johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
249 rows where confirmed = 2916 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753864 | 2753864 | 2022-12-29 | US | Idaho | Teton | 16081 | 2916 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-12-30 04:21:04 | Teton, Idaho, US | |
1074870 | 1074870 | 2022-12-28 | US | Idaho | Teton | 16081 | 2916 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-12-29 04:21:01 | Teton, Idaho, US | |
3715245 | 3715245 | 2022-12-06 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-07 04:20:58 | Brown, Indiana, US | |
3714688 | 3714688 | 2022-12-06 | US | Arkansas | Perry | 5105 | 2916 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-07 04:20:58 | Perry, Arkansas, US | |
2415950 | 2415950 | 2022-12-05 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-06 04:21:03 | Brown, Indiana, US | |
719558 | 719558 | 2022-12-04 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-05 04:20:58 | Brown, Indiana, US | |
2817847 | 2817847 | 2022-12-03 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-04 04:20:56 | Brown, Indiana, US | |
834703 | 834703 | 2022-12-02 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-03 04:21:02 | Brown, Indiana, US | |
2137233 | 2137233 | 2022-12-01 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-02 04:21:07 | Brown, Indiana, US | |
1965649 | 1965649 | 2022-11-30 | US | Indiana | Brown | 18013 | 2916 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-12-01 04:21:03 | Brown, Indiana, US | |
2017848 | 2017848 | 2022-09-20 | US | Indiana | Newton | 18111 | 2916 | 71 | 0 | 40.95610449 | -87.39635768 | 2022-09-21 04:23:22 | Newton, Indiana, US | |
3571721 | 3571721 | 2022-09-19 | US | Indiana | Newton | 18111 | 2916 | 71 | 0 | 40.95610449 | -87.39635768 | 2022-09-20 04:22:48 | Newton, Indiana, US | |
420460 | 420460 | 2022-09-18 | US | Indiana | Newton | 18111 | 2916 | 71 | 0 | 40.95610449 | -87.39635768 | 2022-09-19 04:21:49 | Newton, Indiana, US | |
3374484 | 3374484 | 2022-09-17 | US | Indiana | Newton | 18111 | 2916 | 71 | 0 | 40.95610449 | -87.39635768 | 2022-09-18 04:22:50 | Newton, Indiana, US | |
2356592 | 2356592 | 2022-09-16 | US | Indiana | Newton | 18111 | 2916 | 71 | 0 | 40.95610449 | -87.39635768 | 2022-09-17 04:20:19 | Newton, Indiana, US | |
3987749 | 3987749 | 2022-09-15 | US | Indiana | Newton | 18111 | 2916 | 70 | 0 | 40.95610449 | -87.39635768 | 2022-09-16 04:21:19 | Newton, Indiana, US | |
1890266 | 1890266 | 2022-09-14 | US | Indiana | Newton | 18111 | 2916 | 70 | 0 | 40.95610449 | -87.39635768 | 2022-09-15 04:21:02 | Newton, Indiana, US | |
1877947 | 1877947 | 2022-08-28 | US | Idaho | Valley | 16085 | 2916 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-08-29 04:21:06 | Valley, Idaho, US | |
2097074 | 2097074 | 2022-08-27 | US | Idaho | Valley | 16085 | 2916 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-08-28 04:21:02 | Valley, Idaho, US | |
1532889 | 1532889 | 2022-08-26 | US | Idaho | Valley | 16085 | 2916 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-08-27 04:20:57 | Valley, Idaho, US | |
2402640 | 2402640 | 2022-08-21 | China | Shandong | 2916 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-22 04:20:38 | Shandong, China | |||
3797718 | 3797718 | 2022-08-20 | China | Shandong | 2916 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-21 04:20:44 | Shandong, China | |||
2890812 | 2890812 | 2022-08-12 | US | North Dakota | McLean | 38055 | 2916 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-08-13 04:20:52 | McLean, North Dakota, US | |
1408388 | 1408388 | 2022-08-02 | US | Virginia | Galax | 51640 | 2916 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-08-03 04:20:59 | Galax, Virginia, US | |
1611564 | 1611564 | 2022-07-20 | US | Virginia | Amelia | 51007 | 2916 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-07-21 04:21:10 | Amelia, Virginia, US | |
3081385 | 3081385 | 2022-07-04 | US | Virginia | Clarke | 51043 | 2916 | 46 | 0 | 39.11271747 | -77.99199425 | 2022-07-05 04:20:45 | Clarke, Virginia, US | |
2979670 | 2979670 | 2022-06-13 | US | Alabama | Wilcox | 1131 | 2916 | 46 | 0 | 31.98773215 | -87.30891118 | 2022-06-14 04:20:52 | Wilcox, Alabama, US | |
2999807 | 2999807 | 2022-05-24 | US | Arkansas | Lee | 5077 | 2916 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-25 04:20:56 | Lee, Arkansas, US | |
3583296 | 3583296 | 2022-05-17 | US | Colorado | Rio Grande | 8105 | 2916 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-05-18 04:20:50 | Rio Grande, Colorado, US | |
3445374 | 3445374 | 2022-05-11 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-12 04:20:54 | Stone, Arkansas, US | |
3535991 | 3535991 | 2022-05-10 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-11 04:20:48 | Stone, Arkansas, US | |
222526 | 222526 | 2022-05-09 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-10 04:20:50 | Stone, Arkansas, US | |
2331911 | 2331911 | 2022-05-08 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-09 04:20:54 | Stone, Arkansas, US | |
360873 | 360873 | 2022-05-07 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-08 04:20:49 | Stone, Arkansas, US | |
1398224 | 1398224 | 2022-05-06 | US | Arkansas | Stone | 5137 | 2916 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-07 04:21:09 | Stone, Arkansas, US | |
2310355 | 2310355 | 2022-04-20 | US | Texas | Dawson | 48115 | 2916 | 94 | 0 | 32.74255572 | -101.94772420000001 | 2022-04-21 04:20:46 | Dawson, Texas, US | |
1438470 | 1438470 | 2022-03-28 | US | Missouri | Cedar | 29039 | 2916 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-03-29 04:20:46 | Cedar, Missouri, US | |
878151 | 878151 | 2022-03-27 | US | Missouri | Cedar | 29039 | 2916 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-03-28 04:20:33 | Cedar, Missouri, US | |
2165434 | 2165434 | 2022-03-26 | US | Missouri | Cedar | 29039 | 2916 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-03-27 04:20:47 | Cedar, Missouri, US | |
1722370 | 1722370 | 2022-03-25 | US | Missouri | Cedar | 29039 | 2916 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-03-26 04:20:23 | Cedar, Missouri, US | |
25875 | 25875 | 2022-03-20 | US | Kentucky | Todd | 21219 | 2916 | 42 | 0 | 36.8381152 | -87.17878374 | 2022-03-21 04:20:50 | Todd, Kentucky, US | |
1657885 | 1657885 | 2022-03-19 | US | Kentucky | Todd | 21219 | 2916 | 42 | 0 | 36.8381152 | -87.17878374 | 2022-03-20 04:20:45 | Todd, Kentucky, US | |
337411 | 337411 | 2022-03-18 | US | Kentucky | Todd | 21219 | 2916 | 42 | 0 | 36.8381152 | -87.17878374 | 2022-03-19 04:20:47 | Todd, Kentucky, US | |
695864 | 695864 | 2022-03-17 | US | Kentucky | Todd | 21219 | 2916 | 42 | 0 | 36.8381152 | -87.17878374 | 2022-03-18 04:20:55 | Todd, Kentucky, US | |
2264493 | 2264493 | 2022-03-14 | US | Colorado | Archuleta | 8007 | 2916 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-03-15 04:20:47 | Archuleta, Colorado, US | |
3628559 | 3628559 | 2022-03-13 | US | Colorado | Archuleta | 8007 | 2916 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-03-14 04:20:46 | Archuleta, Colorado, US | |
2141544 | 2141544 | 2022-03-09 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-10 04:20:48 | Bath, Kentucky, US | |
921055 | 921055 | 2022-03-08 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-09 04:20:59 | Bath, Kentucky, US | |
1549342 | 1549342 | 2022-03-07 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-08 04:20:54 | Bath, Kentucky, US | |
2201011 | 2201011 | 2022-03-06 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-07 04:20:47 | Bath, Kentucky, US | |
2093468 | 2093468 | 2022-03-05 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-06 04:20:49 | Bath, Kentucky, US | |
2667168 | 2667168 | 2022-03-04 | US | Kentucky | Bath | 21011 | 2916 | 38 | 0 | 38.14735938 | -83.74588932 | 2022-03-05 04:21:10 | Bath, Kentucky, US | |
2528223 | 2528223 | 2022-03-02 | US | South Dakota | Charles Mix | 46023 | 2916 | 33 | 0 | 43.20660134 | -98.58856175 | 2022-03-03 04:21:01 | Charles Mix, South Dakota, US | |
1993022 | 1993022 | 2022-03-01 | US | Alabama | Coosa | 1037 | 2916 | 54 | 0 | 32.93690146 | -86.24847739 | 2022-03-02 04:21:07 | Coosa, Alabama, US | |
3858555 | 3858555 | 2022-02-18 | US | Puerto Rico | Barceloneta | 72017 | 2916 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-02-19 04:21:11 | Barceloneta, Puerto Rico, US | |
1300774 | 1300774 | 2022-02-17 | US | Puerto Rico | Barceloneta | 72017 | 2916 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-02-18 04:21:04 | Barceloneta, Puerto Rico, US | |
1299885 | 1299885 | 2022-02-17 | US | Mississippi | Montgomery | 28097 | 2916 | 70 | 0 | 33.49419589 | -89.61729103 | 2022-02-18 04:21:04 | Montgomery, Mississippi, US | |
3822271 | 3822271 | 2022-02-16 | US | Mississippi | Montgomery | 28097 | 2916 | 70 | 0 | 33.49419589 | -89.61729103 | 2022-02-17 04:20:56 | Montgomery, Mississippi, US | |
188457 | 188457 | 2022-02-13 | US | North Dakota | Barnes | 38003 | 2916 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-14 04:20:51 | Barnes, North Dakota, US | |
1365110 | 1365110 | 2022-02-08 | US | Puerto Rico | Loiza | 72087 | 2916 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-09 04:21:04 | Loiza, Puerto Rico, US | |
73848 | 73848 | 2022-02-07 | US | Puerto Rico | Loiza | 72087 | 2916 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-08 04:21:15 | Loiza, Puerto Rico, US | |
2015464 | 2015464 | 2022-02-06 | US | Puerto Rico | Loiza | 72087 | 2916 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-07 04:21:05 | Loiza, Puerto Rico, US | |
2658578 | 2658578 | 2022-01-31 | US | Georgia | Dade | 13083 | 2916 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-01 04:21:11 | Dade, Georgia, US | |
2053091 | 2053091 | 2022-01-25 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-26 04:21:07 | Jefferson, Iowa, US | |
1228822 | 1228822 | 2022-01-24 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-25 04:21:05 | Jefferson, Iowa, US | |
1228439 | 1228439 | 2022-01-24 | US | Georgia | Jasper | 13159 | 2916 | 65 | 0 | 33.31535543 | -83.68844964 | 2022-01-25 04:21:05 | Jasper, Georgia, US | |
1142121 | 1142121 | 2022-01-23 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-24 04:21:12 | Jefferson, Iowa, US | |
2834039 | 2834039 | 2022-01-22 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-23 04:21:13 | Jefferson, Iowa, US | |
3426157 | 3426157 | 2022-01-21 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-22 04:21:13 | Jefferson, Iowa, US | |
1961765 | 1961765 | 2022-01-20 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-21 04:21:09 | Jefferson, Iowa, US | |
3227660 | 3227660 | 2022-01-19 | US | Iowa | Jefferson | 19101 | 2916 | 47 | 0 | 41.03192394 | -91.94849466 | 2022-01-20 04:21:07 | Jefferson, Iowa, US | |
1114717 | 1114717 | 2022-01-11 | US | Indiana | Pike | 18125 | 2916 | 45 | 0 | 38.40112197 | -87.23574907 | 2022-01-12 04:21:44 | Pike, Indiana, US | |
1694183 | 1694183 | 2022-01-10 | US | Mississippi | Yalobusha | 28161 | 2916 | 48 | 0 | 34.02824175 | -89.70762049999998 | 2022-01-11 04:22:01 | Yalobusha, Mississippi, US | |
129462 | 129462 | 2022-01-09 | US | Puerto Rico | Catano | 72033 | 2916 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-01-10 04:22:07 | Catano, Puerto Rico, US | |
128598 | 128598 | 2022-01-09 | US | Mississippi | Yalobusha | 28161 | 2916 | 48 | 0 | 34.02824175 | -89.70762049999998 | 2022-01-10 04:22:07 | Yalobusha, Mississippi, US | |
1217433 | 1217433 | 2022-01-08 | US | Mississippi | Yalobusha | 28161 | 2916 | 48 | 0 | 34.02824175 | -89.70762049999998 | 2022-01-09 04:21:46 | Yalobusha, Mississippi, US | |
1391526 | 1391526 | 2022-01-07 | US | Mississippi | Yalobusha | 28161 | 2916 | 48 | 0 | 34.02824175 | -89.70762049999998 | 2022-01-08 04:21:53 | Yalobusha, Mississippi, US | |
3828902 | 3828902 | 2021-12-21 | US | Alaska | North Slope | 2185 | 2916 | 9 | 0 | 69.31479216 | -153.4836093 | 2021-12-22 04:21:54 | North Slope, Alaska, US | |
1255205 | 1255205 | 2021-12-20 | US | Alaska | North Slope | 2185 | 2916 | 9 | 0 | 69.31479216 | -153.4836093 | 2021-12-21 03:21:27 | North Slope, Alaska, US | |
2088171 | 2088171 | 2021-12-14 | Russia | Chukotka Autonomous Okrug | 2916 | 30 | 0 | 66.0006475 | 169.4900869 | 2021-12-15 03:22:16 | Chukotka Autonomous Okrug, Russia | |||
784150 | 784150 | 2021-12-13 | US | Minnesota | Redwood | 27127 | 2916 | 46 | 0 | 44.40555844 | -95.25207021 | 2021-12-14 04:22:38 | Redwood, Minnesota, US | |
552193 | 552193 | 2021-12-08 | US | Kentucky | Jackson | 21109 | 2916 | 54 | 0 | 37.41866422 | -83.99825483 | 2021-12-09 04:22:49 | Jackson, Kentucky, US | |
406623 | 406623 | 2021-12-07 | US | North Carolina | Hertford | 37091 | 2916 | 72 | 0 | 36.3607755 | -76.98104134 | 2021-12-08 04:22:46 | Hertford, North Carolina, US | |
1033499 | 1033499 | 2021-12-06 | US | Texas | Houston | 48225 | 2916 | 87 | 0 | 31.31925973 | -95.42226208 | 2021-12-07 04:22:34 | Houston, Texas, US | |
1032705 | 1032705 | 2021-12-06 | US | North Carolina | Hertford | 37091 | 2916 | 72 | 0 | 36.3607755 | -76.98104134 | 2021-12-07 04:22:34 | Hertford, North Carolina, US | |
1303 | 1303 | 2021-12-02 | US | Illinois | Clay | 17025 | 2916 | 54 | 0 | 38.75388572 | -88.48914513 | 2021-12-03 04:23:05 | Clay, Illinois, US | |
725968 | 725968 | 2021-11-20 | US | West Virginia | Barbour | 54001 | 2916 | 51 | 0 | 39.1307219 | -80.00350858 | 2021-11-21 04:22:13 | Barbour, West Virginia, US | |
3291299 | 3291299 | 2021-11-18 | US | North Carolina | Yancey | 37199 | 2916 | 34 | 0 | 35.90079156 | -82.31237181 | 2021-11-19 04:21:40 | Yancey, North Carolina, US | |
29457 | 29457 | 2021-11-11 | US | Illinois | Richland | 17159 | 2916 | 58 | 0 | 38.71240969 | -88.08475366 | 2021-11-12 04:22:01 | Richland, Illinois, US | |
2845896 | 2845896 | 2021-11-10 | US | Illinois | Richland | 17159 | 2916 | 58 | 0 | 38.71240969 | -88.08475366 | 2021-11-11 04:21:45 | Richland, Illinois, US | |
3641005 | 3641005 | 2021-11-08 | US | Kentucky | Morgan | 21175 | 2916 | 10 | 0 | 37.92465657 | -83.25558245 | 2021-11-09 04:21:36 | Morgan, Kentucky, US | |
2002113 | 2002113 | 2021-11-07 | US | Kentucky | Morgan | 21175 | 2916 | 10 | 0 | 37.92465657 | -83.25558245 | 2021-11-08 04:21:43 | Morgan, Kentucky, US | |
2946636 | 2946636 | 2021-10-15 | US | Vermont | Bennington | 50003 | 2916 | 26 | 0 | 43.03519828 | -73.09048868 | 2021-10-16 04:21:15 | Bennington, Vermont, US | |
494920 | 494920 | 2021-10-14 | US | Vermont | Franklin | 50011 | 2916 | 46 | 0 | 44.85627605 | -72.91249563 | 2021-10-15 04:21:26 | Franklin, Vermont, US | |
635504 | 635504 | 2021-10-13 | US | Maryland | Garrett | 24023 | 2916 | 77 | 0 | 39.52786077 | -79.27355126 | 2021-10-14 04:21:29 | Garrett, Maryland, US | |
1494147 | 1494147 | 2021-10-12 | US | Oklahoma | Craig | 40035 | 2916 | 29 | 0 | 36.76268118 | -95.20916602 | 2021-10-13 04:20:51 | Craig, Oklahoma, US | |
3009880 | 3009880 | 2021-10-11 | US | Oklahoma | Craig | 40035 | 2916 | 29 | 0 | 36.76268118 | -95.20916602 | 2021-10-12 04:21:09 | Craig, Oklahoma, US | |
425896 | 425896 | 2021-10-10 | US | Oklahoma | Craig | 40035 | 2916 | 29 | 0 | 36.76268118 | -95.20916602 | 2021-10-11 04:21:31 | Craig, Oklahoma, US | |
2878753 | 2878753 | 2021-10-09 | US | Oklahoma | Craig | 40035 | 2916 | 29 | 0 | 36.76268118 | -95.20916602 | 2021-10-10 04:21:38 | Craig, Oklahoma, US | |
2961919 | 2961919 | 2021-10-08 | US | Oklahoma | Craig | 40035 | 2916 | 29 | 0 | 36.76268118 | -95.20916602 | 2021-10-09 04:21:34 | Craig, Oklahoma, 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]);