crash_reports
4 rows where date = "2019-07-10"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-10
Time:
07:33
Address:
HAMMONDSWOOD RD & HAMMOND ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Georgi Simov states that he was operating M/V #2 N/B on Hammond St. Simov states that he noticed vehicle #1 was at a stop sign on Hammondswood Rd, who then proceeded to cross the intersection striking him in the left front. Joy Lewis was operating vehicle #1 on Hammondswood Rd. Lewis states that she was at the stop sign and did not see any cars. Lewis states that when she attempted to go through the intersection vehicle #2 struck her car. No injuries no tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3351954
Longitude:
-71.1775586
Location:
Case
number:
Date:
2019-07-10
Time:
09:23
Address:
CENTRE ST & PAUL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she was travelling straight ahead on Centre St N/B slowing down with her right signal on preparing to pull over in front of 1400 Centre St beyond the corner of Paul St. #1 stated she was struck passenger broadside by Mv#2 exiting from Paul St. #1 sustained passenger side damage and towed by Tody's. #1 operator signed a patient refusal. #2 operator stated he came to a stop at the end of Paul St preparing to turn left on Centre St S/B. #2 stated he assumed #1 was turning right on Paul St with her signal on. #2 proceeded left onto Centre St as #1 was passing by and struck #1 broadside. #2 sustained front end damage and towed by Tody's. #2 operator also signed a patient refusal.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.326492
Longitude:
-71.197893
Location:
Case
number:
Date:
2019-07-10
Time:
15:18
Address:
CARLETON ST & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated she was attempting to turn left onto Centre Street from Carleton Street. Opr stated a vehicle in the first lane stopped for her and let he turn. V2 was traveling and did not see V1 and V1 made contact with V2. Opr of V1 signed a patient refusal and V1 sustained damage to the right front side and was towed. Opr of V2 stated he was traveling south on Centre Street. A short time later, V1 was attempting to turn, did not see him, and made contact with him. V2 sustained minor damage to the right side. V2 was not towed.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.359124
Longitude:
-71.1851825
Location:
Case
number:
Date:
2019-07-10
Time:
13:06
Address:
63 KENWOOD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 7/10/2019 at approx 1306Hrs while assigned to 497 I responded to 57 Kenwood St for a report of a vehicle backing into a gas light pole. Upon arrival I met with a worker for A Blade of Grass Landscaping Company, Taidy GONZALES. GONZALES stated she was backing her company truck into the driveway of 57 Kenwood Rd when she taped the gas light pole belonging to The City of Newton causing the glass globe to crack. NFD responded and turned the gas off.
Keywords:
Fire
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3356174
Longitude:
-71.2024286
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);