Countries

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	measurement_method Measurement Method	observation_period Observation Period	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2018	450461.946473		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2016	434598.518727		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2019	468646.54166		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2021	448826.870904		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2015	443945.126583		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2017	442927.20868		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing	2020	425390.186372		P1Y	ClimateTrace_GHG_Emissions	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_CarbonDioxideEquivalent100YearGlobalWarmingPotential_ClimateTrace_OtherManufacturing
country/REU	Réunion	africa	Africa	Annual_Emissions_GreenhouseGas_FuelCombustionForAviation	2016	628297	ClimateTraceEstimate		ClimateTrace_GHG_Emissions_OldAPI	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_GreenhouseGas_FuelCombustionForAviation
country/REU	Réunion	africa	Africa	Annual_Emissions_GreenhouseGas_FuelCombustionForAviation	2015	628297	ClimateTraceEstimate		ClimateTrace_GHG_Emissions_OldAPI	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_GreenhouseGas_FuelCombustionForAviation
country/REU	Réunion	africa	Africa	Annual_Emissions_GreenhouseGas_FuelCombustionForAviation	2019	604033	ClimateTraceEstimate		ClimateTrace_GHG_Emissions_OldAPI	climatetrace.org	https://datacommons.org/browser/country/REU?statVar=Annual_Emissions_GreenhouseGas_FuelCombustionForAviation


CREATE TABLE r_union_country_reu (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);