Dataset: Counties

This table contains time series data for 28384 statistical variables for location: Mercer County (Data Commons location id: geoId/38057).

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/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2049-06	8.247068	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2051-08	6.119324	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2083-11	7.752228	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2049-02	11.318817	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2038-01	0.162903	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2082-06	10.94589	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2098-04	-1.811706	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2050-06	7.333372	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2064-12	8.695588	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245
geoId/38057	Mercer County	geoId/38	North Dakota	DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245	2021-06	9.016294	NASA_Mean_CMIP6_ACCESS-CM2	P1M	NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats	nasa.gov	https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

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/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2049-06

8.247068

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2051-08

6.119324

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2083-11

7.752228

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2049-02

11.318817

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2038-01

0.162903

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2082-06

10.94589

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2098-04

-1.811706

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2050-06

7.333372

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2064-12

8.695588

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

geoId/38057

Mercer County

geoId/38

North Dakota

DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

2021-06

9.016294

NASA_Mean_CMIP6_ACCESS-CM2

P1M

NASA_NEXGDDP_CMIP6_Subnational_AggrDiffStats

nasa.gov

https://datacommons.org/browser/geoId/38057?statVar=DifferenceRelativeToBaseDate2015_Max_Temperature_SSP245

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

Counties

Table List

Mercer County - Time Series For Statistical Variables

@datacommons.counties.mercer_county_geoid_38057

place_id

place_name

parent_place_id

parent_place_name

variable

date

value

measurement_method

observation_period

import_name

provenance_domain

datacommons_url

Share link