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
ENR-101924ENRAmanda E Walsh1965-11-10UHC-09751-1070035843699882 Cedar Ln Apt 13, Orlando, FL0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-27366PRVSara Kelley1984-12-26UHC-19411-9726666519231137 Meadow Ln, Glendale, AZ, 853530.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-27314PRVNicole Gilbert1951-01-25UHC-93489-4277028183606879 Market St, Orlando, FL, 328530.46Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+5 more
TPA-50481TPABeth G West1964-07-01——9763 Apache Blvd # 735, San Antonio, TX, 782940.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-412294CLMGregory K Torres1984-02-22UHC-36621-45—4772 Ocean Ave, Eden Prairie, MN0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-142550ENRJeffrey J Edwards1993-02-09UHC-98325-8097189372584979 Bayshore Dr, Plano, TX, 750320.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-113205ENRDebra Rojas1943-07-15UHC-41714-2078175659858068 Meadow Ln, Tampa, FL, 336880.46Date of birth reformattedPhone reformattedSSN last four extractedCity re-cased+5 more
CLM-400231CLMAustin Stone1949-11-17—46255305744169 Jefferson Ave, Chandler, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416467CLMLisa Lewis1951-03-27UHC-05664-7134636812612672 Park Pl, Jacksonville, FL, 322020.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-420079CLMJasoon A Powwell1964-02-12UHC-18174-8046469378785736 Meadow Ln, Miami, FL, 331520.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-116159ENRChristopher A Rivera1982-06-16UHC-38401-49—7584 Grand Ave, Tucson, AZ0.46Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more
CLM-405615CLMAmber S Garza1950-05-04——6737 Apache Blvd, Phoenix, AZ, 850010.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+5 more
CLM-414358CLMAna P Wong1980-05-28UHC-13625-7639559593764229 Pine Dr # 246, Scottsdale, AZ, 852770.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-110209ENRCharles O Ellis1972-11-13UHC-01634-6776571036379432 Church St, San Diego, CA, 921520.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-127749ENRJose Brooks1985-11-20UHC-69339-0456083428179210 Main St, Nashville, TN0.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-126585ENRLogan Park1943-12-09UHC-39537-4453227913538579 Highland Ave, Sacramento, CA, 958840.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-417284CLMAaaron Ramos1994-06-24UHC-51082-43—1086 Desert Sky Blvd, Orlando, FL, 328540.46Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-140451ENRLucia Tucker1984-08-18UHC-39477-434314122677174 Mountain View Dr Apt 17, Austin, TX, 787810.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-125190ENRSarah I Crawford1975-07-11UHC-51995-26—1056 Forest Ave, Tempe, AZ, 852520.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-137943ENRElijah Stewart1948-05-18UHC-91439-0662267289477215 Mesa Dr # 809, Atlanta, GA, 303670.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-137790ENRZachary R Welch1944-07-14UHC-56247-9227166814938305 Jefferson Ave # 167, Columbus, OH, 432450.46Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
TPA-55254TPAAustin Bryant2006-12-17—29463166296850 Spring St, Orlando, FL, 328990.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-139027ENRRichard Olson1957-09-12UHC-22683-75—9564 Pine Dr Apt 8, Austin, TX, 787230.46Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+5 more
ENR-127246ENRJean L Scott1974-06-25UHC-25460-5255838577074107 Park Pl, Los Angeles, CA, 900290.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-413709CLMSantiago Moore1963-11-19—57778466573960 Spring St, Nashville, TN0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-119106ENRJonathan P Sullivan1969-06-09UHC-02849-7666688858552307 Forest Ave Apt 6, Charlotte, NC0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-104263ENRHiroshi D Cunningham1950-08-06UHC-06723-472743143055590 Spring St, Glendale, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-61243TPAKelly Stephens1994-10-12—70272172835799 Main St, Fresno, CA, 937330.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101925ENRAmanda Walsh1965-11-10UHC-09751-1070035843699882 Cedar Ln, Orlando, FL, 328840.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133017ENRMegan M Butler1953-12-25UHC-88806-5979941566648973 Church St, Atlanta, GA, 303510.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-134682ENREvelyn P Palmer—UHC-50583-3960923909248011 Church St, Tucson, AZ, 857580.46Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+5 more
ENR-109842ENREvelyn Aguilar1950-07-13UHC-87143-5578358654132316 Ridge Rd, Tampa, FL, 336370.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-134132ENRJoshua Aguilar1959-08-24UHC-27301-6393449500866369 Oak St, San Antonio, TX, 782010.46Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more
CLM-427351CLMWillie Chavez2007-02-03UHC-34974-9951470863634782 Pine Dr, Denver, CO, 802890.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101756ENRArjun Gardner1987-08-28UHC-24635-1548783034677270 Bayshore Dr, Denver, CO0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-423470CLMDiiego Fields1958-05-17——7626 Union St # 230, Los Angeles, CA, 900920.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
ENR-109958ENRJudith O Boyd—UHC-46308-61—9713 Desert Sky Blvd, Charlotte, NC, 282580.46Name re-casedDate of birth unreadablePhone missing area codeMember ID reformatted+5 more
ENR-132490ENRHiroshi Brooks1990-08-15UHC-65032-3343857371302677 Washington St, Mesa, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-134884ENRDylan Padila1974-09-27UHC-64991-6660593078968669 Meadow Ln Apt 38, Plano, TX, 750180.46Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-24317PRVJack A Chavez1996-05-15—53161871913756 Sunset Blvd, Gilbert, AZ, 852750.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22845PRVAbigail Jenkins2005-12-11UHC-73523-6772178800875428 Apache Blvd, San Diego, CA, 921850.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-110137ENREmma S Moore1940-06-16UHC-42322-2548549418267623 Spring St, Eden Prairie, MN0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23411PRVDebra Lewis1949-12-24—43480893989547 Meadow Ln # 330, Austin, TX0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-429314CLMValentina Stevens1943-01-26—21699986085643 Meadow Ln, Eden Prairie, MN, 553580.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419468CLM—Junk1962-03-27—84543559255075 Spring St Apt 12, Austin, TX, 787870.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
TPA-62743TPADaniel Marshall——86641216916761 Hillcrest Rd, Nashville, TN, 372860.46Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
TPA-59883TPADanielle Martinez2004-07-22——8733 Desert Sky Blvd, Orlando, FL, 328150.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-51196TPATimothy Vargas1956-09-02——3151 Palm Dr, Glendale, AZ0.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-140522ENRTerry Arnold1941-04-23UHC-90021-63—6184 Pine Dr, San Antonio, TX0.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-112276ENRBradley W Jones1980-07-11UHC-91461-9381890727402163 Baseline Rd, Las Vegas, NV, 891620.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
100,000 rows, page 46 of 2,000PreviousNext