crash_reports
2 rows where keywords contains "Hospital" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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:
Case
number:
Date:
2021-10-13
Time:
08:08
Address:
WASHINGTON ST & LOWELL AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 proceeding straight ahead on Westbound via Washington Street collided with MV2 negotiating a Northbound turn from Washington Street to Lowell Ave. Collision resulted in MV2 rolling and coming to rest on roof. Operator MV2 was entrapped in vehicle, Officer Tocci able to break the window and assist Operator out of vehicle. Operator MV2 transported to Newton Wellesley Hospital via Medic 2. MV1 and MV2 towed to Tody's. A towed motor vehicle form completed and filed.
Keywords:
Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
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);