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-23221PRVJean U Thomas1942-09-05——2362 Mesa Dr, Tempe, AZ, 852090.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25072PRVAlan Jensen1978-10-09—84961788012617 Oak St, Seattle, WA, 981710.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-29323PRVVictoria Singh1941-04-18UHC-82237-0848741656973955 Grand Ave, Chandler, AZ, 852550.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-24276PRVRob Duncan1956-10-18UHC-28650-7987334973407875 Jefferson Ave, Las Vegas, NV, 891480.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
PRV-23722PRVBobby Powell1965-12-22UHC-79003-106014179192—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21532PRVKathryn Garcia1978-03-16—6423004905—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21136PRVSaumel Estrada1976-06-12—21281895821665 Palm Dr, Dallas, TX, 752660.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26469PRVMaria Wells2005-07-01—53185863252693 Highland Ave # 966, Eden Prairie, MN, 553640.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-27405PRVDenise Yang1961-03-26—35742913321201 River Rd, Tucson, AZ, 857320.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-20983PRVBarbara Webb1981-06-13—74943205326837 Pine Dr, Tucson, AZ0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-27040PRVMason V Rios1980-07-07UHC-58394-4570524572598660 Central Ave, Houston, TX, 770950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20360PRVSantiago P Anderson1990-09-27UHC-31051-13301625501921 Main St, Glendale, AZ, 853660.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
PRV-24297PRVEmily Alvarado1961-09-28UHC-66506-48—7977 River Rd, Glendale, AZ, 853280.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28711PRVFrances Lawson1986-07-22—70981383354507 Sage Ct, Gilbert, AZ, 852450.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23849PRVWalter F Bowmna1954-11-01—5174906631—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26708PRVArthur W Rios1972-11-23—43034023358018 Elm St, Glendale, AZ, 853350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20208PRVAlice K Crawford1953-10-20UHC-75258-478197445112—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23707PRVCharlotte Washington2007-01-27UHC-47321-13—7562 Union St, Seattle, WA, 981720.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
PRV-20670PRVGregory McCoy1942-05-15—51827909678994 Lake View Rd, Nashville, TN, 372930.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24265PRVJudith Howell1993-05-02UHC-20985-0355447839675164 Park Pl, Houston, TX, 770810.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24500PRVBetty Brooks2002-03-14——8012 Baseline Rd, Denver, CO0.80Name re-casedCity re-casedZIP missingPlaceholder values cleared
PRV-22502PRVMaria Wang1976-04-07UHC-01269-47—6033 Mesa Dr, Phoenix, AZ, 850040.80Name split from “Last, First”Member ID reformattedEmail lower-casedPlaceholder values cleared
PRV-20092PRVCharyl Howard1946-08-24UHC-29543-4743183661545314 Apache Blvd, Las Vegas, NV, 891760.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25304PRVDorothy E Griffin2006-12-03UHC-72937-0827584753943762 Market St, Glendale, AZ, 853210.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-20220PRVLori E Meyer1959-11-17—36237583669738 Canyon Rd, Charlotte, NC, 282820.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29441PRVAndrea Evans2002-01-12——6496 Spring St, Sacramento, CA, 958470.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28423PRVJrodan Sullivan2001-02-14—6698503292—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25577PRVHelen Green1982-02-24UHC-73031-4640254576133097 Maple Ave, Seattle, WA, 981860.80Name re-casedMember ID reformattedState name converted to codePlaceholder values cleared
PRV-26769PRVBetty Gardner—UHC-30425-6728230985237139 Lake View Rd, Fresno, CA, 937630.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
PRV-27813PRVEthan Y Foster1941-08-06——7698 Lincoln Way, Minneapolis, MN, 554260.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-28579PRVMaria Diaz1983-06-20——5160 Valley View Dr, San Antonio, TX, 782080.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22684PRVKyle Ross1970-08-03—2449000918—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23235PRVAllan G Hoffman1983-06-23UHC-11329-1264965406883527 Bayshore Dr, Fresno, CA, 937780.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29042PRVKatherine Ellis1945-08-02—34283657351385 Jefferson Ave, Eden Prairie, MN, 553220.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-25004PRVAdam Jimenez1978-02-17——263 Lincoln Way, Orlando, FL0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-23171PRVBryan Reinolds1958-08-23UHC-54408-0628456974111616 Desert Sky Blvd, Glendale, AZ, 853760.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22578PRVNathan W Bennett——9715566125—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-27334PRVLucia Butler1979-05-26UHC-92207-77—6114 Grand Ave, Miami, FL, 331340.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29439PRVSamantha Williamson1992-05-21—7719194035—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26753PRVDanielle Kelly1968-01-28UHC-36263-5572340068683468 Washington St, Phoenix, AZ, 850850.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27747PRVDorothy Smiht2003-10-07UHC-01581-36—624 Central Ave, Gilbert, AZ0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-24603PRVJesse Torres—UHC-40675-7721044662606930 Lincoln Way, Atlanta, GA, 303770.80Date of birth missingPhone reformattedCity re-casedPlaceholder values cleared
PRV-22552PRVStephen Munoz1971-04-11—58385561764303 Maple Ave, Scottsdale, AZ, 852800.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27091PRVMarcus Thomas1959-04-28UHC-45703-1973845512603707 Ocean Ave, Houston, TX, 770430.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-26696PRVEdward Duncan1961-06-25UHC-59797-84—619 Market St, Denver, CO, 802800.80Name re-casedMember ID reformattedZIP+4 trimmedPlaceholder values cleared
PRV-24986PRVNoah Morgan1976-03-20UHC-82203-05—5058 Palm Dr, Nashville, TN, 372740.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20332PRVGloria Q Stone1954-03-28UHC-49958-85—7547 Broadway, Seattle, WA0.80Date of birth reformattedAddress re-casedZIP missingPlaceholder values cleared
PRV-22906PRVPaul Marshall1965-08-08UHC-73694-4189565868198380 Ocean Ave, Tampa, FL, 336270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20344PRVThomas V West1961-12-16UHC-63916-2854761781075325 Hillcrest Rd Apt 15, Dallas, TX, 752110.80Unit split from streetCity re-casedEmail lower-casedPlaceholder values cleared
PRV-23941PRVGloria Bukre1918-11-07—39334393678287 Valley View Dr, Tucson, AZ, 857280.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 127 of 192PreviousNext