johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
798 rows where confirmed = 480 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952750 | 2952750 | 2022-12-20 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-21 04:21:03 | Wallace, Kansas, US | |
3175152 | 3175152 | 2022-12-19 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-20 04:21:04 | Wallace, Kansas, US | |
1629669 | 1629669 | 2022-12-18 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-19 04:21:03 | Wallace, Kansas, US | |
505048 | 505048 | 2022-12-17 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-18 04:21:03 | Wallace, Kansas, US | |
3325620 | 3325620 | 2022-12-16 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-17 04:21:04 | Wallace, Kansas, US | |
544132 | 544132 | 2022-12-15 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-16 04:21:01 | Wallace, Kansas, US | |
349660 | 349660 | 2022-12-14 | US | Kansas | Wallace | 20199 | 480 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-15 04:20:58 | Wallace, Kansas, US | |
2557891 | 2557891 | 2022-11-29 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-30 04:21:07 | Hodgeman, Kansas, US | |
1240965 | 1240965 | 2022-11-28 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-29 04:21:05 | Hodgeman, Kansas, US | |
3552953 | 3552953 | 2022-11-27 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-28 04:21:02 | Hodgeman, Kansas, US | |
2101433 | 2101433 | 2022-11-26 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-27 04:21:05 | Hodgeman, Kansas, US | |
488924 | 488924 | 2022-11-25 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-26 04:21:11 | Hodgeman, Kansas, US | |
3524753 | 3524753 | 2022-11-24 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-25 04:21:06 | Hodgeman, Kansas, US | |
3313536 | 3313536 | 2022-11-23 | US | Kansas | Hodgeman | 20083 | 480 | 13 | 0 | 38.08780079 | -99.89829881 | 2022-11-24 04:21:09 | Hodgeman, Kansas, US | |
3216490 | 3216490 | 2022-10-12 | US | New Mexico | Catron | 35003 | 480 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-10-13 04:22:39 | Catron, New Mexico, US | |
132028 | 132028 | 2022-10-04 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-10-05 04:23:06 | Comanche, Kansas, US | |
2686975 | 2686975 | 2022-10-03 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-10-04 04:22:55 | Comanche, Kansas, US | |
2261042 | 2261042 | 2022-10-02 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-10-03 04:23:11 | Comanche, Kansas, US | |
2996568 | 2996568 | 2022-10-01 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-10-02 04:21:23 | Comanche, Kansas, US | |
854894 | 854894 | 2022-09-30 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-10-01 04:23:01 | Comanche, Kansas, US | |
2376820 | 2376820 | 2022-09-29 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-30 04:23:09 | Comanche, Kansas, US | |
1561371 | 1561371 | 2022-09-28 | US | Kansas | Comanche | 20033 | 480 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-29 04:22:34 | Comanche, Kansas, US | |
2771155 | 2771155 | 2022-09-26 | US | New Mexico | Catron | 35003 | 480 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-09-27 04:23:01 | Catron, New Mexico, US | |
3911078 | 3911078 | 2022-08-11 | US | Texas | Dickens | 48125 | 480 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-12 04:20:54 | Dickens, Texas, US | |
1349395 | 1349395 | 2022-08-10 | US | Texas | Dickens | 48125 | 480 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-11 04:20:49 | Dickens, Texas, US | |
1089150 | 1089150 | 2022-08-09 | US | Texas | Dickens | 48125 | 480 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-08-10 04:20:57 | Dickens, Texas, US | |
1490482 | 1490482 | 2022-07-26 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-27 04:21:04 | Miner, South Dakota, US | |
2596928 | 2596928 | 2022-07-25 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-26 04:20:58 | Miner, South Dakota, US | |
899043 | 899043 | 2022-07-24 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-25 04:20:51 | Miner, South Dakota, US | |
94037 | 94037 | 2022-07-23 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-24 04:20:47 | Miner, South Dakota, US | |
903059 | 903059 | 2022-07-22 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-23 04:20:53 | Miner, South Dakota, US | |
673195 | 673195 | 2022-07-21 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-22 04:21:15 | Miner, South Dakota, US | |
1611158 | 1611158 | 2022-07-20 | US | South Dakota | Miner | 46097 | 480 | 13 | 0 | 44.02197882 | -97.60992207 | 2022-07-21 04:21:10 | Miner, South Dakota, US | |
1610667 | 1610667 | 2022-07-20 | US | North Dakota | Grant | 38037 | 480 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-21 04:21:10 | Grant, North Dakota, US | |
961930 | 961930 | 2022-07-19 | US | Texas | Briscoe | 48045 | 480 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-20 04:20:59 | Briscoe, Texas, US | |
961300 | 961300 | 2022-07-19 | US | North Dakota | Grant | 38037 | 480 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-07-20 04:20:59 | Grant, North Dakota, US | |
3213317 | 3213317 | 2022-07-18 | US | Texas | Briscoe | 48045 | 480 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-19 04:20:58 | Briscoe, Texas, US | |
3408492 | 3408492 | 2022-07-17 | US | Texas | Briscoe | 48045 | 480 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-07-18 04:20:59 | Briscoe, Texas, US | |
2791437 | 2791437 | 2022-07-10 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-11 04:20:46 | Golden Valley, North Dakota, US | |
144390 | 144390 | 2022-07-09 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-10 04:20:54 | Golden Valley, North Dakota, US | |
1419490 | 1419490 | 2022-07-08 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-09 04:20:59 | Golden Valley, North Dakota, US | |
2743415 | 2743415 | 2022-07-07 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-08 04:20:56 | Golden Valley, North Dakota, US | |
1202210 | 1202210 | 2022-07-06 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-07 04:20:55 | Golden Valley, North Dakota, US | |
3968953 | 3968953 | 2022-07-05 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-06 04:20:58 | Golden Valley, North Dakota, US | |
3080464 | 3080464 | 2022-07-04 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-05 04:20:45 | Golden Valley, North Dakota, US | |
1769746 | 1769746 | 2022-07-03 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-04 04:20:54 | Golden Valley, North Dakota, US | |
3367732 | 3367732 | 2022-07-02 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-03 04:20:59 | Golden Valley, North Dakota, US | |
596061 | 596061 | 2022-07-01 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-02 04:21:16 | Golden Valley, North Dakota, US | |
3942462 | 3942462 | 2022-06-30 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-07-01 04:21:10 | Golden Valley, North Dakota, US | |
2492420 | 2492420 | 2022-06-29 | US | North Dakota | Golden Valley | 38033 | 480 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-06-30 04:21:01 | Golden Valley, North Dakota, US | |
1766408 | 1766408 | 2022-06-20 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-21 04:20:56 | Edwards, Texas, US | |
3272594 | 3272594 | 2022-06-19 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-20 04:21:01 | Edwards, Texas, US | |
3400506 | 3400506 | 2022-06-18 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-19 04:20:51 | Edwards, Texas, US | |
2314383 | 2314383 | 2022-06-17 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-18 04:21:10 | Edwards, Texas, US | |
561887 | 561887 | 2022-06-16 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-17 04:20:56 | Edwards, Texas, US | |
559735 | 559735 | 2022-06-16 | US | Idaho | Butte | 16023 | 480 | 9 | 0 | 43.72592209 | -113.1735463 | 2022-06-17 04:20:56 | Butte, Idaho, US | |
3985689 | 3985689 | 2022-06-15 | US | Texas | Edwards | 48137 | 480 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-16 04:20:55 | Edwards, Texas, US | |
3983537 | 3983537 | 2022-06-15 | US | Idaho | Butte | 16023 | 480 | 9 | 0 | 43.72592209 | -113.1735463 | 2022-06-16 04:20:55 | Butte, Idaho, US | |
1660083 | 1660083 | 2022-03-19 | Vanuatu | 480 | 1 | 0 | -15.3767 | 166.9592 | 2022-03-20 04:20:45 | Vanuatu | ||||
339609 | 339609 | 2022-03-18 | Vanuatu | 480 | 1 | 0 | -15.3767 | 166.9592 | 2022-03-19 04:20:47 | Vanuatu | ||||
1365501 | 1365501 | 2022-02-08 | US | Texas | Knox | 48275 | 480 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-09 04:21:04 | Knox, Texas, US | |
1363010 | 1363010 | 2022-02-08 | US | Colorado | Sedgwick | 8115 | 480 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-09 04:21:04 | Sedgwick, Colorado, US | |
74239 | 74239 | 2022-02-07 | US | Texas | Knox | 48275 | 480 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2022-02-08 04:21:15 | Knox, Texas, US | |
71748 | 71748 | 2022-02-07 | US | Colorado | Sedgwick | 8115 | 480 | 9 | 0 | 40.87595412 | -102.3519227 | 2022-02-08 04:21:15 | Sedgwick, Colorado, US | |
1296442 | 1296442 | 2022-02-05 | US | North Dakota | Kidder | 38043 | 480 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-06 04:21:00 | Kidder, North Dakota, US | |
2330380 | 2330380 | 2022-02-04 | US | Texas | Armstrong | 48011 | 480 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-05 04:21:05 | Armstrong, Texas, US | |
2329770 | 2329770 | 2022-02-04 | US | North Dakota | Kidder | 38043 | 480 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-05 04:21:05 | Kidder, North Dakota, US | |
2475225 | 2475225 | 2022-02-03 | US | Kansas | Clark | 20025 | 480 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-02-04 04:21:10 | Clark, Kansas, US | |
460650 | 460650 | 2022-02-02 | US | Kansas | Clark | 20025 | 480 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-02-03 04:21:21 | Clark, Kansas, US | |
3302292 | 3302292 | 2022-01-30 | US | Nebraska | Hitchcock | 31087 | 480 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-01-31 04:21:09 | Hitchcock, Nebraska, US | |
3064083 | 3064083 | 2022-01-29 | US | Nebraska | Hitchcock | 31087 | 480 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-01-30 04:21:26 | Hitchcock, Nebraska, US | |
3812017 | 3812017 | 2022-01-28 | US | Nebraska | Hitchcock | 31087 | 480 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-01-29 04:21:10 | Hitchcock, Nebraska, US | |
1782280 | 1782280 | 2022-01-27 | US | South Dakota | Mellette | 46095 | 480 | 5 | 0 | 43.58078848 | -100.7563186 | 2022-01-28 04:21:09 | Mellette, South Dakota, US | |
2054948 | 2054948 | 2022-01-25 | US | Texas | Culberson | 48109 | 480 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-01-26 04:21:07 | Culberson, Texas, US | |
3613873 | 3613873 | 2022-01-12 | US | Georgia | Glascock | 13125 | 480 | 21 | 0 | 33.22879932 | -82.61297636 | 2022-01-13 08:00:09 | Glascock, Georgia, US | |
1116460 | 1116460 | 2022-01-11 | US | South Dakota | Faulk | 46049 | 480 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-12 04:21:44 | Faulk, South Dakota, US | |
1115712 | 1115712 | 2022-01-11 | US | Nebraska | Sherman | 31163 | 480 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-12 04:21:44 | Sherman, Nebraska, US | |
129137 | 129137 | 2022-01-09 | US | North Dakota | Griggs | 38039 | 480 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-01-10 04:22:07 | Griggs, North Dakota, US | |
1217972 | 1217972 | 2022-01-08 | US | North Dakota | Griggs | 38039 | 480 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-01-09 04:21:46 | Griggs, North Dakota, US | |
1217953 | 1217953 | 2022-01-08 | US | North Dakota | Adams | 38001 | 480 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-01-09 04:21:46 | Adams, North Dakota, US | |
1392046 | 1392046 | 2022-01-07 | US | North Dakota | Adams | 38001 | 480 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-01-08 04:21:53 | Adams, North Dakota, US | |
2612433 | 2612433 | 2022-01-06 | US | North Dakota | Adams | 38001 | 480 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-01-07 04:22:09 | Adams, North Dakota, US | |
3520714 | 3520714 | 2022-01-02 | US | Kansas | Edwards | 20047 | 480 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-01-03 02:22:25 | Edwards, Kansas, US | |
2169995 | 2169995 | 2022-01-01 | US | North Dakota | Towner | 38095 | 480 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-02 04:20:52 | Towner, North Dakota, US | |
2168844 | 2168844 | 2022-01-01 | US | Kansas | Edwards | 20047 | 480 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-01-02 04:20:52 | Edwards, Kansas, US | |
2779426 | 2779426 | 2021-12-31 | US | North Dakota | Towner | 38095 | 480 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-01 04:22:14 | Towner, North Dakota, US | |
2778275 | 2778275 | 2021-12-31 | US | Kansas | Edwards | 20047 | 480 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-01-01 04:22:14 | Edwards, Kansas, US | |
3999932 | 3999932 | 2021-12-30 | US | Kansas | Edwards | 20047 | 480 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-12-31 04:21:50 | Edwards, Kansas, US | |
1669739 | 1669739 | 2021-12-29 | US | Kansas | Edwards | 20047 | 480 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-12-30 04:21:25 | Edwards, Kansas, US | |
2113022 | 2113022 | 2021-12-26 | US | Kansas | Morton | 20129 | 480 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-27 04:21:58 | Morton, Kansas, US | |
3606394 | 3606394 | 2021-12-25 | US | Kansas | Morton | 20129 | 480 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-26 04:21:50 | Morton, Kansas, US | |
2964712 | 2964712 | 2021-12-24 | US | Kansas | Morton | 20129 | 480 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-25 04:21:37 | Morton, Kansas, US | |
3817744 | 3817744 | 2021-12-23 | US | Kansas | Morton | 20129 | 480 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-24 04:21:34 | Morton, Kansas, US | |
799752 | 799752 | 2021-12-22 | US | Kansas | Morton | 20129 | 480 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-23 04:21:21 | Morton, Kansas, US | |
3499102 | 3499102 | 2021-12-15 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-16 04:22:11 | Ziebach, South Dakota, US | |
2090887 | 2090887 | 2021-12-14 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-15 03:22:16 | Ziebach, South Dakota, US | |
785304 | 785304 | 2021-12-13 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-14 04:22:38 | Ziebach, South Dakota, US | |
1663339 | 1663339 | 2021-12-12 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-13 04:22:02 | Ziebach, South Dakota, US | |
1667355 | 1667355 | 2021-12-11 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-12 04:22:12 | Ziebach, South Dakota, US | |
3658507 | 3658507 | 2021-12-10 | US | South Dakota | Ziebach | 46137 | 480 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-11 04:22:45 | Ziebach, South Dakota, 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]);