Extracting FIPS code of county given city/town and state name.
‣ Combining and importing data from various tables (in JSON format) in MySQL to find a county's FIPS code when provided with the city/town and state name in U.S.
‣ The primary purpose of the query is to automate, increase accuracy and ease the process of finding this information as this particular data is not readily available online.
‣ Note: Some locations have several counties and so additional research must be done for these locations.