daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
250 rows where confirmed = 2803 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 234
- Japan 3
- New Zealand 2
- Russia 2
- Canada 1
- Chile 1
- Gabon 1
- Italy 1
- Liechtenstein 1
- Niger 1
- Peru 1
- Sierra Leone 1
- Sweden 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Kansas | Doniphan | 20043 | 2803 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-12-30 04:21:04 | Doniphan, Kansas, US | |
2022-12-28 | US | Kansas | Doniphan | 20043 | 2803 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-12-29 04:21:01 | Doniphan, Kansas, US | |
2022-12-07 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-08 04:21:07 | Blaine, Oklahoma, US | |
2022-12-06 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-07 04:20:58 | Blaine, Oklahoma, US | |
2022-12-05 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-06 04:21:03 | Blaine, Oklahoma, US | |
2022-12-04 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-05 04:20:58 | Blaine, Oklahoma, US | |
2022-12-03 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-04 04:20:56 | Blaine, Oklahoma, US | |
2022-12-02 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-03 04:21:02 | Blaine, Oklahoma, US | |
2022-12-01 | US | Oklahoma | Blaine | 40011 | 2803 | 50 | 0 | 35.87518314 | -98.43307003 | 2022-12-02 04:21:07 | Blaine, Oklahoma, US | |
2022-11-30 | US | Virginia | Poquoson | 51735 | 2803 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-01 04:21:03 | Poquoson, Virginia, US | |
2022-11-29 | US | Virginia | Poquoson | 51735 | 2803 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-11-30 04:21:07 | Poquoson, Virginia, US | |
2022-10-11 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-12 04:22:51 | Franklin, Iowa, US | |
2022-10-10 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-11 04:23:05 | Franklin, Iowa, US | |
2022-10-09 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-10 04:22:32 | Franklin, Iowa, US | |
2022-10-08 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-09 04:21:16 | Franklin, Iowa, US | |
2022-10-07 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-08 04:22:56 | Franklin, Iowa, US | |
2022-10-06 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-07 04:23:08 | Franklin, Iowa, US | |
2022-10-05 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-06 04:21:22 | Major, Oklahoma, US | |
2022-10-05 | US | Iowa | Franklin | 19069 | 2803 | 47 | 0 | 42.73270384 | -93.26256925 | 2022-10-06 04:21:22 | Franklin, Iowa, US | |
2022-10-04 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-05 04:23:06 | Major, Oklahoma, US | |
2022-10-03 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-04 04:22:55 | Major, Oklahoma, US | |
2022-10-02 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-03 04:23:11 | Major, Oklahoma, US | |
2022-10-01 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-02 04:21:23 | Major, Oklahoma, US | |
2022-09-30 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-10-01 04:23:01 | Major, Oklahoma, US | |
2022-09-29 | US | Oklahoma | Major | 40093 | 2803 | 42 | 0 | 36.31149996 | -98.53467076 | 2022-09-30 04:23:09 | Major, Oklahoma, US | |
2022-09-29 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-30 04:23:09 | Fergus, Montana, US | |
2022-09-28 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-29 04:22:34 | Fergus, Montana, US | |
2022-09-27 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-28 04:23:01 | Fergus, Montana, US | |
2022-09-26 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-27 04:23:01 | Fergus, Montana, US | |
2022-09-25 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-26 04:20:52 | Fergus, Montana, US | |
2022-09-24 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-25 04:23:31 | Fergus, Montana, US | |
2022-09-23 | US | Montana | Fergus | 30027 | 2803 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-09-24 04:21:40 | Fergus, Montana, US | |
2022-09-21 | US | Colorado | Bent | 8011 | 2803 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-22 04:22:56 | Bent, Colorado, US | |
2022-09-11 | US | Texas | Childress | 48075 | 2803 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-09-12 04:20:58 | Childress, Texas, US | |
2022-09-10 | US | Texas | Childress | 48075 | 2803 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-09-11 04:20:50 | Childress, Texas, US | |
2022-09-09 | US | Texas | Childress | 48075 | 2803 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-09-10 04:21:10 | Childress, Texas, US | |
2022-09-02 | US | Connecticut | Unassigned | 90009 | 2803 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-03 04:21:04 | Unassigned, Connecticut, US | |
2022-09-01 | US | Connecticut | Unassigned | 90009 | 2803 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-02 04:21:07 | Unassigned, Connecticut, US | |
2022-08-31 | US | Virginia | Madison | 51113 | 2803 | 43 | 0 | 38.41531222 | -78.28220331 | 2022-09-01 04:21:03 | Madison, Virginia, US | |
2022-08-11 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-12 04:20:54 | Rosebud, Montana, US | |
2022-08-10 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-11 04:20:49 | Rosebud, Montana, US | |
2022-08-09 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-10 04:20:57 | Rosebud, Montana, US | |
2022-08-08 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-09 04:20:34 | Rosebud, Montana, US | |
2022-08-07 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-08 04:21:08 | Rosebud, Montana, US | |
2022-08-06 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-07 04:20:54 | Rosebud, Montana, US | |
2022-08-05 | US | Montana | Rosebud | 30087 | 2803 | 61 | 0 | 46.23397237 | -106.729288 | 2022-08-06 04:20:56 | Rosebud, Montana, US | |
2022-07-21 | US | Virginia | Floyd | 51063 | 2803 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-07-22 04:21:15 | Floyd, Virginia, US | |
2022-07-12 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-13 04:20:58 | Union, Iowa, US | |
2022-07-11 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-12 04:20:51 | Union, Iowa, US | |
2022-07-10 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-11 04:20:46 | Union, Iowa, US | |
2022-07-09 | US | North Dakota | McLean | 38055 | 2803 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-07-10 04:20:54 | McLean, North Dakota, US | |
2022-07-09 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-10 04:20:54 | Union, Iowa, US | |
2022-07-08 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-09 04:20:59 | Union, Iowa, US | |
2022-07-07 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-08 04:20:56 | Union, Iowa, US | |
2022-07-06 | US | Iowa | Union | 19175 | 2803 | 52 | 0 | 41.0277278 | -94.24234847 | 2022-07-07 04:20:55 | Union, Iowa, US | |
2022-06-24 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-25 04:20:57 | Terry, Texas, US | |
2022-06-23 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-24 04:20:58 | Terry, Texas, US | |
2022-06-22 | US | Virginia | Amelia | 51007 | 2803 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-06-23 04:20:55 | Amelia, Virginia, US | |
2022-06-22 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-23 04:20:55 | Terry, Texas, US | |
2022-06-21 | US | Virginia | Amelia | 51007 | 2803 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-06-22 04:20:54 | Amelia, Virginia, US | |
2022-06-21 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-22 04:20:54 | Terry, Texas, US | |
2022-06-20 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-21 04:20:56 | Terry, Texas, US | |
2022-06-19 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-20 04:21:01 | Terry, Texas, US | |
2022-06-18 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-19 04:20:51 | Terry, Texas, US | |
2022-06-17 | US | Texas | Terry | 48445 | 2803 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-06-18 04:21:10 | Terry, Texas, US | |
2022-06-01 | US | Puerto Rico | Hormigueros | 72067 | 2803 | 0 | 0 | 18.134532 | -67.113972 | 2022-06-02 05:20:39 | Hormigueros, Puerto Rico, US | |
2022-05-17 | US | Puerto Rico | Luquillo | 72089 | 2803 | 0 | 0 | 18.342114 | -65.725097 | 2022-05-18 04:20:50 | Luquillo, Puerto Rico, US | |
2022-05-16 | US | Puerto Rico | Luquillo | 72089 | 2803 | 0 | 0 | 18.342114 | -65.725097 | 2022-05-17 04:20:59 | Luquillo, Puerto Rico, US | |
2022-05-10 | US | Illinois | Marshall | 17123 | 2803 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-05-11 04:20:48 | Marshall, Illinois, US | |
2022-05-07 | Peru | Unknown | 2803 | 68 | 0 | 2022-05-08 04:20:49 | Unknown, Peru | |||||
2022-04-04 | US | Texas | Eastland | 48133 | 2803 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-04-05 04:20:48 | Eastland, Texas, US | |
2022-04-03 | US | Texas | Eastland | 48133 | 2803 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-04-04 04:20:51 | Eastland, Texas, US | |
2022-04-02 | US | Texas | Eastland | 48133 | 2803 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-04-03 04:20:48 | Eastland, Texas, US | |
2022-04-01 | US | Texas | Eastland | 48133 | 2803 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-04-02 04:20:47 | Eastland, Texas, US | |
2022-03-09 | US | Missouri | Barton | 29011 | 2803 | 50 | 0 | 37.50207671 | -94.34757022 | 2022-03-10 04:20:48 | Barton, Missouri, US | |
2022-03-08 | US | Missouri | Barton | 29011 | 2803 | 50 | 0 | 37.50207671 | -94.34757022 | 2022-03-09 04:20:59 | Barton, Missouri, US | |
2022-03-06 | US | Texas | Ward | 48475 | 2803 | 43 | 0 | 31.50999644 | -103.09279090000001 | 2022-03-07 04:20:47 | Ward, Texas, US | |
2022-03-05 | US | Texas | Ward | 48475 | 2803 | 43 | 0 | 31.50999644 | -103.09279090000001 | 2022-03-06 04:20:49 | Ward, Texas, US | |
2022-02-10 | US | Mississippi | Jefferson Davis | 28065 | 2803 | 47 | 0 | 31.56884708 | -89.82670990000004 | 2022-02-11 04:21:09 | Jefferson Davis, Mississippi, US | |
2022-02-09 | US | Puerto Rico | Salinas | 72123 | 2803 | 0 | 0 | 18.010386999999994 | -66.256592 | 2022-02-10 04:21:14 | Salinas, Puerto Rico, US | |
2022-02-08 | US | Alabama | Conecuh | 1035 | 2803 | 63 | 0 | 31.43401703 | -86.99320044 | 2022-02-09 04:21:04 | Conecuh, Alabama, US | |
2022-01-31 | US | Montana | Custer | 30017 | 2803 | 44 | 0 | 46.25319932 | -105.57375259999998 | 2022-02-01 04:21:11 | Custer, Montana, US | |
2022-01-25 | US | Georgia | Dade | 13083 | 2803 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-01-26 04:21:07 | Dade, Georgia, US | |
2022-01-20 | US | Puerto Rico | Anasco | 72011 | 2803 | 0 | 0 | 18.287985 | -67.120611 | 2022-01-21 04:21:09 | Anasco, Puerto Rico, US | |
2022-01-19 | US | Ohio | Morgan | 39115 | 2803 | 48 | 0 | 39.62081738 | -81.85308173 | 2022-01-20 04:21:07 | Morgan, Ohio, US | |
2022-01-17 | US | Kentucky | Green | 21087 | 2803 | 36 | 0 | 37.26484328 | -85.5540745 | 2022-01-18 04:21:04 | Green, Kentucky, US | |
2022-01-16 | US | Kentucky | Green | 21087 | 2803 | 36 | 0 | 37.26484328 | -85.5540745 | 2022-01-17 04:21:08 | Green, Kentucky, US | |
2022-01-15 | US | Kentucky | Green | 21087 | 2803 | 36 | 0 | 37.26484328 | -85.5540745 | 2022-01-16 04:21:12 | Green, Kentucky, US | |
2022-01-14 | US | Kentucky | Green | 21087 | 2803 | 36 | 0 | 37.26484328 | -85.5540745 | 2022-01-15 04:21:07 | Green, Kentucky, US | |
2022-01-03 | US | Minnesota | Sibley | 27143 | 2803 | 20 | 0 | 44.5796592 | -94.23164924 | 2022-01-04 04:22:17 | Sibley, Minnesota, US | |
2021-12-26 | US | Virginia | New Kent | 51127 | 2803 | 28 | 0 | 37.50694406 | -76.99828634 | 2021-12-27 04:21:58 | New Kent, Virginia, US | |
2021-12-25 | US | Virginia | New Kent | 51127 | 2803 | 28 | 0 | 37.50694406 | -76.99828634 | 2021-12-26 04:21:50 | New Kent, Virginia, US | |
2021-12-24 | US | Virginia | New Kent | 51127 | 2803 | 28 | 0 | 37.50694406 | -76.99828634 | 2021-12-25 04:21:37 | New Kent, Virginia, US | |
2021-12-22 | US | Illinois | De Witt | 17039 | 2803 | 32 | 0 | 40.17514519 | -88.90959682 | 2021-12-23 04:21:21 | De Witt, Illinois, US | |
2021-12-17 | US | Texas | Madison | 48313 | 2803 | 46 | 0 | 30.96694679 | -95.93003775 | 2021-12-18 02:22:20 | Madison, Texas, US | |
2021-12-12 | US | Illinois | Ford | 17053 | 2803 | 59 | 0 | 40.59706922 | -88.22350769 | 2021-12-13 04:22:02 | Ford, Illinois, US | |
2021-12-11 | US | Illinois | Ford | 17053 | 2803 | 59 | 0 | 40.59706922 | -88.22350769 | 2021-12-12 04:22:12 | Ford, Illinois, US | |
2021-12-10 | US | Illinois | Ford | 17053 | 2803 | 59 | 0 | 40.59706922 | -88.22350769 | 2021-12-11 04:22:45 | Ford, Illinois, US | |
2021-12-05 | US | Missouri | Moniteau | 29135 | 2803 | 46 | 0 | 38.63571781 | -92.57976951 | 2021-12-06 04:22:34 | Moniteau, Missouri, US | |
2021-11-29 | US | Arkansas | Clay | 5021 | 2803 | 74 | 0 | 36.36826212 | -90.4148172 | 2021-11-30 04:22:53 | Clay, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;