johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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 day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Hunan · 1,024 ✖

country_or_region 1

  • China · 1,024 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752700 2752700 2022-12-29 China Hunan     2983 4 0   27.6104 111.7088 2022-12-30 04:21:04 Hunan, China
1073706 1073706 2022-12-28 China Hunan     2983 4 0   27.6104 111.7088 2022-12-29 04:21:01 Hunan, China
327703 327703 2022-12-27 China Hunan     2983 4 0   27.6104 111.7088 2022-12-28 04:21:04 Hunan, China
217776 217776 2022-12-26 China Hunan     2983 4 0   27.6104 111.7088 2022-12-27 04:21:07 Hunan, China
3222233 3222233 2022-12-25 China Hunan     2983 4 0   27.6104 111.7088 2022-12-26 04:21:06 Hunan, China
1018147 1018147 2022-12-24 China Hunan     2983 4 0   27.6104 111.7088 2022-12-25 04:21:04 Hunan, China
690170 690170 2022-12-23 China Hunan     2983 4 0   27.6104 111.7088 2022-12-24 04:21:02 Hunan, China
2179380 2179380 2022-12-22 China Hunan     2983 4 0   27.6104 111.7088 2022-12-23 04:21:04 Hunan, China
451184 451184 2022-12-21 China Hunan     2983 4 0   27.6104 111.7088 2022-12-22 04:20:56 Hunan, China
2951183 2951183 2022-12-20 China Hunan     2749 4 0   27.6104 111.7088 2022-12-21 04:21:03 Hunan, China
3173585 3173585 2022-12-19 China Hunan     2749 4 0   27.6104 111.7088 2022-12-20 04:21:04 Hunan, China
1628102 1628102 2022-12-18 China Hunan     2541 4 0   27.6104 111.7088 2022-12-19 04:21:03 Hunan, China
503481 503481 2022-12-17 China Hunan     2462 4 0   27.6104 111.7088 2022-12-18 04:21:03 Hunan, China
3324053 3324053 2022-12-16 China Hunan     2442 4 0   27.6104 111.7088 2022-12-17 04:21:04 Hunan, China
542565 542565 2022-12-15 China Hunan     2442 4 0   27.6104 111.7088 2022-12-16 04:21:01 Hunan, China
348093 348093 2022-12-14 China Hunan     2442 4 0   27.6104 111.7088 2022-12-15 04:20:58 Hunan, China
307681 307681 2022-12-13 China Hunan     2442 4 0   27.6104 111.7088 2022-12-14 04:21:04 Hunan, China
1148742 1148742 2022-12-12 China Hunan     2441 4 0   27.6104 111.7088 2022-12-13 04:21:01 Hunan, China
868596 868596 2022-12-11 China Hunan     2432 4 0   27.6104 111.7088 2022-12-12 04:21:01 Hunan, China
257126 257126 2022-12-10 China Hunan     2425 4 0   27.6104 111.7088 2022-12-11 04:20:50 Hunan, China
3935840 3935840 2022-12-09 China Hunan     2412 4 0   27.6104 111.7088 2022-12-10 04:21:02 Hunan, China
3377172 3377172 2022-12-08 China Hunan     2397 4 0   27.6104 111.7088 2022-12-09 04:21:05 Hunan, China
1984443 1984443 2022-12-07 China Hunan     2390 4 0   27.6104 111.7088 2022-12-08 04:21:07 Hunan, China
3713966 3713966 2022-12-06 China Hunan     2376 4 0   27.6104 111.7088 2022-12-07 04:20:58 Hunan, China
2414671 2414671 2022-12-05 China Hunan     2365 4 0   27.6104 111.7088 2022-12-06 04:21:03 Hunan, China
718279 718279 2022-12-04 China Hunan     2282 4 0   27.6104 111.7088 2022-12-05 04:20:58 Hunan, China
2816568 2816568 2022-12-03 China Hunan     2216 4 0   27.6104 111.7088 2022-12-04 04:20:56 Hunan, China
833424 833424 2022-12-02 China Hunan     2185 4 0   27.6104 111.7088 2022-12-03 04:21:02 Hunan, China
2135954 2135954 2022-12-01 China Hunan     2155 4 0   27.6104 111.7088 2022-12-02 04:21:07 Hunan, China
1964370 1964370 2022-11-30 China Hunan     2129 4 0   27.6104 111.7088 2022-12-01 04:21:03 Hunan, China
2556384 2556384 2022-11-29 China Hunan     2129 4 0   27.6104 111.7088 2022-11-30 04:21:07 Hunan, China
1239458 1239458 2022-11-28 China Hunan     2040 4 0   27.6104 111.7088 2022-11-29 04:21:05 Hunan, China
3551446 3551446 2022-11-27 China Hunan     2017 4 0   27.6104 111.7088 2022-11-28 04:21:02 Hunan, China
2099926 2099926 2022-11-26 China Hunan     1991 4 0   27.6104 111.7088 2022-11-27 04:21:05 Hunan, China
487417 487417 2022-11-25 China Hunan     1961 4 0   27.6104 111.7088 2022-11-26 04:21:11 Hunan, China
3523246 3523246 2022-11-24 China Hunan     1932 4 0   27.6104 111.7088 2022-11-25 04:21:06 Hunan, China
3312029 3312029 2022-11-23 China Hunan     1909 4 0   27.6104 111.7088 2022-11-24 04:21:09 Hunan, China
1620070 1620070 2022-11-22 China Hunan     1896 4 0   27.6104 111.7088 2022-11-23 04:21:06 Hunan, China
3459958 3459958 2022-11-21 China Hunan     1883 4 0   27.6104 111.7088 2022-11-22 04:20:47 Hunan, China
1640143 1640143 2022-11-20 China Hunan     1879 4 0   27.6104 111.7088 2022-11-21 04:21:05 Hunan, China
2063700 2063700 2022-11-19 China Hunan     1869 4 0   27.6104 111.7088 2022-11-20 04:21:08 Hunan, China
1755094 1755094 2022-11-18 China Hunan     1861 4 0   27.6104 111.7088 2022-11-19 04:21:14 Hunan, China
3026087 3026087 2022-11-17 China Hunan     1858 4 0   27.6104 111.7088 2022-11-18 04:21:15 Hunan, China
2485798 2485798 2022-11-16 China Hunan     1856 4 0   27.6104 111.7088 2022-11-17 04:21:11 Hunan, China
291809 291809 2022-11-15 China Hunan     1856 4 0   27.6104 111.7088 2022-11-16 04:21:09 Hunan, China
3596839 3596839 2022-11-14 China Hunan     1850 4 0   27.6104 111.7088 2022-11-15 04:21:16 Hunan, China
311697 311697 2022-11-13 China Hunan     1843 4 0   27.6104 111.7088 2022-11-14 04:21: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
2927020 2927020 2022-11-11 China Hunan     1831 4 0   27.6104 111.7088 2022-11-12 04:20:41 Hunan, China
2505856 2505856 2022-11-10 China Hunan     1816 4 0   27.6104 111.7088 2022-11-11 04:21:22 Hunan, China
2430731 2430731 2022-11-09 China Hunan     1803 4 0   27.6104 111.7088 2022-11-10 04:21:16 Hunan, China
479387 479387 2022-11-08 China Hunan     1803 4 0   27.6104 111.7088 2022-11-09 04:21:22 Hunan, China
2438537 2438537 2022-11-07 China Hunan     1795 4 0   27.6104 111.7088 2022-11-08 04:21:21 Hunan, China
1049635 1049635 2022-11-06 China Hunan     1779 4 0   27.6104 111.7088 2022-11-07 04:21:26 Hunan, China
617659 617659 2022-11-05 China Hunan     1769 4 0   27.6104 111.7088 2022-11-06 04:21:24 Hunan, China
1022163 1022163 2022-11-04 China Hunan     1722 4 0   27.6104 111.7088 2022-11-05 04:21:52 Hunan, China
431154 431154 2022-11-03 China Hunan     1712 4 0   27.6104 111.7088 2022-11-04 04:22:11 Hunan, China
849396 849396 2022-11-02 China Hunan     1712 4 0   27.6104 111.7088 2022-11-03 04:22:05 Hunan, China
710247 710247 2022-11-01 China Hunan     1697 4 0   27.6104 111.7088 2022-11-02 04:22:09 Hunan, China
3284696 3284696 2022-10-31 China Hunan     1682 4 0   27.6104 111.7088 2022-11-01 04:22:36 Hunan, China
319729 319729 2022-10-30 China Hunan     1670 4 0   27.6104 111.7088 2022-10-31 04:21:36 Hunan, China
912005 912005 2022-10-29 China Hunan     1665 4 0   27.6104 111.7088 2022-10-30 04:22:14 Hunan, China
1366274 1366274 2022-10-28 China Hunan     1645 4 0   27.6104 111.7088 2022-10-29 04:21:13 Hunan, China
3038129 3038129 2022-10-27 China Hunan     1645 4 0   27.6104 111.7088 2022-10-28 04:22:31 Hunan, China
538549 538549 2022-10-26 China Hunan     1621 4 0   27.6104 111.7088 2022-10-27 04:22:01 Hunan, China
1829950 1829950 2022-10-25 China Hunan     1608 4 0   27.6104 111.7088 2022-10-26 04:22:19 Hunan, China
794211 794211 2022-10-24 China Hunan     1600 4 0   27.6104 111.7088 2022-10-25 04:21:53 Hunan, China
3276666 3276666 2022-10-23 China Hunan     1589 4 0   27.6104 111.7088 2022-10-24 04:22:29 Hunan, China
2267704 2267704 2022-10-22 China Hunan     1582 4 0   27.6104 111.7088 2022-10-23 04:22:46 Hunan, China
1592004 1592004 2022-10-21 China Hunan     1572 4 0   27.6104 111.7088 2022-10-22 04:22:53 Hunan, China
2271720 2271720 2022-10-20 China Hunan     1563 4 0   27.6104 111.7088 2022-10-21 04:22:23 Hunan, China
198055 198055 2022-10-19 China Hunan     1556 4 0   27.6104 111.7088 2022-10-20 04:22:59 Hunan, China
2756716 2756716 2022-10-18 China Hunan     1549 4 0   27.6104 111.7088 2022-10-19 04:22:26 Hunan, China
2024550 2024550 2022-10-17 China Hunan     1542 4 0   27.6104 111.7088 2022-10-18 04:22:42 Hunan, China
2159328 2159328 2022-10-16 China Hunan     1526 4 0   27.6104 111.7088 2022-10-17 04:20:31 Hunan, China
515525 515525 2022-10-15 China Hunan     1522 4 0   27.6104 111.7088 2022-10-16 04:22:39 Hunan, China
2032582 2032582 2022-10-14 China Hunan     1521 4 0   27.6104 111.7088 2022-10-15 04:22:00 Hunan, China
3753270 3753270 2022-10-13 China Hunan     1518 4 0   27.6104 111.7088 2022-10-14 04:22:28 Hunan, China
3214095 3214095 2022-10-12 China Hunan     1518 4 0   27.6104 111.7088 2022-10-13 04:22:39 Hunan, China
3249944 3249944 2022-10-11 China Hunan     1516 4 0   27.6104 111.7088 2022-10-12 04:22:51 Hunan, China
2967203 2967203 2022-10-10 China Hunan     1502 4 0   27.6104 111.7088 2022-10-11 04:23:05 Hunan, China
3097239 3097239 2022-10-09 China Hunan     1497 4 0   27.6104 111.7088 2022-10-10 04:22:32 Hunan, China
4002464 4002464 2022-10-08 China Hunan     1493 4 0   27.6104 111.7088 2022-10-09 04:21:16 Hunan, China
396061 396061 2022-10-07 China Hunan     1490 4 0   27.6104 111.7088 2022-10-08 04:22:56 Hunan, China
2529178 2529178 2022-10-06 China Hunan     1485 4 0   27.6104 111.7088 2022-10-07 04:23:08 Hunan, China
1810572 1810572 2022-10-05 China Hunan     1479 4 0   27.6104 111.7088 2022-10-06 04:21:22 Hunan, China
130546 130546 2022-10-04 China Hunan     1476 4 0   27.6104 111.7088 2022-10-05 04:23:06 Hunan, China
2685493 2685493 2022-10-03 China Hunan     1472 4 0   27.6104 111.7088 2022-10-04 04:22:55 Hunan, China
2259560 2259560 2022-10-02 China Hunan     1466 4 0   27.6104 111.7088 2022-10-03 04:23:11 Hunan, China
2995086 2995086 2022-10-01 China Hunan     1458 4 0   27.6104 111.7088 2022-10-02 04:21:23 Hunan, China
853412 853412 2022-09-30 China Hunan     1457 4 0   27.6104 111.7088 2022-10-01 04:23:01 Hunan, China
2375338 2375338 2022-09-29 China Hunan     1457 4 0   27.6104 111.7088 2022-09-30 04:23:09 Hunan, China
1559889 1559889 2022-09-28 China Hunan     1456 4 0   27.6104 111.7088 2022-09-29 04:22:34 Hunan, China
3994432 3994432 2022-09-27 China Hunan     1456 4 0   27.6104 111.7088 2022-09-28 04:23:01 Hunan, China
2768760 2768760 2022-09-26 China Hunan     1456 4 0   27.6104 111.7088 2022-09-27 04:23:01 Hunan, China
1976413 1976413 2022-09-25 China Hunan     1456 4 0   27.6104 111.7088 2022-09-26 04:20:52 Hunan, China
2649580 2649580 2022-09-24 China Hunan     1456 4 0   27.6104 111.7088 2022-09-25 04:23:31 Hunan, China
384020 384020 2022-09-23 China Hunan     1456 4 0   27.6104 111.7088 2022-09-24 04:21:40 Hunan, China
1624086 1624086 2022-09-22 China Hunan     1455 4 0   27.6104 111.7088 2022-09-23 04:23:13 Hunan, China
1370290 1370290 2022-09-21 China Hunan     1451 4 0   27.6104 111.7088 2022-09-22 04:22:56 Hunan, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);