johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
369 rows where active = 646 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332129 | 332129 | 2021-08-04 | Russia | Magadan Oblast | 9602 | 165 | 8791 | 646 | 62.48858785 | 153.9903764 | 2021-08-05 04:21:51 | Magadan Oblast, Russia | ||
3683421 | 3683421 | 2021-08-02 | India | Uttar Pradesh | 1708500 | 22763 | 1685091 | 646 | 26.925425 | 80.560982 | 2021-08-03 04:21:39 | Uttar Pradesh, India | ||
3904092 | 3904092 | 2021-07-31 | Netherlands | Curacao | 13625 | 126 | 12853 | 646 | 12.1696 | -68.99 | 2021-08-01 04:21:50 | Curacao, Netherlands | ||
3903764 | 3903764 | 2021-07-31 | Chile | Maule | 99680 | 1672 | 97362 | 646 | -35.5183 | -71.6885 | 2021-08-01 04:21:50 | Maule, Chile | ||
3296297 | 3296297 | 2021-07-30 | Netherlands | Curacao | 13567 | 126 | 12795 | 646 | 12.1696 | -68.99 | 2021-07-31 04:21:35 | Curacao, Netherlands | ||
579015 | 579015 | 2021-07-13 | Romania | 1081326 | 34233 | 1046447 | 646 | 45.9432 | 24.9668 | 2021-07-14 04:21:35 | Romania | |||
3741225 | 3741225 | 2021-07-12 | Pakistan | Gilgit-Baltistan | 6972 | 111 | 6215 | 646 | 35.792146 | 74.982138 | 2021-07-13 04:21:18 | Gilgit-Baltistan, Pakistan | ||
3741112 | 3741112 | 2021-07-12 | Japan | Okinawa | 21351 | 206 | 20499 | 646 | 25.768923 | 126.668016 | 2021-07-13 04:21:18 | Okinawa, Japan | ||
111072 | 111072 | 2021-06-19 | Ukraine | Chernivtsi Oblast | 79821 | 1788 | 77387 | 646 | 48.2917 | 25.9352 | 2021-06-20 04:21:48 | Chernivtsi Oblast, Ukraine | ||
3033926 | 3033926 | 2021-06-16 | Ukraine | Sevastopol* | 15409 | 705 | 14058 | 646 | 44.6054 | 33.522 | 2021-06-17 04:22:36 | Sevastopol*, Ukraine | ||
2255723 | 2255723 | 2021-05-19 | Italy | P.A. Trento | 45024 | 1354 | 43024 | 646 | 46.06893511 | 11.12123097 | 2021-05-20 04:21:05 | P.A. Trento, Italy | ||
2255710 | 2255710 | 2021-05-19 | Israel | 839221 | 6395 | 832180 | 646 | 31.046051 | 34.851612 | 2021-05-20 04:21:05 | Israel | |||
2390566 | 2390566 | 2021-05-18 | Chile | Tarapaca | 35661 | 648 | 34367 | 646 | -19.9232 | -69.5132 | 2021-05-19 04:20:42 | Tarapaca, Chile | ||
2501878 | 2501878 | 2021-05-07 | Colombia | Huila | 54462 | 1882 | 51934 | 646 | 2.5359 | -75.5277 | 2021-05-08 04:21:04 | Huila, Colombia | ||
2760768 | 2760768 | 2021-05-03 | Colombia | Huila | 53920 | 1870 | 51404 | 646 | 2.5359 | -75.5277 | 2021-05-04 04:20:34 | Huila, Colombia | ||
3129705 | 3129705 | 2021-04-18 | Russia | Amur Oblast | 22157 | 270 | 21241 | 646 | 52.8032368 | 128.437295 | 2021-04-19 04:20:57 | Amur Oblast, Russia | ||
170295 | 170295 | 2021-04-16 | Russia | Tula Oblast | 37633 | 1710 | 35277 | 646 | 53.9570701 | 37.3690909 | 2021-04-17 04:20:40 | Tula Oblast, Russia | ||
169896 | 169896 | 2021-04-16 | Colombia | Meta | 44883 | 1024 | 43213 | 646 | 3.272 | -73.0877 | 2021-04-17 04:20:40 | Meta, Colombia | ||
3084990 | 3084990 | 2021-04-05 | Andorra | 12286 | 117 | 11523 | 646 | 42.5063 | 1.5218 | 2021-04-06 04:20:32 | Andorra | |||
1302306 | 1302306 | 2021-04-01 | Russia | Tyva Republic | 15762 | 197 | 14919 | 646 | 51.4017149 | 93.8582593 | 2021-04-02 04:20:36 | Tyva Republic, Russia | ||
3669670 | 3669670 | 2021-03-06 | US | Nebraska | Clay | 31035 | 657 | 11 | 0 | 646 | 40.52439441 | -98.05126296 | 2021-03-07 05:21:54 | Clay, Nebraska, US |
1092830 | 1092830 | 2021-03-03 | US | Puerto Rico | Naguabo | 72103 | 646 | 0 | 0 | 646 | 18.230637 | -65.753897 | 2021-03-04 05:24:24 | Naguabo, Puerto Rico, US |
3256902 | 3256902 | 2021-03-02 | US | Puerto Rico | Naguabo | 72103 | 646 | 0 | 0 | 646 | 18.230637 | -65.753897 | 2021-03-03 05:23:28 | Naguabo, Puerto Rico, US |
1001194 | 1001194 | 2021-03-01 | US | Puerto Rico | Naguabo | 72103 | 646 | 0 | 0 | 646 | 18.230637 | -65.753897 | 2021-03-02 05:23:30 | Naguabo, Puerto Rico, US |
3068723 | 3068723 | 2021-02-27 | US | Puerto Rico | Coamo | 72043 | 646 | 0 | 0 | 646 | 18.097597 | -66.36014 | 2021-02-28 05:22:20 | Coamo, Puerto Rico, US |
3066628 | 3066628 | 2021-02-27 | US | Colorado | Moffat | 8081 | 726 | 22 | 0 | 646 | 40.61810999 | -108.2070876 | 2021-02-28 05:22:20 | Moffat, Colorado, US |
2186307 | 2186307 | 2021-02-26 | US | Puerto Rico | Coamo | 72043 | 646 | 0 | 0 | 646 | 18.097597 | -66.36014 | 2021-02-27 05:22:28 | Coamo, Puerto Rico, US |
1860729 | 1860729 | 2021-02-25 | US | Puerto Rico | Coamo | 72043 | 646 | 0 | 0 | 646 | 18.097597 | -66.36014 | 2021-02-26 05:22:40 | Coamo, Puerto Rico, US |
1858194 | 1858194 | 2021-02-25 | Russia | Bryansk Oblast | 32593 | 252 | 31695 | 646 | 52.8873315 | 33.41585300000001 | 2021-02-26 05:22:40 | Bryansk Oblast, Russia | ||
1937697 | 1937697 | 2021-02-23 | US | Iowa | Worth | 19195 | 652 | 6 | 0 | 646 | 43.37750768 | -93.26087602 | 2021-02-24 05:29:16 | Worth, Iowa, US |
185702 | 185702 | 2021-02-21 | Vietnam | 2383 | 35 | 1702 | 646 | 14.058324 | 108.277199 | 2021-02-22 05:24:21 | Vietnam | |||
743560 | 743560 | 2021-02-20 | US | Iowa | Worth | 19195 | 650 | 4 | 0 | 646 | 43.37750768 | -93.26087602 | 2021-02-21 05:24:33 | Worth, Iowa, US |
472658 | 472658 | 2021-02-19 | US | Iowa | Worth | 19195 | 650 | 4 | 0 | 646 | 43.37750768 | -93.26087602 | 2021-02-20 05:22:51 | Worth, Iowa, US |
1155201 | 1155201 | 2021-02-18 | US | Nebraska | Kearney | 31099 | 651 | 5 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-19 05:24:16 | Kearney, Nebraska, US |
1154997 | 1154997 | 2021-02-18 | US | Missouri | Cedar | 29039 | 663 | 17 | 0 | 646 | 37.72391475 | -93.85445441 | 2021-02-19 05:24:16 | Cedar, Missouri, US |
1153743 | 1153743 | 2021-02-18 | US | Colorado | Lake | 8065 | 662 | 0 | 0 | 646 | 39.20278823 | -106.3555697 | 2021-02-19 05:24:16 | Lake, Colorado, US |
3603121 | 3603121 | 2021-02-17 | US | Nebraska | Kearney | 31099 | 651 | 5 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-18 05:22:58 | Kearney, Nebraska, US |
3602917 | 3602917 | 2021-02-17 | US | Missouri | Cedar | 29039 | 663 | 17 | 0 | 646 | 37.72391475 | -93.85445441 | 2021-02-18 05:22:58 | Cedar, Missouri, US |
3052256 | 3052256 | 2021-02-16 | US | Nebraska | Kearney | 31099 | 650 | 4 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-17 05:23:10 | Kearney, Nebraska, US |
3050679 | 3050679 | 2021-02-16 | US | Arkansas | Newton | 5101 | 672 | 26 | 0 | 646 | 35.91947491 | -93.21612969 | 2021-02-17 05:23:10 | Newton, Arkansas, US |
3049885 | 3049885 | 2021-02-16 | Barbados | 2331 | 25 | 1660 | 646 | 13.1939 | -59.5432 | 2021-02-17 05:23:10 | Barbados | |||
1341139 | 1341139 | 2021-02-15 | US | South Dakota | Hamlin | 46057 | 684 | 38 | 0 | 646 | 44.67385954 | -97.18829593 | 2021-02-16 05:24:38 | Hamlin, South Dakota, US |
1340355 | 1340355 | 2021-02-15 | US | Nebraska | Kearney | 31099 | 650 | 4 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-16 05:24:38 | Kearney, Nebraska, US |
2285506 | 2285506 | 2021-02-14 | US | Nebraska | Kearney | 31099 | 650 | 4 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-15 05:24:49 | Kearney, Nebraska, US |
2679906 | 2679906 | 2021-02-13 | US | Nebraska | Kearney | 31099 | 650 | 4 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-14 05:23:43 | Kearney, Nebraska, US |
3542539 | 3542539 | 2021-02-12 | US | Texas | Franklin | 48159 | 785 | 21 | 0 | 646 | 33.17653242 | -95.21917243 | 2021-02-13 05:22:12 | Franklin, Texas, US |
3541539 | 3541539 | 2021-02-12 | US | Nebraska | Kearney | 31099 | 650 | 4 | 0 | 646 | 40.50663314 | -98.94877182 | 2021-02-13 05:22:12 | Kearney, Nebraska, US |
2638858 | 2638858 | 2021-02-11 | US | Indiana | Union | 18161 | 656 | 10 | 0 | 646 | 39.62550777 | -84.92497066 | 2021-02-12 05:23:29 | Union, Indiana, US |
3981958 | 3981958 | 2021-02-10 | US | Virginia | Poquoson | 51735 | 656 | 10 | 0 | 646 | 37.14259351 | -76.35798148 | 2021-02-11 05:23:55 | Poquoson, Virginia, US |
3981593 | 3981593 | 2021-02-10 | US | Texas | Blanco | 48031 | 733 | 15 | 0 | 646 | 30.26640707 | -98.3999852 | 2021-02-11 05:23:55 | Blanco, Texas, US |
615689 | 615689 | 2021-02-08 | US | Montana | Madison | 30057 | 653 | 7 | 0 | 646 | 45.30080065 | -111.9173017 | 2021-02-09 05:23:30 | Madison, Montana, US |
1674458 | 1674458 | 2021-02-07 | US | Montana | Madison | 30057 | 653 | 7 | 0 | 646 | 45.30080065 | -111.9173017 | 2021-02-08 05:22:39 | Madison, Montana, US |
1674333 | 1674333 | 2021-02-07 | US | Missouri | Cedar | 29039 | 656 | 10 | 0 | 646 | 37.72391475 | -93.85445441 | 2021-02-08 05:22:39 | Cedar, Missouri, US |
976794 | 976794 | 2021-02-06 | US | Missouri | Cedar | 29039 | 656 | 10 | 0 | 646 | 37.72391475 | -93.85445441 | 2021-02-07 05:23:00 | Cedar, Missouri, US |
1591809 | 1591809 | 2021-02-05 | Ukraine | Sevastopol* | 10200 | 413 | 9141 | 646 | 44.6054 | 33.522 | 2021-02-06 05:23:55 | Sevastopol*, Ukraine | ||
794016 | 794016 | 2021-02-04 | Ukraine | Sevastopol* | 10108 | 409 | 9053 | 646 | 44.6054 | 33.522 | 2021-02-05 05:22:38 | Sevastopol*, Ukraine | ||
791705 | 791705 | 2021-02-04 | US | Kansas | Phillips | 20147 | 663 | 17 | 0 | 646 | 39.78465501 | -99.34668865 | 2021-02-05 05:22:38 | Phillips, Kansas, US |
341597 | 341597 | 2021-02-03 | US | Kansas | Phillips | 20147 | 663 | 17 | 0 | 646 | 39.78465501 | -99.34668865 | 2021-02-04 05:22:26 | Phillips, Kansas, US |
1678552 | 1678552 | 2021-02-01 | US | Nebraska | Keith | 31101 | 649 | 3 | 0 | 646 | 41.19930341 | -101.6620164 | 2021-02-02 05:22:49 | Keith, Nebraska, US |
1678447 | 1678447 | 2021-02-01 | US | Montana | Blaine | 30005 | 670 | 24 | 0 | 646 | 48.43175214 | -108.9582723 | 2021-02-02 05:22:49 | Blaine, Montana, US |
1677305 | 1677305 | 2021-02-01 | US | Georgia | McIntosh | 13191 | 658 | 12 | 0 | 646 | 31.49683595 | -81.40163426 | 2021-02-02 05:22:49 | McIntosh, Georgia, US |
1461735 | 1461735 | 2021-01-31 | US | Montana | Blaine | 30005 | 670 | 24 | 0 | 646 | 48.43175214 | -108.9582723 | 2021-02-01 05:22:53 | Blaine, Montana, US |
2213643 | 2213643 | 2021-01-30 | US | Montana | Blaine | 30005 | 670 | 24 | 0 | 646 | 48.43175214 | -108.9582723 | 2021-01-31 05:22:42 | Blaine, Montana, US |
1899130 | 1899130 | 2021-01-29 | US | Montana | Blaine | 30005 | 670 | 24 | 0 | 646 | 48.43175214 | -108.9582723 | 2021-01-30 05:22:49 | Blaine, Montana, US |
2483265 | 2483265 | 2021-01-28 | US | Kansas | Kingman | 20095 | 658 | 12 | 0 | 646 | 37.55909527 | -98.13638678 | 2021-01-29 05:22:23 | Kingman, Kansas, US |
3156794 | 3156794 | 2021-01-27 | US | Texas | Presidio | 48377 | 603 | 22 | 0 | 646 | 29.99954402 | -104.2408079 | 2021-01-28 05:22:24 | Presidio, Texas, US |
3155327 | 3155327 | 2021-01-27 | US | Minnesota | Lac qui Parle | 27073 | 662 | 16 | 0 | 646 | 44.9973857 | -96.17488219 | 2021-01-28 05:22:24 | Lac qui Parle, Minnesota, US |
3154900 | 3154900 | 2021-01-27 | US | Kansas | Kingman | 20095 | 658 | 12 | 0 | 646 | 37.55909527 | -98.13638678 | 2021-01-28 05:22:24 | Kingman, Kansas, US |
12845 | 12845 | 2021-01-26 | US | Arkansas | Perry | 5105 | 652 | 6 | 0 | 646 | 34.9459153 | -92.94372564 | 2021-01-27 05:23:41 | Perry, Arkansas, US |
1759084 | 1759084 | 2021-01-24 | Chile | Coquimbo | 16119 | 328 | 15145 | 646 | -29.959 | -71.3389 | 2021-01-25 05:22:16 | Coquimbo, Chile | ||
2429695 | 2429695 | 2021-01-23 | US | South Carolina | Allendale | 45005 | 658 | 12 | 0 | 646 | 32.98837386 | -81.35321066 | 2021-01-24 05:22:35 | Allendale, South Carolina, US |
2428288 | 2428288 | 2021-01-23 | US | Kentucky | Edmonson | 21061 | 659 | 13 | 0 | 646 | 37.21218923 | -86.23955613 | 2021-01-24 05:22:35 | Edmonson, Kentucky, US |
2427773 | 2427773 | 2021-01-23 | US | Georgia | Taylor | 13269 | 664 | 18 | 0 | 646 | 32.55792548 | -84.25077141 | 2021-01-24 05:22:35 | Taylor, Georgia, US |
2427403 | 2427403 | 2021-01-23 | US | Arkansas | Monroe | 5095 | 660 | 14 | 0 | 646 | 34.6815935 | -91.20540287 | 2021-01-24 05:22:35 | Monroe, Arkansas, US |
435284 | 435284 | 2021-01-21 | Guinea | 14236 | 81 | 13509 | 646 | 9.9456 | -9.6966 | 2021-01-22 05:22:10 | Guinea | |||
1095487 | 1095487 | 2021-01-20 | US | Kentucky | Hancock | 21091 | 657 | 11 | 0 | 646 | 37.83766422 | -86.78280584 | 2021-01-21 05:22:01 | Hancock, Kentucky, US |
3102276 | 3102276 | 2021-01-16 | US | Georgia | Miller | 13201 | 650 | 4 | 0 | 646 | 31.16568912 | -84.73151117 | 2021-01-17 05:22:17 | Miller, Georgia, US |
3516948 | 3516948 | 2021-01-15 | US | Maine | Hancock | 23009 | 671 | 25 | 0 | 646 | 44.59816444 | -68.38401854 | 2021-01-16 05:22:40 | Hancock, Maine, US |
3515867 | 3515867 | 2021-01-15 | US | Arkansas | Cleveland | 5025 | 669 | 23 | 0 | 646 | 33.89723187 | -92.18537045 | 2021-01-16 05:22:40 | Cleveland, Arkansas, US |
3515197 | 3515197 | 2021-01-15 | Chile | Nuble | 11990 | 237 | 11107 | 646 | -36.7226 | -71.7622 | 2021-01-16 05:22:40 | Nuble, Chile | ||
3882598 | 3882598 | 2021-01-14 | US | Texas | Brooks | 48047 | 704 | 29 | 0 | 646 | 27.03103197 | -98.21808402 | 2021-01-15 05:22:24 | Brooks, Texas, US |
3310546 | 3310546 | 2021-01-13 | US | North Carolina | Perquimans | 37143 | 651 | 5 | 0 | 646 | 36.17847453 | -76.40603143 | 2021-01-14 05:22:32 | Perquimans, North Carolina, US |
3310034 | 3310034 | 2021-01-13 | US | Mississippi | Quitman | 28119 | 654 | 8 | 0 | 646 | 34.25157572 | -90.28908 | 2021-01-14 05:22:32 | Quitman, Mississippi, US |
776437 | 776437 | 2021-01-12 | US | Nebraska | Merrick | 31121 | 657 | 11 | 0 | 646 | 41.16624273 | -98.0374887 | 2021-01-13 05:22:15 | Merrick, Nebraska, US |
3901859 | 3901859 | 2021-01-09 | US | Missouri | Howard | 29089 | 650 | 4 | 0 | 646 | 39.1435761 | -92.69756691 | 2021-01-10 05:22:12 | Howard, Missouri, US |
3901064 | 3901064 | 2021-01-09 | US | Indiana | Martin | 18101 | 660 | 14 | 0 | 646 | 38.7099921 | -86.80373186 | 2021-01-10 05:22:12 | Martin, Indiana, US |
1065182 | 1065182 | 2021-01-04 | US | Virginia | Goochland | 51075 | 653 | 7 | 0 | 646 | 37.71714806 | -77.90381514 | 2021-01-05 05:21:49 | Goochland, Virginia, US |
1063363 | 1063363 | 2021-01-04 | US | Louisiana | Red River | 22081 | 675 | 29 | 0 | 646 | 32.09530039 | -93.34213308 | 2021-01-05 05:21:49 | Red River, Louisiana, US |
1063108 | 1063108 | 2021-01-04 | US | Kansas | Clay | 20027 | 666 | 20 | 0 | 646 | 39.34948772 | -97.16518128 | 2021-01-05 05:21:49 | Clay, Kansas, US |
2230818 | 2230818 | 2021-01-02 | US | Virginia | Brunswick | 51025 | 653 | 7 | 0 | 646 | 36.76366949 | -77.8593436 | 2021-01-03 05:22:52 | Brunswick, Virginia, US |
2229218 | 2229218 | 2021-01-02 | US | Minnesota | Clearwater | 27029 | 660 | 14 | 0 | 646 | 47.57992111 | -95.37790562 | 2021-01-03 05:22:52 | Clearwater, Minnesota, US |
3698981 | 3698981 | 2020-12-31 | US | West Virginia | Nicholas | 54067 | 654 | 8 | 0 | 646 | 38.29617706 | -80.79759588 | 2021-01-01 05:23:07 | Nicholas, West Virginia, US |
3698638 | 3698638 | 2020-12-31 | US | Texas | Llano | 48299 | 828 | 12 | 0 | 646 | 30.70645047 | -98.68475262 | 2021-01-01 05:23:07 | Llano, Texas, US |
3697451 | 3697451 | 2020-12-31 | US | Missouri | Sullivan | 29211 | 656 | 10 | 0 | 646 | 40.2099105 | -93.11150106 | 2021-01-01 05:23:07 | Sullivan, Missouri, US |
3697381 | 3697381 | 2020-12-31 | US | Missouri | Gasconade | 29073 | 675 | 29 | 0 | 646 | 38.43947277 | -91.50847147 | 2021-01-01 05:23:07 | Gasconade, Missouri, US |
3696271 | 3696271 | 2020-12-31 | US | Georgia | Dooly | 13093 | 671 | 25 | 0 | 646 | 32.15630737 | -83.79746561 | 2021-01-01 05:23:07 | Dooly, Georgia, US |
1012247 | 1012247 | 2020-12-30 | US | Missouri | Ralls | 29173 | 653 | 7 | 0 | 646 | 39.52817427 | -91.51838643 | 2020-12-31 05:22:49 | Ralls, Missouri, US |
1010487 | 1010487 | 2020-12-30 | Russia | Altai Republic | 13753 | 95 | 13012 | 646 | 50.7114101 | 86.8572186 | 2020-12-31 05:22:49 | Altai Republic, Russia | ||
768393 | 768393 | 2020-12-29 | US | Nebraska | Holt | 31089 | 659 | 13 | 0 | 646 | 42.45522056 | -98.78402558 | 2020-12-30 05:22:34 | Holt, Nebraska, US |
2409548 | 2409548 | 2020-12-23 | US | Puerto Rico | Catano | 72033 | 646 | 0 | 0 | 646 | 18.437269 | -66.14330600000001 | 2020-12-24 05:23:04 | Catano, Puerto Rico, 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]);