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-120723ENRGloria M Thompson1946-03-06UHC-34983-1157396341799524 Apache Blvd # 938, Phoenix, AZ, 850800.50Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+3 more
ENR-137158ENRMarcus Davis1951-01-24UHC-27003-575598648628889 Elm St, Columbus, OH0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-112195ENRVincent Griffin1956-01-01UHC-47620-3174149867302128 River Rd # 430, Scottsdale, AZ, 852040.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129041ENRPaul F Romero1971-11-27UHC-28842-6438425381408261 Harbor Blvd, Miami, FL0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-58280TPAAnn Garrett1977-01-19—48657001766583 Oak St # 765, Houston, TX, 770840.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-130180ENRRandy J Brooks1989-12-06UHC-99573-5051120690041030 Mountain View Dr, Miami, FL, 331100.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52288TPAThomas Boyd1984-09-28——7546 Sunset Blvd, Sacramento, CA, 958830.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-141929ENRAngela Kelly2003-11-26UHC-38102-9297742505322483 Willow Ct, Nashville, TN, 372970.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-28639PRVJose Yang1996-12-24UHC-79343-1761392545646764 Ridge Rd, Tampa, FL, 336570.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132929ENRJerry Morales1965-11-19—35755063384882 Union St, Mesa, AZ, 852640.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-141298ENRTerry Z Aguilar1967-10-18UHC-05876-6458127838335644 Camelback Rd Apt 37, Tucson, AZ, 857230.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142787ENRMichelle Watkins1978-01-23UHC-31728-5532681775449395 Willow Ct, Chandler, AZ, 852680.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416270CLMEmyly Brown1943-12-10UHC-53245-33—8526 Valley View Dr, Eden Prairie, MN, 553320.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-128644ENRAustin Y Porter1973-04-05UHC-87313-406196484977690 Valley View Dr, Orlando, FL, 328940.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-421847CLMOlivia Powell1960-07-13UHC-19972-8648161255493983 Bayshore Dr, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412624CLMVincent U George1996-04-01UHC-05005-6540122944191886 Market St, Miami, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-132757ENRDebra N Schmidt1941-08-21UHC-39182-5267851290371984 Jefferson Ave, Tempe, AZ, 852320.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108906ENRSara F Aguilar1949-01-09UHC-97394-2631940254348640 Forest Ave, Las Vegas, NV, 891920.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125274ENRJudy Gutierrez1944-10-11UHC-68949-797269228240893 Market St, Houston, TX, 770410.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28006PRVOlivia Lynch1992-07-18UHC-54864-6850825430132929 Union St, Los Angeles, CA, 900620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59224TPABrittayn Hudson1966-07-21——1462 Canyon Rd # 775, Minneapolis, MN, 554470.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21607PRVBrian Martin1955-12-12—29297555238828 Cedar Ln, Seattle, WA, 981130.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-139301ENRKatherine Q Stephens1973-12-22UHC-65510-3037575780677018 Valley View Dr, Mesa, AZ, 852690.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-106172ENRAshley Bowman1978-06-17UHC-45993-8554937132906982 Mountain View Dr Apt 25, Glendale, AZ, 853710.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
PRV-22993PRVMegan Olson1945-10-28UHC-31741-4667041012263348 Ridge Rd, Los Angeles, CA, 900970.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129314ENRPaul U Arnold2008-11-11UHC-58490-2836647192054396 Jefferson Ave, Miami, FL, 331450.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409818CLMArthur H Spencer1942-06-07—87794577731104 Mesa Dr Apt 31, Minneapolis, MN, 554230.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-122461ENRMatthew C Alexander1988-05-08UHC-16478-31—9294 Highland Ave, Miami, FL0.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407563CLMMelissa Vaaldez1954-02-10UHC-81960-04—962 Valley View Dr Apt 26, Dallas, TX0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-23981PRVAndrea Wilson2006-01-08—52481817874292 Pine Dr, Tempe, AZ, 852820.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135818ENRSara L Frreeman1986-06-22UHC-04806-7783099736472306 Cedar Ln, Dallas, TX, 752560.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-120329ENRDaniel O Myers1991-01-22UHC-26791-7032487928632242 Camelback Rd, Gilbert, AZ, 852580.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111331ENRSteven Holmes1938-02-13UHC-19554-84—6670 Washington St, Tempe, AZ, 852450.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-401067CLMNathan Delgado1947-12-17UHC-06879-352056078663425 Desert Sky Blvd, Dallas, TX, 752870.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24958PRVKelly V Espinoza1999-11-27——2936 Canyon Rd, Sacramento, CA, 958580.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415916CLMJulie Rios1994-08-06UHC-27625-4189542992765635 Lincoln Way, Los Angeles, CA, 900020.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401200CLMKatherine Fields1960-04-02UHC-27585-35—7998 Spring St, Mesa, AZ, 852050.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26165PRVWilliam C Castro—UHC-34758-3586282382595084 Park Pl Apt 2, Eden Prairie, MN, 553420.50Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
PRV-27429PRVAndraa Sanders1942-07-25——1519 Harbor Blvd, Houston, TX, 770510.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-140931ENRTheresa Bradley1954-11-05UHC-33427-4828941788868604 Forest Ave, Sacramento, CA, 958100.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405570CLMJudy Guerrero2000-09-26—36890522787102 Oak St, Tucson, AZ, 857490.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61159TPAAhmed Hoffman1979-12-22——1307 Pine Dr, Dallas, TX, 752000.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-100961ENRMark G Hicks1942-08-10UHC-78075-8175551044679003 Grand Ave, Nashville, TN, 372400.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-113834ENRJozeph S Petters1983-04-21UHC-59958-4475391510725660 Mountain View Dr, Glendale, AZ, 853840.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103316ENREric W Wright1939-06-11UHC-72315-7890461755095338 Main St Apt 14, Mesa, AZ, 852390.50Unit split from streetCity re-casedState name converted to codeEmail lower-cased+3 more
CLM-402302CLMEmma Castillo1966-01-03UHC-15311-16—6915 Oak St, Los Angeles, CA, 900150.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-53951TPAArjun Flores1978-12-09——2271 Elm St, Chandler, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-137547ENRDavid P Simmons1980-07-07UHC-57111-043589680219741 Lincoln Way, Sacramento, CA, 958840.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430638CLMBeverly Davis1975-07-12UHC-26050-1745569803573508 Grand Ave, Dallas, TX, 752950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140659ENRAmber Diaz1955-11-26UHC-29467-2594892644445873 Central Ave, Dallas, TX, 752730.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 88 of 2,000PreviousNext