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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1258372026-06-23T18:22:15Z LaurenLJenkins1993-01-23··UHC-90622-75•••-••-7743420.258.1056—6021 Mountain View Dr Apt 9·AUSTINTX78732··GRP-8710MEDICARE-ADV-A
ENRENR-1300312026-08-30T22:05:32ZLAURA—BISHOP1952-08-16UHC-15246-57•••-••-1839955-527-9262UNKNOWN6443 Forest AveGlendaleArizona85387GRP-1056MEDICARE-ADV-B··
ENRENR-1081182026-10-12T02:59:05ZDENNIS—DAVIS1995-02-16UHC-45986-39•••-••-4399944-683-3114··dennis.davis16@aol.com1031 Jefferson AveTucsonAZ85745-9660GRP-1625medicare-adv-b··
ENRENR-1282242026-01-02T04:07:05ZJamesP.Stewart2004-09-23UHC7145923•••-••-8819(374) 440-2053james.stewart71@yahoo.com1520 Lincoln WaySCOTTSDALEArizona85268GRP-5890OPTIONS-PPO
ENRENR-1310192026-08-23T04:19:26ZJulie—Gomez1941-06-07UHC0845710•••-••-79998062634JULIE.GOMEZ71@PROTON.ME5130 Bayshore DriveGilbertAZ··85241GRP-2596MEDICARE-ADV-B
ENRENR-1207812026-10-10T10:47:32ZEdwad—Santiago1961-01-24UHC-06807-55•••-••-26049312845963-8477 BASELINE RDTempeAZ85299-5394GRP-0845SELECT-EPO
ENRENR-1009382026-01-18T18:41:55ZElizabeth—Wilson02/10/57UHC-61515-34•••-••-7888(918) 502-6324elizabeth.wilson@hotmail.com3145 Desert Sky BlvdPhoenixAZ85002GRP-4816CHOICE-PLUS-PPO
ENRENR-1165672026-09-12T15:16:51ZJerry—·Burke1976-08-18UHC-38441-26•••-••-8400NULLN/A8032 Valley View DriveNASHVILLETennessee37248GRP-4931SELECT-EPO
ENRENR-1322152026-04-12T05:22:37Zalan····dominguez1990-07-24UHC-26620-07•••-••-08052643157691—690 Valley View DriveHoustonTX·77006GRP-4135OPTIONS-PPO
ENRENR-1360212026-08-06T19:29:23ZWayyne—Castillo·03/05/57UHC-95042-59•••-••-58636387266870WAYNE.CASTILLO@PROTON.ME8324 Desert Sky BoulevardSAN ANTONIO·Texas·78247GRP-0218MEDICARE-ADV-A
ENRENR-1211142026-08-15T13:10:42ZJerryORiley24-11-1951UHC-85363-70—6112421163JERRY.RILEY6@OUTLOOK.COM9066 Park PlMIAMIFL33170-4300GRP-3298·MEDICARE-ADV-B
ENRENR-1234642026-01-29T08:27:07Zvirginia—edwards1946-09-24UHC-43742-18•••-••-5116668-907-4854virginia.edwards@icloud.com3182 River Rd··DallasTX75298GRP-2639MEDICARE-ADV-B
ENRENR-1099792026-08-29T14:15:32Z·Sofia—Clark1963-06-07UHC-18310-45··•••-••-04556177107716sofia.clark11@proton.me470 Forest AvenueTAMPA··FL33608GRP-3846CHOICE-PLUS-PPO
ENRENR-1279172026-05-26T21:57:26ZAMANDA—·HALL2005-05-01UHC-90296-30•••-••-75354782432432-··9017 CHURCH STREETMesaaz85215·GRP-6112SELECT-EPO
ENRENR-1065082026-09-20T02:55:53ZWEIOSIMMONS2/28/1986UHC-49677-36•••-••-39472332044463wei.simmons@gmail.com759 RIVER ROADMiami·FL33164·GRP-7024OPTIONS-PPO
ENRENR-1358492026-04-06T15:03:14Zevelyn—walsh1945-11-12UHC-54568-43•••-••-0779(220) 886-0022·EVELYN.WALSH83@PROTON.ME472 Apache BlvdSan AntonioTX····GRP-5351CHOICE-PLUS-PPO
ENRENR-1235732026-05-17T05:12:18ZEdwadr—SpencerMay 3, 1970UHC0121173•••-••-0174·7868662574—6489 ELM STSeattleWANULLGRP-0642NAVIGATE-HMO
ENRENR-1368562026-03-22T08:27:07ZRogerS.Castillo1946-10-01UHC-31070-65•••-••-2718(203) 376-3683roger.castillo95@icloud.com5121 Pine DriveTempe·AZ85261GRP-6696OPTIONS-PPO
ENRENR-1095482026-04-23T17:20:11ZCHARLOTTE··GUERRERO1947-06-06UHC4258043•••-••-7206(885) 509-8443—1517 WILLOW CTTucsonAZ85787-4447GRP-3519CHOICE-PLUS-PPO
ENRENR-1233952026-05-24T22:14:13ZMARIA V—·WAGNER1983-05-02UHC-23015-94N/A4059179634MARIA.WAGNER9@HOTMAIL.COM4726 Valley View Drive·OrlandoFL32877GRP-4548CORE-HMO
ENRENR-1415302026-06-11T12:44:19ZSAMANTHARMEYER1994-09-03UHC-62039-46•••-••-1251427.552.6247samantha.meyer56@outlook.com5138 MARKET STTucsonAZ85774-9921GRP-7984OPTIONS-PPO
ENRENR-1262002026-06-19T17:56:21ZHiroshi——1950-07-07UHC-42235-41•••-••-4920344-364-5351hiroshi.castro@icloud.com4534 CHURCH STGILBERTArizona85228GRP-1527MEDICARE-ADV-A
ENRENR-1293772026-07-25T03:29:54ZJack—Elliott··1972-06-16UHC-52539-55UNKNOWN(989) 374-3226JACK.ELLIOTT45@HOTMAIL.COM7475 Grand AvePlanoTX75097GRP-6964MEDICARE-ADV-A
ENRENR-1037882026-05-12T05:53:32ZEvelynJMorris22-04-1996UHC-90026-65··•••-••-8009757-706-2272····8702 Pine DriveGlendale·AZ85323GRP-0714MEDICARE-ADV-A
ENRENR-1134152026-03-31T12:35:44ZJohnR.Nelson1994-01-21UHC-59328-85•••-••-0666(221) 555-5652null142 Washington StOrlandofl32863-8701GRP-6420NAVIGATE-HMO
ENR ENR-1115762026-07-09T21:50:40ZHIROSHIEMEJIA1996-05-02UHC-81431-34•••-••-77154573777660hiroshi.mejia3@proton.me114 Ridge RdHoustonTX77094GRP-1365select-epo
ENRENR-1027172026-05-23T07:05:43ZEmilyDKennedy1/1/1991UHC-34634-77•••-••-1336—EMILY.KENNEDY@AOL.COM5058 Central AvenueTucsonAZ85746GRP-8226CHOICE-PLUS-PPO
ENRENR-1328522026-06-02T11:56:46ZDOROTHY—MEJIA1961-02-87UHC-13045-75UNKNOWN968-779-9927NULL412 Sunset BlvdDenverCO80246··GRP-1182SELECT-EPO
ENRENR-1193732026-09-28T07:03:29ZLUIS—CRUZ·04/05/1954UHC-82624-56•••-••-7070666.458.3930LUIS.CRUZ@AOL.COM··1564 Grand Ave Apt 18NashvilleTN37283GRP-2676SELECT-EPO
ENRENR-1394652026-07-20T17:57:42ZFrances·UWard1952-09-13UHC-50781-88•••-••-8746948-444-7029··FRANCES.WARD7@HOTMAIL.COM5381 Lincoln WayFresnoCA93702GRP-2117CORE-HMO
ENRENR-1071082026-08-01T00:18:09ZCATHERINE—CHEN··5/12/2001··UHC-18869-02•••-••-59434465809970catherine.chen@aol.com9049 Union StJacksonvilleFlorida32255GRP-0408CORE-HMO
ENRENR-1115972026-05-06T06:24:18ZKevn—Cooper01/02/59UHC-07697-89•••-••-4811(761) 596-5965kevin.cooper@proton.me2403 LINCOLN WAYEden PrairieMN55371GRP-5521CHOICE-PLUS-PPO
ENRENR-1370212026-06-16T16:25:56ZVazquez, JoanB—1958-10-06UHC-66979-80•••-••-7323NULLNULL·2813 VALLEY VIEW DRChandlerAZ85283GRP-0351OPTIONS-PPO
ENRENR-1151292026-09-01T04:02:25ZJordan····Bowman1977-09-10UHC-13738-33•••-••-2540(389) 749-1542jordan.bowman@yahoo.com732 Bayshore DrJacksonvilleFL-···GRP-1745MEDICARE-ADV-B
ENRENR-1389362026-02-07T02:28:42ZBRANDONTWEST08/13/1955UHC-88633-23•••-••-7728(735) 977-9486N/A3868 Palm DrColumbusOH43237GRP-5962CORE-HMO··
ENRENR-1397862026-08-23T08:02:11ZPriyaR.Lane1968-12-20UHC-02436-88null(574) 373-5457··priya.lane@gmail.com7884 Washington StreetNashvilleTennessee37238GRP-9155CORE-HMO
ENRENR-1029732026-03-09T06:37:17ZLauraE.Willis1946-03-19—•••-••-3315(251) 677-4992UNKNOWN3014 Jefferson AvenueSan DiegoCalifornia92175GRP-6528NAVIGATE-HMO
ENRENR-1398792026-04-14T20:53:47ZGerald—Holmes1966-11-23UHC8843173•••-••-3100822.490.5375GERALD.HOLMES81@YAHOO.COM·nullUNKNOWN—NULL··GRP-1566CHOICE-PLUS-PPO
ENRENR-1233692026-01-13T05:11:49ZBRANDONKGIBSON1981-12-23UHC-11579-39•••-••-2137669.550.3338brandon.gibson61@proton.me3333 Maple AvenueDenverCO80292-2944GRP-1989MEDICARE-ADV-B
ENRENR-1233772026-08-17T03:42:48ZSTEVEM.·GUERRERO1966-09-27UHC-23579-55•••-••-2308656-284-9300STEPHEN.GUERRERO@HOTMAIL.COM1690 Union Street #111SAN DIEGOCA·92192GRP-3565SELECT-EPO
ENRENR-1142032026-07-17T22:33:29Z AshleyWGibson2005-08-12uhc-63272-10•••-••-02077703697222NULL8818 MAPLE AVENUEPhoenixAZ85045GRP-5445··OPTIONS-PPO
ENR ENR-1296232026-02-03T12:49:55ZARTHUR—RYAN06/17/64UHC-17123-61•••-••-5522+1 600 702 5020ARTHUR.RYAN55@ICLOUD.COM2777 Oak Street Apt 5TampaFL33672GRP-7908MEDICARE-ADV-A
ENRENR-116245 2026-07-06T20:53:10ZJEFFREYCCRUZ1953-02-14UHC-64784-69•••-••-0518NULLjeffrey.cruz11@hotmail.com6155 Ocean Avenue #695NashvilleTN37211GRP-4508CHOICE-PLUS-PPO
ENRENR-1208472026-07-19T22:37:06ZMeyer··—Bryan··2003-04-09UHC-36141-72•••-••-03884763341658bryan.meyer64@proton.me5618 Jefferson Avenue··HoustonTX·77035GRP-0778SELECT-EPO
ENRENR-1359362026-09-09T11:20:54ZERIC··D.RUSSELL12/03/64UHC-83773-63•••-••-3946(231) 787-1677eric.russell2@proton.me··3605 Ridge RoadMesaAZ85250GRP-7205navigate-hmo
ENRENR-1259692026-07-15T16:56:53Zhelen—snyder02/01/1977UHC-56443-63UNKNOWN(633) 972-4359HELEN.SNYDER96@HOTMAIL.COM2599 Willow CourtATLANTAGA30371GRP-2394MEDICARE-ADV-B
ENRENR-1045892026-03-15T12:14:39ZPAMELA—THOMPSON1981-12-15UHC-13349-08•••-••-8423483-683-1585pamela.thompson@icloud.com99 VALLEY VIEW DRIVEGlendaleaz85374GRP-3369CORE-HMO
ENRENR-132081 2026-01-24T11:25:03ZMeteoDSanchezNov 11, 1996UHC-38016-14•••-••-5129438-652-7009null8758 CAMELBACK RDCHANDLERAZ85262GRP-3208MEDICARE-ADV-A
ENRENR-1368182026-03-26T16:37:10ZNancyM.···Welch1953-10-02UHC-99296-28•••-••-7877—-8417 CENTRAL AVENUEMinneapolisMN55414GRP-1442SELECT-EPO
ENRENR-1084472026-06-26T10:33:28ZJUDITHBWOOD1949-01-49UHC-98663-15•••-••-5012315-536-4374judith.wood@icloud.com3125 DESERT SKY BLVDEden PrairieMN55364··GRP-2107CHOICE-PLUS-PPO
43,101 rows, page 128 of 863PreviousNext

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