Ozone Layer
Ozone more Like O zone. Not funny
@kaggle.programmerrdai_ozone_layer
Ozone more Like O zone. Not funny
@kaggle.programmerrdai_ozone_layer
CREATE TABLE antarctic_ozone_hole_area (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"maximum_ozone_hole_area_nasa" DOUBLE,
"mean_ozone_hole_area" BIGINT
);
CREATE TABLE change_in_cfc_11_concentrations (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"cfc_11_measurement" DOUBLE,
"wmo_2014" DOUBLE
);
CREATE TABLE consumption_of_ozone_depleting_substances (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"consumption_of_ozone_depleting_substances_all" DOUBLE
);
CREATE TABLE countries_to_montreal_protocol_and_vienna_convention (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"vienna_convention_and_montreal_protocol_parties_subscr_7f11c7d9" BIGINT
);
CREATE TABLE excess_skin_cancer_cases_due_to_ozone_depletion (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"excess_skin_cancer_cases_per_million_copenhagen_amendments" BIGINT,
"excess_skin_cancer_cases_per_million_montreal_protocol" BIGINT,
"excess_skin_cancer_cases_per_million_no_restrictions" BIGINT
);
CREATE TABLE expected_concentraitons_of_cfc_11 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"northern_hemisphere" DOUBLE,
"southern_hemisphere" DOUBLE,
"wmo_2014" DOUBLE
);
CREATE TABLE number_of_parties_env_agreements (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"cartagena_protocol_on_biosafety" BIGINT,
"convention_on_biological_diversity_cbd" BIGINT,
"cites_convention_on_international_trade_in_endangered__bbaa5d59" BIGINT,
"convention_on_the_conservation_of_migratory_species_of_b71dd8d4" BIGINT,
"world_heritage_convention" BIGINT,
"kyoto_protocol" BIGINT,
"vienna_convention_ozone" BIGINT,
"ramsar_convention" BIGINT,
"rotterdam_convention" BIGINT,
"stockholm_convention_on_persistent_organic_pollutants" BIGINT,
"un_convention_to_combat_desertification_unccd" BIGINT,
"un_convention_on_the_law_of_the_sea_unclos" BIGINT,
"un_framework_convention_on_climate_change_unfccc" BIGINT
);
CREATE TABLE ozone_depleting_substance_consumption (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"consumption_of_ozone_depleting_substances_methyl_bromide" DOUBLE,
"consumption_of_ozone_depleting_substances_carbon_tetrachloride" DOUBLE,
"consumption_of_ozone_depleting_substances_hydrochlorof_da5ab44f" DOUBLE,
"consumption_of_ozone_depleting_substances_chlorofluoro_8367bbca" DOUBLE,
"consumption_of_ozone_depleting_substances_methyl_chloroform" DOUBLE,
"consumption_of_ozone_depleting_substances_halons" DOUBLE
);
CREATE TABLE ozone_depleting_substance_emissions (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"ozone_depleting_substance_emissions_scientific_assessment_2014" BIGINT
);
CREATE TABLE ozone_depleting_substances_index (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"ozone_depleting_emissions_index_1986_100" DOUBLE
);
CREATE TABLE stratospheric_chorine_concentrations (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"equivalent_stratospheric_chorine_esc_1960_0" DOUBLE
);
CREATE TABLE stratospheric_ozone_concentration_projections (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"ozone_concentration_1960_0" DOUBLE
);
CREATE TABLE stratospheric_ozone_concentration (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"minimum_daily_concentration_nasa" BIGINT,
"mean_daily_concentration_nasa" DOUBLE
);
Anyone who has the link will be able to view this.