home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2022-04-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, 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:
22000342
Date:
2022-04-26
Time:
12:34
Address:
HIGHLAND ST & TEMPLE ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 4-26-22 AT APPROX. 1234HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF TEMPLE AND HIGHLAND ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING S-BOUND ON HIGHLAND ST. SHE STATES VEHICLE #2 ENTERED THE TRAFFIC LANE FROM TEMPLE ST. AND CUT HER OFF. SHE STARTED SHE STARTED BEEPING HER HORN REPEATEDLY AT WHICH POINT VEHICLE #2 STOPPED HIS VEHICLE ABRUPTLY AND SHE WAS UNABLE TO AVOID HITTING HIM. DRIVER STATES VEHICLE #2 STOPPED DELIBERATELY KNOWING SHE WOULD BE UNABLE TO AVOID HITTING HIM. DRIVER OF VEHICLE #2 STATES HE ENTERED HIGHLAND ST. FROM TEMPLE AND WAS TRAVELING S-BOUND. HE STATES VEHICLE #1 WAS BEEPING HER HORN REPEATEDLY. HE STATES HE STOPPED TO SEE IF THERE WERE A PROBLEM AT WHICH TIME VEHICLE #1 HIT HIS VEHICLE. VEHICLE #1 HAD MINOR FRONT END DAMAGE. VEHICLE #2 HAD MINOR REAR END DAMAGE. BOTH PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3457188
Longitude:
-71.2256908
Location:
Highland St & Temple St, Newton, MA 02465, USA
Case number:
22000343
Date:
2022-04-26
Time:
13:33
Address:
1450 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 4-26-22 AT APPROX. 1333HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1426 WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND PREPARING TO GET ON THE MASS PIKE . SHE STATES VEHICLE #2 TRIED TO CUT IN FRONT OF HER AND WHILE DOING SO SIDESWIPED HER VEHICLE. DRIVER OF VEHICLE #2 STATES SHE WAS GOING E-BOUND AND WAS ALSO PREPARING TO GET ON THE PIKE WHEN VEHICLE #1 TRIED TO CUT IN FRONT OF HER AND SIDESWIPED HER VEHICLE. VEHICLE #1 HAD FRONT RIGHT QTR. PANEL DAMAGE. VEHICLE #2 HAD LEFT DRIVER SIDE SCRAPES. BOTH PARTIES REPORTED NO INJURIES. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. DUE TO THE CONFLICTING STORIES AND THE MINOR DAMAGE OF EITHER VEHICLE I WAS UNABLE TO DETERMINE WHICH PARTY WAS AT FAULT FOR THE ACCIDENT. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3465495
Longitude:
-71.2315075
Location:
1450 Washington St, Newton, MA 02465, USA
Case number:
22000344
Date:
2022-04-26
Time:
17:01
Address:
345 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 stated he was attempting to pull into traffic when he made contact with MV2 causing minor damage. MV2 stated he was travelling straight when MV1 pulled out and hit him causing minor damage. No injuries reported & no tows required.
Keywords:
[]
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3568934
Longitude:
-71.1877425
Location:
345 Washington St, Newton, MA 02458, USA
Case number:
22000360
Date:
2022-04-26
Time:
14:50
Address:
191 DEDHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
MV2 was parked behind unoccupied MV1 facing Northbound, when MV2 attempted to pull out onto Dedham St. The front right bumper of MV2 struck the left rear of MV1. Minor damage to both vehicles. No injuries or tows.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3125048
Longitude:
-71.2025447
Location:
191 Dedham St, Newton Highlands, 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 327.54ms