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-1086502026-03-14T06:50:55ZDunn, Ann——1961-21-10UHC8378592•••-••-80044715513104-··N/ANULL—GRP-5813select-epo
ENRENR-1101822026-07-26T01:35:33ZJANICEBMORENO12/06/1950UHC-99841-47··—2877023847-UNKNOWNN/AUNKNOWN·N/AGRP-1129MEDICARE-ADV-B
ENRENR-1051752026-09-28T22:46:15ZWagner, Tyler——1952-07-18UHC-10977-65•••-••-35036309165474tyler.wagner@icloud.com8381 Main StreetGilbertArizona85270GRP-8485··SELECT-EPO
ENRENR-1305972026-02-22T07:46:47ZSchmidt, Austin——03/26/1965UHC-21559-49•••-••-12383066576057austin.schmidt@proton.me3939 Jefferson AveMinneapolisMN55458GRP-0912·CHOICE-PLUS-PPO
ENRENR-1213192026-03-25T06:15:26ZAustin—Nelson1942-09-21UHC-36547-42•••-••-3557(948) 361-8186austin.nelson@outlook.com9020 Maple Avenue Apt 2SeattleWA98127-4048GRP-5143SELECT-EPO
ENRENR-1072342026-05-15T21:43:24ZMarilynY··Stephens1993-09-08UHC-47491-49•••-••-24073172404249marilyn.stephens26@outlook.com7161 Market Street··ChandlerAZ85267GRP-3754·MEDICARE-ADV-B
ENRENR-105580 2026-06-18T18:30:23Zjoan··robertson-UHC-80182-89•••-••-01099419862—8274 JEFFERSON AVENUELOS ANGELESCA90023-7355GRP-0649MEDICARE-ADV-B
ENRENR-1328452026-03-12T10:39:45Z·Diane·WWells·11/24/1941UHC-04452-60··•••-••-69596145750929diane.wells44@icloud.com754 APACHE BLVD Apt 31San DiegoCA92119GRP-5216SELECT-EPO
ENRENR-1091262026-05-24T17:19:59Z·JEREMY—CARLSON08/01/1989UHC-96041-62•••-••-0682910-726-8586jeremy.carlson@aol.com6448 Church StreetEDEN PRAIRIEMN55377GRP-4633CORE-HMO
ENRENR-1330782026-03-31T15:57:29ZCAROL—PAYNE1945-09-02·UHC-93089-53NULL3997799243null9850 Mountain View DriveSeattleWashington98130GRP-1223CORE-HMO
ENRENR-1363192026-02-03T17:02:22ZDeborahRReed·2008-09-01UHC-53566-25··•••-••-2743362-817-3087deborah.reed@yahoo.com5331 Camelback RdSan DiegoCA92170-6392GRP-3076··MEDICARE-ADV-B
ENRENR-1162332026-01-08T20:20:21ZROBERT·GVALDEZ10/21/2000UHC-32586-14•••-••-9454890-629-5975robert.valdez98@aol.com1002 Elm StreetSeattleWA98111GRP-5958NAVIGATE-HMO
ENRENR-1057572026-01-01T09:09:59ZAUSTIN—LUCAS04/28/73UHC-18883-68•••-••-9375N/AAUSTIN.LUCAS@HOTMAIL.COM9566 Oak StreetMINNEAPOLISMN55454GRP-5118CORE-HMO
ENRENR-1290542026-05-14T23:20:30ZEmily·GFuller1986-02-02UHC-95211-89•••-••-419313443081489emily.fuller54@hotmail.com5531 BASELINE RDTampafl33671GRP-7235SELECT-EPO
ENRENR-1145622026-03-11T07:24:15ZKELLYYMILLER2002-02-21UHC-07876-34•••-••-789619116778377kelly.miller@outlook.com5278 VALLEY VIEW DRHOUSTONtx77003GRP-1549SELECT-EPO
ENRENR-116210 2026-01-21T03:25:40ZBrcueXDelgado1955-02-10UHC-33760-87•••-••-6654770-701-4702bruce.delgado84@hotmail.com6913 WILLOW COURTSEATTLEWA··98169-2707GRP-4414OPTIONS-PPO
ENRENR-1258112026-04-07T08:11:23ZBENJAMINCOLSON1993-08-22UHC-52272-82•••-••-53949066369720null6338 Baseline RdMESAAZ85229GRP-0589CHOICE-PLUS-PPO
ENRENR-1029152026-02-21T17:34:01Zsteven—ruiz19710618UHC-69104-20•••-••-7310—steven.ruiz32@yahoo.com860 BAYSHORE DRTUCSONAZ85734GRP-4800MEDICARE-ADV-B
ENRENR-118938 2026-02-05T13:55:59ZLarry·SSanders1993-08-11UHC-48676-74null··407-406-8481larry.sanders52@gmail.com3110 Main StMesaAZNULLGRP-7460MEDICARE-ADV-A
ENRENR-1055092026-07-09T22:15:39ZJamesB.SalazarMay 16, 1980—•••-••-8533——1556 Baseline RoadAustinTX78730GRP-4390MEDICARE-ADV-B
ENRENR-1275452026-01-05T20:43:42ZWILLIAM—FREEMAN03/22/54UHC-52307-49•••-••-40338858555367N/A765 HIGHLAND AVE Apt 26PlanoTexas75071GRP-7298NAVIGATE-HMO
ENRENR-1291872026-04-07T17:42:16ZFreeman, PaulD—1979-12-01UHC-28021-38•••-••-1078647-918-3060PAUL.FREEMAN@PROTON.ME2670 Sage Ct··Charlotte··NC28238·GRP-5294SELECT-EPO
ENR ENR-1232282026-06-12T18:59:29ZJason··LAustin19861116UHC-01733-48•••-••-4147413-348-4121jason.austin85@proton.me5495 Union St #295SeattleWA98100GRP-1250OPTIONS-PPO
ENRENR-1267212026-03-16T02:45:54Z Mei—Vargas1953-01-11UHC-17211-73•••-••-15537184750034mei.vargas@aol.com8958 Lincoln WayAustinTexas78776-5740·GRP-4251MEDICARE-ADV-A
ENRENR-1277672026-01-03T12:58:24ZLe, Albert·C····2008-12-24UHC-06229-79•••-••-26918388034955albert.le70@aol.com·2260 Maple AvenueMINNEAPOLISMN55403GRP-0260CORE-HMO
ENRENR-1029132026-08-23T19:11:31ZMASONTSCHULTZ4/10/1998UHC-99478-24•••-••-45594795036MASON.SCHULTZ@OUTLOOK.COM9216 River RoadMinneapolisMN55455GRP-1133NAVIGATE-HMO··
ENRENR-1159562026-06-13T03:52:04ZDenise—DayJul 21, 1996UHC-59634-29•••-••-5873757-390-1955denise.day14@hotmail.com——NULL—GRP-7770CORE-HMO
ENRENR-1097392026-07-02T17:28:19ZSOPHIA—BENNETT1992-02-24UHC-18922-15•••-••-8986522-916-2765SOPHIA.BENNETT52@GMAIL.COM2822 Union StreetDallas··Texas75239GRP-0480·choice-plus-ppo
ENRENR-1328052026-05-12T06:07:42Z·Marhta·YDixon2007-02-09UHC-86777-89•••-••-7751486-998-3627martha.dixon36@aol.com4637 CEDAR LN·CharlotteNC28200GRP-5735NAVIGATE-HMO
ENRENR-1244102026-09-28T10:06:00ZRyan··LHernandez19-01-1959UHC-51810-13•••-••-8114(572) 709-4583ryan.hernandez@icloud.com6988 Sage CtCHARLOTTENC28205-8727GRP-3522SELECT-EPO
ENRENR-1085702026-04-09T01:58:02ZKAYLAGROBERTS05/17/77UHC-83331-44•••-••-78895832486009kayla.roberts52@outlook.com7963 Market StSAN DIEGOca92185GRP-2185CORE-HMO
ENRENR-1047452026-04-04T17:31:04ZSalazar, Kyle——1988-04-26UHC-42261-80—16653122516kyle.salazar23@outlook.com·3160 VALLEY VIEW DRPhoenixAZ85072GRP-3582OPTIONS-PPO
ENR ENR-1224532026-08-18T00:02:58ZPAMELABBROWN1967-04-07UHC-92102-20•••-••-7926·534.577.3386pamela.brown@aol.com2433 Park PlaceSacramentoCA95874GRP-6743NAVIGATE-HMO
ENRENR-1046882026-06-18T22:54:04Zjack—kelley1980-07-16UHC-32721-72—(753) 908-5171N/A2535 Baseline RoadSeattleWAUNKNOWNGRP-8071MEDICARE-ADV-A
ENRENR-1066982026-03-24T17:40:15ZRachelFVargas1942-02-13UHC-36679-03•••-••-9482363-971-4505—1445 Palm DriveSan Antonio··TX78297-3248GRP-1357CORE-HMO
ENRENR-1386402026-04-06T16:00:09ZJordan··—Turner1998-06-18UHC-81412-09··•••-••-64723772627720·N/A6866 Ocean AveCharlotteNC28219GRP-8720CORE-HMO
ENRENR-1271152026-01-14T01:15:54ZMary—Chapman11/23/04UHC-61852-53•••-••-21472854630759—1445 FOREST AVENUEDenverCO80298··GRP-3718CHOICE-PLUS-PPO··
ENRENR-1267262026-05-25T08:24:03ZMARGARETYDUNCAN1982-05-05UHC4944878•••-••-8443939-279-6023margaret.duncan@yahoo.com1968 WASHINGTON STREETChandlerAZ85235GRP-2331SELECT-EPO
ENRENR-1156032026-08-26T17:35:18ZDOROTHY—ROBINSON19-01-1945UHC-03800-59•••-••-0447528-398-4440DOROTHY.ROBINSON@AOL.COM8096 Elm StTempeAZ85292GRP-9803MEDICARE-ADV-A
ENRENR-1326852026-04-27T17:33:03ZBradley, MasonO—·1986-07-19UHC-43681-03•••-••-1240529.932.0007mason.bradley34@proton.me2852 APACHE BOULEVARD·MINNEAPOLISMN55414-6890GRP-2219··SELECT-EPO
ENR ENR-1073412026-05-26T05:02:07ZOiviaQ.George1944-01-07UHC-77131-10•••-••-82014505092489olivia.george61@hotmail.comnull—NULL····GRP-5727CORE-HMO
ENRENR-1145192026-03-02T09:22:34ZANAHDELGADO1953-02-25UHC6701512•••-••-620815876338278ANA.DELGADO81@OUTLOOK.COM1797 Oak StreetLas VegasNV89167GRP-9514··CHOICE-PLUS-PPO
ENRENR-1129132026-05-19T16:22:08ZMunoz, SantiagoM—Mar 19, 2005UHC-00179-07•••-••-0002N/Asantiago.munoz@icloud.comN/AnullN/A-GRP-5039MEDICARE-ADV-A··
ENRENR-1280722026-06-22T22:58:05ZMARIA X—DELGADO1996-06-14UHC-95248-22•••-••-7880246-591-3779·N/A9693 Highland AveNashvilleTN37285·GRP-1318SELECT-EPO··
ENRENR-1381072026-03-05T08:48:23Zpatrick—castro1997-09-04UHC-42767-76•••-••-5102(292) 420-5701PATRICK.CASTRO13@ICLOUD.COM6189 Camelback RdSAN ANTONIOTX78259GRP-4044·MEDICARE-ADV-A
ENRENR-1377762026-05-02T00:58:00ZJOHN··—BURKE1941-06-21UHC-97491-16•••-••-8628(382) 417-6089john.burke@hotmail.com7252 Spring StreetMiamiFL33165GRP-0675··SELECT-EPO
ENR ENR-1165942026-02-28T21:18:24ZLarryKNguyenApr 28, 1991UHC4624528•••-••-49584618733055larry.nguyen36@yahoo.com9165 Lake View RoadATLANTAGA30327GRP-7356SELECT-EPO
ENRENR-1409482026-09-23T23:39:51ZJuanYWeaver·07/02/1995UHC-40398-20•••-••-7194957-781-7533juan.weaver18@hotmail.com8845 HIGHLAND AVEGilbertAZ85268GRP-6312CHOICE-PLUS-PPO
ENRENR-1191362026-02-25T17:27:14ZsofiaZanderson··1984-01-21UHC-07135-27•••-••-1307(316) 577-8943SOFIA.ANDERSON66@AOL.COM1902 Lincoln Way·HOUSTONTX77037GRP-7319CORE-HMO
ENRENR-1330312026-01-11T04:12:19ZMontgomery, AishaX.—Aug 14, 1941UHC-04709-66•••-••-9558(296) 376-1893-6702 River RdLAS VEGAS··NV89125GRP-8632MEDICARE-ADV-B
43,101 rows, page 180 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:40.315Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty