crash_reports
2 rows where "datetime" is on date 2022-07-19 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-19
Time:
13:40
Address:
2014 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Motor Vehicle # 1 stated they were traveling Eastbound on Washington Street and used their right turn signal and started slowing down to take a right turn into the main entrance of Newton Wellesley Hospital and was struck from behind by Motor Vehicle # 2 causing moderate rear end damage. Operator of Motor Vehicle #2 stated that he was traveling Eastbound on Washington Street and moved into the right lane in an attempt to get out of the ambulances way which had its lights and sirens activated. Operator of Motor Vehicle #2 stated that Motor Vehicle #1 stopped short and he did not have enough time to break and struck the vehicle from behind. Motor Vehicle # 2 sustained no damage. All parties signed medical refusal forms.
Keywords:
Ems, Hospital, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-19
Time:
16:39
Address:
PARK ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
It is believed the operator of MV1 suffered a medical episode, subsequently crossing all 3 lanes of traffic, jumping the curb and striking a city tree. Tody's Towing responded and removed the vehicle without incident. Fallon Ambulance transported the operator of MV1 to St Elizabeth's Hospital for an evaluation. See Incident Report 22025503 for further information.
Keywords:
Ems, Hospital, Tree
Dcc:
Physical impairment
Report
url:
Image
url:
Latitude:
Longitude:
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);