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

Claims, flag “Date of birth reformatted”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth reformattedClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-426865CLMBrandon Y Carter2005-03-20—8194536129—0.94Name re-casedDate of birth reformattedWhitespace trimmed
CLM-404514CLMMichelle Garcia1983-10-18UHC-55128-0357089113191151 Lake View Rd, Dallas, TX, 752720.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418250CLMSharon Mendoza1971-11-23—7394275559—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-400135CLMKayla Rodriguez1983-11-15UHC-42876-2468979806685184 Valley View Dr, Tucson, AZ, 857800.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-424827CLMElizabeth O Nunez2008-08-01—4068718195—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-426867CLMAndrea Mendoza1939-05-07—48548776443886 Sunset Blvd, Scottsdale, AZ, 852340.94Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-414512CLMJesse Collins1987-04-01UHC-94206-2171459174627476 Grand Ave, Columbus, OH, 432120.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-409665CLMTimothy Welch1945-03-03UHC-08254-58——0.94Date of birth reformattedPlan code upper-casedPlaceholder values cleared
CLM-423895CLMAhmed Jordn1957-09-07UHC-80312-48——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-426789CLMJessica P Gutierrez1962-02-16UHC-81735-61——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-411820CLMLuis Freeman1971-07-10UHC-37508-057343224943—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-428520CLMSara Weber1959-06-17UHC-49142-89—4702 Meadow Ln, Plano, TX, 750890.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-424876CLMAlice Cruz1974-09-13UHC-21043-26——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-403373CLMRachel K Hughes1969-06-06UHC-06997-78——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-406574CLMLucia Vargas1964-12-27UHC-14079-98—3420 Broadway, Jacksonville, FL, 322520.94Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-417267CLMRebecca Chavez1986-12-03UHC-60022-24——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-409098CLMLuis Greene2000-06-15UHC-14290-025998528539—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-424953CLMDouglas Wood1992-03-05UHC-08504-80——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403237CLMRichard Luna1986-01-18———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-412046CLMMichael Bishop1941-05-08UHC-40617-3924785812565310 Lincoln Way, Tempe, AZ, 852310.94Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-416759CLMWalter W Black1952-02-19UHC-18775-668207711302—0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-430264CLMMei Reid1977-09-04UHC-17477-15—7400 Meadow Ln, Eden Prairie, MN, 553820.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-416127CLMSarah V Williams1968-12-10UHC-67864-43——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418021CLMJessica Gordon1965-09-14UHC-38164-219532635493—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-431741CLMLinda White1948-03-14UHC-00454-47——0.94Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-426250CLMKevin Brooks1995-12-17——7454 Valley View Dr, Columbus, OH, 432050.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-407830CLMEmily Simpson2006-08-20UHC-45607-98—7381 Canyon Rd, Jacksonville, FL, 322930.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-401151CLMDeborah Dominguez1997-08-06UHC-62481-8397659300128593 Canyon Rd, Phoenix, AZ, 850490.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-429372CLMMichelle Lynch1944-05-17UHC-79929-168346145726—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-414731CLMAlbert Marquez2003-09-12—62566998339035 Pine Dr, Fresno, CA, 937650.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-429101CLMBrenda Phillips1961-06-05UHC-75690-49——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417826CLMAshlye S Bradley1956-04-18—9799207989—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-421043CLMEmily R Gonzalez1984-06-09—8459956614—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-423963CLMAisha Gilbert1971-08-08UHC-36576-925039566880—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-409888CLMPeter Vazquez1992-08-09——5777 Oak St, Phoenix, AZ, 850890.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428978CLMJulia Ramos1978-01-19——4618 Washington St, Las Vegas, NV, 891750.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-431564CLMJerry Torres1947-01-12UHC-90769-883712961543—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-412599CLMGabriel Owens1978-10-24UHC-71828-02——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-408079CLMMarcus Scott2003-02-20UHC-58921-89—2530 Harbor Blvd, Mesa, AZ, 852520.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-401158CLMTerry Fox2007-08-14UHC-25927-17—5658 Maple Ave, Las Vegas, NV, 891810.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-402002CLMDonald Y Grant1977-04-14—94680356611926 Valley View Dr, Gilbert, AZ, 852700.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-402001CLMDonald Y Grant1977-04-14—94680356611926 Valley View Dr, Gilbert, AZ, 852700.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-417769CLMSusan Burns2000-04-10—2033783493—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-421396CLMPaul Harris1943-10-08UHC-51958-958025082809—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-411825CLMWillie V Black2001-09-22UHC-22972-70—4399 Sunset Blvd, Tucson, AZ, 857890.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-423055CLMTeresa Chavez1980-12-08UHC-91472-66——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-429891CLMLogan Payne1986-04-08UHC-81447-44——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-423921CLMHelen Peters1941-05-16UHC-13869-39—7041 Ridge Rd, Scottsdale, AZ, 852680.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-421397CLMNathan Martin1993-02-17UHC-79747-5136322108833231 Central Ave, Las Vegas, NV, 891200.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-405730CLMRandy Franklin1939-02-21UHC-11089-40—8402 Canyon Rd, Scottsdale, AZ, 852460.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
10,559 rows, page 194 of 212PreviousNext