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 = "Hainan" 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

  • Hainan · 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
2752694 2752694 2022-12-29 China Hainan     10436 6 0   19.1959 109.7453 2022-12-30 04:21:04 Hainan, China
1073700 1073700 2022-12-28 China Hainan     10436 6 0   19.1959 109.7453 2022-12-29 04:21:01 Hainan, China
327697 327697 2022-12-27 China Hainan     10436 6 0   19.1959 109.7453 2022-12-28 04:21:04 Hainan, China
217770 217770 2022-12-26 China Hainan     10436 6 0   19.1959 109.7453 2022-12-27 04:21:07 Hainan, China
3222227 3222227 2022-12-25 China Hainan     10436 6 0   19.1959 109.7453 2022-12-26 04:21:06 Hainan, China
1018141 1018141 2022-12-24 China Hainan     10436 6 0   19.1959 109.7453 2022-12-25 04:21:04 Hainan, China
690164 690164 2022-12-23 China Hainan     10436 6 0   19.1959 109.7453 2022-12-24 04:21:02 Hainan, China
2179374 2179374 2022-12-22 China Hainan     10436 6 0   19.1959 109.7453 2022-12-23 04:21:04 Hainan, China
451178 451178 2022-12-21 China Hainan     10436 6 0   19.1959 109.7453 2022-12-22 04:20:56 Hainan, China
2951177 2951177 2022-12-20 China Hainan     10432 6 0   19.1959 109.7453 2022-12-21 04:21:03 Hainan, China
3173579 3173579 2022-12-19 China Hainan     10432 6 0   19.1959 109.7453 2022-12-20 04:21:04 Hainan, China
1628096 1628096 2022-12-18 China Hainan     10425 6 0   19.1959 109.7453 2022-12-19 04:21:03 Hainan, China
503475 503475 2022-12-17 China Hainan     10422 6 0   19.1959 109.7453 2022-12-18 04:21:03 Hainan, China
3324047 3324047 2022-12-16 China Hainan     10287 6 0   19.1959 109.7453 2022-12-17 04:21:04 Hainan, China
542559 542559 2022-12-15 China Hainan     10287 6 0   19.1959 109.7453 2022-12-16 04:21:01 Hainan, China
348087 348087 2022-12-14 China Hainan     10287 6 0   19.1959 109.7453 2022-12-15 04:20:58 Hainan, China
307675 307675 2022-12-13 China Hainan     10287 6 0   19.1959 109.7453 2022-12-14 04:21:04 Hainan, China
1148736 1148736 2022-12-12 China Hainan     10287 6 0   19.1959 109.7453 2022-12-13 04:21:01 Hainan, China
868590 868590 2022-12-11 China Hainan     10101 6 0   19.1959 109.7453 2022-12-12 04:21:01 Hainan, China
257120 257120 2022-12-10 China Hainan     9894 6 0   19.1959 109.7453 2022-12-11 04:20:50 Hainan, China
3935834 3935834 2022-12-09 China Hainan     9731 6 0   19.1959 109.7453 2022-12-10 04:21:02 Hainan, China
3377166 3377166 2022-12-08 China Hainan     9542 6 0   19.1959 109.7453 2022-12-09 04:21:05 Hainan, China
1984437 1984437 2022-12-07 China Hainan     9453 6 0   19.1959 109.7453 2022-12-08 04:21:07 Hainan, China
3713960 3713960 2022-12-06 China Hainan     9453 6 0   19.1959 109.7453 2022-12-07 04:20:58 Hainan, China
2414665 2414665 2022-12-05 China Hainan     9298 6 0   19.1959 109.7453 2022-12-06 04:21:03 Hainan, China
718273 718273 2022-12-04 China Hainan     9298 6 0   19.1959 109.7453 2022-12-05 04:20:58 Hainan, China
2816562 2816562 2022-12-03 China Hainan     9239 6 0   19.1959 109.7453 2022-12-04 04:20:56 Hainan, China
833418 833418 2022-12-02 China Hainan     9184 6 0   19.1959 109.7453 2022-12-03 04:21:02 Hainan, China
2135948 2135948 2022-12-01 China Hainan     9121 6 0   19.1959 109.7453 2022-12-02 04:21:07 Hainan, China
1964364 1964364 2022-11-30 China Hainan     9092 6 0   19.1959 109.7453 2022-12-01 04:21:03 Hainan, China
2556378 2556378 2022-11-29 China Hainan     9092 6 0   19.1959 109.7453 2022-11-30 04:21:07 Hainan, China
1239452 1239452 2022-11-28 China Hainan     9077 6 0   19.1959 109.7453 2022-11-29 04:21:05 Hainan, China
3551440 3551440 2022-11-27 China Hainan     9065 6 0   19.1959 109.7453 2022-11-28 04:21:02 Hainan, China
2099920 2099920 2022-11-26 China Hainan     9055 6 0   19.1959 109.7453 2022-11-27 04:21:05 Hainan, China
487411 487411 2022-11-25 China Hainan     9048 6 0   19.1959 109.7453 2022-11-26 04:21:11 Hainan, China
3523240 3523240 2022-11-24 China Hainan     9035 6 0   19.1959 109.7453 2022-11-25 04:21:06 Hainan, China
3312023 3312023 2022-11-23 China Hainan     9025 6 0   19.1959 109.7453 2022-11-24 04:21:09 Hainan, China
1620064 1620064 2022-11-22 China Hainan     9015 6 0   19.1959 109.7453 2022-11-23 04:21:06 Hainan, China
3459952 3459952 2022-11-21 China Hainan     9015 6 0   19.1959 109.7453 2022-11-22 04:20:47 Hainan, China
1640137 1640137 2022-11-20 China Hainan     9010 6 0   19.1959 109.7453 2022-11-21 04:21:05 Hainan, China
2063694 2063694 2022-11-19 China Hainan     9003 6 0   19.1959 109.7453 2022-11-20 04:21:08 Hainan, China
1755088 1755088 2022-11-18 China Hainan     9003 6 0   19.1959 109.7453 2022-11-19 04:21:14 Hainan, China
3026081 3026081 2022-11-17 China Hainan     8999 6 0   19.1959 109.7453 2022-11-18 04:21:15 Hainan, China
2485792 2485792 2022-11-16 China Hainan     8992 6 0   19.1959 109.7453 2022-11-17 04:21:11 Hainan, China
291803 291803 2022-11-15 China Hainan     8992 6 0   19.1959 109.7453 2022-11-16 04:21:09 Hainan, China
3596833 3596833 2022-11-14 China Hainan     8984 6 0   19.1959 109.7453 2022-11-15 04:21:16 Hainan, China
311691 311691 2022-11-13 China Hainan     8984 6 0   19.1959 109.7453 2022-11-14 04:21:09 Hainan, China
62852 62852 2022-11-12 China Hainan     8983 6 0   19.1959 109.7453 2022-11-13 04:21:14 Hainan, China
2927014 2927014 2022-11-11 China Hainan     8983 6 0   19.1959 109.7453 2022-11-12 04:20:41 Hainan, China
2505850 2505850 2022-11-10 China Hainan     8983 6 0   19.1959 109.7453 2022-11-11 04:21:22 Hainan, China
2430725 2430725 2022-11-09 China Hainan     8983 6 0   19.1959 109.7453 2022-11-10 04:21:16 Hainan, China
479381 479381 2022-11-08 China Hainan     8983 6 0   19.1959 109.7453 2022-11-09 04:21:22 Hainan, China
2438531 2438531 2022-11-07 China Hainan     8981 6 0   19.1959 109.7453 2022-11-08 04:21:21 Hainan, China
1049629 1049629 2022-11-06 China Hainan     8979 6 0   19.1959 109.7453 2022-11-07 04:21:26 Hainan, China
617653 617653 2022-11-05 China Hainan     8979 6 0   19.1959 109.7453 2022-11-06 04:21:24 Hainan, China
1022157 1022157 2022-11-04 China Hainan     8979 6 0   19.1959 109.7453 2022-11-05 04:21:52 Hainan, China
431148 431148 2022-11-03 China Hainan     8979 6 0   19.1959 109.7453 2022-11-04 04:22:11 Hainan, China
849390 849390 2022-11-02 China Hainan     8979 6 0   19.1959 109.7453 2022-11-03 04:22:05 Hainan, China
710241 710241 2022-11-01 China Hainan     8979 6 0   19.1959 109.7453 2022-11-02 04:22:09 Hainan, China
3284690 3284690 2022-10-31 China Hainan     8979 6 0   19.1959 109.7453 2022-11-01 04:22:36 Hainan, China
319723 319723 2022-10-30 China Hainan     8979 6 0   19.1959 109.7453 2022-10-31 04:21:36 Hainan, China
911999 911999 2022-10-29 China Hainan     8979 6 0   19.1959 109.7453 2022-10-30 04:22:14 Hainan, China
1366268 1366268 2022-10-28 China Hainan     8979 6 0   19.1959 109.7453 2022-10-29 04:21:13 Hainan, China
3038123 3038123 2022-10-27 China Hainan     8979 6 0   19.1959 109.7453 2022-10-28 04:22:31 Hainan, China
538543 538543 2022-10-26 China Hainan     8979 6 0   19.1959 109.7453 2022-10-27 04:22:01 Hainan, China
1829944 1829944 2022-10-25 China Hainan     8979 6 0   19.1959 109.7453 2022-10-26 04:22:19 Hainan, China
794205 794205 2022-10-24 China Hainan     8979 6 0   19.1959 109.7453 2022-10-25 04:21:53 Hainan, China
3276660 3276660 2022-10-23 China Hainan     8979 6 0   19.1959 109.7453 2022-10-24 04:22:29 Hainan, China
2267698 2267698 2022-10-22 China Hainan     8979 6 0   19.1959 109.7453 2022-10-23 04:22:46 Hainan, China
1591998 1591998 2022-10-21 China Hainan     8979 6 0   19.1959 109.7453 2022-10-22 04:22:53 Hainan, China
2271714 2271714 2022-10-20 China Hainan     8979 6 0   19.1959 109.7453 2022-10-21 04:22:23 Hainan, China
198049 198049 2022-10-19 China Hainan     8979 6 0   19.1959 109.7453 2022-10-20 04:22:59 Hainan, China
2756710 2756710 2022-10-18 China Hainan     8979 6 0   19.1959 109.7453 2022-10-19 04:22:26 Hainan, China
2024544 2024544 2022-10-17 China Hainan     8979 6 0   19.1959 109.7453 2022-10-18 04:22:42 Hainan, China
2159322 2159322 2022-10-16 China Hainan     8979 6 0   19.1959 109.7453 2022-10-17 04:20:31 Hainan, China
515519 515519 2022-10-15 China Hainan     8979 6 0   19.1959 109.7453 2022-10-16 04:22:39 Hainan, China
2032576 2032576 2022-10-14 China Hainan     8979 6 0   19.1959 109.7453 2022-10-15 04:22:00 Hainan, China
3753264 3753264 2022-10-13 China Hainan     8979 6 0   19.1959 109.7453 2022-10-14 04:22:28 Hainan, China
3214089 3214089 2022-10-12 China Hainan     8979 6 0   19.1959 109.7453 2022-10-13 04:22:39 Hainan, China
3249938 3249938 2022-10-11 China Hainan     8979 6 0   19.1959 109.7453 2022-10-12 04:22:51 Hainan, China
2967197 2967197 2022-10-10 China Hainan     8977 6 0   19.1959 109.7453 2022-10-11 04:23:05 Hainan, China
3097233 3097233 2022-10-09 China Hainan     8977 6 0   19.1959 109.7453 2022-10-10 04:22:32 Hainan, China
4002458 4002458 2022-10-08 China Hainan     8974 6 0   19.1959 109.7453 2022-10-09 04:21:16 Hainan, China
396055 396055 2022-10-07 China Hainan     8964 6 0   19.1959 109.7453 2022-10-08 04:22:56 Hainan, China
2529172 2529172 2022-10-06 China Hainan     8964 6 0   19.1959 109.7453 2022-10-07 04:23:08 Hainan, China
1810566 1810566 2022-10-05 China Hainan     8957 6 0   19.1959 109.7453 2022-10-06 04:21:22 Hainan, China
130540 130540 2022-10-04 China Hainan     8955 6 0   19.1959 109.7453 2022-10-05 04:23:06 Hainan, China
2685487 2685487 2022-10-03 China Hainan     8955 6 0   19.1959 109.7453 2022-10-04 04:22:55 Hainan, China
2259554 2259554 2022-10-02 China Hainan     8955 6 0   19.1959 109.7453 2022-10-03 04:23:11 Hainan, China
2995080 2995080 2022-10-01 China Hainan     8955 6 0   19.1959 109.7453 2022-10-02 04:21:23 Hainan, China
853406 853406 2022-09-30 China Hainan     8955 6 0   19.1959 109.7453 2022-10-01 04:23:01 Hainan, China
2375332 2375332 2022-09-29 China Hainan     8955 6 0   19.1959 109.7453 2022-09-30 04:23:09 Hainan, China
1559883 1559883 2022-09-28 China Hainan     8955 6 0   19.1959 109.7453 2022-09-29 04:22:34 Hainan, China
3994426 3994426 2022-09-27 China Hainan     8955 6 0   19.1959 109.7453 2022-09-28 04:23:01 Hainan, China
2768754 2768754 2022-09-26 China Hainan     8955 6 0   19.1959 109.7453 2022-09-27 04:23:01 Hainan, China
1976407 1976407 2022-09-25 China Hainan     8955 6 0   19.1959 109.7453 2022-09-26 04:20:52 Hainan, China
2649574 2649574 2022-09-24 China Hainan     8955 6 0   19.1959 109.7453 2022-09-25 04:23:31 Hainan, China
384014 384014 2022-09-23 China Hainan     8955 6 0   19.1959 109.7453 2022-09-24 04:21:40 Hainan, China
1624080 1624080 2022-09-22 China Hainan     8954 6 0   19.1959 109.7453 2022-09-23 04:23:13 Hainan, China
1370284 1370284 2022-09-21 China Hainan     8954 6 0   19.1959 109.7453 2022-09-22 04:22:56 Hainan, 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]);