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-25165PRVMaria Baker1972-02-28—65090383825242 Hillcrest Rd, Nashville, TN, 372620.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29104PRVJulia Chavvez1958-02-19UHC-90166-6068354036046840 Willow Ct, Atlanta, GA, 303000.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25333PRVLuis Sandoval1971-07-04UHC-78529-4569442290686877 Mountain View Dr, Jacksonville, FL, 322340.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21909PRVLuis Reed1944-04-24UHC-97310-5024230774893980 Meadow Ln, Orlando, FL, 328210.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21880PRVJean Davis1979-12-02—71238289774831 Highland Ave # 411, Nashville, TN, 372030.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26003PRVKeith I Gordon1965-09-11—39362931229536 Lake View Rd Apt 38, Dallas, TX, 752400.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-21785PRVLuis Porter2006-06-17—66585785712013 Lake View Rd, Jacksonville, FL0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20070PRVHenry Brown1998-08-21UHC-21741-3770439689163158 Indian School Rd # 376, Miami, FL, 331780.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-28273PRVAlexander Patel1985-09-23—44355633495375 Sunset Blvd Apt 40, Plano, TX0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-23539PRVRalph K Guerrero1991-04-08—89159892263786 Palm Dr, Plano, TX, 750100.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
PRV-20111PRVShirley Watson1997-06-09—73325866507724 Canyon Rd, Minneapolis, MN, 554990.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20512PRVKing Carl1958-02-06UHC-56378-0126334047446441 Mesa Dr, Houston, TX, 770500.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24637PRV—Junk1969-06-02UHC-33144-5280665663651367 Mountain View Dr Apt 31, Glendale, AZ, 853400.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-28265PRVRebecca Campbell1938-06-11—58777509287151 Church St, Austin, TX, 787760.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-21278PRVRussell D Davis1962-06-08——1029 Spring St, Columbus, OH0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-24613PRVAisha G Anderson1978-10-20UHC-70821-83—2830 Indian School Rd, Plano, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21295PRVJose Jackson1981-11-23—75865410922459 Ridge Rd # 269, Dallas, TX, 752440.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-20799PRVHiroshi S Richards1983-02-20UHC-72946-1858323471047384 Valley View Dr # 899, Glendale, AZ, 853530.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-24832PRVLuis B Simmons2003-04-13UHC-91105-4791671539489389 Sunset Blvd, Scottsdale, AZ0.48Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
PRV-25665PRVBradley J Reyes1949-11-12UHC-33181-94—7930 Harbor Blvd # 578, Glendale, AZ, 853300.48Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more
PRV-23100PRVGregory Hudson1954-02-04—53563688208058 Main St, Nashville, TN, 372620.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21297PRVHeather O Griffin1987-08-11——8521 Palm Dr, Jacksonville, FL, 322780.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-23763PRVSean Holmes2003-08-13UHC-34874-0930738459417645 Apache Blvd, Dallas, TX, 752100.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
PRV-22021PRVVirginia N Carr1959-09-19UHC-61614-4032544514529085 Church St, Dallas, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22939PRVSean Vasquez1953-03-25UHC-70165-8843392404635831 Palm Dr, Austin, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26637PRVStephen Murphy2002-07-19—27147756405656 Central Ave, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24074PRVDavid I Hernandez1987-06-28UHC-79977-02—8201 Camelback Rd, Orlando, FL0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-24075PRVDavid I Hernandez1987-06-28UHC-79977-02—8201 Camelback Rd, Orlando, FL0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-21575PRVBenjamin Olson2003-05-25UHC-22547-3453665301157725 Palm Dr # 418, Las Vegas, NV, 891950.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-22554PRVJacqueline Baker1945-11-08——6071 Palm Dr, Atlanta, GA, 303600.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
PRV-21690PRVAdam Wright1944-07-04—29086743947199 Sunset Blvd, Gilbert, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-20577PRVEmma L Maldonado1941-04-20UHC-15232-8956597164063063 Desert Sky Blvd, Gilbert, AZ, 852210.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more
PRV-24679PRVFatima Moreno1957-07-16UHC-24101-2575822916477442 Oak St Apt 36, Denver, CO, 802540.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26627PRVAmandaJunk1938-02-27—9336832337879 Sunset Blvd, Houston, TX, 770270.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23343PRVKeith Wells1992-08-05—24066088588900 Pine Dr, Dallas, TX, 752200.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-29147PRVLucia Lawon1953-07-15—81287316824690 Highland Ave, Las Vegas, NV, 891780.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20371PRVVictoria Hawkins1977-02-12—78767965391995 Spring St # 774, Las Vegas, NV, 891550.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-23116PRVLucia F Edwards1970-06-17—43747515306382 Jefferson Ave, Dallas, TX, 752990.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21762PRVGerald W Richardson1957-04-11UHC-52791-3529988256601747 Sage Ct, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23253PRVSamuel Reyes——8256939401445 Mesa Dr, Charlotte, NC, 282560.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22666PRVKenneth Carroll——27766743975265 Maple Ave Apt 38, Dallas, TX, 752980.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
PRV-23213PRVSarah Carlson———1651 Sunset Blvd, Las Vegas, NV0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20112PRVDiego Payne1962-04-18—75780671669440 Mountain View Dr, Scottsdale, AZ, 852130.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
PRV-21778PRVGeorge Fernandez1959-03-23—81899604155931 Union St, Columbus, OH0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22701PRVJustin Fuller1981-05-06UHC-95343-2420232978424564 Camelback Rd, Phoenix, AZ, 850290.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25292PRVKimberly R Ortega——64940699367148 Sage Ct, Jacksonville, FL0.50Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-26346PRVBobby Q Barnes——25054284937012 Lake View Rd, Jacksonville, FL0.50Name re-casedDate of birth missingPhone reformattedCity re-cased+3 more
PRV-28260PRVKevin D Matthews1965-08-15——6609 Mesa Dr, Houston, TX, 770740.50Name re-casedPhone missing area codeState name converted to codeEmail lower-cased+3 more
PRV-21107PRVMark Crawford1942-07-15UHC-80518-1433639449599452 Mesa Dr, Eden Prairie, MN, 553980.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-21737PRVLawrence W Jimenez2008-09-25UHC-86182-1992932181248191 Valley View Dr, San Antonio, TX, 782800.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
9,596 rows, page 9 of 192PreviousNext