Dataset: Counties

This table contains time series data for 9 statistical variables for location: Sonsorol (Data Commons location id: geoId/70370).

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/70370	Sonsorol	country/PLW	Palau	Max_Rainfall	1973-01	4.064	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Max_Rainfall
geoId/70370	Sonsorol	country/PLW	Palau	Min_Temperature	1973-01	24	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Min_Temperature
geoId/70370	Sonsorol	country/PLW	Palau	Count_Person	2015	40	Wikipedia		WikipediaStatsData	wikipedia.org	https://datacommons.org/browser/geoId/70370?statVar=Count_Person
geoId/70370	Sonsorol	country/PLW	Palau	Mean_BarometricPressure	1973-01	1010.5	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Mean_BarometricPressure
geoId/70370	Sonsorol	country/PLW	Palau	Min_Rainfall	1973-01		NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Min_Rainfall
geoId/70370	Sonsorol	country/PLW	Palau	Mean_Temperature	1973-01	27.6667	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Mean_Temperature
geoId/70370	Sonsorol	country/PLW	Palau	Mean_Visibility	1973-01	11.3193	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Mean_Visibility
geoId/70370	Sonsorol	country/PLW	Palau	Mean_Rainfall	1973-01	1.35467	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Mean_Rainfall
geoId/70370	Sonsorol	country/PLW	Palau	Max_Temperature	1973-01	31	NASAGSOD_NASAGHCN_EPA	P1M	NOAA_EPA_Observed_Historical_Weather	noaa.gov	https://datacommons.org/browser/geoId/70370?statVar=Max_Temperature

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

Sonsorol

country/PLW

Palau

Max_Rainfall

1973-01

4.064

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Max_Rainfall

geoId/70370

Sonsorol

country/PLW

Palau

Min_Temperature

1973-01

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Min_Temperature

geoId/70370

Sonsorol

country/PLW

Palau

Count_Person

2015

Wikipedia

WikipediaStatsData

wikipedia.org

https://datacommons.org/browser/geoId/70370?statVar=Count_Person

geoId/70370

Sonsorol

country/PLW

Palau

Mean_BarometricPressure

1973-01

1010.5

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Mean_BarometricPressure

geoId/70370

Sonsorol

country/PLW

Palau

Min_Rainfall

1973-01

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Min_Rainfall

geoId/70370

Sonsorol

country/PLW

Palau

Mean_Temperature

1973-01

27.6667

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Mean_Temperature

geoId/70370

Sonsorol

country/PLW

Palau

Mean_Visibility

1973-01

11.3193

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Mean_Visibility

geoId/70370

Sonsorol

country/PLW

Palau

Mean_Rainfall

1973-01

1.35467

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Mean_Rainfall

geoId/70370

Sonsorol

country/PLW

Palau

Max_Temperature

1973-01

NASAGSOD_NASAGHCN_EPA

P1M

NOAA_EPA_Observed_Historical_Weather

noaa.gov

https://datacommons.org/browser/geoId/70370?statVar=Max_Temperature

CREATE TABLE sonsorol_geoid_70370 ( "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

Sonsorol - Time Series For Statistical Variables

@datacommons.counties.sonsorol_geoid_70370

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