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-141257ENRWei S Cooper1953-10-25UHC-84241-56—5751 River Rd, Chandler, AZ, 852610.54Date of birth reformattedPhone missing area codeState name converted to codeZIP+4 trimmed+1 more
TPA-63232TPAKatherine Q Stephens1973-12-22——7018 Valley View Dr, Mesa, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-107949ENRDebra Robertson1940-12-17UHC-69069-266143143770668 Union St, Atlanta, GA, 303960.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405048CLMTim Lopez1946-01-15UHC-58975-81—9308 Meadow Ln # 186, Nashville, TN, 372710.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
PRV-21399PRVDiego Ramirez1976-05-26UHC-23908-8470580866438373 Ridge Rd, Fresno, CA, 937340.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-103147ENRStephanie R Ruiz1962-03-01UHC-84863-70—8449 Ridge Rd Apt 39, Las Vegas, NV, 891320.54Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
CLM-421559CLMGreg S Luna1953-02-15UHC-66734-89—7307 Camelback Rd, Minneapolis, MN, 554950.54Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+1 more
CLM-430167CLMWillie Chavez1952-10-12—86558015752780 Desert Sky Blvd, Plano, TX, 750960.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55752TPAKathryn Moreno1988-12-02—55875992299188 Grand Ave, Columbus, OH, 432390.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-28817PRVCamila E Li—UHC-40969-55—4919 Harbor Blvd, Gilbert, AZ, 852580.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-119140ENRSharon Z Walsh—UHC-08844-8988681533599734 Union St, Tampa, FL, 336430.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-119253ENRBeverly U Collins1978-09-17UHC-66499-9631134394332916 Park Pl, Scottsdale, AZ, 852330.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-109998ENRMaira F Kim1984-10-06UHC-95297-6487031539537710 Desert Sky Blvd, Plano, TX, 750650.54Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
ENR-109997ENRMaira F Kim1984-10-06UHC-95297-6487031539537710 Desert Sky Blvd, Plano, TX, 750650.54Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
ENR-140577ENRChristian Morgan—UHC-72777-44—9000 Palm Dr, Tucson, AZ, 857220.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-109373ENRLogan Marshall1963-03-07——4254 Elm St, Tampa, FL, 336250.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-123182ENRAndrea Le1957-02-16UHC-70351-27—8785 Canyon Rd, Sacramento, CA, 958540.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25284PRVJack Carlson1985-10-14——4608 Main St, Nashville, TN, 372080.54Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-409143CLMMaria Castillo1949-05-11UHC-29981-057092147452696 Indian School Rd, Tucson, AZ, 857110.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-100466ENRAmber P Nguyen1974-02-06UHC-57730-0175630685366177 Mountain View Dr, Sacramento, CA, 958150.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425838CLMEvelyn Chavez2007-03-15UHC-98599-23—9644 River Rd, Nashville, TN, 372010.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-23313PRVKayla S Crter1970-04-24—40046545633471 Apache Blvd, Miami, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-414026CLMBruce Bradley1978-04-08UHC-17909-89—9096 Washington St, Glendale, AZ, 853820.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-104262ENROmar W Rios—UHC-69358-1937052217015383 Union St, Plano, TX, 750430.54Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+1 more
TPA-61677TPAJeremy O Boyd1997-12-10——9081 Lake View Rd, Miami, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-64103TPAFrances Williamson1960-12-08UHC-12909-32—3123 Mountain View Dr, Nashville, TN, 372780.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-126092ENRLawrence U Smith—UHC-22685-398889655008259 Central Ave, Orlando, FL, 328770.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414903CLMDoris Carroll1985-10-24UHC-14268-87—5143 Indian School Rd, Dallas, TX, 752950.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-129356ENRIsabella K Romero2004-05-20UHC-15177-6740736699819224 Apache Blvd, Minneapolis, MN, 554810.54Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-135495ENRAmenda G Singh1947-10-03UHC-34285-9439878673582132 Baseline Rd, Dallas, TX0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416503CLMJesse R Barnes1969-03-23UHC-14334-26—2923 Church St, Miami, FL, 331460.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-134605ENRElizabeth Turner1995-08-17UHC-28525-3449239849185112 Ridge Rd # 265, Minneapolis, MN, 554610.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
PRV-21684PRVEugene Foster1959-03-24—68568869846273 Central Ave, Sacramento, CA0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-422104CLMJeff Dominguez1962-05-18UHC-23167-87—6186 Baseline Rd, Sacramento, CA, 958510.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-127020ENRCarolyn Porter1995-04-15UHC-44477-87—5268 Church St, Seattle, WA, 981880.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-122440ENRCharlotte M Parker1975-03-14—42256685896182 Desert Sky Blvd, Scottsdale, AZ, 852100.54Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
ENR-129321ENRTimothy U Harris1961-04-21UHC-78926-706314706432533 Apache Blvd, Dallas, TX, 752900.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-137386ENRJoyce M Morgan1996-04-09UHC-80074-1426729829629043 Sunset Blvd, San Diego, CA, 921550.54Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+1 more
CLM-418575CLMKeith Hicks1951-08-22UHC-44307-53—6882 Oak St, Eden Prairie, MN0.54Name re-casedState name converted to codeZIP missingGender normalised+1 more
ENR-137430ENRAna Adams1981-09-15UHC-14475-86—3358 Palm Dr, Miami, FL, 331290.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-421768CLMPatricia Li1970-12-22UHC-70875-6328780809257272 Palm Dr, Las Vegas, NV, 891840.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402449CLMBetsy V Freeman1945-09-03——3288 Valley View Dr, Denver, CO, 802000.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404272CLMGary Welch1940-12-20UHC-29174-76—1042 Church St, Tampa, FL, 336210.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
PRV-20626PRVBobby Wilson1971-02-25—4152432213633 Meadow Ln, Miami, FL, 331170.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-115981ENRSantiago W Kelley1984-08-10UHC-71672-3158543945567157 Grand Ave, Denver, CO, 802050.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-58810TPAWillie Lynch1987-06-03——3720 Park Pl # 603, Glendale, AZ, 853800.54Name split from “Last, First”Unit split from streetCity re-casedGender normalised+1 more
ENR-129633ENRNancy Myers1979-02-15UHC-89328-398819443602667 Sunset Blvd, Nashville, TN, 372850.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-120020ENRAustin M Rogers2006-12-27UHC-78760-24—7879 Valley View Dr, Mesa, AZ, 852450.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-106214ENRAshley F Black1941-07-20UHC-62159-8220455105774377 Camelback Rd, Eden Prairie, MN, 553860.54Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-412062CLMEmily Schuultz1940-12-09——8124 Park Pl, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
100,000 rows, page 204 of 2,000PreviousNext