home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where address = "200 BOYLSTON ST" and speed_limit = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hit_run, violation_cited, geocoded_address, latitude, longitude, 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:
1900000589
Date:
2019-06-07
Time:
11:23
Address:
200 BOYLSTON ST
Speed limit:
10
Violation cited:
no
Narrative:
MV1 was driving northbound in the parking lot when MV2 backed out of a parking spot striking MV1 in the right rear door and quarter panel. Oper 1 stated he was driving in the lot when MV2 struck the right rear of the car. Oper 2 stated she was backing out of he spot when she struck MV1 she stated she did not see MV1 prior to the accident. pictures were taken by and forwarded to IT
Keywords:
Crash, Pictures
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
200 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
22000138
Date:
2022-02-12
Time:
16:03
Address:
200 BOYLSTON ST
Speed limit:
10
Violation cited:
yes
Narrative:
MV1 was parked in a parking spot in the parking lot behind Wegmans grocery store which is a parking lot accessible to the public. MV2 proceeded to back into the front end of MV1 while trying to enter a parking spot (see witnees statement.) There were no injuries and no vehicles were towed. A citation will be issued to the operator of MV1 for leaving the scene of property damage 90/24/C. Citation #T1445641
Keywords:
Citation
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3189069
Longitude:
-71.1752159
Location:
200 Boylston St, Newton, MA 02467, USA
Case number:
22000592
Date:
2022-07-01
Time:
14:40
Address:
200 BOYLSTON ST
Speed limit:
10
Violation cited:
no
Narrative:
MV1 operator stated she was parked in the 200 Boylston St parking garage, level P3 middle row between the hours of 0600 to 1420 hours. MV1 operator stated sometime between those hours an unknown MV must have pulled out from the spot next to hers and struck her MV at an angle. MV1 sustained minor rear bumper damage on the passenger side. The damage was an apparent paint transfer and a minor dent under the brake light (still operable). MV1 operator estimated the damage to be worth approximately $2000 USD. MV1 was unoccupied during the incident so no injuries were reported at this time. MV1 was still able to be driver, no tow required.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3189069
Longitude:
-71.1752159
Location:
200 Boylston St, Newton, MA 02467, 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 211.858ms