crash_reports
3 rows where dcc = "["Followed too closely", "Inattention"]" and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-14
Time:
16:02
Address:
110 PARKER ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated she was traveling Northbound on Parker St. when a vehicle in front of her stopped short. Operator of MV1 further stated she then had to stop suddenly to avoid hitting the vehicle in front of her, however stated that is when MV2 rear ended her vehicle. Operator of MV2 stated he was traveling Northbound on Parker St. when MV1 stopped short in front of him. Operator of MV1 stated he attempted to avoid colliding with MV1, however could not and collided with MV1 in front of 110 Parker St. No injuries. MV1 sustained heavy rear end damage along with rear windshield damage. MV2 sustained heavy front end damage. Both vehicles involved were towed on scene by Tody's towing. A towed motor vehicle form was filled out for both vehicles and placed on file. Operator of MV2 was operating the vehicle without a drivers license. Mr. Marcelo De Oliveira Siqueira was cited in hand for Ch. 90 Sec. 10 (Unlicensed Operation). MA Uniform citation #T2012676. Incident #21039385 was generated in regards.
Keywords:
Citation
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3235716
Longitude:
-71.1937265
Location:
Case
number:
Date:
2022-06-15
Time:
18:32
Address:
CHURCH ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one stated that while stopped at a red light in the north bound lane of Church St at Washington St his vehicle was rear ended by vehicle two. Operator of vehicle two stated that while stopped behind vehicle one his foot slipped off the break and caused his vehicle to rear end vehicle one. A passenger in vehicle one was transported to NWH for neck pain. Neither vehicle had visible damage and did not require a tow. Operator of vehicle two was issued a citation for a violation of City of Newton Ordnance 19/75 , failure to use care while stopped. Church St is a public way in the City of Newton.
Keywords:
Citation
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3558456
Longitude:
-71.1904222
Location:
Case
number:
Date:
2022-07-03
Time:
17:59
Address:
CHESTNUT ST & WASHINGTON ST
Speed
limit:
24
Violation
cited:
yes
Narrative:
MV 1 was traveling straight eastbound on Washington St. When MV 1 approached the intersection of Chestnut St and Washington St he rear ended MV 2. MV 1 sustained major damage to its front end including a fluid leak. The front air bag of MV 1 deployed. There were no injuries to the operator of MV 1, Mr. Million Yifru, and he signed a patient refusal with Fallon medics. Million was given a citation for operating a motor vehicle with an expired license (MGL ch 90-10) in hand. MV 1 was towed by todys due to it being disabled. MV 2 was stopped in traffic at the intersection of Chestnut and Washington St when he was rear ended by MV 1. MV 2 sustained minor damage to its rear bumper. The operator and passenger of MV 2 were not injured and both signed patient refusals. MV 2 was safe to drive from the crash.
Keywords:
Citation, Crash
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
Longitude:
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);