Infrastructure Jobs: payroll-states.csv

Table actions

This table contains data behind the story Using Infrastructure Jobs as a Measuring Stick For State-Level Spending.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

53 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ state_code state_name
1 1 1 Alabama
2 2 2 Alaska
3 3 4 Arizona
4 4 5 Arkansas
5 5 6 California
6 6 8 Colorado
7 7 9 Connecticut
8 8 10 Delaware
9 9 11 District of Columbia
10 10 12 Florida
11 11 13 Georgia
12 12 15 Hawaii
13 13 16 Idaho
14 14 17 Illinois
15 15 18 Indiana
16 16 19 Iowa
17 17 20 Kansas
18 18 21 Kentucky
19 19 22 Louisiana
20 20 23 Maine
21 21 24 Maryland
22 22 25 Massachusetts
23 23 26 Michigan
24 24 27 Minnesota
25 25 28 Mississippi
26 26 29 Missouri
27 27 30 Montana
28 28 31 Nebraska
29 29 32 Nevada
30 30 33 New Hampshire
31 31 34 New Jersey
32 32 35 New Mexico
33 33 36 New York
34 34 37 North Carolina
35 35 38 North Dakota
36 36 39 Ohio
37 37 40 Oklahoma
38 38 41 Oregon
39 39 42 Pennsylvania
40 40 44 Rhode Island
41 41 45 South Carolina
42 42 46 South Dakota
43 43 47 Tennessee
44 44 48 Texas
45 45 49 Utah
46 46 50 Vermont
47 47 51 Virginia
48 48 53 Washington
49 49 54 West Virginia
50 50 55 Wisconsin
51 51 56 Wyoming
52 52 72 Puerto Rico
53 53 78 Virgin Islands

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "infrastructure-jobs/payroll-states" (
"state_code" INTEGER,
  "state_name" TEXT
);