crash_reports
2 rows where "datetime" is on date 2019-02-08 and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-08
Time:
13:57
Address:
27 LINCOLN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was facing Westbound on Lincoln St parked in front of 27 Lincoln St when it was struck by the OPMV#2. OPMV#2 Was traveling Westbound on Lincoln St when he struck the left side mirror of MV#1. OPMV#2 Stated he was heading to do a delivery and never noticed he struck a parked car left side mirror.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3217805
Longitude:
-71.2072785
Location:
Case
number:
Date:
2019-02-08
Time:
19:56
Address:
309 TREMONT STREET
Speed
limit:
35
Violation
cited:
no
Narrative:
On 02/08/2019, I, Officer Conary, responded to 309 Tremont Street for a past hit and run involving a pedestrian. Upon arrival, I was met by FEBLOWITZ, Colleen, who stated at approximately 1745 hours, she was crossing in the crosswalk at Tremont at Hibbard when her foot was hit by a car. FEBLOWITZ explained to me that she was in the crosswalk and she saw a silver sedan, MV1, traveling Eastbound on Tremont Street approaching her but it was far away where she felt safe to walk across the street. She said she also raised her hand to draw attention to herself. FEBLOWITZ was halfway in the crosswalk when she felt severe pain in her right foot. She looked behind her and saw MV1 was very close to her. MV1 continued to drive down Tremont Street and not stop. There were no witnesses. FEBLOWITZ went to Partner's Urgent Care to be treated for minor injuries. The crosswalk is in a lighted roadway. FEBLOWITZ was unable to gain any other information on MV1. No further incident to report.
Keywords:
Crosswalk, Ped, Severe, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3549421
Longitude:
-71.1808005
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);