daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
530 rows where active = 381 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 445
- Japan 12
- Russia 12
- Ukraine 11
- Mexico 5
- India 4
- Malaysia 4
- Colombia 3
- Germany 3
- Sierra Leone 3
- Italy 2
- Malawi 2
- Sao Tome and Principe 2
- Andorra 1
- Angola 1
- Barbados 1
- Chile 1
- China 1
- Congo (Kinshasa) 1
- Cyprus 1
- Eswatini 1
- France 1
- Jamaica 1
- Kenya 1
- Libya 1
- Mauritania 1
- Mauritius 1
- Montenegro 1
- North Macedonia 1
- Rwanda 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-22 | Malaysia | W.P. Putrajaya | 5955 | 22 | 5552 | 381 | 2.9264 | 101.6964 | 2021-09-23 04:21:43 | W.P. Putrajaya, Malaysia | ||
2021-08-02 | Germany | Brandenburg | 109277 | 3818 | 105100 | 381 | 52.4125 | 12.5316 | 2021-08-03 04:21:39 | Brandenburg, Germany | ||
2021-08-01 | Italy | P.A. Trento | 46430 | 1363 | 44686 | 381 | 46.06893511 | 11.12123097 | 2021-08-02 04:21:36 | P.A. Trento, Italy | ||
2021-08-01 | China | Yunnan | 831 | 2 | 448 | 381 | 24.974 | 101.487 | 2021-08-02 04:21:36 | Yunnan, China | ||
2021-07-31 | Ukraine | Chernihiv Oblast | 57777 | 1353 | 56043 | 381 | 51.4982 | 31.2893 | 2021-08-01 04:21:50 | Chernihiv Oblast, Ukraine | ||
2021-07-24 | Ukraine | Cherkasy Oblast | 82119 | 1321 | 80417 | 381 | 49.4444 | 32.0598 | 2021-07-25 04:22:12 | Cherkasy Oblast, Ukraine | ||
2021-07-19 | Montenegro | 100690 | 1623 | 98686 | 381 | 42.708678000000006 | 19.37439 | 2021-07-20 04:21:48 | Montenegro | |||
2021-07-03 | Ukraine | Kherson Oblast | 35830 | 1147 | 34302 | 381 | 46.6354 | 32.6169 | 2021-07-04 04:21:38 | Kherson Oblast, Ukraine | ||
2021-07-01 | Ukraine | Donetsk Oblast | 90646 | 2356 | 87909 | 381 | 48.0159 | 37.8028 | 2021-07-02 04:21:47 | Donetsk Oblast, Ukraine | ||
2021-06-22 | Russia | Altai Republic | 17536 | 248 | 16907 | 381 | 50.7114101 | 86.8572186 | 2021-06-23 04:21:46 | Altai Republic, Russia | ||
2021-06-09 | Japan | Shiga | 5357 | 83 | 4893 | 381 | 35.21582700000001 | 136.138064 | 2021-06-10 04:23:17 | Shiga, Japan | ||
2021-05-28 | Russia | North Ossetia - Alania Republic | 16978 | 212 | 16385 | 381 | 42.79336110000001 | 44.6324493 | 2021-05-29 04:20:41 | North Ossetia - Alania Republic, Russia | ||
2021-05-15 | Japan | Tochigi | 5825 | 74 | 5370 | 381 | 36.689912 | 139.819213 | 2021-05-16 04:20:49 | Tochigi, Japan | ||
2021-05-12 | Russia | Khakassia Republic | 22600 | 534 | 21685 | 381 | 53.72258845 | 91.44293627 | 2021-05-13 04:20:51 | Khakassia Republic, Russia | ||
2021-04-30 | Russia | Mari El Republic | 13061 | 228 | 12452 | 381 | 56.5767504 | 47.8817512 | 2021-05-01 04:20:47 | Mari El Republic, Russia | ||
2021-04-25 | Japan | Nagano | 3735 | 62 | 3292 | 381 | 36.132134 | 138.045528 | 2021-04-26 04:21:04 | Nagano, Japan | ||
2021-04-17 | Russia | Adygea Republic | 14288 | 170 | 13737 | 381 | 44.6939006 | 40.1520421 | 2021-04-18 04:20:41 | Adygea Republic, Russia | ||
2021-04-12 | Mauritius | 1176 | 12 | 797 | 381 | -20.348404 | 57.552152 | 2021-04-13 04:20:37 | Mauritius | |||
2021-04-06 | France | Wallis and Futuna | 429 | 4 | 44 | 381 | -14.2938 | -178.1165 | 2021-04-07 04:20:53 | Wallis and Futuna, France | ||
2021-03-25 | Malaysia | Negeri Sembilan | 17116 | 31 | 16704 | 381 | 2.7258 | 101.9424 | 2021-03-26 05:26:55 | Negeri Sembilan, Malaysia | ||
2021-03-24 | Ukraine | Sevastopol* | 12941 | 555 | 12005 | 381 | 44.6054 | 33.522 | 2021-03-25 05:27:00 | Sevastopol*, Ukraine | ||
2021-03-21 | Ukraine | Sevastopol* | 12838 | 547 | 11910 | 381 | 44.6054 | 33.522 | 2021-03-22 05:25:43 | Sevastopol*, Ukraine | ||
2021-03-21 | Russia | Sakhalin Oblast | 21903 | 36 | 21486 | 381 | 49.7219665 | 143.448533 | 2021-03-22 05:25:43 | Sakhalin Oblast, Russia | ||
2021-03-15 | Andorra | 11289 | 113 | 10795 | 381 | 42.5063 | 1.5218 | 2021-03-16 05:25:13 | Andorra | |||
2021-03-10 | Russia | Komi Republic | 40215 | 762 | 39072 | 381 | 63.9881421 | 54.3326073 | 2021-03-11 05:25:48 | Komi Republic, Russia | ||
2021-03-09 | Ukraine | Sevastopol* | 12417 | 520 | 11516 | 381 | 44.6054 | 33.522 | 2021-03-10 05:24:35 | Sevastopol*, Ukraine | ||
2021-03-09 | Barbados | 3333 | 37 | 2915 | 381 | 13.1939 | -59.5432 | 2021-03-10 05:24:35 | Barbados | |||
2021-03-06 | US | Texas | Mason | 48319 | 350 | 6 | 0 | 381 | 30.71780434 | -99.22629416 | 2021-03-07 05:21:54 | Mason, Texas, US |
2021-03-05 | US | Texas | Mason | 48319 | 350 | 6 | 0 | 381 | 30.71780434 | -99.22629416 | 2021-03-06 04:23:41 | Mason, Texas, US |
2021-03-04 | US | Nebraska | Nuckolls | 31129 | 382 | 1 | 0 | 381 | 40.17637905 | -98.04743961 | 2021-03-05 05:26:29 | Nuckolls, Nebraska, US |
2021-03-03 | US | Nebraska | Nuckolls | 31129 | 382 | 1 | 0 | 381 | 40.17637905 | -98.04743961 | 2021-03-04 05:24:24 | Nuckolls, Nebraska, US |
2021-03-03 | Sao Tome and Principe | 1881 | 30 | 1470 | 381 | 0.1864 | 6.6131 | 2021-03-04 05:24:24 | Sao Tome and Principe | |||
2021-03-02 | US | Texas | Mason | 48319 | 349 | 5 | 0 | 381 | 30.71780434 | -99.22629416 | 2021-03-03 05:23:28 | Mason, Texas, US |
2021-03-02 | US | Texas | Carson | 48065 | 665 | 14 | 0 | 381 | 35.40365929 | -101.3542669 | 2021-03-03 05:23:28 | Carson, Texas, US |
2021-03-01 | US | Texas | Mason | 48319 | 349 | 5 | 0 | 381 | 30.71780434 | -99.22629416 | 2021-03-02 05:23:30 | Mason, Texas, US |
2021-02-28 | US | Texas | Mason | 48319 | 349 | 5 | 0 | 381 | 30.71780434 | -99.22629416 | 2021-03-01 05:23:01 | Mason, Texas, US |
2021-02-28 | US | Montana | Sheridan | 30091 | 386 | 5 | 0 | 381 | 48.72085833 | -104.503829 | 2021-03-01 05:23:01 | Sheridan, Montana, US |
2021-02-28 | US | Michigan | Oscoda | 26135 | 400 | 19 | 0 | 381 | 44.68192279 | -84.12939244 | 2021-03-01 05:23:01 | Oscoda, Michigan, US |
2021-02-28 | India | Chandigarh | 21770 | 352 | 21037 | 381 | 30.733839 | 76.76827800000002 | 2021-03-01 05:23:01 | Chandigarh, India | ||
2021-02-27 | US | Montana | Sheridan | 30091 | 386 | 5 | 0 | 381 | 48.72085833 | -104.503829 | 2021-02-28 05:22:20 | Sheridan, Montana, US |
2021-02-27 | US | Michigan | Oscoda | 26135 | 400 | 19 | 0 | 381 | 44.68192279 | -84.12939244 | 2021-02-28 05:22:20 | Oscoda, Michigan, US |
2021-02-26 | US | Montana | Sheridan | 30091 | 386 | 5 | 0 | 381 | 48.72085833 | -104.503829 | 2021-02-27 05:22:28 | Sheridan, Montana, US |
2021-02-26 | Sao Tome and Principe | 1745 | 28 | 1336 | 381 | 0.1864 | 6.6131 | 2021-02-27 05:22:28 | Sao Tome and Principe | |||
2021-02-26 | Japan | Ibaraki | 5710 | 106 | 5223 | 381 | 36.303588 | 140.319591 | 2021-02-27 05:22:28 | Ibaraki, Japan | ||
2021-02-25 | US | Nebraska | Nuckolls | 31129 | 382 | 1 | 0 | 381 | 40.17637905 | -98.04743961 | 2021-02-26 05:22:40 | Nuckolls, Nebraska, US |
2021-02-25 | US | Montana | Sheridan | 30091 | 386 | 5 | 0 | 381 | 48.72085833 | -104.503829 | 2021-02-26 05:22:40 | Sheridan, Montana, US |
2021-02-22 | Colombia | Huila | 49290 | 1706 | 47203 | 381 | 2.5359 | -75.5277 | 2021-02-23 05:23:41 | Huila, Colombia | ||
2021-02-21 | US | Virginia | Charles City | 51036 | 391 | 10 | 0 | 381 | 37.35358063 | -77.05634116 | 2021-02-22 05:24:21 | Charles City, Virginia, US |
2021-02-19 | US | Minnesota | Kittson | 27069 | 402 | 21 | 0 | 381 | 48.77754106 | -96.78317184 | 2021-02-20 05:22:51 | Kittson, Minnesota, US |
2021-02-17 | US | Kentucky | Menifee | 21165 | 392 | 11 | 0 | 381 | 37.94090733 | -83.59985712 | 2021-02-18 05:22:58 | Menifee, Kentucky, US |
2021-02-17 | US | California | Mariposa | 6043 | 388 | 7 | 0 | 381 | 37.57978556 | -119.9073334 | 2021-02-18 05:22:58 | Mariposa, California, US |
2021-02-16 | US | California | Mariposa | 6043 | 388 | 7 | 0 | 381 | 37.57978556 | -119.9073334 | 2021-02-17 05:23:10 | Mariposa, California, US |
2021-02-15 | US | California | Mariposa | 6043 | 388 | 7 | 0 | 381 | 37.57978556 | -119.9073334 | 2021-02-16 05:24:38 | Mariposa, California, US |
2021-02-13 | US | California | Mariposa | 6043 | 386 | 5 | 0 | 381 | 37.57978556 | -119.9073334 | 2021-02-14 05:23:43 | Mariposa, California, US |
2021-02-12 | US | California | Mariposa | 6043 | 386 | 5 | 0 | 381 | 37.57978556 | -119.9073334 | 2021-02-13 05:22:12 | Mariposa, California, US |
2021-02-11 | Colombia | Caqueta | 16856 | 610 | 15865 | 381 | 0.8699 | -73.8419 | 2021-02-12 05:23:29 | Caqueta, Colombia | ||
2021-02-07 | US | Vermont | Orleans | 50019 | 387 | 6 | 0 | 381 | 44.82964024 | -72.24562697 | 2021-02-08 05:22:39 | Orleans, Vermont, US |
2021-02-07 | US | Oregon | Tillamook | 41057 | 383 | 2 | 0 | 381 | 45.46248721 | -123.712066 | 2021-02-08 05:22:39 | Tillamook, Oregon, US |
2021-02-07 | US | Illinois | Putnam | 17155 | 384 | 3 | 0 | 381 | 41.2013541 | -89.2869272 | 2021-02-08 05:22:39 | Putnam, Illinois, US |
2021-02-06 | US | Oregon | Tillamook | 41057 | 383 | 2 | 0 | 381 | 45.46248721 | -123.712066 | 2021-02-07 05:23:00 | Tillamook, Oregon, US |
2021-02-05 | US | Oregon | Tillamook | 41057 | 383 | 2 | 0 | 381 | 45.46248721 | -123.712066 | 2021-02-06 05:23:55 | Tillamook, Oregon, US |
2021-02-04 | US | Oregon | Tillamook | 41057 | 383 | 2 | 0 | 381 | 45.46248721 | -123.712066 | 2021-02-05 05:22:38 | Tillamook, Oregon, US |
2021-02-03 | US | Puerto Rico | San German | 72125 | 381 | 0 | 0 | 381 | 18.111484 | -67.03858100000001 | 2021-02-04 05:22:26 | San German, Puerto Rico, US |
2021-02-02 | US | Texas | Hartley | 48205 | 548 | 2 | 0 | 381 | 35.84008013 | -102.6029022 | 2021-02-03 05:22:52 | Hartley, Texas, US |
2021-02-01 | US | Texas | Haskell | 48207 | 399 | 19 | 0 | 381 | 33.17823584 | -99.73037358 | 2021-02-02 05:22:49 | Haskell, Texas, US |
2021-01-31 | US | Texas | Haskell | 48207 | 399 | 19 | 0 | 381 | 33.17823584 | -99.73037358 | 2021-02-01 05:22:53 | Haskell, Texas, US |
2021-01-31 | US | Puerto Rico | Penuelas | 72111 | 381 | 0 | 0 | 381 | 18.059645 | -66.721572 | 2021-02-01 05:22:53 | Penuelas, Puerto Rico, US |
2021-01-31 | US | Oklahoma | Beaver | 40007 | 385 | 4 | 0 | 381 | 36.7496847 | -100.4758872 | 2021-02-01 05:22:53 | Beaver, Oklahoma, US |
2021-01-30 | US | Texas | Haskell | 48207 | 399 | 19 | 0 | 381 | 33.17823584 | -99.73037358 | 2021-01-31 05:22:42 | Haskell, Texas, US |
2021-01-30 | US | Puerto Rico | Penuelas | 72111 | 381 | 0 | 0 | 381 | 18.059645 | -66.721572 | 2021-01-31 05:22:42 | Penuelas, Puerto Rico, US |
2021-01-26 | US | Georgia | Talbot | 13263 | 393 | 12 | 0 | 381 | 32.69642758 | -84.53351366 | 2021-01-27 05:23:41 | Talbot, Georgia, US |
2021-01-25 | US | Puerto Rico | Aibonito | 72009 | 381 | 0 | 0 | 381 | 18.131361 | -66.264131 | 2021-01-26 05:22:02 | Aibonito, Puerto Rico, US |
2021-01-25 | US | California | Modoc | 6049 | 378 | 0 | 0 | 381 | 41.58965602 | -120.7244817 | 2021-01-26 05:22:02 | Modoc, California, US |
2021-01-24 | US | Virginia | Fairfax City | 51600 | 391 | 10 | 0 | 381 | 38.85157547 | -77.29779640000002 | 2021-01-25 05:22:16 | Fairfax City, Virginia, US |
2021-01-24 | US | Oklahoma | Harper | 40059 | 384 | 3 | 0 | 381 | 36.78836519 | -99.6679804 | 2021-01-25 05:22:16 | Harper, Oklahoma, US |
2021-01-24 | US | Georgia | Talbot | 13263 | 392 | 11 | 0 | 381 | 32.69642758 | -84.53351366 | 2021-01-25 05:22:16 | Talbot, Georgia, US |
2021-01-23 | US | Virginia | Fairfax City | 51600 | 391 | 10 | 0 | 381 | 38.85157547 | -77.29779640000002 | 2021-01-24 05:22:35 | Fairfax City, Virginia, US |
2021-01-23 | US | Oklahoma | Harper | 40059 | 384 | 3 | 0 | 381 | 36.78836519 | -99.6679804 | 2021-01-24 05:22:35 | Harper, Oklahoma, US |
2021-01-19 | US | Texas | Marion | 48315 | 483 | 20 | 0 | 381 | 32.79868409 | -94.3566123 | 2021-01-20 05:21:54 | Marion, Texas, US |
2021-01-17 | US | Kansas | Rush | 20165 | 391 | 10 | 0 | 381 | 38.52275276 | -99.30863983 | 2021-01-18 05:22:34 | Rush, Kansas, US |
2021-01-17 | US | Illinois | Alexander | 17003 | 388 | 7 | 0 | 381 | 37.18049267 | -89.32910838 | 2021-01-18 05:22:34 | Alexander, Illinois, US |
2021-01-16 | US | Kansas | Rush | 20165 | 391 | 10 | 0 | 381 | 38.52275276 | -99.30863983 | 2021-01-17 05:22:17 | Rush, Kansas, US |
2021-01-16 | Japan | Nara | 2513 | 31 | 2101 | 381 | 34.317451 | 135.871644 | 2021-01-17 05:22:17 | Nara, Japan | ||
2021-01-15 | US | Kansas | Rush | 20165 | 391 | 10 | 0 | 381 | 38.52275276 | -99.30863983 | 2021-01-16 05:22:40 | Rush, Kansas, US |
2021-01-12 | US | Kansas | Haskell | 20081 | 383 | 2 | 0 | 381 | 37.5620394 | -100.8710738 | 2021-01-13 05:22:15 | Haskell, Kansas, US |
2021-01-12 | Japan | Nara | 2370 | 30 | 1959 | 381 | 34.317451 | 135.871644 | 2021-01-13 05:22:15 | Nara, Japan | ||
2021-01-11 | US | Kansas | Haskell | 20081 | 383 | 2 | 0 | 381 | 37.5620394 | -100.8710738 | 2021-01-12 05:22:15 | Haskell, Kansas, US |
2021-01-09 | US | Virginia | Williamsburg | 51830 | 389 | 8 | 0 | 381 | 37.28131268 | -76.70905141 | 2021-01-10 05:22:12 | Williamsburg, Virginia, US |
2021-01-09 | US | Missouri | Clark | 29045 | 386 | 5 | 0 | 381 | 40.41040752 | -91.73661677 | 2021-01-10 05:22:12 | Clark, Missouri, US |
2021-01-08 | US | Nebraska | Sheridan | 31161 | 392 | 11 | 0 | 381 | 42.50284406 | -102.4126613 | 2021-01-09 05:22:18 | Sheridan, Nebraska, US |
2021-01-07 | US | Texas | Sutton | 48435 | 338 | 6 | 0 | 381 | 30.49856623 | -100.5382014 | 2021-01-08 05:22:42 | Sutton, Texas, US |
2021-01-07 | US | North Dakota | Emmons | 38029 | 393 | 10 | 0 | 381 | 46.28398398 | -100.2389766 | 2021-01-08 05:22:42 | Emmons, North Dakota, US |
2021-01-07 | US | Missouri | Carter | 29035 | 387 | 6 | 0 | 381 | 36.94160441 | -90.96051322 | 2021-01-08 05:22:42 | Carter, Missouri, US |
2021-01-07 | US | Iowa | Ringgold | 19159 | 389 | 8 | 0 | 381 | 40.73518949 | -94.24368535 | 2021-01-08 05:22:42 | Ringgold, Iowa, US |
2021-01-06 | US | Maine | Knox | 23013 | 385 | 4 | 0 | 381 | 44.11486325 | -69.10529169 | 2021-01-07 05:22:03 | Knox, Maine, US |
2021-01-05 | US | Maine | Knox | 23013 | 385 | 4 | 0 | 381 | 44.11486325 | -69.10529169 | 2021-01-06 05:22:16 | Knox, Maine, US |
2021-01-04 | US | Wyoming | Crook | 56011 | 388 | 7 | 0 | 381 | 44.58855102 | -104.5697705 | 2021-01-05 05:21:49 | Crook, Wyoming, US |
2021-01-04 | US | Oklahoma | Greer | 40055 | 390 | 9 | 0 | 381 | 34.93535801 | -99.5605612 | 2021-01-05 05:21:49 | Greer, Oklahoma, US |
2021-01-04 | US | Nevada | White Pine | 32033 | 384 | 3 | 0 | 381 | 39.44157041 | -114.899966 | 2021-01-05 05:21:49 | White Pine, Nevada, US |
2021-01-03 | US | Wyoming | Crook | 56011 | 388 | 7 | 0 | 381 | 44.58855102 | -104.5697705 | 2021-01-04 05:22:02 | Crook, Wyoming, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;