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-29226PRVLarry Wong2001-10-02UHC-68223-9273858955075452 Ridge Rd, Orlando, FL, 328860.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-27122PRVMadison Edwards1995-01-13—43568305307010 Meadow Ln, Charlotte, NC, 282770.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22059PRVJacob Kim1958-07-15UHC-18672-9648774896248072 Elm St, Jacksonville, FL, 322910.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23592PRVJudy Jimenez2006-07-10UHC-73726-1537399748864481 Camelback Rd, Tampa, FL, 336190.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-26881PRVHarold Ramirez1943-04-28UHC-18546-9672231607786606 Forest Ave, Charlotte, NC, 282600.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22851PRVHannh Lewis2002-06-28——236 Church St, Denver, CO, 802270.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-29335PRVLogan Flores1967-12-06UHC-41865-4761169889887165 Sunset Blvd, Sacramento, CA, 958760.74Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27453PRVKayla Martin1981-02-09—73038822402860 Spring St, Nashville, TN, 372180.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20218PRVJake Obrien1952-12-07UHC-35819-3589743929856666 Mountain View Dr Apt 37, Dallas, TX, 752000.74Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
PRV-20502PRVAustin Torres1970-06-15—32436022506803 Canyon Rd, Jacksonville, FL, 322680.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28304PRVDennis O Dean1974-02-06UHC-07591-253653866925863 Forest Ave, Gilbert, AZ, 852730.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26010PRVSamuel Bailey1979-06-20UHC-79455-8035255826511831 Spring St, Mesa, AZ, 852840.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-22175PRVCarroll C Pat1986-01-15—51064898499191 Meadow Ln, San Antonio, TX, 782800.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26339PRVAnna Y Greene1986-02-14—98752173919359 Lake View Rd, Denver, CO, 802220.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26056PRVTimothy Scott1949-07-22—2379101779449 Palm Dr, Nashville, TN, 372950.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-29392PRVJulie Miller2007-01-20UHC-50358-4662784060307356 Camelback Rd, Tucson, AZ, 857100.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-29420PRVCatherine Romero1952-02-09UHC-95527-1194453790199615 Camelback Rd, Tempe, AZ, 852630.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27127PRVDavid Lynch1968-09-13UHC-56000-7073866796947366 Union St, Tempe, AZ, 852070.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28065PRVLauren R Murphy1969-08-21—92372970882578 Lake View Rd, Orlando, FL, 328450.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23862PRVCynthia Ray1944-07-28UHC-77905-1498554656992807 Lake View Rd, Houston, TX, 770710.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22660PRVAaron J Bell1940-03-15UHC-97382-4851588575536456 Baseline Rd, Houston, TX, 770850.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20783PRVJarry Haart1992-09-03UHC-00989-2747494307162072 Pine Dr, Los Angeles, CA, 900530.74Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28495PRVJoe Burns1984-01-14UHC-76864-1463980772733433 Indian School Rd, Houston, TX, 770760.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-24264PRVJudith Howell1993-05-02UHC-20985-0355447839675164 Park Pl, Houston, TX, 770810.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-22999PRVJanice Dunn1953-04-18—69090128543591 Oak St, Denver, CO, 802490.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27616PRVRichard Alvarez1952-08-20UHC-56524-9628524527637885 Sunset Blvd, Phoenix, AZ, 850800.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27342PRVSofia Smith1988-05-13UHC-24303-0438293828766410 Oak St, Tempe, AZ, 852570.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-25426PRVPeter West1938-08-09—68560537316880 Valley View Dr, Fresno, CA, 937770.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20170PRVStephanie Hamilton1986-01-08UHC-85850-8182739981626645 Highland Ave, Phoenix, AZ, 850850.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26456PRVNancy I Williamson1948-03-24UHC-86218-7582451174668444 Apache Blvd, Fresno, CA, 937810.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-27249PRVPeter Fisher1973-04-19UHC-49647-8450536432279503 Broadway Apt 37, Dallas, TX, 752520.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-21081PRVFatima Green1971-01-19UHC-56858-968975855235764 River Rd, Minneapolis, MN, 554420.74Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
PRV-21465PRVAustin V Berry2007-04-07UHC-63286-3253757017999431 Central Ave, Eden Prairie, MN, 553290.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24430PRVDaniel Jackson1951-11-21UHC-96969-1388173435799136 Baseline Rd, Denver, CO, 802420.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27299PRVSofia Lucas1969-04-12UHC-89122-7266064422349873 Union St, Austin, TX, 787440.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26333PRVMarcus Howell1997-01-01UHC-94996-608419915857337 Mesa Dr, San Antonio, TX, 782160.74Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+3 more
PRV-26539PRVBobby Sandoval1957-04-03UHC-01331-4069095164998910 Harbor Blvd, Charlotte, NC, 282450.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-28116PRVCharlotte Z Silva2007-01-27UHC-82786-432937090294822 Lake View Rd, Fresno, CA, 937390.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-23867PRVNancy Santiago1974-03-03—76471897163929 Camelback Rd, Eden Prairie, MN, 553460.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25046PRVAmy V Espinoza1996-03-02—63855860273957 Sage Ct, Dallas, TX, 752330.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25128PRVAlexis Walker1962-07-15UHC-81179-5337156795562604 Highland Ave, Phoenix, AZ, 850130.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25961PRVIsabella Barnes2006-03-11—40867155311853 Oak St, Mesa, AZ, 852520.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20704PRVRandy Harrison1985-11-20—71245528935559 Sage Ct, Chandler, AZ, 852260.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22482PRVAhmed H Wagner1981-01-01—3142204944212 Bayshore Dr, Seattle, WA, 981210.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29279PRVSamantha Y Thompson1977-08-09UHC-17634-8777760403125712 Pine Dr, Glendale, AZ, 853060.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28931PRVChristian Thomas2005-10-19—68344767344914 Market St, Gilbert, AZ, 852740.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26741PRVWilliam V Perce1971-02-24UHC-54866-3562826850894291 Pine Dr, San Antonio, TX, 782280.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22042PRVKaith Duncan1943-02-28—65128410161784 Sage Ct, Orlando, FL, 328260.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26347PRVChristian Mendez1983-12-11——9346 Market St, Tucson, AZ, 857100.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25735PRVDiaen N Yang2001-09-09UHC-11444-52261606981477 Main St, San Antonio, TX, 782080.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
9,596 rows, page 79 of 192PreviousNext