crash_reports
1 row where "datetime" is on date 2021-04-22, intersection = 0 and "retrieved" is on date 2021-04-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-22
Time:
08:54
Address:
73 LEXINGTON
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING NORTH BOUND ON LEXINGTON ST WHEN HE WAS STRUCK BY MV#3 CAUSING HIM TO HIT MV#2. THE OPERATOR OF MV#1 STATED MV#3 CAUSED THE ACCIDENT BUT DROVE AWAY. HE STATED THAT HE STRUCK MV#2 ON THE DRIVERS SIDE WHICH PUSHED HIM ONTO THE SIDEWALK TAKING DOWN A TRAFFIC SIGNAL POLE. THERE WAS DAMAGE TO THE D/S FRONT OF MV#1. THE OPERATOR OF MV#2 STATED THAT MV#1 HE WAS TRAVELING SOUTH BOUND ON LEXINGTON ST WHEN MV#1 CAME ONTO THE WRONG SIDE OF THE ROAD, STRUCK HIM ON THE DRIVER SIDE, CAUSING HIM TO GO ONTO THE SIDEWALK AND TAKE DOWN A TRAFFIC LIGHT POLE. THERE WAS DAMAGE TO BOTH D/S, P/S, AND REAR OF MV#2. MV#3 HIT AND RAN FROM THE SCENE. NO ONE GOT A PLATE OR DESCRIPTION OTHER THEN POSSIBLY A PICK UP TRUCK. BOTH VEHICLES WERE TOWED BY TODY'S TOWING AND BOTH OPERATORS DECLINED MEDICAL ATTENTION. TRAFFIC OFFICER GAUDET TOOK PICTURES OF DAMAGE TO THE CITY PROPERTY. SEE INDEPENDENT WITNESS STATEMENT.
Keywords:
Crash, Pictures
Dcc:
Lane departure, Unknown
Report
url:
Image
url:
Latitude:
42.3577593
Longitude:
-71.2398573
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);