crash_reports
5 rows where "datetime" is on date 2020-01-08 and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-08
Time:
13:19
Address:
WASHINGTON ST & MASS PIKE OFF RAMP/WEST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling west on Washington St in the right hand lane when MV#2 crashed into her MV. The operator of MV#2 stated they were also traveling west on Washington St when MV#1 entered his travel lane. No injuries, no tows.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3482146
Longitude:
-71.2294713
Location:
Case
number:
Date:
2020-01-08
Time:
13:33
Address:
647 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Miriam Plavin-Masterman states that she parked vehicle #2 at the Whole Foods on Washington St earlier today. When she came out she noticed someone struck her right rear bumper. Miriam stated that checked with the store to see if there was video surveillance and there was not. No witnesses at this time. report for insurance purposes.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2020-01-08
Time:
13:31
Address:
9 BEACON PL
Speed
limit:
0
Violation
cited:
no
Narrative:
The owner of MV#1 stated she parked in the parking lot at 9 Beacon Pl. at 0800 hrs. At 1345 hrs. she noticed damaged to the drivers side font fender. There were no witnesses and the operator of MV#2 in unknown.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3305578
Longitude:
-71.1953741
Location:
Case
number:
Date:
2020-01-08
Time:
14:55
Address:
9 LILL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that her MV was parked and unoccupied in front of #9 Lill Ave when MV#2 backed into it from the driveway across the street. The operator of MV#2 states that he was backing his MV out of the driveway across from #9 Lill Ave when the rear of his MV struck MV#1. No injuries, no tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3554912
Longitude:
-71.2367132
Location:
Case
number:
Date:
2020-01-08
Time:
17:24
Address:
BOYLSTON ST & WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 8 2020 at approximately 17:24 hours I responded to the area of Centre St by Winchester St for a two vehicle crash with no injuries. Upon arrival, I observed the MV1 facing Northbound on Winchester St with MV2 Westbound from Boylston St. MV1 had front passenger side damage and MV2 had front driver's side damage. The operator of MV 1 said that she was traveling Northbound on Winchester St when MV2 cut in front of her from Boylston St off ramp and she did not have time to stop in time and crashed into MV2. The operator of MV2 said that he had stopped at the stop sign on the Boylston St off ramp, turning left onto Winchester St and was inching forward when the northbound traffic was stopped he began to drive looking at southbound traffic when MV1 passed the stopped vehicle on the left and he crashed into MV1. There were no reported injuries and MV1 denied passing any vehicles on Winchester St.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3192444
Longitude:
-71.2072004
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);