Baselight
Sign In

Bangladesh Spatial Database

A rich variety of indicators about Bangladesh

@kaggle.leekahwin_bangladesh_spatial_database

Loading...
Loading...

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
  • 233.09 KB
  • 21 rows
  • 228 columns
Loading... 

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_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE,
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE,
  "temperature_anomaly_jan_co" DOUBLE,
  "temperature_anomaly_feb_co" DOUBLE,
  "temperature_anomaly_mar_co" DOUBLE,
  "temperature_anomaly_apr_co" DOUBLE,
  "temperature_anomaly_may_co" DOUBLE,
  "temperature_anomaly_jun_co" DOUBLE,
  "temperature_anomaly_jul_co" DOUBLE,
  "temperature_anomaly_aug_co" DOUBLE,
  "temperature_anomaly_sep_co" DOUBLE,
  "temperature_anomaly_oct_co" DOUBLE,
  "temperature_anomaly_nov_co" DOUBLE,
  "temperature_anomaly_dec_co" DOUBLE,
  "precipitation_jan_millimeters" DOUBLE,
  "precipitation_feb_millimeters" DOUBLE,
  "precipitation_mar_millimeters" DOUBLE,
  "precipitation_apr_millimeters" DOUBLE,
  "precipitation_may_millimeters" DOUBLE,
  "precipitation_jun_millimeters" DOUBLE,
  "precipitation_jul_millimeters" DOUBLE,
  "precipitation_aug_millimeters" DOUBLE,
  "precipitation_sep_millimeters" DOUBLE,
  "precipitation_oct_millimeters" DOUBLE,
  "precipitation_nov_millimeters" DOUBLE,
  "precipitation_dec_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE
);

N 2001 Bgd L2

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l2
  • 257.56 KB
  • 192 rows
  • 179 columns
Loading... 

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_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE,
  "temperature_anomaly_jan_co" DOUBLE,
  "temperature_anomaly_feb_co" DOUBLE,
  "temperature_anomaly_mar_co" DOUBLE,
  "temperature_anomaly_apr_co" DOUBLE,
  "temperature_anomaly_may_co" DOUBLE,
  "temperature_anomaly_jun_co" DOUBLE,
  "temperature_anomaly_jul_co" DOUBLE,
  "temperature_anomaly_aug_co" DOUBLE,
  "temperature_anomaly_sep_co" DOUBLE,
  "temperature_anomaly_oct_co" DOUBLE,
  "temperature_anomaly_nov_co" DOUBLE,
  "temperature_anomaly_dec_co" DOUBLE,
  "precipitation_jan_millimeters" DOUBLE,
  "precipitation_feb_millimeters" DOUBLE,
  "precipitation_mar_millimeters" DOUBLE,
  "precipitation_apr_millimeters" DOUBLE,
  "precipitation_may_millimeters" DOUBLE,
  "precipitation_jun_millimeters" DOUBLE,
  "precipitation_jul_millimeters" DOUBLE,
  "precipitation_aug_millimeters" DOUBLE,
  "precipitation_sep_millimeters" DOUBLE,
  "precipitation_oct_millimeters" DOUBLE,
  "precipitation_nov_millimeters" DOUBLE,
  "precipitation_dec_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE
);

N 2001 Bgd L3

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l3
  • 471.54 KB
  • 1632 rows
  • 164 columns
Loading... 

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_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE,
  "temperature_anomaly_jan_co" DOUBLE,
  "temperature_anomaly_feb_co" DOUBLE,
  "temperature_anomaly_mar_co" DOUBLE,
  "temperature_anomaly_apr_co" DOUBLE,
  "temperature_anomaly_may_co" DOUBLE,
  "temperature_anomaly_jun_co" DOUBLE,
  "temperature_anomaly_jul_co" DOUBLE,
  "temperature_anomaly_aug_co" DOUBLE,
  "temperature_anomaly_sep_co" DOUBLE,
  "temperature_anomaly_oct_co" DOUBLE,
  "temperature_anomaly_nov_co" DOUBLE,
  "temperature_anomaly_dec_co" DOUBLE,
  "precipitation_jan_millimeters" DOUBLE,
  "precipitation_feb_millimeters" DOUBLE,
  "precipitation_mar_millimeters" DOUBLE,
  "precipitation_apr_millimeters" DOUBLE,
  "precipitation_may_millimeters" DOUBLE,
  "precipitation_jun_millimeters" DOUBLE,
  "precipitation_jul_millimeters" DOUBLE,
  "precipitation_aug_millimeters" DOUBLE,
  "precipitation_sep_millimeters" DOUBLE,
  "precipitation_oct_millimeters" DOUBLE,
  "precipitation_nov_millimeters" DOUBLE,
  "precipitation_dec_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE
);

