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-1233992026-05-30T21:45:47ZANTHONY J—RAMIREZ1948-04-19UHC-63508-44•••-••-0052636-847-7792·anthony.ramirez@outlook.com6106 Spring StreetDallasTX75285GRP-7224OPTIONS-PPO
ENRENR-1395252026-09-22T13:36:27ZDougalsSFlores··1962-07-08UHC-54916-59•••-••-3525(364) 400-5721DOUGLAS.FLORES90@OUTLOOK.COM8010 Maple AvenueFresnoCA93704GRP-2191CHOICE-PLUS-PPO
ENRENR-1079222026-04-05T19:29:51Z·Gloria—Ryan1988-11-20UHC-61297-46•••-••-72978254741879gloria.ryan2@icloud.com3076 HILLCREST RDTEMPE·AZ85219GRP-3032MEDICARE-ADV-B
ENRENR-1121492026-02-12T09:18:21Z·LoganTRiosJun 22, 1984UHC-71668-54•••-••-2199(392) 864-7401logan.rios@yahoo.com7766 Sunset BoulevardEden PrairieMN···55330GRP-1542OPTIONS-PPO
ENRENR-1024242026-02-07T14:00:01ZMarkNHowlel07/09/1940UHC-14995-76•••-••-74048344239479—7289 MESA DRDENVERCO80276GRP-7301OPTIONS-PPO
ENRENR-1275242026-01-10T22:47:20ZVazquez, Cynthia·B.—1980-11-27UHC-10386-45•••-••-7564560.834.4257cynthia.vazquez74@yahoo.com8953 SPRING STREETTucson··AZ85752-8696GRP-4688SELECT-EPO
ENRENR-1060342026-02-09T14:46:02ZGloriaQWagner03/12/89UHC-72409-92•••-••-7610N/Agloria.wagner@proton.me·3345 Main StreetAtlantaGA30387GRP-8908NAVIGATE-HMO
ENRENR-1213052026-03-08T13:09:37ZMariaHCasstro1973-08-17UHC-68892-31•••-••-5802·+1 758 705 3617maria.castro97@hotmail.com571 Maple AvenueDENVERCO80249GRP-9255SELECT-EPO
ENRENR-1241192026-04-14T16:41:07ZcamilaLramos05/01/1952UHC-23396-60-(315) 681-5432camila.ramos@hotmail.com8909 Market StCHARLOTTENC·28213GRP-1035NAVIGATE-HMO
ENRENR-1396622026-03-26T01:40:49ZaishaR.grayDec 18, 1983UHC-66078-28•••-••-4588(712) 942-1644aisha.gray@outlook.com·8462 Main StMINNEAPOLISMN55488GRP-0622NAVIGATE-HMO
ENRENR-1065432026-02-11T08:25:16ZDeniseWHarvey07-01-1942UHC7759734•••-••-2306647-855-6485NULL1226 DESERT SKY BLVDScottsdaleAZ85285GRP-7570OPTIONS-PPO
ENRENR-1094852026-07-22T15:44:04ZDorothy V—Lopez1990-06-05UHC-66840-49—8266358852DOROTHY.LOPEZ@GMAIL.COM4255 Sage CtDALLASTX75208GRP-9625SELECT-EPO
ENRENR-1332492026-02-17T04:17:45ZHANNAHP.CONTRERAS2007-09-05UHC-34229-30•••-••-06912269628325hannah.contreras25@yahoo.com9577 River RoadChandler··AZ85215GRP-6745CHOICE-PLUS-PPO
ENRENR-1092112026-07-14T22:56:47ZRobertH·Contreras27-02-2004UHC-12292-95•••-••-0946509-300-6171—18 PINE DRIVEOrlando··FL32873GRP-0803choice-plus-ppo
ENRENR-1394602026-06-28T14:36:59ZBryan—Scott1997-04-17··UHC-20605-49•••-••-2043(462) 633-1275—7741 Cedar LaneCHANDLER··AZ85202GRP-4494CHOICE-PLUS-PPO
ENRENR-1059902026-02-06T20:56:34ZWood, LauraP.—1940-03-03UHC-76189-23•••-••-77736142107629—4514 RIVER RDColumbusOH43270GRP-3164NAVIGATE-HMO
ENRENR-1122322026-03-09T23:39:20ZAishaC.Boyd1976-06-01UHC-13717-90•••-••-0224—aisha.boyd8@proton.me418 Palm DrMiamiFL33165GRP-5849SELECT-EPO
ENRENR-1422432026-07-28T01:14:29ZKELLYI.GUTIERREZ1990-10-16··UHC-76846-41•••-••-809718907917505—6693 Maple AvenueLas VegasNV··89123GRP-0927CORE-HMO
ENRENR-1289602026-07-18T14:11:05ZJUDY·X.MASON·1953-08-20UHC-36621-84•••-••-6330(830) 325-8877judy.mason@proton.me6811 Ocean AveMinneapolisMN55454GRP-2217MEDICARE-ADV-A
ENRENR-1264332026-08-18T20:25:37ZBETTYMBARENS10/15/61·UHC-67824-46•••-••-3862+1 504 935 4840betty.barnes41@gmail.com5988 Ocean AvenuePlanoTX75092·GRP-4742medicare-adv-b
ENRENR-1044262026-07-09T22:38:54ZEvelynN.KellyJan 6, 1961UHC-87850-47•••-••-4089922-432-6417EVELYN.KELLY@YAHOO.COM8427 RIVER RDMinneapolisMN··55446GRP-2368NAVIGATE-HMO
ENRENR-1074192026-07-08T11:14:50ZJORDAN—WALLACE1983-07-18UHC-12381-44•••-••-2229920-861-5672jordan.wallace49@hotmail.com3887 Washington StAUSTINTX78764GRP-5390SELECT-EPO
ENRENR-1404852026-05-24T12:40:56ZJACOBDJACOBS12/4/2005··UHC-86809-88•••-••-35248748524295jacob.jacobs@aol.com734 Forest AveFresnoCA93772GRP-4761·MEDICARE-ADV-A
ENRENR-1393092026-08-10T06:17:35ZWillis, Ryan——1951-07-07UHC6762304•••-••-40662202578544ryan.willis14@gmail.com5630 MAPLE AVEJacksonvilleFL32249GRP-5996CORE-HMO
ENRENR-1393632026-06-21T08:38:55ZCaroyln··—Li1947-07-28UHC-82268-47•••-••-24247749764183carolyn.li71@outlook.com6525 HIGHLAND AVENUENashvilleTN37205GRP-8697MEDICARE-ADV-B
ENRENR-1219692026-01-19T05:37:33ZGRACE—HERNANDEZ1950-11-24UHC-88884-27•••-••-17602075289147grace.hernandez98@yahoo.com1280 SUNSET BLVDCHANDLERAZ85229GRP-0874MEDICARE-ADV-A
ENRENR-1292782026-02-05T01:30:59ZSamantha··—·Peters1997-12-01UHC-59150-84•••-••-35716303396349SAMANTHA.PETERS@HOTMAIL.COM4730 Mountain View DrMiamiFL33142GRP-7288CORE-HMO
ENRENR-1095252026-07-14T02:17:04ZPATRICIADWILSON1980-12-14··UHC-39355-98•••-••-4696(665) 934-9692patricia.wilson@yahoo.com5447 SAGE COURTCOLUMBUSoh43240GRP-0222CHOICE-PLUS-PPO
ENRENR-1270832026-08-02T00:54:52ZJuan··Lewis1964-04-09UHC5193121•••-••-00722759792juan.lewis@yahoo.com4772 Jefferson AvenueScottsdaleAZ85207GRP-7392CORE-HMO
ENRENR-1395682026-03-15T21:45:29ZBOBBY—LITTLE1983-04-03UHC-49754-96•••-••-4372-bobby.little@aol.com944 MARKET STCHARLOTTE··NC28203GRP-8386MEDICARE-ADV-B
ENRENR-1208502026-10-01T16:31:02ZNATALIE··—JACOBS02/13/05UHC-20927-65•••-••-1869-natalie.jacobs6@yahoo.com··3207 Market StGLENDALEAZ85315GRP-2262MEDICARE-ADV-B
ENRENR-1122612026-08-07T23:50:48ZMadison—Graham19670323UHC-44820-99•••-••-2168·8443448591madison.graham@icloud.com4121 JEFFERSON AVEAtlantaGA30325GRP-7610OPTIONS-PPO
ENRENR-1011182026-08-12T18:58:28ZDanielleRHart2002-05-09UHC0981333•••-••-2239····danielle.hart@yahoo.com746 WASHINGTON STREETMinneapolisMN55428GRP-8807··CHOICE-PLUS-PPO
ENRENR-1081522026-01-26T14:25:24Z Janice·S.Gonzales·Apr 13, 1999UHC-30169-72•••-••-8553+1 470 555 2894janice.gonzales35@aol.com3592 RIDGE ROADMesaAZ85257GRP-7790MEDICARE-ADV-B
ENRENR-1137422026-08-08T02:41:09ZLUIS·FSMITH1940-11-24UHC-09878-93•••-••-4902N/A·luis.smith@gmail.com4992 Park PlaceLos AngelesCA90054GRP-1173SELECT-EPO
ENRENR-1205652026-03-13T08:53:11Z Gonzales, Jacqqueline········03/13/1997·UHC-44443-96•••-••-0209543-229-6178jacqueline.gonzales@outlook.com5010 Cedar LnMesaAZ85226GRP-7519OPTIONS-PPO
ENRENR-1146602026-06-18T15:11:10ZBurke, Megan——19390611UHC-10284-69•••-••-0604—-5123 CAMELBACK ROAD··Phoenix·Arizona—GRP-5754NAVIGATE-HMO
ENRENR-1224792026-06-19T17:40:11ZKelly, Torres——09/25/48UHC-99496-72null495-880-7345KELLY.TORRES@GMAIL.COM4174 Ocean AvenueEden PrairieMN55304GRP-4517NAVIGATE-HMO
ENR ENR-1154752026-10-06T08:14:48ZRoy—Rojas1996-09-12··UHC-09247-18•••-••-8354(238) 590-0445roy.rojas@icloud.com4151 Washington StLos AngelesCA90034GRP-5308MEDICARE-ADV-A
ENRENR-1305082026-09-16T12:10:34Z·WeiZ.CruzAug 12, 1987UHC-90987-72—+1 969 646 1837N/A677 Willow CourtScottsdaleAZ85282GRP-0674SELECT-EPO
ENRENR-1280502026-05-28T20:39:49ZSHIRLEY—OBRIEN1969-02-16UHC-90722-63•••-••-1801UNKNOWNshirley.obrien@yahoo.com4621 Forest AvenueTempeAZ85234GRP-3432OPTIONS-PPO
ENRENR-1132172026-03-08T02:32:22Z HaroldZ··Russell1981-06-04UHC-56097-38•••-••-6199291-611-6906harold.russell20@outlook.com9253 PALM DRIVESacramentoCA95870GRP-1884·CHOICE-PLUS-PPO
ENRENR-1269752026-05-06T23:03:52ZSOPHIA—LE2000-04-12UHC0722646•••-••-3240+1 743 665 5837sophia.le@gmail.com3641 Forest AveDallasTXN/AGRP-0635NAVIGATE-HMO
ENRENR-1108222026-06-10T02:05:16ZTonyLTorres·1940-10-14uhc-59591-76•••-••-9004+1 845 316 7535—6430 Palm DriveSacramentoCalifornia95812-9694GRP-4868SELECT-EPO
ENRENR-1083882026-04-14T17:11:39Z Christina—CoxJun 21, 1964UHC-38214-73•••-••-8934——2967 Highland AvenueSCOTTSDALE·AZ85232GRP-3454CHOICE-PLUS-PPO··
ENRENR-1072512026-02-03T15:44:19ZMichael—Pena1950-04-25UHC-91542-65-N/AUNKNOWN—null—·UNKNOWNGRP-6847CORE-HMO
ENRENR-1165932026-08-30T02:32:59ZNANCYORICHARDSON07/04/2006UHC-90846-48•••-••-2107-UNKNOWN8986 WILLOW COURTHOUSTONTexas77006GRP-5070MEDICARE-ADV-A
ENRENR-1314592026-02-07T19:54:13ZGRAKETKELLY1948-11-19UHC-37534-77•••-••-6726(345) 496-1591grace.kelly@proton.me··884 Grand AveNashvilleTennessee37265GRP-7945MEDICARE-ADV-B
ENRENR-1426402026-03-11T05:57:50ZWeiO.Marshall1979-11-21UHC-81522-17•••-••-50762959881-6514 Mountain View Dr··ScottsdaleArizona85239GRP-5639MEDICARE-ADV-B
ENRENR-1408552026-04-01T04:08:38ZPAATRICIAJ··BURNS1954-03-14UHC-97556-39•••-••-3808814-253-4914-8332 Washington StSAN DIEGOCalifornia92177GRP-9022NAVIGATE-HMO
43,101 rows, page 148 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.472Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty