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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1265582026-09-14T23:15:42ZWEIK··GRIFFIN07/13/83UHC-18705-80•••-••-08996694114690wei.griffin@hotmail.com·6937 Union StreetHoustonTX77001-3411GRP-9904CHOICE-PLUS-PPO
ENRENR-1363382026-08-03T22:11:38ZGrace, Johnston··—·2008-02-41UHC-06724-33•••-••-9280308-456-2016GRACE.JOHNSTON@AOL.COM5768 Jefferson Ave #562FresnoCA-GRP-4537OPTIONS-PPO
TPATPA-601312026-10-15T14:45:11Zralph—washington7/6/1977N/A—N/A—3498 MEADOW LANEPlanoTX·75077·NULL··
ENRENR-1074672026-04-29T14:52:51Z·TIMOTHYZ.HALL1972-01-09UHC-51089-52•••-••-9296892.399.8932TIMOTHY.HALL@OUTLOOK.COM8662 Cedar LnAustinTX78767GRP-8842MEDICARE-ADV-A··
ENRENR-1358792026-01-29T01:58:51Z JUAANYHUGHES1994-10-24UHC8670992•••-••-7976(320) 640-4193—9070 Bayshore DrMinneapolismn·55486GRP-4055MEDICARE-ADV-A
ENRENR-1076812026-10-08T02:32:38Z—F—1992-05-19··UHC-36150-61•••-••-5096460-458-3191gary.lee45@hotmail.com3691 Lincoln WayMINNEAPOLISMN··55469-3350GRP-2061CORE-HMO
ENRENR-1027202026-09-01T11:47:38ZKAYLAAWONG1966-10-13UHC-67528-30•••-••-6788(612) 492-9138kayla.wong@hotmail.com5312 Apache BoulevardMesaAZ85242GRP-3588MEDICARE-ADV-B
ENRENR-1247482026-04-23T08:41:57ZTIMJ··DEAN·1973-10-26UHC-25505-58•••-••-7712(498) 279-0568TIMOTHY.DEAN2@GMAIL.COM5080 Camelback RoadMinneapolisMN55418GRP-0565MEDICARE-ADV-A··
TPATPA-541102026-09-16T00:42:54ZDOUGLAS—·ROBINSON11/27/1974null—·542-681-9497····9031 APACHE BOULEVARDNASHVILLETN37242GRP-2881MEDICARE-ADV-B
TPATPA-608992026-03-22T18:44:17ZMARILYN—GARRETT2001-04-05NULL—+1 505 910 5727—9623 Hillcrest RdCharlotte·NC28267—N/A
ENRENR-1123112026-07-13T06:40:18ZGloria—Rodriguez·1985-06-07UHC-88209-75•••-••-10114569949432gloria.rodriguez73@proton.me1796 Canyon RoadFresnoCA93769GRP-7945SELECT-EPO
CLMCLM-4017662026-07-23T12:36:20Z JUAN—OLSON07/18/1972UHC-11468-94null4134918263—8046 SPRING STREETCharlotteNC28286GRP-4024CHOICE-PLUS-PPO
ENRENR-1094612026-06-02T04:03:56ZLORIQWOODS1959-12-07UHC-11203-61•••-••-4330UNKNOWNlori.woods@proton.me6879 Cedar LnCharlotteNC28227GRP-9921options-ppo
TPATPA-630102026-05-25T00:02:26ZRogers, Austin——1986-07-06—•••-••-0929—UNKNOWN7743 SAGE COURTSAN ANTONIOTX78273-null
ENR ENR-1344692026-05-04T19:33:30ZisabellaPle04/04/64UHC-19469-80•••-••-7824nullisabella.le@outlook.com670 MOUNTAIN VIEW DRIVETampaFL33606-7654GRP-0626SELECT-EPO
PRVPRV-23292 2026-04-08T06:35:31ZMASON—·GARDNER1957-02-01UHC-03087-94•••-••-8562(513) 281-6326mason.gardner@proton.me1165 Oak StreetTucsonAZ85786·N/AMEDICARE-ADV-A
CLMCLM-4068822026-09-29T23:19:59ZARTHUR—BENNETT1999-10-06UHC-95087-14NULLNULL··—·9341 FOREST AVENUEDallasTX75241GRP-6987OPTIONS-PPO
ENRENR-1347062026-01-23T06:56:56ZIsabella—DavisDec 7, 1970UHC-58116-53•••-••-9105N/Aisabella.davis64@hotmail.com1670 Sunset BoulevardCharlotteNorth Carolina28253GRP-0205MEDICARE-ADV-A
TPATPA-576622026-08-13T09:21:02ZAustin·CRichards1989-08-07··NULL•••-••-1655NULL-9292 FOREST AVENUESeattleWA98168-1048UNKNOWN—
ENR ENR-1074742026-09-02T23:02:29ZChavez, OliviaU—19730115UHC-71126-91null6156628928olivia.chavez21@outlook.com5964 Meadow Lane Apt 17AtlantaGA30371GRP-8530MEDICARE-ADV-B
TPATPA-53029 2026-03-15T03:10:20ZJOSHUA—WHITE1984-09-10N/ANULLnull—8849 Harbor BlvdTempeAZ85238NULL—
CLMCLM-4212652026-08-29T23:59:18ZCHRISTIAN—HAYES3/14/1963UHC-86167-37N/A--957 CAMELBACK ROAD··TempeAZ85207·GRP-2288NAVIGATE-HMO
ENRENR-1045482026-06-28T01:08:54Zvincent—bell·05/27/1981UHC7647857•••-••-0839953.205.1986··VINCENT.BELL98@OUTLOOK.COM6419 Lake View RoadSeattleWA98163-4949GRP-5292MEDICARE-ADV-B
ENRENR-1038072026-05-22T20:05:33ZWashington, Ruth——01/01/2000UHC-31281-40—249-493-4431NULL5227 CHURCH ST··ChandlerAZ85270GRP-1624OPTIONS-PPO
CLMCLM-4188702026-10-08T07:59:38ZKathryn—Duncan·1966-07-24—null8957558703UNKNOWN-nullN/A—GRP-8419UNKNOWN
PRVPRV-285132026-08-10T13:58:28ZJoshua—·Stevens1980-10-26—•••-••-8500(737) 328-1853—9610 Washington Street #268CHARLOTTENorth Carolina28216NULLnull
CLMCLM-4304462026-10-07T21:18:16Zmariana—cook··1990-12-09··—UNKNOWN+1 507 545 4453—·7964 Bayshore DrColumbusOH43216··GRP-2733null
CLMCLM-4080082026-04-24T15:32:31ZJOEGCOLEMAN07/16/1952UHC-89912-98•••-••-6527—N/A5241 Cedar LnMesaAZ85208N/A—
ENRENR-1002392026-03-24T10:17:54ZYUKISJENKINS19731025UHC-89458-27UNKNOWNUNKNOWNyuki.jenkins23@yahoo.com2132 RIVER RD·MesaAZ··85282-7324GRP-6215CORE-HMO
TPATPA-586042026-08-15T21:57:49ZPhilip—·Ferguson1991-08-82N/A•••-••-5834348-267-0324PHILIP.FERGUSON74@PROTON.ME8344 Park PlaceHoustonTX77036-UNKNOWN
ENRENR-1075232026-03-29T06:49:09Z·edward—boyd12/17/1954UHC-10168-63•••-••-8328(778) 309-9804—4823 Pine Dr··MiamiFL33190GRP-7422CORE-HMO
ENRENR-1096252026-07-09T21:36:35ZKathyrnLCarpenter11/22/74UHC-20471-72•••-••-336712479061184kathryn.carpenter13@proton.me7653 Canyon RdLAS VEGAS··NV89153GRP-0610SELECT-EPO
ENRENR-1191872026-02-25T03:55:18ZlauraKross09/14/2006UHC-61400-78null974-887-3171N/A6409 Camelback Road·ScottsdaleAZ85292GRP-7662select-epo
ENRENR-1021032026-01-31T08:26:10ZSCOTTU·PETERS19591204UHC-54729-14•••-••-164418049583186scott.peters72@aol.com4995 Meadow LaneMinneapolisMN55428GRP-5155MEDICARE-ADV-A
CLMCLM-4041152026-03-25T04:27:12ZRAYMOND—WOOD1977-12-17UHC4343018null+1 413 645 8907N/AUNKNOWNUNKNOWNN/A—UNKNOWNMEDICARE-ADV-B
ENRENR-1313302026-10-01T12:31:19ZMartin, NicholasD—·1999-10-26·UHC3755662•••-••-282213462622258NICHOLAS.MARTIN50@OUTLOOK.COM8440 BroadwayTucsonAZ85783GRP-9953SELECT-EPO
ENRENR-1412582026-05-15T04:18:54ZkathrynF.dominguez1939-12-18—•••-••-8154557-401-6040kathryn.dominguez53@gmail.com6195 APACHE BLVDSacramentoCA95854GRP-9268NAVIGATE-HMO
PRVPRV-293622026-06-24T22:52:06ZNICHOLAS—CUNNINGHAM7/18/1971··UHC-89997-78—9848448842·-—NULLNULL·UNKNOWN--
ENRENR-1217412026-07-09T21:11:54ZPatrick—Pena2005-10-25UHC-91383-46•••-••-55455034340464—364 Oak StreetSacramentoCA95867GRP-7883CORE-HMO
ENRENR-1228562026-09-05T16:45:17ZAMBERS.CRZU1960-06-24UHC-94738-75•••-••-4732272.606.1229amber.cruz83@yahoo.com7725 Market StMiamiFL33141·GRP-9204CHOICE-PLUS-PPO
ENRENR-1224472026-09-29T22:37:43ZANDREAEBEELL1940-01-26UHC-37247-96NULL(517) 999-1466andrea.bell@gmail.com9349 Lake View RdGILBERTArizona85250-8627GRP-7249MEDICARE-ADV-A
ENRENR-1077022026-01-21T00:40:53ZDylanI.··Gibson·1946-01-45UHC-91430-31—233-840-2203dylan.gibson@proton.me3146 Forest AvenuePhoenixAZ85098GRP-2797··MEDICARE-ADV-A
TPATPA-540312026-02-12T15:58:23ZAishaCBoyd01-06-1976UNKNOWN•••-••-0224null-418 Palm DriveMiamiFL33165UNKNOWN·SELECT-EPO
ENRENR-1391852026-07-12T14:07:14ZAnn—Garrett18-12-1938··UHC-63615-33•••-••-33332218085199NULL5563 Lincoln WayHOUSTONTX77073GRP-9592CORE-HMO
PRVPRV-258842026-01-02T01:51:45ZArthur····Munoz1956-01-04NULLN/A(523) 803-5252—4160 Sage CourtTampaFL·NULLUNKNOWN—
ENRENR-1057532026-01-23T00:50:53ZWilliam—Howard·19650106UHC-75421-08NULL(661) 528-0200WILLIAM.HOWARD96@OUTLOOK.COM759 Indian School Rd·SacramentoCA95824GRP-6122MEDICARE-ADV-B
CLMCLM-4087752026-04-05T20:53:02ZGARY—JIMENEZ1976-03-26-•••-••-1838UNKNOWN··4951 Jefferson AvenueTampaFL-GRP-4120CHOICE-PLUS-PPO
ENRENR-1237432026-07-08T03:31:26ZBRITTANYWNUNEZ06/06/06UHC1368689•••-••-5418574-807-9358BRITTANY.NUNEZ9@GMAIL.COM2966 Cedar LnSeattleWA98195GRP-8023medicare-adv-a
ENRENR-1430632026-07-25T23:19:23ZalanGrodriguez1964-02-25UHC-92100-32•••-••-724112528182291null9052 Elm StreetPlanoTX··75068GRP-1605options-ppo
TPATPA-518712026-04-04T18:04:39ZJoseph—Porter1950-10-08UHC-81208-98NULL—NULL6339 VALLEY VIEW DRIVECHANDLERAZ85245UNKNOWN—
100,000 rows, page 143 of 2,000PreviousNext

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.696Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty