johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where active = 3666 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2422860 | 2422860 | 2021-06-23 | India | Uttar Pradesh | 1704790 | 22336 | 1678788 | 3666 | 26.925425 | 80.560982 | 2021-06-24 04:21:55 | Uttar Pradesh, India | ||
2575362 | 2575362 | 2021-04-13 | Malaysia | Sarawak | 20959 | 128 | 17165 | 3666 | 1.5533 | 110.3592 | 2021-04-14 04:20:41 | Sarawak, Malaysia | ||
1798866 | 1798866 | 2021-03-23 | Russia | Nizhny Novgorod Oblast | 105002 | 2758 | 98578 | 3666 | 55.47180329999999 | 44.0911594 | 2021-03-24 05:25:40 | Nizhny Novgorod Oblast, Russia | ||
1618066 | 1618066 | 2021-03-05 | US | Mississippi | Neshoba | 28099 | 3836 | 170 | 0 | 3666 | 32.75339664 | -89.11726492 | 2021-03-06 04:23:41 | Neshoba, Mississippi, US |
1617790 | 1617790 | 2021-03-05 | US | Maine | Kennebec | 23011 | 3717 | 51 | 0 | 3666 | 44.40759555 | -69.76738544 | 2021-03-06 04:23:41 | Kennebec, Maine, US |
1093404 | 1093404 | 2021-03-03 | US | Virginia | Franklin | 51067 | 3723 | 57 | 0 | 3666 | 36.99536167 | -79.88023649 | 2021-03-04 05:24:24 | Franklin, Virginia, US |
1093276 | 1093276 | 2021-03-03 | US | Texas | Rusk | 48401 | 4051 | 96 | 0 | 3666 | 32.10773545 | -94.76176432 | 2021-03-04 05:24:24 | Rusk, Texas, US |
1001879 | 1001879 | 2021-03-01 | US | Washington | Lewis | 53041 | 3716 | 50 | 0 | 3666 | 46.57756476 | -122.3925769 | 2021-03-02 05:23:30 | Lewis, Washington, US |
999195 | 999195 | 2021-03-01 | US | Georgia | Camden | 13039 | 3697 | 31 | 0 | 3666 | 30.92951916 | -81.66601818 | 2021-03-02 05:23:30 | Camden, Georgia, US |
2368253 | 2368253 | 2021-02-28 | US | Georgia | Camden | 13039 | 3697 | 31 | 0 | 3666 | 30.92951916 | -81.66601818 | 2021-03-01 05:23:01 | Camden, Georgia, US |
3066040 | 3066040 | 2021-02-27 | Japan | Tokyo | 111347 | 1370 | 106311 | 3666 | 35.711343 | 139.446921 | 2021-02-28 05:22:20 | Tokyo, Japan | ||
2185193 | 2185193 | 2021-02-26 | US | Michigan | Branch | 26023 | 3752 | 86 | 0 | 3666 | 41.91600556 | -85.05929476 | 2021-02-27 05:22:28 | Branch, Michigan, US |
533345 | 533345 | 2021-02-22 | US | Pennsylvania | Bedford | 42009 | 3794 | 128 | 0 | 3666 | 40.00522157 | -78.48998442 | 2021-02-23 05:23:41 | Bedford, Pennsylvania, US |
181960 | 181960 | 2021-02-21 | Germany | Sachsen-Anhalt | 58480 | 2292 | 52822 | 3666 | 51.9503 | 11.6923 | 2021-02-22 05:24:21 | Sachsen-Anhalt, Germany | ||
1153485 | 1153485 | 2021-02-18 | US | Alabama | Escambia | 1053 | 3726 | 60 | 0 | 3666 | 31.1256789 | -87.15918694 | 2021-02-19 05:24:16 | Escambia, Alabama, US |
2286775 | 2286775 | 2021-02-14 | US | Virginia | James City | 51095 | 3708 | 42 | 0 | 3666 | 37.31156958 | -76.76950618 | 2021-02-15 05:24:49 | James City, Virginia, US |
616602 | 616602 | 2021-02-08 | US | Tennessee | Cheatham | 47021 | 3768 | 38 | 0 | 3666 | 36.26136216 | -87.08903581 | 2021-02-09 05:23:30 | Cheatham, Tennessee, US |
1674167 | 1674167 | 2021-02-07 | US | Minnesota | Goodhue | 27049 | 3730 | 64 | 0 | 3666 | 44.40849741 | -92.7234195 | 2021-02-08 05:22:39 | Goodhue, Minnesota, US |
792590 | 792590 | 2021-02-04 | US | New Mexico | Unassigned | 90035 | 3666 | 0 | 0 | 3666 | 36.60569702 | -108.7151824 | 2021-02-05 05:22:38 | Unassigned, New Mexico, US |
1900191 | 1900191 | 2021-01-29 | US | Texas | Cherokee | 48073 | 2933 | 103 | 0 | 3666 | 31.837258 | -95.16559897 | 2021-01-30 05:22:49 | Cherokee, Texas, US |
437187 | 437187 | 2021-01-21 | US | Mississippi | Pontotoc | 28115 | 3721 | 55 | 0 | 3666 | 34.226046000000004 | -89.03636807 | 2021-01-22 05:22:10 | Pontotoc, Mississippi, US |
1097467 | 1097467 | 2021-01-20 | US | Virginia | Pittsylvania | 51143 | 3708 | 42 | 0 | 3666 | 36.81980341 | -79.39731264 | 2021-01-21 05:22:01 | Pittsylvania, Virginia, US |
1096521 | 1096521 | 2021-01-20 | US | Ohio | Athens | 39009 | 3707 | 41 | 0 | 3666 | 39.33425634 | -82.04278644 | 2021-01-21 05:22:01 | Athens, Ohio, US |
1095914 | 1095914 | 2021-01-20 | US | Mississippi | Panola | 28107 | 3746 | 80 | 0 | 3666 | 34.36398677 | -89.95064249 | 2021-01-21 05:22:01 | Panola, Mississippi, US |
3882529 | 3882529 | 2021-01-14 | US | Tennessee | Lincoln | 47103 | 3708 | 44 | 0 | 3666 | 35.13738622 | -86.58910106 | 2021-01-15 05:22:24 | Lincoln, Tennessee, US |
3879800 | 3879800 | 2021-01-14 | Russia | Murmansk Oblast | 39496 | 712 | 35118 | 3666 | 68.00004179999999 | 33.9999151 | 2021-01-15 05:22:24 | Murmansk Oblast, Russia | ||
3901176 | 3901176 | 2021-01-09 | US | Iowa | Muscatine | 19139 | 3741 | 75 | 0 | 3666 | 41.48370744 | -91.1121697 | 2021-01-10 05:22:12 | Muscatine, Iowa, US |
2543176 | 2543176 | 2021-01-07 | US | Minnesota | Winona | 27169 | 3711 | 45 | 0 | 3666 | 43.98772283 | -91.78081305 | 2021-01-08 05:22:42 | Winona, Minnesota, US |
2865474 | 2865474 | 2021-01-06 | US | Georgia | Catoosa | 13047 | 3706 | 40 | 0 | 3666 | 34.89872298 | -85.13757014 | 2021-01-07 05:22:03 | Catoosa, Georgia, US |
3034720 | 3034720 | 2021-01-05 | US | Alaska | Kenai Peninsula | 2122 | 3685 | 19 | 0 | 3666 | 60.24429722 | -151.53888840000005 | 2021-01-06 05:22:16 | Kenai Peninsula, Alaska, US |
1063413 | 1063413 | 2021-01-04 | US | Maryland | Cecil | 24015 | 3744 | 78 | 0 | 3666 | 39.56647682 | -75.94627411 | 2021-01-05 05:21:49 | Cecil, Maryland, US |
1138336 | 1138336 | 2021-01-01 | US | Kentucky | Pulaski | 21199 | 3699 | 33 | 0 | 3666 | 37.10466131 | -84.57629079 | 2021-01-02 05:22:33 | Pulaski, Kentucky, US |
1137012 | 1137012 | 2021-01-01 | Netherlands | Unknown | 2402 | 46 | 0 | 3666 | 2021-01-02 05:22:33 | Unknown, Netherlands | ||||
3696942 | 3696942 | 2020-12-31 | US | Kentucky | Pulaski | 21199 | 3699 | 33 | 0 | 3666 | 37.10466131 | -84.57629079 | 2021-01-01 05:23:07 | Pulaski, Kentucky, US |
1011757 | 1011757 | 2020-12-30 | US | Kentucky | Pulaski | 21199 | 3699 | 33 | 0 | 3666 | 37.10466131 | -84.57629079 | 2020-12-31 05:22:49 | Pulaski, Kentucky, US |
2409312 | 2409312 | 2020-12-23 | US | Ohio | Mercer | 39107 | 3743 | 77 | 0 | 3666 | 40.54043046 | -84.62912742 | 2020-12-24 05:23:04 | Mercer, Ohio, US |
2407714 | 2407714 | 2020-12-23 | US | Georgia | Walker | 13295 | 3723 | 57 | 0 | 3666 | 34.73376362 | -85.30165174 | 2020-12-24 05:23:04 | Walker, Georgia, US |
1904718 | 1904718 | 2020-12-18 | US | Wisconsin | Marinette | 55075 | 3705 | 39 | 0 | 3666 | 45.38553432 | -88.03324599999998 | 2020-12-19 05:27:52 | Marinette, Wisconsin, US |
2129928 | 2129928 | 2020-12-17 | US | Missouri | Pettis | 29159 | 3716 | 50 | 0 | 3666 | 38.72798918 | -93.28471706 | 2020-12-18 05:28:18 | Pettis, Missouri, US |
3150118 | 3150118 | 2020-12-16 | US | Arkansas | White | 5145 | 3731 | 65 | 0 | 3666 | 35.25688493 | -91.74908296 | 2020-12-17 05:28:12 | White, Arkansas, US |
861641 | 861641 | 2020-12-11 | US | Illinois | Coles | 17029 | 3731 | 65 | 0 | 3666 | 39.51949084 | -88.22358557 | 2020-12-12 05:26:19 | Coles, Illinois, US |
1587779 | 1587779 | 2020-11-30 | Ukraine | Crimea Republic* | 15372 | 284 | 11422 | 3666 | 45.2835 | 34.2008 | 2020-12-01 05:26:18 | Crimea Republic*, Ukraine | ||
2936462 | 2936462 | 2020-11-28 | US | Iowa | Sioux | 19167 | 3691 | 25 | 0 | 3666 | 43.08221074 | -96.1767568 | 2020-11-29 05:25:55 | Sioux, Iowa, US |
926681 | 926681 | 2020-11-26 | US | Texas | Anderson | 48001 | 3045 | 47 | 0 | 3666 | 31.81534745 | -95.65354823 | 2020-11-27 05:26:53 | Anderson, Texas, US |
1351069 | 1351069 | 2020-11-24 | US | Georgia | Bulloch | 13031 | 3718 | 52 | 0 | 3666 | 32.39577406 | -81.74811421 | 2020-11-25 05:27:20 | Bulloch, Georgia, US |
2880144 | 2880144 | 2020-11-15 | India | Assam | 210268 | 963 | 205639 | 3666 | 26.357149 | 92.830441 | 2020-11-16 05:25:57 | Assam, India | ||
3440700 | 3440700 | 2020-11-11 | El Salvador | 35862 | 1024 | 31172 | 3666 | 13.7942 | -88.8965 | 2020-11-12 05:25:55 | El Salvador | |||
379161 | 379161 | 2020-11-06 | US | Tennessee | Sevier | 47155 | 3682 | 24 | 0 | 3666 | 35.78077323 | -83.52244332 | 2020-11-07 05:24:52 | Sevier, Tennessee, US |
3653956 | 3653956 | 2020-10-24 | US | North Dakota | Grand Forks | 38035 | 3827 | 18 | 0 | 3666 | 47.92093639 | -97.45450447 | 2020-10-25 04:24:36 | Grand Forks, North Dakota, US |
1056324 | 1056324 | 2020-10-23 | US | Ohio | Stark | 39151 | 3853 | 187 | 0 | 3666 | 40.81482476 | -81.36437305 | 2020-10-24 04:24:46 | Stark, Ohio, US |
3802913 | 3802913 | 2020-10-05 | US | Illinois | Peoria | 17143 | 3721 | 55 | 0 | 3666 | 40.78702156 | -89.76078901 | 2020-10-06 04:23:33 | Peoria, Illinois, US |
1045569 | 1045569 | 2020-09-30 | Brazil | Roraima | 50681 | 654 | 46135 | 3666 | -2.7376 | -62.0751 | 2020-10-01 04:23:42 | Roraima, Brazil | ||
969271 | 969271 | 2020-09-29 | US | North Dakota | Burleigh | 38015 | 3776 | 46 | 0 | 3666 | 46.97847375 | -100.4645214 | 2020-09-30 04:23:33 | Burleigh, North Dakota, US |
2836816 | 2836816 | 2020-09-21 | Jamaica | 5143 | 70 | 1407 | 3666 | 18.1096 | -77.2975 | 2020-09-22 04:23:00 | Jamaica | |||
1121902 | 1121902 | 2020-09-17 | Sweden | Ostergotland | 3943 | 277 | 0 | 3666 | 58.3454 | 15.5198 | 2020-09-18 05:05:00 | Ostergotland, Sweden | ||
2174346 | 2174346 | 2020-09-09 | US | South Carolina | Dorchester | 45035 | 3750 | 84 | 0 | 3666 | 33.0794369 | -80.40502652 | 2020-09-10 04:29:01 | Dorchester, South Carolina, US |
196213 | 196213 | 2020-08-31 | US | New Jersey | Atlantic | 34001 | 3917 | 251 | 0 | 3666 | 39.47538693 | -74.65848483 | 2020-09-01 04:28:31 | Atlantic, New Jersey, US |
1612502 | 1612502 | 2020-08-14 | Russia | Volgograd Oblast | 10480 | 77 | 6737 | 3666 | 49.6048339 | 44.29035820000001 | 2020-08-15 04:27:31 | Volgograd Oblast, Russia | ||
665513 | 665513 | 2020-08-11 | US | Texas | Potter | 48375 | 3754 | 45 | 0 | 3666 | 35.40133773 | -101.893964 | 2020-08-12 04:27:29 | Potter, Texas, US |
663389 | 663389 | 2020-08-11 | US | Illinois | Winnebago | 17201 | 3797 | 131 | 0 | 3666 | 42.33641854 | -89.16085327 | 2020-08-12 04:27:29 | Winnebago, Illinois, US |
3611335 | 3611335 | 2020-08-06 | US | Florida | Santa Rosa | 12113 | 3700 | 34 | 0 | 3666 | 30.69341450000001 | -87.02458128 | 2020-08-07 04:35:11 | Santa Rosa, Florida, US |
1926826 | 1926826 | 2020-07-30 | US | California | Merced | 6047 | 3697 | 30 | 0 | 3666 | 37.18922369 | -120.72090349999999 | 2020-07-31 04:35:18 | Merced, California, US |
3060075 | 3060075 | 2020-06-13 | US | Arizona | Pima | 4019 | 3889 | 223 | 0 | 3666 | 32.0971334 | -111.7890033 | 2020-06-14 03:33:15 | Pima, Arizona, US |
1787385 | 1787385 | 2020-05-29 | US | Pennsylvania | Berks | 42011 | 3977 | 311 | 0 | 3666 | 40.41570541 | -75.92457766 | 2020-05-30 02:32:48 | Berks, Pennsylvania, US |
1103974 | 1103974 | 2020-05-25 | US | Iowa | Polk | 19153 | 3774 | 108 | 0 | 3666 | 41.68679484 | -93.57767461 | 2020-05-26 02:32:35 | Polk, Iowa, 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]);