Note: This site is currently "Under construction". I'm migrating to a new version of my site building software. Lots of things are in a state of disrepair as a result (for example, footnote links aren't working). It's all part of the process of building in public. Most things should still be readable though.

U.S. State Capitals XML Example Data

Code

<?xml version="1.0" encoding="UTF-8"?>
<state_details generated="2015-03-10T13:09:42-05:00" source="Wikipedia">
  <overviews>
    <state_overview name="Alabama" abbreviation="AL" statehood="1819">
      <capital city_name="Montgomery" capital_since="1846">
        <population municipal="205,764" metropolitan="374,536" />
      </capital>
    </state_overview>

    <state_overview name="Alaska" abbreviation="AK" statehood="1959">
      <capital city_name="Juneau" capital_since="1906">
        <population municipal="31,275" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="Arizona" abbreviation="AZ" statehood="1912">
      <capital city_name="Phoenix" capital_since="1889">
        <population municipal="1,445,632" metropolitan="4,192,887" />
      </capital>
    </state_overview>

    <state_overview name="Arkansas" abbreviation="AR" statehood="1836">
      <capital city_name="Little Rock" capital_since="1821">
        <population municipal="193,524" metropolitan="877,091" />
      </capital>
    </state_overview>

    <state_overview name="California" abbreviation="CA" statehood="1850">
      <capital city_name="Sacramento" capital_since="1854">
        <population municipal="466,488" metropolitan="2,527,123" />
      </capital>
    </state_overview>

    <state_overview name="Colorado" abbreviation="CO" statehood="1876">
      <capital city_name="Denver" capital_since="1867">
        <population municipal="600,158" metropolitan="2,552,195" />
      </capital>
    </state_overview>

    <state_overview name="Connecticut" abbreviation="CT" statehood="1788">
      <capital city_name="Hartford" capital_since="1875">
        <population municipal="124,512" metropolitan="1,212,381" />
      </capital>
    </state_overview>

    <state_overview name="Delaware" abbreviation="DE" statehood="1787">
      <capital city_name="Dover" capital_since="1777">
        <population municipal="36,047" metropolitan="162,310" />
      </capital>
    </state_overview>

    <state_overview name="Florida" abbreviation="FL" statehood="1845">
      <capital city_name="Tallahassee" capital_since="1824">
        <population municipal="181,412" metropolitan="367,413" />
      </capital>
    </state_overview>

    <state_overview name="Georgia" abbreviation="GA" statehood="1788">
      <capital city_name="Atlanta" capital_since="1868">
        <population municipal="420,003" metropolitan="5,268,860" />
      </capital>
    </state_overview>

    <state_overview name="Hawaii" abbreviation="HI" statehood="1959">
      <capital city_name="Honolulu" capital_since="1845">
        <population municipal="337,256" metropolitan="953,207" />
      </capital>
    </state_overview>

    <state_overview name="Idaho" abbreviation="ID" statehood="1890">
      <capital city_name="Boise" capital_since="1865">
        <population municipal="205,671" metropolitan="616,561" />
      </capital>
    </state_overview>

    <state_overview name="Illinois" abbreviation="IL" statehood="1818">
      <capital city_name="Springfield" capital_since="1837">
        <population municipal="116,250" metropolitan="208,182" />
      </capital>
    </state_overview>

    <state_overview name="Indiana" abbreviation="IN" statehood="1816">
      <capital city_name="Indianapolis" capital_since="1825">
        <population municipal="829,718" metropolitan="1,756,221" />
      </capital>
    </state_overview>

    <state_overview name="Iowa" abbreviation="IA" statehood="1846">
      <capital city_name="Des Moines" capital_since="1857">
        <population municipal="203,433" metropolitan="580,255" />
      </capital>
    </state_overview>

    <state_overview name="Kansas" abbreviation="KS" statehood="1861">
      <capital city_name="Topeka" capital_since="1856">
        <population municipal="127,473" metropolitan="230,824" />
      </capital>
    </state_overview>

    <state_overview name="Kentucky" abbreviation="KY" statehood="1792">
      <capital city_name="Frankfort" capital_since="1792">
        <population municipal="25,527" metropolitan="70,758" />
      </capital>
    </state_overview>

    <state_overview name="Louisiana" abbreviation="LA" statehood="1812">
      <capital city_name="Baton Rouge" capital_since="1880">
        <population municipal="229,553" metropolitan="802,484" />
      </capital>
    </state_overview>

    <state_overview name="Maine" abbreviation="ME" statehood="1820">
      <capital city_name="Augusta" capital_since="1832">
        <population municipal="19,136" metropolitan="117,114" />
      </capital>
    </state_overview>

    <state_overview name="Maryland" abbreviation="MD" statehood="1788">
      <capital city_name="Annapolis" capital_since="1694">
        <population municipal="38,394" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="Massachusetts" abbreviation="MA" statehood="1788">
      <capital city_name="Boston" capital_since="1630">
        <population municipal="617,594" metropolitan="4,522,858" />
      </capital>
    </state_overview>

    <state_overview name="Michigan" abbreviation="MI" statehood="1837">
      <capital city_name="Lansing" capital_since="1847">
        <population municipal="114,297" metropolitan="464,036" />
      </capital>
    </state_overview>

    <state_overview name="Minnesota" abbreviation="MN" statehood="1858">
      <capital city_name="Saint Paul" capital_since="1849">
        <population municipal="285,068" metropolitan="3,502,891" />
      </capital>
    </state_overview>

    <state_overview name="Mississippi" abbreviation="MS" statehood="1817">
      <capital city_name="Jackson" capital_since="1821">
        <population municipal="173,514" metropolitan="539,057" />
      </capital>
    </state_overview>

    <state_overview name="Missouri" abbreviation="MO" statehood="1821">
      <capital city_name="Jefferson City" capital_since="1826">
        <population municipal="43,079" metropolitan="149,807" />
      </capital>
    </state_overview>

    <state_overview name="Montana" abbreviation="MT" statehood="1889">
      <capital city_name="Helena" capital_since="1875">
        <population municipal="28,190" metropolitan="74,801" />
      </capital>
    </state_overview>

    <state_overview name="Nebraska" abbreviation="NE" statehood="1867">
      <capital city_name="Lincoln" capital_since="1867">
        <population municipal="258,379" metropolitan="302,157" />
      </capital>
    </state_overview>

    <state_overview name="Nevada" abbreviation="NV" statehood="1864">
      <capital city_name="Carson City" capital_since="1861">
        <population municipal="55,274" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="New Hampshire" abbreviation="NH" statehood="1788">
      <capital city_name="Concord" capital_since="1808">
        <population municipal="42,695" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="New Jersey" abbreviation="NJ" statehood="1787">
      <capital city_name="Trenton" capital_since="1784">
        <population municipal="84,913" metropolitan="366,513" />
      </capital>
    </state_overview>

    <state_overview name="New Mexico" abbreviation="NM" statehood="1912">
      <capital city_name="Santa Fe" capital_since="1610">
        <population municipal="75,764" metropolitan="183,732" />
      </capital>
    </state_overview>

    <state_overview name="New York" abbreviation="NY" statehood="1788">
      <capital city_name="Albany" capital_since="1797">
        <population municipal="97,856" metropolitan="857,592" />
      </capital>
    </state_overview>

    <state_overview name="North Carolina" abbreviation="NC" statehood="1789">
      <capital city_name="Raleigh" capital_since="1792">
        <population municipal="403,892" metropolitan="1,130,490" />
      </capital>
    </state_overview>

    <state_overview name="North Dakota" abbreviation="ND" statehood="1889">
      <capital city_name="Bismarck" capital_since="1883">
        <population municipal="61,272" metropolitan="108,779" />
      </capital>
    </state_overview>

    <state_overview name="Ohio" abbreviation="OH" statehood="1803">
      <capital city_name="Columbus" capital_since="1816">
        <population municipal="822,553" metropolitan="1,967,066" />
      </capital>
    </state_overview>

    <state_overview name="Oklahoma" abbreviation="OK" statehood="1907">
      <capital city_name="Oklahoma City" capital_since="1910">
        <population municipal="580,000" metropolitan="1,252,987" />
      </capital>
    </state_overview>

    <state_overview name="Oregon" abbreviation="OR" statehood="1859">
      <capital city_name="Salem" capital_since="1855">
        <population municipal="154,637" metropolitan="390,738" />
      </capital>
    </state_overview>

    <state_overview name="Pennsylvania" abbreviation="PA" statehood="1787">
      <capital city_name="Harrisburg" capital_since="1812">
        <population municipal="49,528" metropolitan="647,390" />
      </capital>
    </state_overview>

    <state_overview name="Rhode Island" abbreviation="RI" statehood="1790">
      <capital city_name="Providence" capital_since="1900">
        <population municipal="178,042" metropolitan="1,630,956" />
      </capital>
    </state_overview>

    <state_overview name="South Carolina" abbreviation="SC" statehood="1788">
      <capital city_name="Columbia" capital_since="1786">
        <population municipal="131,686" metropolitan="913,797" />
      </capital>
    </state_overview>

    <state_overview name="South Dakota" abbreviation="SD" statehood="1889">
      <capital city_name="Pierre" capital_since="1889">
        <population municipal="13,646" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="Tennessee" abbreviation="TN" statehood="1796">
      <capital city_name="Nashville" capital_since="1826">
        <population municipal="635,710" metropolitan="1,582,264" />
      </capital>
    </state_overview>

    <state_overview name="Texas" abbreviation="TX" statehood="1845">
      <capital city_name="Austin" capital_since="1839">
        <population municipal="790,390" metropolitan="1,716,291" />
      </capital>
    </state_overview>

    <state_overview name="Utah" abbreviation="UT" statehood="1896">
      <capital city_name="Salt Lake City" capital_since="1858">
        <population municipal="186,440" metropolitan="1,124,197" />
      </capital>
    </state_overview>

    <state_overview name="Vermont" abbreviation="VT" statehood="1791">
      <capital city_name="Montpelier" capital_since="1805">
        <population municipal="7,855" metropolitan="" />
      </capital>
    </state_overview>

    <state_overview name="Virginia" abbreviation="VA" statehood="1788">
      <capital city_name="Richmond" capital_since="1780">
        <population municipal="204,214" metropolitan="1,231,675" />
      </capital>
    </state_overview>

    <state_overview name="Washington" abbreviation="WA" statehood="1889">
      <capital city_name="Olympia" capital_since="1853">
        <population municipal="46,478" metropolitan="234,670" />
      </capital>
    </state_overview>

    <state_overview name="West Virginia" abbreviation="WV" statehood="1863">
      <capital city_name="Charleston" capital_since="1885">
        <population municipal="51,400" metropolitan="304,214" />
      </capital>
    </state_overview>

    <state_overview name="Wisconsin" abbreviation="WI" statehood="1848">
      <capital city_name="Madison" capital_since="1838">
        <population municipal="233,209" metropolitan="561,505" />
      </capital>
    </state_overview>

    <state_overview name="Wyoming" abbreviation="WY" statehood="1890">
      <capital city_name="Cheyenne" capital_since="1869">
        <population municipal="59,466" metropolitan="91,738" />
      </capital>
    </state_overview>
  </overviews>
</state_details>