crash_reports

Table actions

2 rows where dcc contains "Physical impairment", intersection = 0 and "retrieved" is on date 2021-05-24

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000310
Date:
2021-05-04
Time:
10:34
Address:
125 HANANTAN ST
Speed limit:
30
Violation cited:
no
Narrative:
VEHICLE #1 WAS TRAVELING DOWN NAHANTAN ST, HEADING WESTBOUND, WHEN ALL OF A SUDDEN SHE SNEEZED, AT THAT TIME SHE DRIFTED OUT OF HER LANE, AND SIDESWIPED VEHICLE #2 WHO WAS TRAVELING EASTBOUND ON NAHANTAN ST. NO INJURIES REPORTED, VEHICLE #1 TOWED BY TODYS TOWING OF NEWTON, VEHICLE #2 TOWED BY AAA TOWING.
Keywords:
[]
Dcc:
Physical impairment, Illness
Report url:
report
Image url:
image
Latitude:
42.3370413
Longitude:
-71.2092214
Location:
Newton, MA, USA
Case number:
2100000371
Date:
2021-05-22
Time:
22:16
Address:
242 OTIS ST
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 was driving EASTbound on Otis St when the operator, Philip Dare, drove into a fence belonging to 242 Otis Street. Operator showed signed of impairment and was arrested for OUI Liquor, Marked Lanes, and Negligent Operation. MV1 was towed by Tody's. MV1 sustained heavy front end and undercarriage damage. No injuries were reported by Dare. Medics and Fire arrived at the scene and Fire made the scene safe with yellow caution tape and cleared debris. Pictures taken of the damage, refer to NPD Incident #21022013.
Keywords:
Fire, Impairment, Pictures
Dcc:
Reckless driving, Physical impairment
Report url:
report
Image url:
image
Latitude:
42.3457125
Longitude:
-71.2173959
Location:
242 Otis St, West 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);