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-28456PRVShirley Patel1990-11-08——8596 Mountain View Dr, Fresno, CA, 937400.82Date of birth reformattedState name converted to codePlaceholder values cleared
PRV-28806PRVAustin M Knight1938-02-20UHC-16690-6636999507708220 Oak St, Minneapolis, MN, 554000.82Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-28678PRVDiane Snyder1952-05-14—44664551082666 Spring St Apt 22, Austin, TX, 787380.82Phone reformattedUnit split from streetPlaceholder values cleared
PRV-24819PRVDebra Ray1978-06-08UHC-45020-1327137627265864 Sage Ct, Minneapolis, MN0.82Phone reformattedZIP missingPlaceholder values cleared
PRV-22037PRVRalph Taylor1985-07-21UHC-07187-68——0.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-27664PRVSara Gordon1942-10-07—35731694127925 Highland Ave, Tampa, FL, 336970.82Phone reformattedState name converted to codePlaceholder values cleared
PRV-24703PRVAaron T Simpson2005-05-22——659 Washington St, Miami, FL, 331750.82City re-casedZIP+4 trimmedPlaceholder values cleared
PRV-24688PRVSimmons H Austin1962-05-06UHC-84270-59—4773 Palm Dr, Denver, CO, 802180.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23842PRVTerry Bowman1984-02-01UHC-58664-75—3752 Lincoln Way, Glendale, AZ, 853720.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
PRV-22100PRVBradley H Weaver1986-04-15—5936633482—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-27191PRVJacob N Gonzales2003-01-01—31340280453611 Jefferson Ave, Dallas, TX, 752200.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28836PRVElijaah K Santiago—UHC-99665-89—5365 Hillcrest Rd, Fresno, CA, 937980.82Name re-casedDate of birth missingPlaceholder values cleared
PRV-22405PRVVirginia Freeman2005-02-19—79524876982185 Mountain View Dr, Minneapolis, MN, 554650.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-24628PRVTheresa Young1940-01-10——97 Broadway # 250, Sacramento, CA, 958430.82Unit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25016PRVJeremy Read1948-03-21UHC-59517-3434648006668795 Valley View Dr, Nashville, TN, 372370.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-25557PRVTheresa C Hamilton1978-07-17—2749990981412 Central Ave, Tampa, FL, 336020.82Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-26204PRVJose Chapman1947-03-16———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25963PRVSandra G Schmidt1954-01-18UHC-39593-67——0.82Date of birth reformattedPhone missing area codePlaceholder values cleared
PRV-21908PRVCheryl Campell1989-09-23—6574791634—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-25716PRVRobert Pena1996-09-07UHC-83450-576343820671—0.82Name split from “Last, First”Member ID reformattedPlaceholder values cleared
PRV-26915PRVJoseph Kim1952-01-04UHC-77559-61—1052 Jefferson Ave, San Antonio, TX, 782560.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-22016PRVNancy H Spencer2008-09-06UHC-62462-176803761098—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-27278PRVRaymond Valdez2006-08-24UHC-28229-937386494036816 Palm Dr, Orlando, FL, 328920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21795PRVJoyce Arnold1949-10-04—2872357849—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24110PRVDonna Foster1995-07-14—4476310906—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-27261PRVWilliam Rivera1971-03-13UHC-47674-885122810729—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-27260PRVWilliam Rivera1971-03-13UHC-47674-885122810729—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-28271PRVJesse Baker1985-01-05—3199329132—0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
PRV-25891PRVGloria L Reyes2001-05-09—46041294604288 Spring St, Orlando, FL, 328010.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20033PRVDiana Y Ramos—UHC-92145-596418418084—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
PRV-24663PRVLarry L Morales2002-09-18—62174769771782 Ridge Rd, Sacramento, CA, 958530.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-26894PRVMria L Stephens1986-09-24UHC-32216-3986176339111827 Canyon Rd, San Diego, CA, 921190.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-29380PRVKaren Rose1993-11-16UHC-41271-4587764868861976 Willow Ct, Las Vegas, NV, 891010.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-21285PRVWillie Boyd2004-10-16UHC-34280-1976262482542977 River Rd, Gilbert, AZ, 852610.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21701PRVTerry James1977-02-05—83329201717796 Camelback Rd, Mesa, AZ, 852730.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
PRV-23902PRVTyler X Dominguez1982-11-27——7545 Canyon Rd, Nashville, TN, 372390.82Name re-casedGender normalisedPlaceholder values cleared
PRV-29290PRVBrian D Rogers1948-09-13——3843 Mountain View Dr, Glendale, AZ, 853960.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28930PRVAnthony Johnston2005-11-28UHC-74682-652978502921713 Mountain View Dr, Fresno, CA, 937190.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
PRV-21460PRVTim Lopez1946-01-15UHC-58975-8151367266199308 Meadow Ln, Nashville, TN, 372710.82Phone reformattedStreet suffix standardisedAddress re-cased
PRV-23108PRVArthur Santos1960-11-09—3755721481—0.82Email lower-casedGender normalisedPlaceholder values cleared
PRV-29459PRVTeresa Woods1968-09-17—76545107284912 Hillcrest Rd, Chandler, AZ, 852210.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-25088PRVAlbert Schultz1939-12-06—91869306338850 Hillcrest Rd, Columbus, OH, 432190.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26840PRVPaul T Murphy1961-07-18—76276019544643 Main St, Tucson, AZ, 857470.82Phone reformattedState name converted to codePlaceholder values cleared
PRV-22979PRVMartha Wood1995-08-28UHC-81219-28——0.82Date of birth reformattedPhone missing area codePlaceholder values cleared
PRV-25000PRVJulia Carpenter—UHC-53528-158972660610997 Baseline Rd, Mesa, AZ, 852620.82Name re-casedDate of birth unreadablePlaceholder values cleared
PRV-21902PRVHeather I Rose1982-05-02UHC-34695-217957193104—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20307PRVJoseph Gilbert1946-07-21—3513213461—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-29311PRVCarlos Tucker1981-10-07UHC-87861-853334630761344 Elm St, Columbus, OH, 432940.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21422PRVArjun P Morrison1981-02-02UHC-53363-373414964629—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-26162PRVKenneth Gonzales1994-09-09UHC-22366-98—2617 Cedar Ln, Chandler, AZ, 852160.82State name converted to codeWhitespace trimmedPlaceholder values cleared
9,596 rows, page 145 of 192PreviousNext