Dataset: Crop Production

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.56 MB
246091 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.44 MB
246091 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,
  "n_24_paraganas_south" BIGINT,
  "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
);