crash_reports
2 rows where "date" is on date 2022-06-08 and dcc contains "Inattention"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-08
Time:
10:11
Address:
MARLBORO STREET & TREMONT STREEET
Speed
limit:
35
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST BOUND ON TREMONT STREET WHEN MV#2 BACKED OUT OF A DRIVEWAY AND STRUCK HIM. THIS CAUSED HIM TO THEN CRASH INTO A FENCE AT 4 MARLBORO STREET. THE OPERATOR OF MV#2 STATED SHE WAS BACKING OUT OF A DRIVEWAY WHEN SHE STRUCK MV#1. SHE STATED THAT MV#1 WAS SPEEDING. THE PROPERTY OWNER AT 4 MARLBORO STREET WAS ON SCENE AND AWARE OF THE PROPERTY DAMAGE. BOTH OPERATORS HAD CONFLICTING STATEMENTS BUT MV#1 HAD THE RIGHT OF WAY. BOTH VEHICLES WERE TOWED BY TODYS TOWING. BOTH OPERATORS APPEARED TO HAVE MINOR INJURIES AND WERE TRANSPORTED. THERE WAS AIRBAG DEPLOYMENT TO MV#1. BOTH VEHICLES HAD MAJOR DAMAGE.
Keywords:
Airbag, Crash, Speed
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3524407
Longitude:
-71.1756664
Location:
Case
number:
Date:
2022-06-08
Time:
17:39
Address:
EAST BOWERS & HARVARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was on Harvard Street traveling south bound. When she approached Bowers Street, MV2 pulled out on to Harvard Street and struck MV1. The operator of MV2 stated he stopped at Bowers Street. proceeded to enter Harvard Street when MV1 came out of nowhere and MV2 struck MV1. MV1 had damage to the passenger side and MV2 had damage to the front bumper. Both operators stated they were not injured and motor vehicles were operable. Bowers Road is missing a stop sign.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.351813
Longitude:
-71.201886
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);