us_census_state_populations_2019

Data source: census.gov · About: simonw/covid-19-datasette

57 rows

View and edit SQL

Suggested facets: region_id, division_id

Link rowid ▼ region_id division_id state_id state_name pop_estimate_2019
1 0 0 0 United States 328239523
2 1 0 0 Northeast Region 55982803
3 2 0 0 Midwest Region 68329004
4 3 0 0 South Region 125580448
5 4 0 0 West Region 78347268
6 3 6 1 Alabama 4903185
7 4 9 2 Alaska 731545
8 4 8 4 Arizona 7278717
9 3 7 5 Arkansas 3017804
10 4 9 6 California 39512223
11 4 8 8 Colorado 5758736
12 1 1 9 Connecticut 3565287
13 3 5 10 Delaware 973764
14 3 5 11 District of Columbia 705749
15 3 5 12 Florida 21477737
16 3 5 13 Georgia 10617423
17 4 9 15 Hawaii 1415872
18 4 8 16 Idaho 1787065
19 2 3 17 Illinois 12671821
20 2 3 18 Indiana 6732219
21 2 4 19 Iowa 3155070
22 2 4 20 Kansas 2913314
23 3 6 21 Kentucky 4467673
24 3 7 22 Louisiana 4648794
25 1 1 23 Maine 1344212
26 3 5 24 Maryland 6045680
27 1 1 25 Massachusetts 6892503
28 2 3 26 Michigan 9986857
29 2 4 27 Minnesota 5639632
30 3 6 28 Mississippi 2976149
31 2 4 29 Missouri 6137428
32 4 8 30 Montana 1068778
33 2 4 31 Nebraska 1934408
34 4 8 32 Nevada 3080156
35 1 1 33 New Hampshire 1359711
36 1 2 34 New Jersey 8882190
37 4 8 35 New Mexico 2096829
38 1 2 36 New York 19453561
39 3 5 37 North Carolina 10488084
40 2 4 38 North Dakota 762062
41 2 3 39 Ohio 11689100
42 3 7 40 Oklahoma 3956971
43 4 9 41 Oregon 4217737
44 1 2 42 Pennsylvania 12801989
45 1 1 44 Rhode Island 1059361
46 3 5 45 South Carolina 5148714
47 2 4 46 South Dakota 884659
48 3 6 47 Tennessee 6829174
49 3 7 48 Texas 28995881
50 4 8 49 Utah 3205958
51 1 1 50 Vermont 623989
52 3 5 51 Virginia 8535519
53 4 9 53 Washington 7614893
54 3 5 54 West Virginia 1792147
55 2 3 55 Wisconsin 5822434
56 4 8 56 Wyoming 578759
57     72 Puerto Rico 3193694

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [us_census_state_populations_2019] (
   [region_id] TEXT,
   [division_id] TEXT,
   [state_id] INTEGER,
   [state_name] TEXT,
   [pop_estimate_2019] INTEGER
);
Powered by Datasette · Query took 18.103ms · Data source: census.gov · About: simonw/covid-19-datasette