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-23787PRVCatherine L Peters1960-04-22UHC-57239-936722681200387 Park Pl # 939, Tucson, AZ, 857760.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-29062PRVSara Q Guzman1964-06-15——1638 Washington St, Sacramento, CA, 958160.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27621PRVDavid Guzman1957-08-27UHC-47294-7439042357658849 Oak St, Sacramento, CA0.80Date of birth reformattedPhone reformattedZIP missingPlaceholder values cleared
PRV-21031PRVMartha Bell1992-02-24UHC-89637-1264087305983913 Main St, Las Vegas, NV, 891310.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21716PRVHeather Allen1952-07-21——9064 Grand Ave, Nashville, TN, 372720.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26552PRVArjun B Palmer1946-06-25—54044939386417 Canyon Rd, Mesa, AZ0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-27424PRVMichael V Cole1958-07-12UHC-18134-275285998440—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-22949PRVAlexander E Carpenter1948-07-15——1607 Oak St, Orlando, FL, 328110.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-26458PRVKayla Rike1997-11-11—51062580983442 Church St, Gilbert, AZ, 852720.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
PRV-24103PRVWalter F Florse1966-11-05—46047724494465 Jefferson Ave, Houston, TX, 770580.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20405PRVAustin Rice1961-08-09UHC-01782-0563390883093657 Elm St, Tempe, AZ, 852170.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24389PRVNatalie Medina1945-12-24UHC-96777-369484023277—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21825PRVSophia Lynch1967-10-21UHC-01980-867369644069—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21091PRVMari Munoz1974-05-22—63571790007712 Cedar Ln, Tempe, AZ, 852570.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-26310PRVPhilip Rodriguez1939-08-18—27177912054856 Desert Sky Blvd, Atlanta, GA0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-27241PRVMargaret Ford2008-01-08UHC-83967-2837277645007510 Washington St, Miami, FL, 331310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26932PRVEugene Harper1961-01-04—7052485267787 Baseline Rd, Dallas, TX, 752860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29211PRVEmily F Dean1938-09-11UHC-59103-27809575390645 Oak St, Denver, CO, 802590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28146PRVBenjamin I Walsh1994-02-10UHC-49322-36—6739 Union St, Mesa, AZ, 852070.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-25321PRVKevin Cunningham1962-09-09UHC-16646-65—4566 Forest Ave, Phoenix, AZ, 850990.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24391PRVPaul Pena1987-03-24——1244 Forest Ave, Eden Prairie, MN, 553340.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21383PRVAngela Kennedy———890 Forest Ave, Dallas, TX, 752390.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-21521PRVKevin N Harper1974-04-01—69184738568224 Ocean Ave, Charlotte, NC0.80Date of birth reformattedPhone reformattedZIP missingPlaceholder values cleared
PRV-29297PRVSamuel Richards1984-02-14—26454537702173 Mountain View Dr, Phoenix, AZ, 850060.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21744PRVEthan Li1947-07-13UHC-48504-3432320507022446 Mountain View Dr, Phoenix, AZ, 850640.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21745PRVEthan Li1947-07-13UHC-48504-3432320507022446 Mountain View Dr, Phoenix, AZ, 850640.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21041PRVBilly Weber1989-01-02UHC-14482-44—3418 Indian School Rd, Los Angeles, CA, 900860.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-24874PRVVirginia Morgan1998-09-03UHC-03695-089238712495337 Elm St, Mesa, AZ, 852520.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25068PRVMason O Thompson1973-11-12—65134833103206 Willow Ct, Tucson, AZ, 857450.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28556PRVCarlos A Webb1949-12-20UHC-82977-748783040123—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20931PRVTyler F Carroll1955-07-23—46729369624135 Ocean Ave, Austin, TX, 787210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24512PRVPeter Vasquez1972-12-16——9389 Main St, Nashville, TN, 372000.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23797PRVSophia Ferguson1956-12-12—61887158195698 Baseline Rd, San Antonio, TX, 782250.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21507PRVMarilyn Aguilar1977-06-02—27634837973638 Bayshore Dr, Dallas, TX, 752000.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28445PRVKathryn Wilson1995-04-08——4396 Sage Ct, Chandler, AZ, 852430.80Name re-casedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-22598PRVWillie Rivera1960-07-07———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26250PRVJessica Guerrero1953-09-21UHC-43793-554625519389747 Canyon Rd, Gilbert, AZ, 852230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26219PRVKaren Nichols1944-07-15UHC-16586-7195948026728450 Indian School Rd, Los Angeles, CA, 900350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22588PRVCatherine Q Marquez2000-01-20UHC-51377-3030052681455431 Church St, Austin, TX, 787250.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-22966PRVRussell Hicks1974-03-05UHC-25635-113292866762294 Central Ave # 984, Charlotte, NC, 282840.80Phone reformattedUnit split from streetState code upper-casedPlaceholder values cleared
PRV-22699PRVRachel Sullivan1999-10-18UHC-71527-1552971748492625 Grand Ave, Eden Prairie, MN, 553120.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-20294PRVReid Santiago1991-05-21UHC-51553-4322822418948160 Willow Ct, Sacramento, CA, 958740.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-21821PRVCamila Jimanez1975-10-02UHC-71123-9234836487389655 Meadow Ln, Plano, TX, 750280.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26244PRVRalph Wang—UHC-12292-288379041449—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24312PRVEmily Matthews1969-03-01UHC-29986-98—7506 Indian School Rd, Houston, TX, 770600.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26702PRVEric G Perkins1999-11-21—51031456537227 Sunset Blvd, Tampa, FL, 336390.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23344PRVKimberly Webb2001-10-11UHC-74710-86—1437 Grand Ave, Nashville, TN, 372920.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25566PRVWillie Walsh1986-02-01—5423626204408 Sage Ct, Scottsdale, AZ, 852490.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25230PRVBrittany X Roomero1966-01-05—52893860551928 Maple Ave, Austin, TX0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-29404PRVDiane Fowler1962-09-21—63622364892837 Park Pl, Tampa, FL, 336650.80Date of birth reformattedPhone reformattedZIP+4 trimmedPlaceholder values cleared
9,596 rows, page 140 of 192PreviousNext