crash_reports
3 rows where "datetime" is on date 2019-01-19 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-19
Time:
14:14
Address:
200 BOYLSTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Aubrey Quintus states that she parked ND Reg 539AAR at 200 Boylston St in the parking lot. When she came back to her vehicle she noticed the right side had been struck by an unidentified vehicle. No witnesses, injuries or tow. Quintus was advised.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-01-19
Time:
18:44
Address:
QUINOBEQUIN RD & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states she was travelling eastbound on Washington Street and had the green light when MV#2 suddenly made a turn in front of her. She tried to swerve away to avoid the collision but they still collided together. The OP. of MV#2 states she was on the westbound lane of Washington Street with intent to make a left turn towards Wales Street. The traffic light showed a green left arrow so she made the turn, that's when she collided with MV#1.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3274875
Longitude:
-71.2531655
Location:
Case
number:
Date:
2019-01-19
Time:
21:24
Address:
391 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states while travelling northbound on Lexington Street, her car suddenly started sliding causing her to strike a tree by the roots area. Minor damage to the city tree, pictures taken.
Keywords:
Pictures, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.348877
Longitude:
-71.2476303
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);