crash_reports
2 rows where "datetime" is on date 2021-06-23, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-23
Time:
09:22
Address:
1314 CENTRE ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On Wednesday 6/23/21 at approx 0922hrs, while assigned to N495, I responded to 1314 Centre St, Holly's Cleaners, for a single car MVA into a building. There I met the operator of MV1, Ellen Silver, who stated she was just pulling into the parking lot when she stepped on the brakes but the car did not stop. MV1 made contact with the building damaging a wall and breaking a window. Newton City Inspector Jeff Johnson arrived on scene and deemed the building to be safe. Medics evaluated the operator who signed a refusal. Pictures were taken by Off. Wilson. Vehicle was towed by Tody's.
Keywords:
Pictures
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3286696
Longitude:
-71.1953045
Location:
Case
number:
Date:
2021-06-23
Time:
08:47
Address:
12 MYRTLE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was traveling northbound on Myrtle Street when it crashed into a low hanging City of Newton tree in front of 12 Myrtle Street. As a result of the crash the tree completely uprooted and ripped out the telephone/internet services to 10 and 12 Myrtle Street, as well as 1560 and 1554 Washington Street. MV1 sustained moderate front/top passengers side damage. The City of Newton Forestry division was able to respond and remove the downed tree. I took five pictures of the damage to City property and submitted them to the IT bureau.
Keywords:
Crash, Moderate, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.344429
Longitude:
-71.2341087
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);