crash_reports
2 rows where "datetime" is on date 2019-05-06 and dcc = "[]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-06
Time:
07:10
Address:
COMMONWEALTH AVE & OLD COLONY RD
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE #1 WAS TRAVELING STRAIGHT AHEAD ON COMMONWEALTH AVE, HEADING EASTBOUND. SUDDENLY AT THE INTERSECTION OF OLD COLONY RD, WITHOUT WARNING, A WOMAN CROSSED THE STREET WITH THREE YOUNG CHILDREN.(THE WOMAN WAS IN THE CROSSWALK). VEHICLE #1 STOPPED IMMEDIATELY, UNFORTUNATELY VEHICLE #2 COULD NOT STOP IN TIME AND STRUCK VEHICLE #1. NO INJURIES REPORTED. VEHICLE #2 TOWED BY TODYS TOWING ON NEWTON.
Keywords:
Crosswalk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3371123
Longitude:
-71.1724493
Location:
Case
number:
Date:
2019-05-06
Time:
14:47
Address:
ROWE ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that prior to the crash she was traveling north on Rowe St. Operator #1 came to the intersection at Webster St, stopped and observed no other cars at the intersection and proceeded straight thru the intersection. While in the intersection, operator #1 observed MV#2 traveling west on Webster St travel thru the stop sign without stopping and strike her MV. MV#2 did not stop, but instead continued on Webster St towards Auburndale Square. Operator #1 describes MV#2 as a gold sedan being operated by a 55-70 year old female wearing large sunglasses. A search of the area was negative.
Keywords:
Crash, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.348768
Longitude:
-71.241021
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);