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-1231632026-02-17T06:48:08ZLucai··—Hernandez20030805UHC-88709-12•••-••-0732(296) 607-6326lucia.hernandez91@outlook.com5947 BAYSHORE DRTEMPEArizona85287GRP-5778··CHOICE-PLUS-PPO
ENRENR-1098202026-06-20T23:30:40ZAlex····Diaz10/4/1989UHC6748157•••-••-0579415.857.0050alexander.diaz39@yahoo.com5065 Church StreetSCOTTSDALEAZ85235GRP-5821CHOICE-PLUS-PPO
ENRENR-1269252026-03-22T20:59:05ZCYNTHIA··—YOUNG··03/18/1971UHC-25405-85•••-••-7499744-460-9085cynthia.young53@hotmail.com455 Central AveTampaFlorida33633·GRP-8281CORE-HMO
ENRENR-1196012026-05-03T08:20:40Z·Richard—Sanchez1953-12-23UHC-22704-81null8506094050richard.sanchez@icloud.com349 Spring StMinneapolisMN55448GRP-8199CORE-HMO
ENRENR-1306382026-04-27T13:40:46ZMeiAHoffman1938-05-02UHC-76616-84•••-••-34646563458782·MEI.HOFFMAN64@GMAIL.COM9428 Oak StPLANOTX75031GRP-3890CHOICE-PLUS-PPO
ENRENR-1399122026-05-07T05:17:32ZJoshua—Maldonado1948-11-18UHC-02559-57•••-••-49994156690408NULL6776 Indian School RoadChandlerAZ85266GRP-1423NAVIGATE-HMO
ENRENR-1054802026-02-27T01:59:29Z ERIC—MORENO10/23/1942UHC-52544-11•••-••-1855—eric.moreno81@hotmail.com8842 Sage CourtLos AngelesCA90094GRP-8403CORE-HMO
ENRENR-1089782026-04-28T11:01:17ZAMANDA—HICKS1972-10-09UHC-66518-56•••-••-2126595-886-4136amanda.hicks60@icloud.com··5918 FOREST AVENUEMinneapolisMN55439GRP-2110CORE-HMO
ENR ENR-1058922026-08-13T18:37:07ZSHIRLEY—ALVAREZ1986-07-17N/A•••-••-7961(710) 448-3252NULL1833 Grand Avenue··GilbertazUNKNOWNGRP-1730MEDICARE-ADV-B
ENR ENR-1275582026-02-27T18:29:44ZSOPHIA—REID1993-12-11UHC-39328-57—N/Asophia.reid91@icloud.com1738 RIVER ROAD··ColumbusOH43284GRP-2575CHOICE-PLUS-PPO
ENRENR-1412402026-02-16T10:11:36Z ·GabrielLRodriguezJan 10, 1940UHC-18487-62—845-748-0756-6635 Canyon Rd··MesaAZ85239GRP-8823SELECT-EPO
ENR ENR-1323432026-08-11T04:09:12ZBOBBY—RILEY··03/26/1960UHC-22969-34•••-••-15092117549bobby.riley@gmail.com2284 MAIN STREETDenverCO80205GRP-0296SELECT-EPO
ENRENR-1083422026-09-26T18:58:16ZPerry, Doris——06/20/1995UHC-81544-25—529.484.2209DORIS.PERRY21@YAHOO.COM9693 LINCOLN WAYATLANTAGeorgia30330GRP-2401MEDICARE-ADV-A
ENRENR-1297952026-05-15T06:56:39ZGonzales, RandyG.—10-06-1963null•••-••-4334760.911.1496—37 Forest Ave··Las VegasNV89159GRP-5557··CHOICE-PLUS-PPO
ENRENR-1411032026-07-27T12:43:27ZJulia—Franklin19720822uhc-28885-09•••-••-3075664-996-1968—7844 Spring StMiamiFlorida33144GRP-4551MEDICARE-ADV-A
ENRENR-1153892026-01-20T02:53:41Z·Ryan—Morris··1965-01-04UHC-82461-53•••-••-16755878192433ryan.morris@proton.me5546 VALLEY VIEW DRSan AntonioTX78236GRP-2204OPTIONS-PPO
ENRENR-128994 2026-08-28T23:23:36ZBeverlyR.Vega1973-12-09UHC-03703-82··•••-••-0626+1 820 519 5728BEVERLY.VEGA@PROTON.ME1150 PINE DRGlendaleAZ85350GRP-1949CORE-HMO
ENRENR-1167002026-02-02T12:38:03ZWILLIEMROJAS1979-02-13UHC-56471-45•••-••-6263909.629.6986NULL··5962 Washington StreetChandlerAZ85269GRP-1718OPTIONS-PPO··
ENRENR-1060792026-07-24T03:05:22ZJordan, Kenneth——1963-09-22UHC-39698-67•••-••-0719355.855.2864KENNETH.JORDAN10@YAHOO.COM·3273 Canyon RdMINNEAPOLISMN··55437GRP-1564NAVIGATE-HMO
ENRENR-1058732026-03-05T10:07:04ZJUSTIN·VCRAWFORDOct 8, 1982UHC-66696-56•••-••-6017491-553-8423justin.crawford@icloud.com3216 Park PlHOUSTONTX77003GRP-6280SELECT-EPO
ENRENR-1001522026-06-30T05:42:09ZMarianaATurnr1997-07-23UHC-20164-12•••-••-9022343.711.9710N/A9224 Sage CtNashvilleTennessee37264-1224GRP-5894CORE-HMO
ENRENR-1294912026-07-18T14:41:53ZJeremmyGMartinez10-05-1995UHC-21213-40—7064286240jeremy.martinez@icloud.com1333 Bayshore Drive Apt 18GlendaleAZ85336GRP-1032CORE-HMO
ENRENR-1272942026-01-23T22:47:30ZRALPHVSANTOS19710417··UHC-84145-92•••-••-29825447614694UNKNOWN6368 Highland AveSacramentoCA95809GRP-2280SELECT-EPO
ENRENR-1054252026-02-09T14:34:35Zamber··Vcoleman··20-07-1948UHC-07698-89•••-••-2966641.858.9500amber.coleman96@proton.me1524 MARKET STREETDallasTX75203GRP-5415OPTIONS-PPO
ENRENR-1174272026-02-14T15:33:10ZValentina—Edwards1996-09-07··UHC-29970-49NULL919.249.2513—268 SPRING STREETSeattleWA98178GRP-2076SELECT-EPO
ENRENR-1160202026-04-14T20:52:27ZBeverly····Harrison03/11/62UHC-76087-44•••-••-42814336407608beverly.harrison@icloud.com8994 CEDAR LANESacramentoCA—GRP-4489CHOICE-PLUS-PPO
ENRENR-1105752026-03-27T20:46:54ZJOEJPETERS1970-01-08UHC-78498-42•••-••-1350—N/A2638 Lake View RoadChandlerAZ85261GRP-6652SELECT-EPO
ENRENR-1377002026-07-28T23:59:28ZDonald—Tran1952-02-13UHC-50361-26null4425497002donald.tran19@hotmail.com3981 Maple Avenue Apt 14TampaFL·33651GRP-3026MEDICARE-ADV-B
ENRENR-1348122026-01-17T13:58:46ZMariana—Valdez1982-04-23UHC-86395-54•••-••-0044927-733-4771mariana.valdez@proton.me·684 Oak StColumbusOH43207·GRP-8613·MEDICARE-ADV-B
ENRENR-1168042026-01-18T02:59:22ZWells, Jack····—1996-07-24UHC-04105-55•••-••-702413412874488UNKNOWN3646 SUNSET BOULEVARDTempeArizona85249-4377GRP-9377NAVIGATE-HMO
ENRENR-1032372026-01-31T03:25:45ZArthur·X.Munoz2006-05-28UHC-53883-63•••-••-5878960-975-2681N/A657 SUNSET BLVDTempeAZ85252GRP-7738CHOICE-PLUS-PPO
ENRENR-1173962026-04-07T21:15:17Z MARILYNCTHOMPSON3/13/1964UHC-26376-20•••-••-7465+1 822 716 3831marilyn.thompson60@yahoo.com·3010 MARKET STTampaFL33609GRP-9700MEDICARE-ADV-B
ENRENR-1130392026-01-21T09:07:13ZJasonW.Herrera1958-06-27UHC-57145-52•••-••-3350(234) 954-3371-1600 Palm DriveFresnoCA93747-5725GRP-5441CHOICE-PLUS-PPO
ENRENR-1115992026-09-22T08:49:59ZDavid—Ryan1984-05-22UHC-43444-74•••-••-0018null—·701 RIDGE RDMESAAZnullGRP-6098MEDICARE-ADV-B
ENRENR-1034562026-09-23T18:34:23Z·Moore, VirginiaM··11/16/1952UHC-66744-78•••-••-9233(736) 639-2874UNKNOWN6835 Pine Dr Apt 26MiamiFL33172-4222GRP-0122MEDICARE-ADV-A
ENRENR-1087842026-06-30T21:48:07ZDouglas—Fernandez01-01-1942UHC-20086-55•••-••-208016053563787douglas.fernandez61@gmail.com3013 SPRING STREETAUSTINTX78736··GRP-5381MEDICARE-ADV-B
ENRENR-1248372026-08-20T13:40:53ZKathryn—Duncan19660724·UHC-43519-95•••-••-86038957558703kathryn.duncan95@hotmail.com8671 FOREST AVENUE·AtlantaGA30336GRP-8419MEDICARE-ADV-A
ENRENR-1041382026-07-31T00:43:26ZSarah··U··Crawford19960624UHC-03646-77•••-••-744115948358126sarah.crawford@gmail.com8210 Cedar LnCOLUMBUSOH43297GRP-8412MEDICARE-ADV-B
ENRENR-1089932026-07-06T11:18:44ZFisher, Eugene——19690925UHC-45550-42•••-••-771814097157953—8143 Baseline Rd Apt 36ChandlerAZ85258GRP-1745MEDICARE-ADV-B
ENRENR-1041112026-02-19T03:07:54ZRyan—Tran27-06-1990UHC-25196-24•••-••-65015178816568ryan.tran@proton.me··5180 Apache BlvdFresnoCA93796GRP-4852MEDICARE-ADV-A
ENRENR-1220332026-07-17T17:18:29ZSarah—Chapman1961-08-32UHC-93677-08•••-••-611215957811650sarah.chapman@proton.me263 Ridge RdAustinTexas78779GRP-8225CHOICE-PLUS-PPO
ENRENR-1271302026-07-24T03:12:55ZJeffrey—Wells06/08/2007UHC-79372-14•••-••-18566944155262jeffrey.wells91@yahoo.com6786 Sage CourtDENVERCON/A·GRP-6831MEDICARE-ADV-A
ENRENR-1029282026-04-16T21:42:55ZPAUL··MBISHOP1949-08-10UHC-13439-25•••-••-0817579.749.2588paul.bishop9@gmail.com1352 Apache BoulevardDenverCO80255GRP-6523··OPTIONS-PPO
ENRENR-1338792026-02-05T09:57:44ZharperKphilip02/22/63UHC-80108-67-+1 687 573 2299philip.harper40@gmail.com3956 Bayshore DriveOrlandoFL32854-3205GRP-7363medicare-adv-b
ENRENR-1292272026-07-31T13:02:15ZDonaldQPerkins19400121UHC-49373-90•••-••-971317973507398—7251 Pine DriveCharlotteNC28220GRP-5098CORE-HMO
ENRENR-1003822026-04-16T08:59:41ZCynthia—Reid1987-11-14UHC-56937-09··•••-••-2415588-443-0620NULL7385 Church StreetOrlandoFL32888GRP-4940CORE-HMO
ENRENR-1428752026-06-16T23:47:07ZASHLEY·····GONZALAS4/18/1969UHC-33107-55•••-••-87828456163481ashley.gonzales66@proton.me3591 HARBOR BOULEVARD·CHARLOTTENC28285GRP-5485CORE-HMO
ENRENR-1390302026-08-09T03:23:58ZEspinoza, Keith——1963-02-24UHC-27101-51•••-••-85814139361853KEITH.ESPINOZA44@YAHOO.COM6826 Hillcrest RdMinneapolis··MN55407GRP-6369MEDICARE-ADV-A··
ENRENR-1271032026-10-02T22:25:54ZBENJAMINBWEAVER10-08-1996UHC-20232-99-·N/Abenjamin.weaver@gmail.com3047 Willow CourtColumbusOhio43204-4012GRP-0132NAVIGATE-HMO
ENRENR-1325952026-05-26T01:12:56ZWILLIEC.RIVERA1997-04-28UHC-34561-90•••-••-8027(675) 311-4765N/A3895 Meadow LnLos Angelesca··90067GRP-1941CORE-HMO
43,101 rows, page 323 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.618Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty