WHOのCOVID-19データ(2)からの続き
WHOのjsonデータの冒頭部分を取り出してみた。国別に,UNIX-timeの行と地域名の行の次に10項目の数値データが並んだ配列が格納されていた。10項目の内訳は,死亡数/日,死亡数累計,1週間の死亡数,1週間の死亡数の変化分,100万人あたりの死亡数,確定感染数/日,確定感染数累計,1週間の確定感染数,1週間の確定感染数の変化分,100万人あたりの確定感染数,となっていて,これを取り出していたのだった。
{
"componentChunkName":"component---src-templates-table-tsx",
"path":"/table",
"result":
{"pageContext":
{"countryGroups":[
{
"dimension":{"name":"Country","type":"STRING","dataType":"STRING"},
"value":"US",
“data":
{"metrics":
[
{"name":"Deaths",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Cumulative Deaths",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Deaths Last 7 Days",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Deaths Last 7 Days Change",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Deaths Per Million",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Confirmed",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Cumulative Confirmed",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Cases Last 7 Days",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Cases Last 7 Days Change",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
,
{"name":"Cases Per Million",
"type":"NUMBER",
"dataType":"NUMERIC",
"aggregateFunction":"SUM"}
],
"dimensions":
[
{“name":"day", "type":"TIMESTAMP", “dataType":"STRING"},
{“name":"Region", “type":"STRING", "dataType":"STRING"}
],
"rows":
[
[1578009600000,”AMRO",0,0,0,0,0,0,0,0,0,0],
…
[1608595200000,"AMRO",1570,315318,18478,9.16,952.61,197199,17712290,1671195,13.64,53511.02]
],
"totals":[315318,42488183,2153709,15832.590000000002,128361.91999999997,17712290,1494857008,118829648,32537.839999999975,4516148.239999997]
}
},
{"dimension":
…