crash_reports
1 row where dcc = "["Inattention"]", keywords contains "Speed" and "retrieved" is on date 2022-06-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-09
Time:
15:53
Address:
461 WOLCOTT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-9-22 AT APPROX. 1553HRS. WHILE WORKING N497 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT 469 WOLCOTT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WOLCOTT ST. HE STATES VEHICLE #2 WAS BACKING OUT OF 469 WOLCOTT AT A HIGH RATE OF SPEED. HE STATES HE BEEPED TO MAKE HIS PRESENCE KNOWN BUT WAS STILL HIT IN THE LEFT FRONT QTR. PANEL BY VEHICLE #2. HE STATES AFTER THE CRASH VEHICLE #2 SPED OFF TOWARD LEXINGTON AT A HIGH RATE OF SPEED. DRIVER OF VEHICLE #1 STATES HE GOT THE PLATE NUMBER OF VEHICLE #2 ( MA REG : 225LZ2 ). AS OF THE WRITING OF THIS REPORT I HAVE BEEN UNABLE TO MAKE CONTACT WITH THE OWNER OF VEHICLE #2. VEHICLE #1 HAD MINOR LEFT FRONT END QTR PANEL DAMAGE. HE REPORTED NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.348988
Longitude:
-71.2467486
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);