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-134956ENRHannah Ortiz1957-10-10UHC-87191-3744328528126790 Harbor Blvd, San Diego, CA0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136967ENRNatalie P Gray1996-11-08UHC-64557-4955172297467891 Jefferson Ave Apt 27, Seattle, WA, 981040.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58266TPALewis Brenda1941-12-12UHC-46833-10—5805 Valley View Dr Apt 38, Charlotte, NC, 282670.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-132670ENRAaron Alexander1956-03-20UHC-32032-51—6261 Highland Ave, Denver, CO, 802670.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-129309ENRBetty J Dunn—UHC-03470-3044852324161582 Bayshore Dr, Austin, TX, 787020.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-105853ENRJoshua Crawford2001-05-16UHC-10821-8871395179891998 Sage Ct, Chandler, AZ, 852010.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-110540ENRRichard Z Herera1984-08-28UHC-90195-3981831533349847 Maple Ave, Tucson, AZ, 857550.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-54181TPABradley Brown2004-06-11——4265 Grand Ave, Houston, TX, 770640.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62723TPAIsabella Hall1948-03-05—21955702619712 Washington St, Houston, TX, 770400.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139284ENRMichelle F Harvye1950-05-22UHC-63801-8464426616842326 Oak St, San Antonio, TX, 782000.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110280ENRDiane Mendez1973-12-13UHC-02276-61—6371 Grand Ave, Las Vegas, NV, 891910.52Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-130951ENREugene Franklin1999-06-01UHC-34876-6795375194624137 Mountain View Dr, Miami, FL, 331450.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112663ENRTeresa Vazquez2005-01-09UHC-14612-7191142963701235 Elm St, San Diego, CA, 921770.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118489ENRIsabella N Lynch—UHC-07898-24—630 Church St, Phoenix, AZ, 850990.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118490ENRIsabella N Lynch—UHC-07898-24—630 Church St, Phoenix, AZ, 850990.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-106821ENRBeverly Montgomery—UHC-55657-247337623845820 Lake View Rd, Tempe, AZ, 852000.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27273PRVJerry Jordan1997-06-11UHC-64857-0596724154412771 Spring St Apt 17, Tempe, AZ, 852440.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-123550ENRGeorge Silva1972-09-06UHC-43784-6848072529219064 Camelback Rd, Glendale, AZ0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422002CLMSara J Garcia1995-02-24—7497694651107 Maple Ave, Orlando, FL, 328620.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
CLM-404506CLMNathan W Clark1967-04-01UHC-59130-6750222981479074 Hillcrest Rd, Denver, CO, 802020.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-135074ENRJuan S Carroll1956-10-23UHC-09236-7438258530022194 Central Ave Apt 2, Tucson, AZ, 857450.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-104750ENRCamila Montgomery2007-10-20UHC-03721-0951124593958901 Pine Dr, Minneapolis, MN, 554320.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424783CLMCarolyn Price—UHC-44884-39—524 Broadway, Nashville, TN, 372520.52Date of birth unreadableAddress re-casedState name converted to codeGender normalised+2 more
ENR-108903ENRAlan D Taylor1964-03-06UHC-03445-29—8573 Sunset Blvd, Jacksonville, FL, 322360.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-112901ENRNicholas Harris1967-05-19UHC-74346-37—2764 Washington St, Fresno, CA, 937290.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-427456CLMJack Daniels1952-12-08—67647841726951 Church St Apt 7, Atlanta, GA, 303130.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415213CLMLucia L Holmes2007-02-04——8617 Highland Ave, Glendale, AZ, 853140.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-133008ENRPeter L Rios1957-09-19UHC-05397-9768822959054756 Mesa Dr Apt 26, Plano, TX, 750430.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405793CLMWalter Mejia1953-04-24——2777 Indian School Rd, Houston, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-412142CLMSean A Roberts1959-07-19UHC-73892-4421648101497042 Ocean Ave, Eden Prairie, MN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-27527PRVCharlotte V Nichols1970-05-19UHC-53965-5081482440593495 Market St # 722, Columbus, OH0.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
TPA-58990TPAYuki Elliott2007-03-18——6045 Oak St, Austin, TX, 787640.52Name re-casedPhone missing area codeState name converted to codeGender normalised+2 more
ENR-134974ENRCynthia Stephns1957-04-06UHC-44022-0721738939068209 Bayshore Dr, Atlanta, GA, 303640.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-59754TPAJoyce K Reynolds1963-10-28——3813 Harbor Blvd, Sacramento, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-107494ENRFrank Alvarado1968-11-17UHC-72561-53—9413 Central Ave, Glendale, AZ, 853780.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114602ENRJessica M Evans1974-08-13UHC-87523-8854060060532157 River Rd, Dallas, TX, 752420.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132014ENRAbigail Luna1940-11-08UHC-74464-6967098805894651 Hillcrest Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-26424PRVNancy Graham1959-03-19—70946051284350 Apache Blvd, Seattle, WA, 981970.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-111515ENRCruz O Larry1999-07-15UHC-19187-5662524980241872 Elm St, Seattle, WA, 981280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429211CLMRonald Henry—UHC-15188-9465730507008751 Park Pl, Chandler, AZ0.52Date of birth unreadablePhone reformattedMember ID reformattedZIP missing+2 more
ENR-127152ENRDaniel G Carroll1970-06-20UHC-02920-7993381036776778 Elm St, Charlotte, NC, 282180.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63561TPAVirginia Simmons1960-12-20——4459 Canyon Rd, Minneapolis, MN, 554070.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-121484ENRDylanJunk1959-09-19UHC-37245-6725287082998950 Apache Blvd, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62912TPADavid Mason1997-04-19—47167760728973 Cedar Ln, Seattle, WA, 981810.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59842TPAAndrew Carr1974-06-15——1806 Church St, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-139240ENRSophia Riley1981-12-20UHC-88399-8945639811426152 Washington St, San Diego, CA, 921730.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420395CLMChristian Simmons1942-08-17——2759 Main St, Atlanta, GA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58813TPATerry Rodriguez1984-06-25——7763 Mountain View Dr, Gilbert, AZ, 852640.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28328PRVDennis Kelley1978-04-18UHC-97854-1479322201503742 Meadow Ln, Chandler, AZ, 852170.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417721CLMJoey V Wheeler1991-05-12——3173 Willow Ct, Sacramento, CA, 958920.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
100,000 rows, page 169 of 2,000PreviousNext