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, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-404200CLMDebra Lawosn1939-08-19UHC-10156-1698042912478452 Forest Ave, Miami, FL, 331900.68Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased
CLM-415322CLMWayne Jackson1952-12-22UHC-06505-43—4411 Willow Ct # 221, Dallas, TX, 752900.68Unit split from streetEmail lower-casedGender normalisedPlaceholder values cleared
CLM-404630CLMJacqueline Bailey1939-06-16——6908 Park Pl Apt 2, Las Vegas, NV, 891690.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406479CLMEmily Austin1958-02-05——3924 Mountain View Dr, San Antonio, TX0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-412422CLMKenneth George1945-10-13UHC-44938-15—8887 Pine Dr, Tucson, AZ, 857490.68Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed
CLM-400288CLMRyan Howard1986-10-19——6529 Mesa Dr, Las Vegas, NV0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-425271CLMBruce U Evans1946-06-09—41194565142759 Spring St, Charlotte, NC, 282040.68Name split from “Last, First”Phone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-422944CLMKevin Black1985-10-13——3054 Lake View Rd, Miami, FL0.68Street suffix standardisedAddress re-casedCity re-casedZIP missing
CLM-422715CLMAlbert Hughes1942-06-20UHC-56108-8426250171626509 Apache Blvd # 517, Tucson, AZ, 857100.68Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-422288CLMMartha Z Parker1991-09-26UHC-73620-42—236 Market St, Glendale, AZ, 853470.68Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-405241CLMDorothy K Moreno1944-06-07UHC-95806-45—4861 Washington St, Gilbert, AZ0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-411156CLMDylan Palmer2003-10-15UHC-54824-7685929105322321 Mesa Dr, Chandler, AZ, 852780.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-425618CLMPhilip White1992-10-23UHC-56598-37—208 Washington St, Gilbert, AZ, 852800.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-408628CLMTheresa Munoz1941-06-25UHC-11208-808789573749—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-419342CLMDick Boyd1957-09-01——7982 Central Ave, Glendale, AZ, 853370.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-416334CLMAlbert Parrk1974-02-02UHC-34842-61——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-409023CLMMaria Q Hansen1939-04-07——1426 Washington St, Seattle, WA, 981390.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
CLM-406337CLMAnn Rose1941-12-19UHC-35859-97——0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-417178CLMBrian Elliott1941-06-17UHC-25263-9791661845924640 Harbor Blvd, Mesa, AZ, 852460.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-422384CLMTeresa Gonzales1942-04-21UHC-97031-3321523479457497 Park Pl, Austin, TX, 787160.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-432249CLMAlan S Lynch1959-07-02UHC-97250-4538392266007020 Elm St # 345, Orlando, FL, 328860.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
CLM-405805CLMSmuel Wilson—UHC-53403-90——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-421539CLMFrances Ruiz1994-03-16—38179427299212 Main St, Atlanta, GA0.68ZIP missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-423952CLMAnn Reed1969-04-14UHC-75559-79——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-427103CLMJoseph Gonzales—UHC-00602-46—8030 Elm St, Houston, TX, 770740.68Name re-casedDate of birth missingEmail lower-casedGender normalised
CLM-408197CLMLuna Brenda—UHC-89078-96—1396 Palm Dr, Tampa, FL, 336930.68Date of birth missingState code upper-casedZIP+4 trimmedPlaceholder values cleared
CLM-403484CLMSarah Welch1949-09-22UHC-83510-34—8987 Sage Ct, Phoenix, AZ, 850720.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-423177CLMKelly B Lucas1947-12-15UHC-15635-05—6413 Meadow Ln, Seattle, WA, 981180.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-403759CLMJonathan Valdez1938-07-06UHC-09612-4044581088771279 Bayshore Dr, Nashville, TN, 372860.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-414821CLMJack Salazar—UHC-24125-50——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-428442CLMTeresa Spencer1995-05-10UHC-23682-43—5215 Grand Ave, San Diego, CA, 921200.68SSN last four extractedCity re-casedGender normalisedPlaceholder values cleared
CLM-426325CLMGloria Guzman1939-05-23UHC-99703-83—5838 Pine Dr, Glendale, AZ, 853940.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-416953CLMOlivia Padilla2001-03-03UHC-79554-60—847 Market St # 623, Tempe, AZ0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
CLM-413265CLMWalter Bowman1954-11-01UHC-19722-01—137 River Rd, Phoenix, AZ, 850370.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-403888CLMHenry Tran—UHC-54488-12—4058 Palm Dr, Miami, FL, 331240.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422122CLMFieds Mark———3207 Sunset Blvd, Jacksonville, FL, 322240.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-418085CLMLucia Montgomery1947-12-09——2513 Harbor Blvd, Houston, TX, 770840.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429494CLMJanet Crawford1995-06-21UHC-27024-93—4430 Mountain View Dr, Dallas, TX, 752420.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404660CLMScott F Bradley1952-02-24UHC-01675-10—1227 Lincoln Way, Mesa, AZ, 852240.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
CLM-407775CLMDavid Marsall2008-01-19UHC-85434-85—4602 Forest Ave Apt 22, Atlanta, GA, 303890.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432011CLMDoris Nunez1959-06-20UHC-49736-25—4509 Jefferson Ave, Miami, FL, 331470.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429350CLMBeverly Ortega1950-07-16UHC-09931-26—830 Bayshore Dr, Dallas, TX, 752090.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409917CLMGerald Collins2008-05-28UHC-51890-28—4668 Oak St, Glendale, AZ, 853810.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401816CLMRussell Herrera1993-02-03———0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-417958CLMWayne Silva2005-02-18UHC-07518-90—3386 Union St, Orlando, FL, 328170.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-402670CLMGary Ryan1948-02-13UHC-57701-744496817231—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-414235CLMLori Austin2003-07-23——500 Camelback Rd, San Diego, CA, 921210.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-417164CLMJoyce Q Medina1948-12-10UHC-72617-6497429148139324 Jefferson Ave, Atlanta, GA, 303210.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-426982CLMCatherine Wheeler1952-10-07UHC-48380-89—3516 Harbor Blvd, Tampa, FL, 336960.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-412891CLMCarlos Stone1962-07-04UHC-66575-7538669867953805 Spring St, Glendale, AZ, 853920.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
32,829 rows, page 199 of 657PreviousNext