crash_reports

Table actions

2 rows where dcc = "["Lane departure", "Unknown"]", intersection = 0 and keywords contains "Pictures"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000326
Date:
2019-03-29
Time:
10:45
Address:
1232 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated that he was traveling east on Washington St in the right hand lane in front of #1232 Washington St when his MV was struck by MV#2, who was also traveling east on Washington St in the left bound lane. The female operator of MV#2 pulled over initially, but then left the area. Operator #1 took a photograph of MV#2 and reports a female was operating Ma. Reg. 5HW272, a Toyt. Highlander. Mansfield PD notified and will have owner of MV#2 contact me.
Keywords:
Pictures
Dcc:
Lane departure, Unknown
Report url:
report
Image url:
image
Latitude:
42.3491307
Longitude:
-71.224465
Location:
1232 Washington St, West Newton, MA 02465, USA
Case number:
2100000279
Date:
2021-04-22
Time:
08:54
Address:
73 LEXINGTON
Speed limit:
30
Violation cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING NORTH BOUND ON LEXINGTON ST WHEN HE WAS STRUCK BY MV#3 CAUSING HIM TO HIT MV#2. THE OPERATOR OF MV#1 STATED MV#3 CAUSED THE ACCIDENT BUT DROVE AWAY. HE STATED THAT HE STRUCK MV#2 ON THE DRIVERS SIDE WHICH PUSHED HIM ONTO THE SIDEWALK TAKING DOWN A TRAFFIC SIGNAL POLE. THERE WAS DAMAGE TO THE D/S FRONT OF MV#1. THE OPERATOR OF MV#2 STATED THAT MV#1 HE WAS TRAVELING SOUTH BOUND ON LEXINGTON ST WHEN MV#1 CAME ONTO THE WRONG SIDE OF THE ROAD, STRUCK HIM ON THE DRIVER SIDE, CAUSING HIM TO GO ONTO THE SIDEWALK AND TAKE DOWN A TRAFFIC LIGHT POLE. THERE WAS DAMAGE TO BOTH D/S, P/S, AND REAR OF MV#2. MV#3 HIT AND RAN FROM THE SCENE. NO ONE GOT A PLATE OR DESCRIPTION OTHER THEN POSSIBLY A PICK UP TRUCK. BOTH VEHICLES WERE TOWED BY TODY'S TOWING AND BOTH OPERATORS DECLINED MEDICAL ATTENTION. TRAFFIC OFFICER GAUDET TOOK PICTURES OF DAMAGE TO THE CITY PROPERTY. SEE INDEPENDENT WITNESS STATEMENT.
Keywords:
Crash, Pictures
Dcc:
Lane departure, Unknown
Report url:
report
Image url:
image
Latitude:
42.3577593
Longitude:
-71.2398573
Location:
73 Lexington St, Auburndale, 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);