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
PRV-24926PRVDebra C Robertsson1983-01-04UHC-55599-5271050049084220 Canyon Rd, Seattle, WA, 981340.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-59061TPAAisha Nichols1996-07-14——9422 Baseline Rd, Orlando, FL, 328260.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-141531ENRKayla Rojas1944-07-13UHC-54092-53—6042 Church St, Tucson, AZ, 857850.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-123072ENRAlan Gibson2000-06-13UHC-40231-8034426072186176 Mountain View Dr # 875, Fresno, CA, 937400.52Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125568ENRCharlotte Weber—UHC-81561-0674453283436065 Sage Ct, Scottsdale, AZ, 852650.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-125032ENRKathy W Perry1973-08-28UHC-08328-1289770801436377 Park Pl, Nashville, TN0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23174PRVLaura Daniels1978-04-28—71658950632172 Lincoln Way, Chandler, AZ0.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+2 more
ENR-108654ENRBrenda Bradley1954-10-17UHC-06264-5261675243125192 Meadow Ln, Jacksonville, FL, 322420.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418941CLMHelen O Jhnson1977-05-18UHC-28850-11—9802 Bayshore Dr, Los Angeles, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-51249TPAGrace V Salazar1946-06-19—65599642756117 Mountain View Dr, Glendale, AZ, 853940.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114012ENRJoshua D Rogers1964-01-23UHC-33304-4878924933547625 Maple Ave, San Diego, CA, 921870.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23364PRVJulie Johnson1971-12-09——4699 Sunset Blvd, Houston, TX, 770230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-23365PRVJulie Johnson1971-12-09——4699 Sunset Blvd, Houston, TX, 770230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-432499CLMOmar Bryant1987-03-17UHC-89172-02—3274 Willow Ct, Chandler, AZ, 852070.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-101719ENRRaymond U Foster1973-06-17UHC-62692-5528698694049571 Sunset Blvd, Jacksonville, FL0.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50829TPACloe Stephanie1997-09-22——4353 Ocean Ave # 180, Houston, TX, 770310.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416191CLMSteven Brooks1991-05-11UHC-72425-74—6614 Camelback Rd # 960, Tampa, FL, 336990.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428624CLMAmber Wheeler2008-03-05UHC-82210-35—638 Forest Ave, Mesa, AZ, 852500.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22311PRVElizabeth Stevens1993-01-09UHC-16032-76—5198 Union St, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-405825CLMEmma Hall1991-06-23UHC-83120-1679688745553419 Indian School Rd, Minneapolis, MN0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142778ENRSamantha Johnston1973-06-25UHC-14942-21—6942 Valley View Dr, Eden Prairie, MN0.52Two-digit birth yearState name converted to codeZIP missingEmail lower-cased+2 more
ENR-101492ENRSoifa Lewis1968-03-02UHC-63635-5896279272909224 Bayshore Dr, Mesa, AZ, 852140.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-136446ENRSophia A Nguen1979-10-14UHC-35591-59—1745 Highland Ave, Miami, FL, 331190.52Name re-casedTwo-digit birth yearPhone missing area codeEmail lower-cased+2 more
ENR-102927ENROlivia Hart1976-10-26UHC-78547-45—9622 Highland Ave, Houston, TX, 770170.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-120835ENRGabriel Hawkins1949-12-22UHC-32513-5286434193263579 Desert Sky Blvd, San Antonio, TX, 782170.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23255PRVOmar Thomas1983-02-04——3899 Union St Apt 32, Eden Prairie, MN, 553540.52Name split from “Last, First”Unit split from streetCity re-casedState name converted to code+2 more
ENR-110044ENREric U Banks1956-02-08UHC-92677-899595534496776 Central Ave, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-102513ENRJames E Montgomery1987-04-13UHC-66712-6576779096992804 Central Ave, Charlotte, NC, 282980.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-27949PRVBrittany M Watson1971-04-25——3073 Market St, Sacramento, CA, 958740.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-140129ENRJoan Hudson1956-12-10UHC-12759-1386222996448106 Ridge Rd Apt 6, Tempe, AZ, 852850.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-100508ENRAna Morales1955-09-19UHC-77060-0677841962741236 Valley View Dr, Scottsdale, AZ, 852470.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22485PRVJanice Diaz1987-06-13UHC-88057-73—2994 Indian School Rd, Chandler, AZ, 852670.52Name split from “Last, First”Two-digit birth yearCity re-casedState code upper-cased+2 more
ENR-123749ENRSantiago Martinez1959-06-09UHC-34421-47—225 Harbor Blvd, Minneapolis, MN0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-115549ENRSamantha V Romero1976-08-07UHC-70881-286645502381909 Lincoln Way Apt 33, Minneapolis, MN, 554470.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122296ENRGregory Woods—UHC-74086-9385441623562736 Oak St, San Diego, CA0.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137351ENRHarold B Sanders2006-04-26UHC-57938-526742296498498 Park Pl # 337, Sacramento, CA, 958130.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122916ENRHelen Wallace2006-03-25UHC-46407-62—8344 Mountain View Dr, Phoenix, AZ, 850290.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126755ENREvelyn Ramos—UHC-70497-0763956033258644 Elm St, Plano, TX0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26111PRVEJunk2000-05-06UHC-64732-9976794262347447 Central Ave, Miami, FL, 331710.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-109888ENRJuan Tran2007-06-20UHC-08444-394312024556354 Central Ave # 791, Plano, TX, 750470.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-101149ENRKayla M Chavez—UHC-09981-9935497272098478 Oak St Apt 10, Las Vegas, NV, 891980.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-410268CLMMike Evans2006-09-04——8354 Maple Ave Apt 7, Orlando, FL, 328560.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57264TPAJanet X Henderson1976-07-16—98430869937039 Mountain View Dr Apt 28, Houston, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-101975ENRAmy R Hawkins1994-05-13UHC-63576-0987031731426772 Hillcrest Rd Apt 11, Charlotte, NC, 282670.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-130316ENRKatherine H Rose—UHC-31860-41—2876 Oak St, Denver, CO, 802210.52Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+2 more
CLM-425675CLMBryan Ray1958-11-20UHC-15231-85—9671 Indian School Rd, Tucson, AZ, 857650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431574CLMCatherine Q Wright1952-12-03UHC-46069-48—4260 Lake View Rd, Jacksonville, FL, 322560.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431452CLMJose S Jensen1953-01-13UHC-42670-9642527441812719 Ocean Ave, Nashville, TN, 372600.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431453CLMJose S Jensen1953-01-13UHC-42670-9642527441812719 Ocean Ave, Nashville, TN, 372600.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114962ENRHeather Garza1983-04-15UHC-85505-9362794808197382 Baseline Rd, Phoenix, AZ, 850130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 191 of 2,000PreviousNext