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-1404392026-09-14T19:52:23ZKatherineQWheeler1982-06-17·UHC-14259-82UNKNOWN+1 945 917 1020katherine.wheeler73@outlook.com5094 MAPLE AVELas VegasNV89196GRP-0210SELECT-EPO
ENRENR-1310182026-08-19T10:07:24ZMeiFArmstrongJun 21, 1992UHC-83413-64•••-••-9378237-782-0792MEI.ARMSTRONG16@AOL.COM6233 Canyon RdPlanoTX··75071GRP-3687OPTIONS-PPO
ENRENR-1392982026-09-24T02:33:05Z JACOB··M.JORDAN09/08/1958UHC-33868-33—(421) 675-9993jacob.jordan@aol.com5985 LAKE VIEW RDMIAMIFL33131GRP-3068MEDICARE-ADV-B
ENRENR-1304902026-07-04T11:36:19Z ChristopherF.Guzman19850201UHC-36360-94•••-••-3995(358) 421-6614christopher.guzman95@proton.me4117 River RoadMiamiFL33169GRP-8430CHOICE-PLUS-PPO
ENRENR-1038022026-07-27T17:42:38ZKim—JacobsJan 28, 1969UHC-81813-82•••-••-8744865.301.1418kimberly.jacobs1@hotmail.com184 Jefferson Ave Apt 26··TempeAZ85241GRP-1426OPTIONS-PPO
ENRENR-1065682026-07-07T05:43:08ZMarthaVWillis19660720UHC-62076-92•••-••-1825866.912.6245martha.willis60@outlook.com3212 BAYSHORE DRIVEGLENDALEArizona85351GRP-1686MEDICARE-ADV-B
ENRENR-1091562026-06-19T03:12:47ZJUAN—BURTON1964-08-28UHC-41210-57•••-••-0507304.930.6488JUAN.BURTON86@GMAIL.COM7543 RIDGE ROADLos Angeles·CA90005GRP-5985CHOICE-PLUS-PPO
ENRENR-1090762026-01-07T16:24:10ZDOROTHYS.NUNEZ16-01-1975UHC2758332•••-••-25637503396160dorothy.nunez@icloud.com5049 SPRING STREET Apt 28MinneapolisMN—·GRP-2968CHOICE-PLUS-PPO
ENRENR-1046282026-09-07T04:28:09ZMARILYNZ.ELLIOTTMay 15, 2008UHC-08946-09•••-••-0178+1 212 878 3719MARILYN.ELLIOTT@ICLOUD.COM1704 UNION STREETAtlantaGeorgia30342GRP-6960MEDICARE-ADV-B
ENRENR-1417792026-03-25T05:49:26Z SARA—MCCOY1938-02-24UHC-49462-80•••-••-1513825-556-2765UNKNOWN7050 Forest Avenue Apt 25CharlotteNC··28281GRP-9853OPTIONS-PPO
ENRENR-1100722026-04-01T15:44:12ZJustinC.Aguilar1963-01-19UHC-83597-02•••-••-3965(362) 873-2648justin.aguilar45@yahoo.com1260 Canyon RoadLas VegasNV89131GRP-5158MEDICARE-ADV-A
ENRENR-1336952026-07-06T02:37:28Z GeorgePWalker09/24/72UHC-24290-02•••-••-9042502-313-5191GEORGE.WALKER81@GMAIL.COM6940 Valley View DriveScottsdaleAZ··85207GRP-9446NAVIGATE-HMO
ENRENR-1404572026-02-15T18:50:43ZMelissa—Patterson1982-09-23UHC-00168-06•••-••-6711537-799-7633melissa.patterson71@aol.com6288 HARBOR BOULEVARDAustinTexas78721GRP-1062MEDICARE-ADV-A
ENRENR-1063592026-08-20T06:24:32Z·MARCUSU·HART1981-31-13UHC-36017-42•••-••-8036437-352-6442N/A3873 LINCOLN WAYGilbertAZ85279GRP-2733CORE-HMO··
ENRENR-1116812026-08-14T13:27:06ZSophia—Morrison17-10-1992·UHC-12669-51•••-••-3746761-615-3445sophia.morrison89@yahoo.com1780 Bayshore Dr·TampaFL33663GRP-1538MEDICARE-ADV-A
ENRENR-1301422026-01-23T17:09:06ZMASONLESSPINOZA1994-02-10uhc-05793-04··•••-••-0483—mason.espinoza19@hotmail.com8800 SAGE COURTEDEN PRAIRIEMinnesota55358GRP-3269MEDICARE-ADV-A
ENRENR-1248542026-10-02T21:33:22Z·Mitchell, EthanT—Aug 17, 1954uhc-64818-21•••-••-5636293-852-4806ethan.mitchell@gmail.com4533 VALLEY VIEW DR··Atlanta·GA30372-6106GRP-4191CORE-HMO
ENRENR-1364922026-04-05T15:23:15ZCATHERINEKJONES2003-04-07UHC-34408-38•••-••-22087004956362catherine.jones@icloud.com311 Willow CourtJacksonvilleFL32259GRP-6984CORE-HMO
ENRENR-1308672026-08-03T12:45:42ZRebeccaTRodriguez1996-06-08UHC7212301•••-••-64284757714074rebecca.rodriguez59@gmail.com1058 Lake View Rd #652DenverCO80214GRP-8141MEDICARE-ADV-A
ENRENR-1058612026-03-20T16:07:35ZAUSTIN··Y·FRANKLIN1986-06-21UHC-79654-26•••-••-4138225.564.8574austin.franklin78@yahoo.comnull—nullUNKNOWNGRP-0619OPTIONS-PPO
ENRENR-1235692026-03-04T02:56:55ZBRADLEY—HERRERA20060210UHC-52427-22•••-••-44717925801384-··3645 Mountain View DrScottsdale··az85286GRP-0273OPTIONS-PPO
ENRENR-1217532026-06-21T05:45:01ZMeiT.Le07/21/42UHC-19059-48•••-••-2456584-543-9885N/A1892 FOREST AVESacramentoCA95827GRP-4800MEDICARE-ADV-A
ENRENR-1294702026-03-26T23:17:50Z·KEVINM.GORODN1971-10-03UHC-08655-80•••-••-1055(356) 646-0420-1100 UNION STREETChandler·AZ85281GRP-0574MEDICARE-ADV-A··
ENRENR-1131562026-07-26T19:26:20ZTimothyBBennett1999-12-06UHC-36770-15·null—·timothy.bennett19@proton.me·8571 BAYSHORE DRIVESan DiegoCA92178GRP-6664SELECT-EPO
ENRENR-1162952026-09-16T00:07:42ZDiegoM.Montgomery1959-10-22UHC-93543-76•••-••-12993663529557·diego.montgomery@gmail.com5307 JEFFERSON AVENUEFresnoCA93719GRP-6940CHOICE-PLUS-PPO
ENRENR-1317992026-05-01T05:29:59ZSophia, ScottF—1949-03-16UHC-50442-67•••-••-6121(343) 629-7675—3828 Palm DrCharlotteNC28283GRP-7933SELECT-EPO
ENRENR-1346872026-08-23T18:49:27ZSCOTT—NGUYEN1957-04-16UHC-55213-44•••-••-9922(910) 485-2404·SCOTT.NGUYEN71@PROTON.ME·3549 Forest AveNashvilleTN37216GRP-5736MEDICARE-ADV-B··
ENRENR-1181522026-03-02T23:36:29Z—P—1954-02-08··UHC-37521-41•••-••-32032485613595kathryn.sandoval80@icloud.com6364 Maple AveSeattlewa98142GRP-1586··MEDICARE-ADV-B
ENRENR-1404632026-08-16T02:46:43ZCAMILA—RUSSELLNov 10, 2008UHC-48176-69•••-••-2019+1 941 774 3586camila.russell47@outlook.com535 INDIAN SCHOOL RDGilbertArizona85227GRP-5697CHOICE-PLUS-PPO
ENRENR-1261962026-07-14T16:35:28Z CARL—HILL1975-01-27UHC-51850-24•••-••-6563UNKNOWNCARL.HILL92@GMAIL.COM9031 Harbor BoulevardAtlantaGA30332·GRP-7251CHOICE-PLUS-PPO
ENRENR-1325932026-08-07T03:09:09ZStephanie····Collins1974-08-04UHC-85615-89null(278) 932-1986N/A7857 Ridge RdSan AntonioTX78280GRP-6413CHOICE-PLUS-PPO
ENRENR-1336762026-01-14T13:50:47ZSara—Webar19511212UHC-48334-61•••-••-6297(675) 616-3224—N/A·UNKNOWN··nullGRP-1988·CORE-HMO
ENRENR-1241942026-03-19T10:24:41ZMarcus—Soto1977-03-21UHC8553058•••-••-8181986-534-1919marcus.soto94@outlook.com8050 Main StreetAtlantaGA30362-7828GRP-9746MEDICARE-ADV-B
ENRENR-1163102026-10-02T01:38:18Zkayla—kelley8/26/1969UHC-57021-47•••-••-7905(403) 737-6290··kayla.kelley@gmail.com4111 Cedar LnChandlerAZ85289··GRP-5804MEDICARE-ADV-A
ENRENR-1215462026-09-14T13:33:46ZVincentU.Ruiz10/12/1948UHC-27931-26•••-••-8671+1 366 585 0381vincent.ruiz@aol.com3608 Cedar LaneATLANTAGA30342GRP-7511select-epo
ENRENR-1117372026-06-13T11:29:37ZBenajmin—Rivera1938-09-23·UHC-30206-07•••-••-8847+1 463 905 7281benjamin.rivera@outlook.com2529 CEDAR LANESan DiegoCA·92195·GRP-8627NAVIGATE-HMO
ENRENR-1022392026-02-09T02:29:12ZJACOBVDIAZ10/15/51UHC9894609•••-••-3342·262.935.7695JACOB.DIAZ@OUTLOOK.COM37 Camelback RdGlendaleArizona85327GRP-2917CORE-HMO
ENRENR-109585 2026-01-20T08:09:10ZKARENC.REYNOLDS1988-02-26UHC-08446-48•••-••-4266836-718-6418karen.reynolds@outlook.com1841 Spring StSeattleWA98115GRP-3373CHOICE-PLUS-PPO
ENRENR-1228452026-01-10T02:46:41ZRuth E—Patterson3/24/1998UHC-86334-25•••-••-4153825-329-0339RUTH.PATTERSON@ICLOUD.COM8110 OAK STREETMESAAZ-·GRP-5159MEDICARE-ADV-B
ENRENR-1169252026-09-12T14:33:06ZKathrynKMiller1952-08-16UHC-44187-73•••-••-5971—kathryn.miller@hotmail.com6550 Church StreetFresno··CA93726GRP-1856··MEDICARE-ADV-A
ENRENR-1287242026-03-29T20:22:30ZBrenda—Henry1982-05-17UHC-49567-69•••-••-3234(346) 875-3213brenda.henry@proton.me62 RIDGE RDLOS ANGELESCalifornia90069··GRP-1368CHOICE-PLUS-PPO
ENRENR-1398472026-02-23T12:12:23ZEMILYA.HOWARDJun 4, 1966UHC-32460-21N/A5692927340null525 Meadow LaneColumbusOH43211··GRP-7249OPTIONS-PPO
ENRENR-1276292026-06-30T17:13:36ZCHRISTINA—SCHMIDT07/28/77··UHC-55081-24•••-••-8685404-928-2746N/A5231 LAKE VIEW RDTempe··AZ85205-5713GRP-6907MEDICARE-ADV-B
ENRENR-1114322026-09-05T14:41:46ZTheresa··Wood02/09/1943·UHC-97928-43•••-••-5602797.907.9745NULL698 Union StreetPhoenixAZ85072GRP-9215OPTIONS-PPO
ENRENR-1015212026-09-16T20:45:12ZSims, JeanR—1975-09-27UHC-38336-47—(567) 521-0132jean.sims5@icloud.com2734 MOUNTAIN VIEW DRSACRAMENTO·ca95876··GRP-5646MEDICARE-ADV-B
ENR ENR-1345312026-07-06T17:01:57ZAhmedL.Carter1980-10-01UHC4117279•••-••-9138812.325.6993··ahmed.carter@icloud.com·8000 CAMELBACK RDTampafl33691-3083GRP-2958OPTIONS-PPO
ENRENR-1426022026-06-25T21:29:02ZPATRICIA—RICHARDS1965-06-27UHC-53338-88•••-••-6775817-533-7623patricia.richards@aol.com2662 MAIN STREETChandlerAZ85211GRP-6604MEDICARE-ADV-B
ENRENR-1390802026-02-06T06:19:45ZCAMILA—REID1944-08-22UHC-77952-66•••-••-2910(652) 793-5633camila.reid39@aol.com9808 Forest AvenueDenverCO80248GRP-0252MEDICARE-ADV-B
ENRENR-1199652026-03-09T22:17:48Zeugene—dean··11/04/80·UHC-92457-43•••-••-1734703-404-3731-1663 FOREST AVENUESACRAMENTOCA95876GRP-5569MEDICARE-ADV-A
ENRENR-1230802026-03-27T00:04:18ZEric V.—Freeman1979-11-06UHC-06917-70—8084558536ERIC.FREEMAN89@GMAIL.COM2593 CANYON RD··San AntonioTX78284GRP-8571SELECT-EPO
43,101 rows, page 39 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:34.799Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty