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-28417PRVRalph Arnold1998-08-26—91437920781334 Jefferson Ave # 442, San Antonio, TX, 782540.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28416PRVRalph Arnold1998-08-26—91437920781334 Jefferson Ave # 442, San Antonio, TX, 782540.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27886PRVRebecca Stevens——23436567422879 Lincoln Way, Los Angeles, CA, 900970.64Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more
PRV-23441PRVSamantha T Welch1970-08-20UHC-81164-0443088651833081 Jefferson Ave, San Antonio, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22788PRVAngela Q Hawkins2003-04-13—86320206788940 Church St, Mesa, AZ, 852760.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-22427PRVJason Ramirez1998-11-21UHC-37350-1822761458406727 Valley View Dr, Minneapolis, MN, 554910.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-24633PRVMei Hunt1946-12-20UHC-84600-88—7787 Baseline Rd, Phoenix, AZ, 850530.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26325PRVPriya Stewart1976-08-09UHC-29329-4946727702486977 Hillcrest Rd, Jacksonville, FL0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28969PRVEdward Boyd——71733383748783 Willow Ct, San Diego, CA, 921230.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27487PRVRiick Jenkins1953-09-25—40097938631374 Forest Ave, Austin, TX, 787150.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24367PRVJooyce Gonzales1996-07-20UHC-24623-1023765668593425 Pine Dr Apt 20, Jacksonville, FL, 322440.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27431PRVDouglas Yang—UHC-45248-33—6930 Lincoln Way, Fresno, CA, 937900.64Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+2 more
PRV-27274PRVBenjamin Alvarado1960-08-19UHC-00426-3965668119558188 Mesa Dr, Sacramento, CA, 958260.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29576PRVMaria D Fields1944-03-23—42498724747659 Hillcrest Rd, Minneapolis, MN, 554890.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-23524PRVKathryn X Lopez2001-01-08—93633172702249 Valley View Dr, Scottsdale, AZ, 852650.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25250PRVMariana Ryan1955-05-09——2596 Valley View Dr, Plano, TX, 750820.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-26917PRVCarlos Palmer1983-09-21—46072334509440 Palm Dr # 423, Tampa, FL, 336510.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24177PRVPaul Collins1958-04-25UHC-68079-9577054654992464 Central Ave, San Diego, CA, 921240.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22617PRVAlice Fox1956-01-28—75569182674968 Mountain View Dr, Charlotte, NC, 282910.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22785PRVAngela Wang1967-03-01UHC-43079-7066798899668641 Valley View Dr, Orlando, FL, 328870.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27505PRVAndrew A Harper1980-05-08UHC-99041-2594681994205722 Lincoln Way, Tempe, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22386PRVKimberly Young1974-07-18—36121868675824 Washington St, Mesa, AZ, 852910.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-29032PRVBenjamin K Vasquuez2006-04-10UHC-82637-5530420958845631 Mountain View Dr, Orlando, FL, 328790.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-20654PRVJamse Marshall2006-09-03UHC-35247-8135464439912554 Willow Ct, San Antonio, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22464PRVJanet Holmes2001-05-05UHC-27263-0976081325715096 River Rd, Las Vegas, NV, 891480.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25720PRVWei Hamilton1938-05-27——4558 Cedar Ln, Plano, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21223PRVCamila Delgado1975-06-05UHC-77210-2688962519864527 Desert Sky Blvd, Glendale, AZ, 853010.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24462PRVDiego W Lawson1966-10-07UHC-46964-3644797887538363 Cedar Ln, Mesa, AZ, 852370.64Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22349PRVValentina Adams1955-01-24UHC-04850-4753561652613261 Mesa Dr, Seattle, WA, 981300.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27669PRVChristopher Mendoza1986-10-10—33936311301970 Central Ave, Nashville, TN, 372680.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-27135PRVStephanie B Porter1974-01-20UHC-82341-8285258363603850 Jefferson Ave, Los Angeles, CA, 900860.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26630PRVLarry Riley1938-04-13UHC-29158-6631139699884797 Mountain View Dr, Orlando, FL0.64Name re-casedCity re-casedZIP missingGender normalised+2 more
PRV-24443PRVGrace Jenkins1998-10-08—62447334194259 Sage Ct, Tampa, FL, 336080.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-25358PRVJaack N Burns——30458368994753 Apache Blvd, San Diego, CA, 921970.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29349PRVStephanie Elliott1957-09-15—36881065112713 Bayshore Dr, Gilbert, AZ, 852520.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
PRV-27630PRVEric Robertson2008-07-10UHC-01745-7821862717673096 Union St, Fresno, CA, 937660.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23789PRVMary Robinson2006-01-16—76432676217941 Valley View Dr, Mesa, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25271PRVJustin Johnson1992-03-02—65479591973789 Valley View Dr, Eden Prairie, MN, 553040.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23967PRVAnthony L Palmer1953-06-21UHC-35596-296407435110867 Elm St, Fresno, CA, 937550.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28721PRVAngela O Harrison1950-06-12—26689819062120 Sunset Blvd, Jacksonville, FL, 322390.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24055PRVJulie Li1986-01-24—93127464362088 Ocean Ave, Miami, FL, 331360.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23546PRVNancy Gray1941-07-06—33638459375749 Ridge Rd, Mesa, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23545PRVNancy Gray1941-07-06—33638459375749 Ridge Rd, Mesa, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21424PRVAustin Wong1961-03-19UHC-52819-8675799560477229 Cedar Ln, Los Angeles, CA0.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-22498PRVMarshall J Christian1994-01-04UHC-58093-6984850916165719 Sunset Blvd Apt 37, Minneapolis, MN, 554780.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-27460PRVThomas Matthews2002-08-28UHC-58466-91—8141 Mountain View Dr, Miami, FL, 331610.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24480PRVBetty W Romero1970-01-02UHC-86415-5355528749955730 Union St # 903, Tucson, AZ, 857770.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23490PRVAndrew Lee1991-10-06——9648 Grand Ave, Eden Prairie, MN, 553420.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-21576PRVDaniel T Williams1993-11-01UHC-57654-5534125900568390 Park Pl, Minneapolis, MN, 554080.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21777PRVMark Foster1939-07-22—98462639814474 Sage Ct Apt 34, Fresno, CA, 937130.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
9,596 rows, page 53 of 192PreviousNext