crash_reports
2 rows where "datetime" is on date 2020-04-07, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-04-07
Time:
12:59
Address:
105 TOLMAN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
RP/resident reports hearing a crash while inside his residence and looking outside and observed a silver SUV against the stop sign located at Derby St and Tolman St. RP reports MV in question left the area on Tolman St and then turned right onto Underwood Rd. RP states MV would have damage to drivers side and possibly the drivers side front quarter. A search of the area resulted in negative results. Traffic Officer McSweeney took photos of the damaged stop sign and the DPW was notified.
Keywords:
Crash, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3601183
Longitude:
-71.235389
Location:
Case
number:
Date:
2020-04-07
Time:
16:06
Address:
684 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 and MV#2 was involved in a minor accident and exchanged paperwork. MV#1 is a business vehicle and the company requested a police report afterwards. The OP. of MV#1 states he was parked near 684 Commonwealth Ave. and sitting in the car when MV#2 drove by and their side-view mirrors collided with each other. MV#1 side-view mirror had no damage while MV#2 side-view mirror popped out. I later spoke with the OP. of MV#2 who states while travelling on the eastbound lane of Commonwealth Ave., MV#1 suddenly opened the car door and the door struck her side-view mirror causing some damage. No witnesses available.
Keywords:
Bus, Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.335704
Longitude:
-71.1954613
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);