DemocracyMap Representatives

County Data

NACO provides national coverage:

• Scraper: https://scraperwiki.com/scrapers/us_county_representatives/
• Source: http://www.uscounties.org/cffiles_web/counties/state.cfm?statecode=MS

City Data By State

Most states have a league of cities or association of cities that publishes representative data for each of its member cities. This list catalogs the sources of such data state by state. Some of this data may also be available within State Blue Books which can be found listed at: http://wikis.ala.org/godort/index.php/State_Blue_Books

Alabama

Representatives:

• Source: http://directory.alalm.org/citysearch.aspx

Alaska

Representatives:

• Print version available for order at : http://www.akml.org/Publications.html

Arizona

Representatives:

• Source: http://www.leagueaz.org/lgd/

Arkansas

Representatives:

• Source: http://local.arkansas.gov/index.php?show=citylist

California

Representatives:

• Source: http://events.cacities.org/CGI-SHL/TWSERVER.EXE/RUN:MEMLOOK
• Scraper: https://scraperwiki.com/scrapers/city_representatives/

Social Media:

• Source: http://www.ca.gov/About/Government/Local/Cities/G_K.html
• Source: http://www.ca.gov/CaSearch/Agencies.aspx
• Source: http://www.ca.gov/Multimedia/multimedia_blogs_twitter.html
• Source: http://www.cacities.org/index.jsp?zone=locc&previewStory=28310
• Source: http://twitter.com/#!/CaCitiesLearn/cacities
• Source: http://totalcapitol.com/?twitter

Colorado

Representatives:

• Source: http://www.cml.org/memberdir/default.aspx

Connecticut

Representatives:

• Print, CD, and online versions available for a fee: http://research.ccm-ct.org/Plugs/municipal-directory.aspx

City URLs:

• Source: http://www.ct.gov/ctportal/cwp/view.asp?a=843&q=257266&ctportalPNavCtr=%7C27610%7C#38191

Delaware

Representatives:

• Source: http://www.ipa.udel.edu/localgovt/dllg/municipalities/index.asp

District of Columbia

• Source: http://www.dccouncil.washington.dc.us/council
• Scraper: https://scraperwiki.com/scrapers/washington_dc_wards_and_councilmembers/

Florida

Representatives:

• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_florida/
• Source: http://www.floridaleagueofcities.com/surveyPeers.aspx

Georgia

Representatives:

• Source: http://www.gmanet.com/Cities.aspx

Hawaii

Idaho

City URLs:

• Source: http://www.idahocities.org/index.aspx?nid=95
• Source: http://www.idaho.gov/aboutidaho/cities.html

Representatives:

• Print version available for order at http://www.idahocities.org/index.aspx?nid=235

Illinois

Representatives:

• Print version available for order at http://www.iml.org/page.cfm?key=2557&parent=1168

Mayors:

• Source (PDF) http://www.cyberdriveillinois.com/publications/illinois_bluebook/incorporated.pdf

Indiana

City URLs:

• Source: http://www.citiesandtowns.org/topic/subtopic.php?fDD=2-6
• Source: http://www.in.gov/mylocal/

Representatives

• Available for order: http://www.citiesandtowns.org/egov/apps/services/index.egov?path=details&action=i&id=110

Iowa

Representatives

• Source: https://www.iowaleague.org/pages/CitiesInIowa.aspx - Uses Silverlight, seems mostly limited to Mayors. Raw XML source that Silverlight points to: https://feed.iowaleague.org/Services/CityMembersService.svc/CRMAccountCities%28%29?$orderby=Name&$expand=CRMOrgCounties,CRMCityMayorsClerks

Kansas

Representatives:

• Source: http://www.lkm.org/directory/

Kentucky

Representatives:

• Source: http://www.klc.org/directory/

Louisiana

Representatives:

• Source: http://www.lma.org/LMA/Municipalities/LMA/Municipalities/Municipality_Directory.aspx

Maine

City Contact Info

