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-1166322026-08-28T15:32:33ZKathleen·Q.Wright5/25/1949UHC-81490-13•••-••-9952null—4168 Oak StFresnoCA93768GRP-9323MEDICARE-ADV-B
ENRENR-1091572026-07-08T21:02:28ZPriyaPWebb1983-06-28UHC-01077-32•••-••-554613952917551—·2650 OAK STREET #165ChandlerAZ85214GRP-7239MEDICARE-ADV-B
ENRENR-1419872026-01-26T06:13:15ZEMIYLN··COLEMAN19890705UHC-34875-70NULL4516399546null————GRP-8411MEDICARE-ADV-A
ENRENR-1214002026-06-01T14:21:28ZrachelJ·perkins10/24/1979··UHC-17278-72•••-••-06065195095736—·9847 Spring StAtlantaGeorgia30310GRP-7699NAVIGATE-HMO
ENRENR-1420872026-01-26T01:30:17ZThomas—Meyer2001-10-01·UHC-55702-01•••-••-7572750-686-9766thomas.meyer69@outlook.com1824 CANYON RDGilbertAZ85206GRP-3687MEDICARE-ADV-A
ENRENR-1018322026-08-08T07:03:50ZLe, HeatherH.—1960-09-15UHC-10593-35•••-••-4809659.548.6190heather.le44@icloud.com5299 Desert Sky Boulevard Apt 33AustinTX·78740·GRP-6762CHOICE-PLUS-PPO
ENRENR-1219402026-07-23T06:54:43ZRomero, Camila··—1941-04-20UHC-45685-14•••-••-6707·396-804-7708camila.romero45@aol.com6264 Forest AveTAMPAFL33674GRP-3049CORE-HMO
ENRENR-142858 2026-06-28T02:46:44ZOmmar—Brown04/25/1963UHC-35610-05•••-••-4984+1 517 546 0617—305 Bayshore Dr #791AustinTX78735GRP-1537OPTIONS-PPO
ENRENR-1276042026-05-26T11:08:46ZBobby—Gray2/3/1989UHC-77275-12•••-••-8650249-451-3302BOBBY.GRAY41@PROTON.ME6897 ELM STMiamiFL··33115GRP-2834MEDICARE-ADV-B
ENRENR-1158722026-06-28T04:27:22ZKelly··Cook4/1/1991UHC-28787-18•••-••-55333062232N/A7453 CANYON RDMesaaz85275··GRP-7373CORE-HMO
ENRENR-1199382026-02-21T19:45:05ZMorrison, MarianaN—1948-12-26UHC-95112-56•••-••-9397—mariana.morrison@gmail.com2787 Camelback RdChandlerAZ85258GRP-3139CORE-HMO
ENRENR-1290472026-01-30T05:01:43ZPATRICIA E.—SANCHEZ1942-07-20UHC3939407•••-••-3552(838) 655-5550PATRICIA.SANCHEZ84@OUTLOOK.COM8616 Bayshore Drive··CHANDLERAZ··85240-4214GRP-8549CHOICE-PLUS-PPO
ENRENR-1098992026-06-09T11:38:40ZCar, Gregory——19740810UHC-45524-46—(478) 758-5362gregory.carr83@aol.com9728 Pine DrDallasTexas75245GRP-3368OPTIONS-PPO
ENRENR-1325762026-08-01T10:16:17ZFrancesW.Thompson1992-11-10UHC-79092-60•••-••-948314757492320NULL·6833 SUNSET BOULEVARD·PLANOTX75031GRP-3735NAVIGATE-HMO
ENRENR-1082062026-03-28T11:54:17ZAshleyCKim1975-12-28UHC9697437•••-••-8794(842) 609-0029ashley.kim@yahoo.com4485 FOREST AVETEMPEAZ85263GRP-2980CORE-HMO
ENRENR-1200962026-03-24T06:38:48ZReed, AbigailQ.—19860719UHC-99894-11•••-••-4920537-419-2280abigail.reed7@gmail.com8479 Spring StreetTampa··FL33650GRP-2404OPTIONS-PPO
ENRENR-1335622026-06-02T10:08:56Z·Jack—Kennedy19550314UHC-82804-57•••-••-5682811-980-3553jack.kennedy@proton.me1930 Valley View DriveOrlandoFLNULLGRP-5840OPTIONS-PPO
ENRENR-1273632026-03-05T15:51:08ZANDREW··BANKS19540518UHC-11509-58•••-••-5137(595) 514-8449andrew.banks2@aol.com7387 Main StreetCHANDLERAZ··85259GRP-1520MEDICARE-ADV-B
ENRENR-1155662026-08-13T02:32:56Z·ZACHARYZ.SIMPSON1964-12-08UHC-83668-28•••-••-80457648769980zachary.simpson@icloud.com5711 CHURCH ST··MiamiFL33183GRP-8021NAVIGATE-HMO
ENRENR-1127432026-05-26T09:10:46Zsophia···taylorJul 18, 1986UHC-53505-21•••-••-0206215.651.9022—9815 WASHINGTON STREETOrlandoFL32842GRP-9117MEDICARE-ADV-A
ENRENR-1268862026-07-23T02:31:44ZmariaRmarshall1961-02-19UHC-73511-04•••-••-7750240-342-3474maria.marshall8@outlook.com5013 FOREST AVELas VegasNV89145-8346GRP-4530··OPTIONS-PPO
ENRENR-1062422026-05-11T19:02:17ZSofia—FernandezUNKNOWNUHC-82111-99•••-••-5845976-527-6749sofia.fernandez@outlook.com2511 GRAND AVEPLANOTX75046GRP-0736OPTIONS-PPO
ENRENR-1160152026-08-18T08:58:32ZMichelle—Hayes1957-04-13UHC-81661-07•••-••-8304(864) 264-1798null4123 Park PlDenverCO80208GRP-8485MEDICARE-ADV-A
ENRENR-1012162026-08-25T00:06:34ZCATHERINEI.HOFFMANJan 28, 1949UHC-61532-06•••-••-5818474-438-5613catherine.hoffman@aol.com5813 Indian School RdSAN DIEGOca92113GRP-7376OPTIONS-PPO
ENR ENR-1403282026-05-01T05:52:15ZNatalieN.Mendez··2004-09-09UHC-08282-03•••-••-803117342635192natalie.mendez54@outlook.com2534 Mesa DrEden PrairieMN55326GRP-9331SELECT-EPO
ENRENR-1258502026-07-03T11:07:30ZMariaY.Woods2000-05-04··UHC-74123-21•••-••-41983539181128UNKNOWN·8856 CENTRAL AVENUEFRESNOCA93747GRP-2206OPTIONS-PPO
ENRENR-1265122026-10-05T16:49:37ZJacquelineBRobinson09/01/61UHC-85264-95•••-••-5298UNKNOWNjacqueline.robinson95@hotmail.com9778 PINE DRIVESACRAMENTOCA95886GRP-4949MEDICARE-ADV-A
ENRENR-1332292026-06-13T16:58:01ZJEREMY—CRUZ·1952-07-06UHC-05311-82—(364) 486-5549jeremy.cruz@aol.com6553 River Road #231OrlandoFL··32829GRP-8271MEDICARE-ADV-A
ENRENR-1386692026-03-15T14:15:28ZCAROL·WTURNER04-06-1988UHC-66102-25•••-••-23678674376699CAROL.TURNER@HOTMAIL.COM834 HIGHLAND AVENUEEden PrairieMinnesota55325GRP-4125select-epo
ENRENR-1251892026-03-17T05:36:58ZCYNTHIABTURNER1951-09-10UHC-24518-02•••-••-15012889418563-8782 Hillcrest RdMiamiFL33107GRP-1930SELECT-EPO
ENR ENR-1109272026-01-10T22:02:22ZJENNIFERAROGERS06/12/1942UHC-08853-68•••-••-9705·223-755-3006jennifer.rogers5@aol.com··5864 Union StScottsdaleAZ··85299GRP-8080··SELECT-EPO
ENRENR-1269772026-05-17T07:19:30ZBruce—Perkins1973-10-17UHC-27600-51•••-••-7231(324) 492-3641N/A·8366 Lake View RdLOS ANGELESCA90048GRP-7908SELECT-EPO
ENRENR-119960 2026-04-07T16:58:11Zjennifer··vazquez1949-12-28··UHC-17096-95•••-••-5062(281) 276-4051·JENNIFER.VAZQUEZ88@YAHOO.COM7536 Spring St·GlendaleAZ85393GRP-1066choice-plus-ppo
ENRENR-1101902026-03-21T11:58:11Z BETSYD·CASTRO1966-07-10·UHC-35024-26•••-••-8442(821) 744-2326ELIZABETH.CASTRO54@GMAIL.COM133 Main StSan DiegoCA··92150GRP-7013MEDICARE-ADV-A
ENRENR-1395882026-04-15T06:38:00ZCatherine—Riley1999-11-09uhc-20404-24··•••-••-8432+1 523 903 9881·catherine.riley99@hotmail.com7227 CANYON RDMESAAZ·NULLGRP-5636NAVIGATE-HMO
ENRENR-1106502026-01-26T05:16:43ZABIGAIL—·BRADLEY05/23/1974NULL•••-••-0570806-264-6214abigail.bradley47@hotmail.com3110 Church StMesaAZ85210-5074GRP-2769NAVIGATE-HMO
ENRENR-1205752026-03-22T22:07:17ZLORI··VHUNT1101-19-43UHC-01871-59··•••-••-7511—N/A6594 Maple AvenueAtlantaGA·30365GRP-1488CHOICE-PLUS-PPO
ENR ENR-1187192026-08-29T18:45:42ZWong, JonathanF—04/11/76UHC-36675-44•••-••-82695996510525jonathan.wong34@proton.me7028 CANYON ROADOrlandoFL32815GRP-4920SELECT-EPO
ENRENR-1394742026-05-19T21:34:21ZaustinMknight1938-02-20UHC-16690-66•••-••-3402(369) 995-0770austin.knight@hotmail.com8220 Oak StMinneapolisMinnesota55400GRP-8610MEDICARE-ADV-B
ENRENR-1154142026-01-28T14:33:37ZWEIRROBINSON19850076UHC-00977-64•••-••-17392025315396·WEI.ROBINSON@YAHOO.COM5506 DESERT SKY BLVDLos AngelesCA·90005GRP-2994SELECT-EPO
ENRENR-1029472026-03-10T13:54:07ZlawrenceK·johnston1952-10-18··UHC-57335-96•••-••-27015238041388-5968 PARK PLChandler·AZ85223GRP-0133MEDICARE-ADV-B
ENRENR-1352182026-02-20T05:43:01Z Olivia—Porter··1947-09-16UHC1905890··756-265-8673olivia.porter64@hotmail.com·5621 PARK PLACEHoustonTX77017GRP-2506SELECT-EPO
ENRENR-1106062026-02-19T11:35:02ZOlson, Joe R.——UNKNOWNUHC6382007•••-••-3939·7254738158JOE.OLSON32@PROTON.ME449 Apache Blvd #838TampaFlorida33683GRP-5867navigate-hmo··
ENRENR-1243262026-08-04T02:45:06ZAlna—Hunt19411117uhc-94748-44•••-••-4340·741-843-6421—2719 Lincoln WayPlanoTexas75087GRP-7600OPTIONS-PPO
ENRENR-1197332026-07-27T00:05:16Z·BRENDAP.MARTIN1947-08-27UHC-38052-66•••-••-3352(328) 705-7641NULL1423 FOREST AVECharlotteNorth Carolina··N/AGRP-5521SELECT-EPO
ENRENR-1298362026-03-27T01:44:58ZBetty····Santiago19380207UHC-84720-46•••-••-7891(976) 528-0152BETTY.SANTIAGO@ICLOUD.COM··6786 Elm StColumbusOH43213·GRP-7200MEDICARE-ADV-B
ENRENR-1200062026-07-30T12:12:36ZAHMED—SALAZAR2001-10-10UHC-70661-98•••-••-6808N/A··ahmed.salazar@aol.com7568 Washington StreetLos AngelesCA—GRP-5290NAVIGATE-HMO
ENRENR-1184332026-06-25T04:20:22ZBRYANZ.LAWSON1978-11-16UHC-65742-93UNKNOWN7739164030bryan.lawson@aol.com121 Desert Sky BoulevardTUCSONAZ··—GRP-7719NAVIGATE-HMO
ENRENR-1213472026-08-28T20:23:53Z BARBARAW.HARRIS19950221UHC-90213-48•••-••-3281+1 260 583 4906BARBARA.HARRIS@AOL.COM5369 Bayshore DriveGilbertAZ85294GRP-8982CORE-HMO
ENRENR-1072762026-08-11T00:57:55ZDANIELLE—WALSH1984-02-04UHC-00298-63•••-••-7083+1 945 998 6966danielle.walsh45@gmail.com9278 River RoadColumbusOH43250GRP-8955CORE-HMO
43,101 rows, page 206 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:40.347Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty