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-20805PRVMark Ray1947-03-25—75968286587803 Valley View Dr, Chandler, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29389PRVHenry K Ellis1950-01-01—41160160821632 Central Ave, San Antonio, TX, 782500.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21069PRVAustin Mendoza1939-04-11—94079877794656 Baseline Rd, Chandler, AZ, 852450.60Name re-casedDate of birth reformattedCity re-casedState code upper-cased+4 more
PRV-20006PRVMargaret K Bell2006-07-25UHC-39574-66—4859 Elm St, Tampa, FL, 336180.60Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more
PRV-27052PRVEvelyn U Contreras1977-01-11—80727244158517 Sunset Blvd, Jacksonville, FL, 322400.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21236PRVStephen Hicks2003-03-01—35955640902494 Oak St, Austin, TX, 787820.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29463PRVNicole Ortega2003-03-20UHC-23371-2183050371712244 Maple Ave # 939, Fresno, CA0.60Name re-casedPhone reformattedUnit split from streetCity re-cased+4 more
PRV-20421PRVDonald T Johnston1945-11-27—5666986636942 Harbor Blvd Apt 28, Glendale, AZ, 853560.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-21250PRVJeffrey S Larson1955-09-24UHC-00373-9528955141595242 Jefferson Ave, Scottsdale, AZ, 852360.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24382PRVHenry Stevens1970-10-26UHC-50709-3681389423419556 Sunset Blvd, Eden Prairie, MN, 553430.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23912PRVMatthew N Fowler1946-10-15—66061374105316 Washington St, Chandler, AZ, 852350.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27132PRVPetter O Wells1946-05-19—30551041752917 Mesa Dr, Miami, FL, 331280.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27887PRVKeith Watson1991-02-08UHC-99757-957104688661907 Central Ave, San Antonio, TX, 782650.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29472PRVRebecca Howard1998-06-19UHC-89882-7179557298687322 Camelback Rd, Austin, TX, 787510.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24295PRVSantiago J Wong1981-08-16UHC-46520-40—7006 Mesa Dr, Jacksonville, FL, 322430.60Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22364PRVChristine Chen1943-01-02—90129377867525 Apache Blvd, Atlanta, GA, 303970.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24588PRVEthan Welch1991-03-18UHC-78275-7861350241263867 Highland Ave, Miami, FL, 331990.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-23645PRVDan Franklin1938-08-17UHC-66712-4884272914424019 Mountain View Dr Apt 13, Atlanta, GA, 303400.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
PRV-24132PRVCarlos U Daniels1943-06-12—49541714447763 Main St, Gilbert, AZ, 852180.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-21912PRVJoan Estrada1989-09-22—72644513915173 Highland Ave, Nashville, TN, 372980.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29066PRVAaron Freeman1945-07-07—97925658436995 Oak St, Mesa, AZ, 852160.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25868PRVGeorge E James1951-11-26—39582031554063 Willow Ct # 191, Columbus, OH, 432030.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-27999PRVAlexander W King1974-02-01UHC-17995-0227494525162968 Main St, Phoenix, AZ, 850710.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
PRV-20887PRVJudith Pena1939-08-25UHC-47584-4556151052681931 Baseline Rd, Denver, CO, 802650.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27569PRVDay O Kathleen1966-11-21—41467530983932 Meadow Ln Apt 31, Tampa, FL, 336600.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-24779PRVJoshua Porter1966-08-05——6813 Maple Ave, Scottsdale, AZ, 852260.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22290PRVCarlos Hamilton1956-01-21UHC-99654-3564241320007313 Desert Sky Blvd, Tampa, FL, 336350.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23284PRVPamela Rojas1976-04-09UHC-38278-60—2815 Elm St, Plano, TX, 750100.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23928PRVKelyl Hart1972-01-16—33877848091560 Canyon Rd Apt 25, Miami, FL, 331990.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-23927PRVKelyl Hart1972-01-16—33877848091560 Canyon Rd Apt 25, Miami, FL, 331990.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-26170PRVNick Alexander1955-02-23UHC-81486-0754669500286174 Central Ave, San Diego, CA, 921540.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20075PRVMadison H Boyd1997-10-09—49576314305761 Central Ave Apt 32, Nashville, TN, 372300.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-21463PRVDiana O Harrison1966-08-06—40131855297744 Central Ave, Gilbert, AZ, 852640.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28840PRVChris Ortega1970-12-12UHC-45995-1879237633043105 Oak St, Charlotte, NC, 282780.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27044PRVBanks W Angela1989-12-03UHC-53594-0472956884876844 Oak St, Fresno, CA, 937780.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29388PRVMargaret M Stone1939-12-20UHC-82602-399749293907854 River Rd, Phoenix, AZ0.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-20286PRVCarl W Sandoval1998-04-01—89590739721075 Elm St, Plano, TX, 750320.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24316PRVBenjamin U Hansen1939-12-09—4323077747723 Lincoln Way, Scottsdale, AZ, 852760.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-29164PRVCarl Sims1964-06-26UHC-22625-5189673867763056 Indian School Rd, Tucson, AZ, 857810.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28155PRVDonna Ramos1995-10-06UHC-64152-8578272364317499 Baseline Rd, Tempe, AZ, 852780.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-27483PRVDonald Q Kelly2007-12-04UHC-24828-97—7800 Meadow Ln, San Antonio, TX, 782660.60Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more
PRV-20908PRVAnn Taylor1945-09-03—42991177427489 Valley View Dr, Scottsdale, AZ, 852130.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-23680PRVJack Z Arnold2007-11-16—70196612032516 Central Ave, Denver, CO, 802120.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-21845PRVTerry E Dunn1970-06-22UHC-54521-8941931524491568 Cedar Ln, San Antonio, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26822PRVArthur Jimenez2001-02-01UHC-75581-4370443033014586 Lake View Rd, Eden Prairie, MN, 553420.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29133PRVDigo Moreno1957-09-05—58691190578878 Central Ave, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29167PRVCarl Sims1964-06-26UHC-22625-5189673867763056 Indian School Rd, Tucson, AZ0.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29166PRVCarl Sims1964-06-26UHC-22625-5189673867763056 Indian School Rd, Tucson, AZ0.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21605PRVSara Y Carr2001-07-14UHC-62944-7350494520511350 Market St, Scottsdale, AZ, 852380.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27855PRVSandra Martin——97785383415929 Indian School Rd, Columbus, OH, 432270.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
9,596 rows, page 24 of 192PreviousNext