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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-124204ENRJoshua X Contreras1959-04-17UHC-14116-3831894282568975 Ocean Ave # 849, Denver, CO, 802710.50Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+3 more
TPA-56305TPAGeroge Clark1957-12-20UHC-07697-40—2954 Bayshore Dr, Eden Prairie, MN, 553060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57812TPAEric Nunez—UHC-54081-90—4557 Indian School Rd, Charlotte, NC, 282540.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-26588PRVVincent H Thomas2004-10-15——4712 Willow Ct, Nashville, TN, 372640.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
ENR-135193ENRAna T Carroll—UHC-84457-1965756247639223 Ridge Rd # 982, San Diego, CA0.50Date of birth reformattedDate of birth unreadablePhone reformattedMember ID reformatted+3 more
ENR-114920ENRCarol Lewis1949-07-22UHC-11461-8728034869272415 Lincoln Way, Las Vegas, NV, 891870.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134976ENRRalph T Jacobs1999-04-07UHC-82994-1833989603381278 River Rd # 398, Phoenix, AZ, 850900.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21550PRVSara Ray1970-06-23UHC-20937-4355048008792228 Jefferson Ave, Las Vegas, NV, 891200.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-110138ENRAnn G Murray1986-04-18UHC-04228-652434482550847 Maple Ave, Sacramento, CA, 958520.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-21416PRVNancy W Estrada1976-03-22—79163656127743 Oak St, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-105484ENRDylan C Hawkins2003-12-21UHC-82949-4536162350785395 Lincoln Way Apt 7, Tucson, AZ, 857990.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-408796CLMDenise Parker1947-11-17UHC-17727-44—1449 Central Ave, Tempe, AZ0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-21985PRVJanice K Alexander2008-05-23—88745237528708 Central Ave, Sacramento, CA, 958320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133801ENRJoshua V Rios1968-05-18UHC-07268-3751995776406349 Indian School Rd Apt 35, Charlotte, NC, 282630.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-139999ENRStephen U Herrera1950-05-18UHC-99274-5793041058751373 Park Pl Apt 33, Minneapolis, MN, 554490.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-132343ENRBobby Riley1960-03-26UHC-22969-34—2284 Main St, Denver, CO, 802050.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-421700CLMMariana G Wilson1947-07-01——4779 Canyon Rd, Dallas, TX, 752720.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423178CLMKelly Lucas1947-12-15UHC-15635-05—6413 Meadow Ln, Seattle, WA, 981180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-141327ENRDiego C Carter1992-04-21UHC-63998-384759726757450 Main St, Eden Prairie, MN, 553820.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-137696ENRMaria G Hayes1977-08-17—2553187151541 Apache Blvd, Atlanta, GA, 303810.50Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-21720PRVElliott N Karen1970-11-18UHC-05863-6378135433107428 Forest Ave, San Antonio, TX, 782010.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-107378ENRAbby Arnold1980-05-19UHC-79863-6126133354754960 Jefferson Ave Apt 9, Gilbert, AZ, 852320.50Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+3 more
ENR-100929ENRCharlotte Bryant—UHC-51096-9785882005124266 Union St, Denver, CO, 802300.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109883ENRMaria F Cooper1963-02-22UHC-53767-89—7528 Desert Sky Blvd Apt 35, Miami, FL0.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-417588CLMAndrea Le1957-02-16UHC-70351-27—8785 Canyon Rd # 219, Sacramento, CA, 958540.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125966ENRJoshua Walker1948-12-24UHC-45586-7271441196421765 Lincoln Way # 231, Orlando, FL, 328060.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408122CLMJason Mason1983-09-02UHC-84953-5052788081186011 Washington St Apt 11, Sacramento, CA, 958000.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402607CLMGerald Howell1941-04-08——2627 Baseline Rd, Minneapolis, MN0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-59679TPACynnthia Jenkins1996-07-15——3297 Ridge Rd, San Antonio, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127834ENRMichelle R Price1983-08-09UHC-08987-6096240082705625 Pine Dr, Glendale, AZ, 853590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104763ENRJoe Bishop1987-04-18UHC-19037-06706287731469 Highland Ave Apt 8, Tampa, FL, 336780.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111267ENRRonald Lawrence1981-05-22UHC-29293-4348433793223578 Central Ave, Scottsdale, AZ, 852830.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139600ENRNicholas J Bishop2008-12-10UHC-32869-3481033793027846 Washington St # 686, Scottsdale, AZ, 852810.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120983ENRMadison Jenssen2001-08-22UHC-93265-2696648720717460 Baseline Rd, Scottsdale, AZ, 852120.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52078TPANicole Bowman1978-12-16—83553517633795 Lincoln Way, Tampa, FL, 336830.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-104596ENRJonathan T Hanson—UHC-12906-8493842829035052 Washington St, Plano, TX, 750730.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-57047TPARyan Elliott1962-07-01—83230839105526 Sunset Blvd Apt 8, San Antonio, TX, 782600.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-126010ENRGeorge Valdez1998-11-25UHC-34806-1789091283333498 Church St # 539, Charlotte, NC, 282450.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-108967ENRBryan Mitchell1992-03-14UHC-82450-6986445691836130 Sunset Blvd, Atlanta, GA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109397ENRAmber D King1944-08-22UHC-33875-3183595050474702 Lake View Rd, Gilbert, AZ0.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419332CLMGregory F James1971-03-22UHC-64701-90—669 Desert Sky Blvd, San Antonio, TX, 782940.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425167CLMRandy Jensen2008-05-28—41074486847270 Ridge Rd, Austin, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142627ENRJuan Snyder1939-04-17UHC-15581-31—7663 Spring St, Las Vegas, NV, 891640.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-125780ENRGerald Z Willis1957-08-12UHC-23329-0381525171307465 Church St, Houston, TX, 770080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59815TPALinda Ross1969-06-14UHC-27507-9742978427659275 Ridge Rd Apt 2, Chandler, AZ, 852460.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423738CLMAlan Thompson1972-10-05UHC-77689-96—2288 Sunset Blvd, Eden Prairie, MN, 553460.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-411546CLMMaria Snyder1966-05-27UHC-84820-97—5805 Mountain View Dr, Denver, CO, 802550.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-51875TPANaathan Greene1974-10-10——277 Cedar Ln Apt 34, Columbus, OH, 432360.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
ENR-108009ENRAmber M Valdez—UHC-35139-2678097882087773 Highland Ave, Miami, FL, 331030.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-113837ENRDanielle A Ford2006-12-08UHC-47400-4986421547979012 Central Ave, Plano, TX, 750810.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 127 of 2,000PreviousNext