johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
436 rows where confirmed = 1765 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 407
- Bahamas 5
- China 5
- Sweden 4
- Guinea-Bissau 3
- Russia 3
- Japan 2
- Malaysia 2
- Netherlands 2
- Saint Vincent and the Grenadines 1
- Sierra Leone 1
- Slovakia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219879 | 219879 | 2022-12-26 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-27 04:21:07 | Dade, Missouri, US | |
3224336 | 3224336 | 2022-12-25 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-26 04:21:06 | Dade, Missouri, US | |
1020250 | 1020250 | 2022-12-24 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-25 04:21:04 | Dade, Missouri, US | |
692273 | 692273 | 2022-12-23 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-24 04:21:02 | Dade, Missouri, US | |
2181483 | 2181483 | 2022-12-22 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-23 04:21:04 | Dade, Missouri, US | |
453992 | 453992 | 2022-12-21 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-22 04:20:56 | Tillman, Oklahoma, US | |
453287 | 453287 | 2022-12-21 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-22 04:20:56 | Dade, Missouri, US | |
2953991 | 2953991 | 2022-12-20 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-21 04:21:03 | Tillman, Oklahoma, US | |
2953286 | 2953286 | 2022-12-20 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-21 04:21:03 | Dade, Missouri, US | |
3176393 | 3176393 | 2022-12-19 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-20 04:21:04 | Tillman, Oklahoma, US | |
1630910 | 1630910 | 2022-12-18 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-19 04:21:03 | Tillman, Oklahoma, US | |
506289 | 506289 | 2022-12-17 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-18 04:21:03 | Tillman, Oklahoma, US | |
3326861 | 3326861 | 2022-12-16 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-17 04:21:04 | Tillman, Oklahoma, US | |
545373 | 545373 | 2022-12-15 | US | Oklahoma | Tillman | 40141 | 1765 | 37 | 0 | 34.37288446 | -98.92426619 | 2022-12-16 04:21:01 | Tillman, Oklahoma, US | |
3554978 | 3554978 | 2022-11-27 | US | Virginia | Covington | 51580 | 1765 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-11-28 04:21:02 | Covington, Virginia, US | |
2103458 | 2103458 | 2022-11-26 | US | Virginia | Covington | 51580 | 1765 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-11-27 04:21:05 | Covington, Virginia, US | |
490949 | 490949 | 2022-11-25 | US | Virginia | Covington | 51580 | 1765 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-11-26 04:21:11 | Covington, Virginia, US | |
1623602 | 1623602 | 2022-11-22 | US | Virginia | Covington | 51580 | 1765 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-11-23 04:21:06 | Covington, Virginia, US | |
3995607 | 3995607 | 2022-09-27 | US | Illinois | Calhoun | 17013 | 1765 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-09-28 04:23:01 | Calhoun, Illinois, US | |
2769935 | 2769935 | 2022-09-26 | US | Illinois | Calhoun | 17013 | 1765 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-09-27 04:23:01 | Calhoun, Illinois, US | |
373043 | 373043 | 2022-09-13 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-14 04:20:44 | Marion, Georgia, US | |
2395645 | 2395645 | 2022-09-12 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-13 04:20:57 | Marion, Georgia, US | |
3766723 | 3766723 | 2022-09-11 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-12 04:20:58 | Marion, Georgia, US | |
3825298 | 3825298 | 2022-09-10 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-11 04:20:50 | Marion, Georgia, US | |
963755 | 963755 | 2022-09-09 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-10 04:21:10 | Marion, Georgia, US | |
254157 | 254157 | 2022-09-08 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-09 04:21:11 | Marion, Georgia, US | |
3745955 | 3745955 | 2022-09-07 | US | Georgia | Marion | 13197 | 1765 | 55 | 0 | 32.3483402 | -84.52733571 | 2022-09-08 04:21:02 | Marion, Georgia, US | |
115640 | 115640 | 2022-09-06 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-07 04:20:59 | Treutlen, Georgia, US | |
2634612 | 2634612 | 2022-09-05 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-06 04:21:02 | Treutlen, Georgia, US | |
2988176 | 2988176 | 2022-09-04 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-05 04:21:01 | Treutlen, Georgia, US | |
2713861 | 2713861 | 2022-09-03 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-04 04:21:22 | Treutlen, Georgia, US | |
1394566 | 1394566 | 2022-09-02 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-03 04:21:04 | Treutlen, Georgia, US | |
3549397 | 3549397 | 2022-09-01 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-09-02 04:21:07 | Clark, Missouri, US | |
3548395 | 3548395 | 2022-09-01 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-02 04:21:07 | Treutlen, Georgia, US | |
2345317 | 2345317 | 2022-08-31 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-09-01 04:21:03 | Clark, Missouri, US | |
2344315 | 2344315 | 2022-08-31 | US | Georgia | Treutlen | 13283 | 1765 | 66 | 0 | 32.40422134 | -82.56904553 | 2022-09-01 04:21:03 | Treutlen, Georgia, US | |
3775797 | 3775797 | 2022-08-30 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-08-31 04:20:57 | Clark, Missouri, US | |
1682393 | 1682393 | 2022-08-29 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-08-30 04:21:03 | Clark, Missouri, US | |
1878877 | 1878877 | 2022-08-28 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-08-29 04:21:06 | Clark, Missouri, US | |
2098004 | 2098004 | 2022-08-27 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-08-28 04:21:02 | Clark, Missouri, US | |
1533819 | 1533819 | 2022-08-26 | US | Missouri | Clark | 29045 | 1765 | 40 | 0 | 40.41040752 | -91.73661677 | 2022-08-27 04:20:57 | Clark, Missouri, US | |
2856485 | 2856485 | 2022-08-22 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-23 04:20:56 | Weston, Wyoming, US | |
2406457 | 2406457 | 2022-08-21 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-22 04:20:38 | Weston, Wyoming, US | |
3801535 | 3801535 | 2022-08-20 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-21 04:20:44 | Weston, Wyoming, US | |
2367121 | 2367121 | 2022-08-19 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-20 04:21:01 | Weston, Wyoming, US | |
1164792 | 1164792 | 2022-08-18 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-19 04:20:54 | Weston, Wyoming, US | |
3954116 | 3954116 | 2022-08-17 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-18 04:21:11 | Weston, Wyoming, US | |
994618 | 994618 | 2022-08-16 | US | Wyoming | Weston | 56045 | 1765 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-17 04:20:59 | Weston, Wyoming, US | |
3213318 | 3213318 | 2022-07-18 | US | Texas | Brooks | 48047 | 1765 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-07-19 04:20:58 | Brooks, Texas, US | |
2741622 | 2741622 | 2022-07-07 | US | Colorado | Clear Creek | 8019 | 1765 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-07-08 04:20:56 | Clear Creek, Colorado, US | |
3942098 | 3942098 | 2022-06-30 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-07-01 04:21:10 | Valley, Montana, US | |
3942005 | 3942005 | 2022-06-30 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-01 04:21:10 | Ozark, Missouri, US | |
2492056 | 2492056 | 2022-06-29 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-30 04:21:01 | Valley, Montana, US | |
2491963 | 2491963 | 2022-06-29 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-30 04:21:01 | Ozark, Missouri, US | |
2241438 | 2241438 | 2022-06-28 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-29 04:20:59 | Valley, Montana, US | |
2241345 | 2241345 | 2022-06-28 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-29 04:20:59 | Ozark, Missouri, US | |
2149680 | 2149680 | 2022-06-27 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-28 04:20:58 | Valley, Montana, US | |
2149587 | 2149587 | 2022-06-27 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-28 04:20:58 | Ozark, Missouri, US | |
477481 | 477481 | 2022-06-26 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-27 04:21:00 | Valley, Montana, US | |
477388 | 477388 | 2022-06-26 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-27 04:21:00 | Ozark, Missouri, US | |
940856 | 940856 | 2022-06-25 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-26 04:21:02 | Valley, Montana, US | |
940763 | 940763 | 2022-06-25 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-26 04:21:02 | Ozark, Missouri, US | |
3348676 | 3348676 | 2022-06-24 | US | Montana | Valley | 30105 | 1765 | 38 | 0 | 48.36435097 | -106.6669635 | 2022-06-25 04:20:57 | Valley, Montana, US | |
3348583 | 3348583 | 2022-06-24 | US | Missouri | Ozark | 29153 | 1765 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-25 04:20:57 | Ozark, Missouri, US | |
947387 | 947387 | 2022-06-14 | US | Arkansas | Woodruff | 5147 | 1765 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-15 04:20:54 | Woodruff, Arkansas, US | |
3727203 | 3727203 | 2022-06-07 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-08 04:20:55 | Edwards, Illinois, US | |
3888605 | 3888605 | 2022-06-06 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-07 04:21:08 | Edwards, Illinois, US | |
3508374 | 3508374 | 2022-06-05 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-06 04:20:57 | Edwards, Illinois, US | |
3528451 | 3528451 | 2022-06-04 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-05 04:20:55 | Edwards, Illinois, US | |
3134537 | 3134537 | 2022-06-03 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-04 04:20:58 | Edwards, Illinois, US | |
3579612 | 3579612 | 2022-06-02 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-03 04:20:58 | Edwards, Illinois, US | |
971905 | 971905 | 2022-06-01 | US | Illinois | Edwards | 17047 | 1765 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-02 05:20:39 | Edwards, Illinois, US | |
3000523 | 3000523 | 2022-05-24 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-25 04:20:56 | Lucas, Iowa, US | |
3594244 | 3594244 | 2022-05-23 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-24 04:20:57 | Lucas, Iowa, US | |
1110792 | 1110792 | 2022-05-21 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-22 04:20:52 | Lucas, Iowa, US | |
1110057 | 1110057 | 2022-05-21 | US | Arkansas | Dallas | 5039 | 1765 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-05-22 04:20:52 | Dallas, Arkansas, US | |
1170416 | 1170416 | 2022-05-20 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-21 04:20:58 | Lucas, Iowa, US | |
1169681 | 1169681 | 2022-05-20 | US | Arkansas | Dallas | 5039 | 1765 | 31 | 0 | 33.97042763 | -92.65167437 | 2022-05-21 04:20:58 | Dallas, Arkansas, US | |
3897179 | 3897179 | 2022-05-19 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-20 04:20:57 | Lucas, Iowa, US | |
1185963 | 1185963 | 2022-05-18 | US | Iowa | Lucas | 19117 | 1765 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-05-19 04:20:54 | Lucas, Iowa, US | |
1849182 | 1849182 | 2022-04-18 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-19 04:21:00 | Refugio, Texas, US | |
1847714 | 1847714 | 2022-04-18 | US | Minnesota | Mahnomen | 27087 | 1765 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-19 04:21:00 | Mahnomen, Minnesota, US | |
3420126 | 3420126 | 2022-04-17 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-18 04:21:12 | Refugio, Texas, US | |
3418658 | 3418658 | 2022-04-17 | US | Minnesota | Mahnomen | 27087 | 1765 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-18 04:21:12 | Mahnomen, Minnesota, US | |
307075 | 307075 | 2022-04-16 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-17 04:20:59 | Refugio, Texas, US | |
305607 | 305607 | 2022-04-16 | US | Minnesota | Mahnomen | 27087 | 1765 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-17 04:20:59 | Mahnomen, Minnesota, US | |
2673020 | 2673020 | 2022-04-15 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-16 04:20:48 | Refugio, Texas, US | |
2671552 | 2671552 | 2022-04-15 | US | Minnesota | Mahnomen | 27087 | 1765 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-16 04:20:48 | Mahnomen, Minnesota, US | |
1227024 | 1227024 | 2022-04-14 | US | Virginia | Williamsburg | 51830 | 1765 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-04-15 04:20:57 | Williamsburg, Virginia, US | |
1226805 | 1226805 | 2022-04-14 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-15 04:20:57 | Refugio, Texas, US | |
1225337 | 1225337 | 2022-04-14 | US | Minnesota | Mahnomen | 27087 | 1765 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-15 04:20:57 | Mahnomen, Minnesota, US | |
2445963 | 2445963 | 2022-04-13 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-13 23:21:06 | Refugio, Texas, US | |
1951720 | 1951720 | 2022-04-12 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-13 04:21:03 | Refugio, Texas, US | |
3209473 | 3209473 | 2022-04-11 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-12 04:20:49 | Refugio, Texas, US | |
1579359 | 1579359 | 2022-04-10 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-11 04:21:02 | Refugio, Texas, US | |
1655601 | 1655601 | 2022-04-09 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-10 04:20:52 | Refugio, Texas, US | |
2118923 | 2118923 | 2022-04-08 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-09 04:20:42 | Refugio, Texas, US | |
3323447 | 3323447 | 2022-04-07 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-08 04:20:48 | Refugio, Texas, US | |
2803983 | 2803983 | 2022-04-06 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-07 04:20:53 | Refugio, Texas, US | |
3870752 | 3870752 | 2022-04-05 | US | Texas | Refugio | 48391 | 1765 | 36 | 0 | 28.323897600000002 | -97.15766311 | 2022-04-06 04:20:49 | Refugio, Texas, 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]);