johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
639 rows where confirmed = 770 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713322 | 713322 | 2022-11-01 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-02 04:22:09 | Douglas, South Dakota, US | |
3287771 | 3287771 | 2022-10-31 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-01 04:22:36 | Douglas, South Dakota, US | |
322804 | 322804 | 2022-10-30 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-10-31 04:21:36 | Douglas, South Dakota, US | |
915080 | 915080 | 2022-10-29 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-10-30 04:22:14 | Douglas, South Dakota, US | |
1369349 | 1369349 | 2022-10-28 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-10-29 04:21:13 | Douglas, South Dakota, US | |
3041204 | 3041204 | 2022-10-27 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-10-28 04:22:31 | Douglas, South Dakota, US | |
541624 | 541624 | 2022-10-26 | US | South Dakota | Douglas | 46043 | 770 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-10-27 04:22:01 | Douglas, South Dakota, US | |
1831075 | 1831075 | 2022-10-25 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-26 04:22:19 | Adams, Idaho, US | |
795336 | 795336 | 2022-10-24 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-25 04:21:53 | Adams, Idaho, US | |
3277791 | 3277791 | 2022-10-23 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-24 04:22:29 | Adams, Idaho, US | |
2268829 | 2268829 | 2022-10-22 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-23 04:22:46 | Adams, Idaho, US | |
1593129 | 1593129 | 2022-10-21 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-22 04:22:53 | Adams, Idaho, US | |
2272845 | 2272845 | 2022-10-20 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-21 04:22:23 | Adams, Idaho, US | |
199180 | 199180 | 2022-10-19 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-20 04:22:59 | Adams, Idaho, US | |
2757841 | 2757841 | 2022-10-18 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-19 04:22:26 | Adams, Idaho, US | |
2025675 | 2025675 | 2022-10-17 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-18 04:22:42 | Adams, Idaho, US | |
2160453 | 2160453 | 2022-10-16 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-17 04:20:31 | Adams, Idaho, US | |
516650 | 516650 | 2022-10-15 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-16 04:22:39 | Adams, Idaho, US | |
2033707 | 2033707 | 2022-10-14 | US | Idaho | Adams | 16003 | 770 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-10-15 04:22:00 | Adams, Idaho, US | |
2997704 | 2997704 | 2022-10-01 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-02 04:21:23 | McIntosh, North Dakota, US | |
856030 | 856030 | 2022-09-30 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-01 04:23:01 | McIntosh, North Dakota, US | |
2377956 | 2377956 | 2022-09-29 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-30 04:23:09 | McIntosh, North Dakota, US | |
1562507 | 1562507 | 2022-09-28 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-29 04:22:34 | McIntosh, North Dakota, US | |
3997050 | 3997050 | 2022-09-27 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-28 04:23:01 | McIntosh, North Dakota, US | |
2771378 | 2771378 | 2022-09-26 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-27 04:23:01 | McIntosh, North Dakota, US | |
1979031 | 1979031 | 2022-09-25 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-26 04:20:52 | McIntosh, North Dakota, US | |
2652198 | 2652198 | 2022-09-24 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-25 04:23:31 | McIntosh, North Dakota, US | |
386638 | 386638 | 2022-09-23 | US | North Dakota | McIntosh | 38051 | 770 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-09-24 04:21:40 | McIntosh, North Dakota, US | |
1889758 | 1889758 | 2022-09-14 | US | Colorado | Custer | 8027 | 770 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-15 04:21:02 | Custer, Colorado, US | |
372813 | 372813 | 2022-09-13 | US | Colorado | Custer | 8027 | 770 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-14 04:20:44 | Custer, Colorado, US | |
2395415 | 2395415 | 2022-09-12 | US | Colorado | Custer | 8027 | 770 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-13 04:20:57 | Custer, Colorado, US | |
3767346 | 3767346 | 2022-09-11 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-12 04:20:58 | Robertson, Kentucky, US | |
3825921 | 3825921 | 2022-09-10 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-11 04:20:50 | Robertson, Kentucky, US | |
964378 | 964378 | 2022-09-09 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-10 04:21:10 | Robertson, Kentucky, US | |
254780 | 254780 | 2022-09-08 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-09 04:21:11 | Robertson, Kentucky, US | |
3746578 | 3746578 | 2022-09-07 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-08 04:21:02 | Robertson, Kentucky, US | |
116218 | 116218 | 2022-09-06 | US | Kentucky | Robertson | 21201 | 770 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-09-07 04:20:59 | Robertson, Kentucky, US | |
2325124 | 2325124 | 2022-08-24 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-25 04:21:13 | Unassigned, Minnesota, US | |
1253158 | 1253158 | 2022-08-23 | US | North Dakota | Emmons | 38029 | 770 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-08-24 04:20:46 | Emmons, North Dakota, US | |
1252533 | 1252533 | 2022-08-23 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-24 04:20:46 | Unassigned, Minnesota, US | |
2855262 | 2855262 | 2022-08-22 | US | North Dakota | Emmons | 38029 | 770 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-08-23 04:20:56 | Emmons, North Dakota, US | |
2854637 | 2854637 | 2022-08-22 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-23 04:20:56 | Unassigned, Minnesota, US | |
2404609 | 2404609 | 2022-08-21 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-22 04:20:38 | Unassigned, Minnesota, US | |
3799687 | 3799687 | 2022-08-20 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-21 04:20:44 | Unassigned, Minnesota, US | |
2365273 | 2365273 | 2022-08-19 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-20 04:21:01 | Unassigned, Minnesota, US | |
1162944 | 1162944 | 2022-08-18 | US | Minnesota | Unassigned | 90027 | 770 | 349 | 0 | 48.77754106 | 0.0 | 2022-08-19 04:20:54 | Unassigned, Minnesota, US | |
1348096 | 1348096 | 2022-08-10 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-11 04:20:49 | Unassigned, Minnesota, US | |
1087851 | 1087851 | 2022-08-09 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-10 04:20:57 | Unassigned, Minnesota, US | |
3545266 | 3545266 | 2022-08-08 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-09 04:20:34 | Unassigned, Minnesota, US | |
1071669 | 1071669 | 2022-08-07 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-08 04:21:08 | Unassigned, Minnesota, US | |
1942257 | 1942257 | 2022-08-06 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-07 04:20:54 | Unassigned, Minnesota, US | |
882056 | 882056 | 2022-08-05 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-06 04:20:56 | Unassigned, Minnesota, US | |
2011747 | 2011747 | 2022-08-04 | US | Texas | Collingsworth | 48087 | 770 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-08-05 04:20:52 | Collingsworth, Texas, US | |
2010467 | 2010467 | 2022-08-04 | US | Minnesota | Unassigned | 90027 | 770 | 342 | 0 | 48.77754106 | 0.0 | 2022-08-05 04:20:52 | Unassigned, Minnesota, US | |
673445 | 673445 | 2022-07-21 | US | Texas | Kimble | 48267 | 770 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-07-22 04:21:15 | Kimble, Texas, US | |
1611408 | 1611408 | 2022-07-20 | US | Texas | Kimble | 48267 | 770 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-07-21 04:21:10 | Kimble, Texas, US | |
962041 | 962041 | 2022-07-19 | US | Texas | Kimble | 48267 | 770 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-07-20 04:20:59 | Kimble, Texas, US | |
3430927 | 3430927 | 2022-07-14 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-15 04:20:53 | Schuyler, Missouri, US | |
3111447 | 3111447 | 2022-07-13 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-14 04:20:57 | Schuyler, Missouri, US | |
631870 | 631870 | 2022-07-12 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-13 04:20:58 | Schuyler, Missouri, US | |
1213514 | 1213514 | 2022-07-11 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-12 04:20:51 | Schuyler, Missouri, US | |
2790996 | 2790996 | 2022-07-10 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-11 04:20:46 | Schuyler, Missouri, US | |
143949 | 143949 | 2022-07-09 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-10 04:20:54 | Schuyler, Missouri, US | |
1419049 | 1419049 | 2022-07-08 | US | Missouri | Schuyler | 29197 | 770 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-07-09 04:20:59 | Schuyler, Missouri, US | |
3271913 | 3271913 | 2022-06-19 | US | North Dakota | Eddy | 38027 | 770 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-20 04:21:01 | Eddy, North Dakota, US | |
3399825 | 3399825 | 2022-06-18 | US | North Dakota | Eddy | 38027 | 770 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-19 04:20:51 | Eddy, North Dakota, US | |
3398037 | 3398037 | 2022-06-18 | US | Colorado | Costilla | 8023 | 770 | 18 | 0 | 37.27732493 | -105.4276548 | 2022-06-19 04:20:51 | Costilla, Colorado, US | |
2313702 | 2313702 | 2022-06-17 | US | North Dakota | Eddy | 38027 | 770 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-18 04:21:10 | Eddy, North Dakota, US | |
561206 | 561206 | 2022-06-16 | US | North Dakota | Eddy | 38027 | 770 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-17 04:20:56 | Eddy, North Dakota, US | |
3160054 | 3160054 | 2022-06-09 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-10 04:20:55 | Nelson, North Dakota, US | |
1423521 | 1423521 | 2022-06-08 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-09 04:20:54 | Nelson, North Dakota, US | |
3728635 | 3728635 | 2022-06-07 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-08 04:20:55 | Nelson, North Dakota, US | |
3890037 | 3890037 | 2022-06-06 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-07 04:21:08 | Nelson, North Dakota, US | |
3509806 | 3509806 | 2022-06-05 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-06 04:20:57 | Nelson, North Dakota, US | |
3529883 | 3529883 | 2022-06-04 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-05 04:20:55 | Nelson, North Dakota, US | |
3135969 | 3135969 | 2022-06-03 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-04 04:20:58 | Nelson, North Dakota, US | |
3581044 | 3581044 | 2022-06-02 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-03 04:20:58 | Nelson, North Dakota, US | |
973337 | 973337 | 2022-06-01 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-02 05:20:39 | Nelson, North Dakota, US | |
231644 | 231644 | 2022-05-31 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-01 04:20:55 | Nelson, North Dakota, US | |
3188409 | 3188409 | 2022-05-30 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-05-31 04:20:51 | Nelson, North Dakota, US | |
3200558 | 3200558 | 2022-05-29 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-05-30 04:20:50 | Nelson, North Dakota, US | |
2727436 | 2727436 | 2022-05-28 | US | North Dakota | Nelson | 38063 | 770 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-05-29 04:20:53 | Nelson, North Dakota, US | |
3917770 | 3917770 | 2022-05-01 | US | Minnesota | Lake of the Woods | 27077 | 770 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-02 04:21:10 | Lake of the Woods, Minnesota, US | |
2842574 | 2842574 | 2022-04-30 | US | Minnesota | Lake of the Woods | 27077 | 770 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-01 04:20:57 | Lake of the Woods, Minnesota, US | |
1158887 | 1158887 | 2022-04-29 | US | Minnesota | Lake of the Woods | 27077 | 770 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-04-30 04:21:05 | Lake of the Woods, Minnesota, US | |
3854369 | 3854369 | 2022-04-27 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-04-28 04:20:47 | Ellis, Oklahoma, US | |
1328799 | 1328799 | 2022-04-26 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-27 04:20:52 | Ellis, Oklahoma, US | |
3724753 | 3724753 | 2022-04-25 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-26 04:20:51 | Ellis, Oklahoma, US | |
3724295 | 3724295 | 2022-04-25 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-26 04:20:51 | Kimball, Nebraska, US | |
2031321 | 2031321 | 2022-04-24 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-25 04:20:56 | Ellis, Oklahoma, US | |
2030863 | 2030863 | 2022-04-24 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-25 04:20:56 | Kimball, Nebraska, US | |
748896 | 748896 | 2022-04-23 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-24 04:20:56 | Ellis, Oklahoma, US | |
748438 | 748438 | 2022-04-23 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-24 04:20:56 | Kimball, Nebraska, US | |
3439381 | 3439381 | 2022-04-22 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-23 04:20:50 | Ellis, Oklahoma, US | |
3438923 | 3438923 | 2022-04-22 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-23 04:20:50 | Kimball, Nebraska, US | |
2894966 | 2894966 | 2022-04-21 | US | Oklahoma | Ellis | 40045 | 770 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-22 04:20:45 | Ellis, Oklahoma, US | |
2894508 | 2894508 | 2022-04-21 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-22 04:20:45 | Kimball, Nebraska, US | |
2309380 | 2309380 | 2022-04-20 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-21 04:20:46 | Kimball, Nebraska, US | |
2253519 | 2253519 | 2022-04-19 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-20 04:20:45 | Kimball, Nebraska, US | |
1848069 | 1848069 | 2022-04-18 | US | Nebraska | Kimball | 31105 | 770 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-19 04:21:00 | Kimball, Nebraska, 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]);