crash_reports
3 rows where dcc = "["Unknown"]", intersection = 0 and "retrieved" is on date 2022-01-07
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-02
Time:
10:54
Address:
1210 CHESTNUT ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Sunday 1/2/22 at approximately 1054 hours while assigned to marked unit n498 I was dispatched to the area of 1210 Chestnut Street for a report of a past Hit and Run. Upon arrival I spoke with the damaged vehicle's owner, ODVARKA Joseph, who states last night he parked his vehicle around 4:30pm in his parking spot that runs along a fence bordering the parking lot of Brickfire Pizza and Allstar Liquors (1214 - 1220 Chestnut Street). ODVARKA states between the hours of 4:30pm and 8:30pm last night someone struck the fence on the other side causing it to buckle and do damage to the passenger side of ODVARKA's vehicle. After speaking with ODVARKA I canvassed the area and noticed surveillance cameras at Brickfire Pizza and All Star Liquors. The owner of Brickfire states to the camera only captures footage from the front door and inside the establishment. The owner of All Star Liquor states his cameras only capture footage from the front of the store and the inside and the cameras are real time only and do not record. Businesses across the street were not open and I did not observe any external cameras.
Keywords:
Bus, Night, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3094396
Longitude:
-71.2213944
Location:
Case
number:
Date:
2022-01-03
Time:
09:25
Address:
808 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday 1/3/2022, at approx 0925hrs, while assigned to N-496, I responded to 808 Beacon St in Newton for a 2 car MVA. There, I observed MV1 legally parked in front of 808 beacon St with it's front bumper ripped off. There was minor damage to MV2's front passenger side. Operator of MV2 states that she was attempting to park in front of MV1 but accidently hit it.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.330038
Longitude:
-71.1938425
Location:
Case
number:
Date:
2022-01-03
Time:
11:41
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV operator states he was traveling eastbound on Washington Street when the box truck's break's failed. MV operator states he collided with the lower staircase of the Four Points by Sheraton as the vehicle came to a stop. Also damaged fence along sidewalk that is believed to be property of MassDOT. MV operator had no injuries. The MV had major damage to the front left side. The truck was moved to a municipal parking lot near the crash site awaiting a private tow. The Four Points by Sheraton manager was made aware of the staircase. Traffic responded and took pictures of the scene and Lt. Dangelo notified Mass DOT of the fence that was damaged at the crash.
Keywords:
Crash, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
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);