owid

Data license: CC-BY

Custom SQL query returning 50 rows (hide)

This data as json, CSV

typenametbl_namerootpagesql
table charts charts 0 CREATE TABLE charts(id INTEGER, configId VARCHAR, isInheritanceEnabled BOOLEAN, createdAt TIMESTAMP, updatedAt TIMESTAMP, lastEditedAt TIMESTAMP, publishedAt TIMESTAMP, lastEditedByUserId INTEGER, publishedByUserId INTEGER, isIndexable BOOLEAN, config VARCHAR, slug VARCHAR, "type" VARCHAR, title VARCHAR, subtitle VARCHAR, note VARCHAR, title_plus_variant VARCHAR, isPublished BOOLEAN);
table charts_broken_origin_url charts_broken_origin_url 0 CREATE TABLE charts_broken_origin_url(chartId INTEGER, chartSlug VARCHAR, chartEditLink VARCHAR, originUrlAsAuthored VARCHAR, originUrlPostSlug VARCHAR, originUrlPostLink VARCHAR, isPublished BOOLEAN);
table charts_per_dataset charts_per_dataset 0 CREATE TABLE charts_per_dataset(id INTEGER, "name" VARCHAR, n_charts BIGINT);
table charts_same_title_variant charts_same_title_variant 0 CREATE TABLE charts_same_title_variant(title_plus_variant VARCHAR, chartA VARCHAR, chartB VARCHAR);
table charts_without_origin_url charts_without_origin_url 0 CREATE TABLE charts_without_origin_url(title VARCHAR, tags VARCHAR, URL VARCHAR, isPublished BOOLEAN);
table charts_without_tag charts_without_tag 0 CREATE TABLE charts_without_tag(id INTEGER, title VARCHAR, edit_url VARCHAR, chart_edit_url VARCHAR);
table charts_with_manual_year charts_with_manual_year 0 CREATE TABLE charts_with_manual_year(id INTEGER, title VARCHAR, edit_url VARCHAR);
table charts_x_entities charts_x_entities 0 CREATE TABLE charts_x_entities(chartId INTEGER, entityId INTEGER);
table charts_x_parents charts_x_parents 0 CREATE TABLE charts_x_parents(variableId INTEGER, chartId INTEGER);
table chart_configs chart_configs 0 CREATE TABLE chart_configs(id VARCHAR, patch VARCHAR, "full" VARCHAR, slug VARCHAR, chartType VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, fullMd5 VARCHAR);
table chart_dimensions chart_dimensions 0 CREATE TABLE chart_dimensions(id INTEGER, "order" INTEGER, property VARCHAR, chartId INTEGER, variableId INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table chart_slug_redirects chart_slug_redirects 0 CREATE TABLE chart_slug_redirects(id INTEGER, slug VARCHAR, chart_id INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table chart_tags chart_tags 0 CREATE TABLE chart_tags(chartId INTEGER, tagId INTEGER, keyChartLevel UTINYINT, createdAt TIMESTAMP, updatedAt TIMESTAMP, isApproved BOOLEAN);
table chart_variables chart_variables 0 CREATE TABLE chart_variables(chartId INTEGER, variableId INTEGER, PRIMARY KEY(chartId, variableId));
table datasets datasets 0 CREATE TABLE datasets(id INTEGER, "name" VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, namespace VARCHAR, isPrivate BOOLEAN, createdByUserId INTEGER, metadataEditedAt TIMESTAMP, metadataEditedByUserId INTEGER, dataEditedAt TIMESTAMP, dataEditedByUserId INTEGER, nonRedistributable BOOLEAN, isArchived BOOLEAN, sourceChecksum VARCHAR, shortName VARCHAR, "version" VARCHAR, updatePeriodDays INTEGER, catalogPath VARCHAR, "tables" VARCHAR);
table dataset_tags dataset_tags 0 CREATE TABLE dataset_tags(datasetId INTEGER, tagId INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table dods dods 0 CREATE TABLE dods(id INTEGER, "name" VARCHAR, "content" VARCHAR, createdAt TIMESTAMP WITH TIME ZONE, updatedAt TIMESTAMP WITH TIME ZONE, lastUpdatedUserId INTEGER);
table dod_links dod_links 0 CREATE TABLE dod_links(id INTEGER, sourceId INTEGER, target VARCHAR, componentType VARCHAR, linkType VARCHAR, "text" VARCHAR, queryString VARCHAR, hash VARCHAR);
table entities entities 0 CREATE TABLE entities(id INTEGER, code VARCHAR, "name" VARCHAR, validated BOOLEAN, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table explorers explorers 0 CREATE TABLE explorers(slug VARCHAR, config VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, lastEditedByUserId INTEGER, lastEditedAt TIMESTAMP, commitMessage VARCHAR, tsv VARCHAR, isPublished BOOLEAN);
table explorer_charts explorer_charts 0 CREATE TABLE explorer_charts(id INTEGER, explorerSlug VARCHAR, chartId INTEGER);
table explorer_tags explorer_tags 0 CREATE TABLE explorer_tags(id INTEGER, explorerSlug VARCHAR, tagId INTEGER);
table explorer_variables explorer_variables 0 CREATE TABLE explorer_variables(id INTEGER, explorerSlug VARCHAR, variableId INTEGER);
table images images 0 CREATE TABLE images(id INTEGER, googleId VARCHAR, filename VARCHAR, defaultAlt VARCHAR, originalWidth INTEGER, updatedAt BIGINT, originalHeight INTEGER, cloudflareId VARCHAR, hash VARCHAR, userId INTEGER, replacedBy INTEGER, "version" INTEGER);
table multi_dim_data_pages multi_dim_data_pages 0 CREATE TABLE multi_dim_data_pages(id UINTEGER, catalogPath VARCHAR, slug VARCHAR, config VARCHAR, configMd5 VARCHAR, published TINYINT, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table multi_dim_x_chart_configs multi_dim_x_chart_configs 0 CREATE TABLE multi_dim_x_chart_configs(id UINTEGER, multiDimId UINTEGER, viewId VARCHAR, variableId INTEGER, chartConfigId VARCHAR, createdAt TIMESTAMP WITH TIME ZONE, updatedAt TIMESTAMP WITH TIME ZONE);
table namespaces namespaces 0 CREATE TABLE namespaces(id INTEGER, "name" VARCHAR, description VARCHAR, isArchived BOOLEAN, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table narrative_charts narrative_charts 0 CREATE TABLE narrative_charts(id INTEGER, "name" VARCHAR, chartConfigId VARCHAR, parentChartId INTEGER, parentMultiDimXChartConfigId UINTEGER, queryParamsForParentChart VARCHAR, createdAt TIMESTAMP WITH TIME ZONE, updatedAt TIMESTAMP WITH TIME ZONE, lastEditedByUserId INTEGER);
table origins origins 0 CREATE TABLE origins(id INTEGER, titleSnapshot VARCHAR, title VARCHAR, descriptionSnapshot VARCHAR, description VARCHAR, producer VARCHAR, citationFull VARCHAR, attribution VARCHAR, attributionShort VARCHAR, versionProducer VARCHAR, urlMain VARCHAR, urlDownload VARCHAR, dateAccessed DATE, datePublished VARCHAR, license VARCHAR);
table origins_variables origins_variables 0 CREATE TABLE origins_variables(originId INTEGER, variableId INTEGER, displayOrder SMALLINT);
table posts posts 0 CREATE TABLE posts(id INTEGER, title VARCHAR, slug VARCHAR, "type" VARCHAR, status VARCHAR, "content" VARCHAR, archieml VARCHAR, published_at TIMESTAMP, updated_at TIMESTAMP, authors VARCHAR, excerpt VARCHAR, created_at_in_wordpress TIMESTAMP, updated_at_in_wordpress TIMESTAMP, featured_image VARCHAR, formattingOptions VARCHAR, markdown VARCHAR, wpApiSnapshot VARCHAR);
table posts_gdocs posts_gdocs 0 CREATE TABLE posts_gdocs(id VARCHAR, slug VARCHAR, "type" VARCHAR, "content" VARCHAR, authors VARCHAR, published TINYINT, createdAt TIMESTAMP, publishedAt TIMESTAMP, updatedAt TIMESTAMP, publicationContext VARCHAR, revisionId VARCHAR, manualBreadcrumbs VARCHAR, markdown VARCHAR, title VARCHAR);
table posts_gdocs_components posts_gdocs_components 0 CREATE TABLE posts_gdocs_components(id UBIGINT, gdocId VARCHAR, config VARCHAR, parent VARCHAR, path VARCHAR);
table posts_gdocs_links posts_gdocs_links 0 CREATE TABLE posts_gdocs_links(id INTEGER, sourceId VARCHAR, target VARCHAR, linkType VARCHAR, componentType VARCHAR, "text" VARCHAR, queryString VARCHAR, hash VARCHAR);
table posts_gdocs_tombstones posts_gdocs_tombstones 0 CREATE TABLE posts_gdocs_tombstones(id UBIGINT, gdocId VARCHAR, slug VARCHAR, reason VARCHAR, includeArchiveLink BOOLEAN, relatedLinkUrl VARCHAR, relatedLinkTitle VARCHAR, relatedLinkDescription VARCHAR, relatedLinkThumbnail VARCHAR, createdAt TIMESTAMP WITH TIME ZONE, updatedAt TIMESTAMP WITH TIME ZONE);
table posts_gdocs_variables_faqs posts_gdocs_variables_faqs 0 CREATE TABLE posts_gdocs_variables_faqs(gdocId VARCHAR, variableId INTEGER, fragmentId VARCHAR, displayOrder SMALLINT);
table posts_gdocs_x_images posts_gdocs_x_images 0 CREATE TABLE posts_gdocs_x_images(id INTEGER, gdocId VARCHAR, imageId INTEGER);
table posts_gdocs_x_tags posts_gdocs_x_tags 0 CREATE TABLE posts_gdocs_x_tags(gdocId VARCHAR, tagId INTEGER);
table posts_links posts_links 0 CREATE TABLE posts_links(id INTEGER, sourceId INTEGER, target VARCHAR, linkType VARCHAR, componentType VARCHAR, "text" VARCHAR, queryString VARCHAR, hash VARCHAR);
table posts_unified posts_unified 0 CREATE TABLE posts_unified(id INTEGER DEFAULT(nextval('posts_unified_id')), slug VARCHAR, title VARCHAR, "type" VARCHAR, publishedAt VARCHAR, updatedAt VARCHAR, authors VARCHAR, createdAt VARCHAR, publicationContext VARCHAR, gdocId VARCHAR, wordpressId INTEGER, PRIMARY KEY(id));
table post_tags post_tags 0 CREATE TABLE post_tags(post_id INTEGER, tag_id INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table redirects redirects 0 CREATE TABLE redirects(id INTEGER, source VARCHAR, target VARCHAR, code INTEGER, createdAt TIMESTAMP WITH TIME ZONE, updatedAt TIMESTAMP WITH TIME ZONE, ttl TIMESTAMP WITH TIME ZONE);
table sources sources 0 CREATE TABLE sources(id INTEGER, "name" VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, datasetId INTEGER, additionalInfo VARCHAR, link VARCHAR, dataPublishedBy VARCHAR);
table tags tags 0 CREATE TABLE tags(id INTEGER, "name" VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, parentId INTEGER, specialType VARCHAR, slug VARCHAR);
table tags_variables_topic_tags tags_variables_topic_tags 0 CREATE TABLE tags_variables_topic_tags(tagId INTEGER, variableId INTEGER, displayOrder SMALLINT);
table tag_graph tag_graph 0 CREATE TABLE tag_graph(parentId INTEGER, childId INTEGER, weight INTEGER, updatedAt TIMESTAMP WITH TIME ZONE);
table topic_and_linear_pages topic_and_linear_pages 0 CREATE TABLE topic_and_linear_pages(source VARCHAR, "type" VARCHAR, slug VARCHAR);
table unused_old_datasets unused_old_datasets 0 CREATE TABLE unused_old_datasets("name" VARCHAR, url VARCHAR);
table users users 0 CREATE TABLE users(id INTEGER, "password" VARCHAR, lastLogin TIMESTAMP, isSuperuser BOOLEAN, email VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, isActive BOOLEAN, fullName VARCHAR, lastSeen TIMESTAMP, githubUsername VARCHAR, dataInsightFolderId VARCHAR);
table variables variables 0 CREATE TABLE variables(id INTEGER, "name" VARCHAR, unit VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, code VARCHAR, coverage VARCHAR, timespan VARCHAR, datasetId INTEGER, sourceId INTEGER, shortUnit VARCHAR, display VARCHAR, columnOrder INTEGER, originalMetadata VARCHAR, shortName VARCHAR, catalogPath VARCHAR, dimensions VARCHAR, schemaVersion INTEGER, processingLevel VARCHAR, processingLog VARCHAR, titlePublic VARCHAR, titleVariant VARCHAR, attributionShort VARCHAR, attribution VARCHAR, descriptionShort VARCHAR, descriptionFromProducer VARCHAR, descriptionKey VARCHAR, descriptionProcessing VARCHAR, licenses VARCHAR, license VARCHAR, "type" VARCHAR, sort VARCHAR, grapherConfigIdAdmin VARCHAR, grapherConfigIdETL VARCHAR, dataChecksum VARCHAR, metadataChecksum VARCHAR);