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-108141ENRMaria Hamilton1966-11-20UHC-70067-3152452911483558 Ocean Ave # 808, Sacramento, CA, 958430.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-63623TPALinda Duncan1962-10-21——838 Grand Ave # 845, Las Vegas, NV, 891260.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52333TPASophia Schultz1979-05-28—23387509242062 Jefferson Ave, Phoenix, AZ, 850190.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-432628CLMMargaret B Vasquez1962-10-26UHC-19632-9755856107207899 Church St, Scottsdale, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-430551CLMAlexander J Lawrence1974-03-07——4292 Grand Ave, Jacksonville, FL, 322790.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-405435CLMByan Stevens1944-01-04UHC-77346-2626256394066962 Maple Ave, Phoenix, AZ, 850370.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-415695CLMKelly Montgomery1962-05-24UHC-89838-7035370156958917 Valley View Dr, Sacramento, CA0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-107997ENRGeorge R Fernandez1959-03-23UHC-61162-8581899604155931 Union St, Columbus, OH, 432080.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425945CLMDiego W Turner1988-02-28UHC-92924-96—8225 Union St, Tampa, FL, 336440.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-113178ENRGary Gutierrez2008-08-03UHC-77619-5774157879535455 Bayshore Dr, Houston, TX, 770770.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-430643CLMLucia T Butler1985-05-14UHC-50319-68—5723 Desert Sky Blvd, Gilbert, AZ, 852470.48Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-129130ENRJason I Schultz1981-02-03UHC-97273-7338637322837823 Canyon Rd # 555, Mesa, AZ0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-127852ENRVirginia N Ray1956-07-22UHC-17642-309372571397350 Union St, Phoenix, AZ, 850450.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-100053ENRMaria W McCoy1980-10-08UHC-49836-3287449164289418 Forest Ave Apt 32, Orlando, FL, 328350.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
TPA-61208TPAJeremy C Cruz1964-04-15—54044800269297 Mountain View Dr, Tempe, AZ, 852990.48Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-122886ENRJessica Mendez——94334764094733 Mountain View Dr, Miami, FL, 331370.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-138812ENRDylan Yang1966-08-02UHC-03495-8524365894215592 Lake View Rd Apt 21, Tucson, AZ, 857580.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-108991ENRFerguson Jonatahn1945-06-13UHC-93124-8987371585048474 River Rd, San Diego, CA, 921900.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-120574ENRDJunk1999-09-26UHC-97761-7852452780498845 Mesa Dr # 672, Jacksonville, FL, 322210.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-141129ENRMichelle A Lynch1967-09-11UHC-07856-5560468473343435 Meadow Ln, Plano, TX, 750210.48Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
CLM-409487CLMPriya K Weber1977-01-08UHC-74953-20—7071 Forest Ave, Glendale, AZ, 853980.48Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more
PRV-25679PRVWayne Lopez1988-09-08—48463262611771 Canyon Rd, Jacksonville, FL, 322180.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-416363CLMOmar Meidna1955-05-19UHC-37490-97—3433 Meadow Ln, Orlando, FL, 328540.48Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
CLM-421800CLM—Junk1967-12-18UHC-60213-7773599021021681 River Rd # 342, Scottsdale, AZ, 852210.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-124457ENRRoy B Rios1972-02-26UHC-25856-5671331872157323 Indian School Rd, Nashville, TN0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104833ENRDiego K George2000-06-14UHC-74759-5526750916064258 Sage Ct, Minneapolis, MN, 554240.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-115025ENRAna I Mendoza1996-01-08UHC-49984-1091882060652269 Bayshore Dr, Seattle, WA, 981620.48Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+4 more
CLM-408317CLMAaron Murphy1951-03-16UHC-20453-66—8883 Canyon Rd # 127, Nashville, TN, 372360.48Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
CLM-430130CLMAmanda Grant1985-09-24—57740671086065 Willow Ct, Jacksonville, FL, 322770.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-112468ENRJack Z Mendoza1978-09-13UHC-85398-59—6468 Camelback Rd, Chandler, AZ, 852430.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-22628PRVMei Johnston1938-01-05—50931517173813 Sunset Blvd, Charlotte, NC, 282430.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406376CLMBrian Patel2004-10-26UHC-04047-38—2330 Maple Ave Apt 21, Orlando, FL, 328760.48Date of birth reformattedMember ID reformattedUnit split from streetCity re-cased+4 more
CLM-400208CLMMaria Martin1991-05-20UHC-36744-1585368542305568 Indian School Rd, Phoenix, AZ0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419322CLMMegan Thomas1998-10-14UHC-49695-95—2120 Highland Ave, Dallas, TX, 752210.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57494TPARoy Edwards1944-11-25—53333211539892 Apache Blvd, Atlanta, GA, 303080.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
CLM-418380CLMGloria Johnston—UHC-03301-51—2654 Maple Ave, Orlando, FL, 328630.48Date of birth missingStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-100499ENRBryan M Lucas1993-06-22UHC-39542-794226425082487 Harbor Blvd, Los Angeles, CA, 900260.48Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-137532ENRJoeph E Porter—UHC-13992-8181771271211656 Church St, Orlando, FL0.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-54610TPAKayla Bailey1981-10-10—64197401175758 Pine Dr Apt 24, Columbus, OH, 432560.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408904CLMMarcus Snyder1958-10-04UHC-27788-70—7609 Central Ave Apt 1, Tampa, FL, 336720.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
ENR-108891ENRChristian N Powell1984-09-05UHC-80704-7544190119192322 Union St, Plano, TX0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112046ENRJennifer S Bradley1986-09-17—48684099638203 Park Pl Apt 17, Houston, TX, 770440.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-402397CLMHannah Ryan1983-12-26—4523205161406 Palm Dr, Mesa, AZ, 852120.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127217ENRLauuren Gutierrez1942-10-10UHC-72049-9744090837695474 Indian School Rd, Chandler, AZ, 852200.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-419596CLMEmma Rodriguez2006-11-25——894 River Rd, Phoenix, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403486CLMMegaan Y Jenkins1988-07-16UHC-29869-8091456775189484 River Rd, Gilbert, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431437CLMWayne Lopez2001-12-26UHC-76174-84—8070 Highland Ave, Dallas, TX, 752960.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-130610ENRJohsua Moraes1986-07-14UHC-14391-1750970410682252 Spring St, Seattle, WA0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-412813CLMCamila Baker——9009578885815 Ocean Ave, Las Vegas, NV, 891950.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-424425CLMSara Burke1969-04-08UHC-67629-21—95 Maple Ave, Houston, TX0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
100,000 rows, page 67 of 2,000PreviousNext