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
ENR-119768ENRChris Fuller1947-05-27UHC-77707-7191285203577758 River Rd, Eden Prairie, MN0.52Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more
TPA-58860TPACarl Murphy1955-08-03—59934232433504 Harbor Blvd, Tucson, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412961CLMRuth Payne1977-11-16UHC-75266-66—6794 Church St, Jacksonville, FL, 322900.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-133734ENRRuth E Wheeler2007-03-13UHC-38169-9562762200624468 Cedar Ln, Minneapolis, MN, 554290.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20022PRVJoyce A Contreras1966-07-03UHC-09400-7262245470082980 Park Pl, Mesa, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-128175ENRStephen V Rss2000-09-10UHC-97438-2032782051471885 Grand Ave, Jacksonville, FL, 322900.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120917ENRMei S Luna1959-07-22UHC-88565-3337033879826214 Pine Dr, Dallas, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63609TPAChristian Andersson1939-07-09——2042 Washington St, Orlando, FL, 328180.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-109188ENRHeather P Wagner1991-12-14UHC-68131-4744734708164720 Canyon Rd, Miami, FL, 331740.52Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-107122ENRHannah G Garrett1993-01-09UHC-32176-426057650156478 Sunset Blvd, Minneapolis, MN, 554930.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-100253ENRChristopher Stevens1949-06-27UHC-34040-2674677428321811 Lincoln Way, Las Vegas, NV, 891180.52Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-125637ENRNoah C Elliott1946-12-04UHC-45140-0432375194351201 Harbor Blvd, Columbus, OH, 432330.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25779PRVRaymond Sullivan1989-08-22—48742313135591 Sage Ct # 134, Chandler, AZ, 852010.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415301CLMAmy Lawrence—UHC-73297-66—2012 Mountain View Dr, Denver, CO, 802470.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51087TPABryan Carpenter1953-01-10——3793 Harbor Blvd, Los Angeles, CA, 900750.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419672CLMWilliam Singh1953-02-25UHC-07485-7266383477772604 Meadow Ln # 378, Dallas, TX, 752220.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407097CLMGerald Y Wagner1982-02-05UHC-37501-46—9744 River Rd, Charlotte, NC, 282690.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29099PRVJoe Vargas1973-02-28UHC-09497-5577451754594634 Lake View Rd, Dallas, TX0.52Phone reformattedSSN last four extractedCity re-casedZIP missing+2 more
ENR-123126ENRGerald B Dixon1986-01-13UHC-04299-8834231227402943 Central Ave, Las Vegas, NV, 891580.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-423132CLMCynthia King1981-07-10UHC-15784-433084654069386 Mesa Dr, Fresno, CA, 937540.52Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
TPA-63932TPAZachary Scott1949-12-24—60678269868108 Canyon Rd, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126397ENRAbigail F Adams—UHC-47242-4165881681719028 Spring St # 617, Glendale, AZ, 853700.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-21059PRVAmber G Nichols1993-03-03UHC-10935-8646250934601003 Sage Ct, Scottsdale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-416180CLMThomas Lawrence———5476 Mountain View Dr # 876, Charlotte, NC, 282760.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
ENR-138100ENRMason F Porter1965-02-15UHC-54272-6390978079636442 Apache Blvd # 590, San Diego, CA, 921480.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-128811ENRKatherine U Medina1965-01-25UHC-13206-3881526492636551 Central Ave, Los Angeles, CA, 900510.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-115793ENRMaria Z Hoffman2004-02-01UHC-06277-6541728522977344 Apache Blvd, Gilbert, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-122272ENRRalph Q Montgomery1992-12-15UHC-35654-5545257318154474 Sage Ct, Mesa, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61589TPANicholas Arnold1982-05-18——6306 Indian School Rd, Gilbert, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-400668CLMAshley Jones1969-09-11UHC-95558-79—1608 Desert Sky Blvd, Tucson, AZ, 857440.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-59450TPAJesse Cunningham——81370649957036 Grand Ave, Tampa, FL0.52Name re-casedDate of birth unreadablePhone reformattedState name converted to code+2 more
CLM-430817CLMDiego Montgomery1950-06-08UHC-56570-2394291183112865 Main St, Columbus, OH, 432110.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410486CLMCarrolyn Price2005-12-07—63029916988651 Ridge Rd, Atlanta, GA, 303910.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-113404ENRJulia Torres1983-06-06UHC-43531-7140722932354613 Apache Blvd Apt 12, Eden Prairie, MN, 553200.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-107095ENRJudith H Cooper1957-01-28UHC-10497-1896655603176211 Palm Dr, Eden Prairie, MN, 553310.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132330ENRShirley S Munooz1962-10-06UHC-28956-1053589224639750 Sage Ct, Fresno, CA, 937950.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115367ENRHeather M Rodriguez1960-12-16UHC-35708-4856885035375155 Highland Ave, Fresno, CA, 937180.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-28169PRVEric Bell—UHC-32632-4032463459777210 Mountain View Dr Apt 39, Miami, FL, 331910.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-110580ENRCheryl Daniels1966-01-28UHC-21002-42—1820 Jefferson Ave, Phoenix, AZ, 850910.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-27022PRVJustin Ryan1975-11-04—21538262281898 Camelback Rd, Plano, TX0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421447CLMDylan Lewis1941-12-03UHC-60307-39—5083 Elm St Apt 37, Scottsdale, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-119525ENRJudy Y Taylor1981-09-10UHC-53339-8480060549953763 Meadow Ln, San Antonio, TX, 782450.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110299ENRAbigal Murphy1975-04-26UHC-18664-9860349928736723 Willow Ct, Austin, TX0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-59566TPABrian Walsh1938-10-27—50989603758446 Central Ave, Eden Prairie, MN, 553650.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-59565TPABrian Walsh1938-10-27—50989603758446 Central Ave, Eden Prairie, MN, 553650.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-135745ENREdward N Ellis1979-04-10UHC-04613-7738968907984385 Broadway, Mesa, AZ, 852880.52Name split from “Last, First”Phone reformattedSSN last four extractedAddress re-cased+2 more
TPA-62028TPALawrence Fuller2000-12-09——6647 Church St, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-428418CLMDiana V Ellis1985-05-03—39433155762713 Maple Ave Apt 25, Phoenix, AZ, 850470.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-129018ENRKeith P Jordan—UHC-51305-3051198036612390 Ridge Rd, Mesa, AZ, 852640.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-128964ENRMegan Park1948-12-04UHC-97248-7256428372943187 Maple Ave, Seattle, WA, 981840.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 143 of 2,000PreviousNext