daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
97 rows where deaths = 2787 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-12-29 | Chile | OHiggins | 214637 | 2787 | 0 | -34.5755 | -71.0022 | 2022-12-30 04:21:04 | OHiggins, Chile | |||
2022-11-28 | Russia | Kemerovo Oblast | 210920 | 2787 | 0 | 54.5335781 | 87.342861 | 2022-11-29 04:21:05 | Kemerovo Oblast, Russia | |||
2022-11-09 | Montenegro | 283192 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-10 04:21:16 | Montenegro | ||||
2022-11-08 | Montenegro | 283146 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-09 04:21:22 | Montenegro | ||||
2022-11-07 | Montenegro | 283117 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-08 04:21:21 | Montenegro | ||||
2022-11-06 | Montenegro | 283089 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-07 04:21:26 | Montenegro | ||||
2022-11-06 | Japan | Hokkaido | 876485 | 2787 | 0 | 43.385711 | 142.552318 | 2022-11-07 04:21:26 | Hokkaido, Japan | |||
2022-11-05 | Montenegro | 283055 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-06 04:21:24 | Montenegro | ||||
2022-11-04 | Montenegro | 283011 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-05 04:21:52 | Montenegro | ||||
2022-11-03 | Montenegro | 282973 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-04 04:22:11 | Montenegro | ||||
2022-11-02 | Montenegro | 282911 | 2787 | 0 | 42.708678 | 19.37439 | 2022-11-03 04:22:05 | Montenegro | ||||
2022-10-31 | US | New York | Erie | 36029 | 256860 | 2787 | 0 | 42.76249024 | -78.73063652 | 2022-11-01 04:22:36 | Erie, New York, US | |
2022-10-30 | US | New York | Erie | 36029 | 256797 | 2787 | 0 | 42.76249024 | -78.73063652 | 2022-10-31 04:21:36 | Erie, New York, US | |
2022-10-29 | US | New York | Erie | 36029 | 256676 | 2787 | 0 | 42.76249024 | -78.73063652 | 2022-10-30 04:22:14 | Erie, New York, US | |
2022-10-28 | US | New York | Erie | 36029 | 256505 | 2787 | 0 | 42.76249024 | -78.73063652 | 2022-10-29 04:21:13 | Erie, New York, US | |
2022-10-05 | US | New Jersey | Hudson | 34017 | 215428 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-06 04:21:22 | Hudson, New Jersey, US | |
2022-10-04 | US | New Jersey | Hudson | 34017 | 215273 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-05 04:23:06 | Hudson, New Jersey, US | |
2022-10-03 | US | New Jersey | Hudson | 34017 | 215152 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-04 04:22:55 | Hudson, New Jersey, US | |
2022-10-02 | US | New Jersey | Hudson | 34017 | 215133 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-03 04:23:11 | Hudson, New Jersey, US | |
2022-10-01 | US | New Jersey | Hudson | 34017 | 214988 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-02 04:21:23 | Hudson, New Jersey, US | |
2022-09-30 | US | New Jersey | Hudson | 34017 | 214787 | 2787 | 0 | 40.73766234 | -74.07515667 | 2022-10-01 04:23:01 | Hudson, New Jersey, US | |
2022-09-25 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-26 04:20:52 | Botswana | ||||
2022-09-24 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-25 04:23:31 | Botswana | ||||
2022-09-23 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-24 04:21:40 | Botswana | ||||
2022-09-22 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-23 04:23:13 | Botswana | ||||
2022-09-21 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-22 04:22:56 | Botswana | ||||
2022-09-20 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-21 04:23:22 | Botswana | ||||
2022-09-19 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-20 04:22:48 | Botswana | ||||
2022-09-18 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-19 04:21:49 | Botswana | ||||
2022-09-17 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-18 04:22:50 | Botswana | ||||
2022-09-16 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-17 04:20:19 | Botswana | ||||
2022-09-15 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-16 04:21:19 | Botswana | ||||
2022-09-14 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-15 04:21:02 | Botswana | ||||
2022-09-13 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-14 04:20:44 | Botswana | ||||
2022-08-18 | Germany | Schleswig-Holstein | 965880 | 2787 | 0 | 54.2194 | 9.6961 | 2022-08-19 04:20:54 | Schleswig-Holstein, Germany | |||
2022-08-15 | US | New York | Westchester | 36119 | 296937 | 2787 | 0 | 41.16278376 | -73.75741653 | 2022-08-16 04:20:58 | Westchester, New York, US | |
2022-08-14 | US | New York | Westchester | 36119 | 296760 | 2787 | 0 | 41.16278376 | -73.75741653 | 2022-08-15 04:20:59 | Westchester, New York, US | |
2022-08-13 | US | New York | Westchester | 36119 | 296571 | 2787 | 0 | 41.16278376 | -73.75741653 | 2022-08-14 04:20:55 | Westchester, New York, US | |
2022-08-12 | US | New York | Westchester | 36119 | 296357 | 2787 | 0 | 41.16278376 | -73.75741653 | 2022-08-13 04:20:52 | Westchester, New York, US | |
2022-06-29 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-30 04:21:01 | Boyaca, Colombia | |||
2022-06-28 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-29 04:20:59 | Boyaca, Colombia | |||
2022-06-27 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-28 04:20:58 | Boyaca, Colombia | |||
2022-06-26 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-27 04:21:00 | Boyaca, Colombia | |||
2022-06-25 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-26 04:21:02 | Boyaca, Colombia | |||
2022-06-24 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-25 04:20:57 | Boyaca, Colombia | |||
2022-06-23 | Colombia | Boyaca | 125656 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-24 04:20:58 | Boyaca, Colombia | |||
2022-06-22 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-23 04:20:55 | Boyaca, Colombia | |||
2022-06-21 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-22 04:20:54 | Boyaca, Colombia | |||
2022-06-20 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-21 04:20:56 | Boyaca, Colombia | |||
2022-06-19 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-20 04:21:01 | Boyaca, Colombia | |||
2022-06-18 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-19 04:20:51 | Boyaca, Colombia | |||
2022-06-17 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-18 04:21:10 | Boyaca, Colombia | |||
2022-06-16 | Colombia | Boyaca | 125500 | 2787 | 0 | 5.4545 | -73.362 | 2022-06-17 04:20:56 | Boyaca, Colombia | |||
2022-05-26 | US | Washington | King | 53033 | 424934 | 2787 | 0 | 47.49137892 | -121.8346131 | 2022-05-27 04:20:56 | King, Washington, US | |
2022-05-25 | US | Washington | King | 53033 | 424934 | 2787 | 0 | 47.49137892 | -121.8346131 | 2022-05-26 04:20:50 | King, Washington, US | |
2022-05-22 | US | Washington | King | 53033 | 424934 | 2787 | 0 | 47.49137892 | -121.8346131 | 2022-05-26 04:20:50 | King, Washington, US | |
2022-03-29 | Malaysia | W.P. Kuala Lumpur | 325103 | 2787 | 0 | 3.139 | 101.6869 | 2022-03-30 04:20:45 | W.P. Kuala Lumpur, Malaysia | |||
2022-03-28 | Malaysia | W.P. Kuala Lumpur | 323669 | 2787 | 0 | 3.139 | 101.6869 | 2022-03-29 04:20:46 | W.P. Kuala Lumpur, Malaysia | |||
2022-03-03 | Russia | Smolensk Oblast | 119240 | 2787 | 0 | 55.03434960000001 | 33.0192065 | 2022-03-04 04:21:09 | Smolensk Oblast, Russia | |||
2022-02-21 | Jamaica | 127665 | 2787 | 0 | 18.1096 | -77.2975 | 2022-02-22 04:21:01 | Jamaica | ||||
2022-02-07 | US | New Jersey | Ocean | 34029 | 157636 | 2787 | 0 | 39.8895449 | -74.28089251 | 2022-02-08 04:21:15 | Ocean, New Jersey, US | |
2022-01-10 | US | Pennsylvania | Allegheny | 42003 | 208603 | 2787 | 0 | 40.46809875 | -79.98167747 | 2022-01-11 04:22:01 | Allegheny, Pennsylvania, US | |
2022-01-03 | Malaysia | Sabah | 241122 | 2787 | 0 | 5.9788 | 116.0753 | 2022-01-04 04:22:17 | Sabah, Malaysia | |||
2021-11-27 | Russia | Omsk Oblast | 112818 | 2787 | 0 | 56.09352629999999 | 73.5099936 | 2021-11-28 04:22:43 | Omsk Oblast, Russia | |||
2021-11-05 | Russia | Dagestan Republic | 56823 | 2787 | 0 | 43.05749160000001 | 47.1332224 | 2021-11-06 04:21:51 | Dagestan Republic, Russia | |||
2021-10-08 | Latvia | 168248 | 2787 | 0 | 56.8796 | 24.6032 | 2021-10-09 04:21:34 | Latvia | ||||
2021-09-30 | Russia | Volgograd Oblast | 92067 | 2787 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-01 04:21:35 | Volgograd Oblast, Russia | |||
2021-09-02 | US | Texas | El Paso | 48141 | 121925 | 2787 | 0 | 31.76980765 | -106.23632749999999 | 2021-09-03 04:21:20 | El Paso, Texas, US | |
2021-08-25 | Ukraine | Kiev Oblast | 129071 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-26 04:21:28 | Kiev Oblast, Ukraine | |||
2021-08-24 | Ukraine | Kiev Oblast | 129051 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-25 04:21:41 | Kiev Oblast, Ukraine | |||
2021-08-23 | Ukraine | Kiev Oblast | 129033 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-24 04:21:19 | Kiev Oblast, Ukraine | |||
2021-08-22 | Ukraine | Kiev Oblast | 129030 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-23 04:21:27 | Kiev Oblast, Ukraine | |||
2021-08-21 | Ukraine | Kiev Oblast | 129001 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-22 04:21:29 | Kiev Oblast, Ukraine | |||
2021-08-20 | Ukraine | Kiev Oblast | 128933 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-21 04:21:38 | Kiev Oblast, Ukraine | |||
2021-08-19 | Ukraine | Kiev Oblast | 128862 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-20 04:21:33 | Kiev Oblast, Ukraine | |||
2021-08-18 | Ukraine | Kiev Oblast | 128804 | 2787 | 0 | 50.053000000000004 | 30.7667 | 2021-08-19 04:21:15 | Kiev Oblast, Ukraine | |||
2021-06-10 | Colombia | Magdalena | 73794 | 2787 | 69329 | 1678 | 10.4113 | -74.4057 | 2021-06-11 04:23:20 | Magdalena, Colombia | ||
2021-05-25 | Mexico | Zacatecas | 30680 | 2787 | 0 | 27893 | 22.7709 | -102.5832 | 2021-05-26 04:20:35 | Zacatecas, Mexico | ||
2021-04-03 | Mexico | Morelos | 30337 | 2787 | 0 | 27550 | 18.6813 | -99.1013 | 2021-04-04 04:20:49 | Morelos, Mexico | ||
2021-03-03 | India | Rajasthan | 320772 | 2787 | 316515 | 1470 | 26.583423 | 73.847973 | 2021-03-04 05:24:24 | Rajasthan, India | ||
2021-03-02 | India | Rajasthan | 320557 | 2787 | 316430 | 1340 | 26.583423 | 73.847973 | 2021-03-03 05:23:28 | Rajasthan, India | ||
2021-03-01 | India | Rajasthan | 320455 | 2787 | 316364 | 1304 | 26.583423 | 73.847973 | 2021-03-02 05:23:30 | Rajasthan, India | ||
2021-02-28 | India | Rajasthan | 320336 | 2787 | 316241 | 1308 | 26.583423 | 73.847973 | 2021-03-01 05:23:01 | Rajasthan, India | ||
2021-02-27 | India | Rajasthan | 320180 | 2787 | 316139 | 1254 | 26.583423 | 73.847973 | 2021-02-28 05:22:20 | Rajasthan, India | ||
2021-02-24 | Brazil | Rondonia | 145427 | 2787 | 126006 | 16634 | -11.5057 | -63.5806 | 2021-02-25 05:24:57 | Rondonia, Brazil | ||
2021-02-07 | Mexico | Yucatan | 30837 | 2787 | 0 | 28050 | 20.7099 | -89.0943 | 2021-02-08 05:22:39 | Yucatan, Mexico | ||
2020-12-14 | Mexico | San Luis Potosi | 37412 | 2787 | 0 | 34625 | 22.1565 | -100.9855 | 2020-12-15 05:26:38 | San Luis Potosi, Mexico | ||
2020-11-19 | Austria | 222669 | 2787 | 149541 | 77026 | 47.5162 | 14.5501 | 2020-11-20 05:26:28 | Austria | |||
2020-08-13 | Canada | Ontario | 40909 | 2787 | 38396 | 1083 | 51.2538 | -85.3232 | 2020-08-14 04:51:19 | Ontario, Canada | ||
2020-08-12 | Peru | Arequipa | 20892 | 2787 | 0 | 18105 | -15.843524 | -72.475539 | 2020-08-13 04:29:15 | Arequipa, Peru | ||
2020-08-12 | Canada | Ontario | 40806 | 2787 | 38296 | 1104 | 51.2538 | -85.3232 | 2020-08-13 04:29:15 | Ontario, Canada | ||
2020-07-06 | Spain | Castilla y Leon | 19770 | 2787 | 8716 | 8267 | 41.8357 | -4.3976 | 2020-07-07 04:34:00 | Castilla y Leon, Spain | ||
2020-07-05 | Spain | Castilla y Leon | 19753 | 2787 | 8716 | 8250 | 41.8357 | -4.3976 | 2020-07-06 04:33:57 | Castilla y Leon, Spain | ||
2020-07-04 | Spain | Castilla y Leon | 19753 | 2787 | 8716 | 8250 | 41.8357 | -4.3976 | 2020-07-05 04:33:46 | Castilla y Leon, Spain | ||
2020-07-03 | Spain | Castilla y Leon | 19753 | 2787 | 8716 | 8250 | 41.8357 | -4.3976 | 2020-07-04 04:33:51 | Castilla y Leon, Spain | ||
2020-07-02 | Spain | Castilla y Leon | 19750 | 2787 | 8716 | 8247 | 41.8357 | -4.3976 | 2020-07-03 04:33:54 | Castilla y Leon, Spain | ||
2020-07-01 | Spain | Castilla y Leon | 19730 | 2787 | 8716 | 8227 | 41.8357 | -4.3976 | 2020-07-02 04:33:46 | Castilla y Leon, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;