Investment: Country Investment Statistics Profile

@owid.faostat_cisp

Table List

2 tables(1.53 MB)

Investment: Country Investment Statistics Profile - Flattened Table Indexed By Country-year.

Investment: Country Investment Statistics Profile

@owid.faostat_cisp.owid_faostat_cisp

961.94 KB
102273 rows
18 columns

area_code Area Code	year Year	item_code Item Code	element_code Element Code	value Value	fao_element Fao Element	fao_item Fao Item	fao_unit_short_name Fao Unit Short Name	fao_country Fao Country	flag Flag	item Item	element Element	unit Unit	unit_short_name Unit Short Name	country Country	population_with_data Population With Data
1	2001	00022016	006110	542.2963256835938	Value US$	Value Added (Agriculture, Forestry and Fishing)	million USD	Armenia	X	Value Added (Agriculture, Forestry and Fishing)	Value US$	million US Dollar	million USD	Armenia	3084300
1	2001	00022016	006139	24.004884719848633	Share of Total US$	Value Added (Agriculture, Forestry and Fishing)	%	Armenia	X	Value Added (Agriculture, Forestry and Fishing)	Share of Total US$	Percent	%	Armenia	3084300
1	2001	00022016	061840	805.0264892578125	Value US$, 2015 prices	Value Added (Agriculture, Forestry and Fishing)	million USD	Armenia	X	Value Added (Agriculture, Forestry and Fishing)	Value US$, 2015 prices	million US Dollar	million USD	Armenia	3084300
1	2001	00022030	006110	36.09341812133789	Value US$	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	million USD	Armenia	I	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	Value US$	million US Dollar	million USD	Armenia	3084300
1	2001	00022030	006139	9.017616271972656	Share of Total US$	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	%	Armenia	I	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	Share of Total US$	Percent	%	Armenia	3084300
1	2001	00022030	006159	0.3756580054759979	Agriculture orientation index US$	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)		Armenia	I	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	Agriculture orientation index US$			Armenia	3084300
1	2001	00022030	006161	6.655663013458252	Share of Value Added US$	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	%	Armenia	E	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	Share of Value Added US$	Percent	%	Armenia	3084300
1	2001	00022030	061840	72.70040893554688	Value US$, 2015 prices	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	million USD	Armenia	I	Gross Fixed Capital Formation (Agriculture, Forestry and Fishing)	Value US$, 2015 prices	million US Dollar	million USD	Armenia	3084300
1	2001	00023068	006110	16.930953979492188	Value US$	Credit to Agriculture, Forestry and Fishing	million USD	Armenia	A	Credit to Agriculture, Forestry and Fishing	Value US$	million US Dollar	million USD	Armenia	3084300
1	2001	00023068	006139	15.957212448120117	Share of Total US$	Credit to Agriculture, Forestry and Fishing	%	Armenia	A	Credit to Agriculture, Forestry and Fishing	Share of Total US$	Percent	%	Armenia	3084300


CREATE TABLE owid_faostat_cisp (
  "area_code" VARCHAR,
  "year" INTEGER,
  "item_code" VARCHAR,
  "element_code" VARCHAR,
  "value" FLOAT,
  "fao_element" VARCHAR,
  "fao_item" VARCHAR,
  "fao_unit_short_name" VARCHAR,
  "fao_country" VARCHAR,
  "flag" VARCHAR,
  "item" VARCHAR,
  "item_description" VARCHAR,
  "element" VARCHAR,
  "unit" VARCHAR,
  "element_description" VARCHAR,
  "unit_short_name" VARCHAR,
  "country" VARCHAR,
  "population_with_data" BIGINT
);