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-557322026-07-04T08:50:01ZKelly—Evans1964-05-28UHC-76873-84N/A—NULL9234 Lake View Rd #148Atlantaga30362UNKNOWNMEDICARE-ADV-B
TPATPA-570222026-04-07T10:15:45ZRaymondAThomas1966-03-27—null(827) 461-4635·raymond.thomas54@gmail.com7605 Harbor BlvdPHOENIXAZ85007—MEDICARE-ADV-A
TPATPA-55846 2026-06-03T20:27:52ZMaria—Dean2007-10-07—-N/A—6450 LINCOLN WAYTempeAZ85296——
TPATPA-626682026-07-21T23:41:45Zmelissa··Yphillips2008-08-03———UNKNOWN9369 Sage CtSeattle·WA98167—NULL
TPATPA-620172026-01-08T18:03:56ZAlbert—Watkins09/26/08UNKNOWN—6938904629·albert.watkins@icloud.com6358 Ridge RdTucsonAZ85780··GRP-4384N/A
TPATPA-579332026-06-28T20:21:13ZALBERT—HERNANDEZ·11-09-1983UNKNOWN—5533754564··3177 Spring StLas VegasNevada89184—N/A
TPATPA-548402026-02-01T20:45:58ZWILLIE—ROSS2004-05-19—N/A7869260····896 Lake View RoadFresnoCalifornia93720-8474GRP-5445null
TPATPA-514432026-02-20T06:06:13Z·Carl—Gilbert·1968-12-05N/A•••-••-9320-———N/AN/A-OPTIONS-PPO
TPATPA-627162026-02-15T23:09:37Zjacob—grant1969-10-22—•••-••-95534346185jacob.grant69@gmail.com3053 Harbor BoulevardTucsonAZ85724UNKNOWN—
TPATPA-510422026-01-31T10:15:51ZBEVERLY—MILLER01/27/1938—UNKNOWN·N/AUNKNOWN7645 CENTRAL AVESan DiegoCA92180··nullNULL
TPA TPA-577432026-10-18T03:43:14ZHIROSHI—·MEYER1988-10-03-——hiroshi.meyer56@hotmail.com3492 Willow CtAustinTX78723——
TPATPA-510112026-03-03T12:47:54Zcarl—morales1979-12-15-UNKNOWN·6095466523—5098 Market StreetOrlandoFL32800GRP-7452UNKNOWN
TPATPA-608492026-06-08T19:46:31ZCollins, Amy——1970-09-28-·UNKNOWNUNKNOWNamy.collins61@icloud.com4997 MAPLE AVENUE #315·MinneapolisMN55493GRP-1690null
TPATPA-583592026-04-30T08:09:58ZLawrence····Burke1981-07-17NULL•••-••-5867nullN/A6947 Apache BoulevardMESAAZ85251-8239····-
TPATPA-524712026-09-16T03:57:48Zedward··robertson1995-11-16—•••-••-743819648396355edward.robertson@proton.meN/A-null····GRP-2079·CORE-HMO
TPATPA-617052026-08-19T09:07:47Z·JESSE—FREEMANSep 26, 2001—N/A(343) 292-1075—3400 GRAND AVENUE Apt 8TucsonAZ85753NULL·OPTIONS-PPO
TPATPA-532302026-07-13T20:54:33ZGEORGE—MURPHYOct 14, 1998UNKNOWN•••-••-6270964.805.2507NULL2791 ELM STFresnoCA93778-7029null—
TPATPA-629042026-06-16T09:49:10ZSOPHIA—STONE25-10-1985UNKNOWNN/A·9769077903-———NULLGRP-8389—
TPATPA-629672026-04-13T19:33:49ZBryanCRose1991-01-28····•••-••-1981(481) 388-6338bryan.rose@yahoo.com3255 BroadwayChandlerAZ85255——
TPATPA-540622026-06-13T08:38:05ZBradley—Reynolds1960-03-11-UNKNOWN··(728) 798-1520UNKNOWN3365 Elm Street #847SAN ANTONIOTX78211—N/A
TPATPA-612242026-09-22T21:29:10ZKathleen—Richardson1961-04-10———kathleen.richardson66@proton.menull—N/A·nullN/AN/A··
TPATPA-579592026-03-08T02:46:17ZDixon, Janet——2002-09-08—UNKNOWN··367-674-0820-UNKNOWN—N/A·NULLGRP-9356N/A
TPATPA-504652026-06-10T17:26:55ZMelissaMMoreno09/17/2000N/A-N/Anull7186 Lake View RoadChandlerArizona85207UNKNOWNOPTIONS-PPO
TPATPA-56442 2026-10-14T19:59:44ZMartinez, Jacob——2005-03-05—-··UNKNOWNjacob.martinez31@proton.me·922 Camelback RoadDallasTX··75258····—
TPATPA-527142026-01-02T18:21:03ZJudith—Dunn1969-02-18··NULLN/A(425) 719-8931··3345 Meadow LaneAtlanta·GA—GRP-5103NULL
TPATPA-582242026-03-19T21:13:54Z EDWARD—RUSSELL1991-02-21—-9966099·edward.russell@outlook.com7133 Meadow LnTucsonAZ85795GRP-3858·NULL
TPA TPA-595022026-08-18T01:59:21ZsaraGhoward04/09/1967-UNKNOWN(970) 229-8746NULL4495 Union StreetSan AntonioTexas78244····—
TPATPA-630782026-05-08T15:14:55ZDORIS··—JAMES1972-03-15null•••-••-7263N/A··N/A9312 PINE DRIVEGlendale··AZ85359·NULLnull
TPATPA-530012026-04-28T22:41:32ZMary—Cox1963-06-09····N/A-N/A2441 Canyon RdEden Prairie··MN55375—CHOICE-PLUS-PPO
TPATPA-643832026-04-30T07:33:16ZCHHRISTINA····WILLIAMS1996-12-21-UNKNOWN442-752-5175—9383 OCEAN AVENUETucsonAZ85705GRP-1370OPTIONS-PPO
TPATPA-579862026-08-08T21:47:25ZAnn—Webb1950-10-01——N/AUNKNOWN··NULLN/A·null-N/ANULL
TPATPA-561262026-09-03T03:35:37Zhiroshi—green1992-07-05—N/A—NULLN/AUNKNOWNN/AUNKNOWN-··SELECT-EPO
TPATPA-568382026-06-24T18:40:53ZNunez, Cheryl··——03/17/74——8004872922—3118 Elm St #727SCOTTSDALE··AZ85255——
TPATPA-538082026-04-29T07:20:42ZJohn—Lee12/10/80··—-—john.lee@outlook.com7726 MESA DRNashvilleTN37298-6192-MEDICARE-ADV-A
TPATPA-577862026-09-06T09:43:28ZJenniferFHenry1980-01-17N/AUNKNOWN—jennifer.henry@hotmail.com2409 Oak StreetJacksonvilleFL32216null-
TPATPA-501582026-03-31T00:48:46ZLarry—Thomas1966-10-23UHC-34933-36•••-••-1092N/ALARRY.THOMAS@GMAIL.COM697 Meadow Ln #666ChandlerAZ85227—-
TPATPA-510772026-01-14T03:59:54Zalexis····duncan1974-05-28NULL•••-••-4871(895) 271-0364UNKNOWN7653 Park PlaceScottsdaleAZ85284—MEDICARE-ADV-B
TPATPA-576552026-06-10T07:29:07ZJudyZ·Pierce1991-02-15N/A····+1 710 641 0167—2875 Maple AveSan AntonioTX78239-8088GRP-1592options-ppo
TPATPA-524032026-05-10T20:00:03ZVIRGGINIA—CASTRO1960-04-21UHC-40943-28•••-••-7152—NULL·7068 Sunset BlvdMIAMIFL33146N/A·NULL
TPA TPA-601732026-03-29T14:19:37ZWILLIE—WASHINGTON1952-03-19-•••-••-53196058602454UNKNOWN893 Sunset BoulevardSeattleWA98147GRP-2533OPTIONS-PPO
TPA TPA-606602026-01-10T07:34:48ZAlexis—Washington2/18/1988UNKNOWNnull—UNKNOWN4319 Camelback Road Apt 29TampaFL33696NULLN/A
TPATPA-561072026-07-08T05:28:23ZJohn—·Hill07/23/1979—null5987395817—1953 Church StreetOrlando·FL32807GRP-2933UNKNOWN
TPATPA-556202026-02-28T19:40:18ZWells, Jack··P.—1996-07-24—•••-••-7024UNKNOWN··—3646 SUNSET BOULEVARDTempeAZ85249-UNKNOWN
TPATPA-643222026-01-19T14:46:37Zvalentina—mejia16-08-1964N/A····(321) 752-4507NULL7607 Hillcrest RoadEden Prairie··MN55386GRP-1951—
TPATPA-58475 2026-06-21T23:42:56ZBenjaminQRobinson03/16/96-UNKNOWN+1 597 763 0116—625 Park PlTucsonAZ85770GRP-2332····
TPATPA-508622026-01-20T06:03:15Z·Elizabeth—Hamilton12/01/1950———N/A4500 Maple AveSeattleWA··98196—MEDICARE-ADV-A
TPATPA-531882026-08-27T18:36:58Zrihard—santos1947-06-15··UNKNOWN·UNKNOWNnull—7248 MAIN STREETMesa··Arizona85217-8038·····null
TPATPA-577762026-09-02T06:20:39ZGarrett, Jason——19780408··-··(657) 403-6234UNKNOWN··7286 Baseline RdPhoenix·AZ85081—null
TPATPA-538222026-08-05T22:11:12ZBilly—Parker1973-06-07nullnull··N/Anull1222 Baseline RdChandlerAZ··85280-1358GRP-2878-
TPATPA-591292026-06-13T10:33:42ZJulia··—Garza1951-12-07—•••-••-789012879180689NULL—NULLN/AN/AGRP-7255UNKNOWN
14,474 rows, page 8 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-19T19:54:25.427Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty