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-22963PRVZachary K Long1957-09-19UHC-67657-0779147589928115 Spring St, Tempe, AZ0.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-28259PRVBrandon Coollins1981-07-08UHC-98443-7433052091221704 Desert Sky Blvd, Tampa, FL, 336650.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-23272PRVMaria W Gray1994-12-02—32950022987226 Lincoln Way, Charlotte, NC, 282080.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27944PRVIsabella Sinngh1949-11-14UHC-14951-4091625092208764 Baseline Rd # 276, Columbus, OH, 432960.58Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
PRV-28789PRVSharon Diaz1957-07-25—60896093424651 Sage Ct, Nashville, TN, 372660.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23134PRVEric Lane1948-11-21UHC-13620-9559863732461483 Meadow Ln, Fresno, CA, 937560.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21669PRVAnthony X Fox1958-07-09UHC-20928-7697920492293622 Desert Sky Blvd # 104, Eden Prairie, MN, 553050.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-29256PRVMaria H Cruz1976-05-06UHC-53660-819605553923629 Market St, San Diego, CA, 921100.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-29005PRVMark Banks1986-12-28UHC-06187-4228860497072326 Meadow Ln, Chandler, AZ, 852540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22563PRVRoger Morrison1992-03-22—92421764161173 Apache Blvd, Las Vegas, NV, 891390.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29331PRVGloria Robinson1986-05-28—24569916305674 Maple Ave, Seattle, WA, 981730.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22665PRVDanielle K Ward2003-09-25UHC-81974-4787783952298315 Central Ave, Scottsdale, AZ, 852620.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23449PRVScott Cruz1990-03-08—42965225003854 Cedar Ln # 320, Austin, TX, 787400.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-23192PRVDebra Vargas1992-12-13—74278331857717 Hillcrest Rd, Tempe, AZ, 852690.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25195PRVJanice Johnson1997-04-24UHC-76647-4574234036107828 Highland Ave, Eden Prairie, MN, 553630.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27529PRVDouglas Arnold1991-03-01—91872583614155 Lincoln Way # 994, Tampa, FL, 336200.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-24449PRVSamuel P Morgan2008-03-20UHC-61315-0895971241323999 Hillcrest Rd # 932, Tempe, AZ, 852850.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26999PRVJuustin W Garrett1988-09-04UHC-18690-3274851021471158 River Rd, Tampa, FL, 336770.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
PRV-26313PRVLinda Howard1950-05-15UHC-68897-6231439617656346 Market St # 936, Tampa, FL, 336140.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-24773PRVElijah Price1986-12-26UHC-50102-3223231590743333 Palm Dr, Phoenix, AZ0.60Name re-casedPhone reformattedMember ID reformattedCity re-cased+4 more
PRV-25593PRVSophia I Hill1996-03-13—73465648597644 Hillcrest Rd, Houston, TX, 770570.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22662PRVJoyce Patterson1973-07-17UHC-06691-6925771970974507 Highland Ave, San Antonio, TX, 782780.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24641PRVGeorge Bryannt1965-11-15—92124955572407 Bayshore Dr, San Diego, CA, 921810.60Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26640PRVDanielle R Martinez2004-07-22UHC-78916-82—8733 Desert Sky Blvd, Orlando, FL, 328150.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-22179PRVJordan Harris1951-12-25—25964611761233 Forest Ave, Las Vegas, NV, 891200.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28643PRVDeborah Hall1983-01-08UHC-03263-4533671241513592 Maple Ave, Sacramento, CA, 958440.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22269PRVMichelle X Kelley—UHC-11382-6069549204372898 Baseline Rd, San Antonio, TX, 782440.60Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+4 more
PRV-28082PRVJosh I Gybson1987-11-05UHC-80149-4439834530764752 Washington St, Tempe, AZ, 852320.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29568PRVRebekca Salazar1944-09-24—70170616485115 Grand Ave, Glendale, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20504PRVJudy Schultz1971-11-05UHC-68917-1167445835064311 Sage Ct, Mesa, AZ, 852350.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
PRV-23709PRVAbby Johnson1969-11-17—7167919653658 Elm St, Charlotte, NC0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27186PRVHeather Brooks1978-07-08—82258787418233 Indian School Rd, Plano, TX, 750080.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29537PRVJeremy Jacobs1965-10-04UHC-51630-28—4442 Meadow Ln, Seattle, WA, 981340.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27422PRVGary West1950-10-18—49639778579832 Grand Ave, Fresno, CA, 937960.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27250PRVJoyce Sanchez1966-10-24UHC-16910-09—2620 Market St, Las Vegas, NV, 891040.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25619PRVKevin F Stevens1993-10-06UHC-84647-1957232012563605 Ridge Rd, Chandler, AZ, 852330.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20930PRVZachary Reynolds2006-09-10—90776722861038 Main St, Plano, TX0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21075PRVAustin Wagner1939-09-24UHC-81000-544543577614372 Harbor Blvd # 161, Mesa, AZ, 852690.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-28175PRVLaura Arnold1982-09-24—38940335256320 Main St, Scottsdale, AZ, 852830.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22597PRVEthan Ramos2005-04-01—49430744647771 Spring St, Tampa, FL, 336540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23240PRVMason R Wagner1966-04-13—22976818396319 Jefferson Ave, Miami, FL, 331750.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
PRV-26437PRVGerald Bell1972-01-17—7545231201581 Oak St, Mesa, AZ, 852640.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24818PRVTeresa Medina1959-09-08—82129347496674 Central Ave # 648, Denver, CO, 802720.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-27722PRVJudy Nelson1952-10-02—78735253435320 River Rd, Tucson, AZ, 857100.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28518PRVKayla Mitchell1985-01-11—95830162215324 Desert Sky Blvd, Miami, FL, 331210.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26869PRVDenise Vargas1949-10-23—61467301354158 Central Ave, Nashville, TN, 372050.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-28446PRVGreg V Luna1966-07-21UHC-06652-3851124919821761 Canyon Rd, Phoenix, AZ, 850200.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-22458PRVAbigail Simmons1944-10-04—25648471685286 Cedar Ln, Eden Prairie, MN, 553280.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27469PRVIsabella Lynch1973-11-09—85974059227754 Valley View Dr # 446, Gilbert, AZ, 852350.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25313PRVSean Dixon2000-10-04—34775505183247 Mountain View Dr, Nashville, TN, 372640.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
9,596 rows, page 23 of 192PreviousNext