daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

4,006,353 rows sorted by country_or_region

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state >30

country_or_region >30

day country_or_region ▼ province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-12-02 Afghanistan       157387 7310 0   33.93911 67.709953 2021-12-03 04:23:05 Afghanistan
2021-10-28 Afghanistan       156166 7268 0   33.93911 67.709953 2021-10-29 04:22:03 Afghanistan
2020-10-25 Afghanistan       40768 1511 34129 5128 33.93911 67.709953 2020-10-26 04:25:02 Afghanistan
2021-01-26 Afghanistan       54750 2389 47459 4902 33.93911 67.709953 2021-01-27 05:23:41 Afghanistan
2021-09-18 Afghanistan       154487 7186 0   33.93911 67.709953 2021-09-19 04:21:34 Afghanistan
2021-05-28 Afghanistan       69130 2881 57119 9130 33.93911 67.709953 2021-05-29 04:20:41 Afghanistan
2022-03-20 Afghanistan       177093 7654 0   33.93911 67.709953 2022-03-21 04:20:50 Afghanistan
2021-11-11 Afghanistan       156456 7292 0   33.93911 67.709953 2021-11-12 04:22:01 Afghanistan
2021-08-25 Afghanistan       152722 7090 0   33.93911 67.709953 2021-08-26 04:21:28 Afghanistan
2021-04-12 Afghanistan       57242 2529 52005 2708 33.93911 67.709953 2021-04-13 04:20:37 Afghanistan
2020-03-05 Afghanistan       5 0 0   33.0 65.0 2020-02-24T23:33:02  
2020-04-13 Afghanistan       607 19 32 556 33.93911 67.709953 2020-04-13 23:07:34 Afghanistan
2021-11-02 Afghanistan       156307 7281 0   33.93911 67.709953 2021-11-03 06:22:09 Afghanistan
2020-04-17 Afghanistan       845 30 99 716 33.93911 67.709953 2020-04-17 23:30:32 Afghanistan
2021-05-29 Afghanistan       70111 2899 57281 9931 33.93911 67.709953 2021-05-30 04:20:55 Afghanistan
2021-03-07 Afghanistan       55847 2449 49378 4020 33.93911 67.709953 2021-03-08 05:24:48 Afghanistan
2020-07-23 Afghanistan       36001 1215 24550 10236 33.93911 67.709953 2020-07-24 05:30:40 Afghanistan
2020-03-07 Afghanistan       8 0 0   33.0 65.0 2020-02-24T23:33:02  
2022-11-12 Afghanistan       204417 7829 0   33.93911 67.709953 2022-11-13 04:21:14 Afghanistan
2021-09-01 Afghanistan       153260 7123 0   33.93911 67.709953 2021-09-02 04:21:15 Afghanistan
2022-02-07 Afghanistan       166924 7442 0   33.93911 67.709953 2022-02-08 04:21:15 Afghanistan
2020-12-03 Afghanistan       46980 1822 37260 7898 33.93911 67.709953 2020-12-04 05:27:27 Afghanistan
2020-10-14 Afghanistan       40080 1485 33354 5241 33.93911 67.709953 2020-10-15 04:24:28 Afghanistan
2021-05-25 Afghanistan       66903 2836 56518 7549 33.93911 67.709953 2021-05-26 04:20:35 Afghanistan
2021-11-09 Afghanistan       156397 7290 0   33.93911 67.709953 2021-11-10 04:21:38 Afghanistan
2022-07-23 Afghanistan       184473 7738 0   33.93911 67.709953 2022-07-24 04:20:47 Afghanistan
2020-08-04 Afghanistan       36833 1292 25669 9872 33.93911 67.709953 2020-08-05 04:34:43 Afghanistan
2020-03-04 Afghanistan       5 0 0   33.0 65.0 2020-02-24T23:33:02  
2022-01-14 Afghanistan       158639 7376 0   33.93911 67.709953 2022-01-15 04:21:07 Afghanistan
2021-08-15 Afghanistan       152033 7021 0   33.93911 67.709953 2021-08-16 04:21:31 Afghanistan
2021-06-19 Afghanistan       100521 4030 63875 32616 33.93911 67.709953 2021-06-20 04:21:48 Afghanistan
2020-05-08 Afghanistan       3563 105 472 2986 33.93911 67.709953 2020-05-09 02:32:35 Afghanistan
2022-09-06 Afghanistan       194614 7783 0   33.93911 67.709953 2022-09-07 04:20:59 Afghanistan
2020-07-19 Afghanistan       35561 1185 23634 10742 33.93911 67.709953 2020-07-20 05:34:40 Afghanistan
2020-11-18 Afghanistan       43628 1638 35295 6695 33.93911 67.709953 2020-11-19 05:25:23 Afghanistan
2022-01-09 Afghanistan       158381 7373 0   33.93911 67.709953 2022-01-10 04:22:07 Afghanistan
2022-10-04 Afghanistan       199690 7803 0   33.93911 67.709953 2022-10-05 04:23:06 Afghanistan
2020-04-29 Afghanistan       1827 60 252 1515 33.93911 67.709953 2020-04-30 02:32:27 Afghanistan
2021-12-04 Afghanistan       157431 7312 0   33.93911 67.709953 2021-12-05 04:22:25 Afghanistan
2022-07-09 Afghanistan       183235 7728 0   33.93911 67.709953 2022-07-10 04:20:54 Afghanistan
2020-08-15 Afghanistan       37637 1374 27166 9097 33.93911 67.709953 2020-08-16 04:27:42 Afghanistan
2021-11-29 Afghanistan       157260 7308 0   33.93911 67.709953 2021-11-30 04:22:53 Afghanistan
2021-01-08 Afghanistan       53332 2257 43440 7635 33.93911 67.709953 2021-01-09 05:22:18 Afghanistan
2022-03-29 Afghanistan       177658 7665 0   33.93911 67.709953 2022-03-30 04:20:45 Afghanistan
2021-11-19 Afghanistan       156812 7299 0   33.93911 67.709953 2021-11-20 04:22:17 Afghanistan
2022-06-21 Afghanistan       181808 7715 0   33.93911 67.709953 2022-06-22 04:20:54 Afghanistan
2021-04-16 Afghanistan       57612 2535 52105 2972 33.93911 67.709953 2021-04-17 04:20:40 Afghanistan
2020-07-27 Afghanistan       36349 1273 25198 9878 33.93911 67.709953 2020-07-28 04:58:43 Afghanistan
2021-09-02 Afghanistan       153306 7127 0   33.93911 67.709953 2021-09-03 04:21:20 Afghanistan
2021-02-21 Afghanistan       55604 2432 48834 4338 33.93911 67.709953 2021-02-22 05:24:21 Afghanistan
2022-02-13 Afghanistan       170604 7494 0   33.93911 67.709953 2022-02-14 04:20:51 Afghanistan
2021-01-11 Afghanistan       53538 2288 44137 7113 33.93911 67.709953 2021-01-12 05:22:15 Afghanistan
2020-08-31 Afghanistan       38248 1406 29089 7753 33.93911 67.709953 2020-09-01 04:28:31 Afghanistan
2022-10-19 Afghanistan       201557 7812 0   33.93911 67.709953 2022-10-20 04:22:59 Afghanistan
2020-12-25 Afghanistan       51595 2135 40444 9016 33.93911 67.709953 2020-12-26 05:22:28 Afghanistan
2020-08-19 Afghanistan       37685 1379 27166 9140 33.93911 67.709953 2020-08-20 04:27:43 Afghanistan
2020-10-29 Afghanistan       41145 1529 34239 5377 33.93911 67.709953 2020-10-30 04:24:49 Afghanistan
2020-06-08 Afghanistan       21003 373 2171 18459 33.93911 67.709953 2020-06-09 03:33:03 Afghanistan
2022-12-26 Afghanistan       207438 7846 0   33.93911 67.709953 2022-12-27 04:21:07 Afghanistan
2022-05-09 Afghanistan       179010 7685 0   33.93911 67.709953 2022-05-10 04:20:50 Afghanistan
2020-04-30 Afghanistan       1827 60 260 1507 33.93911 67.709953 2020-05-01 02:32:28 Afghanistan
2022-05-31 Afghanistan       180347 7705 0   33.93911 67.709953 2022-06-01 04:20:55 Afghanistan
2022-02-11 Afghanistan       169940 7478 0   33.93911 67.709953 2022-02-12 04:21:06 Afghanistan
2021-01-18 Afghanistan       54062 2343 46359 5360 33.93911 67.709953 2021-01-19 05:22:15 Afghanistan
2021-04-02 Afghanistan       56572 2495 51798 2279 33.93911 67.709953 2021-04-03 04:20:44 Afghanistan
2021-08-17 Afghanistan       152243 7031 0   33.93911 67.709953 2021-08-18 04:21:35 Afghanistan
2021-09-04 Afghanistan       153395 7128 0   33.93911 67.709953 2021-09-05 04:21:33 Afghanistan
2022-09-08 Afghanistan       195298 7786 0   33.93911 67.709953 2022-09-09 04:21:11 Afghanistan
2022-12-10 Afghanistan       206543 7839 0   33.93911 67.709953 2022-12-11 04:20:50 Afghanistan
2020-03-03 Afghanistan       5 0 0   33.0 65.0 2020-02-24T23:33:02  
2022-03-15 Afghanistan       176571 7646 0   33.93911 67.709953 2022-03-16 04:20:50 Afghanistan
2020-05-21 Afghanistan       8676 193 938 7545 33.93911 67.709953 2020-05-22 02:36:51 Afghanistan
2020-04-28 Afghanistan       1703 60 228 1415 33.93911 67.709953 2020-04-29 02:32:29 Afghanistan
2020-11-10 Afghanistan       42297 1574 34954 5769 33.93911 67.709953 2020-11-11 05:25:30 Afghanistan
2021-11-03 Afghanistan       156323 7284 0   33.93911 67.709953 2021-11-04 04:22:20 Afghanistan
2021-02-24 Afghanistan       55664 2436 49086 4142 33.93911 67.709953 2021-02-25 05:24:57 Afghanistan
2020-06-15 Afghanistan       25613 480 5164 19969 33.93911 67.709953 2020-06-16 04:33:09 Afghanistan
2021-10-31 Afghanistan       156250 7280 0   33.93911 67.709953 2021-11-01 04:22:01 Afghanistan
2022-11-15 Afghanistan       204724 7829 0   33.93911 67.709953 2022-11-16 04:21:09 Afghanistan
2021-07-15 Afghanistan       137853 5983 82586 49284 33.93911 67.709953 2021-07-16 04:21:22 Afghanistan
2020-07-01 Afghanistan       31848 778 15651 15419 33.93911 67.709953 2020-07-02 04:33:46 Afghanistan
2022-04-16 Afghanistan       178387 7676 0   33.93911 67.709953 2022-04-17 04:20:59 Afghanistan
2022-12-13 Afghanistan       206743 7843 0   33.93911 67.709953 2022-12-14 04:21:04 Afghanistan
2022-11-13 Afghanistan       204510 7829 0   33.93911 67.709953 2022-11-14 04:21:09 Afghanistan
2022-02-12 Afghanistan       170152 7488 0   33.93911 67.709953 2022-02-13 04:21:00 Afghanistan
2022-10-30 Afghanistan       202966 7821 0   33.93911 67.709953 2022-10-31 04:21:36 Afghanistan
2020-07-20 Afghanistan       35595 1187 23741 10667 33.93911 67.709953 2020-07-21 04:38:46 Afghanistan
2022-12-27 Afghanistan       207460 7846 0   33.93911 67.709953 2022-12-28 04:21:04 Afghanistan
2021-08-04 Afghanistan       148933 6836 82586 59511 33.93911 67.709953 2021-08-05 04:21:51 Afghanistan
2022-03-18 Afghanistan       176983 7651 0   33.93911 67.709953 2022-03-19 04:20:47 Afghanistan
2020-03-21 Afghanistan       24 0 1   33.9391 67.71 2020-03-20T14:43:04  
2021-02-03 Afghanistan       55174 2406 47982 4786 33.93911 67.709953 2021-02-04 05:22:26 Afghanistan
2020-09-14 Afghanistan       38858 1429 32073 5356 33.93911 67.709953 2020-09-15 03:22:50 Afghanistan
2022-12-14 Afghanistan       206788 7843 0   33.93911 67.709953 2022-12-15 04:20:58 Afghanistan
2021-03-11 Afghanistan       55917 2451 49499 3967 33.93911 67.709953 2021-03-12 05:26:50 Afghanistan
2022-03-11 Afghanistan       175974 7640 0   33.93911 67.709953 2022-03-12 04:20:50 Afghanistan
2022-05-07 Afghanistan       178922 7684 0   33.93911 67.709953 2022-05-08 04:20:49 Afghanistan
2020-07-16 Afghanistan       35156 1117 22824 11215 33.93911 67.709953 2020-07-17 04:34:50 Afghanistan
2020-08-08 Afghanistan       37101 1311 25960 9830 33.93911 67.709953 2020-08-09 04:34:54 Afghanistan
2022-09-13 Afghanistan       196404 7791 0   33.93911 67.709953 2022-09-14 04:20:44 Afghanistan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;