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 = "Inner Mongolia" 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

  • Inner Mongolia · 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
2752701 2752701 2022-12-29 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-30 04:21:04 Inner Mongolia, China
1073707 1073707 2022-12-28 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-29 04:21:01 Inner Mongolia, China
327704 327704 2022-12-27 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-28 04:21:04 Inner Mongolia, China
217777 217777 2022-12-26 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-27 04:21:07 Inner Mongolia, China
3222234 3222234 2022-12-25 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-26 04:21:06 Inner Mongolia, China
1018148 1018148 2022-12-24 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-25 04:21:04 Inner Mongolia, China
690171 690171 2022-12-23 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-24 04:21:02 Inner Mongolia, China
2179381 2179381 2022-12-22 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-23 04:21:04 Inner Mongolia, China
451185 451185 2022-12-21 China Inner Mongolia     8394 1 0   44.0935 113.9448 2022-12-22 04:20:56 Inner Mongolia, China
2951184 2951184 2022-12-20 China Inner Mongolia     8386 1 0   44.0935 113.9448 2022-12-21 04:21:03 Inner Mongolia, China
3173586 3173586 2022-12-19 China Inner Mongolia     8386 1 0   44.0935 113.9448 2022-12-20 04:21:04 Inner Mongolia, China
1628103 1628103 2022-12-18 China Inner Mongolia     8335 1 0   44.0935 113.9448 2022-12-19 04:21:03 Inner Mongolia, China
503482 503482 2022-12-17 China Inner Mongolia     8318 1 0   44.0935 113.9448 2022-12-18 04:21:03 Inner Mongolia, China
3324054 3324054 2022-12-16 China Inner Mongolia     8237 1 0   44.0935 113.9448 2022-12-17 04:21:04 Inner Mongolia, China
542566 542566 2022-12-15 China Inner Mongolia     8237 1 0   44.0935 113.9448 2022-12-16 04:21:01 Inner Mongolia, China
348094 348094 2022-12-14 China Inner Mongolia     8237 1 0   44.0935 113.9448 2022-12-15 04:20:58 Inner Mongolia, China
307682 307682 2022-12-13 China Inner Mongolia     8237 1 0   44.0935 113.9448 2022-12-14 04:21:04 Inner Mongolia, China
1148743 1148743 2022-12-12 China Inner Mongolia     8222 1 0   44.0935 113.9448 2022-12-13 04:21:01 Inner Mongolia, China
868597 868597 2022-12-11 China Inner Mongolia     8215 1 0   44.0935 113.9448 2022-12-12 04:21:01 Inner Mongolia, China
257127 257127 2022-12-10 China Inner Mongolia     8194 1 0   44.0935 113.9448 2022-12-11 04:20:50 Inner Mongolia, China
3935841 3935841 2022-12-09 China Inner Mongolia     8171 1 0   44.0935 113.9448 2022-12-10 04:21:02 Inner Mongolia, China
3377173 3377173 2022-12-08 China Inner Mongolia     8102 1 0   44.0935 113.9448 2022-12-09 04:21:05 Inner Mongolia, China
1984444 1984444 2022-12-07 China Inner Mongolia     8050 1 0   44.0935 113.9448 2022-12-08 04:21:07 Inner Mongolia, China
3713967 3713967 2022-12-06 China Inner Mongolia     7973 1 0   44.0935 113.9448 2022-12-07 04:20:58 Inner Mongolia, China
2414672 2414672 2022-12-05 China Inner Mongolia     7973 1 0   44.0935 113.9448 2022-12-06 04:21:03 Inner Mongolia, China
718280 718280 2022-12-04 China Inner Mongolia     7928 1 0   44.0935 113.9448 2022-12-05 04:20:58 Inner Mongolia, China
2816569 2816569 2022-12-03 China Inner Mongolia     7862 1 0   44.0935 113.9448 2022-12-04 04:20:56 Inner Mongolia, China
833425 833425 2022-12-02 China Inner Mongolia     7807 1 0   44.0935 113.9448 2022-12-03 04:21:02 Inner Mongolia, China
2135955 2135955 2022-12-01 China Inner Mongolia     7664 1 0   44.0935 113.9448 2022-12-02 04:21:07 Inner Mongolia, China
1964371 1964371 2022-11-30 China Inner Mongolia     7664 1 0   44.0935 113.9448 2022-12-01 04:21:03 Inner Mongolia, China
2556385 2556385 2022-11-29 China Inner Mongolia     7587 1 0   44.0935 113.9448 2022-11-30 04:21:07 Inner Mongolia, China
1239459 1239459 2022-11-28 China Inner Mongolia     7480 1 0   44.0935 113.9448 2022-11-29 04:21:05 Inner Mongolia, China
3551447 3551447 2022-11-27 China Inner Mongolia     7389 1 0   44.0935 113.9448 2022-11-28 04:21:02 Inner Mongolia, China
2099927 2099927 2022-11-26 China Inner Mongolia     7267 1 0   44.0935 113.9448 2022-11-27 04:21:05 Inner Mongolia, China
487418 487418 2022-11-25 China Inner Mongolia     7161 1 0   44.0935 113.9448 2022-11-26 04:21:11 Inner Mongolia, China
3523247 3523247 2022-11-24 China Inner Mongolia     7048 1 0   44.0935 113.9448 2022-11-25 04:21:06 Inner Mongolia, China
3312030 3312030 2022-11-23 China Inner Mongolia     6956 1 0   44.0935 113.9448 2022-11-24 04:21:09 Inner Mongolia, China
1620071 1620071 2022-11-22 China Inner Mongolia     6868 1 0   44.0935 113.9448 2022-11-23 04:21:06 Inner Mongolia, China
3459959 3459959 2022-11-21 China Inner Mongolia     6744 1 0   44.0935 113.9448 2022-11-22 04:20:47 Inner Mongolia, China
1640144 1640144 2022-11-20 China Inner Mongolia     6666 1 0   44.0935 113.9448 2022-11-21 04:21:05 Inner Mongolia, China
2063701 2063701 2022-11-19 China Inner Mongolia     6574 1 0   44.0935 113.9448 2022-11-20 04:21:08 Inner Mongolia, China
1755095 1755095 2022-11-18 China Inner Mongolia     6475 1 0   44.0935 113.9448 2022-11-19 04:21:14 Inner Mongolia, China
3026088 3026088 2022-11-17 China Inner Mongolia     6358 1 0   44.0935 113.9448 2022-11-18 04:21:15 Inner Mongolia, China
2485799 2485799 2022-11-16 China Inner Mongolia     6246 1 0   44.0935 113.9448 2022-11-17 04:21:11 Inner Mongolia, China
291810 291810 2022-11-15 China Inner Mongolia     6138 1 0   44.0935 113.9448 2022-11-16 04:21:09 Inner Mongolia, China
3596840 3596840 2022-11-14 China Inner Mongolia     6055 1 0   44.0935 113.9448 2022-11-15 04:21:16 Inner Mongolia, China
311698 311698 2022-11-13 China Inner Mongolia     5971 1 0   44.0935 113.9448 2022-11-14 04:21:09 Inner Mongolia, China
62859 62859 2022-11-12 China Inner Mongolia     5890 1 0   44.0935 113.9448 2022-11-13 04:21:14 Inner Mongolia, China
2927021 2927021 2022-11-11 China Inner Mongolia     5776 1 0   44.0935 113.9448 2022-11-12 04:20:41 Inner Mongolia, China
2505857 2505857 2022-11-10 China Inner Mongolia     5686 1 0   44.0935 113.9448 2022-11-11 04:21:22 Inner Mongolia, China
2430732 2430732 2022-11-09 China Inner Mongolia     5586 1 0   44.0935 113.9448 2022-11-10 04:21:16 Inner Mongolia, China
479388 479388 2022-11-08 China Inner Mongolia     5477 1 0   44.0935 113.9448 2022-11-09 04:21:22 Inner Mongolia, China
2438538 2438538 2022-11-07 China Inner Mongolia     5342 1 0   44.0935 113.9448 2022-11-08 04:21:21 Inner Mongolia, China
1049636 1049636 2022-11-06 China Inner Mongolia     5183 1 0   44.0935 113.9448 2022-11-07 04:21:26 Inner Mongolia, China
617660 617660 2022-11-05 China Inner Mongolia     5124 1 0   44.0935 113.9448 2022-11-06 04:21:24 Inner Mongolia, China
1022164 1022164 2022-11-04 China Inner Mongolia     5080 1 0   44.0935 113.9448 2022-11-05 04:21:52 Inner Mongolia, China
431155 431155 2022-11-03 China Inner Mongolia     5002 1 0   44.0935 113.9448 2022-11-04 04:22:11 Inner Mongolia, China
849397 849397 2022-11-02 China Inner Mongolia     4763 1 0   44.0935 113.9448 2022-11-03 04:22:05 Inner Mongolia, China
710248 710248 2022-11-01 China Inner Mongolia     4544 1 0   44.0935 113.9448 2022-11-02 04:22:09 Inner Mongolia, China
3284697 3284697 2022-10-31 China Inner Mongolia     4529 1 0   44.0935 113.9448 2022-11-01 04:22:36 Inner Mongolia, China
319730 319730 2022-10-30 China Inner Mongolia     4505 1 0   44.0935 113.9448 2022-10-31 04:21:36 Inner Mongolia, China
912006 912006 2022-10-29 China Inner Mongolia     4484 1 0   44.0935 113.9448 2022-10-30 04:22:14 Inner Mongolia, China
1366275 1366275 2022-10-28 China Inner Mongolia     4461 1 0   44.0935 113.9448 2022-10-29 04:21:13 Inner Mongolia, China
3038130 3038130 2022-10-27 China Inner Mongolia     4461 1 0   44.0935 113.9448 2022-10-28 04:22:31 Inner Mongolia, China
538550 538550 2022-10-26 China Inner Mongolia     4423 1 0   44.0935 113.9448 2022-10-27 04:22:01 Inner Mongolia, China
1829951 1829951 2022-10-25 China Inner Mongolia     4392 1 0   44.0935 113.9448 2022-10-26 04:22:19 Inner Mongolia, China
794212 794212 2022-10-24 China Inner Mongolia     4357 1 0   44.0935 113.9448 2022-10-25 04:21:53 Inner Mongolia, China
3276667 3276667 2022-10-23 China Inner Mongolia     4335 1 0   44.0935 113.9448 2022-10-24 04:22:29 Inner Mongolia, China
2267705 2267705 2022-10-22 China Inner Mongolia     4303 1 0   44.0935 113.9448 2022-10-23 04:22:46 Inner Mongolia, China
1592005 1592005 2022-10-21 China Inner Mongolia     4272 1 0   44.0935 113.9448 2022-10-22 04:22:53 Inner Mongolia, China
2271721 2271721 2022-10-20 China Inner Mongolia     4238 1 0   44.0935 113.9448 2022-10-21 04:22:23 Inner Mongolia, China
198056 198056 2022-10-19 China Inner Mongolia     4211 1 0   44.0935 113.9448 2022-10-20 04:22:59 Inner Mongolia, China
2756717 2756717 2022-10-18 China Inner Mongolia     4181 1 0   44.0935 113.9448 2022-10-19 04:22:26 Inner Mongolia, China
2024551 2024551 2022-10-17 China Inner Mongolia     4155 1 0   44.0935 113.9448 2022-10-18 04:22:42 Inner Mongolia, China
2159329 2159329 2022-10-16 China Inner Mongolia     4136 1 0   44.0935 113.9448 2022-10-17 04:20:31 Inner Mongolia, China
515526 515526 2022-10-15 China Inner Mongolia     4120 1 0   44.0935 113.9448 2022-10-16 04:22:39 Inner Mongolia, China
2032583 2032583 2022-10-14 China Inner Mongolia     4107 1 0   44.0935 113.9448 2022-10-15 04:22:00 Inner Mongolia, China
3753271 3753271 2022-10-13 China Inner Mongolia     4058 1 0   44.0935 113.9448 2022-10-14 04:22:28 Inner Mongolia, China
3214096 3214096 2022-10-12 China Inner Mongolia     4002 1 0   44.0935 113.9448 2022-10-13 04:22:39 Inner Mongolia, China
3249945 3249945 2022-10-11 China Inner Mongolia     3947 1 0   44.0935 113.9448 2022-10-12 04:22:51 Inner Mongolia, China
2967204 2967204 2022-10-10 China Inner Mongolia     3899 1 0   44.0935 113.9448 2022-10-11 04:23:05 Inner Mongolia, China
3097240 3097240 2022-10-09 China Inner Mongolia     3752 1 0   44.0935 113.9448 2022-10-10 04:22:32 Inner Mongolia, China
4002465 4002465 2022-10-08 China Inner Mongolia     3629 1 0   44.0935 113.9448 2022-10-09 04:21:16 Inner Mongolia, China
396062 396062 2022-10-07 China Inner Mongolia     3419 1 0   44.0935 113.9448 2022-10-08 04:22:56 Inner Mongolia, China
2529179 2529179 2022-10-06 China Inner Mongolia     3163 1 0   44.0935 113.9448 2022-10-07 04:23:08 Inner Mongolia, China
1810573 1810573 2022-10-05 China Inner Mongolia     3148 1 0   44.0935 113.9448 2022-10-06 04:21:22 Inner Mongolia, China
130547 130547 2022-10-04 China Inner Mongolia     3122 1 0   44.0935 113.9448 2022-10-05 04:23:06 Inner Mongolia, China
2685494 2685494 2022-10-03 China Inner Mongolia     3057 1 0   44.0935 113.9448 2022-10-04 04:22:55 Inner Mongolia, China
2259561 2259561 2022-10-02 China Inner Mongolia     2904 1 0   44.0935 113.9448 2022-10-03 04:23:11 Inner Mongolia, China
2995087 2995087 2022-10-01 China Inner Mongolia     2817 1 0   44.0935 113.9448 2022-10-02 04:21:23 Inner Mongolia, China
853413 853413 2022-09-30 China Inner Mongolia     2790 1 0   44.0935 113.9448 2022-10-01 04:23:01 Inner Mongolia, China
2375339 2375339 2022-09-29 China Inner Mongolia     2771 1 0   44.0935 113.9448 2022-09-30 04:23:09 Inner Mongolia, China
1559890 1559890 2022-09-28 China Inner Mongolia     2770 1 0   44.0935 113.9448 2022-09-29 04:22:34 Inner Mongolia, China
3994433 3994433 2022-09-27 China Inner Mongolia     2768 1 0   44.0935 113.9448 2022-09-28 04:23:01 Inner Mongolia, China
2768761 2768761 2022-09-26 China Inner Mongolia     2768 1 0   44.0935 113.9448 2022-09-27 04:23:01 Inner Mongolia, China
1976414 1976414 2022-09-25 China Inner Mongolia     2766 1 0   44.0935 113.9448 2022-09-26 04:20:52 Inner Mongolia, China
2649581 2649581 2022-09-24 China Inner Mongolia     2765 1 0   44.0935 113.9448 2022-09-25 04:23:31 Inner Mongolia, China
384021 384021 2022-09-23 China Inner Mongolia     2759 1 0   44.0935 113.9448 2022-09-24 04:21:40 Inner Mongolia, China
1624087 1624087 2022-09-22 China Inner Mongolia     2755 1 0   44.0935 113.9448 2022-09-23 04:23:13 Inner Mongolia, China
1370291 1370291 2022-09-21 China Inner Mongolia     2755 1 0   44.0935 113.9448 2022-09-22 04:22:56 Inner Mongolia, 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]);