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-21432PRVLogan Tucker1958-03-25—67093132693731 Baseline Rd, Scottsdale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24546PRVHarold V Vasquez2001-04-18UHC-05206-2452152956724231 Lake View Rd, Mesa, AZ, 852520.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24244PRVCarolyn I Herrera1965-07-04UHC-83872-65—7974 Washington St, Gilbert, AZ, 852610.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28881PRVSofia Y Bowman1964-11-20—59563841393843 Baseline Rd, Scottsdale, AZ, 852290.62Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
PRV-23964PRVBrian F Wilson1984-10-03UHC-08927-597402185505955 Cedar Ln, Miami, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21388PRVArthur Alexander1956-08-20UHC-11557-51—4818 Market St, Nashville, TN, 372730.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
PRV-29539PRVSaen Peters2001-10-05—34041587574637 Sage Ct Apt 5, Houston, TX, 770530.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
PRV-29538PRVSaen Peters2001-10-05—34041587574637 Sage Ct Apt 5, Houston, TX, 770530.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
PRV-20624PRVJustin Carr1939-05-17—74781888712297 Church St, Houston, TX, 770930.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22481PRVAhmed Wagner1981-01-01—3142204944212 Bayshore Dr, Seattle, WA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21372PRVBrandon Garrett1991-01-28—74037915321797 Park Pl, Houston, TX, 770870.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23570PRVDeb V Gilbert—UHC-22494-0971529971275353 Church St, Minneapolis, MN, 554120.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-20253PRVBrandon W Russell1944-07-24UHC-21934-36—7081 Main St, Jacksonville, FL, 322620.62Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-20632PRVSandra Freeman1995-01-01—78159621003230 Pine Dr, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20631PRVSandra Freeman1995-01-01—78159621003230 Pine Dr, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22285PRVRoger George1983-01-10—45334726181902 Washington St, Atlanta, GA, 303620.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27629PRVEric Robertson2008-07-10UHC-01745-7821862717673096 Union St, Fresno, CA, 937660.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21395PRVMichelle I Fowler1981-09-08—50036464412988 Central Ave, Phoenix, AZ, 850150.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28080PRVIsabella Reed1987-08-24UHC-76255-4476866055398519 Main St # 811, Gilbert, AZ, 852500.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20385PRVGreg Lawson1983-02-02——3957 Grand Ave, Denver, CO, 802610.62Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
PRV-29287PRVAnna Guzman1968-06-28UHC-10311-6778333351048017 Washington St, Scottsdale, AZ, 852520.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27933PRVTerry Lane2004-07-22UHC-64702-4769070251225422 Canyon Rd, Sacramento, CA, 958330.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29174PRVWilliam Collins——48680857006271 Cedar Ln, San Antonio, TX, 782180.62Name re-casedDate of birth reformattedDate of birth unreadableCity re-cased+3 more
PRV-28662PRVOlivia Shaw1957-04-28—21695644246872 Jefferson Ave, Dallas, TX, 752590.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25268PRVJose I Scott1979-05-02—79154527891716 Ridge Rd, Nashville, TN, 372830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26531PRVSantiago James1945-09-07UHC-43373-3972925095426714 Church St, Denver, CO0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21975PRVBarbara U Warren1979-06-15—45196816849804 Ocean Ave # 139, Austin, TX, 787630.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24497PRVJudy Ortega1997-11-23—23422834572089 Camelback Rd # 529, San Diego, CA, 921360.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20251PRVDebra Simmons2005-06-27—24433272553226 Elm St, Tampa, FL, 336530.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26778PRVSantiago Rojas1994-12-27UHC-47732-4538473338853935 Canyon Rd Apt 31, Gilbert, AZ, 852640.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27725PRVDavid Day1970-01-08UHC-71063-24—7470 Park Pl, Denver, CO, 802920.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-25562PRVRandy Fisher1984-01-26—8405547906772 Harbor Blvd # 834, Atlanta, GA, 303930.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27027PRVAisha O Brookks1951-06-13—25632470343747 Canyon Rd, Jacksonville, FL, 322600.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24185PRVDouglas Mendez1959-08-10UHC-84771-783438859555630 Apache Blvd, Plano, TX, 750150.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23237PRVMei Ellis1938-06-27UHC-77487-48—1321 Ridge Rd, San Antonio, TX, 782760.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25170PRVJoseph Welch1999-12-19—45971372794470 Apache Blvd Apt 25, San Antonio, TX, 782750.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-27458PRVJennifer Payne1968-12-18—93753779248320 Willow Ct, Glendale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26540PRVKelly Ray1972-10-16UHC-34652-0664140380969554 Sage Ct, Los Angeles, CA, 900090.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25845PRVRichard E Lwason1976-05-25UHC-60156-0337544358199040 Ridge Rd, Las Vegas, NV0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20947PRVJustin I Palmer1950-09-24—84172090647502 Pine Dr, Phoenix, AZ, 850430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20219PRVWei T Hughes1987-07-27—32268990649840 Maple Ave, Austin, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22137PRVAmy Matthews1977-12-25—73956865194188 Hillcrest Rd, Mesa, AZ, 852590.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23198PRVBurke Omar1949-02-03UHC-25889-1346742177766704 Washington St, Glendale, AZ, 853360.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23197PRVBurke Omar1949-02-03UHC-25889-1346742177766704 Washington St, Glendale, AZ, 853360.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29344PRVMichael Garrett2003-11-10UHC-15377-59419682795863 Harbor Blvd Apt 8, Scottsdale, AZ, 852850.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22260PRVTyler Ellis1964-06-11—83166872619799 Maple Ave # 918, Las Vegas, NV, 891400.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-28552PRVBruce Q Wilson2007-09-09UHC-69395-7774491542052098 Baseline Rd, Tampa, FL, 336680.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-25205PRVAndrew Lawson1940-01-10—34074282308968 Willow Ct # 183, Orlando, FL, 328950.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22092PRVStephen Parker1996-08-10UHC-23565-74—272 Church St, Tucson, AZ, 857440.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-29513PRVJeremy H Stevens1952-01-07UHC-47173-614222332187473 Market St, Plano, TX, 750720.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
9,596 rows, page 33 of 192PreviousNext