N 2001 Bgd L4

@kaggle.leekahwin_bangladesh_spatial_database.n_2001_bgd_l4
  • 2.27 MB
  • 23283 rows
  • 159 columns
Loading... 

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,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE,
  "temperature_anomaly_jan_co" DOUBLE,
  "temperature_anomaly_feb_co" DOUBLE,
  "temperature_anomaly_mar_co" DOUBLE,
  "temperature_anomaly_apr_co" DOUBLE,
  "temperature_anomaly_may_co" DOUBLE,
  "temperature_anomaly_jun_co" DOUBLE,
  "temperature_anomaly_jul_co" DOUBLE,
  "temperature_anomaly_aug_co" DOUBLE,
  "temperature_anomaly_sep_co" DOUBLE,
  "temperature_anomaly_oct_co" DOUBLE,
  "temperature_anomaly_nov_co" DOUBLE,
  "temperature_anomaly_dec_co" DOUBLE,
  "precipitation_jan_millimeters" DOUBLE,
  "precipitation_feb_millimeters" DOUBLE,
  "precipitation_mar_millimeters" DOUBLE,
  "precipitation_apr_millimeters" DOUBLE,
  "precipitation_may_millimeters" DOUBLE,
  "precipitation_jun_millimeters" DOUBLE,
  "precipitation_jul_millimeters" DOUBLE,
  "precipitation_aug_millimeters" DOUBLE,
  "precipitation_sep_millimeters" DOUBLE,
  "precipitation_oct_millimeters" DOUBLE,
  "precipitation_nov_millimeters" DOUBLE,
  "precipitation_dec_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jan_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_feb_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_mar_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_apr_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_may_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jun_millimeters" DOUBLE,
  "decadal_average_of_monthly_precipitation_jul_millimeters" DOUBLE
);

N 2011 Bgd L1

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l1
  • 394.3 KB
  • 23 rows
  • 368 columns
Loading... 

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_by_size_1_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE,
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE,
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE,
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE,
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE,
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE,
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE,
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE,
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE,
  "formal_manu_food_beverage_tobacco_10_11_12_percent_of__638a659a" DOUBLE,
  "formal_manu_textiles_apparel_leather_13_14_15_percent__2d43f126" DOUBLE,
  "formal_manu_wood_paper_products_16_17_percent_of_estab_dca6e092" DOUBLE,
  "formal_manu_printing_recorded_media_18_percent_of_esta_b929128d" DOUBLE,
  "formal_manu_coke_and_refined_petroleum_19_percent_of_e_76ee679f" DOUBLE,
  "formal_manu_chemicals_pharmaceuticals_20_21_percent_of_d750a596" DOUBLE,
  "formal_manu_rubber_plastics_nonmetallic_mineral_22_23__1f127765" DOUBLE,
  "formal_manu_basic_metals_fabricated_metals_24_25_perce_0339b989" DOUBLE,
  "formal_manu_computer_electronic_optical_26_percent_of__1ca5376a" DOUBLE,
  "formal_manu_electrical_equipment_27_percent_of_establishments" DOUBLE,
  "formal_manu_machinery_and_equipment_28_percent_of_esta_3779169b" DOUBLE,
  "formal_manu_transportation_equipment_29_30_percent_of__3d36468a" DOUBLE,
  "formal_manu_other_31_32_33_34_percent_of_establishments" DOUBLE,
  "average_size_of_formal_manufacturing_enterprises_numbe_5cef2836" DOUBLE,
  "gender_ratio_all_ages_percent" DOUBLE,
  "gender_ratio_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE,
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE,
  "lp_formal_manu_all_current_usd_per_worker" DOUBLE,
  "lp_formal_manu_food_beverage_tobacco_10_11_12_current__eb2183e9" DOUBLE,
  "lp_formal_manu_textiles_apparel_leather_13_14_15_curre_201f4866" DOUBLE,
  "lp_formal_manu_wood_paper_products_16_17_current_usd_p_0571d82c" DOUBLE,
  "lp_formal_manu_printing_recorded_media_18_current_usd__7faf9b96" DOUBLE,
  "lp_formal_manu_coke_and_refined_petroleum_19_current_u_6534d647" DOUBLE,
  "lp_formal_manu_chemicals_pharmaceuticals_20_21_current_3e4e8a32" DOUBLE,
  "lp_formal_manu_rubber_plastics_nonmetallic_mineral_22__02ee5f22" DOUBLE,
  "lp_formal_manu_basic_metals_fabricated_metals_24_25_cu_d01e9b1b" DOUBLE,
  "lp_formal_manu_computer_electronic_optical_26_current__14cf1be2" DOUBLE,
  "lp_formal_manu_electrical_equipment_27_current_usd_per_worker" DOUBLE,
  "lp_formal_manu_machinery_and_equipment_28_current_usd__27542c6d" DOUBLE,
  "lp_formal_manu_transportation_equipment_29_30_current__6c554878" DOUBLE,
  "lp_formal_manu_other_31_32_33_34_current_usd_per_worker" DOUBLE,
  "k_l_formal_manu_all_current_usd_per_worker" DOUBLE,
  "k_l_formal_manu_food_beverage_tobacco_10_11_12_current_9e7d5c94" DOUBLE,
  "k_l_formal_manu_textiles_apparel_leather_13_14_15_curr_746825b0" DOUBLE,
  "k_l_formal_manu_wood_paper_products_16_17_current_usd__2fc8495c" DOUBLE,
  "k_l_formal_manu_printing_recorded_media_18_current_usd_a9d08c50" DOUBLE,
  "k_l_formal_manu_coke_and_refined_petroleum_19_current__7905a9db" DOUBLE,
  "k_l_formal_manu_chemicals_pharmaceuticals_20_21_curren_18891392" DOUBLE,
  "k_l_formal_manu_rubber_plastics_nonmetallic_mineral_22_cf7c9609" DOUBLE,
  "k_l_formal_manu_basic_metals_fabricated_metals_24_25_c_6d9706dd" DOUBLE,
  "k_l_formal_manu_computer_electronic_optical_26_current_9c057501" DOUBLE
);

