johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
405 rows where active = 568 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375198 | 2375198 | 2021-07-20 | Malaysia | W.P. Labuan | 9467 | 141 | 8758 | 568 | 5.2831 | 115.2308 | 2021-07-21 04:21:40 | W.P. Labuan, Malaysia | ||
2947268 | 2947268 | 2021-07-16 | Germany | Hamburg | 77823 | 1603 | 75700 | 568 | 53.5511 | 9.9937 | 2021-07-17 04:22:22 | Hamburg, Germany | ||
2947116 | 2947116 | 2021-07-16 | Cabo Verde | 33234 | 295 | 32371 | 568 | 16.5388 | -23.0418 | 2021-07-17 04:22:22 | Cabo Verde | |||
3744766 | 3744766 | 2021-07-12 | Malaysia | Terengganu | 11901 | 82 | 11251 | 568 | 5.3117 | 103.1324 | 2021-07-13 04:21:18 | Terengganu, Malaysia | ||
1440423 | 1440423 | 2021-07-07 | Colombia | Caqueta | 20896 | 795 | 19533 | 568 | 0.8699 | -73.8419 | 2021-07-08 04:21:26 | Caqueta, Colombia | ||
2693448 | 2693448 | 2021-07-06 | Cabo Verde | 32788 | 289 | 31931 | 568 | 16.5388 | -23.0418 | 2021-07-07 04:21:20 | Cabo Verde | |||
2072122 | 2072122 | 2021-07-02 | Russia | Kalmykia Republic | 21765 | 415 | 20782 | 568 | 46.2313018 | 45.3275745 | 2021-07-03 04:21:37 | Kalmykia Republic, Russia | ||
2768562 | 2768562 | 2021-07-01 | Ukraine | Khmelnytskyi Oblast | 88908 | 1868 | 86472 | 568 | 49.423 | 26.9871 | 2021-07-02 04:21:47 | Khmelnytskyi Oblast, Ukraine | ||
522842 | 522842 | 2021-06-09 | Italy | Liguria | 102982 | 4340 | 98074 | 568 | 44.41149315 | 8.9326992 | 2021-06-10 04:23:17 | Liguria, Italy | ||
2586056 | 2586056 | 2021-06-05 | Malawi | 34384 | 1156 | 32660 | 568 | -13.2543 | 34.3015 | 2021-06-06 04:24:03 | Malawi | |||
2585773 | 2585773 | 2021-06-05 | Chile | Aysen | 6368 | 40 | 5760 | 568 | -45.9864 | -73.7669 | 2021-06-06 04:24:03 | Aysen, Chile | ||
1448655 | 1448655 | 2021-06-03 | Malawi | 34365 | 1156 | 32641 | 568 | -13.2543 | 34.3015 | 2021-06-04 04:23:37 | Malawi | |||
1448505 | 1448505 | 2021-06-03 | Germany | Saarland | 40934 | 1011 | 39400 | 568 | 49.3964 | 7.023 | 2021-06-04 04:23:37 | Saarland, Germany | ||
1448431 | 1448431 | 2021-06-03 | Colombia | Choco | 12121 | 307 | 11246 | 568 | 5.2528 | -76.82600000000002 | 2021-06-04 04:23:37 | Choco, Colombia | ||
83124 | 83124 | 2021-05-25 | Japan | Oita | 3231 | 38 | 2625 | 568 | 33.200697 | 131.43323999999998 | 2021-05-26 04:20:35 | Oita, Japan | ||
1952527 | 1952527 | 2021-05-21 | Japan | Ishikawa | 3381 | 98 | 2715 | 568 | 36.769464 | 136.771027 | 2021-05-22 04:20:45 | Ishikawa, Japan | ||
3574803 | 3574803 | 2021-05-17 | Russia | Kemerovo Oblast | 36172 | 698 | 34906 | 568 | 54.53357809999999 | 87.342861 | 2021-05-18 04:20:33 | Kemerovo Oblast, Russia | ||
1082132 | 1082132 | 2021-05-14 | Russia | Kemerovo Oblast | 35985 | 691 | 34726 | 568 | 54.53357809999999 | 87.342861 | 2021-05-15 04:20:58 | Kemerovo Oblast, Russia | ||
2820768 | 2820768 | 2021-05-10 | Italy | Valle d'Aosta | 11236 | 463 | 10205 | 568 | 45.73750286 | 7.320149366 | 2021-05-11 04:20:41 | Valle d'Aosta, Italy | ||
3675504 | 3675504 | 2021-05-04 | Colombia | Meta | 47349 | 1086 | 45695 | 568 | 3.272 | -73.0877 | 2021-05-05 04:20:43 | Meta, Colombia | ||
1636567 | 1636567 | 2021-04-29 | Russia | Tula Oblast | 38441 | 1840 | 36033 | 568 | 53.9570701 | 37.3690909 | 2021-04-30 04:21:03 | Tula Oblast, Russia | ||
3702295 | 3702295 | 2021-04-27 | Russia | Amur Oblast | 22263 | 277 | 21418 | 568 | 52.8032368 | 128.437295 | 2021-04-28 04:20:32 | Amur Oblast, Russia | ||
954706 | 954706 | 2021-04-25 | Colombia | Casanare | 14561 | 331 | 13662 | 568 | 5.7589 | -71.5724 | 2021-04-26 04:21:04 | Casanare, Colombia | ||
2549064 | 2549064 | 2021-04-15 | Russia | Bryansk Oblast | 36962 | 295 | 36099 | 568 | 52.8873315 | 33.41585300000001 | 2021-04-16 04:20:46 | Bryansk Oblast, Russia | ||
638169 | 638169 | 2021-03-31 | Russia | Smolensk Oblast | 28168 | 758 | 26842 | 568 | 55.03434960000001 | 33.0192065 | 2021-04-01 04:27:05 | Smolensk Oblast, Russia | ||
1219757 | 1219757 | 2021-03-27 | Russia | Bryansk Oblast | 35277 | 283 | 34426 | 568 | 52.8873315 | 33.41585300000001 | 2021-03-28 05:28:10 | Bryansk Oblast, Russia | ||
999996 | 999996 | 2021-03-01 | US | Maine | Waldo | 23027 | 587 | 19 | 0 | 568 | 44.4858305 | -69.12061935 | 2021-03-02 05:23:30 | Waldo, Maine, US |
281040 | 281040 | 2021-02-24 | US | Georgia | Randolph | 13243 | 600 | 32 | 0 | 568 | 31.76622818 | -84.75732369 | 2021-02-25 05:24:57 | Randolph, Georgia, US |
473430 | 473430 | 2021-02-19 | US | Montana | Sanders | 30089 | 577 | 9 | 0 | 568 | 47.67657534 | -115.1329916 | 2021-02-20 05:22:51 | Sanders, Montana, US |
472322 | 472322 | 2021-02-19 | US | Idaho | Benewah | 16009 | 575 | 7 | 0 | 568 | 47.21754179 | -116.6586851 | 2021-02-20 05:22:51 | Benewah, Idaho, US |
3604538 | 3604538 | 2021-02-17 | US | West Virginia | Pocahontas | 54075 | 577 | 9 | 0 | 568 | 38.32758728 | -80.00993811 | 2021-02-18 05:22:58 | Pocahontas, West Virginia, US |
3603823 | 3603823 | 2021-02-17 | US | Puerto Rico | Yauco | 72153 | 568 | 0 | 0 | 568 | 18.080374 | -66.858814 | 2021-02-18 05:22:58 | Yauco, Puerto Rico, US |
1339893 | 1339893 | 2021-02-15 | US | Michigan | Crawford | 26039 | 573 | 5 | 0 | 568 | 44.68255561 | -84.61006219 | 2021-02-16 05:24:38 | Crawford, Michigan, US |
2286183 | 2286183 | 2021-02-14 | US | Puerto Rico | Orocovis | 72107 | 568 | 0 | 0 | 568 | 18.215046 | -66.433604 | 2021-02-15 05:24:49 | Orocovis, Puerto Rico, US |
2680588 | 2680588 | 2021-02-13 | US | Puerto Rico | Quebradillas | 72115 | 568 | 0 | 0 | 568 | 18.439692 | -66.926113 | 2021-02-14 05:23:43 | Quebradillas, Puerto Rico, US |
2677678 | 2677678 | 2021-02-13 | Colombia | Meta | 41707 | 947 | 40192 | 568 | 3.272 | -73.0877 | 2021-02-14 05:23:43 | Meta, Colombia | ||
3540925 | 3540925 | 2021-02-12 | US | Kentucky | Trimble | 21223 | 571 | 3 | 0 | 568 | 38.61056487 | -85.33775972 | 2021-02-13 05:22:12 | Trimble, Kentucky, US |
2639816 | 2639816 | 2021-02-11 | US | Nebraska | Nemaha | 31127 | 581 | 13 | 0 | 568 | 40.38514847 | -95.85433992 | 2021-02-12 05:23:29 | Nemaha, Nebraska, US |
615788 | 615788 | 2021-02-08 | US | Nebraska | Pierce | 31139 | 588 | 20 | 0 | 568 | 42.26434853 | -97.60122773 | 2021-02-09 05:23:30 | Pierce, Nebraska, US |
1675902 | 1675902 | 2021-02-07 | US | Washington | Pend Oreille | 53051 | 573 | 5 | 0 | 568 | 48.53234021 | -117.2741804 | 2021-02-08 05:22:39 | Pend Oreille, Washington, US |
1675624 | 1675624 | 2021-02-07 | US | Texas | Mills | 48333 | 700 | 19 | 0 | 568 | 31.49557106 | -98.59272068 | 2021-02-08 05:22:39 | Mills, Texas, US |
1674557 | 1674557 | 2021-02-07 | US | Nebraska | Pierce | 31139 | 588 | 20 | 0 | 568 | 42.26434853 | -97.60122773 | 2021-02-08 05:22:39 | Pierce, Nebraska, US |
978420 | 978420 | 2021-02-06 | US | West Virginia | Ritchie | 54085 | 577 | 9 | 0 | 568 | 39.18094587 | -81.06356878 | 2021-02-07 05:23:00 | Ritchie, West Virginia, US |
978363 | 978363 | 2021-02-06 | US | Washington | Pend Oreille | 53051 | 573 | 5 | 0 | 568 | 48.53234021 | -117.2741804 | 2021-02-07 05:23:00 | Pend Oreille, Washington, US |
978085 | 978085 | 2021-02-06 | US | Texas | Mills | 48333 | 700 | 19 | 0 | 568 | 31.49557106 | -98.59272068 | 2021-02-07 05:23:00 | Mills, Texas, US |
1591621 | 1591621 | 2021-02-05 | US | Washington | Pend Oreille | 53051 | 573 | 5 | 0 | 568 | 48.53234021 | -117.2741804 | 2021-02-06 05:23:55 | Pend Oreille, Washington, US |
1591372 | 1591372 | 2021-02-05 | US | Texas | Refugio | 48391 | 627 | 17 | 0 | 568 | 28.3238976 | -97.15766311 | 2021-02-06 05:23:55 | Refugio, Texas, US |
1591295 | 1591295 | 2021-02-05 | US | Texas | Jack | 48237 | 574 | 13 | 0 | 568 | 33.23377248 | -98.17283469 | 2021-02-06 05:23:55 | Jack, Texas, US |
791158 | 791158 | 2021-02-04 | US | Georgia | Crawford | 13079 | 580 | 12 | 0 | 568 | 32.71391813 | -83.98061238 | 2021-02-05 05:22:38 | Crawford, Georgia, US |
340835 | 340835 | 2021-02-03 | US | California | Plumas | 6063 | 569 | 2 | 0 | 568 | 40.00355989 | -120.8395236 | 2021-02-04 05:22:26 | Plumas, California, US |
1678276 | 1678276 | 2021-02-01 | US | Mississippi | Jefferson | 28063 | 591 | 23 | 0 | 568 | 31.73397872 | -91.03764977 | 2021-02-02 05:22:49 | Jefferson, Mississippi, US |
1462467 | 1462467 | 2021-01-31 | US | Puerto Rico | Anasco | 72011 | 568 | 0 | 0 | 568 | 18.287985 | -67.120611 | 2021-02-01 05:22:53 | Anasco, Puerto Rico, US |
2214202 | 2214202 | 2021-01-30 | US | Oklahoma | Cotton | 40033 | 581 | 13 | 0 | 568 | 34.28845626 | -98.37053567 | 2021-01-31 05:22:42 | Cotton, Oklahoma, US |
1897579 | 1897579 | 2021-01-29 | US | Alaska | Northwest Arctic | 2188 | 569 | 1 | 0 | 568 | 67.04919196 | -159.7503946 | 2021-01-30 05:22:49 | Northwest Arctic, Alaska, US |
2485240 | 2485240 | 2021-01-28 | US | Vermont | Addison | 50001 | 573 | 5 | 0 | 568 | 44.03217337 | -73.14130877 | 2021-01-29 05:22:23 | Addison, Vermont, US |
2485067 | 2485067 | 2021-01-28 | US | Texas | Hamilton | 48193 | 624 | 23 | 0 | 568 | 31.70470573 | -98.11083887 | 2021-01-29 05:22:23 | Hamilton, Texas, US |
2483518 | 2483518 | 2021-01-28 | US | Maine | Knox | 23013 | 572 | 4 | 0 | 568 | 44.11486325 | -69.10529169 | 2021-01-29 05:22:23 | Knox, Maine, US |
2483309 | 2483309 | 2021-01-28 | US | Kansas | Sherman | 20181 | 579 | 11 | 0 | 568 | 39.35147699 | -101.7197624 | 2021-01-29 05:22:23 | Sherman, Kansas, US |
2482395 | 2482395 | 2021-01-28 | US | Alaska | Northwest Arctic | 2188 | 569 | 1 | 0 | 568 | 67.04919196 | -159.7503946 | 2021-01-29 05:22:23 | Northwest Arctic, Alaska, US |
3156986 | 3156986 | 2021-01-27 | US | Virginia | Poquoson | 51735 | 575 | 7 | 0 | 568 | 37.14259351 | -76.35798148 | 2021-01-28 05:22:24 | Poquoson, Virginia, US |
3154944 | 3154944 | 2021-01-27 | US | Kansas | Sherman | 20181 | 579 | 11 | 0 | 568 | 39.35147699 | -101.7197624 | 2021-01-28 05:22:24 | Sherman, Kansas, US |
3154030 | 3154030 | 2021-01-27 | US | Alaska | Northwest Arctic | 2188 | 569 | 1 | 0 | 568 | 67.04919196 | -159.7503946 | 2021-01-28 05:22:24 | Northwest Arctic, Alaska, US |
14661 | 14661 | 2021-01-26 | US | North Carolina | Hyde | 37095 | 574 | 6 | 0 | 568 | 35.42017674 | -76.15180542 | 2021-01-27 05:23:41 | Hyde, North Carolina, US |
12765 | 12765 | 2021-01-26 | US | Alaska | Northwest Arctic | 2188 | 569 | 1 | 0 | 568 | 67.04919196 | -159.7503946 | 2021-01-27 05:23:41 | Northwest Arctic, Alaska, US |
2569985 | 2569985 | 2021-01-25 | US | North Carolina | Hyde | 37095 | 574 | 6 | 0 | 568 | 35.42017674 | -76.15180542 | 2021-01-26 05:22:02 | Hyde, North Carolina, US |
2569959 | 2569959 | 2021-01-25 | US | North Carolina | Clay | 37043 | 573 | 5 | 0 | 568 | 35.05704275 | -83.74353633 | 2021-01-26 05:22:02 | Clay, North Carolina, US |
2569870 | 2569870 | 2021-01-25 | US | New Mexico | Torrance | 35057 | 576 | 8 | 0 | 568 | 34.64048375 | -105.8508949 | 2021-01-26 05:22:02 | Torrance, New Mexico, US |
2568089 | 2568089 | 2021-01-25 | US | Alaska | Northwest Arctic | 2188 | 568 | 0 | 0 | 568 | 67.04919196 | -159.7503946 | 2021-01-26 05:22:02 | Northwest Arctic, Alaska, US |
1095031 | 1095031 | 2021-01-20 | US | Idaho | Power | 16077 | 574 | 6 | 0 | 568 | 42.69254894 | -112.83957420000002 | 2021-01-21 05:22:01 | Power, Idaho, US |
1093872 | 1093872 | 2021-01-20 | Chile | Arica y Parinacota | 11982 | 245 | 11169 | 568 | -18.594 | -69.4785 | 2021-01-21 05:22:01 | Arica y Parinacota, Chile | ||
910775 | 910775 | 2021-01-19 | US | Oregon | Baker | 41001 | 573 | 5 | 0 | 568 | 44.70915557 | -117.6749883 | 2021-01-20 05:21:54 | Baker, Oregon, US |
909003 | 909003 | 2021-01-19 | US | Georgia | Lincoln | 13181 | 584 | 16 | 0 | 568 | 33.79201475 | -82.45024131 | 2021-01-20 05:21:54 | Lincoln, Georgia, US |
237831 | 237831 | 2021-01-18 | US | Colorado | Archuleta | 8007 | 597 | 1 | 0 | 568 | 37.19474156 | -107.0476867 | 2021-01-19 05:22:15 | Archuleta, Colorado, US |
3503948 | 3503948 | 2021-01-17 | US | Colorado | Archuleta | 8007 | 595 | 1 | 0 | 568 | 37.19474156 | -107.0476867 | 2021-01-18 05:22:34 | Archuleta, Colorado, US |
3103992 | 3103992 | 2021-01-16 | US | Oklahoma | Jefferson | 40067 | 572 | 4 | 0 | 568 | 34.11130184 | -97.83182974 | 2021-01-17 05:22:17 | Jefferson, Oklahoma, US |
3101550 | 3101550 | 2021-01-16 | Mongolia | 1512 | 1 | 947 | 568 | 46.8625 | 103.8467 | 2021-01-17 05:22:17 | Mongolia | |||
3517813 | 3517813 | 2021-01-15 | US | North Dakota | Ransom | 38073 | 580 | 13 | 0 | 568 | 46.45621782 | -97.65742504 | 2021-01-16 05:22:40 | Ransom, North Dakota, US |
3882448 | 3882448 | 2021-01-14 | US | South Dakota | Kingsbury | 46077 | 581 | 13 | 0 | 568 | 44.36956169 | -97.4913945 | 2021-01-15 05:22:24 | Kingsbury, South Dakota, US |
3881985 | 3881985 | 2021-01-14 | US | North Dakota | Ransom | 38073 | 578 | 12 | 0 | 568 | 46.45621782 | -97.65742504 | 2021-01-15 05:22:24 | Ransom, North Dakota, US |
3310612 | 3310612 | 2021-01-13 | US | North Dakota | Ransom | 38073 | 577 | 12 | 0 | 568 | 46.45621782 | -97.65742504 | 2021-01-14 05:22:32 | Ransom, North Dakota, US |
3308312 | 3308312 | 2021-01-13 | Mongolia | 1469 | 1 | 909 | 568 | 46.8625 | 103.8467 | 2021-01-14 05:22:32 | Mongolia | |||
777850 | 777850 | 2021-01-12 | US | West Virginia | Summers | 54089 | 585 | 17 | 0 | 568 | 37.65390597 | -80.86009693 | 2021-01-13 05:22:15 | Summers, West Virginia, US |
777673 | 777673 | 2021-01-12 | US | Virginia | Floyd | 51063 | 585 | 17 | 0 | 568 | 36.9302126 | -80.36738849 | 2021-01-13 05:22:15 | Floyd, Virginia, US |
2627290 | 2627290 | 2021-01-10 | US | Kentucky | Leslie | 21131 | 569 | 1 | 0 | 568 | 37.09246661 | -83.37999606 | 2021-01-11 05:21:50 | Leslie, Kentucky, US |
2627003 | 2627003 | 2021-01-10 | US | Indiana | Switzerland | 18155 | 574 | 6 | 0 | 568 | 38.82767338 | -85.03022429 | 2021-01-11 05:21:50 | Switzerland, Indiana, US |
2625666 | 2625666 | 2021-01-10 | Chile | Nuble | 11552 | 228 | 10756 | 568 | -36.7226 | -71.7622 | 2021-01-11 05:21:50 | Nuble, Chile | ||
3903130 | 3903130 | 2021-01-09 | US | Texas | Morris | 48343 | 725 | 11 | 0 | 568 | 33.11304005 | -94.73255695 | 2021-01-10 05:22:12 | Morris, Texas, US |
155850 | 155850 | 2021-01-08 | US | Missouri | Caldwell | 29025 | 575 | 7 | 0 | 568 | 39.65620858 | -93.98308093 | 2021-01-09 05:22:18 | Caldwell, Missouri, US |
155216 | 155216 | 2021-01-08 | US | Iowa | Taylor | 19173 | 577 | 9 | 0 | 568 | 40.73710579 | -94.69778563 | 2021-01-09 05:22:18 | Taylor, Iowa, US |
154854 | 154854 | 2021-01-08 | US | Georgia | Terrell | 13273 | 603 | 35 | 0 | 568 | 31.77527543 | -84.44069698 | 2021-01-09 05:22:18 | Terrell, Georgia, US |
2542701 | 2542701 | 2021-01-07 | US | Kansas | Kingman | 20095 | 578 | 10 | 0 | 568 | 37.55909527 | -98.13638678 | 2021-01-08 05:22:42 | Kingman, Kansas, US |
2541909 | 2541909 | 2021-01-07 | US | Arkansas | Newton | 5101 | 592 | 24 | 0 | 568 | 35.91947491 | -93.21612969 | 2021-01-08 05:22:42 | Newton, Arkansas, US |
2866010 | 2866010 | 2021-01-06 | US | Kansas | Kingman | 20095 | 578 | 10 | 0 | 568 | 37.55909527 | -98.13638678 | 2021-01-07 05:22:03 | Kingman, Kansas, US |
2865226 | 2865226 | 2021-01-06 | US | Arkansas | Prairie | 5117 | 585 | 17 | 0 | 568 | 34.83624419 | -91.55162157 | 2021-01-07 05:22:03 | Prairie, Arkansas, US |
3035443 | 3035443 | 2021-01-05 | US | Indiana | Warren | 18171 | 578 | 10 | 0 | 568 | 40.34728141 | -87.35602659 | 2021-01-06 05:22:16 | Warren, Indiana, US |
3034097 | 3034097 | 2021-01-05 | Chile | Nuble | 11107 | 221 | 10318 | 568 | -36.7226 | -71.7622 | 2021-01-06 05:22:16 | Nuble, Chile | ||
2230491 | 2230491 | 2021-01-02 | US | Tennessee | Pickett | 47137 | 601 | 17 | 0 | 568 | 36.55606529 | -85.07763299999998 | 2021-01-03 05:22:52 | Pickett, Tennessee, US |
3696695 | 3696695 | 2020-12-31 | US | Iowa | Lucas | 19117 | 575 | 7 | 0 | 568 | 41.02958964 | -93.32780803 | 2021-01-01 05:23:07 | Lucas, Iowa, US |
3695558 | 3695558 | 2020-12-31 | Maldives | 13757 | 48 | 13141 | 568 | 3.2028 | 73.2207 | 2021-01-01 05:23:07 | Maldives | |||
766117 | 766117 | 2020-12-29 | Chile | Tarapaca | 15530 | 275 | 14687 | 568 | -19.9232 | -69.5132 | 2020-12-30 05:22:34 | Tarapaca, Chile |
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]);