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
CLM-429541CLMOmar O Boyd1939-02-16UHC-90001-1362924455015368 Lake View Rd, Tempe, AZ, 852570.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-431020CLMSarah S Dunn—UHC-26514-9825451406874136 Grand Ave Apt 5, Dallas, TX, 752680.48Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-102861ENRStephen Mason1949-01-20UHC-11372-10—5037 Ocean Ave, Columbus, OH, 432240.48Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+4 more
CLM-403225CLMMichael Campbell2005-09-05UHC-94863-84—1057 Maple Ave Apt 29, Austin, TX, 787310.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-56124TPAKeith Ross1939-07-21——4892 Baseline Rd, Phoenix, AZ, 850260.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-112430ENRBobby Hernandez1974-07-03UHC-97966-7130224288036500 Harbor Blvd, Orlando, FL, 328490.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127109ENRAlice Mendoza1973-07-01UHC-85886-8431637853734821 Cedar Ln, Atlanta, GA, 303360.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109813ENRMason Ramirez1964-05-03UHC-58089-01—3165 Spring St, Fresno, CA, 937690.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-400875CLMTimothy Kelly1988-07-01—48931001292193 Mountain View Dr, Seattle, WA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404187CLMSharon Santos1990-01-28UHC-46936-59—6404 Bayshore Dr # 971, Denver, CO0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-422561CLMKeith Foster1973-01-10UHC-88227-2384669712323575 Oak St, Phoenix, AZ, 850430.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-103209ENRKeith Mills1940-08-12UHC-71507-3791351906873588 Canyon Rd, Plano, TX0.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-423204CLMKeith Griffin1979-04-15—50884260491713 Cedar Ln, Sacramento, CA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420146CLMSusan Yang2000-01-13UHC-21009-4247698699353414 Church St # 502, Jacksonville, FL, 322950.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-423616CLMAustin Harvey1988-02-02UHC-73934-26—8260 Main St # 666, Denver, CO0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-425703CLMKayla Willis1944-09-11UHC-95285-80—7871 Ridge Rd # 923, Tampa, FL, 336160.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114695ENRJonathan W Lawson1945-03-06UHC-79224-89856414071612 Forest Ave, San Antonio, TX, 782100.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-111556ENRNathan Rose1964-05-05UHC-57831-42—439 Baseline Rd, Denver, CO0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115169ENRLogan N Collins—UHC-11070-9951140081049814 Pine Dr, Las Vegas, NV, 891370.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-27957PRVJesse Russell1983-04-14UHC-39788-2450456755828446 Camelback Rd, Phoenix, AZ, 850880.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107032ENRNicole Hanson2006-01-09UHC-87068-6257685262523984 River Rd, Jacksonville, FL, 322170.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120857ENRJordan Carroll1999-11-13UHC-70296-2993278090773188 Desert Sky Blvd, Atlanta, GA, 303570.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127700ENRJoyce S Perez1958-08-13UHC-34295-4568644138468692 Hillcrest Rd, Miami, FL, 331060.48Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-129439ENRElijah Cerr1980-02-25UHC-17312-6153567709328995 Sunset Blvd, Miami, FL, 331570.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-56597TPAWillie Butler1959-10-24——1562 Central Ave Apt 17, Mesa, AZ, 852150.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-407340CLMJoshua Hanson1960-08-22—7238151215967 Oak St, Eden Prairie, MN, 553340.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-126821ENRJesse Thomas1968-01-15UHC-48971-2938661484781706 Valley View Dr, Miami, FL, 331680.48Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-428452CLMMateo Park2002-04-13UHC-21681-0687435470875295 River Rd, Denver, CO0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101268ENRJoan Singh1960-03-25UHC-03484-7672489196135676 Palm Dr # 496, Eden Prairie, MN, 553170.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-416612CLMElijah Burke2003-04-06UHC-58551-91—7099 Elm St Apt 9, Glendale, AZ, 853600.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-23508PRVJack Soctt1949-08-22UHC-60017-5563330782316031 Elm St # 686, Las Vegas, NV, 891670.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-100284ENRGeorge R Knight1976-08-20UHC-05781-7840343275145156 Palm Dr, Gilbert, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-121912ENRKathryn Y Perkins1951-10-26UHC-15775-3432148502668788 Highland Ave, Charlotte, NC0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23812PRVAaron Rojas——31643523791140 Spring St, Tempe, AZ, 852440.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25003PRVMichelle Chavez1992-04-26UHC-36979-4076441803055832 Sunset Blvd # 499, Scottsdale, AZ, 852880.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51289TPAArjun Turner1984-09-08—76967179818735 Valley View Dr Apt 1, Phoenix, AZ, 850670.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-400489CLMMichael Bery1992-08-04UHC-59279-12—7385 Canyon Rd, Orlando, FL, 328580.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-139904ENREmily F Ortiz1959-03-07UHC-21261-5871454289209081 Willow Ct # 686, Charlotte, NC, 282030.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-409588CLMDonald Vaquez1960-05-26——1869 Mesa Dr, Scottsdale, AZ0.48Name re-casedDate of birth reformattedCity re-casedState name converted to code+4 more
ENR-114765ENRRussell V Donald1974-02-22UHC-63213-4674929272205913 Maple Ave, Houston, TX, 770460.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-52026TPASean Torres1939-04-18——1225 Park Pl, Las Vegas, NV, 891210.48Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-102535ENRLisa L Thompson1939-05-26UHC-64914-6493245476586126 Ridge Rd # 441, Houston, TX, 770960.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-115085ENRVictoria O Cooper1960-10-11UHC-00539-4933239981496043 Forest Ave, Charlotte, NC0.48Name re-casedSSN last four extractedCity re-casedState name converted to code+4 more
ENR-125753ENRLaura OJunk1969-02-08UHC-98868-6731546338832369 Bayshore Dr, Dallas, TX, 752530.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-429453CLMWayne Lucas1983-03-12UHC-83195-72—7615 Indian School Rd, Fresno, CA0.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-401125CLMJordan Welch2001-11-13UHC-43144-83—2704 Maple Ave # 582, Denver, CO, 802260.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-29059PRVJulie N Guerrero——90088934943375 Apache Blvd, Sacramento, CA0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54034TPADennis Foster——95462301147226 Ocean Ave, Jacksonville, FL, 322120.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103126ENRLori King1957-04-06UHC-92761-5834124088983025 Lake View Rd, Jacksonville, FL0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124214ENRHelen Oliver1978-08-26UHC-84939-8074466773287301 Church St, Columbus, OH, 432500.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
100,000 rows, page 73 of 2,000PreviousNext