Category Archives: Databases

New Data: Gallup Analytics

Check out our newest data resource at Columbia Libraries: Gallup Analytics.

Gallup Analytics puts Gallup’s best global intelligence in users’ hands to help them better understand the strengths and challenges of the world’s countries and regions.  Users can access Gallup’s U.S. Daily tracking and World Poll data to compare residents’ responses region by region and nation by nation to questions on topics such as economic conditions, government and business, health and well-being, infrastructure, and education.

To Access:

Email us at dssc@library.columbia.edu to schedule a time to use this database. Access is available Monday through Friday in the Digital Social Science Center, Lehman 215.

What You’ll Find:

Build and export your own datasets, by selecting polling results across multiple geographies, years, and variables.

GallupChart
(Click image to enlarge.)

Visually explore relationships between different polling variables.

corruption
(Click image to enlarge.)

Get a quick snapshot overview of a particular geography or set of countries.

nato
(Click image to enlarge.)

For more information on how to use Gallup Analytics, contact us at dssc@library.columbia.edu.

 

Polling, Surveys, & Public Opinion

Looking for opinion poll or survey information? Search these databases:

iPoll Databank US polls originally gathered by academic, commercial and media survey organizations such as Gallup Organization, Harris Interactive, Pew Research Associates, and many more. From 1935 to present.

Polling the Nations Polls on a variety of subjects conducted by over 1000 polling organizations in the United States and 100 other countries from 1986 to the present time.

Peruse also this research guide on Opinion Poll Data

VOXGOV: New Database at the Libraries

A discovery platform with a wealth of analytics providing fast and reliable access to unfiltered original source news, media and information direct from all branches of the U.S. Federal Government. Voxgov enables researchers to easily find who in government is saying what and when on any subject throughout all phases of the political, legislative, and regulatory process.

Voxgov harvests nearly 9,500 U.S. Government web locations multiple times daily with new sites being continually added. In addition to an archive of over 9 million U.S. data files, voxgov adds an average of more than 13,000 files daily drawn from U.S. Government newsrooms (including: press releases, speeches, transcripts, stories, columns, etc.), Congressional Record, Federal Register and social media outlets, such as Twitter, Facebook, and YouTube.

Newspaper Databases

Looking for current newspaper sources? The following databases provide access to local and foreign newspapers:

  • Factiva — a searchable collection of sources including English and non-English newspapers, wire services, and more.
  • Lexis Nexis — a searchable collection of over 18,000 sources including English and non-English newspapers, wire services, transcripts of broadcasts, and more.
  • ProQuest Newspapers — a searchable collection from US national newspapers, international English-language newspapers, and/or selected regional/state newspapers.

Looking for a historical newspaper perspective?  The following databases allow you to search historical newspapers:

Can’t find what you need?  Contact us at dssc@libraries.cul.columbia.edu for assistance!

SIPA Research Tools

Attention: SIPA Students

Come learn about some of the many tools and research aids available for research at SIPA. Among the displays will be:

Interactive GIS display

Research  Resources

Statistical Software display

Zotero display

The SIPA Research Tools event, accompanied by morning refreshments, will be held on

Thursday February 13, 2014

10:00 am – 11:00 am and again 11:00 am – 12:00 pm

and hosted in the

Data Service, Lehman Library, Room 215

Please choose a session and R.S.V.P to

fd2102@columbia.edu

IHS Jane’s — ONLINE INTELLIGENCE BRIEFINGS

The IHS Jane’s annual defence report briefing is due on Wednesday 11th December, at 10 am. It is Jane’s Defence Weekly’s major review of the year’s most significant developments in terms of defence and military geopolitics.

IHS is a global information company with experts in the pivotal areas shaping today’s business landscape: energy, economics, geopolitical risk, sustainability and supply chain management.  Jane’s content provides news and analysis on global issues relating to security and defense issues. The content is updated daily, it is image rich and contain an archive of content back to the late 1980s.Access to Jane’s content is via this url http://www.columbia.edu/cgi-bin/cul/resolve?ARD1353

HELP When You Need It

Don't know where to start?                 Need help using the Libraries' collection

New to using statistical software?            What is the best way to handle citations?

Can't find the right GIS mapping tool to complete you assignment?

 

Check out what the Digital Social Science Center (DSSC) has to offer.

  • Walk in and ask.
    Librarians are available weekdays at  regularly schedule hours throughout the year in the DSSC Consulting Office which is located in the glass-walled area immediately on your right as you enter the main DSSC area, IAB323, on the second floor of Lehman Library.
     
    Additionally the DSSC Data Service is a space set up for those doing quantitative work or looking for numeric or spatial data. The DSSC Data Service is on the lower level of Lehman, IAB215, and can be reached from the main area of the DSSC by a staircase. It also maintains its own regularly schedule hours throughout the year.
     
  • Make an appointment.
    Send an email to dssc@libraries.cul.columbia.edu to request an appointment. Briefly explain what you need and someone will get back in touch. For questions involving numeric or spatial data, statistical software or mapping you can reach the DSSc Data Servic directly at dssc.data@columbia.edu.
     
  • Send an email.
    Use the same steps as a request for an appointment.  If an email contains only your question a librarian will answer by email.
     
  • Telephone.
    You can reach a librarian in the DSSC Consulting Office, 212-854-8043, or a librarian in the DSSC Data Service, 212-854-6012, during the location's regularly schedule hours.
     
  • Help yourself.
    The DSSC main page and DSSC Data Services page each gives overviews of the collections they support.
    Check to see if there are any in-library workshops offered by the DSSC (these occur most frequently early in a semester).
    Self-paced online tutorials are available from Lynda.com Software Tutorials for a wide range of softwares or GIS Self-paced Online Courses.

Life Imitates Art?

I made the mistake of going to my local multiplex last weekend to see "Olympus Has Fallen" — a mistake not just because it wasn't a very good movie, but because now I get all confused when I read the New York Times. The Times seems to have taken a plot point from "Olympus" — North Korea makes a move to destroy the United States with nuclear missiles — and incorporated it into serious news stories. Or are these stories just cleverly written reviews/propaganda pieces for the movie, dumped on the front page, disguised as news? Like I said, I'm confused.

Luckily, the Columbia University Libraries provides me with many resources to help me verify the film/news story conundrum. First, I need some background information, as I'm not as familiar with Korean politics as I should be. The Library of Congress has a great resource for this purpose, North Korea: a Country Study. The Library of Congress also has a component, the Congressional Research Service, which acts as a reference librarian for Congress and issues reports on topics requested by Congress. Ordinarily, these reports are not available to the public, but the Libraries subscribes to a module of ProQuest Congressional, which gives us access to these valuable reports. A search of CRS reports for "North Korea" retrieves 499 reports, but since the database goes back to 1916 I will just sort by date and look at the most recent ones, with titles like North Korea's Nuclear Weapons: Technical Issues; North Korea: U.S. Relations, Nuclear Diplomacy, and Internal Situation; and Foreign Assistance to North Korea. Finally, I do a search on CIAO: Columbia International Affairs Online, to find any research reports written by research institutes and NGOs.

Thanks to these databases, I have achieved clarity on this issue. Now, when did Morgan Freeman become Speaker of the House of Representatives??

Find Out Who’s On The Ballot

Created by professor Ester Fuchs, Who’s on the Ballot is a quick and easy to use website and mobile app that provides New York City citizens the location of polling places, information on candidates, sample ballots, and voter registration information.  Learn about candidates, find out when and where to vote. It’s as easy as entering your home address in search boxes.