crash_reports
4 rows where "datetime" is on date 2019-09-17 and keywords = "[]"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-09-17
Time:
14:28
Address:
895 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Ana Fernandez-Mastrogiovanni parked vehcile #2 at 895 Watertown St at apporx 100 hrs. Ana went back to her vehicle and saw that someone struck her left front fender and ripping off the front bumper. No witness, no injures. vehicle #1 is unknown. Vehicle #2 private tow.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.351319
Longitude:
-71.2220388
Location:
Case
number:
Date:
2019-09-17
Time:
17:13
Address:
ELLIS ST & BOYLSTON STREET UNDER BRIDGE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that he was traveling south on Ellis Street when Vehicle #2 exited from the side road and struck his vehicle. Vehicle #1 sustained heavy front end damage and was towed from the scene by Todys Towing. Operator reports no injuries. Passenger in Vehicle #1 was evaluated by Newton Medics and signed a patient refusal. Operator of Vehicle #2 stated that she was exiting the side road and could not see around the Rt 9 Bridge so she slowly pulled forward and struck Vehicle #1 as it drove by. Vehicle #2 sustained heavy front end damage and was privately towed from the scene by AAA. Operator reports no injuries. It should be noted that the Operator of Vehicle #1 did not have a stop sign from his direction of travel.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3167943
Longitude:
-71.2269407
Location:
Case
number:
Date:
2019-09-17
Time:
17:22
Address:
1 JACKSON RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of Vehicle #1 stated that he returned to his vehicle to find fresh damage to the driver's side door, and the driver's side quarter panel. No video, or signs of the other vehicle were left at the scene. The damage on the vehicle appears consistent with that of another vehicle side-swiping it from the opposite direction.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3612213
Longitude:
-71.1928263
Location:
Case
number:
Date:
2019-09-17
Time:
15:25
Address:
141 NEEDHAM ST
Speed
limit:
0
Violation
cited:
no
Narrative:
On Tuesday 9/17/19 at approximately 1525 hourts I was dispatched to the parking lot in front of Sierra Tradiing Post (141 Needham Street #50) for a report of a past hit and run. Upon arrival I spoke with Lillian ORTIZ-NADER who states that at approximately 2pm she parked her car in a parking space. She came back to her car at 3:25pm and noticed scratches to the drivers side rear fender, rear door and front door. She states that none of this damage was there before she parked the vehicle.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);