daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
319 rows where confirmed = 2734 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-22 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-23 04:21:04 | Dawson, Montana, US | |
2022-12-21 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-22 04:20:56 | Dawson, Montana, US | |
2022-12-20 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-21 04:21:03 | Dawson, Montana, US | |
2022-12-19 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-20 04:21:04 | Dawson, Montana, US | |
2022-12-18 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-19 04:21:03 | Dawson, Montana, US | |
2022-12-17 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-18 04:21:03 | Dawson, Montana, US | |
2022-12-16 | US | Montana | Dawson | 30021 | 2734 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-17 04:21:04 | Dawson, Montana, US | |
2022-12-06 | US | West Virginia | Webster | 54101 | 2734 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-12-07 04:20:58 | Webster, West Virginia, US | |
2022-12-05 | US | West Virginia | Webster | 54101 | 2734 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-12-06 04:21:03 | Webster, West Virginia, US | |
2022-12-01 | US | New Mexico | Colfax | 35007 | 2734 | 68 | 0 | 36.60569702 | -104.6472674 | 2022-12-02 04:21:07 | Colfax, New Mexico, US | |
2022-11-22 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-23 04:21:06 | Jones, North Carolina, US | |
2022-11-22 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-23 04:21:06 | Humboldt, Nevada, US | |
2022-11-22 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-23 04:21:06 | Mitchell, Iowa, US | |
2022-11-21 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-22 04:20:47 | Jones, North Carolina, US | |
2022-11-21 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-22 04:20:47 | Humboldt, Nevada, US | |
2022-11-21 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-22 04:20:47 | Mitchell, Iowa, US | |
2022-11-20 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-21 04:21:05 | Jones, North Carolina, US | |
2022-11-20 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-21 04:21:05 | Humboldt, Nevada, US | |
2022-11-20 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-21 04:21:05 | Mitchell, Iowa, US | |
2022-11-19 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-20 04:21:08 | Jones, North Carolina, US | |
2022-11-19 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-20 04:21:08 | Humboldt, Nevada, US | |
2022-11-19 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-20 04:21:08 | Mitchell, Iowa, US | |
2022-11-18 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-19 04:21:14 | Jones, North Carolina, US | |
2022-11-18 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-19 04:21:14 | Humboldt, Nevada, US | |
2022-11-18 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-19 04:21:14 | Mitchell, Iowa, US | |
2022-11-17 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-18 04:21:15 | Jones, North Carolina, US | |
2022-11-17 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-18 04:21:15 | Humboldt, Nevada, US | |
2022-11-17 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-18 04:21:15 | Mitchell, Iowa, US | |
2022-11-16 | US | North Carolina | Jones | 37103 | 2734 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-17 04:21:11 | Jones, North Carolina, US | |
2022-11-16 | US | Nevada | Humboldt | 32013 | 2734 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-11-17 04:21:11 | Humboldt, Nevada, US | |
2022-11-16 | US | Iowa | Mitchell | 19131 | 2734 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-17 04:21:11 | Mitchell, Iowa, US | |
2022-11-06 | US | Virginia | Sussex | 51183 | 2734 | 44 | 0 | 36.92432914 | -77.25791182 | 2022-11-07 04:21:26 | Sussex, Virginia, US | |
2022-11-05 | US | Virginia | Sussex | 51183 | 2734 | 44 | 0 | 36.92432914 | -77.25791182 | 2022-11-06 04:21:24 | Sussex, Virginia, US | |
2022-11-04 | US | Virginia | Sussex | 51183 | 2734 | 44 | 0 | 36.92432914 | -77.25791182 | 2022-11-05 04:21:52 | Sussex, Virginia, US | |
2022-11-01 | China | Jiangsu | 2734 | 0 | 0 | 32.9711 | 119.455 | 2022-11-02 04:22:09 | Jiangsu, China | |||
2022-10-26 | US | Arkansas | Scott | 5127 | 2734 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-10-27 04:22:01 | Scott, Arkansas, US | |
2022-10-25 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-26 04:22:19 | Evans, Georgia, US | |
2022-10-25 | US | Arkansas | Scott | 5127 | 2734 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-10-26 04:22:19 | Scott, Arkansas, US | |
2022-10-24 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-25 04:21:53 | Evans, Georgia, US | |
2022-10-24 | US | Arkansas | Scott | 5127 | 2734 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-10-25 04:21:53 | Scott, Arkansas, US | |
2022-10-23 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-24 04:22:29 | Evans, Georgia, US | |
2022-10-23 | US | Arkansas | Scott | 5127 | 2734 | 46 | 0 | 34.85588887 | -94.0632176 | 2022-10-24 04:22:29 | Scott, Arkansas, US | |
2022-10-22 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-23 04:22:46 | Evans, Georgia, US | |
2022-10-22 | US | Arkansas | Scott | 5127 | 2734 | 46 | 0 | 34.85588887 | -94.0632176 | 2022-10-23 04:22:46 | Scott, Arkansas, US | |
2022-10-21 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-22 04:22:53 | Evans, Georgia, US | |
2022-10-21 | US | Arkansas | Scott | 5127 | 2734 | 46 | 0 | 34.85588887 | -94.0632176 | 2022-10-22 04:22:53 | Scott, Arkansas, US | |
2022-10-20 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-21 04:22:23 | Evans, Georgia, US | |
2022-10-19 | US | Georgia | Evans | 13109 | 2734 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-10-20 04:22:59 | Evans, Georgia, US | |
2022-10-05 | US | Virginia | Poquoson | 51735 | 2734 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-10-06 04:21:22 | Poquoson, Virginia, US | |
2022-10-04 | US | Virginia | Poquoson | 51735 | 2734 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-10-05 04:23:06 | Poquoson, Virginia, US | |
2022-09-27 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-28 04:23:01 | McIntosh, Georgia, US | |
2022-09-26 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-27 04:23:01 | McIntosh, Georgia, US | |
2022-09-25 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-26 04:20:52 | McIntosh, Georgia, US | |
2022-09-24 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-25 04:23:31 | McIntosh, Georgia, US | |
2022-09-23 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-24 04:21:40 | McIntosh, Georgia, US | |
2022-09-22 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-23 04:23:13 | McIntosh, Georgia, US | |
2022-09-21 | US | Georgia | McIntosh | 13191 | 2734 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-09-22 04:22:56 | McIntosh, Georgia, US | |
2022-09-07 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-08 04:21:02 | Major, Oklahoma, US | |
2022-09-06 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-07 04:20:59 | Major, Oklahoma, US | |
2022-09-06 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-07 04:20:59 | Marshall, Kansas, US | |
2022-09-05 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-06 04:21:02 | Major, Oklahoma, US | |
2022-09-05 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-06 04:21:02 | Marshall, Kansas, US | |
2022-09-04 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-05 04:21:01 | Major, Oklahoma, US | |
2022-09-04 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-05 04:21:01 | Marshall, Kansas, US | |
2022-09-03 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-04 04:21:22 | Major, Oklahoma, US | |
2022-09-03 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-04 04:21:22 | Marshall, Kansas, US | |
2022-09-02 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-03 04:21:04 | Major, Oklahoma, US | |
2022-09-02 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-03 04:21:04 | Marshall, Kansas, US | |
2022-09-01 | US | Oklahoma | Major | 40093 | 2734 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-02 04:21:07 | Major, Oklahoma, US | |
2022-09-01 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-02 04:21:07 | Marshall, Kansas, US | |
2022-08-31 | US | Kansas | Marshall | 20117 | 2734 | 45 | 0 | 39.78359669 | -96.52278974 | 2022-09-01 04:21:03 | Marshall, Kansas, US | |
2022-08-22 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-23 04:20:56 | Mackinac, Michigan, US | |
2022-08-21 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-22 04:20:38 | Mackinac, Michigan, US | |
2022-08-20 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-21 04:20:44 | Mackinac, Michigan, US | |
2022-08-19 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-20 04:21:01 | Mackinac, Michigan, US | |
2022-08-18 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-19 04:20:54 | Mackinac, Michigan, US | |
2022-08-17 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-18 04:21:11 | Mackinac, Michigan, US | |
2022-08-16 | US | Michigan | Mackinac | 26097 | 2734 | 32 | 0 | 46.07028979 | -85.04980537 | 2022-08-17 04:20:59 | Mackinac, Michigan, US | |
2022-08-11 | US | Texas | Morris | 48343 | 2734 | 74 | 0 | 33.11304005 | -94.73255695 | 2022-08-12 04:20:54 | Morris, Texas, US | |
2022-08-10 | US | Arkansas | Perry | 5105 | 2734 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-08-11 04:20:49 | Perry, Arkansas, US | |
2022-08-10 | China | Sichuan | 2734 | 3 | 0 | 30.6171 | 102.7103 | 2022-08-11 04:20:49 | Sichuan, China | |||
2022-07-31 | US | North Dakota | Mercer | 38057 | 2734 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-08-01 04:21:03 | Mercer, North Dakota, US | |
2022-07-30 | US | North Dakota | Mercer | 38057 | 2734 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-31 04:21:02 | Mercer, North Dakota, US | |
2022-07-19 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-20 04:20:59 | Calhoun, Iowa, US | |
2022-07-18 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-19 04:20:58 | Calhoun, Iowa, US | |
2022-07-18 | US | Indiana | Brown | 18013 | 2734 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-07-19 04:20:58 | Brown, Indiana, US | |
2022-07-17 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-18 04:20:59 | Calhoun, Iowa, US | |
2022-07-16 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-17 04:21:15 | Calhoun, Iowa, US | |
2022-07-15 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-16 04:21:05 | Calhoun, Iowa, US | |
2022-07-14 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-15 04:20:53 | Calhoun, Iowa, US | |
2022-07-13 | US | Virginia | Charlotte | 51037 | 2734 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-07-14 04:20:57 | Charlotte, Virginia, US | |
2022-07-13 | US | Iowa | Calhoun | 19025 | 2734 | 25 | 0 | 42.38521079 | -94.64046046 | 2022-07-14 04:20:57 | Calhoun, Iowa, US | |
2022-07-13 | US | Alabama | Sumter | 1119 | 2734 | 52 | 0 | 32.59117397 | -88.19916205 | 2022-07-14 04:20:57 | Sumter, Alabama, US | |
2022-07-10 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-11 04:20:46 | McLean, Kentucky, US | |
2022-07-09 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-10 04:20:54 | McLean, Kentucky, US | |
2022-07-08 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-09 04:20:59 | McLean, Kentucky, US | |
2022-07-07 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-08 04:20:56 | McLean, Kentucky, US | |
2022-07-06 | US | Texas | Blanco | 48031 | 2734 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-07 04:20:55 | Blanco, Texas, US | |
2022-07-06 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-07 04:20:55 | McLean, Kentucky, US | |
2022-07-05 | US | Kentucky | McLean | 21149 | 2734 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-07-06 04:20:58 | McLean, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;