home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2022-05-20, keywords contains "Moderate" and "retrieved" is on date 2022-05-23

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000428
Date:
2022-05-20
Time:
14:47
Address:
712 DEDHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV#1 stated he was stationary at the red traffic light in front of 712 Dedham St eastbound when he observed MV#3 approaching him from behind not slowing down and striking MV#2 which in turn pushed MV#2 into MV#1. MV#1 sustained moderate damages to its rear end. There were no reported injuries to the operator of MV#1. The operator of MV#1 was evaluated by Newton Paramedics and signed a patient refusal of treatment. The operator of MV#2 stated she was stationary at the red traffic light on Dedham St eastbound directly behind MV#1 when she was struck by MV#3 from behind which in turn pushed MV#2 into MV#1. MV#2 sustained heavy front and rear end damages. The operator of MV#2 stated she had some neck pain. The operator of MV#2 was evaluated by Newton Paramedics and signed a patient refusal of treatment. The operator of MV#3 stated she made a left turn from Rosalie Rd onto Dedham St eastbound when MV#2 abruptly stopped. The operator of MV#3 stated she could not stop in time and struck MV#2, pushing it into MV#1. MV#3 sustained heavy front end damage. The operator of MV#3 stated as a result of the crash, her chest struck her steering wheel. The operator of MV#3 was transported to the Beth Israel Needham by Newton Paramedics. Tody's Towing took possession of MV#3.
Keywords:
Crash, Moderate
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3011267
Longitude:
-71.1885979
Location:
712 Dedham St, Newton, MA 02459, 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 600.179ms