Name: Bangladesh Spatial Database
Creator: Kaggle
License: https://datacatalog.worldbank.org/public-licenses

About this Dataset

Bangladesh Spatial Database

Derived from publicly available sources, this dataset contains data on a variety of indicators from the years 2001 and 2011 for Bangladesh at four levels of administrative geography.

Thematic areas include:

Business
Demographics
Economic Activity
Education
Environment
Finance
Health
Information Technology
Infrastructure
Jobs
Living Standards
Urban Extent

Tables

N 2001 Bgd L1

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l1

238.69 kB
21 rows
228 columns

CREATE TABLE n_2001_bgd_l1 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE  -- Crude Birth Rate, Total (live Births Per 1000 People),
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE  -- Crude Death Rate, Total (deaths Per 1000 People),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co),
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jan (Co),
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Feb (Co),
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Mar (Co),
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Apr (Co),
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - May (Co),
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jun (Co),
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jul (Co),
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Aug (Co),
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Sep (Co),
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Oct (Co),
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Nov (Co),
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Dec (Co),
  "temperature_anomaly_jan_co" DOUBLE  -- Temperature Anomaly - Jan (Co),
  "temperature_anomaly_feb_co" DOUBLE  -- Temperature Anomaly - Feb (Co),
  "temperature_anomaly_mar_co" DOUBLE  -- Temperature Anomaly - Mar (Co),
  "temperature_anomaly_apr_co" DOUBLE  -- Temperature Anomaly - Apr (Co),
  "temperature_anomaly_may_co" DOUBLE  -- Temperature Anomaly - May (Co),
  "temperature_anomaly_jun_co" DOUBLE  -- Temperature Anomaly - Jun (Co),
  "temperature_anomaly_jul_co" DOUBLE  -- Temperature Anomaly - Jul (Co),
  "temperature_anomaly_aug_co" DOUBLE  -- Temperature Anomaly - Aug (Co),
  "temperature_anomaly_sep_co" DOUBLE  -- Temperature Anomaly - Sep (Co),
  "temperature_anomaly_oct_co" DOUBLE  -- Temperature Anomaly - Oct (Co),
  "temperature_anomaly_nov_co" DOUBLE  -- Temperature Anomaly - Nov (Co),
  "temperature_anomaly_dec_co" DOUBLE  -- Temperature Anomaly - Dec (Co),
  "precipitation_jan_millimeters" DOUBLE  -- Precipitation - Jan (millimeters),
  "precipitation_feb_millimeters" DOUBLE  -- Precipitation - Feb (millimeters),
  "precipitation_mar_millimeters" DOUBLE  -- Precipitation - Mar (millimeters),
  "precipitation_apr_millimeters" DOUBLE  -- Precipitation - Apr (millimeters),
  "precipitation_may_millimeters" DOUBLE  -- Precipitation - May (millimeters),
  "precipitation_jun_millimeters" DOUBLE  -- Precipitation - Jun (millimeters),
  "precipitation_jul_millimeters" DOUBLE  -- Precipitation - Jul (millimeters),
  "precipitation_aug_millimeters" DOUBLE  -- Precipitation - Aug (millimeters),
  "precipitation_sep_millimeters" DOUBLE  -- Precipitation - Sep (millimeters),
  "precipitation_oct_millimeters" DOUBLE  -- Precipitation - Oct (millimeters),
  "precipitation_nov_millimeters" DOUBLE  -- Precipitation - Nov (millimeters),
  "precipitation_dec_millimeters" DOUBLE  -- Precipitation - Dec (millimeters),
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jan (millimeters),
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Feb (millimeters),
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Mar (millimeters),
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Apr (millimeters),
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - May (millimeters)
);

N 2001 Bgd L2

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l2

263.74 kB
192 rows
179 columns

