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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-407103CLMMark Fisher1991-05-05UHC-49886-815787790779585 Spring St, Chandler, AZ, 852580.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-429583CLMVictoria Lnych1983-07-12—38680373725827 Indian School Rd, Sacramento, CA, 958210.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417503CLMCarolyn Luna1999-11-27—42866993569464 Maple Ave, San Antonio, TX, 782480.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425904CLMJonathan B Rivera1953-04-10UHC-42719-7658697246418587 River Rd # 518, Phoenix, AZ, 850700.74Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-402113CLMAlbert Craawford1942-11-20UHC-09010-7883723208232926 Ocean Ave, Glendale, AZ, 853470.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416473CLMRuth Mills1958-02-08UHC-76487-9872235047156603 Elm St, Nashville, TN, 372050.74Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411861CLMNathan Olson1993-12-09—69334335107076 Washington St, Gilbert, AZ, 852860.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415156CLMJean Carpenter1966-02-01UHC-69541-0977799169153025 Bayshore Dr, Tempe, AZ, 852870.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411679CLMCarolyn J Fisher1951-05-24UHC-83736-1951533106417001 Baseline Rd, Eden Prairie, MN, 553780.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
CLM-413293CLMCarl Park1963-01-14UHC-65013-1963725633939297 Ocean Ave, Fresno, CA, 937410.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409262CLMTerry E Rivera1993-04-10UHC-56476-0523394556834242 Hillcrest Rd, Miami, FL, 331590.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404144CLMKathleen K Carpenter1965-06-13UHC-24892-682586454641—0.74Name re-casedPhone reformattedMember ID reformattedGender normalised+3 more
CLM-408540CLMSantiago J Fowler1946-12-10UHC-38032-372975307721566 Broadway Apt 8, Las Vegas, NV, 891970.74Name re-casedPhone reformattedUnit split from streetAddress re-cased+3 more
CLM-431466CLMLori Mason2005-03-16——6710 Main St, Seattle, WA, 981280.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413979CLMMartha Maldonado1965-02-23UHC-91916-41—4490 Market St, Nashville, TN, 372660.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420789CLMSara Santigao1996-01-19UHC-85534-1525959481012345 Valley View Dr, Denver, CO, 802510.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407729CLMLuis X Oliver1999-04-15UHC-83023-0964337379076924 Oak St, Tucson, AZ, 857720.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432578CLMMelissa Allen1954-02-25UHC-41301-7083765211309662 Main St, Chandler, AZ, 852840.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424563CLMBruce Burke1979-08-05—39476905493592 Market St, Seattle, WA, 981200.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426094CLMKayla Schmidt1973-12-05—61054452067183 Sunset Blvd, Columbus, OH, 432760.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-432203CLMHelen Jacobs1998-02-04UHC-52233-8476324330772811 Desert Sky Blvd, Las Vegas, NV, 891600.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412459CLMAmy Williamson1988-06-15—56622357392430 Pine Dr, Orlando, FL, 328680.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417365CLMSirley Griffin2008-09-22UHC-80810-0291537130743836 Oak St, Denver, CO, 802620.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401547CLMMichael Clrk1966-05-02UHC-15951-2897247338873630 Maple Ave, Denver, CO, 802320.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413445CLMEmily Sandes1943-06-20UHC-15252-8869528885301004 Central Ave, Glendale, AZ, 853130.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-413275CLMJoe Peters1999-06-14UHC-86752-6222358465594227 Market St, Miami, FL, 331800.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409072CLMNicole Q Jensen1995-11-22UHC-78290-1050346827137398 Indian School Rd, Phoenix, AZ, 850660.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404897CLMWayne Weaver1954-08-08UHC-84816-2128493445698045 Main St, Austin, TX, 787100.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422775CLMBrenda Simmons1969-10-10—96045810122504 Hillcrest Rd, San Diego, CA, 921810.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425614CLMBryan V Edwards1981-02-28—98998662884716 Park Pl, Tampa, FL, 336000.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405302CLMRoger V Jensen1977-04-21UHC-86142-7796043699318290 Indian School Rd, Jacksonville, FL, 322930.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-414325CLMIsabella Park1972-06-27UHC-23698-5161631827103705 Hillcrest Rd, Denver, CO, 802900.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400520CLMDanielle Fuller1963-03-07—25726061228088 Central Ave, Phoenix, AZ, 850570.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420223CLMMaria E Wells1945-03-19UHC-02332-78—7304 Mountain View Dr, Phoenix, AZ, 850990.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-423968CLMJonathan Dominguez1990-09-08—45023504032989 Lincoln Way, Scottsdale, AZ, 852530.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
CLM-408455CLMMragaret Hunter2005-01-01UHC-03826-6084678276832931 Oak St, Chandler, AZ, 852720.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415749CLMBrian Reed1964-12-08UHC-65423-747015018114586 Ocean Ave, Dallas, TX, 752090.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431451CLMJordan Brooks1963-03-19UHC-55414-72—9719 Church St, Plano, TX, 750530.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413349CLMFrances Carpenter1989-07-13UHC-94353-4627893705781399 Mountain View Dr, Plano, TX, 750460.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420352CLMWright Helen1968-04-24UHC-67550-8662387754331666 Sunset Blvd, Phoenix, AZ, 850190.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409507CLMAdam Garrett1986-12-01UHC-27878-4080793114821351 Ocean Ave, Seattle, WA, 981390.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429788CLMNanyc Q Marshall1961-03-10UHC-91729-2826355453559776 Main St, Phoenix, AZ, 850730.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429895CLMRalph T Fowler1998-08-16UHC-37591-3525825887303163 Oak St, Miami, FL, 331660.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-420695CLMKaren Y Perez1955-07-03—49834334742263 Palm Dr, Nashville, TN, 372500.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-430209CLMAlan Gilbert1965-01-14UHC-63930-87—7071 Union St, Columbus, OH, 432980.74Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411301CLMDonald Anderson1955-04-02UHC-91846-26—6274 Highland Ave, Phoenix, AZ, 850290.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407707CLMMarcus Jones1952-02-04UHC-16298-63—9174 Indian School Rd, Tampa, FL, 336210.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422335CLMLrry Marshall1971-07-04UHC-53367-57—1466 Grand Ave, Minneapolis, MN, 554100.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411763CLMIsabella Montgomery2007-08-20UHC-13566-8747461848572219 Union St, Jacksonville, FL, 322630.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416527CLMChuck Griffin1970-05-26UHC-14601-2361632102339665 Maple Ave, Mesa, AZ, 852510.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
32,829 rows, page 229 of 657PreviousNext