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-20207PRVBrandon Carlson1988-11-07UHC-05200-4447389373944875 Apache Blvd, Houston, TX, 770120.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-28502PRVVicky Nunez——79123793085348 Central Ave, Houston, TX, 770870.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-27416PRV—Junk1940-02-18UHC-46209-5168529172153684 Church St, Charlotte, NC, 282020.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28952PRVWillie I Sims1959-05-14UHC-08712-3138354952393094 Hillcrest Rd, Plano, TX, 750320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20690PRVAnn Alexander———8659 Ocean Ave, Columbus, OH, 432670.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
PRV-21166PRVWillie V Schmidt1942-05-12UHC-28576-152516074968446 Maple Ave Apt 5, Houston, TX, 770300.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-23105PRVRuth Ray1953-06-22——3090 Harbor Blvd, Las Vegas, NV, 891140.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-24607PRVSofia Carpenter1954-12-27UHC-23990-079727895012204 Ocean Ave Apt 9, Dallas, TX, 752710.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-25027PRVJacob J Smith1974-05-08—20592426254760 Canyon Rd, Atlanta, GA, 303610.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21603PRVWayne Gutierrez1982-11-13—42871316167979 Park Pl, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22239PRVIsabella Mitchell1982-12-01UHC-75813-49—1147 Canyon Rd, Chandler, AZ, 852000.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-28909PRVJerry Cole2005-03-11——8103 Main St, Tampa, FL, 336000.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-20656PRVStephanie Harvey1990-03-05UHC-11287-5275831845206362 Union St, Eden Prairie, MN, 553380.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-27640PRVChristine Fernandez1973-04-23—94933797929101 Washington St, Atlanta, GA, 303810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23881PRVBrandon Rojas1940-05-16UHC-05735-9733531940715141 Union St # 419, Seattle, WA, 981270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23882PRVBrandon Rojas1940-05-16UHC-05735-9733531940715141 Union St # 419, Seattle, WA, 981270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-28992PRVTimothy Carter1941-02-01UHC-21773-289864805461405 Sage Ct, Sacramento, CA, 958030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-27376PRVTeresa Rivera1967-12-18—61337458609292 Forest Ave, Fresno, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28545PRVWalter Gomez1945-05-22—59069430612117 Camelback Rd # 570, Chandler, AZ, 852990.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
PRV-20016PRVSmaantha Young1990-04-28UHC-43942-38—5157 Harbor Blvd, San Antonio, TX, 782310.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
PRV-21125PRVVirginia Singh1957-04-27UHC-78289-57—1609 Valley View Dr, Charlotte, NC0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22102PRVCamila G Olson1949-01-07—52465108063970 Sage Ct, Atlanta, GA, 303420.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
PRV-27201PRVRalph K Collins1989-01-03—92573079151999 Ocean Ave, Columbus, OH, 432400.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29073PRVBrittany W Taylor1941-05-07UHC-11983-4094032991573835 Ridge Rd, Tempe, AZ, 852980.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
PRV-22308PRVCarol Garrett1971-02-27UHC-98913-0344097552595161 Valley View Dr, Fresno, CA, 937850.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22780PRVDavid Martin2007-09-12—32287699045526 Ridge Rd # 580, Denver, CO, 802090.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-27325PRVAngela Carpenter1990-07-20——4829 Jefferson Ave, Austin, TX, 787520.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
PRV-24069PRVTheresa Kelly1950-01-02UHC-26103-4968765601791014 Hillcrest Rd, San Diego, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-26497PRVJudy A Edwards1992-08-01——501 Palm Dr, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22633PRVKathryn Bailey1952-03-04—38866207374062 Baseline Rd # 826, Tampa, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22278PRVHenry Palmer2001-07-28UHC-86219-27—6770 Sage Ct Apt 28, Tucson, AZ, 857210.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25476PRVLawrence Morris1965-03-05—95221469726621 Central Ave Apt 5, Jacksonville, FL, 322580.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24795PRVArjnJunk1986-04-21UHC-50680-8379782688162780 Spring St, Los Angeles, CA, 900630.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23712PRVHarold Fernandez1981-07-02UHC-45011-9882222501906390 Lake View Rd Apt 24, Sacramento, CA, 958080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25428PRVTeressa Yang2006-01-17——3126 Bayshore Dr, Nashville, TN, 372420.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
PRV-22927PRVJulie H Sims1980-02-25UHC-52677-23—4819 Valley View Dr, San Antonio, TX, 782200.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21759PRVScott Santos1961-01-22—44926520669274 Maple Ave, Chandler, AZ, 852870.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26166PRVSofia Riley1998-07-26—38886408926118 Central Ave, Fresno, CA0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-28027PRVBrian Adams1954-04-02—78574307254847 Ridge Rd, Minneapolis, MN, 554700.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25523PRVNatalie L Ramos1987-04-27——926 Spring St, Tempe, AZ, 852560.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25815PRVEugene Warren1965-03-23UHC-16651-2057399045444103 Bayshore Dr Apt 24, Gilbert, AZ, 852770.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
PRV-29337PRVRalph Wood1959-08-19UHC-68877-1129082996885440 Lake View Rd, Charlotte, NC, 282500.50Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
PRV-28542PRVYuki O Maldonado1980-05-26—6806785902647 Church St, Orlando, FL, 328020.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-23194PRVSusan Hayes1957-09-13UHC-57014-2522875701862422 Sunset Blvd, Phoenix, AZ, 850530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-26308PRVChristine J Espinoza—UHC-16134-2241580557566095 Meadow Ln, Plano, TX, 750980.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27414PRVStephanie J Wagner—UHC-41796-51—7721 River Rd, Gilbert, AZ, 852050.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-22172PRVDorothy Medina1967-10-19UHC-55197-7394073349861837 Pine Dr, Houston, TX, 770410.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23075PRVRalph S Fields1980-02-01—53387151287885 Washington St, Columbus, OH, 432250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22632PRVCarol U James1996-11-22——5225 Union St, Tucson, AZ, 857230.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-26195PRVHenry Myeers1953-05-04—21320714182969 Cedar Ln, Las Vegas, NV, 891000.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 13 of 192PreviousNext