Census Of India 2011 - Population, Age & Work
Population, Age and Occupational distribution across districts & states of India
@kaggle.mihirs16_census_of_india_2011_population_age_work
Population, Age and Occupational distribution across districts & states of India
@kaggle.mihirs16_census_of_india_2011_population_age_work
CREATE TABLE census_age (
"unnamed_0" BIGINT,
"table_name" VARCHAR,
"state_code" BIGINT,
"district_code" BIGINT,
"area_name" VARCHAR,
"age_group" VARCHAR,
"total_persons" BIGINT,
"total_males" BIGINT,
"total_females" BIGINT,
"rural_persons" BIGINT,
"rural_males" BIGINT,
"rural_females" BIGINT,
"urban_persons" BIGINT,
"urban_males" BIGINT,
"urban_females" BIGINT
);
CREATE TABLE census_disability (
"unnamed_0" BIGINT,
"table_name" VARCHAR,
"state_code" BIGINT,
"district_code" BIGINT,
"area_name" VARCHAR,
"residence" VARCHAR,
"age_group" VARCHAR,
"disabled_persons" BIGINT,
"disabled_males" BIGINT,
"disabled_females" BIGINT,
"in_seeing_persons" BIGINT,
"in_seeing_males" BIGINT,
"in_seeing_females" BIGINT,
"in_hearing_persons" BIGINT,
"in_hearing_males" BIGINT,
"in_hearing_females" BIGINT,
"in_speech_persons" BIGINT,
"in_speech_males" BIGINT,
"in_speech_females" BIGINT,
"in_movement_persons" BIGINT,
"in_movement_males" BIGINT,
"in_movement_females" BIGINT,
"in_mental_retardation_persons" BIGINT,
"in_mental_retardation_males" BIGINT,
"in_mental_retardation_females" BIGINT,
"in_mental_illness_persons" BIGINT,
"in_mental_illness_males" BIGINT,
"in_mental_illness_females" BIGINT,
"in_any_other_persons" BIGINT,
"in_any_other_males" BIGINT,
"in_any_other_females" BIGINT,
"in_multiple_disability_persons" BIGINT,
"in_multiple_disability_males" BIGINT,
"in_multiple_disability_females" BIGINT
);
CREATE TABLE census_occupation (
"unnamed_0" BIGINT,
"table_name" VARCHAR,
"state_code" DOUBLE,
"district_code" DOUBLE,
"area_name" VARCHAR,
"division" VARCHAR,
"sub_division" VARCHAR,
"occupation" VARCHAR,
"residence" VARCHAR,
"total_main_worker_person" DOUBLE,
"total_main_worker_male" DOUBLE,
"total_main_worker_female" DOUBLE,
"employer_person" DOUBLE,
"employer_male" DOUBLE,
"employer_female" DOUBLE,
"employee_person" DOUBLE,
"employee_male" DOUBLE,
"employee_female" DOUBLE,
"single_worker_person" DOUBLE,
"single_worker_male" DOUBLE,
"single_worker_female" DOUBLE,
"family_worker_person" DOUBLE,
"family_worker_male" DOUBLE,
"family_worker_female" DOUBLE
);
CREATE TABLE census_population (
"unnamed_0" BIGINT,
"state_code" BIGINT,
"district_code" BIGINT,
"sub_district_code" BIGINT,
"category" VARCHAR,
"name" VARCHAR,
"residence" VARCHAR,
"inhabited_villages" BIGINT,
"uninhabited_villages" BIGINT,
"towns" BIGINT,
"households" BIGINT,
"population_person" BIGINT,
"population_male" BIGINT,
"population_female" BIGINT,
"area" DOUBLE,
"population_density" DOUBLE
);
Anyone who has the link will be able to view this.