crash_reports
2 rows where "datetime" is on date 2019-01-01, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-01
Time:
02:18
Address:
78 VINE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On January 1, 2019 at approximately 02:18 hours I, Officer Guarino, responded to 78 Vine St. for a hit and run. I spoke to the operator of MV1, who told me that he was driving Eastbound on Vine St, he turned on his left directional and began to pull into his driveway at 78 Vine St. The operator of MV 2 attempted to pass MV 1 on the left hand side crashing into MV1. MV2 put the vehicle in reverse and left the scene. The operator of MV1 said that the front bumper of MV2 had fallen off in the collision with MA License plate 4KZ917 still attached. The owner of that vehicle lives in Boston, so Boston Police were notified. I attempted to make contact with the owner of MV 2 with negative results. Update January 1, 2019 16:15 hours: I was able to contact the owner of MV2, who admitted that she was the operator of the vehicle and that she was in the vehicle alone. The operator of MV2 said that the operator of MV1 was driving very slow and stopped in the right lane so she attempted to pass the vehicle. MV1 began turning and MV2 struck MV1. The operator of MV 1 said that she was nervous and left the scene because her phone died and attempted to contact the Newton Police in the morning. I am mailing citation T1441275 to Cecelia Spangenberg for MGL90/24C, leaving the scene of property damage. Photographs of the bumper have been submitted to IT to be attached to this report. The license plate was logged into evidence and placed into property and evidence locket #8.
Keywords:
Citation, Crash, Fatal, Phone, Pictures
Dcc:
Reckless driving, Wrong way
Report
url:
Image
url:
Latitude:
42.3034656
Longitude:
-71.1725852
Location:
Case
number:
Date:
2019-01-01
Time:
08:15
Address:
416 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-1-19 AT APPROX. 0815HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 416 WALNUT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING N-BOUND ON WALNUT ST. HE FELT DROWSY AND WAS SWERVING TO THE RIGHT. HE STATES HE WENT UP ON THE CURB AND HIT A NNHS PARKING SIGN. HE UPROOTED THE SIGN IT HIT HIS HOOD AND SMASHED HIS WINDSHIELD. DRIVER STATES HE WENT UP ON THE SIDEWALK BEFORE HE WAS ABLE TO GAIN CONTROL OF HIS VEHICLE AND RETURN TO THE STREET. VEHICLE #2 STATES SHE WAS TRAVELING N-BOUND AHEAD OF VEHICLE #1. SHE STATES HE WENT UP ON THE SIDEWALK AND LANDED HIS VEHICLE IN FRONT OF HERS. VEHICLE #1 HAD FRONT END AND HOOD DAMAGE, A SMASHED WINDSHIELD AND RIGHT SIDE AIRBAG DEPLOYMENT. THERE WAS NO DAMAGE TO VEHICLE #2. VEHICLE #1 DID NOT MAKE CONTACT WITH VEHICLE #2. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANY. VEHICLE #1 HAD HIS VEHICLE TOWED BY AAA. THE UPROOTED POLE WAS PLACED N THE BURM AT THE INTERSECTION OF WALNUT AND ELM. I TOOK SEVERAL PICTURES OF THE POLE, THE SIGN, AND THE AREA IT ORIGINATED FROM. PICTURES PLACED IN BOX FOR I.T. BUREAU.
Keywords:
Airbag, Crash, Pictures
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.347026
Longitude:
-71.2061414
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);