home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Reckless driving"]" and "retrieved" is on date 2022-07-26

✎ 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:
22000525
Date:
2022-06-14
Time:
13:11
Address:
1280 CENTRE ST
Speed limit:
5
Violation cited:
yes
Narrative:
On Tuesday 6/14/2022, at approx 1311hrs, while assigned to N496, I responded to the parking lot of 1280 Centre St in Newton for a MVA hit&run with a parked vehicle. There I observed fresh damage to the rear bumper of MV1. The owner of MV1 was notified of the accident and was given a report number. I was unable to locate the owner of MV2, Song Mai. Mai was cited for leaving the scene of property damage. MA citation number T2015014 was mailed to the address listed on Mai's registration. It should be noted that Mai has an extensive drivers history including leaving the scene of property damage.
Keywords:
Citation, Crash, Severe
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3296269
Longitude:
-71.1943762
Location:
1280 Centre St, Newton, MA 02459, USA
Case number:
22000569
Date:
2022-06-25
Time:
22:12
Address:
CALIFORNIA ST & WYOMING RD
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 stated she had just turned onto California St and was turning left when MV2 struck her causing heavy front end damage & airbag deployment. Operator of MV1 was evaluted by Fallon Medics for upper body pain and signed a patient refusal. MV2 was found abandoned close by on Bemis St @ Fair Oaks Ave. Both vehicles were removed from the scene by Tody's Towing. Operator of MV2 and his passenger complained of injuries, however refused to be evaluated. Operator of MV2 was cited with the following: M.G.L. 90/24A Leaving the Scene of Personal Injury M.G.L. 90/24C Leaving the Scene of Property Damage M.G.L. 90/24E Negligent Operation See incident report #22022661
Keywords:
Airbag, Citation
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

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 253.335ms