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-21741PRVFrances Anderson1976-02-05—32483464427806 Market St, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21742PRVFrances Anderson1976-02-05—32483464427806 Market St, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26387PRVPatrick Mendez1963-09-16——6528 Church St, Plano, TX, 750990.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-26130PRVCarol Rogers1973-06-14UHC-29452-5664376766426820 Hillcrest Rd # 482, Minneapolis, MN, 554270.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-29347PRVDiego P Dominguez1985-01-01—66672321383937 Lake View Rd, Austin, TX, 787840.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
PRV-21705PRVHannah Schmidt1959-01-13UHC-54182-06—5316 Park Pl, San Antonio, TX, 782260.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22573PRVLori Butler1981-02-20UHC-75436-96—405 Indian School Rd, Nashville, TN, 372700.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
PRV-23677PRVAmber Kennedy1969-02-27—66220724291169 Apache Blvd, Los Angeles, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25582PRVSophia Evans1974-12-27UHC-44844-7380262810869437 Sunset Blvd, Chandler, AZ, 852300.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22901PRVHenry T Espinoza1959-07-26——1745 Church St, Austin, TX0.52Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+2 more
PRV-28914PRVAlan Lopez1983-04-13UHC-37303-83—6719 Union St, Gilbert, AZ0.52Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more
PRV-20598PRVDavid F Kelley1970-06-19—4127037771979 Mountain View Dr Apt 35, Dallas, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23803PRVSara Espinoza1997-01-27UHC-90159-047938200340859 Grand Ave, Tempe, AZ, 852010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-22808PRVJordan D Sandoval1984-10-14UHC-19789-28—1497 Bayshore Dr Apt 40, Tempe, AZ, 852290.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20942PRVArthur M Hall1938-11-24—2655323170686 Church St, Glendale, AZ, 853600.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-25025PRVGregory U Woods1998-03-11UHC-74086-93—2736 Oak St, San Diego, CA, 921360.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21151PRVKenneth Payne1973-10-27UHC-66838-75—4077 Grand Ave, Chandler, AZ, 852230.52Name re-casedTwo-digit birth yearSSN last four extractedState name converted to code+2 more
PRV-27893PRVElijah Weaver1954-12-01UHC-12057-3639124032862757 Cedar Ln, Seattle, WA, 981800.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
PRV-23968PRVStephanie S Castillo1999-07-09—35766520336638 Grand Ave, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-27636PRVKathryn Warren1959-03-12—31671364606289 Jefferson Ave, Los Angeles, CA, 900130.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-27969PRVKelly Z Perez——51281887248643 Lincoln Way, Sacramento, CA0.52Date of birth missingZIP missingEmail lower-casedGender normalised+2 more
PRV-21721PRVDeborah Baker1994-06-22—57151857093889 Canyon Rd, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21011PRVBradley Gilbert2005-03-24——600 Maple Ave, Las Vegas, NV, 891230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24700PRVJennifer Wong1988-03-02—72356249182502 Sunset Blvd # 313, San Antonio, TX, 782580.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25261PRVTheresa L Garza1942-10-28——877 Cedar Ln # 244, Atlanta, GA, 303190.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24471PRVFrank F Nelson1997-09-14——9185 Elm St, Chandler, AZ, 852220.52Phone missing area codeSSN last four extractedCity re-casedState name converted to code+2 more
PRV-22463PRVJanet Holmes2001-05-05—76081325715096 River Rd, Las Vegas, NV0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-22026PRVPriya Cook1956-08-04—85939016068550 Cedar Ln, Eden Prairie, MN, 553260.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26299PRVAlexis Hill1952-02-12UHC-64036-10—4089 River Rd, Tucson, AZ, 857880.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22006PRVCheryl Rivera1963-09-14——7489 Apache Blvd, Phoenix, AZ, 850390.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-21823PRVJeremy Walker1958-05-11UHC-68255-8940376061147404 Lincoln Way, Seattle, WA0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
PRV-28170PRVMei Harris1945-10-08UHC-08874-1573140839752008 Maple Ave, Los Angeles, CA, 900370.52Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-29192PRVWayne Lopez2001-12-26—63960903218070 Highland Ave, Dallas, TX, 752960.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-29485PRVCheryl Gibson1999-05-15—29448190186044 Willow Ct, Los Angeles, CA, 900800.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21788PRVDiana Berry1978-03-11UHC-53245-5368165813248859 Spring St, Miami, FL, 331970.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23390PRVAlice Ortega1948-01-20—75676656484708 Camelback Rd, Miami, FL, 331940.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28484PRVLucia B Watkins—UHC-64281-09—952 Bayshore Dr, Scottsdale, AZ, 852000.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-20223PRVDouglas M Morales1952-08-19——2023 Maple Ave, Gilbert, AZ, 852260.52Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24063PRVCamila Burton2003-01-14——6355 Mesa Dr, Seattle, WA, 981850.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-28254PRVLogan J Larson1945-04-19—98668874576157 Forest Ave, Phoenix, AZ, 850530.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20084PRVChristine Salazar1973-11-05UHC-75118-47—7127 Sunset Blvd, Plano, TX, 750200.52Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more
PRV-26511PRVMadison H Ramos1994-04-06—29397888942845 Market St, Columbus, OH0.52Name re-casedPhone reformattedState name converted to codeZIP missing+2 more
PRV-21302PRVPatricia T Gonzales2002-07-18UHC-73800-42—5925 Cedar Ln, Minneapolis, MN0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20886PRVJonathan L Sullivan1976-01-10UHC-13997-3126948715647212 Mesa Dr # 208, Gilbert, AZ, 852310.52Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more
PRV-20856PRVArjun Turner1984-09-08——8735 Valley View Dr, Phoenix, AZ, 850670.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24422PRVThersea Harris1958-09-18UHC-49222-72—7303 Valley View Dr, Miami, FL, 331450.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28861PRVKaren Alexander1975-02-26——6849 Cedar Ln, Nashville, TN, 372540.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
PRV-21148PRVDanielle Lynch2000-02-09UHC-65454-97—1905 Elm St, Minneapolis, MN, 554320.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-23348PRVValentina Ortiz1958-09-28UHC-23200-97—2148 Willow Ct, Columbus, OH0.52Name split from “Last, First”State code upper-casedZIP missingGender normalised+2 more
PRV-24926PRVDebra C Robertsson1983-01-04UHC-55599-5271050049084220 Canyon Rd, Seattle, WA, 981340.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
9,596 rows, page 19 of 192PreviousNext