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
PRV-26130PRVCarol Rogers1973-06-14UHC-29452-5664376766426820 Hillcrest Rd # 482, Minneapolis, MN, 554270.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54609TPA—Junk2004-04-13—62880478415051 Market St, Plano, TX, 750430.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-111848ENRDiane A Simpson1972-09-27UHC-14389-58—366 Hillcrest Rd, Tempe, AZ, 852340.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-108892ENRElizabeth D Burton1988-07-18UHC-20589-2080624508061311 Park Pl, Miami, FL, 331790.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-137234ENREric Simmons1978-05-13UHC-98882-0635340140204431 Lake View Rd, Tampa, FL, 336350.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-29347PRVDiego P Dominguez1985-01-01—66672321383937 Lake View Rd, Austin, TX, 787840.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-141989ENRTheresa J Sims1984-01-16UHC-55226-1952188513179244 Canyon Rd, Jacksonville, FL, 322610.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403018CLMNancy S Vazquez1967-08-27—65551461714030 Maple Ave Apt 9, Scottsdale, AZ, 852070.52Phone reformattedUnit split from streetZIP+4 trimmedGender normalised+2 more
PRV-21705PRVHannah Schmidt1959-01-13UHC-54182-06—5316 Park Pl, San Antonio, TX, 782260.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61902TPAJames Gardner1993-12-01——4528 Desert Sky Blvd, Nashville, TN0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126187ENRRonald Y Burton1938-12-05UHC-06575-0760661319018308 Washington St, Denver, CO, 802430.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-142607ENRJason D Spencer1943-05-08UHC-03083-48—447 Washington St, Minneapolis, MN, 554090.52Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-57281TPAEthan Welch———1962 Mesa Dr # 404, San Antonio, TX, 782210.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410401CLMBrian Hall1946-06-06UHC-70681-1177283313127724 Ridge Rd, Dallas, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-116377ENRRebecca Pierce1997-01-17UHC-36404-38—3492 Forest Ave, Houston, TX, 770340.52Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more
ENR-120404ENRDiego U Schmidt1989-02-24UHC-25673-0255546417936886 Forest Ave Apt 36, Miami, FL, 331870.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-409627CLMVirginia T Rie1942-12-26—57945767836678 Lincoln Way, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-141469ENRDeborah Barnes1978-07-21UHC-58944-2369764472561318 Cedar Ln # 646, Dallas, TX, 752280.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112282ENRAisha P Burke1958-10-14UHC-98365-7267494000756872 Palm Dr # 999, Nashville, TN, 372980.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403705CLMSamantha Z Guzman1969-12-26UHC-92739-3791182846335202 Market St, Los Angeles, CA, 900400.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55690TPAJohn Harper2004-01-19——7402 Ocean Ave, Atlanta, GA, 303890.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410851CLMKayla D Thompson1963-09-26UHC-24551-29711953873989 Park Pl, Mesa, AZ, 852760.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408080CLMMarcus Scott2003-02-20UHC-58921-8954756763422530 Harbor Blvd, Mesa, AZ, 852520.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102816ENRAndrew C Cooper1975-01-17UHC-60313-7252540630917383 Bayshore Dr, Columbus, OH, 432690.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
PRV-22573PRVLori Butler1981-02-20UHC-75436-96—405 Indian School Rd, Nashville, TN, 372700.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-107028ENRElijah A Brooks1964-10-22UHC-25287-2127694064332640 Baseline Rd Apt 25, Orlando, FL, 328290.52Two-digit birth yearPhone reformattedUnit split from streetGender normalised+2 more
ENR-107155ENRScott D Howard1989-08-10UHC-12674-7262272194182527 Union St, Chandler, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432061CLMCarl G Rios——6892764410180 Meadow Ln, Tucson, AZ, 857620.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-50283TPALauren Spencer1956-03-13——9516 Valley View Dr Apt 7, Mesa, AZ, 852800.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126232ENRAnthony G Hansen1963-05-16UHC-17160-0671776721818380 Elm St, Orlando, FL0.52Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-107303ENRMari Nguyen2003-04-02UHC-01436-7682020377584081 Willow Ct, Phoenix, AZ, 850300.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109101ENRMatthew K Montgomery—UHC-40390-8190794467514920 Lake View Rd, Charlotte, NC, 282790.52Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-429482CLMDenise Obrien1947-05-13UHC-16406-7958785166719137 Indian School Rd Apt 23, Nashville, TN, 372800.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
PRV-23677PRVAmber Kennedy1969-02-27—66220724291169 Apache Blvd, Los Angeles, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-128398ENRJose A McCoy1991-07-07UHC-05379-73—2234 Ocean Ave, Columbus, OH, 432330.52Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55424TPASharon Davis1962-12-16——5576 Highland Ave, Fresno, CA, 937500.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416764CLMRalph Sullivan1943-12-18UHC-55195-82—19 Washington St # 885, Orlando, FL, 328670.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-115215ENRBJunk1966-06-21UHC-05736-0441173089276799 Desert Sky Blvd, Jacksonville, FL, 322320.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425803CLMStephanie Chapman1961-10-04UHC-42279-63—7839 Main St, Gilbert, AZ, 852620.52Name split from “Last, First”Member ID reformattedState name converted to codeGender normalised+2 more
CLM-424128CLMJustin Boyd2007-09-17——3999 Pine Dr, Tempe, AZ, 852680.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-58319TPARichard Hicks1987-02-15——6440 River Rd, Eden Prairie, MN, 553210.52Date of birth reformattedCity re-casedState name converted to codeZIP+4 trimmed+2 more
PRV-25582PRVSophia Evans1974-12-27UHC-44844-7380262810869437 Sunset Blvd, Chandler, AZ, 852300.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411641CLMJason Moreno1977-12-24——7109 Pine Dr, Mesa, AZ, 852700.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-134688ENRRoy A Lawrence1993-06-09UHC-96696-0337496430751251 Main St, Dallas, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
CLM-427104CLMLori Burke1960-03-14—95829860803482 Sage Ct, Charlotte, NC, 282400.52Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+2 more
TPA-57062TPACarl Schmidt——77745733481359 Pine Dr, Mesa, AZ, 852540.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-409751CLMAmber Powell1964-03-27UHC-53088-98—7198 Ridge Rd, San Antonio, TX, 782520.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100817ENRDanny Welch2003-10-02UHC-49645-127715285780143 Ocean Ave, Mesa, AZ, 852390.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410544CLMNicole Nunez———6643 Valley View Dr, Dallas, TX0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410545CLMNicole Nunez———6643 Valley View Dr, Dallas, TX0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
100,000 rows, page 179 of 2,000PreviousNext