Events Database - Table Specifics | Last Updated: | 7/14/2005 | |||||||||||||
Table Names: | cold | heat | snow | hail | s_wind | t_wind | fire | ice | fog | ozone | tornado | flood | f_flood | ||
QC STATUS | red = caution; see notes | ||||||||||||||
Created? | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | ||
Complete? | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | ||
Interface? | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | ||
Spot Check? | passed | passed | passed | passed | passed | passed | impossible | passed | passed | impossible | passed | passed | passed | ||
Accuracy of Times? | decent | decent | decent | 1-hr err? | decent | 1-hr err? | some 12Z | acceptable | decent | all 18Z | decent | decent | decent | ||
Spatial Averaging Bias? | more PA | more PA | slight | unlikely | unlikely | unlikely | more PA | unlikely | unlikely | unlikely | unlikely | unlikely | unlikely | ||
Quality Confidence | good | good | good | good | good | good | good | good | good | good | good | good | good | ||
TABLE METADATA | |||||||||||||||
Year Begins | 1926; 1948 | 1926; 1950 | 1950 | 1956; 1996 | 1993 | 1955 | 1970;1995 | 1961 | 1994 | 1995 | 1950 | 1993 | 1993 | ||
Year Ends | 2002; 2005 | 2002 | 2003 | 2004; 2005 | 2003 | 2003 | 2004;2005 | 2003 | 2005 | 2003 | 1992 | 2005 | 2005 | ||
Est. Number of Sources | 2 | 2 | 3 | 2 | 1 | 1 | 4 | 2 | 1 | 1 | 1 | 1 | 1 | ||
# Occurrences | 674 | 546 | 475 | 4028 | 926 | 22240 | 407 | 1405 | 310 | 7586 | 1015 | 2929 | 4548 | ||
# Events | 257 | 163 | 109 | 712 | 67 | 2567 | 194 | 57 | 34 | 128 | 609 | 386 | 761 | ||
Event Criteria | Consec Days | Consec Days | Same Storm | Consec w/in 6 hr | Consec Days | Consec w/in 6 hr | Consec Days | Consec Days | Consec w/in 6 hr | Consec Days | Consec w/in 6 hr | Consec w/in 12 hr | Consec w/in 6 hr | ||
FIELD METADATA | blue = exists for some records, but not all | orange=only one value per event | |||||||||||||
FIELD | FORMAT | NOTES | |||||||||||||
datetime | yyyy-mm-dd hh:mm:ss | UTC | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ |
event_index | integer | consecutive chronologically | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ |
lat | float | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | |
lon | float | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | REQ | |
damage | integer | NULL | NULL | YES | YES | SOME | YES | YES | YES | NULL | NULL | YES | YES | YES | |
comments | vary by table | Obs Low Temp | Obs High Temp | snow accum | hail size (inches) | Peak Wind (mph) | Peak Wind (knots) | extinction cost | ice accrual (inches) | textual damage | NULL | F-scale | event subtype | event subtype | |
state | LL | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | |
site_id | LLLLL | YES | YES | ||||||||||||
site_name | string | YES | YES | ||||||||||||
county | string | YES | YES | YES | YES | YES | YES | ||||||||
fips | integer | YES | YES | YES | YES | YES | |||||||||
c2 | float | 10-Day Centered Average | 10-Day Centered Average | Kocin Index | fatalities | Fire Size | hour_start | 8-hr avg O3 conc (ppm) | fatalities | fatalities | fatalities | ||||
c3 | float | 10-Day Centered STD | 10-Day Centered STD | injuries | Cause | hour_end | 1-hr avg O3 conc (ppm) | injuries | injuries | injuries | |||||
c4 | float | 10DayAVG - (2*10-DaySTD) | 10DayAVG + (2*10-DaySTD) | lat_end | lat_end | lat_end | |||||||||
c5 | float | Palmer Index | lon_end | lon_end | lon_end | ||||||||||
num_states | integer | YES | |||||||||||||
width | float | YES | |||||||||||||
length | float | YES | |||||||||||||
dense | binary | 0 or 1 | |||||||||||||
township | string | YES | |||||||||||||
landmark | string | YES | |||||||||||||
datetime_end | yyyy-mm-dd hh:mm:ss | YES | YES | YES | |||||||||||
location | string | YES | YES | YES | YES | YES | YES | YES | |||||||
wfo | string | YES | YES | ||||||||||||
time_correct | binary | 0 or 1 |