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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-62918 2026-09-20T14:36:54Zken····mcdonald20021223N/AUNKNOWNUNKNOWNkenneth.mcdonald84@proton.me1501 RIVER ROADTampaFL33610—UNKNOWN
TPATPA-586792026-08-21T07:57:45ZRobert—Webb1999-07-16N/A•••-••-9407297-799-9298—NULLnull—····N/AMEDICARE-ADV-B··
TPATPA-576632026-04-27T06:23:48ZTyler—Hughse02/21/1985null•••-••-0388(378) 307-0468N/A3740 WILLOW COURT #114San AntonioTX78252GRP-1227NULL
TPATPA-523042026-02-18T21:55:33Zrandy··nicholsSep 25, 2004——-null3698 Forest AveScottsdaleAZ85243N/ASELECT-EPO
TPATPA-583772026-08-22T11:48:11Zamanda—campbellAug 28, 1968null•••-••-5992——5649 CAMELBACK ROADMESAArizona85295UNKNOWN-
TPATPA-553272026-06-27T22:23:41ZHanson, Hirohsi——12/11/39—N/A—HIROSHI.HANSON@ICLOUD.COM6791 BASELINE ROADMinneapolisMN55425—N/A
TPATPA-528542026-03-08T03:46:53ZCarlos—Santiago10/23/1977——15372772702UNKNOWN2768 Ocean AvenueEden PrairieMN55373NULLnull
TPATPA-524072026-02-11T18:33:04Z EILY—LOPEZ1943-12-14—NULL······-6843 Camelback RdChandlerAZ85280GRP-3410····
TPATPA-510242026-07-05T18:23:29ZEspinoza, Edward——1949-08-10—N/A2694871692edward.espinoza9@proton.me2750 Valley View DrSan AntonioTX78297—UNKNOWN
TPATPA-613442026-04-03T15:58:24ZBETTY··—WILLIS7/17/1958UHC-87716-71—····N/A2735 CEDAR LANEHoustonTX··77086GRP-6346MEDICARE-ADV-B
TPATPA-549942026-08-17T16:19:44ZMaria—Gray1994-12-02NULL··—·NULL7226 Lincoln WayCharlotteNC28208GRP-3657····
TPATPA-540372026-05-20T04:36:03ZCYNTHIA—ELLIOTT09/02/07nullnull—UNKNOWN9248 Sage CtSAN ANTONIOTX78200GRP-2030N/A
TPATPA-612702026-02-22T17:45:29ZEMILY—·WHITE1942-09-14NULL··•••-••-0761—-208 Apache BlvdTempeAZ85295·NULLN/A
TPATPA-608572026-05-07T16:42:35ZJerry—Perkins1960-02-18—•••-••-0692·UNKNOWNjerry.perkins20@outlook.com··1106 Mesa DriveNashvilleTN37212—N/A
TPATPA-618922026-04-27T00:40:53ZFatima··—OliverJan 25, 1962NULL•••-••-4431N/ANULL3457 Harbor BlvdMiamiFL··33104—null
TPA TPA-626202026-09-26T14:21:13ZNATHANKBRYANNT·Dec 5, 1962——null—N/A——-··UNKNOWNnull
TPATPA-500932026-10-16T17:10:56ZJessica··ArmstrongSep 14, 1962··—•••-••-8393+1 673 547 8980····1123 Bayshore DrivePlanoTX·75025GRP-0374MEDICARE-ADV-A
TPATPA-583832026-04-15T08:55:38ZAisha—Morrison2006-04-13NULL··•••-••-4713UNKNOWNNULL3540 Maple AveHOUSTONTX···N/A——
TPATPA-546932026-07-22T23:50:07ZGREGORYJMENDEZ05/01/1948·UNKNOWN•••-••-372615786283318·-N/AUNKNOWNnullUNKNOWNnullUNKNOWN
TPATPA-519272026-05-05T10:36:02ZJohn—Morris12/27/58--—N/A5012 Ridge RoadMiamiFlorida33106··-····
TPA TPA-643292026-07-26T04:38:46ZCAROLYN—CRAWFORD·7/1/1964UNKNOWN•••-••-3320—null9783 MARKET STGlendaleAZ85377—-
TPATPA-518982026-01-31T15:28:48ZYuki—Carter09/25/1955UHC-07808-75N/A524-979-7747N/A4834 Central Avenue··San DiegoCA92122nullnull
TPATPA-603072026-03-05T20:10:18ZAaron—Dominguez1997-03-20NULL—6032881044AARON.DOMINGUEZ@GMAIL.COM3166 BASELINE ROADLAS VEGASNV89147-4973GRP-4402—
TPATPA-597462026-04-07T17:02:49ZJanet—Knight1956-03-07nullNULL——····N/AN/A—GRP-3746CHOICE-PLUS-PPO
TPATPA-519142026-07-15T21:02:13ZGregory—Nichols1965-12-14—•••-••-67657366872442gregory.nichols@proton.me6469 CENTRAL AVEMINNEAPOLISMN55464-—
TPATPA-541572026-08-12T11:10:54ZValdez, Donald——24-07-1994—UNKNOWN784-926-0706UNKNOWN—-null—GRP-2119NULL
TPATPA-520732026-01-03T11:21:18Z Alvarez, Steven··—01/26/80--9823305099····6128 OAK STREETGILBERTAZ85277GRP-1650MEDICARE-ADV-A
TPATPA-554012026-04-15T17:16:19ZJULIA—ESPINOZA19700604UHC-84983-20····N/A—6137 DESERT SKY BOULEVARDChandlerAZ—null—
TPATPA-586832026-04-29T10:30:49ZScott—Burke2004-01-06UNKNOWN•••-••-6023—-1246 Oak St·OrlandoFL32872GRP-2092NULL
TPATPA-628172026-10-17T21:12:23ZGeorge—Berry··1987-02-04NULL····948.219.1848—-NULL—-null—
TPATPA-616362026-08-17T19:29:07ZJoyce—Perez··1977-06-24UHC-21788-68—5748435293—9017 Washington StDallasTX75245-3121NULLMEDICARE-ADV-A
TPATPA-635662026-04-01T01:08:59ZFATIMA—SCHMIDT1595-10-17—•••-••-0358UNKNOWNNULL6559 HIGHLAND AVELos AngelesCA··90068UNKNOWNN/A
TPATPA-609292026-06-25T15:09:14ZFatima—Ford1971-04-08nullN/AN/A··FATIMA.FORD31@PROTON.ME—null-N/AnullOPTIONS-PPO
TPATPA-559612026-04-05T18:01:59ZIsabellaUPayne19900609N/A•••-••-6688-isabella.payne16@outlook.com2458 Forest AvenueHoustonTX77019UNKNOWN·N/A
TPATPA-599302026-02-09T13:06:39ZRyan, Julie····—2000-03-26··•••-••-6201UNKNOWNN/A9125 Bayshore DriveGilbertAZ85295N/Anull
TPATPA-641552026-04-15T07:58:56ZcoxI.edward9174-10-04N/A—913.648.9708NULL3714 Meadow LaneTUCSONAZ85712GRP-0403·MEDICARE-ADV-B
TPA TPA-582822026-08-08T23:53:47ZCatherine··Smith1969-04-03·UHC-24248-33-—·nullN/ANULL—nullGRP-4431OPTIONS-PPO
TPATPA-565012026-09-15T07:42:49ZJUAN··—LOPEZ10/05/68UHC-13601-93—(279) 576-3102N/A8639 Highland AveColumbusOH43244NULLMEDICARE-ADV-A
TPATPA-628742026-07-20T07:44:46ZSTEVEN—HENDERSON··19950516··-——····3009 River RoadSan AntonioTX78260N/A—
TPATPA-612742026-09-23T08:20:50ZPerez, Cheryl····—03-04-1990UNKNOWN•••-••-6916NULLCHERYL.PEREZ@OUTLOOK.COM260 Lake View RoadSAN DIEGOCA·92101——
TPATPA-591982026-05-18T11:49:34ZDENISE—LUCAS06/10/97—NULLN/A—1042 Sunset BoulevardTampaFL33607—MEDICARE-ADV-A
TPATPA-549342026-01-12T08:29:59ZBetty—Wood04/12/1950—UNKNOWN(558) 980-6735N/A7551 LINCOLN WAYSeattle·WA98176null·CORE-HMO
TPATPA-618512026-01-26T09:29:06ZCarolyn—Jimenez1945-05-14UHC-56314-20•••-••-5235nullN/Anull-·NULL-—UNKNOWN
TPATPA-631432026-01-19T10:05:34ZAHMEDW.CAMPBELL1939-09-19—null····-—NULL·UNKNOWNnull··UNKNOWN—
TPATPA-585152026-05-12T05:36:20ZGABRIEL—DIXON2007-08-13—null575-221-3244null····NULL——NULL—
TPATPA-501482026-09-30T17:18:02ZAISHA—HENRY2005-07-22UHC5604479•••-••-4194246.961.5696··—2707 Market St··San AntonioTX78268——
TPATPA-564872026-05-19T18:32:38ZSantos, Keith——12/12/1994····null(923) 656-5752—153 RIDGE ROADChandlerArizonaNULL—UNKNOWN
TPATPA-580722026-02-27T08:30:29ZLane, Lawrence——2006-08-09—-9502398303lawrence.lane@icloud.com2237 CAMELBACK RD··Los AngelesCA90083null—
TPATPA-527992026-02-09T09:44:38ZMegan—Santiago··1948-05-15UHC-27734-09•••-••-968918463227078null4521 Ridge RdGLENDALEAZ85384GRP-7968CHOICE-PLUS-PPO··
TPATPA-620102026-08-12T00:45:05ZALICE—·PALMER07/18/1968—-602-256-7270—2542 Palm DriveMinneapolis·mn55402··GRP-0984—
14,474 rows, page 35 of 290PreviousNext

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:37.740Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty