johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where active = 2442 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3659587 | 3659587 | 2021-07-11 | Italy | Sardegna | 57529 | 1492 | 53595 | 2442 | 39.21531192 | 9.110616306 | 2021-07-12 04:21:34 | Sardegna, Italy | ||
107406 | 107406 | 2021-06-19 | India | Madhya Pradesh | 789174 | 8737 | 777995 | 2442 | 23.541513 | 78.289633 | 2021-06-20 04:21:48 | Madhya Pradesh, India | ||
523037 | 523037 | 2021-06-09 | Qatar | 219138 | 573 | 216123 | 2442 | 25.3548 | 51.1839 | 2021-06-10 04:23:17 | Qatar | |||
3472490 | 3472490 | 2021-06-08 | Russia | Chelyabinsk Oblast | 62514 | 1689 | 58383 | 2442 | 54.4223954 | 61.1865846 | 2021-06-09 04:23:31 | Chelyabinsk Oblast, Russia | ||
2255845 | 2255845 | 2021-05-19 | Morocco | 515758 | 9106 | 504210 | 2442 | 31.7917 | -7.0926 | 2021-05-20 04:21:05 | Morocco | |||
986615 | 986615 | 2021-04-17 | Yemen | 5770 | 1119 | 2209 | 2442 | 15.552727 | 48.516388 | 2021-04-18 04:20:41 | Yemen | |||
2571892 | 2571892 | 2021-04-13 | Russia | Kostroma Oblast | 20158 | 411 | 17305 | 2442 | 58.424756 | 44.2533273 | 2021-04-14 04:20:41 | Kostroma Oblast, Russia | ||
998698 | 998698 | 2021-03-01 | Russia | Vologda Oblast | 39415 | 809 | 36164 | 2442 | 60.0391461 | 43.1215213 | 2021-03-02 05:23:30 | Vologda Oblast, Russia | ||
2186269 | 2186269 | 2021-02-26 | US | Pennsylvania | Pike | 42103 | 2489 | 47 | 0 | 2442 | 41.33155042 | -75.03208106 | 2021-02-27 05:22:28 | Pike, Pennsylvania, US |
1858206 | 1858206 | 2021-02-25 | Russia | Kaliningrad Oblast | 27907 | 246 | 25219 | 2442 | 54.7293041 | 21.1489473 | 2021-02-26 05:22:40 | Kaliningrad Oblast, Russia | ||
281308 | 281308 | 2021-02-24 | US | Indiana | Scott | 18143 | 2489 | 47 | 0 | 2442 | 38.68672078 | -85.74627859 | 2021-02-25 05:24:57 | Scott, Indiana, US |
184168 | 184168 | 2021-02-21 | US | Nevada | Douglas | 32005 | 2475 | 33 | 0 | 2442 | 38.912862 | -119.6171333 | 2021-02-22 05:24:21 | Douglas, Nevada, US |
744442 | 744442 | 2021-02-20 | US | Nevada | Douglas | 32005 | 2475 | 33 | 0 | 2442 | 38.912862 | -119.6171333 | 2021-02-21 05:24:33 | Douglas, Nevada, US |
1153916 | 1153916 | 2021-02-18 | US | Georgia | Franklin | 13119 | 2483 | 41 | 0 | 2442 | 34.37525597 | -83.23159927 | 2021-02-19 05:24:16 | Franklin, Georgia, US |
1530813 | 1530813 | 2021-02-09 | US | Tennessee | Claiborne | 47025 | 2503 | 56 | 0 | 2442 | 36.48319149 | -83.65947309 | 2021-02-10 05:22:41 | Claiborne, Tennessee, US |
1675742 | 1675742 | 2021-02-07 | US | Virgin Islands | 78 | 2466 | 24 | 0 | 2442 | 18.3358 | -64.8963 | 2021-02-08 05:22:39 | Virgin Islands, US | |
978203 | 978203 | 2021-02-06 | US | Virgin Islands | 78 | 2466 | 24 | 0 | 2442 | 18.3358 | -64.8963 | 2021-02-07 05:23:00 | Virgin Islands, US | |
1589258 | 1589258 | 2021-02-05 | US | Indiana | Greene | 18055 | 2514 | 72 | 0 | 2442 | 39.03630547 | -86.96223202 | 2021-02-06 05:23:55 | Greene, Indiana, US |
790373 | 790373 | 2021-02-04 | Italy | P.A. Trento | 28253 | 1158 | 24653 | 2442 | 46.06893511 | 11.12123097 | 2021-02-05 05:22:38 | P.A. Trento, Italy | ||
342112 | 342112 | 2021-02-03 | US | Mississippi | Simpson | 28127 | 2518 | 76 | 0 | 2442 | 31.91282117 | -89.91716179 | 2021-02-04 05:22:26 | Simpson, Mississippi, US |
15886 | 15886 | 2021-01-26 | US | Wisconsin | Kewaunee | 55061 | 2469 | 27 | 0 | 2442 | 44.51727459 | -87.61468386 | 2021-01-27 05:23:41 | Kewaunee, Wisconsin, US |
2568124 | 2568124 | 2021-01-25 | US | Arkansas | Carroll | 5015 | 2480 | 38 | 0 | 2442 | 36.34038560000001 | -93.54270261 | 2021-01-26 05:22:02 | Carroll, Arkansas, US |
1761985 | 1761985 | 2021-01-24 | US | Pennsylvania | Snyder | 42109 | 2505 | 63 | 0 | 2442 | 40.77129231 | -77.06840691 | 2021-01-25 05:22:16 | Snyder, Pennsylvania, US |
1761083 | 1761083 | 2021-01-24 | US | Mississippi | Coahoma | 28027 | 2497 | 55 | 0 | 2442 | 34.22772299 | -90.60415045 | 2021-01-25 05:22:16 | Coahoma, Mississippi, US |
2428746 | 2428746 | 2021-01-23 | US | Mississippi | Tippah | 28139 | 2492 | 50 | 0 | 2442 | 34.76872156 | -88.90988194 | 2021-01-24 05:22:35 | Tippah, Mississippi, US |
2427665 | 2427665 | 2021-01-23 | US | Georgia | Chattahoochee | 13053 | 2445 | 3 | 0 | 2442 | 32.34341231 | -84.78809239 | 2021-01-24 05:22:35 | Chattahoochee, Georgia, US |
3505019 | 3505019 | 2021-01-17 | US | Michigan | Newaygo | 26123 | 2482 | 40 | 0 | 2442 | 43.554374 | -85.80070107 | 2021-01-18 05:22:34 | Newaygo, Michigan, US |
3103102 | 3103102 | 2021-01-16 | US | Michigan | Newaygo | 26123 | 2482 | 40 | 0 | 2442 | 43.554374 | -85.80070107 | 2021-01-17 05:22:17 | Newaygo, Michigan, US |
3518224 | 3518224 | 2021-01-15 | US | South Carolina | Marion | 45067 | 2522 | 80 | 0 | 2442 | 34.07859748 | -79.36400756 | 2021-01-16 05:22:40 | Marion, South Carolina, US |
191987 | 191987 | 2021-01-11 | US | Missouri | Marion | 29127 | 2472 | 30 | 0 | 2442 | 39.80601912 | -91.62203062 | 2021-01-12 05:22:15 | Marion, Missouri, US |
2626850 | 2626850 | 2021-01-10 | US | Illinois | Fulton | 17057 | 2481 | 39 | 0 | 2442 | 40.47289135 | -90.20862357 | 2021-01-11 05:21:50 | Fulton, Illinois, US |
2542712 | 2542712 | 2021-01-07 | US | Kansas | McPherson | 20113 | 2481 | 39 | 0 | 2442 | 38.39184858 | -97.64769869 | 2021-01-08 05:22:42 | McPherson, Kansas, US |
2866021 | 2866021 | 2021-01-06 | US | Kansas | McPherson | 20113 | 2481 | 39 | 0 | 2442 | 38.39184858 | -97.64769869 | 2021-01-07 05:22:03 | McPherson, Kansas, US |
1063686 | 1063686 | 2021-01-04 | US | Mississippi | Sunflower | 28133 | 2504 | 62 | 0 | 2442 | 33.60192578 | -90.58882684 | 2021-01-05 05:21:49 | Sunflower, Mississippi, US |
1012573 | 1012573 | 2020-12-30 | US | New York | Wayne | 36117 | 2477 | 35 | 0 | 2442 | 43.15494365 | -77.02976528 | 2020-12-31 05:22:49 | Wayne, New York, US |
1012046 | 1012046 | 2020-12-30 | US | Minnesota | Pine | 27115 | 2454 | 12 | 0 | 2442 | 46.12105238 | -92.74070188 | 2020-12-31 05:22:49 | Pine, Minnesota, US |
205092 | 205092 | 2020-12-25 | US | South Dakota | Beadle | 46005 | 2476 | 34 | 0 | 2442 | 44.41464384 | -98.27858469 | 2020-12-26 05:22:28 | Beadle, South Dakota, US |
3694315 | 3694315 | 2020-12-24 | US | South Dakota | Beadle | 46005 | 2476 | 34 | 0 | 2442 | 44.41464384 | -98.27858469 | 2020-12-25 05:22:48 | Beadle, South Dakota, US |
3770931 | 3770931 | 2020-12-22 | US | Indiana | Adams | 18001 | 2476 | 34 | 0 | 2442 | 40.7457653 | -84.93671406 | 2020-12-23 05:22:03 | Adams, Indiana, US |
2121406 | 2121406 | 2020-12-20 | US | Minnesota | Carlton | 27017 | 2475 | 33 | 0 | 2442 | 46.59180601 | -92.67601019 | 2020-12-21 05:27:58 | Carlton, Minnesota, US |
2119969 | 2119969 | 2020-12-20 | Russia | Ulyanovsk Oblast | 33202 | 416 | 30344 | 2442 | 54.1463177 | 47.2324921 | 2020-12-21 05:27:58 | Ulyanovsk Oblast, Russia | ||
1752467 | 1752467 | 2020-12-14 | US | Iowa | Jones | 19105 | 2475 | 33 | 0 | 2442 | 42.12118609 | -91.13139641 | 2020-12-15 05:26:38 | Jones, Iowa, US |
2349149 | 2349149 | 2020-12-07 | US | Minnesota | Lyon | 27083 | 2459 | 17 | 0 | 2442 | 44.41327865 | -95.83806103 | 2020-12-08 05:27:42 | Lyon, Minnesota, US |
1635569 | 1635569 | 2020-12-05 | US | Utah | Wasatch | 49051 | 2455 | 13 | 0 | 2442 | 40.33110236 | -111.1691419 | 2020-12-06 05:26:18 | Wasatch, Utah, US |
3863354 | 3863354 | 2020-12-04 | US | Wisconsin | Clark | 55019 | 2489 | 47 | 0 | 2442 | 44.73483377 | -90.61207486 | 2020-12-05 05:27:36 | Clark, Wisconsin, US |
3862358 | 3862358 | 2020-12-04 | US | Oklahoma | Cherokee | 40021 | 2453 | 11 | 0 | 2442 | 35.90692775 | -94.99980896 | 2020-12-05 05:27:36 | Cherokee, Oklahoma, US |
1585015 | 1585015 | 2020-11-30 | US | Georgia | Polk | 13233 | 2476 | 34 | 0 | 2442 | 34.00267074 | -85.18677781 | 2020-12-01 05:26:18 | Polk, Georgia, US |
2936736 | 2936736 | 2020-11-28 | US | Louisiana | Lincoln | 22061 | 2501 | 59 | 0 | 2442 | 32.6003154 | -92.6659741 | 2020-11-29 05:25:55 | Lincoln, Louisiana, US |
393739 | 393739 | 2020-11-27 | US | Louisiana | Lincoln | 22061 | 2501 | 59 | 0 | 2442 | 32.6003154 | -92.6659741 | 2020-11-28 05:25:50 | Lincoln, Louisiana, US |
925843 | 925843 | 2020-11-26 | US | New Jersey | Hunterdon | 34019 | 2573 | 131 | 0 | 2442 | 40.56335249 | -74.91284156 | 2020-11-27 05:26:53 | Hunterdon, New Jersey, US |
3192357 | 3192357 | 2020-11-22 | US | North Carolina | Wilkes | 37193 | 2489 | 47 | 0 | 2442 | 36.2084135 | -81.16232895 | 2020-11-23 05:25:26 | Wilkes, North Carolina, US |
3190482 | 3190482 | 2020-11-22 | US | Arkansas | Lonoke | 5085 | 2487 | 45 | 0 | 2442 | 34.75392199 | -91.88742357 | 2020-11-23 05:25:26 | Lonoke, Arkansas, US |
3839839 | 3839839 | 2020-11-21 | US | Virginia | Lynchburg | 51680 | 2469 | 27 | 0 | 2442 | 37.40021399 | -79.19888138 | 2020-11-22 05:25:45 | Lynchburg, Virginia, US |
2922105 | 2922105 | 2020-11-04 | US | Tennessee | Dyer | 47045 | 2497 | 38 | 0 | 2442 | 36.05931946 | -89.41542855 | 2020-11-05 06:05:03 | Dyer, Tennessee, US |
2921663 | 2921663 | 2020-11-04 | US | Ohio | Miami | 39109 | 2505 | 63 | 0 | 2442 | 40.0543329 | -84.22871271 | 2020-11-05 06:05:03 | Miami, Ohio, US |
3305005 | 3305005 | 2020-11-02 | US | Georgia | Jackson | 13157 | 2484 | 42 | 0 | 2442 | 34.13794553 | -83.56814788 | 2020-11-03 06:00:16 | Jackson, Georgia, US |
2245709 | 2245709 | 2020-10-30 | US | North Carolina | Lincoln | 37109 | 2458 | 16 | 0 | 2442 | 35.48508185 | -81.21740317 | 2020-10-31 04:24:44 | Lincoln, North Carolina, US |
1454165 | 1454165 | 2020-10-27 | US | Maryland | Wicomico | 24045 | 2493 | 51 | 0 | 2442 | 38.37301947 | -75.62705831 | 2020-10-28 04:24:39 | Wicomico, Maryland, US |
10207 | 10207 | 2020-10-25 | US | Missouri | Clay | 29047 | 2491 | 49 | 0 | 2442 | 39.31132056 | -94.41850862 | 2020-10-26 04:25:02 | Clay, Missouri, US |
3654655 | 3654655 | 2020-10-24 | US | Texas | Grayson | 48181 | 2482 | 66 | 0 | 2442 | 33.62744998 | -96.67753461 | 2020-10-25 04:24:36 | Grayson, Texas, US |
1044112 | 1044112 | 2020-10-07 | US | North Carolina | Cleveland | 37045 | 2514 | 72 | 0 | 2442 | 35.33553364 | -81.55204486 | 2020-10-08 04:23:56 | Cleveland, North Carolina, US |
3804589 | 3804589 | 2020-10-05 | US | Pennsylvania | Westmoreland | 42129 | 2499 | 57 | 0 | 2442 | 40.31377979999999 | -79.46615476 | 2020-10-06 04:23:33 | Westmoreland, Pennsylvania, US |
2382510 | 2382510 | 2020-10-01 | US | South Dakota | Pennington | 46103 | 2479 | 37 | 0 | 2442 | 44.0025835 | -102.8240777 | 2020-10-02 04:23:51 | Pennington, South Dakota, US |
2614233 | 2614233 | 2020-09-26 | Russia | Kalmykia Republic | 6162 | 71 | 3649 | 2442 | 46.2313018 | 45.3275745 | 2020-09-27 04:23:00 | Kalmykia Republic, Russia | ||
347691 | 347691 | 2020-09-14 | US | Washington | Clark | 53011 | 2510 | 68 | 0 | 2442 | 45.77568046 | -122.4829204 | 2020-09-15 03:22:50 | Clark, Washington, US |
195020 | 195020 | 2020-08-31 | US | Illinois | Champaign | 17019 | 2462 | 20 | 0 | 2442 | 40.13919438 | -88.20046615 | 2020-09-01 04:28:31 | Champaign, Illinois, US |
3932250 | 3932250 | 2020-08-30 | Russia | Nizhny Novgorod Oblast | 27550 | 469 | 24639 | 2442 | 55.47180329999999 | 44.0911594 | 2020-08-31 04:28:27 | Nizhny Novgorod Oblast, Russia | ||
2301789 | 2301789 | 2020-08-22 | US | North Carolina | Rowan | 37159 | 2496 | 54 | 0 | 2442 | 35.64003916 | -80.52446628 | 2020-08-23 04:27:48 | Rowan, North Carolina, US |
3178243 | 3178243 | 2020-08-18 | Russia | Rostov Oblast | 15251 | 293 | 12516 | 2442 | 47.6222451 | 40.7957942 | 2020-08-19 04:27:00 | Rostov Oblast, Russia | ||
837924 | 837924 | 2020-08-17 | Sweden | Orebro | 2613 | 171 | 0 | 2442 | 59.535 | 15.0066 | 2020-08-18 04:27:56 | Orebro, Sweden | ||
147168 | 147168 | 2020-08-15 | US | Iowa | Linn | 19113 | 2531 | 89 | 0 | 2442 | 42.07923082 | -91.59809485 | 2020-08-16 04:27:42 | Linn, Iowa, US |
1615056 | 1615056 | 2020-08-14 | US | South Carolina | Orangeburg | 45075 | 2514 | 72 | 0 | 2442 | 33.4391073 | -80.79886287 | 2020-08-15 04:27:31 | Orangeburg, South Carolina, US |
3921755 | 3921755 | 2020-08-09 | US | Alabama | Morgan | 1103 | 2460 | 18 | 0 | 2442 | 34.45500589 | -86.85475946 | 2020-08-10 04:34:55 | Morgan, Alabama, US |
844828 | 844828 | 2020-07-22 | Colombia | Narino | 5992 | 179 | 3371 | 2442 | 1.2892 | -77.3579 | 2020-07-23 05:15:04 | Narino, Colombia | ||
2630840 | 2630840 | 2020-06-29 | US | Maryland | Howard | 24027 | 2527 | 85 | 0 | 2442 | 39.25305293 | -76.93126208 | 2020-06-30 04:33:48 | Howard, Maryland, US |
1269770 | 1269770 | 2020-06-05 | Mexico | Mexico | 17815 | 1531 | 13842 | 2442 | 19.4969 | -99.7233 | 2020-06-06 02:33:00 | Mexico, Mexico | ||
3275108 | 3275108 | 2020-05-15 | US | Delaware | New Castle | 10003 | 2619 | 177 | 0 | 2442 | 39.57992638 | -75.64054974 | 2020-05-16 02:32:19 | New Castle, Delaware, US |
3586503 | 3586503 | 2020-04-27 | US | Pennsylvania | Berks | 42011 | 2531 | 89 | 0 | 2442 | 40.41570541 | -75.92457766 | 2020-04-28 02:30:51 | Berks, Pennsylvania, US |
3740237 | 3740237 | 2020-04-03 | US | New Jersey | Union | 34039 | 2487 | 45 | 0 | 2442 | 40.65835409 | -74.30680092 | 2020-04-03 22:46:37 | Union, New Jersey, 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]);