Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Provider network, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-21523PRVBrian Fox2002-04-21UHC-49916-8554574755349335 Indian School Rd, Orlando, FL, 328460.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
PRV-24102PRVMary Owens1943-01-19——726 Sunset Blvd, Atlanta, GA, 303940.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26085PRVAnn Nunez1988-07-19UHC-74358-70—2786 Hillcrest Rd, Atlanta, GA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-29069PRVNatan G Lee1995-03-24—50876454339123 Desert Sky Blvd # 870, Plano, TX, 750980.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
PRV-24843PRVWillie G Mreno1965-07-25—2845322100—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-21497PRVEmma Parker1943-05-15——3550 Palm Dr # 756, Fresno, CA, 937540.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25624PRVPeter Cunningham1965-02-27UHC-99835-7871432073997919 Union St, Plano, TX, 750050.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-26463PRVSandra A Stevens1963-08-22UHC-88900-3938538658406300 Lake View Rd, Tempe, AZ0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
PRV-22067PRVHeather Vazquez1979-12-04——5238 Harbor Blvd Apt 2, Chandler, AZ, 852580.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25353PRVKyle Hill2005-12-22UHC-70211-7741376610124264 Market St Apt 26, Charlotte, NC, 282680.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28429PRVAndrew Montgomery1945-08-15—74724011353903 Mesa Dr, San Antonio, TX, 782840.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-25218PRVArthur T Gibson1982-09-25—29330561596998 Cedar Ln, Austin, TX, 787360.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26659PRVSusan Richards1983-02-21UHC-61678-3396868075947732 Mountain View Dr, Tempe, AZ, 852460.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-24305PRVMegan Burke1908-12-16——7111 Ocean Ave # 193, Seattle, WA, 981280.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27084PRVDebra Hanson1952-05-14UHC-88261-03—2273 Main St, San Diego, CA, 921960.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23339PRVSamuel Williamsson1960-08-28—85394199141245 Sage Ct, Orlando, FL, 328370.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27107PRVKevin Ruiz1971-07-27——5977 Desert Sky Blvd, Austin, TX, 787580.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20758PRVRuth Vargas2001-04-09—84692708477794 Union St, Glendale, AZ0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
PRV-22084PRVAndrew Fisher1976-09-27UHC-49611-1762184182236348 Bayshore Dr, Tampa, FL, 336220.68Phone reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-24596PRVRebecca Y Ramirez1951-02-24——9399 Grand Ave # 848, Dallas, TX, 752230.68Name re-casedUnit split from streetGender normalisedPlaceholder values cleared
PRV-24019PRVOmar Mason1987-04-02UHC-04768-2358554532908246 Union St, Minneapolis, MN, 554450.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22654PRVJoan Mills1957-12-16UHC-84014-04—1972 Hillcrest Rd Apt 14, Scottsdale, AZ, 852140.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22735PRVCharlotte Nunze1991-06-08—69969975363202 Meadow Ln, Phoenix, AZ, 850160.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-28081PRVJosh Gbison1987-11-05——4752 Washington St, Tempe, AZ, 852320.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24837PRVCamila Vargas2001-07-17—44238902754897 Main St, Dallas, TX, 752940.68Two-digit birth yearPhone reformattedState name converted to codePlaceholder values cleared
PRV-24047PRVGary P Coopeer——95726743227995 Sage Ct, Atlanta, GA, 303210.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26157PRVStephen M Harrison1955-03-22—37528473389547 Indian School Rd, San Antonio, TX, 782260.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-28896PRVDouglas Russell1997-07-01——3018 Harbor Blvd Apt 3, Sacramento, CA, 958720.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
PRV-21954PRVRaymond Rodriguez1980-09-11—70431246286125 Meadow Ln Apt 11, Denver, CO, 802880.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
PRV-26842PRVKen James1941-08-01——2485 Baseline Rd, Gilbert, AZ, 852290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20916PRVPriya V West2006-07-03—21541214537070 Oak St, Charlotte, NC, 282520.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-23034PRVJanice E Dixon1990-10-08UHC-72655-75—7673 Indian School Rd, Tucson, AZ, 857030.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23249PRVSteven Phillips1955-03-05UHC-41677-846174680026486 Bayshore Dr Apt 30, Nashville, TN, 372240.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
PRV-23140PRVEdward Powell1968-08-27——1518 Indian School Rd, Tucson, AZ, 857310.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22339PRVRebecca F Hughes1982-04-18UHC-55608-5191041064446044 Palm Dr, San Diego, CA, 921700.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
PRV-27666PRVJustin Rojas——41030072712150 Highland Ave, Atlanta, GA, 303320.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
PRV-26784PRVSaniago Gibson2001-04-19UHC-15032-49—9582 Willow Ct, Houston, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-27806PRVDnise Santos—UHC-49411-48—5029 Jefferson Ave, Columbus, OH, 432550.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24109PRVJonathan Peterson—UHC-80951-2486684926213469 Spring St, Plano, TX, 750190.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
PRV-23584PRV—Junk1940-05-12——298 Sunset Blvd, Phoenix, AZ, 850120.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
PRV-26228PRVWallace Carolyn1997-07-24UHC-71193-563997914383—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26141PRVElijah Gutierrez1966-05-09——8582 Washington St, San Antonio, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-28188PRVMarcus Montgoery1966-02-07UHC-94734-12—1942 Meadow Ln, Chandler, AZ, 852030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28189PRVMarcus Montgoery1966-02-07UHC-94734-12—1942 Meadow Ln, Chandler, AZ, 852030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27063PRVJason Burns1975-12-26UHC-85963-0673535377195434 Camelback Rd, Eden Prairie, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-26409PRVMaria Diaz1985-09-16—67263320251719 Spring St, Miami, FL, 331590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26465PRVRachel Y Flores2001-04-19——3695 Maple Ave, Houston, TX, 770450.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-27563PRVMei Maldonado1945-11-02UHC-86595-66—7457 Park Pl, Houston, TX, 770820.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27724PRVAbigail Gibson1947-09-22UHC-96128-0250255963988715 Mesa Dr, Dallas, TX, 752390.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-23851PRVLaura Gonzalez2003-10-20—85754619074629 Spring St, Scottsdale, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
9,596 rows, page 73 of 192PreviousNext