crash_reports
3 rows where address = "33 AUSTIN ST" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: street1, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-27
Time:
15:54
Address:
33 AUSTIN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Ms. Samantha Mirrer stated that she left her vehicle in the Star Market parking lot at 33 Austin St. She returned to find that the vehicle had been struck on the driver's side. Of yet, the other vehicle is unknown. Star Market has video surveillance of the parking lot, however the view of Ms. Mirrer's vehicle is blocked, and license plates are unable to be made out.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
Location:
Case
number:
Date:
2021-11-24
Time:
12:44
Address:
33 AUSTIN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 11-24-21 AT APPROX. 1244HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 33 AUSTIN ST. ( STAR MARKET LOT ) I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE PULLED INTO THE LOT AND STOPPED BECAUSE VEHICLE #2 WAS BACKING OUT OF A STALL. AS VEHICLE #2 GOT CLOSER THE DRIVER OF VEHICLE #1 BEEPED AND WAS THEN HIT IN THE FRONT RIGHT QTR. PANEL. AFTER CRASHING HE NOTICED THAT NO ONE WAS OPERATING VEHICLE #2. THE OWNER OF VEHICLE #2 HEARD THE CRASH BEHIND HIM AS HE WAS WALKING TOWARD STAR MARKET. WHEN THE OWNER NOTICED IT WAS HIS VEHICLE HE STOOD BY TO EXCHANGE INFORMATION. OWNER OF VEHICLE #2 STATED HE PARKED HIS CAR IN A STALL AND WALKED AWAY. HE STATED THE CAR IS 17 YEARS OLD AND THE EMERGENCY BRAKE MUST HAVE FAILED AND AS A RESULT HIS VEHICLE ROLLED BACKWARDS OUT OF THE STALL AND HIT VEHICLE #1. VEHICLE #1 HAD RIGHT FRONT QTR. PANEL DAMAGE. VEHICLE #2 HAD LEFT SIDE SCRAPES AND DENTS. BOTH PARTIES REPORTED NO INJURIES. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.NEITHER VEHICLE WAS TOWED.
Keywords:
Crash, Walk
Dcc:
Defective equipment
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
Location:
Case
number:
Date:
2022-06-05
Time:
15:39
Address:
33 AUSTIN ST
Speed
limit:
10
Violation
cited:
yes
Narrative:
Vehicle 1 was parked in the parking lot of the Star Market at #33 Austin St when Vehicle 2 attempted to park in the adjacent parking space. While doing so, the front left corner of Vehicle 2 made contact with the driver's side rear door and rear quarter panel causing minor scratches to both vehicles. The operator of Vehicle 1 confronted the operator of Vehicle 2 who stated "You're crazy!" before going across the street to get coffee from Starbucks. When the operator of Vehicle 2 returned she apologized to the operator of Vehicle 1 but felt uncomfortable and left the area without providing her information to the other operator. The operator of Vehicle 2 was issued MA Uniform Citation #T1448098 for leaving the scene with property damage and an incident report was completed (See Report #22019777).There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Citation, Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
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);