daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
412 rows where active = 556 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-04 | Germany | Sachsen | 285904 | 10084 | 275300 | 556 | 51.1045 | 13.2017 | 2021-07-05 04:21:28 | Sachsen, Germany | ||
2021-06-18 | Russia | Kamchatka Krai | 14886 | 238 | 14092 | 556 | 57.1914882 | 160.03838190000005 | 2021-06-19 04:22:33 | Kamchatka Krai, Russia | ||
2021-06-07 | Chile | Tarapaca | 37384 | 685 | 36143 | 556 | -19.9232 | -69.5132 | 2021-06-08 04:22:35 | Tarapaca, Chile | ||
2021-05-30 | Mauritania | 19494 | 463 | 18475 | 556 | 21.0079 | -10.9408 | 2021-05-31 03:08:59 | Mauritania | |||
2021-05-15 | Japan | Nagasaki | 2711 | 50 | 2105 | 556 | 33.235712 | 129.608033 | 2021-05-16 04:20:49 | Nagasaki, Japan | ||
2021-04-13 | Russia | Mari El Republic | 12787 | 218 | 12013 | 556 | 56.5767504 | 47.8817512 | 2021-04-14 04:20:41 | Mari El Republic, Russia | ||
2021-04-08 | Russia | Bryansk Oblast | 36362 | 293 | 35513 | 556 | 52.8873315 | 33.41585300000001 | 2021-04-09 04:21:13 | Bryansk Oblast, Russia | ||
2021-04-08 | Guinea-Bissau | 3664 | 66 | 3042 | 556 | 11.8037 | -15.1804 | 2021-04-09 04:21:13 | Guinea-Bissau | |||
2021-04-02 | Colombia | La Guajira | 18365 | 665 | 17144 | 556 | 11.3548 | -72.5205 | 2021-04-03 04:20:44 | La Guajira, Colombia | ||
2021-03-27 | Colombia | Quindio | 34207 | 1016 | 32635 | 556 | 4.461 | -75.6674 | 2021-03-28 05:28:10 | Quindio, Colombia | ||
2021-03-23 | Chile | Atacama | 13696 | 166 | 12974 | 556 | -27.5661 | -70.0503 | 2021-03-24 05:25:40 | Atacama, Chile | ||
2021-03-20 | Russia | Smolensk Oblast | 27558 | 709 | 26293 | 556 | 55.03434960000001 | 33.0192065 | 2021-03-21 05:25:44 | Smolensk Oblast, Russia | ||
2021-03-15 | India | Jharkhand | 120695 | 1093 | 119046 | 556 | 23.654536 | 85.557631 | 2021-03-16 05:25:13 | Jharkhand, India | ||
2021-03-13 | Colombia | Bolivar | 67904 | 1373 | 65975 | 556 | 8.6704 | -74.03 | 2021-03-14 05:25:37 | Bolivar, Colombia | ||
2021-03-08 | Colombia | Bolivar | 67483 | 1366 | 65561 | 556 | 8.6704 | -74.03 | 2021-03-09 05:28:19 | Bolivar, Colombia | ||
2021-03-06 | US | Nebraska | Dixon | 31051 | 564 | 8 | 0 | 556 | 42.49188363 | -96.86782408 | 2021-03-07 05:21:54 | Dixon, Nebraska, US |
2021-03-05 | India | Uttarakhand | 97285 | 1694 | 95035 | 556 | 30.156447 | 79.197608 | 2021-03-06 04:23:41 | Uttarakhand, India | ||
2021-03-03 | US | Texas | Crockett | 48105 | 427 | 15 | 0 | 556 | 30.72367027 | -101.4134238 | 2021-03-04 05:24:24 | Crockett, Texas, US |
2021-03-03 | Chile | Nuble | 17171 | 323 | 16292 | 556 | -36.7226 | -71.7622 | 2021-03-04 05:24:24 | Nuble, Chile | ||
2021-03-02 | US | Texas | Mitchell | 48335 | 1137 | 29 | 0 | 556 | 32.30623474 | -100.9212058 | 2021-03-03 05:23:28 | Mitchell, Texas, US |
2021-03-02 | US | Texas | Crockett | 48105 | 427 | 15 | 0 | 556 | 30.72367027 | -101.4134238 | 2021-03-03 05:23:28 | Crockett, Texas, US |
2021-03-02 | US | Puerto Rico | Guayama | 72057 | 556 | 0 | 0 | 556 | 18.007516 | -66.13390799999999 | 2021-03-03 05:23:28 | Guayama, Puerto Rico, US |
2021-03-01 | US | Texas | Mitchell | 48335 | 1137 | 29 | 0 | 556 | 32.30623474 | -100.9212058 | 2021-03-02 05:23:30 | Mitchell, Texas, US |
2021-03-01 | US | Texas | Crockett | 48105 | 427 | 15 | 0 | 556 | 30.72367027 | -101.4134238 | 2021-03-02 05:23:30 | Crockett, Texas, US |
2021-02-28 | US | Texas | Mitchell | 48335 | 1137 | 29 | 0 | 556 | 32.30623474 | -100.9212058 | 2021-03-01 05:23:01 | Mitchell, Texas, US |
2021-02-28 | US | Texas | Crockett | 48105 | 427 | 15 | 0 | 556 | 30.72367027 | -101.4134238 | 2021-03-01 05:23:01 | Crockett, Texas, US |
2021-02-27 | US | Texas | Mitchell | 48335 | 1137 | 29 | 0 | 556 | 32.30623474 | -100.9212058 | 2021-02-28 05:22:20 | Mitchell, Texas, US |
2021-02-27 | US | Texas | Crockett | 48105 | 427 | 15 | 0 | 556 | 30.72367027 | -101.4134238 | 2021-02-28 05:22:20 | Crockett, Texas, US |
2021-02-27 | US | Puerto Rico | Cabo Rojo | 72023 | 556 | 0 | 0 | 556 | 18.040993 | -67.154391 | 2021-02-28 05:22:20 | Cabo Rojo, Puerto Rico, US |
2021-02-26 | US | Georgia | Calhoun | 13037 | 571 | 15 | 0 | 556 | 31.53169785 | -84.62725131 | 2021-02-27 05:22:28 | Calhoun, Georgia, US |
2021-02-17 | US | Idaho | Benewah | 16009 | 563 | 7 | 0 | 556 | 47.21754179 | -116.6586851 | 2021-02-18 05:22:58 | Benewah, Idaho, US |
2021-02-16 | US | Wyoming | Platte | 56031 | 567 | 11 | 0 | 556 | 42.13299116 | -104.966331 | 2021-02-17 05:23:10 | Platte, Wyoming, US |
2021-02-12 | US | Georgia | Twiggs | 13289 | 587 | 31 | 0 | 556 | 32.67435595 | -83.43078662 | 2021-02-13 05:22:12 | Twiggs, Georgia, US |
2021-02-05 | US | Puerto Rico | Quebradillas | 72115 | 556 | 0 | 0 | 556 | 18.439692 | -66.926113 | 2021-02-06 05:23:55 | Quebradillas, Puerto Rico, US |
2021-02-05 | US | Puerto Rico | Ciales | 72039 | 556 | 0 | 0 | 556 | 18.28885 | -66.516475 | 2021-02-06 05:23:55 | Ciales, Puerto Rico, US |
2021-02-05 | US | North Carolina | Gates | 37073 | 568 | 12 | 0 | 556 | 36.44667547 | -76.69749701 | 2021-02-06 05:23:55 | Gates, North Carolina, US |
2021-02-04 | US | Puerto Rico | Yauco | 72153 | 556 | 0 | 0 | 556 | 18.080374 | -66.858814 | 2021-02-05 05:22:38 | Yauco, Puerto Rico, US |
2021-02-03 | US | Puerto Rico | Yauco | 72153 | 556 | 0 | 0 | 556 | 18.080374 | -66.858814 | 2021-02-04 05:22:26 | Yauco, Puerto Rico, US |
2021-02-02 | US | Puerto Rico | Yauco | 72153 | 556 | 0 | 0 | 556 | 18.080374 | -66.858814 | 2021-02-03 05:22:52 | Yauco, Puerto Rico, US |
2021-02-01 | US | Texas | Jack | 48237 | 562 | 13 | 0 | 556 | 33.23377248 | -98.17283469 | 2021-02-02 05:22:49 | Jack, Texas, US |
2021-02-01 | US | Missouri | St. Clair | 29185 | 562 | 6 | 0 | 556 | 38.03699437 | -93.77631447 | 2021-02-02 05:22:49 | St. Clair, Missouri, US |
2021-02-01 | US | Kentucky | Owen | 21187 | 563 | 7 | 0 | 556 | 38.51679143 | -84.82404619 | 2021-02-02 05:22:49 | Owen, Kentucky, US |
2021-02-01 | US | Georgia | Crawford | 13079 | 568 | 12 | 0 | 556 | 32.71391813 | -83.98061238 | 2021-02-02 05:22:49 | Crawford, Georgia, US |
2021-01-31 | US | Texas | Trinity | 48455 | 788 | 19 | 0 | 556 | 31.0879489 | -95.1367187 | 2021-02-01 05:22:53 | Trinity, Texas, US |
2021-01-31 | US | Texas | Martin | 48317 | 530 | 18 | 0 | 556 | 32.30600051 | -101.9513518 | 2021-02-01 05:22:53 | Martin, Texas, US |
2021-01-31 | US | Texas | Jack | 48237 | 562 | 13 | 0 | 556 | 33.23377248 | -98.17283469 | 2021-02-01 05:22:53 | Jack, Texas, US |
2021-01-31 | US | Kentucky | Owen | 21187 | 563 | 7 | 0 | 556 | 38.51679143 | -84.82404619 | 2021-02-01 05:22:53 | Owen, Kentucky, US |
2021-01-31 | US | Kentucky | Gallatin | 21077 | 572 | 16 | 0 | 556 | 38.75398691 | -84.8558382 | 2021-02-01 05:22:53 | Gallatin, Kentucky, US |
2021-01-30 | US | Texas | Trinity | 48455 | 788 | 19 | 0 | 556 | 31.0879489 | -95.1367187 | 2021-01-31 05:22:42 | Trinity, Texas, US |
2021-01-30 | US | Texas | Jack | 48237 | 562 | 13 | 0 | 556 | 33.23377248 | -98.17283469 | 2021-01-31 05:22:42 | Jack, Texas, US |
2021-01-30 | US | Nebraska | Nemaha | 31127 | 569 | 13 | 0 | 556 | 40.38514847 | -95.85433992 | 2021-01-31 05:22:42 | Nemaha, Nebraska, US |
2021-01-29 | US | Virginia | Covington | 51580 | 560 | 4 | 0 | 556 | 37.7824656 | -79.98631446 | 2021-01-30 05:22:49 | Covington, Virginia, US |
2021-01-28 | US | West Virginia | Gilmer | 54021 | 562 | 6 | 0 | 556 | 38.9251277 | -80.85952723 | 2021-01-29 05:22:23 | Gilmer, West Virginia, US |
2021-01-28 | US | California | Plumas | 6063 | 557 | 2 | 0 | 556 | 40.00355989 | -120.8395236 | 2021-01-29 05:22:23 | Plumas, California, US |
2021-01-27 | US | Nebraska | Pierce | 31139 | 576 | 20 | 0 | 556 | 42.26434853 | -97.60122773 | 2021-01-28 05:22:24 | Pierce, Nebraska, US |
2021-01-26 | US | Nebraska | Pierce | 31139 | 576 | 20 | 0 | 556 | 42.26434853 | -97.60122773 | 2021-01-27 05:23:41 | Pierce, Nebraska, US |
2021-01-26 | US | Maine | Knox | 23013 | 560 | 4 | 0 | 556 | 44.11486325 | -69.10529169 | 2021-01-27 05:23:41 | Knox, Maine, US |
2021-01-25 | US | Vermont | Addison | 50001 | 561 | 5 | 0 | 556 | 44.03217337 | -73.14130877 | 2021-01-26 05:22:02 | Addison, Vermont, US |
2021-01-25 | US | Texas | Martin | 48317 | 530 | 18 | 0 | 556 | 32.30600051 | -101.9513518 | 2021-01-26 05:22:02 | Martin, Texas, US |
2021-01-25 | US | Nebraska | Burt | 31021 | 566 | 10 | 0 | 556 | 41.85056773 | -96.32605633 | 2021-01-26 05:22:02 | Burt, Nebraska, US |
2021-01-24 | US | Texas | Martin | 48317 | 530 | 18 | 0 | 556 | 32.30600051 | -101.9513518 | 2021-01-25 05:22:16 | Martin, Texas, US |
2021-01-24 | US | Puerto Rico | Villalba | 72149 | 556 | 0 | 0 | 556 | 18.127951 | -66.473115 | 2021-01-25 05:22:16 | Villalba, Puerto Rico, US |
2021-01-21 | India | Himachal Pradesh | 57121 | 970 | 55595 | 556 | 31.927213 | 77.233081 | 2021-01-22 05:22:10 | Himachal Pradesh, India | ||
2021-01-20 | US | Missouri | Monroe | 29137 | 563 | 7 | 0 | 556 | 39.49593978 | -92.00043978 | 2021-01-21 05:22:01 | Monroe, Missouri, US |
2021-01-16 | US | South Dakota | Day | 46037 | 579 | 23 | 0 | 556 | 45.367281 | -97.60737498 | 2021-01-17 05:22:17 | Day, South Dakota, US |
2021-01-16 | US | Arkansas | Searcy | 5129 | 570 | 14 | 0 | 556 | 35.9109364 | -92.69936482 | 2021-01-17 05:22:17 | Searcy, Arkansas, US |
2021-01-15 | US | South Dakota | Day | 46037 | 579 | 23 | 0 | 556 | 45.367281 | -97.60737498 | 2021-01-16 05:22:40 | Day, South Dakota, US |
2021-01-15 | US | Mississippi | Wilkinson | 28157 | 581 | 25 | 0 | 556 | 31.16078225 | -91.31018819 | 2021-01-16 05:22:40 | Wilkinson, Mississippi, US |
2021-01-14 | US | South Dakota | Moody | 46101 | 570 | 14 | 0 | 556 | 44.02266214 | -96.67081159 | 2021-01-15 05:22:24 | Moody, South Dakota, US |
2021-01-13 | US | Arkansas | Dallas | 5039 | 568 | 12 | 0 | 556 | 33.97042763 | -92.65167437 | 2021-01-14 05:22:32 | Dallas, Arkansas, US |
2021-01-12 | US | Virginia | King William | 51101 | 560 | 4 | 0 | 556 | 37.70965316 | -77.09384941 | 2021-01-13 05:22:15 | King William, Virginia, US |
2021-01-12 | US | Montana | Madison | 30057 | 559 | 3 | 0 | 556 | 45.30080065 | -111.9173017 | 2021-01-13 05:22:15 | Madison, Montana, US |
2021-01-12 | US | Arkansas | Perry | 5105 | 561 | 5 | 0 | 556 | 34.9459153 | -92.94372564 | 2021-01-13 05:22:15 | Perry, Arkansas, US |
2021-01-10 | US | Vermont | Rutland | 50021 | 565 | 9 | 0 | 556 | 43.57723578 | -73.03741676 | 2021-01-11 05:21:50 | Rutland, Vermont, US |
2021-01-10 | US | Texas | Martin | 48317 | 529 | 17 | 0 | 556 | 32.30600051 | -101.9513518 | 2021-01-11 05:21:50 | Martin, Texas, US |
2021-01-09 | US | Texas | Martin | 48317 | 529 | 17 | 0 | 556 | 32.30600051 | -101.9513518 | 2021-01-10 05:22:12 | Martin, Texas, US |
2021-01-08 | US | Nebraska | Cedar | 31027 | 566 | 10 | 0 | 556 | 42.5988851 | -97.25311951 | 2021-01-09 05:22:18 | Cedar, Nebraska, US |
2021-01-08 | US | Minnesota | Koochiching | 27071 | 566 | 10 | 0 | 556 | 48.24539665 | -93.78352843 | 2021-01-09 05:22:18 | Koochiching, Minnesota, US |
2021-01-07 | US | Alabama | Coosa | 1037 | 563 | 7 | 0 | 556 | 32.93690146 | -86.24847739 | 2021-01-08 05:22:42 | Coosa, Alabama, US |
2021-01-06 | US | North Carolina | Pamlico | 37137 | 561 | 5 | 0 | 556 | 35.15253315 | -76.66559823 | 2021-01-07 05:22:03 | Pamlico, North Carolina, US |
2021-01-05 | US | Vermont | Bennington | 50003 | 559 | 3 | 0 | 556 | 43.03519828 | -73.09048868 | 2021-01-06 05:22:16 | Bennington, Vermont, US |
2021-01-05 | US | Texas | Floyd | 48153 | 801 | 23 | 0 | 556 | 34.07227468 | -101.3031546 | 2021-01-06 05:22:16 | Floyd, Texas, US |
2021-01-05 | US | Nebraska | Clay | 31035 | 565 | 9 | 0 | 556 | 40.52439441 | -98.05126296 | 2021-01-06 05:22:16 | Clay, Nebraska, US |
2021-01-05 | US | Missouri | Lewis | 29111 | 559 | 3 | 0 | 556 | 40.09673161 | -91.72070156 | 2021-01-06 05:22:16 | Lewis, Missouri, US |
2021-01-05 | US | Hawaii | Out of HI | 80015 | 558 | 2 | 0 | 556 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
2021-01-05 | US | Georgia | Jenkins | 13165 | 590 | 34 | 0 | 556 | 32.79248718 | -81.96040187 | 2021-01-06 05:22:16 | Jenkins, Georgia, US |
2021-01-05 | US | Arkansas | Prairie | 5117 | 573 | 17 | 0 | 556 | 34.83624419 | -91.55162157 | 2021-01-06 05:22:16 | Prairie, Arkansas, US |
2021-01-04 | US | Texas | Archer | 48009 | 586 | 6 | 0 | 556 | 33.61569967 | -98.68754589 | 2021-01-05 05:21:49 | Archer, Texas, US |
2021-01-04 | US | Oklahoma | Tillman | 40141 | 565 | 9 | 0 | 556 | 34.37288446 | -98.92426619 | 2021-01-05 05:21:49 | Tillman, Oklahoma, US |
2021-01-03 | US | Texas | Archer | 48009 | 586 | 6 | 0 | 556 | 33.61569967 | -98.68754589 | 2021-01-04 05:22:02 | Archer, Texas, US |
2021-01-02 | US | Texas | Archer | 48009 | 586 | 6 | 0 | 556 | 33.61569967 | -98.68754589 | 2021-01-03 05:22:52 | Archer, Texas, US |
2021-01-02 | US | Tennessee | Van Buren | 47175 | 636 | 6 | 0 | 556 | 35.69864497 | -85.45221699 | 2021-01-03 05:22:52 | Van Buren, Tennessee, US |
2021-01-02 | US | Nebraska | Jefferson | 31095 | 557 | 1 | 0 | 556 | 40.17584531 | -97.142601 | 2021-01-03 05:22:52 | Jefferson, Nebraska, US |
2021-01-02 | US | Missouri | Caldwell | 29025 | 561 | 5 | 0 | 556 | 39.65620858 | -93.98308093 | 2021-01-03 05:22:52 | Caldwell, Missouri, US |
2021-01-01 | US | Texas | Archer | 48009 | 586 | 6 | 0 | 556 | 33.61569967 | -98.68754589 | 2021-01-02 05:22:33 | Archer, Texas, US |
2021-01-01 | US | Georgia | Wilcox | 13315 | 591 | 35 | 0 | 556 | 31.97496928 | -83.43438555 | 2021-01-02 05:22:33 | Wilcox, Georgia, US |
2020-12-30 | US | Texas | Bandera | 48019 | 647 | 12 | 0 | 556 | 29.74619598 | -99.24598147 | 2020-12-31 05:22:49 | Bandera, Texas, US |
2020-12-29 | US | Iowa | Lucas | 19117 | 563 | 7 | 0 | 556 | 41.02958964 | -93.32780803 | 2020-12-30 05:22:34 | Lucas, Iowa, US |
2020-12-26 | US | Texas | Brooks | 48047 | 564 | 27 | 0 | 556 | 27.03103197 | -98.21808402 | 2020-12-27 05:22:55 | Brooks, Texas, US |
2020-12-26 | Colombia | Sucre | 17353 | 675 | 16122 | 556 | 8.814 | -74.7233 | 2020-12-27 05:22:55 | Sucre, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;