Name: Ozone Layer
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Ozone Layer

The ozone layer or ozone shield is a region of Earth's stratosphere that absorbs most of the Sun's ultraviolet radiation. It contains a high concentration of ozone in relation to other parts of the atmosphere, although still small in relation to other gases in the stratosphere. Wikipedia

@article{owidozonelayer,
author = {Hannah Ritchie and Max Roser},
title = {Ozone Layer},
journal = {Our World in Data},
year = {2018},
note = {https://ourworldindata.org/ozone-layer}
}

Tables

Antarctic Ozone Hole Area

@kaggle.programmerrdai_ozone_layer.antarctic_ozone_hole_area

4.96 kB
41 rows
5 columns

CREATE TABLE antarctic_ozone_hole_area (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "maximum_ozone_hole_area_nasa" DOUBLE  -- Maximum Ozone Hole Area (NASA),
  "mean_ozone_hole_area" BIGINT
);

Change In Cfc 11 Concentrations

@kaggle.programmerrdai_ozone_layer.change_in_cfc_11_concentrations

4.47 kB
24 rows
5 columns

CREATE TABLE change_in_cfc_11_concentrations (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cfc_11_measurement" DOUBLE,
  "wmo_2014" DOUBLE  -- WMO (2014)
);

Consumption Of Ozone Depleting Substances

@kaggle.programmerrdai_ozone_layer.consumption_of_ozone_depleting_substances

30.9 kB
4,733 rows
4 columns

CREATE TABLE consumption_of_ozone_depleting_substances (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "consumption_of_ozone_depleting_substances_all" DOUBLE  -- Consumption Of Ozone-Depleting Substances - All
);

Countries To Montreal Protocol And Vienna Convention

@kaggle.programmerrdai_ozone_layer.countries_to_montreal_protocol_and_vienna_convention

9.26 kB
6,467 rows
4 columns

CREATE TABLE countries_to_montreal_protocol_and_vienna_convention (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "vienna_convention_and_montreal_protocol_parties_subscr_7f11c7d9" BIGINT  -- Vienna Convention And Montreal Protocol (Parties Subscribing Each Year)
);

Excess Skin Cancer Cases Due To Ozone Depletion

@kaggle.programmerrdai_ozone_layer.excess_skin_cancer_cases_due_to_ozone_depletion

6.1 kB
10 rows
6 columns

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 (Copenhagen Amendments),
  "excess_skin_cancer_cases_per_million_montreal_protocol" BIGINT  -- Excess Skin Cancer Cases Per Million (Montreal Protocol),
  "excess_skin_cancer_cases_per_million_no_restrictions" BIGINT  -- Excess Skin Cancer Cases Per Million (no Restrictions)
);

Expected Concentraitons Of Cfc 11

@kaggle.programmerrdai_ozone_layer.expected_concentraitons_of_cfc_11

5.53 kB
31 rows
6 columns

CREATE TABLE expected_concentraitons_of_cfc_11 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "northern_hemisphere" DOUBLE,
  "southern_hemisphere" DOUBLE,
  "wmo_2014" DOUBLE  -- WMO (2014)
);

Number Of Parties Env Agreements

@kaggle.programmerrdai_ozone_layer.number_of_parties_env_agreements

16.34 kB
45 rows
16 columns

CREATE TABLE number_of_parties_env_agreements (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "cartagena_protocol_on_biosafety" BIGINT,
  "convention_on_biological_diversity_cbd" BIGINT  -- Convention On Biological Diversity (CBD),
  "cites_convention_on_international_trade_in_endangered__bbaa5d59" BIGINT  -- Cites Convention On International Trade In Endangered Species Of Wild Fauna Nad Flora,
  "convention_on_the_conservation_of_migratory_species_of_b71dd8d4" BIGINT  -- Convention On The Conservation Of Migratory Species Of Wild Animals,
  "world_heritage_convention" BIGINT,
  "kyoto_protocol" BIGINT,
  "vienna_convention_ozone" BIGINT  -- Vienna Convention (Ozone),
  "ramsar_convention" BIGINT,
  "rotterdam_convention" BIGINT,
  "stockholm_convention_on_persistent_organic_pollutants" BIGINT,
  "un_convention_to_combat_desertification_unccd" BIGINT  -- UN Convention To Combat Desertification (UNCCD),
  "un_convention_on_the_law_of_the_sea_unclos" BIGINT  -- UN Convention On The Law Of The Sea (UNCLOS),
  "un_framework_convention_on_climate_change_unfccc" BIGINT  -- UN Framework Convention On Climate Change (UNFCCC)
);

Ozone Depleting Substance Consumption

@kaggle.programmerrdai_ozone_layer.ozone_depleting_substance_consumption

76 kB
4,733 rows
9 columns

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 - Methyl Bromide,
  "consumption_of_ozone_depleting_substances_carbon_tetrachloride" DOUBLE  -- Consumption Of Ozone-Depleting Substances - Carbon Tetrachloride,
  "consumption_of_ozone_depleting_substances_hydrochlorof_da5ab44f" DOUBLE  -- Consumption Of Ozone-Depleting Substances - Hydrochlorofluorocarbons (HCFCs),
  "consumption_of_ozone_depleting_substances_chlorofluoro_8367bbca" DOUBLE  -- Consumption Of Ozone-Depleting Substances - Chlorofluorocarbons (CFCs),
  "consumption_of_ozone_depleting_substances_methyl_chloroform" DOUBLE  -- Consumption Of Ozone-Depleting Substances - Methyl Chloroform,
  "consumption_of_ozone_depleting_substances_halons" DOUBLE  -- Consumption Of Ozone-Depleting Substances - Halons
);

Ozone Depleting Substance Emissions

@kaggle.programmerrdai_ozone_layer.ozone_depleting_substance_emissions

4.45 kB
108 rows
4 columns

CREATE TABLE ozone_depleting_substance_emissions (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "ozone_depleting_substance_emissions_scientific_assessment_2014" BIGINT  -- Ozone-depleting Substance Emissions (Scientific Assessment 2014)
);

Ozone Depleting Substances Index

@kaggle.programmerrdai_ozone_layer.ozone_depleting_substances_index

3.97 kB
31 rows
4 columns

CREATE TABLE ozone_depleting_substances_index (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "ozone_depleting_emissions_index_1986_100" DOUBLE  -- Ozone Depleting Emissions (Index 1986 \u003d 100)
);

Stratospheric Chorine Concentrations

@kaggle.programmerrdai_ozone_layer.stratospheric_chorine_concentrations

4.22 kB
87 rows
4 columns

CREATE TABLE stratospheric_chorine_concentrations (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "equivalent_stratospheric_chorine_esc_1960_0" DOUBLE  -- Equivalent Stratospheric Chorine (ESC) (1960 \u003d 0)
);

Stratospheric Ozone Concentration

@kaggle.programmerrdai_ozone_layer.stratospheric_ozone_concentration

4.96 kB
41 rows
5 columns

CREATE TABLE stratospheric_ozone_concentration (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "minimum_daily_concentration_nasa" BIGINT  -- Minimum Daily Concentration (NASA),
  "mean_daily_concentration_nasa" DOUBLE  -- Mean Daily Concentration (NASA)
);

Stratospheric Ozone Concentration Projections

@kaggle.programmerrdai_ozone_layer.stratospheric_ozone_concentration_projections

4.1 kB
87 rows
4 columns

CREATE TABLE stratospheric_ozone_concentration_projections (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "ozone_concentration_1960_0" DOUBLE  -- Ozone Concentration (1960 \u003d 0)
);