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-27967PRVMarilyn Sullivn1952-05-20—27485195085246 Desert Sky Blvd, Miami, FL0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
PRV-25144PRVPaul I Woods2007-09-24——8824 Spring St, Scottsdale, AZ, 852960.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21477PRVJonathan Bell1988-02-22UHC-75396-89—4740 Forest Ave, Sacramento, CA, 958960.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-28152PRVChristine Y Edwards1955-04-20UHC-05546-4477462157895729 Elm St, Plano, TX, 750810.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26961PRVLary Cox—UHC-25922-9595537066584973 Grand Ave, Tampa, FL, 336190.66Name split from “Last, First”Date of birth missingPhone reformattedWhitespace trimmed+1 more
PRV-29043PRVValentina Reid1965-04-06UHC-92970-85—6406 Camelback Rd, Nashville, TN, 372670.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-27840PRVJoe Payne1996-08-03——6313 Central Ave, Scottsdale, AZ, 852210.66State name converted to codeZIP+4 trimmedEmail lower-casedWhitespace trimmed+1 more
PRV-28575PRVCamila Hunter1984-09-23——8591 Lincoln Way, San Diego, CA, 921100.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-23471PRVJosh Sanders1952-06-07—47382581789202 Hillcrest Rd, Tempe, AZ, 852170.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-29136PRVAshley Diaz1976-12-18UHC-49500-4879670960696737 Oak St, Minneapolis, MN0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
PRV-25142PRVJanice Fernandez1979-03-16—58791274415641 Mountain View Dr, Minneapolis, MN, 554000.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28529PRVSofia Fuller1945-03-08—43869257508946 Camelback Rd, Sacramento, CA, 958960.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24219PRVChristiian Ortega1989-10-28UHC-60388-1836836197804157 Desert Sky Blvd, Tempe, AZ, 852540.66Date of birth reformattedPhone reformattedSSN last four extractedGender normalised+1 more
PRV-24275PRVCarl Torres2000-05-16——8732 Lake View Rd, Glendale, AZ, 853420.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-26217PRVDavid G Butler—UHC-58798-148576147972—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-23534PRVNatalie B Medina1987-05-27—51578065126608 Maple Ave Apt 6, Charlotte, NC, 282620.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
PRV-28164PRVNick West1984-01-12UHC-15259-4523950187155521 Grand Ave, Fresno, CA, 937760.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-21306PRVSofia Luna1995-01-17UHC-09907-3051959377704207 Cedar Ln, Dallas, TX, 752490.66Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+1 more
PRV-27825PRVAdam T Singh1948-02-03———0.66Middle initial moved out of first nameTwo-digit birth yearEmail lower-casedWhitespace trimmed+1 more
PRV-26079PRVTerry Ford1994-10-01—7027235915—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-20505PRVAmy Castillo1959-02-15UHC-48609-92—3513 Lincoln Way, Scottsdale, AZ0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-26730PRVJoe Z Obrien1938-06-20—2615953563832 Oak St, Jacksonville, FL, 322880.66Middle initial moved out of first nameName re-casedPhone reformattedZIP+4 trimmed+1 more
PRV-21928PRVJoyce Hicks1968-07-04UHC-10074-5545787247205364 Union St, Miami, FL, 331920.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-28098PRVHiroshi A Moore1950-09-08—3349456011952 Union St, Glendale, AZ, 853880.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27425PRVMartha Watson1976-12-23UHC-66588-7969665179276159 Union St, Eden Prairie, MN, 553650.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
PRV-27587PRVEugene Freeman1961-12-23—85438374395162 Lincoln Way, Scottsdale, AZ, 852510.66Name split from “Last, First”City re-casedState code upper-casedGender normalised+1 more
PRV-25944PRVDorothy Weaver1941-10-26UHC-95535-783279370475916 Jefferson Ave, Seattle, WA, 981850.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-23046PRVJsesica Y Matthews1962-01-06—7459959603938 Park Pl, Chandler, AZ, 852060.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23805PRVJannet Gray2003-04-10——1374 Spring St, Glendale, AZ, 853780.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
PRV-26884PRVJoyce Clark1949-01-21UHC-03973-6327489272019737 Sunset Blvd, Columbus, OH, 432790.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-27187PRVSteven Campbell1987-11-27—72571928354595 Union St # 609, Plano, TX, 750990.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-29157PRVAngela Murray1987-06-24UHC-29472-0344871602066807 Cedar Ln, Austin, TX, 787880.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-23571PRVDeborah Gilbert1966-05-12——5353 Church St, Minneapolis, MN0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
PRV-28589PRVBenjamin G Wright1974-05-17UHC-86998-3632665844779599 Ocean Ave, Orlando, FL, 328240.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-22816PRVAisha Baker1944-03-19UHC-54571-0522580310795994 Indian School Rd, Charlotte, NC, 282100.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29074PRVBrittany W Taylor1941-05-07—94032991573835 Ridge Rd, Tempe, AZ, 852980.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-22178PRVJordan Harris1951-12-25UHC-98759-35—1233 Forest Ave, Las Vegas, NV, 891200.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-24280PRVJoshua Ford1972-09-26UHC-98156-2447743646197167 Camelback Rd, Tampa, FL, 336410.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26892PRVAmber Lawrence1978-04-18UHC-53728-1180848880381461 Bayshore Dr, Fresno, CA, 937940.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
PRV-24207PRVAnna D Park1983-12-27UHC-82241-54290626719568 Broadway, San Diego, CA0.66Middle initial moved out of first namePhone reformattedMember ID reformattedZIP missing+1 more
PRV-24746PRVPatrick Fisher——7773295953—0.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
PRV-28691PRVCharles McDonald—UHC-75613-83——0.66Name split from “Last, First”Date of birth unreadableMember ID reformattedWhitespace trimmed+1 more
PRV-22852PRVAisha Sttewart1943-12-10—65238572712865 Apache Blvd, Chandler, AZ, 852910.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22512PRVMadison Patel2000-01-10UHC-54352-4484573459644495 Union St, Glendale, AZ, 853900.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28227PRVRachel Yang1945-11-12—38173674962921 Palm Dr, Denver, CO, 802430.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26743PRVTyler Davis1980-07-28—36128902573924 Bayshore Dr, Nashville, TN, 372670.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-23122PRVJosh Payne1946-12-20——8870 Main St, Denver, CO, 802850.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
PRV-20287PRVKelly Carlson1957-04-27—49599569842153 Canyon Rd, Nashville, TN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-26350PRVNathan Martinez1944-04-01—94944439562561 Bayshore Dr, Nashville, TN, 372070.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27888PRVLori R Guzman—UHC-40801-2192497165068493 Washington St, San Diego, CA, 921220.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
9,596 rows, page 58 of 192PreviousNext