crash_reports

Table actions

1 row where "date" is on date 2019-06-24, intersection = 0 and keywords contains "Ems"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000644
Date:
2019-06-24
Time:
01:27
Address:
61 PEARL ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 stated he was travelling w/b on Pearl St when he "fell asleep" subsequently making contact with 4 parked cars. Operator was evaluated by Cataldo Ambulance who cleared with a patient refusal. MV1 was removed from the scene by Tody's Towing after sustaining heavy passenger side & front end damage. MV2 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV3 sustained heavy drivers side damage. A note was left on the windshield with this report number for the owner. MV4 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV5 sustained minor drivers side damage.A note was left on the windshield with this report number for the owner.
Keywords:
Ems
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.358457
Longitude:
-71.1879481
Location:
61 Pearl 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);