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-106083ENRBruce Matthews1948-10-15UHC-70940-8235648789069500 Church St, Eden Prairie, MN, 553620.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21107PRVMark Crawford1942-07-15UHC-80518-1433639449599452 Mesa Dr, Eden Prairie, MN, 553980.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-54920TPAJustin Garcia1993-09-18——6008 Cedar Ln # 762, Scottsdale, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-122977ENRVicky Q Hamilton1974-09-06UHC-20657-6853899134921611 Spring St, Las Vegas, NV, 891620.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-110572ENRAmy B Franklin1995-06-08UHC-99324-8854478756802923 Washington St, Mesa, AZ, 852790.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-138986ENRDenise Burns1987-02-12UHC-01051-8747962772795721 Meadow Ln, Eden Prairie, MN0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119565ENRNicole Padilla—UHC-62109-3865941677356464 Highland Ave # 838, Eden Prairie, MN, 553040.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130212ENRMarilyn D Bryant1956-07-24UHC-01965-8277493324419387 Apache Blvd, Tampa, FL, 336740.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-120207ENRThomas I Hamilton2001-12-07UHC-44880-96—7449 Baseline Rd Apt 12, Fresno, CA, 937410.50Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115524ENRLaura O Ruiz1990-01-04UHC-43485-0741668477952480 Elm St, Plano, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427635CLMHiroshi Moore1950-09-08UHC-19734-64—952 Union St, Glendale, AZ, 853880.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-56998TPACharlotte Lopez1954-05-07——4337 Sage Ct, Houston, TX, 770530.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54536TPAVyncent K Smith1954-08-27——2219 Canyon Rd, San Diego, CA, 921840.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21737PRVLawrence W Jimenez2008-09-25UHC-86182-1992932181248191 Valley View Dr, San Antonio, TX, 782800.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
ENR-120153ENRLucia U Schmidt1955-03-08UHC-12220-9642393085366822 Church St, Glendale, AZ0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125746ENRBradley Brery1994-07-25UHC-89119-309077518680302 Canyon Rd, Tempe, AZ, 852060.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-100233ENRMarcus Schmidt2006-12-12UHC-74913-8869973280171781 Apache Blvd, Dallas, TX, 752460.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-101185ENREric G Hoffman—UHC-44737-8375837807764427 Desert Sky Blvd, Plano, TX, 750480.50Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-100526ENRSusan Freeman1948-01-26UHC-73337-8641825352458141 Pine Dr, Sacramento, CA, 958100.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51262TPAAnna Freeman2005-05-18UHC-84558-26—9520 Apache Blvd, Nashville, TN0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124309ENRJoshua Warren1949-05-13UHC-33579-29—497 Baseline Rd, Orlando, FL, 328310.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-63275TPASamuel Q Greene———2210 Main St, Charlotte, NC, 282130.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-410059CLMMeyer Yuki1950-06-01UHC-39552-52—7772 Harbor Blvd, Seattle, WA, 981220.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409078CLMRobert N Tren1978-03-12UHC-15067-68—6155 Spring St, Plano, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422276CLMJanet Morgan1968-04-24UHC-17766-52—2596 Sunset Blvd Apt 39, Chandler, AZ, 852280.50Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-116180ENRGregory U Campbell1992-07-05UHC-86806-0496233347201084 Lake View Rd, Los Angeles, CA, 900330.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-122653ENREugene J Johnson1959-08-22UHC-80550-8487833990919294 Park Pl, Tucson, AZ, 857360.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-428847CLMKelly Contreras2004-02-22——6369 Maple Ave, Eden Prairie, MN, 553460.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-139842ENRAaron S Shaw—UHC-68668-9161698898133907 Elm St, Seattle, WA0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-136381ENRDoris Stevens1967-10-25UHC-63515-4640451732013446 Apache Blvd # 441, Nashville, TN, 372220.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-415614CLMTerry Singh1956-05-20UHC-09840-40—7381 Main St, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111143ENRRoy Jimenez2000-04-02—66951753209219 Apache Blvd Apt 30, Glendale, AZ, 853820.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136318ENRKatherine B West2001-01-25UHC-33223-956707918648798 Central Ave Apt 4, Dallas, TX, 752130.50Name re-casedDate of birth reformattedUnit split from streetState name converted to code+3 more
ENR-121069ENRDiane U Baker1983-07-26UHC-71337-5032043183131048 Hillcrest Rd, Las Vegas, NV, 891880.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
CLM-402896CLMBradley Q Hayes1943-07-10—24639068138430 Forest Ave, Las Vegas, NV, 891180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-140800ENRAleexander C Reed2007-01-17UHC-71496-8164155562243769 Meadow Ln, Columbus, OH, 432210.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-21501PRVBilly Morgan1977-10-28UHC-03233-8484781824852010 Union St # 989, Denver, CO, 802240.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-25445PRVJanice Weaver1973-10-17—61380300401279 Oak St, Denver, CO, 802250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24303PRVShirley Adams1972-07-20—91595112748927 Ridge Rd # 823, Houston, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25239PRVJanice Marquez1938-09-08UHC-17144-80—8672 Cedar Ln, Chandler, AZ, 852530.50Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-59755TPABrandon James1955-10-27—33664598759899 Central Ave, Chandler, AZ, 852630.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-127161ENRMegan B Clark1990-01-05UHC-96665-83—3323 Grand Ave, Eden Prairie, MN0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415567CLMBenjamin P Singh1948-11-04UHC-04897-534392169084747 Ocean Ave, San Antonio, TX, 782860.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-406424CLMLawrence Elijah1960-10-13UHC-97485-2127827581357475 Cedar Ln, Phoenix, AZ, 850910.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
TPA-58979TPADominguez Helen2000-05-20——320 Pine Dr, Eden Prairie, MN, 553690.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-110922ENRShirley Butler1993-09-06UHC-47514-26—218 Canyon Rd, Phoenix, AZ, 850060.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
ENR-122364ENRJanice Wilson1947-01-19UHC-63240-6748462816263994 Ocean Ave # 412, Austin, TX, 787980.50Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-406568CLMJonathan Weaver1979-02-25UHC-19398-18—1511 Palm Dr, Tucson, AZ, 857930.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127716ENRAmber Reed1938-03-05UHC-77622-2984594386094076 Canyon Rd # 248, Orlando, FL, 328250.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-404577CLMScott D Richardson1980-05-06—98345416009172 Canyon Rd, Chandler, AZ, 852430.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 86 of 2,000PreviousNext