ryanwaked.com · data warehouse
Every number on this site has a paper trail.
The datasets behind the analyses, each documented with its schema, provenance, governance, and where it is used. Search for a dataset, a column, or a source.
Datasets
4
Domains
3
Analyses fed
2
Source links
8
Personal data
0fields
access
domain
SELECT handle, dataset, access, rows
FROM waked.catalog ORDER BY handle;
datasetaccessrows
cdc_places_county
County health measures (CDC PLACES)
Model-based small-area estimates of chronic disease, prevention, health status, disability, and health-related social needs for U.S. counties, from the CDC PLACES program (BRFSS responses modeled onto ACS demographics). Pulled here for all U.S. states and territories; public aggregates, with no personal data.
Grain
county × measure × year
Rows
229,298 rows
Coverage
52 states & territories · 6 measure categories · 40 measures · 2022–2023
Domain
public health
Updated
Refreshed Jun 30, 2026
Format
duckdb
Downloadstatic file · no warehouse query
| Column | Type | Description |
|---|---|---|
| yearKEY | text | Reporting year of the estimate |
| stateabbr | text | State (USPS abbreviation) |
| statedesc | text | State name |
| locationnameKEY | text | County name |
| datasource | text | Upstream data source for the estimate (e.g. BRFSS) |
| category | text | Measure category (e.g. Health Outcomes, Prevention) |
| measure | text | Full name of the health measure |
| data_value_unit | text | Unit of the value (typically percent) |
| data_value_type | text | What the value represents (e.g. age-adjusted prevalence) |
| data_value | text | Estimated value for the measure |
| low_confidence_limit | text | Lower bound of the 95% interval |
| high_confidence_limit | text | Upper bound of the 95% interval |
| totalpopulation | text | County total population |
| totalpop18plus | text | County population aged 18 and older |
| locationid | text | County FIPS code |
| categoryid | text | Stable measure-category identifier |
| measureidKEY | text | Stable measure identifier |
| datavaluetypeid | text | Stable identifier for the value type |
| short_question_text | text | Short label for the measure |
| geolocation | json | County centroid as a point (type and coordinates) |
| data_value_footnote_symbol | text | Symbol flagging an annotated value |
| data_value_footnote | text | Footnote text, e.g. a data-suppression note |
Used inMajor US Metros QOL ↗
Governance
Data charter
The rules every dataset above is held to.
01 /
Provenance is stated, not implied
Every dataset names its origin and its vintage. If a series was interpolated, reweighted, or deflated, the step is in the lineage below, not hidden in a notebook.
02 /
Uncertainty travels with the estimate
Intervals are reported alongside every headline number and never dropped for a cleaner sentence. An interval crossing zero is allowed to kill a claim.
03 /
No personal data leaves the pipeline
Identifiers are salted-hashed or removed before analysis. Nothing published here is keyed to a person; only aggregates and derived tables are released.
04 /
Licensed data stays licensed
Datasets obtained under provider terms are documented but never redistributed. Where a source restricts republication, only its schema, provenance, and derived results are shown here.
05 /
Reproducible or it didn't happen
Each dataset carries a dictionary, a notebook reference, and a refresh cadence. If the source can't be re-pulled, the derived table that can is what ships.