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-432670 2026-02-22T16:35:48ZTERESA—HOWELL1959-10-07--5502159435NULL6315 Oak StAustinTX·78713GRP-6736-
TPATPA-500352026-05-28T06:02:56ZCHRISTIAN—CONTRERAS1983-07-26———N/A———N/AGRP-8330-··
TPATPA-514562026-09-23T23:46:37ZJOHN—PALMER1951-07-24—NULL(919) 789-8404UNKNOWN2782 PARK PLACEOrlandoFL32882··GRP-6475N/A
ENRENR-1221842026-02-16T05:27:55ZAISHA—GERCIA1994-04-27UHC-35298-45•••-••-1534—aisha.garcia@gmail.com·6404 Union StSacramentoca95876GRP-6218SELECT-EPO
CLMCLM-4102362026-06-10T14:48:45Z·Sarah—Wright07/09/2007N/A——NULL3671 Sunset BoulevardNashvilleTN37271GRP-0854-
CLMCLM-4048792026-04-23T21:20:26ZGaryP.Burton01/22/1988UHC4126481-—NULL4869 Church Street·GilbertArizona—GRP-4384-
CLMCLM-4092802026-03-16T15:38:35Zgloria—·dominguez06/11/1951—NULL3779975546UNKNOWN426 Willow CourtGlendaleAZ85320N/ACORE-HMO
CLMCLM-4046522026-04-09T22:50:59Z·HANNAH—WOOD1982-10-02—•••-••-0747—N/A8882 HARBOR BOULEVARDHoustonTX77005—····
CLMCLM-4026532026-08-30T13:40:48ZBRANDONYRICE3/14/1986UHC-75050-61•••-••-2512509-866-6317—NULL—nullUNKNOWNGRP-5894·N/A
ENRENR-1253232026-09-17T06:54:37Z·Mei—West1967-06-26UHC8942495•••-••-0631686.885.2208MEI.WEST@GMAIL.COM9560 Lincoln WayAUSTINTX78729GRP-7786SELECT-EPO
ENRENR-1338732026-05-18T15:54:47ZamyJjacobs1952-01-01UHC-84427-31•••-••-480613709816363·amy.jacobs74@outlook.com5267 Main Street··San DiegoCA92158GRP-6221··CHOICE-PLUS-PPO
ENRENR-1139242026-01-22T04:24:32ZMarquez, Gregory——2005-03-18UHC1999931—18656524871gregory.marquez14@hotmail.com7419 OAK STFresnoCA93772GRP-8523SELECT-EPO
ENRENR-1408952026-05-21T21:45:30ZValentina···IAsutin1988-08-03-UNKNOWN+1 965 778 4466VALENTINA.AUSTIN11@HOTMAIL.COM1695 Grand AvenueTucsonAZ85774GRP-4516···MEDICARE-ADV-A
PRVPRV-218472026-02-07T19:25:20Zsara—carterMar 8, 1945N/A—-NULL··4145 Lake View RoadPhoenixAZ85097UNKNOWNNAVIGATE-HMO
ENRENR-1312612026-06-10T19:03:16ZWAYNE—GREENE1965-06-25UHC-20352-89•••-••-8600(474) 291-8899NULL1458 Indian School RoadAustinTX78781GRP-6555OPTIONS-PPO
ENRENR-1037122026-08-21T10:45:37ZHEATHERO.··LAWRENCE1964-05-06UHC-82881-79—890.447.9951heather.lawrence34@proton.me1794 Elm StreetGlendaleAZ85376GRP-3993SELECT-EPO
ENRENR-1119892026-06-06T01:58:35ZGaryXReynolds11/01/1968UHC-12263-87•••-••-1352390-961-9471GARY.REYNOLDS@HOTMAIL.COM5823 Elm StreetTampaFL33608GRP-5298CHOICE-PLUS-PPO··
ENRENR-1032152026-05-07T22:53:31ZHeather··—Howard1954-04-18UHC-56509-49•••-••-6968818-539-4398HEATHER.HOWARD@AOL.COM784 Forest Avenue #867HoustonTX77048-0148GRP-3368CHOICE-PLUS-PPO
PRVPRV-216342026-03-14T04:28:18ZBradley—Palmer1952-02-11UHC-68445-57··+1 263 861 9542UNKNOWN2004 Jefferson AveSeattleWA98139UNKNOWN—
CLM CLM-4318672026-02-10T13:59:49ZronaldG·meyer·2000-05-27NULL—5777411106RONALD.MEYER@GMAIL.COM8153 BROADWAYMESAAZ85274—OPTIONS-PPO
CLMCLM-4049152026-05-07T20:07:09ZMartha—Henderson1966-01-09UHC-35020-04-··—·N/A2056 Highland AveTampaFL33619—MEDICARE-ADV-A
ENRENR-1168672026-02-13T21:50:25ZWilliamP.Black1967-03-21UHC-48987-35•••-••-2878210-934-2109william.black@proton.me5405 Sunset BlvdJACKSONVILLEFL32243GRP-0440OPTIONS-PPO··
ENRENR-1183332026-04-13T21:22:10ZKATHRYNAORTEGA1944-08-18·UHC-71038-15•••-••-6815·8819934947null7208 Union StreetPlanoTX75025GRP-4846MEDICARE-ADV-B
ENRENR-1382922026-06-25T14:40:14ZLisaH.Taylor9183-09-14—•••-••-6237·(241) 847-3837LISA.TAYLOR@GMAIL.COM1069 Baseline RdEDEN PRAIRIEMN55389-0152GRP-4158options-ppo
ENRENR-108202 2026-07-24T12:29:31ZJEREMY··WELKERMay 11, 1958UHC-68255-89•••-••-1537N/AUNKNOWN7404 Lincoln WaySeattleWA98133-3716GRP-2826SELECT-EPO
TPATPA-507352026-06-07T14:19:09Z Arthur—Mason1975-07-11··NULLnull··NULL5652 Jefferson Ave #471San AntonioTX78266null·CHOICE-PLUS-PPO
ENRENR-1348402026-09-27T13:30:51ZPAUL—LUNA1961-02-24UHC7199441•••-••-7538(379) 650-4133··paul.luna@outlook.com9527 GRAND AVEFresnoCA93765GRP-0457NAVIGATE-HMO
TPATPA-51548 2026-07-29T14:32:24ZJudith—Mitchell05/03/89····UNKNOWN367-807-2816N/ANULL—-NULLN/AOPTIONS-PPO··
TPATPA-632242026-07-31T08:08:05Zbetty—sandoval9/25/1944-—-betty.sandoval@yahoo.com1080 Desert Sky BoulevardDALLASTX··75227—SELECT-EPO
TPATPA-598232026-06-30T04:01:21ZMatthew—Hoffman1995-04-23UHC-49069-01•••-••-43462903733827matthew.hoffman59@outlook.comNULL-—UNKNOWNGRP-3242—
ENRENR-1117942026-06-03T00:43:17ZCHRISTINA—GONZALES·11/26/1963UHC-49127-77•••-••-1587NULLchristina.gonzales83@yahoo.com3686 Lake View RdSCOTTSDALEAZ85219GRP-0404NAVIGATE-HMO
ENRENR-1115512026-05-27T10:43:03ZWILLIE F—WOOD12-05-1977UHC-01701-76•••-••-2790(953) 435-3831WILLIE.WOOD@YAHOO.COM8425 Ridge RdMesaAZ-GRP-1866OPTIONS-PPO
ENRENR-1108282026-05-08T21:17:02ZDAVIDYCOOK1981-11-05UHC-17459-59•••-••-4845899-764-3225null9354 Valley View DrDallasTX75223GRP-8882MEDICARE-ADV-A
CLMCLM-4117992026-10-06T18:13:38ZCamila—Harrison19950912UHC-38431-26—-camila.harrison@aol.com—nullNULLUNKNOWN·GRP-1243CHOICE-PLUS-PPO
CLMCLM-4191652026-01-30T07:05:37ZAnthony—Wells1955-06-12UHC-46535-81—8936221346··N/A8883 Central AvenueGlendaleAZ··—GRP-8928CHOICE-PLUS-PPO
ENRENR-1191742026-09-02T04:33:47ZMASONY.·WEAVER1946-08-27UHC-94503-02•••-••-1652328-708-4598MASON.WEAVER31@PROTON.ME248 Palm DrFresnoCA93706-3675GRP-4446MEDICARE-ADV-A
ENRENR-1296642026-10-01T16:46:29Z·TIMOTHY··RIOS1947-03-18UHC-68272-84•••-••-6250411.598.8712TIMOTHY.RIOS74@GMAIL.COM8728 Sage Court Apt 36Miamifl33123GRP-0521CORE-HMO··
TPATPA-562552026-05-12T08:52:18ZJOHNJLAWSON1986-10-27UHC-24203-26—null—3416 Washington StreetTEMPE·AZ85289-CHOICE-PLUS-PPO
ENRENR-1092972026-07-06T15:38:25ZRogers, Sharon——Mar 15, 1971UHC-06338-10•••-••-4191-N/A6906 Apache BlvdHoustonTX77080GRP-9468OPTIONS-PPO
CLMCLM-4251772026-09-30T22:53:51ZRichardson, JamesY—1943-05-17UHC-80635-16N/A—null4127 HIGHLAND AVEGILBERT··AZ85229GRP-1931SELECT-EPO
ENRENR-1085952026-10-16T15:38:41ZRalph—·Rice1946-07-03UHC-00945-46•••-••-213712046802370RALPH.RICE91@HOTMAIL.COM7218 River RdAustinTX78726GRP-1068SELECT-EPO
CLMCLM-4261482026-08-21T20:14:36ZAAROND.BAKER01/13/02·UHC-67046-98—8577507295null3501 Indian School RoadGILBERTAZ85251—CORE-HMO
ENRENR-1064952026-05-19T11:35:09ZVincentHHart4/5/1976··UHC9916301•••-••-7483860-939-0189—3166 OAK STMinneapolis··MN55413GRP-8250CHOICE-PLUS-PPO
ENRENR-1127342026-06-03T03:17:02Zchristopher—ruiz1946-03-21UHC-69936-01•••-••-0589+1 985 440 4038christopher.ruiz@icloud.com7578 OCEAN AVENUESACRAMENTOCA95811GRP-8920CORE-HMO
ENRENR-1131162026-08-20T05:19:58ZgeraldZcarpenter5/7/1978UHC-74053-63•••-••-06925949028540····6030 Meadow Ln··TucsonAZ85772GRP-7822MEDICARE-ADV-A
ENRENR-1268042026-06-10T09:03:09ZValentinaOWheeler1953-05-22UHC-44407-74•••-••-8271(964) 527-5872··N/A4300 VALLEY VIEW DRNashvilleTN37203GRP-4683SELECT-EPO··
ENRENR-1046202026-08-08T04:55:34ZSharon—·Welch1939-01-15UHC-81282-68•••-••-813412978056533sharon.welch@icloud.com1841 Sunset BoulevardSan AntonioTX78225GRP-8033··MEDICARE-ADV-A
ENRENR-1142922026-08-16T21:12:11ZTheresa—Murray20040925UHC-22222-28•••-••-9012(365) 922-0740—799 Willow CourtScottsdaleAZ··85261GRP-6119MEDICARE-ADV-B
TPATPA-588862026-06-18T17:56:00ZEstrada, Diana····—1987-06-14-•••-••-5523NULLN/A···6741 Cedar LaneFresnoCA93706null—
CLMCLM-4018122026-08-19T07:23:11ZJacqueline—Willsi09/05/2003UHC-69078-97-871-603-6630UNKNOWN5661 SAGE COURTSAN DIEGO·CANULLGRP-0166-
100,000 rows, page 40 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.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty