crash_reports
2 rows where dcc contains "Followed too closely", dcc_code = "["5"]" and intersection = 0
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-02
Time:
18:33
Address:
414 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/2/19 I was working N503 when I responded to Watertown St. at West St. for a report of an MVA hit and run. Upon arrival I met with Jennifer Nave who stated that she had rear ended a white colored SUV style vehicle in front of 414 Watertown St. Nave stated after she struck the vehicle she pulled over to the side of the road and the other vehicle drove away. Nave stated she was uninjured however had minor front end damage. Nave was unable to give any other description besides white SUV style vehicle.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3597079
Longitude:
-71.2023358
Location:
Case
number:
Date:
2019-01-18
Time:
09:29
Address:
1830 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
ON 1/18/2019 AT APPROX 0929HRS WHILE ASSIGNED TO 497 i RESPONDED TO THE AREA OF 1830 BEACON ST FOR A REPORT OF A TWO CAR COLLISION WITHOUT INJURY. UPON ARRIVAL I OBSERVED BOTH VEHICLES IN THE ROADWAY WITH UNDER RIDE , FLUIDS ALL OVER ROADWAY AND AIRBAG DEPLOYMENT IN THE REAR VEHICLE. BOTH OPERATORS WERE STANDING ON THE SIDEWALK. I SPOKE WITH THE OPERATOR OF MA DEALER REG 5550 MARISSA DEVLIN WHO STATED SHE HAD STOPPED FOR A PEDESTRIAN IN THE CROSSWALK WHEN SHE WAS STRUCK FROM BEHIND. I THAN SPOKE WITH THE OPERATOR OF MA PASSENGER REG 3NM859, THOMAS DORRANCE WHO STATED ' IT APPEARS I'M AT FAULT' DORRANCE STATED HE HAD NOT NOTICED DEVLIN SLOWING AND STOPPING AND RAN INTO THE BACK OF HER. DEVLIN WAS ALSO COMPLAINING OF PAIN FROM THE STEERING WHEEL AND AIRBAG, CATALDO RESPONDED. NFD AND TODYS TOW ARRIVED ON SCENE .NFD USED THE JAWS TO SEPARATE THE TWO VEHICLES TODYS WAS ABLE TO TOW BOTH VEHICLES. DORRANCE SIGNED A PATIENT REFUSAL WITH CATALDO. NFD SPREAD SPEEDY DRY AND CLEARED THE ROADWAY.
Keywords:
Airbag, Crosswalk, Fire, Ped, Speed
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3273334
Longitude:
-71.2389513
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);