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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-28209PRVRaymond Reed1997-07-04—3816512027—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-25089PRVJanet Vasquez1945-02-20UHC-06138-796722671938650 Bayshore Dr, San Diego, CA, 921070.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22119PRVJoice Garrett2008-12-28UHC-90365-28—7709 Grand Ave, Eden Prairie, MN, 553630.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-24104PRVWalter Flores1966-11-05—46047724494809 Bayshore Dr, Austin, TX, 787780.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-22259PRVTyler Ellis1964-06-11UHC-57220-4483166872619799 Maple Ave, Las Vegas, NV, 891400.68Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased
PRV-28924PRVAmanda N Collins1995-12-18UHC-44091-183985287707503 Meadow Ln, Las Vegas, NV, 891960.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-25607PRVDorothy Garrett1941-08-11UHC-53784-33—6322 Ridge Rd, Scottsdale, AZ0.68Two-digit birth yearZIP missingEmail lower-casedPlaceholder values cleared
PRV-21878PRVJerry Kelley1965-11-04—26393410756586 Park Pl # 675, Scottsdale, AZ, 852200.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-22247PRVJoe G Turner1997-09-21UHC-65327-3961176243903679 Lincoln Way Apt 34, Denver, CO, 802270.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25015PRVNatalie O Shaw1966-08-15UHC-04451-662396014239491 Palm Dr, Sacramento, CA, 958190.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-26014PRVSarah K Adams2006-06-09UHC-57106-3033437017152699 Canyon Rd, Fresno, CA, 937840.68Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
PRV-25894PRVKelly Vasquez1994-11-02——2110 Church St, Mesa, AZ, 852740.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-26697PRVBilly Jones1989-12-24——3396 Sunset Blvd, Fresno, CA, 937410.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26620PRVDanny Black2005-02-09——4370 Spring St # 768, Phoenix, AZ, 850780.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26533PRVDiego Hill2001-12-20——6895 Willow Ct, Nashville, TN, 372010.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-25532PRVBrandon J White1984-09-10—57954819818193 Cedar Ln, Gilbert, AZ, 852170.68Street suffix standardisedAddress re-casedEmail lower-casedGender normalised
PRV-20200PRVShirley A Woods1959-10-18UHC-25499-0565926218739434 Washington St, Eden Prairie, MN, 553790.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27182PRVValentina King1989-03-28——8497 Palm Dr, Orlando, FL, 328820.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
PRV-23601PRVMariana Peters2002-11-02—60022269525763 Bayshore Dr, Los Angeles, CA, 900740.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23388PRVRaymond Patterson1938-09-28UHC-88717-5422279954348662 Sage Ct # 505, Chandler, AZ, 852510.68Two-digit birth yearPhone reformattedUnit split from streetPlaceholder values cleared
PRV-20785PRVKayla Wells1985-07-02—269951460216 Forest Ave, Glendale, AZ, 853620.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-28330PRVJeremy Mason1962-12-28—81539815704853 Apache Blvd, Jacksonville, FL, 322530.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-29552PRVWei Mason1982-09-01—55043737019839 Palm Dr # 990, Seattle, WA, 981030.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
PRV-27864PRVCarl Ray1963-08-05——1930 Harbor Blvd, Mesa, AZ, 852080.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26738PRVChris Contreras2008-08-03UHC-67401-8144533929765571 Meadow Ln Apt 40, Orlando, FL, 328490.68Two-digit birth yearPhone reformattedUnit split from streetPlaceholder values cleared
PRV-23605PRVKyle Hall1971-12-28—49871648663425 River Rd, Eden Prairie, MN, 553960.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28012PRVChristine Valdez1960-02-08UHC-95611-798623587484—0.68Name re-casedSSN last four extractedGender normalisedPlaceholder values cleared
PRV-27557PRVLarry Scott1959-05-02——1815 Lincoln Way, Nashville, TN, 372570.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-20147PRVArthur Wright1943-12-18UHC-32304-69—7348 Baseline Rd, Las Vegas, NV, 891120.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-24586PRVJoyce Moreno1990-12-20UHC-51099-94—4316 Park Pl, Orlando, FL0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
PRV-27119PRVRandy Maldonado1963-10-24UHC-17028-4255076642658563 Apache Blvd Apt 11, Glendale, AZ0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
PRV-29366PRVBrittany D Shaw——50761705626327 Ridge Rd, Denver, CO, 802990.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22856PRVKimberly Hernandez1979-10-17—72880668341697 Desert Sky Blvd, Chandler, AZ, 852540.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
PRV-21479PRVMarilyn W Romero1954-08-02—55590005692973 Main St, Eden Prairie, MN, 553380.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26815PRVDennis Phillips1996-12-07—7066237718725 Grand Ave, Orlando, FL, 328220.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22568PRVJanice Burton1955-04-03UHC-20074-87—5988 Baseline Rd, Seattle, WA, 981790.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-24329PRVNicole Rogers1957-02-15UHC-41707-94——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
PRV-25095PRVCarlos Torres1970-09-14———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
PRV-29063PRVSandra Cunningham1962-04-13——2627 Jefferson Ave, Los Angeles, CA0.70ZIP missingGender normalisedPlaceholder values cleared
PRV-28099PRVLogan Brooks1952-04-19—26030032663578 Forest Ave, Eden Prairie, MN0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
PRV-21153PRVRyan Jimenez1955-06-10——2708 Forest Ave, Denver, CO, 802940.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-29534PRVJordan Rivera1972-02-16UHC-42809-7321189801109207 Park Pl, Fresno, CA, 937520.70Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-20861PRVNicholas Roberts1977-11-15UHC-36764-9437239466365876 Pine Dr, San Diego, CA0.70State name converted to codeZIP missingPlaceholder values cleared
PRV-23696PRVRobert Simmons1947-10-08UHC-52762-2550829139181818 Maple Ave, San Diego, CA, 921570.70Street suffix standardisedAddress re-casedGender normalised
PRV-28030PRVKim A Baker1987-10-13UHC-95208-7248277144256304 Camelback Rd, Seattle, WA0.70State name converted to codeZIP missingPlaceholder values cleared
PRV-20765PRVAnthony J Hoffman1977-01-02——5486 Highland Ave, Atlanta, GA0.70Phone missing area codeZIP missingPlaceholder values cleared
PRV-25712PRVDoris Diaz1945-12-07UHC-46853-05——0.70Phone missing area codeGender normalisedPlaceholder values cleared
PRV-22810PRVShirley P Aguilar2000-10-16UHC-87167-45——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
PRV-28487PRVVJunk2008-07-06UHC-92465-7651844848027467 Bayshore Dr # 804, Dallas, TX, 752920.70Unit split from streetPlaceholder values clearedNo usable name (quarantined)
PRV-28316PRVYuki Willis1985-12-25UHC-15526-7129885133485308 Meadow Ln, Miami, FL, 331770.70Street suffix standardisedAddress re-casedGender normalised
9,596 rows, page 75 of 192PreviousNext