Layer: Stanford_MSA_Database.csv (ID:3)

Name: Stanford_MSA_Database.csv

Display Field: Shooter Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CaseID (type: esriFieldTypeInteger, alias: CaseID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Civilian_Fatalities (type: esriFieldTypeInteger, alias: Number of Civilian Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Civilian_Injured (type: esriFieldTypeInteger, alias: Number of Civilian Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Enforcement_Fatalitie (type: esriFieldTypeInteger, alias: Number of Enforcement Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Number_of_Enforcement_Injured (type: esriFieldTypeInteger, alias: Number of Enforcement Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Number_of_Fatalities (type: esriFieldTypeInteger, alias: Total Number of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Number_of_Victims (type: esriFieldTypeInteger, alias: Total Number of Victims, SQL Type: sqlTypeOther, nullable: true, editable: true)
Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Day_of_Week (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Date___Detailed (type: esriFieldTypeString, alias: Date - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Shooter_Name (type: esriFieldTypeString, alias: Shooter Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_shooters (type: esriFieldTypeString, alias: Number of shooters, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Shooter_Age_s_ (type: esriFieldTypeString, alias: Shooter Age(s), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Average_Shooter_Age (type: esriFieldTypeString, alias: Average Shooter Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Shooter_Sex (type: esriFieldTypeString, alias: Shooter Sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Shooter_Race (type: esriFieldTypeString, alias: Shooter Race, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Type_of_Gun___Detailed (type: esriFieldTypeString, alias: Type of Gun - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Type_of_Gun___General (type: esriFieldTypeString, alias: Type of Gun - General, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_Shotguns (type: esriFieldTypeString, alias: Number of Shotguns, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_Rifles (type: esriFieldTypeString, alias: Number of Rifles, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_Handguns (type: esriFieldTypeString, alias: Number of Handguns, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_Number_of_Guns (type: esriFieldTypeString, alias: Total Number of Guns, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_Automatic_Guns (type: esriFieldTypeString, alias: Number of Automatic Guns, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_of_Semi_Automatic_Guns (type: esriFieldTypeString, alias: Number of Semi-Automatic Guns, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Fate_of_Shooter_at_the_scene (type: esriFieldTypeString, alias: Fate of Shooter at the scene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Fate_of_Shooter (type: esriFieldTypeString, alias: Fate of Shooter, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Shooter_s_Cause_of_Death (type: esriFieldTypeString, alias: Shooter's Cause of Death, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
School_Related (type: esriFieldTypeString, alias: School Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Place_Type (type: esriFieldTypeString, alias: Place Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Relationship_to_Incident_Locati (type: esriFieldTypeString, alias: Relationship to Incident Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Targeted_Victim_s___Detailed (type: esriFieldTypeString, alias: Targeted Victim/s - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Targeted_Victim_s___General (type: esriFieldTypeString, alias: Targeted Victim/s - General, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Possible_Motive___Detailed (type: esriFieldTypeString, alias: Possible Motive - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Possible_Motive___General (type: esriFieldTypeString, alias: Possible Motive - General, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
History_of_Mental_Illness___Det (type: esriFieldTypeString, alias: History of Mental Illness - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
History_of_Mental_Illness___Gen (type: esriFieldTypeString, alias: History of Mental Illness - General, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_1 (type: esriFieldTypeString, alias: Data Source 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_2 (type: esriFieldTypeString, alias: Data Source 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_3 (type: esriFieldTypeString, alias: Data Source 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_4 (type: esriFieldTypeString, alias: Data Source 4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_5 (type: esriFieldTypeString, alias: Data Source 5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_6 (type: esriFieldTypeString, alias: Data Source 6, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Data_Source_7 (type: esriFieldTypeString, alias: Data Source 7, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Military_Experience (type: esriFieldTypeString, alias: Military Experience, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Class (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Depreciation (type: esriFieldTypeInteger, alias: Depreciation, SQL Type: sqlTypeOther, nullable: true, editable: true)
Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Edit_Date (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/3/2021 7:56:48 PM

Schema Last Edit Date: 3/3/2021 7:56:48 PM

Data Last Edit Date: 3/3/2021 7:56:48 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat