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)
Suggested facets: last_update (date)
These facets timed out: province_or_state, day
country_or_region 249
- 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
- Palau 1,073
- Summer Olympics 2020 1,073
- Thailand 1,073
- Tonga 1,073
- Tuvalu 1,073
- Winter Olympics 2022 1,073
- Singapore 1,072
- Vietnam 1,071
- Nepal 1,070
- Cambodia 1,068
- Sri Lanka 1,068
- Finland 1,066
- Philippines 1,066
- United Arab Emirates 1,066
- Egypt 1,050
- Iran 1,044
- Israel 1,043
- Lebanon 1,043
- Iraq 1,041
- Afghanistan 1,040
- Bahrain 1,040
- Kuwait 1,040
- Oman 1,040
- Algeria 1,039
- Austria 1,039
- Croatia 1,039
- Switzerland 1,039
- Georgia 1,038
- Greece 1,038
- North Macedonia 1,038
- Norway 1,038
- Romania 1,038
- Estonia 1,037
- San Marino 1,037
- Belarus 1,036
- Iceland 1,036
- Lithuania 1,036
- Nigeria 1,036
- Azerbaijan 1,035
- Ireland 1,035
- Luxembourg 1,035
- Monaco 1,035
- Qatar 1,035
- Armenia 1,034
- Dominican Republic 1,034
- Ecuador 1,034
- Andorra 1,033
- Indonesia 1,033
- Latvia 1,033
- Morocco 1,033
- Portugal 1,033
- Saudi Arabia 1,033
- Senegal 1,033
- Argentina 1,032
- Jordan 1,032
- Hungary 1,031
- Liechtenstein 1,031
- Poland 1,031
- Tunisia 1,031
- Bosnia and Herzegovina 1,030
- Slovenia 1,030
- South Africa 1,030
- Bhutan 1,029
- Cameroon 1,029
- Costa Rica 1,029
- Serbia 1,029
- Slovakia 1,029
- Togo 1,029
- Malta 1,028
- Bangladesh 1,027
- Bulgaria 1,027
- Maldives 1,027
- Paraguay 1,027
- Albania 1,026
- Brunei 1,026
- Cyprus 1,026
- Moldova 1,026
- Burkina Faso 1,025
- Holy See 1,025
- Mongolia 1,025
- Panama 1,025
- Bolivia 1,024
- Congo (Kinshasa) 1,024
- Cote d'Ivoire 1,024
- Czechia 1,024
- Honduras 1,024
- Jamaica 1,024
- Korea, South 1,024
- Taiwan* 1,024
- Turkey 1,024
- Cuba 1,023
- Guyana 1,023
- Antigua and Barbuda 1,022
- Ethiopia 1,022
- Guinea 1,022
- Kazakhstan 1,022
- Kenya 1,022
- Sudan 1,022
- Eswatini 1,021
- Gabon 1,021
- Ghana 1,021
- Guatemala 1,021
- Mauritania 1,021
- Namibia 1,021
- Rwanda 1,021
- Saint Lucia 1,021
- Saint Vincent and the Grenadines 1,021
- Seychelles 1,021
- Suriname 1,021
- Trinidad and Tobago 1,021
- Uruguay 1,021
- Venezuela 1,021
- Central African Republic 1,020
- Congo (Brazzaville) 1,020
- Equatorial Guinea 1,020
- Uzbekistan 1,020
- Benin 1,019
- Liberia 1,019
- Somalia 1,019
- Tanzania 1,019
- Barbados 1,018
- Montenegro 1,018
- Djibouti 1,017
- Kyrgyzstan 1,017
- Mauritius 1,017
- Zambia 1,017
- Chad 1,016
- El Salvador 1,016
- Fiji 1,016
- Kosovo 1,016
- Nicaragua 1,016
- Angola 1,015
- Cabo Verde 1,015
- Haiti 1,015
- Madagascar 1,015
- Niger 1,015
- Papua New Guinea 1,015
- Zimbabwe 1,015
- Eritrea 1,014
- Uganda 1,014
- Bahamas 1,013
- Dominica 1,013
- Gambia 1,013
- Grenada 1,013
- Mozambique 1,013
- Samoa 1,013
- Syria 1,013
- Timor-Leste 1,013
- Belize 1,012
- Laos 1,011
- Libya 1,011
- Diamond Princess 1,010
- Guinea-Bissau 1,010
- Mali 1,010
- Saint Kitts and Nevis 1,010
- West Bank and Gaza 1,009
- Burma 1,008
- MS Zaandam 1,007
- Botswana 1,005
- Burundi 1,004
- Sierra Leone 1,004
- Malawi 1,002
- South Sudan 999
- Sao Tome and Principe 998
- Yemen 994
- Comoros 974
- Tajikistan 974
- Lesotho 961
- Solomon Islands 809
- Marshall Islands 793
- Vanuatu 780
- Micronesia 708
- Hong Kong 48
- Macau 48
- South Korea 48
- Taiwan 48
- Others 33
- Martinique 15
- French Guiana 14
- Cruise Ship 13
- Reunion 11
- Czech Republic 10
- Guadeloupe 9
- Guernsey 8
- Jersey 8
- Aruba 7
- Faroe Islands 7
- Gibraltar 7
- Saint Barthelemy 7
- occupied Palestinian territory 7
- Greenland 6
- Guam 6
- Mayotte 6
- Puerto Rico 6
- Republic of the Congo 6
- The Bahamas 6
- Palestine 5
- The Gambia 5
- Gambia, The 4
- Vatican City 4
- Bahamas, The 3
- Cayman Islands 3
- Curacao 2
- Cape Verde 1
- Channel Islands 1
- East Timor 1
- Hong Kong SAR 1
- Iran (Islamic Republic of) 1
- Ivory Coast 1
- Macao SAR 1
- North Ireland 1
- Republic of Ireland 1
- Republic of Korea 1
- Republic of Moldova 1
- Russian Federation 1
- Saint Martin 1
- St. Martin 1
- Taipei and environs 1
- Viet Nam 1
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;