home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "date" is on date 2019-10-16 and keywords contains "Pictures"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, violation_cited, 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:
1900001049
Date:
2019-10-16
Time:
09:04
Address:
BRANDEIS RD & GREENWOOD ST
Speed limit:
25
Violation cited:
yes
Narrative:
OPER OF MV#1 WAS ON BRANDEIS RD, AND TURNING LEFT ONTO GREENWOOD ST. OPER OF MV#1 CUT THE TURN TOO SHARP AND LIGHTLY STRUCK THE STOP SIGN POLE CAUSING IT TO TILT. CITY NOTIFIED FOR REPAIRS AND THE SIGN WAS PHOTOGRAPHED. MV1 SUSTAINED MINOR FRONT DAMAGE. CITATION #T2081171 WAS ISSUED TO THE OPERATOR FOR MARKED LANES VIOLATION.
Keywords:
Citation, Pictures
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3099488
Longitude:
-71.184323
Location:
Brandeis Rd & Greenwood St, Newton, MA 02459, USA
Case number:
1900001051
Date:
2019-10-16
Time:
14:34
Address:
CHERRY ST & WEBSTER ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 10/16/2019 at 1434hrs, I responded to Cherry St at Webster St for a two vehicle accident. The operator of MV1 (MA Reg: 519PW3) stated that she was travelling eastbound on Webster St and was proceeding through the intersection of Cherry St when the accident occurred. MV1 stated that she had the green light while going through the intersection. The operator of MV2 (MA Reg: 1BYL34) stated that she was on Cherry St travelling southbound and had a green light at the Webster St intersection. MV2 stated that she believed she had a green light and the accident occurred when she entered the intersection. MV1 sustained heavy front end damage. MV2 sustained passenger side damage. Both vehicles were towed by Tody's. The operator of MV1 was transported to NWH for further evaluation. After the initial collision MV1 was directed into the traffic light and bushes at the southeast corner of the intersection. Pictures were taken of the damage by Ofc. Ferguson. MV2 was issued Mass Uniform Citation T2079681 (c89/s9 - Failure to Stop Red Light). It should be noted that the accident caused damage to the bushes of the business at 432 Cherry St. I contacted the property owner, Dennis Cameron, and made him aware for insurance purposes.
Keywords:
Bus, Citation, Crash, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.350159
Longitude:
-71.228704
Location:
Cherry St & Webster St, Newton, MA 02465, USA
Case number:
1900001053
Date:
2019-10-16
Time:
22:48
Address:
1201 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of vehicle number 1 stated she was traveling westbound on Washington Street in the area of 1201 Washington Street when a tree limb fell from a city tree striking her patrol car. Several pictures where taken of both the city tree and the damage to patrol unit 504. The operator of vehicle number 1 was not injured. Vehicle number 1 sustained moderate damage to the passengers side mirror as well as a cracked windshield.
Keywords:
Moderate, Pictures, Tree
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3494627
Longitude:
-71.2228721
Location:
1201 Washington St, Newton, MA 02465, 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 815.087ms