johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
286 rows where confirmed = 3724 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557792 | 2557792 | 2022-11-29 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-30 04:21:07 | Harrison, Iowa, US | |
1240866 | 1240866 | 2022-11-28 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-29 04:21:05 | Harrison, Iowa, US | |
3554784 | 3554784 | 2022-11-27 | US | Texas | Jackson | 48239 | 3724 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-11-28 04:21:02 | Jackson, Texas, US | |
3552854 | 3552854 | 2022-11-27 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-28 04:21:02 | Harrison, Iowa, US | |
2103264 | 2103264 | 2022-11-26 | US | Texas | Jackson | 48239 | 3724 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-11-27 04:21:05 | Jackson, Texas, US | |
2101334 | 2101334 | 2022-11-26 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-27 04:21:05 | Harrison, Iowa, US | |
490755 | 490755 | 2022-11-25 | US | Texas | Jackson | 48239 | 3724 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-11-26 04:21:11 | Jackson, Texas, US | |
488825 | 488825 | 2022-11-25 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-26 04:21:11 | Harrison, Iowa, US | |
3526584 | 3526584 | 2022-11-24 | US | Texas | Jackson | 48239 | 3724 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-11-25 04:21:06 | Jackson, Texas, US | |
3524654 | 3524654 | 2022-11-24 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-25 04:21:06 | Harrison, Iowa, US | |
3315367 | 3315367 | 2022-11-23 | US | Texas | Jackson | 48239 | 3724 | 61 | 0 | 28.95472367 | -96.57749563 | 2022-11-24 04:21:09 | Jackson, Texas, US | |
3313437 | 3313437 | 2022-11-23 | US | Iowa | Harrison | 19085 | 3724 | 99 | 0 | 41.68330137 | -95.81558439 | 2022-11-24 04:21:09 | Harrison, Iowa, US | |
2488963 | 2488963 | 2022-11-16 | US | Tennessee | Jackson | 47087 | 3724 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-11-17 04:21:11 | Jackson, Tennessee, US | |
294432 | 294432 | 2022-11-15 | US | North Dakota | Mountrail | 38061 | 3724 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-11-16 04:21:09 | Mountrail, North Dakota, US | |
3599462 | 3599462 | 2022-11-14 | US | North Dakota | Mountrail | 38061 | 3724 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-11-15 04:21:16 | Mountrail, North Dakota, US | |
480353 | 480353 | 2022-11-08 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-09 04:21:22 | Bleckley, Georgia, US | |
2439503 | 2439503 | 2022-11-07 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-08 04:21:21 | Bleckley, Georgia, US | |
1050601 | 1050601 | 2022-11-06 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-07 04:21:26 | Bleckley, Georgia, US | |
618625 | 618625 | 2022-11-05 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-06 04:21:24 | Bleckley, Georgia, US | |
1023129 | 1023129 | 2022-11-04 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-05 04:21:52 | Bleckley, Georgia, US | |
432120 | 432120 | 2022-11-03 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-04 04:22:11 | Bleckley, Georgia, US | |
850362 | 850362 | 2022-11-02 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-03 04:22:05 | Bleckley, Georgia, US | |
711213 | 711213 | 2022-11-01 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-02 04:22:09 | Bleckley, Georgia, US | |
3285662 | 3285662 | 2022-10-31 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-11-01 04:22:36 | Bleckley, Georgia, US | |
320695 | 320695 | 2022-10-30 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-10-31 04:21:36 | Bleckley, Georgia, US | |
912971 | 912971 | 2022-10-29 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-10-30 04:22:14 | Bleckley, Georgia, US | |
1367240 | 1367240 | 2022-10-28 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-10-29 04:21:13 | Bleckley, Georgia, US | |
3039095 | 3039095 | 2022-10-27 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-10-28 04:22:31 | Bleckley, Georgia, US | |
539515 | 539515 | 2022-10-26 | US | Georgia | Bleckley | 13023 | 3724 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-10-27 04:22:01 | Bleckley, Georgia, US | |
2758238 | 2758238 | 2022-10-18 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-19 04:22:26 | Marion, Kansas, US | |
2026342 | 2026342 | 2022-10-17 | US | Maryland | Kent | 24029 | 3724 | 73 | 0 | 39.24976208 | -76.04741541 | 2022-10-18 04:22:42 | Kent, Maryland, US | |
2026072 | 2026072 | 2022-10-17 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-18 04:22:42 | Marion, Kansas, US | |
2160850 | 2160850 | 2022-10-16 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-17 04:20:31 | Marion, Kansas, US | |
517047 | 517047 | 2022-10-15 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-16 04:22:39 | Marion, Kansas, US | |
2034104 | 2034104 | 2022-10-14 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-15 04:22:00 | Marion, Kansas, US | |
3754792 | 3754792 | 2022-10-13 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-14 04:22:28 | Marion, Kansas, US | |
3215617 | 3215617 | 2022-10-12 | US | Kansas | Marion | 20115 | 3724 | 52 | 0 | 38.35855394 | -97.0985251 | 2022-10-13 04:22:39 | Marion, Kansas, US | |
2263078 | 2263078 | 2022-10-02 | US | Virginia | Brunswick | 51025 | 3724 | 51 | 0 | 36.76366949 | -77.8593436 | 2022-10-03 04:23:11 | Brunswick, Virginia, US | |
2261286 | 2261286 | 2022-10-02 | US | Louisiana | Madison | 22065 | 3724 | 63 | 0 | 32.36918118 | -91.23973355 | 2022-10-03 04:23:11 | Madison, Louisiana, US | |
2998604 | 2998604 | 2022-10-01 | US | Virginia | Brunswick | 51025 | 3724 | 51 | 0 | 36.76366949 | -77.8593436 | 2022-10-02 04:21:23 | Brunswick, Virginia, US | |
2996812 | 2996812 | 2022-10-01 | US | Louisiana | Madison | 22065 | 3724 | 63 | 0 | 32.36918118 | -91.23973355 | 2022-10-02 04:21:23 | Madison, Louisiana, US | |
856930 | 856930 | 2022-09-30 | US | Virginia | Brunswick | 51025 | 3724 | 51 | 0 | 36.76366949 | -77.8593436 | 2022-10-01 04:23:01 | Brunswick, Virginia, US | |
855138 | 855138 | 2022-09-30 | US | Louisiana | Madison | 22065 | 3724 | 63 | 0 | 32.36918118 | -91.23973355 | 2022-10-01 04:23:01 | Madison, Louisiana, US | |
2378856 | 2378856 | 2022-09-29 | US | Virginia | Brunswick | 51025 | 3724 | 51 | 0 | 36.76366949 | -77.8593436 | 2022-09-30 04:23:09 | Brunswick, Virginia, US | |
1624095 | 1624095 | 2022-09-22 | China | Shaanxi | 3724 | 3 | 0 | 35.1917 | 108.8701 | 2022-09-23 04:23:13 | Shaanxi, China | |||
1370299 | 1370299 | 2022-09-21 | China | Shaanxi | 3724 | 3 | 0 | 35.1917 | 108.8701 | 2022-09-22 04:22:56 | Shaanxi, China | |||
2019587 | 2019587 | 2022-09-20 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-21 04:23:22 | Clay, South Dakota, US | |
3573460 | 3573460 | 2022-09-19 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-20 04:22:48 | Clay, South Dakota, US | |
422199 | 422199 | 2022-09-18 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-19 04:21:49 | Clay, South Dakota, US | |
3376223 | 3376223 | 2022-09-17 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-18 04:22:50 | Clay, South Dakota, US | |
2358331 | 2358331 | 2022-09-16 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-17 04:20:19 | Clay, South Dakota, US | |
3989488 | 3989488 | 2022-09-15 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-16 04:21:19 | Clay, South Dakota, US | |
1892005 | 1892005 | 2022-09-14 | US | South Dakota | Clay | 46027 | 3724 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-15 04:21:02 | Clay, South Dakota, US | |
115975 | 115975 | 2022-09-06 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-07 04:20:59 | Mills, Iowa, US | |
2634947 | 2634947 | 2022-09-05 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-06 04:21:02 | Mills, Iowa, US | |
2988511 | 2988511 | 2022-09-04 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-05 04:21:01 | Mills, Iowa, US | |
2714196 | 2714196 | 2022-09-03 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-04 04:21:22 | Mills, Iowa, US | |
1394901 | 1394901 | 2022-09-02 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-03 04:21:04 | Mills, Iowa, US | |
3548730 | 3548730 | 2022-09-01 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-02 04:21:07 | Mills, Iowa, US | |
2344650 | 2344650 | 2022-08-31 | US | Iowa | Mills | 19129 | 3724 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-09-01 04:21:03 | Mills, Iowa, US | |
1071355 | 1071355 | 2022-08-07 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-08 04:21:08 | Pendleton, Kentucky, US | |
1941943 | 1941943 | 2022-08-06 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-07 04:20:54 | Pendleton, Kentucky, US | |
881742 | 881742 | 2022-08-05 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-06 04:20:56 | Pendleton, Kentucky, US | |
2010153 | 2010153 | 2022-08-04 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-05 04:20:52 | Pendleton, Kentucky, US | |
1099580 | 1099580 | 2022-08-03 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-04 04:20:58 | Pendleton, Kentucky, US | |
1406505 | 1406505 | 2022-08-02 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-03 04:20:59 | Pendleton, Kentucky, US | |
3620412 | 3620412 | 2022-08-01 | US | Virginia | Dickenson | 51051 | 3724 | 52 | 0 | 37.12560977 | -82.35124171 | 2022-08-02 04:20:53 | Dickenson, Virginia, US | |
3618543 | 3618543 | 2022-08-01 | US | Kentucky | Pendleton | 21191 | 3724 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-02 04:20:53 | Pendleton, Kentucky, US | |
1069283 | 1069283 | 2022-07-28 | US | Virginia | Rockbridge | 51163 | 3724 | 80 | 0 | 37.81204314 | -79.44605905 | 2022-07-29 04:20:45 | Rockbridge, Virginia, US | |
1608046 | 1608046 | 2022-07-20 | China | Beijing | 3724 | 9 | 0 | 40.1824 | 116.4142 | 2022-07-21 04:21:10 | Beijing, China | |||
1766386 | 1766386 | 2022-06-20 | US | Texas | Comanche | 48093 | 3724 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-06-21 04:20:56 | Comanche, Texas, US | |
3272572 | 3272572 | 2022-06-19 | US | Texas | Comanche | 48093 | 3724 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-06-20 04:21:01 | Comanche, Texas, US | |
3400484 | 3400484 | 2022-06-18 | US | Texas | Comanche | 48093 | 3724 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-06-19 04:20:51 | Comanche, Texas, US | |
2314361 | 2314361 | 2022-06-17 | US | Texas | Comanche | 48093 | 3724 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-06-18 04:21:10 | Comanche, Texas, US | |
561865 | 561865 | 2022-06-16 | US | Texas | Comanche | 48093 | 3724 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-06-17 04:20:56 | Comanche, Texas, US | |
3888244 | 3888244 | 2022-06-06 | US | Colorado | Grand | 8049 | 3724 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-06-07 04:21:08 | Grand, Colorado, US | |
3594780 | 3594780 | 2022-05-23 | US | Minnesota | Pennington | 27113 | 3724 | 41 | 0 | 48.06642577 | -96.0370814 | 2022-05-24 04:20:57 | Pennington, Minnesota, US | |
1111006 | 1111006 | 2022-05-21 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-22 04:20:52 | Leslie, Kentucky, US | |
1170630 | 1170630 | 2022-05-20 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-21 04:20:58 | Leslie, Kentucky, US | |
3897393 | 3897393 | 2022-05-19 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-20 04:20:57 | Leslie, Kentucky, US | |
1186177 | 1186177 | 2022-05-18 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-19 04:20:54 | Leslie, Kentucky, US | |
3584074 | 3584074 | 2022-05-17 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-18 04:20:50 | Leslie, Kentucky, US | |
1505031 | 1505031 | 2022-05-16 | US | Kentucky | Leslie | 21131 | 3724 | 49 | 0 | 37.09246661 | -83.37999606 | 2022-05-17 04:20:59 | Leslie, Kentucky, US | |
3356938 | 3356938 | 2022-05-14 | US | New York | Schuyler | 36097 | 3724 | 25 | 0 | 42.39184015 | -76.8773299 | 2022-05-15 04:20:53 | Schuyler, New York, US | |
660583 | 660583 | 2022-05-13 | US | New York | Schuyler | 36097 | 3724 | 25 | 0 | 42.39184015 | -76.8773299 | 2022-05-14 04:20:48 | Schuyler, New York, US | |
2535666 | 2535666 | 2022-05-12 | US | New York | Schuyler | 36097 | 3724 | 25 | 0 | 42.39184015 | -76.8773299 | 2022-05-13 04:20:51 | Schuyler, New York, US | |
1699499 | 1699499 | 2022-04-28 | US | Texas | Madison | 48313 | 3724 | 54 | 0 | 30.96694679 | -95.93003775 | 2022-04-29 04:20:59 | Madison, Texas, US | |
1699490 | 1699490 | 2022-04-28 | US | Texas | Leon | 48289 | 3724 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-04-29 04:20:59 | Leon, Texas, US | |
1699112 | 1699112 | 2022-04-28 | US | Puerto Rico | San German | 72125 | 3724 | 0 | 0 | 18.111484 | -67.038581 | 2022-04-29 04:20:59 | San German, Puerto Rico, US | |
3854973 | 3854973 | 2022-04-27 | US | Texas | Leon | 48289 | 3724 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-04-28 04:20:47 | Leon, Texas, US | |
3418350 | 3418350 | 2022-04-17 | US | Kentucky | Leslie | 21131 | 3724 | 48 | 0 | 37.09246661 | -83.37999606 | 2022-04-18 04:21:12 | Leslie, Kentucky, US | |
3418047 | 3418047 | 2022-04-17 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-18 04:21:12 | Pike, Indiana, US | |
305299 | 305299 | 2022-04-16 | US | Kentucky | Leslie | 21131 | 3724 | 48 | 0 | 37.09246661 | -83.37999606 | 2022-04-17 04:20:59 | Leslie, Kentucky, US | |
304996 | 304996 | 2022-04-16 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-17 04:20:59 | Pike, Indiana, US | |
2671244 | 2671244 | 2022-04-15 | US | Kentucky | Leslie | 21131 | 3724 | 48 | 0 | 37.09246661 | -83.37999606 | 2022-04-16 04:20:48 | Leslie, Kentucky, US | |
2670941 | 2670941 | 2022-04-15 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-16 04:20:48 | Pike, Indiana, US | |
1225029 | 1225029 | 2022-04-14 | US | Kentucky | Leslie | 21131 | 3724 | 48 | 0 | 37.09246661 | -83.37999606 | 2022-04-15 04:20:57 | Leslie, Kentucky, US | |
1224726 | 1224726 | 2022-04-14 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-15 04:20:57 | Pike, Indiana, US | |
2444187 | 2444187 | 2022-04-13 | US | Kentucky | Leslie | 21131 | 3724 | 48 | 0 | 37.09246661 | -83.37999606 | 2022-04-13 23:21:06 | Leslie, Kentucky, US | |
2443884 | 2443884 | 2022-04-13 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-13 23:21:06 | Pike, Indiana, 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]);