Mission Antyodaya 2020
Mission Antyodaya 2020: Village Data
@kaggle.adsamardeep_mission_antyodaya_2020
Mission Antyodaya 2020: Village Data
@kaggle.adsamardeep_mission_antyodaya_2020
CREATE TABLE ma2020_vill_all_reports (
"year" BIGINT,
"state_code" BIGINT,
"state_name" VARCHAR,
"district_code" BIGINT,
"district_name" VARCHAR,
"sub_district_code" BIGINT,
"sub_district_name" VARCHAR,
"block_code" BIGINT,
"block_name" VARCHAR,
"gp_code" BIGINT,
"gp_name" VARCHAR,
"village_code" BIGINT,
"village_name" VARCHAR,
"village_pin_code" BIGINT,
"pc_code" BIGINT,
"ac_code" DOUBLE,
"other_assembly_constituencies" VARCHAR,
"total_population" BIGINT,
"male_population" BIGINT,
"female_population" BIGINT,
"total_hhd" BIGINT,
"total_hhd_engaged_in_farm_activities" BIGINT,
"total_hhd_engaged_in_non_farm_activities" BIGINT,
"is_govt_seed_centre_available" BIGINT,
"distance_of_govt_seed_centre" BIGINT,
"availability_of_watershed_dev_project" BIGINT,
"availability_of_rain_harvest_system" BIGINT,
"availability_of_fpos_pacs" BIGINT,
"availability_of_food_storage_warehouse" BIGINT,
"distance_of_food_storage_warehouse" BIGINT,
"availability_of_farm_gate_processing" BIGINT,
"availability_of_custom_hiring_centre_agri_equipment" BIGINT,
"total_cultivable_area_in_hac" DOUBLE,
"net_sown_area_in_hac" DOUBLE,
"net_sown_area_kharif_in_hac" DOUBLE,
"net_sown_area_rabi_in_hac" DOUBLE,
"net_sown_area_other_in_hac" DOUBLE,
"is_soil_testing_centre_available" BIGINT,
"distance_of_soil_testing_centre" BIGINT,
"is_fertilizer_shop_available" BIGINT,
"distance_of_fertilizer_shop" BIGINT,
"availability_of_major_source_of_irrigation" BIGINT,
"no_of_farmers_using_drip_sprinkler" BIGINT,
"area_irrigated_in_hac" DOUBLE,
"total_unirrigated_land_area_in_hac" DOUBLE,
"availability_of_livestock_extension_services" BIGINT,
"availability_of_milk_routes" BIGINT,
"availability_of_poultry_dev_project" BIGINT,
"availability_of_goatary_dev_project" BIGINT,
"availability_of_pigery_development" BIGINT,
"is_veterinary_hospital_available" BIGINT,
"distance_of_veterinary_hospital" BIGINT,
"availability_of_fish_community_ponds" BIGINT,
"availability_of_fish_farming" BIGINT,
"availability_of_aquaculture_ext_facility" BIGINT,
"distance_of_aquaculture_ext_facility" BIGINT,
"total_hhd_with_kuccha_wall_kuccha_roof" BIGINT,
"total_hhd_have_got_pmay_house" BIGINT,
"total_hhd_in_pmay_permanent_wait_list" BIGINT,
"total_hhd_got_benefit_under_state_housing_scheme" BIGINT,
"total_hhd_in_perm_waitlist_under_state_housing_scheme" BIGINT,
"availability_of_piped_tap_water" BIGINT,
"distance_of_piped_tap_water" BIGINT,
"is_village_connected_to_all_weather_road" BIGINT,
"distance_of_all_weather_road" BIGINT,
"availability_of_internal_pucca_road" BIGINT,
"availability_of_public_transport" BIGINT,
"distance_of_public_transport" BIGINT,
"availability_of_railway_station" BIGINT,
"distance_of_railway_station" BIGINT,
"availablility_hours_of_domestic_electricity" BIGINT,
"total_hhd_having_pmsbhgy_benefit" BIGINT,
"availability_of_elect_supply_to_msme" BIGINT,
"availability_of_solor_wind_energy" BIGINT,
"total_hhd_having_solor_wind_energy" DOUBLE,
"availability_of_panchayat_bhawan" BIGINT,
"availability_of_csc_in_village" BIGINT,
"availability_of_public_information_board" BIGINT,
"is_common_pastures_available" BIGINT,
"total_hhd_availing_pmuy_benefits" BIGINT,
"availability_of_public_library" BIGINT,
"distance_of_public_library" BIGINT,
"availability_of_recreational_centre" BIGINT,
"is_bank_available" BIGINT,
"distance_of_banks" BIGINT,
"is_bank_buss_correspondent_with_internet" BIGINT,
"is_atm_available" BIGINT,
"distance_of_atm" BIGINT,
"total_hhd_availing_pmjdy_bank_ac" BIGINT,
"is_post_office_available" BIGINT,
"distance_of_post_office" BIGINT,
"availability_of_telephone_services" BIGINT,
"is_broadband_available" BIGINT,
"is_pds_available" BIGINT,
"distance_of_pds_office" BIGINT,
"total_hhd_having_bpl_cards" BIGINT,
"availability_of_primary_school" BIGINT,
"is_primary_school_with_electricity" BIGINT,
"primary_school_toilet" BIGINT,
"is_primary_school_with_computer_lab" BIGINT
);
Anyone who has the link will be able to view this.