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-560502026-01-26T19:20:03ZNathanLSmith1967-01-13UNKNOWN··•••-••-9800(657) 239-4061··nathan.smith8@hotmail.com—N/AUNKNOWN·-GRP-7993N/A
TPATPA-630252026-05-18T14:00:06ZMegan—Luna1962-09-26·nullNULL(649) 219-0680UNKNOWN5143 Hillcrest RdScottsdaleAZ85259NULL—
TPATPA-635952026-08-11T01:43:22ZSarah—Simpson3/19/1949—•••-••-3414NULL-7775 Valley View DrAUSTINTX—GRP-8448—
TPATPA-500602026-10-07T15:41:21ZAlice—Green1997-11-16——NULL-nullN/A··——GRP-8262medicare-adv-b
TPATPA-588612026-02-22T22:43:20ZlaurenFdiza1956-12-14—•••-••-4713null—6254 BAYSHORE DRIVENashvilleTN··37277UNKNOWNCORE-HMO
TPATPA-525932026-02-03T15:43:23ZJAMES—BARNES1989-12-07—•••-••-7803—JAMES.BARNES14@GMAIL.COM7584 Indian School RoadTAMPAFL33641N/A—
TPATPA-626042026-05-20T17:40:24ZLong, Priya——2004-12-02·UNKNOWN•••-••-3042—priya.long@icloud.com9302 BASELINE RDSacramentoCA95836-CHOICE-PLUS-PPO
TPATPA-511212026-08-21T16:03:58ZChapman, Grace··——1971-05-12—NULL—UNKNOWNnullUNKNOWN—-··—NULL
TPATPA-57732 2026-05-20T10:59:27ZWillie—Woods1981-12-09—-2994757233N/A9597 Main StAustinTX78752—CORE-HMO
TPATPA-553892026-03-13T06:33:23ZMELISSA—MENDEZ1974-11-24—•••-••-9633——7492 DESERT SKY BOULEVARD Apt 35AtlantaGA30345GRP-5283—
TPATPA-508372026-07-03T17:09:09Z·KYLEZPHILLIPS08/19/64N/AN/Anull—4114 Cedar LnChandlerAZnull·-NULL
TPATPA-536952026-05-18T00:08:42Zkathryn—sandoval1956-09-11null——kathryn.sandoval@hotmail.com2498 MEADOW LNFresnoCA93760GRP-6057NULL
TPATPA-628952026-10-14T22:06:14ZPAMELANSULLIVAN·1944-05-24——N/AUNKNOWN6071 Harbor Blvd··JacksonvilleFL··GRP-6832··
TPATPA-527352026-05-11T17:26:19ZWillie—Wood1968-02-12N/Anull231-906-9442willie.wood@icloud.com2996 PINE DRIVEFresnoCA93766—N/A
TPATPA-63196 2026-04-27T09:46:01ZNelson, Mark——10/06/1957null•••-••-4332UNKNOWN—·3833 Desert Sky BlvdLas VegasNV89126NULL·null
TPATPA-566122026-08-10T04:12:43ZArjun—Rojas19960822-—476-399-2693—1443 LAKE VIEW ROADSacramentoCA95853nullnull
TPATPA-557932026-01-17T10:14:11ZSimpson, KathleenZ—7/27/1999nullUNKNOWN-kathleen.simpson@aol.com9520 Central Avenue·COLUMBUSoh43244GRP-3885null
TPATPA-642662026-05-31T13:48:34ZOlivia—Richards·19540712NULL··•••-••-9396null-303 OCEAN AVETempeArizona85256-5108GRP-5924NULL
TPATPA-552542026-04-15T06:42:07ZAUSTIN—·BRYANTDec 17, 2006·null•••-••-5457294.631.6629null6850 SPRING STOrlandoFlorida32899N/Anull
TPATPA-503842026-10-03T13:34:55Zalbert—hanson3/10/1940·-•••-••-3808NULLALBERT.HANSON33@OUTLOOK.COM7146 CENTRAL AVESeattleWA98191·NULL-
TPATPA-500552026-02-23T07:00:10ZPhilip—Santos20-01-1947UHC-90436-31UNKNOWN—N/A5673 BROADWAYAustinTX··78761——
TPATPA-555682026-03-08T13:22:21ZShharon—Jordan1940-10-09--N/AN/A9743 Ridge RdJACKSONVILLEFL32207null··—
TPATPA-611482026-09-28T00:50:42Z·Madison—Russsell1985-02-24··NULL247-218-5779madison.russell@proton.me7334 MOUNTAIN VIEW DRTucsonAZ85706——
TPATPA-620262026-05-30T14:52:25ZARTHUR—RICE03/06/05nullN/A·2665327781arthur.rice76@aol.com··NULL—nullUNKNOWN·GRP-6776CHOICE-PLUS-PPO
TPATPA-516462026-08-07T05:54:12ZWalsh, Heather—····11-10-1942—•••-••-1610··HEATHER.WALSH@HOTMAIL.COM———UNKNOWN——
TPATPA-620712026-09-05T11:49:34ZJanice—Moore1982-07-13—N/AUNKNOWNNULL7643 Union StHOUSTONTX77017··N/A
TPATPA-607692026-01-30T18:54:06Zlawrence—ortiz3/25/1977UHC-54477-49N/AUNKNOWN—3355 Highland AveDALLASTX———
TPATPA-519832026-10-07T23:35:01ZTran, Timothy——1958-04-25N/A•••-••-443014657645355null5906 APACHE BLVDGlendaleAZ——NULL
TPATPA-542392026-02-22T06:46:13ZPATRICIA—PHILLIPS1963-07-20NULL•••-••-5000(856) 884-7797—3971 JEFFERSON AVELos AngelesCANULLN/ANAVIGATE-HMO
TPATPA-623372026-02-22T02:09:52Zchristian····bradley1978-08-23UHC-55052-60—9834298798—-null—NULLNULLOPTIONS-PPO
TPATPA-535892026-05-02T21:25:48ZVIRGINIA—FREEMAN2005-02-19··—N/A+1 795 248 7698-2185 MOUNTAIN VIEW DRIVE·MINNEAPOLISMN55465-null··
TPATPA-557532026-05-07T20:44:43Zkevin—·mendoza·1943-10-03-—9597701472UNKNOWN4415 LINCOLN WAYChandlerAZ85253GRP-7852CHOICE-PLUS-PPO
TPATPA-639862026-07-08T05:01:17ZALICE····SULLIVAN1994-08-01-—(543) 489-3307NULL9252 JEFFERSON AVEGilbertAZ85275-2921GRP-5105-
TPA TPA-556932026-01-12T13:45:11Z·Rachel—Diaz12/10/1999—UNKNOWN-rachel.diaz42@yahoo.com9301 HIGHLAND AVENashvilleTN37232N/A—
TPATPA-616032026-07-16T02:59:22ZChris··—Robinson1990-04-22null——CHRISTOPHER.ROBINSON@YAHOO.COM2661 Valley View DriveLOS ANGELESCA90006-N/A
TPATPA-636052026-07-24T08:44:23ZWAYNE····ROBERTSON03/04/1964N/A•••-••-4151——3463 PALM DRIVETampaFL33601GRP-1021CHOICE-PLUS-PPO
TPATPA-548912026-07-21T05:39:13ZCamila—Jones06-03-2007NULLNULL4683156308NULL4149 Bayshore DrTampaFL33633GRP-3124MEDICARE-ADV-B
TPATPA-59681 2026-08-27T19:03:27Zmary—baker6/23/1973N/A··•••-••-8504—————-GRP-0496—
TPATPA-524532026-04-04T00:24:52ZAbigail—FowlerJun 21, 1986UNKNOWNN/A··2499568755—N/AN/Anull-GRP-0971—
TPATPA-617972026-04-13T11:55:06ZJacob—Stone1974-08-15-•••-••-6776NULL··NULL3481 River RdAtlantaGA30379—CHOICE-PLUS-PPO
TPATPA-631642026-08-02T18:47:00ZBRENDA—BENNETT1963-03-11-—N/A··—6951 SUNSET BOULEVARD Apt 31San Diego·CA92121-—
TPATPA-625202026-08-25T00:29:54ZFrances—Berry·1968-02-08NULL····2047033326FRANCES.BERRY@GMAIL.COM7190 PINE DRIVEMinneapolisMN55466—·MEDICARE-ADV-B
TPATPA-548422026-04-09T16:26:58ZAliceJVasquez04/17/2002NULL•••-••-3427—··—N/A—NULL—N/A
TPA TPA-551382026-09-22T18:53:54ZCATHERINE—HARVEYJul 11, 1960UNKNOWN—UNKNOWN—5638 Indian School RdOrlandoFL32831——
TPATPA-513762026-08-27T22:14:13ZKnight, Anthony——1973-06-22—•••-••-5360UNKNOWN—null-NULL——UNKNOWN
TPATPA-580152026-03-21T13:22:38ZMaria—Webb1943-09-01null—····-8356 Maple AvenueMIAMIFL33120-6675GRP-4300N/A··
TPATPA-632762026-03-02T04:24:10ZKennethTArmstrong15-03-1990UHC-29583-62·-+1 513 893 1585——-—N/A—N/A
TPATPA-543112026-09-24T09:07:23ZRuth—Owens1988-01-27··UHC-38282-21—12465225709··UNKNOWN8039 WASHINGTON STHoustonTexas77015-0406nullOPTIONS-PPO
TPATPA-569662026-07-03T01:17:30ZBetty—Hart1993-04-17—•••-••-8914N/ANULL4852 Union StreetCharlotteNC28229NULLNULL
TPATPA-644552026-08-04T20:47:43ZDeboarh—Rose1955-02-05UHC-30731-01NULLNULL-9124 Baseline RoadSan DiegoCA92136nullnull
14,474 rows, page 264 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:43:03.399Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty