johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
471 rows where confirmed = 1569 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752706 | 2752706 | 2022-12-29 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-30 04:21:04 | Macau, China | |||
1073712 | 1073712 | 2022-12-28 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-29 04:21:01 | Macau, China | |||
327709 | 327709 | 2022-12-27 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-28 04:21:04 | Macau, China | |||
217782 | 217782 | 2022-12-26 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-27 04:21:07 | Macau, China | |||
3222239 | 3222239 | 2022-12-25 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-26 04:21:06 | Macau, China | |||
1018153 | 1018153 | 2022-12-24 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-25 04:21:04 | Macau, China | |||
690176 | 690176 | 2022-12-23 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-24 04:21:02 | Macau, China | |||
2179386 | 2179386 | 2022-12-22 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-23 04:21:04 | Macau, China | |||
451190 | 451190 | 2022-12-21 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-22 04:20:56 | Macau, China | |||
2951189 | 2951189 | 2022-12-20 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-21 04:21:03 | Macau, China | |||
3173591 | 3173591 | 2022-12-19 | China | Macau | 1569 | 13 | 0 | 22.1667 | 113.55 | 2022-12-20 04:21:04 | Macau, China | |||
309229 | 309229 | 2022-12-13 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-14 04:21:04 | Rooks, Kansas, US | |
1150290 | 1150290 | 2022-12-12 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-13 04:21:01 | Rooks, Kansas, US | |
870144 | 870144 | 2022-12-11 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-12 04:21:01 | Rooks, Kansas, US | |
258674 | 258674 | 2022-12-10 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-11 04:20:50 | Rooks, Kansas, US | |
3937388 | 3937388 | 2022-12-09 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-10 04:21:02 | Rooks, Kansas, US | |
3378720 | 3378720 | 2022-12-08 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-09 04:21:05 | Rooks, Kansas, US | |
1985991 | 1985991 | 2022-12-07 | US | Kansas | Rooks | 20163 | 1569 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-08 04:21:07 | Rooks, Kansas, US | |
3462593 | 3462593 | 2022-11-21 | US | North Dakota | Sioux | 38085 | 1569 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-22 04:20:47 | Sioux, North Dakota, US | |
293210 | 293210 | 2022-11-15 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-16 04:21:09 | Fremont, Iowa, US | |
3598240 | 3598240 | 2022-11-14 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-15 04:21:16 | Fremont, Iowa, US | |
313098 | 313098 | 2022-11-13 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-14 04:21:09 | Fremont, Iowa, US | |
64259 | 64259 | 2022-11-12 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-13 04:21:14 | Fremont, Iowa, US | |
2928421 | 2928421 | 2022-11-11 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-12 04:20:41 | Fremont, Iowa, US | |
2507257 | 2507257 | 2022-11-10 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-11 04:21:22 | Fremont, Iowa, US | |
2432132 | 2432132 | 2022-11-09 | US | Iowa | Fremont | 19071 | 1569 | 28 | 0 | 40.7454272 | -95.60129045 | 2022-11-10 04:21:16 | Fremont, Iowa, US | |
1833065 | 1833065 | 2022-10-25 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-26 04:22:19 | Tripp, South Dakota, US | |
797326 | 797326 | 2022-10-24 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-25 04:21:53 | Tripp, South Dakota, US | |
3279781 | 3279781 | 2022-10-23 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-24 04:22:29 | Tripp, South Dakota, US | |
2270819 | 2270819 | 2022-10-22 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-23 04:22:46 | Tripp, South Dakota, US | |
1595119 | 1595119 | 2022-10-21 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-22 04:22:53 | Tripp, South Dakota, US | |
2274835 | 2274835 | 2022-10-20 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-21 04:22:23 | Tripp, South Dakota, US | |
201170 | 201170 | 2022-10-19 | US | South Dakota | Tripp | 46123 | 1569 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-20 04:22:59 | Tripp, South Dakota, US | |
3253536 | 3253536 | 2022-10-11 | US | Virginia | Norton | 51720 | 1569 | 23 | 0 | 36.93357076 | -82.62750411 | 2022-10-12 04:22:51 | Norton, Virginia, US | |
133657 | 133657 | 2022-10-04 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-10-05 04:23:06 | Spink, South Dakota, US | |
2688604 | 2688604 | 2022-10-03 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-10-04 04:22:55 | Spink, South Dakota, US | |
2262671 | 2262671 | 2022-10-02 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-10-03 04:23:11 | Spink, South Dakota, US | |
2998197 | 2998197 | 2022-10-01 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-10-02 04:21:23 | Spink, South Dakota, US | |
856523 | 856523 | 2022-09-30 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-10-01 04:23:01 | Spink, South Dakota, US | |
2378449 | 2378449 | 2022-09-29 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-09-30 04:23:09 | Spink, South Dakota, US | |
1563000 | 1563000 | 2022-09-28 | US | South Dakota | Spink | 46115 | 1569 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-09-29 04:22:34 | Spink, South Dakota, US | |
3550678 | 3550678 | 2022-09-01 | US | Texas | McCulloch | 48307 | 1569 | 48 | 0 | 31.1925468 | -99.34682807 | 2022-09-02 04:21:07 | McCulloch, Texas, US | |
3774347 | 3774347 | 2022-08-30 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-31 04:20:57 | Unassigned, Alaska, US | |
1680943 | 1680943 | 2022-08-29 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-30 04:21:03 | Unassigned, Alaska, US | |
1877427 | 1877427 | 2022-08-28 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-29 04:21:06 | Unassigned, Alaska, US | |
2096554 | 2096554 | 2022-08-27 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Alaska, US | |
1532369 | 1532369 | 2022-08-26 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-27 04:20:57 | Unassigned, Alaska, US | |
2829256 | 2829256 | 2022-08-25 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-26 04:21:02 | Unassigned, Alaska, US | |
2323789 | 2323789 | 2022-08-24 | US | Alaska | Unassigned | 90002 | 1569 | 0 | 0 | 69.31479216 | 0.0 | 2022-08-25 04:21:13 | Unassigned, Alaska, US | |
3650912 | 3650912 | 2022-08-14 | US | Virginia | Cumberland | 51049 | 1569 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-15 04:20:59 | Cumberland, Virginia, US | |
1971918 | 1971918 | 2022-08-13 | US | Virginia | Cumberland | 51049 | 1569 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-14 04:20:55 | Cumberland, Virginia, US | |
2891727 | 2891727 | 2022-08-12 | US | Virginia | Cumberland | 51049 | 1569 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-13 04:20:52 | Cumberland, Virginia, US | |
2009623 | 2009623 | 2022-08-04 | US | Idaho | Caribou | 16029 | 1569 | 29 | 0 | 42.77149116 | -111.5597683 | 2022-08-05 04:20:52 | Caribou, Idaho, US | |
1099050 | 1099050 | 2022-08-03 | US | Idaho | Caribou | 16029 | 1569 | 29 | 0 | 42.77149116 | -111.5597683 | 2022-08-04 04:20:58 | Caribou, Idaho, US | |
1488455 | 1488455 | 2022-07-26 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-27 04:21:04 | Randolph, Georgia, US | |
2596429 | 2596429 | 2022-07-25 | US | North Dakota | Dickey | 38021 | 1569 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-07-26 04:20:58 | Dickey, North Dakota, US | |
2594901 | 2594901 | 2022-07-25 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-26 04:20:58 | Randolph, Georgia, US | |
897016 | 897016 | 2022-07-24 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-25 04:20:51 | Randolph, Georgia, US | |
92010 | 92010 | 2022-07-23 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-24 04:20:47 | Randolph, Georgia, US | |
901032 | 901032 | 2022-07-22 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-23 04:20:53 | Randolph, Georgia, US | |
671168 | 671168 | 2022-07-21 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-22 04:21:15 | Randolph, Georgia, US | |
1609131 | 1609131 | 2022-07-20 | US | Georgia | Randolph | 13243 | 1569 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-07-21 04:21:10 | Randolph, Georgia, US | |
960218 | 960218 | 2022-07-19 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-20 04:20:59 | Morris, Kansas, US | |
959725 | 959725 | 2022-07-19 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-20 04:20:59 | Jenkins, Georgia, US | |
959340 | 959340 | 2022-07-19 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-20 04:20:59 | Yukon-Koyukuk, Alaska, US | |
3211605 | 3211605 | 2022-07-18 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-19 04:20:58 | Morris, Kansas, US | |
3211112 | 3211112 | 2022-07-18 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-19 04:20:58 | Jenkins, Georgia, US | |
3210727 | 3210727 | 2022-07-18 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-19 04:20:58 | Yukon-Koyukuk, Alaska, US | |
3406780 | 3406780 | 2022-07-17 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-18 04:20:59 | Morris, Kansas, US | |
3406287 | 3406287 | 2022-07-17 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-18 04:20:59 | Jenkins, Georgia, US | |
3405902 | 3405902 | 2022-07-17 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-18 04:20:59 | Yukon-Koyukuk, Alaska, US | |
2152980 | 2152980 | 2022-07-16 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-17 04:21:15 | Morris, Kansas, US | |
2152487 | 2152487 | 2022-07-16 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-17 04:21:15 | Jenkins, Georgia, US | |
2152102 | 2152102 | 2022-07-16 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-17 04:21:15 | Yukon-Koyukuk, Alaska, US | |
2420213 | 2420213 | 2022-07-15 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-16 04:21:05 | Morris, Kansas, US | |
2419720 | 2419720 | 2022-07-15 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-16 04:21:05 | Jenkins, Georgia, US | |
2419335 | 2419335 | 2022-07-15 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-16 04:21:05 | Yukon-Koyukuk, Alaska, US | |
3430288 | 3430288 | 2022-07-14 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-15 04:20:53 | Morris, Kansas, US | |
3429795 | 3429795 | 2022-07-14 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-15 04:20:53 | Jenkins, Georgia, US | |
3429410 | 3429410 | 2022-07-14 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-15 04:20:53 | Yukon-Koyukuk, Alaska, US | |
3112530 | 3112530 | 2022-07-13 | US | Texas | Carson | 48065 | 1569 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-14 04:20:57 | Carson, Texas, US | |
3110808 | 3110808 | 2022-07-13 | US | Kansas | Morris | 20127 | 1569 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-14 04:20:57 | Morris, Kansas, US | |
3110315 | 3110315 | 2022-07-13 | US | Georgia | Jenkins | 13165 | 1569 | 68 | 0 | 32.79248718 | -81.96040187 | 2022-07-14 04:20:57 | Jenkins, Georgia, US | |
3109930 | 3109930 | 2022-07-13 | US | Alaska | Yukon-Koyukuk | 2290 | 1569 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-07-14 04:20:57 | Yukon-Koyukuk, Alaska, US | |
3967062 | 3967062 | 2022-07-05 | US | Arkansas | Montgomery | 5097 | 1569 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-06 04:20:58 | Montgomery, Arkansas, US | |
3081226 | 3081226 | 2022-07-04 | US | Texas | Lynn | 48305 | 1569 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-05 04:20:45 | Lynn, Texas, US | |
3078573 | 3078573 | 2022-07-04 | US | Arkansas | Montgomery | 5097 | 1569 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-05 04:20:45 | Montgomery, Arkansas, US | |
1770508 | 1770508 | 2022-07-03 | US | Texas | Lynn | 48305 | 1569 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-04 04:20:54 | Lynn, Texas, US | |
1767855 | 1767855 | 2022-07-03 | US | Arkansas | Montgomery | 5097 | 1569 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-04 04:20:54 | Montgomery, Arkansas, US | |
3368494 | 3368494 | 2022-07-02 | US | Texas | Lynn | 48305 | 1569 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-03 04:20:59 | Lynn, Texas, US | |
3365841 | 3365841 | 2022-07-02 | US | Arkansas | Montgomery | 5097 | 1569 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-03 04:20:59 | Montgomery, Arkansas, US | |
596823 | 596823 | 2022-07-01 | US | Texas | Lynn | 48305 | 1569 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-02 04:21:16 | Lynn, Texas, US | |
232687 | 232687 | 2022-05-31 | US | Washington | Skamania | 53059 | 1569 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-01 04:20:55 | Skamania, Washington, US | |
3189452 | 3189452 | 2022-05-30 | US | Washington | Skamania | 53059 | 1569 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-31 04:20:51 | Skamania, Washington, US | |
3201601 | 3201601 | 2022-05-29 | US | Washington | Skamania | 53059 | 1569 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-30 04:20:50 | Skamania, Washington, US | |
2728479 | 2728479 | 2022-05-28 | US | Washington | Skamania | 53059 | 1569 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-29 04:20:53 | Skamania, Washington, US | |
1317660 | 1317660 | 2022-05-27 | US | Washington | Skamania | 53059 | 1569 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-28 04:21:07 | Skamania, Washington, US | |
3208110 | 3208110 | 2022-04-11 | US | Mississippi | Quitman | 28119 | 1569 | 31 | 0 | 34.25157572 | -90.28908 | 2022-04-12 04:20:49 | Quitman, Mississippi, US | |
1577996 | 1577996 | 2022-04-10 | US | Mississippi | Quitman | 28119 | 1569 | 31 | 0 | 34.25157572 | -90.28908 | 2022-04-11 04:21:02 | Quitman, Mississippi, US | |
1654238 | 1654238 | 2022-04-09 | US | Mississippi | Quitman | 28119 | 1569 | 31 | 0 | 34.25157572 | -90.28908 | 2022-04-10 04:20:52 | Quitman, Mississippi, 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]);