crash_reports
2 rows where "datetime" is on date 2021-07-28, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-28
Time:
16:05
Address:
400 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that as he was travelling Eastbound on Centre St he changed lanes to the right prior to the collision with Vehicle #2. The operator of Vehicle #2 stated that as she was travelling Eastbound on Centre St Vehicle #1 entered the lane, colliding with her vehicle, and causing her to drive onto the island, and over 2 posted signs, and bushes. Both parties refused medical attention when it was offered. Both vehicles were also towed from the scene as a result of being disabled. Pictures of the damages to city property were taken, and added to Incident #
Keywords:
Bus, Pictures
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3559661
Longitude:
-71.18448
Location:
Case
number:
Date:
2021-07-28
Time:
16:30
Address:
991 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was exiting the parking lot of 991 Watertown St when he collided with MV2. MV2 was travelling EB on Watertown St when she was struck on the drivers side by MV1. No injuries to Operator 1, Operator 2 was transported by Fallon ambulance with minor injuries. MV1 was driven from the scene with very minor damage. MV2 was parked on Watertown St awaiting Operator 2's release from the hospital. MV2 sustained minor damage to the drivers side Photos taken and placed into IT.
Keywords:
Ems, Hospital, Pictures
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.349735
Longitude:
-71.225836
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);