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-22967PRVPaul Bryant1941-11-16UHC-60881-8229037524862302 Sage Ct, Los Angeles, CA, 900010.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-21237PRVYuki Carter1955-09-25UHC-07808-7552497977474834 Central Ave, San Diego, CA, 921220.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27679PRVValentina H Reed1942-04-11——5582 Maple Ave, San Diego, CA, 921170.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22243PRVHannah Clark1981-05-15—68199262182713 Jefferson Ave, Fresno, CA, 937370.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-28361PRVEvelyn Lucas1955-07-07UHC-92805-2725875870186833 Desert Sky Blvd, Los Angeles, CA, 900100.66Phone reformattedState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
PRV-28693PRVGerald Wood——50357420895108 Maple Ave, Las Vegas, NV, 891800.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21185PRVJanice Clark1988-06-25UHC-78491-2351899049772719 River Rd, Orlando, FL, 328170.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21436PRVNatalie Hciks2004-09-04—63844446984341 Lake View Rd, Plano, TX, 750400.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23428PRVKeith Mills1969-12-07—8646607825278 Hillcrest Rd # 759, Seattle, WA, 981060.66Date of birth reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
PRV-21840PRVEmily Cruz2006-02-24—73764754569514 Spring St, Mesa, AZ, 852450.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-26797PRVGerald Harris1993-09-04UHC-40919-46—5549 Market St, Las Vegas, NV, 891280.66Date of birth reformattedState code upper-casedZIP+4 trimmedGender normalised+1 more
PRV-21038PRVDennis Gardner1975-09-27UHC-28962-20—9046 Mountain View Dr, Austin, TX, 787440.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28292PRVCynthia T Lawrence1954-02-02——8533 Harbor Blvd, Denver, CO, 802560.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21362PRVSean O Turner1965-02-11UHC-59643-9767048658992219 Bayshore Dr, Tampa, FL, 336180.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27415PRVDavid Nguyen1992-12-28—59658367047691 Washington St Apt 5, Jacksonville, FL, 322880.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21712PRVKelly P Aguilar1938-11-04UHC-52255-7724327054255312 Ridge Rd, San Antonio, TX, 782460.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26521PRVJames Williams1985-08-22—94688501241733 Canyon Rd, Minneapolis, MN, 554310.66Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+1 more
PRV-20489PRVLucia Perkins1968-10-09UHC-64440-2167698250089799 Washington St, Denver, CO0.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-22418PRVPriya Z Clark1940-07-26—75768154572277 Bayshore Dr, Plano, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-25639PRVJesse Wallace2005-06-01—4907174293—0.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
PRV-20647PRVJulie Hansen1973-09-25UHC-11629-444145977826667 Oak St, Eden Prairie, MN, 553360.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-25424PRVNicole B Kim1945-01-20UHC-08143-4322588633849473 Jefferson Ave # 868, Glendale, AZ, 853500.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-28153PRVSamuel Yang1982-10-08—29684042549388 Oak St Apt 2, Los Angeles, CA, 900610.66Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+1 more
PRV-25360PRVRichard Harrison1987-09-11—79571180111852 Main St, San Antonio, TX, 782880.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25971PRVMarcus Bishop2007-09-13—9556941252853 Park Pl, Gilbert, AZ, 852030.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-21120PRVAndrew Rivera1983-06-13UHC-42281-6690272227803452 Broadway, Nashville, TN, 372420.66Name split from “Last, First”Phone reformattedAddress re-casedGender normalised+1 more
PRV-21338PRVBilly Tucker1987-12-20—55087718511246 Hillcrest Rd, Tampa, FL, 336790.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
PRV-28200PRVLauren Howard2005-04-18UHC-54097-9478243535269045 Harbor Blvd, Minneapolis, MN, 554370.66Two-digit birth yearPhone reformattedState code upper-casedGender normalised+1 more
PRV-20910PRVChristian Lawson1975-02-12——3874 Jefferson Ave, Chandler, AZ, 852350.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
PRV-22054PRVMark Hunt1984-06-14—78045603997893 Sage Ct Apt 21, Tampa, FL, 336990.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-23261PRVKathryn Ross1980-02-11UHC-38480-0226920316689505 Harbor Blvd, Minneapolis, MN, 554420.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-20674PRVGeorge Castillo2008-10-04UHC-12374-3020747009325752 Sage Ct, Phoenix, AZ, 850550.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-24541PRVDiana Hughes1975-03-01UHC-99954-49—8291 Palm Dr, Dallas, TX, 752540.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-29355PRVAlexander Wells1960-08-11UHC-85686-20—9136 Union St, Sacramento, CA, 958450.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27926PRVCarol T Berry1986-08-25—24590885552971 Indian School Rd, Seattle, WA, 981310.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21924PRVEvelyn K Green2006-05-03UHC-78882-43——0.66Name re-casedTwo-digit birth yearMember ID reformattedGender normalised+1 more
PRV-27176PRVHenry Ruiz1992-02-13UHC-11129-89918848734286 Bayshore Dr, San Antonio, TX, 782960.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-23039PRVGary Simpson—UHC-25382-23—963 Meadow Ln, Nashville, TN, 372380.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23040PRVGary Simpson—UHC-25382-23—963 Meadow Ln, Nashville, TN, 372380.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28613PRVBeverly Ortega1950-07-16UHC-09931-265759757794830 Bayshore Dr, Dallas, TX, 752090.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23916PRVStephen Schmidt1948-08-13——4988 Pine Dr, Glendale, AZ, 853400.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-22298PRVAlbert Ortiz—UHC-43635-68—5853 Union St, Phoenix, AZ, 850510.66Name re-casedDate of birth unreadablePhone missing area codeEmail lower-cased+1 more
PRV-20131PRVCheryl Fernandez—UHC-81604-3596674771005415 Lake View Rd, San Diego, CA, 921520.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29151PRVArthur Boyd1978-06-22UHC-79630-4421825590136927 Lincoln Way, San Diego, CA, 921940.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20243PRVMelissa J Alexander1944-12-03—33325051688745 Ocean Ave, Charlotte, NC, 282100.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-29033PRVJoseph I Lucas1963-11-28UHC-13804-5863026890184555 Lincoln Way, Atlanta, GA, 303450.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29034PRVJoseph I Lucas1963-11-28UHC-13804-5863026890184555 Lincoln Way, Atlanta, GA, 303450.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-28180PRVMary Herrera1973-03-20——7943 Palm Dr, Houston, TX, 770400.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-21127PRVDiana J Russell1999-01-05——3778 Apache Blvd, Tempe, AZ, 852280.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29587PRVEugene A Graham1950-06-16——7226 Oak St, Atlanta, GA, 303430.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
9,596 rows, page 63 of 192PreviousNext