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-413495CLMSnadra Q Murphy1982-09-27UHC-50635-15—2648 Mesa Dr, Minneapolis, MN, 554240.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-425049CLMMark Johnson1989-09-14UHC-68075-73—3957 Willow Ct, Scottsdale, AZ, 852650.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428404CLMJulie Evans1989-03-18—31475882138423 Main St, Plano, TX, 750540.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405481CLMMegan Reynolds1954-09-13UHC-83388-10—9684 Highland Ave Apt 14, Dallas, TX, 752530.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419969CLM—Junk1950-01-23UHC-98453-38—1973 Harbor Blvd, Glendale, AZ, 853850.64Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+2 more
CLM-403500CLMJohn Contreras1980-02-28UHC-95942-06—2831 Baseline Rd, Miami, FL, 331400.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-432742CLMJoan Weber1973-06-08UHC-20455-78—9509 Park Pl, San Diego, CA, 921530.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422022CLMChristina Graham2000-01-21UHC-41760-0375545389296748 Camelback Rd, Jacksonville, FL, 322500.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-402919CLMBen M Greene1994-06-08UHC-36280-57—1364 Oak St, Dallas, TX0.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415522CLMBruce Reynolds1945-07-01UHC-33418-96—8688 Apache Blvd, Glendale, AZ, 853820.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414645CLMBrittany Harvey1969-03-05——862 Willow Ct, Tempe, AZ, 852480.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426461CLMHeather X Long1969-11-19—81058213621715 Camelback Rd, San Antonio, TX, 782640.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429811CLMLiz Ryan1990-03-12—91049777789835 Park Pl, Eden Prairie, MN, 553700.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-410185CLMSaarh D Crawford——74388500921934 River Rd, Eden Prairie, MN0.64Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more
CLM-403227CLMYuki Richardson1982-02-08UHC-64259-1061443306882434 Forest Ave, Eden Prairie, MN, 553400.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412351CLMHarold Rogers2005-10-15UHC-54307-35—955 Lake View Rd, Eden Prairie, MN, 553010.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412350CLMHarold Rogers2005-10-15UHC-54307-35—955 Lake View Rd, Eden Prairie, MN, 553010.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404902CLMGerald Cox1971-10-05UHC-87483-13—5111 Canyon Rd, Plano, TX, 750440.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422330CLMCharles Cook1998-06-25—51022794297590 Harbor Blvd # 368, San Diego, CA, 921740.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428171CLMMegan Prez1984-12-22UHC-14015-2844848116641460 Bayshore Dr, Miami, FL, 331610.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-429169CLMKeith Murphy2002-11-25UHC-50394-8772349908717738 Central Ave, Las Vegas, NV, 891690.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422850CLMGeorge F Kelley1982-01-24—69136784311386 Bayshore Dr, Gilbert, AZ, 852750.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406236CLMSharon Hanson2000-07-07——33 River Rd, Sacramento, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-422582CLMJohn Hughes1947-09-08UHC-46207-3332833529631769 Mesa Dr, Tempe, AZ, 852160.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408966CLMLogan M Carpenter—UHC-56149-76—7199 Bayshore Dr, Austin, TX, 787660.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-403426CLMJessica Burns2007-05-20UHC-28147-7348636337358189 Sage Ct, Seattle, WA, 981140.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412752CLMCruz U Rachel1995-10-10——94 Palm Dr, Eden Prairie, MN, 553790.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405156CLMGreg Hunt1978-09-14UHC-84710-60—6266 Ocean Ave, Seattle, WA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-419209CLMJudith Robertson1974-05-11—70094623879604 Elm St, Nashville, TN, 372680.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-416182CLMDavid Davis1948-04-05UHC-44621-94—5233 Maple Ave, Mesa, AZ, 852030.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409033CLMCatherine Gordon—UHC-95390-2057956747658861 River Rd, Austin, TX, 787800.64Date of birth reformattedDate of birth unreadablePhone reformattedGender normalised+2 more
CLM-432190CLMDoris Obrien1973-11-11——8287 Grand Ave, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425532CLMStephen Y Webb1950-06-21UHC-02013-7870286412627464 Canyon Rd, Minneapolis, MN, 554730.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408084CLMRandy H Wod1980-05-19—73575207394592 Desert Sky Blvd Apt 6, Glendale, AZ, 853460.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-412102CLMRalph Price1978-07-26——1502 Lake View Rd, Minneapolis, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404619CLMChristopher Mendez1967-07-10UHC-51704-12—2371 Union St, Gilbert, AZ0.64Name re-casedPhone missing area codeMember ID reformattedZIP missing+2 more
CLM-419635CLMNicole Carlson1941-10-20UHC-64211-0734988692628802 Pine Dr, Tampa, FL, 336630.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407127CLMGrace Rice1947-01-14UHC-38233-3831381543338097 Indian School Rd, Glendale, AZ, 853370.64Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-432288CLMCheryl Johnson1973-02-07—3353150878101 Palm Dr, Sacramento, CA, 958210.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414097CLMKyle Young1957-11-24UHC-38709-5121170344915907 Harbor Blvd, San Antonio, TX, 782310.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417982CLMDiego A Gibson1990-01-08UHC-11359-8068951271518121 Valley View Dr, Mesa, AZ, 852330.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424883CLMSarah Mitchell1992-09-26UHC-43687-13—8532 Oak St, Eden Prairie, MN, 553860.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408357CLMJacqueline Yang1995-11-26UHC-86549-949155081646100 Ocean Ave, Austin, TX, 787740.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417512CLMDebra Obrien2006-10-26UHC-76374-5661775056866594 Forest Ave, Fresno, CA, 937750.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418926CLMAaron Cox1973-07-25UHC-64407-7672798779274580 Elm St, Mesa, AZ, 852010.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-413374CLMAlbert Hayes1993-09-23UHC-37155-4848865901861017 Willow Ct, Tempe, AZ, 852010.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427714CLMBilly Pallmer1993-09-23UHC-01676-73—7861 Hillcrest Rd, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431431CLMKathryn Dominguez1939-12-18UHC-46274-34—6195 Apache Blvd, Sacramento, CA, 958540.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409207CLMJonathan Davis1971-02-15—39693680436574 Sage Ct, Gilbert, AZ, 852070.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421433CLMMatha Medina1958-10-18——2912 River Rd, Denver, CO, 802850.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 119 of 657PreviousNext