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-102097ENRDouglas Carr1967-01-03UHC-34967-0765444423308779 Highland Ave, Phoenix, AZ, 850200.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123698ENRPaul M Robertson—UHC-98133-8678689631921361 Maple Ave, Jacksonville, FL0.48Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
CLM-419757CLMLukia Patel1982-11-08UHC-19806-9952092535533367 Meadow Ln Apt 11, Atlanta, GA0.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-429938CLMLauren I Johnson1991-06-20UHC-39409-51—1441 Central Ave Apt 3, Tempe, AZ, 852000.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416437CLMAnna F Baker1944-10-27UHC-10154-5872278878473705 Palm Dr, Chandler, AZ, 852890.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127848ENRVictoria Stewart1980-01-04UHC-07460-239043190599860 Forest Ave, San Antonio, TX, 782960.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111732ENRLoganJunk1994-07-22UHC-07950-9740097369829605 Canyon Rd, Mesa, AZ, 852030.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-425714CLMTeresa Fisher1959-04-26UHC-20504-8153576863085150 Main St, Scottsdale, AZ, 852990.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115996ENRJoshua H Jensen2002-08-16UHC-44883-7181322175625857 Cedar Ln, Dallas, TX, 752520.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100717ENRDorothy N Hill1999-08-03UHC-52013-5327076886477095 Elm St, Orlando, FL, 328630.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-103637ENRJerry McDonald1940-11-01UHC-42185-2533769849138173 Hillcrest Rd Apt 35, Atlanta, GA, 303510.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-103636ENRJerry McDonald1940-11-01UHC-42185-2533769849138173 Hillcrest Rd Apt 35, Atlanta, GA, 303510.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-430558CLMValentina Johston1981-12-19—46654317928285 Apache Blvd, Dallas, TX, 752450.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-119006ENRJustin Snyder1941-02-25UHC-15556-7886374425116092 Ocean Ave, Scottsdale, AZ0.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-26703PRVCharlotte Oliver1975-02-24UHC-36496-4995386998885885 Highland Ave, Phoenix, AZ, 850360.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123665ENRJennifer F West1962-05-28UHC-32000-97—9635 Camelback Rd, Austin, TX0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417285CLMAaron Ramos1994-06-24UHC-51082-4335898806221086 Desert Sky Blvd, Orlando, FL, 328540.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114070ENRCamila Knight1975-02-01UHC-56856-169185685593531 Baseline Rd Apt 2, Charlotte, NC, 282970.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-136144ENRIsabella Z Reed1987-08-24UHC-76255-4476866055398519 Main St, Gilbert, AZ, 852500.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-402696CLMAnthony Martin1982-10-23——2343 Oak St, Phoenix, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130856ENRArthur Garrett1991-02-17UHC-98433-7376045553934997 Camelback Rd, Miami, FL, 331220.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20554PRVJulie Lee1979-01-20—38425433075571 Harbor Blvd, Jacksonville, FL, 322450.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-141932ENRDouglas D Castillo1962-12-03UHC-86309-1774020249975903 Lake View Rd # 572, Jacksonville, FL, 322080.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-107747ENRLarry L Herrera1954-02-16UHC-34195-5525472964383663 Mountain View Dr, Austin, TX, 787790.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419893CLMLawrence Jackson—UHC-33336-5843029335148802 Harbor Blvd, Nashville, TN0.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
PRV-20401PRVMarilyn Long1982-08-17UHC-18585-0546965150474829 Oak St, Atlanta, GA, 303570.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107604ENRMatthew Ryan1972-02-10UHC-87039-0384194394852434 Willow Ct, Eden Prairie, MN0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430512CLMRuth Schutz2007-02-04UHC-03534-7074652808561937 Bayshore Dr, San Antonio, TX0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-403397CLMJeremy Munoz—UHC-92193-2992186020351606 Church St, Eden Prairie, MN, 553140.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-59357TPAElizabeth Santiago1974-02-24UHC-79914-44—1713 Ridge Rd # 159, Mesa, AZ, 852740.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-100409ENRHeather H Thomas1998-02-05UHC-74493-6823721455287841 Church St # 744, Minneapolis, MN, 554310.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-23631PRVMateo Harrison1950-12-08—78656505138418 Washington St, Atlanta, GA0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20820PRVNoah Chapman2002-04-15UHC-65294-579799046434397 Palm Dr, Phoenix, AZ, 850780.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56002TPAJean Lucas1978-04-09—58351111579228 Central Ave, Jacksonville, FL, 322840.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412070CLMKevin Mejia——87490239626452 Ridge Rd, Minneapolis, MN, 554860.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-419012CLMGeorge Washington1982-02-08UHC-44790-08—3555 Grand Ave Apt 12, Miami, FL, 331220.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
ENR-120436ENRKatherine N Hawkins—UHC-90748-5988199510807014 Valley View Dr, Austin, TX, 787880.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-415017CLMArthur Harvey1976-03-14UHC-78370-2190469839225334 Elm St # 811, Seattle, WA, 981040.48Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
PRV-23711PRVMei Li1953-11-28UHC-98792-3671166845569840 Palm Dr, Jacksonville, FL, 322550.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-427586CLMCarl Gardner2004-02-12UHC-45737-6269331806513562 Hillcrest Rd, Glendale, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101263ENRAndrew Harper1978-03-24UHC-15603-569438400787340 Lake View Rd, Los Angeles, CA, 900010.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26152PRVMariana U Jackson1992-11-20—49963105298346 Palm Dr, Austin, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61292TPABarbara Johnston1990-12-20—25739314566135 Ridge Rd # 327, Glendale, AZ, 853890.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410438CLMMertha Chapman1938-04-06——1455 Mountain View Dr, Tempe, AZ, 852180.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-129277ENRSamantha F Peters1997-12-01UHC-59150-8463033963494730 Mountain View Dr, Miami, FL, 331420.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
CLM-411515CLMCarl McCoy2008-07-20—40239181259103 Palm Dr, Tampa, FL, 336970.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117986ENRAnn L Morgan2001-12-12UHC-18409-3276772016196424 Cedar Ln, San Diego, CA, 921070.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-110931ENRAlan A Wilson—UHC-64460-0743783823659375 Camelback Rd # 395, Columbus, OH, 432790.48Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403951CLMBobby Cooper1998-12-01UHC-84475-104882831996379 Church St, Chandler, AZ, 852780.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
CLM-415972CLMPeter Padilla1985-05-25—75844332803373 Mountain View Dr, Phoenix, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 76 of 2,000PreviousNext