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-112314 2026-02-28T23:27:54Zdanielle—anderson08/09/1985UHC-89689-39•••-••-9812UNKNOWNDANIELLE.ANDERSON@GMAIL.COM8155 Church StCharlotteNC28284GRP-4173NAVIGATE-HMO
ENRENR-1023632026-06-08T14:18:21ZCheryl—Red2008-05-11UHC-44079-23•••-••-057713523512838NULL8264 BROADWAYPhoenix··az85012GRP-7203MEDICARE-ADV-A
ENRENR-1226232026-06-14T17:07:57ZMariNHughes1996-07-12UHC5772047•••-••-7451(571) 889-7528maria.hughes@outlook.com··4875 SPRING STREETLos Angelesca90096GRP-1298options-ppo
ENRENR-1124202026-08-01T11:03:08ZJessica—Ellis1997-03-05N/A•••-••-3881890-818-4992jessica.ellis@icloud.com2135 Mesa DriveJACKSONVILLEFL32280GRP-1759NAVIGATE-HMO
ENR ENR-1392622026-09-22T10:05:11ZYoung, Danielle··E—2004-09-22UHC-09608-97•••-••-5938979-819-8386—5918 Baseline RdSacramentoCalifornia95811-1284GRP-0791·options-ppo
ENRENR-1286922026-10-07T20:33:31Zandrew—knight1981-12-25UHC-92918-43··•••-••-2139775-630-3249andrew.knight67@gmail.com2680 PINE DRChandlerAZ85255·GRP-7935·OPTIONS-PPO
ENRENR-1228532026-02-05T22:04:57ZTYLER—HUGHES1985-02-21UHC-11147-61•••-••-0388(378) 307-0468—1804 Lincoln WaySacramentoCA95829GRP-1227NAVIGATE-HMO
ENRENR-1211032026-09-25T12:29:13Z·MarcusJTucker11/21/00UHC-60936-79•••-••-6719606.915.9266marcus.tucker@yahoo.com6343 PALM DRAustinTX78799GRP-8819MEDICARE-ADV-A
ENRENR-1065622026-08-12T21:53:46ZKAREN—WELLS·1991-03-06·UHC-21724-15—366-392-6888UNKNOWN3117 Central AveMinneapolisMN55407GRP-0672OPTIONS-PPO
ENRENR-1042682026-03-11T13:24:40ZFRANCESFALVAREZ1963-10-24UHC-86192-80•••-••-6848(776) 688-0620frances.alvarez@proton.me9208 Central AveMIAMIFL33130GRP-3707MEDICARE-ADV-A
ENRENR-1330582026-01-28T00:55:34ZBRUCEU·EVANS1496-06-09UHC-11065-29•••-••-7272411-945-6514bruce.evans70@gmail.com2759 Spring StreetCHARLOTTENC28204GRP-0570CORE-HMO
ENRENR-1242832026-01-05T05:38:28ZStephanie—Ellis04/18/67UHC-58296-03—+1 323 410 8268null3400 Jefferson AveAustinTX78769GRP-1589OPTIONS-PPO
ENRENR-1066602026-10-02T11:28:34ZAustinV.Berry2007-04-07UHC-63286-32•••-••-7128+1 537 570 1799NULL9431 CENTRAL AVENUE #760·Eden PrairieMinnesota55329GRP-3471OPTIONS-PPO
ENRENR-1233272026-09-10T02:19:31ZNOAHLJAMES1957-09-12UHC-65636-63··•••-••-5481·951.699.1019noah.james8@hotmail.com7565 Meadow LnAUSTIN··TX··78733·GRP-9177MEDICARE-ADV-B
ENRENR-1249572026-07-17T10:12:05Zbobby·Nhicks1953-02-05·UHC-64037-39•••-••-0211532-847-2842—9653 Palm DriveGlendaleAZ85382GRP-0691MEDICARE-ADV-A··
ENRENR-1248752026-02-02T05:21:38ZKevin—Wheeler1946-04-21UHC-17930-18•••-••-16958429192611KEVIN.WHEELER56@PROTON.ME6231 BROADWAYPlanotx75022GRP-3014CORE-HMO
ENRENR-1067322026-07-30T00:40:18ZSofia—OBrien·19670316UHC-11144-41•••-••-7316761-360-3371SOFIA.OBRIEN@AOL.COM7485 Ridge RoadJacksonvilleFL32286·GRP-2128CHOICE-PLUS-PPO
ENRENR-1392252026-03-07T19:40:49ZSusan—PerryJan 3, 1946UHC-00025-27·UNKNOWN3296789979susan.perry@proton.me8796 CAMELBACK ROADEden PrairieMinnesota55309GRP-0158OPTIONS-PPO
ENR ENR-1428512026-02-07T00:13:49ZPriya—Ellis1/20/1997UHC-18180-64•••-••-2323—priya.ellis@hotmail.com6657 MEADOW LNSAN DIEGOCA92106GRP-4614OPTIONS-PPO
ENRENR-1195582026-08-09T05:21:02Z·Kenneth—Fernandez10/01/73UHC-00016-47•••-••-9230912.489.4432kenneth.fernandez@yahoo.com4810 Ridge Rd #491MesaAZ··85286-1754GRP-3202SELECT-EPO
ENRENR-1082432026-06-09T20:23:33ZKeithF.Nelson1944-03-05UHC-26507-51•••-••-4174484.662.8345KEITH.NELSON@ICLOUD.COM8933 Canyon RdOrlandoFL32843GRP-0610MEDICARE-ADV-A
ENRENR-1232152026-07-22T02:08:27ZLauren····Stevens1963-09-02··UHC-11564-70•••-••-4340(483) 373-7828LAUREN.STEVENS@PROTON.ME2750 BroadwayAtlantaGA30327GRP-9325OPTIONS-PPO
ENRENR-1283602026-01-25T17:11:06ZBENJAMIN—WONG10/12/1948UHC-60828-17·null340-597-0565—1782 Pine DrMesaArizona85217·GRP-9936·SELECT-EPO
ENRENR-1216292026-04-07T13:49:56ZNatalie····MoralesFeb 13, 2008UHC-94001-78•••-••-2161·855-628-0410—782 Grand AvenueLas VegasNV89100GRP-0370OPTIONS-PPO
ENRENR-1071822026-07-25T07:20:27ZALEXISP.MEYER09/04/85UHC-17132-60•••-••-7726·834.414.0412··6460 Baseline RdMesaAZ85249··GRP-6722OPTIONS-PPO
ENRENR-1352902026-01-01T08:35:38ZDouglasN.Gray1992-08-04UHC-82303-97··•••-••-8063408-407-3926·DOUGLAS.GRAY87@PROTON.ME7609 Bayshore DriveChandlerAZ85274·GRP-4079MEDICARE-ADV-A
ENRENR-1412382026-01-17T11:35:41ZCHRISTINEZDIXON·08/18/1964UHC-34283-65•••-••-1141(851) 248-9796christine.dixon@outlook.com361 Mountain View DriveSan AntonioTexas·78240GRP-1215SELECT-EPO
ENRENR-1354342026-01-25T11:47:01ZChristianL·ClarkSep 17, 1953UHC-97621-91•••-••-531317434222426····2938 Maple Ave··ChandlerAZ85239GRP-5516MEDICARE-ADV-A
ENRENR-1261742026-08-20T19:01:05ZJulieY.Maldonado2003-02-09UHC3209594•••-••-6649·13676613460julie.maldonado43@gmail.com2499 Cedar LaneTampaFL33655GRP-4452CORE-HMO
ENRENR-1249392026-10-18T18:23:30Zaaron····cox1973-07-25UHC-64407-76•••-••-9663·727.987.7927aaron.cox52@gmail.com4580 Elm StreetMesaAZ85201GRP-1972CORE-HMO
ENRENR-1298492026-07-11T18:45:06ZCherylCBarnes1966-10-02UHC-88098-43•••-••-7068·784-218-4408cheryl.barnes@icloud.com9897 Grand AveScottsdaleAZ85261GRP-0243NAVIGATE-HMO
ENRENR-1377402026-04-11T17:00:10ZJOSEBLONG1972-08-05UHC-18259-67•••-••-51134684573172jose.long@outlook.com8334 CANYON ROADNashvilleTN37269GRP-2546MEDICARE-ADV-B
ENRENR-1057842026-10-14T04:58:43ZDANIELLE—LONG1998-01-10UHC-61358-21··•••-••-86918696088611—105 Ocean AveLos AngelesCA90077·GRP-3336CHOICE-PLUS-PPO
ENRENR-1005512026-05-06T02:56:47ZMary—Lucas1972-07-10UHC-34435-37•••-••-2540(855) 493-7649mary.lucas@aol.com6062 Harbor BlvdSAN DIEGO··CA92182GRP-9868CHOICE-PLUS-PPO
ENRENR-1074292026-01-07T09:28:03ZcarolYgonzalez1955-10-09·UHC-52139-69•••-••-9114(580) 787-5170UNKNOWN6918 DESERT SKY BLVDMinneapolisMN55448GRP-0576NAVIGATE-HMO
ENRENR-1189882026-01-08T14:40:48ZMEIB.BRADLEYN/AUHC-98883-33•••-••-5791··MEI.BRADLEY6@ICLOUD.COM3322 Palm DrDENVERco80277GRP-7864OPTIONS-PPO
ENRENR-1155142026-06-28T22:38:38ZAlice—PriceOct 13, 1963UHC-90090-71•••-••-2627(604) 848-2917alice.price1@proton.me4590 SUNSET BLVDAtlantaGA30315GRP-7849MEDICARE-ADV-B
ENRENR-1006442026-02-19T00:04:56ZTaylor, Grace··A—1971-09-23—•••-••-7012415-414-9172·grace.taylor92@yahoo.com7577 Camelback RoadAtlantaGA·30339GRP-7967OPTIONS-PPO
ENRENR-1148842026-05-24T13:42:19ZJerry—HarrisonMay 6, 1966UHC-34375-67•••-••-9279(748) 823-1379JERRY.HARRISON84@AOL.COM1363 RIVER ROADSan DiegoCA92176GRP-4812MEDICARE-ADV-A
ENRENR-1154782026-03-30T05:39:41ZDouglas, PenaR.—05-08-1965··UHC-46619-09•••-••-3865····douglas.pena@gmail.com9100 Bayshore Drive Apt 30Eden PrairieMN55379GRP-0573··CORE-HMO
ENRENR-1262602026-07-27T10:12:49ZKathryn—Harvey·1939-06-06UHC-96992-41•••-••-13782399017112KATHRYN.HARVEY35@ICLOUD.COM5744 River RdDallasTexas75221GRP-1806NAVIGATE-HMO
ENRENR-1207462026-06-03T18:17:39ZMARKL··VALDEZ1963-01-27UHC-15559-11•••-••-93777848814410—8847 Mesa DriveNashvilleTN-GRP-6353MEDICARE-ADV-B
ENRENR-1128252026-02-21T13:23:09ZBryantODonald5/8/1938UHC-55875-41•••-••-6771nullDONALD.BRYANT70@HOTMAIL.COM7574 Bayshore DriveJacksonvilleFL32220-4497GRP-1099CORE-HMO
ENRENR-1421982026-07-02T11:05:47ZWeiCRodriguez1951-06-05UHC-59190-22•••-••-43469636052526wei.rodriguez@hotmail.com6471 Hillcrest Rd··MINNEAPOLISMN55422GRP-5594MEDICARE-ADV-B
ENRENR-1365202026-03-25T03:44:08ZBradleyNHernandez5/27/1998UHC-70759-17•••-••-86518603992759bradley.hernandez79@yahoo.com2161 Washington St·SacramentoCalifornia95872GRP-9596CHOICE-PLUS-PPO
ENRENR-1134462026-06-02T04:48:43ZOmarTMatthews1974-12-10UHC-66764-33•••-••-47568883431618NULL7558 WASHINGTON STREET Apt 10···ChandlerAZ85252-4796GRP-2397CHOICE-PLUS-PPO··
ENRENR-109440 2026-01-09T19:54:57ZAMY··MATTHEWS1977-12-25UHC-25580-78•••-••-4596739.568.6519null4188 Hillcrest Road·MesaAZNULLGRP-1361SELECT-EPO
ENRENR-1190252026-06-13T22:26:43ZYuki—Wood·11/15/1998UHC-13952-38•••-••-4318544-404-8454yuki.wood@icloud.com4796 BroadwayTUCSONAZ85734-4524GRP-7343CHOICE-PLUS-PPO
ENRENR-1175072026-07-27T14:37:06ZjulieAharrison1958-11-06UHC-92178-06—·+1 291 835 2334julie.harrison@icloud.com7541 Jefferson AveLas VegasNV89151GRP-5884CORE-HMO
ENRENR-1017012026-04-04T20:24:25ZMarilynEMiller1955-01-17UHC-47254-57•••-••-61214843845346MARILYN.MILLER18@GMAIL.COM6379 Pine DrSacramentoCA95808GRP-9014CORE-HMO
43,101 rows, page 153 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:38.478Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty