daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
135 rows where active = 1495 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-26 | Russia | Vladimir Oblast | 42178 | 1420 | 39263 | 1495 | 56.0503336 | 40.6561633 | 2021-07-27 04:21:18 | Vladimir Oblast, Russia | ||
2021-07-18 | Colombia | Magdalena | 85581 | 3098 | 80988 | 1495 | 10.4113 | -74.4057 | 2021-07-19 04:21:24 | Magdalena, Colombia | ||
2021-07-09 | Italy | Toscana | 244798 | 6888 | 236415 | 1495 | 43.76923077 | 11.25588885 | 2021-07-10 04:21:25 | Toscana, Italy | ||
2021-06-29 | Malaysia | W.P. Labuan | 8036 | 119 | 6422 | 1495 | 5.2831 | 115.2308 | 2021-06-30 04:21:41 | W.P. Labuan, Malaysia | ||
2021-06-29 | India | Haryana | 768552 | 9417 | 757640 | 1495 | 29.20004 | 76.332824 | 2021-06-30 04:21:41 | Haryana, India | ||
2021-06-23 | India | Madhya Pradesh | 789499 | 8827 | 779177 | 1495 | 23.541513 | 78.289633 | 2021-06-24 04:21:55 | Madhya Pradesh, India | ||
2021-06-15 | Nigeria | 167095 | 2117 | 163483 | 1495 | 9.082 | 8.6753 | 2021-06-16 04:22:32 | Nigeria | |||
2021-05-09 | Russia | Ulyanovsk Oblast | 54179 | 1243 | 51441 | 1495 | 54.1463177 | 47.2324921 | 2021-05-10 04:20:38 | Ulyanovsk Oblast, Russia | ||
2021-04-30 | Russia | Kaluga Oblast | 34061 | 311 | 32255 | 1495 | 54.4382773 | 35.5272854 | 2021-05-01 04:20:47 | Kaluga Oblast, Russia | ||
2021-04-08 | Colombia | Cundinamarca | 112879 | 3101 | 108283 | 1495 | 5.026 | -74.03 | 2021-04-09 04:21:13 | Cundinamarca, Colombia | ||
2021-04-04 | Germany | Saarland | 32275 | 927 | 29950 | 1495 | 49.3964 | 7.023 | 2021-04-05 04:20:35 | Saarland, Germany | ||
2021-03-05 | US | Georgia | Brantley | 13025 | 1526 | 31 | 0 | 1495 | 31.19576557 | -81.97743999 | 2021-03-06 04:23:41 | Brantley, Georgia, US |
2021-03-03 | US | Washington | Unassigned | 90053 | 1500 | 5 | 0 | 1495 | 48.82227976 | 0.0 | 2021-03-04 05:24:24 | Unassigned, Washington, US |
2021-03-02 | US | Montana | Glacier | 30035 | 1524 | 29 | 0 | 1495 | 48.70513576 | -112.9934235 | 2021-03-03 05:23:28 | Glacier, Montana, US |
2021-02-28 | US | Texas | Leon | 48289 | 1889 | 37 | 0 | 1495 | 31.29872538 | -95.9936328 | 2021-03-01 05:23:01 | Leon, Texas, US |
2021-02-28 | US | Kentucky | Harrison | 21097 | 1504 | 9 | 0 | 1495 | 38.44188174 | -84.32869741 | 2021-03-01 05:23:01 | Harrison, Kentucky, US |
2021-02-26 | US | West Virginia | Hampshire | 54027 | 1522 | 27 | 0 | 1495 | 39.32103553 | -78.60826476 | 2021-02-27 05:22:28 | Hampshire, West Virginia, US |
2021-02-26 | US | Tennessee | Decatur | 47039 | 1542 | 37 | 0 | 1495 | 35.60048904 | -88.11043779 | 2021-02-27 05:22:28 | Decatur, Tennessee, US |
2021-02-25 | US | Tennessee | Decatur | 47039 | 1540 | 37 | 0 | 1495 | 35.60048904 | -88.11043779 | 2021-02-26 05:22:40 | Decatur, Tennessee, US |
2021-02-25 | US | Michigan | Out of MI | 80026 | 1505 | 10 | 0 | 1495 | 47.63197653 | 0.0 | 2021-02-26 05:22:40 | Out of MI, Michigan, US |
2021-02-22 | US | Michigan | Out of MI | 80026 | 1505 | 10 | 0 | 1495 | 47.63197653 | 0.0 | 2021-02-23 05:23:41 | Out of MI, Michigan, US |
2021-02-19 | US | Puerto Rico | Dorado | 72051 | 1495 | 0 | 0 | 1495 | 18.436115 | -66.278669 | 2021-02-20 05:22:51 | Dorado, Puerto Rico, US |
2021-02-19 | US | New Mexico | Lincoln | 35027 | 1510 | 15 | 0 | 1495 | 33.74526079 | -105.4586166 | 2021-02-20 05:22:51 | Lincoln, New Mexico, US |
2021-02-19 | US | Illinois | Edgar | 17045 | 1532 | 37 | 0 | 1495 | 39.6809186 | -87.74759563 | 2021-02-20 05:22:51 | Edgar, Illinois, US |
2021-02-18 | US | Tennessee | Decatur | 47039 | 1539 | 35 | 0 | 1495 | 35.60048904 | -88.11043779 | 2021-02-19 05:24:16 | Decatur, Tennessee, US |
2021-02-18 | US | Kansas | Atchison | 20005 | 1507 | 12 | 0 | 1495 | 39.53185661 | -95.30870026 | 2021-02-19 05:24:16 | Atchison, Kansas, US |
2021-02-17 | US | Kansas | Atchison | 20005 | 1507 | 12 | 0 | 1495 | 39.53185661 | -95.30870026 | 2021-02-18 05:22:58 | Atchison, Kansas, US |
2021-02-16 | US | Tennessee | Decatur | 47039 | 1536 | 35 | 0 | 1495 | 35.60048904 | -88.11043779 | 2021-02-17 05:23:10 | Decatur, Tennessee, US |
2021-02-15 | US | Tennessee | Decatur | 47039 | 1536 | 35 | 0 | 1495 | 35.60048904 | -88.11043779 | 2021-02-16 05:24:38 | Decatur, Tennessee, US |
2021-02-15 | US | Georgia | Rabun | 13241 | 1534 | 39 | 0 | 1495 | 34.88389445 | -83.40304637 | 2021-02-16 05:24:38 | Rabun, Georgia, US |
2021-02-13 | Malaysia | Pulau Pinang | 9757 | 14 | 8248 | 1495 | 5.4141 | 100.3288 | 2021-02-14 05:23:43 | Pulau Pinang, Malaysia | ||
2021-02-11 | US | Oklahoma | Choctaw | 40023 | 1508 | 13 | 0 | 1495 | 34.02807439 | -95.54771129 | 2021-02-12 05:23:29 | Choctaw, Oklahoma, US |
2021-02-02 | US | North Carolina | Northampton | 37131 | 1522 | 27 | 0 | 1495 | 36.41736238 | -77.39769443 | 2021-02-03 05:22:52 | Northampton, North Carolina, US |
2021-01-31 | US | Kentucky | Simpson | 21213 | 1516 | 21 | 0 | 1495 | 36.74058474 | -86.58047435 | 2021-02-01 05:22:53 | Simpson, Kentucky, US |
2021-01-31 | US | Indiana | Vermillion | 18165 | 1531 | 36 | 0 | 1495 | 39.8523352 | -87.46160542 | 2021-02-01 05:22:53 | Vermillion, Indiana, US |
2021-01-27 | US | Florida | Lafayette | 12067 | 1518 | 23 | 0 | 1495 | 29.98484137 | -83.18166636 | 2021-01-28 05:22:24 | Lafayette, Florida, US |
2021-01-26 | US | Florida | Lafayette | 12067 | 1518 | 23 | 0 | 1495 | 29.98484137 | -83.18166636 | 2021-01-27 05:23:41 | Lafayette, Florida, US |
2021-01-25 | US | Georgia | Banks | 13011 | 1521 | 26 | 0 | 1495 | 34.35607081 | -83.49644388 | 2021-01-26 05:22:02 | Banks, Georgia, US |
2021-01-23 | US | Georgia | Morgan | 13211 | 1506 | 11 | 0 | 1495 | 33.59232073 | -83.49129491 | 2021-01-24 05:22:35 | Morgan, Georgia, US |
2021-01-18 | US | Georgia | Lamar | 13171 | 1533 | 38 | 0 | 1495 | 33.07841647 | -84.14263877 | 2021-01-19 05:22:15 | Lamar, Georgia, US |
2021-01-16 | US | Iowa | Cedar | 19031 | 1514 | 19 | 0 | 1495 | 41.77233777 | -91.13246684 | 2021-01-17 05:22:17 | Cedar, Iowa, US |
2021-01-16 | US | Illinois | Pike | 17149 | 1538 | 43 | 0 | 1495 | 39.62265059 | -90.8877017 | 2021-01-17 05:22:17 | Pike, Illinois, US |
2021-01-15 | US | Virginia | Southampton | 51175 | 1538 | 43 | 0 | 1495 | 36.72231125 | -77.10642712 | 2021-01-16 05:22:40 | Southampton, Virginia, US |
2021-01-13 | US | Louisiana | St. James | 22093 | 1540 | 45 | 0 | 1495 | 30.02531716 | -90.80212061 | 2021-01-14 05:22:32 | St. James, Louisiana, US |
2021-01-12 | US | Tennessee | Cannon | 47015 | 1530 | 17 | 0 | 1495 | 35.80990797 | -86.05738983 | 2021-01-13 05:22:15 | Cannon, Tennessee, US |
2021-01-10 | US | Tennessee | Lake | 47095 | 1515 | 19 | 0 | 1495 | 36.34180170000001 | -89.48921915 | 2021-01-11 05:21:50 | Lake, Tennessee, US |
2021-01-10 | US | Georgia | Washington | 13303 | 1541 | 46 | 0 | 1495 | 32.96711864 | -82.79357039 | 2021-01-11 05:21:50 | Washington, Georgia, US |
2021-01-10 | Japan | Kyoto | 5937 | 74 | 4368 | 1495 | 35.253815 | 135.443341 | 2021-01-11 05:21:50 | Kyoto, Japan | ||
2021-01-06 | US | Tennessee | Unicoi | 47171 | 1524 | 40 | 0 | 1495 | 36.10890856 | -82.43709629 | 2021-01-07 05:22:03 | Unicoi, Tennessee, US |
2021-01-05 | US | California | Colusa | 6011 | 1498 | 7 | 0 | 1495 | 39.17881957 | -122.2331726 | 2021-01-06 05:22:16 | Colusa, California, US |
2021-01-05 | US | Alabama | Hale | 1065 | 1528 | 33 | 0 | 1495 | 32.76039258 | -87.63284988 | 2021-01-06 05:22:16 | Hale, Alabama, US |
2021-01-03 | US | South Carolina | Barnwell | 45011 | 1528 | 33 | 0 | 1495 | 33.26679302 | -81.43584352 | 2021-01-04 05:22:02 | Barnwell, South Carolina, US |
2021-01-02 | US | Alabama | Barbour | 1005 | 1528 | 33 | 0 | 1495 | 31.868263 | -85.3871286 | 2021-01-03 05:22:52 | Barbour, Alabama, US |
2020-12-31 | US | Georgia | Peach | 13225 | 1528 | 33 | 0 | 1495 | 32.56934316 | -83.82937 | 2021-01-01 05:23:07 | Peach, Georgia, US |
2020-12-30 | Japan | Hyogo | 9808 | 209 | 8104 | 1495 | 35.039913 | 134.828057 | 2020-12-31 05:22:49 | Hyogo, Japan | ||
2020-12-26 | US | Mississippi | Newton | 28101 | 1527 | 32 | 0 | 1495 | 32.40021118 | -89.11843336 | 2020-12-27 05:22:55 | Newton, Mississippi, US |
2020-12-25 | US | North Dakota | Richland | 38077 | 1519 | 15 | 0 | 1495 | 46.26440649 | -96.94852979 | 2020-12-26 05:22:28 | Richland, North Dakota, US |
2020-12-21 | US | Missouri | Randolph | 29175 | 1510 | 15 | 0 | 1495 | 39.44007257 | -92.4971374 | 2020-12-22 05:22:33 | Randolph, Missouri, US |
2020-12-21 | US | Minnesota | Martin | 27091 | 1518 | 23 | 0 | 1495 | 43.67429718 | -94.55099908 | 2020-12-22 05:22:33 | Martin, Minnesota, US |
2020-12-20 | US | Georgia | Pickens | 13227 | 1513 | 18 | 0 | 1495 | 34.46589159 | -84.46406611 | 2020-12-21 05:27:58 | Pickens, Georgia, US |
2020-12-19 | US | Missouri | New Madrid | 29143 | 1521 | 26 | 0 | 1495 | 36.59666326 | -89.66070007 | 2020-12-20 05:27:32 | New Madrid, Missouri, US |
2020-12-18 | US | Texas | Gonzales | 48177 | 1436 | 24 | 0 | 1495 | 29.45634206 | -97.49424032 | 2020-12-19 05:27:52 | Gonzales, Texas, US |
2020-12-17 | US | Illinois | Lawrence | 17101 | 1511 | 16 | 0 | 1495 | 38.71987914 | -87.72884035 | 2020-12-18 05:28:18 | Lawrence, Illinois, US |
2020-12-17 | US | Georgia | Chattooga | 13055 | 1536 | 41 | 0 | 1495 | 34.47197698 | -85.34535662 | 2020-12-18 05:28:18 | Chattooga, Georgia, US |
2020-12-14 | Zimbabwe | 11358 | 309 | 9554 | 1495 | -19.015438 | 29.154857 | 2020-12-15 05:26:38 | Zimbabwe | |||
2020-12-13 | US | Wisconsin | Crawford | 55023 | 1505 | 10 | 0 | 1495 | 43.23870316 | -90.93073686 | 2020-12-14 05:26:27 | Crawford, Wisconsin, US |
2020-12-12 | US | Washington | Okanogan | 53047 | 1520 | 25 | 0 | 1495 | 48.54855019 | -119.7387224 | 2020-12-13 05:27:20 | Okanogan, Washington, US |
2020-12-12 | US | South Dakota | Clay | 46027 | 1506 | 11 | 0 | 1495 | 42.91296147 | -96.97656917 | 2020-12-13 05:27:20 | Clay, South Dakota, US |
2020-12-12 | US | Minnesota | Roseau | 27135 | 1504 | 9 | 0 | 1495 | 48.77501878 | -95.81079919 | 2020-12-13 05:27:20 | Roseau, Minnesota, US |
2020-12-10 | US | Louisiana | Beauregard | 22011 | 1545 | 50 | 0 | 1495 | 30.64836518 | -93.34173616 | 2020-12-11 05:26:59 | Beauregard, Louisiana, US |
2020-12-10 | US | Indiana | Scott | 18143 | 1526 | 31 | 0 | 1495 | 38.68672078 | -85.74627859 | 2020-12-11 05:26:59 | Scott, Indiana, US |
2020-12-07 | US | Louisiana | Vernon | 22115 | 1561 | 66 | 0 | 1495 | 31.10884837 | -93.18153838 | 2020-12-08 05:27:42 | Vernon, Louisiana, US |
2020-12-03 | US | Missouri | Washington | 29221 | 1517 | 22 | 0 | 1495 | 37.96130078 | -90.87948158 | 2020-12-04 05:27:27 | Washington, Missouri, US |
2020-12-02 | US | Minnesota | Brown | 27015 | 1510 | 15 | 0 | 1495 | 44.24205652 | -94.72562874 | 2020-12-03 05:28:22 | Brown, Minnesota, US |
2020-11-26 | US | Michigan | Tuscola | 26157 | 1546 | 51 | 0 | 1495 | 43.46606813 | -83.41897025 | 2020-11-27 05:26:53 | Tuscola, Michigan, US |
2020-11-25 | US | Michigan | Tuscola | 26157 | 1546 | 51 | 0 | 1495 | 43.46606813 | -83.41897025 | 2020-11-26 05:27:44 | Tuscola, Michigan, US |
2020-11-24 | US | Texas | Polk | 48373 | 1590 | 42 | 0 | 1495 | 30.79472531 | -94.8276624 | 2020-11-25 05:27:20 | Polk, Texas, US |
2020-11-24 | US | Ohio | Huron | 39077 | 1523 | 28 | 0 | 1495 | 41.14651175 | -82.59867951 | 2020-11-25 05:27:20 | Huron, Ohio, US |
2020-11-18 | US | Georgia | Decatur | 13087 | 1540 | 45 | 0 | 1495 | 30.87967778 | -84.57619536 | 2020-11-19 05:25:23 | Decatur, Georgia, US |
2020-11-17 | US | Oklahoma | Ottawa | 40115 | 1517 | 22 | 0 | 1495 | 36.83532655 | -94.81011909 | 2020-11-18 05:40:31 | Ottawa, Oklahoma, US |
2020-11-12 | Germany | Mecklenburg-Vorpommern | 3910 | 34 | 2634 | 1495 | 53.6127 | 12.4296 | 2020-11-13 05:25:30 | Mecklenburg-Vorpommern, Germany | ||
2020-11-05 | US | Maine | York | 23031 | 1516 | 21 | 0 | 1495 | 43.47808377 | -70.71052375 | 2020-11-06 05:24:55 | York, Maine, US |
2020-10-31 | US | Tennessee | Lauderdale | 47097 | 1507 | 18 | 0 | 1495 | 35.75893438 | -89.63015909999999 | 2020-11-01 04:36:19 | Lauderdale, Tennessee, US |
2020-10-29 | US | Mississippi | Pontotoc | 28115 | 1515 | 20 | 0 | 1495 | 34.226046000000004 | -89.03636807 | 2020-10-30 04:24:49 | Pontotoc, Mississippi, US |
2020-10-26 | US | Mississippi | Warren | 28149 | 1551 | 56 | 0 | 1495 | 32.35810271 | -90.83352619 | 2020-10-27 04:24:45 | Warren, Mississippi, US |
2020-10-23 | US | Idaho | Bingham | 16011 | 1512 | 17 | 0 | 1495 | 43.21672879999999 | -112.3978437 | 2020-10-24 04:24:46 | Bingham, Idaho, US |
2020-10-22 | US | Ohio | Mercer | 39107 | 1521 | 26 | 0 | 1495 | 40.54043046 | -84.62912742 | 2020-10-23 04:24:46 | Mercer, Ohio, US |
2020-10-20 | Russia | Buryatia Republic | 8964 | 101 | 7368 | 1495 | 52.7182426 | 109.492143 | 2020-10-21 04:24:14 | Buryatia Republic, Russia | ||
2020-10-16 | Haiti | 8908 | 231 | 7182 | 1495 | 18.9712 | -72.2852 | 2020-10-17 04:24:12 | Haiti | |||
2020-10-15 | Haiti | 8908 | 231 | 7182 | 1495 | 18.9712 | -72.2852 | 2020-10-16 04:24:01 | Haiti | |||
2020-10-13 | US | Mississippi | Sunflower | 28133 | 1544 | 49 | 0 | 1495 | 33.60192578 | -90.58882684 | 2020-10-14 04:24:05 | Sunflower, Mississippi, US |
2020-10-11 | US | Illinois | Williamson | 17199 | 1551 | 56 | 0 | 1495 | 37.73033511 | -88.92994027 | 2020-10-12 04:23:45 | Williamson, Illinois, US |
2020-10-10 | US | Georgia | Ware | 13299 | 1557 | 62 | 0 | 1495 | 31.05449097 | -82.42224148 | 2020-10-11 04:23:46 | Ware, Georgia, US |
2020-10-09 | US | Tennessee | Coffee | 47031 | 1497 | 17 | 0 | 1495 | 35.49090731 | -86.07311784 | 2020-10-10 04:23:57 | Coffee, Tennessee, US |
2020-10-08 | US | Michigan | Livingston | 26093 | 1527 | 32 | 0 | 1495 | 42.60302282 | -83.91297209 | 2020-10-09 04:23:59 | Livingston, Michigan, US |
2020-10-08 | US | Alabama | Covington | 1039 | 1523 | 28 | 0 | 1495 | 31.2477854 | -86.45050893 | 2020-10-09 04:23:59 | Covington, Alabama, US |
2020-10-07 | US | Louisiana | St. John the Baptist | 22095 | 1599 | 104 | 0 | 1495 | 30.12597499 | -90.4753503 | 2020-10-08 04:23:56 | St. John the Baptist, Louisiana, US |
2020-10-07 | Colombia | Narino | 19084 | 708 | 16881 | 1495 | 1.2892 | -77.3579 | 2020-10-08 04:23:56 | Narino, Colombia | ||
2020-10-04 | US | Louisiana | St. John the Baptist | 22095 | 1597 | 102 | 0 | 1495 | 30.12597499 | -90.4753503 | 2020-10-05 04:23:33 | St. John the Baptist, Louisiana, US |
2020-10-02 | US | Florida | Baker | 12003 | 1508 | 13 | 0 | 1495 | 30.33060121 | -82.28467476 | 2020-10-03 04:23:40 | Baker, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;