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-567572026-06-04T00:57:17ZAguilar, Walter——2001-02-15N/AN/A-··—2327 Ridge RdDallasTX75247-0278—-
TPATPA-593642026-09-22T21:02:05ZJACQUELINE··BERRY3/17/1949-•••-••-37204818094928—1043 Ocean AveJacksonville·FL32201·GRP-7677-
TPATPA-513482026-04-11T11:19:58ZPat—Carter05-02-1994N/A•••-••-9292UNKNOWN··—6994 Cedar LaneMiamiFL33135N/A-··
TPATPA-571782026-03-23T11:33:26ZGabriel—Estrada19890312····N/A444.431.3872————N/A—N/A
TPATPA-607752026-07-18T03:04:21ZGarza, Melissa——1955-09-11—•••-••-3746-null8234 Lincoln WayNashvilleTN37217-N/A
TPATPA-555672026-06-06T05:49:46Z Vasquez, GeorgeP.—2008-11-14-—nullNULL7870 River Road Apt 36PLANOTX75085··null-
TPATPA-553472026-02-07T08:17:03Z·Jeffrey—Shaw1971-09-20————403 River Rd #561Los Angeles··CA90098GRP-7544SELECT-EPO
TPATPA-555422026-01-26T15:54:51ZLISA—MYERS1975-08-10NULL———····-UNKNOWNNULLGRP-9741NAVIGATE-HMO
TPATPA-565612026-03-21T13:46:55ZWei—Romero1986-01-19—-222-858-4516NULL8922 Willow Court Apt 12SCOTTSDALEAZ——N/A
TPATPA-605242026-07-01T07:51:38ZSandra—Santiago1951-04-21NULL—nullnull-NULLnull—GRP-7352medicare-adv-b
TPATPA-611262026-07-16T08:43:09ZLopez—Jesse1960-09-09··•••-••-6183—-3141 APACHE BOULEVARDLAS VEGASNV89123-1332nullNULL
TPATPA-580652026-05-20T23:07:39Z·timothy··wagner·1985-04-05N/A•••-••-08896825723960—·9724 Bayshore DriveColumbusOhio43283GRP-3075—
TPATPA-507092026-07-18T03:17:07ZMELISSA—VASQUEZ··1998-05-26—-N/Amelissa.vasquez@icloud.com3165 LINCOLN WAYDallasTX75287GRP-8553··MEDICARE-ADV-A
TPATPA-639902026-02-16T04:13:56ZJASON—BAILEY02/16/38UNKNOWN—N/A—3807 Sage CourtSeattle··Washington98116-null
TPATPA-502052026-08-10T08:58:50ZHiroshi—Ortega1979-11-11-··774-860-8302hiroshi.ortega@icloud.com188 ELM STREETAUSTINTX·78799-·MEDICARE-ADV-B
TPATPA-635232026-08-18T03:56:18ZFrank··—Miller1965-03-06UHC-04100-71•••-••-62636207845885—9039 Park PlEden PrairieMN55346GRP-5848—
TPATPA-521572026-05-25T10:29:28ZMcDonald, Amy——1991-08-25nullNULL(791) 784-7622NULL3775 Valley View DrSacramentoCalifornia95849—MEDICARE-ADV-B
TPATPA-602542026-03-08T15:05:36Zelizabeth—larson12-06-1955·uhc-23618-99—N/A—null-—-GRP-0437MEDICARE-ADV-B
TPATPA-576822026-09-21T20:03:15ZEvelyn—Jensen28-05-2005N/Anull··—-9886 SAGE CTPHOENIXArizona85052N/A—
TPATPA-52908 2026-06-01T03:43:23ZBrendaP.Bradley1954-10-17UNKNOWN•••-••-3269616-752-4312—5192 Meadow LaneJacksonville··FL32242UNKNOWN-
TPATPA-527902026-08-03T09:04:52Zalbert—·owensMar 1, 1942—NULLN/A—367 Central AvenueCharlotteNC28236··GRP-9667null
TPATPA-635812026-09-23T04:13:54ZJesse—Bryant07/25/48—UNKNOWNUNKNOWNNULL9551 Sunset BoulevardLos AngelesCA90089-6698GRP-3212N/A
TPATPA-525272026-05-19T06:07:50ZWest, Sharon——1948-11-11—NULL—sharon.west@yahoo.com773 Hillcrest RdOrlandoFL32852—CORE-HMO
TPATPA-510742026-10-13T07:49:59ZANTHONYJ.CHEN1999-12-01-—null—8278 Desert Sky BoulevardAustin·TX78749GRP-3722··
TPATPA-566012026-08-15T10:38:08Z Laura—Watkins1961-02-15—•••-••-7143nullNULL2762 Willow CourtMesaaz85231-1194GRP-4455—
TPATPA-576912026-02-01T17:02:27ZDYLAN—·HARVEY1976-03-10NULL-N/ANULL5090 Ridge RdPHOENIXAZ85057-0932N/A—
TPATPA-532602026-04-14T10:57:08ZGloria—Fowler1964-09-07N/A-655-858-8140null6908 SAGE COURTTUCSONArizona85753UNKNOWN·N/A
TPATPA-601152026-03-19T21:46:23ZKyle····Smith1983-12-24—•••-••-4493634-435-7057·nullNULLN/A-nullN/A—
TPATPA-629272026-06-18T18:46:36ZPAMELA··RUSSELL1939-08-22-•••-••-0501——N/AN/A——GRP-2085OPTIONS-PPO
TPATPA-50556 2026-09-18T22:25:25ZGeorge—Medina1973-04-16-—N/A··UNKNOWN2311 Sunset BlvdSeattleWA98192NULL—
TPATPA-57381 2026-09-06T15:31:18ZBRANDON—MORRIS1961-09-27UNKNOWN•••-••-2377(582) 963-1175brandon.morris50@hotmail.com3009 MAPLE AVENUETampaFL33626GRP-3120—
TPATPA-63854 2026-03-02T10:08:09Zalice—snyder6/5/1981—N/A514-910-7994—5736 MARKET STREETSCOTTSDALEAZ85203nullnull
TPATPA-522032026-01-11T14:08:09ZTimothy—Lopez1946-01-15····•••-••-5496(513) 672-6619UNKNOWNNULL··-—NULL——
TPATPA-578732026-04-11T12:40:04ZSean··—Castro1973-07-25NULL•••-••-2743—-9846 Bayshore Dr·TampaFL33672·GRP-7828·CHOICE-PLUS-PPO
TPATPA-545212026-08-17T13:40:23ZPatricia····Hayes··1993-05-27—•••-••-8047NULLNULL6331 Hillcrest RoadSacramentoCA95813··null—
TPATPA-616842026-06-28T22:22:09ZJoan—Morales1945-05-09NULL———2787 UNION ST·JACKSONVILLEFlorida32218UNKNOWN—
TPATPA-597502026-06-20T04:38:07ZPAT—MASONApr 24, 1954nullNULLUNKNOWNN/A6084 BASELINE RD·MesaAZ85221GRP-2430—
TPATPA-641202026-05-16T15:29:53ZSamuel······Kim··22-07-1969··—624-644-7393N/A3839 Park PlColumbusOH43216··NULL
TPATPA-535182026-06-30T14:13:25ZRyan—Howell25-04-1982N/AN/A+1 672 548 0855ryan.howell@hotmail.com4377 Forest Ave #571MiamiFL33176-1169UNKNOWNCHOICE-PLUS-PPO
TPATPA-515522026-04-13T13:27:23ZPHILIPKGEORGE1952-09-16UHC-01483-44•••-••-2235(764) 481-5635—2537 Sage CourtJacksonvilleFL32223GRP-0596MEDICARE-ADV-A··
TPATPA-642642026-01-03T09:45:17ZJudith—Sanddoval··1983-09-26—null--·5058 Lake View Road·CharlotteNC28204-1361UNKNOWNMEDICARE-ADV-B
TPATPA-632072026-01-19T13:30:57Z·Barrbara····Peters1951-04-10UNKNOWN··N/A6223928410··BARBARA.PETERS@YAHOO.COM4436 Maple AveTAMPAFLNULL-N/A
TPATPA-508732026-05-04T15:05:18Zdenise—johnston09-03-2008—N/A627-308-0928N/A6538 Palm Drive··GilbertArizona··85210··—UNKNOWN
TPATPA-505332026-06-19T19:43:06ZJennifer—Brown·1944-11-06UHC-69247-33•••-••-3689·15643706462—5728 Lake View RdChandlerAZ85258N/A—
TPATPA-629772026-05-20T21:10:30ZDeborah—Ward1989-10-07—•••-••-6449637-449-7703deborah.ward50@proton.meN/A-NULL··——·NULL
TPATPA-527772026-04-09T19:35:01ZArjun—Sanders1961-05-25UHC-60332-28NULLN/Anull1118 OAK STREETMIAMIFL33190—CHOICE-PLUS-PPO
TPATPA-515132026-08-12T13:43:18ZHiroshiA.Wood1960-10-20N/AN/AN/A—-UNKNOWN——GRP-5947—
TPATPA-547852026-03-05T13:13:15ZAlice—Armstrong·1984-04-18null-344-292-0712·null7640 Forest AveColumbusOH43261GRP-0323SELECT-EPO
TPATPA-572622026-06-15T23:44:58ZNICHOLAS··—MILLER12-05-1959-•••-••-19429222990149—5983 SPRING ST·TampaFL33697null·OPTIONS-PPO
TPATPA-577532026-06-25T07:11:48ZSara—Allen11/27/01——-—·5893 Indian School RoadTUCSON··Arizona—NULL·CORE-HMO
14,474 rows, page 270 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:43:03.427Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty