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
CLM-410602CLMPaul Bailey1947-01-06UHC-74026-83—2994 Pine Dr # 188, Las Vegas, NV, 891460.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-127701ENRArthur Gray1996-05-02UHC-88638-1836182429064343 Spring St, Nashville, TN, 372130.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412621CLMJean Chen1989-09-10UHC-94984-08—9310 Camelback Rd # 352, Plano, TX, 750250.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-134468ENRTricia Phillips—UHC-63412-3087737520431441 Harbor Blvd, Austin, TX, 787930.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-108251ENRMichael Z Knight1988-08-19UHC-49306-7226094390625698 Meadow Ln, Seattle, WA, 981940.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403519CLMPemela E Thompson1981-12-15——99 Valley View Dr, Glendale, AZ0.52Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+2 more
ENR-108537ENRWayne P Oliver1976-04-07UHC-87651-907625235720365 Church St, Sacramento, CA, 958310.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62418TPAWilliam Hamilton1950-11-11—24534299743320 Meadow Ln, Fresno, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-108175ENRLauren O Porter2007-09-10UHC-20565-2962061983831895 Elm St, Glendale, AZ, 853350.52Two-digit birth yearPhone reformattedMember ID reformattedState name converted to code+2 more
CLM-416119CLMCamila W Walsh1960-01-13UHC-89214-0277168857682775 Harbor Blvd, Tempe, AZ0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
CLM-402641CLMAnthony Hoffman1977-01-02UHC-25832-74—7546 Main St, Mesa, AZ, 852630.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100513ENRCamila Jacobs1976-08-24UHC-42463-757473538814850 Bayshore Dr, Tempe, AZ, 852860.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60979TPATucker Mei—UHC-96295-4075147223705689 Spring St, Austin, TX, 787920.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-113289ENRRobert Y Hunter1967-12-10UHC-35728-26—399 Broadway Apt 2, Los Angeles, CA, 900400.52SSN last four extractedUnit split from streetEmail lower-casedGender normalised+2 more
ENR-103492ENRKaen B Dixon1993-02-27UHC-52328-184654906522439 Maple Ave Apt 34, Jacksonville, FL, 322290.52Phone reformattedUnit split from streetState name converted to codeGender normalised+2 more
CLM-430386CLMDonna Lawson——8453023316112 Grand Ave Apt 4, Phoenix, AZ, 850300.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
ENR-127574ENRDavid Powell2004-04-27UHC-50609-6292597410021225 Canyon Rd, Austin, TX, 787980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22404PRVRoger U Hawkins2004-10-01UHC-20801-6127687443433171 Harbor Blvd, Plano, TX, 750120.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-55557TPAWilliam Hansen1981-06-28—54167831142079 Jefferson Ave, Austin, TX0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
PRV-21152PRVRyan Jimenez1955-06-10UHC-81271-9227650957532708 Forest Ave Apt 1, Denver, CO, 802940.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418134CLMTeresa Parker1970-03-07——4695 Ocean Ave, Gilbert, AZ, 852350.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-60808TPAPeter Hill1940-12-17—87645941721619 Central Ave # 869, Tucson, AZ, 857810.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-116746ENRNicole Weber2008-04-01UHC-33244-2322630030868660 Broadway Apt 6, Glendale, AZ, 853540.52Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+2 more
ENR-107360ENRWilliam Bradley1964-03-20UHC-33492-5939827530159247 Jefferson Ave, Glendale, AZ, 853490.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-137681ENRJulie Q Simmons1983-02-16UHC-66793-4458172131911667 Canyon Rd, Miami, FL, 331920.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-401790CLMWalter Harris1955-10-03——7654 River Rd, Plano, TX, 750180.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57666TPAEric Bailey1988-04-01——2012 Mountain View Dr, Atlanta, GA, 303150.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-101400ENRThomas West1961-12-16UHC-63916-2854761781075325 Hillcrest Rd Apt 7, Dallas, TX, 752110.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-101601ENRChristian Holmes1958-11-23UHC-16278-74—6194 Meadow Ln, Nashville, TN, 372950.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423105CLMDonald B Weaver1967-07-01——9560 Valley View Dr, Columbus, OH0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-53323TPAHannah Clark1981-05-15——2713 Jefferson Ave, Fresno, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-138998ENRAnna P Andrews2006-02-03UHC-46033-71—1423 Bayshore Dr, Chandler, AZ, 852110.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-26167PRVSam Jones1956-09-12——8027 Union St, Tucson, AZ, 857870.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105074ENRNancy Gibson1957-12-21UHC-64279-7132631822198709 Forest Ave, Chandler, AZ, 852740.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-142368ENRLauren K Willis1968-03-04UHC-50537-87—3496 Ridge Rd, Seattle, WA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-121830ENRStephanie Bell1940-04-27UHC-76947-2121262171583211 Oak St, Tempe, AZ, 852800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121831ENRStephanie Bell1940-04-27UHC-76947-2121262171583211 Oak St, Tempe, AZ, 852800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111791ENRJohnson Randy1986-01-11UHC-51182-5143172927837347 Pine Dr # 974, Jacksonville, FL, 322150.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-111169ENRJoan A Johnston2001-03-18UHC-21549-4469385621738718 Desert Sky Blvd, Miami, FL, 331040.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109011ENR—Junk—UHC-18966-01—2701 Mesa Dr, Tempe, AZ, 852400.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400539CLMAustin Brooks2003-06-19UHC-83271-97—749 Maple Ave, Tempe, AZ, 852610.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-133040ENRMadison Russell—UHC-55697-5124721857797334 Mountain View Dr, Tucson, AZ, 857060.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-136192ENRAlice U Davis2002-06-01UHC-14521-52—6411 Desert Sky Blvd, Miami, FL, 331080.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-124968ENREmily Jimenez1974-01-09UHC-37262-7992174385802840 Spring St, Minneapolis, MN0.52Date of birth reformattedSSN last four extractedState name converted to codeZIP missing+2 more
ENR-125305ENRAustin Clark2007-06-05UHC-09557-64—9803 Washington St # 633, Dallas, TX, 752570.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420696CLMSarah Hill1954-06-20—75350014849678 Market St, Charlotte, NC, 282810.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21661PRVHarold N Ray1946-09-21UHC-61684-71—5887 Jefferson Ave, Phoenix, AZ, 850470.52Middle initial moved out of first nameName re-casedPhone missing area codeStreet suffix standardised+2 more
ENR-135606ENRAustin Perkins1977-06-08UHC-84670-6839770714755500 Union St, Seattle, WA, 981710.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419145CLMSandra D Stephens2004-05-28UHC-87125-33—6751 Elm St Apt 3, Jacksonville, FL0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419144CLMSandra D Stephens2004-05-28UHC-87125-33—6751 Elm St Apt 3, Jacksonville, FL0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 156 of 2,000PreviousNext