crash_reports
2 rows where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2022-06-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-04
Time:
17:55
Address:
22 LANGLEY RD
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV1 was turning left exiting the parking lot at the rear of 22 Langley Rd onto Lyman St when she struck a fire hydrant and two concrete column's protecting the hydrant. MV1 sustained minor damage to the front drivers side fender and drivers door. Two concrete column's were knocked over as well as the hydrant being dislodged. The operator of MV1 was uninjured. MV1 was able to drive away from the scene. Photos of the damage to the vehicle as well as the hydrant and concrete column's were submitted to the IT Bureau. DPW was notified to replace the hydrant and concrete column's.
Keywords:
Fire, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3311629
Longitude:
-71.1933552
Location:
Case
number:
Date:
2022-06-09
Time:
15:53
Address:
461 WOLCOTT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-9-22 AT APPROX. 1553HRS. WHILE WORKING N497 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT 469 WOLCOTT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WOLCOTT ST. HE STATES VEHICLE #2 WAS BACKING OUT OF 469 WOLCOTT AT A HIGH RATE OF SPEED. HE STATES HE BEEPED TO MAKE HIS PRESENCE KNOWN BUT WAS STILL HIT IN THE LEFT FRONT QTR. PANEL BY VEHICLE #2. HE STATES AFTER THE CRASH VEHICLE #2 SPED OFF TOWARD LEXINGTON AT A HIGH RATE OF SPEED. DRIVER OF VEHICLE #1 STATES HE GOT THE PLATE NUMBER OF VEHICLE #2 ( MA REG : 225LZ2 ). AS OF THE WRITING OF THIS REPORT I HAVE BEEN UNABLE TO MAKE CONTACT WITH THE OWNER OF VEHICLE #2. VEHICLE #1 HAD MINOR LEFT FRONT END QTR PANEL DAMAGE. HE REPORTED NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.348988
Longitude:
-71.2467486
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);