# 问题描述

Instead, they could have compared philanthropy funds and flows versus public and private sector funds and flows in China and in the World.

Add more information about funds of climate philanthropy vs. private sectors. We can add two analyses here: first, some of the data can be obtained from 2020年中国企业慈善发展报告; second, we can do a preliminary analysis of different donors, differentiating regions, ownership, etc.

1. 如何定义public sector 和 private sector ？
2. 我们文章中关于 philanthropy funds and flows in China的数据按照上述定义划分是什么结果？public sector 和 private sector 的投入分别是多少？进行对比分析
3. 怎么找到 philanthropy funds and flows in World 在public sector 和 private sector 的数据？
4. 对比China和World的数据结果可以发现什么？

# 如何定义public secor 和 private sector ？

Public Sector Private Sector
Definition
Public sector organisations are owned, controlled and managed by the government or other state-run bodies. Private sector organisations are owned, controlled and managed by individuals, groups or business entities.
Ownership
The ownership of the public sector units can be by central, state or local government bodies, and this ownership is either full or partial. The ownership of private sector units is by individuals or entities with zero interference from the government.
Motive
The main motive of public sector organisations is to engage in activities that serve the general public. The main motive of the private sector is to earn profits from their business operations.
Source of Capital
The capital for public sector undertakings comes from tax collections, excise and other duties, bonds, treasury bills etc. The capital for private sector entities comes either from its owners or through loans, issuing shares and debentures, etc.
Employment Benefits
Public sector units provide several employment benefits like job security, housing facilities, allowances and retirement benefits. Private sector units offer benefits like higher salary packages, better chances of promotion and recognition, competitive environment and greater incentives in terms of bonus and other benefits.
Stability
Jobs within the public sector are very stable since the chances of getting sacked due to non-performance are very low. Jobs within the private sector are not very secure since non-performance can lead to sacking. Companies can also fire people in case of cost cutting or scaling down of operations.
Promotions
The criteria for promotion in the public sector units is generally based on the seniority of the employee. The criteria for promotion in the private sector units is generally based on the merit and job performance of the employee.
Areas
Some of the main areas that come under the public sector are police, military, mining, manufacturing, healthcare, education, transport, banking, etc. Some of the main areas that come under the private sector are information technology, finance, fast moving consumer goods, construction, hospitality, pharmaceuticals, etc.

• 公共部门是指由公共服务国有企业所组成的经济部分[1]。公共服务是面向全社会的服务，任何人都有权利免费使用。国有企业是公有制下的自负盈亏的商业企业，它们一般销售各种非公共商品和服务。公共部门之外还有私营部门第三部门。私营部门由旨在为私人企业主赚取利润的经济部门所组成。而第三部门则是由民间社会所开设的非营利组织所组成。
• 私营部门经济的一部分，有时被称为公民部门（英语：citizen sector），由个人或私人团体拥有，而不是由国家所有，与之相对的是公共部门。私营部门分为两个子部门：家庭部门和私营企业部门。前者从事个人消费活动，后者从事私人投资生产；前者的目标是个人或家庭效用最大化，后者的目标是利润最大化。私营部门经济行为的共同特点是其活动依赖于个人收入和个人资产。

We define the public sector as NACE Code L, which is “Public Administration and defence, compulsory social security” (Public Administration for short). The remaining NACE categories are defined as private and we conduct most of our analysis in these terms. However, in light of the fact that, in some countries, some portion of the health and education sectors is public, we pay special attention to NACE categories M (Education), and N (Health, social work). There is no public sector indicator in the data and it is, therefore, impossible to define and analyse the broader public sector with precision. In our sample, for most countries, the health and education sectors have a pay disadvantage, suggesting that policy concern should be focused on Public Administration relative to the remaining sectors.

It is, therefore, impossible to delineate the public and private sectors solely on functional grounds, since nearly all functions undertaken by government are also performed by the private sector.

The concept of ownership is crucial for defining the public and private sectors.

This category can be subdivided into an American and a European view (though no neat geographical division exists). The former sees the third sector as a discrete sector characterized by certain qualities such as civility, whereas European theorists tend to take “the hybrid view” that views third sector organizations essentially as mixtures of other kinds of social organization such as private and public, or hierarchic and anarchic. The second approach conceives of the third sector not as an object out there waiting to be authoritatively defined but as a kind of societal process.

