Looking at your sample data, New York consists of five rows and four that are filled.

How do you expect to get on New York?

And maybe further, what do you want to see?

Can you provide a sample output for say just New York?