Download Government Databases for Free

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

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

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.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Download Government Databases for Free
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
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?

Help
Full screen

matching results for page

    Questia reader help

    How to highlight and cite specific passages

    1. Click or tap the first word you want to select.
    2. Click or tap the last word you want to select, and you’ll see everything in between get selected.
    3. You’ll then get a menu of options like creating a highlight or a citation from that passage of text.

    OK, got it!

    Cited passage

    Style
    Citations are available only to our active members.
    Buy instant access to cite pages or passages in MLA, APA and Chicago citation styles.

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

    1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

    Cited passage

    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.

    Buy instant access to save your work.

    Already a member? Log in now.

    Oops!

    An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.