johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Hunan" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126 | 126 | 2021-12-02 | China | Hunan | 1199 | 4 | 0 | 27.6104 | 111.7088 | 2021-12-03 04:23:05 | Hunan, China | |||
4142 | 4142 | 2021-10-28 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-29 04:22:03 | Hunan, China | |||
16167 | 16167 | 2021-09-18 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-19 04:21:34 | Hunan, China | |||
24197 | 24197 | 2022-03-20 | China | Hunan | 1281 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-21 04:20:50 | Hunan, China | |||
28212 | 28212 | 2021-11-11 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-12 04:22:01 | Hunan, China | |||
32228 | 32228 | 2021-08-25 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-26 04:21:28 | Hunan, China | |||
43504 | 43504 | 2021-11-02 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-03 06:22:09 | Hunan, China | |||
62858 | 62858 | 2022-11-12 | China | Hunan | 1838 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-13 04:21:14 | Hunan, China | |||
66873 | 66873 | 2021-09-01 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-02 04:21:15 | Hunan, China | |||
70887 | 70887 | 2022-02-07 | China | Hunan | 1231 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-08 04:21:15 | Hunan, China | |||
86921 | 86921 | 2021-11-09 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-10 04:21:38 | Hunan, China | |||
90938 | 90938 | 2022-07-23 | China | Hunan | 1409 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-24 04:20:47 | Hunan, China | |||
99122 | 99122 | 2022-01-14 | China | Hunan | 1229 | 4 | 0 | 27.6104 | 111.7088 | 2022-01-15 04:21:07 | Hunan, China | |||
103138 | 103138 | 2021-08-15 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-16 04:21:31 | Hunan, China | |||
114548 | 114548 | 2022-09-06 | China | Hunan | 1441 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-07 04:20:59 | Hunan, China | |||
126529 | 126529 | 2022-01-09 | China | Hunan | 1229 | 4 | 0 | 27.6104 | 111.7088 | 2022-01-10 04:22:07 | Hunan, China | |||
130546 | 130546 | 2022-10-04 | China | Hunan | 1476 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-05 04:23:06 | Hunan, China | |||
137767 | 137767 | 2021-12-04 | China | Hunan | 1199 | 4 | 0 | 27.6104 | 111.7088 | 2021-12-05 04:22:25 | Hunan, China | |||
141784 | 141784 | 2022-07-09 | China | Hunan | 1402 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-10 04:20:54 | Hunan, China | |||
149780 | 149780 | 2021-11-29 | China | Hunan | 1199 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-30 04:22:53 | Hunan, China | |||
157809 | 157809 | 2022-03-29 | China | Hunan | 1322 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-30 04:20:45 | Hunan, China | |||
161824 | 161824 | 2021-11-19 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-20 04:22:17 | Hunan, China | |||
165841 | 165841 | 2022-06-21 | China | Hunan | 1400 | 4 | 0 | 27.6104 | 111.7088 | 2022-06-22 04:20:54 | Hunan, China | |||
177838 | 177838 | 2021-09-02 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-03 04:21:20 | Hunan, China | |||
185867 | 185867 | 2022-02-13 | China | Hunan | 1231 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-14 04:20:51 | Hunan, China | |||
198055 | 198055 | 2022-10-19 | China | Hunan | 1556 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-20 04:22:59 | Hunan, China | |||
217776 | 217776 | 2022-12-26 | China | Hunan | 2983 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-27 04:21:07 | Hunan, China | |||
221792 | 221792 | 2022-05-09 | China | Hunan | 1392 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-10 04:20:50 | Hunan, China | |||
229023 | 229023 | 2022-05-31 | China | Hunan | 1393 | 4 | 0 | 27.6104 | 111.7088 | 2022-06-01 04:20:55 | Hunan, China | |||
233039 | 233039 | 2022-02-11 | China | Hunan | 1231 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-12 04:21:06 | Hunan, China | |||
245081 | 245081 | 2021-08-17 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-18 04:21:35 | Hunan, China | |||
249095 | 249095 | 2021-09-04 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-05 04:21:33 | Hunan, China | |||
253110 | 253110 | 2022-09-08 | China | Hunan | 1441 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-09 04:21:11 | Hunan, China | |||
257126 | 257126 | 2022-12-10 | China | Hunan | 2425 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-11 04:20:50 | Hunan, China | |||
261329 | 261329 | 2022-03-15 | China | Hunan | 1238 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-16 04:20:50 | Hunan, China | |||
275979 | 275979 | 2021-11-03 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-04 04:22:20 | Hunan, China | |||
287792 | 287792 | 2021-10-31 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-01 04:22:01 | Hunan, China | |||
291809 | 291809 | 2022-11-15 | China | Hunan | 1856 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-16 04:21:09 | Hunan, China | |||
303665 | 303665 | 2022-04-16 | China | Hunan | 1339 | 4 | 0 | 27.6104 | 111.7088 | 2022-04-17 04:20:59 | Hunan, China | |||
307681 | 307681 | 2022-12-13 | China | Hunan | 2442 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-14 04:21:04 | Hunan, China | |||
311697 | 311697 | 2022-11-13 | China | Hunan | 1843 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-14 04:21:09 | Hunan, China | |||
315713 | 315713 | 2022-02-12 | China | Hunan | 1231 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-13 04:21:00 | Hunan, China | |||
319729 | 319729 | 2022-10-30 | China | Hunan | 1670 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-31 04:21:36 | Hunan, China | |||
327703 | 327703 | 2022-12-27 | China | Hunan | 2983 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-28 04:21:04 | Hunan, China | |||
335733 | 335733 | 2022-03-18 | China | Hunan | 1247 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-19 04:20:47 | Hunan, China | |||
339647 | 339647 | 2020-03-21 | China | Hunan | 1018 | 4 | 1014 | 27.6104 | 111.7088 | 2020-03-14T08:33:03 | ||||
348093 | 348093 | 2022-12-14 | China | Hunan | 2442 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-15 04:20:58 | Hunan, China | |||
356123 | 356123 | 2022-03-11 | China | Hunan | 1236 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-12 04:20:50 | Hunan, China | |||
360139 | 360139 | 2022-05-07 | China | Hunan | 1391 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-08 04:20:49 | Hunan, China | |||
371993 | 371993 | 2022-09-13 | China | Hunan | 1443 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-14 04:20:44 | Hunan, China | |||
384020 | 384020 | 2022-09-23 | China | Hunan | 1456 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-24 04:21:40 | Hunan, China | |||
396061 | 396061 | 2022-10-07 | China | Hunan | 1490 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-08 04:22:56 | Hunan, China | |||
404090 | 404090 | 2021-12-07 | China | Hunan | 1199 | 4 | 0 | 27.6104 | 111.7088 | 2021-12-08 04:22:46 | Hunan, China | |||
419132 | 419132 | 2022-09-18 | China | Hunan | 1450 | 4 | 0 | 27.6104 | 111.7088 | 2022-09-19 04:21:49 | Hunan, China | |||
423147 | 423147 | 2021-10-10 | China | Hunan | 1191 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-11 04:21:31 | Hunan, China | |||
431154 | 431154 | 2022-11-03 | China | Hunan | 1712 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-04 04:22:11 | Hunan, China | |||
443151 | 443151 | 2021-10-20 | China | Hunan | 1194 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-21 04:21:18 | Hunan, China | |||
447167 | 447167 | 2021-11-17 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-18 04:21:33 | Hunan, China | |||
451184 | 451184 | 2022-12-21 | China | Hunan | 2983 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-22 04:20:56 | Hunan, China | |||
459176 | 459176 | 2022-02-02 | China | Hunan | 1230 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-03 04:21:21 | Hunan, China | |||
463193 | 463193 | 2022-05-02 | China | Hunan | 1385 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-03 04:21:00 | Hunan, China | |||
467208 | 467208 | 2021-10-07 | China | Hunan | 1189 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-08 04:21:25 | Hunan, China | |||
475239 | 475239 | 2022-06-26 | China | Hunan | 1401 | 4 | 0 | 27.6104 | 111.7088 | 2022-06-27 04:21:00 | Hunan, China | |||
479387 | 479387 | 2022-11-08 | China | Hunan | 1803 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-09 04:21:22 | Hunan, China | |||
487417 | 487417 | 2022-11-25 | China | Hunan | 1961 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-26 04:21:11 | Hunan, China | |||
491432 | 491432 | 2021-10-14 | China | Hunan | 1191 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-15 04:21:26 | Hunan, China | |||
495448 | 495448 | 2021-11-06 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-07 04:21:53 | Hunan, China | |||
499465 | 499465 | 2022-04-02 | China | Hunan | 1331 | 4 | 0 | 27.6104 | 111.7088 | 2022-04-03 04:20:48 | Hunan, China | |||
503481 | 503481 | 2022-12-17 | China | Hunan | 2462 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-18 04:21:03 | Hunan, China | |||
507496 | 507496 | 2021-08-14 | China | Hunan | 1180 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-15 04:21:41 | Hunan, China | |||
511510 | 511510 | 2021-08-19 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-20 04:21:33 | Hunan, China | |||
515525 | 515525 | 2022-10-15 | China | Hunan | 1522 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-16 04:22:39 | Hunan, China | |||
534532 | 534532 | 2021-10-27 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-28 04:22:08 | Hunan, China | |||
538549 | 538549 | 2022-10-26 | China | Hunan | 1621 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-27 04:22:01 | Hunan, China | |||
542565 | 542565 | 2022-12-15 | China | Hunan | 2442 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-16 04:21:01 | Hunan, China | |||
550570 | 550570 | 2021-12-08 | China | Hunan | 1199 | 4 | 0 | 27.6104 | 111.7088 | 2021-12-09 04:22:49 | Hunan, China | |||
554586 | 554586 | 2022-01-16 | China | Hunan | 1229 | 4 | 0 | 27.6104 | 111.7088 | 2022-01-17 04:21:08 | Hunan, China | |||
558603 | 558603 | 2022-06-16 | China | Hunan | 1398 | 4 | 0 | 27.6104 | 111.7088 | 2022-06-17 04:20:56 | Hunan, China | |||
566900 | 566900 | 2021-10-29 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-30 04:22:03 | Hunan, China | |||
574629 | 574629 | 2022-02-25 | China | Hunan | 1233 | 4 | 0 | 27.6104 | 111.7088 | 2022-02-26 04:21:12 | Hunan, China | |||
589440 | 589440 | 2021-08-08 | China | Hunan | 1156 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-09 04:21:24 | Hunan, China | |||
593455 | 593455 | 2022-07-01 | China | Hunan | 1401 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-02 04:21:16 | Hunan, China | |||
597470 | 597470 | 2021-10-19 | China | Hunan | 1194 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-20 04:21:00 | Hunan, China | |||
601486 | 601486 | 2021-09-23 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-24 04:21:44 | Hunan, China | |||
617659 | 617659 | 2022-11-05 | China | Hunan | 1769 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-06 04:21:24 | Hunan, China | |||
621675 | 621675 | 2022-05-22 | China | Hunan | 1393 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-26 04:20:50 | Hunan, China | |||
629705 | 629705 | 2022-07-12 | China | Hunan | 1405 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-13 04:20:58 | Hunan, China | |||
633720 | 633720 | 2021-10-13 | China | Hunan | 1191 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-14 04:21:29 | Hunan, China | |||
641750 | 641750 | 2021-09-07 | China | Hunan | 1181 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-08 04:21:31 | Hunan, China | |||
649778 | 649778 | 2021-08-09 | China | Hunan | 1162 | 4 | 0 | 27.6104 | 111.7088 | 2021-08-10 04:21:27 | Hunan, China | |||
653792 | 653792 | 2021-10-22 | China | Hunan | 1194 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-23 04:21:32 | Hunan, China | |||
658111 | 658111 | 2022-05-13 | China | Hunan | 1393 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-14 04:20:48 | Hunan, China | |||
670096 | 670096 | 2022-07-21 | China | Hunan | 1409 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-22 04:21:15 | Hunan, China | |||
674112 | 674112 | 2022-07-30 | China | Hunan | 1410 | 4 | 0 | 27.6104 | 111.7088 | 2022-07-31 04:21:02 | Hunan, China | |||
682137 | 682137 | 2021-10-24 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-10-25 04:22:31 | Hunan, China | |||
686153 | 686153 | 2021-11-13 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-14 04:21:31 | Hunan, China | |||
690170 | 690170 | 2022-12-23 | China | Hunan | 2983 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-24 04:21:02 | Hunan, China | |||
694186 | 694186 | 2022-03-17 | China | Hunan | 1241 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-18 04:20:55 | Hunan, China | |||
698201 | 698201 | 2021-11-04 | China | Hunan | 1197 | 4 | 0 | 27.6104 | 111.7088 | 2021-11-05 04:21:54 | Hunan, China | |||
706231 | 706231 | 2021-09-29 | China | Hunan | 1182 | 4 | 0 | 27.6104 | 111.7088 | 2021-09-30 04:21:20 | Hunan, China |
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]);