us_census_state_populations_2019
Data source: census.gov · About: simonw/covid-19-datasette
3 rows where division_id = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | region_id | division_id | state_id | state_name | pop_estimate_2019 |
---|---|---|---|---|---|---|
36 | 36 | 1 | 2 | 34 | New Jersey | 8882190 |
38 | 38 | 1 | 2 | 36 | New York | 19453561 |
44 | 44 | 1 | 2 | 42 | Pennsylvania | 12801989 |
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 );