johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
630 rows where confirmed = 639 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2416530 | 2416530 | 2022-12-05 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-06 04:21:03 | Keweenaw, Michigan, US | |
720138 | 720138 | 2022-12-04 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-05 04:20:58 | Keweenaw, Michigan, US | |
2818427 | 2818427 | 2022-12-03 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-04 04:20:56 | Keweenaw, Michigan, US | |
835283 | 835283 | 2022-12-02 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-03 04:21:02 | Keweenaw, Michigan, US | |
2137813 | 2137813 | 2022-12-01 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-02 04:21:07 | Keweenaw, Michigan, US | |
1966229 | 1966229 | 2022-11-30 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-12-01 04:21:03 | Keweenaw, Michigan, US | |
2558243 | 2558243 | 2022-11-29 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-30 04:21:07 | Keweenaw, Michigan, US | |
1241317 | 1241317 | 2022-11-28 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-29 04:21:05 | Keweenaw, Michigan, US | |
3553305 | 3553305 | 2022-11-27 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-28 04:21:02 | Keweenaw, Michigan, US | |
2101785 | 2101785 | 2022-11-26 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-27 04:21:05 | Keweenaw, Michigan, US | |
489276 | 489276 | 2022-11-25 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-26 04:21:11 | Keweenaw, Michigan, US | |
3525105 | 3525105 | 2022-11-24 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-25 04:21:06 | Keweenaw, Michigan, US | |
3313888 | 3313888 | 2022-11-23 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-24 04:21:09 | Keweenaw, Michigan, US | |
1621929 | 1621929 | 2022-11-22 | US | Michigan | Keweenaw | 26083 | 639 | 15 | 0 | 47.63197653 | -88.41434263 | 2022-11-23 04:21:06 | Keweenaw, Michigan, US | |
295033 | 295033 | 2022-11-15 | US | Texas | Armstrong | 48011 | 639 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-11-16 04:21:09 | Armstrong, Texas, US | |
294161 | 294161 | 2022-11-15 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-16 04:21:09 | Lincoln, Nevada, US | |
3600063 | 3600063 | 2022-11-14 | US | Texas | Armstrong | 48011 | 639 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-11-15 04:21:16 | Armstrong, Texas, US | |
3599191 | 3599191 | 2022-11-14 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-15 04:21:16 | Lincoln, Nevada, US | |
314049 | 314049 | 2022-11-13 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-14 04:21:09 | Lincoln, Nevada, US | |
65210 | 65210 | 2022-11-12 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-13 04:21:14 | Lincoln, Nevada, US | |
2929372 | 2929372 | 2022-11-11 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-12 04:20:41 | Lincoln, Nevada, US | |
2508208 | 2508208 | 2022-11-10 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-11 04:21:22 | Lincoln, Nevada, US | |
2433083 | 2433083 | 2022-11-09 | US | Nevada | Lincoln | 32017 | 639 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-10 04:21:16 | Lincoln, Nevada, US | |
1831440 | 1831440 | 2022-10-25 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-26 04:22:19 | Elk, Kansas, US | |
795701 | 795701 | 2022-10-24 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-25 04:21:53 | Elk, Kansas, US | |
3278156 | 3278156 | 2022-10-23 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-24 04:22:29 | Elk, Kansas, US | |
2269194 | 2269194 | 2022-10-22 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-23 04:22:46 | Elk, Kansas, US | |
1593494 | 1593494 | 2022-10-21 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-22 04:22:53 | Elk, Kansas, US | |
2273210 | 2273210 | 2022-10-20 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-21 04:22:23 | Elk, Kansas, US | |
199545 | 199545 | 2022-10-19 | US | Kansas | Elk | 20049 | 639 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-10-20 04:22:59 | Elk, Kansas, US | |
421744 | 421744 | 2022-09-18 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-19 04:21:49 | Griggs, North Dakota, US | |
3375768 | 3375768 | 2022-09-17 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-18 04:22:50 | Griggs, North Dakota, US | |
2357876 | 2357876 | 2022-09-16 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-17 04:20:19 | Griggs, North Dakota, US | |
3989033 | 3989033 | 2022-09-15 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-16 04:21:19 | Griggs, North Dakota, US | |
1891550 | 1891550 | 2022-09-14 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-15 04:21:02 | Griggs, North Dakota, US | |
374605 | 374605 | 2022-09-13 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-14 04:20:44 | Griggs, North Dakota, US | |
2397207 | 2397207 | 2022-09-12 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-13 04:20:57 | Griggs, North Dakota, US | |
3768285 | 3768285 | 2022-09-11 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-12 04:20:58 | Griggs, North Dakota, US | |
3826860 | 3826860 | 2022-09-10 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-11 04:20:50 | Griggs, North Dakota, US | |
965317 | 965317 | 2022-09-09 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-10 04:21:10 | Griggs, North Dakota, US | |
255719 | 255719 | 2022-09-08 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-09 04:21:11 | Griggs, North Dakota, US | |
3747517 | 3747517 | 2022-09-07 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-08 04:21:02 | Griggs, North Dakota, US | |
117157 | 117157 | 2022-09-06 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-07 04:20:59 | Griggs, North Dakota, US | |
2636129 | 2636129 | 2022-09-05 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-06 04:21:02 | Griggs, North Dakota, US | |
2989693 | 2989693 | 2022-09-04 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-05 04:21:01 | Griggs, North Dakota, US | |
2715378 | 2715378 | 2022-09-03 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-04 04:21:22 | Griggs, North Dakota, US | |
1396083 | 1396083 | 2022-09-02 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-03 04:21:04 | Griggs, North Dakota, US | |
3549912 | 3549912 | 2022-09-01 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-02 04:21:07 | Griggs, North Dakota, US | |
2345832 | 2345832 | 2022-08-31 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-09-01 04:21:03 | Griggs, North Dakota, US | |
3776312 | 3776312 | 2022-08-30 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-31 04:20:57 | Griggs, North Dakota, US | |
1682908 | 1682908 | 2022-08-29 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-30 04:21:03 | Griggs, North Dakota, US | |
1879392 | 1879392 | 2022-08-28 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-29 04:21:06 | Griggs, North Dakota, US | |
2098519 | 2098519 | 2022-08-27 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-28 04:21:02 | Griggs, North Dakota, US | |
1534334 | 1534334 | 2022-08-26 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-27 04:20:57 | Griggs, North Dakota, US | |
2831221 | 2831221 | 2022-08-25 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-26 04:21:02 | Griggs, North Dakota, US | |
2325754 | 2325754 | 2022-08-24 | US | North Dakota | Griggs | 38039 | 639 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-08-25 04:21:13 | Griggs, North Dakota, US | |
1163362 | 1163362 | 2022-08-18 | US | New Mexico | De Baca | 35011 | 639 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-08-19 04:20:54 | De Baca, New Mexico, US | |
1066813 | 1066813 | 2022-07-28 | US | Idaho | Custer | 16037 | 639 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-07-29 04:20:45 | Custer, Idaho, US | |
2336332 | 2336332 | 2022-07-27 | US | Idaho | Custer | 16037 | 639 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-07-28 04:20:56 | Custer, Idaho, US | |
1488522 | 1488522 | 2022-07-26 | US | Idaho | Custer | 16037 | 639 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-07-27 04:21:04 | Custer, Idaho, US | |
2594968 | 2594968 | 2022-07-25 | US | Idaho | Custer | 16037 | 639 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-07-26 04:20:58 | Custer, Idaho, US | |
960174 | 960174 | 2022-07-19 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-20 04:20:59 | Decatur, Kansas, US | |
3211561 | 3211561 | 2022-07-18 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-19 04:20:58 | Decatur, Kansas, US | |
3406736 | 3406736 | 2022-07-17 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-18 04:20:59 | Decatur, Kansas, US | |
2152936 | 2152936 | 2022-07-16 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-17 04:21:15 | Decatur, Kansas, US | |
2420169 | 2420169 | 2022-07-15 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-16 04:21:05 | Decatur, Kansas, US | |
3430244 | 3430244 | 2022-07-14 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-15 04:20:53 | Decatur, Kansas, US | |
3110764 | 3110764 | 2022-07-13 | US | Kansas | Decatur | 20039 | 639 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-07-14 04:20:57 | Decatur, Kansas, US | |
631232 | 631232 | 2022-07-12 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-13 04:20:58 | Morton, Kansas, US | |
1212876 | 1212876 | 2022-07-11 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-12 04:20:51 | Morton, Kansas, US | |
2790358 | 2790358 | 2022-07-10 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-11 04:20:46 | Morton, Kansas, US | |
143311 | 143311 | 2022-07-09 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-10 04:20:54 | Morton, Kansas, US | |
1418411 | 1418411 | 2022-07-08 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-09 04:20:59 | Morton, Kansas, US | |
2742336 | 2742336 | 2022-07-07 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-08 04:20:56 | Morton, Kansas, US | |
1201131 | 1201131 | 2022-07-06 | US | Kansas | Morton | 20129 | 639 | 12 | 0 | 37.19141121 | -101.7992519 | 2022-07-07 04:20:55 | Morton, Kansas, US | |
3583068 | 3583068 | 2022-05-17 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-18 04:20:50 | Haines, Alaska, US | |
1504025 | 1504025 | 2022-05-16 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-17 04:20:59 | Haines, Alaska, US | |
2084384 | 2084384 | 2022-05-15 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-16 04:20:47 | Haines, Alaska, US | |
3355094 | 3355094 | 2022-05-14 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-15 04:20:53 | Haines, Alaska, US | |
658739 | 658739 | 2022-05-13 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-14 04:20:48 | Haines, Alaska, US | |
2535830 | 2535830 | 2022-05-12 | US | North Dakota | Towner | 38095 | 639 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-05-13 04:20:51 | Towner, North Dakota, US | |
2533822 | 2533822 | 2022-05-12 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-13 04:20:51 | Haines, Alaska, US | |
3445268 | 3445268 | 2022-05-11 | US | Alaska | Haines | 2100 | 639 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-05-12 04:20:54 | Haines, Alaska, US | |
3418385 | 3418385 | 2022-04-17 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-18 04:21:12 | Robertson, Kentucky, US | |
305334 | 305334 | 2022-04-16 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-17 04:20:59 | Robertson, Kentucky, US | |
2671279 | 2671279 | 2022-04-15 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-16 04:20:48 | Robertson, Kentucky, US | |
1225064 | 1225064 | 2022-04-14 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-15 04:20:57 | Robertson, Kentucky, US | |
2444222 | 2444222 | 2022-04-13 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-13 23:21:06 | Robertson, Kentucky, US | |
1949979 | 1949979 | 2022-04-12 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-13 04:21:03 | Robertson, Kentucky, US | |
3207732 | 3207732 | 2022-04-11 | US | Kentucky | Robertson | 21201 | 639 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-04-12 04:20:49 | Robertson, Kentucky, US | |
1995818 | 1995818 | 2022-03-01 | US | Texas | Lipscomb | 48295 | 639 | 15 | 0 | 36.27783108 | -100.27331509999999 | 2022-03-02 04:21:07 | Lipscomb, Texas, US | |
3721798 | 3721798 | 2022-02-21 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-22 04:21:01 | Niobrara, Wyoming, US | |
3915632 | 3915632 | 2022-02-20 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-21 04:21:05 | Niobrara, Wyoming, US | |
3879190 | 3879190 | 2022-02-19 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-20 04:21:00 | Niobrara, Wyoming, US | |
3859446 | 3859446 | 2022-02-18 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-19 04:21:11 | Niobrara, Wyoming, US | |
1301665 | 1301665 | 2022-02-17 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-18 04:21:04 | Niobrara, Wyoming, US | |
3824051 | 3824051 | 2022-02-16 | US | Wyoming | Niobrara | 56027 | 639 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-02-17 04:20:56 | Niobrara, Wyoming, US | |
980255 | 980255 | 2022-02-01 | US | Kansas | Kiowa | 20097 | 639 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-02-02 04:21:09 | Kiowa, Kansas, US | |
979866 | 979866 | 2022-02-01 | US | Idaho | Adams | 16003 | 639 | 14 | 0 | 44.89333571 | -116.4545247 | 2022-02-02 04:21:09 | Adams, Idaho, US | |
2659097 | 2659097 | 2022-01-31 | US | Kansas | Kiowa | 20097 | 639 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-02-01 04:21:11 | Kiowa, Kansas, 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]);