crash_reports

Table actions

1 row where "retrieved" is on date 2021-07-15 and speed_limit = 10

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000506
Date:
2021-07-13
Time:
08:30
Address:
2014 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
On 7/13/2021 at approx 0858HRS while assigned to 497 I responded to Newton Wellesley Hospital, West Entrance 2014 Washington St for a report of a hit and run in the parking lot. Upon arrival I met with Heather Devoe who stated she had parked her husbands 2018 Chevy Tahoe Ma Reg 7775BK in the parking lot at approx 0830HRS, upon her return at approx 0855HRS she discovered minor damage to her rear driver side bumper. The bumper had minor dark transfer of either dark paint or tire . Heather stated she had observed a dark sedan very close to her when she parked but had no other information. Heather spoke with NWH Security who stated they would check their cameras and see if they found anything.
Keywords:
Hospital
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, 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);