crash_reports
2 rows where dcc contains "Unknown", intersection = 0 and "retrieved" is on date 2021-07-15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-07
Time:
09:55
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper V1 stated she was traveling west on Washington Street in the middle lane with her left turn signal activated, to turn into 320 Washington Street entrance ( Four Points Hotel). She stated while turning left, V2 sped up and had contact with V2. Oper V2 stated he was traveling west on Washington Street in the left lane, he observed V1 with signal on but her vehicle turned into his vehicle in his lane. There was no reported injuries, both vehicles were towed by Todys towing. All parties advised of accident reporting process.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
Case
number:
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:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);