crash_reports
1 row where "datetime" is on date 2019-04-22 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-04-22
Time:
21:07
Address:
300 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 operator states he was driving around the Newton Corner Rotary and approached the merge at the beginning of the bridge to change lanes to head towards Waltham/Watertown, when MV2 collided with his vehicle. Damage was observed on the front passenger door. No injuries reported. MV2 operator states she was driving on Washington St and approached the merge at the beginning of the bridge to change lanes and head onto the Mass Pike W-Bound, when MV1 collided with her vehicle. Damage was observed on the front drivers side bumper. MV2 operator reported having whiplash but signed a medical refusal and was not transported to the hospital. I then cleared without further incident. The main crash factor was due to the weather being a heavy rain storm at night. It should be noted there is a yield sign facing MV1s incoming direction.
Keywords:
Crash, Hospital, Night, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3567319
Longitude:
-71.1859798
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);