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
ENR ENR-135925 2026-10-11T03:24:58ZNICHOLASBPARK1963-11-01UHC-31302-45•••-••-4531478-725-8907nicholas.park65@proton.me·6548 Jefferson AveLOS ANGELES·CA90047-6112GRP-9971OPTIONS-PPO
ENRENR-1231882026-01-17T03:51:21Zdavid—andrews1950-09-02UHC-01919-18•••-••-809016954009348DAVID.ANDREWS4@GMAIL.COM3567 Sunset BlvdJACKSONVILLEFlorida—GRP-5053MEDICARE-ADV-B··
ENRENR-1425632026-09-22T12:02:14Z·JUAN—WALLACE2/27/1954UHC-92362-72•••-••-145314805613121JUAN.WALLACE@YAHOO.COM5508 UNION STColumbusOH43254··GRP-4474CORE-HMO
ENR ENR-1337712026-04-13T04:21:11ZJANET Z—YANG·10/2/1971UHC-47290-18•••-••-0493(385) 858-4468null9686 CEDAR LANESACRAMENTOCA95824·GRP-6158CHOICE-PLUS-PPO
ENRENR-1213562026-10-10T16:30:16ZArthurNRyyan1963-11-16UHC-21613-25•••-••-9712·7099349751—3760 SPRING STLOS ANGELESCA90056GRP-9356MEDICARE-ADV-B
ENRENR-1339852026-10-08T12:26:36ZLORI—COOK1950-10-23-•••-••-0231394-634-6167LORI.COOK36@HOTMAIL.COM8743 PARK PLGLENDALEAZ85393GRP-1947CORE-HMO··
ENRENR-1296522026-06-16T22:05:50ZDebraCRose05/23/55UHC-38793-80•••-••-9804796-856-4591-7416 Baseline Road Apt 36MesaAZ··85276GRP-3200OPTIONS-PPO
ENRENR-1380712026-01-26T07:10:22ZMARTHAN.HERRERA·06/01/56UHC-70389-89•••-••-7357322-967-0616UNKNOWN1696 Park PlLos Angeles··CA···NULLGRP-1403NAVIGATE-HMO
ENRENR-1336842026-05-08T05:32:29ZTheresaBAndrews2005-05-21UHC-01657-25•••-••-97643275187034N/A4366 SPRING STCharlotteNC28247·GRP-9297CORE-HMO
ENRENR-1225172026-03-24T22:55:12Z JeffreyL.Maldonado1987-04-25UHC-80273-31•••-••-81532566266696jeffrey.maldonado@outlook.com2986 Church StAUSTINTX78770GRP-9693CHOICE-PLUS-PPO
ENRENR-1054382026-04-02T14:57:50Z ·KENNETHI·OBRIEN04/17/1948UHC-17109-44•••-••-0961——·8106 CEDAR LANECHARLOTTENC28212-9080GRP-5298CHOICE-PLUS-PPO
ENRENR-1171792026-10-11T13:58:03ZSophia—Bowamn1968-08-22UHC-14385-23•••-••-4335NULL—4709 HIGHLAND AVEDENVERCO80233GRP-9721MEDICARE-ADV-B
ENRENR-1363902026-09-22T09:08:58ZBennett, Brandon——1939-08-21UHC2077628•••-••-1843837-304-5542·brandon.bennett29@hotmail.com1280 CAMELBACK RDTucsonAZNULLGRP-0133SELECT-EPO
ENRENR-1140632026-09-25T04:39:14ZHannahDWatsonJul 27, 1995UHC-44586-69•••-••-30057182887677HANNAH.WATSON@HOTMAIL.COM9895 Bayshore DriveSan AntonioTX78224·GRP-1669CHOICE-PLUS-PPO
ENRENR-1056072026-02-13T18:51:50Z annaRschultz01/02/1946··UHC-40672-67•••-••-5573·2178195267anna.schultz20@outlook.com9395 Valley View DrSCOTTSDALEAZ85253GRP-0444NAVIGATE-HMO
ENRENR-1116402026-01-01T11:18:27Zsarah—henderson··1972-04-16UHC-24133-93•••-••-081115716900431SARAH.HENDERSON@OUTLOOK.COM8426 CEDAR LNMesaAZ85238GRP-1647NAVIGATE-HMO
ENRENR-1082882026-08-16T15:15:42ZMERIAP.SMITH19971219UHC-18101-63null724-829-9741null4836 Mountain View DrEDEN PRAIRIEMN55359·GRP-1023NAVIGATE-HMO
ENRENR-1246692026-09-27T19:36:50ZGaryKBurns1967-01-03UHC-46900-65—+1 986 739 1788GARY.BURNS19@YAHOO.COM6344 DESERT SKY BLVDJacksonvilleFL··32289GRP-4186CORE-HMO
ENRENR-1357172026-02-01T12:37:58ZRussellV.King1964-12-11UHC-80971-11•••-••-0543787.258.0235NULL9139 WILLOW COURTFresnoCA93734GRP-5858CORE-HMO
ENRENR-1270202026-05-05T13:07:54ZCarolyn—Porter1995-04-15UHC-44477-87•••-••-12553662346CAROLYN.PORTER12@GMAIL.COM5268 Church Street··SeattleWashington98188GRP-3396CORE-HMO··
ENRENR-1173752026-06-17T09:42:57ZroyN.hansen19460814UHC-25734-43•••-••-3273247-390-1544—3041 Canyon RoadTampaFL··33618-4079GRP-8623CORE-HMO
ENRENR-1162942026-05-06T10:20:46ZBRANDON—MUNOZ1038-19-54UHC-58272-47•••-••-6662N/A—7696 Highland AvenueTEMPEAZ85265GRP-3223core-hmo
ENRENR-1240422026-07-01T18:12:01Zwaayne—phillips1985-01-07UHC-08722-05•••-••-526716203962170····8846 CANYON ROADOrlandofl32840GRP-2182MEDICARE-ADV-A
ENRENR-1302722026-03-09T16:24:08ZCharlesZNelson1939-03-01UHC6319422•••-••-4862(918) 505-7537CHARLES.NELSON67@AOL.COM1880 Pine DriveEden PrairieMN55394GRP-1054MEDICARE-ADV-B
ENRENR-1103082026-05-31T04:08:38Z CarolWCruz20051021UHC-06042-26•••-••-2470(948) 697-2303carol.cruz22@icloud.com4813 Washington StHOUSTONTX77065GRP-4297OPTIONS-PPO
ENRENR-1211442026-08-30T08:20:50ZJakeVRamirez··03/25/82UHC-31142-43•••-••-6434526-488-3584N/A4664 MEADOW LANEColumbusOH43236GRP-2512CHOICE-PLUS-PPO
ENRENR-1061072026-09-16T23:29:26ZChristina—Harper1979-01-10UHC-69850-79··•••-••-8918921-805-7425CHRISTINA.HARPER@HOTMAIL.COM6368 Valley View DrSacramentoCA95899GRP-2830MEDICARE-ADV-A
ENRENR-1377782026-01-25T18:04:11ZJOYCEH.PATEL19840211UHC-33239-79•••-••-2415925-770-9187—8677 Sage CourtDenverCO80252GRP-9433CHOICE-PLUS-PPO
ENRENR-1202712026-09-27T13:18:24ZDavdEDunn·1962-11-12UHC-26063-72•••-••-8431(966) 850-8506david.dunn@hotmail.com6942 DESERT SKY BOULEVARD·AtlantaGA30357GRP-8868SELECT-EPO
ENRENR-1004672026-04-03T01:16:48ZChristina O—Gray1982-06-23UHC-11437-60··•••-••-1986(211) 618-3763··christina.gray42@icloud.com8282 CEDAR LANECharlotteNC28285-4201GRP-1793OPTIONS-PPO
ENRENR-1101042026-03-03T00:08:13ZKathrynO··Holmes1953-10-08UHC-00116-60•••-••-6342(675) 312-3759kathryn.holmes@outlook.com2668 Willow Court··MesaAZ85216GRP-2902OPTIONS-PPO
ENR ENR-1323132026-03-17T08:59:46ZElizabethMJones02/25/96UHC-45211-18•••-••-16164076820738elizabeth.jones89@hotmail.com9833 OAK STLos AngelesCA90087GRP-6641MEDICARE-ADV-B
ENRENR-1090342026-04-18T06:46:28ZJASONJVAZQUEZ2003-02-28UHC-24325-80•••-••-9244234-319-5820jason.vazquez@gmail.com8252 BASELINE ROADMiamiFL33102GRP-4856CHOICE-PLUS-PPO
ENRENR-1104092026-03-23T22:36:46ZEMMAQ.PETERSON1998-02-13·UHC6545398•••-••-9462+1 239 516 2205··—404 Jefferson AvenueSacramentoCA-GRP-1284SELECT-EPO
ENRENR-1108652026-05-20T11:12:58Z valetinaAharris··1938-10-17UHC-24383-41•••-••-9224782-939-5478··-2755 Sunset BlvdGlendale··AZ85320·GRP-5731choice-plus-ppo
ENR ENR-1370472026-01-31T04:31:43Zmark Y—hicks04/12/1990UHC-61038-68•••-••-2444310-802-3624mark.hicks12@gmail.com2633 Hillcrest RoadAustinTexas78718GRP-9282NAVIGATE-HMO
ENRENR-1010732026-01-01T08:44:50ZEmliyUPerkins2001-10-04UHC-00203-22•••-••-2462(590) 476-4785EMILY.PERKINS67@AOL.COM1327 Cedar LaneFresnoCA·93715-7011GRP-9372CORE-HMO
ENRENR-1194902026-04-15T00:43:59ZKayla····Reed9/24/1962UHC-77914-24•••-••-0297+1 683 682 1294-7306 Mesa DrSAN ANTONIOTX78210GRP-1633SELECT-EPO
ENRENR-1125302026-03-18T07:58:46ZBradleyF.Fernandez08/11/46UHC-37198-75•••-••-3483605.497.4709bradley.fernandez@proton.me660 Maple AveSan AntonioTX78285GRP-3901··SELECT-EPO
ENRENR-1074992026-03-27T13:57:28Z·ANNA Q—CARPENTER1952-02-03uhc-11448-93N/A906-962-2013anna.carpenter@yahoo.com5759 River RoadJacksonvilleFLUNKNOWNGRP-5671··SELECT-EPO
ENRENR-1017692026-04-23T02:04:04ZJOSEBOLSON2003-05-28UHC-32021-76··•••-••-9177+1 976 827 0409jose.olson@gmail.com5299 Elm StreetJacksonvilleFlorida—GRP-9613NAVIGATE-HMO
ENRENR-1189092026-03-05T21:02:34ZHarris, DianaI—19670804UHC-73519-32•••-••-0525326-526-0649diana.harris@hotmail.com·4392 BroadwayFresnoCA93786GRP-9030MEDICARE-ADV-A
ENRENR-100617 2026-01-22T17:25:06Z·CherylRFernandez1964-05-13—•••-••-3565966.747.7100··cheryl.fernandez@icloud.com5415 Lake View RoadSan DiegoCA·92152GRP-2503MEDICARE-ADV-B
ENRENR-1161562026-01-20T10:06:18Zterry··elliott05/20/1980UHC-43012-07•••-••-7234+1 387 492 1011··terry.elliott71@icloud.com6936 WILLOW COURT·TEMPEAZ85260GRP-8058OPTIONS-PPO··
ENRENR-1418772026-04-24T17:02:57ZJOYCEFDUNN2005-01-27··UHC3390711•••-••-5556736-551-8835-··7165 Camelback RoadChandleraz85241GRP-1594·MEDICARE-ADV-A
ENRENR-1065932026-09-15T18:32:00ZDean, CarlV—Mar 28, 1972UHC-87857-89•••-••-215815768443760carl.dean91@outlook.com9585 Oak Street #839TampaFL33642GRP-3119CORE-HMO
ENRENR-1177962026-05-01T21:21:01ZAmanddaY.··McCoy1969-01-12UHC-80480-01•••-••-7207867-893-9961UNKNOWN428 Mesa DriveHoustonTX··77016GRP-7526OPTIONS-PPO
ENRENR-1133132026-09-15T04:59:42ZRachelCHughes1963-04-07UHC-54765-40•••-••-7429(849) 552-6274UNKNOWN6194 Willow Ct #973AUSTINTX78713GRP-2576CORE-HMO
ENR ENR-1074302026-08-16T05:26:09ZJAMESE.··RIVERA-UHC-90965-61•••-••-4727(689) 686-9435james.rivera96@icloud.com1090 SPRING ST Apt 4GlendaleAZ85375-4710GRP-2844MEDICARE-ADV-A
ENRENR-1119952026-09-09T21:58:10ZGRACEBALEXANDER1967-07-01UHC-60724-18—·284-269-3724grace.alexander81@outlook.com9454 Desert Sky BoulevardColumbusoh43279·GRP-3627MEDICARE-ADV-A
43,101 rows, page 140 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.464Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty