crash_reports
2 rows where "datetime" is on date 2019-09-17, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
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:
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);