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
PRV-22361PRVEmma Hamilton1973-02-10—28943024319143 Elm St Apt 40, Seattle, WA, 981520.36Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-412248CLMJulie Sullivan1979-09-27—85989510435655 Union St # 255, Las Vegas, NV0.36Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-131750ENRLisa Torres1961-12-18UHC-00221-4096028363695711 Union St Apt 19, Glendale, AZ, 853940.36Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-426733CLMAmber Lopez1974-05-12UHC-73217-0243044432152315 Meadow Ln, Columbus, OH0.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401243CLMDouglas Simmons1957-03-21UHC-32473-8468558652487378 Main St, Houston, TX, 770560.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-113767ENRNathan M Hall1939-08-26—34661153887748 Bayshore Dr Apt 6, Austin, TX, 787350.36Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-107614ENRWalter Mejia1953-04-24UHC-68970-84—2777 Indian School Rd Apt 31, Houston, TX, 770130.36Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-410066CLMMartha V Walker1956-04-23—24886836145551 Highland Ave, Phoenix, AZ, 850110.36Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more
ENR-131135ENRAlexis U Edwards2003-05-11UHC-06470-3243058408202299 Cedar Ln, Atlanta, GA, 303200.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-114274ENRJose Howell1973-11-06UHC-32051-3038365238926998 Cedar Ln, Seattle, WA, 981470.36Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120241ENRVicoria V Hudson1944-08-14UHC-73175-5975428341986187 Central Ave, Denver, CO, 802150.36Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-109829ENRCamila A Sandoval1972-06-25UHC-86804-4861538616857717 Ocean Ave, Jacksonville, FL, 322200.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25526PRVElizabeth Hanson1981-10-23UHC-21503-2667451420231726 Elm St, San Antonio, TX, 782470.36Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-105487ENRCarolyn P Jones1954-07-13UHC-87815-7625282687817025 Mountain View Dr, Tucson, AZ, 857240.36Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403127CLMSean Howrad2003-03-02UHC-69785-40—1024 Lincoln Way, Gilbert, AZ, 852740.36Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-412504CLMJennifer Bailey2002-08-03UHC-38553-3030678424818575 Indian School Rd, Dallas, TX0.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
PRV-22853PRVMarilyn Richards1987-08-16UHC-81335-2032773575479496 Church St Apt 6, Las Vegas, NV, 891600.36Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26226PRVCarolyn X Day1973-03-06UHC-57139-59—3750 River Rd Apt 20, Seattle, WA, 981700.36Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+4 more
TPA-58018TPASantiago Warren1976-10-01——542 Harbor Blvd Apt 5, Mesa, AZ, 852480.36Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
ENR-135990ENRRyan Q Taylor1961-07-10UHC-02340-68—1616 Indian School Rd, Phoenix, AZ, 850470.36Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone missing area code+4 more
ENR-143022ENRTyler S Anderson2002-09-16UHC-60331-6678376963297392 Main St, Sacramento, CA, 958380.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-103624ENRVictoia T Weber1939-05-02UHC-47186-9496336934516370 Mountain View Dr, Mesa, AZ, 852710.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58152TPAJordan Gilbert2000-05-22—76148383871469 Indian School Rd, Columbus, OH0.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-124058ENRHiroshi R Chen—UHC-44955-99—7171 Jefferson Ave, San Diego, CA, 921800.36Date of birth missingMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-103246ENRAnna K Harris1959-01-20UHC-92449-156842441378942 Park Pl, Seattle, WA, 981160.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53454TPAAhmed Vega1991-05-16——1975 Jefferson Ave # 484, San Diego, CA, 921140.36Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-23236PRVDorothy T Richardson—UHC-54546-12—1505 Camelback Rd, Seattle, WA, 981920.36Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+4 more
ENR-129776ENRWilliaam D Hudson1995-08-11UHC-43451-1564147988945967 Church St # 326, Tempe, AZ0.36Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-418414CLMJudy Soto1981-01-26UHC-64354-1762199084639496 Ridge Rd, Glendale, AZ, 853220.36Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-133955ENRDiego W Turner1988-02-28UHC-92924-9697673028878225 Union St, Tampa, FL, 336440.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63806TPAJoshua Gonzales2001-03-06——4712 Sunset Blvd # 359, Phoenix, AZ0.36Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-104036ENRAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St Apt 6, Chandler, AZ, 852570.36Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-401890CLMOlivia Peterson—UHC-82814-76—2619 Union St, Phoenix, AZ, 850010.36Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-100904ENRAlice K Crawford1953-10-20UHC-75258-4781974451128047 Forest Ave, Plano, TX, 750590.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-140454ENRMegan Miller1991-03-22UHC-23582-7098122617414638 Highland Ave Apt 37, Denver, CO, 802930.36Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
ENR-116585ENRPatrick Welch1952-01-17UHC-32323-3637125190678468 Indian School Rd # 230, Tampa, FL0.36Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138397ENRDennis Meyer1988-09-15UHC-24695-9028740458199097 Spring St, Seattle, WA0.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413283CLMSamuel A Rivera1988-07-26—37864411734182 Valley View Dr, Jacksonville, FL, 322710.36Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-139632ENRPaul Carpenter1986-02-12UHC-05394-1678996299403274 Desert Sky Blvd, Plano, TX, 750440.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62826TPAChristine Gutierrez1964-11-17—67349723897675 Pine Dr, Seattle, WA, 981440.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-102937ENRTimothy Bryant1965-02-15UHC-19534-2892352429464738 Park Pl, Phoenix, AZ0.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431972CLMStephens Ethan1980-08-04UHC-27099-2237095105339299 Forest Ave # 210, Fresno, CA0.36Name re-casedPhone reformattedUnit split from streetState name converted to code+4 more
ENR-136364ENRSusan X Graham1966-04-08UHC-42834-64—9569 Hillcrest Rd, Phoenix, AZ0.36Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-419627CLMTimothy Perry2008-05-20——7814 Highland Ave, Miami, FL, 331360.36Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-115851ENRJulie J Wilson1990-10-20UHC-76381-4128594761316638 Park Pl, Tempe, AZ, 852470.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412508CLMCarlos Y Guerrero1960-03-11UHC-84016-21—53 Grand Ave, Gilbert, AZ0.36Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-106362ENRFrank T Hunter1955-09-25UHC-53273-9196164095683716 Lake View Rd Apt 14, Sacramento, CA, 958160.36Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-100545ENRShirley R Watson1997-06-09UHC-54640-6373325866507724 Canyon Rd, Minneapolis, MN, 554990.36Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
PRV-21868PRVLogan H Welch1964-09-19—94839560375903 Grand Ave, Minneapolis, MN, 554070.36Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-404341CLMDennis Murhy1974-07-05UHC-83602-05—8539 Oak St Apt 18, Minneapolis, MN, 554170.36Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
100,000 rows, page 15 of 2,000PreviousNext