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-1121892026-04-10T15:31:57Z·ALBERT—RIKE···1957-07-16UHC-95181-81•••-••-9380(794) 414-3535albert.rice@gmail.com1926 Pine DriveOrlandofl··32812GRP-4928MEDICARE-ADV-B
CLMCLM-4277012026-08-04T04:48:11ZKatherine—West2001-01-25—•••-••-3139(670) 791-8648UNKNOWN798 Central AvenueDallasTX75213GRP-4302·N/A
ENRENR-1046842026-04-21T19:06:15ZJenny—Stone19670928UHC-35688-48•••-••-6020330-241-6855UNKNOWN2372 Meadow LnMinneapolisMN55489GRP-7521OPTIONS-PPO
PRVPRV-216592026-06-10T01:51:04ZRoy—StephensMar 23, 2007UHC-69885-63—(451) 403-8073-9170 Cedar LnDenverCO80227N/A—
CLMCLM-4284492026-05-19T15:21:43ZcamilaA·oriz19750325UNKNOWN•••-••-7249--2942 Lake View RoadColumbusOH43224null—
PRVPRV-267342026-08-06T15:21:55ZWalsh, Joseph——1997-05-25UHC-54154-91•••-••-4505(229) 637-7020———UNKNOWN—UNKNOWN-
CLMCLM-4283532026-05-19T03:32:50ZThompson, Keith——1963-12-21null—·826.669.3309—6960 Indian School RdJacksonvilleFL32274-5440GRP-5198··UNKNOWN
CLMCLM-4321682026-06-09T18:31:46ZLoganMMorrisonNov 8, 1992UNKNOWN•••-••-9958——7541 Canyon RoadPhoenixAZ85043GRP-3171MEDICARE-ADV-B
ENRENR-1378312026-05-10T11:46:56ZAlanZNelson1978-07-11uhc-35440-27•••-••-7509736-515-2908alan.nelson@yahoo.com1155 Lincoln Way #321CharlotteNC28209GRP-5968OPTIONS-PPO
CLMCLM-4008552026-09-10T23:12:32ZCROL—PORTER9145-05-28——(503) 834-8350—3041 Market StGlendaleAZ85302GRP-5076-
CLMCLM-4184482026-06-12T19:40:44ZScott—Alvrado21-09-1974UHC-03782-04N/A964.929.7388—5896 HILLCREST RDGlendaleAZ—NULLNULL
CLMCLM-4072082026-01-14T18:52:39ZRUSE—BRENDA1958-08-04UHC-21607-07—714.731.4899—6353 Apache BoulevardMiamiFL33144—OPTIONS-PPO
ENRENR-1066422026-02-01T21:45:14ZRachelSEdwardsDec 15, 1988·UHC-16184-77•••-••-6938827.702.3194rachel.edwards@icloud.com9657 UNION STREETMinneapolismn55431GRP-5132NAVIGATE-HMO
ENRENR-140991 2026-05-14T00:17:06ZMatthew M.—Ford02/01/1990UHC-10639-59•••-••-472515498932696-4359 Oak StPLANOTX75087GRP-7405SELECT-EPO
TPATPA-601952026-07-04T14:25:22ZBarbara··Simmons1958-11-02—NULL-BARBARA.SIMMONS28@OUTLOOK.COM5646 Indian School RoadLas VegasNV89124——
CLMCLM-4184082026-10-02T04:21:16ZAARON—JONES1992-10-01UHC-48188-28•••-••-2177nullUNKNOWN——-—NULLNAVIGATE-HMO
TPATPA-509802026-09-23T00:46:52ZLUCIA—ESPINOZA1971-11-16—NULLN/AN/A2739 UNION STREETColumbusOH43207—MEDICARE-ADV-B
CLMCLM-4184472026-09-10T08:42:11ZMaria—Castillo10/06/55UHC-23443-73NULL3365926NULL3511 Ocean AveSEATTLE·WA98161—OPTIONS-PPO
CLMCLM-4083502026-06-21T18:54:06ZFields, Mariana——1960-11-22UHC-96749-28—(602) 228-5654-3511 Main StPhoenixAZ85023··GRP-1044—
ENRENR-1019502026-07-13T00:44:04ZBOBBY—GONZALES1975-08-07UHC-06949-29··•••-••-34698695564134BOBBY.GONZALES89@YAHOO.COM6370 Mesa Drive·NashvilleTN37235GRP-4841CORE-HMO
ENRENR-1054512026-01-26T14:13:55ZJoseph—·Wright4/20/1976UHC-09052-51•••-••-2685·7436136113JOSEPH.WRIGHT27@ICLOUD.COM2096 Willow CourtTampaFloridaNULLGRP-0372CHOICE-PLUS-PPO··
TPATPA-533852026-08-15T19:32:56Z·MARCUS—JONES1952-02-04——nullmarcus.jones@icloud.com9174 Indian School RoadTampaFL33621·GRP-9962—
CLMCLM-4025502026-09-23T12:25:24ZJORDAN—PORTER·1970-07-21UHC3527091—NULLUNKNOWN214 Washington StLos AngelesCA—GRP-1208null
ENRENR-1172652026-10-08T18:22:21ZRONALDD·DANIELS1943-03-18··UHC9552906•••-••-1177——2498 Oak St Apt 33Plano··TX75033-7895GRP-1676SELECT-EPO
ENRENR-1365112026-03-19T01:41:01ZSantiagoKFord10/19/1979UHC-63013-92•••-••-7901729-549-1469santiago.ford@icloud.com7019 Camelback RdTEMPEAZ85250··GRP-1372NAVIGATE-HMO
ENRENR-1334112026-08-31T13:37:37ZBARBARAS.PARK1985-10-03N/A•••-••-6657(789) 276-5182barbara.park83@icloud.com796 Market StreetGilbertAZ85286GRP-5646CHOICE-PLUS-PPO
TPATPA-575932026-03-22T18:55:36ZMaria—Ryan3/1/1965N/A-·NULLMARIA.RYAN@ICLOUD.COM8437 Lake View RdAtlantaGA30370—CHOICE-PLUS-PPO
ENRENR-1093112026-05-18T10:26:05ZEvans, Doris—··05-06-1949uhc-49358-35•••-••-07226204624184doris.evans73@aol.com3326 Forest AveORLANDO··FL32805GRP-6905SELECT-EPO
ENRENR-1263302026-08-20T14:02:58ZNICHOLAS—·SANCHEZ04/16/1985UHC-24197-12•••-••-7072(205) 496-0238—3184 Canyon RdSan AntonioTX78264GRP-9470CHOICE-PLUS-PPO··
CLMCLM-4286252026-08-14T19:24:34ZDouglas—Kelly·05/25/95UHC-63043-26—9644424332N/A9857 Washington StreetCharlotteNC28231GRP-6952N/A
TPATPA-523572026-05-15T05:55:08ZMery—Ramirez1961-03-28UNKNOWNnull(684) 620-5137N/A1794 Cedar LnJACKSONVILLEFL32277··NULLCHOICE-PLUS-PPO
TPA TPA-600802026-01-04T15:19:55ZMendoza, Arthur——1978-08-19--—····4435 Sage CtTampaFlorida33615—UNKNOWN
ENRENR-1364382026-02-01T18:50:30ZChristinaX.Estrada1969-02-07UHC-05394-63•••-••-0290(257) 574-3192CHRISTINA.ESTRADA@HOTMAIL.COM5680 Canyon RdNashvilleTN37201·GRP-9863CORE-HMO
CLMCLM-4044752026-01-07T15:38:21ZBilly····Barnes1995-06-25-——NULL3035 CHURCH STTampaFL33672GRP-6960N/A
ENRENR-1204602026-09-07T10:53:45ZParker, Olivia——1982-07-27UHC-73080-77•••-••-00896079777656OLIVIA.PARKER98@ICLOUD.COM4826 Cedar LnGlendale·AZ85360-6376GRP-4741NAVIGATE-HMO
TPATPA-556322026-04-26T07:31:56ZBaker, Camila····—1946-03-09—•••-••-6227900-957-8885··NULL815 Ocean AveLas Vegasnv89195—··
ENRENR-117021 2026-09-04T13:06:10ZELIJAH—MEYER1957-01-17UHC-22809-59•••-••-57654544298303elijah.meyer88@yahoo.com1014 Mountain View DrAtlantaGeorgia30316GRP-1994CHOICE-PLUS-PPO··
ENRENR-1401862026-01-26T23:39:48ZMaldonado, JohnV—1943-04-02UHC-04570-68•••-••-7804(501) 269-9231JOHN.MALDONADO@GMAIL.COM1029 Sage CtMesaArizona85211GRP-2167SELECT-EPO
PRVPRV-265572026-08-17T07:57:30ZMELISSA—MORGANSep 11, 1992UHC-68202-82•••-••-7770+1 850 264 6613··—7009 Harbor BlvdTampaFL33665NULLNAVIGATE-HMO
ENRENR-1127372026-05-18T12:29:09ZGray, Kayla··W.—1963-10-09UHC-69276-35•••-••-2762697-749-6815—9706 Lake View RdSCOTTSDALEArizona85214GRP-7909MEDICARE-ADV-A
CLMCLM-4209352026-04-26T19:10:07ZTimothy—VasquezAug 16, 1946UHC-40176-50•••-••-5279+1 897 227 1401null———-N/A-
ENRENR-1235652026-08-25T11:53:09ZAlanP.Hanson1999-01-27UHC-37725-42•••-••-7322438-996-7162alan.hanson@yahoo.com3378 Ridge RdLos AngelesCA90009GRP-2146MEDICARE-ADV-B
CLMCLM-4202332026-01-18T21:10:31ZKARENQ.RUIZ08/01/43uhc-25421-25N/A19193230121UNKNOWN··5995 Sage CourtAustinTX78782GRP-6459—
CLMCLM-4108852026-08-17T06:49:46ZBruce—Perkins19970411UHC-22797-74—988-605-6822—2502 CHURCH STREETOrlandoFL32874·N/ANULL
CLMCLM-4092102026-10-08T08:00:16Z JEFFREYPCLRAK22-10-1962UHC-45965-92•••-••-3321·945-338-0672——UNKNOWNnull—UNKNOWN··UNKNOWN
CLMCLM-414681 2026-01-10T23:36:49ZJAMES—WANGMay 28, 1961N/A•••-••-19229628729254NULL39 GRAND AVESeattleWA98186GRP-9496CHOICE-PLUS-PPO
CLMCLM-4202442026-06-25T00:07:48ZETHAN—BOYD19901217··null··——nullUNKNOWN·N/ANULLNULLGRP-1165NULL
CLMCLM-4196182026-03-14T12:46:47ZAaron—·Berry3/4/1972·nullnull——3935 Market StreetChandlerAZ85286-null
ENRENR-1041502026-09-01T23:45:42ZMariana—Collins1966-09-24UHC-57189-74•••-••-466817359498191null9011 Pine DriveJacksonvilleFL32277GRP-4009SELECT-EPO
PRVPRV-209612026-01-21T02:04:41Zjeremy—torres1982-06-17··UHC-01486-09—N/AUNKNOWN8802 Jefferson AvenuePlanoTX75017-NAVIGATE-HMO
100,000 rows, page 144 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