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-137460ENRHiroshi J Ramos1999-11-16UHC-35776-2247391901042146 Cedar Ln, Phoenix, AZ, 850290.42Name split from “Last, First”Two-digit birth yearSSN last four extractedStreet suffix standardised+1 more
ENR-130631ENREvelyn Mendez1978-12-23UHC-76939-7761239654631285 Sage Ct, Gilbert, AZ, 852320.42Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+7 more
ENR-136783ENRAmber W Bell—UHC-28228-33—7582 Jefferson Ave Apt 3, Atlanta, GA0.42Name split from “Last, First”Date of birth missingUnit split from streetZIP missing+1 more
ENR-136546ENRCharlotte A Powell1987-10-20UHC-60454-6570324938412491 Washington St, Nashville, TN0.42Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-404291CLMCarlos Gray1941-08-12UHC-64484-7372863151968227 Grand Ave, San Diego, CA, 921460.42Name split from “Last, First”SSN last four extractedState name converted to codeZIP+4 trimmed+1 more
ENR-110863ENRSarah A Robertson1966-04-14UHC-40324-6727894141854444 Jefferson Ave, Columbus, OH, 432580.42Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-139821ENRAnn Williamson1963-02-12UHC-79164-185907757710567 Meadow Ln, Atlanta, GA, 303220.42Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-139822ENRAnn Williamson1963-02-12UHC-79164-185907757710567 Meadow Ln, Atlanta, GA, 303220.42Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-405164CLMBian Fernandez1989-07-08UHC-94270-72—7051 Lincoln Way # 655, Orlando, FL0.42Phone missing area codeUnit split from streetZIP missingGender normalised+1 more
ENR-133650ENRAlbert Freeman1967-11-21UHC-38009-445953976960587 Willow Ct, Nashville, TN, 372400.42Two-digit birth yearPhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-107391ENRLauren Q Hakins—UHC-71458-0864948078816596 Elm St, Denver, CO, 802980.42Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-137705ENRGreg V Luna1966-07-21UHC-06652-38—1761 Canyon Rd, Phoenix, AZ, 850200.42Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-109136ENREric B Bishop1951-02-13UHC-06958-3193374828801104 Hillcrest Rd, Minneapolis, MN0.42Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-108796ENRCharlotte Perry1999-02-08UHC-98299-4023191230245053 Jefferson Ave, Las Vegas, NV, 891670.42SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-118070ENRMateo B Ramirez1994-05-14UHC-28099-674642423455249 Mountain View Dr, San Antonio, TX, 782790.42Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-50092TPAKayla Park1963-12-07——976 Camelback Rd, Los Angeles, CA, 900010.42Two-digit birth yearPhone missing area codeState name converted to codeGender normalised+1 more
CLM-406926CLMJose K Medina—UHC-85752-84—4922 Sunset Blvd, San Diego, CA, 921100.42Name split from “Last, First”Date of birth missingZIP+4 trimmedGender normalised+1 more
ENR-119513ENRSarah X Grant1939-06-16UHC-62692-1130726410735840 Valley View Dr, Tucson, AZ, 857120.42Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-26115PRVDonna Burns1948-08-23UHC-39950-6736665388834001 Meadow Ln, Scottsdale, AZ, 852230.42Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+7 more
PRV-22167PRVZachary Hughes1988-02-18UHC-96105-20—4613 Canyon Rd, Seattle, WA, 981210.42Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-105815ENRBradley V Marquez2003-05-02UHC-30238-5470130528687375 Lake View Rd, Chandler, AZ, 852540.42Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-57573TPACarlos I Berry———2017 Palm Dr, Mesa, AZ, 852950.42Middle initial moved out of first nameDate of birth unreadableState name converted to codeGender normalised+1 more
ENR-105433ENROlivia Fox1976-01-11UHC-47212-39—1864 Market St Apt 5, Austin, TX, 787500.42Name split from “Last, First”Phone missing area codeUnit split from streetStreet suffix standardised+1 more
CLM-428685CLMCynthia V Fuller1974-01-03——2479 Park Pl Apt 3, Charlotte, NC, 282990.42Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+1 more
ENR-118522ENRMatthew Sullivan1959-03-27UHC-21478-3157670141731146 Indian School Rd Apt 1, Glendale, AZ0.42Name re-casedDate of birth reformattedPhone reformattedUnit split from street+7 more
ENR-128280ENRDiana Webb1967-05-27UHC-08113-6479940658365776 Oak St Apt 25, Scottsdale, AZ, 852440.42Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413189CLMSophia Estrada1992-09-22UHC-67827-54—2462 Elm St, Tucson, AZ, 857790.42Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-412922CLMLucia Little2008-01-04UHC-70129-2595421856455507 Mesa Dr, Miami, FL, 331150.42Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-128507ENRAdam Simpson1967-06-24UHC-96422-35—5636 Ridge Rd, Nashville, TN, 372560.42Name split from “Last, First”Two-digit birth yearPhone missing area codeStreet suffix standardised+1 more
ENR-109895ENRJoshua Turner2005-08-27UHC-57288-8640866969907345 Cedar Ln, Eden Prairie, MN, 553770.42Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+1 more
ENR-125407ENRKathleen E Santos1956-12-09UHC-88039-837267525817367 Oak St, Nashville, TN, 372960.42Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-120852ENRNatalie Jacobs2005-02-13UHC-20927-65—3207 Market St, Glendale, AZ, 853150.42Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-138136ENRDeborah Hoffman1940-03-02UHC-84676-1982667698526121 Mesa Dr # 156, Columbus, OH0.42Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-426209CLMZachary Schultz1966-05-06UHC-17530-09—9272 River Rd, Seattle, WA, 981700.42Name split from “Last, First”State name converted to codeZIP+4 trimmedGender normalised+1 more
ENR-139687ENRAlice Daniels1990-03-12UHC-83756-8145670622484225 Sunset Blvd, Tucson, AZ, 857930.42Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-117361ENRVirginia Warren2000-10-18UHC-49628-1522769782716360 Ridge Rd, San Antonio, TX, 782290.44Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+6 more
PRV-21056PRVMichelle Hamilton1990-01-02—46183633587834 Grand Ave, Austin, TX, 787720.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
CLM-431824CLMTyler D Garza1981-11-03UHC-04182-51—4587 Maple Ave # 722, San Antonio, TX, 782070.44Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more
CLM-425458CLMEdward Reyes2004-09-24UHC-07461-95—8191 Pine Dr Apt 7, Denver, CO, 802040.44Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+6 more
CLM-408907CLMGerald Maldonado1995-11-12UHC-91427-57—1415 Indian School Rd, Las Vegas, NV, 891110.44Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+6 more
ENR-136447ENRDavid I Gardner1964-12-07UHC-74358-7144481332484966 Church St Apt 3, Sacramento, CA0.44Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+6 more
ENR-112503ENRJonathan G Bowman2001-09-03UHC-40062-05986552017054 Grand Ave Apt 7, Miami, FL0.44Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+6 more
ENR-124366ENRKeith N Simpson—UHC-20710-2276356834566732 Church St, Fresno, CA, 937760.44Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+6 more
ENR-130640ENRVictoria G Kelly2006-06-13UHC-05223-4965677263593470 Park Pl, Scottsdale, AZ, 852670.44Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+6 more
ENR-120680ENRMargaret Bailley1998-02-27UHC-26153-91—3713 Cedar Ln, Gilbert, AZ0.44Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+6 more
PRV-28193PRVJeffrey Nelson1962-10-20UHC-95285-4033243798641426 Camelback Rd, Sacramento, CA, 958280.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-21506PRVWillie Lucas—UHC-42851-6540339890503884 Palm Dr, Jacksonville, FL, 322940.44Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+6 more
TPA-50201TPAChristina U Holmes1943-10-03—22191249931045 Indian School Rd, Houston, TX, 770900.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-132620ENRNancy Z Rios1978-08-03UHC-35917-2362335875375048 Hillcrest Rd, Jacksonville, FL, 322230.44Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-112788ENRHelen Ward1998-10-21UHC-75310-08—1861 Jefferson Ave, Charlotte, NC, 282400.44Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+6 more
100,000 rows, page 40 of 2,000PreviousNext