crash_reports
2 rows where "datetime" is on date 2019-08-22 and dcc contains "Failed to yield"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-22
Time:
16:41
Address:
3 AUBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states he was traveling westbound on Auburn St when he collided with vehicle #2, which was pulling out of the driveway of #3 Auburn St. Operator #1 states he did not see vehicle #2 until contact was unavoidable. Operator #2 states he was pulling out of his driveway to turn right onto Auburn St when vehicle #1 hit the left driver's side of the vehicle. Operator #2 did not see vehicle #1 approaching. All parties declined medical attention but vehicle #2 had to be towed to Tody's due to moderate damage to the left driver's side door and bumper. Vehicle #1 sustained minor damage to the front right bumper but was driveable.
Keywords:
Moderate
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.345588
Longitude:
-71.2346597
Location:
Case
number:
Date:
2019-08-22
Time:
16:08
Address:
249 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Thursday 8/22/2019 at approx 1608hrs, while assigned to N-494, I responded to 249 Centre St in Newton for a 2 car MVA. Operator of MV1 states he was travelling straight on Centre St SB when MV2, entered his lane of traffic and struck the driver side of his vehicle. Operator of MV2 states that she was taking a left onto Centre St from the Sunoco gas station heading SB. She states that before entering traffic she saw no cars in the SB lane closest to her. She also states the operator of MV1 was distracted while talking to his wife.
Keywords:
Distracted, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3592861
Longitude:
-71.1856051
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);