crash_reports

Table actions

1 row where date = "2022-05-29" and "retrieved" is on date 2022-06-14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

Case number:
22000462
Date:
2022-05-29
Time:
17:44
Address:
CENTRE ST & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV1 stated she was at the red light on Washington Street, over the Mass Pike bridge, attempting to go straight on to Centre Street. When the light turned green, the operator attempted to yield and continue straight while the vehicle behind her was attempting to go left, on to Washington Street. The operator of MV2, struck the rear driver side bumper of MV1 causing minor damage. The operator of MV2, failed to stop and exchange information and continued on Washington Street, westbound. The operator of MV1 got a partial plate of 526L, Gray Honda CRV. I checked the area for the vehicle yielding negative results. Dispatch attempted to locate a vehicle with the partial plate, yielding negative results. The operator of MV1 was not injured.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Centre St & Washington 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);