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-1089302026-09-15T01:03:18ZBrian—Gordon19650113UHC-81204-88•••-••-6978(856) 674-0511·UNKNOWN2269 WILLOW CTAustinTX78791GRP-0319CHOICE-PLUS-PPO
ENRENR-1377902026-04-14T05:35:17ZWelch, ZacharyR.—Jul 14, 1944··UHC-56247-92•••-••-7746(271) 668-1493—8305 JEFFERSON AVE #167··Columbusoh43245GRP-4946CHOICE-PLUS-PPO
ENRENR-1290692026-07-19T22:12:41ZISABELLAF.GOMEZ19981010UHC-64666-87•••-••-3494····isabella.gomez@gmail.com··6632 Union Street #321JacksonvilleFL32212-3438GRP-7100CORE-HMO
ENRENR-1044802026-02-02T12:18:37Z·marthaV.sandoval1971-07-21UHC-24262-06•••-••-5733737-995-7354-2698 Cedar LaneGILBERT·az-GRP-7717CHOICE-PLUS-PPO
ENRENR-1003462026-04-26T18:43:13ZRebeccaBMorris1949-09-08UHC-18498-20•••-••-72358453216367rebecca.morris@icloud.com1980 Hillcrest RoadPhoenixAZ··85030GRP-8066NAVIGATE-HMO
ENRENR-1122542026-04-28T16:18:32ZDENNIS J—MEDINA07/25/1967UHC-69245-14•••-••-51673388039639null7642 Mesa Drive #472JacksonvilleFL32238GRP-8389OPTIONS-PPO
ENRENR-1186282026-08-18T09:03:46Z Pena, JessicaN—1967-12-17UHC6646653•••-••-1731702-967-7363—6112 WASHINGTON STREETFresnoCA93746-5288GRP-0577··CORE-HMO
ENR ENR-1198922026-03-26T01:51:37ZDylan····Jenkins··2002-08-14UHC2671250•••-••-9759-··dylan.jenkins@outlook.com4438 Park Pl·DallasTXNULLGRP-1802OPTIONS-PPO
ENRENR-1012662026-03-11T12:48:52ZOrtiz, Justin——19561205UHC-24168-07•••-••-6819+1 546 674 7824UNKNOWN8585 MAPLE AVENUEColumbusOH43263GRP-8488NAVIGATE-HMO
ENRENR-1306172026-02-21T18:42:07ZEmilyM.Snyder1990-07-08UHC6284317•••-••-9161·529-982-2278emily.snyder@hotmail.com··5701 HILLCREST RDSeattle··WA·98150GRP-1805CORE-HMO
ENRENR-116148 2026-09-18T20:43:40ZDavid··WHansen2004-02-20UHC-62023-76•••-••-0453UNKNOWNdavid.hansen87@aol.com8251 Apache BoulevardJACKSONVILLEFL32255GRP-7286CHOICE-PLUS-PPO
ENRENR-1278362026-04-04T06:46:50ZCarlson, Randy——1948-01-28UHC-66217-85•••-••-81103114600537randy.carlson@proton.me9624 BASELINE RDDallas·txnullGRP-4359MEDICARE-ADV-B
ENRENR-1262112026-02-23T20:06:16ZLUCIAD.THOMPSON1985-12-14UHC-83698-89•••-••-51232434166660N/A19 Pine DriveSan AntonioTXNULLGRP-5711CORE-HMO
ENRENR-1387042026-04-19T16:29:05ZChristopher—Davis4/14/1986UHC-15407-27•••-••-84313003032139christopher.davis@outlook.com6306 Jefferson Ave·ATLANTAGA30301GRP-7269MEDICARE-ADV-B
ENRENR-1344942026-02-20T08:44:05ZTimothyEHerrera20040525UHC-89916-28—5996330040NULL1567 Grand Ave·AustinTX78797GRP-4022select-epo
ENRENR-1228792026-05-15T16:57:00ZElijahL.Burke03/26/1994UHC-30110-62•••-••-1001—elijah.burke72@outlook.com6133 WASHINGTON STREETGilbertAZ85221GRP-6103SELECT-EPO
ENRENR-1263982026-06-16T23:37:19ZBOBBYS.·BUTLER2008-11-09uhc-08110-05•••-••-5846+1 894 210 3066—7923 Ridge RdFresnoCA·93705GRP-5902SELECT-EPO
ENRENR-1077222026-02-24T05:24:42ZHANNAHOGREEN1948-01-05UHC-70477-31•••-••-7174(357) 908-8492HANNAH.GREEN80@HOTMAIL.COM7494 Washington StLas VegasNV89155GRP-8466select-epo
ENRENR-121739 2026-04-15T09:31:45ZBrendaPRobinson··11/23/1946UHC-07985-13•••-••-3371341-444-4166·brenda.robinson57@proton.me8740 Sunset BoulevardNashvilleTN37205-0740GRP-5717OPTIONS-PPO
ENRENR-1327362026-08-04T10:41:28ZBARBARATFOX··1959-06-27UHC-10850-41•••-••-3455397-611-4044BARBARA.FOX68@OUTLOOK.COM···572 Canyon RdGILBERTAZ85241-4671GRP-6579MEDICARE-ADV-B
ENRENR-1154012026-07-26T01:08:00ZJeanX.·OrtegaOct 3, 2006UHC-95506-88•••-••-38382795838175JEAN.ORTEGA33@GMAIL.COM·7042 Highland AveCharlotteNC28295GRP-7946MEDICARE-ADV-A
ENRENR-1184252026-03-20T23:22:01ZMichaelOGibson1986-02-27UHC-01677-55•••-••-6650+1 815 737 9451NULL6105 MAIN STLos AngelesCA90079-4227GRP-8153NAVIGATE-HMO
ENRENR-1242032026-05-11T00:40:53ZDavdiM.Larson19860427UHC9445768•••-••-8023504-479-6623······5735 Valley View DriveHoustonTX77007GRP-8907MEDICARE-ADV-B
ENRENR-1176222026-03-20T21:49:18Zdenise—hunt··1964-04-04UHC-54373-43—604-776-9470N/A2063 PALM DRSacramentoCalifornia95838GRP-3418CORE-HMO
ENRENR-1097302026-02-21T11:51:04ZMattX.ValdezJun 14, 2002UHC-71925-83•••-••-2073912-798-1519MATTHEW.VALDEZ@HOTMAIL.COM4853 Maple AveLas VegasNV··—GRP-8572MEDICARE-ADV-B
ENRENR-122573 2026-03-11T03:43:20ZMariaTHansen19770811UHC-09268-60•••-••-6509·UNKNOWNMARIA.HANSEN41@OUTLOOK.COM7203 CENTRAL AVENUELos AngelesCA·90080GRP-8920SELECT-EPO
ENRENR-1078452026-08-30T12:51:16ZVICTORIA—LUNA1947-05-10UHC-75189-78•••-••-7924-VICTORIA.LUNA84@OUTLOOK.COM7581 Willow CourtMesaArizona85298··GRP-6912NAVIGATE-HMO
ENRENR-1373502026-02-19T22:22:17ZGARYS·WATKINS1952-02-13UHC-53844-08•••-••-8045610.492.3695—1472 UNION STSAN DIEGOCA92107·GRP-7007OPTIONS-PPO
ENRENR-1240252026-06-25T02:31:31ZBrendaUSoto1938-11-18UHC-22397-55NULL644-539-6041—508 FOREST AVENUEMiamiFL33158·GRP-4892OPTIONS-PPO
ENRENR-1177452026-09-20T01:09:55ZAshleeyAArnold17-12-1960UHC-00958-18null860-969-3955ashley.arnold35@aol.com5208 Baseline Rd·SacramentoCA95816GRP-7183··OPTIONS-PPO
ENRENR-1229552026-06-09T23:34:16ZANGELAAMARTIN2006-02-23UHC-26771-60—563-227-4890angela.martin@hotmail.com3353 Ridge RoadTucsonAZ85795GRP-8933·MEDICARE-ADV-A
ENRENR-1357082026-01-18T20:28:13ZERIC—COLEMAN11/17/1984UHC-48581-76—631.515.6790·ERIC.COLEMAN@PROTON.ME6859 Maple AvenueTAMPAFL33605·GRP-9102·NAVIGATE-HMO
ENRENR-1121842026-08-11T06:11:44ZnicholasLgomez1968-02-09UHC7496712•••-••-2694(479) 373-0345—5772 Mesa Drive·PHOENIXAZ·85078GRP-1219MEDICARE-ADV-B
ENRENR-1163042026-04-12T05:53:29ZStephannie—Chavez1967-06-19UHC-51901-51•••-••-0620492-564-5552··null1655 Indian School RoadPhoenixAZ85056·GRP-9159OPTIONS-PPO
ENRENR-1412372026-06-15T00:16:37ZChristineZDixon8/18/1964··UHC-34283-65•••-••-1141851.248.9796—361 Mountain View DrSan AntonioTXN/AGRP-1215CORE-HMO··
ENRENR-1103022026-02-22T09:41:18ZBradley—YnagDec 4, 1947UHC-57865-36•••-••-7166·856-555-3595bradley.yang@icloud.com··7749 Indian School RdDallasTX75265GRP-9817CORE-HMO
ENRENR-1137652026-08-03T16:13:44ZLuis—Martin1991-12-04UHC-72576-75•••-••-8361635-800-5856luis.martin27@gmail.com8396 VALLEY VIEW DRLos AngelesCA90032GRP-4017SELECT-EPO
ENRENR-1215442026-06-22T17:48:23ZPatel, Gloria——1938-09-05UHC-83726-88•••-••-63803995084680gloria.patel52@proton.me5439 CHURCH STREETDALLASTX75238GRP-0606·CHOICE-PLUS-PPO
ENRENR-1267692026-09-18T21:42:17ZDENNISM··COLE1950-01-09UHC-96366-62•••-••-51437509248916dennis.cole@outlook.com4920 Pine DrivePhoenixAZNULL·GRP-7823NAVIGATE-HMO
ENRENR-1042282026-07-16T06:14:20ZJustinNJenkins·09/21/59UHC-42783-82•••-••-0014962-422-2395justin.jenkins@outlook.comNULL—-—GRP-1957SELECT-EPO
ENRENR-1261162026-06-20T14:01:51ZTERESA—DIXON04/03/1970UHC-78294-80•••-••-8404(703) 945-6181·-5177 Camelback RoadDallasTX75270GRP-9967MEDICARE-ADV-A
ENRENR-1340992026-09-21T06:34:39ZCARLOS—ESTRADA14-05-1969UHC-95033-99··NULL(748) 800-0987carlos.estrada85@hotmail.com4195 OCEAN AVEDenverCO80281GRP-5179CHOICE-PLUS-PPO
ENRENR-1012282026-05-18T03:02:23ZPETERU.CARTER1999-02-24UHC-21483-29•••-••-6041598-254-7530PETER.CARTER@AOL.COM8215 Market StreetFresnoCA93755GRP-5468MEDICARE-ADV-A
ENRENR-1039202026-07-27T02:25:56ZrayElewis19490121UHC-00572-26NULL536.590.7879—561 PINE DRJacksonvilleFL32266··GRP-5396CHOICE-PLUS-PPO
ENRENR-1052402026-01-26T03:58:17ZMei—Hoffman1993-10-01UHC-87074-86•••-••-423514266159236-3347 River RoadMiamiFL33193GRP-1695MEDICARE-ADV-A
ENRENR-1260072026-07-26T12:38:07ZTerryWRojas·1983-04-10·UHC-70197-41NULL6077968128terry.rojas@gmail.com··8350 WILLOW CTTucson·AZ85706GRP-5232CHOICE-PLUS-PPO
ENRENR-1427212026-10-09T10:37:26ZDOUGLAS··J.MATTHEWS02-04-1967UHC-06439-58UNKNOWN···466-342-3750·douglas.matthews83@outlook.com1698 Lake View RoadAtlantaGA30395GRP-5362CHOICE-PLUS-PPO
ENRENR-1273222026-04-26T10:30:03ZBenjamin—Gibson1990-11-28UHC-15397-39•••-••-7402571-719-8351benjamin.gibson15@gmail.com··559 Canyon RoadCOLUMBUSOH43281GRP-4421NAVIGATE-HMO
ENRENR-1186262026-05-14T19:54:54ZOMAREALVARADO1980-04-10UHC7611774··•••-••-66577033342947··—4305 HIGHLAND AVEChandlerAZ—GRP-0789MEDICARE-ADV-A
ENRENR-1415422026-06-07T01:08:44Z·SofiaH—nullUHC-21371-17—470-634-6089·sofia.scott74@aol.com6149 Cedar LaneEden PrairieMN55365GRP-6002MEDICARE-ADV-B
43,101 rows, page 222 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:40.600Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty