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