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-1130802026-04-13T18:05:33ZJudith—Bishop1958-09-24UHC-74677-31•••-••-0631(611) 861-7870judith.bishop@icloud.com4725 Willow CourtMinneapolisMN55458GRP-2987SELECT-EPO
ENRENR-1068292026-01-28T08:33:53ZKimberlyNOliver04/05/08UHC-97879-20•••-••-750516694709487kimberly.oliver@aol.com·1498 Hillcrest RdSan AntonioTX78244GRP-1792NAVIGATE-HMO
ENRENR-1062462026-02-03T05:45:58ZClark, Peter——08-06-1947UHC-99363-17•••-••-719616056117774PETER.CLARK46@PROTON.ME275 Cedar Lane #858DenverCO80294GRP-6727SELECT-EPO
ENRENR-1055632026-07-27T00:03:23Z carlYli9/6/1956UHC-41105-72··•••-••-6429+1 517 912 2797carl.li@icloud.com8507 Highland AvenueHoustontxNULLGRP-4984SELECT-EPO
ENRENR-1364592026-01-29T17:54:46ZomarFobrien1988-03-08UHC-69499-80•••-••-04912582826694omar.obrien12@gmail.com8999 Main StDallasTX··75298GRP-7576CHOICE-PLUS-PPO
ENRENR-1000092026-08-15T06:09:50ZShirley—Hernandez1964-01-10UHC6016588•••-••-1341·460-773-8796shirley.hernandez93@hotmail.com——null····GRP-5397MEDICARE-ADV-A
ENRENR-1381522026-03-02T01:57:49ZWalter—GomezMay 22, 1946UHC-83989-37•••-••-44685906943061NULL··2117 CAMELBACK ROADChandlerArizona85299··GRP-6832··CHOICE-PLUS-PPO
ENR ENR-1297052026-02-12T02:26:42ZSophiaHFosterAug 12, 1990UHC-38594-20•••-••-5473236-425-6732SOPHIA.FOSTER50@YAHOO.COM6771 Forest AvenueOrlandoFL32893GRP-0992MEDICARE-ADV-A
ENRENR-1255492026-09-07T01:06:52ZKATHRYN—ROBINSON1940-03-02UHC-31863-09—644.880.5619N/A——-NULLGRP-2256NAVIGATE-HMO
ENRENR-121631 2026-05-18T03:12:46ZLISA—LEWIS·1951-03-27UHC-05664-71•••-••-16983463681261null·2672 Park PlJacksonvilleFL32202GRP-8345options-ppo··
ENRENR-1033742026-01-17T10:18:45ZNichols, Madison——19991021UHC-83753-93•••-••-3719267.353.2181—2676 Ridge Rd··JACKSONVILLEFL32288GRP-2748OPTIONS-PPO
ENRENR-1079742026-07-22T10:59:15ZDebraVCollisn·1980-11-19UHC-86010-85•••-••-8841—·DEBRA.COLLINS@YAHOO.COM6116 Market StSACRAMENTOCA··95866GRP-9288NAVIGATE-HMO
ENRENR-1027102026-04-02T07:03:44ZBrian··GHamiltonAug 14, 1940UHC-68025-63•••-••-0433-NULL7947 River Road #235ScottsdaleAZ85227GRP-6616NAVIGATE-HMO
ENRENR-1308562026-08-13T03:36:40ZARTHUR—GARRETTFeb 17, 1991UHC-98433-73•••-••-7671(760) 455-5393NULL4997 Camelback Road··MiamiFlorida33122-2121GRP-1843NAVIGATE-HMO
ENRENR-1260942026-07-20T18:04:52Z ·JohnnyOStephens2002-01-16UHC-11327-76•••-••-85234467018786JOHN.STEPHENS@ICLOUD.COM2468 Pine Drive #206MiamiFL33102GRP-3369CHOICE-PLUS-PPO
ENRENR-1383692026-10-08T01:16:31Zyuki—harris10-05-1949UHC-35598-38•••-••-3306—YUKI.HARRIS@AOL.COM7770 Canyon Rd #727··Austin··TX78755GRP-9528CORE-HMO
ENRENR-1305482026-06-24T09:29:49ZPriyaNReed1957-04-23UHC-98300-62•••-••-6429(238) 877-7405NULL3163 LAKE VIEW RDSan AntonioTX78215GRP-5732MEDICARE-ADV-A
ENRENR-1346702026-07-28T17:54:11ZChristopher—Burke9160-05-08UHC-49095-58•••-••-8823807-981-6504christopher.burke99@icloud.com9054 Cedar Lane··Denver·CO80243GRP-6170··NAVIGATE-HMO
ENR ENR-1192372026-03-11T19:55:00ZSandoval, SeanN—May 28, 1955UHC-11554-69UNKNOWN(651) 378-2669sean.sandoval@yahoo.com··4121 Hillcrest RdDallastx75205GRP-5778SELECT-EPO
ENRENR-1017882026-04-30T09:19:32ZDouglas—Carlson01/28/39UHC-97519-33•••-••-5478——3127 Washington St Apt 34AustinTX78718GRP-7892MEDICARE-ADV-A
ENR ENR-1225832026-04-07T04:53:45ZPeter—Siva07/15/64UHC-85660-24•••-••-6992+1 851 612 0948PETER.SILVA90@OUTLOOK.COM5964 River RoadTAMPAFL33621GRP-1163SELECT-EPO
ENRENR-1137612026-07-09T18:00:03ZDebraSAlvarez1979-06-25UHC-54280-04—8698753debra.alvarez@yahoo.com2061 Broadway··Eden Prairie·MN55376GRP-5995NAVIGATE-HMO
ENRENR-126540 2026-03-04T00:26:57ZSCOTTPHUGHES··1958-01-10UHC-53716-26N/A821.748.5157SCOTT.HUGHES1@GMAIL.COM5069 Lincoln Way #614OrlandoFL32854-1643GRP-8068OPTIONS-PPO
ENRENR-1300392026-06-27T11:33:02ZMei—Scott1958-03-16UHC-55509-56•••-••-1205·687.532.7152mei.scott@outlook.com3062 Forest AveFresnoCA93708GRP-4727MEDICARE-ADV-A
ENRENR-1267202026-03-23T14:32:50Zjoyce··li1940-05-15UHC-63707-36•••-••-1742·4346759024null6266 River RoadATLANTAGA30365GRP-5557CHOICE-PLUS-PPO
ENRENR-1198322026-04-30T20:38:24ZDIANASRUSSELL1941-12-27UHC-00530-80•••-••-54108985095934diana.russell@hotmail.com··6622 Mesa DriveLas VegasNV89164··GRP-3581CORE-HMO
ENRENR-1308612026-03-13T11:44:04ZEric—Clark·1981-10-28UHC-57722-74··•••-••-5745466-751-0817NULL·4753 Highland AvenueSan AntonioTX78213GRP-1689MEDICARE-ADV-A
ENRENR-1204782026-07-28T00:01:44ZKathrynT.Dunn2003-01-17UHC-91234-39•••-••-2054758-932-5966KATHRYN.DUNN@GMAIL.COM6922 Park PlDenverCO80261GRP-7919options-ppo
ENR ENR-1171512026-05-29T09:23:02ZPATRICK—PEREZ05/24/75UHC-74189-68•••-••-0456(487) 557-1896N/A6266 CEDAR LNGilbertAZNULLGRP-0468OPTIONS-PPO··
ENRENR-1300472026-08-25T18:59:26ZFisher, KathyJ—1940-06-22UHC7626513··•••-••-21664052561273KATHLEEN.FISHER@GMAIL.COM8461 HARBOR BLVDSan DiegoCalifornia··92108GRP-0660CORE-HMO
ENRENR-1400962026-09-18T02:24:07ZRicard—Stevens1990-10-09—•••-••-0940+1 810 577 5724richard.stevens@outlook.com526 Apache BoulevardColumbusOH43274··GRP-4419SELECT-EPO
ENRENR-1076162026-04-15T11:11:46ZNathanKMoore2000-08-01UHC-49058-08•••-••-5828(827) 231-8244nathan.moore@hotmail.comnullUNKNOWN——GRP-6645MEDICARE-ADV-A
ENRENR-1021052026-08-30T18:31:27ZAndrew··XWillis1947-09-04UHC-40816-30•••-••-3461·201.529.1568ANDREW.WILLIS84@HOTMAIL.COM777 Willow CtEDEN PRAIRIEMN55337GRP-2988NAVIGATE-HMO
ENRENR-1155612026-09-20T00:41:13ZMorales, VicotriaW—1951-10-05UHC-18505-75•••-••-77428644412460victoria.morales37@icloud.com7253 Spring StreetSacramentoCA95897GRP-1103SELECT-EPO
ENRENR-1145922026-01-11T10:30:15ZdorothyY.wang1947-05-08UHC-35536-05•••-••-5631634.948.9563dorothy.wang@hotmail.com2326 Grand AvenueMesaArizona85220GRP-7025CHOICE-PLUS-PPO
ENRENR-1354672026-04-26T19:35:05ZBRIAN··ZHARRISON1988-07-14··UHC-75575-46•••-••-0229463-415-2441brian.harrison@proton.me7055 Canyon RdSan DiegoCA92144GRP-6698NAVIGATE-HMO
ENRENR-1273132026-06-05T11:55:39ZDanielle—Russell07/01/91UHC-65006-18—(473) 916-4877danielle.russell@gmail.com2379 Forest AveTUCSONAZ85737GRP-4830CHOICE-PLUS-PPO
ENRENR-1259912026-05-10T01:59:07ZGERALD·QANDERSON1945-02-25uhc-82667-02•••-••-679917266486425gerald.anderson63@icloud.com8501 Willow CourtFresnoCA93703GRP-5622OPTIONS-PPO
ENRENR-1342232026-07-04T07:17:49ZRebecca—Dunn1945-09-20UHC-28867-84null(986) 383-1536-3054 Harbor BoulevardSacramentoCalifornia95884GRP-4538OPTIONS-PPO
ENRENR-1172272026-06-03T18:18:52ZMellissa—Riley10/9/2008UHC-33889-91•••-••-5909(315) 389-8463UNKNOWN··5292 Forest AvenueDenverCO80293GRP-3302MEDICARE-ADV-B
ENRENR-1286322026-03-17T12:18:12ZWalterHBrooksOct 9, 1951UHC-01528-36•••-••-7418746-755-7640walter.brooks@gmail.com2178 WASHINGTON STPhoenixAZ85041GRP-8886MEDICARE-ADV-B
ENRENR-1207332026-10-15T02:45:59ZAishaFGordon12-06-1975UHC-01782-66•••-••-4976522-836-5004AISHA.GORDON69@OUTLOOK.COM1950 Canyon RdCHANDLERAZ85283-0206··GRP-3117CORE-HMO··
ENRENR-120918 2026-04-02T13:41:10Z·TeresaVTraan2000-05-05UHC-95163-01•••-••-7932389-894-1942—1624 Mesa DrSCOTTSDALEAZ85254GRP-2954NAVIGATE-HMO
ENRENR-1356602026-06-20T10:12:38ZSHARONHBLACKJan 15, 1957UHC-75238-63•••-••-6677306.535.5621null7161 Main StreetTempeAZ85260GRP-3348··CHOICE-PLUS-PPO
ENRENR-1207712026-10-11T23:45:13Zandrew—cole06/14/63UHC-24696-29•••-••-8835—andrew.cole67@proton.me8388 Cedar Ln·MESAAZ85218GRP-7619NAVIGATE-HMO
ENRENR-1409152026-01-23T13:19:22ZDONALDDPRICE1990-06-06··UHC9839801—461-879-2627DONALD.PRICE@AOL.COM1458 Oak StreetSan AntonioTXUNKNOWNGRP-5550CORE-HMO
ENRENR-127990 2026-10-18T17:47:47ZJacquelineR.Singh10/16/1983UHC-41910-36•••-••-5794—N/A8898 Forest AveDenverCO—GRP-6412CHOICE-PLUS-PPO
ENRENR-1324592026-05-01T07:25:40ZTylarKRamirezDec 2, 1998UHC-59537-21—+1 928 900 1602tyler.ramirez@yahoo.com8319 PALM DRIVEAustinTX78719GRP-9020··CORE-HMO
ENRENR-1326042026-08-23T13:34:33ZandrewHpalmer1939-02-02UHC-25445-68•••-••-2702(472) 711-1552-4190 Meadow LaneSACRAMENTO··CA····GRP-5113CORE-HMO
ENRENR-1063222026-02-06T05:39:18ZBilly··CGibosn2008-04-13UHC-06894-24•••-••-2036571-727-4213billy.gibson@aol.com3004 Sunset BoulevardTucsonAZ—GRP-1493···options-ppo
43,101 rows, page 102 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:37.738Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty