johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
122 rows where deaths = 1540 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755592 | 2755592 | 2022-12-29 | US | Pennsylvania | Luzerne | 42079 | 91180 | 1540 | 0 | 41.17823008 | -75.98447579 | 2022-12-30 04:21:04 | Luzerne, Pennsylvania, US | |
1076598 | 1076598 | 2022-12-28 | US | Pennsylvania | Luzerne | 42079 | 91180 | 1540 | 0 | 41.17823008 | -75.98447579 | 2022-12-29 04:21:01 | Luzerne, Pennsylvania, US | |
2488966 | 2488966 | 2022-11-16 | US | Tennessee | Knox | 47093 | 151586 | 1540 | 0 | 35.99508821 | -83.94635435 | 2022-11-17 04:21:11 | Knox, Tennessee, US | |
713911 | 713911 | 2022-11-01 | US | Washington | Pierce | 53053 | 232296 | 1540 | 0 | 47.03892768 | -122.1405958 | 2022-11-02 04:22:09 | Pierce, Washington, US | |
3288360 | 3288360 | 2022-10-31 | US | Washington | Pierce | 53053 | 232296 | 1540 | 0 | 47.03892768 | -122.1405958 | 2022-11-01 04:22:36 | Pierce, Washington, US | |
539349 | 539349 | 2022-10-26 | US | California | Tulare | 6107 | 159059 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-27 04:22:01 | Tulare, California, US | |
1830750 | 1830750 | 2022-10-25 | US | California | Tulare | 6107 | 159042 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-26 04:22:19 | Tulare, California, US | |
795011 | 795011 | 2022-10-24 | US | California | Tulare | 6107 | 158919 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-25 04:21:53 | Tulare, California, US | |
3277466 | 3277466 | 2022-10-23 | US | California | Tulare | 6107 | 158895 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-24 04:22:29 | Tulare, California, US | |
2268504 | 2268504 | 2022-10-22 | US | California | Tulare | 6107 | 158884 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-23 04:22:46 | Tulare, California, US | |
1592804 | 1592804 | 2022-10-21 | US | California | Tulare | 6107 | 158878 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-22 04:22:53 | Tulare, California, US | |
2272520 | 2272520 | 2022-10-20 | US | California | Tulare | 6107 | 158872 | 1540 | 0 | 36.22026558 | -118.8020203 | 2022-10-21 04:22:23 | Tulare, California, US | |
2379007 | 2379007 | 2022-09-29 | US | Washington | Spokane | 53063 | 144464 | 1540 | 0 | 47.62113146 | -117.4046494 | 2022-09-30 04:23:09 | Spokane, Washington, US | |
1563558 | 1563558 | 2022-09-28 | US | Washington | Spokane | 53063 | 144464 | 1540 | 0 | 47.62113146 | -117.4046494 | 2022-09-29 04:22:34 | Spokane, Washington, US | |
3550561 | 3550561 | 2022-09-01 | US | Texas | Collin | 48085 | 252204 | 1540 | 0 | 33.18820114 | -96.57264368 | 2022-09-02 04:21:07 | Collin, Texas, US | |
1683557 | 1683557 | 2022-08-29 | US | Texas | Collin | 48085 | 250995 | 1540 | 0 | 33.18820114 | -96.57264368 | 2022-08-30 04:21:03 | Collin, Texas, US | |
2326683 | 2326683 | 2022-08-24 | US | Virginia | Fairfax | 51059 | 229150 | 1540 | 0 | 38.83677558 | -77.27565836 | 2022-08-25 04:21:13 | Fairfax, Virginia, US | |
2326538 | 2326538 | 2022-08-24 | US | Texas | Nueces | 48355 | 113238 | 1540 | 0 | 27.736286 | -97.5433285 | 2022-08-25 04:21:13 | Nueces, Texas, US | |
3544087 | 3544087 | 2022-08-08 | US | California | Ventura | 6111 | 215662 | 1540 | 0 | 34.44465746 | -119.0910613 | 2022-08-09 04:20:34 | Ventura, California, US | |
1070490 | 1070490 | 2022-08-07 | US | California | Ventura | 6111 | 214706 | 1540 | 0 | 34.44465746 | -119.0910613 | 2022-08-08 04:21:08 | Ventura, California, US | |
1941078 | 1941078 | 2022-08-06 | US | California | Ventura | 6111 | 214683 | 1540 | 0 | 34.44465746 | -119.0910613 | 2022-08-07 04:20:54 | Ventura, California, US | |
880877 | 880877 | 2022-08-05 | US | California | Ventura | 6111 | 214654 | 1540 | 0 | 34.44465746 | -119.0910613 | 2022-08-06 04:20:56 | Ventura, California, US | |
2239533 | 2239533 | 2022-06-28 | Netherlands | Utrecht | 673160 | 1540 | 0 | 52.084251 | 5.163824 | 2022-06-29 04:20:59 | Utrecht, Netherlands | |||
2147775 | 2147775 | 2022-06-27 | Netherlands | Utrecht | 672589 | 1540 | 0 | 52.084251 | 5.163824 | 2022-06-28 04:20:58 | Utrecht, Netherlands | |||
360555 | 360555 | 2022-05-07 | Russia | Khabarovsk Krai | 200980 | 1540 | 0 | 51.6312684 | 136.121524 | 2022-05-08 04:20:49 | Khabarovsk Krai, Russia | |||
2843017 | 2843017 | 2022-04-30 | US | New Jersey | Morris | 34027 | 122537 | 1540 | 0 | 40.86095313 | -74.5455371 | 2022-05-01 04:20:57 | Morris, New Jersey, US | |
1159330 | 1159330 | 2022-04-29 | US | New Jersey | Morris | 34027 | 122292 | 1540 | 0 | 40.86095313 | -74.5455371 | 2022-04-30 04:21:05 | Morris, New Jersey, US | |
3350628 | 3350628 | 2022-04-01 | Italy | P.A. Trento | 149988 | 1540 | 0 | 46.06893511 | 11.12123097 | 2022-04-02 04:20:47 | P.A. Trento, Italy | |||
2321935 | 2321935 | 2022-03-16 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-17 04:20:56 | Unassigned, Oklahoma, US | |
264135 | 264135 | 2022-03-15 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-16 04:20:50 | Unassigned, Oklahoma, US | |
2266494 | 2266494 | 2022-03-14 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-15 04:20:47 | Unassigned, Oklahoma, US | |
3630560 | 3630560 | 2022-03-13 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-14 04:20:46 | Unassigned, Oklahoma, US | |
953468 | 953468 | 2022-03-12 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-13 04:20:49 | Unassigned, Oklahoma, US | |
358929 | 358929 | 2022-03-11 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-12 04:20:50 | Unassigned, Oklahoma, US | |
1868081 | 1868081 | 2022-03-10 | US | Oklahoma | Unassigned | 90040 | 161 | 1540 | 0 | 36.83532655 | 0.0 | 2022-03-11 04:20:50 | Unassigned, Oklahoma, US | |
1644422 | 1644422 | 2022-03-03 | Malaysia | Perak | 154994 | 1540 | 0 | 4.5921 | 101.0901 | 2022-03-04 04:21:09 | Perak, Malaysia | |||
1994907 | 1994907 | 2022-03-01 | US | New York | Monroe | 36055 | 149286 | 1540 | 0 | 43.14638895 | -77.69322942 | 2022-03-02 04:21:07 | Monroe, New York, US | |
2475560 | 2475560 | 2022-02-03 | US | Massachusetts | Plymouth | 25023 | 111794 | 1540 | 0 | 41.94070556 | -70.80802823 | 2022-02-04 04:21:10 | Plymouth, Massachusetts, US | |
1144582 | 1144582 | 2022-01-23 | Uzbekistan | 213767 | 1540 | 0 | 41.377491 | 64.585262 | 2022-01-24 04:21:12 | Uzbekistan | ||||
1141895 | 1141895 | 2022-01-23 | US | Illinois | DuPage | 17043 | 187028 | 1540 | 0 | 41.85116968 | -88.08642662 | 2022-01-24 04:21:12 | DuPage, Illinois, US | |
2833813 | 2833813 | 2022-01-22 | US | Illinois | DuPage | 17043 | 187028 | 1540 | 0 | 41.85116968 | -88.08642662 | 2022-01-23 04:21:13 | DuPage, Illinois, US | |
3425931 | 3425931 | 2022-01-21 | US | Illinois | DuPage | 17043 | 187028 | 1540 | 0 | 41.85116968 | -88.08642662 | 2022-01-22 04:21:13 | DuPage, Illinois, US | |
1960810 | 1960810 | 2022-01-20 | Russia | Tatarstan Republic | 44745 | 1540 | 0 | 55.7648572 | 52.43104273 | 2022-01-21 04:21:09 | Tatarstan Republic, Russia | |||
101842 | 101842 | 2022-01-14 | US | Ohio | Summit | 39153 | 104380 | 1540 | 0 | 41.12464734 | -81.53123079 | 2022-01-15 04:21:07 | Summit, Ohio, US | |
3613045 | 3613045 | 2022-01-12 | Italy | Umbria | 119859 | 1540 | 0 | 43.10675841 | 12.38824698 | 2022-01-13 08:00:09 | Umbria, Italy | |||
3519118 | 3519118 | 2022-01-02 | Australia | Victoria | 199576 | 1540 | 0 | -37.8136 | 144.9631 | 2022-01-03 02:22:25 | Victoria, Australia | |||
1668996 | 1668996 | 2021-12-29 | US | California | Alameda | 6001 | 135359 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-30 04:21:25 | Alameda, California, US | |
1433105 | 1433105 | 2021-12-28 | US | California | Alameda | 6001 | 134047 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-29 03:21:43 | Alameda, California, US | |
731066 | 731066 | 2021-12-27 | US | California | Alameda | 6001 | 133399 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-28 04:21:47 | Alameda, California, US | |
2112238 | 2112238 | 2021-12-26 | US | California | Alameda | 6001 | 130638 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-27 04:21:58 | Alameda, California, US | |
3605610 | 3605610 | 2021-12-25 | US | California | Alameda | 6001 | 130574 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-26 04:21:50 | Alameda, California, US | |
2963928 | 2963928 | 2021-12-24 | US | California | Alameda | 6001 | 130558 | 1540 | 0 | 37.64629437 | -121.8929271 | 2021-12-25 04:21:37 | Alameda, California, US | |
3655360 | 3655360 | 2021-12-10 | Chile | Araucania | 102336 | 1540 | 0 | -38.9489 | -72.3311 | 2021-12-11 04:22:45 | Araucania, Chile | |||
1077691 | 1077691 | 2021-12-09 | Chile | Araucania | 102336 | 1540 | 0 | -38.9489 | -72.3311 | 2021-12-10 04:22:28 | Araucania, Chile | |||
1358603 | 1358603 | 2021-11-27 | Russia | Yaroslavl Oblast | 76571 | 1540 | 0 | 57.77819760000001 | 39.002109499999996 | 2021-11-28 04:22:43 | Yaroslavl Oblast, Russia | |||
3346264 | 3346264 | 2021-11-16 | Ukraine | Sevastopol* | 44661 | 1540 | 0 | 44.6054 | 33.522 | 2021-11-17 04:21:48 | Sevastopol*, Ukraine | |||
3342835 | 3342835 | 2021-11-16 | Russia | Khanty-Mansi Autonomous Okrug | 86257 | 1540 | 0 | 61.0259025 | 69.0982628 | 2021-11-17 04:21:48 | Khanty-Mansi Autonomous Okrug, Russia | |||
3511275 | 3511275 | 2021-11-01 | Estonia | 195382 | 1540 | 0 | 58.5953 | 25.0136 | 2021-11-02 04:22:03 | Estonia | ||||
2876548 | 2876548 | 2021-10-09 | Trinidad and Tobago | 52480 | 1540 | 0 | 10.6918 | -61.2225 | 2021-10-10 04:21:38 | Trinidad and Tobago | ||||
706985 | 706985 | 2021-09-29 | US | California | Kern | 6029 | 138615 | 1540 | 0 | 35.34329425 | -118.72777959999999 | 2021-09-30 04:21:20 | Kern, California, US | |
1334827 | 1334827 | 2021-09-28 | US | California | Kern | 6029 | 138233 | 1540 | 0 | 35.34329425 | -118.72777959999999 | 2021-09-29 04:21:45 | Kern, California, US | |
1236196 | 1236196 | 2021-09-27 | US | California | Kern | 6029 | 137884 | 1540 | 0 | 35.34329425 | -118.72777959999999 | 2021-09-28 04:21:28 | Kern, California, US | |
1374287 | 1374287 | 2021-09-15 | Chile | OHiggins | 68508 | 1540 | 0 | -34.5755 | -71.0022 | 2021-09-16 04:22:19 | OHiggins, Chile | |||
2462586 | 2462586 | 2021-09-14 | Chile | OHiggins | 68493 | 1540 | 0 | -34.5755 | -71.0022 | 2021-09-15 03:22:37 | OHiggins, Chile | |||
1385425 | 1385425 | 2021-09-13 | Chile | OHiggins | 68466 | 1540 | 0 | -34.5755 | -71.0022 | 2021-09-14 04:21:41 | OHiggins, Chile | |||
642740 | 642740 | 2021-09-07 | US | Georgia | Fulton | 13121 | 119784 | 1540 | 0 | 33.79216944 | -84.46319413 | 2021-09-08 04:21:31 | Fulton, Georgia, US | |
3975137 | 3975137 | 2021-09-03 | US | California | San Joaquin | 6077 | 93024 | 1540 | 0 | 37.93433732 | -121.2730061 | 2021-09-04 04:21:28 | San Joaquin, California, US | |
178599 | 178599 | 2021-09-02 | US | California | San Joaquin | 6077 | 92690 | 1540 | 0 | 37.93433732 | -121.2730061 | 2021-09-03 04:21:20 | San Joaquin, California, US | |
67634 | 67634 | 2021-09-01 | US | California | San Joaquin | 6077 | 92251 | 1540 | 0 | 37.93433732 | -121.2730061 | 2021-09-02 04:21:15 | San Joaquin, California, US | |
67316 | 67316 | 2021-09-01 | Russia | Tver Oblast | 60850 | 1540 | 0 | 57.1134475 | 35.174442799999994 | 2021-09-02 04:21:15 | Tver Oblast, Russia | |||
2068476 | 2068476 | 2021-08-31 | US | California | San Joaquin | 6077 | 91961 | 1540 | 0 | 37.93433732 | -121.2730061 | 2021-09-01 04:21:38 | San Joaquin, California, US | |
1854253 | 1854253 | 2021-08-20 | Russia | Vologda Oblast | 59300 | 1540 | 0 | 60.0391461 | 43.1215213 | 2021-08-21 04:21:38 | Vologda Oblast, Russia | |||
1306223 | 1306223 | 2021-07-27 | Malawi | 49752 | 1540 | 36878 | 11334 | -13.2543 | 34.3015 | 2021-07-28 04:21:39 | Malawi | |||
2104504 | 2104504 | 2021-06-01 | US | Alabama | Jefferson | 1073 | 80260 | 1540 | 0 | 33.55554728 | -86.89506300000002 | 2021-06-02 04:24:34 | Jefferson, Alabama, US | |
728075 | 728075 | 2021-05-22 | US | Maryland | Montgomery | 24031 | 70677 | 1540 | 0 | 39.13676329 | -77.20358245 | 2021-05-23 04:20:51 | Montgomery, Maryland, US | |
2942764 | 2942764 | 2021-05-16 | US | Washington | King | 53033 | 107147 | 1540 | 0 | 47.49137892 | -121.8346131 | 2021-05-17 04:20:34 | King, Washington, US | |
1876394 | 1876394 | 2021-05-15 | US | Washington | King | 53033 | 107147 | 1540 | 0 | 47.49137892 | -121.8346131 | 2021-05-16 04:20:49 | King, Washington, US | |
1085363 | 1085363 | 2021-05-14 | US | Washington | King | 53033 | 106940 | 1540 | 0 | 47.49137892 | -121.8346131 | 2021-05-15 04:20:58 | King, Washington, US | |
1425214 | 1425214 | 2021-05-09 | Montenegro | 98303 | 1540 | 94963 | 1800 | 42.708678000000006 | 19.37439 | 2021-05-10 04:20:38 | Montenegro | |||
2505669 | 2505669 | 2021-05-07 | Ukraine | Zakarpattia Oblast | 60376 | 1540 | 55546 | 3290 | 48.6208 | 22.2879 | 2021-05-08 04:21:04 | Zakarpattia Oblast, Ukraine | ||
383826 | 383826 | 2021-04-30 | Ukraine | Poltava Oblast | 71707 | 1540 | 60002 | 10165 | 49.5883 | 34.5514 | 2021-05-01 04:20:47 | Poltava Oblast, Ukraine | ||
3393231 | 3393231 | 2021-04-28 | Colombia | Bolivar | 79173 | 1540 | 75824 | 1809 | 8.6704 | -74.03 | 2021-04-29 04:20:55 | Bolivar, Colombia | ||
2548930 | 2548930 | 2021-04-15 | Kyrgyzstan | 91144 | 1540 | 86491 | 3113 | 41.20438 | 74.766098 | 2021-04-16 04:20:46 | Kyrgyzstan | |||
2183523 | 2183523 | 2021-02-26 | India | Bihar | 262464 | 1540 | 260493 | 431 | 25.679658 | 85.60484 | 2021-02-27 05:22:28 | Bihar, India | ||
2283479 | 2283479 | 2021-02-14 | Kosovo | 63805 | 1540 | 55226 | 7039 | 42.602636 | 20.902977 | 2021-02-15 05:24:49 | Kosovo | |||
2677879 | 2677879 | 2021-02-13 | Kosovo | 63805 | 1540 | 55226 | 7039 | 42.602636 | 20.902977 | 2021-02-14 05:23:43 | Kosovo | |||
3539512 | 3539512 | 2021-02-12 | Kosovo | 63805 | 1540 | 55226 | 7039 | 42.602636 | 20.902977 | 2021-02-13 05:22:12 | Kosovo | |||
1684786 | 1684786 | 2021-02-02 | Spain | Asturias | 37722 | 1540 | 1063 | 35119 | 43.3614 | -5.8593 | 2021-02-03 05:22:52 | Asturias, Spain | ||
1897351 | 1897351 | 2021-01-29 | Russia | Irkutsk Oblast | 48140 | 1540 | 43023 | 3577 | 56.6370122 | 104.719221 | 2021-01-30 05:22:49 | Irkutsk Oblast, Russia | ||
2466689 | 2466689 | 2021-01-22 | El Salvador | 52672 | 1540 | 46370 | 4762 | 13.7942 | -88.8965 | 2021-01-23 05:22:03 | El Salvador | |||
239408 | 239408 | 2021-01-18 | US | New Jersey | Ocean | 34029 | 44577 | 1540 | 0 | 43037 | 39.8895449 | -74.28089251 | 2021-01-19 05:22:15 | Ocean, New Jersey, US |
3901547 | 3901547 | 2021-01-09 | US | Massachusetts | Essex | 25009 | 65536 | 1540 | 0 | 63751 | 42.6687626 | -70.94687179 | 2021-01-10 05:22:12 | Essex, Massachusetts, US |
2347580 | 2347580 | 2020-12-07 | Peru | Cusco | 24293 | 1540 | 0 | 22753 | -13.191068 | -72.153609 | 2020-12-08 05:27:42 | Cusco, Peru | ||
2347330 | 2347330 | 2020-12-07 | Georgia | 164976 | 1540 | 137499 | 25937 | 42.3154 | 43.3569 | 2020-12-08 05:27:42 | Georgia | |||
1006450 | 1006450 | 2020-12-06 | Peru | Cusco | 24264 | 1540 | 0 | 22724 | -13.191068 | -72.153609 | 2020-12-07 05:26:14 | Cusco, Peru | ||
2702067 | 2702067 | 2020-11-20 | US | California | Orange | 6059 | 75847 | 1540 | 0 | 74307 | 33.70147516 | -117.76459979999998 | 2020-11-21 05:25:51 | Orange, California, US |
821743 | 821743 | 2020-11-19 | Peru | Ucayali | 19033 | 1540 | 0 | 17493 | -9.621718 | -73.444929 | 2020-11-20 05:26:28 | Ucayali, Peru | ||
866930 | 866930 | 2020-11-12 | US | New Jersey | Hudson | 34017 | 27400 | 1540 | 0 | 25860 | 40.73766234 | -74.07515667 | 2020-11-13 05:25:30 | Hudson, New Jersey, US |
3442974 | 3442974 | 2020-11-11 | US | New Jersey | Hudson | 34017 | 27074 | 1540 | 0 | 25534 | 40.73766234 | -74.07515667 | 2020-11-12 05:25:55 | Hudson, New Jersey, US |
376351 | 376351 | 2020-11-06 | Peru | San Martin | 21932 | 1540 | 0 | 20392 | -7.039531 | -76.729127 | 2020-11-07 05:24:52 | San Martin, Peru |
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]);