johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: country_or_region
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
- …
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
372337 | 372337 | 2022-09-13 | Nicaragua | 14990 | 244 | 0 | 12.865416 | -85.207229 | 2022-09-14 04:20:44 | Nicaragua | ||||
372338 | 372338 | 2022-09-13 | Niger | 9385 | 312 | 0 | 17.607789 | 8.081666 | 2022-09-14 04:20:44 | Niger | ||||
372339 | 372339 | 2022-09-13 | Nigeria | 264617 | 3155 | 0 | 9.082 | 8.6753 | 2022-09-14 04:20:44 | Nigeria | ||||
372340 | 372340 | 2022-09-13 | North Macedonia | 341748 | 9515 | 0 | 41.6086 | 21.7453 | 2022-09-14 04:20:44 | North Macedonia | ||||
372341 | 372341 | 2022-09-13 | Norway | 1461206 | 4004 | 0 | 60.472 | 8.4689 | 2022-09-14 04:20:44 | Norway | ||||
372342 | 372342 | 2022-09-13 | Oman | 397993 | 4628 | 0 | 21.512583 | 55.923255 | 2022-09-14 04:20:44 | Oman | ||||
372350 | 372350 | 2022-09-13 | Palau | 5430 | 6 | 0 | 7.515 | 134.5825 | 2022-09-14 04:20:44 | Palau | ||||
372351 | 372351 | 2022-09-13 | Panama | 984234 | 8487 | 0 | 8.538 | -80.7821 | 2022-09-14 04:20:44 | Panama | ||||
372352 | 372352 | 2022-09-13 | Papua New Guinea | 44915 | 664 | 0 | -6.314993 | 143.95555 | 2022-09-14 04:20:44 | Papua New Guinea | ||||
372353 | 372353 | 2022-09-13 | Paraguay | 715806 | 19530 | 0 | -23.4425 | -58.4438 | 2022-09-14 04:20:44 | Paraguay | ||||
372380 | 372380 | 2022-09-13 | Philippines | 3909772 | 62382 | 0 | 12.879721 | 121.774017 | 2022-09-14 04:20:44 | Philippines | ||||
372381 | 372381 | 2022-09-13 | Poland | 6221132 | 117280 | 0 | 51.9194 | 19.1451 | 2022-09-14 04:20:44 | Poland | ||||
372382 | 372382 | 2022-09-13 | Portugal | 5448713 | 24931 | 0 | 39.3999 | -8.2245 | 2022-09-14 04:20:44 | Portugal | ||||
372383 | 372383 | 2022-09-13 | Qatar | 437709 | 682 | 0 | 25.3548 | 51.1839 | 2022-09-14 04:20:44 | Qatar | ||||
372384 | 372384 | 2022-09-13 | Romania | 3244886 | 66874 | 0 | 45.9432 | 24.9668 | 2022-09-14 04:20:44 | Romania | ||||
372468 | 372468 | 2022-09-13 | Rwanda | 132475 | 1466 | 0 | -1.9403 | 29.8739 | 2022-09-14 04:20:44 | Rwanda | ||||
372469 | 372469 | 2022-09-13 | Saint Kitts and Nevis | 6532 | 46 | 0 | 17.357822 | -62.782998 | 2022-09-14 04:20:44 | Saint Kitts and Nevis | ||||
372470 | 372470 | 2022-09-13 | Saint Lucia | 28894 | 391 | 0 | 13.9094 | -60.9789 | 2022-09-14 04:20:44 | Saint Lucia | ||||
372471 | 372471 | 2022-09-13 | Saint Vincent and the Grenadines | 9446 | 116 | 0 | 12.9843 | -61.2872 | 2022-09-14 04:20:44 | Saint Vincent and the Grenadines | ||||
372472 | 372472 | 2022-09-13 | Samoa | 15889 | 29 | 0 | -13.759 | -172.1046 | 2022-09-14 04:20:44 | Samoa | ||||
372473 | 372473 | 2022-09-13 | San Marino | 20533 | 118 | 0 | 43.9424 | 12.4578 | 2022-09-14 04:20:44 | San Marino | ||||
372474 | 372474 | 2022-09-13 | Sao Tome and Principe | 6193 | 76 | 0 | 0.1864 | 6.6131 | 2022-09-14 04:20:44 | Sao Tome and Principe | ||||
372475 | 372475 | 2022-09-13 | Saudi Arabia | 814722 | 9320 | 0 | 23.885942 | 45.079162 | 2022-09-14 04:20:44 | Saudi Arabia | ||||
372476 | 372476 | 2022-09-13 | Senegal | 88224 | 1968 | 0 | 14.4974 | -14.4524 | 2022-09-14 04:20:44 | Senegal | ||||
372477 | 372477 | 2022-09-13 | Serbia | 2321849 | 16837 | 0 | 44.0165 | 21.0059 | 2022-09-14 04:20:44 | Serbia | ||||
372478 | 372478 | 2022-09-13 | Seychelles | 46358 | 169 | 0 | -4.6796 | 55.492 | 2022-09-14 04:20:44 | Seychelles | ||||
372479 | 372479 | 2022-09-13 | Sierra Leone | 7749 | 126 | 0 | 8.460555 | -11.779889 | 2022-09-14 04:20:44 | Sierra Leone | ||||
372480 | 372480 | 2022-09-13 | Singapore | 1864742 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-14 04:20:44 | Singapore | ||||
372481 | 372481 | 2022-09-13 | Slovakia | 2580748 | 20236 | 0 | 48.669 | 19.699 | 2022-09-10 23:21:06 | Slovakia | ||||
372482 | 372482 | 2022-09-13 | Slovenia | 1146802 | 6795 | 0 | 46.1512 | 14.9955 | 2022-09-14 04:20:44 | Slovenia | ||||
372483 | 372483 | 2022-09-13 | Solomon Islands | 21544 | 153 | 0 | -9.6457 | 160.1562 | 2022-09-14 04:20:44 | Solomon Islands | ||||
372484 | 372484 | 2022-09-13 | Somalia | 27197 | 1361 | 0 | 5.152149 | 46.199616 | 2022-09-14 04:20:44 | Somalia | ||||
372485 | 372485 | 2022-09-13 | South Africa | 4014724 | 102129 | 0 | -30.5595 | 22.9375 | 2022-09-14 04:20:44 | South Africa | ||||
372486 | 372486 | 2022-09-13 | South Sudan | 17823 | 138 | 0 | 6.877 | 31.307 | 2022-09-14 04:20:44 | South Sudan | ||||
372507 | 372507 | 2022-09-13 | Sri Lanka | 670501 | 16736 | 0 | 7.873054 | 80.771797 | 2022-09-14 04:20:44 | Sri Lanka | ||||
372508 | 372508 | 2022-09-13 | Sudan | 63275 | 4961 | 0 | 12.8628 | 30.2176 | 2022-09-14 04:20:44 | Sudan | ||||
372509 | 372509 | 2022-09-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-14 04:20:44 | Summer Olympics 2020 | ||||
372510 | 372510 | 2022-09-13 | Suriname | 81078 | 1384 | 0 | 3.9193 | -56.0278 | 2022-09-14 04:20:44 | Suriname | ||||
372532 | 372532 | 2022-09-13 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-14 04:20:44 | Switzerland | ||||
372533 | 372533 | 2022-09-13 | Syria | 57189 | 3163 | 0 | 34.802075 | 38.996815 | 2022-09-14 04:20:44 | Syria | ||||
372534 | 372534 | 2022-09-13 | Taiwan* | 5754683 | 10329 | 0 | 23.7 | 121.0 | 2022-09-14 04:20:44 | Taiwan* | ||||
372535 | 372535 | 2022-09-13 | Tajikistan | 17786 | 125 | 0 | 38.861 | 71.2761 | 2022-09-14 04:20:44 | Tajikistan | ||||
372536 | 372536 | 2022-09-13 | Tanzania | 39168 | 845 | 0 | -6.369028 | 34.888822 | 2022-09-14 04:20:44 | Tanzania | ||||
372537 | 372537 | 2022-09-13 | Thailand | 4670184 | 32578 | 0 | 15.870032 | 100.992541 | 2022-09-14 04:20:44 | Thailand | ||||
372538 | 372538 | 2022-09-13 | Timor-Leste | 23227 | 138 | 0 | -8.874217 | 125.727539 | 2022-09-14 04:20:44 | Timor-Leste | ||||
372539 | 372539 | 2022-09-13 | Togo | 38657 | 284 | 0 | 8.6195 | 0.8248 | 2022-09-14 04:20:44 | Togo | ||||
372540 | 372540 | 2022-09-13 | Tonga | 16182 | 12 | 0 | -21.179 | -175.1982 | 2022-09-14 04:20:44 | Tonga | ||||
372541 | 372541 | 2022-09-13 | Trinidad and Tobago | 181567 | 4176 | 0 | 10.6918 | -61.2225 | 2022-09-14 04:20:44 | Trinidad and Tobago | ||||
372542 | 372542 | 2022-09-13 | Tunisia | 1145163 | 29243 | 0 | 33.886917 | 9.537499 | 2022-09-14 04:20:44 | Tunisia | ||||
372543 | 372543 | 2022-09-13 | Turkey | 16852382 | 101068 | 0 | 38.9637 | 35.2433 | 2022-09-14 04:20:44 | Turkey | ||||
372544 | 372544 | 2022-09-13 | Tuvalu | 20 | 0 | 0 | -7.1095 | 177.6493 | 2022-09-14 04:20:44 | Tuvalu | ||||
375824 | 375824 | 2022-09-13 | Uganda | 169396 | 3628 | 0 | 1.373333 | 32.290275 | 2022-09-14 04:20:44 | Uganda | ||||
375853 | 375853 | 2022-09-13 | United Arab Emirates | 1020789 | 2342 | 0 | 23.424076 | 53.847818 | 2022-09-14 04:20:44 | United Arab Emirates | ||||
375873 | 375873 | 2022-09-13 | Uruguay | 982846 | 7462 | 0 | -32.5228 | -55.7658 | 2022-09-14 04:20:44 | Uruguay | ||||
375874 | 375874 | 2022-09-13 | Uzbekistan | 243981 | 1637 | 0 | 41.377491 | 64.585262 | 2022-09-14 04:20:44 | Uzbekistan | ||||
375875 | 375875 | 2022-09-13 | Vanuatu | 11921 | 14 | 0 | -15.3767 | 166.9592 | 2022-09-14 04:20:44 | Vanuatu | ||||
375876 | 375876 | 2022-09-13 | Venezuela | 543832 | 5809 | 0 | 6.4238 | -66.5897 | 2022-09-14 04:20:44 | Venezuela | ||||
375877 | 375877 | 2022-09-13 | Vietnam | 11444927 | 43132 | 0 | 14.058324 | 108.277199 | 2022-09-14 04:20:44 | Vietnam | ||||
375878 | 375878 | 2022-09-13 | West Bank and Gaza | 702591 | 5706 | 0 | 31.9522 | 35.2332 | 2022-09-14 04:20:44 | West Bank and Gaza | ||||
375879 | 375879 | 2022-09-13 | Winter Olympics 2022 | 535 | 0 | 0 | 39.9042 | 116.4074 | 2022-09-14 04:20:44 | Winter Olympics 2022 | ||||
375880 | 375880 | 2022-09-13 | Yemen | 11932 | 2155 | 0 | 15.552727 | 48.516388 | 2022-09-14 04:20:44 | Yemen | ||||
375881 | 375881 | 2022-09-13 | Zambia | 333274 | 4017 | 0 | -13.133897 | 27.849332 | 2022-09-14 04:20:44 | Zambia | ||||
375882 | 375882 | 2022-09-13 | Zimbabwe | 256904 | 5596 | 0 | -19.015438 | 29.154857 | 2022-09-14 04:20:44 | Zimbabwe | ||||
375883 | 375883 | 2020-11-06 | Afghanistan | 41935 | 1554 | 34440 | 5941 | 33.93911 | 67.709953 | 2020-11-07 05:24:52 | Afghanistan | |||
375884 | 375884 | 2020-11-06 | Albania | 23210 | 549 | 11861 | 10800 | 41.1533 | 20.1683 | 2020-11-07 05:24:52 | Albania | |||
375885 | 375885 | 2020-11-06 | Algeria | 60800 | 2024 | 41510 | 17266 | 28.0339 | 1.6596 | 2020-11-07 05:24:52 | Algeria | |||
375886 | 375886 | 2020-11-06 | Andorra | 5135 | 75 | 3858 | 1202 | 42.5063 | 1.5218 | 2020-11-07 05:24:52 | Andorra | |||
375887 | 375887 | 2020-11-06 | Angola | 12223 | 300 | 5626 | 6297 | -11.2027 | 17.8739 | 2020-11-07 05:24:52 | Angola | |||
375888 | 375888 | 2020-11-06 | Antigua and Barbuda | 130 | 3 | 118 | 9 | 17.0608 | -61.7964 | 2020-11-07 05:24:52 | Antigua and Barbuda | |||
375889 | 375889 | 2020-11-06 | Argentina | 1228814 | 33136 | 1042237 | 153441 | -38.4161 | -63.6167 | 2020-11-07 05:24:52 | Argentina | |||
375890 | 375890 | 2020-11-06 | Armenia | 101773 | 1506 | 61782 | 38485 | 40.0691 | 45.0382 | 2020-11-07 05:24:52 | Armenia | |||
375899 | 375899 | 2020-11-06 | Austria | 135116 | 1719 | 83707 | 53932 | 47.5162 | 14.5501 | 2020-11-07 05:24:52 | Austria | |||
375900 | 375900 | 2020-11-06 | Azerbaijan | 62338 | 811 | 47270 | 14257 | 40.1431 | 47.5769 | 2020-11-07 05:24:52 | Azerbaijan | |||
375901 | 375901 | 2020-11-06 | Bahamas | 6882 | 150 | 4779 | 1953 | 25.025885 | -78.035889 | 2020-11-07 05:24:52 | Bahamas | |||
375902 | 375902 | 2020-11-06 | Bahrain | 83023 | 328 | 80526 | 2169 | 26.0275 | 50.55 | 2020-11-07 05:24:52 | Bahrain | |||
375903 | 375903 | 2020-11-06 | Bangladesh | 417475 | 6036 | 335027 | 76412 | 23.685 | 90.3563 | 2020-11-07 05:24:52 | Bangladesh | |||
375904 | 375904 | 2020-11-06 | Barbados | 242 | 7 | 228 | 7 | 13.1939 | -59.5432 | 2020-11-07 05:24:52 | Barbados | |||
375905 | 375905 | 2020-11-06 | Belarus | 104286 | 1001 | 89555 | 13730 | 53.7098 | 27.9534 | 2020-11-07 05:24:52 | Belarus | |||
375906 | 375906 | 2020-11-06 | Belgium | 488044 | 12708 | 28613 | 446723 | 50.8333 | 4.469936 | 2020-11-07 05:24:52 | Belgium | |||
375907 | 375907 | 2020-11-06 | Belize | 4016 | 67 | 2330 | 1619 | 17.1899 | -88.4976 | 2020-11-07 05:24:52 | Belize | |||
375908 | 375908 | 2020-11-06 | Benin | 2745 | 43 | 2466 | 236 | 9.3077 | 2.3158 | 2020-11-07 05:24:52 | Benin | |||
375909 | 375909 | 2020-11-06 | Bhutan | 358 | 0 | 338 | 20 | 27.5142 | 90.4336 | 2020-11-07 05:24:52 | Bhutan | |||
375910 | 375910 | 2020-11-06 | Bolivia | 142343 | 8781 | 113899 | 19663 | -16.2902 | -63.5887 | 2020-11-07 05:24:52 | Bolivia | |||
375911 | 375911 | 2020-11-06 | Bosnia and Herzegovina | 59427 | 1457 | 29970 | 28000 | 43.9159 | 17.6791 | 2020-11-07 05:24:52 | Bosnia and Herzegovina | |||
375912 | 375912 | 2020-11-06 | Botswana | 7835 | 27 | 5534 | 2274 | -22.3285 | 24.6849 | 2020-11-07 05:24:52 | Botswana | |||
375940 | 375940 | 2020-11-06 | Brunei | 148 | 3 | 144 | 1 | 4.5353 | 114.7277 | 2020-11-07 05:24:52 | Brunei | |||
375941 | 375941 | 2020-11-06 | Bulgaria | 72184 | 1576 | 23436 | 47172 | 42.7339 | 25.4858 | 2020-11-07 05:24:52 | Bulgaria | |||
375942 | 375942 | 2020-11-06 | Burkina Faso | 2562 | 67 | 2366 | 129 | 12.2383 | -1.5616 | 2020-11-07 05:24:52 | Burkina Faso | |||
375943 | 375943 | 2020-11-06 | Burma | 59277 | 1376 | 43277 | 14624 | 21.9162 | 95.956 | 2020-11-07 05:24:52 | Burma | |||
375944 | 375944 | 2020-11-06 | Burundi | 606 | 1 | 511 | 94 | -3.3731 | 29.9189 | 2020-11-07 05:24:52 | Burundi | |||
375945 | 375945 | 2020-11-06 | Cabo Verde | 9224 | 100 | 8363 | 761 | 16.5388 | -23.0418 | 2020-11-07 05:24:52 | Cabo Verde | |||
375946 | 375946 | 2020-11-06 | Cambodia | 294 | 0 | 288 | 6 | 11.55 | 104.9167 | 2020-11-07 05:24:52 | Cambodia | |||
375947 | 375947 | 2020-11-06 | Cameroon | 22103 | 429 | 21151 | 523 | 3.848 | 11.5021 | 2020-11-07 05:24:52 | Cameroon | |||
375963 | 375963 | 2020-11-06 | Central African Republic | 4866 | 62 | 1924 | 2880 | 6.6111 | 20.9394 | 2020-11-07 05:24:52 | Central African Republic | |||
375964 | 375964 | 2020-11-06 | Chad | 1538 | 99 | 1362 | 77 | 15.4542 | 18.7322 | 2020-11-07 05:24:52 | Chad | |||
376049 | 376049 | 2020-11-06 | Comoros | 557 | 7 | 525 | 25 | -11.6455 | 43.3333 | 2020-11-07 05:24:52 | Comoros | |||
376050 | 376050 | 2020-11-06 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-07 05:24:52 | Congo (Brazzaville) | |||
376051 | 376051 | 2020-11-06 | Congo (Kinshasa) | 11517 | 315 | 10838 | 364 | -4.0383 | 21.7587 | 2020-11-07 05:24:52 | Congo (Kinshasa) | |||
376052 | 376052 | 2020-11-06 | Costa Rica | 115417 | 1453 | 70421 | 43543 | 9.7489 | -83.7534 | 2020-11-07 05:24:52 | Costa Rica | |||
376053 | 376053 | 2020-11-06 | Cote d'Ivoire | 20801 | 126 | 20477 | 198 | 7.54 | -5.5471 | 2020-11-07 05:24:52 | Cote d'Ivoire |
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]);