home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-03-08

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, keywords, dcc, dcc_code, 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:
1900000250
Date:
2019-03-08
Time:
11:54
Address:
111 NEEDHAM ST
Speed limit:
10
Violation cited:
no
Narrative:
MV1 stopped short to allow an unidentified MV back of of a parking space. He stopped behind MV2. MV2 did not see MV1 stop and backed into MV1.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3137685
Longitude:
-71.2121457
Location:
111 Needham St, Newton, MA 02464, USA
Case number:
1900000251
Date:
2019-03-08
Time:
14:36
Address:
WALNUT ST & ELM RD
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV#1 stated she was travelling southbound on Walnut St at the intersection of Elm Rd when she let a vehicle out of Elm Rd to make a left turn. The operator of MV#1 stated she proceeded to move forward when a school bus directly behind that vehicle also made a left turn making contact with MV#1. The operator of MV#1 honked her horn to get the school bus's attention with negative results. MV#1 sustained minor damages to its driver's side front bumper and fog light. The damage to the school bus should be to its driver's side rear bumper. There were no reported injuries to the operator of MV#1. There were no reports of any contracted school bus operators reporting an accident. The operator of MV#1 stated there were witnesses at the accident scene but she did not get any of their information. The operator of MV#1 was advised to contact her insurance provider.
Keywords:
Bus, Crash, School
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3472639
Longitude:
-71.2065995
Location:
Walnut St & Elm Rd, Newton, MA 02460, USA
Case number:
1900000252
Date:
2019-03-08
Time:
17:14
Address:
275 CENTRE ST
Speed limit:
10
Violation cited:
no
Narrative:
On 03/08/2019, at 1714 hrs, I responded to 275 Centre St, Bertucci's parking lot, for a two car MVA. Upon arrival, I observed MV1 to have no damage to the rear end where she collided with MV2. MV2 had damage to the front passenger side door. The operator of MV1 stated that she did not see MV2 while she attempted to back out of a parking spot and collided with her passenger side. The operator of MV2 corroborated the story and stated she was attempting to exit the parking lot when MV1 backed into her passenger side.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.358572
Longitude:
-71.185233
Location:
275 Centre St, Newton, MA 02458, 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 303.152ms