crash_reports
1 row where "datetime" is on date 2019-04-19, dcc = "["Failed to yield"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-19
Time:
08:00
Address:
2330 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED HE WAS ATTEMPTING TO EXIT #2330 WASHINGTON ST, ARTISON CHILD CARE CENTER, BY MAKING A LEFT TURN TOWARDS WELLESLEY WHEN HE CRASHED INTO VEHICLE #2, WHO WAS COMING E/B ON WASHINGTON ST. OPERATOR #1 FURTHER STATED BEFORE EXITING OUT ONTO WASHINGTON ST HIS ATTENTION WAS DRAWN TO THE OPERATOR OF VEHICLE #3 WHOM HE RECOGNIZED AS A TEACHER AT HIS SONS DAY CARE. SHE WAS STOPPED W/B ON WASHINGTON ST WAITING FOR HIM TO PULL OUT BEFORE TURNING INTO THE DAY CARE. OPERATOR #1 WITH TRAFFIC STOPPED W/B ON WASHINGTON ST PROCEEDED OUT FORGETTING TO LOOK BACK TO HIS LEFT(E/B) WHERE VEHICLE #2 WAS COMING FROM. HE THEN CRASHED INTO VEHICLE #2 AS HE ENTERED OUT INTO THE STREET. OPERATOR#2 STATED HE WAS TRAVELLING E/B ON WASHINGTON ST WHEN VEHICLE #1 PULLED OUT FROM THE PARKING LOT TO #2330 WASHINGTON ST CRASHING INTO HIS VEHICLE. THE IMPACT SENT HIS VEHICLE INTO VEHICLE #3 WHO WAS STOPPED W/B ON WASHINGTON ST WAITING TO TURN INTO THE DAY CARE CENTER. OPERATOR #3 STATED SHE WAS STOPPED W/B ON WASHINGTON ST WAITING TO MAKE LEFT TURN INTO HER WORK PLACE, ARTISON CHILD DAY CARE, #2330 WASHINGTON ST WHEN VEHICLE #2 CRASHED INTO HER VEHICLE AFTER FIRST BEING HIT BY VEHICLE #1.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3253244
Longitude:
-71.2566792
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);