Convert data from covid19 stats for Thailand into a tab separated list that can be imported into a spreasheet

convert-to-table.rb

require "excon"
require "json"

data = JSON.parse(Excon.get("https://covid19.th-stat.com/api/open/timeline").body)

timeline = data["Data"].reverse.take(60).map do |day|
  [
    day["Date"],
    day["NewConfirmed"],
    day["NewRecovered"],
    day["NewHospitalized"],
    day["Confirmed"],
    day["Recovered"],
    day["Hospitalized"],
    day["Deaths"],
  ].join("\t")
end

puts ["Date", "NewConfirmed", "NewRecovered", "NewHospitalized", "Confirmed", "Recovered", "Hospitalized", "Deaths"].join("\t")
puts timeline.reverse.join("\n")

Use with

ruby convert-to-table.rb | pbcopy

Note: remove | pbcopy if not on a mac. And make sure to have excon installed.