crash_reports
3 rows where "datetime" is on date 2020-01-08 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: address, keywords, dcc, dcc_code, geocoded_address, latitude, longitude, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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:
13:50
Address:
647 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
THE OPERATOR OF MV 1 HAD PARKED HER VEHICLE LEGALLY IN THE PARKING LOT BETWEEN WHOLE FOODS AND MARTYS LIQUORS ON WASHINGTON STREET. THE OPERATOR THEN WENT INTO THE VEHICLE AND LEFT THE VEHICLE UNOCCUPIED WHILE SHE WENT SHOPPING. A SHORT WHILE LATER THE OPERATOR CAME BACK TO THE VEHICLE AND OBSERVED FRESH DAMAGE TO THE REAR PASSENGER BUMPER WHICH APPEARS TO HAVE BEEN DONE WHEN AN UNKNOWN MV PARKED TO THE RIGHT OF HER VEHICLE EXITED THE PARKING SPACE. THERE WERE NO WITNESSES AND NO SURVEILLANCE FOOTAGE OF THE ACCIDENT.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
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);