johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 6878 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3038618 | 3038618 | 2022-10-27 | Slovenia | 1230970 | 6878 | 0 | 46.1512 | 14.9955 | 2022-10-28 04:22:31 | Slovenia | ||||
2712645 | 2712645 | 2022-09-03 | Algeria | 270426 | 6878 | 0 | 28.0339 | 1.6596 | 2022-09-04 04:21:22 | Algeria | ||||
1393350 | 1393350 | 2022-09-02 | Algeria | 270405 | 6878 | 0 | 28.0339 | 1.6596 | 2022-09-03 04:21:04 | Algeria | ||||
3547179 | 3547179 | 2022-09-01 | Algeria | 270359 | 6878 | 0 | 28.0339 | 1.6596 | 2022-09-02 04:21:07 | Algeria | ||||
2343099 | 2343099 | 2022-08-31 | Algeria | 270304 | 6878 | 0 | 28.0339 | 1.6596 | 2022-09-01 04:21:03 | Algeria | ||||
3773579 | 3773579 | 2022-08-30 | Algeria | 270272 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-31 04:20:57 | Algeria | ||||
1680175 | 1680175 | 2022-08-29 | Algeria | 270235 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-30 04:21:03 | Algeria | ||||
1876659 | 1876659 | 2022-08-28 | Algeria | 270194 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-29 04:21:06 | Algeria | ||||
2095786 | 2095786 | 2022-08-27 | Algeria | 270175 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-28 04:21:02 | Algeria | ||||
1531601 | 1531601 | 2022-08-26 | Algeria | 270145 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-27 04:20:57 | Algeria | ||||
2828488 | 2828488 | 2022-08-25 | Algeria | 270097 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-26 04:21:02 | Algeria | ||||
2323021 | 2323021 | 2022-08-24 | Algeria | 270043 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-25 04:21:13 | Algeria | ||||
1250430 | 1250430 | 2022-08-23 | Algeria | 269971 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-24 04:20:46 | Algeria | ||||
2852534 | 2852534 | 2022-08-22 | Algeria | 269894 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-23 04:20:56 | Algeria | ||||
2402506 | 2402506 | 2022-08-21 | Algeria | 269805 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-22 04:20:38 | Algeria | ||||
3797584 | 3797584 | 2022-08-20 | Algeria | 269731 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-21 04:20:44 | Algeria | ||||
2363170 | 2363170 | 2022-08-19 | Algeria | 269650 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-20 04:21:01 | Algeria | ||||
1160841 | 1160841 | 2022-08-18 | Algeria | 269556 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-19 04:20:54 | Algeria | ||||
3950165 | 3950165 | 2022-08-17 | Algeria | 269473 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-18 04:21:11 | Algeria | ||||
990667 | 990667 | 2022-08-16 | Algeria | 269381 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-17 04:20:59 | Algeria | ||||
2493706 | 2493706 | 2022-08-15 | Algeria | 269269 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-16 04:20:58 | Algeria | ||||
3647256 | 3647256 | 2022-08-14 | Algeria | 269141 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-15 04:20:59 | Algeria | ||||
1968262 | 1968262 | 2022-08-13 | Algeria | 269008 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-14 04:20:55 | Algeria | ||||
2888071 | 2888071 | 2022-08-12 | Algeria | 268866 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-13 04:20:52 | Algeria | ||||
3907676 | 3907676 | 2022-08-11 | Algeria | 268718 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-12 04:20:54 | Algeria | ||||
1345993 | 1345993 | 2022-08-10 | Algeria | 268584 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-11 04:20:49 | Algeria | ||||
1085748 | 1085748 | 2022-08-09 | Algeria | 268478 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-10 04:20:57 | Algeria | ||||
3543163 | 3543163 | 2022-08-08 | Algeria | 268356 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-09 04:20:34 | Algeria | ||||
1069566 | 1069566 | 2022-08-07 | Algeria | 268254 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-08 04:21:08 | Algeria | ||||
1940154 | 1940154 | 2022-08-06 | Algeria | 268141 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-07 04:20:54 | Algeria | ||||
879953 | 879953 | 2022-08-05 | Algeria | 268033 | 6878 | 0 | 28.0339 | 1.6596 | 2022-08-06 04:20:56 | Algeria | ||||
3871670 | 3871670 | 2022-07-31 | Mexico | Yucatan | 133397 | 6878 | 0 | 20.7099 | -89.0943 | 2022-08-01 04:21:03 | Yucatan, Mexico | |||
674424 | 674424 | 2022-07-30 | Mexico | Yucatan | 133397 | 6878 | 0 | 20.7099 | -89.0943 | 2022-07-31 04:21:02 | Yucatan, Mexico | |||
1783623 | 1783623 | 2022-07-29 | Mexico | Yucatan | 133397 | 6878 | 0 | 20.7099 | -89.0943 | 2022-07-30 04:20:42 | Yucatan, Mexico | |||
1850255 | 1850255 | 2022-05-26 | Russia | Volgograd Oblast | 220797 | 6878 | 0 | 49.6048339 | 44.2903582 | 2022-05-27 04:20:56 | Volgograd Oblast, Russia | |||
3613251 | 3613251 | 2022-01-12 | Russia | Altai Krai | 123178 | 6878 | 0 | 52.693224300000004 | 82.69314240000001 | 2022-01-13 08:00:09 | Altai Krai, Russia | |||
3998915 | 3998915 | 2021-12-30 | Russia | Voronezh Oblast | 193855 | 6878 | 0 | 50.9800393 | 40.15065070000001 | 2021-12-31 04:21:50 | Voronezh Oblast, Russia | |||
3070005 | 3070005 | 2021-11-23 | Italy | Puglia | 277715 | 6878 | 0 | 41.12559576 | 16.86736689 | 2021-11-24 04:22:14 | Puglia, Italy | |||
2923280 | 2923280 | 2021-08-27 | Mexico | Hidalgo | 53757 | 6878 | 0 | 20.0911 | -98.7624 | 2021-08-28 04:21:28 | Hidalgo, Mexico | |||
296112 | 296112 | 2021-07-15 | Mexico | Sonora | 82882 | 6878 | 0 | 76004 | 29.2972 | -110.3309 | 2021-07-16 04:21:22 | Sonora, Mexico | ||
2716943 | 2716943 | 2021-06-10 | India | Uttarakhand | 335866 | 6878 | 322347 | 6641 | 30.156447 | 79.197608 | 2021-06-11 04:23:20 | Uttarakhand, India | ||
2824698 | 2824698 | 2021-05-01 | Germany | Hessen | 263771 | 6878 | 232000 | 26083 | 50.6521 | 9.1624 | 2021-05-02 04:20:48 | Hessen, Germany | ||
1409314 | 1409314 | 2021-04-23 | Saudi Arabia | 410191 | 6878 | 393671 | 9642 | 23.885942 | 45.079162 | 2021-04-24 04:20:38 | Saudi Arabia | |||
3836260 | 3836260 | 2020-11-21 | Canada | Quebec | 131937 | 6878 | 112734 | 12325 | 52.9399 | -73.5491 | 2020-11-22 05:25:45 | Quebec, Canada |
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]);