crash_reports
2 rows where address = "647 WASHINGTON ST" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-22
Time:
12:10
Address:
647 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 10-22-19 AT APPROX. 1210HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 647 WASHINGTON ST. ( WHOLE FOODS PARKING LOT ) I MET THE OWNER OF VEHICLE #1. OWNER STATES SOMETIME BETWEEN 1130-1210HRS. WHILE SHE WAS SHOPPING AT WHOLE FOODS SOMEONE HIT THE RIGHT REAR OF HER VEHICLE CAUSING SCRAPES ALONG THE RIGHT REAR QTR. PANEL. OWNER STATES SHE SAW A WHITE DELIVERY VAN PARKED ACROSS FROM HER STALL IN THE LOT BUT DID NOT ACTUALLY SEE HER VEHICLE GET HIT. OWNER REPORTS NO INJURIES. WAS ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
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);