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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-61688TPAEvelyn Palmer1997-04-03—60923909248011 Church St Apt 11, Tucson, AZ, 857580.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-107361ENRWilliam Bradley1964-03-20UHC-33492-59—9247 Jefferson Ave, Glendale, AZ, 853490.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113893ENRAnthony Q Cox—UHC-21551-4535130312238525 Willow Ct, Glendale, AZ0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-60464TPADennis Alvarez1979-08-21—95877397723110 Desert Sky Blvd, Plano, TX, 750630.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-416989CLMDouglas Howell1959-05-10UHC-59326-05—275 Apache Blvd # 389, Minneapolis, MN, 554170.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
PRV-23213PRVSarah Carlson———1651 Sunset Blvd, Las Vegas, NV0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404870CLMKyle Cruz1970-07-28UHC-67404-3374273260304360 Broadway # 696, Glendale, AZ0.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-127791ENRSarah C Murphy1964-06-03UHC-01157-3054735490167273 Palm Dr, Scottsdale, AZ, 852370.50Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
CLM-432478CLMWillie Bennett1968-01-25UHC-41101-83—1924 Highland Ave Apt 2, Columbus, OH0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424769CLMSophia Cole1979-10-03——5607 Ridge Rd Apt 7, Austin, TX, 787110.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117697ENRMarilyn E Long1948-06-28UHC-02319-9951651120724006 Broadway, Eden Prairie, MN, 553740.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
ENR-117698ENRMarilyn E Long1948-06-28UHC-02319-9951651120724006 Broadway, Eden Prairie, MN, 553740.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
CLM-406019CLMKayla L Bell1982-09-18——6689 Canyon Rd Apt 6, Dallas, TX, 752490.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-20112PRVDiego Payne1962-04-18—75780671669440 Mountain View Dr, Scottsdale, AZ, 852130.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
ENR-102938ENRDan R Brooks1984-10-20UHC-42328-9061465925575113 Cedar Ln, Phoenix, AZ, 850090.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-21778PRVGeorge Fernandez1959-03-23—81899604155931 Union St, Columbus, OH0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51215TPAEugene Espinoza1945-12-11—75929237124711 Mountain View Dr, Houston, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53451TPACarol Cruz2005-10-21——4813 Washington St, Houston, TX, 770650.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-404230CLMDiana Reid2000-01-25——548 Central Ave, Houston, TX, 770060.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430569CLMKelly Miller1970-07-10UHC-14354-7458848518344486 Palm Dr, Gilbert, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431084CLMGoerge Jones2006-12-09UHC-24975-70—3287 Lincoln Way Apt 28, Atlanta, GA, 303330.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53110TPAEmma Tucker1955-10-18—35961167664116 Market St, Mesa, AZ, 852450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103405ENRAaron Munoz1943-12-09UHC-15982-6673374867424673 Palm Dr # 119, Glendale, AZ0.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
TPA-52805TPAWei Mejia1960-05-08——7400 Apache Blvd Apt 19, Los Angeles, CA, 900350.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-124505ENRJohn T Ramos1994-07-07UHC-05969-1320862788143869 Baseline Rd, Fresno, CA, 937120.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116910ENRJudy Y Ward1976-07-26UHC-72375-159225331442398 Main St, Atlanta, GA, 303200.50Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-58013TPALori Z Willis2008-09-22—25737818701029 Pine Dr, Columbus, OH, 432490.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123354ENRWayne T Garza1990-11-24UHC-17167-67—7840 Forest Ave # 508, Jacksonville, FL, 322950.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22701PRVJustin Fuller1981-05-06UHC-95343-2420232978424564 Camelback Rd, Phoenix, AZ, 850290.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-429659CLMBetty P Peters1971-02-24—25238203696038 Market St, Scottsdale, AZ, 852290.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-50558TPAFank Y Park1940-10-09—64327029249254 Cedar Ln, Sacramento, CA, 958860.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109075ENRDorothy S Nunez1975-01-16UHC-27583-3275033961605049 Spring St Apt 28, Minneapolis, MN0.50Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
ENR-109076ENRDorothy S Nunez1975-01-16UHC-27583-3275033961605049 Spring St Apt 28, Minneapolis, MN0.50Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
TPA-60007TPASantiago Carolyn——33350907153514 Indian School Rd, Atlanta, GA, 303550.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404397CLMSamantha Castillo1972-09-18UHC-23757-474294026965398 Meadow Ln Apt 27, Atlanta, GA, 303020.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-141688ENRAnna F Guzman1968-06-28UHC-10311-6778333351048017 Washington St, Scottsdale, AZ, 852520.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
PRV-25292PRVKimberly R Ortega——64940699367148 Sage Ct, Jacksonville, FL0.50Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-26346PRVBobby Q Barnes——25054284937012 Lake View Rd, Jacksonville, FL0.50Name re-casedDate of birth missingPhone reformattedCity re-cased+3 more
ENR-140462ENRMartha Z Ruiz1948-04-01UHC-79278-0947291985275670 Main St, Eden Prairie, MN, 553720.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-125951ENRMarilyn James1969-10-05UHC-34608-5343041650704451 Forest Ave Apt 23, Scottsdale, AZ, 852650.50Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+3 more
CLM-404282CLMAisha Fowler1946-04-20——1357 Cedar Ln, Nashville, TN, 372040.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28260PRVKevin D Matthews1965-08-15——6609 Mesa Dr, Houston, TX, 770740.50Name re-casedPhone missing area codeState name converted to codeEmail lower-cased+3 more
TPA-58845TPAJacqueline Evns1967-02-19——9777 Elm St, Tucson, AZ, 857060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125025ENRAisha Stone—UHC-36349-477474481889905 Main St, Houston, TX, 770550.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134655ENRDennis N Patterson1969-03-28UHC-31263-3095351981923295 Market St, Eden Prairie, MN, 553740.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424149CLMAngela Wuods1978-01-03——6025 Oak St, Minneapolis, MN, 554070.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-413442CLMLuis Hunter1997-11-24UHC-49762-132293013474189 Ocean Ave # 953, Plano, TX, 750220.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421710CLMSophia Ray——7377922231707 Valley View Dr, Austin, TX, 787370.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429485CLMSteve King1969-01-20—21997798715493 Meadow Ln, Los Angeles, CA, 900190.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-115748ENRDavid R Bishop1973-10-26UHC-19805-3294762028631186 Harbor Blvd, Seattle, WA, 981170.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
100,000 rows, page 85 of 2,000PreviousNext