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-1302182026-07-01T11:32:13ZEMILYO.FOXSep 8, 1945UHC-83540-64•••-••-6743·UNKNOWNemily.fox@aol.com121 CHURCH STPhoenixAZ··85059GRP-3639NAVIGATE-HMO
ENRENR-1330462026-09-09T04:38:48ZAmy··—Fisher1975-05-19UHC-32895-69•••-••-7807(239) 825-2548AMY.FISHER@OUTLOOK.COM653 Washington StChandlerAZ·85259GRP-5535CHOICE-PLUS-PPO
ENRENR-1097202026-05-29T20:07:59Zmariana—howell1972-11-18UHC-32155-76•••-••-8352868.444.8970mariana.howell@icloud.com··5535 Meadow Lane Apt 28COLUMBUSOH··43220GRP-4817CORE-HMO
ENRENR-1201072026-01-14T23:55:41ZRebecca——19581112··UHC-46812-67•••-••-8991882-237-1742rebecca.fields@aol.com7931 WASHINGTON STATLANTAGA30312GRP-1020NAVIGATE-HMO··
ENRENR-1271962026-08-07T12:55:35ZHunt, Emma——Feb 17, 1984UHC-70237-17NULL8986135660—3835 Central Ave··MiamiFL33161GRP-6490MEDICARE-ADV-A
ENRENR-1326062026-05-19T23:04:13ZBRENDAKRYAN1976-03-09UHC-87555-07•••-••-2491803-440-5145··BRENDA.RYAN@PROTON.ME4946 Mesa DrivePlano·TX75003GRP-6961·OPTIONS-PPO
ENRENR-1186882026-05-09T11:23:25ZChristina—Hoffman1955-02-05UHC-44501-44•••-••-033613623836863NULL3768 Highland AveTucsonAZ85792GRP-1843MEDICARE-ADV-A
ENRENR-1053492026-02-07T13:47:51ZJEREMY—RICHARDS11-07-1990UHC-44276-58•••-••-9889(541) 255-2374jeremy.richards65@icloud.com9885 Union StreetAtlantaGA30394GRP-6230CHOICE-PLUS-PPO
ENR ENR-1128662026-08-28T03:55:09ZCHRISTINA—PENA1941-07-20UHC-98004-36•••-••-943717193359166christina.pena@proton.me4121 MEADOW LANESAN DIEGOca92127-2280GRP-2159OPTIONS-PPO
ENRENR-1191532026-02-05T16:37:30Z Omar—Le1980-03-23UHC-94958-54•••-••-165012222558840omar.le@hotmail.com··2377 Elm St #704MinneapolisMN55442GRP-5582··MEDICARE-ADV-B
ENRENR-1013662026-07-01T15:29:02ZSTEPHANIEU·HAES2007-10-20UHC-72841-28•••-••-6904+1 311 659 5826stephanie.hayes@outlook.com403 Washington StHoustonTX77013GRP-7416CORE-HMO
ENRENR-1373242026-10-03T21:01:50ZMadison—OBrien1985-04-22UHC-23707-95•••-••-49629607867894·MADISON.OBRIEN@HOTMAIL.COM5260 Union StreetORLANDOFL32857GRP-6821OPTIONS-PPO
ENRENR-118969 2026-10-17T07:46:52ZPHILIPU.RIVERA03-06-1993UHC-89285-29•••-••-9865772-957-4457PHILIP.RIVERA@OUTLOOK.COM9740 Sunset BoulevardCharlotteNC28252GRP-8058SELECT-EPO
ENRENR-1306722026-01-28T07:44:46ZdorisR··welch1975-10-26UHC-03290-26•••-••-7498515-749-0853doris.welch55@proton.me67 ELM STCHARLOTTENC28213GRP-3210SELECT-EPO
ENRENR-1289792026-05-01T14:35:12ZVictoria—Diaz1997-08-20UHC-71375-70•••-••-8330(688) 683-8130victoria.diaz@aol.com3113 Grand AveAustinTX78795GRP-4757CHOICE-PLUS-PPO
ENRENR-1250992026-02-16T21:25:00ZdonaldWreyes1991-06-19UHC-95264-09UNKNOWN+1 456 776 4337DONALD.REYES@GMAIL.COM2262 HIGHLAND AVENUESan AntonioTX78211GRP-1946CHOICE-PLUS-PPO
ENRENR-1376682026-09-09T01:39:24ZOMARRCRUZ··2/18/1940UHC-81755-94•••-••-7640(568) 736-8832omar.cruz33@hotmail.com4576 Jefferson Ave #141PhoenixAZ85002GRP-1892MEDICARE-ADV-B
ENRENR-1281852026-10-06T04:16:33ZBradleyL.Murphy·Oct 25, 1954UHC-68796-96N/A(897) 339-0823bradley.murphy93@proton.me7379 Union StNashvilleTN37228GRP-2004·NAVIGATE-HMO
ENRENR-1356102026-05-09T18:20:39ZKeennethY.··Burton1950-06-10UHC-88371-61—12767546196kenneth.burton@gmail.com8977 Central AvenueFRESNOCA93733GRP-7797CHOICE-PLUS-PPO
ENRENR-1212742026-07-16T08:26:03ZIsabellaO.·ParkerJul 27, 1950UHC-81955-73•••-••-2816(563) 490-6328ISABELLA.PARKER@OUTLOOK.COM3551 Bayshore DrivePhoenixAZ85093GRP-9705CORE-HMO
ENRENR-1395892026-05-05T03:33:06ZCatherine—Riley1999-11-09UHC-20404-24•••-••-8432(523) 903-9881CATHERINE.RILEY99@HOTMAIL.COM7227 CANYON RDMesaAZ85254GRP-5636NAVIGATE-HMO
ENRENR-1368832026-08-30T10:56:49ZJACK—BISHOP··1943-04-02UHC-95340-02•••-••-6158(448) 928-3197jack.bishop@outlook.com411 WASHINGTON STSan AntonioTX78280GRP-6859SELECT-EPO
ENRENR-1165952026-02-03T15:18:47Zjudy··—garza·1960-01-16UHC-43428-27•••-••-7648271-656-9507judy.garza38@hotmail.com··3068 JEFFERSON AVENUE Apt 18ColumbusOH43263GRP-0936CORE-HMO
ENRENR-1253522026-02-22T13:28:33ZWAYNEKCOLLINS1983-12-03UHC-90077-22•••-••-41874425993236WAYNE.COLLINS72@PROTON.ME4627 Camelback RoadPHOENIXAZ85059GRP-6454MEDICARE-ADV-B··
ENRENR-1215662026-06-27T23:15:41ZCHRISTIANS.REID1972-02-24UHC-73377-60•••-••-0573621-412-5299christian.reid@icloud.com1703 BroadwayMiamiFL33157GRP-8740MEDICARE-ADV-B
ENRENR-1214702026-06-02T18:45:10ZMEIVSTEWART2006-05-24uhc-01171-55•••-••-49386733094617—2068 Mountain View DrLas Vegasnv89182GRP-4027MEDICARE-ADV-B
ENRENR-1239432026-06-02T12:15:02ZGRACE—RODRIGUEZAug 20, 1946UHC-14421-97•••-••-2075232-646-5879N/A6215 Lake View RdHoustonTX77026GRP-7504OPTIONS-PPO
ENRENR-1200542026-07-11T04:55:43ZAlexis I—Marquez1989-08-13UHC-99462-36null(350) 420-3997ALEXIS.MARQUEZ71@YAHOO.COM8043 MEADOW LANESacramentoCA95874GRP-2511MEDICARE-ADV-B
ENRENR-1166252026-09-28T01:15:01ZElizabethNChapman1944-12-23UHC-12513-30null8676977543ELIZABETH.CHAPMAN51@OUTLOOK.COM2615 Ridge RoadSan AntonioTX··GRP-4214OPTIONS-PPO
ENRENR-142569 2026-06-21T18:41:18ZKaylaX.Roberts1945-04-24UHC-69967-07•••-••-99346387169774kayla.roberts@gmail.com··7104 MAIN STREETMesaAZ85254GRP-7836NAVIGATE-HMO
ENRENR-1346632026-08-22T15:43:23ZLOGANZRICHARDS10-12-1955UHC-78121-71•••-••-5349472-995-3901LOGAN.RICHARDS24@AOL.COM4433 Indian School RdSAN ANTONIOTX78233GRP-3315OPTIONS-PPO
ENRENR-1418202026-07-24T19:21:07Z Holmes, JamesC—·1983-12-16UHC-85728-59•••-••-59775128477594james.holmes@aol.comnullN/A··UNKNOWNnullGRP-3439CORE-HMO
ENRENR-1140062026-09-28T15:42:54ZBilly—Gardner1/4/1967UHC-71292-65•••-••-52002773621175BILLY.GARDNER82@PROTON.ME30 WILLOW CTOrlandoFL32858GRP-9255SELECT-EPO
ENRENR-1391342026-07-18T08:42:44ZEDWARD—JENSEN···1969-12-27UHC-23832-56•••-••-0728570-716-0853edward.jensen9@gmail.com3215 Indian School RoadOrlandoFL32895GRP-8891CHOICE-PLUS-PPO
ENRENR-1036142026-07-22T03:11:21ZLAURA—HARPER1945-08-11UHC-81629-70•••-••-7682(849) 436-9446LAURA.HARPER@ICLOUD.COM7036 Lake View RdLos AngelesCA90060-3016GRP-6418SELECT-EPO
ENRENR-1035772026-01-19T14:10:56Z Gloria··UCarr1944-11-11UHC-12496-83•••-••-8032966-797-8916—1860 BROADWAYAustinTexas78751··GRP-4013OPTIONS-PPO
ENRENR-1230532026-05-06T15:00:54ZSANTIAGOX.JIIMENEZ04/15/56UHC-32526-93•••-••-5696+1 962 623 4592····6514 CENTRAL AVECHANDLERAZ85260GRP-2553··CHOICE-PLUS-PPO
ENRENR-1243482026-07-23T07:13:33ZRaymond··SScottAug 4, 1957··UHC6811007UNKNOWN(409) 689-2450··raymond.scott72@yahoo.com9683 Forest AveTampaFL33617GRP-7616MEDICARE-ADV-B
ENRENR-1300492026-08-12T19:20:10ZSARA—MORGAN1993-01-19UHC-83917-94•••-••-56854492814899sara.morgan56@gmail.com7008 Union StreetFresnoCalifornia···93720GRP-6516·OPTIONS-PPO
ENRENR-1064622026-07-28T01:34:46Z—K—1998-04-09UHC-66870-46•••-••-37712503266726null7026 RIVER ROADChandlerAZ85251GRP-9876MEDICARE-ADV-A
ENRENR-1268892026-06-18T05:20:36ZGLORIASMUNOZ1939-10-01UHC8761103•••-••-4866228-232-9893NULL3275 Harbor BlvdSCOTTSDALEAZ·85217GRP-2660MEDICARE-ADV-B
ENRENR-1267892026-07-29T14:23:54Z·TAYLORA.JORDANJun 9, 1952UHC-79885-27··•••-••-3579+1 625 870 6852JORDAN.TAYLOR92@AOL.COM7000 Cedar LaneAustinTX78766GRP-1513OPTIONS-PPO
ENRENR-1350332026-08-28T07:50:24ZMATEO—LEE02/24/1944UHC3922272•••-••-1699(757) 434-3951mateo.lee81@hotmail.com·9241 Baseline RoadSeattleWA98157GRP-9758·CORE-HMO
ENRENR-1170142026-08-09T15:40:38ZHAROLD····NGUYENMar 27, 1948UHC-34681-89•••-••-560619408992139harold.nguyen@outlook.com3845 Valley View DriveSEATTLE··WA98189GRP-1967options-ppo··
ENRENR-1331092026-05-31T12:07:01ZCharles—McCoy1959-02-27UHC-34521-24•••-••-1832272-816-6209—7434 Maple AveDenverCO80271GRP-3675··CORE-HMO
ENRENR-1322962026-08-21T06:16:19ZDANIELLE—BERRY4/17/1956UHC-59273-12•••-••-0018+1 973 289 0973danielle.berry@proton.me4271 Canyon RdTEMPEAZ85273GRP-7750CORE-HMO
ENRENR-1282532026-08-21T09:17:27Z DebraBDominguez03/03/1941UHC-37220-11•••-••-8639(792) 344-2128debra.dominguez@gmail.com3819 Lincoln Way #277ScottsdaleArizona85206GRP-4148CHOICE-PLUS-PPO
ENRENR-1216422026-10-01T18:34:03ZSalazar, JudithJ.—19380217UHC-63958-44•••-••-6730·269.951.4154judith.salazar9@gmail.com3981 HARBOR BOULEVARD·Las VegasNV89197GRP-2434OPTIONS-PPO
ENRENR-1367492026-04-03T12:26:14ZSharon—Day1962-01-26UHC-43990-46•••-••-77844488805—4771 Indian School RdCHARLOTTENC··28232GRP-4055NAVIGATE-HMO
ENRENR-1074122026-08-31T15:06:22ZRuthM.Herrera1953-11-13UHC-07124-52•••-••-47603509259639RUTH.HERRERA6@PROTON.ME7181 Central AveTempeAZ85245GRP-1051CORE-HMO
43,101 rows, page 291 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:43.451Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty