Baselight
Sign In

Countries

Global Country-Level Statistics

@datacommons.countries

Svalbard And Jan Mayen - Time Series For Statistical Variables
@datacommons.countries.svalbard_and_jan_mayen_country_sjm

This table contains time series data for 158 statistical variables for location: Svalbard and Jan Mayen (Data Commons location id: country/SJM).

  • 22.49 KB
  • 1491 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

country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR200451.15855SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR20000.34291SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR202194.05489SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR201465.27388SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR201865.27388SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR202394.05489SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR200351.15855SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR201265.27388SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR201365.27388SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR
country/SJMSvalbard and Jan MayenNorthernEuropeNorthern Europesdg/ER_PTD_FRHWTR20020.34291SDG_C_A_GUN_SDGun.orghttps://datacommons.org/browser/country/SJM?statVar=sdg/ER_PTD_FRHWTR

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

Share link

Anyone who has the link will be able to view this.