Most ontological accounts of the third sector place it in relation to the state and the market. For Etzioni, who coined the term “the third sector” in 1973, in his “The third sector and domestic missions,” it was an alternative sector separate from and balancing the state and the market, themselves considered separate sectors. If something is ruled neither primarily by market logic nor via a bureaucratic chain of command, it must be part of the “third” sector. Many current operational definitions follow this basic schema. For the British government, for example, “The term is used to distinguish such organisations from the other two sectors of the economy: the public sector (‘government’) and the private sector (‘businesses’)” (NAO 2009). According to a new textbook on social enterprises, a national economy can be conceptualized as having three sectors: the public sector, a private economy, and a third sector “with organisations established by people on a voluntary basis to pursue social or community goals” (Ridley-Duff and Seanor 2008, p. 1). This view is not restricted geographically to the United States – even though it has been widely associated strongly with researchers at The Johns Hopkins University in Baltimore, Maryland (Salamon and Anheier 1997).

In contrast, a “European” definition of the third sector does not envisage separate sectors. The third sector or third system is thus conceived not as a corrective addon to the blind spots of a market economy, but as a hybrid form of various kinds of organizations such as firms, bureaucracies, and kinship associations that “act as hybrids, intermeshing different resources and connecting different areas, rather than setting clear demarcation lines around a sector and mapping its size” (Evers 1995, p. 160).

If an extrabudgetary entity is producing market output, it fulfills the GFSM2001 criterion to be a market establishment. Market establishments that have: (1) complete accounting records about it production activities, but not (2) a complete balance sheet, nor (3) the ability to engage in financial transactions in its own name, are deemed to belong to “general government”. Market establishments that also satisfy the last two qualities are deemed to be quasi-corporations and, as such, would belong to the public corporation sector. For example, government-owned universities or public hospitals that are market producers—i.e., charge fees based on the costs of producing the services or that are sufficiently high to have a significant impact on the demand for services provided—would be classified as institutional units of the general government sector, not the nonfinancial corporations sector, when it has accounting records of its output and costs of production, but does not satisfy criteria (2) and (3) above.

# Data in China

• 公司：需区分国有和私有企业
• 自然人：私有部门
• 高校：需区分公立学校和私立学校
• 社会组织和红十字会：第三部门
• 政府：公有部门

• 用wind下载一下所有上市国企的名单（数据浏览器 -提取所有A股-有个「公司属性」的字段）。提取出来后再匹配的数据，再分析结果怎么样。
• 通过爬虫，批量查询天眼查，抓取天眼查中公司的类型【OK】

1、进行精确匹配：结果发现很多NA，匹配不上

=VLOOKUP(A2,'/Users/fubo/Desktop/气候变化/[全_20210829所有主体桑基图数据.xlsx]company_0730'!B:Q,16,0)}


2、进行近似匹配，规则很复杂，参考这里（注意，使用的是数组公式，F2进入编辑模式，然后使用ECS快捷键），基本将捐赠人公司跟所爬取的公司匹配成功

=INDIRECT("A"&RIGHT(MAX(MMULT(ISNUMBER(FIND(MID(C2,TRANSPOSE(ROW(INDIRECT("1:"&LEN(C2)))),1),A2:A10875))*1,ROW(INDIRECT("1:"&LEN(C2)))^0)/1%%%+ROW(A2:A10875)),5))


3、vlookup匹配公司类型

=VLOOKUP(C2,'/Users/fubo/Desktop/气候变化/[全_20210829所有主体桑基图数据.xlsx]company_0730'!B:Q,16,0)


4、类型中出现“国有”或者“基层工会”，则归类为公共部门（1），否则为私有部门（0）

=SUMPRODUCT(--ISNUMBER(SEARCH(L4:L5,E2)))


5、通过数据透视表得到金额比例；

## 发送评论编辑评论

|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
（╯‵□′）╯︵┴─┴
￣﹃￣
(/ω＼)
∠( ᐛ 」∠)＿
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ｀)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ(￣∇￣o)
ヾ(´･ ･｀｡)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò｡)
Σ(っ °Д °;)っ
( ,,´･ω･)ﾉ"(´っω･｀｡)
╮(╯▽╰)╭
o(*////▽////*)q
＞﹏＜
( ๑´•ω•) "(ㆆᴗㆆ)

Emoji