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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-141970ENREmily O Taylor1946-06-08UHC-53019-8148344109606234 Elm St Apt 35, Charlotte, NC, 282380.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431045CLMChristine Sullivan2007-09-24——4856 Indian School Rd, Eden Prairie, MN, 553320.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-26223PRVScott Hansen1943-04-11——212 Meadow Ln, Minneapolis, MN, 554010.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-52806TPABilly Bennett1952-01-25——1043 Sage Ct, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113532ENRMegan T Garcia1979-11-28UHC-85835-9482965065879530 Forest Ave, Austin, TX, 787230.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-28020PRVCamila Phillips1977-11-17UHC-26863-5738737905873465 Hillcrest Rd # 705, Atlanta, GA, 303050.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28611PRVHarold Green———5450 Spring St, Seattle, WA0.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
PRV-24002PRVLogan T Pihllips1962-04-09UHC-41116-08—2237 Market St # 861, Seattle, WA0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53981TPATerry E Owens1967-05-12—29420997622368 Camelback Rd, Mesa, AZ, 852310.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426614CLMElizabeth Rodrigeuz1963-12-06—27871509217374 Sage Ct, Tampa, FL, 336020.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134082ENRMelissa S Hicks1954-01-18UHC-05893-6078537544938011 Central Ave, Tempe, AZ, 852660.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedCity re-cased+3 more
ENR-131659ENROlivia Cole1982-06-23UHC-64377-815763539617915 Valley View Dr, Tampa, FL, 336590.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54398TPASharon Ellis1983-09-20—93644275628570 Maple Ave, Phoenix, AZ, 850850.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22390PRVSarah Marshall1941-06-20——4580 River Rd, Tucson, AZ, 857080.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-114552ENRLori Cruz1954-01-08UHC-43223-0343235315123912 Main St Apt 17, Austin, TX, 787300.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21289PRVHenry Y Little1979-03-06—47777834286925 Hillcrest Rd, Plano, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141659ENROmar O Vasquez1948-02-20UHC-98026-9033891281042352 Spring St, Atlanta, GA, 303490.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52268TPAMariana Carlson1958-07-21UHC-83774-86—3744 Elm St, Minneapolis, MN0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-403147CLMMargaret James1943-09-04——831 Grand Ave, Tempe, AZ, 852400.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-138189ENRAmy K Morrison1977-02-06UHC-29243-3348463967844055 Palm Dr, Austin, TX, 787940.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58269TPACarol Walker1946-02-09——8826 Canyon Rd # 879, Sacramento, CA, 958910.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54122TPAJustin Russell1972-06-26——2618 Church St Apt 35, Nashville, TN0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22354PRVWayne I Chavez1995-08-11UHC-99718-582886107037586 Ocean Ave, Fresno, CA, 937250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101980ENRAlice X Le1943-10-22UHC-49554-665785317456845 Bayshore Dr, Charlotte, NC, 282340.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431165CLMRachel Walker1993-07-16——5745 Willow Ct, Denver, CO0.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413054CLMVirginia F Dominguez1997-03-24UHC-47834-81—9376 Elm St, Orlando, FL, 328460.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-120386ENRArjun Chavez1979-07-17UHC-26292-8298261618753090 Apache Blvd, Tucson, AZ, 857700.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-428798CLMRussell Weaver1962-04-14UHC-60979-31—3160 Pine Dr, Phoenix, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-142009ENRLisa Knight—UHC-55792-7941285348942320 Palm Dr, Dallas, TX, 752150.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-125208ENRCamila E Fowler1956-08-27UHC-16999-7669328464118730 River Rd, Eden Prairie, MN, 553690.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400140CLMSofia Nunez1980-07-22UHC-92875-982684198246277 Lake View Rd, Nashville, TN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109754ENRChristopher X Adams1956-06-26UHC-88794-67—4764 Spring St, Atlanta, GA, 303330.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-109755ENRChristopher X Adams1956-06-26UHC-88794-67—4764 Spring St, Atlanta, GA, 303330.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
PRV-21320PRVCastro John1993-10-13UHC-60495-9562740799063188 Spring St Apt 20, Orlando, FL, 328400.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28540PRVJesse Bell1983-01-06—32820750036700 Spring St, Orlando, FL, 328590.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-108645ENREmma X Meyer1997-06-18UHC-13185-09—4208 Palm Dr # 288, Eden Prairie, MN, 553340.50SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-132237ENRRandy U Fox1941-10-24UHC-87702-5741252872568737 Valley View Dr, Minneapolis, MN0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-134413ENRTom O Ortiz2003-10-15UHC-63591-9841668544562226 Lincoln Way, Eden Prairie, MN, 553000.50Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+3 more
ENR-138636ENRWayne W Fuller1986-06-06UHC-56628-5351971805521113 Camelback Rd, Tucson, AZ, 857740.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-404343CLMDonald Coleman1984-12-24UHC-72406-8059042752181107 Maple Ave, Austin, TX, 787270.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101086ENRShirley Santiago1957-01-23UHC-02122-8963852600454627 Apache Blvd, Tempe, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413236CLMDavid Lynch1959-02-27UHC-52815-4790299032526485 Harbor Blvd, Dallas, TX, 752920.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29546PRVHiroshi Butler—UHC-41564-7334871747484742 Oak St, Denver, CO0.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-111433ENRJennifer H McCoy1993-09-28UHC-33786-5465887415867647 Sunset Blvd, Dallas, TX, 752410.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-113130ENRHeather T Cox1991-04-26UHC-00078-4757629369045992 Apache Blvd, Las Vegas, NV, 891430.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedSSN last four extracted+3 more
PRV-21568PRVJoshua Hill1990-06-01UHC-62851-11—1228 Central Ave, Seattle, WA, 981250.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-403787CLMMateo Myers1976-07-16UHC-90347-4363693442365802 Ridge Rd, Glendale, AZ, 853080.50Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-58617TPABryan Walker1962-11-10——385 Oak St, Miami, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-132528ENRRandy Dunn1998-10-09UHC-86655-2146265352381915 Ocean Ave # 657, Jacksonville, FL, 322430.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-119544ENRMark V Ruiz1968-09-18UHC-35056-44—3205 Church St Apt 37, Tampa, FL, 336830.50Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 105 of 2,000PreviousNext