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-1076852026-07-27T17:56:16ZJOSEPDUNN2008-05-01UHC-70623-16•••-••-26672188349182JOSE.DUNN72@GMAIL.COM6828 Elm StreetTampaFL33614GRP-1679CHOICE-PLUS-PPO
ENRENR-1301312026-07-31T12:09:17ZLUISPGONZALES1939-08-26UHC-00878-25··(977) 294-1179luis.gonzales98@outlook.com4733 Canyon RoadAtlantaGA30339GRP-7574MEDICARE-ADV-A
ENRENR-1040082026-03-28T15:39:42ZRUTH—BLACK1963-11-09UHC-63053-46•••-••-81332228050783ruth.black86@yahoo.com3100 Washington StreetPlanoTexas-GRP-3089MEDICARE-ADV-B
ENRENR-1369012026-03-13T19:37:39ZStone, Omar——2000-03-03UHC-96683-20•••-••-7013N/A··OMAR.STONE@YAHOO.COM3196 Ocean AveTempeAZ85210-1531GRP-5712MEDICARE-ADV-A
ENRENR-1161442026-03-21T08:08:13ZBrittanyGHamilton1998-02-24UHC5262642•••-••-45925899508349—6143 Lake View Road #728San DiegoCA92135GRP-0811OPTIONS-PPO
ENR ENR-1174802026-04-01T15:19:34ZAmber—Brown19480104UHC-82688-97•••-••-7434+1 773 286 9431N/A5547 Hillcrest RoadTUCSON·AZ85743GRP-3320CHOICE-PLUS-PPO
ENRENR-131130 2026-01-24T03:39:11ZHEATHERMCHAVEZ1947-10-03UHC-48341-50•••-••-290312995580953-698 Apache Blvd·Miami·fl33189-4246GRP-4933SELECT-EPO
ENRENR-142501 2026-06-18T19:40:38Z·JACK····—7/24/1970UHC-08046-24•••-••-2410(816) 744-2788jack.clark@hotmail.com5407 Camelback RoadDenverCO80236GRP-0226CHOICE-PLUS-PPO
ENRENR-1011622026-05-25T01:31:15ZMaary····Payne01/25/48UHC-97356-17•••-••-6526331.800.8869—2881 Apache BoulevardSeattleWA98120GRP-9259OPTIONS-PPO
ENRENR-1255892026-06-15T15:24:19Z arthurRwashington1978-04-20UHC-16202-78•••-••-4770+1 878 807 1825null4585 Mesa DriveSAN ANTONIOTexas78214GRP-8388MEDICARE-ADV-B
ENR ENR-1202922026-10-11T05:22:19ZJANETWEDWARDS07/10/65UHC-30103-66NULL··737.826.3478··JANET.EDWARDS25@HOTMAIL.COM3833 Market StreetSCOTTSDALEAZ85260GRP-5482MEDICARE-ADV-A
ENRENR-1364062026-02-22T18:38:24ZEthanUWatson1981-10-04··UHC-98139-49•••-••-2947491.796.0564NULL1710 Camelback RdMIAMIFL33103GRP-2246OPTIONS-PPO
ENRENR-1037512026-09-19T05:40:25ZMurray, JerryB—1986-02-06UHC-55351-47•••-••-09576213996616jerry.murray85@outlook.com7532 Cedar Ln #796NashvilleTN··37277GRP-1291CHOICE-PLUS-PPO
ENRENR-1243622026-04-30T22:00:53Z KimberlyAMorrison11/19/43UHC-34877-54•••-••-6926445-918-6280-7194 Lincoln WayPLANOTexas75086GRP-0549NAVIGATE-HMO
ENRENR-1423842026-08-24T11:16:10Z Anna—Taylor07/15/1988UHC-89479-07•••-••-02933119953168—6456 Mesa DriveMinneapolisMN55435GRP-1149MEDICARE-ADV-B
ENRENR-1278042026-03-14T10:27:22ZJulie··M.Chapman19390304UHC2100012•••-••-1636882.307.8782julie.chapman58@hotmail.com7752 Sage CourtGilbertAZ85253-1249GRP-3802MEDICARE-ADV-A
ENRENR-1309282026-09-09T07:01:47ZEugeneAMorales1976-03-11UHC-18419-70•••-••-7399+1 555 993 4176eugene.morales31@proton.me7390 Bayshore DrAUSTINTX78766GRP-2408OPTIONS-PPO
ENRENR-1308592026-08-09T19:22:25ZPaul—Lawson1967-01-26·UHC-77158-43•••-••-4028833-807-7978PAUL.LAWSON@YAHOO.COM3409 Elm StreetTEMPE·AZ85233GRP-2251OPTIONS-PPO
ENRENR-1199132026-06-22T18:25:54Z NATALIE—·HENRY1944-08-18UHC-47059-01•••-••-5906—UNKNOWN7338 Jefferson AvenueFRESNOCA93723GRP-9066SELECT-EPO
ENRENR-1060912026-05-31T09:15:35ZscottQ.singh19-06-1941UHC-63799-34•••-••-82004334896845scott.singh@gmail.com2352 Oak Street Apt 18NashvilleTN37205GRP-1765CORE-HMO
ENRENR-1099612026-09-02T17:26:14ZJoeGTurner1997-09-21·UHC-65327-39•••-••-673616117624390JOE.TURNER@ICLOUD.COM5634 Valley View DriveFresnoCA93707GRP-2175SELECT-EPO
ENRENR-1034312026-04-24T01:33:54ZAGNELA··—GEORGE1994-12-24UHC-43479-59•••-••-2336+1 347 461 4153angela.george96@yahoo.com103 Maple AveSeattleWA98155GRP-8366CHOICE-PLUS-PPO
ENRENR-1245632026-06-17T23:52:11ZBradley—Rivera1941-11-01UHC-50599-32•••-••-6070376.311.9928bradley.rivera76@hotmail.com·300 Apache Boulevard·OrlandoFlorida32896GRP-7233OPTIONS-PPO
ENRENR-1002732026-03-22T16:35:54Z KATHY··—PADILLA1999-11-20UHC-26540-52—2575983304NULL7438 Oak StTAMPAFL33652GRP-6203OPTIONS-PPO
ENR ENR-1035272026-04-27T16:15:08ZEMILY—ROBERTS20060627NULL•••-••-82542562969088emily.roberts@hotmail.com·2034 Hillcrest RdPhoenix·AZ·85017GRP-1843MEDICARE-ADV-A
ENRENR-1004892026-10-09T11:31:01ZFRANK—SOTO1946-10-06UHC-00758-40•••-••-720812714251041frank.soto97@icloud.com7844 Palm Dr·SacramentoCA95808GRP-6983SELECT-EPO
ENRENR-1396752026-01-25T17:04:32ZMontgomery, MariaU—08-04-1951UHC-73684-45•••-••-6831617-344-4429—2720 BASELINE ROADPlanoTX75056·GRP-9505SELECT-EPO
ENRENR-1276882026-07-09T10:49:12ZMelissa—Andrews1963-04-04UHC-49025-89•••-••-6402nullmelissa.andrews@yahoo.com516 Sunset BlvdDENVERCO80248GRP-2460MEDICARE-ADV-B
ENRENR-121611 2026-08-01T06:27:16ZPriyaHCstroOct 1, 1941UHC-73873-85•••-••-32808483256271priya.castro@hotmail.com··1086 Oak StSeattle·WA98156GRP-6869CORE-HMO
ENRENR-1027132026-07-02T04:14:55ZIsabellaC—2002-03-04UHC-51969-60•••-••-91885953278160ISABELLA.DOMINGUEZ@YAHOO.COM5677 Sunset Boulevard Apt 38LOS ANGELESCA90082··GRP-0181SELECT-EPO
ENRENR-1019202026-01-29T20:52:21ZMARILYNS.WILLIAMS1961-05-10uhc-31989-57—982-348-9154UNKNOWN5684 BroadwayEden Prairie··MN55395GRP-3212CORE-HMO
ENRENR-1289412026-08-11T16:20:05Zjerry·Nfoster11/25/05UHC-52520-66•••-••-2342+1 766 451 0793jerry.foster@gmail.com4012 Lake View RoadHoustonTX77047GRP-2959NAVIGATE-HMO
ENR ENR-1309982026-08-06T00:29:20ZCHARLESXFORD08/21/1943UHC4910343-899.878.7816null653 Market StreetTampaFL33670GRP-2917CORE-HMO
ENRENR-1360082026-07-18T01:11:26ZCunningham, KevinX.—1985-04-13UHC-16391-20•••-••-9435935-717-6249kevin.cunningham@yahoo.com7364 Highland AvenueFresnoCalifornia93768GRP-9101·MEDICARE-ADV-A
ENRENR-1112032026-02-17T03:46:42ZMoore, Andrew·W—·1945-01-15UHC-75711-01•••-••-33544644337ANDREW.MOORE@YAHOO.COM5526 Camelback RdColumbusOH43215-9081GRP-8583OPTIONS-PPO··
ENRENR-1365032026-01-24T15:23:05ZCAROL··ESTEVENS1947-08-14UHC-99194-43•••-••-758817813958341-5527 HIGHLAND AVEEden PrairieMN55321GRP-5828·CHOICE-PLUS-PPO
ENRENR-1329482026-10-10T06:48:06ZRyan·····Davis07/03/68UHC-16030-43•••-••-4019UNKNOWNryan.davis94@proton.me3316 Hillcrest RoadSacramento··CAnullGRP-8188select-epo
ENRENR-1200572026-07-26T16:18:54ZRandy, Johnston—····1978-02-22UHC-32459-34•••-••-5376(942) 243-3386··randy.johnston63@icloud.com·5415 Pine DriveTEMPE··Arizona85297GRP-6807·SELECT-EPO
ENRENR-1004102026-08-26T14:55:01Z Kelly—HugehsDec 5, 1982UHC-94709-09•••-••-138212303809948-·2624 Park PlaceOrlandoFL32892-6708GRP-2101MEDICARE-ADV-A
ENRENR-1087212026-04-24T02:28:14ZSinghS.Brenda1999-05-10UHC-58435-51•••-••-2751676-242-0877NULL7872 Indian School RoadGlendale·Arizona85389GRP-5839CHOICE-PLUS-PPO
ENRENR-104579 2026-10-05T00:17:56ZBowman, Patricia——2/14/1989UHC8244860··•••-••-80134585137889PATRICIA.BOWMAN@PROTON.ME201 Hillcrest RdColumbusOHUNKNOWNGRP-8046SELECT-EPO
ENRENR-1384562026-02-01T05:40:07ZdonaaldCespinoza1943-12-26UHC-52321-03•••-••-9364+1 861 380 8046··donald.espinoza5@proton.me9490 Union StreetOrlandoFL32806GRP-3305SELECT-EPO
ENR ENR-124710 2026-04-24T18:26:50ZStone, Linda··——19851114UHC-66695-10•••-••-4079·12404287313LINDA.STONE64@HOTMAIL.COM3121 Main StreetScottsdaleAZ85213··GRP-5955CHOICE-PLUS-PPO
ENRENR-1378932026-06-09T08:39:28Z carlPchapman1972-03-02UHC-14869-57•••-••-8272230-335-7304carl.chapman15@proton.me7757 Hillcrest Road··COLUMBUS·OHNULLGRP-2890CORE-HMO
ENRENR-1070112026-05-26T14:15:36ZBarbara—Simmons1966-11-20·UHC-72880-67•••-••-7927(915) 956-1852-3632 Sunset BlvdHoustontx77080GRP-9522·SELECT-EPO
ENRENR-1080652026-06-04T04:41:09ZAlexanderP.McCoy02/21/1942UHC-33082-26N/A606-892-4506—5925 HILLCREST ROADOrlandoFL32833GRP-2774MEDICARE-ADV-A
ENRENR-1171662026-01-24T09:25:24ZRivera, Barbara——4/26/1996UHC6424952•••-••-0956UNKNOWNbarbara.rivera81@gmail.com3211 Main StreetPlanoTX75077GRP-3314MEDICARE-ADV-A
ENRENR-106218 2026-05-15T18:14:46ZamandaErogerrsNov 21, 1965UHC-64231-47··•••-••-27769688486813AMANDA.ROGERS@OUTLOOK.COM-N/A-·NULLGRP-7374OPTIONS-PPO
ENRENR-1216442026-02-14T06:45:19ZLynch, JeanP.—1996-12-23UHC-03327-17•••-••-9325735-864-4371—5840 Spring StSACRAMENTOCA95860-2051GRP-9849OPTIONS-PPO
ENRENR-1223322026-04-13T03:00:28Z·Mark A—Contreras6/5/1994UHC-18319-57•••-••-3761365-335-9957mark.contreras@hotmail.com4270 OCEAN AVE #399PlanoTexas75036GRP-4070·CORE-HMO
43,101 rows, page 81 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:36.715Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty