johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
315 rows where active = 740 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330194 | 1330194 | 2021-07-24 | India | Haryana | 769717 | 9617 | 759360 | 740 | 29.20004 | 76.332824 | 2021-07-25 04:22:12 | Haryana, India | ||
107696 | 107696 | 2021-06-19 | Russia | Sakhalin Oblast | 23801 | 56 | 23005 | 740 | 49.7219665 | 143.448533 | 2021-06-20 04:21:48 | Sakhalin Oblast, Russia | ||
107211 | 107211 | 2021-06-19 | Cabo Verde | 31964 | 281 | 30943 | 740 | 16.5388 | -23.0418 | 2021-06-20 04:21:48 | Cabo Verde | |||
3145522 | 3145522 | 2021-06-07 | India | Chandigarh | 60707 | 774 | 59193 | 740 | 30.733839 | 76.76827800000002 | 2021-06-08 04:22:35 | Chandigarh, India | ||
20058 | 20058 | 2021-05-28 | Albania | 132285 | 2448 | 129097 | 740 | 41.1533 | 20.1683 | 2021-05-29 04:20:41 | Albania | |||
1913068 | 1913068 | 2021-05-20 | Colombia | Quindio | 42302 | 1266 | 40296 | 740 | 4.461 | -75.6674 | 2021-05-21 04:20:43 | Quindio, Colombia | ||
2939110 | 2939110 | 2021-05-16 | Chile | Atacama | 19710 | 215 | 18755 | 740 | -27.5661 | -70.0503 | 2021-05-17 04:20:34 | Atacama, Chile | ||
954888 | 954888 | 2021-04-25 | Japan | Miyagi | 7901 | 60 | 7101 | 740 | 38.446859 | 140.927086 | 2021-04-26 04:21:04 | Miyagi, Japan | ||
982791 | 982791 | 2021-04-17 | Colombia | Cauca | 29150 | 793 | 27617 | 740 | 2.705 | -76.82600000000002 | 2021-04-18 04:20:41 | Cauca, Colombia | ||
3003141 | 3003141 | 2021-04-06 | Colombia | Bolivar | 70503 | 1417 | 68346 | 740 | 8.6704 | -74.03 | 2021-04-07 04:20:53 | Bolivar, Colombia | ||
1302122 | 1302122 | 2021-04-01 | Malta | 29085 | 394 | 27951 | 740 | 35.9375 | 14.3754 | 2021-04-02 04:20:36 | Malta | |||
3643763 | 3643763 | 2021-03-30 | Russia | Khanty-Mansi Autonomous Okrug | 54104 | 781 | 52583 | 740 | 61.0259025 | 69.0982628 | 2021-03-31 04:26:25 | Khanty-Mansi Autonomous Okrug, Russia | ||
3962313 | 3962313 | 2021-03-10 | Chile | Nuble | 18057 | 339 | 16978 | 740 | -36.7226 | -71.7622 | 2021-03-11 05:25:48 | Nuble, Chile | ||
3670930 | 3670930 | 2021-03-06 | US | Virginia | Charlotte | 51037 | 754 | 14 | 0 | 740 | 37.01909701 | -78.66314092 | 2021-03-07 05:21:54 | Charlotte, Virginia, US |
3670841 | 3670841 | 2021-03-06 | US | Texas | Swisher | 48437 | 903 | 17 | 0 | 740 | 34.53028891 | -101.7349174 | 2021-03-07 05:21:54 | Swisher, Texas, US |
1619462 | 1619462 | 2021-03-05 | US | Texas | Swisher | 48437 | 903 | 17 | 0 | 740 | 34.53028891 | -101.7349174 | 2021-03-06 04:23:41 | Swisher, Texas, US |
2209258 | 2209258 | 2021-03-04 | US | Michigan | Arenac | 26011 | 765 | 25 | 0 | 740 | 44.0636262 | -83.89277559 | 2021-03-05 05:26:29 | Arenac, Michigan, US |
2208827 | 2208827 | 2021-03-04 | US | Iowa | Davis | 19051 | 763 | 23 | 0 | 740 | 40.74773536 | -92.41005468 | 2021-03-05 05:26:29 | Davis, Iowa, US |
1091248 | 1091248 | 2021-03-03 | US | Iowa | Davis | 19051 | 763 | 23 | 0 | 740 | 40.74773536 | -92.41005468 | 2021-03-04 05:24:24 | Davis, Iowa, US |
3256999 | 3256999 | 2021-03-02 | US | South Dakota | Custer | 46033 | 752 | 12 | 0 | 740 | 43.67741105 | -103.4534521 | 2021-03-03 05:23:28 | Custer, South Dakota, US |
3256555 | 3256555 | 2021-03-02 | US | North Dakota | Pembina | 38067 | 749 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-03-03 05:23:28 | Pembina, North Dakota, US |
3255017 | 3255017 | 2021-03-02 | US | Georgia | Taylor | 13269 | 763 | 23 | 0 | 740 | 32.55792548 | -84.25077141 | 2021-03-03 05:23:28 | Taylor, Georgia, US |
1000847 | 1000847 | 2021-03-01 | US | North Dakota | Pembina | 38067 | 748 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-03-02 05:23:30 | Pembina, North Dakota, US |
998648 | 998648 | 2021-03-01 | Russia | Khakassia Republic | 21317 | 453 | 20124 | 740 | 53.72258845 | 91.44293627 | 2021-03-02 05:23:30 | Khakassia Republic, Russia | ||
2369905 | 2369905 | 2021-02-28 | US | North Dakota | Pembina | 38067 | 748 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-03-01 05:23:01 | Pembina, North Dakota, US |
3069311 | 3069311 | 2021-02-27 | US | Virginia | Clarke | 51043 | 757 | 17 | 0 | 740 | 39.11271747 | -77.99199425 | 2021-02-28 05:22:20 | Clarke, Virginia, US |
3068407 | 3068407 | 2021-02-27 | US | North Dakota | Pembina | 38067 | 748 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-02-28 05:22:20 | Pembina, North Dakota, US |
3067791 | 3067791 | 2021-02-27 | US | Mississippi | Franklin | 28037 | 759 | 19 | 0 | 740 | 31.47786634 | -90.89672989 | 2021-02-28 05:22:20 | Franklin, Mississippi, US |
3067423 | 3067423 | 2021-02-27 | US | Kentucky | Livingston | 21139 | 757 | 17 | 0 | 740 | 37.21137452 | -88.34797529 | 2021-02-28 05:22:20 | Livingston, Kentucky, US |
3066331 | 3066331 | 2021-02-27 | Thailand | 25881 | 83 | 25128 | 740 | 15.870032 | 100.992541 | 2021-02-28 05:22:20 | Thailand | |||
2185991 | 2185991 | 2021-02-26 | US | North Dakota | Pembina | 38067 | 748 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-02-27 05:22:28 | Pembina, North Dakota, US |
1861317 | 1861317 | 2021-02-25 | US | Virginia | Clarke | 51043 | 755 | 15 | 0 | 740 | 39.11271747 | -77.99199425 | 2021-02-26 05:22:40 | Clarke, Virginia, US |
1860413 | 1860413 | 2021-02-25 | US | North Dakota | Pembina | 38067 | 748 | 11 | 0 | 740 | 48.76623521 | -97.5523809 | 2021-02-26 05:22:40 | Pembina, North Dakota, US |
1859146 | 1859146 | 2021-02-25 | US | Indiana | Warren | 18171 | 752 | 12 | 0 | 740 | 40.34728141 | -87.35602659 | 2021-02-26 05:22:40 | Warren, Indiana, US |
745682 | 745682 | 2021-02-20 | US | Virginia | Nelson | 51125 | 747 | 7 | 0 | 740 | 37.78790447 | -78.88498513 | 2021-02-21 05:24:33 | Nelson, Virginia, US |
1154253 | 1154253 | 2021-02-18 | US | Indiana | Switzerland | 18155 | 747 | 7 | 0 | 740 | 38.82767338 | -85.03022429 | 2021-02-19 05:24:16 | Switzerland, Indiana, US |
3051006 | 3051006 | 2021-02-16 | US | Georgia | Macon | 13193 | 764 | 24 | 0 | 740 | 32.35207048 | -84.04234127 | 2021-02-17 05:23:10 | Macon, Georgia, US |
1340219 | 1340219 | 2021-02-15 | US | Missouri | Ralls | 29173 | 752 | 12 | 0 | 740 | 39.52817427 | -91.51838643 | 2021-02-16 05:24:38 | Ralls, Missouri, US |
1339105 | 1339105 | 2021-02-15 | US | Georgia | Macon | 13193 | 763 | 23 | 0 | 740 | 32.35207048 | -84.04234127 | 2021-02-16 05:24:38 | Macon, Georgia, US |
2285370 | 2285370 | 2021-02-14 | US | Missouri | Ralls | 29173 | 752 | 12 | 0 | 740 | 39.52817427 | -91.51838643 | 2021-02-15 05:24:49 | Ralls, Missouri, US |
2284256 | 2284256 | 2021-02-14 | US | Georgia | Macon | 13193 | 763 | 23 | 0 | 740 | 32.35207048 | -84.04234127 | 2021-02-15 05:24:49 | Macon, Georgia, US |
2679770 | 2679770 | 2021-02-13 | US | Missouri | Ralls | 29173 | 752 | 12 | 0 | 740 | 39.52817427 | -91.51838643 | 2021-02-14 05:23:43 | Ralls, Missouri, US |
2679716 | 2679716 | 2021-02-13 | US | Missouri | Douglas | 29067 | 763 | 23 | 0 | 740 | 36.9325593 | -92.49905109 | 2021-02-14 05:23:43 | Douglas, Missouri, US |
2678656 | 2678656 | 2021-02-13 | US | Georgia | Macon | 13193 | 763 | 23 | 0 | 740 | 32.35207048 | -84.04234127 | 2021-02-14 05:23:43 | Macon, Georgia, US |
2677787 | 2677787 | 2021-02-13 | India | Odisha | 336101 | 1910 | 333451 | 740 | 20.505428 | 84.418059 | 2021-02-14 05:23:43 | Odisha, India | ||
3541403 | 3541403 | 2021-02-12 | US | Missouri | Ralls | 29173 | 752 | 12 | 0 | 740 | 39.52817427 | -91.51838643 | 2021-02-13 05:22:12 | Ralls, Missouri, US |
1529158 | 1529158 | 2021-02-09 | US | Kansas | Clay | 20027 | 765 | 25 | 0 | 740 | 39.34948772 | -97.16518128 | 2021-02-10 05:22:41 | Clay, Kansas, US |
614949 | 614949 | 2021-02-08 | US | Kansas | Clay | 20027 | 765 | 25 | 0 | 740 | 39.34948772 | -97.16518128 | 2021-02-09 05:23:30 | Clay, Kansas, US |
614498 | 614498 | 2021-02-08 | US | Georgia | Heard | 13149 | 755 | 15 | 0 | 740 | 33.29686567 | -85.12886832 | 2021-02-09 05:23:30 | Heard, Georgia, US |
1673284 | 1673284 | 2021-02-07 | US | Georgia | Long | 13183 | 750 | 10 | 0 | 740 | 31.75218791 | -81.74952375 | 2021-02-08 05:22:39 | Long, Georgia, US |
1591045 | 1591045 | 2021-02-05 | US | South Dakota | Hutchinson | 46067 | 763 | 23 | 0 | 740 | 43.33449012 | -97.75536441 | 2021-02-06 05:23:55 | Hutchinson, South Dakota, US |
792984 | 792984 | 2021-02-04 | US | Oregon | Clatsop | 41007 | 745 | 5 | 0 | 740 | 45.99712889 | -123.660711 | 2021-02-05 05:22:38 | Clatsop, Oregon, US |
342876 | 342876 | 2021-02-03 | US | Oregon | Clatsop | 41007 | 745 | 5 | 0 | 740 | 45.99712889 | -123.660711 | 2021-02-04 05:22:26 | Clatsop, Oregon, US |
341258 | 341258 | 2021-02-03 | US | Illinois | Hamilton | 17065 | 754 | 14 | 0 | 740 | 38.08163641 | -88.53883373 | 2021-02-04 05:22:26 | Hamilton, Illinois, US |
1677480 | 1677480 | 2021-02-01 | US | Illinois | Marshall | 17123 | 753 | 13 | 0 | 740 | 41.0327901 | -89.34510444 | 2021-02-02 05:22:49 | Marshall, Illinois, US |
2212001 | 2212001 | 2021-01-30 | Togo | 5041 | 77 | 4224 | 740 | 8.6195 | 0.8248 | 2021-01-31 05:22:42 | Togo | |||
1898019 | 1898019 | 2021-01-29 | US | Georgia | Stewart | 13259 | 758 | 18 | 0 | 740 | 32.07996777 | -84.83208037 | 2021-01-30 05:22:49 | Stewart, Georgia, US |
2469814 | 2469814 | 2021-01-22 | US | Texas | Bailey | 48017 | 842 | 16 | 0 | 740 | 34.06854817 | -102.8299707 | 2021-01-23 05:22:03 | Bailey, Texas, US |
2468702 | 2468702 | 2021-01-22 | US | Missouri | Harrison | 29081 | 750 | 10 | 0 | 740 | 40.35570088 | -93.99222144 | 2021-01-23 05:22:03 | Harrison, Missouri, US |
3880470 | 3880470 | 2021-01-14 | US | Georgia | Wilkes | 13317 | 752 | 12 | 0 | 740 | 33.78290391 | -82.74286107 | 2021-01-15 05:22:24 | Wilkes, Georgia, US |
775104 | 775104 | 2021-01-12 | US | Georgia | Candler | 13043 | 777 | 37 | 0 | 740 | 32.40209349 | -82.07702563 | 2021-01-13 05:22:15 | Candler, Georgia, US |
2544799 | 2544799 | 2021-01-07 | US | Virginia | Rockbridge | 51163 | 747 | 7 | 0 | 740 | 37.81204314 | -79.44605905 | 2021-01-08 05:22:42 | Rockbridge, Virginia, US |
2543988 | 2543988 | 2021-01-07 | US | Oklahoma | Pushmataha | 40127 | 746 | 6 | 0 | 740 | 34.41635232 | -95.37603505 | 2021-01-08 05:22:42 | Pushmataha, Oklahoma, US |
2864898 | 2864898 | 2021-01-06 | Russia | Altai Republic | 14066 | 108 | 13218 | 740 | 50.7114101 | 86.8572186 | 2021-01-07 05:22:03 | Altai Republic, Russia | ||
3037040 | 3037040 | 2021-01-05 | US | Puerto Rico | Isabela | 72071 | 740 | 0 | 0 | 740 | 18.44981 | -67.005093 | 2021-01-06 05:22:16 | Isabela, Puerto Rico, US |
1064988 | 1064988 | 2021-01-04 | US | Texas | Lampasas | 48281 | 1107 | 15 | 0 | 740 | 31.19531316 | -98.24206613 | 2021-01-05 05:21:49 | Lampasas, Texas, US |
3233591 | 3233591 | 2021-01-03 | US | Texas | Lampasas | 48281 | 1107 | 15 | 0 | 740 | 31.19531316 | -98.24206613 | 2021-01-04 05:22:02 | Lampasas, Texas, US |
3232004 | 3232004 | 2021-01-03 | US | Maine | Somerset | 23025 | 761 | 21 | 0 | 740 | 45.51229767 | -69.95995554 | 2021-01-04 05:22:02 | Somerset, Maine, US |
1138727 | 1138727 | 2021-01-01 | US | Mississippi | Tunica | 28143 | 759 | 19 | 0 | 740 | 34.64967704 | -90.37481167 | 2021-01-02 05:22:33 | Tunica, Mississippi, US |
1138280 | 1138280 | 2021-01-01 | US | Kentucky | Green | 21087 | 750 | 10 | 0 | 740 | 37.26484328 | -85.5540745 | 2021-01-02 05:22:33 | Green, Kentucky, US |
1137082 | 1137082 | 2021-01-01 | Russia | Jewish Autonomous Okrug | 3765 | 72 | 2953 | 740 | 48.57527615 | 132.66307460000002 | 2021-01-02 05:22:33 | Jewish Autonomous Okrug, Russia | ||
3698727 | 3698727 | 2020-12-31 | US | Texas | Ward | 48475 | 675 | 9 | 0 | 740 | 31.50999644 | -103.0927909 | 2021-01-01 05:23:07 | Ward, Texas, US |
3696886 | 3696886 | 2020-12-31 | US | Kentucky | Green | 21087 | 750 | 10 | 0 | 740 | 37.26484328 | -85.5540745 | 2021-01-01 05:23:07 | Green, Kentucky, US |
1011701 | 1011701 | 2020-12-30 | US | Kentucky | Green | 21087 | 750 | 10 | 0 | 740 | 37.26484328 | -85.5540745 | 2020-12-31 05:22:49 | Green, Kentucky, US |
769570 | 769570 | 2020-12-29 | US | Texas | Yoakum | 48501 | 229 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-30 05:22:34 | Yoakum, Texas, US |
3764834 | 3764834 | 2020-12-28 | US | Texas | Yoakum | 48501 | 227 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-29 05:22:37 | Yoakum, Texas, US |
3781154 | 3781154 | 2020-12-27 | US | Texas | Yoakum | 48501 | 225 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-28 05:22:06 | Yoakum, Texas, US |
3778396 | 3778396 | 2020-12-27 | US | Arkansas | Little River | 5081 | 777 | 37 | 0 | 740 | 33.70375665 | -94.23468591 | 2020-12-28 05:22:06 | Little River, Arkansas, US |
2226759 | 2226759 | 2020-12-26 | US | Texas | Yoakum | 48501 | 224 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-27 05:22:55 | Yoakum, Texas, US |
205506 | 205506 | 2020-12-25 | US | Texas | Yoakum | 48501 | 224 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-26 05:22:28 | Yoakum, Texas, US |
3694729 | 3694729 | 2020-12-24 | US | Texas | Yoakum | 48501 | 223 | 19 | 0 | 740 | 33.17320212 | -102.8276433 | 2020-12-25 05:22:48 | Yoakum, Texas, US |
3770219 | 3770219 | 2020-12-22 | US | Alabama | Bullock | 1011 | 760 | 20 | 0 | 740 | 32.10030533 | -85.71265535 | 2020-12-23 05:22:03 | Bullock, Alabama, US |
930244 | 930244 | 2020-12-21 | US | Oklahoma | Johnston | 40069 | 745 | 5 | 0 | 740 | 34.31440473 | -96.66011537 | 2020-12-22 05:22:33 | Johnston, Oklahoma, US |
929985 | 929985 | 2020-12-21 | US | North Carolina | Chowan | 37041 | 759 | 19 | 0 | 740 | 36.12908077 | -76.60118385 | 2020-12-22 05:22:33 | Chowan, North Carolina, US |
2123305 | 2123305 | 2020-12-20 | US | Wyoming | Converse | 56009 | 750 | 10 | 0 | 740 | 42.97272268 | -105.5081848 | 2020-12-21 05:27:58 | Converse, Wyoming, US |
2122684 | 2122684 | 2020-12-20 | US | Tennessee | Perry | 47135 | 767 | 23 | 0 | 740 | 35.63708728 | -87.86139634 | 2020-12-21 05:27:58 | Perry, Tennessee, US |
2121118 | 2121118 | 2020-12-20 | US | Kentucky | Henry | 21103 | 743 | 3 | 0 | 740 | 38.44942688 | -85.11587507 | 2020-12-21 05:27:58 | Henry, Kentucky, US |
1904512 | 1904512 | 2020-12-18 | US | Virginia | Hopewell | 51670 | 749 | 9 | 0 | 740 | 37.29186313 | -77.29754684 | 2020-12-19 05:27:52 | Hopewell, Virginia, US |
1035793 | 1035793 | 2020-12-15 | US | Kentucky | Letcher | 21133 | 742 | 2 | 0 | 740 | 37.12306748 | -82.85346474 | 2020-12-16 05:28:04 | Letcher, Kentucky, US |
1034764 | 1034764 | 2020-12-15 | US | Alabama | Perry | 1105 | 749 | 9 | 0 | 740 | 32.64048341 | -87.29770589 | 2020-12-16 05:28:04 | Perry, Alabama, US |
1752901 | 1752901 | 2020-12-14 | US | Michigan | Iron | 26071 | 777 | 37 | 0 | 740 | 46.20974132 | -88.53136251 | 2020-12-15 05:26:38 | Iron, Michigan, US |
3850408 | 3850408 | 2020-12-13 | US | Oregon | Morrow | 41049 | 747 | 7 | 0 | 740 | 45.41846568 | -119.584546 | 2020-12-14 05:26:27 | Morrow, Oregon, US |
3848266 | 3848266 | 2020-12-13 | US | Arkansas | Grant | 5053 | 748 | 8 | 0 | 740 | 34.29017991 | -92.42320562 | 2020-12-14 05:26:27 | Grant, Arkansas, US |
847107 | 847107 | 2020-12-12 | US | Louisiana | West Carroll | 22123 | 763 | 23 | 0 | 740 | 32.78550125 | -91.461201 | 2020-12-13 05:27:20 | West Carroll, Louisiana, US |
862214 | 862214 | 2020-12-11 | US | Louisiana | West Carroll | 22123 | 763 | 23 | 0 | 740 | 32.78550125 | -91.461201 | 2020-12-12 05:26:19 | West Carroll, Louisiana, US |
1603472 | 1603472 | 2020-12-10 | US | Texas | Zavala | 48507 | 771 | 24 | 0 | 740 | 28.86617238 | -99.76050829 | 2020-12-11 05:26:59 | Zavala, Texas, US |
1603264 | 1603264 | 2020-12-10 | US | Texas | Comanche | 48093 | 740 | 11 | 0 | 740 | 31.94854689 | -98.55876441 | 2020-12-11 05:26:59 | Comanche, Texas, US |
2977527 | 2977527 | 2020-12-09 | US | North Carolina | Dare | 37055 | 744 | 4 | 0 | 740 | 35.66520691 | -75.71767334 | 2020-12-10 05:26:19 | Dare, North Carolina, US |
1009314 | 1009314 | 2020-12-06 | US | Texas | Brewster | 48043 | 575 | 6 | 0 | 740 | 29.81008251 | -103.2520326 | 2020-12-07 05:26:14 | Brewster, Texas, US |
1008147 | 1008147 | 2020-12-06 | US | Mississippi | Yalobusha | 28161 | 769 | 29 | 0 | 740 | 34.02824175 | -89.70762049999998 | 2020-12-07 05:26:14 | Yalobusha, Mississippi, 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]);