Census Of India 2011 - Population, Age & Work

CREATE TABLE census_age (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- Unnamed: 0,
  "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  -- Unnamed: 0,
  "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 (Person),
  "total_main_worker_male" DOUBLE  -- Total Main Worker (Male),
  "total_main_worker_female" DOUBLE  -- Total Main Worker (Female),
  "employer_person" DOUBLE  -- Employer (Person),
  "employer_male" DOUBLE  -- Employer (Male),
  "employer_female" DOUBLE  -- Employer (Female),
  "employee_person" DOUBLE  -- Employee (Person),
  "employee_male" DOUBLE  -- Employee (Male),
  "employee_female" DOUBLE  -- Employee (Female),
  "single_worker_person" DOUBLE  -- Single Worker (Person),
  "single_worker_male" DOUBLE  -- Single Worker (Male),
  "single_worker_female" DOUBLE  -- Single Worker (Female),
  "family_worker_person" DOUBLE  -- Family Worker (Person),
  "family_worker_male" DOUBLE  -- Family Worker (Male),
  "family_worker_female" DOUBLE  -- Family Worker (Female)
);

CREATE TABLE census_population (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 (Person),
  "population_male" BIGINT  -- Population (Male),
  "population_female" BIGINT  -- Population (Female),
  "area" DOUBLE,
  "population_density" DOUBLE
);