N 2011 Bgd L2

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l2
  • 401.54 KB
  • 192 rows
  • 276 columns
Loading... 

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_by_size_1_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE,
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE,
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE,
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE,
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE,
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE,
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE,
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE,
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE,
  "gender_ratio_all_ages_percent" DOUBLE,
  "gender_ratio_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "crude_birth_rate_total_live_births_per_1000_people" DOUBLE,
  "crude_death_rate_total_deaths_per_1000_people" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "pupil_teacher_ratio_in_primary_schools_students_per_teacher" DOUBLE,
  "gross_primary_enrollment_total_percent_of_population_group" DOUBLE,
  "gross_primary_enrollment_female_percent_of_population_group" DOUBLE,
  "gross_primary_enrollment_male_percent_of_population_group" DOUBLE,
  "out_of_school_children_total_percent_of_population_group" DOUBLE,
  "out_of_school_children_female_percent_of_population_group" DOUBLE,
  "out_of_school_children_male_percent_of_population_group" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE
);

N 2011 Bgd L3

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l3
  • 657.27 KB
  • 1632 rows
  • 225 columns
Loading... 

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_by_size_1_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE,
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE,
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE,
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE,
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE,
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE,
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE,
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE,
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE,
  "gender_ratio_all_ages_percent" DOUBLE,
  "gender_ratio_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "crop_yield_monetary_all_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_millets_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_pulses_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_rice_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_sugar_cane_2011_usd_per_ha_in_thousands" VARCHAR,
  "crop_yield_monetary_wheat_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_maize_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_monetary_groundnut_2011_usd_per_ha_in_thousands" DOUBLE,
  "crop_yield_quantity_all_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_millets_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_pulses_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_rice_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_sugar_cane_tonnes_per_ha" VARCHAR,
  "crop_yield_quantity_wheat_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_maize_tonnes_per_ha" DOUBLE,
  "crop_yield_quantity_groundnut_tonnes_per_ha" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE
);

N 2011 Bgd L4

@kaggle.leekahwin_bangladesh_spatial_database.n_2011_bgd_l4
  • 3.19 MB
  • 23283 rows
  • 209 columns
Loading... 

