Dataset Profile
1.1M
Total records
—
Type
Analyzed sample: 5.0K rows
Conduit profiled a subset of the source for performance; full data is downloadable.
ID: https://data.cityofchicago.org/Transportation/Traffic-Crashes-Crashes/85ca-t3if
Freshness & Tracking
Discovered3/8/2026, 4:52:32 PM
Last checked3/8/2026, 11:38:42 PM
Last changed3/8/2026, 4:52:32 PM
Reads0
Search hits5
View raw source ↗File Details
Filenamedownload_2026-03-16.csv
Size549837.2 KB
Typetext/csv; charset=utf-8
Analyzed sample5.0K of 1.1M
Columns48
📊
download_2026-03-16.csv
537.0 MB · text/csv; charset=utf-8 · Uploaded 3/16/2026
100% Excellent
537.0 MB
Size
1.1M
Rows
(5.0K analyzed)
48
Columns
1
Analyses
Activity Timeline
Upload/RefreshAnalysisFailedSnapshot
⚡analysis
Scheduled analysis
3/17/2026
100% quality
📤upload
File uploaded
3/16/2026
download_2026-03-16.csv
Achievements
4/8🔍Located
📤Uploaded
⬇️Downloaded
🗄️Query Layer
🔬Analyzed
📸Snapshot
🛡️Privacy
⭐High Quality
30d agotoday
⏰
Scheduledconduit_analysis
3/17/2026Resources
Direct links to downloads, APIs, and related pages.
Profiled Fields (48)
Field-level metadata from analytics imports.
| Field | Technical | Semantic | Business |
|---|---|---|---|
| ALIGNMENT | string | category | ALIGNMENT |
| BEAT_OF_OCCURRENCE | number | numeric | BEAT OF OCCURRENCE |
| CRASH_DATE | string | datetime | CRASH DATE |
| CRASH_DATE_EST_I | string | datetime | CRASH DATE EST I |
| CRASH_DAY_OF_WEEK | number | numeric | CRASH DAY OF WEEK |
| CRASH_HOUR | number | numeric | CRASH HOUR |
| CRASH_MONTH | number | numeric | CRASH MONTH |
| CRASH_RECORD_ID | string | identifier | CRASH RECORD ID |
| CRASH_TYPE | string | category | CRASH TYPE |
| DAMAGE | string | category | DAMAGE |
| DATE_POLICE_NOTIFIED | string | datetime | DATE POLICE NOTIFIED |
| DEVICE_CONDITION | string | category | DEVICE CONDITION |
| DOORING_I | string | category | DOORING I |
| FIRST_CRASH_TYPE | string | person_name | FIRST CRASH TYPE |
| HIT_AND_RUN_I | string | category | HIT AND RUN I |
| INJURIES_FATAL | mixed | category | INJURIES FATAL |
| INJURIES_INCAPACITATING | mixed | category | INJURIES INCAPACITATING |
| INJURIES_NON_INCAPACITATING | mixed | category | INJURIES NON INCAPACITATING |
| INJURIES_NO_INDICATION | mixed | category | INJURIES NO INDICATION |
| INJURIES_REPORTED_NOT_EVIDENT | mixed | identifier | INJURIES REPORTED NOT EVIDENT |
| INJURIES_TOTAL | mixed | metric | INJURIES TOTAL |
| INJURIES_UNKNOWN | mixed | category | INJURIES UNKNOWN |
| INTERSECTION_RELATED_I | string | geolocation | INTERSECTION RELATED I |
| LANE_CNT | mixed | category | LANE CNT |
| LATITUDE | mixed | geolocation | LATITUDE |
| LIGHTING_CONDITION | string | category | LIGHTING CONDITION |
| LOCATION | string | text | LOCATION |
| LONGITUDE | mixed | geolocation | LONGITUDE |
| MOST_SEVERE_INJURY | string | category | MOST SEVERE INJURY |
| NOT_RIGHT_OF_WAY_I | string | category | NOT RIGHT OF WAY I |
| NUM_UNITS | number | metric | NUM UNITS |
| PHOTOS_TAKEN_I | string | category | PHOTOS TAKEN I |
| POSTED_SPEED_LIMIT | number | numeric | POSTED SPEED LIMIT |
| PRIM_CONTRIBUTORY_CAUSE | string | category | PRIM CONTRIBUTORY CAUSE |
| REPORT_TYPE | string | category | REPORT TYPE |
| ROADWAY_SURFACE_COND | string | category | ROADWAY SURFACE COND |
| ROAD_DEFECT | string | category | ROAD DEFECT |
| SEC_CONTRIBUTORY_CAUSE | string | category | SEC CONTRIBUTORY CAUSE |
| STATEMENTS_TAKEN_I | string | address | STATEMENTS TAKEN I |
| STREET_DIRECTION | string | address | STREET DIRECTION |
| STREET_NAME | string | address | STREET NAME |
| STREET_NO | number | address | STREET NO |
| TRAFFICWAY_TYPE | string | category | TRAFFICWAY TYPE |
| TRAFFIC_CONTROL_DEVICE | string | category | TRAFFIC CONTROL DEVICE |
| WEATHER_CONDITION | string | category | WEATHER CONDITION |
| WORKERS_PRESENT_I | string | category | WORKERS PRESENT I |
| WORK_ZONE_I | string | category | WORK ZONE I |
| WORK_ZONE_TYPE | string | category | WORK ZONE TYPE |