AIREvents Database Documentation
TblModel20 Table
AIREvents Database : TblModel20 Table
Description

No longer applicable as we split the Verisk Severe Thunderstorm model into two different models.

Stores detailed information about each simulated event in the catalog for the United States and Canada Severe Thunderstorm Model (Model 20).

Properties
Creation Date5/13/2015 2:14 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows1723026
Data Space Used145,528.00 KB
Index Space Used256.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-provided identifier for the event.int4   
 

Code that represents the model.

int4  
 

Identifier of the event.

int4  
 

Year in the catalog that the event occurred.

int4  
 Day (within the Year) that the event began.int4  
 

Description of the event. 

Note that the description includes the area codes affected by the event. 

When you review the area codes, recall that the catalog includes events in the United States and Canada.

varchar64  
 Day (within the Year) that the event began.int4  
 Day (within the Year) that the event ended.int4  
 Total number of tornadoes that were a source of damage during the event.int4  
 Total number of hail storms that were a source of damage during the event.int4  
 Total number of wind storms that were a source of damage during the event.int4  
 Total percentage of industry loss caused by tornado damage during the event.int4  
 Total percentage of industry loss caused by hail damage during the event.int4  
 Total percentage of industry loss caused by wind damage during the event.int4  
 

Indicates whether this event is considered a catastrophe.

  • Y = Yes
  • N = No
char1  
See Also

Related Objects

AIREvents Database