crash_reports
2 rows where "datetime" is on date 2020-09-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-26
Time:
11:31
Address:
AUBURN ST & GROVE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 stated he was travelling straight on Auburn St when MV2 "ran the red light and I hit him" causing front end damage. No injuries reported or tow required. MV2 stated he just "wasn't paying attention and ran the light" causing drivers side damage. No injuries reported or tow required. Operator was cited for failure to stop @ red light.
Keywords:
Citation
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3458561
Longitude:
-71.2465491
Location:
Case
number:
Date:
2020-09-26
Time:
15:54
Address:
327 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle one was driving westbound on Washington St when he stated that he was looking at the buildings across from 327 Washington St. Vehicle one drifted into parked car, vehicle two. Vehicle two was parked and unoccupied in a parking spot in front of 327 Washington St. Vehicle two moved forward from the impact and struck vehicle three. It should be noted that vehicle two already had extensive damage to the front end of the vehicle prior to the crash holding the bumper intact with duck tape and clear tape. Vehicle three had minor damage to the rear end bumper. No injuries were reported on scene.
Keywords:
Crash, Severe
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3569413
Longitude:
-71.1871127
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);