crash_reports
2 rows where "datetime" is on date 2019-01-20 and hit_run = 1
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-20
Time:
01:33
Address:
282 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 01/20/2019, while assigned to N492, I, Officer Conary, responded to 282 Watertown Street, for a report of a past hit and run. Upon arrival, I was met by SILVA, Jordana, who explained to me that the car was parked out front at approximately 2130 hours and when she went outside she saw the damage to the left side. MV1 was parked westbound on Watertown Street on the side of the road. There was damage to the left front side panel. The car was not towed at this time but SILVA was advised to call if needed. No further incident to report at this time.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3610851
Longitude:
-71.1979732
Location:
Case
number:
Date:
2019-01-20
Time:
08:22
Address:
1 ST JAMES ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date and time I responded to the area of St.James St at Washington Street for a report of a past hit/run with City traffic signal knocked over. Upon arrival I observed the the traffic signal on St. James Street westbound just before the Washington Street bridge on the roadway. I did observe what appeared to be a sidewalk plow tire impressions on the sidewalk to the traffic signal. I cnanvassed the area with negative results and I am waiting to hear back from Public works who may have been assigned the area to plow the side walks. I also checked for any cameras in the area with negative results. I took pictures of the crash site area and I will have them downloaded at th I.T. Bureau.
Keywords:
Crash, Pictures, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3587653
Longitude:
-71.1802247
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);