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-1206892026-02-23T02:54:24ZAisha—·Patel1941-10-21UHC-23687-29··•••-••-4400724-474-0312aisha.patel@gmail.com465 Lincoln WayHOUSTONTexas77003-7684GRP-9174CHOICE-PLUS-PPO
ENRENR-1029232026-10-09T04:33:20Z·ALANYGOMEZ1970-09-14UHC-96329-04•••-••-3272(499) 675-0420ALAN.GOMEZ62@PROTON.ME4112 Central AvenuePlanoTXN/AGRP-8928CORE-HMO
ENRENR-1235502026-06-04T04:12:11ZGeorge—Silva19720906UHC-43784-68•••-••-8286480.725.2921george.silva@proton.me9064 CAMELBACK ROADGlendaleAZNULLGRP-4915SELECT-EPO
ENRENR-1414532026-02-21T07:39:43ZJUANC.OBRIEN20080720UHC-63527-62··•••-••-0319428-804-5490juan.obrien9@yahoo.com1923 ELM STLos AngelesCA··90045GRP-9866NAVIGATE-HMO
ENRENR-1393052026-03-02T20:09:28ZJulie—Romero19920627UHC-29496-76•••-••-043714677273235julie.romero@yahoo.com5486 Central AveNashvilleTN37292GRP-0880CORE-HMO
ENRENR-1085182026-10-01T18:12:22ZJOHN—PRICE·19380623UHC-15883-40•••-••-9805675.731.6404john.price@proton.me8990 Canyon RdTUCSONAZ85781GRP-5694SELECT-EPO
ENRENR-1410472026-02-20T07:04:14ZIsabellaX.Ruiz1945-09-15UHC0648620•••-••-30912672326358ISABELLA.RUIZ4@OUTLOOK.COM417 Highland AveOrlandoFL32885GRP-1331SELECT-EPO
ENRENR-1140762026-10-03T19:08:41ZJOSE··OWEBER04/10/1957··UHC-75597-59•••-••-0789+1 650 885 8215jose.weber40@proton.me1799 SAGE COURTTempeAZ85281GRP-6525MEDICARE-ADV-A
ENRENR-1379152026-03-20T14:11:45ZHEATHERF·WILLIAMS05/03/96UHC-30599-26•••-••-75872039086858UNKNOWN3186 Canyon RoadGLENDALEAZ85335GRP-2072OPTIONS-PPO
ENRENR-1197532026-06-14T05:34:44Zlinda—porter1964-02-27··UHC1942130•••-••-9862+1 908 396 4665linda.porter69@gmail.com3017 Valley View DrDallasTX75281··GRP-0391MEDICARE-ADV-B
ENRENR-1325062026-03-05T14:19:40ZdouglasT.matthews4/22/1960UHC-06643-85•••-••-63275988718954NULL5409 Canyon RdLos AngelesCA90039GRP-0116CORE-HMO
ENRENR-1055772026-07-03T23:46:56ZJuhn—·Sullivan·1975-02-24UHC-14129-58•••-••-9749·8767559510john.sullivan39@proton.me7173 Desert Sky BoulevardDenver·CO80247GRP-3252MEDICARE-ADV-B
ENRENR-1086452026-04-20T00:32:02ZEmmaX·Meyer1997-06-18··UHC-13185-09•••-••-8228nullemma.meyer@icloud.com4208 PALM DRIVE #288Eden Prairiemn55334GRP-7688CORE-HMO
ENRENR-1017192026-09-29T08:52:40ZRaymondUFoster06/17/73UHC-62692-55•••-••-03262869869404··raymond.foster39@proton.me9571 Sunset BoulevardJACKSONVILLEFL—GRP-2308NAVIGATE-HMO
ENRENR-1337352026-08-29T18:09:00Zjordan—williamson2007-06-02UHC-39394-42•••-••-9350530-796-8577—8677 UNION ST··Eden PrairieMN55320GRP-8808OPTIONS-PPO
ENRENR-128865 2026-02-15T07:45:03ZBishop, Gregory——08/05/62UHC-04258-57•••-••-0882984-459-1436gregory.bishop58@outlook.com8093 Canyon RdAtlantaGA30366GRP-7293CHOICE-PLUS-PPO
ENRENR-1248952026-08-20T21:18:08ZAustinK.Bryat··09/14/70UHC-53540-32•••-••-0591+1 943 414 2190austin.bryant@outlook.com7242 CAMELBACK RDEDEN PRAIRIE·MN55312GRP-7894CORE-HMO
ENRENR-1296732026-01-09T07:30:39Zrussell—barnes08/21/83uhc-92581-69•••-••-3677(824) 818-5713RUSSELL.BARNES@AOL.COM4979 Hillcrest RdNASHVILLETN37226GRP-2340medicare-adv-a
ENRENR-1343172026-02-17T03:15:51ZROYQWILSON·19880624UHC4755311null(396) 832-6745—8944 Hillcrest RoadLos AngelesCalifornia90008GRP-5638MEDICARE-ADV-B··
ENRENR-1360142026-03-28T09:01:59ZTimothyY.Robinson1973-01-91UHC-66634-55•••-••-7554(699) 481-5971·null9153 BROADWAYFresnoCA93769GRP-5392MEDICARE-ADV-A
ENRENR-1202032026-02-10T14:06:42Zmargaret—burke1993-12-13UHC1455590•••-••-2265(860) 846-4900margaret.burke56@icloud.com2687 Canyon RdNashvilletn37222GRP-5523NAVIGATE-HMO
ENRENR-1326092026-10-15T06:28:18ZWood, DouglasU—Mar 5, 1993uhc-08504-80•••-••-6543671.712.2378null519 Sunset BlvdColumbusOH43223··GRP-7423OPTIONS-PPO
ENRENR-1222342026-09-05T21:18:52ZEmmaM.Tucker1964-05-09UHC7080355—(812) 677-0647emma.tucker64@outlook.com8985 Hillcrest RoadFresnoCalifornia93774GRP-7560CHOICE-PLUS-PPO··
ENRENR-1037592026-02-25T06:55:31ZKathyA.Duncan15980619null•••-••-3120—KATHERINE.DUNCAN@AOL.COM5680 Maple AvenueNashvilleTN37295·GRP-7151CORE-HMO
ENRENR-1428862026-04-13T09:53:46Z TERESAA.HOWEL1959-10-07UHC-92058-49•••-••-2036+1 550 215 9435·teresa.howell18@hotmail.com6315 Oak StAustinTexas78713-5753GRP-6736MEDICARE-ADV-A
ENRENR-1021592026-08-17T03:37:01ZOliviaFCarter1951-01-84UHC-78576-01•••-••-1418+1 674 932 8978OLIVIA.CARTER@YAHOO.COM7159 Desert Sky BoulevardSan AntonioTX78229-4233··GRP-2569CHOICE-PLUS-PPO
ENRENR-1415932026-08-14T14:51:57ZMARTHA—RILEY05/20/1972UHC5044112•••-••-1342982-690-1636martha.riley43@yahoo.com3498 UNION STLOS ANGELESCA···90040GRP-9965·OPTIONS-PPO
ENRENR-1317282026-06-14T20:07:38Z ARJUN—ORTEGA1972-08-08UHC-10012-52··NULL-arjun.ortega71@hotmail.com1534 APACHE BLVDChandler·AZ85223GRP-4570CORE-HMO
ENRENR-1313862026-02-15T12:09:39Z WillieG.Schmidt04/01/01UHC4836752•••-••-2268(668) 629-2085null7045 DESERT SKY BOULEVARDJacksonville·FL32210GRP-4507CORE-HMO
ENRENR-118320 2026-01-18T13:41:51ZSTEVENL·MASON1946-10-25UHC-70500-23•••-••-5668(254) 691-8588null586 Hillcrest RdGILBERTaz85203GRP-7826navigate-hmo
ENRENR-1074852026-02-16T06:43:10ZWayneUAdams1979-12-08UHC-83668-70•••-••-358112514718921wayne.adams@gmail.com4850 BROADWAYEden PrairieMN55342GRP-2095NAVIGATE-HMO··
ENRENR-1265222026-04-05T06:58:07Z GloriaB.Weaver20071201UHC-97013-09•••-••-6204+1 372 901 3817gloria.weaver4@icloud.com3149 Central AvenueChandlerAZ85298GRP-1280CORE-HMO
ENRENR-1180772026-04-22T14:18:05ZMills, VincentH—11-06-1977UHC-69802-96•••-••-7363(460) 243-7886—2548 Market StreetGlendaleaz85309·GRP-3385NAVIGATE-HMO
ENRENR-1053782026-08-28T09:18:58ZCarol—Stevens1942-04-05UHC-34223-83•••-••-11517206056203carol.stevens@aol.com8496 River Rd #787·MINNEAPOLISMN55484GRP-0733MEDICARE-ADV-A
ENRENR-1023652026-04-09T11:19:31ZMyers, Maria···P—Feb 16, 1998·UHC-78259-73•••-••-710618343850501—7724 Sage Ct Apt 28TampaFL33676··GRP-4579SELECT-EPO
ENRENR-1012872026-08-20T05:38:14ZRios, GeorgeY—11/12/1974UHC-27407-51•••-••-8338+1 945 510 1110-6504 VALLEY VIEW DRIVEAustinTexas78707GRP-9011MEDICARE-ADV-A
ENRENR-1048572026-05-19T09:36:10ZvirginiaBcarr·Dec 5, 1943UHC-61445-77•••-••-32567792452388VIRGINIA.CARR95@YAHOO.COM8771 Union StHOUSTONTX77012-5531GRP-8519SELECT-EPO
ENRENR-1170322026-07-05T06:09:53ZLUIS··S·HOWARD09/10/87UHC-63334-20-(540) 754-1885luis.howard94@outlook.com·744 Harbor BoulevardLAS VEGASNV89139GRP-8879NAVIGATE-HMO
ENR ENR-1408532026-05-10T21:10:40ZLAURAUCRUZ1973-11-24UHC-36498-37UNKNOWN14508924031LAURA.CRUZ92@GMAIL.COM1327 Union StreetFresnoCA93716GRP-4092NAVIGATE-HMO
ENR ENR-1241532026-08-26T12:55:41ZAdamGPark1991-12-04UHC2514774•••-••-0003(904) 360-0239NULL··3624 WASHINGTON STREETMesaAZ85272GRP-7704MEDICARE-ADV-B
ENRENR-1038612026-03-14T03:57:27ZTimothy—Schmidt1997-04-04UHC-94810-30•••-••-23924215437270·TIMOTHY.SCHMIDT@OUTLOOK.COM6130 SAGE COURTSCOTTSDALEAZ85272GRP-2241··SELECT-EPO
ENRENR-1027622026-07-22T08:41:08ZBrendaH.Campebll04-07-2004UHC-47470-58··•••-••-4609567-928-5712brenda.campbell53@gmail.com9082 Lincoln WayHoustonTX77028GRP-5612NAVIGATE-HMO
ENRENR-1056162026-08-04T17:27:01ZBenjamin—Romero11/2/1978UHC-88365-92•••-••-5708(278) 444-1378benjamin.romero32@aol.com··614 Main Street Apt 8LOS ANGELESCA90017GRP-5377NAVIGATE-HMO
ENRENR-114522 2026-09-20T06:08:05Zzachary·Jcrawford·1968-04-24UHC-19313-14•••-••-6143892-652-9815zachary.crawford@outlook.com2766 Sage CtGlendaleAZ85342GRP-3623MEDICARE-ADV-A
ENRENR-1261062026-07-08T04:32:13ZNathanG.Cooper·7/15/2008UHC-14416-95•••-••-23143667218037···nathan.cooper@hotmail.com6781 Spring St Apt 31·MesaAZ85211·GRP-0283CORE-HMO
ENRENR-1055542026-04-02T20:47:30ZlawrenceOmccoy1981-11-19UHC-10728-13•••-••-6812851-336-0978lawrence.mccoy@gmail.com4352 Oak StreetScottsdaleAZ85214GRP-6647CORE-HMO
ENRENR-1396242026-05-26T09:04:59Zsophia—lynch1950-05-02UHC-90674-61•••-••-2934—sophia.lynch@proton.me··8743 Baseline RdEden Prairiemn55315GRP-6357CORE-HMO
ENRENR-1010382026-09-19T17:57:02ZSARAKPHILLIPS08/13/02UHC-60451-51•••-••-4472NULLsara.phillips26@gmail.com5025 Desert Sky BoulevardOrlandoFL··32803GRP-3408··SELECT-EPO
ENRENR-1150492026-07-31T10:08:03ZBrenda—Tran10/17/1994UHC-06212-91•••-••-57313952791709brenda.tran@gmail.com9506 Lake View RdTucsonAZ85739GRP-9285CHOICE-PLUS-PPO
ENRENR-1203042026-05-24T04:57:10ZWilliamson, Keith——Mar 27, 1976UHC-70723-03•••-••-2572··keith.williamson@hotmail.com1299 Valley View DrPhoenixAZ-GRP-2330NAVIGATE-HMO
43,101 rows, page 178 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.313Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty