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-135840ENRKaren T Lopez—UHC-99332-0768880451704053 Grand Ave, Orlando, FL, 328500.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408406CLMMarilyn N Meyer1969-04-26—43388749147037 Forest Ave, Fresno, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-130644ENRBetty Gonzalez1961-05-12UHC-67685-4476631610148432 Canyon Rd, Plano, TX, 750270.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-104441ENRKevin J Cunningham2002-07-11UHC-11004-7683285557217149 Park Pl, Los Angeles, CA, 900830.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-50922TPAAshley Turner1982-08-20UHC-15343-73—7867 Elm St, Atlanta, GA, 303900.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-129050ENRCamila Jenkins1941-05-25UHC-40064-2171828867147015 Palm Dr, Los Angeles, CA, 900210.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119075ENRAmanda Perkins1943-02-19UHC-49827-3776334851865497 Forest Ave, Phoenix, AZ, 850090.54Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-125050ENREdward T Park1938-02-05UHC-91172-7175778599807334 Oak St, Seattle, WA, 981400.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61426TPAJuhn Dean1983-06-25——2971 Broadway, Fresno, CA, 937000.54Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+1 more
CLM-428872CLMWalter Carlson1955-10-26UHC-39159-1942954065492773 Mountain View Dr, Phoenix, AZ, 850670.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-108137ENRDinae A Garrett2001-11-06—48896633724719 Bayshore Dr, Gilbert, AZ, 852280.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138366ENRBrian Medina1968-10-16UHC-58175-2126342801532973 Highland Ave, Miami, FL, 331780.54Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
ENR-118339ENRDonna Ortega—UHC-71161-8635688857647419 Church St, Glendale, AZ0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-418083CLMLaura Banks1969-10-15——5289 Lake View Rd Apt 14, Scottsdale, AZ, 852730.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421813CLMCamila Lawrence1967-10-12——6983 Grand Ave Apt 8, Sacramento, CA0.54Unit split from streetState code upper-casedZIP missingGender normalised+1 more
ENR-105131ENRElijah P Pena1997-09-16UHC-72695-92—5445 Canyon Rd, Sacramento, CA, 958850.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-27488PRVSean Perkins1943-10-17——2758 Harbor Blvd, Mesa, AZ, 852420.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-135543ENRKyle Taylor1943-03-04UHC-59965-33—8402 Grand Ave, Eden Prairie, MN, 553890.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117885ENRGregory Sullivan1947-01-05UHC-86749-5634425452657934 Cedar Ln, Mesa, AZ0.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401673CLMGrace Valdez2002-08-14UHC-35478-16—2005 Elm St # 888, Jacksonville, FL, 322980.54Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+1 more
CLM-406231CLMVictoria Z Schmidt1988-06-12UHC-00189-2453776272444939 Church St, Gilbert, AZ, 852760.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-425234CLMDavid Nguyen1992-12-28——7691 Washington St # 884, Jacksonville, FL, 322880.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-130505ENRLauren Porter1962-08-04UHC-47113-19—1731 Harbor Blvd, Orlando, FL, 328920.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-140297ENRKathleen Z Fisher1953-08-12UHC-98423-3297562695555400 Sunset Blvd Apt 8, Nashville, TN, 372190.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-111977ENRKenneth X Carroll—UHC-91935-8527766743975265 Maple Ave, Dallas, TX, 752980.54Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+1 more
ENR-100068ENRHamilton Wayne1947-06-25UHC-36182-0260658913374635 Forest Ave, Tucson, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-62754TPAStephen Schmidt1939-11-16——8679 Grand Ave # 319, Tampa, FL, 336680.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-408850CLMMarriana Mason1965-12-17UHC-25369-28—7478 Mountain View Dr, Jacksonville, FL, 322700.54Name split from “Last, First”ZIP+4 trimmedGender normalisedPlan code upper-cased+1 more
CLM-406588CLMTyler Young1981-07-21UHC-00161-11—7471 Ocean Ave, Tampa, FL, 336570.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-424593CLMPaul D Estrada—UHC-63153-8195868793665930 Ridge Rd, Seattle, WA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-112686ENRJon Ortiz1970-05-23UHC-59920-83—4816 Park Pl, Minneapolis, MN, 554700.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-414370CLMDiane Weaver1964-05-12UHC-06730-84—2791 Maple Ave Apt 21, Atlanta, GA, 303190.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-124950ENRPeter E Harris1953-02-27UHC-36327-95—6807 Hillcrest Rd # 322, Eden Prairie, MN, 553080.54Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-128334ENRVictoria Q Barnes2003-11-26UHC-54618-1030198011471900 Ocean Ave, Charlotte, NC, 282510.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133438ENREvelyn Nelson—UHC-74997-91—9742 Park Pl, Tempe, AZ, 852420.54Date of birth missingSSN last four extractedCity re-casedZIP+4 trimmed+1 more
PRV-21427PRVCarlos Lawrence1949-08-04UHC-29118-10—9012 Mesa Dr Apt 16, Plano, TX, 750350.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407065CLMBrenda Wells1997-08-04——3625 Willow Ct # 221, Scottsdale, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-138589ENRDouglas X Lewis1967-09-08UHC-76690-56—560 Spring St # 509, Dallas, TX, 752540.54Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-118550ENRAna A Willis1954-03-06UHC-64569-46—7807 Apache Blvd, Chandler, AZ, 852100.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-116311ENRPamela West—UHC-98149-66—2946 Sage Ct, Austin, TX, 787940.54Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-100152ENRMariana A Turnr1997-07-23UHC-20164-1234371197109224 Sage Ct, Nashville, TN, 372640.54Phone reformattedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
PRV-23799PRVFrank A Howard1971-07-01UHC-33748-5125466838035872 Jefferson Ave, Nashville, TN, 372530.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-100420ENRRobert B Harris1983-10-27UHC-42531-3487836306187190 Main St, Charlotte, NC, 282900.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-407191CLMKevin Peters———2466 Broadway, Columbus, OH, 432970.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
ENR-127145ENRBrenda M Mroeno1976-06-16UHC-64839-494346432900512 Grand Ave, Tempe, AZ, 852020.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
PRV-27962PRVMargaret Foster—UHC-01099-35—9550 Highland Ave, Phoenix, AZ0.54Date of birth missingState name converted to codeZIP missingWhitespace trimmed+1 more
ENR-140789ENRPeter H Banks1991-12-21UHC-77412-58—7123 Ridge Rd # 814, Orlando, FL, 328920.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-413524CLMJoan Jimenze1986-03-18UHC-70453-27—6493 Washington St, Minneapolis, MN, 554150.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-110475ENRWillie Q Robertson1995-12-22UHC-50774-3381078443027551 Bayshore Dr, Phoenix, AZ, 850260.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-110476ENRWillie Q Robertson1995-12-22UHC-50774-3381078443027551 Bayshore Dr, Phoenix, AZ, 850260.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 209 of 2,000PreviousNext