johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where active = 2837 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 53
- Russia 7
- Colombia 5
- El Salvador 2
- Italy 2
- Angola 1
- Qatar 1
- Sweden 1
- Switzerland 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015330 | 3015330 | 2021-08-01 | Italy | Calabria | 71081 | 1255 | 66989 | 2837 | 38.90597598 | 16.59440194 | 2021-08-02 04:21:36 | Calabria, Italy | ||
2674067 | 2674067 | 2021-07-18 | Russia | Tula Oblast | 45520 | 2341 | 40342 | 2837 | 53.9570701 | 37.3690909 | 2021-07-19 04:21:24 | Tula Oblast, Russia | ||
1495586 | 1495586 | 2021-07-03 | Italy | Lazio | 346186 | 8347 | 335002 | 2837 | 41.89277044 | 12.48366722 | 2021-07-04 04:21:38 | Lazio, Italy | ||
2911025 | 2911025 | 2021-06-17 | Colombia | Narino | 71454 | 2392 | 66225 | 2837 | 1.2892 | -77.3579 | 2021-06-18 04:22:16 | Narino, Colombia | ||
522741 | 522741 | 2021-06-09 | El Salvador | 74983 | 2279 | 69867 | 2837 | 13.7942 | -88.8965 | 2021-06-10 04:23:17 | El Salvador | |||
3472181 | 3472181 | 2021-06-08 | El Salvador | 74983 | 2279 | 69867 | 2837 | 13.7942 | -88.8965 | 2021-06-09 04:23:31 | El Salvador | |||
241469 | 241469 | 2021-04-02 | Russia | Krasnodar Krai | 42588 | 2345 | 37406 | 2837 | 45.7684014 | 39.0261044 | 2021-04-03 04:20:44 | Krasnodar Krai, Russia | ||
2781243 | 2781243 | 2021-03-24 | Russia | Tatarstan Republic | 19153 | 407 | 15909 | 2837 | 55.7648572 | 52.43104273 | 2021-03-25 05:27:00 | Tatarstan Republic, Russia | ||
2055718 | 2055718 | 2021-03-15 | Colombia | Atlantico | 129456 | 4117 | 122502 | 2837 | 10.6966 | -74.8741 | 2021-03-16 05:25:13 | Atlantico, Colombia | ||
2210634 | 2210634 | 2021-03-04 | US | Tennessee | Scott | 47151 | 2898 | 44 | 0 | 2837 | 36.42325673 | -84.50360494 | 2021-03-05 05:26:29 | Scott, Tennessee, US |
2210113 | 2210113 | 2021-03-04 | US | Ohio | Guernsey | 39059 | 2884 | 47 | 0 | 2837 | 40.05026529 | -81.49248905 | 2021-03-05 05:26:29 | Guernsey, Ohio, US |
3255068 | 3255068 | 2021-03-02 | US | Idaho | Cassia | 16031 | 2862 | 25 | 0 | 2837 | 42.28347888 | -113.6012409 | 2021-03-03 05:23:28 | Cassia, Idaho, US |
999360 | 999360 | 2021-03-01 | US | Idaho | Cassia | 16031 | 2862 | 25 | 0 | 2837 | 42.28347888 | -113.6012409 | 2021-03-02 05:23:30 | Cassia, Idaho, US |
2186579 | 2186579 | 2021-02-26 | US | Tennessee | Wayne | 47181 | 2875 | 30 | 0 | 2837 | 35.23868267 | -87.78644456 | 2021-02-27 05:22:28 | Wayne, Tennessee, US |
1861001 | 1861001 | 2021-02-25 | US | Tennessee | Wayne | 47181 | 2875 | 30 | 0 | 2837 | 35.23868267 | -87.78644456 | 2021-02-26 05:22:40 | Wayne, Tennessee, US |
1938226 | 1938226 | 2021-02-23 | US | Mississippi | Alcorn | 28003 | 2897 | 60 | 0 | 2837 | 34.88084463 | -88.57996173 | 2021-02-24 05:29:16 | Alcorn, Mississippi, US |
532481 | 532481 | 2021-02-22 | US | Mississippi | Alcorn | 28003 | 2897 | 60 | 0 | 2837 | 34.88084463 | -88.57996173 | 2021-02-23 05:23:41 | Alcorn, Mississippi, US |
742707 | 742707 | 2021-02-20 | US | Alabama | Pike | 1109 | 2907 | 70 | 0 | 2837 | 31.80396383 | -85.9408295 | 2021-02-21 05:24:33 | Pike, Alabama, US |
3601284 | 3601284 | 2021-02-17 | Russia | Samara Oblast | 45398 | 896 | 41665 | 2837 | 53.2128813 | 50.8914633 | 2021-02-18 05:22:58 | Samara Oblast, Russia | ||
1340213 | 1340213 | 2021-02-15 | US | Missouri | Phelps | 29161 | 2954 | 117 | 0 | 2837 | 37.87736118 | -91.79351727 | 2021-02-16 05:24:38 | Phelps, Missouri, US |
2679303 | 2679303 | 2021-02-13 | US | Louisiana | Allen | 22003 | 2919 | 82 | 0 | 2837 | 30.65385745 | -92.82442028 | 2021-02-14 05:23:43 | Allen, Louisiana, US |
3541289 | 3541289 | 2021-02-12 | US | Mississippi | Pike | 28113 | 2926 | 89 | 0 | 2837 | 31.17507789 | -90.40392572 | 2021-02-13 05:22:12 | Pike, Mississippi, US |
3540936 | 3540936 | 2021-02-12 | US | Louisiana | Allen | 22003 | 2919 | 82 | 0 | 2837 | 30.65385745 | -92.82442028 | 2021-02-13 05:22:12 | Allen, Louisiana, US |
792942 | 792942 | 2021-02-04 | US | Oklahoma | Lincoln | 40081 | 2880 | 43 | 0 | 2837 | 35.70270942 | -96.8812462 | 2021-02-05 05:22:38 | Lincoln, Oklahoma, US |
340820 | 340820 | 2021-02-03 | US | California | Lake | 6033 | 2870 | 33 | 0 | 2837 | 39.10124298 | -122.7536244 | 2021-02-04 05:22:26 | Lake, California, US |
1462787 | 1462787 | 2021-01-31 | US | Texas | Caldwell | 48055 | 3369 | 67 | 0 | 2837 | 29.83668859 | -97.61814775 | 2021-02-01 05:22:53 | Caldwell, Texas, US |
2214520 | 2214520 | 2021-01-30 | US | South Dakota | Davison | 46035 | 2896 | 59 | 0 | 2837 | 43.67490933 | -98.14458906 | 2021-01-31 05:22:42 | Davison, South Dakota, US |
1899619 | 1899619 | 2021-01-29 | US | Ohio | Highland | 39071 | 2890 | 53 | 0 | 2837 | 39.1839264 | -83.60331456 | 2021-01-30 05:22:49 | Highland, Ohio, US |
14056 | 14056 | 2021-01-26 | US | Minnesota | Itasca | 27061 | 2880 | 43 | 0 | 2837 | 47.51009045 | -93.63092229 | 2021-01-27 05:23:41 | Itasca, Minnesota, US |
2427778 | 2427778 | 2021-01-23 | US | Georgia | Toombs | 13279 | 2916 | 79 | 0 | 2837 | 32.12059861 | -82.32957247 | 2021-01-24 05:22:35 | Toombs, Georgia, US |
2469296 | 2469296 | 2021-01-22 | US | Ohio | Ottawa | 39123 | 2901 | 64 | 0 | 2837 | 41.53781826 | -83.0940185 | 2021-01-23 05:22:03 | Ottawa, Ohio, US |
910774 | 910774 | 2021-01-19 | US | Oklahoma | Woodward | 40153 | 2849 | 12 | 0 | 2837 | 36.42316318 | -99.26283045 | 2021-01-20 05:21:54 | Woodward, Oklahoma, US |
908015 | 908015 | 2021-01-19 | Colombia | Boyaca | 36460 | 753 | 32870 | 2837 | 5.4545 | -73.362 | 2021-01-20 05:21:54 | Boyaca, Colombia | ||
3308659 | 3308659 | 2021-01-13 | US | Arkansas | Boone | 5009 | 2908 | 71 | 0 | 2837 | 36.3084504 | -93.09374925 | 2021-01-14 05:22:32 | Boone, Arkansas, US |
775845 | 775845 | 2021-01-12 | US | Louisiana | Iberville | 22047 | 2912 | 75 | 0 | 2837 | 30.25734305 | -91.3499598 | 2021-01-13 05:22:15 | Iberville, Louisiana, US |
2542693 | 2542693 | 2021-01-07 | US | Kansas | Harvey | 20079 | 2866 | 29 | 0 | 2837 | 38.04293782 | -97.42747573 | 2021-01-08 05:22:42 | Harvey, Kansas, US |
2542616 | 2542616 | 2021-01-07 | US | Iowa | Marion | 19125 | 2887 | 50 | 0 | 2837 | 41.33445101 | -93.09934783 | 2021-01-08 05:22:42 | Marion, Iowa, US |
2542410 | 2542410 | 2021-01-07 | US | Illinois | Logan | 17107 | 2878 | 41 | 0 | 2837 | 40.12581572 | -89.36638784 | 2021-01-08 05:22:42 | Logan, Illinois, US |
2866110 | 2866110 | 2021-01-06 | US | Kentucky | Graves | 21083 | 2888 | 51 | 0 | 2837 | 36.72292505 | -88.65143315 | 2021-01-07 05:22:03 | Graves, Kentucky, US |
2866002 | 2866002 | 2021-01-06 | US | Kansas | Harvey | 20079 | 2866 | 29 | 0 | 2837 | 38.04293782 | -97.42747573 | 2021-01-07 05:22:03 | Harvey, Kansas, US |
3034897 | 3034897 | 2021-01-05 | US | Colorado | Broomfield | 8014 | 3198 | 68 | 0 | 2837 | 39.95998787 | -105.0566324 | 2021-01-06 05:22:16 | Broomfield, Colorado, US |
3231959 | 3231959 | 2021-01-03 | US | Louisiana | Natchitoches | 22069 | 2896 | 59 | 0 | 2837 | 31.72321584 | -93.09816516 | 2021-01-04 05:22:02 | Natchitoches, Louisiana, US |
1013664 | 1013664 | 2020-12-30 | US | Virginia | Manassas | 51683 | 2867 | 30 | 0 | 2837 | 38.7464321 | -77.48509905 | 2020-12-31 05:22:49 | Manassas, Virginia, US |
768488 | 768488 | 2020-12-29 | US | New Jersey | Salem | 34033 | 2946 | 109 | 0 | 2837 | 39.58719656 | -75.34696629999998 | 2020-12-30 05:22:34 | Salem, New Jersey, US |
3764170 | 3764170 | 2020-12-28 | US | Oklahoma | Stephens | 40137 | 2860 | 23 | 0 | 2837 | 34.48556989 | -97.85141892 | 2020-12-29 05:22:37 | Stephens, Oklahoma, US |
3778972 | 3778972 | 2020-12-27 | US | Indiana | DeKalb | 18033 | 2896 | 59 | 0 | 2837 | 41.39804622 | -84.99906934 | 2020-12-28 05:22:06 | DeKalb, Indiana, US |
2224577 | 2224577 | 2020-12-26 | US | Indiana | DeKalb | 18033 | 2896 | 59 | 0 | 2837 | 41.39804622 | -84.99906934 | 2020-12-27 05:22:55 | DeKalb, Indiana, US |
3772912 | 3772912 | 2020-12-22 | US | Texas | Cherokee | 48073 | 1960 | 69 | 0 | 2837 | 31.837258 | -95.16559897 | 2020-12-23 05:22:03 | Cherokee, Texas, US |
3149801 | 3149801 | 2020-12-16 | Russia | Khakassia Republic | 14949 | 177 | 11935 | 2837 | 53.72258845 | 91.44293627 | 2020-12-17 05:28:12 | Khakassia Republic, Russia | ||
848097 | 848097 | 2020-12-12 | US | Oklahoma | Cherokee | 40021 | 2850 | 13 | 0 | 2837 | 35.90692775 | -94.99980896 | 2020-12-13 05:27:20 | Cherokee, Oklahoma, US |
847475 | 847475 | 2020-12-12 | US | Missouri | Johnson | 29101 | 2859 | 22 | 0 | 2837 | 38.74719601 | -93.80691168 | 2020-12-13 05:27:20 | Johnson, Missouri, US |
2937287 | 2937287 | 2020-11-28 | US | Nebraska | Dodge | 31053 | 2871 | 34 | 0 | 2837 | 41.58071748 | -96.65598179 | 2020-11-29 05:25:55 | Dodge, Nebraska, US |
2787331 | 2787331 | 2020-11-13 | US | North Carolina | Lincoln | 37109 | 2853 | 16 | 0 | 2837 | 35.48508185 | -81.21740317 | 2020-11-14 05:25:37 | Lincoln, North Carolina, US |
2786814 | 2786814 | 2020-11-13 | US | Mississippi | Lauderdale | 28075 | 2978 | 141 | 0 | 2837 | 32.40419769 | -88.66229662 | 2020-11-14 05:25:37 | Lauderdale, Mississippi, US |
2919923 | 2919923 | 2020-11-04 | US | Georgia | Barrow | 13013 | 2889 | 52 | 0 | 2837 | 33.99148694 | -83.71436292 | 2020-11-05 06:05:03 | Barrow, Georgia, US |
210469 | 210469 | 2020-10-29 | Russia | Omsk Oblast | 15388 | 406 | 12145 | 2837 | 56.09352629999999 | 73.5099936 | 2020-10-30 04:24:49 | Omsk Oblast, Russia | ||
1054200 | 1054200 | 2020-10-23 | US | Alabama | Limestone | 1083 | 2867 | 30 | 0 | 2837 | 34.81185586 | -86.98310072 | 2020-10-24 04:24:46 | Limestone, Alabama, US |
81750 | 81750 | 2020-10-14 | US | Pennsylvania | Lackawanna | 42069 | 3054 | 217 | 0 | 2837 | 41.43564672 | -75.60379201 | 2020-10-15 04:24:28 | Lackawanna, Pennsylvania, US |
78935 | 78935 | 2020-10-14 | Colombia | Cundinamarca | 37284 | 1095 | 33352 | 2837 | 5.026 | -74.03 | 2020-10-15 04:24:28 | Cundinamarca, Colombia | ||
2581687 | 2581687 | 2020-09-27 | Angola | 4718 | 174 | 1707 | 2837 | -11.2027 | 17.8739 | 2020-09-28 04:23:00 | Angola | |||
2655237 | 2655237 | 2020-09-23 | US | Louisiana | Acadia | 22001 | 2933 | 96 | 0 | 2837 | 30.2950649 | -92.41419698 | 2020-09-24 04:23:00 | Acadia, Louisiana, US |
344451 | 344451 | 2020-09-14 | Qatar | 121975 | 207 | 118931 | 2837 | 25.3548 | 51.1839 | 2020-09-15 03:22:50 | Qatar | |||
149180 | 149180 | 2020-08-15 | US | Texas | Tom Green | 48451 | 1568 | 47 | 0 | 2837 | 31.40464436 | -100.462443 | 2020-08-16 04:27:42 | Tom Green, Texas, US |
1615850 | 1615850 | 2020-08-14 | Ukraine | Kharkiv Oblast | 5583 | 155 | 2591 | 2837 | 49.9935 | 36.2304 | 2020-08-15 04:27:31 | Kharkiv Oblast, Ukraine | ||
458989 | 458989 | 2020-08-07 | Switzerland | 36269 | 1832 | 31600 | 2837 | 46.8182 | 8.2275 | 2020-08-08 04:34:53 | Switzerland | |||
98172 | 98172 | 2020-08-04 | Russia | Chuvashia Republic | 6880 | 58 | 3985 | 2837 | 55.4259922 | 47.0849429 | 2020-08-05 04:34:43 | Chuvashia Republic, Russia | ||
94918 | 94918 | 2020-08-04 | US | Virginia | Arlington | 51013 | 2973 | 136 | 0 | 2837 | 38.8767675 | -77.10139853 | 2020-08-05 04:34:43 | Arlington, Virginia, US |
752007 | 752007 | 2020-08-01 | US | Arizona | Mohave | 4015 | 2990 | 153 | 0 | 2837 | 35.70471703 | -113.7577902 | 2020-08-02 04:34:47 | Mohave, Arizona, US |
2958420 | 2958420 | 2020-07-29 | Colombia | Cordoba | 5032 | 600 | 1595 | 2837 | 8.0493 | -75.574 | 2020-07-30 04:35:05 | Cordoba, Colombia | ||
3182760 | 3182760 | 2020-07-28 | US | New Jersey | Gloucester | 34015 | 3040 | 203 | 0 | 2837 | 39.71581067 | -75.13995546 | 2020-07-29 04:35:11 | Gloucester, New Jersey, US |
2158623 | 2158623 | 2020-07-14 | Sweden | Gavleborg | 2981 | 144 | 0 | 2837 | 61.3012 | 16.1534 | 2020-07-15 04:34:39 | Gavleborg, Sweden | ||
3488036 | 3488036 | 2020-07-13 | US | Indiana | Allen | 18003 | 2971 | 134 | 0 | 2837 | 41.09194313 | -85.06800636 | 2020-07-14 04:34:46 | Allen, Indiana, US |
3734354 | 3734354 | 2020-07-12 | US | New Jersey | Atlantic | 34001 | 3069 | 232 | 0 | 2837 | 39.47538693 | -74.65848483 | 2020-07-13 04:43:04 | Atlantic, New Jersey, US |
2037395 | 2037395 | 2020-06-27 | US | North Carolina | Forsyth | 37067 | 2871 | 34 | 0 | 2837 | 36.12859861 | -80.25459052 | 2020-06-28 04:34:04 | Forsyth, North Carolina, 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]);