crash_reports
3 rows where keywords contains "Moderate" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-17
Time:
15:57
Address:
HARTMAN RD & MEADOWBROOK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was stopped at the stop sign on Meadowbrook Rd, travelling southbound. Vehicle 2 was making a right turn onto Meadowbrook Rd from Hartman Rd. Vehicle 2 struck vehicle 1 on the drivers side, causing moderate damage. Vehicle 2 had minor damage to the front left bumper. No one was injured due to the accident. Tody's towed vehicle 1 to their lot.
Keywords:
Crash, Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3078062
Longitude:
-71.191447
Location:
Case
number:
Date:
2020-12-22
Time:
11:56
Address:
1357 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was traveling Westbound on Washington Street and as she was slowing down for the red light was struck from behind by motor vehicle #2. Motor vehicle #1 sustained moderate rear end damage. Operator of Motor Vehicle #2 stated that he was traveling Westbound on Washington Street and due to the glare of the sun struck motor vehicle #1 from behind. Motor vehicle #2 sustained moderate front end damage. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3489391
Longitude:
-71.2286452
Location:
Case
number:
Date:
2020-12-22
Time:
16:03
Address:
415 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling southbound on Parker Street when she began to get drowsy and she believes she turned the steering wheel to the right, which caused her to strike a tree and roll over onto the snow bank. MV1 was upright on its side when a passerby assisted the operator in getting out through the passenger side door. Operator of MV1 sustained no visible injuries and was evaluated by Cataldo and transported to NWH. Bobby Donahue of Tody's Towing towed the vehicle which had damage moderate damage.
Keywords:
Moderate, Snow, Tree
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3132574
Longitude:
-71.1963487
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);