home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2019-08-28, intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, keywords, 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:
1900000879
Date:
2019-08-28
Time:
05:48
Address:
29 CENTRE ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 operator states she was driving in the left lane going eastbound on Centre St heading towards Charles Banks Rd when MV2 hit her car on the right side. MV1 operator reported general pain and shock from accident. Medics responded and a refusal was signed. MV2 operator states he was driving eastbound on Centre St when he missed his left turn to go over the bridge heading towards Watertown. He then attempted to make an illegal left turn at the next set of lights but did not see MV1 in left lane. MV2 then hit MV1. Damage was observed on front left of MV2. I then cleared without further incident.
Keywords:
Crash
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3298184
Longitude:
-71.093395
Location:
29 Centre St, Boston, MA 02119, USA
Case number:
1900000880
Date:
2019-08-28
Time:
14:43
Address:
367 CALIFORNIA ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 8-28-19 AT APPROX. 1443HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 367 CALIFORNIA ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON CALIFORNIA ST. WHEN VEHICLE #2 ENTERED THE TRAFFIC LANE AND HIT HIM ON THE RIGHT SIDE OF HIS VEHICLE. VEHICLE #2 STATES HE WAS PARKED IN FRONT OF 368 CALIFORNIA ST. AND WAS PREPARING TO ENTER THE TRAFFIC LANE GOING E-BOUND ON CALIFORNIA. DRIVER STATES AS HE ENTERED THE TRAFFIC LANE HE WAS UNABLE TO AVOID HITTING VEHICLE #1. BOTH DRIVERS STATED THERE WAS A LARGE BOX TRUCK PARKED BEHIND VEHICLE #2 AND THEY DID NOT SEE EACH OTHER UNTIL THEY CRASHED. VEHICLE #1 HAD RIGHT SIDE VEHICLE DAMAGE. VEHICLE #2 HAD LEFT FRONT END VEHICLE DAMAGE. ALL VEHICLES WERE STILL OPERATIONAL AND DID NOT REQUIRE TOWS. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Crash
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.365345
Longitude:
-71.203937
Location:
367 California St, Newton, MA 02458, USA
Case number:
1900000881
Date:
2019-08-28
Time:
16:10
Address:
297 DERBY ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle owner states he parked MA reg 3DH161 on the opposite side of the road from 297 Derby St around 0100 hrs this morning. Around 1530, he came out and noticed moderate damage to the front left corner of the vehicle. No tow required at this time, as the vehicle is parked legally and owner has his own tow coming. Area canvassed with negative results.
Keywords:
Moderate
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3607095
Longitude:
-71.2358895
Location:
297 Derby St, Waltham, MA 02453, USA
Case number:
1900000883
Date:
2019-08-28
Time:
10:58
Address:
2014 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On 8/28/2019 at approx 1058hrs while assigned to 497 I responded to the area of 2014 Washington St for a report of a 2 car crash w/o injuries. Upon arrival I observed the vehicles on opposite sides of Washington St with NFD Lt Bourgeois standing by with his emergency lights activated, Lt Bourgeois stated both operators were shaken up but not injured. I spoke with the operator of Ma Reg 1XM680 Elizabeth CHISOLM who stated she was attempting to take a left onto Washington St, a vehicle in the right hand eastbound lane was turning right into the parking lot, CHISOLM stated she did not see Ma Reg EV3452 being operated by Julien GRANT in the left eastbound travel lane until it was too late colliding with him. I spoke with GRANT who stated he was traveling EB in the left travel lane of Washington St when struck by CHISOLM exiting the hospital.
Keywords:
Crash, Fire, Hospital
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 374.565ms