johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
377 rows where confirmed = 1778 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754629 | 2754629 | 2022-12-29 | US | Minnesota | Grant | 27051 | 1778 | 15 | 0 | 45.93424769 | -96.01139609 | 2022-12-30 04:21:04 | Grant, Minnesota, US | |
2951176 | 2951176 | 2022-12-20 | China | Guizhou | 1778 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-21 04:21:03 | Guizhou, China | |||
3173578 | 3173578 | 2022-12-19 | China | Guizhou | 1778 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-20 04:21:04 | Guizhou, China | |||
1152274 | 1152274 | 2022-12-12 | US | Virginia | Covington | 51580 | 1778 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-13 04:21:01 | Covington, Virginia, US | |
872128 | 872128 | 2022-12-11 | US | Virginia | Covington | 51580 | 1778 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-12 04:21:01 | Covington, Virginia, US | |
260658 | 260658 | 2022-12-10 | US | Virginia | Covington | 51580 | 1778 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-11 04:20:50 | Covington, Virginia, US | |
3939372 | 3939372 | 2022-12-09 | US | Virginia | Covington | 51580 | 1778 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-10 04:21:02 | Covington, Virginia, US | |
2557945 | 2557945 | 2022-11-29 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-30 04:21:07 | Stevens, Kansas, US | |
1241019 | 1241019 | 2022-11-28 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-29 04:21:05 | Stevens, Kansas, US | |
3553007 | 3553007 | 2022-11-27 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-28 04:21:02 | Stevens, Kansas, US | |
2101487 | 2101487 | 2022-11-26 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-27 04:21:05 | Stevens, Kansas, US | |
488978 | 488978 | 2022-11-25 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-26 04:21:11 | Stevens, Kansas, US | |
3524807 | 3524807 | 2022-11-24 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-25 04:21:06 | Stevens, Kansas, US | |
3313590 | 3313590 | 2022-11-23 | US | Kansas | Stevens | 20189 | 1778 | 27 | 0 | 37.1923008 | -101.3118967 | 2022-11-24 04:21:09 | Stevens, Kansas, US | |
2757766 | 2757766 | 2022-10-18 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-19 04:22:26 | Marion, Georgia, US | |
2025600 | 2025600 | 2022-10-17 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-18 04:22:42 | Marion, Georgia, US | |
2160378 | 2160378 | 2022-10-16 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-17 04:20:31 | Marion, Georgia, US | |
516575 | 516575 | 2022-10-15 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-16 04:22:39 | Marion, Georgia, US | |
2033632 | 2033632 | 2022-10-14 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-15 04:22:00 | Marion, Georgia, US | |
3754320 | 3754320 | 2022-10-13 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-14 04:22:28 | Marion, Georgia, US | |
3215270 | 3215270 | 2022-10-12 | US | Illinois | Calhoun | 17013 | 1778 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-10-13 04:22:39 | Calhoun, Illinois, US | |
3215145 | 3215145 | 2022-10-12 | US | Georgia | Marion | 13197 | 1778 | 54 | 0 | 32.3483402 | -84.52733571 | 2022-10-13 04:22:39 | Marion, Georgia, US | |
133175 | 133175 | 2022-10-04 | US | North Dakota | Ransom | 38073 | 1778 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-10-05 04:23:06 | Ransom, North Dakota, US | |
2769559 | 2769559 | 2022-09-26 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-27 04:23:01 | Trinity, California, US | |
1977212 | 1977212 | 2022-09-25 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-26 04:20:52 | Trinity, California, US | |
2650379 | 2650379 | 2022-09-24 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-25 04:23:31 | Trinity, California, US | |
384819 | 384819 | 2022-09-23 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-24 04:21:40 | Trinity, California, US | |
1624885 | 1624885 | 2022-09-22 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-23 04:23:13 | Trinity, California, US | |
1371089 | 1371089 | 2022-09-21 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-22 04:22:56 | Trinity, California, US | |
2017615 | 2017615 | 2022-09-20 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-21 04:23:22 | Treutlen, Georgia, US | |
2017319 | 2017319 | 2022-09-20 | US | California | Trinity | 6105 | 1778 | 20 | 0 | 40.6491767 | -123.114713 | 2022-09-21 04:23:22 | Trinity, California, US | |
3571488 | 3571488 | 2022-09-19 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-20 04:22:48 | Treutlen, Georgia, US | |
420227 | 420227 | 2022-09-18 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-19 04:21:49 | Treutlen, Georgia, US | |
3374251 | 3374251 | 2022-09-17 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-18 04:22:50 | Treutlen, Georgia, US | |
2356359 | 2356359 | 2022-09-16 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-17 04:20:19 | Treutlen, Georgia, US | |
3987516 | 3987516 | 2022-09-15 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-16 04:21:19 | Treutlen, Georgia, US | |
1890033 | 1890033 | 2022-09-14 | US | Georgia | Treutlen | 13283 | 1778 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-15 04:21:02 | Treutlen, Georgia, US | |
1250559 | 1250559 | 2022-08-23 | China | Liaoning | 1778 | 2 | 0 | 41.2956 | 122.6085 | 2022-08-24 04:20:46 | Liaoning, China | |||
2406292 | 2406292 | 2022-08-21 | US | Washington | San Juan | 53055 | 1778 | 2 | 0 | 48.60182783 | -122.96745 | 2022-08-22 04:20:38 | San Juan, Washington, US | |
3801370 | 3801370 | 2022-08-20 | US | Washington | San Juan | 53055 | 1778 | 2 | 0 | 48.60182783 | -122.96745 | 2022-08-21 04:20:44 | San Juan, Washington, US | |
2366956 | 2366956 | 2022-08-19 | US | Washington | San Juan | 53055 | 1778 | 2 | 0 | 48.60182783 | -122.96745 | 2022-08-20 04:21:01 | San Juan, Washington, US | |
3650205 | 3650205 | 2022-08-14 | US | Oregon | Harney | 41025 | 1778 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-08-15 04:20:59 | Harney, Oregon, US | |
1971211 | 1971211 | 2022-08-13 | US | Oregon | Harney | 41025 | 1778 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-08-14 04:20:55 | Harney, Oregon, US | |
2891020 | 2891020 | 2022-08-12 | US | Oregon | Harney | 41025 | 1778 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-08-13 04:20:52 | Harney, Oregon, US | |
1100663 | 1100663 | 2022-08-03 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-04 04:20:58 | Coal, Oklahoma, US | |
1407588 | 1407588 | 2022-08-02 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-03 04:20:59 | Coal, Oklahoma, US | |
3619626 | 3619626 | 2022-08-01 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-02 04:20:53 | Coal, Oklahoma, US | |
3874106 | 3874106 | 2022-07-31 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-01 04:21:03 | Coal, Oklahoma, US | |
676860 | 676860 | 2022-07-30 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-07-31 04:21:02 | Coal, Oklahoma, US | |
1786059 | 1786059 | 2022-07-29 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-07-30 04:20:42 | Coal, Oklahoma, US | |
1068422 | 1068422 | 2022-07-28 | US | Oklahoma | Coal | 40029 | 1778 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-07-29 04:20:45 | Coal, Oklahoma, US | |
2148179 | 2148179 | 2022-06-27 | US | Arkansas | Woodruff | 5147 | 1778 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-28 04:20:58 | Woodruff, Arkansas, US | |
475980 | 475980 | 2022-06-26 | US | Arkansas | Woodruff | 5147 | 1778 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-27 04:21:00 | Woodruff, Arkansas, US | |
939355 | 939355 | 2022-06-25 | US | Arkansas | Woodruff | 5147 | 1778 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-26 04:21:02 | Woodruff, Arkansas, US | |
3347175 | 3347175 | 2022-06-24 | US | Arkansas | Woodruff | 5147 | 1778 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-25 04:20:57 | Woodruff, Arkansas, US | |
167655 | 167655 | 2022-06-21 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-22 04:20:54 | Alcona, Michigan, US | |
1764938 | 1764938 | 2022-06-20 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-21 04:20:56 | Alcona, Michigan, US | |
3271124 | 3271124 | 2022-06-19 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-20 04:21:01 | Alcona, Michigan, US | |
3399036 | 3399036 | 2022-06-18 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-19 04:20:51 | Alcona, Michigan, US | |
2312913 | 2312913 | 2022-06-17 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-18 04:21:10 | Alcona, Michigan, US | |
560417 | 560417 | 2022-06-16 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-17 04:20:56 | Alcona, Michigan, US | |
3985229 | 3985229 | 2022-06-15 | US | Oregon | Grant | 41023 | 1778 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-16 04:20:55 | Grant, Oregon, US | |
3984219 | 3984219 | 2022-06-15 | US | Michigan | Alcona | 26001 | 1778 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-16 04:20:55 | Alcona, Michigan, US | |
3888272 | 3888272 | 2022-06-06 | US | Colorado | Rio Blanco | 8103 | 1778 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-07 04:21:08 | Rio Blanco, Colorado, US | |
3888102 | 3888102 | 2022-06-06 | US | Arkansas | Dallas | 5039 | 1778 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-07 04:21:08 | Dallas, Arkansas, US | |
3508041 | 3508041 | 2022-06-05 | US | Colorado | Rio Blanco | 8103 | 1778 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-06 04:20:57 | Rio Blanco, Colorado, US | |
3507871 | 3507871 | 2022-06-05 | US | Arkansas | Dallas | 5039 | 1778 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-06 04:20:57 | Dallas, Arkansas, US | |
3527948 | 3527948 | 2022-06-04 | US | Arkansas | Dallas | 5039 | 1778 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-05 04:20:55 | Dallas, Arkansas, US | |
3134034 | 3134034 | 2022-06-03 | US | Arkansas | Dallas | 5039 | 1778 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-04 04:20:58 | Dallas, Arkansas, US | |
3579109 | 3579109 | 2022-06-02 | US | Arkansas | Dallas | 5039 | 1778 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-03 04:20:58 | Dallas, Arkansas, US | |
3188107 | 3188107 | 2022-05-30 | US | Nebraska | Richardson | 31147 | 1778 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-31 04:20:51 | Richardson, Nebraska, US | |
3200256 | 3200256 | 2022-05-29 | US | Nebraska | Richardson | 31147 | 1778 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-30 04:20:50 | Richardson, Nebraska, US | |
2727134 | 2727134 | 2022-05-28 | US | Nebraska | Richardson | 31147 | 1778 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-05-29 04:20:53 | Richardson, Nebraska, US | |
3445453 | 3445453 | 2022-05-11 | US | Colorado | Conejos | 8021 | 1778 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-12 04:20:54 | Conejos, Colorado, US | |
3536070 | 3536070 | 2022-05-10 | US | Colorado | Conejos | 8021 | 1778 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-11 04:20:48 | Conejos, Colorado, US | |
1160359 | 1160359 | 2022-04-29 | US | Texas | Refugio | 48391 | 1778 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-04-30 04:21:05 | Refugio, Texas, US | |
2254409 | 2254409 | 2022-04-19 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-20 04:20:45 | Pickett, Tennessee, US | |
1848959 | 1848959 | 2022-04-18 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-19 04:21:00 | Pickett, Tennessee, US | |
3419903 | 3419903 | 2022-04-17 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-18 04:21:12 | Pickett, Tennessee, US | |
306852 | 306852 | 2022-04-16 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-17 04:20:59 | Pickett, Tennessee, US | |
2672797 | 2672797 | 2022-04-15 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-16 04:20:48 | Pickett, Tennessee, US | |
1226582 | 1226582 | 2022-04-14 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-15 04:20:57 | Pickett, Tennessee, US | |
2445740 | 2445740 | 2022-04-13 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-13 23:21:06 | Pickett, Tennessee, US | |
1951497 | 1951497 | 2022-04-12 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-13 04:21:03 | Pickett, Tennessee, US | |
3209250 | 3209250 | 2022-04-11 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-12 04:20:49 | Pickett, Tennessee, US | |
1579136 | 1579136 | 2022-04-10 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-11 04:21:02 | Pickett, Tennessee, US | |
1655378 | 1655378 | 2022-04-09 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-10 04:20:52 | Pickett, Tennessee, US | |
2118700 | 2118700 | 2022-04-08 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-09 04:20:42 | Pickett, Tennessee, US | |
3323224 | 3323224 | 2022-04-07 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-08 04:20:48 | Pickett, Tennessee, US | |
2803760 | 2803760 | 2022-04-06 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-07 04:20:53 | Pickett, Tennessee, US | |
3870529 | 3870529 | 2022-04-05 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-06 04:20:49 | Pickett, Tennessee, US | |
2751871 | 2751871 | 2022-04-04 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-05 04:20:48 | Pickett, Tennessee, US | |
3733217 | 3733217 | 2022-04-03 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-04 04:20:51 | Pickett, Tennessee, US | |
502652 | 502652 | 2022-04-02 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-03 04:20:48 | Pickett, Tennessee, US | |
3353637 | 3353637 | 2022-04-01 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-02 04:20:47 | Pickett, Tennessee, US | |
3352781 | 3352781 | 2022-04-01 | US | Nebraska | Thurston | 31173 | 1778 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-02 04:20:47 | Thurston, Nebraska, US | |
1542942 | 1542942 | 2022-03-31 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-01 04:20:28 | Pickett, Tennessee, US | |
2480955 | 2480955 | 2022-03-30 | US | Tennessee | Pickett | 47137 | 1778 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-31 04:20:56 | Pickett, Tennessee, US | |
696517 | 696517 | 2022-03-17 | US | Nebraska | Thurston | 31173 | 1778 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-18 04:20:55 | Thurston, Nebraska, US | |
2321460 | 2321460 | 2022-03-16 | US | Nebraska | Thurston | 31173 | 1778 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-17 04:20:56 | Thurston, Nebraska, 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]);