crash_reports
2 rows where date = "2019-11-07" and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-07
Time:
16:55
Address:
CHESTNUT ST & TAMWORTH RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was turning left from Tamworth Rd onto Chestnut St, traveling North when MV 2 struck the right side of MV 1. The operator of MV 1 stated that the heavy congestion of traffic and rain obstructed her view when she took the turn. MV 2 was traveling Northbound on Chestnut St and struck MV 1's right side when MV 1 attempted to turn left onto Chestnut St. MV 1 was unable to see MV 2 when making the turn due to weather and the high congestion of traffic. There were no injuries to either party.
Keywords:
Rain
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.320521
Longitude:
-71.22647
Location:
Case
number:
Date:
2019-11-07
Time:
18:06
Address:
326 FULLER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states while travelling eastbound on Fuller Street near #326, the curb suddenly extended out without warning. She struck the curb and sustained two flat tires and unknown axle damage. The OP. of MV#1 states there are no signs or reflective painting to show motorists that the curb has extended out into the roadway. This and the rain was the contributing factor to her accident. She states she will file a complaint with Newton City Hall about this.
Keywords:
Crash, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3360988
Longitude:
-71.2354486
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);