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
CLM-420724CLMKathryn Kelley1941-03-05UHC-23952-71—5269 Washington St Apt 6, Nashville, TN, 372650.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429937CLMNoah Franklin1960-09-27UHC-74947-71—1629 Grand Ave, Denver, CO, 802490.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-118158ENRAmber R Delgado2007-09-14UHC-82226-0388281465824846 Market St # 531, Chandler, AZ, 852410.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56851TPAMaria Ryos—UHC-61386-4442969158389019 Cedar Ln, Sacramento, CA, 958030.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125561ENR—Junk1969-12-14UHC-90454-5042171335686083 Sage Ct, Glendale, AZ, 853200.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-100625ENRJason Rios1953-06-27UHC-49359-3639343905355658 Pine Dr # 434, Jacksonville, FL, 322630.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
PRV-24795PRVArjnJunk1986-04-21UHC-50680-8379782688162780 Spring St, Los Angeles, CA, 900630.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134744ENRKathleen M Miller1944-10-03UHC-61179-1564669733316044 Sage Ct Apt 14, Sacramento, CA, 958340.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405044CLMKathleen Stewart1938-10-13——317 Mountain View Dr, Charlotte, NC, 282400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117793ENRAhmed Hayees1995-10-01UHC-59600-2524077238461557 Baseline Rd, Fresno, CA, 937020.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123129ENRBarbara Roberts1972-10-05UHC-93612-27—9857 Oak St Apt 25, Denver, CO, 802150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115741ENRSophia S Vasquez1947-12-15UHC-21463-60—5478 Canyon Rd Apt 20, Tucson, AZ, 857610.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142067ENRTimothy Nguyne1947-08-09UHC-94509-4839138940044564 Park Pl Apt 28, Charlotte, NC, 282130.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115556ENRAndrew Fernandez1948-06-26UHC-04193-0196850997169020 Valley View Dr, Seattle, WA, 981690.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23712PRVHarold Fernandez1981-07-02UHC-45011-9882222501906390 Lake View Rd Apt 24, Sacramento, CA, 958080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-132696ENRKelly F Burton1980-10-12UHC-06398-61—9072 Park Pl, Dallas, TX, 752170.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-408360CLMAna Q Allen1938-05-27UHC-40301-04—8410 Desert Sky Blvd, Denver, CO, 802520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408361CLMAna Q Allen1938-05-27UHC-40301-04—8410 Desert Sky Blvd, Denver, CO, 802520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109749ENRPatricia J Kelly1949-02-05UHC-46633-4182541829933338 Ocean Ave, Sacramento, CA, 958040.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423982CLMJerry Dominguez—UHC-34607-2793197801058695 Indian School Rd, Austin, TX, 787840.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112218ENRStephanie Nelson—UHC-79058-71—3566 Canyon Rd, Las Vegas, NV, 891910.50Name re-casedDate of birth reformattedDate of birth unreadablePhone missing area code+3 more
ENR-100753ENRFrances R Wilson—UHC-38544-9735558133649472 Willow Ct, Mesa, AZ0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124105ENRCamila R Mendoza1965-10-05UHC-35550-9488976573847918 Oak St, Seattle, WA, 981460.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-432684CLMPeter Wang1989-06-01UHC-50056-3224033554095320 Lake View Rd Apt 12, Columbus, OH, 432730.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103188ENRMary Allen1974-10-02UHC-94733-1694360776684111 Grand Ave # 837, Eden Prairie, MN, 553680.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137061ENRHenry N Peters1977-01-18UHC-77157-4620567918129756 Desert Sky Blvd, Eden Prairie, MN, 553870.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426258CLMAshley Watson1960-12-22——4523 Maple Ave, Phoenix, AZ, 850640.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-102713ENRIsabella CJunk2002-03-04UHC-51969-6059532781605677 Sunset Blvd Apt 38, Los Angeles, CA, 900820.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25428PRVTeressa Yang2006-01-17——3126 Bayshore Dr, Nashville, TN, 372420.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
PRV-22927PRVJulie H Sims1980-02-25UHC-52677-23—4819 Valley View Dr, San Antonio, TX, 782200.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21759PRVScott Santos1961-01-22—44926520669274 Maple Ave, Chandler, AZ, 852870.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26166PRVSofia Riley1998-07-26—38886408926118 Central Ave, Fresno, CA0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-123733ENRJess Morris1978-02-12UHC-05205-9474794095659584 Apache Blvd, Charlotte, NC, 282330.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58950TPACynthia Silva1957-06-20——434 Highland Ave, Nashville, TN, 372330.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-103585ENRAngela O Li1983-11-13UHC-73845-118304998351210 Cedar Ln Apt 9, Denver, CO, 802940.50Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-424445CLMCharles Reynolds1961-09-26—29755746306382 Apache Blvd, Orlando, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428815CLMBetty Stephens2006-12-15UHC-08557-9188691394456241 Lincoln Way Apt 40, Eden Prairie, MN, 553450.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54363TPACharlotte Gordon1983-07-13——4034 Mountain View Dr Apt 36, Orlando, FL, 328790.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-417835CLMHannah Z Porter1991-06-15UHC-63800-6435646122165730 Palm Dr, Miami, FL, 331990.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426264CLMCamila Green1991-08-15UHC-53157-96—8860 Willow Ct, Phoenix, AZ, 850670.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-28027PRVBrian Adams1954-04-02—78574307254847 Ridge Rd, Minneapolis, MN, 554700.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136032ENRMatthew H Burns1976-12-19UHC-41296-6394582617636941 Pine Dr # 520, Tucson, AZ, 857530.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedUnit split from street+3 more
ENR-110624ENRKimberly K Murphy—UHC-02279-397844893230973 Canyon Rd, Glendale, AZ, 853000.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56401TPAJesse H Collins1987-04-01——7476 Grand Ave # 511, Columbus, OH, 432120.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422305CLMKayla Walsh1967-03-10—68577113588522 Lake View Rd, Tucson, AZ, 857050.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135416ENRSamantha Z Burke2000-08-27UHC-94001-9478227547638709 Lincoln Way # 146, Minneapolis, MN, 554040.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-405934CLMThomas W Schmidt1960-08-05—4057942500968 Canyon Rd, Fresno, CA, 937420.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25523PRVNatalie L Ramos1987-04-27——926 Spring St, Tempe, AZ, 852560.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25815PRVEugene Warren1965-03-23UHC-16651-2057399045444103 Bayshore Dr Apt 24, Gilbert, AZ, 852770.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-118782ENRAmy Castro1983-12-12UHC-26944-4625425227094080 Canyon Rd, Mesa, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 119 of 2,000PreviousNext