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-1111792026-03-24T05:49:10ZSahron—Maldonado1972-08-13UHC-56381-23•••-••-5924773-213-8422sharon.maldonado@hotmail.com3759 MAPLE AVENUEMESAAZ·85281GRP-4100select-epo
ENRENR-1429162026-06-11T10:20:16ZBRUCE—TRAN06/10/39·UHC-11511-51•••-••-4714··null·8766 APACHE BOULEVARDOrlandoFL32876-6267GRP-6492navigate-hmo
ENR ENR-1038682026-02-22T04:51:01ZGaryHCook01-06-1970UHC-97450-56•••-••-8790(561) 533-5122gary.cook49@yahoo.com6769 Central AveLas Vegas·NV89148··GRP-2375CHOICE-PLUS-PPO
ENRENR-1359882026-10-16T19:31:50ZSandraOLawson1983-01-01··UHC-77625-31•••-••-51165868776N/A8404 HILLCREST ROAD·TampaFL33640GRP-3348NAVIGATE-HMO
ENRENR-1248642026-08-05T16:42:34ZwillieF.··ray1961-09-01UHC4942170•••-••-14038155422264UNKNOWN··271 VALLEY VIEW DRLas VegasNV89109GRP-6777MEDICARE-ADV-B
ENRENR-1210612026-03-03T11:49:38ZAustinHStevens06/14/1960UHC-43550-76•••-••-450715567049968austin.stevens@hotmail.com2950 SPRING STREET Apt 26MesaAZ85268GRP-2237MEDICARE-ADV-A
ENRENR-1077302026-02-23T19:49:30ZTheresa—Ray1969-11-13···uhc-50362-61•••-••-39579468395360THERESA.RAY78@GMAIL.COM5206 Ridge RoadFresnoCA93720-7161GRP-5813··MEDICARE-ADV-B
ENRENR-1164442026-03-19T18:04:30ZNguyeen, HenryM—1975-07-18UHC-89598-34•••-••-7626492-562-8011henry.nguyen@icloud.com3106 PALM DRIVECOLUMBUSOH43272GRP-6040MEDICARE-ADV-A
ENRENR-1216512026-01-29T20:36:33ZWeaver, Anthony——1999-03-14UHC-71437-69•••-••-5742(747) 518-9556ANTHONY.WEAVER88@OUTLOOK.COMnull———GRP-4879·SELECT-EPO
ENR ENR-1413962026-02-13T14:03:30ZBurke, SttephenW.—1989-09-17UHC2132033•••-••-1504(257) 219-3509STEPHEN.BURKE67@YAHOO.COM··4464 Broadway·AustinTX78750GRP-9454MEDICARE-ADV-A
ENRENR-1256712026-03-17T01:34:02ZGloria—Freeman2000-11-03UHC-15237-23•••-••-3297620-357-2970GLORIA.FREEMAN@ICLOUD.COM823 SAGE CT··SacramentoCalifornia95869GRP-2845CHOICE-PLUS-PPO
ENRENR-1039042026-09-24T19:12:46ZLaurenZAlexander1980-09-18UHC-35766-20•••-••-53507678207593·lauren.alexander29@yahoo.com1352 Grand AveDENVERCO80297GRP-5675NAVIGATE-HMO
ENRENR-1011982026-01-26T18:28:36ZRuthO.Jones1980-04-22UHC-52748-04•••-••-47013646761837··ruth.jones@yahoo.com4009 Oak St Apt 21San DiegoCA92152GRP-3985OPTIONS-PPO
ENRENR-1139392026-08-13T15:41:35ZCynthia—Ryan1948-04-19UHC-86329-70•••-••-7733(814) 733-6786·null1187 Broadway··San AntonioTX78200GRP-9616CHOICE-PLUS-PPO
ENRENR-1274932026-07-20T07:06:59ZSTEVENVDIAZ1974-01-14UHC-29613-87•••-••-08578534457097steven.diaz41@icloud.com·7108 RIVER RDGlendaleArizona85316GRP-5284CHOICE-PLUS-PPO
ENRENR-1285912026-06-12T02:33:21ZDIANE·S·HENRY03-02-1975UHC-12386-62•••-••-4661276-907-7913diane.henry@outlook.com··2927 Ridge RoadChandler···AZ85268GRP-8773CORE-HMO
ENRENR-1372192026-08-23T22:38:04ZScott—Kelley1995-07-25UHC-50527-90•••-••-25507095904912scott.kelley80@gmail.com9189 Canyon RoadSeattleWA98100-4101GRP-6641CHOICE-PLUS-PPO
ENRENR-1198612026-07-22T16:08:35ZJasonOGeorge1962-08-07UHC5153902•••-••-5972(441) 302-8287jason.george@yahoo.com3636 Jefferson AveAtlantaGAN/AGRP-7131MEDICARE-ADV-A
ENRENR-1209172026-01-13T18:13:40ZLuna, MeiS—7/22/1959UHC-88565-33··3703387982null6214 Pine DriveDallasTX-GRP-6420CHOICE-PLUS-PPO
ENRENR-1394782026-05-22T18:20:44ZjeanOnelson09/12/87UHC-20738-64•••-••-3741494.731.1148jean.nelson@gmail.com5776 RIDGE ROADCharlotteNC28236GRP-3021··CHOICE-PLUS-PPO
ENRENR-113654 2026-08-24T08:25:53ZELIJAHAWASHINGTON1979-09-07·UHC-16414-38•••-••-6475(988) 623-0862—959 Mesa DrAustinTX78748GRP-1253·OPTIONS-PPO
ENRENR-1195022026-03-21T21:50:04ZReid, Ronald·X—Sep 11, 1978UHC-15374-37•••-••-2876(880) 794-9813ronald.reid@yahoo.com··3966 Mountain View DrAustinTX78799GRP-9974NAVIGATE-HMO
ENRENR-1092912026-04-13T03:13:41ZVincent—Garza10/18/2001UHC-71824-31··•••-••-3628-null9084 Jefferson AvenuePHOENIXAZ85084GRP-8358core-hmo
ENRENR-1422302026-05-10T11:22:07ZBenjamin—Cooper1968-06-14UHC-69545-33•••-••-399214894411550UNKNOWN5419 Market StreetHOUSTONTX77041GRP-2790MEDICARE-ADV-B
ENRENR-1050372026-04-20T01:27:01ZJULIES.MORGAN1969-02-27UHC-84290-64UNKNOWN-JULIE.MORGAN73@AOL.COM7947 Sage CtGILBERTAZ··85290GRP-7532CORE-HMO
ENRENR-1252992026-04-27T12:05:50ZBishop, CynthiaZ.—·1962-06-21UHC-36612-67•••-••-14316556477092CYNTHIA.BISHOP18@YAHOO.COM4621 PALM DROrlandoFL32872-1431GRP-3681··CHOICE-PLUS-PPO
ENRENR-1347532026-01-16T21:19:50ZCollins, GaryG—1978-09-17UHC-03313-76•••-••-53733428991081gary.collins@proton.me3518 Mountain View DriveLos AngelesCA90037·GRP-2549SELECT-EPO
ENR ENR-1194482026-07-18T12:07:52ZOlivia—Ruuiz1961-01-18UHC-84232-34•••-••-7921(719) 443-9614OLIVIA.RUIZ7@HOTMAIL.COM9419 Apache BlvdAUSTINTX78793GRP-8947NAVIGATE-HMO··
ENRENR-1176932026-05-20T08:18:31ZLoganXScott1966-09-13UHC-85408-43—·16964658702·LOGAN.SCOTT70@ICLOUD.COM3265 Jefferson Ave Apt 1Las VegasNV89182··GRP-2528MEDICARE-ADV-A
ENRENR-1279802026-04-01T09:04:36ZnicoleWdunn11/20/1987UHC-29283-47•••-••-2252930-359-9981UNKNOWN2594 Harbor BlvdCharlotte·NC28271-6659GRP-5656SELECT-EPO
ENRENR-1090642026-02-03T05:32:53ZLISA—HOWARD·2000-06-25UHC-49832-15null410-663-2404··5634 Market StCharlotteNC28296GRP-9728MEDICARE-ADV-B
ENRENR-1328002026-06-06T08:43:34ZJUDY—ESPINOZA1940-07-03UHC-18199-45•••-••-67836108541427judy.espinoza@proton.me4889 Cedar LaneLOS ANGELESCA90056GRP-1916MEDICARE-ADV-A
ENRENR-1401032026-08-02T23:40:39Z ·Moreno, BillZ.—03/16/63-•••-••-5167437.650.6275william.moreno29@gmail.com3740 Valley View DriveSeattle··WA98110GRP-6756OPTIONS-PPO
ENRENR-1006992026-01-22T15:39:37ZALEXIISK.SHAW·08-10-1948UHC-38210-31•••-••-3822(278) 983-0451UNKNOWN3733 Sage CtScottsdaleAZ85200GRP-1637CORE-HMO
ENRENR-1135632026-03-24T18:32:03ZbruceCmorris·01/18/1986UHC-33350-17•••-••-0992764.643.9587BRUCE.MORRIS@OUTLOOK.COM6865 Mesa DriveGILBERT·AZ85258-6666··GRP-4006MEDICARE-ADV-A
ENRENR-1398192026-08-03T04:20:43ZHelen Y—Murphy04/15/1940UHC-97173-05•••-••-7665—HELEN.MURPHY@YAHOO.COM8562 Apache BoulevardJacksonvilleFlorida32206-8361GRP-7794SELECT-EPO
ENRENR-1068282026-08-02T04:00:38ZRYANTWARREN17-09-1981UHC-88327-63•••-••-50148912743852ryan.warren@yahoo.com8565 Desert Sky BoulevardLAS VEGASNevada89165GRP-7660··SELECT-EPO
ENR ENR-1274992026-07-28T01:55:52ZMarilyn—Kelly1993-01-09UHC-08484-93•••-••-986613527415245null··2128 UNION STREETGilbertAZUNKNOWNGRP-0739··MEDICARE-ADV-B
ENRENR-1329282026-06-15T01:35:16ZTYLERR.HICKS1946-02-24UHC-11731-86•••-••-97637384852807TYLER.HICKS40@AOL.COM7491 HARBOR BOULEVARDATLANTAGA30388GRP-7316CORE-HMO
ENRENR-1014032026-09-07T01:47:04ZKye—Young03/28/1959UHC-00690-87•••-••-8362(592) 324-1672kyle.young43@yahoo.com6202 PARK PLACELos AngelesCA90038GRP-4357SELECT-EPO
ENRENR-1179222026-08-31T22:47:25ZVincent—Ruiz1975-11-21UHC-94110-47•••-••-3274(214) 857-9912—1151 Park PlSacramentoCA95854GRP-0337MEDICARE-ADV-A
ENRENR-1007292026-09-28T08:33:03ZRonaldHTaylor1953-01-20UHC-62526-56—555.442.5665ronald.taylor@icloud.com7164 Mesa DrJacksonvilleFL32277GRP-3096·MEDICARE-ADV-A
ENRENR-1337272026-09-05T04:45:09ZZACHARYUMORRIS1985-09-28UHC-13938-46•••-••-84028862801zachary.morris@yahoo.com6613 Pine Drive··FRESNOCalifornia93723GRP-5128CORE-HMO
ENRENR-1340192026-03-06T15:51:34ZMICHELLEY··JIMENEZ9/17/1994UHC-06168-30•••-••-0319—michelle.jimenez19@icloud.com5351 Hillcrest RdScottsdaleaz85255-3820GRP-1860NAVIGATE-HMO
ENRENR-1294492026-04-15T05:16:19ZSean—Gardner1964-07-20UHC-33476-72—-·SEAN.GARDNER50@PROTON.ME9447 Lake View RdSeattleWashington98112GRP-6869MEDICARE-ADV-B
ENRENR-1182902026-06-05T22:45:42ZVicky··PGriffin2008-12-19UHC-82877-44•••-••-3678455-931-3909·-1251 Lincoln WayTUCSONAZ85757GRP-6937NAVIGATE-HMO
ENRENR-1049562026-06-30T04:29:39ZAustin—Ryan1944-04-19UHC4110835•••-••-4326221-607-4536·austin.ryan22@proton.me8565 Market StMiamiFL33113·GRP-4440core-hmo
ENRENR-1134192026-10-08T11:31:34Z Marrilyn—Wells20-07-1949UHC-42043-20•••-••-1900234-372-6103·MARILYN.WELLS@AOL.COM6230 SUNSET BLVDLos Angeles·CA90034GRP-0225MEDICARE-ADV-B
ENRENR-1087222026-02-16T13:02:41ZPATRICIAANICHOLSUNKNOWNUHC-45310-42•••-••-1764(311) 619-6673UNKNOWN9725 Desert Sky BlvdEden PrairieMN55397GRP-3669OPTIONS-PPO
ENRENR-1319412026-04-02T09:35:48ZAHMEDXMEJA1950-08-22UHC-77938-49•••-••-7984662-841-9650ahmed.mejia37@icloud.com··8436 INDIAN SCHOOL RDSan Diego··CA·92198GRP-4488CHOICE-PLUS-PPO
43,101 rows, page 300 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.462Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty