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-62535TPADaniel Yagn1950-03-26——8826 Valley View Dr, Tucson, AZ, 857350.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-23419PRVJuan Coleman2008-05-26—96836167728188 Desert Sky Blvd Apt 17, Sacramento, CA, 958800.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117346ENRAnn X Fields1946-01-03—28028245565259 Valley View Dr, Tempe, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123544ENRElizabeth U Hanson1962-04-16UHC-09556-36—1298 Meadow Ln, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-63895TPAPamela Young———3553 River Rd, Columbus, OH0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423176CLMKelly Lucas1947-12-15UHC-15635-05—6413 Meadow Ln, Seattle, WA, 981180.52Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+2 more
ENR-135201ENRLucia K Cox1978-07-03UHC-24416-48—7527 Hillcrest Rd, Tucson, AZ, 857330.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-407599CLMWayne Wallace1967-05-17UHC-45597-20—4877 Valley View Dr, Tampa, FL, 336700.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-408422CLMLauren Roberts1985-08-02UHC-80177-29—2732 Palm Dr, Denver, CO0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-408688CLMEvelyn Ramos1970-12-02——330 Baseline Rd, Orlando, FL, 328320.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-404417CLMHiroshi Mills1962-05-01UHC-42502-0824971539411782 Highland Ave # 310, Las Vegas, NV, 891620.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-411133CLMLori Garcia1993-06-24UHC-39221-56—988 Sage Ct, Tampa, FL, 336910.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24735PRVRyan J Hill1966-09-13—35939730072450 Ridge Rd, Tempe, AZ, 852860.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126229ENRJohn Mendez1971-06-11UHC-77811-8439659576174815 Pine Dr Apt 25, Chandler, AZ, 852800.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419364CLMSofia Wallace1989-07-10—95165321101093 Ocean Ave, Orlando, FL, 328450.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137829ENRLori Fuller1985-09-22UHC-99756-5678192048492591 Camelback Rd, Tampa, FL, 336240.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-422657CLMMarcus Kelley1975-06-02——6515 Elm St, Eden Prairie, MN, 553060.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-122738ENRHolmes U Arjun1978-11-22UHC-29447-82—5851 Main St, Glendale, AZ, 853330.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23143PRVTom X Luna1986-04-10—89025439703916 Bayshore Dr, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105436ENRPriya U Chavez1999-09-07UHC-11128-2042736220843976 Market St, Chandler, AZ, 852780.52Name split from “Last, First”Two-digit birth yearCity re-casedState name converted to code+2 more
ENR-126834ENRBrooks Robert1956-03-14UHC-20176-4233886175538962 Central Ave, San Diego, CA0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113166ENRMartha J Payne1943-11-21UHC-73293-1385257803575082 Maple Ave, Charlotte, NC, 282060.52Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+2 more
ENR-142083ENRChristopher F Parker1978-01-19UHC-38984-8829649949882280 Sage Ct Apt 15, Columbus, OH0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-132845ENRDiane W Wells1941-11-24UHC-04452-606145750929754 Apache Blvd Apt 31, San Diego, CA, 921190.52Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-116470ENRKyle S Jensen1954-08-01UHC-25407-0133442299915279 Spring St, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102723ENRHelen Muray1952-12-22UHC-97100-194794401429432 River Rd, Los Angeles, CA, 900510.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411949CLMJacob Roberts1959-04-06UHC-64537-46—5524 Canyon Rd Apt 8, Austin, TX, 787960.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-111077ENRLogan J Clark1938-12-28UHC-88925-675217388404217 Elm St, Gilbert, AZ, 852650.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53736TPAJoe Matthews1945-05-09——1238 Willow Ct, Las Vegas, NV, 891830.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101354ENRWillie Austin1998-09-20UHC-42539-11—8903 Baseline Rd, Houston, TX, 770650.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429119CLMHerrera G Jim———4491 Church St Apt 16, Denver, CO, 802280.52Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+2 more
TPA-52319TPADennis Lane2006-01-24——5757 Oak St, Las Vegas, NV, 891120.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-20601PRVStephanie X Allen1995-11-20——8645 Apache Blvd, Tempe, AZ0.52Name split from “Last, First”SSN last four extractedState code upper-casedZIP missing+2 more
CLM-417149CLMMaria Hansen1977-08-11——7203 Central Ave, Los Angeles, CA0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410036CLMReecca H Tucker—UHC-44298-25—1044 Harbor Blvd, Austin, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429901CLMMark Nelson1957-10-06——3833 Desert Sky Blvd, Las Vegas, NV0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-140459ENRRoger Marshall1998-11-17UHC-50010-56—9125 Camelback Rd, Minneapolis, MN, 554180.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-115081ENRArjun N Cooper1997-01-20UHC-97990-0191021064683243 Ocean Ave, Fresno, CA, 937940.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62987TPAChristina Robinson1984-12-26UHC-12497-27—9312 Apache Blvd, Minneapolis, MN, 554150.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129373ENRSharon Campbell—UHC-06772-044465041093878 Canyon Rd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-113468ENRMary Knight1949-03-23UHC-69884-47—3855 Camelback Rd, Orlando, FL, 328930.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107575ENRMartha O Austin1992-04-23UHC-77689-5732030480964820 Ocean Ave, Denver, CO, 802040.52Middle initial moved out of first nameMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-60578TPAPamela Sanders1960-06-11——5409 Washington St, Nashville, TN, 372300.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-106143ENRCarlos N Yang1966-07-15UHC-31412-8733542562468160 Sage Ct Apt 18, Plano, TX, 750330.52Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
TPA-62409TPARoger Hrrison1992-07-11UHC-03161-3339355960059840 Central Ave Apt 18, Glendale, AZ, 853890.52Name split from “Last, First”Member ID reformattedUnit split from streetState name converted to code+2 more
PRV-26105PRVStephanie Ross1998-02-27——504 Sunset Blvd, Austin, TX, 787950.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-424807CLMMartha Hart1992-08-09UHC-75199-01—8285 Oak St, Orlando, FL, 328740.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-402805CLMBruce Harper2006-11-25——2021 River Rd # 649, Fresno, CA, 937710.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59336TPAAustin Franklin1944-05-04——8689 Bayshore Dr, Tempe, AZ, 852120.52Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-109568ENRRachel Q Watson—UHC-77213-1135128691841928 Camelback Rd, San Diego, CA, 921320.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
100,000 rows, page 154 of 2,000PreviousNext