crash_reports

Table actions

2 rows where "datetime" is on date 2019-01-19, dcc contains "Unknown" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000067
Date:
2019-01-19
Time:
14:14
Address:
200 BOYLSTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Aubrey Quintus states that she parked ND Reg 539AAR at 200 Boylston St in the parking lot. When she came back to her vehicle she noticed the right side had been struck by an unidentified vehicle. No witnesses, injuries or tow. Quintus was advised.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
200 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
1900000075
Date:
2019-01-19
Time:
21:24
Address:
391 LEXINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
The OP. of MV#1 states while travelling northbound on Lexington Street, her car suddenly started sliding causing her to strike a tree by the roots area. Minor damage to the city tree, pictures taken.
Keywords:
Pictures, Tree
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.348877
Longitude:
-71.2476303
Location:
391 Lexington St, Auburndale, MA 02466, 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);