📥 Export to Excel (CSV) ⚙ Advanced filters

stateconst

84 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: countryConstID

id ▼ code countryConstID name
1 ZZ 1 Unknown
2 AL 2 Alabama
3 AK 2 Alaska
4 AZ 2 Arizona
5 AR 2 Arkansas
6 CA 2 California
7 CO 2 Colorado
8 CT 2 Connecticut
9 DE 2 Delaware
10 DC 2 District of Columbia
11 FL 2 Florida
12 GA 2 Georgia
13 GU 2 Guam
14 HI 2 Hawaii
15 ID 2 Idaho
16 IL 2 Illinois
17 IN 2 Indiana
18 IA 2 Iowa
19 KS 2 Kansas
20 KY 2 Kentucky
21 LA 2 Louisiana
22 ME 2 Maine
23 MD 2 Maryland
24 MA 2 Massachusetts
25 MI 2 Michigan
26 MN 2 Minnesota
27 MS 2 Mississippi
28 MO 2 Missouri
29 MT 2 Montana
30 NE 2 Nebraska
31 NV 2 Nevada
32 NH 2 New Hampshire
33 NJ 2 New Jersey
34 NM 2 New Mexico
35 NY 2 New York
36 NC 2 North Carolina
37 ND 2 North Dakota
38 MP 2 Northern Marina Islands
39 OH 2 Ohio
40 OK 2 Oklahoma
41 OR 2 Oregon
42 PA 2 Pennsylvania
43 RI 2 Rhode Island
44 SC 2 South Carolina
45 SD 2 South Dakota
46 TN 2 Tennessee
47 TX 2 Texas
48 UT 2 Utah
49 VT 2 Vermont
50 VA 2 Virginia

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "stateconst" (
 "id" INTEGERNOT NULL ,
 "code" TEXT NOT NULL,
 "countryConstID" INTEGERNOT NULL,
 "name" TEXT NOT NULL,
 PRIMARY KEY ("id")
);