johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,128 rows where confirmed = 180 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 1,013
- China 25
- United Kingdom 18
- Japan 17
- Brunei 9
- Australia 6
- Grenada 6
- Barbados 5
- Malaysia 4
- Russia 4
- Burma 3
- Congo (Kinshasa) 3
- Canada 2
- New Zealand 2
- Burkina Faso 1
- Colombia 1
- Guatemala 1
- Iceland 1
- India 1
- Latvia 1
- Mexico 1
- Netherlands 1
- Spain 1
- Ukraine 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1984785 | 1984785 | 2022-12-07 | New Zealand | Niue | 180 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-08 04:21:07 | Niue, New Zealand | |||
3714308 | 3714308 | 2022-12-06 | New Zealand | Niue | 180 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-07 04:20:58 | Niue, New Zealand | |||
2558741 | 2558741 | 2022-11-29 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-30 04:21:07 | Storey, Nevada, US | |
1241815 | 1241815 | 2022-11-28 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-29 04:21:05 | Storey, Nevada, US | |
3553803 | 3553803 | 2022-11-27 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-28 04:21:02 | Storey, Nevada, US | |
2102283 | 2102283 | 2022-11-26 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-27 04:21:05 | Storey, Nevada, US | |
489774 | 489774 | 2022-11-25 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-26 04:21:11 | Storey, Nevada, US | |
3525603 | 3525603 | 2022-11-24 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-25 04:21:06 | Storey, Nevada, US | |
3314386 | 3314386 | 2022-11-23 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-24 04:21:09 | Storey, Nevada, US | |
1622427 | 1622427 | 2022-11-22 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-23 04:21:06 | Storey, Nevada, US | |
3462315 | 3462315 | 2022-11-21 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-22 04:20:47 | Storey, Nevada, US | |
1642500 | 1642500 | 2022-11-20 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-21 04:21:05 | Storey, Nevada, US | |
2066057 | 2066057 | 2022-11-19 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-20 04:21:08 | Storey, Nevada, US | |
1757451 | 1757451 | 2022-11-18 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-19 04:21:14 | Storey, Nevada, US | |
3028444 | 3028444 | 2022-11-17 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-18 04:21:15 | Storey, Nevada, US | |
2488155 | 2488155 | 2022-11-16 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-17 04:21:11 | Storey, Nevada, US | |
294166 | 294166 | 2022-11-15 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-16 04:21:09 | Storey, Nevada, US | |
294158 | 294158 | 2022-11-15 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-16 04:21:09 | Eureka, Nevada, US | |
3599196 | 3599196 | 2022-11-14 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-15 04:21:16 | Storey, Nevada, US | |
3599188 | 3599188 | 2022-11-14 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-15 04:21:16 | Eureka, Nevada, US | |
314054 | 314054 | 2022-11-13 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-14 04:21:09 | Storey, Nevada, US | |
314046 | 314046 | 2022-11-13 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-14 04:21:09 | Eureka, Nevada, US | |
65215 | 65215 | 2022-11-12 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-13 04:21:14 | Storey, Nevada, US | |
65207 | 65207 | 2022-11-12 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-13 04:21:14 | Eureka, Nevada, US | |
2929377 | 2929377 | 2022-11-11 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-12 04:20:41 | Storey, Nevada, US | |
2929369 | 2929369 | 2022-11-11 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-12 04:20:41 | Eureka, Nevada, US | |
2508213 | 2508213 | 2022-11-10 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-11 04:21:22 | Storey, Nevada, US | |
2508205 | 2508205 | 2022-11-10 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-11 04:21:22 | Eureka, Nevada, US | |
2433088 | 2433088 | 2022-11-09 | US | Nevada | Storey | 32029 | 180 | 14 | 0 | 39.44875482 | -119.5250207 | 2022-11-10 04:21:16 | Storey, Nevada, US | |
2433080 | 2433080 | 2022-11-09 | US | Nevada | Eureka | 32011 | 180 | 2 | 0 | 39.98100864 | -116.2683204 | 2022-11-10 04:21:16 | Eureka, Nevada, US | |
2757584 | 2757584 | 2022-10-18 | US | Colorado | Unassigned | 90008 | 180 | 2 | 0 | 40.87595412 | 0.0 | 2022-10-19 04:22:26 | Unassigned, Colorado, US | |
2346600 | 2346600 | 2022-08-31 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-09-01 04:21:03 | McMullen, Texas, US | |
3777080 | 3777080 | 2022-08-30 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-31 04:20:57 | McMullen, Texas, US | |
1683676 | 1683676 | 2022-08-29 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-30 04:21:03 | McMullen, Texas, US | |
1880160 | 1880160 | 2022-08-28 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-29 04:21:06 | McMullen, Texas, US | |
2099287 | 2099287 | 2022-08-27 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-28 04:21:02 | McMullen, Texas, US | |
1535102 | 1535102 | 2022-08-26 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-27 04:20:57 | McMullen, Texas, US | |
2831989 | 2831989 | 2022-08-25 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-26 04:21:02 | McMullen, Texas, US | |
2326522 | 2326522 | 2022-08-24 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-25 04:21:13 | McMullen, Texas, US | |
1253931 | 1253931 | 2022-08-23 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-24 04:20:46 | McMullen, Texas, US | |
2856035 | 2856035 | 2022-08-22 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-23 04:20:56 | McMullen, Texas, US | |
2406007 | 2406007 | 2022-08-21 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-22 04:20:38 | McMullen, Texas, US | |
3801085 | 3801085 | 2022-08-20 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-21 04:20:44 | McMullen, Texas, US | |
2366671 | 2366671 | 2022-08-19 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-20 04:21:01 | McMullen, Texas, US | |
1164342 | 1164342 | 2022-08-18 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-19 04:20:54 | McMullen, Texas, US | |
3953666 | 3953666 | 2022-08-17 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-18 04:21:11 | McMullen, Texas, US | |
994168 | 994168 | 2022-08-16 | US | Texas | McMullen | 48311 | 180 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-08-17 04:20:59 | McMullen, Texas, US | |
2338605 | 2338605 | 2022-07-27 | US | Texas | Roberts | 48393 | 180 | 2 | 0 | 35.83809685 | -100.813175 | 2022-07-28 04:20:56 | Roberts, Texas, US | |
1490795 | 1490795 | 2022-07-26 | US | Texas | Roberts | 48393 | 180 | 2 | 0 | 35.83809685 | -100.813175 | 2022-07-27 04:21:04 | Roberts, Texas, US | |
2597241 | 2597241 | 2022-07-25 | US | Texas | Roberts | 48393 | 180 | 2 | 0 | 35.83809685 | -100.813175 | 2022-07-26 04:20:58 | Roberts, Texas, US | |
899356 | 899356 | 2022-07-24 | US | Texas | Roberts | 48393 | 180 | 2 | 0 | 35.83809685 | -100.813175 | 2022-07-25 04:20:51 | Roberts, Texas, US | |
94350 | 94350 | 2022-07-23 | US | Texas | Roberts | 48393 | 180 | 2 | 0 | 35.83809685 | -100.813175 | 2022-07-24 04:20:47 | Roberts, Texas, US | |
594287 | 594287 | 2022-07-01 | US | Colorado | Jackson | 8057 | 180 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-02 04:21:16 | Jackson, Colorado, US | |
3535898 | 3535898 | 2022-05-10 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-11 04:20:48 | Skagway, Alaska, US | |
222433 | 222433 | 2022-05-09 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-10 04:20:50 | Skagway, Alaska, US | |
2331818 | 2331818 | 2022-05-08 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-09 04:20:54 | Skagway, Alaska, US | |
2331170 | 2331170 | 2022-05-08 | China | Guizhou | 180 | 2 | 0 | 26.8154 | 106.8748 | 2022-05-09 04:20:54 | Guizhou, China | |||
360780 | 360780 | 2022-05-07 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-08 04:20:49 | Skagway, Alaska, US | |
360132 | 360132 | 2022-05-07 | China | Guizhou | 180 | 2 | 0 | 26.8154 | 106.8748 | 2022-05-08 04:20:49 | Guizhou, China | |||
1398131 | 1398131 | 2022-05-06 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-07 04:21:09 | Skagway, Alaska, US | |
1397483 | 1397483 | 2022-05-06 | China | Guizhou | 180 | 2 | 0 | 26.8154 | 106.8748 | 2022-05-07 04:21:09 | Guizhou, China | |||
2598486 | 2598486 | 2022-05-05 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-06 04:21:00 | Skagway, Alaska, US | |
2597838 | 2597838 | 2022-05-05 | China | Guizhou | 180 | 2 | 0 | 26.8154 | 106.8748 | 2022-05-06 04:21:00 | Guizhou, China | |||
3265935 | 3265935 | 2022-05-04 | US | Alaska | Skagway | 2230 | 180 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-05 04:20:55 | Skagway, Alaska, US | |
3323402 | 3323402 | 2022-04-07 | US | Texas | Loving | 48301 | 180 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-08 04:20:48 | Loving, Texas, US | |
2801829 | 2801829 | 2022-04-06 | US | Illinois | Unassigned | 90017 | 180 | 4293 | 0 | 42.36542373 | 0.0 | 2022-04-07 04:20:53 | Unassigned, Illinois, US | |
557887 | 557887 | 2022-01-16 | US | Texas | Glasscock | 48173 | 180 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-17 04:21:08 | Glasscock, Texas, US | |
3843608 | 3843608 | 2022-01-15 | US | Texas | Glasscock | 48173 | 180 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-16 04:21:12 | Glasscock, Texas, US | |
3615104 | 3615104 | 2022-01-12 | US | Montana | Wibaux | 30109 | 180 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-01-13 08:00:09 | Wibaux, Montana, US | |
1115629 | 1115629 | 2022-01-11 | US | Montana | Wibaux | 30109 | 180 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-01-12 04:21:44 | Wibaux, Montana, US | |
2780220 | 2780220 | 2021-12-31 | US | Texas | Sterling | 48431 | 180 | 5 | 0 | 31.82781912 | -101.05007459999999 | 2022-01-01 04:22:14 | Sterling, Texas, US | |
3403582 | 3403582 | 2021-11-30 | US | Nevada | Eureka | 32011 | 180 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-01 04:22:29 | Eureka, Nevada, US | |
152840 | 152840 | 2021-11-29 | US | South Dakota | Campbell | 46021 | 180 | 4 | 0 | 45.77074915 | -100.0510181 | 2021-11-30 04:22:53 | Campbell, South Dakota, US | |
3343929 | 3343929 | 2021-11-16 | US | Kansas | Lane | 20101 | 180 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-11-17 04:21:48 | Lane, Kansas, US | |
2288765 | 2288765 | 2021-11-15 | US | Kansas | Lane | 20101 | 180 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-11-16 04:21:10 | Lane, Kansas, US | |
47064 | 47064 | 2021-11-02 | US | Virginia | Highland | 51091 | 180 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-11-03 06:22:09 | Highland, Virginia, US | |
3514760 | 3514760 | 2021-11-01 | US | Virginia | Highland | 51091 | 180 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-11-02 04:22:03 | Highland, Virginia, US | |
291351 | 291351 | 2021-10-31 | US | Virginia | Highland | 51091 | 180 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-11-01 04:22:01 | Highland, Virginia, US | |
2724357 | 2724357 | 2021-10-30 | US | Virginia | Highland | 51091 | 180 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-10-31 04:22:08 | Highland, Virginia, US | |
570459 | 570459 | 2021-10-29 | US | Virginia | Highland | 51091 | 180 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-10-30 04:22:03 | Highland, Virginia, US | |
2126622 | 2126622 | 2021-10-21 | US | South Dakota | Hyde | 46069 | 180 | 1 | 0 | 44.54747703 | -99.48572582 | 2021-10-22 04:21:14 | Hyde, South Dakota, US | |
443961 | 443961 | 2021-10-20 | US | Colorado | Cheyenne | 8017 | 180 | 7 | 0 | 38.82777431 | -102.6032558 | 2021-10-21 04:21:18 | Cheyenne, Colorado, US | |
1493788 | 1493788 | 2021-10-12 | US | New Mexico | Catron | 35003 | 180 | 7 | 0 | 33.91514144 | -108.4046587 | 2021-10-13 04:20:51 | Catron, New Mexico, US | |
3832927 | 3832927 | 2021-10-05 | US | Alaska | Yakutat | 2282 | 180 | 2 | 0 | 59.890980799999994 | -140.36014509999998 | 2021-10-06 04:21:33 | Yakutat, Alaska, US | |
2078094 | 2078094 | 2021-09-26 | US | Nevada | Storey | 32029 | 180 | 4 | 0 | 39.44875482 | -119.5250207 | 2021-09-27 04:21:16 | Storey, Nevada, US | |
1726646 | 1726646 | 2021-09-25 | US | Nevada | Storey | 32029 | 180 | 4 | 0 | 39.44875482 | -119.5250207 | 2021-09-26 04:21:29 | Storey, Nevada, US | |
1923366 | 1923366 | 2021-09-24 | US | Nevada | Storey | 32029 | 180 | 4 | 0 | 39.44875482 | -119.5250207 | 2021-09-25 04:21:31 | Storey, Nevada, US | |
1389068 | 1389068 | 2021-09-13 | US | Washington | Garfield | 53023 | 180 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2021-09-14 04:21:41 | Garfield, Washington, US | |
70240 | 70240 | 2021-09-01 | US | Texas | Motley | 48345 | 180 | 8 | 0 | 34.07408766 | -100.77972199999999 | 2021-09-02 04:21:15 | Motley, Texas, US | |
513505 | 513505 | 2021-08-19 | US | Mississippi | Issaquena | 28055 | 180 | 6 | 0 | 32.72531359 | -90.97392828 | 2021-08-20 04:21:33 | Issaquena, Mississippi, US | |
2519984 | 2519984 | 2021-08-18 | US | Mississippi | Issaquena | 28055 | 180 | 6 | 0 | 32.72531359 | -90.97392828 | 2021-08-19 04:21:15 | Issaquena, Mississippi, US | |
2519884 | 2519884 | 2021-08-18 | US | Minnesota | Cook | 27031 | 180 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-08-19 04:21:15 | Cook, Minnesota, US | |
248877 | 248877 | 2021-08-17 | US | Wyoming | Niobrara | 56027 | 180 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-18 04:21:35 | Niobrara, Wyoming, US | |
247076 | 247076 | 2021-08-17 | US | Mississippi | Issaquena | 28055 | 180 | 6 | 0 | 32.72531359 | -90.97392828 | 2021-08-18 04:21:35 | Issaquena, Mississippi, US | |
1607840 | 1607840 | 2021-08-16 | US | Wyoming | Niobrara | 56027 | 180 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-17 04:21:49 | Niobrara, Wyoming, US | |
1606039 | 1606039 | 2021-08-16 | US | Mississippi | Issaquena | 28055 | 180 | 6 | 0 | 32.72531359 | -90.97392828 | 2021-08-17 04:21:49 | Issaquena, Mississippi, US | |
106934 | 106934 | 2021-08-15 | US | Wyoming | Niobrara | 56027 | 180 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-16 04:21:31 | Niobrara, Wyoming, US | |
103252 | 103252 | 2021-08-15 | Grenada | 180 | 1 | 0 | 12.1165 | -61.678999999999995 | 2021-08-16 04:21:31 | Grenada | ||||
511292 | 511292 | 2021-08-14 | US | Wyoming | Niobrara | 56027 | 180 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-15 04:21:41 | Niobrara, Wyoming, US | |
507610 | 507610 | 2021-08-14 | Grenada | 180 | 1 | 0 | 12.1165 | -61.678999999999995 | 2021-08-15 04:21:41 | Grenada |
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]);