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-1233562026-01-15T13:27:26ZGarza, TheresaL—1942-10-28UHC-29869-56•••-••-02042471738-877 Cedar LaneATLANTA·GA30319GRP-2195OPTIONS-PPO
ENRENR-126705 2026-01-25T10:24:07ZNicholas—Walker··1962-03-16UHC-31286-65•••-••-6577970-573-1101NICHOLAS.WALKER@AOL.COM·9465 Park PlaceEDEN PRAIRIEMN55341GRP-1001select-epo
ENRENR-1374732026-07-25T16:15:52ZNatalie····Phillips1986-10-11UHC-17373-66•••-••-0339·8554180423natalie.phillips@yahoo.com1429 Cedar LnGilbertAZ85213GRP-4885NAVIGATE-HMO
ENRENR-1382932026-06-07T07:56:46ZShirleyLPrk1988-07-18UHC-00495-82•••-••-1594N/Ashirley.park@outlook.com1805 INDIAN SCHOOL RDSan DiegoCA92113GRP-2757NAVIGATE-HMO
ENRENR-134572 2026-07-17T03:09:21ZFRANCES·A.·RICHARDS2006-02-28UHC-66577-59•••-••-1170+1 239 895 1143UNKNOWN7445 CANYON ROADSan DiegoCA92132GRP-4310SELECT-EPO··
ENRENR-1367712026-10-12T22:34:01ZCruz, Amber—··1943-10-18UHC-42078-47•••-••-1798854-847-7408N/A7339 Oak StreetAustinTX78707GRP-5379CHOICE-PLUS-PPO
ENRENR-1206452026-04-12T01:01:15ZbrandonPmason1940-02-11UHC7291309•••-••-3746229.644.4365BRANDON.MASON@ICLOUD.COM··617 ELM STREETTucson··Arizona85701GRP-7464NAVIGATE-HMO
ENRENR-1194032026-09-29T13:21:36ZJuanELopez1968-10-05UHC-13601-93•••-••-2753(279) 576-3102NULL8639 Highland AveColumbusOH43244GRP-7876MEDICARE-ADV-A
ENRENR-1101012026-09-22T06:37:49ZTerryMWhiteOct 19, 1963UHC0819323•••-••-9669·4752332073terry.white@yahoo.com·3771 Ridge RdCOLUMBUSOH·43239GRP-9740MEDICARE-ADV-A
ENRENR-1313712026-06-21T04:45:37ZVICTORIADSCHMIDT·1993-04-02UHC-78530-25•••-••-2269255-448-2929victoria.schmidt78@outlook.com82 Canyon RdOrlandofl32861GRP-6328OPTIONS-PPO
ENRENR-1300962026-08-23T09:03:59Zdenise—williams19701812UHC-56251-29•••-••-1927·(733) 482-5862—7599 RIDGE ROADSan AntonioTX78294GRP-2008SELECT-EPO
ENRENR-1272032026-01-04T16:25:26ZAnthony··—Marttinez19-08-1979UHC-21138-28•••-••-1818(389) 540-3934anthony.martinez@gmail.com5560 FOREST AVEDenverCO80259··GRP-2389··NAVIGATE-HMO
ENRENR-1248062026-04-15T22:02:36ZWillieCPerez12/6/1982UHC-21123-09-—WILLIE.PEREZ29@HOTMAIL.COM5735 Park PlaceSACRAMENTOCA95810GRP-2077NAVIGATE-HMO
ENRENR-1227912026-05-24T04:14:26ZLAWRENCEZCHAPMAN1975-10-20UHC-16649-11•••-••-698918764001961N/A3172 Ocean AvenueAustinTX78770GRP-1895NAVIGATE-HMO
ENRENR-1094002026-01-10T17:31:01ZGloriaUHunt1949-02-09UHC-17806-37•••-••-7142+1 850 872 1287—3970 HILLCREST ROADGilbertAZ··85238GRP-4890OPTIONS-PPO
ENRENR-1355282026-02-04T22:54:59ZFrances·EVega1981-01-14UHC-40876-79··•••-••-4158(766) 506-0586FRANCES.VEGA@HOTMAIL.COM8278 RIDGE ROADDALLASTexas75257GRP-6271··CORE-HMO
ENRENR-1394202026-03-12T23:51:12ZRUSSELLSGORDON·1956-08-13UHC-16503-25-9378523195RUSSELL.GORDON62@PROTON.ME4073 Apache Blvd·AtlantaGA30319GRP-8100navigate-hmo
ENRENR-1319122026-09-27T12:58:06ZJreryAEdwards5/14/1990UHC-51204-16N/A(833) 818-0022jerry.edwards@aol.com922 Union St #854ATLANTA·ga30387·GRP-6783CHOICE-PLUS-PPO
ENRENR-1061262026-08-08T08:42:49Z·KELLY·LMATTHEWS··1997-08-28UHC-58062-54•••-••-9154—kelly.matthews@hotmail.com2441 Highland AveColumbus··OH43284GRP-6091SELECT-EPO
ENRENR-1245952026-05-29T03:06:14ZElijah—Hill19600419UHC-38561-21•••-••-0431908-377-8969·elijah.hill66@outlook.com4190 Mountain View Dr Apt 31NashvilleTN37278GRP-5479OPTIONS-PPO
ENRENR-1282122026-08-06T15:19:21Zlogan—moreno1945-09-17UHC-03115-61•••-••-551315305361980··logan.moreno@yahoo.com4844 Valley View Dr Apt 21AtlantaGA·30398GRP-1487···CORE-HMO
ENRENR-1181362026-03-06T15:56:59ZJUAND.··BURKE19770709UHC-80383-54•••-••-2384815-917-2608juan.burke95@proton.me1611 BASELINE ROAD··Las VegasNV89103··GRP-2585MEDICARE-ADV-B
ENRENR-1105832026-10-07T14:06:25ZDiana·G.Black1987-07-10UHC-19098-18•••-••-6610+1 534 662 3032DIANA.BLACK@PROTON.ME··1397 Ridge RdTampaFL33657GRP-7439SELECT-EPO
ENRENR-1137102026-10-02T10:21:05ZRobertPAllen01/11/1951UHC-77201-48•••-••-5363(787) 512-7472NULL2090 Ridge RoadSacramentoCalifornia95847-9210GRP-3844··SELECT-EPO
ENRENR-1334312026-05-27T08:22:16ZWallace, Kelly——09/05/01UHC-98623-51•••-••-6359N/Akelly.wallace28@outlook.com·9436 OAK STScottsdaleaz85287GRP-0327CORE-HMO
ENRENR-1401352026-05-15T05:44:03ZBrandon··UBailey2006-07-05UHC-55395-79•••-••-60564265341brandon.bailey@proton.me7446 Market StTempeaz85283GRP-1495CORE-HMO
ENRENR-1056672026-01-08T12:22:35ZJacqueline—Jimenez1951-09-07UHC-16993-83•••-••-8587—JACQUELINE.JIMENEZ36@ICLOUD.COM·7066 HIGHLAND AVENUEOrlandoFL·32875GRP-5339MEDICARE-ADV-A
ENRENR-1316392026-05-07T22:30:42ZMARGARETJ.MARTINEZ1972-10-24UHC-40216-89··•••-••-65349813330574MARGARET.MARTINEZ@HOTMAIL.COM21 MEADOW LNORLANDOFL32856GRP-8916CORE-HMO
ENRENR-1148072026-06-01T16:07:26ZEmilyBBurns1952-07-12UHC-83733-14··•••-••-6711·7449573134emily.burns@outlook.com··2466 GRAND AVENUE Apt 36·ColumbusOH43203GRP-0196CORE-HMO
ENRENR-1244592026-07-01T18:26:42ZDorisGHernandez01/06/57UHC-83598-54UNKNOWN(261) 973-8857—677 Willow CourtTEMPEAZ85281GRP-0882·CORE-HMO
ENRENR-1394722026-02-13T21:08:00ZRaymondRGarciaDec 3, 1965uhc-04669-43—761-745-8550raymond.garcia41@aol.com··7636 Camelback RoadScottsdaleAZ85260GRP-4029MEDICARE-ADV-B
ENRENR-1110572026-09-20T10:22:58ZDENISE—OLSON1951-05-11UHC-65886-44•••-••-4742237-453-3779DENISE.OLSON@OUTLOOK.COM9865 MAPLE AVENUE·PHOENIXAZ85064GRP-9667CORE-HMO
ENRENR-1326542026-07-10T17:41:02ZMarilyn—James1952-06-17UHC0163927•••-••-5413835-406-1542·MARILYN.JAMES44@OUTLOOK.COM1285 Palm DrGlendaleAZ85367-8817GRP-6572CHOICE-PLUS-PPO
ENRENR-1377332026-10-06T09:55:17ZKYLE—DELGADO19970218UHC-21688-31•••-••-2044(667) 774-3819kyle.delgado47@aol.com8719 Maple AvenueColumbusOHUNKNOWNGRP-2236MEDICARE-ADV-A··
ENRENR-1316002026-07-31T04:06:18ZBRIANNROGERS1954-09-25UHC6043385•••-••-5670(961) 996-4041···brian.rogers77@proton.me2114 Maple AvenueGlendaleAZ85367GRP-4688CHOICE-PLUS-PPO
ENRENR-1402782026-02-20T16:48:57ZmasonD.jimenez07/20/1984uhc-12368-64•••-••-8189532-664-9655UNKNOWN5361 Union StGlendaleArizona··85315·GRP-1252MEDICARE-ADV-A
ENRENR-1315322026-08-22T20:34:20ZBeverlyOChavez··04/02/1961UHC9914925•••-••-43244809535522—UNKNOWN-—·null·GRP-5045CORE-HMO
ENRENR-1017542026-06-29T00:50:40ZMariW.··Mendez1940-06-16UHC-87975-31•••-••-8076(762) 978-3398—2907 Cedar Ln··Orlando·FL32848GRP-3160options-ppo
ENRENR-1315712026-07-28T10:45:24ZRivera, DorothyC—19580718UHC3344642•••-••-62122489463431dorothy.rivera@yahoo.com7881 Pine DriveNASHVILLETN37223GRP-0946CHOICE-PLUS-PPO
ENRENR-1315962026-09-12T23:20:45Z ·Bennett, Jose——1960-02-25UHC-02988-17•••-••-0842474-773-6249-2543 Highland AvenueTucsonAZ··85738GRP-8954select-epo
ENRENR-1085192026-04-02T11:47:36ZSteven—Schmidt19950205UHC-49596-79•••-••-0442(739) 726-3855N/A8944 CENTRAL AVENUE·ORLANDOFL32870GRP-7246MEDICARE-ADV-A
ENRENR-112119 2026-08-20T11:07:09ZdylanOreed04-03-1944uhc-37557-53—388-327-9903DYLAN.REED17@AOL.COM1234 Pine DrJacksonvilleFL32257GRP-9213OPTIONS-PPO
ENRENR-1050362026-04-07T16:25:47ZSTEPHENX··ROMERO12-04-2005UHC-91458-30•••-••-53457232201272stephen.romero91@gmail.com2814 Sage CourtSACRAMENTOCA95827-0625GRP-6328OPTIONS-PPO
ENRENR-1428602026-02-26T10:30:53ZSTEPHENBWATKINS1966-10-20UHC-21594-17•••-••-68753607863037stephen.watkins@outlook.com5875 Harbor BlvdGilbertAZ85240GRP-5660NAVIGATE-HMO
ENRENR-1412802026-06-21T16:35:48ZPHILIP—PERRY1989-04-23UHC-35107-86•••-••-57468195845782PHILIP.PERRY64@HOTMAIL.COM·6786 Spring StAustinTexas78708GRP-1834CHOICE-PLUS-PPO
ENRENR-1025792026-03-13T21:00:39Zbanks—sanntiagoJun 22, 1956··UHC-38992-72•••-••-6204839-457-8555UNKNOWN3079 HIGHLAND AVESCOTTSDALEArizona85224GRP-5443NAVIGATE-HMO
ENRENR-1106182026-08-15T06:28:47ZCollins, Camila——1978-05-21NULL•••-••-4381(911) 719-9988camila.collins@yahoo.com248 Ocean AvenueScottsdaleAZ··85236GRP-3957MEDICARE-ADV-A
ENRENR-1403162026-10-08T11:25:39ZAlanBBradley3/4/2008UHC-95978-86NULL—NULL·286 Jefferson AvenueCharlotte··NC28277GRP-8913MEDICARE-ADV-B
ENRENR-1068662026-03-03T07:04:30ZFernandez, Paul········03/22/1989UHC-24250-94—(527) 311-7113paul.fernandez@hotmail.com3114 BroadwaySCOTTSDALEArizona85204GRP-3085CORE-HMO
ENRENR-131028 2026-02-06T13:48:43ZFatima··—Gardner1950-06-01UHC-76102-01-2346900062fatima.gardner48@proton.me7090 Ocean AveGlendaleaz85318GRP-0666CORE-HMO
43,101 rows, page 142 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:38.466Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty