us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
5 rows where division_id = 0
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
1 | 1 | 0 | 0 | 0 | United States | 328239523 |
2 | 2 | 1 | 0 | 0 | Northeast Region | 55982803 |
3 | 3 | 2 | 0 | 0 | Midwest Region | 68329004 |
4 | 4 | 3 | 0 | 0 | South Region | 125580448 |
5 | 5 | 4 | 0 | 0 | West Region | 78347268 |
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 );