crash_reports
2 rows where "datetime" is on date 2019-04-13
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-13
Time:
14:08
Address:
1607 CENTRE ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of MV1 stated while traveling northbound on Centre St. vehicles in front of her came to a halt. As she came to a stop, MV2 struck her rear driver side. Operator of MV1 stated MV2 wasn't traveling too closely but due to the vehicles infront of her stopping quickly she had to stop quickly aswell. Operator of MV2 stated while traveling northbound on Centre St, just passed the intersection of Centre St. and Walnut St. MV1 came to a stop. Operator of MV2 stated he attempted to pull onto the sidewalk to avoid rear ending MV1 but did not have enough room and struck MV2. MV1 had significant damage to the rear passenger side. Operator of MV1 was able to drive her vehicle home. MV2 had significant damage to the front driver side and driverside door. MV2 was not able to operate the vehicle due to the damage. Todys's towed the vehicle.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3212998
Longitude:
-71.2043315
Location:
Case
number:
Date:
2019-04-13
Time:
17:13
Address:
PAUL ST & CYPRESS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 stated they were driving northbound on Cypress St. when her passenger accidently bumped into the cars shifter and put the car into reverse. Vehicle #1 stated they didn't notice and hit the gas and went backwards striking Vehicle #2 in the front. Vehicle #2 stated they were driving northbound on Cypress St. when the car in front of them stopped and then proceeded to reverse into the front of their vehicle. Vehicle #1 had minor damage to the rear of the vehicle and was able to be driven away. Vehicle #2 had minor damage to the front of the vehicle and was able to be driven. All operators and passengers stated they were uninjured and denied any medical treatment.
Keywords:
Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3278969
Longitude:
-71.1942744
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);