johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where deaths = 2769 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755372 | 2755372 | 2022-12-29 | US | Ohio | Franklin | 39049 | 357732 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-30 04:21:04 | Franklin, Ohio, US | |
1076378 | 1076378 | 2022-12-28 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-29 04:21:01 | Franklin, Ohio, US | |
330375 | 330375 | 2022-12-27 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-28 04:21:04 | Franklin, Ohio, US | |
220448 | 220448 | 2022-12-26 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-27 04:21:07 | Franklin, Ohio, US | |
3224905 | 3224905 | 2022-12-25 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-26 04:21:06 | Franklin, Ohio, US | |
1020819 | 1020819 | 2022-12-24 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-25 04:21:04 | Franklin, Ohio, US | |
692842 | 692842 | 2022-12-23 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-24 04:21:02 | Franklin, Ohio, US | |
2182052 | 2182052 | 2022-12-22 | US | Ohio | Franklin | 39049 | 356421 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-23 04:21:04 | Franklin, Ohio, US | |
453856 | 453856 | 2022-12-21 | US | Ohio | Franklin | 39049 | 354558 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-22 04:20:56 | Franklin, Ohio, US | |
2953855 | 2953855 | 2022-12-20 | US | Ohio | Franklin | 39049 | 354558 | 2769 | 0 | 39.96995815 | -83.01115755 | 2022-12-21 04:21:03 | Franklin, Ohio, US | |
1755512 | 1755512 | 2022-11-18 | Russia | Kemerovo Oblast | 210230 | 2769 | 0 | 54.5335781 | 87.342861 | 2022-11-19 04:21:14 | Kemerovo Oblast, Russia | |||
3277129 | 3277129 | 2022-10-23 | Russia | Tver Oblast | 178271 | 2769 | 0 | 57.1134475 | 35.1744428 | 2022-10-24 04:22:29 | Tver Oblast, Russia | |||
2268167 | 2268167 | 2022-10-22 | Russia | Tver Oblast | 178239 | 2769 | 0 | 57.1134475 | 35.1744428 | 2022-10-23 04:22:46 | Tver Oblast, Russia | |||
1592467 | 1592467 | 2022-10-21 | Russia | Tver Oblast | 178203 | 2769 | 0 | 57.1134475 | 35.1744428 | 2022-10-22 04:22:53 | Tver Oblast, Russia | |||
2272183 | 2272183 | 2022-10-20 | Russia | Tver Oblast | 178167 | 2769 | 0 | 57.1134475 | 35.1744428 | 2022-10-21 04:22:23 | Tver Oblast, Russia | |||
2685674 | 2685674 | 2022-10-03 | Italy | Sardegna | 450714 | 2769 | 0 | 39.21531192 | 9.110616306 | 2022-10-04 04:22:55 | Sardegna, Italy | |||
2323463 | 2323463 | 2022-08-24 | Montenegro | 273893 | 2769 | 0 | 42.708678 | 19.37439 | 2022-08-25 04:21:13 | Montenegro | ||||
3647489 | 3647489 | 2022-08-14 | Germany | Schleswig-Holstein | 955777 | 2769 | 0 | 54.2194 | 9.6961 | 2022-08-15 04:20:59 | Schleswig-Holstein, Germany | |||
1968495 | 1968495 | 2022-08-13 | Germany | Schleswig-Holstein | 955777 | 2769 | 0 | 54.2194 | 9.6961 | 2022-08-14 04:20:55 | Schleswig-Holstein, Germany | |||
2888304 | 2888304 | 2022-08-12 | Germany | Schleswig-Holstein | 955777 | 2769 | 0 | 54.2194 | 9.6961 | 2022-08-13 04:20:52 | Schleswig-Holstein, Germany | |||
2596315 | 2596315 | 2022-07-25 | US | New York | Westchester | 36119 | 291087 | 2769 | 0 | 41.16278376 | -73.75741653 | 2022-07-26 04:20:58 | Westchester, New York, US | |
3899409 | 3899409 | 2022-05-19 | US | Washington | King | 53033 | 415703 | 2769 | 0 | 47.49137892 | -121.8346131 | 2022-05-20 04:20:57 | King, Washington, US | |
1188193 | 1188193 | 2022-05-18 | US | Washington | King | 53033 | 415703 | 2769 | 0 | 47.49137892 | -121.8346131 | 2022-05-19 04:20:54 | King, Washington, US | |
1572403 | 1572403 | 2022-05-03 | Russia | Yaroslavl Oblast | 159628 | 2769 | 0 | 57.7781976 | 39.0021095 | 2022-05-04 04:20:59 | Yaroslavl Oblast, Russia | |||
1156833 | 1156833 | 2022-04-29 | Australia | New South Wales | 2278053 | 2769 | 0 | -33.8688 | 151.2093 | 2022-04-30 04:21:05 | New South Wales, Australia | |||
2115841 | 2115841 | 2022-04-08 | Netherlands | Gelderland | 972613 | 2769 | 0 | 52.061738 | 5.939114 | 2022-04-09 04:20:42 | Gelderland, Netherlands | |||
2264560 | 2264560 | 2022-03-14 | US | Connecticut | New Haven | 9009 | 193275 | 2769 | 0 | 41.408032500000004 | -72.93620426 | 2022-03-15 04:20:47 | New Haven, Connecticut, US | |
1298243 | 1298243 | 2022-02-17 | Russia | Astrakhan Oblast | 102382 | 2769 | 0 | 47.1878186 | 47.608851 | 2022-02-18 04:21:04 | Astrakhan Oblast, Russia | |||
1298036 | 1298036 | 2022-02-17 | Jamaica | 127377 | 2769 | 0 | 18.1096 | -77.2975 | 2022-02-18 04:21:04 | Jamaica | ||||
3998880 | 3998880 | 2021-12-30 | Russia | Murmansk Oblast | 91683 | 2769 | 0 | 68.00004179999999 | 33.9999151 | 2021-12-31 04:21:50 | Murmansk Oblast, Russia | |||
798492 | 798492 | 2021-12-22 | Malaysia | Sabah | 239026 | 2769 | 0 | 5.9788 | 116.0753 | 2021-12-23 04:21:21 | Sabah, Malaysia | |||
1806371 | 1806371 | 2021-11-25 | Ukraine | Chernivtsi Oblast | 114906 | 2769 | 0 | 48.2917 | 25.9352 | 2021-11-26 04:22:33 | Chernivtsi Oblast, Ukraine | |||
1803002 | 1803002 | 2021-11-25 | Russia | Tyumen Oblast | 79289 | 2769 | 0 | 58.8206488 | 70.36588370000001 | 2021-11-26 04:22:33 | Tyumen Oblast, Russia | |||
3344280 | 3344280 | 2021-11-16 | US | Michigan | Macomb | 26099 | 130309 | 2769 | 0 | 42.69158356 | -82.92752801 | 2021-11-17 04:21:48 | Macomb, Michigan, US | |
2289116 | 2289116 | 2021-11-15 | US | Michigan | Macomb | 26099 | 130309 | 2769 | 0 | 42.69158356 | -82.92752801 | 2021-11-16 04:21:10 | Macomb, Michigan, US | |
3640009 | 3640009 | 2021-11-08 | US | Arizona | Pima | 4019 | 147945 | 2769 | 0 | 32.0971334 | -111.7890033 | 2021-11-09 04:21:36 | Pima, Arizona, US | |
3639812 | 3639812 | 2021-11-08 | Russia | Udmurt Republic | 66881 | 2769 | 0 | 57.1961165 | 52.69598320000001 | 2021-11-09 04:21:36 | Udmurt Republic, Russia | |||
2001117 | 2001117 | 2021-11-07 | US | Arizona | Pima | 4019 | 147471 | 2769 | 0 | 32.0971334 | -111.7890033 | 2021-11-08 04:21:43 | Pima, Arizona, US | |
496108 | 496108 | 2021-11-06 | US | Arizona | Pima | 4019 | 146926 | 2769 | 0 | 32.0971334 | -111.7890033 | 2021-11-07 04:21:53 | Pima, Arizona, US | |
2943495 | 2943495 | 2021-10-15 | Nigeria | 208797 | 2769 | 0 | 9.082 | 8.6753 | 2021-10-16 04:21:15 | Nigeria | ||||
1385734 | 1385734 | 2021-09-13 | Mexico | Tlaxcala | 27051 | 2769 | 0 | 19.3139 | -98.2404 | 2021-09-14 04:21:41 | Tlaxcala, Mexico | |||
67256 | 67256 | 2021-09-01 | Russia | Chelyabinsk Oblast | 85335 | 2769 | 0 | 54.4223954 | 61.1865846 | 2021-09-02 04:21:15 | Chelyabinsk Oblast, Russia | |||
2521253 | 2521253 | 2021-08-18 | US | Texas | El Paso | 48141 | 119958 | 2769 | 0 | 31.76980765 | -106.23632749999999 | 2021-08-19 04:21:15 | El Paso, Texas, US | |
1483440 | 1483440 | 2021-08-13 | El Salvador | 90129 | 2769 | 0 | 13.7942 | -88.8965 | 2021-08-14 04:21:25 | El Salvador | ||||
2423196 | 2423196 | 2021-06-23 | Sri Lanka | 246109 | 2769 | 211186 | 32154 | 7.873054 | 80.77179699999998 | 2021-06-24 04:21:55 | Sri Lanka | |||
955035 | 955035 | 2021-04-25 | Peru | Puno | 28181 | 2769 | 0 | 25412 | -14.995826999999998 | -69.922726 | 2021-04-26 04:21:04 | Puno, Peru | ||
983625 | 983625 | 2021-04-17 | US | Florida | Broward | 12011 | 227738 | 2769 | 0 | 26.15184651 | -80.48725556 | 2021-04-18 04:20:41 | Broward, Florida, US | |
2573836 | 2573836 | 2021-04-13 | US | New Jersey | Bergen | 34003 | 96748 | 2769 | 0 | 40.96010917 | -74.07164325 | 2021-04-14 04:20:41 | Bergen, New Jersey, US | |
3088410 | 3088410 | 2021-04-05 | US | Texas | Hidalgo | 48215 | 92822 | 2769 | 0 | 26.39418217 | -98.18299696 | 2021-04-06 04:20:32 | Hidalgo, Texas, US | |
388077 | 388077 | 2021-04-04 | Colombia | Norte de Santander | 52127 | 2769 | 48767 | 591 | 7.9463 | -72.8988 | 2021-04-05 04:20:35 | Norte de Santander, Colombia | ||
3709993 | 3709993 | 2021-04-03 | Colombia | Norte de Santander | 52097 | 2769 | 48730 | 598 | 7.9463 | -72.8988 | 2021-04-04 04:20:49 | Norte de Santander, Colombia | ||
1880875 | 1880875 | 2021-03-26 | Ethiopia | 196621 | 2769 | 152508 | 41344 | 9.145 | 40.4897 | 2021-03-27 05:25:04 | Ethiopia | |||
3503522 | 3503522 | 2021-01-17 | Peru | Loreto | 26677 | 2769 | 0 | 23908 | -4.124847 | -74.424115 | 2021-01-18 05:22:34 | Loreto, Peru | ||
2227211 | 2227211 | 2021-01-02 | Algeria | 100159 | 2769 | 67611 | 29779 | 28.0339 | 1.6596 | 2021-01-03 05:22:52 | Algeria | |||
2119461 | 2119461 | 2020-12-20 | Brazil | Piaui | 138152 | 2769 | 134737 | 442 | -7.7183 | -42.7289 | 2020-12-21 05:27:58 | Piaui, Brazil | ||
3264721 | 3264721 | 2020-07-31 | Brazil | Minas Gerais | 127106 | 2769 | 97048 | 27289 | -18.5122 | -44.555 | 2020-08-01 04:36:27 | Minas Gerais, Brazil | ||
2958650 | 2958650 | 2020-07-29 | Canada | Ontario | 39536 | 2769 | 36268 | 1792 | 51.2538 | -85.3232 | 2020-07-30 04:35:05 | Ontario, Canada | ||
1273591 | 1273591 | 2020-06-11 | Peru | Piura | 12177 | 2769 | 0 | 9408 | -5.133361 | -80.335861 | 2020-06-12 05:09:52 | Piura, Peru | ||
3084926 | 3084926 | 2020-05-04 | Sweden | 22721 | 2769 | 4074 | 15878 | 60.128161 | 18.643501 | 2020-05-05 02:32:34 | Sweden |
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]);