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-4128402026-10-08T19:17:13ZRyan—Grant9/27/1989—•••-••-4542NULLN/A6174 Valley View Drive #604TucsonAZ85708NULLCHOICE-PLUS-PPO
ENRENR-1076742026-08-10T14:35:12ZRUTH··Y.STEPHENS11/26/1956UHC-49733-39•••-••-1177(416) 288-1086ruth.stephens@icloud.com3218 Grand AvenueDenverCO80292GRP-1630SELECT-EPO
ENRENR-1029202026-02-19T23:47:06Zanthony—wong1939-02-17UHC-96640-09··—(292) 341-7071UNKNOWN4634 Sage CourtFresnoCA93703GRP-0384NAVIGATE-HMO
ENRENR-1242652026-01-21T18:26:31ZLoganIWagner·Mar 2, 1977UHC-44134-51•••-••-21914549516436LOGAN.WAGNER83@PROTON.ME289 Willow Ct··TempeAZ85227GRP-2578MEDICARE-ADV-B
ENRENR-1059142026-03-24T15:16:10Z·Heather—Soto1972-04-28UHC9294991null974-255-9371·HEATHER.SOTO10@PROTON.ME4780 UNION STREETTampaFL··33662GRP-9463CORE-HMO
PRVPRV-283692026-09-05T05:52:46ZJoyceD··Cooper2000-04-03UHC-90049-06··8408126761UNKNOWN459 Cedar LnColumbusOH43270NULLSELECT-EPO
ENRENR-1406992026-08-21T16:08:30ZNATALIE—MEDINA1963-09-06UHC-05268-08•••-••-3886+1 489 329 4533natalie.medina@proton.me6281 CAMELBACK RDHoustonTX77024GRP-3583OPTIONS-PPO
ENRENR-1159292026-09-25T06:10:16ZDANIEL—HANSEN12/22/42UHC-80355-44•••-••-1717(286) 811-8561·DANIEL.HANSEN@ICLOUD.COM5594 Willow CtTampaFL33655GRP-3600OPTIONS-PPO
CLMCLM-4249352026-01-21T19:32:28ZJeffrey··Jenkins1105-19-92UHC-38887-29•••-••-8891839-989-8724-413 Baseline RdHoustonTX77084·GRP-4612N/A
ENRENR-1093512026-07-21T21:49:16ZBenjamin—Walsh1972-04-04N/A•••-••-78822207615819null9852 Ridge RdPhoenixAZ85033GRP-5461CHOICE-PLUS-PPO
PRVPRV-238402026-01-27T08:05:03ZARJUNCCRUZJan 18, 2002—-(761) 478-0340····2954 Palm DrEDEN PRAIRIEMN55315N/A—
PRVPRV-217092026-06-11T20:48:19Z ·MADISON—FOSTERMar 28, 1955UHC6306807N/A+1 679 972 7683madison.foster23@outlook.com8828 Spring StAtlantaGA30393UNKNOWNN/A
ENRENR-1138232026-04-17T19:46:03ZJoshuaGPowell2004-11-10UHC4486916•••-••-6597·18142274678JOSHUA.POWELL@YAHOO.COM5876 Mountain View DrTampaFL33699GRP-3791MEDICARE-ADV-B
TPATPA-565432026-06-19T23:22:16ZGonzalez, Debbie——19451114NULL--—3485 Desert Sky Blvd Apt 21SEATTLEWA98153GRP-9960UNKNOWN
ENRENR-1334772026-05-29T02:04:52ZSHIRLEY··PRICE1995-09-17UHC-74361-22•••-••-2586511-585-3654shirley.price@outlook.com1106 Park PlGilbertAZ85257GRP-0572MEDICARE-ADV-B
ENRENR-1000752026-08-06T03:46:37ZCarlosLVazquez··Jun 14, 2002UHC3336789•••-••-8050(447) 795-0657carlos.vazquez81@aol.com5250 Central Ave·GlendaleAZ85368GRP-4583··CHOICE-PLUS-PPO
ENRENR-130182 2026-02-05T17:27:22ZTeresa—Chavez1980-12-08UHC9147266•••-••-50213717833852TERESA.CHAVEZ24@PROTON.ME2318 Harbor BlvdMesaAZ85214GRP-8053CORE-HMO
CLMCLM-4181962026-04-22T04:25:23ZJAKE—LITTLE1952-04-05UHC-83659-74NULL+1 337 539 2416NULL6539 BROADWAYPhoenixAZUNKNOWN—NAVIGATE-HMO
TPATPA-598552026-06-29T03:31:56ZWAYNE—THMAS·02/10/54UHC-60306-66··•••-••-1255UNKNOWNN/A4016 JEFFERSON AVENUESeattleWashington·98168GRP-2398-
ENRENR-1015772026-08-01T16:29:35Z anaC·hughes24-10-1953UHC-80738-36•••-••-4314(803) 568-4704··ana.hughes@icloud.com····NULL—UNKNOWN·GRP-3186CORE-HMO
ENR ENR-1180102026-07-24T09:46:27ZBailey, StephenA—·2/22/1994UHC-72645-22•••-••-51209798374715stephen.bailey60@icloud.com5482 INDIAN SCHOOL ROAD··ScottsdaleAZ85256GRP-1938CHOICE-PLUS-PPO
ENRENR-1039892026-09-29T19:22:11ZValentinaS··Banks1954-05-17UHC9505493•••-••-653114526099548valentina.banks27@hotmail.com7203 Palm Dr··AtlantaGA30397GRP-3711··OPTIONS-PPO··
TPATPA-519462026-05-17T22:50:49Z·DAN—CARROLL09/22/08N/AN/A·NULLdaniel.carroll@proton.me4534 Highland AveCharlotteNC28286—UNKNOWN
ENRENR-1346762026-06-04T05:38:41ZDORIS—RIVERA21-02-1969UHC-42495-13N/A(263) 524-6876DORIS.RIVERA@OUTLOOK.COM5068 Mesa DrSAN DIEGOCA92185GRP-2668MEDICARE-ADV-A
CLMCLM-4009662026-09-01T16:44:49ZMary—Willis1939-06-26UHC3926651N/A(336) 358-9981nullNULL—nullNULLGRP-1982—
ENRENR-1016442026-06-07T18:46:11ZJudithGWang2007-11-09UHC-93998-66—4153175333judith.wang@gmail.com1337 Maple AveAtlantaGA30392GRP-3892OPTIONS-PPO
ENRENR-1036912026-03-27T06:40:29ZPena, KimberlyO—28-05-1982UHC-27784-32•••-••-57239612391659kimberly.pena@proton.me2968 Sage Ct··Las VegasNV89108GRP-4526MEDICARE-ADV-A
ENRENR-1017562026-04-21T19:38:12Zarjun—gardnerAug 28, 1987UHC-24635-15··•••-••-8494487-830-3467arjun.gardner@proton.me7270 BAYSHORE DRDENVERColoradoN/AGRP-0348SELECT-EPO
ENRENR-1079262026-09-23T09:01:55ZPriya—Harvey1989-08-15UHC4105047•••-••-0865598-261-1718PRIYA.HARVEY@YAHOO.COM3080 Apache Boulevard Apt 31DallasTXnullGRP-3151OPTIONS-PPO··
TPA TPA-523552026-07-26T04:28:02ZSean—Collins6/27/1995UHC-91688-56•••-••-5792-—3968 Elm StChandlerAZ85206-8091——
CLMCLM-4291102026-02-20T07:27:00Zchristopher····stevens19920921-•••-••-7154—N/A6186 ELM STREETPlano··TX75006nullMEDICARE-ADV-B··
TPATPA-542622026-03-18T20:24:35ZJERRY—NELSON2005-05-26UHC-34021-91—NULLjerry.nelson40@gmail.com4180 Apache BoulevardCharlotteNC28250NULLnull
ENRENR-1037352026-06-10T02:20:30ZHANNAHLYOUNG1963-06-13UHC-10405-78-4882650160HANNAH.YOUNG2@ICLOUD.COM1395 PARK PLACEDenverCO80298GRP-4360SELECT-EPO
ENRENR-1341662026-01-29T19:55:43ZMorgan, AnthonyY—09/05/2001UHC-23469-62•••-••-9761266-270-0298anthony.morgan@outlook.com5791 Indian School RdSCOTTSDALEAZ85231GRP-1140MEDICARE-ADV-A
ENRENR-1251172026-04-18T08:45:02Znancy··O.·vargas5/21/1947UHC-55764-99•••-••-3288(943) 820-6881nancy.vargas15@proton.me2475 Church StCHANDLERAZ85251GRP-5460OPTIONS-PPO
PRVPRV-200552026-06-29T13:44:45ZAnnNFlores1978-10-19UHC-43456-24··367-432-7305—5599 BroadwayNASHVILLEtn37234UNKNOWN—
TPATPA-531192026-08-23T10:18:32ZRachel—Jacobs··1987-04-14UHC-12610-08-——2993 UNION STREET·SAN ANTONIO·TX78219·GRP-4742·OPTIONS-PPO
ENRENR-1055532026-08-21T03:16:59ZDonnaB.Williams06/25/1984UHC-10270-99•••-••-5858425.231.4592DONNA.WILLIAMS39@AOL.COM5938 Ridge RoadGlendaleAZ85390GRP-2723MEDICARE-ADV-B
TPATPA-630982026-05-27T06:23:13ZDelgado, Amber——1972-11-06N/A•••-••-1666N/Aamber.delgado72@aol.com1854 Union StreetSeattleWA98150GRP-0451MEDICARE-ADV-B
TPATPA-605922026-04-07T08:29:52ZBRIAN—LUNAFeb 17, 2000··-N/ANULLbrian.luna81@aol.com2217 Indian School RdMinneapolisMN55411N/AUNKNOWN
ENRENR-1000352026-02-05T09:18:42ZJeremy··I.Carlson··19390319UHC-49717-27•••-••-02067576890394jeremy.carlson36@icloud.com255 BROADWAYSCOTTSDALEAZ85248GRP-7006NAVIGATE-HMO
TPATPA-621432026-05-27T17:31:53ZKimberly··—Robertson11/18/1940··nullUNKNOWNUNKNOWN9549 Apache BoulevardTempeAZ85296····-
TPATPA-531752026-01-26T08:27:14Z Frank—Snchez1941-11-17UHC-19954-35——N/A2748 Sage CtSeattle·WAN/Anull····
ENRENR-1059792026-04-20T10:57:49ZRickXLittle1942-10-15UHC-26075-48•••-••-5412746-343-3858NULL·2180 Baseline RdSAN ANTONIOTX78230GRP-6525CHOICE-PLUS-PPO
CLMCLM-4195022026-10-17T08:58:52ZLarry—Banks·May 21, 1947UHC-47014-15null—N/A7288 MESA DR Apt 29·SacramentoCA95840GRP-5849MEDICARE-ADV-B
CLMCLM-4187092026-07-03T14:53:23ZAna··—Burton·3/20/1972UHC-36574-30——N/A3854 Spring StreetChandlerAZ85266N/ANULL
TPATPA-569472026-04-20T16:09:49ZcamilaA··marshall1956-12-09nullNULL13347020523—6341 Baseline Rd·PhoenixAZ·85066N/Anull
ENRENR-124267 2026-09-03T13:40:54ZPerezZRalph1971-05-24UHC-58602-73N/A··927-974-8279RALPH.PEREZ37@YAHOO.COM7671 APACHE BOULEVARDJacksonvilleFL32257GRP-9921MEDICARE-ADV-A
ENRENR-1084052026-03-10T03:40:30ZFrank Y—Simpson11-09-1946··UHC-30318-98·null437-901-1316frank.simpson67@aol.com1478 Grand AveHouston·TX77069·GRP-2153SELECT-EPO
PRVPRV-214382026-03-21T13:21:48ZKmiberlyJWillis1954-04-24null-(227) 434-0284—5805 Park PlaceSAN DIEGOCA-NULL—
100,000 rows, page 96 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