crash_reports
1 row where date = "2019-04-10" and keywords contains "Walk"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-10
Time:
15:22
Address:
460 NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 returned to her vehicle to a note from a witness that stated that she witnessed a vehicle strike her front bumper, as it was reversing to park. I also observed a small dent and a scratch consistent with a collision of this type on Vehicle #1's bumper. All attempts to contact Vehicle #2 have been negative, of yet. I will follow up on my next tour. The witness, identified as Ms. Michelle Temple, stated that she observed the collision, and added that it was with enough force to cause damage to the bumper. She then stated to the operator, "you just hit that car", to which the operator replied, "I know", and then walked away towards Newtonville Square. I was later able to speak with Ms. Rogovin. She stated that she didn't believe any damage was caused, thus she didn't notify anyone.
Keywords:
Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.350691
Longitude:
-71.2065685
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);