crash_reports
2 rows where "date" is on date 2021-07-27, hit_run = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-27
Time:
09:39
Address:
FENWICK RD & TAMWORTH RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 7/27/2021 at approx 0939hrs while assigned to 497 I responded to the intersection of Fenwick Rd and Tamworth Rd for a report of a two car crash with possible injuries. Upon arrival I observed Ma Reg 1CNR59 being operated by Svertlana Savenco pinned between the southern curb of Tamworth facing Eastbound and Ma Reg 62EZ69 being operated by Renata Pawska. I spoke with Renata who stated she had been travelling NB on Fenwick Rd intending to turn right onto Tamworth when she saw Tamworth east of Fenwick was shut down due to a detour, at that time Renata turned left colliding with Svetlana. I spoke with Svetlana who stated she was travelling straight ahead when Renata turned into her. Both vehicles towed by Todys, NFD put down speedy dry for fluids, Renata signed a refusal with Fallon Ambulance, Svetlana was transported by Fallon complaining of leg and back pain.
Keywords:
Crash, Ems, Fire, Speed
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.322375
Longitude:
-71.228183
Location:
Case
number:
Date:
2021-07-27
Time:
14:49
Address:
513 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/27/2021, while assigned to N494, I, Officer Conary, spoke with DEALE, Cathy (Operator of MV1) over the phone about a past hit and run. DEALE explained to me that she parked Westbound on Washington Street in front of 513 by the fire hydrant. Between 1200-1400 MV1 was hit on the driver side, and the mirror broke off. Operator of MV1 did not see any other vehicle standing by, she left the area and notified Newton Police. Operator of MV1 sent me pictures to confirm the damage. I went back to the area of where the accident was reported and confirmed glass and a pieces of a mirror on the side of the road.
Keywords:
Crash, Fire, Phone, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3552254
Longitude:
-71.1940066
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);