Please use the following API to fetch all the county, city, town, village wise data to the database based on year.
More:
Census API