crash_reports
2 rows where dcc contains "Unknown" and "retrieved" is on date 2021-01-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-24
Time:
15:07
Address:
48 RESERVOIR AVE
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of MV#1 stated he had slowed to a stop just past the posted stop sign on the corner of Reservoir Ave. and Lee Rd. The operator of MV#2 passed MV#1 on the right, sideswiping it, causing minor damage to MV#1's right side panel and significant damage to MV#2 left side panel. No injuries were reported and both vehicles were driven away from the scene.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3319565
Longitude:
-71.166064
Location:
Case
number:
Date:
2021-01-26
Time:
11:09
Address:
CENTRE ST & COTTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator # 1 stated she had stopped at the stop sign on Cotton Street and Centre Street. She saw that Centre Street was clear and she turned left onto Centre Street. She then stated that Vehicle # 2 "came out of nowhere" and didn't slow down before the crash. She believed vehicle # 2 was speeding. Oper # 2 stated she was travelling NB on Centre Street when vehicle # 1 pulled out in front of her from Cotton Street. Both vehicles towed by Todys. Operators 1 and 2 signed refusals. passenger 1 and 2 had been picked up prior to being evaluated.
Keywords:
Crash, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3414924
Longitude:
-71.192219
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);