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-22545PRVWalter H Fuller1957-07-01UHC-25159-1824679847131122 Camelback Rd, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22249PRVBeverly Phillips1945-08-19UHC-74481-708465817626996 River Rd, Nashville, TN, 372140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22998PRVMason H Chen1982-09-21UHC-68233-5971040032719569 Canyon Rd Apt 30, San Antonio, TX, 782400.48Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
PRV-27940PRVRichard L Gonzales1974-05-08UHC-13350-1772232724746299 Ocean Ave, Minneapolis, MN0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28727PRVBrian Ramos1971-08-15—7093802338134 Market St, Fresno, CA, 937140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28726PRVBrian Ramos1971-08-15—7093802338134 Market St, Fresno, CA, 937140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23318PRVRebecca Garza—UHC-40205-4954955613905199 Union St, Plano, TX, 750440.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-23801PRVMarilyn Aguilar1989-02-22—44645788774665 Baseline Rd, Chandler, AZ, 852350.48Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+4 more
PRV-23878PRVBruce Murray1994-10-11UHC-95825-7928930729862873 Highland Ave, Minneapolis, MN, 554380.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26354PRVKim H Harvey1960-01-28——1939 Palm Dr, Miami, FL, 331530.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-26562PRVLarry Lawrence1962-08-16—2058113418891 Indian School Rd, Glendale, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27288PRVMartha Hart1992-08-09UHC-75199-0161121682188285 Oak St, Orlando, FL, 328740.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25657PRVKelly Gonzales1965-12-21—87052621864772 Forest Ave, Plano, TX, 750140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27076PRVKaren N Harrison1987-01-26—8458765434718 Canyon Rd, Jacksonville, FL, 322070.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-25293PRVBeverly Romero1963-02-22—67841324517088 Ocean Ave, Miami, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-27123PRVOmar Morgan1977-12-03UHC-44342-5355776678779037 River Rd, Sacramento, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25652PRVAnn Martinez2006-09-21UHC-19690-8520390828713769 Highland Ave, Houston, TX, 770300.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20160PRVMadison F Cook1960-01-25—40140814788386 Spring St, Tucson, AZ, 857380.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-25574PRVGary K Burns1967-01-03—98673917883058 Church St, Mesa, AZ, 852120.48Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+4 more
PRV-29222PRVMelissa Dominguez1955-10-15—9855304738953 Baseline Rd, Sacramento, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25042PRVBeverly Evans1988-10-08—89090482109591 Valley View Dr, Las Vegas, NV, 891240.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27293PRVChristopher Contreras1951-12-19UHC-60511-1842097536828960 Main St Apt 14, Las Vegas, NV, 891760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-27585PRVElizabeth Walker1958-11-19UHC-96628-55—8507 Harbor Blvd, Denver, CO0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20347PRVMark Fox1974-07-18UHC-99909-5929466193522492 Ridge Rd, Minneapolis, MN, 554220.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-22085PRVRalph T Daniels2001-07-07UHC-44422-8861998445113822 Sage Ct Apt 7, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-27957PRVJesse Russell1983-04-14UHC-39788-2450456755828446 Camelback Rd, Phoenix, AZ, 850880.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23508PRVJack Soctt1949-08-22UHC-60017-5563330782316031 Elm St # 686, Las Vegas, NV, 891670.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-23812PRVAaron Rojas——31643523791140 Spring St, Tempe, AZ, 852440.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25003PRVMichelle Chavez1992-04-26UHC-36979-4076441803055832 Sunset Blvd # 499, Scottsdale, AZ, 852880.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
PRV-29059PRVJulie N Guerrero——90088934943375 Apache Blvd, Sacramento, CA0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25556PRVWei Schultz1995-09-03—6143618318552 Indian School Rd, Eden Prairie, MN, 553830.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21414PRVAhmed Vazquez1955-08-09UHC-66130-9391425412726035 Oak St, Fresno, CA, 937230.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-20370PRVTimothy Reed1963-03-14UHC-65404-5521687000236904 Lincoln Way, Columbus, OH, 432030.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20470PRVJoe W Olson1974-08-05UHC-29037-7095172276778587 Meadow Ln Apt 8, Minneapolis, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-22623PRVAmanda Reynolds1981-04-11—32628910117514 Ocean Ave # 187, Tucson, AZ, 857250.48Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+4 more
PRV-29130PRVChristian Lynch1982-04-12UHC-89218-0947356220602724 Central Ave, San Antonio, TX, 782480.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-26050PRVCarol Ortega1996-01-15UHC-51717-7359678030695241 Central Ave, Tampa, FL0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-22864PRVRaymond Payne1967-06-01UHC-06240-9538084789377626 Broadway, Denver, CO, 802720.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
PRV-24148PRVPhilip Valdez1996-03-02UHC-84631-45—713 Camelback Rd Apt 24, Denver, CO, 802340.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-20830PRVTyler U Crawford1968-08-07UHC-49693-6472550150119252 Ridge Rd, Plano, TX, 750950.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26703PRVCharlotte Oliver1975-02-24UHC-36496-4995386998885885 Highland Ave, Phoenix, AZ, 850360.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20554PRVJulie Lee1979-01-20—38425433075571 Harbor Blvd, Jacksonville, FL, 322450.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-20401PRVMarilyn Long1982-08-17UHC-18585-0546965150474829 Oak St, Atlanta, GA, 303570.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23631PRVMateo Harrison1950-12-08—78656505138418 Washington St, Atlanta, GA0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20820PRVNoah Chapman2002-04-15UHC-65294-579799046434397 Palm Dr, Phoenix, AZ, 850780.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23711PRVMei Li1953-11-28UHC-98792-3671166845569840 Palm Dr, Jacksonville, FL, 322550.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
PRV-26152PRVMariana U Jackson1992-11-20—49963105298346 Palm Dr, Austin, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20429PRVCarol P Powell1948-10-05—93339346796617 Highland Ave, Tucson, AZ, 857640.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21444PRVEmma L Carpenter1987-06-28—4109002257286 Market St, Jacksonville, FL, 322950.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-21627PRVKimberly Alexander1955-06-01—68085369988543 Forest Ave, Chandler, AZ, 852430.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
9,596 rows, page 8 of 192PreviousNext