johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where confirmed = 4859 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2418471 | 2418471 | 2022-12-05 | US | Wisconsin | Washburn | 55129 | 4859 | 50 | 0 | 45.89838588 | -91.79050449 | 2022-12-06 04:21:03 | Washburn, Wisconsin, US | |
2136862 | 2136862 | 2022-12-01 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-12-02 04:21:07 | Gulf, Florida, US | |
1965278 | 1965278 | 2022-11-30 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-12-01 04:21:03 | Gulf, Florida, US | |
2557292 | 2557292 | 2022-11-29 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-30 04:21:07 | Gulf, Florida, US | |
1240366 | 1240366 | 2022-11-28 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-29 04:21:05 | Gulf, Florida, US | |
3552354 | 3552354 | 2022-11-27 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-28 04:21:02 | Gulf, Florida, US | |
2100834 | 2100834 | 2022-11-26 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-27 04:21:05 | Gulf, Florida, US | |
488325 | 488325 | 2022-11-25 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-26 04:21:11 | Gulf, Florida, US | |
3524154 | 3524154 | 2022-11-24 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-25 04:21:06 | Gulf, Florida, US | |
3312937 | 3312937 | 2022-11-23 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-24 04:21:09 | Gulf, Florida, US | |
1620978 | 1620978 | 2022-11-22 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-23 04:21:06 | Gulf, Florida, US | |
3460866 | 3460866 | 2022-11-21 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-22 04:20:47 | Gulf, Florida, US | |
1641051 | 1641051 | 2022-11-20 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-21 04:21:05 | Gulf, Florida, US | |
2064608 | 2064608 | 2022-11-19 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-20 04:21:08 | Gulf, Florida, US | |
1756002 | 1756002 | 2022-11-18 | US | Florida | Gulf | 12045 | 4859 | 87 | 0 | 29.93543004 | -85.2427099 | 2022-11-19 04:21:14 | Gulf, Florida, US | |
294895 | 294895 | 2022-11-15 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-16 04:21:09 | Hughes, South Dakota, US | |
3599925 | 3599925 | 2022-11-14 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-15 04:21:16 | Hughes, South Dakota, US | |
314783 | 314783 | 2022-11-13 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-14 04:21:09 | Hughes, South Dakota, US | |
65944 | 65944 | 2022-11-12 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-13 04:21:14 | Hughes, South Dakota, US | |
2930106 | 2930106 | 2022-11-11 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-12 04:20:41 | Hughes, South Dakota, US | |
2508942 | 2508942 | 2022-11-10 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-11 04:21:22 | Hughes, South Dakota, US | |
2433817 | 2433817 | 2022-11-09 | US | South Dakota | Hughes | 46065 | 4859 | 62 | 0 | 44.39091534 | -99.99661148 | 2022-11-10 04:21:16 | Hughes, South Dakota, US | |
480563 | 480563 | 2022-11-08 | US | Illinois | Carroll | 17015 | 4859 | 52 | 0 | 42.06823429 | -89.93395545 | 2022-11-09 04:21:22 | Carroll, Illinois, US | |
2439713 | 2439713 | 2022-11-07 | US | Illinois | Carroll | 17015 | 4859 | 52 | 0 | 42.06823429 | -89.93395545 | 2022-11-08 04:21:21 | Carroll, Illinois, US | |
399260 | 399260 | 2022-10-07 | US | Tennessee | Sequatchie | 47153 | 4859 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-10-08 04:22:56 | Sequatchie, Tennessee, US | |
1561860 | 1561860 | 2022-09-28 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-29 04:22:34 | Roseau, Minnesota, US | |
3996403 | 3996403 | 2022-09-27 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-28 04:23:01 | Roseau, Minnesota, US | |
2770731 | 2770731 | 2022-09-26 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-27 04:23:01 | Roseau, Minnesota, US | |
1978384 | 1978384 | 2022-09-25 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-26 04:20:52 | Roseau, Minnesota, US | |
2651551 | 2651551 | 2022-09-24 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-25 04:23:31 | Roseau, Minnesota, US | |
385991 | 385991 | 2022-09-23 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-24 04:21:40 | Roseau, Minnesota, US | |
1626057 | 1626057 | 2022-09-22 | US | Minnesota | Roseau | 27135 | 4859 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-09-23 04:23:13 | Roseau, Minnesota, US | |
1406032 | 1406032 | 2022-08-02 | US | Illinois | Ford | 17053 | 4859 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-08-03 04:20:59 | Ford, Illinois, US | |
2596815 | 2596815 | 2022-07-25 | US | Puerto Rico | Santa Isabel | 72133 | 4859 | 0 | 0 | 17.994525 | -66.388913 | 2022-07-26 04:20:58 | Santa Isabel, Puerto Rico, US | |
2492511 | 2492511 | 2022-06-29 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-30 04:21:01 | Meigs, Ohio, US | |
2241893 | 2241893 | 2022-06-28 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-29 04:20:59 | Meigs, Ohio, US | |
2150135 | 2150135 | 2022-06-27 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-28 04:20:58 | Meigs, Ohio, US | |
477936 | 477936 | 2022-06-26 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-27 04:21:00 | Meigs, Ohio, US | |
941311 | 941311 | 2022-06-25 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-26 04:21:02 | Meigs, Ohio, US | |
3349131 | 3349131 | 2022-06-24 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-25 04:20:57 | Meigs, Ohio, US | |
1650872 | 1650872 | 2022-06-23 | US | Ohio | Meigs | 39105 | 4859 | 92 | 0 | 39.09224872 | -82.0305041 | 2022-06-24 04:20:58 | Meigs, Ohio, US | |
1314681 | 1314681 | 2022-05-27 | US | Arkansas | Cross | 5037 | 4859 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-05-28 04:21:07 | Cross, Arkansas, US | |
3725158 | 3725158 | 2022-04-25 | US | Tennessee | Humphreys | 47085 | 4859 | 74 | 0 | 36.03958805 | -87.77992872 | 2022-04-26 04:20:51 | Humphreys, Tennessee, US | |
2031726 | 2031726 | 2022-04-24 | US | Tennessee | Humphreys | 47085 | 4859 | 74 | 0 | 36.03958805 | -87.77992872 | 2022-04-25 04:20:56 | Humphreys, Tennessee, US | |
1994606 | 1994606 | 2022-03-01 | US | Missouri | Perry | 29157 | 4859 | 44 | 0 | 37.70660776 | -89.82741088 | 2022-03-02 04:21:07 | Perry, Missouri, US | |
1512498 | 1512498 | 2022-02-24 | US | Indiana | Fulton | 18049 | 4859 | 98 | 0 | 41.0469907 | -86.26252745 | 2022-02-25 04:21:11 | Fulton, Indiana, US | |
3721660 | 3721660 | 2022-02-21 | US | West Virginia | Brooke | 54009 | 4859 | 101 | 0 | 40.27367263 | -80.57915332 | 2022-02-22 04:21:01 | Brooke, West Virginia, US | |
3719745 | 3719745 | 2022-02-21 | US | Maine | Lincoln | 23015 | 4859 | 26 | 0 | 44.05996956 | -69.54227124 | 2022-02-22 04:21:01 | Lincoln, Maine, US | |
3913579 | 3913579 | 2022-02-20 | US | Maine | Lincoln | 23015 | 4859 | 26 | 0 | 44.05996956 | -69.54227124 | 2022-02-21 04:21:05 | Lincoln, Maine, US | |
1365849 | 1365849 | 2022-02-08 | US | West Virginia | McDowell | 54047 | 4859 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-09 04:21:04 | McDowell, West Virginia, US | |
3813147 | 3813147 | 2022-01-28 | US | Texas | San Jacinto | 48407 | 4859 | 88 | 0 | 30.57933681 | -95.16260304 | 2022-01-29 04:21:10 | San Jacinto, Texas, US | |
1962236 | 1962236 | 2022-01-20 | US | Michigan | Otsego | 26137 | 4859 | 89 | 0 | 45.02085831 | -84.59898295 | 2022-01-21 04:21:09 | Otsego, Michigan, US | |
3228131 | 3228131 | 2022-01-19 | US | Michigan | Otsego | 26137 | 4859 | 89 | 0 | 45.02085831 | -84.59898295 | 2022-01-20 04:21:07 | Otsego, Michigan, US | |
2113552 | 2113552 | 2021-12-26 | US | Mississippi | Tate | 28137 | 4859 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-27 04:21:58 | Tate, Mississippi, US | |
3606924 | 3606924 | 2021-12-25 | US | Mississippi | Tate | 28137 | 4859 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-26 04:21:50 | Tate, Mississippi, US | |
3605685 | 3605685 | 2021-12-25 | US | Colorado | Delta | 8029 | 4859 | 122 | 0 | 38.86246243 | -107.86313419999999 | 2021-12-26 04:21:50 | Delta, Colorado, US | |
2965242 | 2965242 | 2021-12-24 | US | Mississippi | Tate | 28137 | 4859 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-25 04:21:37 | Tate, Mississippi, US | |
3818274 | 3818274 | 2021-12-23 | US | Mississippi | Tate | 28137 | 4859 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-24 04:21:34 | Tate, Mississippi, US | |
800282 | 800282 | 2021-12-22 | US | Mississippi | Tate | 28137 | 4859 | 120 | 0 | 34.65133709 | -89.94485778 | 2021-12-23 04:21:21 | Tate, Mississippi, US | |
798744 | 798744 | 2021-12-22 | Sweden | Gotland | 4859 | 54 | 0 | 57.4684 | 18.4867 | 2021-12-23 04:21:21 | Gotland, Sweden | |||
1663380 | 1663380 | 2021-12-12 | US | Tennessee | Hickman | 47081 | 4859 | 81 | 0 | 35.80609681 | -87.47643507 | 2021-12-13 04:22:02 | Hickman, Tennessee, US | |
404650 | 404650 | 2021-12-07 | US | Alabama | Clarke | 1025 | 4859 | 86 | 0 | 31.68099859 | -87.83548597 | 2021-12-08 04:22:46 | Clarke, Alabama, US | |
2802 | 2802 | 2021-12-02 | US | Ohio | Hardin | 39065 | 4859 | 112 | 0 | 40.66015414 | -83.65929931 | 2021-12-03 04:23:05 | Hardin, Ohio, US | |
3749966 | 3749966 | 2021-11-22 | US | Georgia | Lumpkin | 13187 | 4859 | 109 | 0 | 34.57286511 | -84.00425681 | 2021-11-23 04:22:39 | Lumpkin, Georgia, US | |
725205 | 725205 | 2021-11-20 | US | Pennsylvania | Warren | 42123 | 4859 | 146 | 0 | 41.81304978 | -79.26969577 | 2021-11-21 04:22:13 | Warren, Pennsylvania, US | |
87654 | 87654 | 2021-11-09 | US | Arkansas | St. Francis | 5123 | 4859 | 69 | 0 | 35.02201976 | -90.74828138 | 2021-11-10 04:21:38 | St. Francis, Arkansas, US | |
3794959 | 3794959 | 2021-10-25 | US | Indiana | Adams | 18001 | 4859 | 77 | 0 | 40.7457653 | -84.93671406 | 2021-10-26 04:22:09 | Adams, Indiana, US | |
685822 | 685822 | 2021-10-24 | US | West Virginia | Greenbrier | 54025 | 4859 | 90 | 0 | 37.9463652 | -80.45335881 | 2021-10-25 04:22:31 | Greenbrier, West Virginia, US | |
445073 | 445073 | 2021-10-20 | US | Minnesota | Freeborn | 27047 | 4859 | 42 | 0 | 43.67385583 | -93.34884422 | 2021-10-21 04:21:18 | Freeborn, Minnesota, US | |
601260 | 601260 | 2021-10-19 | US | Wisconsin | Trempealeau | 55121 | 4859 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-10-20 04:21:00 | Trempealeau, Wisconsin, US | |
601242 | 601242 | 2021-10-19 | US | Wisconsin | Oneida | 55085 | 4859 | 88 | 0 | 45.70677897 | -89.51944105 | 2021-10-20 04:21:00 | Oneida, Wisconsin, US | |
492152 | 492152 | 2021-10-14 | US | Arkansas | Poinsett | 5111 | 4859 | 98 | 0 | 35.57433534 | -90.66268713 | 2021-10-15 04:21:26 | Poinsett, Arkansas, US | |
468252 | 468252 | 2021-10-07 | US | Georgia | Madison | 13195 | 4859 | 67 | 0 | 34.12920917 | -83.21218732 | 2021-10-08 04:21:25 | Madison, Georgia, US | |
2775194 | 2775194 | 2021-09-30 | US | New Mexico | Unassigned | 90035 | 4859 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-01 04:21:35 | Unassigned, New Mexico, US | |
708650 | 708650 | 2021-09-29 | US | New Mexico | Unassigned | 90035 | 4859 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-30 04:21:20 | Unassigned, New Mexico, US | |
707906 | 707906 | 2021-09-29 | US | Kentucky | Taylor | 21217 | 4859 | 72 | 0 | 37.3677562 | -85.3329931 | 2021-09-30 04:21:20 | Taylor, Kentucky, US | |
1336492 | 1336492 | 2021-09-28 | US | New Mexico | Unassigned | 90035 | 4859 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-29 04:21:45 | Unassigned, New Mexico, US | |
604196 | 604196 | 2021-09-23 | US | Ohio | Putnam | 39137 | 4859 | 108 | 0 | 41.02094889 | -84.1336111 | 2021-09-24 04:21:44 | Putnam, Ohio, US | |
3195919 | 3195919 | 2021-09-06 | US | Missouri | Lawrence | 29109 | 4859 | 97 | 0 | 37.10626634 | -93.83293097 | 2021-09-07 04:21:35 | Lawrence, Missouri, US | |
3895431 | 3895431 | 2021-08-29 | US | West Virginia | Ohio | 54069 | 4859 | 88 | 0 | 40.0955451 | -80.62203992 | 2021-08-30 04:21:23 | Ohio, West Virginia, US | |
3108262 | 3108262 | 2021-08-24 | US | South Carolina | Chester | 45023 | 4859 | 83 | 0 | 34.69249168 | -81.1583216 | 2021-08-25 04:21:41 | Chester, South Carolina, US | |
247862 | 247862 | 2021-08-17 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-18 04:21:35 | Sequoyah, Oklahoma, US | |
1606825 | 1606825 | 2021-08-16 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-17 04:21:49 | Sequoyah, Oklahoma, US | |
105919 | 105919 | 2021-08-15 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-16 04:21:31 | Sequoyah, Oklahoma, US | |
510277 | 510277 | 2021-08-14 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-15 04:21:41 | Sequoyah, Oklahoma, US | |
1486149 | 1486149 | 2021-08-13 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-14 04:21:25 | Sequoyah, Oklahoma, US | |
2902279 | 2902279 | 2021-08-12 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-13 04:21:24 | Sequoyah, Oklahoma, US | |
1344883 | 1344883 | 2021-08-11 | US | Oklahoma | Sequoyah | 40135 | 4859 | 57 | 0 | 35.49447108 | -94.75463785 | 2021-08-12 04:21:25 | Sequoyah, Oklahoma, US | |
332887 | 332887 | 2021-08-04 | US | Illinois | Effingham | 17049 | 4859 | 74 | 0 | 39.05935711 | -88.58969584 | 2021-08-05 04:21:51 | Effingham, Illinois, US | |
2674859 | 2674859 | 2021-07-18 | US | Illinois | Stephenson | 17177 | 4859 | 86 | 0 | 42.35129217 | -89.662598 | 2021-07-19 04:21:24 | Stephenson, Illinois, US | |
3708350 | 3708350 | 2021-07-17 | US | New York | Clinton | 36019 | 4859 | 33 | 0 | 44.74530905 | -73.67875352 | 2021-07-18 04:22:07 | Clinton, New York, US | |
3707171 | 3707171 | 2021-07-17 | US | Illinois | Stephenson | 17177 | 4859 | 86 | 0 | 42.35129217 | -89.662598 | 2021-07-18 04:22:07 | Stephenson, Illinois, US | |
2949581 | 2949581 | 2021-07-16 | US | New York | Clinton | 36019 | 4859 | 33 | 0 | 44.74530905 | -73.67875352 | 2021-07-17 04:22:22 | Clinton, New York, US | |
2948402 | 2948402 | 2021-07-16 | US | Illinois | Stephenson | 17177 | 4859 | 86 | 0 | 42.35129217 | -89.662598 | 2021-07-17 04:22:22 | Stephenson, Illinois, US | |
582445 | 582445 | 2021-07-13 | US | Wyoming | Sweetwater | 56037 | 4859 | 41 | 0 | 41.65943896 | -108.8827882 | 2021-07-14 04:21:35 | Sweetwater, Wyoming, US | |
2075030 | 2075030 | 2021-07-02 | US | Texas | Henderson | 48213 | 4859 | 194 | 0 | 32.21128872 | -95.85846587 | 2021-07-03 04:21:37 | Henderson, Texas, US | |
2768046 | 2768046 | 2021-07-01 | US | Texas | Henderson | 48213 | 4859 | 194 | 0 | 32.21128872 | -95.85846587 | 2021-07-02 04:21:47 | Henderson, Texas, US | |
1896254 | 1896254 | 2021-06-30 | US | Texas | Henderson | 48213 | 4859 | 194 | 0 | 32.21128872 | -95.85846587 | 2021-07-01 04:21:19 | Henderson, Texas, US | |
1894201 | 1894201 | 2021-06-30 | US | Illinois | Woodford | 17203 | 4859 | 82 | 0 | 40.78579374 | -89.20973757 | 2021-07-01 04:21:19 | Woodford, Illinois, US | |
403377 | 403377 | 2021-06-29 | US | Texas | Henderson | 48213 | 4859 | 194 | 0 | 32.21128872 | -95.85846587 | 2021-06-30 04:21:41 | Henderson, Texas, 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]);