johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where active = 2754 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
483464 | 483464 | 2021-07-19 | Czechia | 1671145 | 30338 | 1638053 | 2754 | 49.8175 | 15.473 | 2021-07-20 04:21:48 | Czechia | |||
3706334 | 3706334 | 2021-07-17 | Russia | Karelia Republic | 53328 | 679 | 49895 | 2754 | 62.61940309999999 | 33.4920267 | 2021-07-18 04:22:07 | Karelia Republic, Russia | ||
2947603 | 2947603 | 2021-07-16 | Russia | Saratov Oblast | 69410 | 1538 | 65118 | 2754 | 51.6520555 | 46.86319520000001 | 2021-07-17 04:22:22 | Saratov Oblast, Russia | ||
1310416 | 1310416 | 2021-05-26 | Russia | Sverdlovsk Oblast | 88814 | 3367 | 82693 | 2754 | 58.6414755 | 61.8021546 | 2021-05-27 04:20:59 | Sverdlovsk Oblast, Russia | ||
3421136 | 3421136 | 2021-03-19 | Russia | Kursk Oblast | 32851 | 527 | 29570 | 2754 | 51.6568453 | 36.4852695 | 2021-03-20 05:25:46 | Kursk Oblast, Russia | ||
1618858 | 1618858 | 2021-03-05 | US | Oregon | Klamath | 41035 | 2809 | 55 | 0 | 2754 | 42.68762984 | -121.64964609999998 | 2021-03-06 04:23:41 | Klamath, Oregon, US |
999630 | 999630 | 2021-03-01 | US | Iowa | Henry | 19087 | 2791 | 37 | 0 | 2754 | 40.98767962 | -91.54436349 | 2021-03-02 05:23:30 | Henry, Iowa, US |
999217 | 999217 | 2021-03-01 | US | Georgia | Dawson | 13085 | 2789 | 35 | 0 | 2754 | 34.44244079 | -84.16964071 | 2021-03-02 05:23:30 | Dawson, Georgia, US |
2184651 | 2184651 | 2021-02-26 | US | Indiana | Daviess | 18027 | 2850 | 96 | 0 | 2754 | 38.70186039 | -87.07185406 | 2021-02-27 05:22:28 | Daviess, Indiana, US |
2184275 | 2184275 | 2021-02-26 | US | Florida | Hardee | 12049 | 2783 | 29 | 0 | 2754 | 27.49293939 | -81.80956574 | 2021-02-27 05:22:28 | Hardee, Florida, US |
283600 | 283600 | 2021-02-24 | US | Virginia | Wise | 51195 | 2840 | 86 | 0 | 2754 | 36.9746148 | -82.62410519 | 2021-02-25 05:24:57 | Wise, Virginia, US |
281374 | 281374 | 2021-02-24 | US | Iowa | Henry | 19087 | 2789 | 35 | 0 | 2754 | 40.98767962 | -91.54436349 | 2021-02-25 05:24:57 | Henry, Iowa, US |
472084 | 472084 | 2021-02-19 | US | Florida | Bradford | 12007 | 2803 | 49 | 0 | 2754 | 29.95079741 | -82.16611613 | 2021-02-20 05:22:51 | Bradford, Florida, US |
1156233 | 1156233 | 2021-02-18 | US | Texas | Hopkins | 48223 | 2531 | 98 | 0 | 2754 | 33.14875072 | -95.56351139 | 2021-02-19 05:24:16 | Hopkins, Texas, US |
3604012 | 3604012 | 2021-02-17 | US | Tennessee | Overton | 47133 | 2864 | 57 | 0 | 2754 | 36.34117832 | -85.28989535 | 2021-02-18 05:22:58 | Overton, Tennessee, US |
3052032 | 3052032 | 2021-02-16 | US | Mississippi | Yazoo | 28163 | 2815 | 61 | 0 | 2754 | 32.77890365 | -90.39656148 | 2021-02-17 05:23:10 | Yazoo, Mississippi, US |
3051919 | 3051919 | 2021-02-16 | US | Minnesota | Pine | 27115 | 2770 | 16 | 0 | 2754 | 46.12105238 | -92.74070188 | 2021-02-17 05:23:10 | Pine, Minnesota, US |
2285772 | 2285772 | 2021-02-14 | US | North Carolina | Person | 37145 | 2813 | 59 | 0 | 2754 | 36.38989032 | -78.97217358 | 2021-02-15 05:24:49 | Person, North Carolina, US |
616684 | 616684 | 2021-02-08 | US | Tennessee | Wayne | 47181 | 2841 | 26 | 0 | 2754 | 35.23868267 | -87.78644456 | 2021-02-09 05:23:30 | Wayne, Tennessee, US |
615490 | 615490 | 2021-02-08 | US | Mississippi | Itawamba | 28057 | 2823 | 69 | 0 | 2754 | 34.27993475 | -88.3606733 | 2021-02-09 05:23:30 | Itawamba, Mississippi, US |
1675836 | 1675836 | 2021-02-07 | US | Virginia | Petersburg | 51730 | 2793 | 39 | 0 | 2754 | 37.20530399 | -77.39368102 | 2021-02-08 05:22:39 | Petersburg, Virginia, US |
341106 | 341106 | 2021-02-03 | US | Georgia | Madison | 13195 | 2791 | 37 | 0 | 2754 | 34.12920917 | -83.21218732 | 2021-02-04 05:22:26 | Madison, Georgia, US |
1687305 | 1687305 | 2021-02-02 | US | South Carolina | Colleton | 45029 | 2842 | 88 | 0 | 2754 | 32.87582989 | -80.67641292 | 2021-02-03 05:22:52 | Colleton, South Carolina, US |
3154629 | 3154629 | 2021-01-27 | US | Illinois | Perry | 17145 | 2808 | 54 | 0 | 2754 | 38.08510853 | -89.36856219 | 2021-01-28 05:22:24 | Perry, Illinois, US |
14278 | 14278 | 2021-01-26 | US | Missouri | Phelps | 29161 | 2861 | 107 | 0 | 2754 | 37.87736118 | -91.79351727 | 2021-01-27 05:23:41 | Phelps, Missouri, US |
1760185 | 1760185 | 2021-01-24 | US | Georgia | Wayne | 13305 | 2813 | 59 | 0 | 2754 | 31.5521809 | -81.91894878 | 2021-01-25 05:22:16 | Wayne, Georgia, US |
2469070 | 2469070 | 2021-01-22 | US | New York | Tompkins | 36109 | 2779 | 25 | 0 | 2754 | 42.44945765 | -76.47229843 | 2021-01-23 05:22:03 | Tompkins, New York, US |
3517719 | 3517719 | 2021-01-15 | US | North Carolina | Haywood | 37087 | 2829 | 75 | 0 | 2754 | 35.55269063 | -82.98196486 | 2021-01-16 05:22:40 | Haywood, North Carolina, US |
3516801 | 3516801 | 2021-01-15 | US | Kentucky | Greenup | 21089 | 2775 | 21 | 0 | 2754 | 38.54332505 | -82.9215658 | 2021-01-16 05:22:40 | Greenup, Kentucky, US |
3881289 | 3881289 | 2021-01-14 | US | Minnesota | Isanti | 27059 | 2794 | 40 | 0 | 2754 | 45.56181234 | -93.29487636 | 2021-01-15 05:22:24 | Isanti, Minnesota, US |
2627686 | 2627686 | 2021-01-10 | US | Mississippi | Lincoln | 28085 | 2835 | 81 | 0 | 2754 | 31.53288662 | -90.45391915 | 2021-01-11 05:21:50 | Lincoln, Mississippi, US |
2229950 | 2229950 | 2021-01-02 | US | Ohio | Ashland | 39005 | 2825 | 71 | 0 | 2754 | 40.84772277 | -82.27280781 | 2021-01-03 05:22:52 | Ashland, Ohio, US |
2229055 | 2229055 | 2021-01-02 | US | Louisiana | Webster | 22119 | 2822 | 68 | 0 | 2754 | 32.70847669 | -93.33121835 | 2021-01-03 05:22:52 | Webster, Louisiana, US |
1139529 | 1139529 | 2021-01-01 | US | Pennsylvania | Carbon | 42025 | 2844 | 90 | 0 | 2754 | 40.91545395 | -75.7068525 | 2021-01-02 05:22:33 | Carbon, Pennsylvania, US |
1138419 | 1138419 | 2021-01-01 | US | Louisiana | Webster | 22119 | 2822 | 68 | 0 | 2754 | 32.70847669 | -93.33121835 | 2021-01-02 05:22:33 | Webster, Louisiana, US |
3697025 | 3697025 | 2020-12-31 | US | Louisiana | Webster | 22119 | 2822 | 68 | 0 | 2754 | 32.70847669 | -93.33121835 | 2021-01-01 05:23:07 | Webster, Louisiana, US |
2223865 | 2223865 | 2020-12-26 | US | Alabama | Covington | 1039 | 2792 | 38 | 0 | 2754 | 31.2477854 | -86.45050893 | 2020-12-27 05:22:55 | Covington, Alabama, US |
203913 | 203913 | 2020-12-25 | US | Michigan | Montcalm | 26117 | 2813 | 59 | 0 | 2754 | 43.31082541 | -85.15252824 | 2020-12-26 05:22:28 | Montcalm, Michigan, US |
3693136 | 3693136 | 2020-12-24 | US | Michigan | Montcalm | 26117 | 2813 | 59 | 0 | 2754 | 43.31082541 | -85.15252824 | 2020-12-25 05:22:48 | Montcalm, Michigan, US |
3691679 | 3691679 | 2020-12-24 | Russia | Kaliningrad Oblast | 16289 | 161 | 13374 | 2754 | 54.7293041 | 21.1489473 | 2020-12-25 05:22:48 | Kaliningrad Oblast, Russia | ||
2408488 | 2408488 | 2020-12-23 | US | Michigan | Montcalm | 26117 | 2813 | 59 | 0 | 2754 | 43.31082541 | -85.15252824 | 2020-12-24 05:23:04 | Montcalm, Michigan, US |
2407899 | 2407899 | 2020-12-23 | US | Indiana | DeKalb | 18033 | 2813 | 59 | 0 | 2754 | 41.39804622 | -84.99906934 | 2020-12-24 05:23:04 | DeKalb, Indiana, US |
3772311 | 3772311 | 2020-12-22 | US | Ohio | Belmont | 39013 | 2834 | 80 | 0 | 2754 | 40.01625942 | -80.9924051 | 2020-12-23 05:22:03 | Belmont, Ohio, US |
2121543 | 2121543 | 2020-12-20 | US | Mississippi | Pontotoc | 28115 | 2789 | 35 | 0 | 2754 | 34.226046000000004 | -89.03636807 | 2020-12-21 05:27:58 | Pontotoc, Mississippi, US |
2129725 | 2129725 | 2020-12-17 | US | Minnesota | Morrison | 27097 | 2790 | 36 | 0 | 2754 | 46.01265363 | -94.27341528 | 2020-12-18 05:28:18 | Morrison, Minnesota, US |
845787 | 845787 | 2020-12-12 | Russia | Leningrad Oblast | 19516 | 172 | 16590 | 2754 | 60.1853296 | 32.3925325 | 2020-12-13 05:27:20 | Leningrad Oblast, Russia | ||
2977647 | 2977647 | 2020-12-09 | US | North Dakota | Stutsman | 38093 | 2813 | 59 | 0 | 2754 | 46.97962541 | -98.95637318 | 2020-12-10 05:26:19 | Stutsman, North Dakota, US |
2347610 | 2347610 | 2020-12-07 | Russia | Bashkortostan Republic | 15265 | 92 | 12419 | 2754 | 54.8573563 | 57.1439682 | 2020-12-08 05:27:42 | Bashkortostan Republic, Russia | ||
78049 | 78049 | 2020-12-03 | US | Tennessee | McMinn | 47107 | 2846 | 56 | 0 | 2754 | 35.42812616 | -84.61520715 | 2020-12-04 05:27:27 | McMinn, Tennessee, US |
76730 | 76730 | 2020-12-03 | US | Michigan | Lapeer | 26087 | 2815 | 61 | 0 | 2754 | 43.09052506 | -83.22153148 | 2020-12-04 05:27:27 | Lapeer, Michigan, US |
739022 | 739022 | 2020-12-02 | US | Florida | Putnam | 12107 | 2814 | 60 | 0 | 2754 | 29.60779729 | -81.74230285 | 2020-12-03 05:28:22 | Putnam, Florida, US |
680667 | 680667 | 2020-11-23 | US | North Carolina | Stanly | 37167 | 2832 | 78 | 0 | 2754 | 35.31647813 | -80.25093221 | 2020-11-24 05:27:31 | Stanly, North Carolina, US |
3190190 | 3190190 | 2020-11-22 | Russia | Kaluga Oblast | 14858 | 105 | 11999 | 2754 | 54.4382773 | 35.5272854 | 2020-11-23 05:25:26 | Kaluga Oblast, Russia | ||
3837037 | 3837037 | 2020-11-21 | US | California | Napa | 6055 | 2773 | 17 | 0 | 2754 | 38.50735751 | -122.332839 | 2020-11-22 05:25:45 | Napa, California, US |
123873 | 123873 | 2020-11-18 | US | Iowa | Clinton | 19045 | 2791 | 37 | 0 | 2754 | 41.89981633 | -90.53275096 | 2020-11-19 05:25:23 | Clinton, Iowa, US |
3169587 | 3169587 | 2020-11-16 | India | Jharkhand | 106230 | 928 | 102548 | 2754 | 23.654536 | 85.557631 | 2020-11-17 05:25:54 | Jharkhand, India | ||
2881941 | 2881941 | 2020-11-15 | US | Minnesota | Nobles | 27105 | 2779 | 25 | 0 | 2754 | 43.67434621 | -95.75329576 | 2020-11-16 05:25:57 | Nobles, Minnesota, US |
3442449 | 3442449 | 2020-11-11 | US | Michigan | Jackson | 26075 | 2835 | 81 | 0 | 2754 | 42.24807035 | -84.42258681 | 2020-11-12 05:25:55 | Jackson, Michigan, US |
1544187 | 1544187 | 2020-11-07 | Russia | Smolensk Oblast | 9593 | 243 | 6596 | 2754 | 55.03434960000001 | 33.0192065 | 2020-11-08 05:24:56 | Smolensk Oblast, Russia | ||
1177941 | 1177941 | 2020-10-22 | US | Arizona | Yavapai | 4025 | 2841 | 87 | 0 | 2754 | 34.59933926 | -112.5538588 | 2020-10-23 04:24:46 | Yavapai, Arizona, US |
81681 | 81681 | 2020-10-14 | US | Oregon | Clackamas | 41005 | 2819 | 65 | 0 | 2754 | 45.18787398 | -122.2179634 | 2020-10-15 04:24:28 | Clackamas, Oregon, US |
2602287 | 2602287 | 2020-10-10 | Russia | Ulyanovsk Oblast | 16902 | 175 | 13973 | 2754 | 54.1463177 | 47.2324921 | 2020-10-11 04:23:46 | Ulyanovsk Oblast, Russia | ||
3802768 | 3802768 | 2020-10-05 | US | Georgia | Troup | 13285 | 2855 | 101 | 0 | 2754 | 33.03349196 | -85.02812115 | 2020-10-06 04:23:33 | Troup, Georgia, US |
3316743 | 3316743 | 2020-09-22 | US | California | Butte | 6007 | 2827 | 43 | 0 | 2754 | 39.66727762 | -121.6005252 | 2020-09-23 04:23:00 | Butte, California, US |
2455213 | 2455213 | 2020-09-19 | US | Arizona | Santa Cruz | 4023 | 2816 | 62 | 0 | 2754 | 31.52508998 | -110.8479088 | 2020-09-20 04:22:00 | Santa Cruz, Arizona, US |
1173099 | 1173099 | 2020-09-10 | Germany | Nordrhein-Westfalen | 61201 | 1827 | 56620 | 2754 | 51.4332 | 7.6616 | 2020-09-11 04:46:23 | Nordrhein-Westfalen, Germany | ||
193783 | 193783 | 2020-08-31 | Australia | Victoria | 19138 | 570 | 15814 | 2754 | -37.8136 | 144.9631 | 2020-09-01 04:28:31 | Victoria, Australia | ||
612507 | 612507 | 2020-08-29 | US | South Carolina | Sumter | 45085 | 2818 | 64 | 0 | 2754 | 33.91826534 | -80.37942316 | 2020-08-30 04:28:22 | Sumter, South Carolina, US |
2511944 | 2511944 | 2020-08-27 | US | Minnesota | Washington | 27163 | 2808 | 54 | 0 | 2754 | 45.03864533 | -92.88429635 | 2020-08-28 04:28:11 | Washington, Minnesota, US |
1997205 | 1997205 | 2020-08-26 | US | California | San Luis Obispo | 6079 | 2774 | 20 | 0 | 2754 | 35.38822029 | -120.4039028 | 2020-08-27 04:28:15 | San Luis Obispo, California, US |
2991563 | 2991563 | 2020-08-24 | Spain | Galicia | 12590 | 632 | 9204 | 2754 | 42.5751 | -8.1339 | 2020-08-25 04:28:02 | Galicia, Spain | ||
1612338 | 1612338 | 2020-08-14 | Mexico | Nuevo Leon | 23411 | 1726 | 18931 | 2754 | 25.5922 | -99.9962 | 2020-08-15 04:27:31 | Nuevo Leon, Mexico | ||
3922632 | 3922632 | 2020-08-09 | US | Georgia | Unassigned | 90013 | 2763 | 9 | 0 | 2754 | 34.91369188 | 0.0 | 2020-08-10 04:34:55 | Unassigned, Georgia, US |
3264213 | 3264213 | 2020-07-31 | US | Texas | Walker | 48471 | 3060 | 38 | 0 | 2754 | 30.73872995 | -95.57440968 | 2020-08-01 04:36:27 | Walker, Texas, US |
3263080 | 3263080 | 2020-07-31 | US | Illinois | McHenry | 17111 | 2866 | 112 | 0 | 2754 | 42.32451172 | -88.45248227 | 2020-08-01 04:36:27 | McHenry, Illinois, US |
2561339 | 2561339 | 2020-07-24 | US | New Jersey | Gloucester | 34015 | 2956 | 202 | 0 | 2754 | 39.71581067 | -75.13995546 | 2020-07-25 04:47:39 | Gloucester, New Jersey, US |
3489273 | 3489273 | 2020-07-13 | US | Maryland | Howard | 24027 | 2850 | 96 | 0 | 2754 | 39.25305293 | -76.93126208 | 2020-07-14 04:34:46 | Howard, Maryland, US |
413681 | 413681 | 2020-07-05 | US | Pennsylvania | Luzerne | 42079 | 2932 | 178 | 0 | 2754 | 41.17823008 | -75.98447579 | 2020-07-06 04:33:57 | Luzerne, Pennsylvania, US |
1281211 | 1281211 | 2020-06-04 | Italy | Lazio | 7764 | 750 | 4260 | 2754 | 41.89277044 | 12.48366722 | 2020-06-05 02:33:06 | Lazio, Italy |
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]);