johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
332 rows where active = 683 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2673880 | 2673880 | 2021-07-18 | Madagascar | 42536 | 937 | 40916 | 683 | -18.766947 | 46.869107 | 2021-07-19 04:21:24 | Madagascar | |||
2673602 | 2673602 | 2021-07-18 | Chile | Los Rios | 47557 | 596 | 46278 | 683 | -40.231 | -72.3311 | 2021-07-19 04:21:24 | Los Rios, Chile | ||
296293 | 296293 | 2021-07-15 | Slovenia | 258045 | 4425 | 252937 | 683 | 46.1512 | 14.9955 | 2021-07-16 04:21:22 | Slovenia | |||
296079 | 296079 | 2021-07-15 | Madagascar | 42479 | 934 | 40862 | 683 | -18.766947 | 46.869107 | 2021-07-16 04:21:22 | Madagascar | |||
578776 | 578776 | 2021-07-13 | India | Delhi | 1435204 | 25020 | 1409501 | 683 | 28.646519 | 77.10898 | 2021-07-14 04:21:35 | Delhi, India | ||
1932656 | 1932656 | 2021-07-05 | Russia | Kurgan Oblast | 22760 | 451 | 21626 | 683 | 55.7655302 | 64.5632681 | 2021-07-06 04:21:32 | Kurgan Oblast, Russia | ||
1165147 | 1165147 | 2021-07-04 | Italy | Basilicata | 26985 | 591 | 25711 | 683 | 40.63947052 | 15.80514834 | 2021-07-05 04:21:28 | Basilicata, Italy | ||
3145602 | 3145602 | 2021-06-07 | Japan | Kyoto | 16108 | 223 | 15202 | 683 | 35.253815 | 135.443341 | 2021-06-08 04:22:35 | Kyoto, Japan | ||
2315414 | 2315414 | 2021-06-04 | Montenegro | 99758 | 1591 | 97484 | 683 | 42.708678000000006 | 19.37439 | 2021-06-05 04:23:03 | Montenegro | |||
1872963 | 1872963 | 2021-05-15 | Japan | Fukushima | 4214 | 130 | 3401 | 683 | 37.378867 | 140.223295 | 2021-05-16 04:20:49 | Fukushima, Japan | ||
3054198 | 3054198 | 2021-05-13 | Japan | Fukushima | 4114 | 129 | 3302 | 683 | 37.378867 | 140.223295 | 2021-05-14 04:20:41 | Fukushima, Japan | ||
1636165 | 1636165 | 2021-04-29 | Colombia | Huila | 53533 | 1856 | 50994 | 683 | 2.5359 | -75.5277 | 2021-04-30 04:21:03 | Huila, Colombia | ||
3242110 | 3242110 | 2021-04-21 | Chile | Arica y Parinacota | 19214 | 380 | 18151 | 683 | -18.594 | -69.4785 | 2021-04-22 04:20:53 | Arica y Parinacota, Chile | ||
3670486 | 3670486 | 2021-03-06 | US | South Dakota | Hamlin | 46057 | 721 | 38 | 0 | 683 | 44.67385954 | -97.18829593 | 2021-03-07 05:21:54 | Hamlin, South Dakota, US |
3669643 | 3669643 | 2021-03-06 | US | Montana | Stillwater | 30095 | 696 | 13 | 0 | 683 | 45.67071407 | -109.3950061 | 2021-03-07 05:21:54 | Stillwater, Montana, US |
1619107 | 1619107 | 2021-03-05 | US | South Dakota | Hamlin | 46057 | 721 | 38 | 0 | 683 | 44.67385954 | -97.18829593 | 2021-03-06 04:23:41 | Hamlin, South Dakota, US |
1618264 | 1618264 | 2021-03-05 | US | Montana | Stillwater | 30095 | 696 | 13 | 0 | 683 | 45.67071407 | -109.3950061 | 2021-03-06 04:23:41 | Stillwater, Montana, US |
1092918 | 1092918 | 2021-03-03 | US | South Dakota | Brule | 46015 | 692 | 9 | 0 | 683 | 43.71756379 | -99.08118954 | 2021-03-04 05:24:24 | Brule, South Dakota, US |
3257203 | 3257203 | 2021-03-02 | US | Texas | Dallam | 48111 | 1093 | 22 | 0 | 683 | 36.27787176 | -102.6020725 | 2021-03-03 05:23:28 | Dallam, Texas, US |
3256990 | 3256990 | 2021-03-02 | US | South Dakota | Brule | 46015 | 692 | 9 | 0 | 683 | 43.71756379 | -99.08118954 | 2021-03-03 05:23:28 | Brule, South Dakota, US |
1001336 | 1001336 | 2021-03-01 | US | South Dakota | Tripp | 46123 | 699 | 16 | 0 | 683 | 43.34459388 | -99.8854891 | 2021-03-02 05:23:30 | Tripp, South Dakota, US |
2370394 | 2370394 | 2021-02-28 | US | South Dakota | Tripp | 46123 | 699 | 16 | 0 | 683 | 43.34459388 | -99.8854891 | 2021-03-01 05:23:01 | Tripp, South Dakota, US |
3067205 | 3067205 | 2021-02-27 | US | Iowa | Lucas | 19117 | 704 | 21 | 0 | 683 | 41.02958964 | -93.32780803 | 2021-02-28 05:22:20 | Lucas, Iowa, US |
1861061 | 1861061 | 2021-02-25 | US | Texas | Dallam | 48111 | 1093 | 22 | 0 | 683 | 36.27787176 | -102.6020725 | 2021-02-26 05:22:40 | Dallam, Texas, US |
283432 | 283432 | 2021-02-24 | US | Texas | Winkler | 48495 | 695 | 20 | 0 | 683 | 31.85008651 | -103.0485163 | 2021-02-25 05:24:57 | Winkler, Texas, US |
280026 | 280026 | 2021-02-24 | Colombia | Cesar | 40195 | 1176 | 38336 | 683 | 9.3373 | -73.6536 | 2021-02-25 05:24:57 | Cesar, Colombia | ||
1936561 | 1936561 | 2021-02-23 | Mongolia | 2723 | 2 | 2070 | 683 | 46.8625 | 103.8467 | 2021-02-24 05:29:16 | Mongolia | |||
531941 | 531941 | 2021-02-22 | US | Iowa | Unassigned | 90019 | 683 | 0 | 0 | 683 | 43.38107862 | 0.0 | 2021-02-23 05:23:41 | Unassigned, Iowa, US |
531359 | 531359 | 2021-02-22 | US | Colorado | Yuma | 8125 | 826 | 17 | 0 | 683 | 40.00346839 | -102.4258673 | 2021-02-23 05:23:41 | Yuma, Colorado, US |
3604485 | 3604485 | 2021-02-17 | US | Washington | Pacific | 53049 | 692 | 9 | 0 | 683 | 46.55418369 | -123.7285716 | 2021-02-18 05:22:58 | Pacific, Washington, US |
3602599 | 3602599 | 2021-02-17 | US | Maine | Washington | 23029 | 696 | 13 | 0 | 683 | 45.01607142 | -67.62813524 | 2021-02-18 05:22:58 | Washington, Maine, US |
2681459 | 2681459 | 2021-02-13 | Ukraine | Sevastopol* | 10903 | 441 | 9779 | 683 | 44.6054 | 33.522 | 2021-02-14 05:23:43 | Sevastopol*, Ukraine | ||
2641049 | 2641049 | 2021-02-11 | US | Virginia | Floyd | 51063 | 701 | 18 | 0 | 683 | 36.9302126 | -80.36738849 | 2021-02-12 05:23:29 | Floyd, Virginia, US |
2640503 | 2640503 | 2021-02-11 | US | Puerto Rico | Yabucoa | 72151 | 683 | 0 | 0 | 683 | 18.070399 | -65.896289 | 2021-02-12 05:23:29 | Yabucoa, Puerto Rico, US |
1527749 | 1527749 | 2021-02-09 | Colombia | Meta | 41425 | 929 | 39813 | 683 | 3.272 | -73.0877 | 2021-02-10 05:22:41 | Meta, Colombia | ||
615388 | 615388 | 2021-02-08 | US | Minnesota | Clearwater | 27029 | 697 | 14 | 0 | 683 | 47.57992111 | -95.37790562 | 2021-02-09 05:23:30 | Clearwater, Minnesota, US |
614160 | 614160 | 2021-02-08 | US | Arkansas | Dallas | 5039 | 695 | 12 | 0 | 683 | 33.97042763 | -92.65167437 | 2021-02-09 05:23:30 | Dallas, Arkansas, US |
1674157 | 1674157 | 2021-02-07 | US | Minnesota | Clearwater | 27029 | 697 | 14 | 0 | 683 | 47.57992111 | -95.37790562 | 2021-02-08 05:22:39 | Clearwater, Minnesota, US |
1589833 | 1589833 | 2021-02-05 | US | Michigan | Missaukee | 26113 | 700 | 17 | 0 | 683 | 44.33772443 | -85.09256478 | 2021-02-06 05:23:55 | Missaukee, Michigan, US |
791205 | 791205 | 2021-02-04 | US | Georgia | Lanier | 13173 | 693 | 10 | 0 | 683 | 31.038285700000007 | -83.06472457 | 2021-02-05 05:22:38 | Lanier, Georgia, US |
1685331 | 1685331 | 2021-02-02 | US | Georgia | Macon | 13193 | 702 | 19 | 0 | 683 | 32.35207048 | -84.04234127 | 2021-02-03 05:22:52 | Macon, Georgia, US |
1684262 | 1684262 | 2021-02-02 | Cabo Verde | 14152 | 134 | 13335 | 683 | 16.5388 | -23.0418 | 2021-02-03 05:22:52 | Cabo Verde | |||
1677619 | 1677619 | 2021-02-01 | US | Iowa | Adair | 19001 | 707 | 24 | 0 | 683 | 41.33075609 | -94.47105874 | 2021-02-02 05:22:49 | Adair, Iowa, US |
2213027 | 2213027 | 2021-01-30 | US | Kentucky | Bath | 21011 | 697 | 14 | 0 | 683 | 38.14735938 | -83.74588932 | 2021-01-31 05:22:42 | Bath, Kentucky, US |
1900178 | 1900178 | 2021-01-29 | US | Texas | Brooks | 48047 | 743 | 31 | 0 | 683 | 27.03103197 | -98.21808402 | 2021-01-30 05:22:49 | Brooks, Texas, US |
2483994 | 2483994 | 2021-01-28 | US | Montana | Toole | 30101 | 693 | 10 | 0 | 683 | 48.65577551 | -111.6942414 | 2021-01-29 05:22:23 | Toole, Montana, US |
2483390 | 2483390 | 2021-01-28 | US | Kentucky | Leslie | 21131 | 685 | 2 | 0 | 683 | 37.09246661 | -83.37999606 | 2021-01-29 05:22:23 | Leslie, Kentucky, US |
2481811 | 2481811 | 2021-01-28 | Colombia | Casanare | 11241 | 225 | 10333 | 683 | 5.7589 | -71.5724 | 2021-01-29 05:22:23 | Casanare, Colombia | ||
3155629 | 3155629 | 2021-01-27 | US | Montana | Toole | 30101 | 691 | 8 | 0 | 683 | 48.65577551 | -111.6942414 | 2021-01-28 05:22:24 | Toole, Montana, US |
14431 | 14431 | 2021-01-26 | US | Nebraska | Merrick | 31121 | 696 | 13 | 0 | 683 | 41.16624273 | -98.0374887 | 2021-01-27 05:23:41 | Merrick, Nebraska, US |
13513 | 13513 | 2021-01-26 | US | Iowa | Davis | 19051 | 704 | 21 | 0 | 683 | 40.74773536 | -92.41005468 | 2021-01-27 05:23:41 | Davis, Iowa, US |
2570939 | 2570939 | 2021-01-25 | US | Vermont | Franklin | 50011 | 717 | 34 | 0 | 683 | 44.85627605 | -72.91249563 | 2021-01-26 05:22:02 | Franklin, Vermont, US |
2570883 | 2570883 | 2021-01-25 | US | Texas | Swisher | 48437 | 843 | 14 | 0 | 683 | 34.53028891 | -101.7349174 | 2021-01-26 05:22:02 | Swisher, Texas, US |
2569755 | 2569755 | 2021-01-25 | US | Nebraska | Merrick | 31121 | 696 | 13 | 0 | 683 | 41.16624273 | -98.0374887 | 2021-01-26 05:22:02 | Merrick, Nebraska, US |
2568837 | 2568837 | 2021-01-25 | US | Iowa | Davis | 19051 | 704 | 21 | 0 | 683 | 40.74773536 | -92.41005468 | 2021-01-26 05:22:02 | Davis, Iowa, US |
2568500 | 2568500 | 2021-01-25 | US | Georgia | Miller | 13201 | 689 | 6 | 0 | 683 | 31.16568912 | -84.73151117 | 2021-01-26 05:22:02 | Miller, Georgia, US |
1762515 | 1762515 | 2021-01-24 | US | Texas | Swisher | 48437 | 843 | 14 | 0 | 683 | 34.53028891 | -101.7349174 | 2021-01-25 05:22:16 | Swisher, Texas, US |
2430122 | 2430122 | 2021-01-23 | US | Texas | Swisher | 48437 | 843 | 14 | 0 | 683 | 34.53028891 | -101.7349174 | 2021-01-24 05:22:35 | Swisher, Texas, US |
2427713 | 2427713 | 2021-01-23 | US | Georgia | Heard | 13149 | 696 | 13 | 0 | 683 | 33.29686567 | -85.12886832 | 2021-01-24 05:22:35 | Heard, Georgia, US |
2470024 | 2470024 | 2021-01-22 | US | Texas | Swisher | 48437 | 843 | 14 | 0 | 683 | 34.53028891 | -101.7349174 | 2021-01-23 05:22:03 | Swisher, Texas, US |
911640 | 911640 | 2021-01-19 | US | West Virginia | Braxton | 54007 | 684 | 1 | 0 | 683 | 38.70036159 | -80.72011184 | 2021-01-20 05:21:54 | Braxton, West Virginia, US |
239625 | 239625 | 2021-01-18 | US | North Dakota | Dickey | 38021 | 712 | 32 | 0 | 683 | 46.11017712 | -98.5049008 | 2021-01-19 05:22:15 | Dickey, North Dakota, US |
239073 | 239073 | 2021-01-18 | US | Mississippi | Quitman | 28119 | 691 | 8 | 0 | 683 | 34.25157572 | -90.28908 | 2021-01-19 05:22:15 | Quitman, Mississippi, US |
3504618 | 3504618 | 2021-01-17 | US | Kansas | Clay | 20027 | 706 | 23 | 0 | 683 | 39.34948772 | -97.16518128 | 2021-01-18 05:22:34 | Clay, Kansas, US |
3104723 | 3104723 | 2021-01-16 | US | Vermont | Windham | 50025 | 692 | 9 | 0 | 683 | 42.986982 | -72.71268875 | 2021-01-17 05:22:17 | Windham, Vermont, US |
3104187 | 3104187 | 2021-01-16 | US | Puerto Rico | Loiza | 72087 | 683 | 0 | 0 | 683 | 18.425688 | -65.89943000000001 | 2021-01-17 05:22:17 | Loiza, Puerto Rico, US |
3102701 | 3102701 | 2021-01-16 | US | Kansas | Clay | 20027 | 706 | 23 | 0 | 683 | 39.34948772 | -97.16518128 | 2021-01-17 05:22:17 | Clay, Kansas, US |
3518114 | 3518114 | 2021-01-15 | US | Puerto Rico | Barranquitas | 72019 | 683 | 0 | 0 | 683 | 18.201592 | -66.30963 | 2021-01-16 05:22:40 | Barranquitas, Puerto Rico, US |
3516663 | 3516663 | 2021-01-15 | US | Kansas | Clay | 20027 | 706 | 23 | 0 | 683 | 39.34948772 | -97.16518128 | 2021-01-16 05:22:40 | Clay, Kansas, US |
3880824 | 3880824 | 2021-01-14 | US | Kansas | Anderson | 20003 | 690 | 7 | 0 | 683 | 38.21413251 | -95.29272815 | 2021-01-15 05:22:24 | Anderson, Kansas, US |
3311340 | 3311340 | 2021-01-13 | US | Texas | La Salle | 48283 | 866 | 15 | 0 | 683 | 28.34453111 | -99.09908775 | 2021-01-14 05:22:32 | La Salle, Texas, US |
3309930 | 3309930 | 2021-01-13 | US | Minnesota | Marshall | 27089 | 698 | 15 | 0 | 683 | 48.35825983 | -96.37017407 | 2021-01-14 05:22:32 | Marshall, Minnesota, US |
3309451 | 3309451 | 2021-01-13 | US | Kansas | Anderson | 20003 | 690 | 7 | 0 | 683 | 38.21413251 | -95.29272815 | 2021-01-14 05:22:32 | Anderson, Kansas, US |
3309185 | 3309185 | 2021-01-13 | US | Illinois | Hamilton | 17065 | 697 | 14 | 0 | 683 | 38.08163641 | -88.53883373 | 2021-01-14 05:22:32 | Hamilton, Illinois, US |
192947 | 192947 | 2021-01-11 | US | South Dakota | McCook | 46087 | 705 | 22 | 0 | 683 | 43.6742571 | -97.36863144 | 2021-01-12 05:22:15 | McCook, South Dakota, US |
192142 | 192142 | 2021-01-11 | US | Nebraska | Holt | 31089 | 696 | 13 | 0 | 683 | 42.45522056 | -98.78402558 | 2021-01-12 05:22:15 | Holt, Nebraska, US |
2629366 | 2629366 | 2021-01-10 | US | West Virginia | Pleasants | 54073 | 689 | 6 | 0 | 683 | 39.37091679 | -81.16771771 | 2021-01-11 05:21:50 | Pleasants, West Virginia, US |
3902664 | 3902664 | 2021-01-09 | US | Puerto Rico | Aguas Buenas | 72007 | 683 | 0 | 0 | 683 | 18.251619 | -66.126806 | 2021-01-10 05:22:12 | Aguas Buenas, Puerto Rico, US |
154847 | 154847 | 2021-01-08 | US | Georgia | Stewart | 13259 | 700 | 17 | 0 | 683 | 32.07996777 | -84.83208037 | 2021-01-09 05:22:18 | Stewart, Georgia, US |
2544257 | 2544257 | 2021-01-07 | US | South Dakota | Custer | 46033 | 692 | 9 | 0 | 683 | 43.67741105 | -103.4534521 | 2021-01-08 05:22:42 | Custer, South Dakota, US |
2542729 | 2542729 | 2021-01-07 | US | Kansas | Pratt | 20151 | 704 | 21 | 0 | 683 | 37.64780729 | -98.73922153 | 2021-01-08 05:22:42 | Pratt, Kansas, US |
2541903 | 2541903 | 2021-01-07 | US | Arkansas | Marion | 5089 | 707 | 24 | 0 | 683 | 36.26844485 | -92.68451899 | 2021-01-08 05:22:42 | Marion, Arkansas, US |
2868014 | 2868014 | 2021-01-06 | US | Virginia | Brunswick | 51025 | 690 | 7 | 0 | 683 | 36.76366949 | -77.8593436 | 2021-01-07 05:22:03 | Brunswick, Virginia, US |
2866684 | 2866684 | 2021-01-06 | US | Missouri | Wayne | 29223 | 690 | 7 | 0 | 683 | 37.11303869 | -90.46001416 | 2021-01-07 05:22:03 | Wayne, Missouri, US |
2866038 | 2866038 | 2021-01-06 | US | Kansas | Pratt | 20151 | 704 | 21 | 0 | 683 | 37.64780729 | -98.73922153 | 2021-01-07 05:22:03 | Pratt, Kansas, US |
2230411 | 2230411 | 2021-01-02 | US | South Dakota | Spink | 46115 | 707 | 24 | 0 | 683 | 44.93837606 | -98.34626602 | 2021-01-03 05:22:52 | Spink, South Dakota, US |
3698902 | 3698902 | 2020-12-31 | US | Virginia | Westmoreland | 51193 | 692 | 9 | 0 | 683 | 38.11021557 | -76.80213247 | 2021-01-01 05:23:07 | Westmoreland, Virginia, US |
1013865 | 1013865 | 2020-12-30 | US | Wisconsin | Pepin | 55091 | 688 | 5 | 0 | 683 | 44.58307413 | -91.99949611 | 2020-12-31 05:22:49 | Pepin, Wisconsin, US |
1013717 | 1013717 | 2020-12-30 | US | Virginia | Westmoreland | 51193 | 692 | 9 | 0 | 683 | 38.11021557 | -76.80213247 | 2020-12-31 05:22:49 | Westmoreland, Virginia, US |
768064 | 768064 | 2020-12-29 | US | Minnesota | Pope | 27121 | 687 | 4 | 0 | 683 | 45.58606667 | -95.44451209 | 2020-12-30 05:22:34 | Pope, Minnesota, US |
3763699 | 3763699 | 2020-12-28 | US | Nebraska | Thurston | 31173 | 692 | 9 | 0 | 683 | 42.15725356 | -96.54157099 | 2020-12-29 05:22:37 | Thurston, Nebraska, US |
3763382 | 3763382 | 2020-12-28 | US | Mississippi | Humphreys | 28053 | 705 | 22 | 0 | 683 | 33.12825718 | -90.52252707 | 2020-12-29 05:22:37 | Humphreys, Mississippi, US |
3763137 | 3763137 | 2020-12-28 | US | Maine | Somerset | 23025 | 704 | 21 | 0 | 683 | 45.51229767 | -69.95995554 | 2020-12-29 05:22:37 | Somerset, Maine, US |
3762644 | 3762644 | 2020-12-28 | US | Indiana | Brown | 18013 | 693 | 10 | 0 | 683 | 39.19605589 | -86.22868909 | 2020-12-29 05:22:37 | Brown, Indiana, US |
3780618 | 3780618 | 2020-12-27 | US | Puerto Rico | Camuy | 72027 | 683 | 0 | 0 | 683 | 18.418578 | -66.860206 | 2020-12-28 05:22:06 | Camuy, Puerto Rico, US |
2223768 | 2223768 | 2020-12-26 | Russia | Voronezh Oblast | 44283 | 1044 | 42556 | 683 | 50.9800393 | 40.15065070000001 | 2020-12-27 05:22:55 | Voronezh Oblast, Russia | ||
3694952 | 3694952 | 2020-12-24 | US | West Virginia | Hardy | 54031 | 689 | 6 | 0 | 683 | 39.00683177 | -78.85855301 | 2020-12-25 05:22:48 | Hardy, West Virginia, US |
3773430 | 3773430 | 2020-12-22 | US | Wisconsin | Menominee | 55078 | 693 | 10 | 0 | 683 | 45.00422544 | -88.70950714 | 2020-12-23 05:22:03 | Menominee, Wisconsin, US |
3773258 | 3773258 | 2020-12-22 | US | Virginia | Powhatan | 51145 | 689 | 6 | 0 | 683 | 37.55016038 | -77.91267882 | 2020-12-23 05:22:03 | Powhatan, Virginia, US |
930840 | 930840 | 2020-12-21 | US | Texas | Live Oak | 48297 | 659 | 10 | 0 | 683 | 28.35101362 | -98.1246786 | 2020-12-22 05:22:33 | Live Oak, Texas, 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]);