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-1043942026-08-10T02:56:58ZBenjamin··—Stewart1945-06-25UHC-28478-43•••-••-0799331-471-3960benjamin.stewart88@yahoo.com2391 WILLOW COURTTempeAZ—·GRP-7283OPTIONS-PPO··
ENRENR-1227772026-06-11T17:58:40Zshirley—patterson1946-10-07UHC-26027-63-833-536-6506N/A9287 MAPLE AVENUE··San AntonioTexas78286GRP-3089CHOICE-PLUS-PPO
CLMCLM-4006412026-10-10T06:43:26ZBILLY—·JACOBS19590628UHC-33970-88•••-••-02173229878billy.jacobs@yahoo.com——nullNULL—CHOICE-PLUS-PPO
TPATPA-557242026-09-28T17:38:34ZROGER··HOLMES03-08-1978NULL•••-••-7487NULLN/A289 Grand AveLos AngelesCA90087—····
ENRENR-1146032026-05-28T18:31:30ZJessica··—Evans1974-08-13·UHC-87523-88•••-••-0034·5406006053jessica.evans@aol.com2157 River RoadDallasTexas75242GRP-5812medicare-adv-b
ENRENR-1282522026-04-18T18:09:17ZBADLEY—ROGERS12/20/87UHC-01551-77•••-••-9344NULLbradley.rogers@gmail.com··8042 Pine DrSeattleWA98169GRP-8225SELECT-EPO
ENRENR-118087 2026-02-20T18:48:44ZDavid—RamirezApr 21, 1999UHC-64424-44•••-••-6863(444) 316-7152DAVID.RAMIREZ@OUTLOOK.COM5071 Lincoln WayDenver·CO80248·GRP-2296SELECT-EPO
ENRENR-1247582026-03-13T01:07:03ZRichardRBoyd·1945-02-02UHC-89046-92null989.669.5363richard.boyd35@aol.com2919 JEFFERSON AVEScottsdaleAZ85258-6147GRP-7405CHOICE-PLUS-PPO
ENRENR-1350722026-10-10T10:41:27ZGibson, CamilaU—1968-03-15UHC-37139-56N/A9162589539·camila.gibson45@hotmail.com999 Bayshore DriveJacksonvilleFL32272-7308GRP-2024MEDICARE-ADV-A
ENRENR-1054412026-07-21T07:08:33ZERICLLEWIS1984-04-18UHC-33199-78•••-••-1275N/Aeric.lewis@aol.com277 Grand AveTampaFL33697GRP-3695SELECT-EPO
CLMCLM-4119812026-08-29T04:28:50ZGonzales, Douglas··—1954-12-17UHC-31335-66··—(377) 877-8088NULL—nullNULLN/AUNKNOWNMEDICARE-ADV-A
CLMCLM-4298232026-01-01T19:03:29ZHannah—Larson06/11/01·NULL—null—8916 Jefferson AveMiamiFL33161·GRP-5644OPTIONS-PPO
ENRENR-1102732026-07-04T16:39:04ZKEITH··Z.ALVAREZ20010818UHC-14541-33··•••-••-04066609361558keith.alvarez@gmail.com6453 INDIAN SCHOOL RDCharlotte···North Carolina28299GRP-8883MEDICARE-ADV-B
TPATPA-501232026-04-13T12:59:47ZJacob—Hamilton09/19/87-··7252173776—9073 Grand AveColumbusOH43214··GRP-9243MEDICARE-ADV-A··
ENRENR-1265642026-03-13T12:28:45ZWEI—GOMEZ2005-03-13UHC-05045-78•••-••-1413260-974-3152wei.gomez92@gmail.com3593 Ocean Avenue Apt 16·AUSTINTX78708GRP-9864NAVIGATE-HMO
ENRENR-1428972026-07-27T23:31:18Z CAROL··—HAYAS··1942-10-20UHC-21010-07··•••-••-5448—carol.hayes@yahoo.com3739 Ridge RdOrlandoFL—GRP-6631CORE-HMO
ENRENR-1265522026-07-15T00:32:53ZJOSE—·GRIFFIN·19731216UHC-35738-01N/A940-486-0601JOSE.GRIFFIN@PROTON.ME4251 MOUNTAIN VIEW DR··ATLANTAGA30303GRP-6675CHOICE-PLUS-PPO
ENRENR-1171712026-02-05T13:37:08ZCheryl·KRay05-11-1946UHC-15687-67··•••-••-7710787-763-5985CHERYL.RAY78@AOL.COM2287 ELM STREETSan AntonioTX78246·GRP-3415MEDICARE-ADV-B
ENRENR-1045882026-04-21T16:53:28ZBRITTANYA.WATSON1974-05-08UHC-29744-32•••-••-3486(854) 562-1093null2080 UNION STREETScottsdaleArizona85239··GRP-8157medicare-adv-a
TPATPA-626992026-09-23T10:56:07ZEthanSButler1957-01-03UHC-86946-59—2552516678—4299 FOREST AVEColumbusOhio43284-NAVIGATE-HMO
PRVPRV-224032026-10-09T20:49:47ZHudson, SarahV—2008-11-07·--·822-977-2895sarah.hudson88@gmail.com3760 WILLOW CTDenverCO80207—null
ENRENR-1170962026-05-11T15:45:40ZNATALLIEECARPENTER··19930224UHC-94569-81•••-••-7977415-484-7911natalie.carpenter94@proton.me1689 Highland AveSACRAMENTOCA95892GRP-5688CORE-HMO
CLMCLM-4116912026-02-06T17:36:19ZEMILY··GUZMANN/AUHC-12345-16NULLNULLNULL—-·N/A—GRP-9555-··
PRVPRV-245442026-07-20T21:05:47ZPATRICKA.KELLY1994-03-12UHC-50584-30—554-683-0225UNKNOWNUNKNOWN—NULL—UNKNOWN-
CLMCLM-4120872026-02-08T19:06:10ZwalterLalvarez06/02/1941UHC-32233-17•••-••-7106(375) 379-0045··null7531 Forest Ave #512GilbertAZ85232GRP-7948-
ENR ENR-1405862026-07-12T20:36:52ZDiane··TMejia·Nov 10, 1969UHC-22232-12··•••-••-720916589315970diane.mejia@gmail.com5573 Ridge RdMiamiFL33155GRP-8843core-hmo
CLMCLM-4095952026-05-04T02:30:16ZISABELLA—PARKER02/11/1955UHC-22975-41•••-••-8799——3506 Grand AvenueGlendaleArizona··85339·GRP-2034NAVIGATE-HMO
ENRENR-1094322026-04-03T14:24:40ZRICHARDRMEDINA20-06-1988UHC-01593-38•••-••-7473566-955-2739null9218 HIGHLAND AVENUEEden PrairieMinnesota··N/AGRP-7482OPTIONS-PPO
ENRENR-1063982026-03-09T08:57:07ZPriya···VBurton1971-02-22UHC-88178-11•••-••-3823(796) 321-1040priya.burton53@icloud.com5714 PARK PL Apt 24·ColumbusOH43229GRP-8057SELECT-EPO
ENRENR-1020792026-03-24T11:03:51ZDOUGLAS—SHAW2007-05-05UHC-29466-62—(655) 463-8466douglas.shaw18@icloud.com2059 Valley View DrCharlotteNorth Carolina28285GRP-6795··CORE-HMO
ENRENR-1021202026-02-19T13:07:04ZLinda—Harper07/04/62UHC-07597-09•••-••-0571527-253-3308null··3480 VALLEY VIEW DRIVEPLANOTX75008GRP-5884MEDICARE-ADV-B
ENRENR-1386932026-05-19T05:23:48ZPatricia—Wilson1962-09-25UHC-11066-40-268-294-1704··patricia.wilson@aol.com7558 Mesa Dr··ColumbusOH43220GRP-6763NAVIGATE-HMO
CLMCLM-4011612026-05-11T02:55:50ZBryan—HansenNov 13, 1945NULLnull327-698-8031null8525 Highland AveSAN ANTONIOTX78231GRP-1638—
CLMCLM-4034762026-01-04T06:50:13ZDavid—Hall6/4/1949··UHC-32874-59•••-••-9377(585) 606-0670—766 Central AvenueDenverCO80252GRP-8437choice-plus-ppo
ENRENR-1376222026-01-12T19:24:48ZHIROSHI—MCCOYMar 2, 1978UHC-31964-77•••-••-8518438-771-8991hiroshi.mccoy11@proton.me5533 River RoadJacksonvilleFL32240GRP-5371CORE-HMO
ENRENR-1275032026-06-29T07:26:06ZJANICE—SANDOVAL12/23/2003UHC-66768-58•••-••-1239367-284-8392JANICE.SANDOVAL68@GMAIL.COM8538 HIGHLAND AVEOrlandoFL32852GRP-4962CORE-HMO
ENRENR-1325042026-03-09T15:29:06ZALICE—CRUZ1974-09-13UHC-21043-26•••-••-4123516-581-5396alice.cruz98@proton.me·2591 CEDAR LNTampaFlorida33676GRP-4698MEDICARE-ADV-B
TPATPA-566662026-09-05T09:30:08ZJeremy—Long2005-07-23N/Anull756.785.0188—2147 Market StMiamiFL33138null··—
TPATPA-638792026-01-06T13:35:45ZKathryn—Dominnguez1939-12-18N/A--null6195 Apache BoulevardSacramentoCA95854GRP-9268N/A
CLMCLM-4202612026-05-12T05:17:53ZRaymond—Austin07-11-1980UHC-70748-51—2546782802-————GRP-7251SELECT-EPO
ENRENR-1146442026-04-09T17:22:55ZANNAIOSON1954-09-14UHC-72420-10•••-••-5208255.631.7118anna.olson41@aol.com4591 Mesa DrJacksonvilleFL32263GRP-0702MEDICARE-ADV-B
CLMCLM-4186252026-07-29T23:35:27ZEdwadr—Russell1991-02-21UHC-31057-94UNKNOWN14029966099·-7133 MEADOW LANE #832TucsonAZ··85795N/A—
ENRENR-136951 2026-05-01T06:23:40ZSamanthaVRiley1965-12-27UHC-88189-45—·2449878790samantha.riley@yahoo.com5302 Hillcrest Rd Apt 28Orlando·FL32828GRP-3563NAVIGATE-HMO
ENRENR-1015362026-07-15T20:05:35ZAbby····Pena1940-06-13UHC-34131-19•••-••-9783(927) 438-4882—2019 PARK PLACENashvilleTN37267··GRP-8194CHOICE-PLUS-PPO
ENRENR-1203902026-05-12T10:19:01Z TylarN.Luna1977-07-09UHC-66717-89—(856) 915-8143tyler.luna9@proton.me1937 Meadow LaneATLANTAGA30361GRP-3081NAVIGATE-HMO
ENRENR-126239 2026-10-14T20:02:22ZOMARU.FIELDS··1970-08-01UHC-26432-52•••-••-5367—omar.fields@aol.com7580 OCEAN AVEDALLASTX75280-1632GRP-1866CHOICE-PLUS-PPO
TPATPA-622232026-03-04T03:58:05ZMARGARET—JENSENDec 27, 1955UHC-87953-54—·739-302-5588-8046 Sunset BoulevardGlendaleAZ85323—MEDICARE-ADV-B
CLMCLM-4025982026-05-19T18:36:29ZMICHELLENMEDINA·2006-03-15UHC-20779-23•••-••-7670—UNKNOWN2223 Spring StreetAustinTX78785-CORE-HMO
CLMCLM-4209842026-05-15T02:39:21ZemilyBowens2002-03-03N/A•••-••-3728(326) 256-4018·-8088 Lake View RoadTampaFlorida33657UNKNOWNUNKNOWN
CLM CLM-4078352026-10-17T04:19:30ZBenjamin—Ross02-12-1980UHC-35042-30-16157931347—7719 Market StMinneapolisMN55421GRP-9464MEDICARE-ADV-B
100,000 rows, page 124 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.687Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty