crash_reports
3 rows where "datetime" is on date 2019-04-27 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-27
Time:
12:02
Address:
CENTRE ST & CARLTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 REPORTS THAT SHE WAS N/B ON CENTRE ST ABOUT TO TURN LEFT ONTO CARLTON ST WHEN SHE REALIZED IT WAS A ONE WAY ST. SHE THEN BEGAN TO GO FORWARD AGAIN ON CENTRE ST WHEN VEHICLE #2 CHANGED INTO HER LANE JUST AS SHE BEGAN TO DRIVE FORWARD AGAIN. OPERATOR #2 STATED HE WAS GOING N/B ON CENTRE ST WHEN HE OBSERVED VEHICLE #1 STOPPED AHEAD OF HIM. HE THEN PROCEEDED AROUND VEHICLE #1 THEN BACK INTO HER LANE BECAUSE HE WAS GOING TO MAKE A LEFT TURN INTO #249 CENTRE ST, NEWTON AUTOMOTIVE SERVICES WHICH IS JUST A SHORT DISTANCE AHEAD OF WHERE VEHICLE #1 WAS STOPPED. AS VEHICLE #2 DROVE AROUND VEHICLE #1 WHO WAS STILL STOPPED HE ENTERED BACK INTO HIS ORIGINAL LANE WHEN VEHICLE #1 SUDDENLY DROVE FORWARD HITTING HIS VEHICLE. OPERATOR #1 FURTHER STATED ONCE SHE REALIZED CARLTON ST WAS A ONE WAY ST SHE BEGAN TO GO FORWARD AGAIN, NEVER SEEING VEHICLE #2 APPROACHING FROM HER RIGHT SIDE.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.359124
Longitude:
-71.1851825
Location:
Case
number:
Date:
2019-04-27
Time:
15:51
Address:
191 NEEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle 1 was travelling southbound on Needham St in the left turn lane getting ready to turn left into 191 Needham St, which was the next block away. Vehicle 2 was travelling southbound as well, and took a left turn into the parking lot at 188 Needham St. At this time vehicle 1 was parallel to vehicle 2. The front left of vehicle 2 hit the front right of vehicle 1. I observed moderate damage to the point of impact on both vehicles. Both vehicles were towed by Tody's to their lot. No one was injured due to the accident.
Keywords:
Crash, Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3113604
Longitude:
-71.213892
Location:
Case
number:
Date:
2019-04-27
Time:
17:16
Address:
1349 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states he was parked in vehicle #1 (MA reg 396FJ3) in front of 1349 Washington St when vehicle #2 (MA reg 61YM44) backed into him. Operator #2 states he was backing up in his metered space and "may or may not have" made contact with vehicle #1 while doing so. Operator #2 was not sure if he hit vehicle #1 however Opertaor #1 and the witness/vehicle owner in the passenger seat state they distinctly felt vehicle #1 shake when vehicle #2 backed into them. There are minor scratches on both cars that appear consistent with Operator #1 and the witness' statements. All parties declined medical attention and no tows were needed.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3490978
Longitude:
-71.2284527
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);