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 - Flattened Table Indexed By Country-year.

@owid.faostat_cisp.owid_faostat_cisp_flat

607.8 KB
5631 rows
31 columns

country Country	year Year	area_code Area Code	agriculture_forestry_fishing_general_government_000231_d31746ed Agriculture, Forestry, Fishing, General Government, 00023131, Agriculture Orientation Index Usd, 006159	agriculture_forestry_fishing_general_government_000231_0d516b88 Agriculture, Forestry, Fishing, General Government, 00023131, Share Of Total Usd, 006139, Percent	agriculture_forestry_fishing_general_government_000231_2c3c6004 Agriculture, Forestry, Fishing, General Government, 00023131, Value Usd, 006110, Million Us Dollar	agriculture_forestry_fishing_general_government_000231_2da30fa8 Agriculture, Forestry, Fishing, General Government, 00023131, Value Usd, 2015 Prices, 061840, Million Us Dollar	credit_to_agriculture_forestry_and_fishing_00023068_ag_def23309 Credit To Agriculture, Forestry And Fishing, 00023068, Agriculture Orientation Index Usd, 006159	credit_to_agriculture_forestry_and_fishing_00023068_sh_97b4b00b Credit To Agriculture, Forestry And Fishing, 00023068, Share Of Total Usd, 006139, Percent	credit_to_agriculture_forestry_and_fishing_00023068_va_750d236c Credit To Agriculture, Forestry And Fishing, 00023068, Value Usd, 006110, Million Us Dollar	credit_to_agriculture_forestry_and_fishing_00023068_va_442cf25f Credit To Agriculture, Forestry And Fishing, 00023068, Value Usd, 2015 Prices, 061840, Million Us Dollar	dfa_disbursement_to_agriculture_forestry_and_fishing_0_59832147 Dfa Disbursement To Agriculture, Forestry And Fishing, 00023070, Agriculture Orientation Index Usd, 006159	dfa_disbursement_to_agriculture_forestry_and_fishing_0_c2a47f94 Dfa Disbursement To Agriculture, Forestry And Fishing, 00023070, Annual Growth Usd, 006129, Percent	dfa_disbursement_to_agriculture_forestry_and_fishing_0_84a682d4 Dfa Disbursement To Agriculture, Forestry And Fishing, 00023070, Share Of Total Usd, 006139, Percent	dfa_disbursement_to_agriculture_forestry_and_fishing_0_04e36a5b Dfa Disbursement To Agriculture, Forestry And Fishing, 00023070, Value Usd, 006110, Million Us Dollar	dfa_disbursement_to_agriculture_forestry_and_fishing_0_81d6ed98 Dfa Disbursement To Agriculture, Forestry And Fishing, 00023070, Value Usd, 2022 Prices, 062290, Million Us Dollar	gross_fixed_capital_formation_agriculture_forestry_and_2c045dcd Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Agriculture Orientation Index Usd, 006159	gross_fixed_capital_formation_agriculture_forestry_and_73e46062 Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Annual Growth Usd, 006129, Percent	gross_fixed_capital_formation_agriculture_forestry_and_c2b030dd Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Share Of Total Usd, 006139, Percent	gross_fixed_capital_formation_agriculture_forestry_and_dfd17684 Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Share Of Value Added Usd, 006161, Percent	gross_fixed_capital_formation_agriculture_forestry_and_64be0cb6 Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Value Usd, 006110, Million Us Dollar	gross_fixed_capital_formation_agriculture_forestry_and_1604c233 Gross Fixed Capital Formation, Agriculture, Forestry And Fishing, 00022030, Value Usd, 2015 Prices, 061840, Million Us Dollar	value_added_agriculture_forestry_and_fishing_00022016__3dab9fc2 Value Added, Agriculture, Forestry And Fishing, 00022016, Annual Growth Usd, 006129, Percent	value_added_agriculture_forestry_and_fishing_00022016__de58b1df Value Added, Agriculture, Forestry And Fishing, 00022016, Share Of Total Usd, 006139, Percent	value_added_agriculture_forestry_and_fishing_00022016__0f6c2b0a Value Added, Agriculture, Forestry And Fishing, 00022016, Value Usd, 006110, Million Us Dollar	value_added_agriculture_forestry_and_fishing_00022016__6fb670e2 Value Added, Agriculture, Forestry And Fishing, 00022016, Value Usd, 2015 Prices, 061840, Million Us Dollar
Afghanistan	2001	2									0.02308100089430809		1.2290079593658447	2.7240800857543945	4.543078899383545	0.39483100175857544		21.345794677734375	5.249176979064941	102.11978912353516	358.95068359375		53.24675369262695	1927.8121337890625	2872.47509765625
Afghanistan	2002	2									0.022082999348640442	226.2353515625	0.9532399773597717	8.88691234588623	14.199618339538574	0.43939000368118286	-5.545236110687256	19.83159637451172	5.160199165344238	96.45700073242188	457.0898132324219	-4.04896879196167	43.166229248046875	1849.755615234375	3842.257568359375
Afghanistan	2003	2	0.1270889937877655	5.32548713684082							0.03845899924635887	125.86375427246094	1.5921059846878052	20.07231330871582	26.014705657958984	0.4575279951095581	6.907853126525879	19.17200469970703	5.203794002532959	103.12010955810547	481.79559326171875	9.634140014648438	41.3972282409668	2027.963623046875	3976.2998046875
Afghanistan	2004	2	0.40741100907325745	14.509098052978516							0.07882999628782272	136.7268829345703	2.6673378944396973	47.516563415527344	62.91865539550781	0.36406201124191284	6.727934837341309	12.965302467346191	5.735189914703369	110.05796813964844	388.513671875	-8.164681434631348	33.83652114868164	1862.3868408203125	3404.06982421875
Afghanistan	2005	2	0.1332709938287735	4.684162139892578							0.158283993601799	213.60606384277344	5.555456161499023	149.0148162841797	204.61131286621094	0.3116160035133362	21.22553253173828	10.952542304992676	6.102252006530762	133.41835021972656	345.69140625	22.025426864624023	35.097957611083984	2272.58544921875	3823.5244140625
Afghanistan	2006	2	0.13621999323368073	4.685078144073486	104.41999816894531	153.10960388183594					0.06957100331783295	-56.76140213012695	2.348875045776367	64.43191528320312	75.00859832763672	0.2985450029373169	19.04060935974121	10.267951965332031	6.499645233154297	158.822021484375	313.8748779296875	8.345722198486328	33.76231384277344	2462.249267578125	4120.1689453125
Afghanistan	2007	2	0.21127699315547943	7.450864791870117	246.11000061035156	334.07147216796875					0.059664998203516006	20.458709716796875	2.0910239219665527	77.61386108398438	86.005859375	0.34992799162864685	28.20614242553711	12.340547561645508	6.134436130523682	203.6195831298828	385.6397705078125	42.32456970214844	35.04618453979492	3504.3857421875	4996.34326171875
Afghanistan	2008	2	0.09614899754524231	2.971426010131836	275.989990234375	340.6473083496094	0.004207000136375427	0.12999999523162842	1.0348340272903442	1.277250051498413	0.17574800550937653	202.36892700195312	5.125957012176514	234.68019104003906	288.1696472167969	0.3732700049877167	-8.334272384643555	11.535725593566895	5.899781227111816	186.64938354492188	345.249755859375	-14.30640697479248	29.166582107543945	3003.033935546875	4414.84716796875
Afghanistan	2009	2	0.12984800338745117	4.2571492195129395	380.6099853515625	459.8152770996094					0.24820199608802795	92.34647369384766	8.185202598571777	451.3990478515625	569.4583129882812	0.39621299505233765	19.628713607788086	12.99007511138916	5.873583793640137	223.2862548828125	549.0204467773438	31.027433395385742	32.97795867919922	3934.79833984375	5449.17919921875
Afghanistan	2010	2	0.1514499932527542	4.681899070739746	603.8699951171875	605.7047119140625	0.0284659992903471	0.8799999952316284	12.057221412658691	12.093865394592285	0.29658401012420654	27.03575897216797	8.799072265625	573.438232421875	697.919921875	0.4002059996128082	17.31110191345215	12.371895790100098	5.764529228210449	261.9395446777344	455.8365783691406	14.18889045715332	29.66807746887207	4493.1025390625	4471.1279296875