CREATE TABLE n_2001_bgd_l2 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co),
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jan (Co),
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Feb (Co),
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Mar (Co),
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Apr (Co),
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - May (Co),
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jun (Co),
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jul (Co),
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Aug (Co),
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Sep (Co),
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Oct (Co),
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Nov (Co),
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Dec (Co),
  "temperature_anomaly_jan_co" DOUBLE  -- Temperature Anomaly - Jan (Co),
  "temperature_anomaly_feb_co" DOUBLE  -- Temperature Anomaly - Feb (Co),
  "temperature_anomaly_mar_co" DOUBLE  -- Temperature Anomaly - Mar (Co),
  "temperature_anomaly_apr_co" DOUBLE  -- Temperature Anomaly - Apr (Co),
  "temperature_anomaly_may_co" DOUBLE  -- Temperature Anomaly - May (Co),
  "temperature_anomaly_jun_co" DOUBLE  -- Temperature Anomaly - Jun (Co),
  "temperature_anomaly_jul_co" DOUBLE  -- Temperature Anomaly - Jul (Co),
  "temperature_anomaly_aug_co" DOUBLE  -- Temperature Anomaly - Aug (Co),
  "temperature_anomaly_sep_co" DOUBLE  -- Temperature Anomaly - Sep (Co),
  "temperature_anomaly_oct_co" DOUBLE  -- Temperature Anomaly - Oct (Co),
  "temperature_anomaly_nov_co" DOUBLE  -- Temperature Anomaly - Nov (Co),
  "temperature_anomaly_dec_co" DOUBLE  -- Temperature Anomaly - Dec (Co),
  "precipitation_jan_millimeters" DOUBLE  -- Precipitation - Jan (millimeters),
  "precipitation_feb_millimeters" DOUBLE  -- Precipitation - Feb (millimeters),
  "precipitation_mar_millimeters" DOUBLE  -- Precipitation - Mar (millimeters),
  "precipitation_apr_millimeters" DOUBLE  -- Precipitation - Apr (millimeters),
  "precipitation_may_millimeters" DOUBLE  -- Precipitation - May (millimeters),
  "precipitation_jun_millimeters" DOUBLE  -- Precipitation - Jun (millimeters),
  "precipitation_jul_millimeters" DOUBLE  -- Precipitation - Jul (millimeters),
  "precipitation_aug_millimeters" DOUBLE  -- Precipitation - Aug (millimeters),
  "precipitation_sep_millimeters" DOUBLE  -- Precipitation - Sep (millimeters),
  "precipitation_oct_millimeters" DOUBLE  -- Precipitation - Oct (millimeters),
  "precipitation_nov_millimeters" DOUBLE  -- Precipitation - Nov (millimeters),
  "precipitation_dec_millimeters" DOUBLE  -- Precipitation - Dec (millimeters),
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jan (millimeters),
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Feb (millimeters),
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Mar (millimeters),
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Apr (millimeters),
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - May (millimeters)
);

N 2001 Bgd L3

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l3

482.86 kB
1,632 rows
164 columns

CREATE TABLE n_2001_bgd_l3 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "level_3_code" BIGINT,
  "level_3_name" VARCHAR,
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co),
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jan (Co),
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Feb (Co),
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Mar (Co),
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Apr (Co),
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - May (Co),
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jun (Co),
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jul (Co),
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Aug (Co),
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Sep (Co),
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Oct (Co),
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Nov (Co),
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Dec (Co),
  "temperature_anomaly_jan_co" DOUBLE  -- Temperature Anomaly - Jan (Co),
  "temperature_anomaly_feb_co" DOUBLE  -- Temperature Anomaly - Feb (Co),
  "temperature_anomaly_mar_co" DOUBLE  -- Temperature Anomaly - Mar (Co),
  "temperature_anomaly_apr_co" DOUBLE  -- Temperature Anomaly - Apr (Co),
  "temperature_anomaly_may_co" DOUBLE  -- Temperature Anomaly - May (Co),
  "temperature_anomaly_jun_co" DOUBLE  -- Temperature Anomaly - Jun (Co),
  "temperature_anomaly_jul_co" DOUBLE  -- Temperature Anomaly - Jul (Co),
  "temperature_anomaly_aug_co" DOUBLE  -- Temperature Anomaly - Aug (Co),
  "temperature_anomaly_sep_co" DOUBLE  -- Temperature Anomaly - Sep (Co),
  "temperature_anomaly_oct_co" DOUBLE  -- Temperature Anomaly - Oct (Co),
  "temperature_anomaly_nov_co" DOUBLE  -- Temperature Anomaly - Nov (Co),
  "temperature_anomaly_dec_co" DOUBLE  -- Temperature Anomaly - Dec (Co),
  "precipitation_jan_millimeters" DOUBLE  -- Precipitation - Jan (millimeters),
  "precipitation_feb_millimeters" DOUBLE  -- Precipitation - Feb (millimeters),
  "precipitation_mar_millimeters" DOUBLE  -- Precipitation - Mar (millimeters),
  "precipitation_apr_millimeters" DOUBLE  -- Precipitation - Apr (millimeters),
  "precipitation_may_millimeters" DOUBLE  -- Precipitation - May (millimeters),
  "precipitation_jun_millimeters" DOUBLE  -- Precipitation - Jun (millimeters),
  "precipitation_jul_millimeters" DOUBLE  -- Precipitation - Jul (millimeters),
  "precipitation_aug_millimeters" DOUBLE  -- Precipitation - Aug (millimeters),
  "precipitation_sep_millimeters" DOUBLE  -- Precipitation - Sep (millimeters),
  "precipitation_oct_millimeters" DOUBLE  -- Precipitation - Oct (millimeters),
  "precipitation_nov_millimeters" DOUBLE  -- Precipitation - Nov (millimeters),
  "precipitation_dec_millimeters" DOUBLE  -- Precipitation - Dec (millimeters),
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jan (millimeters),
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Feb (millimeters),
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Mar (millimeters)
);

