johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where active = 2474 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468051 | 3468051 | 2021-08-03 | Czechia | 1673926 | 30378 | 1641074 | 2474 | 49.8175 | 15.473 | 2021-08-04 04:21:25 | Czechia | |||
1309811 | 1309811 | 2021-07-27 | United Kingdom | Isle of Man | 4189 | 29 | 1686 | 2474 | 54.2361 | -4.5481 | 2021-07-28 04:21:39 | Isle of Man, United Kingdom | ||
3221954 | 3221954 | 2021-07-26 | United Kingdom | Isle of Man | 4189 | 29 | 1686 | 2474 | 54.2361 | -4.5481 | 2021-07-27 04:21:18 | Isle of Man, United Kingdom | ||
3631660 | 3631660 | 2021-07-14 | Austria | 647813 | 13103 | 639154 | 2474 | 47.5162 | 14.5501 | 2021-07-15 04:21:48 | Austria | |||
3702360 | 3702360 | 2021-04-27 | Russia | Tatarstan Republic | 20344 | 458 | 17412 | 2474 | 55.7648572 | 52.43104273 | 2021-04-28 04:20:32 | Tatarstan Republic, Russia | ||
3129781 | 3129781 | 2021-04-18 | Russia | Voronezh Oblast | 78572 | 2554 | 73544 | 2474 | 50.9800393 | 40.15065070000001 | 2021-04-19 04:20:57 | Voronezh Oblast, Russia | ||
2548713 | 2548713 | 2021-04-15 | Colombia | Caldas | 54314 | 1071 | 50769 | 2474 | 5.2983 | -75.2479 | 2021-04-16 04:20:46 | Caldas, Colombia | ||
2211268 | 2211268 | 2021-03-04 | Ukraine | Cherkasy Oblast | 49170 | 642 | 46054 | 2474 | 49.4444 | 32.0598 | 2021-03-05 05:26:29 | Cherkasy Oblast, Ukraine | ||
998285 | 998285 | 2021-03-01 | Colombia | Cundinamarca | 105930 | 2890 | 100566 | 2474 | 5.026 | -74.03 | 2021-03-02 05:23:30 | Cundinamarca, Colombia | ||
2368668 | 2368668 | 2021-02-28 | US | Iowa | Crawford | 19047 | 2509 | 35 | 0 | 2474 | 42.03718237 | -95.3819718 | 2021-03-01 05:23:01 | Crawford, Iowa, US |
2185434 | 2185434 | 2021-02-26 | US | Mississippi | Wayne | 28153 | 2515 | 41 | 0 | 2474 | 31.64135687 | -88.69573913 | 2021-02-27 05:22:28 | Wayne, Mississippi, US |
531851 | 531851 | 2021-02-22 | US | Indiana | Wells | 18179 | 2548 | 74 | 0 | 2474 | 40.72934187 | -85.22132966 | 2021-02-23 05:23:41 | Wells, Indiana, US |
744225 | 744225 | 2021-02-20 | US | Missouri | Lafayette | 29107 | 2527 | 53 | 0 | 2474 | 39.06986886 | -93.78076396 | 2021-02-21 05:24:33 | Lafayette, Missouri, US |
2680314 | 2680314 | 2021-02-13 | US | Ohio | Morrow | 39117 | 2512 | 38 | 0 | 2474 | 40.52363560000001 | -82.7892599 | 2021-02-14 05:23:43 | Morrow, Ohio, US |
1675107 | 1675107 | 2021-02-07 | US | Pennsylvania | Clarion | 42031 | 2550 | 76 | 0 | 2474 | 41.19265812 | -79.42413524 | 2021-02-08 05:22:39 | Clarion, Pennsylvania, US |
1685809 | 1685809 | 2021-02-02 | US | Kansas | Miami | 20121 | 2502 | 28 | 0 | 2474 | 38.56383358 | -94.83832189 | 2021-02-03 05:22:52 | Miami, Kansas, US |
1684744 | 1684744 | 2021-02-02 | Russia | Samara Oblast | 40903 | 830 | 37599 | 2474 | 53.2128813 | 50.8914633 | 2021-02-03 05:22:52 | Samara Oblast, Russia | ||
1677779 | 1677779 | 2021-02-01 | US | Kansas | Miami | 20121 | 2502 | 28 | 0 | 2474 | 38.56383358 | -94.83832189 | 2021-02-02 05:22:49 | Miami, Kansas, US |
3155448 | 3155448 | 2021-01-27 | US | Mississippi | Tippah | 28139 | 2526 | 52 | 0 | 2474 | 34.76872156 | -88.90988194 | 2021-01-28 05:22:24 | Tippah, Mississippi, US |
3154144 | 3154144 | 2021-01-27 | US | California | Glenn | 6021 | 2475 | 14 | 0 | 2474 | 39.59875897 | -122.3938452 | 2021-01-28 05:22:24 | Glenn, California, US |
1759988 | 1759988 | 2021-01-24 | US | Florida | Hardee | 12049 | 2496 | 22 | 0 | 2474 | 27.49293939 | -81.80956574 | 2021-01-25 05:22:16 | Hardee, Florida, US |
2430090 | 2430090 | 2021-01-23 | US | Texas | Polk | 48373 | 2586 | 74 | 0 | 2474 | 30.79472531 | -94.8276624 | 2021-01-24 05:22:35 | Polk, Texas, US |
3103352 | 3103352 | 2021-01-16 | US | Missouri | Lawrence | 29109 | 2534 | 60 | 0 | 2474 | 37.10626634 | -93.83293097 | 2021-01-17 05:22:17 | Lawrence, Missouri, US |
3101985 | 3101985 | 2021-01-16 | US | California | Lake | 6033 | 2504 | 30 | 0 | 2474 | 39.10124298 | -122.7536244 | 2021-01-17 05:22:17 | Lake, California, US |
3515620 | 3515620 | 2021-01-15 | Russia | Leningrad Oblast | 27130 | 318 | 24338 | 2474 | 60.1853296 | 32.3925325 | 2021-01-16 05:22:40 | Leningrad Oblast, Russia | ||
3309226 | 3309226 | 2021-01-13 | US | Illinois | Perry | 17145 | 2526 | 52 | 0 | 2474 | 38.08510853 | -89.36856219 | 2021-01-14 05:22:32 | Perry, Illinois, US |
775508 | 775508 | 2021-01-12 | US | Iowa | Carroll | 19027 | 2507 | 33 | 0 | 2474 | 42.03617207 | -94.86032705 | 2021-01-13 05:22:15 | Carroll, Iowa, US |
775335 | 775335 | 2021-01-12 | US | Illinois | Iroquois | 17075 | 2525 | 51 | 0 | 2474 | 40.74717633 | -87.82466784 | 2021-01-13 05:22:15 | Iroquois, Illinois, US |
3037329 | 3037329 | 2021-01-05 | US | Texas | Caldwell | 48055 | 2985 | 46 | 0 | 2474 | 29.83668859 | -97.61814775 | 2021-01-06 05:22:16 | Caldwell, Texas, US |
1062026 | 1062026 | 2021-01-04 | Qatar | 144644 | 245 | 141925 | 2474 | 25.3548 | 51.1839 | 2021-01-05 05:21:49 | Qatar | |||
3232389 | 3232389 | 2021-01-03 | US | Missouri | Platte | 29165 | 2497 | 23 | 0 | 2474 | 39.38154439 | -94.77068479 | 2021-01-04 05:22:02 | Platte, Missouri, US |
1139720 | 1139720 | 2021-01-01 | US | South Dakota | Beadle | 46005 | 2509 | 35 | 0 | 2474 | 44.41464384 | -98.27858469 | 2021-01-02 05:22:33 | Beadle, South Dakota, US |
3698326 | 3698326 | 2020-12-31 | US | South Dakota | Beadle | 46005 | 2509 | 35 | 0 | 2474 | 44.41464384 | -98.27858469 | 2021-01-01 05:23:07 | Beadle, South Dakota, US |
768133 | 768133 | 2020-12-29 | US | Mississippi | Leflore | 28083 | 2574 | 100 | 0 | 2474 | 33.55545125 | -90.29900733 | 2020-12-30 05:22:34 | Leflore, Mississippi, US |
3781330 | 3781330 | 2020-12-27 | US | Washington | Douglas | 53017 | 2488 | 14 | 0 | 2474 | 47.7361335 | -119.692937 | 2020-12-28 05:22:06 | Douglas, Washington, US |
2226935 | 2226935 | 2020-12-26 | US | Washington | Douglas | 53017 | 2488 | 14 | 0 | 2474 | 47.7361335 | -119.692937 | 2020-12-27 05:22:55 | Douglas, Washington, US |
2409741 | 2409741 | 2020-12-23 | US | Tennessee | Carroll | 47017 | 2532 | 47 | 0 | 2474 | 35.97366108 | -88.45189331 | 2020-12-24 05:23:04 | Carroll, Tennessee, US |
3771569 | 3771569 | 2020-12-22 | US | Minnesota | Carlton | 27017 | 2507 | 33 | 0 | 2474 | 46.59180601 | -92.67601019 | 2020-12-23 05:22:03 | Carlton, Minnesota, US |
1902366 | 1902366 | 2020-12-18 | US | Iowa | Jones | 19105 | 2509 | 35 | 0 | 2474 | 42.12118609 | -91.13139641 | 2020-12-19 05:27:52 | Jones, Iowa, US |
2130630 | 2130630 | 2020-12-17 | US | Pennsylvania | Bedford | 42009 | 2548 | 74 | 0 | 2474 | 40.00522157 | -78.48998442 | 2020-12-18 05:28:18 | Bedford, Pennsylvania, US |
1752363 | 1752363 | 2020-12-14 | US | Indiana | Knox | 18083 | 2530 | 56 | 0 | 2474 | 38.68861576 | -87.4194665 | 2020-12-15 05:26:38 | Knox, Indiana, US |
863991 | 863991 | 2020-12-11 | US | Virginia | Culpeper | 51047 | 2493 | 19 | 0 | 2474 | 38.48199985 | -77.95630870000002 | 2020-12-12 05:26:19 | Culpeper, Virginia, US |
2976246 | 2976246 | 2020-12-09 | US | Illinois | Morgan | 17137 | 2526 | 52 | 0 | 2474 | 39.71654544 | -90.20255104 | 2020-12-10 05:26:19 | Morgan, Illinois, US |
1822244 | 1822244 | 2020-12-08 | US | Washington | Whitman | 53075 | 2494 | 20 | 0 | 2474 | 46.90022523 | -117.5241763 | 2020-12-09 05:28:01 | Whitman, Washington, US |
3566812 | 3566812 | 2020-11-29 | Russia | Stavropol Krai | 27488 | 545 | 24469 | 2474 | 44.86325770000001 | 43.4406913 | 2020-11-30 05:26:13 | Stavropol Krai, Russia | ||
3193671 | 3193671 | 2020-11-22 | Malaysia | Selangor | 9756 | 27 | 7255 | 2474 | 3.0738 | 101.5183 | 2020-11-23 05:25:26 | Selangor, Malaysia | ||
3838170 | 3838170 | 2020-11-21 | US | Minnesota | Benton | 27009 | 2511 | 37 | 0 | 2474 | 45.69804958 | -93.99514135 | 2020-11-22 05:25:45 | Benton, Minnesota, US |
123229 | 123229 | 2020-11-18 | US | Arkansas | White | 5145 | 2518 | 44 | 0 | 2474 | 35.25688493 | -91.74908296 | 2020-11-19 05:25:23 | White, Arkansas, US |
2917517 | 2917517 | 2020-11-14 | US | North Carolina | Moore | 37125 | 2532 | 58 | 0 | 2474 | 35.30885257 | -79.48474178 | 2020-11-15 05:26:53 | Moore, North Carolina, US |
3443256 | 3443256 | 2020-11-11 | US | Ohio | Columbiana | 39029 | 2569 | 95 | 0 | 2474 | 40.76932373 | -80.78094576 | 2020-11-12 05:25:55 | Columbiana, Ohio, US |
2501417 | 2501417 | 2020-11-03 | US | Virginia | Spotsylvania | 51177 | 2529 | 55 | 0 | 2474 | 38.18574462 | -77.655399 | 2020-11-04 05:25:09 | Spotsylvania, Virginia, US |
3411100 | 3411100 | 2020-11-01 | US | Michigan | Muskegon | 26121 | 2558 | 84 | 0 | 2474 | 43.29123859 | -86.15176712 | 2020-11-02 05:25:04 | Muskegon, Michigan, US |
2081589 | 2081589 | 2020-10-31 | US | Michigan | Muskegon | 26121 | 2558 | 84 | 0 | 2474 | 43.29123859 | -86.15176712 | 2020-11-01 04:36:19 | Muskegon, Michigan, US |
2245998 | 2245998 | 2020-10-30 | US | Oregon | Lane | 41039 | 2501 | 27 | 0 | 2474 | 43.93727035 | -122.847753 | 2020-10-31 04:24:44 | Lane, Oregon, US |
2245699 | 2245699 | 2020-10-30 | US | North Carolina | Henderson | 37089 | 2541 | 67 | 0 | 2474 | 35.33788927 | -82.4766782 | 2020-10-31 04:24:44 | Henderson, North Carolina, US |
8688 | 8688 | 2020-10-25 | US | Alabama | Cullman | 1043 | 2498 | 24 | 0 | 2474 | 34.13020303 | -86.86888037 | 2020-10-26 04:25:02 | Cullman, Alabama, US |
1056261 | 1056261 | 2020-10-23 | US | Ohio | Clermont | 39025 | 2512 | 38 | 0 | 2474 | 39.04847534 | -84.15375786 | 2020-10-24 04:24:46 | Clermont, Ohio, US |
1054038 | 1054038 | 2020-10-23 | Russia | Kursk Oblast | 9966 | 73 | 7419 | 2474 | 51.6568453 | 36.4852695 | 2020-10-24 04:24:46 | Kursk Oblast, Russia | ||
3784268 | 3784268 | 2020-10-13 | US | North Carolina | Wilson | 37195 | 2535 | 61 | 0 | 2474 | 35.70625477 | -77.917978 | 2020-10-14 04:24:05 | Wilson, North Carolina, US |
3804884 | 3804884 | 2020-10-05 | US | Tennessee | Washington | 47179 | 2487 | 38 | 0 | 2474 | 36.29472368 | -82.49454720000001 | 2020-10-06 04:23:33 | Washington, Tennessee, US |
2654869 | 2654869 | 2020-09-23 | US | Indiana | Monroe | 18105 | 2512 | 38 | 0 | 2474 | 39.16130004 | -86.52414358 | 2020-09-24 04:23:00 | Monroe, Indiana, US |
1123395 | 1123395 | 2020-09-17 | US | Mississippi | Lee | 28081 | 2540 | 66 | 0 | 2474 | 34.2918775 | -88.68149954 | 2020-09-18 05:05:00 | Lee, Mississippi, US |
1173224 | 1173224 | 2020-09-10 | Japan | Tokyo | 22440 | 379 | 19587 | 2474 | 35.711343 | 139.446921 | 2020-09-11 04:46:23 | Tokyo, Japan | ||
2664261 | 2664261 | 2020-09-04 | US | Ohio | Pickaway | 39129 | 2511 | 37 | 0 | 2474 | 39.64170392 | -83.0243386 | 2020-09-05 04:28:19 | Pickaway, Ohio, US |
1108510 | 1108510 | 2020-09-02 | US | Tennessee | Montgomery | 47125 | 2547 | 30 | 0 | 2474 | 36.49609412 | -87.38550661 | 2020-09-03 04:28:22 | Montgomery, Tennessee, US |
1997313 | 1997313 | 2020-08-26 | US | Florida | Charlotte | 12015 | 2582 | 108 | 0 | 2474 | 26.90131002 | -81.92949121 | 2020-08-27 04:28:15 | Charlotte, Florida, US |
148781 | 148781 | 2020-08-15 | US | South Carolina | Orangeburg | 45075 | 2550 | 76 | 0 | 2474 | 33.4391073 | -80.79886287 | 2020-08-16 04:27:42 | Orangeburg, South Carolina, US |
1920828 | 1920828 | 2020-08-10 | Switzerland | 36708 | 1834 | 32400 | 2474 | 46.8182 | 8.2275 | 2020-08-11 04:35:08 | Switzerland | |||
3184506 | 3184506 | 2020-07-28 | US | Louisiana | Terrebonne | 22109 | 2546 | 72 | 0 | 2474 | 29.37343766 | -90.82626855 | 2020-07-29 04:35:11 | Terrebonne, Louisiana, US |
2563939 | 2563939 | 2020-07-24 | Russia | Stavropol Krai | 7451 | 140 | 4837 | 2474 | 44.86325770000001 | 43.4406913 | 2020-07-25 04:47:39 | Stavropol Krai, Russia | ||
2708465 | 2708465 | 2020-07-17 | Peru | Cusco | 2586 | 112 | 0 | 2474 | -13.191068 | -72.153609 | 2020-07-18 04:34:45 | Cusco, Peru | ||
364444 | 364444 | 2020-07-16 | US | North Dakota | Cass | 38017 | 2590 | 73 | 0 | 2474 | 46.93201724 | -97.2444719 | 2020-07-17 04:34:50 | Cass, North Dakota, US |
2622969 | 2622969 | 2020-06-25 | US | Texas | Hidalgo | 48215 | 2394 | 29 | 0 | 2474 | 26.39418217 | -98.18299696 | 2020-06-26 04:33:43 | Hidalgo, Texas, US |
2437745 | 2437745 | 2020-06-20 | Russia | Bashkortostan Republic | 4850 | 18 | 2358 | 2474 | 54.8573563 | 57.1439682 | 2020-06-21 04:33:19 | Bashkortostan Republic, Russia | ||
3682514 | 3682514 | 2020-06-18 | Russia | Chelyabinsk Oblast | 5125 | 51 | 2600 | 2474 | 54.4223954 | 61.1865846 | 2020-06-19 04:33:17 | Chelyabinsk Oblast, Russia |
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]);