crash_reports
2 rows where dcc = "["Physical impairment", "Inattention"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-15
Time:
16:41
Address:
399 WASHINGTON ST
Speed
limit:
5
Violation
cited:
yes
Narrative:
MV1 attempted to pull into a parking spot, struck MV2, backed out and parked in the rear of the lot. MV1 sustained minor damage to the drivers side front & MV2 sustained major passenger side damage. Operator of MV1 was charged with Leaving the Scene of Property Damage & Negligent Operation. See incident report # 20042163 for further information.
Keywords:
[]
Dcc:
Physical impairment, Inattention
Report
url:
Image
url:
Latitude:
42.3563569
Longitude:
-71.1896886
Location:
Case
number:
Date:
2020-12-10
Time:
16:00
Address:
44 HARRINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV1 struck MV2, the side of 44 Harrington St, and a shed. The owner of MV2 further stated that they observed the owner of MV1 was in the passanger seat of MV1 and identified the operator as "Bob." "Bob" stated he had to get to an appointment and fled the scene. MV2 sustained minor damage and the homeowner was notified of the damage to his residence. (See report #20055388 for more info). I contacted the owner of MV1 who stated he was at the Brigham & Womens Hospital in Boston. The owner stated that his home health care aid "Joe" was operating the vehicle and when he returned home he would call with all of "Joe's" information. The owner of the vehicle further stated that he is paralyzed and cannot drive. This report has been forwarded to the Traffic Bureau for further investigation.
Keywords:
Hospital
Dcc:
Physical impairment, Inattention
Report
url:
Image
url:
Latitude:
42.3509227
Longitude:
-71.2148656
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);