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-1039072026-07-09T01:34:25ZwillieVwoods··02/18/01UHC-13925-39•••-••-8177(946) 897-7509WILLIE.WOODS52@GMAIL.COM6332 BroadwayPhoenixAZ—GRP-3099CHOICE-PLUS-PPO
ENRENR-1227802026-02-04T00:54:55ZMICHELLE—WALKER08/05/03UHC-17580-14•••-••-498713015838848··-7539 BAYSHORE DRIVE Apt 19JacksonvilleFL32259GRP-5013CHOICE-PLUS-PPO
ENRENR-1242082026-03-19T04:18:51ZJerryI.Patel1984-07-01UHC-16622-15•••-••-72725747010969jerry.patel80@gmail.com8468 LAKE VIEW RDMINNEAPOLISMN55427GRP-8182MEDICARE-ADV-B
ENRENR-112738 2026-07-02T05:53:02ZSHARNODROMERO1952-10-26——-SHARON.ROMERO@ICLOUD.COM5377 DESERT SKY BLVDLAS VEGASNV89188GRP-7312NAVIGATE-HMO
ENRENR-1430852026-02-26T00:13:56ZBradley—Salazar1964-10-18UHC-55091-67•••-••-9359-—6012 VALLEY VIEW DRIVEDallasTX75231·GRP-4987MEDICARE-ADV-A
ENRENR-1102902026-07-02T06:50:00ZRussell—Hunt1961-09-13UHC2046499•••-••-2468N/ARUSSELL.HUNT@ICLOUD.COM6588 HIGHLAND AVENUETampa··FL33604GRP-2112CHOICE-PLUS-PPO
ENRENR-1149982026-05-15T14:18:21ZAISHA—WILLIS·1961-04-17UHC-57295-06•••-••-7368(929) 291-2990null5745 CANYON RD #441PHOENIXAZ85072GRP-9533NAVIGATE-HMO
ENRENR-1200412026-08-19T23:14:00ZBrittany—Morris20010110UHC-21353-51•••-••-1368467-340-4072brittany.morris@aol.com205 SUNSET BOULEVARDHoustonTX77032GRP-7575NAVIGATE-HMO
ENRENR-1118382026-01-29T22:05:48ZJohn·V.Andrews1960-09-20UHC-04984-49•••-••-8157N/Ajohn.andrews@aol.com8168 LINCOLN WAYDallas·Texas75234GRP-6883NAVIGATE-HMO··
ENRENR-1075332026-03-11T00:50:10ZSharonE.··WestNov 11, 1984UHC-67402-41•••-••-8907(941) 675-1364·sharon.west@yahoo.com—-UNKNOWNN/AGRP-9511CORE-HMO
ENRENR-1065422026-03-09T01:39:51ZOLIVIA—CHAPMAN1981-10-02··UHC-99104-40•••-••-98518042210204null——N/ANULLGRP-8822SELECT-EPO
ENRENR-1376092026-08-24T07:52:28ZChristinaNDunn1942-03-01UHC-82313-51•••-••-5280+1 647 611 4354christina.dunn99@hotmail.com6848 Market StAtlantaGA30334GRP-2690·CHOICE-PLUS-PPO
ENRENR-1159162026-07-09T19:16:11Z———02/26/1972UHC-22368-01•••-••-5602(606) 706-0238nathan.griffin@hotmail.com3469 Park PlaceTampaFL33622GRP-9922CHOICE-PLUS-PPO
ENRENR-1378652026-10-05T23:44:55Z·AISHA·W.HUDSON1969-07-28··UHC-06355-21•••-••-8494351-593-0306aisha.hudson91@gmail.com7330 Sunset BlvdTucsonAZ85756GRP-4735MEDICARE-ADV-A
ENRENR-1371522026-04-24T05:36:35ZMaarcusGJenkins1968-02-28UHC-53827-50•••-••-087317907852675MARCUS.JENKINS64@AOL.COM8251 Sunset BoulevardSan AntonioTX78266·GRP-4654CHOICE-PLUS-PPO
ENRENR-1093122026-04-05T16:56:36ZBradleyHWeaver1985-04-15UHC-93569-57•••-••-6204+1 593 663 3482-6249 Ridge RdJacksonvilleFL—GRP-1603NAVIGATE-HMO
ENRENR-1238902026-07-22T03:08:03ZAISHAY.PARKER1986-02-03UHC-97880-87•••-••-4730482-634-6233aisha.parker@proton.me764 INDIAN SCHOOL RD·Eden PrairieMNUNKNOWNGRP-5324SELECT-EPO··
ENRENR-1172702026-05-14T03:19:36ZaustinYmorrgan1982-12-01UHC-70663-96•••-••-6128622-670-9815austin.morgan@icloud.com6776 Sunset BlvdChandler··AZ85258GRP-3117OPTIONS-PPO
ENRENR-1043382026-07-26T19:00:39ZGLORIA—RYAN1955-07-08UHC-01082-27•••-••-6622·579.237.2085-4221 Forest AveTEMPEAZ85292GRP-4923MEDICARE-ADV-B
ENRENR-1427422026-09-22T01:08:33ZMateo—Harvey1961-06-08UHC-46235-64•••-••-1425560.427.2492MATEO.HARVEY@OUTLOOK.COM4288 BroadwayORLANDOFL32876GRP-6598SELECT-EPO
ENRENR-1213282026-09-26T10:25:07ZJUSTINR.JENKINSDec 15, 1957UHC-35967-43•••-••-21215577874542justin.jenkins@icloud.com9632 Palm DrScottsdaleAZ85250·GRP-0830SELECT-EPO
ENRENR-127051 2026-01-02T18:26:35ZDonald—Wallace23-01-1977UHC-19014-04—+1 249 323 6181DONALD.WALLACE@GMAIL.COM7020 Forest AvenueColumbusOH43255GRP-8309OPTIONS-PPO
ENRENR-102019 2026-06-19T00:02:20ZJulieLWashington10/25/39UHC-19375-27•••-••-2795466-201-5517julie.washington@yahoo.com4718 Union St·ScottsdaleAZ85298-1114GRP-9291MEDICARE-ADV-A
ENRENR-1069812026-10-01T20:37:01ZJustinLArnold1971-07-23UHC-06114-95•••-••-3257N/Ajustin.arnold61@hotmail.com4094 Market Street··FresnoCA93795GRP-1038··SELECT-EPO
ENRENR-1379382026-06-23T17:59:22ZBradley—Kelley1979-09-06UHC-90063-13•••-••-96096623691927·BRADLEY.KELLEY66@AOL.COM3620 Willow Ct·San DiegoCA92172·GRP-3103OPTIONS-PPO
ENRENR-1052382026-03-01T22:07:23ZDianaJRussell01/05/1999UHC-52397-34•••-••-740818807150014DIANA.RUSSELL@OUTLOOK.COM3778 APACHE BOULEVARDTempeAZ85228-4713GRP-2052SELECT-EPO··
ENRENR-1061372026-04-22T11:13:34ZChristinaK·Edwards05/02/88UHC-48121-67—12938790886christina.edwards@proton.menull--····GRP-6260OPTIONS-PPO
ENRENR-1224762026-07-12T22:30:57ZAliceCMedina04-07-1974UHC-10694-52··UNKNOWN244-222-1165··—1726 Desert Sky BoulevardColumbusOH43209GRP-7142SELECT-EPO
ENRENR-1354992026-03-11T20:22:00Z Santiago—Garcia1962-01-10UHC-07974-07•••-••-6373····—203 Park PlNashville·tn—GRP-5734MEDICARE-ADV-A
ENRENR-1074352026-05-21T09:27:50ZERIC—FULLER1975-09-21UHC2465587•••-••-0541N/Aeric.fuller35@aol.com8373 Market StreetSan DiegoCA92190GRP-7843CHOICE-PLUS-PPO
ENRENR-1413762026-06-14T23:37:22Z evelynM.moore1955-08-25UHC-06739-36··•••-••-2810—-7193 ELM STATLANTAGA30339GRP-8406MEDICARE-ADV-B
ENRENR-1104482026-05-24T20:44:46ZaishaD·wang2007-07-07UHC-84976-29•••-••-4291(320) 414-2896aisha.wang@proton.me3855 BroadwaySacramentoCA95878GRP-1740OPTIONS-PPO
ENRENR-1007562026-05-03T17:56:23ZOrtiz, TheresaX—1985-08-24UHC-35785-19•••-••-6322·3675086099THERESA.ORTIZ@PROTON.ME5028 Cedar LaneScottsdaleAZ-GRP-5255CORE-HMO
ENRENR-1301942026-02-06T02:19:27ZMEI C··BURKE20-09-1978UHC-54989-41•••-••-2016(620) 238-6100·mei.burke36@gmail.com5002 MEADOW LNDallasTX75219GRP-2843·MEDICARE-ADV-B
ENRENR-1022542026-03-07T03:56:28ZRALPHFHICKS1980-08-05UHC-56710-86•••-••-77387899787275UNKNOWN8976 Forest AveHOUSTONTX77015GRP-5458·SELECT-EPO
ENRENR-124944 2026-02-16T22:51:43ZChristine—Webb03/15/79··UHC-65802-97•••-••-77258396118541N/A8114 RIDGE ROAD #636Eden PrairieMN55376··GRP-8571OPTIONS-PPO
ENRENR-1012772026-03-19T15:12:12ZBeverly··Gonzales1995-09-04UHC-17854-92•••-••-2963972-542-9556beverly.gonzales@aol.com8059 Church StMinneapolisMN55492··GRP-8260select-epo
ENRENR-1103782026-07-03T08:35:17Z·Mason, KyleP—1952-03-09UHC-06799-94•••-••-5632854-559-3191—5448 Ocean AveDenverCOUNKNOWNGRP-9355NAVIGATE-HMO··
ENRENR-1152632026-08-08T02:14:05ZMejia, LawreceE.—1964-12-23uhc-44229-83•••-••-5245960-331-9548—8170 Church StTucsonAZ·85727·GRP-4527OPTIONS-PPO
ENRENR-1392122026-05-20T22:02:17Zjordan··harrison12/6/1938UHC-50825-87•••-••-29713244495201JORDAN.HARRISON68@PROTON.ME2882 DESERT SKY BLVDPHOENIXAZ85013GRP-5974CHOICE-PLUS-PPO
ENR ENR-1010652026-08-05T13:53:07ZERICJKIM08/06/83UHC-91798-83•••-••-5090222-783-8251-9672 BroadwayTampaFL33649··GRP-4729OPTIONS-PPO
ENRENR-1022122026-10-02T15:45:56ZKYLLEQ.WANG1939-09-22UHC-43409-27•••-••-2103(260) 617-2007kyle.wang@icloud.com··5461 Indian School RoadFresnoCA93741-6115GRP-9093medicare-adv-b
ENR ENR-1245212026-02-04T16:04:41ZNATALIEO.HOFFMANnullUHC-91848-90•••-••-4702858-564-2442natalie.hoffman72@outlook.com4436 Highland AvenueMesaAZ85217GRP-4643CHOICE-PLUS-PPO
ENR ENR-1392862026-06-09T05:06:47ZJesseJ·Jones1967-07-15UHC-26577-70•••-••-0227(363) 363-4581jesse.jones16@hotmail.com9066 UNION ST Apt 31TampaFL33627GRP-9719NAVIGATE-HMO··
ENRENR-134777 2026-08-08T01:01:29ZAlbert—Delgado11/16/77UHC-28781-56•••-••-39032699420467·albert.delgado@outlook.com6306 SAGE CTLas VegasNV89115GRP-5153··OPTIONS-PPO
ENRENR-1311892026-06-11T22:50:01ZWAYNEMWARD02-01-1981UHC-83240-76•••-••-4959605-419-9098NULL9586 BASELINE RDSEATTLEWA98156·GRP-1592·options-ppo
ENRENR-1332302026-08-07T20:40:19ZKellyFHerrera01/10/1953UHC-57765-55•••-••-1193407-477-1215kelly.herrera56@icloud.com7200 Market StSCOTTSDALEArizona85274GRP-9327··OPTIONS-PPO··
ENRENR-1243102026-05-28T13:06:11ZJoshuaC··Hicks1938-10-10UHC-89302-30•••-••-0274·(545) 867-6089joshua.hicks@outlook.com4961 Harbor BlvdOrlandoFlorida··32882GRP-4898OPTIONS-PPO
ENRENR-1277562026-10-02T09:41:32ZARTHURTPARKER1971-03-13UHC-20503-28•••-••-3783(920) 760-8700ARTHUR.PARKER85@ICLOUD.COM680 Park PlaceChandlerArizona85241GRP-5991SELECT-EPO
ENRENR-1163252026-05-09T07:13:00ZAndrewK··Foster1955-10-12UHC-85895-32•••-••-6521·16394265330andrew.foster@gmail.com6503 Cedar LaneLas VegasNV89173GRP-9418MEDICARE-ADV-B
43,101 rows, page 62 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:36.695Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty