crash_reports
3 rows where "datetime" is on date 2019-08-24
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-24
Time:
14:53
Address:
2345 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
Vehicle One was struck while parked in the Marriott Hotel parking lot sometime overnight. Minor damage to Passenger side mirror.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.346364
Longitude:
-71.2584662
Location:
Case
number:
Date:
2019-08-24
Time:
11:19
Address:
WATERTOWN ST & DUNSTAN RD
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 8-24-19 AT APPROX. 1119HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WATERTOWN AND DUNSTAN I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WATERTOWN. AS HE APPROACHED DUNSTAN ST. VEHICLE #2 CAME OUT OF THE STREET ENTERED THE TRAFFIC LANE AND HIT THE RIGHT SIDE OF HIS VEHICLE. VEHICLE #2 DRIVER STATES SHE WAS STOPPED AT THE STOP SIGN TRAVELING N-BOUND ON DUNSTAN. SHE LOOKED TO HER LEFT AND DIDN'T SEE ANY VEHICLES COMING, AS SHE ENTERED THE TRAFFIC LANE SHE WAS UNABLE TO AVOID HITTING VEHICLE #1. DRIVER STATES HER VISIBILITY WAS OBSTRUCTED BY A BLACK PICKUP PARKED ON THE SIDE OF THE ROAD ( MA REG: 7ZV435, 2011 FORD F150 PICKUP ). THE VEHICLE WAS PARKED LEGALLY AND HAD AN ACTIVE REGISTRATION. I WAS STOPPED BY A RESIDENT WHO STATED THERE ARE A LOT OF ACCIDENTS IN THIS AREA BECAUSE OF THE VISIBILITY OBSTRUCTION CAUSED BY VEHICLES PARKING IN THE AREA. VEHICLE #1 HAD RIGHT FRONT SIDE DAMAGE. VEHICLE #2 HAD SEVERE FRONT END DAMAGE, FRONT AIRBAG DEPLOYMENT AND WAS TOWED BY TODYS. BOTH PARTIES WERE EXAMINED BY MEDICS AND SIGNED PATIENT REFUSALS. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Airbag, Crash, Severe
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3508016
Longitude:
-71.222578
Location:
Case
number:
Date:
2019-08-24
Time:
07:30
Address:
212 KENRICK ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV1 stated he parked Northbound facing Kenrick St. in the driveway of the golf course across from the club house at approximately 0600 hrs. When the operator returned to his vehicle at 0730 hrs, there was minor front drivers side damage. There is no other vehicle information at this time, and no cameras in the area.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3447332
Longitude:
-71.1708193
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);