variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

8 rows where datasetId = 5327 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, createdAt (date), updatedAt (date)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
147037 no_species_shortterm_nochange   Number of butterfly species in the UK that have seen little change in population size over the short-term (from 2014 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Little change",
    "includeInTable": true
}
 0           1                                  
147036 no_species_shortterm_decrease   Number of butterfly species in the UK that have seen a decrease in population size over the short-term (from 2014 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Decrease",
    "includeInTable": true
}
 0           1                                  
147035 no_species_shortterm_increase   Number of butterfly species in the UK that have seen an increase in population size over the short-term (from 2014 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Increase",
    "includeInTable": true
}
 0           1                                  
147034 no_species_longterm_nochange   Number of butterfly species in the UK that have seen little change in population size over the long-term (from 1976 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Little change",
    "includeInTable": true
}
 0           1                                  
147033 no_species_longterm_decrease   Number of butterfly species in the UK that have seen a decrease in population size over the long-term (from 1976 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Decrease",
    "includeInTable": true
}
 0           1                                  
147032 no_species_longterm_increase   Number of butterfly species in the UK that have seen an increase in population size over the long-term (from 1976 to 2019). 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "Increase",
    "includeInTable": true
}
 0           1                                  
147031 butterfly_population_smoothed_index   The year-to-year fluctuations in butterfly numbers are often linked to natural environmental variation, especially weather conditions. Therefore, in order to identify underlying patterns in population trends, the assessment of change is based on smoothed indices. 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "UK butterfly populations, smoothed index",
    "includeInTable": true
}
 0           1                                  
147030 butterfly_population_unsmoothed_index   UK butterfly populations are measured relative to their numbers in 1976 (where 1976 = 100). The base year for farmland and woodland species is 1990. This is because prior to this date, there are insufficient data for a number of species included within the 2 indices. 2021-06-19 10:16:33 2023-06-15 05:05:42       UK Butterfly Populations (UK ONS) 5327 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 18047   
{
    "name": "UK butterfly populations, unsmoothed index",
    "unit": "(1976 = 100)",
    "includeInTable": true
}
 0           1                                  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");