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-1224072026-07-05T12:58:47ZJonathanJMcCoy02/18/2004UHC4482780-nulljonathan.mccoy@outlook.com4382 CHURCH STREETOrlando·FL32852GRP-0193MEDICARE-ADV-A
CLMCLM-4059882026-05-16T15:27:56ZDiegoJBaker1956-09-07UNKNOWN—543-998-4934N/A8180 Elm StAtlantaGA30317GRP-3331-
ENRENR-1232982026-03-26T04:24:31Z·Eugene—Graham2004-10-26UHC-44398-20•••-••-1531274.253.0457eugene.graham@icloud.com1088 MAPLE AVENUE Apt 7··FresnoCA93725GRP-9689MEDICARE-ADV-A
CLMCLM-4234562026-09-21T06:37:43ZJordan—HicksFeb 4, 1995UHC-45387-89N/A·NULLN/A2656 Mesa DriveSan AntonioTX78247·GRP-6648NAVIGATE-HMO
ENRENR-1387322026-10-09T14:20:41ZPalmer, Zachay··—1953-11-15UHC-76597-84··•••-••-5369+1 279 968 0762ZACHARY.PALMER1@OUTLOOK.COM8301 Apache BlvdLas VegasNV—GRP-1412CHOICE-PLUS-PPO
CLMCLM-4076482026-06-02T06:49:28ZkimberlyJroberts1965-01-21UHC-22451-24-(678) 597-3841UNKNOWN8007 BROADWAYGilbertAZ85287N/AMEDICARE-ADV-B
ENRENR-1188632026-08-23T11:40:54ZEvans, BobbyQ—1976-07-03UHC-75183-23•••-••-91823658364507bobby.evans@yahoo.com6622 Maple AvenueSacramentoCA95876GRP-2204CORE-HMO
CLMCLM-4306602026-02-13T21:09:37ZSchultz, JudithC—1988-10-24null—UNKNOWN—1867 Pine Dr·HOUSTONTX77077GRP-4712MEDICARE-ADV-B
ENRENR-1119232026-01-17T16:29:11ZCARLO.BARNES07-09-1949UHC-50191-73•••-••-4739(657) 295-7273carol.barnes@aol.com8051 HILLCREST ROADMiamiFL33177GRP-2138NAVIGATE-HMO
ENRENR-1221272026-06-05T16:40:01ZEric—Hernandez07-01-1959NULL•••-••-2214·(247) 498-7159N/A9634 Mountain View DrSan DiegoCA92171GRP-5887CORE-HMO··
ENRENR-1091812026-06-27T12:39:08ZJacqueline—Graham1945-12-23UHC-66972-89•••-••-6070+1 739 928 4388jacqueline.graham@outlook.com·4419 Cedar LnAtlanta··GA30363GRP-0664MEDICARE-ADV-A
PRVPRV-214772026-01-14T15:48:25ZJonathan··Bell19880222UHC-75396-89nullN/Ajonathan.bell@gmail.com4740 Forest AvenueSacramentoCA95896UNKNOWNMEDICARE-ADV-A
TPATPA-576372026-03-18T07:41:36ZDEBRAC.MATTHEWS1973-10-28—•••-••-2520357-945-9511··debra.matthews@yahoo.com3697 LAKE VIEW ROADChandlerAZ85267····UNKNOWN
CLM CLM-4088662026-07-15T02:20:32ZMari—Diaz2/22/1952UHC-71461-93•••-••-8744·-nullN/A—UNKNOWN-GRP-6943····
CLMCLM-4260722026-04-14T03:41:28Z·Emily, WardN.—1981-03-05UHC-88538-10——····—······N/A·NULLN/A
ENRENR-1157162026-04-17T17:11:16ZKEITH····RMIREZJun 19, 1954UHC-39559-25•••-••-90044842642072keith.ramirez60@hotmail.com339 BroadwayTucsonAZ85705GRP-3066MEDICARE-ADV-B
ENRENR-1027482026-09-19T18:21:54ZJack—Arnold1950-10-23UHC-31146-13•••-••-47012934952283null6818 Spring StreetColumbusOH43276GRP-4148core-hmo
ENRENR-1058982026-08-30T16:45:03ZterryHdiaz1939-05-15UHC-77144-47•••-••-248612984482979terry.diaz34@proton.me4080 Palm DrivePlano·TX75019GRP-4461MEDICARE-ADV-B
ENRENR-1351042026-06-21T17:53:55ZRayBVargas·Mar 2, 1949UHC-85125-76•••-••-885716504315259null9088 RIVER ROADHoustonTX77017GRP-9609MEDICARE-ADV-B
CLMCLM-4198922026-03-21T23:58:05Z·LuciaDThompson1985-12-14UHC-83698-89•••-••-5123243-416-6660-19 Pine DriveSan AntonioTX78223GRP-5711null
ENRENR-1270152026-09-25T05:28:02ZSEAN—HOWELL03/16/1982UHC-57319-58•••-••-3701+1 216 355 1879····9674 Park PlTempeAZ85261GRP-9194··medicare-adv-b
CLMCLM-4094672026-03-16T01:08:37ZSaraEBoyd1944-07-08UHC-17819-97•••-••-0701N/ASARA.BOYD@ICLOUD.COM6365 Sage Ct #465ScottsdaleAZ85281GRP-4026··—
ENRENR-1393222026-06-18T02:06:22ZbrandonV.·smith9/13/1954·uhc-16733-19•••-••-5039611-876-2320BRANDON.SMITH@OUTLOOK.COM8647 Park Pl··Glendaleaz85350-8181GRP-2118SELECT-EPO
CLMCLM-4096792026-04-19T19:12:29Z·Roy—Hall1952-10-16——953-514-0397NULL6334 Apache BoulevardSan Antonio·TX78254-6623GRP-4432NAVIGATE-HMO
TPATPA-606072026-02-21T09:49:39ZBETTY—·MURPHY1985-11-02-··NULL9497643betty.murphy17@yahoo.com198 Bayshore DriveLas VegasNV89134··-··-
CLMCLM-4080052026-01-06T16:07:55ZAMY····FRANKLIN1995-06-08—•••-••-2478null—2923 Washington StMesaAZ—GRP-2124null
PRVPRV-220262026-08-25T17:00:24ZCook, Priya——1956-08-04UNKNOWN·null8593901606PRIYA.COOK@ICLOUD.COM8550 Cedar LaneEden PrairieMinnesota55326-NULL
ENRENR-1085412026-06-25T10:42:38ZJORDANLCOLE·19791101UHC-83214-78•••-••-6969+1 579 439 4335null4226 Spring StreetMinneapolisMN55459-1317GRP-6517OPTIONS-PPO
ENRENR-1109832026-08-17T19:25:05ZlarryRjones·6/4/1950UHC-94064-39•••-••-4245(231) 259-2006null··6613 Jefferson AvePlano·TX75089GRP-9933MEDICARE-ADV-B
TPATPA-636612026-05-26T18:15:33ZMEGAN—VARGAS20010127NULLNULL—-7543 GRAND AVESAN ANTONIOTX78266——
ENRENR-1217872026-05-26T00:07:52ZGREGM·HAYES07/20/1975UHC-04760-22—5710718GREGORY.HAYES21@ICLOUD.COM1498 FOREST AVENUEMinneapolis··MN55452GRP-5983MEDICARE-ADV-B
ENRENR-1220492026-06-03T19:44:18ZKIETH—BURKE1951-08-19UHC-26388-23•••-••-2422725-580-6428·KEITH.BURKE65@ICLOUD.COM9829 DESERT SKY BOULEVARD·MiamiFL33192··GRP-7324NAVIGATE-HMO
CLMCLM-4002432026-01-18T20:52:47Z Gonzalez, Pamela——12/18/1996UHC-32865-94—+1 829 874 1320UNKNOWN2138 Highland AveSan DiegoCA92148··GRP-6898UNKNOWN
ENR ENR-1213422026-04-26T13:48:58ZVictoria··EDixon1943-04-03UHC-43667-50—2493842228victoria.dixon29@hotmail.com1154 MAPLE AVENUE #117LOS ANGELESCA90028GRP-3090CORE-HMO
ENRENR-1038582026-07-24T14:31:26ZHannah—YoungFeb 22, 2001UHC-12727-47··•••-••-57933338285049UNKNOWN··3496 CEDAR LNMINNEAPOLISmn55481GRP-4426··CORE-HMO
CLMCLM-4024992026-03-25T19:14:16Zbrandon—jenkins1994-08-01NULL•••-••-7631-—1660 Palm DrScottsdaleAZ85209GRP-8564OPTIONS-PPO
TPATPA-612302026-07-07T09:05:31ZELIZABETH··WEAVER1985-07-09UHC-21629-88—NULLN/A2357 OCEAN AVENUESan Antonio·TX78239GRP-9943····
ENRENR-1320132026-08-02T17:02:49ZABIGAIL—LUNA1940-11-08·UHC-74464-69•••-••-9590—abigail.luna@outlook.com4651 Hillcrest RoadJACKSONVILLEFL32238GRP-5936OPTIONS-PPO
CLMCLM-4099182026-05-09T09:31:38Z Cllins, Gerald——May 28, 2008NULL•••-••-5410466-335-8492N/A4668 Oak StreetGlendaleArizona85381-CORE-HMO
CLMCLM-4142582026-07-13T13:26:06ZROY—ROMERO1969-09-17UHC-60685-91——-31 MEADOW LANEDenverCO···80253—CHOICE-PLUS-PPO
ENRENR-1224772026-04-23T11:58:19ZFord, Jordan·A—1978-07-12UHC-27315-41•••-••-2960(978) 299-2078—1158 Oak StreetMINNEAPOLISMN55427GRP-2039MEDICARE-ADV-A
ENRENR-1329552026-05-24T20:48:21ZTeresa—King1990-05-17UHC-80583-96•••-••-4107··teresa.king@proton.me6395 Ocean AvenueEden PrairieMN55348GRP-5512NAVIGATE-HMO
ENRENR-1130532026-07-06T15:12:30ZAlan H—Nunez·2003-08-05UHC-53813-83•••-••-4498+1 943 330 5822ALAN.NUNEZ@GMAIL.COM6551 Maple AveTampaFL33644GRP-8882CHOICE-PLUS-PPO
CLMCLM-411933 2026-05-29T22:07:34ZAna··—Mejia2/18/1990UHC3565903N/ANULLNULL8489 River RoadSAN DIEGO··CA92143-MEDICARE-ADV-A
TPATPA-508152026-08-27T20:13:07ZGABRIEL—HANSON07/24/81——828-645-3056—UNKNOWNUNKNOWNUNKNOWN———
ENRENR-1415902026-07-02T02:17:41ZJasonSBailey02/16/1938·UHC-32640-85•••-••-6898·19479647321jason.bailey98@gmail.com4995 Harbor BlvdMinneapolis·MN·55463GRP-3135CORE-HMO
ENRENR-1228192026-04-20T14:34:54ZDennisU.Carroll1943-02-20UHC-89739-33•••-••-5171(284) 717-7644DENNIS.CARROLL@PROTON.ME7211 BroadwayGLENDALEAZ85375GRP-6697··MEDICARE-ADV-B
ENRENR-1187962026-06-25T06:44:44ZmarcusJlewis1945-02-07uhc-54523-19•••-••-5010(754) 918-5266marcus.lewis27@aol.com4802 JEFFERSON AVETampaFL33648GRP-8436CORE-HMO
CLMCLM-4060182026-07-22T16:31:17ZKayla—Bell1982-09-18-NULL—kayla.bell@proton.meNULL-null-GRP-9363NULL
TPATPA-511132026-01-12T01:54:38ZPerez, EmmaA.—1997-09-25—•••-••-7416NULLNULLUNKNOWN—UNKNOWN·N/A—N/A
100,000 rows, page 97 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.804Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty