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-25489PRVAisha Castro1938-10-08UHC-02967-7689460400563200 Apache Blvd, Las Vegas, NV, 891110.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-25432PRVOmar V Moore2004-07-06—25981129026676 Central Ave, Columbus, OH, 432320.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27762PRVMaria Hawkins1984-05-24UHC-51163-8446665944164711 Desert Sky Blvd, Austin, TX, 787830.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26120PRVMary G Nunez1967-06-23UHC-30029-904078082756326 Willow Ct, Houston, TX, 770490.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28307PRVMarcus P Davis1951-01-24UHC-27003-575598648628889 Elm St, Columbus, OH, 432250.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21122PRVJeremy Wagner1995-05-10UHC-69263-6539482887335862 Oak St, Eden Prairie, MN, 553050.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26618PRVLori Bradley1960-07-22UHC-54008-33903851526775 Market St, Las Vegas, NV, 891120.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26648PRVRalph A Mendoza1977-11-03UHC-00344-4977930927351456 Palm Dr, Los Angeles, CA, 900820.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24079PRVMason Le1954-04-12—60575311261454 Camelback Rd, Glendale, AZ, 853610.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-24291PRVAlan J Ellis1946-01-13—9427220019491 Mesa Dr, Gilbert, AZ, 852840.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26693PRVBetty Cox1944-01-01—28336299983527 Central Ave, Jacksonville, FL, 322750.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22115PRVRyan M Duncan2002-11-20—50023636688674 Willow Ct, Plano, TX, 750240.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20763PRVGregory H Richardson1961-04-11UHC-32697-7129096679471687 Palm Dr, Dallas, TX, 752710.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20789PRVEmily Roberts2006-06-27—25629690882034 Hillcrest Rd, Phoenix, AZ, 850170.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28515PRVBarbara Hayes1951-03-26—9766358924590 Meadow Ln, Fresno, CA, 937370.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28964PRVEdward Hicks1989-04-06—65454843633192 Mesa Dr, Columbus, OH, 432090.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22425PRVNatalie Medina1972-05-23UHC-72744-3139729005053602 Sunset Blvd, Tampa, FL, 336230.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28600PRVVirginia Y Wong1971-03-07UHC-96611-2567143572186349 River Rd, Chandler, AZ, 852710.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24740PRVCharles V Murphy1953-02-10UHC-98759-5230867657292992 Market St, Seattle, WA, 981620.76Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
PRV-20693PRVRoger Crawford1966-01-21UHC-92649-44—8719 Oak St, Phoenix, AZ, 850080.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27298PRVJulie Butler1976-09-06UHC-18149-7028479552613540 Apache Blvd, Los Angeles, CA, 900800.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21819PRVTimothy Flores1980-10-14UHC-53330-0257729978546476 Washington St, Eden Prairie, MN, 553890.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25488PRVKelly Warren1998-01-06—87324101584879 Harbor Blvd, Minneapolis, MN, 554210.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24304PRVEvelyn Burns1991-10-17—72847194534461 Spring St, Tampa, FL, 336710.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20364PRVBryan Q Hansen1945-11-13UHC-58991-8832769880318525 Highland Ave, San Antonio, TX, 782310.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21541PRVSophia Hughes2006-11-23UHC-77760-3775063005142143 Bayshore Dr, Tempe, AZ, 852300.76Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-27533PRVTimothy Hicks1942-12-19UHC-95337-3352864795174810 Church St, Scottsdale, AZ, 852950.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26261PRVBrittany Mendez1946-05-27—98250176895701 Baseline Rd, Columbus, OH, 432340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27037PRVJose Nelson1986-01-14UHC-60100-9797971792442966 Grand Ave, Nashville, TN, 372720.76Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
PRV-28357PRVMarrtha Black1979-07-25UHC-60855-5972757415699603 Baseline Rd, Seattle, WA, 981740.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29447PRVChristian Morano1939-05-17—44748124229892 Lake View Rd, Scottsdale, AZ0.76Name re-casedDate of birth reformattedCity re-casedZIP missing+2 more
PRV-23883PRVPatel Paul1942-11-22UHC-67299-3267172337078622 Bayshore Dr Apt 22, Tucson, AZ, 857410.76Name re-casedPhone reformattedMember ID reformattedUnit split from street+2 more
PRV-22631PRVWillie Graham2001-04-23UHC-19939-0941686410757899 Willow Ct, Minneapolis, MN, 554680.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23031PRVTimothy Martin1985-02-15UHC-77042-1482156529235826 Maple Ave, Fresno, CA, 937680.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26871PRVSteve Lewis1945-04-19UHC-79108-3770835118736070 Sage Ct, Scottsdale, AZ, 852600.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21009PRVTimotyh Reynolds1961-07-01—45580279138333 Forest Ave, Miami, FL, 331250.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23558PRVSophia Murphy1975-06-15—44333021337694 Pine Dr, Glendale, AZ, 853140.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-23559PRVSophia Murphy1975-06-15—44333021337694 Pine Dr, Glendale, AZ, 853140.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-24594PRVGeorge Owens1938-04-26—6016586517491 Union St, Glendale, AZ, 853220.76Date of birth reformattedPhone reformattedState code upper-casedZIP+4 trimmed+2 more
PRV-20128PRVHarold Y Cole1946-09-26UHC-46572-8244494237005148 Lincoln Way, San Antonio, TX, 782440.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22882PRVJess Fox1991-05-08—49322917872148 Apache Blvd, Jacksonville, FL, 322410.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-21277PRVPriya Dixon1998-08-21—32095319584608 Desert Sky Blvd, Columbus, OH, 432610.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27026PRVBrandon Robinson1952-09-16UHC-78201-8435528680275826 Jefferson Ave, Tempe, AZ, 852180.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
PRV-22324PRVAmanda Peters1967-11-03—92896890902524 Spring St, Minneapolis, MN, 554880.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21455PRVCamila S Murphy1977-05-27UHC-32185-1276480763607655 Forest Ave, Scottsdale, AZ, 852530.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25135PRVKeith Fod1947-04-21UHC-33594-4643824168926215 Central Ave, Orlando, FL, 328110.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27270PRVJoan Weber1940-06-07—86261986482151 Canyon Rd, Los Angeles, CA, 900830.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25881PRVLinda Martin2006-09-27——1063 Union St, Dallas, TX, 752620.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24730PRVAlbert Johnston1961-03-13UHC-99093-5492120377756902 Indian School Rd, Chandler, AZ, 852830.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20513PRVDorothy Jacobs1942-02-04—43220116562626 River Rd, Fresno, CA, 937710.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 85 of 192PreviousNext