charts
Data license: CC-BY
4 rows where lastEditedByUserId = 79 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: type, publishedByUserId, isIndexable, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7930 | annual-reported-passenger-kilometers | StackedArea | { "id": 7930, "map": { "time": 2008 }, "slug": "annual-reported-passenger-kilometers", "type": "StackedArea", "title": "Reported passenger kilometers", "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json", "maxTime": 2021, "version": 19, "subtitle": "A passenger kilometer represents the transport of one passenger by rail or road over a distance of one kilometer. Crew or service personnel are excluded.", "originUrl": "https://ourworldindata.org/transport", "dimensions": [ { "display": { "name": "Rail", "unit": "passenger-kilometers", "includeInTable": true }, "property": "y", "variableId": 946968 }, { "display": { "name": "Road", "includeInTable": true }, "property": "y", "variableId": 946967 } ], "sourceDesc": "OECD (2024)", "isPublished": true, "addCountryMode": "change-country", "baseColorScheme": "owid-distinct", "missingDataStrategy": "hide", "selectedEntityNames": [ "Germany" ], "hideAnnotationFieldsInTitle": { "time": true } } |
2024-07-05 10:47:29 | 2024-07-05 11:53:56 | 2024-07-05 11:53:56 | 2024-07-05 10:47:29 | Tuna Acisu 79 | ETL 74 | 0 | Reported passenger kilometers | A passenger kilometer represents the transport of one passenger by rail or road over a distance of one kilometer. Crew or service personnel are excluded. | Reported passenger kilometers () | { "$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": 2021, "baseColorScheme": "owid-distinct", "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": 19, "logo": "owid", "entityType": "country or region", "facettingLabelByYVariables": "metric", "addCountryMode": "change-country", "compareEndPointsOnly": false, "type": "StackedArea", "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": "hide", "id": 7930, "slug": "annual-reported-passenger-kilometers", "title": "Reported passenger kilometers", "subtitle": "A passenger kilometer represents the transport of one passenger by rail or road over a distance of one kilometer. Crew or service personnel are excluded.", "originUrl": "https://ourworldindata.org/transport", "dimensions": [ { "display": { "name": "Rail", "unit": "passenger-kilometers", "includeInTable": true }, "property": "y", "variableId": 946968 }, { "display": { "name": "Road", "includeInTable": true }, "property": "y", "variableId": 946967 } ], "sourceDesc": "OECD (2024)", "selectedEntityNames": [ "Germany" ] } |
|
7929 | road-accident-deaths-per-passenger-kilometers | LineChart | { "id": 7929, "map": { "time": 2022, "colorScale": { "baseColorScheme": "Reds", "binningStrategy": "manual", "customNumericValues": [ 3, 10, 30, 100, 20 ], "binningStrategyBinCount": 8 }, "timeTolerance": 5 }, "slug": "road-accident-deaths-per-passenger-kilometers", "title": "Road accident deaths per billion passenger kilometers", "yAxis": { "min": 0 }, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json", "maxTime": 2022, "version": 12, "subtitle": "Number of deaths due to road accidents per billion passenger kilometers traveled on the road.", "hasMapTab": true, "originUrl": "https://ourworldindata.org/causes-of-death", "dimensions": [ { "display": { "shortUnit": "", "includeInTable": true, "numDecimalPlaces": 1 }, "property": "y", "variableId": 946973 } ], "sourceDesc": "OECD (2024)", "isPublished": true, "selectedEntityNames": [ "United Kingdom", "United States", "Germany", "India", "Poland", "Turkey", "Russia", "Argentina" ], "hideAnnotationFieldsInTitle": { "time": true } } |
2024-07-05 10:47:28 | 2024-07-05 11:53:38 | 2024-07-05 11:53:38 | 2024-07-05 10:47:28 | Tuna Acisu 79 | ETL 74 | 0 | Road accident deaths per billion passenger kilometers | Number of deaths due to road accidents per billion passenger kilometers traveled on the road. | Road accident deaths per billion passenger kilometers () | { "$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": 2022, "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": 12, "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": 7929, "slug": "road-accident-deaths-per-passenger-kilometers", "title": "Road accident deaths per billion passenger kilometers", "subtitle": "Number of deaths due to road accidents per billion passenger kilometers traveled on the road.", "originUrl": "https://ourworldindata.org/causes-of-death", "dimensions": [ { "display": { "shortUnit": "", "includeInTable": true, "numDecimalPlaces": 1 }, "property": "y", "variableId": 946973 } ], "sourceDesc": "OECD (2024)", "selectedEntityNames": [ "United Kingdom", "United States", "Germany", "India", "Poland", "Turkey", "Russia", "Argentina" ] } |
|
2251 | sales-of-cigarettes-per-adult-per-day | LineChart | { "id": 2251, "map": { "time": 2015, "colorScale": { "baseColorScheme": "OrRd", "binningStrategy": "manual", "customNumericValues": [ 2, 4, 6, 8, 10, 12 ], "customNumericMinValue": 0 }, "columnSlug": "85765", "timeTolerance": 5 }, "slug": "sales-of-cigarettes-per-adult-per-day", "title": "Sales of cigarettes per adult per day", "yAxis": { "max": 0, "min": 0 }, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json", "version": 39, "subtitle": "Daily sales of [manufactured cigarettes](#dod:manufactured-cigarettes) to people aged 15 and over.", "hasMapTab": true, "originUrl": "https://ourworldindata.org/smoking", "dimensions": [ { "property": "y", "variableId": 931756 } ], "isPublished": true, "baseColorScheme": "owid-distinct", "invertColorScheme": true, "selectedEntityNames": [ "Japan", "Germany", "United States", "France", "Switzerland", "Spain", "Croatia", "Austria" ] } |
2018-02-21 18:48:36 | 2024-07-22 08:10:21 | 2024-06-12 13:35:05 | 2018-02-21 18:48:48 | Tuna Acisu 79 | Diana Beltekian 19 | 1 | Sales of cigarettes per adult per day | Daily sales of [manufactured cigarettes](#dod:manufactured-cigarettes) to people aged 15 and over. | Sales of cigarettes per adult per day () | { "$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": "owid-distinct", "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": 39, "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": 2251, "slug": "sales-of-cigarettes-per-adult-per-day", "title": "Sales of cigarettes per adult per day", "subtitle": "Daily sales of [manufactured cigarettes](#dod:manufactured-cigarettes) to people aged 15 and over.", "originUrl": "https://ourworldindata.org/smoking", "dimensions": [ { "property": "y", "variableId": 931756 } ], "selectedEntityNames": [ "Japan", "Germany", "United States", "France", "Switzerland", "Spain", "Croatia", "Austria" ] } |
|
2064 | number-of-reported-guinea-worm-dracunculiasis-cases | LineChart | { "id": 2064, "map": { "colorScale": { "baseColorScheme": "Reds", "binningStrategy": "manual", "customNumericColors": [ "#fbfbde", null, null, null, null ], "customNumericLabels": [ "No reported cases", null, null, null, "", null, null ], "customNumericValues": [ 0, 10, 100, 1000, 10000, 100000, 1000000 ], "customCategoryLabels": { "No data": "No data" }, "customNumericColorsActive": true }, "columnSlug": "67406" }, "note": "Due to limited surveillance capacity, particularly during past outbreaks, the number of reported cases can be lower than the actual number of infections.", "slug": "number-of-reported-guinea-worm-dracunculiasis-cases", "title": "Reported cases of guinea worm disease", "yAxis": { "max": 1000000, "min": 0, "scaleType": "log", "canChangeScaleType": true }, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.004.json", "version": 33, "subtitle": "Reported annual cases of [guinea worm disease](#dod:guinea-worm). Guinea worm disease is a painful and debilitating disease caused by a parasitic worm spread through contaminated water.", "hasMapTab": true, "originUrl": "https://ourworldindata.org/eradication-of-diseases", "dimensions": [ { "property": "y", "variableId": 943086 } ], "isPublished": true, "relatedQuestions": [ { "url": "https://ourworldindata.org/guinea-worm-path-eradication", "text": "How did cases of guinea worm disease decline?" } ], "selectedEntityNames": [ "World" ] } |
2018-02-09 09:39:10 | 2024-07-16 09:20:29 | 2024-07-16 09:20:29 | 2018-02-09 09:46:25 | Tuna Acisu 79 | Sophie Ochmann 18 | 1 | Reported cases of guinea worm disease | Reported annual cases of [guinea worm disease](#dod:guinea-worm). Guinea worm disease is a painful and debilitating disease caused by a parasitic worm spread through contaminated water. | Due to limited surveillance capacity, particularly during past outbreaks, the number of reported cases can be lower than the actual number of infections. | Reported cases of guinea worm disease () | { "$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": 33, "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": 2064, "note": "Due to limited surveillance capacity, particularly during past outbreaks, the number of reported cases can be lower than the actual number of infections.", "slug": "number-of-reported-guinea-worm-dracunculiasis-cases", "title": "Reported cases of guinea worm disease", "subtitle": "Reported annual cases of [guinea worm disease](#dod:guinea-worm). Guinea worm disease is a painful and debilitating disease caused by a parasitic worm spread through contaminated water.", "originUrl": "https://ourworldindata.org/eradication-of-diseases", "dimensions": [ { "property": "y", "variableId": 943086 } ], "relatedQuestions": [ { "url": "https://ourworldindata.org/guinea-worm-path-eradication", "text": "How did cases of guinea worm disease decline?" } ], "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);