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-1196262026-04-19T11:06:04ZWilson, Christina——1989-05-09UHC-86231-01—+1 924 818 5789christina.wilson@outlook.com·7942 Bayshore DrOrlandoFL32897GRP-9183CORE-HMO
ENRENR-1226182026-10-04T13:42:15Z·CherylBLarson1972-07-04UHC-15926-53•••-••-32415078692913-4718 Forest Ave·Los AngelesCA90073GRP-4027MEDICARE-ADV-B
ENRENR-1243142026-08-07T12:55:49ZNickLGarrett1987-02-16UHC-58324-10—(896) 303-2558nicholas.garrett56@outlook.com8090 LINCOLN WAY #428Tucson·AZ85776GRP-3693MEDICARE-ADV-A
ENRENR-1066162026-09-29T10:46:00ZTorres, Santiago——Jun 15, 1961UHC-99531-69··•••-••-45592596244074santiago.torres26@yahoo.com————GRP-2939CHOICE-PLUS-PPO
ENRENR-1044952026-06-21T13:09:29ZElizabeth—Coleman09-04-1978UHC-37703-99•••-••-671216366706369elizabeth.coleman4@gmail.com9256 Indian School RdColumbusOH43247-7010GRP-1977·MEDICARE-ADV-B
ENRENR-1278332026-03-09T22:56:34Zalexis··payne·1960-09-09·UHC-05678-36•••-••-0844(843) 212-1327NULL·309 INDIAN SCHOOL ROADPhoenixAZ85062-8582GRP-9173NAVIGATE-HMO
ENRENR-1392142026-04-29T08:52:17ZJesse—Day18-05-1987UHC-56650-50NULL·(695) 617-6066JESSE.DAY94@ICLOUD.COM3022 Bayshore DriveAtlantaGA30332GRP-1964OPTIONS-PPO
ENRENR-141149 2026-04-15T07:02:10ZADAMGSCHULTZ1975-10-28UHC-81014-14•••-••-2132276.455.3652adam.schultz@outlook.com—-··-UNKNOWNGRP-1340OPTIONS-PPO
ENRENR-1234492026-05-21T14:12:10ZANDREA—MITCHELL08/25/54UHC-48937-47•••-••-4317244.444.2826andrea.mitchell@gmail.com7095 RIDGE ROADFresno·California93728GRP-6361··NAVIGATE-HMO
ENRENR-1004862026-07-03T18:36:19ZMARTHA—HILL19880923UHC-60043-73··•••-••-24573207487899-698 Park PlPhoenixAZ85001GRP-5489OPTIONS-PPO
ENRENR-1188622026-09-14T13:15:51ZLUIS—RILEY06/19/71UHC4236239•••-••-62272097919867LUIS.RILEY48@HOTMAIL.COM··8644 Apache BlvdLos AngelesCA90003-0240GRP-0799OPTIONS-PPO
ENRENR-1268412026-08-09T01:33:14ZJason—Espinoza9/6/1959UHC-11220-61•••-••-17737525778242UNKNOWN7266 Grand AvenueTEMPEAZ85281GRP-6953CORE-HMO··
ENRENR-1301952026-03-15T22:31:32ZPhillips, Dennnis——1996-12-07UHC-63082-94•••-••-5503(706) 623-7718dennis.phillips@gmail.com725 Grand AveORLANDO··FloridaN/AGRP-5162SELECT-EPO
ENRENR-1397702026-05-06T18:10:27ZAna····Kelly1984-10-08UHC-38685-48•••-••-98436518317698ana.kelly@aol.com6712 Main StAustinTX78730GRP-6125SELECT-EPO
ENRENR-1268782026-09-20T00:26:18ZNathanABennettAug 28, 1998UHC-01939-06•••-••-18209381184····1469 Spring StEDEN PRAIRIE··MN··55313GRP-8712choice-plus-ppo
ENRENR-141077 2026-04-10T12:12:55Zfrances—padilla1992-02-12UHC-30041-02•••-••-19253326016151null3122 Sunset BlvdEden PrairieMN·55388GRP-0448OPTIONS-PPO
ENRENR-1122072026-01-17T03:12:36ZColeman, Brenda——Nov 18, 1992UHC-20384-71•••-••-7077·6625946961UNKNOWN7077 SUNSET BLVDDenverCO·80293GRP-7626core-hmo
ENRENR-111593 2026-09-24T23:40:18ZLISA··WEST1985-01-04··UHC-50352-48•••-••-7222·688-500-4710lisa.west@aol.com4336 JEFFERSON AVENUEGlendaleAZ85399GRP-9586CHOICE-PLUS-PPO
ENRENR-1327992026-02-24T06:39:14ZBeverly—Allen·1936-01-04UHC-37163-07null17705232843beverly.allen@gmail.com2944 Willow CourtJacksonvilleFL32247GRP-5888··MEDICARE-ADV-B
ENRENR-1377582026-08-06T09:21:46ZOMAR—PENA10/4/1945UHC-29214-87•••-••-04445416597849-5332 Church StSCOTTSDALEAZUNKNOWNGRP-1128CHOICE-PLUS-PPO
ENR ENR-1146482026-01-13T10:16:10ZDennisLGilbert1938-11-10UHC-85450-66•••-••-28995999557223dennis.gilbert@icloud.com3653 Washington StreetJacksonville··FL32271GRP-4770CORE-HMO
ENRENR-1390472026-05-24T21:58:21ZDaniele—Stevens1944-02-13UHC-46226-50•••-••-25709558861612DANIELLE.STEVENS@GMAIL.COM4873 Ocean AvenueCHANDLERAZ85215GRP-9015SELECT-EPO
ENRENR-1089972026-01-22T19:43:21ZstevenRtaylor6/8/1966UHC-53391-04•••-••-9447+1 969 836 2988STEVEN.TAYLOR@GMAIL.COM9446 MAIN STREETTampaFL33670GRP-8971MEDICARE-ADV-B
ENRENR-1426762026-04-10T22:06:32ZJUDYR.DANIELS2005-06-30UHC-29533-54•••-••-3426300-828-8144judy.daniels@outlook.com··6141 Sunset BlvdFresnoCalifornia·93709GRP-0373OPTIONS-PPO
ENRENR-1423612026-07-29T09:39:17ZBryanN.Vargas1991-01-19UHC-24573-21null··(456) 901-6596bryan.vargas@hotmail.com6311 Sunset BoulevardLas VegasNV89101·GRP-8767OPTIONS-PPO··
ENRENR-1063442026-02-09T23:51:34ZYuki—Berry17-04-1993UHC-61933-66··•••-••-8610(546) 836-8795··—223 Valley View DriveDenverCO80294GRP-0832·MEDICARE-ADV-A
ENRENR-1118292026-06-13T02:06:04ZGarrett, Jacob——12/09/1939UHC-86308-51•••-••-0802(869) 582-9637null5038 Desert Sky BoulevardAustinTX78716··GRP-9397MEDICARE-ADV-B
ENRENR-1327122026-05-15T12:23:56ZJeremy—Henderson1994-12-07UHC-68558-75•••-••-5541+1 486 412 5425NULL887 Desert Sky Boulevard··MiamiFL33164GRP-9093OPTIONS-PPO
ENRENR-1364712026-01-26T16:40:23ZTERESAZCOLEMAN2005-06-26UHC-01517-27—(814) 944-9845TERESA.COLEMAN94@ICLOUD.COM5737 MAPLE AVENUE #982PHOENIXAZ85029GRP-7028CHOICE-PLUS-PPO
ENRENR-1000722026-06-07T04:49:59ZAMBERSWASHINGTON1997-01-01UHC-65404-63•••-••-0596628.739.5206amber.washington51@icloud.com3983 JEFFERSON AVENashvilleTN37209·GRP-3725·CORE-HMO
ENRENR-1209682026-05-10T19:10:38ZAndrewE.Mejia··1979-07-09UHC-23944-80•••-••-5722466.449.4639andrew.mejia@icloud.com5822 Valley View DriveDenverCO80267GRP-5820OPTIONS-PPO
ENRENR-1236752026-06-14T07:39:43ZAna—Gant1979-06-23UHC-25155-17•••-••-7544NULLana.grant63@icloud.com9741 OAK STREETMINNEAPOLISMN55447-9461GRP-4938MEDICARE-ADV-B
ENRENR-1406092026-08-31T04:55:44ZTHERESA··LEWIIS··9/20/1965·UHC-86460-92•••-••-9278(369) 268-9943theresa.lewis97@hotmail.com8792 MESA DRHoustonTexas77001GRP-6494MEDICARE-ADV-B
ENRENR-1419342026-06-10T05:29:27ZFatimaS.Martiin1964-11-24UHC-04430-17•••-••-5066929-864-7444FATIMA.MARTIN50@OUTLOOK.COM5235 Lake View RdHoustonTX77005GRP-9798MEDICARE-ADV-B
ENRENR-1132622026-02-16T11:35:42ZPamela—RuizOct 10, 1970UHC6209803—9505258522N/A1086 Meadow Ln·TampaFL33666GRP-6398NAVIGATE-HMO
ENRENR-1358312026-02-24T05:12:36ZBrian—·Jacobs2001-11-04UHC-22822-80•••-••-1828424.574.5244··brian.jacobs@gmail.com6051 Valley View DriveJacksonville··FL32239-6849GRP-4817MEDICARE-ADV-A
ENRENR-1045152026-08-29T07:56:54ZDavidQHall·Jun 4, 1947UHC-32874-59•••-••-93776060670·DAVID.HALL80@GMAIL.COM766 Central AvenueDENVERCO80252-0586GRP-8437CHOICE-PLUS-PPO
ENRENR-1428652026-07-01T06:31:32ZCatherine·LBennett12-01-1980UHC5889870•••-••-2465(258) 712-4462·CATHERINE.BENNETT@YAHOO.COM939 Ocean Avenue Apt 32AustinTX78790GRP-4780MEDICARE-ADV-B
ENRENR-1227622026-01-09T10:37:41ZCarlTWeebr··1999-04-18UHC-17260-12•••-••-9260·+1 507 399 3642carl.weber@hotmail.com2535 Market StCHARLOTTENC28221GRP-2787··OPTIONS-PPO
ENRENR-1413142026-09-11T11:30:31ZCATHERINE—JIMENEZ2008-06-06UHC-25455-37UNKNOWN+1 303 868 0566catherine.jimenez22@gmail.com478 ELM STREETCharlotteNC28244·GRP-8846SELECT-EPO
ENRENR-104315 2026-09-14T13:27:01ZDONWCOLE1957-02-18UHC-55288-55•••-••-0056+1 556 811 0237donald.cole@hotmail.com7977 Grand AvenueNashvilletn37251·GRP-2264NAVIGATE-HMO
ENRENR-1056332026-04-15T12:24:21ZCHARLOTTE—DUNN··1987-10-01UHC-00603-18•••-••-5610(587) 434-1669null6874 BroadwayDenverColorado·80250-4011GRP-8249NAVIGATE-HMO
ENRENR-1290232026-10-12T19:33:04ZMatthweFBurke19850811·UHC-89207-87•••-••-9813554-461-0600MATTHEW.BURKE@HOTMAIL.COM5897 Camelback RdLos Angeles··CA90051GRP-7679MEDICARE-ADV-B
ENRENR-1065142026-08-10T21:37:15ZAISHA—BERRY1976-03-07··UHC-76598-21NULL(861) 749-3114aisha.berry16@outlook.com2814 Oak StColumbusOH43226GRP-9554CORE-HMO
ENRENR-120245 2026-07-30T13:22:37ZEthanR.Little03-02-1983UHC-34632-67—983-411-2655ethan.little@proton.me·2244 PINE DRIVETampaFL33633-4984GRP-9479NAVIGATE-HMO··
ENRENR-1228272026-02-14T00:46:46ZAndrews, Catherine··——1959-08-12NULL•••-••-5406——7499 Bayshore Drive·DenverCO80272·GRP-2461SELECT-EPO
ENRENR-1123922026-04-02T11:12:51ZstephanieJfreeman1997-07-08UHC-23974-43•••-••-964114435742466STEPHANIE.FREEMAN62@YAHOO.COM8960 Spring StCHANDLERAZ85294GRP-5051CORE-HMO
ENRENR-1029352026-03-18T04:27:11ZBEVERLYHPRICE··1962-05-28UHC-13639-59•••-••-69842176874402—3799 Willow CtSeattleWA98175-9646GRP-4856OPTIONS-PPO
ENRENR-1212792026-09-15T08:08:12ZYukiDJones04/24/87UHC-69070-02•••-••-0939582-637-3080··yuki.jones@yahoo.com2363 Maple Ave #476JACKSONVILLE·Florida32260GRP-6080CHOICE-PLUS-PPO··
ENRENR-1310252026-04-26T10:04:41ZTIMOTHYNBRADLEY·Jan 14, 1982UHC-38160-44—8068900272TIMOTHY.BRADLEY22@OUTLOOK.COM4594 Baseline RdNashville··TN·37285GRP-3292MEDICARE-ADV-B
43,101 rows, page 314 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.607Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty