johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
182 rows where confirmed = 4397 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3174278 | 3174278 | 2022-12-19 | US | Arkansas | Franklin | 5047 | 4397 | 80 | 0 | 35.51202821 | -93.89299569 | 2022-12-20 04:21:04 | Franklin, Arkansas, US | |
3938788 | 3938788 | 2022-12-09 | US | Puerto Rico | Florida | 72054 | 4397 | 0 | 0 | 18.373715 | -66.560488 | 2022-12-10 04:21:02 | Florida, Puerto Rico, US | |
796079 | 796079 | 2022-10-24 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-25 04:21:53 | Manistee, Michigan, US | |
3278534 | 3278534 | 2022-10-23 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-24 04:22:29 | Manistee, Michigan, US | |
2269572 | 2269572 | 2022-10-22 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-23 04:22:46 | Manistee, Michigan, US | |
1593872 | 1593872 | 2022-10-21 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-22 04:22:53 | Manistee, Michigan, US | |
2273588 | 2273588 | 2022-10-20 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-21 04:22:23 | Manistee, Michigan, US | |
199923 | 199923 | 2022-10-19 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-20 04:22:59 | Manistee, Michigan, US | |
2758584 | 2758584 | 2022-10-18 | US | Michigan | Manistee | 26101 | 4397 | 102 | 0 | 44.33352407 | -86.05626916 | 2022-10-19 04:22:26 | Manistee, Michigan, US | |
3214667 | 3214667 | 2022-10-12 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-13 04:22:39 | Crenshaw, Alabama, US | |
3250516 | 3250516 | 2022-10-11 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-12 04:22:51 | Crenshaw, Alabama, US | |
2967903 | 2967903 | 2022-10-10 | US | Arkansas | Howard | 5061 | 4397 | 56 | 0 | 34.09007427 | -93.9934871 | 2022-10-11 04:23:05 | Howard, Arkansas, US | |
2967775 | 2967775 | 2022-10-10 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-11 04:23:05 | Crenshaw, Alabama, US | |
3097939 | 3097939 | 2022-10-09 | US | Arkansas | Howard | 5061 | 4397 | 56 | 0 | 34.09007427 | -93.9934871 | 2022-10-10 04:22:32 | Howard, Arkansas, US | |
3097811 | 3097811 | 2022-10-09 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-10 04:22:32 | Crenshaw, Alabama, US | |
4003164 | 4003164 | 2022-10-08 | US | Arkansas | Howard | 5061 | 4397 | 56 | 0 | 34.09007427 | -93.9934871 | 2022-10-09 04:21:16 | Howard, Arkansas, US | |
4003036 | 4003036 | 2022-10-08 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-09 04:21:16 | Crenshaw, Alabama, US | |
396633 | 396633 | 2022-10-07 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-08 04:22:56 | Crenshaw, Alabama, US | |
2529750 | 2529750 | 2022-10-06 | US | Alabama | Crenshaw | 1041 | 4397 | 106 | 0 | 31.72941803 | -86.31593104 | 2022-10-07 04:23:08 | Crenshaw, Alabama, US | |
2771182 | 2771182 | 2022-09-26 | US | New Mexico | Socorro | 35053 | 4397 | 96 | 0 | 34.00715494 | -106.9298354 | 2022-09-27 04:23:01 | Socorro, New Mexico, US | |
2770023 | 2770023 | 2022-09-26 | US | Illinois | Wabash | 17185 | 4397 | 29 | 0 | 38.44272901 | -87.84922065 | 2022-09-27 04:23:01 | Wabash, Illinois, US | |
256769 | 256769 | 2022-09-08 | US | Washington | Pacific | 53049 | 4397 | 67 | 0 | 46.55418369 | -123.7285716 | 2022-09-09 04:21:11 | Pacific, Washington, US | |
3748567 | 3748567 | 2022-09-07 | US | Washington | Pacific | 53049 | 4397 | 67 | 0 | 46.55418369 | -123.7285716 | 2022-09-08 04:21:02 | Pacific, Washington, US | |
1161688 | 1161688 | 2022-08-18 | US | Arkansas | Polk | 5113 | 4397 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-08-19 04:20:54 | Polk, Arkansas, US | |
2336424 | 2336424 | 2022-07-27 | US | Illinois | Mercer | 17131 | 4397 | 50 | 0 | 41.20596782 | -90.74290052 | 2022-07-28 04:20:56 | Mercer, Illinois, US | |
1487945 | 1487945 | 2022-07-26 | US | Alabama | Clay | 1027 | 4397 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-07-27 04:21:04 | Clay, Alabama, US | |
3940803 | 3940803 | 2022-06-30 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-01 04:21:10 | Union, Florida, US | |
2490761 | 2490761 | 2022-06-29 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-06-30 04:21:01 | Union, Florida, US | |
2240143 | 2240143 | 2022-06-28 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-06-29 04:20:59 | Union, Florida, US | |
2148385 | 2148385 | 2022-06-27 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-06-28 04:20:58 | Union, Florida, US | |
476186 | 476186 | 2022-06-26 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-06-27 04:21:00 | Union, Florida, US | |
939561 | 939561 | 2022-06-25 | US | Florida | Union | 12125 | 4397 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-06-26 04:21:02 | Union, Florida, US | |
3347381 | 3347381 | 2022-06-24 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-25 04:20:57 | Union, Florida, US | |
1649122 | 1649122 | 2022-06-23 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-24 04:20:58 | Union, Florida, US | |
2188357 | 2188357 | 2022-06-22 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-23 04:20:55 | Union, Florida, US | |
166788 | 166788 | 2022-06-21 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-22 04:20:54 | Union, Florida, US | |
1764071 | 1764071 | 2022-06-20 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-21 04:20:56 | Union, Florida, US | |
3270257 | 3270257 | 2022-06-19 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-20 04:21:01 | Union, Florida, US | |
3398169 | 3398169 | 2022-06-18 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-19 04:20:51 | Union, Florida, US | |
2312046 | 2312046 | 2022-06-17 | US | Florida | Union | 12125 | 4397 | 116 | 0 | 30.04412971 | -82.37497443 | 2022-06-18 04:21:10 | Union, Florida, US | |
949142 | 949142 | 2022-06-14 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-15 04:20:54 | Bertie, North Carolina, US | |
2981550 | 2981550 | 2022-06-13 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-14 04:20:52 | Bertie, North Carolina, US | |
2237676 | 2237676 | 2022-06-12 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-13 04:21:14 | Bertie, North Carolina, US | |
3143874 | 3143874 | 2022-06-11 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-12 04:20:53 | Bertie, North Carolina, US | |
1946790 | 1946790 | 2022-06-10 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-11 04:21:01 | Bertie, North Carolina, US | |
3159929 | 3159929 | 2022-06-09 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-10 04:20:55 | Bertie, North Carolina, US | |
3158606 | 3158606 | 2022-06-09 | US | Illinois | Carroll | 17015 | 4397 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-06-10 04:20:55 | Carroll, Illinois, US | |
1424606 | 1424606 | 2022-06-08 | US | West Virginia | Monroe | 54063 | 4397 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-06-09 04:20:54 | Monroe, West Virginia, US | |
1423396 | 1423396 | 2022-06-08 | US | North Carolina | Bertie | 37015 | 4397 | 70 | 0 | 36.0688473 | -76.96545943 | 2022-06-09 04:20:54 | Bertie, North Carolina, US | |
3507151 | 3507151 | 2022-06-05 | Canada | Yukon | 4397 | 26 | 0 | 64.2823 | -135.0 | 2022-06-06 04:20:57 | Yukon, Canada | |||
3527228 | 3527228 | 2022-06-04 | Canada | Yukon | 4397 | 26 | 0 | 64.2823 | -135.0 | 2022-06-05 04:20:55 | Yukon, Canada | |||
3133314 | 3133314 | 2022-06-03 | Canada | Yukon | 4397 | 26 | 0 | 64.2823 | -135.0 | 2022-06-04 04:20:58 | Yukon, Canada | |||
230491 | 230491 | 2022-05-31 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-06-01 04:20:55 | Bourbon, Kansas, US | |
3187256 | 3187256 | 2022-05-30 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-31 04:20:51 | Bourbon, Kansas, US | |
3199405 | 3199405 | 2022-05-29 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-30 04:20:50 | Bourbon, Kansas, US | |
2726283 | 2726283 | 2022-05-28 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-29 04:20:53 | Bourbon, Kansas, US | |
1315464 | 1315464 | 2022-05-27 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-28 04:21:07 | Bourbon, Kansas, US | |
1851256 | 1851256 | 2022-05-26 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-27 04:20:56 | Bourbon, Kansas, US | |
2049132 | 2049132 | 2022-05-25 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-26 04:20:50 | Bourbon, Kansas, US | |
3002829 | 3002829 | 2022-05-24 | US | West Virginia | Wetzel | 54103 | 4397 | 86 | 0 | 39.6065771 | -80.6401654 | 2022-05-25 04:20:56 | Wetzel, West Virginia, US | |
623143 | 623143 | 2022-05-22 | US | Kansas | Bourbon | 20011 | 4397 | 56 | 0 | 37.85508555 | -94.84865997 | 2022-05-26 04:20:50 | Bourbon, Kansas, US | |
1906256 | 1906256 | 2022-03-22 | US | Illinois | White | 17193 | 4397 | 48 | 0 | 38.08706198 | -88.17657461 | 2022-03-23 04:20:48 | White, Illinois, US | |
946349 | 946349 | 2022-02-28 | US | West Virginia | Taylor | 54091 | 4397 | 62 | 0 | 39.33602617 | -80.0421439 | 2022-03-01 04:21:09 | Taylor, West Virginia, US | |
3719995 | 3719995 | 2022-02-21 | US | Mississippi | Holmes | 28051 | 4397 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-02-22 04:21:01 | Holmes, Mississippi, US | |
3913829 | 3913829 | 2022-02-20 | US | Mississippi | Holmes | 28051 | 4397 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-02-21 04:21:05 | Holmes, Mississippi, US | |
3877387 | 3877387 | 2022-02-19 | US | Mississippi | Holmes | 28051 | 4397 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-02-20 04:21:00 | Holmes, Mississippi, US | |
3857643 | 3857643 | 2022-02-18 | US | Mississippi | Holmes | 28051 | 4397 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-02-19 04:21:11 | Holmes, Mississippi, US | |
189353 | 189353 | 2022-02-13 | US | Vermont | Caledonia | 50005 | 4397 | 23 | 0 | 44.46548598 | -72.10314651 | 2022-02-14 04:20:51 | Caledonia, Vermont, US | |
319199 | 319199 | 2022-02-12 | US | Vermont | Caledonia | 50005 | 4397 | 23 | 0 | 44.46548598 | -72.10314651 | 2022-02-13 04:21:00 | Caledonia, Vermont, US | |
236525 | 236525 | 2022-02-11 | US | Vermont | Caledonia | 50005 | 4397 | 23 | 0 | 44.46548598 | -72.10314651 | 2022-02-12 04:21:06 | Caledonia, Vermont, US | |
982128 | 982128 | 2022-02-01 | US | Texas | Montague | 48337 | 4397 | 110 | 0 | 33.67521893 | -97.72500958 | 2022-02-02 04:21:09 | Montague, Texas, US | |
1781111 | 1781111 | 2022-01-27 | US | Minnesota | Hubbard | 27057 | 4397 | 53 | 0 | 47.10778564 | -94.91693868 | 2022-01-28 04:21:09 | Hubbard, Minnesota, US | |
1779867 | 1779867 | 2022-01-27 | US | Arkansas | Cross | 5037 | 4397 | 73 | 0 | 35.29631396 | -90.77185818 | 2022-01-28 04:21:09 | Cross, Arkansas, US | |
2052489 | 2052489 | 2022-01-25 | US | Colorado | Chaffee | 8015 | 4397 | 42 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-26 04:21:07 | Chaffee, Colorado, US | |
555291 | 555291 | 2022-01-16 | US | Arkansas | Lincoln | 5079 | 4397 | 59 | 0 | 33.95317155 | -91.74002806 | 2022-01-17 04:21:08 | Lincoln, Arkansas, US | |
3690261 | 3690261 | 2022-01-13 | US | Puerto Rico | San Sebastian | 72131 | 4397 | 0 | 0 | 18.328646 | -66.971214 | 2022-01-14 04:21:54 | San Sebastian, Puerto Rico, US | |
3614919 | 3614919 | 2022-01-12 | US | Mississippi | Tishomingo | 28141 | 4397 | 99 | 0 | 34.74023475 | -88.23917219 | 2022-01-13 08:00:09 | Tishomingo, Mississippi, US | |
1284735 | 1284735 | 2022-01-05 | US | Puerto Rico | Gurabo | 72063 | 4397 | 0 | 0 | 18.266461 | -65.97970500000001 | 2022-01-06 04:22:09 | Gurabo, Puerto Rico, US | |
1284439 | 1284439 | 2022-01-05 | US | Ohio | Carroll | 39019 | 4397 | 106 | 0 | 40.578968599999996 | -81.09178213 | 2022-01-06 04:22:09 | Carroll, Ohio, US | |
1670594 | 1670594 | 2021-12-29 | US | Nevada | Churchill | 32001 | 4397 | 90 | 0 | 39.58105744 | -118.3394607 | 2021-12-30 04:21:25 | Churchill, Nevada, US | |
2904063 | 2904063 | 2021-12-19 | US | Alabama | Bibb | 1007 | 4397 | 95 | 0 | 32.99642064 | -87.12511459999996 | 2021-12-20 04:21:43 | Bibb, Alabama, US | |
1741481 | 1741481 | 2021-12-05 | US | Idaho | Jerome | 16053 | 4397 | 55 | 0 | 42.68891267 | -114.2655033 | 2021-12-06 04:22:34 | Jerome, Idaho, US | |
138913 | 138913 | 2021-12-04 | US | Idaho | Jerome | 16053 | 4397 | 55 | 0 | 42.68891267 | -114.2655033 | 2021-12-05 04:22:25 | Jerome, Idaho, US | |
759269 | 759269 | 2021-11-26 | US | Idaho | Jefferson | 16051 | 4397 | 51 | 0 | 43.82078483 | -112.3131749 | 2021-11-27 04:22:45 | Jefferson, Idaho, US | |
3751648 | 3751648 | 2021-11-22 | US | Ohio | Van Wert | 39161 | 4397 | 97 | 0 | 40.8554138 | -84.59111700000003 | 2021-11-23 04:22:39 | Van Wert, Ohio, US | |
1324238 | 1324238 | 2021-11-14 | US | Montana | Lake | 30047 | 4397 | 68 | 0 | 47.64514965 | -114.0898013 | 2021-11-15 04:21:36 | Lake, Montana, US | |
1323229 | 1323229 | 2021-11-14 | US | Illinois | Iroquois | 17075 | 4397 | 81 | 0 | 40.74717633 | -87.82466784 | 2021-11-15 04:21:36 | Iroquois, Illinois, US | |
688364 | 688364 | 2021-11-13 | US | Montana | Lake | 30047 | 4397 | 68 | 0 | 47.64514965 | -114.0898013 | 2021-11-14 04:21:31 | Lake, Montana, US | |
687355 | 687355 | 2021-11-13 | US | Illinois | Iroquois | 17075 | 4397 | 81 | 0 | 40.74717633 | -87.82466784 | 2021-11-14 04:21:31 | Iroquois, Illinois, US | |
716473 | 716473 | 2021-11-12 | US | Montana | Lake | 30047 | 4397 | 68 | 0 | 47.64514965 | -114.0898013 | 2021-11-13 04:21:38 | Lake, Montana, US | |
715464 | 715464 | 2021-11-12 | US | Illinois | Iroquois | 17075 | 4397 | 81 | 0 | 40.74717633 | -87.82466784 | 2021-11-13 04:21:38 | Iroquois, Illinois, US | |
701347 | 701347 | 2021-11-04 | US | Tennessee | Grainger | 47057 | 4397 | 67 | 0 | 36.27469206 | -83.51254721 | 2021-11-05 04:21:54 | Grainger, Tennessee, US | |
569074 | 569074 | 2021-10-29 | US | Missouri | Stoddard | 29207 | 4397 | 71 | 0 | 36.85571651 | -89.9444155 | 2021-10-30 04:22:03 | Stoddard, Missouri, US | |
684201 | 684201 | 2021-10-24 | US | Mississippi | Wayne | 28153 | 4397 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-10-25 04:22:31 | Wayne, Mississippi, US | |
682888 | 682888 | 2021-10-24 | US | California | Glenn | 6021 | 4397 | 33 | 0 | 39.59875897 | -122.3938452 | 2021-10-25 04:22:31 | Glenn, California, US | |
772209 | 772209 | 2021-10-23 | US | Mississippi | Wayne | 28153 | 4397 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-10-24 04:21:22 | Wayne, Mississippi, US | |
655856 | 655856 | 2021-10-22 | US | Mississippi | Wayne | 28153 | 4397 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-10-23 04:21:32 | Wayne, Mississippi, US | |
2125603 | 2125603 | 2021-10-21 | US | Mississippi | Wayne | 28153 | 4397 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-10-22 04:21:14 | Wayne, Mississippi, US | |
2125058 | 2125058 | 2021-10-21 | US | Kansas | McPherson | 20113 | 4397 | 93 | 0 | 38.39184858 | -97.64769869 | 2021-10-22 04:21:14 | McPherson, Kansas, US | |
444670 | 444670 | 2021-10-20 | US | Kansas | McPherson | 20113 | 4397 | 93 | 0 | 38.39184858 | -97.64769869 | 2021-10-21 04:21:18 | McPherson, 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]);