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-1087642026-02-21T20:09:59ZWebb, GloriaT.—-··UHC-30941-79•••-••-3780(258) 222-1799N/A3557 Church StTempeAZ85267GRP-5757MEDICARE-ADV-A
ENR ENR-1132722026-08-02T02:39:24ZVirginia—Mason-UHC-15433-81—581.543.9419virginia.mason1@gmail.com8824 Indian School RdATLANTAGA30306GRP-4648OPTIONS-PPO
ENRENR-1260842026-10-09T13:22:17Z·Ann—·Singh18-09-1944UHC-68432-82•••-••-0817232-323-6049ANN.SINGH@AOL.COM9512 Main StMiamiFL33148GRP-9987NAVIGATE-HMO
ENRENR-1063952026-02-12T15:25:05Z JulieYFranklin1980-10-22UHC-96702-58•••-••-8380+1 711 334 1651JULIE.FRANKLIN@PROTON.ME2312 Pine DriveGlendaleAZ85382GRP-6499MEDICARE-ADV-A
ENRENR-1283442026-03-14T12:57:45ZSANTIAGO·TGNOZALES11/3/1989UHC-46097-50•••-••-7602616.905.4240SANTIAGO.GONZALES@PROTON.ME·2699 Ocean AveMIAMI·FL33178GRP-1338SELECT-EPO
ENRENR-1387442026-03-14T00:44:07ZCarol—Duncan1943-10-11UHC-01787-21•••-••-33016039047913CAROL.DUNCAN11@GMAIL.COM9468 Forest AveScottsdaleAZ85254GRP-5927CORE-HMO··
ENRENR-117333 2026-09-24T17:55:39ZJames, Junathan·O—·1965-04-14UHC-64223-13•••-••-6273····-4591 Mesa Drive··San AntonioTX78288GRP-8076CHOICE-PLUS-PPO
ENRENR-1188252026-02-16T20:09:17ZbradleyFwarren09/15/1949UHC-68145-62•••-••-3569(381) 430-4989bradley.warren3@icloud.com8313 Sage CourtLas VegasNV89170GRP-7637OPTIONS-PPO
ENRENR-1375072026-07-24T12:23:08Z Jacubs, LauraZ—03/21/1985UHC-87411-82•••-••-4240·7919226255laura.jacobs19@outlook.com··2503 Lincoln WayATLANTAGA30384GRP-5449MEDICARE-ADV-B
ENRENR-1358982026-01-03T13:33:23Zadam—richards2008-09-20UHC-56502-17•••-••-0405(776) 455-7343adam.richards80@aol.com1893 Sage CourtMiamiFL33111GRP-4345NAVIGATE-HMO
ENR ENR-1250672026-07-22T18:34:16ZPATRICIAH.ALLEN20020827·UHC-01447-36•••-••-4516414-645-9706N/A2191 CEDAR LN··CharlotteNC28254GRP-9729··core-hmo
ENRENR-123287 2026-10-15T04:50:28ZHarrison, SophiaH—1964-02-25UHC-44046-20•••-••-2848+1 881 482 5729sophia.harrison47@outlook.com···1060 Grand AvePhoenixAZ85096-7425GRP-4660MEDICARE-ADV-B
ENRENR-1244642026-02-26T15:47:55ZDORISGJACOBS1/16/2000UHC-45965-80•••-••-9953—doris.jacobs@proton.me4453 Baseline RoadCHARLOTTENC28287GRP-6430options-ppo
ENRENR-1346032026-02-21T06:01:43Zcarol····grant13-07-1939UHC-58128-35N/A(256) 377-8166carol.grant88@outlook.com9824 Sunset BlvdSan DiegoCA·92139GRP-3592CHOICE-PLUS-PPO
ENRENR-1344842026-01-17T05:52:52ZPerez, CherylH··Apr 1, 1963UHC-28681-13-6088639791CHERYL.PEREZ93@YAHOO.COMnull-——GRP-9511NAVIGATE-HMO
ENRENR-1058702026-08-16T19:01:22ZGerald····Mitchell1951-04-24UHC-05369-83•••-••-36124477314017gerald.mitchell61@outlook.com551 Park PlSan DiegoCA··92117GRP-6168··SELECT-EPO
ENRENR-1422852026-04-04T05:49:19ZHelen—Green1990-05-19UHC-47620-65•••-••-9059·NULLhelen.green@aol.com1088 SPRING STGlendaleAZ85354·GRP-2981SELECT-EPO
ENRENR-1018282026-04-02T21:38:11ZCATHERINE—MARSHALL19591217UHC-98347-36•••-••-8472486-866-1722catherine.marshall22@yahoo.com8409 Desert Sky BlvdDALLASTX75231GRP-6542MEDICARE-ADV-B
ENRENR-1070882026-09-14T20:36:09ZWarren, Ryan——8/13/1946UHC-88581-01null219-583-5859ryan.warren@yahoo.com243 Sunset BlvdNashville··TNNULLGRP-8970CORE-HMO
ENRENR-1059422026-02-27T13:25:39ZGaryP.BurkeMay 22, 1963UHC-88412-98•••-••-579815097344875gary.burke@yahoo.com2576 Lake View RoadMiamiFL33128GRP-1792MEDICARE-ADV-A
ENR ENR-1065072026-02-26T07:12:18ZDenise—Johnston19520212UHC2027955•••-••-4330·912-528-1888N/A5325 BASELINE ROAD··JacksonvilleFL32210GRP-0543SELECT-EPO
ENRENR-1234082026-02-25T15:07:20Z rogerHnelson14-06-1989UHC-31937-38•••-••-2695968-475-8967-9244 MOUNTAIN VIEW DRMiamiFL33198·GRP-0484OPTIONS-PPO
ENRENR-1346552026-01-09T01:32:17ZDENNISN.·PATTERSON1969-03-28UHC-31263-30•••-••-9034953-519-8192··dennis.patterson@hotmail.com3295 Market StreetEden PrairieMN55374-9444GRP-1889OPTIONS-PPO
ENRENR-117297 2026-08-07T22:29:31ZMasonXRice1993-10-07UHC1752408•••-••-8096(296) 204-6244····7281 Hillcrest Rd Apt 28ScottsdaleAZ85237·GRP-1123NAVIGATE-HMO
ENRENR-1303652026-07-10T08:15:10ZSanchez, RobertM—9139-12-19UHC-14192-84-472-831-9605robert.sanchez@icloud.com3138 MEADOW LN··JacksonvilleFL32254GRP-9841NAVIGATE-HMO
ENRENR-1085562026-04-21T17:48:57Z·BobbyJMatthews05/04/1973UHC-97499-90—866-745-4117-nullNULLN/A—GRP-6800medicare-adv-a··
ENRENR-1093292026-06-07T02:56:17ZMateo—Kelly1947-07-10UHC-38908-32•••-••-71834894443862mateo.kelly85@proton.me··9270 ELM STREETSan DiegoCA92165GRP-5728OPTIONS-PPO
ENRENR-136078 2026-06-05T08:31:10Z·KIMBERLY—GORDON··12/28/06UHC8956095•••-••-7458(784) 584-5260kimberly.gordon@aol.com··88 Willow Ct Apt 12Eden PrairieMN55360GRP-9801NAVIGATE-HMO
ENRENR-1212532026-05-29T04:15:54ZDENNIS·F.SULLIVAN1997-09-10UHC-87040-17•••-••-40729694738666N/A7287 Indian School Rd·DenverCO80240GRP-8323OPTIONS-PPO
ENRENR-1355992026-01-13T11:57:54ZDiana—Mendez07-11-1947UHC-94222-12•••-••-3976UNKNOWN—7727 Lincoln WayPhoenixAZ85044GRP-9469MEDICARE-ADV-A
ENRENR-1178262026-10-07T15:33:17Z Rogr—Guzman1991-11-22UHC-24096-79··—+1 212 756 3097roger.guzman@aol.com7777 BASELINE ROADLos AngelesCA90037GRP-5220CORE-HMO
ENRENR-1255722026-03-16T08:44:40ZPatriciaZPadiilla·1941-12-17UHC-08197-54•••-••-4029477-441-5654patricia.padilla@proton.me·8746 Maple AvenueMinneapolisMN··—GRP-5343OPTIONS-PPO
ENRENR-1039882026-05-17T11:01:04ZVALENTINASBANKS1954-05-17UHC-95054-93——VALENTINA.BANKS27@HOTMAIL.COM7203 Palm DrATLANTAGA30397GRP-3711OPTIONS-PPO··
ENRENR-1033602026-05-11T10:34:07ZAbigailI.Scott11/13/1957UHC-38024-47•••-••-0963-N/A4747 Grand AvenueMinneapolisMN55474GRP-0835MEDICARE-ADV-A
ENRENR-1414292026-05-10T23:03:35ZREBECCA—PAYNE·19390310UHC-73170-37•••-••-4417(629) 774-9005REBECCA.PAYNE@OUTLOOK.COM··1740 Union St···NASHVILLETN37257GRP-5753NAVIGATE-HMO
ENRENR-1208422026-02-03T07:54:24ZCox, Ronald——1942-12-27—•••-••-3291275-259-8119ronald.cox34@hotmail.com6366 Spring StreetPlanoTX75002-5844·GRP-5022CHOICE-PLUS-PPO
ENRENR-1270902026-04-30T19:35:57Z·janetE.lawrence01/06/06UHC-94279-90•••-••-6599648-410-7286janet.lawrence@hotmail.com942 Elm StGilbertAZNULLGRP-0427MEDICARE-ADV-B
ENRENR-1378812026-08-19T02:11:58ZOLIVIA—MONTGOMERY1940-13-03UHC-04428-79•••-••-5670885.616.1836olivia.montgomery63@gmail.com·9665 Market Street Apt 40GilbertAZ85200GRP-1640SELECT-EPO
ENR ENR-1376592026-08-25T21:32:39ZHiroshi—Hrrera1978-01-23UHC-69001-89-··NULLhiroshi.herrera41@icloud.com4577 Union StPlano··TX75018GRP-0879MEDICARE-ADV-B
ENRENR-1049032026-03-01T07:27:51ZMARIANAGBRADLEY8/8/1960UHC-30373-48—7159317768mariana.bradley78@aol.com3194 SUNSET BLVDSeattleWA98156GRP-4167CORE-HMO
ENRENR-1120072026-04-14T14:23:24ZBillyRLe1940-01-19UHC-22687-90•••-••-2596(798) 273-3512billy.le@proton.me1390 MESA DRIVEPhoenixAZ··85003-3602GRP-6426CHOICE-PLUS-PPO
ENRENR-1425172026-05-25T23:44:41ZSTEPHENO··HARRIS2001-01-28UHC-18624-69•••-••-9777841-330-2005stephen.harris49@outlook.com6491 Grand AvePlanoTexas75015GRP-3553CORE-HMO··
ENRENR-1323402026-09-18T19:39:09ZMartha—·Knight1949-02-09UHC-46240-42•••-••-3525(303) 850-9698MARTHA.KNIGHT@GMAIL.COM9616 Valley View DriveDENVERCO80276GRP-7807SELECT-EPO
ENRENR-1025772026-07-12T14:22:24ZJose—Dixon09/18/41··UHC-71614-07•••-••-9172602-240-2723jose.dixon@yahoo.com4623 Camelback RoadCHARLOTTEnc28219GRP-2440SELECT-EPO
ENRENR-1279432026-03-31T14:40:33ZHayes, Emma····—1947-11-22UHC-08659-93•••-••-7482+1 438 618 4440null7363 Cedar LaneCharlotte··NC28215GRP-8584SELECT-EPO
ENRENR-1277252026-07-25T21:47:36ZArthur·YChavez03/13/76UHC-62825-64•••-••-7749(428) 838-6557arthur.chavez@icloud.com··—null··NULLGRP-6797·SELECT-EPO
ENRENR-1063972026-07-13T05:38:49ZHeatherWMcDonald1947-01-09UHC-74882-51•••-••-2460(711) 496-9185heather.mcdonald50@outlook.com634 Apache BoulevardAustinTX78773GRP-2642NAVIGATE-HMO··
ENRENR-1138872026-06-20T22:21:47Z julia—chen2000-07-16UHC-24371-99•••-••-6564NULL-8419 Palm DriveGlendaleAZ85322GRP-6019MEDICARE-ADV-A
ENRENR-1184222026-02-12T01:05:59ZVICTORIA—·ROJAS19500314UHC-85933-77•••-••-0771UNKNOWN—6116 Meadow LnLas VegasNVUNKNOWNGRP-4201CHOICE-PLUS-PPO
ENRENR-1071832026-07-26T14:59:25ZALEXISPMEYER19850904UHC-17132-60•••-••-772618344140412N/A6460 Baseline RoadMesaAZ85249GRP-6722OPTIONS-PPO
43,101 rows, page 23 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:34.779Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty