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-26731PRVJesse Cunningham1993-09-09UHC-75159-1735439746859591 Palm Dr, Tempe, AZ, 852110.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-25520PRVDouglas Day1946-08-13—55539472483209 Washington St, Orlando, FL, 328140.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-23496PRVValentina U Wagner1950-07-17—62065439206600 Harbor Blvd, Sacramento, CA, 958440.80Name re-casedPhone reformattedGender normalisedWhitespace trimmed
PRV-28617PRVJonathan Burton2006-09-23UHC-87120-2097166703844473 Mesa Dr, Dallas, TX, 752380.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26355PRVAlexander Rivera1958-07-12UHC-52912-995126817146298 Washington St, Phoenix, AZ, 850870.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23172PRVNatalie Banks1989-04-09UHC-97535-4964645221477508 Jefferson Ave, Seattle, WA, 981770.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28314PRVJordan George1960-06-18UHC-08759-6089761601466040 Bayshore Dr, Scottsdale, AZ, 852680.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24377PRVKathryn Gonzalez1988-08-13—60199827294472 Main St, Minneapolis, MN, 554830.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-27452PRVTheresa W Rios1950-03-14UHC-98479-4149636872259833 Park Pl, Tempe, AZ, 852590.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23579PRVHenry Gomez1957-07-16UHC-44840-4651659323018724 Bayshore Dr, Scottsdale, AZ, 852110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24349PRVBruce Hansen1995-04-06UHC-49101-8372937164053759 Willow Ct, Austin, TX, 787350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28491PRVBarbara Weber1948-01-25UHC-24739-9934990604154863 Ocean Ave, Eden Prairie, MN, 553360.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-27769PRVChristian J Jenkins1986-08-22—93378365225840 Broadway, Mesa, AZ0.80Phone reformattedAddress re-casedZIP missingPlaceholder values cleared
PRV-25090PRVEugene Parker1988-06-25—75757222352035 Ocean Ave, Minneapolis, MN, 554130.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25799PRVBilly S Perry2005-09-14—6616504482—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21560PRVRyan Waarren1946-08-13UHC-88581-01—243 Sunset Blvd, Nashville, TN, 372590.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28263PRVSam Warren2003-06-02——4561 Pine Dr, Mesa, AZ, 852460.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26574PRVJustin M Knight1985-10-27UHC-39714-96—2762 Forest Ave, Seattle, WA, 981020.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20149PRVWilliam M Ferguson1965-09-19—481211040029 Market St, Austin, TX, 787740.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20708PRVElizabeth Hudson2001-12-09UHC-04542-1357686335604988 Highland Ave, Austin, TX, 787030.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20899PRVAustin Hughes—UHC-81540-494454953335138 Meadow Ln, Eden Prairie, MN, 553080.80Date of birth unreadableMember ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-26363PRVDiana Vazquez1993-07-23UHC-02734-7047089136575173 River Rd, Jacksonville, FL0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-26076PRVJanet Mendoza1998-11-26——5780 Mountain View Dr, San Diego, CA, 921010.80Date of birth reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-22399PRVSofia Porter2002-07-04UHC-53417-6823043499101396 Apache Blvd, Austin, TX, 787080.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27808PRVDeborah S Burns1980-01-12UHC-63347-7322024245052696 Willow Ct, Fresno, CA, 937270.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25047PRVAmy V Espinoza1996-03-02—63855860273957 Sage Ct # 741, Dallas, TX, 752330.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-26315PRVNicholas F Dunn1959-08-22—97744430615990 Pine Dr, Mesa, AZ, 852420.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26750PRVBruce Wells1977-11-17——7373 Pine Dr, Charlotte, NC, 282330.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27610PRVDunna Reed1985-11-09—44756244589147 Park Pl, Jacksonville, FL, 322420.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23730PRVBarbara Boyd1966-09-24UHC-51193-3163361463389280 Valley View Dr, Las Vegas, NV, 891180.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23729PRVBarbara Boyd1966-09-24UHC-51193-3163361463389280 Valley View Dr, Las Vegas, NV, 891180.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27002PRVWalker D Fatima1977-09-21UHC-22421-47—1113 Mesa Dr, Mesa, AZ, 852660.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-20447PRVEmiyl Yuong1987-09-27—62438680785517 Lincoln Way, Seattle, WA, 981820.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26180PRVDoris W Santiago1986-07-04UHC-85136-9775888168086004 Forest Ave, Tucson, AZ, 857710.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-25794PRVVictoria Howard1961-09-20UHC-87606-6458881070999758 Oak St, San Diego, CA, 921420.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-21461PRVJoyce Q Gibson1984-04-10—83674888132946 Ocean Ave, Las Vegas, NV0.80Date of birth reformattedPhone reformattedZIP missingPlaceholder values cleared
PRV-20261PRVMorrison Donald1970-11-26UHC-52599-4182657907356285 Park Pl, Denver, CO0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
PRV-28624PRVCamila O Franklin1979-11-17UHC-02351-8641948712525533 Main St, San Diego, CA, 921220.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26972PRVLucia Smith1983-10-17UHC-73102-4885066461257359 Washington St, Nashville, TN, 372070.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-24484PRVJerry Armstrong1940-04-10—96722009786898 Mountain View Dr, Phoenix, AZ, 850580.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21054PRVJennifer U Perez1948-07-18UHC-64712-0835961881779158 Highland Ave, Mesa, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-27451PRVGloria Clark1976-08-27—7976787660—0.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-23752PRVDylan Ross1942-02-11—5644987844—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24454PRVWei A Car1977-01-10—2125299826174 Mesa Dr, Jacksonville, FL, 322690.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23351PRVRoger J Chavez1990-11-09UHC-74003-193275114423148 Jefferson Ave, Los Angeles, CA, 900770.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-27498PRVElisabeth Weaver1985-07-09UHC-21629-88—2357 Ocean Ave, San Antonio, TX, 782390.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-24066PRVHarold I Allen1982-05-24UHC-32188-32—4801 Mountain View Dr, Atlanta, GA, 303500.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-21130PRVMartha Hall1974-09-23—80471576911786 Grand Ave, Orlando, FL, 328480.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28255PRVLogan Larson1945-04-19———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-27521PRVFatima O Smith1941-12-12—75193015971716 Spring St, Charlotte, NC, 282670.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 126 of 192PreviousNext