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-27849PRVTony Hunt1939-05-02UHC-11062-0591344858137124 Mountain View Dr, Fresno, CA, 937950.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26154PRVDenny M Hansen1940-05-06—65844967284410 River Rd, Tampa, FL, 336670.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20951PRVEvelyn A Montgomery1980-09-25UHC-11441-1838071023923702 Valley View Dr, Eden Prairie, MN, 553790.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21366PRVKaren Walker1965-08-19UHC-57736-9944553964478920 Grand Ave, Denver, CO, 802880.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26775PRVElijah Rodriguez——88893134535994 Union St, Charlotte, NC, 282800.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21225PRVJames S Watson1963-01-06—4954177457784 Palm Dr, Jacksonville, FL, 322210.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26414PRVAnnna Ortiz1964-08-20UHC-88523-2059290686581887 Central Ave, Charlotte, NC, 282090.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27339PRVEmily F Porter1947-04-11UHC-00724-2985431176533895 Bayshore Dr, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-22267PRVDylan J Guerrero1944-04-17—56936450229202 Spring St, Las Vegas, NV, 891190.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21755PRVMei White——35367607908916 River Rd, Jacksonville, FL, 322730.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-21365PRVSam Johnston1978-02-08—32327512981434 Palm Dr, Las Vegas, NV, 891120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22718PRVJuan Hoffman2000-10-05UHC-66382-0130430435512964 Desert Sky Blvd, Denver, CO, 802400.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-29055PRVDiane Olson1981-07-11—63856909354637 Lake View Rd, Jacksonville, FL, 322570.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24429PRVDylan Hawkins1970-03-25UHC-26068-2947251750806252 Valley View Dr, Minneapolis, MN, 554480.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23815PRVSamuel Q Lnych1981-12-12UHC-18157-277306344799689 Market St, Plano, TX, 750950.64Two-digit birth yearPhone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-23814PRVSamuel Q Lnych1981-12-12UHC-18157-277306344799689 Market St, Plano, TX, 750950.64Two-digit birth yearPhone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-20525PRVDouglas K Moore1956-08-04UHC-27864-0569420898131328 Pine Dr, Denver, CO, 802660.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23408PRVJuna C Singh1968-07-02—55941196684657 Cedar Ln, Miami, FL, 331550.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21998PRVWillie Books1964-08-16——1402 Indian School Rd, Las Vegas, NV, 891780.64City re-casedState name converted to codeEmail lower-casedGender normalised+2 more
PRV-26033PRVMason P Foster1975-03-14—46627599378369 Bayshore Dr, Eden Prairie, MN, 553440.64Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-24707PRVMei S Luna1959-07-22—37033879826214 Pine Dr, Dallas, TX, 752850.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20268PRVScott Alexander1939-02-10—40199169936524 Lincoln Way, Glendale, AZ, 853920.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-28893PRVAnthony Elliott1979-10-12—31651870639411 Cedar Ln, Plano, TX, 750720.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21387PRVWilliam Fox1961-11-11UHC-95380-9737534896702561 Spring St, Charlotte, NC, 282430.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22925PRVPamela Ruiz1970-10-10UHC-62098-0395052585221086 Meadow Ln, Tampa, FL, 336660.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28853PRVAustin Miller2001-11-16—74268384441627 Church St, Minneapolis, MN, 554760.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23708PRVMegan R Porter1975-01-10UHC-46101-45—3600 Harbor Blvd, San Antonio, TX, 782100.64Name re-casedTwo-digit birth yearState name converted to codePlan code upper-cased+2 more
PRV-27995PRVThomas A Reynolds1946-11-28UHC-63941-86—4967 Valley View Dr, San Antonio, TX, 782050.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21438PRVKmiberly J Willis1954-04-24—22743402845805 Park Pl, San Diego, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20473PRVRonald G Gonzales1951-05-19UHC-77889-07—2738 Central Ave, Jacksonville, FL, 322390.64Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-22655PRVDiane Sanders2003-04-09UHC-96847-8277862672172151 Mesa Dr, Miami, FL, 331640.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22664PRVDoris Ford1985-08-03UHC-09446-7327449380964869 Meadow Ln, Mesa, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-22854PRVJustin Vargas2004-09-15UHC-10790-4158088809063263 Hillcrest Rd, Los Angeles, CA, 900350.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26135PRVDonna Sullivan1998-01-01UHC-84309-2757868880927269 Broadway, Atlanta, GA, 303930.64Name re-casedPhone reformattedAddress re-casedZIP+4 trimmed+2 more
PRV-25450PRVSean K Jordan1968-11-12UHC-98220-6132696382916969 Canyon Rd, Jacksonville, FL, 322340.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28466PRVDylan Lynch1999-03-16—86092098185219 Baseline Rd, Orlando, FL, 328660.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26608PRVDanny Cunningham1943-08-03UHC-00723-2258698957082249 Mesa Dr, Glendale, AZ, 853250.64Name re-casedPhone reformattedState name converted to codeGender normalised+2 more
PRV-22581PRVJudith H Lopez1955-12-23UHC-71589-8286565049637203 Market St, Columbus, OH, 432830.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23779PRVMichelle C Suto1966-06-26—53341840495905 Maple Ave Apt 34, Dallas, TX, 752110.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
PRV-28873PRVPatrick Robinson1971-12-01—59633554521715 Ridge Rd, Denver, CO, 802310.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22076PRVSofia J Kim2007-02-04UHC-90210-5459724037082261 Ocean Ave, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23596PRVWilliam Alvarez1944-01-18——8942 Ridge Rd, Plano, TX, 750850.64Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+2 more
PRV-21796PRVEmyly U Lopez2004-08-12UHC-26356-0841270162753277 Forest Ave, Seattle, WA, 981530.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23231PRVJuan Dixon1982-04-10—49073748207198 Church St # 782, Atlanta, GA, 303670.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-28464PRVJustin Jensen1953-10-24——3327 River Rd, Jacksonville, FL, 322230.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-22274PRVHarold D Mitchell2005-12-08UHC-40615-47—5445 Union St, Los Angeles, CA, 900490.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22284PRVJacqueline Peters1986-06-16—43646465509069 Forest Ave, Jacksonville, FL, 322280.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26295PRVCarolyn Park1956-12-06UHC-04264-5955255512512140 Union St, Scottsdale, AZ, 852480.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27626PRVBilly Hudson1996-07-06—27730510957901 Market St, Chandler, AZ, 852490.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-20195PRVHenry Ramos1958-10-28—79579835322976 Camelback Rd, Houston, TX0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 45 of 192PreviousNext