johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Russia" and province_or_state = "Astrakhan Oblast" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005301 | 1005301 | 2020-07-09 | Russia | Astrakhan Oblast | 3806 | 35 | 2515 | 1256 | 47.1878186 | 47.608851 | 2020-07-10 04:34:24 | Astrakhan Oblast, Russia | ||
2222517 | 2222517 | 2020-07-08 | Russia | Astrakhan Oblast | 3773 | 35 | 2471 | 1267 | 47.1878186 | 47.608851 | 2020-07-09 04:34:23 | Astrakhan Oblast, Russia | ||
887126 | 887126 | 2020-07-07 | Russia | Astrakhan Oblast | 3738 | 35 | 2414 | 1289 | 47.1878186 | 47.608851 | 2020-07-08 05:33:48 | Astrakhan Oblast, Russia | ||
2684686 | 2684686 | 2020-07-06 | Russia | Astrakhan Oblast | 3698 | 33 | 2404 | 1261 | 47.1878186 | 47.608851 | 2020-07-07 04:34:00 | Astrakhan Oblast, Russia | ||
415151 | 415151 | 2020-07-05 | Russia | Astrakhan Oblast | 3656 | 33 | 2399 | 1224 | 47.1878186 | 47.608851 | 2020-07-06 04:33:57 | Astrakhan Oblast, Russia | ||
529713 | 529713 | 2020-07-04 | Russia | Astrakhan Oblast | 3617 | 33 | 2395 | 1189 | 47.1878186 | 47.608851 | 2020-07-05 04:33:46 | Astrakhan Oblast, Russia | ||
2234374 | 2234374 | 2020-07-03 | Russia | Astrakhan Oblast | 3577 | 32 | 2378 | 1167 | 47.1878186 | 47.608851 | 2020-07-04 04:33:51 | Astrakhan Oblast, Russia | ||
3045168 | 3045168 | 2020-07-02 | Russia | Astrakhan Oblast | 3548 | 32 | 2363 | 1153 | 47.1878186 | 47.608851 | 2020-07-03 04:33:54 | Astrakhan Oblast, Russia | ||
302859 | 302859 | 2020-07-01 | Russia | Astrakhan Oblast | 3513 | 32 | 2352 | 1129 | 47.1878186 | 47.608851 | 2020-07-02 04:33:46 | Astrakhan Oblast, Russia | ||
2974237 | 2974237 | 2020-06-30 | Russia | Astrakhan Oblast | 3479 | 31 | 2340 | 1108 | 47.1878186 | 47.608851 | 2020-07-01 04:33:52 | Astrakhan Oblast, Russia | ||
2632714 | 2632714 | 2020-06-29 | Russia | Astrakhan Oblast | 3448 | 30 | 2322 | 1096 | 47.1878186 | 47.608851 | 2020-06-30 04:33:48 | Astrakhan Oblast, Russia | ||
2306277 | 2306277 | 2020-06-28 | Russia | Astrakhan Oblast | 3419 | 30 | 2310 | 1079 | 47.1878186 | 47.608851 | 2020-06-29 04:33:44 | Astrakhan Oblast, Russia | ||
2039612 | 2039612 | 2020-06-27 | Russia | Astrakhan Oblast | 3382 | 30 | 2298 | 1054 | 47.1878186 | 47.608851 | 2020-06-28 04:34:04 | Astrakhan Oblast, Russia | ||
1135893 | 1135893 | 2020-06-26 | Russia | Astrakhan Oblast | 3347 | 29 | 2272 | 1046 | 47.1878186 | 47.608851 | 2020-06-27 04:33:35 | Astrakhan Oblast, Russia | ||
2624880 | 2624880 | 2020-06-25 | Russia | Astrakhan Oblast | 3307 | 29 | 2220 | 1058 | 47.1878186 | 47.608851 | 2020-06-26 04:33:43 | Astrakhan Oblast, Russia | ||
2700520 | 2700520 | 2020-06-24 | Russia | Astrakhan Oblast | 3275 | 29 | 2203 | 1043 | 47.1878186 | 47.608851 | 2020-06-25 05:26:54 | Astrakhan Oblast, Russia | ||
1522205 | 1522205 | 2020-06-23 | Russia | Astrakhan Oblast | 3242 | 28 | 2157 | 1057 | 47.1878186 | 47.608851 | 2020-06-24 04:33:28 | Astrakhan Oblast, Russia | ||
1510399 | 1510399 | 2020-06-22 | Russia | Astrakhan Oblast | 3206 | 28 | 2093 | 1085 | 47.1878186 | 47.608851 | 2020-06-23 04:33:22 | Astrakhan Oblast, Russia | ||
3249138 | 3249138 | 2020-06-21 | Russia | Astrakhan Oblast | 3158 | 28 | 2076 | 1054 | 47.1878186 | 47.608851 | 2020-06-22 04:33:20 | Astrakhan Oblast, Russia | ||
2437731 | 2437731 | 2020-06-20 | Russia | Astrakhan Oblast | 3103 | 27 | 2053 | 1023 | 47.1878186 | 47.608851 | 2020-06-21 04:33:19 | Astrakhan Oblast, Russia | ||
1691309 | 1691309 | 2020-06-19 | Russia | Astrakhan Oblast | 3046 | 27 | 2000 | 1019 | 47.1878186 | 47.608851 | 2020-06-20 04:33:19 | Astrakhan Oblast, Russia | ||
3682458 | 3682458 | 2020-06-18 | Russia | Astrakhan Oblast | 2987 | 26 | 1978 | 983 | 47.1878186 | 47.608851 | 2020-06-19 04:33:17 | Astrakhan Oblast, Russia | ||
1195661 | 1195661 | 2020-06-17 | Russia | Astrakhan Oblast | 2927 | 25 | 1875 | 1027 | 47.1878186 | 47.608851 | 2020-06-18 04:33:18 | Astrakhan Oblast, Russia | ||
2386424 | 2386424 | 2020-06-16 | Russia | Astrakhan Oblast | 2862 | 25 | 1807 | 1030 | 47.1878186 | 47.608851 | 2020-06-17 04:33:21 | Astrakhan Oblast, Russia | ||
286987 | 286987 | 2020-06-15 | Russia | Astrakhan Oblast | 2794 | 24 | 1702 | 1068 | 47.1878186 | 47.608851 | 2020-06-16 04:33:09 | Astrakhan Oblast, Russia | ||
1836938 | 1836938 | 2020-06-14 | Russia | Astrakhan Oblast | 2733 | 24 | 1678 | 1031 | 47.1878186 | 47.608851 | 2020-06-15 03:33:14 | Astrakhan Oblast, Russia | ||
3060990 | 3060990 | 2020-06-13 | Russia | Astrakhan Oblast | 2674 | 24 | 1639 | 1011 | 47.1878186 | 47.608851 | 2020-06-14 03:33:15 | Astrakhan Oblast, Russia | ||
737310 | 737310 | 2020-06-12 | Russia | Astrakhan Oblast | 2630 | 24 | 1560 | 1046 | 47.1878186 | 47.608851 | 2020-06-13 03:33:14 | Astrakhan Oblast, Russia | ||
1273280 | 1273280 | 2020-06-11 | Russia | Astrakhan Oblast | 2586 | 23 | 1535 | 1028 | 47.1878186 | 47.608851 | 2020-06-12 05:09:52 | Astrakhan Oblast, Russia | ||
2863724 | 2863724 | 2020-06-10 | Russia | Astrakhan Oblast | 2501 | 23 | 1438 | 1040 | 47.1878186 | 47.608851 | 2020-06-11 03:33:41 | Astrakhan Oblast, Russia | ||
1210580 | 1210580 | 2020-06-09 | Russia | Astrakhan Oblast | 2420 | 22 | 1362 | 1036 | 47.1878186 | 47.608851 | 2020-06-10 04:07:00 | Astrakhan Oblast, Russia | ||
217007 | 217007 | 2020-06-08 | Russia | Astrakhan Oblast | 2337 | 22 | 1294 | 1021 | 47.1878186 | 47.608851 | 2020-06-09 03:33:03 | Astrakhan Oblast, Russia | ||
2799804 | 2799804 | 2020-06-07 | Russia | Astrakhan Oblast | 2293 | 22 | 1263 | 1008 | 47.1878186 | 47.608851 | 2020-06-08 03:33:22 | Astrakhan Oblast, Russia | ||
573860 | 573860 | 2020-06-06 | Russia | Astrakhan Oblast | 2233 | 22 | 1225 | 986 | 47.1878186 | 47.608851 | 2020-06-07 03:53:30 | Astrakhan Oblast, Russia | ||
1269557 | 1269557 | 2020-06-05 | Russia | Astrakhan Oblast | 2172 | 20 | 1166 | 986 | 47.1878186 | 47.608851 | 2020-06-06 02:33:00 | Astrakhan Oblast, Russia | ||
1281038 | 1281038 | 2020-06-04 | Russia | Astrakhan Oblast | 2097 | 19 | 1120 | 958 | 47.1878186 | 47.608851 | 2020-06-05 02:33:06 | Astrakhan Oblast, Russia | ||
3866593 | 3866593 | 2020-06-03 | Russia | Astrakhan Oblast | 2004 | 19 | 1052 | 933 | 47.1878186 | 47.608851 | 2020-06-04 02:33:14 | Astrakhan Oblast, Russia | ||
2555636 | 2555636 | 2020-06-02 | Russia | Astrakhan Oblast | 1937 | 19 | 1014 | 904 | 47.1878186 | 47.608851 | 2020-06-03 02:33:13 | Astrakhan Oblast, Russia | ||
805172 | 805172 | 2020-06-01 | Russia | Astrakhan Oblast | 1883 | 16 | 937 | 930 | 47.1878186 | 47.608851 | 2020-06-02 02:33:08 | Astrakhan Oblast, 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]);