--- title: "Part 2: Turning Machine Readable into Human Readable šŸ¤–" description: You have access to your in-network negotiated rate file links. Now what? Here's a step-by-step guide on how to turn those links into useful information. image: https://getwinstonhealth.com/hubfs/undraw_Code_typing_re_p8b9.png --- [![Winston Health Logo Long](https://getwinstonhealth.com/hubfs/Winston%20Health%20Logo%20Long.svg)](https://www.getwinstonhealth.com) - PRODUCTS - [Healthcare Navigation](https://getwinstonhealth.com/healthcare-navigation) - [Financial Assistance](https://getwinstonhealth.com/financial-assistance) - [Health & Wellness](https://getwinstonhealth.com/wellness) - [Medical Record Data](https://getwinstonhealth.com/medical-record-data) - [ABOUT](https://getwinstonhealth.com/about-us) - [BLOG](https://getwinstonhealth.com/blog) - [CONTACT US](https://getwinstonhealth.com/contact-us) [LOGIN](https://app.getwinstonhealth.com/login) [SCHEDULE DEMO](https://meetings.hubspot.com/mitchell-sweigart) health insurance # Part 2: Turning Machine Readable into Human Readable šŸ¤– You have access to your in-network negotiated rate file links. Now what? Here's a step-by-step guide on how to turn those links into useful information. [Mitchell Sweigart](https://getwinstonhealth.com/blog/author/mitchell-sweigart) Jul 11, 2023 --- Beep. Boop. Beep-boop. We're back with Part 2 of how to transform machine-readable price transparency in coverage (TIC) files into human-readable, actionable information. You can catch yourself up to speed by reading Part 1 [here](https://getwinstonhealth.com/blog/price-transparency-in-coverage-part-1). Now that everyone's caught up let's dive in. The links to all of our in-network negotiated rate files are in the file we generated at the end of Part 1. Now that we have that, the next step is to click each link to begin downloading each file onto your computer. That process is super manual,Ā  it can take a while, and, frankly, I don't recommend it, especially if you're running low on storage on your machine. Putting aside the manual effort involved in downloading each file, there's still a bunch of work to do to get the information contained in each of the newly downloaded files into human comprehendable info. Did you think the insurance carriers would make it easy on you? If you're adventurous or just accidentally click on a link to an in-network file, you'll quickly find yourself at what seems to be square one. The files come in a zipped up .gz file format (ie. 2023-06-19\_000008010\_in-network-rates\_01\_of\_15.json.gz). Once you double click to unzip them you'll see they are JSON, like our last Highmark file with the countless EINs. Like before, these files aren't necessarily straight forward to understand for the average joe. For the adventurous, CMS's Github repository and technical specifications are [here](https://github.com/CMSgov/price-transparency-guide). For everyone else, the tl;dr is that the files, when deconstructed, give consumers perfect visibility into the inter-workings of their health plan(s) and how procedures and services are billed. So that everyone can take advantage of this information, our team has made the Google Colab notebook that we use to deconstruct the JSON files available for everyone to use. You can access it [here](https://colab.research.google.com/drive/1SNMIcxbI_yNW8IEsrEOhpDK1ajCdl6pW?usp=sharing). To use the workbook, simply upload the file we generated in Part 1, replace the filename variable with the name of your file, and click run (play looking button to the left of "import requests"). After the script finishes and you click refresh, you'll see a new file for each of your networks (ie. human\_readable\_file\_378000000106.csv, human\_readable\_file\_378000000328.csv, human\_readable\_file\_378000008010.csv, etc.). Download those files and continue reading. Whether you're parsing through the JSON files individually or using our shortcut above, you'll find a few key elements that are needed to make sense of it all. Here are those elements and a brief description of each one. 'billing\_code': The code used by a plan or issuer or its in-network providers to identify health care items or services for purposes of billing, adjudicating, and paying claims for a covered item or service 'billing\_code\_type': Common billing code types. Please see a list of theĀ [currently allowed codes](https://github.com/CMSgov/price-transparency-guide/tree/master/schemas/in-network-rates#additional-notes-concerning-billing_code_type) for more information. 'negotiation\_arrangement': An indication as to whether a reimbursement arrangement other than a standard fee-for-service model applies. Allowed values: "ffs", "bundle", or "capitation" 'negotiated\_type': There are a few ways in which negotiated rates can happen. Allowed values: "negotiated", "derived", "fee schedule", "percentage", and "per diem". SeeĀ [additional notes](https://github.com/CMSgov/price-transparency-guide/tree/master/schemas/in-network-rates#additional-notes-1). 'negotiated\_rate': The dollar or percentage amount based on theĀ `negotiation_type`'expiration\_date': The date in which the agreement for the `negotiated_price`Ā based on theĀ `negotiated_type` ends. 'billing\_class': Allowed values: "professional" (physician), "institutional" (facility) 'service\_code': TheĀ [CMS-maintained two-digit code](https://www.cms.gov/Medicare/Coding/place-of-service-codes/Place_of_Service_Code_Set)Ā that is placed on a professional claim to indicate the setting in which a service was provided. When attribute ofĀ `billing_class`Ā has the value of "professional",Ā `service_code` is required. 'billing\_code\_modifier': An array of strings. There are certain billing code types that allow for modifiers (e.g. The CPT coding type allows for modifiers). If a negotiated rate for a billing code type is dependent on a modifier for the reported item or service, then an additional negotiated price object should be included to represent the difference. You can find more information on specific modifiers [here](https://www.aapc.com/modifiers/). 'tin': Either the unique identification number issued by the Internal Revenue Service (IRS) for type "ein" or the provider's npi for type "npi". 'tin\_type': Allowed values: "ein" and "npi". 'npi': if billing\_class is professional, this is the npi of the provider the negotiated rate is associated to. Now, I know what you're thinking. Yes, the files are massive and at times, okay maybe all of the time, unwieldy. As they say, "you gotta break a few eggs to make an omelet". Okay, so how can we now use this data? Well, let's say you want to price shop a knee replacement. With some searching, you find that CPT 27446 is for "Repair of knee joint". Perfect, let's see what we're dealing with. ![Screenshot 2023-07-11 at 5.30.25 PM](https://getwinstonhealth.com/hs-fs/hubfs/Screenshot%202023-07-11%20at%205.30.25%20PM.png?width=2466&height=874&name=Screenshot%202023-07-11%20at%205.30.25%20PM.png) Woah! The highest costing facility (billing\_class == institution) is nearly 2x the lowest costing facility? Yes. Yes, really. This is the power of healthcare shopping. By enabling consumers with this information and the right incentives, we can literally prevent claims for shoppable services from being double what they might otherwise be. For anyone interested, [NPIĀ ](https://npidb.org/organizations/ambulatory_health_care/ambulatory-surgical_261qa1903x/1750658092.aspx)[175065809](https://npidb.org/organizations/ambulatory_health_care/ambulatory-surgical_261qa1903x/1750658092.aspx)[2](https://npidb.org/organizations/ambulatory_health_care/ambulatory-surgical_261qa1903x/1750658092.aspx) is the Advanced Center For Surgery, LLC (3280 Pleasant Valley BLVD. Altoona, PA) and [NPI](https://npidb.org/organizations/hospitals/general-acute-care-hospital_282n00000x/1801897038.aspx)[1801897038](https://npidb.org/organizations/hospitals/general-acute-care-hospital_282n00000x/1801897038.aspx) is Conemaugh Memorial Medical Center LLC (1086 Franklin ST Johnstown, PA). They are 48 minĀ (45.7Ā mi) apart via US-22 W and US-219 S. Would you or anyone you know drive 45 miles to save $14k? Follow along for Part 3 where we'll dive into how we'll use NPIs to layer physician and facility information into our excel based healthcare shopping tool! P.S. If this seems like a lot of work, it's because it is, and we haven't even scratched the surface. If you or your clients are looking for an best-in-class, easy-to-use, healthcare shopping tool that will save them money [schedule a meeting with us today](https://meetings.hubspot.com/mitchell-sweigart) to see how we can help. [health insurance](https://getwinstonhealth.com/blog/tag/health-insurance) [price-transparency](https://getwinstonhealth.com/blog/tag/price-transparency) ## Similar posts health insurance ### [Part 1: Turning Machine Readable into Human Readable šŸ¤–](https://getwinstonhealth.com/blog/price-transparency-in-coverage-part-1) Unpack price transparency in coverage files to give you and your employees new insight into the interworkings of your health plan(s). Mitchell Sweigart Jul 11, 2023 health insurance ### [Your Health is Your Wealth šŸ’°](https://getwinstonhealth.com/blog/health-is-wealth) Here are 5 ways your health directly impacts your wealth and bottom line Mitchell Sweigart Apr 1, 2023 health insurance ### [šŸ„ Blue (Oval) vs. Blue (Cross Blue Shield Association)](https://getwinstonhealth.com/blog/ford-vs-blue-cross-blue-shield-association-part-1) Ford's lawsuit against the Blue Cross Blue Shield Assoc. is a historic account of the rise of the largest insurance players in America. Mitchell Sweigart Jul 17, 2023 ### Get notified on new posts and insights Be the first to know about new insights to manage your healthcare costs, and the latest products and trends in the industry. ![Winston Health Logo Long](https://getwinstonhealth.com/hubfs/Winston%20Health%20Logo%20Long.svg) Winston Health 129 EĀ Charlotte Street Millersville, PA 17551 Ā  ### Product - [Healthcare Navigation](https://getwinstonhealth.com/healthcare-navigation) - [Financial Assistance](https://getwinstonhealth.com/financial-assistance) - [Health & Wellness](https://getwinstonhealth.com/wellness) - [Medical Record Data](https://getwinstonhealth.com/medical-record-data) ### Resources - [Blog](https://getwinstonhealth.com/blog) - [Terms of Use](https://getwinstonhealth.com/terms-of-use) - [Privacy Policy](https://getwinstonhealth.com/privacy-policy) ### Company - [About Us](https://getwinstonhealth.com/about-us) - [Careers](https://wellfound.com/company/winston-health) - [Contact Us](https://getwinstonhealth.com/contact-us) Ā© 2023 Winston Health All rights reserved [Powered by Atlas - a B2B SaaS HubSpot theme](https://www.kalungi.com/atlas-hubspot-theme-for-b2b-saas-software) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Mitchell Sweigart", "url" : "https://getwinstonhealth.com/blog/author/mitchell-sweigart" }, "dateModified" : "2023-07-12T15:39:04.666Z", "datePublished" : "2023-07-11T21:48:19.000Z", "headline" : "Part 2: Turning Machine Readable into Human Readable šŸ¤–", "image" : [ "https://getwinstonhealth.com/hubfs/undraw_Code_typing_re_p8b9.png" ], "mainEntityOfPage" : { "@id" : "https://getwinstonhealth.com/blog/price-transparency-in-coverage-part-2", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://getwinstonhealth.com/hubfs/Winston%20Health%20(500%20%C3%97%2080%20px).svg" }, "name" : "Winston Health" } } ```