Tag Archives: data

CNTS Dataset on Domestic Conflict Events (International Coverage)

In addition to the wealth of data that is publicly available through federal, state, or local government sources, at Columbia you have access to a number of other rich datasets. You can access these datasets through the Numeric Data Catalog and the Spatial Data Catalog, which are maintained by the DSSC Data Service at Lehman Library. (And if you’ve never checked out the page on NYC data sources, you should do so now!)

One example of these interesting datasets is the Cross-National Time-Series Data Archive. This resource was started in 1968, and some of its data goes back to 1815. Of primary interest is that this dataset records occurrences of domestic conflict events (defined as: General Strikes, Purges, Government Crises, Riots, Assassinations, Anti-Government Demonstrations, Guerilla Warfare, and Revolutions) for many countries, going back to 1919. This dataset has released a new feature beginning with the 2011 data, in which each of these listed events is also linked to a relevant New York Times story. You can find frequencies for the events in the main file <CNTSDATA.xls>, and the links to related NYT stories in another file <2012 Edition LINKS.xls or 2013 Edition LINKS.xls>.

The CNTS FAQ page provides information on variables, countries included, the codebook, and more:
http://www.databanksinternational.com/71.html

Before downloading this data, you must read ICPSR’s Responsible Use Statement, available here:
http://www.icpsr.umich.edu/icpsrweb/content/datamanagement/lifecycle/access.html

ICPSR’s guide to data citation:
http://www.icpsr.umich.edu/icpsrweb/content/datamanagement/citations.html
 
For any questions about using this or other datasets, contact the DSSC Data Service at: dssc.data@columbia.edu or 212-854-6012
 

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! 

Social Explorer for Historical Maps

Looking for historical U.S. Census maps?  Try Social Explorer – a database product that helps to visually analyze and understand the demographics of the United States through the use of interactive maps and data reports.  Explore thousands of historical data maps, from the first US Census in 1790 to the present.

Census – Population Density, NYC Metro Area

1790, 1890, 1990

1790 1890 1990

Europe’s Energy Data Visualization

Europe's EnergyEurope’s Energy project, a joint effort with the Open Knowledge Foundation and using data from Eurostat – the statistical office of the European Union, gives users a set of visual tools to understand EU member states’ efforts to reduce greenhouse gas emissions and energy consumption.  Take a look!

American FactFinder

affNeed a place to start when looking for Census data?  American FactFinder (http://factfinder.census.gov) is an online data source for population, housing, economy and geography from the following data programs: 

  • Decennial Census
  • American Community Survey
  • Current Population Estimates
  • Economic Census
  • Annual Economic Surveys

American FactFinder is your source for population, housing, economic and geographic data for the United States!  Can’t find what you need?  Contact the librarian:  journalism@libraries.cul.columbia.edu.