1 / 68

Digging into Census Data to Find Good Stories

Digging into Census Data to Find Good Stories. Sean Lahman – SLAHMAN@gannett.com Rochester Democrat & Chronicle SeanLahman.com/resources. Digging for Stories. Computer Assisted Reporting.

nida
Download Presentation

Digging into Census Data to Find Good Stories

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Digging into Census Data to Find Good Stories Sean Lahman – SLAHMAN@gannett.comRochester Democrat & Chronicle SeanLahman.com/resources

  2. Digging for Stories

  3. Computer Assisted Reporting “Journalists need to be data-savvy. It used to be that you would get stories by chatting to people in bars, and it still might be that you'll do it that way some times. But now it's also going to be about poring over data and equipping yourself with the tools to analyse it and picking out what's interesting.” London, November 2010 Tim Berners-Lee Inventor of the World Wide Web

  4. Overview of the U.S. Census

  5. Since 1790 Representatives and direct Taxes shall be apportioned among the several States which may be included within this Union, according to their respective Numbers…

  6. 10 Questions in 10 Minutes • How many people live here? • Age, gender, race of each • Home ownership?

  7. Data Release Schedule • Dec 2010 Totals for all states • February & March - Redistricting data for each state • May – Demographic profiles • June-August – Summary File 1 • Late 2011 / early 2012 – Summary File 2

  8. The End…

  9. Shortest. Census. Form. Ever. The more questions the Census Bureau asked, the fewer responses they received.

  10. American Community Survey • Samples roughly 3 million people per year • 1-year, 3-year, and5-year data released • 65,000 & 20,000 population sizes

  11. “Census data” is really many data sets • Decennial Census • American Community Survey • Small Area Income and Poverty Estimates • American Housing Survey • Consumer Expenditure Survey • Public Use Microdata Samples • Survey of Construction • … and more

  12. Levels of Complexity • Age • Gender • Race • Location

  13. Geographical Groupings

  14. Census Tracts

  15. 1790 Map

  16. Getting the Data http://www2.census.gov/census_2010/

  17. American Fact Finder

  18. AFF2

  19. AFF3

  20. AFF4

  21. AFF5

  22. AFF - new

  23. AFF-new1

  24. AFF-new2

  25. AFF-new3

  26. DataFerrett http://thedataweb.org/ or http://dataferrett.census.gov

  27. DF1

  28. IRE

  29. Other Resources • New York State Data Centerhttp://esd.ny.gov/ • Lewis Mumford Center - University of Albany http://www.albany.edu/mumford/ • University of Virginia http://mapserver.lib.virginia.edu/ • NYC Department of City Planninghttp://gis.nyc.gov/dcp/pa/address.jsp • University of Michiganhttp://www.icpsr.umich.edu/icpsrweb/ICPSR/ • University of Minnesota (PUMS)http://usa.ipums.org/usa/

  30. Finding Story Ideas "People don't really tell you this, but often the amount of time you spend finding a decent story is more than the time it takes to produce the story.“ -- Ira Glass

  31. Civics for Journalists • Who is your audience? • Context • Need reliable numbers other than the Census Bureau

  32. Redistricting • Redistricting is an intensely political process • There is a vocabulary to redistricting • Section 5 • Gerrymandering • Huge opportunity to share historical info with readers • Communities of Interest

  33. Population • Urban sprawl, neighborhood decay, suburban flight • Population density maps • Growth/decline of population in neighborhoods • Average household size (changes, comparisons between neighborhoods)

  34. Age and Gender • (More detailed age breakdowns available in May) • Graying or seeing a baby boom? • Concentrations of older residents vs. children • Gender differences in neighborhoods • Generational conflicts (mixing of generations)

  35. Race and Ethnicity • (Top level race data in first release, more detail in summer release) • Look at race breakdowns by age (growth of minority population tends to be bottom up) • Surge in Hispanic population is a national story (14 to 35 million from 1980-2000) • Segregation & diversity (see the Mumford Center at SUNY Albany, or USAT diversity index)

  36. Relationships • Types of households (available in may) • Seniors living alone • Grandchildren living in household • Consider mapping same-sex couples, single mothers

  37. Housing • Vacant housing units: what is the trend, and where? • Owner-occupied vs. rentals • How many people own their homes free and clear? Where are they? • Foreclosures… where and how many?

  38. Other Ideas • Redistricting on the local level • Compare racial composition of school population with citizens 18+ (voters) • New ACS variables: healthcare coverage, degree field, Veterans’ disability, marital history • Housing double-up as an indicator of economic impact

  39. New York Ideas • Look at the extent to which the recession, mortgage meltdown slowed the migration away from NY.   • NY an example of state that is aging, but also seeing a decline in child population (<18) 2000-10 • Also look at: % Children w/immigrant parents, children speaking other than English, HS dropout rates for 1st generation vs. 2nd generation Hispanics • To what extent does # of seats impact fed $ compared to seniority of your reps (and which committees they are on)

  40. Demographic Resources • Our Patchwork Nation – Dante ChinniIdentified clusters based on income, education, population growth, unemployment, foreclosure rates, Starbucks vs. Wal-Mart • Who We Are Now – Sam Roberts • The Big Sort – Bill Bishop • A Field Guide to Sprawl – Dolores Hayden

  41. American Community Survey

  42. American Community Survey

  43. American Community Survey

  44. American Community Survey

  45. American Community Survey

  46. Data Visualization

  47. Shan Carter Data Visualization “The last thing the internet needs is more data.” Shan Carter, Interactive Graphics EditorThe New York Times

  48. Data Visualization as a new medium

  49. Protovis-1

  50. Protovis-2

More Related