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
ENR ENR-1323212026-03-21T06:58:31ZTimothy—Moreno1986-04-19UHC-68739-51•••-••-97145796382277null6169 Ocean AvenueTucsonAZ85716GRP-9830navigate-hmo
ENRENR-1212352026-10-15T10:23:17ZAndrea—Thomas19380228·UHC-67365-40•••-••-6295784.481.1884UNKNOWN··638 Indian School RdJacksonvilleFL32278GRP-2358MEDICARE-ADV-B
ENRENR-1077772026-06-06T09:06:14ZSteven—Salazar1950-05-26UNKNOWN—438-585-2568STEVEN.SALAZAR@HOTMAIL.COM694 Bayshore Drive #764FresnoCA93798GRP-7140select-epo
ENRENR-1071132026-05-03T06:55:07ZKeith—Ortega1978-12-20UHC-38565-14•••-••-6507(520) 416-3841KEITH.ORTEGA@GMAIL.COM—-—NULLGRP-5228CORE-HMO
ENRENR-1002882026-04-22T09:33:27ZANDREAR.MENDOZA···1949-05-24UHC-31553-52•••-••-8587+1 614 363 2941ANDREA.MENDOZA@HOTMAIL.COM3821 Willow CtDENVERCO80230··GRP-0616MEDICARE-ADV-A
ENRENR-119943 2026-08-31T22:13:45ZWei—Carr9177-01-10UHC-15206-89•••-••-8332(212) 529-9826wei.carr77@proton.me174 MESA DRJacksonvilleFL32269··GRP-6164MEDICARE-ADV-B
ENRENR-1230952026-06-25T22:22:57Z DONALDN··BUTLER1947-12-10-··•••-••-5416(306) 975-0455-·172 Baseline RdHoustonTexas77089GRP-7219·MEDICARE-ADV-B
ENRENR-1429542026-07-28T20:03:46ZDoris—West—UHC-47060-88··885.996.6541doris.west@icloud.com1429 CANYON RDSan Diegoca92179GRP-4212SELECT-EPO
ENRENR-1237572026-05-19T16:13:39ZBryanD.··Morrison5/12/2007UHC-71309-50•••-••-3397(277) 658-3270BRYAN.MORRISON@OUTLOOK.COM3627 Elm StreetSacramentoCA95803GRP-7031SELECT-EPO
ENRENR-1099822026-06-08T22:07:18ZZACHARY—WHITE1979-02-10UHC-40406-22•••-••-13988288816842zachary.white75@proton.me3514 MEADOW LNGilbertAZ85268GRP-4331CHOICE-PLUS-PPO
ENRENR-1126832026-06-24T22:25:22Z Henry····Graham1955-02-24UHC-04190-61•••-••-045112093363473-9650 Bayshore DrSan AntonioTX—GRP-9166MEDICARE-ADV-A
ENRENR-1129892026-05-08T06:07:46Z·ERCIB.FISHER1942-10-10UHC-76932-93•••-••-5896+1 714 412 3803—799 LAKE VIEW RD·ChandlerAZ··85244GRP-9945CORE-HMO
ENRENR-1123622026-03-02T02:05:31ZTheresaFFerguson1971-08-02UHC-72869-72•••-••-2733(816) 981-8524theresa.ferguson@icloud.com4160 Harbor BlvdDallasTX75223-6117GRP-1831NAVIGATE-HMO
ENR ENR-1196082026-04-11T05:23:25ZJOE—EDWARDDS08/22/94UHC-54824-57•••-••-08979314941398jose.edwards@proton.me6240 ELM STREETMesaAZ85249··GRP-4980MEDICARE-ADV-B
ENRENR-1269662026-02-17T10:55:47ZalanNpowell19861020·UHC-61794-36•••-••-79097382050511—4543 HARBOR BLVDSan AntonioTX78203-1802GRP-1043OPTIONS-PPO
ENRENR-1024932026-07-19T00:22:22ZJOSEG.OLSON1944-06-25UHC-21968-19———UNKNOWN—null—GRP-4952options-ppo
ENRENR-1033892026-08-08T03:47:07ZANTHONY·JHOFFMAN1977-01-02UHC-25832-74•••-••-6752586-301-6837anthony.hoffman@outlook.com7546 Main StMesaAZ85263GRP-9953MEDICARE-ADV-A
ENRENR-1302982026-07-24T03:02:20ZAHMEDDDAVIS1939-05-12UHC-93970-69•••-••-43597707282806—9123 Cedar LanePlanoTX75054GRP-7335OPTIONS-PPO
ENR ENR-1336552026-07-06T08:47:11ZBRENDAH.WELLS1961-07-12UHC-70706-56•••-••-78376507345717—5623 Maple Ave·MesaAZ85251GRP-3724SELECT-EPO
ENRENR-1389782026-09-04T04:58:42ZNOAH—HUDSON1970-10-06UHC-94282-09•••-••-7693298-948-7394—8252 WASHINGTON STREETSacramentoCA95820GRP-1695NAVIGATE-HMO
ENRENR-1095912026-09-21T11:27:01ZWillieAHarrisonFeb 21, 2004UHC-05201-04NULL3058660067null8401 INDIAN SCHOOL RDMesaAZ85208GRP-1690OPTIONS-PPO··
ENRENR-1324962026-06-30T11:47:24ZBrian—Rogers1976-07-17UHC-74277-16•••-••-31487956487UNKNOWN2065 Baseline RoadTucsonArizona85791-1047GRP-4378·MEDICARE-ADV-A
ENRENR-1140582026-03-17T08:30:49Z Nelson, HaroldU.—09/18/1971UHC-43965-26•••-••-6307319-596-5425harold.nelson@aol.com918 ELM ST #112AustinTexas78796GRP-0183SELECT-EPO
ENRENR-1055432026-07-24T15:43:42ZANTHONY—BURTON1974-03-27UHC9218455•••-••-61242235633ANTHONY.BURTON52@YAHOO.COM7992 Valley View DrNashvilleTennessee37244GRP-1034CORE-HMO
ENRENR-1155722026-06-14T02:53:56ZMeyer, TonyK—12/20/1985UHC-88421-50•••-••-39452232304602anthony.meyer@hotmail.com7567 Harbor BlvdDallasTX75269GRP-8136NAVIGATE-HMO
ENRENR-1354712026-08-03T09:23:11ZLinda—Warren1955-03-10UHC1467502•••-••-8058(283) 612-8657linda.warren@gmail.com2619 OCEAN AVENUEMiamiFL33122·GRP-3098·MEDICARE-ADV-B
ENRENR-1031802026-05-28T15:21:07Z JOHNRCARR11/27/1973UHC-01911-50•••-••-6907·6192536105john.carr78@proton.me6104 HARBOR BOULEVARDDENVERCO80220GRP-3632SELECT-EPO
ENRENR-1430102026-03-24T19:23:32ZNICHOLESTROSE23-04-1970UHC-29927-87null(631) 915-9086nicholas.rose@proton.me3939 RIDGE ROADMiamiFL33127GRP-4175NAVIGATE-HMO
ENR ENR-1151702026-09-27T09:30:47ZCarolRGordon1958-11-22UHC-27402-14•••-••-2029+1 616 881 8448—227 Canyon Rd·SeattleWA98190GRP-2110OPTIONS-PPO
ENRENR-1115502026-01-12T05:42:09ZJUSTIN·IWILLIAMS06/26/83UHC-16413-13•••-••-48482132093236justin.williams@hotmail.com7613 Mountain View DrSan DiegoCA92117GRP-4244··SELECT-EPO
ENRENR-1388922026-06-06T01:11:27ZShaw, Jenny——1998-12-17UHC1841849•••-••-9119775-362-9460jennifer.shaw@proton.me··3731 Lincoln Way Apt 3Las Vegas·NV89125·GRP-4548SELECT-EPO
ENRENR-1343922026-08-30T12:08:36ZCHARLES··MHOFFMAN21-06-1958UHC-08773-02•••-••-10482152540032charles.hoffman69@yahoo.com2378 BAYSHORE DRIVE Apt 2MesaArizona85275GRP-4113CHOICE-PLUS-PPO
ENRENR-1408272026-09-15T15:44:21ZBEVERLY—BROWN23-03-1993UHC-97823-17•••-••-81377905314712beverly.brown@icloud.com8738 Canyon RdNashvilleTN37241GRP-8825MEDICARE-ADV-A
ENRENR-1104522026-05-18T17:49:49Z ·OMARI.GUERRERO1951-12-09UHC-89846-05•••-••-05927324128688·omar.guerrero@outlook.com7467 BAYSHORE DRGlendaleAZ85319GRP-2149CORE-HMO
ENRENR-1245152026-03-30T13:30:11ZABIGAIL—SANDOVAL1998-03-11UHC-26589-69•••-••-52378464016197ABIGAIL.SANDOVAL@ICLOUD.COM5932 Sunset BlvdTEMPE·AZ85268GRP-4418CHOICE-PLUS-PPO
ENRENR-1418462026-08-05T13:45:48ZDEAN····WAYNE12/23/88UHC-74792-22•••-••-7123939.436.6445wayne.dean77@icloud.com5386 CHURCH ST·PlanoTX···75056GRP-6591MEDICARE-ADV-B
ENRENR-1191712026-03-13T01:46:03ZJessica—Walsh1995-02-19UHC-22109-31•••-••-091913145416080NULLnull-nullNULLGRP-3346MEDICARE-ADV-A
ENRENR-1081232026-01-31T01:27:40Zchristian—hdusonApr 4, 1982UHC-25514-58•••-••-5512425.840.2247··christian.hudson93@yahoo.com3963 JEFFERSON AVENUEDenver··CO80255-0239GRP-8344NAVIGATE-HMO
ENRENR-1351872026-09-22T12:32:03ZJaniceBEllis1972-12-12UHC-19036-34•••-••-05329366031janice.ellis15@hotmail.com8206 Sunset BlvdFresnoca93710GRP-7625MEDICARE-ADV-A
ENRENR-1427752026-08-19T13:51:01Z·TIMCSPENCER11-05-1969UHC-29413-04•••-••-8390+1 464 829 3204timothy.spencer@yahoo.com9865 Harbor Blvd··SacramentoCA95815GRP-9851OPTIONS-PPO
ENRENR-1281262026-07-08T13:17:46ZAhmedDPerkins··1948-08-28··UHC-16952-84•••-••-4607479.948.2546ahmed.perkins@proton.me··3105 Main St··GlendaleAZ85324GRP-4971CORE-HMO
ENRENR-1383412026-09-28T13:28:32ZARTHURRLOPEZ2/23/1980UHC-09569-22•••-••-9928+1 239 744 4409null9565 SUNSET BOULEVARDOrlandoFL32888GRP-0740·NAVIGATE-HMO
ENRENR-1322582026-08-20T15:37:40ZBARBARAZJACKSON1999-07-19·UHC-50069-87—+1 872 429 8088barbara.jackson@icloud.com5187 Mountain View DriveSacramentoCA95842GRP-4956CHOICE-PLUS-PPO
ENRENR-1121932026-02-13T00:25:33ZShirley—·McDonnald1949-08-25UHC-84446-46•••-••-2520(296) 670-7470shirley.mcdonald13@hotmail.com3937 CHURCH STREET Apt 26San DiegoCalifornia92164GRP-8387CORE-HMO
ENRENR-1131092026-03-10T21:14:54ZJaniceE··Reid1952-10-16UHC-94482-66•••-••-3384(384) 310-8382JANICE.REID@GMAIL.COM5596 SPRING STNashvilleTN37238GRP-4413CORE-HMO
ENRENR-1154082026-04-20T21:29:34ZCherylCHughes05/15/44UHC-53947-90•••-••-14777924336738CHERYL.HUGHES@PROTON.ME6375 MESA DRIVEATLANTAGA30399GRP-7614CORE-HMO
ENRENR-1352842026-01-16T12:13:47ZEthanM··Rogers9138-12-18UHC-76883-32•••-••-5790(869) 438-9533ethan.rogers8@gmail.com1672 SPRING STREET··San Antonio·TX78251GRP-1367choice-plus-ppo
ENRENR-1393282026-07-05T01:05:45ZdanielleXwagnerAug 23, 1991UHC-66464-67•••-••-1398719-940-0785danielle.wagner@yahoo.com1644 Valley View Dr·GlendaleAZ85399GRP-2397MEDICARE-ADV-B
ENRENR-1112582026-06-18T09:05:36ZRalphLFernandez20-09-1991UHC-99815-83•••-••-48465742953093ralph.fernandez52@hotmail.com8245 Ocean AveFresnoCA93769GRP-4269CORE-HMO
ENRENR-1108512026-05-09T03:57:27ZFRNCES—MTCHELL1947-12-24uhc-79918-41•••-••-18049522635378—3943 Cedar Lane Apt 9DallasTexas·UNKNOWNGRP-9237CORE-HMO
43,101 rows, page 255 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.641Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty