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-540402026-04-05T00:39:34ZMark—Davis·06/10/62null•••-••-6289+1 586 223 3028N/A··1403 Pine DriveMesa·AZ85248-OPTIONS-PPO
TPATPA-637062026-10-07T19:19:44Z Dunn, Madison····—2008-10-06UNKNOWNN/A878-822-8483—1892 Market StSeattleWA98184··——
TPATPA-557082026-01-27T05:55:03ZLUCIA—CLARK1974-07-01·-NULLnull—8782 Highland AvenueCHARLOTTENC·28288GRP-4903—
TPATPA-572862026-05-10T21:09:57ZAhmedQBlack11/24/1995—null—ahmed.black@proton.me4516 Indian School RdFresnoCA93720GRP-0439UNKNOWN
TPATPA-614192026-10-09T04:15:54ZBetty—Bennett1983-07-08—N/A·(778) 503-9119betty.bennett@outlook.com5946 Forest AvenueTEMPEAZ85205GRP-7488-
TPATPA-598672026-04-16T23:12:11ZLawrence, Danielle——1983-10-12N/A-(769) 866-3216-9652 Mesa Dr··HOUSTONTX77069··NULL—
TPATPA-620252026-08-11T07:41:46Z·Andrew—Carroll19420421UNKNOWN•••-••-3421NULL-8282 BASELINE RDTEMPEAZ85254null—
TPATPA-513832026-08-15T18:05:02ZVINCENT—BROOKS11/9/1946NULL•••-••-9493—NULL1195 RIDGE RDEden PrairieMN55300-3388--
TPATPA-596392026-05-24T14:25:41ZDENNY—GARDNER10-04-1974null——UNKNOWN2179 BROADWAYColumbusOH43279-N/A
TPA TPA-638762026-07-10T08:40:43Zpeter—·roberts2008-09-12··nullNULL····NULL1031 Grand AvenuePlanoTX75042GRP-8244N/A
TPA TPA-530602026-02-16T02:45:11ZAustin··—FloresMar 14, 1945—UNKNOWNUNKNOWNaustin.flores45@outlook.comUNKNOWNnull—UNKNOWN—N/A
TPATPA-558752026-07-13T15:30:38ZAisha—Walker1991-12-23null•••-••-4161575-392-4222-9366 Union StColumbusOH43292-9870··GRP-8731—
TPATPA-555462026-08-11T19:02:32ZChristopher—Chavez04/25/44—•••-••-4129null-5415 Forest AvenueLos AngelesCA90043·GRP-5182null
TPATPA-632632026-01-21T19:29:50ZChristine—Marquez1941-01-03nullnull—··5341 MEADOW LNTampaFL33627-7881··GRP-3623·NULL
TPATPA-622382026-03-21T08:34:32ZPETERYWEST1975-01-06UHC-81086-81N/AN/A—9360 ELM STLos Angelesca90076—NULL
TPATPA-527042026-09-05T22:38:49ZCatherine··ETaylor1965-12-12—N/A8284089875N/A7245 Hillcrest RdChandlerAZ85253GRP-5964navigate-hmo
TPATPA-636142026-05-20T05:02:51ZRyan—Martinez·1951-06-25null-UNKNOWN—7459 MAIN STGilbertAZ—nullMEDICARE-ADV-B
TPATPA-631772026-08-31T21:19:30ZLisa—Stevens··19860928——+1 647 637 8828··8250 Highland Ave Apt 24ChandlerAZ85205-N/A
TPATPA-524692026-03-24T13:59:12Z Gregory—Larson1963-11-18null··•••-••-9760(957) 377-8373null2970 SUNSET BLVDGilbertAZ85293——
TPATPA-605952026-01-09T00:13:32ZCARLUBENNETT1968-11-07—UNKNOWNUNKNOWNnull··9430 SAGE CTSan AntonioTX78267UNKNOWN—
TPATPA-640232026-08-08T04:32:00ZColeman, Marcus——1994-10-28N/A—3907759461··—304 Pine DrPlanoTX75045-—
TPATPA-502792026-06-06T23:41:44ZEmma—Rogers2001-11-18—•••-••-3030NULLUNKNOWN6134 Lincoln WayPhoenixAZ85048-UNKNOWN
TPATPA-531362026-01-29T18:11:04ZJose—Kim20000408··NULL··-N/A-7840 RIVER RDEden PrairieMinnesota55338-N/A
TPATPA-627932026-08-30T12:23:28ZPriya··Rios··1918-02-14··——NULLPRIYA.RIOS@GMAIL.COM610 Desert Sky Boulevard·Eden PrairieMN55387—MEDICARE-ADV-A
TPATPA-625062026-01-09T14:57:17Z Ashley—Jimenez1971-12-23··NULL•••-••-1075958-495-3788ashley.jimenez2@icloud.com—UNKNOWNN/ANULL—CHOICE-PLUS-PPO
TPATPA-637722026-05-23T09:32:17ZLIZDMYERS1981-12-18N/Anull—elizabeth.myers98@outlook.com·9332 Ridge RoadDallas···TX75292GRP-2558—
TPATPA-605742026-01-21T00:54:09ZSteven—Carter1995-08-08null····(238) 726-4090—3793 Bayshore DriveSAN ANTONIOTX78250nullnull
TPATPA-603032026-05-26T11:50:27ZNicole—Arnold··19790510—•••-••-37445623336184—3165 Mesa DriveChandler·AZ85231—·null
TPATPA-554602026-06-12T13:57:21ZBRANDON—MUNOZ··08/13/1954——N/Anull7696 Highland AveTEMPEAZ85265GRP-3223—
TPATPA-520252026-06-21T15:42:47ZBILLY··—TUCKER··1987-12-20null··—NULLNULL1246 Hillcrest RoadTampaFL33679N/A····
TPATPA-590612026-09-28T02:25:36ZNichols, Aisha——14-07-1996NULL•••-••-1318—null9422 Baseline RoadOrlandoFL32826-0596NULLN/A
TPATPA-644002026-06-03T12:31:35ZCHRIS—PORTER1972-09-25---—3330 Washington StreetTempeAZ85222-4736UNKNOWN··N/A
TPATPA-51279 2026-08-23T08:28:33ZSTEPHANIE—ROBERTSON··1980-01-10—null18045810159NULLNULLN/A·-NULLnullN/A
TPATPA-584612026-04-16T02:09:44ZMICHELLE—MASON1990-12-28—•••-••-4066——4639 Forest AvenueSeattle·WA98194··GRP-8170····
TPATPA-590972026-09-27T21:32:39Zchristopher··lucas19460107null-7858852136······NULL—NULL—UNKNOWN··UNKNOWN
TPATPA-532362026-07-02T21:19:30Zbrian—vazquez16-07-1970N/A··null364-661-5998NULL4314 WASHINGTON STREET··SacramentoCA95831GRP-8130—
TPATPA-565432026-06-19T23:22:16ZGonzalez, Debbie——19451114NULL--—3485 Desert Sky Blvd Apt 21SEATTLEWA98153GRP-9960UNKNOWN
TPATPA-598552026-06-29T03:31:56ZWAYNE—THMAS·02/10/54UHC-60306-66··•••-••-1255UNKNOWNN/A4016 JEFFERSON AVENUESeattleWashington·98168GRP-2398-
TPATPA-519462026-05-17T22:50:49Z·DAN—CARROLL09/22/08N/AN/A·NULLdaniel.carroll@proton.me4534 Highland AveCharlotteNC28286—UNKNOWN
TPA TPA-523552026-07-26T04:28:02ZSean—Collins6/27/1995UHC-91688-56•••-••-5792-—3968 Elm StChandlerAZ85206-8091——
TPATPA-542622026-03-18T20:24:35ZJERRY—NELSON2005-05-26UHC-34021-91—NULLjerry.nelson40@gmail.com4180 Apache BoulevardCharlotteNC28250NULLnull
TPATPA-531192026-08-23T10:18:32ZRachel—Jacobs··1987-04-14UHC-12610-08-——2993 UNION STREET·SAN ANTONIO·TX78219·GRP-4742·OPTIONS-PPO
TPATPA-630982026-05-27T06:23:13ZDelgado, Amber——1972-11-06N/A•••-••-1666N/Aamber.delgado72@aol.com1854 Union StreetSeattleWA98150GRP-0451MEDICARE-ADV-B
TPATPA-605922026-04-07T08:29:52ZBRIAN—LUNAFeb 17, 2000··-N/ANULLbrian.luna81@aol.com2217 Indian School RdMinneapolisMN55411N/AUNKNOWN
TPATPA-621432026-05-27T17:31:53ZKimberly··—Robertson11/18/1940··nullUNKNOWNUNKNOWN9549 Apache BoulevardTempeAZ85296····-
TPATPA-531752026-01-26T08:27:14Z Frank—Snchez1941-11-17UHC-19954-35——N/A2748 Sage CtSeattle·WAN/Anull····
TPATPA-569472026-04-20T16:09:49ZcamilaA··marshall1956-12-09nullNULL13347020523—6341 Baseline Rd·PhoenixAZ·85066N/Anull
TPATPA-576372026-03-18T07:41:36ZDEBRAC.MATTHEWS1973-10-28—•••-••-2520357-945-9511··debra.matthews@yahoo.com3697 LAKE VIEW ROADChandlerAZ85267····UNKNOWN
TPATPA-606072026-02-21T09:49:39ZBETTY—·MURPHY1985-11-02-··NULL9497643betty.murphy17@yahoo.com198 Bayshore DriveLas VegasNV89134··-··-
TPATPA-636612026-05-26T18:15:33ZMEGAN—VARGAS20010127NULLNULL—-7543 GRAND AVESAN ANTONIOTX78266——
14,474 rows, page 14 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:34.801Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty