johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
144 rows where confirmed = 5642 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260069 | 260069 | 2022-12-10 | US | Puerto Rico | Comerio | 72045 | 5642 | 0 | 0 | 18.224687 | -66.221622 | 2022-12-11 04:20:50 | Comerio, Puerto Rico, US | |
2418405 | 2418405 | 2022-12-05 | US | Wisconsin | Adams | 55001 | 5642 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-06 04:21:03 | Adams, Wisconsin, US | |
3460765 | 3460765 | 2022-11-21 | US | Colorado | Alamosa | 8003 | 5642 | 65 | 0 | 37.57250606 | -105.7885451 | 2022-11-22 04:20:47 | Alamosa, Colorado, US | |
292636 | 292636 | 2022-11-15 | US | Colorado | Elbert | 8039 | 5642 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-11-16 04:21:09 | Elbert, Colorado, US | |
2433416 | 2433416 | 2022-11-09 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-10 04:21:16 | Holmes, Ohio, US | |
482072 | 482072 | 2022-11-08 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-09 04:21:22 | Holmes, Ohio, US | |
2441222 | 2441222 | 2022-11-07 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-08 04:21:21 | Holmes, Ohio, US | |
1052320 | 1052320 | 2022-11-06 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-07 04:21:26 | Holmes, Ohio, US | |
620344 | 620344 | 2022-11-05 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-06 04:21:24 | Holmes, Ohio, US | |
1024848 | 1024848 | 2022-11-04 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-05 04:21:52 | Holmes, Ohio, US | |
433839 | 433839 | 2022-11-03 | US | Ohio | Holmes | 39075 | 5642 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-11-04 04:22:11 | Holmes, Ohio, US | |
1373105 | 1373105 | 2022-09-21 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-22 04:22:56 | Woodward, Oklahoma, US | |
2019335 | 2019335 | 2022-09-20 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-21 04:23:22 | Woodward, Oklahoma, US | |
3573208 | 3573208 | 2022-09-19 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-20 04:22:48 | Woodward, Oklahoma, US | |
421947 | 421947 | 2022-09-18 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-19 04:21:49 | Woodward, Oklahoma, US | |
3375971 | 3375971 | 2022-09-17 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-18 04:22:50 | Woodward, Oklahoma, US | |
2358079 | 2358079 | 2022-09-16 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-17 04:20:19 | Woodward, Oklahoma, US | |
3989236 | 3989236 | 2022-09-15 | US | Oklahoma | Woodward | 40153 | 5642 | 79 | 0 | 36.42316318 | -99.26283045 | 2022-09-16 04:21:19 | Woodward, Oklahoma, US | |
3549485 | 3549485 | 2022-09-01 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-02 04:21:07 | Vernon, Missouri, US | |
2345405 | 2345405 | 2022-08-31 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-01 04:21:03 | Vernon, Missouri, US | |
3775885 | 3775885 | 2022-08-30 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-08-31 04:20:57 | Vernon, Missouri, US | |
1682481 | 1682481 | 2022-08-29 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-08-30 04:21:03 | Vernon, Missouri, US | |
1878965 | 1878965 | 2022-08-28 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-08-29 04:21:06 | Vernon, Missouri, US | |
2098092 | 2098092 | 2022-08-27 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-08-28 04:21:02 | Vernon, Missouri, US | |
1533907 | 1533907 | 2022-08-26 | US | Missouri | Vernon | 29217 | 5642 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-08-27 04:20:57 | Vernon, Missouri, US | |
3909593 | 3909593 | 2022-08-11 | US | Maryland | Somerset | 24039 | 5642 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-08-12 04:20:54 | Somerset, Maryland, US | |
673077 | 673077 | 2022-07-21 | US | Puerto Rico | Salinas | 72123 | 5642 | 0 | 0 | 18.010387 | -66.256592 | 2022-07-22 04:21:15 | Salinas, Puerto Rico, US | |
3158591 | 3158591 | 2022-06-09 | US | Idaho | Payette | 16075 | 5642 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-06-10 04:20:55 | Payette, Idaho, US | |
1422058 | 1422058 | 2022-06-08 | US | Idaho | Payette | 16075 | 5642 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-06-09 04:20:54 | Payette, Idaho, US | |
1397891 | 1397891 | 2022-05-06 | Russia | Chukotka Autonomous Okrug | 5642 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-05-07 04:21:09 | Chukotka Autonomous Okrug, Russia | |||
2601545 | 2601545 | 2022-05-05 | US | West Virginia | McDowell | 54047 | 5642 | 75 | 0 | 37.38002939 | -81.65083669 | 2022-05-06 04:21:00 | McDowell, West Virginia, US | |
2598246 | 2598246 | 2022-05-05 | Russia | Chukotka Autonomous Okrug | 5642 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-05-06 04:21:00 | Chukotka Autonomous Okrug, Russia | |||
3439563 | 3439563 | 2022-04-22 | US | Puerto Rico | Cidra | 72041 | 5642 | 0 | 0 | 18.173559 | -66.161179 | 2022-04-23 04:20:50 | Cidra, Puerto Rico, US | |
2895838 | 2895838 | 2022-04-21 | US | Virginia | Waynesboro | 51820 | 5642 | 64 | 0 | 38.06451466 | -78.90293905 | 2022-04-22 04:20:45 | Waynesboro, Virginia, US | |
3323860 | 3323860 | 2022-04-07 | US | Wyoming | Uinta | 56041 | 5642 | 39 | 0 | 41.2878183 | -110.54757820000002 | 2022-04-08 04:20:48 | Uinta, Wyoming, US | |
2804396 | 2804396 | 2022-04-06 | US | Wyoming | Uinta | 56041 | 5642 | 39 | 0 | 41.2878183 | -110.54757820000002 | 2022-04-07 04:20:53 | Uinta, Wyoming, US | |
2804191 | 2804191 | 2022-04-06 | US | Virginia | Staunton | 51790 | 5642 | 110 | 0 | 38.15965544 | -79.05979937 | 2022-04-07 04:20:53 | Staunton, Virginia, US | |
3871165 | 3871165 | 2022-04-05 | US | Wyoming | Uinta | 56041 | 5642 | 39 | 0 | 41.2878183 | -110.54757820000002 | 2022-04-06 04:20:49 | Uinta, Wyoming, US | |
2752295 | 2752295 | 2022-04-04 | US | Virginia | Salem | 51775 | 5642 | 96 | 0 | 37.2836193 | -80.06219455 | 2022-04-05 04:20:48 | Salem, Virginia, US | |
1542194 | 1542194 | 2022-03-31 | US | New York | Essex | 36031 | 5642 | 57 | 0 | 44.11630765 | -73.77297842 | 2022-04-01 04:20:28 | Essex, New York, US | |
26116 | 26116 | 2022-03-20 | US | Minnesota | Dodge | 27039 | 5642 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-03-21 04:20:50 | Dodge, Minnesota, US | |
1658126 | 1658126 | 2022-03-19 | US | Minnesota | Dodge | 27039 | 5642 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-03-20 04:20:45 | Dodge, Minnesota, US | |
337652 | 337652 | 2022-03-18 | US | Minnesota | Dodge | 27039 | 5642 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-03-19 04:20:47 | Dodge, Minnesota, US | |
1513090 | 1513090 | 2022-02-24 | US | Michigan | Out of MI | 80026 | 5642 | 38 | 0 | 47.63197653 | 0.0 | 2022-02-25 04:21:11 | Out of MI, Michigan, US | |
1059531 | 1059531 | 2022-02-23 | US | Michigan | Out of MI | 80026 | 5642 | 38 | 0 | 47.63197653 | 0.0 | 2022-02-24 04:21:14 | Out of MI, Michigan, US | |
1782320 | 1782320 | 2022-01-27 | US | Tennessee | DeKalb | 47041 | 5642 | 91 | 0 | 35.97616272 | -85.83689361 | 2022-01-28 04:21:09 | DeKalb, Tennessee, US | |
2053458 | 2053458 | 2022-01-25 | US | Maryland | Caroline | 24011 | 5642 | 63 | 0 | 38.87172293 | -75.82904158 | 2022-01-26 04:21:07 | Caroline, Maryland, US | |
557895 | 557895 | 2022-01-16 | US | Texas | Hale | 48189 | 5642 | 214 | 0 | 34.07044901 | -101.82681140000001 | 2022-01-17 04:21:08 | Hale, Texas, US | |
1282380 | 1282380 | 2022-01-05 | US | Alabama | Marion | 1093 | 5642 | 132 | 0 | 34.13697363 | -87.88704173 | 2022-01-06 04:22:09 | Marion, Alabama, US | |
1435689 | 1435689 | 2021-12-28 | US | Texas | Hopkins | 48223 | 5642 | 153 | 0 | 33.14875072 | -95.56351139 | 2021-12-29 03:21:43 | Hopkins, Texas, US | |
3497932 | 3497932 | 2021-12-15 | US | Minnesota | Mille Lacs | 27095 | 5642 | 85 | 0 | 45.93705297 | -93.63236823 | 2021-12-16 04:22:11 | Mille Lacs, Minnesota, US | |
1667409 | 1667409 | 2021-12-11 | US | Tennessee | Macon | 47111 | 5642 | 100 | 0 | 36.53157855 | -86.00778595 | 2021-12-12 04:22:12 | Macon, Tennessee, US | |
406224 | 406224 | 2021-12-07 | US | Missouri | Marion | 29127 | 5642 | 100 | 0 | 39.80601912 | -91.62203062 | 2021-12-08 04:22:46 | Marion, Missouri, US | |
1357 | 1357 | 2021-12-02 | US | Illinois | Monroe | 17133 | 5642 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-12-03 04:23:05 | Monroe, Illinois, US | |
1235124 | 1235124 | 2021-11-28 | US | West Virginia | Marshall | 54051 | 5642 | 119 | 0 | 39.86064362 | -80.66591062 | 2021-11-29 04:22:30 | Marshall, West Virginia, US | |
1361831 | 1361831 | 2021-11-27 | US | West Virginia | Marshall | 54051 | 5642 | 119 | 0 | 39.86064362 | -80.66591062 | 2021-11-28 04:22:43 | Marshall, West Virginia, US | |
761822 | 761822 | 2021-11-26 | US | West Virginia | Marshall | 54051 | 5642 | 119 | 0 | 39.86064362 | -80.66591062 | 2021-11-27 04:22:45 | Marshall, West Virginia, US | |
1806239 | 1806239 | 2021-11-25 | US | West Virginia | Marshall | 54051 | 5642 | 119 | 0 | 39.86064362 | -80.66591062 | 2021-11-26 04:22:33 | Marshall, West Virginia, US | |
907673 | 907673 | 2021-11-24 | US | West Virginia | Marshall | 54051 | 5642 | 119 | 0 | 39.86064362 | -80.66591062 | 2021-11-25 04:22:33 | Marshall, West Virginia, US | |
904043 | 904043 | 2021-11-24 | Dominica | 5642 | 35 | 0 | 15.415 | -61.371 | 2021-11-25 04:22:33 | Dominica | ||||
3069893 | 3069893 | 2021-11-23 | Dominica | 5642 | 35 | 0 | 15.415 | -61.371 | 2021-11-24 04:22:14 | Dominica | ||||
3748991 | 3748991 | 2021-11-22 | Dominica | 5642 | 35 | 0 | 15.415 | -61.371 | 2021-11-23 04:22:39 | Dominica | ||||
1014198 | 1014198 | 2021-11-21 | Dominica | 5642 | 35 | 0 | 15.415 | -61.371 | 2021-11-22 04:22:20 | Dominica | ||||
1324908 | 1324908 | 2021-11-14 | US | Pennsylvania | Jefferson | 42065 | 5642 | 131 | 0 | 41.12913106 | -78.9986361 | 2021-11-15 04:21:36 | Jefferson, Pennsylvania, US | |
44983 | 44983 | 2021-11-02 | US | Kansas | Cowley | 20035 | 5642 | 127 | 0 | 37.23781842 | -96.83776647 | 2021-11-03 06:22:09 | Cowley, Kansas, US | |
3512679 | 3512679 | 2021-11-01 | US | Kansas | Cowley | 20035 | 5642 | 127 | 0 | 37.23781842 | -96.83776647 | 2021-11-02 04:22:03 | Cowley, Kansas, US | |
291003 | 291003 | 2021-10-31 | US | Tennessee | White | 47185 | 5642 | 97 | 0 | 35.92929884 | -85.45591799 | 2021-11-01 04:22:01 | White, Tennessee, US | |
3009401 | 3009401 | 2021-10-11 | US | Nebraska | Dodge | 31053 | 5642 | 62 | 0 | 41.58071748 | -96.65598179 | 2021-10-12 04:21:09 | Dodge, Nebraska, US | |
425417 | 425417 | 2021-10-10 | US | Nebraska | Dodge | 31053 | 5642 | 62 | 0 | 41.58071748 | -96.65598179 | 2021-10-11 04:21:31 | Dodge, Nebraska, US | |
2878274 | 2878274 | 2021-10-09 | US | Nebraska | Dodge | 31053 | 5642 | 62 | 0 | 41.58071748 | -96.65598179 | 2021-10-10 04:21:38 | Dodge, Nebraska, US | |
2876239 | 2876239 | 2021-10-09 | Japan | Yamaguchi | 5642 | 90 | 0 | 34.201190000000004 | 131.573293 | 2021-10-10 04:21:38 | Yamaguchi, Japan | |||
2961440 | 2961440 | 2021-10-08 | US | Nebraska | Dodge | 31053 | 5642 | 62 | 0 | 41.58071748 | -96.65598179 | 2021-10-09 04:21:34 | Dodge, Nebraska, US | |
2077895 | 2077895 | 2021-09-26 | US | Missouri | Platte | 29165 | 5642 | 58 | 0 | 39.38154439 | -94.77068479 | 2021-09-27 04:21:16 | Platte, Missouri, US | |
604966 | 604966 | 2021-09-23 | US | Utah | Wasatch | 49051 | 5642 | 27 | 0 | 40.33110236 | -111.1691419 | 2021-09-24 04:21:44 | Wasatch, Utah, US | |
3758691 | 3758691 | 2021-09-21 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-22 04:21:45 | Marshall, Iowa, US | |
812814 | 812814 | 2021-09-20 | US | Texas | Upshur | 48459 | 5642 | 98 | 0 | 32.73706798 | -94.93999853 | 2021-09-21 04:21:26 | Upshur, Texas, US | |
810794 | 810794 | 2021-09-20 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-21 04:21:26 | Marshall, Iowa, US | |
1818013 | 1818013 | 2021-09-19 | US | Texas | Upshur | 48459 | 5642 | 98 | 0 | 32.73706798 | -94.93999853 | 2021-09-20 04:21:22 | Upshur, Texas, US | |
1815993 | 1815993 | 2021-09-19 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-20 04:21:22 | Marshall, Iowa, US | |
19593 | 19593 | 2021-09-18 | US | Texas | Upshur | 48459 | 5642 | 97 | 0 | 32.73706798 | -94.93999853 | 2021-09-19 04:21:34 | Upshur, Texas, US | |
17573 | 17573 | 2021-09-18 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-19 04:21:34 | Marshall, Iowa, US | |
2619258 | 2619258 | 2021-09-17 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-18 04:21:24 | Marshall, Iowa, US | |
2809966 | 2809966 | 2021-09-16 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-17 04:21:46 | Marshall, Iowa, US | |
2808782 | 2808782 | 2021-09-16 | Japan | Saga | 5642 | 29 | 0 | 33.286977 | 130.115738 | 2021-09-17 04:21:46 | Saga, Japan | |||
1375710 | 1375710 | 2021-09-15 | US | Iowa | Marshall | 19127 | 5642 | 80 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-16 04:22:19 | Marshall, Iowa, US | |
2069780 | 2069780 | 2021-08-31 | US | Missouri | Camden | 29029 | 5642 | 114 | 0 | 38.02199522 | -92.76083747 | 2021-09-01 04:21:38 | Camden, Missouri, US | |
332901 | 332901 | 2021-08-04 | US | Illinois | Jackson | 17077 | 5642 | 65 | 0 | 37.78595185 | -89.38232563 | 2021-08-05 04:21:51 | Jackson, Illinois, US | |
1306931 | 1306931 | 2021-07-27 | US | Georgia | Coffee | 13069 | 5642 | 182 | 0 | 31.54892966 | -82.85492059999999 | 2021-07-28 04:21:39 | Coffee, Georgia, US | |
1381507 | 1381507 | 2021-07-25 | US | Tennessee | Warren | 47177 | 5642 | 85 | 0 | 35.6728299 | -85.77969117 | 2021-07-26 04:21:28 | Warren, Tennessee, US | |
2697074 | 2697074 | 2021-07-06 | US | Virginia | Pittsylvania | 51143 | 5642 | 83 | 0 | 36.81980341 | -79.39731264 | 2021-07-07 04:21:20 | Pittsylvania, Virginia, US | |
1894668 | 1894668 | 2021-06-30 | US | Louisiana | St. Charles | 22089 | 5642 | 98 | 0 | 29.90709658 | -90.35555967 | 2021-07-01 04:21:19 | St. Charles, Louisiana, US | |
3128355 | 3128355 | 2021-06-28 | US | South Dakota | Brown | 46013 | 5642 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-06-29 04:21:28 | Brown, South Dakota, US | |
1713154 | 1713154 | 2021-06-25 | US | Georgia | Laurens | 13175 | 5642 | 173 | 0 | 32.46325233 | -82.92221316 | 2021-06-26 04:21:43 | Laurens, Georgia, US | |
2885371 | 2885371 | 2021-06-20 | US | Illinois | Knox | 17095 | 5642 | 153 | 0 | 40.93148779 | -90.21330340000002 | 2021-06-21 04:21:41 | Knox, Illinois, US | |
108454 | 108454 | 2021-06-19 | US | Illinois | Knox | 17095 | 5642 | 153 | 0 | 40.93148779 | -90.21330340000002 | 2021-06-20 04:21:48 | Knox, Illinois, US | |
107147 | 107147 | 2021-06-19 | Australia | New South Wales | 5642 | 54 | 0 | 5588 | -33.8688 | 151.2093 | 2021-06-20 04:21:48 | New South Wales, Australia | ||
1126597 | 1126597 | 2021-06-18 | US | Illinois | Knox | 17095 | 5642 | 153 | 0 | 40.93148779 | -90.21330340000002 | 2021-06-19 04:22:33 | Knox, Illinois, US | |
825726 | 825726 | 2021-06-06 | Pakistan | Gilgit-Baltistan | 5642 | 107 | 5421 | 114 | 35.792146 | 74.982138 | 2021-06-07 04:22:51 | Gilgit-Baltistan, Pakistan | ||
1191218 | 1191218 | 2021-05-31 | US | Ohio | Jefferson | 39081 | 5642 | 161 | 0 | 40.38614126 | -80.76259514 | 2021-06-01 04:23:09 | Jefferson, Ohio, US | |
1190200 | 1190200 | 2021-05-31 | US | Kentucky | Pike | 21195 | 5642 | 103 | 0 | 37.47088263 | -82.39487445 | 2021-06-01 04:23:09 | Pike, Kentucky, 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]);