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-132441ENRJeremy V McDonald1940-06-12UHC-67446-94—5567 Willow Ct, Fresno, CA, 937290.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
TPA-57968TPACynthia Carroll2004-07-27——7925 Mountain View Dr Apt 10, Las Vegas, NV0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-138597ENRAustin Rogers1986-07-06UHC-96104-2364774304937743 Sage Ct, San Antonio, TX, 782730.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119904ENRJacob Banks1988-07-10UHC-77320-9045484884075849 Cedar Ln, Mesa, AZ, 852670.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-126893ENRBarbara N Murphy1959-07-01UHC-87414-3060993107603962 Mesa Dr Apt 6, Chandler, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-126892ENRBarbara N Murphy1959-07-01UHC-87414-3060993107603962 Mesa Dr Apt 6, Chandler, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-135038ENRTeresa D Cunningham—UHC-56407-995897165184981 Willow Ct, San Diego, CA, 921630.54Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+1 more
ENR-120842ENRRonald Cox1942-12-27—27525981196366 Spring St, Plano, TX, 750020.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57252TPAJanet U Dean———8717 Palm Dr # 330, Phoenix, AZ, 850370.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-406693CLMLauren Stevens—UHC-56668-5537732831812878 Canyon Rd, Phoenix, AZ0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-111578ENRBruce Fowler1938-05-08UHC-81149-56—7225 Lincoln Way, Columbus, OH, 432130.54Phone missing area codeState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
CLM-412063CLMBradley Armstrong1938-01-22——9526 Park Pl, Minneapolis, MN, 554290.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-131003ENRElijah Grant1940-05-21UHC-75378-87—587 Church St, Eden Prairie, MN, 553770.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-124995ENRDebra W Sinhg—UHC-05447-844967867869887 Harbor Blvd, San Antonio, TX0.54Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-116103ENRScott Wilson1954-03-26UHC-00397-8237857258929053 Lincoln Way Apt 28, Sacramento, CA, 958790.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-113992ENRWillie Gibson1994-04-23UHC-28593-6935125751553603 Harbor Blvd, Tampa, FL, 336950.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-141534ENREd Y Carter2004-12-18UHC-08519-8283442878645858 Lake View Rd # 256, Minneapolis, MN, 554860.54Date of birth reformattedUnit split from streetState name converted to codeGender normalised+1 more
TPA-55603TPANicole Weber2008-04-01——8660 Broadway, Glendale, AZ, 853540.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-112297ENRBrittany T Gardner1986-05-11—76988874521215 Cedar Ln, Plano, TX, 750580.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-109119ENRDouglas R Peterson1980-05-13UHC-56966-41—991 Mountain View Dr, Fresno, CA, 937930.54Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-429511CLMJula Lucas1981-07-20——504 Sunset Blvd, Minneapolis, MN, 554470.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-123091ENRArjun M Carr1967-04-15UHC-90273-7791777054401500 Desert Sky Blvd, Fresno, CA, 937670.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-415665CLMMei Hunt1946-12-20UHC-84600-88—7787 Baseline Rd Apt 20, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415666CLMMei Hunt1946-12-20UHC-84600-88—7787 Baseline Rd Apt 20, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-101141ENRJoan IJunk1949-03-16——573 Willow Ct, Plano, TX, 750010.54Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared+1 more
TPA-54545TPAFrank S Garrett1984-11-11——9229 Sunset Blvd, Tampa, FL, 336180.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-102147ENRNathan M Armstrong1942-02-06UHC-15778-11—5140 Highland Ave, Orlando, FL0.54Two-digit birth yearZIP missingGender normalisedWhitespace trimmed+1 more
ENR-110845ENRBarbara H Bishop1979-04-22UHC-14889-8395388478264698 Willow Ct # 585, Mesa, AZ, 852070.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-137685ENRLori P Simpson1941-10-25UHC-23112-1061657507091352 Cedar Ln Apt 7, Austin, TX, 787650.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-106456ENRLinda N Murray1957-10-15UHC-87160-2042366006589085 Washington St Apt 28, Mesa, AZ, 852500.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-109811ENRAbigail N Hicks2001-04-05UHC-46842-79—251 Hillcrest Rd, Seattle, WA, 981760.54Name split from “Last, First”Two-digit birth yearState name converted to codeEmail lower-cased+1 more
ENR-130751ENRRoy Ross1976-06-23UHC-03594-93—2156 Main St, Sacramento, CA, 958960.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
CLM-401049CLMChristina Singh1972-07-12UHC-36281-66—1049 Harbor Blvd, Tempe, AZ0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
CLM-401048CLMChristina Singh1972-07-12UHC-36281-66—1049 Harbor Blvd, Tempe, AZ0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
ENR-108006ENRAnn Anderson—UHC-38548-51—3585 Union St, Nashville, TN0.54Name re-casedDate of birth unreadableState name converted to codeZIP missing+1 more
CLM-424035CLMJohn Moreno1973-04-20UHC-62742-88—6704 Apache Blvd, Sacramento, CA, 958600.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-114815ENRDebbie P Schultz1954-10-18UHC-70429-412169276479944 Lake View Rd, Glendale, AZ, 853300.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-110633ENRKelly Evans1967-07-23UHC-44014-0532349039184597 Sunset Blvd, Houston, TX, 770930.54Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+1 more
ENR-131587ENRMark G Reyes1985-09-11UHC-44839-3662628322175171 Sage Ct Apt 18, Gilbert, AZ, 852040.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
PRV-27624PRVDonna Ellis1965-07-03UHC-56478-1737769342094083 Desert Sky Blvd, Jacksonville, FL, 322930.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-126190ENRMary X Williams1960-06-08UHC-91552-924679682584975 Mesa Dr, Denver, CO, 802540.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411492CLMGerald Marquez1943-05-27——7247 Valley View Dr, Tempe, AZ0.54Name re-casedTwo-digit birth yearZIP missingGender normalised+1 more
CLM-414217CLMHelen Graham1985-11-14—93081344177493 Park Pl, Miami, FL, 331370.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-102774ENRAhmed Gutierrez—UHC-99150-7423367218366178 Forest Ave, Columbus, OH, 432040.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404232CLMBillyJunk1956-08-02UHC-22233-15—9181 Mountain View Dr, Phoenix, AZ, 850540.54Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared+1 more
CLM-404707CLMYuki X Espinoza1951-06-16—2243679502387 Harbor Blvd, Charlotte, NC, 282060.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-136903ENRSteven Z Banks1996-02-04UHC-07451-5138943306543470 Bayshore Dr, Eden Prairie, MN, 553480.54Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
CLM-431186CLMEvelyn Herrera1951-07-16UHC-76171-21—5146 Baseline Rd, Jacksonville, FL0.54Two-digit birth yearCity re-casedZIP missingGender normalised+1 more
CLM-409273CLMJustin Morgan1956-06-21UHC-81951-04—4401 Desert Sky Blvd, Tempe, AZ, 852330.54Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+1 more
CLM-409272CLMJustin Morgan1956-06-21UHC-81951-04—4401 Desert Sky Blvd, Tempe, AZ, 852330.54Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+1 more
100,000 rows, page 197 of 2,000PreviousNext