crash_reports
2 rows where date = "2021-02-11", dcc contains "Inattention" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-11
Time:
09:02
Address:
CHESTNUT ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator of Motor Vehicle #1 stated that she was stopped at the red light Northbound on Chestnut Street. Motor Vehicle #2 was traveling Westbound on Commonwealth Avenue a took a left turn onto Chestnut Street ( Southbound). Motor Vehicle #2 turned into Motor Vehicle #1 causing major damage to its drivers side front panel. Operator of motor vehicle #2 stated she took a left turn onto Chestnut Street from Commonwealth Avenue and her vehicle fishtailed causing her to strike motor vehicle #1. Medics arrived on scene and both parties signed medical refusal forms. Tody's towed motor vehicle #1. Motor vehicle #1 sustained major left side damage and motor Vehicle #2 sustained moderate front end damage. Operator of motor vehicle #2 was issued a Citation T1447521 for Ch. 89 S. 4A Marked Lanes and Ch. 90 S.11 License Not Accessible.
Keywords:
Citation, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.336717
Longitude:
-71.223643
Location:
Case
number:
Date:
2021-02-11
Time:
10:07
Address:
155 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was traveling south on Lexington St (#155) when he looked down for a second and his MV stuck MV#2. MV#2 was parked and unoccupied in front of #155 Lexington St at the time of the crash. No injuries, both MV's towed from the scene.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3555308
Longitude:
-71.2423822
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);