User:Doc James/OurWorld
From Wikipedia, the free encyclopedia
- Rich content was second most requested in a 2015 reader survey
- Based on {{Global Heat Maps by Year}}
- Data sets from OWID
- Obesity data
- Steps
- Download csv (put in google docs and trim to three columns)
- Upload it at https://www.csvjson.com/csv2json
- Select "parse numbers"
- Copy the output and paste it into Notepad
- Find and replace { with [, and "Country:" with nothing
- Paste this data below the heading data at [Data:Child Mortality.tab]
Improvements
Mediawiki Extensions Graph Phab Workboard
Color scales
- bug fix: the color scale should remain fixed for the whole set to allow easier comparison between years (phab ticket), or the color should show rank ("global position") instead of percentage
- bug fix: if increase is > 100%, black is currently shown
- default have colors go from for example blue to red for low to high rather than just a blue scale (phab ticket)
- @Doc James: This is set by the
["#01f1f0", "#08306b"]bit in Template:Global Heat Maps by Year. (Replacing it with, for example,["orange", "green"]would switch to orange-green scales.) Could be set to have different defaults and/or allow specific colors through a parameter (maybemin-color=/max-color=, or something). --Yair rand (talk) 21:36, 12 January 2020 (UTC)- User:Yair rand it would be cool if users could select the color range that they wish when using the template parameters :-) Is it possible to use "# redyellowblue" Doc James (talk · contribs · email) 10:56, 13 January 2020 (UTC)
- Much better, but the diff scale is much more clear than the absolute scale. Is quantization necessary? It reduces the number of discernable shades. Also, non-uniform distribution sometimes makes the data differences hard to see. Sometimes there may be a logarithmic distribution of the data. One approach would be to index the values, with colour 1 representing the lowest value in the full matrix, 2=the second lowest, up to <number of years>*<number of countries> for the highest value. That would also solve bug fix no 1 above - to make the color scale fixed for all years.Tomastvivlaren (talk) 16:46, 25 March 2020 (UTC)
- User:Yair rand it would be cool if users could select the color range that they wish when using the template parameters :-) Is it possible to use "# redyellowblue" Doc James (talk · contribs · email) 10:56, 13 January 2020 (UTC)
- @Doc James: This is set by the
Interactivity
- week-by-week or day-by-day statistics, for example of corona/covid-19 deaths per 1 million people in each country.
- clicking on a country (or marking a group of countries) should give a curve for that country
- the play button should be replaced with a refresh icon. People believe it is animated because of the play button.
- add a play features such that it will move through all the years like an animated gif, and/or add a separate year slider (phab ticket)
- when one hovers their cursor over a country with no data it should say so (phab ticket)
- allow the nearest year to be used when the year is missing, example of this is here https://ourworldindata.org/grapher/share-of-the-population-living-in-extreme-poverty
- allow the ability to zoom or to just show specific regions of the world (like Asia, Europe, North America, South America) similar to the tool here https://sdg-tracker.org/no-poverty (phab ticket)
- allow the ability to filter on various wikidata properties
Layout
- the legend / y axis should be graded, at least with a top number, or the nearest value of the curve should be shown with tooltips on mouse over
- increase the size of the world and make skinnier the year slider, make the legend wider and skinner (phab ticket)
- allow the interval of years to be set -> mostly fixed
Values
- allow values other than a percentage
- allow logarithmic y axis and color scaling
- allow multi-column dataset, that does not need trimming to three columns
- allow the number of decimal points shown to be stipulated in parameters
- Commons datasets
- Allow pageviews
- Allow them to be put in categories (phab ticket)
.svgs
COVID19
{{Global Heat Maps by Year}}
COVID19
Agricultural area per capita
{{Global Heat Maps by Year}}
Literacy rate by country[1]
Literacy rate
{{Global Heat Maps by Year}}
Literacy rate by country[2]
Abortion rates (per 1000 women)
Average-price-of-a-pack-of-cigarettes.tab
{{Global Heat Maps by Year}}
Average price of a pack of 20 cigarettes, measured in international dollars.[4]
Other options
Is to use WP:VideoWiki. Basically download each year as a .png and stitch them together. Will keep the easy updating as new years come out. A little harder to get them going though. And not as dynamic for our readers.
Cocoa-bean-production.tab
{{Global Heat Maps by Year}}
Cocoa bean production from 1961 to 2014.[6]
- User:Yurik this one appears to be having some trouble.
- Data file is here
- Afghanistan is overly dark yet there is no data for that country. Doc James (talk · contribs · email) 16:47, 17 November 2019 (UTC)
Fire Death Rate.tab
{{Global Heat Maps by Year}}
Rate of deaths due to fire between 1990 and 2017.[7]
Child mortality
{{Global Heat Maps by Year}}
Child mortality by year from 1960 until 2017.[8]
Cancer deaths
Not sure were the % sign is coming from?
{{Global Heat Maps by Year}}
Age-standardized death rate from cancer per 10,000 people.[9]
- The percent sign comes from the line in Template:Global Heat Maps by Year beginning with
{"template": "{{{columnName}}}:, at the end. You could replace the "%" with something like "{{{%|%}}}" to allow|%=to hide the symbol. --Yair rand (talk) 17:28, 6 October 2019 (UTC)- Nice User:Yair rand that fixed the problem :-) Doc James (talk · contribs · email) 23:33, 6 October 2019 (UTC)
Health spending
{{Global Heat Maps by Year}}
Total health spending as a % of GDP.[10]
HIV rates.tab
{{Global Heat Maps by Year}}
Percent of people with HIV/AIDS.[11]
CO2PerCapita.tab
{{Global Heat Maps by Year}}
CO2 emissions per capita.[12]
Banana production.tab
{{Global Heat Maps by Year}}
Annual banana production, measured in tonnes per year.[13]
Mobile cellular subscriptions per 100 people.tab
{{Global Heat Maps by Year}}
Mobile subscriptions per 100 people[14]
Share of population using the Internet.tab
{{Global Heat Maps by Year}}
Share of population using the Internet[15]
Landlines.tab
{{Global Heat Maps by Year}}
The number of fixed (landline) telephone subscriptions per 100 people.[16]
Homicide rate.tab
{{Global Heat Maps by Year}}
Number of homicide deaths per 100,000 people.[17]