The Database Hub | Back4App
The Database Hub | Back4App
How it works
  • Log In
  • Sign Up

  1. Back4App
  2. USStates + Capitals
Public

10
10
10
10
  • DatabaseDatabase
  • GraphQL API PlaygroundAPI Playground
  • Get Started GuideGet Started
  • IssuesIssues
  • ContributorsContributors
  • GraphQL API Playground
    API Playground
    Get Started Guide
    Get Started
    Issues
    Issues
    Contributors
    Contributors

  1. USStates + Capitals
  2. States

This is a dataset will all US states. You can access the list via an GraphQL API of download it via JSON format.


DataSchema
Get StartedFetch Data
capitalcapitalscreatedAtestablishedflaglandAreaSquareKilometerslandAreaSquareMileslargestCitylinknamenumberRepresentativesobjectIdpopulationpostalAbreviationtotalAreaSquareKilometerstotalAreaSquareMilesupdatedAtwaterAreaSquareKilometerswaterAreaSquareMiles
Montgomery
Montgomery
2019-12-06T19:36:50.117Z
Dec 14, 1819
https://upload.wikimedia.org/wikipedia/commons/thumb/5/5c/Flag_of_Alabama.svg/23px-Flag_of_Alabama.svg.png
131171
50645
Birmingham
/wiki/Alabama
Alabama
7
B9IfALchYP
4874747
AL
135767
52420
2019-12-09T23:20:36.439Z
4597
1775
Juneau
Juneau
2019-12-06T19:36:50.597Z
Jan 3, 1959
https://upload.wikimedia.org/wikipedia/commons/thumb/e/e6/Flag_of_Alaska.svg/21px-Flag_of_Alaska.svg.png
1477953
570641
Anchorage
/wiki/Alaska
Alaska
1
zq8GVoD1n0
739795
AK
1723337
665384
2019-12-09T23:20:25.520Z
245384
94743
Phoenix
Phoenix
2019-12-06T19:36:50.877Z
Feb 14, 1912
https://upload.wikimedia.org/wikipedia/commons/thumb/9/9d/Flag_of_Arizona.svg/23px-Flag_of_Arizona.svg.png
294207
113594
Phoenix
/wiki/Arizona
Arizona
9
9DhrhBxbKN
7016270
AZ
295234
113990
2019-12-09T23:18:34.311Z
1026
396
Little Rock
Little Rock
2019-12-06T19:36:51.153Z
Jun 15, 1836
https://upload.wikimedia.org/wikipedia/commons/thumb/9/9d/Flag_of_Arkansas.svg/23px-Flag_of_Arkansas.svg.png
134771
52035
Little Rock
/wiki/Arkansas
Arkansas
4
UGNHGooffs
3004279
AR
137732
53179
2019-12-09T23:16:24.718Z
2961
1143
Sacramento
Sacramento
2019-12-06T19:36:51.430Z
Sep 9, 1850
https://upload.wikimedia.org/wikipedia/commons/thumb/0/01/Flag_of_California.svg/23px-Flag_of_California.svg.png
403466
155779
Los Angeles
/wiki/California
California
53
ta1PtZdnvM
39536653
CA
423967
163695
2019-12-09T23:20:09.986Z
20501
7916
Denver
Denver
2019-12-06T19:36:51.710Z
Aug 1, 1876
https://upload.wikimedia.org/wikipedia/commons/thumb/4/46/Flag_of_Colorado.svg/23px-Flag_of_Colorado.svg.png
268431
103642
Denver
/wiki/Colorado
Colorado
7
kqgijwmz3F
5607154
CO
269601
104094
2019-12-09T23:19:59.544Z
1170
452
Hartford
Hartford[5]
2019-12-06T19:36:51.988Z
Jan 9, 1788
https://upload.wikimedia.org/wikipedia/commons/thumb/9/96/Flag_of_Connecticut.svg/20px-Flag_of_Connecticut.svg.png
12542
4842
Bridgeport
/wiki/Connecticut
Connecticut
5
PTVrvM8ICm
3588184
CT
14357
5543
2019-12-09T23:18:18.193Z
1816
701
Dover
Dover
2019-12-06T19:36:52.257Z
Dec 7, 1787
https://upload.wikimedia.org/wikipedia/commons/thumb/c/c6/Flag_of_Delaware.svg/23px-Flag_of_Delaware.svg.png
5047
1949
Wilmington
/wiki/Delaware
Delaware
1
QHfmLFQmHn
961939
DE
6446
2489
2019-12-09T23:16:39.680Z
1399
540
Tallahassee
Tallahassee
2019-12-06T19:36:52.530Z
Mar 3, 1845
https://upload.wikimedia.org/wikipedia/commons/thumb/f/f7/Flag_of_Florida.svg/23px-Flag_of_Florida.svg.png
138887
53625
Jacksonville
/wiki/Florida
Florida
27
AGUxGMhElY
20984400
FL
170312
65758
2019-12-09T23:19:26.903Z
31424
12133
Atlanta
Atlanta
2019-12-06T19:36:52.804Z
Jan 2, 1788
https://upload.wikimedia.org/wikipedia/commons/thumb/5/54/Flag_of_Georgia_%28U.S._state%29.svg/23px-Flag_of_Georgia_%28U.S._state%29.svg.png
148959
57513
Atlanta
/wiki/Georgia_(U.S._state)
Georgia
14
OvvlXkfRk1
10429379
GA
153910
59425
2019-12-09T23:19:00.528Z
4951
1912
Honolulu
Honolulu
2019-12-06T19:36:53.076Z
Aug 21, 1959
https://upload.wikimedia.org/wikipedia/commons/thumb/e/ef/Flag_of_Hawaii.svg/23px-Flag_of_Hawaii.svg.png
16635
6423
Honolulu
/wiki/Hawaii
Hawaii
2
CSEJeVNqVB
1427538
HI
28313
10932
2019-12-09T23:17:10.856Z
11678
4509
Boise
Boise
2019-12-06T19:36:53.352Z
Jul 3, 1890
https://upload.wikimedia.org/wikipedia/commons/thumb/a/a4/Flag_of_Idaho.svg/19px-Flag_of_Idaho.svg.png
214045
82643
Boise
/wiki/Idaho
Idaho
2
UYuF6PSOyg
1716943
ID
216443
83569
2019-12-09T23:16:55.251Z
2398
926
Springfield
Springfield
2019-12-06T19:36:53.625Z
Dec 3, 1818
https://upload.wikimedia.org/wikipedia/commons/thumb/0/01/Flag_of_Illinois.svg/23px-Flag_of_Illinois.svg.png
143793
55519
Chicago
/wiki/Illinois
Illinois
18
cU9BokMx6a
12802023
IL
149995
57914
2019-12-09T23:18:01.981Z
6202
2395
Indianapolis
Indianapolis
2019-12-06T19:36:53.908Z
Dec 11, 1816
https://upload.wikimedia.org/wikipedia/commons/thumb/a/ac/Flag_of_Indiana.svg/23px-Flag_of_Indiana.svg.png
92789
35826
Indianapolis
/wiki/Indiana
Indiana
9
qOsTmj31Ru
6666818
IN
94326
36420
2019-12-09T23:18:48.420Z
1537
593
Des Moines
Des Moines
2019-12-06T19:36:54.181Z
Dec 28, 1846
https://upload.wikimedia.org/wikipedia/commons/thumb/a/aa/Flag_of_Iowa.svg/23px-Flag_of_Iowa.svg.png
144669
55857
Des Moines
/wiki/Iowa
Iowa
4
LyB0T2rFBy
3145711
IA
145746
56273
2019-12-09T23:19:12.152Z
1077
416
Topeka
Topeka
2019-12-06T19:36:54.467Z
Jan 29, 1861
https://upload.wikimedia.org/wikipedia/commons/thumb/d/da/Flag_of_Kansas.svg/23px-Flag_of_Kansas.svg.png
211754
81759
Wichita
/wiki/Kansas
Kansas
4
CBAeAPHHIx
2913123
KS
213100
82278
2019-12-09T23:19:42.556Z
1346
520
Frankfort
Frankfort
2019-12-06T19:36:54.745Z
Jun 1, 1792
https://upload.wikimedia.org/wikipedia/commons/thumb/8/8d/Flag_of_Kentucky.svg/23px-Flag_of_Kentucky.svg.png
102269
39486
Louisville
/wiki/Kentucky
Kentucky
6
HRLE9LJr0j
4454189
KY
104656
40408
2019-12-09T23:15:49.979Z
2387
921
Baton Rouge
Baton Rouge
2019-12-06T19:36:55.017Z
Apr 30, 1812
https://upload.wikimedia.org/wikipedia/commons/thumb/e/e0/Flag_of_Louisiana.svg/23px-Flag_of_Louisiana.svg.png
111898
43204
New Orleans
/wiki/Louisiana
Louisiana
6
smLZvAGQQS
4684333
LA
135659
52378
2019-12-09T23:16:05.705Z
23761
9174
Augusta
Augusta
2019-12-06T19:36:55.250Z
Mar 15, 1820
https://upload.wikimedia.org/wikipedia/commons/thumb/3/35/Flag_of_Maine.svg/19px-Flag_of_Maine.svg.png
79883
30843
Portland
/wiki/Maine
Maine
2
V5NlanRaRf
1335907
ME
91633
35380
2019-12-09T23:17:46.836Z
11750
4537
Annapolis
Annapolis
2019-12-06T19:36:55.525Z
Apr 28, 1788
https://upload.wikimedia.org/wikipedia/commons/thumb/a/a0/Flag_of_Maryland.svg/23px-Flag_of_Maryland.svg.png
25142
9707
Baltimore
/wiki/Maryland
Maryland
8
FicuFjsF4D
6052177
MD
32131
12406
2019-12-09T23:17:28.328Z
6990
2699