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-26375PRVMark Bryant1993-06-04—6974213297190 Harbor Blvd, Glendale, AZ, 853100.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26245PRVAmy Bennett1970-10-21——8477 Pine Dr, San Antonio, TX, 782010.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
PRV-21369PRVJoshua Brown1993-10-09——509 Sunset Blvd, Tucson, AZ, 857510.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
PRV-25552PRVAustin Smith2006-09-13UHC-95971-84—8639 Lincoln Way, Jacksonville, FL, 322720.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25551PRVAustin Smith2006-09-13UHC-95971-84—8639 Lincoln Way, Jacksonville, FL, 322720.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24868PRVRaymond Lynch2004-11-18UHC-59681-4887892214901709 Union St, Austin, TX, 787510.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21213PRVAlexander Morrison1945-12-23—76289216897056 Cedar Ln, Chandler, AZ, 852000.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-26788PRVJulie Dixon1947-05-03UHC-54209-3287180508398661 Bayshore Dr, Gilbert, AZ, 852490.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22053PRVDebra Ortiz1998-11-25—24278733004384 Pine Dr, Tempe, AZ, 852400.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25784PRVGariel Z Ward1943-02-02—3307013173998 Pine Dr, San Antonio, TX, 782500.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25174PRVSantiago Romero1978-11-20—88297237932666 Forest Ave, Houston, TX, 770760.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-22466PRVAhmed Spencer1994-06-20UHC-74337-104925245904317 Park Pl, Mesa, AZ, 852440.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22465PRVAhmed Spencer1994-06-20UHC-74337-104925245904317 Park Pl, Mesa, AZ, 852440.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28838PRVCatheerine Riley1999-11-09UHC-20404-2452390398817227 Canyon Rd, Mesa, AZ, 852540.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23982PRVAndrea L Wilson2006-01-08UHC-84921-8052481817874292 Pine Dr, Tempe, AZ, 852820.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23890PRVKeith Z Gonzales1971-04-03UHC-47275-3923479258963073 Sage Ct, Scottsdale, AZ, 852030.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26519PRVMatthew Schmidt1990-04-09—7876960213—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
PRV-22200PRVChristopher X Adams1956-06-26—34332127904764 Spring St, Atlanta, GA, 303330.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20472PRVJoe W Olson1974-08-05UHC-29037-7095172276778587 Meadow Ln, Minneapolis, MN, 554800.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20471PRVJoe W Olson1974-08-05UHC-29037-7095172276778587 Meadow Ln, Minneapolis, MN, 554800.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29108PRVKevin L Hoffman2006-10-27—89280827003210 Park Pl, Miami, FL, 331880.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-26705PRVArthur V Lawson1980-01-04—2375944552—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-27238PRVBruce Munoz1993-08-13UHC-93815-584465388925—0.78Date of birth reformattedPhone reformattedSSN last four extractedWhitespace trimmed+1 more
PRV-26831PRVCharles Nelson1939-03-01UHC-63194-2291850575371880 Pine Dr, Eden Prairie, MN, 553940.78Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28447PRVWright Anthony1957-06-16UHC-70779-76—4821 River Rd, Scottsdale, AZ, 852310.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23358PRVAndrea Watkins1973-10-08UHC-03284-6663651245956651 Hillcrest Rd, Jacksonville, FL, 322680.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21021PRVAshley Vargas1998-11-05UHC-01359-3451336631666649 Valley View Dr, San Diego, CA, 921860.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21202PRVMelissa Thompson1976-02-10UHC-59296-894806760819—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-28826PRVAdam X Vega1974-12-27—53724674983130 Cedar Ln, San Diego, CA, 921810.80Name re-casedTwo-digit birth yearPlan code upper-casedPlaceholder values cleared
PRV-29273PRVYuki Williamson2000-03-19——4914 Sage Ct, Jacksonville, FL, 322700.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-25283PRVAshley S Bradley1956-04-18UHC-66935-9897992079896661 Apache Blvd, Las Vegas, NV0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-20636PRVAhmed Gutierrez1938-05-12UHC-99150-74—6178 Forest Ave, Columbus, OH, 432040.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21226PRVDaniel S Fuller1953-01-25UHC-71153-2488289323495148 Mesa Dr, Austin, TX, 787560.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23866PRVKenneth K Fowler1956-12-11—9044379449100 Canyon Rd, Dallas, TX, 752720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27535PRVCarol Stevens1965-12-10UHC-68436-17—8238 Indian School Rd, Eden Prairie, MN, 553430.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21305PRVDiana P Patterson2002-09-09—45264619968120 Maple Ave, Scottsdale, AZ, 852150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27955PRVJustin Nichols1978-08-23—28079378637207 Highland Ave, Plano, TX, 750830.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26707PRVValentina Coleman1965-02-18—26290163604830 Palm Dr, Eden Prairie, MN, 553770.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-29260PRVGloria N Hudson1976-06-26——603 Maple Ave, Tucson, AZ, 857890.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-22553PRVTimothy Yang1954-04-02—20481347365445 Forest Ave, Phoenix, AZ, 850930.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-21807PRVGloria Bennett1958-01-19—36137358718792 Grand Ave, Minneapolis, MN, 554190.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25058PRVMatthew Alexender1988-05-08UHC-16478-31—9294 Highland Ave, Miami, FL, 331380.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-21099PRVThomas Welch2004-12-10UHC-87160-1142844507827503 Broadway Apt 19, Plano, TX, 750500.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25467PRVBruce S Dunn1962-11-25UHC-09543-246733786713805 Grand Ave, Gilbert, AZ, 852350.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-29503PRVDoris McDnald1977-06-19UHC-00910-815318250759—0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-22658PRVBradley Belll1989-10-15—62736228578241 Meadow Ln, Jacksonville, FL, 322680.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26215PRVDavid C Ray2006-09-26UHC-63175-315379777346—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27925PRVCarol Berry1986-08-25UHC-30702-832459088555—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-27449PRVRoger Z Le1987-12-14—43463337739800 Cedar Ln, Austin, TX, 787390.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20639PRVAshley Turner1982-08-20UHC-15343-7358575978157867 Elm St, Atlanta, GA, 303900.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 124 of 192PreviousNext