home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-02-21, keywords contains "Bus" and "retrieved" is on date 2020-10-06

✎ 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:
1900000204
Date:
2019-02-21
Time:
09:42
Address:
1066 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
The owner of MV#1 stated her vehicle was parked in the rear parking lot (Located on Rice St) of 1066 Centre St and was informed by 2 witnesses that stated her vehicle was struck by MV#2. I spoke to the 2 witnesses and they stated they were on the second floor of 1066 Centre St in suite #212 and had a bird's eye view of the rear parking lot on Rice St. The witnesses stated that MV#1 was parked while MV#2 was parked at an angle at a very close proximity to MV#1. The witnesses stated the operator of MV#2 was cleaning the snow off her vehicle, got into her vehicle then backed out of her parking space striking MV#1. The witnesses took a digital photograph of MV#2's registration (MA REG 763YC9). They described the operator of MV#2 as an Asian female in her 40's, 5'1" in height, operating a black colored "Buick" S.U.V type vehicle. MV#1 sustained minor damages to its front passenger door and bumper. A query of MA REG 763YC9 showed that it was registered to an Asian female to a black colored "Buick Rendezvous". The owner of MV#1 stated the owner of MV#2 also has a business in the same building at 630 Commonwealth Ave (Move2Boston Group). I spoke to the registered owner of MV#2 via telephone and she stated she was parked in the rear parking lot on Rice St but denied making contact with any vehicles. I could not observe MV#2 as it was not at the scene. At 14:40 I returned to 1066 Centre St and was able to observe MV#2. MV#2 displayed minor scrapes to its front driver's side bumper which was consistent relative to where both vehicles were parked. Based on the witnesses statements I will document this accident and provide this report number to the vehicle owners.
Keywords:
Bus, Crash, Pictures, Snow
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3358329
Longitude:
-71.1931117
Location:
1066 Centre 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 370.852ms