home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

5 rows where dcc_code = "[19, 21]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, 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:
1900000644
Date:
2019-06-24
Time:
01:27
Address:
61 PEARL ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 stated he was travelling w/b on Pearl St when he "fell asleep" subsequently making contact with 4 parked cars. Operator was evaluated by Cataldo Ambulance who cleared with a patient refusal. MV1 was removed from the scene by Tody's Towing after sustaining heavy passenger side & front end damage. MV2 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV3 sustained heavy drivers side damage. A note was left on the windshield with this report number for the owner. MV4 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV5 sustained minor drivers side damage.A note was left on the windshield with this report number for the owner.
Keywords:
Ems
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.358457
Longitude:
-71.1879481
Location:
61 Pearl St, Newton, MA 02458, USA
Case number:
1900000714
Date:
2019-07-11
Time:
16:32
Address:
SOUTH BROADWAY & WATERTOWN ST
Speed limit:
35
Violation cited:
no
Narrative:
MV1 stated she "was working all day and closed her eyes for a moment" subsequently rear ending MV2 which was stopped in traffic. MV1 sustained heavy front end damage and was removed from the scene by Tody's. MV2 stated he was stopped and he could see MV1 "in my rear view mirror coming up fast without hitting the brakes" subsequently rear ending his vehicle. MV2 was then pushed forward striking MV3. MV2 sustained minor front and rear end damage. MV3 stated she was at a stop and was rear ended by MV2 and as a result she rear ended MV4. MV3 sustained minor front and rear end damage. MV4 confirmed that she was stopped at the light and was rear ended by MV3. MV4 sustained minor rear end damage.
Keywords:
[]
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3573235
Longitude:
-71.2060662
Location:
Broadway & Watertown St, Newton, MA 02460, USA
Case number:
2100000643
Date:
2021-08-28
Time:
22:03
Address:
326 CHERRY ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV 1 was traveling northbound on Cherry Street when she struck a parked vehicle MV2 and then struck an additional parked vehicle MV3. Both MV2 and MV3 were unoccupied. Operator of MV1 states she was on her way home from getting ice cream and does not know how the accident occurred. Operator of MV1 states she does not remember anything happening prior to the accident. A bystander who wishes to remain anonymous states that when the operator of MV1 got out of the vehicle she stated that she thought she had fallen asleep. Operator of MV1 was evaluated due to airbag deployment and her father signed a AMA refusal, stating they would take her on their own to the hospital. MV1 and MV2 towed from the scene by Tody's, owner of MV3 was able to be move MV3 into driveway.
Keywords:
Airbag, Crash, Hospital, Ice
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3532099
Longitude:
-71.228882
Location:
326 Cherry St, West Newton, MA 02465, USA
Case number:
22000298
Date:
2022-04-10
Time:
15:47
Address:
246 CALIFORNIA ST
Speed limit:
25
Violation cited:
no
Narrative:
MV#1 Was Eastbound on California St when he collided with MV#2 & MV#3 that were parked facing Eastbound. OPMV#1 Stated he doesn't know what happened and he possibly fell asleep as he was driving. No injuries. MV#1 & MV#3 were towed by Todys Towing. Uninvolved vehicle owners were notified on scene.
Keywords:
[]
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3646329
Longitude:
-71.1985301
Location:
246 California St, Newton, MA 02458, USA
Case number:
22000491
Date:
2022-06-06
Time:
18:38
Address:
2282 COMMONWEALTH AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 states she was traveling west on Commonwealth Ave. after leaving the grocery store. She states she was feeling tired and must not have been paying attention. When she looked up she saw the grassy median and a telephone pole. She heard a pop and then swerved and MV1 rolled landing on its passenger side. Operator of MV1 was evaluated by medics and signed a patient refusal. It appears as if MV1 struck the curb with the left front tire, popping the tire and splitting the rim, also causing suspension damage. The vehicle then subsequently rolled onto its right side. Also possible striking the telephone pole. Eversource was notified to inspect pole. Todys up righted and towed MV1. NFD Engine 2 took care of the spill.
Keywords:
Fire
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3465172
Longitude:
-71.2553181
Location:
2282 Commonwealth Ave, Auburndale, MA 02466, 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 222.834ms