johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
251 rows where active = 899 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371474 | 2371474 | 2021-07-20 | India | Punjab | 598455 | 16244 | 581312 | 899 | 30.841465000000003 | 75.40879 | 2021-07-21 04:21:40 | Punjab, India | ||
2674021 | 2674021 | 2021-07-18 | Russia | Karachay-Cherkess Republic | 21641 | 228 | 20514 | 899 | 43.7368326 | 41.7267991 | 2021-07-19 04:21:24 | Karachay-Cherkess Republic, Russia | ||
295868 | 295868 | 2021-07-15 | Colombia | Quindio | 52154 | 1556 | 49699 | 899 | 4.461 | -75.6674 | 2021-07-16 04:21:22 | Quindio, Colombia | ||
1893348 | 1893348 | 2021-06-30 | Russia | Kamchatka Krai | 15275 | 238 | 14138 | 899 | 57.1914882 | 160.03838190000005 | 2021-07-01 04:21:19 | Kamchatka Krai, Russia | ||
3970327 | 3970327 | 2021-06-11 | Canada | Saskatchewan | 47769 | 554 | 46311 | 899 | 52.9399 | -106.4509 | 2021-06-12 04:22:22 | Saskatchewan, Canada | ||
380468 | 380468 | 2021-04-30 | Sierra Leone | 4054 | 79 | 3076 | 899 | 8.460555000000001 | -11.779889 | 2021-05-01 04:20:47 | Sierra Leone | |||
1636591 | 1636591 | 2021-04-29 | Sierra Leone | 4053 | 79 | 3075 | 899 | 8.460555000000001 | -11.779889 | 2021-04-30 04:21:03 | Sierra Leone | |||
3643623 | 3643623 | 2021-03-30 | Malta | 28993 | 390 | 27704 | 899 | 35.9375 | 14.3754 | 2021-03-31 04:26:25 | Malta | |||
3420864 | 3420864 | 2021-03-19 | India | Goa | 56371 | 815 | 54657 | 899 | 15.359682 | 74.057396 | 2021-03-20 05:25:46 | Goa, India | ||
3966186 | 3966186 | 2021-03-10 | Zimbabwe | 36341 | 1489 | 33953 | 899 | -19.015438 | 29.154857 | 2021-03-11 05:25:48 | Zimbabwe | |||
3962469 | 3962469 | 2021-03-10 | India | Jammu and Kashmir | 127288 | 1968 | 124421 | 899 | 33.75943 | 76.612638 | 2021-03-11 05:25:48 | Jammu and Kashmir, India | ||
2359312 | 2359312 | 2021-03-08 | Colombia | Cordoba | 38503 | 1865 | 35739 | 899 | 8.0493 | -75.574 | 2021-03-09 05:28:19 | Cordoba, Colombia | ||
3670678 | 3670678 | 2021-03-06 | US | Texas | Dallam | 48111 | 1309 | 22 | 0 | 899 | 36.27787176 | -102.6020725 | 2021-03-07 05:21:54 | Dallam, Texas, US |
1619299 | 1619299 | 2021-03-05 | US | Texas | Dallam | 48111 | 1309 | 22 | 0 | 899 | 36.27787176 | -102.6020725 | 2021-03-06 04:23:41 | Dallam, Texas, US |
998296 | 998296 | 2021-03-01 | Colombia | Risaralda | 46153 | 1144 | 44110 | 899 | 5.3158 | -75.9928 | 2021-03-02 05:23:30 | Risaralda, Colombia | ||
2367962 | 2367962 | 2021-02-28 | US | Arkansas | Cleveland | 5025 | 922 | 23 | 0 | 899 | 33.89723187 | -92.18537045 | 2021-03-01 05:23:01 | Cleveland, Arkansas, US |
3068036 | 3068036 | 2021-02-27 | US | Nebraska | Box Butte | 31013 | 907 | 8 | 0 | 899 | 42.22079243 | -103.0878834 | 2021-02-28 05:22:20 | Box Butte, Nebraska, US |
2185620 | 2185620 | 2021-02-26 | US | Nebraska | Box Butte | 31013 | 907 | 8 | 0 | 899 | 42.22079243 | -103.0878834 | 2021-02-27 05:22:28 | Box Butte, Nebraska, US |
282958 | 282958 | 2021-02-24 | US | Puerto Rico | Unassigned | 72999 | 2906 | 2007 | 0 | 899 | 18.459681 | -67.336525 | 2021-02-25 05:24:57 | Unassigned, Puerto Rico, US |
281241 | 281241 | 2021-02-24 | US | Indiana | Benton | 18007 | 912 | 13 | 0 | 899 | 40.60626947 | -87.31093999 | 2021-02-25 05:24:57 | Benton, Indiana, US |
1938054 | 1938054 | 2021-02-23 | US | Michigan | Antrim | 26009 | 918 | 19 | 0 | 899 | 44.99690221 | -85.15503082 | 2021-02-24 05:29:16 | Antrim, Michigan, US |
532137 | 532137 | 2021-02-22 | US | Kentucky | Martin | 21159 | 910 | 11 | 0 | 899 | 37.79990579 | -82.51247478 | 2021-02-23 05:23:41 | Martin, Kentucky, US |
183818 | 183818 | 2021-02-21 | US | Mississippi | Benton | 28009 | 923 | 24 | 0 | 899 | 34.81681228 | -89.18945516 | 2021-02-22 05:24:21 | Benton, Mississippi, US |
744092 | 744092 | 2021-02-20 | US | Mississippi | Benton | 28009 | 923 | 24 | 0 | 899 | 34.81681228 | -89.18945516 | 2021-02-21 05:24:33 | Benton, Mississippi, US |
473190 | 473190 | 2021-02-19 | US | Mississippi | Benton | 28009 | 923 | 24 | 0 | 899 | 34.81681228 | -89.18945516 | 2021-02-20 05:22:51 | Benton, Mississippi, US |
472473 | 472473 | 2021-02-19 | US | Indiana | Brown | 18013 | 938 | 39 | 0 | 899 | 39.19605589 | -86.22868909 | 2021-02-20 05:22:51 | Brown, Indiana, US |
471266 | 471266 | 2021-02-19 | Colombia | Norte de Santander | 50334 | 2680 | 46755 | 899 | 7.9463 | -72.8988 | 2021-02-20 05:22:51 | Norte de Santander, Colombia | ||
1154899 | 1154899 | 2021-02-18 | US | Mississippi | Benton | 28009 | 923 | 24 | 0 | 899 | 34.81681228 | -89.18945516 | 2021-02-19 05:24:16 | Benton, Mississippi, US |
1154182 | 1154182 | 2021-02-18 | US | Indiana | Brown | 18013 | 938 | 39 | 0 | 899 | 39.19605589 | -86.22868909 | 2021-02-19 05:24:16 | Brown, Indiana, US |
3602819 | 3602819 | 2021-02-17 | US | Mississippi | Benton | 28009 | 923 | 24 | 0 | 899 | 34.81681228 | -89.18945516 | 2021-02-18 05:22:58 | Benton, Mississippi, US |
3539995 | 3539995 | 2021-02-12 | US | California | Del Norte | 6015 | 905 | 2 | 0 | 899 | 41.74228275 | -123.8974063 | 2021-02-13 05:22:12 | Del Norte, California, US |
1529178 | 1529178 | 2021-02-09 | US | Kansas | Grant | 20067 | 914 | 15 | 0 | 899 | 37.56227336 | -101.3079758 | 2021-02-10 05:22:41 | Grant, Kansas, US |
1527918 | 1527918 | 2021-02-09 | Japan | Kyoto | 8798 | 139 | 7760 | 899 | 35.253815 | 135.443341 | 2021-02-10 05:22:41 | Kyoto, Japan | ||
1527692 | 1527692 | 2021-02-09 | Chile | OHiggins | 27512 | 698 | 25915 | 899 | -34.5755 | -71.0022 | 2021-02-10 05:22:41 | OHiggins, Chile | ||
615826 | 615826 | 2021-02-08 | US | Nevada | Pershing | 32027 | 918 | 19 | 0 | 899 | 40.44003782 | -118.40056409999998 | 2021-02-09 05:23:30 | Pershing, Nevada, US |
614969 | 614969 | 2021-02-08 | US | Kansas | Grant | 20067 | 914 | 15 | 0 | 899 | 37.56227336 | -101.3079758 | 2021-02-09 05:23:30 | Grant, Kansas, US |
1674595 | 1674595 | 2021-02-07 | US | Nevada | Pershing | 32027 | 918 | 19 | 0 | 899 | 40.44003782 | -118.40056409999998 | 2021-02-08 05:22:39 | Pershing, Nevada, US |
977056 | 977056 | 2021-02-06 | US | Nevada | Pershing | 32027 | 918 | 19 | 0 | 899 | 40.44003782 | -118.40056409999998 | 2021-02-07 05:23:00 | Pershing, Nevada, US |
1590663 | 1590663 | 2021-02-05 | US | Ohio | Morgan | 39115 | 920 | 21 | 0 | 899 | 39.62081738 | -81.85308173 | 2021-02-06 05:23:55 | Morgan, Ohio, US |
342059 | 342059 | 2021-02-03 | US | Mississippi | Claiborne | 28021 | 926 | 27 | 0 | 899 | 31.97061673 | -90.90702196 | 2021-02-04 05:22:26 | Claiborne, Mississippi, US |
341662 | 341662 | 2021-02-03 | US | Kentucky | Estill | 21065 | 899 | 0 | 0 | 899 | 37.69241417 | -83.95956369 | 2021-02-04 05:22:26 | Estill, Kentucky, US |
1463418 | 1463418 | 2021-01-31 | Uzbekistan | 78711 | 621 | 77191 | 899 | 41.377491 | 64.585262 | 2021-02-01 05:22:53 | Uzbekistan | |||
2215326 | 2215326 | 2021-01-30 | Uzbekistan | 78711 | 621 | 77191 | 899 | 41.377491 | 64.585262 | 2021-01-31 05:22:42 | Uzbekistan | |||
1900840 | 1900840 | 2021-01-29 | Malaysia | Terengganu | 1976 | 4 | 1073 | 899 | 5.3117 | 103.1324 | 2021-01-30 05:22:49 | Terengganu, Malaysia | ||
2484243 | 2484243 | 2021-01-28 | US | New York | Yates | 36123 | 921 | 22 | 0 | 899 | 42.63505484 | -77.10369919 | 2021-01-29 05:22:23 | Yates, New York, US |
13450 | 13450 | 2021-01-26 | US | Indiana | Newton | 18111 | 926 | 27 | 0 | 899 | 40.95610449 | -87.39635768 | 2021-01-27 05:23:41 | Newton, Indiana, US |
2568277 | 2568277 | 2021-01-25 | US | Colorado | Grand | 8049 | 939 | 5 | 0 | 899 | 40.10603347 | -106.1178042 | 2021-01-26 05:22:02 | Grand, Colorado, US |
2469551 | 2469551 | 2021-01-22 | US | Puerto Rico | Las Piedras | 72085 | 899 | 0 | 0 | 899 | 18.187527 | -65.86946800000001 | 2021-01-23 05:22:03 | Las Piedras, Puerto Rico, US |
2468541 | 2468541 | 2021-01-22 | US | Minnesota | Murray | 27101 | 905 | 6 | 0 | 899 | 44.02216709 | -95.76328482 | 2021-01-23 05:22:03 | Murray, Minnesota, US |
2467543 | 2467543 | 2021-01-22 | US | Georgia | Atkinson | 13003 | 911 | 12 | 0 | 899 | 31.29633502 | -82.87545866 | 2021-01-23 05:22:03 | Atkinson, Georgia, US |
438770 | 438770 | 2021-01-21 | US | Virginia | Westmoreland | 51193 | 913 | 14 | 0 | 899 | 38.11021557 | -76.80213247 | 2021-01-22 05:22:10 | Westmoreland, Virginia, US |
1095308 | 1095308 | 2021-01-20 | US | Iowa | Palo Alto | 19147 | 909 | 10 | 0 | 899 | 43.08193849 | -94.67824621 | 2021-01-21 05:22:01 | Palo Alto, Iowa, US |
910947 | 910947 | 2021-01-19 | US | Puerto Rico | San Sebastian | 72131 | 899 | 0 | 0 | 899 | 18.328646 | -66.971214 | 2021-01-20 05:21:54 | San Sebastian, Puerto Rico, US |
240830 | 240830 | 2021-01-18 | US | Wyoming | Big Horn | 56003 | 921 | 22 | 0 | 899 | 44.52405055 | -107.9960365 | 2021-01-19 05:22:15 | Big Horn, Wyoming, US |
3103586 | 3103586 | 2021-01-16 | US | New Hampshire | Coos | 33007 | 919 | 20 | 0 | 899 | 44.69063265 | -71.30633239 | 2021-01-17 05:22:17 | Coos, New Hampshire, US |
3518432 | 3518432 | 2021-01-15 | US | Texas | Callahan | 48059 | 917 | 27 | 0 | 899 | 32.29760619 | -99.37326312 | 2021-01-16 05:22:40 | Callahan, Texas, US |
3882863 | 3882863 | 2021-01-14 | US | Virginia | Alleghany | 51005 | 926 | 27 | 0 | 899 | 37.78636074 | -80.00222498 | 2021-01-15 05:22:24 | Alleghany, Virginia, US |
3882604 | 3882604 | 2021-01-14 | US | Texas | Callahan | 48059 | 915 | 25 | 0 | 899 | 32.29760619 | -99.37326312 | 2021-01-15 05:22:24 | Callahan, Texas, US |
3881934 | 3881934 | 2021-01-14 | US | North Carolina | Swain | 37173 | 907 | 8 | 0 | 899 | 35.48665845 | -83.48748932 | 2021-01-15 05:22:24 | Swain, North Carolina, US |
3881695 | 3881695 | 2021-01-14 | US | Nebraska | Wayne | 31179 | 905 | 6 | 0 | 899 | 42.20934475 | -97.11926964 | 2021-01-15 05:22:24 | Wayne, Nebraska, US |
3880695 | 3880695 | 2021-01-14 | US | Indiana | Pulaski | 18131 | 936 | 37 | 0 | 899 | 41.04166107 | -86.69890683 | 2021-01-15 05:22:24 | Pulaski, Indiana, US |
3310804 | 3310804 | 2021-01-13 | US | Oregon | Coos | 41011 | 913 | 14 | 0 | 899 | 43.17406868 | -124.0594514 | 2021-01-14 05:22:32 | Coos, Oregon, US |
3903439 | 3903439 | 2021-01-09 | US | West Virginia | Lincoln | 54043 | 908 | 9 | 0 | 899 | 38.172154 | -82.07017953 | 2021-01-10 05:22:12 | Lincoln, West Virginia, US |
156826 | 156826 | 2021-01-08 | US | South Dakota | Butte | 46019 | 917 | 18 | 0 | 899 | 44.90608745 | -103.5079318 | 2021-01-09 05:22:18 | Butte, South Dakota, US |
153928 | 153928 | 2021-01-08 | India | Goa | 51626 | 744 | 49983 | 899 | 15.359682 | 74.057396 | 2021-01-09 05:22:18 | Goa, India | ||
2541352 | 2541352 | 2021-01-07 | India | Goa | 51626 | 744 | 49983 | 899 | 15.359682 | 74.057396 | 2021-01-08 05:22:42 | Goa, India | ||
3035672 | 3035672 | 2021-01-05 | US | Kentucky | Caldwell | 21033 | 915 | 16 | 0 | 899 | 37.14749129 | -87.86948214 | 2021-01-06 05:22:16 | Caldwell, Kentucky, US |
3034723 | 3034723 | 2021-01-05 | US | Alaska | Kusilvak | 2158 | 901 | 2 | 0 | 899 | 62.15429159999999 | -163.39678830000003 | 2021-01-06 05:22:16 | Kusilvak, Alaska, US |
1064831 | 1064831 | 2021-01-04 | US | Tennessee | Stewart | 47161 | 934 | 20 | 0 | 899 | 36.50235092 | -87.83920548 | 2021-01-05 05:21:49 | Stewart, Tennessee, US |
3231004 | 3231004 | 2021-01-03 | US | California | Mono | 6051 | 905 | 3 | 0 | 899 | 37.93899289 | -118.8872409 | 2021-01-04 05:22:02 | Mono, California, US |
2227740 | 2227740 | 2021-01-02 | Russia | Mari El Republic | 9284 | 121 | 8264 | 899 | 56.5767504 | 47.8817512 | 2021-01-03 05:22:52 | Mari El Republic, Russia | ||
3698569 | 3698569 | 2020-12-31 | US | Texas | Freestone | 48161 | 1152 | 23 | 0 | 899 | 31.70422788 | -96.15072516 | 2021-01-01 05:23:07 | Freestone, Texas, US |
2224901 | 2224901 | 2020-12-26 | US | Kentucky | Garrard | 21079 | 903 | 4 | 0 | 899 | 37.6388668 | -84.53289319 | 2020-12-27 05:22:55 | Garrard, Kentucky, US |
3692629 | 3692629 | 2020-12-24 | US | Iowa | Appanoose | 19007 | 933 | 34 | 0 | 899 | 40.74324454 | -92.86865906 | 2020-12-25 05:22:48 | Appanoose, Iowa, US |
2408677 | 2408677 | 2020-12-23 | US | Mississippi | Walthall | 28147 | 932 | 33 | 0 | 899 | 31.14971548 | -90.10446654 | 2020-12-24 05:23:04 | Walthall, Mississippi, US |
929673 | 929673 | 2020-12-21 | US | Montana | Custer | 30017 | 907 | 8 | 0 | 899 | 46.25319932 | -105.57375259999998 | 2020-12-22 05:22:33 | Custer, Montana, US |
929513 | 929513 | 2020-12-21 | US | Mississippi | Montgomery | 28097 | 929 | 30 | 0 | 899 | 33.49419589 | -89.61729103 | 2020-12-22 05:22:33 | Montgomery, Mississippi, US |
929112 | 929112 | 2020-12-21 | US | Kentucky | Letcher | 21133 | 902 | 3 | 0 | 899 | 37.12306748 | -82.85346474 | 2020-12-22 05:22:33 | Letcher, Kentucky, US |
2121694 | 2121694 | 2020-12-20 | US | Montana | Custer | 30017 | 907 | 8 | 0 | 899 | 46.25319932 | -105.57375259999998 | 2020-12-21 05:27:58 | Custer, Montana, US |
2121205 | 2121205 | 2020-12-20 | US | Louisiana | East Carroll | 22035 | 913 | 14 | 0 | 899 | 32.73926954 | -91.23425694 | 2020-12-21 05:27:58 | East Carroll, Louisiana, US |
2933593 | 2933593 | 2020-12-19 | US | North Carolina | Yancey | 37199 | 904 | 5 | 0 | 899 | 35.90079156 | -82.31237181 | 2020-12-20 05:27:32 | Yancey, North Carolina, US |
2933201 | 2933201 | 2020-12-19 | US | Montana | Custer | 30017 | 907 | 8 | 0 | 899 | 46.25319932 | -105.57375259999998 | 2020-12-20 05:27:32 | Custer, Montana, US |
2933057 | 2933057 | 2020-12-19 | US | Mississippi | Smith | 28129 | 916 | 17 | 0 | 899 | 32.01744532 | -89.50644846 | 2020-12-20 05:27:32 | Smith, Mississippi, US |
1901815 | 1901815 | 2020-12-18 | US | Colorado | Teller | 8119 | 980 | 10 | 0 | 899 | 38.88133511 | -105.1614893 | 2020-12-19 05:27:52 | Teller, Colorado, US |
3150716 | 3150716 | 2020-12-16 | US | Indiana | Rush | 18139 | 910 | 11 | 0 | 899 | 39.62002287 | -85.4655599 | 2020-12-17 05:28:12 | Rush, Indiana, US |
3150641 | 3150641 | 2020-12-16 | US | Illinois | White | 17193 | 911 | 12 | 0 | 899 | 38.08706198 | -88.17657461 | 2020-12-17 05:28:12 | White, Illinois, US |
3850859 | 3850859 | 2020-12-13 | US | Texas | Falls | 48145 | 962 | 15 | 0 | 899 | 31.25350609 | -96.93630086 | 2020-12-14 05:26:27 | Falls, Texas, US |
848502 | 848502 | 2020-12-12 | US | Tennessee | Grundy | 47061 | 948 | 14 | 0 | 899 | 35.38433717 | -85.72142731 | 2020-12-13 05:27:20 | Grundy, Tennessee, US |
848382 | 848382 | 2020-12-12 | US | South Carolina | Hampton | 45049 | 934 | 35 | 0 | 899 | 32.77419582 | -81.13845571 | 2020-12-13 05:27:20 | Hampton, South Carolina, US |
847004 | 847004 | 2020-12-12 | US | Kentucky | Meade | 21163 | 903 | 4 | 0 | 899 | 37.96163597 | -86.21028219 | 2020-12-13 05:27:20 | Meade, Kentucky, US |
1603799 | 1603799 | 2020-12-10 | US | Wisconsin | Washburn | 55129 | 907 | 8 | 0 | 899 | 45.89838588 | -91.79050449 | 2020-12-11 05:26:59 | Washburn, Wisconsin, US |
1603037 | 1603037 | 2020-12-10 | US | South Carolina | Lee | 45061 | 939 | 40 | 0 | 899 | 34.16393091 | -80.25690731 | 2020-12-11 05:26:59 | Lee, South Carolina, US |
1602407 | 1602407 | 2020-12-10 | US | New Mexico | Lincoln | 35027 | 907 | 8 | 0 | 899 | 33.74526079 | -105.4586166 | 2020-12-11 05:26:59 | Lincoln, New Mexico, US |
1600222 | 1600222 | 2020-12-10 | Japan | Chiba | 7825 | 95 | 6831 | 899 | 35.510141 | 140.198917 | 2020-12-11 05:26:59 | Chiba, Japan | ||
2975421 | 2975421 | 2020-12-09 | Russia | Chuvashia Republic | 13654 | 340 | 12415 | 899 | 55.4259922 | 47.0849429 | 2020-12-10 05:26:19 | Chuvashia Republic, Russia | ||
1820644 | 1820644 | 2020-12-08 | US | Missouri | Andrew | 29003 | 911 | 12 | 0 | 899 | 39.98492163 | -94.80163024 | 2020-12-09 05:28:01 | Andrew, Missouri, US |
1008859 | 1008859 | 2020-12-06 | US | Oklahoma | McIntosh | 40091 | 912 | 13 | 0 | 899 | 35.37235506 | -95.66599306 | 2020-12-07 05:26:14 | McIntosh, Oklahoma, US |
3860980 | 3860980 | 2020-12-04 | US | Iowa | Allamakee | 19005 | 912 | 13 | 0 | 899 | 43.28383218 | -91.37860922 | 2020-12-05 05:27:36 | Allamakee, Iowa, US |
77197 | 77197 | 2020-12-03 | US | Nebraska | Seward | 31159 | 908 | 9 | 0 | 899 | 40.87241834 | -97.139673 | 2020-12-04 05:27:27 | Seward, Nebraska, US |
76338 | 76338 | 2020-12-03 | US | Kansas | Atchison | 20005 | 908 | 9 | 0 | 899 | 39.53185661 | -95.30870026 | 2020-12-04 05:27:27 | Atchison, Kansas, 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]);