EVENTS DATABASE: FLOOD


DESCRIPTION:

Contains occurrences of large scale flooding in the mid-Atlantic region.

# Occurrences: 2929

# Events: 386

Event Criteria: Consecutive occurrences within 12 hrs of each other.

Occurrence Criteria: As classified by NCDC storm events database.

Sources: NCDC Storm Events Database


NOTES:

Times represent flood start times.


SELECT DATES:

Database Start Year: 1993

Database End Year: 2011

Please select a starting date and ending date for your query:

Start Date: Enter yyyy mm dd - -

End Date: Enter yyyy mm dd

Month:

Order: Earliest to Latest Latest to Earliest

Only gather occurrences with complete date and time information.

Group occurrences by event index.

The above option will generate an average event time and location. The other fields will not be shown if this option is selected.


SELECT FIELDS:

Please select which fields you'd like to retrieve. If you want all of them, skip to the next section.

Field Name
Description
Format
Incomplete
datetime
The date and time of the event (UTC).
yyyy-mm-dd hh:mm:ss
 
event_index
Describes to which event the occurrence belongs; typically numbered consecutively.
integer
 
lat
The latitude of the occurrence (N-positive).
floating point number
 
lon
The longitude of the occurrence (W-negative).
floating point number
 
damage
Event damage cost (dollars).
integer

YES

comments
Event type text description.
text
state
The US state of the occurrence.
2-letter state abbrev.
 
county
The location or county of the occurrence.
text

 

fips
US Govt FIPS (county) code.
integer
location
Location (town) of the occurrence.
text
YES
datetime_end
The datetime of the end of occurrence (UTC).
yyyy-mm-dd hh:mm:ss
YES
location_end
Location (town) of the occurrence at its end.
text
YES
c2
Fatalities.
integer
YES
c3
Injuries.
integer
YES
c4
Latitude of end of occurrence.
floating point number
YES
c5
Longitude of end of occurrence.
floating point number
YES
wfo
The NWS forecast offfice of the occurrence.
3-letter office abbrev.
YES

SELECT FORMAT:

Please select a format for viewing your results. Plain text is best for copying into Excel or another file, while web pages are easiest to read if you are just browsing.

Plain Text (csv Ascii)
Web Page

Selecting too many records may take a long time to process, and could even overload the browser.

Limit: records.

Click "Retrieve Events" to submit your query and view the results.


Interface designed by SJG for Pennsylvania State Climate Office; Summer 2005