CREATE TABLE owid_faostat_cisp_flat (
  "country" VARCHAR,
  "year" INTEGER,
  "area_code" VARCHAR,
  "agriculture_forestry_fishing_general_government_000231_d31746ed" FLOAT,
  "agriculture_forestry_fishing_general_government_000231_0d516b88" FLOAT,
  "agriculture_forestry_fishing_general_government_000231_2c3c6004" FLOAT,
  "agriculture_forestry_fishing_general_government_000231_2da30fa8" FLOAT,
  "credit_to_agriculture_forestry_and_fishing_00023068_ag_def23309" FLOAT,
  "credit_to_agriculture_forestry_and_fishing_00023068_an_c4e436e8" FLOAT,
  "credit_to_agriculture_forestry_and_fishing_00023068_sh_97b4b00b" FLOAT,
  "credit_to_agriculture_forestry_and_fishing_00023068_va_750d236c" FLOAT,
  "credit_to_agriculture_forestry_and_fishing_00023068_va_442cf25f" FLOAT,
  "dfa_disbursement_to_agriculture_forestry_and_fishing_0_59832147" FLOAT,
  "dfa_disbursement_to_agriculture_forestry_and_fishing_0_c2a47f94" FLOAT,
  "dfa_disbursement_to_agriculture_forestry_and_fishing_0_84a682d4" FLOAT,
  "dfa_disbursement_to_agriculture_forestry_and_fishing_0_04e36a5b" FLOAT,
  "dfa_disbursement_to_agriculture_forestry_and_fishing_0_81d6ed98" FLOAT,
  "fdi_inflows_to_agriculture_forestry_and_fishing_000230_26e2fc92" FLOAT,
  "fdi_inflows_to_agriculture_forestry_and_fishing_000230_7c0313a1" FLOAT,
  "fdi_inflows_to_agriculture_forestry_and_fishing_000230_b09ac5c7" FLOAT,
  "fdi_inflows_to_agriculture_forestry_and_fishing_000230_bdfcd369" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_2c045dcd" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_73e46062" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_c2b030dd" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_dfd17684" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_64be0cb6" FLOAT,
  "gross_fixed_capital_formation_agriculture_forestry_and_1604c233" FLOAT,
  "value_added_agriculture_forestry_and_fishing_00022016__3dab9fc2" FLOAT,
  "value_added_agriculture_forestry_and_fishing_00022016__de58b1df" FLOAT,
  "value_added_agriculture_forestry_and_fishing_00022016__0f6c2b0a" FLOAT,
  "value_added_agriculture_forestry_and_fishing_00022016__6fb670e2" FLOAT
);