Dataset: States

This table contains time series data for 5 statistical variables for location: Howland Island (Data Commons location id: geoId/84).

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/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_Person	2015		WikidataPopulation		WikidataPopulation	wikimediafoundation.org	https://datacommons.org/browser/geoId/84?statVar=Count_Person
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_Person	1942-01-31	2	WikidataPopulation		WikidataPopulation	wikimediafoundation.org	https://datacommons.org/browser/geoId/84?statVar=Count_Person
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_MarineThunderstormWindEvent	2006-03	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_MarineThunderstormWindEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_MarineThunderstormWindEvent	2006	1		P1Y	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_MarineThunderstormWindEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2002-09	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2014-01	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2011-04	2		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2019-04	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2015-06	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent
geoId/84	Howland Island	country/UMI	U.S. Minor Outlying Islands	Count_WaterspoutEvent	2009-12	1		P1M	StormNOAA_Agg	noaa.gov	https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

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

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_Person

2015

WikidataPopulation

wikimediafoundation.org

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

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_Person

1942-01-31

WikidataPopulation

wikimediafoundation.org

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

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_MarineThunderstormWindEvent

2006-03

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_MarineThunderstormWindEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_MarineThunderstormWindEvent

2006

P1Y

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_MarineThunderstormWindEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2002-09

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2014-01

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2011-04

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2019-04

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2015-06

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

geoId/84

Howland Island

country/UMI

U.S. Minor Outlying Islands

Count_WaterspoutEvent

2009-12

P1M

StormNOAA_Agg

noaa.gov

https://datacommons.org/browser/geoId/84?statVar=Count_WaterspoutEvent

CREATE TABLE howland_island_geoid_84 ( "place_id" VARCHAR, "place_name" VARCHAR, "parent_place_id" VARCHAR, "parent_place_name" VARCHAR, "variable" VARCHAR, "date" VARCHAR, "value" BIGINT, "measurement_method" VARCHAR, "observation_period" VARCHAR, "import_name" VARCHAR, "provenance_domain" VARCHAR, "datacommons_url" VARCHAR );

States

Table List

Howland Island - Time Series For Statistical Variables

@datacommons.states.howland_island_geoid_84

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