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-1380912026-04-11T19:33:12ZISABELLAAWALSH04/16/06UHC-62689-44•••-••-2323(347) 248-3522isabella.walsh22@icloud.com656 CEDAR LANESeattle··WA98178-8183GRP-6966MEDICARE-ADV-B
ENR ENR-1158742026-08-03T07:03:11Z·BrandonUGarza1952-08-04UHC-56641-57—2583068901brandon.garza@yahoo.com358 Central AvenueNASHVILLE···TN37211GRP-9646MEDICARE-ADV-B
ENRENR-1138322026-05-24T05:20:27ZJanetSWood24-01-1942UHC-90445-01•••-••-62794788274782JANET.WOOD@PROTON.ME230 Ocean Avenue #800PhoenixAZ85070GRP-1514NAVIGATE-HMO
ENR ENR-1328122026-02-04T15:24:51ZMARY—SIMPSON1957-08-17UHC-05072-24•••-••-9908(475) 235-4763mary.simpson@icloud.com·9133 River RdJacksonville·FL32221GRP-8485MEDICARE-ADV-B
ENRENR-1091532026-09-26T16:57:05ZGarza, Ethan··——1967-07-06UHC-36481-22•••-••-45697388993155null2460 Lincoln WayTEMPEArizona85206··GRP-6001SELECT-EPO
ENRENR-1115682026-10-09T14:39:05ZJerry—Butler1964-11-15UHC-90087-88•••-••-0544nulljerry.butler@gmail.com467 INDIAN SCHOOL RDMESAAZ85268GRP-4293MEDICARE-ADV-B
ENRENR-119805 2026-05-02T07:41:11Z·CynthiaWSanders··Nov 5, 1982UHC-47513-40•••-••-2604·(909) 617-3880NULL3725 Central AveTempeAZNULL·GRP-4043CORE-HMO
ENRENR-1004522026-04-17T16:23:14ZEDWARDAHOWELL19501213UHC-47701-51•••-••-2521(708) 458-7377NULL4793 Main StreetAtlantaGA30345GRP-4849OPTIONS-PPO
ENRENR-1421992026-02-07T11:58:42ZdorothyJolson19430524UHC-01013-65•••-••-28742707736DOROTHY.OLSON@AOL.COM8210 INDIAN SCHOOL ROADColumbusOH43285GRP-1109NAVIGATE-HMO
ENR ENR-1213902026-06-15T10:36:12ZDylan—Fox1946-04-10UHC-69951-95··•••-••-67602662916dylan.fox8@outlook.com9665 Forest AvenueSeattle·WA98174GRP-5627NAVIGATE-HMO
ENRENR-1378142026-05-06T01:12:36ZRogerLRoss2000-12-27UHC-76258-52•••-••-4832(803) 959-7753ROGER.ROSS@PROTON.MENULL—null—GRP-0648NAVIGATE-HMO
ENRENR-1015572026-08-07T12:47:19ZCarolHGray·1944-12-11·UHC8438626•••-••-533713177934138carol.gray@outlook.com·4136 VALLEY VIEW DRScottsdaleAZ85255GRP-8042MEDICARE-ADV-A··
ENRENR-1345532026-01-29T05:42:44ZMARY·Z.FORD1987-07-04UHC-39754-94•••-••-77082716923898mary.ford62@proton.me278 BroadwayGilbert·AZ85251GRP-4244NAVIGATE-HMO··
ENRENR-1378272026-01-28T17:35:42ZDANIELLE—DIAZ1947-03-24UHC-42957-15•••-••-5590655-721-0908danielle.diaz18@outlook.com2992 Jefferson AvenueMiamiFL33121GRP-2628MEDICARE-ADV-B
ENRENR-1154382026-03-10T06:36:28ZJORDANN.BEVERLY11/16/1940UHC-93897-11•••-••-4235710-314-9946beverly.jordan47@proton.me4835 Sunset BlvdTampaFlorida33639GRP-0820NAVIGATE-HMO
ENRENR-106139 2026-04-02T03:47:00Z·Joseph—Watson1977-05-04UHC-53452-16•••-••-3496nulljoseph.watson@outlook.com1905 Bayshore DrNashvilleTN37236··GRP-5316SELECT-EPO
ENRENR-1013312026-07-20T02:43:17Z KIMBERLY—MEJIA1977-11-19UHC-56315-91•••-••-9568-KIMBERLY.MEJIA73@GMAIL.COM4850 Indian School RdMESAAZ85252GRP-5053SELECT-EPO
ENRENR-1050762026-01-06T13:23:32ZCharlesZMendoza1989-12-26UHC-16827-22•••-••-676818502743377CHARLES.MENDOZA94@AOL.COM4650 HILLCREST RDSacramentoCA95858-8441GRP-2381NAVIGATE-HMO
ENRENR-1080702026-09-16T19:27:21ZSamantha—Crawford1985-10-16UHC-02931-55•••-••-3095793.472.5694·samantha.crawford73@outlook.com-NULL··-UNKNOWNGRP-5416CHOICE-PLUS-PPO
ENRENR-1105222026-01-23T17:10:44ZGaryC··Brown1970-05-01UHC-72488-49•••-••-2037(520) 654-0755gary.brown@yahoo.com5744 GRAND AVESCOTTSDALEAZ85270GRP-8222MEDICARE-ADV-A
ENRENR-1064222026-05-07T08:44:45Z·Ronald—Sims··04/26/1980UHC-83579-90•••-••-2139357.396.3674··RONALD.SIMS56@HOTMAIL.COM6616 Jefferson Ave Apt 24Eden PrairieMN—GRP-4107MEDICARE-ADV-B
ENRENR-1243402026-02-13T07:15:54ZBRUCER.SANCHEZ·1958-03-21UHC-55488-72•••-••-0043724-493-1820BRUCE.SANCHEZ@OUTLOOK.COM2162 HILLCREST ROADSacramentoCA95843·GRP-6271MEDICARE-ADV-A
ENRENR-1364362026-01-03T13:46:16ZCAMILAEPAARKER1957-05-01··UHC-18232-09•••-••-0989657.468.5071NULL4559 Bayshore DrChandlerAZ85209GRP-2875·CHOICE-PLUS-PPO
ENRENR-1265962026-02-01T14:49:50ZMichael—Sanders19901101UHC-59749-51•••-••-2539—MICHAEL.SANDERS@GMAIL.COM8657 Mesa DrScottsdaleAZ85200GRP-6732CORE-HMO
ENRENR-1216302026-06-29T18:08:12ZKeith·N.Green12/18/1955UHC-23627-60•••-••-154418794356930—6691 RIVER ROADJacksonvilleFL32207··GRP-9329CHOICE-PLUS-PPO
ENRENR-1360762026-05-18T09:12:05Z·Kennedy, BarberaL··Feb 21, 1969UHC-10787-91•••-••-89243258561919···barbara.kennedy@outlook.comnullnull——GRP-0984NAVIGATE-HMO
ENRENR-1212162026-02-28T14:17:28ZWILLIEUHANSN1995-03-20UHC5077790•••-••-71593374316747willie.hanson@proton.me8046 Maple AvenueSeattleWANULLGRP-8282NAVIGATE-HMO
ENRENR-1248552026-01-27T07:57:23ZAustinGMorris1975-05-24·UHC-85876-46•••-••-8143459.337.7942austin.morris@aol.com282 RIDGE RDSeattleWA98126GRP-9574SELECT-EPO
ENRENR-1269852026-08-15T21:37:15ZJOSEN.WELLS1968-06-15UHC-83554-72•••-••-7177414.746.5634jose.wells99@gmail.com409 Baseline RoadCHANDLERAZ·85238GRP-3180MEDICARE-ADV-B
ENRENR-1086462026-10-02T00:53:52ZemmaXmeyer6/18/1997UHC-13185-09··•••-••-82282227302295emma.meyer@icloud.com·5206 SUNSET BLVDColumbus··OH·43225GRP-7688CORE-HMO
ENRENR-1240562026-02-12T01:30:03ZJuan—Willis8/4/1990UHC-57655-64•••-••-6995+1 879 479 4589—·9867 Camelback RoadAUSTINTX··78789GRP-1425CHOICE-PLUS-PPO··
ENRENR-1192492026-06-27T04:24:18ZRACHELZPEREZ1996-09-20UHC-86265-57•••-••-5509426-414-3253RACHEL.PEREZ34@PROTON.ME6993 Mountain View DriveCHANDLERAZ85206GRP-6430··MEDICARE-ADV-B
ENRENR-1206772026-07-06T18:34:30Z CarolJ··Rodriguez··1982-02-25UHC2979924•••-••-07902149673595null9154 Elm StCharlotteNC28280-2955GRP-3991MEDICARE-ADV-B··
ENRENR-1369962026-05-26T16:25:41ZNelson, Doris——1950-11-27UHC-87944-22•••-••-9302(713) 321-9059doris.nelson33@outlook.com962 Hillcrest RoadAustinTX78784GRP-8889MEDICARE-ADV-B
ENRENR-1167222026-08-22T18:51:28Z·Price, Marilyn——1975-11-18UHC-60162-30•••-••-3860(420) 218-8431N/A6884 Camelback RoadEden PrairieMN55310GRP-5495CORE-HMO··
ENRENR-1214512026-05-26T02:32:19ZDonna—Young·4/19/1987UHC-12196-74•••-••-219515726362157null4065 MARKET STREETEden PrairieMN55329GRP-7095SELECT-EPO
ENRENR-1370232026-07-21T20:27:10ZBryan—Foster01-12-2001UHC-42145-76•••-••-2391·451-349-6968·BRYAN.FOSTER@HOTMAIL.COM636 Ocean Ave··FRESNOCA93709GRP-6829MEDICARE-ADV-B
ENRENR-1345512026-07-23T02:41:16ZJUSTIN—MUNOZ2007-11-04··UHC-63130-10•••-••-6510-—1759 GRAND AVENUEPlanoTX·75048·GRP-5609SELECT-EPO··
ENRENR-1241462026-08-01T14:01:40ZDorothy—Vega2007-12-16UHC-62516-28•••-••-0323573-503-0053NULL1660 Ridge RdAtlantaGA30306-3168·GRP-1916SELECT-EPO
ENRENR-1247942026-04-20T09:34:44ZWillieTFranklin1940-10-21UHC-53624-98null879-440-6786willie.franklin86@icloud.com8439 Harbor BoulevardDallasTX75242GRP-3911CORE-HMO
ENRENR-1130872026-05-28T07:02:22ZMarqez, Russell··——11-03-1962UHC-20668-29··•••-••-468612913710345russell.marquez61@proton.me2146 MESA DRIVEScottsdaleAZ85285GRP-6898MEDICARE-ADV-A
ENRENR-1251162026-10-14T23:33:40ZLori—Hansen1994-03-26UHC-25477-77—+1 437 820 1783—7679 Bayshore DrChandlerAZ—GRP-4285NAVIGATE-HMO
ENRENR-1101442026-06-05T23:09:30Zjose—duncanApr 17, 1972UHC-33793-74•••-••-1035766-731-8574JOSE.DUNCAN93@HOTMAIL.COM2436 Mesa DriveDallasTX75244GRP-1591MEDICARE-ADV-B
ENRENR-1407662026-09-10T03:15:12ZJeremyCDominguez··1972-02-12··UHC3166879•••-••-9835968-913-5832jeremy.dominguez@icloud.com·8548 Hillcrest RdMESAAZ85287GRP-2855CHOICE-PLUS-PPO
ENRENR-1418182026-04-02T01:34:43ZDianaAMiller09/03/07UHC1319258•••-••-7753·2947654130·diana.miller57@proton.me1299 Maple AveTucsonAZ85736GRP-6001CORE-HMO
ENRENR-1127182026-09-27T23:09:30ZJOSHUABHOFFMAN-UHC-75819-13•••-••-24099417652null4968 Indian School RdAustinTX78725GRP-4035SELECT-EPO
ENRENR-1318112026-10-14T02:59:28ZPerry, LuisG—19460614uhc-22698-52NULL——8902 PARK PLACETucson·AZ85755-5471GRP-5329OPTIONS-PPO
ENRENR-1019572026-07-08T07:59:09ZBrianQHansen12/21/1985UHC-10706-35•••-••-7894(867) 412-5308··brian.hansen@gmail.com2266 RIDGE ROADGlendaleAZ85316··GRP-9141CORE-HMO
ENRENR-1368712026-07-09T18:11:08ZPhilip—Weaver1939-12-04·UHC-30716-57•••-••-8283(558) 255-0081·philip.weaver72@hotmail.com2369 PINE DR··HoustonTX77056-6638GRP-0150CHOICE-PLUS-PPO
ENRENR-1014582026-07-20T05:35:17ZAlexis—Harper04/02/1954UHC-57014-87··•••-••-94579731226alexis.harper90@aol.com1298 Central AvenueSacramentoCA95845GRP-3693OPTIONS-PPO
43,101 rows, page 115 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.755Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty