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-1131442026-08-06T10:06:02ZSofia—Allen1977-04-28·UHC-34121-21NULL989.342.7204sofia.allen7@icloud.com2567 Oak StSan AntonioTXnullGRP-6380CHOICE-PLUS-PPO
ENRENR-1283562026-05-12T02:20:13ZVINCENT N—CAMPBELL02/26/50UHC-73442-08•••-••-6425711-582-7776vincent.campbell7@gmail.com9392 Harbor BoulevardNashvilleTennessee37212GRP-2503SELECT-EPO
ENRENR-1334632026-10-09T15:30:23ZFernandez, KimberlyU··—1972-08-08UHC-06067-35•••-••-5172(546) 297-8577—7077 Park PlTempeAZ85248GRP-3600CORE-HMO
ENRENR-1301902026-06-28T17:33:21ZAmanda—Santos1939-03-09UHC-16913-21··•••-••-445212179055139amanda.santos39@aol.com1074 CHURCH STChandleraz85276GRP-0160SELECT-EPO
ENRENR-1201112026-03-28T03:18:33ZScott, KeithJ—1999-07-09··UHC-99761-49-19847610668keith.scott73@gmail.com9133 CANYON ROADSAN ANTONIOTX—GRP-9645··NAVIGATE-HMO
ENRENR-1344152026-03-21T17:07:12ZCharlotteJ.Rojas2006-06-13UHC-76391-19N/A867.404.7573charlotte.rojas@icloud.com5721 Canyon Rd·MesaArizona85252GRP-9138NAVIGATE-HMO
ENRENR-1306712026-05-21T12:14:07ZMeiBWest2000-03-24UHC-16141-70•••-••-7287(269) 936-0943mei.west@icloud.com9598 CENTRAL AVENUE··San AntonioTX78259GRP-7861SELECT-EPO
ENRENR-111783 2026-04-09T18:27:33ZHERRERAX.JAMES10/15/2007UHC-91233-31•••-••-17985506593172james.herrera@icloud.com3206 WASHINGTON STLAS VEGASNV89105GRP-7790CHOICE-PLUS-PPO
ENRENR-1189552026-07-25T16:56:43ZJoshuaIYoung07/01/76UHC-12060-06•••-••-8537296-246-4303JOSHUA.YOUNG19@AOL.COM228 Meadow Ln··HOUSTONTX77055GRP-9388CHOICE-PLUS-PPO
ENRENR-1056042026-04-09T03:57:51ZMegan—Silva08-08-1964UHC-68244-03•••-••-8598(694) 432-4248NULL·6813 Church StJacksonvilleFL32265GRP-2677NAVIGATE-HMO
ENRENR-1313772026-05-19T23:20:47ZBRADLEY·FRIVEA·1986-01-09UHC-14146-70•••-••-22899287092307—1580 Willow CtJacksonvilleFL32239GRP-7919CHOICE-PLUS-PPO
ENRENR-1231572026-05-06T19:48:56ZjakeKfields1996-01-20UHC7609202•••-••-2237318-703-2904jacob.fields@outlook.com4079 Pine DriveEden PrairieMN55338GRP-7677CORE-HMO
ENRENR-1410462026-07-25T00:09:30ZChristine—Murray—UHC-07405-48•••-••-7697—-894 Elm StreetOrlandoFL32823·GRP-7669NAVIGATE-HMO
ENRENR-1134892026-01-13T05:44:52ZBeverly—Robinson1982-01-25UHC-05141-71•••-••-2855+1 392 924 0778beverly.robinson@icloud.com9497 Sage CourtScottsdaleAZ85224GRP-5169CHOICE-PLUS-PPO
ENRENR-1276642026-02-27T12:15:36ZMasonK.OrtyzFeb 8, 2008UHC-43983-84•••-••-1254(827) 243-2942mason.ortiz@icloud.com9428 LAKE VIEW RDTempeAZ85262GRP-2209···NAVIGATE-HMO
ENR ENR-1064972026-05-08T18:18:05ZCynthiaN.Chapman05/02/1978UHC-75673-50•••-••-980413906447278cynthia.chapman66@aol.com8451 Willow CourtDallasTX75209GRP-9849CORE-HMO
ENRENR-1208532026-07-14T21:10:15ZTony—Hunter4/17/1973UHC-25320-77•••-••-7049514-868-8083··3011 Park PlaceSeattleWA—GRP-7779MEDICARE-ADV-B
ENRENR-1378322026-07-14T00:26:08ZJEFFREYNSANTOS1943-08-15UHC-37212-67•••-••-6200925-769-6225jeffrey.santos12@aol.com2114 Canyon Road··San AntonioTX78248GRP-0631CHOICE-PLUS-PPO
ENRENR-1210972026-01-03T11:05:21ZBrenda··DNguyen1950-10-10UHC-96686-39-739-966-4939N/A5028 Harbor BlvdSan DiegoCA92146GRP-8677CORE-HMO
ENRENR-1300342026-05-14T18:08:17ZjoanGharrt2006-05-10UHC2026466•••-••-0714-·JOAN.HART65@AOL.COM5336 Church St #302GlendaleAZ85384GRP-2987·MEDICARE-ADV-B
ENRENR-1020342026-01-04T05:53:42Zpriya—kelly1959-05-22UHC-02663-92•••-••-77483886271158UNKNOWN6859 Grand AvenueTucsonAZ85723GRP-7053NAVIGATE-HMO
ENRENR-1143712026-02-17T03:44:57ZAlexanderXDiaz08/14/2001UHC0894548•••-••-3103(540) 945-3173alexander.diaz34@proton.me3718 MOUNTAIN VIEW DRIVEEDEN PRAIRIEMN55318GRP-7306MEDICARE-ADV-A
ENRENR-1289542026-02-02T15:30:12ZKAREN—RILEY1997-02-11uhc-15007-83•••-••-8999(685) 737-5411—2321 Park PlDallasTX75292GRP-2494MEDICARE-ADV-B
ENRENR-1102532026-03-25T13:15:46ZEUGENE—LOPEZ3/22/1968UHC-03438-59•••-••-639613294911950-3170 Spring StCharlotteNC28233GRP-5881OPTIONS-PPO
ENRENR-1382092026-06-27T21:15:42ZLuis—Gray2000-03-07UHC-13868-70··•••-••-3032+1 842 360 8014LUIS.GRAY@AOL.COM1486 WILLOW CTDenverCO··80216GRP-2461SELECT-EPO
ENRENR-1256672026-06-06T06:47:08ZRay—Sullivan1989-08-22UHC0598164•••-••-66324231313raymond.sullivan@proton.me5591 SAGE CTChandlerAZ—GRP-5127NAVIGATE-HMO
ENRENR-1247752026-09-15T20:27:49ZAHMED—KIM2004-08-23NULL•••-••-8940(753) 721-8219ahmed.kim@icloud.com4911 Forest Ave #468·NashvilleTennessee37298·GRP-7391CORE-HMO
ENRENR-1341912026-08-16T21:41:48ZBeverlyP·Morales1955-05-12UHC5950345··•••-••-4628(732) 665-8315—1235 Cedar LnSan Diego·California92176GRP-7241MEDICARE-ADV-B
ENRENR-1056662026-05-12T02:22:57ZYukiURichardson1990-12-20UHC-71666-54UNKNOWN267-305-2729—6228 Pine DrLas VegasNevada89113GRP-5699·MEDICARE-ADV-A
ENRENR-1011152026-05-14T23:55:17ZsaraDdaniels9161-03-27UHC-86981-74•••-••-7593964-530-0290null8035 Jefferson AveCharlotteNC28267GRP-2939CORE-HMO
ENRENR-1181942026-03-08T13:18:59Z MARY—PENA1964-10-04UHC-87810-27NULL—mary.pena@outlook.com5221 RIVER ROADSeattleWA98184GRP-0482NAVIGATE-HMO
ENRENR-1097242026-02-07T15:24:37ZEmmaIMyers2005-11-14UHC-94234-71•••-••-6409(220) 483-1763UNKNOWN8549 Highland AvenueLos AngelesCalifornia90048GRP-8181MEDICARE-ADV-B
ENRENR-1165752026-06-30T08:36:37ZANNASMORRSON11/22/1956uhc-62678-61··•••-••-357115489139559ANNA.MORRISON@GMAIL.COM7151 Baseline Road·MiamiFL33142GRP-3759MEDICARE-ADV-B
ENRENR-1362742026-04-20T00:48:06Z Singh, BillyZ—1957-03-05UHC-37632-95•••-••-47127256946273billy.singh29@aol.com7609 BroadwayLAS VEGASNV89189GRP-4961NAVIGATE-HMO··
ENRENR-1233022026-05-30T05:45:10ZPATRICIA—COOPER1972-01-15UHC-47120-09··•••-••-02794425050577····2892 Pine DriveJACKSONVILLEFLnullGRP-3549OPTIONS-PPO
ENRENR-1017992026-04-14T15:00:59ZAmy—Graham1942-10-28UHC-93467-22•••-••-52218128178278amy.graham@proton.me3276 OAK STREET·Seattle·WA98148··GRP-9311MEDICARE-ADV-B
ENRENR-1204812026-01-31T23:52:03Z·CHARLESYKELLY2006-07-14UHC-86006-63•••-••-9185715-590-2967CHARLES.KELLY20@PROTON.ME25 JEFFERSON AVE·SCOTTSDALEAZ85226GRP-5937SELECT-EPO
ENRENR-1172772026-04-13T17:37:57Z Cruz, Nathan——1986-12-27UHC-61858-81UNKNOWN(812) 895-2303nathan.cruz@outlook.com—UNKNOWNnullNULLGRP-3313core-hmo
ENRENR-1236252026-09-22T18:17:30ZALBERT····HERNANDEZ·11-09-1983UHC-13118-17•••-••-1254(553) 375-4564albert.hernandez@yahoo.com3177 Spring St #340Las VegasNV89184GRP-9052MEDICARE-ADV-A
ENRENR-1189632026-10-09T17:05:43ZHenryJAdams··20000624UHC-54010-91•••-••-6715(578) 373-0509·N/A4825 Lincoln WayLos AngelesCA90042GRP-9331CHOICE-PLUS-PPO
ENRENR-1149882026-03-30T23:24:53Z·joshua—walsh—UHC-13971-36—+1 525 276 4697··null3202 PINE DRIVEDENVERCO80286GRP-7865NAVIGATE-HMO
ENRENR-1285562026-01-29T10:14:27ZDANIEL······BROOKS1987-01-01UHC-14086-28•••-••-3847+1 799 700 1733NULL··5261 RIDGE ROADFresnoCA93749··GRP-3152MEDICARE-ADV-B
ENRENR-1124762026-05-08T16:48:04Z·Camila—Kim1985-10-22UHC3287219•••-••-88693768564UNKNOWN9150 CENTRAL AVEFresnoCA93754GRP-1834NAVIGATE-HMO
ENRENR-1303302026-08-07T10:18:29Z·KellyBLucas1947-12-15UHC-15635-05NULL619-901-4927kelly.lucas87@outlook.com6413 Meadow LnSeattleWA98118GRP-0972··CORE-HMO
ENRENR-1273002026-08-05T19:07:29ZLarry—·Gordon19421007UHC-57084-06•••-••-3256+1 319 296 4336larry.gordon16@gmail.com3764 Canyon RoadAtlantaGA30331··GRP-2409SELECT-EPO
ENRENR-1095772026-10-02T12:13:13ZpatrickCcarroll·1986-01-15UHC5129359•••-••-85935106489849patrick.carroll5@aol.com9191 MEADOW LNSan AntonioTX78280GRP-3850CORE-HMO
ENRENR-132688 2026-01-07T11:51:56ZDennisMElliott1944-08-12UHC-36167-23•••-••-1680N/A—2860 OCEAN AVEEden PrairieMN55387GRP-3623OPTIONS-PPO··
ENRENR-1231902026-07-03T18:18:01Z Raymond—Reyes11/14/1972uhc-12708-34•••-••-26044285472035·raymond.reyes31@hotmail.com5870 Lincoln WayDENVERColorado80290GRP-9767CORE-HMO
ENRENR-1042032026-01-02T14:30:29ZRuthM··Hill···12/12/85UHC-49852-18—(380) 534-9906ruth.hill18@hotmail.com9606 Mesa DriveLos AngelesCA90083GRP-4114MEDICARE-ADV-B
ENRENR-1119812026-07-04T01:05:48ZLoganTDaniels1942-01-23UHC-42295-25—942.967.4440··logan.daniels49@aol.com··1651 Desert Sky BlvdHOUSTON·TX·-GRP-6240SELECT-EPO··
43,101 rows, page 134 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.456Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty