home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc_code = "["18"]", intersection = 0 and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000044
Date:
2019-01-11
Time:
11:10
Address:
978 BOYLSTON ST
Speed limit:
10
Violation cited:
no
Narrative:
Veh #1 is a semi-trailer and was attempting to back up in the parking lot of #978 Boylston St-CVS when it collided with veh # 2. No damage to veh #1 Veh #2 stated he was attempting to go around veh #1 in the parking lot when veh #1 backed into him. Damage to veh #2 rear drivers side door.
Keywords:
[]
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3181167
Longitude:
-71.211237
Location:
978 Boylston St, Newton, MA 02461, USA
Case number:
1900000101
Date:
2019-01-23
Time:
14:07
Address:
165 NEEDHAM ST
Speed limit:
30
Violation cited:
yes
Narrative:
Leary was crossing Needham St southbound at the corner of the property between Stop and Shop and Jiffy Lube. She states that she was 1/4 of the way across the street when she was struck by MV1. The left side of her body(arm, hip) struck the right side of the MV. She fell to the ground. MV1 states that he was pulling out of the Stop and Shop driveway to turn right onto Needham St. He saw the pedestrian next to the snow bank on the right side of the driveway as he approached the end of the driveway. When he got to the end he did not see her anymore and assumed she had continued walking west on Needham St. He then turned right and felt the collision and then he saw her. He immediately pulled into the Jiffy Lube lot to check on her. I took pictures of the scene and the MV. They were TOT IT. After further investigation, on 2/7 the operator was cited for 90/14 failure to stop for pedestrian. I spoke with Kenneth via phone and advised him of the update. The citation was mailed to him. I am charging for 90/14 failure to stop for a pedestrian. On Wednesday February 6, the operator information of this report was ammended to show the correct operator information.
Keywords:
Citation, Ped, Phone, Pictures, Snow, Walk
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
165 Needham St, Newton, MA 02461, 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 283.262ms