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-1076852026-07-27T17:56:16ZJOSEPDUNN2008-05-01UHC-70623-16•••-••-26672188349182JOSE.DUNN72@GMAIL.COM6828 Elm StreetTampaFL33614GRP-1679CHOICE-PLUS-PPO
CLMCLM-4301382026-07-07T19:18:48Zronald—butler1971-70-18··UHC2344992•••-••-4521839.470.8174—6971 Lake View RoadLas VegasNevada89162GRP-2699N/A
CLMCLM-4030222026-04-18T09:37:55ZKeith—·Wood1941-02-22——16685826424NULL8529 HILLCREST RDFresno·CA93767GRP-5630null
ENRENR-1301312026-07-31T12:09:17ZLUISPGONZALES1939-08-26UHC-00878-25··(977) 294-1179luis.gonzales98@outlook.com4733 Canyon RoadAtlantaGA30339GRP-7574MEDICARE-ADV-A
ENRENR-1040082026-03-28T15:39:42ZRUTH—BLACK1963-11-09UHC-63053-46•••-••-81332228050783ruth.black86@yahoo.com3100 Washington StreetPlanoTexas-GRP-3089MEDICARE-ADV-B
TPATPA-548522026-07-17T00:54:22ZHannah—Silva19871206null•••-••-29565642976614N/A4027 PARK PLACEGlendaleAZ85315N/AN/A
CLMCLM-4305162026-03-26T02:49:46ZSara··—Hicks··2001-12-23UHC-24394-15null·(474) 579-5639SARA.HICKS54@AOL.COM2890 Mountain View DriveSacramentoca··95867——
ENRENR-1369012026-03-13T19:37:39ZStone, Omar——2000-03-03UHC-96683-20•••-••-7013N/A··OMAR.STONE@YAHOO.COM3196 Ocean AveTempeAZ85210-1531GRP-5712MEDICARE-ADV-A
TPATPA-527952026-08-08T20:33:00ZBakar, Megan——01/06/1994UHC-45792-28UNKNOWN5964708007—5007 Bayshore DrNashvilleTN37261··null·-
TPATPA-636782026-01-13T00:43:58ZKELLY··CHAPMAN19710112—NULL(319) 444-2943N/A——NULL—nullOPTIONS-PPO
ENRENR-1161442026-03-21T08:08:13ZBrittanyGHamilton1998-02-24UHC5262642•••-••-45925899508349—6143 Lake View Road #728San DiegoCA92135GRP-0811OPTIONS-PPO
CLMCLM-4090622026-07-09T21:55:21ZStephens, Willie——1957-11-02UHC-37196-32•••-••-8315-NULL·UNKNOWNN/A—-UNKNOWNMEDICARE-ADV-A
TPATPA-543142026-01-15T22:14:19ZBruceCAlvarez1981-05-04N/A-UNKNOWNN/A———·-··NULL
CLMCLM-4232062026-10-03T22:40:02ZWillie—Munoz1960-01-08UHC-92535-52-6597207005UNKNOWN—····——GRP-0789NULL
TPA TPA-588122026-09-29T12:48:52ZKimberly—Ruiz0716-19-88NULL—null—8217 Valley View DriveOrlandoFL··32817—CHOICE-PLUS-PPO
CLMCLM-4086582026-04-26T02:25:37ZPRIYA—WILLIAMSON1981-05-23NULLN/A-··N/A1331 Ocean AveSeattleWA98159nullnull
PRVPRV-256462026-04-09T06:02:13ZMarha—Brooks1966-10-23UNKNOWNNULL438.515.6124MARTHA.BROOKS@HOTMAIL.COM-·N/AUNKNOWN——MEDICARE-ADV-B
CLMCLM-4177772026-01-05T01:37:11ZHenry—Hudson1962-05-17—•••-••-5636399.531.9723UNKNOWN3276 Camelback RoadGlendaleAZ85374-4060GRP-2840CHOICE-PLUS-PPO
ENR ENR-1174802026-04-01T15:19:34ZAmber—Brown19480104UHC-82688-97•••-••-7434+1 773 286 9431N/A5547 Hillcrest RoadTUCSON·AZ85743GRP-3320CHOICE-PLUS-PPO
TPATPA-584532026-02-25T04:38:44ZAUSTIN—MURRAY1940-47-18UHC-61729-64··—null6579 Washington StAustin···TX78760——
CLMCLM-4111492026-02-12T03:30:04ZBurns, Noah······2000-03-03UNKNOWN····(503) 580-0367—7504 BROADWAYTampaFLUNKNOWN——
ENRENR-131130 2026-01-24T03:39:11ZHEATHERMCHAVEZ1947-10-03UHC-48341-50•••-••-290312995580953-698 Apache Blvd·Miami·fl33189-4246GRP-4933SELECT-EPO
CLMCLM-4219002026-08-22T09:03:29ZPrice, Alexis—····09/09/1958-•••-••-3091903-494-0566nullNULLNULL-··GRP-3123—
TPATPA-561402026-03-10T11:03:09Zpatel—austin1972-10-22NULLUNKNOWN——1655 Baseline RdAtlantaGA30387-4961GRP-0892-
ENRENR-142501 2026-06-18T19:40:38Z·JACK····—7/24/1970UHC-08046-24•••-••-2410(816) 744-2788jack.clark@hotmail.com5407 Camelback RoadDenverCO80236GRP-0226CHOICE-PLUS-PPO
PRVPRV-283262026-01-28T05:55:57ZShirleyAMeyer1976-09-12NULLNULL2663373260shirley.meyer73@gmail.com413 CEDAR LNSeattleWashington98187-1203—OPTIONS-PPO
ENRENR-1011622026-05-25T01:31:15ZMaary····Payne01/25/48UHC-97356-17•••-••-6526331.800.8869—2881 Apache BoulevardSeattleWA98120GRP-9259OPTIONS-PPO
TPATPA-558402026-03-08T04:53:48ZAnthony—Aguilar1989-11-06NULLNULL17628088884—·7499 Jefferson AvenuePhoenixAZnullUNKNOWN··MEDICARE-ADV-A
CLMCLM-4124552026-01-10T01:12:36ZREBECCAH.KENNEDY··1938-05-08··UHC-25249-09NULLNULL—2598 Church StJacksonvillefl32236—OPTIONS-PPO
CLMCLM-4253542026-10-08T19:14:32ZMASON—EDWARDS1998-08-27-····7264066114NULL4767 Apache BlvdSan DiegoCA··92146UNKNOWNNULL
TPATPA-537332026-10-03T08:15:30Z Patel, Stephen——1961-07-20—•••-••-1402—null8076 HIGHLAND AVE··ColumbusOH43290-3066—CHOICE-PLUS-PPO
CLMCLM-4046982026-01-13T15:38:07ZStephens, BrendaL—Mar 2, 2000NULLN/A(876) 219-6814——UNKNOWN—nullGRP-6378NAVIGATE-HMO
CLMCLM-4299482026-07-18T03:08:05ZFrances—Hansen1958-11-10—•••-••-2992(744) 286-4153null8848 Lincoln WaySan DiegoCA92179NULL—
CLMCLM-4099222026-09-05T12:01:38ZLisa—·Porter·1961-07-05UHC-43480-38—15394275875—5821 Bayshore DriveSeattle··WA98178GRP-0233—
ENRENR-1255892026-06-15T15:24:19Z arthurRwashington1978-04-20UHC-16202-78•••-••-4770+1 878 807 1825null4585 Mesa DriveSAN ANTONIOTexas78214GRP-8388MEDICARE-ADV-B
ENR ENR-1202922026-10-11T05:22:19ZJANETWEDWARDS07/10/65UHC-30103-66NULL··737.826.3478··JANET.EDWARDS25@HOTMAIL.COM3833 Market StreetSCOTTSDALEAZ85260GRP-5482MEDICARE-ADV-A
TPATPA-513002026-09-28T03:23:55Znatalie—weber1977-12-13null•••-••-7476(844) 948-9245···natalie.weber60@yahoo.com2493 Pine DriveJacksonvilleFlorida32279—NAVIGATE-HMO
PRVPRV-28488 2026-04-11T09:49:11Z·Logan—ScottAug 15, 1988UHC-34279-81•••-••-2048505-243-4196NULL·9396 Cedar LnNashville··TN37243·nullUNKNOWN
PRVPRV-267172026-04-26T15:42:07Z·ROGER—ORTEGA1939-04-19UHC-44775-27-(562) 395-5539—9312 Market StreetJacksonvillefl32210····NAVIGATE-HMO
ENRENR-1364062026-02-22T18:38:24ZEthanUWatson1981-10-04··UHC-98139-49•••-••-2947491.796.0564NULL1710 Camelback RdMIAMIFL33103GRP-2246OPTIONS-PPO
ENRENR-1037512026-09-19T05:40:25ZMurray, JerryB—1986-02-06UHC-55351-47•••-••-09576213996616jerry.murray85@outlook.com7532 Cedar Ln #796NashvilleTN··37277GRP-1291CHOICE-PLUS-PPO
ENRENR-1243622026-04-30T22:00:53Z KimberlyAMorrison11/19/43UHC-34877-54•••-••-6926445-918-6280-7194 Lincoln WayPLANOTexas75086GRP-0549NAVIGATE-HMO
ENRENR-1423842026-08-24T11:16:10Z Anna—Taylor07/15/1988UHC-89479-07•••-••-02933119953168—6456 Mesa DriveMinneapolisMN55435GRP-1149MEDICARE-ADV-B
ENRENR-1278042026-03-14T10:27:22ZJulie··M.Chapman19390304UHC2100012•••-••-1636882.307.8782julie.chapman58@hotmail.com7752 Sage CourtGilbertAZ85253-1249GRP-3802MEDICARE-ADV-A
ENRENR-1309282026-09-09T07:01:47ZEugeneAMorales1976-03-11UHC-18419-70•••-••-7399+1 555 993 4176eugene.morales31@proton.me7390 Bayshore DrAUSTINTX78766GRP-2408OPTIONS-PPO
ENRENR-1308592026-08-09T19:22:25ZPaul—Lawson1967-01-26·UHC-77158-43•••-••-4028833-807-7978PAUL.LAWSON@YAHOO.COM3409 Elm StreetTEMPE·AZ85233GRP-2251OPTIONS-PPO
ENRENR-1199132026-06-22T18:25:54Z NATALIE—·HENRY1944-08-18UHC-47059-01•••-••-5906—UNKNOWN7338 Jefferson AvenueFRESNOCA93723GRP-9066SELECT-EPO
ENRENR-1060912026-05-31T09:15:35ZscottQ.singh19-06-1941UHC-63799-34•••-••-82004334896845scott.singh@gmail.com2352 Oak Street Apt 18NashvilleTN37205GRP-1765CORE-HMO
PRVPRV-222752026-09-22T01:09:19ZValentina—Price04/24/04UNKNOWNnull—-9812 Meadow Lane #599PhoenixAZ85032——
TPATPA-633582026-02-10T22:02:50Z Flores, Jesse··——2008-11-16N/A·····null-7763 Hillcrest RdNashvilleTN37275N/ANULL
100,000 rows, page 184 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.715Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty