User:Doc James/OurWorld

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
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)
    • bug fix: if increase is > 100%, black is currently shown
    • default have colors go from 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 :-) Is it possible to use "# redyellowblue"[2] Doc James (talk · contribs · email) 10:56, 13 January 2020 (UTC)
    • allow other color scale, number of colors and mapping thresholds as input parameter.

Interactivity[edit]

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 [3]

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[4]
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.