crash_reports
4 rows where "datetime" is on date 2019-09-17, 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-17
Time:
09:45
Address:
2040 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Francis Vincent was operating vehicle #1 W/B on Comm Ave. Francis states that he was driving and looking at traffic straight ahead. Francis states that he drove into a green dumpster that was left on the side of the road by Star Market. Francis states that he did not see the dumpster because it blended in with the tree line. I spoke with Star Market Manager Joe Granata. Joe stated that the disposal company was brining a new dumpster and the dumpster was left in the street so the exchange could be made. No injures, vehicle #1 towed by Todys
Keywords:
Tree
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2019-09-17
Time:
14:28
Address:
895 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Ana Fernandez-Mastrogiovanni parked vehcile #2 at 895 Watertown St at apporx 100 hrs. Ana went back to her vehicle and saw that someone struck her left front fender and ripping off the front bumper. No witness, no injures. vehicle #1 is unknown. Vehicle #2 private tow.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.351319
Longitude:
-71.2220388
Location:
Case
number:
Date:
2019-09-17
Time:
17:22
Address:
1 JACKSON RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of Vehicle #1 stated that he returned to his vehicle to find fresh damage to the driver's side door, and the driver's side quarter panel. No video, or signs of the other vehicle were left at the scene. The damage on the vehicle appears consistent with that of another vehicle side-swiping it from the opposite direction.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3612213
Longitude:
-71.1928263
Location:
Case
number:
Date:
2019-09-17
Time:
15:25
Address:
141 NEEDHAM ST
Speed
limit:
0
Violation
cited:
no
Narrative:
On Tuesday 9/17/19 at approximately 1525 hourts I was dispatched to the parking lot in front of Sierra Tradiing Post (141 Needham Street #50) for a report of a past hit and run. Upon arrival I spoke with Lillian ORTIZ-NADER who states that at approximately 2pm she parked her car in a parking space. She came back to her car at 3:25pm and noticed scratches to the drivers side rear fender, rear door and front door. She states that none of this damage was there before she parked the vehicle.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);