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-502152026-05-06T02:29:28ZMARTHA··PARKER1981-02-15UHC1960397··—6026444202———····—GRP-9206-
TPA TPA-580092026-06-04T11:46:57ZMarcus—·Hansen1940-03-12UHC1868864•••-••-5353469-699-2761·N/A8183 OCEAN AVENUEPhoenixAZ85012UNKNOWNNULL
TPATPA-572692026-01-17T05:18:00ZMADISON—MEYER19540922N/A—7023315—6065 Ridge RdTampaFL33615——
TPATPA-582182026-09-17T20:35:58ZCATHERINE—CARROLL1971-06-08UNKNOWN•••-••-7387-null5270 Highland AvenueOrlandoFL32847-····
TPA TPA-519112026-05-03T03:18:29ZDANIELLE—LONG10-01-1998N/A··•••-••-8691—danielle.long@proton.me105 OCEAN AVELos AngelesCA90077GRP-3336CHOICE-PLUS-PPO
TPATPA-583252026-05-12T01:59:18ZMDAISON—·VAZQUEZ10/09/1994—•••-••-6767N/Anull9099 MESA DRIVEMinneapolisMN55480-2477——
TPATPA-540532026-01-01T06:16:44ZMatthew—Romero1972-07-08NULL•••-••-9717—matthew.romero92@icloud.com———-null—
TPATPA-625812026-08-10T05:51:37ZJAMESJJACK1957-03-03—•••-••-1330··jack.james@outlook.com··1297 MAPLE AVETampaFL33662GRP-3340—
TPATPA-586752026-06-06T22:19:01ZJenkins, Bryan····—1945-05-18··N/A—7804210538N/A5150 Cedar LnSan DiegoCA92139··—NAVIGATE-HMO
TPATPA-608232026-09-19T16:31:13Z·DEBORAH—FERRNANDEZ1954-02-61—•••-••-8661null—5013 BROADWAYMiamiFL33157—MEDICARE-ADV-A
TPATPA-544682026-05-05T03:30:15ZKevin—Wilson19950915—NULL783.570.2670—2944 VALLEY VIEW DRIVEMinneapolisMN55410GRP-0748-
TPATPA-508052026-06-19T17:35:41ZBettyTPeters1940-12-28UNKNOWN-—NULL7521 CAMELBACK RDSACRAMENTOCA95881GRP-9838MEDICARE-ADV-B
TPATPA-609142026-09-20T10:42:49Z·Watkins, BradleyR—2008-04-01——·15773987294UNKNOWN4441 VALLEY VIEW DRATLANTAGA—UNKNOWN-··
TPATPA-600872026-04-24T17:27:33Zlogan—simmonsJun 11, 1959UHC-67698-28null9247951154—8239 Forest AvenueFresnoCA93786nullnull
TPATPA-547882026-03-17T09:47:26Zadam—lnua1941-11-08··——UNKNOWNADAM.LUNA@ICLOUD.COM6056 Main StreetTempeAZ85296nullCORE-HMO
TPATPA-55100 2026-01-22T00:11:03Zjack····carter1997-04-23—•••-••-7654693-940-0690null9198 Mountain View Dr Apt 21TUCSONAZ85754GRP-7654-
TPATPA-503952026-05-09T16:41:57Z·PATRICK—MOORE1955-03-04N/A•••-••-64077412401465patrick.moore90@aol.com1188 Lincoln WayScottsdaleAZ85236GRP-3879—
TPATPA-577802026-01-04T23:47:37ZDIANA—ARMSTRONG·1969-06-23NULL····—UNKNOWN1554 PALM DRIVELos AngelesCA90085nullUNKNOWN
TPATPA-577572026-02-26T01:24:21Zmason—espinoza1941-11-26·NULL——NULL9727 CANYON RDScottsdaleAZ85256-—
TPA TPA-605342026-01-15T15:18:04ZLoriQYang··1974-08-09null-7174754465N/A5415 Forest Avenue Apt 11DallasTX75273GRP-0534OPTIONS-PPO
TPA TPA-600672026-06-04T03:43:16ZCAROLYN—COLE1/18/1970—null393.763.5596—·4149 Mountain View DrTEMPEArizona85288N/AN/A
TPATPA-597442026-08-22T10:29:39ZRaymond—Robinson1942-04-12UHC-17881-72·NULLUNKNOWN—1979 UNION STAtlantaGeorgiaN/A——
TPATPA-527622026-04-14T11:22:52ZSHARON—HANSON07/07/2000N/A——UNKNOWN33 RIVER ROADSACRAMENTOCA95834NULLN/A
TPATPA-554752026-09-17T19:36:56ZHenry, Alice L.——11/22/42-—null—4514 Indian School RoadDenverCO80296·····OPTIONS-PPO
TPATPA-521942026-04-27T02:25:17Zalan—wagner1970-03-01··——505-512-8445—6466 BROADWAYLos AngelesCA90063GRP-2573N/A
TPATPA-518582026-04-27T16:42:35ZNicholas—Fuller1983-02-08·NULL•••-••-76163246093501—4462 Sage CtLas VegasNV89144GRP-8651—
TPATPA-536642026-09-04T19:47:42ZAlex—Perez··6/5/1993--UNKNOWNNULL··1775 LINCOLN WAYPHOENIXAZ·85003GRP-3899UNKNOWN
TPATPA-528522026-01-13T17:52:18ZJames—Gilbert1965-01-02···NULL•••-••-513818843126120··NULL6028 Apache BoulevardOrlandoFL32836-—
TPATPA-639222026-02-18T20:40:35ZMelissa—DominguezOct 15, 1955··N/A-(985) 530-4738null1059 INDIAN SCHOOL RD Apt 36··AustinTX78745GRP-2322—
TPATPA-571342026-02-25T23:14:44ZBRANDON—·GARCIA12/04/45NULL—9413637070—UNKNOWN-———CHOICE-PLUS-PPO
TPA TPA-533262026-09-25T05:40:05ZJoe—Turner1997-09-21—N/A—-3679 LINCOLN WAYDenverCO-nullSELECT-EPO
TPATPA-557712026-03-14T09:55:54ZSara—Espinoza1/27/1997--nullnull·5773 CENTRAL AVENUELos AngelesCA90072·GRP-5707—
TPATPA-573902026-01-05T05:51:10ZADAM—LI01/18/1945NULLUNKNOWNNULLN/AN/A—NULLNULLGRP-0546—
TPATPA-600452026-08-26T03:55:27Z ZACHARY—GREENE·1992-12-26UHC-69793-13——null3732 PALM DR #883Los AngelesCA90067NULLOPTIONS-PPO
TPATPA-505362026-08-21T07:55:18ZVirginia—Salazar1954-12-03UNKNOWN•••-••-47138316600224NULL3707 Ridge RdSacramentoCA--—
TPATPA-509102026-10-16T15:43:08Z gragP··knight·1993-08-02nullUNKNOWNnullNULL8500 MAIN ST Apt 14AUSTINTX78740nullNAVIGATE-HMO
TPA TPA-507812026-03-12T07:25:04Zhiroshi—coleman04/06/85UHC-24824-94—nullnull··3352 CENTRAL AVENUE·SAN ANTONIOTX78242GRP-4840··
TPATPA-500432026-06-03T04:38:17ZSofia—Lawson9/7/1963null·-null—1830 LAKE VIEW ROADNashvilleTN37231null-
TPA TPA-528382026-10-14T21:08:37ZCarter, Carolyn——19501124UHC-48342-14··UNKNOWNUNKNOWNCAROLYN.CARTER19@ICLOUD.COM3394 Park Place··TAMPAFlorida33632nullUNKNOWN
TPATPA-555292026-07-31T13:52:29ZElizabeth—Ward08/04/1947··N/A··•••-••-9345——1229 Willow Ct··SeattleWA98173—SELECT-EPO
TPATPA-573512026-08-09T19:52:47ZLUIS—DELGADO1999-05-08null•••-••-7791503-222-3372——null—-NULL—
TPATPA-500802026-10-07T12:15:21ZALBERT—MONGOMERY2/3/1971N/A•••-••-2171NULL·-7534 CEDAR LNGlendaleAZ—N/A··
TPATPA-616672026-08-27T07:15:46ZRachel—Carroll7/14/1968N/A•••-••-6396nullrachel.carroll22@outlook.com8789 Valley View DrSacramentoCA95843GRP-9885UNKNOWN
TPATPA-610922026-04-21T22:16:42ZMiller, Betty··—05/22/65—•••-••-4276null··4060 Indian School RdTampaFL33671—CORE-HMO
TPATPA-539082026-05-03T22:40:38ZGonzalse, Christina——1963-11-26——(632) 606-3316-3686 LAKE VIEW ROADSCOTTSDALEAZ85219—N/A
TPATPA-629572026-03-22T02:39:17ZGABRIEL··FERGUSON20070914UNKNOWN—17222377414—74 Bayshore DriveDENVER·CO80231GRP-8716MEDICARE-ADV-A
TPATPA-609572026-03-10T04:29:11ZTylerKRamiirez1998-12-02UHC-59537-21····—-··8319 Palm DrAustinTX——NULL··
TPATPA-510332026-10-11T22:09:43ZKaren··Little1959-03-03NULL—····KAREN.LITTLE27@PROTON.ME7996 Willow CourtOrlandoFL32830nullMEDICARE-ADV-B
TPATPA-590722026-05-05T22:59:52ZWong, Eugene——1941-11-04—•••-••-42326692377—3733 Forest AveTempeArizona85240——
TPATPA-546152026-05-29T00:50:35ZBRADLEY—PERKINS·08/26/2003—•••-••-3823—BRADLEY.PERKINS@OUTLOOK.COMnullNULL··—N/Anull
14,474 rows, page 190 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.144Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty