crash_reports

Table actions

1 row where "datetime" is on date 2019-08-07, intersection = 0 and keywords contains "Phone"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000830
Date:
2019-08-07
Time:
11:40
Address:
2014 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On 8/7/2019 at approx 1140hrs while assigned to 497 I responded to 2014 Washington St, NWH west entrance for a report of a two car crash without injuries. Upon arrival I spoke with the operators of Ma Reg 2GF281 Kira WIRSIG and Ma Reg LV56933 Yevhen ROITBERH. WIRSIG stated she was travelling straight ahead in the right EB lane when ROITBERH turned right into her vehicle from the left EB lane causing the collision. ROITBERH stated he was turning right into NWH from the right EB lane when WIRSIG attempted to pass him on the right . WIRSIGS passenger Christopher BERRY agreed with her version. ROITBERH had photos on his phone of his vehicle in the right lane turning into NWH which he claims show he had the right of way.
Keywords:
Crash, Phone, Pictures
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, 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);