johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
129 rows where confirmed = 5536 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331396 | 331396 | 2022-12-27 | US | West Virginia | Hardy | 54031 | 5536 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-28 04:21:04 | Hardy, West Virginia, US | |
2951192 | 2951192 | 2022-12-20 | China | Shaanxi | 5536 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-21 04:21:03 | Shaanxi, China | |||
3173594 | 3173594 | 2022-12-19 | China | Shaanxi | 5536 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-20 04:21:04 | Shaanxi, China | |||
310238 | 310238 | 2022-12-13 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-14 04:21:04 | Northampton, North Carolina, US | |
1151299 | 1151299 | 2022-12-12 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-13 04:21:01 | Northampton, North Carolina, US | |
871153 | 871153 | 2022-12-11 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-12 04:21:01 | Northampton, North Carolina, US | |
259683 | 259683 | 2022-12-10 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-11 04:20:50 | Northampton, North Carolina, US | |
3938397 | 3938397 | 2022-12-09 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-10 04:21:02 | Northampton, North Carolina, US | |
3379729 | 3379729 | 2022-12-08 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-09 04:21:05 | Northampton, North Carolina, US | |
1987000 | 1987000 | 2022-12-07 | US | North Carolina | Northampton | 37131 | 5536 | 93 | 0 | 36.41736238 | -77.39769443 | 2022-12-08 04:21:07 | Northampton, North Carolina, US | |
2557763 | 2557763 | 2022-11-29 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-30 04:21:07 | Carroll, Iowa, US | |
1240837 | 1240837 | 2022-11-28 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-29 04:21:05 | Carroll, Iowa, US | |
3552825 | 3552825 | 2022-11-27 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-28 04:21:02 | Carroll, Iowa, US | |
2101305 | 2101305 | 2022-11-26 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-27 04:21:05 | Carroll, Iowa, US | |
488796 | 488796 | 2022-11-25 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-26 04:21:11 | Carroll, Iowa, US | |
3524625 | 3524625 | 2022-11-24 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-25 04:21:06 | Carroll, Iowa, US | |
3313408 | 3313408 | 2022-11-23 | US | Iowa | Carroll | 19027 | 5536 | 78 | 0 | 42.03617207 | -94.86032705 | 2022-11-24 04:21:09 | Carroll, Iowa, US | |
320452 | 320452 | 2022-10-30 | US | Arkansas | Phillips | 5107 | 5536 | 103 | 0 | 34.43268455 | -90.84800154 | 2022-10-31 04:21:36 | Phillips, Arkansas, US | |
1833588 | 1833588 | 2022-10-25 | US | Washington | Adams | 53001 | 5536 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-26 04:22:19 | Adams, Washington, US | |
797849 | 797849 | 2022-10-24 | US | Washington | Adams | 53001 | 5536 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-25 04:21:53 | Adams, Washington, US | |
3280304 | 3280304 | 2022-10-23 | US | Washington | Adams | 53001 | 5536 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-24 04:22:29 | Adams, Washington, US | |
2271342 | 2271342 | 2022-10-22 | US | Washington | Adams | 53001 | 5536 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-23 04:22:46 | Adams, Washington, US | |
1595642 | 1595642 | 2022-10-21 | US | Washington | Adams | 53001 | 5536 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-22 04:22:53 | Adams, Washington, US | |
1627512 | 1627512 | 2022-09-22 | US | Texas | Scurry | 48415 | 5536 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-23 04:23:13 | Scurry, Texas, US | |
1625428 | 1625428 | 2022-09-22 | US | Indiana | Rush | 18139 | 5536 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-09-23 04:23:13 | Rush, Indiana, US | |
1373716 | 1373716 | 2022-09-21 | US | Texas | Scurry | 48415 | 5536 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-22 04:22:56 | Scurry, Texas, US | |
1371632 | 1371632 | 2022-09-21 | US | Indiana | Rush | 18139 | 5536 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-09-22 04:22:56 | Rush, Indiana, US | |
3951530 | 3951530 | 2022-08-17 | US | Illinois | Pike | 17149 | 5536 | 68 | 0 | 39.62265059 | -90.8877017 | 2022-08-18 04:21:11 | Pike, Illinois, US | |
1086505 | 1086505 | 2022-08-09 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-10 04:20:57 | Kodiak Island, Alaska, US | |
3543920 | 3543920 | 2022-08-08 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-09 04:20:34 | Kodiak Island, Alaska, US | |
1070323 | 1070323 | 2022-08-07 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-08 04:21:08 | Kodiak Island, Alaska, US | |
1940911 | 1940911 | 2022-08-06 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-07 04:20:54 | Kodiak Island, Alaska, US | |
880710 | 880710 | 2022-08-05 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-06 04:20:56 | Kodiak Island, Alaska, US | |
2009121 | 2009121 | 2022-08-04 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-05 04:20:52 | Kodiak Island, Alaska, US | |
1098548 | 1098548 | 2022-08-03 | US | Alaska | Kodiak Island | 2150 | 5536 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-08-04 04:20:58 | Kodiak Island, Alaska, US | |
899543 | 899543 | 2022-07-24 | US | Virginia | Prince Edward | 51147 | 5536 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-25 04:20:51 | Prince Edward, Virginia, US | |
94537 | 94537 | 2022-07-23 | US | Virginia | Prince Edward | 51147 | 5536 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-24 04:20:47 | Prince Edward, Virginia, US | |
903559 | 903559 | 2022-07-22 | US | Virginia | Prince Edward | 51147 | 5536 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-23 04:20:53 | Prince Edward, Virginia, US | |
961508 | 961508 | 2022-07-19 | US | Oregon | Clatsop | 41007 | 5536 | 54 | 0 | 45.99712889 | -123.660711 | 2022-07-20 04:20:59 | Clatsop, Oregon, US | |
1648851 | 1648851 | 2022-06-23 | US | Arkansas | Clark | 5019 | 5536 | 82 | 0 | 34.04613432 | -93.17484713 | 2022-06-24 04:20:58 | Clark, Arkansas, US | |
3273074 | 3273074 | 2022-06-19 | US | Wisconsin | Langlade | 55067 | 5536 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-06-20 04:21:01 | Langlade, Wisconsin, US | |
3400986 | 3400986 | 2022-06-18 | US | Wisconsin | Langlade | 55067 | 5536 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-06-19 04:20:51 | Langlade, Wisconsin, US | |
2314863 | 2314863 | 2022-06-17 | US | Wisconsin | Langlade | 55067 | 5536 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-06-18 04:21:10 | Langlade, Wisconsin, US | |
949118 | 949118 | 2022-06-14 | US | New York | Schoharie | 36095 | 5536 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-06-15 04:20:54 | Schoharie, New York, US | |
1421581 | 1421581 | 2022-06-08 | US | Arkansas | Conway | 5029 | 5536 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-06-09 04:20:54 | Conway, Arkansas, US | |
232718 | 232718 | 2022-05-31 | US | West Virginia | Lewis | 54041 | 5536 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-06-01 04:20:55 | Lewis, West Virginia, US | |
3725693 | 3725693 | 2022-04-25 | US | West Virginia | Lincoln | 54043 | 5536 | 81 | 0 | 38.172154 | -82.07017953 | 2022-04-26 04:20:51 | Lincoln, West Virginia, US | |
1846420 | 1846420 | 2022-04-18 | US | American Samoa | 60 | 5536 | 18 | 0 | -14.270999999999999 | -170.132 | 2022-04-19 04:21:00 | American Samoa, US | ||
3417364 | 3417364 | 2022-04-17 | US | American Samoa | 60 | 5536 | 18 | 0 | -14.270999999999999 | -170.132 | 2022-04-18 04:21:12 | American Samoa, US | ||
304313 | 304313 | 2022-04-16 | US | American Samoa | 60 | 5536 | 18 | 0 | -14.270999999999999 | -170.132 | 2022-04-17 04:20:59 | American Samoa, US | ||
2670258 | 2670258 | 2022-04-15 | US | American Samoa | 60 | 5536 | 18 | 0 | -14.270999999999999 | -170.132 | 2022-04-16 04:20:48 | American Samoa, US | ||
1224043 | 1224043 | 2022-04-14 | US | American Samoa | 60 | 5536 | 18 | 0 | -14.270999999999999 | -170.132 | 2022-04-15 04:20:57 | American Samoa, US | ||
1952186 | 1952186 | 2022-04-12 | Vanuatu | 5536 | 6 | 0 | -15.3767 | 166.9592 | 2022-04-13 04:21:03 | Vanuatu | ||||
3631345 | 3631345 | 2022-03-13 | US | Virginia | Page | 51139 | 5536 | 118 | 0 | 38.61807452 | -78.48797204 | 2022-03-14 04:20:46 | Page, Virginia, US | |
954253 | 954253 | 2022-03-12 | US | Virginia | Page | 51139 | 5536 | 118 | 0 | 38.61807452 | -78.48797204 | 2022-03-13 04:20:49 | Page, Virginia, US | |
359714 | 359714 | 2022-03-11 | US | Virginia | Page | 51139 | 5536 | 118 | 0 | 38.61807452 | -78.48797204 | 2022-03-12 04:20:50 | Page, Virginia, US | |
1548241 | 1548241 | 2022-03-07 | Saint Kitts and Nevis | 5536 | 42 | 0 | 17.357822 | -62.782998 | 2022-03-08 04:20:54 | Saint Kitts and Nevis | ||||
2199910 | 2199910 | 2022-03-06 | Saint Kitts and Nevis | 5536 | 42 | 0 | 17.357822 | -62.782998 | 2022-03-07 04:20:47 | Saint Kitts and Nevis | ||||
2092367 | 2092367 | 2022-03-05 | Saint Kitts and Nevis | 5536 | 42 | 0 | 17.357822 | -62.782998 | 2022-03-06 04:20:49 | Saint Kitts and Nevis | ||||
1645975 | 1645975 | 2022-03-03 | US | Michigan | Alpena | 26007 | 5536 | 133 | 0 | 45.03477666 | -83.62212411 | 2022-03-04 04:21:09 | Alpena, Michigan, US | |
2526978 | 2526978 | 2022-03-02 | US | Michigan | Alpena | 26007 | 5536 | 133 | 0 | 45.03477666 | -83.62212411 | 2022-03-03 04:21:01 | Alpena, Michigan, US | |
1995678 | 1995678 | 2022-03-01 | US | Texas | Austin | 48015 | 5536 | 71 | 0 | 29.88548725 | -96.27736949 | 2022-03-02 04:21:07 | Austin, Texas, US | |
1994149 | 1994149 | 2022-03-01 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-03-02 04:21:07 | Assumption, Louisiana, US | |
944323 | 944323 | 2022-02-28 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-03-01 04:21:09 | Assumption, Louisiana, US | |
2734514 | 2734514 | 2022-02-27 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-02-28 04:21:05 | Assumption, Louisiana, US | |
3047667 | 3047667 | 2022-02-26 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-02-27 04:21:04 | Assumption, Louisiana, US | |
576322 | 576322 | 2022-02-25 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-02-26 04:21:12 | Assumption, Louisiana, US | |
1512898 | 1512898 | 2022-02-24 | US | Louisiana | Assumption | 22007 | 5536 | 68 | 0 | 29.89946234 | -91.06461642 | 2022-02-25 04:21:11 | Assumption, Louisiana, US | |
1465531 | 1465531 | 2022-02-10 | US | Kentucky | Meade | 21163 | 5536 | 61 | 0 | 37.96163597 | -86.21028219 | 2022-02-11 04:21:09 | Meade, Kentucky, US | |
1465507 | 1465507 | 2022-02-10 | US | Kentucky | Johnson | 21115 | 5536 | 86 | 0 | 37.85106355 | -82.8264322 | 2022-02-11 04:21:09 | Johnson, Kentucky, US | |
3074857 | 3074857 | 2022-02-09 | US | Georgia | Grady | 13131 | 5536 | 102 | 0 | 30.87454847 | -84.23418364 | 2022-02-10 04:21:14 | Grady, Georgia, US | |
2611455 | 2611455 | 2022-01-06 | US | Kentucky | Grayson | 21085 | 5536 | 109 | 0 | 37.46231118 | -86.34248968 | 2022-01-07 04:22:09 | Grayson, Kentucky, US | |
1288189 | 1288189 | 2022-01-04 | US | New Jersey | Unassigned | 90034 | 5536 | 0 | 0 | 41.13891592 | 0.0 | 2022-01-05 04:21:59 | Unassigned, New Jersey, US | |
2170351 | 2170351 | 2022-01-01 | US | Puerto Rico | Vega Baja | 72145 | 5536 | 0 | 0 | 18.428262 | -66.397924 | 2022-01-02 04:20:52 | Vega Baja, Puerto Rico, US | |
2779782 | 2779782 | 2021-12-31 | US | Puerto Rico | Vega Baja | 72145 | 5536 | 0 | 0 | 18.428262 | -66.397924 | 2022-01-01 04:22:14 | Vega Baja, Puerto Rico, US | |
2907178 | 2907178 | 2021-12-19 | US | Washington | Stevens | 53065 | 5536 | 108 | 0 | 48.40035475 | -117.8542701 | 2021-12-20 04:21:43 | Stevens, Washington, US | |
1262251 | 1262251 | 2021-12-18 | US | Washington | Stevens | 53065 | 5536 | 108 | 0 | 48.40035475 | -117.8542701 | 2021-12-19 04:21:11 | Stevens, Washington, US | |
2402279 | 2402279 | 2021-12-17 | US | Washington | Stevens | 53065 | 5536 | 108 | 0 | 48.40035475 | -117.8542701 | 2021-12-18 02:22:20 | Stevens, Washington, US | |
3865 | 3865 | 2021-12-02 | US | Wisconsin | Clark | 55019 | 5536 | 87 | 0 | 44.73483377 | -90.61207486 | 2021-12-03 04:23:05 | Clark, Wisconsin, US | |
152816 | 152816 | 2021-11-29 | US | South Carolina | Marion | 45067 | 5536 | 143 | 0 | 34.07859748 | -79.36400756 | 2021-11-30 04:22:53 | Marion, South Carolina, US | |
1805248 | 1805248 | 2021-11-25 | US | Ohio | Perry | 39127 | 5536 | 85 | 0 | 39.73508655 | -82.23804971 | 2021-11-26 04:22:33 | Perry, Ohio, US | |
906682 | 906682 | 2021-11-24 | US | Ohio | Perry | 39127 | 5536 | 85 | 0 | 39.73508655 | -82.23804971 | 2021-11-25 04:22:33 | Perry, Ohio, US | |
164995 | 164995 | 2021-11-19 | US | Tennessee | Macon | 47111 | 5536 | 94 | 0 | 36.53157855 | -86.00778595 | 2021-11-20 04:22:17 | Macon, Tennessee, US | |
715878 | 715878 | 2021-11-12 | US | Kentucky | Harlan | 21095 | 5536 | 133 | 0 | 36.85699301 | -83.21899516 | 2021-11-13 04:21:38 | Harlan, Kentucky, US | |
29387 | 29387 | 2021-11-11 | US | Illinois | Christian | 17021 | 5536 | 83 | 0 | 39.54581621 | -89.27780482 | 2021-11-12 04:22:01 | Christian, Illinois, US | |
2845826 | 2845826 | 2021-11-10 | US | Illinois | Christian | 17021 | 5536 | 83 | 0 | 39.54581621 | -89.27780482 | 2021-11-11 04:21:45 | Christian, Illinois, US | |
637576 | 637576 | 2021-10-13 | United Kingdom | Bermuda | 5536 | 92 | 0 | 32.3078 | -64.7505 | 2021-10-14 04:21:29 | Bermuda, United Kingdom | |||
1495254 | 1495254 | 2021-10-12 | United Kingdom | Bermuda | 5536 | 92 | 0 | 32.3078 | -64.7505 | 2021-10-13 04:20:51 | Bermuda, United Kingdom | |||
3009841 | 3009841 | 2021-10-11 | US | Ohio | Preble | 39135 | 5536 | 131 | 0 | 39.7420247 | -84.64787018 | 2021-10-12 04:21:09 | Preble, Ohio, US | |
2774958 | 2774958 | 2021-09-30 | US | Missouri | Webster | 29225 | 5536 | 86 | 0 | 37.2813734 | -92.876329 | 2021-10-01 04:21:35 | Webster, Missouri, US | |
601676 | 601676 | 2021-09-23 | Japan | Aomori | 5536 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-24 04:21:44 | Aomori, Japan | |||
1386092 | 1386092 | 2021-09-13 | US | Arkansas | Baxter | 5005 | 5536 | 158 | 0 | 36.28784385 | -92.33782872 | 2021-09-14 04:21:41 | Baxter, Arkansas, US | |
1265953 | 1265953 | 2021-09-09 | US | Texas | Matagorda | 48321 | 5536 | 127 | 0 | 28.81955746 | -96.01230294 | 2021-09-10 04:21:20 | Matagorda, Texas, US | |
652650 | 652650 | 2021-08-09 | US | Pennsylvania | Mifflin | 42087 | 5536 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-08-10 04:21:27 | Mifflin, Pennsylvania, US | |
651377 | 651377 | 2021-08-09 | US | Kentucky | Henderson | 21101 | 5536 | 80 | 0 | 37.79344553 | -87.57392021 | 2021-08-10 04:21:27 | Henderson, Kentucky, US | |
591541 | 591541 | 2021-08-08 | US | Missouri | Johnson | 29101 | 5536 | 60 | 0 | 38.74719601 | -93.80691168 | 2021-08-09 04:21:24 | Johnson, Missouri, US | |
3470684 | 3470684 | 2021-08-03 | US | Ohio | Sandusky | 39143 | 5536 | 131 | 0 | 41.35624126 | -83.137872 | 2021-08-04 04:21:25 | Sandusky, Ohio, US | |
1332123 | 1332123 | 2021-07-24 | US | Missouri | Callaway | 29027 | 5536 | 51 | 0 | 38.83674754 | -91.92186505 | 2021-07-25 04:22:12 | Callaway, Missouri, US | |
3031457 | 3031457 | 2021-06-16 | US | Iowa | Cerro Gordo | 19033 | 5536 | 93 | 0 | 43.08177563 | -93.2612239 | 2021-06-17 04:22:36 | Cerro Gordo, Iowa, US | |
3955074 | 3955074 | 2021-05-11 | US | California | Tehama | 6103 | 5536 | 62 | 0 | 40.12570935 | -122.2370171 | 2021-05-12 04:21:29 | Tehama, California, 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]);