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-22704PRVMary Ross1970-03-28—30734886707635 Harbor Blvd, Las Vegas, NV, 891160.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28933PRVJustin H Fowler1981-12-21UHC-57350-28—9821 Sage Ct, Phoenix, AZ, 850810.64Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-23431PRVBruce Santos1938-03-13—32780084709658 Pine Dr, Gilbert, AZ, 852880.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23950PRVPamela O Santiago1997-07-14—72226897496957 Apache Blvd, Dallas, TX, 752140.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23619PRVBrandon Ward1985-08-15UHC-12510-9937880171842264 Sage Ct Apt 11, Charlotte, NC, 282300.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-26039PRVEthan Washington1994-11-12UHC-00595-5460348616771253 Elm St, Tempe, AZ, 852570.64Phone reformattedCity re-casedZIP+4 trimmedGender normalised+2 more
PRV-23447PRVArthur Chen—UHC-64162-3349681463842514 Apache Blvd, Dallas, TX, 752680.64Name re-casedDate of birth unreadablePhone reformattedEmail lower-cased+2 more
PRV-29188PRVWei S Cooper1953-10-25—70560888835751 River Rd, Chandler, AZ, 852610.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25417PRVEdward Allen1940-10-20UHC-76827-8935174311831379 Canyon Rd, Eden Prairie, MN, 553720.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25418PRVEdward Allen1940-10-20UHC-76827-8935174311831379 Canyon Rd, Eden Prairie, MN, 553720.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-24027PRVGreen Hiroshi1992-07-05——367 Harbor Blvd, Tempe, AZ, 852490.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-27094PRVAlice Gonzales2004-02-05UHC-98533-2432295312587162 Park Pl, Atlanta, GA, 303840.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24438PRVRlph Oliver1995-03-26UHC-98397-4398820296211949 Spring St, Los Angeles, CA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23420PRVDonald Vargas1975-12-28—93841103994449 Meadow Ln, Plano, TX, 750810.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28421PRVAisha M Cox1948-11-27—78575933633223 Harbor Blvd, Las Vegas, NV0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-20446PRVStephan Murphy1992-11-09UHC-54490-8323453846712604 River Rd, Eden Prairie, MN, 553920.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22868PRVAmy Kennedy1947-06-19—66553824782061 Canyon Rd, Atlanta, GA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28095PRVJordan Banks1980-04-06—20358256258932 Elm St, Charlotte, NC, 282110.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21734PRVWalter Rivera1994-12-28——2298 Main St, Minneapolis, MN, 554250.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20832PRVTyler Crawford1968-08-07—72550150119252 Ridge Rd, Plano, TX, 750950.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-28767PRVBetty Hicks1974-12-13UHC-35810-716556029001—0.64Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+2 more
PRV-24694PRVCamila Marshall1956-12-09UHC-89742-0633470205236341 Baseline Rd, Phoenix, AZ, 850660.64Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+2 more
PRV-25386PRVJessica M Boyd1977-11-15UHC-79586-375289719406602 Cedar Ln, Denver, CO, 802970.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23201PRVLauren Z Schmidt1973-01-17—36034195484410 Lincoln Way # 409, Houston, TX, 770250.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
PRV-29015PRVLawrence Silva1974-07-17—20834876665164 Canyon Rd, Fresno, CA, 937260.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25139PRVJerry Ramos1974-10-07UHC-14545-9938940922735136 Elm St, Sacramento, CA, 958800.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23228PRVJose B Morrison1962-08-14UHC-74741-2562423121313629 Park Pl, Tucson, AZ, 857710.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25098PRVJack Campbell1968-03-16—30432607151440 Grand Ave # 603, Las Vegas, NV, 891330.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
PRV-25992PRVFrances Valedz1957-04-24——9052 Park Pl, Glendale, AZ, 853450.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20926PRVPhilip Gray1948-10-06UHC-41519-2585741702249035 Willow Ct, Seattle, WA, 981640.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
PRV-26691PRVMegan Hanson—UHC-19714-346966467182416 Meadow Ln, Los Angeles, CA, 900950.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20031PRVMark Burke1994-05-26—95332742204572 Forest Ave, Nashville, TN, 372890.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20468PRVSophia D Hanson1969-04-26—3236540001975 Washington St, Nashville, TN, 372830.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27134PRVSandra Harrison1957-10-15—49851796619330 Lincoln Way Apt 19, Eden Prairie, MN, 553370.64Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
PRV-28290PRVEdward Jenkins1963-01-15——7380 Oak St, Sacramento, CA, 958470.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28137PRVChristine Valdez1969-03-12UHC-20572-1185739917338031 Union St # 872, Houston, TX, 770120.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27128PRVCarol Vargas1951-03-18——3390 Washington St # 749, Jacksonville, FL, 322040.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27006PRVDouglas Z Guzman1939-05-04UHC-59096-8841432939664355 Mountain View Dr, Tempe, AZ, 852990.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27156PRVJacob Jackson1949-03-05—37967397361810 Palm Dr, Charlotte, NC, 282210.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27155PRVJacob Jackson1949-03-05—37967397361810 Palm Dr, Charlotte, NC, 282210.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20328PRVSara Ortega1976-02-06—91460194645180 Church St, Fresno, CA, 937290.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22500PRVLawrence L Morrison1965-09-14UHC-89838-1684052759472495 Pine Dr, Miami, FL, 331990.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28919PRVRaymond Peters1972-08-03—94169620192221 Lake View Rd Apt 31, Austin, TX, 787320.64Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
PRV-22020PRVAlexander Davis1979-12-27—29274742968974 Elm St, Scottsdale, AZ, 852950.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-20351PRVJanice Z Luna1976-10-02—24335217386923 Palm Dr, Tucson, AZ, 857630.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26503PRVSean Tucker1942-02-27UHC-15420-3267698742104803 Canyon Rd, Minneapolis, MN, 554330.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23060PRVRachel Walker1941-06-28UHC-14561-8250947243336112 Elm St, Gilbert, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26897PRVBarbara O Patel1957-02-05—21081214156265 Bayshore Dr, Houston, TX, 770930.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26211PRVMason Ortiz2008-02-08—82724329429428 Lake View Rd, Tempe, AZ, 852620.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26212PRVMason Ortiz2008-02-08—82724329429428 Lake View Rd, Tempe, AZ, 852620.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 42 of 192PreviousNext