johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
407 rows where active = 496 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015127 | 3015127 | 2021-08-01 | Canada | Saskatchewan | 50067 | 578 | 48993 | 496 | 52.9399 | -106.4509 | 2021-08-02 04:21:36 | Saskatchewan, Canada | ||
1330035 | 1330035 | 2021-07-24 | Chile | Los Lagos | 87058 | 1308 | 85254 | 496 | -41.9198 | -72.1416 | 2021-07-25 04:22:12 | Los Lagos, Chile | ||
3335164 | 3335164 | 2021-07-21 | Ukraine | Lviv Oblast | 137878 | 3676 | 133706 | 496 | 49.8397 | 24.0297 | 2021-07-22 04:21:19 | Lviv Oblast, Ukraine | ||
2371630 | 2371630 | 2021-07-20 | Netherlands | Curacao | 12883 | 126 | 12261 | 496 | 12.1696 | -68.99 | 2021-07-21 04:21:40 | Curacao, Netherlands | ||
483377 | 483377 | 2021-07-19 | Chile | Coquimbo | 46993 | 897 | 45600 | 496 | -29.959 | -71.3389 | 2021-07-20 04:21:48 | Coquimbo, Chile | ||
3706089 | 3706089 | 2021-07-17 | India | Rajasthan | 953334 | 8949 | 943889 | 496 | 26.583423 | 73.847973 | 2021-07-18 04:22:07 | Rajasthan, India | ||
578703 | 578703 | 2021-07-13 | Croatia | 360924 | 8231 | 352197 | 496 | 45.1 | 15.2 | 2021-07-14 04:21:35 | Croatia | |||
1932281 | 1932281 | 2021-07-05 | Colombia | Choco | 14801 | 353 | 13952 | 496 | 5.2528 | -76.82600000000002 | 2021-07-06 04:21:32 | Choco, Colombia | ||
1893012 | 1893012 | 2021-06-30 | Croatia | 359872 | 8206 | 351170 | 496 | 45.1 | 15.2 | 2021-07-01 04:21:19 | Croatia | |||
3125341 | 3125341 | 2021-06-28 | Colombia | Arauca | 10455 | 302 | 9657 | 496 | 7.0762 | -70.7105 | 2021-06-29 04:21:28 | Arauca, Colombia | ||
2295524 | 2295524 | 2021-06-24 | Mauritius | 1845 | 18 | 1331 | 496 | -20.348404 | 57.552152 | 2021-06-25 04:21:33 | Mauritius | |||
2295336 | 2295336 | 2021-06-24 | Eritrea | 5664 | 21 | 5147 | 496 | 15.1794 | 39.7823 | 2021-06-25 04:21:33 | Eritrea | |||
2104339 | 2104339 | 2021-06-01 | Russia | Khakassia Republic | 23171 | 554 | 22121 | 496 | 53.72258845 | 91.44293627 | 2021-06-02 04:24:34 | Khakassia Republic, Russia | ||
1952789 | 1952789 | 2021-05-21 | Singapore | 61770 | 32 | 61242 | 496 | 1.2833 | 103.8333 | 2021-05-22 04:20:45 | Singapore | |||
1082176 | 1082176 | 2021-05-14 | Russia | Tula Oblast | 39219 | 1944 | 36779 | 496 | 53.9570701 | 37.3690909 | 2021-05-15 04:20:58 | Tula Oblast, Russia | ||
3054215 | 3054215 | 2021-05-13 | Japan | Miyazaki | 2728 | 25 | 2207 | 496 | 32.193203999999994 | 131.299374 | 2021-05-14 04:20:41 | Miyazaki, Japan | ||
2004871 | 2004871 | 2021-05-12 | Russia | Khanty-Mansi Autonomous Okrug | 56591 | 794 | 55301 | 496 | 61.0259025 | 69.0982628 | 2021-05-13 04:20:51 | Khanty-Mansi Autonomous Okrug, Russia | ||
3133198 | 3133198 | 2021-04-18 | Malaysia | Negeri Sembilan | 17916 | 31 | 17389 | 496 | 2.7258 | 101.9424 | 2021-04-19 04:20:57 | Negeri Sembilan, Malaysia | ||
605693 | 605693 | 2021-04-09 | Japan | Ehime | 1653 | 24 | 1133 | 496 | 33.624835 | 132.856842 | 2021-04-10 04:20:59 | Ehime, Japan | ||
3003326 | 3003326 | 2021-04-06 | Japan | Kyoto | 9844 | 173 | 9175 | 496 | 35.253815 | 135.443341 | 2021-04-07 04:20:53 | Kyoto, Japan | ||
3456536 | 3456536 | 2021-03-18 | Malaysia | Perak | 12476 | 43 | 11937 | 496 | 4.5921 | 101.0901 | 2021-03-19 05:26:09 | Perak, Malaysia | ||
54690 | 54690 | 2021-03-07 | Equatorial Guinea | 6329 | 96 | 5737 | 496 | 1.6508 | 10.2679 | 2021-03-08 05:24:48 | Equatorial Guinea | |||
3667507 | 3667507 | 2021-03-06 | Equatorial Guinea | 6329 | 96 | 5737 | 496 | 1.6508 | 10.2679 | 2021-03-07 05:21:54 | Equatorial Guinea | |||
1093178 | 1093178 | 2021-03-03 | US | Texas | Hartley | 48205 | 663 | 2 | 0 | 496 | 35.84008013 | -102.6029022 | 2021-03-04 05:24:24 | Hartley, Texas, US |
3256183 | 3256183 | 2021-03-02 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-03-03 05:23:28 | Boone, Nebraska, US |
1000475 | 1000475 | 2021-03-01 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-03-02 05:23:30 | Boone, Nebraska, US |
2369533 | 2369533 | 2021-02-28 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-03-01 05:23:01 | Boone, Nebraska, US |
3068035 | 3068035 | 2021-02-27 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-02-28 05:22:20 | Boone, Nebraska, US |
2185619 | 2185619 | 2021-02-26 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-02-27 05:22:28 | Boone, Nebraska, US |
1860041 | 1860041 | 2021-02-25 | US | Nebraska | Boone | 31011 | 500 | 4 | 0 | 496 | 41.70759415 | -98.06737183 | 2021-02-26 05:22:40 | Boone, Nebraska, US |
283461 | 283461 | 2021-02-24 | US | Vermont | Orange | 50017 | 499 | 3 | 0 | 496 | 44.00470222 | -72.37640104 | 2021-02-25 05:24:57 | Orange, Vermont, US |
1939503 | 1939503 | 2021-02-23 | US | Texas | Crane | 48103 | 373 | 11 | 0 | 496 | 31.43052248 | -102.5143314 | 2021-02-24 05:29:16 | Crane, Texas, US |
1937283 | 1937283 | 2021-02-23 | US | Georgia | Marion | 13197 | 511 | 15 | 0 | 496 | 32.3483402 | -84.52733571 | 2021-02-24 05:29:16 | Marion, Georgia, US |
533758 | 533758 | 2021-02-22 | US | Texas | Crane | 48103 | 373 | 11 | 0 | 496 | 31.43052248 | -102.5143314 | 2021-02-23 05:23:41 | Crane, Texas, US |
185092 | 185092 | 2021-02-21 | US | Texas | Crane | 48103 | 373 | 11 | 0 | 496 | 31.43052248 | -102.5143314 | 2021-02-22 05:24:21 | Crane, Texas, US |
745366 | 745366 | 2021-02-20 | US | Texas | Crane | 48103 | 373 | 11 | 0 | 496 | 31.43052248 | -102.5143314 | 2021-02-21 05:24:33 | Crane, Texas, US |
743680 | 743680 | 2021-02-20 | US | Kentucky | Bracken | 21023 | 500 | 4 | 0 | 496 | 38.69158994 | -84.08532444 | 2021-02-21 05:24:33 | Bracken, Kentucky, US |
3053862 | 3053862 | 2021-02-16 | Malaysia | Terengganu | 2952 | 7 | 2449 | 496 | 5.3117 | 103.1324 | 2021-02-17 05:23:10 | Terengganu, Malaysia | ||
3053228 | 3053228 | 2021-02-16 | US | Texas | Crane | 48103 | 373 | 11 | 0 | 496 | 31.43052248 | -102.5143314 | 2021-02-17 05:23:10 | Crane, Texas, US |
1341137 | 1341137 | 2021-02-15 | US | South Dakota | Gregory | 46053 | 523 | 27 | 0 | 496 | 43.19419064 | -99.18883902 | 2021-02-16 05:24:38 | Gregory, South Dakota, US |
3541185 | 3541185 | 2021-02-12 | US | Minnesota | Lincoln | 27081 | 498 | 2 | 0 | 496 | 44.41311883 | -96.26688165 | 2021-02-13 05:22:12 | Lincoln, Minnesota, US |
2639799 | 2639799 | 2021-02-11 | US | Nebraska | Howard | 31093 | 513 | 17 | 0 | 496 | 41.2200529 | -98.5166499 | 2021-02-12 05:23:29 | Howard, Nebraska, US |
2639448 | 2639448 | 2021-02-11 | US | Minnesota | Lincoln | 27081 | 498 | 2 | 0 | 496 | 44.41311883 | -96.26688165 | 2021-02-12 05:23:29 | Lincoln, Minnesota, US |
3980303 | 3980303 | 2021-02-10 | US | Minnesota | Lincoln | 27081 | 498 | 2 | 0 | 496 | 44.41311883 | -96.26688165 | 2021-02-11 05:23:55 | Lincoln, Minnesota, US |
1529623 | 1529623 | 2021-02-09 | US | Minnesota | Lincoln | 27081 | 498 | 2 | 0 | 496 | 44.41311883 | -96.26688165 | 2021-02-10 05:22:41 | Lincoln, Minnesota, US |
1529384 | 1529384 | 2021-02-09 | US | Louisiana | Cameron | 22023 | 501 | 5 | 0 | 496 | 29.87592238 | -93.19310676 | 2021-02-10 05:22:41 | Cameron, Louisiana, US |
615765 | 615765 | 2021-02-08 | US | Nebraska | Howard | 31093 | 511 | 15 | 0 | 496 | 41.2200529 | -98.5166499 | 2021-02-09 05:23:30 | Howard, Nebraska, US |
1674534 | 1674534 | 2021-02-07 | US | Nebraska | Howard | 31093 | 511 | 15 | 0 | 496 | 41.2200529 | -98.5166499 | 2021-02-08 05:22:39 | Howard, Nebraska, US |
1591035 | 1591035 | 2021-02-05 | US | South Dakota | Fall River | 46047 | 511 | 15 | 0 | 496 | 43.23929297 | -103.5275691 | 2021-02-06 05:23:55 | Fall River, South Dakota, US |
791357 | 791357 | 2021-02-04 | US | Illinois | Edwards | 17047 | 504 | 8 | 0 | 496 | 38.41353228 | -88.05720863 | 2021-02-05 05:22:38 | Edwards, Illinois, US |
790493 | 790493 | 2021-02-04 | Mongolia | 1890 | 2 | 1430 | 496 | 46.8625 | 103.8467 | 2021-02-05 05:22:38 | Mongolia | |||
1460871 | 1460871 | 2021-01-31 | US | Indiana | Ohio | 18115 | 506 | 10 | 0 | 496 | 38.955305 | -84.96515993 | 2021-02-01 05:22:53 | Ohio, Indiana, US |
2214207 | 2214207 | 2021-01-30 | US | Oklahoma | Dewey | 40043 | 500 | 4 | 0 | 496 | 35.98772922 | -99.00730714 | 2021-01-31 05:22:42 | Dewey, Oklahoma, US |
2212904 | 2212904 | 2021-01-30 | US | Iowa | Van Buren | 19177 | 512 | 16 | 0 | 496 | 40.75326764 | -91.95017958 | 2021-01-31 05:22:42 | Van Buren, Iowa, US |
13514 | 13514 | 2021-01-26 | US | Iowa | Decatur | 19053 | 500 | 4 | 0 | 496 | 40.73742757 | -93.78645949 | 2021-01-27 05:23:41 | Decatur, Iowa, US |
2569974 | 2569974 | 2021-01-25 | US | North Carolina | Gates | 37073 | 508 | 12 | 0 | 496 | 36.44667547 | -76.69749701 | 2021-01-26 05:22:02 | Gates, North Carolina, US |
1761211 | 1761211 | 2021-01-24 | US | Missouri | Linn | 29115 | 506 | 10 | 0 | 496 | 39.87001769 | -93.10704106 | 2021-01-25 05:22:16 | Linn, Missouri, US |
2429628 | 2429628 | 2021-01-23 | US | Puerto Rico | Comerio | 72045 | 496 | 0 | 0 | 496 | 18.224687 | -66.221622 | 2021-01-24 05:22:35 | Comerio, Puerto Rico, US |
2428837 | 2428837 | 2021-01-23 | US | Missouri | Ozark | 29153 | 502 | 6 | 0 | 496 | 36.64916339 | -92.44459066 | 2021-01-24 05:22:35 | Ozark, Missouri, US |
2470438 | 2470438 | 2021-01-22 | Ukraine | Sevastopol* | 8807 | 348 | 7963 | 496 | 44.6054 | 33.522 | 2021-01-23 05:22:03 | Sevastopol*, Ukraine | ||
2467560 | 2467560 | 2021-01-22 | US | Georgia | Calhoun | 13037 | 508 | 12 | 0 | 496 | 31.53169785 | -84.62725131 | 2021-01-23 05:22:03 | Calhoun, Georgia, US |
910899 | 910899 | 2021-01-19 | US | Puerto Rico | Ciales | 72039 | 496 | 0 | 0 | 496 | 18.28885 | -66.516475 | 2021-01-20 05:21:54 | Ciales, Puerto Rico, US |
910096 | 910096 | 2021-01-19 | US | Missouri | Maries | 29125 | 503 | 7 | 0 | 496 | 38.16193985 | -91.92249662 | 2021-01-20 05:21:54 | Maries, Missouri, US |
239565 | 239565 | 2021-01-18 | US | North Carolina | Jones | 37103 | 512 | 16 | 0 | 496 | 35.02254606 | -77.35870791 | 2021-01-19 05:22:15 | Jones, North Carolina, US |
239159 | 239159 | 2021-01-18 | US | Missouri | Maries | 29125 | 503 | 7 | 0 | 496 | 38.16193985 | -91.92249662 | 2021-01-19 05:22:15 | Maries, Missouri, US |
238688 | 238688 | 2021-01-18 | US | Kentucky | Owen | 21187 | 503 | 7 | 0 | 496 | 38.51679143 | -84.82404619 | 2021-01-19 05:22:15 | Owen, Kentucky, US |
3505682 | 3505682 | 2021-01-17 | US | North Carolina | Jones | 37103 | 512 | 16 | 0 | 496 | 35.02254606 | -77.35870791 | 2021-01-18 05:22:34 | Jones, North Carolina, US |
3518164 | 3518164 | 2021-01-15 | US | Puerto Rico | Quebradillas | 72115 | 496 | 0 | 0 | 496 | 18.439692 | -66.926113 | 2021-01-16 05:22:40 | Quebradillas, Puerto Rico, US |
3518159 | 3518159 | 2021-01-15 | US | Puerto Rico | Orocovis | 72107 | 496 | 0 | 0 | 496 | 18.215046 | -66.433604 | 2021-01-16 05:22:40 | Orocovis, Puerto Rico, US |
3516795 | 3516795 | 2021-01-15 | US | Kentucky | Gallatin | 21077 | 508 | 12 | 0 | 496 | 38.75398691 | -84.8558382 | 2021-01-16 05:22:40 | Gallatin, Kentucky, US |
2867422 | 2867422 | 2021-01-06 | US | Puerto Rico | Anasco | 72011 | 496 | 0 | 0 | 496 | 18.287985 | -67.120611 | 2021-01-07 05:22:03 | Anasco, Puerto Rico, US |
3036669 | 3036669 | 2021-01-05 | US | North Carolina | Washington | 37187 | 509 | 13 | 0 | 496 | 35.83810081 | -76.57299037 | 2021-01-06 05:22:16 | Washington, North Carolina, US |
3035251 | 3035251 | 2021-01-05 | US | Idaho | Valley | 16085 | 500 | 4 | 0 | 496 | 44.76728382 | -115.5676773 | 2021-01-06 05:22:16 | Valley, Idaho, US |
3034807 | 3034807 | 2021-01-05 | US | Arkansas | Perry | 5105 | 501 | 5 | 0 | 496 | 34.9459153 | -92.94372564 | 2021-01-06 05:22:16 | Perry, Arkansas, US |
2231197 | 2231197 | 2021-01-02 | Malaysia | Pahang | 1413 | 7 | 910 | 496 | 3.8126 | 103.3256 | 2021-01-03 05:22:52 | Pahang, Malaysia | ||
2228019 | 2228019 | 2021-01-02 | US | Arkansas | Monroe | 5095 | 503 | 7 | 0 | 496 | 34.6815935 | -91.20540287 | 2021-01-03 05:22:52 | Monroe, Arkansas, US |
1013606 | 1013606 | 2020-12-30 | US | Virginia | Buena Vista | 51530 | 500 | 4 | 0 | 496 | 37.73484642 | -79.35296097 | 2020-12-31 05:22:49 | Buena Vista, Virginia, US |
1013380 | 1013380 | 2020-12-30 | US | Texas | Floyd | 48153 | 690 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-31 05:22:49 | Floyd, Texas, US |
1012086 | 1012086 | 2020-12-30 | US | Mississippi | Choctaw | 28019 | 506 | 10 | 0 | 496 | 33.34598242 | -89.24809382 | 2020-12-31 05:22:49 | Choctaw, Mississippi, US |
1010928 | 1010928 | 2020-12-30 | US | Colorado | Las Animas | 8071 | 707 | 9 | 0 | 496 | 37.3153406 | -104.0376458 | 2020-12-31 05:22:49 | Las Animas, Colorado, US |
1010328 | 1010328 | 2020-12-30 | Japan | Miyagi | 2165 | 16 | 1653 | 496 | 38.446859 | 140.927086 | 2020-12-31 05:22:49 | Miyagi, Japan | ||
3764659 | 3764659 | 2020-12-28 | US | Texas | Floyd | 48153 | 671 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-29 05:22:37 | Floyd, Texas, US |
3764635 | 3764635 | 2020-12-28 | US | Texas | Crockett | 48105 | 358 | 9 | 0 | 496 | 30.72367027 | -101.4134238 | 2020-12-29 05:22:37 | Crockett, Texas, US |
3763508 | 3763508 | 2020-12-28 | US | Missouri | Monroe | 29137 | 501 | 5 | 0 | 496 | 39.49593978 | -92.00043978 | 2020-12-29 05:22:37 | Monroe, Missouri, US |
3780979 | 3780979 | 2020-12-27 | US | Texas | Floyd | 48153 | 663 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-28 05:22:06 | Floyd, Texas, US |
2226584 | 2226584 | 2020-12-26 | US | Texas | Floyd | 48153 | 663 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-27 05:22:55 | Floyd, Texas, US |
2224428 | 2224428 | 2020-12-26 | US | Idaho | Caribou | 16029 | 506 | 10 | 0 | 496 | 42.77149116 | -111.5597683 | 2020-12-27 05:22:55 | Caribou, Idaho, US |
205931 | 205931 | 2020-12-25 | Malaysia | Melaka | 922 | 6 | 420 | 496 | 2.1896 | 102.2501 | 2020-12-26 05:22:28 | Melaka, Malaysia | ||
205331 | 205331 | 2020-12-25 | US | Texas | Floyd | 48153 | 659 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-26 05:22:28 | Floyd, Texas, US |
205108 | 205108 | 2020-12-25 | US | South Dakota | Day | 46037 | 516 | 20 | 0 | 496 | 45.367281 | -97.60737498 | 2020-12-26 05:22:28 | Day, South Dakota, US |
3694554 | 3694554 | 2020-12-24 | US | Texas | Floyd | 48153 | 654 | 21 | 0 | 496 | 34.07227468 | -101.3031546 | 2020-12-25 05:22:48 | Floyd, Texas, US |
3694331 | 3694331 | 2020-12-24 | US | South Dakota | Day | 46037 | 516 | 20 | 0 | 496 | 45.367281 | -97.60737498 | 2020-12-25 05:22:48 | Day, South Dakota, US |
2407666 | 2407666 | 2020-12-23 | US | Georgia | Miller | 13201 | 499 | 3 | 0 | 496 | 31.16568912 | -84.73151117 | 2020-12-24 05:23:04 | Miller, Georgia, US |
3771975 | 3771975 | 2020-12-22 | US | Nebraska | Pierce | 31139 | 514 | 18 | 0 | 496 | 42.26434853 | -97.60122773 | 2020-12-23 05:22:03 | Pierce, Nebraska, US |
3771260 | 3771260 | 2020-12-22 | US | Kentucky | Edmonson | 21061 | 509 | 13 | 0 | 496 | 37.21218923 | -86.23955613 | 2020-12-23 05:22:03 | Edmonson, Kentucky, US |
929623 | 929623 | 2020-12-21 | US | Missouri | Oregon | 29149 | 499 | 3 | 0 | 496 | 36.68710164 | -91.4033755 | 2020-12-22 05:22:33 | Oregon, Missouri, US |
2123067 | 2123067 | 2020-12-20 | US | Virginia | Lexington | 51678 | 499 | 3 | 0 | 496 | 37.78258621 | -79.44262866 | 2020-12-21 05:27:58 | Lexington, Virginia, US |
2120216 | 2120216 | 2020-12-20 | US | Arkansas | Newton | 5101 | 520 | 24 | 0 | 496 | 35.91947491 | -93.21612969 | 2020-12-21 05:27:58 | Newton, Arkansas, US |
2119674 | 2119674 | 2020-12-20 | India | Nagaland | 11842 | 73 | 11273 | 496 | 26.06702 | 94.470302 | 2020-12-21 05:27:58 | Nagaland, India | ||
2933260 | 2933260 | 2020-12-19 | US | Nebraska | Burt | 31021 | 504 | 8 | 0 | 496 | 41.85056773 | -96.32605633 | 2020-12-20 05:27:32 | Burt, Nebraska, 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]);