daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
95 rows where deaths = 1986 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-08 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-09 04:21:22 | Cobb, Georgia, US | |
2022-11-07 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-08 04:21:21 | Cobb, Georgia, US | |
2022-11-06 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-07 04:21:26 | Cobb, Georgia, US | |
2022-11-05 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-06 04:21:24 | Cobb, Georgia, US | |
2022-11-04 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-05 04:21:52 | Cobb, Georgia, US | |
2022-11-03 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-04 04:22:11 | Cobb, Georgia, US | |
2022-11-02 | US | Georgia | Cobb | 13067 | 206221 | 1986 | 0 | 33.94243204 | -84.5761255 | 2022-11-03 04:22:05 | Cobb, Georgia, US | |
2022-10-27 | Russia | Kaliningrad Oblast | 189933 | 1986 | 0 | 54.7293041 | 21.1489473 | 2022-10-28 04:22:31 | Kaliningrad Oblast, Russia | |||
2022-10-08 | Japan | Fukuoka | 1087133 | 1986 | 0 | 33.526032 | 130.666949 | 2022-10-09 04:21:16 | Fukuoka, Japan | |||
2022-09-03 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-04 04:21:22 | Queensland, Australia | |||
2022-09-02 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-03 04:21:04 | Queensland, Australia | |||
2022-09-01 | US | California | Alameda | 6001 | 361141 | 1986 | 0 | 37.64629437 | -121.8929271 | 2022-09-02 04:21:07 | Alameda, California, US | |
2022-09-01 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-02 04:21:07 | Queensland, Australia | |||
2022-08-31 | US | California | Alameda | 6001 | 360295 | 1986 | 0 | 37.64629437 | -121.8929271 | 2022-09-01 04:21:03 | Alameda, California, US | |
2022-08-30 | US | California | Alameda | 6001 | 360274 | 1986 | 0 | 37.64629437 | -121.8929271 | 2022-08-31 04:20:57 | Alameda, California, US | |
2022-08-09 | Malaysia | Perak | 217469 | 1986 | 0 | 4.5921 | 101.0901 | 2022-08-10 04:20:57 | Perak, Malaysia | |||
2022-08-05 | Italy | Umbria | 354814 | 1986 | 0 | 43.10675841 | 12.38824698 | 2022-08-06 04:20:56 | Umbria, Italy | |||
2022-05-12 | Malaysia | Pulau Pinang | 278882 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-13 04:20:51 | Pulau Pinang, Malaysia | |||
2022-05-11 | Malaysia | Pulau Pinang | 278690 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-12 04:20:54 | Pulau Pinang, Malaysia | |||
2022-05-10 | Malaysia | Pulau Pinang | 278482 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-11 04:20:48 | Pulau Pinang, Malaysia | |||
2022-05-09 | Malaysia | Pulau Pinang | 278308 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-10 04:20:50 | Pulau Pinang, Malaysia | |||
2022-05-08 | Malaysia | Pulau Pinang | 278157 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-09 04:20:54 | Pulau Pinang, Malaysia | |||
2022-05-07 | Malaysia | Pulau Pinang | 278001 | 1986 | 0 | 5.4141 | 100.3288 | 2022-05-08 04:20:49 | Pulau Pinang, Malaysia | |||
2022-05-06 | Russia | Tatarstan Republic | 145861 | 1986 | 0 | 55.7648572 | 52.43104273 | 2022-05-07 04:21:09 | Tatarstan Republic, Russia | |||
2022-05-05 | Russia | Tatarstan Republic | 145661 | 1986 | 0 | 55.7648572 | 52.43104273 | 2022-05-06 04:21:00 | Tatarstan Republic, Russia | |||
2022-04-08 | Japan | Aichi | 435094 | 1986 | 0 | 35.035551 | 137.211621 | 2022-04-09 04:20:42 | Aichi, Japan | |||
2022-03-29 | Germany | Mecklenburg-Vorpommern | 384392 | 1986 | 0 | 53.6127 | 12.4296 | 2022-03-30 04:20:45 | Mecklenburg-Vorpommern, Germany | |||
2022-02-25 | US | Maryland | Montgomery | 24031 | 164893 | 1986 | 0 | 39.13676329 | -77.20358245 | 2022-02-26 04:21:12 | Montgomery, Maryland, US | |
2022-02-15 | US | Kentucky | Jefferson | 21111 | 213710 | 1986 | 0 | 38.18664655 | -85.65931031 | 2022-02-16 04:21:10 | Jefferson, Kentucky, US | |
2022-02-06 | Ukraine | Sevastopol* | 60340 | 1986 | 0 | 44.6054 | 33.522 | 2022-02-07 04:21:05 | Sevastopol*, Ukraine | |||
2022-02-03 | US | California | San Joaquin | 6077 | 166873 | 1986 | 0 | 37.93433732 | -121.2730061 | 2022-02-04 04:21:10 | San Joaquin, California, US | |
2022-01-28 | US | New Jersey | Monmouth | 34025 | 156965 | 1986 | 0 | 40.26549699 | -74.22240686 | 2022-01-29 04:21:10 | Monmouth, New Jersey, US | |
2022-01-19 | US | California | Santa Clara | 6085 | 253867 | 1986 | 0 | 37.23104908 | -121.6970462 | 2022-01-20 04:21:07 | Santa Clara, California, US | |
2022-01-10 | Yemen | 10197 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-11 04:22:01 | Yemen | ||||
2022-01-09 | Yemen | 10197 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-10 04:22:07 | Yemen | ||||
2022-01-08 | Yemen | 10178 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-09 04:21:46 | Yemen | ||||
2022-01-07 | Yemen | 10159 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-08 04:21:53 | Yemen | ||||
2022-01-06 | Yemen | 10152 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-07 04:22:09 | Yemen | ||||
2022-01-01 | Mongolia | 693119 | 1986 | 0 | 46.8625 | 103.8467 | 2022-01-02 04:20:52 | Mongolia | ||||
2021-12-31 | Mongolia | 692621 | 1986 | 0 | 46.8625 | 103.8467 | 2022-01-01 04:22:14 | Mongolia | ||||
2021-12-18 | US | New York | Richmond | 36085 | 97714 | 1986 | 0 | 40.58582155 | -74.14808598 | 2021-12-19 04:21:11 | Richmond, New York, US | |
2021-12-17 | US | New York | Richmond | 36085 | 97714 | 1986 | 0 | 40.58582155 | -74.14808598 | 2021-12-18 02:22:20 | Richmond, New York, US | |
2021-12-12 | US | Ohio | Franklin | 39049 | 184316 | 1986 | 0 | 39.96995815 | -83.01115755 | 2021-12-13 04:22:02 | Franklin, Ohio, US | |
2021-11-17 | US | Massachusetts | Worcester | 25027 | 100244 | 1986 | 0 | 42.35026951 | -71.90493363 | 2021-11-18 04:21:33 | Worcester, Massachusetts, US | |
2021-10-31 | US | Washington | King | 53033 | 164026 | 1986 | 0 | 47.49137892 | -121.8346131 | 2021-11-01 04:22:01 | King, Washington, US | |
2021-10-31 | Russia | Astrakhan Oblast | 66276 | 1986 | 0 | 47.1878186 | 47.608851 | 2021-11-01 04:22:01 | Astrakhan Oblast, Russia | |||
2021-10-30 | US | Washington | King | 53033 | 164026 | 1986 | 0 | 47.49137892 | -121.8346131 | 2021-10-31 04:22:08 | King, Washington, US | |
2021-10-29 | US | Washington | King | 53033 | 164026 | 1986 | 0 | 47.49137892 | -121.8346131 | 2021-10-30 04:22:03 | King, Washington, US | |
2021-10-14 | Brazil | Amapa | 123195 | 1986 | 0 | 0.902 | -52.003 | 2021-10-15 04:21:26 | Amapa, Brazil | |||
2021-10-13 | Brazil | Amapa | 123142 | 1986 | 0 | 0.902 | -52.003 | 2021-10-14 04:21:29 | Amapa, Brazil | |||
2021-10-12 | Brazil | Amapa | 123132 | 1986 | 0 | 0.902 | -52.003 | 2021-10-13 04:20:51 | Amapa, Brazil | |||
2021-10-11 | Brazil | Amapa | 123104 | 1986 | 0 | 0.902 | -52.003 | 2021-10-12 04:21:09 | Amapa, Brazil | |||
2021-10-10 | Montenegro | 135298 | 1986 | 0 | 42.708678000000006 | 19.37439 | 2021-10-11 04:21:31 | Montenegro | ||||
2021-10-10 | Brazil | Amapa | 123096 | 1986 | 0 | 0.902 | -52.003 | 2021-10-11 04:21:31 | Amapa, Brazil | |||
2021-10-09 | Brazil | Amapa | 123074 | 1986 | 0 | 0.902 | -52.003 | 2021-10-10 04:21:38 | Amapa, Brazil | |||
2021-10-08 | Brazil | Amapa | 123046 | 1986 | 0 | 0.902 | -52.003 | 2021-10-09 04:21:34 | Amapa, Brazil | |||
2021-10-07 | Brazil | Amapa | 123002 | 1986 | 0 | 0.902 | -52.003 | 2021-10-08 04:21:25 | Amapa, Brazil | |||
2021-10-06 | Brazil | Amapa | 122961 | 1986 | 0 | 0.902 | -52.003 | 2021-10-07 04:21:36 | Amapa, Brazil | |||
2021-10-05 | Brazil | Amapa | 122937 | 1986 | 0 | 0.902 | -52.003 | 2021-10-06 04:21:33 | Amapa, Brazil | |||
2021-09-26 | US | New Jersey | Passaic | 34031 | 79436 | 1986 | 0 | 41.03238628 | -74.29954144 | 2021-09-27 04:21:16 | Passaic, New Jersey, US | |
2021-09-25 | US | New Jersey | Passaic | 34031 | 79392 | 1986 | 0 | 41.03238628 | -74.29954144 | 2021-09-26 04:21:29 | Passaic, New Jersey, US | |
2021-08-11 | Russia | Stavropol Krai | 68222 | 1986 | 0 | 44.86325770000001 | 43.4406913 | 2021-08-12 04:21:25 | Stavropol Krai, Russia | |||
2021-07-22 | Spain | Asturias | 63321 | 1986 | 1063 | 60272 | 43.3614 | -5.8593 | 2021-07-23 04:21:29 | Asturias, Spain | ||
2021-07-19 | US | New Jersey | Union | 34039 | 72128 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-20 04:21:48 | Union, New Jersey, US | |
2021-07-18 | US | New Jersey | Union | 34039 | 72112 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-19 04:21:24 | Union, New Jersey, US | |
2021-07-17 | US | New Jersey | Union | 34039 | 72101 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-18 04:22:07 | Union, New Jersey, US | |
2021-07-16 | US | New Jersey | Union | 34039 | 72074 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-17 04:22:22 | Union, New Jersey, US | |
2021-07-15 | US | New Jersey | Union | 34039 | 72046 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-16 04:21:22 | Union, New Jersey, US | |
2021-07-14 | US | New Jersey | Union | 34039 | 72019 | 1986 | 0 | 40.65835409 | -74.30680092 | 2021-07-15 04:21:48 | Union, New Jersey, US | |
2021-06-10 | US | Massachusetts | Essex | 25009 | 97770 | 1986 | 0 | 42.6687626 | -70.94687179 | 2021-06-11 04:23:20 | Essex, Massachusetts, US | |
2021-06-04 | US | Pennsylvania | Allegheny | 42003 | 102067 | 1986 | 0 | 40.46809875 | -79.98167747 | 2021-06-05 04:23:03 | Allegheny, Pennsylvania, US | |
2021-04-11 | Latvia | 107608 | 1986 | 99162 | 6460 | 56.8796 | 24.6032 | 2021-04-12 04:21:00 | Latvia | |||
2021-04-10 | Latvia | 107240 | 1986 | 98247 | 7007 | 56.8796 | 24.6032 | 2021-04-11 04:20:56 | Latvia | |||
2021-04-04 | Russia | Perm Krai | 51703 | 1986 | 46312 | 3405 | 58.5951603 | 56.3159546 | 2021-04-05 04:20:35 | Perm Krai, Russia | ||
2021-03-23 | US | Connecticut | New Haven | 9009 | 77638 | 1986 | 0 | 41.4080325 | -72.93620426 | 2021-03-24 05:25:40 | New Haven, Connecticut, US | |
2021-03-23 | El Salvador | 63631 | 1986 | 60681 | 964 | 13.7942 | -88.8965 | 2021-03-24 05:25:40 | El Salvador | |||
2021-03-22 | Sudan | 31147 | 1986 | 23725 | 5436 | 12.8628 | 30.2176 | 2021-03-23 05:26:18 | Sudan | |||
2021-03-21 | Sudan | 30989 | 1986 | 23725 | 5278 | 12.8628 | 30.2176 | 2021-03-22 05:25:43 | Sudan | |||
2021-03-11 | US | Michigan | Macomb | 26099 | 61187 | 1986 | 0 | 42.69158356 | -82.92752801 | 2021-03-12 05:26:50 | Macomb, Michigan, US | |
2021-03-10 | Albania | 114840 | 1986 | 77498 | 35356 | 41.1533 | 20.1683 | 2021-03-11 05:25:48 | Albania | |||
2021-02-23 | US | Puerto Rico | Unassigned | 72999 | 2909 | 1986 | 0 | 923 | 18.459681 | -67.336525 | 2021-02-24 05:29:16 | Unassigned, Puerto Rico, US |
2021-02-22 | West Bank and Gaza | 174969 | 1986 | 162025 | 10958 | 31.9522 | 35.2332 | 2021-02-23 05:23:41 | West Bank and Gaza | |||
2021-02-15 | US | Ohio | Cuyahoga | 39035 | 92902 | 1986 | 0 | 90915 | 41.424119 | -81.65918339 | 2021-02-16 05:24:38 | Cuyahoga, Ohio, US |
2021-02-14 | US | Connecticut | Fairfield | 9001 | 76511 | 1986 | 0 | 74525 | 41.26809896 | -73.3881171 | 2021-02-15 05:24:49 | Fairfield, Connecticut, US |
2021-02-13 | US | Connecticut | Fairfield | 9001 | 76511 | 1986 | 0 | 74525 | 41.26809896 | -73.3881171 | 2021-02-14 05:23:43 | Fairfield, Connecticut, US |
2021-02-12 | US | Connecticut | Fairfield | 9001 | 76511 | 1986 | 0 | 74525 | 41.26809896 | -73.3881171 | 2021-02-13 05:22:12 | Fairfield, Connecticut, US |
2021-02-12 | Pakistan | Khyber Pakhtunkhwa | 69386 | 1986 | 65349 | 2051 | 34.485332 | 72.09169 | 2021-02-13 05:22:12 | Khyber Pakhtunkhwa, Pakistan | ||
2021-02-02 | Italy | Marche | 56009 | 1986 | 45342 | 8681 | 43.61675973 | 13.5188753 | 2021-02-03 05:22:52 | Marche, Italy | ||
2021-01-29 | Netherlands | Noord-Holland | 163943 | 1986 | 0 | 161708 | 52.60090600000001 | 4.918688 | 2021-01-30 05:22:49 | Noord-Holland, Netherlands | ||
2021-01-22 | Nepal | 268948 | 1986 | 263348 | 3614 | 28.1667 | 84.25 | 2021-01-23 05:22:03 | Nepal | |||
2020-11-23 | Mexico | Yucatan | 23238 | 1986 | 0 | 21252 | 20.7099 | -89.0943 | 2020-11-24 05:27:31 | Yucatan, Mexico | ||
2020-10-28 | Germany | Baden-Wurttemberg | 72884 | 1986 | 54611 | 18527 | 48.6616 | 9.3501 | 2020-10-29 04:24:49 | Baden-Wurttemberg, Germany | ||
2020-10-23 | US | Massachusetts | Middlesex | 25017 | 30831 | 1986 | 0 | 28588 | 42.48607732 | -71.39049229 | 2020-10-24 04:24:46 | Middlesex, Massachusetts, US |
2020-10-19 | Spain | Pais Vasco | 54200 | 1986 | 16160 | 36054 | 42.9896 | -2.6189 | 2020-10-20 04:24:22 | Pais Vasco, Spain | ||
2020-07-19 | Mexico | Puebla | 16126 | 1986 | 11575 | 2565 | 19.0414 | -98.2063 | 2020-07-20 05:34:40 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;