charts
Data license: CC-BY
2 rows where publishedByUserId = 25 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date), lastEditedAt (date), publishedAt (date)
| id ▲ | slug | type | config | createdAt | updatedAt | lastEditedAt | publishedAt | lastEditedByUserId | publishedByUserId | isIndexable | title | subtitle | note | title_plus_variant | configWithDefaults |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3227 | new-neonatal-tetanus-cases-per-million | LineChart | {
"id": 3227,
"map": {
"time": "latest",
"colorScale": {
"baseColorScheme": "Oranges",
"binningStrategy": "manual",
"customNumericColors": [
"#fbfbde",
null,
null,
null,
null,
null
],
"customNumericLabels": [
"No cases",
null,
null,
null,
null,
null,
null
],
"customNumericValues": [
0,
3,
10,
30,
100,
300,
1000
],
"customNumericColorsActive": true
},
"columnSlug": "98918",
"tooltipUseCustomLabels": true
},
"tab": "map",
"slug": "new-neonatal-tetanus-cases-per-million",
"title": "Annual new cases of neonatal tetanus per million people",
"yAxis": {
"max": 0,
"min": 0
},
"$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
"version": 23,
"hasMapTab": true,
"originUrl": "https://ourworldindata.org/tetanus",
"dimensions": [
{
"property": "y",
"variableId": 828578
}
],
"sourceDesc": "World Health Organization - Global Health Observatory (2024)",
"isPublished": true,
"selectedEntityNames": [
"Albania",
"Syria",
"Ukraine"
]
} |
2018-12-04 15:24:55 | 2024-04-08 12:13:54 | 2024-03-11 10:00:48 | 2018-12-04 15:44:15 | Fiona Spooner 54 | Hannah Behrens 25 | 1 | Annual new cases of neonatal tetanus per million people | Annual new cases of neonatal tetanus per million people () | {
"$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
"map": {
"projection": "World",
"hideTimeline": false,
"colorScale": {
"baseColorScheme": "default",
"equalSizeBins": true,
"binningStrategy": "ckmeans",
"customNumericColorsActive": false,
"colorSchemeInvert": false,
"binningStrategyBinCount": 5
},
"timeTolerance": 0,
"toleranceStrategy": "closest",
"tooltipUseCustomLabels": false,
"time": "latest"
},
"maxTime": "latest",
"baseColorScheme": "default",
"yAxis": {
"removePointsOutsideDomain": false,
"scaleType": "linear",
"canChangeScaleType": false,
"facetDomain": "shared"
},
"tab": "map",
"matchingEntitiesOnly": false,
"hasChartTab": true,
"hideLegend": false,
"hideLogo": false,
"hideTimeline": false,
"colorScale": {
"baseColorScheme": "default",
"equalSizeBins": true,
"binningStrategy": "ckmeans",
"customNumericColorsActive": false,
"colorSchemeInvert": false,
"binningStrategyBinCount": 5
},
"scatterPointLabelStrategy": "year",
"selectedFacetStrategy": "none",
"isPublished": true,
"invertColorScheme": false,
"version": 23,
"logo": "owid",
"entityType": "country or region",
"facettingLabelByYVariables": "metric",
"addCountryMode": "add-country",
"compareEndPointsOnly": false,
"type": "LineChart",
"hasMapTab": true,
"stackMode": "absolute",
"minTime": "earliest",
"hideAnnotationFieldsInTitle": {
"entity": false,
"time": false,
"changeInPrefix": false
},
"xAxis": {
"removePointsOutsideDomain": false,
"scaleType": "linear",
"canChangeScaleType": false,
"facetDomain": "shared"
},
"hideConnectedScatterLines": false,
"showNoDataArea": true,
"zoomToSelection": false,
"showYearLabels": false,
"hideLinesOutsideTolerance": false,
"hideTotalValueLabel": false,
"hideScatterLabels": false,
"sortBy": "total",
"sortOrder": "desc",
"hideFacetControl": true,
"entityTypePlural": "countries",
"missingDataStrategy": "auto",
"id": 3227,
"slug": "new-neonatal-tetanus-cases-per-million",
"title": "Annual new cases of neonatal tetanus per million people",
"originUrl": "https://ourworldindata.org/tetanus",
"dimensions": [
{
"property": "y",
"variableId": 828578
}
],
"sourceDesc": "World Health Organization - Global Health Observatory (2024)",
"selectedEntityNames": [
"Albania",
"Syria",
"Ukraine"
]
} |
||
| 3224 | who-vs-gbd-incidence-of-tetanus | LineChart | {
"id": 3224,
"map": {
"colorScale": {
"binningStrategy": "equalInterval",
"customNumericMinValue": 0
}
},
"slug": "who-vs-gbd-incidence-of-tetanus",
"title": "WHO vs. IHME incidence of tetanus",
"yAxis": {
"max": 0,
"min": 0,
"canChangeScaleType": true
},
"$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
"version": 29,
"subtitle": "Comparison of the incidence of tetanus as published by the World Health Organization (WHO) and Institute for Health Metrics and Evaluation, Global Burden of Disease (GBD). The WHO reports the number of confirmed cases, while the IHME corrects for unreported cases in their estimates.",
"originUrl": "https://ourworldindata.org/tetanus",
"dimensions": [
{
"display": {
"name": "Confirmed tetanus cases (WHO)",
"unit": "confirmed cases",
"includeInTable": true
},
"property": "y",
"variableId": 830638
},
{
"display": {
"name": "Incidence of tetanus (GBD)",
"unit": "cases",
"includeInTable": true
},
"property": "y",
"variableId": 912171
}
],
"isPublished": true,
"addCountryMode": "change-country",
"selectedEntityNames": [
"World"
],
"hideAnnotationFieldsInTitle": {
"time": true,
"entity": true,
"changeInPrefix": true
}
} |
2018-12-03 18:27:52 | 2024-06-05 09:53:08 | 2024-06-05 09:53:08 | 2018-12-03 18:31:05 | Fiona Spooner 54 | Hannah Behrens 25 | 1 | WHO vs. IHME incidence of tetanus | Comparison of the incidence of tetanus as published by the World Health Organization (WHO) and Institute for Health Metrics and Evaluation, Global Burden of Disease (GBD). The WHO reports the number of confirmed cases, while the IHME corrects for unreported cases in their estimates. | WHO vs. IHME incidence of tetanus () | {
"$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json",
"map": {
"projection": "World",
"hideTimeline": false,
"colorScale": {
"baseColorScheme": "default",
"equalSizeBins": true,
"binningStrategy": "ckmeans",
"customNumericColorsActive": false,
"colorSchemeInvert": false,
"binningStrategyBinCount": 5
},
"timeTolerance": 0,
"toleranceStrategy": "closest",
"tooltipUseCustomLabels": false,
"time": "latest"
},
"maxTime": "latest",
"baseColorScheme": "default",
"yAxis": {
"removePointsOutsideDomain": false,
"scaleType": "linear",
"canChangeScaleType": false,
"facetDomain": "shared"
},
"tab": "chart",
"matchingEntitiesOnly": false,
"hasChartTab": true,
"hideLegend": false,
"hideLogo": false,
"hideTimeline": false,
"colorScale": {
"baseColorScheme": "default",
"equalSizeBins": true,
"binningStrategy": "ckmeans",
"customNumericColorsActive": false,
"colorSchemeInvert": false,
"binningStrategyBinCount": 5
},
"scatterPointLabelStrategy": "year",
"selectedFacetStrategy": "none",
"isPublished": true,
"invertColorScheme": false,
"version": 29,
"logo": "owid",
"entityType": "country or region",
"facettingLabelByYVariables": "metric",
"addCountryMode": "change-country",
"compareEndPointsOnly": false,
"type": "LineChart",
"hasMapTab": false,
"stackMode": "absolute",
"minTime": "earliest",
"hideAnnotationFieldsInTitle": {
"entity": false,
"time": false,
"changeInPrefix": false
},
"xAxis": {
"removePointsOutsideDomain": false,
"scaleType": "linear",
"canChangeScaleType": false,
"facetDomain": "shared"
},
"hideConnectedScatterLines": false,
"showNoDataArea": true,
"zoomToSelection": false,
"showYearLabels": false,
"hideLinesOutsideTolerance": false,
"hideTotalValueLabel": false,
"hideScatterLabels": false,
"sortBy": "total",
"sortOrder": "desc",
"hideFacetControl": true,
"entityTypePlural": "countries",
"missingDataStrategy": "auto",
"id": 3224,
"slug": "who-vs-gbd-incidence-of-tetanus",
"title": "WHO vs. IHME incidence of tetanus",
"subtitle": "Comparison of the incidence of tetanus as published by the World Health Organization (WHO) and Institute for Health Metrics and Evaluation, Global Burden of Disease (GBD). The WHO reports the number of confirmed cases, while the IHME corrects for unreported cases in their estimates.",
"originUrl": "https://ourworldindata.org/tetanus",
"dimensions": [
{
"display": {
"name": "Confirmed tetanus cases (WHO)",
"unit": "confirmed cases",
"includeInTable": true
},
"property": "y",
"variableId": 830638
},
{
"display": {
"name": "Incidence of tetanus (GBD)",
"unit": "cases",
"includeInTable": true
},
"property": "y",
"variableId": 912171
}
],
"selectedEntityNames": [
"World"
]
} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "charts" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"slug" VARCHAR(255) NULL ,
"type" VARCHAR(255) NULL ,
"config" TEXT NOT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"lastEditedAt" DATETIME NOT NULL ,
"publishedAt" DATETIME NULL ,
"lastEditedByUserId" INTEGER NOT NULL ,
"publishedByUserId" INTEGER NULL ,
"isIndexable" TINYINT NOT NULL DEFAULT '0', title TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.title')) VIRTUAL, subtitle TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.subtitle')) VIRTUAL, note TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.note')) VIRTUAL, title_plus_variant GENERATED ALWAYS as (printf("%s (%s)", title, json_extract(config, "$.variantName"))) VIRTUAL, configWithDefaults json,
FOREIGN KEY("lastEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("publishedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "charts_lastEditedByUserId" ON "charts" ("lastEditedByUserId");
CREATE INDEX "charts_publishedByUserId" ON "charts" ("publishedByUserId");
CREATE INDEX "charts_slug" ON "charts" ("slug");
CREATE INDEX idx_title_plus_variant ON charts(title_plus_variant);