johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
374 rows where confirmed = 1922 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
721861 | 721861 | 2022-12-04 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-12-05 04:20:58 | Mathews, Virginia, US | |
2820150 | 2820150 | 2022-12-03 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-12-04 04:20:56 | Mathews, Virginia, US | |
837006 | 837006 | 2022-12-02 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-12-03 04:21:02 | Mathews, Virginia, US | |
2139536 | 2139536 | 2022-12-01 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-12-02 04:21:07 | Mathews, Virginia, US | |
1967952 | 1967952 | 2022-11-30 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-12-01 04:21:03 | Mathews, Virginia, US | |
2559966 | 2559966 | 2022-11-29 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-30 04:21:07 | Mathews, Virginia, US | |
1243040 | 1243040 | 2022-11-28 | US | Virginia | Mathews | 51115 | 1922 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-29 04:21:05 | Mathews, Virginia, US | |
2273892 | 2273892 | 2022-10-20 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-21 04:22:23 | Shelby, Missouri, US | |
200227 | 200227 | 2022-10-19 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-20 04:22:59 | Shelby, Missouri, US | |
2758888 | 2758888 | 2022-10-18 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-19 04:22:26 | Shelby, Missouri, US | |
2026722 | 2026722 | 2022-10-17 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-18 04:22:42 | Shelby, Missouri, US | |
2161500 | 2161500 | 2022-10-16 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-17 04:20:31 | Shelby, Missouri, US | |
517697 | 517697 | 2022-10-15 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-16 04:22:39 | Shelby, Missouri, US | |
2034754 | 2034754 | 2022-10-14 | US | Missouri | Shelby | 29205 | 1922 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-10-15 04:22:00 | Shelby, Missouri, US | |
2261227 | 2261227 | 2022-10-02 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-10-03 04:23:11 | Owsley, Kentucky, US | |
2996753 | 2996753 | 2022-10-01 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-10-02 04:21:23 | Owsley, Kentucky, US | |
855079 | 855079 | 2022-09-30 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-10-01 04:23:01 | Owsley, Kentucky, US | |
2377443 | 2377443 | 2022-09-29 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-30 04:23:09 | Daviess, Missouri, US | |
2377005 | 2377005 | 2022-09-29 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-30 04:23:09 | Owsley, Kentucky, US | |
1563262 | 1563262 | 2022-09-28 | US | Texas | Marion | 48315 | 1922 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-09-29 04:22:34 | Marion, Texas, US | |
1561994 | 1561994 | 2022-09-28 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-29 04:22:34 | Daviess, Missouri, US | |
1561556 | 1561556 | 2022-09-28 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-29 04:22:34 | Owsley, Kentucky, US | |
3997805 | 3997805 | 2022-09-27 | US | Texas | Marion | 48315 | 1922 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-09-28 04:23:01 | Marion, Texas, US | |
3996537 | 3996537 | 2022-09-27 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-28 04:23:01 | Daviess, Missouri, US | |
3996099 | 3996099 | 2022-09-27 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-28 04:23:01 | Owsley, Kentucky, US | |
2772133 | 2772133 | 2022-09-26 | US | Texas | Marion | 48315 | 1922 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-09-27 04:23:01 | Marion, Texas, US | |
2770865 | 2770865 | 2022-09-26 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-27 04:23:01 | Daviess, Missouri, US | |
2770427 | 2770427 | 2022-09-26 | US | Kentucky | Owsley | 21189 | 1922 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-27 04:23:01 | Owsley, Kentucky, US | |
1978518 | 1978518 | 2022-09-25 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-26 04:20:52 | Daviess, Missouri, US | |
2651685 | 2651685 | 2022-09-24 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-25 04:23:31 | Daviess, Missouri, US | |
386125 | 386125 | 2022-09-23 | US | Missouri | Daviess | 29061 | 1922 | 31 | 0 | 39.96145298 | -93.98519678 | 2022-09-24 04:21:40 | Daviess, Missouri, US | |
2017984 | 2017984 | 2022-09-20 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-21 04:23:22 | Worth, Iowa, US | |
3571857 | 3571857 | 2022-09-19 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-20 04:22:48 | Worth, Iowa, US | |
420596 | 420596 | 2022-09-18 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-19 04:21:49 | Worth, Iowa, US | |
3374620 | 3374620 | 2022-09-17 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-18 04:22:50 | Worth, Iowa, US | |
2356728 | 2356728 | 2022-09-16 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-17 04:20:19 | Worth, Iowa, US | |
3987885 | 3987885 | 2022-09-15 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-16 04:21:19 | Worth, Iowa, US | |
1890402 | 1890402 | 2022-09-14 | US | Iowa | Worth | 19195 | 1922 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-15 04:21:02 | Worth, Iowa, US | |
1532411 | 1532411 | 2022-08-26 | US | Arkansas | Dallas | 5039 | 1922 | 34 | 0 | 33.97042763 | -92.65167437 | 2022-08-27 04:20:57 | Dallas, Arkansas, US | |
2154859 | 2154859 | 2022-07-16 | US | Texas | Rains | 48379 | 1922 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-17 04:21:15 | Rains, Texas, US | |
2242692 | 2242692 | 2022-06-28 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-29 04:20:59 | Unassigned, Vermont, US | |
2150934 | 2150934 | 2022-06-27 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-28 04:20:58 | Unassigned, Vermont, US | |
478735 | 478735 | 2022-06-26 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-27 04:21:00 | Unassigned, Vermont, US | |
942110 | 942110 | 2022-06-25 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-26 04:21:02 | Unassigned, Vermont, US | |
3349930 | 3349930 | 2022-06-24 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-25 04:20:57 | Unassigned, Vermont, US | |
1651671 | 1651671 | 2022-06-23 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-24 04:20:58 | Unassigned, Vermont, US | |
2190906 | 2190906 | 2022-06-22 | US | Vermont | Unassigned | 90050 | 1922 | 3 | 0 | 44.85627605 | 0.0 | 2022-06-23 04:20:55 | Unassigned, Vermont, US | |
166421 | 166421 | 2022-06-21 | US | Alabama | Greene | 1063 | 1922 | 50 | 0 | 32.85504247 | -87.95684022 | 2022-06-22 04:20:54 | Greene, Alabama, US | |
3891097 | 3891097 | 2022-06-06 | US | West Virginia | Calhoun | 54013 | 1922 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-06-07 04:21:08 | Calhoun, West Virginia, US | |
971553 | 971553 | 2022-06-01 | US | Colorado | Lake | 8065 | 1922 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-02 05:20:39 | Lake, Colorado, US | |
3189607 | 3189607 | 2022-05-30 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-31 04:20:51 | Platte, Wyoming, US | |
3201756 | 3201756 | 2022-05-29 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-30 04:20:50 | Platte, Wyoming, US | |
2728634 | 2728634 | 2022-05-28 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-29 04:20:53 | Platte, Wyoming, US | |
1317815 | 1317815 | 2022-05-27 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-28 04:21:07 | Platte, Wyoming, US | |
1853607 | 1853607 | 2022-05-26 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-27 04:20:56 | Platte, Wyoming, US | |
2051483 | 2051483 | 2022-05-25 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-26 04:20:50 | Platte, Wyoming, US | |
3002921 | 3002921 | 2022-05-24 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-25 04:20:56 | Platte, Wyoming, US | |
625494 | 625494 | 2022-05-22 | US | Wyoming | Platte | 56031 | 1922 | 41 | 0 | 42.13299116 | -104.966331 | 2022-05-26 04:20:50 | Platte, Wyoming, US | |
467013 | 467013 | 2022-05-02 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-05-03 04:21:00 | Sublette, Wyoming, US | |
3919652 | 3919652 | 2022-05-01 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-05-02 04:21:10 | Sublette, Wyoming, US | |
2844456 | 2844456 | 2022-04-30 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-05-01 04:20:57 | Sublette, Wyoming, US | |
1160769 | 1160769 | 2022-04-29 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-04-30 04:21:05 | Sublette, Wyoming, US | |
1699951 | 1699951 | 2022-04-28 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-04-29 04:20:59 | Sublette, Wyoming, US | |
3855434 | 3855434 | 2022-04-27 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-04-28 04:20:47 | Sublette, Wyoming, US | |
1329864 | 1329864 | 2022-04-26 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-27 04:20:52 | Sublette, Wyoming, US | |
3725818 | 3725818 | 2022-04-25 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-26 04:20:51 | Sublette, Wyoming, US | |
2032386 | 2032386 | 2022-04-24 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-25 04:20:56 | Sublette, Wyoming, US | |
749961 | 749961 | 2022-04-23 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-24 04:20:56 | Sublette, Wyoming, US | |
749092 | 749092 | 2022-04-23 | US | Puerto Rico | Hormigueros | 72067 | 1922 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-24 04:20:56 | Hormigueros, Puerto Rico, US | |
3440446 | 3440446 | 2022-04-22 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-23 04:20:50 | Sublette, Wyoming, US | |
2896031 | 2896031 | 2022-04-21 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-22 04:20:45 | Sublette, Wyoming, US | |
2310903 | 2310903 | 2022-04-20 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-21 04:20:46 | Sublette, Wyoming, US | |
2255042 | 2255042 | 2022-04-19 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-20 04:20:45 | Sublette, Wyoming, US | |
1849592 | 1849592 | 2022-04-18 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-19 04:21:00 | Sublette, Wyoming, US | |
3420536 | 3420536 | 2022-04-17 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-18 04:21:12 | Sublette, Wyoming, US | |
3420028 | 3420028 | 2022-04-17 | US | Texas | Hansford | 48195 | 1922 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-04-18 04:21:12 | Hansford, Texas, US | |
307485 | 307485 | 2022-04-16 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-17 04:20:59 | Sublette, Wyoming, US | |
306977 | 306977 | 2022-04-16 | US | Texas | Hansford | 48195 | 1922 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-04-17 04:20:59 | Hansford, Texas, US | |
2673430 | 2673430 | 2022-04-15 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-16 04:20:48 | Sublette, Wyoming, US | |
2672922 | 2672922 | 2022-04-15 | US | Texas | Hansford | 48195 | 1922 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-04-16 04:20:48 | Hansford, Texas, US | |
1227215 | 1227215 | 2022-04-14 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-15 04:20:57 | Sublette, Wyoming, US | |
1226707 | 1226707 | 2022-04-14 | US | Texas | Hansford | 48195 | 1922 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-04-15 04:20:57 | Hansford, Texas, US | |
2446373 | 2446373 | 2022-04-13 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-13 23:21:06 | Sublette, Wyoming, US | |
2445865 | 2445865 | 2022-04-13 | US | Texas | Hansford | 48195 | 1922 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-04-13 23:21:06 | Hansford, Texas, US | |
1952130 | 1952130 | 2022-04-12 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-04-13 04:21:03 | Sublette, Wyoming, US | |
878067 | 878067 | 2022-03-27 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-28 04:20:33 | Franklin, Mississippi, US | |
2165350 | 2165350 | 2022-03-26 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-27 04:20:47 | Franklin, Mississippi, US | |
1722286 | 1722286 | 2022-03-25 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-26 04:20:23 | Franklin, Mississippi, US | |
1469903 | 1469903 | 2022-03-24 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-25 04:20:46 | Franklin, Mississippi, US | |
3024077 | 3024077 | 2022-03-23 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-24 04:20:43 | Franklin, Mississippi, US | |
1906999 | 1906999 | 2022-03-22 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-23 04:20:48 | Franklin, Mississippi, US | |
3240130 | 3240130 | 2022-03-21 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-22 04:20:54 | Franklin, Mississippi, US | |
3238837 | 3238837 | 2022-03-21 | US | Arkansas | Monroe | 5095 | 1922 | 33 | 0 | 34.6815935 | -91.20540287 | 2022-03-22 04:20:54 | Monroe, Arkansas, US | |
3629760 | 3629760 | 2022-03-13 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-14 04:20:46 | Franklin, Mississippi, US | |
952668 | 952668 | 2022-03-12 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-13 04:20:49 | Franklin, Mississippi, US | |
358129 | 358129 | 2022-03-11 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-12 04:20:50 | Franklin, Mississippi, US | |
1867281 | 1867281 | 2022-03-10 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-11 04:20:50 | Franklin, Mississippi, US | |
2143790 | 2143790 | 2022-03-09 | US | Wyoming | Sublette | 56035 | 1922 | 27 | 0 | 42.76558279 | -109.91309220000001 | 2022-03-10 04:20:48 | Sublette, Wyoming, US | |
2141976 | 2141976 | 2022-03-09 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-10 04:20:48 | Franklin, Mississippi, US | |
921487 | 921487 | 2022-03-08 | US | Mississippi | Franklin | 28037 | 1922 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-03-09 04:20:59 | Franklin, Mississippi, 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]);