johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
794 rows where active = 244 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3471812 | 3471812 | 2021-08-03 | Ukraine | Mykolaiv Oblast | 70447 | 1867 | 68336 | 244 | 46.975 | 31.9946 | 2021-08-04 04:21:25 | Mykolaiv Oblast, Ukraine | ||
411931 | 411931 | 2021-07-28 | Ukraine | Poltava Oblast | 78244 | 1872 | 76128 | 244 | 49.5883 | 34.5514 | 2021-07-29 04:21:33 | Poltava Oblast, Ukraine | ||
2371345 | 2371345 | 2021-07-20 | Colombia | Arauca | 12051 | 381 | 11426 | 244 | 7.0762 | -70.7105 | 2021-07-21 04:21:40 | Arauca, Colombia | ||
483629 | 483629 | 2021-07-19 | Japan | Tochigi | 7420 | 83 | 7093 | 244 | 36.689912 | 139.819213 | 2021-07-20 04:21:48 | Tochigi, Japan | ||
3631647 | 3631647 | 2021-07-14 | Andorra | 14167 | 127 | 13796 | 244 | 42.5063 | 1.5218 | 2021-07-15 04:21:48 | Andorra | |||
578522 | 578522 | 2021-07-13 | Andorra | 14167 | 127 | 13796 | 244 | 42.5063 | 1.5218 | 2021-07-14 04:21:35 | Andorra | |||
1495555 | 1495555 | 2021-07-03 | India | Ladakh | 20115 | 202 | 19669 | 244 | 34.1526 | 77.5771 | 2021-07-04 04:21:38 | Ladakh, India | ||
3129149 | 3129149 | 2021-06-28 | Ukraine | Vinnytsia Oblast | 71076 | 1690 | 69142 | 244 | 49.2331 | 28.4682 | 2021-06-29 04:21:28 | Vinnytsia Oblast, Ukraine | ||
3030512 | 3030512 | 2021-06-16 | Russia | Mari El Republic | 13877 | 268 | 13365 | 244 | 56.5767504 | 47.8817512 | 2021-06-17 04:22:36 | Mari El Republic, Russia | ||
2586017 | 2586017 | 2021-06-05 | Japan | Oita | 3432 | 55 | 3133 | 244 | 33.200697 | 131.43323999999998 | 2021-06-06 04:24:03 | Oita, Japan | ||
1448784 | 1448784 | 2021-06-03 | Russia | Ingushetia Republic | 15807 | 190 | 15373 | 244 | 43.11542075 | 45.01713552 | 2021-06-04 04:23:37 | Ingushetia Republic, Russia | ||
2104152 | 2104152 | 2021-06-01 | Japan | Miyagi | 8874 | 83 | 8547 | 244 | 38.446859 | 140.927086 | 2021-06-02 04:24:34 | Miyagi, Japan | ||
2104148 | 2104148 | 2021-06-01 | Japan | Kochi | 1493 | 20 | 1229 | 244 | 33.422519 | 133.367307 | 2021-06-02 04:24:34 | Kochi, Japan | ||
1188770 | 1188770 | 2021-05-31 | Japan | Nagano | 4789 | 83 | 4462 | 244 | 36.132134 | 138.045528 | 2021-06-01 04:23:09 | Nagano, Japan | ||
1568315 | 1568315 | 2021-04-22 | Russia | Khakassia Republic | 22197 | 521 | 21432 | 244 | 53.72258845 | 91.44293627 | 2021-04-23 04:20:52 | Khakassia Republic, Russia | ||
3003343 | 3003343 | 2021-04-06 | Japan | Shizuoka | 5852 | 118 | 5490 | 244 | 34.916975 | 138.40778400000002 | 2021-04-07 04:20:53 | Shizuoka, Japan | ||
241531 | 241531 | 2021-04-02 | Singapore | 60450 | 30 | 60176 | 244 | 1.2833 | 103.8333 | 2021-04-03 04:20:44 | Singapore | |||
241035 | 241035 | 2021-04-02 | Chad | 4573 | 164 | 4165 | 244 | 15.4542 | 18.7322 | 2021-04-03 04:20:44 | Chad | |||
1223246 | 1223246 | 2021-03-27 | Malaysia | Pahang | 4180 | 17 | 3919 | 244 | 3.8126 | 103.3256 | 2021-03-28 05:28:10 | Pahang, Malaysia | ||
2055762 | 2055762 | 2021-03-15 | Djibouti | 6294 | 63 | 5987 | 244 | 11.8251 | 42.5903 | 2021-03-16 05:25:13 | Djibouti | |||
2359602 | 2359602 | 2021-03-08 | Niger | 4828 | 177 | 4407 | 244 | 17.607789 | 8.081666 | 2021-03-09 05:28:19 | Niger | |||
1092466 | 1092466 | 2021-03-03 | US | North Dakota | Golden Valley | 38033 | 247 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-03-04 05:24:24 | Golden Valley, North Dakota, US |
3256538 | 3256538 | 2021-03-02 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-03-03 05:23:28 | Golden Valley, North Dakota, US |
3256221 | 3256221 | 2021-03-02 | US | Nebraska | Hitchcock | 31087 | 248 | 4 | 0 | 244 | 40.17609175 | -101.0416477 | 2021-03-03 05:23:28 | Hitchcock, Nebraska, US |
1000830 | 1000830 | 2021-03-01 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-03-02 05:23:30 | Golden Valley, North Dakota, US |
1000513 | 1000513 | 2021-03-01 | US | Nebraska | Hitchcock | 31087 | 248 | 4 | 0 | 244 | 40.17609175 | -101.0416477 | 2021-03-02 05:23:30 | Hitchcock, Nebraska, US |
2369888 | 2369888 | 2021-02-28 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-03-01 05:23:01 | Golden Valley, North Dakota, US |
2369571 | 2369571 | 2021-02-28 | US | Nebraska | Hitchcock | 31087 | 248 | 4 | 0 | 244 | 40.17609175 | -101.0416477 | 2021-03-01 05:23:01 | Hitchcock, Nebraska, US |
3068390 | 3068390 | 2021-02-27 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-02-28 05:22:20 | Golden Valley, North Dakota, US |
3065849 | 3065849 | 2021-02-27 | Colombia | La Guajira | 16131 | 634 | 15253 | 244 | 11.3548 | -72.5205 | 2021-02-28 05:22:20 | La Guajira, Colombia | ||
2185974 | 2185974 | 2021-02-26 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-02-27 05:22:28 | Golden Valley, North Dakota, US |
2185657 | 2185657 | 2021-02-26 | US | Nebraska | Hitchcock | 31087 | 248 | 4 | 0 | 244 | 40.17609175 | -101.0416477 | 2021-02-27 05:22:28 | Hitchcock, Nebraska, US |
1860748 | 1860748 | 2021-02-25 | US | Puerto Rico | Lajas | 72079 | 244 | 0 | 0 | 244 | 18.011661 | -67.040585 | 2021-02-26 05:22:40 | Lajas, Puerto Rico, US |
1860396 | 1860396 | 2021-02-25 | US | North Dakota | Golden Valley | 38033 | 246 | 2 | 0 | 244 | 46.94022281 | -103.8465421 | 2021-02-26 05:22:40 | Golden Valley, North Dakota, US |
1860079 | 1860079 | 2021-02-25 | US | Nebraska | Hitchcock | 31087 | 248 | 4 | 0 | 244 | 40.17609175 | -101.0416477 | 2021-02-26 05:22:40 | Hitchcock, Nebraska, US |
1857953 | 1857953 | 2021-02-25 | India | Himachal Pradesh | 58499 | 995 | 57260 | 244 | 31.927213 | 77.233081 | 2021-02-26 05:22:40 | Himachal Pradesh, India | ||
283066 | 283066 | 2021-02-24 | US | South Dakota | Mellette | 46095 | 246 | 2 | 0 | 244 | 43.58078848 | -100.7563186 | 2021-02-25 05:24:57 | Mellette, South Dakota, US |
282926 | 282926 | 2021-02-24 | US | Puerto Rico | Lajas | 72079 | 244 | 0 | 0 | 244 | 18.011661 | -67.040585 | 2021-02-25 05:24:57 | Lajas, Puerto Rico, US |
280081 | 280081 | 2021-02-24 | France | Reunion | 11562 | 48 | 11270 | 244 | -21.1151 | 55.5364 | 2021-02-25 05:24:57 | Reunion, France | ||
1939194 | 1939194 | 2021-02-23 | US | Puerto Rico | Lajas | 72079 | 244 | 0 | 0 | 244 | 18.011661 | -67.040585 | 2021-02-24 05:29:16 | Lajas, Puerto Rico, US |
1937763 | 1937763 | 2021-02-23 | US | Kansas | Morton | 20129 | 252 | 8 | 0 | 244 | 37.19141121 | -101.79925190000002 | 2021-02-24 05:29:16 | Morton, Kansas, US |
533449 | 533449 | 2021-02-22 | US | Puerto Rico | Lajas | 72079 | 244 | 0 | 0 | 244 | 18.011661 | -67.040585 | 2021-02-23 05:23:41 | Lajas, Puerto Rico, US |
532259 | 532259 | 2021-02-22 | US | Maine | Piscataquis | 23021 | 245 | 1 | 0 | 244 | 45.83839062 | -69.2860223 | 2021-02-23 05:23:41 | Piscataquis, Maine, US |
532018 | 532018 | 2021-02-22 | US | Kansas | Morton | 20129 | 252 | 8 | 0 | 244 | 37.19141121 | -101.79925190000002 | 2021-02-23 05:23:41 | Morton, Kansas, US |
531340 | 531340 | 2021-02-22 | US | Colorado | Ouray | 8091 | 260 | 3 | 0 | 244 | 38.14717457 | -107.7675136 | 2021-02-23 05:23:41 | Ouray, Colorado, US |
530572 | 530572 | 2021-02-22 | Comoros | 3518 | 144 | 3130 | 244 | -11.6455 | 43.3333 | 2021-02-23 05:23:41 | Comoros | |||
184783 | 184783 | 2021-02-21 | US | Puerto Rico | Lajas | 72079 | 244 | 0 | 0 | 244 | 18.011661 | -67.040585 | 2021-02-22 05:24:21 | Lajas, Puerto Rico, US |
183352 | 183352 | 2021-02-21 | US | Kansas | Morton | 20129 | 252 | 8 | 0 | 244 | 37.19141121 | -101.79925190000002 | 2021-02-22 05:24:21 | Morton, Kansas, US |
182674 | 182674 | 2021-02-21 | US | Colorado | Ouray | 8091 | 259 | 3 | 0 | 244 | 38.14717457 | -107.7675136 | 2021-02-22 05:24:21 | Ouray, Colorado, US |
744710 | 744710 | 2021-02-20 | US | North Dakota | Kidder | 38043 | 256 | 10 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-21 05:24:33 | Kidder, North Dakota, US |
743626 | 743626 | 2021-02-20 | US | Kansas | Morton | 20129 | 252 | 8 | 0 | 244 | 37.19141121 | -101.79925190000002 | 2021-02-21 05:24:33 | Morton, Kansas, US |
472724 | 472724 | 2021-02-19 | US | Kansas | Morton | 20129 | 252 | 8 | 0 | 244 | 37.19141121 | -101.79925190000002 | 2021-02-20 05:22:51 | Morton, Kansas, US |
1154378 | 1154378 | 2021-02-18 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-19 05:24:16 | Chautauqua, Kansas, US |
3602298 | 3602298 | 2021-02-17 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-18 05:22:58 | Chautauqua, Kansas, US |
3051433 | 3051433 | 2021-02-16 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-17 05:23:10 | Chautauqua, Kansas, US |
1339532 | 1339532 | 2021-02-15 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-16 05:24:38 | Chautauqua, Kansas, US |
2284683 | 2284683 | 2021-02-14 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-15 05:24:49 | Chautauqua, Kansas, US |
2679083 | 2679083 | 2021-02-13 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-14 05:23:43 | Chautauqua, Kansas, US |
3542105 | 3542105 | 2021-02-12 | US | Pennsylvania | Cameron | 42023 | 251 | 7 | 0 | 244 | 41.43625568 | -78.20376845 | 2021-02-13 05:22:12 | Cameron, Pennsylvania, US |
3540716 | 3540716 | 2021-02-12 | US | Kansas | Chautauqua | 20019 | 250 | 6 | 0 | 244 | 37.14994405 | -96.2454192 | 2021-02-13 05:22:12 | Chautauqua, Kansas, US |
1530293 | 1530293 | 2021-02-09 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-10 05:22:41 | Kidder, North Dakota, US |
616084 | 616084 | 2021-02-08 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-09 05:23:30 | Kidder, North Dakota, US |
1674853 | 1674853 | 2021-02-07 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-08 05:22:39 | Kidder, North Dakota, US |
977314 | 977314 | 2021-02-06 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-07 05:23:00 | Kidder, North Dakota, US |
1590572 | 1590572 | 2021-02-05 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-06 05:23:55 | Kidder, North Dakota, US |
1588104 | 1588104 | 2021-02-05 | Guinea | 14629 | 84 | 14301 | 244 | 9.9456 | -9.6966 | 2021-02-06 05:23:55 | Guinea | |||
793832 | 793832 | 2021-02-04 | US | Washington | Skamania | 53059 | 245 | 1 | 0 | 244 | 46.02408726 | -121.9164403 | 2021-02-05 05:22:38 | Skamania, Washington, US |
792779 | 792779 | 2021-02-04 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-05 05:22:38 | Kidder, North Dakota, US |
790311 | 790311 | 2021-02-04 | Guinea | 14629 | 84 | 14301 | 244 | 9.9456 | -9.6966 | 2021-02-05 05:22:38 | Guinea | |||
343724 | 343724 | 2021-02-03 | US | Washington | Skamania | 53059 | 245 | 1 | 0 | 244 | 46.02408726 | -121.9164403 | 2021-02-04 05:22:26 | Skamania, Washington, US |
342671 | 342671 | 2021-02-03 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-04 05:22:26 | Kidder, North Dakota, US |
340203 | 340203 | 2021-02-03 | Guinea | 14555 | 83 | 14228 | 244 | 9.9456 | -9.6966 | 2021-02-04 05:22:26 | Guinea | |||
1687950 | 1687950 | 2021-02-02 | US | Washington | Skamania | 53059 | 245 | 1 | 0 | 244 | 46.02408726 | -121.9164403 | 2021-02-03 05:22:52 | Skamania, Washington, US |
1686897 | 1686897 | 2021-02-02 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-03 05:22:52 | Kidder, North Dakota, US |
1684527 | 1684527 | 2021-02-02 | Japan | Nagasaki | 1537 | 31 | 1262 | 244 | 33.235712 | 129.608033 | 2021-02-03 05:22:52 | Nagasaki, Japan | ||
1684429 | 1684429 | 2021-02-02 | Guinea | 14555 | 83 | 14228 | 244 | 9.9456 | -9.6966 | 2021-02-03 05:22:52 | Guinea | |||
1678867 | 1678867 | 2021-02-01 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-02 05:22:49 | Kidder, North Dakota, US |
1676399 | 1676399 | 2021-02-01 | Guinea | 14555 | 83 | 14228 | 244 | 9.9456 | -9.6966 | 2021-02-02 05:22:49 | Guinea | |||
1462155 | 1462155 | 2021-01-31 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-02-01 05:22:53 | Kidder, North Dakota, US |
1461059 | 1461059 | 2021-01-31 | US | Kansas | Lincoln | 20105 | 248 | 4 | 0 | 244 | 39.04549684 | -98.20756994 | 2021-02-01 05:22:53 | Lincoln, Kansas, US |
2214388 | 2214388 | 2021-01-30 | US | Puerto Rico | Ceiba | 72037 | 244 | 0 | 0 | 244 | 18.251818 | -65.666416 | 2021-01-31 05:22:42 | Ceiba, Puerto Rico, US |
2214063 | 2214063 | 2021-01-30 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-31 05:22:42 | Kidder, North Dakota, US |
2212967 | 2212967 | 2021-01-30 | US | Kansas | Lincoln | 20105 | 248 | 4 | 0 | 244 | 39.04549684 | -98.20756994 | 2021-01-31 05:22:42 | Lincoln, Kansas, US |
1899875 | 1899875 | 2021-01-29 | US | Puerto Rico | Ceiba | 72037 | 244 | 0 | 0 | 244 | 18.251818 | -65.666416 | 2021-01-30 05:22:49 | Ceiba, Puerto Rico, US |
1899550 | 1899550 | 2021-01-29 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-30 05:22:49 | Kidder, North Dakota, US |
1898830 | 1898830 | 2021-01-29 | US | Michigan | Schoolcraft | 26153 | 249 | 5 | 0 | 244 | 46.19235734 | -86.19972234 | 2021-01-30 05:22:49 | Schoolcraft, Michigan, US |
1898454 | 1898454 | 2021-01-29 | US | Kansas | Lincoln | 20105 | 248 | 4 | 0 | 244 | 39.04549684 | -98.20756994 | 2021-01-30 05:22:49 | Lincoln, Kansas, US |
2484366 | 2484366 | 2021-01-28 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-29 05:22:23 | Kidder, North Dakota, US |
2483646 | 2483646 | 2021-01-28 | US | Michigan | Schoolcraft | 26153 | 249 | 5 | 0 | 244 | 46.19235734 | -86.19972234 | 2021-01-29 05:22:23 | Schoolcraft, Michigan, US |
2483310 | 2483310 | 2021-01-28 | US | Kansas | Smith | 20183 | 246 | 2 | 0 | 244 | 39.78516566 | -98.78566062 | 2021-01-29 05:22:23 | Smith, Kansas, US |
3156957 | 3156957 | 2021-01-27 | US | Virginia | King and Queen | 51097 | 247 | 3 | 0 | 244 | 37.71044922 | -76.88689628 | 2021-01-28 05:22:24 | King and Queen, Virginia, US |
3156001 | 3156001 | 2021-01-27 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-28 05:22:24 | Kidder, North Dakota, US |
3155281 | 3155281 | 2021-01-27 | US | Michigan | Schoolcraft | 26153 | 249 | 5 | 0 | 244 | 46.19235734 | -86.19972234 | 2021-01-28 05:22:24 | Schoolcraft, Michigan, US |
3154945 | 3154945 | 2021-01-27 | US | Kansas | Smith | 20183 | 246 | 2 | 0 | 244 | 39.78516566 | -98.78566062 | 2021-01-28 05:22:24 | Smith, Kansas, US |
14736 | 14736 | 2021-01-26 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-27 05:23:41 | Kidder, North Dakota, US |
14702 | 14702 | 2021-01-26 | US | North Carolina | Tyrrell | 37177 | 250 | 6 | 0 | 244 | 35.87147226 | -76.17055253 | 2021-01-27 05:23:41 | Tyrrell, North Carolina, US |
14016 | 14016 | 2021-01-26 | US | Michigan | Schoolcraft | 26153 | 249 | 5 | 0 | 244 | 46.19235734 | -86.19972234 | 2021-01-27 05:23:41 | Schoolcraft, Michigan, US |
2570060 | 2570060 | 2021-01-25 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-26 05:22:02 | Kidder, North Dakota, US |
2569340 | 2569340 | 2021-01-25 | US | Michigan | Schoolcraft | 26153 | 249 | 5 | 0 | 244 | 46.19235734 | -86.19972234 | 2021-01-26 05:22:02 | Schoolcraft, Michigan, US |
1761692 | 1761692 | 2021-01-24 | US | North Dakota | Kidder | 38043 | 253 | 9 | 0 | 244 | 46.97830064 | -99.77507857 | 2021-01-25 05:22:16 | Kidder, North Dakota, 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]);