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-59076TPANicholas V Campbell2004-08-21——5205 Elm St, Scottsdale, AZ, 852020.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-124125ENRBrian Parker—UHC-66930-2737287379161902 Desert Sky Blvd # 676, Eden Prairie, MN, 553210.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-138548ENRAna Vargas1979-02-26UHC-00677-15—6532 Harbor Blvd # 829, Austin, TX, 787190.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-412113CLMChristopher Jenkins1982-09-18UHC-46541-04—9681 Forest Ave, Dallas, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-401698CLMSteve G Jensen1981-11-03—30235078895564 Washington St, Minneapolis, MN, 554300.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-107351ENRRachel Hansen1985-08-15UHC-39876-6240447185572713 Sunset Blvd, Gilbert, AZ, 852440.54Name split from “Last, First”Two-digit birth yearMember ID reformattedSSN last four extracted+1 more
TPA-53590TPAAustin Tucker2003-03-02—87855712336741 Cedar Ln, Tampa, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
PRV-27821PRVStephanei J Moore1978-07-04UHC-96480-1259873820914646 Ridge Rd, San Antonio, TX, 782560.54Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+1 more
ENR-136977ENRAlbert R Brown1992-04-12UHC-45592-1522541735911776 Grand Ave, Tucson, AZ, 857870.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
CLM-416403CLMHarold Rojas—UHC-16881-88—4310 Ridge Rd, Fresno, CA, 937940.54Date of birth unreadablePhone missing area codeState name converted to codeWhitespace trimmed+1 more
CLM-416402CLMHarold Rojas—UHC-16881-88—4310 Ridge Rd, Fresno, CA, 937940.54Date of birth unreadablePhone missing area codeState name converted to codeWhitespace trimmed+1 more
TPA-59062TPACarlos S Schmidt1942-01-28—6087291157886 Ridge Rd Apt 3, Atlanta, GA0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-103885ENREthan A Alexandar1973-07-04UHC-55550-61—4421 Baseline Rd, Glendale, AZ, 853870.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-106989ENRLaura J Bowman2002-12-23UHC-16543-1450772625864517 Church St, Fresno, CA, 937020.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-55323TPAGrace Sandoval———9578 Camelback Rd, Columbus, OH, 432450.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-132536ENRFrank K Roberts1982-06-11UHC-23833-1435552310967429 Washington St # 551, Phoenix, AZ, 850500.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-423923CLMGeorgeJunk1990-12-21—81260493565038 Ocean Ave, Seattle, WA, 981650.54Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared+1 more
TPA-64319TPADouglas Lukas1944-09-12—78370589632791 Forest Ave, Las Vegas, NV, 891770.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-430168CLMLawrence I Ray—UHC-62884-26—475 Pine Dr, Jacksonville, FL, 322130.54Name split from “Last, First”Date of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
TPA-59511TPAVictoria Barnes2003-11-26——1900 Ocean Ave, Charlotte, NC, 282510.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-410359CLMAhmed Riley2007-03-13UHC-08481-83—5024 Hillcrest Rd, Jacksonville, FL, 322830.54Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133372ENRScott Reed1965-09-13UHC-22245-7866064962819322 Lincoln Way Apt 24, Denver, CO, 802590.54Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code+1 more
TPA-52691TPAHanneh Green1981-12-16——9332 Camelback Rd, Dallas, TX, 752930.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-100422ENRAlexis Bell—UHC-40956-1078251120248121 Meadow Ln, Houston, TX, 770120.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-401749CLMKelly Harper2003-03-10UHC-75619-5332434229248799 Jefferson Ave, San Diego, CA0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-139123ENRTeresa G James1987-06-15UHC-36227-8962084588185550 Jefferson Ave Apt 40, Plano, TX, 750840.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-136294ENRBilly A Washington1996-02-02UHC-77163-1341337816081371 Desert Sky Blvd Apt 13, Glendale, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-419004CLMReynolds Wei1973-07-01UHC-28141-19—2782 Apache Blvd, Scottsdale, AZ, 852970.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-20463PRVSofia Chen1996-09-25—45574195147943 Washington St, Phoenix, AZ, 850060.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-50209TPAJudith Ortiz1981-01-05——9287 Camelback Rd, Gilbert, AZ, 852160.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
TPA-50210TPAJudith Ortiz1981-01-05——9287 Camelback Rd, Gilbert, AZ, 852160.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
ENR-127330ENRPamela Brown2003-11-10UHC-00296-23—6660 Maple Ave Apt 23, Orlando, FL, 328060.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-113123ENRAhmed West1998-02-07UHC-52082-6890322863846585 Mountain View Dr, Eden Prairie, MN0.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-405259CLMFrank Padilla1964-02-14UHC-18739-5464031681583588 River Rd, Minneapolis, MN0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-110212ENRSteven N Jones1987-01-21UHC-14206-1327451500528824 Main St, Tempe, AZ, 852610.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52932TPABradley Rodriguez1959-01-01——682 Pine Dr, Las Vegas, NV, 891940.54Name re-casedTwo-digit birth yearPhone missing area codeState name converted to code+1 more
CLM-402301CLMLawrece K Johnston1952-10-18UHC-57335-96—5968 Park Pl, Chandler, AZ, 852230.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-411393CLMLori Jordan1985-05-24UHC-12979-7072149276073367 Ocean Ave, Mesa, AZ, 852090.54Name split from “Last, First”City re-casedState name converted to codeGender normalised+1 more
CLM-412928CLMJustin Tran1940-01-10UHC-70251-56—7628 Pine Dr, Las Vegas, NV, 891290.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-133276ENRDonald Y Lene1974-01-25UHC-25028-4392236758114221 Cedar Ln, Denver, CO, 802910.54Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-407999CLMJean Waatkins1990-03-21——5101 Mountain View Dr, Seattle, WA0.54Name split from “Last, First”State name converted to codeZIP missingWhitespace trimmed+1 more
CLM-424915CLMDebra R Knight1991-04-27UHC-42617-07—4546 Church St, Tampa, FL, 336440.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-133383ENRChristina N Campbell—UHC-89991-6179568036736439 Apache Blvd Apt 7, Miami, FL, 331410.54Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-131484ENRAaron Berry1954-04-03UHC-39244-8696046039281258 Oak St # 355, Tucson, AZ, 857430.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-107729ENRJohn P Herrera1968-03-13UHC-51994-4776948021115996 Oak St, Plano, TX, 750860.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-61093TPAKelly Baker1953-02-17———0.54Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised+1 more
TPA-59038TPALinda B McDonald1980-04-09——6056 Highland Ave, Atlanta, GA, 303850.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138074ENRVincent T Bell1972-06-09UHC-71011-6366683699274948 Ocean Ave, Mesa, AZ, 852880.54Phone reformattedState name converted to codeZIP+4 trimmedGender normalised+1 more
CLM-401974CLMJustin Myers1972-03-15——1634 Apache Blvd, San Diego, CA, 921890.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416636CLMAnn G Stewart1946-07-10——6460 Valley View Dr, Gilbert, AZ, 852950.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
100,000 rows, page 207 of 2,000PreviousNext