johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
374 rows where confirmed = 1933 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954011 | 2954011 | 2022-12-20 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-21 04:21:03 | Harney, Oregon, US | |
3176413 | 3176413 | 2022-12-19 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-20 04:21:04 | Harney, Oregon, US | |
1630930 | 1630930 | 2022-12-18 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-19 04:21:03 | Harney, Oregon, US | |
506309 | 506309 | 2022-12-17 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-18 04:21:03 | Harney, Oregon, US | |
3326881 | 3326881 | 2022-12-16 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-17 04:21:04 | Harney, Oregon, US | |
545393 | 545393 | 2022-12-15 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-16 04:21:01 | Harney, Oregon, US | |
350921 | 350921 | 2022-12-14 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-15 04:20:58 | Harney, Oregon, US | |
310509 | 310509 | 2022-12-13 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-14 04:21:04 | Harney, Oregon, US | |
1151570 | 1151570 | 2022-12-12 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-13 04:21:01 | Harney, Oregon, US | |
871424 | 871424 | 2022-12-11 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-12 04:21:01 | Harney, Oregon, US | |
259954 | 259954 | 2022-12-10 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-11 04:20:50 | Harney, Oregon, US | |
3938668 | 3938668 | 2022-12-09 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-10 04:21:02 | Harney, Oregon, US | |
3380000 | 3380000 | 2022-12-08 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-09 04:21:05 | Harney, Oregon, US | |
1987271 | 1987271 | 2022-12-07 | US | Oregon | Harney | 41025 | 1933 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-12-08 04:21:07 | Harney, Oregon, US | |
3553755 | 3553755 | 2022-11-27 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-28 04:21:02 | Merrick, Nebraska, US | |
2102235 | 2102235 | 2022-11-26 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-27 04:21:05 | Merrick, Nebraska, US | |
489726 | 489726 | 2022-11-25 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-26 04:21:11 | Merrick, Nebraska, US | |
3525555 | 3525555 | 2022-11-24 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-25 04:21:06 | Merrick, Nebraska, US | |
3314338 | 3314338 | 2022-11-23 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-24 04:21:09 | Merrick, Nebraska, US | |
1622379 | 1622379 | 2022-11-22 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-23 04:21:06 | Merrick, Nebraska, US | |
3462267 | 3462267 | 2022-11-21 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-22 04:20:47 | Merrick, Nebraska, US | |
1642452 | 1642452 | 2022-11-20 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-21 04:21:05 | Merrick, Nebraska, US | |
2066009 | 2066009 | 2022-11-19 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-20 04:21:08 | Merrick, Nebraska, US | |
1757403 | 1757403 | 2022-11-18 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-19 04:21:14 | Merrick, Nebraska, US | |
3028396 | 3028396 | 2022-11-17 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-18 04:21:15 | Merrick, Nebraska, US | |
2488107 | 2488107 | 2022-11-16 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-17 04:21:11 | Merrick, Nebraska, US | |
294118 | 294118 | 2022-11-15 | US | Nebraska | Merrick | 31121 | 1933 | 25 | 0 | 41.16624273 | -98.0374887 | 2022-11-16 04:21:09 | Merrick, Nebraska, US | |
1049652 | 1049652 | 2022-11-06 | China | Xinjiang | 1933 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-07 04:21:26 | Xinjiang, China | |||
617676 | 617676 | 2022-11-05 | China | Xinjiang | 1933 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-06 04:21:24 | Xinjiang, China | |||
3756643 | 3756643 | 2022-10-13 | US | Texas | Marion | 48315 | 1933 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-14 04:22:28 | Marion, Texas, US | |
3217468 | 3217468 | 2022-10-12 | US | Texas | Marion | 48315 | 1933 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-13 04:22:39 | Marion, Texas, US | |
3253317 | 3253317 | 2022-10-11 | US | Texas | Marion | 48315 | 1933 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-12 04:22:51 | Marion, Texas, US | |
2970576 | 2970576 | 2022-10-10 | US | Texas | Marion | 48315 | 1933 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-11 04:23:05 | Marion, Texas, US | |
1811292 | 1811292 | 2022-10-05 | US | Arkansas | Newton | 5101 | 1933 | 50 | 0 | 35.91947491 | -93.21612969 | 2022-10-06 04:21:22 | Newton, Arkansas, US | |
1253830 | 1253830 | 2022-08-23 | US | Texas | Delta | 48119 | 1933 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-08-24 04:20:46 | Delta, Texas, US | |
1087419 | 1087419 | 2022-08-09 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-10 04:20:57 | Russell, Kansas, US | |
3544834 | 3544834 | 2022-08-08 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-09 04:20:34 | Russell, Kansas, US | |
1071237 | 1071237 | 2022-08-07 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-08 04:21:08 | Russell, Kansas, US | |
1941825 | 1941825 | 2022-08-06 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-07 04:20:54 | Russell, Kansas, US | |
881624 | 881624 | 2022-08-05 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-06 04:20:56 | Russell, Kansas, US | |
2010035 | 2010035 | 2022-08-04 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-05 04:20:52 | Russell, Kansas, US | |
1099462 | 1099462 | 2022-08-03 | US | Kansas | Russell | 20167 | 1933 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-04 04:20:58 | Russell, Kansas, US | |
2338381 | 2338381 | 2022-07-27 | US | Tennessee | Pickett | 47137 | 1933 | 38 | 0 | 36.55606529 | -85.077633 | 2022-07-28 04:20:56 | Pickett, Tennessee, US | |
903390 | 903390 | 2022-07-22 | US | Texas | Stephens | 48429 | 1933 | 46 | 0 | 32.73553157 | -98.83631615 | 2022-07-23 04:20:53 | Stephens, Texas, US | |
673608 | 673608 | 2022-07-21 | US | Virginia | Bland | 51021 | 1933 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-07-22 04:21:15 | Bland, Virginia, US | |
962075 | 962075 | 2022-07-19 | US | Texas | Mitchell | 48335 | 1933 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-07-20 04:20:59 | Mitchell, Texas, US | |
169409 | 169409 | 2022-06-21 | US | Virginia | Lancaster | 51103 | 1933 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-06-22 04:20:54 | Lancaster, Virginia, US | |
3726851 | 3726851 | 2022-06-07 | US | Colorado | Lake | 8065 | 1933 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-08 04:20:55 | Lake, Colorado, US | |
3135605 | 3135605 | 2022-06-03 | US | Nebraska | Butler | 31023 | 1933 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-04 04:20:58 | Butler, Nebraska, US | |
3580680 | 3580680 | 2022-06-02 | US | Nebraska | Butler | 31023 | 1933 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-03 04:20:58 | Butler, Nebraska, US | |
974029 | 974029 | 2022-06-01 | US | Texas | Hansford | 48195 | 1933 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-06-02 05:20:39 | Hansford, Texas, US | |
972973 | 972973 | 2022-06-01 | US | Nebraska | Butler | 31023 | 1933 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-02 05:20:39 | Butler, Nebraska, US | |
232336 | 232336 | 2022-05-31 | US | Texas | Hansford | 48195 | 1933 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-06-01 04:20:55 | Hansford, Texas, US | |
231280 | 231280 | 2022-05-31 | US | Nebraska | Butler | 31023 | 1933 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-01 04:20:55 | Butler, Nebraska, US | |
3000641 | 3000641 | 2022-05-24 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-25 04:20:56 | Pratt, Kansas, US | |
3594362 | 3594362 | 2022-05-23 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-24 04:20:57 | Pratt, Kansas, US | |
3592837 | 3592837 | 2022-05-23 | China | Tianjin | 1933 | 3 | 0 | 39.3054 | 117.323 | 2022-05-24 04:20:57 | Tianjin, China | |||
1110910 | 1110910 | 2022-05-21 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-22 04:20:52 | Pratt, Kansas, US | |
1170534 | 1170534 | 2022-05-20 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-21 04:20:58 | Pratt, Kansas, US | |
3897297 | 3897297 | 2022-05-19 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-20 04:20:57 | Pratt, Kansas, US | |
1186081 | 1186081 | 2022-05-18 | US | Kansas | Pratt | 20151 | 1933 | 33 | 0 | 37.64780729 | -98.73922153 | 2022-05-19 04:20:54 | Pratt, Kansas, US | |
222505 | 222505 | 2022-05-09 | US | Arkansas | Monroe | 5095 | 1933 | 35 | 0 | 34.6815935 | -91.20540287 | 2022-05-10 04:20:50 | Monroe, Arkansas, US | |
2331890 | 2331890 | 2022-05-08 | US | Arkansas | Monroe | 5095 | 1933 | 35 | 0 | 34.6815935 | -91.20540287 | 2022-05-09 04:20:54 | Monroe, Arkansas, US | |
360852 | 360852 | 2022-05-07 | US | Arkansas | Monroe | 5095 | 1933 | 35 | 0 | 34.6815935 | -91.20540287 | 2022-05-08 04:20:49 | Monroe, Arkansas, US | |
1398203 | 1398203 | 2022-05-06 | US | Arkansas | Monroe | 5095 | 1933 | 35 | 0 | 34.6815935 | -91.20540287 | 2022-05-07 04:21:09 | Monroe, Arkansas, US | |
1908702 | 1908702 | 2022-03-22 | US | West Virginia | Pendleton | 54071 | 1933 | 17 | 0 | 38.68314479 | -79.35084086 | 2022-03-23 04:20:48 | Pendleton, West Virginia, US | |
3241833 | 3241833 | 2022-03-21 | US | West Virginia | Pendleton | 54071 | 1933 | 17 | 0 | 38.68314479 | -79.35084086 | 2022-03-22 04:20:54 | Pendleton, West Virginia, US | |
953953 | 953953 | 2022-03-12 | US | Texas | Floyd | 48153 | 1933 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-03-13 04:20:49 | Floyd, Texas, US | |
1300440 | 1300440 | 2022-02-17 | US | North Dakota | Benson | 38005 | 1933 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-02-18 04:21:04 | Benson, North Dakota, US | |
2645261 | 2645261 | 2022-02-14 | US | West Virginia | Pocahontas | 54075 | 1933 | 25 | 0 | 38.32758728 | -80.00993811 | 2022-02-15 04:21:09 | Pocahontas, West Virginia, US | |
3074950 | 3074950 | 2022-02-09 | US | Georgia | Wilcox | 13315 | 1933 | 63 | 0 | 31.97496928 | -83.43438555 | 2022-02-10 04:21:14 | Wilcox, Georgia, US | |
74198 | 74198 | 2022-02-07 | US | Texas | Hamilton | 48193 | 1933 | 29 | 0 | 31.70470573 | -98.11083887 | 2022-02-08 04:21:15 | Hamilton, Texas, US | |
73304 | 73304 | 2022-02-07 | US | New Mexico | Sierra | 35051 | 1933 | 69 | 0 | 33.13028233 | -107.1925893 | 2022-02-08 04:21:15 | Sierra, New Mexico, US | |
2329306 | 2329306 | 2022-02-04 | US | Missouri | Oregon | 29149 | 1933 | 28 | 0 | 36.68710164 | -91.4033755 | 2022-02-05 04:21:05 | Oregon, Missouri, US | |
3064774 | 3064774 | 2022-01-29 | US | Puerto Rico | Sabana Grande | 72121 | 1933 | 0 | 0 | 18.08282 | -66.943758 | 2022-01-30 04:21:26 | Sabana Grande, Puerto Rico, US | |
3426853 | 3426853 | 2022-01-21 | US | Missouri | Gentry | 29075 | 1933 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-01-22 04:21:13 | Gentry, Missouri, US | |
3465456 | 3465456 | 2022-01-18 | US | Kansas | Doniphan | 20043 | 1933 | 32 | 0 | 39.79067154 | -95.14056866 | 2022-01-19 04:21:23 | Doniphan, Kansas, US | |
1473395 | 1473395 | 2022-01-17 | US | Kansas | Doniphan | 20043 | 1933 | 32 | 0 | 39.79067154 | -95.14056866 | 2022-01-18 04:21:04 | Doniphan, Kansas, US | |
556069 | 556069 | 2022-01-16 | US | Kansas | Doniphan | 20043 | 1933 | 32 | 0 | 39.79067154 | -95.14056866 | 2022-01-17 04:21:08 | Doniphan, Kansas, US | |
3841790 | 3841790 | 2022-01-15 | US | Kansas | Doniphan | 20043 | 1933 | 32 | 0 | 39.79067154 | -95.14056866 | 2022-01-16 04:21:12 | Doniphan, Kansas, US | |
100605 | 100605 | 2022-01-14 | US | Kansas | Doniphan | 20043 | 1933 | 32 | 0 | 39.79067154 | -95.14056866 | 2022-01-15 04:21:07 | Doniphan, Kansas, US | |
3615002 | 3615002 | 2022-01-12 | US | Missouri | Montgomery | 29139 | 1933 | 35 | 0 | 38.94022054 | -91.47000721 | 2022-01-13 08:00:09 | Montgomery, Missouri, US | |
1694670 | 1694670 | 2022-01-10 | US | North Carolina | Pamlico | 37137 | 1933 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-11 04:22:01 | Pamlico, North Carolina, US | |
2612045 | 2612045 | 2022-01-06 | US | Montana | Fergus | 30027 | 1933 | 51 | 0 | 47.26331584 | -109.2245206 | 2022-01-07 04:22:09 | Fergus, Montana, US | |
1287797 | 1287797 | 2022-01-04 | US | Mississippi | Carroll | 28015 | 1933 | 41 | 0 | 33.44834567 | -89.91994479 | 2022-01-05 04:21:59 | Carroll, Mississippi, US | |
2170745 | 2170745 | 2022-01-01 | US | Texas | Morris | 48343 | 1933 | 58 | 0 | 33.11304005 | -94.73255695 | 2022-01-02 04:20:52 | Morris, Texas, US | |
733434 | 733434 | 2021-12-27 | US | South Dakota | Todd | 46121 | 1933 | 39 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-28 04:21:47 | Todd, South Dakota, US | |
3829693 | 3829693 | 2021-12-21 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-22 04:21:54 | Mitchell, Iowa, US | |
1255996 | 1255996 | 2021-12-20 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-21 03:21:27 | Mitchell, Iowa, US | |
2904939 | 2904939 | 2021-12-19 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-20 04:21:43 | Mitchell, Iowa, US | |
1260012 | 1260012 | 2021-12-18 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-19 04:21:11 | Mitchell, Iowa, US | |
2400040 | 2400040 | 2021-12-17 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-18 02:22:20 | Mitchell, Iowa, US | |
1717578 | 1717578 | 2021-12-16 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-17 04:22:14 | Mitchell, Iowa, US | |
3497412 | 3497412 | 2021-12-15 | US | Iowa | Mitchell | 19131 | 1933 | 46 | 0 | 43.35638371 | -92.78887719 | 2021-12-16 04:22:11 | Mitchell, Iowa, US | |
2090387 | 2090387 | 2021-12-14 | US | North Dakota | Mercer | 38057 | 1933 | 21 | 0 | 47.31213126 | -101.8318399 | 2021-12-15 03:22:16 | Mercer, North Dakota, US | |
3658116 | 3658116 | 2021-12-10 | US | Ohio | Vinton | 39163 | 1933 | 43 | 0 | 39.25208988 | -82.4831444 | 2021-12-11 04:22:45 | Vinton, Ohio, US | |
1079708 | 1079708 | 2021-12-09 | US | Minnesota | Yellow Medicine | 27173 | 1933 | 25 | 0 | 44.71710183 | -95.86842453 | 2021-12-10 04:22:28 | Yellow Medicine, Minnesota, US | |
1079399 | 1079399 | 2021-12-09 | US | Kentucky | Todd | 21219 | 1933 | 36 | 0 | 36.8381152 | -87.17878374 | 2021-12-10 04:22:28 | Todd, Kentucky, US | |
552699 | 552699 | 2021-12-08 | US | Missouri | Linn | 29115 | 1933 | 57 | 0 | 39.87001769 | -93.10704106 | 2021-12-09 04:22:49 | Linn, Missouri, US | |
551260 | 551260 | 2021-12-08 | US | Arkansas | Fulton | 5049 | 1933 | 69 | 0 | 36.38177105 | -91.81729127 | 2021-12-09 04:22:49 | Fulton, Arkansas, 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]);