johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
520 rows where confirmed = 1167 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2951859 | 2951859 | 2022-12-20 | US | Arkansas | Calhoun | 5013 | 1167 | 14 | 0 | 33.55598792 | -92.49974403 | 2022-12-21 04:21:03 | Calhoun, Arkansas, US | |
1622675 | 1622675 | 2022-11-22 | US | North Dakota | Dunn | 38025 | 1167 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-11-23 04:21:06 | Dunn, North Dakota, US | |
541176 | 541176 | 2022-10-26 | US | North Dakota | Pierce | 38069 | 1167 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-10-27 04:22:01 | Pierce, North Dakota, US | |
2262981 | 2262981 | 2022-10-02 | US | Texas | San Augustine | 48405 | 1167 | 45 | 0 | 31.39457611 | -94.17000399 | 2022-10-03 04:23:11 | San Augustine, Texas, US | |
2998507 | 2998507 | 2022-10-01 | US | Texas | San Augustine | 48405 | 1167 | 45 | 0 | 31.39457611 | -94.17000399 | 2022-10-02 04:21:23 | San Augustine, Texas, US | |
856833 | 856833 | 2022-09-30 | US | Texas | San Augustine | 48405 | 1167 | 45 | 0 | 31.39457611 | -94.17000399 | 2022-10-01 04:23:01 | San Augustine, Texas, US | |
2497434 | 2497434 | 2022-08-15 | US | Virginia | Rappahannock | 51157 | 1167 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-16 04:20:58 | Rappahannock, Virginia, US | |
1101664 | 1101664 | 2022-08-03 | US | Wisconsin | Florence | 55037 | 1167 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-04 04:20:58 | Florence, Wisconsin, US | |
3874595 | 3874595 | 2022-07-31 | US | Texas | Brewster | 48043 | 1167 | 31 | 0 | 29.81008251 | -103.2520326 | 2022-08-01 04:21:03 | Brewster, Texas, US | |
677349 | 677349 | 2022-07-30 | US | Texas | Brewster | 48043 | 1167 | 31 | 0 | 29.81008251 | -103.2520326 | 2022-07-31 04:21:02 | Brewster, Texas, US | |
1786548 | 1786548 | 2022-07-29 | US | Texas | Brewster | 48043 | 1167 | 31 | 0 | 29.81008251 | -103.2520326 | 2022-07-30 04:20:42 | Brewster, Texas, US | |
3212482 | 3212482 | 2022-07-18 | US | New Mexico | Hidalgo | 35023 | 1167 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-07-19 04:20:58 | Hidalgo, New Mexico, US | |
630833 | 630833 | 2022-07-12 | US | Idaho | Boise | 16015 | 1167 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-07-13 04:20:58 | Boise, Idaho, US | |
1212477 | 1212477 | 2022-07-11 | US | Idaho | Boise | 16015 | 1167 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-07-12 04:20:51 | Boise, Idaho, US | |
3969627 | 3969627 | 2022-07-05 | US | Texas | Donley | 48129 | 1167 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-06 04:20:58 | Donley, Texas, US | |
2493344 | 2493344 | 2022-06-29 | US | Virginia | Craig | 51045 | 1167 | 20 | 0 | 37.48133648 | -80.21072274 | 2022-06-30 04:21:01 | Craig, Virginia, US | |
948202 | 948202 | 2022-06-14 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-15 04:20:54 | Stafford, Kansas, US | |
2980610 | 2980610 | 2022-06-13 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-14 04:20:52 | Stafford, Kansas, US | |
2236736 | 2236736 | 2022-06-12 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-13 04:21:14 | Stafford, Kansas, US | |
3142934 | 3142934 | 2022-06-11 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-12 04:20:53 | Stafford, Kansas, US | |
1945850 | 1945850 | 2022-06-10 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-11 04:21:01 | Stafford, Kansas, US | |
3159595 | 3159595 | 2022-06-09 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-10 04:20:55 | Reynolds, Missouri, US | |
3158989 | 3158989 | 2022-06-09 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-10 04:20:55 | Stafford, Kansas, US | |
1423062 | 1423062 | 2022-06-08 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-09 04:20:54 | Reynolds, Missouri, US | |
1422456 | 1422456 | 2022-06-08 | US | Kansas | Stafford | 20185 | 1167 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-06-09 04:20:54 | Stafford, Kansas, US | |
3728176 | 3728176 | 2022-06-07 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-08 04:20:55 | Reynolds, Missouri, US | |
3889578 | 3889578 | 2022-06-06 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-07 04:21:08 | Reynolds, Missouri, US | |
3509347 | 3509347 | 2022-06-05 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-06 04:20:57 | Reynolds, Missouri, US | |
3529424 | 3529424 | 2022-06-04 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-05 04:20:55 | Reynolds, Missouri, US | |
3135510 | 3135510 | 2022-06-03 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-04 04:20:58 | Reynolds, Missouri, US | |
3580585 | 3580585 | 2022-06-02 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-03 04:20:58 | Reynolds, Missouri, US | |
972878 | 972878 | 2022-06-01 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-02 05:20:39 | Reynolds, Missouri, US | |
231185 | 231185 | 2022-05-31 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-06-01 04:20:55 | Reynolds, Missouri, US | |
3187950 | 3187950 | 2022-05-30 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-31 04:20:51 | Reynolds, Missouri, US | |
3200099 | 3200099 | 2022-05-29 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-30 04:20:50 | Reynolds, Missouri, US | |
2726977 | 2726977 | 2022-05-28 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-29 04:20:53 | Reynolds, Missouri, US | |
1316158 | 1316158 | 2022-05-27 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-28 04:21:07 | Reynolds, Missouri, US | |
1851950 | 1851950 | 2022-05-26 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-27 04:20:56 | Reynolds, Missouri, US | |
2049826 | 2049826 | 2022-05-25 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-26 04:20:50 | Reynolds, Missouri, US | |
3001264 | 3001264 | 2022-05-24 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-25 04:20:56 | Reynolds, Missouri, US | |
3594985 | 3594985 | 2022-05-23 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-24 04:20:57 | Reynolds, Missouri, US | |
623837 | 623837 | 2022-05-22 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-26 04:20:50 | Reynolds, Missouri, US | |
1111533 | 1111533 | 2022-05-21 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-22 04:20:52 | Reynolds, Missouri, US | |
1171157 | 1171157 | 2022-05-20 | US | Missouri | Reynolds | 29179 | 1167 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-05-21 04:20:58 | Reynolds, Missouri, US | |
1573014 | 1573014 | 2022-05-03 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-05-04 04:20:59 | Talbot, Georgia, US | |
464274 | 464274 | 2022-05-02 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-05-03 04:21:00 | Talbot, Georgia, US | |
3918056 | 3918056 | 2022-05-01 | US | Montana | Pondera | 30073 | 1167 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-02 04:21:10 | Pondera, Montana, US | |
3916913 | 3916913 | 2022-05-01 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-05-02 04:21:10 | Talbot, Georgia, US | |
2842860 | 2842860 | 2022-04-30 | US | Montana | Pondera | 30073 | 1167 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-01 04:20:57 | Pondera, Montana, US | |
2841717 | 2841717 | 2022-04-30 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-05-01 04:20:57 | Talbot, Georgia, US | |
1159173 | 1159173 | 2022-04-29 | US | Montana | Pondera | 30073 | 1167 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-04-30 04:21:05 | Pondera, Montana, US | |
1158030 | 1158030 | 2022-04-29 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-04-30 04:21:05 | Talbot, Georgia, US | |
1698355 | 1698355 | 2022-04-28 | US | Montana | Pondera | 30073 | 1167 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-04-29 04:20:59 | Pondera, Montana, US | |
1697212 | 1697212 | 2022-04-28 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-04-29 04:20:59 | Talbot, Georgia, US | |
3853838 | 3853838 | 2022-04-27 | US | Montana | Pondera | 30073 | 1167 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-04-28 04:20:47 | Pondera, Montana, US | |
3852695 | 3852695 | 2022-04-27 | US | Georgia | Talbot | 13263 | 1167 | 32 | 0 | 32.69642758 | -84.53351366 | 2022-04-28 04:20:47 | Talbot, Georgia, US | |
3731636 | 3731636 | 2022-04-03 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-04-04 04:20:51 | Fulton, Kentucky, US | |
501071 | 501071 | 2022-04-02 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-04-03 04:20:48 | Fulton, Kentucky, US | |
3352056 | 3352056 | 2022-04-01 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-04-02 04:20:47 | Fulton, Kentucky, US | |
1541361 | 1541361 | 2022-03-31 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-04-01 04:20:28 | Fulton, Kentucky, US | |
2479374 | 2479374 | 2022-03-30 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-03-31 04:20:56 | Fulton, Kentucky, US | |
159415 | 159415 | 2022-03-29 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-03-30 04:20:45 | Fulton, Kentucky, US | |
1439837 | 1439837 | 2022-03-28 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-29 04:20:46 | Wheeler, Texas, US | |
1437986 | 1437986 | 2022-03-28 | US | Kentucky | Fulton | 21075 | 1167 | 28 | 0 | 36.55238827 | -89.20140068 | 2022-03-29 04:20:46 | Fulton, Kentucky, US | |
879518 | 879518 | 2022-03-27 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-28 04:20:33 | Wheeler, Texas, US | |
2166801 | 2166801 | 2022-03-26 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-27 04:20:47 | Wheeler, Texas, US | |
1723737 | 1723737 | 2022-03-25 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-26 04:20:23 | Wheeler, Texas, US | |
1471354 | 1471354 | 2022-03-24 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-25 04:20:46 | Wheeler, Texas, US | |
3025528 | 3025528 | 2022-03-23 | US | Texas | Wheeler | 48483 | 1167 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-03-24 04:20:43 | Wheeler, Texas, US | |
1868936 | 1868936 | 2022-03-10 | US | Washington | San Juan | 53055 | 1167 | 2 | 0 | 48.60182783 | -122.96745 | 2022-03-11 04:20:50 | San Juan, Washington, US | |
2143631 | 2143631 | 2022-03-09 | US | Washington | San Juan | 53055 | 1167 | 2 | 0 | 48.60182783 | -122.96745 | 2022-03-10 04:20:48 | San Juan, Washington, US | |
922851 | 922851 | 2022-03-08 | US | Texas | Martin | 48317 | 1167 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-03-09 04:20:59 | Martin, Texas, US | |
1994726 | 1994726 | 2022-03-01 | US | Nebraska | Dixon | 31051 | 1167 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-03-02 04:21:07 | Dixon, Nebraska, US | |
577931 | 577931 | 2022-02-25 | US | Texas | Goliad | 48175 | 1167 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-02-26 04:21:12 | Goliad, Texas, US | |
2014694 | 2014694 | 2022-02-06 | US | Montana | Broadwater | 30007 | 1167 | 18 | 0 | 46.33277565 | -111.49558130000001 | 2022-02-07 04:21:05 | Broadwater, Montana, US | |
1296023 | 1296023 | 2022-02-05 | US | Montana | Broadwater | 30007 | 1167 | 18 | 0 | 46.33277565 | -111.49558130000001 | 2022-02-06 04:21:00 | Broadwater, Montana, US | |
2329351 | 2329351 | 2022-02-04 | US | Montana | Broadwater | 30007 | 1167 | 18 | 0 | 46.33277565 | -111.49558130000001 | 2022-02-05 04:21:05 | Broadwater, Montana, US | |
2476043 | 2476043 | 2022-02-03 | US | Nebraska | Jefferson | 31095 | 1167 | 1 | 0 | 40.17584531 | -97.142601 | 2022-02-04 04:21:10 | Jefferson, Nebraska, US | |
2475691 | 2475691 | 2022-02-03 | US | Minnesota | Lincoln | 27081 | 1167 | 5 | 0 | 44.41311883 | -96.26688165 | 2022-02-04 04:21:10 | Lincoln, Minnesota, US | |
1780679 | 1780679 | 2022-01-27 | US | Kansas | Gray | 20069 | 1167 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-01-28 04:21:09 | Gray, Kansas, US | |
1319507 | 1319507 | 2022-01-26 | US | Kansas | Gray | 20069 | 1167 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-01-27 04:21:19 | Gray, Kansas, US | |
2052828 | 2052828 | 2022-01-25 | US | Idaho | Lemhi | 16059 | 1167 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-01-26 04:21:07 | Lemhi, Idaho, US | |
1142372 | 1142372 | 2022-01-23 | US | Kentucky | Owsley | 21189 | 1167 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-01-24 04:21:12 | Owsley, Kentucky, US | |
2834290 | 2834290 | 2022-01-22 | US | Kentucky | Owsley | 21189 | 1167 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-01-23 04:21:13 | Owsley, Kentucky, US | |
3426408 | 3426408 | 2022-01-21 | US | Kentucky | Owsley | 21189 | 1167 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-01-22 04:21:13 | Owsley, Kentucky, US | |
1963720 | 1963720 | 2022-01-20 | US | Texas | Lynn | 48305 | 1167 | 30 | 0 | 33.17657705 | -101.8162849 | 2022-01-21 04:21:09 | Lynn, Texas, US | |
2612249 | 2612249 | 2022-01-06 | US | New Mexico | Los Alamos | 35028 | 1167 | 11 | 0 | 35.86631386 | -106.31349850000001 | 2022-01-07 04:22:09 | Los Alamos, New Mexico, US | |
2780107 | 2780107 | 2021-12-31 | US | Texas | Hartley | 48205 | 1167 | 2 | 0 | 35.84008013 | -102.6029022 | 2022-01-01 04:22:14 | Hartley, Texas, US | |
1671821 | 1671821 | 2021-12-29 | US | Virginia | Lancaster | 51103 | 1167 | 24 | 0 | 37.71889653 | -76.46400482 | 2021-12-30 04:21:25 | Lancaster, Virginia, US | |
1433048 | 1433048 | 2021-12-28 | US | Arkansas | Dallas | 5039 | 1167 | 20 | 0 | 33.97042763 | -92.65167437 | 2021-12-29 03:21:43 | Dallas, Arkansas, US | |
1662815 | 1662815 | 2021-12-12 | US | North Dakota | Bottineau | 38009 | 1167 | 23 | 0 | 48.79106111 | -100.8378166 | 2021-12-13 04:22:02 | Bottineau, North Dakota, US | |
1666831 | 1666831 | 2021-12-11 | US | North Dakota | Bottineau | 38009 | 1167 | 23 | 0 | 48.79106111 | -100.8378166 | 2021-12-12 04:22:12 | Bottineau, North Dakota, US | |
1080959 | 1080959 | 2021-12-09 | US | Texas | Brooks | 48047 | 1167 | 47 | 0 | 27.03103197 | -98.21808402 | 2021-12-10 04:22:28 | Brooks, Texas, US | |
1031360 | 1031360 | 2021-12-06 | US | Illinois | Edwards | 17047 | 1167 | 19 | 0 | 38.41353228 | -88.05720863 | 2021-12-07 04:22:34 | Edwards, Illinois, US | |
1147798 | 1147798 | 2021-12-01 | US | South Dakota | Fall River | 46047 | 1167 | 24 | 0 | 43.23929297 | -103.5275691 | 2021-12-02 04:22:37 | Fall River, South Dakota, US | |
151029 | 151029 | 2021-11-29 | US | Illinois | Schuyler | 17169 | 1167 | 12 | 0 | 40.157179799999994 | -90.61114163 | 2021-11-30 04:22:53 | Schuyler, Illinois, US | |
1232260 | 1232260 | 2021-11-28 | US | Colorado | Kit Carson | 8063 | 1167 | 27 | 0 | 39.30497777 | -102.60221990000001 | 2021-11-29 04:22:30 | Kit Carson, Colorado, US | |
1016114 | 1016114 | 2021-11-21 | US | Minnesota | Wilkin | 27167 | 1167 | 15 | 0 | 46.35721532 | -96.4684375 | 2021-11-22 04:22:20 | Wilkin, Minnesota, US | |
1016066 | 1016066 | 2021-11-21 | US | Minnesota | Lac qui Parle | 27073 | 1167 | 25 | 0 | 44.9973857 | -96.17488219 | 2021-11-22 04:22:20 | Lac qui Parle, Minnesota, US | |
724278 | 724278 | 2021-11-20 | US | Minnesota | Wilkin | 27167 | 1167 | 15 | 0 | 46.35721532 | -96.4684375 | 2021-11-21 04:22:13 | Wilkin, Minnesota, 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]);