crash_reports
2 rows where latitude = "42.3646105"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-09
Time:
13:11
Address:
232 CALIFORNIA ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On October 9th, 2020 at approximately 13:11 hours while assigned to N491 I responded to the area of California St near Jasset St for a report of a MV crash. On my arrival I located both involved vehicles just east of the Koko Bakery, #232 California St. Operator of vehicle #1, a black Mercedes, ma reg. 9hf857 stated she was going E/B on California St when vehicle #2 pulled out into traffic from in front of the Koko bakery, #232 California St causing the crash. Operator#2 who was operating a 2004 grey BMW X3, ma reg. 976DW8, stated she was parked in front of #232 California St, Koko Bakery, was attempting to enter out into traffic E/B when she struck vehicle #1. Operator #2 admitted that she never looked back for oncoming traffic before pulling out from her parked position.
Keywords:
Crash
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3646105
Longitude:
-71.1977411
Location:
Case
number:
Date:
2021-10-09
Time:
07:58
Address:
232 CALIFORNIA
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 while proceeding East bound on California Street struck parked MV2. MV1 continued straight and struck parked MV3. Owner of MV2 and MV3 were notified and completed an exchange of information with owner of MV1 Driver MV1 transported via Medic #3 to Newton-Wellesley Hospital for evaluation. MV1 towed to Tody's and a towed motor vehicle form was completed and filed.
Keywords:
Hospital
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3646105
Longitude:
-71.1977411
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);