Wheat Production Statistics
International Wheat Production Statistics
@kaggle.rajkumarpandey02_wheat_production_statistics
International Wheat Production Statistics
@kaggle.rajkumarpandey02_wheat_production_statistics.international_wheat_production_statistics
- 23.55 KB
- 42 rows
- 27 columns
unnamed_0Unnamed: 0 | countryCountry | n_2020_12020[1] | n_2019_12019[1] | n_2018_12018[1] | n_2017_12017[1] | n_2016_12016[1] | n_2015_22015[2] | n_2014_32014[3] | n_2013_42013[4] | n_2012_52012[5] | n_2011_52011[5] | n_2010_52010[5] | n_2009_52009[5] | n_2008_52008[5] | n_2007_52007[5] | n_2006_52006[5] | n_2005_62005 [6] | n_2004_62004[6] | n_2003_62003[6] | n_20022002 | n_20012001 | n_20002000 | n_19991999 | n_19981998 | n_19971997 | n_19961996 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| China | 134.3 | 133.6 | 131.4 | 134.3 | 131.7 | 130.2 | 126.2 | 121.7 | 125.6 | 117.4 | 115.2 | 115.1 | 112.5 | 109.9 | 104.5 | 96.3 | 91.6 | 86.5 | 90.3 | 93.9 | 99.7 | 113.9 | 109.7 | 123.3 | 110.6 | |
| 1 | India | 107.6 | 103.6 | 99.7 | 98.5 | 93.5 | 86.5 | 94.5 | 93.5 | 94.9 | 86.9 | 80.7 | 80.7 | 78.6 | 74.9 | 69.4 | 72 | 72.1 | 65.1 | 72.8 | 69.7 | 76.4 | 70.8 | 65.9 | 69.4 | 62.6 |
| 2 | Russia | 85.9 | 74.5 | 72.1 | 85.9 | 73.3 | 61.8 | 59.7 | 52.1 | 37.7 | 56.2 | 41.5 | 61.7 | 63.7 | 49.4 | 45 | 47.6 | 45.4 | 34.1 | 50.6 | 47 | 34.5 | 31 | 27 | 44.3 | 34.9 |
| 3 | United States | 49.7 | 52.3 | 51.3 | 47.3 | 62.9 | 55.8 | 55.4 | 60.0 | 61.8 | 54.4 | 60.1 | 60.3 | 68 | 53.6 | 57.3 | 57.1 | 58.7 | 63.8 | 44.1 | 53.3 | 60.8 | 62.7 | 69.4 | 67.5 | 62 |
| 4 | Canada | 35.2 | 32.3 | 31.8 | 30.0 | 30.5 | 27.6 | 29.3 | 37.5 | 27.0 | 25.3 | 23.2 | 26.8 | 28.6 | 20.6 | 27.3 | 25.6 | 25.9 | 23.6 | 16.2 | 20.6 | 26.8 | 26.9 | 24.1 | 24.3 | 29.8 |
| 5 | France | 30.1 | 40.6 | 35.8 | 36.9 | 29.5 | 42.8 | 39.0 | 38.6 | 40.3 | 38.0 | 38.2 | 38.3 | 39 | 33.2 | 35.4 | 36.9 | 39.7 | 30.5 | 38.9 | 31.5 | 37.5 | 37.2 | 39.8 | 33.9 | 35.9 |
| 6 | Pakistan | 25.2 | 24.4 | 25.1 | 26.7 | 26.0 | 25.1 | 26.0 | 24.2 | 23.5 | 25.2 | 23.3 | 24 | 21 | 23.5 | 21.3 | 21.6 | 19.5 | 19.2 | 18.2 | 19 | 21.1 | 17.9 | 18.7 | 16.7 | 16.9 |
| 7 | Ukraine | 24.9 | 28.4 | 24.7 | 26.2 | 26.1 | 26.5 | 24.1 | 22.8 | 15.8 | 22.3 | 16.9 | 20.9 | 25.9 | 13.8 | 14 | 18.7 | 17.5 | 6.9 | 20.6 | 21.4 | 10.2 | 13.6 | 14.9 | 18.4 | 13.5 |
| 8 | Germany | 22.2 | 23.1 | 20.3 | 24.5 | 24.5 | 26.5 | 27.8 | 25.0 | 22.4 | 22.8 | 24.1 | 25.2 | 26 | 21.4 | 22.4 | 23.6 | 25.4 | 19.3 | 20.8 | 22.8 | 21.6 | 19.6 | 20.2 | 19.8 | 18.9 |
| 9 | Turkey | 20.5 | 19.0 | 20.0 | 21.5 | 20.6 | 22.6 | 19.0 | 22.1 | 20.1 | 21.8 | 19.7 | 20.6 | 17.8 | 17.7 | 20 | 21 | 21 | 19 | 19.5 | 19 | 17.5 | 16.5 | 18.5 | 16.2 | 16.2 |
CREATE TABLE international_wheat_production_statistics (
"unnamed_0" BIGINT,
"country" VARCHAR,
"n_2020_1" DOUBLE,
"n_2019_1" VARCHAR,
"n_2018_1" VARCHAR,
"n_2017_1" VARCHAR,
"n_2016_1" VARCHAR,
"n_2015_2" VARCHAR,
"n_2014_3" VARCHAR,
"n_2013_4" VARCHAR,
"n_2012_5" VARCHAR,
"n_2011_5" VARCHAR,
"n_2010_5" DOUBLE,
"n_2009_5" DOUBLE,
"n_2008_5" DOUBLE,
"n_2007_5" DOUBLE,
"n_2006_5" DOUBLE,
"n_2005_6" DOUBLE,
"n_2004_6" DOUBLE,
"n_2003_6" DOUBLE,
"n_2002" DOUBLE,
"n_2001" DOUBLE,
"n_2000" DOUBLE,
"n_1999" DOUBLE,
"n_1998" DOUBLE,
"n_1997" DOUBLE,
"n_1996" DOUBLE
);