johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,040 rows where country_or_region = "Afghanistan" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, latitude, day (date), last_update (date)
country_or_region 1
- Afghanistan · 1,040 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
479195 | 479195 | 2020-02-25 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
617466 | 617466 | 2020-02-27 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
2509820 | 2509820 | 2020-02-26 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
2883983 | 2883983 | 2020-02-28 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
3205864 | 3205864 | 2020-02-29 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
3551255 | 3551255 | 2020-02-24 | Afghanistan | 5 | 0 | 0 | 2020-02-24T23:33:02 | |||||||
40254 | 40254 | 2020-03-05 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
62622 | 62622 | 2020-03-07 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
98913 | 98913 | 2020-03-04 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
261120 | 261120 | 2020-03-03 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
562584 | 562584 | 2020-03-01 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
657808 | 657808 | 2020-03-09 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-03-08T04:53:03 | |||||
1152729 | 1152729 | 2020-03-02 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
1527321 | 1527321 | 2020-03-08 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-03-08T04:53:03 | |||||
2127563 | 2127563 | 2020-03-11 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T10:13:12 | |||||
2283001 | 2283001 | 2020-03-12 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T10:13:12 | |||||
3177611 | 3177611 | 2020-03-06 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
3752943 | 3752943 | 2020-03-10 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-03-10T12:33:02 | |||||
3765508 | 3765508 | 2020-03-13 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T20:00:00 | |||||
339811 | 339811 | 2020-03-21 | Afghanistan | 24 | 0 | 1 | 33.9391 | 67.71 | 2020-03-20T14:43:04 | |||||
1177043 | 1177043 | 2020-03-18 | Afghanistan | 26 | 0 | 1 | 33.9391 | 67.71 | 2020-03-17T11:53:10 | |||||
1463607 | 1463607 | 2020-03-15 | Afghanistan | 20 | 0 | 0 | 33.9391 | 67.71 | 2020-03-15T18:20:18 | |||||
1527048 | 1527048 | 2020-03-19 | Afghanistan | 26 | 0 | 1 | 33.9391 | 67.71 | 2020-03-17T11:53:10 | |||||
2111236 | 2111236 | 2020-03-14 | Afghanistan | 14 | 0 | 0 | 33.9391 | 67.71 | 2020-03-14T14:53:04 | |||||
2255258 | 2255258 | 2020-03-16 | Afghanistan | 25 | 0 | 1 | 33.9391 | 67.71 | 2020-03-16T14:38:45 | |||||
3734101 | 3734101 | 2020-03-20 | Afghanistan | 24 | 0 | 1 | 33.9391 | 67.71 | 2020-03-20T14:43:04 | |||||
3891467 | 3891467 | 2020-03-17 | Afghanistan | 26 | 0 | 1 | 33.9391 | 67.71 | 2020-03-17T11:53:10 | |||||
1 | 1 | 2021-12-02 | Afghanistan | 157387 | 7310 | 0 | 33.93911 | 67.709953 | 2021-12-03 04:23:05 | Afghanistan | ||||
4017 | 4017 | 2021-10-28 | Afghanistan | 156166 | 7268 | 0 | 33.93911 | 67.709953 | 2021-10-29 04:22:03 | Afghanistan | ||||
8033 | 8033 | 2020-10-25 | Afghanistan | 40768 | 1511 | 34129 | 5128 | 33.93911 | 67.709953 | 2020-10-26 04:25:02 | Afghanistan | |||
12028 | 12028 | 2021-01-26 | Afghanistan | 54750 | 2389 | 47459 | 4902 | 33.93911 | 67.709953 | 2021-01-27 05:23:41 | Afghanistan | |||
16042 | 16042 | 2021-09-18 | Afghanistan | 154487 | 7186 | 0 | 33.93911 | 67.709953 | 2021-09-19 04:21:34 | Afghanistan | ||||
20057 | 20057 | 2021-05-28 | Afghanistan | 69130 | 2881 | 57119 | 9130 | 33.93911 | 67.709953 | 2021-05-29 04:20:41 | Afghanistan | |||
24071 | 24071 | 2022-03-20 | Afghanistan | 177093 | 7654 | 0 | 33.93911 | 67.709953 | 2022-03-21 04:20:50 | Afghanistan | ||||
28087 | 28087 | 2021-11-11 | Afghanistan | 156456 | 7292 | 0 | 33.93911 | 67.709953 | 2021-11-12 04:22:01 | Afghanistan | ||||
32103 | 32103 | 2021-08-25 | Afghanistan | 152722 | 7090 | 0 | 33.93911 | 67.709953 | 2021-08-26 04:21:28 | Afghanistan | ||||
36117 | 36117 | 2021-04-12 | Afghanistan | 57242 | 2529 | 52005 | 2708 | 33.93911 | 67.709953 | 2021-04-13 04:20:37 | Afghanistan | |||
43162 | 43162 | 2020-04-13 | Afghanistan | 607 | 19 | 32 | 556 | 33.93911 | 67.709953 | 2020-04-13 23:07:34 | Afghanistan | |||
43379 | 43379 | 2021-11-02 | Afghanistan | 156307 | 7281 | 0 | 33.93911 | 67.709953 | 2021-11-03 06:22:09 | Afghanistan | ||||
50261 | 50261 | 2020-04-17 | Afghanistan | 845 | 30 | 99 | 716 | 33.93911 | 67.709953 | 2020-04-17 23:30:32 | Afghanistan | |||
50478 | 50478 | 2021-05-29 | Afghanistan | 70111 | 2899 | 57281 | 9931 | 33.93911 | 67.709953 | 2021-05-30 04:20:55 | Afghanistan | |||
54492 | 54492 | 2021-03-07 | Afghanistan | 55847 | 2449 | 49378 | 4020 | 33.93911 | 67.709953 | 2021-03-08 05:24:48 | Afghanistan | |||
62230 | 62230 | 2020-07-23 | Afghanistan | 36001 | 1215 | 24550 | 10236 | 33.93911 | 67.709953 | 2020-07-24 05:30:40 | Afghanistan | |||
62732 | 62732 | 2022-11-12 | Afghanistan | 204417 | 7829 | 0 | 33.93911 | 67.709953 | 2022-11-13 04:21:14 | Afghanistan | ||||
66748 | 66748 | 2021-09-01 | Afghanistan | 153260 | 7123 | 0 | 33.93911 | 67.709953 | 2021-09-02 04:21:15 | Afghanistan | ||||
70762 | 70762 | 2022-02-07 | Afghanistan | 166924 | 7442 | 0 | 33.93911 | 67.709953 | 2022-02-08 04:21:15 | Afghanistan | ||||
74778 | 74778 | 2020-12-03 | Afghanistan | 46980 | 1822 | 37260 | 7898 | 33.93911 | 67.709953 | 2020-12-04 05:27:27 | Afghanistan | |||
78789 | 78789 | 2020-10-14 | Afghanistan | 40080 | 1485 | 33354 | 5241 | 33.93911 | 67.709953 | 2020-10-15 04:24:28 | Afghanistan | |||
82782 | 82782 | 2021-05-25 | Afghanistan | 66903 | 2836 | 56518 | 7549 | 33.93911 | 67.709953 | 2021-05-26 04:20:35 | Afghanistan | |||
86796 | 86796 | 2021-11-09 | Afghanistan | 156397 | 7290 | 0 | 33.93911 | 67.709953 | 2021-11-10 04:21:38 | Afghanistan | ||||
90812 | 90812 | 2022-07-23 | Afghanistan | 184473 | 7738 | 0 | 33.93911 | 67.709953 | 2022-07-24 04:20:47 | Afghanistan | ||||
98594 | 98594 | 2020-08-04 | Afghanistan | 36833 | 1292 | 25669 | 9872 | 33.93911 | 67.709953 | 2020-08-05 04:34:43 | Afghanistan | |||
98997 | 98997 | 2022-01-14 | Afghanistan | 158639 | 7376 | 0 | 33.93911 | 67.709953 | 2022-01-15 04:21:07 | Afghanistan | ||||
103013 | 103013 | 2021-08-15 | Afghanistan | 152033 | 7021 | 0 | 33.93911 | 67.709953 | 2021-08-16 04:21:31 | Afghanistan | ||||
107138 | 107138 | 2021-06-19 | Afghanistan | 100521 | 4030 | 63875 | 32616 | 33.93911 | 67.709953 | 2021-06-20 04:21:48 | Afghanistan | |||
114201 | 114201 | 2020-05-08 | Afghanistan | 3563 | 105 | 472 | 2986 | 33.93911 | 67.709953 | 2020-05-09 02:32:35 | Afghanistan | |||
114422 | 114422 | 2022-09-06 | Afghanistan | 194614 | 7783 | 0 | 33.93911 | 67.709953 | 2022-09-07 04:20:59 | Afghanistan | ||||
122185 | 122185 | 2020-07-19 | Afghanistan | 35561 | 1185 | 23634 | 10742 | 33.93911 | 67.709953 | 2020-07-20 05:34:40 | Afghanistan | |||
122394 | 122394 | 2020-11-18 | Afghanistan | 43628 | 1638 | 35295 | 6695 | 33.93911 | 67.709953 | 2020-11-19 05:25:23 | Afghanistan | |||
126404 | 126404 | 2022-01-09 | Afghanistan | 158381 | 7373 | 0 | 33.93911 | 67.709953 | 2022-01-10 04:22:07 | Afghanistan | ||||
130420 | 130420 | 2022-10-04 | Afghanistan | 199690 | 7803 | 0 | 33.93911 | 67.709953 | 2022-10-05 04:23:06 | Afghanistan | ||||
137425 | 137425 | 2020-04-29 | Afghanistan | 1827 | 60 | 252 | 1515 | 33.93911 | 67.709953 | 2020-04-30 02:32:27 | Afghanistan | |||
137642 | 137642 | 2021-12-04 | Afghanistan | 157431 | 7312 | 0 | 33.93911 | 67.709953 | 2021-12-05 04:22:25 | Afghanistan | ||||
141658 | 141658 | 2022-07-09 | Afghanistan | 183235 | 7728 | 0 | 33.93911 | 67.709953 | 2022-07-10 04:20:54 | Afghanistan | ||||
145674 | 145674 | 2020-08-15 | Afghanistan | 37637 | 1374 | 27166 | 9097 | 33.93911 | 67.709953 | 2020-08-16 04:27:42 | Afghanistan | |||
149655 | 149655 | 2021-11-29 | Afghanistan | 157260 | 7308 | 0 | 33.93911 | 67.709953 | 2021-11-30 04:22:53 | Afghanistan | ||||
153671 | 153671 | 2021-01-08 | Afghanistan | 53332 | 2257 | 43440 | 7635 | 33.93911 | 67.709953 | 2021-01-09 05:22:18 | Afghanistan | |||
157683 | 157683 | 2022-03-29 | Afghanistan | 177658 | 7665 | 0 | 33.93911 | 67.709953 | 2022-03-30 04:20:45 | Afghanistan | ||||
161699 | 161699 | 2021-11-19 | Afghanistan | 156812 | 7299 | 0 | 33.93911 | 67.709953 | 2021-11-20 04:22:17 | Afghanistan | ||||
165715 | 165715 | 2022-06-21 | Afghanistan | 181808 | 7715 | 0 | 33.93911 | 67.709953 | 2022-06-22 04:20:54 | Afghanistan | ||||
169731 | 169731 | 2021-04-16 | Afghanistan | 57612 | 2535 | 52105 | 2972 | 33.93911 | 67.709953 | 2021-04-17 04:20:40 | Afghanistan | |||
177503 | 177503 | 2020-07-27 | Afghanistan | 36349 | 1273 | 25198 | 9878 | 33.93911 | 67.709953 | 2020-07-28 04:58:43 | Afghanistan | |||
177713 | 177713 | 2021-09-02 | Afghanistan | 153306 | 7127 | 0 | 33.93911 | 67.709953 | 2021-09-03 04:21:20 | Afghanistan | ||||
181727 | 181727 | 2021-02-21 | Afghanistan | 55604 | 2432 | 48834 | 4338 | 33.93911 | 67.709953 | 2021-02-22 05:24:21 | Afghanistan | |||
185741 | 185741 | 2022-02-13 | Afghanistan | 170604 | 7494 | 0 | 33.93911 | 67.709953 | 2022-02-14 04:20:51 | Afghanistan | ||||
189757 | 189757 | 2021-01-11 | Afghanistan | 53538 | 2288 | 44137 | 7113 | 33.93911 | 67.709953 | 2021-01-12 05:22:15 | Afghanistan | |||
193769 | 193769 | 2020-08-31 | Afghanistan | 38248 | 1406 | 29089 | 7753 | 33.93911 | 67.709953 | 2020-09-01 04:28:31 | Afghanistan | |||
197929 | 197929 | 2022-10-19 | Afghanistan | 201557 | 7812 | 0 | 33.93911 | 67.709953 | 2022-10-20 04:22:59 | Afghanistan | ||||
201945 | 201945 | 2020-12-25 | Afghanistan | 51595 | 2135 | 40444 | 9016 | 33.93911 | 67.709953 | 2020-12-26 05:22:28 | Afghanistan | |||
205956 | 205956 | 2020-08-19 | Afghanistan | 37685 | 1379 | 27166 | 9140 | 33.93911 | 67.709953 | 2020-08-20 04:27:43 | Afghanistan | |||
209941 | 209941 | 2020-10-29 | Afghanistan | 41145 | 1529 | 34239 | 5377 | 33.93911 | 67.709953 | 2020-10-30 04:24:49 | Afghanistan | |||
217440 | 217440 | 2020-06-08 | Afghanistan | 21003 | 373 | 2171 | 18459 | 33.93911 | 67.709953 | 2020-06-09 03:33:03 | Afghanistan | |||
217650 | 217650 | 2022-12-26 | Afghanistan | 207438 | 7846 | 0 | 33.93911 | 67.709953 | 2022-12-27 04:21:07 | Afghanistan | ||||
221666 | 221666 | 2022-05-09 | Afghanistan | 179010 | 7685 | 0 | 33.93911 | 67.709953 | 2022-05-10 04:20:50 | Afghanistan | ||||
228678 | 228678 | 2020-04-30 | Afghanistan | 1827 | 60 | 260 | 1507 | 33.93911 | 67.709953 | 2020-05-01 02:32:28 | Afghanistan | |||
228897 | 228897 | 2022-05-31 | Afghanistan | 180347 | 7705 | 0 | 33.93911 | 67.709953 | 2022-06-01 04:20:55 | Afghanistan | ||||
232913 | 232913 | 2022-02-11 | Afghanistan | 169940 | 7478 | 0 | 33.93911 | 67.709953 | 2022-02-12 04:21:06 | Afghanistan | ||||
236929 | 236929 | 2021-01-18 | Afghanistan | 54062 | 2343 | 46359 | 5360 | 33.93911 | 67.709953 | 2021-01-19 05:22:15 | Afghanistan | |||
240942 | 240942 | 2021-04-02 | Afghanistan | 56572 | 2495 | 51798 | 2279 | 33.93911 | 67.709953 | 2021-04-03 04:20:44 | Afghanistan | |||
244956 | 244956 | 2021-08-17 | Afghanistan | 152243 | 7031 | 0 | 33.93911 | 67.709953 | 2021-08-18 04:21:35 | Afghanistan | ||||
248970 | 248970 | 2021-09-04 | Afghanistan | 153395 | 7128 | 0 | 33.93911 | 67.709953 | 2021-09-05 04:21:33 | Afghanistan | ||||
252984 | 252984 | 2022-09-08 | Afghanistan | 195298 | 7786 | 0 | 33.93911 | 67.709953 | 2022-09-09 04:21:11 | Afghanistan | ||||
257000 | 257000 | 2022-12-10 | Afghanistan | 206543 | 7839 | 0 | 33.93911 | 67.709953 | 2022-12-11 04:20:50 | Afghanistan | ||||
261203 | 261203 | 2022-03-15 | Afghanistan | 176571 | 7646 | 0 | 33.93911 | 67.709953 | 2022-03-16 04:20:50 | Afghanistan | ||||
268439 | 268439 | 2020-05-21 | Afghanistan | 8676 | 193 | 938 | 7545 | 33.93911 | 67.709953 | 2020-05-22 02:36:51 | Afghanistan | |||
271639 | 271639 | 2020-04-28 | Afghanistan | 1703 | 60 | 228 | 1415 | 33.93911 | 67.709953 | 2020-04-29 02:32:29 | Afghanistan | |||
271856 | 271856 | 2020-11-10 | Afghanistan | 42297 | 1574 | 34954 | 5769 | 33.93911 | 67.709953 | 2020-11-11 05:25:30 | Afghanistan | |||
275854 | 275854 | 2021-11-03 | Afghanistan | 156323 | 7284 | 0 | 33.93911 | 67.709953 | 2021-11-04 04:22:20 | Afghanistan | ||||
279870 | 279870 | 2021-02-24 | Afghanistan | 55664 | 2436 | 49086 | 4142 | 33.93911 | 67.709953 | 2021-02-25 05:24:57 | Afghanistan | |||
287464 | 287464 | 2020-06-15 | Afghanistan | 25613 | 480 | 5164 | 19969 | 33.93911 | 67.709953 | 2020-06-16 04:33:09 | Afghanistan |
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]);