Difference between revisions of "DemocracyMap Representatives"

Latest revision as of 15:59, 11 February 2016

State Data

• State legislators are covered by the OpenStates API
• Governors are covered by this National Governor's Association and this Scraper: https://scraperwiki.com/scrapers/us_governors/
• Additional 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

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

Note: See Individual City Data for resources on a city by city basis

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/
• Source (clerks): http://www.californiacityclerks.org/Membership_Directory.90.0.html
• Source (clerks): http://www.caceo58.org/index.php?servId=1461&Itemid=90&option=com_community&view=search&isMenu=true&uuId=5237bfb7855f0&limitstart=20

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:

• Municipal CEOs, Source: http://www.ct.gov/opm/lib/opm/igp/ceos/ceolist4-13-12.xlsx (more info)
• Municipal CFOs, Source: http://www.ct.gov/opm/lib/opm/igp/cfos/cfolist4-13-12.xls (more info)
• Municipal Tax Assessors, Source: http://www.ct.gov/opm/lib/opm/igp/assess/assessor9-16-11_v2.xls (more info)
• Complete print, CD, and online directories available for a fee ($200): 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
• Source (clerks): http://www.flcities.com/facc/MembershipDirectory3.aspx

Georgia

Representatives:

• Scraper: As of March 15 dane summers has started working on one
• 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

Officials:

• Scraper: https://scraperwiki.com/scrapers/city_representatives_-_massachusetts/
• Source: https://dlsgateway.dor.state.ma.us/Gateway/Public/WebForms/Directory/CityTownLandingPage.aspx

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

Officials

• Available for order: https://www.nhlgc.org/shop/index.php?p=product&id=4&parent=0

New Jersey

• Scraper: https://scraperwiki.com/scrapers/mayors_-_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
• Full PDF available for $50 - http://www.njslom.org/Publications.html

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

City URLs

• Source: http://ncinfo.iog.unc.edu/library/cities.html

Representatives:

• Scraper: https://scraperwiki.com/scrapers/nc_cities_towns/
• Source: http://www.nclm.org/resource-center/municipalities/Pages/Default.aspx
• Source (clerks) : http://www.ncamc.com/nc_members.php

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://munstats.pa.gov/Reports/ReportInformation2.aspx?report=LocalOfficial_Excel

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/

Representatives:

• Source (PDF) http://www.muni-info.ri.gov/documents/publications/Directory%202012%20-%20A.pdf

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:

• Scraper: As of March 8 philipashlock has started working on one
• 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

City Managers:

• Source: (not working on last inspection) https://members.tml.org/source/Members/TCMA_Directory.cfm
• Source (PDF): http://tcma.org/roster-2/ -> http://tcma.org/wp-content/uploads/2013/08/TCMA_Directory2013-14.pdf

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
• Source (clerks): http://www.wmcaclerks.org/Default.aspx?pageId=935602

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 |
+------------+--------+

City Data

The OpenStates project has been compiling resources on a city by city basis

• Google doc spreadsheet listing cities
• Github wiki page