johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
665 rows where confirmed = 713 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 605
- San Marino 20
- China 10
- Japan 4
- Malaysia 3
- Sao Tome and Principe 3
- Ukraine 3
- United Kingdom 2
- Andorra 1
- Belize 1
- Bulgaria 1
- Canada 1
- Chile 1
- Colombia 1
- Costa Rica 1
- Croatia 1
- Georgia 1
- Libya 1
- Mexico 1
- Netherlands 1
- Niger 1
- Paraguay 1
- Saint Lucia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557861 | 2557861 | 2022-11-29 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-30 04:21:07 | Cheyenne, Kansas, US | |
1241858 | 1241858 | 2022-11-28 | US | New Mexico | De Baca | 35011 | 713 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-11-29 04:21:05 | De Baca, New Mexico, US | |
1240935 | 1240935 | 2022-11-28 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-29 04:21:05 | Cheyenne, Kansas, US | |
3552923 | 3552923 | 2022-11-27 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-28 04:21:02 | Cheyenne, Kansas, US | |
2101403 | 2101403 | 2022-11-26 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-27 04:21:05 | Cheyenne, Kansas, US | |
488894 | 488894 | 2022-11-25 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-26 04:21:11 | Cheyenne, Kansas, US | |
3524723 | 3524723 | 2022-11-24 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-25 04:21:06 | Cheyenne, Kansas, US | |
3313506 | 3313506 | 2022-11-23 | US | Kansas | Cheyenne | 20023 | 713 | 16 | 0 | 39.78580976 | -101.7318201 | 2022-11-24 04:21:09 | Cheyenne, Kansas, US | |
3756914 | 3756914 | 2022-10-13 | US | Washington | Columbia | 53013 | 713 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-10-14 04:22:28 | Columbia, Washington, US | |
3217739 | 3217739 | 2022-10-12 | US | Washington | Columbia | 53013 | 713 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-10-13 04:22:39 | Columbia, Washington, US | |
3251487 | 3251487 | 2022-10-11 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-12 04:22:51 | Rawlins, Kansas, US | |
2968746 | 2968746 | 2022-10-10 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-11 04:23:05 | Rawlins, Kansas, US | |
3098782 | 3098782 | 2022-10-09 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-10 04:22:32 | Rawlins, Kansas, US | |
4004007 | 4004007 | 2022-10-08 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-09 04:21:16 | Rawlins, Kansas, US | |
397604 | 397604 | 2022-10-07 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-08 04:22:56 | Rawlins, Kansas, US | |
2530721 | 2530721 | 2022-10-06 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-07 04:23:08 | Rawlins, Kansas, US | |
1812115 | 1812115 | 2022-10-05 | US | Kansas | Rawlins | 20153 | 713 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-10-06 04:21:22 | Rawlins, Kansas, US | |
3997072 | 3997072 | 2022-09-27 | US | North Dakota | Towner | 38095 | 713 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-09-28 04:23:01 | Towner, North Dakota, US | |
2771400 | 2771400 | 2022-09-26 | US | North Dakota | Towner | 38095 | 713 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-09-27 04:23:01 | Towner, North Dakota, US | |
959338 | 959338 | 2022-07-19 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-20 04:20:59 | Wrangell, Alaska, US | |
3210725 | 3210725 | 2022-07-18 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-19 04:20:58 | Wrangell, Alaska, US | |
3405900 | 3405900 | 2022-07-17 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-18 04:20:59 | Wrangell, Alaska, US | |
2152100 | 2152100 | 2022-07-16 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-17 04:21:15 | Wrangell, Alaska, US | |
2422111 | 2422111 | 2022-07-15 | US | Texas | Shackelford | 48417 | 713 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-07-16 04:21:05 | Shackelford, Texas, US | |
2419333 | 2419333 | 2022-07-15 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-16 04:21:05 | Wrangell, Alaska, US | |
3432186 | 3432186 | 2022-07-14 | US | Texas | Shackelford | 48417 | 713 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-07-15 04:20:53 | Shackelford, Texas, US | |
3429408 | 3429408 | 2022-07-14 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-15 04:20:53 | Wrangell, Alaska, US | |
3109928 | 3109928 | 2022-07-13 | US | Alaska | Wrangell | 2275 | 713 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-07-14 04:20:57 | Wrangell, Alaska, US | |
630352 | 630352 | 2022-07-12 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-13 04:20:58 | Yakutat, Alaska, US | |
1211996 | 1211996 | 2022-07-11 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-12 04:20:51 | Yakutat, Alaska, US | |
2791446 | 2791446 | 2022-07-10 | US | North Dakota | McIntosh | 38051 | 713 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-11 04:20:46 | McIntosh, North Dakota, US | |
2789478 | 2789478 | 2022-07-10 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-11 04:20:46 | Yakutat, Alaska, US | |
144399 | 144399 | 2022-07-09 | US | North Dakota | McIntosh | 38051 | 713 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-10 04:20:54 | McIntosh, North Dakota, US | |
142431 | 142431 | 2022-07-09 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-10 04:20:54 | Yakutat, Alaska, US | |
1419499 | 1419499 | 2022-07-08 | US | North Dakota | McIntosh | 38051 | 713 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-09 04:20:59 | McIntosh, North Dakota, US | |
1417531 | 1417531 | 2022-07-08 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-09 04:20:59 | Yakutat, Alaska, US | |
2741456 | 2741456 | 2022-07-07 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-08 04:20:56 | Yakutat, Alaska, US | |
1200251 | 1200251 | 2022-07-06 | US | Alaska | Yakutat | 2282 | 713 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-07-07 04:20:55 | Yakutat, Alaska, US | |
1763941 | 1763941 | 2022-06-20 | US | Colorado | Custer | 8027 | 713 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-06-21 04:20:56 | Custer, Colorado, US | |
3727136 | 3727136 | 2022-06-07 | US | Idaho | Adams | 16003 | 713 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-06-08 04:20:55 | Adams, Idaho, US | |
3888538 | 3888538 | 2022-06-06 | US | Idaho | Adams | 16003 | 713 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-06-07 04:21:08 | Adams, Idaho, US | |
3887404 | 3887404 | 2022-06-06 | China | Chongqing | 713 | 6 | 0 | 30.0572 | 107.874 | 2022-06-07 04:21:08 | Chongqing, China | |||
3507173 | 3507173 | 2022-06-05 | China | Chongqing | 713 | 6 | 0 | 30.0572 | 107.874 | 2022-06-06 04:20:57 | Chongqing, China | |||
3527250 | 3527250 | 2022-06-04 | China | Chongqing | 713 | 6 | 0 | 30.0572 | 107.874 | 2022-06-05 04:20:55 | Chongqing, China | |||
3133336 | 3133336 | 2022-06-03 | China | Chongqing | 713 | 6 | 0 | 30.0572 | 107.874 | 2022-06-04 04:20:58 | Chongqing, China | |||
3578411 | 3578411 | 2022-06-02 | China | Chongqing | 713 | 6 | 0 | 30.0572 | 107.874 | 2022-06-03 04:20:58 | Chongqing, China | |||
224128 | 224128 | 2022-05-09 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-10 04:20:50 | Webster, Nebraska, US | |
2333513 | 2333513 | 2022-05-08 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-09 04:20:54 | Webster, Nebraska, US | |
363487 | 363487 | 2022-05-07 | US | Texas | Kimble | 48267 | 713 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-05-08 04:20:49 | Kimble, Texas, US | |
362475 | 362475 | 2022-05-07 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-08 04:20:49 | Webster, Nebraska, US | |
1400838 | 1400838 | 2022-05-06 | US | Texas | Kimble | 48267 | 713 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-05-07 04:21:09 | Kimble, Texas, US | |
1399826 | 1399826 | 2022-05-06 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-07 04:21:09 | Webster, Nebraska, US | |
2600181 | 2600181 | 2022-05-05 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-06 04:21:00 | Webster, Nebraska, US | |
3267630 | 3267630 | 2022-05-04 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-05 04:20:55 | Webster, Nebraska, US | |
1574269 | 1574269 | 2022-05-03 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-05-04 04:20:59 | Webster, Nebraska, US | |
3724334 | 3724334 | 2022-04-25 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-26 04:20:51 | Webster, Nebraska, US | |
2030902 | 2030902 | 2022-04-24 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-25 04:20:56 | Webster, Nebraska, US | |
748477 | 748477 | 2022-04-23 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-24 04:20:56 | Webster, Nebraska, US | |
3438962 | 3438962 | 2022-04-22 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-23 04:20:50 | Webster, Nebraska, US | |
2894547 | 2894547 | 2022-04-21 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-22 04:20:45 | Webster, Nebraska, US | |
2309419 | 2309419 | 2022-04-20 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-21 04:20:46 | Webster, Nebraska, US | |
2253558 | 2253558 | 2022-04-19 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-20 04:20:45 | Webster, Nebraska, US | |
1848108 | 1848108 | 2022-04-18 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-19 04:21:00 | Webster, Nebraska, US | |
3419052 | 3419052 | 2022-04-17 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-18 04:21:12 | Webster, Nebraska, US | |
306001 | 306001 | 2022-04-16 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-17 04:20:59 | Webster, Nebraska, US | |
2671946 | 2671946 | 2022-04-15 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-16 04:20:48 | Webster, Nebraska, US | |
1225731 | 1225731 | 2022-04-14 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-15 04:20:57 | Webster, Nebraska, US | |
2444889 | 2444889 | 2022-04-13 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-13 23:21:06 | Webster, Nebraska, US | |
1950646 | 1950646 | 2022-04-12 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-13 04:21:03 | Webster, Nebraska, US | |
3208399 | 3208399 | 2022-04-11 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-12 04:20:49 | Webster, Nebraska, US | |
1578285 | 1578285 | 2022-04-10 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-11 04:21:02 | Webster, Nebraska, US | |
1654527 | 1654527 | 2022-04-09 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-10 04:20:52 | Webster, Nebraska, US | |
2117849 | 2117849 | 2022-04-08 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-09 04:20:42 | Webster, Nebraska, US | |
2751020 | 2751020 | 2022-04-04 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-05 04:20:48 | Webster, Nebraska, US | |
3732366 | 3732366 | 2022-04-03 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-04 04:20:51 | Webster, Nebraska, US | |
501801 | 501801 | 2022-04-02 | US | Nebraska | Webster | 31181 | 713 | 10 | 0 | 40.17642643 | -98.50019851 | 2022-04-03 04:20:48 | Webster, Nebraska, US | |
3022885 | 3022885 | 2022-03-23 | US | Colorado | Costilla | 8023 | 713 | 16 | 0 | 37.27732493 | -105.4276548 | 2022-03-24 04:20:43 | Costilla, Colorado, US | |
73295 | 73295 | 2022-02-07 | US | New Mexico | Mora | 35033 | 713 | 16 | 0 | 36.01095101 | -104.9497716 | 2022-02-08 04:21:15 | Mora, New Mexico, US | |
3812349 | 3812349 | 2022-01-28 | US | North Dakota | Nelson | 38063 | 713 | 17 | 0 | 47.9226426 | -98.19038437 | 2022-01-29 04:21:10 | Nelson, North Dakota, US | |
2053211 | 2053211 | 2022-01-25 | US | Kansas | Osborne | 20141 | 713 | 15 | 0 | 39.3503437 | -98.76753828 | 2022-01-26 04:21:07 | Osborne, Kansas, US | |
2052834 | 2052834 | 2022-01-25 | US | Idaho | Oneida | 16071 | 713 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2022-01-26 04:21:07 | Oneida, Idaho, US | |
1229717 | 1229717 | 2022-01-24 | US | Nebraska | Nance | 31125 | 713 | 10 | 0 | 41.39750195 | -97.99327291 | 2022-01-25 04:21:05 | Nance, Nebraska, US | |
1229031 | 1229031 | 2022-01-24 | US | Kentucky | Hickman | 21105 | 713 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2022-01-25 04:21:05 | Hickman, Kentucky, US | |
1228942 | 1228942 | 2022-01-24 | US | Kansas | Osborne | 20141 | 713 | 15 | 0 | 39.3503437 | -98.76753828 | 2022-01-25 04:21:05 | Osborne, Kansas, US | |
1144218 | 1144218 | 2022-01-23 | US | Virginia | Bath | 51017 | 713 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-24 04:21:12 | Bath, Virginia, US | |
1141515 | 1141515 | 2022-01-23 | US | Colorado | Baca | 8009 | 713 | 8 | 0 | 37.31940883 | -102.5603223 | 2022-01-24 04:21:12 | Baca, Colorado, US | |
2836136 | 2836136 | 2022-01-22 | US | Virginia | Bath | 51017 | 713 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-23 04:21:13 | Bath, Virginia, US | |
2836034 | 2836034 | 2022-01-22 | US | Texas | Real | 48385 | 713 | 22 | 0 | 29.83321503 | -99.82018052 | 2022-01-23 04:21:13 | Real, Texas, US | |
3428254 | 3428254 | 2022-01-21 | US | Virginia | Bath | 51017 | 713 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-22 04:21:13 | Bath, Virginia, US | |
3427605 | 3427605 | 2022-01-21 | US | Pennsylvania | Cameron | 42023 | 713 | 16 | 0 | 41.43625568 | -78.20376845 | 2022-01-22 04:21:13 | Cameron, Pennsylvania, US | |
3467227 | 3467227 | 2022-01-18 | US | Texas | Cochran | 48079 | 713 | 21 | 0 | 33.60425307 | -102.82844990000001 | 2022-01-19 04:21:23 | Cochran, Texas, US | |
3522724 | 3522724 | 2022-01-02 | US | Vermont | Unassigned | 90050 | 713 | 0 | 0 | 44.85627605 | 0.0 | 2022-01-03 02:22:25 | Unassigned, Vermont, US | |
2170854 | 2170854 | 2022-01-01 | US | Vermont | Unassigned | 90050 | 713 | 0 | 0 | 44.85627605 | 0.0 | 2022-01-02 04:20:52 | Unassigned, Vermont, US | |
2780285 | 2780285 | 2021-12-31 | US | Vermont | Unassigned | 90050 | 713 | 0 | 0 | 44.85627605 | 0.0 | 2022-01-01 04:22:14 | Unassigned, Vermont, US | |
4001942 | 4001942 | 2021-12-30 | US | Vermont | Unassigned | 90050 | 713 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-31 04:21:50 | Unassigned, Vermont, US | |
1433865 | 1433865 | 2021-12-28 | US | Kansas | Haskell | 20081 | 713 | 9 | 0 | 37.562039399999996 | -100.8710738 | 2021-12-29 03:21:43 | Haskell, Kansas, US | |
731826 | 731826 | 2021-12-27 | US | Kansas | Haskell | 20081 | 713 | 9 | 0 | 37.562039399999996 | -100.8710738 | 2021-12-28 04:21:47 | Haskell, Kansas, US | |
801183 | 801183 | 2021-12-22 | US | Puerto Rico | Lajas | 72079 | 713 | 0 | 0 | 18.011661 | -67.040585 | 2021-12-23 04:21:21 | Lajas, Puerto Rico, US | |
800349 | 800349 | 2021-12-22 | US | Missouri | Knox | 29103 | 713 | 8 | 0 | 40.12699751 | -92.14780832 | 2021-12-23 04:21:21 | Knox, Missouri, US | |
3831795 | 3831795 | 2021-12-21 | US | Virginia | Craig | 51045 | 713 | 11 | 0 | 37.48133648 | -80.21072274 | 2021-12-22 04:21:54 | Craig, Virginia, 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]);