johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
357 rows where confirmed = 1563 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752690 | 2752690 | 2022-12-29 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-30 04:21:04 | Gansu, China | |||
1073696 | 1073696 | 2022-12-28 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-29 04:21:01 | Gansu, China | |||
327693 | 327693 | 2022-12-27 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-28 04:21:04 | Gansu, China | |||
217766 | 217766 | 2022-12-26 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-27 04:21:07 | Gansu, China | |||
3222223 | 3222223 | 2022-12-25 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-26 04:21:06 | Gansu, China | |||
1018137 | 1018137 | 2022-12-24 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-25 04:21:04 | Gansu, China | |||
690160 | 690160 | 2022-12-23 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-24 04:21:02 | Gansu, China | |||
2179370 | 2179370 | 2022-12-22 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-23 04:21:04 | Gansu, China | |||
451174 | 451174 | 2022-12-21 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-22 04:20:56 | Gansu, China | |||
2954722 | 2954722 | 2022-12-20 | US | Virginia | Emporia | 51595 | 1563 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-12-21 04:21:03 | Emporia, Virginia, US | |
1621618 | 1621618 | 2022-11-22 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-23 04:21:06 | Rooks, Kansas, US | |
3461506 | 3461506 | 2022-11-21 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-22 04:20:47 | Rooks, Kansas, US | |
1641691 | 1641691 | 2022-11-20 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-21 04:21:05 | Rooks, Kansas, US | |
2065248 | 2065248 | 2022-11-19 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-20 04:21:08 | Rooks, Kansas, US | |
1756642 | 1756642 | 2022-11-18 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-19 04:21:14 | Rooks, Kansas, US | |
3027635 | 3027635 | 2022-11-17 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-18 04:21:15 | Rooks, Kansas, US | |
2487346 | 2487346 | 2022-11-16 | US | Kansas | Rooks | 20163 | 1563 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-17 04:21:11 | Rooks, Kansas, US | |
294444 | 294444 | 2022-11-15 | US | North Dakota | Sioux | 38085 | 1563 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-16 04:21:09 | Sioux, North Dakota, US | |
315082 | 315082 | 2022-11-13 | US | Texas | Mills | 48333 | 1563 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-14 04:21:09 | Mills, Texas, US | |
66243 | 66243 | 2022-11-12 | US | Texas | Mills | 48333 | 1563 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-13 04:21:14 | Mills, Texas, US | |
2930405 | 2930405 | 2022-11-11 | US | Texas | Mills | 48333 | 1563 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-12 04:20:41 | Mills, Texas, US | |
2509241 | 2509241 | 2022-11-10 | US | Texas | Mills | 48333 | 1563 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-11 04:21:22 | Mills, Texas, US | |
2434116 | 2434116 | 2022-11-09 | US | Texas | Mills | 48333 | 1563 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-10 04:21:16 | Mills, Texas, US | |
2271720 | 2271720 | 2022-10-20 | China | Hunan | 1563 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-21 04:22:23 | Hunan, China | |||
1625248 | 1625248 | 2022-09-22 | US | Idaho | Power | 16077 | 1563 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-09-23 04:23:13 | Power, Idaho, US | |
1371452 | 1371452 | 2022-09-21 | US | Idaho | Power | 16077 | 1563 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-09-22 04:22:56 | Power, Idaho, US | |
2017682 | 2017682 | 2022-09-20 | US | Idaho | Power | 16077 | 1563 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-09-21 04:23:22 | Power, Idaho, US | |
3571555 | 3571555 | 2022-09-19 | US | Idaho | Power | 16077 | 1563 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-09-20 04:22:48 | Power, Idaho, US | |
2495692 | 2495692 | 2022-08-15 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-16 04:20:58 | Luce, Michigan, US | |
3649242 | 3649242 | 2022-08-14 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-15 04:20:59 | Luce, Michigan, US | |
1970248 | 1970248 | 2022-08-13 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-14 04:20:55 | Luce, Michigan, US | |
2890057 | 2890057 | 2022-08-12 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-13 04:20:52 | Luce, Michigan, US | |
3909662 | 3909662 | 2022-08-11 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-12 04:20:54 | Luce, Michigan, US | |
1347979 | 1347979 | 2022-08-10 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-11 04:20:49 | Luce, Michigan, US | |
1087734 | 1087734 | 2022-08-09 | US | Michigan | Luce | 26095 | 1563 | 16 | 0 | 46.47227431 | -85.54471223 | 2022-08-10 04:20:57 | Luce, Michigan, US | |
1491027 | 1491027 | 2022-07-26 | US | Washington | Ferry | 53019 | 1563 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-07-27 04:21:04 | Ferry, Washington, US | |
2597473 | 2597473 | 2022-07-25 | US | Washington | Ferry | 53019 | 1563 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-07-26 04:20:58 | Ferry, Washington, US | |
1610659 | 1610659 | 2022-07-20 | US | North Dakota | Dickey | 38021 | 1563 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-07-21 04:21:10 | Dickey, North Dakota, US | |
633461 | 633461 | 2022-07-12 | US | Wisconsin | Iron | 55051 | 1563 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-07-13 04:20:58 | Iron, Wisconsin, US | |
1214683 | 1214683 | 2022-07-11 | US | Texas | Jack | 48237 | 1563 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-07-12 04:20:51 | Jack, Texas, US | |
594170 | 594170 | 2022-07-01 | US | Arkansas | Montgomery | 5097 | 1563 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-02 04:21:16 | Montgomery, Arkansas, US | |
3272678 | 3272678 | 2022-06-19 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-20 04:21:01 | Lynn, Texas, US | |
3400590 | 3400590 | 2022-06-18 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-19 04:20:51 | Lynn, Texas, US | |
2314467 | 2314467 | 2022-06-17 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-18 04:21:10 | Lynn, Texas, US | |
561971 | 561971 | 2022-06-16 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-17 04:20:56 | Lynn, Texas, US | |
3985773 | 3985773 | 2022-06-15 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-16 04:20:55 | Lynn, Texas, US | |
950014 | 950014 | 2022-06-14 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-15 04:20:54 | Lynn, Texas, US | |
2982422 | 2982422 | 2022-06-13 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-14 04:20:52 | Lynn, Texas, US | |
2238548 | 2238548 | 2022-06-12 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-13 04:21:14 | Lynn, Texas, US | |
3144746 | 3144746 | 2022-06-11 | US | Texas | Lynn | 48305 | 1563 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-12 04:20:53 | Lynn, Texas, US | |
3161012 | 3161012 | 2022-06-09 | US | Virginia | Mathews | 51115 | 1563 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-06-10 04:20:55 | Mathews, Virginia, US | |
3580377 | 3580377 | 2022-06-02 | US | Minnesota | Norman | 27107 | 1563 | 14 | 0 | 47.32628443 | -96.45620947 | 2022-06-03 04:20:58 | Norman, Minnesota, US | |
971970 | 971970 | 2022-06-01 | US | Illinois | Stark | 17175 | 1563 | 33 | 0 | 41.09309773 | -89.79745866 | 2022-06-02 05:20:39 | Stark, Illinois, US | |
661046 | 661046 | 2022-05-13 | US | Puerto Rico | Ceiba | 72037 | 1563 | 0 | 0 | 18.251818 | -65.666416 | 2022-05-14 04:20:48 | Ceiba, Puerto Rico, US | |
1060470 | 1060470 | 2022-02-23 | US | Oregon | Harney | 41025 | 1563 | 36 | 0 | 43.06422669 | -118.96663059999999 | 2022-02-24 04:21:14 | Harney, Oregon, US | |
3823473 | 3823473 | 2022-02-16 | US | Texas | Brooks | 48047 | 1563 | 50 | 0 | 27.03103197 | -98.21808402 | 2022-02-17 04:20:56 | Brooks, Texas, US | |
3822368 | 3822368 | 2022-02-16 | US | Missouri | Maries | 29125 | 1563 | 31 | 0 | 38.16193985 | -91.92249662 | 2022-02-17 04:20:56 | Maries, Missouri, US | |
3822328 | 3822328 | 2022-02-16 | US | Missouri | Clark | 29045 | 1563 | 28 | 0 | 40.41040752 | -91.73661677 | 2022-02-17 04:20:56 | Clark, Missouri, US | |
2644143 | 2644143 | 2022-02-14 | US | North Dakota | Bottineau | 38009 | 1563 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-15 04:21:09 | Bottineau, North Dakota, US | |
2329261 | 2329261 | 2022-02-04 | US | Missouri | Daviess | 29061 | 1563 | 25 | 0 | 39.96145298 | -93.98519678 | 2022-02-05 04:21:05 | Daviess, Missouri, US | |
2477063 | 2477063 | 2022-02-03 | US | Texas | Hansford | 48195 | 1563 | 27 | 0 | 36.27743284 | -101.3545796 | 2022-02-04 04:21:10 | Hansford, Texas, US | |
2475313 | 2475313 | 2022-02-03 | US | Kansas | Wabaunsee | 20197 | 1563 | 21 | 0 | 38.95471985 | -96.20350509 | 2022-02-04 04:21:10 | Wabaunsee, Kansas, US | |
462488 | 462488 | 2022-02-02 | US | Texas | Hansford | 48195 | 1563 | 27 | 0 | 36.27743284 | -101.3545796 | 2022-02-03 04:21:21 | Hansford, Texas, US | |
460738 | 460738 | 2022-02-02 | US | Kansas | Wabaunsee | 20197 | 1563 | 21 | 0 | 38.95471985 | -96.20350509 | 2022-02-03 04:21:21 | Wabaunsee, Kansas, US | |
3065475 | 3065475 | 2022-01-29 | US | West Virginia | Calhoun | 54013 | 1563 | 10 | 0 | 38.84315422 | -81.11934872 | 2022-01-30 04:21:26 | Calhoun, West Virginia, US | |
1320316 | 1320316 | 2022-01-26 | US | Nebraska | Merrick | 31121 | 1563 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-27 04:21:19 | Merrick, Nebraska, US | |
1143211 | 1143211 | 2022-01-23 | US | North Carolina | Camden | 37029 | 1563 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-01-24 04:21:12 | Camden, North Carolina, US | |
2835129 | 2835129 | 2022-01-22 | US | North Carolina | Camden | 37029 | 1563 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-01-23 04:21:13 | Camden, North Carolina, US | |
2833312 | 2833312 | 2022-01-22 | US | Arkansas | Dallas | 5039 | 1563 | 21 | 0 | 33.97042763 | -92.65167437 | 2022-01-23 04:21:13 | Dallas, Arkansas, US | |
3427247 | 3427247 | 2022-01-21 | US | North Carolina | Camden | 37029 | 1563 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-01-22 04:21:13 | Camden, North Carolina, US | |
1961851 | 1961851 | 2022-01-20 | US | Kansas | Greenwood | 20073 | 1563 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-01-21 04:21:09 | Greenwood, Kansas, US | |
3227848 | 3227848 | 2022-01-19 | US | Kentucky | Elliott | 21063 | 1563 | 14 | 0 | 38.11624059 | -83.09771563 | 2022-01-20 04:21:07 | Elliott, Kentucky, US | |
3227746 | 3227746 | 2022-01-19 | US | Kansas | Greenwood | 20073 | 1563 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-01-20 04:21:07 | Greenwood, Kansas, US | |
1475316 | 1475316 | 2022-01-17 | US | Texas | Rains | 48379 | 1563 | 49 | 0 | 32.87109387 | -95.79232691 | 2022-01-18 04:21:04 | Rains, Texas, US | |
3616435 | 3616435 | 2022-01-12 | US | Virginia | Madison | 51113 | 1563 | 25 | 0 | 38.41531222 | -78.28220331 | 2022-01-13 08:00:09 | Madison, Virginia, US | |
1703327 | 1703327 | 2022-01-03 | US | Tennessee | Moore | 47127 | 1563 | 32 | 0 | 35.27724699 | -86.36230578 | 2022-01-04 04:22:17 | Moore, Tennessee, US | |
1671922 | 1671922 | 2021-12-29 | US | Washington | Unassigned | 90053 | 1563 | 4 | 0 | 48.82227976 | 0.0 | 2021-12-30 04:21:25 | Unassigned, Washington, US | |
733751 | 733751 | 2021-12-27 | US | Texas | Somervell | 48425 | 1563 | 26 | 0 | 32.22236802 | -97.77403489 | 2021-12-28 04:21:47 | Somervell, Texas, US | |
2114923 | 2114923 | 2021-12-26 | US | Texas | Somervell | 48425 | 1563 | 26 | 0 | 32.22236802 | -97.77403489 | 2021-12-27 04:21:58 | Somervell, Texas, US | |
2402050 | 2402050 | 2021-12-17 | US | Texas | Terry | 48445 | 1563 | 70 | 0 | 33.17402785 | -102.3354521 | 2021-12-18 02:22:20 | Terry, Texas, US | |
786005 | 786005 | 2021-12-13 | US | Wyoming | Platte | 56031 | 1563 | 33 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-14 04:22:38 | Platte, Wyoming, US | |
1661860 | 1661860 | 2021-12-12 | US | Kentucky | Livingston | 21139 | 1563 | 47 | 0 | 37.21137452 | -88.34797529 | 2021-12-13 04:22:02 | Livingston, Kentucky, US | |
3655409 | 3655409 | 2021-12-10 | China | Zhejiang | 1563 | 1 | 0 | 29.1832 | 120.0934 | 2021-12-11 04:22:45 | Zhejiang, China | |||
406033 | 406033 | 2021-12-07 | US | Minnesota | Marshall | 27089 | 1563 | 22 | 0 | 48.35825983 | -96.37017407 | 2021-12-08 04:22:46 | Marshall, Minnesota, US | |
1032364 | 1032364 | 2021-12-06 | US | Montana | Carbon | 30009 | 1563 | 22 | 0 | 45.22850116 | -109.0274047 | 2021-12-07 04:22:34 | Carbon, Montana, US | |
1742527 | 1742527 | 2021-12-05 | US | Montana | Carbon | 30009 | 1563 | 22 | 0 | 45.22850116 | -109.0274047 | 2021-12-06 04:22:34 | Carbon, Montana, US | |
139959 | 139959 | 2021-12-04 | US | Montana | Carbon | 30009 | 1563 | 22 | 0 | 45.22850116 | -109.0274047 | 2021-12-05 04:22:25 | Carbon, Montana, US | |
2198802 | 2198802 | 2021-12-03 | US | Texas | Mitchell | 48335 | 1563 | 43 | 0 | 32.30623474 | -100.9212058 | 2021-12-04 04:22:18 | Mitchell, Texas, US | |
2198773 | 2198773 | 2021-12-03 | US | Texas | La Salle | 48283 | 1563 | 40 | 0 | 28.34453111 | -99.09908775 | 2021-12-04 04:22:18 | La Salle, Texas, US | |
2197612 | 2197612 | 2021-12-03 | US | Montana | Carbon | 30009 | 1563 | 22 | 0 | 45.22850116 | -109.0274047 | 2021-12-04 04:22:18 | Carbon, Montana, US | |
3402270 | 3402270 | 2021-11-30 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-12-01 04:22:29 | Johnson, Georgia, US | |
150813 | 150813 | 2021-11-29 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-30 04:22:53 | Johnson, Georgia, US | |
1232459 | 1232459 | 2021-11-28 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-29 04:22:30 | Johnson, Georgia, US | |
1359782 | 1359782 | 2021-11-27 | US | Kentucky | McLean | 21149 | 1563 | 41 | 0 | 37.5301951 | -87.26803443 | 2021-11-28 04:22:43 | McLean, Kentucky, US | |
1359166 | 1359166 | 2021-11-27 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-28 04:22:43 | Johnson, Georgia, US | |
759157 | 759157 | 2021-11-26 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-27 04:22:45 | Johnson, Georgia, US | |
1803574 | 1803574 | 2021-11-25 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-26 04:22:33 | Johnson, Georgia, US | |
905008 | 905008 | 2021-11-24 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-25 04:22:33 | Johnson, Georgia, US | |
3070858 | 3070858 | 2021-11-23 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-24 04:22:14 | Johnson, Georgia, US | |
3749956 | 3749956 | 2021-11-22 | US | Georgia | Johnson | 13167 | 1563 | 63 | 0 | 32.70211082 | -82.66166794 | 2021-11-23 04:22:39 | Johnson, 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]);