johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1720048 | 1720048 | 2020-02-19 | Mainland China | Jiangxi | 934 | 1 | 362 | 27.614 | 115.7221 | 2020-02-19T01:23:07 | ||||
1837011 | 1837011 | 2020-06-14 | Ukraine | Crimea Republic* | 512 | 7 | 362 | 143 | 45.2835 | 34.2008 | 2020-06-15 03:33:14 | Crimea Republic*, Ukraine | ||
2227283 | 2227283 | 2021-01-02 | Cambodia | 381 | 0 | 362 | 19 | 11.55 | 104.9167 | 2021-01-03 05:22:52 | Cambodia | |||
2541169 | 2541169 | 2021-01-07 | Cambodia | 386 | 0 | 362 | 24 | 11.55 | 104.9167 | 2021-01-08 05:22:42 | Cambodia | |||
2684842 | 2684842 | 2020-07-06 | Russia | Jewish Autonomous Okrug | 441 | 6 | 362 | 73 | 48.57527615 | 132.66307460000002 | 2020-07-07 04:34:00 | Jewish Autonomous Okrug, Russia | ||
2784814 | 2784814 | 2020-11-13 | China | Hebei | 373 | 6 | 362 | 5 | 37.8957 | 114.9042 | 2020-11-14 05:25:37 | Hebei, China | ||
2863739 | 2863739 | 2020-06-10 | Italy | Basilicata | 400 | 27 | 362 | 11 | 40.63947052 | 15.80514834 | 2020-06-11 03:33:41 | Basilicata, Italy | ||
2864478 | 2864478 | 2021-01-06 | Cambodia | 385 | 0 | 362 | 23 | 11.55 | 104.9167 | 2021-01-07 05:22:03 | Cambodia | |||
2880014 | 2880014 | 2020-11-15 | China | Hebei | 373 | 6 | 362 | 5 | 37.8957 | 114.9042 | 2020-11-16 05:25:57 | Hebei, China | ||
2914992 | 2914992 | 2020-11-14 | China | Hebei | 373 | 6 | 362 | 5 | 37.8957 | 114.9042 | 2020-11-15 05:26:53 | Hebei, China | ||
2958448 | 2958448 | 2020-07-29 | China | Fujian | 366 | 1 | 362 | 3 | 26.0789 | 117.9874 | 2020-07-30 04:35:05 | Fujian, China | ||
3034065 | 3034065 | 2021-01-05 | Cambodia | 383 | 0 | 362 | 21 | 11.55 | 104.9167 | 2021-01-06 05:22:16 | Cambodia | |||
3061562 | 3061562 | 2020-06-13 | Madagascar | 1252 | 10 | 362 | 880 | -18.766947000000002 | 46.869107 | 2020-06-14 03:33:15 | Madagascar | |||
3101456 | 3101456 | 2021-01-16 | Japan | Iwate | 457 | 25 | 362 | 70 | 39.593287 | 141.361777 | 2021-01-17 05:22:17 | Iwate, Japan | ||
3178018 | 3178018 | 2020-08-18 | Japan | Hiroshima | 437 | 3 | 362 | 72 | 34.605309 | 132.788719 | 2020-08-19 04:27:00 | Hiroshima, Japan | ||
3230213 | 3230213 | 2021-01-03 | Cambodia | 382 | 0 | 362 | 20 | 11.55 | 104.9167 | 2021-01-04 05:22:02 | Cambodia | |||
3484343 | 3484343 | 2020-08-20 | Japan | Shizuoka | 430 | 1 | 362 | 67 | 34.916975 | 138.40778400000002 | 2020-08-21 04:27:41 | Shizuoka, Japan | ||
3491357 | 3491357 | 2020-07-13 | Japan | Kyoto | 456 | 18 | 362 | 76 | 35.253815 | 135.443341 | 2020-07-14 04:34:46 | Kyoto, Japan | ||
3539499 | 3539499 | 2021-02-12 | Japan | Tokushima | 423 | 15 | 362 | 46 | 33.919178 | 134.242091 | 2021-02-13 05:22:12 | Tokushima, Japan | ||
3695253 | 3695253 | 2020-12-31 | Cambodia | 378 | 0 | 362 | 16 | 11.55 | 104.9167 | 2021-01-01 05:23:07 | Cambodia | |||
3737620 | 3737620 | 2020-07-12 | Japan | Kyoto | 447 | 18 | 362 | 67 | 35.253815 | 135.443341 | 2020-07-13 04:43:04 | Kyoto, Japan | ||
3860023 | 3860023 | 2020-12-04 | Russia | Chukotka Autonomous Okrug | 414 | 4 | 362 | 48 | 66.0006475 | 169.4900869 | 2020-12-05 05:27:36 | Chukotka Autonomous Okrug, Russia | ||
3931902 | 3931902 | 2020-08-30 | Denmark | Faroe Islands | 411 | 0 | 362 | 49 | 61.8926 | -6.9118 | 2020-08-31 04:28:27 | Faroe Islands, Denmark | ||
75119 | 75119 | 2020-12-03 | Japan | Okayama | 629 | 11 | 363 | 255 | 34.89246 | 133.826252 | 2020-12-04 05:27:27 | Okayama, Japan | ||
98205 | 98205 | 2020-08-04 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-05 04:34:43 | Fujian, China | ||
122513 | 122513 | 2020-11-18 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-19 05:25:23 | Hebei, China | ||
122729 | 122729 | 2020-11-18 | Japan | Nagano | 525 | 6 | 363 | 156 | 36.132134 | 138.045528 | 2020-11-19 05:25:23 | Nagano, Japan | ||
268417 | 268417 | 2020-05-21 | Mexico | Tlaxcala | 677 | 117 | 363 | 197 | 19.3139 | -98.2404 | 2020-05-22 02:36:51 | Tlaxcala, Mexico | ||
287002 | 287002 | 2020-06-15 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-16 04:33:09 | Basilicata, Italy | ||
287060 | 287060 | 2020-06-15 | Ukraine | Crimea Republic* | 539 | 7 | 363 | 169 | 45.2835 | 34.2008 | 2020-06-16 04:33:09 | Crimea Republic*, Ukraine | ||
371270 | 371270 | 2020-08-08 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-09 04:34:54 | Fujian, China | ||
392265 | 392265 | 2020-11-27 | Japan | Okayama | 568 | 11 | 363 | 194 | 34.89246 | 133.826252 | 2020-11-28 05:25:50 | Okayama, Japan | ||
400094 | 400094 | 2021-06-29 | China | Yunnan | 417 | 2 | 363 | 52 | 24.974 | 101.487 | 2021-06-30 04:21:41 | Yunnan, China | ||
458454 | 458454 | 2020-08-07 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-08 04:34:53 | Fujian, China | ||
662103 | 662103 | 2020-08-11 | China | Fujian | 368 | 1 | 363 | 4 | 26.0789 | 117.9874 | 2020-08-12 04:27:29 | Fujian, China | ||
678039 | 678039 | 2020-11-23 | Bhutan | 386 | 0 | 363 | 23 | 27.5142 | 90.4336 | 2020-11-24 05:27:31 | Bhutan | |||
738331 | 738331 | 2020-12-02 | Japan | Okayama | 619 | 11 | 363 | 245 | 34.89246 | 133.826252 | 2020-12-03 05:28:22 | Okayama, Japan | ||
753408 | 753408 | 2020-08-01 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-02 04:34:47 | Fujian, China | ||
821379 | 821379 | 2020-11-19 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-20 05:26:28 | Hebei, China | ||
1350044 | 1350044 | 2020-11-24 | Bhutan | 386 | 0 | 363 | 23 | 27.5142 | 90.4336 | 2020-11-25 05:27:20 | Bhutan | |||
1385148 | 1385148 | 2020-04-19 | Dominican Republic | 4680 | 226 | 363 | 4091 | 18.7357 | -70.1627 | 2020-04-19 23:40:41 | Dominican Republic | |||
1584194 | 1584194 | 2020-11-30 | Japan | Okayama | 599 | 11 | 363 | 225 | 34.89246 | 133.826252 | 2020-12-01 05:26:18 | Okayama, Japan | ||
1836953 | 1836953 | 2020-06-14 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-15 03:33:14 | Basilicata, Italy | ||
1837445 | 1837445 | 2020-06-14 | Central African Republic | 2057 | 7 | 363 | 1687 | 6.6111 | 20.9394 | 2020-06-15 03:33:14 | Central African Republic | |||
1920293 | 1920293 | 2020-08-10 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-11 04:35:08 | Fujian, China | ||
1928280 | 1928280 | 2020-07-30 | China | Fujian | 366 | 1 | 363 | 2 | 26.0789 | 117.9874 | 2020-07-31 04:35:18 | Fujian, China | ||
2008341 | 2008341 | 2021-05-12 | Malaysia | Perlis | 382 | 3 | 363 | 16 | 6.4449 | 100.2048 | 2021-05-13 04:20:51 | Perlis, Malaysia | ||
2223179 | 2223179 | 2020-07-08 | Malaysia | Sabah | 379 | 7 | 363 | 9 | 5.9788 | 116.0753 | 2020-07-09 04:34:23 | Sabah, Malaysia | ||
2537425 | 2537425 | 2020-12-01 | Japan | Okayama | 609 | 11 | 363 | 235 | 34.89246 | 133.826252 | 2020-12-02 05:27:41 | Okayama, Japan | ||
2537440 | 2537440 | 2020-12-01 | Japan | Wakayama | 462 | 6 | 363 | 93 | 33.911879 | 135.505446 | 2020-12-02 05:27:41 | Wakayama, Japan | ||
2677866 | 2677866 | 2021-02-13 | Japan | Tokushima | 424 | 15 | 363 | 46 | 33.919178 | 134.242091 | 2021-02-14 05:23:43 | Tokushima, Japan | ||
2701319 | 2701319 | 2020-11-20 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-21 05:25:51 | Hebei, China | ||
2740088 | 2740088 | 2020-08-03 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-04 04:41:59 | Fujian, China | ||
2807840 | 2807840 | 2020-08-02 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-03 04:34:35 | Fujian, China | ||
2899351 | 2899351 | 2020-05-09 | Malaysia | Sarawak | 542 | 17 | 363 | 162 | 1.5533 | 110.3592 | 2020-05-10 02:32:30 | Sarawak, Malaysia | ||
2935002 | 2935002 | 2020-11-28 | Canada | New Brunswick | 481 | 7 | 363 | 111 | 46.5653 | -66.4619 | 2020-11-29 05:25:55 | New Brunswick, Canada | ||
2935262 | 2935262 | 2020-11-28 | Japan | Okayama | 583 | 11 | 363 | 209 | 34.89246 | 133.826252 | 2020-11-29 05:25:55 | Okayama, Japan | ||
3061005 | 3061005 | 2020-06-13 | Italy | Basilicata | 401 | 27 | 363 | 11 | 40.63947052 | 15.80514834 | 2020-06-14 03:33:15 | Basilicata, Italy | ||
3061497 | 3061497 | 2020-06-13 | Central African Republic | 2057 | 7 | 363 | 1687 | 6.6111 | 20.9394 | 2020-06-14 03:33:15 | Central African Republic | |||
3169446 | 3169446 | 2020-11-16 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-17 05:25:54 | Hebei, China | ||
3178021 | 3178021 | 2020-08-18 | Japan | Ibaraki | 463 | 10 | 363 | 90 | 36.303588 | 140.319591 | 2020-08-19 04:27:00 | Ibaraki, Japan | ||
3264573 | 3264573 | 2020-07-31 | China | Fujian | 366 | 1 | 363 | 2 | 26.0789 | 117.9874 | 2020-08-01 04:36:27 | Fujian, China | ||
3338401 | 3338401 | 2020-11-17 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-18 05:40:31 | Hebei, China | ||
3566597 | 3566597 | 2020-11-29 | Japan | Okayama | 592 | 11 | 363 | 218 | 34.89246 | 133.826252 | 2020-11-30 05:26:13 | Okayama, Japan | ||
3612139 | 3612139 | 2020-08-06 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-07 04:35:11 | Fujian, China | ||
3655243 | 3655243 | 2020-10-24 | Malaysia | Perak | 458 | 7 | 363 | 88 | 4.5921 | 101.0901 | 2020-10-25 04:24:36 | Perak, Malaysia | ||
3761355 | 3761355 | 2020-12-28 | Canada | Newfoundland and Labrador | 389 | 4 | 363 | 22 | 53.1355 | -57.6604 | 2020-12-29 05:22:37 | Newfoundland and Labrador, Canada | ||
3792969 | 3792969 | 2020-08-05 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-06 04:35:02 | Fujian, China | ||
3805538 | 3805538 | 2020-10-05 | United Kingdom | Gibraltar | 432 | 0 | 363 | 69 | 36.1408 | -5.3536 | 2020-10-06 04:23:33 | Gibraltar, United Kingdom | ||
3836291 | 3836291 | 2020-11-21 | China | Hebei | 373 | 6 | 363 | 4 | 37.8957 | 114.9042 | 2020-11-22 05:25:45 | Hebei, China | ||
3923102 | 3923102 | 2020-08-09 | China | Fujian | 367 | 1 | 363 | 3 | 26.0789 | 117.9874 | 2020-08-10 04:34:55 | Fujian, China | ||
15990 | 15990 | 2021-01-26 | United Kingdom | Isle of Man | 432 | 25 | 364 | 43 | 54.2361 | -4.5481 | 2021-01-27 05:23:41 | Isle of Man, United Kingdom | ||
137548 | 137548 | 2020-04-29 | Oman | 2274 | 10 | 364 | 1900 | 21.512583 | 55.92325500000001 | 2020-04-30 02:32:27 | Oman | |||
228869 | 228869 | 2020-04-30 | Malaysia | Negeri Sembilan | 514 | 7 | 364 | 143 | 2.7258 | 101.9424 | 2020-05-01 02:32:28 | Negeri Sembilan, Malaysia | ||
271762 | 271762 | 2020-04-28 | Oman | 2131 | 10 | 364 | 1757 | 21.512583 | 55.92325500000001 | 2020-04-29 02:32:29 | Oman | |||
546796 | 546796 | 2020-09-12 | Japan | Toyama | 408 | 25 | 364 | 19 | 36.637464 | 137.26934599999998 | 2020-09-13 04:30:52 | Toyama, Japan | ||
762386 | 762386 | 2020-10-18 | Mauritius | 407 | 10 | 364 | 43 | -20.348404 | 57.552152 | 2020-10-19 04:24:16 | Mauritius | |||
766091 | 766091 | 2020-12-29 | Canada | Newfoundland and Labrador | 390 | 4 | 364 | 22 | 53.1355 | -57.6604 | 2020-12-30 05:22:34 | Newfoundland and Labrador, Canada | ||
778032 | 778032 | 2021-01-12 | Malaysia | Terengganu | 547 | 1 | 364 | 182 | 5.3117 | 103.1324 | 2021-01-13 05:22:15 | Terengganu, Malaysia | ||
786449 | 786449 | 2020-10-15 | Mauritius | 407 | 10 | 364 | 41 | -20.348404 | 57.552152 | 2020-10-16 04:24:01 | Mauritius | |||
817454 | 817454 | 2020-10-09 | Eritrea | 405 | 0 | 364 | 41 | 15.1794 | 39.7823 | 2020-10-10 04:23:57 | Eritrea | |||
1005964 | 1005964 | 2020-07-09 | Malaysia | Sabah | 379 | 7 | 364 | 8 | 5.9788 | 116.0753 | 2020-07-10 04:34:24 | Sabah, Malaysia | ||
1026424 | 1026424 | 2020-10-17 | Mauritius | 407 | 10 | 364 | 43 | -20.348404 | 57.552152 | 2020-10-18 04:24:25 | Mauritius | |||
1173007 | 1173007 | 2020-09-10 | China | Shaanxi | 379 | 3 | 364 | 12 | 35.1917 | 108.8701 | 2020-09-11 04:46:23 | Shaanxi, China | ||
1184282 | 1184282 | 2020-05-01 | Jordan | 459 | 8 | 364 | 87 | 31.24 | 36.51 | 2020-05-02 02:32:27 | Jordan | |||
1192450 | 1192450 | 2020-02-14 | Mainland China | Hunan | 988 | 2 | 364 | 27.6104 | 111.7088 | 2020-02-14T09:23:04 | ||||
1195676 | 1195676 | 2020-06-17 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-18 04:33:18 | Basilicata, Italy | ||
1444604 | 1444604 | 2020-09-11 | Japan | Mie | 455 | 5 | 364 | 86 | 34.508018 | 136.376013 | 2020-09-12 04:25:05 | Mie, Japan | ||
1762946 | 1762946 | 2021-01-24 | United Kingdom | Isle of Man | 432 | 25 | 364 | 43 | 54.2361 | -4.5481 | 2021-01-25 05:22:16 | Isle of Man, United Kingdom | ||
1892971 | 1892971 | 2021-06-30 | China | Yunnan | 419 | 2 | 364 | 53 | 24.974 | 101.487 | 2021-07-01 04:21:19 | Yunnan, China | ||
1920829 | 1920829 | 2020-08-10 | Syria | 1255 | 52 | 364 | 839 | 34.802075 | 38.99681500000001 | 2020-08-11 04:35:08 | Syria | |||
2171372 | 2171372 | 2020-09-09 | China | Shaanxi | 378 | 3 | 364 | 11 | 35.1917 | 108.8701 | 2020-09-10 04:29:01 | Shaanxi, China | ||
2283466 | 2283466 | 2021-02-14 | Japan | Tokushima | 426 | 15 | 364 | 47 | 33.919178 | 134.242091 | 2021-02-15 05:24:49 | Tokushima, Japan | ||
2386439 | 2386439 | 2020-06-16 | Italy | Basilicata | 401 | 27 | 364 | 10 | 40.63947052 | 15.80514834 | 2020-06-17 04:33:21 | Basilicata, Italy | ||
2430553 | 2430553 | 2021-01-23 | United Kingdom | Isle of Man | 432 | 25 | 364 | 43 | 54.2361 | -4.5481 | 2021-01-24 05:22:35 | Isle of Man, United Kingdom | ||
2571314 | 2571314 | 2021-01-25 | United Kingdom | Isle of Man | 432 | 25 | 364 | 43 | 54.2361 | -4.5481 | 2021-01-26 05:22:02 | Isle of Man, United Kingdom | ||
2685040 | 2685040 | 2020-07-06 | Russia | Sakhalin Oblast | 993 | 0 | 364 | 629 | 49.7219665 | 143.448533 | 2020-07-07 04:34:00 | Sakhalin Oblast, Russia | ||
2689569 | 2689569 | 2020-10-08 | Eritrea | 405 | 0 | 364 | 41 | 15.1794 | 39.7823 | 2020-10-09 04:23:59 | Eritrea | |||
2764763 | 2764763 | 2021-07-01 | China | Yunnan | 419 | 2 | 364 | 53 | 24.974 | 101.487 | 2021-07-02 04:21:47 | Yunnan, China | ||
2856919 | 2856919 | 2020-10-16 | Mauritius | 407 | 10 | 364 | 43 | -20.348404 | 57.552152 | 2020-10-17 04:24:12 | Mauritius |
Advanced export
JSON shape: default, array, newline-delimited
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]);