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-20345PRVGabriel Brooks2003-06-07—4819315738682 Pine Dr, Phoenix, AZ, 850510.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25945PRVDorothy Weaver1941-10-26—3279370475916 Jefferson Ave, Seattle, WA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20546PRVHiroshi Reynolds1965-06-21—39352960252054 Sunset Blvd, Sacramento, CA, 958970.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-23011PRVJerry Woods1995-08-03UHC-83700-12—2742 Oak St, Minneapolis, MN, 554060.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
PRV-25533PRVSamuel Graham1999-05-06UHC-97254-5167879843502511 Valley View Dr, Phoenix, AZ, 850450.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26522PRVJames E Williams1985-08-22UHC-59391-5394688501241733 Canyon Rd, Minneapolis, MN, 554310.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-20142PRVSamuel X Allen1943-02-16—20878142637372 Washington St, Minneapolis, MN, 554380.66Two-digit birth yearPhone reformattedEmail lower-casedGender normalised+1 more
PRV-29415PRVAlexis T Nunez——29298321659582 Grand Ave, Denver, CO, 802100.66Name split from “Last, First”Date of birth missingPhone reformattedWhitespace trimmed+1 more
PRV-24582PRVJacqueline L Parker1994-11-17UHC-11243-9594652185344759 Mesa Dr, Mesa, AZ, 852540.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-20439PRVBenjamin BJunk1978-11-02—74142890561764 Mountain View Dr, Las Vegas, NV, 891900.66Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
PRV-25974PRVChristine Jimenez—UHC-90658-1147727974657936 Mountain View Dr, Eden Prairie, MN, 553240.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27418PRVStepphanie Rios1979-05-15——3417 Forest Ave, Nashville, TN, 372070.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
PRV-20982PRVRoy Miller2006-01-17——7067 Church St Apt 40, Sacramento, CA, 958410.66Date of birth reformattedPhone missing area codeUnit split from streetWhitespace trimmed+1 more
PRV-23179PRVMarcus C Reed1954-10-05—68236390219817 Oak St, Chandler, AZ, 852970.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26193PRVOmar Z Rios1997-02-17UHC-74123-5268439940577637 Union St, Phoenix, AZ, 850330.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26739PRVSharon T Sims——8278218280—0.66Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-23445PRVJanet E Ryan1951-06-25——1077 Sage Ct, Minneapolis, MN, 554350.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26689PRVJoan Castro1993-08-20—4054368361—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-28129PRVJuditth Brown1949-05-01UHC-78195-6924245878844374 Pine Dr, Fresno, CA, 937040.66Two-digit birth yearPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-27643PRVBrittany Wang1994-11-14UHC-81918-66—3355 River Rd, Miami, FL, 331850.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-27382PRVHiroshi Webb1978-05-02UHC-42260-1962248223358151 Church St, Denver, CO, 802960.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23944PRVJustin Y Gilbert1979-10-17—47832030405876 Indian School Rd, Mesa, AZ, 852320.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27910PRVTheresa Washington1957-04-11UHC-57051-33—3875 Washington St, Scottsdale, AZ, 852650.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26314PRVNicholas F Dunn1959-08-22UHC-05520-2697744430615990 Pine Dr # 277, Mesa, AZ, 852420.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24031PRVGrace I Ramos1991-08-09UHC-74116-697933245860683 Hillcrest Rd, Charlotte, NC, 282310.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29305PRVEvelyn U Guzman1990-07-11—32432298445792 Bayshore Dr, Seattle, WA, 981780.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27071PRVDavid Weber1980-04-08——7188 Jefferson Ave, Denver, CO, 802110.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-24078PRVElijah K Hudson1967-07-17——4748 Apache Blvd, Nashville, TN, 372260.66Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-24149PRVJuan Gutierrez1975-02-27—70991346894751 Washington St, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-20744PRVJoshua Lane2008-08-05—70749108193732 Maple Ave, Sacramento, CA, 958990.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-21534PRVLogan Williams1942-05-11—92335159019681 Jefferson Ave, Fresno, CA, 937230.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24657PRVKathryn Ortega2002-07-27UHC-85581-7998289909691848 Main St, Atlanta, GA, 303070.66Name re-casedTwo-digit birth yearSSN last four extractedWhitespace trimmed+1 more
PRV-28888PRVCheryl Maldonado1999-06-02UHC-31630-48—2734 Hillcrest Rd, Jacksonville, FL, 322160.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
PRV-20628PRVMary Hansen1961-11-20—9885051853263 Lincoln Way # 695, Orlando, FL, 328840.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
PRV-24635PRVAaron Vazquez2003-11-22UHC-00207-3088061658405948 Apache Blvd, Gilbert, AZ, 852520.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26300PRVDonald M Palmer1991-01-10——1789 Valley View Dr, Sacramento, CA, 958570.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-24725PRVChuck Brooks—UHC-36973-2573826060174048 River Rd # 874, Orlando, FL, 328740.66Date of birth unreadablePhone reformattedUnit split from streetWhitespace trimmed+1 more
PRV-20490PRVGloria Cahpman1945-07-20UHC-02870-2363431530939217 Elm St, Phoenix, AZ0.66Name split from “Last, First”City re-casedZIP missingWhitespace trimmed+1 more
PRV-20448PRVBecky Jacobs1993-02-24—96684869007259 Highland Ave, Jacksonville, FL, 322370.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-26459PRVKayla Rice1997-11-11——3442 Church St, Gilbert, AZ, 852720.66Name re-casedPhone missing area codeCity re-casedState name converted to code+1 more
PRV-21775PRVBradley G Carroll1968-11-05UHC-64547-1276465026402490 Market St, Glendale, AZ, 853830.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-24098PRVJason Cooper1955-08-08UHC-89789-0344670806077903 Main St # 205, Phoenix, AZ, 850270.66Unit split from streetCity re-casedGender normalisedWhitespace trimmed+1 more
PRV-20466PRVDouglas Hill1942-09-02UHC-33322-2553243089427413 Hillcrest Rd, Denver, CO, 802150.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
PRV-20465PRVDouglas Hill1942-09-02UHC-33322-2553243089427413 Hillcrest Rd, Denver, CO, 802150.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
PRV-27333PRVAaron Alexander——49431291116261 Highland Ave, Denver, CO0.66Date of birth unreadablePhone reformattedZIP missingWhitespace trimmed+1 more
PRV-26320PRVKeith Schultz1940-01-23UHC-59799-8483696871853791 Sunset Blvd, Seattle, WA, 981270.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25761PRVYuki Valdez1943-08-07UHC-47279-523586907058—0.66Two-digit birth yearPhone reformattedMember ID reformattedGender normalised+1 more
PRV-27851PRVLawrence Wallace1975-10-13—8466865142—0.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
PRV-23361PRVAmy Woods1998-06-08UHC-57366-8923288966485269 Canyon Rd, Plano, TX, 750130.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-28970PRVEdward Boyd2003-11-09—71733383748783 Willow Ct, San Diego, CA, 921230.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
9,596 rows, page 66 of 192PreviousNext