Countries
Global Country-Level Statistics
@datacommons.countries
Jersey - Time Series For Statistical Variables
@datacommons.countries.jersey_country_jey
This table contains time series data for 864 statistical variables for location: Jersey (Data Commons location id: country/JEY).
- 147.45 KB
- 21744 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/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2031 | -0.1 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2026 | -0.1 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2039 | 0.58 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2021 | -1.27 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2028 | 0.09 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2014 | 0.24 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2017 | -0.69 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2024 | 0.24 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2045 | 0.78 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
| country/JEY | Jersey | ChannelIslands | Channel Islands | MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 | 2038 | 0.87 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/country/JEY?statVar=MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_MPI-ESM1-2-LR_SSP245 |
CREATE TABLE jersey_country_jey (
"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
);