johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Hokkaido" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435953 | 3435953 | 2020-07-11 | Japan | Hokkaido | 1290 | 101 | 1120 | 69 | 43.385711 | 142.55231799999999 | 2020-07-12 04:34:30 | Hokkaido, Japan | ||
3237451 | 3237451 | 2020-07-10 | Japan | Hokkaido | 1289 | 101 | 1120 | 68 | 43.385711 | 142.55231799999999 | 2020-07-11 04:34:26 | Hokkaido, Japan | ||
1005436 | 1005436 | 2020-07-09 | Japan | Hokkaido | 1283 | 101 | 1106 | 76 | 43.385711 | 142.55231799999999 | 2020-07-10 04:34:24 | Hokkaido, Japan | ||
2222652 | 2222652 | 2020-07-08 | Japan | Hokkaido | 1282 | 101 | 1093 | 88 | 43.385711 | 142.55231799999999 | 2020-07-09 04:34:23 | Hokkaido, Japan | ||
887261 | 887261 | 2020-07-07 | Japan | Hokkaido | 1278 | 101 | 1093 | 84 | 43.385711 | 142.55231799999999 | 2020-07-08 05:33:48 | Hokkaido, Japan | ||
2684821 | 2684821 | 2020-07-06 | Japan | Hokkaido | 1277 | 101 | 1088 | 88 | 43.385711 | 142.55231799999999 | 2020-07-07 04:34:00 | Hokkaido, Japan | ||
415286 | 415286 | 2020-07-05 | Japan | Hokkaido | 1277 | 101 | 1077 | 99 | 43.385711 | 142.55231799999999 | 2020-07-06 04:33:57 | Hokkaido, Japan | ||
529848 | 529848 | 2020-07-04 | Japan | Hokkaido | 1276 | 101 | 1077 | 98 | 43.385711 | 142.55231799999999 | 2020-07-05 04:33:46 | Hokkaido, Japan | ||
2234509 | 2234509 | 2020-07-03 | Japan | Hokkaido | 1275 | 101 | 1072 | 102 | 43.385711 | 142.55231799999999 | 2020-07-04 04:33:51 | Hokkaido, Japan | ||
3045303 | 3045303 | 2020-07-02 | Japan | Hokkaido | 1275 | 101 | 1061 | 113 | 43.385711 | 142.552318 | 2020-07-03 04:33:54 | Hokkaido, Japan | ||
302994 | 302994 | 2020-07-01 | Japan | Hokkaido | 1267 | 100 | 1054 | 113 | 43.385711 | 142.55231799999999 | 2020-07-02 04:33:46 | Hokkaido, Japan | ||
2974372 | 2974372 | 2020-06-30 | Japan | Hokkaido | 1263 | 99 | 1054 | 110 | 43.385711 | 142.55231799999999 | 2020-07-01 04:33:52 | Hokkaido, Japan | ||
2632849 | 2632849 | 2020-06-29 | Japan | Hokkaido | 1250 | 99 | 1048 | 103 | 43.385711 | 142.552318 | 2020-06-30 04:33:48 | Hokkaido, Japan | ||
2306412 | 2306412 | 2020-06-28 | Japan | Hokkaido | 1239 | 99 | 1044 | 96 | 43.385711 | 142.55231799999999 | 2020-06-29 04:33:44 | Hokkaido, Japan | ||
2039747 | 2039747 | 2020-06-27 | Japan | Hokkaido | 1222 | 99 | 1028 | 95 | 43.385711 | 142.55231799999999 | 2020-06-28 04:34:04 | Hokkaido, Japan | ||
1136028 | 1136028 | 2020-06-26 | Japan | Hokkaido | 1221 | 98 | 1028 | 95 | 43.385711 | 142.55231799999999 | 2020-06-27 04:33:35 | Hokkaido, Japan | ||
2625015 | 2625015 | 2020-06-25 | Japan | Hokkaido | 1216 | 98 | 1011 | 107 | 43.385711 | 142.55231799999999 | 2020-06-26 04:33:43 | Hokkaido, Japan | ||
2700655 | 2700655 | 2020-06-24 | Japan | Hokkaido | 1210 | 98 | 1011 | 101 | 43.385711 | 142.55231799999999 | 2020-06-25 05:26:54 | Hokkaido, Japan | ||
1522340 | 1522340 | 2020-06-23 | Japan | Hokkaido | 1200 | 97 | 1011 | 92 | 43.385711 | 142.55231799999999 | 2020-06-24 04:33:28 | Hokkaido, Japan | ||
1510534 | 1510534 | 2020-06-22 | Japan | Hokkaido | 1199 | 95 | 1006 | 98 | 43.385711 | 142.55231799999999 | 2020-06-23 04:33:22 | Hokkaido, Japan | ||
3249273 | 3249273 | 2020-06-21 | Japan | Hokkaido | 1197 | 95 | 1001 | 101 | 43.385711 | 142.55231799999999 | 2020-06-22 04:33:20 | Hokkaido, Japan | ||
2437866 | 2437866 | 2020-06-20 | Japan | Hokkaido | 1195 | 94 | 1001 | 100 | 43.385711 | 142.55231799999999 | 2020-06-21 04:33:19 | Hokkaido, Japan | ||
1691444 | 1691444 | 2020-06-19 | Japan | Hokkaido | 1192 | 94 | 977 | 121 | 43.385711 | 142.55231799999999 | 2020-06-20 04:33:19 | Hokkaido, Japan | ||
3682593 | 3682593 | 2020-06-18 | Japan | Hokkaido | 1189 | 93 | 970 | 126 | 43.385711 | 142.55231799999999 | 2020-06-19 04:33:17 | Hokkaido, Japan | ||
1195796 | 1195796 | 2020-06-17 | Japan | Hokkaido | 1184 | 92 | 970 | 122 | 43.385711 | 142.55231799999999 | 2020-06-18 04:33:18 | Hokkaido, Japan | ||
2386559 | 2386559 | 2020-06-16 | Japan | Hokkaido | 1178 | 92 | 959 | 127 | 43.385711 | 142.55231799999999 | 2020-06-17 04:33:21 | Hokkaido, Japan | ||
287122 | 287122 | 2020-06-15 | Japan | Hokkaido | 1176 | 91 | 956 | 129 | 43.385711 | 142.55231799999999 | 2020-06-16 04:33:09 | Hokkaido, Japan | ||
1837073 | 1837073 | 2020-06-14 | Japan | Hokkaido | 1170 | 91 | 950 | 129 | 43.385711 | 142.55231799999999 | 2020-06-15 03:33:14 | Hokkaido, Japan | ||
3061125 | 3061125 | 2020-06-13 | Japan | Hokkaido | 1163 | 91 | 943 | 129 | 43.385711 | 142.55231799999999 | 2020-06-14 03:33:15 | Hokkaido, Japan | ||
737445 | 737445 | 2020-06-12 | Japan | Hokkaido | 1154 | 91 | 921 | 142 | 43.385711 | 142.55231799999999 | 2020-06-13 03:33:14 | Hokkaido, Japan | ||
1273415 | 1273415 | 2020-06-11 | Japan | Hokkaido | 1144 | 91 | 906 | 147 | 43.385711 | 142.55231799999999 | 2020-06-12 05:09:52 | Hokkaido, Japan | ||
2863858 | 2863858 | 2020-06-10 | Japan | Hokkaido | 1137 | 91 | 906 | 140 | 43.385711 | 142.552318 | 2020-06-11 03:33:41 | Hokkaido, Japan | ||
1210702 | 1210702 | 2020-06-09 | Japan | Hokkaido | 1132 | 91 | 888 | 153 | 43.385711 | 142.552318 | 2020-06-10 04:07:00 | Hokkaido, Japan | ||
217129 | 217129 | 2020-06-08 | Japan | Hokkaido | 1125 | 91 | 881 | 153 | 43.385711 | 142.552318 | 2020-06-09 03:33:03 | Hokkaido, Japan | ||
2799925 | 2799925 | 2020-06-07 | Japan | Hokkaido | 1121 | 90 | 869 | 162 | 43.385711 | 142.552318 | 2020-06-08 03:33:22 | Hokkaido, Japan | ||
573981 | 573981 | 2020-06-06 | Japan | Hokkaido | 1117 | 90 | 849 | 178 | 43.385711 | 142.552318 | 2020-06-07 03:53:30 | Hokkaido, Japan | ||
1269678 | 1269678 | 2020-06-05 | Japan | Hokkaido | 1109 | 90 | 849 | 170 | 43.385711 | 142.552318 | 2020-06-06 02:33:00 | Hokkaido, Japan | ||
1281154 | 1281154 | 2020-06-04 | Japan | Hokkaido | 1105 | 90 | 831 | 184 | 43.385711 | 142.55231799999999 | 2020-06-05 02:33:06 | Hokkaido, Japan | ||
3866709 | 3866709 | 2020-06-03 | Japan | Hokkaido | 1102 | 88 | 821 | 193 | 43.385711 | 142.55231799999999 | 2020-06-04 02:33:14 | Hokkaido, Japan | ||
2555751 | 2555751 | 2020-06-02 | Japan | Hokkaido | 1099 | 87 | 812 | 200 | 43.385711 | 142.55231799999999 | 2020-06-03 02:33:13 | Hokkaido, Japan | ||
805288 | 805288 | 2020-06-01 | Japan | Hokkaido | 1096 | 87 | 810 | 199 | 43.385711 | 142.55231799999999 | 2020-06-02 02:33:08 | Hokkaido, Japan | ||
1793912 | 1793912 | 2020-05-31 | Japan | Hokkaido | 1091 | 86 | 799 | 206 | 43.385711 | 142.55231799999999 | 2020-06-01 02:32:46 | Hokkaido, Japan | ||
3638805 | 3638805 | 2020-05-30 | Japan | Hokkaido | 1085 | 86 | 783 | 216 | 43.385711 | 142.55231799999999 | 2020-05-31 02:32:45 | Hokkaido, Japan | ||
1790346 | 1790346 | 2020-05-29 | Japan | Hokkaido | 1081 | 86 | 770 | 225 | 43.385711 | 142.55231799999999 | 2020-05-30 02:32:48 | Hokkaido, Japan | ||
2712225 | 2712225 | 2020-05-28 | Japan | Hokkaido | 1078 | 86 | 763 | 229 | 43.385711 | 142.55231799999999 | 2020-05-29 02:32:50 | Hokkaido, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);