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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-423121CLMRaymond J Turner1999-09-09UHC-94522-57—321 Grand Ave, Denver, CO0.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-420892CLMBenjamin Collins2004-03-16—72771703031636 Apache Blvd, Tucson, AZ, 857570.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418487CLMJulia Perkins1945-03-26—58998824355328 Washington St, Tempe, AZ, 852690.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-405528CLMDenise Dunn1954-05-11—37971970485263 Sunset Blvd, Tempe, AZ, 852390.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430055CLMPriay T Fuller1952-07-13UHC-15580-0967647209488743 Maple Ave, Minneapolis, MN, 554040.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403146CLMFatima Jones1965-05-13UHC-49631-4694982519168055 Harbor Blvd, Seattle, WA, 981670.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-408846CLMAaron Andrews2007-04-08UHC-76478-8053387952386597 Church St, San Diego, CA, 921700.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414572CLMLaura Ross2006-09-14——6409 Camelback Rd, Scottsdale, AZ0.64Street suffix standardisedAddress re-casedZIP missingPlan code upper-cased+2 more
CLM-413460CLMNatalie Wang1942-05-17UHC-03089-1634850641435516 Market St, Austin, TX, 787860.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432094CLMDeborah Q Murray1968-11-04—68242044051166 Park Pl # 806, Las Vegas, NV, 891990.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425258CLMMariana Campbbell2008-05-15UHC-28563-6373128950582470 Palm Dr, Minneapolis, MN, 554000.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422665CLMSean I Watkins1969-09-15UHC-94342-84—9284 Ridge Rd, Seattle, WA, 981910.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408769CLMShaw Vincent1984-04-27UHC-60140-357722673629—0.64Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-420134CLMDennis Woods1967-11-24——3112 Sunset Blvd, Eden Prairie, MN, 553280.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422707CLMZachary Olson1993-09-06UHC-00455-39—592 Jefferson Ave, Charlotte, NC, 282810.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425008CLMMaason Bradley1986-07-19UHC-43681-03—2852 Apache Blvd, Minneapolis, MN, 554140.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-425628CLMLuis Green1964-04-24——873 Indian School Rd, Fresno, CA, 937830.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409383CLMAnna S Carlson1992-01-24UHC-22854-38—2529 Sunset Blvd, Gilbert, AZ, 852520.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414622CLMArthur Myers1978-05-10UHC-40907-37—3245 Indian School Rd, Jacksonville, FL0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-428248CLMMaria Dean—UHC-57338-0630785971757959 Harbor Blvd, Sacramento, CA, 958120.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-432297CLMSara Wood—UHC-68954-8778344119443466 Oak St, Austin, TX, 787220.64Date of birth missingMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427606CLMFrances V Cammpbell1992-09-16UHC-98486-22—94 Washington St, Austin, TX, 787170.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403601CLMMary K Rogers1943-04-11UHC-81130-6647681945883310 Washington St, Scottsdale, AZ, 852020.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401213CLMLerry Delgado1979-01-19UHC-13396-91—1290 Cedar Ln, Denver, CO, 802220.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427268CLMKyle Myers1982-10-21——2974 Ridge Rd, Mesa, AZ, 852110.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-423222CLMWilliam Knight1940-02-10UHC-41179-033535879695267 Grand Ave, Los Angeles, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422115CLMChristian Ortega1968-11-12UHC-71636-16—2074 Forest Ave, Houston, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-414087CLMTyler Adams1959-02-25—55236711902455 Lake View Rd, Mesa, AZ, 852440.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419401CLMEdward Green1963-11-19——277 Mesa Dr, Jacksonville, FL, 322590.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426287CLMShirley U Crawford1962-08-09UHC-23349-84—9043 Jefferson Ave, Denver, CO, 802070.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425826CLMAhmed Barnes1943-05-04——1236 Spring St, Nashville, TN, 372640.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408096CLMEugene Hughes2008-02-10——2894 Camelback Rd Apt 19, Plano, TX, 750050.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432361CLMAmy Sanchez1972-07-02UHC-63205-92—7045 Desert Sky Blvd, Sacramento, CA, 958920.64Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+2 more
CLM-401581CLMArthur Austin1977-04-03UHC-81712-05—5085 Oak St # 313, Phoenix, AZ, 850440.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411588CLMJuan Jordan2000-07-03UHC-43301-6632652911277107 Jefferson Ave, Plano, TX, 750640.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-415523CLMBruce Reynolds1945-07-01UHC-33418-9633258313358688 Apache Blvd, Glendale, AZ, 853820.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427968CLMBen Z Cunninghm1961-09-18——5415 Mountain View Dr, Chandler, AZ, 852460.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-419476CLMOlivia Dunn1956-09-23—25051112447987 Central Ave # 306, Columbus, OH, 432350.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
CLM-409230CLMJoe Castillo1971-02-06—62459480614630 Church St, Tampa, FL0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400114CLMNancy Patel1982-05-17——5592 Oak St, Tucson, AZ, 857350.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401987CLMStephen Garza1947-12-11——9896 Ridge Rd, Orlando, FL, 328630.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421611CLMBrandon Mason1970-07-13UHC-65028-1260152781051350 Elm St, Scottsdale, AZ, 852790.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419572CLMEugene Perez1995-04-11——7968 Baseline Rd, Chandler, AZ, 852440.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422937CLMKathryn U Cooper1979-09-21UHC-84332-55—2370 Ridge Rd, Mesa, AZ, 852150.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422488CLMPaul Vazquez1995-01-08UHC-55634-1097826203494886 Lake View Rd, Plano, TX, 750850.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416711CLMAmber Graene1965-07-14UHC-66959-32—5664 Market St, Glendale, AZ, 853020.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429912CLMJoshua Castor1977-01-11—70549163737336 Sunset Blvd Apt 31, Charlotte, NC, 282430.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413696CLMStephanie Castillo1999-07-09UHC-57276-27—6638 Grand Ave, Houston, TX, 770350.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-418427CLMKatherine Wells1960-06-09UHC-87823-7875454845722093 Hillcrest Rd, Gilbert, AZ, 852540.64Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-406050CLMJohn Delgado1990-07-14UHC-78053-8164783501269808 Market St, Sacramento, CA, 958730.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 125 of 657PreviousNext