SOCRATA
Traffic Crashes - Vehicles | City of Chicago | Data Portal
Freshness & Tracking
Discovered3/8/2026, 4:53:09 PM
Last checked3/8/2026, 11:39:19 PM
Last changed3/8/2026, 4:53:09 PM
Reads1
Search hits5
View raw source ↗File Details
Filenamedownload_2026-03-16.csv
Size657437.5 KB
Typetext/csv; charset=utf-8
Rows analyzed2.1M
Columns71
📊
download_2026-03-16.csv
642.0 MB · text/csv; charset=utf-8 · Uploaded 3/16/2026
52.4% Poor
642.0 MB
Size
2.1M
Rows
71
Columns
3
Analyses
Activity Timeline
Upload/RefreshAnalysisFailedSnapshot
⚡analysis
DuckDB analysis
8/23/2026
52.4% quality
⚡analysis
DuckDB analysis
8/17/2026
52.9% quality
⚡analysis
Scheduled analysis
3/17/2026
100% quality
📤upload
File uploaded
3/16/2026
download_2026-03-16.csv
Achievements
3/8🔍Located
📤Uploaded
⬇️Downloaded
🗄️Query Layer
🔬Analyzed
📸Snapshot
🛡️Privacy
⭐High Quality
30d agotoday
⚡
Manualconduit_analysis
8/23/2026⚡
Manualconduit_analysis
8/17/2026⏰
Scheduledconduit_analysis
3/17/2026Resources
Direct links to downloads, APIs, and related pages.
Profiled Fields (71)
Field-level metadata from analytics imports.
| Field | Technical | Semantic | Business |
|---|---|---|---|
| AREA_00_I | string | category | AREA 00 I |
| AREA_01_I | string | category | AREA 01 I |
| AREA_02_I | string | category | AREA 02 I |
| AREA_03_I | string | category | AREA 03 I |
| AREA_04_I | string | category | AREA 04 I |
| AREA_05_I | string | category | AREA 05 I |
| AREA_06_I | string | category | AREA 06 I |
| AREA_07_I | string | category | AREA 07 I |
| AREA_08_I | string | category | AREA 08 I |
| AREA_09_I | string | category | AREA 09 I |
| AREA_10_I | string | category | AREA 10 I |
| AREA_11_I | string | category | AREA 11 I |
| AREA_12_I | string | category | AREA 12 I |
| AREA_99_I | string | category | AREA 99 I |
| AXLE_CNT | number | numeric | AXLE CNT |
| CARGO_BODY_TYPE | string | category | CARGO BODY TYPE |
| CARRIER_CITY | string | address | CARRIER CITY |
| CARRIER_NAME | string | business_name | CARRIER NAME |
| CARRIER_STATE | string | address | CARRIER STATE |
| CCMC_NO | string | category | CCMC NO |
| CMRC_VEH_I | string | category | CMRC VEH I |
| CMV_ID | string | identifier | CMV ID |
| COMMERCIAL_SRC | string | category | COMMERCIAL SRC |
| CRASH_DATE | string | datetime | CRASH DATE |
| CRASH_RECORD_ID | string | identifier | CRASH RECORD ID |
| CRASH_UNIT_ID | string | identifier | CRASH UNIT ID |
| EXCEED_SPEED_LIMIT_I | string | category | EXCEED SPEED LIMIT I |
| FIRE_I | string | category | FIRE I |
| FIRST_CONTACT_POINT | string | person_name | FIRST CONTACT POINT |
| GVWR | string | category | GVWR |
| HAZMAT_CLASS | string | category | HAZMAT CLASS |
| HAZMAT_NAME | string | person_name | HAZMAT NAME |
| HAZMAT_OUT_OF_SERVICE_I | string | category | HAZMAT OUT OF SERVICE I |
| HAZMAT_PLACARDS_I | string | category | HAZMAT PLACARDS I |
| HAZMAT_PRESENT_I | string | category | HAZMAT PRESENT I |
| HAZMAT_REPORT_I | string | category | HAZMAT REPORT I |
| HAZMAT_REPORT_NO | string | category | HAZMAT REPORT NO |
| HAZMAT_VIO_CAUSE_CRASH_I | string | category | HAZMAT VIO CAUSE CRASH I |
| IDOT_PERMIT_NO | string | category | IDOT PERMIT NO |
| ILCC_NO | string | category | ILCC NO |
| LIC_PLATE_STATE | string | address | LIC PLATE STATE |
| LOAD_TYPE | string | category | LOAD TYPE |
| MAKE | string | category | MAKE |
| MANEUVER | string | category | MANEUVER |
| MCS_OUT_OF_SERVICE_I | string | category | MCS OUT OF SERVICE I |
| MCS_REPORT_I | string | category | MCS REPORT I |
| MCS_REPORT_NO | string | category | MCS REPORT NO |
| MCS_VIO_CAUSE_CRASH_I | string | category | MCS VIO CAUSE CRASH I |
| MODEL | string | category | MODEL |
| NUM_PASSENGERS | string | category | NUM PASSENGERS |
| OCCUPANT_CNT | number | numeric | OCCUPANT CNT |
| TOTAL_VEHICLE_LENGTH | number | metric | TOTAL VEHICLE LENGTH |
| TOWED_BY | string | category | TOWED BY |
| TOWED_I | string | category | TOWED I |
| TOWED_TO | string | category | TOWED TO |
| TRAILER1_LENGTH | number | numeric | TRAILER1 LENGTH |
| TRAILER1_WIDTH | string | category | TRAILER1 WIDTH |
| TRAILER2_LENGTH | number | numeric | TRAILER2 LENGTH |
| TRAILER2_WIDTH | string | category | TRAILER2 WIDTH |
| TRAVEL_DIRECTION | string | category | TRAVEL DIRECTION |
| UNIT_NO | string | category | UNIT NO |
| UNIT_TYPE | string | category | UNIT TYPE |
| UN_NO | string | category | UN NO |
| USDOT_NO | string | category | USDOT NO |
| VEHICLE_CONFIG | string | category | VEHICLE CONFIG |
| VEHICLE_DEFECT | string | category | VEHICLE DEFECT |
| VEHICLE_ID | string | identifier | VEHICLE ID |
| VEHICLE_TYPE | string | category | VEHICLE TYPE |
| VEHICLE_USE | string | category | VEHICLE USE |
| VEHICLE_YEAR | number | numeric | VEHICLE YEAR |
| WIDE_LOAD_I | string | category | WIDE LOAD I |