crash_reports
1 row where "datetime" is on date 2020-01-29, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-29
Time:
18:35
Address:
50 WINCHESTER ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 1/29/20 at approximately 1835 hrs I responded to 50 Winchester St for a report of a MVA hit and run. Upon arrival I spoke with the owner of Tile in Style which is located at this address. Inga Sipicina stated that at 1050 hrs a brown UPS truck bearing S79977 struck a sign that was attached to the building above the entrance in two different locations. Inga stated the truck then took off. The sign had clear but minimal damage. A branch manager from UPS later came to the store to speak with Inga and her husband Slava and stated they would be in contact with them but didn't leave any information. I attempted to call the business but it was after hours and left a message. There were no injuries involved in this accident. On 2/4/20 I again attempted to contact UPS with negative results.
Keywords:
Bus, Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3181824
Longitude:
-71.208344
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);