crash_reports
2 rows where "datetime" is on date 2019-01-18 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-18
Time:
12:37
Address:
1479 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/18/19 at approximately 1200hrs, a party who wished to remain anonymous reported observing a tractor trailer travelling on Washington St W/B at #1479 where the street curves to the right struck a traffic light pole in front of Burke & Blackington Funeral Home. The side of the trailer struck the pole. It was reported the operator, a non descript black male, stopped after the collision, picked up the downed pole and moved it onto the sidewalk. Markings observed on the trailer were "Powered Transportation" out of Laurel, Mississippi. Unknown plates. Operator left scene and as of this time, it hasn't been reported by the operator. Photos were taken of the downed pole and submitted to the IT bureau. Daigle Electric notified to respond. Google search of "Powered Transportation" was negative results.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3467789
Longitude:
-71.2322834
Location:
Case
number:
Date:
2019-01-18
Time:
08:00
Address:
WASHINGTON ST & 128 N OFF RAMP
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/18/19 at approx 0800hrs while assigned to 497 I responded to the area of Washington St at 128 N off ramp for a report of a two car collision without injury. Upon arrival I met with the operator of Ma Reg 2GKG20 Kenneth COLGATE who stated he was travelling EB on Washington ST when he was struck from behind by the operator of Ma Reg 8RX338 Ejemel MONIR. COLGATE stated although MONIR did give him his lic and reg information he left prior to my arrival.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2543001
Longitude:
-71.1656782
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);