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-20140PRVJoan Bryant1958-12-01—52538875926477 Spring St, Mesa, AZ, 852870.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
PRV-27372PRVPaul G Luna1974-05-11UHC-71549-9695299451189143 Union St, Glendale, AZ, 853330.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27437PRVSteven Wright2003-04-06—92494288008108 Meadow Ln, Chandler, AZ, 852190.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20064PRVDeborah T Murray2003-04-24UHC-81038-07—3737 Baseline Rd, Scottsdale, AZ, 852530.66Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+1 more
PRV-20065PRVDeborah T Murray2003-04-24UHC-81038-07—3737 Baseline Rd, Scottsdale, AZ, 852530.66Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+1 more
PRV-26875PRVRobert H Stone1972-01-08UHC-11766-7032742369884545 Cedar Ln, Eden Prairie, MN, 553190.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-28514PRVJustin Rice1948-06-02UHC-64295-91—2262 Union St # 107, Jacksonville, FL, 322540.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-29148PRVBruce T Rodriguez1960-10-12UHC-81012-4123561271138269 Market St, Mesa, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-25911PRVLinda Wagner1994-05-17—31792763894845 Hillcrest Rd, San Diego, CA, 921360.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
PRV-26952PRVBruce Hart——88421442822479 Mesa Dr, Tucson, AZ, 857860.66Date of birth unreadableCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-26294PRVVirginia Clark1956-11-05UHC-07844-6038322973948280 Forest Ave, Phoenix, AZ, 850310.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-25374PRVKimberly Burns1982-01-20—23054872413423 Camelback Rd, Tempe, AZ0.66Phone reformattedCity re-casedZIP missingGender normalised+1 more
PRV-24689PRVJacob George1957-06-02——1133 Lincoln Way, Eden Prairie, MN, 553830.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-21043PRVSamantha Guzman1969-12-26UHC-92739-3791182846335202 Market St, Los Angeles, CA, 900400.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-23003PRVElijah Brooks1974-10-23UHC-94363-4344475840702057 Grand Ave, Scottsdale, AZ, 852400.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24520PRVTimothy Weber1954-08-04—66032504423331 Mountain View Dr, Plano, TX, 750030.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21629PRVJoshua Johnston2000-11-19—76858830716768 Jefferson Ave, Eden Prairie, MN, 553690.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
PRV-23023PRVVictoria Ramirez1957-12-09UHC-01322-018917815866635 Forest Ave # 652, Sacramento, CA, 958070.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
PRV-22047PRVMatt Montgomery1972-10-03—90794467514920 Lake View Rd, Charlotte, NC0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-22043PRVEmma Santiago1995-03-17UHC-20832-619627945315—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-27562PRVBetty Lucas1958-05-20—2923740103—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-28045PRVDaavid Henry1938-09-08UHC-00305-08—7188 Broadway, San Diego, CA, 921090.66Address re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-28046PRVDaavid Henry1938-09-08UHC-00305-08—7188 Broadway, San Diego, CA, 921090.66Address re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-24972PRVAdam Li1945-01-18UHC-03793-43—51 Oak St, Houston, TX, 770500.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27478PRVChristopher B Stephens1988-09-21UHC-69472-9892199834475720 Valley View Dr, Gilbert, AZ, 852270.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24018PRVJuan Welhc1959-01-05UHC-99208-1834782018514917 Park Pl, San Antonio, TX, 782270.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-20976PRVJessica Burns2007-05-20UHC-28147-73—8189 Sage Ct Apt 7, Seattle, WA, 981140.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29079PRVCarl Lynch2003-02-23UHC-43141-1251529799459073 River Rd, Tempe, AZ, 852120.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-23845PRVRonald Snyder1957-07-20——1398 Harbor Blvd, Tampa, FL0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-20024PRVMaria Ortiz1999-11-28——5555 Harbor Blvd Apt 13, Jacksonville, FL, 322410.66Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-26850PRVSara P Wallace1970-10-27UHC-48359-676659671601298 Ridge Rd, Minneapolis, MN, 554710.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20260PRVMarcus Wallace1991-02-08UHC-76142-96——0.66Name re-casedDate of birth reformattedPhone missing area codeGender normalised+1 more
PRV-25573PRVNancy N Morgan1988-01-04——1598 Canyon Rd, Minneapolis, MN, 554150.66Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-24171PRVChristian X Kennedy1938-09-22UHC-25677-82—4685 River Rd, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+1 more
PRV-23837PRVAlbert Mendez1972-10-21—39386633021232 Desert Sky Blvd, Houston, TX, 770040.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28631PRVJustin Jackson1995-01-02UHC-75123-32—4662 Apache Blvd, Denver, CO, 802540.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-24111PRVPaul Gilbert1952-08-21UHC-18539-6769523281726577 Ridge Rd, Houston, TX, 770480.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-22773PRVNathan Cunningham1938-05-08UHC-14810-76—8203 Lake View Rd, Atlanta, GA, 303990.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-27889PRVCharlees Carpenter2006-07-15UHC-19993-8674198391287072 Highland Ave, Denver, CO, 802020.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22064PRVAnna Turneer1974-02-09UHC-90002-7345775746726074 Willow Ct, Nashville, TN, 372500.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-28681PRVKenneth Cox1953-06-17—32163879043484 Maple Ave, Glendale, AZ, 853310.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22796PRVBradley Austin—UHC-84381-5841167534797207 Washington St, Fresno, CA, 937380.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24476PRVSteven Banks1955-12-09——3943 Market St, Minneapolis, MN, 554400.66Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-24630PRVPeter Baker2001-04-28UHC-99981-31—9241 Sunset Blvd, Fresno, CA, 937570.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-26484PRVRebecca Fox2000-04-23UHC-17190-79—9718 Main St, Fresno, CA, 937890.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-23753PRVLuis Howard1987-09-10UHC-63334-205407541885744 Harbor Blvd Apt 30, Las Vegas, NV, 891390.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-26941PRVDougas Daniels1957-01-06UHC-43682-30—3223 Washington St, Denver, CO, 802150.66Name re-casedPhone missing area codeMember ID reformattedState name converted to code+1 more
PRV-23436PRVZachay Knight1959-07-23UHC-03561-97—6436 Grand Ave, Charlotte, NC, 282900.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20548PRVRyan Palmer1964-12-15—4425680312452 Union St, Seattle, WA0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
PRV-20957PRVBoby Martinez1963-09-25——2233 Mountain View Dr, Atlanta, GA, 303880.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
9,596 rows, page 61 of 192PreviousNext