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-419913CLMCynthia Jimenez1989-07-14——7864 Market St, Columbus, OH, 432220.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-430448CLMAnna Rice1944-03-24UHC-25879-1265250284388413 Mesa Dr, Atlanta, GA, 303210.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-421848CLMEric Perkins—UHC-30832-4473788737123134 Mountain View Dr, Fresno, CA, 937670.64Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-409000CLMAlan Ortiz2008-07-18UHC-87483-9537860247678517 Highland Ave, Columbus, OH, 432030.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404945CLMJoe Salazar1995-08-18UHC-98084-2584944684408258 Hillcrest Rd, Seattle, WA, 981080.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429151CLMMichelle Lucas1976-03-21UHC-38152-13—6230 Valley View Dr, Sacramento, CA, 958430.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401285CLMAustin Rice1961-08-09UHC-01782-0563390883093657 Elm St, Tempe, AZ, 852170.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431122CLMBradley Clark2005-09-18—44642953671924 Sage Ct, Tampa, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417338CLMJerry Rmaos1974-10-07—38940922735136 Elm St Apt 36, Sacramento, CA, 958800.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
CLM-413796CLMMatthew Hall1983-03-09UHC-86977-16—6673 Harbor Blvd, Fresno, CA, 937790.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405306CLMDenise Sandoval1990-02-16——7820 Jefferson Ave, Houston, TX, 770970.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404657CLMMarcus Wells—UHC-49609-6297822291889829 River Rd, Denver, CO, 802250.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402148CLMBobby Wilson1971-02-25UHC-12643-12—633 Meadow Ln, Miami, FL, 331170.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411092CLMLuis Garcia1978-11-12—29562167878262 Main St, Scottsdale, AZ, 852960.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432823CLMMaggie Z Patel1991-06-28UHC-64158-8225955169686042 Hillcrest Rd, Austin, TX, 787910.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412570CLMNoah Sims2002-05-14—45583568427793 Harbor Blvd, Chandler, AZ, 852150.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406521CLMBobby Matthews1973-05-04UHC-97499-9086674541175402 Grand Ave, Tempe, AZ, 852530.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427475CLMShirley Lopez—UHC-32327-7461520967933855 Palm Dr, Plano, TX, 750850.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404157CLMRaymnd Castro1997-10-20UHC-84200-38—6647 Harbor Blvd, Eden Prairie, MN, 553860.64Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
CLM-432745CLMRachel S Young1961-08-26UHC-25987-4541843448518725 Cedar Ln, Phoenix, AZ, 850760.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409624CLMBruce Adams1943-08-25——1940 Grand Ave, Austin, TX, 787330.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-412307CLMIsabella Black1988-09-02—8686574633521 Spring St, San Diego, CA, 921040.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403911CLMDonna Griffin1944-10-13—42485720419479 Pine Dr, Chandler, AZ, 852570.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-406229CLMBilly Contreras1984-05-25——1811 Valley View Dr, Miami, FL0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-410265CLMShirley N James1958-03-17UHC-50985-20—4874 Canyon Rd, Tempe, AZ, 852120.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432150CLMBenjamin Cooper1968-06-14UHC-69545-33—2277 Maple Ave, Sacramento, CA, 958200.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-431003CLMKenneth Murphy1958-07-17UHC-62459-213904287949356 Baseline Rd Apt 8, Houston, TX, 770430.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419758CLMGeorge Valdze1998-11-25UHC-34806-1789091283333498 Church St, Charlotte, NC, 282450.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428323CLMMichelle G Harrison2000-04-28—78993072912767 Indian School Rd # 822, Jacksonville, FL, 322040.64Name re-casedPhone reformattedUnit split from streetGender normalised+2 more
CLM-417491CLMRichard Q Hawkins1963-06-14UHC-05462-25—8626 Indian School Rd, Minneapolis, MN0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-415436CLMMatthew Gilbert1950-10-25UHC-74569-95—8101 Bayshore Dr, San Diego, CA, 921980.64Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-402159CLMAna Fox1954-09-13UHC-70153-8069864024239363 Lake View Rd, Minneapolis, MN, 554960.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402017CLMRaymond Hall1978-08-11—85476463253690 Elm St, San Antonio, TX, 782980.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420521CLMJudith Ford1949-12-12UHC-34094-3380737444804607 Mountain View Dr, Miami, FL, 331470.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427443CLMPhilip Valdez2002-07-04UHC-98601-37—2007 Mountain View Dr, Eden Prairie, MN, 553200.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-430634CLMAlexis Morrison1949-03-08——4439 Apache Blvd, Tampa, FL, 336460.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427836CLMMichelle Harrper1952-04-17UHC-59426-45—3693 Union St, Plano, TX, 750800.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403546CLMTeresa Wilson1977-09-18UHC-45385-633675462817456 Canyon Rd, Tucson, AZ, 857750.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405108CLMWalter S Wallace1947-11-07UHC-21909-8161175351384602 Washington St, Tampa, FL, 336660.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401565CLMVincent George———2954 Lincoln Way, Phoenix, AZ, 850290.64Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-405947CLMSharon C Aguilar1990-09-19UHC-98678-80—4558 Pine Dr, Atlanta, GA, 303580.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429454CLMJose Yang1996-12-24UHC-79343-17—6764 Ridge Rd Apt 25, Tampa, FL, 336570.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405495CLMLori Fowler1972-10-21UHC-41558-853782491059194 Church St Apt 5, Tampa, FL, 336400.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400763CLMBilly Thomas1961-12-16——394 Cedar Ln, Mesa, AZ, 852200.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-423452CLMAmber Wells1953-04-11——3814 Palm Dr, Eden Prairie, MN0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421343CLMEugene Spencer1980-09-06—7877832098480 Bayshore Dr, San Antonio, TX, 782140.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-409317CLMJulie Reynolds2003-09-10——9505 Meadow Ln, Seattle, WA, 981360.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402252CLMNancy Bennett——41225559217655 Bayshore Dr, Denver, CO, 802440.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402770CLMGloria Perez1980-02-17UHC-82117-1467663052588074 Pine Dr, Tampa, FL, 336350.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-430067CLMDona Bell—UHC-23412-40——0.64Name re-casedDate of birth unreadableEmail lower-casedGender normalised+2 more
32,829 rows, page 148 of 657PreviousNext