TblModel01 Table

AIREvents Database Documentation

TblModel01 Table

Collapse All

AIREvents Database : TblModel01 Table

Description

Stores detailed information about each simulated event in the catalog for the United States Terrorism Model (Model 01).

Properties

Creation Date	3/21/2019 5:26 PM
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	1403644
Data Space Used	422,256.00 KB
Index Space Used	1,032.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	EventID	Unique system-provided identifier for the event.	int	4
	ModelID	Code that represents the model.	int	4
	Event	Identifier for the event.	int	4
	Year	Year in the catalog that the event occurred.	int	4
	Day	Day (within the Year) that the event occurred.	int	4
	TerrorismGroup	Identifies whether the "group" that executed the terrorism event is considered international or domestic. Note this is from a United States perspective.	varchar	20
	AttackType	Defines the type of attack. Conventional = Portable car and truck bombs, and general and commercial aviation crashes CBRN = Biological weapons (e.g., anthrax and smallpox), chemical weapons(e.g., anthrax and VX), radiological dispersion devices (e.g., cobalt and cesium), and nuclear bombs	varchar	50
	WeaponType	Defines the weapon used in the event.	varchar	16
	TargetType	Identifies the generic genre of the target, such as "airport".	varchar	35
	Latitude	Latitude coordinate where the event occurred. Values will be positive for locations north of the equator and negative south of the equator.	float	9
	Longitude	Longitude coordinate where the event occurred. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.	float	9
	SubAreaName	Name of the subarea where the event occurred.	varchar	40
	AreaName	Name of the area where the event occurred.	varchar	20
	Target_ID	Unique system-provided identifier for the specific target of the event.	int	4
	Target_Name	Name of the specific target, such as "JFK Airport Terminal 8".	varchar	100
	Key_Event	Indicates whether the event features the first appearance of a unique combination of a specific weapon type and specific target. 1 = key event 0 = not a key event	smallint	2
	TrophyFlag	Indicates whether the target of the event has a higher probability of attack because of its iconic status. 1 = trophy target 0 = non-trophy target	varchar	10
	ClusterEventCount	Number of individual incidences that are clustered together to represent this event.	smallint	2
	SFP_Coverage	Indicates the coverage for each simulated event.	char	1

See Also

Related Objects

AIREvents Database

Extreme Event Solutions Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Extreme Events Solutions with questions or comments. For database questions. For documentation comments.