owid

Data license: CC-BY

The following databases are attached to this connection, and can be used for cross-database joins:

public - tables

Tables

chart_configs

id, patch, full, slug, chartType, createdAt, updatedAt, fullMd5

119,060 rows

chart_dimensions

id, order, property, chartId, variableId, createdAt, updatedAt

13,541 rows

chart_slug_redirects

id, slug, chart_id, createdAt, updatedAt

1,845 rows

chart_tags

chartId, tagId, keyChartLevel, createdAt, updatedAt, isApproved

7,203 rows

id, configId, isInheritanceEnabled, createdAt, updatedAt, lastEditedAt, publishedAt, lastEditedByUserId, publishedByUserId, isIndexable, config, slug, type, title, subtitle, note, title_plus_variant, isPublished

5,265 rows

charts_broken_origin_url

chartId, chartSlug, chartEditLink, originUrlAsAuthored, originUrlPostSlug, originUrlPostLink, isPublished

143 rows

charts_per_dataset

id, name, n_charts

1,014 rows

charts_same_title_variant

title_plus_variant, chartA, chartB

1 row

charts_with_manual_year

id, title, edit_url

52 rows

charts_without_origin_url

title, tags, URL, isPublished

259 rows

charts_without_tag

id, title, edit_url, chart_edit_url

19 rows

charts_x_entities

chartId, entityId

646,137 rows

charts_x_parents

variableId, chartId

2,911 rows

dataset_tags

datasetId, tagId, createdAt, updatedAt

960 rows

datasets

id, name, description, createdAt, updatedAt, namespace, isPrivate, createdByUserId, metadataEditedAt, metadataEditedByUserId, dataEditedAt, dataEditedByUserId, nonRedistributable, isArchived, sourceChecksum, shortName, version, updatePeriodDays, catalogPath, tables

4,238 rows

entities

id, code, name, validated, createdAt, updatedAt

23,202 rows

explorer_charts

id, explorerSlug, chartId

907 rows

explorer_tags

id, explorerSlug, tagId

48 rows

explorer_variables

id, explorerSlug, variableId

2,681 rows

explorers

slug, config, createdAt, updatedAt, lastEditedByUserId, lastEditedAt, commitMessage, tsv, isPublished

92 rows

images

id, googleId, filename, defaultAlt, originalWidth, updatedAt, originalHeight, cloudflareId, hash, userId, replacedBy, version

3,222 rows

multi_dim_data_pages

id, catalogPath, slug, config, configMd5, published, createdAt, updatedAt

23 rows

multi_dim_x_chart_configs

id, multiDimId, viewId, variableId, chartConfigId, createdAt, updatedAt

6,817 rows

namespaces

id, name, description, isArchived, createdAt, updatedAt

185 rows

origins

id, titleSnapshot, title, descriptionSnapshot, description, producer, citationFull, attribution, attributionShort, versionProducer, urlMain, urlDownload, dateAccessed, datePublished, license

3,366 rows

origins_variables

originId, variableId, displayOrder

215,525 rows

post_tags

post_id, tag_id, createdAt, updatedAt

678 rows

posts

id, title, slug, type, status, content, archieml, archieml_update_statistics, published_at, updated_at, gdocSuccessorId, authors, excerpt, created_at_in_wordpress, updated_at_in_wordpress, featured_image, formattingOptions, markdown, wpApiSnapshot

820 rows

posts_gdocs

id, slug, type, content, authors, published, createdAt, publishedAt, updatedAt, publicationContext, revisionId, manualBreadcrumbs, markdown, title

888 rows

posts_gdocs_components

id, gdocId, config, parent, path

41,757 rows

posts_gdocs_links

id, sourceId, target, linkType, componentType, text, queryString, hash

15,649 rows

posts_gdocs_tombstones

id, gdocId, slug, reason, includeArchiveLink, relatedLinkUrl, relatedLinkTitle, relatedLinkDescription, relatedLinkThumbnail, createdAt, updatedAt

7 rows

posts_gdocs_variables_faqs

gdocId, variableId, fragmentId, displayOrder

1,448 rows

posts_gdocs_x_images

id, gdocId, imageId

2,034 rows

posts_gdocs_x_tags

gdocId, tagId

1,057 rows

posts_links

id, sourceId, target, linkType, componentType, text, queryString, hash

20,415 rows

posts_unified

id, slug, title, type, publishedAt, updatedAt, authors, createdAt, publicationContext, gdocId, wordpressId

895 rows

redirects

id, source, target, code, createdAt, updatedAt, ttl

685 rows

sources

id, name, description, createdAt, updatedAt, datasetId, additionalInfo, link, dataPublishedBy

22,731 rows

tag_graph

parentId, childId, weight, updatedAt

259 rows

tags_variables_topic_tags

tagId, variableId, displayOrder

210,084 rows

topic_and_linear_pages

source, type, slug

114 rows

unused_old_datasets

name, url

1 row

users

id, password, lastLogin, isSuperuser, email, createdAt, updatedAt, isActive, fullName, lastSeen, githubUsername, dataInsightFolderId

72 rows

variables

id, name, unit, description, createdAt, updatedAt, code, coverage, timespan, datasetId, sourceId, shortUnit, display, columnOrder, originalMetadata, shortName, catalogPath, dimensions, schemaVersion, processingLevel, processingLog, titlePublic, titleVariant, attributionShort, attribution, descriptionShort, descriptionFromProducer, descriptionKey, descriptionProcessing, licenses, license, type, sort, grapherConfigIdAdmin, grapherConfigIdETL, dataChecksum, metadataChecksum

511,382 rows

owid

Custom SQL query

Tables