us_census_state_populations_2019

Table actions

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

57 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: region_id, division_id

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