johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
634 rows where confirmed = 774 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330811 | 330811 | 2022-12-27 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-28 04:21:04 | Potter, South Dakota, US | |
220884 | 220884 | 2022-12-26 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-27 04:21:07 | Potter, South Dakota, US | |
218425 | 218425 | 2022-12-26 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-27 04:21:07 | Wrangell, Alaska, US | |
3225341 | 3225341 | 2022-12-25 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-26 04:21:06 | Potter, South Dakota, US | |
3222882 | 3222882 | 2022-12-25 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-26 04:21:06 | Wrangell, Alaska, US | |
1021255 | 1021255 | 2022-12-24 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-25 04:21:04 | Potter, South Dakota, US | |
1018796 | 1018796 | 2022-12-24 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-25 04:21:04 | Wrangell, Alaska, US | |
693278 | 693278 | 2022-12-23 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-24 04:21:02 | Potter, South Dakota, US | |
690819 | 690819 | 2022-12-23 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-24 04:21:02 | Wrangell, Alaska, US | |
2182488 | 2182488 | 2022-12-22 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-23 04:21:04 | Potter, South Dakota, US | |
2180029 | 2180029 | 2022-12-22 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-23 04:21:04 | Wrangell, Alaska, US | |
454292 | 454292 | 2022-12-21 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-22 04:20:56 | Potter, South Dakota, US | |
451833 | 451833 | 2022-12-21 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-22 04:20:56 | Wrangell, Alaska, US | |
2954291 | 2954291 | 2022-12-20 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-21 04:21:03 | Potter, South Dakota, US | |
2951832 | 2951832 | 2022-12-20 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-21 04:21:03 | Wrangell, Alaska, US | |
3176693 | 3176693 | 2022-12-19 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-20 04:21:04 | Potter, South Dakota, US | |
1631210 | 1631210 | 2022-12-18 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-19 04:21:03 | Potter, South Dakota, US | |
506589 | 506589 | 2022-12-17 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-18 04:21:03 | Potter, South Dakota, US | |
3327161 | 3327161 | 2022-12-16 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-17 04:21:04 | Potter, South Dakota, US | |
545673 | 545673 | 2022-12-15 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-16 04:21:01 | Potter, South Dakota, US | |
351201 | 351201 | 2022-12-14 | US | South Dakota | Potter | 46107 | 774 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-15 04:20:58 | Potter, South Dakota, US | |
309155 | 309155 | 2022-12-13 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-14 04:21:04 | Chase, Kansas, US | |
1150216 | 1150216 | 2022-12-12 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-13 04:21:01 | Chase, Kansas, US | |
870070 | 870070 | 2022-12-11 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-12 04:21:01 | Chase, Kansas, US | |
258600 | 258600 | 2022-12-10 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-11 04:20:50 | Chase, Kansas, US | |
3937314 | 3937314 | 2022-12-09 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-10 04:21:02 | Chase, Kansas, US | |
3378646 | 3378646 | 2022-12-08 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-09 04:21:05 | Chase, Kansas, US | |
1985917 | 1985917 | 2022-12-07 | US | Kansas | Chase | 20017 | 774 | 9 | 0 | 38.30292938 | -96.59563862 | 2022-12-08 04:21:07 | Chase, Kansas, US | |
3717073 | 3717073 | 2022-12-06 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-07 04:20:58 | Perkins, South Dakota, US | |
2417778 | 2417778 | 2022-12-05 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-06 04:21:03 | Perkins, South Dakota, US | |
721386 | 721386 | 2022-12-04 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-05 04:20:58 | Perkins, South Dakota, US | |
2819675 | 2819675 | 2022-12-03 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-04 04:20:56 | Perkins, South Dakota, US | |
836531 | 836531 | 2022-12-02 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-03 04:21:02 | Perkins, South Dakota, US | |
2139061 | 2139061 | 2022-12-01 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-02 04:21:07 | Perkins, South Dakota, US | |
1967477 | 1967477 | 2022-11-30 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-01 04:21:03 | Perkins, South Dakota, US | |
1623177 | 1623177 | 2022-11-22 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-23 04:21:06 | Perkins, South Dakota, US | |
3463065 | 3463065 | 2022-11-21 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-22 04:20:47 | Perkins, South Dakota, US | |
1643250 | 1643250 | 2022-11-20 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-21 04:21:05 | Perkins, South Dakota, US | |
2066807 | 2066807 | 2022-11-19 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-20 04:21:08 | Perkins, South Dakota, US | |
1758201 | 1758201 | 2022-11-18 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-19 04:21:14 | Perkins, South Dakota, US | |
3029194 | 3029194 | 2022-11-17 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-18 04:21:15 | Perkins, South Dakota, US | |
2488905 | 2488905 | 2022-11-16 | US | South Dakota | Perkins | 46105 | 774 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-11-17 04:21:11 | Perkins, South Dakota, US | |
294884 | 294884 | 2022-11-15 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-16 04:21:09 | Douglas, South Dakota, US | |
3599914 | 3599914 | 2022-11-14 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-15 04:21:16 | Douglas, South Dakota, US | |
314772 | 314772 | 2022-11-13 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-14 04:21:09 | Douglas, South Dakota, US | |
65933 | 65933 | 2022-11-12 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-13 04:21:14 | Douglas, South Dakota, US | |
2930095 | 2930095 | 2022-11-11 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-12 04:20:41 | Douglas, South Dakota, US | |
2508931 | 2508931 | 2022-11-10 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-11 04:21:22 | Douglas, South Dakota, US | |
2433806 | 2433806 | 2022-11-09 | US | South Dakota | Douglas | 46043 | 774 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-10 04:21:16 | Douglas, South Dakota, US | |
2432650 | 2432650 | 2022-11-09 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-10 04:21:16 | Cook, Minnesota, US | |
481306 | 481306 | 2022-11-08 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-09 04:21:22 | Cook, Minnesota, US | |
2440456 | 2440456 | 2022-11-07 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-08 04:21:21 | Cook, Minnesota, US | |
1051554 | 1051554 | 2022-11-06 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-07 04:21:26 | Cook, Minnesota, US | |
619578 | 619578 | 2022-11-05 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-06 04:21:24 | Cook, Minnesota, US | |
1024082 | 1024082 | 2022-11-04 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-05 04:21:52 | Cook, Minnesota, US | |
433073 | 433073 | 2022-11-03 | US | Minnesota | Cook | 27031 | 774 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-11-04 04:22:11 | Cook, Minnesota, US | |
2273889 | 2273889 | 2022-10-20 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-21 04:22:23 | Scotland, Missouri, US | |
200224 | 200224 | 2022-10-19 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-20 04:22:59 | Scotland, Missouri, US | |
2758885 | 2758885 | 2022-10-18 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-19 04:22:26 | Scotland, Missouri, US | |
2026719 | 2026719 | 2022-10-17 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-18 04:22:42 | Scotland, Missouri, US | |
2161497 | 2161497 | 2022-10-16 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-17 04:20:31 | Scotland, Missouri, US | |
517694 | 517694 | 2022-10-15 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-16 04:22:39 | Scotland, Missouri, US | |
2034751 | 2034751 | 2022-10-14 | US | Missouri | Scotland | 29199 | 774 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-10-15 04:22:00 | Scotland, Missouri, US | |
2531796 | 2531796 | 2022-10-06 | US | North Dakota | McIntosh | 38051 | 774 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-07 04:23:08 | McIntosh, North Dakota, US | |
1812554 | 1812554 | 2022-10-05 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-06 04:21:22 | Unassigned, Minnesota, US | |
132528 | 132528 | 2022-10-04 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Minnesota, US | |
2687475 | 2687475 | 2022-10-03 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-04 04:22:55 | Unassigned, Minnesota, US | |
2261542 | 2261542 | 2022-10-02 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-03 04:23:11 | Unassigned, Minnesota, US | |
2997068 | 2997068 | 2022-10-01 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-02 04:21:23 | Unassigned, Minnesota, US | |
855394 | 855394 | 2022-09-30 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-10-01 04:23:01 | Unassigned, Minnesota, US | |
2377320 | 2377320 | 2022-09-29 | US | Minnesota | Unassigned | 90027 | 774 | 366 | 0 | 48.77754106 | 0.0 | 2022-09-30 04:23:09 | Unassigned, Minnesota, US | |
3747512 | 3747512 | 2022-09-07 | US | North Dakota | Emmons | 38029 | 774 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-09-08 04:21:02 | Emmons, North Dakota, US | |
117152 | 117152 | 2022-09-06 | US | North Dakota | Emmons | 38029 | 774 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-09-07 04:20:59 | Emmons, North Dakota, US | |
899948 | 899948 | 2022-07-22 | China | Chongqing | 774 | 6 | 0 | 30.0572 | 107.874 | 2022-07-23 04:20:53 | Chongqing, China | |||
2981536 | 2981536 | 2022-06-13 | US | New York | Unassigned | 90036 | 774 | 1 | 0 | 44.74530905 | 0.0 | 2022-06-14 04:20:52 | Unassigned, New York, US | |
2237801 | 2237801 | 2022-06-12 | US | North Dakota | Nelson | 38063 | 774 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-13 04:21:14 | Nelson, North Dakota, US | |
3143999 | 3143999 | 2022-06-11 | US | North Dakota | Nelson | 38063 | 774 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-12 04:20:53 | Nelson, North Dakota, US | |
1187298 | 1187298 | 2022-05-18 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-19 04:20:54 | Ellis, Oklahoma, US | |
3585195 | 3585195 | 2022-05-17 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-18 04:20:50 | Ellis, Oklahoma, US | |
1506152 | 1506152 | 2022-05-16 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-17 04:20:59 | Ellis, Oklahoma, US | |
1505805 | 1505805 | 2022-05-16 | US | New Mexico | Mora | 35033 | 774 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-17 04:20:59 | Mora, New Mexico, US | |
2086511 | 2086511 | 2022-05-15 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-16 04:20:47 | Ellis, Oklahoma, US | |
3357221 | 3357221 | 2022-05-14 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-15 04:20:53 | Ellis, Oklahoma, US | |
660866 | 660866 | 2022-05-13 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-14 04:20:48 | Ellis, Oklahoma, US | |
2535949 | 2535949 | 2022-05-12 | US | Oklahoma | Ellis | 40045 | 774 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-13 04:20:51 | Ellis, Oklahoma, US | |
2599783 | 2599783 | 2022-05-05 | US | Minnesota | Lake of the Woods | 27077 | 774 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-06 04:21:00 | Lake of the Woods, Minnesota, US | |
3267232 | 3267232 | 2022-05-04 | US | Minnesota | Lake of the Woods | 27077 | 774 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-05 04:20:55 | Lake of the Woods, Minnesota, US | |
1159246 | 1159246 | 2022-04-29 | US | Nebraska | Kimball | 31105 | 774 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-30 04:21:05 | Kimball, Nebraska, US | |
1698428 | 1698428 | 2022-04-28 | US | Nebraska | Kimball | 31105 | 774 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-29 04:20:59 | Kimball, Nebraska, US | |
3853911 | 3853911 | 2022-04-27 | US | Nebraska | Kimball | 31105 | 774 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-28 04:20:47 | Kimball, Nebraska, US | |
1328341 | 1328341 | 2022-04-26 | US | Nebraska | Kimball | 31105 | 774 | 4 | 0 | 41.19774275 | -103.7148131 | 2022-04-27 04:20:52 | Kimball, Nebraska, US | |
2253458 | 2253458 | 2022-04-19 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-20 04:20:45 | Sweet Grass, Montana, US | |
1848008 | 1848008 | 2022-04-18 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-19 04:21:00 | Sweet Grass, Montana, US | |
3418952 | 3418952 | 2022-04-17 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-18 04:21:12 | Sweet Grass, Montana, US | |
305901 | 305901 | 2022-04-16 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-17 04:20:59 | Sweet Grass, Montana, US | |
2671846 | 2671846 | 2022-04-15 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-16 04:20:48 | Sweet Grass, Montana, US | |
1225631 | 1225631 | 2022-04-14 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-15 04:20:57 | Sweet Grass, Montana, US | |
2444789 | 2444789 | 2022-04-13 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-13 23:21:06 | Sweet Grass, Montana, US | |
1950546 | 1950546 | 2022-04-12 | US | Montana | Sweet Grass | 30097 | 774 | 12 | 0 | 45.81367654 | -109.9425686 | 2022-04-13 04:21:03 | Sweet Grass, Montana, US | |
3208299 | 3208299 | 2022-04-11 | US | Montana | Sweet Grass | 30097 | 774 | 11 | 0 | 45.81367654 | -109.9425686 | 2022-04-12 04:20:49 | Sweet Grass, Montana, 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]);