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-1131252026-06-26T04:26:00ZDouglesR.·SchultzJul 19, 1974UHC-55063-31•••-••-5297772-317-0773····3366 Elm StreetMiamiFL33181··GRP-7860··OPTIONS-PPO
ENRENR-1415972026-08-30T09:24:15ZKATHRYNV.BLACK1962-06-13UHC-47024-45•••-••-4051972-235-9380NULL3202 River Rd··NashvilleTN37261GRP-8366NAVIGATE-HMO
ENRENR-1278492026-07-08T07:56:27ZCatherine—Anderson1986-06-28null•••-••-2295630-715-9126catherine.anderson@yahoo.com6272 Valley View Dr #827Glendaleaz85355GRP-0460medicare-adv-a
ENRENR-1360822026-09-16T21:26:57ZFlores, Albert——1987-06-26UHC-98167-09•••-••-7162466-495-8764albert.flores@aol.com·7327 PALM DRIVEDENVERCO··80275GRP-3145MEDICARE-ADV-B
ENRENR-1006162026-08-24T23:57:57ZBennett, MeiQ—1978-06-19UHC-99084-44•••-••-154512346979705mei.bennett@yahoo.com3424 Mountain View Dr·Las VegasNV89132GRP-8342OPTIONS-PPO
ENRENR-1009322026-01-26T09:44:11ZSusan··NBennett07/12/1951UHC-83289-11UNKNOWN9894362311SUSAN.BENNETT38@AOL.COM8267 Jefferson AvenueDenverCO80203·GRP-6839SELECT-EPO
ENRENR-1051182026-06-05T17:58:56ZDANIELLET.··WHITE1999-07-17UHC-49036-24··UNKNOWN(969) 919-0327null5573 Bayshore DrMinneapolisMN55470··GRP-4104SELECT-EPO
ENRENR-1140092026-10-12T00:54:56ZGraceHRoss1985-12-22UHC-85981-15··•••-••-25492152747706grace.ross@icloud.com5740 Sunset BoulevardEden PrairieMN55308GRP-9022MEDICARE-ADV-A
ENRENR-1407162026-07-20T08:42:09ZpamelaX.rios1952-02-22UHC-95871-52··•••-••-0829N/APAMELA.RIOS45@YAHOO.COM1936 Elm StOrlandoFL32807GRP-8845CHOICE-PLUS-PPO
ENRENR-1224412026-09-13T13:07:50ZThomas—·FosterMay 26, 1999UHC-99921-94•••-••-1752(387) 744-4007-369 Ocean AveDenverColorado80260-3940GRP-6029MEDICARE-ADV-B
ENRENR-1241242026-02-04T12:25:52ZSCOTT—GRIFFIN1995-06-26UHC-28293-93•••-••-3674(962) 358-8268N/A1594 BroadwayDALLASTX75240GRP-7480MEDICARE-ADV-B
ENR ENR-1149672026-01-31T13:26:52ZWilliamson, Adam——21-08-1951UHC-78870-26•••-••-1356nullN/A2585 HARBOR BOULEVARDHoustonTX-·GRP-6135MEDICARE-ADV-A
ENR ENR-1375342026-10-04T06:47:32ZJensen, Dylan··——24-11-1967UHC-19747-59•••-••-73225937192670dylan.jensen6@outlook.com9643 Mountain View Dr··GLENDALEAZ85311GRP-1424CORE-HMO
ENRENR-108816 2026-06-09T21:40:28ZMarkXHart1941-06-18UHC-12044-87•••-••-8616(649) 562-9877MARK.HART@AOL.COM8242 Cedar LaneDenverCO80219-7352GRP-2386MEDICARE-ADV-B
ENRENR-1338672026-09-21T14:31:24ZRalphE.Grant1988-01-18UHC-13840-17•••-••-4025326-407-0221ralph.grant88@hotmail.com5030 Spring St #708AtlantaGA··30358GRP-8947SELECT-EPO
ENRENR-1184542026-02-25T17:33:35ZKaylaP.Patel1964-09-08UHC-00656-58•••-••-940514189011716··kayla.patel@proton.me4595 Bayshore DriveTampafl33672GRP-8703·choice-plus-ppo
ENRENR-1359382026-03-17T08:45:57Zlias··washington1989-09-12UHC6232919N/A976-781-6090·lisa.washington@outlook.com6189 Union StGlendale··AZ85331-3719GRP-6152OPTIONS-PPO
ENRENR-1105532026-08-25T11:25:45ZSamanthaDNunez28-02-1990UHC-31120-14null·(536) 547-4717samantha.nunez@icloud.com·3542 Hillcrest RdLos AngelesCA·90035GRP-8102SELECT-EPO··
ENRENR-1223612026-08-26T14:51:54ZRachel—Fisher1949-12-18UHC-38689-22•••-••-0775957-782-6761N/A3418 Palm DrSeattleWA98120GRP-6190MEDICARE-ADV-A
ENRENR-1221012026-01-20T18:21:41ZMelissaMDaniels1998-01-01UHC-79454-55•••-••-09144186937435melissa.daniels@proton.me7050 Lincoln WayLos AngelesCA90070GRP-6040MEDICARE-ADV-B
ENRENR-1403232026-04-13T06:30:10Z·AliceTChapmanOct 10, 1984UHC-31500-76•••-••-54196632395alice.chapman47@icloud.com101 PALM DRTucsonAZ85751GRP-4538MEDICARE-ADV-B
ENR ENR-1237302026-01-27T12:13:56ZJoshuaSChapman·1975-07-02UHC-13597-78•••-••-7409(888) 697-3592joshua.chapman@hotmail.com6059 Main StreetFresno·CA—GRP-3104MEDICARE-ADV-B
ENRENR-1397332026-10-09T23:49:46ZLYNCHGPAUL2005-03-22UHC-76821-72··•••-••-131715903439107PAUL.LYNCH27@PROTON.ME6421 PARK PLLOS ANGELESCA90054-2123GRP-7983·choice-plus-ppo
ENRENR-1204022026-07-07T02:22:12ZSOPHIA—YANG1966-08-04UHC0088959UNKNOWN13629007634sophia.yang13@proton.me4788 Union St··GLENDALEAZ85328GRP-3959SELECT-EPO··
ENRENR-1328482026-07-24T06:15:22Z·Brandon R.—Owens1960-05-05UHC-82663-44•••-••-270213977177912brandon.owens@icloud.com8315 Desert Sky Blvd·PhoenixAZ85091GRP-1382·MEDICARE-ADV-A
ENRENR-1119372026-02-03T22:55:04ZTerryB.Fuller9/6/1948UHC3266333•••-••-5341790.962.0221terry.fuller55@proton.me6172 CANYON ROADATLANTAGA30341GRP-3988OPTIONS-PPO
ENR ENR-1198622026-05-07T22:20:43Z———1970-03-25UHC-26068-29•••-••-6214472-517-5080N/A6252 VALLEY VIEW DRMinneapolisMN55448GRP-2868NAVIGATE-HMO
ENRENR-1363122026-01-10T04:22:39Z·billyUhenderson1995-12-27UHC-53069-38•••-••-8434(612) 660-3099BILLY.HENDERSON62@YAHOO.COM1253 Lake View RoadEden PrairieMN55342GRP-5473MEDICARE-ADV-A
ENRENR-1125012026-06-10T18:20:56ZADAM··—CUNNINGHAM1993-04-11UHC-92181-19•••-••-0556(212) 401-0773·adam.cunningham@aol.com7672 Sunset BlvdTampaFlorida33638GRP-3197MEDICARE-ADV-B
ENRENR-1005812026-08-17T16:01:30Z ·Warren, Dennis——2007-05-11UHC-29646-24•••-••-8135+1 735 239 6322dennis.warren88@gmail.com4604 Washington StEden PrairieMN55305GRP-9724OPTIONS-PPO
ENRENR-1210922026-06-15T20:24:38ZJUDITH··—HARRIS·1958-02-09UHC-75418-18•••-••-309113459433214judith.harris1@yahoo.com8761 Oak StreetHoustonTX77064GRP-7604NAVIGATE-HMO
ENRENR-1376472026-07-21T14:54:01ZSusan—Hamilton09-12-1983UHC-49973-47•••-••-2250(968) 346-9728NULL4288 Church StSacramento··CA95810GRP-7961CHOICE-PLUS-PPO
ENRENR-1354902026-04-21T09:35:53ZBryanJ.Castro1947-12-01UHC-32542-57•••-••-7227N/A·bryan.castro@icloud.com3934 Central AvenueDallasTX75200GRP-4080NAVIGATE-HMO
ENRENR-1033192026-04-19T03:19:41ZJohnston, Mary——6/19/1950UHC-79819-75•••-••-109312632233036MARY.JOHNSTON@HOTMAIL.COM612 Desert Sky BlvdNashvilleTN37291GRP-8443SELECT-EPO
ENRENR-1166192026-07-08T10:56:56ZCHARLOTTE—FOX··10-03-1978UHC-60940-57•••-••-9867(433) 754-1715null657 JEFFERSON AVESAN ANTONIOTX78201GRP-3881SELECT-EPO
ENRENR-1377522026-08-08T06:33:33ZAnna····Bowman2007-03-24UHC-89187-82•••-••-1275529.576.2468··anna.bowman@yahoo.com3232 SPRING STREETOrlandoFL32810GRP-0406OPTIONS-PPO
ENRENR-1038692026-03-09T12:20:56ZJENNIFER—WOOD3/5/1995··UHC-28217-72null340-956-0955··-84 Union StreetSan AntonioTX78269GRP-0183SELECT-EPO
ENRENR-1173182026-08-29T12:55:40ZRose, Melissa——1954-07-10··UHC-51916-72•••-••-19198748714040MELISSA.ROSE86@ICLOUD.COM6028 MAPLE AVENUEPhoenixaz85084GRP-4246OPTIONS-PPO
ENRENR-1361562026-05-03T05:21:39ZVALENTINA—KELLY·08/01/1949UHC-36802-31•••-••-23052294031985VALENTINA.KELLY@GMAIL.COM4990 CHURCH STAtlantaGeorgia30324GRP-5558CHOICE-PLUS-PPO
ENRENR-1042832026-06-20T06:59:20ZDIEGO U—WILLIS19761204UHC-87330-63•••-••-4979(399) 885-3867DIEGO.WILLIS44@PROTON.ME5065 Ocean AvenueChandler··AZ85274GRP-1768CHOICE-PLUS-PPO
ENRENR-1052712026-08-09T23:07:10ZKyleESimpsonApr 15, 2007UHC-10810-94•••-••-95432251125NULL··621 Palm DrivePlanoTX·75092GRP-2294OPTIONS-PPO
ENRENR-1262452026-03-10T09:08:22ZPAMELAIFERNANDEZ2001-02-18UHC-96258-35•••-••-59364714737524··pamela.fernandez@outlook.com6090 MOUNTAIN VIEW DR··MiamiFL33175GRP-9286OPTIONS-PPO
ENRENR-1030372026-04-27T21:36:16Zhiroshi—lawrence10-09-2005UHC7553502•••-••-1888907-559-9530HIROSHI.LAWRENCE14@HOTMAIL.COM8338 Cedar LnTucsonAZ85797GRP-6318MEDICARE-ADV-B
ENRENR-1014352026-05-22T03:00:01ZKathrynOLi2001-05-09UHC-12085-61UNKNOWN15052534864-5526 Central AvenueLos AngelesCA—GRP-3805NAVIGATE-HMO
ENRENR-1358912026-01-26T19:39:12ZMadisonN.··Reyes··1946-04-18UHC-15905-97•••-••-873613839294814madison.reyes7@aol.com6130 ELM STREET·OrlandoFL32897-5236GRP-1492MEDICARE-ADV-A
ENRENR-115699 2026-04-05T10:34:06ZAustin—Bryant2006-12-17UHC-63037-48UNKNOWN2946316629NULL6850 SPRING STOrlandoFL32899GRP-3815CHOICE-PLUS-PPO
ENRENR-1019332026-02-13T01:29:06Z·Shirley—Harrrison1973-07-10·UHC-40065-75•••-••-1649825-497-4022—5839 GRAND AVENUENashville·TNNULLGRP-1335CORE-HMO
ENRENR-1257132026-01-21T22:24:22ZMarcusKBanks1986-08-14UHC8223418•••-••-2842(652) 293-1767marcus.banks17@icloud.com6292 Mesa DrPlanoTX75055-4366GRP-9522SELECT-EPO
ENRENR-1161242026-06-29T16:10:58ZRoss, VickyO.····16-06-1978UHC-40023-82•••-••-9640N/A—8429 CAMELBACK RDDallas··TX75251GRP-5900MEDICARE-ADV-A
ENRENR-1023132026-09-29T04:42:26ZNicholas—Wilson12-09-1946UHC-79475-21•••-••-8715774-878-4998·null6712 LINCOLN WAYFresno··CA93747GRP-5317OPTIONS-PPO
43,101 rows, page 265 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.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty