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-1139712026-02-05T21:27:03ZColeman, EvelynV—NULL·UHC-59991-62•••-••-4707755.393.3108UNKNOWN5757 Main StreetTampa·FL33672GRP-1530OPTIONS-PPO
ENRENR-1390452026-05-29T15:59:39Z Don—Hudson07-02-1964UHC-48273-26•••-••-6132—-6118 Lake View RoadMinneapolisMinnesota55444-8230GRP-6644CHOICE-PLUS-PPO
ENRENR-1304802026-04-16T22:39:50ZVincentHEvans·Feb 9, 2007UHC-91535-79•••-••-836919343006985-·5354 FOREST AVENUEAUSTINtx78705GRP-6211CORE-HMO
ENRENR-1211532026-06-28T11:34:29ZAngela—Rose1944-09-19UHC-67908-80•••-••-4689526-596-0167—·2743 Ridge RdHOUSTONTX··77006GRP-2461NAVIGATE-HMO
ENRENR-1429972026-02-11T11:10:03ZNoahK.Boyd··1790-07-15UHC-94724-49•••-••-7479N/Anoah.boyd@gmail.com474 WASHINGTON STGlendaleAZ—GRP-3653OPTIONS-PPO
ENR ENR-1075782026-04-20T01:40:13ZVasquez, Jennifer··I.—6/14/1954UHC-71721-93•••-••-31964419304062jennifer.vasquez38@proton.me8150 SUNSET BLVDHoustonTexas···77099GRP-3446CORE-HMO
ENRENR-1292172026-05-31T16:35:45ZBrenda—Larson1967-06-24UHC-66176-92·-(761) 970-4000N/A5505 MOUNTAIN VIEW DRIVE Apt 6Nashvilletn37258GRP-8576NAVIGATE-HMO
ENRENR-1287162026-02-04T08:22:00ZDylan—White1948-11-26·UHC-40771-60•••-••-7108—-8523 Oak Street··MESAAZ·85273GRP-7434CORE-HMO
ENRENR-1393512026-05-31T06:39:37Z·Logan—Schmidt11/06/96UHC7298069•••-••-0992231-738-5984—2821 RIDGE RD·OrlandoFL32853GRP-4308OPTIONS-PPO
ENR ENR-1128832026-04-10T14:51:14ZMeiAJohnson1978-02-23UHC-36165-09UNKNOWN-NULL4634 River Road #113PlanoTX75089GRP-9331OPTIONS-PPO
ENRENR-1275722026-07-07T12:15:30Z SaraKRoberst1973-03-18UHC3748691•••-••-24327328855620sara.roberts47@icloud.com2948 BroadwayAtlanta·GA30348-7640GRP-2232CHOICE-PLUS-PPO
ENRENR-1093462026-02-01T00:08:29ZSAMANTHA—ROBERTS12-10-1980UHC-44286-72•••-••-7713-samantha.roberts@icloud.com4083 BASELINE RDSan DiegoCA92160GRP-4853select-epo
ENRENR-1427832026-08-25T06:28:34ZEVELYNHHUGHES1999-02-26UHC-38691-18•••-••-7709597-261-7796EVELYN.HUGHES79@AOL.COM1327 SAGE CTLas VegasNV89154GRP-9787CORE-HMO
ENRENR-1155402026-09-08T10:12:31ZAshleyCLucas1945-10-28UHC-17637-43•••-••-3065658-748-5628ashley.lucas@yahoo.com7450 BroadwayNashville·TN37211GRP-4122CHOICE-PLUS-PPO
ENRENR-1229172026-01-24T04:17:28ZbradleyYramirez2001-02-14UHC9575220··null··9478906192UNKNOWN1256 Canyon Road Apt 7MesaAZ85261GRP-7078MEDICARE-ADV-B
ENRENR-1040012026-05-29T17:05:14ZANNOADAMS03/09/64UHC-49487-89··19476613565ann.adams6@icloud.com4774 BroadwayScottsdale·AZnullGRP-9801OPTIONS-PPO
ENRENR-1038102026-01-22T14:08:10Z·JusttinHVega1963-07-18··UHC-33269-61•••-••-23247118533690·justin.vega@aol.com8801 WASHINGTON STAustinTX·78794-0967GRP-0697SELECT-EPO
ENRENR-1070652026-03-22T16:20:44ZArjun····Bradley1959-04-16UHC2674533•••-••-8819—arjun.bradley39@proton.me1459 OCEAN AVEDallasTexas75254··GRP-8167CORE-HMO
ENRENR-1265992026-01-04T12:55:11ZMELISSAIGIBSON09-07-1965UHC-50376-45•••-••-17432110885melissa.gibson@icloud.com9252 Mesa DrMesaAZ85294-7061GRP-6935CORE-HMO
ENRENR-1172242026-06-08T15:28:19ZYukiUOrtega1977-05-26UHC-69924-78•••-••-8467NULL··yuki.ortega96@proton.me9570 Cedar LnLos AngelesCA90089·GRP-7595MEDICARE-ADV-B
ENRENR-1195472026-10-05T14:53:02ZAbigailZBrooks1992-04-21uhc-31101-36•••-••-7604510-438-8223abigail.brooks85@aol.com3405 Harbor BlvdOrlandoFL32801GRP-2239NAVIGATE-HMO
ENRENR-1201932026-01-14T10:12:24ZDANIEL—PATTERSON1983-06-22UHC-32182-09•••-••-65729893376478DANIEL.PATTERSON@OUTLOOK.COM·6795 Ridge RdSan Antoniotx78279GRP-7034choice-plus-ppo
ENRENR-1170522026-07-18T13:18:02ZWillie—·Gordon06/13/1944UHC-53886-67•••-••-2371·9893213490willie.gordon92@hotmail.com7310 CHURCH STREETTucsonAZ85754GRP-4593CHOICE-PLUS-PPO
ENRENR-1399912026-01-16T03:44:14ZANA—TAYLOR1975-06-18UHC-73163-58··•••-••-876012943049886ana.taylor19@aol.com4803 Willow CtChandlerAZ85234GRP-3222CORE-HMO
ENRENR-1104312026-08-04T17:35:21Z·Arthur—Ryan19891028UHC7834845•••-••-2638N/AARTHUR.RYAN@AOL.COM·2752 River RoadTampaFL·33651GRP-3178SELECT-EPO
ENRENR-1392402026-06-05T23:17:08ZSophia—Riley12/20/1981UHC-88399-89—(456) 398-1142sophia.riley24@icloud.com6152 Washington StreetSan DiegoCalifornia92173GRP-9518NAVIGATE-HMO
ENRENR-1381772026-01-18T10:04:35ZBrian—Dixon07/13/85UHC-02163-23—340.505.3318··NULL··8209 Maple AveGilbertAZ85204GRP-1761CHOICE-PLUS-PPO
ENRENR-1048992026-04-12T21:11:42ZSarah—Snyder1944-01-02UHC8375553•••-••-92342938583248SARAH.SNYDER21@GMAIL.COM8118 Canyon RdSan Diegoca92188GRP-6032MEDICARE-ADV-B
ENRENR-1109242026-06-17T08:34:34ZRick···Phillips2/4/1997UHC-68324-20—6819995947—·1443 Washington StreetGilbertAZ85270GRP-7057MEDICARE-ADV-B··
ENRENR-1335952026-07-25T14:04:08ZRay, BryanI—11/20/1958UHC-15231-85•••-••-5361897.685.2507bryan.ray@gmail.com9671 Indian School RdTucsonAZ85765GRP-3651·MEDICARE-ADV-A
ENRENR-1234912026-10-10T06:36:17ZSeanNHicks1971-01-22UHC-17934-68•••-••-0199238-612-4135sean.hicks5@icloud.com7299 Baseline RdAtlantaGeorgia·30397GRP-6074CHOICE-PLUS-PPO
ENRENR-1376902026-07-09T17:23:51ZJoan—Waber1956-02-06UHC8118090•••-••-49638395974612joan.weber44@gmail.com···1837 Sunset BoulevardAtlantaGA30394GRP-9148MEDICARE-ADV-A
ENRENR-1025072026-07-14T00:13:36ZABBYFSCHULTZ1953-12-18UHC-83069-97UNKNOWN···306.934.7118·ABIGAIL.SCHULTZ@YAHOO.COM5760 HIGHLAND AVENUEEden PrairieMN55358GRP-2856OPTIONS-PPO
ENRENR-1376732026-01-09T09:10:38ZCharles—Kelly1939-01-01UHC-30123-69•••-••-8875(773) 817-7776charles.kelly19@yahoo.com4325 MEADOW LNSacramentoCA95874GRP-1276CORE-HMO
ENRENR-1246722026-09-20T18:36:38ZBanks, Gloria··——19500706UHC8465502•••-••-2326UNKNOWNgloria.banks76@icloud.com5506 Park PlaceJacksonvilleFLnullGRP-4226CORE-HMO··
ENRENR-1002942026-01-20T09:09:09ZMIE··UDUNN16-08-2006UHC-18186-94•••-••-53355549773334MICHAEL.DUNN20@YAHOO.COM·7975 CHURCH STREETGlendaleAZ85329GRP-7547CORE-HMO
ENRENR-1089812026-03-29T13:14:50ZRussellJPowall1942-08-18UHC-28230-99•••-••-34023099786russell.powell11@outlook.com—NULL——GRP-2840OPTIONS-PPO
ENRENR-1422772026-05-06T18:35:22ZMasonQMaldonado1993-05-22UHC-59194-16•••-••-46384069970837mason.maldonado2@outlook.com4878 Ocean AveChandlerAZ85233GRP-2010NAVIGATE-HMO
ENRENR-1352022026-02-08T07:07:01ZMraiKMedina1968-07-26UHC-77914-28•••-••-652112446763516maria.medina56@gmail.com1193 Indian School RdMiamiFL33164GRP-1729CORE-HMO
ENRENR-1233622026-04-03T05:04:13ZCheryl—HansenN/AUHC-33532-41•••-••-8714NULLN/A4801 Hillcrest RdScottsdaleAZ—GRP-5503SELECT-EPO
ENRENR-1097342026-02-19T05:56:21ZMeyer, VincentM—2005-07-25UHC-00737-86•••-••-0260721-572-6749UNKNOWN7588 Camelback RoadDALLAS·TX75251GRP-3339OPTIONS-PPO··
ENRENR-1279122026-05-18T14:32:58Zjacqueline—berry1949-03-17UHC-12284-64•••-••-3720+1 481 809 4928JACQUELINE.BERRY48@PROTON.ME1043 Ocean AvenueJACKSONVILLEFL32201GRP-7677MEDICARE-ADV-A
ENRENR-1412952026-01-22T20:04:42ZJordan—Brooks03/19/1963UHC-55414-72··•••-••-76407516578927—9719 Church St··PlanoTX··75053GRP-1095MEDICARE-ADV-A
ENRENR-132660 2026-05-11T22:36:49ZHiroshiNArnold1979-04-09UHC-91468-21•••-••-17495297206074NULL9087 Harbor BoulevardChandlerAZ85228GRP-2687MEDICARE-ADV-A
ENRENR-1170812026-09-26T17:21:36ZHENRYRCAMPBELL2001-08-15UHC-45214-87N/A18038862277UNKNOWN5329 Camelback RoadCOLUMBUSOH43298GRP-5581NAVIGATE-HMO
ENRENR-1033202026-09-19T07:43:12ZEstrada, BryanB—·02/12/1939UHC-28517-49•••-••-2251+1 417 664 5671UNKNOWN2929 VALLEY VIEW DRIVE·COLUMBUSOH43238GRP-6377··SELECT-EPO··
ENRENR-1213722026-04-16T02:54:25ZANDREWYDOMINGUEZ06/06/08uhc-74762-12•••-••-4483277.831.7507andrew.dominguez57@outlook.com2936 BroadwayCOLUMBUS·ohnullGRP-0714SELECT-EPO
ENRENR-135192 2026-06-01T10:17:09ZKathryn—Payne1988-12-19UHC-12324-03-8638248181null7108 Canyon Road··Mesa·AZ85289GRP-7156SELECT-EPO
ENRENR-1011832026-10-09T21:01:28Zmartha—guerrero1974-02-06uhc-94695-32•••-••-2398+1 272 651 3045—6792 Ocean AveGlendaleAZ85335GRP-3584··SELECT-EPO
ENRENR-1363042026-01-17T11:30:53ZBARB··ZBARNES·09/12/06UHC-95085-67•••-••-1178(488) 365-6405·barbara.barnes82@gmail.com9453 PARK PLAustinTX78780-8699GRP-2422MEDICARE-ADV-B··
43,101 rows, page 173 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.503Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty