crash_reports
2 rows where "datetime" is on date 2019-05-21 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-21
Time:
08:14
Address:
COMMONWEALTH AVE & GRANT AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
Bicyclist was traveling north on Grant Ave with traffic on the right side of the cars. He was intending on traveling straight across Comm Ave. The unknown silver BMW who was traveling next to the bicyclist turned right onto Comm Ave eastbound and struck the bicyclist with rear right part of the car. The BMW continued east on Comm Ave. The bicyclist was knocked from his bike and sustained minor cuts to his legs. His bike was not damaged. He refused medical attention and left the scene prior to amb arrival. No pictures were taken because he left before I could take them.
Keywords:
Bike, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.336511
Longitude:
-71.1856504
Location:
Case
number:
Date:
2019-05-21
Time:
14:35
Address:
709 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 5-21-19 AT APPROX. 1435HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE HIT AND RUN ACCIDENT. UPON ARRIVAL AT 709 WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING W-BOUND ON WASHINGTON ST WHEN SHE WAS SIDESWIPED BY A VEHICLE THAT WAS TO HER RIGHT. AFTER MAKING CONTACT VEHICLE #2 FLED THE SCENE. PASSENGER IN VEHICLE #1 WAS ABLE TO GET A LICENSE PLATE ( MA REG: 5CN162 ). SHE DESCRIBED THE FLEEING VEHICLE AS A TAN JEEP. A REGISTRY CHECK REVEALED THE VEHICLE TO BE A TAN JEEP COMPASS. ATTEMPTS TO CONTACT THE OWNER OF VEHICLE #2 BY PHONE WERE UNSUCCESSFUL. WILL TRY AGAIN ON NEXT SHIFT. ALL PARTIES IN VEHICLE #1 REPORTED NO INJURIES. VEHICLE #1 HAD RIGHT SIDE VEHICLE SCRAPES. VEHICLE #1 WAS STILL OPERATIONAL AND LEFT THE SCENE WITH NO FURTHER INCIDENT. OWNER OF VEHICLE #1 WAS ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3528182
Longitude:
-71.2026607
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);