johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,157 rows where deaths = 140 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755570 | 2755570 | 2022-12-29 | US | Pennsylvania | Clinton | 42035 | 10860 | 140 | 0 | 41.23255967 | -77.63785995 | 2022-12-30 04:21:04 | Clinton, Pennsylvania, US | |
2755168 | 2755168 | 2022-12-29 | US | New York | Putnam | 36079 | 30664 | 140 | 0 | 41.42630093 | -73.74965532 | 2022-12-30 04:21:04 | Putnam, New York, US | |
2755004 | 2755004 | 2022-12-29 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-30 04:21:04 | Lincoln, Nebraska, US | |
2754381 | 2754381 | 2022-12-29 | US | Kentucky | Taylor | 21217 | 11450 | 140 | 0 | 37.3677562 | -85.3329931 | 2022-12-30 04:21:04 | Taylor, Kentucky, US | |
2754224 | 2754224 | 2022-12-29 | US | Kansas | McPherson | 20113 | 9312 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-30 04:21:04 | McPherson, Kansas, US | |
2754184 | 2754184 | 2022-12-29 | US | Kansas | Crawford | 20037 | 14793 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-30 04:21:04 | Crawford, Kansas, US | |
2753984 | 2753984 | 2022-12-29 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-30 04:21:04 | Clinton, Indiana, US | |
1076576 | 1076576 | 2022-12-28 | US | Pennsylvania | Clinton | 42035 | 10860 | 140 | 0 | 41.23255967 | -77.63785995 | 2022-12-29 04:21:01 | Clinton, Pennsylvania, US | |
1076174 | 1076174 | 2022-12-28 | US | New York | Putnam | 36079 | 30625 | 140 | 0 | 41.42630093 | -73.74965532 | 2022-12-29 04:21:01 | Putnam, New York, US | |
1076010 | 1076010 | 2022-12-28 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-29 04:21:01 | Lincoln, Nebraska, US | |
1075387 | 1075387 | 2022-12-28 | US | Kentucky | Taylor | 21217 | 11450 | 140 | 0 | 37.3677562 | -85.3329931 | 2022-12-29 04:21:01 | Taylor, Kentucky, US | |
1075230 | 1075230 | 2022-12-28 | US | Kansas | McPherson | 20113 | 9312 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-29 04:21:01 | McPherson, Kansas, US | |
1075190 | 1075190 | 2022-12-28 | US | Kansas | Crawford | 20037 | 14793 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-29 04:21:01 | Crawford, Kansas, US | |
1074990 | 1074990 | 2022-12-28 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-29 04:21:01 | Clinton, Indiana, US | |
330171 | 330171 | 2022-12-27 | US | New York | Putnam | 36079 | 30603 | 140 | 0 | 41.42630093 | -73.74965532 | 2022-12-28 04:21:04 | Putnam, New York, US | |
330007 | 330007 | 2022-12-27 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-28 04:21:04 | Lincoln, Nebraska, US | |
329384 | 329384 | 2022-12-27 | US | Kentucky | Taylor | 21217 | 11450 | 140 | 0 | 37.3677562 | -85.3329931 | 2022-12-28 04:21:04 | Taylor, Kentucky, US | |
329227 | 329227 | 2022-12-27 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-28 04:21:04 | McPherson, Kansas, US | |
329187 | 329187 | 2022-12-27 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-28 04:21:04 | Crawford, Kansas, US | |
328987 | 328987 | 2022-12-27 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-28 04:21:04 | Clinton, Indiana, US | |
327896 | 327896 | 2022-12-27 | Japan | Fukui | 166524 | 140 | 0 | 35.846614 | 136.224654 | 2022-12-28 04:21:04 | Fukui, Japan | |||
220080 | 220080 | 2022-12-26 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-27 04:21:07 | Lincoln, Nebraska, US | |
219300 | 219300 | 2022-12-26 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-27 04:21:07 | McPherson, Kansas, US | |
219260 | 219260 | 2022-12-26 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-27 04:21:07 | Crawford, Kansas, US | |
219060 | 219060 | 2022-12-26 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-27 04:21:07 | Clinton, Indiana, US | |
3224537 | 3224537 | 2022-12-25 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-26 04:21:06 | Lincoln, Nebraska, US | |
3223757 | 3223757 | 2022-12-25 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-26 04:21:06 | McPherson, Kansas, US | |
3223717 | 3223717 | 2022-12-25 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-26 04:21:06 | Crawford, Kansas, US | |
3223517 | 3223517 | 2022-12-25 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-26 04:21:06 | Clinton, Indiana, US | |
1020451 | 1020451 | 2022-12-24 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-25 04:21:04 | Lincoln, Nebraska, US | |
1019671 | 1019671 | 2022-12-24 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-25 04:21:04 | McPherson, Kansas, US | |
1019631 | 1019631 | 2022-12-24 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-25 04:21:04 | Crawford, Kansas, US | |
1019431 | 1019431 | 2022-12-24 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-25 04:21:04 | Clinton, Indiana, US | |
692474 | 692474 | 2022-12-23 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-24 04:21:02 | Lincoln, Nebraska, US | |
691694 | 691694 | 2022-12-23 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-24 04:21:02 | McPherson, Kansas, US | |
691654 | 691654 | 2022-12-23 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-24 04:21:02 | Crawford, Kansas, US | |
691454 | 691454 | 2022-12-23 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-24 04:21:02 | Clinton, Indiana, US | |
2181684 | 2181684 | 2022-12-22 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-23 04:21:04 | Lincoln, Nebraska, US | |
2180904 | 2180904 | 2022-12-22 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-23 04:21:04 | McPherson, Kansas, US | |
2180864 | 2180864 | 2022-12-22 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-23 04:21:04 | Crawford, Kansas, US | |
2180664 | 2180664 | 2022-12-22 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-23 04:21:04 | Clinton, Indiana, US | |
453488 | 453488 | 2022-12-21 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-22 04:20:56 | Lincoln, Nebraska, US | |
452708 | 452708 | 2022-12-21 | US | Kansas | McPherson | 20113 | 9284 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-22 04:20:56 | McPherson, Kansas, US | |
452668 | 452668 | 2022-12-21 | US | Kansas | Crawford | 20037 | 14770 | 140 | 0 | 37.50675523 | -94.85245778 | 2022-12-22 04:20:56 | Crawford, Kansas, US | |
452468 | 452468 | 2022-12-21 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-22 04:20:56 | Clinton, Indiana, US | |
2953487 | 2953487 | 2022-12-20 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-21 04:21:03 | Lincoln, Nebraska, US | |
2952707 | 2952707 | 2022-12-20 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-21 04:21:03 | McPherson, Kansas, US | |
2952467 | 2952467 | 2022-12-20 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-21 04:21:03 | Clinton, Indiana, US | |
3175889 | 3175889 | 2022-12-19 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-20 04:21:04 | Lincoln, Nebraska, US | |
3175109 | 3175109 | 2022-12-19 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-20 04:21:04 | McPherson, Kansas, US | |
3174869 | 3174869 | 2022-12-19 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-20 04:21:04 | Clinton, Indiana, US | |
1630406 | 1630406 | 2022-12-18 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-19 04:21:03 | Lincoln, Nebraska, US | |
1629626 | 1629626 | 2022-12-18 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-19 04:21:03 | McPherson, Kansas, US | |
1629386 | 1629386 | 2022-12-18 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-19 04:21:03 | Clinton, Indiana, US | |
505785 | 505785 | 2022-12-17 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-18 04:21:03 | Lincoln, Nebraska, US | |
505005 | 505005 | 2022-12-17 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-18 04:21:03 | McPherson, Kansas, US | |
504765 | 504765 | 2022-12-17 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-18 04:21:03 | Clinton, Indiana, US | |
3326357 | 3326357 | 2022-12-16 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-17 04:21:04 | Lincoln, Nebraska, US | |
3325577 | 3325577 | 2022-12-16 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-17 04:21:04 | McPherson, Kansas, US | |
3325337 | 3325337 | 2022-12-16 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-17 04:21:04 | Clinton, Indiana, US | |
3324278 | 3324278 | 2022-12-16 | Japan | Shimane | 119160 | 140 | 0 | 35.07076 | 132.554064 | 2022-12-17 04:21:04 | Shimane, Japan | |||
545746 | 545746 | 2022-12-15 | US | Tennessee | McNairy | 47109 | 9144 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-16 04:21:01 | McNairy, Tennessee, US | |
544869 | 544869 | 2022-12-15 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-16 04:21:01 | Lincoln, Nebraska, US | |
544089 | 544089 | 2022-12-15 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-16 04:21:01 | McPherson, Kansas, US | |
543849 | 543849 | 2022-12-15 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-16 04:21:01 | Clinton, Indiana, US | |
542790 | 542790 | 2022-12-15 | Japan | Shimane | 118133 | 140 | 0 | 35.07076 | 132.554064 | 2022-12-16 04:21:01 | Shimane, Japan | |||
351660 | 351660 | 2022-12-14 | US | Virginia | James City | 51095 | 20159 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-15 04:20:58 | James City, Virginia, US | |
351274 | 351274 | 2022-12-14 | US | Tennessee | McNairy | 47109 | 9133 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-15 04:20:58 | McNairy, Tennessee, US | |
350397 | 350397 | 2022-12-14 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-15 04:20:58 | Lincoln, Nebraska, US | |
349617 | 349617 | 2022-12-14 | US | Kansas | McPherson | 20113 | 9238 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-15 04:20:58 | McPherson, Kansas, US | |
349377 | 349377 | 2022-12-14 | US | Indiana | Clinton | 18023 | 10378 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-15 04:20:58 | Clinton, Indiana, US | |
311248 | 311248 | 2022-12-13 | US | Virginia | James City | 51095 | 20142 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-14 04:21:04 | James City, Virginia, US | |
310862 | 310862 | 2022-12-13 | US | Tennessee | McNairy | 47109 | 9127 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-14 04:21:04 | McNairy, Tennessee, US | |
309985 | 309985 | 2022-12-13 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-14 04:21:04 | Lincoln, Nebraska, US | |
309205 | 309205 | 2022-12-13 | US | Kansas | McPherson | 20113 | 9190 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-14 04:21:04 | McPherson, Kansas, US | |
308965 | 308965 | 2022-12-13 | US | Indiana | Clinton | 18023 | 10354 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-14 04:21:04 | Clinton, Indiana, US | |
1152325 | 1152325 | 2022-12-12 | US | Virginia | Mecklenburg | 51117 | 7487 | 140 | 0 | 36.67882005 | -78.36131056 | 2022-12-13 04:21:01 | Mecklenburg, Virginia, US | |
1152309 | 1152309 | 2022-12-12 | US | Virginia | James City | 51095 | 20125 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-13 04:21:01 | James City, Virginia, US | |
1151923 | 1151923 | 2022-12-12 | US | Tennessee | McNairy | 47109 | 9120 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-13 04:21:01 | McNairy, Tennessee, US | |
1151046 | 1151046 | 2022-12-12 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-13 04:21:01 | Lincoln, Nebraska, US | |
1150266 | 1150266 | 2022-12-12 | US | Kansas | McPherson | 20113 | 9190 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-13 04:21:01 | McPherson, Kansas, US | |
1150026 | 1150026 | 2022-12-12 | US | Indiana | Clinton | 18023 | 10354 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-13 04:21:01 | Clinton, Indiana, US | |
872179 | 872179 | 2022-12-11 | US | Virginia | Mecklenburg | 51117 | 7473 | 140 | 0 | 36.67882005 | -78.36131056 | 2022-12-12 04:21:01 | Mecklenburg, Virginia, US | |
872163 | 872163 | 2022-12-11 | US | Virginia | James City | 51095 | 20080 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-12 04:21:01 | James City, Virginia, US | |
871812 | 871812 | 2022-12-11 | US | Tennessee | White | 47185 | 9563 | 140 | 0 | 35.92929884 | -85.45591799 | 2022-12-12 04:21:01 | White, Tennessee, US | |
871777 | 871777 | 2022-12-11 | US | Tennessee | McNairy | 47109 | 9108 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-12 04:21:01 | McNairy, Tennessee, US | |
870900 | 870900 | 2022-12-11 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-12 04:21:01 | Lincoln, Nebraska, US | |
870120 | 870120 | 2022-12-11 | US | Kansas | McPherson | 20113 | 9190 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-12 04:21:01 | McPherson, Kansas, US | |
869880 | 869880 | 2022-12-11 | US | Indiana | Clinton | 18023 | 10354 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-12 04:21:01 | Clinton, Indiana, US | |
260709 | 260709 | 2022-12-10 | US | Virginia | Mecklenburg | 51117 | 7473 | 140 | 0 | 36.67882005 | -78.36131056 | 2022-12-11 04:20:50 | Mecklenburg, Virginia, US | |
260693 | 260693 | 2022-12-10 | US | Virginia | James City | 51095 | 20080 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-11 04:20:50 | James City, Virginia, US | |
260342 | 260342 | 2022-12-10 | US | Tennessee | White | 47185 | 9562 | 140 | 0 | 35.92929884 | -85.45591799 | 2022-12-11 04:20:50 | White, Tennessee, US | |
260307 | 260307 | 2022-12-10 | US | Tennessee | McNairy | 47109 | 9108 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-11 04:20:50 | McNairy, Tennessee, US | |
259430 | 259430 | 2022-12-10 | US | Nebraska | Lincoln | 31111 | 10273 | 140 | 0 | 41.04658298 | -100.7475374 | 2022-12-11 04:20:50 | Lincoln, Nebraska, US | |
258650 | 258650 | 2022-12-10 | US | Kansas | McPherson | 20113 | 9190 | 140 | 0 | 38.39184858 | -97.64769869 | 2022-12-11 04:20:50 | McPherson, Kansas, US | |
258410 | 258410 | 2022-12-10 | US | Indiana | Clinton | 18023 | 10354 | 140 | 0 | 40.30319754 | -86.47277257 | 2022-12-11 04:20:50 | Clinton, Indiana, US | |
3939423 | 3939423 | 2022-12-09 | US | Virginia | Mecklenburg | 51117 | 7473 | 140 | 0 | 36.67882005 | -78.36131056 | 2022-12-10 04:21:02 | Mecklenburg, Virginia, US | |
3939407 | 3939407 | 2022-12-09 | US | Virginia | James City | 51095 | 20080 | 140 | 0 | 37.31156958 | -76.76950618 | 2022-12-10 04:21:02 | James City, Virginia, US | |
3939056 | 3939056 | 2022-12-09 | US | Tennessee | White | 47185 | 9562 | 140 | 0 | 35.92929884 | -85.45591799 | 2022-12-10 04:21:02 | White, Tennessee, US | |
3939021 | 3939021 | 2022-12-09 | US | Tennessee | McNairy | 47109 | 9108 | 140 | 0 | 35.17468549 | -88.5647812 | 2022-12-10 04:21:02 | McNairy, Tennessee, 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]);