johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
270 rows where active = 763 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015191 | 3015191 | 2021-08-01 | Colombia | Casanare | 34181 | 869 | 32549 | 763 | 5.7589 | -71.5724 | 2021-08-02 04:21:36 | Casanare, Colombia | ||
483871 | 483871 | 2021-07-19 | Slovenia | 258199 | 4425 | 253011 | 763 | 46.1512 | 14.9955 | 2021-07-20 04:21:48 | Slovenia | |||
2693451 | 2693451 | 2021-07-06 | Canada | Alberta | 232269 | 2305 | 229201 | 763 | 53.9333 | -116.5765 | 2021-07-07 04:21:20 | Alberta, Canada | ||
1125371 | 1125371 | 2021-06-18 | Canada | Saskatchewan | 48327 | 562 | 47002 | 763 | 52.9399 | -106.4509 | 2021-06-19 04:22:33 | Saskatchewan, Canada | ||
2339232 | 2339232 | 2021-06-15 | Colombia | Bolivar | 115359 | 2234 | 112362 | 763 | 8.6704 | -74.03 | 2021-06-16 04:22:32 | Bolivar, Colombia | ||
1563928 | 1563928 | 2021-06-14 | Colombia | Bolivar | 115359 | 2234 | 112362 | 763 | 8.6704 | -74.03 | 2021-06-15 04:22:22 | Bolivar, Colombia | ||
3384994 | 3384994 | 2021-06-13 | Ukraine | Chernivtsi Oblast | 79690 | 1785 | 77142 | 763 | 48.2917 | 25.9352 | 2021-06-14 04:22:46 | Chernivtsi Oblast, Ukraine | ||
3145799 | 3145799 | 2021-06-07 | Russia | Kursk Oblast | 38880 | 840 | 37277 | 763 | 51.6568453 | 36.4852695 | 2021-06-08 04:22:35 | Kursk Oblast, Russia | ||
24039 | 24039 | 2021-05-28 | Zimbabwe | 38918 | 1592 | 36563 | 763 | -19.015438 | 29.154857 | 2021-05-29 04:20:41 | Zimbabwe | |||
1310025 | 1310025 | 2021-05-26 | Colombia | Quindio | 43232 | 1299 | 41170 | 763 | 4.461 | -75.6674 | 2021-05-27 04:20:59 | Quindio, Colombia | ||
3675501 | 3675501 | 2021-05-04 | Colombia | Huila | 54121 | 1872 | 51486 | 763 | 2.5359 | -75.5277 | 2021-05-05 04:20:43 | Huila, Colombia | ||
3702416 | 3702416 | 2021-04-27 | Suriname | 10157 | 201 | 9193 | 763 | 3.9193 | -56.0278 | 2021-04-28 04:20:32 | Suriname | |||
954833 | 954833 | 2021-04-25 | India | Tripura | 34627 | 394 | 33470 | 763 | 23.746783 | 91.743565 | 2021-04-26 04:21:04 | Tripura, India | ||
1219530 | 1219530 | 2021-03-27 | India | Puducherry | 40964 | 680 | 39521 | 763 | 11.882658 | 78.86498 | 2021-03-28 05:28:10 | Puducherry, India | ||
1204017 | 1204017 | 2021-03-22 | Russia | Khanty-Mansi Autonomous Okrug | 53478 | 779 | 51936 | 763 | 61.0259025 | 69.0982628 | 2021-03-23 05:26:18 | Khanty-Mansi Autonomous Okrug, Russia | ||
3369341 | 3369341 | 2021-03-21 | Japan | Hyogo | 18905 | 573 | 17569 | 763 | 35.039913 | 134.828057 | 2021-03-22 05:25:43 | Hyogo, Japan | ||
3670226 | 3670226 | 2021-03-06 | US | Oregon | Crook | 41013 | 781 | 18 | 0 | 763 | 44.14230227 | -120.356297 | 2021-03-07 05:21:54 | Crook, Oregon, US |
3668458 | 3668458 | 2021-03-06 | US | Georgia | Miller | 13201 | 773 | 10 | 0 | 763 | 31.16568912 | -84.73151117 | 2021-03-07 05:21:54 | Miller, Georgia, US |
1618847 | 1618847 | 2021-03-05 | US | Oregon | Crook | 41013 | 781 | 18 | 0 | 763 | 44.14230227 | -120.356297 | 2021-03-06 04:23:41 | Crook, Oregon, US |
2209014 | 2209014 | 2021-03-04 | US | Kentucky | Bath | 21011 | 779 | 16 | 0 | 763 | 38.14735938 | -83.74588932 | 2021-03-05 05:26:29 | Bath, Kentucky, US |
3257515 | 3257515 | 2021-03-02 | US | Virginia | Nelson | 51125 | 771 | 8 | 0 | 763 | 37.78790447 | -78.88498513 | 2021-03-03 05:23:28 | Nelson, Virginia, US |
3255876 | 3255876 | 2021-03-02 | US | Minnesota | Marshall | 27089 | 778 | 15 | 0 | 763 | 48.35825983 | -96.37017407 | 2021-03-03 05:23:28 | Marshall, Minnesota, US |
1000168 | 1000168 | 2021-03-01 | US | Minnesota | Marshall | 27089 | 778 | 15 | 0 | 763 | 48.35825983 | -96.37017407 | 2021-03-02 05:23:30 | Marshall, Minnesota, US |
2369226 | 2369226 | 2021-02-28 | US | Minnesota | Marshall | 27089 | 778 | 15 | 0 | 763 | 48.35825983 | -96.37017407 | 2021-03-01 05:23:01 | Marshall, Minnesota, US |
2186452 | 2186452 | 2021-02-26 | US | South Dakota | Hutchinson | 46067 | 787 | 24 | 0 | 763 | 43.33449012 | -97.75536441 | 2021-02-27 05:22:28 | Hutchinson, South Dakota, US |
1860874 | 1860874 | 2021-02-25 | US | South Dakota | Hutchinson | 46067 | 787 | 24 | 0 | 763 | 43.33449012 | -97.75536441 | 2021-02-26 05:22:40 | Hutchinson, South Dakota, US |
182051 | 182051 | 2021-02-21 | Japan | Hokkaido | 18814 | 656 | 17395 | 763 | 43.385711 | 142.552318 | 2021-02-22 05:24:21 | Hokkaido, Japan | ||
1153939 | 1153939 | 2021-02-18 | US | Georgia | Jenkins | 13165 | 801 | 38 | 0 | 763 | 32.79248718 | -81.96040187 | 2021-02-19 05:24:16 | Jenkins, Georgia, US |
3602024 | 3602024 | 2021-02-17 | US | Illinois | Hamilton | 17065 | 778 | 15 | 0 | 763 | 38.08163641 | -88.53883373 | 2021-02-18 05:22:58 | Hamilton, Illinois, US |
3053639 | 3053639 | 2021-02-16 | US | West Virginia | Braxton | 54007 | 764 | 1 | 0 | 763 | 38.70036159 | -80.72011184 | 2021-02-17 05:23:10 | Braxton, West Virginia, US |
1341738 | 1341738 | 2021-02-15 | US | West Virginia | Braxton | 54007 | 764 | 1 | 0 | 763 | 38.70036159 | -80.72011184 | 2021-02-16 05:24:38 | Braxton, West Virginia, US |
1341268 | 1341268 | 2021-02-15 | US | Tennessee | Van Buren | 47175 | 797 | 20 | 0 | 763 | 35.69864497 | -85.45221699 | 2021-02-16 05:24:38 | Van Buren, Tennessee, US |
1339085 | 1339085 | 2021-02-15 | US | Georgia | Heard | 13149 | 779 | 16 | 0 | 763 | 33.29686567 | -85.12886832 | 2021-02-16 05:24:38 | Heard, Georgia, US |
2283262 | 2283262 | 2021-02-14 | Colombia | Bolivar | 65927 | 1327 | 63837 | 763 | 8.6704 | -74.03 | 2021-02-15 05:24:49 | Bolivar, Colombia | ||
3542352 | 3542352 | 2021-02-12 | US | South Dakota | Spink | 46115 | 788 | 25 | 0 | 763 | 44.93837606 | -98.34626602 | 2021-02-13 05:22:12 | Spink, South Dakota, US |
3541205 | 3541205 | 2021-02-12 | US | Minnesota | Pope | 27121 | 768 | 5 | 0 | 763 | 45.58606667 | -95.44451209 | 2021-02-13 05:22:12 | Pope, Minnesota, US |
3539964 | 3539964 | 2021-02-12 | US | Arkansas | Perry | 5105 | 770 | 7 | 0 | 763 | 34.9459153 | -92.94372564 | 2021-02-13 05:22:12 | Perry, Arkansas, US |
2640615 | 2640615 | 2021-02-11 | US | South Dakota | Spink | 46115 | 788 | 25 | 0 | 763 | 44.93837606 | -98.34626602 | 2021-02-12 05:23:29 | Spink, South Dakota, US |
2639764 | 2639764 | 2021-02-11 | US | Nebraska | Butler | 31023 | 774 | 11 | 0 | 763 | 41.22703692 | -97.13106306 | 2021-02-12 05:23:29 | Butler, Nebraska, US |
3981586 | 3981586 | 2021-02-10 | US | Texas | Bailey | 48017 | 865 | 16 | 0 | 763 | 34.06854817 | -102.8299707 | 2021-02-11 05:23:55 | Bailey, Texas, US |
3980619 | 3980619 | 2021-02-10 | US | Nebraska | Butler | 31023 | 774 | 11 | 0 | 763 | 41.22703692 | -97.13106306 | 2021-02-11 05:23:55 | Butler, Nebraska, US |
1529939 | 1529939 | 2021-02-09 | US | Nebraska | Butler | 31023 | 774 | 11 | 0 | 763 | 41.22703692 | -97.13106306 | 2021-02-10 05:22:41 | Butler, Nebraska, US |
1529547 | 1529547 | 2021-02-09 | US | Michigan | Manistee | 26101 | 782 | 19 | 0 | 763 | 44.33352407 | -86.05626916 | 2021-02-10 05:22:41 | Manistee, Michigan, US |
615730 | 615730 | 2021-02-08 | US | Nebraska | Butler | 31023 | 774 | 11 | 0 | 763 | 41.22703692 | -97.13106306 | 2021-02-09 05:23:30 | Butler, Nebraska, US |
1672418 | 1672418 | 2021-02-07 | India | Odisha | 335620 | 1909 | 332948 | 763 | 20.505428 | 84.418059 | 2021-02-08 05:22:39 | Odisha, India | ||
976112 | 976112 | 2021-02-06 | US | Iowa | Ida | 19093 | 794 | 31 | 0 | 763 | 42.38696136 | -95.51355387 | 2021-02-07 05:23:00 | Ida, Iowa, US |
1589370 | 1589370 | 2021-02-05 | US | Iowa | Ida | 19093 | 794 | 31 | 0 | 763 | 42.38696136 | -95.51355387 | 2021-02-06 05:23:55 | Ida, Iowa, US |
1589125 | 1589125 | 2021-02-05 | US | Idaho | Valley | 16085 | 768 | 5 | 0 | 763 | 44.76728382 | -115.5676773 | 2021-02-06 05:23:55 | Valley, Idaho, US |
791707 | 791707 | 2021-02-04 | US | Kansas | Pratt | 20151 | 786 | 23 | 0 | 763 | 37.64780729 | -98.73922153 | 2021-02-05 05:22:38 | Pratt, Kansas, US |
341599 | 341599 | 2021-02-03 | US | Kansas | Pratt | 20151 | 786 | 23 | 0 | 763 | 37.64780729 | -98.73922153 | 2021-02-04 05:22:26 | Pratt, Kansas, US |
1461304 | 1461304 | 2021-01-31 | US | Maine | Franklin | 23007 | 771 | 8 | 0 | 763 | 44.97330019 | -70.44381045 | 2021-02-01 05:22:53 | Franklin, Maine, US |
2213563 | 2213563 | 2021-01-30 | US | Missouri | Grundy | 29079 | 793 | 30 | 0 | 763 | 40.11406587 | -93.56509276 | 2021-01-31 05:22:42 | Grundy, Missouri, US |
2483843 | 2483843 | 2021-01-28 | US | Missouri | Carroll | 29033 | 781 | 18 | 0 | 763 | 39.42762566 | -93.50626255 | 2021-01-29 05:22:23 | Carroll, Missouri, US |
2482823 | 2482823 | 2021-01-28 | US | Georgia | Pulaski | 13235 | 796 | 33 | 0 | 763 | 32.23334561 | -83.47549959999998 | 2021-01-29 05:22:23 | Pulaski, Georgia, US |
2482339 | 2482339 | 2021-01-28 | US | Alabama | Greene | 1063 | 790 | 27 | 0 | 763 | 32.85504247 | -87.95684022 | 2021-01-29 05:22:23 | Greene, Alabama, US |
3156311 | 3156311 | 2021-01-27 | US | Puerto Rico | Aguas Buenas | 72007 | 763 | 0 | 0 | 763 | 18.251619 | -66.126806 | 2021-01-28 05:22:24 | Aguas Buenas, Puerto Rico, US |
3155501 | 3155501 | 2021-01-27 | US | Missouri | Grundy | 29079 | 793 | 30 | 0 | 763 | 40.11406587 | -93.56509276 | 2021-01-28 05:22:24 | Grundy, Missouri, US |
15620 | 15620 | 2021-01-26 | US | Vermont | Rutland | 50021 | 772 | 9 | 0 | 763 | 43.57723578 | -73.03741676 | 2021-01-27 05:23:41 | Rutland, Vermont, US |
2428278 | 2428278 | 2021-01-23 | US | Kentucky | Carroll | 21041 | 773 | 10 | 0 | 763 | 38.66599534 | -85.12601074 | 2021-01-24 05:22:35 | Carroll, Kentucky, US |
435491 | 435491 | 2021-01-21 | Niger | 4267 | 147 | 3357 | 763 | 17.607789 | 8.081666 | 2021-01-22 05:22:10 | Niger | |||
1095154 | 1095154 | 2021-01-20 | US | Indiana | Crawford | 18025 | 776 | 13 | 0 | 763 | 38.28814402 | -86.44518825 | 2021-01-21 05:22:01 | Crawford, Indiana, US |
1094983 | 1094983 | 2021-01-20 | US | Georgia | Wilkinson | 13319 | 783 | 20 | 0 | 763 | 32.80291082 | -83.17140684 | 2021-01-21 05:22:01 | Wilkinson, Georgia, US |
911732 | 911732 | 2021-01-19 | US | Wisconsin | Menominee | 55078 | 774 | 11 | 0 | 763 | 45.00422544 | -88.70950714 | 2021-01-20 05:21:54 | Menominee, Wisconsin, US |
3104156 | 3104156 | 2021-01-16 | US | Puerto Rico | Camuy | 72027 | 763 | 0 | 0 | 763 | 18.418578 | -66.860206 | 2021-01-17 05:22:17 | Camuy, Puerto Rico, US |
3101449 | 3101449 | 2021-01-16 | Japan | Gifu | 3455 | 54 | 2638 | 763 | 35.778671 | 137.055925 | 2021-01-17 05:22:17 | Gifu, Japan | ||
3518964 | 3518964 | 2021-01-15 | US | Wisconsin | Pepin | 55091 | 769 | 6 | 0 | 763 | 44.58307413 | -91.99949611 | 2021-01-16 05:22:40 | Pepin, Wisconsin, US |
3517005 | 3517005 | 2021-01-15 | US | Michigan | Antrim | 26009 | 779 | 16 | 0 | 763 | 44.99690221 | -85.15503082 | 2021-01-16 05:22:40 | Antrim, Michigan, US |
3880332 | 3880332 | 2021-01-14 | US | Georgia | Candler | 13043 | 800 | 37 | 0 | 763 | 32.40209349 | -82.07702563 | 2021-01-15 05:22:24 | Candler, Georgia, US |
3309081 | 3309081 | 2021-01-13 | US | Georgia | Turner | 13287 | 789 | 26 | 0 | 763 | 31.71612656 | -83.62069378 | 2021-01-14 05:22:32 | Turner, Georgia, US |
776870 | 776870 | 2021-01-12 | US | Oklahoma | Blaine | 40011 | 767 | 4 | 0 | 763 | 35.87518314 | -98.43307003 | 2021-01-13 05:22:15 | Blaine, Oklahoma, US |
775562 | 775562 | 2021-01-12 | US | Iowa | Monroe | 19135 | 781 | 18 | 0 | 763 | 41.02988815 | -92.8690667 | 2021-01-13 05:22:15 | Monroe, Iowa, US |
2629362 | 2629362 | 2021-01-10 | US | West Virginia | Morgan | 54065 | 772 | 9 | 0 | 763 | 39.55439028 | -78.26311676 | 2021-01-11 05:21:50 | Morgan, West Virginia, US |
3035363 | 3035363 | 2021-01-05 | US | Indiana | Brown | 18013 | 775 | 12 | 0 | 763 | 39.19605589 | -86.22868909 | 2021-01-06 05:22:16 | Brown, Indiana, US |
3233041 | 3233041 | 2021-01-03 | US | Oklahoma | Unassigned | 90040 | 763 | 0 | 0 | 763 | 36.83532655 | 0.0 | 2021-01-04 05:22:02 | Unassigned, Oklahoma, US |
3231921 | 3231921 | 2021-01-03 | US | Kentucky | Webster | 21233 | 775 | 12 | 0 | 763 | 37.52168356 | -87.67989953 | 2021-01-04 05:22:02 | Webster, Kentucky, US |
2231129 | 2231129 | 2021-01-02 | US | Wyoming | Washakie | 56043 | 782 | 19 | 0 | 763 | 43.90451606 | -107.68018700000002 | 2021-01-03 05:22:52 | Washakie, Wyoming, US |
1137407 | 1137407 | 2021-01-01 | US | Arkansas | Van Buren | 5141 | 771 | 8 | 0 | 763 | 35.58095779 | -92.51295036 | 2021-01-02 05:22:33 | Van Buren, Arkansas, US |
768355 | 768355 | 2020-12-29 | US | Nebraska | Box Butte | 31013 | 771 | 8 | 0 | 763 | 42.22079243 | -103.0878834 | 2020-12-30 05:22:34 | Box Butte, Nebraska, US |
767646 | 767646 | 2020-12-29 | US | Kansas | Rice | 20159 | 766 | 3 | 0 | 763 | 38.34616184 | -98.19992118 | 2020-12-30 05:22:34 | Rice, Kansas, US |
767096 | 767096 | 2020-12-29 | US | Georgia | Dade | 13083 | 771 | 8 | 0 | 763 | 34.854916700000004 | -85.50490424 | 2020-12-30 05:22:34 | Dade, Georgia, US |
3764527 | 3764527 | 2020-12-28 | US | Tennessee | Houston | 47083 | 798 | 22 | 0 | 763 | 36.28872054 | -87.71878828 | 2020-12-29 05:22:37 | Houston, Tennessee, US |
3764335 | 3764335 | 2020-12-28 | US | Puerto Rico | Moca | 72099 | 763 | 0 | 0 | 763 | 18.377805 | -67.080952 | 2020-12-29 05:22:37 | Moca, Puerto Rico, US |
3762910 | 3762910 | 2020-12-28 | US | Kansas | Rice | 20159 | 766 | 3 | 0 | 763 | 38.34616184 | -98.19992118 | 2020-12-29 05:22:37 | Rice, Kansas, US |
203889 | 203889 | 2020-12-25 | US | Michigan | Iron | 26071 | 800 | 37 | 0 | 763 | 46.20974132 | -88.53136251 | 2020-12-26 05:22:28 | Iron, Michigan, US |
3693112 | 3693112 | 2020-12-24 | US | Michigan | Iron | 26071 | 800 | 37 | 0 | 763 | 46.20974132 | -88.53136251 | 2020-12-25 05:22:48 | Iron, Michigan, US |
2408590 | 2408590 | 2020-12-23 | US | Minnesota | Swift | 27151 | 777 | 14 | 0 | 763 | 45.2829032 | -95.68264092 | 2020-12-24 05:23:04 | Swift, Minnesota, US |
2408464 | 2408464 | 2020-12-23 | US | Michigan | Iron | 26071 | 800 | 37 | 0 | 763 | 46.20974132 | -88.53136251 | 2020-12-24 05:23:04 | Iron, Michigan, US |
2407160 | 2407160 | 2020-12-23 | Tajikistan | 13388 | 89 | 12536 | 763 | 38.861 | 71.2761 | 2020-12-24 05:23:04 | Tajikistan | |||
1904363 | 1904363 | 2020-12-18 | US | Texas | Robertson | 48395 | 907 | 10 | 0 | 763 | 31.02539637 | -96.51272246 | 2020-12-19 05:27:52 | Robertson, Texas, US |
1901624 | 1901624 | 2020-12-18 | US | Arkansas | Bradley | 5011 | 772 | 9 | 0 | 763 | 33.46755808 | -92.15980837 | 2020-12-19 05:27:52 | Bradley, Arkansas, US |
3152968 | 3152968 | 2020-12-16 | US | Virginia | Page | 51139 | 796 | 33 | 0 | 763 | 38.61807452 | -78.48797204 | 2020-12-17 05:28:12 | Page, Virginia, US |
3149434 | 3149434 | 2020-12-16 | Colombia | Caqueta | 14087 | 502 | 12822 | 763 | 0.8699 | -73.8419 | 2020-12-17 05:28:12 | Caqueta, Colombia | ||
1036576 | 1036576 | 2020-12-15 | US | New Mexico | Socorro | 35053 | 797 | 34 | 0 | 763 | 34.00715494 | -106.9298354 | 2020-12-16 05:28:04 | Socorro, New Mexico, US |
3848142 | 3848142 | 2020-12-13 | US | Alabama | Conecuh | 1035 | 778 | 15 | 0 | 763 | 31.43401703 | -86.99320044 | 2020-12-14 05:26:27 | Conecuh, Alabama, US |
847485 | 847485 | 2020-12-12 | US | Missouri | Macon | 29121 | 767 | 4 | 0 | 763 | 39.83049768 | -92.56453089 | 2020-12-13 05:27:20 | Macon, Missouri, US |
845523 | 845523 | 2020-12-12 | India | Ladakh | 9138 | 123 | 8252 | 763 | 34.1526 | 77.5771 | 2020-12-13 05:27:20 | Ladakh, India | ||
864137 | 864137 | 2020-12-11 | US | West Virginia | Boone | 54005 | 780 | 17 | 0 | 763 | 38.01974191 | -81.69888019 | 2020-12-12 05:26:19 | Boone, West Virginia, US |
1821867 | 1821867 | 2020-12-08 | US | Texas | Freestone | 48161 | 801 | 14 | 0 | 763 | 31.70422788 | -96.15072516 | 2020-12-09 05:28:01 | Freestone, Texas, US |
1820471 | 1820471 | 2020-12-08 | US | Michigan | Wexford | 26165 | 781 | 18 | 0 | 763 | 44.33853602 | -85.57712739 | 2020-12-09 05:28:01 | Wexford, Michigan, US |
2348320 | 2348320 | 2020-12-07 | US | Georgia | Worth | 13321 | 802 | 39 | 0 | 763 | 31.55162306 | -83.85090513 | 2020-12-08 05:27:42 | Worth, Georgia, 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]);