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-511052026-03-10T05:02:51ZMARY—JOHNSTON06/19/1950nullN/A263-223-3036··—612 DESERT SKY BLVDNashvilleTN37291NULLSELECT-EPO
TPATPA-61894 2026-01-07T16:52:30Zjack—castro03-08-1967NULLNULL(917) 574-3970jack.castro32@outlook.comnull——UNKNOWN·-null
TPATPA-623012026-01-02T08:34:49ZParker, Timothy··——1997-01-11N/A•••-••-95593266379772··—8235 MARKET STREETEden PrairieMN55368N/ACORE-HMO
TPATPA-548722026-04-21T13:11:46ZBetty—Watkins1959-10-19UHC-26145-99•••-••-96548705739315—9212 Desert Sky BlvdAtlanta··GA30343UNKNOWN—
TPATPA-643472026-07-23T19:32:48ZLewis, Robert——1938-06-12UNKNOWN•••-••-3026UNKNOWNrobert.lewis@proton.me1524 OAK STSacramentoCA95858—NULL
TPATPA-548522026-07-17T00:54:22ZHannah—Silva19871206null•••-••-29565642976614N/A4027 PARK PLACEGlendaleAZ85315N/AN/A
TPATPA-527952026-08-08T20:33:00ZBakar, Megan——01/06/1994UHC-45792-28UNKNOWN5964708007—5007 Bayshore DrNashvilleTN37261··null·-
TPATPA-636782026-01-13T00:43:58ZKELLY··CHAPMAN19710112—NULL(319) 444-2943N/A——NULL—nullOPTIONS-PPO
TPATPA-543142026-01-15T22:14:19ZBruceCAlvarez1981-05-04N/A-UNKNOWNN/A———·-··NULL
TPA TPA-588122026-09-29T12:48:52ZKimberly—Ruiz0716-19-88NULL—null—8217 Valley View DriveOrlandoFL··32817—CHOICE-PLUS-PPO
TPATPA-584532026-02-25T04:38:44ZAUSTIN—MURRAY1940-47-18UHC-61729-64··—null6579 Washington StAustin···TX78760——
TPATPA-561402026-03-10T11:03:09Zpatel—austin1972-10-22NULLUNKNOWN——1655 Baseline RdAtlantaGA30387-4961GRP-0892-
TPATPA-558402026-03-08T04:53:48ZAnthony—Aguilar1989-11-06NULLNULL17628088884—·7499 Jefferson AvenuePhoenixAZnullUNKNOWN··MEDICARE-ADV-A
TPATPA-537332026-10-03T08:15:30Z Patel, Stephen——1961-07-20—•••-••-1402—null8076 HIGHLAND AVE··ColumbusOH43290-3066—CHOICE-PLUS-PPO
TPATPA-513002026-09-28T03:23:55Znatalie—weber1977-12-13null•••-••-7476(844) 948-9245···natalie.weber60@yahoo.com2493 Pine DriveJacksonvilleFlorida32279—NAVIGATE-HMO
TPATPA-633582026-02-10T22:02:50Z Flores, Jesse··——2008-11-16N/A·····null-7763 Hillcrest RdNashvilleTN37275N/ANULL
TPATPA-585002026-07-04T03:14:48ZGabrielZ.Espinoza19391125UHC-49887-40•••-••-0856239-774-1239—6048 Lake View RdGLENDALEArizona85330GRP-7848NAVIGATE-HMO
TPATPA-637742026-05-24T03:49:21ZVIRGINIA—·FERNANDEZ1973-06-03——-UNKNOWN3072 Ocean AvenueJacksonvilleFL·32215-1911GRP-2742null
TPATPA-602562026-08-21T04:15:55ZJanet—Dixon2007-10-04UHC-08041-77—nullUNKNOWN2945 Lincoln Way··HoustonTX··77078null·UNKNOWN
TPATPA-543382026-01-02T08:44:51ZHIROSHI—VAZQUEZ09/11/1978-—906-583-6819-928 MOUNTAIN VIEW DRIVE #951SCOTTSDALEAZ85204GRP-0865NAVIGATE-HMO
TPATPA-548292026-01-24T08:25:57ZLUIS—CLARK1983-08-07NULL—·-—8275 Church StColumbusOH43264N/AMEDICARE-ADV-B··
TPATPA-554212026-05-23T15:54:25ZLawrence—·Watson1995-10-04UNKNOWN•••-••-7664N/A—9551 CAMELBACK RD #710MINNEAPOLISMN55483GRP-7217UNKNOWN
TPATPA-576722026-10-05T16:59:16Zemily—harris1968-10-25—•••-••-0697UNKNOWN··—N/A—nullnullUNKNOWN
TPATPA-517172026-09-06T23:01:41ZPrice, Philip··F—1999-11-07—NULL15548342963philip.price@yahoo.com1953 HILLCREST ROADGILBERTAZ85296-2957—NULL
TPATPA-521832026-03-16T18:40:33ZSaar—Padilla··1982-07-06N/A•••-••-8586·+1 956 871 1550N/A690 MAIN STREET·TampaFL33683··nullCHOICE-PLUS-PPO
TPATPA-607712026-02-08T20:19:25ZRalph—Ruiz1950-05-14··UNKNOWNnull(817) 960-5979null5738 Valley View Dr Apt 28MesaAZ85298··-MEDICARE-ADV-B
TPA TPA-541062026-01-20T08:25:48ZJerry—Anderson12/25/2006N/A·N/A—·null5218 Lake View RdSan AntonioTX78227nullmedicare-adv-a
TPATPA-564102026-09-04T04:31:38ZPAUL—COOPER1984-05-19——··N/A732 Camelback RoadSan AntonioTX78283GRP-2878SELECT-EPO
TPATPA-635612026-06-05T21:32:15ZSimmons, Virginia—··1960-12-20··N/Anull—virginia.simmons@gmail.com4459 Canyon RoadMinneapolisMN55407—CORE-HMO
TPATPA-576152026-01-02T21:46:31ZNancy—Hughes1990-72-05UHC-92987-80UNKNOWN6757855487··NANCY.HUGHES@YAHOO.COM7424 CEDAR LANELas Vegasnv89131—OPTIONS-PPO
TPATPA-637642026-09-29T20:39:27ZSHIRLEY—LEE1955-01-13UHC-46809-42UNKNOWNnull—429 CAMELBACK RDChandleraz85230—UNKNOWN
TPATPA-518302026-02-25T20:01:09ZKevin··—·Bakeer2001-01-12-—896-687-1486NULL9150 CHURCH STREETJacksonvilleFL32225····null
TPATPA-526762026-06-21T07:04:24ZDONALD—LUNA1955-01-09UNKNOWN—nullDONALD.LUNA@ICLOUD.COM8713 Main StScottsdaleAZ85205—null
TPATPA-612312026-07-07T09:05:31ZELIZABETH··WEAVER1985-07-09UHC-21629-88—NULLN/A2357 OCEAN AVENUESan Antonio·TX78239GRP-9943····
TPATPA-583942026-04-11T00:08:13ZFernandez, Amber—··Aug 14, 1970—nullUNKNOWNNULL3495 Hillcrest RdSan DiegoCA·92129UNKNOWNCORE-HMO
TPATPA-505412026-03-28T08:18:20ZMaria—Washington1968-08-24··NULL—null—1478 BAYSHORE DRIVESacramento··CA95859GRP-8811—
TPATPA-639822026-07-20T21:50:30ZGRACE—LE0201-07-10null-····UNKNOWN·7146 Central AvenueSAN ANTONIOTX78244-null
TPATPA-585982026-06-29T23:05:39ZJacobKArnold1945-11-04UNKNOWN•••-••-7841(429) 917-8212—NULLUNKNOWN—UNKNOWN—-
TPATPA-589342026-01-26T08:19:29ZNathanABell12/03/1942-—2603064347NATHAN.BELL53@OUTLOOK.COM1240 Park Place··MiamiFL33170-—
TPATPA-637772026-08-05T08:07:08Zsteeve—robertson1974-04-26—-nullstephen.robertson8@aol.com4568 CANYON RDFresnoCalifornia93735-2481-null
TPATPA-545122026-02-01T03:09:24ZDYLAN··—BAILEY1962-07-08—•••-••-0427null—8382 Jefferson AveLas VegasNV89144——
TPATPA-547572026-03-03T07:49:32ZPowell, LauraW—1969-05-21N/ANULL768.770.4513-3187 Harbor BoulevardEden PrairieMN·55356N/A-
TPATPA-500272026-02-15T09:52:15ZPatricia—Anderson4/15/1974null··——1229 DESERT SKY BOULEVARDCharlotteNC28235GRP-3065null
TPATPA-579812026-08-04T13:53:43ZKayla—Perez12/11/1964NULLnullN/Akayla.perez@gmail.com5951 FOREST AVEPlanoTX75025N/ACORE-HMO
TPATPA-558882026-01-25T00:09:04ZERICMJENKINS2004-02-27NULL•••-••-1030null··eric.jenkins@hotmail.com8967 PINE DRIVENASHVILLETN37247-NAVIGATE-HMO
TPATPA-612822026-08-21T14:22:06ZTeresa—Mitchell12-09-2001UHC-68340-13•••-••-5012UNKNOWNUNKNOWN1695 CEDAR LN·San AntonioTX78272—NULL
TPATPA-536922026-05-21T09:09:06ZAnderson, Bobby····—1978-03-09N/A··UNKNOWN—3664 Harbor Blvd #951··MINNEAPOLISMN55491GRP-0391—
TPATPA-608372026-02-14T14:40:43ZDiana—Castro1977-10-11nullN/AN/A—2172 Ocean AvenueOrlando·Florida32838—MEDICARE-ADV-A
TPA TPA-634932026-06-20T20:19:52ZJackson, Russell——2001-02-14nullnull——3483 Desert Sky BlvdMesaAZ85242-—
TPA TPA-598082026-02-26T19:28:12ZRYN—REED·01/18/55NULL—UNKNOWNryan.reed@proton.me7022 Elm StreetCHARLOTTENC28289—UNKNOWN
14,474 rows, page 27 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:36.715Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty