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
TPA-52110TPATerry Q Watson1949-06-28——9167 Church St, Tampa, FL0.50Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-22914PRVRonald Perez1992-01-17UHC-32632-1240292413568671 Pine Dr # 693, Austin, TX, 787650.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-106460ENRChristina Gomez1971-09-20UHC-11504-2660690015523559 Harbor Blvd, Houston, TX, 770620.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103161ENRBryan Fernendez1985-05-08UHC-38196-0137161411271556 Canyon Rd, Minneapolis, MN, 554320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111107ENRLauren Rberts1985-08-02UHC-80177-29—2732 Palm Dr, Denver, CO, 802160.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-108813ENRGloria E Nichols1998-05-17UHC-58730-814856129268328 Willow Ct # 370, Dallas, TX, 752020.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25249PRVMariana Ryan——78732588292596 Valley View Dr, Plano, TX, 750820.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-131605ENRPriya Ford1969-05-03UHC-66719-8023630448146295 Indian School Rd, Denver, CO0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-139147ENRSara Simpson1949-08-27UHC-10556-5624335464794334 Church St # 863, Tampa, FL0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-413790CLMHenry Dean1970-09-10UHC-91438-57—2175 Jefferson Ave Apt 4, Glendale, AZ, 853470.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-110064ENRChristopher Diaz1940-11-27UHC-69730-9346186523433368 Oak St, Mesa, AZ, 852180.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-426741CLMDanny Powell1981-10-07UHC-81002-4121432766388638 Highland Ave, Glendale, AZ, 853650.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426740CLMDanny Powell1981-10-07UHC-81002-4121432766388638 Highland Ave, Glendale, AZ, 853650.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-100342ENRSofia Woods—UHC-13736-2568648548976262 Forest Ave # 867, Chandler, AZ, 852380.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
CLM-431627CLMSanitago Hoffman1988-02-13UHC-83483-1072450165992511 Harbor Blvd # 508, Orlando, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402972CLMYuki White1954-11-15UHC-76332-1534622366344932 Maple Ave # 361, Denver, CO, 802550.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58098TPAJack Schultz1958-03-23—56963452221433 Union St # 384, Orlando, FL, 328470.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23499PRVHiroshi X Hanson1939-12-11UHC-76924-2494847553776791 Baseline Rd, Minneapolis, MN, 554250.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-55092TPAElizabeth Crawford2002-07-18—61135311276310 Hillcrest Rd, Houston, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24308PRVArjun Johnston1966-02-05UHC-67323-9363198129423085 Forest Ave, Austin, TX, 787630.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-124621ENRAlexis Peyne2003-05-01UHC-10731-0870895134786949 Market St, Columbus, OH0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-124622ENRAlexis Peyne2003-05-01UHC-10731-0870895134786949 Market St, Columbus, OH0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-135115ENRBrian E Stone1973-10-20UHC-93876-6672085770521030 Highland Ave, San Diego, CA, 921380.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413549CLMRachel Richardson1991-01-22——2199 Hillcrest Rd # 533, Denver, CO, 802550.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-103321ENRMartha I Cox1979-02-18UHC-85585-1893490764771474 Oak St, Columbus, OH, 432320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103927ENRAustin Warren2008-07-28UHC-54396-7036981484625121 Mesa Dr Apt 30, Tampa, FL, 336250.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-104519ENRGregory H Gordon1957-03-06UHC-03362-9368493429338156 Mountain View Dr # 815, Tempe, AZ, 852690.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-119305ENRTerry X Cook1972-05-04UHC-61203-5327681744441367 Forest Ave, Fresno, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142701ENRAhmed W Hoffman1991-01-20UHC-79652-32—6488 Desert Sky Blvd # 368, Eden Prairie, MN, 553450.50Name re-casedPhone missing area codeMember ID reformattedUnit split from street+3 more
ENR-136873ENRMegan Z Maqruez1990-06-14UHC-86538-0279646739884790 Washington St # 163, Mesa, AZ, 852380.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136874ENRMegan Z Maqruez1990-06-14UHC-86538-0279646739884790 Washington St # 163, Mesa, AZ, 852380.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103487ENRIsabella E Stone1983-06-14UHC-62989-4178771906357196 Apache Blvd, Scottsdale, AZ, 852450.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
PRV-23623PRVCamila James1946-05-03—90374636376031 Oak St, Eden Prairie, MN, 553540.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-27152PRVWanye Stephens1981-07-10UHC-60073-1047573550748351 Hillcrest Rd # 342, Seattle, WA, 981890.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-131072ENRPhilip U Spencer1953-12-04UHC-13092-606415105709238 Highland Ave, Tempe, AZ, 852690.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423704CLMDoris Barnes1980-03-13UHC-22231-79——0.50Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more
CLM-424668CLMLarry Crawford1982-09-02—72092591628183 Mesa Dr # 601, Scottsdale, AZ, 852640.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25291PRVKimberly R Ortega2000-05-19UHC-66789-55—7148 Sage Ct Apt 17, Jacksonville, FL, 322970.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-405621CLMHirohsi Kennedy———4777 Ocean Ave, Nashville, TN, 372940.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-415558CLMRussell X Burton1948-06-02—33384926965524 Valley View Dr # 484, Seattle, WA, 981520.50Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+3 more
CLM-430613CLMOlivia Rose1995-09-20UHC-69550-0487478126619001 Pine Dr, Tucson, AZ, 857160.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405316CLMSofia Ortiz—UHC-21428-8694446031858551 Market St, Fresno, CA, 937760.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127943ENREmma Hayes1947-11-22UHC-08659-9343861844407363 Cedar Ln, Charlotte, NC, 282150.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408397CLMWilliam Harvy—UHC-66390-2650765324776888 Meadow Ln, Atlanta, GA, 303010.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116863ENREryc Phillips1951-12-09UHC-15080-4166885163138796 Ridge Rd, Seattle, WA, 981490.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136970ENRAmy W Greene1973-10-15UHC-32627-2658786995062894 Canyon Rd, Austin, TX, 787070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403389CLMBrian Castillo1966-06-21——5969 Willow Ct, Austin, TX, 787500.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-425455CLMLaura Obrien2000-08-16——3657 Desert Sky Blvd, Los Angeles, CA, 900290.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-419016CLMReid I Joyce1965-10-13UHC-05392-1034672669793296 Sunset Blvd Apt 29, Scottsdale, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136161ENRKatherine L Palmer1982-02-11UHC-33792-4235374044094419 Camelback Rd Apt 20, Plano, TX, 750470.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 101 of 2,000PreviousNext