johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
183 rows where confirmed = 4346 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755191 | 2755191 | 2022-12-29 | US | New York | Yates | 36123 | 4346 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-30 04:21:04 | Yates, New York, US | |
3177351 | 3177351 | 2022-12-19 | US | Wisconsin | Lafayette | 55065 | 4346 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-20 04:21:04 | Lafayette, Wisconsin, US | |
3377182 | 3377182 | 2022-12-08 | China | Shandong | 4346 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-09 04:21:05 | Shandong, China | |||
2162981 | 2162981 | 2022-10-16 | US | Washington | Jefferson | 53031 | 4346 | 31 | 0 | 47.75003077 | -123.5609704 | 2022-10-17 04:20:31 | Jefferson, Washington, US | |
519178 | 519178 | 2022-10-15 | US | Washington | Jefferson | 53031 | 4346 | 31 | 0 | 47.75003077 | -123.5609704 | 2022-10-16 04:22:39 | Jefferson, Washington, US | |
2036235 | 2036235 | 2022-10-14 | US | Washington | Jefferson | 53031 | 4346 | 31 | 0 | 47.75003077 | -123.5609704 | 2022-10-15 04:22:00 | Jefferson, Washington, US | |
3214897 | 3214897 | 2022-10-12 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-13 04:22:39 | Unassigned, California, US | |
3250746 | 3250746 | 2022-10-11 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-12 04:22:51 | Unassigned, California, US | |
2968005 | 2968005 | 2022-10-10 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-11 04:23:05 | Unassigned, California, US | |
3098041 | 3098041 | 2022-10-09 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-10 04:22:32 | Unassigned, California, US | |
4003266 | 4003266 | 2022-10-08 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-09 04:21:16 | Unassigned, California, US | |
396863 | 396863 | 2022-10-07 | US | California | Unassigned | 90006 | 4346 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-08 04:22:56 | Unassigned, California, US | |
2687361 | 2687361 | 2022-10-03 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-10-04 04:22:55 | Manistee, Michigan, US | |
2261428 | 2261428 | 2022-10-02 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-10-03 04:23:11 | Manistee, Michigan, US | |
2996954 | 2996954 | 2022-10-01 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-10-02 04:21:23 | Manistee, Michigan, US | |
855280 | 855280 | 2022-09-30 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-10-01 04:23:01 | Manistee, Michigan, US | |
2377206 | 2377206 | 2022-09-29 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-09-30 04:23:09 | Manistee, Michigan, US | |
1561757 | 1561757 | 2022-09-28 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-09-29 04:22:34 | Manistee, Michigan, US | |
3996300 | 3996300 | 2022-09-27 | US | Michigan | Manistee | 26101 | 4346 | 98 | 0 | 44.33352407 | -86.05626916 | 2022-09-28 04:23:01 | Manistee, Michigan, US | |
2355964 | 2355964 | 2022-09-16 | US | Arkansas | Howard | 5061 | 4346 | 53 | 0 | 34.09007427 | -93.9934871 | 2022-09-17 04:20:19 | Howard, Arkansas, US | |
2398164 | 2398164 | 2022-09-12 | US | Virginia | King William | 51101 | 4346 | 48 | 0 | 37.70965316 | -77.09384941 | 2022-09-13 04:20:57 | King William, Virginia, US | |
2396937 | 2396937 | 2022-09-12 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-13 04:20:57 | York, Nebraska, US | |
3768015 | 3768015 | 2022-09-11 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-12 04:20:58 | York, Nebraska, US | |
3826590 | 3826590 | 2022-09-10 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-11 04:20:50 | York, Nebraska, US | |
965047 | 965047 | 2022-09-09 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-10 04:21:10 | York, Nebraska, US | |
255449 | 255449 | 2022-09-08 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-09 04:21:11 | York, Nebraska, US | |
3747247 | 3747247 | 2022-09-07 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-08 04:21:02 | York, Nebraska, US | |
116887 | 116887 | 2022-09-06 | US | Nebraska | York | 31185 | 4346 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-07 04:20:59 | York, Nebraska, US | |
116080 | 116080 | 2022-09-06 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-07 04:20:59 | Osage, Kansas, US | |
2637206 | 2637206 | 2022-09-05 | US | West Virginia | Grant | 54023 | 4346 | 58 | 0 | 39.10314817 | -79.19440518 | 2022-09-06 04:21:02 | Grant, West Virginia, US | |
2636346 | 2636346 | 2022-09-05 | US | Oregon | Hood River | 41027 | 4346 | 47 | 0 | 45.51872811 | -121.6552036 | 2022-09-06 04:21:02 | Hood River, Oregon, US | |
2635052 | 2635052 | 2022-09-05 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-06 04:21:02 | Osage, Kansas, US | |
2990770 | 2990770 | 2022-09-04 | US | West Virginia | Grant | 54023 | 4346 | 58 | 0 | 39.10314817 | -79.19440518 | 2022-09-05 04:21:01 | Grant, West Virginia, US | |
2989910 | 2989910 | 2022-09-04 | US | Oregon | Hood River | 41027 | 4346 | 47 | 0 | 45.51872811 | -121.6552036 | 2022-09-05 04:21:01 | Hood River, Oregon, US | |
2988616 | 2988616 | 2022-09-04 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-05 04:21:01 | Osage, Kansas, US | |
2716455 | 2716455 | 2022-09-03 | US | West Virginia | Grant | 54023 | 4346 | 58 | 0 | 39.10314817 | -79.19440518 | 2022-09-04 04:21:22 | Grant, West Virginia, US | |
2715595 | 2715595 | 2022-09-03 | US | Oregon | Hood River | 41027 | 4346 | 47 | 0 | 45.51872811 | -121.6552036 | 2022-09-04 04:21:22 | Hood River, Oregon, US | |
2714301 | 2714301 | 2022-09-03 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-04 04:21:22 | Osage, Kansas, US | |
1397160 | 1397160 | 2022-09-02 | US | West Virginia | Grant | 54023 | 4346 | 58 | 0 | 39.10314817 | -79.19440518 | 2022-09-03 04:21:04 | Grant, West Virginia, US | |
1396300 | 1396300 | 2022-09-02 | US | Oregon | Hood River | 41027 | 4346 | 47 | 0 | 45.51872811 | -121.6552036 | 2022-09-03 04:21:04 | Hood River, Oregon, US | |
1395006 | 1395006 | 2022-09-02 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-03 04:21:04 | Osage, Kansas, US | |
3549509 | 3549509 | 2022-09-01 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-09-02 04:21:07 | Glacier, Montana, US | |
3548835 | 3548835 | 2022-09-01 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-02 04:21:07 | Osage, Kansas, US | |
2345429 | 2345429 | 2022-08-31 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-09-01 04:21:03 | Glacier, Montana, US | |
2344755 | 2344755 | 2022-08-31 | US | Kansas | Osage | 20139 | 4346 | 62 | 0 | 38.65235984 | -95.72707998 | 2022-09-01 04:21:03 | Osage, Kansas, US | |
3775909 | 3775909 | 2022-08-30 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-08-31 04:20:57 | Glacier, Montana, US | |
1682505 | 1682505 | 2022-08-29 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-08-30 04:21:03 | Glacier, Montana, US | |
1878989 | 1878989 | 2022-08-28 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-08-29 04:21:06 | Glacier, Montana, US | |
2098116 | 2098116 | 2022-08-27 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-08-28 04:21:02 | Glacier, Montana, US | |
1533931 | 1533931 | 2022-08-26 | US | Montana | Glacier | 30035 | 4346 | 75 | 0 | 48.70513576 | -112.9934235 | 2022-08-27 04:20:57 | Glacier, Montana, US | |
2366257 | 2366257 | 2022-08-19 | US | Puerto Rico | Luquillo | 72089 | 4346 | 0 | 0 | 18.342114 | -65.725097 | 2022-08-20 04:21:01 | Luquillo, Puerto Rico, US | |
1164542 | 1164542 | 2022-08-18 | US | Virginia | Manassas Park | 51685 | 4346 | 28 | 0 | 38.77058531 | -77.44399307 | 2022-08-19 04:20:54 | Manassas Park, Virginia, US | |
899309 | 899309 | 2022-07-24 | US | Texas | Llano | 48299 | 4346 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-07-25 04:20:51 | Llano, Texas, US | |
1766483 | 1766483 | 2022-06-20 | US | Texas | Lee | 48287 | 4346 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-06-21 04:20:56 | Lee, Texas, US | |
3272282 | 3272282 | 2022-06-19 | US | Puerto Rico | Orocovis | 72107 | 4346 | 0 | 0 | 18.215046 | -66.433604 | 2022-06-20 04:21:01 | Orocovis, Puerto Rico, US | |
232106 | 232106 | 2022-05-31 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-06-01 04:20:55 | Hughes, South Dakota, US | |
3188871 | 3188871 | 2022-05-30 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-31 04:20:51 | Hughes, South Dakota, US | |
3201020 | 3201020 | 2022-05-29 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-30 04:20:50 | Hughes, South Dakota, US | |
2727898 | 2727898 | 2022-05-28 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-29 04:20:53 | Hughes, South Dakota, US | |
1317079 | 1317079 | 2022-05-27 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-28 04:21:07 | Hughes, South Dakota, US | |
1852871 | 1852871 | 2022-05-26 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-27 04:20:56 | Hughes, South Dakota, US | |
2051406 | 2051406 | 2022-05-25 | US | Wisconsin | Crawford | 55023 | 4346 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-05-26 04:20:50 | Crawford, Wisconsin, US | |
2050747 | 2050747 | 2022-05-25 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-26 04:20:50 | Hughes, South Dakota, US | |
625417 | 625417 | 2022-05-22 | US | Wisconsin | Crawford | 55023 | 4346 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-05-26 04:20:50 | Crawford, Wisconsin, US | |
624758 | 624758 | 2022-05-22 | US | South Dakota | Hughes | 46065 | 4346 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-05-26 04:20:50 | Hughes, South Dakota, US | |
1329770 | 1329770 | 2022-04-26 | US | West Virginia | Wetzel | 54103 | 4346 | 86 | 0 | 39.6065771 | -80.64016540000001 | 2022-04-27 04:20:52 | Wetzel, West Virginia, US | |
3725724 | 3725724 | 2022-04-25 | US | West Virginia | Wetzel | 54103 | 4346 | 86 | 0 | 39.6065771 | -80.64016540000001 | 2022-04-26 04:20:51 | Wetzel, West Virginia, US | |
3629468 | 3629468 | 2022-03-13 | US | Louisiana | Jackson | 22049 | 4346 | 73 | 0 | 32.30251776 | -92.55692092 | 2022-03-14 04:20:46 | Jackson, Louisiana, US | |
952376 | 952376 | 2022-03-12 | US | Louisiana | Jackson | 22049 | 4346 | 73 | 0 | 32.30251776 | -92.55692092 | 2022-03-13 04:20:49 | Jackson, Louisiana, US | |
357837 | 357837 | 2022-03-11 | US | Louisiana | Jackson | 22049 | 4346 | 73 | 0 | 32.30251776 | -92.55692092 | 2022-03-12 04:20:50 | Jackson, Louisiana, US | |
1866989 | 1866989 | 2022-03-10 | US | Louisiana | Jackson | 22049 | 4346 | 72 | 0 | 32.30251776 | -92.55692092 | 2022-03-11 04:20:50 | Jackson, Louisiana, US | |
920583 | 920583 | 2022-03-08 | US | Georgia | Washington | 13303 | 4346 | 132 | 0 | 32.96711864 | -82.79357039 | 2022-03-09 04:20:59 | Washington, Georgia, US | |
2666441 | 2666441 | 2022-03-04 | US | Colorado | Otero | 8089 | 4346 | 129 | 0 | 37.9014485 | -103.7173385 | 2022-03-05 04:21:10 | Otero, Colorado, US | |
1995386 | 1995386 | 2022-03-01 | US | Puerto Rico | Camuy | 72027 | 4346 | 0 | 0 | 18.418578 | -66.860206 | 2022-03-02 04:21:07 | Camuy, Puerto Rico, US | |
945560 | 945560 | 2022-02-28 | US | Puerto Rico | Camuy | 72027 | 4346 | 0 | 0 | 18.418578 | -66.860206 | 2022-03-01 04:21:09 | Camuy, Puerto Rico, US | |
2735751 | 2735751 | 2022-02-27 | US | Puerto Rico | Camuy | 72027 | 4346 | 0 | 0 | 18.418578 | -66.860206 | 2022-02-28 04:21:05 | Camuy, Puerto Rico, US | |
1299112 | 1299112 | 2022-02-17 | US | Illinois | White | 17193 | 4346 | 45 | 0 | 38.08706198 | -88.17657461 | 2022-02-18 04:21:04 | White, Illinois, US | |
71936 | 71936 | 2022-02-07 | US | Georgia | Meriwether | 13199 | 4346 | 129 | 0 | 33.04163534 | -84.68859732 | 2022-02-08 04:21:15 | Meriwether, Georgia, US | |
71581 | 71581 | 2022-02-07 | US | Arkansas | Hempstead | 5057 | 4346 | 52 | 0 | 33.73325583 | -93.66935133 | 2022-02-08 04:21:15 | Hempstead, Arkansas, US | |
3301624 | 3301624 | 2022-01-30 | US | Kentucky | Henry | 21103 | 4346 | 42 | 0 | 38.44942688 | -85.11587507 | 2022-01-31 04:21:09 | Henry, Kentucky, US | |
3063415 | 3063415 | 2022-01-29 | US | Kentucky | Henry | 21103 | 4346 | 42 | 0 | 38.44942688 | -85.11587507 | 2022-01-30 04:21:26 | Henry, Kentucky, US | |
3813138 | 3813138 | 2022-01-28 | US | Texas | Reeves | 48389 | 4346 | 64 | 0 | 31.32323325 | -103.69038959999999 | 2022-01-29 04:21:10 | Reeves, Texas, US | |
3811349 | 3811349 | 2022-01-28 | US | Kentucky | Henry | 21103 | 4346 | 42 | 0 | 38.44942688 | -85.11587507 | 2022-01-29 04:21:10 | Henry, Kentucky, US | |
1782710 | 1782710 | 2022-01-27 | US | Virginia | Colonial Heights | 51570 | 4346 | 72 | 0 | 37.26420587 | -77.39609676 | 2022-01-28 04:21:09 | Colonial Heights, Virginia, US | |
1116549 | 1116549 | 2022-01-11 | US | Tennessee | Johnson | 47091 | 4346 | 69 | 0 | 36.45523950000001 | -81.84886538 | 2022-01-12 04:21:44 | Johnson, Tennessee, US | |
1695357 | 1695357 | 2022-01-10 | US | Texas | Calhoun | 48057 | 4346 | 40 | 0 | 28.47048236 | -96.61633945 | 2022-01-11 04:22:01 | Calhoun, Texas, US | |
127820 | 127820 | 2022-01-09 | US | Indiana | Fountain | 18045 | 4346 | 77 | 0 | 40.12361933 | -87.24217689 | 2022-01-10 04:22:07 | Fountain, Indiana, US | |
1216655 | 1216655 | 2022-01-08 | US | Indiana | Fountain | 18045 | 4346 | 77 | 0 | 40.12361933 | -87.24217689 | 2022-01-09 04:21:46 | Fountain, Indiana, US | |
1390748 | 1390748 | 2022-01-07 | US | Indiana | Fountain | 18045 | 4346 | 77 | 0 | 40.12361933 | -87.24217689 | 2022-01-08 04:21:53 | Fountain, Indiana, US | |
3520386 | 3520386 | 2022-01-02 | US | Idaho | Payette | 16075 | 4346 | 74 | 0 | 44.00545243 | -116.7647695 | 2022-01-03 02:22:25 | Payette, Idaho, US | |
2169144 | 2169144 | 2022-01-01 | US | Maryland | Garrett | 24023 | 4346 | 98 | 0 | 39.52786077 | -79.27355126 | 2022-01-02 04:20:52 | Garrett, Maryland, US | |
2168516 | 2168516 | 2022-01-01 | US | Idaho | Payette | 16075 | 4346 | 74 | 0 | 44.00545243 | -116.7647695 | 2022-01-02 04:20:52 | Payette, Idaho, US | |
2777947 | 2777947 | 2021-12-31 | US | Idaho | Payette | 16075 | 4346 | 74 | 0 | 44.00545243 | -116.7647695 | 2022-01-01 04:22:14 | Payette, Idaho, US | |
3999604 | 3999604 | 2021-12-30 | US | Idaho | Payette | 16075 | 4346 | 74 | 0 | 44.00545243 | -116.7647695 | 2021-12-31 04:21:50 | Payette, Idaho, US | |
1669100 | 1669100 | 2021-12-29 | US | Colorado | Morgan | 8087 | 4346 | 129 | 0 | 40.26279810000001 | -103.8093302 | 2021-12-30 04:21:25 | Morgan, Colorado, US | |
1435912 | 1435912 | 2021-12-28 | US | Virginia | Gloucester | 51073 | 4346 | 83 | 0 | 37.40809042 | -76.53524337 | 2021-12-29 03:21:43 | Gloucester, Virginia, US | |
3819560 | 3819560 | 2021-12-23 | US | Texas | Karnes | 48255 | 4346 | 58 | 0 | 28.90705334 | -97.85960149 | 2021-12-24 04:21:34 | Karnes, Texas, US | |
3831093 | 3831093 | 2021-12-21 | US | Oregon | Jefferson | 41031 | 4346 | 69 | 0 | 44.62806839 | -121.17832 | 2021-12-22 04:21:54 | Jefferson, Oregon, US | |
1256643 | 1256643 | 2021-12-20 | US | Missouri | Audrain | 29007 | 4346 | 81 | 0 | 39.215877 | -91.84242683 | 2021-12-21 03:21:27 | Audrain, Missouri, US | |
783267 | 783267 | 2021-12-13 | US | Georgia | Sumter | 13261 | 4346 | 141 | 0 | 32.03650571 | -84.19821492 | 2021-12-14 04:22:38 | Sumter, 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]);