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-26795PRVArthur Soto1963-03-10UHC-76728-295419202237487 Maple Ave # 383, Austin, TX, 787960.56Two-digit birth yearUnit split from streetGender normalisedPlaceholder values cleared
PRV-27214PRVElijah Payne1957-04-18——7432 Oak St Apt 11, Miami, FL, 331600.56Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased
PRV-24645PRVElijah Gordon1978-11-12—85693013562459 Bayshore Dr, Atlanta, GA, 303590.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-24451PRVPhilip Luna1999-12-08UHC-82234-7340163999013718 Camelback Rd, Minneapolis, MN, 554980.58Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
PRV-28864PRVJennifer M Webb2007-03-07UHC-32803-2834371450562087 Mesa Dr # 893, Fresno, CA, 937160.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-28364PRVNicole Nunez1991-08-12—48780634471464 Cedar Ln, Austin, TX, 787470.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20161PRVSantiago Bennett——48376904165393 Palm Dr, San Diego, CA, 921420.58Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
PRV-22429PRVJuila Estrada1999-12-16—84194284429472 Bayshore Dr, San Diego, CA, 921730.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-24549PRVBryttany Long1978-06-02—66574788206125 Forest Ave, Tempe, AZ, 852450.58Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-24901PRVYuki Chapman2002-02-19—72695766315584 Desert Sky Blvd, Minneapolis, MN, 554160.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-21311PRVJacob Simpson2000-01-24UHC-02926-18—4452 Maple Ave, Charlotte, NC, 282670.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-24852PRVTheresa Little1983-02-08UHC-38411-9831659280455346 Sunset Blvd, Denver, CO, 802830.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-21453PRVArthur Contreras1943-10-20UHC-78188-7133399483943294 Baseline Rd Apt 34, Jacksonville, FL, 322770.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-26045PRVLori Nichols1941-10-03—92896744868962 Union St, Gilbert, AZ, 852640.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-21150PRVCharlotte Soto1999-07-06—39652599778267 Pine Dr, San Diego, CA, 921290.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27010PRVSandra H Vasquez1938-09-12UHC-61566-5783147444735203 Church St, Dallas, TX0.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-27009PRVSandra H Vasquez1938-09-12UHC-61566-5783147444735203 Church St, Dallas, TX0.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-26392PRVLauren D Montgomery1963-12-10UHC-09615-9074283554492528 Desert Sky Blvd Apt 16, Minneapolis, MN, 554950.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-20522PRVJeremy T Harper1981-01-17—82147445005522 Baseline Rd, Los Angeles, CA, 900930.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20590PRVMei Estrada——98677509818211 Church St, Tempe, AZ, 852670.58Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
PRV-26729PRVAndrea Gomeez1987-10-27UHC-49598-7073458696319419 Sunset Blvd, Tucson, AZ, 857620.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27196PRVVictoria K Rice1998-09-15—66839002204405 Palm Dr, Glendale, AZ, 853550.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22063PRVAndrew Woods1973-11-16UHC-68285-699343582652872 Union St, Gilbert, AZ, 852500.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-28798PRVRoger Marquez1964-12-22UHC-62705-9130833780725303 Elm St, Minneapolis, MN, 554070.58Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23239PRVPeter I McCoy2000-04-02—87998848153108 Desert Sky Blvd, Columbus, OH, 432700.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22045PRVKevin Jacobs1973-08-14UHC-12897-5065656530259820 Harbor Blvd # 728, Jacksonville, FL, 322020.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-26239PRVBrittany M Sims2005-12-05—58596196038123 Harbor Blvd, Los Angeles, CA, 900680.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-29086PRVAndrew C Patel1981-05-13—92943934834615 Maple Ave, San Antonio, TX0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-25858PRVMariana Guzman1954-06-03—65774604693575 Hillcrest Rd # 161, Columbus, OH, 432660.58Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
PRV-22913PRVGerald K Fernandez1951-04-27UHC-60458-3851873943306759 Camelback Rd, Nashville, TN0.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-28671PRVKevin Patel1986-11-19—38035984826854 Park Pl, Seattle, WA, 981400.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-28396PRVJack Warren1966-02-10—84076979792998 Mountain View Dr, Dallas, TX, 752970.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26747PRVTerry Olson1945-01-20UHC-32163-313115130681423 Elm St, Los Angeles, CA, 900580.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26748PRVTerry Olson1945-01-20UHC-32163-313115130681423 Elm St, Los Angeles, CA, 900580.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-25459PRVJoseph Vargas1967-03-08—79690683938941 Baseline Rd, Tempe, AZ0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27435PRVJacob James1992-08-23UHC-95959-822063730657757 Spring St, Seattle, WA, 981990.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-22671PRVRobert Tran1978-03-12—48973669866155 Spring St, Plano, TX, 750080.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-23662PRVEthan Walsh1941-03-07—56223776605428 Mountain View Dr, Tampa, FL, 336330.58Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
PRV-29093PRVJean McCoy1963-12-09UHC-59244-395507371454343 Maple Ave, Tampa, FL, 336000.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-28471PRVCarlos Bryant1954-09-18—29199491506753 Hillcrest Rd, Tampa, FL, 336090.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-28084PRVMarcus N Hoffman1967-09-02UHC-57280-2126292073311328 Desert Sky Blvd, Tampa, FL0.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-22624PRVMartha Soto1957-12-05—50147086722000 Harbor Blvd, Austin, TX, 787000.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-21048PRVDiego George2000-06-14UHC-74759-5526750916064258 Sage Ct, Minneapolis, MN0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27165PRVDiane Dominguez1946-08-06—97898589849605 Union St, Sacramento, CA, 958620.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26545PRVSandra Z Alexander1950-04-13—77630193968420 Forest Ave, Fresno, CA, 937090.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-24798PRVThomas XJunk1964-08-10UHC-37217-3944559064855476 Mountain View Dr, Charlotte, NC, 282760.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-21124PRVAlbert Sanders1943-07-28—9309676412313 Canyon Rd, Las Vegas, NV0.58Name re-casedDate of birth reformattedPhone reformattedCity re-cased+5 more
PRV-28632PRVKelly Perkins2001-10-04—37544428546401 Washington St, Plano, TX, 750110.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20938PRVCarolyn T Woods1950-11-09UHC-37941-836155849864998 Mountain View Dr, San Antonio, TX, 782840.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
PRV-23532PRVJason Holems1944-04-09—39382874447300 Elm St # 132, Columbus, OH, 432900.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
9,596 rows, page 22 of 192PreviousNext