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-20104PRVMary Willis1956-06-18—24267807708319 Main St, Mesa, AZ, 852630.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20884PRVWei X Bailey——34691242848300 Park Pl, Mesa, AZ, 852140.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24592PRVSamntha Harris1987-07-06UHC-52365-8481467782223707 Apache Blvd, Houston, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20556PRVObrien Valentina1965-06-13UHC-50153-598578412143—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
PRV-20555PRVObrien Valentina1965-06-13UHC-50153-598578412143—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
PRV-29348PRVMadison Q Wilson1946-10-13UHC-30657-3247659476301800 Lake View Rd, Atlanta, GA, 303660.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25550PRVRobert Russell1983-09-05—25036658779166 Pine Dr, San Diego, CA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28296PRVGrace F Duncan1999-06-14UHC-41719-7559052518926527 Harbor Blvd, Orlando, FL, 328790.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-23310PRVJerry L Riley1941-10-02—93178398404607 Pine Dr, Charlotte, NC, 282140.64Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+2 more
PRV-23567PRVJanet Sanders1963-04-02—3977111586—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
PRV-21287PRVMason Duncan1984-04-28UHC-64676-9478747869413258 Hillcrest Rd, Gilbert, AZ, 852160.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26036PRVMelissa Ramos2002-06-10—87637691087751 Bayshore Dr, Chandler, AZ, 852330.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29493PRVSara Nunez1940-06-09UHC-01441-4289171981253337 Market St, Los Angeles, CA, 900490.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27292PRVFrances Phillips1964-10-25—9358982434128 Union St, Fresno, CA, 937350.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
PRV-23717PRVBarbara Fox1964-06-23—95952974624433 Ridge Rd, Tempe, AZ, 852880.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28090PRVSofia G Price1970-08-23—72880388012370 Spring St, Phoenix, AZ, 850010.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23586PRVJeffrey K Simmons1979-02-02UHC-58774-6231670356015421 Bayshore Dr, Chandler, AZ, 852950.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24859PRVVincent Ruiz1948-10-12UHC-27931-26—3608 Cedar Ln, Atlanta, GA0.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23984PRVElizabeth Z Martinez1998-12-22—91474127832780 Desert Sky Blvd, Atlanta, GA, 303430.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-29572PRVMadison U Thomas1945-05-25UHC-45958-4438538632899336 Maple Ave Apt 25, Minneapolis, MN, 554400.64Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+2 more
PRV-27275PRVHarold Rios1982-09-28UHC-13868-3448295633252214 Harbor Blvd, Minneapolis, MN, 554470.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28111PRVGrace Wong2000-12-03UHC-13056-4773566760103571 Spring St, Sacramento, CA, 958340.64Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+2 more
PRV-24652PRVVincent R Barnes1999-01-17UHC-01375-618164990462863 Meadow Ln, Plano, TX, 750670.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22950PRVRobert Hansen1939-12-07—62483447409514 Washington St, Gilbert, AZ, 852790.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25005PRVMichelle Andrews1993-08-24—23778711996315 Highland Ave, Orlando, FL0.64Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
PRV-26692PRVDavid P Jenkins2003-05-05UHC-89133-6933354853734240 Jefferson Ave, Minneapolis, MN, 554960.64Middle initial moved out of first nameDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-25273PRVBrandon Harper1987-08-21—29094778436652 Highland Ave, Chandler, AZ, 852970.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28738PRVLauren Sullivan1938-07-08UHC-65196-5282492688726489 Oak St # 854, Seattle, WA, 981890.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23552PRVAlice Alvarez2007-10-06UHC-16932-0787042903981521 Harbor Blvd, Eden Prairie, MN, 553730.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23366PRVRalph Arnold1951-08-10—74196843181384 Canyon Rd, Plano, TX, 750890.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
PRV-22174PRVJason Fowler1941-08-26UHC-57273-8794372453817152 Willow Ct, Dallas, TX, 752390.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21010PRVSandra N Harper1946-09-10UHC-48277-68—7685 Jefferson Ave, Denver, CO, 802120.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22698PRVNicholas Patterson1974-12-05——9852 Washington St Apt 34, Tempe, AZ, 852590.64Unit split from streetStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
PRV-22986PRVAngela Moreno1984-07-14UHC-73326-2791358591515944 Park Pl, Houston, TX, 770010.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29332PRVMargaret Fernandez1938-09-28——1878 Ocean Ave, Atlanta, GA, 303090.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24805PRVCarlos Ryan1989-06-02——814 Meadow Ln, Mesa, AZ, 852900.64Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20072PRV—Junk1953-11-08—76942058019437 Valley View Dr, Denver, CO, 802800.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25986PRVHeather Freeman1961-09-08—20638319062537 Grand Ave Apt 15, Orlando, FL, 328460.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28468PRVVincent N Knight1984-07-24UHC-99113-1030823497082594 Sunset Blvd, Phoenix, AZ, 850020.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23523PRVElizabeth Young1979-01-13UHC-34103-1489864479216703 Sage Ct Apt 14, Miami, FL, 331330.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26647PRVNicole Q Thomas1999-04-10—93091849245300 Maple Ave, Mesa, AZ, 852120.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24813PRVTimothy Freeman1992-07-09UHC-34025-6093169663895657 Market St, Seattle, WA0.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26679PRVDylan R Ramos1961-07-22UHC-33618-3781859985851058 Sunset Blvd # 765, Atlanta, GA, 303360.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26678PRVDylan R Ramos1961-07-22UHC-33618-3781859985851058 Sunset Blvd # 765, Atlanta, GA, 303360.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24151PRVJessica K Morgan1957-05-01UHC-15395-1030543049654019 Meadow Ln, Glendale, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26008PRVBilly Valdez1968-12-02UHC-52318-42—1459 Hillcrest Rd Apt 13, Glendale, AZ, 853100.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24105PRVDanielle Andrews1952-11-02UHC-05813-343413261209247 Camelback Rd, Eden Prairie, MN, 553930.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
PRV-21554PRVAna Mendoza2004-10-14—30297727587371 Market St, Houston, TX, 770800.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27163PRVAlan Powell—UHC-25780-7293460543193127 Washington St, Phoenix, AZ, 850830.64Name split from “Last, First”Date of birth missingPhone reformattedCity re-cased+2 more
PRV-23970PRVMary Marquez1981-01-20—62290918599126 Union St, Atlanta, GA, 303140.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
9,596 rows, page 43 of 192PreviousNext