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-126773ENRMateo Thomas1952-06-21UHC-30713-2863380391105508 Mountain View Dr Apt 38, Austin, TX, 787630.38Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+3 more
CLM-410842CLMAnn Rios—UHC-55469-7490042133736732 Valley View Dr # 284, Eden Prairie, MN, 553310.38Name split from “Last, First”Date of birth unreadableMember ID reformattedUnit split from street+3 more
CLM-420814CLMLauren Johnson1955-02-23UHC-97366-6325496165958349 Harbor Blvd, Minneapolis, MN, 554400.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-410040CLMJason Mills1986-04-22UHC-72396-45—2460 Grand Ave # 759, Tampa, FL, 336390.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-141729ENRBetty Guerrero—UHC-76613-1635226304018596 Valley View Dr, San Antonio, TX, 782390.38Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405335CLMSofia Hart2007-01-01UHC-60364-393126488737346 Meadow Ln, Tampa, FL, 336550.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140400ENRMak K Banks1986-12-28UHC-06187-4228860497072326 Meadow Ln # 150, Chandler, AZ0.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125414ENRKenneth Wood1992-06-03UHC-29559-4574323569413547 Central Ave, Orlando, FL, 328020.38Two-digit birth yearPhone reformattedSSN last four extractedState code upper-cased+3 more
ENR-139926ENRDavid N Vazquez1991-07-20UHC-60007-8262436443865456 Washington St # 974, Seattle, WA, 981740.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419829CLMJudy Andrews1986-09-07UHC-49978-5835465829106785 Pine Dr, Sacramento, CA, 958450.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61904TPAKatherine Butler——79054446687504 Desert Sky Blvd, Houston, TX0.38Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
TPA-54774TPASofia Ryan1948-01-16——6638 Spring St, Tempe, AZ0.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-135005ENRAbigail G Young1992-02-27UHC-96753-2058873152569294 Indian School Rd Apt 16, Los Angeles, CA0.38Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-122698ENRJessica McDonald1974-08-19UHC-64226-3277791353435827 Union St, Tucson, AZ, 857720.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137782ENRDouglas C Stewart1987-03-07UHC-98736-6477341079764478 Cedar Ln Apt 31, Dallas, TX0.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60889TPAKayla Willis———6807 Highland Ave # 992, Scottsdale, AZ0.38Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58414TPASarah Luna1994-12-16——7313 Bayshore Dr, Sacramento, CA0.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-123714ENRKyle F Hill2005-12-22UHC-70211-7741376610124264 Market St, Charlotte, NC0.38Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-115518ENRRoger W Pena1996-06-25UHC-93843-322015980107207 Cedar Ln, Fresno, CA0.38Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-115519ENRRoger W Pena1996-06-25UHC-93843-322015980107207 Cedar Ln, Fresno, CA0.38Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-431102CLMAlexis Murray1990-12-15UHC-07375-77—5747 Camelback Rd, San Diego, CA, 921310.38Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-413916CLMDorothy Wods1942-01-03UHC-01218-9055628396035620 Indian School Rd, Houston, TX, 770690.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116804ENRJack Wells1996-07-24UHC-04105-5534128744883646 Sunset Blvd, Tempe, AZ, 852490.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419379CLMAlbert Ellis2001-08-08——860 Ocean Ave, Houston, TX, 770500.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-138775ENRChristopher P Larson1946-06-21UHC-69121-0159388200366328 Willow Ct Apt 40, Mesa, AZ0.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-424267CLMJack Barnes1940-07-25——5734 Washington St, Atlanta, GA, 303560.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-429997CLMDaniel U Russell—UHC-04417-79—6057 Apache Blvd, Sacramento, CA, 958420.38Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-121158ENRAlan Marquez2002-02-16UHC-88620-2937133652952304 Central Ave Apt 25, Fresno, CA, 937420.38Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102828ENRSantiago W Aguilar1946-01-13UHC-56097-85—7366 Sunset Blvd, Charlotte, NC, 282190.38Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedMember ID reformatted+3 more
ENR-136956ENRBruce C Porter1986-12-02UHC-09068-8190464166252128 Sunset Blvd, Las Vegas, NV, 891910.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412435CLMMaria McDonald———8439 Elm St, Houston, TX, 770440.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-55621TPAJose Perry1957-01-22——332 Ocean Ave, Miami, FL0.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117523ENRKelly N Clark1954-10-03UHC-47071-6448592740709516 Market St, Glendale, AZ, 853740.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-405215CLMDorothy A Gray1945-08-20UHC-28039-87—9607 Meadow Ln # 871, Las Vegas, NV, 891550.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129043ENRAmber E Coleman1974-01-06UHC-48834-19—6563 Valley View Dr Apt 28, Jacksonville, FL, 322550.38Middle initial moved out of first nameTwo-digit birth yearUnit split from streetCity re-cased+3 more
ENR-102191ENRAlexis Little1984-07-16UHC-97948-5970051918283461 Baseline Rd # 710, Chandler, AZ, 852600.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-29131PRVBruce T Garrett1962-07-12UHC-64079-01—383 Central Ave, Miami, FL, 331140.38Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-141892ENRMichelle K Cruz1975-05-02UHC-29430-75—6540 Harbor Blvd, Tampa, FL, 336910.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-50239TPAMara Chavez1999-10-15——3624 Union St Apt 29, Las Vegas, NV, 891050.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424718CLMPaul Gordon1954-05-19—68384721259470 Camelback Rd, Miami, FL, 331650.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61936TPAMarilyn Guerrero1997-05-12—93156634243267 Mesa Dr, Orlando, FL0.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29593PRVEugene V Daniels1994-02-05——9891 Oak St, Mesa, AZ, 852320.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-56768TPAJoan Garza1974-12-12——5331 Willow Ct Apt 17, Charlotte, NC, 282320.38Name split from “Last, First”Two-digit birth yearUnit split from streetCity re-cased+3 more
ENR-109433ENRGloria Rogers—UHC-45329-4743335014805350 Desert Sky Blvd Apt 29, Atlanta, GA0.38Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-109434ENRGloria Rogers—UHC-45329-4743335014805350 Desert Sky Blvd Apt 29, Atlanta, GA0.38Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60054TPADorothy C Price2007-01-05——1418 Sunset Blvd, San Diego, CA, 921530.38Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-140734ENRJoshua X Diaz1953-03-05UHC-25720-29—1005 Market St, Columbus, OH, 432760.38Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+3 more
CLM-409898CLMEthan Maldonado1948-10-25——6746 Central Ave, Glendale, AZ0.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23334PRVJulie Chen1981-10-26UHC-35660-9369663819286058 Church St # 437, Dallas, TX, 752590.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20095PRVKyle Mason2008-03-16——9092 Park Pl, Orlando, FL, 328880.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 23 of 2,000PreviousNext