crash_reports

1 row where keywords contains "Citation", "retrieved" is on date 2022-07-26 and speed_limit = 5

✎ 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

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);