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-102221ENRHeather Fisher1990-08-26UHC-46371-2538534066946233 River Rd Apt 22, Miami, FL, 331370.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51088TPABryan Carpenter1953-01-10——3793 Harbor Blvd, Los Angeles, CA, 900750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120426ENRJoshua Gardner1941-01-10UHC-87871-0124669674498336 Bayshore Dr, Tucson, AZ, 857740.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123105ENRJose S Ryan1948-06-08UHC-19407-98—5976 Market St, Gilbert, AZ, 852810.48Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
CLM-402074CLMMichael Boyd1992-07-23UHC-19257-78—5328 Ridge Rd, San Antonio, TX, 782310.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53187TPARichard Santtos1947-06-15—69049554307248 Main St Apt 20, Mesa, AZ, 852170.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-124981ENRAnn Martinez2006-09-21UHC-19690-8520390828713769 Highland Ave Apt 39, Houston, TX, 770300.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-23265PRVLauren Cook1991-09-16—42077043015042 Highland Ave, San Antonio, TX, 782020.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-54645TPAMarcus Pierce1944-05-08——7945 Park Pl, Los Angeles, CA, 900960.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-21580PRVJesse J Hughes1956-06-22UHC-62926-9129969911754783 Valley View Dr, Phoenix, AZ, 850590.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408368CLMMason Maldonado1982-10-08UHC-54625-2327228623841570 Union St, Tampa, FL, 336040.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138017ENRGeorge Berry1987-02-04UHC-94256-1694821918484676 Ocean Ave, Chandler, AZ, 852990.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421741CLMNatalie Ward1959-04-17—59492895952490 Apache Blvd, Gilbert, AZ, 852640.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133603ENRBetty S Lucas1958-05-20UHC-66849-3829237401036439 Grand Ave, Los Angeles, CA0.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
PRV-28994PRVMateo Salazar1965-05-19UHC-62782-53—4525 Highland Ave # 743, Mesa, AZ, 852150.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-138305ENREmma R Black1975-09-27UHC-75057-9730448079969463 Sage Ct, Los Angeles, CA, 900010.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-57735TPAJuan Herrera1995-05-05—30192024148271 Apache Blvd, Mesa, AZ, 852190.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-21132PRVEthan Rios—UHC-98500-332722856719143 Lake View Rd, Orlando, FL, 328280.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-27964PRVMargaret Foster1950-06-28—28792189019550 Highland Ave, Phoenix, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114106ENRAshley N Hayes1970-03-20UHC-08753-0948428029162850 Valley View Dr Apt 38, Chandler, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133958ENRBrandon U Hart1982-04-10UHC-55080-9764227794962303 Indian School Rd Apt 33, Columbus, OH, 432180.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
PRV-26685PRVStephanie F Day—UHC-13402-2757648385255173 Highland Ave, Atlanta, GA, 303610.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-128167ENRMariana Nguyen1945-08-06UHC-21698-0268369941599516 Ocean Ave Apt 18, Chandler, AZ, 852500.48Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
TPA-56463TPAJecob Watkins1948-01-23——1221 Church St, Fresno, CA, 937190.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-140219ENREdward Hicks1989-04-06UHC-50339-1765454843633192 Mesa Dr, Columbus, OH0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112207ENRBrenda Coleman1992-11-18UHC-20384-7166259469617077 Sunset Blvd, Denver, CO, 802930.48Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-132115ENRDennis Ruiz—UHC-75844-1243047609342378 Valley View Dr, Dallas, TX0.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-109889ENRAbby Kelley1987-10-27UHC-49343-3023257785143540 Harbor Blvd Apt 23, Seattle, WA, 981720.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-122862ENRSean F Price1952-05-18—6433590619469 Apache Blvd, Chandler, AZ, 852960.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-141238ENRChristine Z Dixon1964-08-18UHC-34283-658512489796361 Mountain View Dr, San Antonio, TX, 782400.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28047PRVChristian X Holmes1951-08-01—54948752854067 Highland Ave, Minneapolis, MN0.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-141386ENRBran O Fox1940-05-21UHC-71539-2557790452224990 Highland Ave, Denver, CO, 802300.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122010ENRVirginia Lynch1988-09-10UHC-88578-38—9775 Willow Ct, San Antonio, TX0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-122446ENRLauren C Montgomery1983-02-01UHC-75031-0860440003363614 Canyon Rd, Fresno, CA0.48Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-135950ENRMartha I Campbell1970-12-14UHC-78455-9041760779193970 Harbor Blvd, Gilbert, AZ, 852010.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417606CLMArthur Gibson1982-09-25UHC-31926-06—6998 Cedar Ln, Austin, TX0.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-140499ENRAna E King—UHC-25436-1638039496325915 Park Pl # 766, Orlando, FL, 328500.48Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-420233CLMKaren Q Ruiz1943-08-01UHC-25421-2591932301215995 Sage Ct, Austin, TX, 787820.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-55589TPAJustin Wilson1974-03-27—95046258765123 Camelback Rd, Plano, TX, 750010.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137392ENRSam Pierce—UHC-33483-5968592172684847 Valley View Dr, Houston, TX, 770010.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-432778CLMNicole M Robertson1982-10-04UHC-44037-37556998175070 Lake View Rd Apt 32, Nashville, TN, 372760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138534ENRNancy Sims1976-06-23UHC-57979-9376552502399620 Hillcrest Rd, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413427CLMChristine James1957-02-26—63022363627804 Apache Blvd, Chandler, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-115969ENRStephen Heyes1954-03-20UHC-21260-7064334714673539 Union St, Scottsdale, AZ, 852030.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411571CLMGlora Lynch1980-11-13UHC-57656-6737797579754678 Grand Ave Apt 17, Tempe, AZ, 852260.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-427352CLM—Junk1966-06-01UHC-51600-7178620619202572 Hillcrest Rd, Miami, FL, 331110.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103132ENRDennise C Perkins1971-11-25UHC-55403-3686387417595125 Oak St, Glendale, AZ0.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120358ENRNoah D Bryant1949-03-15UHC-89912-12—8174 Pine Dr, Jacksonville, FL, 322620.48Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
ENR-113088ENRRussell Marquez1962-03-11UHC-20668-29—2146 Mesa Dr, Scottsdale, AZ, 852850.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-113139ENRLuis U Bell1956-03-23UHC-85259-8465195716169061 Meadow Ln, Atlanta, GA, 303000.48Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
100,000 rows, page 54 of 2,000PreviousNext