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
ENR-101152ENRFatima E Nguyen1984-03-14UHC-77642-9598044925782819 Palm Dr Apt 39, Houston, TX, 770800.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-118950ENRJacqueline E Spencer—UHC-18603-59—1667 Camelback Rd, Tampa, FL, 336220.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
PRV-25556PRVWei Schultz1995-09-03—6143618318552 Indian School Rd, Eden Prairie, MN, 553830.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142146ENRMargaret M Stone1939-12-20UHC-82602-399749293907854 River Rd, Phoenix, AZ, 850410.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-404954CLMStephen Peterson1980-01-06UHC-33520-0684789606249687 Central Ave, Dallas, TX, 752210.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123326ENRElizabeth Pierce1956-05-17UHC-85478-5075363615571579 Union St, Gilbert, AZ, 852670.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-61411TPADortohy Wag1974-07-20——4129 Bayshore Dr # 533, Columbus, OH, 432680.48Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more
CLM-412970CLMStephanie Chavez1946-04-09UHC-88000-5496257288875606 Cedar Ln, Fresno, CA, 937290.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114497ENRRoger Nunez1974-03-26UHC-36065-0687198461547888 Market St, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121465ENRAlexander Sttone1954-02-21UHC-79178-97—5648 Harbor Blvd, Atlanta, GA, 303520.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-124990ENRHelen G Mendez1949-07-10UHC-76991-2452797637138102 Market St # 888, Glendale, AZ, 853000.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-21414PRVAhmed Vazquez1955-08-09UHC-66130-9391425412726035 Oak St, Fresno, CA, 937230.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-115800ENRJesse N Pena—UHC-04366-25—2100 Jefferson Ave, Charlotte, NC, 282200.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-403044CLMBrittany Kim1958-12-16UHC-44063-25—6440 Central Ave Apt 9, Houston, TX, 770100.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-414018CLMMariana R Snatiago2006-11-22UHC-36282-5653178070234386 Jefferson Ave Apt 23, Tucson, AZ, 857370.48Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-131628ENRAisha Harvey1979-02-02UHC-39601-0922929882334208 Main St, Dallas, TX, 752110.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124527ENRLuis S Nichols1972-03-13UHC-68522-2725182779993220 Apache Blvd, Nashville, TN, 372810.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123382ENRBrandon Harper1987-08-21UHC-68742-3729094778436786 Willow Ct, Gilbert, AZ0.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-55281TPAFrank Castillo2005-01-02UHC-40282-62—3298 Jefferson Ave, Miami, FL, 331290.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114247ENRAisha Allen1956-12-26UHC-82372-2687342716015681 Hillcrest Rd, Dallas, TX, 752880.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20370PRVTimothy Reed1963-03-14UHC-65404-5521687000236904 Lincoln Way, Columbus, OH, 432030.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426850CLMKathryn Thompson1988-02-25UHC-66658-7538499092399214 Forest Ave # 804, Minneapolis, MN, 554160.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-135183ENRJoe C Harvey1970-03-07UHC-23152-2060540236987400 Spring St, Orlando, FL, 328900.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-111553ENRLarry Murphy—UHC-56832-3662398916475457 Harbor Blvd, Tempe, AZ, 852110.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-119733ENRBrenda P Martin1947-08-27UHC-38052-6632870576411423 Forest Ave, Charlotte, NC0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20470PRVJoe W Olson1974-08-05UHC-29037-7095172276778587 Meadow Ln Apt 8, Minneapolis, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-60006TPASharon Garza1994-02-05—44542333499247 Highland Ave, Columbus, OH, 432980.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-111542ENRAustin X Bryant1982-03-20UHC-43474-7852755598753056 Willow Ct, Houston, TX, 770080.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-134491ENRMartha U Richardson2002-07-26UHC-71174-1953379514623299 Ocean Ave Apt 29, Glendale, AZ, 853600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-100369ENRCharltote M Oritz2002-10-16UHC-52389-49—7944 Canyon Rd, Columbus, OH, 432390.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-133993ENRSophia G Walker1996-05-18UHC-84938-9398196777722087 Highland Ave, Las Vegas, NV, 891400.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-105739ENRKyle Shaw1944-01-27UHC-46000-39—9403 Washington St, Charlotte, NC, 282720.48Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-403618CLMEugene Patel1989-11-06UHC-40110-14—7309 Spring St, Charlotte, NC, 282200.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123938ENRStephanie O Grant2000-05-13UHC-90074-5567765542253746 Maple Ave # 831, San Antonio, TX, 782430.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-425173CLMBrenda Cruz2006-05-16UHC-82459-61—2625 Sunset Blvd, Plano, TX0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113181ENRSofia Weaver1968-06-05UHC-51460-0835936018261381 Union St # 767, Mesa, AZ, 852340.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-111572ENRVincent R Shaw1984-04-27—77226736293323 Church St, Eden Prairie, MN, 553940.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423422CLM—Junk1969-08-25UHC-95875-47—5564 Central Ave, Minneapolis, MN0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56209TPAMadison Lopez1945-02-18UHC-54424-312767735983673 Grand Ave, Las Vegas, NV, 891770.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-104485ENRSamuel Le1988-05-21UHC-07604-1173681418238848 Cedar Ln # 856, Columbus, OH, 432290.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133216ENRPeter N Walsh2004-07-27UHC-87363-5942549942403658 Meadow Ln, Tempe, AZ, 852080.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-103817ENRGregory Hudson2001-05-05——3589 Spring St, Tucson, AZ, 857010.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-110651ENRAlbert S Morrison1992-12-06UHC-99651-9977030167757326 Harbor Blvd, Mesa, AZ, 852350.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120594ENRMaria Rios1988-04-10UHC-61386-44—9019 Cedar Ln, Sacramento, CA, 958030.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-113660ENRMari Dunn2006-05-22UHC-02585-20—929 Union St, Dallas, TX, 752730.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-117444ENRDorothy James1986-02-16UHC-93469-7740161111758094 Indian School Rd, Eden Prairie, MN, 553920.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-105830ENRRachl X Davis1993-10-04UHC-17326-9576890404664711 River Rd, Charlotte, NC, 282470.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127383ENRThomas Lynch1955-12-03UHC-15368-9240576630917119 Maple Ave, Atlanta, GA, 303640.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-22623PRVAmanda Reynolds1981-04-11—32628910117514 Ocean Ave # 187, Tucson, AZ, 857250.48Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+4 more
PRV-29130PRVChristian Lynch1982-04-12UHC-89218-0947356220602724 Central Ave, San Antonio, TX, 782480.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
100,000 rows, page 74 of 2,000PreviousNext