Category Archives: Journalism

Survey Documentation and Analysis (SDA)

Survey Documentation and Analysis (SDA) is a web based interface that allows access and analysis of data. The data can be accessed from IPUMS or from  the Inter-university Consortium for Political and Social Research (ICPSR).

SDA allows you to:

  • Browse the codebook describing a datasetsda
  • Calculate frequencies or crosstabulation (with charts)
  • Do comparison of means
  • Calculate a correlation matrix
  • Compare correlations
  • Perform multiple regression
  • Perform logit/probit regression
  • List values of individual cases
  • Recode variables (into public work area)
  • Compute a new variable
  • List/delete derived variables
  • Download a customized subset

SDA allows you to analyze data at a level appropriate to your level of experience. SDA can only analyze datasets that reside on an SDA server. If you would like to test drive SDA, or to see if SDA is useful for your research check out their General Information page.

Journalism Library Data Viz Contest – Decorate Our Wall EXTENDED

Hold the phone!!!  The Journalism Library is excited to EXTEND the deadline for the data visualization contest! Submit your entries by Wednesday, May 15th 5pm, for a chance to see yours in poster-size proudly displayed in the Journalism Library. The winner will also receive a libraries mug and the opportunity to submit your work to Columbia University Libraries Academic Commons.

Contest Rules:

  • submissions must use publicly available data; data is broadly defined and can include video, audio, photo
  • submissions must be received no later than 5pm on May 15th – please send to journalism@libraries.cul.columbia.edu
  • you may use previously submitted class work!
  • submissions must be in PDF – please do not include your name in the filename, but please share with us the following in your email!
    • your full name
    • graduation year
    • title for your creation
    • data source/s used

Try Ashley's new cool data tools page for help and ideas!

All submissions will be judged based on accurate use of data and originality in aesthetic presentation; panel of judges includes Journalism Librarian, Cristina Ergunay, Data Services Coordinator, Ashley Jester, and JSchool Professors Susan McGregor and Mark Hansen!

The winner will be announced at the JSchool Innovation Showcase on May 17th. We look forward to your submissions! 

UTC/National Journal Survey Data Now Available

Data from United Technologies/National Journal Congressional Connection survey series are now available from the Roper Center for Public Opinion Research.  The surveys track the public's priorities on the policies at the center of Congressional debate. Included in this new data collection are 22 studies conducted from January, 2012 to January, 2013. 

 The data can be accessed either through Roper's iPoll interface or the RoperExpress interface. iPoll searches at the question-level and returns the tabulated responses as percentages and in a bar chart.  RoperExpress searches survey-level descriptions and returns the description with links for downloading the data files and accompanying documentation. 

 
At the Roper site you can navigate between the two interfaces using icons for each: a stylized i for iPoll and a stylized x for RoperExpress.  

For more information go to the Roper Center for Public Opinion Research website or refer to the Library guide on Opinion Poll Data.  For help with this or any data product visit the  Digital Social Science Data Service at contact us dssc.data@columbia.edu.

New Service – Journalism Library Video Chat

The Journalism Library is excited to launch a new cool service to assist you with your research – video chat reference – which will enable you to connect with a librarian using Skype or Google+ Hangouts.

Enjoy virtual face time and screen-sharing demonstrations, all from the comfort of your couch.  In addition to video chat "Walk-in Wednesdays," you may make evening and weekend appointments for video chat research assistance.

Take a look at the instructions for using these video chat technologies – and book your appointment today!

Internet Archive TV News Collection

The Internet Archive TV News now contains an online collection of all tv news since 2009 from national U.S. networks.  The collection contains 350,000 news programs and transcripts collected over 3 years and is updated with new broadcasts 24 hours after they are aired.  Search from selected topics, or customize a search by keyword, network, station, and program title!  Try it, and let me know what you think!

Who Owns the Media?

Did you know:

  • Yahoo ranks #1 for having the most unique monthly visitors – over 39 million – to their online news sites? 
  • Time Warner ranks #1 in combined magazine circulation – over 32 million?

Find these statistics and more at Who Owns the News Media from the Pew Research Center's Project for Excellence in Journalism, an interactive database of companies who own news properties – online, newspaper, magazine, network tv, radio, and more – in the United States. Use the site to compare the companies, explore each media sector or read profiles of individual companies.

Statistical Treats for a Happy Halloween!

 Happy HalloweenDid you know?

  • 1.1 billion total pounds of pumpkin were grown in the U.S. in 2010 
  • there are an estimated 41 million potential trick-or-treaters in the U.S., ages 5-14
  • California led the nation in the number of chocolate and cocoa manufacturing establishments, with 135

Find these and other fun holiday statistics at the U.S. Census Bureau’s Newsroom, Facts for Features & Special Editions page – one of the census projects designed for journalists.  This collection of statistics from demographic and economic subject areas provides information, background, and source citing for topics in the news.  Happy Halloween!

NYT & WNYC to Launch SchoolBook

A new project – SchoolBook – will launch on September 7th, 2011 – a collaboration of the New York Times and WNYC, which will be a site offering daily news, data, and discussion about New York City schools, including customized pages for each of the 1,700 pubic schools and 800 private schools in the city.

Sign up to get email notification when the site will be ready at:

http://www.nytimes.com/schoolbook/

In the meantime, do you need other NYC education resources for your beat reporting?  Try:

for statistics, data, and reports on schools.

Back to School Stats

butlerworkshop.2008-04-16.DSC_0048

Did you know:

  • the average number of children participating each month in the National School Lunch Program in 2009 was 31.3 million
  • the number of classroom computers in the nation’s schools in 2005-2006 was 14.2 million (or one computer for every four students)?  
  • the per-pupil expenditure on public elementary and secondary education nationally in 2009 was $10,499, and in New York $18,126 per-pupil, the most among all states?
  • the average tuition, room and board at the nation’s four-year private colleges and universities for one academic year (2008-09) was $40,633, more than double the cost in 1990?

Find these and other interesting statistics from the U.S. Census Bureau’s Facts for Features & Special Editions!