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
CLMCLM-4019112026-10-04T18:41:14ZtylerCwilson1987-12-11—NULL——null-UNKNOWN··NULLGRP-9766··MEDICARE-ADV-B
CLMCLM-4052262026-09-30T22:06:43ZKAYLA—WONGOct 23, 1996-—(954) 349-2668-—UNKNOWNN/A··NULLGRP-6220N/A
ENRENR-1274742026-10-13T02:53:45Z RandyJGardner1958-06-08UHC-99224-74•••-••-8033633-291-2701randy.gardner68@aol.com·3483 PALM DRIVEChandlerAZ85291GRP-7545SELECT-EPO
CLMCLM-4204922026-08-01T06:08:17ZAlan—Powell10/20/1986UHC-61794-36-17382050511null4543 Harbor BlvdSAN ANTONIOTexas78203—OPTIONS-PPO
CLMCLM-4190332026-04-07T22:57:11ZBarbara—Espinoza1953-03-07UHC-74131-02UNKNOWN927-429-7274BARBARA.ESPINOZA@GMAIL.COM1702 Lincoln WayJacksonvilleFL32214-8496GRP-6708N/A
ENRENR-1325182026-08-19T14:27:55ZKELLY—CARPENTER2004-07-26UHC6413181—(901) 559-7621-9304 Mountain View DrOrlandoFL32878GRP-0812SELECT-EPO
CLMCLM-4183102026-04-18T01:04:27ZREBECCA—YOUNG1958-07-26UHC2988099•••-••-4882—null--——UNKNOWNUNKNOWN
ENRENR-1081992026-08-17T06:48:28Z CHRISTOPHER—GEORGE08/04/1968UHC-66684-75•••-••-3818(959) 848-1439··christopher.george@gmail.com6132 CANYON RDPhoenixArizona85033GRP-3399··CORE-HMO
TPATPA-54258 2026-02-12T05:05:00Zjustin—vargas2004-09-15UHC-10790-41•••-••-9180——N/AUNKNOWNN/A-····NULL
CLMCLM-4284262026-08-06T09:27:25ZRACHELC—Mar 10, 1961-•••-••-8337UNKNOWNUNKNOWN1832 Grand AvenueSEATTLEWA98154·-CORE-HMO
CLMCLM-4296172026-07-21T20:44:07ZKevin—Patel1986-11-19UHC-81454-64NULL··——6854 Park PlSeattleWA··98140GRP-4128null··
ENRENR-1034732026-04-11T18:51:11ZJENNIFER··NHENRY1968-06-10UHC-46109-60•••-••-9393296.584.9602—4536 Camelback RdOrlandoFL32843-9979GRP-9558··CHOICE-PLUS-PPO
PRVPRV-291062026-05-22T10:02:16ZCHERYL—JORDANJun 6, 2003UHC-20575-37•••-••-41525728804657—9780 FOREST AVESan AntonioTX78296UNKNOWN·-
CLMCLM-4136652026-03-12T19:25:00Z JoshuaT··Cooper1962-10-20UHC-54359-82UNKNOWNN/A—8269 PINE DRNASHVILLE·TN37234·UNKNOWNUNKNOWN
ENRENR-1181042026-05-02T14:39:12ZCarlosRFields2005-11-05UHC-08061-71•••-••-5260UNKNOWNUNKNOWN9541 RIDGE ROADJacksonvilleFL32278-1115GRP-7938SELECT-EPO
PRVPRV-207542026-07-11T10:04:35ZJanniferC.Oliver·1972-06-16—NULL660-692-0658JENNIFER.OLIVER9@OUTLOOK.COM————--
ENRENR-1066892026-06-26T12:54:33ZJudith—Lopez05/16/02UHC-84948-25•••-••-096713307270584judith.lopez39@yahoo.com9047 BroadwayGlendaleAZ85316··GRP-1165options-ppo
CLMCLM-4135152026-09-21T17:05:49ZMEGAN—SNYDER1940-03-27··UHC-00507-08nullnullUNKNOWNnullnull———CORE-HMO
CLMCLM-4234832026-09-19T15:27:32ZHolmes, Donna——1958-03-17UHC-94194-30-(680) 224-0241—8953 MAIN STGlendaleAZ85308-—
TPA TPA-514752026-03-18T07:21:19ZBrianP.Allen··1951-05-13UNKNOWN—2622348559UNKNOWN9215 LINCOLN WAYAUSTINTX78736GRP-7803MEDICARE-ADV-A
CLM CLM-4046152026-02-06T08:09:25Z EUGENE—PERKINS1991-05-21UHC-74376-09•••-••-0748+1 409 264 0195—NULL—-UNKNOWNGRP-5892SELECT-EPO
ENRENR-1193292026-08-15T18:04:09ZCarlos—McDonald1/15/1967UHC-52759-39•••-••-9681(948) 398-4209—2056 Central AvePlanoTX75017GRP-4409SELECT-EPO
ENRENR-1219972026-08-03T20:49:15ZOmar—Hicks06/28/1994UHC-71644-16•••-••-4591968-202-3886omar.hicks@icloud.com1129 Indian School RdGlendaleAZ85347GRP-6450CHOICE-PLUS-PPO
ENRENR-1363412026-04-02T19:44:06ZJulieYBell1987-02-03UHC-17025-41•••-••-7534411-761-4121julie.bell86@proton.me8754 Indian School RdMesaaz85208GRP-0380NAVIGATE-HMO
TPATPA-594412026-09-03T19:36:13ZSAMANTHA—RAY9/3/1990··•••-••-5484—NULL464 Jefferson AveDenverCOUNKNOWN——
TPATPA-623722026-03-15T11:06:55ZLisa—Hoffman1942-01-28——····—384 MESA DRIVEJacksonvilleFL32281-9896null·OPTIONS-PPO
ENRENR-1389432026-09-15T06:29:14ZJacob—Knight··1990-08-28UHC-87545-68•••-••-60117144005082JACOB.KNIGHT5@HOTMAIL.COM831 Oak StChandleraz85270GRP-9920OPTIONS-PPO
TPATPA-633192026-02-10T10:19:03ZCarolyn—Li1943-09-13—•••-••-8239N/Anull·2737 Lake View RoadMinneapolisMN55479··NULLMEDICARE-ADV-A
CLMCLM-4174622026-04-05T01:06:54ZDanielle—Gomez1/4/1962uhc-89338-09null·496-616-9025—9496 CEDAR LNJacksonvilleFL32223GRP-8405CHOICE-PLUS-PPO
PRVPRV-245192026-04-24T18:14:54ZJerry—Foster20-12-2005null—+1 264 913 5799·-1403 Ridge RoadSan AntonioTX·78278-OPTIONS-PPO
ENRENR-1292882026-06-25T16:23:09ZJessicaNDuncan2002-02-01UHC-72847-69•••-••-8335(596) 766-5166jessica.duncan99@gmail.com3920 Bayshore DriveOrlandoFL32874··GRP-9469OPTIONS-PPO
CLMCLM-4291222026-05-31T04:49:42ZAmy—Morrison1977-02-06UHC-29243-33-—AMY.MORRISON@ICLOUD.COM4055 PALM DRIVEAustinTexas78794-OPTIONS-PPO
CLMCLM-4152742026-04-13T20:49:41ZMegan··George1978-08-01UHC-26913-97•••-••-3787+1 882 233 5553NULL·8803 Ocean AvenueScottsdaleAZ85297GRP-5477OPTIONS-PPO
ENRENR-1360752026-04-27T12:07:45ZJULIA—RIVERA1971-04-24··UHC-90037-16•••-••-9506(755) 242-9720julia.rivera86@outlook.com6720 HARBOR BOULEVARDTUCSONAZ85702GRP-0713CHOICE-PLUS-PPO
TPATPA-525992026-04-02T01:55:05ZSusn—Matthews19600604—NULL+1 409 931 0599-2622 Meadow Ln Apt 22AustinTX··78742N/ACORE-HMO
CLMCLM-4064702026-10-14T22:55:06ZStephen—Holmes1940-01-28N/A—2114154493NULL2998 Cedar LaneOrlandoFL32851GRP-8071·MEDICARE-ADV-A
ENRENR-1144342026-05-06T10:25:45ZANN—BLACK1966-05-27UHC-45653-98•••-••-7985nullANN.BLACK39@ICLOUD.COM4101 BroadwayCharlotteNC··28209GRP-8218NAVIGATE-HMO
ENRENR-1203952026-03-17T03:07:37ZPHILIPIPAYNE1950-02-15UHC-56576-45—-philip.payne@yahoo.com448 Grand AveTUCSONAZ85777GRP-6150OPTIONS-PPO··
CLMCLM-4240042026-09-25T10:31:42ZJeremy··VElliott1977-09-03UHC5556828•••-••-3939——1576 GRAND AVETucsonAZ85784NULL-
ENRENR-1102512026-10-10T19:30:12ZJerry·YClark2007-01-04UHC-90096-08-3827912874··jerry.clark@icloud.com3732 SUNSET BLVDMIAMIFL33131GRP-6820··OPTIONS-PPO··
ENRENR-1278882026-04-16T00:15:13ZLISA—LI1999-09-23UHC-04073-64•••-••-424112314798466LISA.LI7@AOL.COM6577 Ridge RoadSan DiegoCalifornia92129·GRP-3281medicare-adv-a
ENRENR-1095892026-03-07T05:31:56ZDaniel—Garcia·Jun 10, 1961UHC-93269-80—4136142747DANIEL.GARCIA@YAHOO.COM7755 Washington St·MesaAZ··85270GRP-4462SELECT-EPO
ENRENR-1197922026-10-05T20:07:31ZMason, Kathy··C—1960-02-27UHC-94661-33•••-••-9341330-597-9501kathleen.mason41@icloud.com8572 VALLEY VIEW DRTAMPAFL33620GRP-2373CHOICE-PLUS-PPO
ENRENR-1045372026-06-06T04:29:28ZMelissaV.Pakrer11-05-1965UHC-94575-53•••-••-33148563266440melissa.parker81@yahoo.com4833 Desert Sky BlvdCharlotteNC··28272GRP-1606CORE-HMO
ENRENR-1153052026-02-19T12:39:07Zdonna—warren1939-02-19UHC-24647-21—18796564687donna.warren@hotmail.com5205 VALLEY VIEW DRJacksonville··FL32217GRP-5471MEDICARE-ADV-B
TPATPA-518412026-09-25T08:29:48Z MARCUS—LITTLEMar 28, 2001··-NULL··marcus.little9@gmail.com9687 Ridge Rd·GILBERTAZ85266null-
PRVPRV-255902026-07-18T05:03:50ZMartha—Gardner11/13/1995nullN/A4033281179—5940 Pine DriveColumbusOH43207——
TPATPA-592952026-10-11T03:54:04ZArthur····Parker03/13/71NULL—·920-760-8700arthur.parker85@icloud.comN/A··—UNKNOWNN/A-SELECT-EPO
ENRENR-1280392026-10-16T16:37:45ZStephenV.·Butler09/28/1942UHC-23462-93N/A272-469-4981STEPHEN.BUTLER94@GMAIL.COM4120 Valley View DrDenver··CO··80231GRP-3477·CHOICE-PLUS-PPO
ENRENR-1114072026-01-10T15:56:02ZJim—·Ramirez27-11-2000UHC-84711-77•••-••-1677+1 729 839 8022NULL6848 Valley View DrChandleraz85290GRP-9337MEDICARE-ADV-A
100,000 rows, page 34 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:34.769Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty