johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
547 rows where confirmed = 1178 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176230 | 3176230 | 2022-12-19 | US | North Dakota | Wells | 38103 | 1178 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-12-20 04:21:04 | Wells, North Dakota, US | |
3717035 | 3717035 | 2022-12-06 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-07 04:20:58 | Corson, South Dakota, US | |
2417740 | 2417740 | 2022-12-05 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-06 04:21:03 | Corson, South Dakota, US | |
721348 | 721348 | 2022-12-04 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-05 04:20:58 | Corson, South Dakota, US | |
2819637 | 2819637 | 2022-12-03 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-04 04:20:56 | Corson, South Dakota, US | |
836493 | 836493 | 2022-12-02 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-03 04:21:02 | Corson, South Dakota, US | |
2139023 | 2139023 | 2022-12-01 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-02 04:21:07 | Corson, South Dakota, US | |
1967439 | 1967439 | 2022-11-30 | US | South Dakota | Corson | 46031 | 1178 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-01 04:21:03 | Corson, South Dakota, US | |
3523239 | 3523239 | 2022-11-24 | China | Guizhou | 1178 | 2 | 0 | 26.8154 | 106.8748 | 2022-11-25 04:21:06 | Guizhou, China | |||
711116 | 711116 | 2022-11-01 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-11-02 04:22:09 | Washington, Colorado, US | |
3285565 | 3285565 | 2022-10-31 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-11-01 04:22:36 | Washington, Colorado, US | |
320598 | 320598 | 2022-10-30 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-10-31 04:21:36 | Washington, Colorado, US | |
912874 | 912874 | 2022-10-29 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-10-30 04:22:14 | Washington, Colorado, US | |
1367143 | 1367143 | 2022-10-28 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-10-29 04:21:13 | Washington, Colorado, US | |
3038998 | 3038998 | 2022-10-27 | US | Colorado | Washington | 8121 | 1178 | 33 | 0 | 39.97015535 | -103.202587 | 2022-10-28 04:22:31 | Washington, Colorado, US | |
539418 | 539418 | 2022-10-26 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-27 04:22:01 | Washington, Colorado, US | |
1830819 | 1830819 | 2022-10-25 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-26 04:22:19 | Washington, Colorado, US | |
795080 | 795080 | 2022-10-24 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-25 04:21:53 | Washington, Colorado, US | |
3277535 | 3277535 | 2022-10-23 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-24 04:22:29 | Washington, Colorado, US | |
2268573 | 2268573 | 2022-10-22 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-23 04:22:46 | Washington, Colorado, US | |
1592873 | 1592873 | 2022-10-21 | US | Colorado | Washington | 8121 | 1178 | 32 | 0 | 39.97015535 | -103.202587 | 2022-10-22 04:22:53 | Washington, Colorado, US | |
3573026 | 3573026 | 2022-09-19 | US | North Dakota | Sargent | 38081 | 1178 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-09-20 04:22:48 | Sargent, North Dakota, US | |
421765 | 421765 | 2022-09-18 | US | North Dakota | Sargent | 38081 | 1178 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-09-19 04:21:49 | Sargent, North Dakota, US | |
3375789 | 3375789 | 2022-09-17 | US | North Dakota | Sargent | 38081 | 1178 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-09-18 04:22:50 | Sargent, North Dakota, US | |
2357897 | 2357897 | 2022-09-16 | US | North Dakota | Sargent | 38081 | 1178 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-09-17 04:20:19 | Sargent, North Dakota, US | |
1681066 | 1681066 | 2022-08-29 | US | California | Modoc | 6049 | 1178 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-08-30 04:21:03 | Modoc, California, US | |
1877550 | 1877550 | 2022-08-28 | US | California | Modoc | 6049 | 1178 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-08-29 04:21:06 | Modoc, California, US | |
2096677 | 2096677 | 2022-08-27 | US | California | Modoc | 6049 | 1178 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-08-28 04:21:02 | Modoc, California, US | |
1532492 | 1532492 | 2022-08-26 | US | California | Modoc | 6049 | 1178 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-08-27 04:20:57 | Modoc, California, US | |
2829379 | 2829379 | 2022-08-25 | US | California | Modoc | 6049 | 1178 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-08-26 04:21:02 | Modoc, California, US | |
1253865 | 1253865 | 2022-08-23 | US | Texas | Hall | 48191 | 1178 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-08-24 04:20:46 | Hall, Texas, US | |
3953893 | 3953893 | 2022-08-17 | US | Virginia | Rappahannock | 51157 | 1178 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-18 04:21:11 | Rappahannock, Virginia, US | |
1488001 | 1488001 | 2022-07-26 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-27 04:21:04 | Aleutians East, Alaska, US | |
2596230 | 2596230 | 2022-07-25 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-26 04:20:58 | Guadalupe, New Mexico, US | |
2594447 | 2594447 | 2022-07-25 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-26 04:20:58 | Aleutians East, Alaska, US | |
898345 | 898345 | 2022-07-24 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-25 04:20:51 | Guadalupe, New Mexico, US | |
896562 | 896562 | 2022-07-24 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-25 04:20:51 | Aleutians East, Alaska, US | |
93339 | 93339 | 2022-07-23 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-24 04:20:47 | Guadalupe, New Mexico, US | |
91556 | 91556 | 2022-07-23 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-24 04:20:47 | Aleutians East, Alaska, US | |
902361 | 902361 | 2022-07-22 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-23 04:20:53 | Guadalupe, New Mexico, US | |
900578 | 900578 | 2022-07-22 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-23 04:20:53 | Aleutians East, Alaska, US | |
672497 | 672497 | 2022-07-21 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-22 04:21:15 | Guadalupe, New Mexico, US | |
670714 | 670714 | 2022-07-21 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-22 04:21:15 | Aleutians East, Alaska, US | |
1610460 | 1610460 | 2022-07-20 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-21 04:21:10 | Guadalupe, New Mexico, US | |
1608677 | 1608677 | 2022-07-20 | US | Alaska | Aleutians East | 2013 | 1178 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-07-21 04:21:10 | Aleutians East, Alaska, US | |
961093 | 961093 | 2022-07-19 | US | New Mexico | Guadalupe | 35019 | 1178 | 17 | 0 | 34.86319296 | -104.790669 | 2022-07-20 04:20:59 | Guadalupe, New Mexico, US | |
2154734 | 2154734 | 2022-07-16 | US | Texas | Donley | 48129 | 1178 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-17 04:21:15 | Donley, Texas, US | |
2421967 | 2421967 | 2022-07-15 | US | Texas | Donley | 48129 | 1178 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-16 04:21:05 | Donley, Texas, US | |
3432042 | 3432042 | 2022-07-14 | US | Texas | Donley | 48129 | 1178 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-15 04:20:53 | Donley, Texas, US | |
633196 | 633196 | 2022-07-12 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-13 04:20:58 | Grand Isle, Vermont, US | |
631261 | 631261 | 2022-07-12 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-13 04:20:58 | Stafford, Kansas, US | |
1214840 | 1214840 | 2022-07-11 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-12 04:20:51 | Grand Isle, Vermont, US | |
1212905 | 1212905 | 2022-07-11 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-12 04:20:51 | Stafford, Kansas, US | |
2792322 | 2792322 | 2022-07-10 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-11 04:20:46 | Grand Isle, Vermont, US | |
2790387 | 2790387 | 2022-07-10 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-11 04:20:46 | Stafford, Kansas, US | |
145275 | 145275 | 2022-07-09 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-10 04:20:54 | Grand Isle, Vermont, US | |
143340 | 143340 | 2022-07-09 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-10 04:20:54 | Stafford, Kansas, US | |
1420375 | 1420375 | 2022-07-08 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-09 04:20:59 | Grand Isle, Vermont, US | |
1418440 | 1418440 | 2022-07-08 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-09 04:20:59 | Stafford, Kansas, US | |
2744300 | 2744300 | 2022-07-07 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-08 04:20:56 | Grand Isle, Vermont, US | |
2742365 | 2742365 | 2022-07-07 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-08 04:20:56 | Stafford, Kansas, US | |
1203095 | 1203095 | 2022-07-06 | US | Vermont | Grand Isle | 50013 | 1178 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-07-07 04:20:55 | Grand Isle, Vermont, US | |
1201160 | 1201160 | 2022-07-06 | US | Kansas | Stafford | 20185 | 1178 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-07-07 04:20:55 | Stafford, Kansas, US | |
1111663 | 1111663 | 2022-05-21 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-22 04:20:52 | Howard, Nebraska, US | |
1171287 | 1171287 | 2022-05-20 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-21 04:20:58 | Howard, Nebraska, US | |
3898050 | 3898050 | 2022-05-19 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-20 04:20:57 | Howard, Nebraska, US | |
1186834 | 1186834 | 2022-05-18 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-19 04:20:54 | Howard, Nebraska, US | |
3584731 | 3584731 | 2022-05-17 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-18 04:20:50 | Howard, Nebraska, US | |
1505688 | 1505688 | 2022-05-16 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-17 04:20:59 | Howard, Nebraska, US | |
2086047 | 2086047 | 2022-05-15 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-16 04:20:47 | Howard, Nebraska, US | |
3356757 | 3356757 | 2022-05-14 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-15 04:20:53 | Howard, Nebraska, US | |
660402 | 660402 | 2022-05-13 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-14 04:20:48 | Howard, Nebraska, US | |
2535485 | 2535485 | 2022-05-12 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-13 04:20:51 | Howard, Nebraska, US | |
2535418 | 2535418 | 2022-05-12 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-13 04:20:51 | Pondera, Montana, US | |
3446931 | 3446931 | 2022-05-11 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-12 04:20:54 | Howard, Nebraska, US | |
3446864 | 3446864 | 2022-05-11 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-12 04:20:54 | Pondera, Montana, US | |
3537548 | 3537548 | 2022-05-10 | US | Nebraska | Howard | 31093 | 1178 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-05-11 04:20:48 | Howard, Nebraska, US | |
3537481 | 3537481 | 2022-05-10 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-11 04:20:48 | Pondera, Montana, US | |
224016 | 224016 | 2022-05-09 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-10 04:20:50 | Pondera, Montana, US | |
2333401 | 2333401 | 2022-05-08 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-09 04:20:54 | Pondera, Montana, US | |
362363 | 362363 | 2022-05-07 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-08 04:20:49 | Pondera, Montana, US | |
1399714 | 1399714 | 2022-05-06 | US | Montana | Pondera | 30073 | 1178 | 8 | 0 | 48.22773388 | -112.2252703 | 2022-05-07 04:21:09 | Pondera, Montana, US | |
1329579 | 1329579 | 2022-04-26 | US | Virginia | Emporia | 51595 | 1178 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-04-27 04:20:52 | Emporia, Virginia, US | |
2253569 | 2253569 | 2022-04-19 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-20 04:20:45 | Lander, Nevada, US | |
1848119 | 1848119 | 2022-04-18 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-19 04:21:00 | Lander, Nevada, US | |
3419063 | 3419063 | 2022-04-17 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-18 04:21:12 | Lander, Nevada, US | |
306012 | 306012 | 2022-04-16 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-17 04:20:59 | Lander, Nevada, US | |
2671957 | 2671957 | 2022-04-15 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-16 04:20:48 | Lander, Nevada, US | |
1225742 | 1225742 | 2022-04-14 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-15 04:20:57 | Lander, Nevada, US | |
2444900 | 2444900 | 2022-04-13 | US | Nevada | Lander | 32015 | 1178 | 21 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-04-13 23:21:06 | Lander, Nevada, US | |
3209520 | 3209520 | 2022-04-11 | US | Texas | Wheeler | 48483 | 1178 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-04-12 04:20:49 | Wheeler, Texas, US | |
1579406 | 1579406 | 2022-04-10 | US | Texas | Wheeler | 48483 | 1178 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-04-11 04:21:02 | Wheeler, Texas, US | |
1655648 | 1655648 | 2022-04-09 | US | Texas | Wheeler | 48483 | 1178 | 23 | 0 | 35.40114335 | -100.26995140000001 | 2022-04-10 04:20:52 | Wheeler, Texas, US | |
161337 | 161337 | 2022-03-29 | US | Virginia | Covington | 51580 | 1178 | 26 | 0 | 37.7824656 | -79.98631446 | 2022-03-30 04:20:45 | Covington, Virginia, US | |
1470167 | 1470167 | 2022-03-24 | US | Nebraska | Dixon | 31051 | 1178 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-03-25 04:20:46 | Dixon, Nebraska, US | |
263599 | 263599 | 2022-03-15 | US | Nebraska | Dixon | 31051 | 1178 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-03-16 04:20:50 | Dixon, Nebraska, US | |
2142264 | 2142264 | 2022-03-09 | US | Nebraska | Kearney | 31099 | 1178 | 5 | 0 | 40.50663314 | -98.94877182 | 2022-03-10 04:20:48 | Kearney, Nebraska, US | |
921775 | 921775 | 2022-03-08 | US | Nebraska | Kearney | 31099 | 1178 | 5 | 0 | 40.50663314 | -98.94877182 | 2022-03-09 04:20:59 | Kearney, Nebraska, US | |
1551088 | 1551088 | 2022-03-07 | US | Texas | Hemphill | 48211 | 1178 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-03-08 04:20:54 | Hemphill, Texas, US | |
2202757 | 2202757 | 2022-03-06 | US | Texas | Hemphill | 48211 | 1178 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-03-07 04:20:47 | Hemphill, 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]);