About this Dataset

Allegheny County Commercial Vehicle Inspections

This dataset lists the locations and results of all commercial vehicle inspections performed by the Allegheny County Police Motor Carrier Safety Assistance Program (MCSAP). The goal of the MCSAP is to reduce CMV-involved crashes, fatalities, and injuries through consistent, uniform, and effective CMV safety programs.

https://www.fmcsa.dot.gov/grants/mcsap-basic-incentive-grant/motor-carrier-safety-assistance-program-mcsap-grant
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:50:40.409295
Tags: crash, police, public-safety, traffic-count

Tables

ACP Commercial Vehicle Inspections

@usgov.allegheny_county_city_of_pitts_allegheny_county_commer_8b28986d.acp_commercial_vehicle_inspections

53.53 kB
2,563 rows
14 columns

CREATE TABLE acp_commercial_vehicle_inspections (
  "date" TIMESTAMP,
  "intersection" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "inspection" VARCHAR  -- Inspection #,
  "level" VARCHAR,
  "oos_tr" VARCHAR,
  "oos_tl" VARCHAR,
  "oos_dr" VARCHAR,
  "crash" VARCHAR,
  "weighed" VARCHAR,
  "n__of_violations" DOUBLE  -- # Of Violations,
  "total_fines" DOUBLE,
  "inspector" VARCHAR
);