Healthcare provider data and medical marketing lists

About the CoLoCode™ - Co-Location Coding

The CoLoCode is a hyper-conformed version of the practice location data, making it possible to compare locations despite minor typographical errors in address fields. That makes a lot of things possible, including the operations described below.

A Way to Link Practitioners With Their Employers/Companies

The exclusive CarePrecise CoLoCode is used to identify individuals and organizations providing medical services at the same location. CarePrecise computes a CoLoCode for the full database of 6.2 million U.S. healthcare provider records.* It can help in determining practice size, and in finding practitioners who are co-workers. It can also be used to find a Type 1 (individual) provider's Type 2 (organization) records(s) (Type 1 to Type 2 crosswalk), and to find the workers at a given practice group (workplace to worker crosswalk).

  • View all providers working at every workplace (Worker-to-Workplace linkage)
  • Link physicians' Type 1 (individual) records with their Type 2 (business entity) records
  • Find all Type 2 records of any given location of service (organization's multiple NPI records)

The CoLoCode is constructed using a proprietary algorithm that hyper-conforms practice location data for the 6.2 million US healthcare providers. Going well beyond the US Postal Service's "Pub 28" standard, the CoLoCode accounts for addresses that may have been entered very differently. For example, "2525 West 33rd Street, Suite 205" is understood to be the same location as "2525 W 33 #205," as well as many other variations.

The CoLoCode is a great asset when merging lists of individuals with lists of their companies, or de-duplicating databases, and is key element of CarePrecise's Qo-Relate™ record-linkage processing.

 

People Working at the Same Locations

Here's how a query is structured that links all providers having the same CoLoCode, in a manner like this:

Swipe left to view all...

Click to open graphic...


The "Names tables" are shown in the example, but you can also include address, phone/fax, and other tables.

The "CoLoCode table" is used twice in the query; the first one is the CoLoCode for the provider you want to find co-workers for, and the second one is going to pull all of the NPI numbers for people (and companies) listing that location for their place of practice. A count of the workers having an organization's CoLoCode can be an indicator of the size of the organization.

 

Worker-to-Workplace Linkage

The same configuration works to locate the workplace (organization) name for a given worker. On the keft side we specify Type 1 records (individuals), and on the right side we specify Type 2 records (organizations), to arrive at the "worker-to-workplace" connection, and a rfow that contains both the individual's record and the organization's record. Once again, the graphic shows only Names tables, but other tables would be included; such as address, phone/fax, and taxonomy/specialty/license.

Swipe left to view all...

Click to open graphic...

 

Using the CoLoCode in Excel

If you have an Excel file containing a CoLoCode column, simply sort the file on the CoLoCode column. Where you see a cluster of the same CoLoCodes, these are records with the same practice location. If your Excel file also contains the EntityType field, then the record(s) of Type 2 identify the organization (workplace), and the records of Type 1 identify the individuals (workers).

 

CoLoCoding Beyond Healthcare Provider Data

The powerful CoLoCode feature is available only from CarePrecise. It is present in CarePrecise datasets wherever location data is available, (with the exception of the OtherPracticeLocations table at this time). But it can also be used on any dataset that contains street address field(s) (line 1 only, or lines 1 and 2), city, state, and Zip Code® (5-digit or Zip+4) fields, and a unique ID field.

CarePrecise can provide CoLoCode services for a wide range of applications. Contact us for information.