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-408822CLMZachary Bryant2006-07-04UHC-87908-2788074071051840 Sage Ct, Charlotte, NC, 282530.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-432024CLMRandy Parker1952-10-17——5505 Grand Ave, Houston, TX, 770130.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
CLM-423371CLMDeborah M Clark1985-04-10—23341451341310 River Rd, Fresno, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-402746CLMYki Collins1983-01-13UHC-91200-07—1167 Camelback Rd, Jacksonville, FL, 322480.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401962CLMMateo Stewart1957-12-19UHC-20020-02—6550 Jefferson Ave, Denver, CO, 802610.66Name split from “Last, First”Two-digit birth yearMember ID reformattedState code upper-cased+1 more
CLM-408377CLMRalph Z Graham1981-01-27UHC-10242-73—3792 Palm Dr, San Diego, CA, 921270.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414108CLMWalter Estrada1990-03-23UHC-60096-2957767420384182 Main St, San Antonio, TX, 782170.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-410192CLMDenise Guerrero1997-11-18——638 Central Ave, Tempe, AZ, 852910.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-421472CLMArjun Reynolds1987-10-08UHC-54196-28—5920 Willow Ct, Glendale, AZ, 853820.66Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+1 more
CLM-425967CLMSophia Walker——9819677772—0.66Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-424127CLMDorothy Hayes2007-11-07UHC-27529-31—6272 Bayshore Dr, Tucson, AZ, 857290.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-417777CLMHenry Hudson1962-05-17—39953197233276 Camelback Rd, Glendale, AZ, 853740.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-404409CLMMatthew Y White1973-02-19——8059 Valley View Dr, Gilbert, AZ, 852240.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424538CLMMark E Scott1987-01-02—74383974204446 Washington St, Tucson, AZ, 857920.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411503CLMJeffrey Y Valdez1998-02-08UHC-15233-48—5176 Baseline Rd, Atlanta, GA, 303100.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-404159CLMPriya Chavez1999-09-07UHC-11128-2042736220843976 Market St, Chandler, AZ, 852780.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425115CLMChristine Whiet1945-10-20UHC-96746-66—9707 Bayshore Dr, Gilbert, AZ, 852690.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-429939CLMLaurne I Johnson1991-06-02——1441 Central Ave, Tempe, AZ, 852000.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-403982CLMSandra X Price1965-04-25UHC-17641-18—1307 Lincoln Way, Atlanta, GA, 303380.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-419810CLMLawrence Smiith1964-03-19UHC-22685-39—259 Central Ave, Orlando, FL, 328770.66Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
CLM-405794CLMNathan Moore2000-08-01——2651 Central Ave, Eden Prairie, MN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-417467CLMAlice Harper1979-06-01——6995 Meadow Ln, Plano, TX, 750170.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-430036CLMCarolyn Moreno1969-02-05UHC-38849-3043375092089513 Desert Sky Blvd, Orlando, FL0.66Date of birth reformattedPhone reformattedZIP missingGender normalised+1 more
CLM-420447CLMPatrick Boyd1977-05-24——7545 Mesa Dr, Mesa, AZ0.66Name re-casedDate of birth reformattedZIP missingGender normalised+1 more
CLM-411742CLMPriya Tucker1981-02-07UHC-26060-45—619 Ocean Ave, Jacksonville, FL, 322480.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-423444CLMLarry N Salazar1959-01-11UHC-88293-0461739759063354 Park Pl, Gilbert, AZ, 852570.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
CLM-428370CLMScott Kelley1995-07-25UHC-50527-90—9189 Canyon Rd, Seattle, WA, 981000.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-421258CLMDot M Bradley1952-09-12——634 Canyon Rd # 238, Seattle, WA, 981000.66Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+1 more
CLM-422284CLMMaria Cunningham1959-10-20UHC-51601-8589880858327075 Pine Dr, Los Angeles, CA, 900080.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428509CLMFrank Lawrence1945-09-08UHC-55442-7587266260506136 Harbor Blvd, Fresno, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-403200CLMSamantha Watson1998-11-08UHC-51081-8169141935973602 Ocean Ave, Phoenix, AZ, 850060.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416582CLMMason Ramirez1988-07-17UHC-04462-47—7429 Bayshore Dr, Jacksonville, FL, 322960.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-400853CLMNicholas Colemna1945-09-10UHC-80494-31—441 Washington St, Chandler, AZ, 852940.66Two-digit birth yearCity re-casedState name converted to codeWhitespace trimmed+1 more
CLM-420462CLMPatrick Valdez1950-04-27—63837438855078 Canyon Rd, Minneapolis, MN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-428812CLMRallph Tran1938-12-26——9090 Pine Dr, Sacramento, CA, 958760.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-430900CLMVirginia N Harvey1955-12-22UHC-76444-8853747302344131 Main St, Columbus, OH, 432840.66Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424554CLMSantiago Franklin1954-10-10—95991790216914 Oak St, Mesa, AZ, 852990.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-410136CLMRoger U Ray1977-08-03UHC-43599-50—4127 Apache Blvd, Mesa, AZ, 852140.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412806CLMMatthew B Phillips1974-09-16UHC-56067-4137578647259725 Jefferson Ave, Austin, TX, 787550.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405152CLMDouglas Hrnandez1945-10-12UHC-13991-22—1934 Lincoln Way, San Antonio, TX, 782130.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-432205CLMMarc V Allen1984-07-06—7872124274474 Harbor Blvd Apt 5, Eden Prairie, MN, 553910.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-402851CLMOlivia Chapman1975-01-18—61673770919683 Market St, Eden Prairie, MN, 553970.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408407CLMAna Gray1969-02-06UHC-67181-466554210090887 Mountain View Dr # 367, Sacramento, CA, 958120.66Name re-casedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-402379CLMJulia Bailey1954-05-06UHC-66212-73—9691 Church St, Charlotte, NC, 282510.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401296CLMGeorge Medina1973-04-16UHC-11140-3535948544032311 Sunset Blvd, Seattle, WA, 981920.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423688CLMAaron E Johnson1978-11-04—43479224159581 Indian School Rd, San Antonio, TX, 782830.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400392CLMEthan Lewis1948-02-25UHC-22221-92—5473 Lincoln Way, Houston, TX, 770410.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411866CLMHelen West—UHC-20637-25—5497 Lincoln Way, Mesa, AZ0.66Name re-casedDate of birth unreadableZIP missingWhitespace trimmed+1 more
CLM-419193CLMJoan Burton1996-12-17UHC-29497-54—4143 River Rd, Denver, CO, 802530.66Two-digit birth yearGender normalisedPlan code upper-casedWhitespace trimmed+1 more
CLM-403708CLMLogan Sanchez1970-12-08UHC-37017-96—1334 Ridge Rd, Chandler, AZ, 852680.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
32,829 rows, page 154 of 657PreviousNext