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

13,358 rows where province_or_state = "Unknown" sorted by day descending

✎ View and edit SQL

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

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

country_or_region 15

province_or_state 1

  • Unknown · 13,358 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752607 2752607 2022-12-29 Belgium Unknown     62662 33228 0       2022-12-30 04:21:04 Unknown, Belgium
2752684 2752684 2022-12-29 Chile Unknown     42 2 0       2022-12-30 04:21:04 Unknown, Chile
2752716 2752716 2022-12-29 China Unknown     1521800 0 0       2022-12-30 04:21:04 Unknown, China
2752750 2752750 2022-12-29 Colombia Unknown     0 2 0       2022-12-30 04:21:04 Unknown, Colombia
2752811 2752811 2022-12-29 Germany Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Germany
2752857 2752857 2022-12-29 India Unknown     0 0 0       2022-12-30 04:21:04 Unknown, India
2752932 2752932 2022-12-29 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
2752971 2752971 2022-12-29 Malaysia Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Malaysia
2753010 2753010 2022-12-29 Mexico Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Mexico
2753037 2753037 2022-12-29 Netherlands Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Netherlands
2753086 2753086 2022-12-29 Peru Unknown     10580 106 0       2022-12-30 04:21:04 Unknown, Peru
2753213 2753213 2022-12-29 Spain Unknown     0 0 0       2022-12-30 04:21:04 Unknown, Spain
2756554 2756554 2022-12-29 Ukraine Unknown     545114 5261 0       2022-12-30 04:21:04 Unknown, Ukraine
2756578 2756578 2022-12-29 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-30 04:21:04 Unknown, United Kingdom
1073613 1073613 2022-12-28 Belgium Unknown     62662 33228 0       2022-12-29 04:21:01 Unknown, Belgium
1073690 1073690 2022-12-28 Chile Unknown     42 2 0       2022-12-29 04:21:01 Unknown, Chile
1073722 1073722 2022-12-28 China Unknown     1521800 0 0       2022-12-29 04:21:01 Unknown, China
1073756 1073756 2022-12-28 Colombia Unknown     0 105 0       2022-12-29 04:21:01 Unknown, Colombia
1073817 1073817 2022-12-28 Germany Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Germany
1073863 1073863 2022-12-28 India Unknown     0 0 0       2022-12-29 04:21:01 Unknown, India
1073938 1073938 2022-12-28 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
1073977 1073977 2022-12-28 Malaysia Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Malaysia
1074016 1074016 2022-12-28 Mexico Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Mexico
1074043 1074043 2022-12-28 Netherlands Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Netherlands
1074092 1074092 2022-12-28 Peru Unknown     7418 74 0       2022-12-29 04:21:01 Unknown, Peru
1074219 1074219 2022-12-28 Spain Unknown     0 0 0       2022-12-29 04:21:01 Unknown, Spain
1077560 1077560 2022-12-28 Ukraine Unknown     545114 5261 0       2022-12-29 04:21:01 Unknown, Ukraine
1077584 1077584 2022-12-28 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-29 04:21:01 Unknown, United Kingdom
327610 327610 2022-12-27 Belgium Unknown     62662 33228 0       2022-12-28 04:21:04 Unknown, Belgium
327687 327687 2022-12-27 Chile Unknown     42 2 0       2022-12-28 04:21:04 Unknown, Chile
327719 327719 2022-12-27 China Unknown     1521800 0 0       2022-12-28 04:21:04 Unknown, China
327753 327753 2022-12-27 Colombia Unknown     0 105 0       2022-12-28 04:21:04 Unknown, Colombia
327814 327814 2022-12-27 Germany Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Germany
327860 327860 2022-12-27 India Unknown     0 0 0       2022-12-28 04:21:04 Unknown, India
327935 327935 2022-12-27 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
327974 327974 2022-12-27 Malaysia Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Malaysia
328013 328013 2022-12-27 Mexico Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Mexico
328040 328040 2022-12-27 Netherlands Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Netherlands
328089 328089 2022-12-27 Peru Unknown     2092 41 0       2022-12-28 04:21:04 Unknown, Peru
328216 328216 2022-12-27 Spain Unknown     0 0 0       2022-12-28 04:21:04 Unknown, Spain
331557 331557 2022-12-27 Ukraine Unknown     545114 5261 0       2022-12-28 04:21:04 Unknown, Ukraine
331581 331581 2022-12-27 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-28 04:21:04 Unknown, United Kingdom
217683 217683 2022-12-26 Belgium Unknown     62662 33228 0       2022-12-27 04:21:07 Unknown, Belgium
217760 217760 2022-12-26 Chile Unknown     42 2 0       2022-12-27 04:21:07 Unknown, Chile
217792 217792 2022-12-26 China Unknown     1521800 0 0       2022-12-27 04:21:07 Unknown, China
217826 217826 2022-12-26 Colombia Unknown     0 105 0       2022-12-27 04:21:07 Unknown, Colombia
217887 217887 2022-12-26 Germany Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Germany
217933 217933 2022-12-26 India Unknown     0 0 0       2022-12-27 04:21:07 Unknown, India
218008 218008 2022-12-26 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
218047 218047 2022-12-26 Malaysia Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Malaysia
218086 218086 2022-12-26 Mexico Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Mexico
218113 218113 2022-12-26 Netherlands Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Netherlands
218162 218162 2022-12-26 Peru Unknown     350 20 0       2022-12-27 04:21:07 Unknown, Peru
218289 218289 2022-12-26 Spain Unknown     0 0 0       2022-12-27 04:21:07 Unknown, Spain
221630 221630 2022-12-26 Ukraine Unknown     545114 5261 0       2022-12-27 04:21:07 Unknown, Ukraine
221654 221654 2022-12-26 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-27 04:21:07 Unknown, United Kingdom
3222140 3222140 2022-12-25 Belgium Unknown     62662 33228 0       2022-12-26 04:21:06 Unknown, Belgium
3222217 3222217 2022-12-25 Chile Unknown     42 2 0       2022-12-26 04:21:06 Unknown, Chile
3222249 3222249 2022-12-25 China Unknown     1521800 0 0       2022-12-26 04:21:06 Unknown, China
3222283 3222283 2022-12-25 Colombia Unknown     0 105 0       2022-12-26 04:21:06 Unknown, Colombia
3222344 3222344 2022-12-25 Germany Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Germany
3222390 3222390 2022-12-25 India Unknown     0 0 0       2022-12-26 04:21:06 Unknown, India
3222465 3222465 2022-12-25 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
3222504 3222504 2022-12-25 Malaysia Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Malaysia
3222543 3222543 2022-12-25 Mexico Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Mexico
3222570 3222570 2022-12-25 Netherlands Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Netherlands
3222619 3222619 2022-12-25 Peru Unknown     0 368 0       2022-12-26 04:21:06 Unknown, Peru
3222746 3222746 2022-12-25 Spain Unknown     0 0 0       2022-12-26 04:21:06 Unknown, Spain
3226087 3226087 2022-12-25 Ukraine Unknown     545114 5261 0       2022-12-26 04:21:06 Unknown, Ukraine
3226111 3226111 2022-12-25 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-26 04:21:06 Unknown, United Kingdom
1018054 1018054 2022-12-24 Belgium Unknown     62662 33228 0       2022-12-25 04:21:04 Unknown, Belgium
1018131 1018131 2022-12-24 Chile Unknown     42 2 0       2022-12-25 04:21:04 Unknown, Chile
1018163 1018163 2022-12-24 China Unknown     1521800 0 0       2022-12-25 04:21:04 Unknown, China
1018197 1018197 2022-12-24 Colombia Unknown     0 105 0       2022-12-25 04:21:04 Unknown, Colombia
1018258 1018258 2022-12-24 Germany Unknown     0 0 0       2022-12-25 04:21:04 Unknown, Germany
1018304 1018304 2022-12-24 India Unknown     0 0 0       2022-12-25 04:21:04 Unknown, India
1018379 1018379 2022-12-24 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
1018418 1018418 2022-12-24 Malaysia Unknown     0 0 0       2022-12-25 04:21:04 Unknown, Malaysia
1018457 1018457 2022-12-24 Mexico Unknown     0 0 0       2022-12-25 04:21:04 Unknown, Mexico
1018484 1018484 2022-12-24 Netherlands Unknown     0 0 0       2022-12-25 04:21:04 Unknown, Netherlands
1018533 1018533 2022-12-24 Peru Unknown     65286 304 0       2022-12-25 04:21:04 Unknown, Peru
1018660 1018660 2022-12-24 Spain Unknown     0 0 0       2022-12-25 04:21:04 Unknown, Spain
1022001 1022001 2022-12-24 Ukraine Unknown     545114 5261 0       2022-12-25 04:21:04 Unknown, Ukraine
1022025 1022025 2022-12-24 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-25 04:21:04 Unknown, United Kingdom
690077 690077 2022-12-23 Belgium Unknown     62662 33228 0       2022-12-24 04:21:02 Unknown, Belgium
690154 690154 2022-12-23 Chile Unknown     42 2 0       2022-12-24 04:21:02 Unknown, Chile
690186 690186 2022-12-23 China Unknown     1521800 0 0       2022-12-24 04:21:02 Unknown, China
690220 690220 2022-12-23 Colombia Unknown     0 105 0       2022-12-24 04:21:02 Unknown, Colombia
690281 690281 2022-12-23 Germany Unknown     0 0 0       2022-12-24 04:21:02 Unknown, Germany
690327 690327 2022-12-23 India Unknown     0 0 0       2022-12-24 04:21:02 Unknown, India
690402 690402 2022-12-23 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
690441 690441 2022-12-23 Malaysia Unknown     0 0 0       2022-12-24 04:21:02 Unknown, Malaysia
690480 690480 2022-12-23 Mexico Unknown     0 0 0       2022-12-24 04:21:02 Unknown, Mexico
690507 690507 2022-12-23 Netherlands Unknown     0 0 0       2022-12-24 04:21:02 Unknown, Netherlands
690556 690556 2022-12-23 Peru Unknown     61873 303 0       2022-12-24 04:21:02 Unknown, Peru
690683 690683 2022-12-23 Spain Unknown     0 0 0       2022-12-24 04:21:02 Unknown, Spain
694024 694024 2022-12-23 Ukraine Unknown     545114 5261 0       2022-12-24 04:21:02 Unknown, Ukraine
694048 694048 2022-12-23 United Kingdom Unknown     0 326 0   55.3781 -3.436 2022-12-24 04:21:02 Unknown, United Kingdom
2179287 2179287 2022-12-22 Belgium Unknown     62662 33228 0       2022-12-23 04:21:04 Unknown, Belgium
2179364 2179364 2022-12-22 Chile Unknown     42 2 0       2022-12-23 04:21:04 Unknown, Chile

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