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-1293352026-05-09T00:18:22ZJOYCEJ.GUTIERREZ05/03/1982-•••-••-5182320.744.6204UNKNOWN1976 Sunset BoulevardScottsdaleArizona85270GRP-1409CORE-HMO
TPATPA-560912026-08-28T11:51:07ZKatherine—Porter5/1/1945N/A-N/A··-N/A-N/ANULL—
ENRENR-1257252026-03-28T07:38:55ZVINCENTMGUERRERO9/1/1965··UHC7975763•••-••-20362012751580—-nullNULL—GRP-5970MEDICARE-ADV-B
ENRENR-108146 2026-02-08T00:38:46ZBrown, Gabriel—··1995-05-27UHC-12037-69•••-••-00639387919979gabriel.brown18@aol.com3573 Forest Ave·TampaFL33681GRP-8902OPTIONS-PPO
ENRENR-1253692026-01-23T08:09:21ZVictoria··—Jacobs1963-02-02UHC-60426-14··•••-••-2729623-893-8906victoria.jacobs@proton.me1494 Bayshore DrSacramentoCalifornia95826GRP-4508NAVIGATE-HMO··
CLMCLM-4263552026-03-16T15:14:12ZMariaPHawkins1984-05-24UHC-51163-84···NULL—maria.hawkins@aol.com4711 Desert Sky Boulevard·AustinTX··78783GRP-9526NULL
CLMCLM-4154912026-07-28T07:21:28ZBetty··Brooks1952-05-01UHC4647501——BETTY.BROOKS@HOTMAIL.COM2768 Park PlMesa·AZ·85231-MEDICARE-ADV-A
ENRENR-1177242026-08-27T14:30:02ZKellyRHart1972-01-16UHC-41768-52•••-••-51857784809-1560 CANYON RDMiami··FL33199GRP-0998NAVIGATE-HMO
CLMCLM-4104322026-05-01T02:12:15ZCATHERINE—BENNETT1945-01-20null·NULL8452836··NULL9312 INDIAN SCHOOL RDOrlandoFLUNKNOWN··GRP-8343-
TPATPA-522822026-01-26T04:49:59ZKATHY—LUCAS2000-07-16nullN/AnullNULLnullN/AUNKNOWN··UNKNOWN-SELECT-EPO
TPATPA-616182026-03-05T10:49:57ZGloria····Alvarez9/4/1956N/A•••-••-3717484.215.4398——UNKNOWNnullnullN/AOPTIONS-PPO
CLMCLM-4226012026-09-12T04:27:10ZLaura—Morgan1970-02-28nullUNKNOWN504-278-8356N/A6176 Pine Dr··TAMPAFlorida33650-null
ENRENR-1054852026-05-27T03:29:58Zbilly—ryan·19390315UHC-95013-71NULL5232687886billy.ryan@outlook.com7645 Washington StreetTampaFL33672GRP-6361CORE-HMO
ENRENR-1367532026-09-25T01:38:41ZDeborah—Carlson1957-11-22UHC-44867-77•••-••-1777(410) 904-8126deborah.carlson@aol.com3493 MOUNTAIN VIEW DRSacramentoCA95894··GRP-1915OPTIONS-PPO
ENRENR-1024192026-09-10T01:48:25ZMarcus—Grifffin1220-19-82UHC-10120-08•••-••-5192——4569 Grand Ave··San DiegoCA92129GRP-5000NAVIGATE-HMO
ENR ENR-1214492026-07-13T03:06:53ZLUIS·BSIMMONS2003-04-13UHC-91105-47•••-••-4666+1 916 715 3948luis.simmons68@proton.me87 BAYSHORE DRSacramentoCA95863GRP-3140CORE-HMO
CLMCLM-4214812026-05-21T07:24:55ZFrances—Rojas1985-05-01UHC-82208-39•••-••-5938(720) 337-1205N/AUNKNOWN-UNKNOWNnullGRP-4259null
ENRENR-1108872026-07-06T10:58:41ZHolmes, RaymondN—1972-02-10UHC-55460-17•••-••-1111896-442-9771UNKNOWN1455 Sunset BoulevardLas VegasNV89124GRP-5641CORE-HMO
CLMCLM-4204722026-10-10T17:36:33ZAmanda—Graham1996-03-27UHC-29738-16•••-••-6068882-794-2406amanda.graham41@gmail.com1043 Harbor BlvdSacramentoCA95883GRP-5868CHOICE-PLUS-PPO
TPATPA-564712026-06-24T18:25:51ZLuna, Mariana··——12/20/1951—N/A·(910) 562-2104N/A9580 Bayshore DrMinneapolisMN55438GRP-4372—
ENRENR-1176852026-01-25T03:02:38ZWright, Joshua——1965-03-19UHC-71174-31•••-••-1610+1 380 221 5070JOSHUA.WRIGHT33@HOTMAIL.COM7265 Desert Sky BlvdChandlerAZ85273·GRP-4976NAVIGATE-HMO
CLMCLM-4048472026-09-26T12:25:49Z FRANK—RICHARDS1949-06-20UHC-87366-39UNKNOWN··nullN/A7427 Union St #125ChandlerAZ··85261N/AUNKNOWN
PRVPRV-258212026-02-16T08:41:44ZANGELA—·WAGNER1942-12-13N/A··•••-••-905015744498171——·nullNULL——NAVIGATE-HMO
CLMCLM-4145562026-08-04T11:39:51ZBrandon—Warren01/11/2003nullnull7083255304UNKNOWN1717 GRAND AVENUEMinneapolisMN55466GRP-7257CHOICE-PLUS-PPO
ENRENR-1310932026-03-31T13:43:38Zkevin—burns1941-10-06UHC-64254-55•••-••-2333(669) 368-7213—8615 Washington StreetOrlandoFL32815GRP-9676CORE-HMO
ENRENR-1417332026-07-24T00:35:41ZARTUHRVKNIGHTJan 25, 1986UHC-47920-07•••-••-0908UNKNOWNNULL9401 Camelback RdMesaAZ85263GRP-3787MEDICARE-ADV-B
CLMCLM-4061592026-06-26T14:30:33ZLuis—Nguyen1977-04-15··UHC-08438-95·nullnullluis.nguyen80@gmail.comNULL—UNKNOWN-GRP-1208··
TPATPA-636122026-06-27T16:23:19ZLawrence—Silva17-07-1974NULL-208-348-7666—5164 Canyon RoadFresnoCA93726——
TPATPA-64393 2026-03-12T06:48:30ZSARAFRICHARDSON10/24/69N/A---7411 LAKE VIEW ROADHoustonTX77089NULL—
PRVPRV-223172026-06-23T20:52:03Z·Roger—Stephens·1991-01-11UHC-94066-98—19248808854roger.stephens@outlook.com—---—null
ENRENR-1315632026-07-17T19:23:32Zmicahel—ferguson1991-08-02UHC-81936-57•••-••-1285708-483-6813MICHAEL.FERGUSON89@OUTLOOK.COM6568 HIGHLAND AVEAtlanta·GA30341GRP-8129MEDICARE-ADV-B
CLMCLM-4201922026-10-09T14:31:44ZWei—Miller03/27/49N/A•••-••-8601+1 697 777 0510····967 Canyon Rd #466TempeAZ85223GRP-6579·CORE-HMO
CLMCLM-4245872026-09-22T22:05:18ZJANICE—JORDAN1966-03-24·-•••-••-5351(360) 839-8659—774 Washington StreetNASHVILLETN37275GRP-3331····
CLMCLM-4187082026-02-04T20:58:33ZMICHELLE—CARPENTER12/26/04UHC-19794-40•••-••-2403N/A—1416 SPRING STREETSCOTTSDALE·AZ85215—null
CLMCLM-424359 2026-06-26T07:31:30ZGloia—Howard03/22/1996UHC-34736-12null15206655418·null9169 Spring StScottsdaleAZ85211·N/A-··
ENRENR-115316 2026-03-06T15:56:56ZterryK.coleman1939-09-10··UHC-28889-03•••-••-3837(755) 353-3818terry.coleman88@proton.me9252 LAKE VIEW RDGilbertAZ—GRP-8526MEDICARE-ADV-A
ENRENR-1308642026-03-15T03:52:08ZDaniels, JoyceC—3/12/1999uhc-17507-69•••-••-9977820-715-6604joyce.daniels63@outlook.com6364 BroadwaySeattleWAN/AGRP-8970OPTIONS-PPO
PRVPRV-244902026-07-12T05:02:40Z·diana····oliver10/2/2003UHC-09068-41UNKNOWN328.256.9089-4633 Hillcrest RoadSeattle·WA98134NULLMEDICARE-ADV-A
TPATPA-520222026-04-22T16:46:57Zlinda—gomez04/14/94····———·8638 River RdJacksonville··Florida32251GRP-6378OPTIONS-PPO
ENRENR-1072082026-10-07T14:02:09ZNathan—OBrien1939-09-27UHC-35857-33•••-••-01079205194785nathan.obrien@aol.com9887 APACHE BOULEVARDTempeAZ85200GRP-5221navigate-hmo
ENRENR-1423312026-01-06T07:00:44ZVirginia··Stevens·13-07-1954UHC-41703-79•••-••-3486307-634-4555virginia.stevens12@proton.me1551 Ocean AveAustinTX78728·GRP-4294OPTIONS-PPO
ENRENR-1348512026-04-27T03:54:02ZNatalie—Woods1940-09-01UHC-23619-40—8567426616NATALIE.WOODS49@OUTLOOK.COM8158 Oak StColumbusOH43281GRP-9151CHOICE-PLUS-PPO
ENRENR-1250052026-06-22T22:41:21Z·douglas—scott11/23/1972UHC-87164-66•••-••-5514574-764-5660douglas.scott92@hotmail.com··4134 Jefferson AvenueLas VegasNV89168-6326GRP-8502SELECT-EPO
ENRENR-1044682026-05-18T20:55:45ZRyan—Armstrong12/15/1961UHC-91572-43•••-••-9788658.270.8039··ryan.armstrong@outlook.com608 Spring Street··TampaFlorida33687GRP-0754NAVIGATE-HMO
CLMCLM-4295552026-02-26T04:22:58ZBRADLEY—PORTER2006-03-12UHC2330628-(882) 618-5903-6298 Maple AveFresnoCA··93729UNKNOWNOPTIONS-PPO
CLMCLM-4080802026-07-27T22:56:17ZMARCUS—SCOTT2003-02-20UHC-58921-89-5475676342null·2530 HARBOR BOULEVARDMesaArizona85252GRP-2725CHOICE-PLUS-PPO
CLMCLM-4258892026-08-21T12:04:33ZRANDYB.EDWWARDSApr 7, 1967——null—1054 WASHINGTON ST·MiamiFlorida33128··GRP-3470CHOICE-PLUS-PPO
CLMCLM-4235712026-09-05T03:41:10ZMegan—·Perez1947-11-27NULL··N/A-·megan.perez93@icloud.com8597 Valley View DrOrlandoFL32834·GRP-5749MEDICARE-ADV-B
TPATPA-629922026-06-24T16:19:19ZKEVIN—JIMENEZ1992-11-03—-··null—1553 DESERT SKY BOULEVARDOrlandoFL·32857GRP-4171··
TPATPA-604242026-10-01T05:39:17ZDonna····Owens8/12/1956——257-438-1946UNKNOWN—NULL—NULL—-
100,000 rows, page 171 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.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty