Web で閲覧できる次の表を作成します。
データのソースは福島県のサイトにある csv です。
csv の取得
URL="http://www.pref.fukushima.lg.jp/w4/covid19/patients"
#
wget $URL"/070009_fukushima_covid19_patients_200420.csv"
JSON への変換
iconv -f sjis -t UTF-8 070009_fukushima_covid19_patients_200420.csv > fukushima_200420.csv
#
./fukushima_corona.py fukushima_200420.csv data_fukushima.json
fukushima_corona.py
#! /usr/bin/python
# -*- coding: utf-8 -*-
#
# fukushima_corona.py
#
# Apr/19/2020
#
import sys
import string
import json
import csv
#
# ------------------------------------------------------------------
def parse_proc(dict_aa,row):
ix = int(row[0])
key = "s%03d" % ix
unit_aa = {}
unit_aa['date'] = row[4]
unit_aa['age'] = row[7]
unit_aa['sex'] = row[8]
unit_aa['place'] = row[6]
# unit_aa['status'] = row[5]
dict_aa[key] = unit_aa
#
return dict_aa
# ------------------------------------------------------------------
sys.stderr.write ("*** 開始 ***\n")
file_csv = sys.argv[1]
file_json = sys.argv[2]
sys.stderr.write(file_csv + "\n")
sys.stderr.write(file_json + "\n")
#
fp = open(file_csv, 'r')
reader = csv.reader(fp)
dict_aa = {}
for row in reader:
if row[0] != "No":
dict_aa = parse_proc(dict_aa,row)
#
fp.close()
#
dict_bb = {}
for key in sorted(dict_aa.keys(), reverse=True):
dict_bb[key] = dict_aa[key]
#
json_str = json.dumps(dict_bb)
#
fp_out = open(file_json,mode='w',encoding='utf-8')
fp_out.write(json_str)
fp_out.close()
#
sys.stderr.write ("*** 終了 ***\n")
# ------------------------------------------------------------------
ホームページ
fukushima_patient.html
<!DOCTYPE html>
<html lang="ja">
<head>
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Cache-Control" content="no-cache" />
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8" />
<script src="/js/jquery-3.4.1.min.js"></script>
<script src="fukushima_patient.js"></script>
<link rel="stylesheet" href="fukushima_patient.css">
<title>福島県の新型コロナウイルス感染症患者の発生状況</title>
</head>
<body>
<blockquote>
<h2>福島県の新型コロナウイルス感染症患者の発生状況</h2><p />
<blockquote>
(4月19日 時点)<p />
</blockquote>
</blockquote>
<blockquote>
<div class="contents"></div>
</blockquote>
</blockquote>
<hr />
データソース
<blockquote>
<a href="http://www.pref.fukushima.lg.jp/w4/covid19/patients/" target="_blank">/covid19/patients</a><p />
</blockquote>
<a href="../">Return</a><p />
Apr/19/2020 AM 07:00<p />
</body>
</html>
fukushima_patient.css
/* -------------------------------------------------------------- */
/*
fukushima_patient.css
Apr/20/2020
*/
/* -------------------------------------------------------------- */
table.main,td,th {
table-layout:fixed;
border:1.5px #7e7e7e solid;
border-collapse: collapse;
height: 16px;
}
th {
background: #c6c6c6;
}
table.tag {
border:0.5px green solid;
}
tr.cyan {
background-color: #c7d7c7;
}
.red {color:#ff0000;}
/* -------------------------------------------------------------- */
fukushima_patient.js
// -----------------------------------------------------------------------
// fukushima_patient.js
//
// Apr/19/2020
//
// -----------------------------------------------------------------------
jQuery (function ()
{
jQuery("#outarea_aa").text ("*** fukushima_patient *** start ***")
const file_in = "./data_fukushima.json"
jQuery.getJSON (file_in,function (data_aa)
{
var str_out = ""
str_out += "<table>"
str_out += "<tr>"
str_out += "<th>No</th>"
str_out += "<th>判明日</th>"
str_out += "<th>年代</th>"
str_out += "<th>性別</th>"
str_out += "<th>居住地</th>"
str_out += "<th>退院済</th>"
str_out += "</tr>"
for (var key in data_aa)
{
const unit_aa = data_aa[key]
str_out += "<tr>"
str_out += "<td>" + key + "</td>"
str_out += "<td>" + unit_aa.date + "</td>"
str_out += "<td>" + unit_aa.age + "</td>"
str_out += "<td>" + unit_aa.sex + "</td>"
str_out += "<td>" + unit_aa.place + "</td>"
// str_out += "<td>" + unit_aa.status + "</td>"
str_out += "<td>---</td>"
str_out += "</tr>"
}
str_out += "</table>"
jQuery(".contents").html (str_out)
})
jQuery("#outarea_hh").text ("*** fukushima_patient *** end ***")
})
// -----------------------------------------------------------------------