us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
5 rows where division_id = 9
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
7 | 7 | 4 | 9 | 2 | Alaska | 731545 |
10 | 10 | 4 | 9 | 6 | California | 39512223 |
17 | 17 | 4 | 9 | 15 | Hawaii | 1415872 |
43 | 43 | 4 | 9 | 41 | Oregon | 4217737 |
53 | 53 | 4 | 9 | 53 | Washington | 7614893 |
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 );