Countries
Global Country-Level Statistics
@datacommons.countries
Gambia - Time Series For Statistical Variables
@datacommons.countries.gambia_country_gmb
This table contains time series data for 6226 statistical variables for location: Gambia (Data Commons location id: country/GMB).
- 2 MB
- 242937 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/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2034 | 0.559666666666672 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2043 | 0.949666666666673 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2023 | 0.649666666666668 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2039 | 0.99966666666667 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2044 | 1.04966666666667 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2031 | 0.649666666666668 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2033 | 0.699666666666673 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2037 | 0.849666666666671 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2036 | 0.849666666666671 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
| country/GMB | Gambia | SubSaharanAfrica | Sub-Saharan Africa | DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 | 2042 | 0.949666666666673 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/GMB?statVar=DiffRelativeToAvg_1980_2010_MaxTemp_Daily_GaussianMixture_95PctProb_Greater_Atleast1DayAYear_CMIP6_Ensemble_SSP245 |
CREATE TABLE gambia_country_gmb (
"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
);