crash_reports
2 rows where "datetime" is on date 2019-01-03 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-03
Time:
08:40
Address:
WASHINGTON ST & CHANNING ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 REPORTS THAT SHE WAS DRIVING W/B ON WASHINGTON ST WHEN IN THE AREA OF THE CROWN PLAZA/ CHANNING ST AREA, VEHICLE #2 MADE CONTACT WITH HER REAR DRIVERS SIDE QUARTER. BOTH VEHICLES CONTINUED STRAIGHT AHEAD AND OPERATOR #1 THOUGHT VEHICLE #2 WAS GOING TO PULL OVER AT SOME POINT BUT OPERATOR SUDDENLY VEERED OFF TO THE LEFT HEADING S/B TOWARDS THE WASHINGTON ST OVER PASS TO THE MASS PIKE. VEHICLE #2 WAS DESCRIBED AS A RED KIA SUV, MA REG 36TX70. THE OPERATOR APPEARED TO BE A MALE WITH DARK HAIR. A REGISTRATION QUERY SHOWED THE OWNER TO BE A BRIANNA COSKIE, 27 N MAIN ST UPTON MA. UPTON POLICE LATER MADE CONTACT WITH THE OWNERS SISTER WHO RELAYED THE MESSAGE TO BRIANNA TO CONTACT NEWTON POLICE. A SHORT TIME LATER I RECEIVED A CALL FROM BRIANNA COSKIE SHE REPORTED THAT HER BOYFRIEND WAS OPERATING HER VEHICLE THIS MORNING. SHE HAD ALREADY CONTACTED HIM PRIOR TO CALLING POLICE. HE TOLD BRIANNA THAT SOMEONE CUT HIM OFF THIS MORNING BUT WASN'T INVOLVED IN ANY ACCIDENT. I TOLD BRIANNA WHERE THE DAMAGE WAS ACCORDING TO THE OTHER DRIVER/ PASSENGER SIDE FRONT QUARTER. BRIANNA STATED SHE WOULD CHECK HER VEHICLE WHEN HER BOYFRIEND BRINGS IT BACK LATER TODAY, THEN CALL BACK. I LATER RECEIVED A CALL FROM THE DRIVER OF VEHICLE #2, IDENTIFIED AS ROBERT TEACHOUT, 27 N MAIN ST , UPTON MA. HE STATED THAT HE WAS IN NEWTON THIS MORNING AND REPORTED BEING CUT OFF BUT WASN'T INVOLVED IN A CRASH. MR TEACHOUT WHO WAS STILL IN THE AREA/ WATERTOWN WAS WILLING TO COME TO THE POLICE STATION AND HAVE POLICE LOOK AT HIS VEHICLE. HE LATER ARRIVED AT THE POLICE STATION AND I WAS UNABLE TO OBSERVE ANY VISIBLE DAMAGE TO THE AREA IN QUESTION/FRONT PASSENGER SIDE QUARTER. I HAD HIM E/MAIL PICTURES OF HIS CAR TO POLICE DISPATCH AND FROM THERE WAS GOING TO FORWARD THEM TO THE OTHER OPERATOR. I LATER UPDATED MS PEPI ABOUT THE OTHER OPERATOR BRINGING HIS VEHICLE TO THE POLICE STATION TO BE LOOKED AT. SHE WAS INFORMED THAT I COULDN'T FIND ANY VISIBLE DAMAGE TO THE AREA SHE SPECIFIED. I TOLD HER I WOULD E/MAIL THE PICTURES TAKEN FROM THE OTHER VEHICLE.
Keywords:
Crash, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3566909
Longitude:
-71.1874033
Location:
Case
number:
Date:
2019-01-03
Time:
14:42
Address:
NEWTONVILLE AVE & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date and time I responded to Walnut Street Bridge near Newtonville Ave for a two motor vehicle crash. Upon arrival I met with the operator of vehicle one Ms. Lanton, she stated she was stopped on Walnut Street bridge facing north when vehicle two struck her from behind. I spoke with the operator of vehicle two Ms. Stanek, she stated she was stopped and vehicle one rolled back into her. Neither party had injuries, I assisted in swapping their information and all parties were advised of the process.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3508165
Longitude:
-71.2069913
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);