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-1172602026-10-05T00:03:59ZCarter, ChristinaV.—1943-10-03UHC-20494-29•••-••-1506507.630.0680CHRISTINA.CARTER37@GMAIL.COM6427 Pine Drive·SCOTTSDALE·AZ85266GRP-5422NAVIGATE-HMO
ENRENR-1359792026-08-07T05:29:46ZAlbert—Mills13-09-1984UHC-53858-84•••-••-2569961-647-4879albert.mills@yahoo.com7892 Bayshore DrNashvilleTN37245GRP-0682CORE-HMO
ENRENR-1011312026-01-21T13:29:07ZJustin—Perkins1977-04-12UHC-46732-56•••-••-76266838260564UNKNOWN6573 Palm DriveLas VegasNV89197GRP-5154NAVIGATE-HMO
ENRENR-1295602026-10-03T17:34:53ZAndrea—Woods1955-06-21UHC-37440-63•••-••-7172UNKNOWN—7509 DESERT SKY BOULEVARDAustinTX78757GRP-2256·CHOICE-PLUS-PPO
ENRENR-1419132026-01-27T14:59:49ZEDWARDZ.GILBERT1965-06-19UHC-07317-90•••-••-9499397-319-0600edward.gilbert@outlook.com5360 Valley View DrMinneapolisMN55401GRP-1793OPTIONS-PPO
ENRENR-1241472026-05-01T13:32:32ZDorothyWVega16-12-2007UHC-62516-28•••-••-0323·573-503-0053DOROTHY.VEGA80@PROTON.ME1660 Ridge Road #263AtlantaGA30306GRP-1916·SELECT-EPO
ENRENR-1409612026-05-15T09:57:07ZTERRYYWILLIAMS1939-10-17uhc-02175-32•••-••-8328—terry.williams@gmail.com2679 Ocean AvenueGLENDALEAZ85377GRP-8076NAVIGATE-HMO··
ENRENR-1424522026-07-07T12:43:13ZCarlosRWalker1987-12-15UHC-39806-08•••-••-76975453381271UNKNOWN9720 Ocean AveScottsdaleAZ85221GRP-4321CORE-HMO
ENRENR-1241962026-08-08T03:07:05ZRebecca··XFord1939-06-27UHC-16239-13•••-••-2928724-441-2514rebecca.ford@yahoo.com5409 WASHINGTON STREETAustin··TX78705GRP-6611SELECT-EPO
ENR ENR-1168972026-04-20T19:24:33ZJESSE—LOPEZ28-12-1970UHC0535437•••-••-0439(942) 769-7990··jesse.lopez91@yahoo.com5274 Mountain View DrTucsonAZ85737GRP-7954SELECT-EPO
ENR ENR-1273972026-04-23T18:19:34Zemma····soot1957-10-07UHC-80867-23•••-••-57947385433932N/A3951 Park PlCHARLOTTENC28233GRP-6668MEDICARE-ADV-A
ENRENR-1213662026-04-17T02:53:49ZWard, Daniel—····1948-04-16UHC-44682-84•••-••-6812(354) 839-4358UNKNOWN8568 Highland AveAustinTX78731-0739GRP-9817MEDICARE-ADV-B
ENRENR-1203372026-01-12T15:58:17ZTYLERJROJAS·1994-06-27UHC-99681-64•••-••-2875(846) 773-9005tyler.rojas17@outlook.com4070 Main StreetScottsdaleAZ85263··GRP-1544CORE-HMO
ENRENR-1158312026-10-14T00:41:41ZJimenez, SamanthaM—2002-10-04UHC4560904•••-••-5979(948) 429-6920—8491 Indian School RdTempeAZ85296GRP-0398OPTIONS-PPO
ENRENR-1136772026-01-29T23:23:11ZSusan—YoungJun 2, 1995UHC-38795-15•••-••-11906983284700SUSAN.YOUNG@YAHOO.COM8550 Valley View DrCOLUMBUSOhio43295GRP-3352SELECT-EPO
ENRENR-1130172026-07-07T04:35:22ZGREGORYFRILEY09/15/1963UHC-93831-63•••-••-229417447232310gregory.riley41@icloud.com9807 Lincoln WayJACKSONVILLEFL32227GRP-3696MEDICARE-ADV-B
ENRENR-1255162026-03-23T05:43:39ZJulia··Le12/15/1972UHC-13063-97•••-••-5918(278) 940-4205NULL9364 MARKET STREET··TucsonAZ85750GRP-7017SELECT-EPO
ENRENR-1054482026-06-13T21:30:58ZHannah—·Olson1959-07-24UHC-75928-92•••-••-44027356379285UNKNOWN6531 Palm DriveMesa··AZ85262GRP-1301MEDICARE-ADV-B
ENRENR-1094912026-01-13T13:43:03Z BRADELYTCARR03-11-1998UHC-51378-49—367-407-2449bradley.carr@gmail.com2339 Jefferson Avenue Apt 25PhoenixAZ85029GRP-7776CHOICE-PLUS-PPO··
ENRENR-136796 2026-09-27T14:23:48ZCAROLYN—HENRY1941-09-17UHC-10251-23•••-••-3755968.795.7748carolyn.henry12@gmail.com924 River Rd··DallasTX75256GRP-4168SELECT-EPO
ENRENR-1134532026-02-23T21:28:26ZMateoTHarris··1943-12-06UHC-85653-70•••-••-9289780.764.3636mateo.harris51@hotmail.com7925 Lincoln Way··TucsonAZ85782GRP-5510·CORE-HMO
ENRENR-1039102026-03-17T16:46:24ZCarl·XSimmons1942-12-11UHC-88435-70N/A19624244078—6421 APACHE BLVDSan DiegoCA92117··GRP-5812NAVIGATE-HMO
ENRENR-1325002026-08-24T03:24:37ZZachary··—Gibson08/24/2001·UHC-91881-98•••-••-7419496-502-9512zachary.gibson@outlook.com1442 Maple AvenueAUSTINTexas78796-6867GRP-0273CORE-HMO
ENRENR-1078732026-08-10T00:26:21Z ZACHARY—ROMERO1987-08-21UHC-63280-47•••-••-83609163739317—7869 Camelback RdSacramentoCA95833GRP-7269CHOICE-PLUS-PPO
ENRENR-1101662026-07-25T16:47:19ZRachel—Hart2008-09-02UHC-95126-24—(212) 376-1294RACHEL.HART@OUTLOOK.COM3381 Elm StAustinTX78751GRP-6761MEDICARE-ADV-A
ENRENR-1185602026-04-30T01:59:56ZBRANDONF.COLE·1996-09-27UHC-38163-34•••-••-63135809831735brandon.cole@outlook.com·1346 Grand AvenueHoustonTX77072GRP-1502NAVIGATE-HMO
ENRENR-1393162026-03-02T08:46:00ZJAKEBBRYANT2003-10-01UHC-59020-53•••-••-2198—jacob.bryant36@icloud.com-NULLN/AN/AGRP-4818OPTIONS-PPO
ENRENR-1341942026-06-18T03:31:29ZEric—·Vasquez·2008-03-08UHC-84182-39—6142346200null5828 MESA DRIVEJacksonvilleFL32289GRP-6893CORE-HMO
ENRENR-1204092026-04-11T05:31:59ZLisaT.WangJan 10, 1962UHC-01264-90•••-••-5499314-889-5342lisa.wang26@aol.com5726 INDIAN SCHOOL RDScottsdaleAZ85282GRP-0440SELECT-EPO
ENRENR-1259322026-04-29T20:48:32ZALICEA.ALVAREZ1938-10-15UHC-35392-66•••-••-7106(749) 273-7308ALICE.ALVAREZ@AOL.COM··5516 CHURCH ST···TucsonAZ85771GRP-9451NAVIGATE-HMO
ENRENR-1052572026-04-02T05:40:06ZNicholas—Diaz1985-09-18UHC-32019-50•••-••-55238624959236N/A3294 ELM STFresnoCA93742GRP-3700CHOICE-PLUS-PPO
ENRENR-1375662026-09-23T01:59:35ZDIANAB.MILS1972-11-19UHC-74388-14•••-••-68298517641826DIANA.MILLS28@PROTON.ME7835 BroadwayAtlantaGA30342·GRP-3037CHOICE-PLUS-PPO
ENRENR-1218712026-05-21T04:25:50ZJUDITH····SIMPSON1986-04-27UHC-21051-13•••-••-37969284809622judith.simpson68@yahoo.com2933 PINE DRIVETempe·AZ85207GRP-4563·medicare-adv-b
ENRENR-1325792026-09-26T05:48:39ZMei—Alvarado1943-12-01UHC-70588-83•••-••-45198674002494-6950 Elm StFresnoCA93701GRP-1181NAVIGATE-HMO
ENRENR-1332392026-06-22T10:32:08ZJAACQUELINENBNNETT1968-07-17UHC-17971-89•••-••-7221·(724) 239-2930—6998 Ocean AvenueLos AngelesCA90070GRP-7035select-epo
ENRENR-1141792026-05-17T04:04:46ZRodriguez, Russell—····1970-08-16UHC-07390-28•••-••-65156038159420·russell.rodriguez51@hotmail.com128 BroadwayColumbusOH43201GRP-5422SELECT-EPO··
ENRENR-1055872026-08-01T00:20:57ZJordanL.Ross··NULLUHC-47728-62•••-••-8086+1 293 951 8374jordan.ross58@proton.me·8556 MARKET STEden Prairie·MN55365GRP-7843MEDICARE-ADV-A
ENRENR-1214612026-10-03T04:55:38ZHunter, Virginia··Q.—1968-02-24UHC-14526-69•••-••-6337740.283.9156virginia.hunter@yahoo.com3867 BROADWAYTampaFL33638GRP-5656··SELECT-EPO
ENRENR-1055782026-07-22T09:01:29ZDENISE—PATEL02/15/1993UHC-83561-59··•••-••-8809(946) 482-4612··null5609 CAMELBACK ROADTampaFL33635GRP-1225MEDICARE-ADV-B
ENRENR-1340632026-06-19T19:41:45ZPAMELA—MEDINA1945-06-06UHC-50999-12•••-••-07813906878493pamela.medina86@aol.com9511 Sunset BlvdSACRAMENTOCA95850-8402GRP-4686OPTIONS-PPO
ENRENR-1167972026-06-23T19:00:18ZSOPHIAKROBERTSON08/12/1942UHC-82419-72•••-••-07754303460sophia.robertson98@outlook.com5540 HILLCREST ROADAustintx78703GRP-9746MEDICARE-ADV-A
ENRENR-1011572026-08-12T11:38:30ZOmarUMcDonald19570604UHC-70145-28•••-••-86368775407256—3532 RIVER ROADColumbusOH43230GRP-5681CHOICE-PLUS-PPO
ENRENR-1126972026-06-16T09:41:33ZHoffman, WillieP—05-05-1963UHC-26483-10•••-••-2813(382) 938-8058WILLIE.HOFFMAN45@PROTON.ME5145 Mesa Drive #515DenverCO80241··GRP-4150CORE-HMO
ENRENR-1016132026-09-18T01:32:56ZBRENDAQ.··SINGH1981-12-05UHC-46582-51•••-••-2645(856) 619-5540brenda.singh7@icloud.com996 CEDAR LN··MinneapolisMN55449GRP-8809CORE-HMO
ENRENR-1283552026-05-12T02:20:13ZVINCENT N—CAMPBELL02/26/50UHC-73442-08•••-••-6425711-582-7776vincent.campbell7@gmail.com9392 Harbor BoulevardNashvilleTennessee37212GRP-2503SELECT-EPO
ENRENR-1062812026-08-10T21:36:15ZANGELAG.KENNEDY1998-08-04UHC-50851-54•••-••-8486(256) 550-7688angela.kennedy97@icloud.com890 Forest AveDallasTexas75239GRP-3934CHOICE-PLUS-PPO
ENRENR-1140442026-03-26T19:12:58ZSARAH—BOWMAN1983-04-27UHC-65972-52•••-••-3711343-667-9817SARAH.BOWMAN89@GMAIL.COM3180 Apache BlvdLos AngelesCalifornia90041-0833GRP-7556MEDICARE-ADV-A
ENRENR-1015802026-01-16T19:59:40ZAnnS··Lopez1940-11-23UHC-75662-02•••-••-7435(860) 959-6207ann.lopez@outlook.com·61 Sunset BoulevardPlanoTX75061-8792GRP-9447NAVIGATE-HMO
ENRENR-1133832026-10-07T22:41:16ZBobby—·RobertsonAug 20, 1965UHC-81310-51•••-••-0938(564) 377-1828-8300 River RoadMesaAZ85293GRP-1016·OPTIONS-PPO
ENRENR-1062352026-03-02T16:34:21ZEdwardBBowman1984-12-22UHC-20406-75•••-••-1310-edward.bowman@aol.com402 Oak StreetFRESNOCA93769GRP-2489CHOICE-PLUS-PPO
43,101 rows, page 329 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.624Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty