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-1318492026-02-10T19:06:50ZHELEN····FERNANDEZ1942-06-16UHC-17523-60•••-••-7828(918) 896-4154HELEN.FERNANDEZ57@GMAIL.COM5023 Grand AveATLANTAGA30344GRP-8865CORE-HMO
ENRENR-1409742026-05-22T08:46:08Z·AlanJLarson··11-01-1981UHC-15650-15NULL971-663-0158alan.larson42@gmail.com5025 BroadwayDenverCO··80213GRP-1618CHOICE-PLUS-PPO
ENRENR-1088052026-04-23T05:10:56Zjulia—webbApr 26, 1990·UHC-13256-28•••-••-9919565-327-4313JULIA.WEBB8@AOL.COM·5812 Oak StreetFRESNO·CA93767GRP-1120SELECT-EPO
ENRENR-1303192026-08-05T01:30:38ZBRANDON···BLONG1963-11-17UHC-49927-34-700-923-0695BRANDON.LONG@ICLOUD.COM6600 Ocean AvenueTAMPA·FL33649GRP-4692NAVIGATE-HMO
ENRENR-1183422026-03-21T22:29:56ZWatson, TomW.—1971-00-95uhc-88577-54•••-••-42792457307thomas.watson74@aol.com7825 Lincoln WayPhoenixAZ85072GRP-5710CHOICE-PLUS-PPO
ENR ENR-1426162026-08-25T23:09:42ZDebraZStone1962-03-19UHC-48866-06•••-••-458615814209653N/A57 Mesa DrEden PrairieMN55335GRP-3380MEDICARE-ADV-B
ENRENR-1233502026-08-25T21:31:29ZAbigail—Harris1956-03-04UHC-15281-60•••-••-3417917.966.3308ABIGAIL.HARRIS@AOL.COM5186 Washington StTucsonAZ85723GRP-0576SELECT-EPO
ENRENR-1191882026-01-02T21:54:34ZTylerQ.LawsonApr 24, 1985UHC-01679-18•••-••-19585897583351tyler.lawson@yahoo.com8511 Lake View RdTEMPE··az85213GRP-0637MEDICARE-ADV-B
ENRENR-1429102026-01-17T03:18:08ZDOUGLAS··—BERRY10/11/69UHC-83888-39··•••-••-5545+1 886 328 4662NULL1607 Lake View RdJACKSONVILLEFL32270GRP-4165MEDICARE-ADV-A
ENRENR-1351732026-06-29T04:18:42ZWalter—SnyderJun 11, 2007UHC-79725-32•••-••-6667(736) 824-8197walter.snyder@gmail.com·218 PINE DRIVETempeAZ85202GRP-0984CHOICE-PLUS-PPO
ENRENR-1362022026-07-08T06:34:07ZGary··Jorrdan·2005-01-08UHC-93960-98•••-••-7988(795) 446-6673gary.jordan6@outlook.com5448 PALM DRHoustonTX77090GRP-9233CORE-HMO
ENRENR-1136102026-09-09T02:25:59ZRebecca—Harris1995-09-15UHC-64318-81•••-••-7725405-712-2716N/A7103 Market StreetATLANTAGA30388GRP-6551MEDICARE-ADV-B
ENRENR-1422732026-06-05T05:51:31ZGrant, Wei——1961-20-09UHC-03343-57•••-••-2013795.582.8203N/A·9605 Highland AveSeattleWA98161··GRP-4544SELECT-EPO
ENRENR-1325302026-07-21T02:05:32ZGERALD—CARROLL1969-08-11UHC-87192-04•••-••-895512765170952····7456 Ridge Rd #312SACRAMENTOCA95891GRP-7066OPTIONS-PPO
ENRENR-123538 2026-08-02T23:55:29ZMarkIArnold10/25/1983UHC-55501-27—744-656-3855MARK.ARNOLD29@OUTLOOK.COM8580 River RdGilbertAZ85227GRP-7768MEDICARE-ADV-B··
ENRENR-1134092026-03-01T07:57:14ZRuthRRyen1998-03-04UNKNOWN•••-••-0056570.831.7067ruth.ryan@yahoo.com2471 Willow CourtGilbertAZ85257GRP-7574NAVIGATE-HMO
ENRENR-1021402026-09-12T04:46:40ZJoan—Gilbert1953-12-03UHC-31278-89•••-••-10865588143784joan.gilbert@outlook.com6465 Willow CourtGlendaleAZ85319GRP-4455NAVIGATE-HMO
ENRENR-1245402026-04-15T02:52:04ZOmar····Morales1965-06-15UHC-01149-88•••-••-9044·5311364omar.morales@aol.com2612 Meadow LaneHoustonTX77071GRP-9955MEDICARE-ADV-A
ENRENR-1368652026-05-24T13:15:43ZShirley—Ellis··1975-01-21UHC-40576-59•••-••-3121284-631-5516shirley.ellis@aol.com7905 Church StreetPhoenixAZ85068GRP-3566SELECT-EPO
ENR ENR-1190812026-03-10T00:54:08ZAISHA—WRIGHT1949-02-26UHC-95172-81•••-••-4999+1 273 698 4308AISHA.WRIGHT84@HOTMAIL.COM3424 Spring StreetPlanoTX··75044GRP-7238MEDICARE-ADV-A
ENRENR-1359302026-09-28T22:43:21Z ·Russell—Holmes·12/03/1981UHC-96335-85•••-••-320419803564027·russell.holmes@aol.com8880 MEADOW LANEATLANTAGA·30317GRP-5087medicare-adv-a
ENRENR-1202502026-10-18T16:03:18ZJOSHUA—BISHOP16-01-1944UHC-15066-21—(793) 405-8502null9490 Desert Sky BlvdCHANDLERAZ85202··GRP-3653NAVIGATE-HMO
ENR ENR-1197062026-03-11T07:48:19ZBrendaY.·Reed1974-02-24UHC-39078-46•••-••-3050248-414-2651brenda.reed95@proton.me3928 HILLCREST RDEden PrairieMN·N/AGRP-9981CHOICE-PLUS-PPO
ENRENR-1063742026-04-21T12:26:18ZLINDA—PADILLA02/20/47UHC-69153-86•••-••-9075—linda.padilla@gmail.com7195 Cedar Lane Apt 10GilbertAZ85269GRP-7474OPTIONS-PPO
ENRENR-1361372026-09-05T19:28:19ZJeesse·AHart1963-08-19UHC-19507-27•••-••-17748823996834JESSE.HART@AOL.COM9617 Ocean AveAtlantaGA30391GRP-7741SELECT-EPO
ENRENR-1263562026-02-14T08:03:57ZButler, ChristinaS—13-03-1945UHC-65441-35•••-••-7895359-257-6327christina.butler46@proton.me5040 Lincoln WayTampaFL33644GRP-1735MEDICARE-ADV-B··
ENRENR-1417712026-06-30T20:28:46ZBruceS—1979-07-16UHC-57855-96•••-••-7435NULLBRUCE.JOHNSON@PROTON.ME1021 MEADOW LANEPlanoTX75019GRP-1942CORE-HMO
ENRENR-1011702026-01-17T16:07:13ZSOFYA—BANKS2007-10-13UHC-41894-24—8384869026—4043 Main StHoustonTX77071GRP-9570NAVIGATE-HMO
ENRENR-1392172026-03-14T12:50:09ZKyleMContreras1962-06-10UHC-17396-44•••-••-251015368965463UNKNOWN7575 CANYON ROAD #830DenverCO··80251GRP-5453SELECT-EPO
ENRENR-113111 2026-06-04T02:19:58ZRandy—Aguilar···19470125UHC-67444-11•••-••-9073(405) 681-6139—6009 Elm StTucsonAZnullGRP-2177CHOICE-PLUS-PPO
ENRENR-1110252026-07-16T16:10:26ZMATEOIEDWARDS1958-09-14UHC-77692-77•••-••-32842107032080mateo.edwards71@yahoo.com746 Maple Avenue #682NashvilleTN37291GRP-3405CORE-HMO
ENRENR-1011442026-03-16T21:56:36ZZacharyTGeorge7/23/1999UHC-99695-66•••-••-5676938.999.9112ZACHARY.GEORGE@AOL.COM4326 SAGE COURTAustin··TX78784GRP-1841CORE-HMO··
ENRENR-1045302026-10-14T07:46:25ZMARTHAGDAY··1986-10-03UHC-91422-70•••-••-2690+1 686 806 3049martha.day@icloud.com4026 Mesa DriveNashvilleTN37215···GRP-0153CHOICE-PLUS-PPO
ENRENR-1095022026-01-31T12:41:55ZDanielsCGregory19691006UHC-35145-84•••-••-2197·423-804-8898gregory.daniels69@outlook.com3460 Ridge RdMesaAZN/AGRP-5529CORE-HMO··
ENRENR-141716 2026-10-11T02:39:33ZWei—Robinson1983-12-14UHC-07395-64•••-••-2809·289.560.4585wei.robinson@proton.me3560 Mountain View DrMesaAZ85242GRP-8711SELECT-EPO
ENRENR-1265652026-08-24T18:06:33ZMaria—Gonzales05-05-1966UHC-94421-13N/A981-590-2792MARIA.GONZALES72@OUTLOOK.COM8457 CEDAR LNTEMPEAZ85287-4293GRP-5290NAVIGATE-HMO
ENRENR-1327322026-04-25T23:11:17ZMARTHAUGORDON11/07/78UHC2647939•••-••-8813+1 686 422 8548MARTHA.GORDON@ICLOUD.COM6440 LINCOLN WAYDallasTexasnull··GRP-7242MEDICARE-ADV-A
ENRENR-1195102026-02-19T20:51:55ZRachelBWells··1974-05-08UHC-21071-49•••-••-4201620-489-9009—4991 MARKET STMinneapolisMN55485GRP-9549OPTIONS-PPO
ENRENR-1330902026-06-04T12:54:02Zsantiago—baker1991-02-27UHC-82806-01··•••-••-85138619839SANTIAGO.BAKER87@ICLOUD.COM3643 Park Pl··Los AngelesCA90027GRP-5960OPTIONS-PPO
ENRENR-1421782026-05-18T14:49:00ZEthanFReyse··19391213uhc-75336-04•••-••-0125(338) 641-0619—5303 BroadwaySeattleWA··98135GRP-7074NAVIGATE-HMO
ENRENR-1230462026-10-14T07:18:59ZMendez, DanielQ····11/04/58UHC-21332-78N/A—DANIEL.MENDEZ@AOL.COM1144 Main StColumbusOH43225GRP-5926··CORE-HMO
ENRENR-1215592026-10-07T02:10:35ZTyler—Bryant1947-01-04UHC-47734-38•••-••-72239184828298··TYLER.BRYANT25@OUTLOOK.COM4557 Union StreetChandlerAZ85260GRP-8749MEDICARE-ADV-A
ENRENR-1250552026-03-20T17:14:14ZMARIA—CASTILLO19520426UHC-23081-93•••-••-17542489942114maria.castillo@gmail.com9239 Elm StreetEden PrairieMN—GRP-3397NAVIGATE-HMO
ENRENR-1365492026-05-22T09:16:57ZMason—Lawrence08/12/1946UHC-62902-14··•••-••-5180(602) 721-0466-5884 RIDGE ROADFresnoCA93710GRP-2615CORE-HMO
ENRENR-1425752026-05-08T14:58:08Z TERESA··AROBERTS1955-11-12UHC-75432-74•••-••-6180+1 503 284 7223teresa.roberts@icloud.com7920 Main StreetGlendaleAZ85321GRP-2391OPTIONS-PPO
ENRENR-1293142026-01-21T09:26:56ZArnold, PaulU—11-11-2008UHC-58490-28•••-••-9323366-471-9205paul.arnold@yahoo.com·4396 JEFFERSON AVEMiamiFlorida33145GRP-1763navigate-hmo
ENRENR-1023302026-05-13T15:49:56ZFrances—Jimenez04/07/75UHC-14586-77•••-••-016012474950765FRANCES.JIMENEZ@ICLOUD.COM1433 MOUNTAIN VIEW DRIVEJacksonville··FLNULLGRP-8242MEDICARE-ADV-B
ENRENR-1276222026-03-01T20:54:41ZsantiagoE.patterson1978-05-19UHC9802922•••-••-130217479540450santiago.patterson14@proton.me6551 Mesa Dr·CharlotteNC28248GRP-0106CORE-HMO
ENRENR-111728 2026-04-04T01:47:42ZRobertVElliott1943-12-15UHC-76201-35•••-••-1298685-637-3354robert.elliott47@aol.com6465 BroadwayPhoenixAZ85093GRP-4844·OPTIONS-PPO
ENRENR-1311352026-03-14T05:46:14ZALEXISUEDWARDS·05/11/03UHC-06470-32•••-••-9814430-584-0820··alexis.edwards32@yahoo.com2299 Cedar LaneAtlanta···GA30320-3533GRP-7672OPTIONS-PPO
43,101 rows, page 50 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.682Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty