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-1260812026-05-08T06:50:21ZFatimaWReed8/22/1985UHC-50785-10•••-••-736314962488328fatima.reed58@hotmail.com7651 Sage CtMINNEAPOLISMN—GRP-7414CHOICE-PLUS-PPO··
ENRENR-1249112026-02-25T01:53:17ZGregory—Cruz1940-06-04UHC-75910-07•••-••-982815699373495—9362 Mountain View DriveGilbertAZ··85270·GRP-9427MEDICARE-ADV-B
ENRENR-1293372026-05-04T03:56:10ZDianeC.Evans08/13/1960UHC-63208-52•••-••-586813978918720diane.evans@yahoo.com3144 Church St Apt 16AustinTX78731GRP-3420MEDICARE-ADV-A
ENRENR-1143552026-08-29T20:24:07ZSarah—·Fernandez1591-11-24UHC-46404-59•••-••-30427394265314—3509 WILLOW COURTDenver··CON/AGRP-7251OPTIONS-PPO
ENRENR-1079692026-02-23T22:09:02ZGabrielT··Edwards1967-06-01UHC-72894-86•••-••-7066(579) 272-1768gabriel.edwards@hotmail.com8238 Union Street·GilbertAZ—GRP-3970OPTIONS-PPO··
ENRENR-1309422026-06-14T16:57:01ZDAVIDA.··LONG1966-04-07UHC-02750-47•••-••-0385-david.long@yahoo.com5155 Maple AveChandlerAZ85240GRP-6395··medicare-adv-a
ENRENR-1268142026-04-29T20:11:51ZEthen—Dean03-03-1970UHC-12480-79•••-••-3031658-408-6437—8057 Union St··MesaAZ··85298GRP-6786CHOICE-PLUS-PPO··
ENR ENR-1355902026-09-15T16:29:15ZMASON—BRYANT1980-07-28UHC-62320-16•••-••-3990(229) 778-3863mason.bryant@icloud.com··4694 HARBOR BOULEVARD··MesaAZ85264GRP-2469NAVIGATE-HMO
ENRENR-1418282026-06-01T12:14:19ZNATALIEC.VAZQUEZ1974-09-11·UHC-96384-44•••-••-1420(264) 531-3082NULL——NULL—GRP-5708··MEDICARE-ADV-A
ENRENR-1048672026-06-22T06:58:49ZBilly—HuntDec 21, 1972UHC-00290-15•••-••-7650(983) 455-4233billy.hunt@gmail.com5719 Camelback Road··SacramentoCA95800GRP-3214MEDICARE-ADV-B··
ENRENR-1108732026-07-06T08:23:55ZMarcusP.Parker11/24/74UHC-90476-58•••-••-9685(929) 440-8641MARCUS.PARKER@AOL.COM8429 CAMELBACK ROADChandlerArizona85255·GRP-5129CHOICE-PLUS-PPO
ENRENR-1280602026-01-17T01:29:03Z·LINDA—HOWARD1590-05-15UHC-68897-62N/AN/Alinda.howard@yahoo.com6346 Market StTampafl33614-2618··GRP-7735CHOICE-PLUS-PPO
ENRENR-1202782026-04-26T16:57:38Zscott·Gguzman1989-02-04·UHC-03230-14•••-••-5085+1 371 642 8266—2262 Cedar Ln Apt 33··TampaFL33649GRP-4073NAVIGATE-HMO
ENRENR-1060102026-07-29T17:52:49ZKATHRYN—PALMER1959-01-15UHC-39282-95—+1 316 262 6727kathryn.palmer@yahoo.com·6723 Sunset BlvdEden Prairie·MN55301GRP-4957CORE-HMO
ENRENR-1252642026-04-19T07:41:43ZGomez, Benjamin——2002-07-21··UHC-32991-98•••-••-5356(653) 799-8516—5654 Washington St·DALLASTX—GRP-9555MEDICARE-ADV-B
ENRENR-1430082026-06-18T09:56:48ZDenise—Miller1949-07-11UHC-85977-64•••-••-7932789-386-4561DENISE.MILLER59@HOTMAIL.COM7211 Park PlaceFresnoCA93785GRP-8339CHOICE-PLUS-PPO
ENRENR-1369502026-05-08T00:51:25ZGregoryBRose1940-08-26UHC-54198-54•••-••-9639627-412-3865gregory.rose@aol.com7497 River RdTucson·az85766GRP-2983CHOICE-PLUS-PPO
ENRENR-1168402026-08-20T22:31:13ZMEI—POWELL1938-01-21·UHC8656131null6008298mei.powell71@outlook.com·9037 Ridge RoadScottsdaleAZ85281GRP-4935CHOICE-PLUS-PPO
ENRENR-1252972026-08-13T18:32:53ZemmaJgardner1946-01-01UHC-09094-51•••-••-02597997187816··emma.gardner66@proton.me8545 PALM DRIVESan Diego···CA92122GRP-2417CHOICE-PLUS-PPO
ENRENR-1287982026-06-02T08:51:30ZShaw, Mary——03/14/08UHC-57057-08•••-••-537615379779855mary.shaw@outlook.com1838 MESA DROrlandoFlorida32845··GRP-3335CHOICE-PLUS-PPO··
ENRENR-1117682026-08-19T16:30:09ZJOSEDCRAWFORD1991-06-13UHC-88067-96•••-••-18878108166307JOSE.CRAWFORD@HOTMAIL.COM2181 WILLOW COURTChandlerAZ··85241GRP-6896MEDICARE-ADV-A
ENRENR-1230052026-03-30T20:43:43ZJoyce—Snyder1/7/1961··UHC3834205•••-••-6007678.253.9977—7991 Meadow LnGLENDALEAZ85350·GRP-7665CORE-HMO
ENRENR-1120962026-03-02T00:26:12ZJUANMMURPHY10/3/1973UHC-80089-58•••-••-9029684-627-8951·UNKNOWN147 Canyon RoadTampaFL33668-4893GRP-1277CHOICE-PLUS-PPO
ENRENR-1302732026-06-25T18:42:18ZCHARLES—NELSON01-03-1939UHC-63194-22•••-••-4862918.505.7537charles.nelson67@aol.com1880 Pine Drive·Eden PrairieMN55394GRP-1054MEDICARE-ADV-B
ENRENR-1201092026-08-22T05:16:41ZRANDYB.BAKER19810409UHC-05575-14null6041115randy.baker73@aol.com8269 GRAND AVENUEMesaAZ85297GRP-6765CHOICE-PLUS-PPO
ENRENR-1213892026-07-01T01:32:52ZBradleyZAlexander1970-09-20UNKNOWN·null+1 685 991 8010bradley.alexander12@aol.com8192 Highland AvenueColumbusOH··GRP-8145··MEDICARE-ADV-A
ENRENR-1208562026-09-13T22:11:19Z EDWARD—LONG07-09-1972UHC-76626-71··—3274234802edward.long@gmail.com4777 BroadwayCharlotteNC28289GRP-1325NAVIGATE-HMO
ENRENR-1091072026-09-23T18:06:59ZWilliam··—Howell2000-02-12UHC-25683-74•••-••-0624(496) 728-4654william.howell@gmail.com9735 River RdLos AngelesCA90067··GRP-0635MEDICARE-ADV-B··
ENRENR-1173252026-10-13T05:12:40ZChristine—Carter1939-10-14·UHC6597285•••-••-9173·485.958.7300christine.carter63@hotmail.com··4747 MOUNTAIN VIEW DRScottsdaleAZ85229GRP-0845CORE-HMO
ENRENR-1217762026-03-17T19:56:29ZDIANA—WALLACE2004-07-14UHC5666620•••-••-0020·5528184543diana.wallace40@aol.com9592 BROADWAYTampaFL··33603GRP-6309NAVIGATE-HMO
ENRENR-1028862026-04-01T02:13:51ZCHARLOTTE—BERRY11/20/1966uhc-48530-99•••-••-81696178568471NULL3697 Desert Sky BoulevardAustinTX78711GRP-3962CORE-HMO
ENRENR-1372002026-04-23T13:58:03ZFRANCESXBERRY08-02-1968UHC-64195-37•••-••-4150—frances.berry@gmail.com7190 Pine DrMinneapolisMN55466GRP-7903··MEDICARE-ADV-B
ENRENR-1005762026-08-29T14:18:14ZSophia—Evans2/2/1952UHC-99110-39•••-••-3979569.526.2850null5011 Maple Ave·Las VegasNV·89199GRP-2086OPTIONS-PPO
ENRENR-124896 2026-10-11T09:50:43ZScott··Silva2004-08-21UHC-66182-48•••-••-0464364-256-2449scott.silva83@gmail.com156 GRAND AVENUE·AustinTX78755-4765GRP-1854NAVIGATE-HMO
ENRENR-1371612026-04-30T16:08:06ZNOAH—HERRERAFeb 25, 1955UHC-36445-13•••-••-497212652811140NOAH.HERRERA@GMAIL.COM6367 MARKET STDenverco80200GRP-2544CHOICE-PLUS-PPO
ENRENR-1334212026-09-01T10:22:23ZNANCYGALVAREZ2/6/1961UHC-44268-52•••-••-8156—nancy.alvarez@gmail.com2852 Indian School Road··MinneapolisMN··55405GRP-5593CORE-HMO
ENRENR-1010192026-09-07T20:19:55ZDAVID—TAYLOR·1956-08-27·UHC8064110—+1 607 377 8597david.taylor@outlook.com4578 Baseline RoadJacksonvilleFL32221GRP-9183CHOICE-PLUS-PPO
ENRENR-1065992026-01-13T23:55:12ZLynh, AliceP.—1958-09-16UHC-12665-44•••-••-52877566717771alice.lynch13@icloud.com8765 BroadwayMinneapolis··MN55455GRP-0921SELECT-EPO
ENRENR-1320662026-09-28T00:56:22ZJessicaB.Cox1982-09-27uhc-61058-29•••-••-8443825-712-6253-4717 Forest AveHoustonTX77091GRP-2364SELECT-EPO
ENRENR-1427672026-08-04T01:41:10ZZacharyWMitchell08/27/87UHC-77378-20•••-••-0584(426) 904-9941zachary.mitchell@yahoo.com5449 Jefferson AveCHARLOTTENC28278·GRP-6557NAVIGATE-HMO
ENRENR-1271952026-03-27T13:16:11Z ElijahXMyeer1947-05-17UHC-42044-02—(378) 876-8518··elijah.meyer@icloud.com7941 CENTRAL AVETampaFL33692-4475GRP-1581·MEDICARE-ADV-A
ENRENR-1002122026-08-26T18:23:44ZYoung, KatherineX··—06/08/1985UHC4503396•••-••-1873927-454-5148N/A9786 Mountain View DrAustinTexas78765GRP-6874·SELECT-EPO
ENRENR-1378222026-10-09T18:04:58ZPeter—Valdez19391002UHC-67988-31•••-••-3422+1 322 470 4354·NULL4179 RIVER RDCHARLOTTENorth Carolina28202GRP-1621CHOICE-PLUS-PPO
ENRENR-1268252026-04-13T20:03:59ZWheeler, Maary——1975-09-27···UHC-61948-57•••-••-8351+1 978 707 5309··mary.wheeler12@hotmail.comN/A—NULLNULLGRP-0299NAVIGATE-HMO
ENRENR-1069922026-08-16T19:59:28ZFRANCES—JENSEN1939-11-26UHC-28319-76•••-••-8967(828) 259-9076··frances.jensen@icloud.com6699 Market StSan DiegoCA92101GRP-7029MEDICARE-ADV-B
ENRENR-1050682026-07-02T23:39:43ZJONATHAN·H.CASTILLO1988-02-03UHC-91832-33•••-••-0263(945) 590-9882jonathan.castillo@yahoo.com7014 Willow Court··SAN DIEGOCA92161GRP-1845MEDICARE-ADV-B
ENRENR-1299392026-08-17T07:59:21ZContreras, Austin L.——21-03-1946UHC-46475-46•••-••-01933652239138AUSTIN.CONTRERAS@HOTMAIL.COM··1920 Pine DrMiamiFL33145GRP-5522SELECT-EPO
ENRENR-1038222026-03-14T00:09:40ZMichaelCMejia1980-03-11UHC-78868-01•••-••-20205596034107MICHAEL.MEJIA@ICLOUD.COM1065 Harbor BoulevardGlendaleAZ85373GRP-5999CHOICE-PLUS-PPO
ENRENR-1116832026-06-17T00:30:31ZMARILYNTRICHADS1995-06-26UHC-52260-31•••-••-5253907-984-1631—2627 Church StreetDenverCO80240-5901GRP-3127OPTIONS-PPO
ENRENR-1195932026-02-21T15:40:15ZSandraGSingh1975-10-23UHC-70540-52•••-••-9568(684) 730-8043sandra.singh@proton.me1491 Jefferson Ave Apt 32GILBERTAZ85269GRP-4823OPTIONS-PPO
43,101 rows, page 197 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.335Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty