daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,039 rows where country_or_region = "Algeria" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Algeria · 1,039 ✖
province_or_state 0
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-06 | Algeria | 60800 | 2024 | 41510 | 17266 | 28.0339 | 1.6596 | 2020-11-07 05:24:52 | Algeria | |||
2021-04-30 | Algeria | 122108 | 3253 | 85108 | 33747 | 28.0339 | 1.6596 | 2021-05-01 04:20:47 | Algeria | |||
2022-09-23 | Algeria | 270631 | 6879 | 0 | 28.0339 | 1.6596 | 2022-09-24 04:21:40 | Algeria | ||||
2021-04-04 | Algeria | 117622 | 3105 | 81896 | 32621 | 28.0339 | 1.6596 | 2021-04-05 04:20:35 | Algeria | |||
2020-11-27 | Algeria | 80168 | 2372 | 51946 | 25850 | 28.0339 | 1.6596 | 2020-11-28 05:25:50 | Algeria | |||
2022-10-07 | Algeria | 270701 | 6881 | 0 | 28.0339 | 1.6596 | 2022-10-08 04:22:56 | Algeria | ||||
2021-06-29 | Algeria | 139229 | 3708 | 96815 | 38706 | 28.0339 | 1.6596 | 2021-06-30 04:21:41 | Algeria | |||
2021-12-07 | Algeria | 211859 | 6114 | 0 | 28.0339 | 1.6596 | 2021-12-08 04:22:46 | Algeria | ||||
2021-07-28 | Algeria | 167131 | 4161 | 112900 | 50070 | 28.0339 | 1.6596 | 2021-07-29 04:21:33 | Algeria | |||
2020-07-05 | Algeria | 15941 | 952 | 11492 | 3497 | 28.0339 | 1.6596 | 2020-07-06 04:33:57 | Algeria | |||
2020-04-18 | Algeria | 2534 | 367 | 894 | 1273 | 28.0339 | 1.6596 | 2020-04-18 22:32:28 | Algeria | |||
2022-09-18 | Algeria | 270609 | 6879 | 0 | 28.0339 | 1.6596 | 2022-09-19 04:21:49 | Algeria | ||||
2021-10-10 | Algeria | 204597 | 5853 | 0 | 28.0339 | 1.6596 | 2021-10-11 04:21:31 | Algeria | ||||
2020-09-07 | Algeria | 46653 | 1562 | 32985 | 12106 | 28.0339 | 1.6596 | 2020-09-08 04:28:25 | Algeria | |||
2022-11-03 | Algeria | 270847 | 6881 | 0 | 28.0339 | 1.6596 | 2022-11-04 04:22:11 | Algeria | ||||
2021-01-21 | Algeria | 104852 | 2853 | 71343 | 30656 | 28.0339 | 1.6596 | 2021-01-22 05:22:10 | Algeria | |||
2020-07-26 | Algeria | 27357 | 1155 | 18088 | 8114 | 28.0339 | 1.6596 | 2020-07-27 04:35:02 | Algeria | |||
2021-10-20 | Algeria | 205529 | 5878 | 0 | 28.0339 | 1.6596 | 2021-10-21 04:21:18 | Algeria | ||||
2021-11-17 | Algeria | 208380 | 6005 | 0 | 28.0339 | 1.6596 | 2021-11-18 04:21:33 | Algeria | ||||
2022-12-21 | Algeria | 271186 | 6881 | 0 | 28.0339 | 1.6596 | 2022-12-22 04:20:56 | Algeria | ||||
2020-08-07 | Algeria | 34155 | 1282 | 23667 | 9206 | 28.0339 | 1.6596 | 2020-08-08 04:34:53 | Algeria | |||
2022-02-02 | Algeria | 254885 | 6604 | 0 | 28.0339 | 1.6596 | 2022-02-03 04:21:21 | Algeria | ||||
2022-05-02 | Algeria | 265782 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-03 04:21:00 | Algeria | ||||
2021-10-07 | Algeria | 204276 | 5843 | 0 | 28.0339 | 1.6596 | 2021-10-08 04:21:25 | Algeria | ||||
2021-02-19 | Algeria | 111600 | 2954 | 76797 | 31849 | 28.0339 | 1.6596 | 2021-02-20 05:22:51 | Algeria | |||
2022-06-26 | Algeria | 266038 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-27 04:21:00 | Algeria | ||||
2020-02-25 | Algeria | 1 | 0 | 0 | 2020-02-25T23:43:03 | |||||||
2022-11-08 | Algeria | 270891 | 6881 | 0 | 28.0339 | 1.6596 | 2022-11-09 04:21:22 | Algeria | ||||
2021-07-19 | Algeria | 154486 | 3956 | 106337 | 44193 | 28.0339 | 1.6596 | 2021-07-20 04:21:48 | Algeria | |||
2022-11-25 | Algeria | 271057 | 6881 | 0 | 28.0339 | 1.6596 | 2022-11-26 04:21:11 | Algeria | ||||
2021-10-14 | Algeria | 205005 | 5864 | 0 | 28.0339 | 1.6596 | 2021-10-15 04:21:26 | Algeria | ||||
2021-11-06 | Algeria | 207079 | 5941 | 0 | 28.0339 | 1.6596 | 2021-11-07 04:21:53 | Algeria | ||||
2022-04-02 | Algeria | 265684 | 6874 | 0 | 28.0339 | 1.6596 | 2022-04-03 04:20:48 | Algeria | ||||
2022-12-17 | Algeria | 271168 | 6881 | 0 | 28.0339 | 1.6596 | 2022-12-18 04:21:03 | Algeria | ||||
2021-08-14 | Algeria | 186655 | 4766 | 0 | 28.0339 | 1.6596 | 2021-08-15 04:21:41 | Algeria | ||||
2021-08-19 | Algeria | 190078 | 4929 | 0 | 28.0339 | 1.6596 | 2021-08-20 04:21:33 | Algeria | ||||
2022-10-15 | Algeria | 270734 | 6881 | 0 | 28.0339 | 1.6596 | 2022-10-16 04:22:39 | Algeria | ||||
2020-04-21 | Algeria | 2811 | 392 | 1152 | 1267 | 28.0339 | 1.6596 | 2020-04-21 23:30:30 | Algeria | |||
2021-06-09 | Algeria | 132034 | 3544 | 91894 | 36596 | 28.0339 | 1.6596 | 2021-06-10 04:23:17 | Algeria | |||
2020-07-04 | Algeria | 15500 | 946 | 11181 | 3373 | 28.0339 | 1.6596 | 2020-07-05 04:33:46 | Algeria | |||
2021-02-22 | Algeria | 112094 | 2964 | 77225 | 31905 | 28.0339 | 1.6596 | 2021-02-23 05:23:41 | Algeria | |||
2021-10-27 | Algeria | 206069 | 5904 | 0 | 28.0339 | 1.6596 | 2021-10-28 04:22:08 | Algeria | ||||
2022-10-26 | Algeria | 270810 | 6881 | 0 | 28.0339 | 1.6596 | 2022-10-27 04:22:01 | Algeria | ||||
2022-12-15 | Algeria | 271156 | 6881 | 0 | 28.0339 | 1.6596 | 2022-12-16 04:21:01 | Algeria | ||||
2020-09-12 | Algeria | 48007 | 1605 | 33875 | 12527 | 28.0339 | 1.6596 | 2020-09-13 04:30:52 | Algeria | |||
2021-12-08 | Algeria | 212047 | 6122 | 0 | 28.0339 | 1.6596 | 2021-12-09 04:22:49 | Algeria | ||||
2022-01-16 | Algeria | 226057 | 6412 | 0 | 28.0339 | 1.6596 | 2022-01-17 04:21:08 | Algeria | ||||
2022-06-16 | Algeria | 265964 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-17 04:20:56 | Algeria | ||||
2020-03-01 | Algeria | 1 | 0 | 0 | 28.0339 | 1.6596 | 2020-02-25T23:43:03 | |||||
2021-06-22 | Algeria | 136679 | 3650 | 95084 | 37945 | 28.0339 | 1.6596 | 2021-06-23 04:21:46 | Algeria | |||
2021-10-29 | Algeria | 206270 | 5913 | 0 | 28.0339 | 1.6596 | 2021-10-30 04:22:03 | Algeria | ||||
2020-06-06 | Algeria | 10050 | 698 | 6631 | 2721 | 28.0339 | 1.6596 | 2020-06-07 03:53:30 | Algeria | |||
2022-02-25 | Algeria | 264706 | 6823 | 0 | 28.0339 | 1.6596 | 2022-02-26 04:21:12 | Algeria | ||||
2021-07-13 | Algeria | 147883 | 3867 | 102594 | 41422 | 28.0339 | 1.6596 | 2021-07-14 04:21:35 | Algeria | |||
2020-08-13 | Algeria | 37187 | 1341 | 26004 | 9842 | 28.0339 | 1.6596 | 2020-08-14 04:51:19 | Algeria | |||
2020-04-05 | Algeria | 1320 | 152 | 90 | 1078 | 28.0339 | 1.6596 | 2020-04-05 23:06:26 | Algeria | |||
2021-08-08 | Algeria | 181376 | 4550 | 0 | 28.0339 | 1.6596 | 2021-08-09 04:21:24 | Algeria | ||||
2022-07-01 | Algeria | 266105 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-02 04:21:16 | Algeria | ||||
2021-10-19 | Algeria | 205453 | 5875 | 0 | 28.0339 | 1.6596 | 2021-10-20 04:21:00 | Algeria | ||||
2021-09-23 | Algeria | 202283 | 5748 | 0 | 28.0339 | 1.6596 | 2021-09-24 04:21:44 | Algeria | ||||
2021-04-09 | Algeria | 118251 | 3123 | 82392 | 32736 | 28.0339 | 1.6596 | 2021-04-10 04:20:59 | Algeria | |||
2020-08-29 | Algeria | 43781 | 1491 | 30717 | 11573 | 28.0339 | 1.6596 | 2020-08-30 04:28:22 | Algeria | |||
2021-02-08 | Algeria | 109313 | 2918 | 74871 | 31524 | 28.0339 | 1.6596 | 2021-02-09 05:23:30 | Algeria | |||
2020-02-27 | Algeria | 1 | 0 | 0 | 2020-02-25T23:43:03 | |||||||
2022-11-05 | Algeria | 270862 | 6881 | 0 | 28.0339 | 1.6596 | 2022-11-06 04:21:24 | Algeria | ||||
2022-05-22 | Algeria | 265862 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-26 04:20:50 | Algeria | ||||
2021-07-10 | Algeria | 145296 | 3824 | 100911 | 40561 | 28.0339 | 1.6596 | 2021-07-11 04:21:43 | Algeria | |||
2022-07-12 | Algeria | 266303 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-13 04:20:58 | Algeria | ||||
2021-10-13 | Algeria | 204900 | 5862 | 0 | 28.0339 | 1.6596 | 2021-10-14 04:21:29 | Algeria | ||||
2021-03-31 | Algeria | 117192 | 3093 | 81538 | 32561 | 28.0339 | 1.6596 | 2021-04-01 04:27:05 | Algeria | |||
2021-09-07 | Algeria | 198645 | 5471 | 0 | 28.0339 | 1.6596 | 2021-09-08 04:21:31 | Algeria | ||||
2021-05-05 | Algeria | 123272 | 3299 | 85869 | 34104 | 28.0339 | 1.6596 | 2021-05-06 04:20:38 | Algeria | |||
2021-08-09 | Algeria | 182368 | 4578 | 0 | 28.0339 | 1.6596 | 2021-08-10 04:21:27 | Algeria | ||||
2021-10-22 | Algeria | 205683 | 5883 | 0 | 28.0339 | 1.6596 | 2021-10-23 04:21:32 | Algeria | ||||
2020-03-09 | Algeria | 20 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-09T10:13:06 | |||||
2022-05-13 | Algeria | 265814 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-14 04:20:48 | Algeria | ||||
2020-08-11 | Algeria | 36204 | 1322 | 25263 | 9619 | 28.0339 | 1.6596 | 2020-08-12 04:27:29 | Algeria | |||
2020-09-16 | Algeria | 48966 | 1645 | 34517 | 12804 | 28.0339 | 1.6596 | 2020-09-17 04:22:00 | Algeria | |||
2022-07-21 | Algeria | 266654 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-22 04:21:15 | Algeria | ||||
2022-07-30 | Algeria | 267374 | 6876 | 0 | 28.0339 | 1.6596 | 2022-07-31 04:21:02 | Algeria | ||||
2020-11-23 | Algeria | 75867 | 2294 | 49421 | 24152 | 28.0339 | 1.6596 | 2020-11-24 05:27:31 | Algeria | |||
2021-10-24 | Algeria | 205822 | 5890 | 0 | 28.0339 | 1.6596 | 2021-10-25 04:22:31 | Algeria | ||||
2021-11-13 | Algeria | 207873 | 5977 | 0 | 28.0339 | 1.6596 | 2021-11-14 04:21:31 | Algeria | ||||
2022-12-23 | Algeria | 271193 | 6881 | 0 | 28.0339 | 1.6596 | 2022-12-24 04:21:02 | Algeria | ||||
2022-03-17 | Algeria | 265511 | 6870 | 0 | 28.0339 | 1.6596 | 2022-03-18 04:20:55 | Algeria | ||||
2021-11-04 | Algeria | 206878 | 5936 | 0 | 28.0339 | 1.6596 | 2021-11-05 04:21:54 | Algeria | ||||
2021-03-16 | Algeria | 115540 | 3045 | 80103 | 32392 | 28.0339 | 1.6596 | 2021-03-17 05:25:07 | Algeria | |||
2021-09-29 | Algeria | 203198 | 5805 | 0 | 28.0339 | 1.6596 | 2021-09-30 04:21:20 | Algeria | ||||
2022-11-01 | Algeria | 270839 | 6881 | 0 | 28.0339 | 1.6596 | 2022-11-02 04:22:09 | Algeria | ||||
2021-11-12 | Algeria | 207764 | 5971 | 0 | 28.0339 | 1.6596 | 2021-11-13 04:21:38 | Algeria | ||||
2022-12-04 | Algeria | 271107 | 6881 | 0 | 28.0339 | 1.6596 | 2022-12-05 04:20:58 | Algeria | ||||
2021-11-20 | Algeria | 208839 | 6017 | 0 | 28.0339 | 1.6596 | 2021-11-21 04:22:13 | Algeria | ||||
2021-05-22 | Algeria | 126651 | 3411 | 88208 | 35032 | 28.0339 | 1.6596 | 2021-05-23 04:20:51 | Algeria | |||
2021-12-27 | Algeria | 216930 | 6246 | 0 | 28.0339 | 1.6596 | 2021-12-28 04:21:47 | Algeria | ||||
2020-06-12 | Algeria | 10698 | 751 | 7322 | 2625 | 28.0339 | 1.6596 | 2020-06-13 03:33:14 | Algeria | |||
2020-12-02 | Algeria | 85084 | 2464 | 54990 | 27630 | 28.0339 | 1.6596 | 2020-12-03 05:28:22 | Algeria | |||
2021-02-20 | Algeria | 111764 | 2958 | 76940 | 31866 | 28.0339 | 1.6596 | 2021-02-21 05:24:33 | Algeria | |||
2022-04-23 | Algeria | 265761 | 6874 | 0 | 28.0339 | 1.6596 | 2022-04-24 04:20:56 | Algeria | ||||
2020-08-01 | Algeria | 30950 | 1223 | 20988 | 8739 | 28.0339 | 1.6596 | 2020-08-02 04:34:47 | Algeria | |||
2020-10-28 | Algeria | 57026 | 1941 | 39635 | 15450 | 28.0339 | 1.6596 | 2020-10-29 04:24:49 | Algeria |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;