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-25278PRVRoger H Nelson1989-06-14—96847589671103 Desert Sky Blvd, Tucson, AZ, 857330.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26413PRVIzabella B Kennedy1951-08-10UHC-97057-9740523665272989 Ridge Rd, Chandler, AZ, 852170.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22189PRVJack Kelly1984-08-10UHC-72971-0235823695068029 Willow Ct, San Antonio, TX, 782300.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26342PRVJoe Stewart1953-02-11UHC-21317-805262346068286 Sage Ct, Los Angeles, CA, 900630.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24325PRVMei Allen1991-09-17UHC-06040-5079677003802703 Main St, Tampa, FL, 336340.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27661PRVCamila Herrera1946-01-08—47654110196176 Park Pl, Glendale, AZ, 853800.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22214PRVLee Julie1985-06-28UHC-59108-59—7238 Main St, Tucson, AZ, 857430.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25651PRVNicole Carr1961-06-14—40238027927331 Pine Dr, Phoenix, AZ, 850530.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-26817PRVChristina Contreras1967-07-06UHC-62827-359404286373—0.76Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more
PRV-28124PRVJohnny Lynch1973-03-02UHC-98159-4495377132524664 Maple Ave, Tempe, AZ, 852110.76Name re-casedDate of birth reformattedMember ID reformattedGender normalised+2 more
PRV-23421PRVNancy Stpehens2005-01-22—85447290678008 Ocean Ave, Scottsdale, AZ, 852050.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28201PRVPatricia Gardner2004-03-08UHC-34913-4068456256595921 Union St, Chandler, AZ, 852030.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27589PRVMariana Hansen1948-10-02—32970201317499 Desert Sky Blvd, Eden Prairie, MN, 553700.76Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+2 more
PRV-22072PRVJoshua Q Munoz1994-01-20—22145947924852 Washington St, Dallas, TX, 752370.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20635PRVAhmed Gutierrez1938-05-12—23367218366178 Forest Ave, Columbus, OH, 432040.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23810PRVJohn Hicks1993-02-23UHC-25546-25—4101 Hillcrest Rd, Charlotte, NC, 282990.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26097PRVGregory U Husdon1968-08-14UHC-14069-2127695589637983 Hillcrest Rd, Plano, TX, 750600.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23625PRVGregory Cole1995-09-24UHC-65103-9162621283142080 Washington St, Austin, TX, 787140.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29237PRVNatalie Ryan2004-06-05—30955225149790 Washington St, Minneapolis, MN, 554210.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22168PRVMateo A Lane1942-10-27—71052092733117 Pine Dr, Miami, FL, 331360.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22537PRVJack O Hudson1999-01-25—79071614829203 Broadway, Miami, FL, 331990.76Phone reformattedAddress re-casedCity re-casedState code upper-cased+2 more
PRV-29010PRVKatherine Q Wheeler1982-06-17UHC-14259-8294591710205094 Maple Ave, Las Vegas, NV, 891960.76Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-27472PRVDaniel Hudson1996-07-23UHC-33246-3543589145428069 Lincoln Way, Jacksonville, FL, 322450.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22258PRVDiana Rian1945-09-14—67425439483336 Market St, Tucson, AZ, 857360.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-22817PRVDanielle Torres2003-09-16—85583245723202 Central Ave, Orlando, FL, 328590.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25560PRVEugene Nunez1969-01-28—48993507032385 Mesa Dr, Sacramento, CA, 958070.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-23439PRVJose Rodriguez1972-10-11UHC-49925-883472183963385 Market St, Dallas, TX, 752610.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20116PRVTerry Martinez1970-10-08UHC-27731-5367238616085456 Park Pl, San Antonio, TX, 782510.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21893PRVStephen N Holmes1940-01-28UHC-84368-1721141544932998 Cedar Ln, Orlando, FL, 328510.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20859PRVKeith D Morales1973-08-27—55567046729255 Washington St, Plano, TX, 750090.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25806PRVJordan Carpenter1977-03-17——7257 Mesa Dr, Phoenix, AZ, 850880.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24465PRVTerry S Peterson1940-03-22—78266113223240 Apache Blvd, Los Angeles, CA, 900660.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21756PRVMei White1981-03-25——8916 River Rd, Jacksonville, FL, 322730.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-22532PRVMariana Anderson2000-10-14—8244073420340 Ocean Ave, Columbus, OH, 432740.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21133PRVJudy Gomez—UHC-18172-2994025049718411 Canyon Rd, Orlando, FL, 328400.76Name re-casedDate of birth unreadablePhone reformattedEmail lower-cased+2 more
PRV-29357PRVArthur Oliver1972-07-19——3820 Mountain View Dr, Minneapolis, MN, 554720.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-22407PRVStephanie Adams1955-12-25UHC-59976-7354060726443604 River Rd, Eden Prairie, MN, 553760.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-22686PRVCheryl Stephens2008-06-25—9423658387—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-22231PRVJoshua Turner2005-08-27UHC-57288-8640866969907345 Cedar Ln, Eden Prairie, MN, 553770.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-24209PRVRaymond Padilla1959-11-23—84929274146845 Maple Ave, Minneapolis, MN, 554390.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23840PRVArjun C Cruz2002-01-18—76147803402954 Palm Dr, Eden Prairie, MN, 553150.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
PRV-21314PRVPriya Warren1958-06-19UHC-43262-2993338686057010 Bayshore Dr, Tampa, FL, 336530.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27206PRVSharon Alexander1992-04-27—45268425014450 Ocean Ave, Dallas, TX, 752130.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28085PRVRalph Peterson1995-08-04UHC-53260-0545885719841958 Market St, Sacramento, CA, 958830.76Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-25691PRVAngela E Murray2004-11-25—942247295753 Elm St, Nashville, TN, 372150.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25244PRVTimothy Gordon1967-03-04UHC-69308-4849934649923260 Union St, Phoenix, AZ, 850050.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28537PRVMeriana Williamson1967-04-01UHC-94555-3148588576832955 Church St, Fresno, CA, 937080.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21193PRVLogan Mendoza1997-07-19UHC-83159-6632645630545812 Jefferson Ave, Tucson, AZ, 857280.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26782PRVSusan X Webb1952-10-06UHC-58050-5042892858242347 Lincoln Way, Eden Prairie, MN, 553900.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-20461PRVMartha G Carter1989-09-22—89233398418319 Lake View Rd, Las Vegas, NV, 891040.76Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
9,596 rows, page 86 of 192PreviousNext