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-29299PRVCharles W Clark1989-03-17—88146927708197 Mesa Dr, Tempe, AZ, 852630.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-22057PRVGrace Lawrence1990-02-28——5929 Central Ave, Glendale, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-22083PRVDanielle N Pierce1956-11-16—77168469615592 Ocean Ave, Atlanta, GA, 303280.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-24636PRVSophia Lee2003-03-11—5425709844528 Ocean Ave, Gilbert, AZ, 852270.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20013PRVOlivvia H Mejia1996-01-27——1802 Forest Ave, Atlanta, GA, 303890.66Name re-casedTwo-digit birth yearPhone missing area codeCity re-cased+1 more
PRV-24343PRVJohn Lynch1985-12-18UHC-71698-3646196067054927 Ocean Ave, Charlotte, NC0.66Name split from “Last, First”Phone reformattedCity re-casedZIP missing+1 more
PRV-28832PRVJesse D Wang1951-05-04UHC-64399-80—4970 Grand Ave, Chandler, AZ, 852450.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
PRV-26883PRVJack Parker1957-11-06UHC-19681-90—7658 Pine Dr Apt 4, Las Vegas, NV, 891170.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-23409PRVJuan C Singh1968-07-02——4657 Cedar Ln, Miami, FL, 331550.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21481PRVSophia M Wilson1958-10-14UHC-22018-0294469331103631 Market St # 845, Nashville, TN, 372190.66Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+1 more
PRV-24076PRVAnn Mendez1964-02-12UHC-31441-4631684899594985 Park Pl, San Antonio, TX, 782930.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-28404PRVAndrea Harey1975-03-08UHC-45580-0691932608387038 Valley View Dr, Phoenix, AZ, 850750.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-24249PRVJordan Porter2001-04-17——2631 Highland Ave, Austin, TX, 787070.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-29301PRVDenise C Mason1965-02-19——4099 Canyon Rd, Atlanta, GA, 303140.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-20791PRVLinda Weaver1945-04-12UHC-05696-3759340933698132 Grand Ave, Seattle, WA, 981450.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22241PRVLori I Duncan1951-07-06UHC-68266-8992745270678977 Mesa Dr, Seattle, WA, 981640.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25558PRVAnn Garrett1977-01-19——6583 Oak St, Houston, TX, 770840.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22833PRVBrenda Turner1983-08-03UHC-44384-04—1252 Mountain View Dr, Columbus, OH, 432940.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20825PRVCynthia Gibson——25951059917483 Church St, San Diego, CA, 921440.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28772PRVAbigail Maldonado2008-08-23—66169835291734 Hillcrest Rd, Tampa, FL, 336500.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-27445PRVChristina Green1969-11-10—80675779548203 Jefferson Ave, Glendale, AZ, 853510.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27459PRVMichelle Miller1948-11-23—89893856541803 Main St, Houston, TX, 770990.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28687PRVWayne Ortiz2005-03-01UHC-34770-9874448467098399 Grand Ave, Atlanta, GA0.66Phone reformattedSSN last four extractedCity re-casedZIP missing+1 more
PRV-24748PRVSharon A Valdez1983-05-27UHC-61180-4382797626055645 Highland Ave, Phoenix, AZ, 850000.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-27254PRVSandra Obrien1975-11-28—44580893076992 Jefferson Ave, Fresno, CA, 937770.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27255PRVSandra Obrien1975-11-28—44580893076992 Jefferson Ave, Fresno, CA, 937770.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25889PRVMei White1958-08-20UHC-19755-6773359765343997 Central Ave, Eden Prairie, MN, 553290.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22762PRVAisha H Price1939-08-27UHC-23862-7540622835412027 Ocean Ave, Miami, FL, 331240.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26635PRVSean Gardner1964-07-20—73130754809447 Lake View Rd, Seattle, WA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-25748PRVAnn Hudson1947-09-06—28667648882748 Palm Dr, Eden Prairie, MN, 553200.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-28524PRVChristopher Mendez1989-01-10—67960615648230 Willow Ct, Miami, FL, 331990.66Two-digit birth yearPhone reformattedCity re-casedGender normalised+1 more
PRV-21753PRVHeather Q Taylor1945-07-23UHC-41950-845308836062753 Camelback Rd, Mesa, AZ, 852090.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
PRV-25559PRVJulie Jenkins1941-06-04UHC-74393-8645094986746858 Camelback Rd Apt 23, San Antonio, TX, 782080.66Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+1 more
PRV-20591PRVMei F Etrada1958-06-13UHC-89965-9698677509818211 Church St, Tempe, AZ, 852670.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20315PRVKenneth Wung1994-06-21——6751 Central Ave, Chandler, AZ, 852500.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-24269PRVMateo Elliott1995-02-27——5947 Valley View Dr, Orlando, FL, 328170.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26660PRVDylan Reid1943-12-05UHC-30535-4864554744982056 Mesa Dr, Plano, TX, 750580.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23480PRVVictoria Wang1940-10-15—78363072013793 Canyon Rd, Nashville, TN, 372070.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-24139PRVChris Green1954-06-08—93062454672440 Market St, Los Angeles, CA, 900720.66Name re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-24711PRVMargaret Lane1979-04-20—87252315242784 Spring St, Plano, TX, 750150.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
PRV-27251PRVMei Alexander1941-04-04UHC-21643-14—968 Ridge Rd, Sacramento, CA, 958200.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-22659PRVRaymond Pierce———9508 Market St, Eden Prairie, MN, 553280.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
PRV-20890PRVChristian T Rivera2000-04-11UHC-95771-5751228357252617 Sage Ct, Seattle, WA0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
PRV-28239PRVRoy Gonzalez1944-06-16UHC-99240-6595079681711918 Elm St, Chandler, AZ, 852930.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-22444PRVIsabella Williams2005-12-04—65054157421402 Maple Ave, Mesa, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-24346PRVJohn D Hery1944-01-19—85326149989524 Desert Sky Blvd, Atlanta, GA, 303910.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25214PRVJason Garrett——65740362347286 Baseline Rd, Phoenix, AZ, 850810.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
PRV-26762PRVStephanie Payne1974-07-04UHC-82530-782415154803640 Indian School Rd, Fresno, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-28975PRVBetty Griffin—UHC-23779-7539182744614989 Central Ave, Las Vegas, NV, 891630.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26380PRVBobby R Turner1943-12-25UHC-32889-502087869270484 Washington St, Houston, TX0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
9,596 rows, page 64 of 192PreviousNext