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-51296TPAJuan Reyes1941-04-23——7663 Forest Ave, Dallas, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-128987ENRJordan C Mitchell1995-11-27UHC-28654-5331356807679584 Valley View Dr # 135, Scottsdale, AZ, 852240.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430802CLMMarilyn Castillo1980-01-24——7402 Highland Ave Apt 29, Chandler, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-139905ENRCatherine J George1998-04-25UHC-90701-5765321999485642 Church St Apt 28, Austin, TX0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-402729CLMAna I Coleman1941-03-12——4247 Grand Ave, Los Angeles, CA, 900030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-123761ENRDonna Q Marquez1942-02-24UHC-23095-7839488793796518 Cedar Ln, Miami, FL, 331630.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404642CLMBilly Tucker1987-12-20UHC-60679-1455087718516369 Indian School Rd, Tampa, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20656PRVStephanie Harvey1990-03-05UHC-11287-5275831845206362 Union St, Eden Prairie, MN, 553380.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-27640PRVChristine Fernandez1973-04-23—94933797929101 Washington St, Atlanta, GA, 303810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108818ENRMaria Robinson1962-12-03UHC-39058-942829200240717 Grand Ave, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more
TPA-58181TPAAshley Thompsson1999-11-22——8765 Central Ave, Eden Prairie, MN, 553200.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-23881PRVBrandon Rojas1940-05-16UHC-05735-9733531940715141 Union St # 419, Seattle, WA, 981270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23882PRVBrandon Rojas1940-05-16UHC-05735-9733531940715141 Union St # 419, Seattle, WA, 981270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-135296ENRJessica Y Mejia2002-10-23UHC-87470-4868467846597277 Meadow Ln Apt 37, Los Angeles, CA0.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62471TPAKenneth Medina1967-10-03UHC-58954-978256422353817 Hillcrest Rd, Houston, TX, 770900.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-129963ENRAngela D Carlson1968-09-22UHC-78453-7279556423394333 Church St # 900, Seattle, WA, 981340.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-117404ENRKeren Morrison2000-06-28UHC-23765-4747641167755196 Cedar Ln, Miami, FL, 331410.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-419288CLMMadison Knight1984-02-05UHC-85507-79—8677 Baseline Rd Apt 18, Atlanta, GA, 303190.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102122ENRLori E Carlson1945-09-28UHC-83409-0686138045192001 Elm St, Scottsdale, AZ, 852700.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-135110ENRDebra A Andrews1971-11-10UHC-51903-2184891191829658 River Rd, Dallas, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-418497CLMIsabella P McDonald1967-08-02UHC-60298-7248162624457667 Pine Dr Apt 20, Columbus, OH, 432470.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414141CLMRay Banks1966-04-28UHC-72994-01—3219 Grand Ave, Eden Prairie, MN, 553440.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110822ENRTony L Torres1940-10-14UHC-59591-7684531675356430 Palm Dr, Sacramento, CA, 958120.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53497TPAJeremy Daniels1961-02-21UHC-81515-12—6850 Sage Ct, Las Vegas, NV0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-142281ENRJustin Ortiz1979-01-21UHC-85757-1524079564896818 Ridge Rd, Charlotte, NC, 282090.50Name split from “Last, First”Two-digit birth yearMember ID reformattedEmail lower-cased+3 more
CLM-420839CLMRaymond X Muunoz1976-05-13UHC-91631-69—8454 Apache Blvd, Scottsdale, AZ, 852480.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429692CLMAshely O Ryan1981-05-26—23598435995777 Grand Ave, Fresno, CA, 937800.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
TPA-60597TPAChristopher Willis1980-03-14—7679142678788 Willow Ct, Las Vegas, NV, 891530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-412958CLMDylan Ross1942-02-11——8779 Forest Ave, Orlando, FL, 328690.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60447TPABrenda Munoz1979-05-11—39989853806309 Park Pl, San Antonio, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421448CLMEmma L Carroll1984-04-25UHC-47807-89—8499 Indian School Rd, Fresno, CA, 937350.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409956CLMKayla Flores1951-06-13UHC-94241-41—1387 Main St, Mesa, AZ0.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-117347ENRAnn X Fields1946-01-03UHC-32591-8128028245565259 Valley View Dr Apt 22, Tempe, AZ, 852410.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125215ENRAngela E Murray2004-11-25UHC-17948-28942247295753 Elm St, Nashville, TN, 372150.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417090CLMWilson Maison1993-07-06UHC-64072-59—1284 Mesa Dr, Jacksonville, FL0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-100995ENRShirley Q Wiliamson1962-04-25UHC-89515-8394663800484586 Church St, Tampa, FL, 336190.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121280ENRThomas E Harvey1977-10-25UHC-55914-0296722936946330 Cedar Ln, Plano, TX, 750960.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-112772ENRRalph T Mitchell1990-02-21UHC-17638-1460952537633670 Spring St, Minneapolis, MN, 554020.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
TPA-61057TPARogers Ruszell1989-10-26—42276112202184 Grand Ave # 413, Nashville, TN, 372480.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-28992PRVTimothy Carter1941-02-01UHC-21773-289864805461405 Sage Ct, Sacramento, CA, 958030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-27376PRVTeresa Rivera1967-12-18—61337458609292 Forest Ave, Fresno, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106670ENRSarah E Park1964-06-27UHC-57297-3222485384381654 Church St, Atlanta, GA, 303430.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-139046ENRKathryn I Wallace1991-04-10UHC-49905-7561033106508278 Canyon Rd # 197, Jacksonville, FL, 322710.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-405923CLMRios Harold———6491 Highland Ave Apt 38, Jacksonville, FL, 322620.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-428170CLMKevin Matthews1965-08-15—66160382376609 Mesa Dr, Houston, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
TPA-53404TPARonald Moore1995-01-08——2050 Palm Dr, Fresno, CA, 937990.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-136587ENRKyle L Weber1987-08-09UHC-48005-0396836459389279 Forest Ave, San Diego, CA, 921820.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413684CLMJanice Robinson—UHC-21270-0370038794755220 River Rd, Columbus, OH, 432440.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-431916CLMAmy H Pena1939-08-28UHC-89660-2638434608639258 Hillcrest Rd # 611, Houston, TX, 770400.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50427TPAAnn Campbell2008-12-18——223 Indian School Rd, Denver, CO, 802500.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 115 of 2,000PreviousNext