The file machine_readable_homepages.csv provides links to insurer homepages for their compliance with insurer price transparency. It is a flat file
with the following schema:
| Name | Description | Type | Definition | Required | Example Value |
|---|---|---|---|---|---|
| id | Record integral primary key | Integer | A primary key for the record, to allow for cross-referencing index files. | Yes | 1 |
| insurer_name_legal | Insurer Name (legal) | String | The legal name of the insurer, i.e. the insurer's legal name. | No | United Healthcare |
| insurer_name_common | Insurer Name (common) | String | The common name of the insurer, i.e. the insurer's common name. | Yes | United Healthcare |
| price_transparency_url | Price Transparency URL | String | A (purported) url documenting insurer's compliance with price transparency. | Yes | https://transparency-in-coverage.uhc.com/ |
| price_transparency_url_status | Price Transparency URL Status. | Enum("up", "down", "corrupt") | A status code for the purported url for the purported price transparency url. | Yes | up |
| supplemental_url | Supplemental URL | String | A url for any supplemental information pertaining to the particular transparency homepage in question. | No | https://www.uhc.com/content/dam/uhcdotcom/en/HealthReform/PDF/Provisions/reform-external-transparancy-FAQs.pdf |
| last_updated_date | Last Updated Date | String | The date in which this record (not the price transparency homepage) was last updated. Date must be in an ISO 8601 format (i.e. YYYY-MM-DD). | Yes | 2022-04-14 |
Note:
The state_or_region entry, if entered, must be one of the following ABBREV standardized abbreviation strings:
| State or Region | ABBREV |
|---|---|
| Alabama | AL |
| Alaska | AK |
| American Samoa | AS |
| Arizona | AZ |
| Arkansas | AR |
| California | CA |
| Colorado | CO |
| Connecticut | CT |
| Delaware | DE |
| District of Columbia | DC |
| Florida | FL |
| Georgia | GA |
| Guam | GU |
| Hawaii | HI |
| Idaho | ID |
| Illinois | IL |
| Indiana | IN |
| Iowa | IA |
| Kansas | KS |
| Kentucky | KY |
| Louisiana | LA |
| Maine | ME |
| Maryland | MD |
| Massachusetts | MA |
| Michigan | MI |
| Minnesota | MN |
| Mississippi | MS |
| Missouri | MO |
| Montana | MT |
| Nebraska | NE |
| Nevada | NV |
| New Hampshire | NH |
| New Jersey | NJ |
| New Mexico | NM |
| New York | NY |
| North Carolina | NC |
| North Dakota | ND |
| Northern Mariana Islands | MP |
| Ohio | OH |
| Oklahoma | OK |
| Oregon | OR |
| Pennsylvania | PA |
| Puerto Rico | PR |
| Rhode Island | RI |
| South Carolina | SC |
| South Dakota | SD |
| Tennessee | TN |
| Texas | TX |
| Utah | UT |
| Vermont | VT |
| Virgin Islands | VI |
| Virginia | VA |
| Washington | WA |
| West Virginia | WV |
| Wisconsin | WI |
| Wyoming | WY |