Jump to content

User:Doc James/OurWorld

From Wikipedia, the free encyclopedia
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

[edit]

Mediawiki Extensions Graph Phab Workboard

Color scales

[edit]
    • 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

[edit]
    • 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

[edit]
    • 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

[edit]
    • 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

[edit]
  • Initial upload [4]

COVID19

[edit]
See or edit source data.
COVID19

Agricultural area per capita

[edit]
See or edit source data.
Literacy rate by country[1]

Literacy rate

[edit]
See or edit source data.
Literacy rate by country[2]

Abortion rates (per 1000 women)

[edit]
See or edit source data.
Abortion rates per 1000 women[3]
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

[edit]
See or edit source data.
Average price of a pack of 20 cigarettes, measured in international dollars.[4]

Other options

[edit]
Average price of cigarettes in USD in 2012 and 2014[5]

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

[edit]
See or edit source data.
Cocoa bean production from 1961 to 2014.[6]
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

[edit]
See or edit source data.
Rate of deaths due to fire between 1990 and 2017.[7]

Child mortality

[edit]
See or edit source data.
Child mortality by year from 1960 until 2017.[8]

Cancer deaths

[edit]

Not sure were the % sign is coming from?

See or edit source data.
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

[edit]
See or edit source data.
Total health spending as a % of GDP.[10]

HIV rates.tab

[edit]
See or edit source data.
Percent of people with HIV/AIDS.[11]

CO2PerCapita.tab

[edit]
See or edit source data.
CO2 emissions per capita.[12]

Banana production.tab

[edit]
See or edit source data.
Annual banana production, measured in tonnes per year.[13]

Mobile cellular subscriptions per 100 people.tab

[edit]
See or edit source data.
Mobile subscriptions per 100 people[14]

Share of population using the Internet.tab

[edit]
See or edit source data.
Share of population using the Internet[15]

Landlines.tab

[edit]
See or edit source data.
The number of fixed (landline) telephone subscriptions per 100 people.[16]

Homicide rate.tab

[edit]
See or edit source data.
Number of homicide deaths per 100,000 people.[17]

References

[edit]
  1. ^ "Agricultural area per capita". Our World in Data. Retrieved 10 February 2020.
  2. ^ "Literacy rate by country". Our World in Data. Retrieved 10 February 2020.
  3. ^ "Abortion rates (per 1,000 women aged 15-44 years)". Our World in Data. Retrieved 10 February 2020.
  4. ^ Ritchie, Hannah; Roser, Max (23 May 2013). "Smoking". Our World in Data. Retrieved 22 November 2019.
  5. ^ Ritchie, Hannah; Roser, Max (23 May 2013). "Smoking". Our World in Data. Retrieved 27 January 2020.
  6. ^ "Cocoa bean production". Our World in Data. Retrieved 17 November 2019.
  7. ^ "Fire death rates". Our World in Data. Retrieved 17 November 2019.
  8. ^ Roser, Max; Ritchie, Hannah (10 May 2013). "Child & Infant Mortality". Our World in Data. Retrieved 4 October 2019.
  9. ^ "Cancer death rates". Our World in Data. Retrieved 4 October 2019.
  10. ^ Ortiz-Ospina, Esteban; Roser, Max (22 August 2016). "Global Health". Our World in Data. Retrieved 4 October 2019.
  11. ^ Roser, Max; Ritchie, Hannah (3 April 2018). "HIV / AIDS". Our World in Data. Retrieved 4 October 2019.
  12. ^ "Where in the world do people emit the most CO2?". Our World in Data. Retrieved 7 October 2019.
  13. ^ "Banana production". Our World in Data. Retrieved 7 October 2019.
  14. ^ Ritchie, Hannah; Roser, Max (2 October 2017). "Technology Adoption". Our World in Data. Retrieved 12 October 2019.
  15. ^ Ritchie, Hannah; Roser, Max (2 October 2017). "Technology Adoption". Our World in Data. Retrieved 12 October 2019.
  16. ^ Ritchie, Hannah; Roser, Max (2 October 2017). "Technology Adoption". Our World in Data. Retrieved 12 October 2019.
  17. ^ Roser, Max (6 July 2013). "Homicides". Our World in Data. Retrieved 12 October 2019.