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-422414CLMGary Espinoza1942-02-25UHC-09582-4442346650728150 Mesa Dr, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-420402CLMCarol Ortega1996-01-15UHC-51717-7359678030695241 Central Ave Apt 18, Tampa, FL, 336120.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-116191ENRIsabella O Black1988-09-02UHC-19050-028686574633521 Spring St, San Diego, CA0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-118586ENRRebecca J Perry1949-08-01UHC-79876-1994081426862918 River Rd, Seattle, WA, 981230.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124266ENRGarry U Perez1980-08-18UHC-00936-2944568951975936 Park Pl, Tempe, AZ, 852980.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432665CLMZachary Allen1997-01-10——2122 Union St, Plano, TX, 750210.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-130679ENRAna Thomas1983-07-19—32849167616256 Apache Blvd Apt 13, Tampa, FL0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24020PRVTeresa L Castro1974-07-06UHC-25853-305968562151324 Ridge Rd, Tampa, FL0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-24022PRVMarcus West1999-09-26—23067476447751 Union St, Mesa, AZ, 852220.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413780CLMGloria Ray1982-06-02—823277365864 Central Ave, Tucson, AZ, 857120.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-406504CLMEmma S Pena1949-07-17UHC-14042-8531621651562462 Highland Ave, Nashville, TN, 372450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20903PRVMary U Daniels1969-09-15—32624261463406 Market St, Denver, CO, 802590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51383TPAVincent Brooks1946-11-09——1195 Ridge Rd, Eden Prairie, MN, 553000.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-20481PRVJohn Santiago2005-10-04—92178307709707 Ridge Rd, Dallas, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120137ENROmar G Nichols1974-12-28UHC-45484-8750664034521161 Ridge Rd, Denver, CO, 802730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428898CLMDan Ward1941-04-15UHC-94840-20—2104 Palm Dr, Denver, CO, 802940.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-120018ENRSusan Padilla1965-01-07UHC-62689-0622089110438745 Cedar Ln, Glendale, AZ, 853680.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422641CLMDeborah Wilils1974-02-17——2399 Harbor Blvd, Miami, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407502CLMCamila A Sandovval1972-06-25—61538616857717 Ocean Ave, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-106434ENRKyle Curz—UHC-67404-3374273260304360 Broadway, Glendale, AZ, 853540.50Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+3 more
TPA-57486TPAJoe Q Powell———5587 Harbor Blvd, Tampa, FL0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-141923ENRTyler Fisher1970-10-15UHC-12257-4059772420027191 Forest Ave, Fresno, CA, 937960.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-102159ENROlivia F Carter—UHC-78576-0167493289787159 Desert Sky Blvd, San Antonio, TX, 782290.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56913TPANoah Black1999-05-15——9551 Baseline Rd, Scottsdale, AZ, 852390.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-51344TPAMargaret James1943-09-04——831 Grand Ave # 328, Tempe, AZ, 852400.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-127517ENRTyler Perry1954-06-03UHC-60694-52—9309 Desert Sky Blvd, San Antonio, TX, 782910.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418592CLMCatherine Coleman2004-08-12UHC-75249-3955082842244690 Camelback Rd, San Antonio, TX, 782920.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-125620ENRAlice Delgado1984-09-11UHC-45437-5662542104456296 Washington St Apt 18, Minneapolis, MN, 554890.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102771ENRMarcus M Woods2003-01-14UHC-97464-0856968364925181 Harbor Blvd # 561, Orlando, FL, 328570.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23795PRVJason Wang1942-07-04UHC-43783-3553543194081287 Harbor Blvd # 201, Los Angeles, CA, 900110.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142321ENREric Castro1948-07-16UHC-70681-72—575 Apache Blvd, Austin, TX0.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132889ENRBrenda Cruz2006-05-16UHC-82459-6164669855512625 Sunset Blvd, Plano, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50332TPADouglas Morales1952-08-19—91724543532023 Maple Ave, Gilbert, AZ, 852260.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137366ENRTerry Hughes2002-02-18UHC-96369-8921589558113241 Valley View Dr, Phoenix, AZ, 850180.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-134405ENRJack Brooks1981-01-26UHC-28522-727917222951391 Market St, Las Vegas, NV, 891940.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-407403CLMPeter Riley1989-11-21UHC-68971-8259367593355137 Willow Ct, Phoenix, AZ, 850180.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403788CLMSamuel Ramireez1986-05-28UHC-35438-68—895 Church St, Glendale, AZ, 853760.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114940ENRMary Fields1941-09-09UHC-14826-97—6672 Elm St, Denver, CO, 802380.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-132015ENRFatima Y Stephens1995-07-04UHC-06221-6426444757591103 Main St, Sacramento, CA, 958620.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-419681CLMOlivia Z Arnold—UHC-48489-95—824 Forest Ave, Plano, TX, 750490.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21163PRVAaron Larson1996-05-07—68399198053534 Union St, Nashville, TN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61156TPAEmily Sims1991-09-03——9820 Ocean Ave, Phoenix, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60931TPAMarucs Griffin1955-02-22——6506 Spring St, Phoenix, AZ0.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-108466ENR—Junk1988-10-03UHC-47094-1238432456562590 Sage Ct, Glendale, AZ, 853190.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-114643ENRMaria G Kelly1970-02-25UHC-02887-027049041430478 Spring St, Minneapolis, MN, 554560.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-414647CLMSantiago Wong1981-08-16—23856276897006 Mesa Dr, Jacksonville, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111363ENRCheryl Rios1947-10-04UHC-04103-4774778684924133 River Rd, Minneapolis, MN, 554770.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-131200ENRLogan L Ward1957-07-06UHC-11133-9289439117273076 Valley View Dr, San Antonio, TX, 782330.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-134391ENRMark Z Vazquez1992-11-10UHC-54827-0751485554002171 Hillcrest Rd # 959, Minneapolis, MN, 554760.50Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101287ENRGeorge Y Rios1974-11-12UHC-27407-5194551011106504 Valley View Dr, Austin, TX, 787070.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 128 of 2,000PreviousNext