owid

Data license: CC-BY

This data as json, CSV

type	name	tbl_name	sql
table	charts	charts	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	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	CREATE TABLE charts_per_dataset(id INTEGER, "name" VARCHAR, n_charts BIGINT);
table	charts_same_title_variant	charts_same_title_variant	CREATE TABLE charts_same_title_variant(title_plus_variant VARCHAR, chartA VARCHAR, chartB VARCHAR);
table	charts_without_origin_url	charts_without_origin_url	CREATE TABLE charts_without_origin_url(title VARCHAR, tags VARCHAR, URL VARCHAR, isPublished BOOLEAN);
table	charts_without_tag	charts_without_tag	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	CREATE TABLE charts_with_manual_year(id INTEGER, title VARCHAR, edit_url VARCHAR);
table	charts_x_entities	charts_x_entities	CREATE TABLE charts_x_entities(chartId INTEGER, entityId INTEGER);
table	charts_x_parents	charts_x_parents	CREATE TABLE charts_x_parents(variableId INTEGER, chartId INTEGER);
table	chart_configs	chart_configs	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	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	CREATE TABLE chart_slug_redirects(id INTEGER, slug VARCHAR, chart_id INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table	chart_tags	chart_tags	CREATE TABLE chart_tags(chartId INTEGER, tagId INTEGER, keyChartLevel UTINYINT, createdAt TIMESTAMP, updatedAt TIMESTAMP, isApproved BOOLEAN);
table	chart_variables	chart_variables	CREATE TABLE chart_variables(chartId INTEGER, variableId INTEGER, PRIMARY KEY(chartId, variableId));
table	datasets	datasets	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	CREATE TABLE dataset_tags(datasetId INTEGER, tagId INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table	entities	entities	CREATE TABLE entities(id INTEGER, code VARCHAR, "name" VARCHAR, validated BOOLEAN, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table	explorers	explorers	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	CREATE TABLE explorer_charts(id INTEGER, explorerSlug VARCHAR, chartId INTEGER);
table	explorer_tags	explorer_tags	CREATE TABLE explorer_tags(id INTEGER, explorerSlug VARCHAR, tagId INTEGER);
table	explorer_variables	explorer_variables	CREATE TABLE explorer_variables(id INTEGER, explorerSlug VARCHAR, variableId INTEGER);
table	images	images	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	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	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	CREATE TABLE namespaces(id INTEGER, "name" VARCHAR, description VARCHAR, isArchived BOOLEAN, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table	origins	origins	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	CREATE TABLE origins_variables(originId INTEGER, variableId INTEGER, displayOrder SMALLINT);
table	posts	posts	CREATE TABLE posts(id INTEGER, title VARCHAR, slug VARCHAR, "type" VARCHAR, status VARCHAR, "content" VARCHAR, archieml VARCHAR, archieml_update_statistics VARCHAR, published_at TIMESTAMP, updated_at TIMESTAMP, gdocSuccessorId VARCHAR, 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	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	CREATE TABLE posts_gdocs_components(id UBIGINT, gdocId VARCHAR, config VARCHAR, parent VARCHAR, path VARCHAR);
table	posts_gdocs_links	posts_gdocs_links	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	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	CREATE TABLE posts_gdocs_variables_faqs(gdocId VARCHAR, variableId INTEGER, fragmentId VARCHAR, displayOrder SMALLINT);
table	posts_gdocs_x_images	posts_gdocs_x_images	CREATE TABLE posts_gdocs_x_images(id INTEGER, gdocId VARCHAR, imageId INTEGER);
table	posts_gdocs_x_tags	posts_gdocs_x_tags	CREATE TABLE posts_gdocs_x_tags(gdocId VARCHAR, tagId INTEGER);
table	posts_links	posts_links	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	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	CREATE TABLE post_tags(post_id INTEGER, tag_id INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);
table	redirects	redirects	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	CREATE TABLE sources(id INTEGER, "name" VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, datasetId INTEGER, additionalInfo VARCHAR, link VARCHAR, dataPublishedBy VARCHAR);
table	tags	tags	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	CREATE TABLE tags_variables_topic_tags(tagId INTEGER, variableId INTEGER, displayOrder SMALLINT);
table	tag_graph	tag_graph	CREATE TABLE tag_graph(parentId INTEGER, childId INTEGER, weight INTEGER, updatedAt TIMESTAMP WITH TIME ZONE);
table	topic_and_linear_pages	topic_and_linear_pages	CREATE TABLE topic_and_linear_pages(source VARCHAR, "type" VARCHAR, slug VARCHAR);
table	unused_old_datasets	unused_old_datasets	CREATE TABLE unused_old_datasets("name" VARCHAR, url VARCHAR);
table	users	users	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	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);

owid

Custom SQL query returning 47 rows (hide)