us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
5 rows where division_id = 3 and region_id = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
19 | 19 | 2 | 3 | 17 | Illinois | 12671821 |
20 | 20 | 2 | 3 | 18 | Indiana | 6732219 |
28 | 28 | 2 | 3 | 26 | Michigan | 9986857 |
41 | 41 | 2 | 3 | 39 | Ohio | 11689100 |
55 | 55 | 2 | 3 | 55 | Wisconsin | 5822434 |
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 );