crash_reports
2 rows where "datetime" is on date 2020-09-21, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-21
Time:
12:05
Address:
36 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
When I arrived at the single MV crash on Grove St near Central St, the operator was being attended to by a bystander because her head was bleeding. The operator, identified as Ida Cain stated she didn't know what happened, but that she never lost consciousness. Operator still wearing her seatbelt when I arrived. I observed MV#1 to be crashed into a telephone pole and it would appear that MV#1 was traveling south on Grove St prior to the crash. No witnesses to crash. Operator transported to NWH for a head injury and her MV was towed by Todys.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3449287
Longitude:
-71.2464701
Location:
Case
number:
Date:
2020-09-21
Time:
14:16
Address:
1750 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday September 21st, 2020 while in N526 I responded to Newton Fire Station #2 located at 1750 Commonwealth Ave for a past accident involving Newton Fire Ladder #1 and a Cataldo Ambulance. The accident is reported to have occurred on Thursday September 17th 2020 at 10:00am. At the time of the accident the weather was partly cloudy and the road surface was dry. Captain Roche stated he was working at the station that day when a Cataldo Ambulance truck MA AMR:AMB41 slowly backed up and struck the top of the ladder on the Ladder Truck#1 MA MVN: MF463. Ladder #1 was parked and unoccupied at the time in front of the Fire Station. At the time no damage was reported on either apparatus. Today damage was noticed on the top part of the ladder. Pictures were taken of a crack and some damage to the ladder. I spoke with the operator of the ambulance identified as EMT James Perry (S14785886 ) who stated on Thursday at around 10:00am he was delivering spare parts to another ambulance and was slowly backing up in front of the Fire Station. James stated he was going about 2MPH when he bumped into the front of Ladder #1. James stated there was no damage reported to either apparatus at the time. This minor accident occurred on City of Newton Property in the driveway of Fire Station #2. No injuries were reported. Pictures of Ladder #1 were submitted to the IT Bureau.
Keywords:
Crash, Ems, Fire, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3405731
Longitude:
-71.2384715
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);