johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
393 rows where confirmed = 1655 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952321 | 2952321 | 2022-12-20 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-21 04:21:03 | Caribou, Idaho, US | |
3174723 | 3174723 | 2022-12-19 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-20 04:21:04 | Caribou, Idaho, US | |
1629240 | 1629240 | 2022-12-18 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-19 04:21:03 | Caribou, Idaho, US | |
504619 | 504619 | 2022-12-17 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-18 04:21:03 | Caribou, Idaho, US | |
3325191 | 3325191 | 2022-12-16 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-17 04:21:04 | Caribou, Idaho, US | |
543703 | 543703 | 2022-12-15 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-16 04:21:01 | Caribou, Idaho, US | |
349231 | 349231 | 2022-12-14 | US | Idaho | Caribou | 16029 | 1655 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-15 04:20:58 | Caribou, Idaho, US | |
2559755 | 2559755 | 2022-11-29 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-30 04:21:07 | Lynn, Texas, US | |
1242829 | 1242829 | 2022-11-28 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-29 04:21:05 | Lynn, Texas, US | |
3554817 | 3554817 | 2022-11-27 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-28 04:21:02 | Lynn, Texas, US | |
2103297 | 2103297 | 2022-11-26 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-27 04:21:05 | Lynn, Texas, US | |
490788 | 490788 | 2022-11-25 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-26 04:21:11 | Lynn, Texas, US | |
3526617 | 3526617 | 2022-11-24 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-25 04:21:06 | Lynn, Texas, US | |
3315400 | 3315400 | 2022-11-23 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-24 04:21:09 | Lynn, Texas, US | |
1623441 | 1623441 | 2022-11-22 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-23 04:21:06 | Lynn, Texas, US | |
3463329 | 3463329 | 2022-11-21 | US | Texas | Lynn | 48305 | 1655 | 41 | 0 | 33.17657705 | -101.8162849 | 2022-11-22 04:20:47 | Lynn, Texas, US | |
915002 | 915002 | 2022-10-29 | US | Puerto Rico | Vieques | 72147 | 1655 | 0 | 0 | 18.123276 | -65.440971 | 2022-10-30 04:22:14 | Vieques, Puerto Rico, US | |
2377441 | 2377441 | 2022-09-29 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-30 04:23:09 | Dade, Missouri, US | |
1563140 | 1563140 | 2022-09-28 | US | Texas | Carson | 48065 | 1655 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-09-29 04:22:34 | Carson, Texas, US | |
1561992 | 1561992 | 2022-09-28 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-29 04:22:34 | Dade, Missouri, US | |
3998191 | 3998191 | 2022-09-27 | US | Wisconsin | Iron | 55051 | 1655 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-09-28 04:23:01 | Iron, Wisconsin, US | |
3997683 | 3997683 | 2022-09-27 | US | Texas | Carson | 48065 | 1655 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-09-28 04:23:01 | Carson, Texas, US | |
3996535 | 3996535 | 2022-09-27 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-28 04:23:01 | Dade, Missouri, US | |
2772011 | 2772011 | 2022-09-26 | US | Texas | Carson | 48065 | 1655 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-09-27 04:23:01 | Carson, Texas, US | |
2770863 | 2770863 | 2022-09-26 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-27 04:23:01 | Dade, Missouri, US | |
1980060 | 1980060 | 2022-09-25 | US | Washington | Ferry | 53019 | 1655 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-09-26 04:20:52 | Ferry, Washington, US | |
1978516 | 1978516 | 2022-09-25 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-26 04:20:52 | Dade, Missouri, US | |
2653227 | 2653227 | 2022-09-24 | US | Washington | Ferry | 53019 | 1655 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-09-25 04:23:31 | Ferry, Washington, US | |
2651683 | 2651683 | 2022-09-24 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-25 04:23:31 | Dade, Missouri, US | |
387667 | 387667 | 2022-09-23 | US | Washington | Ferry | 53019 | 1655 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-09-24 04:21:40 | Ferry, Washington, US | |
386123 | 386123 | 2022-09-23 | US | Missouri | Dade | 29057 | 1655 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-24 04:21:40 | Dade, Missouri, US | |
1626325 | 1626325 | 2022-09-22 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-23 04:23:13 | Stillwater, Montana, US | |
1372529 | 1372529 | 2022-09-21 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-22 04:22:56 | Stillwater, Montana, US | |
2018759 | 2018759 | 2022-09-20 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-21 04:23:22 | Stillwater, Montana, US | |
3572632 | 3572632 | 2022-09-19 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-20 04:22:48 | Stillwater, Montana, US | |
421371 | 421371 | 2022-09-18 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-19 04:21:49 | Stillwater, Montana, US | |
3375395 | 3375395 | 2022-09-17 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-18 04:22:50 | Stillwater, Montana, US | |
2357503 | 2357503 | 2022-09-16 | US | Montana | Stillwater | 30095 | 1655 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-09-17 04:20:19 | Stillwater, Montana, US | |
375724 | 375724 | 2022-09-13 | US | West Virginia | Wirt | 54105 | 1655 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-09-14 04:20:44 | Wirt, West Virginia, US | |
2398326 | 2398326 | 2022-09-12 | US | West Virginia | Wirt | 54105 | 1655 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-09-13 04:20:57 | Wirt, West Virginia, US | |
115379 | 115379 | 2022-09-06 | US | Colorado | Huerfano | 8055 | 1655 | 38 | 0 | 37.68473101 | -104.9612585 | 2022-09-07 04:20:59 | Huerfano, Colorado, US | |
3953094 | 3953094 | 2022-08-17 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-18 04:21:11 | Tillman, Oklahoma, US | |
993596 | 993596 | 2022-08-16 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-17 04:20:59 | Tillman, Oklahoma, US | |
2496635 | 2496635 | 2022-08-15 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-16 04:20:58 | Tillman, Oklahoma, US | |
2496456 | 2496456 | 2022-08-15 | US | North Dakota | Ransom | 38073 | 1655 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-08-16 04:20:58 | Ransom, North Dakota, US | |
3650185 | 3650185 | 2022-08-14 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-15 04:20:59 | Tillman, Oklahoma, US | |
1971191 | 1971191 | 2022-08-13 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-14 04:20:55 | Tillman, Oklahoma, US | |
2891000 | 2891000 | 2022-08-12 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-13 04:20:52 | Tillman, Oklahoma, US | |
3910605 | 3910605 | 2022-08-11 | US | Oklahoma | Tillman | 40141 | 1655 | 36 | 0 | 34.37288446 | -98.92426619 | 2022-08-12 04:20:54 | Tillman, Oklahoma, US | |
2009203 | 2009203 | 2022-08-04 | US | Arkansas | Montgomery | 5097 | 1655 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-08-05 04:20:52 | Montgomery, Arkansas, US | |
2336447 | 2336447 | 2022-07-27 | US | Illinois | Stark | 17175 | 1655 | 37 | 0 | 41.09309773 | -89.79745866 | 2022-07-28 04:20:56 | Stark, Illinois, US | |
1488637 | 1488637 | 2022-07-26 | US | Illinois | Stark | 17175 | 1655 | 37 | 0 | 41.09309773 | -89.79745866 | 2022-07-27 04:21:04 | Stark, Illinois, US | |
673320 | 673320 | 2022-07-21 | US | Texas | Bailey | 48017 | 1655 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-22 04:21:15 | Bailey, Texas, US | |
1608855 | 1608855 | 2022-07-20 | US | California | Trinity | 6105 | 1655 | 20 | 0 | 40.6491767 | -123.114713 | 2022-07-21 04:21:10 | Trinity, California, US | |
2190004 | 2190004 | 2022-06-22 | US | North Dakota | Bottineau | 38009 | 1655 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-06-23 04:20:55 | Bottineau, North Dakota, US | |
168435 | 168435 | 2022-06-21 | US | North Dakota | Bottineau | 38009 | 1655 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-06-22 04:20:54 | Bottineau, North Dakota, US | |
949471 | 949471 | 2022-06-14 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-15 04:20:54 | Harney, Oregon, US | |
2981879 | 2981879 | 2022-06-13 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-14 04:20:52 | Harney, Oregon, US | |
2238005 | 2238005 | 2022-06-12 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-13 04:21:14 | Harney, Oregon, US | |
3144203 | 3144203 | 2022-06-11 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-12 04:20:53 | Harney, Oregon, US | |
1947119 | 1947119 | 2022-06-10 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-11 04:21:01 | Harney, Oregon, US | |
3160258 | 3160258 | 2022-06-09 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-10 04:20:55 | Harney, Oregon, US | |
1423725 | 1423725 | 2022-06-08 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-09 04:20:54 | Harney, Oregon, US | |
3728839 | 3728839 | 2022-06-07 | US | Oregon | Harney | 41025 | 1655 | 40 | 0 | 43.06422669 | -118.9666306 | 2022-06-08 04:20:55 | Harney, Oregon, US | |
971551 | 971551 | 2022-06-01 | US | Colorado | Kit Carson | 8063 | 1655 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-06-02 05:20:39 | Kit Carson, Colorado, US | |
3002341 | 3002341 | 2022-05-24 | US | Texas | Brooks | 48047 | 1655 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-05-25 04:20:56 | Brooks, Texas, US | |
3000603 | 3000603 | 2022-05-24 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-25 04:20:56 | Harper, Kansas, US | |
3594324 | 3594324 | 2022-05-23 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-24 04:20:57 | Harper, Kansas, US | |
1110872 | 1110872 | 2022-05-21 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-22 04:20:52 | Harper, Kansas, US | |
1170496 | 1170496 | 2022-05-20 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-21 04:20:58 | Harper, Kansas, US | |
3897259 | 3897259 | 2022-05-19 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-20 04:20:57 | Harper, Kansas, US | |
1186043 | 1186043 | 2022-05-18 | US | Kansas | Harper | 20077 | 1655 | 28 | 0 | 37.19175361 | -98.07578384 | 2022-05-19 04:20:54 | Harper, Kansas, US | |
2598657 | 2598657 | 2022-05-05 | US | Colorado | Clear Creek | 8019 | 1655 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-05-06 04:21:00 | Clear Creek, Colorado, US | |
2597850 | 2597850 | 2022-05-05 | China | Liaoning | 1655 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-06 04:21:00 | Liaoning, China | |||
2480515 | 2480515 | 2022-03-30 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-31 04:20:56 | Coal, Oklahoma, US | |
160556 | 160556 | 2022-03-29 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-30 04:20:45 | Coal, Oklahoma, US | |
1439127 | 1439127 | 2022-03-28 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-29 04:20:46 | Coal, Oklahoma, US | |
878808 | 878808 | 2022-03-27 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-28 04:20:33 | Coal, Oklahoma, US | |
2166091 | 2166091 | 2022-03-26 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-27 04:20:47 | Coal, Oklahoma, US | |
1723027 | 1723027 | 2022-03-25 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-26 04:20:23 | Coal, Oklahoma, US | |
1470644 | 1470644 | 2022-03-24 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-25 04:20:46 | Coal, Oklahoma, US | |
3024818 | 3024818 | 2022-03-23 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-24 04:20:43 | Coal, Oklahoma, US | |
1907740 | 1907740 | 2022-03-22 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-23 04:20:48 | Coal, Oklahoma, US | |
3240871 | 3240871 | 2022-03-21 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-22 04:20:54 | Coal, Oklahoma, US | |
26944 | 26944 | 2022-03-20 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-21 04:20:50 | Coal, Oklahoma, US | |
1658954 | 1658954 | 2022-03-19 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-20 04:20:45 | Coal, Oklahoma, US | |
338480 | 338480 | 2022-03-18 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-19 04:20:47 | Coal, Oklahoma, US | |
696933 | 696933 | 2022-03-17 | US | Oklahoma | Coal | 40029 | 1655 | 23 | 0 | 34.58840127 | -96.29798747 | 2022-03-18 04:20:55 | Coal, Oklahoma, US | |
922405 | 922405 | 2022-03-08 | US | Puerto Rico | Arroyo | 72015 | 1655 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-03-09 04:20:59 | Arroyo, Puerto Rico, US | |
2328015 | 2328015 | 2022-02-04 | US | Colorado | Rio Blanco | 8103 | 1655 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-02-05 04:21:05 | Rio Blanco, Colorado, US | |
981515 | 981515 | 2022-02-01 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-02-02 04:21:09 | Kiowa, Oklahoma, US | |
2660357 | 2660357 | 2022-01-31 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-02-01 04:21:11 | Kiowa, Oklahoma, US | |
3302774 | 3302774 | 2022-01-30 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-01-31 04:21:09 | Kiowa, Oklahoma, US | |
3064565 | 3064565 | 2022-01-29 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-01-30 04:21:26 | Kiowa, Oklahoma, US | |
3812499 | 3812499 | 2022-01-28 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-01-29 04:21:10 | Kiowa, Oklahoma, US | |
1781953 | 1781953 | 2022-01-27 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-01-28 04:21:09 | Kiowa, Oklahoma, US | |
1320781 | 1320781 | 2022-01-26 | US | Oklahoma | Kiowa | 40075 | 1655 | 48 | 0 | 34.91671958 | -98.97720696 | 2022-01-27 04:21:19 | Kiowa, Oklahoma, US | |
1319611 | 1319611 | 2022-01-26 | US | Kentucky | Elliott | 21063 | 1655 | 14 | 0 | 38.11624059 | -83.09771563 | 2022-01-27 04:21:19 | Elliott, Kentucky, US | |
3230068 | 3230068 | 2022-01-19 | US | Wyoming | Sublette | 56035 | 1655 | 24 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-20 04:21:07 | Sublette, Wyoming, US | |
3227598 | 3227598 | 2022-01-19 | US | Indiana | Union | 18161 | 1655 | 19 | 0 | 39.62550777 | -84.92497066 | 2022-01-20 04:21:07 | Union, Indiana, 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]);