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-25171PRVRaymond Fox2000-10-21—34661704087089 Mesa Dr, Eden Prairie, MN, 553060.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29586PRVMason Pyane1979-11-17UHC-28896-1432383535515013 Forest Ave, Atlanta, GA, 303850.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28350PRVMichael Bailey1962-12-12—45824180693103 Lake View Rd, San Diego, CA, 921460.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21442PRVSantago Ross1972-09-08—24487778653583 Hillcrest Rd, Phoenix, AZ, 850040.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28473PRVNicholas O King1992-05-02UHC-48082-65—2780 Oak St, San Antonio, TX, 782310.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-22607PRVSantiago S Moore1962-07-03UHC-27250-83—7197 Indian School Rd, Glendale, AZ, 853710.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20424PRVArjun Gardner1987-08-28—48783034677270 Bayshore Dr, Denver, CO, 802860.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-20425PRVArjun Gardner1987-08-28—48783034677270 Bayshore Dr, Denver, CO, 802860.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-24974PRVNancy W Hansen1975-08-24—58740524858671 Harbor Blvd, Charlotte, NC, 282820.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22551PRVStephen Munoz1971-04-11—58385561764303 Maple Ave, Scottsdale, AZ, 852800.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-22436PRVWatson V Andrea1950-09-10UHC-73165-7573757953048190 Apache Blvd, Plano, TX, 750290.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20068PRVDiane Lucas1950-03-12—98099461343522 Jefferson Ave, Tampa, FL, 336370.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-28596PRVBobby Wilson1994-01-12—2094822436—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-21849PRVMason Wagner1962-08-16—91431820551593 Church St, San Antonio, TX, 782150.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
PRV-26772PRVSteven McDonald2000-11-28UHC-80624-6635194822631739 Canyon Rd, San Diego, CA, 921880.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24266PRVDiana Mendez1997-04-20—3518197282—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22648PRVCheryl Dunn1987-12-14UHC-78434-31—6313 Highland Ave, Eden Prairie, MN, 553630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24909PRVNoah C Santiago1979-07-05UHC-16502-2046172397267426 Baseline Rd, Los Angeles, CA, 900370.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28841PRVNicholas Bishop2008-12-10——7846 Washington St, Scottsdale, AZ, 852810.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25936PRVChristina S Butler1945-03-13UHC-65441-353592576327—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24911PRVChristine Stewart1946-01-03—6954879216412 Palm Dr Apt 12, Austin, TX, 787280.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-23248PRVBetty Wood1950-04-12UHC-68387-0455898067357551 Lincoln Way, Seattle, WA, 981760.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
PRV-27599PRVDiego C Snyder1944-01-08UHC-57459-8239893418772917 Washington St, Seattle, WA, 981010.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21325PRVKyle Williamson1988-10-24—94939350645641 Meadow Ln, Gilbert, AZ, 852260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22965PRVNathan Cunningham1952-05-27—9847883848789 Apache Blvd, Tempe, AZ, 852700.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22163PRVBradley Sims1941-06-23—69720657525562 Apache Blvd, Mesa, AZ0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-26499PRVAlan Pery1958-11-22UHC-67699-5424373544745216 Desert Sky Blvd, Austin, TX, 787390.80Phone reformattedState code upper-casedGender normalisedPlaceholder values cleared
PRV-20397PRVThomas J Griffin1986-12-03—82494205723794 Mountain View Dr, Charlotte, NC, 282470.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23345PRVAmanda Allen1954-10-20UHC-89738-8447790354264736 Lake View Rd, San Diego, CA, 921960.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-24904PRVAlexander Perkins1959-03-26—716433639526 Camelback Rd, Plano, TX, 750580.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-23404PRVZachary Simpson1964-12-08—76487699805711 Church St, Miami, FL, 331830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
PRV-24323PRVEmma K Brooks1972-05-01UHC-09562-952039757599453 Canyon Rd, Sacramento, CA0.80Phone reformattedMember ID reformattedZIP missingPlaceholder values cleared
PRV-26006PRVArjun Stone1987-03-17—6575655180—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-29361PRVFreeman Albert1997-04-04—98072180474258 Palm Dr, Chandler, AZ, 852670.80Name re-casedDate of birth reformattedPhone reformattedState name converted to code
PRV-21286PRVNicole Smith1957-12-16——7305 Canyon Rd, Mesa, AZ, 852260.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26501PRVSean Tucker1942-02-27—67698742104803 Canyon Rd, Minneapolis, MN, 554330.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21542PRVAlbert Li1973-10-24—96390724351364 Park Pl, Charlotte, NC, 282640.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-22190PRVGreg Phillips1981-07-05——7908 Forest Ave, Atlanta, GA0.80Date of birth reformattedZIP missingEmail lower-casedPlaceholder values cleared
PRV-27905PRVAndrea Harper1989-01-06UHC-76420-19—8990 Spring St, Fresno, CA, 937710.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-23055PRVTyler Russell1958-12-09UHC-38785-33—596 Hillcrest Rd, Orlando, FL, 328660.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-25791PRVCamila Castro2003-05-15——5948 Pine Dr, Los Angeles, CA, 900580.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26682PRVMateo Mason1979-12-10—61647812908867 Forest Ave, Miami, FL, 331540.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
PRV-24330PRVWillie McCoy1994-10-23UHC-22083-44—1428 Cedar Ln, Fresno, CA, 937810.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26905PRVCarolyn J Martin——42827904625919 Church St, Plano, TX, 750080.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
PRV-22157PRVCarl Taylor1939-12-17—61192788128064 Broadway, San Antonio, TX, 782040.80Phone reformattedState code upper-casedGender normalisedPlaceholder values cleared
PRV-27428PRVEthan S Sims1969-05-08UHC-64045-2661393807396288 Elm St, Plano, TX, 750050.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-23271PRVRoy F Watkins1955-04-27UHC-25431-61——0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-23270PRVRoy F Watkins1955-04-27UHC-25431-61——0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26888PRVAna Foster1989-09-08—32761683094119 Union St, Tempe, AZ, 852880.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-23995PRVJohn Greene1940-07-18—76641180507982 Mesa Dr, Eden Prairie, MN, 553700.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
9,596 rows, page 130 of 192PreviousNext