johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
96 rows where active = 2022 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2343070 | 2343070 | 2021-06-15 | Malaysia | Kedah | 22322 | 181 | 20119 | 2022 | 6.1184 | 100.3685 | 2021-06-16 04:22:32 | Kedah, Malaysia | ||
3970765 | 3970765 | 2021-06-11 | Russia | Krasnodar Krai | 49495 | 3152 | 44321 | 2022 | 45.7684014 | 39.0261044 | 2021-06-12 04:22:22 | Krasnodar Krai, Russia | ||
54434 | 54434 | 2021-05-29 | Ukraine | Zhytomyr Oblast | 87550 | 1738 | 83790 | 2022 | 50.2547 | 28.6587 | 2021-05-30 04:20:55 | Zhytomyr Oblast, Ukraine | ||
888379 | 888379 | 2021-04-26 | Russia | Vologda Oblast | 44654 | 986 | 41646 | 2022 | 60.0391461 | 43.1215213 | 2021-04-27 04:20:52 | Vologda Oblast, Russia | ||
888063 | 888063 | 2021-04-26 | India | Dadra and Nagar Haveli and Daman and Diu | 6726 | 4 | 4700 | 2022 | 20.194742 | 73.080901 | 2021-04-27 04:20:52 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2983493 | 2983493 | 2021-04-10 | Russia | Primorsky Krai | 42849 | 694 | 40133 | 2022 | 45.0819456 | 134.726645 | 2021-04-11 04:20:56 | Primorsky Krai, Russia | ||
3085168 | 3085168 | 2021-04-05 | Congo (Kinshasa) | 28354 | 745 | 25587 | 2022 | -4.0383 | 21.7587 | 2021-04-06 04:20:32 | Congo (Kinshasa) | |||
2780845 | 2780845 | 2021-03-24 | Colombia | Magdalena | 41081 | 1519 | 37540 | 2022 | 10.4113 | -74.4057 | 2021-03-25 05:27:00 | Magdalena, Colombia | ||
2209590 | 2209590 | 2021-03-04 | US | Missouri | Perry | 29157 | 2049 | 27 | 0 | 2022 | 37.70660776 | -89.82741088 | 2021-03-05 05:26:29 | Perry, Missouri, US |
2209514 | 2209514 | 2021-03-04 | US | Missouri | Audrain | 29007 | 2079 | 57 | 0 | 2022 | 39.215877 | -91.84242683 | 2021-03-05 05:26:29 | Audrain, Missouri, US |
2208505 | 2208505 | 2021-03-04 | US | Georgia | Pike | 13231 | 2054 | 32 | 0 | 2022 | 33.09310242 | -84.38790389 | 2021-03-05 05:26:29 | Pike, Georgia, US |
1092011 | 1092011 | 2021-03-03 | US | Missouri | Perry | 29157 | 2049 | 27 | 0 | 2022 | 37.70660776 | -89.82741088 | 2021-03-04 05:24:24 | Perry, Missouri, US |
3256031 | 3256031 | 2021-03-02 | US | Missouri | Crawford | 29055 | 2052 | 30 | 0 | 2022 | 37.97663738 | -91.30528104 | 2021-03-03 05:23:28 | Crawford, Missouri, US |
3255735 | 3255735 | 2021-03-02 | US | Massachusetts | Dukes and Nantucket | 2024 | 3 | 0 | 2022 | 41.40674725 | -70.68763497 | 2021-03-03 05:23:28 | Dukes and Nantucket, Massachusetts, US | |
1000323 | 1000323 | 2021-03-01 | US | Missouri | Crawford | 29055 | 2052 | 30 | 0 | 2022 | 37.97663738 | -91.30528104 | 2021-03-02 05:23:30 | Crawford, Missouri, US |
1000027 | 1000027 | 2021-03-01 | US | Massachusetts | Dukes and Nantucket | 2024 | 3 | 0 | 2022 | 41.40674725 | -70.68763497 | 2021-03-02 05:23:30 | Dukes and Nantucket, Massachusetts, US | |
2370306 | 2370306 | 2021-02-28 | US | South Carolina | Fairfield | 45039 | 2096 | 74 | 0 | 2022 | 34.39287073 | -81.1195624 | 2021-03-01 05:23:01 | Fairfield, South Carolina, US |
2185025 | 2185025 | 2021-02-26 | US | Kentucky | Morgan | 21175 | 2023 | 1 | 0 | 2022 | 37.92465657 | -83.25558245 | 2021-02-27 05:22:28 | Morgan, Kentucky, US |
2183953 | 2183953 | 2021-02-26 | US | Alabama | Hale | 1065 | 2090 | 68 | 0 | 2022 | 32.76039258 | -87.63284988 | 2021-02-27 05:22:28 | Hale, Alabama, US |
471609 | 471609 | 2021-02-19 | Russia | Irkutsk Oblast | 53514 | 1714 | 49778 | 2022 | 56.6370122 | 104.719221 | 2021-02-20 05:22:51 | Irkutsk Oblast, Russia | ||
3051943 | 3051943 | 2021-02-16 | US | Minnesota | Waseca | 27161 | 2039 | 17 | 0 | 2022 | 44.02211116 | -93.58720034 | 2021-02-17 05:23:10 | Waseca, Minnesota, US |
3051807 | 3051807 | 2021-02-16 | US | Michigan | Huron | 26063 | 2080 | 58 | 0 | 2022 | 43.83353985 | -83.04078453 | 2021-02-17 05:23:10 | Huron, Michigan, US |
2284905 | 2284905 | 2021-02-14 | US | Louisiana | Assumption | 22007 | 2055 | 33 | 0 | 2022 | 29.89946234 | -91.06461642 | 2021-02-15 05:24:49 | Assumption, Louisiana, US |
2284622 | 2284622 | 2021-02-14 | US | Iowa | Jackson | 19097 | 2059 | 37 | 0 | 2022 | 42.17178824 | -90.57354837 | 2021-02-15 05:24:49 | Jackson, Iowa, US |
2637925 | 2637925 | 2021-02-11 | Russia | Kaluga Oblast | 27626 | 236 | 25368 | 2022 | 54.4382773 | 35.5272854 | 2021-02-12 05:23:29 | Kaluga Oblast, Russia | ||
977517 | 977517 | 2021-02-06 | US | Oregon | Benton | 41003 | 2036 | 14 | 0 | 2022 | 44.49167306 | -123.4316987 | 2021-02-07 05:23:00 | Benton, Oregon, US |
1676438 | 1676438 | 2021-02-01 | India | Telangana | 294739 | 1602 | 291115 | 2022 | 18.1124 | 79.0193 | 2021-02-02 05:22:49 | Telangana, India | ||
1459962 | 1459962 | 2021-01-31 | Russia | Kaluga Oblast | 25985 | 218 | 23745 | 2022 | 54.4382773 | 35.5272854 | 2021-02-01 05:22:53 | Kaluga Oblast, Russia | ||
2483824 | 2483824 | 2021-01-28 | US | Mississippi | Winston | 28159 | 2093 | 71 | 0 | 2022 | 33.08747908 | -89.03391385 | 2021-01-29 05:22:23 | Winston, Mississippi, US |
3156291 | 3156291 | 2021-01-27 | US | Pennsylvania | Pike | 42103 | 2065 | 43 | 0 | 2022 | 41.33155042 | -75.03208106 | 2021-01-28 05:22:24 | Pike, Pennsylvania, US |
1762738 | 1762738 | 2021-01-24 | US | Washington | Mason | 53045 | 2040 | 18 | 0 | 2022 | 47.35007586 | -123.1863685 | 2021-01-25 05:22:16 | Mason, Washington, US |
2430345 | 2430345 | 2021-01-23 | US | Washington | Mason | 53045 | 2040 | 18 | 0 | 2022 | 47.35007586 | -123.1863685 | 2021-01-24 05:22:35 | Mason, Washington, US |
2428946 | 2428946 | 2021-01-23 | US | Nebraska | Cass | 31025 | 2036 | 14 | 0 | 2022 | 40.90899107 | -96.13971217 | 2021-01-24 05:22:35 | Cass, Nebraska, US |
910445 | 910445 | 2021-01-19 | US | New York | Warren | 36113 | 2062 | 40 | 0 | 2022 | 43.56173026 | -73.8433699 | 2021-01-20 05:21:54 | Warren, New York, US |
3102973 | 3102973 | 2021-01-16 | US | Louisiana | Union | 22111 | 2091 | 69 | 0 | 2022 | 32.83121059 | -92.3749373 | 2021-01-17 05:22:17 | Union, Louisiana, US |
3517866 | 3517866 | 2021-01-15 | US | Ohio | Henry | 39069 | 2078 | 56 | 0 | 2022 | 41.3339642 | -84.06830637 | 2021-01-16 05:22:40 | Henry, Ohio, US |
3516935 | 3516935 | 2021-01-15 | US | Louisiana | Union | 22111 | 2091 | 69 | 0 | 2022 | 32.83121059 | -92.3749373 | 2021-01-16 05:22:40 | Union, Louisiana, US |
2542551 | 2542551 | 2021-01-07 | US | Indiana | Wells | 18179 | 2074 | 52 | 0 | 2022 | 40.72934187 | -85.22132966 | 2021-01-08 05:22:42 | Wells, Indiana, US |
2866675 | 2866675 | 2021-01-06 | US | Missouri | Stoddard | 29207 | 2056 | 34 | 0 | 2022 | 36.85571651 | -89.9444155 | 2021-01-07 05:22:03 | Stoddard, Missouri, US |
2866407 | 2866407 | 2021-01-06 | US | Minnesota | Brown | 27015 | 2055 | 33 | 0 | 2022 | 44.24205652 | -94.72562874 | 2021-01-07 05:22:03 | Brown, Minnesota, US |
3779793 | 3779793 | 2020-12-27 | US | Missouri | Dunklin | 29069 | 2037 | 15 | 0 | 2022 | 36.27167174 | -90.09122243 | 2020-12-28 05:22:06 | Dunklin, Missouri, US |
3694586 | 3694586 | 2020-12-24 | US | Texas | Hill | 48217 | 2545 | 29 | 0 | 2022 | 31.99045053 | -97.13423143 | 2020-12-25 05:22:48 | Hill, Texas, US |
3771663 | 3771663 | 2020-12-22 | US | Mississippi | Copiah | 28029 | 2065 | 43 | 0 | 2022 | 31.86977774 | -90.44565118 | 2020-12-23 05:22:03 | Copiah, Mississippi, US |
2122824 | 2122824 | 2020-12-20 | US | Texas | Hopkins | 48223 | 1610 | 67 | 0 | 2022 | 33.14875072 | -95.56351139 | 2020-12-21 05:27:58 | Hopkins, Texas, US |
3152066 | 3152066 | 2020-12-16 | US | Ohio | Logan | 39091 | 2061 | 39 | 0 | 2022 | 40.38996525 | -83.76784341 | 2020-12-17 05:28:12 | Logan, Ohio, US |
1037499 | 1037499 | 2020-12-15 | US | Texas | Jones | 48253 | 2322 | 18 | 0 | 2022 | 32.73997145 | -99.87861576 | 2020-12-16 05:28:04 | Jones, Texas, US |
1037254 | 1037254 | 2020-12-15 | US | South Dakota | Meade | 46093 | 2042 | 20 | 0 | 2022 | 44.56676791 | -102.7162741 | 2020-12-16 05:28:04 | Meade, South Dakota, US |
2977865 | 2977865 | 2020-12-09 | US | Pennsylvania | Bedford | 42009 | 2077 | 55 | 0 | 2022 | 40.00522157 | -78.48998442 | 2020-12-10 05:26:19 | Bedford, Pennsylvania, US |
1821846 | 1821846 | 2020-12-08 | US | Texas | Deaf Smith | 48117 | 2284 | 43 | 0 | 2022 | 34.96522957 | -102.6054267 | 2020-12-09 05:28:01 | Deaf Smith, Texas, US |
1821130 | 1821130 | 2020-12-08 | US | North Carolina | Pender | 37141 | 2039 | 17 | 0 | 2022 | 34.52265624 | -77.90352133 | 2020-12-09 05:28:01 | Pender, North Carolina, US |
1819719 | 1819719 | 2020-12-08 | US | Idaho | Jerome | 16053 | 2036 | 14 | 0 | 2022 | 42.68891267 | -114.2655033 | 2020-12-09 05:28:01 | Jerome, Idaho, US |
2348384 | 2348384 | 2020-12-07 | US | Illinois | Christian | 17021 | 2056 | 34 | 0 | 2022 | 39.54581621 | -89.27780482 | 2020-12-08 05:27:42 | Christian, Illinois, US |
1633753 | 1633753 | 2020-12-05 | US | Kentucky | Pike | 21195 | 2044 | 22 | 0 | 2022 | 37.47088263 | -82.39487445 | 2020-12-06 05:26:18 | Pike, Kentucky, US |
3862471 | 3862471 | 2020-12-04 | US | Pennsylvania | Bradford | 42015 | 2065 | 43 | 0 | 2022 | 41.78869215 | -76.51570822 | 2020-12-05 05:27:36 | Bradford, Pennsylvania, US |
76802 | 76802 | 2020-12-03 | US | Minnesota | Isanti | 27059 | 2039 | 17 | 0 | 2022 | 45.56181234 | -93.29487636 | 2020-12-04 05:27:27 | Isanti, Minnesota, US |
3567769 | 3567769 | 2020-11-29 | US | Iowa | Lee | 19111 | 2039 | 17 | 0 | 2022 | 40.64181461 | -91.48183025 | 2020-11-30 05:26:13 | Lee, Iowa, US |
2935486 | 2935486 | 2020-11-28 | Russia | Udmurt Republic | 13020 | 280 | 10718 | 2022 | 57.1961165 | 52.69598320000001 | 2020-11-29 05:25:55 | Udmurt Republic, Russia | ||
2787648 | 2787648 | 2020-11-13 | US | Pennsylvania | Cambria | 42021 | 2037 | 15 | 0 | 2022 | 40.49527404 | -78.71377428 | 2020-11-14 05:25:37 | Cambria, Pennsylvania, US |
1991448 | 1991448 | 2020-11-09 | US | South Carolina | Laurens | 45059 | 2085 | 63 | 0 | 2022 | 34.48244419 | -82.00490796 | 2020-11-10 05:40:07 | Laurens, South Carolina, US |
1989718 | 1989718 | 2020-11-09 | US | Indiana | Howard | 18067 | 2098 | 76 | 0 | 2022 | 40.48527731 | -86.11351892 | 2020-11-10 05:40:07 | Howard, Indiana, US |
894710 | 894710 | 2020-11-05 | US | Oklahoma | Wagoner | 40145 | 2053 | 31 | 0 | 2022 | 35.96024096 | -95.51911308 | 2020-11-06 05:24:55 | Wagoner, Oklahoma, US |
893896 | 893896 | 2020-11-05 | US | Mississippi | Bolivar | 28011 | 2103 | 81 | 0 | 2022 | 33.79696941 | -90.87372121 | 2020-11-06 05:24:55 | Bolivar, Mississippi, US |
2499394 | 2499394 | 2020-11-03 | US | Kentucky | Christian | 21047 | 2051 | 29 | 0 | 2022 | 36.89267803 | -87.49055367 | 2020-11-04 05:25:09 | Christian, Kentucky, US |
2082169 | 2082169 | 2020-10-31 | US | New York | Niagara | 36063 | 2124 | 102 | 0 | 2022 | 43.19898042 | -78.74777412 | 2020-11-01 04:36:19 | Niagara, New York, US |
1452785 | 1452785 | 2020-10-27 | Russia | Kaliningrad Oblast | 6442 | 93 | 4327 | 2022 | 54.7293041 | 21.1489473 | 2020-10-28 04:24:39 | Kaliningrad Oblast, Russia | ||
1794418 | 1794418 | 2020-10-19 | Chile | Biobio | 27210 | 418 | 24770 | 2022 | -37.4464 | -72.1416 | 2020-10-20 04:24:22 | Biobio, Chile | ||
3788876 | 3788876 | 2020-10-11 | US | Tennessee | Tipton | 47167 | 2058 | 22 | 0 | 2022 | 35.501942 | -89.73694895 | 2020-10-12 04:23:45 | Tipton, Tennessee, US |
3787660 | 3787660 | 2020-10-11 | US | Minnesota | Wright | 27171 | 2032 | 10 | 0 | 2022 | 45.17297924 | -93.96234781 | 2020-10-12 04:23:45 | Wright, Minnesota, US |
2603764 | 2603764 | 2020-10-10 | US | Minnesota | Nobles | 27105 | 2038 | 16 | 0 | 2022 | 43.67434621 | -95.75329576 | 2020-10-11 04:23:46 | Nobles, Minnesota, US |
3389233 | 3389233 | 2020-10-02 | Colombia | Cesar | 20511 | 630 | 17859 | 2022 | 9.3373 | -73.6536 | 2020-10-03 04:23:40 | Cesar, Colombia | ||
2383025 | 2383025 | 2020-10-01 | US | Virginia | Stafford | 51179 | 2039 | 17 | 0 | 2022 | 38.41758738 | -77.45917053 | 2020-10-02 04:23:51 | Stafford, Virginia, US |
2609441 | 2609441 | 2020-09-24 | US | Washington | Chelan | 53007 | 2039 | 17 | 0 | 2022 | 47.87046092 | -120.6173956 | 2020-09-25 04:23:00 | Chelan, Washington, US |
2654503 | 2654503 | 2020-09-23 | US | Georgia | Baldwin | 13009 | 2078 | 56 | 0 | 2022 | 33.06882326 | -83.24701748 | 2020-09-24 04:23:00 | Baldwin, Georgia, US |
2837532 | 2837532 | 2020-09-21 | US | Florida | Putnam | 12107 | 2060 | 38 | 0 | 2022 | 29.60779729 | -81.74230285 | 2020-09-22 04:23:00 | Putnam, Florida, US |
2851168 | 2851168 | 2020-09-18 | US | North Carolina | Nash | 37127 | 2057 | 35 | 0 | 2022 | 35.96575634 | -77.98422508 | 2020-09-19 04:22:00 | Nash, North Carolina, US |
666209 | 666209 | 2020-09-16 | Haiti | 8499 | 219 | 6258 | 2022 | 18.9712 | -72.2852 | 2020-09-17 04:22:00 | Haiti | |||
1173582 | 1173582 | 2020-09-10 | US | Alabama | Walker | 1127 | 2097 | 75 | 0 | 2022 | 33.80270512 | -87.30027177 | 2020-09-11 04:46:23 | Walker, Alabama, US |
1996950 | 1996950 | 2020-08-26 | Sweden | Halland | 2103 | 81 | 0 | 2022 | 56.8967 | 12.8034 | 2020-08-27 04:28:15 | Halland, Sweden | ||
1481808 | 1481808 | 2020-08-21 | US | New York | Ulster | 36111 | 2115 | 93 | 0 | 2022 | 41.89027881 | -74.26252104 | 2020-08-22 04:27:49 | Ulster, New York, US |
3532037 | 3532037 | 2020-08-12 | US | Colorado | Boulder | 8013 | 2166 | 71 | 0 | 2022 | 40.09313619 | -105.3546767 | 2020-08-13 04:29:15 | Boulder, Colorado, US |
3531732 | 3531732 | 2020-08-12 | Spain | Baleares | 3780 | 225 | 1533 | 2022 | 39.710358 | 2.995148 | 2020-08-13 04:29:15 | Baleares, Spain | ||
3183045 | 3183045 | 2020-07-28 | US | Louisiana | Iberia | 22045 | 2080 | 58 | 0 | 2022 | 29.86803617 | -91.75871777 | 2020-07-29 04:35:11 | Iberia, Louisiana, US |
3737806 | 3737806 | 2020-07-12 | Russia | Smolensk Oblast | 5069 | 76 | 2971 | 2022 | 55.03434960000001 | 33.0192065 | 2020-07-13 04:43:04 | Smolensk Oblast, Russia | ||
887663 | 887663 | 2020-07-07 | Greece | 3589 | 193 | 1374 | 2022 | 39.0742 | 21.8243 | 2020-07-08 05:33:48 | Greece | |||
884152 | 884152 | 2020-07-07 | US | Washington | Benton | 53005 | 2110 | 88 | 0 | 2022 | 46.23946995 | -119.5120834 | 2020-07-08 05:33:48 | Benton, Washington, US |
2972696 | 2972696 | 2020-06-30 | US | South Carolina | Lexington | 45063 | 2071 | 49 | 0 | 2022 | 33.89665987 | -81.27146426 | 2020-07-01 04:33:52 | Lexington, South Carolina, US |
2632736 | 2632736 | 2020-06-29 | Chile | Biobio | 6595 | 50 | 4523 | 2022 | -37.4464 | -72.1416 | 2020-06-30 04:33:48 | Biobio, Chile | ||
2629777 | 2629777 | 2020-06-29 | US | Iowa | Black Hawk | 19013 | 2079 | 57 | 0 | 2022 | 42.4704581 | -92.30524729 | 2020-06-30 04:33:48 | Black Hawk, Iowa, US |
2624983 | 2624983 | 2020-06-25 | Sweden | Gavleborg | 2148 | 126 | 0 | 2022 | 61.3012 | 16.1534 | 2020-06-26 04:33:43 | Gavleborg, Sweden | ||
1192962 | 1192962 | 2020-06-17 | US | North Dakota | Cass | 38017 | 2094 | 62 | 0 | 2022 | 46.93201724 | -97.2444719 | 2020-06-18 04:33:18 | Cass, North Dakota, US |
3060451 | 3060451 | 2020-06-13 | US | Missouri | St. Louis City | 29510 | 2171 | 149 | 0 | 2022 | 38.63555736 | -90.24349225 | 2020-06-14 03:33:15 | St. Louis City, Missouri, US |
3863610 | 3863610 | 2020-06-03 | US | Virginia | Arlington | 51013 | 2142 | 120 | 0 | 2022 | 38.8767675 | -77.10139853 | 2020-06-04 02:33:14 | Arlington, Virginia, US |
2388189 | 2388189 | 2020-05-19 | US | Ohio | Hamilton | 39061 | 2138 | 116 | 0 | 2022 | 39.19673558 | -84.54502924 | 2020-05-20 02:32:19 | Hamilton, Ohio, US |
1931949 | 1931949 | 2020-05-05 | Denmark | 9821 | 503 | 7296 | 2022 | 56.2639 | 9.5018 | 2020-05-06 02:32:31 | Denmark | |||
1183094 | 1183094 | 2020-05-01 | US | Pennsylvania | Northampton | 42095 | 2116 | 94 | 0 | 2022 | 40.75182733 | -75.30471829 | 2020-05-02 02:32:27 | Northampton, Pennsylvania, US |
49032 | 49032 | 2020-04-17 | US | New Jersey | Mercer | 34021 | 2123 | 101 | 0 | 2022 | 40.28047017 | -74.70479631 | 2020-04-17 23:30:52 | Mercer, New Jersey, 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]);