johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where deaths = 1723 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2136465 | 2136465 | 2022-12-01 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-12-02 04:21:07 | Navarra, Spain | |||
1964881 | 1964881 | 2022-11-30 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-12-01 04:21:03 | Navarra, Spain | |||
2556895 | 2556895 | 2022-11-29 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-30 04:21:07 | Navarra, Spain | |||
1239969 | 1239969 | 2022-11-28 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-29 04:21:05 | Navarra, Spain | |||
3551957 | 3551957 | 2022-11-27 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-28 04:21:02 | Navarra, Spain | |||
2100437 | 2100437 | 2022-11-26 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-27 04:21:05 | Navarra, Spain | |||
487928 | 487928 | 2022-11-25 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-26 04:21:11 | Navarra, Spain | |||
1346003 | 1346003 | 2022-08-10 | Australia | Queensland | 1565788 | 1723 | 0 | -27.4698 | 153.0251 | 2022-08-11 04:20:49 | Queensland, Australia | |||
2596966 | 2596966 | 2022-07-25 | US | Tennessee | Davidson | 47037 | 212035 | 1723 | 0 | 36.17007426 | -86.78646056 | 2022-07-26 04:20:58 | Davidson, Tennessee, US | |
2788806 | 2788806 | 2022-07-10 | Chile | Coquimbo | 154334 | 1723 | 0 | -29.959 | -71.3389 | 2022-07-11 04:20:46 | Coquimbo, Chile | |||
2727536 | 2727536 | 2022-05-28 | US | Ohio | Summit | 39153 | 117609 | 1723 | 0 | 41.12464734 | -81.53123079 | 2022-05-29 04:20:53 | Summit, Ohio, US | |
3000941 | 3000941 | 2022-05-24 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-25 04:20:56 | Genesee, Michigan, US | |
3594662 | 3594662 | 2022-05-23 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-24 04:20:57 | Genesee, Michigan, US | |
1111210 | 1111210 | 2022-05-21 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-22 04:20:52 | Genesee, Michigan, US | |
1170834 | 1170834 | 2022-05-20 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-21 04:20:58 | Genesee, Michigan, US | |
3897597 | 3897597 | 2022-05-19 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-20 04:20:57 | Genesee, Michigan, US | |
1187262 | 1187262 | 2022-05-18 | US | Ohio | Stark | 39151 | 80794 | 1723 | 0 | 40.81482476 | -81.36437305 | 2022-05-19 04:20:54 | Stark, Ohio, US | |
1186381 | 1186381 | 2022-05-18 | US | Michigan | Genesee | 26049 | 104674 | 1723 | 0 | 43.02244215 | -83.70589709 | 2022-05-19 04:20:54 | Genesee, Michigan, US | |
1951751 | 1951751 | 2022-04-12 | US | Texas | Travis | 48453 | 240690 | 1723 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-13 04:21:03 | Travis, Texas, US | |
1436825 | 1436825 | 2022-03-28 | Russia | Pskov Oblast | 106774 | 1723 | 0 | 57.535872899999994 | 28.8586826 | 2022-03-29 04:20:46 | Pskov Oblast, Russia | |||
694141 | 694141 | 2022-03-17 | Canada | Manitoba | 133745 | 1723 | 0 | 53.7609 | -98.8139 | 2022-03-18 04:20:55 | Manitoba, Canada | |||
1058086 | 1058086 | 2022-02-23 | Russia | Orel Oblast | 96042 | 1723 | 0 | 52.96854329999999 | 36.0692477 | 2022-02-24 04:21:14 | Orel Oblast, Russia | |||
3718084 | 3718084 | 2022-02-21 | Germany | Mecklenburg-Vorpommern | 213308 | 1723 | 0 | 53.6127 | 12.4296 | 2022-02-22 04:21:01 | Mecklenburg-Vorpommern, Germany | |||
981616 | 981616 | 2022-02-01 | US | Pennsylvania | Delaware | 42045 | 106289 | 1723 | 0 | 39.91680171 | -75.40243663 | 2022-02-02 04:21:09 | Delaware, Pennsylvania, US | |
554754 | 554754 | 2022-01-16 | Italy | Calabria | 145097 | 1723 | 0 | 38.90597598 | 16.59440194 | 2022-01-17 04:21:08 | Calabria, Italy | |||
3519644 | 3519644 | 2022-01-02 | Russia | Kemerovo Oblast | 85554 | 1723 | 0 | 54.53357809999999 | 87.342861 | 2022-01-03 02:22:25 | Kemerovo Oblast, Russia | |||
1668435 | 1668435 | 2021-12-29 | Italy | Sardegna | 86290 | 1723 | 0 | 39.21531192 | 9.110616306 | 2021-12-30 04:21:25 | Sardegna, Italy | |||
161899 | 161899 | 2021-11-19 | Estonia | 216081 | 1723 | 0 | 58.5953 | 25.0136 | 2021-11-20 04:22:17 | Estonia | ||||
30001 | 30001 | 2021-11-11 | US | Maryland | Montgomery | 24031 | 83349 | 1723 | 0 | 39.13676329 | -77.20358245 | 2021-11-12 04:22:01 | Montgomery, Maryland, US | |
2846440 | 2846440 | 2021-11-10 | US | Maryland | Montgomery | 24031 | 83259 | 1723 | 0 | 39.13676329 | -77.20358245 | 2021-11-11 04:21:45 | Montgomery, Maryland, US | |
2844530 | 2844530 | 2021-11-10 | Angola | 64815 | 1723 | 0 | -11.2027 | 17.8739 | 2021-11-11 04:21:45 | Angola | ||||
88710 | 88710 | 2021-11-09 | US | Maryland | Montgomery | 24031 | 83163 | 1723 | 0 | 39.13676329 | -77.20358245 | 2021-11-10 04:21:38 | Montgomery, Maryland, US | |
86800 | 86800 | 2021-11-09 | Angola | 64762 | 1723 | 0 | -11.2027 | 17.8739 | 2021-11-10 04:21:38 | Angola | ||||
2004306 | 2004306 | 2021-11-07 | Ukraine | Ternopil Oblast | 94460 | 1723 | 0 | 49.5535 | 25.5948 | 2021-11-08 04:21:43 | Ternopil Oblast, Ukraine | |||
568689 | 568689 | 2021-10-29 | US | Maryland | Prince George's | 24033 | 99689 | 1723 | 0 | 38.83070039 | -76.8496441 | 2021-10-30 04:22:03 | Prince George's, Maryland, US | |
5931 | 5931 | 2021-10-28 | US | Maryland | Prince George's | 24033 | 99599 | 1723 | 0 | 38.83070039 | -76.8496441 | 2021-10-29 04:22:03 | Prince George's, Maryland, US | |
444160 | 444160 | 2021-10-20 | US | Georgia | Fulton | 13121 | 131107 | 1723 | 0 | 33.79216944 | -84.46319413 | 2021-10-21 04:21:18 | Fulton, Georgia, US | |
491892 | 491892 | 2021-10-14 | Russia | Tver Oblast | 70481 | 1723 | 0 | 57.1134475 | 35.174442799999994 | 2021-10-15 04:21:26 | Tver Oblast, Russia | |||
2135061 | 2135061 | 2021-10-01 | US | Texas | Cameron | 48061 | 67689 | 1723 | 0 | 26.14524221 | -97.48140372 | 2021-10-02 04:21:25 | Cameron, Texas, US | |
2808604 | 2808604 | 2021-09-16 | Colombia | Quindio | 55987 | 1723 | 0 | 4.461 | -75.6674 | 2021-09-17 04:21:46 | Quindio, Colombia | |||
1374349 | 1374349 | 2021-09-15 | Colombia | Quindio | 55933 | 1723 | 0 | 4.461 | -75.6674 | 2021-09-16 04:22:19 | Quindio, Colombia | |||
1778999 | 1778999 | 2021-08-30 | Ukraine | Vinnytsia Oblast | 72452 | 1723 | 0 | 49.2331 | 28.4682 | 2021-08-31 04:21:46 | Vinnytsia Oblast, Ukraine | |||
35858 | 35858 | 2021-08-25 | US | Washington | King | 53033 | 131876 | 1723 | 0 | 47.49137892 | -121.8346131 | 2021-08-26 04:21:28 | King, Washington, US | |
507475 | 507475 | 2021-08-14 | Chile | Maule | 100436 | 1723 | 0 | -35.5183 | -71.6885 | 2021-08-15 04:21:41 | Maule, Chile | |||
2354474 | 2354474 | 2021-08-10 | US | Texas | Cameron | 48061 | 57819 | 1723 | 0 | 26.14524221 | -97.48140372 | 2021-08-11 04:21:58 | Cameron, Texas, US | |
411917 | 411917 | 2021-07-28 | Ukraine | Crimea Republic* | 58680 | 1723 | 49699 | 7258 | 45.2835 | 34.2008 | 2021-07-29 04:21:33 | Crimea Republic*, Ukraine | ||
1330326 | 1330326 | 2021-07-24 | Mexico | Chiapas | 13452 | 1723 | 0 | 11729 | 16.7569 | -93.1292 | 2021-07-25 04:22:12 | Chiapas, Mexico | ||
2764785 | 2764785 | 2021-07-01 | Colombia | Meta | 72763 | 1723 | 69022 | 2018 | 3.272 | -73.0877 | 2021-07-02 04:21:47 | Meta, Colombia | ||
2422640 | 2422640 | 2021-06-23 | Brazil | Roraima | 110820 | 1723 | 102722 | 5343 | -2.7376 | -62.0751 | 2021-06-24 04:21:55 | Roraima, Brazil | ||
2884330 | 2884330 | 2021-06-20 | India | Puducherry | 114847 | 1723 | 109562 | 3562 | 11.882658 | 78.86498 | 2021-06-21 04:21:41 | Puducherry, India | ||
3030018 | 3030018 | 2021-06-16 | Brazil | Acre | 84450 | 1723 | 79110 | 3617 | -9.0238 | -70.812 | 2021-06-17 04:22:36 | Acre, Brazil | ||
525540 | 525540 | 2021-06-09 | US | Pennsylvania | Montgomery | 42091 | 70415 | 1723 | 0 | 40.21053671 | -75.36652296 | 2021-06-10 04:23:17 | Montgomery, Pennsylvania, US | |
3474980 | 3474980 | 2021-06-08 | US | Pennsylvania | Montgomery | 42091 | 70402 | 1723 | 0 | 40.21053671 | -75.36652296 | 2021-06-09 04:23:31 | Montgomery, Pennsylvania, US | |
3578214 | 3578214 | 2021-05-17 | Ukraine | Chernivtsi Oblast | 78432 | 1723 | 70693 | 6016 | 48.2917 | 25.9352 | 2021-05-18 04:20:33 | Chernivtsi Oblast, Ukraine | ||
3057822 | 3057822 | 2021-05-13 | Ukraine | Mykolaiv Oblast | 65579 | 1723 | 61419 | 2437 | 46.975 | 31.9946 | 2021-05-14 04:20:41 | Mykolaiv Oblast, Ukraine | ||
1553685 | 1553685 | 2021-05-08 | US | Minnesota | Hennepin | 27053 | 121633 | 1723 | 0 | 45.00761521 | -93.47694895 | 2021-05-09 04:20:35 | Hennepin, Minnesota, US | |
1411269 | 1411269 | 2021-04-23 | US | New York | Erie | 36029 | 84353 | 1723 | 0 | 42.76249024 | -78.73063652 | 2021-04-24 04:20:38 | Erie, New York, US | |
1410148 | 1410148 | 2021-04-23 | US | Indiana | Marion | 18097 | 97182 | 1723 | 0 | 39.78163624 | -86.13826325 | 2021-04-24 04:20:38 | Marion, Indiana, US | |
1569211 | 1569211 | 2021-04-22 | US | Indiana | Marion | 18097 | 97018 | 1723 | 0 | 39.78163624 | -86.13826325 | 2021-04-23 04:20:52 | Marion, Indiana, US | |
1568336 | 1568336 | 2021-04-22 | Russia | Novosibirsk Oblast | 40501 | 1723 | 37507 | 1271 | 54.9720169 | 79.48139240000002 | 2021-04-23 04:20:52 | Novosibirsk Oblast, Russia | ||
388190 | 388190 | 2021-04-04 | India | Telangana | 313237 | 1723 | 302768 | 8746 | 18.1124 | 79.0193 | 2021-04-05 04:20:35 | Telangana, India | ||
3452910 | 3452910 | 2021-03-18 | Kosovo | 78340 | 1723 | 65596 | 11021 | 42.602636 | 20.902977 | 2021-03-19 05:26:09 | Kosovo | |||
3621134 | 3621134 | 2021-03-17 | Kosovo | 78340 | 1723 | 65596 | 11021 | 42.602636 | 20.902977 | 2021-03-18 05:26:22 | Kosovo | |||
702458 | 702458 | 2021-03-16 | Kosovo | 78340 | 1723 | 65596 | 11021 | 42.602636 | 20.902977 | 2021-03-17 05:25:07 | Kosovo | |||
2208225 | 2208225 | 2021-03-04 | US | California | Santa Clara | 6085 | 111776 | 1723 | 0 | 110084 | 37.23104908 | -121.6970462 | 2021-03-05 05:26:29 | Santa Clara, California, US |
2183432 | 2183432 | 2021-02-26 | Colombia | Huila | 49545 | 1723 | 47369 | 453 | 2.5359 | -75.5277 | 2021-02-27 05:22:28 | Huila, Colombia | ||
1759453 | 1759453 | 2021-01-24 | Peru | Cusco | 27260 | 1723 | 0 | 25537 | -13.191068 | -72.153609 | 2021-01-25 05:22:16 | Cusco, Peru | ||
3879627 | 3879627 | 2021-01-14 | Kenya | 98693 | 1723 | 81933 | 15037 | -0.0236 | 37.9062 | 2021-01-15 05:22:24 | Kenya | |||
774335 | 774335 | 2021-01-12 | Italy | Marche | 47647 | 1723 | 31734 | 14190 | 43.61675973 | 13.5188753 | 2021-01-13 05:22:15 | Marche, Italy | ||
931315 | 931315 | 2020-12-21 | Ukraine | Kiev | 101123 | 1723 | 32739 | 66661 | 50.4501 | 30.5234 | 2020-12-22 05:22:33 | Kiev, Ukraine | ||
1821843 | 1821843 | 2020-12-08 | US | Texas | Dallas | 48113 | 126775 | 1723 | 0 | 149217 | 32.76670599 | -96.7779605 | 2020-12-09 05:28:01 | Dallas, Texas, US |
1632297 | 1632297 | 2020-12-05 | Italy | Sicilia | 70467 | 1723 | 29204 | 39540 | 38.11569725 | 13.362356699999998 | 2020-12-06 05:26:18 | Sicilia, Italy | ||
2856811 | 2856811 | 2020-10-16 | India | Rajasthan | 169289 | 1723 | 146185 | 21381 | 26.583423 | 73.847973 | 2020-10-17 04:24:12 | Rajasthan, India | ||
3117580 | 3117580 | 2020-10-06 | Mexico | Quintana Roo | 12459 | 1723 | 10270 | 466 | 19.1817 | -88.4791 | 2020-10-07 04:23:40 | Quintana Roo, Mexico | ||
2454851 | 2454851 | 2020-09-19 | Mexico | Coahuila | 24766 | 1723 | 22020 | 1023 | 27.0587 | -101.7068 | 2020-09-20 04:22:00 | Coahuila, Mexico | ||
1271041 | 1271041 | 2020-06-11 | US | New Jersey | Essex | 34013 | 18284 | 1723 | 0 | 16561 | 40.78681335 | -74.24657979 | 2020-06-12 05:09:52 | Essex, New Jersey, US |
2861486 | 2861486 | 2020-06-10 | US | New Jersey | Essex | 34013 | 18251 | 1723 | 0 | 16528 | 40.78681335 | -74.24657979 | 2020-06-11 03:33:41 | Essex, New Jersey, US |
114336 | 114336 | 2020-05-08 | Russia | 187859 | 1723 | 26608 | 159528 | 61.52401 | 105.318756 | 2020-05-09 02:32:35 | Russia |
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]);