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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-56394TPANicole Perry1952-01-17—58831503757253 Ocean Ave Apt 37, Tampa, FL, 336140.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-50054TPAAaron R Medina1978-11-05——1917 Sage Ct, Austin, TX, 787390.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53314TPAJack Hernandez1955-12-04——916 Indian School Rd, Columbus, OH0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-51207TPALawrence Nichols1994-01-19——1338 Union St Apt 37, Orlando, FL, 328620.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51206TPALawrence Nichols1994-01-19——1338 Union St Apt 37, Orlando, FL, 328620.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-57638TPABetty Garcia1999-09-19—63373348913070 Park Pl, San Diego, CA0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-50881TPAJeffrey King1951-04-08—29946654238238 Camelback Rd, Los Angeles, CA, 900900.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-56144TPAJoseph Meyer———3996 Harbor Blvd, Atlanta, GA, 303250.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
TPA-51811TPAMendez Ryan1969-06-26—89659945652216 Lake View Rd, Fresno, CA, 937140.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50184TPAEmma Cox1996-05-09——4137 Canyon Rd, Jacksonville, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-53735TPAJudy Wells2007-04-08UHC-19437-7241383020997975 Elm St # 313, Eden Prairie, MN, 553720.66Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+1 more
TPA-60409TPAElijah Hoffman1974-10-18—78387015251333 Spring St, Minneapolis, MN, 554550.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58808TPAJudy Brown1979-03-24—88546449836536 Elm St, Plano, TX0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
TPA-62596TPADavid Elliott1955-05-20——4394 Main St, Nashville, TN, 372000.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-51785TPANacny Palmer1975-12-11——4573 Elm St, Dallas, TX, 752730.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-53505TPA—Junk1963-09-01UHC-98430-647746454505—0.66Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared+1 more
TPA-53504TPA—Junk1963-09-01UHC-98430-647746454505—0.66Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared+1 more
TPA-58413TPASharon M Ortega1972-05-08——9011 Willow Ct, Atlanta, GA, 303060.66Name re-casedCity re-casedZIP+4 trimmedGender normalised+1 more
TPA-50262TPAHenry Y Lane1940-09-11—56973541091172 Lincoln Way, Los Angeles, CA, 900680.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
TPA-56668TPASamuel Morgan2008-03-20—9597124132—0.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
TPA-62985TPABrandon Davis1984-01-06UHC-42245-62—1491 Jefferson Ave, Glendale, AZ, 853710.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55010TPAJacob Kelly1990-05-14——9005 Hillcrest Rd, Austin, TX, 787050.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52503TPAGrace Kennedy1952-02-07——3820 Indian School Rd, Fresno, CA, 937540.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60258TPAWillie Hill1954-02-17——6950 Camelback Rd, Gilbert, AZ, 852500.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59622TPATyler Morris1966-01-12——133 Washington St, Atlanta, GA, 303000.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51758TPANicole D Harris1955-08-04——3260 Cedar Ln, Fresno, CA0.66Two-digit birth yearCity re-casedZIP missingWhitespace trimmed+1 more
TPA-51645TPARaymond Vasquez1997-10-05——2095 Cedar Ln, Tampa, FL, 336690.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-55645TPAWilliam Black1967-03-21——5405 Sunset Blvd Apt 12, Jacksonville, FL, 322430.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-55089TPACarolyn Fowler1993-06-10——4224 Union St, Seattle, WA, 981900.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62995TPAAlexis Price1997-10-10——300 Bayshore Dr, Atlanta, GA, 303580.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50342TPAShirley W Bell1971-11-04——8891 Washington St, Houston, TX, 770500.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52873TPACarl Pena1953-07-21—74530183694429 Baseline Rd, Tucson, AZ, 857090.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54857TPACarl Thompson1958-01-03——683 Spring St, Orlando, FL, 328030.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-54654TPABilly King1969-08-10UHC-12485-8226820359487862 Highland Ave, Chandler, AZ, 852800.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53131TPAHenry Jackson1975-09-28——6258 Forest Ave # 512, Columbus, OH, 432540.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63884TPADenise Pena2001-09-06UHC-12515-52—5007 Pine Dr, Miami, FL, 331070.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-50408TPACatherine Anderson——95274347292226 Oak St, San Antonio, TX, 782720.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62866TPAJames G Herrera2005-03-03——4491 Church St, Denver, CO, 802280.66SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-56025TPARoy Li2005-03-07——5854 Harbor Blvd, Las Vegas, NV, 891810.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63136TPAKaren Nichols1995-12-25———0.66Name split from “Last, First”Date of birth reformattedPhone missing area codeEmail lower-cased+1 more
TPA-60755TPAAmy Medina1997-03-22——4249 Apache Blvd, San Diego, CA, 921330.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51157TPAMadison Jones—UHC-46381-9726444967074925 Palm Dr, Tucson, AZ, 857840.66Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+1 more
TPA-60212TPAMark Larson1950-10-25—74482553844811 Pine Dr, Seattle, WA, 981250.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-63230TPADebra Robertson1942-12-26——9263 Palm Dr, Mesa, AZ, 852430.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52188TPAJerry Q Jimenez1998-09-15——3727 Maple Ave, Gilbert, AZ, 852940.66Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedWhitespace trimmed+1 more
TPA-62078TPADiana Z Long2007-11-05——7104 Sage Ct, Houston, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61889TPAJean Sanchez1991-03-04—41446419916271 Camelback Rd, Las Vegas, NV, 891680.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51555TPADenny Powell1977-07-24——8141 Main St, Tucson, AZ, 857650.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50057TPADoris Mendoza1986-11-26——5532 Main St Apt 30, Tempe, AZ, 852980.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61167TPAKeith Collins1980-12-13—80287292347882 Lincoln Way Apt 14, Plano, TX0.66Date of birth reformattedPhone reformattedUnit split from streetZIP missing+1 more
14,474 rows, page 85 of 290PreviousNext