Global Pollution By Counties
Worldwide waste by countries (inc. all types of pollution by 2010-2020)
@kaggle.zvr842_global_pollution_by_counties
Worldwide waste by countries (inc. all types of pollution by 2010-2020)
@kaggle.zvr842_global_pollution_by_counties
CREATE TABLE country_level_data_0 (
"region_id" VARCHAR,
"country_name" VARCHAR,
"gdp" DOUBLE,
"composition_food_organic_waste_percent" DOUBLE,
"composition_glass_percent" DOUBLE,
"composition_metal_percent" DOUBLE,
"composition_other_percent" DOUBLE,
"composition_paper_cardboard_percent" DOUBLE,
"composition_plastic_percent" DOUBLE,
"composition_rubber_leather_percent" DOUBLE,
"composition_wood_percent" DOUBLE,
"composition_yard_garden_green_waste_percent" DOUBLE,
"other_information_information_system_for_solid_waste_management" VARCHAR,
"other_information_national_agency_to_enforce_solid_was_e169c5a6" VARCHAR,
"other_information_national_law_governing_solid_waste_m_eaee7aec" VARCHAR,
"other_information_ppp_rules_and_regulations" VARCHAR,
"other_information_summary_of_key_solid_waste_informati_a4eb87b7" VARCHAR,
"population_population_number_of_people" BIGINT,
"special_waste_agricultural_waste_tons_year" DOUBLE,
"special_waste_construction_and_demolition_waste_tons_year" DOUBLE,
"special_waste_e_waste_tons_year" DOUBLE,
"special_waste_hazardous_waste_tons_year" DOUBLE,
"special_waste_industrial_waste_tons_year" DOUBLE,
"special_waste_medical_waste_tons_year" DOUBLE,
"total_msw_total_msw_generated_tons_year" DOUBLE,
"waste_collection_coverage_rural_percent_of_geographic_area" DOUBLE,
"waste_collection_coverage_rural_percent_of_households" DOUBLE,
"waste_collection_coverage_rural_percent_of_population" DOUBLE,
"waste_collection_coverage_rural_percent_of_waste" DOUBLE,
"waste_collection_coverage_total_percent_of_geographic_area" DOUBLE,
"waste_collection_coverage_total_percent_of_households" DOUBLE,
"waste_collection_coverage_total_percent_of_population" DOUBLE,
"waste_collection_coverage_total_percent_of_waste" DOUBLE,
"waste_collection_coverage_urban_percent_of_geographic_area" DOUBLE,
"waste_collection_coverage_urban_percent_of_households" DOUBLE,
"waste_collection_coverage_urban_percent_of_population" DOUBLE,
"waste_collection_coverage_urban_percent_of_waste" DOUBLE,
"waste_treatment_anaerobic_digestion_percent" DOUBLE,
"waste_treatment_compost_percent" DOUBLE,
"waste_treatment_controlled_landfill_percent" DOUBLE,
"waste_treatment_incineration_percent" DOUBLE,
"waste_treatment_landfill_unspecified_percent" DOUBLE,
"waste_treatment_open_dump_percent" DOUBLE,
"waste_treatment_other_percent" DOUBLE,
"waste_treatment_recycling_percent" DOUBLE,
"waste_treatment_sanitary_landfill_landfill_gas_system_percent" DOUBLE,
"waste_treatment_unaccounted_for_percent" DOUBLE,
"waste_treatment_waterways_marine_percent" DOUBLE,
"where_where_is_this_data_measured" VARCHAR
);
Anyone who has the link will be able to view this.