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-638582026-03-27T07:17:34ZRobert—Miller··11/3/1984-—-NULL4044 Market StreetMinneapolisMN·55403UNKNOWN—
TPATPA-609552026-09-20T15:40:47ZTyler—Weber19600413nullUNKNOWN17659251120null3535 Market StreetCharlotteNCnull——
TPATPA-527182026-06-19T15:37:13ZMICHELLE—NELSNOAug 8, 1947—·-—michelle.nelson@gmail.com··2704 Lincoln WayNashvilleTN37286UNKNOWNMEDICARE-ADV-B
TPATPA-539102026-09-07T01:25:13ZPAUL—WARREN1988-02-11—N/A··(655) 898-6393null4438 Willow CtLos AngelesCA90034NULLnull
TPATPA-585242026-07-19T00:16:36ZMarcus—Boyd1980-03-05NULL•••-••-9679+1 885 233 1451—8120 Central Avenue Apt 2Las VegasNV89144——
TPATPA-614322026-01-07T07:36:26ZScott—Hawkins6/10/2008null•••-••-2438UNKNOWN-8995 PINE DRTEMPEAZ85250—NULL
TPATPA-607762026-05-29T10:54:34ZJames—·Burke2001-04-16—N/A393-820-4845null1454 Elm StPhoenixAZNULLNULLMEDICARE-ADV-A··
TPATPA-526332026-10-01T18:44:42Z·Emily—Peters1962-08-09--5184678823-2414 Union Street··DenverCO80267·GRP-2347-
TPATPA-586692026-03-05T22:56:38ZStephanie—Ross-null•••-••-3411UNKNOWN—NULLUNKNOWN——N/A·SELECT-EPO
TPATPA-546422026-01-19T13:06:43ZVictoria—Simmons1960-11-19-····——9567 Highland AveLos AngelesCA90089··--
TPATPA-61668 2026-01-11T05:25:28ZRojas, Julie——1950-04-23NULL·null+1 336 712 6600julie.rojas@proton.me5396 Meadow LaneSan DiegoCA92139NULLNAVIGATE-HMO
TPATPA-568432026-05-30T09:24:30ZGreen, Linda——·1970-08-10—··NULL—8032 Valley View Dr·Los AngelesCA90038-2138NULLUNKNOWN
TPA TPA-641782026-04-06T10:12:04ZJULIE—MILLER2007-01-20NULL•••-••-7422627.840.6030—7356 Camelback RoadTucsonArizona85710—NULL
TPATPA-504942026-01-19T19:50:21ZgregoryP.salazar19670926—null—GREGORY.SALAZAR61@HOTMAIL.COM7702 APACHE BLVD #213SeattleWA98131——
TPATPA-643742026-10-06T03:37:23ZLUIS—HALL19540413····null··-null2269 Canyon RoadCOLUMBUSOH43267·GRP-3798—
TPATPA-516902026-06-09T23:39:51ZNATHAN—·WILLIAMSSep 7, 1976UNKNOWN•••-••-2274(552) 205-8925N/A5340 Jefferson AvenueTempeAZ85203nullMEDICARE-ADV-B
TPATPA-57146 2026-06-01T02:13:06ZTERESA—MARTINEZ··Feb 26, 1976null•••-••-3718—teresa.martinez@gmail.com··332 Cedar LaneTUCSONAZ85752GRP-8243UNKNOWN
TPATPA-55488 2026-07-01T20:07:30ZALEXISDROSE08/02/1955UHC-40584-26··•••-••-22596946981859UNKNOWN6299 Hillcrest RdAtlantaGA30393GRP-0241-
TPATPA-555092026-09-05T02:19:23ZBradnon—White04/11/00—•••-••-8782696-379-2814·N/A1696 APACHE BOULEVARD·Las VegasNV89171nullMEDICARE-ADV-A
TPATPA-566992026-03-21T00:22:59Z·Lawrence—Rice14-11-1962--UNKNOWNNULL7553 Harbor BlvdTAMPAFL33632—NULL··
TPATPA-578882026-07-30T08:57:17ZmadisonOstephensAug 4, 1951UHC-13108-98—4823249184NULL1893 WASHINGTON STChandlerAZ85243GRP-1363CHOICE-PLUS-PPO
TPATPA-595432026-10-17T02:51:42Zdebra—holmes12-01-2003—-—null6762 River RdEDEN PRAIRIEMN55326—SELECT-EPO
TPATPA-632122026-02-01T03:01:14ZMICHELLE··OLIVER1978-02-16··UHC-82552-09•••-••-5718—UNKNOWN8192 Indian School RdSACRAMENTOCalifornia95899-—
TPATPA-582842026-10-05T13:09:53ZStephen—Alexander1977-05-25—N/AN/A—1435 INDIAN SCHOOL ROADAustinTexas··78701···-
TPATPA-547262026-06-03T09:38:47ZRUSSELL··—ROBERTS1996-12-25—•••-••-2178null·····6249 Union StreetAtlanta·GA30305GRP-2427—
TPA TPA-57418 2026-04-17T00:07:52ZJESSICAMCAMPBELL1970-05-04—NULLNULLNULL343 Palm DrTucsonAZ85763-CHOICE-PLUS-PPO
TPATPA-53775 2026-06-11T15:46:17ZANDREW—PHILLIPS1946-03-28null—907-682-8708—4171 Harbor BoulevardColumbus··OH43226UNKNOWNNULL
TPATPA-528392026-08-22T12:44:30ZKATHLEEN I—MOORE1977-02-10UHC-73695-03—+1 455 566 6896—4834 Forest Ave·Los AngelesCA90038-MEDICARE-ADV-A
TPATPA-524152026-02-11T08:47:14ZAnn—SimpsonJan 13, 1975——NULL-63 Indian School RoadTempeAZ85297GRP-1233—
TPATPA-520862026-05-22T01:31:40ZMaria—Ray16-02-1984—UNKNOWN—NULL6515 Market StreetGlendaleAZ85309-N/A
TPATPA-641912026-07-24T12:20:52ZJordanU.Garza1949-11-27UHC-94287-98•••-••-2497nullnull5075 Harbor BoulevardPhoenixAZ85041GRP-5813—
TPATPA-567032026-04-25T02:58:20ZMarthaPFerguson··18-08-1990—NULL—-6568 BroadwaySan AntonioTX·78288GRP-1447OPTIONS-PPO
TPATPA-565652026-02-17T23:40:11Zjudith—foster1959-05-11N/A———2131 Camelback RdChandlerAZ85220—····
TPA TPA-633262026-04-21T10:14:31ZEmmaP.Lawson··19801026UHC-48027-22—N/A——N/A—-GRP-4380SELECT-EPO
TPATPA-514792026-05-20T18:35:43ZWayne—Luna05/16/42—•••-••-4045—UNKNOWN··9591 Jefferson AvenueDenverCO80232N/ANULL
TPATPA-505012026-02-14T14:37:48ZISABELLA—·WELCH10/04/1981——728-951-7598NULL————GRP-9179MEDICARE-ADV-B
TPATPA-522242026-06-05T05:52:52Z Sean—·Soto01/28/56N/A•••-••-9273N/AN/ANULL———-null
TPATPA-606642026-07-06T08:45:19ZBrandon—GuzmanDec 9, 1948·UNKNOWN—NULLbrandon.guzman56@proton.me3766 SUNSET BLVDTempeAZ85226-MEDICARE-ADV-B
TPA TPA-613672026-02-19T05:39:56Zsara—webar9151-12-12—null675-616-3224—4638 Lincoln Way···San Antoniotx78206GRP-1988null
TPATPA-643482026-03-06T20:48:56ZJOE—MARTIN2008-02-18——-··UNKNOWN9024 Bayshore Drive··MinneapolisMN55483-0978GRP-7537CHOICE-PLUS-PPO
TPATPA-514852026-02-23T17:42:15ZJONATHAN—MASON2008-11-13—UNKNOWNNULL—·5076 Cedar LnSan Antoniotx78265null····
TPATPA-511332026-04-17T08:44:26ZBRANDON—RICE03/14/1986··•••-••-2512—brandon.rice@icloud.com9531 Mountain View DriveFRESNOCA93773N/A·NULL
TPATPA-569642026-09-13T07:16:03Zjulia—collins27-07-1951-NULL-—9208 Camelback RoadEden PrairieMN55371GRP-9110—
TPATPA-601852026-09-10T17:31:02Zkelly—lucas1947-12-15UHC-15635-05-nullkelly.lucas87@outlook.com——NULL—·-UNKNOWN
TPATPA-561682026-04-17T04:59:27ZOMAR—JONES1945-07-03—null-N/A··8618 Bayshore DrTucsonAZ85700—null
TPATPA-538562026-05-07T22:15:19ZRANDY—HERNANDEZ1980-10-19UHC-00866-60nullNULL—8338 Lincoln WayATLANTA·GA30392GRP-2523MEDICARE-ADV-A
TPATPA-615732026-07-15T16:25:29Zanna—payne1966-11-27··-•••-••-2402(440) 897-7065—3257 Market StAustinTexas78786GRP-5767NAVIGATE-HMO
TPATPA-584442026-03-15T06:44:38ZHEATHER··NICOHLS1995-11-26N/A··—·heather.nichols@outlook.com—null—N/AN/A-
TPATPA-583952026-01-08T09:29:28Z·mary—miller1940-11-17—-N/Amary.miller4@aol.com9265 Sunset BoulevardMINNEAPOLISMN55476null····
TPATPA-593122026-07-17T20:06:55ZCarollyn—Walker·1997-04-28NULL-null-911 Mountain View DriveMinneapolisMN·55471UNKNOWNNULL
14,474 rows, page 129 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:46.092Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty