us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
4 rows where division_id = 6
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
6 | 6 | 3 | 6 | 1 | Alabama | 4903185 |
23 | 23 | 3 | 6 | 21 | Kentucky | 4467673 |
30 | 30 | 3 | 6 | 28 | Mississippi | 2976149 |
48 | 48 | 3 | 6 | 47 | Tennessee | 6829174 |
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 );