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-26100PRVAhmed Ford1973-01-28UHC-38320-2173870546929525 Harbor Blvd, Sacramento, CA, 958290.66Date of birth reformattedPhone reformattedSSN last four extractedGender normalised+1 more
PRV-24940PRVDot W Wagner1999-11-07——1607 Forest Ave, Tucson, AZ, 857330.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-27317PRVBetty P Wang——37350192812663 Park Pl, Glendale, AZ, 853350.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22146PRVBobby Turner1938-02-19UHC-59366-90—7255 Church St, Houston, TX, 770530.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-24578PRVCharlotte Obrien1944-12-04—83983291822619 Central Ave, San Diego, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-27136PRVPhilip Warren1964-04-26UHC-00906-326237643552416 Meadow Ln, Nashville, TN, 372600.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28280PRVLisa J Vega1965-03-05UHC-36382-3093995890619673 Indian School Rd, Houston, TX, 770140.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-20625PRVBruce Johnston1957-08-10UHC-32734-8524528311453273 Harbor Blvd, Dallas, TX0.66Phone reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-25859PRVJoe T Williamson1968-12-09——6730 Bayshore Dr, Seattle, WA, 981750.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-22002PRVBradley Tailor1977-02-24UHC-96928-9863179586774774 Meadow Ln, Plano, TX, 750450.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-20815PRVSandra Wang1992-07-25UHC-11750-7224926601544488 Cedar Ln, Seattle, WA0.66Date of birth reformattedPhone reformattedZIP missingGender normalised+1 more
PRV-28444PRVDaina M Maldonado1979-10-19—60182945295458 Jefferson Ave, Columbus, OH0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-29436PRVDaniel X Pena1971-01-08UHC-54987-16—7245 Camelback Rd, Miami, FL, 331080.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25673PRVArjun Ramirez1990-05-09UHC-84085-4238075996082896 Sunset Blvd, Gilbert, AZ, 852590.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21199PRVJulia Hunt1965-02-23—67398035059025 Cedar Ln, Seattle, WA, 981610.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24971PRVCarol Hansen2000-06-19UHC-25657-98—4776 Bayshore Dr, Jacksonville, FL, 322820.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-27080PRVSusan Salazar1966-12-23—74368601521616 Sunset Blvd, Glendale, AZ, 853830.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26673PRVJonathan Garrett1961-02-22UHC-48138-96—5631 Church St, Denver, CO, 802500.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-24339PRVJulia Weber1984-11-10—84124126787153 Lake View Rd, Las Vegas, NV, 891240.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27082PRVJerry Martin1994-11-16—32933102009420 Baseline Rd, Houston, TX, 770250.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26529PRVEric Hudson2008-12-03UHC-87974-5973052046188745 Church St, Minneapolis, MN, 554220.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22281PRVMary M Waver1981-06-07—29838484125061 Maple Ave, San Antonio, TX, 782810.66Name re-casedTwo-digit birth yearState code upper-casedZIP+4 trimmed+1 more
PRV-21820PRVTimothy O Flores1980-10-14——2143 Apache Blvd, Glendale, AZ, 853500.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25934PRVWei Walker1976-05-14UHC-30724-8070040528289780 River Rd, Dallas, TX, 752700.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-23278PRVNathan Gutierrez1996-06-12UHC-41662-03—4249 Canyon Rd, Orlando, FL, 328370.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-24084PRVMadison P Lupez1945-02-18——673 Grand Ave, Las Vegas, NV, 891770.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22194PRVJohn F Lee1959-06-19UHC-08697-40—6819 Pine Dr Apt 16, Mesa, AZ, 852510.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24790PRVHarold Greene1994-12-16—95954398917545 Ocean Ave, Seattle, WA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-27938PRVHenry Alvarado1960-08-24UHC-71930-79—569 Highland Ave, Austin, TX, 787260.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-22205PRVJordan Cooper1966-09-05UHC-56687-7676121268162256 Apache Blvd, Houston, TX, 770300.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-20306PRVGilbert Josseph1946-07-21——2818 Bayshore Dr, Tucson, AZ, 857380.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-28890PRVKayla Estrada1996-09-26—74462224429641 Camelback Rd, Tucson, AZ, 857530.66Phone reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-28669PRVDiane Robinson1989-02-15UHC-99457-0954454530606755 Park Pl, Atlanta, GA, 303790.66Two-digit birth yearPhone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-20416PRVBilly Rodriguez1982-07-06—9146151101647 Main St, Gilbert, AZ, 852610.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25568PRVAlice Herrera1980-06-25——7946 Elm St, Jacksonville, FL, 322680.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
PRV-24474PRVLisa Carpenter1948-11-22——6990 Pine Dr, Tucson, AZ, 857250.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28490PRVTeresa P Ramos1998-03-26—76279838615696 Sunset Blvd, Las Vegas, NV, 891860.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25842PRVOlivai Arnold1940-05-23——824 Forest Ave, Plano, TX, 750490.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-23128PRVEdward Daaniels1985-10-27UHC-52432-1133431721638035 Central Ave Apt 10, Tampa, FL, 336150.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
PRV-28756PRVJesse Spencer2001-01-15UHC-70831-7351886818667662 Camelback Rd, Tempe, AZ, 852460.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25931PRVJeremy Roberts1994-12-02UHC-19875-4353187153019863 Sage Ct, Columbus, OH, 432600.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-28121PRVBarbara Z Barnes2006-09-12—4883656405—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-28120PRVBarbara Z Barnes2006-09-12—4883656405—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-28675PRVRichard Carpenter1973-01-14—72122807841751 Elm St, Fresno, CA, 937660.66Street suffix standardisedAddress re-casedState name converted to codePlan code upper-cased+1 more
PRV-22731PRVAnna Thompson1973-04-05UHC-22617-5863450697723663 Willow Ct, Sacramento, CA, 958590.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-24502PRVPamela Fuller1926-07-15—35070036683814 Market St, San Diego, CA, 921540.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-20000PRVLaura Alvarado1939-03-06—20820463444347 Church St, Plano, TX, 750860.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26524PRVIsabella Kelly1959-02-25—45059334222733 Sunset Blvd, Dallas, TX, 752150.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25565PRVAmy Torres1995-01-01UHC-25276-496413517923206 Lincoln Way, Tampa, FL, 336200.66Date of birth reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-23568PRVHarold U Rogers—UHC-54307-354666518737955 Lake View Rd, Eden Prairie, MN, 553010.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
9,596 rows, page 69 of 192PreviousNext