N 2001 Bgd L4

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l4

2.38 MB
23,283 rows
159 columns

CREATE TABLE n_2001_bgd_l4 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "level_3_code" BIGINT,
  "level_3_name" VARCHAR,
  "level_4_code" BIGINT,
  "level_4_name" VARCHAR,
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co),
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jan (Co),
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Feb (Co),
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Mar (Co),
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Apr (Co),
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - May (Co),
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jun (Co),
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jul (Co),
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Aug (Co),
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Sep (Co),
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Oct (Co),
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Nov (Co),
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Dec (Co),
  "temperature_anomaly_jan_co" DOUBLE  -- Temperature Anomaly - Jan (Co),
  "temperature_anomaly_feb_co" DOUBLE  -- Temperature Anomaly - Feb (Co),
  "temperature_anomaly_mar_co" DOUBLE  -- Temperature Anomaly - Mar (Co),
  "temperature_anomaly_apr_co" DOUBLE  -- Temperature Anomaly - Apr (Co),
  "temperature_anomaly_may_co" DOUBLE  -- Temperature Anomaly - May (Co),
  "temperature_anomaly_jun_co" DOUBLE  -- Temperature Anomaly - Jun (Co),
  "temperature_anomaly_jul_co" DOUBLE  -- Temperature Anomaly - Jul (Co),
  "temperature_anomaly_aug_co" DOUBLE  -- Temperature Anomaly - Aug (Co),
  "temperature_anomaly_sep_co" DOUBLE  -- Temperature Anomaly - Sep (Co),
  "temperature_anomaly_oct_co" DOUBLE  -- Temperature Anomaly - Oct (Co),
  "temperature_anomaly_nov_co" DOUBLE  -- Temperature Anomaly - Nov (Co),
  "temperature_anomaly_dec_co" DOUBLE  -- Temperature Anomaly - Dec (Co),
  "precipitation_jan_millimeters" DOUBLE  -- Precipitation - Jan (millimeters),
  "precipitation_feb_millimeters" DOUBLE  -- Precipitation - Feb (millimeters),
  "precipitation_mar_millimeters" DOUBLE  -- Precipitation - Mar (millimeters),
  "precipitation_apr_millimeters" DOUBLE  -- Precipitation - Apr (millimeters),
  "precipitation_may_millimeters" DOUBLE  -- Precipitation - May (millimeters),
  "precipitation_jun_millimeters" DOUBLE  -- Precipitation - Jun (millimeters),
  "precipitation_jul_millimeters" DOUBLE  -- Precipitation - Jul (millimeters),
  "precipitation_aug_millimeters" DOUBLE  -- Precipitation - Aug (millimeters),
  "precipitation_sep_millimeters" DOUBLE  -- Precipitation - Sep (millimeters),
  "precipitation_oct_millimeters" DOUBLE  -- Precipitation - Oct (millimeters),
  "precipitation_nov_millimeters" DOUBLE  -- Precipitation - Nov (millimeters),
  "precipitation_dec_millimeters" DOUBLE  -- Precipitation - Dec (millimeters),
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jan (millimeters),
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Feb (millimeters),
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Mar (millimeters),
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Apr (millimeters),
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - May (millimeters),
  "decadal_average_of_monthly_precipitation_jun_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jun (millimeters),
  "decadal_average_of_monthly_precipitation_jul_millimeters" DOUBLE  -- Decadal Average Of Monthly Precipitation - Jul (millimeters)
);

