home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Followed too closely", "Inattention"]" and keywords contains "Citation"

✎ View and edit SQL

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 time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000702
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:
report
Image url:
image
Latitude:
42.3235716
Longitude:
-71.1937265
Location:
110 Parker St, Newton Centre, MA 02459, USA
Case number:
22000531
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:
report
Image url:
image
Latitude:
42.3558456
Longitude:
-71.1904222
Location:
Church St & Washington St, Newton, MA 02458, USA
Case number:
22000596
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:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 312.234ms