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-1377192026-03-02T18:36:52Zjacob—brown1947-10-11UHC-24152-73•••-••-54022892313117jacob.brown@aol.com4000 Mountain View DriveMINNEAPOLISMN·55484GRP-1886medicare-adv-a
ENRENR-1272122026-06-03T19:55:14ZDylanEMorrisoon·10/20/88UHC6505417N/A··662-649-5574DYLAN.MORRISON48@YAHOO.COM40 Apache BlvdTucsonAZ—GRP-5271MEDICARE-ADV-B
ENRENR-1190672026-04-26T15:19:09ZcrlosFperry05/14/03UHC-74538-98•••-••-9245+1 575 417 8557NULL872 Mesa DriveSeattleWA98149GRP-6420navigate-hmo
ENRENR-1166852026-07-01T18:03:59Zfrank—bennett2007-04-06··UHC9084874····+1 804 450 4782frank.bennett@icloud.com8560 Park PlMiamiFL33125·GRP-9518NAVIGATE-HMO··
ENRENR-122074 2026-06-18T02:48:50ZanaNsantiago1989-10-10UHC-27486-90•••-••-67616547889967ana.santiago16@hotmail.com7230 INDIAN SCHOOL ROADTEMPEAZ85276GRP-2089SELECT-EPO
ENRENR-1066402026-07-26T16:33:33ZJuanQ.Watkisn1982-10-03·UHC-15347-49•••-••-6445926.886.4586juan.watkins75@gmail.com9466 Lake View Rd·San AntonioTexas78277GRP-0426MEDICARE-ADV-B
ENRENR-1366972026-04-14T02:27:06ZSHIRLEYT.CARR19380916UHC-71867-23•••-••-6940729.227.2123·shirley.carr@proton.me281 Meadow Lane·FresnoCA93770GRP-6371MEDICARE-ADV-A
ENRENR-1212372026-06-21T11:20:22ZHeatherWParker1963-10-05UHC-09095-27•••-••-3483489-261-9691heather.parker@proton.me4494 Market StreetMinneapolisMNN/A·GRP-9858CORE-HMO
ENRENR-1215562026-06-17T08:45:49ZDanielle—Ross1997-05-10UHC-36430-99•••-••-7802(734) 837-4218DANIELLE.ROSS57@OUTLOOK.COM—NULLnull·NULLGRP-8070OPTIONS-PPO
ENRENR-1099172026-01-11T02:58:05ZJESS—RILEY03/12/47UHC-00691-96•••-••-7141(632) 246-5722···jessica.riley@outlook.com3593 Sunset BoulevardJacksonvilleFL32216GRP-4388CORE-HMO
ENRENR-1005332026-05-27T13:04:12ZABIGAIL—OLSON6/20/1976UHC-39205-83•••-••-2949857.875.4323abigail.olson57@hotmail.com-··-——GRP-5291CORE-HMO
ENRENR-1059082026-06-02T15:37:35ZHenry—Anderson1952-11-06UHC-79339-20•••-••-3639559-283-1672HENRY.ANDERSON36@AOL.COM5226 Washington StreetCharlotteNC28246GRP-4645CHOICE-PLUS-PPO
ENRENR-1306812026-10-10T14:32:31Z·MARTHAN·ELLIS19460314UHC-51149-93··•••-••-8258843-767-0606null3183 Grand AveSAN ANTONIOTX78256GRP-8564NAVIGATE-HMO
ENRENR-1335562026-01-03T15:13:33ZNataliePRyanApr 26, 1965UHC-61600-45—3735071279NULL6981 PINE DRIVELos AngelesCA90059GRP-8186MEDICARE-ADV-A
ENRENR-1297192026-02-07T04:51:36ZDiana—Watson1999-04-13UHC-75454-95•••-••-1858+1 210 230 3626—7178 Ocean AvenueTempe··AZ85295GRP-0180CHOICE-PLUS-PPO··
ENRENR-1053642026-05-27T16:00:41ZHannah—Weber1985-06-16UHC-28367-65•••-••-4879769.257.2297HANNAH.WEBER58@GMAIL.COM·1040 Ocean AvenueCharlottenc28222GRP-3532MEDICARE-ADV-A
ENRENR-1270602026-01-07T00:22:05Zlucia—vega1962-02-03UHC1809662•••-••-744713203449877lucia.vega77@gmail.com5744 SPRING STREETLas VegasNV89168GRP-9561SELECT-EPO
ENRENR-1107632026-06-09T08:38:52ZTIMOTHYLORTEGA11/14/95UHC-61342-15•••-••-56835465806924··—9713 Park PlaceLos AngelesCA90055GRP-3758OPTIONS-PPO
ENRENR-1295922026-04-16T21:42:24ZGeorge—Flores1/16/1959UHC4469388•••-••-84177002694839george.flores@hotmail.com8251 PINE DRIVE Apt 10JACKSONVILLEFlorida··32280GRP-0433MEDICARE-ADV-B
ENRENR-1047242026-08-24T12:47:19ZFatima—Turner4/21/1991UHC-62577-37•••-••-2911+1 904 876 7069FATIMA.TURNER57@GMAIL.COM·7573 Willow CtMesaAZ85277GRP-4657SELECT-EPO
ENRENR-1076022026-06-21T22:11:45ZNICHOLAS··EDWARDS03-06-1983··UHC-13752-66•••-••-7811N/A··NICHOLAS.EDWARDS56@PROTON.ME2706 BroadwayTucsonAZ·85724GRP-0427NAVIGATE-HMO
ENRENR-1282622026-03-31T09:49:55ZBOBBYSCASTRO06/02/1943UHC-60624-22•••-••-7273(306) 911-4821bobby.castro@outlook.com288 Ocean AvenueLos Angeles·CA90038GRP-7626SELECT-EPO
ENRENR-1321272026-09-11T23:18:53ZAmy—Coollins1970-09-28UHC-11297-50•••-••-9707(913) 565-0175NULL3899 Grand AveSeattleWA98176GRP-1690SELECT-EPO
ENRENR-1186002026-07-26T22:08:00ZAaronBKennedy12/26/1993·UHC-04502-15•••-••-22903364903606—·2310 Jefferson AvenueSEATTLEWA98163GRP-3522CORE-HMO
ENRENR-1224682026-08-10T11:13:24ZEugene··Vega1011-09-86UHC-77351-27•••-••-8861·768.396.8875eugene.vega@yahoo.com8100 Mesa DrTampaFL·33627-8644GRP-2306MEDICARE-ADV-B
ENRENR-1152942026-07-25T22:34:18ZStephenUBaker··09/13/1958··UHC-93089-76•••-••-1684744.405.0613·stephen.baker38@outlook.com4570 Willow CtPlanotx75012GRP-8123select-epo
ENRENR-1073812026-06-06T13:32:20ZMarianaL.··LaneSep 10, 1972UHC-44784-71—(451) 279-9408MARIANA.LANE@YAHOO.COM3982 CEDAR LNDENVER·CO—GRP-8659MEDICARE-ADV-B
ENRENR-1286492026-06-21T06:55:26ZBetty—Morales·1968-05-13UHC-75997-35•••-••-7652(427) 855-8517BETTY.MORALES79@OUTLOOK.COM532 Palm DriveSacramentoCalifornia95834GRP-3583OPTIONS-PPO
ENRENR-1255232026-07-17T04:47:16ZMATEOANICHOLS1963-10-10UHC-68007-33•••-••-2527385-258-9739MATEO.NICHOLS@OUTLOOK.COM··NULLUNKNOWN—GRP-4036CORE-HMO
ENRENR-1080052026-10-04T23:41:53ZCatherineETaylor1965-12-12UHC-44781-53•••-••-9548(828) 408-9875catherine.taylor@aol.com··7245 Hillcrest RdChandler··Arizona85253·GRP-5964NAVIGATE-HMO
ENRENR-1423182026-03-11T10:05:49ZJudyDChen11/03/1999UHC-63983-74—-judy.chen40@proton.me6498 Oak StreetMesaAZ85202GRP-0455NAVIGATE-HMO
ENRENR-1205462026-04-03T14:27:11ZSTEVEN—RUIZ··1949-07-10UHC-52473-73•••-••-0972(727) 246-6796·STEVEN.RUIZ73@OUTLOOK.COM6429 Sage Ct··ChandlerArizona85280GRP-0591CHOICE-PLUS-PPO
ENRENR-1277332026-05-21T08:47:11ZBobby—Park1947-07-20UHC-74639-88•••-••-08002472998501···bobby.park@hotmail.com2144 Mountain View DrDallasTX75214GRP-3640NAVIGATE-HMO
ENRENR-1166692026-07-07T01:47:29Zdorothy—hanson19581209UHC-56345-74•••-••-1245(624) 811-6866null4903 MEADOW LNEDEN PRAIRIEMN55335GRP-7612·medicare-adv-b
ENRENR-1231602026-08-22T05:16:44ZSteveC.Carpenter02/04/73UHC-76604-67··null463-282-0237null1248 Union StreetSacramentoCAUNKNOWNGRP-2852CORE-HMO
ENRENR-1209262026-03-12T09:21:36ZMeganL·Le02/10/1971UHC-32794-78—·(794) 277-3498megan.le@aol.com6796 RIDGE RDTampaFL33685GRP-6622MEDICARE-ADV-B
ENRENR-1168292026-01-25T12:26:00ZSentiago A—Wong1969-01-19·UHC-35346-77•••-••-7978-SANTIAGO.WONG@YAHOO.COM4049 Washington StreetHOUSTONTX—GRP-2545SELECT-EPO
ENRENR-1259592026-04-14T01:27:24ZMorgan, Mari——2007-02-11UHC-98499-33•••-••-2549—null6055 Willow CtMesaAZ85273GRP-9744SELECT-EPO
ENRENR-1395342026-08-02T06:12:09ZLINDAK.·WATSON2005-10-21UHC-57475-22•••-••-5674·380-896-1733—3703 Park PlaceMINNEAPOLISMN55493GRP-4340NAVIGATE-HMO
ENRENR-102258 2026-05-30T20:53:39ZJUAN—·MILLS1946-12-18UHC-66910-63•••-••-0270392.402.6843JUAN.MILLS21@YAHOO.COM·4066 Union StMesaAZ·85231GRP-9855MEDICARE-ADV-A
ENRENR-1288142026-02-16T00:39:41ZDAVIDVFORD1991-03-11UHC-92766-36•••-••-6695(762) 817-0414UNKNOWN9634 Baseline RdColumbusOhioUNKNOWNGRP-3876MEDICARE-ADV-A··
ENRENR-1164362026-03-30T08:35:11ZMegan—Rivera1959-08-21UHC-06599-45—13298667528megan.rivera3@outlook.com1707 BASELINE ROADMesaAZ85204GRP-0272··NAVIGATE-HMO
ENRENR-1137142026-02-16T11:34:53ZJaniceHCrawford05/07/1951UHC-71490-35N/A9077934932JANICE.CRAWFORD49@GMAIL.COM3966 Camelback RdEden PrairieMN55386·GRP-2992CHOICE-PLUS-PPO
ENRENR-1270962026-01-02T17:14:35ZWei—Stephens1952-07-07UHC9019391•••-••-8038(444) 244-2440null7159 Cedar LaneOrlandoFL·32877GRP-9712MEDICARE-ADV-B
ENRENR-1079372026-01-15T12:44:20Z MASONM··KING1959-80-04UHC-51740-50•••-••-0836203-703-2899MASON.KING@YAHOO.COM3044 RIDGE ROADEden PrairieMN55356GRP-5139MEDICARE-ADV-B
ENRENR-1373022026-06-11T01:31:21Z Hannah—Taylor9/14/1956UHC-49582-39·N/A+1 474 853 8894··UNKNOWN6227 Palm DriveSacramentoCA95872GRP-5565OPTIONS-PPO
ENRENR-1412572026-04-26T11:39:54ZWeiSCooper19531025UHC-84241-56•••-••-88486088883wei.cooper@aol.com5751 River RdChandler·Arizona85261-9280GRP-3458CHOICE-PLUS-PPO
ENRENR-1383342026-02-25T04:15:21ZThomas—Jimenez1993-09-18UHC-17040-83•••-••-6440318-703-2925thomas.jimenez@gmail.com7889 Forest AveGilbertAZ85267GRP-5640MEDICARE-ADV-B
ENRENR-1376362026-07-01T09:04:35ZEmmaX.Wang·19670528UHC-33419-22•••-••-1559(410) 622-8015emma.wang@proton.me5672 Sunset BlvdMiamiFL33165-2688GRP-2058choice-plus-ppo
ENRENR-1296062026-05-09T03:00:32Z·BRUCEU.CLARK1990-05-02UHC-63878-37•••-••-88878644093656··BRUCE.CLARK25@OUTLOOK.COM2717 Ocean AveHoustonTX77077·GRP-5532MEDICARE-ADV-A
43,101 rows, page 225 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:40.603Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty