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-411970CLMNiocle Vasquez1951-02-03——1687 Mesa Dr Apt 33, Scottsdale, AZ, 852580.68Date of birth reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-414467CLMBill Allen1953-06-12UHC-46233-87—430 Highland Ave, Dallas, TX, 752670.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409047CLMKathryn S Morris1945-10-13UHC-54409-02—2221 Forest Ave, Jacksonville, FL, 322340.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-412787CLMVincent Mitchell2004-07-10—3315801080—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410088CLMHelen Guzmman1977-07-25UHC-62092-104839340028—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-424338CLMKimberly Sandoval1942-08-19UHC-46976-6585987918764288 Pine Dr, Mesa, AZ, 852820.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-400802CLMRandy Sanchez1962-01-09UHC-91481-56—3993 Elm St, Chandler, AZ, 852180.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-406503CLMLawrence Mitchell1940-07-19UHC-30433-13—5724 Hillcrest Rd, Columbus, OH0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-429914CLMSusan Perry1946-01-03——8796 Camelback Rd, Eden Prairie, MN, 553090.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-421293CLMJoseph Stephns1975-05-21UHC-66802-91—1800 Willow Ct, Miami, FL, 331110.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-419597CLMValentina Santiago1993-10-02UHC-48471-74——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-407027CLMAndrew Woods1973-11-16UHC-68285-69—872 Union St, Gilbert, AZ, 852500.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-411532CLMLogan Collins1944-12-21UHC-11070-99—9814 Pine Dr, Las Vegas, NV, 891370.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-403694CLMJanice Ramirez1973-02-17UHC-60736-65—4673 Sunset Blvd, Eden Prairie, MN, 553580.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-408925CLMBarbara Austin1954-11-01UHC-00126-43—7031 Market St, Orlando, FL, 328870.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-408331CLMRebekca Wilson1982-12-21—82630802613284 Valley View Dr, San Antonio, TX, 782890.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-418886CLMRussell Valdez1968-04-09UHC-94337-10——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-410239CLMEdward E Wright1961-02-17UHC-28582-36——0.68Name split from “Last, First”Middle initial moved out of first nameWhitespace trimmedPlaceholder values cleared
CLM-411364CLMBradley R Meyer1978-02-03UHC-39806-7680578397312160 Central Ave, Jacksonville, FL, 322360.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-413264CLMWillie Hicks1962-04-17——6951 Palm Dr, Mesa, AZ, 852460.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418927CLMAaron Cox1973-07-25——4580 Elm St, Mesa, AZ, 852010.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-415043CLMMei Harvey1985-04-19—98589839212393 Cedar Ln, Nashville, TN, 372120.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-414414CLMLawrence Garza1959-12-26UHC-96175-05—4747 Palm Dr, Minneapolis, MN, 554230.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425129CLMGray Joshua1994-04-12UHC-40679-05—1373 Lincoln Way, Sacramento, CA, 958720.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410725CLMEthan Jacobs1943-12-05UHC-87152-417244354459—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-420545CLMOmar Lopez1969-11-17UHC-67709-818007005328—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-428123CLMDylan Day1946-11-15UHC-32420-88—8287 Central Ave, Gilbert, AZ, 852750.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409722CLMJonathan Patel1961-12-21UHC-08496-08—4336 Desert Sky Blvd, Glendale, AZ, 853810.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406781CLMBilly Perez1978-10-05—2562963049—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-411249CLMJulie Wright1956-04-09——1200 Meadow Ln, San Diego, CA, 921310.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419921CLMDouglas Wang1938-02-04——566 Pine Dr, San Diego, CA, 921450.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411587CLMBenjamin Tran2006-06-02UHC-32488-0957070602763043 Church St, Glendale, AZ, 853050.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405199CLMLinda Peterson1992-10-04UHC-87559-0761086053169153 Lake View Rd, Dallas, TX, 752110.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-412025CLMDiego Kennedy1961-05-03UHC-16765-65—9183 Apache Blvd, Austin, TX, 787830.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-407111CLMPamela Mitchell1997-11-08UHC-76970-81—5418 River Rd Apt 26, Phoenix, AZ, 850730.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415273CLMKimberly Marquez1942-05-15—90423025441432 Valley View Dr # 146, Las Vegas, NV, 891700.68Unit split from streetEmail lower-casedGender normalisedPlaceholder values cleared
CLM-418046CLMJoseph Hunt1983-12-06——4149 Central Ave, Austin, TX, 787100.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-429992CLMArthur Nichols1942-09-26UHC-48023-89—1576 Mountain View Dr, Columbus, OH0.68ZIP missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-418833CLMHenry Scott1959-07-01——6046 Baseline Rd # 381, Denver, CO, 802680.68Name re-casedTwo-digit birth yearUnit split from streetPlaceholder values cleared
CLM-431578CLMPamela Woods1997-01-27UHC-24441-51—5461 River Rd, Sacramento, CA, 958880.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-408714CLMVincent Gordon1973-01-03———0.68Name split from “Last, First”Gender normalisedPlan code upper-casedPlaceholder values cleared
CLM-405925CLMNicole Z Johnston1953-04-09—52547851635609 Lincoln Way, Charlotte, NC, 282970.68Middle initial moved out of first namePhone reformattedGender normalisedPlaceholder values cleared
CLM-411654CLM—Junk1980-08-17UHC-69832-38—2735 Bayshore Dr, Mesa, AZ, 852790.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
CLM-410412CLMTeresa Myers1966-05-12——3439 Pine Dr # 847, Tucson, AZ, 857630.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410728CLMJose Weber1957-04-10UHC-75597-59—1799 Sage Ct, Tempe, AZ, 852810.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-403085CLMCharlotte Rogers1974-05-26——1968 Cedar Ln, Columbus, OH, 432990.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-400073CLMValentina D Warren1959-11-17UHC-64240-81—9049 Maple Ave, Dallas, TX, 752250.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406591CLMMateo Castro1969-09-04UHC-93344-27—8933 Bayshore Dr, Mesa, AZ, 852780.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-406514CLMVirginia Berry1960-09-23——6980 Canyon Rd, San Diego, CA, 921970.68Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-420065CLMAndrea Kim1945-04-05UHC-46800-07——0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
32,829 rows, page 201 of 657PreviousNext