CREATE TABLE n_2011_bgd_l4 (
  "unnamed_0" VARCHAR,
  "spatial_database_year" DOUBLE,
  "unnamed_2" 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,
  "non_agr_enterprises_thousands" DOUBLE,
  "non_agr_enterprises_by_size_1_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_2_5_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_6_9_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_10_19_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_20_99_percent_of_establishments" DOUBLE,
  "non_agr_enterprises_by_size_100_percent_of_establishments" DOUBLE,
  "non_agr_by_sect_isic3_1_mining_and_quarrying_c_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_manufacturing_d_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_electricity_gas_and_water_supp_50b33465" DOUBLE,
  "non_agr_by_sect_isic3_1_construction_f_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_trade_hotels_and_restaurants_g_de8f767e" DOUBLE,
  "non_agr_by_sect_isic3_1_trans_storage_and_communicatio_ab259ffc" DOUBLE,
  "non_agr_by_sect_isic3_1_financial_intermediation_j_per_87d2890e" DOUBLE,
  "non_agr_by_sect_isic3_1_real_estate_business_activitie_c051506d" DOUBLE,
  "non_agr_by_sect_isic3_1_public_administration_l_percent_of_est" DOUBLE,
  "non_agr_by_sect_isic3_1_education_health_and_social_m__857b647a" DOUBLE,
  "non_agr_enterprises_by_ownership_private_percent_of_es_1c42c095" DOUBLE,
  "non_agr_enterprises_by_ownership_public_percent_of_est_4165f389" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__84713076" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_2_efa7b835" DOUBLE,
  "diversification_index_of_non_agr_enterprises_isic_3_1__e747a393" DOUBLE,
  "specialization_index_of_non_agr_enterprises_isic_3_1_4_ee58890a" DOUBLE,
  "gender_ratio_all_ages_percent" DOUBLE,
  "gender_ratio_0_4_years_percent" DOUBLE,
  "gender_ratio_at_birth_percent" DOUBLE,
  "dependency_ratio_0_14_or_65_years_percent" DOUBLE,
  "dependency_ratio_65_years_percent" DOUBLE,
  "dependency_ratio_0_14_years_percent" DOUBLE,
  "ethnic_population_percent" DOUBLE,
  "muslim_population_percent" DOUBLE,
  "hindu_population_percent" DOUBLE,
  "christian_population_percent" DOUBLE,
  "buddhist_population_percent" DOUBLE,
  "other_religion_population_percent" DOUBLE,
  "light_intensity_per_1000_people_digital_numbers_of_lig_27c621b2" DOUBLE,
  "light_intensity_per_area_digital_numbers_of_light_per_sq_km" DOUBLE,
  "literacy_rate_7_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_7_years_male_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_total_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_female_percent_of_population_group" DOUBLE,
  "literacy_rate_15_years_male_percent_of_population_group" DOUBLE,
  "secondary_education_completion_rate_15_years_total_per_7a3611ad" DOUBLE,
  "secondary_education_completion_rate_15_years_female_pe_aeb4b9fa" DOUBLE,
  "secondary_education_completion_rate_15_years_male_perc_160a498d" DOUBLE,
  "tertiary_education_completion_rate_15_years_total_perc_fec1e0d5" DOUBLE,
  "tertiary_education_completion_rate_15_years_female_per_78b63a34" DOUBLE,
  "tertiary_education_completion_rate_15_years_male_perce_1cc9a252" DOUBLE,
  "monthly_temperature_jan_co" DOUBLE,
  "monthly_temperature_feb_co" DOUBLE,
  "monthly_temperature_mar_co" DOUBLE,
  "monthly_temperature_apr_co" DOUBLE,
  "monthly_temperature_may_co" DOUBLE,
  "monthly_temperature_jun_co" DOUBLE,
  "monthly_temperature_jul_co" DOUBLE,
  "monthly_temperature_aug_co" DOUBLE,
  "monthly_temperature_sep_co" DOUBLE,
  "monthly_temperature_oct_co" DOUBLE,
  "monthly_temperature_nov_co" DOUBLE,
  "monthly_temperature_dec_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_average_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_average_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_average_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_average_of_monthly_temperature_may_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_average_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_average_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_average_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_average_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_average_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_average_of_monthly_temperature_dec_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jan_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_feb_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_mar_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_apr_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_may_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jun_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_jul_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_aug_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_sep_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_oct_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_nov_co" DOUBLE,
  "decadal_variation_of_monthly_temperature_dec_co" DOUBLE,
  "temperature_anomaly_jan_co" DOUBLE,
  "temperature_anomaly_feb_co" DOUBLE
);

Share link

Anyone who has the link will be able to view this.