crash_reports
3 rows where date = "2019-06-22"
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-22
Time:
09:30
Address:
WALNUT ST & MADISON AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED HE WAS GOING N/B ON WALNUT NEAR MADISON AVE ST WHEN HE STOPPED FOR A PEDESTRIAN CROSSING THE STREET. VEHICLE #2 THEN REAR ENDED HIM. OPERATOR #2 REPORTS SHE WAS GOING N/B ON WALNUT ST WHEN SHE OBSERVED ANOTHER VEHICLE BACKING INTO A PARKING SPACE. SHE THEN DROVE AROUND IT NOT SEEING VEHICLE #1 WAS STOPPED AHEAD. SHE WAS UNABLE TO REACT IN TIME TO STOP BEFORE CRASHING INTO THE REAR OF VEHICLE #1.
Keywords:
Crash, Ped
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3499376
Longitude:
-71.2068697
Location:
Case
number:
Date:
2019-06-22
Time:
13:33
Address:
1349 WASHINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he had backed out of his parking spot at the rear of #1349 Washington St and about to drive forward when crash occurred with MV#2. The operator of MV#2 stated that he was also backing out of a parking spot at the rear of #1349 Washington St directly across from MV#1 when crash occurred with MV#1. No injuries, no tows.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3490978
Longitude:
-71.2284527
Location:
Case
number:
Date:
2019-06-22
Time:
09:44
Address:
16 CREHORE DR
Speed
limit:
25
Violation
cited:
no
Narrative:
OWNER OF MV 1 STATED THAT HE PARKED HIS VEHICLE IN FRONT OF HIS HOUSE ON THE STREET AT APPX. 4 PM YESTERDAY. THIS MORNING WHEN HE CAME OUT TO HIS CAR HE NOTICED THAT HIS DRIVERS SIDE HAD DAMAGE CONSISTENT WITH ANOTHER CAR SIDESWIPING HIS CAR. Traffic Bureau Update (Officer Gaudet): On Thursday, June 27, 2019, I was forwarded possible video evidence from this accident by the residence of 17 Crehore Drive. The footage (capurtured by a NEST security camera affixed to the residence) shows a gray mini van (unknown make or model) traveling on Crehore Drive towards Goff Street. The vehicle takes a left turn onto Goff Street, parks, and a male party exits the vehicle and delievers a package to 16 Crehore Drive. There is no date or time associated with the video and I am unable to make out a license place number or identify the driver. I am unable to determine if this vehicle made contact with MV1.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3319425
Longitude:
-71.2595563
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);