EVENTS DATABASE: ICE


DESCRIPTION:

Contains occurrences of damaging ice storms in the mid-Atlantic region.

# Occurrences: 1591

# Events: 71

Event Criteria: Consecutive Days

Occurrence Criteria: Dates chosen from WDI research and NCDC events database.

Sources: NCDC events database; ASOS Hourly Reports; Winter Disruptiveness Index (WDI) research data.


NOTES:

Multiple Datasources: This table contains data from multiple data sources that may have varying selection criteria.  Very few reports before 1993.

Times reflect start times.


SELECT DATES:

Database Start Year: 1961

Database End Year: 2005

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 occurrence (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
Damage cost (dollars).
integer

YES

comments
Ice accrual (inches).
floating point number
YES
state
The US state of the occurrence.
2-letter state abbrev.
 
fips
The US Govt Fips (county) code.
integer
 
c2
Starting hour.
integer
YES
c3
Ending hour.
integer
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