johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
392 rows where confirmed = 1546 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310298 | 310298 | 2022-12-13 | US | North Dakota | McHenry | 38049 | 1546 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-14 04:21:04 | McHenry, North Dakota, US | |
295348 | 295348 | 2022-11-15 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-16 04:21:09 | Emporia, Virginia, US | |
3600378 | 3600378 | 2022-11-14 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-15 04:21:16 | Emporia, Virginia, US | |
315236 | 315236 | 2022-11-13 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-14 04:21:09 | Emporia, Virginia, US | |
66397 | 66397 | 2022-11-12 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-13 04:21:14 | Emporia, Virginia, US | |
2930559 | 2930559 | 2022-11-11 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-12 04:20:41 | Emporia, Virginia, US | |
2509395 | 2509395 | 2022-11-10 | US | Virginia | Emporia | 51595 | 1546 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-11 04:21:22 | Emporia, Virginia, US | |
1052270 | 1052270 | 2022-11-06 | US | North Dakota | Sioux | 38085 | 1546 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-07 04:21:26 | Sioux, North Dakota, US | |
3251484 | 3251484 | 2022-10-11 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-12 04:22:51 | Phillips, Kansas, US | |
2968743 | 2968743 | 2022-10-10 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-11 04:23:05 | Phillips, Kansas, US | |
3098779 | 3098779 | 2022-10-09 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-10 04:22:32 | Phillips, Kansas, US | |
4004004 | 4004004 | 2022-10-08 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-09 04:21:16 | Phillips, Kansas, US | |
397601 | 397601 | 2022-10-07 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-08 04:22:56 | Phillips, Kansas, US | |
2530718 | 2530718 | 2022-10-06 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-07 04:23:08 | Phillips, Kansas, US | |
1812112 | 1812112 | 2022-10-05 | US | Kansas | Phillips | 20147 | 1546 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-06 04:21:22 | Phillips, Kansas, US | |
1563274 | 1563274 | 2022-09-28 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-29 04:22:34 | Mills, Texas, US | |
3997817 | 3997817 | 2022-09-27 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-28 04:23:01 | Mills, Texas, US | |
2772145 | 2772145 | 2022-09-26 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-27 04:23:01 | Mills, Texas, US | |
1979798 | 1979798 | 2022-09-25 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-26 04:20:52 | Mills, Texas, US | |
2652965 | 2652965 | 2022-09-24 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-25 04:23:31 | Mills, Texas, US | |
387405 | 387405 | 2022-09-23 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-24 04:21:40 | Mills, Texas, US | |
1627471 | 1627471 | 2022-09-22 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-23 04:23:13 | Mills, Texas, US | |
1373675 | 1373675 | 2022-09-21 | US | Texas | Mills | 48333 | 1546 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-22 04:22:56 | Mills, Texas, US | |
3776761 | 3776761 | 2022-08-30 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-31 04:20:57 | Brule, South Dakota, US | |
1683357 | 1683357 | 2022-08-29 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-30 04:21:03 | Brule, South Dakota, US | |
1879841 | 1879841 | 2022-08-28 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-29 04:21:06 | Brule, South Dakota, US | |
2098968 | 2098968 | 2022-08-27 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-28 04:21:02 | Brule, South Dakota, US | |
1534783 | 1534783 | 2022-08-26 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-27 04:20:57 | Brule, South Dakota, US | |
2831670 | 2831670 | 2022-08-25 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-26 04:21:02 | Brule, South Dakota, US | |
2326203 | 2326203 | 2022-08-24 | US | South Dakota | Brule | 46015 | 1546 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-25 04:21:13 | Brule, South Dakota, US | |
3875086 | 3875086 | 2022-07-31 | US | West Virginia | Wirt | 54105 | 1546 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-08-01 04:21:03 | Wirt, West Virginia, US | |
3874749 | 3874749 | 2022-07-31 | US | Texas | Newton | 48351 | 1546 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-01 04:21:03 | Newton, Texas, US | |
677840 | 677840 | 2022-07-30 | US | West Virginia | Wirt | 54105 | 1546 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-07-31 04:21:02 | Wirt, West Virginia, US | |
677503 | 677503 | 2022-07-30 | US | Texas | Newton | 48351 | 1546 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-07-31 04:21:02 | Newton, Texas, US | |
1787039 | 1787039 | 2022-07-29 | US | West Virginia | Wirt | 54105 | 1546 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-07-30 04:20:42 | Wirt, West Virginia, US | |
1786702 | 1786702 | 2022-07-29 | US | Texas | Newton | 48351 | 1546 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-07-30 04:20:42 | Newton, Texas, US | |
1069065 | 1069065 | 2022-07-28 | US | Texas | Newton | 48351 | 1546 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-07-29 04:20:45 | Newton, Texas, US | |
633349 | 633349 | 2022-07-12 | US | Washington | Ferry | 53019 | 1546 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-07-13 04:20:58 | Ferry, Washington, US | |
1214993 | 1214993 | 2022-07-11 | US | Washington | Ferry | 53019 | 1546 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-07-12 04:20:51 | Ferry, Washington, US | |
3967873 | 3967873 | 2022-07-05 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-06 04:20:58 | Morris, Kansas, US | |
3079384 | 3079384 | 2022-07-04 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-05 04:20:45 | Morris, Kansas, US | |
1768666 | 1768666 | 2022-07-03 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-04 04:20:54 | Morris, Kansas, US | |
3366652 | 3366652 | 2022-07-02 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-03 04:20:59 | Morris, Kansas, US | |
594981 | 594981 | 2022-07-01 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-02 04:21:16 | Morris, Kansas, US | |
3941382 | 3941382 | 2022-06-30 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-01 04:21:10 | Morris, Kansas, US | |
2491340 | 2491340 | 2022-06-29 | US | Kansas | Morris | 20127 | 1546 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-30 04:21:01 | Morris, Kansas, US | |
2150064 | 2150064 | 2022-06-27 | US | North Dakota | Ransom | 38073 | 1546 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-06-28 04:20:58 | Ransom, North Dakota, US | |
2148234 | 2148234 | 2022-06-27 | US | California | Trinity | 6105 | 1546 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-28 04:20:58 | Trinity, California, US | |
1651509 | 1651509 | 2022-06-23 | US | Texas | Jack | 48237 | 1546 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-24 04:20:58 | Jack, Texas, US | |
3144626 | 3144626 | 2022-06-11 | US | Texas | Carson | 48065 | 1546 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-06-12 04:20:53 | Carson, Texas, US | |
1110543 | 1110543 | 2022-05-21 | US | Illinois | Calhoun | 17013 | 1546 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-22 04:20:52 | Calhoun, Illinois, US | |
1170167 | 1170167 | 2022-05-20 | US | Illinois | Calhoun | 17013 | 1546 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-21 04:20:58 | Calhoun, Illinois, US | |
3899422 | 3899422 | 2022-05-19 | US | Washington | Skamania | 53059 | 1546 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-20 04:20:57 | Skamania, Washington, US | |
1188206 | 1188206 | 2022-05-18 | US | Washington | Skamania | 53059 | 1546 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-19 04:20:54 | Skamania, Washington, US | |
1159244 | 1159244 | 2022-04-29 | US | Nebraska | Keith | 31101 | 1546 | 19 | 0 | 41.19930341 | -101.6620164 | 2022-04-30 04:21:05 | Keith, Nebraska, US | |
1698426 | 1698426 | 2022-04-28 | US | Nebraska | Keith | 31101 | 1546 | 19 | 0 | 41.19930341 | -101.6620164 | 2022-04-29 04:20:59 | Keith, Nebraska, US | |
3853909 | 3853909 | 2022-04-27 | US | Nebraska | Keith | 31101 | 1546 | 19 | 0 | 41.19930341 | -101.6620164 | 2022-04-28 04:20:47 | Keith, Nebraska, US | |
1328339 | 1328339 | 2022-04-26 | US | Nebraska | Keith | 31101 | 1546 | 19 | 0 | 41.19930341 | -101.66201640000001 | 2022-04-27 04:20:52 | Keith, Nebraska, US | |
3209430 | 3209430 | 2022-04-11 | US | Texas | Lynn | 48305 | 1546 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-04-12 04:20:49 | Lynn, Texas, US | |
1579316 | 1579316 | 2022-04-10 | US | Texas | Lynn | 48305 | 1546 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-04-11 04:21:02 | Lynn, Texas, US | |
1655558 | 1655558 | 2022-04-09 | US | Texas | Lynn | 48305 | 1546 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-04-10 04:20:52 | Lynn, Texas, US | |
694200 | 694200 | 2022-03-17 | China | Tianjin | 1546 | 3 | 0 | 39.3054 | 117.323 | 2022-03-18 04:20:55 | Tianjin, China | |||
1514028 | 1514028 | 2022-02-24 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-25 04:21:11 | Grant, Oregon, US | |
1060469 | 1060469 | 2022-02-23 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-24 04:21:14 | Grant, Oregon, US | |
2449392 | 2449392 | 2022-02-22 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-23 04:21:09 | Grant, Oregon, US | |
3720805 | 3720805 | 2022-02-21 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-22 04:21:01 | Grant, Oregon, US | |
3914639 | 3914639 | 2022-02-20 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-21 04:21:05 | Grant, Oregon, US | |
3878197 | 3878197 | 2022-02-19 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-20 04:21:00 | Grant, Oregon, US | |
3858453 | 3858453 | 2022-02-18 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-19 04:21:11 | Grant, Oregon, US | |
1300672 | 1300672 | 2022-02-17 | US | Oregon | Grant | 41023 | 1546 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-02-18 04:21:04 | Grant, Oregon, US | |
186887 | 186887 | 2022-02-13 | US | Georgia | Hancock | 13141 | 1546 | 86 | 0 | 33.2721566 | -82.99766919 | 2022-02-14 04:20:51 | Hancock, Georgia, US | |
316733 | 316733 | 2022-02-12 | US | Georgia | Hancock | 13141 | 1546 | 86 | 0 | 33.2721566 | -82.99766919 | 2022-02-13 04:21:00 | Hancock, Georgia, US | |
234059 | 234059 | 2022-02-11 | US | Georgia | Hancock | 13141 | 1546 | 86 | 0 | 33.2721566 | -82.99766919 | 2022-02-12 04:21:06 | Hancock, Georgia, US | |
3076435 | 3076435 | 2022-02-09 | US | North Dakota | Bottineau | 38009 | 1546 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-10 04:21:14 | Bottineau, North Dakota, US | |
1364282 | 1364282 | 2022-02-08 | US | Missouri | Maries | 29125 | 1546 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-09 04:21:04 | Maries, Missouri, US | |
1364196 | 1364196 | 2022-02-08 | US | Mississippi | Quitman | 28119 | 1546 | 30 | 0 | 34.25157572 | -90.28908 | 2022-02-09 04:21:04 | Quitman, Mississippi, US | |
1230820 | 1230820 | 2022-01-24 | US | Texas | Refugio | 48391 | 1546 | 31 | 0 | 28.323897600000002 | -97.15766311 | 2022-01-25 04:21:05 | Refugio, Texas, US | |
1230722 | 1230722 | 2022-01-24 | US | Texas | Hansford | 48195 | 1546 | 27 | 0 | 36.27743284 | -101.3545796 | 2022-01-25 04:21:05 | Hansford, Texas, US | |
1229728 | 1229728 | 2022-01-24 | US | Nebraska | Richardson | 31147 | 1546 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-01-25 04:21:05 | Richardson, Nebraska, US | |
1143916 | 1143916 | 2022-01-23 | US | Tennessee | Van Buren | 47175 | 1546 | 44 | 0 | 35.69864497 | -85.45221699 | 2022-01-24 04:21:12 | Van Buren, Tennessee, US | |
1475623 | 1475623 | 2022-01-17 | US | West Virginia | Pocahontas | 54075 | 1546 | 24 | 0 | 38.32758728 | -80.00993811 | 2022-01-18 04:21:04 | Pocahontas, West Virginia, US | |
1286669 | 1286669 | 2022-01-04 | US | Colorado | Yuma | 8125 | 1546 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-01-05 04:21:59 | Yuma, Colorado, US | |
2779971 | 2779971 | 2021-12-31 | US | Tennessee | Moore | 47127 | 1546 | 32 | 0 | 35.27724699 | -86.36230578 | 2022-01-01 04:22:14 | Moore, Tennessee, US | |
1671936 | 1671936 | 2021-12-29 | US | West Virginia | Doddridge | 54017 | 1546 | 13 | 0 | 39.27057157 | -80.70671527 | 2021-12-30 04:21:25 | Doddridge, West Virginia, US | |
1669330 | 1669330 | 2021-12-29 | US | Georgia | Seminole | 13253 | 1546 | 26 | 0 | 30.93464824 | -84.86823924 | 2021-12-30 04:21:25 | Seminole, Georgia, US | |
1433416 | 1433416 | 2021-12-28 | US | Georgia | Montgomery | 13209 | 1546 | 45 | 0 | 32.17201038 | -82.53527476 | 2021-12-29 03:21:43 | Montgomery, Georgia, US | |
2112563 | 2112563 | 2021-12-26 | US | Georgia | Pulaski | 13235 | 1546 | 67 | 0 | 32.23334561 | -83.47549959999998 | 2021-12-27 04:21:58 | Pulaski, Georgia, US | |
3605935 | 3605935 | 2021-12-25 | US | Georgia | Pulaski | 13235 | 1546 | 67 | 0 | 32.23334561 | -83.47549959999998 | 2021-12-26 04:21:50 | Pulaski, Georgia, US | |
2964253 | 2964253 | 2021-12-24 | US | Georgia | Pulaski | 13235 | 1546 | 67 | 0 | 32.23334561 | -83.47549959999998 | 2021-12-25 04:21:37 | Pulaski, Georgia, US | |
3817285 | 3817285 | 2021-12-23 | US | Georgia | Pulaski | 13235 | 1546 | 67 | 0 | 32.23334561 | -83.47549959999998 | 2021-12-24 04:21:34 | Pulaski, Georgia, US | |
799293 | 799293 | 2021-12-22 | US | Georgia | Pulaski | 13235 | 1546 | 67 | 0 | 32.23334561 | -83.47549959999998 | 2021-12-23 04:21:21 | Pulaski, Georgia, US | |
1258253 | 1258253 | 2021-12-20 | US | West Virginia | Gilmer | 54021 | 1546 | 14 | 0 | 38.9251277 | -80.85952723 | 2021-12-21 03:21:27 | Gilmer, West Virginia, US | |
1256858 | 1256858 | 2021-12-20 | US | Nebraska | Holt | 31089 | 1546 | 16 | 0 | 42.45522056 | -98.78402558 | 2021-12-21 03:21:27 | Holt, Nebraska, US | |
1262012 | 1262012 | 2021-12-18 | US | Texas | Somervell | 48425 | 1546 | 25 | 0 | 32.22236802 | -97.77403489 | 2021-12-19 04:21:11 | Somervell, Texas, US | |
3497331 | 3497331 | 2021-12-15 | US | Indiana | Switzerland | 18155 | 1546 | 14 | 0 | 38.82767338 | -85.03022429 | 2021-12-16 04:22:11 | Switzerland, Indiana, US | |
714980 | 714980 | 2021-11-12 | US | Arkansas | Perry | 5105 | 1546 | 22 | 0 | 34.945915299999996 | -92.94372564 | 2021-11-13 04:21:38 | Perry, Arkansas, US | |
30143 | 30143 | 2021-11-11 | US | Minnesota | Jackson | 27063 | 1546 | 16 | 0 | 43.67423373 | -95.15398258 | 2021-11-12 04:22:01 | Jackson, Minnesota, US | |
2004207 | 2004207 | 2021-11-07 | US | Wisconsin | Forest | 55041 | 1546 | 32 | 0 | 45.66678019 | -88.77084892 | 2021-11-08 04:21:43 | Forest, Wisconsin, US | |
499198 | 499198 | 2021-11-06 | US | Wisconsin | Forest | 55041 | 1546 | 32 | 0 | 45.66678019 | -88.77084892 | 2021-11-07 04:21:53 | Forest, Wisconsin, US | |
3125053 | 3125053 | 2021-11-05 | US | Wisconsin | Forest | 55041 | 1546 | 32 | 0 | 45.66678019 | -88.77084892 | 2021-11-06 04:21:51 | Forest, Wisconsin, 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]);