johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
680 rows where active = 287 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 581
- Japan 20
- Colombia 9
- Madagascar 7
- Russia 7
- Ukraine 6
- Gambia 4
- Mexico 4
- Italy 3
- Malaysia 3
- Pakistan 3
- San Marino 3
- Canada 2
- Chile 2
- United Kingdom 2
- Barbados 1
- Belize 1
- Benin 1
- Burundi 1
- China 1
- Congo (Brazzaville) 1
- Costa Rica 1
- France 1
- Germany 1
- Guinea-Bissau 1
- Latvia 1
- Liechtenstein 1
- Lithuania 1
- Montenegro 1
- Netherlands 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683365 | 3683365 | 2021-08-02 | Germany | Mecklenburg-Vorpommern | 44459 | 1180 | 43000 | 287 | 53.6127 | 12.4296 | 2021-08-03 04:21:39 | Mecklenburg-Vorpommern, Germany | ||
3296374 | 3296374 | 2021-07-30 | Russia | Chukotka Autonomous Okrug | 1142 | 9 | 846 | 287 | 66.0006475 | 169.4900869 | 2021-07-31 04:21:35 | Chukotka Autonomous Okrug, Russia | ||
3296033 | 3296033 | 2021-07-30 | Colombia | Putumayo | 15356 | 627 | 14442 | 287 | 0.436 | -75.5277 | 2021-07-31 04:21:35 | Putumayo, Colombia | ||
3221943 | 3221943 | 2021-07-26 | Ukraine | Zaporizhia Oblast | 105050 | 2451 | 102312 | 287 | 47.8388 | 35.1396 | 2021-07-27 04:21:18 | Zaporizhia Oblast, Ukraine | ||
1382152 | 1382152 | 2021-07-25 | Ukraine | Zaporizhia Oblast | 105050 | 2451 | 102312 | 287 | 47.8388 | 35.1396 | 2021-07-26 04:21:28 | Zaporizhia Oblast, Ukraine | ||
3137574 | 3137574 | 2021-07-23 | Japan | Miyagi | 9646 | 91 | 9268 | 287 | 38.446859 | 140.927086 | 2021-07-24 00:21:36 | Miyagi, Japan | ||
3476240 | 3476240 | 2021-07-22 | Guinea-Bissau | 4117 | 74 | 3756 | 287 | 11.8037 | -15.1804 | 2021-07-23 04:21:29 | Guinea-Bissau | |||
3476088 | 3476088 | 2021-07-22 | Canada | Saskatchewan | 49556 | 575 | 48694 | 287 | 52.9399 | -106.4509 | 2021-07-23 04:21:29 | Saskatchewan, Canada | ||
3335176 | 3335176 | 2021-07-21 | Ukraine | Zhytomyr Oblast | 88686 | 1801 | 86598 | 287 | 50.2547 | 28.6587 | 2021-07-22 04:21:19 | Zhytomyr Oblast, Ukraine | ||
3331360 | 3331360 | 2021-07-21 | China | Yunnan | 678 | 2 | 389 | 287 | 24.974 | 101.487 | 2021-07-22 04:21:19 | Yunnan, China | ||
295734 | 295734 | 2021-07-15 | Belize | 13644 | 332 | 13025 | 287 | 17.1899 | -88.4976 | 2021-07-16 04:21:22 | Belize | |||
1165181 | 1165181 | 2021-07-04 | Japan | Ibaraki | 10651 | 165 | 10199 | 287 | 36.303588 | 140.319591 | 2021-07-05 04:21:28 | Ibaraki, Japan | ||
1499237 | 1499237 | 2021-07-03 | Ukraine | Mykolaiv Oblast | 69995 | 1847 | 67861 | 287 | 46.975 | 31.9946 | 2021-07-04 04:21:38 | Mykolaiv Oblast, Ukraine | ||
2768570 | 2768570 | 2021-07-01 | Ukraine | Poltava Oblast | 77854 | 1859 | 75708 | 287 | 49.5883 | 34.5514 | 2021-07-02 04:21:47 | Poltava Oblast, Ukraine | ||
1893253 | 1893253 | 2021-06-30 | Montenegro | 100252 | 1613 | 98352 | 287 | 42.708678000000006 | 19.37439 | 2021-07-01 04:21:19 | Montenegro | |||
2590015 | 2590015 | 2021-06-27 | Japan | Ibaraki | 10477 | 163 | 10027 | 287 | 36.303588 | 140.319591 | 2021-06-28 04:21:29 | Ibaraki, Japan | ||
2884507 | 2884507 | 2021-06-20 | North Macedonia | 155624 | 5475 | 149862 | 287 | 41.6086 | 21.7453 | 2021-06-21 04:21:41 | North Macedonia | |||
2884389 | 2884389 | 2021-06-20 | Japan | Kyoto | 16459 | 235 | 15937 | 287 | 35.253815 | 135.443341 | 2021-06-21 04:21:41 | Kyoto, Japan | ||
1125778 | 1125778 | 2021-06-18 | Russia | Adygea Republic | 14823 | 223 | 14313 | 287 | 44.6939006 | 40.1520421 | 2021-06-19 04:22:33 | Adygea Republic, Russia | ||
825622 | 825622 | 2021-06-06 | Japan | Tochigi | 6488 | 78 | 6123 | 287 | 36.689912 | 139.819213 | 2021-06-07 04:22:51 | Tochigi, Japan | ||
825597 | 825597 | 2021-06-06 | Japan | Ishikawa | 3839 | 109 | 3443 | 287 | 36.769464 | 136.771027 | 2021-06-07 04:22:51 | Ishikawa, Japan | ||
20555 | 20555 | 2021-05-28 | Russia | Amur Oblast | 22696 | 291 | 22118 | 287 | 52.8032368 | 128.437295 | 2021-05-29 04:20:41 | Amur Oblast, Russia | ||
83119 | 83119 | 2021-05-25 | Japan | Miyazaki | 2986 | 25 | 2674 | 287 | 32.193203999999994 | 131.299374 | 2021-05-26 04:20:35 | Miyazaki, Japan | ||
1771359 | 1771359 | 2021-05-23 | Japan | Kagawa | 1938 | 24 | 1627 | 287 | 34.217292 | 133.969047 | 2021-05-24 04:20:53 | Kagawa, Japan | ||
3954537 | 3954537 | 2021-05-11 | Japan | Wakayama | 2389 | 34 | 2068 | 287 | 33.911879 | 135.505446 | 2021-05-12 04:21:29 | Wakayama, Japan | ||
2824787 | 2824787 | 2021-05-01 | Japan | Aomori | 1598 | 22 | 1289 | 287 | 40.781541 | 140.828896 | 2021-05-02 04:20:48 | Aomori, Japan | ||
380240 | 380240 | 2021-04-30 | Japan | Yamaguchi | 1834 | 44 | 1503 | 287 | 34.201190000000004 | 131.573293 | 2021-05-01 04:20:47 | Yamaguchi, Japan | ||
888146 | 888146 | 2021-04-26 | Japan | Nagasaki | 1967 | 40 | 1640 | 287 | 33.235712 | 129.608033 | 2021-04-27 04:20:52 | Nagasaki, Japan | ||
3245991 | 3245991 | 2021-04-21 | Vietnam | 2812 | 35 | 2490 | 287 | 14.058324 | 108.277199 | 2021-04-22 04:20:53 | Vietnam | |||
605594 | 605594 | 2021-04-09 | Gambia | 5564 | 166 | 5111 | 287 | 13.4432 | -15.3101 | 2021-04-10 04:20:59 | Gambia | |||
2645658 | 2645658 | 2021-04-08 | Gambia | 5564 | 166 | 5111 | 287 | 13.4432 | -15.3101 | 2021-04-09 04:21:13 | Gambia | |||
2247300 | 2247300 | 2021-04-07 | Gambia | 5564 | 166 | 5111 | 287 | 13.4432 | -15.3101 | 2021-04-08 04:21:13 | Gambia | |||
3003210 | 3003210 | 2021-04-06 | Gambia | 5564 | 166 | 5111 | 287 | 13.4432 | -15.3101 | 2021-04-07 04:20:53 | Gambia | |||
3085507 | 3085507 | 2021-04-05 | Russia | Kemerovo Oblast | 33518 | 620 | 32611 | 287 | 54.53357809999999 | 87.342861 | 2021-04-06 04:20:32 | Kemerovo Oblast, Russia | ||
388248 | 388248 | 2021-04-04 | Japan | Nagano | 2934 | 41 | 2606 | 287 | 36.132134 | 138.045528 | 2021-04-05 04:20:35 | Nagano, Japan | ||
241293 | 241293 | 2021-04-02 | Japan | Shizuoka | 5770 | 118 | 5365 | 287 | 34.916975 | 138.40778400000002 | 2021-04-03 04:20:44 | Shizuoka, Japan | ||
1539604 | 1539604 | 2021-03-28 | Malaysia | Melaka | 6482 | 22 | 6173 | 287 | 2.1896 | 102.2501 | 2021-03-29 04:28:35 | Melaka, Malaysia | ||
1535966 | 1535966 | 2021-03-28 | Japan | Shizuoka | 5646 | 115 | 5244 | 287 | 34.916975 | 138.40778400000002 | 2021-03-29 04:28:35 | Shizuoka, Japan | ||
1223244 | 1223244 | 2021-03-27 | Malaysia | Melaka | 6477 | 22 | 6168 | 287 | 2.1896 | 102.2501 | 2021-03-28 05:28:10 | Melaka, Malaysia | ||
1219409 | 1219409 | 2021-03-27 | Colombia | Casanare | 12947 | 299 | 12361 | 287 | 5.7589 | -71.5724 | 2021-03-28 05:28:10 | Casanare, Colombia | ||
1732336 | 1732336 | 2021-03-14 | Colombia | Casanare | 12624 | 283 | 12054 | 287 | 5.7589 | -71.5724 | 2021-03-15 05:25:51 | Casanare, Colombia | ||
3670169 | 3670169 | 2021-03-06 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-07 05:21:54 | Harmon, Oklahoma, US |
1618790 | 1618790 | 2021-03-05 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-06 04:23:41 | Harmon, Oklahoma, US |
2210201 | 2210201 | 2021-03-04 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-05 05:26:29 | Harmon, Oklahoma, US |
1093136 | 1093136 | 2021-03-03 | US | Texas | Delta | 48119 | 932 | 10 | 0 | 287 | 33.38570922 | -95.66921122 | 2021-03-04 05:24:24 | Delta, Texas, US |
1092622 | 1092622 | 2021-03-03 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-04 05:24:24 | Harmon, Oklahoma, US |
3257208 | 3257208 | 2021-03-02 | US | Texas | Delta | 48119 | 932 | 10 | 0 | 287 | 33.38570922 | -95.66921122 | 2021-03-03 05:23:28 | Delta, Texas, US |
3256694 | 3256694 | 2021-03-02 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-03 05:23:28 | Harmon, Oklahoma, US |
1001500 | 1001500 | 2021-03-01 | US | Texas | Delta | 48119 | 932 | 10 | 0 | 287 | 33.38570922 | -95.66921122 | 2021-03-02 05:23:30 | Delta, Texas, US |
1000986 | 1000986 | 2021-03-01 | US | Oklahoma | Harmon | 40057 | 290 | 3 | 0 | 287 | 34.7440135 | -99.84741652 | 2021-03-02 05:23:30 | Harmon, Oklahoma, US |
2370558 | 2370558 | 2021-02-28 | US | Texas | Delta | 48119 | 932 | 10 | 0 | 287 | 33.38570922 | -95.66921122 | 2021-03-01 05:23:01 | Delta, Texas, US |
2183423 | 2183423 | 2021-02-26 | Colombia | Caqueta | 17010 | 631 | 16092 | 287 | 0.8699 | -73.8419 | 2021-02-27 05:22:28 | Caqueta, Colombia | ||
745703 | 745703 | 2021-02-20 | US | Virginia | Rappahannock | 51157 | 289 | 2 | 0 | 287 | 38.68295619 | -78.15826963 | 2021-02-21 05:24:33 | Rappahannock, Virginia, US |
474923 | 474923 | 2021-02-19 | US | West Virginia | Webster | 54101 | 289 | 2 | 0 | 287 | 38.49370949 | -80.4202023 | 2021-02-20 05:22:51 | Webster, West Virginia, US |
1156776 | 1156776 | 2021-02-18 | United Kingdom | Turks and Caicos Islands | 1928 | 13 | 1628 | 287 | 21.694000000000006 | -71.7979 | 2021-02-19 05:24:16 | Turks and Caicos Islands, United Kingdom | ||
1153390 | 1153390 | 2021-02-18 | San Marino | 3394 | 72 | 3035 | 287 | 43.9424 | 12.4578 | 2021-02-19 05:24:16 | San Marino | |||
3053528 | 3053528 | 2021-02-16 | US | Virginia | King and Queen | 51097 | 291 | 4 | 0 | 287 | 37.71044922 | -76.88689628 | 2021-02-17 05:23:10 | King and Queen, Virginia, US |
3542811 | 3542811 | 2021-02-12 | US | Virginia | King and Queen | 51097 | 291 | 4 | 0 | 287 | 37.71044922 | -76.88689628 | 2021-02-13 05:22:12 | King and Queen, Virginia, US |
3541871 | 3541871 | 2021-02-12 | US | North Dakota | Renville | 38075 | 301 | 13 | 0 | 287 | 48.71982533 | -101.6603912 | 2021-02-13 05:22:12 | Renville, North Dakota, US |
616425 | 616425 | 2021-02-08 | US | Puerto Rico | Hormigueros | 72067 | 287 | 0 | 0 | 287 | 18.134532 | -67.113972 | 2021-02-09 05:23:30 | Hormigueros, Puerto Rico, US |
613696 | 613696 | 2021-02-08 | Japan | Gifu | 4359 | 82 | 3990 | 287 | 35.778671 | 137.055925 | 2021-02-09 05:23:30 | Gifu, Japan | ||
613397 | 613397 | 2021-02-08 | Barbados | 1732 | 18 | 1427 | 287 | 13.1939 | -59.5432 | 2021-02-09 05:23:30 | Barbados | |||
1589036 | 1589036 | 2021-02-05 | US | Georgia | Schley | 13249 | 289 | 2 | 0 | 287 | 32.2654021 | -84.31258912 | 2021-02-06 05:23:55 | Schley, Georgia, US |
792146 | 792146 | 2021-02-04 | US | Minnesota | Traverse | 27155 | 291 | 4 | 0 | 287 | 45.77298854 | -96.47062949 | 2021-02-05 05:22:38 | Traverse, Minnesota, US |
1685414 | 1685414 | 2021-02-02 | US | Idaho | Boise | 16015 | 289 | 2 | 0 | 287 | 43.98829931 | -115.7309284 | 2021-02-03 05:22:52 | Boise, Idaho, US |
2214089 | 2214089 | 2021-01-30 | US | North Dakota | Towner | 38095 | 298 | 11 | 0 | 287 | 48.68565745 | -99.24564265 | 2021-01-31 05:22:42 | Towner, North Dakota, US |
1899576 | 1899576 | 2021-01-29 | US | North Dakota | Towner | 38095 | 297 | 11 | 0 | 287 | 48.68565745 | -99.24564265 | 2021-01-30 05:22:49 | Towner, North Dakota, US |
2484392 | 2484392 | 2021-01-28 | US | North Dakota | Towner | 38095 | 297 | 11 | 0 | 287 | 48.68565745 | -99.24564265 | 2021-01-29 05:22:23 | Towner, North Dakota, US |
2482614 | 2482614 | 2021-01-28 | US | Colorado | Saguache | 8109 | 299 | 4 | 0 | 287 | 38.08054629 | -106.282466 | 2021-01-29 05:22:23 | Saguache, Colorado, US |
2482305 | 2482305 | 2021-01-28 | Trinidad and Tobago | 7520 | 134 | 7099 | 287 | 10.6918 | -61.2225 | 2021-01-29 05:22:23 | Trinidad and Tobago | |||
3156027 | 3156027 | 2021-01-27 | US | North Dakota | Towner | 38095 | 297 | 11 | 0 | 287 | 48.68565745 | -99.24564265 | 2021-01-28 05:22:24 | Towner, North Dakota, US |
3154249 | 3154249 | 2021-01-27 | US | Colorado | Saguache | 8109 | 299 | 4 | 0 | 287 | 38.08054629 | -106.282466 | 2021-01-28 05:22:24 | Saguache, Colorado, US |
2428340 | 2428340 | 2021-01-23 | US | Kentucky | Menifee | 21165 | 291 | 4 | 0 | 287 | 37.94090733 | -83.59985712 | 2021-01-24 05:22:35 | Menifee, Kentucky, US |
2469941 | 2469941 | 2021-01-22 | US | Texas | Kinney | 48271 | 343 | 3 | 0 | 287 | 29.34967888 | -100.4186638 | 2021-01-23 05:22:03 | Kinney, Texas, US |
438492 | 438492 | 2021-01-21 | US | Texas | Kinney | 48271 | 343 | 3 | 0 | 287 | 29.34967888 | -100.4186638 | 2021-01-22 05:22:10 | Kinney, Texas, US |
437475 | 437475 | 2021-01-21 | US | Nebraska | Valley | 31175 | 290 | 3 | 0 | 287 | 41.56730777 | -98.98197724 | 2021-01-22 05:22:10 | Valley, Nebraska, US |
1097528 | 1097528 | 2021-01-20 | US | Washington | Lincoln | 53043 | 292 | 5 | 0 | 287 | 47.57705241 | -118.4194388 | 2021-01-21 05:22:01 | Lincoln, Washington, US |
3104953 | 3104953 | 2021-01-16 | US | West Virginia | Wirt | 54105 | 288 | 1 | 0 | 287 | 39.02775007 | -81.37473928 | 2021-01-17 05:22:17 | Wirt, West Virginia, US |
3104495 | 3104495 | 2021-01-16 | US | Texas | Culberson | 48109 | 265 | 4 | 0 | 287 | 31.44506775 | -104.5185739 | 2021-01-17 05:22:17 | Culberson, Texas, US |
3101899 | 3101899 | 2021-01-16 | US | Arkansas | Calhoun | 5013 | 289 | 2 | 0 | 287 | 33.55598792 | -92.49974403 | 2021-01-17 05:22:17 | Calhoun, Arkansas, US |
3101507 | 3101507 | 2021-01-16 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-17 05:22:17 | Madagascar | |||
3515543 | 3515543 | 2021-01-15 | Pakistan | Balochistan | 18537 | 190 | 18060 | 287 | 28.328492 | 65.898403 | 2021-01-16 05:22:40 | Balochistan, Pakistan | ||
3515469 | 3515469 | 2021-01-15 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-16 05:22:40 | Madagascar | |||
3883041 | 3883041 | 2021-01-14 | US | West Virginia | Clay | 54015 | 291 | 4 | 0 | 287 | 38.46231092 | -81.07652217 | 2021-01-15 05:22:24 | Clay, West Virginia, US |
3879642 | 3879642 | 2021-01-14 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-15 05:22:24 | Madagascar | |||
3311473 | 3311473 | 2021-01-13 | US | Vermont | Caledonia | 50005 | 291 | 4 | 0 | 287 | 44.46548598 | -72.10314651 | 2021-01-14 05:22:32 | Caledonia, Vermont, US |
3308269 | 3308269 | 2021-01-13 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-14 05:22:32 | Madagascar | |||
3307963 | 3307963 | 2021-01-13 | Burundi | 1062 | 2 | 773 | 287 | -3.3731 | 29.9189 | 2021-01-14 05:22:32 | Burundi | |||
777992 | 777992 | 2021-01-12 | United Kingdom | Channel Islands | 0 | 0 | 2948 | 287 | 49.3723 | -2.3644 | 2021-01-13 05:22:15 | Channel Islands, United Kingdom | ||
775687 | 775687 | 2021-01-12 | US | Kansas | Stafford | 20185 | 296 | 9 | 0 | 287 | 38.03100851 | -98.71762001 | 2021-01-13 05:22:15 | Stafford, Kansas, US |
775254 | 775254 | 2021-01-12 | US | Idaho | Adams | 16003 | 290 | 3 | 0 | 287 | 44.89333571 | -116.4545247 | 2021-01-13 05:22:15 | Adams, Idaho, US |
774414 | 774414 | 2021-01-12 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-13 05:22:15 | Madagascar | |||
191408 | 191408 | 2021-01-11 | US | Kansas | Stafford | 20185 | 296 | 9 | 0 | 287 | 38.03100851 | -98.71762001 | 2021-01-12 05:22:15 | Stafford, Kansas, US |
190975 | 190975 | 2021-01-11 | US | Idaho | Adams | 16003 | 290 | 3 | 0 | 287 | 44.89333571 | -116.4545247 | 2021-01-12 05:22:15 | Adams, Idaho, US |
190135 | 190135 | 2021-01-11 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-12 05:22:15 | Madagascar | |||
2627211 | 2627211 | 2021-01-10 | US | Kansas | Stafford | 20185 | 296 | 9 | 0 | 287 | 38.03100851 | -98.71762001 | 2021-01-11 05:21:50 | Stafford, Kansas, US |
2626145 | 2626145 | 2021-01-10 | Seychelles | 502 | 1 | 214 | 287 | -4.6796 | 55.492 | 2021-01-11 05:21:50 | Seychelles | |||
2625938 | 2625938 | 2021-01-10 | Madagascar | 18001 | 267 | 17447 | 287 | -18.766947 | 46.869107 | 2021-01-11 05:21:50 | Madagascar | |||
3901299 | 3901299 | 2021-01-09 | US | Kansas | Stafford | 20185 | 296 | 9 | 0 | 287 | 38.03100851 | -98.71762001 | 2021-01-10 05:22:12 | Stafford, Kansas, US |
156870 | 156870 | 2021-01-08 | US | South Dakota | Perkins | 46105 | 298 | 11 | 0 | 287 | 45.49049506 | -102.4755586 | 2021-01-09 05:22:18 | Perkins, South Dakota, 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]);