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-22217PRVLawrence Maldonado1994-07-20—81329809197498 Main St, Glendale, AZ0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28650PRVChristopher Davis1986-04-14——6306 Jefferson Ave, Atlanta, GA, 303010.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22293PRVLuis Carlson—UHC-63765-77—8906 Meadow Ln, Tempe, AZ0.38Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-20182PRVKenneth Dunn1950-03-15UHC-30577-22—345 Harbor Blvd, Atlanta, GA, 303900.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-22071PRVJoshua Munoz1994-01-20—22145947924852 Washington St, Dallas, TX0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23980PRVAdam Snyder1964-09-27UHC-25891-4859346297719660 Market St Apt 28, Denver, CO0.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-29371PRVAbigail S Webb1997-07-23——7718 Harbor Blvd, Chandler, AZ, 852380.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25581PRVSophia Evans1974-12-27—80262810869437 Sunset Blvd, Chandler, AZ, 852300.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29564PRVSusan Hart1938-10-02UHC-24309-1935560063182889 Maple Ave Apt 21, Fresno, CA0.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25503PRVRoy Q Simpson1956-07-16UHC-12089-1696777551199767 Harbor Blvd, Gilbert, AZ0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27984PRVAlbert U Johnston1961-05-09UHC-58242-5755487785045512 Highland Ave, Tucson, AZ, 857500.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25043PRVJoyce G Price1964-01-27——3725 Jefferson Ave, Columbus, OH0.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-24130PRVBeth R Howard2001-12-10——6188 Church St, San Antonio, TX, 782140.38Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-28133PRVBrandon T Bennett1939-08-21—83730455421280 Camelback Rd # 719, Tucson, AZ, 857320.38Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-28696PRVHenry King1989-12-02——3949 Central Ave Apt 11, Las Vegas, NV0.38Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
PRV-22615PRVMary Moreno1992-12-28—91677916782055 Cedar Ln Apt 30, Phoenix, AZ, 850500.40Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24012PRVTheresa A Cook1987-01-13—49924856978803 Mountain View Dr # 687, Denver, CO, 802970.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-25364PRVEric Hayes———4894 Spring St # 773, Jacksonville, FL, 322640.40Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27803PRVCynthia D Carlson1997-07-15—37458512584545 Park Pl, Chandler, AZ, 852970.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-26444PRVLarson Joan1949-09-16——2943 Pine Dr, Tempe, AZ0.40Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+2 more
PRV-25434PRVBobby Rodriguez1967-01-04UHC-12282-59—2655 Bayshore Dr Apt 13, Phoenix, AZ, 850520.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-25433PRVBobby Rodriguez1967-01-04UHC-12282-59—2655 Bayshore Dr Apt 13, Phoenix, AZ, 850520.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24345PRVCynthia Jensen1959-05-28UHC-82520-15—454 Apache Blvd Apt 36, Columbus, OH, 432770.40Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+2 more
PRV-27011PRVMichael Matthews1998-09-14—39329321619134 Grand Ave, Glendale, AZ, 853740.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-27749PRVAaron Davis—UHC-45592-8477278381641381 Highland Ave, San Antonio, TX0.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-23217PRVCatherine Cunningham1972-06-16——615 River Rd, Sacramento, CA, 958370.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-25064PRVKelly Torres1948-09-25—49588073454174 Ocean Ave, Eden Prairie, MN, 553040.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24156PRVCharlotte Washington2005-08-24UHC-01290-5498369330031416 Washington St Apt 15, Denver, CO, 802110.42Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21865PRVJessica Larson1995-02-09—59634890323604 Maple Ave # 500, Las Vegas, NV0.42Name split from “Last, First”Unit split from streetState name converted to codeZIP missing+1 more
PRV-26115PRVDonna Burns1948-08-23UHC-39950-6736665388834001 Meadow Ln, Scottsdale, AZ, 852230.42Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+7 more
PRV-22167PRVZachary Hughes1988-02-18UHC-96105-20—4613 Canyon Rd, Seattle, WA, 981210.42Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21056PRVMichelle Hamilton1990-01-02—46183633587834 Grand Ave, Austin, TX, 787720.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
PRV-28193PRVJeffrey Nelson1962-10-20UHC-95285-4033243798641426 Camelback Rd, Sacramento, CA, 958280.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-21506PRVWillie Lucas—UHC-42851-6540339890503884 Palm Dr, Jacksonville, FL, 322940.44Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+6 more
PRV-24037PRVMason Rios1950-09-14UHC-34110-1122082205288770 Washington St Apt 16, Glendale, AZ, 853400.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-23659PRVBrenda Henry2004-01-05—69981261062034 Cedar Ln Apt 18, Chandler, AZ0.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-29575PRVMaria Fields1944-03-23—42498724747659 Hillcrest Rd, Minneapolis, MN, 554890.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-23726PRVMegan Wilson1956-03-14UHC-27377-9567330167079499 Market St, Denver, CO, 802470.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-21018PRVLarry L Mills1998-01-13—5265578622155 Harbor Blvd # 679, Gilbert, AZ, 852090.44Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-25231PRVCarlos S McCoy1981-10-23—23675260354191 Grand Ave, Plano, TX, 750610.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
PRV-27018PRVBenjamin Cox1983-03-07UHC-68145-7840195488472173 Main St, San Antonio, TX, 782300.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-21725PRVNoah Pena1977-02-21—70344085659475 Canyon Rd, Fresno, CA0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-22077PRVAustin Henderson1993-03-13UHC-20641-0246881298414944 Indian School Rd Apt 2, San Diego, CA, 921140.44Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
PRV-27343PRVKelly Burton1980-10-12UHC-06398-6176745875249072 Park Pl, Dallas, TX, 752170.44Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more
PRV-21329PRVRebecca Munoz1958-09-21—34857368478264 Hillcrest Rd # 969, Charlotte, NC, 282600.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-21330PRVRebecca Munoz1958-09-21—34857368478264 Hillcrest Rd # 969, Charlotte, NC, 282600.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-23458PRVMichelle Haansen1952-03-09UHC-96691-0158723646374178 Baseline Rd, Charlotte, NC, 282740.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
PRV-27404PRVWei Knight2003-01-13—65651213265983 Harbor Blvd # 742, Minneapolis, MN, 554400.44Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
PRV-28219PRVDeborah Ray1944-02-03UHC-55168-607986907373596 Indian School Rd, Sacramento, CA, 958840.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-22608PRVBarbara T Austin1980-07-02UHC-09800-5923430118204185 Bayshore Dr, Tampa, FL0.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
9,596 rows, page 4 of 192PreviousNext