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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4026542026-02-07T04:36:50ZAMY—MURRAYMar 15, 1952UHC-24519-12•••-••-1959·4239153null5657 Central AvenueSan DiegoCA92144GRP-0270UNKNOWN
PRVPRV-256432026-09-06T06:36:07ZLauren—Chen2003-04-01UHC-04060-90•••-••-5249709-951-8613lauren.chen58@gmail.com8160 INDIAN SCHOOL RD·AustinTX78773—-
CLMCLM-4073972026-05-21T10:36:57ZArthur····Lucas1954-04-24UHC-21109-17NULL651.741.3344arthur.lucas75@outlook.com9504 RIVER ROADAtlantaGA30300N/A-
PRVPRV-213652026-03-16T20:19:43ZJohnston, Sam—····2/8/1978nullUNKNOWN3232751298—1434 Palm DriveLas Vegas·NV89112null—
ENRENR-1313762026-01-04T03:45:52ZKaren—Harrison01/26/87·UHC-86250-15•••-••-1653UNKNOWNUNKNOWN718 Canyon RdJacksonvilleFL·32207GRP-8028SELECT-EPO
ENRENR-122503 2026-02-10T15:40:04ZDONALD—DUNCAN1962-07-13UHC-03962-67•••-••-3680785-302-6888DONALD.DUNCAN@GMAIL.COM8339 Mountain View DriveMesaAZ85244GRP-9321MEDICARE-ADV-B
CLMCLM-4145712026-01-09T22:20:50ZLUIS—MUNOZ01/25/97UHC-45111-01•••-••-8939565-723-8308NULL—··N/A·UNKNOWN—OPTIONS-PPO
ENRENR-1133532026-05-06T14:26:08ZROGERU.RAY19770803UHC-43599-50—(787) 500-8643roger.ray@icloud.com4127 Apache Blvd·MesaArizona··85214-1674GRP-9426OPTIONS-PPO
ENRENR-1138012026-06-03T12:23:31ZjanetTelliottSep 18, 1976UHC-44835-28•••-••-56183494185569N/A5041 Mountain View DrGilbertAZ85216GRP-0238SELECT-EPO
TPATPA-599682026-05-11T16:03:37ZERICGPERKINS1999-11-21———ERIC.PERKINS@HOTMAIL.COM7227 Sunset BlvdTampaFL33639GRP-6080CHOICE-PLUS-PPO
CLMCLM-4192382026-07-21T14:13:11ZSAMUELKDANIELS1987-06-15UHC-88956-84•••-••-9324—UNKNOWN423 Ocean AveSeattleWA98180N/ANAVIGATE-HMO
ENRENR-1418032026-04-07T19:47:17ZCrlos—Tucker1981-10-07UHC-87861-85•••-••-3304·333-463-0761carlos.tucker8@aol.com344 Elm St Apt 16ColumbusOH43294GRP-7370MEDICARE-ADV-A
ENRENR-114050 2026-02-13T15:57:18ZPeter—Willis12/24/46UHC-19939-26•••-••-4461+1 435 493 9382··peter.willis@aol.com1547 Camelback RdJACKSONVILLEFL32252GRP-6246NAVIGATE-HMO
ENRENR-135779 2026-06-28T04:36:51ZsantiagoT.lane1946-01-18UHC8341550•••-••-8186699-397-4272santiago.lane@gmail.com1353 Grand AveMiamiFL33198GRP-7252CHOICE-PLUS-PPO··
ENRENR-1177282026-03-06T10:05:39ZLi, Greg——1994-10-04UHC-53739-09UNKNOWN(334) 241-6899GREGORY.LI@YAHOO.COM-—NULL—GRP-8840CHOICE-PLUS-PPO
ENRENR-1054042026-02-19T07:45:39ZAmanda—Morrison2003-01-12··UHC-73807-14UNKNOWN·12494692364amanda.morrison@yahoo.com6629 Indian School RoadTampaFL33645GRP-4490NAVIGATE-HMO
ENRENR-1119222026-04-09T11:56:37ZSOPHIA—HARRIS1939-08-24UHC0706971•••-••-5089617-901-2513SOPHIA.HARRIS96@PROTON.ME8447 Camelback Road··TampaFlorida33665GRP-8643SELECT-EPO
CLMCLM-4039772026-03-09T10:47:35Zdaniel—white1994-09-26UHC-97483-98-null—NULL—N/AnullGRP-7334UNKNOWN
ENRENR-1220502026-09-17T18:51:04ZKyleJVega2006-05-23·uhc-33666-83•••-••-0210·9236953488KYLE.VEGA53@HOTMAIL.COM377 WASHINGTON STREETSacramentoCA95829GRP-7629··SELECT-EPO
PRVPRV-220172026-07-13T00:40:35ZADAM··ADAMS7/5/1969UHC-49503-77NULL(761) 282-7366—87 Ridge Rd··Las VegasNV89191null—
ENRENR-1372122026-05-09T14:09:18ZJONATHANQ.·BROOKS1999-03-02UHC-27135-67•••-••-7944846-583-4201jonathan.brooks22@aol.com4731 SUNSET BOULEVARDLOS ANGELESCA90089GRP-8485·CORE-HMO
CLMCLM-4078762026-03-23T21:59:07Z·Arnold, Mari——19860313UHC-85249-31•••-••-6371——UNKNOWNNULLUNKNOWN—nullNAVIGATE-HMO
ENRENR-1003492026-02-06T09:54:55ZAdams, Jeremy——1971-07-04UHC-96734-62•••-••-50283987907224NULL4817 Oak StreetAustinTX·78775GRP-9275OPTIONS-PPO
CLMCLM-4118052026-10-10T22:59:36ZKeithJBell10-12-1942UHC-34516-56null··——2197 Oak St Apt 8Eden Prairie·MN55370GRP-3984MEDICARE-ADV-B
ENRENR-1266862026-07-15T06:11:38ZASHLEYL.LAWSON·1942-07-23UHC-23259-90•••-••-4711nullASHLEY.LAWSON81@OUTLOOK.COM5048 Canyon RoadFRESNOCA·93734GRP-5131·MEDICARE-ADV-A
PRVPRV-282682026-08-29T06:00:51ZRANDY·DWARD1966-08-21UHC-18923-49——UNKNOWN··5264 Sage Court··MesaArizona85277··—·CHOICE-PLUS-PPO
TPATPA-50876 2026-09-02T09:56:09ZMarthaMDean1989-02-17N/A•••-••-2395-null··5105 SPRING STREETTempeArizonaN/A—medicare-adv-b
CLMCLM-4306312026-04-22T17:49:42ZWillie—Soto2006-09-19UHC-53600-87UNKNOWN9745816681-8204 Central AvenueSCOTTSDALEAZ85249—NAVIGATE-HMO
ENRENR-102981 2026-03-02T08:56:11ZRussellUJensen1960-08-26UHC-60553-97N/A(864) 628-3416russell.jensen14@gmail.com3170 MAIN STREETScottsdaleArizona85274-5679GRP-1404OPTIONS-PPO
TPATPA-547212026-04-21T15:54:05ZLauren—Perry··1954-10-27····•••-••-9222966.432.6969N/A1166 Camelback RdEden PrairieMN55300NULLMEDICARE-ADV-A
ENRENR-1036002026-07-16T05:11:38ZHIROSHIS.RICHARDS1983-02-20UHC-72946-18•••-••-6865583-234-7104NULL7384 VALLEY VIEW DRGlendaleAZ85353GRP-5892OPTIONS-PPO
TPATPA-535082026-05-26T22:14:19ZLawrence—Diaz1938-06-03NULLNULL(930) 944-0897·lawrence.diaz@gmail.com6968 Mesa DriveChandlerAZ85254UNKNOWN—
TPATPA-610432026-05-30T09:35:47Zsean—·campbellDec 12, 1982UHC-19745-75•••-••-8070366-700-0422—····——UNKNOWN—null
CLMCLM-4265472026-09-24T04:10:29ZDoris—McDonald1956-04-19—-UNKNOWN--——NULLNULLCORE-HMO
ENRENR-1138592026-09-25T08:24:47ZSean—·Silva1959-05-03UHC-15160-88•••-••-428817673356525null7819 Church StChandleraz85221GRP-0782OPTIONS-PPO
ENRENR-1171422026-09-15T12:41:37ZDianaVLane·1940-04-01UHC-50137-28•••-••-3122768-370-4962null·3196 SUNSET BOULEVARDEden PrairieMinnesota55378GRP-2966CHOICE-PLUS-PPO
CLMCLM-4113942026-03-31T08:40:14ZChristinaIGuzman27-07-2000·UHC-18324-39UNKNOWN304-903-6070-——N/A———
ENRENR-1358232026-05-30T04:24:31ZAbigail—Stephens1949-09-04UHC-27778-62··•••-••-1688(327) 479-1689ABIGAIL.STEPHENS73@YAHOO.COM····---GRP-3063CHOICE-PLUS-PPO
ENRENR-1255142026-10-08T04:39:21ZRebeccaO.Tucker1993-04-25UHC8324780—3319960397—5279 ELM STREETLos Angeles·California90000GRP-8753CORE-HMO
CLMCLM-4234102026-02-07T07:40:34ZNICOLE—SHAW1945-12-13UHC-95009-85—(989) 426-8957N/A·8639 Indian School RoadGilbertArizona85296nullCORE-HMO··
ENRENR-1316142026-02-15T12:51:08ZCheryl—Gray1950-06-23UHC-21057-88-236-824-4049·cheryl.gray25@proton.meN/AN/ANULLNULLGRP-2077CHOICE-PLUS-PPO
ENRENR-1168992026-05-18T08:03:24ZSantiago, Joshua—··03/26/06UHC2384359··•••-••-7953—-8004 MOUNTAIN VIEW DRIVECharlotteNC28257GRP-9243MEDICARE-ADV-B
TPATPA-585662026-03-15T15:28:49ZLane, Jerry——10/23/1949——5816804—2060 Ocean AveOrlandoFL32820····—
CLMCLM-428689 2026-08-04T02:51:28ZWalterATucker1976-12-11UHC-36982-74•••-••-449618879136632—7362 Desert Sky BoulevardJacksonvilleFL32253-6147·UNKNOWNSELECT-EPO
CLMCLM-4126322026-02-08T11:08:39Z NANCY—RICHARDSON2006-07-04··uhc-90846-48UNKNOWN—·null8986 Willow CtHoustonTX77006-MEDICARE-ADV-A
TPATPA-543512026-06-21T05:23:33Z·TERESA—HAYES1958-07-09UNKNOWNnull—null———·-·nullNULL
CLMCLM-4073752026-04-13T22:16:53Zsantiago—elliott1989-06-01UHC-52585-76•••-••-6574UNKNOWN·null5848 ELM STOrlandoFL32832NULLchoice-plus-ppo
TPATPA-618472026-03-13T14:28:05Z Joe—Bishop1967-10-04·-——UNKNOWN3979 Elm StreetGilbertAZ85264—null
CLMCLM-4237072026-03-13T16:52:09Z Joyce—·Montgomery1959-03-09UHC-22282-57··—····UNKNOWN··UNKNOWN-····GRP-8932select-epo
CLMCLM-4076912026-07-09T12:16:25ZEUGENE··HKELLY1976-07-07UHC-59154-82NULL—-1751 VALLEY VIEW DRIVEMiamiFL33148-8748GRP-1415—
100,000 rows, page 99 of 2,000PreviousNext

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.806Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty