Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-635162026-08-12T22:15:47ZTRICIA—DUNN··1939-09-19NULLUNKNOWN4929915295·UNKNOWN9685 Camelback Rd Apt 30MiamiFL33169-N/A
TPATPA-578952026-07-24T00:25:12ZDiane—Contreras1963-08-17——N/A—7134 SAGE CTFresnoCA·93704·UNKNOWN-
TPATPA-588412026-06-12T22:53:10ZVirginia—Wilson1999-05-18null——··7763 OAK STREET #196··San AntonioTX78268——
TPATPA-631382026-09-15T10:30:57ZBilylZWells1947-09-03UHC-28507-55•••-••-2174—BILLY.WELLS41@PROTON.ME6266 Maple AvenueMinneapolisMN55440GRP-0874null
TPATPA-583022026-05-11T09:35:42ZCAMILA—TRAN1958-03-13UHC-16446-89UNKNOWNUNKNOWN-1343 FOREST AVENUE #446PhoenixAZ85032—MEDICARE-ADV-A
TPATPA-641432026-01-21T14:21:52Z Timothy——·2007-01-02-——timothy.delgado@proton.meUNKNOWNNULLnullNULL——
TPATPA-558742026-05-26T22:25:14ZMarcus—Whte02/10/1984uhc-00927-15NULL(855) 830-3111—3172 Main StreetScottsdaleAZ85299——
TPATPA-529452026-07-05T12:03:47Z LAURA··—MURRAY5/2/1945N/A·null332-406-7182·laura.murray87@hotmail.com———N/AUNKNOWNCHOICE-PLUS-PPO
TPATPA-598612026-08-18T12:04:00ZSHIRLEY··—BAKER19840513UNKNOWN··—NULL-NULL··NULLUNKNOWN-··UNKNOWN
TPATPA-58084 2026-09-29T06:13:50ZMorgan, Logan——1975-11-03UNKNOWN—N/A—5987 Ocean AveGlendaleaz··85359NULLUNKNOWN
TPATPA-635942026-08-19T18:11:49ZChen, Teresa··—11/11/43UNKNOWNNULL5833252714NULL2986 Apache BoulevardHoustonTX77059—UNKNOWN
TPATPA-534872026-09-07T14:38:34Zrichard—allen1992-07-27UNKNOWN-7974152000null3888 Mountain View DriveScottsdale·AZ85265—core-hmo
TPATPA-570182026-05-28T17:31:32ZRuth—Flores2008-03-05UNKNOWN-NULL····2065 Elm StColumbusoh—UNKNOWNnull
TPATPA-638452026-01-24T17:26:23Z CHRISTINE—·ROBINSON1972-06-05UHC-30697-65•••-••-1613UNKNOWNN/A9172 Meadow LnLas VegasNV89111GRP-3877NULL
TPATPA-644172026-03-14T00:38:01ZPhillips, Wei··—1941-03-09NULL•••-••-5253NULL-4341 BROADWAYEden Prairie··MN—nullnull
TPATPA-564742026-08-08T21:18:39ZDunn, Wei——05/02/46-•••-••-0386—NULL6309 Lincoln Way #257PlanoTX75041GRP-2134null··
TPATPA-637292026-01-04T14:14:55ZSharon—Lewis1982-06-20—UNKNOWN(903) 526-6511UNKNOWN7383 CENTRAL AVEHoustonTX77018NULL—
TPATPA-607812026-03-13T23:14:13ZDEBORAH—GRANT14-10-1942UHC-98028-76——null····-—NULLNULL-
TPATPA-615852026-04-25T00:31:23ZHEATHER—RIOS1690-07-24UHC-67463-23NULL6472954779HEATHER.RIOS@YAHOO.COM6475 Desert Sky Boulevard #668SacramentoCA95827GRP-0771UNKNOWN
TPATPA-556792026-06-22T07:57:12ZISABELLA—ROSE12/19/52—•••-••-2708N/Aisabella.rose6@outlook.com7391 Church StJacksonvilleFL32272—NAVIGATE-HMO
TPATPA-523892026-03-18T16:41:53ZRYAN—CARROLL1964-06-12··-NULL—N/A——·UNKNOWN—nullMEDICARE-ADV-B
TPATPA-585212026-09-08T15:31:04ZSara—Gibson1955-12-02UNKNOWN—+1 959 294 3473sara.gibson@hotmail.com7592 INDIAN SCHOOL RDDallasTX75282GRP-9158MEDICARE-ADV-B
TPATPA-512512026-03-21T15:01:10ZDylan—Ferguson6/26/1993UHC3474774N/AN/AUNKNOWN··9126 Maple AvenueTempeAZ85200-1915UNKNOWNNAVIGATE-HMO
TPATPA-549632026-09-07T09:52:17ZCheryl··Payne1956-03-15UNKNOWN•••-••-7169UNKNOWNcheryl.payne@gmail.com7084 Apache BlvdScottsdaleAZ85289GRP-3413—
TPATPA-625702026-06-18T19:35:03ZGeorge—Munoz1969-01-10null•••-••-5496-—918 SUNSET BLVDSAN DIEGO··CA92170-2058N/ANAVIGATE-HMO
TPATPA-634682026-02-20T14:36:03Zevelyn—hudson06/07/1989UHC-95299-09··null·-UNKNOWN1021 Grand AvePlanoTX75034··—UNKNOWN
TPATPA-501242026-03-05T17:17:38ZVALENTINA—AUSTIN·11/05/1980—NULL—N/A6663 HIGHLAND AVENUEGILBERTAZ85292UNKNOWNNULL
TPATPA-549712026-02-16T03:52:24ZDanielle—Fernandez··19750403N/AUNKNOWNN/A-46 Meadow LaneEDEN PRAIRIEMN··N/A—
TPATPA-60033 2026-03-27T03:39:21Zkathleen—alvarado9/4/2006UNKNOWN····9107986533—1905 Sage CtColumbusOH43226null—
TPATPA-535492026-02-22T23:14:25ZAISHA—MYERS1995-02-19null•••-••-9814(443) 421-2130aisha.myers55@aol.com··5623 Sage Ct··FresnoCA93744UNKNOWN—
TPATPA-540462026-05-07T15:58:32ZRussell—Johnson07/17/1965NULLNULL··14803964351russell.johnson34@gmail.com7387 Oak StLos AngelesCA90052········
TPATPA-551672026-07-02T06:41:02ZAMY····WONG10/13/62—UNKNOWN——336 Market StChandlerAZ85254NULLCHOICE-PLUS-PPO
TPATPA-531262026-09-12T11:00:57ZHannah—Rose16-11-1969—•••-••-0556(246) 535-5809UNKNOWN3727 Sunset BoulevardDenverCO80280-4941—UNKNOWN
TPATPA-605872026-07-25T05:21:06ZLAURAQJORDAN1961-07-06UHC-59863-10NULL—laura.jordan92@icloud.com··7326 Elm StreetPhoenixAZ85020-5206··——
TPATPA-521182026-03-18T08:09:31Zcaarolyn—lane12/27/1965N/A•••-••-9315—UNKNOWN9646 Mesa DrSacramentoCA—····—
TPATPA-603852026-04-14T14:48:41ZAARON····ROJAS3/27/1938NULL—·UNKNOWNnull7749 Mesa DriveGilbertArizonaUNKNOWN-··NAVIGATE-HMO
TPATPA-567242026-08-15T09:22:53ZHannah—Carr1943-07-10UNKNOWN—··hannah.carr@hotmail.com8041 Cedar LaneSACRAMENTOCalifornia—GRP-1996OPTIONS-PPO
TPATPA-53602 2026-09-09T09:25:44ZMADISN—LOPEZ1970-08-17-null(481) 310-2984UNKNOWN-——nullGRP-3135UNKNOWN
TPATPA-557552026-07-30T18:27:03Zcynthia—mejia1957-06-17··———null8021 Spring StAustinTX——-
TPATPA-620382026-03-12T15:37:43ZJoshua—Rose09/22/61—•••-••-3434-joshua.rose@icloud.com7769 Ridge RdMinneapolis·MN55456—N/A
TPATPA-590882026-09-03T22:54:42ZOwens, Sandra··W—1972-03-03null•••-••-0203(488) 527-8152sandra.owens79@hotmail.com7000 Harbor BoulevardChandleraz85271—UNKNOWN··
TPATPA-550172026-07-26T08:13:56ZBeverly—Schultz07/15/80-•••-••-7651—BEVERLY.SCHULTZ@HOTMAIL.COMUNKNOWN——NULLNULLUNKNOWN
TPATPA-500982026-04-23T05:54:28ZDeboarh—·Murry·04/24/2003—N/A—deborah.murray@proton.meNULLnullNULL··GRP-0251NULL
TPATPA-511632026-07-03T19:36:28ZCARL—GEORGE1959-08-09UNKNOWN····-carl.george@icloud.com2222 OAK STTucsonAZ85739-0601GRP-6024—
TPATPA-514002026-03-26T00:06:35ZDuncen—Valentina12/22/74—•••-••-2677284.917.3760UNKNOWN5898 Sunset BoulevardSan AntonioTX78219——
TPATPA-537092026-09-11T02:01:12Zcarol—myers···1977-12-17UHC1182796null(499) 889-5708··N/A6335 Church StreetSeattleWashington98126GRP-1387-
TPATPA-626432026-09-18T11:09:40Z Nancy·GHarvey3/19/1994····UNKNOWN243-732-2928null4513 PALM DRSan DiegoCalifornia·92169—CHOICE-PLUS-PPO
TPATPA-554512026-03-11T08:39:51ZSTEVN—MASON·1965-11-06—UNKNOWN··—steven.mason@aol.com6665 Pine DriveMiamiFL33184N/A—
TPATPA-591012026-06-02T01:11:07ZLaura—·Little2001-07-05—····(832) 477-1227NULL5519 WILLOW COURT Apt 33Chandler·AZ85219-CHOICE-PLUS-PPO
TPATPA-633932026-01-12T20:06:09ZAnn—Williamson··1963-02-12—nullnullNULL567 Meadow LaneAtlantaGA30322UNKNOWNNULL
14,474 rows, page 184 of 290PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:53.122Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty