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-24612PRVTimothy Berry1963-09-08—21840377043376 Spring St, Dallas, TX, 752840.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
PRV-20826PRVCynthia A Gibson1952-11-09UHC-98065-1625951059918464 Jefferson Ave, Tempe, AZ, 852390.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-26857PRVCamila Kelly1962-06-14—82731972449580 Canyon Rd, Mesa, AZ, 852480.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
PRV-20619PRVAnthony Gray1947-05-21UHC-32028-5549841691693721 Park Pl, Miami, FL, 331020.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27800PRVGerald K Robertson1945-09-20UHC-52253-14—2789 Palm Dr, Phoenix, AZ0.66Two-digit birth yearMember ID reformattedZIP missingWhitespace trimmed+1 more
PRV-22663PRVDonna Schmidt1983-02-23UHC-88832-04—6092 Meadow Ln, San Antonio, TX, 782500.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24492PRVAaron Estrada1994-05-27UHC-74678-88—433 Hillcrest Rd # 854, San Diego, CA, 921220.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20094PRVKyle Mason2008-03-16UHC-92667-29—5993 Bayshore Dr, Chandler, AZ, 852560.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-22055PRVDonna B Padilla1951-10-28——6322 Bayshore Dr, Sacramento, CA, 958750.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-25714PRVAlice Gordon1961-02-17—22067214119363 Lincoln Way, Seattle, WA, 981220.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25226PRVJacob Walker1999-02-27UHC-50958-9648695017942767 Highland Ave, Scottsdale, AZ, 852500.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27530PRVJanet Tucker1972-06-26UHC-36190-8085126054894988 Indian School Rd, Minneapolis, MN, 554600.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-28724PRVJacob Gomez1976-07-10UHC-45306-7125323750446461 Valley View Dr, Atlanta, GA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-24754PRVDoris Anderon1940-06-16UHC-85647-30—5796 Broadway, Sacramento, CA, 958280.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-26669PRVKimberly Green1987-09-27—82233950111921 Hillcrest Rd # 496, Orlando, FL, 328230.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-29474PRVMichael Ramirez2007-02-19UHC-59993-3982398507797881 Maple Ave Apt 1, Dallas, TX, 752050.66Date of birth reformattedUnit split from streetState code upper-casedZIP+4 trimmed+1 more
PRV-24217PRVJordan Warren1997-06-16UHC-42873-9028354058306339 Harbor Blvd, Fresno, CA, 937790.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20651PRVNoah Morris1981-10-14—23946622796769 Park Pl, Glendale, AZ, 853010.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-29511PRVMariana Henderson1986-11-02—39040479298672 Highland Ave, Orlando, FL, 328840.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-21611PRVMaria Nguyen2003-04-02—82020377584081 Willow Ct, Phoenix, AZ, 850300.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21610PRVMaria Nguyen2003-04-02—82020377584081 Willow Ct, Phoenix, AZ, 850300.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22679PRVGregory W Wheeler1989-03-15———0.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
PRV-21834PRVWillie Shaw1978-12-02——7789 Canyon Rd, Minneapolis, MN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20099PRVAna George1976-08-11—5393476904610 Maple Ave, Minneapolis, MN, 554690.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25995PRVAndrea Padilla2008-05-07UHC-09343-48—501 Harbor Blvd, Charlotte, NC, 282270.66Name split from “Last, First”Date of birth reformattedPhone missing area codeWhitespace trimmed+1 more
PRV-26938PRVRussell Ferguson1949-04-04—37559167322954 Highland Ave, Charlotte, NC0.66Phone reformattedCity re-casedState name converted to codeZIP missing+1 more
PRV-22011PRVMaria Danniels2002-09-14UHC-62018-03—5348 Market St, San Antonio, TX, 782280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-25183PRVDaniel Mendez——9787564344—0.66Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-25349PRVBetty Y Martinez1968-04-26UHC-57515-4657934894593912 Central Ave, Los Angeles, CA, 900100.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20326PRVFrances Williamson1987-05-23—5116349753128 Desert Sky Blvd, Miami, FL, 331800.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29126PRVArjun X Crawford1971-06-23——8223 Highland Ave, Eden Prairie, MN, 553720.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25204PRVMariana G Gutierrez1999-07-23—60167564738486 Central Ave, Mesa, AZ0.66Middle initial moved out of first nameName re-casedDate of birth reformattedZIP missing+1 more
PRV-25367PRVDavid M Ruiz1967-12-20UHC-51878-80—2004 Lake View Rd, Denver, CO, 802350.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
PRV-23896PRVLinda Martinez1949-11-21—6422389030—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
PRV-23897PRVLinda Martinez1949-11-21—6422389030—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
PRV-26043PRVKayla Pena1969-01-04UHC-82931-02—6436 Ridge Rd, Atlanta, GA, 303080.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24089PRVMichael Lucas1965-08-11——1524 Highland Ave, Eden Prairie, MN, 553290.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25989PRVBenjamin Boyd1939-02-06UHC-43747-9845277709048631 Sage Ct, Jacksonville, FL, 322690.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-27281PRVSamantha S Adams1997-01-12UHC-60115-83—6922 Sage Ct # 957, Fresno, CA, 937270.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-29230PRVLinda Cooper1950-12-07—25225219934702 Jefferson Ave, Las Vegas, NV, 891530.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-23212PRVSantiago Price1940-11-08—90093082023870 Sage Ct, Denver, CO, 802040.66Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+1 more
PRV-27385PRVCarlos Jordan2006-09-02UHC-81783-75276349944386 Oak St, Sacramento, CA, 958860.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26885PRVRob Watkins2001-07-07UHC-29270-37—8144 Grand Ave, Dallas, TX, 752450.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-24855PRVDenise E Hamilton1988-06-25—70140169899833 Sage Ct, Minneapolis, MN, 554410.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22719PRVScott B Johnston1991-06-01——8261 Pine Dr, San Diego, CA, 921810.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-20087PRVEugene Rose——78169416654245 Maple Ave, Orlando, FL, 328460.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22359PRVSara Sanders1970-11-07——2403 Spring St, Denver, CO, 802960.66Phone missing area codeState name converted to codeEmail lower-casedWhitespace trimmed+1 more
PRV-21457PRVSantiago Torres——25962440745968 Park Pl, Tucson, AZ0.66Date of birth unreadablePhone reformattedZIP missingWhitespace trimmed+1 more
PRV-26754PRVDiane Hunt1974-07-11——772 Bayshore Dr, Austin, TX0.66Date of birth reformattedPhone missing area codeZIP missingWhitespace trimmed+1 more
PRV-27450PRVGloria Clark1976-08-27UHC-28114-3079767876605774 Indian School Rd, Sacramento, CA, 958820.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
9,596 rows, page 60 of 192PreviousNext