us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
7 rows where division_id = 4
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
21 | 21 | 2 | 4 | 19 | Iowa | 3155070 |
22 | 22 | 2 | 4 | 20 | Kansas | 2913314 |
29 | 29 | 2 | 4 | 27 | Minnesota | 5639632 |
31 | 31 | 2 | 4 | 29 | Missouri | 6137428 |
33 | 33 | 2 | 4 | 31 | Nebraska | 1934408 |
40 | 40 | 2 | 4 | 38 | North Dakota | 762062 |
47 | 47 | 2 | 4 | 46 | South Dakota | 884659 |
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 );