crash_reports
2 rows where date = "2021-01-26" 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-26
Time:
10:46
Address:
CHANNING ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Oper of vehicle # 1 stated that he was changing lanes trying to get into a parking lot. He admitted that he didn't see vehicle #2. Oper of vehicle # 2 stated he was going WB on Washington Street when Vehicle #2 hit him while trying to enter his lane of travel. No tows No injuries
Keywords:
[]
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3566909
Longitude:
-71.1874033
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);