johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
438 rows where confirmed = 1568 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331242 | 331242 | 2022-12-27 | US | Virginia | Emporia | 51595 | 1568 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-12-28 04:21:04 | Emporia, Virginia, US | |
3715514 | 3715514 | 2022-12-06 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-07 04:20:58 | Rooks, Kansas, US | |
2416219 | 2416219 | 2022-12-05 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-06 04:21:03 | Rooks, Kansas, US | |
719827 | 719827 | 2022-12-04 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-05 04:20:58 | Rooks, Kansas, US | |
2818116 | 2818116 | 2022-12-03 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-04 04:20:56 | Rooks, Kansas, US | |
834972 | 834972 | 2022-12-02 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-03 04:21:02 | Rooks, Kansas, US | |
2137502 | 2137502 | 2022-12-01 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-02 04:21:07 | Rooks, Kansas, US | |
1965918 | 1965918 | 2022-11-30 | US | Kansas | Rooks | 20163 | 1568 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-01 04:21:03 | Rooks, Kansas, US | |
3554831 | 3554831 | 2022-11-27 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-28 04:21:02 | Mills, Texas, US | |
2103311 | 2103311 | 2022-11-26 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-27 04:21:05 | Mills, Texas, US | |
490802 | 490802 | 2022-11-25 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-26 04:21:11 | Mills, Texas, US | |
3526631 | 3526631 | 2022-11-24 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-25 04:21:06 | Mills, Texas, US | |
3315414 | 3315414 | 2022-11-23 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-24 04:21:09 | Mills, Texas, US | |
1623455 | 1623455 | 2022-11-22 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-23 04:21:06 | Mills, Texas, US | |
1620056 | 1620056 | 2022-11-22 | China | Anhui | 1568 | 6 | 0 | 31.8257 | 117.2264 | 2022-11-23 04:21:06 | Anhui, China | |||
3463343 | 3463343 | 2022-11-21 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-22 04:20:47 | Mills, Texas, US | |
1643528 | 1643528 | 2022-11-20 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-21 04:21:05 | Mills, Texas, US | |
2067085 | 2067085 | 2022-11-19 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-20 04:21:08 | Mills, Texas, US | |
1758479 | 1758479 | 2022-11-18 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-19 04:21:14 | Mills, Texas, US | |
3029472 | 3029472 | 2022-11-17 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-18 04:21:15 | Mills, Texas, US | |
2489183 | 2489183 | 2022-11-16 | US | Texas | Mills | 48333 | 1568 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-11-17 04:21:11 | Mills, Texas, US | |
2759831 | 2759831 | 2022-10-18 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-19 04:22:26 | Tripp, South Dakota, US | |
2027665 | 2027665 | 2022-10-17 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-18 04:22:42 | Tripp, South Dakota, US | |
2162443 | 2162443 | 2022-10-16 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-17 04:20:31 | Tripp, South Dakota, US | |
518640 | 518640 | 2022-10-15 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-16 04:22:39 | Tripp, South Dakota, US | |
2035697 | 2035697 | 2022-10-14 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-15 04:22:00 | Tripp, South Dakota, US | |
3756385 | 3756385 | 2022-10-13 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-14 04:22:28 | Tripp, South Dakota, US | |
3217210 | 3217210 | 2022-10-12 | US | South Dakota | Tripp | 46123 | 1568 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-10-13 04:22:39 | Tripp, South Dakota, US | |
2970795 | 2970795 | 2022-10-10 | US | Virginia | Norton | 51720 | 1568 | 23 | 0 | 36.93357076 | -82.62750411 | 2022-10-11 04:23:05 | Norton, Virginia, US | |
3746814 | 3746814 | 2022-09-07 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-08 04:21:02 | Big Stone, Minnesota, US | |
116454 | 116454 | 2022-09-06 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-07 04:20:59 | Big Stone, Minnesota, US | |
2635426 | 2635426 | 2022-09-05 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-06 04:21:02 | Big Stone, Minnesota, US | |
2988990 | 2988990 | 2022-09-04 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-05 04:21:01 | Big Stone, Minnesota, US | |
2714675 | 2714675 | 2022-09-03 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-04 04:21:22 | Big Stone, Minnesota, US | |
1395380 | 1395380 | 2022-09-02 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-03 04:21:04 | Big Stone, Minnesota, US | |
3549209 | 3549209 | 2022-09-01 | US | Minnesota | Big Stone | 27011 | 1568 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-09-02 04:21:07 | Big Stone, Minnesota, US | |
2345973 | 2345973 | 2022-08-31 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-09-01 04:21:03 | Cotton, Oklahoma, US | |
3776453 | 3776453 | 2022-08-30 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-31 04:20:57 | Cotton, Oklahoma, US | |
1683049 | 1683049 | 2022-08-29 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-30 04:21:03 | Cotton, Oklahoma, US | |
1879533 | 1879533 | 2022-08-28 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-29 04:21:06 | Cotton, Oklahoma, US | |
2098660 | 2098660 | 2022-08-27 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-28 04:21:02 | Cotton, Oklahoma, US | |
1534475 | 1534475 | 2022-08-26 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-27 04:20:57 | Cotton, Oklahoma, US | |
2831362 | 2831362 | 2022-08-25 | US | Oklahoma | Cotton | 40033 | 1568 | 34 | 0 | 34.28845626 | -98.37053567 | 2022-08-26 04:21:02 | Cotton, Oklahoma, US | |
1087199 | 1087199 | 2022-08-09 | US | Indiana | Ohio | 18115 | 1568 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-10 04:20:57 | Ohio, Indiana, US | |
3547015 | 3547015 | 2022-08-08 | US | West Virginia | Wirt | 54105 | 1568 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-08-09 04:20:34 | Wirt, West Virginia, US | |
3544614 | 3544614 | 2022-08-08 | US | Indiana | Ohio | 18115 | 1568 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-09 04:20:34 | Ohio, Indiana, US | |
1407136 | 1407136 | 2022-08-02 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-08-03 04:20:59 | Keith, Nebraska, US | |
3619174 | 3619174 | 2022-08-01 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-08-02 04:20:53 | Keith, Nebraska, US | |
3873654 | 3873654 | 2022-07-31 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-08-01 04:21:03 | Keith, Nebraska, US | |
676408 | 676408 | 2022-07-30 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-31 04:21:02 | Keith, Nebraska, US | |
1785607 | 1785607 | 2022-07-29 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-30 04:20:42 | Keith, Nebraska, US | |
1067970 | 1067970 | 2022-07-28 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-29 04:20:45 | Keith, Nebraska, US | |
2337489 | 2337489 | 2022-07-27 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-28 04:20:56 | Keith, Nebraska, US | |
1489679 | 1489679 | 2022-07-26 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-27 04:21:04 | Keith, Nebraska, US | |
2596125 | 2596125 | 2022-07-25 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-26 04:20:58 | Keith, Nebraska, US | |
898240 | 898240 | 2022-07-24 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-25 04:20:51 | Keith, Nebraska, US | |
93234 | 93234 | 2022-07-23 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-24 04:20:47 | Keith, Nebraska, US | |
902256 | 902256 | 2022-07-22 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-23 04:20:53 | Keith, Nebraska, US | |
672392 | 672392 | 2022-07-21 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-22 04:21:15 | Keith, Nebraska, US | |
1610355 | 1610355 | 2022-07-20 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-21 04:21:10 | Keith, Nebraska, US | |
960988 | 960988 | 2022-07-19 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-20 04:20:59 | Keith, Nebraska, US | |
3212375 | 3212375 | 2022-07-18 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-19 04:20:58 | Keith, Nebraska, US | |
3407550 | 3407550 | 2022-07-17 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-18 04:20:59 | Keith, Nebraska, US | |
2154788 | 2154788 | 2022-07-16 | US | Texas | Jack | 48237 | 1568 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-07-17 04:21:15 | Jack, Texas, US | |
2153750 | 2153750 | 2022-07-16 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-17 04:21:15 | Keith, Nebraska, US | |
2420983 | 2420983 | 2022-07-15 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-16 04:21:05 | Keith, Nebraska, US | |
3431058 | 3431058 | 2022-07-14 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-15 04:20:53 | Keith, Nebraska, US | |
3113038 | 3113038 | 2022-07-13 | US | Wisconsin | Iron | 55051 | 1568 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-07-14 04:20:57 | Iron, Wisconsin, US | |
3111578 | 3111578 | 2022-07-13 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-14 04:20:57 | Keith, Nebraska, US | |
632953 | 632953 | 2022-07-12 | US | Texas | Carson | 48065 | 1568 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-13 04:20:58 | Carson, Texas, US | |
632001 | 632001 | 2022-07-12 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-13 04:20:58 | Keith, Nebraska, US | |
1214597 | 1214597 | 2022-07-11 | US | Texas | Carson | 48065 | 1568 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-12 04:20:51 | Carson, Texas, US | |
1213645 | 1213645 | 2022-07-11 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-12 04:20:51 | Keith, Nebraska, US | |
2792079 | 2792079 | 2022-07-10 | US | Texas | Carson | 48065 | 1568 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-11 04:20:46 | Carson, Texas, US | |
2791127 | 2791127 | 2022-07-10 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-11 04:20:46 | Keith, Nebraska, US | |
144080 | 144080 | 2022-07-09 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-10 04:20:54 | Keith, Nebraska, US | |
1419180 | 1419180 | 2022-07-08 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-09 04:20:59 | Keith, Nebraska, US | |
2743105 | 2743105 | 2022-07-07 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-08 04:20:56 | Keith, Nebraska, US | |
1201900 | 1201900 | 2022-07-06 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-07 04:20:55 | Keith, Nebraska, US | |
3968643 | 3968643 | 2022-07-05 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-06 04:20:58 | Keith, Nebraska, US | |
3080154 | 3080154 | 2022-07-04 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-05 04:20:45 | Keith, Nebraska, US | |
3078689 | 3078689 | 2022-07-04 | US | Colorado | Huerfano | 8055 | 1568 | 37 | 0 | 37.68473101 | -104.9612585 | 2022-07-05 04:20:45 | Huerfano, Colorado, US | |
1769436 | 1769436 | 2022-07-03 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-04 04:20:54 | Keith, Nebraska, US | |
3367422 | 3367422 | 2022-07-02 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-03 04:20:59 | Keith, Nebraska, US | |
595751 | 595751 | 2022-07-01 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-02 04:21:16 | Keith, Nebraska, US | |
3943224 | 3943224 | 2022-06-30 | US | Texas | Lynn | 48305 | 1568 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-01 04:21:10 | Lynn, Texas, US | |
3942152 | 3942152 | 2022-06-30 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-07-01 04:21:10 | Keith, Nebraska, US | |
2493182 | 2493182 | 2022-06-29 | US | Texas | Lynn | 48305 | 1568 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-06-30 04:21:01 | Lynn, Texas, US | |
2492110 | 2492110 | 2022-06-29 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-30 04:21:01 | Keith, Nebraska, US | |
2241492 | 2241492 | 2022-06-28 | US | Nebraska | Keith | 31101 | 1568 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-29 04:20:59 | Keith, Nebraska, US | |
1650411 | 1650411 | 2022-06-23 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-24 04:20:58 | Stillwater, Montana, US | |
2189646 | 2189646 | 2022-06-22 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-23 04:20:55 | Stillwater, Montana, US | |
168077 | 168077 | 2022-06-21 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-22 04:20:54 | Stillwater, Montana, US | |
1765360 | 1765360 | 2022-06-20 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-21 04:20:56 | Stillwater, Montana, US | |
3271546 | 3271546 | 2022-06-19 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-20 04:21:01 | Stillwater, Montana, US | |
3399458 | 3399458 | 2022-06-18 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-19 04:20:51 | Stillwater, Montana, US | |
2313335 | 2313335 | 2022-06-17 | US | Montana | Stillwater | 30095 | 1568 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-06-18 04:21:10 | Stillwater, Montana, US | |
3727968 | 3727968 | 2022-06-07 | US | Minnesota | Norman | 27107 | 1568 | 14 | 0 | 47.32628443 | -96.45620947 | 2022-06-08 04:20:55 | Norman, Minnesota, US | |
3436618 | 3436618 | 2022-04-22 | China | Guangxi | 1568 | 2 | 0 | 23.8298 | 108.7881 | 2022-04-23 04:20:50 | Guangxi, China | |||
2892203 | 2892203 | 2022-04-21 | China | Guangxi | 1568 | 2 | 0 | 23.8298 | 108.7881 | 2022-04-22 04:20:45 | Guangxi, China |
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]);