crash_reports
3 rows where date = "2020-10-05"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-05
Time:
12:53
Address:
1763 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/05/20 Sgt Giardina notified me that he was flagged down by a person who wished to remain anonymous that stated they had seen a niisan maxima strike a tree and two trash barrels in front of 1763 Commonwealth Ave. On arrival I saw two City of Newton trash barrels destroyed and a city tree down on its side on the sidewalk. There were skid marks going back out onto the road westbound on Commonwealth Ave. I was able to notify the homeowner, Melissa Woythaoer who stated she was upstairs and never heard anything. Units canvassed the area with negative results. Officer Gaudet took pictures of the damage.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.341503
Longitude:
-71.2385206
Location:
Case
number:
Date:
2020-10-05
Time:
15:31
Address:
719 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was travelling WestBound on Washington St when her vehicle was struck by Vehicle #2 when it drifted into her lane. The operator of Vehicle #2, a Cataldo Ambulance, stated that the vehicle was struck by Vehicle #1 when it drifted into her travel lane. All involved parties declined medical attention.
Keywords:
Ems
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3527843
Longitude:
-71.2030088
Location:
Case
number:
Date:
2020-10-05
Time:
17:51
Address:
414 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that he was pulling out of the driveway at 414 Watertown St when he was struck by Vehicle #2, a Vespa scooter. He stated that a vehicle parked on the side of the road may have blocked his view of the scooter. The operator of Vehicle #2 stated that he collided with Vehicle #1 as it was pulling out of the driveway.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3597
Longitude:
-71.2022894
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);