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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1133032026-08-25T16:34:47ZROYF.·GRAY1988-02-74UHC-24777-38•••-••-6657(729) 666-4724roy.gray@aol.com··7049 Cedar LnOrlandoFL32880GRP-1399MEDICARE-ADV-B
ENRENR-1085062026-03-24T08:55:01ZHiroshiPNunez··1976-12-20UHC-91613-92•••-••-8749490-907-2204HIROSHI.NUNEZ50@YAHOO.COM9881 Forest AveGilbertAZ·85215GRP-3528navigate-hmo
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
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
ENRENR-1102732026-07-04T16:39:04ZKEITH··Z.ALVAREZ20010818UHC-14541-33··•••-••-04066609361558keith.alvarez@gmail.com6453 INDIAN SCHOOL RDCharlotte···North Carolina28299GRP-8883MEDICARE-ADV-B
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
ENRENR-1170962026-05-11T15:45:40ZNATALLIEECARPENTER··19930224UHC-94569-81•••-••-7977415-484-7911natalie.carpenter94@proton.me1689 Highland AveSACRAMENTOCA95892GRP-5688CORE-HMO
ENR ENR-1405862026-07-12T20:36:52ZDiane··TMejia·Nov 10, 1969UHC-22232-12··•••-••-720916589315970diane.mejia@gmail.com5573 Ridge RdMiamiFL33155GRP-8843core-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
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
ENRENR-1146442026-04-09T17:22:55ZANNAIOSON1954-09-14UHC-72420-10•••-••-5208255.631.7118anna.olson41@aol.com4591 Mesa DrJacksonvilleFL32263GRP-0702MEDICARE-ADV-B
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
ENRENR-1099062026-03-07T20:56:42ZOrtega, LarryX—1967-02-18UHC-85464-51•••-••-630618462904302—2939 SAGE COURTPlanoTX75014GRP-9433MEDICARE-ADV-A
ENRENR-1313982026-08-25T06:49:18ZJOAN—DUNCAN05/04/1993UHC-84887-28•••-••-3797833-260-6249··NULL1439 PARK PLHoustonTX77074GRP-6114CORE-HMO
ENRENR-1125142026-04-13T19:36:13Zadam—garrett12/01/1986UHC-27878-40•••-••-7008(807) 931-1482ADAM.GARRETT@AOL.COM1633 Palm DrLos AngelesCA90078-5976GRP-3997SELECT-EPO
ENRENR-1213102026-07-16T16:05:27ZLaraFLittle1991-07-09UHC-22772-24—7905263748NULL5722 Grand AvenueLas VegasNV·89146GRP-5816MEDICARE-ADV-B
ENRENR-1051342026-06-30T21:19:40ZBrianD.·Bishoop02-01-1959UHC-60626-53•••-••-3079238.325.1453brian.bishop92@aol.com·1478 Lincoln WayPLANOTX75057GRP-0173MEDICARE-ADV-A
ENRENR-1288912026-09-19T13:21:55ZLawrence—Dominguez01/28/94UHC-42734-36•••-••-1153302-940-9460lawrence.dominguez@hotmail.comUNKNOWNnullNULLnullGRP-9519··MEDICARE-ADV-A··
ENRENR-1249202026-01-18T06:44:07ZLAURENLWASHINGTON10/28/1965UHC-74755-05•••-••-19238856518679lauren.washington13@hotmail.com6518 Harbor BoulevardScottsdaleAZ85232GRP-3236MEDICARE-ADV-A
ENRENR-1110822026-10-02T06:33:53ZHenderson, Anthony——1989-01-09UHC-92935-47null226.227.0341null3140 Central AvenueTucson··AZ85701GRP-2465NAVIGATE-HMO
ENRENR-1320022026-09-19T15:59:28ZStephanie—Perry2004-05-21UHC-67445-50•••-••-8574(363) 716-1865stephanie.perry26@icloud.com8437 JEFFERSON AVEColumbusOHNULLGRP-2737MEDICARE-ADV-B
ENRENR-1024102026-05-13T02:24:26ZLoriTJenkins1942-03-08uhc-04155-85··•••-••-56126364362211lori.jenkins@yahoo.com6063 Market StreetNashvilleTN37280GRP-4075MEDICARE-ADV-B
ENRENR-1342802026-01-29T13:04:55ZRachhel—Hraper12/13/1939··UHC-28835-89•••-••-2888328-399-8405NULL5937 Willow CtMinneapolisMN55407GRP-7516OPTIONS-PPO
ENRENR-1164602026-08-30T20:02:06ZRojas, Jean——1967-09-27UHC-90958-81—NULLJEAN.ROJAS@GMAIL.COM3453 BROADWAYOrlandoFL32829GRP-0969CORE-HMO
ENRENR-1169592026-01-16T13:36:05ZAnnaPTorres·2005-04-23UHC-62997-94•••-••-80565402567457UNKNOWN9611 Sage CourtPlano··TX75069GRP-2224MEDICARE-ADV-A
ENRENR-1166272026-03-11T10:49:02ZShirley—·Coleman03/14/1954UHC0958807•••-••-3142428-842-0235shirley.coleman55@gmail.com6553 Lake View RdAustin··Texas··78755GRP-9998MEDICARE-ADV-A
ENRENR-128518 2026-07-08T09:45:16ZIsabella—Santos12/02/85UHC-21801-43•••-••-3917+1 814 922 6535isabella.santos@aol.com7088 Market StreetTempeAZ85211GRP-3180··SELECT-EPO
ENRENR-1151172026-08-12T04:28:00ZJERRYLRIEY1941-10-02UHC-25201-66•••-••-84387839840UNKNOWN4607 Pine Drive··CharlotteNC28214GRP-0254MEDICARE-ADV-B
ENRENR-1086242026-08-05T06:44:40ZEugeneG.Cox1983-02-14UHC-38773-39•••-••-01099205851897eugene.cox@yahoo.com28 Spring St·MiamiFL33105GRP-8477CHOICE-PLUS-PPO
ENR ENR-1290642026-02-27T22:35:56ZMARTHAXREID1/12/1981UHC-18004-07•••-••-8177(345) 360-9355—1230 Camelback RoadAtlantaGA30304GRP-1130SELECT-EPO
ENRENR-1306252026-02-04T02:18:26ZJacquelineVRamirez1995-07-09UHC4288992•••-••-9289null—1601 Washington St··TEMPE··AZ85247GRP-6048MEDICARE-ADV-A
43,101 rows, page 55 of 863PreviousNext

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