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-615242026-05-22T16:40:42Zadem—vasquez1973-04-07·NULL-9417296737-5966 Cedar LnCHARLOTTENorth Carolina28288·null—
TPATPA-618252026-06-30T05:26:46Zsophia—mitchell19640920UNKNOWNN/AN/Asophia.mitchell57@icloud.comNULL-null———
TPATPA-636152026-06-17T23:11:48Zandrea—harrison1956-06-22UHC-14709-75———1180 Meadow LanePhoenixAZ··85054··GRP-6490N/A
TPATPA-568832026-07-21T07:13:20Zmateo—colemanOct 3, 1963NULL•••-••-37119149432078—7528 LINCOLN WAYGlendaleAZ85303UNKNOWN··N/A
TPATPA-563632026-08-11T20:28:35ZSOPHIA—HART·1959-04-24UNKNOWN—-sophia.hart26@aol.com8220 Ocean AvenueDenverCO80243NULL-
TPATPA-574632026-05-28T06:53:52ZBill—Wallace1121-09-97·--NULL—·NULL—null··UNKNOWN······
TPATPA-592982026-09-22T08:36:56ZAmy··G.Palmer1983-04-08—NULLUNKNOWN-—·UNKNOWNNULLUNKNOWN-OPTIONS-PPO
TPATPA-609232026-09-08T17:45:31Z·Brenda····LopezNov 1, 1950—N/A-—7991 Park PlColumbusOH43204UNKNOWN—
TPATPA-583402026-10-12T16:22:49ZBEVERLY—MATINEZ1985-09-20UNKNOWN-··——·-—UNKNOWN——NULL
TPATPA-581482026-04-09T17:56:54ZRuth—Bell1991-06-20··UNKNOWNnullNULL—5894 Central AveScottsdaleAZ85240NULLNULL
TPATPA-559052026-03-07T20:25:14Z Noah—Chapman1994-12-08UHC-64405-22N/A905.487.3314N/A7353 Mountain View DriveDallasTX75268UNKNOWN—
TPATPA-554352026-02-05T10:46:59ZColeman—Edward1971-11-17—null6329700454edward.coleman@proton.meN/A-———-
TPATPA-519152026-05-15T01:43:31ZALEXISV.DAY07-09-1997UHC-68769-03—6482209403NULLnull-UNKNOWNN/AGRP-2995—
TPATPA-510152026-02-14T15:27:57ZMary—Bennett··1943-09-13N/A—-—7846 MAIN STREETSCOTTSDALEAZ85214—NULL
TPATPA-561722026-09-25T17:26:35ZKAYLA—WATKINS1977-02-06null—-kayla.watkins@gmail.com··5154 Harbor BlvdMESAAZ85267GRP-4197medicare-adv-b
TPATPA-606062026-09-02T19:39:01Zabigail··—patterson24-05-1957-UNKNOWN··—abigail.patterson54@icloud.com4835 Palm DriveCharlotteNC28257GRP-6067SELECT-EPO
TPATPA-624242026-05-16T23:50:46ZELIJAH—SPENCER1968-05-13UNKNOWN—N/A—3963 Forest Avenue Apt 35SacramentoCA95892NULL—
TPATPA-629812026-08-10T02:52:17ZBEVERLY····HOWELL·1988-10-22null··null—null··—null—nullGRP-9887NULL
TPATPA-515422026-07-29T14:46:27ZAhmed—MooreOct 26, 1988NULLUNKNOWN(472) 796-3380UNKNOWN5163 VALLEY VIEW DRHoustonTexas77025—MEDICARE-ADV-A
TPATPA-538972026-08-06T00:05:00ZVICKY—GARZA07-02-2000—•••-••-1984——6788 Spring StNashville··TN37205GRP-7057OPTIONS-PPO
TPATPA-554812026-01-22T19:52:21ZStephanie—Bell2005-04-28··UHC-85247-16--stephanie.bell@icloud.com319 Valley View Dr·DallasTX75255GRP-1339UNKNOWN
TPATPA-574962026-08-12T16:03:40ZRuth—Ross06/03/73UNKNOWN•••-••-0308NULL—4968 Lincoln WayChandlerAZ··85285UNKNOWNNULL
TPATPA-541952026-04-27T06:38:32ZPETER—HERRERA07/16/41·null—nullNULL4776 WASHINGTON STSacramentoCA95843-OPTIONS-PPO
TPATPA-540602026-03-27T01:23:53ZAaron—Campbell1975-11-03-········-·9770 Park PlaceAustinTX78708——
TPATPA-570932026-09-28T00:17:07Zmarcus—valdez1994-01-05-UNKNOWN5282052210UNKNOWN6287 BroadwayDenverco80221—N/A
TPATPA-503202026-06-08T19:44:38ZCHERYL—PARKER1988-06-09—NULL746-261-6992cheryl.parker@proton.me8286 Bayshore DrTampaFL·33649—CORE-HMO··
TPATPA-635302026-09-20T21:55:39ZJACK—TORRES02/10/49NULL-N/Anull110 Spring StNashvilleTN37271GRP-2611—
TPATPA-605012026-04-03T17:50:26ZJENNIFER····VARGAS1989-11-03N/A-NULLnull2753 River RoadPlanoTX75058GRP-9763MEDICARE-ADV-A
TPATPA-516312026-03-07T16:10:51ZCYNTHAI—CASTRO1988-10-16NULLnullNULLCYNTHIA.CASTRO@AOL.COM—N/AN/A-··NULL—
TPATPA-508022026-08-17T02:35:27Zwayne—howell·1965-10-08—NULL388-481-1126N/A9750 Central AveTEMPEAZ85230GRP-1160-
TPATPA-611022026-07-01T00:18:03ZANDREA—DELGADO1950-09-04··-(404) 871-3326UNKNOWN9789 Washington StreetHoustonTX77017—·null
TPATPA-612292026-01-13T21:20:34ZHicks, Donna——4/13/1952null•••-••-3963NULL··-2177 Highland AvenueTempeAZ85215··—MEDICARE-ADV-A
TPATPA-503622026-07-08T00:57:18ZSamuel—Price25-11-1987UNKNOWN•••-••-3155—-3203 CENTRAL AVENUEAtlantaGA30365nullCORE-HMO
TPA TPA-551292026-06-09T07:21:58ZVALENTINA—ORTIZ1958-09-28null——valentina.ortiz@icloud.com2148 WILLOW COURTColumbusOhio··43285—UNKNOWN
TPATPA-537482026-05-11T12:57:05ZKELLY··—STEWART10/28/1997—N/A—null5781 Jefferson AvenueSan AntonioTX78263GRP-2276—
TPATPA-508962026-09-17T17:04:57ZEric—Evans1979-11-17N/A•••-••-6176——N/A-——NULL—
TPATPA-589052026-07-06T19:24:45ZRuiz, Karen——1943-08-01UHC-25421-25—N/AUNKNOWN5995 Sage CourtAustin··TX78782GRP-6459·MEDICARE-ADV-B
TPATPA-565472026-05-28T02:43:43ZChristina··—Gardner1973-08-26—•••-••-1295UNKNOWN—·3126 Central AvenueGilbertAZUNKNOWNGRP-7224CORE-HMO
TPATPA-623922026-07-08T11:34:38ZRYANACARR··1973-07-20—NULLnullN/A2674 Ridge RoadGlendaleAZ85343NULLnull
TPATPA-622902026-04-19T11:42:53ZGLORIA—PALMER··19440601null·N/A828-615-6343null2787 Mountain View Drive Apt 4Tampa··FL33666—MEDICARE-ADV-A
TPATPA-525652026-07-11T23:54:40Z·Eugene—Foster1959-03-24··-•••-••-4534——6273 CENTRAL AVENUESACRAMENTOCA95833UNKNOWNCORE-HMO
TPATPA-516972026-02-13T12:25:11ZASHLEY—·THOMPSON19610411NULL•••-••-4943nullashley.thompson70@aol.com5781 BROADWAYMiamiFLN/A·-MEDICARE-ADV-A
TPATPA-548032026-07-02T09:33:41ZHiroshi—Harrison1948-04-27—-(538) 924-3959-1277 Spring StFresnoCA93797·nullOPTIONS-PPO
TPATPA-533592026-05-07T09:25:40ZDilan—Guerrero1944-04-17——569-364-5022dylan.guerrero9@proton.me9202 Spring StLas VegasNV89119-1199GRP-2481OPTIONS-PPO··
TPATPA-513382026-06-20T22:16:05ZHANNAH—AGUILAR09/23/1973-•••-••-4157nullN/A5872 Harbor BoulevardMinneapolisMN55402—N/A
TPATPA-614182026-04-10T01:38:51ZBobby—Graham1946-06-21UHC-35937-07•••-••-2231——7881 Palm DriveNashvilleTN37272N/AUNKNOWN
TPATPA-564482026-09-14T17:31:20ZMarilyn··Hansen1962-11-20UNKNOWNN/Anullnull659 Broadway·JacksonvilleFL·32295GRP-7959N/A
TPATPA-608192026-03-31T05:38:37ZROGERSNGUYEN19920206—UNKNOWN456-732-9041null4735 Central Ave Apt 19Eden PrairieMN55355—-
TPATPA-562882026-06-17T21:37:07ZAhmed—Marshall1985-05-08NULL-4986064229UNKNOWN——--null—
TPATPA-613412026-01-29T04:46:05ZReyes, Aaron——1946-09-11N/A—240-610-6259aaron.reyes@hotmail.com7541 CANYON RDCharlotteNC28228GRP-1943N/A
14,474 rows, page 192 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:53.696Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty