crash_reports
1 row where "datetime" is on date 2019-02-01, intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-01
Time:
15:35
Address:
15 CYPRESS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/1/19 I was working N496 when I responded to a 2 car MVA at 15 Cypress St. with a road rage incident ( incident # 19004330). Upon arrival I spoke with Edward Macaleese. Macaleese stated MA reg 2EE232 (being operated by Fabian Castillo) was tailgating him while traveling southbound on Cypress St. so he pulled to the side to allow him to pass. After Castillo passed Macaleese he slammed on his brakes causing Macaleese to rear end Castillo. I spoke with Castillo who stated that he was traveling southbound on Cypress St. when the vehicle in front of him (Macaleese) began driving "much slower than the speed limit". Castillo stated the Macaleese pulled over to allow him to pass, after Castillo began to slow in traffic due to a vehicle pulling out. Macaleese struck Castillo from behind. Both parties stated they were not injured. Both vehicle were still drive able. Both parties were provided an accident report number.
Keywords:
Crash, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3285638
Longitude:
-71.1951188
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);