Countries
Global Country-Level Statistics
@datacommons.countries
Guernsey - Time Series For Statistical Variables
@datacommons.countries.guernsey_country_ggy
This table contains time series data for 815 statistical variables for location: Guernsey (Data Commons location id: country/GGY).
- 130.52 KB
- 20938 rows
- 12 columns
place_idPlace Id | place_namePlace Name | parent_place_idParent Place Id | parent_place_nameParent Place Name | variableVariable | dateDate | valueValue | measurement_methodMeasurement Method | observation_periodObservation Period | import_nameImport Name | provenance_domainProvenance Domain | datacommons_urlDatacommons Url |
|---|---|---|---|---|---|---|---|---|---|---|---|
| country/GGY | Guernsey | ChannelIslands | Channel Islands | sdg/SI_COV_UEMP.SEX--F | 2019 | 100 | SDG_E_A_G | UN_SDG | un.org | https://datacommons.org/browser/country/GGY?statVar=sdg/SI_COV_UEMP.SEX--F | |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 | 2030 | -4.79 | MixtureGaussianDistribution | P10Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 | 2010 | -4.6 | MixtureGaussianDistribution | P10Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 | 2020 | -5.77 | MixtureGaussianDistribution | P10Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 | 2040 | -5.57 | MixtureGaussianDistribution | P10Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_5PctProb_LessThan_Atleast1DayADecade_CMIP6_HADGEM3-GC31-LL_SSP245 |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical | 2004 | 0.14 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical | 1992 | 0.58 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical | 1990 | 0.63 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical | 2007 | 1.36 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical |
| country/GGY | Guernsey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical | 1989 | 0.87 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/GGY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_GFDL-CM4_Historical |
CREATE TABLE guernsey_country_ggy (
"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
);