Repository: usds/justice40-tool (language: python)

Issue:
"Number of Tribal areas within Census tract” is blank for all entries in the download file on staging
See here:

https://static-data-screeningtool.geoplatform.gov/data-versions/1.0/data/score/downloadable/1.0-communities.csv


Discussion / hints:
Well that's not supposed to happen. I'll spend an hour tomorrow to see if I can figure out why.
This data point is showing up for me on local runs and showed up in the run merging narwhal into main, so I've rerun the 1.0 release action to see if maybe the branch I ran it on last had a defect that's since been resolved. If not, well, I'll have some really slow debugging to do I guess.
Okay, I was looking at a file too early in the pipeline. We ended up only putting counts for Alaska, so the real field is named "Number of Tribal areas within Census tract for Alaska." The download was pulling from the old, defunct filed that is now all blank since we don't do national counts. I've updated the fieldname in the downloads accordingly (cc @KameronKerger and @katherinedm-usds ) and a PR will be coming shortly with the fix.

Fix patch:
diff --git a/data/data-pipeline/data_pipeline/content/config/csv.yml b/data/data-pipeline/data_pipeline/content/config/csv.yml
index 7444e3647..c25e8ff34 100644
--- a/data/data-pipeline/data_pipeline/content/config/csv.yml
+++ b/data/data-pipeline/data_pipeline/content/config/csv.yml
@@ -395,8 +395,8 @@ fields:
 - score_name: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS education in 2009 (island areas)?
   label: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS education in 2009 (island areas)?
   format: bool
-- score_name: Number of Tribal areas within Census tract
-  label: Number of Tribal areas within Census tract
+- score_name: Number of Tribal areas within Census tract for Alaska
+  label: Number of Tribal areas within Census tract for Alaska
   format: int64
 - score_name: Names of Tribal areas within Census tract
   label: Names of Tribal areas within Census tract
diff --git a/data/data-pipeline/data_pipeline/content/config/excel.yml b/data/data-pipeline/data_pipeline/content/config/excel.yml
index 6c3792604..757477102 100644
--- a/data/data-pipeline/data_pipeline/content/config/excel.yml
+++ b/data/data-pipeline/data_pipeline/content/config/excel.yml
@@ -399,8 +399,8 @@ sheets:
       - score_name: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS education in 2009 (island areas)?
         label: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS education in 2009 (island areas)?
         format: bool
-      - score_name: Number of Tribal areas within Census tract
-        label: Number of Tribal areas within Census tract
+      - score_name: Number of Tribal areas within Census tract for Alaska
+        label: Number of Tribal areas within Census tract for Alaska
         format: int64
       - score_name: Names of Tribal areas within Census tract
         label: Names of Tribal areas within Census tract
diff --git a/data/data-pipeline/data_pipeline/files/readme-version-1.0.md b/data/data-pipeline/data_pipeline/files/readme-version-1.0.md
new file mode 100644
index 000000000..e69de29bb


Test patch:
diff --git a/data/data-pipeline/data_pipeline/etl/score/tests/snapshots/downloadable_data_expected.pkl b/data/data-pipeline/data_pipeline/etl/score/tests/snapshots/downloadable_data_expected.pkl
index fddabc3f5..4b50fff98 100644
Binary files a/data/data-pipeline/data_pipeline/etl/score/tests/snapshots/downloadable_data_expected.pkl and b/data/data-pipeline/data_pipeline/etl/score/tests/snapshots/downloadable_data_expected.pkl differ