johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
600 rows where confirmed = 485 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309188 | 309188 | 2022-12-13 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-14 04:21:04 | Hodgeman, Kansas, US | |
1150249 | 1150249 | 2022-12-12 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-13 04:21:01 | Hodgeman, Kansas, US | |
870103 | 870103 | 2022-12-11 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-12 04:21:01 | Hodgeman, Kansas, US | |
258633 | 258633 | 2022-12-10 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-11 04:20:50 | Hodgeman, Kansas, US | |
3937347 | 3937347 | 2022-12-09 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-10 04:21:02 | Hodgeman, Kansas, US | |
3378679 | 3378679 | 2022-12-08 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-09 04:21:05 | Hodgeman, Kansas, US | |
1985950 | 1985950 | 2022-12-07 | US | Kansas | Hodgeman | 20083 | 485 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-12-08 04:21:07 | Hodgeman, Kansas, US | |
2557866 | 2557866 | 2022-11-29 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-30 04:21:07 | Comanche, Kansas, US | |
1240940 | 1240940 | 2022-11-28 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-29 04:21:05 | Comanche, Kansas, US | |
3552928 | 3552928 | 2022-11-27 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-28 04:21:02 | Comanche, Kansas, US | |
2101408 | 2101408 | 2022-11-26 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-27 04:21:05 | Comanche, Kansas, US | |
488899 | 488899 | 2022-11-25 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-26 04:21:11 | Comanche, Kansas, US | |
3524728 | 3524728 | 2022-11-24 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-25 04:21:06 | Comanche, Kansas, US | |
3313511 | 3313511 | 2022-11-23 | US | Kansas | Comanche | 20033 | 485 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-11-24 04:21:09 | Comanche, Kansas, US | |
322124 | 322124 | 2022-10-30 | US | New Mexico | Catron | 35003 | 485 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-31 04:21:36 | Catron, New Mexico, US | |
914400 | 914400 | 2022-10-29 | US | New Mexico | Catron | 35003 | 485 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-30 04:22:14 | Catron, New Mexico, US | |
1368669 | 1368669 | 2022-10-28 | US | New Mexico | Catron | 35003 | 485 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-29 04:21:13 | Catron, New Mexico, US | |
3041074 | 3041074 | 2022-10-27 | US | Puerto Rico | Culebra | 72049 | 485 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-28 04:22:31 | Culebra, Puerto Rico, US | |
3040524 | 3040524 | 2022-10-27 | US | New Mexico | Catron | 35003 | 485 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-28 04:22:31 | Catron, New Mexico, US | |
541494 | 541494 | 2022-10-26 | US | Puerto Rico | Culebra | 72049 | 485 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-27 04:22:01 | Culebra, Puerto Rico, US | |
993890 | 993890 | 2022-08-16 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-17 04:20:59 | Miner, South Dakota, US | |
993869 | 993869 | 2022-08-16 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-17 04:20:59 | Haakon, South Dakota, US | |
2496929 | 2496929 | 2022-08-15 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-16 04:20:58 | Miner, South Dakota, US | |
2496908 | 2496908 | 2022-08-15 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-16 04:20:58 | Haakon, South Dakota, US | |
3650479 | 3650479 | 2022-08-14 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-15 04:20:59 | Miner, South Dakota, US | |
3650458 | 3650458 | 2022-08-14 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-15 04:20:59 | Haakon, South Dakota, US | |
1971485 | 1971485 | 2022-08-13 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-14 04:20:55 | Miner, South Dakota, US | |
1971464 | 1971464 | 2022-08-13 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-14 04:20:55 | Haakon, South Dakota, US | |
2891294 | 2891294 | 2022-08-12 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-13 04:20:52 | Miner, South Dakota, US | |
2891273 | 2891273 | 2022-08-12 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-13 04:20:52 | Haakon, South Dakota, US | |
3910899 | 3910899 | 2022-08-11 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-12 04:20:54 | Miner, South Dakota, US | |
3910878 | 3910878 | 2022-08-11 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-12 04:20:54 | Haakon, South Dakota, US | |
1349216 | 1349216 | 2022-08-10 | US | South Dakota | Miner | 46097 | 485 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-08-11 04:20:49 | Miner, South Dakota, US | |
1349195 | 1349195 | 2022-08-10 | US | South Dakota | Haakon | 46055 | 485 | 12 | 0 | 44.29299053 | -101.539099 | 2022-08-11 04:20:49 | Haakon, South Dakota, US | |
3874596 | 3874596 | 2022-07-31 | US | Texas | Briscoe | 48045 | 485 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-01 04:21:03 | Briscoe, Texas, US | |
677350 | 677350 | 2022-07-30 | US | Texas | Briscoe | 48045 | 485 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-31 04:21:02 | Briscoe, Texas, US | |
1786549 | 1786549 | 2022-07-29 | US | Texas | Briscoe | 48045 | 485 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-30 04:20:42 | Briscoe, Texas, US | |
1068282 | 1068282 | 2022-07-28 | US | North Dakota | Grant | 38037 | 485 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-29 04:20:45 | Grant, North Dakota, US | |
1068280 | 1068280 | 2022-07-28 | US | North Dakota | Golden Valley | 38033 | 485 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-29 04:20:45 | Golden Valley, North Dakota, US | |
2337799 | 2337799 | 2022-07-27 | US | North Dakota | Golden Valley | 38033 | 485 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-28 04:20:56 | Golden Valley, North Dakota, US | |
1489989 | 1489989 | 2022-07-26 | US | North Dakota | Golden Valley | 38033 | 485 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-27 04:21:04 | Golden Valley, North Dakota, US | |
2596435 | 2596435 | 2022-07-25 | US | North Dakota | Golden Valley | 38033 | 485 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-26 04:20:58 | Golden Valley, North Dakota, US | |
2240328 | 2240328 | 2022-06-28 | US | Idaho | Butte | 16023 | 485 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-29 04:20:59 | Butte, Idaho, US | |
2148570 | 2148570 | 2022-06-27 | US | Idaho | Butte | 16023 | 485 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-28 04:20:58 | Butte, Idaho, US | |
476371 | 476371 | 2022-06-26 | US | Idaho | Butte | 16023 | 485 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-27 04:21:00 | Butte, Idaho, US | |
939746 | 939746 | 2022-06-25 | US | Idaho | Butte | 16023 | 485 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-26 04:21:02 | Butte, Idaho, US | |
3347566 | 3347566 | 2022-06-24 | US | Idaho | Butte | 16023 | 485 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-06-25 04:20:57 | Butte, Idaho, US | |
2190694 | 2190694 | 2022-06-22 | US | Texas | Edwards | 48137 | 485 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-23 04:20:55 | Edwards, Texas, US | |
577981 | 577981 | 2022-02-25 | US | Texas | Knox | 48275 | 485 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-26 04:21:12 | Knox, Texas, US | |
1514557 | 1514557 | 2022-02-24 | US | Texas | Knox | 48275 | 485 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-25 04:21:11 | Knox, Texas, US | |
1060998 | 1060998 | 2022-02-23 | US | Texas | Knox | 48275 | 485 | 23 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-24 04:21:14 | Knox, Texas, US | |
3878799 | 3878799 | 2022-02-19 | US | Texas | Sherman | 48421 | 485 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-02-20 04:21:00 | Sherman, Texas, US | |
3859055 | 3859055 | 2022-02-18 | US | Texas | Sherman | 48421 | 485 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-02-19 04:21:11 | Sherman, Texas, US | |
1301274 | 1301274 | 2022-02-17 | US | Texas | Sherman | 48421 | 485 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-02-18 04:21:04 | Sherman, Texas, US | |
2642411 | 2642411 | 2022-02-14 | US | Colorado | Sedgwick | 8115 | 485 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-15 04:21:09 | Sedgwick, Colorado, US | |
1364759 | 1364759 | 2022-02-08 | US | North Dakota | Kidder | 38043 | 485 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-09 04:21:04 | Kidder, North Dakota, US | |
461429 | 461429 | 2022-02-02 | US | Nebraska | Brown | 31017 | 485 | 2 | 0 | 42.43018907 | -99.92904055 | 2022-02-03 04:21:21 | Brown, Nebraska, US | |
2052659 | 2052659 | 2022-01-25 | US | Georgia | Clay | 13061 | 485 | 4 | 0 | 31.62221166 | -84.97713865 | 2022-01-26 04:21:07 | Clay, Georgia, US | |
102516 | 102516 | 2022-01-14 | US | Texas | Oldham | 48359 | 485 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-15 04:21:07 | Oldham, Texas, US | |
3690671 | 3690671 | 2022-01-13 | US | Texas | Oldham | 48359 | 485 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-14 04:21:54 | Oldham, Texas, US | |
3616255 | 3616255 | 2022-01-12 | US | Texas | Oldham | 48359 | 485 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-13 08:00:09 | Oldham, Texas, US | |
3615935 | 3615935 | 2022-01-12 | US | South Dakota | Faulk | 46049 | 485 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-13 08:00:09 | Faulk, South Dakota, US | |
1289092 | 1289092 | 2022-01-04 | US | Texas | Fisher | 48151 | 485 | 19 | 0 | 32.74281316 | -100.40193020000001 | 2022-01-05 04:21:59 | Fisher, Texas, US | |
1702554 | 1702554 | 2022-01-03 | US | New Mexico | Mora | 35033 | 485 | 14 | 0 | 36.01095101 | -104.9497716 | 2022-01-04 04:22:17 | Mora, New Mexico, US | |
2905677 | 2905677 | 2021-12-19 | US | Missouri | Scotland | 29199 | 485 | 15 | 0 | 40.45214695 | -92.14709064 | 2021-12-20 04:21:43 | Scotland, Missouri, US | |
1741151 | 1741151 | 2021-12-05 | US | Colorado | Custer | 8027 | 485 | 13 | 0 | 38.10883162 | -105.3683478 | 2021-12-06 04:22:34 | Custer, Colorado, US | |
1147983 | 1147983 | 2021-12-01 | US | Texas | Collingsworth | 48087 | 485 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-12-02 04:22:37 | Collingsworth, Texas, US | |
276827 | 276827 | 2021-11-03 | US | Colorado | Ouray | 8091 | 485 | 6 | 0 | 38.14717457 | -107.7675136 | 2021-11-04 04:22:20 | Ouray, Colorado, US | |
6750 | 6750 | 2021-10-28 | US | North Dakota | Hettinger | 38041 | 485 | 6 | 0 | 46.43375068 | -102.4632417 | 2021-10-29 04:22:03 | Hettinger, North Dakota, US | |
538040 | 538040 | 2021-10-27 | US | Virginia | Bath | 51017 | 485 | 14 | 0 | 38.05852573 | -79.73912095 | 2021-10-28 04:22:08 | Bath, Virginia, US | |
535153 | 535153 | 2021-10-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 485 | 0 | 0 | 58.62403337 | -156.21405890000003 | 2021-10-28 04:22:08 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
3495477 | 3495477 | 2021-10-26 | US | Virginia | Bath | 51017 | 485 | 14 | 0 | 38.05852573 | -79.73912095 | 2021-10-27 04:22:32 | Bath, Virginia, US | |
2127026 | 2127026 | 2021-10-21 | US | Vermont | Essex | 50009 | 485 | 2 | 0 | 44.72736416 | -71.73579864 | 2021-10-22 04:21:14 | Essex, Vermont, US | |
445486 | 445486 | 2021-10-20 | US | Nebraska | Webster | 31181 | 485 | 7 | 0 | 40.17642643 | -98.50019851 | 2021-10-21 04:21:18 | Webster, Nebraska, US | |
598998 | 598998 | 2021-10-19 | US | Kansas | Ness | 20135 | 485 | 17 | 0 | 38.47974157 | -99.91547333 | 2021-10-20 04:21:00 | Ness, Kansas, US | |
2045175 | 2045175 | 2021-10-18 | US | Kansas | Ness | 20135 | 485 | 17 | 0 | 38.47974157 | -99.91547333 | 2021-10-19 04:20:54 | Ness, Kansas, US | |
492902 | 492902 | 2021-10-14 | US | Kansas | Chautauqua | 20019 | 485 | 8 | 0 | 37.14994405 | -96.2454192 | 2021-10-15 04:21:26 | Chautauqua, Kansas, US | |
635190 | 635190 | 2021-10-13 | US | Kansas | Chautauqua | 20019 | 485 | 8 | 0 | 37.14994405 | -96.2454192 | 2021-10-14 04:21:29 | Chautauqua, Kansas, US | |
634840 | 634840 | 2021-10-13 | US | Idaho | Adams | 16003 | 485 | 9 | 0 | 44.89333571 | -116.4545247 | 2021-10-14 04:21:29 | Adams, Idaho, US | |
2878950 | 2878950 | 2021-10-09 | US | Puerto Rico | Guayanilla | 72059 | 485 | 0 | 0 | 18.039942 | -66.79186 | 2021-10-10 04:21:38 | Guayanilla, Puerto Rico, US | |
2962116 | 2962116 | 2021-10-08 | US | Puerto Rico | Guayanilla | 72059 | 485 | 0 | 0 | 18.039942 | -66.79186 | 2021-10-09 04:21:34 | Guayanilla, Puerto Rico, US | |
470154 | 470154 | 2021-10-07 | US | Puerto Rico | Guayanilla | 72059 | 485 | 0 | 0 | 18.039942 | -66.79186 | 2021-10-08 04:21:25 | Guayanilla, Puerto Rico, US | |
2461534 | 2461534 | 2021-10-06 | US | Puerto Rico | Guayanilla | 72059 | 485 | 0 | 0 | 18.039942 | -66.79186 | 2021-10-07 04:21:36 | Guayanilla, Puerto Rico, US | |
1276390 | 1276390 | 2021-10-03 | US | Nebraska | Nance | 31125 | 485 | 10 | 0 | 41.39750195 | -97.99327291 | 2021-10-04 04:21:31 | Nance, Nebraska, US | |
1274727 | 1274727 | 2021-10-03 | US | Alaska | Unassigned | 90002 | 485 | 0 | 0 | 69.31479216 | 0.0 | 2021-10-04 04:21:31 | Unassigned, Alaska, US | |
3930143 | 3930143 | 2021-10-02 | US | Nebraska | Nance | 31125 | 485 | 10 | 0 | 41.39750195 | -97.99327291 | 2021-10-03 04:21:24 | Nance, Nebraska, US | |
3928480 | 3928480 | 2021-10-02 | US | Alaska | Unassigned | 90002 | 485 | 0 | 0 | 69.31479216 | 0.0 | 2021-10-03 04:21:24 | Unassigned, Alaska, US | |
2134123 | 2134123 | 2021-10-01 | US | Nebraska | Nance | 31125 | 485 | 10 | 0 | 41.39750195 | -97.99327291 | 2021-10-02 04:21:25 | Nance, Nebraska, US | |
2132460 | 2132460 | 2021-10-01 | US | Alaska | Unassigned | 90002 | 485 | 0 | 0 | 69.31479216 | 0.0 | 2021-10-02 04:21:25 | Unassigned, Alaska, US | |
2775080 | 2775080 | 2021-09-30 | US | Nebraska | Nance | 31125 | 485 | 10 | 0 | 41.39750195 | -97.99327291 | 2021-10-01 04:21:35 | Nance, Nebraska, US | |
2774993 | 2774993 | 2021-09-30 | US | Montana | Musselshell | 30065 | 485 | 15 | 0 | 46.49684637 | -108.39498 | 2021-10-01 04:21:35 | Musselshell, Montana, US | |
2078000 | 2078000 | 2021-09-26 | US | Nebraska | Chase | 31029 | 485 | 5 | 0 | 40.523719799999995 | -101.69780259999999 | 2021-09-27 04:21:16 | Chase, Nebraska, US | |
1726552 | 1726552 | 2021-09-25 | US | Nebraska | Chase | 31029 | 485 | 5 | 0 | 40.523719799999995 | -101.69780259999999 | 2021-09-26 04:21:29 | Chase, Nebraska, US | |
1724309 | 1724309 | 2021-09-25 | China | Tianjin | 485 | 3 | 0 | 39.3054 | 117.323 | 2021-09-26 04:21:29 | Tianjin, China | |||
1924419 | 1924419 | 2021-09-24 | US | Texas | Reagan | 48383 | 485 | 9 | 0 | 31.36607041 | -101.52326590000001 | 2021-09-25 04:21:31 | Reagan, Texas, US | |
1921029 | 1921029 | 2021-09-24 | China | Tianjin | 485 | 3 | 0 | 39.3054 | 117.323 | 2021-09-25 04:21:31 | Tianjin, China | |||
604086 | 604086 | 2021-09-23 | US | North Dakota | Eddy | 38027 | 485 | 6 | 0 | 47.71701474 | -98.90432337 | 2021-09-24 04:21:44 | Eddy, North Dakota, US | |
603029 | 603029 | 2021-09-23 | US | Kansas | Rush | 20165 | 485 | 15 | 0 | 38.52275276 | -99.30863983 | 2021-09-24 04:21:44 | Rush, Kansas, US | |
3013730 | 3013730 | 2021-09-22 | US | North Dakota | Eddy | 38027 | 485 | 6 | 0 | 47.71701474 | -98.90432337 | 2021-09-23 04:21:43 | Eddy, North Dakota, US | |
3012673 | 3012673 | 2021-09-22 | US | Kansas | Rush | 20165 | 485 | 15 | 0 | 38.52275276 | -99.30863983 | 2021-09-23 04:21:43 | Rush, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);