home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-09-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000732
Date:
2021-09-20
Time:
13:54
Address:
314 HAMMOND ST
Speed limit:
25
Violation cited:
no
Narrative:
On the above date and time while on Patrol in N496 I responded to 314 Hammond St (Boston College) to assist BCPD with damage to a wall. On arrivial I spoke to BCPD who stated they were alerted by an employee (Luckny Capre) that NP landscaping pulled onto the property to turn around and while pulling back onto Hammond St struck the stone wall ripping it apart. While speaking to BCPD thier dispatch was able to locate the landscaper by phone who stated they were in Newton Corner area and would come back. The landscaper returned and was identified as Luis Chingo-Calel and stated he knew he struck the wall but did not know what to do. I issued Chingo-Calel MA Uniforn Citation #T1447323 for 90/24 leaving the scene with property damage. See also incident report #21040232
Keywords:
Citation, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3312402
Longitude:
-71.1697398
Location:
Haley, 314 Hammond St, Chestnut Hill, MA 02467, USA
Case number:
2100000735
Date:
2021-09-21
Time:
09:52
Address:
80 MAPLE ST
Speed limit:
25
Violation cited:
no
Narrative:
MV#1 was parked and unoccupied at the time of the crash. According to RP Alexa Berkeley, she parked her MV in the area of #80 Maple St on 9/19/21 and when she returned today she observed that her MV had been struck on the rear drivers side. Lasell PD also responded, as Ms. Berkeley is a Lasell student. Lasell PD had no additional information to provide and state they don't believe Lasell has any cameras in the area. No injuries, no tows.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3429619
Longitude:
-71.2450547
Location:
DeWitt Hall, 80 Maple St, Auburndale, MA 02466, USA
Case number:
2100000736
Date:
2021-09-21
Time:
10:25
Address:
367 CALIFORNIA ST
Speed limit:
30
Violation cited:
no
Narrative:
OPERATOR OF MV 1 IDENTIFIED AS TYREN FERNANDEZ STATED HE WAS TRAVELING WEST ON CALIFORNIA ST IN FRONT OF THE GROCERY GARRISON. HE STATED THAT MV 2 WAS PARKED FIVE FEET OFF OF THE CURB IN FRONT OF HIM SO HE HAD TO DRIVE AROUND HIM, AND AS HE WAS DRIVING AROUND HIM, MV 2 BEGAN TO MOVE FORWARD AND STRUCK HIS PASSENGERS SIDE MIRROR CAUSING IT TO SHATTER. ACCORDING TO HERNANNDEZ, MV 2 WAS BEING OPERATED BY A HISPANIC MALE WITH A GOATEE WEARING A HIGH LIGHTER CONSTRUCTION SHIRT AND IN THE PASSENGER SEAT WAS A BLACK MALE WEARING A WHITE T SHIRT AND A BLACK HAT. FERNANDEZ APPROACHED MV 2 IN AN ATTEMPT TO EXCHANGE INFORMATION BUT THE OPERATOR OF MV 2 WOULD NOT. WHEN FERNANDEZ BEGAN WALKING BACK TO HIS CAR THE OCCUPANTS OF MV 2 SWITCHED POSITIONS IN THE VEHICLE AND THE BLACK MALE DROVE OFF TOWARDS WATERTOWN WITHOUT EXCHANGING INFORMATION. MV 2 WAS DESCRIBED AS A BLACK CHEVY FLATBED TRUCK. WATERTOWN WAS NOTIFIED OF THE HIT AND RUN.
Keywords:
Walk
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.365345
Longitude:
-71.203937
Location:
367 California 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 477.682ms