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-20348PRVSophia Munoz1977-05-22UHC-32629-2185499957376455 Ridge Rd, Scottsdale, AZ, 852560.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23340PRVBruce Stone2006-02-06UHC-02412-4377776302244565 Mountain View Dr Apt 36, Phoenix, AZ, 850960.48Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
PRV-26967PRVSoto Randy1943-12-07UHC-23233-3283369148748000 Pine Dr, Dallas, TX, 752310.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101899ENRDiana S Myers1994-04-19UHC-65881-9076650623014782 Sage Ct # 409, Plano, TX, 750600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-101900ENRDiana S Myers1994-04-19UHC-65881-9076650623014782 Sage Ct # 409, Plano, TX, 750600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26722PRVTerry A Turner1971-11-01—27377983361573 Park Pl Apt 38, Eden Prairie, MN, 553310.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-127986ENRChristian P Nelson—UHC-83748-446033036816499 Pine Dr, Los Angeles, CA, 900680.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-141678ENRGabriel Vazquez1979-05-14UHC-22403-9952474426232070 Apache Blvd, Phoenix, AZ, 850600.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-125058ENRHannah G Dean1943-06-10UHC-03019-597805122733248 River Rd, Scottsdale, AZ, 852420.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402421CLMLauren Carroll1963-12-24—86671074302829 Lake View Rd, Mesa, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109171ENRLuis Bailey1976-06-02UHC-42810-1334772494697673 Main St, Minneapolis, MN, 554510.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-111059ENRSara Greene1987-04-04UHC-84724-2621291920512557 Main St, Las Vegas, NV, 891660.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-64358TPADuris McDonald1977-06-19UHC-00910-815318250759566 Church St, Chandler, AZ, 852030.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23907PRVAndrew Bell1964-08-20UHC-15391-2527724282305494 Union St, San Antonio, TX, 782870.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-409349CLMMatthew R Romero1972-07-08——138 Market St, Tempe, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134242ENRRaymond Hicks2007-09-22UHC-56313-5484378696787323 Baseline Rd, Orlando, FL, 328250.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-129623ENRArthur Ryan1964-06-17UHC-17123-6160070250202777 Oak St Apt 5, Tampa, FL, 336720.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
TPA-57311TPAWayne Bailey2007-07-10——8816 Forest Ave, Phoenix, AZ, 850170.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20376PRVDenise Walker1955-11-04UHC-80410-9422981678218205 Baseline Rd, Jacksonville, FL, 322730.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-113034ENRLinda Lawrence1940-05-16UHC-42978-1287358901234617 Palm Dr Apt 39, Tucson, AZ, 857570.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-121278ENRTyler Q Rose1982-01-28UHC-35992-83—959 Palm Dr, Mesa, AZ, 852720.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-407908CLMMichelle Lee1952-02-03UHC-44850-78246888320188 Highland Ave, Charlotte, NC, 282110.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-426370CLMMei Y Reyes1945-08-10—22853008241048 Main St Apt 3, Jacksonville, FL, 322410.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-104755ENRNathan Morrison—UHC-32458-3552577729171788 Valley View Dr, Seattle, WA, 981170.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-122780ENRMichelle Walker2003-08-05UHC-17580-1430158388487539 Bayshore Dr Apt 19, Jacksonville, FL, 322590.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-404467CLMGabriel Campbell1941-09-14UHC-07730-9285122041761460 Pine Dr # 396, Plano, TX, 750010.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-416731CLMThomas Black1962-10-13UHC-99272-93—9730 Oak St, Glendale, AZ, 853210.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-123645ENRCarl N Valdez1964-02-03UHC-93111-3940952226006049 Forest Ave, Atlanta, GA, 303800.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-118359ENRJoe Wright1992-06-04UHC-08635-406875965982907 Apache Blvd, Gilbert, AZ, 852910.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24213PRVJeremy B Dixon1939-05-03UHC-07517-7144641106886846 Hillcrest Rd, Houston, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21291PRVDan Q Allen1944-11-27—23322387269804 Camelback Rd, Houston, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418708CLMMichelle Carpenter2004-12-26UHC-19794-40—1416 Spring St, Scottsdale, AZ, 852150.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-135528ENRFrances E Vega1981-01-14UHC-40876-7976650605868278 Ridge Rd, Dallas, TX, 752570.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-110740ENRDoris Jones1970-08-26UHC-98385-2364078830841468 Mountain View Dr, Austin, TX, 787820.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26611PRVDavid G Hicks1957-12-18UHC-45736-97—3403 Sage Ct # 724, San Diego, CA, 921590.48Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+4 more
ENR-133879ENRHarper K Philip1963-02-22UHC-80108-6768757322993956 Bayshore Dr, Orlando, FL, 328540.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-419720CLMTheresa G Ruiz—UHC-19329-1488875609105807 Bayshore Dr, Columbus, OH, 432900.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-432077CLMTerry Q Duncan1972-11-17UHC-55410-43—8349 Sunset Blvd Apt 40, Fresno, CA, 937260.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-108259ENRKathryn Lawson—UHC-39531-7968224463676646 Canyon Rd, Orlando, FL, 328930.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
PRV-26420PRVValentina R Jackson1965-01-20—5397472494462 Lake View Rd, Eden Prairie, MN, 553670.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52425TPAMartha Harper1950-11-13—50352205177781 Market St, Minneapolis, MN0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-119005ENRWillie Barnes1986-01-11UHC-72052-8147530525833387 Cedar Ln, Nashville, TN, 372650.48Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-122577ENRDanielle Peterson1949-01-25UHC-54962-6425848466871519 Jefferson Ave, Mesa, AZ0.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-24350PRVBruce Hansen1995-04-06UHC-49101-8372937164053759 Willow Ct Apt 28, Austin, TX0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-107800ENRKyle Q Snyder1945-05-19UHC-90590-9854056351306754 Sage Ct, Tampa, FL, 336660.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-55650TPARyan Grant1989-09-27——6174 Valley View Dr, Tucson, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409582CLMJennifer Riley1988-04-14——4639 Baseline Rd, Jacksonville, FL, 322860.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-127162ENRJacob Z Carpenter2007-11-22UHC-24720-4633463551465511 Mountain View Dr, Tempe, AZ, 852960.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110698ENRFrank M Vasquez2007-09-18UHC-46737-1180631870407100 Main St, Scottsdale, AZ, 852740.48Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+4 more
ENR-107978ENRGeorge Munoz1956-12-23UHC-84709-9137174744181291 Cedar Ln # 923, Tampa, FL, 336050.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 56 of 2,000PreviousNext