home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-04-06, dcc = "["Inattention"]" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, violation_cited, 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:
1900000344
Date:
2019-04-06
Time:
12:41
Address:
334 WATERTOWN ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 4-6-19 AT APPROX. 1241HRS. WILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 434 WATERTOWN ST. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES SHE WAS IN 334 WATERTOWN ST ( METRO CREDIT UNION ). SHE LOOKED OUT THE WINDOW AND SAW HER CAR SHAKE. SHE WENT OUTSIDE AND SAW HER CAR SHAKE AGAIN. SHE CONFRONTED THE OPERATOR OF VEHICLE #2 AND ADVISED HER THAT HE HIT HER VEHICLE. VEHICLE #2 YELLED AT HER DENYING HITTING HER CAR AND LEFT THE AREA. VEHICLE #1 HAD MINOR FRONT END SCRAPES. VEHICLE #1 REPORTED NO INJURIES AND WAS ADVISED TO CONTACT HER INSURANCE COMPANY. ATTEMPTS TO CONTACT VEHICLE #2 WERE UNSUCCESSFUL. VOICE MAIL LEFT. WILL ATTEMPT TO MAKE CONTACT ON NEXT SHIFT. ON 4-8-19 AT APPROX. 1035HRS. WHILE WORKING N492 I ATTEMPTED TO CONTACT THE OWNER OF VEHICLE #2. I LEFT ANOTHER VOICE MAIL. AS OF 4-9-19 1100HRS. AS I WRITE THIS REPORT I HAVE NOT RECEIVED A CALL BACK. VOICE MAIL ALSO ADVISED HE CONTACT HIS INSURANCE COMPANY FOR MORE INFORMATION.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3607314
Longitude:
-71.1998296
Location:
334 Watertown St, Newton, MA 02458, USA
Case number:
1900000345
Date:
2019-04-06
Time:
18:55
Address:
980 BOYLSTON ST
Speed limit:
5
Violation cited:
yes
Narrative:
The owner of MV1 stated that he was working inside Mr. K's Discount Wine and Spirits when a witness came into the store and asked if he owned a white Toyota Camry parked outside and then explained that another car had backed into it and then left the scene. When he came out he observed a large dent in the passengers side rear bumper that was not there before. Officer Selig tracked down the owner of MA Registration 3EF576 at 20 Hale Street and the operator of MV2 admitted to being in the parking lot but denied striking MV1. It should be noted that while at Mr. Wendt's residence both Officer Selig and I observed MA reg 3EF576 parked in driveway of 20 Hale Street with damage to the left rear bumper consistent with how the witnesses stated MV2 struck MV1. Based on the 2 witness statements that express that the operator of the Nissan Pickup knew he struck another vehicle and still left the scene I issued the operator of MV2, Mr. Spencer Wendt, Massachusetts Uniform Citation T1443928, a criminal application to appear in Newton District Court for 90-24 Leaving the Scene of Property Damage. A copy of this report as a well as the criminal application were placed in the court prosecutors mailbox.
Keywords:
Citation
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3181482
Longitude:
-71.2114226
Location:
980 Boylston St, Newton, MA 02459, USA
Case number:
1900000348
Date:
2019-04-06
Time:
15:01
Address:
866 BEACON ST
Speed limit:
30
Violation cited:
no
Narrative:
Brian Feeley states that he was driving E/B on Beacon St. Feeley states that he struck a tree branch that was overhanging onto the street. Damage to the top right of the box truck. No injuries, no tows.
Keywords:
Tree
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3299685
Longitude:
-71.19672
Location:
866 Beacon St, Newton, MA 02459, USA

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 432.238ms