johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where active = 2415 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2590264 | 2590264 | 2021-06-27 | Russia | Vologda Oblast | 47650 | 1155 | 44080 | 2415 | 60.0391461 | 43.1215213 | 2021-06-28 04:21:29 | Vologda Oblast, Russia | ||
562816 | 562816 | 2021-06-22 | Colombia | Huila | 67617 | 2278 | 62924 | 2415 | 2.5359 | -75.5277 | 2021-06-23 04:21:46 | Huila, Colombia | ||
107667 | 107667 | 2021-06-19 | Russia | Kostroma Oblast | 22273 | 503 | 19355 | 2415 | 58.424756 | 44.2533273 | 2021-06-20 04:21:48 | Kostroma Oblast, Russia | ||
1129217 | 1129217 | 2021-06-18 | Ukraine | Dnipropetrovsk Oblast | 135195 | 4390 | 128390 | 2415 | 48.4647 | 35.0462 | 2021-06-19 04:22:33 | Dnipropetrovsk Oblast, Ukraine | ||
1736284 | 1736284 | 2021-06-12 | Canada | Quebec | 373283 | 11170 | 359698 | 2415 | 52.9399 | -73.5491 | 2021-06-13 04:22:44 | Quebec, Canada | ||
1309896 | 1309896 | 2021-05-26 | Botswana | 52865 | 809 | 49641 | 2415 | -22.3285 | 24.6849 | 2021-05-27 04:20:59 | Botswana | |||
82822 | 82822 | 2021-05-25 | Botswana | 52865 | 809 | 49641 | 2415 | -22.3285 | 24.6849 | 2021-05-26 04:20:35 | Botswana | |||
1412784 | 1412784 | 2021-05-24 | Botswana | 52865 | 809 | 49641 | 2415 | -22.3285 | 24.6849 | 2021-05-25 04:21:08 | Botswana | |||
2359680 | 2359680 | 2021-03-08 | Russia | Kostroma Oblast | 18730 | 357 | 15958 | 2415 | 58.424756 | 44.2533273 | 2021-03-09 05:28:19 | Kostroma Oblast, Russia | ||
58431 | 58431 | 2021-03-07 | Ukraine | Kirovohrad Oblast | 10997 | 386 | 8196 | 2415 | 48.5079 | 32.2623 | 2021-03-08 05:24:48 | Kirovohrad Oblast, Ukraine | ||
1619583 | 1619583 | 2021-03-05 | US | Virginia | Halifax | 51083 | 2479 | 64 | 0 | 2415 | 36.76654925 | -78.93512622 | 2021-03-06 04:23:41 | Halifax, Virginia, US |
1091864 | 1091864 | 2021-03-03 | US | Mississippi | Covington | 28031 | 2495 | 80 | 0 | 2415 | 31.63225413 | -89.55389939 | 2021-03-04 05:24:24 | Covington, Mississippi, US |
3254078 | 3254078 | 2021-03-02 | Haiti | 12554 | 250 | 9828 | 2415 | 18.9712 | -72.2852 | 2021-03-03 05:23:28 | Haiti | |||
1859430 | 1859430 | 2021-02-25 | US | Kentucky | Logan | 21141 | 2466 | 51 | 0 | 2415 | 36.85949479 | -86.877635 | 2021-02-26 05:22:40 | Logan, Kentucky, US |
532525 | 532525 | 2021-02-22 | US | Mississippi | Marion | 28091 | 2493 | 78 | 0 | 2415 | 31.23132643 | -89.8209217 | 2021-02-23 05:23:41 | Marion, Mississippi, US |
183859 | 183859 | 2021-02-21 | US | Mississippi | Marion | 28091 | 2493 | 78 | 0 | 2415 | 31.23132643 | -89.8209217 | 2021-02-22 05:24:21 | Marion, Mississippi, US |
744133 | 744133 | 2021-02-20 | US | Mississippi | Marion | 28091 | 2493 | 78 | 0 | 2415 | 31.23132643 | -89.8209217 | 2021-02-21 05:24:33 | Marion, Mississippi, US |
3602033 | 3602033 | 2021-02-17 | US | Illinois | Jersey | 17083 | 2459 | 44 | 0 | 2415 | 39.08869046 | -90.35393073 | 2021-02-18 05:22:58 | Jersey, Illinois, US |
2284189 | 2284189 | 2021-02-14 | US | Georgia | Chattooga | 13055 | 2475 | 60 | 0 | 2415 | 34.47197698 | -85.34535662 | 2021-02-15 05:24:49 | Chattooga, Georgia, US |
613959 | 613959 | 2021-02-08 | Saudi Arabia | 370634 | 6406 | 361813 | 2415 | 23.885942 | 45.079162 | 2021-02-09 05:23:30 | Saudi Arabia | |||
978204 | 978204 | 2021-02-06 | US | Virginia | Accomack | 51001 | 2448 | 33 | 0 | 2415 | 37.76707161 | -75.63234615 | 2021-02-07 05:23:00 | Accomack, Virginia, US |
1900214 | 1900214 | 2021-01-29 | US | Texas | Deaf Smith | 48117 | 2320 | 61 | 0 | 2415 | 34.96522957 | -102.6054267 | 2021-01-30 05:22:49 | Deaf Smith, Texas, US |
2485030 | 2485030 | 2021-01-28 | US | Texas | Deaf Smith | 48117 | 2320 | 61 | 0 | 2415 | 34.96522957 | -102.6054267 | 2021-01-29 05:22:23 | Deaf Smith, Texas, US |
3154676 | 3154676 | 2021-01-27 | US | Indiana | Decatur | 18031 | 2502 | 87 | 0 | 2415 | 39.30712658 | -85.50087166 | 2021-01-28 05:22:24 | Decatur, Indiana, US |
2569079 | 2569079 | 2021-01-25 | US | Kentucky | Knox | 21121 | 2425 | 10 | 0 | 2415 | 36.89225732 | -83.85403396 | 2021-01-26 05:22:02 | Knox, Kentucky, US |
435896 | 435896 | 2021-01-21 | US | California | Humboldt | 6023 | 2438 | 23 | 0 | 2415 | 40.69923009 | -123.876044 | 2021-01-22 05:22:10 | Humboldt, California, US |
910792 | 910792 | 2021-01-19 | US | Oregon | Klamath | 41035 | 2453 | 38 | 0 | 2415 | 42.68762984 | -121.64964609999998 | 2021-01-20 05:21:54 | Klamath, Oregon, US |
239864 | 239864 | 2021-01-18 | US | Oregon | Polk | 41053 | 2455 | 40 | 0 | 2415 | 44.90322804 | -123.4128888 | 2021-01-19 05:22:15 | Polk, Oregon, US |
238071 | 238071 | 2021-01-18 | US | Georgia | Madison | 13195 | 2444 | 29 | 0 | 2415 | 34.12920917 | -83.21218732 | 2021-01-19 05:22:15 | Madison, Georgia, US |
3311434 | 3311434 | 2021-01-13 | US | Texas | Uvalde | 48463 | 2567 | 46 | 0 | 2415 | 29.35739637 | -99.76229172 | 2021-01-14 05:22:32 | Uvalde, Texas, US |
3310232 | 3310232 | 2021-01-13 | US | Nebraska | Adams | 31001 | 2451 | 36 | 0 | 2415 | 40.52449420000001 | -98.50117804 | 2021-01-14 05:22:32 | Adams, Nebraska, US |
192840 | 192840 | 2021-01-11 | US | Puerto Rico | Toa Baja | 72137 | 2415 | 0 | 0 | 2415 | 18.431446 | -66.213553 | 2021-01-12 05:22:15 | Toa Baja, Puerto Rico, US |
2866208 | 2866208 | 2021-01-06 | US | Louisiana | East Feliciana | 22037 | 2510 | 95 | 0 | 2415 | 30.84425359 | -91.04976723 | 2021-01-07 05:22:03 | East Feliciana, Louisiana, US |
2865876 | 2865876 | 2021-01-06 | US | Iowa | Carroll | 19027 | 2446 | 31 | 0 | 2415 | 42.03617207 | -94.86032705 | 2021-01-07 05:22:03 | Carroll, Iowa, US |
3780130 | 3780130 | 2020-12-27 | US | New York | Genesee | 36037 | 2455 | 40 | 0 | 2415 | 43.0022601 | -78.19135193 | 2020-12-28 05:22:06 | Genesee, New York, US |
3779426 | 3779426 | 2020-12-27 | US | Louisiana | St. John the Baptist | 22095 | 2533 | 118 | 0 | 2415 | 30.12597499 | -90.4753503 | 2020-12-28 05:22:06 | St. John the Baptist, Louisiana, US |
2224699 | 2224699 | 2020-12-26 | US | Iowa | Henry | 19087 | 2439 | 24 | 0 | 2415 | 40.98767962 | -91.54436349 | 2020-12-27 05:22:55 | Henry, Iowa, US |
204901 | 204901 | 2020-12-25 | US | Pennsylvania | Carbon | 42025 | 2504 | 89 | 0 | 2415 | 40.91545395 | -75.7068525 | 2020-12-26 05:22:28 | Carbon, Pennsylvania, US |
2406866 | 2406866 | 2020-12-23 | Japan | Saitama | 12212 | 186 | 9611 | 2415 | 35.997101 | 139.347635 | 2020-12-24 05:23:04 | Saitama, Japan | ||
929450 | 929450 | 2020-12-21 | US | Minnesota | Steele | 27147 | 2424 | 9 | 0 | 2415 | 44.02240351 | -93.22627088 | 2020-12-22 05:22:33 | Steele, Minnesota, US |
3152533 | 3152533 | 2020-12-16 | US | Tennessee | Henderson | 47077 | 2494 | 38 | 0 | 2415 | 35.65581134 | -88.38600175 | 2020-12-17 05:28:12 | Henderson, Tennessee, US |
846638 | 846638 | 2020-12-12 | US | Indiana | DeKalb | 18033 | 2463 | 48 | 0 | 2415 | 41.39804622 | -84.99906934 | 2020-12-13 05:27:20 | DeKalb, Indiana, US |
2537135 | 2537135 | 2020-12-01 | Brazil | Mato Grosso | 159726 | 4152 | 152392 | 2415 | -12.6819 | -56.9211 | 2020-12-02 05:27:41 | Mato Grosso, Brazil | ||
1587739 | 1587739 | 2020-11-30 | US | Wisconsin | Trempealeau | 55121 | 2430 | 15 | 0 | 2415 | 44.30360275 | -91.35893614 | 2020-12-01 05:26:18 | Trempealeau, Wisconsin, US |
2938049 | 2938049 | 2020-11-28 | US | South Carolina | Laurens | 45059 | 2482 | 67 | 0 | 2415 | 34.48244419 | -82.00490796 | 2020-11-29 05:25:55 | Laurens, South Carolina, US |
2937663 | 2937663 | 2020-11-28 | US | Ohio | Ashtabula | 39007 | 2473 | 58 | 0 | 2415 | 41.70860332 | -80.74830218 | 2020-11-29 05:25:55 | Ashtabula, Ohio, US |
395747 | 395747 | 2020-11-27 | US | West Virginia | Wood | 54107 | 2432 | 17 | 0 | 2415 | 39.20967886 | -81.5162836 | 2020-11-28 05:25:50 | Wood, West Virginia, US |
1973824 | 1973824 | 2020-11-25 | US | Iowa | Wapello | 19179 | 2486 | 71 | 0 | 2415 | 41.03064984 | -92.40954728 | 2020-11-26 05:27:44 | Wapello, Iowa, US |
678678 | 678678 | 2020-11-23 | US | Alabama | Franklin | 1059 | 2448 | 33 | 0 | 2415 | 34.44235334 | -87.84289505 | 2020-11-24 05:27:31 | Franklin, Alabama, US |
3190969 | 3190969 | 2020-11-22 | US | Illinois | Grundy | 17063 | 2426 | 11 | 0 | 2415 | 41.28569601 | -88.41905692 | 2020-11-23 05:25:26 | Grundy, Illinois, US |
126043 | 126043 | 2020-11-18 | US | Virginia | Hampton | 51650 | 2449 | 34 | 0 | 2415 | 37.03513786 | -76.35879121 | 2020-11-19 05:25:23 | Hampton, Virginia, US |
3341509 | 3341509 | 2020-11-17 | US | Tennessee | Coffee | 47031 | 2465 | 36 | 0 | 2415 | 35.49090731 | -86.07311784 | 2020-11-18 05:40:31 | Coffee, Tennessee, US |
2881308 | 2881308 | 2020-11-15 | US | Indiana | Marshall | 18099 | 2452 | 37 | 0 | 2415 | 41.32467367 | -86.26185087 | 2020-11-16 05:25:57 | Marshall, Indiana, US |
272196 | 272196 | 2020-11-10 | Japan | Tokyo | 33059 | 465 | 30179 | 2415 | 35.711343 | 139.446921 | 2020-11-11 05:25:30 | Tokyo, Japan | ||
1730118 | 1730118 | 2020-11-08 | US | Michigan | Jackson | 26075 | 2493 | 78 | 0 | 2415 | 42.24807035 | -84.42258681 | 2020-11-09 05:25:45 | Jackson, Michigan, US |
1545578 | 1545578 | 2020-11-07 | US | Michigan | Jackson | 26075 | 2493 | 78 | 0 | 2415 | 42.24807035 | -84.42258681 | 2020-11-08 05:24:56 | Jackson, Michigan, US |
1543923 | 1543923 | 2020-11-07 | Italy | Basilicata | 3277 | 63 | 799 | 2415 | 40.63947052 | 15.80514834 | 2020-11-08 05:24:56 | Basilicata, Italy | ||
2080743 | 2080743 | 2020-10-31 | US | Georgia | Jackson | 13157 | 2457 | 42 | 0 | 2415 | 34.13794553 | -83.56814788 | 2020-11-01 04:36:19 | Jackson, Georgia, US |
754777 | 754777 | 2020-10-28 | US | Arkansas | Garland | 5051 | 2481 | 66 | 0 | 2415 | 34.57692074 | -93.14921604 | 2020-10-29 04:24:49 | Garland, Arkansas, US |
1455124 | 1455124 | 2020-10-27 | US | Oklahoma | Garfield | 40047 | 2443 | 28 | 0 | 2415 | 36.3791334 | -97.78265517 | 2020-10-28 04:24:39 | Garfield, Oklahoma, US |
1056632 | 1056632 | 2020-10-23 | US | South Carolina | Greenwood | 45047 | 2489 | 74 | 0 | 2415 | 34.15272415 | -82.12715789 | 2020-10-24 04:24:46 | Greenwood, South Carolina, US |
2604398 | 2604398 | 2020-10-10 | US | North Carolina | Wilson | 37195 | 2473 | 58 | 0 | 2415 | 35.70625477 | -77.917978 | 2020-10-11 04:23:46 | Wilson, North Carolina, US |
3390329 | 3390329 | 2020-10-02 | US | Idaho | Twin Falls | 16083 | 2453 | 38 | 0 | 2415 | 42.35440512 | -114.6685381 | 2020-10-03 04:23:40 | Twin Falls, Idaho, US |
2816310 | 2816310 | 2020-09-25 | US | Wisconsin | Rock | 55105 | 2447 | 32 | 0 | 2415 | 42.67151616 | -89.071479 | 2020-09-26 04:23:00 | Rock, Wisconsin, US |
2656479 | 2656479 | 2020-09-23 | US | Puerto Rico | Carolina | 72031 | 2415 | 0 | 0 | 2415 | 18.374986 | -65.956831 | 2020-09-24 04:23:00 | Carolina, Puerto Rico, US |
2510022 | 2510022 | 2020-08-27 | Colombia | Bolivar | 24685 | 692 | 21578 | 2415 | 8.6704 | -74.03 | 2020-08-28 04:28:11 | Bolivar, Colombia | ||
2993550 | 2993550 | 2020-08-24 | US | North Carolina | Catawba | 37035 | 2454 | 39 | 0 | 2415 | 35.66211129 | -81.2132617 | 2020-08-25 04:28:02 | Catawba, North Carolina, US |
2215747 | 2215747 | 2020-08-23 | Mexico | Coahuila | 19874 | 1236 | 16223 | 2415 | 27.0587 | -101.7068 | 2020-08-24 04:27:56 | Coahuila, Mexico | ||
1557762 | 1557762 | 2020-08-16 | US | Mississippi | Jackson | 28059 | 2462 | 47 | 0 | 2415 | 30.54020656 | -88.64184064 | 2020-08-17 04:27:20 | Jackson, Mississippi, US |
2956790 | 2956790 | 2020-07-29 | US | Louisiana | Livingston | 22063 | 2463 | 48 | 0 | 2415 | 30.44143993 | -90.73061664 | 2020-07-30 04:35:05 | Livingston, Louisiana, US |
3182029 | 3182029 | 2020-07-28 | US | Ohio | Butler | 39017 | 2476 | 61 | 0 | 2415 | 39.44012838 | -84.57388716 | 2020-07-29 04:35:11 | Butler, Ohio, US |
121126 | 121126 | 2020-07-19 | US | Florida | St. Johns | 12109 | 2431 | 16 | 0 | 2415 | 29.90096506 | -81.43589967 | 2020-07-20 05:34:40 | St. Johns, Florida, US |
3205635 | 3205635 | 2020-07-18 | Greece | 3983 | 194 | 1374 | 2415 | 39.0742 | 21.8243 | 2020-07-19 04:34:58 | Greece | |||
2707798 | 2707798 | 2020-07-17 | US | California | Solano | 6095 | 2439 | 26 | 0 | 2415 | 38.26827353 | -121.9357113 | 2020-07-18 04:34:45 | Solano, California, US |
887302 | 887302 | 2020-07-07 | India | Kerala | 5894 | 27 | 3452 | 2415 | 10.450898 | 76.405749 | 2020-07-08 05:33:48 | Kerala, India | ||
303277 | 303277 | 2020-07-01 | Peru | Tumbes | 2849 | 434 | 0 | 2415 | -3.857496 | -80.54525500000003 | 2020-07-02 04:33:46 | Tumbes, Peru | ||
2863717 | 2863717 | 2020-06-10 | Chile | Araucania | 2448 | 33 | 0 | 2415 | -38.9489 | -72.3311 | 2020-06-11 03:33:41 | Araucania, Chile | ||
1210733 | 1210733 | 2020-06-09 | Russia | Kaluga Oblast | 4691 | 36 | 2240 | 2415 | 54.438277299999996 | 35.5272854 | 2020-06-10 04:07:00 | Kaluga Oblast, Russia | ||
1931392 | 1931392 | 2020-05-05 | US | Delaware | Sussex | 10005 | 2520 | 105 | 0 | 2415 | 38.66143781 | -75.39031349 | 2020-05-06 02:32:31 | Sussex, Delaware, 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]);