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 = "Henan" sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

  • Henan · 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
2752697 2752697 2022-12-29 China Henan     9089 23 0   33.882 113.614 2022-12-30 04:21:04 Henan, China
1073703 1073703 2022-12-28 China Henan     9089 23 0   33.882 113.614 2022-12-29 04:21:01 Henan, China
327700 327700 2022-12-27 China Henan     9089 23 0   33.882 113.614 2022-12-28 04:21:04 Henan, China
217773 217773 2022-12-26 China Henan     9089 23 0   33.882 113.614 2022-12-27 04:21:07 Henan, China
3222230 3222230 2022-12-25 China Henan     9089 23 0   33.882 113.614 2022-12-26 04:21:06 Henan, China
1018144 1018144 2022-12-24 China Henan     9089 23 0   33.882 113.614 2022-12-25 04:21:04 Henan, China
690167 690167 2022-12-23 China Henan     9089 23 0   33.882 113.614 2022-12-24 04:21:02 Henan, China
2179377 2179377 2022-12-22 China Henan     9089 23 0   33.882 113.614 2022-12-23 04:21:04 Henan, China
451181 451181 2022-12-21 China Henan     9089 23 0   33.882 113.614 2022-12-22 04:20:56 Henan, China
2951180 2951180 2022-12-20 China Henan     9011 23 0   33.882 113.614 2022-12-21 04:21:03 Henan, China
3173582 3173582 2022-12-19 China Henan     9011 23 0   33.882 113.614 2022-12-20 04:21:04 Henan, China
1628099 1628099 2022-12-18 China Henan     8927 23 0   33.882 113.614 2022-12-19 04:21:03 Henan, China
503478 503478 2022-12-17 China Henan     8897 23 0   33.882 113.614 2022-12-18 04:21:03 Henan, China
3324050 3324050 2022-12-16 China Henan     8692 23 0   33.882 113.614 2022-12-17 04:21:04 Henan, China
542562 542562 2022-12-15 China Henan     8692 23 0   33.882 113.614 2022-12-16 04:21:01 Henan, China
348090 348090 2022-12-14 China Henan     8692 23 0   33.882 113.614 2022-12-15 04:20:58 Henan, China
307678 307678 2022-12-13 China Henan     8692 23 0   33.882 113.614 2022-12-14 04:21:04 Henan, China
1148739 1148739 2022-12-12 China Henan     8692 23 0   33.882 113.614 2022-12-13 04:21:01 Henan, China
868593 868593 2022-12-11 China Henan     8618 23 0   33.882 113.614 2022-12-12 04:21:01 Henan, China
257123 257123 2022-12-10 China Henan     8538 23 0   33.882 113.614 2022-12-11 04:20:50 Henan, China
3935837 3935837 2022-12-09 China Henan     8494 23 0   33.882 113.614 2022-12-10 04:21:02 Henan, China
3377169 3377169 2022-12-08 China Henan     8192 23 0   33.882 113.614 2022-12-09 04:21:05 Henan, China
1984440 1984440 2022-12-07 China Henan     8031 23 0   33.882 113.614 2022-12-08 04:21:07 Henan, China
3713963 3713963 2022-12-06 China Henan     7877 23 0   33.882 113.614 2022-12-07 04:20:58 Henan, China
2414668 2414668 2022-12-05 China Henan     7877 23 0   33.882 113.614 2022-12-06 04:21:03 Henan, China
718276 718276 2022-12-04 China Henan     7714 23 0   33.882 113.614 2022-12-05 04:20:58 Henan, China
2816565 2816565 2022-12-03 China Henan     7508 23 0   33.882 113.614 2022-12-04 04:20:56 Henan, China
833421 833421 2022-12-02 China Henan     7508 23 0   33.882 113.614 2022-12-03 04:21:02 Henan, China
2135951 2135951 2022-12-01 China Henan     7352 23 0   33.882 113.614 2022-12-02 04:21:07 Henan, China
1964367 1964367 2022-11-30 China Henan     7277 23 0   33.882 113.614 2022-12-01 04:21:03 Henan, China
2556381 2556381 2022-11-29 China Henan     7144 23 0   33.882 113.614 2022-11-30 04:21:07 Henan, China
1239455 1239455 2022-11-28 China Henan     7144 23 0   33.882 113.614 2022-11-29 04:21:05 Henan, China
3551443 3551443 2022-11-27 China Henan     6980 23 0   33.882 113.614 2022-11-28 04:21:02 Henan, China
2099923 2099923 2022-11-26 China Henan     6654 23 0   33.882 113.614 2022-11-27 04:21:05 Henan, China
487414 487414 2022-11-25 China Henan     6468 23 0   33.882 113.614 2022-11-26 04:21:11 Henan, China
3523243 3523243 2022-11-24 China Henan     6468 23 0   33.882 113.614 2022-11-25 04:21:06 Henan, China
3312026 3312026 2022-11-23 China Henan     6169 23 0   33.882 113.614 2022-11-24 04:21:09 Henan, China
1620067 1620067 2022-11-22 China Henan     6054 23 0   33.882 113.614 2022-11-23 04:21:06 Henan, China
3459955 3459955 2022-11-21 China Henan     6054 23 0   33.882 113.614 2022-11-22 04:20:47 Henan, China
1640140 1640140 2022-11-20 China Henan     5979 22 0   33.882 113.614 2022-11-21 04:21:05 Henan, China
2063697 2063697 2022-11-19 China Henan     5818 22 0   33.882 113.614 2022-11-20 04:21:08 Henan, China
1755091 1755091 2022-11-18 China Henan     5440 22 0   33.882 113.614 2022-11-19 04:21:14 Henan, China
3026084 3026084 2022-11-17 China Henan     5332 22 0   33.882 113.614 2022-11-18 04:21:15 Henan, China
2485795 2485795 2022-11-16 China Henan     5195 22 0   33.882 113.614 2022-11-17 04:21:11 Henan, China
291806 291806 2022-11-15 China Henan     5195 22 0   33.882 113.614 2022-11-16 04:21:09 Henan, China
3596836 3596836 2022-11-14 China Henan     4995 22 0   33.882 113.614 2022-11-15 04:21:16 Henan, China
311694 311694 2022-11-13 China Henan     4846 22 0   33.882 113.614 2022-11-14 04:21:09 Henan, China
62855 62855 2022-11-12 China Henan     4621 22 0   33.882 113.614 2022-11-13 04:21:14 Henan, China
2927017 2927017 2022-11-11 China Henan     4379 22 0   33.882 113.614 2022-11-12 04:20:41 Henan, China
2505853 2505853 2022-11-10 China Henan     4272 22 0   33.882 113.614 2022-11-11 04:21:22 Henan, China
2430728 2430728 2022-11-09 China Henan     3970 22 0   33.882 113.614 2022-11-10 04:21:16 Henan, China
479384 479384 2022-11-08 China Henan     3970 22 0   33.882 113.614 2022-11-09 04:21:22 Henan, China
2438534 2438534 2022-11-07 China Henan     3811 22 0   33.882 113.614 2022-11-08 04:21:21 Henan, China
1049632 1049632 2022-11-06 China Henan     3725 22 0   33.882 113.614 2022-11-07 04:21:26 Henan, China
617656 617656 2022-11-05 China Henan     3683 22 0   33.882 113.614 2022-11-06 04:21:24 Henan, China
1022160 1022160 2022-11-04 China Henan     3658 22 0   33.882 113.614 2022-11-05 04:21:52 Henan, China
431151 431151 2022-11-03 China Henan     3658 22 0   33.882 113.614 2022-11-04 04:22:11 Henan, China
849393 849393 2022-11-02 China Henan     3636 22 0   33.882 113.614 2022-11-03 04:22:05 Henan, China
710244 710244 2022-11-01 China Henan     3536 22 0   33.882 113.614 2022-11-02 04:22:09 Henan, China
3284693 3284693 2022-10-31 China Henan     3523 22 0   33.882 113.614 2022-11-01 04:22:36 Henan, China
319726 319726 2022-10-30 China Henan     3517 22 0   33.882 113.614 2022-10-31 04:21:36 Henan, China
912002 912002 2022-10-29 China Henan     3510 22 0   33.882 113.614 2022-10-30 04:22:14 Henan, China
1366271 1366271 2022-10-28 China Henan     3507 22 0   33.882 113.614 2022-10-29 04:21:13 Henan, China
3038126 3038126 2022-10-27 China Henan     3507 22 0   33.882 113.614 2022-10-28 04:22:31 Henan, China
538546 538546 2022-10-26 China Henan     3503 22 0   33.882 113.614 2022-10-27 04:22:01 Henan, China
1829947 1829947 2022-10-25 China Henan     3498 22 0   33.882 113.614 2022-10-26 04:22:19 Henan, China
794208 794208 2022-10-24 China Henan     3495 22 0   33.882 113.614 2022-10-25 04:21:53 Henan, China
3276663 3276663 2022-10-23 China Henan     3489 22 0   33.882 113.614 2022-10-24 04:22:29 Henan, China
2267701 2267701 2022-10-22 China Henan     3481 22 0   33.882 113.614 2022-10-23 04:22:46 Henan, China
1592001 1592001 2022-10-21 China Henan     3475 22 0   33.882 113.614 2022-10-22 04:22:53 Henan, China
2271717 2271717 2022-10-20 China Henan     3462 22 0   33.882 113.614 2022-10-21 04:22:23 Henan, China
198052 198052 2022-10-19 China Henan     3453 22 0   33.882 113.614 2022-10-20 04:22:59 Henan, China
2756713 2756713 2022-10-18 China Henan     3446 22 0   33.882 113.614 2022-10-19 04:22:26 Henan, China
2024547 2024547 2022-10-17 China Henan     3436 22 0   33.882 113.614 2022-10-18 04:22:42 Henan, China
2159325 2159325 2022-10-16 China Henan     3430 22 0   33.882 113.614 2022-10-17 04:20:31 Henan, China
515522 515522 2022-10-15 China Henan     3422 22 0   33.882 113.614 2022-10-16 04:22:39 Henan, China
2032579 2032579 2022-10-14 China Henan     3415 22 0   33.882 113.614 2022-10-15 04:22:00 Henan, China
3753267 3753267 2022-10-13 China Henan     3405 22 0   33.882 113.614 2022-10-14 04:22:28 Henan, China
3214092 3214092 2022-10-12 China Henan     3397 22 0   33.882 113.614 2022-10-13 04:22:39 Henan, China
3249941 3249941 2022-10-11 China Henan     3385 22 0   33.882 113.614 2022-10-12 04:22:51 Henan, China
2967200 2967200 2022-10-10 China Henan     3372 22 0   33.882 113.614 2022-10-11 04:23:05 Henan, China
3097236 3097236 2022-10-09 China Henan     3360 22 0   33.882 113.614 2022-10-10 04:22:32 Henan, China
4002461 4002461 2022-10-08 China Henan     3349 22 0   33.882 113.614 2022-10-09 04:21:16 Henan, China
396058 396058 2022-10-07 China Henan     3341 22 0   33.882 113.614 2022-10-08 04:22:56 Henan, China
2529175 2529175 2022-10-06 China Henan     3341 22 0   33.882 113.614 2022-10-07 04:23:08 Henan, China
1810569 1810569 2022-10-05 China Henan     3336 22 0   33.882 113.614 2022-10-06 04:21:22 Henan, China
130543 130543 2022-10-04 China Henan     3333 22 0   33.882 113.614 2022-10-05 04:23:06 Henan, China
2685490 2685490 2022-10-03 China Henan     3332 22 0   33.882 113.614 2022-10-04 04:22:55 Henan, China
2259557 2259557 2022-10-02 China Henan     3330 22 0   33.882 113.614 2022-10-03 04:23:11 Henan, China
2995083 2995083 2022-10-01 China Henan     3330 22 0   33.882 113.614 2022-10-02 04:21:23 Henan, China
853409 853409 2022-09-30 China Henan     3330 22 0   33.882 113.614 2022-10-01 04:23:01 Henan, China
2375335 2375335 2022-09-29 China Henan     3330 22 0   33.882 113.614 2022-09-30 04:23:09 Henan, China
1559886 1559886 2022-09-28 China Henan     3329 22 0   33.882 113.614 2022-09-29 04:22:34 Henan, China
3994429 3994429 2022-09-27 China Henan     3327 22 0   33.882 113.614 2022-09-28 04:23:01 Henan, China
2768757 2768757 2022-09-26 China Henan     3326 22 0   33.882 113.614 2022-09-27 04:23:01 Henan, China
1976410 1976410 2022-09-25 China Henan     3325 22 0   33.882 113.614 2022-09-26 04:20:52 Henan, China
2649577 2649577 2022-09-24 China Henan     3325 22 0   33.882 113.614 2022-09-25 04:23:31 Henan, China
384017 384017 2022-09-23 China Henan     3325 22 0   33.882 113.614 2022-09-24 04:21:40 Henan, China
1624083 1624083 2022-09-22 China Henan     3325 22 0   33.882 113.614 2022-09-23 04:23:13 Henan, China
1370287 1370287 2022-09-21 China Henan     3325 22 0   33.882 113.614 2022-09-22 04:22:56 Henan, 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]);