Countries
Global Country-Level Statistics
@datacommons.countries
Philippines - Time Series For Statistical Variables
@datacommons.countries.philippines_country_phl
This table contains time series data for 7362 statistical variables for location: Philippines (Data Commons location id: country/PHL).
- 2.6 MB
- 293407 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/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2036 | 6.67813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2035 | 6.82813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2034 | 6.77813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2021 | 6.63813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2033 | 6.72813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2025 | 6.67813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2040 | 6.97813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2032 | 6.92813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2022 | 6.63813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
| country/PHL | Philippines | SouthEasternAsia | South-Eastern Asia | DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 | 2047 | 7.50813333333333 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_Prediction_Diffs | nasa.gov | https://datacommons.org/browser/country/PHL?statVar=DiffRelativeToAvg_1980_2010_MinTemp_Daily_GaussianMixture_95PctProb_LessThan_Atleast1DayAYear_CMIP6_Ensemble_SSP585 |
CREATE TABLE philippines_country_phl (
"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
);