Dataset: Indian Agriculture Dataset

About this Dataset

Indian Agriculture Dataset

**Disclaimer: **
DLD is an open-access database. Users are advised to upload only the datasets they intend to use for their analysis, ensuring appropriate citation. Interested users are encouraged to explore the database based on the provided citation: https://doi.org/10.21421/D2/XFB1BZ

For additional information on terms of use and other queries, please refer to the 'About Us' page at http://data.icrisat.org/dld/src/about-dld.html

We hope this information helps and clarifies any queries you may have.

District-wise yearly area, yield and production.
This file group has two files: 1. Area, production and yield and 2. High yielding varieties The area, production yield file includes data on 20 major crops that include cereals, pulses, oilseeds, cotton, sugarcane, total fruits and vegetables. Yield is calculated based on area and production.

The data are for the annual area and production under the crops. The percent area under each crop is calculated by dividing crop area by Gross Cropped Area (GCA variable generated using a defined methodology).

For more details see definition and standards and in the data documentation manual the section on ‘data clarification and anomalies’.For season wise crop area and production data refer to season wise area and production of crops under additional data); for breakup of fruits and vegetables data by type also see files on area and vegetables under additional data.

The second file is on High Yielding Varieties (HYV / hybrids) has data on area under HYVs for 5 major cereal crops. The data on HYVs has a number of gaps in recent years implying that the area is completely under HYVs and hence no longer reported / some states do not publish this data.

guys please upvote me!!!

Tables

Icrisat District Level Data

@kaggle.vineetkukreti_indian_agriculture_dataset.icrisat_district_level_data

2.79 MB
16146 rows
80 columns


CREATE TABLE icrisat_district_level_data (
  "dist_code" BIGINT,
  "year" BIGINT,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "dist_name" VARCHAR,
  "rice_area_1000_ha" DOUBLE,
  "rice_production_1000_tons" DOUBLE,
  "rice_yield_kg_per_ha" DOUBLE,
  "wheat_area_1000_ha" DOUBLE,
  "wheat_production_1000_tons" DOUBLE,
  "wheat_yield_kg_per_ha" DOUBLE,
  "kharif_sorghum_area_1000_ha" DOUBLE,
  "kharif_sorghum_production_1000_tons" DOUBLE,
  "kharif_sorghum_yield_kg_per_ha" DOUBLE,
  "rabi_sorghum_area_1000_ha" DOUBLE,
  "rabi_sorghum_production_1000_tons" DOUBLE,
  "rabi_sorghum_yield_kg_per_ha" DOUBLE,
  "sorghum_area_1000_ha" DOUBLE,
  "sorghum_production_1000_tons" DOUBLE,
  "sorghum_yield_kg_per_ha" DOUBLE,
  "pearl_millet_area_1000_ha" DOUBLE,
  "pearl_millet_production_1000_tons" DOUBLE,
  "pearl_millet_yield_kg_per_ha" DOUBLE,
  "maize_area_1000_ha" DOUBLE,
  "maize_production_1000_tons" DOUBLE,
  "maize_yield_kg_per_ha" DOUBLE,
  "finger_millet_area_1000_ha" DOUBLE,
  "finger_millet_production_1000_tons" DOUBLE,
  "finger_millet_yield_kg_per_ha" DOUBLE,
  "barley_area_1000_ha" DOUBLE,
  "barley_production_1000_tons" DOUBLE,
  "barley_yield_kg_per_ha" DOUBLE,
  "chickpea_area_1000_ha" DOUBLE,
  "chickpea_production_1000_tons" DOUBLE,
  "chickpea_yield_kg_per_ha" DOUBLE,
  "pigeonpea_area_1000_ha" DOUBLE,
  "pigeonpea_production_1000_tons" DOUBLE,
  "pigeonpea_yield_kg_per_ha" DOUBLE,
  "minor_pulses_area_1000_ha" DOUBLE,
  "minor_pulses_production_1000_tons" DOUBLE,
  "minor_pulses_yield_kg_per_ha" DOUBLE,
  "groundnut_area_1000_ha" DOUBLE,
  "groundnut_production_1000_tons" DOUBLE,
  "groundnut_yield_kg_per_ha" DOUBLE,
  "sesamum_area_1000_ha" DOUBLE,
  "sesamum_production_1000_tons" DOUBLE,
  "sesamum_yield_kg_per_ha" DOUBLE,
  "rapeseed_and_mustard_area_1000_ha" DOUBLE,
  "rapeseed_and_mustard_production_1000_tons" DOUBLE,
  "rapeseed_and_mustard_yield_kg_per_ha" DOUBLE,
  "safflower_area_1000_ha" DOUBLE,
  "safflower_production_1000_tons" DOUBLE,
  "safflower_yield_kg_per_ha" DOUBLE,
  "castor_area_1000_ha" DOUBLE,
  "castor_production_1000_tons" DOUBLE,
  "castor_yield_kg_per_ha" DOUBLE,
  "linseed_area_1000_ha" DOUBLE,
  "linseed_production_1000_tons" DOUBLE,
  "linseed_yield_kg_per_ha" DOUBLE,
  "sunflower_area_1000_ha" DOUBLE,
  "sunflower_production_1000_tons" DOUBLE,
  "sunflower_yield_kg_per_ha" DOUBLE,
  "soyabean_area_1000_ha" DOUBLE,
  "soyabean_production_1000_tons" DOUBLE,
  "soyabean_yield_kg_per_ha" DOUBLE,
  "oilseeds_area_1000_ha" DOUBLE,
  "oilseeds_production_1000_tons" DOUBLE,
  "oilseeds_yield_kg_per_ha" DOUBLE,
  "sugarcane_area_1000_ha" DOUBLE,
  "sugarcane_production_1000_tons" DOUBLE,
  "sugarcane_yield_kg_per_ha" DOUBLE,
  "cotton_area_1000_ha" DOUBLE,
  "cotton_production_1000_tons" DOUBLE,
  "cotton_yield_kg_per_ha" DOUBLE,
  "fruits_area_1000_ha" DOUBLE,
  "vegetables_area_1000_ha" DOUBLE,
  "fruits_and_vegetables_area_1000_ha" DOUBLE,
  "potatoes_area_1000_ha" DOUBLE,
  "onion_area_1000_ha" DOUBLE,
  "fodder_area_1000_ha" DOUBLE
);