johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
379 rows where confirmed = 2222 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348837 | 348837 | 2022-12-14 | US | Arkansas | Woodruff | 5147 | 2222 | 33 | 0 | 35.18902527 | -91.2439489 | 2022-12-15 04:20:58 | Woodruff, Arkansas, US | |
2486669 | 2486669 | 2022-11-16 | US | Colorado | Yuma | 8125 | 2222 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-11-17 04:21:11 | Yuma, Colorado, US | |
292680 | 292680 | 2022-11-15 | US | Colorado | Yuma | 8125 | 2222 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-11-16 04:21:09 | Yuma, Colorado, US | |
482682 | 482682 | 2022-11-08 | US | Texas | Floyd | 48153 | 2222 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-11-09 04:21:22 | Floyd, Texas, US | |
2441832 | 2441832 | 2022-11-07 | US | Texas | Floyd | 48153 | 2222 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-11-08 04:21:21 | Floyd, Texas, US | |
1592721 | 1592721 | 2022-10-21 | US | Arkansas | Monroe | 5095 | 2222 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-10-22 04:22:53 | Monroe, Arkansas, US | |
134319 | 134319 | 2022-10-04 | US | Wisconsin | Menominee | 55078 | 2222 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-10-05 04:23:06 | Menominee, Wisconsin, US | |
2687503 | 2687503 | 2022-10-03 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-10-04 04:22:55 | Franklin, Mississippi, US | |
2261570 | 2261570 | 2022-10-02 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-10-03 04:23:11 | Franklin, Mississippi, US | |
2997096 | 2997096 | 2022-10-01 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-10-02 04:21:23 | Franklin, Mississippi, US | |
855422 | 855422 | 2022-09-30 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-10-01 04:23:01 | Franklin, Mississippi, US | |
2377348 | 2377348 | 2022-09-29 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-09-30 04:23:09 | Franklin, Mississippi, US | |
1561899 | 1561899 | 2022-09-28 | US | Mississippi | Franklin | 28037 | 2222 | 39 | 0 | 31.47786634 | -90.89672989 | 2022-09-29 04:22:34 | Franklin, Mississippi, US | |
2017577 | 2017577 | 2022-09-20 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-21 04:23:22 | Montgomery, Georgia, US | |
3571450 | 3571450 | 2022-09-19 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-20 04:22:48 | Montgomery, Georgia, US | |
420189 | 420189 | 2022-09-18 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-19 04:21:49 | Montgomery, Georgia, US | |
3374213 | 3374213 | 2022-09-17 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-18 04:22:50 | Montgomery, Georgia, US | |
2356321 | 2356321 | 2022-09-16 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-17 04:20:19 | Montgomery, Georgia, US | |
3987478 | 3987478 | 2022-09-15 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-16 04:21:19 | Montgomery, Georgia, US | |
1889995 | 1889995 | 2022-09-14 | US | Georgia | Montgomery | 13209 | 2222 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-09-15 04:21:02 | Montgomery, Georgia, US | |
256831 | 256831 | 2022-09-08 | US | West Virginia | Tucker | 54093 | 2222 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-09-09 04:21:11 | Tucker, West Virginia, US | |
3748629 | 3748629 | 2022-09-07 | US | West Virginia | Tucker | 54093 | 2222 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-09-08 04:21:02 | Tucker, West Virginia, US | |
1394199 | 1394199 | 2022-09-02 | US | Arkansas | Prairie | 5117 | 2222 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-09-03 04:21:04 | Prairie, Arkansas, US | |
1940296 | 1940296 | 2022-08-06 | China | Yunnan | 2222 | 2 | 0 | 24.974 | 101.487 | 2022-08-07 04:20:54 | Yunnan, China | |||
880095 | 880095 | 2022-08-05 | China | Yunnan | 2222 | 2 | 0 | 24.974 | 101.487 | 2022-08-06 04:20:56 | Yunnan, China | |||
1405927 | 1405927 | 2022-08-02 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-08-03 04:20:59 | Terrell, Georgia, US | |
3617965 | 3617965 | 2022-08-01 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-08-02 04:20:53 | Terrell, Georgia, US | |
3872445 | 3872445 | 2022-07-31 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-08-01 04:21:03 | Terrell, Georgia, US | |
675199 | 675199 | 2022-07-30 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-31 04:21:02 | Terrell, Georgia, US | |
1784398 | 1784398 | 2022-07-29 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-30 04:20:42 | Terrell, Georgia, US | |
1066761 | 1066761 | 2022-07-28 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-29 04:20:45 | Terrell, Georgia, US | |
2336280 | 2336280 | 2022-07-27 | US | Georgia | Terrell | 13273 | 2222 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-28 04:20:56 | Terrell, Georgia, US | |
1490450 | 1490450 | 2022-07-26 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-27 04:21:04 | Custer, South Dakota, US | |
1488007 | 1488007 | 2022-07-26 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-27 04:21:04 | Chugach, Alaska, US | |
2596896 | 2596896 | 2022-07-25 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-26 04:20:58 | Custer, South Dakota, US | |
2594453 | 2594453 | 2022-07-25 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-26 04:20:58 | Chugach, Alaska, US | |
899011 | 899011 | 2022-07-24 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-25 04:20:51 | Custer, South Dakota, US | |
896568 | 896568 | 2022-07-24 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-25 04:20:51 | Chugach, Alaska, US | |
94005 | 94005 | 2022-07-23 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-24 04:20:47 | Custer, South Dakota, US | |
91562 | 91562 | 2022-07-23 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-24 04:20:47 | Chugach, Alaska, US | |
903231 | 903231 | 2022-07-22 | US | Texas | Dallam | 48111 | 2222 | 41 | 0 | 36.27787176 | -102.6020725 | 2022-07-23 04:20:53 | Dallam, Texas, US | |
903027 | 903027 | 2022-07-22 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-23 04:20:53 | Custer, South Dakota, US | |
900584 | 900584 | 2022-07-22 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-23 04:20:53 | Chugach, Alaska, US | |
673163 | 673163 | 2022-07-21 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-22 04:21:15 | Custer, South Dakota, US | |
670720 | 670720 | 2022-07-21 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-22 04:21:15 | Chugach, Alaska, US | |
1611126 | 1611126 | 2022-07-20 | US | South Dakota | Custer | 46033 | 2222 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-07-21 04:21:10 | Custer, South Dakota, US | |
1608683 | 1608683 | 2022-07-20 | US | Alaska | Chugach | 2063 | 2222 | 11 | 0 | 61.16666 | -149.9 | 2022-07-21 04:21:10 | Chugach, Alaska, US | |
1211951 | 1211951 | 2022-07-11 | US | Alabama | Perry | 1105 | 2222 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-07-12 04:20:51 | Perry, Alabama, US | |
2792370 | 2792370 | 2022-07-10 | US | Virginia | Fairfax City | 51600 | 2222 | 44 | 0 | 38.85157547 | -77.2977964 | 2022-07-11 04:20:46 | Fairfax City, Virginia, US | |
145323 | 145323 | 2022-07-09 | US | Virginia | Fairfax City | 51600 | 2222 | 44 | 0 | 38.85157547 | -77.2977964 | 2022-07-10 04:20:54 | Fairfax City, Virginia, US | |
1420423 | 1420423 | 2022-07-08 | US | Virginia | Fairfax City | 51600 | 2222 | 44 | 0 | 38.85157547 | -77.2977964 | 2022-07-09 04:20:59 | Fairfax City, Virginia, US | |
2493497 | 2493497 | 2022-06-29 | US | West Virginia | Doddridge | 54017 | 2222 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-30 04:21:01 | Doddridge, West Virginia, US | |
2242879 | 2242879 | 2022-06-28 | US | West Virginia | Doddridge | 54017 | 2222 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-29 04:20:59 | Doddridge, West Virginia, US | |
2240168 | 2240168 | 2022-06-28 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-29 04:20:59 | Candler, Georgia, US | |
2148410 | 2148410 | 2022-06-27 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-28 04:20:58 | Candler, Georgia, US | |
476211 | 476211 | 2022-06-26 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-27 04:21:00 | Candler, Georgia, US | |
939586 | 939586 | 2022-06-25 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-26 04:21:02 | Candler, Georgia, US | |
3347406 | 3347406 | 2022-06-24 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-25 04:20:57 | Candler, Georgia, US | |
1649147 | 1649147 | 2022-06-23 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-24 04:20:58 | Candler, Georgia, US | |
2188382 | 2188382 | 2022-06-22 | US | Georgia | Candler | 13043 | 2222 | 98 | 0 | 32.40209349 | -82.07702563 | 2022-06-23 04:20:55 | Candler, Georgia, US | |
2188126 | 2188126 | 2022-06-22 | US | Arkansas | Nevada | 5099 | 2222 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-06-23 04:20:55 | Nevada, Arkansas, US | |
169139 | 169139 | 2022-06-21 | US | Texas | Gaines | 48165 | 2222 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-06-22 04:20:54 | Gaines, Texas, US | |
166557 | 166557 | 2022-06-21 | US | Arkansas | Nevada | 5099 | 2222 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-06-22 04:20:54 | Nevada, Arkansas, US | |
1766422 | 1766422 | 2022-06-20 | US | Texas | Gaines | 48165 | 2222 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-06-21 04:20:56 | Gaines, Texas, US | |
1765762 | 1765762 | 2022-06-20 | US | North Dakota | Traill | 38097 | 2222 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-06-21 04:20:56 | Traill, North Dakota, US | |
3272608 | 3272608 | 2022-06-19 | US | Texas | Gaines | 48165 | 2222 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-06-20 04:21:01 | Gaines, Texas, US | |
3400520 | 3400520 | 2022-06-18 | US | Texas | Gaines | 48165 | 2222 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-06-19 04:20:51 | Gaines, Texas, US | |
560721 | 560721 | 2022-06-16 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-17 04:20:56 | Iron, Missouri, US | |
3984523 | 3984523 | 2022-06-15 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-16 04:20:55 | Iron, Missouri, US | |
948764 | 948764 | 2022-06-14 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-15 04:20:54 | Iron, Missouri, US | |
2981172 | 2981172 | 2022-06-13 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-14 04:20:52 | Iron, Missouri, US | |
2237298 | 2237298 | 2022-06-12 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-13 04:21:14 | Iron, Missouri, US | |
3143496 | 3143496 | 2022-06-11 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-12 04:20:53 | Iron, Missouri, US | |
1946412 | 1946412 | 2022-06-10 | US | Missouri | Iron | 29093 | 2222 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-06-11 04:21:01 | Iron, Missouri, US | |
3727952 | 3727952 | 2022-06-07 | US | Minnesota | Lake | 27075 | 2222 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-08 04:20:55 | Lake, Minnesota, US | |
3726967 | 3726967 | 2022-06-07 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-08 04:20:55 | Atkinson, Georgia, US | |
3888369 | 3888369 | 2022-06-06 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-07 04:21:08 | Atkinson, Georgia, US | |
3508138 | 3508138 | 2022-06-05 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-06 04:20:57 | Atkinson, Georgia, US | |
3528215 | 3528215 | 2022-06-04 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-05 04:20:55 | Atkinson, Georgia, US | |
3134301 | 3134301 | 2022-06-03 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-04 04:20:58 | Atkinson, Georgia, US | |
3579376 | 3579376 | 2022-06-02 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-03 04:20:58 | Atkinson, Georgia, US | |
971669 | 971669 | 2022-06-01 | US | Georgia | Atkinson | 13003 | 2222 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-06-02 05:20:39 | Atkinson, Georgia, US | |
230500 | 230500 | 2022-05-31 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-06-01 04:20:55 | Cloud, Kansas, US | |
230454 | 230454 | 2022-05-31 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-01 04:20:55 | Montgomery, Iowa, US | |
3187265 | 3187265 | 2022-05-30 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-31 04:20:51 | Cloud, Kansas, US | |
3187219 | 3187219 | 2022-05-30 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-31 04:20:51 | Montgomery, Iowa, US | |
3199414 | 3199414 | 2022-05-29 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-30 04:20:50 | Cloud, Kansas, US | |
3199368 | 3199368 | 2022-05-29 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-30 04:20:50 | Montgomery, Iowa, US | |
2726292 | 2726292 | 2022-05-28 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-29 04:20:53 | Cloud, Kansas, US | |
2726246 | 2726246 | 2022-05-28 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-29 04:20:53 | Montgomery, Iowa, US | |
1315473 | 1315473 | 2022-05-27 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-28 04:21:07 | Cloud, Kansas, US | |
1315427 | 1315427 | 2022-05-27 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-28 04:21:07 | Montgomery, Iowa, US | |
1851265 | 1851265 | 2022-05-26 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-27 04:20:56 | Cloud, Kansas, US | |
1851219 | 1851219 | 2022-05-26 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-27 04:20:56 | Montgomery, Iowa, US | |
2051251 | 2051251 | 2022-05-25 | US | Virginia | Northampton | 51131 | 2222 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-05-26 04:20:50 | Northampton, Virginia, US | |
2049141 | 2049141 | 2022-05-25 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-26 04:20:50 | Cloud, Kansas, US | |
2049095 | 2049095 | 2022-05-25 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-26 04:20:50 | Montgomery, Iowa, US | |
625262 | 625262 | 2022-05-22 | US | Virginia | Northampton | 51131 | 2222 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-05-26 04:20:50 | Northampton, Virginia, US | |
623152 | 623152 | 2022-05-22 | US | Kansas | Cloud | 20029 | 2222 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-05-26 04:20:50 | Cloud, Kansas, US | |
623106 | 623106 | 2022-05-22 | US | Iowa | Montgomery | 19137 | 2222 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-05-26 04:20:50 | Montgomery, Iowa, 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]);