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
PRV-25981PRVJose Griffin1973-12-16UHC-35738-0194048606014251 Mountain View Dr, Atlanta, GA, 303030.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-112937ENRMatthew E Jones2002-04-11UHC-71563-08—9898 Valley View Dr, Los Angeles, CA, 900440.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-123947ENRDiana H Lopez1990-12-20UHC-00021-6567666348457282 Sunset Blvd, Tempe, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102791ENRStephanie Allen1994-06-12UHC-95154-6530088668366831 Oak St, Dallas, TX, 752590.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-107039ENRSandra A Dixon1966-11-08UHC-02208-336462029251648 Union St, Mesa, AZ, 852670.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414672CLMGrace E Cole1972-04-15——8933 Meadow Ln # 456, Glendale, AZ, 853990.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408845CLMAaron Andrews——53387952386597 Church St, San Diego, CA, 921700.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411817CLMJason Robinson1978-02-06—52952199823577 Lake View Rd, Atlanta, GA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-425018CLMAlan Ferguson1942-03-01——8978 Grand Ave, Eden Prairie, MN, 553620.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-130976ENRChristine Wright1955-03-17UHC-12937-8991742926641177 Hillcrest Rd, Chandler, AZ, 852770.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117842ENRAlice P Bowman1941-10-04UHC-07682-1878793533916661 Main St, Houston, TX, 770400.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424570CLMEugene Nichols1980-03-11——1911 Palm Dr, Phoenix, AZ, 850310.52Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more
ENR-111683ENRMarilyn T Richads1995-06-26UHC-52260-3190798416312627 Church St, Denver, CO, 802400.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-137201ENREugene V Watkins1965-11-24UHC-59440-0165626185815076 Elm St # 250, Denver, CO, 802950.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51701TPAMargaret Kelley———6289 Jefferson Ave, Las Vegas, NV, 891380.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57171TPAValentina Harvey1979-04-11——3650 River Rd, Austin, TX, 787590.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63705TPAMadison Spencer1973-01-18—94899719188387 River Rd, Denver, CO0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62607TPAMichael Johnston1994-08-25——9651 Ocean Ave, Charlotte, NC, 282510.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58647TPACarolyn Gordn1956-11-16UHC-62649-12—5433 Desert Sky Blvd, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51736TPADiana Russell1999-01-05——3778 Apache Blvd, Tempe, AZ, 852280.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59407TPAJeffrey X Prk1938-06-15——5894 Pine Dr, Chandler, AZ0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
ENR-142483ENRCharlie A Nunez1953-05-25UHC-42084-7186271042831663 Mesa Dr, Seattle, WA, 981790.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423827CLMAndrea Guzman1992-05-15——4778 Sage Ct, Tucson, AZ, 857730.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53833TPARandy Thompson1994-11-20——4277 Elm St, Houston, TX, 770810.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425246CLMMartha Watson1976-12-23UHC-66588-79—6159 Union St, Eden Prairie, MN, 553650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-112867ENRZachary Hill1958-01-15UHC-33929-5225395707307404 Market St # 840, Sacramento, CA, 958050.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-102733ENRGreg Chen—UHC-87310-18—8242 Canyon Rd, Mesa, AZ, 852800.52Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+2 more
ENR-122681ENRKathryn L Burke1952-10-06UHC-37727-0588550543405009 Grand Ave, Glendale, AZ, 853940.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-125182ENRGregory Morgan1943-01-06UHC-49778-4785388465403106 Harbor Blvd, Denver, CO0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-113499ENRWatkins Maria1943-09-15UHC-30542-2797965420267679 Central Ave, Tampa, FL, 336660.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-128139ENRNoah S Torres1979-09-16UHC-06965-0471991179892460 Grand Ave, Eden Prairie, MN, 553250.52Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedMember ID reformatted+2 more
ENR-111534ENRCarol James1950-05-14UHC-38761-26—34 Sage Ct Apt 39, Scottsdale, AZ, 852090.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415452CLMLawrence O Richards———6040 Main St, Columbus, OH, 432360.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-427637CLMRoy G Burns1996-01-06UHC-22217-24—1170 Church St, Denver, CO, 802960.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-125606ENRMargaret Bishop1983-09-08UHC-24206-49—9864 Maple Ave, Eden Prairie, MN, 553000.52Name split from “Last, First”Date of birth reformattedPhone missing area codeSSN last four extracted+2 more
ENR-103974ENRJean Santiago1943-08-12UHC-49960-8757866132423517 Highland Ave, Los Angeles, CA, 900380.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418171CLMAhmed Adams2001-12-06UHC-61442-8264222621153121 Union St, Las Vegas, NV, 891390.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-417545CLMWalter D Moreno1939-07-01UHC-84396-39—597 Elm St, Denver, CO, 802620.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-403425CLMJessica Burns2007-05-20UHC-28147-73—8189 Sage Ct, Seattle, WA, 981140.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-130254ENRSamantha Dean2004-11-26UHC-17723-1875556637978064 Indian School Rd, Dallas, TX, 752800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418506CLMEmma Parker1938-04-22—63263641473226 Spring St, Tucson, AZ, 857180.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55887TPAEric Jenkinns2004-02-27—40142514838967 Pine Dr, Nashville, TN0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25343PRVAbigail Owens1964-11-24UHC-36998-8887546491449000 Valley View Dr Apt 35, Chandler, AZ, 852470.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-21961PRVNoah Nguyen1976-10-23UHC-84004-0996239493412884 Lake View Rd Apt 7, Gilbert, AZ, 852450.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120827ENRDiane Snyder—UHC-68765-3660828704963890 Cedar Ln, Plano, TX, 750810.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425732CLMAmber Jordan1985-02-17UHC-29175-45—1088 Sunset Blvd, Seattle, WA, 981860.52Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+2 more
ENR-133295ENRKaren Q Clark2007-12-06UHC-47593-4556473926001136 Baseline Rd, Los Angeles, CA, 900840.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-142498ENRTerry Q Hill—UHC-63505-057094435864212 Washington St, Seattle, WA, 981450.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413941CLMAlbert Marsshall1991-07-04—21967059398011 Maple Ave # 643, Plano, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27951PRVJohn Z Bryant1951-11-03—62784749469217 Elm St, Orlando, FL0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
100,000 rows, page 172 of 2,000PreviousNext