Such 'pitcher pumps' will only pump from about 20' depth. Deep well hand pumps are quite expensive - and you need a really super strong arm. Commonly those types of pumps are hooked up to windmills - livestock watering.
I’ve seen our water treatment guy use one in our house and our well is roughly 100 ft deep. At 200 ft, it might be a bit more difficult.