johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
534 rows where confirmed = 915 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329200 | 329200 | 2022-12-27 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-28 04:21:04 | Gove, Kansas, US | |
219273 | 219273 | 2022-12-26 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-27 04:21:07 | Gove, Kansas, US | |
3223730 | 3223730 | 2022-12-25 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-26 04:21:06 | Gove, Kansas, US | |
1019644 | 1019644 | 2022-12-24 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-25 04:21:04 | Gove, Kansas, US | |
691667 | 691667 | 2022-12-23 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-24 04:21:02 | Gove, Kansas, US | |
2180877 | 2180877 | 2022-12-22 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-23 04:21:04 | Gove, Kansas, US | |
452681 | 452681 | 2022-12-21 | US | Kansas | Gove | 20063 | 915 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-22 04:20:56 | Gove, Kansas, US | |
3715333 | 3715333 | 2022-12-06 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-07 04:20:58 | Adams, Iowa, US | |
2416038 | 2416038 | 2022-12-05 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-06 04:21:03 | Adams, Iowa, US | |
719646 | 719646 | 2022-12-04 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-05 04:20:58 | Adams, Iowa, US | |
2817935 | 2817935 | 2022-12-03 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-04 04:20:56 | Adams, Iowa, US | |
834791 | 834791 | 2022-12-02 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-03 04:21:02 | Adams, Iowa, US | |
2137321 | 2137321 | 2022-12-01 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-02 04:21:07 | Adams, Iowa, US | |
1965737 | 1965737 | 2022-11-30 | US | Iowa | Adams | 19003 | 915 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-01 04:21:03 | Adams, Iowa, US | |
1621229 | 1621229 | 2022-11-22 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-23 04:21:06 | Oneida, Idaho, US | |
3461117 | 3461117 | 2022-11-21 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-22 04:20:47 | Oneida, Idaho, US | |
1641302 | 1641302 | 2022-11-20 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-21 04:21:05 | Oneida, Idaho, US | |
2064859 | 2064859 | 2022-11-19 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-20 04:21:08 | Oneida, Idaho, US | |
1756253 | 1756253 | 2022-11-18 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-19 04:21:14 | Oneida, Idaho, US | |
3028513 | 3028513 | 2022-11-17 | US | New Mexico | Union | 35059 | 915 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-18 04:21:15 | Union, New Mexico, US | |
3027246 | 3027246 | 2022-11-17 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-18 04:21:15 | Oneida, Idaho, US | |
2488224 | 2488224 | 2022-11-16 | US | New Mexico | Union | 35059 | 915 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-17 04:21:11 | Union, New Mexico, US | |
2486957 | 2486957 | 2022-11-16 | US | Idaho | Oneida | 16071 | 915 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-11-17 04:21:11 | Oneida, Idaho, US | |
294235 | 294235 | 2022-11-15 | US | New Mexico | Union | 35059 | 915 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-16 04:21:09 | Union, New Mexico, US | |
3599265 | 3599265 | 2022-11-14 | US | New Mexico | Union | 35059 | 915 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-15 04:21:16 | Union, New Mexico, US | |
2377951 | 2377951 | 2022-09-29 | US | North Dakota | Hettinger | 38041 | 915 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-09-30 04:23:09 | Hettinger, North Dakota, US | |
374595 | 374595 | 2022-09-13 | US | North Dakota | Cavalier | 38019 | 915 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-14 04:20:44 | Cavalier, North Dakota, US | |
3952267 | 3952267 | 2022-08-17 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-18 04:21:11 | Traverse, Minnesota, US | |
993200 | 993200 | 2022-08-16 | US | New Mexico | Mora | 35033 | 915 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-17 04:20:59 | Mora, New Mexico, US | |
992769 | 992769 | 2022-08-16 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-17 04:20:59 | Traverse, Minnesota, US | |
2495808 | 2495808 | 2022-08-15 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-16 04:20:58 | Traverse, Minnesota, US | |
3649358 | 3649358 | 2022-08-14 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-15 04:20:59 | Traverse, Minnesota, US | |
1970364 | 1970364 | 2022-08-13 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-14 04:20:55 | Traverse, Minnesota, US | |
2890173 | 2890173 | 2022-08-12 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-13 04:20:52 | Traverse, Minnesota, US | |
3909778 | 3909778 | 2022-08-11 | US | Minnesota | Traverse | 27155 | 915 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-12 04:20:54 | Traverse, Minnesota, US | |
1349525 | 1349525 | 2022-08-10 | US | Texas | Real | 48385 | 915 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-08-11 04:20:49 | Real, Texas, US | |
3874765 | 3874765 | 2022-07-31 | US | Texas | Reagan | 48383 | 915 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-01 04:21:03 | Reagan, Texas, US | |
677519 | 677519 | 2022-07-30 | US | Texas | Reagan | 48383 | 915 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-31 04:21:02 | Reagan, Texas, US | |
1786718 | 1786718 | 2022-07-29 | US | Texas | Reagan | 48383 | 915 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-30 04:20:42 | Reagan, Texas, US | |
1420203 | 1420203 | 2022-07-08 | US | Texas | Haskell | 48207 | 915 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-07-09 04:20:59 | Haskell, Texas, US | |
2240048 | 2240048 | 2022-06-28 | US | Colorado | Phillips | 8095 | 915 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-06-29 04:20:59 | Phillips, Colorado, US | |
2725664 | 2725664 | 2022-05-28 | US | Colorado | Ouray | 8091 | 915 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-05-29 04:20:53 | Ouray, Colorado, US | |
1314845 | 1314845 | 2022-05-27 | US | Colorado | Ouray | 8091 | 915 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-05-28 04:21:07 | Ouray, Colorado, US | |
3002970 | 3002970 | 2022-05-24 | United Kingdom | Montserrat | 915 | 4 | 0 | 16.742498 | -62.187366 | 2022-05-25 04:20:56 | Montserrat, United Kingdom | |||
3596691 | 3596691 | 2022-05-23 | United Kingdom | Montserrat | 915 | 4 | 0 | 16.742498 | -62.187366 | 2022-05-24 04:20:57 | Montserrat, United Kingdom | |||
1113239 | 1113239 | 2022-05-21 | United Kingdom | Montserrat | 915 | 4 | 0 | 16.742498 | -62.187366 | 2022-05-22 04:20:52 | Montserrat, United Kingdom | |||
1110252 | 1110252 | 2022-05-21 | US | Delaware | Unassigned | 90010 | 915 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-22 04:20:52 | Unassigned, Delaware, US | |
1169876 | 1169876 | 2022-05-20 | US | Delaware | Unassigned | 90010 | 915 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-21 04:20:58 | Unassigned, Delaware, US | |
3896639 | 3896639 | 2022-05-19 | US | Delaware | Unassigned | 90010 | 915 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-20 04:20:57 | Unassigned, Delaware, US | |
2534317 | 2534317 | 2022-05-12 | US | Idaho | Bear Lake | 16007 | 915 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-13 04:20:51 | Bear Lake, Idaho, US | |
3445763 | 3445763 | 2022-05-11 | US | Idaho | Bear Lake | 16007 | 915 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-12 04:20:54 | Bear Lake, Idaho, US | |
3918052 | 3918052 | 2022-05-01 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-02 04:21:10 | Musselshell, Montana, US | |
2842856 | 2842856 | 2022-04-30 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-01 04:20:57 | Musselshell, Montana, US | |
1159169 | 1159169 | 2022-04-29 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-04-30 04:21:05 | Musselshell, Montana, US | |
1698351 | 1698351 | 2022-04-28 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-04-29 04:20:59 | Musselshell, Montana, US | |
3853834 | 3853834 | 2022-04-27 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-04-28 04:20:47 | Musselshell, Montana, US | |
1328264 | 1328264 | 2022-04-26 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-04-27 04:20:52 | Musselshell, Montana, US | |
3724218 | 3724218 | 2022-04-25 | US | Montana | Musselshell | 30065 | 915 | 31 | 0 | 46.49684637 | -108.39498 | 2022-04-26 04:20:51 | Musselshell, Montana, US | |
2030786 | 2030786 | 2022-04-24 | US | Montana | Musselshell | 30065 | 915 | 26 | 0 | 46.49684637 | -108.39498 | 2022-04-25 04:20:56 | Musselshell, Montana, US | |
748361 | 748361 | 2022-04-23 | US | Montana | Musselshell | 30065 | 915 | 26 | 0 | 46.49684637 | -108.39498 | 2022-04-24 04:20:56 | Musselshell, Montana, US | |
3438846 | 3438846 | 2022-04-22 | US | Montana | Musselshell | 30065 | 915 | 26 | 0 | 46.49684637 | -108.39498 | 2022-04-23 04:20:50 | Musselshell, Montana, US | |
264932 | 264932 | 2022-03-15 | US | Virginia | Rappahannock | 51157 | 915 | 9 | 0 | 38.68295619 | -78.15826963 | 2022-03-16 04:20:50 | Rappahannock, Virginia, US | |
2450172 | 2450172 | 2022-02-22 | US | Virginia | Rappahannock | 51157 | 915 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-02-23 04:21:09 | Rappahannock, Virginia, US | |
2447193 | 2447193 | 2022-02-22 | US | Alaska | Copper River | 2066 | 915 | 8 | 0 | 60.3886 | -162.8905196 | 2022-02-23 04:21:09 | Copper River, Alaska, US | |
3718606 | 3718606 | 2022-02-21 | US | Alaska | Copper River | 2066 | 915 | 8 | 0 | 60.3886 | -162.8905196 | 2022-02-22 04:21:01 | Copper River, Alaska, US | |
3912440 | 3912440 | 2022-02-20 | US | Alaska | Copper River | 2066 | 915 | 8 | 0 | 60.3886 | -162.8905196 | 2022-02-21 04:21:05 | Copper River, Alaska, US | |
3875998 | 3875998 | 2022-02-19 | US | Alaska | Copper River | 2066 | 915 | 8 | 0 | 60.3886 | -162.8905196 | 2022-02-20 04:21:00 | Copper River, Alaska, US | |
3856254 | 3856254 | 2022-02-18 | US | Alaska | Copper River | 2066 | 915 | 8 | 0 | 60.3886 | -162.8905196 | 2022-02-19 04:21:11 | Copper River, Alaska, US | |
1464881 | 1464881 | 2022-02-10 | US | Georgia | Echols | 13101 | 915 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-11 04:21:09 | Echols, Georgia, US | |
3074842 | 3074842 | 2022-02-09 | US | Georgia | Echols | 13101 | 915 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-10 04:21:14 | Echols, Georgia, US | |
1364272 | 1364272 | 2022-02-08 | US | Missouri | Knox | 29103 | 915 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-02-09 04:21:04 | Knox, Missouri, US | |
1782142 | 1782142 | 2022-01-27 | US | Puerto Rico | Las Marias | 72083 | 915 | 0 | 0 | 18.23679 | -66.98362 | 2022-01-28 04:21:09 | Las Marias, Puerto Rico, US | |
2054433 | 2054433 | 2022-01-25 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-26 04:21:07 | Dewey, Oklahoma, US | |
1230164 | 1230164 | 2022-01-24 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-25 04:21:05 | Dewey, Oklahoma, US | |
1144238 | 1144238 | 2022-01-23 | US | Virginia | Craig | 51045 | 915 | 11 | 0 | 37.48133648 | -80.21072274 | 2022-01-24 04:21:12 | Craig, Virginia, US | |
1143463 | 1143463 | 2022-01-23 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-24 04:21:12 | Dewey, Oklahoma, US | |
2836156 | 2836156 | 2022-01-22 | US | Virginia | Craig | 51045 | 915 | 11 | 0 | 37.48133648 | -80.21072274 | 2022-01-23 04:21:13 | Craig, Virginia, US | |
2836030 | 2836030 | 2022-01-22 | US | Texas | Presidio | 48377 | 915 | 32 | 0 | 29.99954402 | -104.24080790000001 | 2022-01-23 04:21:13 | Presidio, Texas, US | |
2835381 | 2835381 | 2022-01-22 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-23 04:21:13 | Dewey, Oklahoma, US | |
3428274 | 3428274 | 2022-01-21 | US | Virginia | Craig | 51045 | 915 | 11 | 0 | 37.48133648 | -80.21072274 | 2022-01-22 04:21:13 | Craig, Virginia, US | |
3427499 | 3427499 | 2022-01-21 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-22 04:21:13 | Dewey, Oklahoma, US | |
1963107 | 1963107 | 2022-01-20 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-21 04:21:09 | Dewey, Oklahoma, US | |
3229002 | 3229002 | 2022-01-19 | US | Oklahoma | Dewey | 40043 | 915 | 24 | 0 | 35.98772922 | -99.00730714 | 2022-01-20 04:21:07 | Dewey, Oklahoma, US | |
1474259 | 1474259 | 2022-01-17 | US | Nevada | Lander | 32015 | 915 | 16 | 0 | 39.933223299999995 | -117.03970749999999 | 2022-01-18 04:21:04 | Lander, Nevada, US | |
3615152 | 3615152 | 2022-01-12 | US | Nebraska | Howard | 31093 | 915 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-13 08:00:09 | Howard, Nebraska, US | |
2611044 | 2611044 | 2022-01-06 | US | Illinois | Henderson | 17071 | 915 | 15 | 0 | 40.81908672 | -90.92491462 | 2022-01-07 04:22:09 | Henderson, Illinois, US | |
1282952 | 1282952 | 2022-01-05 | US | Illinois | Alexander | 17003 | 915 | 13 | 0 | 37.18049267 | -89.32910838 | 2022-01-06 04:22:09 | Alexander, Illinois, US | |
1282644 | 1282644 | 2022-01-05 | US | Colorado | Saguache | 8109 | 915 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-01-06 04:22:09 | Saguache, Colorado, US | |
3831909 | 3831909 | 2021-12-21 | US | Washington | Ferry | 53019 | 915 | 18 | 0 | 48.471143100000006 | -118.5154041 | 2021-12-22 04:21:54 | Ferry, Washington, US | |
1258212 | 1258212 | 2021-12-20 | US | Washington | Ferry | 53019 | 915 | 18 | 0 | 48.471143100000006 | -118.5154041 | 2021-12-21 03:21:27 | Ferry, Washington, US | |
2905035 | 2905035 | 2021-12-19 | US | Kansas | Mitchell | 20123 | 915 | 17 | 0 | 39.39331582 | -98.20906732 | 2021-12-20 04:21:43 | Mitchell, Kansas, US | |
1260108 | 1260108 | 2021-12-18 | US | Kansas | Mitchell | 20123 | 915 | 17 | 0 | 39.39331582 | -98.20906732 | 2021-12-19 04:21:11 | Mitchell, Kansas, US | |
2400136 | 2400136 | 2021-12-17 | US | Kansas | Mitchell | 20123 | 915 | 17 | 0 | 39.39331582 | -98.20906732 | 2021-12-18 02:22:20 | Mitchell, Kansas, US | |
3498058 | 3498058 | 2021-12-15 | US | Missouri | Atchison | 29005 | 915 | 18 | 0 | 40.43238737 | -95.42970639 | 2021-12-16 04:22:11 | Atchison, Missouri, US | |
1661770 | 1661770 | 2021-12-12 | US | Kansas | Scott | 20171 | 915 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2021-12-13 04:22:02 | Scott, Kansas, US | |
1661747 | 1661747 | 2021-12-12 | US | Kansas | Morris | 20127 | 915 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-12-13 04:22:02 | Morris, Kansas, US | |
1665786 | 1665786 | 2021-12-11 | US | Kansas | Scott | 20171 | 915 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2021-12-12 04:22:12 | Scott, Kansas, US | |
1665763 | 1665763 | 2021-12-11 | US | Kansas | Morris | 20127 | 915 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-12-12 04:22:12 | Morris, Kansas, US | |
3656938 | 3656938 | 2021-12-10 | US | Kansas | Scott | 20171 | 915 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2021-12-11 04:22:45 | Scott, Kansas, US | |
3656915 | 3656915 | 2021-12-10 | US | Kansas | Morris | 20127 | 915 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-12-11 04:22:45 | Morris, 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]);