crash_reports
2 rows where dcc contains "Inattention" and longitude = "-71.1727828"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-28
Time:
17:40
Address:
BEACON ST & HAMMOND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was stopped at the traffic light at the corner of Hammond Street at Beacon Street. MV1 got the green light and proceeded to move forward, but had to stop due to a vehicle in front of MV1 that had slowed down. MV2 saw MV1 begin to move forward but did not see MV1 come to a stop. MV2 struck the rear of MV1 causing little damage to the rear bumper of MV1. The operator of MV1 stated she had some minor neck pains, but when medics arrived on scene the operator of MV1 signed a patient refusal form to seek further medical evaluation.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3328654
Longitude:
-71.1727828
Location:
Case
number:
Date:
2021-03-01
Time:
19:14
Address:
BEACON ST & HAMMOND ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was stopped on Beacon St for the red light at the intersection of Beacon and Hammond. MV#2 was coming up behind MV#1 and did not stop in time, and crashed into the rear of MV#1. No injuries occurred. Both vehicles were driven off scene.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3328654
Longitude:
-71.1727828
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);