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
ENR-117747ENRValentina Q Baker1998-03-24UHC-81231-4186665108991465 Apache Blvd, Scottsdale, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107598ENRDaniiel D Roberts2005-12-26UHC-94741-837797070570631 Sunset Blvd, Sacramento, CA, 958320.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-132914ENRScott T Gardner1989-04-26UHC-83945-7421466988213672 Lake View Rd, Dallas, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423576CLMPeter Hernandez1986-02-20UHC-11079-43—7574 Baseline Rd # 842, Gilbert, AZ, 852040.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-120973ENRJulie R Rios—UHC-27625-4189542992765635 Lincoln Way, Los Angeles, CA, 900020.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
PRV-25293PRVBeverly Romero1963-02-22—67841324517088 Ocean Ave, Miami, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-428657CLMAisha Cox1948-11-27UHC-40748-2778575933633223 Harbor Blvd, Las Vegas, NV, 891520.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52773TPALogan Lucas1985-09-26—92952239983084 Desert Sky Blvd, Mesa, AZ, 852810.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-131666ENRDebra Howell—UHC-76247-6320189479669725 Mesa Dr, Austin, TX, 787430.48Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more
ENR-114579ENRJordan W Morles1952-08-11UHC-10237-8461534108189688 Forest Ave, Atlanta, GA0.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137893ENRCarl P Chapman1972-03-02UHC-14869-5723033573047757 Hillcrest Rd, Columbus, OH0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134873ENRSamuel W Fisher1963-12-19UHC-86502-0922140069091226 Palm Dr, Denver, CO, 802980.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-112398ENRBobby Harper1991-12-14UHC-24069-932702784382516 Park Pl, Fresno, CA0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101242ENRRoger D Clark1985-04-20UHC-11754-6974851587321018 Grand Ave, Nashville, TN, 372210.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-100362ENRAlice R Hudson1997-06-04UHC-39004-6881121747535423 Bayshore Dr, Fresno, CA, 937140.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-142916ENRBruce Tran1939-06-10UHC-11511-51—8766 Apache Blvd, Orlando, FL, 328760.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-120093ENRTyler L Chapman2005-02-26UHC-17051-9934120875046201 Mountain View Dr, Sacramento, CA, 958110.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-61160TPAMichael Chapman1980-02-27UHC-12278-8321578738909642 Washington St, Eden Prairie, MN, 553240.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-124123ENRCarol Kelly—UHC-09522-4830183460501796 Maple Ave, Seattle, WA, 981140.48Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-116655ENRTeresa Taylor2007-08-11UHC-76093-8246851337493498 Bayshore Dr, Tampa, FL0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-420507CLMJudith H Sanchez1994-04-11—32220762486227 Main St # 475, Charlotte, NC, 282010.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-432176CLMAnthony Park2001-02-22——379 Oak St Apt 20, Dallas, TX, 752310.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-424685CLMJohnson Teresa—UHC-93030-1420976418623273 Washington St, Austin, TX, 787010.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424333CLMSofia Patel2000-03-25—26191561135736 Ocean Ave Apt 15, Chandler, AZ, 852980.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-404919CLMCheryl M Bryant——23894749496111 Willow Ct, San Antonio, TX, 782140.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-424844CLMAaron X Payne1996-08-06UHC-08039-35—8093 Pine Dr, Tucson, AZ0.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418459CLMLawrence Russell1987-08-05—28728500741418 River Rd, Dallas, TX, 752330.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101107ENRBurke S Hannah2008-11-14UHC-00120-2326193414167092 Canyon Rd, Chandler, AZ, 852570.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
TPA-51940TPALarry Martin2001-01-13——4620 Valley View Dr Apt 1, San Antonio, TX, 782560.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51408TPARichard Henry1978-06-16—84829597867513 Spring St, Atlanta, GA0.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-103299ENRAnna Chapman1947-10-17—31390615491007 Main St, Charlotte, NC, 282280.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405740CLMBobby Mason2003-05-20UHC-43823-71—2306 Mesa Dr Apt 12, Charlotte, NC, 282030.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-51621TPACharles Bryant1941-02-14—38365395955600 Baseline Rd, San Antonio, TX, 782370.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125589ENRArthur R Washington1978-04-20UHC-16202-7887880718254585 Mesa Dr, San Antonio, TX, 782140.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102974ENRLaura E Willis1946-03-19UHC-57630-6525167749923014 Jefferson Ave, San Diego, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-116559ENRLisa Myers1975-08-10UHC-30198-6050928832106220 Willow Ct, Fresno, CA0.48Member ID reformattedState name converted to codeZIP missingEmail lower-cased+4 more
ENR-112697ENRWillie P Hoffman1963-05-05UHC-26483-1038293880585145 Mesa Dr # 515, Denver, CO, 802410.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-104911ENRDilan Arnold1964-03-17UHC-34868-1628250560907544 Pine Dr, Jacksonville, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104451ENRAustin B Reid1941-04-21UHC-86036-5344336514051361 Pine Dr, Tampa, FL, 336310.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
ENR-104450ENRAustin B Reid1941-04-21UHC-86036-5344336514051361 Pine Dr, Tampa, FL, 336310.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
TPA-53415TPAKaren Y Dean———8850 Ocean Ave, Denver, CO, 802040.48Name re-casedDate of birth missingCity re-casedZIP+4 trimmed+4 more
ENR-118655ENRKayla Alvarez1965-02-05UHC-80479-0320139704982707 Church St, Seattle, WA0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114882ENRDebraJunk1947-12-10UHC-73580-7930665532369195 Hillcrest Rd, Sacramento, CA, 958700.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422792CLMJulie M Guzman1963-02-20UHC-93993-352596593030885 Church St, Glendale, AZ, 853710.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedMember ID reformatted+4 more
TPA-62249TPAGary Z Burns1984-11-19—79631360375738 Meadow Ln, Mesa, AZ, 852530.48Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
CLM-401732CLMPriya M Bryant1995-09-20—96987443622965 Lake View Rd, Chandler, AZ, 852880.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-122884ENRShirley Griffin2008-09-22UHC-80810-02—3836 Oak St, Denver, CO, 802620.48Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-104860ENRWillie W Phillips1991-11-15UHC-87487-8722627242137567 Grand Ave, Charlotte, NC, 282650.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110202ENRNoah Miller—UHC-00633-608687041115468 Bayshore Dr, Scottsdale, AZ, 852500.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428680CLMLori Franklin1982-04-15UHC-98775-39—3386 Washington St, Jacksonville, FL, 322720.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 70 of 2,000PreviousNext