Name: Indian Agriculture Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

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.93 MB
16,146 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 AREA (1000 Ha),
  "rice_production_1000_tons" DOUBLE  -- RICE PRODUCTION (1000 Tons),
  "rice_yield_kg_per_ha" DOUBLE  -- RICE YIELD (Kg Per Ha),
  "wheat_area_1000_ha" DOUBLE  -- WHEAT AREA (1000 Ha),
  "wheat_production_1000_tons" DOUBLE  -- WHEAT PRODUCTION (1000 Tons),
  "wheat_yield_kg_per_ha" DOUBLE  -- WHEAT YIELD (Kg Per Ha),
  "kharif_sorghum_area_1000_ha" DOUBLE  -- KHARIF SORGHUM AREA (1000 Ha),
  "kharif_sorghum_production_1000_tons" DOUBLE  -- KHARIF SORGHUM PRODUCTION (1000 Tons),
  "kharif_sorghum_yield_kg_per_ha" DOUBLE  -- KHARIF SORGHUM YIELD (Kg Per Ha),
  "rabi_sorghum_area_1000_ha" DOUBLE  -- RABI SORGHUM AREA (1000 Ha),
  "rabi_sorghum_production_1000_tons" DOUBLE  -- RABI SORGHUM PRODUCTION (1000 Tons),
  "rabi_sorghum_yield_kg_per_ha" DOUBLE  -- RABI SORGHUM YIELD (Kg Per Ha),
  "sorghum_area_1000_ha" DOUBLE  -- SORGHUM AREA (1000 Ha),
  "sorghum_production_1000_tons" DOUBLE  -- SORGHUM PRODUCTION (1000 Tons),
  "sorghum_yield_kg_per_ha" DOUBLE  -- SORGHUM YIELD (Kg Per Ha),
  "pearl_millet_area_1000_ha" DOUBLE  -- PEARL MILLET AREA (1000 Ha),
  "pearl_millet_production_1000_tons" DOUBLE  -- PEARL MILLET PRODUCTION (1000 Tons),
  "pearl_millet_yield_kg_per_ha" DOUBLE  -- PEARL MILLET YIELD (Kg Per Ha),
  "maize_area_1000_ha" DOUBLE  -- MAIZE AREA (1000 Ha),
  "maize_production_1000_tons" DOUBLE  -- MAIZE PRODUCTION (1000 Tons),
  "maize_yield_kg_per_ha" DOUBLE  -- MAIZE YIELD (Kg Per Ha),
  "finger_millet_area_1000_ha" DOUBLE  -- FINGER MILLET AREA (1000 Ha),
  "finger_millet_production_1000_tons" DOUBLE  -- FINGER MILLET PRODUCTION (1000 Tons),
  "finger_millet_yield_kg_per_ha" DOUBLE  -- FINGER MILLET YIELD (Kg Per Ha),
  "barley_area_1000_ha" DOUBLE  -- BARLEY AREA (1000 Ha),
  "barley_production_1000_tons" DOUBLE  -- BARLEY PRODUCTION (1000 Tons),
  "barley_yield_kg_per_ha" DOUBLE  -- BARLEY YIELD (Kg Per Ha),
  "chickpea_area_1000_ha" DOUBLE  -- CHICKPEA AREA (1000 Ha),
  "chickpea_production_1000_tons" DOUBLE  -- CHICKPEA PRODUCTION (1000 Tons),
  "chickpea_yield_kg_per_ha" DOUBLE  -- CHICKPEA YIELD (Kg Per Ha),
  "pigeonpea_area_1000_ha" DOUBLE  -- PIGEONPEA AREA (1000 Ha),
  "pigeonpea_production_1000_tons" DOUBLE  -- PIGEONPEA PRODUCTION (1000 Tons),
  "pigeonpea_yield_kg_per_ha" DOUBLE  -- PIGEONPEA YIELD (Kg Per Ha),
  "minor_pulses_area_1000_ha" DOUBLE  -- MINOR PULSES AREA (1000 Ha),
  "minor_pulses_production_1000_tons" DOUBLE  -- MINOR PULSES PRODUCTION (1000 Tons),
  "minor_pulses_yield_kg_per_ha" DOUBLE  -- MINOR PULSES YIELD (Kg Per Ha),
  "groundnut_area_1000_ha" DOUBLE  -- GROUNDNUT AREA (1000 Ha),
  "groundnut_production_1000_tons" DOUBLE  -- GROUNDNUT PRODUCTION (1000 Tons),
  "groundnut_yield_kg_per_ha" DOUBLE  -- GROUNDNUT YIELD (Kg Per Ha),
  "sesamum_area_1000_ha" DOUBLE  -- SESAMUM AREA (1000 Ha),
  "sesamum_production_1000_tons" DOUBLE  -- SESAMUM PRODUCTION (1000 Tons),
  "sesamum_yield_kg_per_ha" DOUBLE  -- SESAMUM YIELD (Kg Per Ha),
  "rapeseed_and_mustard_area_1000_ha" DOUBLE  -- RAPESEED AND MUSTARD AREA (1000 Ha),
  "rapeseed_and_mustard_production_1000_tons" DOUBLE  -- RAPESEED AND MUSTARD PRODUCTION (1000 Tons),
  "rapeseed_and_mustard_yield_kg_per_ha" DOUBLE  -- RAPESEED AND MUSTARD YIELD (Kg Per Ha),
  "safflower_area_1000_ha" DOUBLE  -- SAFFLOWER AREA (1000 Ha),
  "safflower_production_1000_tons" DOUBLE  -- SAFFLOWER PRODUCTION (1000 Tons),
  "safflower_yield_kg_per_ha" DOUBLE  -- SAFFLOWER YIELD (Kg Per Ha),
  "castor_area_1000_ha" DOUBLE  -- CASTOR AREA (1000 Ha),
  "castor_production_1000_tons" DOUBLE  -- CASTOR PRODUCTION (1000 Tons),
  "castor_yield_kg_per_ha" DOUBLE  -- CASTOR YIELD (Kg Per Ha),
  "linseed_area_1000_ha" DOUBLE  -- LINSEED AREA (1000 Ha),
  "linseed_production_1000_tons" DOUBLE  -- LINSEED PRODUCTION (1000 Tons),
  "linseed_yield_kg_per_ha" DOUBLE  -- LINSEED YIELD (Kg Per Ha),
  "sunflower_area_1000_ha" DOUBLE  -- SUNFLOWER AREA (1000 Ha),
  "sunflower_production_1000_tons" DOUBLE  -- SUNFLOWER PRODUCTION (1000 Tons),
  "sunflower_yield_kg_per_ha" DOUBLE  -- SUNFLOWER YIELD (Kg Per Ha),
  "soyabean_area_1000_ha" DOUBLE  -- SOYABEAN AREA (1000 Ha),
  "soyabean_production_1000_tons" DOUBLE  -- SOYABEAN PRODUCTION (1000 Tons),
  "soyabean_yield_kg_per_ha" DOUBLE  -- SOYABEAN YIELD (Kg Per Ha),
  "oilseeds_area_1000_ha" DOUBLE  -- OILSEEDS AREA (1000 Ha),
  "oilseeds_production_1000_tons" DOUBLE  -- OILSEEDS PRODUCTION (1000 Tons),
  "oilseeds_yield_kg_per_ha" DOUBLE  -- OILSEEDS YIELD (Kg Per Ha),
  "sugarcane_area_1000_ha" DOUBLE  -- SUGARCANE AREA (1000 Ha),
  "sugarcane_production_1000_tons" DOUBLE  -- SUGARCANE PRODUCTION (1000 Tons),
  "sugarcane_yield_kg_per_ha" DOUBLE  -- SUGARCANE YIELD (Kg Per Ha),
  "cotton_area_1000_ha" DOUBLE  -- COTTON AREA (1000 Ha),
  "cotton_production_1000_tons" DOUBLE  -- COTTON PRODUCTION (1000 Tons),
  "cotton_yield_kg_per_ha" DOUBLE  -- COTTON YIELD (Kg Per Ha),
  "fruits_area_1000_ha" DOUBLE  -- FRUITS AREA (1000 Ha),
  "vegetables_area_1000_ha" DOUBLE  -- VEGETABLES AREA (1000 Ha),
  "fruits_and_vegetables_area_1000_ha" DOUBLE  -- FRUITS AND VEGETABLES AREA (1000 Ha),
  "potatoes_area_1000_ha" DOUBLE  -- POTATOES AREA (1000 Ha),
  "onion_area_1000_ha" DOUBLE  -- ONION AREA (1000 Ha),
  "fodder_area_1000_ha" DOUBLE  -- FODDER AREA (1000 Ha)
);