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-26374PRVLarry Mejia2008-10-26——9043 Bayshore Dr, Fresno, CA, 937120.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24682PRVCarol Phillips1977-12-05—62658824798747 Apache Blvd, Plano, TX, 750760.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20436PRVMark Gomez1959-12-09UHC-95727-7751387004565174 Meadow Ln, Seattle, WA, 981590.64Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
PRV-20349PRVEugene Dean1963-10-24—76257421311762 Oak St # 953, Scottsdale, AZ, 852110.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-23393PRVCal C Watson1947-06-09UHC-46114-2263561410724297 Palm Dr, Miami, FL, 331000.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26774PRVJose Holmes1986-06-03—24790189214808 Meadow Ln, San Diego, CA, 921890.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28745PRVCatherine R Larson1971-12-20—64228520952721 Sunset Blvd, San Diego, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25109PRVAngela Watkins1959-11-08UHC-59656-7335391474333595 Mountain View Dr, Jacksonville, FL0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21747PRVAhmed N Gibson1955-01-10—56359762205266 Main St, San Diego, CA, 921550.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23328PRVBarbara Pena2005-02-23—44334853972978 Church St, Atlanta, GA0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
PRV-20132PRVAmenda H Campbell1953-03-03—65564553752081 Park Pl Apt 20, Columbus, OH, 432200.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28140PRVMadison Nichols1945-06-25—64022789339777 Desert Sky Blvd, Jacksonville, FL, 322010.64Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-23424PRVMaria S Dominguez1985-05-22UHC-32345-8887089456146206 Lincoln Way, Dallas, TX, 752540.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25870PRVLauren McCoy1946-01-06UHC-57720-335459437491692 Spring St, Charlotte, NC, 282480.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22273PRVHarold D Mitchell2005-12-08—43780384605445 Union St Apt 23, Los Angeles, CA, 900490.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-20247PRVLaurra A Sullivan1974-11-11—65671790831021 Highland Ave, Atlanta, GA, 303780.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-28268PRVRandy D Ward1966-08-21UHC-18923-49—5264 Sage Ct, Mesa, AZ, 852770.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-28176PRVRandy R Vazqquez1960-06-15UHC-86837-2363657789679686 Lake View Rd, Austin, TX, 787920.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24656PRVKathryn Ortega2002-07-27—98289909691848 Main St, Atlanta, GA, 303070.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-25528PRVSteven Clark2006-02-12UHC-49567-8371694350655715 Jefferson Ave, Glendale, AZ, 853580.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22846PRVChristine McDonald1952-09-07UHC-07777-6035347730611438 Grand Ave, Eden Prairie, MN, 553000.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23660PRVOlivia Dominguez1977-08-09—43996149507574 Bayshore Dr, Scottsdale, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22073PRVJennifer Hawkins1943-07-14UHC-46500-9179061136471107 Lake View Rd, Denver, CO, 802660.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28517PRVFrank Scott1988-11-22UHC-44570-9693235586092437 Highland Ave Apt 36, Dallas, TX, 752490.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-21288PRVThomas Espinoza1975-04-25—24574357172938 Maple Ave, Atlanta, GA, 303970.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28067PRVAisha N Martin1972-02-24UHC-24039-3284569948506550 Union St, Seattle, WA, 981840.64Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
PRV-21084PRVCamila Walsh1956-04-22——238 Market St, Miami, FL, 331870.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24778PRVAustin A Le1972-03-20UHC-07743-0551351475338887 Sage Ct, Mesa, AZ, 852470.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-20427PRVWillie Valdez1943-12-12UHC-40042-3359054630364034 River Rd # 898, Minneapolis, MN, 554750.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-25404PRVKayla Reid1950-11-06—95274513991181 Sage Ct, Plano, TX, 750140.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20257PRVAlbert Hanson1940-03-10UHC-65216-04—7146 Central Ave, Seattle, WA, 981910.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28749PRVFrank H Johnson1975-03-06UHC-56150-346566132714925 Spring St, Gilbert, AZ, 852740.64Name split from “Last, First”Phone reformattedCity re-casedGender normalised+2 more
PRV-26460PRVMelissa E Kennedy1998-11-03—46434050807833 Park Pl, Fresno, CA, 937850.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22342PRVBrian Ortiz1959-11-08—51949101916054 Cedar Ln, Tampa, FL, 336600.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20499PRVLori E Carlson1945-09-28—86138045192001 Elm St, Scottsdale, AZ, 852700.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-26854PRVSam Adams1960-07-20UHC-62298-6640581503272770 Canyon Rd, Columbus, OH, 432260.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-26196PRVNicole Snyder1988-07-06—33024176736336 Spring St, San Antonio, TX0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28813PRVCarol Warren1952-07-21—77272837167040 Hillcrest Rd, Gilbert, AZ0.64Name re-casedPhone reformattedZIP missingGender normalised+2 more
PRV-27227PRVMelissa Hawkins—UHC-47276-8070043803284053 Forest Ave, San Diego, CA, 921400.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-21505PRVBarbara Silva1965-04-05—33641360397394 Valley View Dr, Austin, TX, 787810.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24010PRVDennis Elliott1975-04-06—41469875193313 Maple Ave, Gilbert, AZ, 852650.64Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+2 more
PRV-26487PRVGary V Hill—UHC-08265-4048967133631930 Apache Blvd, Seattle, WA, 981480.64Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
PRV-29217PRVJusitn Coleman1977-12-02—87841737506753 Baseline Rd, San Diego, CA, 921380.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-21157PRVRoy Morales1969-09-21—57381751023291 Sunset Blvd, Glendale, AZ, 853500.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25219PRVArthur Gibson1982-09-25—29330561596998 Cedar Ln, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20318PRVBobby Garcia1940-10-09UHC-75717-4537679331813222 Valley View Dr Apt 33, Minneapolis, MN, 554280.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26049PRVEthan Richardson1951-02-27UHC-74350-59—1264 Palm Dr, Sacramento, CA, 958850.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-26296PRVDouglas H Kennedy1959-02-15—40762713199050 Sunset Blvd, Eden Prairie, MN, 553350.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28470PRVJonathan Ramirez1962-03-14UHC-25636-58—995 Spring St, Columbus, OH, 432760.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-27078PRVMark Kelly1978-10-13UHC-20486-0923923383489319 Main St, San Diego, CA, 921270.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 54 of 192PreviousNext