home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-08-29, dcc contains "Inattention" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, dcc, dcc_code, 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:
1900000885
Date:
2019-08-29
Time:
10:58
Address:
320 NEEDHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
On 08/29/19 at 10:58 hours, I responded to a three car motor vehicle accident at 320 Needham Street with no injuries reported. Operator of MV1 states she was heading straight ahead (WB) on Needham Street towards Christina Street. She states that she attempted to stop for the stopped traffic ahead of her by pushing on her brakes hard to no avail. She then rear ended MV2 and MV2 was pushed in to MV3. MV1 sustained moderate front end damage to the grille and hood area. MV2 sustained moderate rear end damage and MV3 sustained a minor dent/scratch to the rear end. All vehicles were still driveable.
Keywords:
Crash, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3069921
Longitude:
-71.2158644
Location:
320 Needham St, Newton, MA 02464, USA
Case number:
1900000890
Date:
2019-08-29
Time:
16:11
Address:
770 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 stated she was traveling straight on Centre St when vehicle 2 rear ended her. Vehicle 2 stated that there was light traffic and vehicle 1 was yielding in front of him and he couldn't stop quick enough and rear ended vehicle 1.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.345868
Longitude:
-71.18822
Location:
770 Centre St, Newton, MA 02458, USA
Case number:
1900000892
Date:
2019-08-29
Time:
16:31
Address:
716 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
OPMV#1 Was traveling Eastbound on Beacon St when she was struck by the OPMV#2 pulling out of the Gulf Gas Station located at 716 Beacon St. OPMV#1 Stated she was driving straight on Beacon St when a car pulled out of the gas station and collided with her vehicle. OPMV#2 Was pulling out of the Gulf Gas Station attempting to make a right turn onto Beacon St traveling Eastbound when he collided with the OPMV#1. OPMV#2 Stated he looked both ways before making a right turn but believes a utility pole blocked his view causing a blind spot, when he struck a vehicle driving on Beacon St..
Keywords:
[]
Dcc:
Failed to yield, Inattention
Report url:
report
Image url:
image
Latitude:
42.3306362
Longitude:
-71.1900994
Location:
716 Beacon St, Newton Centre, 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 313.421ms