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-591852026-02-08T13:43:49ZDennis—Rivera06/18/96—·-—UNKNOWN—NULLUNKNOWNnullN/A··—
TPATPA-534892026-01-30T04:37:55Z Donald—Aguilar7/15/1950UHC-95936-49—·N/AUNKNOWN3963 Mesa DrAustinTX78726nullNULL
TPATPA-527222026-09-22T15:24:17Z jacob—kimNov 28, 1988··•••-••-323516176643822N/A—N/ANULL—null—
TPATPA-590322026-09-03T05:47:48ZArthur—Perez1980-07-06-•••-••-785812362504700N/AN/A—NULL·-—N/A
TPATPA-606292026-09-20T00:01:07ZWalker, Sofia——1997-10-01·N/A—-—3784 Oak StreetMesaAZ85277GRP-9026—
TPATPA-610222026-05-07T05:23:50ZClark, BrandonV—1990-07-05-NULLnullN/A2821 APACHE BOULEVARD·PLANOTX75002—N/A
TPATPA-617732026-03-25T05:59:44ZSANDRA—MARTIN26-11-2003—N/ANULLnull5929 Indian School RoadCOLUMBUSOH··43227UNKNOWNCORE-HMO
TPATPA-578822026-08-30T03:38:20ZHicks, Sean··N.—1971-01-22null———7299 BASELINE RDAtlantaGA30397—UNKNOWN
TPATPA-595652026-01-17T06:01:55ZWalsh, Brian——10/27/38-•••-••-2448(509) 896-0375brian.walsh23@proton.me8446 CENTRAL AVENUEEden PrairieMN55365NULLN/A
TPATPA-615422026-03-14T12:20:05ZGEORGE··DANIELS·1951-09-11NULL·N/A+1 602 943 8891··george.daniels@yahoo.com8278 Central Avenue Apt 26Las VegasNV89187GRP-9588CORE-HMO
TPATPA-590002026-10-05T00:22:37ZWelch, Logan——07/17/1980N/ANULL(484) 505-2970-·585 Washington StreetMesaAZ85208GRP-1311OPTIONS-PPO
TPATPA-531792026-10-08T06:09:28Zsusan—·estrada5/10/1958UNKNOWN——susan.estrada@yahoo.com4482 Union St··TempeAZ85200UNKNOWNCHOICE-PLUS-PPO
TPATPA-632952026-02-07T01:24:35ZBowman, Jennifer——1995-06-08—•••-••-5904N/AN/A9289 Canyon RdMesa··AZ85244GRP-1845null
TPATPA-576712026-05-15T20:59:14ZRebecca—Kelley1982-09-13—•••-••-9187UNKNOWN—3860 Camelback RdOrlandoFL32813—NAVIGATE-HMO
TPATPA-553912026-02-07T13:04:14ZJulie··Lewis1963-03-22UHC-04157-39UNKNOWN286-288-0696julie.lewis@icloud.com161 Bayshore DrMesaAZ85267UNKNOWN-
TPATPA-514292026-05-05T13:21:41Zarthur—halll9138-11-24—N/AUNKNOWNUNKNOWN686 Church StreetGlendaleAZ85360GRP-8109OPTIONS-PPO
TPATPA-566852026-03-16T18:11:00Z·Kathryn—Price1987-02-12UNKNOWNnull(873) 698-1814—5333 Lincoln WayPlanoTexas75049··CHOICE-PLUS-PPO
TPATPA-573942026-06-19T20:33:17ZSARAH—CHAPMAN1961-08-23NULLNULL5957811650SARAH.CHAPMAN@PROTON.ME263 Ridge RoadAustinTX··78779N/ACHOICE-PLUS-PPO
TPATPA-54682 2026-08-09T01:53:49Z·carlos—thompson2002-01-26——-UNKNOWN7115 Apache Boulevard Apt 38·TAMPAFlorida33652—OPTIONS-PPO
TPATPA-625422026-04-05T23:56:23ZArthur—Rivera1966-04-15—null——8948 Apache BoulevardHOUSTONTX77054-6874··—N/A
TPATPA-54559 2026-03-19T23:42:40ZDiana—OBrien1971-09-07UHC-82105-09NULL19458802963diana.obrien63@hotmail.com5504 Indian School RoadFRESNOCA93792—SELECT-EPO
TPATPA-543372026-03-15T06:36:43ZGardner, Evelyn——1981-08-14UNKNOWN•••-••-9829—evelyn.gardner@gmail.com7508 HIGHLAND AVELos AngelesCA90020GRP-6084-
TPATPA-572042026-08-26T16:43:24ZJEAN—ORTEGA20000725—·null-—9182 INDIAN SCHOOL RDDallasTX75246NULL—
TPATPA-644272026-02-16T19:08:38ZRchel··—Adams···1939-03-26-—(670) 587-9506rachel.adams@icloud.com5892 OAK STREETTUCSONAZ85724N/A—
TPA TPA-574102026-02-15T07:08:39ZNancy—Contreras1988-02-04NULL——-8194 Jefferson AvenueDenverCO80264GRP-7906NULL
TPATPA-538632026-03-20T17:27:14ZDenise—Parker1947-11-17—•••-••-2383nulldenise.parker56@gmail.comN/A-UNKNOWN——SELECT-EPO
TPATPA-626282026-08-06T16:17:33ZmarianaKhanry1946-02-44NULL•••-••-1610N/Amariana.henry@hotmail.com··—-NULLNULL—SELECT-EPO
TPATPA-624562026-07-11T09:27:15Z·Bily—Woods12/28/2008UHC-41784-21null··NULL··—9638 Sage CtAtlantaGA30338GRP-3851NULL
TPA TPA-554792026-07-30T00:25:08ZWright, Ahmed——1972-11-22UHC-78812-39——·-617 Camelback RoadChandlerAZ85214GRP-6175UNKNOWN
TPATPA-562582026-02-06T13:04:49ZAlice—Walsh1996-07-06NULL-8233860657—7143 Elm StAtlantaGeorgia30389—NAVIGATE-HMO
TPATPA-540392026-02-23T05:53:15ZMadison—Graham1967-03-23--NULL—4121 JEFFERSON AVEAtlantaGA·30325—NULL
TPATPA-588032026-04-14T02:16:23ZJudy—Ward1978-11-04UNKNOWN•••-••-3618UNKNOWN-931 SUNSET BOULEVARDSAN ANTONIOTX78219—··
TPATPA-511762026-05-14T16:34:25ZCHRISTOPHER—FOX1950-04-28NULLNULL—null3691 HILLCREST RDATLANTAGANULLGRP-4425—
TPA TPA-548092026-08-20T14:27:13ZGerald—Robertson1950-10-09·null•••-••-3288·7873326872nullNULL—nullnullGRP-8108medicare-adv-b
TPATPA-619202026-05-13T11:10:12ZPeter—Tucker1978-02-05UNKNOWNNULL··UNKNOWNpeter.tucker@outlook.com5174 Hillcrest Rd··HoustonTexas77035-—
TPATPA-54140 2026-01-25T03:21:19ZDONALD—JAMAS1972-11-14-•••-••-9415UNKNOWN·donald.james@aol.com5823 Harbor BoulevardAustinTX78769-·-
TPATPA-634002026-09-07T23:45:13ZJean—Campbell1989-03-24null——NULL···8068 Apache BlvdLas Vegas·NV89164——
TPATPA-512832026-08-29T16:14:02ZCarol—Snyder06/27/1966-UNKNOWN——NULL———N/ACORE-HMO
TPATPA-613542026-02-27T13:29:50ZWillie—Richardson1974-11-11-•••-••-9060——1339 Cedar LaneAustinTX78703N/A-
TPATPA-582022026-09-04T04:54:10ZSophia—Roberts1942-06-05UHC-04642-04•••-••-6874UNKNOWN—3413 Valley View DriveAustinTX78720-0272GRP-9128·N/A
TPATPA-604222026-08-06T21:16:01ZSANTIAGO····PRICE09-05-1978UHC9826618··•••-••-9557263-298-3584N/A8949 Mesa Drive Apt 27Houstontx·77059UNKNOWN—
TPATPA-607172026-05-25T13:16:42ZRalph—Santiago·11-01-1964NULL—2875128451UNKNOWNNULL··———null—
TPA TPA-593472026-06-14T13:34:37ZAlvarez, Steve——2007-02-25··-···UNKNOWN(779) 976-0516—6594 Spring StreetSan AntonioTXUNKNOWN··GRP-1190—
TPATPA-545582026-01-19T19:04:33ZSophia··U.Jeknins1964-12-06—•••-••-4378922-398-1116N/A·1597 Bayshore DriveMiamiFL33141-4673GRP-0964SELECT-EPO
TPA TPA-515332026-04-02T21:32:44ZWang, Joseph——1976-04-25-··•••-••-2856UNKNOWNJOSEPH.WANG@GMAIL.COM—N/AN/A—NULLNAVIGATE-HMO
TPATPA-558852026-09-27T09:20:45ZLauren—GrantOct 28, 2004——(850) 287-7272N/A7880 Ridge RdMiamiFL33125GRP-6717null
TPATPA-518492026-05-12T03:06:11ZMaria··DEstrada1977-08-07—NULL-—4706 INDIAN SCHOOL RDJacksonvilleFL32292——
TPATPA-588902026-02-17T11:38:40ZWei—Miller1949-03-27NULL•••-••-8601+1 697 777 0510—967 Canyon RoadTempeAZ85223··-NULL
TPATPA-590552026-03-31T00:58:17ZMarcusP··Sims·04/04/01—NULL·19367211415····9274 CANYON RDMiami··FL33180null··UNKNOWN
TPATPA-607742026-05-15T17:24:58ZCHARLES—REYNOLDS19610926··NULL•••-••-2370+1 297 557 4630charles.reynolds@aol.comNULLUNKNOWNnullNULL—null
14,474 rows, page 182 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.114Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty