home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-09-22 and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, violation_cited, 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:
1900000967
Date:
2019-09-22
Time:
11:53
Address:
1247 CENTER STREET
Speed limit:
25
Violation cited:
yes
Narrative:
MV#1 was entering Center Street from a parking stall when he was struck by MV#2. -OpMV#1 stated he was entering Center Street from a parking stall when he was struck by MV#2. He stated he observed a far distance buffer between him and MV #2. MV#1 was occupied by two passengers. -OpMV#2 stated she was traveling north on Center Street. She stated she observed a MV#1 entering the roadway. She stated MV#1 pulled out suddenly in front of MV #2. She collided with MV#1. - I observe the damage to both vehicles. I observed the heavy damage and deep gouge to the driver(cid:31)s side door of MV#1. The gouge had cut open the outer panel of the door revealing the mechanical components inside the door. OpMV#1 stated he could not open the door, but the vehicle was drivable. I next conducted an inspection of the exterior damage of MV#2. I observed that the plastic bumper was separated from the frame and several cracks and breaks on the bumper. I further observed damage to the wheel well panel. OpMV#2 stated the vehicle was drivable. -There were no injuries reported at the scene and all parties declined medical assistance. Neither vehicle was towed from the scene. OpMV#1 was cited (T2015553) for Failure to Use Care Entering the Roadway.
Keywords:
Citation
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3303452
Longitude:
-71.1947576
Location:
1247 Centre St, Newton Centre, MA 02459, USA
Case number:
1900000968
Date:
2019-09-22
Time:
16:01
Address:
51 HANCOCK ST
Speed limit:
25
Violation cited:
no
Narrative:
The owner of MV#1 states he parked his vehicle across the street from 51 Hancock Street at approx. 1300 hrs. today. He went back to his vehicle at approx. 1530 hrs. and noticed someone had struck it and did not make any attempts to leave their information.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.344551
Longitude:
-71.2499505
Location:
51 Hancock St, Auburndale, MA 02466, USA
Case number:
1900000969
Date:
2019-09-22
Time:
14:41
Address:
2366 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator#1 stated she was going W/B on Washington St when she attempted to make a left turn into #2366 Washington St,, Lower Falls Wine parking lot but was struck by vehicle #2. Operator #2 stated he was going E/B on Washington St just passing Concord St intersection when vehicle #1 turned left in front of him causing the crash.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3252081
Longitude:
-71.2581459
Location:
2366 Washington St, Newton Lower Falls, 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);
Powered by Datasette · Queries took 351.641ms