crash_reports
3 rows where "datetime" is on date 2022-05-10
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-10
Time:
07:58
Address:
ELM ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED SHE WAS STOPPED N/B ON ELM STREET AT WEBSTER STREET WHEN SHE WAS REAR-ENDED BY MV#2. SHE STATED THAT MV#2 BACKED UP AND TOOK OFF. SHE DID NOT GET ANY LICENSE PLATE FROM THE OTHER VEHICLE. SHE STATED IT WAS A GRAY SEDAN WITH A WHITE FEMALE OPERATOR WITH BLOND HAIR. SHE STATED MV#2 LEFT NORTH-BOUND TOWARDS RIVER STREET. WE COULD NO LOCATE MV#2. THERE WAS MINOR DAMAGE TO THE REAR OF MV#1. TH E OPERATOR HAD NO INJURIES.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.34987
Longitude:
-71.229876
Location:
Case
number:
Date:
2022-05-10
Time:
13:45
Address:
57 CHARLESBANK ROAD
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 WAS TRAVELING WEST ON CHARLESBANK ROAD WHEN HIS DRIVERS SIDE MIRROR WAS STRUCK BY A BLACK TOW TRUCK TRAVELING IN THE OPPOSITE DIRECTION ON CHARLESBANK ROAD. OPERATOR OF MV 1 WAS IN THE PROPER LANE WHEN THE ACCIDENT OCCURRED. THE OPERATOR OF MV 1 WAS UNABLE TO GET A REGISTRATION PLATE OR FURTHER DESCRIPTION BECAUSE IT HAPPENED SO QUICKLY AND MV 2 DROVE OFF WITHOUT EXCHANGING INFORMATION. MODERATE DAMAGE SUSTAINED TO MV1 AND NO INJURIES WERE REPORTED.
Keywords:
Crash, Moderate
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.3587686
Longitude:
-71.1786414
Location:
Case
number:
Date:
2022-05-10
Time:
18:17
Address:
88 GARLAND RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday, May 10, 2022, MV1 was parked on the street in front of 88 Garland Rd. MV2 was backing out of the driveway from 85 Garland Rd and struck the drivers side door of MV1. MV1 drivers side door sustained heavy damage and was unable to be opened. The reporting party (Non-Motorist) stated that her Mother's vehicle (MV1) was parked in front of 88 Garland Rd all day and she had returned from work to find the damage. Operator of MV2 was not on scene upon arrival, but had left his information and was able to be contacted by phone in regard to the incident. Operator of MV2 confirmed what had occurred and stated he had minor damage to the rear end of his vehicle. Both parties were informed that a report would be generated in regard to the incident.
Keywords:
Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3337853
Longitude:
-71.2057721
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);