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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-29314PRVRandy Ross1940-01-07—3174487162728 Spring St, Orlando, FL, 328930.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23613PRVLaura Watkins1995-07-08—22673147369483 Elm St, Tucson, AZ, 857100.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23163PRVMaria A Vazquez1980-02-04—24783647738005 Mountain View Dr, Plano, TX, 750210.80Middle initial moved out of first namePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26474PRVDonald Griffin1954-05-14—33727609073360 Mountain View Dr, Austin, TX, 787040.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20894PRVMarcus Fields1996-03-03—61330795378621 Oak St, Nashville, TN, 372410.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-24722PRVAmy Moore1986-01-20—90955990009505 Willow Ct, Plano, TX, 750170.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28300PRVBrittany Moore1952-10-22—67726506942008 Park Pl, Atlanta, GA, 303230.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-22690PRVJosaph Lewis1946-01-13UHC-59337-9242627868966639 Mountain View Dr, Gilbert, AZ, 852440.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-29254PRVNatalie Bennett1992-11-25—9619633546517 River Rd, Houston, TX, 770630.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-29255PRVNatalie Bennett1992-11-25—9619633546517 River Rd, Houston, TX, 770630.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27891PRVJoe C Harvey1970-03-07UHC-23152-2060540236987400 Spring St, Orlando, FL, 328900.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25625PRVKevin Wheeler1946-04-21UHC-17930-1884291926116231 Broadway, Plano, TX, 750220.80Two-digit birth yearAddress re-casedCity re-casedPlaceholder values cleared
PRV-21351PRVBruce Jensen1946-11-15—35438153792311 Lincoln Way, Chandler, AZ, 852100.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20086PRVPeter C Garrett1981-03-11UHC-70030-7933278542448443 Oak St # 940, Fresno, CA, 937830.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-26467PRVBeverly Z Vasquez1980-01-13—27840636493211 Meadow Ln Apt 35, Denver, CO, 802160.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-22421PRVElizabeth F Lane1943-05-04—24451857489077 Hillcrest Rd, Columbus, OH, 432240.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-28324PRVScott Kelley1995-07-25UHC-50527-9070959049129189 Canyon Rd, Seattle, WA, 981000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26455PRVEthan Jackson1954-04-10—5583013069801 Main St Apt 28, San Antonio, TX, 782690.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-24442PRVGrce Jenkins1998-10-08—62447334194259 Sage Ct, Tampa, FL, 336080.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-21890PRVMarcus J Delgado1990-12-17UHC-19436-2390092399632234 Camelback Rd, Glendale, AZ, 853750.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-20018PRVWayne Hamilton1947-06-25—60658913374635 Forest Ave, Tucson, AZ, 857030.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-26852PRVRachel K Garza1951-02-09UHC-60032-5423632835874470 Park Pl, Fresno, CA, 937320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20357PRVLogan Sims1982-02-26——539 Meadow Ln, Houston, TX, 770060.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27648PRVGracce Wong1975-10-21——6636 Market St, Sacramento, CA, 958060.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-20778PRVThompson Robert1976-07-17UHC-19770-53—6258 Camelback Rd # 108, Houston, TX, 770220.80Name re-casedDate of birth reformattedUnit split from streetEmail lower-cased
PRV-28779PRVKyle Powell1962-10-08—5249192176—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22402PRVEmma Dunn1944-10-28UHC-06624-8751160194611261 Highland Ave, Denver, CO, 802720.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-20044PRVSusan Guzman1959-04-03UHC-20174-31—4331 Canyon Rd, Mesa, AZ, 852870.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29171PRVKyle Cook2001-09-07UHC-25023-44—9327 Broadway, Scottsdale, AZ, 852410.80Address re-casedZIP+4 trimmedEmail lower-casedPlaceholder values cleared
PRV-22165PRVJoyce Thompson——78289465262819 Pine Dr, Fresno, CA, 937210.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-27612PRVRuth Moreno1977-10-01—34250381458783 Mesa Dr, Dallas, TX, 752310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22082PRVCharlotte K Coleman1994-05-05—70357616224598 Baseline Rd # 227, Nashville, TN, 372210.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25330PRVJean Bell1964-07-22—27471964569449 Ocean Ave, Houston, TX, 770470.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28581PRVAustin U Jensen1945-08-06—38050631476006 Church St, San Diego, CA, 921790.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22013PRVCarol Ross1954-12-21—87125573311098 Desert Sky Blvd, Tampa, FL, 336230.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-27753PRVCheryl H Perz1963-04-01———0.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-23302PRVAlice Simpson2004-09-19UHC-94887-78—2454 Spring St, Sacramento, CA, 958250.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27935PRVAdam Mendoza1956-02-27UHC-49778-068238225670—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-27954PRVJanet Fernanndez1989-04-14——8060 Ridge Rd, San Diego, CA, 921890.80Name split from “Last, First”City re-casedEmail lower-casedPlaceholder values cleared
PRV-25798PRVTeresa Wallace1965-10-17UHC-19584-987375253255131 Baseline Rd, Tampa, FL, 336840.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25683PRVAustin Murray1944-07-18——6579 Washington St, Austin, TX, 787600.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-25942PRVDoris O Sims1942-11-10UHC-56700-5987683451725650 Valley View Dr, Plano, TX, 750970.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
PRV-27580PRVAbby Grant1953-02-13UHC-92965-8322282811127908 Hillcrest Rd, Tempe, AZ, 852530.80Phone reformattedMember ID reformattedState name converted to codePlaceholder values cleared
PRV-28950PRVWillie Sims1959-05-14UHC-08712-3138354952393094 Hillcrest Rd, Plano, TX, 750320.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23301PRVVictoria N Medina1977-12-21UHC-01237-8278187636302066 Cedar Ln, Dallas, TX, 752300.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27958PRVLisa Graham1956-08-06—2669411647—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20089PRVRebecca F Little1941-01-15UHC-55146-08—7903 Desert Sky Blvd, Austin, TX, 787220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20532PRVWalter Weng1947-09-13—77195838825093 Grand Ave, Plano, TX, 750900.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25247PRVGeorge Perez1969-01-24UHC-59062-5094692268738873 Indian School Rd, Las Vegas, NV, 891900.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
PRV-25912PRVCynthia Jimenez1989-07-14UHC-68580-40—7864 Market St, Columbus, OH, 432220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 131 of 192PreviousNext