daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
376 rows where active = 565 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Madagascar | 42685 | 943 | 41177 | 565 | -18.766947 | 46.869107 | 2021-08-05 04:21:51 | Madagascar | |||
2021-08-02 | Madagascar | 42672 | 943 | 41164 | 565 | -18.766947 | 46.869107 | 2021-08-03 04:21:39 | Madagascar | |||
2021-07-27 | Italy | Basilicata | 27253 | 591 | 26097 | 565 | 40.63947052 | 15.80514834 | 2021-07-28 04:21:39 | Basilicata, Italy | ||
2021-07-19 | Chile | Atacama | 26289 | 300 | 25424 | 565 | -27.5661 | -70.0503 | 2021-07-20 04:21:48 | Atacama, Chile | ||
2021-07-16 | Latvia | 138087 | 2542 | 134980 | 565 | 56.8796 | 24.6032 | 2021-07-17 04:22:22 | Latvia | |||
2021-07-15 | Ukraine | Kiev Oblast | 127880 | 2759 | 124556 | 565 | 50.053 | 30.7667 | 2021-07-16 04:21:22 | Kiev Oblast, Ukraine | ||
2021-07-11 | Slovenia | 257863 | 4423 | 252875 | 565 | 46.1512 | 14.9955 | 2021-07-12 04:21:34 | Slovenia | |||
2021-06-25 | Russia | Kurgan Oblast | 22160 | 442 | 21153 | 565 | 55.7655302 | 64.5632681 | 2021-06-26 04:21:43 | Kurgan Oblast, Russia | ||
2021-06-19 | Malaysia | Terengganu | 10925 | 70 | 10290 | 565 | 5.3117 | 103.1324 | 2021-06-20 04:21:48 | Terengganu, Malaysia | ||
2021-05-24 | Japan | Ibaraki | 9427 | 143 | 8719 | 565 | 36.303588 | 140.319591 | 2021-05-25 04:21:08 | Ibaraki, Japan | ||
2021-04-24 | Bahamas | 9976 | 196 | 9215 | 565 | 25.025885 | -78.035889 | 2021-04-25 04:20:32 | Bahamas | |||
2021-04-23 | Bahamas | 9976 | 196 | 9215 | 565 | 25.025885 | -78.035889 | 2021-04-24 04:20:38 | Bahamas | |||
2021-04-19 | Suriname | 9581 | 187 | 8829 | 565 | 3.9193 | -56.0278 | 2021-04-20 04:20:41 | Suriname | |||
2021-04-18 | Suriname | 9581 | 187 | 8829 | 565 | 3.9193 | -56.0278 | 2021-04-19 04:20:57 | Suriname | |||
2021-04-16 | India | Meghalaya | 14703 | 152 | 13986 | 565 | 25.536934 | 91.278882 | 2021-04-17 04:20:40 | Meghalaya, India | ||
2021-04-15 | Russia | Tomsk Oblast | 31758 | 377 | 30816 | 565 | 58.6124279 | 82.04753149999998 | 2021-04-16 04:20:46 | Tomsk Oblast, Russia | ||
2021-04-12 | Japan | Fukuoka | 19520 | 341 | 18614 | 565 | 33.526032 | 130.666949 | 2021-04-13 04:20:37 | Fukuoka, Japan | ||
2021-04-07 | Guinea-Bissau | 3663 | 66 | 3032 | 565 | 11.8037 | -15.1804 | 2021-04-08 04:21:13 | Guinea-Bissau | |||
2021-04-07 | Colombia | Quindio | 35515 | 1064 | 33886 | 565 | 4.461 | -75.6674 | 2021-04-08 04:21:13 | Quindio, Colombia | ||
2021-03-22 | Italy | Valle d'Aosta | 8655 | 419 | 7671 | 565 | 45.73750286 | 7.320149366 | 2021-03-23 05:26:18 | Valle d'Aosta, Italy | ||
2021-03-15 | Chile | Arica y Parinacota | 16151 | 329 | 15257 | 565 | -18.594 | -69.4785 | 2021-03-16 05:25:13 | Arica y Parinacota, Chile | ||
2021-03-09 | Thailand | 26501 | 85 | 25851 | 565 | 15.870032 | 100.992541 | 2021-03-10 05:24:35 | Thailand | |||
2021-03-06 | US | Georgia | Calhoun | 13037 | 580 | 15 | 0 | 565 | 31.53169785 | -84.62725131 | 2021-03-07 05:21:54 | Calhoun, Georgia, US |
2021-03-05 | US | Puerto Rico | Guayama | 72057 | 565 | 0 | 0 | 565 | 18.007516 | -66.13390799999999 | 2021-03-06 04:23:41 | Guayama, Puerto Rico, US |
2021-02-25 | US | North Dakota | McHenry | 38049 | 586 | 21 | 0 | 565 | 48.23104458 | -100.6324822 | 2021-02-26 05:22:40 | McHenry, North Dakota, US |
2021-02-24 | US | North Dakota | McHenry | 38049 | 586 | 21 | 0 | 565 | 48.23104458 | -100.6324822 | 2021-02-25 05:24:57 | McHenry, North Dakota, US |
2021-02-24 | US | North Carolina | Camden | 37029 | 570 | 5 | 0 | 565 | 36.33804939 | -76.15568396 | 2021-02-25 05:24:57 | Camden, North Carolina, US |
2021-02-23 | US | Georgia | Randolph | 13243 | 597 | 32 | 0 | 565 | 31.76622818 | -84.75732369 | 2021-02-24 05:29:16 | Randolph, Georgia, US |
2021-02-21 | US | Maine | Lincoln | 23015 | 566 | 1 | 0 | 565 | 44.05996956 | -69.54227124 | 2021-02-22 05:24:21 | Lincoln, Maine, US |
2021-02-20 | Colombia | Quindio | 31601 | 928 | 30108 | 565 | 4.461 | -75.6674 | 2021-02-21 05:24:33 | Quindio, Colombia | ||
2021-02-16 | US | Georgia | Twiggs | 13289 | 597 | 32 | 0 | 565 | 32.67435595 | -83.43078662 | 2021-02-17 05:23:10 | Twiggs, Georgia, US |
2021-02-16 | India | Bihar | 261841 | 1528 | 259748 | 565 | 25.679658 | 85.60484 | 2021-02-17 05:23:10 | Bihar, India | ||
2021-02-12 | US | West Virginia | Pocahontas | 54075 | 574 | 9 | 0 | 565 | 38.32758728 | -80.00993811 | 2021-02-13 05:22:12 | Pocahontas, West Virginia, US |
2021-02-12 | US | Missouri | St. Clair | 29185 | 572 | 7 | 0 | 565 | 38.03699437 | -93.77631447 | 2021-02-13 05:22:12 | St. Clair, Missouri, US |
2021-02-12 | US | Michigan | Crawford | 26039 | 570 | 5 | 0 | 565 | 44.68255561 | -84.61006219 | 2021-02-13 05:22:12 | Crawford, Michigan, US |
2021-02-11 | US | West Virginia | Pocahontas | 54075 | 574 | 9 | 0 | 565 | 38.32758728 | -80.00993811 | 2021-02-12 05:23:29 | Pocahontas, West Virginia, US |
2021-02-10 | US | Virginia | Emporia | 51595 | 600 | 35 | 0 | 565 | 36.69455571 | -77.53406129 | 2021-02-11 05:23:55 | Emporia, Virginia, US |
2021-02-10 | US | Puerto Rico | Ciales | 72039 | 565 | 0 | 0 | 565 | 18.28885 | -66.516475 | 2021-02-11 05:23:55 | Ciales, Puerto Rico, US |
2021-02-10 | US | Michigan | Crawford | 26039 | 570 | 5 | 0 | 565 | 44.68255561 | -84.61006219 | 2021-02-11 05:23:55 | Crawford, Michigan, US |
2021-02-09 | US | Virginia | Emporia | 51595 | 600 | 35 | 0 | 565 | 36.69455571 | -77.53406129 | 2021-02-10 05:22:41 | Emporia, Virginia, US |
2021-02-09 | US | Puerto Rico | Ciales | 72039 | 565 | 0 | 0 | 565 | 18.28885 | -66.516475 | 2021-02-10 05:22:41 | Ciales, Puerto Rico, US |
2021-02-08 | US | Missouri | St. Clair | 29185 | 572 | 7 | 0 | 565 | 38.03699437 | -93.77631447 | 2021-02-09 05:23:30 | St. Clair, Missouri, US |
2021-02-07 | Cabo Verde | 14423 | 135 | 13723 | 565 | 16.5388 | -23.0418 | 2021-02-08 05:22:39 | Cabo Verde | |||
2021-02-04 | US | West Virginia | Ritchie | 54085 | 573 | 8 | 0 | 565 | 39.18094587 | -81.06356878 | 2021-02-05 05:22:38 | Ritchie, West Virginia, US |
2021-02-04 | US | Missouri | Daviess | 29061 | 576 | 11 | 0 | 565 | 39.96145298 | -93.98519678 | 2021-02-05 05:22:38 | Daviess, Missouri, US |
2021-02-03 | US | Kentucky | Owen | 21187 | 572 | 7 | 0 | 565 | 38.51679143 | -84.82404619 | 2021-02-04 05:22:26 | Owen, Kentucky, US |
2021-02-03 | US | Georgia | Crawford | 13079 | 577 | 12 | 0 | 565 | 32.71391813 | -83.98061238 | 2021-02-04 05:22:26 | Crawford, Georgia, US |
2021-02-03 | US | Colorado | Lake | 8065 | 605 | 0 | 0 | 565 | 39.20278823 | -106.3555697 | 2021-02-04 05:22:26 | Lake, Colorado, US |
2021-02-03 | Colombia | Caqueta | 16691 | 597 | 15529 | 565 | 0.8699 | -73.8419 | 2021-02-04 05:22:26 | Caqueta, Colombia | ||
2021-02-01 | US | Texas | Red River | 48387 | 639 | 32 | 0 | 565 | 33.61886692 | -95.04841765 | 2021-02-02 05:22:49 | Red River, Texas, US |
2021-01-30 | US | West Virginia | Tyler | 54095 | 569 | 4 | 0 | 565 | 39.46811972 | -80.88772676 | 2021-01-31 05:22:42 | Tyler, West Virginia, US |
2021-01-30 | US | Puerto Rico | Anasco | 72011 | 565 | 0 | 0 | 565 | 18.287985 | -67.120611 | 2021-01-31 05:22:42 | Anasco, Puerto Rico, US |
2021-01-30 | US | North Carolina | Jones | 37103 | 581 | 16 | 0 | 565 | 35.02254606 | -77.35870791 | 2021-01-31 05:22:42 | Jones, North Carolina, US |
2021-01-29 | US | North Carolina | Jones | 37103 | 581 | 16 | 0 | 565 | 35.02254606 | -77.35870791 | 2021-01-30 05:22:49 | Jones, North Carolina, US |
2021-01-27 | US | Puerto Rico | Naguabo | 72103 | 565 | 0 | 0 | 565 | 18.230637 | -65.753897 | 2021-01-28 05:22:24 | Naguabo, Puerto Rico, US |
2021-01-27 | US | Missouri | Monroe | 29137 | 572 | 7 | 0 | 565 | 39.49593978 | -92.00043978 | 2021-01-28 05:22:24 | Monroe, Missouri, US |
2021-01-27 | US | Kentucky | Cumberland | 21057 | 572 | 7 | 0 | 565 | 36.78926125 | -85.39050034 | 2021-01-28 05:22:24 | Cumberland, Kentucky, US |
2021-01-26 | US | Missouri | Monroe | 29137 | 572 | 7 | 0 | 565 | 39.49593978 | -92.00043978 | 2021-01-27 05:23:41 | Monroe, Missouri, US |
2021-01-26 | US | Kansas | Sherman | 20181 | 575 | 10 | 0 | 565 | 39.35147699 | -101.7197624 | 2021-01-27 05:23:41 | Sherman, Kansas, US |
2021-01-25 | US | Kansas | Sherman | 20181 | 575 | 10 | 0 | 565 | 39.35147699 | -101.7197624 | 2021-01-26 05:22:02 | Sherman, Kansas, US |
2021-01-25 | Eritrea | 1950 | 7 | 1378 | 565 | 15.1794 | 39.7823 | 2021-01-26 05:22:02 | Eritrea | |||
2021-01-24 | US | North Carolina | Hyde | 37095 | 571 | 6 | 0 | 565 | 35.42017674 | -76.15180542 | 2021-01-25 05:22:16 | Hyde, North Carolina, US |
2021-01-24 | US | North Carolina | Clay | 37043 | 570 | 5 | 0 | 565 | 35.05704275 | -83.74353633 | 2021-01-25 05:22:16 | Clay, North Carolina, US |
2021-01-24 | Colombia | Sucre | 18827 | 700 | 17562 | 565 | 8.814 | -74.7233 | 2021-01-25 05:22:16 | Sucre, Colombia | ||
2021-01-23 | US | South Dakota | Day | 46037 | 590 | 25 | 0 | 565 | 45.367281 | -97.60737498 | 2021-01-24 05:22:35 | Day, South Dakota, US |
2021-01-22 | US | Texas | Franklin | 48159 | 699 | 16 | 0 | 565 | 33.17653242 | -95.21917243 | 2021-01-23 05:22:03 | Franklin, Texas, US |
2021-01-20 | US | South Dakota | Lyman | 46085 | 575 | 10 | 0 | 565 | 43.89522709 | -99.85201878 | 2021-01-21 05:22:01 | Lyman, South Dakota, US |
2021-01-19 | US | Nebraska | Dawes | 31045 | 583 | 18 | 0 | 565 | 42.71985036 | -103.1313774 | 2021-01-20 05:21:54 | Dawes, Nebraska, US |
2021-01-18 | US | Nebraska | Dawes | 31045 | 583 | 18 | 0 | 565 | 42.71985036 | -103.1313774 | 2021-01-19 05:22:15 | Dawes, Nebraska, US |
2021-01-18 | US | Kentucky | Livingston | 21139 | 580 | 15 | 0 | 565 | 37.21137452 | -88.34797529 | 2021-01-19 05:22:15 | Livingston, Kentucky, US |
2021-01-17 | US | Virginia | Bland | 51021 | 572 | 7 | 0 | 565 | 37.13128068 | -81.13599391 | 2021-01-18 05:22:34 | Bland, Virginia, US |
2021-01-17 | US | Nebraska | Dawes | 31045 | 583 | 18 | 0 | 565 | 42.71985036 | -103.1313774 | 2021-01-18 05:22:34 | Dawes, Nebraska, US |
2021-01-13 | US | Virginia | King William | 51101 | 569 | 4 | 0 | 565 | 37.70965316 | -77.09384941 | 2021-01-14 05:22:32 | King William, Virginia, US |
2021-01-13 | US | Minnesota | Koochiching | 27071 | 575 | 10 | 0 | 565 | 48.24539665 | -93.78352843 | 2021-01-14 05:22:32 | Koochiching, Minnesota, US |
2021-01-12 | US | South Carolina | Allendale | 45005 | 576 | 11 | 0 | 565 | 32.98837386 | -81.35321066 | 2021-01-13 05:22:15 | Allendale, South Carolina, US |
2021-01-11 | US | Vermont | Rutland | 50021 | 574 | 9 | 0 | 565 | 43.57723578 | -73.03741676 | 2021-01-12 05:22:15 | Rutland, Vermont, US |
2021-01-11 | US | North Carolina | Washington | 37187 | 581 | 16 | 0 | 565 | 35.83810081 | -76.57299037 | 2021-01-12 05:22:15 | Washington, North Carolina, US |
2021-01-09 | US | Georgia | Lanier | 13173 | 575 | 10 | 0 | 565 | 31.038285700000007 | -83.06472457 | 2021-01-10 05:22:12 | Lanier, Georgia, US |
2021-01-07 | US | Nebraska | Clay | 31035 | 574 | 9 | 0 | 565 | 40.52439441 | -98.05126296 | 2021-01-08 05:22:42 | Clay, Nebraska, US |
2021-01-06 | US | Nebraska | Jefferson | 31095 | 566 | 1 | 0 | 565 | 40.17584531 | -97.142601 | 2021-01-07 05:22:03 | Jefferson, Nebraska, US |
2021-01-06 | Guinea | 13845 | 81 | 13199 | 565 | 9.9456 | -9.6966 | 2021-01-07 05:22:03 | Guinea | |||
2021-01-05 | US | Kentucky | Morgan | 21175 | 565 | 0 | 0 | 565 | 37.92465657 | -83.25558245 | 2021-01-06 05:22:16 | Morgan, Kentucky, US |
2021-01-05 | Guinea | 13845 | 81 | 13199 | 565 | 9.9456 | -9.6966 | 2021-01-06 05:22:16 | Guinea | |||
2021-01-04 | US | Kentucky | Morgan | 21175 | 565 | 0 | 0 | 565 | 37.92465657 | -83.25558245 | 2021-01-05 05:21:49 | Morgan, Kentucky, US |
2020-12-30 | US | Nebraska | Merrick | 31121 | 576 | 11 | 0 | 565 | 41.16624273 | -98.0374887 | 2020-12-31 05:22:49 | Merrick, Nebraska, US |
2020-12-30 | Maldives | 13738 | 48 | 13125 | 565 | 3.2028 | 73.2207 | 2020-12-31 05:22:49 | Maldives | |||
2020-12-29 | US | Puerto Rico | Fajardo | 72053 | 565 | 0 | 0 | 565 | 18.318373 | -65.666866 | 2020-12-30 05:22:34 | Fajardo, Puerto Rico, US |
2020-12-28 | US | Puerto Rico | Aguas Buenas | 72007 | 565 | 0 | 0 | 565 | 18.251619 | -66.126806 | 2020-12-29 05:22:37 | Aguas Buenas, Puerto Rico, US |
2020-12-28 | US | Georgia | Hancock | 13141 | 612 | 47 | 0 | 565 | 33.2721566 | -82.99766919 | 2020-12-29 05:22:37 | Hancock, Georgia, US |
2020-12-27 | US | South Dakota | Hamlin | 46057 | 597 | 32 | 0 | 565 | 44.67385954 | -97.18829593 | 2020-12-28 05:22:06 | Hamlin, South Dakota, US |
2020-12-27 | US | Arkansas | Nevada | 5099 | 585 | 20 | 0 | 565 | 33.66340119 | -93.30632432 | 2020-12-28 05:22:06 | Nevada, Arkansas, US |
2020-12-25 | US | Kentucky | Metcalfe | 21169 | 572 | 7 | 0 | 565 | 36.99459295 | -85.63123699 | 2020-12-26 05:22:28 | Metcalfe, Kentucky, US |
2020-12-24 | US | Kentucky | Metcalfe | 21169 | 572 | 7 | 0 | 565 | 36.99459295 | -85.63123699 | 2020-12-25 05:22:48 | Metcalfe, Kentucky, US |
2020-12-23 | US | Virginia | Brunswick | 51025 | 572 | 7 | 0 | 565 | 36.76366949 | -77.8593436 | 2020-12-24 05:23:04 | Brunswick, Virginia, US |
2020-12-23 | US | Minnesota | Wilkin | 27167 | 571 | 6 | 0 | 565 | 46.35721532 | -96.4684375 | 2020-12-24 05:23:04 | Wilkin, Minnesota, US |
2020-12-23 | US | Kentucky | Metcalfe | 21169 | 572 | 7 | 0 | 565 | 36.99459295 | -85.63123699 | 2020-12-24 05:23:04 | Metcalfe, Kentucky, US |
2020-12-22 | US | Kansas | Clay | 20027 | 582 | 17 | 0 | 565 | 39.34948772 | -97.16518128 | 2020-12-23 05:22:03 | Clay, Kansas, US |
2020-12-22 | US | Georgia | Irwin | 13155 | 581 | 16 | 0 | 565 | 31.60213036 | -83.27501387 | 2020-12-23 05:22:03 | Irwin, Georgia, US |
2020-12-21 | US | Michigan | Antrim | 26009 | 573 | 8 | 0 | 565 | 44.99690221 | -85.15503082 | 2020-12-22 05:22:33 | Antrim, Michigan, US |
2020-12-21 | US | Kansas | Clay | 20027 | 582 | 17 | 0 | 565 | 39.34948772 | -97.16518128 | 2020-12-22 05:22:33 | Clay, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;