removed loop to get socrata data, found a single query to do it.