owid

Data license: CC-BY

Tables

chart_dimensions

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

12,350 rows

chart_slug_redirects

id, slug, chart_id, createdAt, updatedAt

1,710 rows

chart_tags

chartId, tagId, keyChartLevel, createdAt, updatedAt, isApproved

7,162 rows

charts

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

5,012 rows

dataset_tags

datasetId, tagId, createdAt, updatedAt

941 rows

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

Many rows

entities

id, code, name, validated, createdAt, updatedAt

22,179 rows

explorer_charts

id, explorerSlug, chartId

1,101 rows

explorer_tags

id, explorerSlug, tagId

45 rows

explorer_variables

id, explorerSlug, variableId

2,995 rows

explorers

slug, isPublished, config, createdAt, updatedAt

105 rows

images

id, googleId, filename, defaultAlt, originalWidth, updatedAt, originalHeight

1,886 rows

namespaces

id, name, description, isArchived, createdAt, updatedAt

168 rows

origins

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

1,119 rows

origins_variables

originId, variableId, displayOrder

139,770 rows

post_broken_chart_links

id, postId, chartSlug, kind

93 rows

post_charts

id, postId, chartId, kind, through_redirect

3,490 rows

post_links

id, postId, link, kind

16,716 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

848 rows

posts_gdocs

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

653 rows

posts_gdocs_links

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

13,563 rows

posts_gdocs_variables_faqs

gdocId, variableId, fragmentId, displayOrder

112 rows

posts_gdocs_x_images

id, gdocId, imageId

1,577 rows

posts_gdocs_x_tags

gdocId, tagId

749 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

695 rows

redirects

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

636 rows

sources

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

22,744 rows

sqlite_sequence

name, seq

21 rows

tags_variables_topic_tags

tagId, variableId, displayOrder

129,393 rows

users

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

70 rows

variables

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

449,525 rows