johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where deaths = 2708 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
911987 | 911987 | 2022-10-29 | Chile | OHiggins | 202644 | 2708 | 0 | -34.5755 | -71.0022 | 2022-10-30 04:22:14 | OHiggins, Chile | |||
2268122 | 2268122 | 2022-10-22 | Russia | Kemerovo Oblast | 207891 | 2708 | 0 | 54.5335781 | 87.342861 | 2022-10-23 04:22:46 | Kemerovo Oblast, Russia | |||
1812502 | 1812502 | 2022-10-05 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-06 04:21:22 | Hennepin, Minnesota, US | |
132476 | 132476 | 2022-10-04 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-05 04:23:06 | Hennepin, Minnesota, US | |
2687423 | 2687423 | 2022-10-03 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-04 04:22:55 | Hennepin, Minnesota, US | |
2261490 | 2261490 | 2022-10-02 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-03 04:23:11 | Hennepin, Minnesota, US | |
2997016 | 2997016 | 2022-10-01 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-02 04:21:23 | Hennepin, Minnesota, US | |
855342 | 855342 | 2022-09-30 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-10-01 04:23:01 | Hennepin, Minnesota, US | |
2377268 | 2377268 | 2022-09-29 | US | Minnesota | Hennepin | 27053 | 360772 | 2708 | 0 | 45.00761521 | -93.47694895 | 2022-09-30 04:23:09 | Hennepin, Minnesota, US | |
2357936 | 2357936 | 2022-09-16 | US | Ohio | Franklin | 39049 | 338573 | 2708 | 0 | 39.96995815 | -83.01115755 | 2022-09-17 04:20:19 | Franklin, Ohio, US | |
114736 | 114736 | 2022-09-06 | Japan | Aichi | 1257634 | 2708 | 0 | 35.035551 | 137.211621 | 2022-09-07 04:20:59 | Aichi, Japan | |||
3773884 | 3773884 | 2022-08-30 | Italy | Sardegna | 438675 | 2708 | 0 | 39.21531192 | 9.110616306 | 2022-08-31 04:20:57 | Sardegna, Italy | |||
1065957 | 1065957 | 2022-07-28 | Mexico | Baja California Sur | 119637 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-29 04:20:45 | Baja California Sur, Mexico | |||
2335476 | 2335476 | 2022-07-27 | Mexico | Baja California Sur | 119637 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-28 04:20:56 | Baja California Sur, Mexico | |||
1489822 | 1489822 | 2022-07-26 | US | New York | Erie | 36029 | 241261 | 2708 | 0 | 42.76249024 | -78.73063652 | 2022-07-27 04:21:04 | Erie, New York, US | |
1487666 | 1487666 | 2022-07-26 | Mexico | Baja California Sur | 118946 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-27 04:21:04 | Baja California Sur, Mexico | |||
2596268 | 2596268 | 2022-07-25 | US | New York | Erie | 36029 | 241118 | 2708 | 0 | 42.76249024 | -78.73063652 | 2022-07-26 04:20:58 | Erie, New York, US | |
2594112 | 2594112 | 2022-07-25 | Mexico | Baja California Sur | 118946 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-26 04:20:58 | Baja California Sur, Mexico | |||
896227 | 896227 | 2022-07-24 | Mexico | Baja California Sur | 118872 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-25 04:20:51 | Baja California Sur, Mexico | |||
91221 | 91221 | 2022-07-23 | Mexico | Baja California Sur | 118773 | 2708 | 0 | 26.0444 | -111.6661 | 2022-07-24 04:20:47 | Baja California Sur, Mexico | |||
1848257 | 1848257 | 2022-04-18 | US | New York | Westchester | 36119 | 255017 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-19 04:21:00 | Westchester, New York, US | |
3420366 | 3420366 | 2022-04-17 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-18 04:21:12 | King, Washington, US | |
3419201 | 3419201 | 2022-04-17 | US | New York | Westchester | 36119 | 254506 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-18 04:21:12 | Westchester, New York, US | |
307315 | 307315 | 2022-04-16 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-17 04:20:59 | King, Washington, US | |
306150 | 306150 | 2022-04-16 | US | New York | Westchester | 36119 | 254506 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-17 04:20:59 | Westchester, New York, US | |
2673260 | 2673260 | 2022-04-15 | US | Washington | King | 53033 | 384135 | 2708 | 0 | 47.49137892 | -121.8346131 | 2022-04-16 04:20:48 | King, Washington, US | |
2672095 | 2672095 | 2022-04-15 | US | New York | Westchester | 36119 | 254172 | 2708 | 0 | 41.16278376 | -73.75741653 | 2022-04-16 04:20:48 | Westchester, New York, US | |
2442870 | 2442870 | 2022-04-13 | Montenegro | 233908 | 2708 | 0 | 42.708678000000006 | 19.37439 | 2022-04-13 23:21:06 | Montenegro | ||||
1948627 | 1948627 | 2022-04-12 | Montenegro | 233834 | 2708 | 0 | 42.708678000000006 | 19.37439 | 2022-04-13 04:21:03 | Montenegro | ||||
3022822 | 3022822 | 2022-03-23 | US | California | Fresno | 6019 | 253736 | 2708 | 0 | 36.75733899 | -119.6466953 | 2022-03-24 04:20:43 | Fresno, California, US | |
263705 | 263705 | 2022-03-15 | US | New Jersey | Hudson | 34017 | 169428 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-16 04:20:50 | Hudson, New Jersey, US | |
2266064 | 2266064 | 2022-03-14 | US | New Jersey | Hudson | 34017 | 169369 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-15 04:20:47 | Hudson, New Jersey, US | |
358499 | 358499 | 2022-03-11 | US | New Jersey | Hudson | 34017 | 169267 | 2708 | 0 | 40.73766234 | -74.07515667 | 2022-03-12 04:20:50 | Hudson, New Jersey, US | |
2446840 | 2446840 | 2022-02-22 | Malaysia | W.P. Kuala Lumpur | 241712 | 2708 | 0 | 3.139 | 101.6869 | 2022-02-23 04:21:09 | W.P. Kuala Lumpur, Malaysia | |||
1464068 | 1464068 | 2022-02-10 | Jamaica | 126589 | 2708 | 0 | 18.1096 | -77.2975 | 2022-02-11 04:21:09 | Jamaica | ||||
1695950 | 1695950 | 2022-01-10 | Ukraine | Kherson Oblast | 79283 | 2708 | 0 | 46.6354 | 32.6169 | 2022-01-11 04:22:01 | Kherson Oblast, Ukraine | |||
3607040 | 3607040 | 2021-12-25 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-26 04:21:50 | St. Louis, Missouri, US | |
2965358 | 2965358 | 2021-12-24 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-25 04:21:37 | St. Louis, Missouri, US | |
3818390 | 3818390 | 2021-12-23 | US | Missouri | St. Louis | 29189 | 145630 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-24 04:21:34 | St. Louis, Missouri, US | |
800398 | 800398 | 2021-12-22 | US | Missouri | St. Louis | 29189 | 144627 | 2708 | 0 | 38.63770039999999 | -90.4458375 | 2021-12-23 04:21:21 | St. Louis, Missouri, US | |
722720 | 722720 | 2021-11-20 | Russia | Leningrad Oblast | 86403 | 2708 | 0 | 60.185329599999996 | 32.3925325 | 2021-11-21 04:22:13 | Leningrad Oblast, Russia | |||
1325872 | 1325872 | 2021-11-14 | Ukraine | Poltava Oblast | 113098 | 2708 | 0 | 49.5883 | 34.5514 | 2021-11-15 04:21:36 | Poltava Oblast, Ukraine | |||
28186 | 28186 | 2021-11-11 | Chile | Biobio | 155525 | 2708 | 0 | -37.4464 | -72.1416 | 2021-11-12 04:22:01 | Biobio, Chile | |||
45367 | 45367 | 2021-11-02 | US | Michigan | Macomb | 26099 | 123374 | 2708 | 0 | 42.69158356 | -82.92752801 | 2021-11-03 06:22:09 | Macomb, Michigan, US | |
3513063 | 3513063 | 2021-11-01 | US | Michigan | Macomb | 26099 | 123374 | 2708 | 0 | 42.69158356 | -82.92752801 | 2021-11-02 04:22:03 | Macomb, Michigan, US | |
534597 | 534597 | 2021-10-27 | Denmark | 380949 | 2708 | 0 | 56.2639 | 9.5018 | 2021-10-28 04:22:08 | Denmark | ||||
3794350 | 3794350 | 2021-10-25 | US | Arizona | Pima | 4019 | 141870 | 2708 | 0 | 32.0971334 | -111.7890033 | 2021-10-26 04:22:09 | Pima, Arizona, US | |
682796 | 682796 | 2021-10-24 | US | Arizona | Pima | 4019 | 141869 | 2708 | 0 | 32.0971334 | -111.7890033 | 2021-10-25 04:22:31 | Pima, Arizona, US | |
682540 | 682540 | 2021-10-24 | Russia | Dagestan Republic | 54908 | 2708 | 0 | 43.05749160000001 | 47.1332224 | 2021-10-25 04:22:31 | Dagestan Republic, Russia | |||
2876301 | 2876301 | 2021-10-09 | Mexico | Nayarit | 33248 | 2708 | 0 | 21.7514 | -104.8455 | 2021-10-10 04:21:38 | Nayarit, Mexico | |||
2959467 | 2959467 | 2021-10-08 | Mexico | Nayarit | 33248 | 2708 | 0 | 21.7514 | -104.8455 | 2021-10-09 04:21:34 | Nayarit, Mexico | |||
2462440 | 2462440 | 2021-10-06 | Ukraine | Zaporizhia Oblast | 116940 | 2708 | 0 | 47.8388 | 35.1396 | 2021-10-07 04:21:36 | Zaporizhia Oblast, Ukraine | |||
3833536 | 3833536 | 2021-10-05 | US | Illinois | Unassigned | 90017 | 279 | 2708 | 0 | 42.36542373 | 0.0 | 2021-10-06 04:21:33 | Unassigned, Illinois, US | |
3281102 | 3281102 | 2021-09-05 | Russia | Novosibirsk Oblast | 59349 | 2708 | 0 | 54.9720169 | 79.48139240000002 | 2021-09-06 04:21:22 | Novosibirsk Oblast, Russia | |||
483622 | 483622 | 2021-07-19 | Japan | Osaka | 106969 | 2708 | 100719 | 3542 | 34.620965000000005 | 135.507481 | 2021-07-20 04:21:48 | Osaka, Japan | ||
2673845 | 2673845 | 2021-07-18 | Japan | Osaka | 106745 | 2708 | 100611 | 3426 | 34.620965000000005 | 135.507481 | 2021-07-19 04:21:24 | Osaka, Japan | ||
526485 | 526485 | 2021-06-09 | Ukraine | Kiev Oblast | 126294 | 2708 | 121151 | 2435 | 50.053 | 30.7667 | 2021-06-10 04:23:17 | Kiev Oblast, Ukraine | ||
2589652 | 2589652 | 2021-06-05 | Venezuela | 240714 | 2708 | 221108 | 16898 | 6.4238 | -66.5897 | 2021-06-06 04:24:03 | Venezuela | |||
2549595 | 2549595 | 2021-04-15 | US | Florida | Palm Beach | 12099 | 137552 | 2708 | 0 | 26.64676272 | -80.46536002 | 2021-04-16 04:20:46 | Palm Beach, Florida, US | |
391853 | 391853 | 2021-04-04 | Ukraine | Lviv Oblast | 108882 | 2708 | 81004 | 25170 | 49.8397 | 24.0297 | 2021-04-05 04:20:35 | Lviv Oblast, Ukraine | ||
2058991 | 2058991 | 2021-03-15 | US | Texas | Hidalgo | 48215 | 88412 | 2708 | 0 | 26.39418217 | -98.18299696 | 2021-03-16 05:25:13 | Hidalgo, Texas, US | |
3539552 | 3539552 | 2021-02-12 | Mexico | Oaxaca | 37854 | 2708 | 0 | 35146 | 17.0732 | -96.7266 | 2021-02-13 05:22:12 | Oaxaca, Mexico | ||
2569926 | 2569926 | 2021-01-25 | US | New York | Suffolk | 36103 | 136593 | 2708 | 0 | 133885 | 40.88320119 | -72.8012172 | 2021-01-26 05:22:02 | Suffolk, New York, US |
908154 | 908154 | 2021-01-19 | Ireland | 176839 | 2708 | 23364 | 150767 | 53.1424 | -7.6921 | 2021-01-20 05:21:54 | Ireland | |||
927979 | 927979 | 2020-12-21 | Spain | C. Valenciana | 129463 | 2708 | 9970 | 116785 | 39.484 | -0.7533 | 2020-12-22 05:22:33 | C. Valenciana, Spain | ||
122854 | 122854 | 2020-11-18 | Peru | Ancash | 27833 | 2708 | 0 | 25125 | -9.407125 | -77.67179499999997 | 2020-11-19 05:25:23 | Ancash, Peru | ||
2915347 | 2915347 | 2020-11-14 | Peru | Loreto | 23293 | 2708 | 0 | 20585 | -4.124847 | -74.424115 | 2020-11-15 05:26:53 | Loreto, Peru | ||
789471 | 789471 | 2020-10-15 | US | Texas | Harris | 48201 | 192100 | 2708 | 0 | 150269 | 29.85864939 | -95.39339521 | 2020-10-16 04:24:01 | Harris, Texas, US |
2848803 | 2848803 | 2020-09-18 | India | Punjab | 92833 | 2708 | 68463 | 21662 | 30.841465 | 75.40879 | 2020-09-19 04:22:00 | Punjab, India | ||
121929 | 121929 | 2020-07-19 | Brazil | Maranhao | 106325 | 2708 | 90360 | 13257 | -4.9609 | -45.2744 | 2020-07-20 05:34:40 | Maranhao, Brazil | ||
2040136 | 2040136 | 2020-06-27 | Egypt | 63923 | 2708 | 17140 | 44075 | 26.820553000000004 | 30.802497999999996 | 2020-06-28 04:34:04 | Egypt | |||
2039433 | 2039433 | 2020-06-27 | US | Michigan | Wayne | 26163 | 22579 | 2708 | 0 | 19871 | 42.28098405 | -83.281255 | 2020-06-28 04:34:04 | Wayne, Michigan, 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]);