About this Dataset

Serious Injury Response, Tracking & Analysis Program (SIRTA)

In accordance with NYC Administrative Code section 19-182.3, the Serious Injury Response, Tracking & Analysis Program (SIRTA) is a program at the New York City Department of Transportation (NYC DOT) that investigates, analyzes and reports on serious vehicular crashes, review street design, infrastructure and driver behavior at each crash location, and makes recommendations for safety street design or infrastructure. This dataset provides information on serious vehicular crashes that were analyzed and reported on as part of SIRTA. For more information, please visit the NYC DOT website: https://www.nyc.gov/html/dot/html/about/dotlibrary.shtml#data
Organization: City of New York
Last updated: 2023-08-12T18:21:42.946558
Tags: analysis, injury, response, serious, tracking, vehicle

Tables

Table 1

@usgov.city_of_new_york_serious_injury_response_tracking_anal_4a75bec8.table_1

363.95 kB
8,353 rows
23 columns

CREATE TABLE table_1 (
  "collision_id" DOUBLE,
  "crash_date" TIMESTAMP,
  "crash_time" VARCHAR,
  "crash_police_precinct" DOUBLE,
  "crash_borough" VARCHAR,
  "total_non_severe_injuries" DOUBLE,
  "total_severe_injuries" DOUBLE,
  "total_fatalities" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "on_street" VARCHAR,
  "cross_street" VARCHAR,
  "address" VARCHAR,
  "highway_reference_marker" VARCHAR,
  "zipcode" DOUBLE,
  "similar_fatalities_severe_injuries_3y_lookback" DOUBLE  -- Similar Fatalities & Severe Injuries (3Y Lookback),
  "similar_fatalities_all_injuries_3y_lookback" DOUBLE  -- Similar Fatalities & All Injuries (3Y Lookback),
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "building_identification_number_bin" DOUBLE  -- Building Identification Number (BIN),
  "borough_block_lot_bbl" DOUBLE  -- Borough Block Lot (BBL),
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);