crash_reports
3 rows where "datetime" is on date 2019-09-17 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), dcc (array)
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);