crash_reports
3 rows where "datetime" is on date 2021-10-01 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-01
Time:
11:33
Address:
222 AUSTIN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 10-1-21 AT APPROX. 1133HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 222 AUSTIN ST. I NOTICED A RED FIRE HYDRANT ACROSS THE STREET WAS DISLODGED ROM ITS BASE AND LAYING SIDEWAYS ON THE GROUND. I SPOKE TO A WITNESS WHO LIVES ACROSS THE STREET AT 222 AUSTIN ST. ( DALLAS PERKINS ). WITNESS STATES HE HAD HEARD THE CRASH AND SAW FROM HIS WINDOW A LARGE BOX TRUCK WITH A TRAILER ATTACHMENT THAT CONTAINED SEVERAL LANDSCAPING EQUIPMENT PIECES DRIVE AWAY FROM THE SCENE. WHEN HE NOTICED THE FIRE HYDRANT WAS KNOCKED OVER HE CALLED THE POLICE. WITNESS STATES FROM HIS VANTAGE POINT HE WAS UNABLE TO GET A PLATE OR OTHER IDENTIFIABLE MARKINGS. NEWTON PUBLIC WORKS WAS NOTIFIED TO REPLACE THE HYDRANT. N525 ( OFF GAUDET ) ARRIVED AND TOOK PICTURES OF THE SCENE AND THE DAMAGE. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Fire, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3491731
Longitude:
-71.216911
Location:
Case
number:
Date:
2021-10-01
Time:
14:37
Address:
40 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Driver #1 stated she was travelling westbound on Needham St and had entered the middle lane (turning lane ) to turn left into Farm Grill, 40 Needham St when she was hit on the right side by Driver #2. Driver #2 stated she was travelling westbound with her blinker on, moving into the middle turning lane from the northbound lane when Driver #1 came up abruptly beside her and she had no chance to stop. Minor damage to the passenger side of MV#1. MV#1 was driven from the scene. MV#2 has moderate damage to the front drivers side and was leaking coolant. The car was parked in a private parking spot (with permission from Farm Grille ) until a tow could arrive on scene. All parties declined medical attention.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3157609
Longitude:
-71.2097675
Location:
Case
number:
Date:
2021-10-01
Time:
15:34
Address:
WASHINGTON ST & ENTRANCE/EXIT WOODLAND MBTA
Speed
limit:
15
Violation
cited:
no
Narrative:
MV#1 Was stopped at the traffic light at the intersection of Washington St and the entrance/exit to the Woodland MBTA station when she was struck from behind. MV#2 Was exiting the Woodland MBTA station when he struck MV#1 from behind. OPMV#2 Stated he wasn't paying attention when he struck the vehicle in front of him.
Keywords:
[]
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3327357
Longitude:
-71.2432065
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);