daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
823 rows where confirmed = 346 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-10-11 | US | Texas | Loving | 48301 | 346 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-10-12 04:22:51 | Loving, Texas, US | |
2022-10-10 | US | Texas | Loving | 48301 | 346 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-10-11 04:23:05 | Loving, Texas, US | |
2022-08-17 | US | North Dakota | Oliver | 38065 | 346 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-08-18 04:21:11 | Oliver, North Dakota, US | |
2022-08-16 | US | North Dakota | Oliver | 38065 | 346 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-08-17 04:20:59 | Oliver, North Dakota, US | |
2022-08-07 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-08 04:21:08 | Dundy, Nebraska, US | |
2022-08-06 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-07 04:20:54 | Dundy, Nebraska, US | |
2022-08-05 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-06 04:20:56 | Dundy, Nebraska, US | |
2022-08-04 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-05 04:20:52 | Dundy, Nebraska, US | |
2022-08-03 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-04 04:20:58 | Dundy, Nebraska, US | |
2022-08-02 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-03 04:20:59 | Greeley, Kansas, US | |
2022-08-01 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-02 04:20:53 | Greeley, Kansas, US | |
2022-07-31 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-01 04:21:03 | Greeley, Kansas, US | |
2022-07-30 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-31 04:21:02 | Greeley, Kansas, US | |
2022-07-29 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-30 04:20:42 | Greeley, Kansas, US | |
2022-07-28 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-29 04:20:45 | Greeley, Kansas, US | |
2022-07-27 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-28 04:20:56 | Greeley, Kansas, US | |
2022-07-06 | US | Colorado | Kiowa | 8061 | 346 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-07-07 04:20:55 | Kiowa, Colorado, US | |
2022-07-05 | US | Colorado | Kiowa | 8061 | 346 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-07-06 04:20:58 | Kiowa, Colorado, US | |
2022-03-14 | Peru | Unknown | 346 | 33 | 0 | 2022-03-15 04:20:47 | Unknown, Peru | |||||
2022-02-20 | US | Texas | Stonewall | 48433 | 346 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-21 04:21:05 | Stonewall, Texas, US | |
2022-02-19 | US | Texas | Stonewall | 48433 | 346 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-20 04:21:00 | Stonewall, Texas, US | |
2022-02-02 | US | Nebraska | Gosper | 31073 | 346 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-02-03 04:21:21 | Gosper, Nebraska, US | |
2022-01-29 | US | Colorado | Dolores | 8033 | 346 | 7 | 0 | 37.75208676 | -108.5211585 | 2022-01-30 04:21:26 | Dolores, Colorado, US | |
2022-01-23 | US | North Dakota | Steele | 38091 | 346 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-01-24 04:21:12 | Steele, North Dakota, US | |
2022-01-21 | US | Texas | Irion | 48235 | 346 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-22 04:21:13 | Irion, Texas, US | |
2022-01-20 | US | Washington | Wahkiakum | 53069 | 346 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-21 04:21:09 | Wahkiakum, Washington, US | |
2022-01-19 | US | Nebraska | Boyd | 31015 | 346 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2022-01-20 04:21:07 | Boyd, Nebraska, US | |
2022-01-12 | US | Texas | Briscoe | 48045 | 346 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-01-13 08:00:09 | Briscoe, Texas, US | |
2022-01-12 | US | South Dakota | Jerauld | 46073 | 346 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-01-13 08:00:09 | Jerauld, South Dakota, US | |
2022-01-11 | US | Missouri | Worth | 29227 | 346 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-12 04:21:44 | Worth, Missouri, US | |
2022-01-11 | US | Georgia | Webster | 13307 | 346 | 7 | 0 | 32.04066113 | -84.54742852 | 2022-01-12 04:21:44 | Webster, Georgia, US | |
2022-01-04 | US | Georgia | Clay | 13061 | 346 | 4 | 0 | 31.62221166 | -84.97713865 | 2022-01-05 04:21:59 | Clay, Georgia, US | |
2022-01-02 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-03 02:22:25 | Wallace, Kansas, US | |
2022-01-01 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-02 04:20:52 | Wallace, Kansas, US | |
2021-12-31 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-01 04:22:14 | Wallace, Kansas, US | |
2021-12-30 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2021-12-31 04:21:50 | Wallace, Kansas, US | |
2021-12-29 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2021-12-30 04:21:25 | Wallace, Kansas, US | |
2021-12-20 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-21 03:21:27 | Menard, Texas, US | |
2021-12-19 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-20 04:21:43 | Menard, Texas, US | |
2021-12-18 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-19 04:21:11 | Menard, Texas, US | |
2021-12-17 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-18 02:22:20 | Menard, Texas, US | |
2021-12-17 | US | North Dakota | Logan | 38047 | 346 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-18 02:22:20 | Logan, North Dakota, US | |
2021-12-16 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-17 04:22:14 | Menard, Texas, US | |
2021-12-16 | US | North Dakota | Logan | 38047 | 346 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-17 04:22:14 | Logan, North Dakota, US | |
2021-12-15 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-16 04:22:11 | Menard, Texas, US | |
2021-12-14 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-15 03:22:16 | Menard, Texas, US | |
2021-12-14 | US | Kansas | Comanche | 20033 | 346 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-15 03:22:16 | Comanche, Kansas, US | |
2021-12-13 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-14 04:22:38 | Menard, Texas, US | |
2021-12-13 | US | Kansas | Comanche | 20033 | 346 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-14 04:22:38 | Comanche, Kansas, US | |
2021-12-12 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-13 04:22:02 | Menard, Texas, US | |
2021-12-11 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-12 04:22:12 | Menard, Texas, US | |
2021-12-10 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-11 04:22:45 | Menard, Texas, US | |
2021-12-05 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-06 04:22:34 | Mellette, South Dakota, US | |
2021-12-04 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-05 04:22:25 | Mellette, South Dakota, US | |
2021-12-03 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-04 04:22:18 | Mellette, South Dakota, US | |
2021-11-24 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-25 04:22:33 | Guanica, Puerto Rico, US | |
2021-11-23 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-24 04:22:14 | Guanica, Puerto Rico, US | |
2021-11-22 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-23 04:22:39 | Guanica, Puerto Rico, US | |
2021-11-21 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-22 04:22:20 | Guanica, Puerto Rico, US | |
2021-11-21 | US | North Dakota | Burke | 38013 | 346 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-22 04:22:20 | Burke, North Dakota, US | |
2021-11-20 | US | North Dakota | Burke | 38013 | 346 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-21 04:22:13 | Burke, North Dakota, US | |
2021-11-18 | US | North Dakota | Grant | 38037 | 346 | 8 | 0 | 46.35821257 | -101.63900129999999 | 2021-11-19 04:21:40 | Grant, North Dakota, US | |
2021-11-15 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-16 04:21:10 | Edwards, Texas, US | |
2021-11-14 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-15 04:21:36 | Edwards, Texas, US | |
2021-11-13 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-14 04:21:31 | Edwards, Texas, US | |
2021-11-12 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-13 04:21:38 | Edwards, Texas, US | |
2021-11-07 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-08 04:21:43 | Hitchcock, Nebraska, US | |
2021-11-07 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-08 04:21:43 | Brown, Nebraska, US | |
2021-11-06 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-07 04:21:53 | Hitchcock, Nebraska, US | |
2021-11-06 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-07 04:21:53 | Brown, Nebraska, US | |
2021-11-05 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-06 04:21:51 | Hitchcock, Nebraska, US | |
2021-11-05 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-06 04:21:51 | Brown, Nebraska, US | |
2021-11-04 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-05 04:21:54 | Hitchcock, Nebraska, US | |
2021-11-04 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-05 04:21:54 | Brown, Nebraska, US | |
2021-11-03 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-04 04:22:20 | Hitchcock, Nebraska, US | |
2021-11-03 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-04 04:22:20 | Brown, Nebraska, US | |
2021-11-03 | China | Guangxi | 346 | 2 | 0 | 23.8298 | 108.7881 | 2021-11-04 04:22:20 | Guangxi, China | |||
2021-10-24 | US | North Dakota | Golden Valley | 38033 | 346 | 4 | 0 | 46.94022281 | -103.8465421 | 2021-10-25 04:22:31 | Golden Valley, North Dakota, US | |
2021-10-10 | US | North Dakota | Kidder | 38043 | 346 | 10 | 0 | 46.97830064 | -99.77507857 | 2021-10-11 04:21:31 | Kidder, North Dakota, US | |
2021-09-15 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-16 04:22:19 | Renville, North Dakota, US | |
2021-09-14 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-15 03:22:37 | Renville, North Dakota, US | |
2021-09-13 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-14 04:21:41 | Renville, North Dakota, US | |
2021-09-12 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-13 04:21:15 | Renville, North Dakota, US | |
2021-09-11 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-12 04:21:13 | Renville, North Dakota, US | |
2021-09-10 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-11 04:21:30 | Renville, North Dakota, US | |
2021-09-09 | US | Pennsylvania | Cameron | 42023 | 346 | 10 | 0 | 41.43625568 | -78.20376845 | 2021-09-10 04:21:20 | Cameron, Pennsylvania, US | |
2021-09-04 | US | Colorado | Gilpin | 8047 | 346 | 3 | 0 | 39.85646523 | -105.5252597 | 2021-09-05 04:21:33 | Gilpin, Colorado, US | |
2021-09-02 | US | Texas | Culberson | 48109 | 346 | 11 | 0 | 31.44506775 | -104.5185739 | 2021-09-03 04:21:20 | Culberson, Texas, US | |
2021-09-02 | US | Alaska | Prince of Wales-Hyder | 2198 | 346 | 5 | 0 | 55.76261984 | -133.0511621 | 2021-09-03 04:21:20 | Prince of Wales-Hyder, Alaska, US | |
2021-09-01 | US | North Dakota | Towner | 38095 | 346 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-09-02 04:21:15 | Towner, North Dakota, US | |
2021-08-31 | US | California | Unassigned | 90006 | 346 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-01 04:21:38 | Unassigned, California, US | |
2021-08-23 | US | Georgia | Glascock | 13125 | 346 | 19 | 0 | 33.22879932 | -82.61297636 | 2021-08-24 04:21:19 | Glascock, Georgia, US | |
2021-08-21 | US | New York | Hamilton | 36041 | 346 | 2 | 0 | 43.66146647 | -74.49721957 | 2021-08-22 04:21:29 | Hamilton, New York, US | |
2021-08-18 | US | Missouri | Mercer | 29129 | 346 | 2 | 0 | 40.42212303 | -93.56829590000001 | 2021-08-19 04:21:15 | Mercer, Missouri, US | |
2021-08-01 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-08-02 04:21:36 | Pope, Illinois, US | |
2021-07-31 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-08-01 04:21:50 | Pope, Illinois, US | |
2021-07-30 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-07-31 04:21:35 | Pope, Illinois, US | |
2021-07-27 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-28 04:21:39 | Upton, Texas, US | |
2021-07-26 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-27 04:21:18 | Upton, Texas, US | |
2021-07-25 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-26 04:21:28 | Upton, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;