Download Government Databases for Free

By Cuillier, David | The Quill, March/April 2013 | Go to article overview
Save to active project

Download Government Databases for Free


Cuillier, David, The Quill


CHECK OUT FIVE federal databases that you can download for free, pull into Microsoft Excel, and analyze to identify trends and problems in your community. Start with these easily obtainable databases and then use your FOI skills to request more public data specific to your beat.

1 TRAIN WRECKS

safetydata.fra.dot.gov/OfficeofSafety

Find the most dangerous train crossings in your community by looking at Federal Railroad Administration data going back to 1975. Click on the "Download Accident Data" link and under the "Table name" pull-down menu, choose "Railroad Casualties." Then choose a year, your state and a format, such as Excel, then click "Generate File." Sort by county, city and highway to identify trouble spots (find your state in the STCNTY field). Check out the "TOTKLD" column for fatalities, and the "GXID" column to identify specific crossings. Download the past five years to spot trends.

2 AGRICULTURAL TRENDS

nass.usda.gov/Data_and_Statistics/index.asp

The U.S. Department of Agriculture provides statistics about all sorts of agricultural commodities by state, county orZIP code. You can look at trends going back to 1 997 in farm production to identify what is on the rise and decline in your area. The data retrieval site is a little complicated and clunky, but with a little experimentation you should be able to get what you need.

3 DETERIORATING BRIDGES

fhwa.dot.gov/BRIDGE/britab.cfm

You'd be surprised how many bridges, including overpasses, are falling apart. Click on "Download NBI ASCII files," then "Recording and Coding Guide" to save a PDF to your desktop. You'll need this because the data are heavily coded. Go back and click on "Record Format" and then File "Save As." Save this Web page to the desktop. Click on "2012 Data" then your state, then "Proceed to data." Go to File and then Save As a text file to your desktop.

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
Loading One moment ...
Project items
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

Cited article

Download Government Databases for Free
Settings

Settings

Typeface
Text size Smaller Larger
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

While we understand printed pages are helpful to our users, this limitation is necessary to help protect our publishers' copyrighted material and prevent its unlawful distribution. We are sorry for any inconvenience.
Full screen

matching results for page

Cited passage

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.

Are you sure you want to delete this highlight?