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-1002332026-01-10T18:18:54ZMARCUS—SCHMIDT2006-12-12UHC-74913-88•••-••-8405699-732-8017··marcus.schmidt48@icloud.com1781 Apache BlvdDallasTexas75246-1238·GRP-2994choice-plus-ppo
ENRENR-1281602026-03-03T06:58:10Z MRATHA—GRIFFIN1962-01-22UHC-27032-07•••-••-9679—martha.griffin76@yahoo.com3725 Main StreetMesaAZ85276-9210GRP-8714CORE-HMO
ENR ENR-1110962026-08-08T01:48:49Z·RandyTFisher1946-10-27UHC-12537-46—NULLRANDY.FISHER80@YAHOO.COM4312 Sage CtMinneapolisMNN/AGRP-1703MEDICARE-ADV-B
ENRENR-1301772026-05-17T17:48:56Z·HELEN—DAY24-11-1940UHC-89044-18•••-••-98773908666607helen.day@gmail.com8355 MEADOW LANENashvilleTN37220GRP-9222CHOICE-PLUS-PPO··
ENRENR-1261632026-04-10T20:20:22ZRandy—Crawford··1957-05-16UHC-69743-66•••-••-42384052859randy.crawford3@proton.me8004 Sunset BlvdAustinTX—GRP-0343··OPTIONS-PPO
ENRENR-1008512026-10-06T20:09:55ZBrianWHughes1973-09-07UHC7486618•••-••-2222467.889.8577UNKNOWN2261 Mesa Dr #130DallasTX75287GRP-7924medicare-adv-a
ENRENR-1189992026-01-05T14:40:36ZElijahOFlores03-01-1958UHC7589970•••-••-73158964903416NULL5650 Central AvePlanoTX75012GRP-3929NAVIGATE-HMO
ENRENR-1307422026-01-05T06:30:57ZSpencer, Edward——1965-03-02UHC-21630-91•••-••-2842754-469-2371EDWARD.SPENCER@ICLOUD.COM2549 Apache BlvdMinneapolisMN55426GRP-2868OPTIONS-PPO
ENRENR-1372572026-09-20T06:24:44ZCastillo, Heather··——·18-03-1970UHC-37392-76•••-••-9713·3729536856HEATHER.CASTILLO@HOTMAIL.COM6411 MAIN STSCOTTSDALE·AZ85255··GRP-1696MEDICARE-ADV-A
ENRENR-1047372026-06-19T16:01:00ZCamila··GBennett1948-01-16UHC-13764-67•••-••-5842(551) 785-6968CAMILA.BENNETT58@AOL.COM5995 Ridge RoadDenverCO80242GRP-9483OPTIONS-PPO
ENR ENR-1224502026-01-22T21:58:57ZSTEVENS.·POWELL·1961-12-11UHC-96214-99•••-••-7390+1 704 621 8707steven.powell@aol.com2384 Mountain View DriveAtlantaGA30336GRP-8037NAVIGATE-HMO
ENRENR-1220662026-05-13T02:01:05ZCarlosDYang·12/09/1943UHC-74210-27•••-••-504713883967231carlos.yang@aol.com3892 Lake View RdScottsdaleAZ85207GRP-7211MEDICARE-ADV-B
ENRENR-1414972026-07-08T11:39:25ZLAURAJNICHOLS-uhc-18482-51•••-••-62355193302410laura.nichols@aol.com6981 Willow CtDenverCO80281GRP-0341··OPTIONS-PPO
ENRENR-1115242026-04-10T09:53:03ZFranklin, Sandra——10/6/1938UHC-51432-41—832-297-7462·sandra.franklin@icloud.com·3855 Oak StFresnoCA93752GRP-7675medicare-adv-a
ENRENR-1232302026-05-26T01:48:28ZKatherineY.Perry3/27/1959UHC-19069-50•••-••-7141(774) 925-0018KATHERINE.PERRY@ICLOUD.COM5610 Sage CourtFresnoCA93713GRP-0999SELECT-EPO
ENRENR-1087342026-07-07T09:19:12ZNoah—Nguyen1976-10-23UHC-84004-09•••-••-9401(962) 394-9341UNKNOWN2884 Lake View RdGilbert··AZ85245GRP-7530CHOICE-PLUS-PPO
ENRENR-1104502026-01-24T02:27:17Z TOHMAS—JENKINS1997-01-19UHC-82945-36•••-••-8522(858) 340-1370THOMAS.JENKINS52@AOL.COM6365 OAK STDenverCO80235GRP-8419MEDICARE-ADV-B
ENRENR-1368432026-07-18T18:28:43ZDeborahYFox19820604UHC-40257-90•••-••-49834632238876—3808 Highland Avenue··HoustonTX77059GRP-3223MEDICARE-ADV-A
ENRENR-116345 2026-06-03T03:17:46ZAmandaDSchmidt1994-04-21UHC-60957-45UNKNOWN(445) 380-3209amanda.schmidt4@gmail.com··768 Oak StJACKSONVILLEFL32215-8243GRP-8425OPTIONS-PPO
ENRENR-1392152026-01-05T15:50:24ZFrank·H.Johnson1975-03-06UHC-56150-34•••-••-1500(656) 613-2714FRANK.JOHNSON99@OUTLOOK.COM925 Spring St··GILBERTArizona85274GRP-3614SELECT-EPO
ENRENR-1286722026-06-01T07:11:39ZELIJAH—MEDINA02/09/52UHC-63153-94•••-••-8382977-834-4616··elijah.medina@gmail.com8286 BAYSHORE DRIVEColumbusOH43267GRP-5257OPTIONS-PPO
ENRENR-1153882026-07-09T07:30:33ZMARK—MURRAY1982-01-24UHC-91730-92•••-••-6406UNKNOWNmark.murray@icloud.com·3268 MEADOW LANEJacksonvilleFL32202GRP-5675CORE-HMO
ENRENR-1318072026-07-02T20:22:03ZTHOMAS—GRAHAM·1984-09-21UHC-00491-82—4183807798thomas.graham24@icloud.com·2092 Sage CourtTucsonAZ85779GRP-1117MEDICARE-ADV-B
ENRENR-1172872026-09-12T08:02:29ZLuis—Herrera4/1/1979UHC-39380-74•••-••-1489279.376.8068··—1179 CEDAR LANE·OrlandoFL32876GRP-7558MEDICARE-ADV-A
ENRENR-1142242026-04-01T15:33:31ZBRUCEV.LITTLE1941-07-05UHC-76002-34··NULL(751) 260-8776BRUCE.LITTLE@HOTMAIL.COM2833 Sunset BoulevardSan DiegoCA92115GRP-4953·SELECT-EPO
ENRENR-1424162026-08-11T08:53:57ZWatson, JerryY.··04/17/1983··UHC8220873•••-••-2761(683) 382-1024jerry.watson20@hotmail.com7251 GRAND AVESacramentoCA95840GRP-8759SELECT-EPO
ENRENR-1284662026-08-29T05:58:13Zaamnda—williamson19761206UHC-93564-15—(538) 685-7122N/A6312 Market StFresnoCA93759·GRP-4207OPTIONS-PPO
ENRENR-1075722026-08-20T07:36:36ZjoeAhamilton2003-10-17UHC-71097-95•••-••-2617(233) 584-9051··—9027 Central AveSacramentoCalifornia95813GRP-1607SELECT-EPO
ENRENR-1170282026-04-30T15:55:36ZDylan····RossFeb 11, 1942UHC-47131-54•••-••-16505644987844—8779 Forest AvenueOrlandoFL32869GRP-7137MEDICARE-ADV-B
ENRENR-1321862026-03-04T17:19:33Z·Charles—Griffin2003-10-08UHC-79368-12•••-••-29653085847986NULL6431 Oak StEden PrairieMN55384GRP-9778choice-plus-ppo
ENRENR-1295772026-01-15T12:21:49ZGABRIEL—·COX1994-08-17UHC-26477-54•••-••-5667nullNULL··3550 Willow CtScottsdaleAZ85217·GRP-4913MEDICARE-ADV-B
ENRENR-1261212026-07-08T08:39:19ZAdamOHughes1974-04-05··UHC-67149-60•••-••-1534(757) 225-3575—·4667 SUNSET BLVDSacramentoCA95821··GRP-6894MEDICARE-ADV-A
ENRENR-1409732026-09-09T07:14:48Z·WAYNEVROMERO1945-03-26UHC-14479-29•••-••-3504(446) 786-8191wayne.romero@gmail.com7933 MAPLE AVENUESeattleWA98153-5946GRP-9095SELECT-EPO
ENR ENR-1378072026-05-27T20:17:52ZKeith—Miller1959-07-13UHC-21541-75•••-••-4655(507) 212-7474keith.miller75@icloud.com355 Meadow LnMiamiFL·33125GRP-3658MEDICARE-ADV-A
ENRENR-1112862026-02-07T15:06:13ZCARLOS—TAYLOR1960-11-05UHC-54687-87—2273350001carlos.taylor@gmail.com5964 Sage CtColumbusOH43271GRP-7150MEDICARE-ADV-A
ENRENR-1107902026-06-01T01:45:02ZcherylV.herrera1975-09-06UHC-59021-38•••-••-1650+1 950 768 2078cheryl.herrera@gmail.com·505 ELM STTucsonAZ85736GRP-8768NAVIGATE-HMO
ENRENR-108508 2026-01-31T14:06:59ZVirginiaNGreene2005-06-22UHC-49687-56•••-••-3329(265) 552-4091virginia.greene70@proton.me4747 Willow CtSan DiegoCA92152GRP-8981CHOICE-PLUS-PPO
ENRENR-120513 2026-01-13T04:36:42ZOliviaKPerez1963-04-16UHC-08021-88•••-••-5557(559) 640-2012olivia.perez56@yahoo.com1737 UNION STTampaFL33689GRP-4040MEDICARE-ADV-A
ENRENR-1025042026-03-16T20:37:26ZEmma—Munoz09/16/94UHC8241281•••-••-4078+1 314 528 3398EMMA.MUNOZ50@PROTON.ME2062 Jefferson AvenueDallasTX75213·GRP-7047·MEDICARE-ADV-B
ENRENR-1234032026-01-29T05:02:13ZWalter—Chavez1994-05-07UHC-49446-32—3416809590null7980 Maple Ave Apt 22Austintx·78761GRP-5337MEDICARE-ADV-B··
ENRENR-1268432026-10-12T19:37:28ZSandra—JacksonMay 16, 2003·UHC-07540-32•••-••-3737786-913-3115sandra.jackson64@yahoo.com531 Church StreetCHANDLERArizona85266··GRP-4024CHOICE-PLUS-PPO
ENRENR-1273082026-10-16T21:53:12ZDianeCOBrien2004-05-21UHC-76312-12•••-••-8344880.432.8328N/A3706 Highland AvenueDenverCO80241GRP-9078NAVIGATE-HMO
ENRENR-1426732026-07-04T10:07:47Z·LAWRENCE—BUTLER1995-05-05·UHC-40416-62•••-••-6050·(436) 969-7675LAWRENCE.BUTLER87@GMAIL.COM5400 Meadow LnHOUSTONTX77020GRP-3326MEDICARE-ADV-B
ENRENR-1277882026-05-14T10:31:39ZjeremyB.nguyen1990-03-26UHC-03233-46•••-••-9406(628) 871-4833JEREMY.NGUYEN@AOL.COM5719 JEFFERSON AVENUEAtlantaGA30308GRP-1660OPTIONS-PPO
ENRENR-1196482026-02-28T00:41:50ZJESSICA—COOK2004-07-07UHC8410926NULL949-637-0799N/A2137 Camelback RoadGlendaleAZ85348GRP-5298MEDICARE-ADV-A
ENRENR-1265982026-08-12T01:46:49ZMeyer, TheresaD—Feb 18, 1970·UHC-06837-05•••-••-8114627-737-6605theresa.meyer42@aol.com1228 Apache BoulevardMesaAZ85265GRP-1255OPTIONS-PPO
ENRENR-1092202026-05-19T12:03:37ZSofia····Kim02/04/07UHC-90210-54•••-••-930815972403708UNKNOWN8467 ELM STREETGilbertAZ85257GRP-7761CORE-HMO
ENRENR-1414592026-09-05T05:01:52ZDaniel—Walker1967-04-27UHC-12416-79•••-••-96733419170507DANIEL.WALKER@ICLOUD.COM770 INDIAN SCHOOL ROADGlendale··AZ··85305··GRP-8429CHOICE-PLUS-PPO
ENRENR-1152742026-06-27T18:54:26Z·Espinoza, AndreaA—10/20/1995UHC-38500-61•••-••-883218248033190andrea.espinoza@aol.com4990 Church Street Apt 14Eden PrairieMN55312GRP-2114MEDICARE-ADV-A
ENRENR-1109982026-08-14T07:28:18ZGaryQ.West17-01-1998UHC-19798-12•••-••-65309816612400gary.west45@aol.com6358 OCEAN AVENUEColumbusOH43278GRP-4927SELECT-EPO
43,101 rows, page 150 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:38.475Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty