Created
November 18, 2017 01:56
-
-
Save riceissa/3ec08bf75ada9f3d77a7fb4a46f884b9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> select count(*),metric from t1 group by metric having count(*) > 1; | |
+----------+---------------------------------------------------------------------------------------------------------------------+ | |
| count(*) | metric | | |
+----------+---------------------------------------------------------------------------------------------------------------------+ | |
| 3 | Adjusted net national income | | |
| 3 | Adjusted net national income per capita | | |
| 2 | Adjusted net savings, excluding particulate emission damage | | |
| 2 | Adjusted net savings, including particulate emission damage | | |
| 2 | Adjusted savings: carbon dioxide damage | | |
| 2 | Adjusted savings: consumption of fixed capital | | |
| 2 | Adjusted savings: education expenditure | | |
| 2 | Adjusted savings: energy depletion | | |
| 2 | Adjusted savings: mineral depletion | | |
| 2 | Adjusted savings: net forest depletion | | |
| 2 | Adjusted savings: net national savings | | |
| 2 | Adjusted savings: particulate emission damage | | |
| 2 | Agricultural land | | |
| 2 | Agricultural methane emissions | | |
| 2 | Agricultural nitrous oxide emissions | | |
| 6 | Agriculture, value added | | |
| 3 | Arable land | | |
| 2 | Average depreciation rate of the capital stock | | |
| 2 | Broad money | | |
| 2 | Capital stock at constant 2005 national prices | | |
| 3 | Capital stock at current PPPs | | |
| 2 | Central government debt, total | | |
| 3 | Changes in inventories | | |
| 5 | CO2 emissions | | |
| 2 | CO2 emissions from gaseous fuel consumption | | |
| 2 | CO2 emissions from liquid fuel consumption | | |
| 2 | CO2 emissions from solid fuel consumption | | |
| 2 | Communications, computer, etc. | | |
| 2 | Compensation of employees | | |
| 2 | Computer, communications and other services | | |
| 2 | Consumption Share of PPP Converted GDP Per Capita at 2005 constant prices [rgdpl] | | |
| 2 | Consumption Share of PPP Converted GDP Per Capita at current prices [cgdp], (%) | | |
| 4 | Contrib-ICT-K-Services | | |
| 3 | Contrib-LB-Composition | | |
| 4 | Contrib-NonICT-K-Services | | |
| 2 | Contribution-ICT-Capital | | |
| 2 | Contribution-Labor-Quality | | |
| 2 | Contribution-Labor-Quantity | | |
| 2 | Contribution-Non-ICT-Capital | | |
| 2 | Current account balance | | |
| 2 | Customs and other import duties | | |
| 2 | Discrepancy in expenditure estimate of GDP | | |
| 7 | EKS-GDP | | |
| 2 | Electricity production from renewable sources, excluding hydroelectric | | |
| 8 | Emp | | |
| 2 | EMP_g (adjusted) | | |
| 2 | EMP_g (original) | | |
| 2 | EMP-gr | | |
| 3 | Employment | | |
| 2 | Employment (adjusted) | | |
| 2 | Employment (original) | | |
| 2 | Employment to population ratio, 15+, female (%) | | |
| 2 | Employment to population ratio, 15+, male (%) | | |
| 2 | Employment to population ratio, 15+, total (%) | | |
| 3 | Employment-Growth | | |
| 3 | Exchange rate, national currency/USD (market+estimated) | | |
| 3 | Expenditure-side real GDP at chained PPPs | | |
| 3 | Expenditure-side real GDP at current PPPs | | |
| 2 | Expense | | |
| 7 | Exports of goods and services | | |
| 4 | External balance on goods and services | | |
| 2 | External debt stocks | | |
| 2 | Fertilizer consumption | | |
| 4 | Final consumption expenditure | | |
| 6 | Final consumption expenditure, etc. | | |
| 2 | Fixed broadband subscriptions | | |
| 2 | Fixed telephone subscriptions | | |
| 2 | Foreign direct investment, net inflows | | |
| 2 | Foreign direct investment, net outflows | | |
| 2 | Forest area | | |
| 9 | GDP | | |
| 2 | GDP (adjusted) | | |
| 2 | GDP (original) | | |
| 2 | GDP growth | | |
| 6 | GDP per capita | | |
| 2 | GDP per capita, PPP | | |
| 2 | GDP per unit of energy use | | |
| 3 | GDP_g (adjusted) | | |
| 3 | GDP_g (original) | | |
| 7 | GDP-capita-EKS | | |
| 7 | GDP-capita-GK | | |
| 3 | GDP-Capita-Growth | | |
| 4 | GDP-gr | | |
| 4 | GDP-growth | | |
| 2 | GDP, PPP | | |
| 6 | General government final consumption expenditure | | |
| 7 | GK-GDP | | |
| 4 | GNI | | |
| 3 | GNI per capita | | |
| 2 | GNI per capita, PPP | | |
| 2 | GNI, PPP | | |
| 2 | Goods and services expense | | |
| 2 | Government Consumption Share of PPP Converted GDP Per Capita at 2005 constant prices [rgdpl] | | |
| 2 | Government Consumption Share of PPP Converted GDP Per Capita at current prices [cgdp], (%) | | |
| 2 | Government expenditure on education, total | | |
| 2 | Grants and other revenue | | |
| 6 | Gross capital formation | | |
| 3 | Gross domestic savings | | |
| 6 | Gross fixed capital formation | | |
| 5 | Gross national expenditure | | |
| 4 | Gross savings | | |
| 4 | Gross value added at factor cost | | |
| 3 | Health expenditure, public | | |
| 2 | High-technology exports | | |
| 5 | Household final consumption expenditure | | |
| 6 | Household final consumption expenditure, etc. | | |
| 2 | Household final consumption expenditure, PPP | | |
| 3 | Human capital index, based on years of schooling and returns to education | | |
| 2 | ICT service exports | | |
| 2 | ICT-Capital-Services-gr | | |
| 4 | ICT-K-Services | | |
| 7 | Imports of goods and services | | |
| 6 | Industry, value added | | |
| 4 | Insurance and financial services | | |
| 3 | Interest payments | | |
| 2 | Interest payments on external debt | | |
| 2 | International tourism, expenditures | | |
| 2 | International tourism, receipts | | |
| 2 | Investment Share of PPP Converted GDP Per Capita at 2005 constant prices [rgdpl] | | |
| 2 | Investment Share of PPP Converted GDP Per Capita at current prices [cgdp], (%) | | |
| 2 | Labor force participation rate for ages 15-24, female (%) | | |
| 2 | Labor force participation rate for ages 15-24, male (%) | | |
| 2 | Labor force participation rate for ages 15-24, total (%) | | |
| 2 | Labor force participation rate, female (% of female population ages 15+) | | |
| 2 | Labor force participation rate, male (% of male population ages 15+) | | |
| 2 | Labor force participation rate, total (% of total population ages 15+) | | |
| 2 | Labor-Quality-gr | | |
| 2 | Labor-Quantity-gr | | |
| 4 | Labor-Share | | |
| 3 | LB-Composition | | |
| 2 | Lifetime risk of maternal death | | |
| 4 | LP | | |
| 2 | LP_L_g (adjusted) | | |
| 2 | LP_L_g (original) | | |
| 2 | LP-gr | | |
| 7 | LP-person-EKS | | |
| 7 | LP-person-GK | | |
| 3 | LP-Person-Growth | | |
| 6 | Manufacturing, value added | | |
| 2 | Market capitalization of listed domestic companies | | |
| 2 | Methane emissions | | |
| 3 | Military expenditure | | |
| 2 | Mobile cellular subscriptions | | |
| 2 | Multilateral debt service | | |
| 2 | Net acquisition of financial assets | | |
| 2 | Net current transfers from abroad | | |
| 2 | Net income from abroad | | |
| 2 | Net incurrence of liabilities, total | | |
| 2 | Net investment in nonfinancial assets | | |
| 2 | Net lending (+) / net borrowing (-) | | |
| 4 | Net ODA received | | |
| 2 | Net official development assistance and official aid received | | |
| 2 | Net official development assistance received | | |
| 3 | Net taxes on products | | |
| 2 | Nitrous oxide emissions | | |
| 2 | Nitrous oxide emissions in energy sector | | |
| 2 | Non-ICT-Capital-Services-gr | | |
| 4 | NonICT-K-Services | | |
| 3 | Number of persons engaged | | |
| 2 | Openness at 2005 constant prices (%) | | |
| 2 | Openness at Current Prices (%) | | |
| 2 | Other expense | | |
| 2 | Other taxes | | |
| 2 | Out-of-pocket health expenditure | | |
| 3 | Output-side real GDP at chained PPPs | | |
| 3 | Output-side real GDP at current PPPs | | |
| 2 | Personal remittances, received | | |
| 7 | PNG, bonds | | |
| 7 | PNG, commercial banks and other creditors | | |
| 4 | Pop | | |
| 7 | Population | | |
| 2 | Population ages 0-14, female | | |
| 2 | Population ages 0-14, male | | |
| 2 | Population ages 15-64, female | | |
| 2 | Population ages 15-64, male | | |
| 2 | Population ages 65 and above, female | | |
| 2 | Population ages 65 and above, male | | |
| 2 | Population growth | | |
| 2 | Population in urban agglomerations of more than 1 million | | |
| 3 | Population-Growth | | |
| 2 | Population, female | | |
| 2 | Population, male | | |
| 6 | PPG, bilateral | | |
| 7 | PPG, bilateral concessional | | |
| 7 | PPG, bonds | | |
| 7 | PPG, commercial banks | | |
| 6 | PPG, IBRD | | |
| 6 | PPG, IDA | | |
| 5 | PPG, multilateral | | |
| 7 | PPG, multilateral concessional | | |
| 7 | PPG, official creditors | | |
| 7 | PPG, other private creditors | | |
| 7 | PPG, private creditors | | |
| 2 | PPP Converted Domestic Absorption Per Capita, average GEKS-CPDW, at current prices | | |
| 2 | PPP Converted GDP Chain per equivalent adult at 2005 constant prices | | |
| 2 | PPP Converted GDP Chain per worker at 2005 constant prices | | |
| 2 | PPP Converted GDP Laspeyres per person counted in total employment at 2005 constant prices | | |
| 2 | PPP Converted GDP Laspeyres per worker at 2005 constant prices | | |
| 2 | PPP Converted GDP Per Capita (Chain Series), at 2005 constant prices | | |
| 2 | PPP Converted GDP Per Capita (Laspeyres), derived from growth rates ofc, g, i, at 2005 constant prices | | |
| 2 | PPP Converted GDP Per Capita (Laspeyres), derived from growth rates ofdomestic absorption, at 2005 constant prices | | |
| 2 | PPP Converted GDP Per Capita Relative to the United States, average GEKS-CPDW, at current prices, [cgdp2](US = 100) | | |
| 2 | PPP Converted GDP Per Capita Relative to the United States, G-K method, at current prices, [cgdp](US = 100) | | |
| 2 | PPP Converted GDP Per Capita, average GEKS-CPDW, at current prices | | |
| 2 | PPP Converted GDP Per Capita, G-K method, at current prices | | |
| 2 | PPP Converted Gross Domestic Income (RGDPL adjusted for Terms of Tradechanges) at 2005 constant prices | | |
| 2 | Price level of capital formation, price level of USA GDPo in 2005=1 | | |
| 2 | Price level of CGDPo (PPP/XR), price level of USA GDPo in 2005=1 | | |
| 3 | Price Level of Consumption | | |
| 2 | Price level of exports, price level of USA GDPo in 2005=1 | | |
| 2 | Price Level of GDP, average of GEKS-CPDW (US = 100) | | |
| 2 | Price Level of GDP, G-K method (US = 100) | | |
| 2 | Price Level of Government Consumption | | |
| 2 | Price level of government consumption, price level of USA GDPo in 2005=1 | | |
| 2 | Price level of household consumption, price level of USA GDPo in 2005=1 | | |
| 2 | Price level of imports, price level of USA GDPo in 2005=1 | | |
| 3 | Price Level of Investment | | |
| 2 | Price level of the capital stock, price level of USA in 2005=1 | | |
| 2 | Public and publicly guaranteed debt service | | |
| 2 | Ratio of female to male labor force participation rate (%) | | |
| 2 | Ratio of GNP to GDP (%) | | |
| 2 | Real consumption of households and government, at current PPPs | | |
| 2 | Real domestic absorption, (real consumption plus investment), at current PPPs | | |
| 2 | Real GDP at constant 2005 national prices | | |
| 2 | Revenue, excluding grants | | |
| 2 | Rural population | | |
| 2 | Secondary education, general pupils | | |
| 2 | Secondary education, pupils | | |
| 2 | Secondary education, vocational pupils | | |
| 2 | Secure Internet servers | | |
| 6 | Services, etc., value added | | |
| 3 | Share of government consumption at current PPPs | | |
| 3 | Share of gross capital formation at current PPPs | | |
| 3 | Share of household consumption at current PPPs | | |
| 3 | Share of labour compensation in GDP at current national prices | | |
| 3 | Share of merchandise exports at current PPPs | | |
| 3 | Share of merchandise imports at current PPPs | | |
| 3 | Share of residual trade and GDP statistical discrepancy at current PPPs | | |
| 3 | Short-term debt | | |
| 2 | Social contributions | | |
| 2 | Stocks traded, total value | | |
| 2 | Subsidies and other transfers | | |
| 2 | Tax revenue | | |
| 2 | Taxes on exports | | |
| 3 | Taxes on goods and services | | |
| 3 | Taxes on income, profits and capital gains | | |
| 2 | Taxes on international trade | | |
| 8 | TFP | | |
| 2 | TFP at constant national prices (2005=1) | | |
| 3 | TFP level at current PPPs (USA=1) | | |
| 2 | TFP-growth | | |
| 2 | TFPG (adjusted) | | |
| 2 | TFPG (original) | | |
| 2 | Total debt service | | |
| 2 | Total greenhouse gas emissions | | |
| 2 | Total PPP Converted GDP, G-K method, at current prices | | |
| 2 | Total reserves | | |
| 4 | Transport services | | |
| 4 | Travel services | | |
| 2 | Unemployment, female (% of female labor force) | | |
| 2 | Unemployment, male (% of male labor force) | | |
| 2 | Unemployment, total (% of total labor force) | | |
| 2 | Unemployment, youth female (% of female labor force ages 15-24) | | |
| 2 | Unemployment, youth male (% of male labor force ages 15-24) | | |
| 2 | Unemployment, youth total (% of total labor force ages 15-24) | | |
| 2 | Urban population | | |
| 2 | Welfare-relevant TFP levels at current PPPs (USA=1) | | |
| 4 | XR-GDP | | |
+----------+---------------------------------------------------------------------------------------------------------------------+ | |
268 rows in set (0.07 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment