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-427713CLMJennifer McCoy1950-09-26UHC-92337-58—8713 Main St, Nashville, TN, 372080.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429070CLMCatherine Sanchez2004-06-08UHC-09685-1231799047309542 Mountain View Dr Apt 29, Charlotte, NC, 282310.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405846CLMLori Allen1972-01-06UHC-66446-3662328459868219 Bayshore Dr, Denver, CO, 802130.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419823CLMRandy J Guzman1967-11-04UHC-25385-67—5574 Elm St, Houston, TX, 770110.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418570CLMSusan Alvarez1965-11-01UHC-58484-22—8399 River Rd, San Diego, CA, 921080.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420952CLMHiroshi Montgomery1976-04-17UHC-28875-0778285583761778 Ridge Rd, Miami, FL, 331230.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417146CLMLucia White1991-07-18UHC-66434-91—4563 Lincoln Way, Sacramento, CA, 958530.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423941CLMMarcus Myers1949-12-23UHC-16071-16—2919 Harbor Blvd # 295, Scottsdale, AZ, 852180.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428100CLMDeborah Fox1982-06-04UHC-40257-90—3808 Highland Ave, Houston, TX, 770590.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428407CLMRichard Rice1977-10-05UHC-29214-90—2371 Mesa Dr, Plano, TX, 750100.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428406CLMRichard Rice1977-10-05UHC-29214-90—2371 Mesa Dr, Plano, TX, 750100.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421442CLMAustin Burton—UHC-94455-39——0.64Date of birth missingMember ID reformattedEmail lower-casedGender normalised+2 more
CLM-401016CLMJanet Gibson1966-08-04——8053 Mesa Dr, Jacksonville, FL, 322620.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421497CLMEmma Dean2001-02-28UHC-64762-9826722240224006 Meadow Ln, Nashville, TN, 372310.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-420542CLMPriya Gutierrez2005-09-07UHC-28590-73—2606 Elm St, Charlotte, NC, 282790.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-415160CLMEddie Garcia1942-12-09UHC-82255-21—5691 Lincoln Way, Austin, TX, 787860.64Name re-casedMember ID reformattedState name converted to codeGender normalised+2 more
CLM-421900CLMAlexis Price1958-09-09—9034940566—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-413334CLMDouglas Henderson1997-01-10UHC-07476-5177093864901129 Market St, Eden Prairie, MN, 553650.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423472CLMWalter Hudson1939-11-17UHC-10004-8295470872697989 Lake View Rd, Houston, TX, 770530.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427963CLMJeffrey B Hunter1974-07-13UHC-42787-34—3234 Sage Ct, San Diego, CA, 921760.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429513CLMJulia Lucas1981-07-20UHC-72844-783215592607504 Sunset Blvd, Minneapolis, MN, 554470.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401073CLMBobby Hawkins1938-05-01UHC-47552-02—6533 Pine Dr, Las Vegas, NV, 891230.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-425933CLMJanet Wells1987-07-25UHC-54496-81—4618 Ridge Rd, Los Angeles, CA, 900550.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-415313CLMMariana H Harrison2007-03-03UHC-02249-1558772328335365 Union St, Glendale, AZ, 853370.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401191CLMDennis Li1967-06-16UHC-05445-31—5730 Park Pl, Atlanta, GA, 303460.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-428640CLMAustin Allen1939-03-24UHC-32273-6939936047702083 Cedar Ln, Phoenix, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405343CLMValentina Montgomery1983-04-19UHC-94649-40—9150 Forest Ave, Nashville, TN, 372380.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414294CLMCamila I Ortiz2008-06-21——8674 Cedar Ln, Houston, TX0.64Date of birth reformattedPhone missing area codeCity re-casedZIP missing+2 more
CLM-402504CLMHeather Howard1954-04-18UHC-56509-498185394398784 Forest Ave, Houston, TX, 770480.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413075CLMSofia A Wong1978-03-15UHC-38789-3942078158542750 Spring St, Miami, FL, 331380.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-421047CLMDaniel R Jimenez1956-02-18UHC-92103-6365124376204505 Hillcrest Rd, Sacramento, CA, 958170.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420109CLMBarbara Z Gordon1974-10-13UHC-06105-8981526579503289 Washington St, Orlando, FL, 328520.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427975CLMMcCoy Abigail1966-02-08UHC-03347-2241497344411161 Meadow Ln, Columbus, OH, 432770.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-418491CLMLinda Kelly1950-08-10—49557317645183 Ridge Rd, Columbus, OH, 432620.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427457CLMStephen Wallace1940-10-19—43764857148935 Willow Ct, Fresno, CA, 937410.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428134CLMJudith Espinoza1987-06-10——403 Spring St, Mesa, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-428085CLMKelley Arthur1988-04-25UHC-28863-8143782134114444 Spring St, Tempe, AZ, 852160.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402894CLMBeverly Taylor1996-03-12UHC-10404-5048424872458531 Canyon Rd, Mesa, AZ, 852400.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-408460CLMBrenda Garrett1985-09-28——3668 Ridge Rd, Phoenix, AZ, 850180.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-407764CLMKim Robinson—UHC-32138-4988525595841348 Mountain View Dr, Minneapolis, MN, 554280.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421901CLMAlexis Price1958-09-09UHC-80433-48—1324 Main St # 244, Scottsdale, AZ, 852480.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424934CLMJeffrey Jenkins1992-05-11—8399898724413 Baseline Rd, Houston, TX, 770840.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406069CLMDorothy Olson1969-01-05UHC-97175-1620698320846538 Forest Ave Apt 19, San Antonio, TX, 782480.64Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-425808CLMGary N Kelly1969-12-25UHC-44852-79—9565 Valley View Dr, San Antonio, TX, 782370.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401897CLMDick Medina1981-07-21UHC-21869-63—635 Washington St, Phoenix, AZ, 850840.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427047CLMHiroshi A Martinez1993-08-16UHC-21659-3489927145136792 Valley View Dr Apt 2, Fresno, CA, 937560.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
CLM-408869CLMWalter Clark——25773364603926 Lincoln Way, Jacksonville, FL, 322980.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407034CLMEugene Porter1966-07-22UHC-60023-22—4072 Maple Ave, Nashville, TN, 372910.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410407CLMChristine James1949-11-18——4126 Highland Ave Apt 9, Austin, TX, 787170.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-421624CLMOlivia Gonzales1943-12-08UHC-00411-1896829946438846 Apache Blvd, Seattle, WA0.64Name re-casedDate of birth reformattedPhone reformattedZIP missing+2 more
32,829 rows, page 144 of 657PreviousNext