crash_reports
1 row where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2021-09-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-06
Time:
12:47
Address:
189 WATERTOWN ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On September 6th, 2021 at approximately 12:47 hours while working N491 I responded to the parking lot to Stop and Shop Plaza, #171 Watertown St, for a report of a crash near Planet Fitness. On my arrival I located both involved vehicles near the CVS. Vehicle #1 was a 2015 Honda Civic, MA reg. 7zg316, operator identified as JITENDIA MISHRA. He reported travelling N/B in the parking lot to the plaza when he had to stop due to vehicle #2 had stopped in front of him. Vehicle #2 suddenly backed up into his vehicle hitting his drivers side front. Vehicle #2 was a 2009 black Toyota RAV4, NY plate HFJ2619, operator identified as Madeleine Lesser. She stated she was in the parking lot of the plaza when she observed a car backing out from a parking space in front of her. She then stopped her vehicle and allowed that vehicle to proceed out. She then had to back up a little to allow room for that other vehicle to back out. She never saw vehicle #1 right behind her. She then backed into the drivers side front quarter. There were no tows or injuries to this crash.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3637788
Longitude:
-71.1943201
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);