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-23606PRVKyle Hall1971-12-28UHC-40356-4549871648663425 River Rd, Eden Prairie, MN, 553960.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23064PRVPaul A Crawford2000-04-03UHC-85132-11—5404 Highland Ave, Columbus, OH, 432980.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24739PRVRivera Logan1976-05-01UHC-27810-9577477955878658 Elm St Apt 11, Phoenix, AZ0.52Date of birth reformattedMember ID reformattedUnit split from streetZIP missing+2 more
PRV-22066PRVHeather P Wagner1991-12-14UHC-68131-4744734708164720 Canyon Rd, Miami, FL, 331740.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21962PRVJudith K Daniels1940-03-13—5416562075862 Sunset Blvd, Phoenix, AZ, 850150.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23666PRVDennis Castro2000-05-06—32684423295520 Washington St Apt 16, Miami, FL, 331740.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-27273PRVJerry Jordan1997-06-11UHC-64857-0596724154412771 Spring St Apt 17, Tempe, AZ, 852440.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27527PRVCharlotte V Nichols1970-05-19UHC-53965-5081482440593495 Market St # 722, Columbus, OH0.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
PRV-26424PRVNancy Graham1959-03-19—70946051284350 Apache Blvd, Seattle, WA, 981970.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-28328PRVDennis Kelley1978-04-18UHC-97854-1479322201503742 Meadow Ln, Chandler, AZ, 852170.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22106PRVDylan Watkins2007-10-27—8029169881343 Bayshore Dr, Seattle, WA, 981910.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26229PRVDoris Bell—UHC-49343-4462776602853718 Forest Ave, Nashville, TN, 372650.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-26098PRVBarbara Z Fields——31831965595933 Oak St, Glendale, AZ0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-20123PRVJacqueline Chen1997-08-07——5143 Grand Ave, Los Angeles, CA, 900110.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-26360PRVHelen Williams1996-06-22—78980986146789 Canyon Rd, Houston, TX, 770460.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25981PRVJose Griffin1973-12-16UHC-35738-0194048606014251 Mountain View Dr, Atlanta, GA, 303030.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-25343PRVAbigail Owens1964-11-24UHC-36998-8887546491449000 Valley View Dr Apt 35, Chandler, AZ, 852470.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-21961PRVNoah Nguyen1976-10-23UHC-84004-0996239493412884 Lake View Rd Apt 7, Gilbert, AZ, 852450.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27951PRVJohn Z Bryant1951-11-03—62784749469217 Elm St, Orlando, FL0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27686PRVDouglas R Woods1940-01-07——2430 Elm St, Columbus, OH0.52Middle initial moved out of first namePhone missing area codeState code upper-casedZIP missing+2 more
PRV-24157PRVLisa Huughes2005-08-28—43355631723596 Main St # 498, Las Vegas, NV, 891780.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-27794PRVMark Morgan1981-04-13UHC-34154-2352427336092340 Pine Dr # 761, Tampa, FL, 336070.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-25862PRVJudy Schmidt2002-02-05—63739236454339 Park Pl Apt 12, Tempe, AZ, 852330.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
PRV-28784PRVJulia Z Nelson1997-06-11—81421350206787 Maple Ave, Tucson, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25229PRVMatthew P Riec1999-03-22—86894716316058 Apache Blvd, Houston, TX, 770660.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21341PRVJesse F Fowler1998-12-11UHC-13704-8751346058294715 Sage Ct # 627, Miami, FL0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21142PRVValentina Saalazar1971-07-20UHC-13048-6875582639697124 Desert Sky Blvd, Charlotte, NC, 282650.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24298PRVJacob Watkins1948-01-23—98252317421221 Church St, Fresno, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-27378PRVMary Simpson1957-08-17——9133 River Rd, Jacksonville, FL, 322210.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22171PRVDorothy Medina1967-10-19UHC-55197-73—1837 Pine Dr, Houston, TX, 770410.52Name re-casedPhone missing area codeState name converted to codeZIP+4 trimmed+2 more
PRV-21889PRVKennth Roberts1976-01-07——2936 Hillcrest Rd, Chandler, AZ, 852680.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-25228PRVAdam I Lttle1943-08-22—55154240281689 Mountain View Dr, Nashville, TN, 372010.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23247PRVCamila Turner1990-05-10UHC-89373-5860096679299865 Mesa Dr, Charlotte, NC, 282180.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
PRV-24925PRVNuah Turner1949-03-28——441 Palm Dr # 868, Chandler, AZ, 852870.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22216PRVDonna Ford1941-04-09—25059444186615 Canyon Rd Apt 31, Las Vegas, NV, 891570.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26171PRVDennis C Ryvera1996-06-18——7168 Forest Ave Apt 36, Tempe, AZ, 852980.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28104PRVRaymond Phillips1995-01-28UHC-34319-1140373412971479 Baseline Rd, Glendale, AZ, 853140.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23337PRVAhmed I Patel2005-02-09UHC-86063-1361239709187258 Apache Blvd, Austin, TX, 787660.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23590PRVVirginia F Smith1963-08-07UHC-21841-47—4860 Canyon Rd, Las Vegas, NV, 891530.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23744PRVGloria Allen1976-12-08UHC-05703-453084703302585 River Rd, Austin, TX, 787730.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-27554PRVBradley Flures1978-11-17UHC-20706-4090343003343417 Indian School Rd, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22144PRVLori S Williams1984-07-03—20180010397541 Washington St, Fresno, CA, 937340.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24460PRVLinda C McDonald1987-03-12UHC-89393-8634048308784266 Broadway Apt 3, Miami, FL, 331920.52Two-digit birth yearUnit split from streetAddress re-casedZIP+4 trimmed+2 more
PRV-24883PRVArthur D Rios1956-06-28UHC-53771-89—583 Market St, Mesa, AZ, 852400.52Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-26220PRVOmar T Davis1980-11-19—78836651742400 Mountain View Dr, Nashville, TN, 372410.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-21165PRVEmily Valdez1942-11-17——2291 Ridge Rd, Orlando, FL, 328550.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22328PRVBrittany Q Graham1987-01-04UHC-81173-0953760236133057 Sunset Blvd, Tampa, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-26601PRVJudith Mittchell—UHC-88504-2783496331626212 Meadow Ln, Tucson, AZ0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-20868PRVKathleen O Gibson2007-07-19UHC-89929-3833524730294256 Washington St, Seattle, WA, 981470.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28854PRVVirginia Hansen1944-07-06——3692 Sunset Blvd Apt 30, Jacksonville, FL, 322200.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
9,596 rows, page 18 of 192PreviousNext