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-26198PRVYoug Cheryl1984-10-20UHC-94928-5040731710836311 Sage Ct, San Diego, CA, 921500.82Name re-casedGender normalisedPlaceholder values cleared
PRV-29084PRVGary Q Daniesl2007-01-19UHC-24336-404364137189—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-28145PRVRoger Robinsson1990-04-28UHC-22981-7362996994912138 Ocean Ave, Tampa, FL, 336170.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-23188PRVRichard X Vasquez1944-10-03UHC-80242-217574224752—0.82Name re-casedGender normalisedPlaceholder values cleared
PRV-27055PRVJenice Kelly1956-11-05—6167580964—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-24015PRVKatherine N Porter1945-05-01UHC-30660-1379551210598266 Lincoln Way, Eden Prairie, MN, 553860.82Phone reformattedState name converted to codePlaceholder values cleared
PRV-25539PRVTyler Parker2008-07-24—8367210922—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-29446PRVRichard X Hal1968-05-21UHC-80730-4836537939981642 Mountain View Dr, Dallas, TX, 752940.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-28928PRVJanet Garrett1995-11-27—43669049956771 Broadway, Miami, FL, 331540.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-22152PRVSara Richardson2002-11-24—5574408247—0.82Email lower-casedGender normalisedPlaceholder values cleared
PRV-26668PRVJacqueline Bell1997-04-19—8718672673—0.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-24975PRVIsabella Elliott1942-04-03—9478300276—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-27014PRVHeather Chavez1947-10-03UHC-48341-502995580953698 Apache Blvd, Miami, FL, 331890.82Phone reformattedState name converted to codePlaceholder values cleared
PRV-21146PRVAbigail Andrews1980-05-16—8794888751499 Lincoln Way, Minneapolis, MN, 554550.82Date of birth reformattedState name converted to codePlaceholder values cleared
PRV-27558PRVAlexis Vasquez1968-08-12—77192505886026 Ocean Ave, Chandler, AZ, 852410.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-26101PRVCarl M Santos1997-03-31———0.82Name re-casedGender normalisedPlaceholder values cleared
PRV-23314PRVAlexander J Castro1938-07-15UHC-91968-47—6520 Apache Blvd, Scottsdale, AZ0.82Name re-casedZIP missingPlaceholder values cleared
PRV-22197PRVGloria Fowler1964-09-07——6908 Sage Ct, Tucson, AZ, 857530.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22863PRVJoe Q Hernandez1984-04-12—7448370918795 Maple Ave, Tempe, AZ0.82Phone reformattedZIP missingPlaceholder values cleared
PRV-22202PRVElijah Aguilar1996-12-19UHC-11836-39—1294 Sage Ct, Jacksonville, FL, 322920.82City re-casedState name converted to codePlaceholder values cleared
PRV-27586PRVAnthony Hernandez1986-02-11UHC-00616-7357365128919401 Central Ave, Orlando, FL, 328450.82Phone reformattedState name converted to codePlaceholder values cleared
PRV-27708PRVKimberly Black1991-04-16——8087 Pine Dr, Tempe, AZ0.82ZIP missingEmail lower-casedPlaceholder values cleared
PRV-26786PRVLawrence Snyder2007-03-28UHC-47696-5086436898152275 Harbor Blvd, Miami, FL, 331570.82Name re-casedGender normalisedPlaceholder values cleared
PRV-25960PRVBryan King1960-11-11UHC-04101-99—3073 Canyon Rd, Fresno, CA, 937610.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-21631PRVHeather G Black1983-01-18——3321 Washington St, Los Angeles, CA, 900400.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22750PRVRalph Simmons1962-05-14—53360648706693 Washington St, San Diego, CA, 921760.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-28926PRVRobert Jordan1972-11-19UHC-91338-54—913 Hillcrest Rd, Chandler, AZ, 852950.82Name split from “Last, First”City re-casedPlaceholder values cleared
PRV-20683PRVMichael Stone1974-01-26UHC-84625-12—7918 Meadow Ln, Miami, FL, 331290.82Date of birth reformattedGender normalisedPlaceholder values cleared
PRV-27667PRVAlbert Larson——9705549588197 Park Pl, Glendale, AZ, 853990.82Date of birth missingPhone reformattedPlaceholder values cleared
PRV-25847PRVVirginia Delgado1965-02-23——7260 Union St, Sacramento, CA, 958360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27323PRVDeborah Luna1953-12-05UHC-71000-239327912460—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-20477PRVHelen Guerrero1982-11-01—4187174453—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-24937PRVVicttoria C Johnston1957-07-22UHC-39376-18—9122 Central Ave, Sacramento, CA, 958550.82Name re-casedTwo-digit birth yearPlaceholder values cleared
PRV-23014PRVMartha O Chapman1938-04-06——1455 Mountain View Dr, Tempe, AZ, 852180.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
PRV-21879PRVJean Petars1980-07-14—44449156825944 Apache Blvd, Miami, FL, 331190.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-24893PRVGary Vazquez1974-01-17—9332571941—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24017PRVJun Welch1959-01-05—34782018514917 Park Pl, San Antonio, TX, 782270.82Street suffix standardisedAddress re-casedWhitespace trimmed
PRV-20845PRVPhilip Le1983-04-22UHC-39834-947534863035—0.82Email lower-casedGender normalisedPlaceholder values cleared
PRV-25597PRVRobert C Dean1949-03-03—8195638371—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26622PRVDouglas Stevens2003-03-17——7040 Oak St, Columbus, OH, 432360.82Name re-casedState name converted to codePlaceholder values cleared
PRV-20417PRVSarra Gomez——6536545230—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
PRV-20167PRVFrances Wilson1940-10-21UHC-38544-9735558133649472 Willow Ct, Mesa, AZ, 852270.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28516PRVNatalie Walsh————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
PRV-20475PRVMichael Fields1969-09-14UHC-13912-975934521973332 Baseline Rd, Tucson, AZ, 857560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28547PRVJose Jensen1939-09-04——4470 Church St, Mesa, AZ, 852430.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20422PRVAngela I Hawkins1940-08-24UHC-86812-105688248155975 Lincoln Way, Minneapolis, MN, 554320.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26806PRVAlan Adams1967-08-10UHC-50559-2228049517663569 Meadow Ln, Minneapolis, MN, 554800.82Street suffix standardisedAddress re-casedEmail lower-cased
PRV-23548PRVSharon Z Davis1962-12-16——5576 Highland Ave, Fresno, CA, 937500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22155PRVStephen Carr1966-01-10—78073114197932 Harbor Blvd, Jacksonville, FL, 322190.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21925PRVCharles Ramirez1979-07-08——4626 Sage Ct, Sacramento, CA, 958160.82Street suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 147 of 192PreviousNext