charts
Data license: CC-BY
1 row where publishedByUserId = 29 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1664 | measles-cases-and-death-rate | LineChart | { "id": 1664, "map": { "colorScale": { "binningStrategy": "equalInterval", "customNumericMinValue": 0 } }, "slug": "measles-cases-and-death-rate", "title": "Rate of cases and deaths from measles in the United States", "yAxis": { "max": 0, "min": 0, "scaleType": "log", "canChangeScaleType": true }, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json", "version": 13, "subtitle": "The reported annual rate of new cases and deaths from measles, per 100,000 people in the population.", "originUrl": "https://ourworldindata.org/vaccination", "dimensions": [ { "display": { "name": "Reported measles case rate", "unit": "per 100,000", "color": "#3c4e66", "shortUnit": "", "includeInTable": true }, "property": "y", "variableId": 65376 }, { "display": { "name": "Reported measles death rate", "unit": "per 100,000", "color": "#b13507", "shortUnit": "", "includeInTable": true }, "property": "y", "variableId": 65378 } ], "sourceDesc": "CDC and other sources (2017)", "isPublished": true, "addCountryMode": "change-country", "invertColorScheme": true, "selectedEntityNames": [ "United States" ], "selectedEntityColors": { "United States": "#b13507" }, "hideAnnotationFieldsInTitle": { "time": true, "entity": true, "changeInPrefix": true } } |
2017-11-29 20:06:50 | 2024-04-08 12:13:54 | 2024-02-08 13:35:54 | 2019-10-28 10:33:38 | Saloni Dattani 50 | Daniel Gavrilov 29 | 1 | Rate of cases and deaths from measles in the United States | The reported annual rate of new cases and deaths from measles, per 100,000 people in the population. | Rate of cases and deaths from measles in the United States () | { "$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": true, "version": 13, "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": 1664, "slug": "measles-cases-and-death-rate", "title": "Rate of cases and deaths from measles in the United States", "subtitle": "The reported annual rate of new cases and deaths from measles, per 100,000 people in the population.", "originUrl": "https://ourworldindata.org/vaccination", "dimensions": [ { "display": { "name": "Reported measles case rate", "unit": "per 100,000", "color": "#3c4e66", "shortUnit": "", "includeInTable": true }, "property": "y", "variableId": 65376 }, { "display": { "name": "Reported measles death rate", "unit": "per 100,000", "color": "#b13507", "shortUnit": "", "includeInTable": true }, "property": "y", "variableId": 65378 } ], "sourceDesc": "CDC and other sources (2017)", "selectedEntityNames": [ "United States" ], "selectedEntityColors": { "United States": "#b13507" } } |
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);