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-1229452026-08-09T20:03:20Z·Larry—Graham1989-07-18UHC-76788-10•••-••-08516874061603··LARRY.GRAHAM@YAHOO.COM···7319 Spring StreetScottsdaleAZ85253-8339GRP-5580··CHOICE-PLUS-PPO
ENRENR-1066692026-04-20T15:45:51Z WILLIAM—ROSS20-03-1984UHC-56163-74•••-••-9181351-775-3659··—9411 HILLCREST RDTampaFL33647GRP-0883·MEDICARE-ADV-A
ENRENR-1401402026-02-26T20:24:01Z KELLYK··MILER10-07-1970uhc-14354-74•••-••-980215884851834KELLY.MILLER@YAHOO.COM··UNKNOWNN/A-N/AGRP-3363NAVIGATE-HMO
ENRENR-1035442026-03-14T07:26:44ZGaryU.Pena1983-06-09UHC3455447•••-••-14548606575105GARY.PENA@OUTLOOK.COM7060 Jefferson Avenue··SAN DIEGOca92173··GRP-7488SELECT-EPO
ENRENR-1318862026-08-04T23:00:26ZTheresaL.Alvarado1985-07-14UHC-14040-52··•••-••-2313(420) 221-7026theresa.alvarado13@aol.com7498 Spring StTempeAZ85295GRP-5679··NAVIGATE-HMO
ENRENR-1073882026-03-17T02:54:25ZJACKMORTIZ··12/15/1957UHC-23081-51•••-••-7576—jack.ortiz97@aol.com8618 Elm StreetMesaAZ—GRP-1451OPTIONS-PPO
ENRENR-1361512026-06-11T17:01:32ZMARCUS—RICHARDSON1993-01-28UHC-45648-36•••-••-98849206572938marcus.richardson18@proton.me2714 BroadwayGlendaleAZ85378GRP-3186CORE-HMO
ENRENR-1223952026-07-11T01:52:33ZJeanL.AndrewsJul 7, 1940UHC-62623-61•••-••-9961·+1 301 632 8058jean.andrews7@outlook.com4756 Jefferson AveMiamiFL33151GRP-7756OPTIONS-PPO
ENRENR-1413882026-03-18T00:52:21Z·KennethSRoss1947-09-04UHC-26589-52•••-••-5530(906) 839-5974KENNETH.ROSS8@PROTON.ME4605 Hillcrest RdPhoenixArizona—GRP-2457CHOICE-PLUS-PPO
ENRENR-1407582026-09-10T00:25:10ZJANICEZMARSHALL···22-02-1985UHC-38497-73•••-••-7159905-866-4819N/A5578 Bayshore DriveSacramentoCA95824·GRP-1207SELECT-EPO
ENRENR-1269892026-08-12T20:51:56ZMeiEOBrien·1973-07-02UHC-86611-30•••-••-6200+1 516 220 8960MEI.OBRIEN38@AOL.COM650 Indian School RdSan AntonioTX78297GRP-0887CHOICE-PLUS-PPO
ENRENR-1306792026-08-15T03:45:48ZAna—Thomas07/19/1983null•••-••-655913284916761ana.thomas51@gmail.com·6256 Apache Boulevard Apt 13TampaFLN/AGRP-4282OPTIONS-PPO
ENRENR-1262862026-10-14T13:46:29Z·DouglasTLuna1990-11-25UHC-38556-96•••-••-9924336.718.3888N/A8652 Willow CourtAtlantaGA30367GRP-9804MEDICARE-ADV-B
ENRENR-1370172026-01-05T09:07:24ZrebeccaCcarpenter1956-10-09UHC-34222-05•••-••-2189(205) 746-3844REBECCA.CARPENTER55@OUTLOOK.COM1983 Elm StreetMiamiFL33146GRP-3437MEDICARE-ADV-A
ENRENR-1072592026-07-29T17:04:01Z·Larry—Kim06/21/88UHC-54455-56•••-••-0546(633) 507-3010LARRY.KIM85@OUTLOOK.COM3283 CHURCH STAtlantaGA30373-9600GRP-8411··CORE-HMO
ENRENR-1230682026-06-24T06:27:44ZShirleySHarper··20011102·UHC-59756-03•••-••-6502807-457-2285SHIRLEY.HARPER16@AOL.COM4986 Union StScottsdaleAZ85220GRP-6886MEDICARE-ADV-A
ENRENR-1027772026-01-31T23:38:18ZMaria—Perkins4/22/1979·UHC-18060-30··960-221-8858maria.perkins33@yahoo.com·5752 Central AveAtlantaGA30396GRP-5428CORE-HMO
ENRENR-1260472026-08-04T21:49:07ZJacquelineH.Edwards06/03/58UHC-33846-54•••-••-1117-null9136 Lincoln WayTampaFL33618GRP-3065MEDICARE-ADV-B
ENRENR-1403172026-05-02T20:49:29ZTERESA—GERZA1971-06-14UHC-37981-33•••-••-59594239666146··TERESA.GARZA@YAHOO.COM5421 LINCOLN WAYAUSTINTX78736GRP-7863OPTIONS-PPO
ENRENR-102182 2026-03-15T22:58:00ZBrianKSyder1969-11-19UHC-67952-09•••-••-8997471.248.7301··brian.snyder13@gmail.com6722 GRAND AVENUECHANDLERAZ85212GRP-7063choice-plus-ppo
ENRENR-1044132026-02-19T15:59:12ZJasonMStone08/12/1950UHC-81347-87•••-••-5771+1 375 395 0948jason.stone16@yahoo.com4937 Maple AvenueMiamiFL33139GRP-9297NAVIGATE-HMO··
ENRENR-1182022026-06-25T09:41:58ZGRACEIRAMOS1991-08-09UHC-74116-69•••-••-5137+1 793 324 5860grace.ramos@aol.com683 Hillcrest Road··CharlotteNC28231GRP-5040CHOICE-PLUS-PPO
ENRENR-1063902026-05-16T15:42:28ZYuki—Nguyen1955-01-22··UHC-27496-70··•••-••-780518686306366YUKI.NGUYEN39@HOTMAIL.COM7942 Maple Ave Apt 23AUSTINtx78721GRP-9428OPTIONS-PPO
ENRENR-1266062026-03-21T23:32:06ZbeverlyI.baker08-08-1997UHC-69779-08····nullbeverly.baker28@proton.me5700 Maple Ave #597ATLANTAga—GRP-5211SELECT-EPO
ENRENR-1326122026-01-08T22:03:24ZLawrence··T.Aguilar1978-05-28UHC-26192-03•••-••-3792651-295-7001LAWRENCE.AGUILAR@GMAIL.COM2892 JEFFERSON AVE Apt 35··Los AngelesCA··90054GRP-5021CHOICE-PLUS-PPO··
ENRENR-1426822026-10-06T05:28:58ZJOELSTEVENS1952-07-16UHC-90246-63•••-••-0686(578) 587-5708joe.stevens@icloud.com6977 APACHE BLVDSEATTLE·WA98174·GRP-4929select-epo
ENRENR-1131002026-01-24T21:15:22ZWalter—Little11/18/83UHC9254452··•••-••-87025614200368walter.little55@outlook.com··5629 Park PlAustinTX78746···GRP-4503OPTIONS-PPO
ENRENR-1281092026-05-27T04:49:38Zjuan—kelly10/24/1945··UHC-12228-04N/A896-376-2803—2386 CENTRAL AVEPhoenixAZ·85057-1243GRP-7143MEDICARE-ADV-A
ENRENR-1008192026-09-30T08:06:10ZDUNN—KENNETH1950-03-15··UHC-30577-22•••-••-74334216669973———UNKNOWN··UNKNOWNGRP-4581MEDICARE-ADV-A
ENRENR-118722 2026-01-04T10:33:27ZOwens, Keith····—1995-10-16UHC-04440-15•••-••-0822-keith.owens57@outlook.com2171 Baseline Rd··Minneapolis··MN55445GRP-2139CHOICE-PLUS-PPO
ENRENR-1242142026-07-20T11:59:02ZOliver, Helen—··26-08-1978UHC-84939-80•••-••-880217446677328-7301 CHURCH ST··ColumbusOH43250-4967GRP-6105··OPTIONS-PPO
ENRENR-1151952026-05-03T09:10:29ZHeatherWHarvey1983-09-01UHC-60272-33•••-••-213816914808544HEATHER.HARVEY60@YAHOO.COM3733 UNION STREET #506SeattleWashington98188-9584··GRP-6314OPTIONS-PPO
ENRENR-1185612026-05-22T15:09:04ZVirginiaMBradley09/02/04UHC-13669-86•••-••-0468370-989-7683virginia.bradley43@hotmail.com1433 HILLCREST RDLos AngelesCA90043GRP-1348··NAVIGATE-HMO
ENRENR-112233 2026-08-17T09:12:25ZSTEPHANIE··BHAMILTON··1963-09-04··UHC-40363-22•••-••-3187(429) 332-9333stephanie.hamilton@icloud.com6214 Baseline Rd··ColumbusOH43244GRP-5747CORE-HMO
ENRENR-1117012026-07-15T12:44:57ZLuis—Cox1960-05-26UHC-34441-71•••-••-0538NULLluis.cox@gmail.com3779 Grand AvenueTampaFL33614GRP-3422CORE-HMO
ENRENR-1050522026-04-07T23:15:38Zaaron—guzman1980-05-22uhc-47230-13•••-••-4561(451) 917-0178aaron.guzman14@gmail.com7203 Lincoln WaySacramentoCA95870·GRP-8821MEDICARE-ADV-B
ENRENR-1348702026-03-25T13:52:57Z dennisYwelch19761106UHC-22288-82•••-••-1038+1 526 327 6850null6453 Meadow LnGilbertAZ85207-4182GRP-6592CORE-HMO
ENRENR-1360662026-05-03T23:38:41Z·LaurenRMurphy1969-08-21UHC-46397-91•••-••-23839237297088LAUREN.MURPHY69@PROTON.ME6265 OCEAN AVENUEMesaAZ85264GRP-3939MEDICARE-ADV-B
ENRENR-1166752026-04-05T16:16:24ZTorres, IsabellaN··—2008-09-07UHC-07446-40•••-••-7272(365) 839-5638isabella.torres@gmail.com7978 Ridge RoadTucsonArizona85785GRP-0521SELECT-EPO
ENRENR-1207542026-02-19T14:54:08ZTyler—Moore1993-06-18UHC-71756-75•••-••-6444(762) 242-7816tyler.moore@icloud.com2614 MARKET STREETSeattleWA···98158GRP-5612OPTIONS-PPO
ENRENR-1272962026-07-21T07:42:08ZDorisQFowlerDec 26, 1957UHC-45462-27•••-••-58336243402078DORIS.FOWLER9@GMAIL.COM9260 Apache BoulevardMinneapolisMN55456-3876GRP-4878OPTIONS-PPO
ENRENR-1052022026-09-19T11:39:33Z·ANNP.STEPHENS1940-06-06UHC8952257•••-••-8370(810) 301-5570ANN.STEPHENS@YAHOO.COM2592 GRAND AVE··AtlantaGA30307GRP-6323SELECT-EPO
ENRENR-1217982026-10-11T00:38:45ZrobertEramirez04/20/95UHC-10947-38•••-••-7942824.424.6056NULL7520 MEADOW LANENashvilleTN37292GRP-6769CORE-HMO
ENRENR-1254932026-01-03T01:18:29ZRANDY—NELSON1980-11-09UHC-28095-97•••-••-1495·632-734-9209·randy.nelson40@icloud.com4414 SAGE COURTChandlerAZ85229GRP-7795··OPTIONS-PPO
ENR ENR-1366802026-02-20T18:11:00ZGeorge—Myers··7/26/1939UHC-18318-35•••-••-8012+1 399 543 8590george.myers@hotmail.com5516 Market StreetSan AntonioTX··78287GRP-4173OPTIONS-PPO
ENRENR-1298122026-07-09T11:30:49ZArmstrong, KimberlyU—1958-04-08—•••-••-5535+1 357 859 3661-1214 Palm DriveTucson··AZ85739GRP-6267SELECT-EPO
ENRENR-1344682026-03-21T08:18:38ZTricia—Phillips1599-06-18·UHC-63412-30•••-••-83568773752043NULL1441 HARBOR BOULEVARDAustinTX78793·GRP-0829OPTIONS-PPO
ENRENR-1215822026-09-15T19:53:59ZKimberlyDRamirez1961-09-17UHC-25631-35•••-••-8013-kimberly.ramirez62@hotmail.com8356 Park PlDallasTX75263GRP-2906core-hmo
ENRENR-1202262026-04-12T10:36:07ZLaurenHBerry1979-05-24UHC-64735-96•••-••-23568947647549LAUREN.BERRY79@GMAIL.COM4422 Camelback RdFresnoCA93724GRP-0526MEDICARE-ADV-B
ENRENR-1264552026-08-29T13:22:15ZMARIAGCARR1975-01-13UHC-29916-28··•••-••-0918437.504.7952MARIA.CARR@AOL.COM9203 CEDAR LANEOrlando·FL32835GRP-8170·CHOICE-PLUS-PPO
43,101 rows, page 271 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.427Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty