johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104 rows where confirmed = 6039 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754496 | 2754496 | 2022-12-29 | US | Maryland | Somerset | 24039 | 6039 | 78 | 0 | 38.1163542 | -75.75118623 | 2022-12-30 04:21:04 | Somerset, Maryland, US | |
539110 | 539110 | 2022-10-26 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-27 04:22:01 | Cherokee, Alabama, US | |
1830511 | 1830511 | 2022-10-25 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-26 04:22:19 | Cherokee, Alabama, US | |
794772 | 794772 | 2022-10-24 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-25 04:21:53 | Cherokee, Alabama, US | |
3277227 | 3277227 | 2022-10-23 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-24 04:22:29 | Cherokee, Alabama, US | |
2268265 | 2268265 | 2022-10-22 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-23 04:22:46 | Cherokee, Alabama, US | |
1592565 | 1592565 | 2022-10-21 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-22 04:22:53 | Cherokee, Alabama, US | |
2272281 | 2272281 | 2022-10-20 | US | Alabama | Cherokee | 1019 | 6039 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-10-21 04:22:23 | Cherokee, Alabama, US | |
3987612 | 3987612 | 2022-09-15 | US | Illinois | Edgar | 17045 | 6039 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-09-16 04:21:19 | Edgar, Illinois, US | |
3827457 | 3827457 | 2022-09-10 | US | Tennessee | Unicoi | 47171 | 6039 | 99 | 0 | 36.10890856 | -82.43709629 | 2022-09-11 04:20:50 | Unicoi, Tennessee, US | |
2987760 | 2987760 | 2022-09-04 | US | Arkansas | Clark | 5019 | 6039 | 86 | 0 | 34.04613432 | -93.17484713 | 2022-09-05 04:21:01 | Clark, Arkansas, US | |
2492796 | 2492796 | 2022-06-29 | US | Puerto Rico | San German | 72125 | 6039 | 0 | 0 | 18.111484 | -67.038581 | 2022-06-30 04:21:01 | San German, Puerto Rico, US | |
478851 | 478851 | 2022-06-26 | US | Virginia | Salem | 51775 | 6039 | 97 | 0 | 37.2836193 | -80.06219455 | 2022-06-27 04:21:00 | Salem, Virginia, US | |
942226 | 942226 | 2022-06-25 | US | Virginia | Salem | 51775 | 6039 | 97 | 0 | 37.2836193 | -80.06219455 | 2022-06-26 04:21:02 | Salem, Virginia, US | |
3350046 | 3350046 | 2022-06-24 | US | Virginia | Salem | 51775 | 6039 | 97 | 0 | 37.2836193 | -80.06219455 | 2022-06-25 04:20:57 | Salem, Virginia, US | |
1766421 | 1766421 | 2022-06-20 | US | Texas | Frio | 48163 | 6039 | 94 | 0 | 28.86751206 | -99.10804207 | 2022-06-21 04:20:56 | Frio, Texas, US | |
3272607 | 3272607 | 2022-06-19 | US | Texas | Frio | 48163 | 6039 | 94 | 0 | 28.86751206 | -99.10804207 | 2022-06-20 04:21:01 | Frio, Texas, US | |
2982815 | 2982815 | 2022-06-13 | US | Wisconsin | Kewaunee | 55061 | 6039 | 59 | 0 | 44.51727459 | -87.61468386 | 2022-06-14 04:20:52 | Kewaunee, Wisconsin, US | |
3208536 | 3208536 | 2022-04-11 | US | New York | Seneca | 36099 | 6039 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-04-12 04:20:49 | Seneca, New York, US | |
877840 | 877840 | 2022-03-27 | US | Maryland | Caroline | 24011 | 6039 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-03-28 04:20:33 | Caroline, Maryland, US | |
3239146 | 3239146 | 2022-03-21 | US | Georgia | Harris | 13145 | 6039 | 110 | 0 | 32.73709786 | -84.90538572 | 2022-03-22 04:20:54 | Harris, Georgia, US | |
577964 | 577964 | 2022-02-25 | US | Texas | Jasper | 48241 | 6039 | 178 | 0 | 30.74685667 | -94.02667579 | 2022-02-26 04:21:12 | Jasper, Texas, US | |
3821297 | 3821297 | 2022-02-16 | US | Georgia | Peach | 13225 | 6039 | 119 | 0 | 32.56934316 | -83.82937 | 2022-02-17 04:20:56 | Peach, Georgia, US | |
189022 | 189022 | 2022-02-13 | US | Tennessee | Haywood | 47075 | 6039 | 90 | 0 | 35.58332824 | -89.28536625 | 2022-02-14 04:20:51 | Haywood, Tennessee, US | |
316557 | 316557 | 2022-02-12 | US | Colorado | Montezuma | 8083 | 6039 | 73 | 0 | 37.33859579 | -108.59588570000001 | 2022-02-13 04:21:00 | Montezuma, Colorado, US | |
1143434 | 1143434 | 2022-01-23 | US | Ohio | Van Wert | 39161 | 6039 | 133 | 0 | 40.8554138 | -84.59111700000003 | 2022-01-24 04:21:12 | Van Wert, Ohio, US | |
1282261 | 1282261 | 2022-01-05 | Saint Vincent and the Grenadines | 6039 | 83 | 0 | 12.9843 | -61.2872 | 2022-01-06 04:22:09 | Saint Vincent and the Grenadines | ||||
2170571 | 2170571 | 2022-01-01 | US | Tennessee | White | 47185 | 6039 | 115 | 0 | 35.92929884 | -85.45591799 | 2022-01-02 04:20:52 | White, Tennessee, US | |
2966342 | 2966342 | 2021-12-24 | US | Tennessee | Henderson | 47077 | 6039 | 118 | 0 | 35.65581134 | -88.38600175 | 2021-12-25 04:21:37 | Henderson, Tennessee, US | |
3819348 | 3819348 | 2021-12-23 | US | Tennessee | Claiborne | 47025 | 6039 | 142 | 0 | 36.48319149 | -83.65947309 | 2021-12-24 04:21:34 | Claiborne, Tennessee, US | |
2090181 | 2090181 | 2021-12-14 | US | New Mexico | Rio Arriba | 35039 | 6039 | 88 | 0 | 36.51072137 | -106.69316740000001 | 2021-12-15 03:22:16 | Rio Arriba, New Mexico, US | |
784647 | 784647 | 2021-12-13 | US | New York | Orleans | 36073 | 6039 | 100 | 0 | 43.2516977 | -78.2320066 | 2021-12-14 04:22:38 | Orleans, New York, US | |
552145 | 552145 | 2021-12-08 | US | Kentucky | Bell | 21013 | 6039 | 113 | 0 | 36.73355174 | -83.67766671 | 2021-12-09 04:22:49 | Bell, Kentucky, US | |
405265 | 405265 | 2021-12-07 | US | Illinois | Christian | 17021 | 6039 | 84 | 0 | 39.54581621 | -89.27780482 | 2021-12-08 04:22:46 | Christian, Illinois, US | |
1744007 | 1744007 | 2021-12-05 | US | Washington | Whitman | 53075 | 6039 | 82 | 0 | 46.90022523 | -117.52417630000001 | 2021-12-06 04:22:34 | Whitman, Washington, US | |
141439 | 141439 | 2021-12-04 | US | Washington | Whitman | 53075 | 6039 | 82 | 0 | 46.90022523 | -117.52417630000001 | 2021-12-05 04:22:25 | Whitman, Washington, US | |
2199092 | 2199092 | 2021-12-03 | US | Washington | Whitman | 53075 | 6039 | 82 | 0 | 46.90022523 | -117.52417630000001 | 2021-12-04 04:22:18 | Whitman, Washington, US | |
3401714 | 3401714 | 2021-11-30 | San Marino | 6039 | 93 | 0 | 43.9424 | 12.4578 | 2021-12-01 04:22:29 | San Marino | ||||
1014394 | 1014394 | 2021-11-21 | Malaysia | Perlis | 6039 | 122 | 0 | 6.4449 | 100.2048 | 2021-11-22 04:22:20 | Perlis, Malaysia | |||
3291422 | 3291422 | 2021-11-18 | US | Ohio | Preble | 39135 | 6039 | 143 | 0 | 39.7420247 | -84.64787018 | 2021-11-19 04:21:40 | Preble, Ohio, US | |
3513173 | 3513173 | 2021-11-01 | US | Minnesota | Steele | 27147 | 6039 | 26 | 0 | 44.02240351 | -93.22627088 | 2021-11-02 04:22:03 | Steele, Minnesota, US | |
291334 | 291334 | 2021-10-31 | US | Virginia | Franklin | 51067 | 6039 | 104 | 0 | 36.99536167 | -79.88023649 | 2021-11-01 04:22:01 | Franklin, Virginia, US | |
2724340 | 2724340 | 2021-10-30 | US | Virginia | Franklin | 51067 | 6039 | 104 | 0 | 36.99536167 | -79.88023649 | 2021-10-31 04:22:08 | Franklin, Virginia, US | |
570442 | 570442 | 2021-10-29 | US | Virginia | Franklin | 51067 | 6039 | 104 | 0 | 36.99536167 | -79.88023649 | 2021-10-30 04:22:03 | Franklin, Virginia, US | |
3494758 | 3494758 | 2021-10-26 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-27 04:22:32 | Ottawa, Oklahoma, US | |
3796480 | 3796480 | 2021-10-25 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-26 04:22:09 | Ottawa, Oklahoma, US | |
684926 | 684926 | 2021-10-24 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-25 04:22:31 | Ottawa, Oklahoma, US | |
772934 | 772934 | 2021-10-23 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-24 04:21:22 | Ottawa, Oklahoma, US | |
656581 | 656581 | 2021-10-22 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-23 04:21:32 | Ottawa, Oklahoma, US | |
2126328 | 2126328 | 2021-10-21 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-22 04:21:14 | Ottawa, Oklahoma, US | |
445940 | 445940 | 2021-10-20 | US | Oklahoma | Ottawa | 40115 | 6039 | 100 | 0 | 36.83532655 | -94.81011909 | 2021-10-21 04:21:18 | Ottawa, Oklahoma, US | |
425049 | 425049 | 2021-10-10 | US | Minnesota | Beltrami | 27007 | 6039 | 76 | 0 | 47.97373527 | -94.93732139 | 2021-10-11 04:21:31 | Beltrami, Minnesota, US | |
2877906 | 2877906 | 2021-10-09 | US | Minnesota | Beltrami | 27007 | 6039 | 76 | 0 | 47.97373527 | -94.93732139 | 2021-10-10 04:21:38 | Beltrami, Minnesota, US | |
2876218 | 2876218 | 2021-10-09 | Japan | Nagasaki | 6039 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-10 04:21:38 | Nagasaki, Japan | |||
2961072 | 2961072 | 2021-10-08 | US | Minnesota | Beltrami | 27007 | 6039 | 76 | 0 | 47.97373527 | -94.93732139 | 2021-10-09 04:21:34 | Beltrami, Minnesota, US | |
2776303 | 2776303 | 2021-09-30 | US | Virginia | Culpeper | 51047 | 6039 | 76 | 0 | 38.48199985 | -77.95630870000002 | 2021-10-01 04:21:35 | Culpeper, Virginia, US | |
2776229 | 2776229 | 2021-09-30 | US | Texas | Wharton | 48481 | 6039 | 158 | 0 | 29.27765923 | -96.22319248 | 2021-10-01 04:21:35 | Wharton, Texas, US | |
1336720 | 1336720 | 2021-09-28 | US | Ohio | Auglaize | 39011 | 6039 | 94 | 0 | 40.55998859 | -84.22421429999999 | 2021-09-29 04:21:45 | Auglaize, Ohio, US | |
3013213 | 3013213 | 2021-09-22 | US | Missouri | Camden | 29029 | 6039 | 118 | 0 | 38.02199522 | -92.76083747 | 2021-09-23 04:21:43 | Camden, Missouri, US | |
2465767 | 2465767 | 2021-09-14 | US | Tennessee | Obion | 47131 | 6039 | 102 | 0 | 36.35732446 | -89.14921589 | 2021-09-15 03:22:37 | Obion, Tennessee, US | |
33420 | 33420 | 2021-08-25 | US | Illinois | Knox | 17095 | 6039 | 157 | 0 | 40.93148779 | -90.21330340000002 | 2021-08-26 04:21:28 | Knox, Illinois, US | |
651842 | 651842 | 2021-08-09 | US | Missouri | Callaway | 29027 | 6039 | 52 | 0 | 38.83674754 | -91.92186505 | 2021-08-10 04:21:27 | Callaway, Missouri, US | |
2913814 | 2913814 | 2021-06-17 | US | Pennsylvania | Armstrong | 42005 | 6039 | 148 | 0 | 40.81665618 | -79.46290811 | 2021-06-18 04:22:16 | Armstrong, Pennsylvania, US | |
3032930 | 3032930 | 2021-06-16 | US | Pennsylvania | Armstrong | 42005 | 6039 | 148 | 0 | 40.81665618 | -79.46290811 | 2021-06-17 04:22:36 | Armstrong, Pennsylvania, US | |
2340978 | 2340978 | 2021-06-15 | US | Maryland | St. Mary's | 24037 | 6039 | 131 | 0 | 38.30058422 | -76.60629279999998 | 2021-06-16 04:22:32 | St. Mary's, Maryland, US | |
1565674 | 1565674 | 2021-06-14 | US | Maryland | St. Mary's | 24037 | 6039 | 131 | 0 | 38.30058422 | -76.60629279999998 | 2021-06-15 04:22:22 | St. Mary's, Maryland, US | |
3382957 | 3382957 | 2021-06-13 | US | Maryland | St. Mary's | 24037 | 6039 | 131 | 0 | 38.30058422 | -76.60629279999998 | 2021-06-14 04:22:46 | St. Mary's, Maryland, US | |
3972132 | 3972132 | 2021-06-11 | US | Maryland | St. Mary's | 24037 | 6039 | 131 | 0 | 38.30058422 | -76.60629279999998 | 2021-06-12 04:22:22 | St. Mary's, Maryland, US | |
526378 | 526378 | 2021-06-09 | US | Wisconsin | Barron | 55005 | 6039 | 84 | 0 | 45.42372701 | -91.84833627 | 2021-06-10 04:23:17 | Barron, Wisconsin, US | |
826197 | 826197 | 2021-06-06 | US | Colorado | Garfield | 8045 | 6039 | 48 | 0 | 39.59921777 | -107.902708 | 2021-06-07 04:22:51 | Garfield, Colorado, US | |
3576768 | 3576768 | 2021-05-17 | US | New Jersey | Salem | 34033 | 6039 | 185 | 0 | 39.58719656 | -75.34696629999998 | 2021-05-18 04:20:33 | Salem, New Jersey, US | |
1426209 | 1426209 | 2021-05-09 | US | Indiana | Marshall | 18099 | 6039 | 111 | 0 | 41.32467367 | -86.26185087 | 2021-05-10 04:20:38 | Marshall, Indiana, US | |
2573490 | 2573490 | 2021-04-13 | US | Mississippi | Lafayette | 28071 | 6039 | 117 | 0 | 34.35687874 | -89.48490961 | 2021-04-14 04:20:41 | Lafayette, Mississippi, US | |
2572544 | 2572544 | 2021-04-13 | US | Georgia | Spalding | 13255 | 6039 | 185 | 0 | 33.26310031 | -84.28013991 | 2021-04-14 04:20:41 | Spalding, Georgia, US | |
2572440 | 2572440 | 2021-04-13 | US | Georgia | Catoosa | 13047 | 6039 | 66 | 0 | 34.89872298 | -85.13757014 | 2021-04-14 04:20:41 | Catoosa, Georgia, US | |
3005832 | 3005832 | 2021-04-06 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-07 04:20:53 | Bryan, Oklahoma, US | |
3087827 | 3087827 | 2021-04-05 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-06 04:20:32 | Bryan, Oklahoma, US | |
390750 | 390750 | 2021-04-04 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-05 04:20:35 | Bryan, Oklahoma, US | |
3712666 | 3712666 | 2021-04-03 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-04 04:20:49 | Bryan, Oklahoma, US | |
243782 | 243782 | 2021-04-02 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-03 04:20:44 | Bryan, Oklahoma, US | |
1304577 | 1304577 | 2021-04-01 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-02 04:20:36 | Bryan, Oklahoma, US | |
640449 | 640449 | 2021-03-31 | US | Oklahoma | Bryan | 40013 | 6039 | 59 | 0 | 33.96472458 | -96.25903472 | 2021-04-01 04:27:05 | Bryan, Oklahoma, US | |
1221378 | 1221378 | 2021-03-27 | US | Mississippi | Lamar | 28073 | 6039 | 84 | 0 | 31.20572971 | -89.5077704 | 2021-03-28 05:28:10 | Lamar, Mississippi, US | |
2781693 | 2781693 | 2021-03-24 | US | Florida | Jackson | 12063 | 6039 | 154 | 0 | 30.7954597 | -85.21500423 | 2021-03-25 05:27:00 | Jackson, Florida, US | |
1204761 | 1204761 | 2021-03-22 | US | Illinois | Boone | 17007 | 6039 | 71 | 0 | 42.32359279 | -88.82345779 | 2021-03-23 05:26:18 | Boone, Illinois, US | |
1583057 | 1583057 | 2021-03-13 | US | Tennessee | Bedford | 47003 | 6039 | 122 | 0 | 35.51123746 | -86.45549096 | 2021-03-14 05:25:37 | Bedford, Tennessee, US | |
3050111 | 3050111 | 2021-02-16 | Iceland | 6039 | 29 | 5986 | 24 | 64.9631 | -19.0208 | 2021-02-17 05:23:10 | Iceland | |||
1338210 | 1338210 | 2021-02-15 | Iceland | 6039 | 29 | 5984 | 26 | 64.9631 | -19.0208 | 2021-02-16 05:24:38 | Iceland | |||
2223884 | 2223884 | 2020-12-26 | US | Alabama | Lauderdale | 1077 | 6039 | 68 | 0 | 5971 | 34.90171875 | -87.65624729 | 2020-12-27 05:22:55 | Lauderdale, Alabama, US |
3770964 | 3770964 | 2020-12-22 | US | Indiana | Howard | 18067 | 6039 | 120 | 0 | 5919 | 40.48527731 | -86.11351892 | 2020-12-23 05:22:03 | Howard, Indiana, US |
3770784 | 3770784 | 2020-12-22 | US | Idaho | Bannock | 16005 | 6039 | 53 | 0 | 5986 | 42.67002716 | -112.2233311 | 2020-12-23 05:22:03 | Bannock, Idaho, US |
3851023 | 3851023 | 2020-12-13 | US | Texas | Walker | 48471 | 6039 | 74 | 0 | 5010 | 30.73872995 | -95.57440968 | 2020-12-14 05:26:27 | Walker, Texas, US |
845760 | 845760 | 2020-12-12 | Russia | Chechen Republic | 6039 | 83 | 2956 | 3000 | 43.39761470000001 | 45.6985005 | 2020-12-13 05:27:20 | Chechen Republic, Russia | ||
2975663 | 2975663 | 2020-12-09 | US | Arizona | Apache | 4001 | 6039 | 204 | 0 | 5835 | 35.39465006 | -109.4892383 | 2020-12-10 05:26:19 | Apache, Arizona, US |
392047 | 392047 | 2020-11-27 | China | Hong Kong | 6039 | 108 | 5313 | 618 | 22.3 | 114.2 | 2020-11-28 05:25:50 | Hong Kong, China | ||
867281 | 867281 | 2020-11-12 | US | Ohio | Warren | 39165 | 6039 | 85 | 0 | 5954 | 39.42581994 | -84.16557457 | 2020-11-13 05:25:30 | Warren, Ohio, US |
3440965 | 3440965 | 2020-11-11 | Peru | Apurimac | 6039 | 286 | 0 | 5753 | -14.027713 | -72.975378 | 2020-11-12 05:25:55 | Apurimac, Peru | ||
1545846 | 1545846 | 2020-11-07 | US | Missouri | Jasper | 29097 | 6039 | 85 | 0 | 5954 | 37.20351921 | -94.34050458 | 2020-11-08 05:24:56 | Jasper, Missouri, US |
2614774 | 2614774 | 2020-09-26 | US | Georgia | Bibb | 13021 | 6039 | 168 | 0 | 5871 | 32.80904227 | -83.70489165 | 2020-09-27 04:23:00 | Bibb, Georgia, US |
1243884 | 1243884 | 2020-09-08 | Netherlands | Utrecht | 6039 | 437 | 0 | 5581 | 52.084251 | 5.163824 | 2020-09-09 04:28:48 | Utrecht, Netherlands |
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]);