• Source: http://www.maine.gov/local/
• Source: http://www.memun.org/dbtw-wpd/textbase/muni/muniQBE.htm

Representatives:

• Can be ordered from http://www2.memun.org/public/mmapub/OrderForm.cfm

Maryland

Seems to be only available as a PDF. See http://www.mdmunicipal.org/index.aspx?NID=110

Representatives

• Source (PDF): http://www.mdmunicipal.org/documentcenter/home/view/702
• Source: http://msa.maryland.gov/msa/mdmanual/01glance/html/mun.html

Massachusetts

City Phone Numbers:

• Source: http://www.sec.state.ma.us/cis/cistel/telidx.htm

City Contact Info:

• Source: http://www.mma.org/community-info

Election Contact Info:

• Source: http://www.sec.state.ma.us/ele/eleclk/clkidx.htm

City URLs:

• Source: http://www.mma.org/city-and-town-web-sites
• Source: http://www.mass.gov/portal/government-taxes/local/cities-towns/cities-and-towns.html

Michigan

City URLs:

• Source: http://www.michigan.gov/som/0,1607,7-192-29701_31713_31714-97070--,00.html
• Source: http://www.mml.org/resources/links/members/a.htm

Township Officials:

• Source: http://www.michigantownships.org/find_a_township.asp

Minnesota

City Information:

• Source: http://www.lmc.org/page/1/city-directory.jsp

Representatives:

• The directory is only available in print and costs $35

Mississippi

Representatives:

• Source: http://www.mmlonline.com/members-cities.aspx

Missouri

Representatives

• Available for $350! http://www.mocities.com/?page=DirMunOfficials

City URLs

• Source: http://www.mo.gov/government/city-county-government/cities-and-municipalities/

Montana

City URLs:

• Source: http://www.mlct.org/members/municipalities.html

Representatives:

• Available for order http://www.msuextension.org/store/Products/Montana-Municipal-Officials-Handbook--First-Edition__4593.aspx

Nebraska

City URLs

• Source: http://www.lonm.org/membership_info/league_members.html

Nevada

Mayors

• Source: http://www.nvleague.org/citymayors.asp

New Hampshire

City URLs:

• Source: http://www.nhlgc.org/resources/municipalities.asp
• Source: http://www.nh.gov/municipal/index.html

New Jersey

OMG Machine Readable Raw Data! See: http://www.state.nj.us/dca/home/mayors.html

Representatives (Mayors only)

• Source: http://www.state.nj.us/dca/home/20120809mayors.csv

New Mexico

Representatives

• Available for order $35 - http://nmml.org/publications/

New York

City URLs

• Source: http://www.nysegov.com/citguide.cfm?context=citguide&content=munibyalpha

Representatives

• Available for order? http://www.nycom.org/mn_pubs/dir_cityvillage_officials/index.asp
• Towns, available for order: http://www.nytowns.org/web/2008/09/publications.aspx

North Carolina

Representatives:

• Source: http://www.nclm.org/resource-center/municipalities/Pages/Default.aspx

North Dakota

Representatives

• Available for order: http://www.ndlc.org/index.aspx?NID=109

Ohio

Representatives:

• Available for order: http://www.omlohio.org/Publications/publications.htm

City URLs

• Source: http://www.omlohio.org/Municipal%20Resources/CVlinks.htm
• Source: http://www.exploreohio.org/node/11452?cat=1805&cty=

Oklahoma

City URLs:

• Source: http://okml.webs.com/apps/links/

Representatives:

• Some listed at http://okml.webs.com/newcertifiedofficials.htm#560517048
• Print copy available for order at http://okml.webs.com/omlpublications.htm and http://fs12.formsite.com/cchristo/form80/index.html

Oregon

Representatives

• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_oregon/
• Source: http://www.orcities.org/CityResources/LOCCityDirectory/CityReportViewer/tabid/6214/language/en-US/Default.aspx

City Contact Info

• Source: http://www.bluebook.state.or.us/local/cities/ad/index.htm

