daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
255 rows where confirmed = 3056 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-20 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-21 04:21:03 | Valley, Idaho, US | |
2022-12-20 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-21 04:21:03 | Shoshone, Idaho, US | |
2022-12-19 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-20 04:21:04 | Valley, Idaho, US | |
2022-12-19 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-20 04:21:04 | Shoshone, Idaho, US | |
2022-12-18 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-19 04:21:03 | Valley, Idaho, US | |
2022-12-18 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-19 04:21:03 | Shoshone, Idaho, US | |
2022-12-18 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-19 04:21:03 | Fulton, Arkansas, US | |
2022-12-17 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-18 04:21:03 | Valley, Idaho, US | |
2022-12-17 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-18 04:21:03 | Shoshone, Idaho, US | |
2022-12-17 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-18 04:21:03 | Fulton, Arkansas, US | |
2022-12-16 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-17 04:21:04 | Valley, Idaho, US | |
2022-12-16 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-17 04:21:04 | Shoshone, Idaho, US | |
2022-12-16 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-17 04:21:04 | Fulton, Arkansas, US | |
2022-12-15 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-16 04:21:01 | Valley, Idaho, US | |
2022-12-15 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-16 04:21:01 | Shoshone, Idaho, US | |
2022-12-14 | US | Idaho | Valley | 16085 | 3056 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-15 04:20:58 | Valley, Idaho, US | |
2022-12-14 | US | Idaho | Shoshone | 16079 | 3056 | 80 | 0 | 47.35364087 | -115.8916749 | 2022-12-15 04:20:58 | Shoshone, Idaho, US | |
2022-12-14 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-15 04:20:58 | Fulton, Arkansas, US | |
2022-12-06 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-07 04:20:58 | Lyon, Iowa, US | |
2022-12-05 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-06 04:21:03 | Lyon, Iowa, US | |
2022-12-04 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-05 04:20:58 | Lyon, Iowa, US | |
2022-12-03 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-04 04:20:56 | Lyon, Iowa, US | |
2022-12-02 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-03 04:21:02 | Lyon, Iowa, US | |
2022-12-01 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-02 04:21:07 | Lyon, Iowa, US | |
2022-11-30 | US | Iowa | Lyon | 19119 | 3056 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-12-01 04:21:03 | Lyon, Iowa, US | |
2022-11-14 | US | Colorado | Prowers | 8099 | 3056 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-11-15 04:21:16 | Prowers, Colorado, US | |
2022-11-09 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-10 04:21:16 | Washita, Oklahoma, US | |
2022-11-08 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-09 04:21:22 | Washita, Oklahoma, US | |
2022-11-07 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-08 04:21:21 | Washita, Oklahoma, US | |
2022-11-06 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-07 04:21:26 | Washita, Oklahoma, US | |
2022-11-05 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-06 04:21:24 | Washita, Oklahoma, US | |
2022-11-04 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-05 04:21:52 | Washita, Oklahoma, US | |
2022-11-03 | US | Oklahoma | Washita | 40149 | 3056 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-11-04 04:22:11 | Washita, Oklahoma, US | |
2022-10-18 | US | Virginia | Nelson | 51125 | 3056 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-10-19 04:22:26 | Nelson, Virginia, US | |
2022-09-29 | US | Puerto Rico | Guanica | 72055 | 3056 | 0 | 0 | 17.982429 | -66.919643 | 2022-09-30 04:23:09 | Guanica, Puerto Rico, US | |
2022-09-28 | US | Virginia | Floyd | 51063 | 3056 | 50 | 0 | 36.9302126 | -80.36738849 | 2022-09-29 04:22:34 | Floyd, Virginia, US | |
2022-09-07 | US | New Mexico | Torrance | 35057 | 3056 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-09-08 04:21:02 | Torrance, New Mexico, US | |
2022-09-06 | US | New Mexico | Torrance | 35057 | 3056 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-09-07 04:20:59 | Torrance, New Mexico, US | |
2022-08-11 | US | Louisiana | West Feliciana | 22125 | 3056 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-12 04:20:54 | West Feliciana, Louisiana, US | |
2022-07-26 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-27 04:21:04 | Sitka, Alaska, US | |
2022-07-25 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-26 04:20:58 | Sitka, Alaska, US | |
2022-07-24 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-25 04:20:51 | Sitka, Alaska, US | |
2022-07-23 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-24 04:20:47 | Sitka, Alaska, US | |
2022-07-22 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-23 04:20:53 | Sitka, Alaska, US | |
2022-07-21 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-22 04:21:15 | Sitka, Alaska, US | |
2022-07-20 | US | Alaska | Sitka | 2220 | 3056 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-07-21 04:21:10 | Sitka, Alaska, US | |
2022-07-13 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-14 04:20:57 | Koochiching, Minnesota, US | |
2022-07-12 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-13 04:20:58 | Koochiching, Minnesota, US | |
2022-07-11 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-12 04:20:51 | Koochiching, Minnesota, US | |
2022-07-10 | US | New Jersey | Unassigned | 90034 | 3056 | 0 | 0 | 41.13891592 | 0.0 | 2022-07-11 04:20:46 | Unassigned, New Jersey, US | |
2022-07-10 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-11 04:20:46 | Koochiching, Minnesota, US | |
2022-07-09 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-10 04:20:54 | Koochiching, Minnesota, US | |
2022-07-08 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-09 04:20:59 | Koochiching, Minnesota, US | |
2022-07-07 | US | Minnesota | Koochiching | 27071 | 3056 | 38 | 0 | 48.24539665 | -93.78352843 | 2022-07-08 04:20:56 | Koochiching, Minnesota, US | |
2022-06-28 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-29 04:20:59 | Winnebago, Iowa, US | |
2022-06-27 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-28 04:20:58 | Winnebago, Iowa, US | |
2022-06-26 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-27 04:21:00 | Winnebago, Iowa, US | |
2022-06-25 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-26 04:21:02 | Winnebago, Iowa, US | |
2022-06-24 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-25 04:20:57 | Winnebago, Iowa, US | |
2022-06-23 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-24 04:20:58 | Winnebago, Iowa, US | |
2022-06-22 | US | Iowa | Winnebago | 19189 | 3056 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-06-23 04:20:55 | Winnebago, Iowa, US | |
2022-06-20 | US | Arkansas | Bradley | 5011 | 3056 | 51 | 0 | 33.46755808 | -92.15980837 | 2022-06-21 04:20:56 | Bradley, Arkansas, US | |
2022-06-13 | US | North Dakota | Barnes | 38003 | 3056 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-06-14 04:20:52 | Barnes, North Dakota, US | |
2022-06-08 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-09 04:20:54 | Noble, Oklahoma, US | |
2022-06-07 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-08 04:20:55 | Noble, Oklahoma, US | |
2022-06-06 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-07 04:21:08 | Noble, Oklahoma, US | |
2022-06-05 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-06 04:20:57 | Noble, Oklahoma, US | |
2022-06-05 | US | New Mexico | Los Alamos | 35028 | 3056 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-06-06 04:20:57 | Los Alamos, New Mexico, US | |
2022-06-05 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-06 04:20:57 | Perry, Mississippi, US | |
2022-06-04 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-05 04:20:55 | Noble, Oklahoma, US | |
2022-06-04 | US | New Mexico | Los Alamos | 35028 | 3056 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-06-05 04:20:55 | Los Alamos, New Mexico, US | |
2022-06-04 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-05 04:20:55 | Perry, Mississippi, US | |
2022-06-03 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-04 04:20:58 | Noble, Oklahoma, US | |
2022-06-03 | US | New Mexico | Los Alamos | 35028 | 3056 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-06-04 04:20:58 | Los Alamos, New Mexico, US | |
2022-06-03 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-04 04:20:58 | Perry, Mississippi, US | |
2022-06-02 | US | Oklahoma | Noble | 40103 | 3056 | 41 | 0 | 36.38953329 | -97.22928674 | 2022-06-03 04:20:58 | Noble, Oklahoma, US | |
2022-06-02 | US | New Mexico | Los Alamos | 35028 | 3056 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-06-03 04:20:58 | Los Alamos, New Mexico, US | |
2022-06-02 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-03 04:20:58 | Perry, Mississippi, US | |
2022-06-01 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-02 05:20:39 | Perry, Mississippi, US | |
2022-05-31 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-01 04:20:55 | Perry, Mississippi, US | |
2022-05-30 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-31 04:20:51 | Perry, Mississippi, US | |
2022-05-29 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-30 04:20:50 | Perry, Mississippi, US | |
2022-05-28 | US | Puerto Rico | Patillas | 72109 | 3056 | 0 | 0 | 18.03174 | -66.012242 | 2022-05-29 04:20:53 | Patillas, Puerto Rico, US | |
2022-05-28 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-29 04:20:53 | Perry, Mississippi, US | |
2022-05-27 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-28 04:21:07 | Perry, Mississippi, US | |
2022-05-26 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-27 04:20:56 | Perry, Mississippi, US | |
2022-05-25 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-26 04:20:50 | Perry, Mississippi, US | |
2022-05-24 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-25 04:20:56 | Perry, Mississippi, US | |
2022-05-23 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-24 04:20:57 | Perry, Mississippi, US | |
2022-05-22 | US | Mississippi | Perry | 28111 | 3056 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-05-26 04:20:50 | Perry, Mississippi, US | |
2022-05-17 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-18 04:20:50 | Washington, North Carolina, US | |
2022-05-16 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-17 04:20:59 | Washington, North Carolina, US | |
2022-05-15 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-16 04:20:47 | Washington, North Carolina, US | |
2022-05-14 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-15 04:20:53 | Washington, North Carolina, US | |
2022-05-13 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-14 04:20:48 | Washington, North Carolina, US | |
2022-05-12 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-13 04:20:51 | Washington, North Carolina, US | |
2022-05-11 | US | North Carolina | Washington | 37187 | 3056 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-12 04:20:54 | Washington, North Carolina, US | |
2022-05-03 | US | Minnesota | Pope | 27121 | 3056 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-05-04 04:20:59 | Pope, Minnesota, US | |
2022-04-28 | US | Montana | Custer | 30017 | 3056 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-04-29 04:20:59 | Custer, Montana, US | |
2022-04-27 | US | Montana | Custer | 30017 | 3056 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-04-28 04:20:47 | Custer, Montana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;