Database
API Playground
Get Started
Issues
ContributorsA dataset with all USA States. You can consume the data and retrieve cities via APIs (GraphQL) or clone the database and extract the data in JSON.
| ACL | capital | createdAt | established | landAreaSquareKilometers | landAreaSquareMiles | largestCity | name | numberRepresentatives | objectId | population | postalAbreviation | totalAreaSquareKilometers | totalAreaSquareMiles | updatedAt | waterAreaSquareKilometers | waterAreaSquareMiles |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
(undefined) | Montgomery | 2019-12-11T12:37:58.497Z | Dec 14, 1819 | 131171 | 50645 | Birmingham | Alabama | 7 | opo6B57pvA | 4874747 | AL | 135767 | 52420 | 2019-12-11T12:37:58.497Z | 4597 | 1775 |
(undefined) | Juneau | 2019-12-11T12:37:58.916Z | Jan 3, 1959 | 1477953 | 570641 | Anchorage | Alaska | 1 | EsQf83wAdn | 739795 | AK | 1723337 | 665384 | 2019-12-11T12:37:58.916Z | 245384 | 94743 |
(undefined) | Phoenix | 2019-12-11T12:37:59.188Z | Feb 14, 1912 | 294207 | 113594 | Phoenix | Arizona | 9 | 8enbDj7PMY | 7016270 | AZ | 295234 | 113990 | 2019-12-11T12:37:59.188Z | 1026 | 396 |
(undefined) | Little Rock | 2019-12-11T12:37:59.459Z | Jun 15, 1836 | 134771 | 52035 | Little Rock | Arkansas | 4 | egMJvGAYYI | 3004279 | AR | 137732 | 53179 | 2019-12-11T12:37:59.459Z | 2961 | 1143 |
(undefined) | Sacramento | 2019-12-11T12:37:59.731Z | Sep 9, 1850 | 403466 | 155779 | Los Angeles | California | 53 | n0CFSAKZ7z | 39536653 | CA | 423967 | 163695 | 2019-12-11T12:37:59.731Z | 20501 | 7916 |
(undefined) | Denver | 2019-12-11T12:38:00.005Z | Aug 1, 1876 | 268431 | 103642 | Denver | Colorado | 7 | XemvdXRj0L | 5607154 | CO | 269601 | 104094 | 2019-12-11T12:38:00.005Z | 1170 | 452 |
(undefined) | Hartford | 2019-12-11T12:38:00.276Z | Jan 9, 1788 | 12542 | 4842 | Bridgeport | Connecticut | 5 | tC3LV8KpB4 | 3588184 | CT | 14357 | 5543 | 2019-12-11T12:38:00.276Z | 1816 | 701 |
(undefined) | Dover | 2019-12-11T12:38:00.560Z | Dec 7, 1787 | 5047 | 1949 | Wilmington | Delaware | 1 | jM3n2Rl4nc | 961939 | DE | 6446 | 2489 | 2019-12-11T12:38:00.560Z | 1399 | 540 |
(undefined) | Tallahassee | 2019-12-11T12:38:00.833Z | Mar 3, 1845 | 138887 | 53625 | Jacksonville | Florida | 27 | S5QgTkXtsl | 20984400 | FL | 170312 | 65758 | 2019-12-11T12:38:00.833Z | 31424 | 12133 |
(undefined) | Atlanta | 2019-12-11T12:38:01.104Z | Jan 2, 1788 | 148959 | 57513 | Atlanta | Georgia | 14 | 36t3FG30Cw | 10429379 | GA | 153910 | 59425 | 2019-12-11T12:38:01.104Z | 4951 | 1912 |
(undefined) | Honolulu | 2019-12-11T12:38:01.377Z | Aug 21, 1959 | 16635 | 6423 | Honolulu | Hawaii | 2 | 99Odvp6TuS | 1427538 | HI | 28313 | 10932 | 2019-12-11T12:38:01.377Z | 11678 | 4509 |
(undefined) | Boise | 2019-12-11T12:38:01.648Z | Jul 3, 1890 | 214045 | 82643 | Boise | Idaho | 2 | VIBTGLXWAs | 1716943 | ID | 216443 | 83569 | 2019-12-11T12:38:01.648Z | 2398 | 926 |
(undefined) | Springfield | 2019-12-11T12:38:01.920Z | Dec 3, 1818 | 143793 | 55519 | Chicago | Illinois | 18 | IdZoq8ZfsG | 12802023 | IL | 149995 | 57914 | 2019-12-11T12:38:01.920Z | 6202 | 2395 |
(undefined) | Indianapolis | 2019-12-11T12:38:02.192Z | Dec 11, 1816 | 92789 | 35826 | Indianapolis | Indiana | 9 | EhyjmgGokx | 6666818 | IN | 94326 | 36420 | 2019-12-11T12:38:02.192Z | 1537 | 593 |
(undefined) | Des Moines | 2019-12-11T12:38:02.464Z | Dec 28, 1846 | 144669 | 55857 | Des Moines | Iowa | 4 | vrOCmmXATc | 3145711 | IA | 145746 | 56273 | 2019-12-11T12:38:02.464Z | 1077 | 416 |
(undefined) | Topeka | 2019-12-11T12:38:02.732Z | Jan 29, 1861 | 211754 | 81759 | Wichita | Kansas | 4 | 9pPmUBeYDm | 2913123 | KS | 213100 | 82278 | 2019-12-11T12:38:02.732Z | 1346 | 520 |
(undefined) | Frankfort | 2019-12-11T12:38:02.969Z | Jun 1, 1792 | 102269 | 39486 | Louisville | Kentucky | 6 | LF22chhxzQ | 4454189 | KY | 104656 | 40408 | 2019-12-11T12:38:02.969Z | 2387 | 921 |
(undefined) | Baton Rouge | 2019-12-11T12:38:03.244Z | Apr 30, 1812 | 111898 | 43204 | New Orleans | Louisiana | 6 | 6hCWq2CnpH | 4684333 | LA | 135659 | 52378 | 2019-12-11T12:38:03.244Z | 23761 | 9174 |
(undefined) | Augusta | 2019-12-11T12:38:03.520Z | Mar 15, 1820 | 79883 | 30843 | Portland | Maine | 2 | zz5CncDtzP | 1335907 | ME | 91633 | 35380 | 2019-12-11T12:38:03.520Z | 11750 | 4537 |
(undefined) | Annapolis | 2019-12-11T12:38:03.797Z | Apr 28, 1788 | 25142 | 9707 | Baltimore | Maryland | 8 | xff1jBOJOA | 6052177 | MD | 32131 | 12406 | 2019-12-11T12:38:03.797Z | 6990 | 2699 |