This bird is a sharp-shinned hawk. It's a very small raptor, and colorful. It's likely to be seen around backyard feeders, picking off unwary seed eaters.
These photos are of a yellow bellied sapsucker. I was surprised to learn that they are native to my area. I had thought they were a southern bird. They eat bugs that they dig for in trees, and they also lick up the sap that drips down the tree trunk after they peck a hole.