johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "Russia", deaths = 30 and province_or_state = "Karachay-Cherkess Republic" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
754505 | 754505 | 2020-10-28 | Russia | Karachay-Cherkess Republic | 9349 | 30 | 5433 | 3886 | 43.7368326 | 41.7267991 | 2020-10-29 04:24:49 | Karachay-Cherkess Republic, Russia | ||
1452789 | 1452789 | 2020-10-27 | Russia | Karachay-Cherkess Republic | 9259 | 30 | 5378 | 3851 | 43.7368326 | 41.7267991 | 2020-10-28 04:24:39 | Karachay-Cherkess Republic, Russia | ||
3480513 | 3480513 | 2020-10-26 | Russia | Karachay-Cherkess Republic | 9173 | 30 | 5331 | 3812 | 43.7368326 | 41.7267991 | 2020-10-27 04:24:45 | Karachay-Cherkess Republic, Russia | ||
8534 | 8534 | 2020-10-25 | Russia | Karachay-Cherkess Republic | 9084 | 30 | 5307 | 3747 | 43.7368326 | 41.7267991 | 2020-10-26 04:25:02 | Karachay-Cherkess Republic, Russia | ||
3651771 | 3651771 | 2020-10-24 | Russia | Karachay-Cherkess Republic | 8997 | 30 | 5290 | 3677 | 43.7368326 | 41.7267991 | 2020-10-25 04:24:36 | Karachay-Cherkess Republic, Russia | ||
1054026 | 1054026 | 2020-10-23 | Russia | Karachay-Cherkess Republic | 8909 | 30 | 5249 | 3630 | 43.7368326 | 41.7267991 | 2020-10-24 04:24:46 | Karachay-Cherkess Republic, Russia | ||
1177696 | 1177696 | 2020-10-22 | Russia | Karachay-Cherkess Republic | 8823 | 30 | 5215 | 3578 | 43.7368326 | 41.7267991 | 2020-10-23 04:24:46 | Karachay-Cherkess Republic, Russia | ||
2191801 | 2191801 | 2020-10-21 | Russia | Karachay-Cherkess Republic | 8740 | 30 | 5186 | 3524 | 43.7368326 | 41.7267991 | 2020-10-22 04:24:27 | Karachay-Cherkess Republic, Russia | ||
3990812 | 3990812 | 2020-10-20 | Russia | Karachay-Cherkess Republic | 8658 | 30 | 5161 | 3467 | 43.7368326 | 41.7267991 | 2020-10-21 04:24:14 | Karachay-Cherkess Republic, Russia | ||
1794832 | 1794832 | 2020-10-19 | Russia | Karachay-Cherkess Republic | 8574 | 30 | 5138 | 3406 | 43.7368326 | 41.7267991 | 2020-10-20 04:24:22 | Karachay-Cherkess Republic, Russia | ||
762516 | 762516 | 2020-10-18 | Russia | Karachay-Cherkess Republic | 8489 | 30 | 5121 | 3338 | 43.7368326 | 41.7267991 | 2020-10-19 04:24:16 | Karachay-Cherkess Republic, Russia | ||
1026554 | 1026554 | 2020-10-17 | Russia | Karachay-Cherkess Republic | 8406 | 30 | 5112 | 3264 | 43.7368326 | 41.7267991 | 2020-10-18 04:24:25 | Karachay-Cherkess Republic, Russia | ||
2857049 | 2857049 | 2020-10-16 | Russia | Karachay-Cherkess Republic | 8325 | 30 | 5088 | 3207 | 43.7368326 | 41.7267991 | 2020-10-17 04:24:12 | Karachay-Cherkess Republic, Russia | ||
786579 | 786579 | 2020-10-15 | Russia | Karachay-Cherkess Republic | 8246 | 30 | 5066 | 3150 | 43.7368326 | 41.7267991 | 2020-10-16 04:24:01 | Karachay-Cherkess Republic, Russia | ||
79290 | 79290 | 2020-10-14 | Russia | Karachay-Cherkess Republic | 8166 | 30 | 5046 | 3090 | 43.7368326 | 41.7267991 | 2020-10-15 04:24:28 | Karachay-Cherkess Republic, Russia | ||
3782105 | 3782105 | 2020-10-13 | Russia | Karachay-Cherkess Republic | 8084 | 30 | 5027 | 3027 | 43.7368326 | 41.7267991 | 2020-10-14 04:24:05 | Karachay-Cherkess Republic, Russia | ||
2291645 | 2291645 | 2020-10-12 | Russia | Karachay-Cherkess Republic | 8003 | 30 | 5006 | 2967 | 43.7368326 | 41.7267991 | 2020-10-13 04:24:02 | Karachay-Cherkess Republic, Russia | ||
3786098 | 3786098 | 2020-10-11 | Russia | Karachay-Cherkess Republic | 7921 | 30 | 4998 | 2893 | 43.7368326 | 41.7267991 | 2020-10-12 04:23:45 | Karachay-Cherkess Republic, Russia |
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]);