Website Name: NO Name This folder has the data for the link: https://mrfdata.hmhs.com/ There were 15 states json files. Each state json file is in corresponding folder witht the reporting entity name in Short form. Used: BCBS ==> Blue Cross Blue Shield e.g BCBSArizone folder has the json file 2022-12-01_Blue_Cross_and_Blue_Shield_of_Arizona_index.json BC ==> Blue Cross e.g BCIdaho folder has the file 2022-12-01_Blue_Cross_of_Idaho_index.json Similarly for the other short forms HBCBS ==> Highmark Blue Cross Blue Shield HBS ==> Highmark Blue Shield Detials of each state folder/json file is given below: ---------------------------------------------Detials---------------------------------------------------------------------- ----------------------------------------------------------1----------------------------------------------------------------- Folder: BCBSND json file: 2022-12-01_BlueCrossBlueShieldND_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Blue Cross Blue Shield of North Dakota 39 links for json.gz were found in 2022-12-01_BlueCrossBlueShieldND_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_BlueCrossBlueShieldND_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------2------------------------------------------------------------ Folder: BCBSLouisana json file: 2022-12-01_Blue_Cross_Blue_Shield_Louisana_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in 2022-12-01_Blue_Cross_Blue_Shield_Louisana_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_Blue_Shield_Louisana_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------3-------------------------------------------------------- Folder: BCBSWyoming json file: 2022-12-01_Blue_Cross_Blue_Shield_of_Wyoming_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Blue Cross Blue Shield of Wyoming 1231 links for json.gz were found in ./2022-12-01_Blue_Cross_Blue_Shield_of_Wyoming_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_Blue_Shield_of_Wyoming_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------4------------------------------------------------------- Folder: BCBSArizona json file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Arizona_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Blue_Cross_and_Blue_Shield_of_Arizona_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Arizona_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------5------------------------------------------------------ Folder: BCBSFlorida json file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Florida_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Blue_Cross_and_Blue_Shield_of_Florida_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Florida_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------6------------------------------------------------------ Folder: BCBSMinnesota json file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Minnesota_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Blue_Cross_and_Blue_Shield_of_Minnesota_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Minnesota_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------7------------------------------------------------------ Folder: BCBSNebraska json file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Nebraska_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Blue_Cross_and_Blue_Shield_of_Nebraska_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_and_Blue_Shield_of_Nebraska_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------8------------------------------------------------------ Folder: BCIdaho json file: 2022-12-01_Blue_Cross_of_Idaho_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Blue_Cross_of_Idaho_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Blue_Cross_of_Idaho_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------9------------------------------------------------------ Folder: HBCBSDelaware json file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Delaware_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Delaware 1571 links for json.gz were found in ./2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Delaware_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Delaware_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------10------------------------------------------------------ Folder: HBCBSPennsylvania json file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Pennsylvania_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield Pennsylvania 9251 links for json.gz were found in ./2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Pennsylvania_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_Pennsylvania_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------11------------------------------------------------------ Folder: HBCBSWestVirginia json file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_West_Virginia_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Cross Blue Shield West Virginia 768 links for json.gz were found in ./2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_West_Virginia_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Cross_Blue_Shield_of_West_Virginia_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------12------------------------------------------------------ Folder: HBSNortheasternNewYork json file: 2022-12-01_Highmark_Blue_Shield_of_Northeastern_New_York_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Shield of Northeastern New York 779 links for json.gz were found in ./2022-12-01_Highmark_Blue_Shield_of_Northeastern_New_York_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Shield_of_Northeastern_New_York_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------13------------------------------------------------------ Folder: HBSPennsylvania json file: 2022-12-01_Highmark_Blue_Shield_of_Pennsylvania_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Shield Pennsylivania 3408 links for json.gz were found in ./2022-12-01_Highmark_Blue_Shield_of_Pennsylvania_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Shield_of_Pennsylvania_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------14------------------------------------------------------ Folder: HBSWestermNewYork json file: 2022-12-01_Highmark_Blue_Shield_of_Western_New_York_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Shield Pennsylivania 779 links for json.gz were found in ./2022-12-01_Highmark_Blue_Shield_of_Western_New_York_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Highmark_Blue_Shield_of_Western_New_York_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state --------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------15------------------------------------------------------ Folder: INA json file: 2022-12-01_Independence_National_Alliance_index.json reporting_entity_type: Health Insurance Issuer reporting_entity_name: Highmark Blue Shield Pennsylivania 9251 links for json.gz were found in ./2022-12-01_Independence_National_Alliance_index.json As these links are all not have a .json.gz ending, instead some links leads to other webpages with nothing to download, so we will filter the links from which we can get the data. All the downloadable links are also written to this file: 2022-12-01_Independence_National_Alliance_index.txt All the downloaded file are extracted from .json.gz to .json and then converted into .csv. After conversion the .json files are deleted to save memory. --> All the csvs are then merged and joined based on the ZIP3 code for the corresponding state ---------------------------------------------------------------------------------------------------------------------------