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-61340TPAAaron Reyes1946-09-11—24061062597541 Canyon Rd, Charlotte, NC, 282280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61341TPAAaron Reyes1946-09-11—24061062597541 Canyon Rd, Charlotte, NC, 282280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408467CLMJudy Payne1950-01-20——1141 Indian School Rd, Minneapolis, MN, 554020.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415266CLMAlbet W Richadrs1994-01-03—34650883913265 Church St, Chandler, AZ, 852460.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429008CLMPeter Garrett1989-03-09—67243641686303 Church St, Orlando, FL, 328310.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61257TPAWalter Morris1945-08-18——9310 Forest Ave, Las Vegas, NV0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-122869ENRBilly W Edwards1985-12-05UHC-09876-0121073508035729 Camelback Rd, Tempe, AZ, 852010.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101643ENRVincent X Tran1987-09-12UHC-31092-9449665425999163 Central Ave, Tucson, AZ, 857260.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-428187CLMVictoria Ramirez1987-10-14—48284578523413 Desert Sky Blvd Apt 7, Mesa, AZ, 852670.52Phone reformattedUnit split from streetState name converted to codeGender normalised+2 more
ENR-130379ENRCynthia Nunez1966-08-17UHC-40492-8931191553976744 Camelback Rd Apt 11, Mesa, AZ, 852070.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-111442ENRElijah Q Vega1948-05-08UHC-68333-423405042350925 Spring St, Chandler, AZ, 852150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-135029ENRCharles Robinsson—UHC-14595-20—3748 Ocean Ave, Tempe, AZ, 852770.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-111838ENRJohn V Andrews1960-09-20UHC-04984-49—8168 Lincoln Way, Dallas, TX, 752340.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105610ENRLucia F Hoffman1941-02-12UHC-31201-993569658725836 Desert Sky Blvd, Seattle, WA, 981950.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-142099ENRJonathan X Bishop1998-06-24UHC-27890-4072530084035797 Desert Sky Blvd, Mesa, AZ, 852150.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432103CLMKimberly Carlson—UHC-99272-77—8110 Highland Ave # 212, Mesa, AZ, 852140.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
CLM-425773CLMJoan J Soto1981-05-17—75788535561004 Apache Blvd, Los Angeles, CA, 900000.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402226CLMAlice Singh1983-02-16——4384 Main St, San Antonio, TX0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57749TPAMarilyn King1970-10-14—88246655717092 Pine Dr, Houston, TX, 770780.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-108377ENRMoreno F William1953-05-16UHC-32552-3071226647797067 Forest Ave, Austin, TX, 787290.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-133009ENRJremy Dunn2002-08-04UHC-68007-89—5789 Apache Blvd Apt 5, Charlotte, NC, 282440.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-124334ENRYuki V Salazar1949-11-06UHC-78489-0734375276179084 River Rd, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21589PRVJessica Alexander1973-06-17——5403 Jefferson Ave, Phoenix, AZ, 850340.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410012CLM—Junk1981-10-05UHC-80308-05—1263 Harbor Blvd, Gilbert, AZ, 852770.52Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-402492CLMDanielle Bishop1974-09-14——5050 Desert Sky Blvd, Houston, TX, 770670.52Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-404273CLMAdam Clark1994-12-09UHC-19041-5720884205314456 Park Pl, Denver, CO, 802010.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431768CLMHiroshi B Day1998-11-02——9870 Apache Blvd Apt 30, Mesa, AZ, 852780.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418121CLMDonald Sullivan1972-02-12UHC-55880-2681742480369412 Main St Apt 14, Fresno, CA, 937090.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139011ENRPatrick I Santiago1951-07-19UHC-87991-71—1176 Willow Ct, Fresno, CA, 937980.52Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
ENR-114967ENRAdam Williamson1951-08-21UHC-78870-26—2585 Harbor Blvd, Houston, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114966ENRAdam Williamson1951-08-21UHC-78870-26—2585 Harbor Blvd, Houston, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24227PRVSara F Murphy2008-01-24UHC-77515-8536690103477201 Cedar Ln, Las Vegas, NV, 891840.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415125CLMHarrison M Adm2008-10-07UHC-57645-54—2956 Sage Ct, Minneapolis, MN0.52Middle initial moved out of first nameName re-casedTwo-digit birth yearZIP missing+2 more
TPA-50505TPATerry Fox2007-08-14——5658 Maple Ave, Las Vegas, NV, 891810.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-139243ENRPricce V Mateo2008-02-20UHC-70897-2961960875674704 Mountain View Dr, Tempe, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21294PRVAlexis Harvey1991-02-11UHC-56292-04—6202 Bayshore Dr, Nashville, TN, 372110.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113173ENRMariana T Green1989-08-17UHC-41515-8035471599299052 Grand Ave, Denver, CO, 802220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419334CLMGregory F James1971-03-22——8867 Hillcrest Rd # 519, Charlotte, NC, 282490.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420170CLMMaria G Armstrong1965-02-02UHC-58502-70—6800 Maple Ave, Tampa, FL, 336770.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-402268CLMSamantha Padilla———2359 Union St, Columbus, OH, 432140.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-120467ENRWei Kim1968-03-07UHC-37453-9477874259927066 Hillcrest Rd, Houston, TX, 770520.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102782ENRHolmes E Bruce1966-07-06UHC-64889-2633036082948363 Main St, Tucson, AZ, 857690.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-126339ENRCheryl P Allen—UHC-03912-0174682923099106 Sunset Blvd, Mesa, AZ0.52Name split from “Last, First”Date of birth reformattedDate of birth unreadableZIP missing+2 more
ENR-137966ENRHannah Rojas1963-01-04UHC-56751-8597755291341371 Lake View Rd, Nashville, TN0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422230CLMSamuel Perkins1969-08-26—6179691045514 Meadow Ln, Los Angeles, CA, 900330.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51016TPARalph Stephens2000-12-04——3893 Elm St, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-402930CLMGregory Morales1942-12-05UHC-11323-443389600893999 Jefferson Ave, Chandler, AZ, 852710.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427032CLMRebecca Garcia—UHC-03053-8750293876133630 Baseline Rd Apt 21, San Diego, CA, 921200.52Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+2 more
CLM-416312CLMKathleen Johnston1964-01-05—65960693611204 Highland Ave, Los Angeles, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57343TPAMelissa Holmes1950-12-25——7566 Spring St # 263, San Antonio, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
100,000 rows, page 146 of 2,000PreviousNext