crash_reports
4 rows where "datetime" is on date 2019-09-05, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-05
Time:
07:12
Address:
1200 BEACON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated she was driving in the parking lot of Cold Spring Park 1200 Beacon St when one of her two children in the back seat began crying loudly. Due to the childs screaming the operator turned around quickly causing the vehicle to veer left and crash into a large boulder used to separate the parking lot and the fields. The vehicle had to be pulled off of the boulder and towed by Nicks Towing. Operator and her two children reported no injuries. Several digital images were taken as it was on city property and turned into IT.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3311133
Longitude:
-71.2132723
Location:
Case
number:
Date:
2019-09-05
Time:
13:24
Address:
50 LOTHROP ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated he had parked his vehicle on the corner of Jenison St. and Lothrop to make a delivery. Operator #1 stated that he started backing up onto Lothrop St, not realizing that Vehicle #2 was parked in front of 50 Lothrop St. While backing Vehicle #1 collided with vehicle #2. Operator of Vehicle # 2 stated she had just parked her vehicle in front of 50 Lothrop St. when Vehicle #1 collided with vehicle #2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3564351
Longitude:
-71.2034008
Location:
Case
number:
Date:
2019-09-05
Time:
15:15
Address:
237 WATERTOWN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that he was attempting to pull out of a spot in the parking lot at 237 Watertown St when Vehicle #2 passed in front of his vehicle as she was attempting to leave her spot. The operator of Vehicle #2 offered a similar account, and added that she believed that Vehicle #1 was stopping to let her go. All parties declined medical attention.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3624639
Longitude:
-71.1961399
Location:
Case
number:
Date:
2019-09-05
Time:
15:17
Address:
35 ROWE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 9/5/19 at approximately 1515 hours, I responded to a report of a hit and run. The operator of mv 1 stated she was parked in front of 35 Rowe St when a green colored ford f150 truck drove by and hit her drivers side mirror off. The operator did not stop and kept driving. Mv1 was not able to get the plate in time.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.349111
Longitude:
-71.2411957
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);