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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-23107PRVBrittany Q Fowler1948-04-11—77383111154303 Lake View Rd, San Antonio, TX, 782740.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
PRV-27016PRVCalros Jenzen1988-06-19——5801 Canyon Rd Apt 38, Tucson, AZ, 857000.66Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+1 more
PRV-24090PRVRoy Chavez1939-11-04UHC-19953-0327858557161429 Apache Blvd, Chandler, AZ, 852950.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23015PRVGary Rojas1962-07-15UHC-95184-372027396086350 Union St, Gilbert, AZ, 852590.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22387PRVKimberlyJunk1993-05-03UHC-01765-2879886486924122 Market St, Dallas, TX, 752570.66Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
PRV-24034PRVHarold Ramos1978-08-26—20879057623785 Church St, San Diego, CA, 921440.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-24033PRVHarold Ramos1978-08-26—20879057623785 Church St, San Diego, CA, 921440.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-23485PRVKeith R Ross1996-07-22—41752932267356 Maple Ave # 587, Houston, TX, 770150.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22921PRVJason M Mills1986-04-22—35242266382460 Grand Ave Apt 16, Tampa, FL, 336390.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
PRV-21057PRVNatalie Sandoval1989-05-08UHC-85144-5584587621843009 River Rd, Sacramento, CA, 958870.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-20045PRVJulie Wilson1965-12-07UHC-58931-703513146084766 Washington St, Austin, TX, 787450.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-27142PRVJudith Snyder1983-01-13—94661588007887 Bayshore Dr, Mesa, AZ, 852820.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20572PRVSarah D Grannt1999-01-04UHC-93690-5335432335514672 Canyon Rd, Minneapolis, MN, 554130.66Name split from “Last, First”Phone reformattedEmail lower-casedGender normalised+1 more
PRV-25856PRVMason Rios1939-11-04UHC-42367-40—2850 Valley View Dr, Tampa, FL, 336900.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-28666PRVJulia Cooper2002-07-03—42387740454654 Cedar Ln, Tucson, AZ, 857290.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26336PRVWayne Marshall1983-10-09——6085 Church St, San Antonio, TX, 782950.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27901PRVAndrea Mendoza1939-05-07UHC-86485-6648548776443886 Sunset Blvd, Scottsdale, AZ, 852340.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27019PRVYuki Johnson1960-07-06—2568028066—0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-27486PRVPaul Cole1987-03-25—39029193575765 Indian School Rd, Tempe, AZ, 852460.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21702PRVDavid Lewis1981-04-09UHC-05353-8545632885855645 Apache Blvd, Eden Prairie, MN, 553660.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25024PRVSharon A Little———8702 Pine Dr, Houston, TX, 770800.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
PRV-22460PRVGary Q West1998-01-17UHC-19798-1298166124006358 Ocean Ave, Columbus, OH, 432780.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
PRV-27035PRVRonald Stone1948-08-28UHC-20959-12—643 Forest Ave, Glendale, AZ, 853590.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26619PRVChhristian Little1980-06-27—52339679375811 Church St # 309, Orlando, FL, 328880.66Name re-casedPhone reformattedUnit split from streetGender normalised+1 more
PRV-27524PRVJason Rose1967-10-22——4069 Pine Dr, Mesa, AZ, 852300.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-29508PRVLisa Cark2002-09-26UHC-57585-7646939977873910 Palm Dr, Columbus, OH, 432850.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22871PRVOlivia Bradley1969-04-23—73746875653185 Apache Blvd, Las Vegas, NV, 891160.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26279PRVAnthony Parker1987-01-26UHC-91210-46—6120 River Rd, Denver, CO, 802620.66Date of birth reformattedPhone missing area codeGender normalisedWhitespace trimmed+1 more
PRV-25161PRVChristopher Ellis1986-04-05UHC-61611-0725225979343925 Broadway, San Diego, CA, 921780.66Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+1 more
PRV-20603PRVChristina Perez2000-01-20UHC-96033-7845575448979108 Meadow Ln, Gilbert, AZ, 852550.66Two-digit birth yearPhone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-27079PRVCarlos Howard1963-11-24—31151930415732 Desert Sky Blvd, Chandler, AZ, 852310.66Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+1 more
PRV-22121PRVBeverly Bennett1977-03-21—56393471268135 Mountain View Dr, Nashville, TN, 372430.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21222PRVJacqueline Jimenez1950-09-07UHC-16993-83—7066 Highland Ave Apt 4, Orlando, FL, 328750.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-20620PRVAnthony Gray1947-05-21—49841691693721 Park Pl, Miami, FL, 331020.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27181PRVValentina King1989-03-28—40938459098497 Palm Dr, Orlando, FL, 328820.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26765PRVHannah P Ramos1989-05-18——6381 Desert Sky Blvd, Dallas, TX, 752070.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
PRV-27448PRVSarah T Prker1990-02-23—25382864547418 Forest Ave, Denver, CO, 802800.66Name re-casedTwo-digit birth yearState name converted to codeWhitespace trimmed+1 more
PRV-20648PRV—Junk1963-12-16—94349186696990 Sunset Blvd, Dallas, TX, 752850.66Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared+1 more
PRV-26920PRVYuki Harris1950-10-26UHC-23626-39—3874 Sage Ct, Austin, TX, 787200.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-20014PRVOlivia H Mejia1996-01-27——1802 Forest Ave, Atlanta, GA, 303890.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27301PRVJohn Sanders1938-09-06—36284791631497 Broadway, Tempe, AZ, 852300.66Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+1 more
PRV-25491PRVMegan Washington1972-11-17UHC-86025-9538087796712946 Maple Ave Apt 23, Nashville, TN, 372760.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22702PRVNikholas Gomez1968-02-09—47937303455772 Mesa Dr, Phoenix, AZ0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
PRV-24669PRVRussell Harrison1950-08-14UHC-05513-689875500866460 Palm Dr, Dallas, TX, 752390.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-20284PRVDonna Sanchez1979-09-22——2472 Harbor Blvd, Scottsdale, AZ, 852250.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-23827PRVChristine Carter1939-10-14UHC-65972-8548595873004747 Mountain View Dr, Scottsdale, AZ, 852290.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24732PRVJuan Butler1952-03-08UHC-52359-45—4309 Willow Ct, Plano, TX, 750310.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22933PRVBJunk1982-11-25UHC-14257-0588898510415562 Indian School Rd, Denver, CO, 802540.66Phone reformattedZIP+4 trimmedEmail lower-casedPlaceholder values cleared+1 more
PRV-27685PRVJean Campbell1944-11-22—78723704943206 Sage Ct, Dallas, TX, 752140.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24254PRVEthan G Ramirez1970-07-10UHC-26954-7587664456045724 Mountain View Dr, Tucson, AZ, 857110.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
9,596 rows, page 62 of 192PreviousNext