johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where deaths = 2780 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1018129 | 1018129 | 2022-12-24 | Chile | OHiggins | 213925 | 2780 | 0 | -34.5755 | -71.0022 | 2022-12-25 04:21:04 | OHiggins, Chile | |||
3523664 | 3523664 | 2022-11-24 | Russia | Kemerovo Oblast | 210652 | 2780 | 0 | 54.5335781 | 87.342861 | 2022-11-25 04:21:06 | Kemerovo Oblast, Russia | |||
2759158 | 2759158 | 2022-10-18 | US | New York | Erie | 36029 | 254867 | 2780 | 0 | 42.76249024 | -78.73063652 | 2022-10-19 04:22:26 | Erie, New York, US | |
1624404 | 1624404 | 2022-09-22 | Montenegro | 278992 | 2780 | 0 | 42.708678 | 19.37439 | 2022-09-23 04:23:13 | Montenegro | ||||
1372670 | 1372670 | 2022-09-21 | US | New Jersey | Hudson | 34017 | 213299 | 2780 | 0 | 40.73766234 | -74.07515667 | 2022-09-22 04:22:56 | Hudson, New Jersey, US | |
1370608 | 1370608 | 2022-09-21 | Montenegro | 278848 | 2780 | 0 | 42.708678 | 19.37439 | 2022-09-22 04:22:56 | Montenegro | ||||
2016838 | 2016838 | 2022-09-20 | Montenegro | 278690 | 2780 | 0 | 42.708678 | 19.37439 | 2022-09-21 04:23:22 | Montenegro | ||||
3570711 | 3570711 | 2022-09-19 | Montenegro | 278509 | 2780 | 0 | 42.708678 | 19.37439 | 2022-09-20 04:22:48 | Montenegro | ||||
3002753 | 3002753 | 2022-05-24 | US | Washington | King | 53033 | 422477 | 2780 | 0 | 47.49137892 | -121.8346131 | 2022-05-25 04:20:56 | King, Washington, US | |
3596474 | 3596474 | 2022-05-23 | US | Washington | King | 53033 | 422477 | 2780 | 0 | 47.49137892 | -121.8346131 | 2022-05-24 04:20:57 | King, Washington, US | |
3445110 | 3445110 | 2022-05-11 | Russia | Yaroslavl Oblast | 160288 | 2780 | 0 | 57.7781976 | 39.0021095 | 2022-05-12 04:20:54 | Yaroslavl Oblast, Russia | |||
1223723 | 1223723 | 2022-04-14 | Netherlands | Gelderland | 977904 | 2780 | 0 | 52.061738 | 5.939114 | 2022-04-15 04:20:57 | Gelderland, Netherlands | |||
2442881 | 2442881 | 2022-04-13 | Netherlands | Gelderland | 977318 | 2780 | 0 | 52.061738 | 5.939114 | 2022-04-13 23:21:06 | Gelderland, Netherlands | |||
25069 | 25069 | 2022-03-20 | US | Connecticut | New Haven | 9009 | 193688 | 2780 | 0 | 41.408032500000004 | -72.93620426 | 2022-03-21 04:20:50 | New Haven, Connecticut, US | |
1657079 | 1657079 | 2022-03-19 | US | Connecticut | New Haven | 9009 | 193688 | 2780 | 0 | 41.408032500000004 | -72.93620426 | 2022-03-20 04:20:45 | New Haven, Connecticut, US | |
336605 | 336605 | 2022-03-18 | US | Connecticut | New Haven | 9009 | 193688 | 2780 | 0 | 41.408032500000004 | -72.93620426 | 2022-03-19 04:20:47 | New Haven, Connecticut, US | |
2525615 | 2525615 | 2022-03-02 | Russia | Smolensk Oblast | 118406 | 2780 | 0 | 55.03434960000001 | 33.0192065 | 2022-03-03 04:21:01 | Smolensk Oblast, Russia | |||
3913133 | 3913133 | 2022-02-20 | US | Indiana | Marion | 18097 | 222497 | 2780 | 0 | 39.78163624 | -86.13826325 | 2022-02-21 04:21:05 | Marion, Indiana, US | |
3876691 | 3876691 | 2022-02-19 | US | Indiana | Marion | 18097 | 222497 | 2780 | 0 | 39.78163624 | -86.13826325 | 2022-02-20 04:21:00 | Marion, Indiana, US | |
3875768 | 3875768 | 2022-02-19 | Russia | Astrakhan Oblast | 103945 | 2780 | 0 | 47.1878186 | 47.608851 | 2022-02-20 04:21:00 | Astrakhan Oblast, Russia | |||
3856947 | 3856947 | 2022-02-18 | US | Indiana | Marion | 18097 | 222497 | 2780 | 0 | 39.78163624 | -86.13826325 | 2022-02-19 04:21:11 | Marion, Indiana, US | |
2330996 | 2330996 | 2022-02-04 | Ukraine | Kherson Oblast | 88642 | 2780 | 0 | 46.6354 | 32.6169 | 2022-02-05 04:21:05 | Kherson Oblast, Ukraine | |||
2661415 | 2661415 | 2022-01-31 | Ukraine | Cherkasy Oblast | 138257 | 2780 | 0 | 49.4444 | 32.0598 | 2022-02-01 04:21:11 | Cherkasy Oblast, Ukraine | |||
1961287 | 1961287 | 2022-01-20 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-21 04:21:09 | Pinellas, Florida, US | |
3227182 | 3227182 | 2022-01-19 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-20 04:21:07 | Pinellas, Florida, US | |
3464907 | 3464907 | 2022-01-18 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-19 04:21:23 | Pinellas, Florida, US | |
1472846 | 1472846 | 2022-01-17 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-18 04:21:04 | Pinellas, Florida, US | |
555520 | 555520 | 2022-01-16 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-17 04:21:08 | Pinellas, Florida, US | |
3841241 | 3841241 | 2022-01-15 | US | Florida | Pinellas | 12103 | 173389 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-16 04:21:12 | Pinellas, Florida, US | |
100056 | 100056 | 2022-01-14 | US | Florida | Pinellas | 12103 | 159079 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-15 04:21:07 | Pinellas, Florida, US | |
3688211 | 3688211 | 2022-01-13 | US | Florida | Pinellas | 12103 | 159079 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-14 04:21:54 | Pinellas, Florida, US | |
3613795 | 3613795 | 2022-01-12 | US | Florida | Pinellas | 12103 | 159079 | 2780 | 0 | 27.93130349 | -82.72239666 | 2022-01-13 08:00:09 | Pinellas, Florida, US | |
1391629 | 1391629 | 2022-01-07 | US | Missouri | St. Louis | 29189 | 173630 | 2780 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-08 04:21:53 | St. Louis, Missouri, US | |
2612016 | 2612016 | 2022-01-06 | US | Missouri | St. Louis | 29189 | 170590 | 2780 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-07 04:22:09 | St. Louis, Missouri, US | |
2610347 | 2610347 | 2022-01-06 | Spain | Galicia | 279998 | 2780 | 0 | 42.5751 | -8.1339 | 2022-01-07 04:22:09 | Galicia, Spain | |||
1282289 | 1282289 | 2022-01-05 | Spain | Galicia | 279998 | 2780 | 0 | 42.5751 | -8.1339 | 2022-01-06 04:22:09 | Galicia, Spain | |||
1716618 | 1716618 | 2021-12-16 | Russia | Vologda Oblast | 95857 | 2780 | 0 | 60.0391461 | 43.1215213 | 2021-12-17 04:22:14 | Vologda Oblast, Russia | |||
2876284 | 2876284 | 2021-10-09 | Mexico | Aguascalientes | 34422 | 2780 | 0 | 21.8853 | -102.2916 | 2021-10-10 04:21:38 | Aguascalientes, Mexico | |||
2959450 | 2959450 | 2021-10-08 | Mexico | Aguascalientes | 34422 | 2780 | 0 | 21.8853 | -102.2916 | 2021-10-09 04:21:34 | Aguascalientes, Mexico | |||
642192 | 642192 | 2021-09-07 | Russia | Tula Oblast | 52113 | 2780 | 0 | 53.9570701 | 37.369090899999996 | 2021-09-08 04:21:31 | Tula Oblast, Russia | |||
2923225 | 2923225 | 2021-08-27 | Japan | Osaka | 159740 | 2780 | 0 | 34.620965000000005 | 135.507481 | 2021-08-28 04:21:28 | Osaka, Japan | |||
2903317 | 2903317 | 2021-08-12 | Ukraine | Kiev Oblast | 128538 | 2780 | 0 | 50.053000000000004 | 30.7667 | 2021-08-13 04:21:24 | Kiev Oblast, Ukraine | |||
3705978 | 3705978 | 2021-07-17 | Colombia | Narino | 83947 | 2780 | 78482 | 2685 | 1.2892 | -77.3579 | 2021-07-18 04:22:07 | Narino, Colombia | ||
1412766 | 1412766 | 2021-05-24 | Belarus | 386978 | 2780 | 377105 | 7093 | 53.7098 | 27.9534 | 2021-05-25 04:21:08 | Belarus | |||
1857914 | 1857914 | 2021-02-25 | Germany | Berlin | 127930 | 2780 | 120315 | 5326 | 52.52 | 13.405 | 2021-02-26 05:22:40 | Berlin, Germany | ||
3539423 | 3539423 | 2021-02-12 | India | Rajasthan | 318710 | 2780 | 314523 | 1407 | 26.583423 | 73.847973 | 2021-02-13 05:22:12 | Rajasthan, India | ||
790113 | 790113 | 2021-02-04 | Brazil | Alagoas | 119458 | 2780 | 114348 | 2330 | -9.5713 | -36.782 | 2021-02-05 05:22:38 | Alagoas, Brazil | ||
2426762 | 2426762 | 2021-01-23 | Colombia | Santander | 80412 | 2780 | 72816 | 4816 | 6.6437 | -73.6536 | 2021-01-24 05:22:35 | Santander, Colombia | ||
1094252 | 1094252 | 2021-01-20 | Peru | Loreto | 26755 | 2780 | 0 | 23975 | -4.124847 | -74.424115 | 2021-01-21 05:22:01 | Loreto, Peru | ||
821715 | 821715 | 2020-11-19 | Pakistan | Sindh | 159752 | 2780 | 144316 | 12656 | 26.009446 | 68.77680699999999 | 2020-11-20 05:26:28 | Sindh, Pakistan | ||
272088 | 272088 | 2020-11-10 | Honduras | 100804 | 2780 | 43507 | 54517 | 15.2 | -86.2419 | 2020-11-11 05:25:30 | Honduras | |||
3204906 | 3204906 | 2020-07-18 | US | Michigan | Wayne | 26163 | 25051 | 2780 | 0 | 22271 | 42.28098405 | -83.281255 | 2020-07-19 04:34:58 | Wayne, Michigan, US |
2700566 | 2700566 | 2020-06-24 | Spain | Castilla y Leon | 19563 | 2780 | 8716 | 8067 | 41.8357 | -4.3976 | 2020-06-25 05:26:54 | Castilla y Leon, Spain |
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]);