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-422408CLMJack F Garza1966-10-12UHC-71666-67—363 Bayshore Dr, Las Vegas, NV, 891780.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-423750CLMJulia Myers2001-03-08UHC-12935-9093650676627917 Desert Sky Blvd, Scottsdale, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425992CLMTheresa Cunningham1960-10-09—85689010243066 Indian School Rd, Austin, TX, 787380.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-416161CLMCamila Kennedy1956-10-21UHC-20024-09—8467 Mesa Dr, Seattle, WA, 981440.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416281CLMMegan Mendez1980-08-24UHC-42944-9444231469635609 Forest Ave # 243, Phoenix, AZ, 850100.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407799CLMLisa Berry1993-11-04UHC-31792-15—1455 Harbor Blvd, Minneapolis, MN, 554950.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427989CLMSharon Gilbert2003-05-14——1467 Meadow Ln, Glendale, AZ, 853320.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419662CLMRobert Webb1999-07-16UHC-71122-27—7762 Mountain View Dr, Las Vegas, NV0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-413774CLMAaron Bailey1938-10-12UHC-83010-9634144567063294 Elm St, Eden Prairie, MN, 553250.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412828CLMCharlotte Washington2007-01-27UHC-47321-13—7562 Union St, Seattle, WA, 981720.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-425602CLMMadison Martin1960-07-24UHC-79970-57—1902 Camelback Rd, Denver, CO, 802180.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419020CLMGregory Tucker2003-03-19——8139 Forest Ave, San Diego, CA, 921630.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407495CLMMartha Weaver1978-08-11UHC-63216-91—7449 Jefferson Ave, Scottsdale, AZ, 852260.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416645CLMMarcus Johnston1957-01-12UHC-13149-5042343056557914 Meadow Ln, Las Vegas, NV, 891670.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411271CLMStephanie Hayes1982-06-25——6718 Elm St, Scottsdale, AZ, 852320.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406373CLMOmar Collins2001-09-13UHC-17620-3822922273249690 Hillcrest Rd, Atlanta, GA, 303410.64Name re-casedCity re-casedState name converted to codeGender normalised+2 more
CLM-425015CLMAlan Mendez1999-04-23—27051002809237 Lincoln Way, Las Vegas, NV, 891350.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-412989CLMJeremy Castillo1981-09-28——3847 Grand Ave, Tempe, AZ, 852350.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400116CLMBobby X Silva1965-06-25UHC-38822-20—2830 Main St, Glendale, AZ, 853600.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424896CLMFrank Roberts1982-06-11UHC-23833-1435552310967429 Washington St, Phoenix, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410809CLMNicole Richardson2008-09-22—72570764852529 Canyon Rd, Houston, TX, 770640.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400653CLMArjun Lucas1993-03-09UHC-83630-69—7452 Indian School Rd, Nashville, TN, 372370.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400652CLMArjun Lucas1993-03-09UHC-83630-69—7452 Indian School Rd, Nashville, TN, 372370.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421336CLMRuth Moreno1997-07-27UHC-85063-05—8785 River Rd, Austin, TX, 787270.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407258CLMLucia Butler1997-12-24UHC-64949-99—3810 River Rd, Denver, CO, 802100.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414045CLMSteve L Lawson1974-09-03UHC-40167-9789421148025405 Valley View Dr, Denver, CO, 802440.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408363CLMAlbert Herrera1979-02-01UHC-78925-85—5972 Baseline Rd, Charlotte, NC, 282210.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-402102CLMJordan Brton1954-08-28—97866687288433 Washington St # 906, Tempe, AZ, 852880.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-404887CLMJordan Ramirez1995-11-26UHC-27987-2780456729971597 Harbor Blvd, Mesa, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404942CLMRussell F Morales1969-02-22—25432280094402 Desert Sky Blvd # 269, Tucson, AZ, 857440.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-414392CLMGregory Cruz2004-09-18—63966169778123 Hillcrest Rd, Denver, CO, 802410.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427979CLMAbigail Rios1979-05-26UHC-06532-9279578946525815 Bayshore Dr, San Antonio, TX, 782960.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-410772CLMAbigail Johnston2002-06-09UHC-13519-75—5319 Meadow Ln, Dallas, TX, 752350.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425749CLMSaar Robertson1962-04-12UHC-65179-24—910 Forest Ave, Phoenix, AZ, 850050.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411316CLMBetty Rojas1976-12-27UHC-59588-7925337744683322 Hillcrest Rd, Sacramento, CA, 958310.64Name re-casedPhone reformattedState name converted to codeGender normalised+2 more
CLM-427737CLMLucia Huughes1939-07-22UHC-07805-0637259766543294 Lake View Rd, Atlanta, GA, 303450.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405431CLMWalter Espinoza1976-05-06UHC-40017-5550959321839590 Bayshore Dr # 323, Gilbert, AZ, 852290.64Name re-casedPhone reformattedMember ID reformattedUnit split from street+2 more
CLM-403676CLMGerald Ford1951-09-22UHC-48495-3751886593896239 Oak St, Phoenix, AZ, 850530.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420797CLMJack Kelley1960-05-05——6336 Spring St, Austin, TX, 787360.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-420798CLMJack Kelley1960-05-05——6336 Spring St, Austin, TX, 787360.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-409595CLMIsabella Parker1955-02-11UHC-22975-41—3506 Grand Ave, Glendale, AZ, 853390.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400978CLMCamila Rogers2004-02-15—8248373567811 Hillcrest Rd, Miami, FL, 331030.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413470CLMAnan Carr1972-11-13—45131872757558 Central Ave, Phoenix, AZ, 850250.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425936CLMKaren Romero1986-03-19UHC-81131-34—6696 Spring St, Denver, CO, 802760.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412283CLMKathleen A Bryant1993-08-19UHC-97131-90—5236 Mesa Dr, Scottsdale, AZ, 852880.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-427958CLMTersea Henry1938-05-12UHC-74516-29—1546 Hillcrest Rd # 168, San Antonio, TX, 782830.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414826CLMLucia Smith—UHC-11040-64—2181 Forest Ave, Houston, TX, 770070.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412218CLMNoah Walch1978-12-12UHC-89604-2888936051244394 Pine Dr, Denver, CO, 802450.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-428917CLMDonald Cooper1988-03-11—57569871064619 Central Ave, Los Angeles, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427558CLMBeverly Gonzalez1944-06-04UHC-21342-60—8147 Jefferson Ave, Plano, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
32,829 rows, page 124 of 657PreviousNext