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-52057TPARonald Broooks1990-04-28——7486 Union St, Glendale, AZ, 853820.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401779CLMAnn Reyes—UHC-80982-32—5760 Oak St # 231, Gilbert, AZ, 852810.52Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-130367ENRGrace Montgomery1984-02-21UHC-74716-175928770083592 Mountain View Dr, Fresno, CA, 937790.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428284CLMRichard Bailey—UHC-89724-56—735 Jefferson Ave, Miami, FL, 331000.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52306TPADylan Hill1962-01-21UHC-19089-37—5307 Valley View Dr, Charlotte, NC, 282510.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405065CLMSandra Adams1983-12-04UHC-23338-39—589 Pine Dr, Dallas, TX, 752900.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423669CLMSantiago Prike———8949 Mesa Dr, Houston, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-55780TPADiana Dixon1963-04-18—58188241635701 Union St, Nashville, TN0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-64272TPABenjamin Walker1995-12-12——4431 Union St Apt 10, Jacksonville, FL0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-101874ENRKeelly Williamson2002-09-08UHC-46667-3074726156009407 Union St, Chandler, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-125082ENRBarbara Espinoza1953-03-07UHC-74131-0292742972741702 Lincoln Way, Jacksonville, FL, 322140.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111330ENRGeorge Patterson1983-02-09UHC-34242-4860851256235376 Central Ave # 493, San Antonio, TX, 782050.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-56319TPAElijah Stone1944-04-03——250 Washington St # 471, Tempe, AZ, 852060.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114606ENREric T Bowman1950-05-23UHC-56333-0545093036058419 Central Ave # 287, Nashville, TN, 372960.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-129562ENRTheresa U Hicks1969-02-09UHC-01574-14—1799 Highland Ave, Jacksonville, FL, 322080.52Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+2 more
ENR-106103ENREthan I Wright1967-03-17UHC-95641-0540841100638968 Main St, Mesa, AZ, 852980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403568CLMJoe Richardson1943-10-04UHC-53594-59—5386 Apache Blvd, Nashville, TN0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-407453CLMJose Reyes1982-09-22——3037 Willow Ct, Phoenix, AZ, 850740.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-130684ENRKevin X Guerrero1985-05-16UHC-46668-3634878413902840 Apache Blvd, Dallas, TX0.52Two-digit birth yearPhone reformattedZIP missingGender normalised+2 more
CLM-422460CLMCharles Q Medina1965-05-16UHC-94822-28—8165 Sunset Blvd, Houston, TX, 770910.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-113108ENRLori T Ward1965-06-23UHC-57208-30—5185 Maple Ave, Denver, CO, 802710.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-127855ENRBetsy Parker1941-06-22UHC-00177-45—1852 Cedar Ln, Seattle, WA, 981410.52Member ID reformattedState name converted to codeZIP+4 trimmedGender normalised+2 more
ENR-108749ENRGabriel P Carter—UHC-25374-6642966360117602 Spring St, Scottsdale, AZ, 852820.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-400348CLM—Junk1950-12-14UHC-83429-9575649720078824 Ocean Ave, Charlotte, NC, 282940.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127310ENRBryan Graham1999-09-04UHC-39222-6676564482296502 Market St # 568, Charlotte, NC, 282390.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-126441ENRKeith I Bailey1986-02-12UHC-91055-8448394324011902 Park Pl, Seattle, WA0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-128823ENRElijah N Payne2000-07-03UHC-20841-62—7940 Hillcrest Rd, Gilbert, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
TPA-52465TPASandra Smith1977-06-05—40950111272383 Park Pl, Chandler, AZ, 852040.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401515CLMAlice Le1943-01-22UHC-49554-66—845 Bayshore Dr, Charlotte, NC0.52Name split from “Last, First”City re-casedZIP missingGender normalised+2 more
CLM-407658CLMRyn Austin—UHC-79286-6143585148481673 Church St, Orlando, FL, 328330.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-113922ENRAustin Pena—UHC-44306-4956924067195302 Mountain View Dr, Glendale, AZ0.52Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more
ENR-126621ENRAmber T Wellls1939-12-20UHC-53150-3061226333917373 Jefferson Ave, Chandler, AZ, 852150.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112534ENRJakke K Harvey1986-07-03UHC-64879-3431433357705435 Highland Ave, Miami, FL0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-428670CLMDouglas Patterson2000-08-26UHC-20741-40—4786 Sage Ct, Los Angeles, CA, 900520.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-102426ENRIsabella Bowman1953-10-22UHC-75417-10—1711 Union St, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51983TPATimothy Tran1958-04-25—46576453555906 Apache Blvd, Glendale, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419443CLMJoe Bishop—UHC-58513-77—1154 Forest Ave, Eden Prairie, MN, 553870.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405944CLMZachary Harris1972-03-02UHC-04428-6275244190316872 Sage Ct # 826, Miami, FL, 331030.52Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+2 more
ENR-130397ENRKlye Harper1997-08-03UHC-68942-5726798013311435 Jefferson Ave Apt 25, Gilbert, AZ, 852940.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409728CLMJacob Cooper1970-12-18UHC-27394-07—9817 Pine Dr, Chandler, AZ, 852570.52Name split from “Last, First”City re-casedZIP+4 trimmedGender normalised+2 more
ENR-108724ENRGabriel R Ross1982-07-27UHC-82385-4341237472435064 Mesa Dr, Sacramento, CA, 958750.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108725ENRGabriel R Ross1982-07-27UHC-82385-4341237472435064 Mesa Dr, Sacramento, CA, 958750.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136737ENRShirley Spencer1968-09-14UHC-49565-9855785124584384 Lincoln Way Apt 22, Fresno, CA, 937800.52Phone reformattedUnit split from streetCity re-casedState name converted to code+2 more
ENR-112438ENRSandra Spencer1981-03-07UHC-91154-1163272312922833 Willow Ct Apt 16, Chandler, AZ, 852920.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403572CLMTimothy Reynolds1961-07-01UHC-76724-37—8333 Forest Ave, Miami, FL0.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422210CLMVincent Morgan1986-08-06UHC-89453-5560197590136852 Union St # 772, Phoenix, AZ, 850970.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117265ENRRonald D Daniels1943-03-18UHC-95529-06—2498 Oak St Apt 33, Plano, TX, 750330.52Name re-casedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-414794CLMScott Ward1943-10-21——468 Pine Dr, Jacksonville, FL, 322510.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
TPA-56322TPAHeather Nelson1950-11-11—35841978717856 Jefferson Ave, Houston, TX, 770330.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-112667ENRWilliam V Vega1954-01-12UHC-29188-4533696585636214 Main St, Chandler, AZ0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
100,000 rows, page 192 of 2,000PreviousNext