Counties

County-Level Data for Regional Insights

@datacommons.counties

Table List

3390 tables(117.53 GB)

results for

Marshall County - Time Series For Statistical Variables

@datacommons.counties.marshall_county_geoid_47117

This table contains time series data for 33060 statistical variables for location: Marshall County (Data Commons location id: geoId/47117).

36.14 MB
3829293 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/47117	Marshall County	geoId/47	Tennessee	dc/rj3vt2jxvc854	1994	0.5759514		P22Y	OpportunityInsightsOutcomes	opportunityinsights.org	https://datacommons.org/browser/geoId/47117?statVar=dc/rj3vt2jxvc854
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2036-08	-2.47013100000001	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2100-03	-1.26346600000001	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2066-04	0.474373	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2019-11	0.198943999999997	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2098-02	-0.332557999999992	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2029-12	-0.231751000000003	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2081-04	0.0179899999999975	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2066-12	-0.468184999999991	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245
geoId/47117	Marshall County	geoId/47	Tennessee	MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245	2041-11	1.91444399999999	MedianAcrossModels	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrStatsAcrossModels	nasa.gov	https://datacommons.org/browser/geoId/47117?statVar=MedianAcrossModels_DifferenceRelativeToBaseDate2015_Humidity_RelativeHumidity_SSP245


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