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-1380082026-07-09T00:19:06ZdonaldQ.santiago11/04/1962UHC-92432-89UNKNOWN··(939) 627-9118donald.santiago11@hotmail.com7104 LAKE VIEW RDGilbertAZ··85225GRP-8650SELECT-EPO
ENRENR-1250952026-03-21T01:02:18ZAbigailV.Marshall1982-04-17UHC-99816-10•••-••-815217277331794UNKNOWN1792 BROADWAYMinneapolisMN55477GRP-2552CORE-HMO
ENRENR-1073542026-08-26T21:51:04ZCatherine—Hudson2001-05-05UHC-76200-83NULL(597) 810-3544catherine.hudson65@hotmail.com370 Harbor Boulevard Apt 12MIAMIFL··33129-4079GRP-3391CHOICE-PLUS-PPO
ENRENR-1110462026-03-07T14:26:52Z·donna·W.ferguson19521117UHC-64369-08•••-••-8063252-627-9130donna.ferguson14@yahoo.com6244 Hillcrest RdNASHVILLE·TN—GRP-9838··MEDICARE-ADV-A
ENRENR-1427192026-05-16T07:35:24ZCARLOSG.RUIZ1986-04-23UHC-41194-02•••-••-30758483815644carlos.ruiz60@hotmail.com4033 Maple AveGlendaleArizona85316GRP-1656OPTIONS-PPO
ENRENR-1423772026-04-18T17:55:24Z·TERESA—REED1974-06-13UHC-91743-86•••-••-591917837657538teresa.reed@icloud.com2181 Main Street·Las VegasNV89144GRP-6849MEDICARE-ADV-B
ENRENR-1346122026-03-29T12:53:19ZCheryl—Alvarez·1/25/1938UHC0515116•••-••-4643——9105 Baseline RdOrlandoFL32875GRP-9676MEDICARE-ADV-B
ENRENR-1275282026-05-04T03:15:44ZFrancesK.Hudson1954-05-17UHC-60488-02•••-••-8373(837) 483-1360FRANCES.HUDSON@YAHOO.COM9405 Willow Ct Apt 15NashvilleTN37246GRP-0719·MEDICARE-ADV-A
ENRENR-1055012026-03-18T10:59:37Zphiilp—bell1989-06-25UHC-78034-52•••-••-6545(840) 312-1915philip.bell@yahoo.com2564 Palm Drive #240FresnoCA93722GRP-8658MEDICARE-ADV-A
ENRENR-1047872026-09-25T21:54:34ZSean—Clark···Dec 9, 1973UHC-83360-30•••-••-4259nullsean.clark@gmail.com6639 Mountain View DriveSacramentoCA95813··GRP-9850NAVIGATE-HMO
ENRENR-1305942026-06-21T17:54:58ZCHARLOTTE—LAWRENCE1946-05-15UHC-14351-68•••-••-8783909-960-7677CHARLOTTE.LAWRENCE23@HOTMAIL.COM8224 Valley View DriveMinneapolisMN55457GRP-6212core-hmo··
ENRENR-1199832026-03-09T06:53:44ZANAYGUTIERREZ24-01-1962UHC-95156-71•••-••-5127·807.672.5741ana.gutierrez43@yahoo.com··4154 Valley View DriveColumbusOH43243GRP-9599MEDICARE-ADV-B
ENRENR-1266782026-07-25T20:30:38Z·LoganU.Fields1991-08-03··UHC-12290-95··•••-••-3579+1 978 709 4139logan.fields92@icloud.com5038 Main StreetPhoenixAZ·85031GRP-3093NAVIGATE-HMO
ENRENR-120444 2026-07-26T06:13:41ZJackie····Parker1993-11-17uhc-11243-95•••-••-7018+1 946 521 8534jacqueline.parker8@aol.com4759 Mesa Dr·MesaAZ85254GRP-0979MEDICARE-ADV-B
ENRENR-1223302026-03-03T08:09:50ZLuisYJackson1992-06-25UHC-64643-91•••-••-1772(452) 715-5097luis.jackson9@yahoo.com2919 Park PlaceMinneapolisMinnesota··55476GRP-1528CHOICE-PLUS-PPO
ENRENR-1085352026-02-17T02:51:46ZLawrence E.··Mitchell1940-07-19UHC-30433-13•••-••-05336425815350lawrence.mitchell80@outlook.com5724 Hillcrest Rd Apt 11COLUMBUSOhio43221GRP-8079MEDICARE-ADV-A
ENRENR-1269622026-03-16T05:31:35ZAbigailU.Peters2003-10-20UHC-38914-38•••-••-6956+1 414 530 9293··abigail.peters41@icloud.com8838 Elm StAtlantaGA30373-9201GRP-8040CORE-HMO
ENRENR-1025482026-02-14T18:34:25ZBOBBYCCOOPER1940-02-01uhc-01816-03•••-••-48678540115bobby.cooper6@yahoo.com9529 Hillcrest RdGILBERT·AZ85286-7666GRP-6042MEDICARE-ADV-B
ENRENR-1020682026-06-23T19:31:31ZSTEPHANIEL··MILLER1992-05-27UHC-50204-08•••-••-9052+1 609 203 9771stephanie.miller26@yahoo.com339 CENTRAL AVENUE #176··JacksonvilleFL32212··GRP-2979OPTIONS-PPO
ENRENR-1083052026-05-31T00:28:36ZLarson, Donna——10/27/1939UHC-17183-32•••-••-0668245-666-2754-9649 Apache Blvd·AtlantaGA··30362GRP-4394SELECT-EPO··
ENRENR-1013512026-08-23T15:25:54ZWilliam—Knighht1947-04-10UHC-94551-87NULL6167086143william.knight25@proton.me3097 SAGE CTSeattleWA98196GRP-5550CHOICE-PLUS-PPO
ENRENR-1274222026-08-27T03:00:00ZSCOTT—HALL2003-02-18UHC-57013-81•••-••-08297217117160scott.hall84@yahoo.com2441 MAPLE AVENUE #466JACKSONVILLEFL··32208GRP-8169options-ppo
ENRENR-1010782026-01-06T21:44:40ZHIROSHIX.ARMSTRONG03-11-1952UHC-54673-76NULL5022261479null9809 LINCOLN WAYScottsdale··AZ85299GRP-1322MEDICARE-ADV-A
ENRENR-1417852026-08-25T18:02:45ZRICHARD··SHAW1996-02-03null•••-••-371319093629129richard.shaw@yahoo.com1104 JEFFERSON AVE·MinneapolisMN·55424GRP-5560MEDICARE-ADV-A
ENRENR-1040892026-05-10T09:55:22Z·NOAHPWILSON07/12/1942UHC2266758—481-984-0815UNKNOWN1183 SPRING STREETNashvilleTN37275··GRP-1104MEDICARE-ADV-B
ENRENR-1283962026-06-24T17:21:48ZCarlos··Sullivan·1948-05-15UHC-14063-41null573.659.8305CARLOS.SULLIVAN@AOL.COM4850 Mountain View DriveDenver·CO80260GRP-0255CHOICE-PLUS-PPO
ENRENR-1399652026-02-02T21:17:36ZGERALD—ANDERSON1999-08-03UHC-60914-75•••-••-0608nullgerald.anderson18@icloud.com6481 Lake View Road··MesaAZ-··GRP-3457SELECT-EPO
ENRENR-1283972026-07-10T05:57:54ZKATHERINEMGARZA12/13/77UHC-34249-92—·13798157969katherine.garza@yahoo.com910 LINCOLN WAYTampaFL33644GRP-9508NAVIGATE-HMO
ENRENR-1313102026-02-10T08:21:13ZAbigailR.Gutierez1951-05-02UHC-54068-46•••-••-3161753-626-1696—5075 SAGE CTPLANOTexas75062GRP-2913CHOICE-PLUS-PPO
ENRENR-1042542026-04-25T11:22:34Z ALEXANDERR.TURNER1994-07-02UHC-44580-36•••-••-67623565819790alexander.turner75@outlook.com171 Camelback RoadMinneapolisMN55479GRP-3110CORE-HMO
ENRENR-1263182026-04-10T19:39:18ZMARIA—HOLMES19440628UHC-41418-76•••-••-9565NULL—3447 Desert Sky BoulevardTEMPEAZ·85290-0430GRP-3683CORE-HMO
ENRENR-1148312026-03-10T01:15:17ZSTEPHANIE··HAYES5206-19-82uhc-35079-82•••-••-8772-stephanie.hayes60@aol.com6718 ELM STScottsdaleAZ85232GRP-2582OPTIONS-PPO
ENR ENR-1308862026-09-07T14:25:12ZBruceZ.Hart19761126UHC-51692-81•••-••-0555884-214-4282bruce.hart79@outlook.com2479 Mesa DrTucsonAZ·85786GRP-4924SELECT-EPO
ENRENR-1205572026-09-05T00:24:06Z·PHILIIPYWARD01/18/1982UHC-04779-18•••-••-5373273-979-5001··philip.ward75@aol.com··2868 Desert Sky BoulevardFresnoCA93749GRP-6970SELECT-EPO
ENRENR-1346252026-09-16T01:55:59ZETHAN—WATSON12/07/77UHC-77561-28null(238) 920-2282ethan.watson@outlook.com4309 Valley View DrTampaFL33626GRP-5769NAVIGATE-HMO
ENRENR-1230292026-01-19T22:41:54ZGLORIA—NELSON08-09-1954UHC-36758-70•••-••-1080486-480-2720GLORIA.NELSON@OUTLOOK.COM8017 Main StNashvilleTN37206GRP-9021options-ppo
ENRENR-1227542026-07-22T07:05:36ZJackB.Alexander··1971-04-20UHC-89498-08•••-••-7772(723) 740-4966NULL··7505 Mesa Dr #306GilbertAZ85215GRP-2177SELECT-EPO
ENRENR-1109322026-02-23T23:03:26Zalan A—wilson·2001-03-06N/A•••-••-2301—alan.wilson77@outlook.com9375 Camelback Road #912COLUMBUSOH43279GRP-2217SELECT-EPO
ENRENR-1132952026-04-02T08:16:04ZJOHN—CHAVEZ·1988-08-11UHC-47303-17•••-••-8037(535) 546-4218UNKNOWN7160 Valley View DrSAN ANTONIOTX78222GRP-2553NAVIGATE-HMO
ENRENR-1190692026-06-07T10:17:43ZKellyU··Patterson19481203UHC-93961-32•••-••-7266605-379-8623kelly.patterson11@hotmail.com·124 Grand AvenueGilbertAZ85259GRP-3800SELECT-EPO
ENR ENR-1341352026-06-30T05:59:40ZANN··R.··BANKS19960614UHC-98310-32•••-••-4380594.714.5082··-1224 Park Pl·DALLASTX75244GRP-6572select-epo
ENR ENR-1312372026-07-12T06:55:53ZSAMUEL—MARTINEZ1993-03-02uhc-63883-31•••-••-3393204.445.0890·samuel.martinez55@icloud.com3969 LAKE VIEW RDSan AntonioTX78262GRP-8231CHOICE-PLUS-PPO
ENRENR-1402872026-03-01T18:08:22ZCamilaACastillo07/24/00UHC-26142-58•••-••-5484308.475.0346—7096 Central AvenueTampaFL33614GRP-1495MEDICARE-ADV-B
ENRENR-1229642026-03-08T01:56:49ZDonnaA.Evans··1960-11-01UHC-46623-02•••-••-747415206216393-4193 Forest AveDenverCO···80216GRP-2946NAVIGATE-HMO
ENRENR-1201452026-04-07T14:59:58Z·Albrt—Knigth07-08-1994UHC-52355-58•••-••-2456null—6424 Mesa DrTempeAZ85229-0572GRP-7233·CHOICE-PLUS-PPO
ENRENR-1375272026-09-04T01:54:15ZWayneD.Dunn·Sep 20, 1981UHC-76545-20-454.671.3779wayne.dunn88@icloud.com2552 Willow CtSacramentoCalifornia95878-8113GRP-4348NAVIGATE-HMO
ENRENR-106674 2026-04-22T13:16:14ZHANNAHLANDREWS··1966-05-25UHC-23068-61•••-••-6217897.589.5438HANNAH.ANDREWS46@GMAIL.COM8163 Bayshore DrOrlandoFLN/AGRP-9204OPTIONS-PPO
ENR ENR-1228312026-09-05T11:05:53ZKathyLWeber19-04-1983UHC-61537-64•••-••-8001(966) 790-7447—6853 Lake View RoadSan Antoniotx78232-0172GRP-6044CHOICE-PLUS-PPO
ENRENR-1143772026-05-31T01:13:08ZBillyPPeterson·1954-11-28UHC-29755-09•••-••-0388802-283-7389billy.peterson@yahoo.com5137 Harbor Blvd Apt 3AtlantaGA30326·GRP-6593NAVIGATE-HMO
ENRENR-1200472026-03-30T10:27:23ZElijah—Hansen06/28/66UHC-64874-13•••-••-7404(563) 929-4848elijah.hansen6@aol.com6700 Jefferson Ave #240PhoenixAZ85037GRP-2950MEDICARE-ADV-B
43,101 rows, page 90 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:37.723Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty