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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-53712TPAMargaret Hunter2005-01-01—84678276832931 Oak St, Chandler, AZ, 852720.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-416830CLMPriya Reynolds1995-05-20UHC-03653-5137554156563380 Camelback Rd, Tucson, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-131616ENRSandra Valdez—UHC-92310-3276766993834090 Main St, Tampa, FL, 336040.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-142382ENRAnna E Taylor1988-07-15UHC-89479-0731199531686456 Mesa Dr, Minneapolis, MN, 554350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-141928ENRStephanie Elliott1957-09-15UHC-77580-0736881065112713 Bayshore Dr, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-132546ENRHanson Scott2000-08-24—84364898421929 Union St # 655, Tempe, AZ, 852120.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
PRV-21468PRVPatricia Grant1962-11-13UHC-86096-7431774523902725 Hillcrest Rd, Mesa, AZ0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106518ENRJoe O Salazar1995-08-18UHC-98084-2584944684408258 Hillcrest Rd, Seattle, WA, 981080.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423752CLMKelly H Harris1961-03-22UHC-15595-64—3408 Hillcrest Rd, Minneapolis, MN, 554900.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432237CLMCarl West1992-01-06——3663 Grand Ave Apt 38, Glendale, AZ, 853530.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63908TPADylan Carlsno1946-10-01——1363 Baseline Rd Apt 40, Atlanta, GA0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102172ENRMartha D Harrison1980-03-26UHC-15211-7865560610267138 Lincoln Way, Denver, CO, 802880.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-420313CLMGregory Smith1987-10-09—40266049222142 Indian School Rd, Charlotte, NC, 282070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107357ENRPeter Marquez1975-02-20UHC-35980-72—4952 Jefferson Ave, Jacksonville, FL, 322850.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-429180CLMMegan Richardson1959-05-13UHC-31006-11—2569 Indian School Rd, Orlando, FL, 328550.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124822ENRHannah R Ryan1983-08-14UHC-82129-983147035927604 Washington St, Minneapolis, MN, 554490.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56679TPAJessica Green1964-04-06—52350459443674 Washington St, Tempe, AZ, 852810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430185CLMRonald Thomas1999-03-07UHC-18112-046868544321700 Grand Ave, Los Angeles, CA, 900540.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58784TPADouglas Wang1938-02-04—9179773554566 Pine Dr, San Diego, CA, 921450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407241CLMGrace Patterson1983-05-26UHC-32210-74—3189 Maple Ave Apt 3, Austin, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-124559ENRMarilyn T Reyes1975-10-22UHC-73685-7736495362846140 Baseline Rd # 257, Eden Prairie, MN, 553650.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-121718ENRValentina R Aguilar—UHC-88614-9323860953224653 River Rd, Glendale, AZ, 853760.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-418987CLMAhmed Sanders1960-10-26—42099771322821 Sunset Blvd, Sacramento, CA, 958770.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-400283CLMWalter Estrada1987-03-07UHC-13603-42—1573 Indian School Rd, Eden Prairie, MN0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-410859CLMSusan Burke1985-02-25UHC-70463-11—4081 Oak St, Mesa, AZ, 852660.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-125794ENRBruce Bryant2000-02-16UHC-90920-7058499274902016 Grand Ave Apt 13, Eden Prairie, MN, 553610.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-415601CLMJacqueline Gonzales1997-03-13UHC-44443-96—5010 Cedar Ln # 809, Mesa, AZ, 852260.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431632CLMAustin Henderson1941-12-22——4815 Mesa Dr, Charlotte, NC, 282500.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-142936ENRElijah Hudson1984-06-27UHC-37723-8531272628583818 Sage Ct, Phoenix, AZ, 850000.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-114230ENRJerry G Phillips1991-05-02UHC-17758-1020741265461057 Meadow Ln, Charlotte, NC, 282800.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22251PRVPatricia Schultz1940-11-24UHC-79313-9041450670738206 Union St, Denver, CO, 802960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417843CLMWalter Dominguez1944-11-03UHC-68577-83—7860 Palm Dr, Atlanta, GA, 303040.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-409950CLMDouglas Schultz1974-07-19UHC-55063-3177231707733366 Elm St, Miami, FL, 331810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108614ENRKyle Berry1981-08-15UHC-29527-443613128002205 Central Ave, Jacksonville, FL, 322880.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137575ENRChristina P Mitchell1960-10-28UHC-77759-595852691353228 Union St, Jacksonville, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134354ENRHelen C Maldonado1993-11-23UHC-15722-4046664041776844 Highland Ave, Charlotte, NC, 282850.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117538ENRMarcus Whitte1984-02-10——3172 Main St, Scottsdale, AZ, 852990.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-414338CLMLucia V Welch1983-09-18UHC-74680-1159456306771802 Spring St, Mesa, AZ, 852130.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-122911ENRNoah Ward1945-03-10UHC-78806-2776334270703345 Ocean Ave, Mesa, AZ, 852990.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415102CLMMichelle Lee1942-09-04UHC-24537-632074848993182 Canyon Rd # 653, Los Angeles, CA, 900300.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
TPA-53006TPATommy Sandoval1954-06-23——1297 Apache Blvd Apt 19, Charlotte, NC0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134386ENRSamuel G George2008-12-03UHC-58433-1495977481782754 Cedar Ln, Denver, CO, 802220.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
TPA-55484TPAJoseph Ward1957-04-24—51340615256443 Bayshore Dr, Glendale, AZ, 853670.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-125611ENRKelly V Greene1963-12-04UHC-79987-7333062643256586 Market St, Las Vegas, NV0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117609ENRRussell S Bailey1987-04-01UHC-87909-5242242402934758 Maple Ave, Chandler, AZ, 852760.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426016CLMAlbert Larson1939-03-03UHC-99616-93—197 Park Pl, Glendale, AZ, 853990.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431323CLMJack N Jordan——81236203547965 Washington St, Houston, TX0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-409059CLMDonna Gutierrez1958-05-06UHC-64677-45—3046 Indian School Rd, Gilbert, AZ0.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-29495PRVJudy Chen1980-06-18—73523803717401 Desert Sky Blvd, Fresno, CA, 937900.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-422009CLMEdward Sanchez1951-09-13—92258852929732 Market St, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
100,000 rows, page 104 of 2,000PreviousNext