johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
717 rows where active = 262 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299815 | 3299815 | 2021-07-30 | Ukraine | Poltava Oblast | 78277 | 1872 | 76143 | 262 | 49.5883 | 34.5514 | 2021-07-31 04:21:35 | Poltava Oblast, Ukraine | ||
3385412 | 3385412 | 2021-07-29 | Japan | Miyagi | 9791 | 91 | 9438 | 262 | 38.446859 | 140.927086 | 2021-07-30 04:21:34 | Miyagi, Japan | ||
3218494 | 3218494 | 2021-07-26 | Russia | Chukotka Autonomous Okrug | 1091 | 9 | 820 | 262 | 66.0006475 | 169.4900869 | 2021-07-27 04:21:18 | Chukotka Autonomous Okrug, Russia | ||
1382153 | 1382153 | 2021-07-25 | Ukraine | Zhytomyr Oblast | 88723 | 1802 | 86659 | 262 | 50.2547 | 28.6587 | 2021-07-26 04:21:28 | Zhytomyr Oblast, Ukraine | ||
3335175 | 3335175 | 2021-07-21 | Ukraine | Zaporizhia Oblast | 104948 | 2451 | 102235 | 262 | 47.8388 | 35.1396 | 2021-07-22 04:21:19 | Zaporizhia Oblast, Ukraine | ||
2375144 | 2375144 | 2021-07-20 | Ukraine | Luhansk Oblast | 26878 | 961 | 25655 | 262 | 48.574 | 39.3078 | 2021-07-21 04:21:40 | Luhansk Oblast, Ukraine | ||
483367 | 483367 | 2021-07-19 | Canada | Saskatchewan | 49450 | 575 | 48613 | 262 | 52.9399 | -106.4509 | 2021-07-20 04:21:48 | Saskatchewan, Canada | ||
2947151 | 2947151 | 2021-07-16 | Chile | Tarapaca | 39740 | 763 | 38715 | 262 | -19.9232 | -69.5132 | 2021-07-17 04:22:22 | Tarapaca, Chile | ||
3635594 | 3635594 | 2021-07-14 | Ukraine | Poltava Oblast | 78046 | 1868 | 75916 | 262 | 49.5883 | 34.5514 | 2021-07-15 04:21:48 | Poltava Oblast, Ukraine | ||
1168790 | 1168790 | 2021-07-04 | Ukraine | Chernivtsi Oblast | 79963 | 1793 | 77908 | 262 | 48.2917 | 25.9352 | 2021-07-05 04:21:28 | Chernivtsi Oblast, Ukraine | ||
2768574 | 2768574 | 2021-07-01 | Ukraine | Ternopil Oblast | 70027 | 1199 | 68566 | 262 | 49.5535 | 25.5948 | 2021-07-02 04:21:47 | Ternopil Oblast, Ukraine | ||
2764886 | 2764886 | 2021-07-01 | India | Ladakh | 20090 | 202 | 19626 | 262 | 34.1526 | 77.5771 | 2021-07-02 04:21:47 | Ladakh, India | ||
3129151 | 3129151 | 2021-06-28 | Ukraine | Zakarpattia Oblast | 62083 | 1603 | 60218 | 262 | 48.6208 | 22.2879 | 2021-06-29 04:21:28 | Zakarpattia Oblast, Ukraine | ||
2589890 | 2589890 | 2021-06-27 | Eswatini | 19035 | 678 | 18095 | 262 | -26.5225 | 31.4659 | 2021-06-28 04:21:29 | Eswatini | |||
3958394 | 3958394 | 2021-06-26 | Eswatini | 19018 | 678 | 18078 | 262 | -26.5225 | 31.4659 | 2021-06-27 04:21:39 | Eswatini | |||
3030201 | 3030201 | 2021-06-16 | Germany | Bremen | 27355 | 481 | 26620 | 262 | 53.0793 | 8.8017 | 2021-06-17 04:22:36 | Bremen, Germany | ||
2339435 | 2339435 | 2021-06-15 | Japan | Tochigi | 6713 | 80 | 6371 | 262 | 36.689912 | 139.819213 | 2021-06-16 04:22:32 | Tochigi, Japan | ||
3145628 | 3145628 | 2021-06-07 | Japan | Yamaguchi | 3000 | 68 | 2670 | 262 | 34.201190000000004 | 131.573293 | 2021-06-08 04:22:35 | Yamaguchi, Japan | ||
3145595 | 3145595 | 2021-06-07 | Japan | Ishikawa | 3843 | 109 | 3472 | 262 | 36.769464 | 136.771027 | 2021-06-08 04:22:35 | Ishikawa, Japan | ||
825592 | 825592 | 2021-06-06 | Japan | Gunma | 7917 | 144 | 7511 | 262 | 36.504479 | 138.985605 | 2021-06-07 04:22:51 | Gunma, Japan | ||
82965 | 82965 | 2021-05-25 | Cote d'Ivoire | 47036 | 298 | 46476 | 262 | 7.54 | -5.5471 | 2021-05-26 04:20:35 | Cote d'Ivoire | |||
2255603 | 2255603 | 2021-05-19 | Cote d'Ivoire | 46777 | 298 | 46217 | 262 | 7.54 | -5.5471 | 2021-05-20 04:21:05 | Cote d'Ivoire | |||
1301744 | 1301744 | 2021-04-01 | Antigua and Barbuda | 1147 | 28 | 857 | 262 | 17.0608 | -61.7964 | 2021-04-02 04:20:36 | Antigua and Barbuda | |||
638065 | 638065 | 2021-03-31 | Pakistan | Balochistan | 19576 | 208 | 19106 | 262 | 28.328492 | 65.898403 | 2021-04-01 04:27:05 | Balochistan, Pakistan | ||
3369401 | 3369401 | 2021-03-21 | Mauritania | 17601 | 446 | 16893 | 262 | 21.0079 | -10.9408 | 2021-03-22 05:25:43 | Mauritania | |||
1744438 | 1744438 | 2021-03-20 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-21 05:25:44 | Saint Barthelemy, France | ||
3420818 | 3420818 | 2021-03-19 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-20 05:25:46 | Saint Barthelemy, France | ||
3453066 | 3453066 | 2021-03-18 | Russia | Khakassia Republic | 21624 | 488 | 20874 | 262 | 53.72258845 | 91.44293627 | 2021-03-19 05:26:09 | Khakassia Republic, Russia | ||
3453048 | 3453048 | 2021-03-18 | Russia | Chechen Republic | 11509 | 115 | 11132 | 262 | 43.39761470000001 | 45.6985005 | 2021-03-19 05:26:09 | Chechen Republic, Russia | ||
3452864 | 3452864 | 2021-03-18 | Japan | Fukushima | 2253 | 99 | 1892 | 262 | 37.378867 | 140.223295 | 2021-03-19 05:26:09 | Fukushima, Japan | ||
3452756 | 3452756 | 2021-03-18 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-19 05:26:09 | Saint Barthelemy, France | ||
3620980 | 3620980 | 2021-03-17 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-18 05:26:22 | Saint Barthelemy, France | ||
702304 | 702304 | 2021-03-16 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-17 05:25:07 | Saint Barthelemy, France | ||
2055782 | 2055782 | 2021-03-15 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-16 05:25:13 | Saint Barthelemy, France | ||
1732394 | 1732394 | 2021-03-14 | France | Saint Barthelemy | 725 | 1 | 462 | 262 | 17.9 | -62.8333 | 2021-03-15 05:25:51 | Saint Barthelemy, France | ||
3668962 | 3668962 | 2021-03-06 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-07 05:21:54 | Smith, Kansas, US |
1617583 | 1617583 | 2021-03-05 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-06 04:23:41 | Smith, Kansas, US |
2208994 | 2208994 | 2021-03-04 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-05 05:26:29 | Smith, Kansas, US |
1092959 | 1092959 | 2021-03-03 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-03-04 05:24:24 | Miner, South Dakota, US |
1091415 | 1091415 | 2021-03-03 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-04 05:24:24 | Smith, Kansas, US |
3257031 | 3257031 | 2021-03-02 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-03-03 05:23:28 | Miner, South Dakota, US |
3255487 | 3255487 | 2021-03-02 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-03 05:23:28 | Smith, Kansas, US |
1001323 | 1001323 | 2021-03-01 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-03-02 05:23:30 | Miner, South Dakota, US |
999779 | 999779 | 2021-03-01 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-02 05:23:30 | Smith, Kansas, US |
2370381 | 2370381 | 2021-02-28 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-03-01 05:23:01 | Miner, South Dakota, US |
2368837 | 2368837 | 2021-02-28 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-03-01 05:23:01 | Smith, Kansas, US |
3068883 | 3068883 | 2021-02-27 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-28 05:22:20 | Miner, South Dakota, US |
3067339 | 3067339 | 2021-02-27 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-28 05:22:20 | Smith, Kansas, US |
2186467 | 2186467 | 2021-02-26 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-27 05:22:28 | Miner, South Dakota, US |
2184923 | 2184923 | 2021-02-26 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-27 05:22:28 | Smith, Kansas, US |
1860889 | 1860889 | 2021-02-25 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-26 05:22:40 | Miner, South Dakota, US |
1860380 | 1860380 | 2021-02-25 | US | North Dakota | Adams | 38001 | 266 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-26 05:22:40 | Adams, North Dakota, US |
1859345 | 1859345 | 2021-02-25 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-26 05:22:40 | Smith, Kansas, US |
283067 | 283067 | 2021-02-24 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-25 05:24:57 | Miner, South Dakota, US |
282558 | 282558 | 2021-02-24 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-25 05:24:57 | Adams, North Dakota, US |
281523 | 281523 | 2021-02-24 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-25 05:24:57 | Smith, Kansas, US |
1939335 | 1939335 | 2021-02-23 | US | South Dakota | Miner | 46097 | 271 | 9 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-24 05:29:16 | Miner, South Dakota, US |
1938826 | 1938826 | 2021-02-23 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-24 05:29:16 | Adams, North Dakota, US |
1937791 | 1937791 | 2021-02-23 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-24 05:29:16 | Smith, Kansas, US |
534374 | 534374 | 2021-02-22 | US | Alaska | Chugach | 2063 | 265 | 3 | 0 | 262 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
533316 | 533316 | 2021-02-22 | US | Oregon | Harney | 41025 | 268 | 6 | 0 | 262 | 43.06422669 | -118.9666306 | 2021-02-23 05:23:41 | Harney, Oregon, US |
533081 | 533081 | 2021-02-22 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-23 05:23:41 | Adams, North Dakota, US |
532046 | 532046 | 2021-02-22 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-23 05:23:41 | Smith, Kansas, US |
185708 | 185708 | 2021-02-21 | US | Alaska | Chugach | 2063 | 265 | 3 | 0 | 262 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
184911 | 184911 | 2021-02-21 | US | South Dakota | Jackson | 46071 | 276 | 14 | 0 | 262 | 43.69318385 | -101.6255063 | 2021-02-22 05:24:21 | Jackson, South Dakota, US |
184415 | 184415 | 2021-02-21 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-22 05:24:21 | Adams, North Dakota, US |
183380 | 183380 | 2021-02-21 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-22 05:24:21 | Smith, Kansas, US |
745982 | 745982 | 2021-02-20 | US | Alaska | Chugach | 2063 | 265 | 3 | 0 | 262 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
745185 | 745185 | 2021-02-20 | US | South Dakota | Jackson | 46071 | 276 | 14 | 0 | 262 | 43.69318385 | -101.6255063 | 2021-02-21 05:24:33 | Jackson, South Dakota, US |
744689 | 744689 | 2021-02-20 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-21 05:24:33 | Adams, North Dakota, US |
743654 | 743654 | 2021-02-20 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-21 05:24:33 | Smith, Kansas, US |
474283 | 474283 | 2021-02-19 | US | South Dakota | Jackson | 46071 | 276 | 14 | 0 | 262 | 43.69318385 | -101.6255063 | 2021-02-20 05:22:51 | Jackson, South Dakota, US |
473787 | 473787 | 2021-02-19 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-20 05:22:51 | Adams, North Dakota, US |
472752 | 472752 | 2021-02-19 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-20 05:22:51 | Smith, Kansas, US |
1155992 | 1155992 | 2021-02-18 | US | South Dakota | Jackson | 46071 | 276 | 14 | 0 | 262 | 43.69318385 | -101.6255063 | 2021-02-19 05:24:16 | Jackson, South Dakota, US |
1155496 | 1155496 | 2021-02-18 | US | North Dakota | Adams | 38001 | 265 | 3 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-19 05:24:16 | Adams, North Dakota, US |
1154461 | 1154461 | 2021-02-18 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-19 05:24:16 | Smith, Kansas, US |
3603762 | 3603762 | 2021-02-17 | US | Puerto Rico | Ceiba | 72037 | 262 | 0 | 0 | 262 | 18.251818 | -65.666416 | 2021-02-18 05:22:58 | Ceiba, Puerto Rico, US |
3602381 | 3602381 | 2021-02-17 | US | Kansas | Smith | 20183 | 264 | 2 | 0 | 262 | 39.78516566 | -98.78566062 | 2021-02-18 05:22:58 | Smith, Kansas, US |
3052897 | 3052897 | 2021-02-16 | US | Puerto Rico | Ceiba | 72037 | 262 | 0 | 0 | 262 | 18.251818 | -65.666416 | 2021-02-17 05:23:10 | Ceiba, Puerto Rico, US |
3541834 | 3541834 | 2021-02-12 | US | North Dakota | Adams | 38001 | 264 | 2 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-13 05:22:12 | Adams, North Dakota, US |
3980527 | 3980527 | 2021-02-10 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-11 05:23:55 | Schuyler, Missouri, US |
1530781 | 1530781 | 2021-02-09 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-10 05:22:41 | Miner, South Dakota, US |
1530272 | 1530272 | 2021-02-09 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-10 05:22:41 | Adams, North Dakota, US |
1529847 | 1529847 | 2021-02-09 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-10 05:22:41 | Schuyler, Missouri, US |
616572 | 616572 | 2021-02-08 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-09 05:23:30 | Miner, South Dakota, US |
616063 | 616063 | 2021-02-08 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-09 05:23:30 | Adams, North Dakota, US |
615638 | 615638 | 2021-02-08 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-09 05:23:30 | Schuyler, Missouri, US |
1675341 | 1675341 | 2021-02-07 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-08 05:22:39 | Miner, South Dakota, US |
1674832 | 1674832 | 2021-02-07 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-08 05:22:39 | Adams, North Dakota, US |
1674407 | 1674407 | 2021-02-07 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-08 05:22:39 | Schuyler, Missouri, US |
977802 | 977802 | 2021-02-06 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-07 05:23:00 | Miner, South Dakota, US |
977293 | 977293 | 2021-02-06 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 262 | 46.09686891 | -102.5285397 | 2021-02-07 05:23:00 | Adams, North Dakota, US |
976868 | 976868 | 2021-02-06 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-07 05:23:00 | Schuyler, Missouri, US |
1591060 | 1591060 | 2021-02-05 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-06 05:23:55 | Miner, South Dakota, US |
1590126 | 1590126 | 2021-02-05 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-06 05:23:55 | Schuyler, Missouri, US |
793267 | 793267 | 2021-02-04 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-05 05:22:38 | Miner, South Dakota, US |
792333 | 792333 | 2021-02-04 | US | Missouri | Schuyler | 29197 | 263 | 1 | 0 | 262 | 40.46921489 | -92.52311943 | 2021-02-05 05:22:38 | Schuyler, Missouri, US |
343159 | 343159 | 2021-02-03 | US | South Dakota | Miner | 46097 | 269 | 7 | 0 | 262 | 44.02197882 | -97.60992207 | 2021-02-04 05:22:26 | Miner, South Dakota, US |
342637 | 342637 | 2021-02-03 | US | North Carolina | Tyrrell | 37177 | 268 | 6 | 0 | 262 | 35.87147226 | -76.17055253 | 2021-02-04 05:22:26 | Tyrrell, North Carolina, US |
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]);