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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-23690PRVChristina Larson1955-07-09UHC-90485-9044896719352725 Mountain View Dr, Tampa, FL, 336680.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23243PRVRebecca Wagner2004-11-21——451 Mountain View Dr, Mesa, AZ, 852700.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23740PRVNicholas Price1942-09-03UHC-89676-4482668685305158 Baseline Rd, Fresno, CA, 937940.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22447PRVAlexander Gutierrez1969-08-03UHC-03255-0265626872803809 Oak St, Sacramento, CA, 958110.76Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-26143PRVPamela Brown2003-11-10——6660 Maple Ave, Orlando, FL, 328060.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-26231PRVAlexis Bwman2006-05-09UHC-55664-0774422020714239 Ridge Rd, Chandler, AZ, 852580.76Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-28831PRVZachary U Blacck2008-07-06UHC-26635-3677554954297325 Oak St, Orlando, FL, 328200.76Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-26303PRVTheresa Pena2007-12-11—52993785003868 Sunset Blvd # 377, Tempe, AZ, 852710.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
PRV-23190PRVOlivia Ramirez2002-09-06—91781490363487 Oak St, Austin, TX, 787630.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22593PRVPatricia O Gomez1940-10-24——3964 Highland Ave, Scottsdale, AZ, 852990.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20962PRVAlbert Diaz1958-10-18UHC-79011-2424170947584675 Mountain View Dr, San Diego, CA, 921730.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26298PRVAlexis Hill1952-02-12—61439043294089 River Rd, Tucson, AZ, 857880.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21175PRVRichard Matthews1958-07-27—8945794523276 Ridge Rd, Orlando, FL, 328570.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21176PRVRichard Matthews1958-07-27—8945794523276 Ridge Rd, Orlando, FL, 328570.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24413PRVCynthia W Sanders1982-11-05UHC-47513-4090961738803725 Central Ave, Tempe, AZ, 852130.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24769PRVDonald Matthews1995-02-05UHC-95205-0572948502311183 Grand Ave, Eden Prairie, MN, 553520.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-29308PRVRuth Hudson1966-02-12—70394780156660 Market St, Eden Prairie, MN, 553840.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24942PRVMelissa S Holmes1950-12-25UHC-70244-4854078803577566 Spring St, San Antonio, TX, 782030.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24939PRVMatthew Cruz1944-06-17UHC-91463-5421342252937979 Pine Dr, Eden Prairie, MN, 553740.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29407PRVKelly I Gutierrez1990-10-16UHC-76846-4189079175056693 Maple Ave, Las Vegas, NV, 891230.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28963PRVEdwerd Hicks1989-04-06UHC-50339-1765454843633192 Mesa Dr, Columbus, OH, 432090.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25554PRVBrittany Hill2008-08-16—48395805709432 Elm St, Orlando, FL, 328750.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22987PRVKeith Torres1955-12-22——8102 Main St, Houston, TX, 770180.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25482PRVSara Sanders1984-10-03—38231787322217 Grand Ave, Austin, TX, 787010.76Name re-casedTwo-digit birth yearPhone reformattedState code upper-cased+2 more
PRV-21933PRVRachel R Rivera1971-02-24UHC-18995-25—5236 Oak St, Charlotte, NC, 282720.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-24342PRVJohn K Lynch1985-12-18UHC-71698-3646196067054927 Ocean Ave, Charlotte, NC, 282890.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20372PRVJoe Crawfford1977-07-08—72188657401032 Sunset Blvd, Denver, CO, 802180.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20358PRVRebecca Y Garza1976-06-04UHC-50074-12——0.76Middle initial moved out of first nameName re-casedDate of birth reformattedMember ID reformatted+2 more
PRV-24365PRVLogan Lawson1941-11-21UHC-25158-4160887743933174 Lincoln Way, Jacksonville, FL, 322040.76Phone reformattedMember ID reformattedCity re-casedGender normalised+2 more
PRV-24950PRVLisa I Yang1963-12-18—27225671616761 Oak St, Scottsdale, AZ, 852290.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-25609PRVKyle Bryant1976-09-16UHC-45658-5558243599883140 Ocean Ave, Nashville, TN, 372810.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23078PRVScot M Marquez2003-11-17UHC-37992-3148241895352286 Ocean Ave, Gilbert, AZ, 852510.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20400PRVSara Y Bryant2008-07-23UHC-95119-0389075369792128 Maple Ave, Jacksonville, FL, 322110.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21155PRVJeremy Richards1990-07-11UHC-44276-5854125523749885 Union St, Atlanta, GA, 303940.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-29121PRVElliott Alexis1965-02-04—90087452889576 Cedar Ln, Atlanta, GA, 303440.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26732PRVBrenda W Simmons1969-10-10UHC-69449-6096045810122504 Hillcrest Rd, San Diego, CA, 921810.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27546PRVBilly N Phillips1952-12-19UHC-39529-3478173483931219 Desert Sky Blvd, Charlotte, NC, 282220.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28904PRVValentina T Guerrero1977-09-18UHC-71193-0256866688567765 Grand Ave, Columbus, OH, 432320.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27651PRVEthan Sancehz1971-12-04—56232799041217 Oak St, San Antonio, TX, 782520.76Phone reformattedState code upper-casedEmail lower-casedGender normalised+2 more
PRV-27548PRVSharon Hicks1955-02-11—70974455546437 Spring St, Scottsdale, AZ, 852800.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21910PRVCarlos L Gordon1983-04-28UHC-62783-1657451552635917 Maple Ave, Plano, TX, 750400.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26475PRVJennifer Jensn2001-10-28UHC-53962-932922800161512 Main St, Houston, TX, 770300.76Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-26376PRVShirley Yang1953-08-08UHC-48664-667602056421699 Baseline Rd, Atlanta, GA, 303950.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-20058PRVCarl Mendez1990-10-19UHC-48311-1397425885265168 Palm Dr, Seattle, WA, 981990.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28967PRVJulie Miller1955-10-16—392572789852 Harbor Blvd, Atlanta, GA, 303850.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22932PRVGary U Rodriguez1952-11-10UHC-65603-1266674426021707 Mesa Dr, Chandler, AZ, 852880.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28571PRVAshley Walllace1961-07-08—84780643592406 Church St, Tucson, AZ, 857720.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21922PRVKatherine Stevens1952-12-20UHC-93932-2642887553757115 Apache Blvd, Jacksonville, FL, 322550.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-28302PRVJerry Perkins1988-01-07UHC-63351-4380975552629878 Desert Sky Blvd, Atlanta, GA, 303800.76Name re-casedPhone reformattedSSN last four extractedCity re-cased+2 more
PRV-25079PRVValentina Wood1989-02-20UHC-77504-308498752268464 Oak St, Gilbert, AZ, 852970.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 98 of 192PreviousNext