daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,632 rows where confirmed = 128 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-11-14 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-15 04:21:16 | Keya Paha, Nebraska, US | |
2022-11-13 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-14 04:21:09 | Keya Paha, Nebraska, US | |
2022-11-12 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-13 04:21:14 | Keya Paha, Nebraska, US | |
2022-11-11 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-12 04:20:41 | Keya Paha, Nebraska, US | |
2022-11-10 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-11 04:21:22 | Keya Paha, Nebraska, US | |
2022-11-09 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-10 04:21:16 | Keya Paha, Nebraska, US | |
2022-11-08 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-09 04:21:22 | Keya Paha, Nebraska, US | |
2022-11-07 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-08 04:21:21 | Keya Paha, Nebraska, US | |
2022-11-06 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-07 04:21:26 | Keya Paha, Nebraska, US | |
2022-11-05 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-06 04:21:24 | Keya Paha, Nebraska, US | |
2022-11-04 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-05 04:21:52 | Keya Paha, Nebraska, US | |
2022-11-03 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-04 04:22:11 | Keya Paha, Nebraska, US | |
2022-11-02 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-03 04:22:05 | Keya Paha, Nebraska, US | |
2022-11-01 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-02 04:22:09 | Keya Paha, Nebraska, US | |
2022-10-31 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-11-01 04:22:36 | Keya Paha, Nebraska, US | |
2022-10-30 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-10-31 04:21:36 | Keya Paha, Nebraska, US | |
2022-10-29 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-10-30 04:22:14 | Keya Paha, Nebraska, US | |
2022-10-28 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-10-29 04:21:13 | Keya Paha, Nebraska, US | |
2022-10-27 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-10-28 04:22:31 | Keya Paha, Nebraska, US | |
2022-10-26 | US | Nebraska | Keya Paha | 31103 | 128 | 0 | 0 | 42.87990694 | -99.71343729 | 2022-10-27 04:22:01 | Keya Paha, Nebraska, US | |
2022-08-29 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-30 04:21:03 | Wheeler, Nebraska, US | |
2022-08-28 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-29 04:21:06 | Wheeler, Nebraska, US | |
2022-08-27 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-28 04:21:02 | Wheeler, Nebraska, US | |
2022-08-26 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-27 04:20:57 | Wheeler, Nebraska, US | |
2022-08-25 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-26 04:21:02 | Wheeler, Nebraska, US | |
2022-08-24 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-25 04:21:13 | Wheeler, Nebraska, US | |
2022-08-23 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-24 04:20:46 | Wheeler, Nebraska, US | |
2022-08-22 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-23 04:20:56 | Wheeler, Nebraska, US | |
2022-08-21 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-22 04:20:38 | Wheeler, Nebraska, US | |
2022-08-20 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-21 04:20:44 | Wheeler, Nebraska, US | |
2022-08-19 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-20 04:21:01 | Wheeler, Nebraska, US | |
2022-08-18 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-19 04:20:54 | Wheeler, Nebraska, US | |
2022-08-17 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-18 04:21:11 | Wheeler, Nebraska, US | |
2022-08-16 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-17 04:20:59 | Wheeler, Nebraska, US | |
2022-08-15 | US | Nebraska | Wheeler | 31183 | 128 | 2 | 0 | 41.91482725 | -98.52798941 | 2022-08-16 04:20:58 | Wheeler, Nebraska, US | |
2022-07-18 | US | Texas | Terrell | 48443 | 128 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-07-19 04:20:58 | Terrell, Texas, US | |
2022-07-17 | US | Texas | Terrell | 48443 | 128 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-07-18 04:20:59 | Terrell, Texas, US | |
2022-07-16 | US | Texas | Terrell | 48443 | 128 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-07-17 04:21:15 | Terrell, Texas, US | |
2022-06-12 | US | Illinois | Unassigned | 90017 | 128 | 4385 | 0 | 42.36542373 | 0.0 | 2022-06-13 04:21:14 | Unassigned, Illinois, US | |
2022-06-11 | US | Illinois | Unassigned | 90017 | 128 | 4385 | 0 | 42.36542373 | 0.0 | 2022-06-12 04:20:53 | Unassigned, Illinois, US | |
2022-06-10 | US | Illinois | Unassigned | 90017 | 128 | 4385 | 0 | 42.36542373 | 0.0 | 2022-06-11 04:21:01 | Unassigned, Illinois, US | |
2022-04-10 | United Kingdom | Falkland Islands (Malvinas) | 128 | 0 | 0 | -51.7963 | -59.5236 | 2022-04-11 04:21:02 | Falkland Islands (Malvinas), United Kingdom | |||
2022-04-09 | United Kingdom | Falkland Islands (Malvinas) | 128 | 0 | 0 | -51.7963 | -59.5236 | 2022-04-10 04:20:52 | Falkland Islands (Malvinas), United Kingdom | |||
2022-04-08 | United Kingdom | Falkland Islands (Malvinas) | 128 | 0 | 0 | -51.7963 | -59.5236 | 2022-04-09 04:20:42 | Falkland Islands (Malvinas), United Kingdom | |||
2022-04-07 | United Kingdom | Falkland Islands (Malvinas) | 128 | 0 | 0 | -51.7963 | -59.5236 | 2022-04-08 04:20:48 | Falkland Islands (Malvinas), United Kingdom | |||
2022-04-06 | United Kingdom | Falkland Islands (Malvinas) | 128 | 0 | 0 | -51.7963 | -59.5236 | 2022-04-07 04:20:53 | Falkland Islands (Malvinas), United Kingdom | |||
2022-02-13 | US | Alaska | Skagway | 2230 | 128 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-02-14 04:20:51 | Skagway, Alaska, US | |
2022-02-12 | US | Alaska | Skagway | 2230 | 128 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-02-13 04:21:00 | Skagway, Alaska, US | |
2022-02-11 | US | Alaska | Skagway | 2230 | 128 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2022-02-12 04:21:06 | Skagway, Alaska, US | |
2022-02-06 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-07 04:21:05 | Hinsdale, Colorado, US | |
2022-02-05 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-06 04:21:00 | Hinsdale, Colorado, US | |
2022-02-04 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-05 04:21:05 | Hinsdale, Colorado, US | |
2022-02-03 | US | Idaho | Camas | 16025 | 128 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-02-04 04:21:10 | Camas, Idaho, US | |
2022-02-03 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-04 04:21:10 | Hinsdale, Colorado, US | |
2022-02-02 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-03 04:21:21 | Hinsdale, Colorado, US | |
2022-02-01 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-02 04:21:09 | Hinsdale, Colorado, US | |
2022-01-31 | US | Colorado | Hinsdale | 8053 | 128 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-02-01 04:21:11 | Hinsdale, Colorado, US | |
2022-01-23 | US | Montana | Golden Valley | 30037 | 128 | 5 | 0 | 46.3816474 | -109.17685220000001 | 2022-01-24 04:21:12 | Golden Valley, Montana, US | |
2022-01-22 | US | Montana | Golden Valley | 30037 | 128 | 5 | 0 | 46.3816474 | -109.17685220000001 | 2022-01-23 04:21:13 | Golden Valley, Montana, US | |
2022-01-21 | US | North Dakota | Billings | 38007 | 128 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-01-22 04:21:13 | Billings, North Dakota, US | |
2022-01-21 | US | Montana | Golden Valley | 30037 | 128 | 5 | 0 | 46.3816474 | -109.17685220000001 | 2022-01-22 04:21:13 | Golden Valley, Montana, US | |
2022-01-20 | US | North Dakota | Billings | 38007 | 128 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-01-21 04:21:09 | Billings, North Dakota, US | |
2021-12-27 | US | Colorado | Jackson | 8057 | 128 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-28 04:21:47 | Jackson, Colorado, US | |
2021-12-26 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-27 04:21:58 | Roberts, Texas, US | |
2021-12-26 | US | Colorado | Jackson | 8057 | 128 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-27 04:21:58 | Jackson, Colorado, US | |
2021-12-25 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-26 04:21:50 | Roberts, Texas, US | |
2021-12-25 | US | Colorado | Jackson | 8057 | 128 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-26 04:21:50 | Jackson, Colorado, US | |
2021-12-24 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-25 04:21:37 | Roberts, Texas, US | |
2021-12-24 | US | Colorado | Jackson | 8057 | 128 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-25 04:21:37 | Jackson, Colorado, US | |
2021-12-23 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-24 04:21:34 | Roberts, Texas, US | |
2021-12-22 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-23 04:21:21 | Roberts, Texas, US | |
2021-12-21 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-22 04:21:54 | Roberts, Texas, US | |
2021-12-20 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-21 03:21:27 | Roberts, Texas, US | |
2021-12-19 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-20 04:21:43 | Roberts, Texas, US | |
2021-12-18 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-19 04:21:11 | Roberts, Texas, US | |
2021-12-17 | US | Texas | Roberts | 48393 | 128 | 1 | 0 | 35.83809685 | -100.813175 | 2021-12-18 02:22:20 | Roberts, Texas, US | |
2021-11-03 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-11-04 04:22:20 | Throckmorton, Texas, US | |
2021-11-02 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-11-03 06:22:09 | Throckmorton, Texas, US | |
2021-11-02 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-11-03 06:22:09 | Rock, Nebraska, US | |
2021-11-01 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-11-02 04:22:03 | Throckmorton, Texas, US | |
2021-11-01 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-11-02 04:22:03 | Rock, Nebraska, US | |
2021-10-31 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-11-01 04:22:01 | Throckmorton, Texas, US | |
2021-10-31 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-11-01 04:22:01 | Rock, Nebraska, US | |
2021-10-30 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-10-31 04:22:08 | Throckmorton, Texas, US | |
2021-10-30 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-10-31 04:22:08 | Rock, Nebraska, US | |
2021-10-29 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-10-30 04:22:03 | Throckmorton, Texas, US | |
2021-10-29 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-10-30 04:22:03 | Rock, Nebraska, US | |
2021-10-28 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-10-29 04:22:03 | Throckmorton, Texas, US | |
2021-10-28 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-10-29 04:22:03 | Rock, Nebraska, US | |
2021-10-27 | US | Texas | Throckmorton | 48447 | 128 | 6 | 0 | 33.17751417 | -99.21226795 | 2021-10-28 04:22:08 | Throckmorton, Texas, US | |
2021-10-27 | US | Nebraska | Rock | 31149 | 128 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-10-28 04:22:08 | Rock, Nebraska, US | |
2021-10-27 | US | Illinois | Unassigned | 90017 | 128 | 2835 | 0 | 42.36542373 | 0.0 | 2021-10-28 04:22:08 | Unassigned, Illinois, US | |
2021-10-20 | US | Colorado | Mineral | 8079 | 128 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2021-10-21 04:21:18 | Mineral, Colorado, US | |
2021-10-19 | US | Colorado | Mineral | 8079 | 128 | 1 | 0 | 37.66954283 | -106.92816979999999 | 2021-10-20 04:21:00 | Mineral, Colorado, US | |
2021-10-04 | US | Colorado | Kiowa | 8061 | 128 | 4 | 0 | 38.43260896 | -102.7392145 | 2021-10-05 04:21:27 | Kiowa, Colorado, US | |
2021-10-03 | US | Kansas | Greeley | 20071 | 128 | 2 | 0 | 38.4808095 | -101.8061079 | 2021-10-04 04:21:31 | Greeley, Kansas, US | |
2021-10-02 | US | Kansas | Greeley | 20071 | 128 | 2 | 0 | 38.4808095 | -101.8061079 | 2021-10-03 04:21:24 | Greeley, Kansas, US | |
2021-10-01 | US | Kansas | Greeley | 20071 | 128 | 2 | 0 | 38.4808095 | -101.8061079 | 2021-10-02 04:21:25 | Greeley, Kansas, US | |
2021-09-30 | US | New York | Unassigned | 90036 | 128 | 30 | 0 | 44.74530905 | 0.0 | 2021-10-01 04:21:35 | Unassigned, New York, US | |
2021-09-30 | US | Kansas | Greeley | 20071 | 128 | 2 | 0 | 38.4808095 | -101.8061079 | 2021-10-01 04:21:35 | Greeley, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;