Counties

County-Level Data for Regional Insights

@datacommons.counties

Table List

3390 tables(117.53 GB)

results for

Humphreys County - Time Series For Statistical Variables

@datacommons.counties.humphreys_county_geoid_47085

This table contains time series data for 30626 statistical variables for location: Humphreys County (Data Commons location id: geoId/47085).

35.48 MB
3748010 rows
12 columns

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	measurement_method Measurement Method	observation_period Observation Period	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
geoId/47085	Humphreys County	geoId/47	Tennessee	dc/k389kx8rkkc58	2014	0.023850763		P2Y	OpportunityInsightsOutcomes	opportunityinsights.org	https://datacommons.org/browser/geoId/47085?statVar=dc/k389kx8rkkc58
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	1994-11	-0.0000860000000000001	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	2006-09	-0.000759999999999999	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	1999-08	0.0000269999999999992	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	2011-03	0.000517999999999999	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	1992-11	0.000363	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	2001-06	-0.0000189999999999982	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	2014-10	0.000407000000000001	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	1996-06	-0.00033	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity
geoId/47085	Humphreys County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity	2008-02	0.000592000000000001	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47085?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate1990_Humidity_SpecificHumidity


CREATE TABLE humphreys_county_geoid_47085 (
  "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
);