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-20153PRVEvelyn Rodriguez1946-12-04UHC-93535-65—44 Palm Dr, Austin, TX, 787670.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25269PRVMason Rose1948-06-12UHC-72109-4965395906951468 Central Ave, Phoenix, AZ, 850210.78Date of birth reformattedPhone reformattedCity re-casedState name converted to code+1 more
PRV-22677PRVJoe Freeman2007-11-17—77946985303030 Park Pl, Charlotte, NC, 282480.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25810PRVAnna Fowler2001-05-23UHC-90627-10—4001 Harbor Blvd, Nashville, TN, 372450.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25846PRVJesse Pena1982-07-12——9522 Oak St, Las Vegas, NV, 891710.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26028PRVSean Young2007-07-27UHC-50316-40—3421 Indian School Rd, Phoenix, AZ, 850600.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23252PRVKayla Olson1988-07-18UHC-13448-6875593139851392 Grand Ave, Dallas, TX, 752970.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28374PRVCharles Kngiht1979-09-19——6096 Maple Ave, Tempe, AZ, 852590.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27095PRVGrace Armstrong1986-04-08UHC-94830-935378844765795 Broadway, San Antonio, TX0.78Name re-casedDate of birth reformattedAddress re-casedZIP missing+1 more
PRV-21035PRVQJunk1949-10-19—4463092832729 Broadway, Plano, TX, 750700.78Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared+1 more
PRV-20321PRVSharon Mejia1995-04-14UHC-94173-8231992937361111 Camelback Rd, Phoenix, AZ, 850810.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27028PRVAissha Brooks1951-06-13—25632470343747 Canyon Rd # 880, Jacksonville, FL, 322600.78Phone reformattedUnit split from streetState code upper-casedWhitespace trimmed+1 more
PRV-28308PRVSantiago Warren1989-01-17UHC-28156-5458855873235906 Pine Dr, Glendale, AZ, 853050.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
PRV-26358PRVGeorge X Robinson1999-01-11UHC-33174-4095891385364700 Highland Ave, Miami, FL, 331600.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29158PRVJack N Jordan1968-12-26UHC-46514-8581236203547965 Washington St, Houston, TX, 770070.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25616PRVJoseph Carpenter1942-01-28UHC-79380-69—874 Main St, Tucson, AZ, 857130.78Date of birth reformattedMember ID reformattedGender normalisedWhitespace trimmed+1 more
PRV-28475PRVAshley O Walsh1961-10-13UHC-77677-08—7897 Palm Dr, Nashville, TN, 372760.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26292PRVJoyce Moreno1943-07-28——2582 Hillcrest Rd, Seattle, WA, 981520.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-26681PRVJacqueline Flores1974-06-19UHC-20775-7266768412678905 Washington St, San Diego, CA, 921730.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-23979PRVDouglas Welch1980-07-10UHC-34288-4372353756363626 Hillcrest Rd, Dallas, TX, 752500.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27726PRVWei James1987-05-16UHC-53568-2289280807517550 Sage Ct, Orlando, FL, 328220.78Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+1 more
PRV-22437PRVAaron Chapman1980-11-08UHC-51747-5781965673548489 Sunset Blvd, Orlando, FL, 328690.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-27763PRVSam Palmer2000-08-01UHC-81616-4765290750807508 Cedar Ln, Chandler, AZ, 852080.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22508PRVPriya Ray1985-09-26UHC-69452-315644196221727 Canyon Rd, Denver, CO, 802520.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29473PRVSophhia Burns1965-11-15——9399 Baseline Rd, Tempe, AZ, 852800.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28653PRVJaes L Mitchell1940-05-27UHC-22235-8446843600708842 Highland Ave, Sacramento, CA, 958950.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29555PRVThomas Harper1974-08-03UHC-43283-39—973 Market St, Tucson, AZ, 857660.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-27906PRVEthan Rogers1938-12-18UHC-76883-3286943895331672 Spring St, San Antonio, TX, 782510.78Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+1 more
PRV-26654PRVDiego T Richards1963-02-06—2263570196254 Grand Ave, Austin, TX, 787040.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-25827PRVNicole Woods1980-02-02UHC-75934-6989521146966428 Mesa Dr, Chandler, AZ, 852220.78Name re-casedTwo-digit birth yearState code upper-casedWhitespace trimmed+1 more
PRV-23488PRVHannah Sims1985-11-24—40830206759768 Sunset Blvd, Dallas, TX, 752560.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-21917PRVAlan Montgomery1979-04-12——8755 Jefferson Ave, Columbus, OH, 432870.78Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed+1 more
PRV-21036PRVBrenda Owens1949-10-19—4463092832729 Broadway, Plano, TX, 750700.78Name split from “Last, First”Phone reformattedAddress re-casedWhitespace trimmed+1 more
PRV-21946PRVIsabella Flores2000-06-04—74738842843163 Forest Ave, Plano, TX, 750000.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23616PRVHenry Nguyen1975-07-18—49256280113106 Palm Dr, Columbus, OH, 432720.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-27441PRVRoger Myers2003-10-14——4575 Cedar Ln, Charlotte, NC, 282810.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27259PRVDanielle Grahaam1985-10-18UHC-01900-593775011977—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-21640PRVBrenda Marquez1974-03-24—70799070625518 Grand Ave, Las Vegas, NV, 891720.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26808PRVRalph Washington1977-07-06—45089130083498 Meadow Ln, Plano, TX, 750770.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24705PRVBetty Hart1993-04-17UHC-32493-859158180225—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-20063PRVAlice Le2005-09-17—28685740504656 Hillcrest Rd, Glendale, AZ, 853820.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21590PRVNathan Obrien1939-09-27UHC-35857-3392051947859887 Apache Blvd, Tempe, AZ, 852000.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-27093PRVPatricia Gibson2002-06-06—38943899259178 Cedar Ln, Denver, CO0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
PRV-29499PRVJoe Martin2009-02-18UHC-97135-5395374487759024 Bayshore Dr, Minneapolis, MN, 554830.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21441PRVAaron Mendez2006-05-23UHC-95807-3239942845834835 Main St, Orlando, FL, 328670.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22051PRVDanielle F Knight1957-08-19—89936957538549 Jefferson Ave, Gilbert, AZ, 852200.78Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more
PRV-26537PRVRussell P Nunez1987-06-15—2273469995—0.78Two-digit birth yearPhone reformattedEmail lower-casedWhitespace trimmed+1 more
PRV-22058PRVJuan Burton1964-08-28UHC-41210-57—7543 Ridge Rd, Los Angeles, CA, 900050.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27069PRVKelly Fox1996-01-15—90121589144171 River Rd, Plano, TX, 750130.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21245PRVDavid Garza1938-04-06—64292181214042 Canyon Rd, Plano, TX, 750980.78Name re-casedDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more
9,596 rows, page 105 of 192PreviousNext