crash_reports
1 row where "datetime" is on date 2019-01-09, dcc = "["Failed to yield"]" and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-09
Time:
07:44
Address:
BROOKLINE ST & DEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
OPERATOR #1 WAS ON DEDHAM ST, HEADING EASTBOUND AT THE INTERSECTION OF BROOKLINE ST. SHE WAS ATTEMPTING TO TAKE A LEFT HAND TURN ONTO BROOKLINE ST. SHE STATES THAT THE CAR IN THE OPPOSITE DIRECTION OF HER STOPPED, AN INDICATION THAT THE DRIVER WAS LETTING HER TAKE A LEFT HAND TURN. SHE TOOK THE LEFT HAND TURN ONTO BROOKLINE ST AND STRUCK VEHICLE #2 AS IT WAS PASSING BY. VEHICLE #2 IN TURN REAR ENDED VEHICLE #3. VEHICLE #3 OPERATOR TRANSPORTED TO FAULKNER HOSPITAL WITH MINOR INJURIES. VEHICLE OPERATOR #1 STATES THAT HER VIEW WAS OBSTRUCTED, AND THAT SHE WAS TRAVELING EASTBOUND THE SUN WAS IN HER EYES AND HER VIEW WAS OBSTRUCTED. VEHICLE #2 AND #3 WERE TOWED BY TODYS TOWING OF NEWTON. VEHICLE #1 OPERATOR ISSUED CITATION T0645456 BY MAIL, FOR FAILING TO YIELD TO ONCOMING TRAFFIC.
Keywords:
Citation, Hospital, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.2989668
Longitude:
-71.1865087
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);