home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "date" is on date 2019-12-09, intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900001263
Date:
2019-12-09
Time:
07:53
Address:
1659 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
On 12/9/2019 at approx 0753hrs while assigned to 497 I responded to the area of Commonwealth Av and Temple St for a report of a 2 car collision w/o injury. Upon arrival I observed Ma Reg 692NB8 pulled to the side with flashers on in front of 1650 Commonwealth Av. i spoke with the operator Kai CHEN who stated he was stopped in traffic in front of 1650 Commonwealth Av when the white mini van Ma Reg 7ZB211 backed out of the driveway at 1650 Commonwealth Av striking his car. I spoke with the operator of the mini van , James MURPHY who stated he was backing out of the driveway and did not see CHEN colliding with his car.
Keywords:
[]
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3397226
Longitude:
-71.2348182
Location:
1659 Commonwealth Avenue, Newton, MA 02465, USA
Case number:
1900001265
Date:
2019-12-09
Time:
09:36
Address:
2345 COMMONWEALTH AVE
Speed limit:
5
Violation cited:
no
Narrative:
The operator of MV#1, identified as Frank Vanmierlo states that he parked his MV in the Marriott parking area at approx. 7:45AM on 12/9/19. When he returned to his unoccupied MV he found MV#2 making contact with the rear of his MV and his MV was now moved slightly from its original parking spot. MV#2 was unoccupied when Mr. Vanmierlo returned to his MV and we could not locate the registered owner on the Marriott property. I then spoke with the operator of MV#2 by telephone, identified as Jonathan Lang. Mr. Lang stated that he parked MV#2 in the Marriott parking area at approx. 7:45AM and was not involved in a crash with any other MV while in the parking area. Mr. Lang states that there was another MV parked and unoccupied in the parking space in front of him when he turned left into his parking spot. Marriott security states that there are no cameras video taping the exterior of the Marriott including the parking area. Interior videotape provided by the Marriott confirms that Mr. Lang entered the front lobby before Mr. Vanmierlo. Upon further investigation it was determined that an unknown person had informed Mr. Vanmierlo that a Red Acura had struck his MV while parked in the parking area. Mr. Vanmierlo also confirmed that there was new damage to the front of his MV. No other information available at this time. It would appear at this time that unknown MV#3 backed into the front of MV#1, pushing MV#1 into the front of MV#2.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.346364
Longitude:
-71.2584662
Location:
2345 Commonwealth Avenue, Newton, MA 02466, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 360.66ms