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-1149982026-05-15T14:18:21ZAISHA—WILLIS·1961-04-17UHC-57295-06•••-••-7368(929) 291-2990null5745 CANYON RD #441PHOENIXAZ85072GRP-9533NAVIGATE-HMO
TPATPA-518352026-09-06T12:47:39ZWelch, Dorys——1950-07-19--4428915456doris.welch72@gmail.com2676 Forest AveHOUSTONTX77070—-
CLMCLM-4274762026-09-29T06:51:18ZMARGARET—GONZALES1981-02-10UHC-59119-32UNKNOWN·831-731-1167UNKNOWN6102 VALLEY VIEW DRORLANDOFL32807-MEDICARE-ADV-A
CLMCLM-4131122026-03-09T19:50:30ZCarolG.Fowler04/09/1995UHC-12538-47NULL+1 227 516 8933··—7684 Lincoln WaySacramentoCA95821nullMEDICARE-ADV-A
ENRENR-1200412026-08-19T23:14:00ZBrittany—Morris20010110UHC-21353-51•••-••-1368467-340-4072brittany.morris@aol.com205 SUNSET BOULEVARDHoustonTX77032GRP-7575NAVIGATE-HMO
CLMCLM-4169282026-06-11T16:54:12ZALEXANDERHGRAYMay 1, 1940UHC-74703-60··UNKNOWN—alexander.gray@yahoo.com2104 Apache BlvdNASHVILLETN37207GRP-3053null
CLMCLM-4138422026-03-08T10:13:08ZJonathan··—Nguyen1955-06-07N/AUNKNOWNN/ANULL—UNKNOWN····——N/A
PRVPRV-239732026-02-15T13:51:18Zfrank—baker1990-09-08--774-260-1092·UNKNOWN2429 Sage CtGlendaleAZ85307-3547—-
ENRENR-1118382026-01-29T22:05:48ZJohn·V.Andrews1960-09-20UHC-04984-49•••-••-8157N/Ajohn.andrews@aol.com8168 LINCOLN WAYDallas·Texas75234GRP-6883NAVIGATE-HMO··
CLMCLM-4278552026-05-18T07:22:12ZSara—Hawkins02/02/86-•••-••-4742+1 926 290 1022UNKNOWN1415 Ocean AveAtlanta·ga30337GRP-0717NULL
ENRENR-1075332026-03-11T00:50:10ZSharonE.··WestNov 11, 1984UHC-67402-41•••-••-8907(941) 675-1364·sharon.west@yahoo.com—-UNKNOWNN/AGRP-9511CORE-HMO
ENRENR-1065422026-03-09T01:39:51ZOLIVIA—CHAPMAN1981-10-02··UHC-99104-40•••-••-98518042210204null——N/ANULLGRP-8822SELECT-EPO
ENRENR-1376092026-08-24T07:52:28ZChristinaNDunn1942-03-01UHC-82313-51•••-••-5280+1 647 611 4354christina.dunn99@hotmail.com6848 Market StAtlantaGA30334GRP-2690·CHOICE-PLUS-PPO
ENRENR-1159162026-07-09T19:16:11Z———02/26/1972UHC-22368-01•••-••-5602(606) 706-0238nathan.griffin@hotmail.com3469 Park PlaceTampaFL33622GRP-9922CHOICE-PLUS-PPO
TPA TPA-567872026-09-16T03:45:44Zjack—barnes1979-04-24N/AN/A7666769332jack.barnes@hotmail.com3185 Washington StreetLas VegasNV89125-5486GRP-6648—
PRVPRV-200072026-09-05T17:05:38ZNANCY—CAMPBELL1991-05-20····733.238.1159N/A3517 Baseline RoadJACKSONVILLEFL·32266NULLMEDICARE-ADV-B
CLMCLM-4297872026-01-15T16:31:15Zheather—·ramirez1984-02-13UHC-38315-81N/A·NULL··7274 HILLCREST RD··NashvilleTN37213NULLNAVIGATE-HMO
ENRENR-1378652026-10-05T23:44:55Z·AISHA·W.HUDSON1969-07-28··UHC-06355-21•••-••-8494351-593-0306aisha.hudson91@gmail.com7330 Sunset BlvdTucsonAZ85756GRP-4735MEDICARE-ADV-A
ENRENR-1371522026-04-24T05:36:35ZMaarcusGJenkins1968-02-28UHC-53827-50•••-••-087317907852675MARCUS.JENKINS64@AOL.COM8251 Sunset BoulevardSan AntonioTX78266·GRP-4654CHOICE-PLUS-PPO
CLMCLM-4029892026-07-18T18:35:32ZGaryH···Cook1969-06-01——15615335122NULL6769 CENTRAL AVELas VegasNV89148GRP-2375—
ENRENR-1093122026-04-05T16:56:36ZBradleyHWeaver1985-04-15UHC-93569-57•••-••-6204+1 593 663 3482-6249 Ridge RdJacksonvilleFL—GRP-1603NAVIGATE-HMO
CLMCLM-4261942026-01-05T10:55:41ZJudy—Day1976-03-09··UNKNOWNUNKNOWN7418337789—N/A····——GRP-2100·N/A
ENRENR-1238902026-07-22T03:08:03ZAISHAY.PARKER1986-02-03UHC-97880-87•••-••-4730482-634-6233aisha.parker@proton.me764 INDIAN SCHOOL RD·Eden PrairieMNUNKNOWNGRP-5324SELECT-EPO··
TPATPA-626122026-04-29T01:33:05ZOlivia—Jenkins1989-09-09—N/ANULLnull—·-——N/ASELECT-EPO
PRVPRV-291532026-05-20T14:17:08Z JOSSHUA—GUERRERO19630904N/A—··UNKNOWN7674 Baseline RoadDALLASTX75246-—
TPATPA-616812026-07-08T03:25:16ZWilliamT.··Cruz·1968-06-02UHC-40984-50null—NULLNULL··—UNKNOWNGRP-1971—
CLMCLM-4104962026-02-20T21:40:25ZDaniel—Hawkins··2006-06-15··UHC-93697-01•••-••-4435N/AN/A·6882 Harbor Boulevard·GilbertAZ85221GRP-6477CHOICE-PLUS-PPO
ENRENR-1172702026-05-14T03:19:36ZaustinYmorrgan1982-12-01UHC-70663-96•••-••-6128622-670-9815austin.morgan@icloud.com6776 Sunset BlvdChandler··AZ85258GRP-3117OPTIONS-PPO
TPATPA-530582026-05-05T00:26:45Z DOUGLASRPETERSON13-05-1980—•••-••-1441N/A-null····——null—
CLMCLM-4325562026-10-16T18:02:04ZSANDRAMSCOTT1974-11-01UHC-00116-94•••-••-9878(411) 580-8782N/A3389 Harbor BlvdLas VegasNV·89158-9670UNKNOWNnull··
CLMCLM-4264162026-02-02T15:41:38ZARTHR—HOLMES1979-10-16uhc-61995-62NULL(400) 583-4862-6471 MEADOW LANEAustinTX··78734—MEDICARE-ADV-B
CLMCLM-4251422026-02-12T00:30:09ZGerald—Watson1959-09-14N/A-N/A··gerald.watson@icloud.com9473 Palm DrChandlerAZ··—-NAVIGATE-HMO
CLM CLM-4089422026-01-02T08:57:16ZSusan—Garrett1939-08-02uhc-86282-68··•••-••-7369+1 679 559 3135N/A4507 Ridge RdDenverco80256NULLCHOICE-PLUS-PPO
ENRENR-1043382026-07-26T19:00:39ZGLORIA—RYAN1955-07-08UHC-01082-27•••-••-6622·579.237.2085-4221 Forest AveTEMPEAZ85292GRP-4923MEDICARE-ADV-B
CLMCLM-430442 2026-01-16T10:46:37ZGERALD··—ANDERSON8/3/1999···UHC-60914-75N/A(780) 908-5422gerald.anderson18@icloud.com·6481 Lake View RoadMesaAZ85283GRP-3457—
TPATPA-602852026-06-06T14:53:41ZCHARLES—LI1987-12-15··-N/Anull-UNKNOWNUNKNOWNNULLGRP-8496—
CLMCLM-416640 2026-07-18T20:59:00Z·Ruiz, RalphQ—1954-06-03NULLnull368-826-4206null·777 Lake View RdFRESNOCA93760····MEDICARE-ADV-B
CLMCLM-4322052026-01-08T16:51:23ZMarcVAllen1984-07-06—•••-••-3252787-212-4274NULL474 Harbor Boulevard Apt 5Eden PrairieMN55391—OPTIONS-PPO
TPATPA-579852026-08-24T12:01:13ZZACHARY—MALDONADO1987-02-22N/ANULL489.987.7427ZACHARY.MALDONADO@YAHOO.COM—null—····null····
PRVPRV-207102026-01-28T03:05:01ZGrace—Mills1984-07-03UHC-19336-64•••-••-37152662329785grace.mills@icloud.com1298 MAIN STREETTempeArizona85217UNKNOWNOPTIONS-PPO
CLMCLM-4289032026-05-23T01:06:02ZWilliam·····Carpenter1948-06-03···NULL•••-••-6281—UNKNOWN9388 MARKET ST··TempeAZ85270GRP-5732CHOICE-PLUS-PPO
CLMCLM-4033162026-06-05T21:38:05ZSCOTT—BARNES1999-01-19—•••-••-2041687-739-6692-8037 Forest AvenueChandlerAZ85280UNKNOWN—
ENRENR-1427422026-09-22T01:08:33ZMateo—Harvey1961-06-08UHC-46235-64•••-••-1425560.427.2492MATEO.HARVEY@OUTLOOK.COM4288 BroadwayORLANDOFL32876GRP-6598SELECT-EPO
ENRENR-1213282026-09-26T10:25:07ZJUSTINR.JENKINSDec 15, 1957UHC-35967-43•••-••-21215577874542justin.jenkins@icloud.com9632 Palm DrScottsdaleAZ85250·GRP-0830SELECT-EPO
CLM CLM-4162692026-02-22T01:30:14ZMariaEChenOct 9, 2006UHC0660737—N/A··N/A5649 Elm StreetEden PrairieMinnesota55345GRP-9912MEDICARE-ADV-A
ENRENR-127051 2026-01-02T18:26:35ZDonald—Wallace23-01-1977UHC-19014-04—+1 249 323 6181DONALD.WALLACE@GMAIL.COM7020 Forest AvenueColumbusOH43255GRP-8309OPTIONS-PPO
ENRENR-102019 2026-06-19T00:02:20ZJulieLWashington10/25/39UHC-19375-27•••-••-2795466-201-5517julie.washington@yahoo.com4718 Union St·ScottsdaleAZ85298-1114GRP-9291MEDICARE-ADV-A
ENRENR-1069812026-10-01T20:37:01ZJustinLArnold1971-07-23UHC-06114-95•••-••-3257N/Ajustin.arnold61@hotmail.com4094 Market Street··FresnoCA93795GRP-1038··SELECT-EPO
CLMCLM-4219212026-05-02T02:49:03ZTHERESA—HENRY12/11/1991UHC-34912-88nullnulltheresa.henry21@icloud.com8184 Meadow LnSAN DIEGOCA92175GRP-1724··SELECT-EPO
CLMCLM-4165842026-07-18T16:51:53ZLARWENCE—MORGAN9187-06-08UHC-20131-53—+1 824 549 4912——-NULL—GRP-8876—
100,000 rows, page 140 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.695Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty