us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
6 rows where division_id = 1
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
12 | 12 | 1 | 1 | 9 | Connecticut | 3565287 |
25 | 25 | 1 | 1 | 23 | Maine | 1344212 |
27 | 27 | 1 | 1 | 25 | Massachusetts | 6892503 |
35 | 35 | 1 | 1 | 33 | New Hampshire | 1359711 |
45 | 45 | 1 | 1 | 44 | Rhode Island | 1059361 |
51 | 51 | 1 | 1 | 50 | Vermont | 623989 |
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 );