johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
355 rows where confirmed = 1773 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954942 | 2954942 | 2022-12-20 | US | Wisconsin | Iron | 55051 | 1773 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-21 04:21:03 | Iron, Wisconsin, US | |
1150793 | 1150793 | 2022-12-12 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-13 04:21:01 | Quitman, Mississippi, US | |
870647 | 870647 | 2022-12-11 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-12 04:21:01 | Quitman, Mississippi, US | |
259177 | 259177 | 2022-12-10 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-11 04:20:50 | Quitman, Mississippi, US | |
3937891 | 3937891 | 2022-12-09 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-10 04:21:02 | Quitman, Mississippi, US | |
3379223 | 3379223 | 2022-12-08 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-09 04:21:05 | Quitman, Mississippi, US | |
1986494 | 1986494 | 2022-12-07 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-08 04:21:07 | Quitman, Mississippi, US | |
3716017 | 3716017 | 2022-12-06 | US | Mississippi | Quitman | 28119 | 1773 | 33 | 0 | 34.25157572 | -90.28908 | 2022-12-07 04:20:58 | Quitman, Mississippi, US | |
721811 | 721811 | 2022-12-04 | US | Virginia | Covington | 51580 | 1773 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-05 04:20:58 | Covington, Virginia, US | |
2820100 | 2820100 | 2022-12-03 | US | Virginia | Covington | 51580 | 1773 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-04 04:20:56 | Covington, Virginia, US | |
836956 | 836956 | 2022-12-02 | US | Virginia | Covington | 51580 | 1773 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-03 04:21:02 | Covington, Virginia, US | |
1621114 | 1621114 | 2022-11-22 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-23 04:21:06 | Lincoln, Georgia, US | |
3461002 | 3461002 | 2022-11-21 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-22 04:20:47 | Lincoln, Georgia, US | |
1641187 | 1641187 | 2022-11-20 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-21 04:21:05 | Lincoln, Georgia, US | |
2064744 | 2064744 | 2022-11-19 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-20 04:21:08 | Lincoln, Georgia, US | |
1756138 | 1756138 | 2022-11-18 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-19 04:21:14 | Lincoln, Georgia, US | |
3027131 | 3027131 | 2022-11-17 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-18 04:21:15 | Lincoln, Georgia, US | |
2486842 | 2486842 | 2022-11-16 | US | Georgia | Lincoln | 13181 | 1773 | 38 | 0 | 33.79201475 | -82.45024131 | 2022-11-17 04:21:11 | Lincoln, Georgia, US | |
131644 | 131644 | 2022-10-04 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-10-05 04:23:06 | Twiggs, Georgia, US | |
131596 | 131596 | 2022-10-04 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-05 04:23:06 | Marion, Georgia, US | |
2686591 | 2686591 | 2022-10-03 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-10-04 04:22:55 | Twiggs, Georgia, US | |
2686543 | 2686543 | 2022-10-03 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-04 04:22:55 | Marion, Georgia, US | |
2260658 | 2260658 | 2022-10-02 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-10-03 04:23:11 | Twiggs, Georgia, US | |
2260610 | 2260610 | 2022-10-02 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-03 04:23:11 | Marion, Georgia, US | |
2996184 | 2996184 | 2022-10-01 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-10-02 04:21:23 | Twiggs, Georgia, US | |
2996136 | 2996136 | 2022-10-01 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-02 04:21:23 | Marion, Georgia, US | |
854510 | 854510 | 2022-09-30 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-10-01 04:23:01 | Twiggs, Georgia, US | |
854462 | 854462 | 2022-09-30 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-01 04:23:01 | Marion, Georgia, US | |
2376436 | 2376436 | 2022-09-29 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-09-30 04:23:09 | Twiggs, Georgia, US | |
2376388 | 2376388 | 2022-09-29 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-09-30 04:23:09 | Marion, Georgia, US | |
1560987 | 1560987 | 2022-09-28 | US | Georgia | Twiggs | 13289 | 1773 | 73 | 0 | 32.67435595 | -83.43078662 | 2022-09-29 04:22:34 | Twiggs, Georgia, US | |
1560939 | 1560939 | 2022-09-28 | US | Georgia | Marion | 13197 | 1773 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-09-29 04:22:34 | Marion, Georgia, US | |
3571192 | 3571192 | 2022-09-19 | US | California | Trinity | 6105 | 1773 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-20 04:22:48 | Trinity, California, US | |
3548138 | 3548138 | 2022-09-01 | US | Colorado | Kit Carson | 8063 | 1773 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-02 04:21:07 | Kit Carson, Colorado, US | |
3952274 | 3952274 | 2022-08-17 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-18 04:21:11 | Wilkin, Minnesota, US | |
992776 | 992776 | 2022-08-16 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-17 04:20:59 | Wilkin, Minnesota, US | |
2495815 | 2495815 | 2022-08-15 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-16 04:20:58 | Wilkin, Minnesota, US | |
3649365 | 3649365 | 2022-08-14 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-15 04:20:59 | Wilkin, Minnesota, US | |
1970371 | 1970371 | 2022-08-13 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-14 04:20:55 | Wilkin, Minnesota, US | |
2890180 | 2890180 | 2022-08-12 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-13 04:20:52 | Wilkin, Minnesota, US | |
3910625 | 3910625 | 2022-08-11 | US | Oregon | Harney | 41025 | 1773 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-08-12 04:20:54 | Harney, Oregon, US | |
3909785 | 3909785 | 2022-08-11 | US | Minnesota | Wilkin | 27167 | 1773 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-12 04:20:54 | Wilkin, Minnesota, US | |
3430854 | 3430854 | 2022-07-14 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-15 04:20:53 | Chariton, Missouri, US | |
3111374 | 3111374 | 2022-07-13 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-14 04:20:57 | Chariton, Missouri, US | |
631797 | 631797 | 2022-07-12 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-13 04:20:58 | Chariton, Missouri, US | |
1213441 | 1213441 | 2022-07-11 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-12 04:20:51 | Chariton, Missouri, US | |
2790923 | 2790923 | 2022-07-10 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-11 04:20:46 | Chariton, Missouri, US | |
2789644 | 2789644 | 2022-07-10 | US | Colorado | Clear Creek | 8019 | 1773 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-07-11 04:20:46 | Clear Creek, Colorado, US | |
143876 | 143876 | 2022-07-09 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-10 04:20:54 | Chariton, Missouri, US | |
142597 | 142597 | 2022-07-09 | US | Colorado | Clear Creek | 8019 | 1773 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-07-10 04:20:54 | Clear Creek, Colorado, US | |
1418976 | 1418976 | 2022-07-08 | US | Missouri | Chariton | 29041 | 1773 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-07-09 04:20:59 | Chariton, Missouri, US | |
2240439 | 2240439 | 2022-06-28 | US | Illinois | Pulaski | 17153 | 1773 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-06-29 04:20:59 | Pulaski, Illinois, US | |
2148681 | 2148681 | 2022-06-27 | US | Illinois | Pulaski | 17153 | 1773 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-06-28 04:20:58 | Pulaski, Illinois, US | |
476482 | 476482 | 2022-06-26 | US | Illinois | Pulaski | 17153 | 1773 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-06-27 04:21:00 | Pulaski, Illinois, US | |
939857 | 939857 | 2022-06-25 | US | Illinois | Pulaski | 17153 | 1773 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-06-26 04:21:02 | Pulaski, Illinois, US | |
3347677 | 3347677 | 2022-06-24 | US | Illinois | Pulaski | 17153 | 1773 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-06-25 04:20:57 | Pulaski, Illinois, US | |
947835 | 947835 | 2022-06-14 | US | Illinois | Edwards | 17047 | 1773 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-15 04:20:54 | Edwards, Illinois, US | |
3200903 | 3200903 | 2022-05-29 | US | Puerto Rico | Maunabo | 72095 | 1773 | 0 | 0 | 18.017889 | -65.922235 | 2022-05-30 04:20:50 | Maunabo, Puerto Rico, US | |
1111690 | 1111690 | 2022-05-21 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-22 04:20:52 | Richardson, Nebraska, US | |
1171314 | 1171314 | 2022-05-20 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-21 04:20:58 | Richardson, Nebraska, US | |
3898077 | 3898077 | 2022-05-19 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-20 04:20:57 | Richardson, Nebraska, US | |
1186861 | 1186861 | 2022-05-18 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-19 04:20:54 | Richardson, Nebraska, US | |
1186479 | 1186479 | 2022-05-18 | US | Minnesota | Lac qui Parle | 27073 | 1773 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-05-19 04:20:54 | Lac qui Parle, Minnesota, US | |
3584758 | 3584758 | 2022-05-17 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-18 04:20:50 | Richardson, Nebraska, US | |
3583429 | 3583429 | 2022-05-17 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-18 04:20:50 | Crawford, Georgia, US | |
1505715 | 1505715 | 2022-05-16 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-17 04:20:59 | Richardson, Nebraska, US | |
1504386 | 1504386 | 2022-05-16 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-17 04:20:59 | Crawford, Georgia, US | |
2086074 | 2086074 | 2022-05-15 | US | Nebraska | Richardson | 31147 | 1773 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-16 04:20:47 | Richardson, Nebraska, US | |
2084745 | 2084745 | 2022-05-15 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-16 04:20:47 | Crawford, Georgia, US | |
3355455 | 3355455 | 2022-05-14 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-15 04:20:53 | Crawford, Georgia, US | |
659100 | 659100 | 2022-05-13 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-14 04:20:48 | Crawford, Georgia, US | |
2534183 | 2534183 | 2022-05-12 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-13 04:20:51 | Crawford, Georgia, US | |
3445629 | 3445629 | 2022-05-11 | US | Georgia | Crawford | 13079 | 1773 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-05-12 04:20:54 | Crawford, Georgia, US | |
1699541 | 1699541 | 2022-04-28 | US | Texas | Refugio | 48391 | 1773 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-04-29 04:20:59 | Refugio, Texas, US | |
3855024 | 3855024 | 2022-04-27 | US | Texas | Refugio | 48391 | 1773 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-04-28 04:20:47 | Refugio, Texas, US | |
3420227 | 3420227 | 2022-04-17 | US | Virginia | Bland | 51021 | 1773 | 22 | 0 | 37.13128068 | -81.13599391 | 2022-04-18 04:21:12 | Bland, Virginia, US | |
307176 | 307176 | 2022-04-16 | US | Virginia | Bland | 51021 | 1773 | 22 | 0 | 37.13128068 | -81.13599391 | 2022-04-17 04:20:59 | Bland, Virginia, US | |
2673121 | 2673121 | 2022-04-15 | US | Virginia | Bland | 51021 | 1773 | 22 | 0 | 37.13128068 | -81.13599391 | 2022-04-16 04:20:48 | Bland, Virginia, US | |
876075 | 876075 | 2022-03-27 | China | Tianjin | 1773 | 3 | 0 | 39.3054 | 117.323 | 2022-03-28 04:20:33 | Tianjin, China | |||
2201768 | 2201768 | 2022-03-06 | US | Nebraska | Thurston | 31173 | 1773 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-07 04:20:47 | Thurston, Nebraska, US | |
2094225 | 2094225 | 2022-03-05 | US | Nebraska | Thurston | 31173 | 1773 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-06 04:20:49 | Thurston, Nebraska, US | |
2667925 | 2667925 | 2022-03-04 | US | Nebraska | Thurston | 31173 | 1773 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-05 04:21:10 | Thurston, Nebraska, US | |
1995643 | 1995643 | 2022-03-01 | US | Tennessee | Pickett | 47137 | 1773 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-02 04:21:07 | Pickett, Tennessee, US | |
1993954 | 1993954 | 2022-03-01 | US | Kansas | Greenwood | 20073 | 1773 | 22 | 0 | 37.8774388 | -96.23250453 | 2022-03-02 04:21:07 | Greenwood, Kansas, US | |
944128 | 944128 | 2022-02-28 | US | Kansas | Greenwood | 20073 | 1773 | 22 | 0 | 37.8774388 | -96.23250453 | 2022-03-01 04:21:09 | Greenwood, Kansas, US | |
3045976 | 3045976 | 2022-02-26 | China | Jiangsu | 1773 | 0 | 0 | 32.9711 | 119.455 | 2022-02-27 04:21:04 | Jiangsu, China | |||
1300373 | 1300373 | 2022-02-17 | US | North Carolina | Gates | 37073 | 1773 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-02-18 04:21:04 | Gates, North Carolina, US | |
2643661 | 2643661 | 2022-02-14 | US | Missouri | Harrison | 29081 | 1773 | 27 | 0 | 40.35570088 | -93.99222144 | 2022-02-15 04:21:09 | Harrison, Missouri, US | |
189296 | 189296 | 2022-02-13 | US | Texas | Stephens | 48429 | 1773 | 39 | 0 | 32.73553157 | -98.83631615 | 2022-02-14 04:20:51 | Stephens, Texas, US | |
3428036 | 3428036 | 2022-01-21 | US | Texas | Floyd | 48153 | 1773 | 42 | 0 | 34.07227468 | -101.3031546 | 2022-01-22 04:21:13 | Floyd, Texas, US | |
1962499 | 1962499 | 2022-01-20 | US | Missouri | Oregon | 29149 | 1773 | 27 | 0 | 36.68710164 | -91.4033755 | 2022-01-21 04:21:09 | Oregon, Missouri, US | |
3228162 | 3228162 | 2022-01-19 | US | Minnesota | Clearwater | 27029 | 1773 | 27 | 0 | 47.57992111 | -95.37790562 | 2022-01-20 04:21:07 | Clearwater, Minnesota, US | |
3615001 | 3615001 | 2022-01-12 | US | Missouri | Monroe | 29137 | 1773 | 37 | 0 | 39.49593978 | -92.00043978 | 2022-01-13 08:00:09 | Monroe, Missouri, US | |
1390175 | 1390175 | 2022-01-07 | US | Arkansas | Perry | 5105 | 1773 | 26 | 0 | 34.945915299999996 | -92.94372564 | 2022-01-08 04:21:53 | Perry, Arkansas, US | |
1282923 | 1282923 | 2022-01-05 | US | Idaho | Clearwater | 16035 | 1773 | 28 | 0 | 46.67459924 | -115.6622393 | 2022-01-06 04:22:09 | Clearwater, Idaho, US | |
1286943 | 1286943 | 2022-01-04 | US | Idaho | Fremont | 16043 | 1773 | 20 | 0 | 44.22800938 | -111.48099429999999 | 2022-01-05 04:21:59 | Fremont, Idaho, US | |
3608282 | 3608282 | 2021-12-25 | US | Texas | Runnels | 48399 | 1773 | 56 | 0 | 31.8314342 | -99.97616148 | 2021-12-26 04:21:50 | Runnels, Texas, US | |
1717717 | 1717717 | 2021-12-16 | US | Kansas | Wilson | 20205 | 1773 | 35 | 0 | 37.55937174 | -95.74323255 | 2021-12-17 04:22:14 | Wilson, Kansas, US | |
3498143 | 3498143 | 2021-12-15 | US | Missouri | Ralls | 29173 | 1773 | 19 | 0 | 39.52817427 | -91.51838643 | 2021-12-16 04:22:11 | Ralls, Missouri, US | |
3497551 | 3497551 | 2021-12-15 | US | Kansas | Wilson | 20205 | 1773 | 35 | 0 | 37.55937174 | -95.74323255 | 2021-12-16 04:22:11 | Wilson, Kansas, 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]);