Pennsylvania

Representatives

• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_pennsylvania/
• Source (19mb CSV) http://munstatspa.dced.state.pa.us/ReportViewer.axd?R=LocalOfficial&F=C
• Source http://munstatspa.dced.state.pa.us/EAOReports.aspx?M=L

Puerto Rico

City Contact Info:

• Source: http://www2.pr.gov/Directorios/Pages/DirectoriodeMunicipios.aspx

Rhode Island

City Contact Info:

• Source: http://www.ri.gov/towns/

South Carolina

Representatives

• Source: http://www.masc.sc/municipalities/directory/Pages/by-name.aspx

South Dakota

Representatives

• Available for order: http://www.sdmunicipalleague.org/index.asp?Type=B_BASIC&SEC={5E957446-C492-4183-8408-FA70CE26D0D4}

Tennessee

Representatives:

• Source: http://www.mtas.tennessee.edu/public/web.nsf/Web/Locate+Info

More Info:

• http://www.tn.gov/local

Texas

Representatives:

• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_texas/
• Source: http://www.tml.org/source/Members/TML_Directory.cfm?CITY=A

Utah

City URLs

• Source: http://www.ulct.org/ulct/about/linkstocities.html

Representatives

• Print version available for order at https://secure.utah.gov/ulct-multimedia/item.html

Vermont

OMG Machine Readable Data! See http://www.vlct.org/vermont-local-government/municipal-directory/

Representatives:

• Source: http://www.vlct.org/assets/General/VT_Municipal_Contacts.xls

City Information:

• Source: http://www.vlct.org/assets/General/VT_Cities_and_Towns.xls

Virginia

City URLs:

• Source: http://www.vml.org/Links.html

Washington

Representatives:

• Source: http://www.mrsc.org/cityprofiles/citylist.aspx
• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_washington

West Virginia

Representatives:

• Print version available for order at http://www.wvml.org/resources/municipal-directory.html

Wisconsin

City URLs

• Source: http://www.lwm-info.org/index.asp?SEC=E98A5DA6-F873-4E5B-B258-3C634571EBC4&Type=B_BASIC
• Source: http://www.wisconsin.gov/state/core/wisconsin_cities_towns_and_villages.html

Wyoming

Representatives:

• Print version available for order at: http://www.wyomuni.org/index.asp?Type=B_BASIC&SEC={39883395-64A6-411A-AF31-ED715C1916ED}

Example

See DemocracyMap Officials Example

Number of Cities Per State

Based on the 2007 GID

+------------+--------+
| STATE_ABBR | cities |
+------------+--------+
| IL         |   2598 |
| TX         |   2418 |
| PA         |   2032 |
| MO         |   1904 |
| IA         |   1894 |
| OH         |   1876 |
| MN         |   1708 |
| KS         |   1254 |
| NY         |   1236 |
| OK         |   1188 |
| WI         |   1184 |
| IN         |   1134 |
| NC         |   1096 |
| GA         |   1070 |
| MI         |   1066 |
| NE         |   1060 |
| AR         |   1004 |
| CA         |    956 |
| AL         |    916 |
| KY         |    838 |
| FL         |    822 |
| ND         |    714 |
| TN         |    694 |
| NJ         |    648 |
| SD         |    618 |
| LA         |    606 |
| MS         |    592 |
| WA         |    562 |
| CO         |    540 |
| SC         |    536 |
| OR         |    484 |
| UT         |    484 |
| WV         |    464 |
| VA         |    458 |
| ID         |    400 |
| MD         |    314 |
| AK         |    296 |
| MT         |    258 |
| NM         |    202 |
| WY         |    198 |
| AZ         |    180 |
| DE         |    114 |
| VT         |     90 |
| MA         |     90 |
| CT         |     60 |
| ME         |     44 |
| NV         |     38 |
| NH         |     26 |
| RI         |     16 |
|            |      6 |
| HI         |      2 |
| DC         |      2 |
+------------+--------+