johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
165 rows where confirmed = 3755 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311019 | 311019 | 2022-12-13 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-14 04:21:04 | Jackson, Texas, US | |
1152080 | 1152080 | 2022-12-12 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-13 04:21:01 | Jackson, Texas, US | |
871934 | 871934 | 2022-12-11 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-12 04:21:01 | Jackson, Texas, US | |
260464 | 260464 | 2022-12-10 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-11 04:20:50 | Jackson, Texas, US | |
3939178 | 3939178 | 2022-12-09 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-10 04:21:02 | Jackson, Texas, US | |
3380510 | 3380510 | 2022-12-08 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-09 04:21:05 | Jackson, Texas, US | |
1987781 | 1987781 | 2022-12-07 | US | Texas | Jackson | 48239 | 3755 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-12-08 04:21:07 | Jackson, Texas, US | |
3574177 | 3574177 | 2022-09-19 | US | Wisconsin | Price | 55099 | 3755 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-09-20 04:22:48 | Price, Wisconsin, US | |
2891140 | 2891140 | 2022-08-12 | US | Puerto Rico | Florida | 72054 | 3755 | 0 | 0 | 18.373715 | -66.560488 | 2022-08-13 04:20:52 | Florida, Puerto Rico, US | |
1101700 | 1101700 | 2022-08-03 | US | Wisconsin | Rusk | 55107 | 3755 | 59 | 0 | 45.47498854 | -91.1333012 | 2022-08-04 04:20:58 | Rusk, Wisconsin, US | |
3871345 | 3871345 | 2022-07-31 | China | Beijing | 3755 | 9 | 0 | 40.1824 | 116.4142 | 2022-08-01 04:21:03 | Beijing, China | |||
166669 | 166669 | 2022-06-21 | US | Colorado | Grand | 8049 | 3755 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-06-22 04:20:54 | Grand, Colorado, US | |
2311938 | 2311938 | 2022-06-17 | US | Colorado | Las Animas | 8071 | 3755 | 44 | 0 | 37.3153406 | -104.0376458 | 2022-06-18 04:21:10 | Las Animas, Colorado, US | |
230433 | 230433 | 2022-05-31 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-06-01 04:20:55 | Iowa, Iowa, US | |
3187198 | 3187198 | 2022-05-30 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-31 04:20:51 | Iowa, Iowa, US | |
3186374 | 3186374 | 2022-05-30 | US | Alabama | Lamar | 1075 | 3755 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-31 04:20:51 | Lamar, Alabama, US | |
3199347 | 3199347 | 2022-05-29 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-30 04:20:50 | Iowa, Iowa, US | |
3198523 | 3198523 | 2022-05-29 | US | Alabama | Lamar | 1075 | 3755 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-30 04:20:50 | Lamar, Alabama, US | |
2726225 | 2726225 | 2022-05-28 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-29 04:20:53 | Iowa, Iowa, US | |
2725401 | 2725401 | 2022-05-28 | US | Alabama | Lamar | 1075 | 3755 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-29 04:20:53 | Lamar, Alabama, US | |
1315406 | 1315406 | 2022-05-27 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-28 04:21:07 | Iowa, Iowa, US | |
1314582 | 1314582 | 2022-05-27 | US | Alabama | Lamar | 1075 | 3755 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-28 04:21:07 | Lamar, Alabama, US | |
1851198 | 1851198 | 2022-05-26 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-27 04:20:56 | Iowa, Iowa, US | |
2049074 | 2049074 | 2022-05-25 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-26 04:20:50 | Iowa, Iowa, US | |
3595649 | 3595649 | 2022-05-23 | US | Oregon | Hood River | 41027 | 3755 | 44 | 0 | 45.51872811 | -121.6552036 | 2022-05-24 04:20:57 | Hood River, Oregon, US | |
624814 | 624814 | 2022-05-22 | US | Tennessee | Decatur | 47039 | 3755 | 70 | 0 | 35.60048904 | -88.11043779 | 2022-05-26 04:20:50 | Decatur, Tennessee, US | |
623085 | 623085 | 2022-05-22 | US | Iowa | Iowa | 19095 | 3755 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-05-26 04:20:50 | Iowa, Iowa, US | |
2334742 | 2334742 | 2022-05-08 | US | Virginia | King William | 51101 | 3755 | 44 | 0 | 37.70965316 | -77.09384941 | 2022-05-09 04:20:54 | King William, Virginia, US | |
363704 | 363704 | 2022-05-07 | US | Virginia | King William | 51101 | 3755 | 44 | 0 | 37.70965316 | -77.09384941 | 2022-05-08 04:20:49 | King William, Virginia, US | |
1401055 | 1401055 | 2022-05-06 | US | Virginia | King William | 51101 | 3755 | 44 | 0 | 37.70965316 | -77.09384941 | 2022-05-07 04:21:09 | King William, Virginia, US | |
2480701 | 2480701 | 2022-03-30 | US | Puerto Rico | Catano | 72033 | 3755 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-31 04:20:56 | Catano, Puerto Rico, US | |
1471184 | 1471184 | 2022-03-24 | US | Texas | Falls | 48145 | 3755 | 63 | 0 | 31.25350609 | -96.93630086 | 2022-03-25 04:20:46 | Falls, Texas, US | |
3631439 | 3631439 | 2022-03-13 | US | West Virginia | Grant | 54023 | 3755 | 56 | 0 | 39.10314817 | -79.19440518 | 2022-03-14 04:20:46 | Grant, West Virginia, US | |
954347 | 954347 | 2022-03-12 | US | West Virginia | Grant | 54023 | 3755 | 56 | 0 | 39.10314817 | -79.19440518 | 2022-03-13 04:20:49 | Grant, West Virginia, US | |
359808 | 359808 | 2022-03-11 | US | West Virginia | Grant | 54023 | 3755 | 56 | 0 | 39.10314817 | -79.19440518 | 2022-03-12 04:20:50 | Grant, West Virginia, US | |
3820803 | 3820803 | 2022-02-16 | US | Alabama | Crenshaw | 1041 | 3755 | 86 | 0 | 31.72941803 | -86.31593104 | 2022-02-17 04:20:56 | Crenshaw, Alabama, US | |
3075981 | 3075981 | 2022-02-09 | US | Missouri | Moniteau | 29135 | 3755 | 50 | 0 | 38.63571781 | -92.57976951 | 2022-02-10 04:21:14 | Moniteau, Missouri, US | |
74103 | 74103 | 2022-02-07 | US | Texas | Andrews | 48003 | 3755 | 69 | 0 | 32.30468633 | -102.63765479999999 | 2022-02-08 04:21:15 | Andrews, Texas, US | |
2327751 | 2327751 | 2022-02-04 | US | Alabama | Macon | 1087 | 3755 | 71 | 0 | 32.38759944 | -85.69267724 | 2022-02-05 04:21:05 | Macon, Alabama, US | |
3301234 | 3301234 | 2022-01-30 | US | Illinois | Mercer | 17131 | 3755 | 40 | 0 | 41.20596782 | -90.74290052 | 2022-01-31 04:21:09 | Mercer, Illinois, US | |
3063025 | 3063025 | 2022-01-29 | US | Illinois | Mercer | 17131 | 3755 | 40 | 0 | 41.20596782 | -90.74290052 | 2022-01-30 04:21:26 | Mercer, Illinois, US | |
3810959 | 3810959 | 2022-01-28 | US | Illinois | Mercer | 17131 | 3755 | 40 | 0 | 41.20596782 | -90.74290052 | 2022-01-29 04:21:10 | Mercer, Illinois, US | |
1319938 | 1319938 | 2022-01-26 | US | Minnesota | Houston | 27055 | 3755 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-01-27 04:21:19 | Houston, Minnesota, US | |
1962699 | 1962699 | 2022-01-20 | US | Nevada | Humboldt | 32013 | 3755 | 46 | 0 | 41.40692186 | -118.11094270000001 | 2022-01-21 04:21:09 | Humboldt, Nevada, US | |
1475269 | 1475269 | 2022-01-17 | US | Texas | Lavaca | 48285 | 3755 | 100 | 0 | 29.38508402 | -96.93186692 | 2022-01-18 04:21:04 | Lavaca, Texas, US | |
3688947 | 3688947 | 2022-01-13 | US | Kentucky | Rockcastle | 21203 | 3755 | 48 | 0 | 37.36642393 | -84.31176452 | 2022-01-14 04:21:54 | Rockcastle, Kentucky, US | |
1693168 | 1693168 | 2022-01-10 | US | Georgia | Morgan | 13211 | 3755 | 52 | 0 | 33.59232073 | -83.49129491 | 2022-01-11 04:22:01 | Morgan, Georgia, US | |
1393326 | 1393326 | 2022-01-07 | United Kingdom | Turks and Caicos Islands | 3755 | 26 | 0 | 21.69400000000001 | -71.7979 | 2022-01-08 04:21:53 | Turks and Caicos Islands, United Kingdom | |||
2613713 | 2613713 | 2022-01-06 | United Kingdom | Turks and Caicos Islands | 3755 | 26 | 0 | 21.69400000000001 | -71.7979 | 2022-01-07 04:22:09 | Turks and Caicos Islands, United Kingdom | |||
1289143 | 1289143 | 2022-01-04 | US | Texas | Jones | 48253 | 3755 | 80 | 0 | 32.73997145 | -99.87861576 | 2022-01-05 04:21:59 | Jones, Texas, US | |
1669269 | 1669269 | 2021-12-29 | US | Georgia | Grady | 13131 | 3755 | 93 | 0 | 30.87454847 | -84.23418364 | 2021-12-30 04:21:25 | Grady, Georgia, US | |
3605346 | 3605346 | 2021-12-25 | Sao Tome and Principe | 3755 | 57 | 0 | 0.1864 | 6.6131 | 2021-12-26 04:21:50 | Sao Tome and Principe | ||||
2904840 | 2904840 | 2021-12-19 | US | Indiana | Owen | 18119 | 3755 | 80 | 0 | 39.31145587 | -86.83900724 | 2021-12-20 04:21:43 | Owen, Indiana, US | |
1259913 | 1259913 | 2021-12-18 | US | Indiana | Owen | 18119 | 3755 | 80 | 0 | 39.31145587 | -86.83900724 | 2021-12-19 04:21:11 | Owen, Indiana, US | |
2399941 | 2399941 | 2021-12-17 | US | Indiana | Owen | 18119 | 3755 | 80 | 0 | 39.31145587 | -86.83900724 | 2021-12-18 02:22:20 | Owen, Indiana, US | |
407330 | 407330 | 2021-12-07 | US | Texas | Burleson | 48051 | 3755 | 60 | 0 | 30.49273808 | -96.62158484 | 2021-12-08 04:22:46 | Burleson, Texas, US | |
1146704 | 1146704 | 2021-12-01 | US | Minnesota | Wabasha | 27157 | 3755 | 10 | 0 | 44.28424356 | -92.23121312 | 2021-12-02 04:22:37 | Wabasha, Minnesota, US | |
3071161 | 3071161 | 2021-11-23 | US | Indiana | Randolph | 18135 | 3755 | 107 | 0 | 40.15734772 | -85.01139319 | 2021-11-24 04:22:14 | Randolph, Indiana, US | |
1017272 | 1017272 | 2021-11-21 | US | Tennessee | Fentress | 47049 | 3755 | 68 | 0 | 36.38128818 | -84.92870012 | 2021-11-22 04:22:20 | Fentress, Tennessee, US | |
725436 | 725436 | 2021-11-20 | US | Tennessee | Fentress | 47049 | 3755 | 68 | 0 | 36.38128818 | -84.92870012 | 2021-11-21 04:22:13 | Fentress, Tennessee, US | |
1325726 | 1325726 | 2021-11-14 | US | West Virginia | Mason | 54053 | 3755 | 59 | 0 | 38.77071799 | -82.02524219 | 2021-11-15 04:21:36 | Mason, West Virginia, US | |
1325657 | 1325657 | 2021-11-14 | US | Virginia | Winchester | 51840 | 3755 | 56 | 0 | 39.17054517 | -78.17325058 | 2021-11-15 04:21:36 | Winchester, Virginia, US | |
1324036 | 1324036 | 2021-11-14 | US | Mississippi | Grenada | 28043 | 3755 | 109 | 0 | 33.77036166 | -89.80245083 | 2021-11-15 04:21:36 | Grenada, Mississippi, US | |
1323538 | 1323538 | 2021-11-14 | US | Kansas | Labette | 20099 | 3755 | 62 | 0 | 37.19113093 | -95.29849679 | 2021-11-15 04:21:36 | Labette, Kansas, US | |
689783 | 689783 | 2021-11-13 | US | Virginia | Winchester | 51840 | 3755 | 56 | 0 | 39.17054517 | -78.17325058 | 2021-11-14 04:21:31 | Winchester, Virginia, US | |
688162 | 688162 | 2021-11-13 | US | Mississippi | Grenada | 28043 | 3755 | 109 | 0 | 33.77036166 | -89.80245083 | 2021-11-14 04:21:31 | Grenada, Mississippi, US | |
687664 | 687664 | 2021-11-13 | US | Kansas | Labette | 20099 | 3755 | 62 | 0 | 37.19113093 | -95.29849679 | 2021-11-14 04:21:31 | Labette, Kansas, US | |
717892 | 717892 | 2021-11-12 | US | Virginia | Winchester | 51840 | 3755 | 56 | 0 | 39.17054517 | -78.17325058 | 2021-11-13 04:21:38 | Winchester, Virginia, US | |
716942 | 716942 | 2021-11-12 | US | Ohio | Hocking | 39073 | 3755 | 93 | 0 | 39.49537927 | -82.47991446 | 2021-11-13 04:21:38 | Hocking, Ohio, US | |
716271 | 716271 | 2021-11-12 | US | Mississippi | Grenada | 28043 | 3755 | 109 | 0 | 33.77036166 | -89.80245083 | 2021-11-13 04:21:38 | Grenada, Mississippi, US | |
715773 | 715773 | 2021-11-12 | US | Kansas | Labette | 20099 | 3755 | 62 | 0 | 37.19113093 | -95.29849679 | 2021-11-13 04:21:38 | Labette, Kansas, US | |
3642917 | 3642917 | 2021-11-08 | US | Virginia | Lee | 51105 | 3755 | 60 | 0 | 36.70586667 | -83.12606515 | 2021-11-09 04:21:36 | Lee, Virginia, US | |
3640195 | 3640195 | 2021-11-08 | US | Colorado | Morgan | 8087 | 3755 | 115 | 0 | 40.26279810000001 | -103.8093302 | 2021-11-09 04:21:36 | Morgan, Colorado, US | |
3512872 | 3512872 | 2021-11-01 | US | Kentucky | Russell | 21207 | 3755 | 56 | 0 | 36.99308373 | -85.06070117 | 2021-11-02 04:22:03 | Russell, Kentucky, US | |
288796 | 288796 | 2021-10-31 | US | Georgia | Fannin | 13111 | 3755 | 106 | 0 | 34.86430205 | -84.316964 | 2021-11-01 04:22:01 | Fannin, Georgia, US | |
2721802 | 2721802 | 2021-10-30 | US | Georgia | Fannin | 13111 | 3755 | 106 | 0 | 34.86430205 | -84.316964 | 2021-10-31 04:22:08 | Fannin, Georgia, US | |
567904 | 567904 | 2021-10-29 | US | Georgia | Fannin | 13111 | 3755 | 106 | 0 | 34.86430205 | -84.316964 | 2021-10-30 04:22:03 | Fannin, Georgia, US | |
3493459 | 3493459 | 2021-10-26 | US | Kansas | Franklin | 20059 | 3755 | 58 | 0 | 38.56443815 | -95.28644341 | 2021-10-27 04:22:32 | Franklin, Kansas, US | |
3795181 | 3795181 | 2021-10-25 | US | Kansas | Franklin | 20059 | 3755 | 58 | 0 | 38.56443815 | -95.28644341 | 2021-10-26 04:22:09 | Franklin, Kansas, US | |
2124167 | 2124167 | 2021-10-21 | US | Alaska | Juneau | 2110 | 3755 | 11 | 0 | 58.45031811 | -134.200436 | 2021-10-22 04:21:14 | Juneau, Alaska, US | |
600269 | 600269 | 2021-10-19 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-20 04:21:00 | Seminole, Oklahoma, US | |
2046446 | 2046446 | 2021-10-18 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-19 04:20:54 | Seminole, Oklahoma, US | |
1911807 | 1911807 | 2021-10-17 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-18 04:21:10 | Seminole, Oklahoma, US | |
937396 | 937396 | 2021-10-16 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-17 04:21:29 | Seminole, Oklahoma, US | |
2945951 | 2945951 | 2021-10-15 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-16 04:21:15 | Seminole, Oklahoma, US | |
494231 | 494231 | 2021-10-14 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-15 04:21:26 | Seminole, Oklahoma, US | |
637442 | 637442 | 2021-10-13 | US | West Virginia | Upshur | 54097 | 3755 | 57 | 0 | 38.89285061 | -80.23689136 | 2021-10-14 04:21:29 | Upshur, West Virginia, US | |
636519 | 636519 | 2021-10-13 | US | Oklahoma | Seminole | 40133 | 3755 | 92 | 0 | 35.16478725 | -96.61686741 | 2021-10-14 04:21:29 | Seminole, Oklahoma, US | |
2461162 | 2461162 | 2021-10-06 | US | North Carolina | Transylvania | 37175 | 3755 | 43 | 0 | 35.20383864 | -82.79638423 | 2021-10-07 04:21:36 | Transylvania, North Carolina, US | |
1377495 | 1377495 | 2021-09-15 | US | Tennessee | Wayne | 47181 | 3755 | 38 | 0 | 35.23868267 | -87.78644456 | 2021-09-16 04:22:19 | Wayne, Tennessee, US | |
2280952 | 2280952 | 2021-09-08 | US | Mississippi | Coahoma | 28027 | 3755 | 95 | 0 | 34.22772299 | -90.60415045 | 2021-09-09 04:21:27 | Coahoma, Mississippi, US | |
1596701 | 1596701 | 2021-08-26 | US | Arkansas | Johnson | 5071 | 3755 | 48 | 0 | 35.56759135 | -93.46036368 | 2021-08-27 04:21:37 | Johnson, Arkansas, US | |
35338 | 35338 | 2021-08-25 | US | Tennessee | Claiborne | 47025 | 3755 | 80 | 0 | 36.48319149 | -83.65947309 | 2021-08-26 04:21:28 | Claiborne, Tennessee, US | |
3108598 | 3108598 | 2021-08-24 | US | Texas | Kleberg | 48273 | 3755 | 98 | 0 | 27.42435506 | -97.69894948 | 2021-08-25 04:21:41 | Kleberg, Texas, US | |
3107293 | 3107293 | 2021-08-24 | US | Mississippi | Prentiss | 28117 | 3755 | 64 | 0 | 34.61810501 | -88.51986294 | 2021-08-25 04:21:41 | Prentiss, Mississippi, US | |
2901603 | 2901603 | 2021-08-12 | US | Missouri | Lafayette | 29107 | 3755 | 59 | 0 | 39.06986886 | -93.78076396 | 2021-08-13 04:21:24 | Lafayette, Missouri, US | |
2901243 | 2901243 | 2021-08-12 | US | Maine | Oxford | 23017 | 3755 | 70 | 0 | 44.49952995 | -70.75682123 | 2021-08-13 04:21:24 | Oxford, Maine, US | |
3220795 | 3220795 | 2021-07-26 | US | Ohio | Ottawa | 39123 | 3755 | 82 | 0 | 41.53781826 | -83.0940185 | 2021-07-27 04:21:18 | Ottawa, Ohio, US | |
627283 | 627283 | 2021-07-10 | US | Kentucky | Greenup | 21089 | 3755 | 63 | 0 | 38.54332505 | -82.9215658 | 2021-07-11 04:21:43 | Greenup, Kentucky, US | |
1894087 | 1894087 | 2021-06-30 | US | Idaho | Nez Perce | 16069 | 3755 | 57 | 0 | 46.32638236 | -116.7500975 | 2021-07-01 04:21:19 | Nez Perce, Idaho, 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]);