daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
234 rows where confirmed = 2752 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-06 | US | Virginia | Northampton | 51131 | 2752 | 73 | 0 | 37.34062933 | -75.87751591 | 2022-12-07 04:20:58 | Northampton, Virginia, US | |
2022-11-26 | US | Arkansas | Scott | 5127 | 2752 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-11-27 04:21:05 | Scott, Arkansas, US | |
2022-11-25 | US | Arkansas | Scott | 5127 | 2752 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-11-26 04:21:11 | Scott, Arkansas, US | |
2022-11-22 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-23 04:21:06 | Doniphan, Kansas, US | |
2022-11-21 | US | Virginia | Sussex | 51183 | 2752 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-11-22 04:20:47 | Sussex, Virginia, US | |
2022-11-21 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-22 04:20:47 | Doniphan, Kansas, US | |
2022-11-20 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-21 04:21:05 | Doniphan, Kansas, US | |
2022-11-19 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-20 04:21:08 | Doniphan, Kansas, US | |
2022-11-18 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-19 04:21:14 | Doniphan, Kansas, US | |
2022-11-17 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-18 04:21:15 | Doniphan, Kansas, US | |
2022-11-16 | US | Kansas | Doniphan | 20043 | 2752 | 39 | 0 | 39.79067154 | -95.14056866 | 2022-11-17 04:21:11 | Doniphan, Kansas, US | |
2022-10-11 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-12 04:22:51 | Graham, North Carolina, US | |
2022-10-10 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-11 04:23:05 | Graham, North Carolina, US | |
2022-10-09 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-10 04:22:32 | Graham, North Carolina, US | |
2022-10-08 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-09 04:21:16 | Graham, North Carolina, US | |
2022-10-07 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-08 04:22:56 | Graham, North Carolina, US | |
2022-10-06 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-07 04:23:08 | Graham, North Carolina, US | |
2022-10-05 | US | North Carolina | Graham | 37075 | 2752 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-10-06 04:21:22 | Graham, North Carolina, US | |
2022-08-15 | US | Arkansas | Pike | 5109 | 2752 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-08-16 04:20:58 | Pike, Arkansas, US | |
2022-08-14 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-15 04:20:59 | Hancock, Kentucky, US | |
2022-08-14 | US | Arkansas | Pike | 5109 | 2752 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-08-15 04:20:59 | Pike, Arkansas, US | |
2022-08-13 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-14 04:20:55 | Hancock, Kentucky, US | |
2022-08-13 | US | Arkansas | Pike | 5109 | 2752 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-08-14 04:20:55 | Pike, Arkansas, US | |
2022-08-12 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-13 04:20:52 | Hancock, Kentucky, US | |
2022-08-11 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-12 04:20:54 | Douglas, Missouri, US | |
2022-08-11 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-12 04:20:54 | Hancock, Kentucky, US | |
2022-08-10 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-11 04:20:49 | Douglas, Missouri, US | |
2022-08-10 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-11 04:20:49 | Hancock, Kentucky, US | |
2022-08-09 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-10 04:20:57 | Douglas, Missouri, US | |
2022-08-09 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-10 04:20:57 | Hancock, Kentucky, US | |
2022-08-08 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-09 04:20:34 | Douglas, Missouri, US | |
2022-08-08 | US | Kentucky | Hancock | 21091 | 2752 | 26 | 0 | 37.83766422 | -86.78280584 | 2022-08-09 04:20:34 | Hancock, Kentucky, US | |
2022-08-07 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-08 04:21:08 | Douglas, Missouri, US | |
2022-08-06 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-07 04:20:54 | Douglas, Missouri, US | |
2022-08-05 | US | Missouri | Douglas | 29067 | 2752 | 83 | 0 | 36.9325593 | -92.49905109 | 2022-08-06 04:20:56 | Douglas, Missouri, US | |
2022-07-26 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-27 04:21:04 | Humboldt, Iowa, US | |
2022-07-25 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-26 04:20:58 | Humboldt, Iowa, US | |
2022-07-24 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-25 04:20:51 | Wolfe, Kentucky, US | |
2022-07-24 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-25 04:20:51 | Humboldt, Iowa, US | |
2022-07-23 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-24 04:20:47 | Wolfe, Kentucky, US | |
2022-07-23 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-24 04:20:47 | Humboldt, Iowa, US | |
2022-07-22 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-23 04:20:53 | Wolfe, Kentucky, US | |
2022-07-22 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-23 04:20:53 | Humboldt, Iowa, US | |
2022-07-21 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-22 04:21:15 | Wolfe, Kentucky, US | |
2022-07-21 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-22 04:21:15 | Humboldt, Iowa, US | |
2022-07-20 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-21 04:21:10 | Wolfe, Kentucky, US | |
2022-07-20 | US | Iowa | Humboldt | 19091 | 2752 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-21 04:21:10 | Humboldt, Iowa, US | |
2022-07-19 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-20 04:20:59 | Wolfe, Kentucky, US | |
2022-07-18 | US | Virginia | Lunenburg | 51111 | 2752 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-07-19 04:20:58 | Lunenburg, Virginia, US | |
2022-07-18 | US | Kentucky | Wolfe | 21237 | 2752 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-19 04:20:58 | Wolfe, Kentucky, US | |
2022-07-11 | US | Tennessee | Houston | 47083 | 2752 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-12 04:20:51 | Houston, Tennessee, US | |
2022-07-09 | US | Texas | Blanco | 48031 | 2752 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-10 04:20:54 | Blanco, Texas, US | |
2022-07-07 | US | Virginia | Galax | 51640 | 2752 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-07-08 04:20:56 | Galax, Virginia, US | |
2022-06-29 | US | Arkansas | Fulton | 5049 | 2752 | 93 | 0 | 36.38177105 | -91.81729127 | 2022-06-30 04:21:01 | Fulton, Arkansas, US | |
2022-06-21 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-22 04:20:54 | Stewart, Georgia, US | |
2022-06-20 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-21 04:20:56 | Stewart, Georgia, US | |
2022-06-19 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-20 04:21:01 | Stewart, Georgia, US | |
2022-06-18 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-19 04:20:51 | Stewart, Georgia, US | |
2022-06-17 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-18 04:21:10 | Stewart, Georgia, US | |
2022-06-16 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-17 04:20:56 | Stewart, Georgia, US | |
2022-06-15 | US | Georgia | Stewart | 13259 | 2752 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-16 04:20:55 | Stewart, Georgia, US | |
2022-05-26 | US | Idaho | Shoshone | 16079 | 2752 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-27 04:20:56 | Shoshone, Idaho, US | |
2022-05-25 | US | Idaho | Shoshone | 16079 | 2752 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-26 04:20:50 | Shoshone, Idaho, US | |
2022-05-22 | US | Idaho | Shoshone | 16079 | 2752 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-26 04:20:50 | Shoshone, Idaho, US | |
2022-03-20 | US | Illinois | Marshall | 17123 | 2752 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-03-21 04:20:50 | Marshall, Illinois, US | |
2022-03-19 | US | Illinois | Marshall | 17123 | 2752 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-03-20 04:20:45 | Marshall, Illinois, US | |
2022-03-18 | US | Illinois | Marshall | 17123 | 2752 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-03-19 04:20:47 | Marshall, Illinois, US | |
2022-03-03 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-04 04:21:09 | Guainia, Colombia | |||
2022-03-02 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-03 04:21:01 | Guainia, Colombia | |||
2022-03-01 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-02 04:21:07 | Guainia, Colombia | |||
2022-02-28 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-01 04:21:09 | Guainia, Colombia | |||
2022-02-27 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-02-28 04:21:05 | Guainia, Colombia | |||
2022-02-26 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-02-27 04:21:04 | Guainia, Colombia | |||
2022-02-25 | Colombia | Guainia | 2752 | 37 | 0 | 2.5854 | -68.5247 | 2022-02-26 04:21:12 | Guainia, Colombia | |||
2022-02-16 | US | Idaho | Gooding | 16047 | 2752 | 52 | 0 | 42.96927962 | -114.81083059999999 | 2022-02-17 04:20:56 | Gooding, Idaho, US | |
2022-02-06 | US | Kentucky | Todd | 21219 | 2752 | 40 | 0 | 36.8381152 | -87.17878374 | 2022-02-07 04:21:05 | Todd, Kentucky, US | |
2022-02-05 | US | Kentucky | Todd | 21219 | 2752 | 40 | 0 | 36.8381152 | -87.17878374 | 2022-02-06 04:21:00 | Todd, Kentucky, US | |
2022-02-04 | US | Kentucky | Todd | 21219 | 2752 | 40 | 0 | 36.8381152 | -87.17878374 | 2022-02-05 04:21:05 | Todd, Kentucky, US | |
2022-01-17 | US | Vermont | Lamoille | 50015 | 2752 | 12 | 0 | 44.60353043 | -72.64356694 | 2022-01-18 04:21:04 | Lamoille, Vermont, US | |
2022-01-16 | US | Vermont | Lamoille | 50015 | 2752 | 12 | 0 | 44.60353043 | -72.64356694 | 2022-01-17 04:21:08 | Lamoille, Vermont, US | |
2022-01-11 | US | Kentucky | Butler | 21031 | 2752 | 44 | 0 | 37.20946153 | -86.68748787 | 2022-01-12 04:21:44 | Butler, Kentucky, US | |
2022-01-10 | US | North Dakota | Ramsey | 38071 | 2752 | 46 | 0 | 48.26886249 | -98.72223879 | 2022-01-11 04:22:01 | Ramsey, North Dakota, US | |
2022-01-10 | US | Illinois | Washington | 17189 | 2752 | 31 | 0 | 38.35309213 | -89.40982703 | 2022-01-11 04:22:01 | Washington, Illinois, US | |
2021-12-10 | US | Arkansas | Madison | 5087 | 2752 | 42 | 0 | 36.01038185 | -93.72524943 | 2021-12-11 04:22:45 | Madison, Arkansas, US | |
2021-12-01 | US | Kentucky | Mason | 21161 | 2752 | 73 | 0 | 38.59471935 | -83.82151043 | 2021-12-02 04:22:37 | Mason, Kentucky, US | |
2021-11-30 | US | Missouri | Benton | 29015 | 2752 | 47 | 0 | 38.29503305 | -93.28756116 | 2021-12-01 04:22:29 | Benton, Missouri, US | |
2021-11-20 | Russia | Chukotka Autonomous Okrug | 2752 | 23 | 0 | 66.0006475 | 169.4900869 | 2021-11-21 04:22:13 | Chukotka Autonomous Okrug, Russia | |||
2021-11-15 | US | Puerto Rico | Gurabo | 72063 | 2752 | 0 | 0 | 18.266461 | -65.97970500000001 | 2021-11-16 04:21:10 | Gurabo, Puerto Rico, US | |
2021-11-13 | US | Puerto Rico | Dorado | 72051 | 2752 | 0 | 0 | 18.436115 | -66.278669 | 2021-11-14 04:21:31 | Dorado, Puerto Rico, US | |
2021-11-13 | US | Indiana | Franklin | 18047 | 2752 | 44 | 0 | 39.4142482 | -85.06062647 | 2021-11-14 04:21:31 | Franklin, Indiana, US | |
2021-11-12 | US | Puerto Rico | Dorado | 72051 | 2752 | 0 | 0 | 18.436115 | -66.278669 | 2021-11-13 04:21:38 | Dorado, Puerto Rico, US | |
2021-11-08 | US | Virginia | Fluvanna | 51065 | 2752 | 25 | 0 | 37.84157909 | -78.27715475 | 2021-11-09 04:21:36 | Fluvanna, Virginia, US | |
2021-11-06 | US | Hawaii | Out of HI | 80015 | 2752 | 9 | 0 | 22.03935037 | 0.0 | 2021-11-07 04:21:53 | Out of HI, Hawaii, US | |
2021-10-29 | US | Colorado | Otero | 8089 | 2752 | 86 | 0 | 37.9014485 | -103.7173385 | 2021-10-30 04:22:03 | Otero, Colorado, US | |
2021-10-28 | US | Wyoming | Lincoln | 56023 | 2752 | 20 | 0 | 42.26376367 | -110.6563997 | 2021-10-29 04:22:03 | Lincoln, Wyoming, US | |
2021-10-21 | US | Texas | Llano | 48299 | 2752 | 71 | 0 | 30.70645047 | -98.68475262 | 2021-10-22 04:21:14 | Llano, Texas, US | |
2021-10-10 | US | Tennessee | Grundy | 47061 | 2752 | 37 | 0 | 35.38433717 | -85.72142731 | 2021-10-11 04:21:31 | Grundy, Tennessee, US | |
2021-10-09 | US | Tennessee | Cannon | 47015 | 2752 | 39 | 0 | 35.80990797 | -86.05738983 | 2021-10-10 04:21:38 | Cannon, Tennessee, US | |
2021-10-06 | US | Illinois | Richland | 17159 | 2752 | 56 | 0 | 38.71240969 | -88.08475366 | 2021-10-07 04:21:36 | Richland, Illinois, US | |
2021-10-04 | US | Texas | Leon | 48289 | 2752 | 61 | 0 | 31.29872538 | -95.9936328 | 2021-10-05 04:21:27 | Leon, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;