crash_reports
3 rows where "datetime" is on date 2021-11-24, dcc contains "Unknown" and "retrieved" is on date 2021-12-06
This data as json, CSV (advanced)
Suggested facets: intersection, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-24
Time:
08:20
Address:
1321 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of MV 1 and stated that when he pulled out of his parking space in the parking lot of 1321 Washington st, he accidently sideswiped MV 2 which was parked next to him on his passenger side. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2021-11-24
Time:
11:53
Address:
ALDEN ST & CENTRE ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Oper # 1 stated he was traveling SB on Centre Street when Vehicle # 2 pulled in front of him and he was unable to stop in time. Oper #2 stated she stopped at Alden Street and Centre Street. Traffic was stopped on Centre Street due to red light ahead. No one was blocking intersection so she pulled out and turned left onto Centre Street when she was struck by Veh #1. She stated Veh #1 had gott into left turn lane early making Centre Street two lanes , when it doesn't become two lanes until after the intersection. Medics responded and everyone signed a refusal, Both vehicles towed by Tody's.
Keywords:
[]
Dcc:
Lane departure, Unknown
Report
url:
Image
url:
Latitude:
42.3371882
Longitude:
-71.1931665
Location:
Case
number:
Date:
2021-11-24
Time:
14:22
Address:
85 OAK HILL ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was travelling Westbound on Old Farm Rd prior to the collision with Vehicle #2. The owner of Vehicle #2 stated that his trailer was parked on the roadside of Old Farm Rd prior the collision with Vehicle #1
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2984091
Longitude:
-71.180166
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);