crash_reports
3 rows where "datetime" is on date 2022-07-08 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-08
Time:
16:30
Address:
335 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 Was stopped in traffic on Parker St, facing Northbound when they were struck by MV#2 from behind. OPMV#1 Stated she was stopped in traffic when she was hit from behind by another vehicle. MV#2 Was stopped in traffic on Parker St, facing Northbound when they were struck by MV#3. OPMV#2 Stated he was stopped in traffic when he was struck from behind by another vehicle. MV#3 Was traveling Northbound on Parker St when they collided with MV#2 that was stopped in traffic. OPMV#3 Stated she didn't know what happened prior to the crash. MV#3 Was towed by Tody's Towing. OPMV#3 Was transported by EMS to Brigham Hospital.
Keywords:
Crash, Ems, Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3158503
Longitude:
-71.1954205
Location:
Case
number:
Date:
2022-07-08
Time:
17:57
Address:
95 GLEN AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 7-8-22 AT APPROX. 1757HRS. WHILE WORKING N496 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 95 GLEN AVE. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES SHE HAD PARKED HER VEHICLE IN HER DRIVEWAY LOCATED IN THE REAR OF 85 GLEN AVE. AFTER PARKING OWNER EXITED HER VEHICLE AND GOT HER DOG TO COME OUT. OWNER STATES THE DOGS LEASH GOT CAUGHT ON THE GEAR STICK AND SHIFTED THE VEHICLE INTO NEUTRAL. OWNER STATES SHE GRABBED HER DOG AND FELL AWAY FROM THE VEHICLE. SHE STATES THE VEHICLE STARTED BACKING WENT ACROSS ELGIN RD. TO THE DRIVEWAY LOCATED IN THE REAR OF 95 GLEN AVE. AFTER CROSSING THE STREET THE VEHICLE CONTINUED TO TRAVEL AND SMASHED INTO VEHICLE #2 THAT WAS PARKED IN THE DRIVEWAY OF 95 GLEN AVE. DURING THE CRASH VEHICLE #2 WAS PUSHED AGAINST THE GARAGE OF 95 GLEN AVE. VEHICLE #1 CAME TO REST ASIDE THE GARAGE OF 95 GLEN AVE. OWNER OF VEHICLE #2 STATED SHE HEARD THE CRASH CAME OUT AND SAW THE DAMAGE. VEHICLE #1 HAD MINOR RIGHT REAR DAMAGE. VEHICLE #2 HAD EXTENSIVE RIGHT REAR DAMAGE AND MINOR FRONT END DAMAGE. THERE WAS ALSO MINOR DAMAGE TO THE GARAGE. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Severe
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3285409
Longitude:
-71.1877641
Location:
Case
number:
Date:
2022-07-08
Time:
18:53
Address:
19 COMMONWEALTH AVE
Speed
limit:
20
Violation
cited:
yes
Narrative:
The operator of MV1 stated he was traveling eastbound on Commonwealth Ave. while attempting to pull off to the road due to a flat tire on the drivers rear side, he struck the door of MV2 when the operator opened the door. The operator of MV2 stated he was parked, went to exit his vehicle and after opening the door MV1 struck the drivers side door to his vehicle. The damage that MV1 had was minor damage to the passenger side mirror. The damage MV2 had significant damage to the drivers door, causing it to not close. All parties stated they were not injured. MV1 was towed by Tody's due to a suspended registration.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3400456
Longitude:
-71.1674332
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);