us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
8 rows where division_id = 8
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
8 | 8 | 4 | 8 | 4 | Arizona | 7278717 |
11 | 11 | 4 | 8 | 8 | Colorado | 5758736 |
18 | 18 | 4 | 8 | 16 | Idaho | 1787065 |
32 | 32 | 4 | 8 | 30 | Montana | 1068778 |
34 | 34 | 4 | 8 | 32 | Nevada | 3080156 |
37 | 37 | 4 | 8 | 35 | New Mexico | 2096829 |
50 | 50 | 4 | 8 | 49 | Utah | 3205958 |
56 | 56 | 4 | 8 | 56 | Wyoming | 578759 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us_census_state_populations_2019] ( [region_id] TEXT, [division_id] TEXT, [state_id] INTEGER, [state_name] TEXT, [pop_estimate_2019] INTEGER );