johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
742 rows where confirmed = 486 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621552 | 1621552 | 2022-11-22 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-23 04:21:06 | Comanche, Kansas, US | |
3461440 | 3461440 | 2022-11-21 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-22 04:20:47 | Comanche, Kansas, US | |
1641625 | 1641625 | 2022-11-20 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-21 04:21:05 | Comanche, Kansas, US | |
2065182 | 2065182 | 2022-11-19 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-20 04:21:08 | Comanche, Kansas, US | |
1756576 | 1756576 | 2022-11-18 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-19 04:21:14 | Comanche, Kansas, US | |
3027569 | 3027569 | 2022-11-17 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-18 04:21:15 | Comanche, Kansas, US | |
2487280 | 2487280 | 2022-11-16 | US | Kansas | Comanche | 20033 | 486 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-17 04:21:11 | Comanche, Kansas, US | |
3599154 | 3599154 | 2022-11-14 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-15 04:21:16 | Pawnee, Nebraska, US | |
314012 | 314012 | 2022-11-13 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-14 04:21:09 | Pawnee, Nebraska, US | |
65173 | 65173 | 2022-11-12 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-13 04:21:14 | Pawnee, Nebraska, US | |
2929335 | 2929335 | 2022-11-11 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-12 04:20:41 | Pawnee, Nebraska, US | |
2508171 | 2508171 | 2022-11-10 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-11 04:21:22 | Pawnee, Nebraska, US | |
2433046 | 2433046 | 2022-11-09 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-10 04:21:16 | Pawnee, Nebraska, US | |
481702 | 481702 | 2022-11-08 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-09 04:21:22 | Pawnee, Nebraska, US | |
2440852 | 2440852 | 2022-11-07 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-08 04:21:21 | Pawnee, Nebraska, US | |
1051950 | 1051950 | 2022-11-06 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-07 04:21:26 | Pawnee, Nebraska, US | |
619974 | 619974 | 2022-11-05 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-06 04:21:24 | Pawnee, Nebraska, US | |
1024478 | 1024478 | 2022-11-04 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-05 04:21:52 | Pawnee, Nebraska, US | |
433469 | 433469 | 2022-11-03 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-04 04:22:11 | Pawnee, Nebraska, US | |
851711 | 851711 | 2022-11-02 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-03 04:22:05 | Pawnee, Nebraska, US | |
712562 | 712562 | 2022-11-01 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-02 04:22:09 | Pawnee, Nebraska, US | |
3287011 | 3287011 | 2022-10-31 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-11-01 04:22:36 | Pawnee, Nebraska, US | |
322044 | 322044 | 2022-10-30 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-10-31 04:21:36 | Pawnee, Nebraska, US | |
914320 | 914320 | 2022-10-29 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-10-30 04:22:14 | Pawnee, Nebraska, US | |
1369219 | 1369219 | 2022-10-28 | US | Puerto Rico | Culebra | 72049 | 486 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-29 04:21:13 | Culebra, Puerto Rico, US | |
1368589 | 1368589 | 2022-10-28 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-10-29 04:21:13 | Pawnee, Nebraska, US | |
3040444 | 3040444 | 2022-10-27 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-10-28 04:22:31 | Pawnee, Nebraska, US | |
540864 | 540864 | 2022-10-26 | US | Nebraska | Pawnee | 31133 | 486 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-10-27 04:22:01 | Pawnee, Nebraska, US | |
2161545 | 2161545 | 2022-10-16 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-17 04:20:31 | Liberty, Montana, US | |
517742 | 517742 | 2022-10-15 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-16 04:22:39 | Liberty, Montana, US | |
2034799 | 2034799 | 2022-10-14 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-15 04:22:00 | Liberty, Montana, US | |
3755487 | 3755487 | 2022-10-13 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-14 04:22:28 | Liberty, Montana, US | |
3216312 | 3216312 | 2022-10-12 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-13 04:22:39 | Liberty, Montana, US | |
3252161 | 3252161 | 2022-10-11 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-12 04:22:51 | Liberty, Montana, US | |
2969420 | 2969420 | 2022-10-10 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-11 04:23:05 | Liberty, Montana, US | |
3099456 | 3099456 | 2022-10-09 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-10 04:22:32 | Liberty, Montana, US | |
4004681 | 4004681 | 2022-10-08 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-09 04:21:16 | Liberty, Montana, US | |
398278 | 398278 | 2022-10-07 | US | Montana | Liberty | 30051 | 486 | 4 | 0 | 48.56084317 | -111.024307 | 2022-10-08 04:22:56 | Liberty, Montana, US | |
1088950 | 1088950 | 2022-08-09 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-10 04:20:57 | Haakon, South Dakota, US | |
3546365 | 3546365 | 2022-08-08 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-09 04:20:34 | Haakon, South Dakota, US | |
1072768 | 1072768 | 2022-08-07 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-08 04:21:08 | Haakon, South Dakota, US | |
1943356 | 1943356 | 2022-08-06 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-07 04:20:54 | Haakon, South Dakota, US | |
883155 | 883155 | 2022-08-05 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-06 04:20:56 | Haakon, South Dakota, US | |
2011566 | 2011566 | 2022-08-04 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-05 04:20:52 | Haakon, South Dakota, US | |
1100993 | 1100993 | 2022-08-03 | US | South Dakota | Haakon | 46055 | 486 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-04 04:20:58 | Haakon, South Dakota, US | |
3873966 | 3873966 | 2022-07-31 | US | North Dakota | Grant | 38037 | 486 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-08-01 04:21:03 | Grant, North Dakota, US | |
676720 | 676720 | 2022-07-30 | US | North Dakota | Grant | 38037 | 486 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-31 04:21:02 | Grant, North Dakota, US | |
1785919 | 1785919 | 2022-07-29 | US | North Dakota | Grant | 38037 | 486 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-30 04:20:42 | Grant, North Dakota, US | |
1202937 | 1202937 | 2022-07-06 | US | Texas | Irion | 48235 | 486 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-07 04:20:55 | Irion, Texas, US | |
3967479 | 3967479 | 2022-07-05 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-06 04:20:58 | Butte, Idaho, US | |
3078990 | 3078990 | 2022-07-04 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-05 04:20:45 | Butte, Idaho, US | |
1768272 | 1768272 | 2022-07-03 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-04 04:20:54 | Butte, Idaho, US | |
3366258 | 3366258 | 2022-07-02 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-03 04:20:59 | Butte, Idaho, US | |
594587 | 594587 | 2022-07-01 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-02 04:21:16 | Butte, Idaho, US | |
3942457 | 3942457 | 2022-06-30 | US | North Dakota | Divide | 38023 | 486 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-01 04:21:10 | Divide, North Dakota, US | |
3940988 | 3940988 | 2022-06-30 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-01 04:21:10 | Butte, Idaho, US | |
2490946 | 2490946 | 2022-06-29 | US | Idaho | Butte | 16023 | 486 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-30 04:21:01 | Butte, Idaho, US | |
3349718 | 3349718 | 2022-06-24 | US | Texas | Edwards | 48137 | 486 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-25 04:20:57 | Edwards, Texas, US | |
1651459 | 1651459 | 2022-06-23 | US | Texas | Edwards | 48137 | 486 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-24 04:20:58 | Edwards, Texas, US | |
920127 | 920127 | 2022-03-08 | US | Alaska | Yakutat | 2282 | 486 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-03-09 04:20:59 | Yakutat, Alaska, US | |
1548629 | 1548629 | 2022-03-07 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-08 04:20:54 | Sedgwick, Colorado, US | |
1548414 | 1548414 | 2022-03-07 | US | Alaska | Yakutat | 2282 | 486 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-03-08 04:20:54 | Yakutat, Alaska, US | |
2200298 | 2200298 | 2022-03-06 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-07 04:20:47 | Sedgwick, Colorado, US | |
2092755 | 2092755 | 2022-03-05 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-06 04:20:49 | Sedgwick, Colorado, US | |
2666455 | 2666455 | 2022-03-04 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-05 04:21:10 | Sedgwick, Colorado, US | |
1645020 | 1645020 | 2022-03-03 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-04 04:21:09 | Sedgwick, Colorado, US | |
2526023 | 2526023 | 2022-03-02 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-03 04:21:01 | Sedgwick, Colorado, US | |
1995808 | 1995808 | 2022-03-01 | US | Texas | Knox | 48275 | 486 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-03-02 04:21:07 | Knox, Texas, US | |
1993317 | 1993317 | 2022-03-01 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-02 04:21:07 | Sedgwick, Colorado, US | |
945982 | 945982 | 2022-02-28 | US | Texas | Knox | 48275 | 486 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-03-01 04:21:09 | Knox, Texas, US | |
943491 | 943491 | 2022-02-28 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-03-01 04:21:09 | Sedgwick, Colorado, US | |
2736173 | 2736173 | 2022-02-27 | US | Texas | Knox | 48275 | 486 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-28 04:21:05 | Knox, Texas, US | |
2733682 | 2733682 | 2022-02-27 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-28 04:21:05 | Sedgwick, Colorado, US | |
3049326 | 3049326 | 2022-02-26 | US | Texas | Knox | 48275 | 486 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-27 04:21:04 | Knox, Texas, US | |
3046835 | 3046835 | 2022-02-26 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-27 04:21:04 | Sedgwick, Colorado, US | |
575490 | 575490 | 2022-02-25 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-26 04:21:12 | Sedgwick, Colorado, US | |
1512066 | 1512066 | 2022-02-24 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-25 04:21:11 | Sedgwick, Colorado, US | |
1058507 | 1058507 | 2022-02-23 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-24 04:21:14 | Sedgwick, Colorado, US | |
2447430 | 2447430 | 2022-02-22 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-23 04:21:09 | Sedgwick, Colorado, US | |
3721407 | 3721407 | 2022-02-21 | US | Texas | Sherman | 48421 | 486 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-02-22 04:21:01 | Sherman, Texas, US | |
3718843 | 3718843 | 2022-02-21 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-22 04:21:01 | Sedgwick, Colorado, US | |
3915241 | 3915241 | 2022-02-20 | US | Texas | Sherman | 48421 | 486 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-02-21 04:21:05 | Sherman, Texas, US | |
3912677 | 3912677 | 2022-02-20 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-21 04:21:05 | Sedgwick, Colorado, US | |
3876235 | 3876235 | 2022-02-19 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-20 04:21:00 | Sedgwick, Colorado, US | |
3856491 | 3856491 | 2022-02-18 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-19 04:21:11 | Sedgwick, Colorado, US | |
1298710 | 1298710 | 2022-02-17 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-18 04:21:04 | Sedgwick, Colorado, US | |
3821096 | 3821096 | 2022-02-16 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-17 04:20:56 | Sedgwick, Colorado, US | |
3672310 | 3672310 | 2022-02-15 | US | Colorado | Sedgwick | 8115 | 486 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-16 04:21:10 | Sedgwick, Colorado, US | |
2643115 | 2643115 | 2022-02-14 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-15 04:21:09 | Wichita, Kansas, US | |
187432 | 187432 | 2022-02-13 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-14 04:20:51 | Wichita, Kansas, US | |
317278 | 317278 | 2022-02-12 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-13 04:21:00 | Wichita, Kansas, US | |
234604 | 234604 | 2022-02-11 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-12 04:21:06 | Wichita, Kansas, US | |
1465446 | 1465446 | 2022-02-10 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-11 04:21:09 | Wichita, Kansas, US | |
3076452 | 3076452 | 2022-02-09 | US | North Dakota | Kidder | 38043 | 486 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-10 04:21:14 | Kidder, North Dakota, US | |
3075407 | 3075407 | 2022-02-09 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-10 04:21:14 | Wichita, Kansas, US | |
1363714 | 1363714 | 2022-02-08 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-09 04:21:04 | Wichita, Kansas, US | |
72452 | 72452 | 2022-02-07 | US | Kansas | Wichita | 20203 | 486 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-02-08 04:21:15 | Wichita, Kansas, US | |
2014756 | 2014756 | 2022-02-06 | US | Nebraska | Brown | 31017 | 486 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-02-07 04:21:05 | Brown, Nebraska, US | |
1296085 | 1296085 | 2022-02-05 | US | Nebraska | Brown | 31017 | 486 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-02-06 04:21:00 | Brown, Nebraska, US | |
2329413 | 2329413 | 2022-02-04 | US | Nebraska | Brown | 31017 | 486 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-02-05 04:21:05 | Brown, 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]);