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-140346ENREugene F Reyes1966-05-18UHC-92197-1156690629319300 Maple Ave, Los Angeles, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133756ENRMarcus P Thompson—UHC-71607-7340122472164858 Apache Blvd, Atlanta, GA0.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-119232ENRKevin D George1941-01-17UHC-63679-2187798915981143 Jefferson Ave # 221, Houston, TX, 770300.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416948CLMBradley Q Sims2006-09-04—79738646405554 Cedar Ln, Atlanta, GA, 303000.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-22249PRVBeverly Phillips1945-08-19UHC-74481-708465817626996 River Rd, Nashville, TN, 372140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429228CLMThomas Campbell1945-08-21UHC-19472-4325047665861644 Highland Ave, Eden Prairie, MN, 553270.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112310ENRTeresa Williamson1981-01-26UHC-54512-5441421629872913 Lincoln Way, Dallas, TX, 752570.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-126663ENRStephanie Lee1958-09-17UHC-99580-25—5666 Lake View Rd, Minneapolis, MN, 554230.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
TPA-58973TPAJessica Miller1952-02-08——8223 Jefferson Ave, Jacksonville, FL, 322520.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22998PRVMason H Chen1982-09-21UHC-68233-5971040032719569 Canyon Rd Apt 30, San Antonio, TX, 782400.48Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
PRV-27940PRVRichard L Gonzales1974-05-08UHC-13350-1772232724746299 Ocean Ave, Minneapolis, MN0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123608ENRRyan P Rogers1988-02-01UHC-87700-6173722149038822 Cedar Ln, Atlanta, GA0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-28727PRVBrian Ramos1971-08-15—7093802338134 Market St, Fresno, CA, 937140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28726PRVBrian Ramos1971-08-15—7093802338134 Market St, Fresno, CA, 937140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406139CLMJacob Kim1988-11-28——3777 Cedar Ln, Los Angeles, CA, 900390.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-142406ENRDiane P Perkins1983-03-17UHC-00538-2756531585274580 Hillcrest Rd, Glendale, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23318PRVRebecca Garza—UHC-40205-4954955613905199 Union St, Plano, TX, 750440.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-23801PRVMarilyn Aguilar1989-02-22—44645788774665 Baseline Rd, Chandler, AZ, 852350.48Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+4 more
ENR-119190ENRNicole Robertson1976-07-12UHC-67797-4747324638233505 Sage Ct, Los Angeles, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56512TPAPamela K Butler1995-11-10——8619 Spring St, Miami, FL0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-107623ENRJacob J Reed—UHC-01120-6358066391949349 Meadow Ln, Columbus, OH0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122887ENRLinda Z Garrett1979-03-06UHC-28085-1836791340938977 Hillcrest Rd, Tempe, AZ, 852550.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23878PRVBruce Murray1994-10-11UHC-95825-7928930729862873 Highland Ave, Minneapolis, MN, 554380.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56650TPADaniiel K Reid1939-01-23UHC-18514-1247752400458395 Camelback Rd, Columbus, OH, 432090.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411735CLMJuan F Kelly2002-07-25—20585886931899 Maple Ave Apt 14, Dallas, TX0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133683ENRLisa V Singh1998-06-03UHC-77375-17—3457 Mesa Dr, Miami, FL, 331010.48Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
ENR-137569ENRKatherine Padila1943-06-08UHC-78445-7594167746134199 Ridge Rd, Seattle, WA, 981160.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-139931ENRKyle Z Le—UHC-49171-75—3289 Church St, Eden Prairie, MN, 553700.48Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-410092CLMWalter M Sanchez1997-08-25UHC-28330-36—6160 Elm St, Tampa, FL0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130695ENRDonna G Holmes1958-03-17UHC-94194-3068022402418953 Main St, Glendale, AZ, 853080.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
PRV-26354PRVKim H Harvey1960-01-28——1939 Palm Dr, Miami, FL, 331530.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-109710ENRGerald Bailey1939-07-16UHC-38263-5538922748116098 Washington St, Plano, TX, 750640.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-120103ENRRuth B Wilson1970-07-22UHC-28608-66—1034 Camelback Rd, Jacksonville, FL, 322660.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-419949CLMEvelyn Le1993-12-09UHC-70727-0553421953951620 Central Ave # 910, Glendale, AZ, 853490.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129741ENRXJunk1993-09-06UHC-00455-395858741769592 Jefferson Ave, Charlotte, NC, 282810.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131586ENRBenjamin U Carpenter—UHC-86121-26—8555 Baseline Rd, Columbus, OH, 432430.48Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+4 more
CLM-420126CLMScott Clark1946-04-12UHC-35459-0250782464194843 Bayshore Dr, Houston, TX, 770430.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420127CLMScott Clark1946-04-12UHC-35459-0250782464194843 Bayshore Dr, Houston, TX, 770430.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26562PRVLarry Lawrence1962-08-16—2058113418891 Indian School Rd, Glendale, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402233CLMStephanie Harvey1990-03-05UHC-11287-5275831845206362 Union St, Eden Prairie, MN, 553380.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127578ENRLinda O Hart1952-12-22UHC-14871-1289697768708803 Canyon Rd, San Diego, CA0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116981ENRDorothy Bishop1975-12-12UHC-06383-2577445837908850 Mesa Dr, Houston, TX, 770400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27288PRVMartha Hart1992-08-09UHC-75199-0161121682188285 Oak St, Orlando, FL, 328740.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132891ENRLinda V Reynolds2004-10-19UHC-41436-28—900 Ocean Ave, Tempe, AZ0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129077ENRSharon E Rose2004-02-27UHC-55095-57270396571999 Lake View Rd Apt 16, Orlando, FL, 328390.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-417501CLMJustin Reyes1963-09-22——4889 Spring St, Glendale, AZ, 853370.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-409716CLMChheryl Grraham1981-01-16UHC-72022-3897849717796905 Elm St Apt 25, Minneapolis, MN, 554110.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25657PRVKelly Gonzales1965-12-21—87052621864772 Forest Ave, Plano, TX, 750140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140206ENRBarbara Stevens1976-08-17UHC-77280-772502990466720 Main St, Las Vegas, NV, 891500.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27076PRVKaren N Harrison1987-01-26—8458765434718 Canyon Rd, Jacksonville, FL, 322070.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
100,000 rows, page 69 of 2,000PreviousNext