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-27045PRVBetty C Rose1945-03-03UHC-74182-2360035624758135 Central Ave, Columbus, OH, 432100.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23652PRVJustin Rodriguez1981-01-25—20347683635750 Desert Sky Blvd, Dallas, TX, 752860.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26075PRVSamantha I Torres1954-08-20UHC-71644-84—5874 Sunset Blvd, Austin, TX, 787170.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29281PRVDenise Robertson1947-09-05UHC-42523-9280687449046834 Market St, Tucson, AZ, 857630.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24833PRVLuis B Simmons2003-04-13UHC-91105-479167153948—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23136PRVAnn Rios2003-07-20——6732 Valley View Dr, Eden Prairie, MN, 553310.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29448PRVBenjamin Walker1995-12-12UHC-70830-9958791808164431 Union St, Jacksonville, FL, 322540.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29543PRVCatherine L Bennett1980-01-12UHC-58898-702587124462939 Ocean Ave, Austin, TX, 787900.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26011PRVPaul Rilye1973-02-14—2275951424—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22980PRVKelley Samuel1960-10-20UHC-79157-5757669721793674 Meadow Ln, Tempe, AZ, 852090.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21385PRVAlbert Griffin1953-03-15—93781800442971 Canyon Rd, Minneapolis, MN, 554980.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23452PRVMegna S Herrera1991-02-23——4453 Indian School Rd, Denver, CO, 802280.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28829PRVJoe Rojas1982-01-06—85142025827841 Sage Ct, Phoenix, AZ, 850470.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25631PRVKathy C Salazar1961-02-05UHC-01997-4345299543359016 Ocean Ave, Fresno, CA, 937330.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29039PRVJessica Alvarez1905-03-27UHC-19484-62—976 Sunset Blvd, Gilbert, AZ, 852180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28958PRVEdward A Hunt1999-06-24UHC-76455-829463364219—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26745PRVKyle V Butler1991-11-28UHC-96998-4250795322661483 Canyon Rd, Charlotte, NC, 282680.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24117PRVRaymond Banks1966-04-28——3219 Grand Ave, Eden Prairie, MN, 553440.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25500PRVRyna L Hernandez1959-01-19—5727094583—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24680PRVLisa Y Gray2004-05-26UHC-96835-0359254441491231 Hillcrest Rd, Chandler, AZ, 852120.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-26369PRVPeter Furd1991-10-23——9835 Pine Dr, Dallas, TX, 752630.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28213PRVJesse Q Chapman1968-06-27—62252448402417 Willow Ct, Denver, CO, 802270.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21191PRVMarcus Little2001-03-28UHC-92454-6387258415899687 Ridge Rd, Gilbert, AZ, 852660.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-20630PRVLuis Sullivan1943-02-09UHC-42957-5828263402992265 Maple Ave, Los Angeles, CA, 900100.80Two-digit birth yearCity re-casedEmail lower-casedWhitespace trimmed
PRV-27839PRVTheresa Rios2008-07-20UHC-59751-66—3083 Sage Ct, Houston, TX, 770630.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-23929PRVRichard R Boyd2001-08-07UHC-29020-2891369606931939 Willow Ct, Austin, TX, 787420.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24499PRVSean Meyer1949-11-03—4655735390158 Mesa Dr, Tucson, AZ, 857810.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26567PRVJuan Medina1967-05-10UHC-12396-7339845146141799 Bayshore Dr, Los Angeles, CA, 900750.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21760PRVRyan Le1979-11-28—22458584869613 Broadway, Seattle, WA, 981000.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25715PRVAnn Kennedy1955-04-17UHC-55225-29—5760 Cedar Ln, Chandler, AZ, 852610.80Name re-casedEmail lower-casedGender normalisedPlaceholder values cleared
PRV-27083PRVTimothy O Griffin1977-11-03UHC-74484-3164430164843387 Hillcrest Rd, Austin, TX, 787610.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-21531PRVCamila T Snyder1993-06-09——3515 Willow Ct, Miami, FL, 331920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20827PRVDennis Gutierrez1984-04-08UHC-41524-3995263272839635 Mountain View Dr, Seattle, WA, 981320.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23369PRVGrace Guzman1982-12-19UHC-39682-1775664318553690 Central Ave Apt 11, San Diego, CA, 921920.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-22382PRVDiana X Richards2006-11-08—55774827273735 Cedar Ln, Mesa, AZ, 852960.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21494PRVEmma O Red1991-06-07——161 Desert Sky Blvd, Charlotte, NC, 282940.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-28427PRVVirginia Bowman1957-09-20—31876698815826 Hillcrest Rd, Atlanta, GA, 303460.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23766PRVGabriel Perry1957-04-25UHC-42198-2064863386212064 Baseline Rd, Denver, CO, 802970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26803PRVKeith Dominguez1941-02-08UHC-93982-603457970629—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26024PRVJeffrey K Carter1957-01-25UHC-22659-6768954929694976 Church St, Mesa, AZ, 852470.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-22760PRVGerge Lawson1998-11-03UHC-33442-55—4710 Palm Dr, Mesa, AZ, 852930.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27421PRVCatherine V Day1943-07-04UHC-08875-72—5538 Grand Ave, Plano, TX, 750470.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28453PRVJoan T Coleman2002-05-25—55142461196592 Willow Ct Apt 32, Tampa, FL, 336360.80Name re-casedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-25310PRVJonathan Wang1997-08-12—65898900695706 Indian School Rd, Jacksonville, FL, 322380.80Date of birth reformattedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-20779PRVRobert I Hicks1987-12-14UHC-88936-3975250243309867 Park Pl, Houston, TX0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-28644PRVHarold Barnes1995-04-05UHC-11839-778725208417683 Hillcrest Rd, Jacksonville, FL, 322990.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21805PRVJean A Kelly2007-01-26——1655 Cedar Ln, Chandler, AZ, 852710.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28880PRVSofia Bowman1964-11-20UHC-32544-49—3843 Baseline Rd, Scottsdale, AZ, 852290.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26906PRVScott Duncan1997-10-26UHC-47476-2852537361204543 Indian School Rd, Gilbert, AZ, 852610.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22613PRVCarlos Jenkins1959-08-07——1581 Valley View Dr, Chandler, AZ, 852910.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
9,596 rows, page 142 of 192PreviousNext