I haven’t spent much time looking at any place other than New York. But there’s census data, tax data, and a lot of public records. The number of empty units is small. The total is probably close to 40k, but that’s a fuzzy number and moving target. That includes regular vacant units.

https://gothamist.com/news/how-many-nyc-apartments-are-vacan...