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

Provider network, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-23598PRVRuth Z Contreras1978-05-04UHC-90999-03——0.68Middle initial moved out of first namePhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-26704PRVEric Bell1993-10-26—54894204108680 Canyon Rd, Miami, FL, 331890.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-22603PRVRandy Hernandez1980-10-19—84685466485165 Grand Ave # 565, Denver, CO, 802430.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26576PRVRoger Peters1968-05-09—96366200567864 Lincoln Way, Scottsdale, AZ, 852720.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26483PRVGrace T Taylor1987-06-25——6983 Apache Blvd, Charlotte, NC, 282280.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27966PRVPriya Coleman1979-02-22UHC-29997-8333171277388189 Canyon Rd, Phoenix, AZ, 850270.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
PRV-29581PRVJuan Morales1995-06-09UHC-08643-2786883347278572 Valley View Dr, Gilbert, AZ, 852530.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-20450PRVJanice Rice1938-12-26UHC-09502-63—8888 Palm Dr, Tucson, AZ0.68City re-casedState name converted to codeZIP missingPlaceholder values cleared
PRV-27978PRVIsabella Patel2001-11-25UHC-65359-8684265315719684 Ocean Ave, Fresno, CA, 937410.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-22086PRVPamela Mitchell1997-11-08UHC-76970-81—5418 River Rd, Phoenix, AZ, 850730.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29175PRVDeennis E Nelson1961-03-27UHC-29756-86—4709 Ridge Rd, Tampa, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-21215PRVRandy Q Snyder1989-06-16—4318186468398 Broadway, San Antonio, TX, 782130.68Name split from “Last, First”Middle initial moved out of first namePhone reformattedPlaceholder values cleared
PRV-21407PRVScott X Stevens1994-01-08UHC-77093-82—4455 Main St, Austin, TX, 787230.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-27945PRVBryan Castro1947-12-01—68559914843934 Central Ave, Dallas, TX, 752000.68Two-digit birth yearPhone reformattedState name converted to codePlaceholder values cleared
PRV-27704PRVHiroshi Garza2005-11-05UHC-77416-3680657863613626 Indian School Rd, Plano, TX, 750180.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27257PRVKaren Fihser1951-08-16UHC-86096-6029046360586730 Baseline Rd # 505, Houston, TX, 770920.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21005PRVPriya Larson1975-12-13UHC-56071-01—9198 Pine Dr, Nashville, TN, 372320.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-26103PRVWillie Yang1983-02-18—73847185513924 Jefferson Ave, Miami, FL, 331370.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-25519PRVRuth Weber1940-05-24UHC-58634-65—9877 Market St, Glendale, AZ, 853340.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26684PRVJudith Simmons1980-07-16——8104 Maple Ave, Fresno, CA, 937280.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-23333PRVSantiago Miller——9432530574—0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-28946PRVWei V Rojas1959-03-01—44745361789644 Apache Blvd, Glendale, AZ, 853940.68Name split from “Last, First”Two-digit birth yearEmail lower-casedPlaceholder values cleared
PRV-24181PRVSophia G Vargas1962-06-05UHC-93377-20—8577 Apache Blvd, Houston, TX, 770120.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-24099PRVIsabella N Lynch1998-01-28UHC-07898-247183223704630 Church St, Phoenix, AZ, 850990.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
PRV-23751PRVLuis Harper1954-02-19UHC-25060-782319227326—0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
PRV-22028PRVKelly Laura1957-02-22—57288150579767 Broadway, Minneapolis, MN, 554770.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-23312PRVLinda Smith1989-09-17UHC-68199-2089094506786905 Hillcrest Rd, Tempe, AZ, 852220.68Phone reformattedSSN last four extractedGender normalisedPlaceholder values cleared
PRV-27707PRVRichard Espinoza1957-05-16—51633962412683 Mesa Dr, Seattle, WA, 981610.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-21293PRVDeborah Munoz1989-05-06UHC-29058-6968295363615131 Apache Blvd, Gilbert, AZ, 852650.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
PRV-23081PRVWayne F Harper1947-08-10UHC-60257-7533894022276090 Church St, Columbus, OH0.68Name split from “Last, First”Phone reformattedZIP missingPlaceholder values cleared
PRV-29376PRVWei Rogers1991-09-25UHC-97411-9177423782589562 Elm St, Orlando, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-27719PRVLisa I Wood1938-11-08UHC-20238-5895183196637709 Meadow Ln, Glendale, AZ, 853690.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
PRV-29368PRVNathan Heernandez1998-09-28—6626810799—0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26677PRVDylan R Ramos1961-07-22——1058 Sunset Blvd, Atlanta, GA, 303360.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-22891PRVKeith Day1998-05-16UHC-81898-7122532579166826 Sunset Blvd, San Antonio, TX, 782320.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-27584PRVBetsy Walker1958-11-19—44631391908507 Harbor Blvd, Denver, CO, 802600.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
PRV-29236PRVAndrea Silva1968-07-26UHC-17651-5163943690445701 Forest Ave Apt 6, San Diego, CA, 921260.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23246PRVIsabella Jimenez1993-02-04UHC-62078-4037362678136914 Mesa Dr, Minneapolis, MN, 554700.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
PRV-21612PRVGabriel P Salazar1943-02-04—2378144343—0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22523PRVJohn Reyes2004-01-07—30648739751791 Elm St, Tempe, AZ, 852530.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-26368PRVSantiago Washington1994-08-02—36455202746554 Ocean Ave, Charlotte, NC, 282280.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26377PRV—Junk2003-11-26——1900 Ocean Ave, Charlotte, NC, 282510.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
PRV-29271PRVKevin Washington—UHC-24205-7849677257397626 Ridge Rd, Plano, TX, 750460.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-27324PRVChristopher Gray2000-08-20UHC-48386-23—6500 Elm St, Minneapolis, MN, 554110.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
PRV-20840PRVWillie Williamson1980-02-11UHC-87207-77—7994 Canyon Rd, San Antonio, TX, 782390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24574PRVRebecca Hart1962-03-15—44428933042012 Jefferson Ave, Dallas, TX, 752840.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-26887PRVAaron Aguilar1987-05-12UHC-55513-5042587068488520 Meadow Ln # 185, Austin, TX, 787980.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25818PRVDavid Hoffman1974-11-01UHC-56897-7876861785139643 Camelback Rd Apt 33, Nashville, TN, 372980.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29353PRVLauren Miller1991-09-18——1142 River Rd, Denver, CO, 802810.68Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed
PRV-24437PRVRalph Oliver1995-03-26——1949 Spring St, Los Angeles, CA, 900610.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
9,596 rows, page 74 of 192PreviousNext