home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2021-04-06, hit_run = 0 and "retrieved" is on date 2021-04-12

✎ 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:
2100000235
Date:
2021-04-06
Time:
10:03
Address:
LEXINGTON ST & RUMFORD AVE
Speed limit:
30
Violation cited:
yes
Narrative:
The operator of MV1 (ma reg 4018XZ) stated he was traveling SB when stopped at the intersection of Lexington Street and River Street waiting for the light to turn green. Operator of MV1 stated once the light turned green he continued straight through the intersection and was struck by a vehicle attempting to turn left. The operator of MV2(ma reg 7SR379) stated she was traveling NB when she stopped at the intersection of Lexington Street and River Street. Operator of MV2 stated she attempted to turn left onto Rumford Ave when her vehicle was struck by MV1. Both vehicles had significant damage and required tow's. Tody's was called to the scene to tow both vehicles. Neither driver reported any injuries. The airbag from MV1 was deployed so I had dispatch call the medics to the scene for an evaluation. Medic 5 and engine 1 arrived on scene. Both parties were evaluated and signed refusals. The operator of MV2 has been cited (MA Citation#958265AA) 89/8 Failure to yield at intersection.
Keywords:
Airbag, Citation
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.357825
Longitude:
-71.2396119
Location:
Rumford Ave & Lexington St, Newton, MA 02465, USA
Case number:
2100000237
Date:
2021-04-06
Time:
17:15
Address:
CRAFTS ST & MAGUIRE CT
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle one was turning right out of Maguire Court onto Crafts Street when he thought vehicle two was driving straight and didn't look until he made contact with the back of vehicle two. Vehicle two was slowing and stopped on Craft St trying to take a left hand turn onto Clinton St. Vehicle one rear ended vehicle two.
Keywords:
[]
Dcc:
Followed too closely, Inattention
Report url:
report
Image url:
image
Latitude:
42.3551192
Longitude:
-71.2018354
Location:
Maguire Ct & Crafts St, Newton, MA 02458, 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 354.178ms