home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2021-01-27 and "retrieved" is on date 2021-02-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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:
2100000059
Date:
2021-01-27
Time:
12:19
Address:
275 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
On 01/27/2021, while assigned to N491, I, Officer Conary, responded to the 275 Centre Street for a minor motor vehicle accident. Upon arrival, I was met by Operator of MV3, who stated that he was driving Northbound on Centre Street in the far right lane. MV2 began to enter his lane of traffic to take a right turn into Brigham and Women's. At this time, MV3 thought MV2 was going to hit him so MV3 hit parked MV1. I spoke with Operator of MV2 who stated that he was traveling Northbound on Centre Street in the left side lane. Operator of MV2 merged into the far right lane to take right turn. He stated he did not see MV3 nor did he hit anyone. Operator of MV3 confirmed that MV2 did not hit another vehicle. I spoke to the owners of MV1 and they stated that the damage was minor and that they did not want to contact insurance. There was minor damage to the left front bumper. Operator of MV3 wanted an accident report due to the minor damage on the right side of his vehicle. All parties involved were asked if they needed medical attention in which the declined. All motor vehicles were driven from scene without issue.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.358572
Longitude:
-71.185233
Location:
275 Centre St, Newton, MA 02458, USA
Case number:
2100000060
Date:
2021-01-27
Time:
12:29
Address:
239 WATERTOWN ST
Speed limit:
10
Violation cited:
no
Narrative:
ON 1-27-21 AT APPROX. 1229HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 239 WASHINGTON ST. ( ST. JEANS HOUSING ).I SPOKE TO THE OWNER OF VEHICLE #1 ( MARIO SALVUCCI ). OWNER STATES SOMETIME BETWEEN 0800 AND 1229HRS. SOMEONE HIT THE REAR RIGHT QTR. PANEL OF HIS MOTOR VEHICLE WHILE IT WAS PARKED IN THE ST JEANS PARKING LOT. THERE WERE SCRAPES TO THE VEHICLES RIGHT REAR QTR. PANEL CONSISTENT WITH A VEHICLE THAT WAS BACKING OUT OF THE NEIGHBORING STALL. THERE WAS NO OTHER VEHICLE IN THE STALL AT THE TIME OF THIS REPORT. OWNER STATES HE BELIEVES HE KNOWS WHO WAS PARKED THERE AND IS GOING TO QUESTION HIM LATER THIS EVENING. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3616456
Longitude:
-71.1960462
Location:
239 Watertown St, Watertown, MA 02472, 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 380.076ms