Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 1140 statistical variables for location: Swains Island (Data Commons location id: geoId/60040).
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical | 2010 | 29 | HistogramBased | P10Y | NASA_NEXGDDP_CMIP6_Subnational_Histogram | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical | 1980 | 29 | HistogramBased | P10Y | NASA_NEXGDDP_CMIP6_Subnational_Histogram | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical | 2000 | 29 | HistogramBased | P10Y | NASA_NEXGDDP_CMIP6_Subnational_Histogram | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical | 1990 | 29 | HistogramBased | P10Y | NASA_NEXGDDP_CMIP6_Subnational_Histogram | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_Hist_5PctProb_Greater_Atleast1DayADecade_CMIP6_HADGEM3-GC31-MM_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 1995 | 29.71 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 1992 | 29.71 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 2011 | 30.05 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 1980 | 29.97 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 1987 | 29.83 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
geoId/60040 | Swains Island | country/ASM | American Samoa | MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical | 1999 | 29.9 | MixtureGaussianDistribution | P1Y | NASA_NEXGDDP_CMIP6_Subnational_PDFs | nasa.gov | https://datacommons.org/browser/geoId/60040?statVar=MaxTemp_Daily_GaussianMixture_5PctProb_Greater_Atleast1DayAYear_CMIP6_MPI-ESM1-2-HR_Historical |
CREATE TABLE swains_island_geoid_60040 (
"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
);
Anyone who has the link will be able to view this.