Name: Crop Production
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Crop Production

inspiration
Agriculture the oldest practice in India. Farmers always wait for rainy and some times sunny weather and many depend on
winter.I have created this file to help the farmer check which crop will bring them the much benefit

Tables

Crop Production

@kaggle.divyosmi2009_crop_production_in_india_statevise.crop_production

1.64 MB
246,091 rows
7 columns

CREATE TABLE crop_production (
  "state_name" VARCHAR,
  "district_name" VARCHAR,
  "crop_year" BIGINT,
  "season" VARCHAR,
  "crop" VARCHAR,
  "area" DOUBLE,
  "production" DOUBLE
);

Test

@kaggle.divyosmi2009_crop_production_in_india_statevise.test

5.7 MB
246,091 rows
812 columns

CREATE TABLE test (
  "andaman_and_nicobar_islands" BIGINT,
  "andhra_pradesh" BIGINT,
  "arunachal_pradesh" BIGINT,
  "assam" BIGINT,
  "bihar" BIGINT,
  "chandigarh" BIGINT,
  "chhattisgarh" BIGINT,
  "dadra_and_nagar_haveli" BIGINT,
  "goa" BIGINT,
  "gujarat" BIGINT,
  "haryana" BIGINT,
  "himachal_pradesh" BIGINT,
  "jammu_and_kashmir" BIGINT,
  "jharkhand" BIGINT,
  "karnataka" BIGINT,
  "kerala" BIGINT,
  "madhya_pradesh" BIGINT,
  "maharashtra" BIGINT,
  "manipur" BIGINT,
  "meghalaya" BIGINT,
  "mizoram" BIGINT,
  "nagaland" BIGINT,
  "odisha" BIGINT,
  "puducherry" BIGINT,
  "punjab" BIGINT,
  "rajasthan" BIGINT,
  "sikkim" BIGINT,
  "tamil_nadu" BIGINT,
  "telangana" BIGINT,
  "tripura" BIGINT,
  "uttar_pradesh" BIGINT,
  "uttarakhand" BIGINT,
  "west_bengal" BIGINT,
  "n_24_paraganas_north" BIGINT  -- 24 PARAGANAS NORTH,
  "n_24_paraganas_south" BIGINT  -- 24 PARAGANAS SOUTH,
  "adilabad" BIGINT,
  "agar_malwa" BIGINT,
  "agra" BIGINT,
  "ahmadabad" BIGINT,
  "ahmednagar" BIGINT,
  "aizawl" BIGINT,
  "ajmer" BIGINT,
  "akola" BIGINT,
  "alappuzha" BIGINT,
  "aligarh" BIGINT,
  "alirajpur" BIGINT,
  "allahabad" BIGINT,
  "almora" BIGINT,
  "alwar" BIGINT,
  "ambala" BIGINT,
  "ambedkar_nagar" BIGINT,
  "amethi" BIGINT,
  "amravati" BIGINT,
  "amreli" BIGINT,
  "amritsar" BIGINT,
  "amroha" BIGINT,
  "anand" BIGINT,
  "anantapur" BIGINT,
  "anantnag" BIGINT,
  "anjaw" BIGINT,
  "anugul" BIGINT,
  "anuppur" BIGINT,
  "araria" BIGINT,
  "ariyalur" BIGINT,
  "arwal" BIGINT,
  "ashoknagar" BIGINT,
  "auraiya" BIGINT,
  "aurangabad" BIGINT,
  "azamgarh" BIGINT,
  "badgam" BIGINT,
  "bagalkot" BIGINT,
  "bageshwar" BIGINT,
  "baghpat" BIGINT,
  "bahraich" BIGINT,
  "baksa" BIGINT,
  "balaghat" BIGINT,
  "balangir" BIGINT,
  "baleshwar" BIGINT,
  "ballia" BIGINT,
  "balod" BIGINT,
  "baloda_bazar" BIGINT,
  "balrampur" BIGINT,
  "banas_kantha" BIGINT,
  "banda" BIGINT,
  "bandipora" BIGINT,
  "bangalore_rural" BIGINT,
  "banka" BIGINT,
  "bankura" BIGINT,
  "banswara" BIGINT,
  "barabanki" BIGINT,
  "baramulla" BIGINT,
  "baran" BIGINT,
  "bardhaman" BIGINT,
  "bareilly" BIGINT,
  "bargarh" BIGINT,
  "barmer" BIGINT,
  "barnala" BIGINT,
  "barpeta" BIGINT,
  "barwani" BIGINT,
  "bastar" BIGINT
);