johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
82 rows where active = 2350 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3030504 | 3030504 | 2021-06-16 | Russia | Kostroma Oblast | 22110 | 498 | 19262 | 2350 | 58.424756 | 44.2533273 | 2021-06-17 04:22:36 | Kostroma Oblast, Russia | ||
3030139 | 3030139 | 2021-06-16 | Colombia | Huila | 64650 | 2189 | 60111 | 2350 | 2.5359 | -75.5277 | 2021-06-17 04:22:36 | Huila, Colombia | ||
2716889 | 2716889 | 2021-06-10 | Germany | Rheinland-Pfalz | 154198 | 3771 | 148200 | 2350 | 50.1183 | 7.309 | 2021-06-11 04:23:20 | Rheinland-Pfalz, Germany | ||
2020936 | 2020936 | 2021-04-20 | Russia | Kostroma Oblast | 20367 | 422 | 17595 | 2350 | 58.424756 | 44.2533273 | 2021-04-21 04:21:14 | Kostroma Oblast, Russia | ||
244938 | 244938 | 2021-04-02 | Malaysia | Sarawak | 16845 | 112 | 14383 | 2350 | 1.5533 | 110.3592 | 2021-04-03 04:20:44 | Sarawak, Malaysia | ||
3670067 | 3670067 | 2021-03-06 | US | Ohio | Coshocton | 39031 | 2407 | 57 | 0 | 2350 | 40.30096166 | -81.91729018 | 2021-03-07 05:21:54 | Coshocton, Ohio, US |
3669073 | 3669073 | 2021-03-06 | US | Kentucky | Perry | 21193 | 2390 | 40 | 0 | 2350 | 37.25023553 | -83.22922731 | 2021-03-07 05:21:54 | Perry, Kentucky, US |
3668565 | 3668565 | 2021-03-06 | US | Idaho | Payette | 16075 | 2382 | 32 | 0 | 2350 | 44.00545243 | -116.7647695 | 2021-03-07 05:21:54 | Payette, Idaho, US |
1617186 | 1617186 | 2021-03-05 | US | Idaho | Payette | 16075 | 2382 | 32 | 0 | 2350 | 44.00545243 | -116.7647695 | 2021-03-06 04:23:41 | Payette, Idaho, US |
2208807 | 2208807 | 2021-03-04 | US | Iowa | Benton | 19011 | 2404 | 54 | 0 | 2350 | 42.08011739 | -92.06463573 | 2021-03-05 05:26:29 | Benton, Iowa, US |
2208597 | 2208597 | 2021-03-04 | US | Idaho | Payette | 16075 | 2382 | 32 | 0 | 2350 | 44.00545243 | -116.7647695 | 2021-03-05 05:26:29 | Payette, Idaho, US |
2186923 | 2186923 | 2021-02-26 | US | Virginia | Halifax | 51083 | 2409 | 59 | 0 | 2350 | 36.76654925 | -78.93512622 | 2021-02-27 05:22:28 | Halifax, Virginia, US |
2185161 | 2185161 | 2021-02-26 | US | Maryland | Somerset | 24039 | 2381 | 31 | 0 | 2350 | 38.1163542 | -75.75118623 | 2021-02-27 05:22:28 | Somerset, Maryland, US |
282790 | 282790 | 2021-02-24 | US | Oregon | Douglas | 41019 | 2402 | 52 | 0 | 2350 | 43.27941273 | -123.167291 | 2021-02-25 05:24:57 | Douglas, Oregon, US |
281248 | 281248 | 2021-02-24 | US | Indiana | Clay | 18021 | 2394 | 44 | 0 | 2350 | 39.39561833 | -87.11723506 | 2021-02-25 05:24:57 | Clay, Indiana, US |
743469 | 743469 | 2021-02-20 | US | Iowa | Boone | 19015 | 2380 | 30 | 0 | 2350 | 42.03657094 | -93.9313999 | 2021-02-21 05:24:33 | Boone, Iowa, US |
472567 | 472567 | 2021-02-19 | US | Iowa | Boone | 19015 | 2380 | 30 | 0 | 2350 | 42.03657094 | -93.9313999 | 2021-02-20 05:22:51 | Boone, Iowa, US |
2680815 | 2680815 | 2021-02-13 | US | Tennessee | Trousdale | 47169 | 2377 | 21 | 0 | 2350 | 36.39026213 | -86.16087954 | 2021-02-14 05:23:43 | Trousdale, Tennessee, US |
1672655 | 1672655 | 2021-02-07 | Russia | Ivanovo Oblast | 27923 | 802 | 24771 | 2350 | 56.9167446 | 41.43521370000001 | 2021-02-08 05:22:39 | Ivanovo Oblast, Russia | ||
341420 | 341420 | 2021-02-03 | US | Indiana | Wells | 18179 | 2413 | 63 | 0 | 2350 | 40.72934187 | -85.22132966 | 2021-02-04 05:22:26 | Wells, Indiana, US |
341178 | 341178 | 2021-02-03 | US | Hawaii | Maui | 15009 | 2376 | 26 | 0 | 2350 | 20.86399628 | -156.56890969999995 | 2021-02-04 05:22:26 | Maui, Hawaii, US |
1900138 | 1900138 | 2021-01-29 | US | Tennessee | Smith | 47159 | 2429 | 30 | 0 | 2350 | 36.25359775 | -85.95411046 | 2021-01-30 05:22:49 | Smith, Tennessee, US |
3155869 | 3155869 | 2021-01-27 | US | New York | Tioga | 36107 | 2404 | 54 | 0 | 2350 | 42.16852837 | -76.30835812 | 2021-01-28 05:22:24 | Tioga, New York, US |
13076 | 13076 | 2021-01-26 | US | Florida | Washington | 12133 | 2381 | 31 | 0 | 2350 | 30.61359259 | -85.66002461 | 2021-01-27 05:23:41 | Washington, Florida, US |
2428740 | 2428740 | 2021-01-23 | US | Mississippi | Simpson | 28127 | 2421 | 71 | 0 | 2350 | 31.91282117 | -89.91716179 | 2021-01-24 05:22:35 | Simpson, Mississippi, US |
2427683 | 2427683 | 2021-01-23 | US | Georgia | Decatur | 13087 | 2407 | 57 | 0 | 2350 | 30.87967778 | -84.57619536 | 2021-01-24 05:22:35 | Decatur, Georgia, US |
3504186 | 3504186 | 2021-01-17 | US | Georgia | Lumpkin | 13187 | 2382 | 32 | 0 | 2350 | 34.57286511 | -84.00425681 | 2021-01-18 05:22:34 | Lumpkin, Georgia, US |
3516094 | 3516094 | 2021-01-15 | US | Florida | Hardee | 12049 | 2371 | 21 | 0 | 2350 | 27.49293939 | -81.80956574 | 2021-01-16 05:22:40 | Hardee, Florida, US |
3309295 | 3309295 | 2021-01-13 | US | Indiana | Jefferson | 18077 | 2406 | 56 | 0 | 2350 | 38.78576239 | -85.43633383 | 2021-01-14 05:22:32 | Jefferson, Indiana, US |
192246 | 192246 | 2021-01-11 | US | New Mexico | Cibola | 35006 | 2431 | 81 | 0 | 2350 | 34.91131525 | -107.998876 | 2021-01-12 05:22:15 | Cibola, New Mexico, US |
2542474 | 2542474 | 2021-01-07 | US | Indiana | Daviess | 18027 | 2425 | 75 | 0 | 2350 | 38.70186039 | -87.07185406 | 2021-01-08 05:22:42 | Daviess, Indiana, US |
3036213 | 3036213 | 2021-01-05 | US | Missouri | Lawrence | 29109 | 2407 | 57 | 0 | 2350 | 37.10626634 | -93.83293097 | 2021-01-06 05:22:16 | Lawrence, Missouri, US |
3763410 | 3763410 | 2020-12-28 | US | Mississippi | Pearl River | 28109 | 2430 | 80 | 0 | 2350 | 30.77090935 | -89.58677275 | 2020-12-29 05:22:37 | Pearl River, Mississippi, US |
3778994 | 3778994 | 2020-12-27 | US | Indiana | Jasper | 18073 | 2380 | 30 | 0 | 2350 | 41.02078733 | -87.11553319 | 2020-12-28 05:22:06 | Jasper, Indiana, US |
204814 | 204814 | 2020-12-25 | US | Oklahoma | Logan | 40083 | 2357 | 7 | 0 | 2350 | 35.91899576 | -97.44352845 | 2020-12-26 05:22:28 | Logan, Oklahoma, US |
3694037 | 3694037 | 2020-12-24 | US | Oklahoma | Logan | 40083 | 2357 | 7 | 0 | 2350 | 35.91899576 | -97.44352845 | 2020-12-25 05:22:48 | Logan, Oklahoma, US |
2120077 | 2120077 | 2020-12-20 | US | Alabama | Escambia | 1053 | 2383 | 33 | 0 | 2350 | 31.1256789 | -87.15918694 | 2020-12-21 05:27:58 | Escambia, Alabama, US |
2119576 | 2119576 | 2020-12-20 | Colombia | Tolima | 37547 | 1118 | 34079 | 2350 | 4.0925 | -75.1545 | 2020-12-21 05:27:58 | Tolima, Colombia | ||
2932578 | 2932578 | 2020-12-19 | US | Kentucky | Barren | 21009 | 2384 | 34 | 0 | 2350 | 36.96469836 | -85.93338945 | 2020-12-20 05:27:32 | Barren, Kentucky, US |
1820445 | 1820445 | 2020-12-08 | US | Michigan | Montcalm | 26117 | 2385 | 35 | 0 | 2350 | 43.31082541 | -85.15252824 | 2020-12-09 05:28:01 | Montcalm, Michigan, US |
1008160 | 1008160 | 2020-12-06 | US | Missouri | Butler | 29023 | 2359 | 9 | 0 | 2350 | 36.71462476 | -90.40421163 | 2020-12-07 05:26:14 | Butler, Missouri, US |
1006880 | 1006880 | 2020-12-06 | US | California | Yuba | 6115 | 2358 | 10 | 0 | 2350 | 39.26255932 | -121.3535644 | 2020-12-07 05:26:14 | Yuba, California, US |
739104 | 739104 | 2020-12-02 | US | Georgia | Habersham | 13137 | 2432 | 82 | 0 | 2350 | 34.63331566 | -83.53094677 | 2020-12-03 05:28:22 | Habersham, Georgia, US |
2935150 | 2935150 | 2020-11-28 | Germany | Saarland | 12237 | 250 | 10199 | 2350 | 49.3964 | 7.023 | 2020-11-29 05:25:55 | Saarland, Germany | ||
2935026 | 2935026 | 2020-11-28 | Chile | Metropolitana | 304601 | 10308 | 291943 | 2350 | -33.4376 | -70.6505 | 2020-11-29 05:25:55 | Metropolitana, Chile | ||
3192298 | 3192298 | 2020-11-22 | US | North Carolina | Granville | 37077 | 2405 | 55 | 0 | 2350 | 36.30337451 | -78.65184241 | 2020-11-23 05:25:26 | Granville, North Carolina, US |
3836367 | 3836367 | 2020-11-21 | El Salvador | 37404 | 1070 | 33984 | 2350 | 13.7942 | -88.8965 | 2020-11-22 05:25:45 | El Salvador | |||
124811 | 124811 | 2020-11-18 | US | Nebraska | Scotts Bluff | 31157 | 2363 | 13 | 0 | 2350 | 41.85070896 | -103.7080986 | 2020-11-19 05:25:23 | Scotts Bluff, Nebraska, US |
3341115 | 3341115 | 2020-11-17 | US | Oklahoma | Bryan | 40013 | 2367 | 17 | 0 | 2350 | 33.96472458 | -96.25903472 | 2020-11-18 05:40:31 | Bryan, Oklahoma, US |
865002 | 865002 | 2020-11-12 | Russia | Orenburg Oblast | 19808 | 149 | 17309 | 2350 | 52.02692620000001 | 54.7276647 | 2020-11-13 05:25:30 | Orenburg Oblast, Russia | ||
3440726 | 3440726 | 2020-11-11 | Germany | Bremen | 7367 | 89 | 5163 | 2350 | 53.0793 | 8.8017 | 2020-11-12 05:25:55 | Bremen, Germany | ||
275557 | 275557 | 2020-11-10 | US | Virginia | Suffolk | 51800 | 2428 | 78 | 0 | 2350 | 36.70155394 | -76.63603554 | 2020-11-11 05:25:30 | Suffolk, Virginia, US |
272976 | 272976 | 2020-11-10 | US | Georgia | Laurens | 13175 | 2453 | 103 | 0 | 2350 | 32.46325233 | -82.92221316 | 2020-11-11 05:25:30 | Laurens, Georgia, US |
1732034 | 1732034 | 2020-11-08 | US | Wisconsin | Marinette | 55075 | 2369 | 19 | 0 | 2350 | 45.38553432 | -88.03324599999998 | 2020-11-09 05:25:45 | Marinette, Wisconsin, US |
1729341 | 1729341 | 2020-11-08 | US | Georgia | Rockdale | 13247 | 2393 | 43 | 0 | 2350 | 33.65145002 | -84.02202167 | 2020-11-09 05:25:45 | Rockdale, Georgia, US |
2919366 | 2919366 | 2020-11-04 | Russia | Astrakhan Oblast | 10074 | 178 | 7546 | 2350 | 47.1878186 | 47.608851 | 2020-11-05 06:05:03 | Astrakhan Oblast, Russia | ||
3305349 | 3305349 | 2020-11-02 | US | Iowa | Buena Vista | 19021 | 2362 | 12 | 0 | 2350 | 42.73545875 | -95.15100162 | 2020-11-03 06:00:16 | Buena Vista, Iowa, US |
2245119 | 2245119 | 2020-10-30 | US | Minnesota | Nobles | 27105 | 2368 | 18 | 0 | 2350 | 43.67434621 | -95.75329576 | 2020-10-31 04:24:44 | Nobles, Minnesota, US |
2243464 | 2243464 | 2020-10-30 | Mexico | Chihuahua | 18079 | 1942 | 13787 | 2350 | 28.633000000000006 | -106.0691 | 2020-10-31 04:24:44 | Chihuahua, Mexico | ||
3482117 | 3482117 | 2020-10-26 | US | Mississippi | Lauderdale | 28075 | 2485 | 135 | 0 | 2350 | 32.40419769 | -88.66229662 | 2020-10-27 04:24:45 | Lauderdale, Mississippi, US |
1798018 | 1798018 | 2020-10-19 | US | Virginia | Roanoke City | 51770 | 2385 | 35 | 0 | 2350 | 37.27791025 | -79.96189766 | 2020-10-20 04:24:22 | Roanoke City, Virginia, US |
2859659 | 2859659 | 2020-10-16 | US | South Carolina | Lancaster | 45057 | 2406 | 56 | 0 | 2350 | 34.68270843 | -80.70513032 | 2020-10-17 04:24:12 | Lancaster, South Carolina, US |
2693203 | 2693203 | 2020-10-08 | US | Wisconsin | Dodge | 55027 | 2369 | 19 | 0 | 2350 | 43.41576662 | -88.70928178 | 2020-10-09 04:23:59 | Dodge, Wisconsin, US |
2514373 | 2514373 | 2020-10-03 | Russia | Karachay-Cherkess Republic | 7274 | 29 | 4895 | 2350 | 43.7368326 | 41.7267991 | 2020-10-04 04:23:44 | Karachay-Cherkess Republic, Russia | ||
3392916 | 3392916 | 2020-10-02 | US | Wisconsin | Fond du Lac | 55039 | 2364 | 14 | 0 | 2350 | 43.75354908 | -88.48885325 | 2020-10-03 04:23:40 | Fond du Lac, Wisconsin, US |
2609587 | 2609587 | 2020-09-24 | US | Wisconsin | Rock | 55105 | 2382 | 32 | 0 | 2350 | 42.67151616 | -89.071479 | 2020-09-25 04:23:00 | Rock, Wisconsin, US |
3319850 | 3319850 | 2020-09-22 | Ukraine | Zhytomyr Oblast | 5121 | 92 | 2679 | 2350 | 50.2547 | 28.6587 | 2020-09-23 04:23:00 | Zhytomyr Oblast, Ukraine | ||
666129 | 666129 | 2020-09-16 | Colombia | Huila | 8506 | 255 | 5901 | 2350 | 2.5359 | -75.5277 | 2020-09-17 04:22:00 | Huila, Colombia | ||
3485062 | 3485062 | 2020-08-20 | US | Georgia | Clarke | 13059 | 2372 | 22 | 0 | 2350 | 33.95436462 | -83.37124007 | 2020-08-21 04:27:41 | Clarke, Georgia, US |
369679 | 369679 | 2020-08-08 | US | Mississippi | Madison | 28089 | 2414 | 64 | 0 | 2350 | 32.63389156 | -90.03513564 | 2020-08-09 04:34:54 | Madison, Mississippi, US |
3790661 | 3790661 | 2020-08-05 | US | Georgia | Glynn | 13127 | 2392 | 42 | 0 | 2350 | 31.23279254 | -81.53811412 | 2020-08-06 04:35:02 | Glynn, Georgia, US |
98437 | 98437 | 2020-08-04 | Peru | Puno | 2705 | 355 | 0 | 2350 | -14.995826999999998 | -69.922726 | 2020-08-05 04:34:43 | Puno, Peru | ||
95654 | 95654 | 2020-08-04 | US | Georgia | Douglas | 13097 | 2400 | 50 | 0 | 2350 | 33.70291126 | -84.77026156 | 2020-08-05 04:34:43 | Douglas, Georgia, US |
2807315 | 2807315 | 2020-08-02 | US | Texas | Tom Green | 48451 | 1120 | 29 | 0 | 2350 | 31.40464436 | -100.462443 | 2020-08-03 04:34:35 | Tom Green, Texas, US |
3264231 | 3264231 | 2020-07-31 | US | Kentucky | Warren | 21227 | 2372 | 22 | 0 | 2350 | 36.99903045 | -86.42672751 | 2020-08-01 04:36:27 | Warren, Kentucky, US |
2956651 | 2956651 | 2020-07-29 | US | Louisiana | Lafourche | 22057 | 2446 | 96 | 0 | 2350 | 29.52470226 | -90.40976986 | 2020-07-30 04:35:05 | Lafourche, Louisiana, US |
845028 | 845028 | 2020-07-22 | Russia | Voronezh Oblast | 10347 | 78 | 7919 | 2350 | 50.9800393 | 40.15065070000001 | 2020-07-23 05:15:04 | Voronezh Oblast, Russia | ||
325405 | 325405 | 2020-07-20 | US | Alabama | Marshall | 1095 | 2369 | 19 | 0 | 2350 | 34.36975964 | -86.30486727 | 2020-07-21 04:38:46 | Marshall, Alabama, US |
2684968 | 2684968 | 2020-07-06 | Russia | Novosibirsk Oblast | 6611 | 116 | 4145 | 2350 | 54.9720169 | 79.48139240000002 | 2020-07-07 04:34:00 | Novosibirsk Oblast, Russia | ||
2305629 | 2305629 | 2020-06-28 | US | Florida | Seminole | 12117 | 2366 | 16 | 0 | 2350 | 28.7158582 | -81.24060348 | 2020-06-29 04:33:44 | Seminole, Florida, US |
1508277 | 1508277 | 2020-06-22 | US | Michigan | Genesee | 26049 | 2634 | 284 | 0 | 2350 | 43.02244215 | -83.70589709 | 2020-06-23 04:33:22 | Genesee, Michigan, US |
1196096 | 1196096 | 2020-06-17 | Sweden | Uppsala | 2555 | 205 | 0 | 2350 | 60.0092 | 17.2715 | 2020-06-18 04:33:18 | Uppsala, Sweden |
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]);