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
TPA TPA-527062026-09-27T22:13:47ZKayla—Myers1980-11-25UHC2403847——NULL3718 Church StreetTampa·FL33686—null
TPATPA-535592026-10-07T01:32:01ZBradley, Abigail··—5/23/1974N/A—NULL—3110 Church StMesaArizona85210··null-
TPATPA-614142026-02-19T11:36:43Zruth—moreno1977-10-01—•••-••-1267—UNKNOWNNULLN/ANULL—··—
TPA TPA-623792026-01-15T18:36:11ZMary—Brown08/18/2006—•••-••-4125—MARY.BROWN@AOL.COM5961 Ridge RdMesaAZ85268GRP-8535MEDICARE-ADV-A
TPA TPA-619622026-07-02T12:42:45ZJULIAHKELLYDec 28, 1938NULL—(680) 423-6350—4420 Union St··TAMPAFL33662nullOPTIONS-PPO
TPATPA-52029 2026-07-04T03:58:33ZAllen, Alexander——1972-06-07null•••-••-04864195231—·6316 Spring StreetTucsonAZ85713NULLMEDICARE-ADV-A
TPATPA-605832026-04-25T09:04:02ZYuki—Evans1984-12-08·UHC5772603-811-336-3207yuki.evans@outlook.com8031 BroadwaySan AntonioTX78227-3401GRP-3116—
TPATPA-553862026-08-05T11:54:34ZAdam—Gordon2008-07-18UNKNOWN·nullN/AUNKNOWNNULL—NULLUNKNOWN—-
TPATPA-509842026-05-11T11:21:34ZJENNIFER····SILVA1938-10-06N/A—573-883-1960jennifer.silva70@aol.comNULL····NULL··nullNULL—
TPATPA-624302026-05-24T05:29:04ZRuth—Meyer2004-06-19N/A•••-••-0378——8704 Central AvenueGlendaleAZ·85341—SELECT-EPO
TPATPA-628042026-02-17T09:05:07Zcynthia—weber1989-03-13-—N/A-—-NULL-NULLMEDICARE-ADV-B
TPATPA-534602026-09-14T06:29:03Zjose—perry1967-07-03——915-693-5561jose.perry89@proton.me7548 MOUNTAIN VIEW DRFresnoCA93749··-—
TPATPA-575922026-06-07T04:38:54ZSARAH····REED19670314——-—3831 Grand AveSeattleWA98140—CHOICE-PLUS-PPO
TPA TPA-619422026-09-11T03:30:57Zeddward—ray1/4/1980null··N/A·982.447.3753—5698 Palm DriveTempeAZ85252——
TPATPA-57349 2026-09-21T06:29:52ZKimberly·····Payne1942-04-07——N/A··kimberly.payne14@outlook.com4517 Bayshore Dr·JacksonvilleFL32253—null
TPATPA-577122026-02-11T04:06:39ZJoseph—Welch1999-12-19NULLnull·NULLNULL4470 APACHE BLVDSan AntonioTX—UNKNOWNCORE-HMO
TPATPA-627712026-09-10T10:23:15ZJanice····—19620721··—•••-••-2805NULL—4623 Highland AvenueChandlerAZ85234··nullMEDICARE-ADV-B
TPATPA-617592026-02-18T10:41:33ZLori—Allen12/02/1938——null—nullN/A———CORE-HMO··
TPATPA-59978 2026-05-08T04:49:42ZDaniel—Guerrero1946-06-03null··—+1 397 301 8288—8761 Jefferson AveAustinTX78723N/Aoptions-ppo
TPATPA-527502026-02-11T10:29:20ZJANICE—GONZALES1999-04-13N/A··—·-NULLNULLnullNULL-NULL—
TPATPA-557482026-07-21T18:02:00ZNATALIE—MOORE10/09/40—•••-••-1637·nullNULL4797 Cedar LnGlendaleaz·85322—null
TPATPA-604142026-10-07T14:29:47ZArjun—·Jones1953-02-05—nullUNKNOWNN/A8013 Grand AvenueDenverCO80293GRP-1470—
TPATPA-520162026-02-21T14:43:37ZRebecca—Munoz1958-09-21—null(348) 573-6847—NULL-——GRP-8420—
TPATPA-639882026-05-14T22:00:25ZjacquelineVrichards20040910—UNKNOWN(335) 206-0718··jacqueline.richards8@icloud.com2754 Main StreetDALLAStx75298——
TPATPA-619752026-08-25T15:33:18ZKibmerly—Hart22-11-1940NULLUNKNOWN—null1388 Spring StreetSan DiegoCA92145GRP-9346—
TPA TPA-546242026-03-28T18:19:16ZGabriel—Luna·Dec 3, 2001UHC-12214-03•••-••-5441N/A—3051 Washington StLas VegasNV89151—CHOICE-PLUS-PPO
TPATPA-637232026-04-18T18:26:49ZJUDITH—HERNANDEZ1/21/1964NULL——NULL1992 Church StreetColumbusOH43237N/AUNKNOWN
TPATPA-553832026-01-14T19:32:24ZJacquelineVJones19550513UHC-92030-89-4156409037JACQUELINE.JONES@AOL.COM1278 Lake View RdDENVERColorado80286GRP-8181null
TPATPA-579572026-06-07T06:41:05ZLINDA—LUCAS06-03-1951-··•••-••-71694002711136NULL6009 BAYSHORE DRIVE Apt 29EDEN PRAIRIEmn55326GRP-5847··NULL
TPATPA-583272026-10-03T13:08:28ZFATIMA—MEYERNov 1, 1962—-—N/A8894 MAIN STTEMPEAZ85297-6119GRP-9317OPTIONS-PPO
TPATPA-515352026-07-21T19:51:43ZJoe—Wang1976-04-25N/A•••-••-285618153047222UNKNOWN7202 RIVER RDSan DiegoCA92172··—
TPATPA-617422026-06-04T13:19:36ZRoy—Powell···1980-11-27UHC-17581-40—5032571479NULL482 BROADWAYPlano··TX75010GRP-9654—
TPATPA-548622026-10-02T22:15:25ZRANDY—HOWELL1948-03-18··nullUNKNOWNrandy.howell@hotmail.com9138 Maple AveTempeAZ85264UNKNOWNUNKNOWN
TPATPA-620962026-04-19T07:24:05ZMEI—VASQUEZ03/22/58—N/Anullnullnull-—··GRP-8142—
TPATPA-528582026-09-05T03:12:41ZVazquez, Mateo——1964-10-05UHC-94454-99—NULLNULL--··——N/A—
TPATPA-621102026-04-21T03:02:37Z·HEATHER····COLEMAN1943-07-03—NULL—-UNKNOWN··N/A—····—NULL
TPATPA-588772026-03-27T12:09:26ZBobby—Vasquez08/27/87NULL—-null776 Sunset BoulevardAtlanta·GA30347—-
TPATPA-632442026-06-27T15:42:04ZGilbert, Timothy——19680310—-369-501-2841null7975 Camelback RdNashvilleTN37228—core-hmo··
TPATPA-616802026-01-17T12:01:50Z·Logan—Owens1974-08-18—•••-••-3816754-691-0824———-NULLNULL··CHOICE-PLUS-PPO
TPATPA-617692026-04-25T15:26:48ZNacy—Richards06/12/48UNKNOWN•••-••-5878—nancy.richards@proton.me8910 MOUNTAIN VIEW DRIVEDallasTX75234··GRP-6136—
TPATPA-63323 2026-05-16T20:16:01ZKeith—Howell1992-02-06—UNKNOWNUNKNOWN—200 Camelback RdDallasTX75201nullMEDICARE-ADV-A
TPATPA-563232026-01-03T03:43:48ZChristopher—Maldonado·2000-04-22nullnull-—6080 Ridge RdLas VegasNevada89110NULL—
TPATPA-594702026-09-03T02:02:03ZsofiaZcooper14-06-1959—-9457044—4007 Washington St #866SACRAMENTOCA·95812GRP-5610medicare-adv-b
TPATPA-571252026-09-05T03:17:00ZDylan··Fox1946-04-10NULL—nulldylan.fox8@outlook.com9665 Forest Ave··SeattleWA98174UNKNOWN-
TPATPA-582172026-09-27T02:44:10ZAlice—Wood1946-05-04····•••-••-9120(864) 957-5675—1569 Canyon Road #345SeattleWA98155GRP-7389CHOICE-PLUS-PPO
TPATPA-572392026-04-14T04:17:21ZAISHAX··GIBSON1941-12-19NULL-877.363.4795—3743 Church StAtlantaGA30359-6292GRP-8576OPTIONS-PPO
TPATPA-594992026-06-21T13:00:05ZSilva, Mark······12/04/87——UNKNOWN··7641 Ocean AvenueChandlerAZ··85251—core-hmo
TPATPA-504292026-06-14T10:59:02ZGerald—Hart01-01-1955-N/AN/AN/A6037 VALLEY VIEW DRSAN ANTONIOTX78256—null
TPATPA-528482026-03-03T19:39:48ZETHAN··WILSON1974-12-05··UNKNOWNN/AnullUNKNOWN7519 LAKE VIEW RDPhoenixArizona85083UNKNOWN—
TPATPA-561062026-02-17T22:15:22ZJohn—Hill1979-07-23N/A—5987395817—1953 Church St··OrlandoFL32807—N/A
14,474 rows, page 44 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.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty