User:Doc James/OurWorld

• Rich content was second most requested in a 2015 reader survey[1]
• Based on {{Global Heat Maps by Year}}
• Data sets from OWID
• Obesity data[2]

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 (maybe min-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"[3] 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)

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

• Initial upload [4]

COVID19

See or edit source data.

COVID19

Agricultural area per capita

See or edit source data.

Literacy rate by country

Literacy rate

See or edit source data.

Literacy rate by country

Abortion rates (per 1000 women)

See or edit source data.

Abortion rates per 1000 women

Would be nice if the tool can handle regions. Doc James (talk · contribs · email) 18:08, 10 February 2020 (UTC)

Average-price-of-a-pack-of-cigarettes.tab

See or edit source data.

Average price of a pack of 20 cigarettes, measured in international dollars.

Other options

Average price of cigarettes in USD in 2012 and 2014

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

See or edit source data.

Cocoa bean production from 1961 to 2014.

User:Yurik this one appears to be having some trouble.

Data file is here[5]

Afghanistan is overly dark yet there is no data for that country. Doc James (talk · contribs · email) 16:47, 17 November 2019 (UTC)

Have now filled in zero for all the years and it fixes it a bit. Doc James (talk · contribs · email) 18:22, 17 November 2019 (UTC)

When one looks at the difference between two points in time for a country were no data is avaliable it gives a value but shouldn't Doc James (talk · contribs · email) 18:24, 17 November 2019 (UTC)

Fire Death Rate.tab

See or edit source data.

Rate of deaths due to fire between 1990 and 2017.

Child mortality

See or edit source data.

Child mortality by year from 1960 until 2017.

Cancer deaths

Not sure were the % sign is coming from?

See or edit source data.

Age-standardized death rate from cancer per 10,000 people.

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

See or edit source data.

Total health spending as a % of GDP.

HIV rates.tab

See or edit source data.

Percent of people with HIV/AIDS.

CO2PerCapita.tab

See or edit source data.

CO₂ emissions per capita.

Banana production.tab

See or edit source data.

Annual banana production, measured in tonnes per year.

Mobile cellular subscriptions per 100 people.tab

See or edit source data.

Mobile subscriptions per 100 people

Share of population using the Internet.tab

See or edit source data.

Share of population using the Internet

Landlines.tab

See or edit source data.

The number of fixed (landline) telephone subscriptions per 100 people.

Homicide rate.tab

See or edit source data.

Number of homicide deaths per 100,000 people.