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
CLM-429753CLMJoseph Brooks1949-02-20UHC-78973-47—4944 Lake View Rd, Tampa, FL, 336580.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-403602CLMMary Edwards1949-09-06——7363 Forest Ave, Miami, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-407090CLMSofia Crawford1998-03-01UHC-53642-74—8260 Church St, Nashville, TN, 372790.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-102338ENRJustin M Gibson—UHC-22092-5041673727682598 Central Ave, Phoenix, AZ, 850250.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407213CLMKimberly Munoz2007-12-22——5212 Spring St, Jacksonville, FL, 322370.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-415181CLMBradley Oliver—UHC-67161-27—5188 Union St, Tampa, FL, 336560.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-415330CLMBruce Bryant2000-04-09UHC-31867-72—9841 Meadow Ln, Chandler, AZ, 852360.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-136049ENRYuki N Burton2001-06-17UHC-06392-96—1866 Willow Ct, Tempe, AZ, 852440.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-107771ENRAleaxnder Reed1960-08-02UHC-32257-0843527313287671 Church St, Austin, TX0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-120169ENRBrenda Harris1982-06-13UHC-10906-7985253053117288 Elm St Apt 21, Plano, TX, 750330.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-139356ENRMateo Y Gardner1991-11-03UHC-88333-70—2185 Market St, Minneapolis, MN, 554680.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-103248ENRJason Harvey1967-02-16UHC-58543-4626440613937451 Desert Sky Blvd, Tampa, FL0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-130089ENRMark A Garrett1994-11-07UHC-56857-90—9121 Jefferson Ave, Houston, TX, 770950.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117392ENRKimberly Lawson1977-01-25UHC-30977-8990743030474007 River Rd, Denver, CO, 802980.54Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+1 more
TPA-54471TPADanielle Bell1959-12-08——7586 Spring St, Orlando, FL, 328070.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-60442TPAJacqueline Daniels2000-10-28——5622 Valley View Dr, Miami, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-108880ENRDoris Y Cooper1969-06-21UHC-46929-1932283044024151 Valley View Dr Apt 28, Glendale, AZ, 853740.54Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more
CLM-431048CLMRobert Flores1950-01-28UHC-72032-58—796 Mesa Dr, Glendale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-113561ENRJesse Herrera—UHC-64854-8355765931242531 Grand Ave, Miami, FL, 331860.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50069TPARuth Ferguson1945-10-09——9177 Jefferson Ave, Mesa, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-428683CLMDrew Montgomery—UHC-32115-7074724011353903 Mesa Dr Apt 27, San Antonio, TX, 782840.54Name split from “Last, First”Date of birth unreadableUnit split from streetCity re-cased+1 more
TPA-52511TPAEugene Contreras1987-08-05UHC-38123-34—2194 Valley View Dr, Gilbert, AZ, 852220.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-50598TPAAndrea McDonald1960-02-20——8541 Camelback Rd, Tempe, AZ, 852380.54Two-digit birth yearState name converted to codeEmail lower-casedGender normalised+1 more
ENR-137072ENRRyan S Walker1979-07-19UHC-79552-9458973111539299 Hillcrest Rd, Las Vegas, NV, 891020.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-142181ENRJesse Vasquez—UHC-78649-5454989682596969 Indian School Rd, Atlanta, GA, 303310.54Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-425884CLMRaymond Jenkins2004-03-16——669 Washington St, Plano, TX, 750970.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-104960ENRMaria Wood1941-12-26UHC-46790-7433899725458674 Hillcrest Rd, Los Angeles, CA, 900070.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-117660ENRDoorthy O Myers1983-07-22UHC-06278-2629699977388147 Harbor Blvd, Houston, TX, 770410.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-117661ENRDoorthy O Myers1983-07-22UHC-06278-2629699977388147 Harbor Blvd, Houston, TX, 770410.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-422655CLMOlivia McCoy1969-04-26UHC-44552-76—7460 Highland Ave, Minneapolis, MN, 554450.54Name split from “Last, First”Two-digit birth yearState code upper-casedGender normalised+1 more
CLM-417179CLMDonald Harper1975-11-02UHC-72323-54—499 Lincoln Way, Fresno, CA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-136008ENRKevin X Cunningham1985-04-13UHC-16391-2093571762497364 Highland Ave, Fresno, CA, 937680.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138509ENRCheryl S Sanchez2004-10-26UHC-38922-463358407861126 Willow Ct, Miami, FL, 331310.54Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
ENR-136826ENRKimberly Z Moreno1979-07-04UHC-01332-3383144380214360 Baseline Rd, Miami, FL, 331540.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431758CLMCharlotte Jacobs1947-07-01UHC-75072-89—2840 Cedar Ln, Scottsdale, AZ0.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+1 more
CLM-426292CLMHelen Munoz1951-03-02UHC-11640-38—6368 Washington St, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-142632ENRWillie Bennett—UHC-41101-83—1924 Highland Ave, Columbus, OH, 432250.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-142631ENRWillie Bennett—UHC-41101-83—1924 Highland Ave, Columbus, OH, 432250.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-63485TPAWei Jordan1988-12-16——5392 Union St, Nashville, TN, 372400.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407838CLMRebecca Duncan1976-10-21UHC-15711-81—2569 Broadway, Denver, CO, 802590.54Name split from “Last, First”SSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-64449TPAJesse Hunter1943-06-08——1690 Willow Ct, Phoenix, AZ, 850350.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-431604CLMWayne Rodriguez———257 Market St, Plano, TX, 750400.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-132228ENRValentina Kennedy1943-08-06UHC-03137-7335251452535500 Ocean Ave, Glendale, AZ, 853690.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-120944ENRPaul L Henry1950-12-23UHC-44952-3077790248976812 Elm St, Austin, TX, 787560.54Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-134289ENRAnthony S Hernandez1959-08-28UHC-52509-78—8419 Lincoln Way, Dallas, TX, 752890.54Date of birth reformattedSSN last four extractedZIP+4 trimmedGender normalised+1 more
CLM-413936CLMSharon Scott1977-06-19——463 Pine Dr, San Diego, CA, 921020.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-107857ENRArjun H Lucas1945-10-23UHC-89462-9478264658268270 Market St, Fresno, CA, 937200.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-104553ENRChrristian V Munoz1992-02-12UHC-66109-89—1973 Cedar Ln, Sacramento, CA, 958940.54Two-digit birth yearSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-432141CLMKatherine Harrison1970-04-13——2321 Apache Blvd, Nashville, TN, 372120.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-121499ENRWilliam F Simmons1940-08-12UHC-29547-53—3201 Apache Blvd, Nashville, TN, 372240.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
100,000 rows, page 211 of 2,000PreviousNext