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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-24472PRVFrank Nelson1997-09-14UHC-41067-7772865105659185 Elm St, Chandler, AZ, 852220.76Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-20246PRVRoy G Fisher1967-07-02——323 Baseline Rd, Tampa, FL, 336990.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22630PRVJuan Powell1975-01-22—45177122701179 Bayshore Dr, Los Angeles, CA, 900580.76Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-24676PRVDiaz Joe2001-03-25UHC-07594-3760162012293111 Maple Ave, Glendale, AZ, 853530.76Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
PRV-28883PRVTheresa M Munoz1962-04-06—89330398282470 Camelback Rd, Atlanta, GA, 303640.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21279PRVKelly G Baker2006-08-28UHC-48249-9227868597564218 Sunset Blvd, San Diego, CA0.76Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more
PRV-26439PRVBilly Hamilton1962-12-26UHC-77514-1654690134692692 Meadow Ln, Phoenix, AZ, 850250.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21619PRVRaymond U Burns1943-08-03—47031694932658 Hillcrest Rd, Austin, TX, 787000.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21480PRVDiane Knight1942-11-18UHC-54183-6524246830302976 Market St, Tucson, AZ, 857600.76Date of birth reformattedPhone reformattedCity re-casedGender normalised+2 more
PRV-21397PRVNicole K Ortega2005-09-13——376 Baseline Rd, Chandler, AZ, 852830.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26928PRVJoe Salazar1994-01-16UHC-89970-5887327591752559 Mountain View Dr, Dallas, TX, 752600.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26960PRVLaarry Cox1983-06-01UHC-25922-9595537066584973 Grand Ave, Tampa, FL, 336190.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26266PRVJordan Carroll1963-04-26UHC-34809-7680363589727063 Sage Ct, Tucson, AZ, 857140.76Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-24965PRVDanielle Garza1978-11-07—96486310912118 Desert Sky Blvd, Charlotte, NC, 282410.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-22503PRVBrandon V Rose1970-04-09—9489835891202 Ridge Rd, Seattle, WA, 981030.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26599PRVDorothy Richards1979-02-07—81638353144171 Spring St, Scottsdale, AZ, 852530.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21877PRVRuth U McCoy2001-01-03—58226045731090 Maple Ave, San Antonio, TX, 782530.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28335PRVPatricia Rodriguez1970-07-28——8202 Willow Ct, Gilbert, AZ, 852000.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-27974PRVKenneth Burton1950-06-10—27675461968977 Central Ave, Fresno, CA0.76Name re-casedPhone reformattedCity re-casedZIP missing+2 more
PRV-27857PRVJulie Hunter1961-07-12——5231 Harbor Blvd, Miami, FL, 331960.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22297PRVCharlotte Reyes1942-10-20UHC-26687-6862429368072567 Canyon Rd, Charlotte, NC, 282960.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20876PRVGerald Cunningham1951-07-23UHC-47203-8178756775783051 Washington St, Scottsdale, AZ, 852570.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-29089PRVTheresa Yaang1991-04-03—37494905106217 Bayshore Dr, Plano, TX, 750850.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28192PRVDenise S Little1975-11-22UHC-01972-7171350724213747 Market St, Mesa, AZ, 852070.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
PRV-20304PRVBrandon Duncan1940-09-27UHC-13760-6874865649655044 Market St, Scottsdale, AZ, 852420.76Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more
PRV-24697PRVJudy Cox1985-03-11UHC-31243-2770145804471767 Meadow Ln, Sacramento, CA, 958710.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28584PRVDennis Meyer1988-09-15—28740458199097 Spring St, Seattle, WA, 981660.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25307PRVMariana Ray1981-12-14—44350632905557 Hillcrest Rd, Minneapolis, MN, 554170.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28757PRVStephen R Freeman1991-10-18—49627534921765 Spring St, Atlanta, GA, 303980.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27820PRVSteven Spencr1937-06-20—32591856737438 Cedar Ln, San Diego, CA, 921790.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22442PRVNathan Olson1977-08-18—89350644567553 Central Ave, Houston, TX, 770340.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20640PRVCatherine L Phillips1981-08-26UHC-13217-1159926241218247 Desert Sky Blvd, Seattle, WA, 981640.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-27655PRVSteven Edwards1943-10-14UHC-25642-7467398354071488 Hillcrest Rd, San Diego, CA, 921720.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20994PRVSue Fuller1956-09-15—65454691341486 Main St, Tampa, FL, 336990.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26149PRVLaura Mendoza2001-04-10UHC-72770-86—5539 Ocean Ave, Mesa, AZ, 852970.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27918PRVBilly Mills1946-11-11——8661 Indian School Rd, Plano, TX, 750970.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21264PRVMatthew White1973-02-19UHC-78331-45—8059 Valley View Dr, Gilbert, AZ, 852240.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-25527PRVBradley U Weaver1982-07-14UHC-09294-0240226154017945 Grand Ave, Atlanta, GA, 303180.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
PRV-20079PRVArthur Torres1941-08-23UHC-50812-3781690792325706 River Rd, Tucson, AZ, 857040.76Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more
PRV-26192PRVGeerald T Larson1986-02-15—44351535028163 Valley View Dr, Atlanta, GA, 303810.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21486PRVDorothy Johnston1970-12-11UHC-64629-02—5559 Mountain View Dr, Houston, TX, 770720.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29087PRVKaren Yeng1977-08-27UHC-84529-4297490641921854 Elm St, Orlando, FL, 328730.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25468PRVMartha J Gonzales1950-02-07UHC-87872-0736381740998970 Spring St, Sacramento, CA, 958060.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26900PRVHiroshi A Greene1999-03-25—75985212732623 Maple Ave, Las Vegas, NV, 891760.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
PRV-24580PRVMaria Vazquez1954-10-10—23855066756910 Jefferson Ave, Miami, FL, 331500.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20738PRVBruce Myers1997-07-10—6239787690162 Ridge Rd, San Antonio, TX, 782020.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28322PRVBradley J Warren2005-07-23—588372712093 Valley View Dr, Atlanta, GA, 303850.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20186PRVEmily Lewis1993-11-02UHC-88929-0947959435558519 Willow Ct, Glendale, AZ, 853370.76Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more
PRV-22134PRVCarl S Knight1965-02-06UHC-18875-6021629573976964 Main St, Charlotte, NC, 282950.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22541PRVSusan Murphy1996-06-03—75766743211234 Broadway, Tempe, AZ0.76Date of birth reformattedPhone reformattedZIP missingEmail lower-cased+2 more
9,596 rows, page 89 of 192PreviousNext