johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
821 rows where active = 224 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 715
- Japan 15
- Ukraine 7
- Colombia 6
- Russia 5
- Chad 4
- Chile 4
- Germany 4
- India 4
- Italy 4
- Mexico 4
- Sao Tome and Principe 4
- Gambia 3
- Latvia 3
- Niger 3
- Sweden 3
- Congo (Brazzaville) 2
- Liechtenstein 2
- Malaysia 2
- Monaco 2
- Saint Vincent and the Grenadines 2
- Albania 1
- Bahamas 1
- Bhutan 1
- Brazil 1
- Cabo Verde 1
- Canada 1
- China 1
- Cote d'Ivoire 1
- Finland 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3907608 | 3907608 | 2021-07-31 | Ukraine | Mykolaiv Oblast | 70400 | 1865 | 68311 | 224 | 46.975 | 31.9946 | 2021-08-01 04:21:50 | Mykolaiv Oblast, Ukraine | ||
3296205 | 3296205 | 2021-07-30 | Japan | Nara | 8847 | 133 | 8490 | 224 | 34.317451 | 135.871644 | 2021-07-31 04:21:35 | Nara, Japan | ||
3295992 | 3295992 | 2021-07-30 | China | Jiangsu | 968 | 0 | 744 | 224 | 32.9711 | 119.455 | 2021-07-31 04:21:35 | Jiangsu, China | ||
1330275 | 1330275 | 2021-07-24 | Japan | Niigata | 3724 | 54 | 3446 | 224 | 37.521819 | 138.918647 | 2021-07-25 04:22:12 | Niigata, Japan | ||
829551 | 829551 | 2021-07-09 | India | Lakshadweep | 10002 | 49 | 9729 | 224 | 13.6999972 | 72.18333259999999 | 2021-07-10 04:21:25 | Lakshadweep, India | ||
1936078 | 1936078 | 2021-07-05 | Ukraine | Ternopil Oblast | 70057 | 1200 | 68633 | 224 | 49.5535 | 25.5948 | 2021-07-06 04:21:32 | Ternopil Oblast, Ukraine | ||
2590196 | 2590196 | 2021-06-27 | Russia | Chechen Republic | 12687 | 152 | 12311 | 224 | 43.39761470000001 | 45.6985005 | 2021-06-28 04:21:29 | Chechen Republic, Russia | ||
1736529 | 1736529 | 2021-06-12 | Japan | Kumamoto | 6402 | 109 | 6069 | 224 | 32.608154 | 130.74523100000002 | 2021-06-13 04:22:44 | Kumamoto, Japan | ||
523125 | 523125 | 2021-06-09 | Saint Vincent and the Grenadines | 2092 | 12 | 1856 | 224 | 12.9843 | -61.2872 | 2021-06-10 04:23:17 | Saint Vincent and the Grenadines | |||
3472565 | 3472565 | 2021-06-08 | Saint Vincent and the Grenadines | 2092 | 12 | 1856 | 224 | 12.9843 | -61.2872 | 2021-06-09 04:23:31 | Saint Vincent and the Grenadines | |||
3472519 | 3472519 | 2021-06-08 | Russia | Mari El Republic | 13685 | 258 | 13203 | 224 | 56.5767504 | 47.8817512 | 2021-06-09 04:23:31 | Mari El Republic, Russia | ||
3472306 | 3472306 | 2021-06-08 | Japan | Gunma | 7934 | 146 | 7564 | 224 | 36.504479 | 138.985605 | 2021-06-09 04:23:31 | Gunma, Japan | ||
2585759 | 2585759 | 2021-06-05 | Canada | Nova Scotia | 5651 | 88 | 5339 | 224 | 44.682 | -63.7443 | 2021-06-06 04:24:03 | Nova Scotia, Canada | ||
1188951 | 1188951 | 2021-05-31 | Russia | Karachay-Cherkess Republic | 20445 | 135 | 20086 | 224 | 43.7368326 | 41.7267991 | 2021-06-01 04:23:09 | Karachay-Cherkess Republic, Russia | ||
50810 | 50810 | 2021-05-29 | Japan | Kochi | 1423 | 20 | 1179 | 224 | 33.422519 | 133.367307 | 2021-05-30 04:20:55 | Kochi, Japan | ||
1806771 | 1806771 | 2021-05-27 | Japan | Nagasaki | 2857 | 63 | 2570 | 224 | 33.235712 | 129.608033 | 2021-05-28 04:20:36 | Nagasaki, Japan | ||
1412781 | 1412781 | 2021-05-24 | Bhutan | 1411 | 1 | 1186 | 224 | 27.5142 | 90.4336 | 2021-05-25 04:21:08 | Bhutan | |||
726356 | 726356 | 2021-05-22 | Colombia | San Andres y Providencia | 4905 | 75 | 4606 | 224 | 12.5567 | -81.7185 | 2021-05-23 04:20:51 | San Andres y Providencia, Colombia | ||
3054231 | 3054231 | 2021-05-13 | Japan | Tokushima | 1542 | 54 | 1264 | 224 | 33.919178 | 134.242091 | 2021-05-14 04:20:41 | Tokushima, Japan | ||
3113620 | 3113620 | 2021-05-06 | Niger | 5286 | 192 | 4870 | 224 | 17.607789 | 8.081666 | 2021-05-07 04:20:40 | Niger | |||
646087 | 646087 | 2021-05-05 | Niger | 5286 | 192 | 4870 | 224 | 17.607789 | 8.081666 | 2021-05-06 04:20:38 | Niger | |||
645888 | 645888 | 2021-05-05 | India | Andaman and Nicobar Islands | 6223 | 71 | 5928 | 224 | 11.225999 | 92.968178 | 2021-05-06 04:20:38 | Andaman and Nicobar Islands, India | ||
3675787 | 3675787 | 2021-05-04 | Niger | 5286 | 192 | 4870 | 224 | 17.607789 | 8.081666 | 2021-05-05 04:20:43 | Niger | |||
2824565 | 2824565 | 2021-05-01 | Chad | 4824 | 170 | 4430 | 224 | 15.4542 | 18.7322 | 2021-05-02 04:20:48 | Chad | |||
380063 | 380063 | 2021-04-30 | Cote d'Ivoire | 46036 | 286 | 45526 | 224 | 7.54 | -5.5471 | 2021-05-01 04:20:47 | Cote d'Ivoire | |||
379973 | 379973 | 2021-04-30 | Chad | 4817 | 170 | 4423 | 224 | 15.4542 | 18.7322 | 2021-05-01 04:20:47 | Chad | |||
1636096 | 1636096 | 2021-04-29 | Chad | 4810 | 170 | 4416 | 224 | 15.4542 | 18.7322 | 2021-04-30 04:21:03 | Chad | |||
2247404 | 2247404 | 2021-04-07 | Japan | Gunma | 5156 | 101 | 4831 | 224 | 36.504479 | 138.985605 | 2021-04-08 04:21:13 | Gunma, Japan | ||
241160 | 241160 | 2021-04-02 | Gambia | 5459 | 165 | 5070 | 224 | 13.4432 | -15.3101 | 2021-04-03 04:20:44 | Gambia | |||
1301957 | 1301957 | 2021-04-01 | Gambia | 5459 | 165 | 5070 | 224 | 13.4432 | -15.3101 | 2021-04-02 04:20:36 | Gambia | |||
637829 | 637829 | 2021-03-31 | Gambia | 5459 | 165 | 5070 | 224 | 13.4432 | -15.3101 | 2021-04-01 04:27:05 | Gambia | |||
3643591 | 3643591 | 2021-03-30 | Japan | Shizuoka | 5685 | 118 | 5343 | 224 | 34.916975 | 138.40778400000002 | 2021-03-31 04:26:25 | Shizuoka, Japan | ||
1798712 | 1798712 | 2021-03-23 | Mauritius | 812 | 10 | 592 | 224 | -20.348404 | 57.552152 | 2021-03-24 05:25:40 | Mauritius | |||
2055955 | 2055955 | 2021-03-15 | Mauritania | 17457 | 444 | 16789 | 224 | 21.0079 | -10.9408 | 2021-03-16 05:25:13 | Mauritania | |||
1732533 | 1732533 | 2021-03-14 | Japan | Shizuoka | 5395 | 102 | 5069 | 224 | 34.916975 | 138.40778400000002 | 2021-03-15 05:25:51 | Shizuoka, Japan | ||
1092684 | 1092684 | 2021-03-03 | US | Oregon | Grant | 41023 | 225 | 1 | 0 | 224 | 44.49024544 | -119.0068631 | 2021-03-04 05:24:24 | Grant, Oregon, US |
1091722 | 1091722 | 2021-03-03 | US | Michigan | Luce | 26095 | 225 | 1 | 0 | 224 | 46.47227431 | -85.54471223 | 2021-03-04 05:24:24 | Luce, Michigan, US |
1001646 | 1001646 | 2021-03-01 | US | Texas | Schleicher | 48413 | 177 | 6 | 0 | 224 | 30.89740592 | -100.5384842 | 2021-03-02 05:23:30 | Schleicher, Texas, US |
998477 | 998477 | 2021-03-01 | Japan | Shizuoka | 5151 | 93 | 4834 | 224 | 34.916975 | 138.40778400000002 | 2021-03-02 05:23:30 | Shizuoka, Japan | ||
2370704 | 2370704 | 2021-02-28 | US | Texas | Schleicher | 48413 | 177 | 6 | 0 | 224 | 30.89740592 | -100.5384842 | 2021-03-01 05:23:01 | Schleicher, Texas, US |
2367535 | 2367535 | 2021-02-28 | Japan | Shizuoka | 5141 | 93 | 4824 | 224 | 34.916975 | 138.40778400000002 | 2021-03-01 05:23:01 | Shizuoka, Japan | ||
3069206 | 3069206 | 2021-02-27 | US | Texas | Schleicher | 48413 | 177 | 6 | 0 | 224 | 30.89740592 | -100.5384842 | 2021-02-28 05:22:20 | Schleicher, Texas, US |
1861471 | 1861471 | 2021-02-25 | US | West Virginia | Calhoun | 54013 | 224 | 0 | 0 | 224 | 38.84315422 | -81.11934872 | 2021-02-26 05:22:40 | Calhoun, West Virginia, US |
283649 | 283649 | 2021-02-24 | US | West Virginia | Calhoun | 54013 | 224 | 0 | 0 | 224 | 38.84315422 | -81.11934872 | 2021-02-25 05:24:57 | Calhoun, West Virginia, US |
282187 | 282187 | 2021-02-24 | US | Montana | Mineral | 30061 | 224 | 0 | 0 | 224 | 47.15283992 | -115.0015239 | 2021-02-25 05:24:57 | Mineral, Montana, US |
280033 | 280033 | 2021-02-24 | Colombia | La Guajira | 16096 | 633 | 15239 | 224 | 11.3548 | -72.5205 | 2021-02-25 05:24:57 | La Guajira, Colombia | ||
3601807 | 3601807 | 2021-02-17 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-18 05:22:58 | Clay, Georgia, US |
3050942 | 3050942 | 2021-02-16 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-17 05:23:10 | Clay, Georgia, US |
3050215 | 3050215 | 2021-02-16 | Japan | Tochigi | 3981 | 60 | 3697 | 224 | 36.689912 | 139.819213 | 2021-02-17 05:23:10 | Tochigi, Japan | ||
1339041 | 1339041 | 2021-02-15 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-16 05:24:38 | Clay, Georgia, US |
2284192 | 2284192 | 2021-02-14 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-15 05:24:49 | Clay, Georgia, US |
2678592 | 2678592 | 2021-02-13 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-14 05:23:43 | Clay, Georgia, US |
2677935 | 2677935 | 2021-02-13 | Monaco | 1755 | 21 | 1510 | 224 | 43.7333 | 7.4167 | 2021-02-14 05:23:43 | Monaco | |||
3542202 | 3542202 | 2021-02-12 | US | Puerto Rico | Lajas | 72079 | 224 | 0 | 0 | 224 | 18.011661 | -67.040585 | 2021-02-13 05:22:12 | Lajas, Puerto Rico, US |
3540225 | 3540225 | 2021-02-12 | US | Georgia | Clay | 13061 | 227 | 3 | 0 | 224 | 31.62221166 | -84.97713865 | 2021-02-13 05:22:12 | Clay, Georgia, US |
2641037 | 2641037 | 2021-02-11 | US | Virginia | Craig | 51045 | 227 | 3 | 0 | 224 | 37.48133648 | -80.21072274 | 2021-02-12 05:23:29 | Craig, Virginia, US |
2637991 | 2637991 | 2021-02-11 | San Marino | 3213 | 71 | 2918 | 224 | 43.9424 | 12.4578 | 2021-02-12 05:23:29 | San Marino | |||
1529958 | 1529958 | 2021-02-09 | US | Nebraska | Franklin | 31061 | 227 | 3 | 0 | 224 | 40.17636348 | -98.95299073 | 2021-02-10 05:22:41 | Franklin, Nebraska, US |
615749 | 615749 | 2021-02-08 | US | Nebraska | Franklin | 31061 | 227 | 3 | 0 | 224 | 40.17636348 | -98.95299073 | 2021-02-09 05:23:30 | Franklin, Nebraska, US |
614612 | 614612 | 2021-02-08 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-09 05:23:30 | Custer, Idaho, US |
1674518 | 1674518 | 2021-02-07 | US | Nebraska | Franklin | 31061 | 227 | 3 | 0 | 224 | 40.17636348 | -98.95299073 | 2021-02-08 05:22:39 | Franklin, Nebraska, US |
1673381 | 1673381 | 2021-02-07 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-08 05:22:39 | Custer, Idaho, US |
975842 | 975842 | 2021-02-06 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-07 05:23:00 | Custer, Idaho, US |
1591314 | 1591314 | 2021-02-05 | US | Texas | Knox | 48275 | 233 | 13 | 0 | 224 | 33.60519951 | -99.7422906 | 2021-02-06 05:23:55 | Knox, Texas, US |
1589100 | 1589100 | 2021-02-05 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-06 05:23:55 | Custer, Idaho, US |
791307 | 791307 | 2021-02-04 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-05 05:22:38 | Custer, Idaho, US |
343413 | 343413 | 2021-02-03 | US | Texas | Knox | 48275 | 232 | 12 | 0 | 224 | 33.60519951 | -99.7422906 | 2021-02-04 05:22:26 | Knox, Texas, US |
341199 | 341199 | 2021-02-03 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-04 05:22:26 | Custer, Idaho, US |
1687639 | 1687639 | 2021-02-02 | US | Texas | Knox | 48275 | 232 | 12 | 0 | 224 | 33.60519951 | -99.7422906 | 2021-02-03 05:22:52 | Knox, Texas, US |
1685813 | 1685813 | 2021-02-02 | US | Kansas | Morton | 20129 | 232 | 8 | 0 | 224 | 37.19141121 | -101.79925190000002 | 2021-02-03 05:22:52 | Morton, Kansas, US |
1685761 | 1685761 | 2021-02-02 | US | Kansas | Clark | 20025 | 230 | 6 | 0 | 224 | 37.23577007 | -99.81883015 | 2021-02-03 05:22:52 | Clark, Kansas, US |
1685425 | 1685425 | 2021-02-02 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-03 05:22:52 | Custer, Idaho, US |
1677783 | 1677783 | 2021-02-01 | US | Kansas | Morton | 20129 | 232 | 8 | 0 | 224 | 37.19141121 | -101.79925190000002 | 2021-02-02 05:22:49 | Morton, Kansas, US |
1677731 | 1677731 | 2021-02-01 | US | Kansas | Clark | 20025 | 230 | 6 | 0 | 224 | 37.23577007 | -99.81883015 | 2021-02-02 05:22:49 | Clark, Kansas, US |
1677395 | 1677395 | 2021-02-01 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-02 05:22:49 | Custer, Idaho, US |
1462524 | 1462524 | 2021-01-31 | US | Puerto Rico | Sabana Grande | 72121 | 224 | 0 | 0 | 224 | 18.08282 | -66.943758 | 2021-02-01 05:22:53 | Sabana Grande, Puerto Rico, US |
1461019 | 1461019 | 2021-01-31 | US | Kansas | Clark | 20025 | 230 | 6 | 0 | 224 | 37.23577007 | -99.81883015 | 2021-02-01 05:22:53 | Clark, Kansas, US |
1460683 | 1460683 | 2021-01-31 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-02-01 05:22:53 | Custer, Idaho, US |
2214425 | 2214425 | 2021-01-30 | US | Puerto Rico | Out of PR | 72888 | 224 | 0 | 0 | 224 | 18.459681 | -67.336525 | 2021-01-31 05:22:42 | Out of PR, Puerto Rico, US |
2212927 | 2212927 | 2021-01-30 | US | Kansas | Clark | 20025 | 230 | 6 | 0 | 224 | 37.23577007 | -99.81883015 | 2021-01-31 05:22:42 | Clark, Kansas, US |
2212591 | 2212591 | 2021-01-30 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-01-31 05:22:42 | Custer, Idaho, US |
1898414 | 1898414 | 2021-01-29 | US | Kansas | Clark | 20025 | 230 | 6 | 0 | 224 | 37.23577007 | -99.81883015 | 2021-01-30 05:22:49 | Clark, Kansas, US |
1898078 | 1898078 | 2021-01-29 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-01-30 05:22:49 | Custer, Idaho, US |
2482894 | 2482894 | 2021-01-28 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-01-29 05:22:23 | Custer, Idaho, US |
3154529 | 3154529 | 2021-01-27 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-01-28 05:22:24 | Custer, Idaho, US |
13264 | 13264 | 2021-01-26 | US | Idaho | Custer | 16037 | 227 | 3 | 0 | 224 | 44.24186819 | -114.2855494 | 2021-01-27 05:23:41 | Custer, Idaho, US |
2570725 | 2570725 | 2021-01-25 | US | Texas | Delta | 48119 | 864 | 5 | 0 | 224 | 33.38570922 | -95.66921122 | 2021-01-26 05:22:02 | Delta, Texas, US |
1762357 | 1762357 | 2021-01-24 | US | Texas | Delta | 48119 | 864 | 5 | 0 | 224 | 33.38570922 | -95.66921122 | 2021-01-25 05:22:16 | Delta, Texas, US |
1760567 | 1760567 | 2021-01-24 | US | Kansas | Edwards | 20047 | 234 | 10 | 0 | 224 | 37.88735543 | -99.31263309 | 2021-01-25 05:22:16 | Edwards, Kansas, US |
1760552 | 1760552 | 2021-01-24 | US | Kansas | Chase | 20017 | 227 | 3 | 0 | 224 | 38.30292938 | -96.59563862 | 2021-01-25 05:22:16 | Chase, Kansas, US |
2429265 | 2429265 | 2021-01-23 | US | North Carolina | Tyrrell | 37177 | 230 | 6 | 0 | 224 | 35.87147226 | -76.17055253 | 2021-01-24 05:22:35 | Tyrrell, North Carolina, US |
2428174 | 2428174 | 2021-01-23 | US | Kansas | Edwards | 20047 | 234 | 10 | 0 | 224 | 37.88735543 | -99.31263309 | 2021-01-24 05:22:35 | Edwards, Kansas, US |
2428159 | 2428159 | 2021-01-23 | US | Kansas | Chase | 20017 | 227 | 3 | 0 | 224 | 38.30292938 | -96.59563862 | 2021-01-24 05:22:35 | Chase, Kansas, US |
2468076 | 2468076 | 2021-01-22 | US | Kansas | Edwards | 20047 | 234 | 10 | 0 | 224 | 37.88735543 | -99.31263309 | 2021-01-23 05:22:03 | Edwards, Kansas, US |
2468061 | 2468061 | 2021-01-22 | US | Kansas | Chase | 20017 | 227 | 3 | 0 | 224 | 38.30292938 | -96.59563862 | 2021-01-23 05:22:03 | Chase, Kansas, US |
2466914 | 2466914 | 2021-01-22 | Monaco | 1311 | 9 | 1078 | 224 | 43.7333 | 7.4167 | 2021-01-23 05:22:03 | Monaco | |||
2466591 | 2466591 | 2021-01-22 | Chile | Aysen | 2227 | 18 | 1985 | 224 | -45.9864 | -73.7669 | 2021-01-23 05:22:03 | Aysen, Chile | ||
438745 | 438745 | 2021-01-21 | US | Virginia | Rappahannock | 51157 | 226 | 2 | 0 | 224 | 38.68295619 | -78.15826963 | 2021-01-22 05:22:10 | Rappahannock, Virginia, US |
438237 | 438237 | 2021-01-21 | US | South Dakota | McPherson | 46089 | 228 | 4 | 0 | 224 | 45.76626028 | -99.22118798 | 2021-01-22 05:22:10 | McPherson, South Dakota, US |
436627 | 436627 | 2021-01-21 | US | Kansas | Edwards | 20047 | 234 | 10 | 0 | 224 | 37.88735543 | -99.31263309 | 2021-01-22 05:22:10 | Edwards, Kansas, US |
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]);