crash_reports
2 rows where "datetime" is on date 2019-06-28, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-28
Time:
12:54
Address:
350 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 6/28/2019, I responded to area of 350 Chestnut St for a a motor vehicle accident. The operator of MV1 ( Ma. Reg: DEB5) stated that they were stopped in traffic southbound on Chestnut St. MV1 stated that they were then rear ended by MV2 while they were stopped in traffic. The operator of MV2 (Ma Reg: S81436) stated that he was stopped in traffic southbound on Chestnut St behind MV1. MV2 stated that he saw the light at Commonwealth Ave turn green and started accelerating. MV2 stated that he collided with the rear end of MV1. All parties involved were checked by medics and signed patient refusals. No vehicle needed to be towed. MV1 sustained damage to the rear. MV2 sustainted no damage.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3376063
Longitude:
-71.2230578
Location:
Case
number:
Date:
2019-06-28
Time:
17:29
Address:
101 WALKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/28/2019, while assigned to West Newton, I, Officer Conary, met with Owner of MV1 for a report of a past hit and run accident. Owner of MV1 explained to me that at approximately 0800 hours they parked MV1 on Walker Street on the side of the road. At 1700 hours, they observed a dent on front right bumper. There was a note left that stated "a green van hit your car and scraped - License plate C49807". There was no additional information. The registration comes back to a party out of Somerville MA, Frank Sarno Jr. Somerville PD was contacted to check the residence. They left a note to have Sarno call Newton Police. Investigation is still ongoing until all parties involved have been contacted.
Keywords:
Crash, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3511713
Longitude:
-71.213219
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);