johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
484 rows where active = 448 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3295955 | 3295955 | 2021-07-30 | Canada | Saskatchewan | 49940 | 578 | 48914 | 448 | 52.9399 | -106.4509 | 2021-07-31 04:21:35 | Saskatchewan, Canada | ||
1306194 | 1306194 | 2021-07-27 | Japan | Tochigi | 7790 | 84 | 7258 | 448 | 36.689912 | 139.819213 | 2021-07-28 04:21:39 | Tochigi, Japan | ||
3141182 | 3141182 | 2021-07-23 | Ukraine | Kiev Oblast | 128021 | 2765 | 124808 | 448 | 50.053 | 30.7667 | 2021-07-24 00:21:36 | Kiev Oblast, Ukraine | ||
3705919 | 3705919 | 2021-07-17 | Chile | OHiggins | 66869 | 1422 | 64999 | 448 | -34.5755 | -71.0022 | 2021-07-18 04:22:07 | OHiggins, Chile | ||
3362354 | 3362354 | 2021-06-21 | Malaysia | Terengganu | 10955 | 72 | 10435 | 448 | 5.3117 | 103.1324 | 2021-06-22 04:21:34 | Terengganu, Malaysia | ||
3145589 | 3145589 | 2021-06-07 | Japan | Gifu | 8953 | 170 | 8335 | 448 | 35.778671 | 137.055925 | 2021-06-08 04:22:35 | Gifu, Japan | ||
1448797 | 1448797 | 2021-06-03 | Russia | Khakassia Republic | 23223 | 555 | 22220 | 448 | 53.72258845 | 91.44293627 | 2021-06-04 04:23:37 | Khakassia Republic, Russia | ||
1708324 | 1708324 | 2021-06-02 | Japan | Ibaraki | 9797 | 151 | 9198 | 448 | 36.303588 | 140.319591 | 2021-06-03 04:23:32 | Ibaraki, Japan | ||
1188516 | 1188516 | 2021-05-31 | Canada | Nova Scotia | 5567 | 85 | 5034 | 448 | 44.682 | -63.7443 | 2021-06-01 04:23:09 | Nova Scotia, Canada | ||
2259400 | 2259400 | 2021-05-19 | Zambia | 92630 | 1263 | 90919 | 448 | -13.133897 | 27.849332 | 2021-05-20 04:21:05 | Zambia | |||
2411048 | 2411048 | 2021-04-19 | Russia | Kamchatka Krai | 14352 | 213 | 13691 | 448 | 57.1914882 | 160.03838190000005 | 2021-04-20 04:20:41 | Kamchatka Krai, Russia | ||
3129534 | 3129534 | 2021-04-18 | Japan | Ibaraki | 7432 | 129 | 6855 | 448 | 36.303588 | 140.319591 | 2021-04-19 04:20:57 | Ibaraki, Japan | ||
982974 | 982974 | 2021-04-17 | Japan | Nagano | 3470 | 52 | 2970 | 448 | 36.132134 | 138.045528 | 2021-04-18 04:20:41 | Nagano, Japan | ||
2645958 | 2645958 | 2021-04-08 | Russia | Karachay-Cherkess Republic | 19790 | 72 | 19270 | 448 | 43.7368326 | 41.7267991 | 2021-04-09 04:21:13 | Karachay-Cherkess Republic, Russia | ||
2247468 | 2247468 | 2021-04-07 | Mauritius | 1138 | 12 | 707 | 448 | -20.348404 | 57.552152 | 2021-04-08 04:21:13 | Mauritius | |||
1880838 | 1880838 | 2021-03-26 | Colombia | Meta | 43487 | 995 | 42044 | 448 | 3.272 | -73.0877 | 2021-03-27 05:25:04 | Meta, Colombia | ||
1980468 | 1980468 | 2021-03-25 | Colombia | Meta | 43438 | 995 | 41995 | 448 | 3.272 | -73.0877 | 2021-03-26 05:26:55 | Meta, Colombia | ||
702165 | 702165 | 2021-03-16 | Cabo Verde | 16154 | 157 | 15549 | 448 | 16.5388 | -23.0418 | 2021-03-17 05:25:07 | Cabo Verde | |||
3962729 | 3962729 | 2021-03-10 | Russia | Khakassia Republic | 21492 | 479 | 20565 | 448 | 53.72258845 | 91.44293627 | 2021-03-11 05:25:48 | Khakassia Republic, Russia | ||
3668658 | 3668658 | 2021-03-06 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-07 05:21:54 | Scott, Illinois, US |
3668408 | 3668408 | 2021-03-06 | US | Georgia | Echols | 13101 | 455 | 7 | 0 | 448 | 30.71101099 | -82.89687287 | 2021-03-07 05:21:54 | Echols, Georgia, US |
1617279 | 1617279 | 2021-03-05 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-06 04:23:41 | Scott, Illinois, US |
2208690 | 2208690 | 2021-03-04 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-05 05:26:29 | Scott, Illinois, US |
2208440 | 2208440 | 2021-03-04 | US | Georgia | Echols | 13101 | 455 | 7 | 0 | 448 | 30.71101099 | -82.89687287 | 2021-03-05 05:26:29 | Echols, Georgia, US |
1091111 | 1091111 | 2021-03-03 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-04 05:24:24 | Scott, Illinois, US |
3255183 | 3255183 | 2021-03-02 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-03 05:23:28 | Scott, Illinois, US |
3254933 | 3254933 | 2021-03-02 | US | Georgia | Echols | 13101 | 454 | 6 | 0 | 448 | 30.71101099 | -82.89687287 | 2021-03-03 05:23:28 | Echols, Georgia, US |
3253839 | 3253839 | 2021-03-02 | Antigua and Barbuda | 769 | 14 | 307 | 448 | 17.0608 | -61.7964 | 2021-03-03 05:23:28 | Antigua and Barbuda | |||
999475 | 999475 | 2021-03-01 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-02 05:23:30 | Scott, Illinois, US |
998131 | 998131 | 2021-03-01 | Antigua and Barbuda | 769 | 14 | 307 | 448 | 17.0608 | -61.7964 | 2021-03-02 05:23:30 | Antigua and Barbuda | |||
2368533 | 2368533 | 2021-02-28 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-03-01 05:23:01 | Scott, Illinois, US |
3067035 | 3067035 | 2021-02-27 | US | Illinois | Scott | 17171 | 449 | 1 | 0 | 448 | 39.6429169 | -90.47814431 | 2021-02-28 05:22:20 | Scott, Illinois, US |
2185028 | 2185028 | 2021-02-26 | US | Kentucky | Nicholas | 21181 | 454 | 6 | 0 | 448 | 38.33342292 | -84.01889177 | 2021-02-27 05:22:28 | Nicholas, Kentucky, US |
1861223 | 1861223 | 2021-02-25 | US | Texas | Sutton | 48435 | 407 | 8 | 0 | 448 | 30.49856623 | -100.5382014 | 2021-02-26 05:22:40 | Sutton, Texas, US |
533924 | 533924 | 2021-02-22 | US | Texas | Sutton | 48435 | 407 | 8 | 0 | 448 | 30.49856623 | -100.5382014 | 2021-02-23 05:23:41 | Sutton, Texas, US |
530656 | 530656 | 2021-02-22 | India | Jharkhand | 119637 | 1086 | 118103 | 448 | 23.654536 | 85.557631 | 2021-02-23 05:23:41 | Jharkhand, India | ||
185258 | 185258 | 2021-02-21 | US | Texas | Sutton | 48435 | 407 | 8 | 0 | 448 | 30.49856623 | -100.5382014 | 2021-02-22 05:24:21 | Sutton, Texas, US |
745532 | 745532 | 2021-02-20 | US | Texas | Sutton | 48435 | 407 | 8 | 0 | 448 | 30.49856623 | -100.5382014 | 2021-02-21 05:24:33 | Sutton, Texas, US |
742335 | 742335 | 2021-02-20 | Japan | Kyoto | 9008 | 152 | 8408 | 448 | 35.253815 | 135.443341 | 2021-02-21 05:24:33 | Kyoto, Japan | ||
1153026 | 1153026 | 2021-02-18 | Gambia | 4510 | 139 | 3923 | 448 | 13.4432 | -15.3101 | 2021-02-19 05:24:16 | Gambia | |||
2286792 | 2286792 | 2021-02-14 | US | Virginia | Middlesex | 51119 | 464 | 16 | 0 | 448 | 37.63191998 | -76.55064617 | 2021-02-15 05:24:49 | Middlesex, Virginia, US |
2681192 | 2681192 | 2021-02-13 | US | Virginia | Middlesex | 51119 | 464 | 16 | 0 | 448 | 37.63191998 | -76.55064617 | 2021-02-14 05:23:43 | Middlesex, Virginia, US |
3980587 | 3980587 | 2021-02-10 | US | Montana | Pondera | 30073 | 451 | 3 | 0 | 448 | 48.22773388 | -112.2252703 | 2021-02-11 05:23:55 | Pondera, Montana, US |
1529907 | 1529907 | 2021-02-09 | US | Montana | Pondera | 30073 | 451 | 3 | 0 | 448 | 48.22773388 | -112.2252703 | 2021-02-10 05:22:41 | Pondera, Montana, US |
1529776 | 1529776 | 2021-02-09 | US | Missouri | Clark | 29045 | 454 | 6 | 0 | 448 | 40.41040752 | -91.73661677 | 2021-02-10 05:22:41 | Clark, Missouri, US |
615567 | 615567 | 2021-02-08 | US | Missouri | Clark | 29045 | 454 | 6 | 0 | 448 | 40.41040752 | -91.73661677 | 2021-02-09 05:23:30 | Clark, Missouri, US |
1674845 | 1674845 | 2021-02-07 | US | North Dakota | Eddy | 38027 | 450 | 6 | 0 | 448 | 47.71701474 | -98.90432337 | 2021-02-08 05:22:39 | Eddy, North Dakota, US |
1674336 | 1674336 | 2021-02-07 | US | Missouri | Clark | 29045 | 454 | 6 | 0 | 448 | 40.41040752 | -91.73661677 | 2021-02-08 05:22:39 | Clark, Missouri, US |
977666 | 977666 | 2021-02-06 | US | Puerto Rico | Luquillo | 72089 | 448 | 0 | 0 | 448 | 18.342114 | -65.72509699999999 | 2021-02-07 05:23:00 | Luquillo, Puerto Rico, US |
977306 | 977306 | 2021-02-06 | US | North Dakota | Eddy | 38027 | 449 | 6 | 0 | 448 | 47.71701474 | -98.90432337 | 2021-02-07 05:23:00 | Eddy, North Dakota, US |
1590924 | 1590924 | 2021-02-05 | US | Puerto Rico | Luquillo | 72089 | 448 | 0 | 0 | 448 | 18.342114 | -65.72509699999999 | 2021-02-06 05:23:55 | Luquillo, Puerto Rico, US |
1589568 | 1589568 | 2021-02-05 | US | Kentucky | Fulton | 21075 | 452 | 4 | 0 | 448 | 36.55238827 | -89.20140068 | 2021-02-06 05:23:55 | Fulton, Kentucky, US |
793131 | 793131 | 2021-02-04 | US | Puerto Rico | Luquillo | 72089 | 448 | 0 | 0 | 448 | 18.342114 | -65.72509699999999 | 2021-02-05 05:22:38 | Luquillo, Puerto Rico, US |
343023 | 343023 | 2021-02-03 | US | Puerto Rico | Luquillo | 72089 | 448 | 0 | 0 | 448 | 18.342114 | -65.72509699999999 | 2021-02-04 05:22:26 | Luquillo, Puerto Rico, US |
342335 | 342335 | 2021-02-03 | US | Nebraska | Fillmore | 31059 | 457 | 9 | 0 | 448 | 40.52458567 | -97.59646937 | 2021-02-04 05:22:26 | Fillmore, Nebraska, US |
1687249 | 1687249 | 2021-02-02 | US | Puerto Rico | Luquillo | 72089 | 448 | 0 | 0 | 448 | 18.342114 | -65.72509699999999 | 2021-02-03 05:22:52 | Luquillo, Puerto Rico, US |
1687047 | 1687047 | 2021-02-02 | US | Oklahoma | Greer | 40055 | 461 | 13 | 0 | 448 | 34.93535801 | -99.5605612 | 2021-02-03 05:22:52 | Greer, Oklahoma, US |
1679017 | 1679017 | 2021-02-01 | US | Oklahoma | Greer | 40055 | 461 | 13 | 0 | 448 | 34.93535801 | -99.5605612 | 2021-02-02 05:22:49 | Greer, Oklahoma, US |
1678531 | 1678531 | 2021-02-01 | US | Nebraska | Fillmore | 31059 | 457 | 9 | 0 | 448 | 40.52458567 | -97.59646937 | 2021-02-02 05:22:49 | Fillmore, Nebraska, US |
1676960 | 1676960 | 2021-02-01 | US | Arkansas | Lafayette | 5073 | 455 | 7 | 0 | 448 | 33.24116713 | -93.60677071 | 2021-02-02 05:22:49 | Lafayette, Arkansas, US |
1462305 | 1462305 | 2021-01-31 | US | Oklahoma | Greer | 40055 | 461 | 13 | 0 | 448 | 34.93535801 | -99.5605612 | 2021-02-01 05:22:53 | Greer, Oklahoma, US |
1461819 | 1461819 | 2021-01-31 | US | Nebraska | Fillmore | 31059 | 457 | 9 | 0 | 448 | 40.52458567 | -97.59646937 | 2021-02-01 05:22:53 | Fillmore, Nebraska, US |
2213620 | 2213620 | 2021-01-30 | US | Missouri | Shannon | 29203 | 458 | 10 | 0 | 448 | 37.15772072 | -91.40190382 | 2021-01-31 05:22:42 | Shannon, Missouri, US |
1900012 | 1900012 | 2021-01-29 | US | South Dakota | Edmunds | 46045 | 457 | 9 | 0 | 448 | 45.41846445 | -99.21545423 | 2021-01-30 05:22:49 | Edmunds, South Dakota, US |
2484828 | 2484828 | 2021-01-28 | US | South Dakota | Edmunds | 46045 | 457 | 9 | 0 | 448 | 45.41846445 | -99.21545423 | 2021-01-29 05:22:23 | Edmunds, South Dakota, US |
3156463 | 3156463 | 2021-01-27 | US | South Dakota | Edmunds | 46045 | 456 | 8 | 0 | 448 | 45.41846445 | -99.21545423 | 2021-01-28 05:22:24 | Edmunds, South Dakota, US |
15195 | 15195 | 2021-01-26 | US | South Dakota | Deuel | 46039 | 455 | 7 | 0 | 448 | 44.75994309 | -96.66943645 | 2021-01-27 05:23:41 | Deuel, South Dakota, US |
15191 | 15191 | 2021-01-26 | US | South Dakota | Corson | 46031 | 459 | 11 | 0 | 448 | 45.70889983 | -101.1970473 | 2021-01-27 05:23:41 | Corson, South Dakota, US |
14455 | 14455 | 2021-01-26 | US | Nebraska | Thayer | 31169 | 451 | 3 | 0 | 448 | 40.17626377 | -97.59504381 | 2021-01-27 05:23:41 | Thayer, Nebraska, US |
2570515 | 2570515 | 2021-01-25 | US | South Dakota | Corson | 46031 | 459 | 11 | 0 | 448 | 45.70889983 | -101.1970473 | 2021-01-26 05:22:02 | Corson, South Dakota, US |
1762147 | 1762147 | 2021-01-24 | US | South Dakota | Corson | 46031 | 459 | 11 | 0 | 448 | 45.70889983 | -101.1970473 | 2021-01-25 05:22:16 | Corson, South Dakota, US |
2429754 | 2429754 | 2021-01-23 | US | South Dakota | Corson | 46031 | 459 | 11 | 0 | 448 | 45.70889983 | -101.1970473 | 2021-01-24 05:22:35 | Corson, South Dakota, US |
2428935 | 2428935 | 2021-01-23 | US | Nebraska | Antelope | 31003 | 454 | 6 | 0 | 448 | 42.17695516 | -98.0666283 | 2021-01-24 05:22:35 | Antelope, Nebraska, US |
2469861 | 2469861 | 2021-01-22 | US | Texas | Dallam | 48111 | 856 | 20 | 0 | 448 | 36.27787176 | -102.6020725 | 2021-01-23 05:22:03 | Dallam, Texas, US |
2468837 | 2468837 | 2021-01-22 | US | Nebraska | Antelope | 31003 | 454 | 6 | 0 | 448 | 42.17695516 | -98.0666283 | 2021-01-23 05:22:03 | Antelope, Nebraska, US |
2467762 | 2467762 | 2021-01-22 | US | Illinois | Calhoun | 17013 | 449 | 1 | 0 | 448 | 39.16840183 | -90.66330078 | 2021-01-23 05:22:03 | Calhoun, Illinois, US |
438412 | 438412 | 2021-01-21 | US | Texas | Dallam | 48111 | 856 | 20 | 0 | 448 | 36.27787176 | -102.6020725 | 2021-01-22 05:22:10 | Dallam, Texas, US |
1097143 | 1097143 | 2021-01-20 | US | Texas | Dallam | 48111 | 856 | 20 | 0 | 448 | 36.27787176 | -102.6020725 | 2021-01-21 05:22:01 | Dallam, Texas, US |
239785 | 239785 | 2021-01-18 | US | Oklahoma | Grant | 40053 | 453 | 5 | 0 | 448 | 36.796297 | -97.78638765 | 2021-01-19 05:22:15 | Grant, Oklahoma, US |
3104821 | 3104821 | 2021-01-16 | US | Virginia | Poquoson | 51735 | 455 | 7 | 0 | 448 | 37.14259351 | -76.35798148 | 2021-01-17 05:22:17 | Poquoson, Virginia, US |
3101187 | 3101187 | 2021-01-16 | Brazil | Piaui | 151397 | 2950 | 147653 | 448 | -7.7183 | -42.7289 | 2021-01-17 05:22:17 | Piaui, Brazil | ||
3516038 | 3516038 | 2021-01-15 | US | Colorado | Park | 8093 | 479 | 5 | 0 | 448 | 39.120926 | -105.7182065 | 2021-01-16 05:22:40 | Park, Colorado, US |
3515253 | 3515253 | 2021-01-15 | Colombia | La Guajira | 14852 | 571 | 13833 | 448 | 11.3548 | -72.5205 | 2021-01-16 05:22:40 | La Guajira, Colombia | ||
3881265 | 3881265 | 2021-01-14 | US | Minnesota | Big Stone | 27011 | 451 | 3 | 0 | 448 | 45.42712824 | -96.41403739 | 2021-01-15 05:22:24 | Big Stone, Minnesota, US |
3311569 | 3311569 | 2021-01-13 | US | Virginia | Nelson | 51125 | 452 | 4 | 0 | 448 | 37.78790447 | -78.88498513 | 2021-01-14 05:22:32 | Nelson, Virginia, US |
3309892 | 3309892 | 2021-01-13 | US | Minnesota | Big Stone | 27011 | 451 | 3 | 0 | 448 | 45.42712824 | -96.41403739 | 2021-01-14 05:22:32 | Big Stone, Minnesota, US |
777704 | 777704 | 2021-01-12 | US | Virginia | Lunenburg | 51111 | 451 | 3 | 0 | 448 | 36.94618528 | -78.24133319 | 2021-01-13 05:22:15 | Lunenburg, Virginia, US |
776671 | 776671 | 2021-01-12 | US | North Carolina | Jones | 37103 | 464 | 16 | 0 | 448 | 35.02254606 | -77.35870791 | 2021-01-13 05:22:15 | Jones, North Carolina, US |
193379 | 193379 | 2021-01-11 | US | Virginia | Clarke | 51043 | 454 | 6 | 0 | 448 | 39.11271747 | -77.99199425 | 2021-01-12 05:22:15 | Clarke, Virginia, US |
192799 | 192799 | 2021-01-11 | US | Puerto Rico | Guayama | 72057 | 448 | 0 | 0 | 448 | 18.007516 | -66.13390799999999 | 2021-01-12 05:22:15 | Guayama, Puerto Rico, US |
190688 | 190688 | 2021-01-11 | US | Colorado | Kit Carson | 8063 | 500 | 10 | 0 | 448 | 39.30497777 | -102.6022199 | 2021-01-12 05:22:15 | Kit Carson, Colorado, US |
2628195 | 2628195 | 2021-01-10 | US | North Carolina | Jones | 37103 | 464 | 16 | 0 | 448 | 35.02254606 | -77.35870791 | 2021-01-11 05:21:50 | Jones, North Carolina, US |
2627785 | 2627785 | 2021-01-10 | US | Missouri | Linn | 29115 | 458 | 10 | 0 | 448 | 39.87001769 | -93.10704106 | 2021-01-11 05:21:50 | Linn, Missouri, US |
2543940 | 2543940 | 2021-01-07 | US | Oklahoma | Cotton | 40033 | 459 | 11 | 0 | 448 | 34.28845626 | -98.37053567 | 2021-01-08 05:22:42 | Cotton, Oklahoma, US |
2867917 | 2867917 | 2021-01-06 | US | Texas | San Augustine | 48405 | 345 | 25 | 0 | 448 | 31.39457611 | -94.17000399 | 2021-01-07 05:22:03 | San Augustine, Texas, US |
2865541 | 2865541 | 2021-01-06 | US | Georgia | Lincoln | 13181 | 460 | 12 | 0 | 448 | 33.79201475 | -82.45024131 | 2021-01-07 05:22:03 | Lincoln, Georgia, US |
3037160 | 3037160 | 2021-01-05 | US | South Dakota | Fall River | 46047 | 460 | 12 | 0 | 448 | 43.23929297 | -103.5275691 | 2021-01-06 05:22:16 | Fall River, South Dakota, US |
3035649 | 3035649 | 2021-01-05 | US | Kansas | Wabaunsee | 20197 | 456 | 8 | 0 | 448 | 38.95471985 | -96.20350509 | 2021-01-06 05:22:16 | Wabaunsee, Kansas, US |
3034924 | 3034924 | 2021-01-05 | US | Colorado | Lake | 8065 | 466 | 0 | 0 | 448 | 39.20278823 | -106.3555697 | 2021-01-06 05:22:16 | Lake, Colorado, US |
1063194 | 1063194 | 2021-01-04 | US | Kansas | Wabaunsee | 20197 | 456 | 8 | 0 | 448 | 38.95471985 | -96.20350509 | 2021-01-05 05:21:49 | Wabaunsee, 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]);