daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where deaths = 1552 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Knox | 47093 | 154083 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-30 04:21:04 | Knox, Tennessee, US | |
2022-12-28 | US | Tennessee | Knox | 47093 | 154083 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-29 04:21:01 | Knox, Tennessee, US | |
2022-12-19 | US | Tennessee | Knox | 47093 | 153704 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-20 04:21:04 | Knox, Tennessee, US | |
2022-12-18 | US | Tennessee | Knox | 47093 | 153602 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-19 04:21:03 | Knox, Tennessee, US | |
2022-12-17 | US | Tennessee | Knox | 47093 | 153587 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-18 04:21:03 | Knox, Tennessee, US | |
2022-12-16 | US | Tennessee | Knox | 47093 | 153546 | 1552 | 0 | 35.99508821 | -83.94635435 | 2022-12-17 04:21:04 | Knox, Tennessee, US | |
2022-10-20 | US | Washington | Spokane | 53063 | 146097 | 1552 | 0 | 47.62113146 | -117.4046494 | 2022-10-21 04:22:23 | Spokane, Washington, US | |
2022-10-19 | US | Washington | Spokane | 53063 | 146097 | 1552 | 0 | 47.62113146 | -117.4046494 | 2022-10-20 04:22:59 | Spokane, Washington, US | |
2022-09-28 | US | Texas | Collin | 48085 | 257025 | 1552 | 0 | 33.18820114 | -96.57264368 | 2022-09-29 04:22:34 | Collin, Texas, US | |
2022-09-27 | US | Texas | Collin | 48085 | 257025 | 1552 | 0 | 33.18820114 | -96.57264368 | 2022-09-28 04:23:01 | Collin, Texas, US | |
2022-09-26 | US | Texas | Collin | 48085 | 257025 | 1552 | 0 | 33.18820114 | -96.57264368 | 2022-09-27 04:23:01 | Collin, Texas, US | |
2022-09-22 | Netherlands | Utrecht | 692474 | 1552 | 0 | 52.084251 | 5.163824 | 2022-09-23 04:23:13 | Utrecht, Netherlands | |||
2022-09-21 | Netherlands | Utrecht | 692474 | 1552 | 0 | 52.084251 | 5.163824 | 2022-09-22 04:22:56 | Utrecht, Netherlands | |||
2022-09-20 | Netherlands | Utrecht | 692474 | 1552 | 0 | 52.084251 | 5.163824 | 2022-09-21 04:23:22 | Utrecht, Netherlands | |||
2022-09-15 | US | Texas | Nueces | 48355 | 114839 | 1552 | 0 | 27.736286 | -97.5433285 | 2022-09-16 04:21:19 | Nueces, Texas, US | |
2022-08-30 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-31 04:20:57 | Out of GA, Georgia, US | |
2022-08-29 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-30 04:21:03 | Out of GA, Georgia, US | |
2022-08-28 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-29 04:21:06 | Out of GA, Georgia, US | |
2022-08-27 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-28 04:21:02 | Out of GA, Georgia, US | |
2022-08-26 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-27 04:20:57 | Out of GA, Georgia, US | |
2022-08-25 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-26 04:21:02 | Out of GA, Georgia, US | |
2022-08-24 | US | Georgia | Out of GA | 80013 | 92786 | 1552 | 0 | 34.91369188 | 0.0 | 2022-08-25 04:21:13 | Out of GA, Georgia, US | |
2022-08-22 | US | California | Ventura | 6111 | 219120 | 1552 | 0 | 34.44465746 | -119.0910613 | 2022-08-23 04:20:56 | Ventura, California, US | |
2022-08-21 | US | California | Ventura | 6111 | 218297 | 1552 | 0 | 34.44465746 | -119.0910613 | 2022-08-22 04:20:38 | Ventura, California, US | |
2022-08-20 | US | California | Ventura | 6111 | 218280 | 1552 | 0 | 34.44465746 | -119.0910613 | 2022-08-21 04:20:44 | Ventura, California, US | |
2022-08-19 | US | California | Ventura | 6111 | 218258 | 1552 | 0 | 34.44465746 | -119.0910613 | 2022-08-20 04:21:01 | Ventura, California, US | |
2022-08-12 | Singapore | 1786643 | 1552 | 0 | 1.2833 | 103.8333 | 2022-08-13 04:20:52 | Singapore | ||||
2022-06-20 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-21 04:20:56 | Spartanburg, South Carolina, US | |
2022-06-19 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-20 04:21:01 | Spartanburg, South Carolina, US | |
2022-06-18 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-19 04:20:51 | Spartanburg, South Carolina, US | |
2022-06-17 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-18 04:21:10 | Spartanburg, South Carolina, US | |
2022-06-16 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-17 04:20:56 | Spartanburg, South Carolina, US | |
2022-06-15 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-16 04:20:55 | Spartanburg, South Carolina, US | |
2022-06-14 | US | South Carolina | Spartanburg | 45083 | 97078 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-15 04:20:54 | Spartanburg, South Carolina, US | |
2022-06-13 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-14 04:20:52 | Spartanburg, South Carolina, US | |
2022-06-12 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-13 04:21:14 | Spartanburg, South Carolina, US | |
2022-06-11 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-12 04:20:53 | Spartanburg, South Carolina, US | |
2022-06-10 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-11 04:21:01 | Spartanburg, South Carolina, US | |
2022-06-09 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-10 04:20:55 | Spartanburg, South Carolina, US | |
2022-06-08 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-09 04:20:54 | Spartanburg, South Carolina, US | |
2022-06-07 | US | South Carolina | Spartanburg | 45083 | 96670 | 1552 | 0 | 34.92960077 | -81.99225984 | 2022-06-08 04:20:55 | Spartanburg, South Carolina, US | |
2022-06-07 | US | Illinois | Will | 17197 | 176549 | 1552 | 0 | 41.44619267 | -87.97862712 | 2022-06-08 04:20:55 | Will, Illinois, US | |
2022-05-29 | Russia | Khabarovsk Krai | 202356 | 1552 | 0 | 51.6312684 | 136.121524 | 2022-05-30 04:20:50 | Khabarovsk Krai, Russia | |||
2022-05-28 | Russia | Khabarovsk Krai | 202286 | 1552 | 0 | 51.6312684 | 136.121524 | 2022-05-29 04:20:53 | Khabarovsk Krai, Russia | |||
2022-05-27 | Russia | Khabarovsk Krai | 202212 | 1552 | 0 | 51.6312684 | 136.121524 | 2022-05-28 04:21:07 | Khabarovsk Krai, Russia | |||
2022-05-26 | Russia | Khabarovsk Krai | 202133 | 1552 | 0 | 51.6312684 | 136.121524 | 2022-05-27 04:20:56 | Khabarovsk Krai, Russia | |||
2022-05-19 | US | New Jersey | Morris | 34027 | 127749 | 1552 | 0 | 40.86095313 | -74.5455371 | 2022-05-20 04:20:57 | Morris, New Jersey, US | |
2022-05-18 | US | New Jersey | Morris | 34027 | 127368 | 1552 | 0 | 40.86095313 | -74.5455371 | 2022-05-19 04:20:54 | Morris, New Jersey, US | |
2022-05-17 | US | New Jersey | Morris | 34027 | 127063 | 1552 | 0 | 40.86095313 | -74.5455371 | 2022-05-18 04:20:50 | Morris, New Jersey, US | |
2022-04-23 | Italy | P.A. Trento | 158603 | 1552 | 0 | 46.06893511 | 11.12123097 | 2022-04-24 04:20:56 | P.A. Trento, Italy | |||
2022-04-22 | Italy | P.A. Trento | 158182 | 1552 | 0 | 46.06893511 | 11.12123097 | 2022-04-23 04:20:50 | P.A. Trento, Italy | |||
2022-04-21 | Italy | P.A. Trento | 157701 | 1552 | 0 | 46.06893511 | 11.12123097 | 2022-04-22 04:20:45 | P.A. Trento, Italy | |||
2022-04-09 | US | New York | Monroe | 36055 | 152955 | 1552 | 0 | 43.14638895 | -77.69322942 | 2022-04-10 04:20:52 | Monroe, New York, US | |
2022-03-13 | US | North Carolina | Mecklenburg | 37119 | 276029 | 1552 | 0 | 35.24469268 | -80.8317671 | 2022-03-14 04:20:46 | Mecklenburg, North Carolina, US | |
2022-03-12 | US | North Carolina | Mecklenburg | 37119 | 276029 | 1552 | 0 | 35.24469268 | -80.8317671 | 2022-03-13 04:20:49 | Mecklenburg, North Carolina, US | |
2022-03-11 | US | North Carolina | Mecklenburg | 37119 | 276029 | 1552 | 0 | 35.24469268 | -80.8317671 | 2022-03-12 04:20:50 | Mecklenburg, North Carolina, US | |
2022-02-19 | US | Pennsylvania | Berks | 42011 | 101231 | 1552 | 0 | 40.41570541 | -75.92457766 | 2022-02-20 04:21:00 | Berks, Pennsylvania, US | |
2022-02-18 | US | Pennsylvania | Berks | 42011 | 101103 | 1552 | 0 | 40.41570541 | -75.92457766 | 2022-02-19 04:21:11 | Berks, Pennsylvania, US | |
2022-02-17 | Spain | Canarias | 275377 | 1552 | 0 | 28.2916 | -16.6291 | 2022-02-18 04:21:04 | Canarias, Spain | |||
2022-02-10 | US | New Mexico | Bernalillo | 35001 | 140857 | 1552 | 0 | 35.05163625 | -106.6703554 | 2022-02-11 04:21:09 | Bernalillo, New Mexico, US | |
2022-02-08 | India | Meghalaya | 92521 | 1552 | 0 | 25.536934 | 91.278882 | 2022-02-09 04:21:04 | Meghalaya, India | |||
2022-02-06 | US | Michigan | Genesee | 26049 | 97310 | 1552 | 0 | 43.02244215 | -83.70589709 | 2022-02-07 04:21:05 | Genesee, Michigan, US | |
2022-02-05 | US | Michigan | Genesee | 26049 | 97310 | 1552 | 0 | 43.02244215 | -83.70589709 | 2022-02-06 04:21:00 | Genesee, Michigan, US | |
2022-02-04 | US | Michigan | Genesee | 26049 | 97310 | 1552 | 0 | 43.02244215 | -83.70589709 | 2022-02-05 04:21:05 | Genesee, Michigan, US | |
2022-01-20 | US | Massachusetts | Hampden | 25013 | 118486 | 1552 | 0 | 42.13440424 | -72.63235561 | 2022-01-21 04:21:09 | Hampden, Massachusetts, US | |
2022-01-16 | Chile | Los Lagos | 101270 | 1552 | 0 | -41.9198 | -72.1416 | 2022-01-17 04:21:08 | Los Lagos, Chile | |||
2022-01-15 | Russia | Arkhangelsk Oblast | 125881 | 1552 | 0 | 63.5589686 | 43.1221646 | 2022-01-16 04:21:12 | Arkhangelsk Oblast, Russia | |||
2021-12-30 | US | Pennsylvania | Lancaster | 42071 | 90442 | 1552 | 0 | 40.03904563 | -76.24770128 | 2021-12-31 04:21:50 | Lancaster, Pennsylvania, US | |
2021-12-30 | US | Pennsylvania | Bucks | 42017 | 90889 | 1552 | 0 | 40.33682119 | -75.10836643 | 2021-12-31 04:21:50 | Bucks, Pennsylvania, US | |
2021-12-25 | Chile | Araucania | 103636 | 1552 | 0 | -38.9489 | -72.3311 | 2021-12-26 04:21:50 | Araucania, Chile | |||
2021-12-24 | Chile | Araucania | 103536 | 1552 | 0 | -38.9489 | -72.3311 | 2021-12-25 04:21:37 | Araucania, Chile | |||
2021-12-23 | US | Ohio | Montgomery | 39113 | 86134 | 1552 | 0 | 39.75394919 | -84.29050975 | 2021-12-24 04:21:34 | Montgomery, Ohio, US | |
2021-12-11 | Finland | 204479 | 1552 | 0 | 61.92411 | 25.748151 | 2021-12-12 04:22:12 | Finland | ||||
2021-11-15 | US | Ohio | Hamilton | 39061 | 109220 | 1552 | 0 | 39.19673558 | -84.54502924 | 2021-11-16 04:21:10 | Hamilton, Ohio, US | |
2021-11-14 | US | Ohio | Hamilton | 39061 | 109052 | 1552 | 0 | 39.19673558 | -84.54502924 | 2021-11-15 04:21:36 | Hamilton, Ohio, US | |
2021-11-13 | US | Ohio | Hamilton | 39061 | 108892 | 1552 | 0 | 39.19673558 | -84.54502924 | 2021-11-14 04:21:31 | Hamilton, Ohio, US | |
2021-11-12 | US | Ohio | Hamilton | 39061 | 108716 | 1552 | 0 | 39.19673558 | -84.54502924 | 2021-11-13 04:21:38 | Hamilton, Ohio, US | |
2021-10-30 | Ukraine | Luhansk Oblast | 48148 | 1552 | 0 | 48.574 | 39.3078 | 2021-10-31 04:22:08 | Luhansk Oblast, Ukraine | |||
2021-10-13 | US | Kentucky | Jefferson | 21111 | 116662 | 1552 | 0 | 38.18664655 | -85.65931031 | 2021-10-14 04:21:29 | Jefferson, Kentucky, US | |
2021-10-08 | Chile | OHiggins | 69002 | 1552 | 0 | -34.5755 | -71.0022 | 2021-10-09 04:21:34 | OHiggins, Chile | |||
2021-10-07 | Chile | OHiggins | 68970 | 1552 | 0 | -34.5755 | -71.0022 | 2021-10-08 04:21:25 | OHiggins, Chile | |||
2021-09-06 | Peru | Tumbes | 18411 | 1552 | 0 | -3.857496 | -80.54525500000003 | 2021-09-07 04:21:35 | Tumbes, Peru | |||
2021-09-05 | Peru | Tumbes | 18411 | 1552 | 0 | -3.857496 | -80.54525500000003 | 2021-09-06 04:21:22 | Tumbes, Peru | |||
2021-07-30 | Colombia | Sucre | 57357 | 1552 | 54799 | 1006 | 8.814 | -74.7233 | 2021-07-31 04:21:35 | Sucre, Colombia | ||
2021-07-06 | Ukraine | Crimea Republic* | 50313 | 1552 | 44248 | 4513 | 45.2835 | 34.2008 | 2021-07-07 04:21:20 | Crimea Republic*, Ukraine | ||
2021-07-05 | Russia | Volgograd Oblast | 63751 | 1552 | 59630 | 2569 | 49.6048339 | 44.29035820000001 | 2021-07-06 04:21:32 | Volgograd Oblast, Russia | ||
2021-07-01 | Russia | Chuvashia Republic | 27354 | 1552 | 24991 | 811 | 55.4259922 | 47.0849429 | 2021-07-02 04:21:47 | Chuvashia Republic, Russia | ||
2021-06-08 | Russia | Stavropol Krai | 55302 | 1552 | 52417 | 1333 | 44.86325770000001 | 43.4406913 | 2021-06-09 04:23:31 | Stavropol Krai, Russia | ||
2021-05-09 | Mexico | Chiapas | 11089 | 1552 | 0 | 9537 | 16.7569 | -93.1292 | 2021-05-10 04:20:38 | Chiapas, Mexico | ||
2021-05-08 | Mexico | Chiapas | 11083 | 1552 | 0 | 9531 | 16.7569 | -93.1292 | 2021-05-09 04:20:35 | Chiapas, Mexico | ||
2021-05-04 | Japan | Osaka | 85223 | 1552 | 61766 | 21905 | 34.620965000000005 | 135.507481 | 2021-05-05 04:20:43 | Osaka, Japan | ||
2021-05-03 | Brazil | Acre | 78325 | 1552 | 63652 | 13121 | -9.0238 | -70.812 | 2021-05-04 04:20:34 | Acre, Brazil | ||
2021-04-17 | Zimbabwe | 37699 | 1552 | 35005 | 1142 | -19.015438 | 29.154857 | 2021-04-18 04:20:41 | Zimbabwe | |||
2021-03-26 | US | Tennessee | Shelby | 47157 | 89340 | 1552 | 0 | 35.1864775 | -89.89692423 | 2021-03-27 05:25:04 | Shelby, Tennessee, US | |
2021-03-18 | US | Texas | Cameron | 48061 | 41976 | 1552 | 0 | 26.14524221 | -97.48140372 | 2021-03-19 05:26:09 | Cameron, Texas, US | |
2021-03-15 | India | Bihar | 263051 | 1552 | 261171 | 328 | 25.679658 | 85.60484 | 2021-03-16 05:25:13 | Bihar, India | ||
2021-02-21 | Oman | 139362 | 1552 | 130653 | 7157 | 21.512583 | 55.92325500000001 | 2021-02-22 05:24:21 | Oman | |||
2021-02-09 | US | Minnesota | Hennepin | 27053 | 97413 | 1552 | 0 | 95861 | 45.00761521 | -93.47694895 | 2021-02-10 05:22:41 | Hennepin, Minnesota, US |
2021-01-30 | Russia | Irkutsk Oblast | 48406 | 1552 | 43360 | 3494 | 56.6370122 | 104.719221 | 2021-01-31 05:22:42 | Irkutsk Oblast, Russia | ||
2021-01-07 | Peru | Puno | 19441 | 1552 | 0 | 17889 | -14.995826999999998 | -69.922726 | 2021-01-08 05:22:42 | Puno, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;