johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
286 rows where confirmed = 2375 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218619 | 218619 | 2022-12-26 | US | Colorado | Lincoln | 8073 | 2375 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-12-27 04:21:07 | Lincoln, Colorado, US | |
3715385 | 3715385 | 2022-12-06 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-07 04:20:58 | Keokuk, Iowa, US | |
2416090 | 2416090 | 2022-12-05 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-06 04:21:03 | Keokuk, Iowa, US | |
719698 | 719698 | 2022-12-04 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-05 04:20:58 | Keokuk, Iowa, US | |
2817987 | 2817987 | 2022-12-03 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-04 04:20:56 | Keokuk, Iowa, US | |
834843 | 834843 | 2022-12-02 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-03 04:21:02 | Keokuk, Iowa, US | |
2137373 | 2137373 | 2022-12-01 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-02 04:21:07 | Keokuk, Iowa, US | |
1965789 | 1965789 | 2022-11-30 | US | Iowa | Keokuk | 19107 | 2375 | 53 | 0 | 41.33649833 | -92.1785067 | 2022-12-01 04:21:03 | Keokuk, Iowa, US | |
3552699 | 3552699 | 2022-11-27 | US | Illinois | Schuyler | 17169 | 2375 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-28 04:21:02 | Schuyler, Illinois, US | |
2101179 | 2101179 | 2022-11-26 | US | Illinois | Schuyler | 17169 | 2375 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-27 04:21:05 | Schuyler, Illinois, US | |
488670 | 488670 | 2022-11-25 | US | Illinois | Schuyler | 17169 | 2375 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-26 04:21:11 | Schuyler, Illinois, US | |
3524499 | 3524499 | 2022-11-24 | US | Illinois | Schuyler | 17169 | 2375 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-25 04:21:06 | Schuyler, Illinois, US | |
3313282 | 3313282 | 2022-11-23 | US | Illinois | Schuyler | 17169 | 2375 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-24 04:21:09 | Schuyler, Illinois, US | |
3599260 | 3599260 | 2022-11-14 | US | New Mexico | Sierra | 35051 | 2375 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-11-15 04:21:16 | Sierra, New Mexico, US | |
314338 | 314338 | 2022-11-13 | US | North Dakota | Traill | 38097 | 2375 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-11-14 04:21:09 | Traill, North Dakota, US | |
65499 | 65499 | 2022-11-12 | US | North Dakota | Traill | 38097 | 2375 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-11-13 04:21:14 | Traill, North Dakota, US | |
540467 | 540467 | 2022-10-26 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-27 04:22:01 | Clearwater, Minnesota, US | |
1831868 | 1831868 | 2022-10-25 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-26 04:22:19 | Clearwater, Minnesota, US | |
796129 | 796129 | 2022-10-24 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-25 04:21:53 | Clearwater, Minnesota, US | |
3278584 | 3278584 | 2022-10-23 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-24 04:22:29 | Clearwater, Minnesota, US | |
2269622 | 2269622 | 2022-10-22 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-23 04:22:46 | Clearwater, Minnesota, US | |
1593922 | 1593922 | 2022-10-21 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-22 04:22:53 | Clearwater, Minnesota, US | |
2275434 | 2275434 | 2022-10-20 | US | West Virginia | Pleasants | 54073 | 2375 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-10-21 04:22:23 | Pleasants, West Virginia, US | |
2273638 | 2273638 | 2022-10-20 | US | Minnesota | Clearwater | 27029 | 2375 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-21 04:22:23 | Clearwater, Minnesota, US | |
201769 | 201769 | 2022-10-19 | US | West Virginia | Pleasants | 54073 | 2375 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-10-20 04:22:59 | Pleasants, West Virginia, US | |
2760430 | 2760430 | 2022-10-18 | US | West Virginia | Pleasants | 54073 | 2375 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-10-19 04:22:26 | Pleasants, West Virginia, US | |
853426 | 853426 | 2022-09-30 | China | Tianjin | 2375 | 3 | 0 | 39.3054 | 117.323 | 2022-10-01 04:23:01 | Tianjin, China | |||
2376071 | 2376071 | 2022-09-29 | US | Arkansas | Searcy | 5129 | 2375 | 50 | 0 | 35.9109364 | -92.69936482 | 2022-09-30 04:23:09 | Searcy, Arkansas, US | |
2649598 | 2649598 | 2022-09-24 | China | Yunnan | 2375 | 2 | 0 | 24.974 | 101.487 | 2022-09-25 04:23:31 | Yunnan, China | |||
3769359 | 3769359 | 2022-09-11 | US | West Virginia | Doddridge | 54017 | 2375 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-09-12 04:20:58 | Doddridge, West Virginia, US | |
3769215 | 3769215 | 2022-09-11 | US | Virginia | Fairfax City | 51600 | 2375 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-12 04:20:58 | Fairfax City, Virginia, US | |
3827934 | 3827934 | 2022-09-10 | US | West Virginia | Doddridge | 54017 | 2375 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-09-11 04:20:50 | Doddridge, West Virginia, US | |
3827790 | 3827790 | 2022-09-10 | US | Virginia | Fairfax City | 51600 | 2375 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-11 04:20:50 | Fairfax City, Virginia, US | |
966391 | 966391 | 2022-09-09 | US | West Virginia | Doddridge | 54017 | 2375 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-09-10 04:21:10 | Doddridge, West Virginia, US | |
966247 | 966247 | 2022-09-09 | US | Virginia | Fairfax City | 51600 | 2375 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-10 04:21:10 | Fairfax City, Virginia, US | |
3774656 | 3774656 | 2022-08-30 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-31 04:20:57 | Atkinson, Georgia, US | |
1681252 | 1681252 | 2022-08-29 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-30 04:21:03 | Atkinson, Georgia, US | |
1680300 | 1680300 | 2022-08-29 | China | Inner Mongolia | 2375 | 1 | 0 | 44.0935 | 113.9448 | 2022-08-30 04:21:03 | Inner Mongolia, China | |||
1877736 | 1877736 | 2022-08-28 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-29 04:21:06 | Atkinson, Georgia, US | |
2096863 | 2096863 | 2022-08-27 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-28 04:21:02 | Atkinson, Georgia, US | |
1532678 | 1532678 | 2022-08-26 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-27 04:20:57 | Atkinson, Georgia, US | |
2830344 | 2830344 | 2022-08-25 | US | Louisiana | Red River | 22081 | 2375 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-08-26 04:21:02 | Red River, Louisiana, US | |
2829565 | 2829565 | 2022-08-25 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-26 04:21:02 | Atkinson, Georgia, US | |
2324098 | 2324098 | 2022-08-24 | US | Georgia | Atkinson | 13003 | 2375 | 53 | 0 | 31.29633502 | -82.87545866 | 2022-08-25 04:21:13 | Atkinson, Georgia, US | |
1163925 | 1163925 | 2022-08-18 | US | Puerto Rico | Las Marias | 72083 | 2375 | 0 | 0 | 18.23679 | -66.98362 | 2022-08-19 04:20:54 | Las Marias, Puerto Rico, US | |
1490565 | 1490565 | 2022-07-26 | US | Tennessee | Moore | 47127 | 2375 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-07-27 04:21:04 | Moore, Tennessee, US | |
3112869 | 3112869 | 2022-07-13 | US | Virginia | Northampton | 51131 | 2375 | 66 | 0 | 37.34062933 | -75.87751591 | 2022-07-14 04:20:57 | Northampton, Virginia, US | |
633292 | 633292 | 2022-07-12 | US | Virginia | Northampton | 51131 | 2375 | 66 | 0 | 37.34062933 | -75.87751591 | 2022-07-13 04:20:58 | Northampton, Virginia, US | |
632955 | 632955 | 2022-07-12 | US | Texas | Castro | 48069 | 2375 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-13 04:20:58 | Castro, Texas, US | |
1214599 | 1214599 | 2022-07-11 | US | Texas | Castro | 48069 | 2375 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-12 04:20:51 | Castro, Texas, US | |
3943582 | 3943582 | 2022-06-30 | US | West Virginia | Webster | 54101 | 2375 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-07-01 04:21:10 | Webster, West Virginia, US | |
3940994 | 3940994 | 2022-06-30 | US | Idaho | Clearwater | 16035 | 2375 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-07-01 04:21:10 | Clearwater, Idaho, US | |
2490952 | 2490952 | 2022-06-29 | US | Idaho | Clearwater | 16035 | 2375 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-30 04:21:01 | Clearwater, Idaho, US | |
2489827 | 2489827 | 2022-06-29 | China | Sichuan | 2375 | 3 | 0 | 30.6171 | 102.7103 | 2022-06-30 04:21:01 | Sichuan, China | |||
3272855 | 3272855 | 2022-06-19 | US | Virginia | Franklin City | 51620 | 2375 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-20 04:21:01 | Franklin City, Virginia, US | |
3270907 | 3270907 | 2022-06-19 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-20 04:21:01 | Crittenden, Kentucky, US | |
3400767 | 3400767 | 2022-06-18 | US | Virginia | Franklin City | 51620 | 2375 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-19 04:20:51 | Franklin City, Virginia, US | |
3398819 | 3398819 | 2022-06-18 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-19 04:20:51 | Crittenden, Kentucky, US | |
2314644 | 2314644 | 2022-06-17 | US | Virginia | Franklin City | 51620 | 2375 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-18 04:21:10 | Franklin City, Virginia, US | |
2312696 | 2312696 | 2022-06-17 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-18 04:21:10 | Crittenden, Kentucky, US | |
560570 | 560570 | 2022-06-16 | US | Minnesota | Rock | 27133 | 2375 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-06-17 04:20:56 | Rock, Minnesota, US | |
560200 | 560200 | 2022-06-16 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-17 04:20:56 | Crittenden, Kentucky, US | |
3984002 | 3984002 | 2022-06-15 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-16 04:20:55 | Crittenden, Kentucky, US | |
948243 | 948243 | 2022-06-14 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-15 04:20:54 | Crittenden, Kentucky, US | |
2980651 | 2980651 | 2022-06-13 | US | Kentucky | Crittenden | 21055 | 2375 | 50 | 0 | 37.35839237 | -88.0882609 | 2022-06-14 04:20:52 | Crittenden, Kentucky, US | |
3000099 | 3000099 | 2022-05-24 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-25 04:20:56 | Dooly, Georgia, US | |
3593820 | 3593820 | 2022-05-23 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-24 04:20:57 | Dooly, Georgia, US | |
1110368 | 1110368 | 2022-05-21 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-22 04:20:52 | Dooly, Georgia, US | |
1169992 | 1169992 | 2022-05-20 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-21 04:20:58 | Dooly, Georgia, US | |
3896755 | 3896755 | 2022-05-19 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-20 04:20:57 | Dooly, Georgia, US | |
1185539 | 1185539 | 2022-05-18 | US | Georgia | Dooly | 13093 | 2375 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-05-19 04:20:54 | Dooly, Georgia, US | |
2534069 | 2534069 | 2022-05-12 | US | Connecticut | Unassigned | 90009 | 2375 | 1 | 0 | 41.85853803 | 0.0 | 2022-05-13 04:20:51 | Unassigned, Connecticut, US | |
2334101 | 2334101 | 2022-05-08 | US | Puerto Rico | Arroyo | 72015 | 2375 | 0 | 0 | 17.998457 | -66.056546 | 2022-05-09 04:20:54 | Arroyo, Puerto Rico, US | |
363063 | 363063 | 2022-05-07 | US | Puerto Rico | Arroyo | 72015 | 2375 | 0 | 0 | 17.998457 | -66.056546 | 2022-05-08 04:20:49 | Arroyo, Puerto Rico, US | |
3731630 | 3731630 | 2022-04-03 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-04-04 04:20:51 | Elliott, Kentucky, US | |
501065 | 501065 | 2022-04-02 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-04-03 04:20:48 | Elliott, Kentucky, US | |
3352050 | 3352050 | 2022-04-01 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-04-02 04:20:47 | Elliott, Kentucky, US | |
1541355 | 1541355 | 2022-03-31 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-04-01 04:20:28 | Elliott, Kentucky, US | |
2479368 | 2479368 | 2022-03-30 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-31 04:20:56 | Elliott, Kentucky, US | |
159409 | 159409 | 2022-03-29 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-30 04:20:45 | Elliott, Kentucky, US | |
158899 | 158899 | 2022-03-29 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-30 04:20:45 | Towns, Georgia, US | |
1437980 | 1437980 | 2022-03-28 | US | Kentucky | Elliott | 21063 | 2375 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-29 04:20:46 | Elliott, Kentucky, US | |
1437470 | 1437470 | 2022-03-28 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-29 04:20:46 | Towns, Georgia, US | |
877151 | 877151 | 2022-03-27 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-28 04:20:33 | Towns, Georgia, US | |
2164434 | 2164434 | 2022-03-26 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-27 04:20:47 | Towns, Georgia, US | |
1721370 | 1721370 | 2022-03-25 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-26 04:20:23 | Towns, Georgia, US | |
1468987 | 1468987 | 2022-03-24 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-25 04:20:46 | Towns, Georgia, US | |
3023161 | 3023161 | 2022-03-23 | US | Georgia | Towns | 13281 | 2375 | 107 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-24 04:20:43 | Towns, Georgia, US | |
1906083 | 1906083 | 2022-03-22 | US | Georgia | Towns | 13281 | 2375 | 106 | 0 | 34.91369188 | -83.74107459999998 | 2022-03-23 04:20:48 | Towns, Georgia, US | |
695745 | 695745 | 2022-03-17 | US | Kansas | Thomas | 20193 | 2375 | 27 | 0 | 39.35107575 | -101.0553705 | 2022-03-18 04:20:55 | Thomas, Kansas, US | |
2320688 | 2320688 | 2022-03-16 | US | Kansas | Thomas | 20193 | 2375 | 27 | 0 | 39.35107575 | -101.0553705 | 2022-03-17 04:20:56 | Thomas, Kansas, US | |
1551290 | 1551290 | 2022-03-07 | US | Virginia | Charlotte | 51037 | 2375 | 44 | 0 | 37.01909701 | -78.66314092 | 2022-03-08 04:20:54 | Charlotte, Virginia, US | |
2526850 | 2526850 | 2022-03-02 | US | Kentucky | Wolfe | 21237 | 2375 | 18 | 0 | 37.73941626 | -83.49303612 | 2022-03-03 04:21:01 | Wolfe, Kentucky, US | |
236291 | 236291 | 2022-02-11 | US | Texas | Childress | 48075 | 2375 | 27 | 0 | 34.529304100000004 | -100.2077916 | 2022-02-12 04:21:06 | Childress, Texas, US | |
1364307 | 1364307 | 2022-02-08 | US | Missouri | Ralls | 29173 | 2375 | 20 | 0 | 39.52817427 | -91.51838643 | 2022-02-09 04:21:04 | Ralls, Missouri, US | |
1779773 | 1779773 | 2022-01-27 | US | Alabama | Lowndes | 1085 | 2375 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-28 04:21:09 | Lowndes, Alabama, US | |
1318601 | 1318601 | 2022-01-26 | US | Alabama | Lowndes | 1085 | 2375 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-27 04:21:19 | Lowndes, Alabama, US | |
1228000 | 1228000 | 2022-01-24 | US | Alabama | Lowndes | 1085 | 2375 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-25 04:21:05 | Lowndes, Alabama, US | |
3689237 | 3689237 | 2022-01-13 | US | Minnesota | Pope | 27121 | 2375 | 14 | 0 | 45.58606667 | -95.44451209 | 2022-01-14 04:21:54 | Pope, Minnesota, US | |
3615451 | 3615451 | 2022-01-12 | US | North Dakota | Barnes | 38003 | 2375 | 41 | 0 | 46.93579637 | -98.06605978 | 2022-01-13 08:00:09 | Barnes, North Dakota, 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]);