Database
API Playground
Get Started
Issues
ContributorsThis is a dataset will all US states. You can access the list via an GraphQL API of download it via JSON format.
| capital | capitals | createdAt | established | flag | landAreaSquareKilometers | landAreaSquareMiles | largestCity | link | name | numberRepresentatives | objectId | population | postalAbreviation | totalAreaSquareKilometers | totalAreaSquareMiles | updatedAt | waterAreaSquareKilometers | waterAreaSquareMiles |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |