johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where deaths = 2753 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
833615 | 833615 | 2022-12-02 | Japan | Chiba | 1094863 | 2753 | 0 | 35.510141 | 140.198917 | 2022-12-03 04:21:02 | Chiba, Japan | |||
2432661 | 2432661 | 2022-11-09 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-10 04:21:16 | Hennepin, Minnesota, US | |
481317 | 481317 | 2022-11-08 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-09 04:21:22 | Hennepin, Minnesota, US | |
2440467 | 2440467 | 2022-11-07 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-08 04:21:21 | Hennepin, Minnesota, US | |
1051565 | 1051565 | 2022-11-06 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-07 04:21:26 | Hennepin, Minnesota, US | |
619589 | 619589 | 2022-11-05 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-06 04:21:24 | Hennepin, Minnesota, US | |
1024093 | 1024093 | 2022-11-04 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-05 04:21:52 | Hennepin, Minnesota, US | |
433084 | 433084 | 2022-11-03 | US | Minnesota | Hennepin | 27053 | 366098 | 2753 | 0 | 45.00761521 | -93.47694895 | 2022-11-04 04:22:11 | Hennepin, Minnesota, US | |
3038099 | 3038099 | 2022-10-27 | Chile | Araucania | 273148 | 2753 | 0 | -38.9489 | -72.3311 | 2022-10-28 04:22:31 | Araucania, Chile | |||
2771202 | 2771202 | 2022-09-26 | US | New York | Erie | 36029 | 251136 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-27 04:23:01 | Erie, New York, US | |
1978855 | 1978855 | 2022-09-25 | US | New York | Erie | 36029 | 251136 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-26 04:20:52 | Erie, New York, US | |
2652022 | 2652022 | 2022-09-24 | US | New York | Erie | 36029 | 250945 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-25 04:23:31 | Erie, New York, US | |
386462 | 386462 | 2022-09-23 | US | New York | Erie | 36029 | 250790 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-24 04:21:40 | Erie, New York, US | |
1626528 | 1626528 | 2022-09-22 | US | New York | Erie | 36029 | 250581 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-23 04:23:13 | Erie, New York, US | |
1372732 | 1372732 | 2022-09-21 | US | New York | Erie | 36029 | 250336 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-22 04:22:56 | Erie, New York, US | |
2018962 | 2018962 | 2022-09-20 | US | New York | Erie | 36029 | 250106 | 2753 | 0 | 42.76249024 | -78.73063652 | 2022-09-21 04:23:22 | Erie, New York, US | |
882454 | 882454 | 2022-08-05 | US | New Jersey | Hudson | 34017 | 204963 | 2753 | 0 | 40.73766234 | -74.07515667 | 2022-08-06 04:20:56 | Hudson, New Jersey, US | |
880395 | 880395 | 2022-08-05 | Montenegro | 263658 | 2753 | 0 | 42.708678 | 19.37439 | 2022-08-06 04:20:56 | Montenegro | ||||
2010865 | 2010865 | 2022-08-04 | US | New Jersey | Hudson | 34017 | 204963 | 2753 | 0 | 40.73766234 | -74.07515667 | 2022-08-05 04:20:52 | Hudson, New Jersey, US | |
2008806 | 2008806 | 2022-08-04 | Montenegro | 262808 | 2753 | 0 | 42.708678 | 19.37439 | 2022-08-05 04:20:52 | Montenegro | ||||
1100292 | 1100292 | 2022-08-03 | US | New Jersey | Hudson | 34017 | 204661 | 2753 | 0 | 40.73766234 | -74.07515667 | 2022-08-04 04:20:58 | Hudson, New Jersey, US | |
1407217 | 1407217 | 2022-08-02 | US | New Jersey | Hudson | 34017 | 204385 | 2753 | 0 | 40.73766234 | -74.07515667 | 2022-08-03 04:20:59 | Hudson, New Jersey, US | |
3109743 | 3109743 | 2022-07-13 | Russia | Tver Oblast | 163458 | 2753 | 0 | 57.1134475 | 35.1744428 | 2022-07-14 04:20:57 | Tver Oblast, Russia | |||
3109197 | 3109197 | 2022-07-13 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-14 04:20:57 | Botswana | ||||
630166 | 630166 | 2022-07-12 | Russia | Tver Oblast | 163440 | 2753 | 0 | 57.1134475 | 35.1744428 | 2022-07-13 04:20:58 | Tver Oblast, Russia | |||
629620 | 629620 | 2022-07-12 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-13 04:20:58 | Botswana | ||||
1213835 | 1213835 | 2022-07-11 | US | New York | Westchester | 36119 | 285949 | 2753 | 0 | 41.16278376 | -73.75741653 | 2022-07-12 04:20:51 | Westchester, New York, US | |
1211810 | 1211810 | 2022-07-11 | Russia | Tver Oblast | 163424 | 2753 | 0 | 57.1134475 | 35.1744428 | 2022-07-12 04:20:51 | Tver Oblast, Russia | |||
1211264 | 1211264 | 2022-07-11 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-12 04:20:51 | Botswana | ||||
2788746 | 2788746 | 2022-07-10 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-11 04:20:46 | Botswana | ||||
141699 | 141699 | 2022-07-09 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-10 04:20:54 | Botswana | ||||
1416799 | 1416799 | 2022-07-08 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-09 04:20:59 | Botswana | ||||
2740724 | 2740724 | 2022-07-07 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-08 04:20:56 | Botswana | ||||
3046427 | 3046427 | 2022-02-26 | Russia | Smolensk Oblast | 115201 | 2753 | 0 | 55.03434960000001 | 33.0192065 | 2022-02-27 04:21:04 | Smolensk Oblast, Russia | |||
1511230 | 1511230 | 2022-02-24 | Colombia | Boyaca | 124360 | 2753 | 0 | 5.4545 | -73.362 | 2022-02-25 04:21:11 | Boyaca, Colombia | |||
2052099 | 2052099 | 2022-01-25 | Russia | Komi Republic | 100781 | 2753 | 0 | 63.9881421 | 54.3326073 | 2022-01-26 04:21:07 | Komi Republic, Russia | |||
1227830 | 1227830 | 2022-01-24 | Russia | Komi Republic | 100507 | 2753 | 0 | 63.9881421 | 54.3326073 | 2022-01-25 04:21:05 | Komi Republic, Russia | |||
3616058 | 3616058 | 2022-01-12 | US | Tennessee | Shelby | 47157 | 200597 | 2753 | 0 | 35.1864775 | -89.89692423 | 2022-01-13 08:00:09 | Shelby, Tennessee, US | |
1740309 | 1740309 | 2021-12-05 | Chile | Biobio | 162560 | 2753 | 0 | -37.4464 | -72.1416 | 2021-12-06 04:22:34 | Biobio, Chile | |||
714327 | 714327 | 2021-11-12 | Denmark | 417151 | 2753 | 0 | 56.2639 | 9.5018 | 2021-11-13 04:21:38 | Denmark | ||||
30075 | 30075 | 2021-11-11 | US | Michigan | Macomb | 26099 | 126650 | 2753 | 0 | 42.69158356 | -82.92752801 | 2021-11-12 04:22:01 | Macomb, Michigan, US | |
2846514 | 2846514 | 2021-11-10 | US | Michigan | Macomb | 26099 | 126650 | 2753 | 0 | 42.69158356 | -82.92752801 | 2021-11-11 04:21:45 | Macomb, Michigan, US | |
4474 | 4474 | 2021-10-28 | Netherlands | Noord-Holland | 359313 | 2753 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-29 04:22:03 | Noord-Holland, Netherlands | |||
534864 | 534864 | 2021-10-27 | Netherlands | Noord-Holland | 358530 | 2753 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-28 04:22:08 | Noord-Holland, Netherlands | |||
634975 | 634975 | 2021-10-13 | US | Illinois | Unassigned | 90017 | 240 | 2753 | 0 | 42.36542373 | 0.0 | 2021-10-14 04:21:29 | Unassigned, Illinois, US | |
2959046 | 2959046 | 2021-10-08 | Albania | 174168 | 2753 | 0 | 41.1533 | 20.1683 | 2021-10-09 04:21:34 | Albania | ||||
3928280 | 3928280 | 2021-10-02 | Russia | Penza Oblast | 71096 | 2753 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-03 04:21:24 | Penza Oblast, Russia | |||
2132098 | 2132098 | 2021-10-01 | Mexico | Aguascalientes | 33851 | 2753 | 0 | 21.8853 | -102.2916 | 2021-10-02 04:21:25 | Aguascalientes, Mexico | |||
511730 | 511730 | 2021-08-19 | Japan | Osaka | 140003 | 2753 | 0 | 34.620965000000005 | 135.507481 | 2021-08-20 04:21:33 | Osaka, Japan | |||
3479387 | 3479387 | 2021-07-22 | US | Texas | El Paso | 48141 | 117159 | 2753 | 0 | 31.76980765 | -106.2363275 | 2021-07-23 04:21:29 | El Paso, Texas, US | |
2104301 | 2104301 | 2021-06-01 | Peru | San Martin | 44005 | 2753 | 0 | 41252 | -7.039531 | -76.729127 | 2021-06-02 04:24:34 | San Martin, Peru | ||
2251060 | 2251060 | 2021-04-07 | West Bank and Gaza | 259133 | 2753 | 226090 | 30290 | 31.9522 | 35.2332 | 2021-04-08 04:21:13 | West Bank and Gaza | |||
241502 | 241502 | 2021-04-02 | Russia | Sverdlovsk Oblast | 82782 | 2753 | 76143 | 3886 | 58.6414755 | 61.8021546 | 2021-04-03 04:20:44 | Sverdlovsk Oblast, Russia | ||
3369183 | 3369183 | 2021-03-21 | Colombia | Norte de Santander | 51568 | 2753 | 48166 | 649 | 7.9463 | -72.8988 | 2021-03-22 05:25:43 | Norte de Santander, Colombia | ||
3671246 | 3671246 | 2021-03-06 | Ukraine | Kiev | 141598 | 2753 | 96287 | 42558 | 50.4501 | 30.5234 | 2021-03-07 05:21:54 | Kiev, Ukraine | ||
3691702 | 3691702 | 2020-12-24 | Russia | Moscow Oblast | 144282 | 2753 | 102563 | 38966 | 55.50431579999999 | 38.0353929 | 2020-12-25 05:22:48 | Moscow Oblast, Russia | ||
1026307 | 1026307 | 2020-10-17 | India | Madhya Pradesh | 159158 | 2753 | 142707 | 13698 | 23.541513 | 78.289633 | 2020-10-18 04:24:25 | Madhya Pradesh, India | ||
2836916 | 2836916 | 2020-09-21 | Mexico | Tabasco | 30928 | 2753 | 27363 | 812 | 17.8409 | -92.6189 | 2020-09-22 04:23:00 | Tabasco, Mexico | ||
1173269 | 1173269 | 2020-09-10 | Mexico | Jalisco | 22589 | 2753 | 17875 | 1961 | 20.6595 | -103.3494 | 2020-09-11 04:46:23 | Jalisco, Mexico | ||
3932123 | 3932123 | 2020-08-30 | Mexico | Sinaloa | 16016 | 2753 | 12539 | 724 | 25.1721 | -107.4795 | 2020-08-31 04:28:27 | Sinaloa, Mexico | ||
1707603 | 1707603 | 2020-07-21 | Canada | Ontario | 38512 | 2753 | 35096 | 1824 | 51.2538 | -85.3232 | 2020-07-22 04:34:42 | Ontario, Canada | ||
3276396 | 3276396 | 2020-05-15 | India | 85784 | 2753 | 30258 | 52773 | 20.593684 | 78.96288 | 2020-05-16 02:32:19 | India |
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]);