crash_reports
1 row where dcc = "["Failed to yield", "Other improper action"]", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-17
Time:
15:00
Address:
2101 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 9/17/2020 at approx 1500hrs while assigned to 497 I responded to the area of Washington St over Rt 128 for a report of a 2 car crash with possible injuries. Upon arrival I found both cars in the parking lot of 2101 Washington St. I spoke with the operator of Ma reg 3CXA91, Emma Lorden who stated she was taking a left out of 2150 Washington St, thought the way was clear when at what she perceived at a high speed she was struck by the operator of Ma reg 122CF6 Patricia Christina . I spoke with Patricia who stated she was travelling Eastbound on Washington St when the other vehicle pulled out across her traffic lane. Patricia had a passport only and admitted she had no license in the U.S. or in Brazil. Patricia issued criminal application citation for violation of MGL 90/10 Unlicensed Operation , her car was towed by Todys Towing. Emma stated she had struck her head but signed a refusal with Cataldo Ambulance.
Keywords:
Citation, Crash, Ems, Speed
Dcc:
Failed to yield, Other improper action
Report
url:
Image
url:
Latitude:
42.3303129
Longitude:
-71.2500201
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);