Summary Of Disaster Declarations In Utah 2005-2014

This dataset was created for the Data Visualization map on FEMA.gov/data-visualization using Agency data that was released to the public by OpenFEMA. It is created by pulling, processing and combining multiple OpenFEMA datasets (listed below) together. Merging data tables depends on common fields being present throughout each source file. For this reason many columns in the original files were not included. For example, county level details were excluded because they are not available in all the source files. Additionally, we added new columns to ensure integrity existed between the source file and the merged file. For example, we added and populated when needed Grant Bucket, Program Name, Program Abbr, and Incident Type. Open FEMA data is available at: http://www.fema.gov/media-library/resources-documents/collections/339

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-utah-gov/summary-of-disaster-declarations-in-utah-20052014-p7ry-9nxh\".\"summary_of_disaster_declarations_in_utah_20052014\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.