sources
Data license: CC-BY
1 row where datasetId = 5033 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
17764 | Investment: Government Expenditure | { "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "13-Feb-2020", "additionalInfo": "In the GFS framework, Expenditures are defined as Expenses plus the Net investment in non-financial assets, and are grouped according to the COFOG categories. Expenses are those transactions that imply a decrease of the net worth. Net investment in non-financial assets, instead, are those transactions that affect the stock of non-financial assets without changing the net worth.Expenditures are classified according to COFOG. In particular, the COFOG categories included are:Agriculture (Includes Crops and Livestock) - COFOG 0421:\u2022 Administration of agricultural affairs and services; conservation, reclamation or expansion of arable land; agrarian reform and land settlement; supervision and regulation of the agricultural industry;\u2022 Construction or operation of flood control, irrigation and drainage systems, including grants, loans or subsidies for such works;\u2022 Operation or support of programs or schemes to stabilize or improve farm prices and farm incomes; operation or support of extension services or veterinary services to farmers, pest control services, crop inspection services and crop grading services;\u2022 Production and dissemination of general information, technical documentation and statistics on agricultural affairs and services;\u2022 Compensation, grants, or subsidies to farmers in connection with agricultural activities, including payments for restricting or encouraging output of a particular crop or for allowing land to remain uncultivated.Excludes: multi-purpose development projects, such as the development of integrated facilities for flood control and irrigation, which would fall under code 0474.Forestry - COFOG 0422:\u2022 Administration of forestry affairs and services; conservation, extension, and rationalized exploitation of forest reserves; supervision and regulation of forest operations and issuance of tree-felling licenses;\u2022 Operation or support of reforestation work, pest and disease control, forest firefighting and fire prevention services, and extension services to forest operators;\u2022 Production and dissemination of general information, technical documentation, and statistics on forestry affairs and services;\u2022 Grants, loans, or subsidies to support commercial forest activities.Includes: forest crops in addition to timber.Fishing and hunting - COFOG 0423: \u2022 Administration of fishing affairs and services; protection, propagation and rationalised exploitation of fish stocks; supervision and regulation of freshwater fishing, coastal fishing, ocean fishing, fish farming and issuance of fishing licenses;\u2022 Operation or support of fish hatcheries, extension services, or stocking activities, etc.;\u2022 Production and dissemination of general information, technical documentation and statistics on fishing affairs and services;\u2022 Grants, loans or subsidies to support commercial fishing and hunting activities, including the construction or operation of fish hatcheries.Excludes: control of offshore and ocean fishing (0310).RD Agriculture, forestry, fishing, and hunting - COFOG 0482:\u2022 Administration and operation of government agencies engaged in applied research and experimental development related to agriculture, forestry, fishing, and hunting;\u2022 Grants, loans, or subsidies to support applied research and experimental development related to agriculture, forestry, fishing, and hunting undertaken by nongovernment bodies, such as research institutes and universities.Excludes: basic research (0140).Agriculture, Forestry, Fishing - COFOG 042:It is equal to the sum of the classes Agriculture (0421), Forestry (0422), Fishing and hunting (0423).Environmental Protection - COFOG 05.It includes:\u2022Waste management - COFOG 051,\u2022Waste water management - COFOG 052,\u2022Pollution Abatement - COFOG 053,\u2022Protection of biodiversity and landscape - COFOG 054,\u2022RD Environmental Protection - COFOG 055,\u2022Environmental Protection n.e.c. - COFOG 056.Recurrent expenditure refers to Expense.Capital expenditure refers to Net Investment in Non-Financial Assets.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)", "dataPublisherSource": "Countries report their data to FAO through the annual questionnaire on Government Expenditure n Agriculture. Missing data/fields may be supplemented with official statistics from FAO member countries, or by data published by the IMF or Eurostat." } |
2020-02-14 02:51:31 | 2020-02-14 02:51:31 | Investment: Government Expenditure 5033 | In the GFS framework, Expenditures are defined as Expenses plus the Net investment in non-financial assets, and are grouped according to the COFOG categories. Expenses are those transactions that imply a decrease of the net worth. Net investment in non-financial assets, instead, are those transactions that affect the stock of non-financial assets without changing the net worth.Expenditures are classified according to COFOG. In particular, the COFOG categories included are:Agriculture (Includes Crops and Livestock) - COFOG 0421:• Administration of agricultural affairs and services; conservation, reclamation or expansion of arable land; agrarian reform and land settlement; supervision and regulation of the agricultural industry;• Construction or operation of flood control, irrigation and drainage systems, including grants, loans or subsidies for such works;• Operation or support of programs or schemes to stabilize or improve farm prices and farm incomes; operation or support of extension services or veterinary services to farmers, pest control services, crop inspection services and crop grading services;• Production and dissemination of general information, technical documentation and statistics on agricultural affairs and services;• Compensation, grants, or subsidies to farmers in connection with agricultural activities, including payments for restricting or encouraging output of a particular crop or for allowing land to remain uncultivated.Excludes: multi-purpose development projects, such as the development of integrated facilities for flood control and irrigation, which would fall under code 0474.Forestry - COFOG 0422:• Administration of forestry affairs and services; conservation, extension, and rationalized exploitation of forest reserves; supervision and regulation of forest operations and issuance of tree-felling licenses;• Operation or support of reforestation work, pest and disease control, forest firefighting and fire prevention services, and extension services to forest operators;• Production and dissem… | http://www.fao.org/faostat/en/?#data/ | Food and Agriculture Organization of the United Nations (FAO) (2020) |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");