johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
374 rows where active = 637 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218261 | 3218261 | 2021-07-26 | India | Punjab | 598840 | 16278 | 581925 | 637 | 30.841465000000003 | 75.40879 | 2021-07-27 04:21:18 | Punjab, India | ||
1378478 | 1378478 | 2021-07-25 | India | Uttarakhand | 341724 | 7359 | 333728 | 637 | 30.156447 | 79.197608 | 2021-07-26 04:21:28 | Uttarakhand, India | ||
1330314 | 1330314 | 2021-07-24 | Madagascar | 42590 | 939 | 41014 | 637 | -18.766947 | 46.869107 | 2021-07-25 04:22:12 | Madagascar | |||
295958 | 295958 | 2021-07-15 | India | Gujarat | 824384 | 10074 | 813673 | 637 | 22.694884 | 71.590923 | 2021-07-16 04:21:22 | Gujarat, India | ||
3970664 | 3970664 | 2021-06-11 | Mozambique | 71355 | 840 | 69878 | 637 | -18.665695 | 35.529562 | 2021-06-12 04:22:22 | Mozambique | |||
2103912 | 2103912 | 2021-06-01 | Chile | Arica y Parinacota | 22869 | 444 | 21788 | 637 | -18.594 | -69.4785 | 2021-06-02 04:24:34 | Arica y Parinacota, Chile | ||
1771372 | 1771372 | 2021-05-23 | Japan | Oita | 3164 | 38 | 2489 | 637 | 33.200697 | 131.43323999999998 | 2021-05-24 04:20:53 | Oita, Japan | ||
1771138 | 1771138 | 2021-05-23 | Chile | Tarapaca | 36161 | 660 | 34864 | 637 | -19.9232 | -69.5132 | 2021-05-24 04:20:53 | Tarapaca, Chile | ||
3574846 | 3574846 | 2021-05-17 | Russia | Tomsk Oblast | 32517 | 422 | 31458 | 637 | 58.6124279 | 82.04753149999998 | 2021-05-18 04:20:33 | Tomsk Oblast, Russia | ||
3054205 | 3054205 | 2021-05-13 | Japan | Ishikawa | 3084 | 92 | 2355 | 637 | 36.769464 | 136.771027 | 2021-05-14 04:20:41 | Ishikawa, Japan | ||
2760775 | 2760775 | 2021-05-03 | Colombia | Quindio | 39673 | 1183 | 37853 | 637 | 4.461 | -75.6674 | 2021-05-04 04:20:34 | Quindio, Colombia | ||
2020621 | 2020621 | 2021-04-20 | France | Reunion | 18425 | 135 | 17653 | 637 | -21.1151 | 55.5364 | 2021-04-21 04:21:14 | Reunion, France | ||
3883431 | 3883431 | 2021-04-11 | Colombia | Cauca | 28704 | 789 | 27278 | 637 | 2.705 | -76.82600000000002 | 2021-04-12 04:21:00 | Cauca, Colombia | ||
3003526 | 3003526 | 2021-04-06 | Russia | Mari El Republic | 12662 | 214 | 11811 | 637 | 56.5767504 | 47.8817512 | 2021-04-07 04:20:53 | Mari El Republic, Russia | ||
1301835 | 1301835 | 2021-04-01 | Chile | Arica y Parinacota | 17547 | 352 | 16558 | 637 | -18.594 | -69.4785 | 2021-04-02 04:20:36 | Arica y Parinacota, Chile | ||
1619565 | 1619565 | 2021-03-05 | US | Virginia | Essex | 51057 | 644 | 7 | 0 | 637 | 37.93357639 | -76.94230311 | 2021-03-06 04:23:41 | Essex, Virginia, US |
1617636 | 1617636 | 2021-03-05 | US | Kentucky | Gallatin | 21077 | 656 | 19 | 0 | 637 | 38.75398691 | -84.8558382 | 2021-03-06 04:23:41 | Gallatin, Kentucky, US |
2210976 | 2210976 | 2021-03-04 | US | Virginia | Essex | 51057 | 644 | 7 | 0 | 637 | 37.93357639 | -76.94230311 | 2021-03-05 05:26:29 | Essex, Virginia, US |
2210508 | 2210508 | 2021-03-04 | US | South Dakota | Day | 46037 | 665 | 28 | 0 | 637 | 45.367281 | -97.60737498 | 2021-03-05 05:26:29 | Day, South Dakota, US |
1092929 | 1092929 | 2021-03-03 | US | South Dakota | Day | 46037 | 665 | 28 | 0 | 637 | 45.367281 | -97.60737498 | 2021-03-04 05:24:24 | Day, South Dakota, US |
3257001 | 3257001 | 2021-03-02 | US | South Dakota | Day | 46037 | 665 | 28 | 0 | 637 | 45.367281 | -97.60737498 | 2021-03-03 05:23:28 | Day, South Dakota, US |
2370855 | 2370855 | 2021-02-28 | US | Virginia | Lunenburg | 51111 | 642 | 5 | 0 | 637 | 36.94618528 | -78.24133319 | 2021-03-01 05:23:01 | Lunenburg, Virginia, US |
3069357 | 3069357 | 2021-02-27 | US | Virginia | Lunenburg | 51111 | 642 | 5 | 0 | 637 | 36.94618528 | -78.24133319 | 2021-02-28 05:22:20 | Lunenburg, Virginia, US |
3068534 | 3068534 | 2021-02-27 | US | Oklahoma | Cotton | 40033 | 650 | 13 | 0 | 637 | 34.28845626 | -98.37053567 | 2021-02-28 05:22:20 | Cotton, Oklahoma, US |
2185878 | 2185878 | 2021-02-26 | US | North Carolina | Clay | 37043 | 655 | 18 | 0 | 637 | 35.05704275 | -83.74353633 | 2021-02-27 05:22:28 | Clay, North Carolina, US |
280812 | 280812 | 2021-02-24 | US | Colorado | Moffat | 8081 | 723 | 22 | 0 | 637 | 40.61810999 | -108.2070876 | 2021-02-25 05:24:57 | Moffat, Colorado, US |
280025 | 280025 | 2021-02-24 | Colombia | Cauca | 27270 | 743 | 25890 | 637 | 2.705 | -76.82600000000002 | 2021-02-25 05:24:57 | Cauca, Colombia | ||
534059 | 534059 | 2021-02-22 | US | Virginia | Lancaster | 51103 | 643 | 6 | 0 | 637 | 37.71889653 | -76.46400482 | 2021-02-23 05:23:41 | Lancaster, Virginia, US |
185413 | 185413 | 2021-02-21 | US | Virginia | Northumberland | 51133 | 650 | 13 | 0 | 637 | 37.89202088 | -76.41949732 | 2021-02-22 05:24:21 | Northumberland, Virginia, US |
745667 | 745667 | 2021-02-20 | US | Virginia | Lancaster | 51103 | 641 | 4 | 0 | 637 | 37.71889653 | -76.46400482 | 2021-02-21 05:24:33 | Lancaster, Virginia, US |
1155324 | 1155324 | 2021-02-18 | US | New Mexico | Sierra | 35051 | 680 | 43 | 0 | 637 | 33.13028233 | -107.1925893 | 2021-02-19 05:24:16 | Sierra, New Mexico, US |
1155169 | 1155169 | 2021-02-18 | US | Nebraska | Clay | 31035 | 648 | 11 | 0 | 637 | 40.52439441 | -98.05126296 | 2021-02-19 05:24:16 | Clay, Nebraska, US |
3603089 | 3603089 | 2021-02-17 | US | Nebraska | Clay | 31035 | 648 | 11 | 0 | 637 | 40.52439441 | -98.05126296 | 2021-02-18 05:22:58 | Clay, Nebraska, US |
2678017 | 2678017 | 2021-02-13 | Russia | Chechen Republic | 11114 | 110 | 10367 | 637 | 43.39761470000001 | 45.6985005 | 2021-02-14 05:23:43 | Chechen Republic, Russia | ||
2677797 | 2677797 | 2021-02-13 | India | Uttarakhand | 96766 | 1680 | 94449 | 637 | 30.156447 | 79.197608 | 2021-02-14 05:23:43 | Uttarakhand, India | ||
2639770 | 2639770 | 2021-02-11 | US | Nebraska | Clay | 31035 | 648 | 11 | 0 | 637 | 40.52439441 | -98.05126296 | 2021-02-12 05:23:29 | Clay, Nebraska, US |
2638968 | 2638968 | 2021-02-11 | US | Iowa | Worth | 19195 | 641 | 4 | 0 | 637 | 43.37750768 | -93.26087602 | 2021-02-12 05:23:29 | Worth, Iowa, US |
3980956 | 3980956 | 2021-02-10 | US | North Dakota | Bottineau | 38009 | 664 | 20 | 0 | 637 | 48.79106111 | -100.8378166 | 2021-02-11 05:23:55 | Bottineau, North Dakota, US |
3979823 | 3979823 | 2021-02-10 | US | Iowa | Worth | 19195 | 641 | 4 | 0 | 637 | 43.37750768 | -93.26087602 | 2021-02-11 05:23:55 | Worth, Iowa, US |
1529950 | 1529950 | 2021-02-09 | US | Nebraska | Dawes | 31045 | 655 | 18 | 0 | 637 | 42.71985036 | -103.1313774 | 2021-02-10 05:22:41 | Dawes, Nebraska, US |
793691 | 793691 | 2021-02-04 | US | Virginia | Charlotte | 51037 | 648 | 11 | 0 | 637 | 37.01909701 | -78.66314092 | 2021-02-05 05:22:38 | Charlotte, Virginia, US |
342355 | 342355 | 2021-02-03 | US | Nebraska | Kearney | 31099 | 641 | 4 | 0 | 637 | 40.50663314 | -98.94877182 | 2021-02-04 05:22:26 | Kearney, Nebraska, US |
1685828 | 1685828 | 2021-02-02 | US | Kansas | Republic | 20157 | 647 | 10 | 0 | 637 | 39.82799632 | -97.65036709 | 2021-02-03 05:22:52 | Republic, Kansas, US |
1678347 | 1678347 | 2021-02-01 | US | Missouri | Cedar | 29039 | 646 | 9 | 0 | 637 | 37.72391475 | -93.85445441 | 2021-02-02 05:22:49 | Cedar, Missouri, US |
1677798 | 1677798 | 2021-02-01 | US | Kansas | Republic | 20157 | 647 | 10 | 0 | 637 | 39.82799632 | -97.65036709 | 2021-02-02 05:22:49 | Republic, Kansas, US |
1461086 | 1461086 | 2021-01-31 | US | Kansas | Republic | 20157 | 647 | 10 | 0 | 637 | 39.82799632 | -97.65036709 | 2021-02-01 05:22:53 | Republic, Kansas, US |
1461081 | 1461081 | 2021-01-31 | US | Kansas | Phillips | 20147 | 654 | 17 | 0 | 637 | 39.78465501 | -99.34668865 | 2021-02-01 05:22:53 | Phillips, Kansas, US |
2212994 | 2212994 | 2021-01-30 | US | Kansas | Republic | 20157 | 647 | 10 | 0 | 637 | 39.82799632 | -97.65036709 | 2021-01-31 05:22:42 | Republic, Kansas, US |
2212989 | 2212989 | 2021-01-30 | US | Kansas | Phillips | 20147 | 654 | 17 | 0 | 637 | 39.78465501 | -99.34668865 | 2021-01-31 05:22:42 | Phillips, Kansas, US |
1898481 | 1898481 | 2021-01-29 | US | Kansas | Republic | 20157 | 647 | 10 | 0 | 637 | 39.82799632 | -97.65036709 | 2021-01-30 05:22:49 | Republic, Kansas, US |
1898476 | 1898476 | 2021-01-29 | US | Kansas | Phillips | 20147 | 654 | 17 | 0 | 637 | 39.78465501 | -99.34668865 | 2021-01-30 05:22:49 | Phillips, Kansas, US |
3157049 | 3157049 | 2021-01-27 | US | Washington | Pacific | 53049 | 645 | 8 | 0 | 637 | 46.55418369 | -123.7285716 | 2021-01-28 05:22:24 | Pacific, Washington, US |
3156381 | 3156381 | 2021-01-27 | US | Puerto Rico | Utuado | 72141 | 637 | 0 | 0 | 637 | 18.271214 | -66.702984 | 2021-01-28 05:22:24 | Utuado, Puerto Rico, US |
3155686 | 3155686 | 2021-01-27 | US | Nebraska | Keith | 31101 | 640 | 3 | 0 | 637 | 41.19930341 | -101.6620164 | 2021-01-28 05:22:24 | Keith, Nebraska, US |
15946 | 15946 | 2021-01-26 | US | Wyoming | Sublette | 56035 | 644 | 7 | 0 | 637 | 42.76558279 | -109.9130922 | 2021-01-27 05:23:41 | Sublette, Wyoming, US |
12993 | 12993 | 2021-01-26 | US | Colorado | Yuma | 8125 | 796 | 16 | 0 | 637 | 40.00346839 | -102.4258673 | 2021-01-27 05:23:41 | Yuma, Colorado, US |
2570741 | 2570741 | 2021-01-25 | US | Texas | Floyd | 48153 | 887 | 28 | 0 | 637 | 34.07227468 | -101.3031546 | 2021-01-26 05:22:02 | Floyd, Texas, US |
2427725 | 2427725 | 2021-01-23 | US | Georgia | Lanier | 13173 | 647 | 10 | 0 | 637 | 31.038285700000007 | -83.06472457 | 2021-01-24 05:22:35 | Lanier, Georgia, US |
2427408 | 2427408 | 2021-01-23 | US | Arkansas | Perry | 5105 | 643 | 6 | 0 | 637 | 34.9459153 | -92.94372564 | 2021-01-24 05:22:35 | Perry, Arkansas, US |
2469702 | 2469702 | 2021-01-22 | US | South Dakota | Tripp | 46123 | 652 | 15 | 0 | 637 | 43.34459388 | -99.8854891 | 2021-01-23 05:22:03 | Tripp, South Dakota, US |
2468350 | 2468350 | 2021-01-22 | US | Maine | Franklin | 23007 | 644 | 7 | 0 | 637 | 44.97330019 | -70.44381045 | 2021-01-23 05:22:03 | Franklin, Maine, US |
1094589 | 1094589 | 2021-01-20 | US | Arkansas | Nevada | 5099 | 659 | 22 | 0 | 637 | 33.66340119 | -93.30632432 | 2021-01-21 05:22:01 | Nevada, Arkansas, US |
3504658 | 3504658 | 2021-01-17 | US | Kansas | Linn | 20107 | 642 | 5 | 0 | 637 | 38.21267844 | -94.84254089 | 2021-01-18 05:22:34 | Linn, Kansas, US |
3503169 | 3503169 | 2021-01-17 | China | Hong Kong | 9557 | 162 | 8758 | 637 | 22.3 | 114.2 | 2021-01-18 05:22:34 | Hong Kong, China | ||
3102741 | 3102741 | 2021-01-16 | US | Kansas | Linn | 20107 | 642 | 5 | 0 | 637 | 38.21267844 | -94.84254089 | 2021-01-17 05:22:17 | Linn, Kansas, US |
3101222 | 3101222 | 2021-01-16 | Chad | 2855 | 111 | 2107 | 637 | 15.4542 | 18.7322 | 2021-01-17 05:22:17 | Chad | |||
3516703 | 3516703 | 2021-01-15 | US | Kansas | Linn | 20107 | 642 | 5 | 0 | 637 | 38.21267844 | -94.84254089 | 2021-01-16 05:22:40 | Linn, Kansas, US |
3516608 | 3516608 | 2021-01-15 | US | Iowa | Lucas | 19117 | 645 | 8 | 0 | 637 | 41.02958964 | -93.32780803 | 2021-01-16 05:22:40 | Lucas, Iowa, US |
3516279 | 3516279 | 2021-01-15 | US | Georgia | Treutlen | 13283 | 653 | 16 | 0 | 637 | 32.40422134 | -82.56904553 | 2021-01-16 05:22:40 | Treutlen, Georgia, US |
3515434 | 3515434 | 2021-01-15 | Japan | Okinawa | 6180 | 86 | 5457 | 637 | 25.768923 | 126.668016 | 2021-01-16 05:22:40 | Okinawa, Japan | ||
3882131 | 3882131 | 2021-01-14 | US | Oklahoma | Latimer | 40077 | 644 | 7 | 0 | 637 | 34.87844729 | -95.25215049 | 2021-01-15 05:22:24 | Latimer, Oklahoma, US |
3880781 | 3880781 | 2021-01-14 | US | Iowa | Lucas | 19117 | 645 | 8 | 0 | 637 | 41.02958964 | -93.32780803 | 2021-01-15 05:22:24 | Lucas, Iowa, US |
2627764 | 2627764 | 2021-01-10 | US | Missouri | Gentry | 29075 | 653 | 16 | 0 | 637 | 40.21097916 | -94.40944419 | 2021-01-11 05:21:50 | Gentry, Missouri, US |
156728 | 156728 | 2021-01-08 | US | Puerto Rico | Loiza | 72087 | 637 | 0 | 0 | 637 | 18.425688 | -65.89943000000001 | 2021-01-09 05:22:18 | Loiza, Puerto Rico, US |
2541948 | 2541948 | 2021-01-07 | US | California | Inyo | 6027 | 664 | 20 | 0 | 637 | 36.51112084 | -117.41119779999998 | 2021-01-08 05:22:42 | Inyo, California, US |
2867933 | 2867933 | 2021-01-06 | US | Texas | Swisher | 48437 | 797 | 14 | 0 | 637 | 34.53028891 | -101.7349174 | 2021-01-07 05:22:03 | Swisher, Texas, US |
2866615 | 2866615 | 2021-01-06 | US | Missouri | Howard | 29089 | 641 | 4 | 0 | 637 | 39.1435761 | -92.69756691 | 2021-01-07 05:22:03 | Howard, Missouri, US |
2230854 | 2230854 | 2021-01-02 | US | Virginia | Goochland | 51075 | 644 | 7 | 0 | 637 | 37.71714806 | -77.90381514 | 2021-01-03 05:22:52 | Goochland, Virginia, US |
2230837 | 2230837 | 2021-01-02 | US | Virginia | Dickenson | 51051 | 643 | 6 | 0 | 637 | 37.12560977 | -82.35124171 | 2021-01-03 05:22:52 | Dickenson, Virginia, US |
2229415 | 2229415 | 2021-01-02 | US | Missouri | Harrison | 29081 | 647 | 10 | 0 | 637 | 40.35570088 | -93.99222144 | 2021-01-03 05:22:52 | Harrison, Missouri, US |
1138909 | 1138909 | 2021-01-01 | US | Montana | Valley | 30105 | 644 | 7 | 0 | 637 | 48.36435097 | -106.6669635 | 2021-01-02 05:22:33 | Valley, Montana, US |
3697515 | 3697515 | 2020-12-31 | US | Montana | Valley | 30105 | 644 | 7 | 0 | 637 | 48.36435097 | -106.6669635 | 2021-01-01 05:23:07 | Valley, Montana, US |
1012330 | 1012330 | 2020-12-30 | US | Montana | Valley | 30105 | 644 | 7 | 0 | 637 | 48.36435097 | -106.6669635 | 2020-12-31 05:22:49 | Valley, Montana, US |
768018 | 768018 | 2020-12-29 | US | Minnesota | Clearwater | 27029 | 650 | 13 | 0 | 637 | 47.57992111 | -95.37790562 | 2020-12-30 05:22:34 | Clearwater, Minnesota, US |
767503 | 767503 | 2020-12-29 | US | Iowa | Greene | 19073 | 644 | 7 | 0 | 637 | 42.03614551 | -94.39658081 | 2020-12-30 05:22:34 | Greene, Iowa, US |
2225992 | 2225992 | 2020-12-26 | US | Ohio | Monroe | 39111 | 665 | 28 | 0 | 637 | 39.72984936 | -81.08464734 | 2020-12-27 05:22:55 | Monroe, Ohio, US |
2225470 | 2225470 | 2020-12-26 | US | Missouri | Sullivan | 29211 | 646 | 9 | 0 | 637 | 40.2099105 | -93.11150106 | 2020-12-27 05:22:55 | Sullivan, Missouri, US |
203672 | 203672 | 2020-12-25 | US | Kentucky | Lawrence | 21127 | 641 | 4 | 0 | 637 | 38.07136018 | -82.72882223 | 2020-12-26 05:22:28 | Lawrence, Kentucky, US |
3692895 | 3692895 | 2020-12-24 | US | Kentucky | Lawrence | 21127 | 641 | 4 | 0 | 637 | 38.07136018 | -82.72882223 | 2020-12-25 05:22:48 | Lawrence, Kentucky, US |
2408247 | 2408247 | 2020-12-23 | US | Kentucky | Lawrence | 21127 | 641 | 4 | 0 | 637 | 38.07136018 | -82.72882223 | 2020-12-24 05:23:04 | Lawrence, Kentucky, US |
3772755 | 3772755 | 2020-12-22 | US | South Dakota | McCook | 46087 | 658 | 21 | 0 | 637 | 43.6742571 | -97.36863144 | 2020-12-23 05:22:03 | McCook, South Dakota, US |
3772621 | 3772621 | 2020-12-22 | US | Puerto Rico | Las Piedras | 72085 | 637 | 0 | 0 | 637 | 18.187527 | -65.86946800000001 | 2020-12-23 05:22:03 | Las Piedras, Puerto Rico, US |
3771199 | 3771199 | 2020-12-22 | US | Kansas | Pratt | 20151 | 654 | 17 | 0 | 637 | 37.64780729 | -98.73922153 | 2020-12-23 05:22:03 | Pratt, Kansas, US |
929960 | 929960 | 2020-12-21 | US | New York | Washington | 36115 | 651 | 14 | 0 | 637 | 43.31153794 | -73.43043448 | 2020-12-22 05:22:33 | Washington, New York, US |
929775 | 929775 | 2020-12-21 | US | Nebraska | Knox | 31107 | 642 | 5 | 0 | 637 | 42.63758421 | -97.89178836 | 2020-12-22 05:22:33 | Knox, Nebraska, US |
929015 | 929015 | 2020-12-21 | US | Kansas | Pratt | 20151 | 654 | 17 | 0 | 637 | 37.64780729 | -98.73922153 | 2020-12-22 05:22:33 | Pratt, Kansas, US |
2123090 | 2123090 | 2020-12-20 | US | Virginia | Patrick | 51141 | 665 | 28 | 0 | 637 | 36.6801638 | -80.2865648 | 2020-12-21 05:27:58 | Patrick, Virginia, US |
2932672 | 2932672 | 2020-12-19 | US | Kentucky | Powell | 21197 | 637 | 0 | 0 | 637 | 37.83218794 | -83.82553961 | 2020-12-20 05:27:32 | Powell, Kentucky, US |
1902568 | 1902568 | 2020-12-18 | US | Kentucky | Harrison | 21097 | 638 | 1 | 0 | 637 | 38.44188174 | -84.32869741 | 2020-12-19 05:27:52 | Harrison, Kentucky, US |
2131581 | 2131581 | 2020-12-17 | US | Wyoming | Big Horn | 56003 | 652 | 15 | 0 | 637 | 44.52405055 | -107.9960365 | 2020-12-18 05:28:18 | Big Horn, Wyoming, 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]);