sources
Data license: CC-BY
1 row where datasetId = 5012 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 |
---|---|---|---|---|---|---|---|---|
17743 | Investment: Foreign Direct Investment (FDI) | { "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "13-Feb-2020", "additionalInfo": "FDI is an investment which aims to acquire a lasting management influence (10 percent or more of the voting stock) in an enterprise operating in a foreign economy. FDI involves both the initial transaction between the two entities and all subsequent transactions between them and among affiliated enterprises, both incorporated and unincorporated. FDI may be undertaken by individuals, as well as business entities.The foreign direct investor most often is aiming to gain access to natural resources, to markets, to labour supply, to technology, to ensure security of supplies or to control the quality of a certain product. FDI can be decomposed into two types of investments: mergers and acquisitions (MA) and greenfield investments. The latter type results in the creation of new entities and the setting up of offices, buildings, plants or factories from scratch in a foreign economy. FDI stocks usually represent the book value or historical costs of assets. Insufficient data often prevents calculating FDI stocks at market value. FDI is the sum of equity capital, reinvested earnings and other FDI capital.Equity capital comprises equity in branches, all shares in subsidiaries and associates (except non-participating, preferred shares that are treated as debt securities and are included under other FDI capital) and other contributions such as the provision of machinery.Reinvested earnings consist of the direct investor's share (in proportion to equity participation) of earnings not distributed by the direct investment enterprise. Other FDI capital (loans) includes the borrowing and lending of funds, including debt securities and trade credits between direct investors and direct investment enterprises.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)", "dataPublisherSource": "UNCTAD data are based on the official data reported to UNCTAD through the submission of local entreprises surveys by national authorities. INTRACEN collects its data through UNCTAD and the UN COMTRADE.Data from UNCTAD (FDI for the whole economy) and INTRACEN are available to the public. OECD collects FDI statistics from its member countries through statistical surveys.UNCTAD data for AFF and FBT was provided by UNCTAD as it is not available to the public." } |
2020-02-14 02:14:49 | 2020-02-14 02:14:49 | Investment: Foreign Direct Investment (FDI) 5012 | FDI is an investment which aims to acquire a lasting management influence (10 percent or more of the voting stock) in an enterprise operating in a foreign economy. FDI involves both the initial transaction between the two entities and all subsequent transactions between them and among affiliated enterprises, both incorporated and unincorporated. FDI may be undertaken by individuals, as well as business entities.The foreign direct investor most often is aiming to gain access to natural resources, to markets, to labour supply, to technology, to ensure security of supplies or to control the quality of a certain product. FDI can be decomposed into two types of investments: mergers and acquisitions (MA) and greenfield investments. The latter type results in the creation of new entities and the setting up of offices, buildings, plants or factories from scratch in a foreign economy. FDI stocks usually represent the book value or historical costs of assets. Insufficient data often prevents calculating FDI stocks at market value. FDI is the sum of equity capital, reinvested earnings and other FDI capital.Equity capital comprises equity in branches, all shares in subsidiaries and associates (except non-participating, preferred shares that are treated as debt securities and are included under other FDI capital) and other contributions such as the provision of machinery.Reinvested earnings consist of the direct investor's share (in proportion to equity participation) of earnings not distributed by the direct investment enterprise. Other FDI capital (loans) includes the borrowing and lending of funds, including debt securities and trade credits between direct investors and direct investment enterprises. | 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");