johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where deaths = 1497 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713139 | 713139 | 2022-11-01 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-11-02 04:22:09 | Luzerne, Pennsylvania, US | |
3287588 | 3287588 | 2022-10-31 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-11-01 04:22:36 | Luzerne, Pennsylvania, US | |
322621 | 322621 | 2022-10-30 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-10-31 04:21:36 | Luzerne, Pennsylvania, US | |
914897 | 914897 | 2022-10-29 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-10-30 04:22:14 | Luzerne, Pennsylvania, US | |
1369166 | 1369166 | 2022-10-28 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-10-29 04:21:13 | Luzerne, Pennsylvania, US | |
3041021 | 3041021 | 2022-10-27 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-10-28 04:22:31 | Luzerne, Pennsylvania, US | |
541441 | 541441 | 2022-10-26 | US | Pennsylvania | Luzerne | 42079 | 88176 | 1497 | 0 | 41.17823008 | -75.98447579 | 2022-10-27 04:22:01 | Luzerne, Pennsylvania, US | |
1624968 | 1624968 | 2022-09-22 | US | Delaware | New Castle | 10003 | 174495 | 1497 | 0 | 39.57992638 | -75.64054974 | 2022-09-23 04:23:13 | New Castle, Delaware, US | |
1371172 | 1371172 | 2022-09-21 | US | Delaware | New Castle | 10003 | 174362 | 1497 | 0 | 39.57992638 | -75.64054974 | 2022-09-22 04:22:56 | New Castle, Delaware, US | |
2832273 | 2832273 | 2022-08-25 | US | Washington | Pierce | 53053 | 225227 | 1497 | 0 | 47.03892768 | -122.1405958 | 2022-08-26 04:21:02 | Pierce, Washington, US | |
2326806 | 2326806 | 2022-08-24 | US | Washington | Pierce | 53053 | 225227 | 1497 | 0 | 47.03892768 | -122.1405958 | 2022-08-25 04:21:13 | Pierce, Washington, US | |
2363556 | 2363556 | 2022-08-19 | Malaysia | Negeri Sembilan | 217663 | 1497 | 0 | 2.7258 | 101.9424 | 2022-08-20 04:21:01 | Negeri Sembilan, Malaysia | |||
1161227 | 1161227 | 2022-08-18 | Malaysia | Negeri Sembilan | 217422 | 1497 | 0 | 2.7258 | 101.9424 | 2022-08-19 04:20:54 | Negeri Sembilan, Malaysia | |||
3950551 | 3950551 | 2022-08-17 | Malaysia | Negeri Sembilan | 217102 | 1497 | 0 | 2.7258 | 101.9424 | 2022-08-18 04:21:11 | Negeri Sembilan, Malaysia | |||
991053 | 991053 | 2022-08-16 | Malaysia | Negeri Sembilan | 216909 | 1497 | 0 | 2.7258 | 101.9424 | 2022-08-17 04:20:59 | Negeri Sembilan, Malaysia | |||
674597 | 674597 | 2022-07-30 | Singapore | 1708950 | 1497 | 0 | 1.2833 | 103.8333 | 2022-07-31 04:21:02 | Singapore | ||||
899482 | 899482 | 2022-07-24 | US | Virginia | Fairfax | 51059 | 219490 | 1497 | 0 | 38.83677558 | -77.27565836 | 2022-07-25 04:20:51 | Fairfax, Virginia, US | |
94476 | 94476 | 2022-07-23 | US | Virginia | Fairfax | 51059 | 219490 | 1497 | 0 | 38.83677558 | -77.27565836 | 2022-07-24 04:20:47 | Fairfax, Virginia, US | |
903498 | 903498 | 2022-07-22 | US | Virginia | Fairfax | 51059 | 219490 | 1497 | 0 | 38.83677558 | -77.27565836 | 2022-07-23 04:20:53 | Fairfax, Virginia, US | |
463607 | 463607 | 2022-05-02 | Russia | Karelia Republic | 134143 | 1497 | 0 | 62.6194031 | 33.4920267 | 2022-05-03 04:21:00 | Karelia Republic, Russia | |||
3916246 | 3916246 | 2022-05-01 | Russia | Karelia Republic | 134090 | 1497 | 0 | 62.6194031 | 33.4920267 | 2022-05-02 04:21:10 | Karelia Republic, Russia | |||
3854530 | 3854530 | 2022-04-27 | US | Pennsylvania | York | 42133 | 119253 | 1497 | 0 | 39.9210089 | -76.73040131 | 2022-04-28 04:20:47 | York, Pennsylvania, US | |
502722 | 502722 | 2022-04-02 | US | Texas | Collin | 48085 | 210057 | 1497 | 0 | 33.18820114 | -96.57264368 | 2022-04-03 04:20:48 | Collin, Texas, US | |
1468003 | 1468003 | 2022-03-24 | Germany | Saarland | 224073 | 1497 | 0 | 49.3964 | 7.023 | 2022-03-25 04:20:46 | Saarland, Germany | |||
3022487 | 3022487 | 2022-03-23 | Russia | Khabarovsk Krai | 194312 | 1497 | 0 | 51.6312684 | 136.121524 | 2022-03-24 04:20:43 | Khabarovsk Krai, Russia | |||
696040 | 696040 | 2022-03-17 | US | Michigan | Kent | 26081 | 165669 | 1497 | 0 | 43.03197711 | -85.54934642 | 2022-03-18 04:20:55 | Kent, Michigan, US | |
2320983 | 2320983 | 2022-03-16 | US | Michigan | Kent | 26081 | 165669 | 1497 | 0 | 43.03197711 | -85.54934642 | 2022-03-17 04:20:56 | Kent, Michigan, US | |
1644667 | 1644667 | 2022-03-03 | Spain | Navarra | 223676 | 1497 | 0 | 42.6954 | -1.6761 | 2022-03-04 04:21:09 | Navarra, Spain | |||
2525670 | 2525670 | 2022-03-02 | Spain | Navarra | 223386 | 1497 | 0 | 42.6954 | -1.6761 | 2022-03-03 04:21:01 | Navarra, Spain | |||
3671487 | 3671487 | 2022-02-15 | Colombia | La Guajira | 55589 | 1497 | 0 | 11.3548 | -72.5205 | 2022-02-16 04:21:10 | La Guajira, Colombia | |||
189340 | 189340 | 2022-02-13 | US | Utah | Salt Lake | 49035 | 334737 | 1497 | 0 | 40.66616532 | -111.92160109999999 | 2022-02-14 04:20:51 | Salt Lake, Utah, US | |
319186 | 319186 | 2022-02-12 | US | Utah | Salt Lake | 49035 | 334737 | 1497 | 0 | 40.66616532 | -111.92160109999999 | 2022-02-13 04:21:00 | Salt Lake, Utah, US | |
236512 | 236512 | 2022-02-11 | US | Utah | Salt Lake | 49035 | 334737 | 1497 | 0 | 40.66616532 | -111.92160109999999 | 2022-02-12 04:21:06 | Salt Lake, Utah, US | |
71880 | 71880 | 2022-02-07 | US | Georgia | DeKalb | 13089 | 141001 | 1497 | 0 | 33.76944049 | -84.22396017 | 2022-02-08 04:21:15 | DeKalb, Georgia, US | |
1296283 | 1296283 | 2022-02-05 | US | New York | Monroe | 36055 | 146761 | 1497 | 0 | 43.14638895 | -77.69322942 | 2022-02-06 04:21:00 | Monroe, New York, US | |
1779975 | 1779975 | 2022-01-27 | US | California | Stanislaus | 6099 | 123255 | 1497 | 0 | 37.55862499 | -120.9970722 | 2022-01-28 04:21:09 | Stanislaus, California, US | |
1319820 | 1319820 | 2022-01-26 | US | Massachusetts | Plymouth | 25023 | 109222 | 1497 | 0 | 41.94070556 | -70.80802823 | 2022-01-27 04:21:19 | Plymouth, Massachusetts, US | |
1140855 | 1140855 | 2022-01-23 | India | Meghalaya | 88459 | 1497 | 0 | 25.536934 | 91.278882 | 2022-01-24 04:21:12 | Meghalaya, India | |||
3689054 | 3689054 | 2022-01-13 | US | Maryland | Baltimore City | 24510 | 100023 | 1497 | 0 | 39.30211911 | -76.61151012 | 2022-01-14 04:21:54 | Baltimore City, Maryland, US | |
1115191 | 1115191 | 2022-01-11 | US | Massachusetts | Hampden | 25013 | 105801 | 1497 | 0 | 42.13440424 | -72.63235561 | 2022-01-12 04:21:44 | Hampden, Massachusetts, US | |
1113843 | 1113843 | 2022-01-11 | Russia | Tatarstan Republic | 43749 | 1497 | 0 | 55.7648572 | 52.43104273 | 2022-01-12 04:21:44 | Tatarstan Republic, Russia | |||
1695987 | 1695987 | 2022-01-10 | Uzbekistan | 200730 | 1497 | 0 | 41.377491 | 64.585262 | 2022-01-11 04:22:01 | Uzbekistan | ||||
1668647 | 1668647 | 2021-12-29 | Russia | Arkhangelsk Oblast | 122902 | 1497 | 0 | 63.5589686 | 43.1221646 | 2021-12-30 04:21:25 | Arkhangelsk Oblast, Russia | |||
1432756 | 1432756 | 2021-12-28 | Russia | Arkhangelsk Oblast | 122655 | 1497 | 0 | 63.5589686 | 43.1221646 | 2021-12-29 03:21:43 | Arkhangelsk Oblast, Russia | |||
730717 | 730717 | 2021-12-27 | Russia | Arkhangelsk Oblast | 122402 | 1497 | 0 | 63.5589686 | 43.1221646 | 2021-12-28 04:21:47 | Arkhangelsk Oblast, Russia | |||
2111889 | 2111889 | 2021-12-26 | Russia | Arkhangelsk Oblast | 122128 | 1497 | 0 | 63.5589686 | 43.1221646 | 2021-12-27 04:21:58 | Arkhangelsk Oblast, Russia | |||
1716335 | 1716335 | 2021-12-16 | Italy | Umbria | 70079 | 1497 | 0 | 43.10675841 | 12.38824698 | 2021-12-17 04:22:14 | Umbria, Italy | |||
3496169 | 3496169 | 2021-12-15 | Italy | Umbria | 69819 | 1497 | 0 | 43.10675841 | 12.38824698 | 2021-12-16 04:22:11 | Umbria, Italy | |||
2087954 | 2087954 | 2021-12-14 | Italy | Umbria | 69568 | 1497 | 0 | 43.10675841 | 12.38824698 | 2021-12-15 03:22:16 | Umbria, Italy | |||
1662593 | 1662593 | 2021-12-12 | US | New Jersey | Camden | 34007 | 75133 | 1497 | 0 | 39.80343818 | -74.96388753 | 2021-12-13 04:22:02 | Camden, New Jersey, US | |
1666609 | 1666609 | 2021-12-11 | US | New Jersey | Camden | 34007 | 74912 | 1497 | 0 | 39.80343818 | -74.96388753 | 2021-12-12 04:22:12 | Camden, New Jersey, US | |
1080578 | 1080578 | 2021-12-09 | US | Pennsylvania | Bucks | 42017 | 81450 | 1497 | 0 | 40.33682119 | -75.10836643 | 2021-12-10 04:22:28 | Bucks, Pennsylvania, US | |
551026 | 551026 | 2021-12-08 | Russia | Tambov Oblast | 56343 | 1497 | 0 | 52.9019574 | 41.3578918 | 2021-12-09 04:22:49 | Tambov Oblast, Russia | |||
205 | 205 | 2021-12-02 | Finland | 191261 | 1497 | 0 | 61.92411 | 25.748151 | 2021-12-03 04:23:05 | Finland | ||||
3291737 | 3291737 | 2021-11-18 | US | South Carolina | Greenville | 45045 | 106768 | 1497 | 0 | 34.89502264 | -82.37295012 | 2021-11-19 04:21:40 | Greenville, South Carolina, US | |
87336 | 87336 | 2021-11-09 | Russia | Kemerovo Oblast | 66160 | 1497 | 0 | 54.53357809999999 | 87.342861 | 2021-11-10 04:21:38 | Kemerovo Oblast, Russia | |||
2946980 | 2946980 | 2021-10-15 | Ukraine | Chernihiv Oblast | 65228 | 1497 | 0 | 51.4982 | 31.2893 | 2021-10-16 04:21:15 | Chernihiv Oblast, Ukraine | |||
633985 | 633985 | 2021-10-13 | Malaysia | Pulau Pinang | 138200 | 1497 | 0 | 5.4141 | 100.3288 | 2021-10-14 04:21:29 | Pulau Pinang, Malaysia | |||
423572 | 423572 | 2021-10-10 | Russia | Kursk Oblast | 59953 | 1497 | 0 | 51.6568453 | 36.4852695 | 2021-10-11 04:21:31 | Kursk Oblast, Russia | |||
601846 | 601846 | 2021-09-23 | Peru | Apurimac | 26011 | 1497 | 0 | -14.027713 | -72.975378 | 2021-09-24 04:21:44 | Apurimac, Peru | |||
249453 | 249453 | 2021-09-04 | Peru | Moquegua | 29354 | 1497 | 0 | -16.860271 | -70.839046 | 2021-09-05 04:21:33 | Moquegua, Peru | |||
3555904 | 3555904 | 2021-08-21 | Russia | Tver Oblast | 58615 | 1497 | 0 | 57.1134475 | 35.174442799999994 | 2021-08-22 04:21:29 | Tver Oblast, Russia | |||
590430 | 590430 | 2021-08-08 | US | Georgia | Fulton | 13121 | 105675 | 1497 | 0 | 33.79216944 | -84.46319413 | 2021-08-09 04:21:24 | Fulton, Georgia, US | |
2204442 | 2204442 | 2021-08-07 | US | Georgia | Fulton | 13121 | 105675 | 1497 | 0 | 33.79216944 | -84.46319413 | 2021-08-08 04:21:33 | Fulton, Georgia, US | |
1118392 | 1118392 | 2021-08-06 | US | Georgia | Fulton | 13121 | 105675 | 1497 | 0 | 33.79216944 | -84.46319413 | 2021-08-07 04:21:30 | Fulton, Georgia, US | |
3218291 | 3218291 | 2021-07-26 | Italy | Sardegna | 60315 | 1497 | 55328 | 3490 | 39.21531192 | 9.110616306 | 2021-07-27 04:21:18 | Sardegna, Italy | ||
1378500 | 1378500 | 2021-07-25 | Italy | Sardegna | 60106 | 1497 | 55291 | 3318 | 39.21531192 | 9.110616306 | 2021-07-26 04:21:28 | Sardegna, Italy | ||
3705985 | 3705985 | 2021-07-17 | Colombia | Sucre | 55191 | 1497 | 52170 | 1524 | 8.814 | -74.7233 | 2021-07-18 04:22:07 | Sucre, Colombia | ||
579079 | 579079 | 2021-07-13 | Russia | Saratov Oblast | 68736 | 1497 | 64476 | 2763 | 51.6520555 | 46.86319520000001 | 2021-07-14 04:21:35 | Saratov Oblast, Russia | ||
2590263 | 2590263 | 2021-06-27 | Russia | Volgograd Oblast | 62374 | 1497 | 59046 | 1831 | 49.6048339 | 44.29035820000001 | 2021-06-28 04:21:29 | Volgograd Oblast, Russia | ||
2886827 | 2886827 | 2021-06-20 | US | Ohio | Franklin | 39049 | 128749 | 1497 | 0 | 39.96995815 | -83.01115755 | 2021-06-21 04:21:41 | Franklin, Ohio, US | |
50753 | 50753 | 2021-05-29 | India | Puducherry | 102896 | 1497 | 88246 | 13153 | 11.882658 | 78.86498 | 2021-05-30 04:20:55 | Puducherry, India | ||
2940924 | 2940924 | 2021-05-16 | US | Massachusetts | Suffolk | 25025 | 92192 | 1497 | 0 | 42.3279514 | -71.07850442 | 2021-05-17 04:20:34 | Suffolk, Massachusetts, US | |
2822335 | 2822335 | 2021-05-10 | US | Maryland | Baltimore | 24005 | 64579 | 1497 | 0 | 39.45784712 | -76.62911955 | 2021-05-11 04:20:41 | Baltimore, Maryland, US | |
1426667 | 1426667 | 2021-05-09 | US | Maryland | Baltimore | 24005 | 64532 | 1497 | 0 | 39.45784712 | -76.62911955 | 2021-05-10 04:20:38 | Baltimore, Maryland, US | |
1553535 | 1553535 | 2021-05-08 | US | Maryland | Baltimore | 24005 | 64449 | 1497 | 0 | 39.45784712 | -76.62911955 | 2021-05-09 04:20:35 | Baltimore, Maryland, US | |
645795 | 645795 | 2021-05-05 | Colombia | Cesar | 55801 | 1497 | 52667 | 1637 | 9.3373 | -73.6536 | 2021-05-06 04:20:38 | Cesar, Colombia | ||
2824817 | 2824817 | 2021-05-01 | Japan | Osaka | 82439 | 1497 | 59867 | 21075 | 34.620965000000005 | 135.507481 | 2021-05-02 04:20:48 | Osaka, Japan | ||
380436 | 380436 | 2021-04-30 | Russia | Samara Oblast | 61513 | 1497 | 58634 | 1382 | 53.2128813 | 50.8914633 | 2021-05-01 04:20:47 | Samara Oblast, Russia | ||
380141 | 380141 | 2021-04-30 | India | Himachal Pradesh | 99287 | 1497 | 79365 | 18425 | 31.927213 | 77.233081 | 2021-05-01 04:20:47 | Himachal Pradesh, India | ||
888041 | 888041 | 2021-04-26 | Germany | Schleswig-Holstein | 57471 | 1497 | 51650 | 4472 | 54.2194 | 9.6961 | 2021-04-27 04:20:52 | Schleswig-Holstein, Germany | ||
1567836 | 1567836 | 2021-04-22 | Brazil | Amapa | 103960 | 1497 | 76149 | 26314 | 0.902 | -52.003 | 2021-04-23 04:20:52 | Amapa, Brazil | ||
171621 | 171621 | 2021-04-16 | US | Maryland | Montgomery | 24031 | 68623 | 1497 | 0 | 39.13676329 | -77.20358245 | 2021-04-17 04:20:40 | Montgomery, Maryland, US | |
3887207 | 3887207 | 2021-04-11 | Ukraine | Chernivtsi Oblast | 73696 | 1497 | 53116 | 19083 | 48.2917 | 25.9352 | 2021-04-12 04:21:00 | Chernivtsi Oblast, Ukraine | ||
2983429 | 2983429 | 2021-04-10 | Peru | Tacna | 22377 | 1497 | 0 | 20880 | -17.644160999999997 | -70.27756 | 2021-04-11 04:20:56 | Tacna, Peru | ||
2645831 | 2645831 | 2021-04-08 | Mexico | Chiapas | 10560 | 1497 | 0 | 9063 | 16.7569 | -93.1292 | 2021-04-09 04:21:13 | Chiapas, Mexico | ||
641565 | 641565 | 2021-03-31 | United Arab Emirates | 461444 | 1497 | 445355 | 14592 | 23.424076 | 53.847818 | 2021-04-01 04:27:05 | United Arab Emirates | |||
3645719 | 3645719 | 2021-03-30 | US | New Jersey | Monmouth | 34025 | 67701 | 1497 | 0 | 40.26549699 | -74.22240686 | 2021-03-31 04:26:25 | Monmouth, New Jersey, US | |
1290061 | 1290061 | 2021-03-29 | Kyrgyzstan | 88163 | 1497 | 84653 | 2013 | 41.20438 | 74.766098 | 2021-03-30 04:26:23 | Kyrgyzstan | |||
3503479 | 3503479 | 2021-01-17 | Netherlands | Gelderland | 104077 | 1497 | 0 | 102449 | 52.061738 | 5.939114 | 2021-01-18 05:22:34 | Gelderland, Netherlands | ||
3101515 | 3101515 | 2021-01-16 | Mexico | Aguascalientes | 18443 | 1497 | 0 | 16946 | 21.8853 | -102.2916 | 2021-01-17 05:22:17 | Aguascalientes, Mexico | ||
3900050 | 3900050 | 2021-01-09 | Mexico | Morelos | 10993 | 1497 | 0 | 9496 | 18.6813 | -99.1013 | 2021-01-10 05:22:12 | Morelos, Mexico | ||
1010443 | 1010443 | 2020-12-30 | Oman | 128719 | 1497 | 121614 | 5608 | 21.512583 | 55.92325500000001 | 2020-12-31 05:22:49 | Oman | |||
766458 | 766458 | 2020-12-29 | Oman | 128633 | 1497 | 121356 | 5780 | 21.512583 | 55.92325500000001 | 2020-12-30 05:22:34 | Oman | |||
2931390 | 2931390 | 2020-12-19 | Peru | Puno | 18989 | 1497 | 0 | 17492 | -14.995826999999998 | -69.922726 | 2020-12-20 05:27:32 | Puno, Peru | ||
2130165 | 2130165 | 2020-12-17 | US | New Jersey | Union | 34039 | 37791 | 1497 | 0 | 36294 | 40.65835409 | -74.30680092 | 2020-12-18 05:28:18 | Union, New Jersey, US |
1818643 | 1818643 | 2020-12-08 | Colombia | Norte de Santander | 31709 | 1497 | 28396 | 1816 | 7.9463 | -72.8988 | 2020-12-09 05:28:01 | Norte de Santander, Colombia | ||
2784757 | 2784757 | 2020-11-13 | Brazil | Rondonia | 74598 | 1497 | 67037 | 6064 | -11.5057 | -63.5806 | 2020-11-14 05:25:37 | Rondonia, Brazil | ||
1454709 | 1454709 | 2020-10-27 | US | Nevada | Clark | 32003 | 79782 | 1497 | 0 | 78285 | 36.21458855 | -115.0130241 | 2020-10-28 04:24:39 | Clark, Nevada, US |
1795344 | 1795344 | 2020-10-19 | US | Florida | Palm Beach | 12099 | 49068 | 1497 | 0 | 47571 | 26.64676272 | -80.46536002 | 2020-10-20 04:24:22 | Palm Beach, Florida, 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]);