johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
329 rows where confirmed = 1983 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331076 | 331076 | 2022-12-27 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-28 04:21:04 | Marion, Texas, US | |
221149 | 221149 | 2022-12-26 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-27 04:21:07 | Marion, Texas, US | |
3225606 | 3225606 | 2022-12-25 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-26 04:21:06 | Marion, Texas, US | |
1021520 | 1021520 | 2022-12-24 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-25 04:21:04 | Marion, Texas, US | |
693543 | 693543 | 2022-12-23 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-24 04:21:02 | Marion, Texas, US | |
2182753 | 2182753 | 2022-12-22 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-23 04:21:04 | Marion, Texas, US | |
454557 | 454557 | 2022-12-21 | US | Texas | Marion | 48315 | 1983 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-12-22 04:20:56 | Marion, Texas, US | |
1149462 | 1149462 | 2022-12-12 | US | Arkansas | Newton | 5101 | 1983 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-13 04:21:01 | Newton, Arkansas, US | |
869316 | 869316 | 2022-12-11 | US | Arkansas | Newton | 5101 | 1983 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-12 04:21:01 | Newton, Arkansas, US | |
257846 | 257846 | 2022-12-10 | US | Arkansas | Newton | 5101 | 1983 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-11 04:20:50 | Newton, Arkansas, US | |
1643385 | 1643385 | 2022-11-20 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-21 04:21:05 | Brooks, Texas, US | |
2066942 | 2066942 | 2022-11-19 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-20 04:21:08 | Brooks, Texas, US | |
1758336 | 1758336 | 2022-11-18 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-19 04:21:14 | Brooks, Texas, US | |
3029329 | 3029329 | 2022-11-17 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-18 04:21:15 | Brooks, Texas, US | |
2489040 | 2489040 | 2022-11-16 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-17 04:21:11 | Brooks, Texas, US | |
295051 | 295051 | 2022-11-15 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-16 04:21:09 | Brooks, Texas, US | |
3600081 | 3600081 | 2022-11-14 | US | Texas | Brooks | 48047 | 1983 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-15 04:21:16 | Brooks, Texas, US | |
131958 | 131958 | 2022-10-04 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-05 04:23:06 | Ida, Iowa, US | |
2686905 | 2686905 | 2022-10-03 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-04 04:22:55 | Ida, Iowa, US | |
2260972 | 2260972 | 2022-10-02 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-03 04:23:11 | Ida, Iowa, US | |
2996498 | 2996498 | 2022-10-01 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-02 04:21:23 | Ida, Iowa, US | |
854824 | 854824 | 2022-09-30 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-01 04:23:01 | Ida, Iowa, US | |
2376750 | 2376750 | 2022-09-29 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-30 04:23:09 | Ida, Iowa, US | |
1561301 | 1561301 | 2022-09-28 | US | Iowa | Ida | 19093 | 1983 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-29 04:22:34 | Ida, Iowa, US | |
1682618 | 1682618 | 2022-08-29 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-30 04:21:03 | Richardson, Nebraska, US | |
1879102 | 1879102 | 2022-08-28 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-29 04:21:06 | Richardson, Nebraska, US | |
2098229 | 2098229 | 2022-08-27 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-28 04:21:02 | Richardson, Nebraska, US | |
1534044 | 1534044 | 2022-08-26 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-27 04:20:57 | Richardson, Nebraska, US | |
2832042 | 2832042 | 2022-08-25 | US | Texas | Stephens | 48429 | 1983 | 50 | 0 | 32.73553157 | -98.83631615 | 2022-08-26 04:21:02 | Stephens, Texas, US | |
2830931 | 2830931 | 2022-08-25 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-26 04:21:02 | Richardson, Nebraska, US | |
2326575 | 2326575 | 2022-08-24 | US | Texas | Stephens | 48429 | 1983 | 50 | 0 | 32.73553157 | -98.83631615 | 2022-08-25 04:21:13 | Stephens, Texas, US | |
2325464 | 2325464 | 2022-08-24 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-25 04:21:13 | Richardson, Nebraska, US | |
1252873 | 1252873 | 2022-08-23 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-24 04:20:46 | Richardson, Nebraska, US | |
2854977 | 2854977 | 2022-08-22 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-23 04:20:56 | Richardson, Nebraska, US | |
2405818 | 2405818 | 2022-08-21 | US | Tennessee | Pickett | 47137 | 1983 | 38 | 0 | 36.55606529 | -85.077633 | 2022-08-22 04:20:38 | Pickett, Tennessee, US | |
2404949 | 2404949 | 2022-08-21 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-22 04:20:38 | Richardson, Nebraska, US | |
3800896 | 3800896 | 2022-08-20 | US | Tennessee | Pickett | 47137 | 1983 | 38 | 0 | 36.55606529 | -85.077633 | 2022-08-21 04:20:44 | Pickett, Tennessee, US | |
3800027 | 3800027 | 2022-08-20 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-21 04:20:44 | Richardson, Nebraska, US | |
2366482 | 2366482 | 2022-08-19 | US | Tennessee | Pickett | 47137 | 1983 | 38 | 0 | 36.55606529 | -85.077633 | 2022-08-20 04:21:01 | Pickett, Tennessee, US | |
2365613 | 2365613 | 2022-08-19 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-20 04:21:01 | Richardson, Nebraska, US | |
1163284 | 1163284 | 2022-08-18 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-19 04:20:54 | Richardson, Nebraska, US | |
3952608 | 3952608 | 2022-08-17 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-18 04:21:11 | Richardson, Nebraska, US | |
993110 | 993110 | 2022-08-16 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-17 04:20:59 | Richardson, Nebraska, US | |
2496149 | 2496149 | 2022-08-15 | US | Nebraska | Richardson | 31147 | 1983 | 23 | 0 | 40.1247415 | -95.71755036 | 2022-08-16 04:20:58 | Richardson, Nebraska, US | |
1101320 | 1101320 | 2022-08-03 | US | Texas | Rains | 48379 | 1983 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-08-04 04:20:58 | Rains, Texas, US | |
1101123 | 1101123 | 2022-08-03 | US | Tennessee | Van Buren | 47175 | 1983 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-04 04:20:58 | Van Buren, Tennessee, US | |
1068943 | 1068943 | 2022-07-28 | US | Texas | Crosby | 48107 | 1983 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-29 04:20:45 | Crosby, Texas, US | |
2741389 | 2741389 | 2022-07-07 | US | Alabama | Greene | 1063 | 1983 | 51 | 0 | 32.85504247 | -87.95684022 | 2022-07-08 04:20:56 | Greene, Alabama, US | |
3970028 | 3970028 | 2022-07-05 | US | West Virginia | Calhoun | 54013 | 1983 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-06 04:20:58 | Calhoun, West Virginia, US | |
594269 | 594269 | 2022-07-01 | US | Colorado | Conejos | 8021 | 1983 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-02 04:21:16 | Conejos, Colorado, US | |
3943148 | 3943148 | 2022-06-30 | US | Texas | Floyd | 48153 | 1983 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-07-01 04:21:10 | Floyd, Texas, US | |
2493126 | 2493126 | 2022-06-29 | US | Texas | Hamilton | 48193 | 1983 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-30 04:21:01 | Hamilton, Texas, US | |
2242508 | 2242508 | 2022-06-28 | US | Texas | Hamilton | 48193 | 1983 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-29 04:20:59 | Hamilton, Texas, US | |
2151019 | 2151019 | 2022-06-27 | US | Virginia | Middlesex | 51119 | 1983 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-28 04:20:58 | Middlesex, Virginia, US | |
2150750 | 2150750 | 2022-06-27 | US | Texas | Hamilton | 48193 | 1983 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-28 04:20:58 | Hamilton, Texas, US | |
478551 | 478551 | 2022-06-26 | US | Texas | Hamilton | 48193 | 1983 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-27 04:21:00 | Hamilton, Texas, US | |
941926 | 941926 | 2022-06-25 | US | Texas | Hamilton | 48193 | 1983 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-26 04:21:02 | Hamilton, Texas, US | |
3509777 | 3509777 | 2022-06-05 | US | North Dakota | Benson | 38005 | 1983 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-06-06 04:20:57 | Benson, North Dakota, US | |
3529854 | 3529854 | 2022-06-04 | US | North Dakota | Benson | 38005 | 1983 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-06-05 04:20:55 | Benson, North Dakota, US | |
1574555 | 1574555 | 2022-05-03 | US | North Dakota | Pembina | 38067 | 1983 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-04 04:20:59 | Pembina, North Dakota, US | |
466969 | 466969 | 2022-05-02 | US | Wisconsin | Pepin | 55091 | 1983 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-05-03 04:21:00 | Pepin, Wisconsin, US | |
878019 | 878019 | 2022-03-27 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-28 04:20:33 | Pipestone, Minnesota, US | |
2165302 | 2165302 | 2022-03-26 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-27 04:20:47 | Pipestone, Minnesota, US | |
1722238 | 1722238 | 2022-03-25 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-26 04:20:23 | Pipestone, Minnesota, US | |
1471617 | 1471617 | 2022-03-24 | US | West Virginia | Tucker | 54093 | 1983 | 36 | 0 | 39.11240885 | -79.57053576 | 2022-03-25 04:20:46 | Tucker, West Virginia, US | |
1469855 | 1469855 | 2022-03-24 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-25 04:20:46 | Pipestone, Minnesota, US | |
3025791 | 3025791 | 2022-03-23 | US | West Virginia | Tucker | 54093 | 1983 | 36 | 0 | 39.11240885 | -79.57053576 | 2022-03-24 04:20:43 | Tucker, West Virginia, US | |
3024029 | 3024029 | 2022-03-23 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-24 04:20:43 | Pipestone, Minnesota, US | |
1906951 | 1906951 | 2022-03-22 | US | Minnesota | Pipestone | 27117 | 1983 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-23 04:20:48 | Pipestone, Minnesota, US | |
1904995 | 1904995 | 2022-03-22 | China | Jiangsu | 1983 | 0 | 0 | 32.9711 | 119.455 | 2022-03-23 04:20:48 | Jiangsu, China | |||
920589 | 920589 | 2022-03-08 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-09 04:20:59 | Wilcox, Georgia, US | |
1548876 | 1548876 | 2022-03-07 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-08 04:20:54 | Wilcox, Georgia, US | |
2200545 | 2200545 | 2022-03-06 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-07 04:20:47 | Wilcox, Georgia, US | |
2093002 | 2093002 | 2022-03-05 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-06 04:20:49 | Wilcox, Georgia, US | |
2666702 | 2666702 | 2022-03-04 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-05 04:21:10 | Wilcox, Georgia, US | |
1647870 | 1647870 | 2022-03-03 | US | West Virginia | Pocahontas | 54075 | 1983 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-04 04:21:09 | Pocahontas, West Virginia, US | |
1645283 | 1645283 | 2022-03-03 | US | Idaho | Benewah | 16009 | 1983 | 40 | 0 | 47.21754179 | -116.6586851 | 2022-03-04 04:21:09 | Benewah, Idaho, US | |
1645267 | 1645267 | 2022-03-03 | US | Georgia | Wilcox | 13315 | 1983 | 68 | 0 | 31.97496928 | -83.43438555 | 2022-03-04 04:21:09 | Wilcox, Georgia, US | |
1511847 | 1511847 | 2022-02-24 | US | Alaska | Southeast Fairbanks | 2240 | 1983 | 16 | 0 | 63.87692095 | -143.2127643 | 2022-02-25 04:21:11 | Southeast Fairbanks, Alaska, US | |
1059836 | 1059836 | 2022-02-23 | US | Montana | Blaine | 30005 | 1983 | 30 | 0 | 48.43175214 | -108.9582723 | 2022-02-24 04:21:14 | Blaine, Montana, US | |
1058288 | 1058288 | 2022-02-23 | US | Alaska | Southeast Fairbanks | 2240 | 1983 | 16 | 0 | 63.87692095 | -143.2127643 | 2022-02-24 04:21:14 | Southeast Fairbanks, Alaska, US | |
3719106 | 3719106 | 2022-02-21 | US | Idaho | Benewah | 16009 | 1983 | 38 | 0 | 47.21754179 | -116.6586851 | 2022-02-22 04:21:01 | Benewah, Idaho, US | |
3912940 | 3912940 | 2022-02-20 | US | Idaho | Benewah | 16009 | 1983 | 38 | 0 | 47.21754179 | -116.6586851 | 2022-02-21 04:21:05 | Benewah, Idaho, US | |
3876498 | 3876498 | 2022-02-19 | US | Idaho | Benewah | 16009 | 1983 | 38 | 0 | 47.21754179 | -116.6586851 | 2022-02-20 04:21:00 | Benewah, Idaho, US | |
3856754 | 3856754 | 2022-02-18 | US | Idaho | Benewah | 16009 | 1983 | 38 | 0 | 47.21754179 | -116.6586851 | 2022-02-19 04:21:11 | Benewah, Idaho, US | |
3822185 | 3822185 | 2022-02-16 | US | Minnesota | Murray | 27101 | 1983 | 15 | 0 | 44.02216709 | -95.76328482 | 2022-02-17 04:20:56 | Murray, Minnesota, US | |
3674515 | 3674515 | 2022-02-15 | US | South Dakota | Custer | 46033 | 1983 | 22 | 0 | 43.67741105 | -103.45345209999999 | 2022-02-16 04:21:10 | Custer, South Dakota, US | |
3673399 | 3673399 | 2022-02-15 | US | Minnesota | Murray | 27101 | 1983 | 15 | 0 | 44.02216709 | -95.76328482 | 2022-02-16 04:21:10 | Murray, Minnesota, US | |
3673392 | 3673392 | 2022-02-15 | US | Minnesota | Marshall | 27089 | 1983 | 23 | 0 | 48.35825983 | -96.37017407 | 2022-02-16 04:21:10 | Marshall, Minnesota, US | |
189441 | 189441 | 2022-02-13 | US | Virginia | Madison | 51113 | 1983 | 31 | 0 | 38.41531222 | -78.28220331 | 2022-02-14 04:20:51 | Madison, Virginia, US | |
319287 | 319287 | 2022-02-12 | US | Virginia | Madison | 51113 | 1983 | 31 | 0 | 38.41531222 | -78.28220331 | 2022-02-13 04:21:00 | Madison, Virginia, US | |
236613 | 236613 | 2022-02-11 | US | Virginia | Madison | 51113 | 1983 | 31 | 0 | 38.41531222 | -78.28220331 | 2022-02-12 04:21:06 | Madison, Virginia, US | |
3075856 | 3075856 | 2022-02-09 | US | Mississippi | Humphreys | 28053 | 1983 | 41 | 0 | 33.12825718 | -90.52252707 | 2022-02-10 04:21:14 | Humphreys, Mississippi, US | |
71973 | 71973 | 2022-02-07 | US | Georgia | Terrell | 13273 | 1983 | 60 | 0 | 31.77527543 | -84.44069698 | 2022-02-08 04:21:15 | Terrell, Georgia, US | |
71488 | 71488 | 2022-02-07 | US | Alabama | Perry | 1105 | 1983 | 41 | 0 | 32.64048341 | -87.29770589 | 2022-02-08 04:21:15 | Perry, Alabama, US | |
462470 | 462470 | 2022-02-02 | US | Texas | Franklin | 48159 | 1983 | 37 | 0 | 33.17653242 | -95.21917243 | 2022-02-03 04:21:21 | Franklin, Texas, US | |
462251 | 462251 | 2022-02-02 | US | South Dakota | Grant | 46051 | 1983 | 48 | 0 | 45.1723937 | -96.77002276 | 2022-02-03 04:21:21 | Grant, South Dakota, US | |
462150 | 462150 | 2022-02-02 | US | Puerto Rico | Penuelas | 72111 | 1983 | 0 | 0 | 18.059645 | -66.721572 | 2022-02-03 04:21:21 | Penuelas, Puerto Rico, US | |
461407 | 461407 | 2022-02-02 | US | Montana | Rosebud | 30087 | 1983 | 58 | 0 | 46.23397237 | -106.72928799999998 | 2022-02-03 04:21:21 | Rosebud, Montana, US | |
1320119 | 1320119 | 2022-01-26 | US | Missouri | Gentry | 29075 | 1983 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-01-27 04:21:19 | Gentry, Missouri, 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]);