N 2011 Bgd L1

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l1

403.76 kB
23 rows
368 columns

CREATE TABLE n_2011_bgd_l1 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "non_agr_enterprises_thousands" DOUBLE  -- Non-agr. Enterprises (thousands),
  "non_agr_enterprises_by_size_1_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -1(percent Of Establishments),
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -2-5(percent Of Establishments),
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -6-9(percent Of Establishments),
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -10-19(percent Of Establishments),
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -20-99(percent Of Establishments),
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -100+(percent Of Establishments),
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Mining And Quarrying(C)(percent Of Est.),
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Manufacturing(D)(percent Of Est.),
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Electricity,gas And Water Supply(E)(percent Of Est.),
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Construction(F)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trade,hotels And Restaurants(G, H)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trans.,storage And Communications.(I)(percent Of Est.),
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Financial Intermediation(J)(percent Of Est.),
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Real Estate \u0026 Business Activities (K)(percent Of Est.),
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Public Administration(L)(percent Of Est.),
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Education,health And Social(M, N, O)(percent Of Est.),
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE  -- Non-agr. Enterprises By Ownership -Private(percent Of Establishments),
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE  -- Non-agr. Enterprises By Ownership -Public(percent Of Establishments),
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "formal_manu_food_beverage_tobacco_10_11_12_percent_of__638a659a" DOUBLE  -- Formal Manu,Food/beverage/tobacco (10, 11, 12)(percent Of Establishments),
  "formal_manu_textiles_apparel_leather_13_14_15_percent__2d43f126" DOUBLE  -- Formal Manu,Textiles/apparel/leather(13, 14, 15)(percent Of Establishments),
  "formal_manu_wood_paper_products_16_17_percent_of_estab_dca6e092" DOUBLE  -- Formal Manu,Wood/paper Products (16, 17)(percent Of Establishments),
  "formal_manu_printing_recorded_media_18_percent_of_esta_b929128d" DOUBLE  -- Formal Manu,Printing/recorded Media (18)(percent Of Establishments),
  "formal_manu_coke_and_refined_petroleum_19_percent_of_e_76ee679f" DOUBLE  -- Formal Manu,Coke And Refined Petroleum (19)(percent Of Establishments),
  "formal_manu_chemicals_pharmaceuticals_20_21_percent_of_d750a596" DOUBLE  -- Formal Manu,Chemicals Pharmaceuticals (20, 21)(percent Of Establishments),
  "formal_manu_rubber_plastics_nonmetallic_mineral_22_23__1f127765" DOUBLE  -- Formal Manu,Rubber/plastics/nonmetallic Mineral(22, 23)(current USD Per Work,
  "formal_manu_basic_metals_fabricated_metals_24_25_perce_0339b989" DOUBLE  -- Formal Manu,Basic Metals/fabricated Metals(24, 25)(percent Of Establishments),
  "formal_manu_computer_electronic_optical_26_percent_of__1ca5376a" DOUBLE  -- Formal Manu,Computer/electronic/optical(26)(percent Of Establishments),
  "formal_manu_electrical_equipment_27_percent_of_establishments" DOUBLE  -- Formal Manu,Electrical Equipment (27)(percent Of Establishments),
  "formal_manu_machinery_and_equipment_28_percent_of_esta_3779169b" DOUBLE  -- Formal Manu,Machinery And Equipment (28)(percent Of Establishments),
  "formal_manu_transportation_equipment_29_30_percent_of__3d36468a" DOUBLE  -- Formal Manu,Transportation Equipment (29, 30)(percent Of Establishments),
  "formal_manu_other_31_32_33_34_percent_of_establishments" DOUBLE  -- Formal Manu,Other (31,32,33,34)(percent Of Establishments),
  "average_size_of_formal_manufacturing_enterprises_numbe_5cef2836" DOUBLE  -- Average Size Of Formal Manufacturing Enterprises (number Of Employees),
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE  -- Crude Birth Rate, Total (live Births Per 1000 People),
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE  -- Crude Death Rate, Total (deaths Per 1000 People),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - All (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Millets (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Pulses (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Rice(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Sugar Cane (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Wheat (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Maize(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Groundnut (2011 USD Per Ha., In Thousands),
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - All (tonnes Per Ha.),
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Millets(tonnes Per Ha.),
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Pulses(tonnes Per Ha.),
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Rice(tonnes Per Ha.),
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Sugar Cane(tonnes Per Ha.),
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Wheat(tonnes Per Ha.),
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Maize(tonnes Per Ha.),
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Groundnut(tonnes Per Ha.),
  "lp_formal_manu_all_current_usd_per_worker" DOUBLE  -- LP Formal Manu,All(current USD Per Worker),
  "lp_formal_manu_food_beverage_tobacco_10_11_12_current__eb2183e9" DOUBLE  -- LP Formal Manu,Food/beverage/tobacco (10, 11, 12)(current USD Per Worker),
  "lp_formal_manu_textiles_apparel_leather_13_14_15_curre_201f4866" DOUBLE  -- LP Formal Manu,Textiles/apparel/leather(13, 14, 15)(current USD Per Worker),
  "lp_formal_manu_wood_paper_products_16_17_current_usd_p_0571d82c" DOUBLE  -- LP Formal Manu,Wood/paper Products (16, 17)(current USD Per Worker),
  "lp_formal_manu_printing_recorded_media_18_current_usd__7faf9b96" DOUBLE  -- LP Formal Manu,Printing/recorded Media (18)(current USD Per Worker),
  "lp_formal_manu_coke_and_refined_petroleum_19_current_u_6534d647" DOUBLE  -- LP Formal Manu,Coke And Refined Petroleum (19)(current USD Per Worker),
  "lp_formal_manu_chemicals_pharmaceuticals_20_21_current_3e4e8a32" DOUBLE  -- LP Formal Manu,Chemicals Pharmaceuticals (20, 21)(current USD Per Worker),
  "lp_formal_manu_rubber_plastics_nonmetallic_mineral_22__02ee5f22" DOUBLE  -- LP Formal Manu,Rubber/plastics/nonmetallic Mineral(22, 23)(current USD Per Work,
  "lp_formal_manu_basic_metals_fabricated_metals_24_25_cu_d01e9b1b" DOUBLE  -- LP Formal Manu,Basic Metals/fabricated Metals(24, 25)(current USD Per Worker),
  "lp_formal_manu_computer_electronic_optical_26_current__14cf1be2" DOUBLE  -- LP Formal Manu,Computer/electronic/optical(26)(current USD Per Worker),
  "lp_formal_manu_electrical_equipment_27_current_usd_per_worker" DOUBLE  -- LP Formal Manu,Electrical Equipment (27)(current USD Per Worker),
  "lp_formal_manu_machinery_and_equipment_28_current_usd__27542c6d" DOUBLE  -- LP Formal Manu,Machinery And Equipment (28)(current USD Per Worker),
  "lp_formal_manu_transportation_equipment_29_30_current__6c554878" DOUBLE  -- LP Formal Manu,Transportation Equipment (29, 30)(current USD Per Worker),
  "lp_formal_manu_other_31_32_33_34_current_usd_per_worker" DOUBLE  -- LP Formal Manu,Other (31,32,33,34)(current USD Per Worker),
  "k_l_formal_manu_all_current_usd_per_worker" DOUBLE  -- K/L Formal Manu,All(current USD Per Worker),
  "k_l_formal_manu_food_beverage_tobacco_10_11_12_current_9e7d5c94" DOUBLE  -- K/L Formal Manu,Food/beverage/tobacco (10, 11, 12)(current USD Per Worker),
  "k_l_formal_manu_textiles_apparel_leather_13_14_15_curr_746825b0" DOUBLE  -- K/L Formal Manu,Textiles/apparel/leather(13, 14, 15)(current USD Per Worker),
  "k_l_formal_manu_wood_paper_products_16_17_current_usd__2fc8495c" DOUBLE  -- K/L Formal Manu,Wood/paper Products (16, 17)(current USD Per Worker),
  "k_l_formal_manu_printing_recorded_media_18_current_usd_a9d08c50" DOUBLE  -- K/L Formal Manu,Printing/recorded Media (18)(current USD Per Worker),
  "k_l_formal_manu_coke_and_refined_petroleum_19_current__7905a9db" DOUBLE  -- K/L Formal Manu,Coke And Refined Petroleum (19)(current USD Per Worker),
  "k_l_formal_manu_chemicals_pharmaceuticals_20_21_curren_18891392" DOUBLE  -- K/L Formal Manu,Chemicals Pharmaceuticals (20, 21)(current USD Per Worker),
  "k_l_formal_manu_rubber_plastics_nonmetallic_mineral_22_cf7c9609" DOUBLE  -- K/L Formal Manu,Rubber/plastics/nonmetallic Mineral(22, 23)(current USD Per Work,
  "k_l_formal_manu_basic_metals_fabricated_metals_24_25_c_6d9706dd" DOUBLE  -- K/L Formal Manu,Basic Metals/fabricated Metals(24, 25)(current USD Per Worker),
  "k_l_formal_manu_computer_electronic_optical_26_current_9c057501" DOUBLE  -- K/L Formal Manu,Computer/electronic/optical(26)(current USD Per Worker)
);

N 2011 Bgd L2

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l2

411.18 kB
192 rows
276 columns

CREATE TABLE n_2011_bgd_l2 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "non_agr_enterprises_thousands" DOUBLE  -- Non-agr. Enterprises (thousands),
  "non_agr_enterprises_by_size_1_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -1(percent Of Establishments),
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -2-5(percent Of Establishments),
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -6-9(percent Of Establishments),
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -10-19(percent Of Establishments),
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -20-99(percent Of Establishments),
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -100+(percent Of Establishments),
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Mining And Quarrying(C)(percent Of Est.),
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Manufacturing(D)(percent Of Est.),
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Electricity,gas And Water Supply(E)(percent Of Est.),
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Construction(F)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trade,hotels And Restaurants(G, H)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trans.,storage And Communications.(I)(percent Of Est.),
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Financial Intermediation(J)(percent Of Est.),
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Real Estate \u0026 Business Activities (K)(percent Of Est.),
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Public Administration(L)(percent Of Est.),
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Education,health And Social(M, N, O)(percent Of Est.),
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE  -- Non-agr. Enterprises By Ownership -Private(percent Of Establishments),
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE  -- Non-agr. Enterprises By Ownership -Public(percent Of Establishments),
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE  -- Crude Birth Rate, Total (live Births Per 1000 People),
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE  -- Crude Death Rate, Total (deaths Per 1000 People),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - All (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Millets (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Pulses (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Rice(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Sugar Cane (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Wheat (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Maize(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Groundnut (2011 USD Per Ha., In Thousands),
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - All (tonnes Per Ha.),
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Millets(tonnes Per Ha.),
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Pulses(tonnes Per Ha.),
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Rice(tonnes Per Ha.),
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Sugar Cane(tonnes Per Ha.),
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Wheat(tonnes Per Ha.),
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Maize(tonnes Per Ha.),
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Groundnut(tonnes Per Ha.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "pupil_teacher_ratio_in_primary_schools_students_per_teacher" DOUBLE  -- Pupil-teacher Ratio In Primary Schools (students Per Teacher),
  "gross_primary_enrollment_total_percent_of_population_group" DOUBLE  -- Gross Primary Enrollment, Total(percent Of Population Group),
  "gross_primary_enrollment_female_percent_of_population_group" DOUBLE  -- Gross Primary Enrollment, Female (percent Of Population Group),
  "gross_primary_enrollment_male_percent_of_population_group" DOUBLE  -- Gross Primary Enrollment, Male (percent Of Population Group),
  "out_of_school_children_total_percent_of_population_group" DOUBLE  -- Out Of School Children, Total(percent Of Population Group),
  "out_of_school_children_female_percent_of_population_group" DOUBLE  -- Out Of School Children, Female(percent Of Population Group),
  "out_of_school_children_male_percent_of_population_group" DOUBLE  -- Out Of School Children, Male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co)
);

N 2011 Bgd L3

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l3

673.04 kB
1,632 rows
225 columns

CREATE TABLE n_2011_bgd_l3 (
  "unique_id" VARCHAR,
  "spatial_database_year" BIGINT,
  "total_rural_urban_division" VARCHAR,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "level_3_code" BIGINT,
  "level_3_name" VARCHAR,
  "non_agr_enterprises_thousands" DOUBLE  -- Non-agr. Enterprises (thousands),
  "non_agr_enterprises_by_size_1_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -1(percent Of Establishments),
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -2-5(percent Of Establishments),
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -6-9(percent Of Establishments),
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -10-19(percent Of Establishments),
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -20-99(percent Of Establishments),
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -100+(percent Of Establishments),
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Mining And Quarrying(C)(percent Of Est.),
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Manufacturing(D)(percent Of Est.),
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Electricity,gas And Water Supply(E)(percent Of Est.),
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Construction(F)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trade,hotels And Restaurants(G, H)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trans.,storage And Communications.(I)(percent Of Est.),
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Financial Intermediation(J)(percent Of Est.),
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Real Estate \u0026 Business Activities (K)(percent Of Est.),
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Public Administration(L)(percent Of Est.),
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Education,health And Social(M, N, O)(percent Of Est.),
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE  -- Non-agr. Enterprises By Ownership -Private(percent Of Establishments),
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE  -- Non-agr. Enterprises By Ownership -Public(percent Of Establishments),
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - All (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Millets (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Pulses (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Rice(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR  -- Crop Yield, Monetary - Sugar Cane (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Wheat (2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Maize(2011 USD Per Ha., In Thousands),
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE  -- Crop Yield, Monetary - Groundnut (2011 USD Per Ha., In Thousands),
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - All (tonnes Per Ha.),
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Millets(tonnes Per Ha.),
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Pulses(tonnes Per Ha.),
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Rice(tonnes Per Ha.),
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR  -- Crop Yield, Quantity - Sugar Cane(tonnes Per Ha.),
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Wheat(tonnes Per Ha.),
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Maize(tonnes Per Ha.),
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE  -- Crop Yield, Quantity - Groundnut(tonnes Per Ha.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co)
);

N 2011 Bgd L4

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l4

3.34 MB
23,283 rows
209 columns

CREATE TABLE n_2011_bgd_l4 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "spatial_database_year" DOUBLE,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "level_0_code" BIGINT,
  "level_0_name" VARCHAR,
  "level_1_code" BIGINT,
  "level_1_name" VARCHAR,
  "level_2_code" BIGINT,
  "level_2_name" VARCHAR,
  "level_3_code" BIGINT,
  "level_3_name" VARCHAR,
  "level_4_code" BIGINT,
  "level_4_name" VARCHAR,
  "non_agr_enterprises_thousands" DOUBLE  -- Non-agr. Enterprises (thousands),
  "non_agr_enterprises_by_size_1_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -1(percent Of Establishments),
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -2-5(percent Of Establishments),
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -6-9(percent Of Establishments),
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -10-19(percent Of Establishments),
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -20-99(percent Of Establishments),
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE  -- Non-agr. Enterprises By Size -100+(percent Of Establishments),
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Mining And Quarrying(C)(percent Of Est.),
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Manufacturing(D)(percent Of Est.),
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Electricity,gas And Water Supply(E)(percent Of Est.),
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Construction(F)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trade,hotels And Restaurants(G, H)(percent Of Est.),
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Trans.,storage And Communications.(I)(percent Of Est.),
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Financial Intermediation(J)(percent Of Est.),
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Real Estate \u0026 Business Activities (K)(percent Of Est.),
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Public Administration(L)(percent Of Est.),
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE  -- Non-agr. By Sect.,ISIC3.1-Education,health And Social(M, N, O)(percent Of Est.),
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE  -- Non-agr. Enterprises By Ownership -Private(percent Of Establishments),
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE  -- Non-agr. Enterprises By Ownership -Public(percent Of Establishments),
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -2 Digit(index),
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE  -- Diversification Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE  -- Specialization Index Of Non-agr. Enterprises, ISIC 3.1 -4 Digit(index),
  "gender_ratio_all_ages_percent" DOUBLE  -- Gender Ratio, All Ages (percent),
  "gender_ratio_0_4_years_percent" DOUBLE  -- Gender Ratio, 0-4 Years (percent),
  "gender_ratio_at_birth_percent" DOUBLE  -- Gender Ratio, At Birth (percent),
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Or 65+ Years (percent),
  "dependency_ratio_65_years_percent" DOUBLE  -- Dependency Ratio, 65+ Years (percent),
  "dependency_ratio_0_14_years_percent" DOUBLE  -- Dependency Ratio, 0-14 Years (percent),
  "ethnic_population_percent" DOUBLE  -- Ethnic Population (percent),
  "muslim_population_percent" DOUBLE  -- Muslim Population (percent),
  "hindu_population_percent" DOUBLE  -- Hindu Population (percent),
  "christian_population_percent" DOUBLE  -- Christian Population (percent),
  "buddhist_population_percent" DOUBLE  -- Buddhist Population (percent),
  "other_religion_population_percent" DOUBLE  -- Other Religion Population (percent),
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE  -- Light Intensity Per 1000 People(Digital Numbers Of Light Per 1000 People),
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE  -- Light Intensity Per Area (Digital Numbers Of Light Per Sq. Km.),
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,total(percent Of Population Group),
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,female(percent Of Population Group),
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,7+ Years,male(percent Of Population Group),
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,total(percent Of Population Group),
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,female(percent Of Population Group),
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE  -- Literacy Rate,15+ Years,male(percent Of Population Group),
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE  -- Secondary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE  -- Secondary Education Completion Rate,15+ Years,female(percent Of Population Group,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE  -- Secondary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,total(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,female(percent Of Population Group),
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE  -- Tertiary Education Completion Rate,15+ Years,male(percent Of Population Group),
  "monthly_temperature_jan_co" DOUBLE  -- Monthly Temperature - Jan (Co),
  "monthly_temperature_feb_co" DOUBLE  -- Monthly Temperature - Feb (Co),
  "monthly_temperature_mar_co" DOUBLE  -- Monthly Temperature - Mar (Co),
  "monthly_temperature_apr_co" DOUBLE  -- Monthly Temperature - Apr (Co),
  "monthly_temperature_may_co" DOUBLE  -- Monthly Temperature - May (Co),
  "monthly_temperature_jun_co" DOUBLE  -- Monthly Temperature - Jun (Co),
  "monthly_temperature_jul_co" DOUBLE  -- Monthly Temperature - Jul (Co),
  "monthly_temperature_aug_co" DOUBLE  -- Monthly Temperature - Aug (Co),
  "monthly_temperature_sep_co" DOUBLE  -- Monthly Temperature - Sep (Co),
  "monthly_temperature_oct_co" DOUBLE  -- Monthly Temperature - Oct (Co),
  "monthly_temperature_nov_co" DOUBLE  -- Monthly Temperature - Nov (Co),
  "monthly_temperature_dec_co" DOUBLE  -- Monthly Temperature - Dec (Co),
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jan (Co),
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Feb (Co),
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Mar (Co),
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Apr (Co),
  "decadal_average_of_monthly_temperature_may_co" DOUBLE  -- Decadal Average Of Monthly Temperature - May (Co),
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jun (Co),
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Jul (Co),
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Aug (Co),
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Sep (Co),
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Oct (Co),
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Nov (Co),
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Average Of Monthly Temperature - Dec (Co),
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jan (Co),
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Feb (Co),
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Mar (Co),
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Apr (Co),
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - May (Co),
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jun (Co),
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Jul (Co),
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Aug (Co),
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Sep (Co),
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Oct (Co),
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Nov (Co),
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE  -- Decadal Variation Of Monthly Temperature - Dec (Co),
  "temperature_anomaly_jan_co" DOUBLE  -- Temperature Anomaly - Jan (Co),
  "temperature_anomaly_feb_co" DOUBLE  -- Temperature Anomaly - Feb (Co)
);