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-1018892026-07-24T22:03:54ZAmandaBMashall1952-06-22uhc-03865-31··UNKNOWN4022435amanda.marshall66@proton.me1064 Ocean AveGilbertAZ85283GRP-7146CORE-HMO
ENRENR-1127812026-03-31T23:19:51ZJoshua·I·Howell11/6/1972UHC-65629-91UNKNOWN··769.961.8385N/A927 Indian School RoadAustinTX·78794GRP-5613NAVIGATE-HMO
ENRENR-1319322026-07-04T19:40:34ZBrittany—Arnold1976-06-20UHC-79114-26null+1 639 387 4304brittany.arnold59@icloud.com2061 Apache BlvdNASHVILLE·TN37254GRP-3088CHOICE-PLUS-PPO
ENRENR-1042912026-06-08T02:54:11ZLucia···D.Simmons1969-02-21UHC2135972•••-••-9440439-930-2121LUCIA.SIMMONS@GMAIL.COM5160 PARK PLACEFRESNO··CA93748GRP-4601CORE-HMO
ENRENR-1239662026-05-06T15:57:33ZNOAH—GUTIERREZ12/01/05UHC-54159-41•••-••-0934257.670.7157NOAH.GUTIERREZ9@GMAIL.COM179 MEADOW LANEMIAMIFL33101GRP-3468MEDICARE-ADV-A
ENRENR-1313792026-03-20T10:44:30ZFrank—Richards06/28/1983UHC-92254-86··•••-••-8026383-485-0609frank.richards74@proton.me7748 MEADOW LANEJacksonvilleFL·32201GRP-2957CORE-HMO
ENRENR-1425902026-09-23T13:14:11ZJOAN—CHEN·1996-03-24UHC-37022-11•••-••-8985413-846-2946joan.chen66@proton.me7676 Baseline RdLas VegasNV89105GRP-0495MEDICARE-ADV-B
ENRENR-1419172026-03-03T14:24:39ZEvelyn··OYuung2006-09-15UHC-11134-42··•••-••-5455+1 374 784 7570evelyn.young@aol.com6805 MESA DRGilbertAZ85221GRP-8242SELECT-EPO
ENRENR-1329152026-03-05T01:40:59ZSTEVENKCOLEMAN1943-09-27UHC-69122-85•••-••-3465899.389.2300—4640 Ocean Ave·MesaAZ··85230GRP-3256NAVIGATE-HMO
ENRENR-1397192026-07-30T03:23:22ZStevenMGriffin2008-09-14UHC-95954-44•••-••-84493052350920steven.griffin@outlook.com1826 CENTRAL AVENUESacramentoCA—GRP-1766·CHOICE-PLUS-PPO
ENR ENR-1329442026-05-14T19:15:27ZKennethZ—1959-11-07UHC-22177-86•••-••-2979856-642-9593kenneth.jones65@yahoo.com9138 Valley View DrSeattleWA98130GRP-5033CHOICE-PLUS-PPO
ENRENR-1231152026-02-19T21:51:03Z Russell—·Moreno2005-07-27UHC0849611··•••-••-12298428694390N/A8906 BROADWAYPlanoTX75023GRP-3583··OPTIONS-PPO
ENRENR-1137772026-05-19T22:46:04ZIsabella—Ramirez··06/23/03UHC-93692-17•••-••-2973N/AISABELLA.RAMIREZ63@AOL.COM3355 ELM STMinneapolisMN55479GRP-2809·MEDICARE-ADV-B
ENRENR-1286442026-01-20T13:44:51Z·AustinYPorter1973-04-05UHC-87313-40•••-••-7955619-648-4977AUSTIN.PORTER@OUTLOOK.COM690 Valley View DriveOrlando·FL32894GRP-5465CORE-HMO
ENRENR-1174602026-10-06T18:33:25Z———1950-04-26UHC-72427-35•••-••-7888(466) 449-2461joe.carlson22@hotmail.com6655 Elm StATLANTAGA··30393GRP-0856··core-hmo
ENRENR-1143232026-08-08T17:31:39ZDylan—Pierce1972-03-12UHC-67960-13•••-••-1830(295) 684-2249dylan.pierce@proton.me9281 APACHE BLVDLas VegasNV89140GRP-8452SELECT-EPO
ENRENR-1299182026-06-04T05:33:43ZCharlotteNHanson·1963-05-10UHC6446142•••-••-513517994257241charlotte.hanson95@gmail.com1822 MOUNTAIN VIEW DRIVECHARLOTTENC28272GRP-9340MEDICARE-ADV-A
ENRENR-1236192026-09-07T03:53:49ZANNR.LONG1953-05-23·UHC-06317-61•••-••-3709+1 801 719 1931ANN.LONG@ICLOUD.COM2571 Camelback Road··HoustonTexas77034GRP-8283MEDICARE-ADV-B
ENRENR-100961 2026-01-22T20:12:33ZMARKGHICKS1942-08-10UHC-78075-81•••-••-3903+1 755 510 4467mark.hicks79@icloud.com9003 GRAND AVENUENashvilleTN·37240-0465GRP-2813CHOICE-PLUS-PPO
ENRENR-1288082026-01-16T11:39:31ZALICEI.FISHER1971-01-16UHC-58981-64•••-••-73158202819100··alice.fisher@outlook.com5584 Forest AveTampaFlorida33652GRP-5652OPTIONS-PPO
ENRENR-1165742026-08-06T18:47:45ZVega, MaryX··—1986-12-03UHC-73241-94•••-••-2771277-353-8469mary.vega@hotmail.com··7441 Jefferson AveLOS ANGELESCA90059GRP-5873MEDICARE-ADV-A
ENRENR-1153512026-02-04T10:03:47ZJulie··Johnson1971-12-09·UHC-66669-36•••-••-144118043858243JULIE.JOHNSON@AOL.COM4699 SUNSET BOULEVARDHouston·TX77023GRP-2074core-hmo
ENRENR-1045212026-09-03T09:11:36ZNICOLE—LUCAS1989-08-13UHC-38295-18null··UNKNOWN—1029 ELM STREETEden PrairieMN55345GRP-3868CORE-HMO
ENRENR-1242302026-04-13T21:56:50Z·Deborah—·Vargas1982-08-06UHC8333639•••-••-29336229138079deborah.vargas97@hotmail.com1445 Bayshore DrCharlotteNC28287··GRP-1009CORE-HMO
ENRENR-1268602026-05-09T07:11:27ZSAMANTHAP··HAWKINS1964-06-19··UHC-88855-86•••-••-2664(407) 934-8722SAMANTHA.HAWKINS@HOTMAIL.COM3752 Grand AvenueTEMPEAZ85247GRP-6330NAVIGATE-HMO
ENRENR-104559 2026-01-09T21:47:21ZLisa··—Griffin1941-09-27··UHC-64792-99•••-••-5150793.302.2674UNKNOWN1440 Elm StreetJACKSONVILLEFL32291···GRP-8609OPTIONS-PPO
ENRENR-1041742026-02-12T09:54:44ZElizabeth—Bowman1940-12-09UHC-88810-12NULL··9216537911null6864 HIGHLAND AVENUESan AntonioTX78287GRP-9118MEDICARE-ADV-A
ENRENR-1081092026-02-16T01:33:34ZWalker, Nicole H——19731107UHC-98415-20•••-••-05278777034317-1256 Indian School Road #357AUSTINTX78715GRP-0838OPTIONS-PPO
ENRENR-105652 2026-07-14T02:58:59Z·Patrick—Singh1973-03-17UHC-86192-10•••-••-34676643233876—9324 CENTRAL AVETucsonAZ85771··GRP-1629··CORE-HMO
ENRENR-1105942026-02-14T11:13:06ZCamila—Griffin2002-02-22UHC-54579-08•••-••-4909(324) 382-8322camila.griffin@gmail.com6395 CANYON RDLas Vegasnv89121GRP-0926CHOICE-PLUS-PPO
ENRENR-1070332026-09-25T08:42:48ZCarolynT.Green1963-05-12UHC1256066•••-••-6658+1 693 638 0394··carolyn.green68@gmail.com2761 Main StSACRAMENTOCalifornia95874··GRP-9188··MEDICARE-ADV-A
ENRENR-1328292026-07-29T11:39:40ZWEI L—MEDINA1925-10-25UHC-05721-07•••-••-4526NULL—4780 Lake View RoadPlanotx75067GRP-0349OPTIONS-PPO
ENRENR-1141602026-06-06T23:29:34ZLittle, KathrynI··—1995-03-05UHC-44764-84•••-••-3045848-605-0713—7695 Park PlMIAMIFL33129GRP-5361··OPTIONS-PPO
ENRENR-1126532026-06-02T02:06:02ZEugeneE.Coleman1986-03-07uhc-85703-84•••-••-4827(508) 418-0342eugene.coleman7@aol.com8339 Sage CourtEden PrairieMN55315GRP-2467NAVIGATE-HMO
ENRENR-1134692026-09-02T07:17:06ZSTEVEN··ROGERS1984-08-23··UHC-57928-40•••-••-251715934662378steven.rogers@yahoo.com5940 Mesa DriveMinneapolisMN55434GRP-4229SELECT-EPO
ENRENR-1297452026-09-03T12:27:06ZEmilyT.Vasquez02/23/1965UHC-59355-08··•••-••-209319892379123—1316 Apache BoulevardOrlandoFL32817GRP-5926··choice-plus-ppo
ENRENR-1110522026-05-26T01:06:41Z·KatherineV.Johnson1982-09-20UHC-46421-57•••-••-3819916-822-3941—7762 Camelback RoadPlanoTX75022GRP-7859NAVIGATE-HMO
ENRENR-1141812026-01-01T14:18:42ZFatima—Baker1982-12-22UHC-98242-13•••-••-9601748-244-3393fatima.baker@proton.me·7973 APACHE BOULEVARDCHANDLERaz85289GRP-0142MEDICARE-ADV-B
ENRENR-1070052026-07-09T01:56:21ZAna—Bailey·1989-07-21UHC-50320-21•••-••-2474598.230.1903null3822 Lincoln WayHoustonTX77093GRP-3693CORE-HMO
ENRENR-1348592026-02-17T20:15:17ZNatalie··IReyes1963-03-17UHC2027868•••-••-8272(954) 660-6252natalie.reyes51@icloud.com1848 Willow CtSCOTTSDALEArizona85286GRP-7567choice-plus-ppo··
ENRENR-1083902026-08-16T14:32:26ZMargaret··Q.Marshall1960-09-25UHC-55401-63•••-••-1782·(756) 380-9209UNKNOWN420 FOREST AVENUEMinneapolisMNNULL··GRP-9366MEDICARE-ADV-A
ENRENR-1196462026-04-20T11:09:43Z Eric—Valdez1939-11-25UHC-86362-98•••-••-1488912-637-5845··eric.valdez75@proton.me9341 BROADWAY #258Eden Prairiemn55375GRP-3276NAVIGATE-HMO
ENRENR-1287122026-05-21T05:18:35Z Wood—Kathleen1968-12-28UHC-04145-86•••-••-064612228626696N/A1573 HILLCREST ROADDallasTX75295GRP-3549SELECT-EPO
ENRENR-1034132026-01-14T19:07:18ZNATHANM.MCCOY1970-12-06UHC-35142-11•••-••-05578263455424null77 Sunset BoulevardTAMPAFL·33686GRP-1872medicare-adv-a
ENRENR-1402802026-09-15T01:18:26ZWood, JessicaV—2004-05-24UHC-42569-57•••-••-0147559-634-2608NULL3017 CAMELBACK RDScottsdaleArizona85270GRP-2590OPTIONS-PPO
ENRENR-1202112026-10-09T01:42:49ZSaraY.Carter1968-05-03UHC-10224-44··•••-••-774312378449565sara.carter@hotmail.com8769 Cedar LaneGilbertAZ85200GRP-5701MEDICARE-ADV-A
ENRENR-1196362026-05-05T22:52:58ZJESSICAU.CUNNINGHAM04-09-1978UHC-94194-72··•••-••-29364277057006·jessica.cunningham@gmail.com6160 CENTRAL AVENUEPHOENIXAZ85047GRP-7902CORE-HMO
ENRENR-1200172026-04-08T17:26:41ZArthurKMorgan2000-10-03·UHC-25116-10null510-957-3797UNKNOWN773 SUNSET BOULEVARDLos Angelesca90005-2355GRP-9123CHOICE-PLUS-PPO
ENRENR-1396282026-09-27T11:51:36ZNANCY—PATELJul 10, 1973UHC-46379-42•••-••-8203—NANCY.PATEL67@ICLOUD.COM6370 Mesa Dr··San Antoniotx78209GRP-5232CORE-HMO
ENRENR-1423362026-02-01T17:07:36ZKatherine—Kelly1938-08-01UHC1341579•••-••-1509869-559-2521katherine.kelly67@icloud.com5787 Camelback RdTempeAZ85261GRP-5082··MEDICARE-ADV-B
43,101 rows, page 190 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.327Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty