johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
208 rows where confirmed = 4358 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331175 | 331175 | 2022-12-27 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-28 04:21:04 | Zapata, Texas, US | |
221248 | 221248 | 2022-12-26 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-27 04:21:07 | Zapata, Texas, US | |
3225705 | 3225705 | 2022-12-25 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-26 04:21:06 | Zapata, Texas, US | |
1021619 | 1021619 | 2022-12-24 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-25 04:21:04 | Zapata, Texas, US | |
693642 | 693642 | 2022-12-23 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-24 04:21:02 | Zapata, Texas, US | |
2182852 | 2182852 | 2022-12-22 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-23 04:21:04 | Zapata, Texas, US | |
454656 | 454656 | 2022-12-21 | US | Texas | Zapata | 48505 | 4358 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-22 04:20:56 | Zapata, Texas, US | |
3038931 | 3038931 | 2022-10-27 | US | California | Unassigned | 90006 | 4358 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-28 04:22:31 | Unassigned, California, US | |
1832292 | 1832292 | 2022-10-25 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-26 04:22:19 | York, Nebraska, US | |
796553 | 796553 | 2022-10-24 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-25 04:21:53 | York, Nebraska, US | |
3279008 | 3279008 | 2022-10-23 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-24 04:22:29 | York, Nebraska, US | |
2270046 | 2270046 | 2022-10-22 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-23 04:22:46 | York, Nebraska, US | |
1594346 | 1594346 | 2022-10-21 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-22 04:22:53 | York, Nebraska, US | |
2274062 | 2274062 | 2022-10-20 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-21 04:22:23 | York, Nebraska, US | |
200397 | 200397 | 2022-10-19 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-20 04:22:59 | York, Nebraska, US | |
2759671 | 2759671 | 2022-10-18 | US | Puerto Rico | Hormigueros | 72067 | 4358 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-19 04:22:26 | Hormigueros, Puerto Rico, US | |
2759058 | 2759058 | 2022-10-18 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-19 04:22:26 | York, Nebraska, US | |
2026892 | 2026892 | 2022-10-17 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-18 04:22:42 | York, Nebraska, US | |
2161670 | 2161670 | 2022-10-16 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-17 04:20:31 | York, Nebraska, US | |
517867 | 517867 | 2022-10-15 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-16 04:22:39 | York, Nebraska, US | |
2034924 | 2034924 | 2022-10-14 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-15 04:22:00 | York, Nebraska, US | |
3755612 | 3755612 | 2022-10-13 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-14 04:22:28 | York, Nebraska, US | |
3216437 | 3216437 | 2022-10-12 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-13 04:22:39 | York, Nebraska, US | |
3252286 | 3252286 | 2022-10-11 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-12 04:22:51 | York, Nebraska, US | |
2969545 | 2969545 | 2022-10-10 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-11 04:23:05 | York, Nebraska, US | |
2969071 | 2969071 | 2022-10-10 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-11 04:23:05 | Manistee, Michigan, US | |
3099581 | 3099581 | 2022-10-09 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-10 04:22:32 | York, Nebraska, US | |
3099107 | 3099107 | 2022-10-09 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-10 04:22:32 | Manistee, Michigan, US | |
4004806 | 4004806 | 2022-10-08 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-09 04:21:16 | York, Nebraska, US | |
4004332 | 4004332 | 2022-10-08 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-09 04:21:16 | Manistee, Michigan, US | |
398403 | 398403 | 2022-10-07 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-08 04:22:56 | York, Nebraska, US | |
397929 | 397929 | 2022-10-07 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-08 04:22:56 | Manistee, Michigan, US | |
2531520 | 2531520 | 2022-10-06 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-07 04:23:08 | York, Nebraska, US | |
2531046 | 2531046 | 2022-10-06 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-07 04:23:08 | Manistee, Michigan, US | |
1812914 | 1812914 | 2022-10-05 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-06 04:21:22 | York, Nebraska, US | |
1812440 | 1812440 | 2022-10-05 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-06 04:21:22 | Manistee, Michigan, US | |
132888 | 132888 | 2022-10-04 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-05 04:23:06 | York, Nebraska, US | |
132414 | 132414 | 2022-10-04 | US | Michigan | Manistee | 26101 | 4358 | 99 | 0 | 44.33352407 | -86.05626916 | 2022-10-05 04:23:06 | Manistee, Michigan, US | |
2687835 | 2687835 | 2022-10-03 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-04 04:22:55 | York, Nebraska, US | |
2261902 | 2261902 | 2022-10-02 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-03 04:23:11 | York, Nebraska, US | |
2997428 | 2997428 | 2022-10-01 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-02 04:21:23 | York, Nebraska, US | |
855754 | 855754 | 2022-09-30 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-10-01 04:23:01 | York, Nebraska, US | |
2377680 | 2377680 | 2022-09-29 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-30 04:23:09 | York, Nebraska, US | |
1562231 | 1562231 | 2022-09-28 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-29 04:22:34 | York, Nebraska, US | |
3996774 | 3996774 | 2022-09-27 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-28 04:23:01 | York, Nebraska, US | |
2771102 | 2771102 | 2022-09-26 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-27 04:23:01 | York, Nebraska, US | |
1978755 | 1978755 | 2022-09-25 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-26 04:20:52 | York, Nebraska, US | |
2651922 | 2651922 | 2022-09-24 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-25 04:23:31 | York, Nebraska, US | |
386362 | 386362 | 2022-09-23 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-24 04:21:40 | York, Nebraska, US | |
1626428 | 1626428 | 2022-09-22 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-23 04:23:13 | York, Nebraska, US | |
1372632 | 1372632 | 2022-09-21 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-22 04:22:56 | York, Nebraska, US | |
2018862 | 2018862 | 2022-09-20 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-21 04:23:22 | York, Nebraska, US | |
3572735 | 3572735 | 2022-09-19 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-20 04:22:48 | York, Nebraska, US | |
421474 | 421474 | 2022-09-18 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-19 04:21:49 | York, Nebraska, US | |
3375498 | 3375498 | 2022-09-17 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-18 04:22:50 | York, Nebraska, US | |
2357606 | 2357606 | 2022-09-16 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-17 04:20:19 | York, Nebraska, US | |
3988763 | 3988763 | 2022-09-15 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-16 04:21:19 | York, Nebraska, US | |
1891280 | 1891280 | 2022-09-14 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-15 04:21:02 | York, Nebraska, US | |
374335 | 374335 | 2022-09-13 | US | Nebraska | York | 31185 | 4358 | 23 | 0 | 40.87272618 | -97.59710186 | 2022-09-14 04:20:44 | York, Nebraska, US | |
118018 | 118018 | 2022-09-06 | US | Texas | Zavala | 48507 | 4358 | 69 | 0 | 28.86617238 | -99.76050829 | 2022-09-07 04:20:59 | Zavala, Texas, US | |
2635939 | 2635939 | 2022-09-05 | US | New Mexico | Socorro | 35053 | 4358 | 95 | 0 | 34.00715494 | -106.9298354 | 2022-09-06 04:21:02 | Socorro, New Mexico, US | |
2989503 | 2989503 | 2022-09-04 | US | New Mexico | Socorro | 35053 | 4358 | 95 | 0 | 34.00715494 | -106.9298354 | 2022-09-05 04:21:01 | Socorro, New Mexico, US | |
2715188 | 2715188 | 2022-09-03 | US | New Mexico | Socorro | 35053 | 4358 | 95 | 0 | 34.00715494 | -106.9298354 | 2022-09-04 04:21:22 | Socorro, New Mexico, US | |
1395893 | 1395893 | 2022-09-02 | US | New Mexico | Socorro | 35053 | 4358 | 95 | 0 | 34.00715494 | -106.9298354 | 2022-09-03 04:21:04 | Socorro, New Mexico, US | |
2406289 | 2406289 | 2022-08-21 | US | Washington | Pacific | 53049 | 4358 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-22 04:20:38 | Pacific, Washington, US | |
3801367 | 3801367 | 2022-08-20 | US | Washington | Pacific | 53049 | 4358 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-21 04:20:44 | Pacific, Washington, US | |
2366953 | 2366953 | 2022-08-19 | US | Washington | Pacific | 53049 | 4358 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-20 04:21:01 | Pacific, Washington, US | |
3908523 | 3908523 | 2022-08-11 | US | Arkansas | Polk | 5113 | 4358 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-08-12 04:20:54 | Polk, Arkansas, US | |
2337986 | 2337986 | 2022-07-27 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-28 04:20:56 | Pawnee, Oklahoma, US | |
1490176 | 1490176 | 2022-07-26 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-27 04:21:04 | Pawnee, Oklahoma, US | |
2596622 | 2596622 | 2022-07-25 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-26 04:20:58 | Pawnee, Oklahoma, US | |
898737 | 898737 | 2022-07-24 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-25 04:20:51 | Pawnee, Oklahoma, US | |
93731 | 93731 | 2022-07-23 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-24 04:20:47 | Pawnee, Oklahoma, US | |
902753 | 902753 | 2022-07-22 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-23 04:20:53 | Pawnee, Oklahoma, US | |
672889 | 672889 | 2022-07-21 | US | Oklahoma | Pawnee | 40117 | 4358 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-07-22 04:21:15 | Pawnee, Oklahoma, US | |
633033 | 633033 | 2022-07-12 | US | Texas | Houston | 48225 | 4358 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-07-13 04:20:58 | Houston, Texas, US | |
3079066 | 3079066 | 2022-07-04 | US | Illinois | Jo Daviess | 17085 | 4358 | 37 | 0 | 42.36542373 | -90.21094405 | 2022-07-05 04:20:45 | Jo Daviess, Illinois, US | |
1768348 | 1768348 | 2022-07-03 | US | Illinois | Jo Daviess | 17085 | 4358 | 37 | 0 | 42.36542373 | -90.21094405 | 2022-07-04 04:20:54 | Jo Daviess, Illinois, US | |
3366334 | 3366334 | 2022-07-02 | US | Illinois | Jo Daviess | 17085 | 4358 | 37 | 0 | 42.36542373 | -90.21094405 | 2022-07-03 04:20:59 | Jo Daviess, Illinois, US | |
594663 | 594663 | 2022-07-01 | US | Illinois | Jo Daviess | 17085 | 4358 | 37 | 0 | 42.36542373 | -90.21094405 | 2022-07-02 04:21:16 | Jo Daviess, Illinois, US | |
2149156 | 2149156 | 2022-06-27 | US | Louisiana | LaSalle | 22059 | 4358 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-28 04:20:58 | LaSalle, Louisiana, US | |
2190629 | 2190629 | 2022-06-22 | US | Texas | Aransas | 48007 | 4358 | 87 | 0 | 28.10556197 | -96.9995047 | 2022-06-23 04:20:55 | Aransas, Texas, US | |
232379 | 232379 | 2022-05-31 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-06-01 04:20:55 | Lamb, Texas, US | |
3189144 | 3189144 | 2022-05-30 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-31 04:20:51 | Lamb, Texas, US | |
3201293 | 3201293 | 2022-05-29 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-30 04:20:50 | Lamb, Texas, US | |
2728171 | 2728171 | 2022-05-28 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-29 04:20:53 | Lamb, Texas, US | |
1317352 | 1317352 | 2022-05-27 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-28 04:21:07 | Lamb, Texas, US | |
1853144 | 1853144 | 2022-05-26 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-27 04:20:56 | Lamb, Texas, US | |
2051020 | 2051020 | 2022-05-25 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-26 04:20:50 | Lamb, Texas, US | |
3002458 | 3002458 | 2022-05-24 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-25 04:20:56 | Lamb, Texas, US | |
3596179 | 3596179 | 2022-05-23 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-24 04:20:57 | Lamb, Texas, US | |
625031 | 625031 | 2022-05-22 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-26 04:20:50 | Lamb, Texas, US | |
1112727 | 1112727 | 2022-05-21 | US | Texas | Lamb | 48279 | 4358 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-05-22 04:20:52 | Lamb, Texas, US | |
2334903 | 2334903 | 2022-05-08 | US | West Virginia | Wetzel | 54103 | 4358 | 86 | 0 | 39.6065771 | -80.6401654 | 2022-05-09 04:20:54 | Wetzel, West Virginia, US | |
363865 | 363865 | 2022-05-07 | US | West Virginia | Wetzel | 54103 | 4358 | 86 | 0 | 39.6065771 | -80.6401654 | 2022-05-08 04:20:49 | Wetzel, West Virginia, US | |
1401216 | 1401216 | 2022-05-06 | US | West Virginia | Wetzel | 54103 | 4358 | 86 | 0 | 39.6065771 | -80.6401654 | 2022-05-07 04:21:09 | Wetzel, West Virginia, US | |
2599012 | 2599012 | 2022-05-05 | US | Illinois | Bond | 17005 | 4358 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-05-06 04:21:00 | Bond, Illinois, US | |
2443400 | 2443400 | 2022-04-13 | US | Colorado | Otero | 8089 | 4358 | 130 | 0 | 37.9014485 | -103.7173385 | 2022-04-13 23:21:06 | Otero, Colorado, US | |
920720 | 920720 | 2022-03-08 | US | Illinois | Piatt | 17147 | 4358 | 22 | 0 | 40.01360584 | -88.59319339 | 2022-03-09 04:20:59 | Piatt, Illinois, US | |
2202861 | 2202861 | 2022-03-06 | US | Texas | Shelby | 48419 | 4358 | 126 | 0 | 31.79211404 | -94.14550696 | 2022-03-07 04:20:47 | Shelby, Texas, 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]);