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-108669ENRAmber Mejia1973-08-10UHC-47303-9838097041898584 Jefferson Ave # 876, Fresno, CA, 937290.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-129937ENRIsabella Munoz1982-05-16UHC-41188-9993263574064246 Main St # 400, Nashville, TN, 372740.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428018CLMAndrew M James1938-01-24UHC-35033-4776753075557426 Forest Ave, Jacksonville, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109354ENRHenry Jackson1975-09-28UHC-76377-4681392784946258 Forest Ave Apt 7, Columbus, OH, 432540.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404436CLMCharlotte U Day1981-10-02—8648823337948 Valley View Dr, Glendale, AZ, 853030.50Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+3 more
CLM-432362CLMAmy Sanchez1972-07-02UHC-63205-92—7045 Desert Sky Blvd, Sacramento, CA, 958920.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403872CLMAaron Schultz1952-07-11——5848 Bayshore Dr, Los Angeles, CA, 900700.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-426958CLMJoan Sanders2008-11-07—83070964423502 Forest Ave, Chandler, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58137TPAWei Garrett1986-11-10——2747 Harbor Blvd, Seattle, WA, 981690.50Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-134095ENRKathryn Gray1969-12-14UHC-34431-1362346178516391 Camelback Rd, Scottsdale, AZ, 852130.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-400903CLMEmma Z Rogers1970-04-14UHC-12078-576834028241156 Lake View Rd Apt 22, Fresno, CA, 937270.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102710ENRBrian G Hamilton1940-08-14UHC-68025-63—7947 River Rd # 235, Scottsdale, AZ, 852270.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-50087TPASharon Patel1955-09-08——400 Washington St # 136, Chandler, AZ, 852070.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50764TPAFatima Clark1979-03-05——2705 Sage Ct, Minneapolis, MN0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-408311CLMArjun Gibson1957-05-23UHC-37494-6774630641562796 Bayshore Dr, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-405906CLMGregory Webb1977-01-26—5949277879462 Meadow Ln, Miami, FL0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-407383CLMMari S Price1986-05-12UHC-97503-98943708169772 Mesa Dr, Atlanta, GA, 303880.50Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-142051ENRHeather Jones1985-02-01UHC-44914-8236654286581863 Lake View Rd, Phoenix, AZ, 850710.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60044TPAZachary Greene1992-12-26——3732 Palm Dr, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-123054ENRSantiago Jimenez1956-04-15UHC-32526-9396262345926514 Central Ave Apt 28, Chandler, AZ, 852600.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27665PRVJasson Ramirez2005-12-13UHC-29490-8577471867626091 Cedar Ln, Plano, TX, 750290.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102719ENRDiana D Butler—UHC-83959-1034975665071810 Indian School Rd, Scottsdale, AZ, 852940.50Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+3 more
PRV-24733PRVJuan Butler1952-03-08UHC-52359-4535654661794309 Willow Ct Apt 19, Plano, TX, 750310.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57279TPAAhmed P Fiher1986-05-01—505305669944 Elm St, Seattle, WA, 981490.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135782ENRHart S Michelle—UHC-85075-2954899117082271 Lake View Rd, Houston, TX, 770960.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-423577CLMPeter Y Hernandez——88946005737574 Baseline Rd, Gilbert, AZ, 852040.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413459CLMJason Johnston1987-07-21——5392 Highland Ave Apt 30, San Diego, CA, 921020.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
PRV-22685PRVNancy Rios1945-11-03——7547 Highland Ave Apt 19, Columbus, OH, 432860.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-404228CLMWilile N Gonzalez1938-08-11—49975649278463 Indian School Rd Apt 13, Seattle, WA, 981600.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142445ENRJudith V Sandoval1983-09-26UHC-66168-1987224597285058 Lake View Rd, Charlotte, NC, 282040.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60736TPAJoe Bshop1988-10-18—52791546206422 Harbor Blvd, Nashville, TN0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427523CLMJudith Guzman1944-02-20——3680 Church St, Glendale, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-23180PRVKayla Stephens1947-07-20UHC-86478-9680153859152909 Washington St # 771, Miami, FL, 331060.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415966CLMJean Yang1955-02-15UHC-55015-0776830894285899 Main St, Atlanta, GA, 303030.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-110605ENRShirley K Ramirez1978-03-10UHC-48562-2341136178557240 Valley View Dr # 940, Tempe, AZ, 852740.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409771CLMAnn O Jacobs1982-08-04UHC-08255-9759154757065062 Lake View Rd, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21558PRVJohn B Oliver1954-09-26——3713 Lake View Rd, Charlotte, NC, 282260.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-142159ENRJoan P Kelly2000-02-05UHC-83052-1687943058563036 Washington St, Gilbert, AZ, 852080.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-416526CLMCharles Griffin1970-05-26UHC-14601-2361632102339665 Maple Ave, Mesa, AZ0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429888CLMAlan Olson1953-01-19—40322493959036 Ridge Rd, San Antonio, TX, 782010.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-114486ENRAmy N Woods2006-11-16UHC-17540-2761983997663130 Cedar Ln, Seattle, WA, 981420.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405115CLMJesse Carroll1995-04-15UHC-51047-789658492887291 Bayshore Dr, Houston, TX, 770170.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418389CLMMary Fuller1963-10-05UHC-43878-4673867999356246 Church St, Sacramento, CA, 958340.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-409625CLMAnn Kelley1967-01-18——2306 Union St, Scottsdale, AZ, 852360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425312CLMRyan Ruiz1957-02-17——1962 Central Ave Apt 14, Minneapolis, MN, 554690.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25978PRVScott Hughes1958-01-10UHC-53716-2682174851575069 Lincoln Way, Orlando, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-25979PRVScott Hughes1958-01-10UHC-53716-2682174851575069 Lincoln Way, Orlando, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-118383ENRTimothy E Gordon1977-07-23UHC-55444-6986060297443979 Bayshore Dr, Jacksonville, FL, 322880.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-104584ENRCynhtia E Gardner1988-06-20UHC-10851-3532788142333740 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141538ENRDouglas D Cruz1961-04-01UHC-70015-6728179396569571 Baseline Rd, Columbus, OH, 432780.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
100,000 rows, page 102 of 2,000PreviousNext