daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 14597 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 26
- Russia 2
- Congo (Kinshasa) 1
- Netherlands 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | California | Lake | 6033 | 14597 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-30 04:21:04 | Lake, California, US | |
2022-12-28 | US | California | Lake | 6033 | 14597 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-29 04:21:01 | Lake, California, US | |
2022-12-27 | US | California | Lake | 6033 | 14597 | 149 | 0 | 39.10124298 | -122.7536244 | 2022-12-28 04:21:04 | Lake, California, US | |
2022-12-15 | US | New York | Montgomery | 36057 | 14597 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-16 04:21:01 | Montgomery, New York, US | |
2022-11-15 | US | Virginia | Harrisonburg | 51660 | 14597 | 173 | 0 | 38.43542574 | -78.87536254 | 2022-11-16 04:21:09 | Harrisonburg, Virginia, US | |
2022-06-25 | US | Tennessee | Lawrence | 47099 | 14597 | 205 | 0 | 35.21675201 | -87.39787695 | 2022-06-26 04:21:02 | Lawrence, Tennessee, US | |
2022-06-21 | US | Louisiana | St. Charles | 22089 | 14597 | 144 | 0 | 29.90709658 | -90.35555967 | 2022-06-22 04:20:54 | St. Charles, Louisiana, US | |
2022-06-02 | US | New York | Madison | 36053 | 14597 | 128 | 0 | 42.91653905 | -75.67266639 | 2022-06-03 04:20:58 | Madison, New York, US | |
2022-04-24 | US | Tennessee | Loudon | 47105 | 14597 | 192 | 0 | 35.73939663 | -84.31145275 | 2022-04-25 04:20:56 | Loudon, Tennessee, US | |
2022-03-24 | US | North Carolina | Hoke | 37093 | 14597 | 103 | 0 | 35.01888303 | -79.23651674 | 2022-03-25 04:20:46 | Hoke, North Carolina, US | |
2022-01-25 | US | New York | Cayuga | 36011 | 14597 | 131 | 0 | 42.91261714 | -76.55731592 | 2022-01-26 04:21:07 | Cayuga, New York, US | |
2022-01-23 | US | Georgia | Spalding | 13255 | 14597 | 353 | 0 | 33.26310031 | -84.28013991 | 2022-01-24 04:21:12 | Spalding, Georgia, US | |
2022-01-22 | US | Georgia | Spalding | 13255 | 14597 | 353 | 0 | 33.26310031 | -84.28013991 | 2022-01-23 04:21:13 | Spalding, Georgia, US | |
2022-01-21 | US | Georgia | Spalding | 13255 | 14597 | 353 | 0 | 33.26310031 | -84.28013991 | 2022-01-22 04:21:13 | Spalding, Georgia, US | |
2021-11-05 | US | Maryland | Charles | 24017 | 14597 | 261 | 0 | 38.51092331 | -76.98580666 | 2021-11-06 04:21:51 | Charles, Maryland, US | |
2021-10-25 | US | Mississippi | Madison | 28089 | 14597 | 280 | 0 | 32.63389156 | -90.03513564 | 2021-10-26 04:22:09 | Madison, Mississippi, US | |
2021-10-13 | US | North Carolina | Lincoln | 37109 | 14597 | 107 | 0 | 35.48508185 | -81.21740317 | 2021-10-14 04:21:29 | Lincoln, North Carolina, US | |
2021-06-08 | US | Iowa | Johnson | 19103 | 14597 | 85 | 0 | 41.67169354 | -91.58754744 | 2021-06-09 04:23:31 | Johnson, Iowa, US | |
2021-05-21 | Russia | Adygea Republic | 14597 | 197 | 14052 | 348 | 44.6939006 | 40.1520421 | 2021-05-22 04:20:45 | Adygea Republic, Russia | ||
2021-05-20 | US | Pennsylvania | Cambria | 42021 | 14597 | 430 | 0 | 40.49527404 | -78.71377428 | 2021-05-21 04:20:43 | Cambria, Pennsylvania, US | |
2021-05-05 | US | Wisconsin | Sheboygan | 55117 | 14597 | 151 | 0 | 43.72099677 | -87.94579284 | 2021-05-06 04:20:38 | Sheboygan, Wisconsin, US | |
2021-04-29 | US | Colorado | Mesa | 8077 | 14597 | 223 | 0 | 39.01787888 | -108.469799 | 2021-04-30 04:21:03 | Mesa, Colorado, US | |
2021-04-12 | US | Texas | Guadalupe | 48187 | 14597 | 208 | 0 | 29.58165339 | -97.94786822 | 2021-04-13 04:20:37 | Guadalupe, Texas, US | |
2021-04-11 | US | Texas | Guadalupe | 48187 | 14597 | 208 | 0 | 29.58165339 | -97.94786822 | 2021-04-12 04:21:00 | Guadalupe, Texas, US | |
2021-04-10 | US | Texas | Guadalupe | 48187 | 14597 | 208 | 0 | 29.58165339 | -97.94786822 | 2021-04-11 04:20:56 | Guadalupe, Texas, US | |
2021-02-17 | Ukraine | Luhansk Oblast | 14597 | 435 | 12908 | 1254 | 48.574 | 39.3078 | 2021-02-18 05:22:58 | Luhansk Oblast, Ukraine | ||
2021-02-03 | Netherlands | Zeeland | 14597 | 159 | 0 | 14431 | 51.47936 | 3.861559 | 2021-02-04 05:22:26 | Zeeland, Netherlands | ||
2021-02-02 | US | Arizona | Navajo | 4017 | 14597 | 437 | 0 | 14160 | 35.3997715 | -110.3218983 | 2021-02-03 05:22:52 | Navajo, Arizona, US |
2021-01-23 | US | North Carolina | Pitt | 37147 | 14597 | 69 | 0 | 14528 | 35.59535426 | -77.37353178 | 2021-01-24 05:22:35 | Pitt, North Carolina, US |
2020-12-15 | Congo (Kinshasa) | 14597 | 358 | 12773 | 1466 | -4.0383 | 21.7587 | 2020-12-16 05:28:04 | Congo (Kinshasa) | |||
2020-10-14 | Russia | Dagestan Republic | 14597 | 696 | 12782 | 1119 | 43.05749160000001 | 47.1332224 | 2020-10-15 04:24:28 | Dagestan Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;