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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-21330PRVRebecca Munoz1958-09-21—34857368478264 Hillcrest Rd # 969, Charlotte, NC, 282600.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-23458PRVMichelle Haansen1952-03-09UHC-96691-0158723646374178 Baseline Rd, Charlotte, NC, 282740.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
PRV-27404PRVWei Knight2003-01-13—65651213265983 Harbor Blvd # 742, Minneapolis, MN, 554400.44Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
CLM-409594CLMIsabella Parker1955-02-11UHC-22975-4138031554983506 Grand Ave, Glendale, AZ0.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
ENR-134675ENRNancy Sims2000-10-07UHC-83909-9777299257488212 Market St Apt 7, Seattle, WA0.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-406806CLMPatty Hart1974-05-14—28882723926473 Jefferson Ave, Phoenix, AZ0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-142678ENRIsabbella Gordon2007-08-24UHC-44059-85—752 Mountain View Dr, Los Angeles, CA0.44Name split from “Last, First”Two-digit birth yearZIP missingGender normalised
PRV-28219PRVDeborah Ray1944-02-03UHC-55168-607986907373596 Indian School Rd, Sacramento, CA, 958840.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-124209ENRBrittany Ferguson1960-11-14UHC-34165-5226190629738443 Valley View Dr, Fresno, CA, 937290.44Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
ENR-127264ENRCarol X Rogers1973-06-14UHC-29452-5664376766426820 Hillcrest Rd, Minneapolis, MN, 554270.44Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
CLM-410506CLMJoyce Roberts2007-01-12UHC-91571-6033770748402751 Jefferson Ave, Los Angeles, CA, 900460.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-406590CLMMateo Castro1969-09-04—61025965818933 Bayshore Dr, Mesa, AZ, 852780.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-422843CLMKathleen Alvarado2006-09-04UHC-63954-8991079865331905 Sage Ct, Columbus, OH, 432260.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-106041ENRAmber White1962-10-21UHC-86611-6882091176472131 Sunset Blvd, Miami, FL0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-400939CLMRoger Clark1985-04-20—74851587321018 Grand Ave # 590, Nashville, TN, 372210.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-116462ENRLauren G Holmes1992-02-16UHC-98314-2821078859498144 Camelback Rd, Austin, TX, 787490.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-22608PRVBarbara T Austin1980-07-02UHC-09800-5923430118204185 Bayshore Dr, Tampa, FL0.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
CLM-419121CLMJake Espinoza1942-06-20UHC-07841-7757048382082984 Desert Sky Blvd # 755, Tempe, AZ0.46Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-419178CLMJordan P Flores1964-08-10—80371338068436 Jefferson Ave, Tempe, AZ, 852300.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-119401ENRSophia P Dunn1968-06-01—36820363133089 Grand Ave # 798, Miami, FL, 331230.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-128529ENRJacqueline Stone1970-04-24UHC-69765-498124567795607 Apache Blvd, Nashville, TN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-138630ENRKevin Mills1948-08-03UHC-92487-7262542167977712 Mountain View Dr # 836, Scottsdale, AZ, 852090.46Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
TPA-61951TPADebbie Obrien1991-02-05—49484774326867 Main St, Los Angeles, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-103640ENRTheresa M Weaver2001-03-15UHC-34492-5667424342581689 Indian School Rd, Tampa, FL, 336820.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23062PRVCarol Hart1945-05-28—38124201237981 Pine Dr Apt 13, Austin, TX, 787890.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-426877CLMAlexander Estrada2004-12-02UHC-81386-3684356918032506 Indian School Rd, Houston, TX, 770360.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-60991TPAAmanda Little1953-02-07—42427398243360 Canyon Rd, Las Vegas, NV, 891160.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-127999ENRAlan Lynch1993-06-03—84626093348507 Bayshore Dr, Tampa, FL, 336620.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-130771ENRPamla Y Hunt2001-10-27UHC-01030-0383180264678873 River Rd, Plano, TX, 750420.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-107224ENRSandra E Owens1978-11-16UHC-89246-6288538569826957 Bayshore Dr, Seattle, WA, 981750.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-58448TPADonna Stone1996-10-18——8866 Grand Ave # 816, Jacksonville, FL, 322590.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-114125ENRAlice A McDonald1963-06-01UHC-51908-0295891909584905 Jefferson Ave, Tucson, AZ, 857220.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-131356ENRRoger Fox1990-07-18UHC-96985-7064041481005466 Maple Ave # 686, Tampa, FL, 336800.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
TPA-58831TPAAlice Willis1944-06-18—70880544496140 Forest Ave, Chandler, AZ, 852570.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-420211CLMDenise Berry1943-01-02UHC-93903-6170399311596018 Maple Ave, Nashville, TN0.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-411775CLMEric Elliott1950-09-19—37739313276054 Forest Ave Apt 37, Las Vegas, NV, 891460.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-408173CLMKenneth Kellly1966-06-27UHC-11325-9448958813996640 Indian School Rd # 198, Tucson, AZ, 857220.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-125315ENRMari O Campbell1986-11-08UHC-54075-9220868460933520 Lincoln Way, Charlotte, NC, 282190.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-119598ENRLawrence Carter1993-01-26UHC-42533-01—1881 Jefferson Ave, Scottsdale, AZ, 852060.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-119597ENRLawrence Carter1993-01-26UHC-42533-01—1881 Jefferson Ave, Scottsdale, AZ, 852060.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
CLM-409127CLMRobert Pierce1988-03-04—24437130213041 Hillcrest Rd, Houston, TX, 770720.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-426990CLMMartah P Jenkins—UHC-38108-7329447690828650 Apache Blvd Apt 4, Sacramento, CA, 958210.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
TPA-55793TPAKathleen Z Simpson1999-07-27——9520 Central Ave, Columbus, OH, 432440.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-102299ENRAngela Fowler1969-11-24UHC-91761-7040555815161269 Sage Ct, Tempe, AZ, 852830.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-408088CLMKathryn Perry1971-07-27UHC-90777-0576949111174230 Pine Dr, Atlanta, GA0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-128634ENRHaroold Rivera1954-10-21UHC-92156-9567672508502799 Cedar Ln # 734, Orlando, FL, 328490.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-63881TPAChristina Maldonado1968-01-13UHC-10398-3064155008007835 Grand Ave Apt 31, Austin, TX, 787630.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-425287CLMAna A Banks1964-10-09—62179605332552 Union St, Houston, TX, 770450.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-134939ENRWillie Franklin1974-09-24UHC-39455-06—5953 Bayshore Dr, Dallas, TX, 752260.46Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more
CLM-419750CLMGerald Maldonado1946-04-17——3295 Pine Dr # 915, Charlotte, NC0.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
100,000 rows, page 42 of 2,000PreviousNext