home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2021-08-20 and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, 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:
2100000617
Date:
2021-08-20
Time:
13:58
Address:
2040 COMMONWEALTH AVE
Speed limit:
10
Violation cited:
no
Narrative:
The operator of MV#1 states that she was attempting to exit the Star Market parking area (#2040 Commonwealth Ave) onto Commonwealth Ave when MV#2, who was directly in front of her, began backing up and struck MV#1. The operator of MV#2, described as a older W/M, with white hair and very tanned operating a white sedan with MA. plates, exited MV#2 looked at the damage and then left the area. No injuries reported and no tows.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, USA
Case number:
2100000618
Date:
2021-08-20
Time:
14:37
Address:
199 BOYLSTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle 1 was backing out of a parking space in front of 199 Boylston St when he struck vehicle 2 which was traveling eastbound in the parking lot. Vehicle 2 did not stop and left the area. The plate given for vehicle 2 was 962WNZ and I had two phone numbers for the vehicle owner (h:617-558-7264 and C:617-834-7806). I made several unsuccessful attempts to contact the owner of vehicle two and will follow up on my next tour of duty. On 08/23/2021 I spoke to Julia over the phone who stated she was operating the vehicle and did not realize she had been involved in an accident until she got home. While driving through the parking lot she did notice the other vehicle was clost to her but did not realize they had made contact.
Keywords:
Crash, Phone
Dcc:
Inattention, Unknown
Report url:
report
Image url:
image
Latitude:
42.3213853
Longitude:
-71.175966
Location:
199 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
2100000620
Date:
2021-08-20
Time:
21:17
Address:
96 WARWICK RD
Speed limit:
25
Violation cited:
no
Narrative:
Upon arrival, I observed damage on the rear bumper of vehicle 2 which was parked and unoccupied. A witness, Paul Shoemaker, stated he saw vehicle 1, a white Chrysler PT Cruiser, operated by a male party back into vehicle 2 which was parked in front of 96 Warwick Rd. He stated a female party then got out of the vehicle to observe the damage. She then got in vehicle 1 and drove away towards Waltham St. The witness was unable to view the license plate. Mr. Shoemaker stated that his neighbor, the owner of vehicle 2, Marcelo Chaves, is away in Brazil and did not have a phone number for him.
Keywords:
Phone
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3558568
Longitude:
-71.2191038
Location:
96 Warwick Rd, Newton, MA 02465, 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 328.191ms