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-26167PRVSam Jones1956-09-12——8027 Union St, Tucson, AZ, 857870.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21661PRVHarold N Ray1946-09-21UHC-61684-71—5887 Jefferson Ave, Phoenix, AZ, 850470.52Middle initial moved out of first nameName re-casedPhone missing area codeStreet suffix standardised+2 more
PRV-27464PRVBetty Watkins1994-07-17UHC-83199-3839320355046891 Palm Dr, Tempe, AZ, 852860.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-27520PRVAdnrea Salazar——60688652638269 Mesa Dr, Columbus, OH, 432700.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-21559PRVRyan Z Warren1946-08-13UHC-88581-012195835859243 Sunset Blvd Apt 12, Nashville, TN0.52Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+2 more
PRV-20952PRVAlexis Garcia——78472617609065 Desert Sky Blvd, Charlotte, NC, 282150.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-26882PRVSara K Roberts1950-08-19—53888982227982 Maple Ave, Fresno, CA, 937990.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25622PRVRussell Valedz1968-04-09UHC-94337-1063682164551589 Willow Ct, Tampa, FL, 336520.52Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-21430PRVZachary Ortega1947-11-11UHC-23727-64—7811 Washington St, Fresno, CA0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25633PRV—Junk2002-03-22——4094 Apache Blvd, Los Angeles, CA, 900850.52Date of birth reformattedPhone missing area codeState name converted to codeWhitespace trimmed+2 more
PRV-29531PRVDot U Fernandez1958-06-18——4640 Pine Dr Apt 37, San Diego, CA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26398PRVFrank Arnold1969-03-10UHC-80971-8268134218052031 Central Ave, San Antonio, TX, 782980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27676PRVCarlos Estrada1969-05-14——4195 Ocean Ave, Denver, CO, 802810.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21080PRVFatima Green1971-01-19UHC-56858-968975855235764 River Rd, Minneapolis, MN, 554420.52Name split from “Last, First”Date of birth reformattedCity re-casedState name converted to code+2 more
PRV-22159PRVChristina Meyer1958-09-22UHC-53968-3778537666729661 Maple Ave, Sacramento, CA, 958610.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24469PRVJoshua Gordon1958-12-25——4104 Union St, Jacksonville, FL, 322860.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-28113PRVGrace Wong2000-12-03——3571 Spring St, Sacramento, CA, 958340.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-21214PRVCarlos Gray1941-08-12UHC-64484-73—8227 Grand Ave, San Diego, CA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
PRV-20810PRVGerald P Li1954-12-24—79132136257477 River Rd, Jacksonville, FL0.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21987PRVAaron Willis1938-05-01UHC-70017-39—8138 Ridge Rd, Los Angeles, CA, 900210.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24817PRVAmanda Washington2000-07-01UHC-98242-3477378831722909 Spring St, Charlotte, NC0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-20457PRVMateo Shaw1955-06-19—93855708061818 Church St # 860, San Antonio, TX, 782810.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-29017PRVKye A Hunt1959-07-03—20335740489635 Highland Ave, Denver, CO, 802540.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
PRV-26505PRVDonna Hansen1961-06-10—870450680533 Meadow Ln, Atlanta, GA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28973PRVChristopher Evans1905-10-23—84396334999894 Maple Ave, Tucson, AZ, 857300.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23066PRVPaul Burke1956-05-24—94053550527574 Apache Blvd, Eden Prairie, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26721PRVHeather Hart1960-06-27UHC-02743-9263850637178139 Highland Ave, Jacksonville, FL, 322120.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21622PRVAlice Welker—UHC-55066-7630841758093598 Willow Ct, Minneapolis, MN, 554370.52Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+2 more
PRV-29220PRVLauren Ryan—UHC-05185-183286179340514 Lake View Rd, Glendale, AZ, 853140.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-23150PRVAmanda Ortiz2003-09-19UHC-69544-44—7344 Baseline Rd, Seattle, WA, 981250.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-28223PRVRonald C Stone1938-12-18UHC-53111-7576095298552406 Apache Blvd, Gilbert, AZ, 852950.52Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-26904PRVElijah T Henderson1980-02-17UHC-24951-3922057840838438 Camelback Rd, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+2 more
PRV-23211PRVSandra Morgan1939-05-20UHC-28897-69—1706 Palm Dr, Denver, CO, 802870.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24358PRVNancy C Rojas1999-06-09UHC-90304-33—6782 Pine Dr, Houston, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-24614PRVJacqueline Gonzales1997-03-13UHC-44443-9654322961785010 Cedar Ln, Mesa, AZ, 852260.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
PRV-21118PRVHannah X Nguyen1972-05-08—72355258658201 Meadow Ln, Dallas, TX, 752930.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24717PRVElijah Montgomery—UHC-48585-51—6026 Sage Ct Apt 5, Denver, CO, 802300.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
PRV-28122PRVSarah N Washington1975-02-02UHC-90115-2831363968377915 Meadow Ln, Fresno, CA0.52Date of birth reformattedState name converted to codeZIP missingGender normalised+2 more
PRV-25742PRVDanielle L Lewis1943-03-16—72798932398665 Mountain View Dr # 811, Phoenix, AZ, 850350.52Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+2 more
PRV-20046PRVMari Davis—UHC-35556-5257547170215103 Willow Ct, Tempe, AZ, 852470.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28605PRVBruce Fox1979-09-06UHC-44206-8177399399254844 Cedar Ln, Austin, TX, 787440.52Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
PRV-29315PRVDoris Espinoza———5805 Meadow Ln, Scottsdale, AZ, 852440.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-28922PRVBilly Wnag1952-12-17—28387107789796 Canyon Rd # 922, San Antonio, TX, 782460.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-26956PRVBryan Franklin1981-12-17——325 Valley View Dr, Scottsdale, AZ, 852000.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24880PRVLori Lee1943-09-07—77938283077843 Sunset Blvd, Scottsdale, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25456PRVNoah Munoz1973-01-26——5381 Pine Dr, Houston, TX, 770950.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-20254PRVJeffrey S Dixon2007-02-12——3804 Hillcrest Rd, Mesa, AZ, 852230.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23634PRVNoah E Sims2002-05-14UHC-54449-78—7793 Harbor Blvd, Chandler, AZ, 852150.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23264PRVDebra Hill1947-12-10—30665532363871 Bayshore Dr, Phoenix, AZ, 850410.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22440PRVGloria Webb1941-12-28UHC-39563-01—7915 Mountain View Dr, Austin, TX, 787570.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
9,596 rows, page 17 of 192PreviousNext