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-1130572026-06-20T14:48:14Z KEVINCCOLEMAN1942-10-16UHC7083458•••-••-3739(326) 863-8705kevin.coleman43@aol.com8198 Highland AveLas Vegasnv89100GRP-9859core-hmo
ENRENR-1107232026-10-17T19:47:15ZBarbara—WooodsApr 21, 1954UHC8475521•••-••-6490955.832.4804N/A4966 Grand AveSacramentoCA95834GRP-9377OPTIONS-PPO
ENRENR-113796 2026-08-09T18:11:06ZEvelyn—·West1995-12-24·UHC-84463-14•••-••-69526024952159··EVELYN.WEST@PROTON.ME1337 FOREST AVENUETEMPEAZ85288GRP-5684MEDICARE-ADV-A
ENRENR-1269232026-10-16T17:06:19ZJennyKWatkins1993-04-21UHC2770665•••-••-33773146720042JENNIFER.WATKINS@YAHOO.COM—UNKNOWNNULL—GRP-3525MEDICARE-ADV-B
ENRENR-1429912026-05-09T14:36:16ZMarilynRSpencer2005-10-20UHC-90446-75•••-••-1322—·marilyn.spencer75@outlook.com4124 Lake View RoadDallasTX75207GRP-2440CORE-HMO
ENRENR-1010622026-01-20T02:56:23ZRogerDMasonApr 28, 1964UHC-97852-83•••-••-9912848-939-2124roger.mason@gmail.com5276 River Rd··SacramentoCA95819GRP-3147OPTIONS-PPO
ENRENR-1236712026-06-19T21:22:51ZMADISON·MWALSH1943-07-16·UHC-76889-17•••-••-3932454.863.2450madison.walsh96@icloud.com7496 MESA DROrlandoFL32816GRP-3160SELECT-EPO
ENRENR-1203292026-01-21T17:50:41ZdanielOmyers1991-01-22UHC-26791-70··•••-••-4500(324) 879-2863daniel.myers@proton.me2242 CAMELBACK RDGilbertArizona85258GRP-6750CHOICE-PLUS-PPO
ENRENR-1239472026-06-15T15:19:04ZDianaH·Lopez1990-12-20UHC-00021-65•••-••-6461(676) 663-4845diana.lopez@proton.me7282 SUNSET BLVD·TempeArizona—GRP-7334CORE-HMO
ENRENR-1179602026-01-04T19:26:33ZSara—Franklin1954-09-04UHC-76769-82•••-••-67535679250SARA.FRANKLIN@PROTON.ME3518 Central AvenueLas VegasNV·89141GRP-6375CORE-HMO
ENRENR-1283712026-06-29T20:21:33ZADAM—SOTO03/23/63··UHC-12844-11•••-••-2096498-548-3779—9217 Spring StJACKSONVILLEFL32274GRP-1626CHOICE-PLUS-PPO
ENRENR-1400432026-01-07T07:35:43ZNICOLEWCHNE03/15/49·UHC-87075-85•••-••-5782(931) 687-3774nicole.chen@hotmail.com9865 Forest AvenueJacksonvilleFL32246GRP-7644MEDICARE-ADV-A
ENRENR-1128012026-09-13T03:57:11Z·SCOTTUHOWELL09/04/2004UHC-80139-48··•••-••-0580(222) 943-5045scott.howell@outlook.com1885 MEADOW LANEHoustonTX77071GRP-8571CORE-HMO
ENRENR-1258862026-05-25T21:58:04ZLisaI.Vargas1939-02-28UHC-03351-44•••-••-2277—N/A3295 Meadow LaneAtlantaGA30367GRP-8902MEDICARE-ADV-A
ENRENR-1252342026-10-01T04:48:01ZLISA—GUERRERO02/11/1971UHC-93978-31•••-••-0516(571) 333-6008LISA.GUERRERO@ICLOUD.COM8703 Sunset BlvdPhoenixAZ85067GRP-7903MEDICARE-ADV-A
ENRENR-1062362026-08-06T19:02:41ZRobertzon, Jack——19950717—•••-••-41976525259235jack.robertson@aol.com·5819 PARK PLOrlandoFlorida32865GRP-6788·MEDICARE-ADV-B
ENRENR-1346372026-04-29T11:01:05ZBeverlyK··Reed1947-06-05UHC-18578-72•••-••-39763336957668beverly.reed73@yahoo.com5652 Desert Sky BlvdTampaFL33624GRP-5168NAVIGATE-HMO
ENRENR-1171692026-08-29T23:56:51ZgabrielD.evans1957-11-25UHC-09691-23•••-••-34076278628703·gabriel.evans19@proton.me3036 Apache BoulevardColumbusOH·NULLGRP-3713NAVIGATE-HMO
ENRENR-1044242026-02-12T14:24:58ZKatheriine—Marshall16-08-1944UHC-61716-65•••-••-01665719886069KATHERINE.MARSHALL@HOTMAIL.COM6981 GRAND AVENUEFresnoCAUNKNOWNGRP-2747CORE-HMO
ENRENR-1221242026-05-13T16:11:22Zkathleen··—howard1986-01-21UHC-39187-01•••-••-4315(790) 776-5295KATHLEEN.HOWARD18@HOTMAIL.COM3370 OAK STREETHoustonTX77060GRP-1240NAVIGATE-HMO
ENRENR-1312422026-09-02T14:48:10ZMasonVRios··1979-07-07UHC-58394-45•••-••-7516705-245-7259mason.rios@yahoo.com8660 Central AveHOUSTONTX77095GRP-8954··MEDICARE-ADV-B
ENRENR-1289002026-02-05T09:15:47ZAnthonyLMejia··02/12/64UHC-47990-92•••-••-6633(414) 597-5745anthony.mejia@yahoo.com8792 Camelback RdLas VegasNV89175GRP-2764CHOICE-PLUS-PPO
ENRENR-1422622026-08-18T16:58:23ZAliceNHart1966-02-17UHC5280045•••-••-0417(522) 463-0912ALICE.HART23@ICLOUD.COM·5467 Grand AveOrlandoFL32841GRP-1358OPTIONS-PPO
ENRENR-1091612026-05-24T22:56:14ZJESSERHUDSON21-08-1973UHC8395438null8006928238-7065 LINCOLN WAY Apt 15Los AngelesCA90025GRP-9518OPTIONS-PPO
ENRENR-1244182026-10-11T20:26:44ZNatalie—Alvarado1990-02-08·UHC2966087NULL13433595981null6392 Palm DrSan Antonio·TX78252GRP-7549··SELECT-EPO
ENRENR-1265412026-06-27T07:40:01ZEUGENE—ESTRADA·1981-02-28UHC-68506-19•••-••-7799946-965-8170eugene.estrada82@gmail.com5142 Union StHoustonTX77041GRP-9959CORE-HMO
ENR ENR-1048932026-08-12T02:21:04Zsamantha——4/3/2000UHC-05248-31NULL632-619-6458samantha.hudson62@outlook.com6065 Camelback RoadSacramentoCA95868GRP-9554SELECT-EPO
ENRENR-1230932026-03-31T12:54:15ZARJUN··GHALL2002-03-11UHC-12634-22N/A12567233942—663 Jefferson AvenueMinneapolis·MN55448GRP-9323select-epo
ENRENR-1231452026-03-26T14:05:35Zdenise—peterson20061012UHC-84776-24•••-••-6359399-872-2277UNKNOWN3782 Main StreetSacramentoCA95896GRP-6038CORE-HMO
ENRENR-1246832026-09-27T03:49:36Zjaince—holmes1961-11-07···UHC-79640-77•••-••-9232·+1 324 679 7955NULL8847 Mesa DrTucsonArizona85762GRP-2340MEDICARE-ADV-A
ENRENR-1189742026-09-06T11:26:09ZjaniceKrichards13-06-1938UHC-36443-23•••-••-5421604-331-7216janice.richards@yahoo.com2622 JEFFERSON AVENUECharlotteNC28254GRP-3249CHOICE-PLUS-PPO
ENRENR-1176822026-05-26T03:52:53ZaustinThansonSep 9, 1974UHC9987794•••-••-23766835634UNKNOWN1610 Church StPHOENIX·az85030GRP-2231CORE-HMO
ENRENR-1270342026-06-30T11:19:24ZAshley—Hart··1950-03-20UHC-94030-87•••-••-6774(335) 553-1298ashley.hart12@proton.me··4651 Mesa DrTampaFL··33612GRP-6544MEDICARE-ADV-B
ENRENR-1229252026-02-13T22:44:28ZJerry—Li2006-03-17UHC-05098-54•••-••-937016834992073··-7252 WILLOW CTAustinTX78740GRP-5269SELECT-EPO
ENRENR-1364162026-02-28T10:53:50ZBilly—Romero1992-09-22UHC-51311-12•••-••-9388—·billy.romero@outlook.com6253 Church StMesaAZ85294GRP-8526SELECT-EPO
ENRENR-1284682026-07-17T19:36:52Z·AMANDA—WILLIAMSON1976-12-06UHC-93564-15•••-••-1123538-685-7122N/A6312 Market StFRESNOCA93759··GRP-4207OPTIONS-PPO
ENRENR-1025882026-10-04T18:31:06ZYuki K.—Arnold1960-09-14UHC-33237-47•••-••-3746247.451.6144···yuki.arnold@hotmail.com9645 Sage CtDenverCO··80259GRP-7936NAVIGATE-HMO
ENRENR-1072622026-04-26T07:35:47ZDANIELIMILLS1939-07-06UHC-23666-16null+1 414 413 6559DANIEL.MILLS19@YAHOO.COM9358 PALM DRLos AngelesCA90058GRP-1576choice-plus-ppo
ENRENR-1111122026-01-27T07:44:56ZKATHLEEN—HOLMES19420506UHC-15477-60•••-••-967413638648269—5971 Hillcrest Road··Las VegasNevada89149GRP-1332CORE-HMO
ENRENR-1306912026-01-07T12:25:38ZTERESA····SIMMONS1/11/1949UHC-70791-29··•••-••-1118+1 894 919 0292null2740 Mesa Drive·ColumbusOH43203-5944GRP-9873MEDICARE-ADV-B
ENRENR-1193692026-09-27T14:40:54ZElizabethS.Gutierrez1998-12-24UHC-77937-50•••-••-5757(615) 846-7073—7839 Willow CourtSan AntonioTX··78214GRP-7007CORE-HMO
ENRENR-1147982026-07-18T11:56:11ZKayla—Wheeler1950-02-20UHC-07128-66•••-••-7948N/AUNKNOWN701 Baseline RoadChandleraz85247GRP-7696NAVIGATE-HMO
ENRENR-1098192026-05-15T08:41:36ZDiaz, Alexander——Oct 4, 1989UHC-67481-57··•••-••-0579415-857-0050alexander.diaz39@yahoo.com··5065 Church StScottsdaleAZ85235GRP-5821CHOICE-PLUS-PPO
ENRENR-1115192026-09-22T09:42:25ZBRYANC.WHEELER2000-01-22UHC-07444-96•••-••-72527307510835bryan.wheeler28@yahoo.comN/AN/A··N/A—GRP-8378NAVIGATE-HMO
ENRENR-1161502026-03-24T06:10:22ZBen—Elliott1948-03-08UNKNOWN•••-••-15407184335benjamin.elliott40@aol.com5730 SUNSET BOULEVARDSan AntonioTX78208GRP-7359NAVIGATE-HMO
ENRENR-1195192026-05-02T06:14:56ZOliviaDLong1997-07-15UHC-29266-21•••-••-2785·824.274.2158olivia.long66@gmail.com1779 Jefferson AvenueMiami·FL33125·GRP-1363CHOICE-PLUS-PPO
ENRENR-112640 2026-01-16T04:31:50ZEthanM.··Russell12/22/1951UHC-56931-47•••-••-01575478729413ETHAN.RUSSELL79@HOTMAIL.COM6970 Willow CtLas VegasNV89192GRP-2431MEDICARE-ADV-B
ENRENR-1050432026-01-21T14:42:29ZKEITH—JORDAN1963-03-15UHC9424468•••-••-6911419-736-7580—7093 Apache BlvdNashvilleTN37267GRP-4872NAVIGATE-HMO
ENRENR-1141342026-09-14T14:27:37ZLawrenceP.··Romero1947-12-28UHC-11868-35•••-••-1890+1 397 385 7667lawrence.romero@proton.me4907 Apache Boulevard #703Eden PrairieMinnesota55395GRP-4013NAVIGATE-HMO
ENRENR-1349332026-03-02T05:40:21ZMoreno, JesseP.—1941-07-17UHC-10876-97•••-••-00756730803JESSE.MORENO@GMAIL.COM2244 Harbor BlvdSan Diego··CA··92172GRP-7709·SELECT-EPO
43,101 rows, page 133 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.454Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty