johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where active = 2834 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2673522 | 2673522 | 2021-07-18 | Belarus | 434362 | 3326 | 428202 | 2834 | 53.7098 | 27.9534 | 2021-07-19 04:21:24 | Belarus | |||
2501811 | 2501811 | 2021-05-07 | Chile | Araucania | 73835 | 920 | 70081 | 2834 | -38.9489 | -72.3311 | 2021-05-08 04:21:04 | Araucania, Chile | ||
1571781 | 1571781 | 2021-04-22 | Malaysia | Kelantan | 10199 | 29 | 7336 | 2834 | 6.1254 | 102.2381 | 2021-04-23 04:20:52 | Kelantan, Malaysia | ||
3003209 | 3003209 | 2021-04-06 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-07 04:20:53 | Gabon | |||
3085204 | 3085204 | 2021-04-05 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-06 04:20:32 | Gabon | |||
388127 | 388127 | 2021-04-04 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-05 04:20:35 | Gabon | |||
3710043 | 3710043 | 2021-04-03 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-04 04:20:49 | Gabon | |||
241159 | 241159 | 2021-04-02 | Gabon | 19863 | 119 | 16910 | 2834 | -0.8037 | 11.6094 | 2021-04-03 04:20:44 | Gabon | |||
1617952 | 1617952 | 2021-03-05 | US | Minnesota | Freeborn | 27047 | 2858 | 24 | 0 | 2834 | 43.67385583 | -93.34884422 | 2021-03-06 04:23:41 | Freeborn, Minnesota, US |
3068468 | 3068468 | 2021-02-27 | US | Ohio | Jackson | 39079 | 2885 | 51 | 0 | 2834 | 39.01914254 | -82.61818559999998 | 2021-02-28 05:22:20 | Jackson, Ohio, US |
2186052 | 2186052 | 2021-02-26 | US | Ohio | Jackson | 39079 | 2885 | 51 | 0 | 2834 | 39.01914254 | -82.61818559999998 | 2021-02-27 05:22:28 | Jackson, Ohio, US |
283179 | 283179 | 2021-02-24 | US | Tennessee | Wayne | 47181 | 2875 | 30 | 0 | 2834 | 35.23868267 | -87.78644456 | 2021-02-25 05:24:57 | Wayne, Tennessee, US |
744149 | 744149 | 2021-02-20 | US | Mississippi | Scott | 28123 | 2900 | 66 | 0 | 2834 | 32.406704100000006 | -89.53789439 | 2021-02-21 05:24:33 | Scott, Mississippi, US |
744089 | 744089 | 2021-02-20 | US | Mississippi | Alcorn | 28003 | 2894 | 60 | 0 | 2834 | 34.88084463 | -88.57996173 | 2021-02-21 05:24:33 | Alcorn, Mississippi, US |
473247 | 473247 | 2021-02-19 | US | Mississippi | Scott | 28123 | 2900 | 66 | 0 | 2834 | 32.406704100000006 | -89.53789439 | 2021-02-20 05:22:51 | Scott, Mississippi, US |
2679764 | 2679764 | 2021-02-13 | US | Missouri | Phelps | 29161 | 2951 | 117 | 0 | 2834 | 37.87736118 | -91.79351727 | 2021-02-14 05:23:43 | Phelps, Missouri, US |
2679736 | 2679736 | 2021-02-13 | US | Missouri | Laclede | 29105 | 2898 | 64 | 0 | 2834 | 37.65896829 | -92.5888493 | 2021-02-14 05:23:43 | Laclede, Missouri, US |
3541369 | 3541369 | 2021-02-12 | US | Missouri | Laclede | 29105 | 2898 | 64 | 0 | 2834 | 37.65896829 | -92.5888493 | 2021-02-13 05:22:12 | Laclede, Missouri, US |
1674973 | 1674973 | 2021-02-07 | US | Ohio | Williams | 39171 | 2906 | 72 | 0 | 2834 | 41.56052014 | -84.58429552 | 2021-02-08 05:22:39 | Williams, Ohio, US |
1673282 | 1673282 | 2021-02-07 | US | Georgia | Liberty | 13179 | 2876 | 42 | 0 | 2834 | 31.82588896 | -81.49251135 | 2021-02-08 05:22:39 | Liberty, Georgia, US |
1590395 | 1590395 | 2021-02-05 | US | New York | Clinton | 36019 | 2856 | 22 | 0 | 2834 | 44.74530905 | -73.67875352 | 2021-02-06 05:23:55 | Clinton, New York, US |
790401 | 790401 | 2021-02-04 | Japan | Kanagawa | 41627 | 527 | 38266 | 2834 | 35.415312 | 139.338983 | 2021-02-05 05:22:38 | Kanagawa, Japan | ||
3157210 | 3157210 | 2021-01-27 | US | Wyoming | Sheridan | 56033 | 2853 | 19 | 0 | 2834 | 44.79048913 | -106.8862389 | 2021-01-28 05:22:24 | Sheridan, Wyoming, US |
910978 | 910978 | 2021-01-19 | US | South Carolina | Chester | 45023 | 2882 | 48 | 0 | 2834 | 34.69249168 | -81.1583216 | 2021-01-20 05:21:54 | Chester, South Carolina, US |
3310574 | 3310574 | 2021-01-13 | US | North Carolina | Yadkin | 37197 | 2862 | 28 | 0 | 2834 | 36.16222629 | -80.66239436 | 2021-01-14 05:22:32 | Yadkin, North Carolina, US |
775402 | 775402 | 2021-01-12 | US | Indiana | Adams | 18001 | 2875 | 41 | 0 | 2834 | 40.7457653 | -84.93671406 | 2021-01-13 05:22:15 | Adams, Indiana, US |
2543854 | 2543854 | 2021-01-07 | US | Ohio | Defiance | 39039 | 2910 | 76 | 0 | 2834 | 41.32398837 | -84.49076944 | 2021-01-08 05:22:42 | Defiance, Ohio, US |
3036150 | 3036150 | 2021-01-05 | US | Mississippi | Warren | 28149 | 2914 | 80 | 0 | 2834 | 32.35810271 | -90.83352619 | 2021-01-06 05:22:16 | Warren, Mississippi, US |
2230456 | 2230456 | 2021-01-02 | US | Tennessee | Hardeman | 47069 | 2875 | 42 | 0 | 2834 | 35.20772017 | -88.99161161 | 2021-01-03 05:22:52 | Hardeman, Tennessee, US |
2230171 | 2230171 | 2021-01-02 | US | Pennsylvania | Columbia | 42037 | 2907 | 73 | 0 | 2834 | 41.04821986 | -76.40565017 | 2021-01-03 05:22:52 | Columbia, Pennsylvania, US |
1010597 | 1010597 | 2020-12-30 | Spain | Ceuta | 3056 | 59 | 163 | 2834 | 35.8894 | -5.3213 | 2020-12-31 05:22:49 | Ceuta, Spain | ||
3779636 | 3779636 | 2020-12-27 | US | Minnesota | Morrison | 27097 | 2874 | 40 | 0 | 2834 | 46.01265363 | -94.27341528 | 2020-12-28 05:22:06 | Morrison, Minnesota, US |
205550 | 205550 | 2020-12-25 | US | Virginia | Bedford | 51019 | 2864 | 30 | 0 | 2834 | 37.3080028 | -79.5281964 | 2020-12-26 05:22:28 | Bedford, Virginia, US |
2408849 | 2408849 | 2020-12-23 | US | Montana | Silver Bow | 30093 | 2868 | 34 | 0 | 2834 | 45.90018933 | -112.6620092 | 2020-12-24 05:23:04 | Silver Bow, Montana, US |
2130243 | 2130243 | 2020-12-17 | US | New York | Rensselaer | 36083 | 2904 | 70 | 0 | 2834 | 42.71348136 | -73.51089874 | 2020-12-18 05:28:18 | Rensselaer, New York, US |
1036103 | 1036103 | 2020-12-15 | US | Minnesota | McLeod | 27085 | 2865 | 31 | 0 | 2834 | 44.82367677 | -94.27287017 | 2020-12-16 05:28:04 | McLeod, Minnesota, US |
2976297 | 2976297 | 2020-12-09 | US | Indiana | Dearborn | 18029 | 2875 | 41 | 0 | 2834 | 39.14647946 | -84.97333539 | 2020-12-10 05:26:19 | Dearborn, Indiana, US |
2539522 | 2539522 | 2020-12-01 | US | Nevada | Elko | 32007 | 2851 | 17 | 0 | 2834 | 41.14531606 | -115.3577619 | 2020-12-02 05:27:41 | Elko, Nevada, US |
2538392 | 2538392 | 2020-12-01 | US | Illinois | Knox | 17095 | 2890 | 56 | 0 | 2834 | 40.93148779 | -90.21330340000002 | 2020-12-02 05:27:41 | Knox, Illinois, US |
3567088 | 3567088 | 2020-11-29 | US | Arkansas | Unassigned | 90005 | 2834 | 0 | 0 | 2834 | 36.38177105 | 0.0 | 2020-11-30 05:26:13 | Unassigned, Arkansas, US |
3839882 | 3839882 | 2020-11-21 | US | Virginia | Spotsylvania | 51177 | 2891 | 57 | 0 | 2834 | 38.18574462 | -77.655399 | 2020-11-22 05:25:45 | Spotsylvania, Virginia, US |
2915173 | 2915173 | 2020-11-14 | Italy | P.A. Trento | 12300 | 516 | 8950 | 2834 | 46.06893511 | 11.12123097 | 2020-11-15 05:26:53 | P.A. Trento, Italy | ||
210436 | 210436 | 2020-10-29 | Russia | Ivanovo Oblast | 11246 | 169 | 8243 | 2834 | 56.9167446 | 41.43521370000001 | 2020-10-30 04:24:49 | Ivanovo Oblast, Russia | ||
1795721 | 1795721 | 2020-10-19 | US | Indiana | Johnson | 18081 | 2972 | 138 | 0 | 2834 | 39.48994426 | -86.10149107 | 2020-10-20 04:24:22 | Johnson, Indiana, US |
763427 | 763427 | 2020-10-18 | US | Indiana | Porter | 18127 | 2889 | 55 | 0 | 2834 | 41.45986947 | -87.06848888 | 2020-10-19 04:24:16 | Porter, Indiana, US |
3787456 | 3787456 | 2020-10-11 | US | Maryland | Charles | 24017 | 2935 | 101 | 0 | 2834 | 38.51092331 | -76.98580666 | 2020-10-12 04:23:45 | Charles, Maryland, US |
3117661 | 3117661 | 2020-10-06 | Qatar | 126943 | 216 | 123893 | 2834 | 25.3548 | 51.1839 | 2020-10-07 04:23:40 | Qatar | |||
2379806 | 2379806 | 2020-10-01 | Qatar | 125959 | 214 | 122911 | 2834 | 25.3548 | 51.1839 | 2020-10-02 04:23:51 | Qatar | |||
1515718 | 1515718 | 2020-09-28 | Syria | 4102 | 194 | 1074 | 2834 | 34.802075 | 38.99681500000001 | 2020-09-29 04:23:42 | Syria | |||
3317686 | 3317686 | 2020-09-22 | US | Louisiana | Acadia | 22001 | 2930 | 96 | 0 | 2834 | 30.2950649 | -92.41419698 | 2020-09-23 04:23:00 | Acadia, Louisiana, US |
3316887 | 3316887 | 2020-09-22 | US | Florida | Charlotte | 12015 | 2965 | 131 | 0 | 2834 | 26.90131002 | -81.92949121 | 2020-09-23 04:23:00 | Charlotte, Florida, US |
3096321 | 3096321 | 2020-09-20 | US | Tennessee | Bradley | 47011 | 2851 | 16 | 0 | 2834 | 35.15739424 | -84.857186 | 2020-09-21 04:23:00 | Bradley, Tennessee, US |
815920 | 815920 | 2020-09-05 | US | North Carolina | Rowan | 37159 | 2911 | 77 | 0 | 2834 | 35.64003916 | -80.52446628 | 2020-09-06 04:28:33 | Rowan, North Carolina, US |
3485069 | 3485069 | 2020-08-20 | US | Georgia | Columbia | 13073 | 2869 | 35 | 0 | 2834 | 33.54534185 | -82.263524 | 2020-08-21 04:27:41 | Columbia, Georgia, US |
838388 | 838388 | 2020-08-17 | US | Georgia | Douglas | 13097 | 2892 | 58 | 0 | 2834 | 33.70291126 | -84.77026156 | 2020-08-18 04:27:56 | Douglas, Georgia, US |
176972 | 176972 | 2020-07-27 | US | South Carolina | York | 45091 | 2858 | 24 | 0 | 2834 | 34.97281497 | -81.18085944 | 2020-07-28 04:58:43 | York, South Carolina, US |
441461 | 441461 | 2020-07-26 | US | Wisconsin | Racine | 55101 | 2906 | 72 | 0 | 2834 | 42.74753117 | -88.05941254 | 2020-07-27 04:35:02 | Racine, Wisconsin, US |
1005335 | 1005335 | 2020-07-09 | Peru | Cajamarca | 3110 | 276 | 0 | 2834 | -6.4302839999999994 | -78.74559599999998 | 2020-07-10 04:34:24 | Cajamarca, Peru | ||
2973360 | 2973360 | 2020-06-30 | US | Texas | Potter | 48375 | 2836 | 39 | 0 | 2834 | 35.40133773 | -101.893964 | 2020-07-01 04:33:52 | Potter, Texas, US |
2306348 | 2306348 | 2020-06-28 | Chile | Coquimbo | 2857 | 23 | 0 | 2834 | -29.959 | -71.3389 | 2020-06-29 04:33:44 | Coquimbo, Chile | ||
3637140 | 3637140 | 2020-05-30 | US | Pennsylvania | Lancaster | 42071 | 3129 | 295 | 0 | 2834 | 40.03904563 | -76.24770128 | 2020-05-31 02:32:45 | Lancaster, Pennsylvania, US |
43122 | 43122 | 2020-04-13 | Australia | New South Wales | 2863 | 25 | 4 | 2834 | -33.8688 | 151.2093 | 2020-04-13 23:15:42 | New South Wales, Australia |
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]);