source food access atlas 2019
Reading
This is the 'Read Me' sheet from the USDA Food Access Research Atlas 2019 download, not an analytical dataset. It contains just 7 rows in a single column of free-text notes describing the workbook's contents, source URL, and release history. Each row is unique, so there is nothing to aggregate or model here. Treat this sheet as documentation and pivot to the sibling sheets (the variable lookup and the main data table) for actual analysis.
citing: row_count · column_count · columns[0].n_unique · columns[0].null_rate · columns[0].top_value · columns[0].alerts
Charts the summary said to look at first
Show data table
| value | count | share |
|---|---|---|
| This file contains multiple spreadsheets: | 1 | 14.3% |
| 1. A variable lookup that provides explanatory names for all Food Access Research Atlas variables. | 1 | 14.3% |
| 2. A table of all Food Access Research Atlas Data. | 1 | 14.3% |
| 3. Data explanations and data sources are on the Food Access Research Atlas data and documentation download page: | 1 | 14.3% |
| https://www.ers.usda.gov/data-products/food-access-research-atlas/download-the-data/ | 1 | 14.3% |
| Release history: | 1 | 14.3% |
| Initial release: April 2021 | 1 | 14.3% |
Schema
1 columns| Alerts | ||||
|---|---|---|---|---|
| Notes about the Food Access Research Atlas download data: | categorical | 0.0% | 7 |
long_tail
|
Notes about the Food Access Research Atlas download data:
categorical metadata long_tailThis isn't a real data column — it's the README/preamble lines from the Food Access Research Atlas download, captured as 7 unique rows including 'This file contains multiple spreadsheets:', a USDA URL, and 'Initial release: April 2021'. Each of the 7 values appears exactly once (entropy_ratio 1.0), confirming it's documentation text rather than observations. The column header itself ('Notes about the Food Access Research Atlas download data:') is a sentence, which is a strong tell that the spreadsheet was loaded with the wrong header row. Treatment: Drop this column and reload the source file skipping the preamble rows so the true header is used.
- n
- 7
- nulls
- 0 (0.0%)
- unique
- 7
- top_value
- This file contains multiple spreadsheets:
- top_rate
- 0.1429
- cardinality
- 7
- entropy
- 2.807
- entropy_ratio
- 1