daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 254,491
- Georgia 162,920
- Virginia 135,590
- Kentucky 121,675
- Missouri 117,101
- Kansas 105,758
- Illinois 104,685
- North Carolina 102,044
- Iowa 100,603
- Tennessee 98,183
- Indiana 94,151
- Nebraska 92,863
- Ohio 90,027
- Minnesota 88,465
- Michigan 87,758
- Mississippi 83,968
- Oklahoma 79,376
- Arkansas 76,709
- Wisconsin 73,611
- Puerto Rico 71,726
- Alabama 69,765
- Pennsylvania 68,850
- Florida 68,836
- Louisiana 66,723
- South Dakota 66,362
- Colorado 66,146
- New York 64,046
- California 59,941
- West Virginia 56,193
- Montana 54,982
- …
country_or_region >30
- US 3,284,537
- Russia 78,307
- Japan 46,430
- China 34,865
- India 34,605
- Colombia 32,189
- Mexico 31,389
- Ukraine 26,597
- Brazil 25,862
- Peru 24,679
- Italy 20,264
- Sweden 19,824
- United Kingdom 19,730
- Spain 19,298
- Malaysia 18,241
- Germany 16,427
- Chile 16,296
- Canada 16,227
- Netherlands 15,842
- France 11,972
- Belgium 9,618
- Australia 8,420
- Pakistan 6,636
- New Zealand 3,188
- Denmark 3,077
- Mainland China 1,517
- Antarctica 1,073
- Kiribati 1,073
- Korea, North 1,073
- Nauru 1,073
- …
day | country_or_region ▼ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-11-26 | Afghanistan | 157171 | 7307 | 0 | 33.93911 | 67.709953 | 2021-11-27 04:22:45 | Afghanistan | ||||
2020-10-18 | Afghanistan | 40286 | 1496 | 33614 | 5176 | 33.93911 | 67.709953 | 2020-10-19 04:24:16 | Afghanistan | |||
2020-12-29 | Afghanistan | 52147 | 2182 | 41543 | 8422 | 33.93911 | 67.709953 | 2020-12-30 05:22:34 | Afghanistan | |||
2021-10-23 | Afghanistan | 155940 | 7253 | 0 | 33.93911 | 67.709953 | 2021-10-24 04:21:22 | Afghanistan | ||||
2021-01-12 | Afghanistan | 53584 | 2301 | 44608 | 6675 | 33.93911 | 67.709953 | 2021-01-13 05:22:15 | Afghanistan | |||
2021-07-08 | Afghanistan | 130113 | 5477 | 78521 | 46115 | 33.93911 | 67.709953 | 2021-07-09 04:21:21 | Afghanistan | |||
2021-12-13 | Afghanistan | 157648 | 7328 | 0 | 33.93911 | 67.709953 | 2021-12-14 04:22:38 | Afghanistan | ||||
2020-10-15 | Afghanistan | 40112 | 1485 | 33447 | 5180 | 33.93911 | 67.709953 | 2020-10-16 04:24:01 | Afghanistan | |||
2021-02-04 | Afghanistan | 55231 | 2407 | 47995 | 4829 | 33.93911 | 67.709953 | 2021-02-05 05:22:38 | Afghanistan | |||
2022-10-24 | Afghanistan | 202199 | 7818 | 0 | 33.93911 | 67.709953 | 2022-10-25 04:21:53 | Afghanistan | ||||
2021-12-22 | Afghanistan | 157841 | 7341 | 0 | 33.93911 | 67.709953 | 2021-12-23 04:21:21 | Afghanistan | ||||
2020-06-01 | Afghanistan | 15836 | 269 | 1428 | 14139 | 33.93911 | 67.709953 | 2020-06-02 02:33:08 | Afghanistan | |||
2020-03-27 | Afghanistan | 91 | 2 | 2 | 87 | 33.93911 | 67.709953 | 2020-03-27 23:23:03 | Afghanistan | |||
2021-09-20 | Afghanistan | 154585 | 7199 | 0 | 33.93911 | 67.709953 | 2021-09-21 04:21:26 | Afghanistan | ||||
2020-09-05 | Afghanistan | 38390 | 1413 | 30082 | 6895 | 33.93911 | 67.709953 | 2020-09-06 04:28:33 | Afghanistan | |||
2020-10-09 | Afghanistan | 39779 | 1476 | 33058 | 5245 | 33.93911 | 67.709953 | 2020-10-10 04:23:57 | Afghanistan | |||
2020-11-19 | Afghanistan | 43851 | 1645 | 35350 | 6856 | 33.93911 | 67.709953 | 2020-11-20 05:26:28 | Afghanistan | |||
2021-06-06 | Afghanistan | 79224 | 3145 | 58622 | 17457 | 33.93911 | 67.709953 | 2021-06-07 04:22:51 | Afghanistan | |||
2021-07-09 | Afghanistan | 131586 | 5561 | 79446 | 46579 | 33.93911 | 67.709953 | 2021-07-10 04:21:25 | Afghanistan | |||
2022-12-02 | Afghanistan | 206133 | 7834 | 0 | 33.93911 | 67.709953 | 2022-12-03 04:21:02 | Afghanistan | ||||
2020-08-17 | Afghanistan | 37682 | 1379 | 27166 | 9137 | 33.93911 | 67.709953 | 2020-08-18 04:27:56 | Afghanistan | |||
2020-07-22 | Afghanistan | 35813 | 1194 | 23924 | 10695 | 33.93911 | 67.709953 | 2020-07-23 05:15:04 | Afghanistan | |||
2020-12-12 | Afghanistan | 48826 | 1949 | 38200 | 8677 | 33.93911 | 67.709953 | 2020-12-13 05:27:20 | Afghanistan | |||
2022-11-02 | Afghanistan | 203265 | 7823 | 0 | 33.93911 | 67.709953 | 2022-11-03 04:22:05 | Afghanistan | ||||
2022-09-30 | Afghanistan | 199188 | 7800 | 0 | 33.93911 | 67.709953 | 2022-10-01 04:23:01 | Afghanistan | ||||
2020-04-15 | Afghanistan | 770 | 25 | 43 | 702 | 33.93911 | 67.709953 | 2020-04-15 22:56:32 | Afghanistan | |||
2020-12-11 | Afghanistan | 48753 | 1939 | 38141 | 8673 | 33.93911 | 67.709953 | 2020-12-12 05:26:19 | Afghanistan | |||
2020-11-12 | Afghanistan | 42609 | 1581 | 35024 | 6004 | 33.93911 | 67.709953 | 2020-11-13 05:25:30 | Afghanistan | |||
2022-12-11 | Afghanistan | 206603 | 7839 | 0 | 33.93911 | 67.709953 | 2022-12-12 04:21:01 | Afghanistan | ||||
2020-05-24 | Afghanistan | 10668 | 222 | 1075 | 9371 | 33.93911 | 67.709953 | 2020-05-25 02:32:44 | Afghanistan | |||
2022-03-27 | Afghanistan | 177520 | 7662 | 0 | 33.93911 | 67.709953 | 2022-03-28 04:20:33 | Afghanistan | ||||
2022-08-05 | Afghanistan | 187037 | 7752 | 0 | 33.93911 | 67.709953 | 2022-08-06 04:20:56 | Afghanistan | ||||
2020-07-07 | Afghanistan | 33470 | 924 | 20179 | 12367 | 33.93911 | 67.709953 | 2020-07-08 05:33:48 | Afghanistan | |||
2021-04-26 | Afghanistan | 59015 | 2592 | 52520 | 3903 | 33.93911 | 67.709953 | 2021-04-27 04:20:52 | Afghanistan | |||
2020-11-05 | Afghanistan | 41814 | 1548 | 34440 | 5826 | 33.93911 | 67.709953 | 2020-11-06 05:24:55 | Afghanistan | |||
2022-07-24 | Afghanistan | 184587 | 7738 | 0 | 33.93911 | 67.709953 | 2022-07-25 04:20:51 | Afghanistan | ||||
2022-07-22 | Afghanistan | 184360 | 7738 | 0 | 33.93911 | 67.709953 | 2022-07-23 04:20:53 | Afghanistan | ||||
2021-11-24 | Afghanistan | 157032 | 7306 | 0 | 33.93911 | 67.709953 | 2021-11-25 04:22:33 | Afghanistan | ||||
2021-01-19 | Afghanistan | 54141 | 2346 | 46554 | 5241 | 33.93911 | 67.709953 | 2021-01-20 05:21:54 | Afghanistan | |||
2022-10-29 | Afghanistan | 202834 | 7821 | 0 | 33.93911 | 67.709953 | 2022-10-30 04:22:14 | Afghanistan | ||||
2020-03-26 | Afghanistan | 80 | 2 | 2 | 76 | 33.93911 | 67.709953 | 2020-03-26 23:48:18 | Afghanistan | |||
2022-03-08 | Afghanistan | 175353 | 7630 | 0 | 33.93911 | 67.709953 | 2022-03-09 04:20:59 | Afghanistan | ||||
2020-11-26 | Afghanistan | 45490 | 1725 | 36232 | 7533 | 33.93911 | 67.709953 | 2020-11-27 05:26:53 | Afghanistan | |||
2020-12-21 | Afghanistan | 50678 | 2074 | 39508 | 9096 | 33.93911 | 67.709953 | 2020-12-22 05:22:33 | Afghanistan | |||
2020-04-16 | Afghanistan | 794 | 29 | 54 | 711 | 33.93911 | 67.709953 | 2020-04-16 23:30:31 | Afghanistan | |||
2021-10-16 | Afghanistan | 155739 | 7238 | 0 | 33.93911 | 67.709953 | 2021-10-17 04:21:29 | Afghanistan | ||||
2022-06-25 | Afghanistan | 182072 | 7717 | 0 | 33.93911 | 67.709953 | 2022-06-26 04:21:02 | Afghanistan | ||||
2022-02-28 | Afghanistan | 173659 | 7598 | 0 | 33.93911 | 67.709953 | 2022-03-01 04:21:09 | Afghanistan | ||||
2022-06-14 | Afghanistan | 181178 | 7710 | 0 | 33.93911 | 67.709953 | 2022-06-15 04:20:54 | Afghanistan | ||||
2022-03-12 | Afghanistan | 176039 | 7641 | 0 | 33.93911 | 67.709953 | 2022-03-13 04:20:49 | Afghanistan | ||||
2021-04-25 | Afghanistan | 58843 | 2582 | 52489 | 3772 | 33.93911 | 67.709953 | 2021-04-26 04:21:04 | Afghanistan | |||
2022-07-19 | Afghanistan | 183908 | 7736 | 0 | 33.93911 | 67.709953 | 2022-07-20 04:20:59 | Afghanistan | ||||
2022-09-09 | Afghanistan | 195471 | 7786 | 0 | 33.93911 | 67.709953 | 2022-09-10 04:21:10 | Afghanistan | ||||
2020-09-29 | Afghanistan | 39340 | 1462 | 32746 | 5132 | 33.93911 | 67.709953 | 2020-09-30 04:23:33 | Afghanistan | |||
2022-06-01 | Afghanistan | 180419 | 7707 | 0 | 33.93911 | 67.709953 | 2022-06-02 05:20:39 | Afghanistan | ||||
2021-02-06 | Afghanistan | 55330 | 2408 | 48027 | 4895 | 33.93911 | 67.709953 | 2021-02-07 05:23:00 | Afghanistan | |||
2022-02-01 | Afghanistan | 163555 | 7417 | 0 | 33.93911 | 67.709953 | 2022-02-02 04:21:09 | Afghanistan | ||||
2021-04-17 | Afghanistan | 57721 | 2539 | 52116 | 3066 | 33.93911 | 67.709953 | 2021-04-18 04:20:41 | Afghanistan | |||
2021-10-04 | Afghanistan | 155287 | 7212 | 0 | 33.93911 | 67.709953 | 2021-10-05 04:21:27 | Afghanistan | ||||
2022-08-16 | Afghanistan | 189477 | 7759 | 0 | 33.93911 | 67.709953 | 2022-08-17 04:20:59 | Afghanistan | ||||
2020-05-23 | Afghanistan | 9952 | 215 | 1040 | 8697 | 33.93911 | 67.709953 | 2020-05-24 02:32:43 | Afghanistan | |||
2021-03-01 | Afghanistan | 55733 | 2444 | 49344 | 3945 | 33.93911 | 67.709953 | 2021-03-02 05:23:30 | Afghanistan | |||
2020-07-09 | Afghanistan | 33739 | 941 | 20847 | 11951 | 33.93911 | 67.709953 | 2020-07-10 04:34:24 | Afghanistan | |||
2020-12-06 | Afghanistan | 47641 | 1865 | 37685 | 8091 | 33.93911 | 67.709953 | 2020-12-07 05:26:14 | Afghanistan | |||
2020-12-30 | Afghanistan | 52330 | 2189 | 41612 | 8529 | 33.93911 | 67.709953 | 2020-12-31 05:22:49 | Afghanistan | |||
2021-11-21 | Afghanistan | 156896 | 7303 | 0 | 33.93911 | 67.709953 | 2021-11-22 04:22:20 | Afghanistan | ||||
2022-12-24 | Afghanistan | 207310 | 7845 | 0 | 33.93911 | 67.709953 | 2022-12-25 04:21:04 | Afghanistan | ||||
2022-11-04 | Afghanistan | 203497 | 7825 | 0 | 33.93911 | 67.709953 | 2022-11-05 04:21:52 | Afghanistan | ||||
2020-10-17 | Afghanistan | 40227 | 1492 | 33561 | 5174 | 33.93911 | 67.709953 | 2020-10-18 04:24:25 | Afghanistan | |||
2021-12-06 | Afghanistan | 157499 | 7316 | 0 | 33.93911 | 67.709953 | 2021-12-07 04:22:34 | Afghanistan | ||||
2020-12-15 | Afghanistan | 49484 | 1975 | 38336 | 9173 | 33.93911 | 67.709953 | 2020-12-16 05:28:04 | Afghanistan | |||
2020-05-26 | Afghanistan | 11917 | 224 | 1128 | 10565 | 33.93911 | 67.709953 | 2020-05-27 02:32:31 | Afghanistan | |||
2020-10-07 | Afghanistan | 39634 | 1473 | 33045 | 5116 | 33.93911 | 67.709953 | 2020-10-08 04:23:56 | Afghanistan | |||
2020-09-30 | Afghanistan | 39354 | 1462 | 32789 | 5103 | 33.93911 | 67.709953 | 2020-10-01 04:23:42 | Afghanistan | |||
2022-11-06 | Afghanistan | 203681 | 7826 | 0 | 33.93911 | 67.709953 | 2022-11-07 04:21:26 | Afghanistan | ||||
2020-10-23 | Afghanistan | 40626 | 1505 | 34010 | 5111 | 33.93911 | 67.709953 | 2020-10-24 04:24:46 | Afghanistan | |||
2022-02-23 | Afghanistan | 172901 | 7574 | 0 | 33.93911 | 67.709953 | 2022-02-24 04:21:14 | Afghanistan | ||||
2021-01-04 | Afghanistan | 52909 | 2230 | 42530 | 8149 | 33.93911 | 67.709953 | 2021-01-05 05:21:49 | Afghanistan | |||
2022-07-28 | Afghanistan | 185393 | 7743 | 0 | 33.93911 | 67.709953 | 2022-07-29 04:20:45 | Afghanistan | ||||
2022-08-07 | Afghanistan | 187442 | 7752 | 0 | 33.93911 | 67.709953 | 2022-08-08 04:21:08 | Afghanistan | ||||
2022-12-28 | Afghanistan | 207493 | 7846 | 0 | 33.93911 | 67.709953 | 2022-12-29 04:21:01 | Afghanistan | ||||
2021-12-09 | Afghanistan | 157585 | 7321 | 0 | 33.93911 | 67.709953 | 2021-12-10 04:22:28 | Afghanistan | ||||
2021-05-14 | Afghanistan | 63355 | 2730 | 54634 | 5991 | 33.93911 | 67.709953 | 2021-05-15 04:20:58 | Afghanistan | |||
2022-08-09 | Afghanistan | 187966 | 7753 | 0 | 33.93911 | 67.709953 | 2022-08-10 04:20:57 | Afghanistan | ||||
2021-03-03 | Afghanistan | 55770 | 2446 | 49359 | 3965 | 33.93911 | 67.709953 | 2021-03-04 05:24:24 | Afghanistan | |||
2021-01-20 | Afghanistan | 54278 | 2354 | 46759 | 5165 | 33.93911 | 67.709953 | 2021-01-21 05:22:01 | Afghanistan | |||
2022-08-03 | Afghanistan | 186393 | 7752 | 0 | 33.93911 | 67.709953 | 2022-08-04 04:20:58 | Afghanistan | ||||
2020-05-25 | Afghanistan | 11180 | 223 | 1097 | 9860 | 33.93911 | 67.709953 | 2020-05-26 02:32:35 | Afghanistan | |||
2020-09-02 | Afghanistan | 38329 | 1413 | 29315 | 7601 | 33.93911 | 67.709953 | 2020-09-03 04:28:22 | Afghanistan | |||
2022-05-21 | Afghanistan | 179674 | 7697 | 0 | 33.93911 | 67.709953 | 2022-05-22 04:20:52 | Afghanistan | ||||
2022-01-11 | Afghanistan | 158471 | 7374 | 0 | 33.93911 | 67.709953 | 2022-01-12 04:21:44 | Afghanistan | ||||
2021-08-06 | Afghanistan | 149810 | 6879 | 0 | 33.93911 | 67.709953 | 2021-08-07 04:21:30 | Afghanistan | ||||
2020-09-17 | Afghanistan | 38958 | 1440 | 32505 | 5013 | 33.93911 | 67.709953 | 2020-09-18 05:05:00 | Afghanistan | |||
2021-06-18 | Afghanistan | 98734 | 3934 | 63426 | 31374 | 33.93911 | 67.709953 | 2021-06-19 04:22:33 | Afghanistan | |||
2020-03-25 | Afghanistan | 74 | 1 | 2 | 71 | 33.93911 | 67.709953 | 2020-03-25 23:33:04 | Afghanistan | |||
2020-06-26 | Afghanistan | 30346 | 684 | 10306 | 19356 | 33.93911 | 67.709953 | 2020-06-27 04:33:35 | Afghanistan | |||
2021-01-01 | Afghanistan | 52513 | 2201 | 41727 | 8585 | 33.93911 | 67.709953 | 2021-01-02 05:22:33 | Afghanistan | |||
2022-01-23 | Afghanistan | 159649 | 7393 | 0 | 33.93911 | 67.709953 | 2022-01-24 04:21:12 | Afghanistan | ||||
2021-12-01 | Afghanistan | 157359 | 7309 | 0 | 33.93911 | 67.709953 | 2021-12-02 04:22:37 | Afghanistan | ||||
2022-12-12 | Afghanistan | 206702 | 7840 | 0 | 33.93911 | 67.709953 | 2022-12-13 04:21:01 | Afghanistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;