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-1194342026-10-17T03:56:09ZFrances Z.—White1968-11-16UHC-12054-22—647-573-4121frances.white@yahoo.com3852 Main StreetDallas··TXnullGRP-6156CHOICE-PLUS-PPO
ENRENR-1288342026-08-12T01:42:59ZANDREWD.RYAN·1938-11-04UHC8049857•••-••-2774·nullANDREW.RYAN@AOL.COM5629 Pine DriveHoustonTX··77089··GRP-5710··MEDICARE-ADV-B
ENRENR-1111162026-03-03T09:37:38ZPatricia—Banks2007-05-19UHC-67902-87•••-••-0937(559) 421-0595patricia.banks4@aol.com4827 Willow Ct #283San AntonioTX78218GRP-0789OPTIONS-PPO
ENRENR-1171192026-01-11T02:20:44Zmarcus—gutierrez07-08-1951UHC-02151-27•••-••-6481368-363-3570MARCUS.GUTIERREZ@YAHOO.COM1976 Church StPLANOTX75033·GRP-9942OPTIONS-PPO
ENRENR-1013412026-06-24T13:41:03ZDAVIDPCONTRERAS13-11-1993·UHC-93508-57•••-••-8732301-484-0962david.contreras@outlook.com8288 Spring StGlendaleAZ··85345GRP-5159NAVIGATE-HMO
ENRENR-1175352026-01-07T20:59:08ZRachel—Marshall1988-03-07UHC-50684-24—·723.905.1021rachel.marshall98@hotmail.com8677 Washington StreetGilbertAZ85214-9087GRP-5647CORE-HMO
ENRENR-1111262026-10-10T12:17:47ZBrandon—Kim2005-03-05UHC-49210-04•••-••-8693986.968.1859brandon.kim@aol.com9353 Church StSan Diego·CA92173GRP-8534MEDICARE-ADV-B
ENRENR-1123372026-03-28T16:58:22ZGERALDW.RAMIREZ05/28/75UHC-09097-49•••-••-4424+1 848 434 2645GERALD.RAMIREZ@AOL.COM7735 Ridge RoadNASHVILLE··TN37236GRP-7057MEDICARE-ADV-B
ENRENR-1236892026-04-30T08:04:30Z HenryUCarroll3/16/1968UHC-95952-29•••-••-99027672710341henry.carroll69@yahoo.com6390 WILLOW CTSACRAMENTOCA95872GRP-4917SELECT-EPO
ENRENR-1291112026-08-14T22:16:22ZReyes, Kevin——1938-04-09UHC-54672-04•••-••-7373571.647.8007kevin.reyes34@proton.me172 Sage CourtSeattleWA·NULLGRP-9023··SELECT-EPO
ENRENR-1326442026-10-02T10:24:47ZGary V.—Rice1983-06-05UHC-79247-20•••-••-126816587037804GARY.RICE@YAHOO.COM-··UNKNOWNN/A—GRP-6632MEDICARE-ADV-B
ENRENR-1159922026-05-09T06:52:57ZLisaXHart1958-02-28UHC-49707-65•••-••-3348549-625-1448lisa.hart66@gmail.com··9687 LAKE VIEW RDColumbusOH43252GRP-6052NAVIGATE-HMO
ENRENR-1202392026-04-20T11:54:06ZJasonCTuurner··1941-04-06—•••-••-4470(292) 945-9744jason.turner39@yahoo.com6041 Park Pl··SCOTTSDALEAZ85283GRP-5738SELECT-EPO··
ENRENR-1265262026-10-14T08:19:28ZJerry—Hughes1998-05-16UHC-76428-97•••-••-0224409.208.7854·jerry.hughes8@hotmail.com5967 Meadow LaneTempe·AZ85200-1259GRP-1020MEDICARE-ADV-A
ENRENR-1014412026-04-14T10:18:04ZkathrynWholmes1939-02-10UHC-21580-23•••-••-4060206-950-1377NULL1223 CANYON ROADAUSTINTX78717GRP-0902NAVIGATE-HMO
ENRENR-1270672026-01-28T02:23:53ZYoung, RoyX.—1964-04-11UHC-43268-74•••-••-28066443274383roy.young@icloud.com3149 MOUNTAIN VIEW DRIVE Apt 22JacksonvilleFL··32273-0175GRP-4867MEDICARE-ADV-B
ENRENR-1209032026-10-08T10:18:21ZTerry—Gomez1/21/2002UHC9794544N/A8139961NULL···875 Grand AveEden Prairie··MN55359-5344GRP-7407MEDICARE-ADV-A
ENRENR-1423032026-04-12T14:38:53Zjoan—price1938-10-13UHC-30347-25—877-521-7866—5568 River RoadSeattleWashington98144GRP-6619select-epo
ENRENR-1101842026-02-10T17:44:06ZCHRISTINA—YOUNG1946-01-15UHC-65599-85—453.354.4179-1509 Maple Avenue Apt 13DenverCO80225GRP-9362MEDICARE-ADV-A
ENRENR-1382722026-09-09T18:16:58ZbryanRgibson·1975-01-08UHC-97590-49•••-••-74738896080724bryan.gibson@icloud.com7113 SPRING STREET·FRESNOCA··93789GRP-0884MEDICARE-ADV-A
ENRENR-1308062026-01-10T11:35:07Z MaryJWatkins·1994-02-25UHC-68504-43—585-338-8926—6724 Baseline Road··JacksonvilleFL32288-6439GRP-7920SELECT-EPO
ENRENR-1237192026-03-23T04:32:25ZAlanR.·Duncan1974-03-18UHC-33937-60•••-••-3981605-431-2076alan.duncan74@gmail.com5209 Sunset BlvdNashvilleTN37222-8885GRP-2502CHOICE-PLUS-PPO
ENRENR-1003312026-03-02T04:43:13ZLoriSMendoza1973-05-08UHC-66986-50•••-••-874716517234862null·9073 Indian School RoadGILBERTArizona85235GRP-4536NAVIGATE-HMO
ENRENR-1422052026-07-17T21:19:32Z·JessicaYEvans·1992-05-05UHC-18410-68•••-••-9960682-907-2676·JESSICA.EVANS68@PROTON.ME4955 BroadwayLas VegasNVNULLGRP-2016CHOICE-PLUS-PPO
ENRENR-1303412026-08-14T01:14:39ZChristine—Cunningham·1980-12-13UHC-36095-33-346-412-8711-9251 Ridge RdDallasTX75296GRP-9254OPTIONS-PPO
ENRENR-1016602026-04-16T21:01:24ZCHRISTOPHER—COLEMAN1950-04-12UHC-32322-15NULL597.288.6469christopher.coleman@icloud.com1911 OCEAN AVEMiamiFL33172GRP-3054SELECT-EPO
ENRENR-1183232026-09-14T14:33:50ZJudith—Foster9172-07-03UHC-34522-45•••-••-9040539-656-6661JUDITH.FOSTER@PROTON.ME6667 Elm Street #433DallasTX75243GRP-8828MEDICARE-ADV-A
ENR ENR-1131522026-10-16T14:08:47ZTler—·SullivanJul 6, 1992·UHC-70041-90•••-••-0613(960) 321-5648TYLER.SULLIVAN66@YAHOO.COM1500 Meadow LaneMiamiFlorida33115-0068GRP-8703SELECT-EPO··
ENR ENR-1219802026-02-20T13:17:16ZMike—Simmons02/27/94·UHC-55383-31•••-••-486513948378915—3978 Broadway··HoustonTX77078GRP-4135MEDICARE-ADV-B
ENRENR-1207442026-04-16T02:48:01ZOLIVIA—RAMIREZ1992-11-08UHC0181353•••-••-8474855-833-3445olivia.ramirez@proton.me3133 SUNSET BLVDSAN ANTONIOTX78245GRP-2240CORE-HMO
ENRENR-1071432026-02-24T22:37:12ZFrances—Butler05/07/86·UHC-19278-43null(945) 774-5868··frances.butler44@outlook.com4527 UNION STChandlerAZ85274GRP-9467NAVIGATE-HMO
ENRENR-1060032026-07-24T17:31:03ZAndrewD.Freeman19590114UHC-02052-01•••-••-69593559211510—·4715 Palm DrTucsonAZ—GRP-7092OPTIONS-PPO
ENRENR-1166432026-07-20T16:32:05ZMari··—Warrd1968-05-28UHC-00922-08•••-••-6845UNKNOWNmaria.ward82@hotmail.com6177 Central AveLos AngelesCA90025GRP-7056··MEDICARE-ADV-B
ENRENR-1042242026-07-06T04:17:31ZGaryHPalmer1948-08-24·UHC-85894-33•••-••-3785(731) 888-2464null342 Washington StreetEden PrairieMN55395GRP-8943NAVIGATE-HMO
ENRENR-1129682026-01-16T00:39:39Z VICTORIAP.MITCHELLMay 8, 1982UHC-89946-94•••-••-30539235847VICTORIA.MITCHELL35@HOTMAIL.COM4460 Mountain View DrNASHVILLETN··37207GRP-0196SELECT-EPO
ENRENR-1351892026-07-08T15:10:09ZMendez, Linda——1987-05-08UHC-91612-22•••-••-5585·9584414884N/A9362 WILLOW CTTEMPEAZ85226GRP-0755CHOICE-PLUS-PPO
ENRENR-1199032026-08-31T12:53:50Z ANAL.WEBB28-09-2002UHC-90823-82•••-••-3282—ANA.WEBB@OUTLOOK.COM6431 Desert Sky BoulevardTampaFL33641GRP-7610CORE-HMO
ENRENR-1205362026-03-02T21:34:46ZFoster, Lori——1993-05-17UHC-94326-05-479-632-6521lori.foster95@aol.com8427 RIVER RD·Eden PrairieMN·55339GRP-6681NAVIGATE-HMO
ENRENR-1268652026-08-15T09:04:13ZBRUCEDDAVIS··2/4/1963UHC-59299-76•••-••-4619—BRUCE.DAVIS@GMAIL.COM7362 Apache BlvdTempeaz85262GRP-1966SELECT-EPO
ENRENR-1069422026-04-21T08:30:38ZRAMOSX.·CHARLOTTE1974-07-17UHC9663946•••-••-0380551-781-9373UNKNOWN8596 Indian School RdJACKSONVILLEFL32211··GRP-9272MEDICARE-ADV-A
ENRENR-1115732026-08-19T18:00:36ZBradleyCPierce1994-09-12UHC-10913-48•••-••-6716(944) 797-6638··2723 Desert Sky BoulevardGilbertAZ85266GRP-1566·OPTIONS-PPO
ENRENR-1318262026-01-08T08:53:25ZHelenYHudson1992-12-26UHC-69159-53•••-••-1121445.220.4883HELEN.HUDSON51@ICLOUD.COM7169 OCEAN AVELos AngelesCA90058GRP-7520CHOICE-PLUS-PPO
ENRENR-1359202026-07-25T00:25:50ZChristopher—Medina1954-01-26UHC-47341-58·-(359) 811-5467-2266 OAK STREETMiamiFL··33156GRP-8427OPTIONS-PPO··
ENRENR-1123912026-05-29T01:45:18Z·NoahTBowman1943-08-06UHC5128470•••-••-8465828-600-5804noah.bowman74@proton.me5853 Cedar LaneLas Vegas·NV89120GRP-6472CORE-HMO
ENRENR-1358732026-09-05T11:18:08ZJOYCEBBLACK2004-04-08UHC-16597-33•••-••-79645440767joyce.black36@proton.me7526 HARBOR BOULEVARDDenverCO80263GRP-4243CHOICE-PLUS-PPO
ENRENR-1302382026-08-11T09:59:22ZJIMZHERRERA1979-11-09UHC-24048-03•••-••-1993·(344) 704-3368—6370 MEADOW LNSeattleWA98144GRP-4649CHOICE-PLUS-PPO
ENRENR-1361492026-04-01T01:00:36ZLawrenceSCarter1943-08-09UHC-03473-40•••-••-4062(656) 660-1272lawrence.carter12@icloud.com7006 PINE DRMiamiFlorida33145GRP-2156NAVIGATE-HMO
ENRENR-1093342026-08-30T02:03:29ZSophia—DiazJul 10, 1944UHC-97392-72•••-••-5246UNKNOWN·sophia.diaz65@gmail.com5031 Meadow LnMiamiFL33116-5458GRP-2895NAVIGATE-HMO
ENRENR-1311132026-03-20T20:25:39ZDOROTHYR··HARRISON1952-09-10uhc-14183-38•••-••-0545365-849-8699dorothy.harrison@icloud.com9607 Ocean Avenue··Atlanta·GA30352GRP-2413CORE-HMO
ENRENR-1325112026-02-12T15:34:26ZWillie··—Jensen1943-06-26UHC-76046-12•••-••-4907252.387.7125willie.jensen14@gmail.com3180 Market Street Apt 3SAN ANTONIOTX78283GRP-6479SELECT-EPO
43,101 rows, page 282 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:43.439Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty