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-420968CLMMelissaJunk1998-06-13UHC-73960-39—4529 Grand Ave # 997, Minneapolis, MN, 554920.52Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+2 more
ENR-121560ENRScott Lopez1953-08-14UHC-54516-93—7734 Hillcrest Rd, Tucson, AZ, 857380.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126627ENRSandra X Powell1996-04-25—97585055459548 Main St, Los Angeles, CA, 900260.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
ENR-139115ENRKJunk1940-07-15UHC-71964-5387378102526331 Ocean Ave, Dallas, TX, 752910.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140741ENRAaron Freeman—UHC-00601-67—6995 Oak St, Mesa, AZ, 852160.52Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone missing area code+2 more
CLM-423087CLMSteven P Maldonado1985-04-19——1352 Desert Sky Blvd, Minneapolis, MN, 554780.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-410643CLMRachel Z Patterson1941-11-27——8143 Mountain View Dr, Tampa, FL, 336860.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-117654ENRMatthew Fwler1946-10-15UHC-68471-3366061374105316 Washington St, Chandler, AZ, 852350.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-119223ENRKJunk1971-03-15UHC-94640-273012390145547 Oak St, Plano, TX, 750880.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28861PRVKaren Alexander1975-02-26——6849 Cedar Ln, Nashville, TN, 372540.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-117649ENRJason Johnston1987-07-21UHC-86002-9696556558025392 Highland Ave, San Diego, CA, 921020.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-62013TPAIsabella H Shaw———9248 Park Pl, Las Vegas, NV, 891390.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136096ENRSantiago V Gutierrez1969-07-10UHC-16012-725246898145851 Willow Ct, Dallas, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403492CLMMelissa Brooks1990-06-02UHC-50029-66—72 Park Pl, Sacramento, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
TPA-59257TPAJordan Murphy1986-12-16——621 Indian School Rd, Gilbert, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-117333ENRJunathan O James1965-04-14UHC-64223-13—4591 Mesa Dr, San Antonio, TX, 782880.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-420235CLMKaren Q Ruiz1943-08-01——5995 Sage Ct, Austin, TX, 787820.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-426591CLMGary Fields1988-08-24UHC-65382-80—8600 Willow Ct, Fresno, CA, 937360.52Name split from “Last, First”Member ID reformattedZIP+4 trimmedGender normalised+2 more
PRV-21148PRVDanielle Lynch2000-02-09UHC-65454-97—1905 Elm St, Minneapolis, MN, 554320.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-423726CLMBubby T Colilns—UHC-46738-0124334856378599 Lake View Rd, Tempe, AZ, 852650.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-142015ENRSamuel P Kim—UHC-44901-5762464473933839 Park Pl, Columbus, OH, 432160.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-127520ENRJoran Robinson1979-06-15UHC-00837-84—1116 Washington St, Tucson, AZ, 857850.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
TPA-61796TPAMills Sophia1991-10-20——1708 Union St, Los Angeles, CA, 900850.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-108711ENRMartha S Young—UHC-71458-4022522118215367 Grand Ave, Tucson, AZ0.52Date of birth unreadablePhone reformattedCity re-casedState name converted to code+2 more
TPA-63043TPA—Junk1975-03-16——4120 River Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
ENR-106351ENRAngela G Gordon1989-03-20UHC-91021-02—4781 Pine Dr, Miami, FL, 331080.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123036ENRJennifer Dominguez1988-12-24UHC-64982-19327522690418 Meadow Ln Apt 16, Columbus, OH, 432630.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-103955ENRJuan S Silva1974-10-08UHC-07687-3365128263895111 Mountain View Dr Apt 2, Las Vegas, NV, 891750.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-135733ENRLawrence W Flores2008-06-27UHC-58157-26—7822 Oak St, Los Angeles, CA, 900240.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-427915CLMSarah Perkins1949-06-25——2882 Indian School Rd, Sacramento, CA, 958220.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-109315ENRNatlaie T Moore2005-08-23UHC-14590-35313814566659 Mountain View Dr, Atlanta, GA, 303230.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112129ENRBenjamin Delgado2000-04-14UHC-96396-6375490415077626 Bayshore Dr, Houston, TX, 770960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117643ENRSam N Harris1982-11-16UHC-32799-2940061196446925 Desert Sky Blvd, Scottsdale, AZ, 852700.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109153ENREthan Garza1967-07-06UHC-36481-2273889931552460 Lincoln Way, Tempe, AZ, 852060.52Name split from “Last, First”City re-casedState name converted to codeGender normalised+2 more
CLM-424361CLMPamela Hayes1967-07-20——3336 Valley View Dr, Atlanta, GA, 303250.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-113412ENRChristina Burton1943-07-17UHC-38322-1658534746047991 Mesa Dr, Miami, FL, 331940.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-104913ENRHeather T Walsh1942-10-11UHC-45163-9892130222786927 Oak St, Eden Prairie, MN, 553650.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137458ENRJacqueline F Salazar1945-04-25UHC-37624-7751476559527958 Bayshore Dr # 730, San Antonio, TX, 782390.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-55394TPAKathleen Hill1999-03-18——8010 Oak St, Fresno, CA, 937460.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107264ENRBruce S Rammos1948-03-06UHC-52527-1537949855716296 Main St, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-23348PRVValentina Ortiz1958-09-28UHC-23200-97—2148 Willow Ct, Columbus, OH0.52Name split from “Last, First”State code upper-casedZIP missingGender normalised+2 more
ENR-121251ENRBobby Gray1981-10-12UHC-95919-3555279487236636 Ridge Rd, San Antonio, TX, 782870.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102693ENREmily Z Adams2000-07-22UHC-15907-1346663486589365 Sage Ct # 739, Orlando, FL, 328230.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-114119ENRShirley Armstrong1993-03-18UHC-87313-6626758318725754 Harbor Blvd, San Antonio, TX, 782240.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58762TPAJulie Maldonado—UHC-32095-9436766134602499 Cedar Ln # 572, Tampa, FL, 336550.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137255ENRRussell N Ford1949-11-02UHC-94139-91—5170 Apache Blvd, Jacksonville, FL, 322200.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-60761TPARoy Gilbert1957-01-25——5220 Market St, San Antonio, TX, 782210.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-104545ENRLori N Duncan1965-10-18UHC-77386-40—2740 Oak St Apt 15, Plano, TX, 750930.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-108928ENRRandy L Sandoval1951-11-13UHC-38306-8094435151975598 Canyon Rd, Denver, CO, 802350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-118396ENRNathan Y Howell1991-01-14——3009 Harbor Blvd, San Antonio, TX, 782370.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 190 of 2,000PreviousNext