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-4056552026-04-10T01:12:08Zvictoria—evans1994-03-26——NULLNULL··9661 Forest AveHoustonTX77068-6642N/A··NAVIGATE-HMO
ENRENR-1273402026-10-18T21:38:08ZAguilar, DianeL—1956-07-17UHC-44282-26•••-••-86108316017296DIANE.AGUILAR@HOTMAIL.COM2266 Park PlSacramentoca··UNKNOWNGRP-2865navigate-hmo
ENRENR-1084242026-04-14T10:42:12ZChristina—Dominguez1943-07-16UHC5510853•••-••-9086(241) 633-6743CHRISTINA.DOMINGUEZ29@YAHOO.COM2619 Highland AvenuePhoenixAZ·85069GRP-2871OPTIONS-PPO
CLMCLM-4152192026-07-01T14:14:06ZLawrence—Rice11/14/1963UHC-04124-95•••-••-4439UNKNOWNN/AUNKNOWN—N/Anull··GRP-1729null
CLMCLM-4237712026-06-03T20:25:23ZCHRISTIAN—SPENCER1974-07-25UHC-07631-84•••-••-7081NULLN/A·9861 Valley View DrHoustonTX·77090GRP-1973—
TPATPA-563862026-01-12T23:13:58Zjordan—porter2001-04-17—•••-••-4268NULL—2631 HIGHLAND AVENUEAustinTX78707GRP-4825null
ENRENR-1290192026-02-08T21:04:32ZPamela—Sullivan1963-04-28UHC-72817-47··•••-••-40067663120309PAMELA.SULLIVAN@OUTLOOK.COM5284 Harbor BoulevardMiamiFL··33144GRP-7763SELECT-EPO
CLMCLM-4080042026-04-20T05:15:42ZDANIEL—WHEELER08/16/1995UHC-50459-31N/A(477) 365-9766—7175 HIGHLAND AVEDenverCO80263—CORE-HMO
ENRENR-1222112026-08-07T03:54:05Z·Tucker, DouglasQ.—1971-11-13UHC-69945-91•••-••-39236739321900douglas.tucker12@proton.me7086 Cedar LnSan AntonioTexas78281GRP-2653MEDICARE-ADV-B
ENRENR-1119392026-07-21T07:21:28ZEMILYWMURRAY08/23/1963UHC-02083-82•••-••-2768(901) 566-4820emily.murray@outlook.com7357 Mesa DrAustinTexas78760GRP-8609CHOICE-PLUS-PPO
ENRENR-1068812026-06-05T03:36:52ZRANDY····NICHOLS25-09-2004UHC-80809-06•••-••-2628(604) 871-1724randy.nichols@yahoo.com3698 Forest AvenueScottsdaleAZ·85243GRP-8506SELECT-EPO
ENRENR-1393722026-06-30T02:45:50ZROGERDKELLEY01/26/69UHC-99844-35•••-••-21726528001976roger.kelley32@yahoo.com8484 CANYON ROADMesaaz85248GRP-1720OPTIONS-PPO··
TPATPA-590442026-01-30T05:12:34ZHudson, Gregory——8/14/1968—NULLUNKNOWNN/AUNKNOWN—null-GRP-4947··N/A
CLMCLM-4280862026-04-15T23:19:51ZARTHUR—KELLEY04/25/88UHC-28863-81UNKNOWN14378213411null4444 SPRING STTempeAZ85216—UNKNOWN
ENRENR-1323242026-03-22T12:04:12ZRachelN.Daniels1994-12-06·UHC5388676•••-••-97459305162541—1557 Cedar LnSAN ANTONIO··TX··78225GRP-1329SELECT-EPO
CLMCLM-4269542026-07-17T23:04:20ZGerald—Dean1964-08-14··········—UNKNOWNN/AUNKNOWN—GRP-0689NULL
TPATPA-531052026-03-09T06:05:30ZGeraldYWagner1982-02-05—•••-••-379316279468172-9744 RIVER ROAD #478CharlotteNC28269nullCORE-HMO
ENRENR-1418672026-08-06T16:16:33ZMARIANA—LITTLE19430905UHC-08311-83•••-••-9748·UNKNOWNmariana.little@icloud.com4453 Market StCHANDLER·AZ85286GRP-7316MEDICARE-ADV-B
TPATPA-610802026-10-09T11:37:09ZPAUL—PRICE2001-03-20-—803-219-0290-6131 Jefferson AvenueGlendaleAZ85325-3957—CORE-HMO
CLMCLM-4152972026-05-09T12:26:16Zfatima—·myers1948-02-05··UHC-02930-28··N/ANULL··422 Bayshore DriveGilbertAZ··85235GRP-8726····
CLMCLM-4058052026-01-17T07:29:05Z·Wilson, Smuel——2003-40-10UHC-53403-90•••-••-3185N/Asamuel.wilson47@outlook.com-—-NULLGRP-6879null
ENRENR-1388892026-06-24T20:42:13ZSantiago I—Sanchez1984-05-28··UHC-26057-10•••-••-6990(615) 525-7468santiago.sanchez40@outlook.com·4447 Canyon RoadSan DiegoCA92171GRP-6358CORE-HMO
TPATPA-574612026-01-27T04:52:41ZChapman, Tommy——1967-01-23——18624451824··-4340 CANYON RDChandlerArizona85252—NULL
ENRENR-1164192026-06-03T18:57:46ZGrace····Welch1939-04-17UHC-28155-26N/A··527.773.8860grace.welch86@proton.me··1665 Desert Sky Boulevard··AtlantaGA30390··GRP-8626MEDICARE-ADV-B
TPATPA-504432026-02-20T15:15:29ZGary—Sullivan1965-11-03N/AnullN/Agary.sullivan62@aol.com8505 Market StTempeAZ85242GRP-5094—
ENRENR-1421572026-05-07T20:38:46ZBarbara—·Willis1983-05-09UHC-77515-78•••-••-7780(886) 976-8059barbara.willis93@proton.me8672 Washington StPlanoTexas-GRP-1078NAVIGATE-HMO
ENRENR-1416392026-08-02T03:04:51ZRios, DylanT—1963-10-11UHC-19892-73•••-••-053818959144169dylan.rios66@outlook.com2747 SUNSET BOULEVARDPhoenixAZ85033GRP-5809NAVIGATE-HMO
ENRENR-1045082026-08-22T12:57:53ZAndrea—Scott··Feb 12, 1947UHC-70977-09··•••-••-6606·5432865021ANDREA.SCOTT@AOL.COM2266 Lincoln Way Apt 22ChandlerAZ··85274GRP-5913SELECT-EPO
CLMCLM-417768 2026-10-16T21:32:39ZSusan—BurnsApr 10, 2000··—•••-••-6503nullNULL6673 Cedar LnTampa·Florida33655GRP-3225UNKNOWN
PRVPRV-236632026-03-01T22:37:18ZJaccob—Pierce1950-04-11UHC-39294-12null(621) 654-5488jacob.pierce64@gmail.com3638 HILLCREST RD Apt 28··MesaAZ85229NULLMEDICARE-ADV-B
PRVPRV-262892026-09-10T02:41:19ZJonathan··Msaon1979-10-23—NULL+1 770 216 8246N/A———NULL-NULL
ENRENR-1104022026-07-07T05:42:13Zjeremy—nunez26-02-1971UHC-54560-44•••-••-0300(764) 238-2750N/A8260 Lincoln WayNashvilleTN37271-4751GRP-1735CHOICE-PLUS-PPO
TPATPA-631582026-09-24T03:19:39ZHENNRY—·DOMINGUEZ2000-08-01····N/A15516789287NULL9538 MESA DRIVETAMPA·Florida33662-7119nullnull
TPATPA-62935 2026-01-28T07:48:14ZGEORGE—HOEWLL1984-03-09UNKNOWN-(261) 897-4828—9286 Baseline RoadMesa·Arizona85207NULL—
TPATPA-529972026-03-13T14:48:54ZGRACECKELLY06/04/92—null(766) 506-0494GRACE.KELLY@YAHOO.COM5725 Maple AvenueSAN DIEGOCA92122UNKNOWN—
ENRENR-1289032026-09-30T10:08:31Z·Rose, StephenD—nulluhc-80010-57•••-••-6832UNKNOWN—8862 Park PlPlanoTX75069GRP-6350·SELECT-EPO
ENRENR-1039302026-01-11T03:58:31ZMorales, Keith——1973-08-27UHC-51608-34•••-••-4885—KEITH.MORALES@YAHOO.COM8899 Park PlaceLas VegasNV89194GRP-8759NAVIGATE-HMO
ENRENR-1322172026-10-02T20:50:33ZAlexander, Mei——1941-04-04UHC2164314•••-••-5719924.271.5819mei.alexander@icloud.com9152 CAMELBACK ROADJacksonvilleFL32279··GRP-3254CORE-HMO
TPATPA-503042026-07-25T05:32:41ZALICE—CRAWFORD1953-10-20····—··-8047 FOREST AVENUEPlanoTX75059——
PRVPRV-231512026-09-10T11:40:08ZGraham, Michael··L—1991-04-09UHC-80630-55·-+1 712 888 0544MICHAEL.GRAHAM45@GMAIL.COM5523 Main StPlanoTexas·null—-
PRVPRV-287452026-08-26T14:35:36ZCatherine·RLarson20-12-1971-N/A6422852095catherine.larson@gmail.com2721 SUNSET BLVD··San DiegoCA···NULL——
CLMCLM-4045842026-06-12T16:32:24Z RICHARD—ROIS2/23/1992UHC-20691-71··5839168503-9572 Park PlGLENDALEAZ·85330GRP-5810··
ENRENR-106183 2026-07-01T08:58:24ZmarthaEgarrett1938-08-15UHC-05777-33•••-••-5994688-732-0887martha.garrett@hotmail.com7161 Union St Apt 17JacksonvilleFL32231GRP-3188SELECT-EPO
ENRENR-1283532026-01-15T07:33:53ZSamantha—Dominguez27-01-1983UHC-55189-26•••-••-8836+1 310 302 3238··NULL1012 Bayshore Drive #259ColumbusOH43249GRP-6630MEDICARE-ADV-B
CLMCLM-4173102026-04-13T10:41:24ZLinda—Gray·1944-09-06UHC-13908-56•••-••-5243——8805 Ridge RoadHOUSTON·TX—GRP-2419-
CLMCLM-4304322026-06-09T07:42:29ZJOAN—MEDINA02/10/1968-•••-••-8635UNKNOWN··NULL4462 Oak StOrlandoFL32890GRP-1695NULL
CLMCLM-4160652026-01-09T20:04:43ZMyers, Ralph——Apr 5, 1966—·UNKNOWN14093983582—3366 Hillcrest Road Apt 38GlendaleAZnull··—SELECT-EPO
CLMCLM-4075202026-06-07T22:52:27ZGrant, Patricia——1978-09-07·--7485931064··—6500 RIDGE ROAD Apt 27MiamiFL33172GRP-6546OPTIONS-PPO
TPATPA-625482026-04-06T23:25:15Zwaltar—bowman04/16/1971—•••-••-2778——·9491 Apache BoulevardHoustonTX77035GRP-4410—
ENR ENR-1392032026-05-13T03:10:32ZDIEGOMKNIGHT1939-10-11UHC-87115-85-311-528-4149DIEGO.KNIGHT@ICLOUD.COM··7285 VALLEY VIEW DRIVEDALLAS··TX75271GRP-5073SELECT-EPO
100,000 rows, page 105 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.679Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty