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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52347TPASantiago Gardner1988-07-05UHC-96725-826222516731628 Oak St, San Antonio, TX, 782170.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54268TPAPriya Roberts——57553886317499 Market St, Las Vegas, NV, 891010.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50373TPABryan Turner1951-09-08——1071 Baseline Rd, Houston, TX, 770490.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-53994TPAJoseph Lewis1946-01-13——2854 Camelback Rd, Las Vegas, NV, 891710.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64312TPAChristina Cooer1958-05-08——6821 Sage Ct, Miami, FL, 331790.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55941TPAScott Fuller1965-02-05—80767275367273 Mountain View Dr # 675, Miami, FL, 331150.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-64069TPATimothy Gonzales1991-10-25—24685417646157 Market St, Houston, TX, 770650.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
TPA-52507TPAJonathan Foster1953-09-06——7387 Lake View Rd Apt 37, Charlotte, NC, 282840.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64340TPAJdy Chen1980-06-18—73523803717401 Desert Sky Blvd, Fresno, CA, 937900.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53473TPATyler Long1981-04-15—4175177821277 Jefferson Ave, Dallas, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55250TPAOlivia Anderson1990-05-17——4847 Bayshore Dr, Tucson, AZ, 857600.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-55967TPALinda I Wang1979-05-24——528 Sage Ct, Seattle, WA, 981170.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57898TPAThomas Hamilton1948-05-17UHC-56407-3188887821863220 Bayshore Dr # 433, Eden Prairie, MN, 553230.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58797TPAMateo O Hansen1996-01-23UHC-39094-52—1668 Jefferson Ave, Chandler, AZ, 852430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55453TPAMei W Lee1996-04-03——850 Pine Dr, Atlanta, GA, 303970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55718TPAJean Graham1961-08-15—20567616811653 Ridge Rd, Tampa, FL, 336580.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53964TPADanielle Ward2003-09-25——8315 Central Ave, Scottsdale, AZ, 852620.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58302TPACamila Tran1958-03-13UHC-16446-89—1343 Forest Ave # 446, Phoenix, AZ, 850320.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58303TPACamila Tran1958-03-13UHC-16446-89—1343 Forest Ave # 446, Phoenix, AZ, 850320.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58776TPALisa Harrison1983-07-19——2224 Ocean Ave, Minneapolis, MN, 554310.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52040TPAMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ, 852480.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58732TPAEmma Dean1989-04-24—92858279001260 Ocean Ave, Orlando, FL, 328270.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-61238TPAMariana Patel1956-02-11——2743 Apache Blvd, Gilbert, AZ, 852300.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-57409TPAPeter Gray1985-08-23——876 Spring St, Los Angeles, CA, 900150.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-52826TPAWei E Nelson1998-12-11——139 Main St, Minneapolis, MN, 554880.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57660TPASofia Garcia1962-08-12—47399826099463 Meadow Ln # 100, Jacksonville, FL, 322160.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-62582TPAJack James1957-03-03——1297 Maple Ave, Tampa, FL, 336620.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58141TPAJustin X Schultz1985-08-09——6556 Mountain View Dr, Glendale, AZ0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
TPA-61592TPAWiill Price1983-07-02——1117 Oak St, Scottsdale, AZ, 852230.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55649TPARyan Grant1989-09-27UHC-15044-3674043630406174 Valley View Dr, Tucson, AZ, 857080.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55648TPARyan Grant1989-09-27UHC-15044-3674043630406174 Valley View Dr, Tucson, AZ, 857080.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58205TPAChuck James1985-01-01UHC-80457-27—6831 Desert Sky Blvd, Miami, FL, 331070.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-62424TPAElijah Spencer1968-05-13——3963 Forest Ave Apt 35, Sacramento, CA, 958920.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-62425TPAElijah Spencer1968-05-13——3963 Forest Ave Apt 35, Sacramento, CA, 958920.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-53436TPABradley Jacobs1974-02-03UHC-08105-3540142313192621 River Rd Apt 39, Gilbert, AZ, 852090.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-59524TPAPamela Q Grant1949-06-15——6343 Maple Ave, Denver, CO, 802350.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-57245TPAAndrew T Griffin1956-09-07——644 Palm Dr, Atlanta, GA, 303880.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-62955TPADonald Banks1971-06-13—47423550705222 Camelback Rd, Austin, TX, 787300.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59151TPAJacqueline Vargas1983-07-26—22749800119060 Mesa Dr, Houston, TX, 770820.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59447TPARalph Armstrong1981-07-21——8223 Pine Dr, Los Angeles, CA, 900770.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54495TPAMichael Evans2006-09-04——2201 Elm St, Nashville, TN, 372450.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52581TPABarbara Wallace1984-12-25——3506 Willow Ct, Phoenix, AZ, 850810.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59198TPADenise Lucas1997-06-10——1042 Sunset Blvd, Tampa, FL, 336070.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-59242TPAHenry L Estrada1981-06-09UHC-01815-4524042122677816 Willow Ct, Phoenix, AZ, 850990.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57212TPANicholas Sullivan2004-02-02——6528 River Rd, Scottsdale, AZ, 852590.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50933TPAGary Munoz1965-10-25—73760188158538 Ocean Ave, Nashville, TN, 372250.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
TPA-51217TPAMaria Clark1994-08-10——6838 Central Ave, Tempe, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-59318TPAJesse Davis1944-02-15—24251606627335 Canyon Rd, Scottsdale, AZ, 852480.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61881TPAGregory Lawson1948-12-27——2487 Jefferson Ave, Phoenix, AZ, 850230.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63614TPARyan Martinez1951-06-25——7459 Main St, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
14,474 rows, page 79 of 290PreviousNext