crash_reports

Table actions

1 row where "date" is on date 2021-08-10, dcc = "["Failed to yield"]" and keywords contains "Helmet"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000595
Date:
2021-08-10
Time:
08:51
Address:
WASHINGTON ST & GROVE ST
Speed limit:
25
Violation cited:
no
Narrative:
On 8/10/2021 at approx 0851hrs while assigned to 497 I responded to the intersection of Washington St at Grove St for a report of a motor vehicle/bike crash with minor injuries. Upon arrival I met with Montgomery Curren a 15 year old adolescent male who related he was in the right travel lane w/b on Washington St crossing the intersection of Grove St when Ma Reg 3SN235 pulled in front of him taking a left from the e/b lane of Washington St onto Grove St. Curren was wearing a bicycle helmet, had minor scrapes and minor damage to his handlebars. I spoke with Triaca Fiorella who stated she was taking a left onto Grove St from Washington St, stopped to see if any cars were coming , when she saw no cars she took the left and Curren ran into the side of her car. Fiorella stated she believed Curren was "speeding" on his bicycle. Mass Uniform Citation T2015318 issued to Fiorella for violation MGL Ch 89 Sec 8 Fail to Yield Right of Way. Currens father , James Curren, responded to the scene to sign a patient refusal for Curren.
Keywords:
Bike, Citation, Crash, Helmet
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3257617
Longitude:
-71.2563872
Location:
Grove St & 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);