Foreign Direct Investment In India

Sector & Financial year wise time series data from 2000-2016.

@kaggle.rajanand_fdi_in_india

Table List

1 table(20.6 KB)

Fdi In India

@kaggle.rajanand_fdi_in_india.fdi_in_india

20.6 KB
63 rows
18 columns

sector Sector	n_2000_01 2000-01	n_2001_02 2001-02	n_2002_03 2002-03	n_2003_04 2003-04	n_2004_05 2004-05	n_2005_06 2005-06	n_2006_07 2006-07	n_2007_08 2007-08	n_2008_09 2008-09	n_2009_10 2009-10	n_2010_11 2010-11	n_2011_12 2011-12	n_2012_13 2012-13	n_2013_14 2013-14	n_2014_15 2014-15	n_2015_16 2015-16	n_2016_17 2016-17
METALLURGICAL INDUSTRIES	22.69	14.14	36.61	8.11	200.38	149.13	169.94	1175.75	959.94	419.88	1098.14	1786.14	1466.23	567.63	359.34	456.31	1440.18
MINING	1.32	6.52	10.06	23.48	9.92	7.4	6.62	444.36	34.16	174.4	79.51	142.65	57.89	12.73	684.39	520.67	55.75
POWER	89.42	757.44	59.11	27.09	43.37	72.69	157.15	988.68	907.66	1271.79	1271.77	1652.38	535.68	1066.08	707.04	868.8	1112.98
NON-CONVENTIONAL ENERGY			1.7	4.14	1.27	1.35	2.44	58.82	125.88	622.52	214.4	452.17	1106.52	414.25	615.95	776.51	783.57
COAL PRODUCTION				0.04		9.14	1.3	14.08	0.22					2.96
PETROLEUM & NATURAL GAS	9.35	211.07	56.78	80.64	102.78	12.09	87.71	1405.04	349.29	265.53	556.43	2029.98	214.8	112.23	1079.02	103.02	180.4
BOILERS AND STEAM GENERATING PLANTS				0.04	0.54		3.31	1.51		3.96	0.63	31.79	20.05	0.17	1.33	77.91	53.91
PRIME MOVER (OTHER THAN ELECTRICAL GENERATORS)					2.66	0.74	25.57	40.53	74.88	39.5	166.44	313.75	184.6	212.78	230.7	159.13	286.88
ELECTRICAL EQUIPMENTS	79.76	65.76	34.71	73.2	97.4	39.5	76.85	653.74	417.35	728.27	153.9	566.39	195.87	134.31	574.83	444.88	2230.69
COMPUTER SOFTWARE & HARDWARE	228.39	419.39	314.24	368.32	527.9	1359.97	2613.33	1382.25	1543.34	871.86	779.81	796.35	485.96	1126.27	2296.04	5904.36	3651.71


CREATE TABLE fdi_in_india (
  "sector" VARCHAR,
  "n_2000_01" DOUBLE,
  "n_2001_02" DOUBLE,
  "n_2002_03" DOUBLE,
  "n_2003_04" DOUBLE,
  "n_2004_05" DOUBLE,
  "n_2005_06" DOUBLE,
  "n_2006_07" DOUBLE,
  "n_2007_08" DOUBLE,
  "n_2008_09" DOUBLE,
  "n_2009_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_13" DOUBLE,
  "n_2013_14" DOUBLE,
  "n_2014_15" DOUBLE,
  "n_2015_16" DOUBLE,
  "n_2016_17" DOUBLE
);