home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc_code = "["4"]" and keywords contains "Citation"

✎ 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), dcc_code (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000003
Date:
2019-01-02
Time:
09:32
Address:
ALBEMARLE RD & CRAFTS ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle one stated that while driving east bound on Crafts St at Albemarle Rd vehicle two darted out into the path of his vehicle from the south bound lane of Albemarle Rd. Operator of vehicle one stated that he attempted to avoid a crash with vehicle two by applying his vehicle's brakes and swerving to his left. Operator of vehicle one stated that his vehicle's front bumbler made contact with vehicle two's front driver's side fender and bumper. Operator of vehicle one stated that he was not injured his vehicle was not towed. Operator of vehicle two stated that he had stopped at the stop sign in the north bound lane of Albemarle Rd at Crafts St. Operator of vehicle two stated that he saw vehicle one driving east bound on Crafts St and he pulled out into the east bound lane of Crafts St in font of vehicle one believing that he had enough time to cross over Crafts St . Operator of vehicle two stated that vehicle one's front bumper struck his vehicle's front driver's side. Operator of vehicle two stated that he was not injured and his vehicle was not towed. Passenger in vehicle two Zbigniew Saletnik stated that he was not injured and had little recollection of the crash. All Streets are public ways in the city of Newton. I issued operator of vehicle two MA Citation T0340520 and cited him for MLG 89/8 , failure to yield. I took photos of the vehicles and crash area, the disk was downloaded by the NPD's IT bureau.
Keywords:
Citation, Crash, Pictures
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Crafts St & Albemarle Rd, Newton, MA 02460, USA
Case number:
1900000032
Date:
2019-01-09
Time:
07:44
Address:
BROOKLINE ST & DEDHAM ST
Speed limit:
30
Violation cited:
yes
Narrative:
OPERATOR #1 WAS ON DEDHAM ST, HEADING EASTBOUND AT THE INTERSECTION OF BROOKLINE ST. SHE WAS ATTEMPTING TO TAKE A LEFT HAND TURN ONTO BROOKLINE ST. SHE STATES THAT THE CAR IN THE OPPOSITE DIRECTION OF HER STOPPED, AN INDICATION THAT THE DRIVER WAS LETTING HER TAKE A LEFT HAND TURN. SHE TOOK THE LEFT HAND TURN ONTO BROOKLINE ST AND STRUCK VEHICLE #2 AS IT WAS PASSING BY. VEHICLE #2 IN TURN REAR ENDED VEHICLE #3. VEHICLE #3 OPERATOR TRANSPORTED TO FAULKNER HOSPITAL WITH MINOR INJURIES. VEHICLE OPERATOR #1 STATES THAT HER VIEW WAS OBSTRUCTED, AND THAT SHE WAS TRAVELING EASTBOUND THE SUN WAS IN HER EYES AND HER VIEW WAS OBSTRUCTED. VEHICLE #2 AND #3 WERE TOWED BY TODYS TOWING OF NEWTON. VEHICLE #1 OPERATOR ISSUED CITATION T0645456 BY MAIL, FOR FAILING TO YIELD TO ONCOMING TRAFFIC.
Keywords:
Citation, Hospital, Solar
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.2989668
Longitude:
-71.1865087
Location:
Brookline St & Dedham St, Newton, MA 02459, USA
Case number:
1900000065
Date:
2019-01-18
Time:
12:01
Address:
2014 WASHINGTON ST
Speed limit:
30
Violation cited:
yes
Narrative:
The operator of MV#1 stated that she was waiting to exit NWH at the east exit/entrance. When her light turned green she proceeded to enter Washington St and her MV was struck by MV#2, who was traveling south on Washington St. The operator of MV#2 stated that she was traveling south on Washington St approaching NWH and had a green light to proceed thru the intersection at the east exit/entrance. An independent witness stated that she was in a MV directly behind MV#1 at the east exit when she observed their traffic light turn green and both her and MV#1 proceeded into the intersection. The witness then observed MV#2 traveling south on Washington St enter the intersection crashing into MV#1 while their light was still green. Operator #2 cited for a red light violation.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, 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 493.624ms