johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
666 rows where confirmed = 704 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717087 | 3717087 | 2022-12-06 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-07 04:20:58 | Ziebach, South Dakota, US | |
2417792 | 2417792 | 2022-12-05 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-06 04:21:03 | Ziebach, South Dakota, US | |
721400 | 721400 | 2022-12-04 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-05 04:20:58 | Ziebach, South Dakota, US | |
2819689 | 2819689 | 2022-12-03 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-04 04:20:56 | Ziebach, South Dakota, US | |
836545 | 836545 | 2022-12-02 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-03 04:21:02 | Ziebach, South Dakota, US | |
2139075 | 2139075 | 2022-12-01 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-02 04:21:07 | Ziebach, South Dakota, US | |
1967491 | 1967491 | 2022-11-30 | US | South Dakota | Ziebach | 46137 | 704 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-12-01 04:21:03 | Ziebach, South Dakota, US | |
2488198 | 2488198 | 2022-11-16 | US | New Mexico | De Baca | 35011 | 704 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-11-17 04:21:11 | De Baca, New Mexico, US | |
480864 | 480864 | 2022-11-08 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-09 04:21:22 | Cheyenne, Kansas, US | |
2440014 | 2440014 | 2022-11-07 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-08 04:21:21 | Cheyenne, Kansas, US | |
1051112 | 1051112 | 2022-11-06 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-07 04:21:26 | Cheyenne, Kansas, US | |
619136 | 619136 | 2022-11-05 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-06 04:21:24 | Cheyenne, Kansas, US | |
1023640 | 1023640 | 2022-11-04 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-05 04:21:52 | Cheyenne, Kansas, US | |
432631 | 432631 | 2022-11-03 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-04 04:22:11 | Cheyenne, Kansas, US | |
850873 | 850873 | 2022-11-02 | US | Kansas | Cheyenne | 20023 | 704 | 15 | 0 | 39.78580976 | -101.7318201 | 2022-11-03 04:22:05 | Cheyenne, Kansas, US | |
713331 | 713331 | 2022-11-01 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-11-02 04:22:09 | Hanson, South Dakota, US | |
3287780 | 3287780 | 2022-10-31 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-11-01 04:22:36 | Hanson, South Dakota, US | |
322813 | 322813 | 2022-10-30 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-10-31 04:21:36 | Hanson, South Dakota, US | |
915089 | 915089 | 2022-10-29 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-10-30 04:22:14 | Hanson, South Dakota, US | |
1369358 | 1369358 | 2022-10-28 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-10-29 04:21:13 | Hanson, South Dakota, US | |
3041213 | 3041213 | 2022-10-27 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-10-28 04:22:31 | Hanson, South Dakota, US | |
541633 | 541633 | 2022-10-26 | US | South Dakota | Hanson | 46061 | 704 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-10-27 04:22:01 | Hanson, South Dakota, US | |
373551 | 373551 | 2022-09-13 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-14 04:20:44 | Smith, Kansas, US | |
2396153 | 2396153 | 2022-09-12 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-13 04:20:57 | Smith, Kansas, US | |
3767231 | 3767231 | 2022-09-11 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-12 04:20:58 | Smith, Kansas, US | |
3825806 | 3825806 | 2022-09-10 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-11 04:20:50 | Smith, Kansas, US | |
964263 | 964263 | 2022-09-09 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-10 04:21:10 | Smith, Kansas, US | |
254665 | 254665 | 2022-09-08 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-09 04:21:11 | Smith, Kansas, US | |
3746463 | 3746463 | 2022-09-07 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-08 04:21:02 | Smith, Kansas, US | |
117185 | 117185 | 2022-09-06 | US | North Dakota | Towner | 38095 | 704 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-09-07 04:20:59 | Towner, North Dakota, US | |
116103 | 116103 | 2022-09-06 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-07 04:20:59 | Smith, Kansas, US | |
2635075 | 2635075 | 2022-09-05 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-06 04:21:02 | Smith, Kansas, US | |
2988639 | 2988639 | 2022-09-04 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-05 04:21:01 | Smith, Kansas, US | |
2714324 | 2714324 | 2022-09-03 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-04 04:21:22 | Smith, Kansas, US | |
1395029 | 1395029 | 2022-09-02 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-03 04:21:04 | Smith, Kansas, US | |
3548858 | 3548858 | 2022-09-01 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-02 04:21:07 | Smith, Kansas, US | |
2344778 | 2344778 | 2022-08-31 | US | Kansas | Smith | 20183 | 704 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-09-01 04:21:03 | Smith, Kansas, US | |
1087412 | 1087412 | 2022-08-09 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-10 04:20:57 | Rawlins, Kansas, US | |
3544827 | 3544827 | 2022-08-08 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-09 04:20:34 | Rawlins, Kansas, US | |
1071230 | 1071230 | 2022-08-07 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-08 04:21:08 | Rawlins, Kansas, US | |
1941818 | 1941818 | 2022-08-06 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-07 04:20:54 | Rawlins, Kansas, US | |
881617 | 881617 | 2022-08-05 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-06 04:20:56 | Rawlins, Kansas, US | |
2010028 | 2010028 | 2022-08-04 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-05 04:20:52 | Rawlins, Kansas, US | |
1099455 | 1099455 | 2022-08-03 | US | Kansas | Rawlins | 20153 | 704 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-08-04 04:20:58 | Rawlins, Kansas, US | |
169265 | 169265 | 2022-06-21 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-22 04:20:54 | Shackelford, Texas, US | |
1766548 | 1766548 | 2022-06-20 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-21 04:20:56 | Shackelford, Texas, US | |
3272734 | 3272734 | 2022-06-19 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-20 04:21:01 | Shackelford, Texas, US | |
3400646 | 3400646 | 2022-06-18 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-19 04:20:51 | Shackelford, Texas, US | |
2314523 | 2314523 | 2022-06-17 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-18 04:21:10 | Shackelford, Texas, US | |
562027 | 562027 | 2022-06-16 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-17 04:20:56 | Shackelford, Texas, US | |
3985829 | 3985829 | 2022-06-15 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-16 04:20:55 | Shackelford, Texas, US | |
950070 | 950070 | 2022-06-14 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-15 04:20:54 | Shackelford, Texas, US | |
949751 | 949751 | 2022-06-14 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-15 04:20:54 | Potter, South Dakota, US | |
2982478 | 2982478 | 2022-06-13 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-14 04:20:52 | Shackelford, Texas, US | |
2982159 | 2982159 | 2022-06-13 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-14 04:20:52 | Potter, South Dakota, US | |
2238604 | 2238604 | 2022-06-12 | US | Texas | Shackelford | 48417 | 704 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-13 04:21:14 | Shackelford, Texas, US | |
2238285 | 2238285 | 2022-06-12 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-13 04:21:14 | Potter, South Dakota, US | |
3144483 | 3144483 | 2022-06-11 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-12 04:20:53 | Potter, South Dakota, US | |
1947399 | 1947399 | 2022-06-10 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-11 04:21:01 | Potter, South Dakota, US | |
3160538 | 3160538 | 2022-06-09 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-10 04:20:55 | Potter, South Dakota, US | |
1424005 | 1424005 | 2022-06-08 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-09 04:20:54 | Potter, South Dakota, US | |
3729119 | 3729119 | 2022-06-07 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-08 04:20:55 | Potter, South Dakota, US | |
3726831 | 3726831 | 2022-06-07 | US | Colorado | Custer | 8027 | 704 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-06-08 04:20:55 | Custer, Colorado, US | |
3890521 | 3890521 | 2022-06-06 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-07 04:21:08 | Potter, South Dakota, US | |
3510290 | 3510290 | 2022-06-05 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-06 04:20:57 | Potter, South Dakota, US | |
3530367 | 3530367 | 2022-06-04 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-05 04:20:55 | Potter, South Dakota, US | |
3136453 | 3136453 | 2022-06-03 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-04 04:20:58 | Potter, South Dakota, US | |
3581528 | 3581528 | 2022-06-02 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-03 04:20:58 | Potter, South Dakota, US | |
973821 | 973821 | 2022-06-01 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-02 05:20:39 | Potter, South Dakota, US | |
3189605 | 3189605 | 2022-05-30 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-31 04:20:51 | Niobrara, Wyoming, US | |
3188270 | 3188270 | 2022-05-30 | US | New York | Unassigned | 90036 | 704 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-31 04:20:51 | Unassigned, New York, US | |
3201754 | 3201754 | 2022-05-29 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-30 04:20:50 | Niobrara, Wyoming, US | |
3200419 | 3200419 | 2022-05-29 | US | New York | Unassigned | 90036 | 704 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-30 04:20:50 | Unassigned, New York, US | |
2728632 | 2728632 | 2022-05-28 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-29 04:20:53 | Niobrara, Wyoming, US | |
2727297 | 2727297 | 2022-05-28 | US | New York | Unassigned | 90036 | 704 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-29 04:20:53 | Unassigned, New York, US | |
1317813 | 1317813 | 2022-05-27 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-28 04:21:07 | Niobrara, Wyoming, US | |
1316478 | 1316478 | 2022-05-27 | US | New York | Unassigned | 90036 | 704 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-28 04:21:07 | Unassigned, New York, US | |
1853605 | 1853605 | 2022-05-26 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-27 04:20:56 | Niobrara, Wyoming, US | |
2051481 | 2051481 | 2022-05-25 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-26 04:20:50 | Niobrara, Wyoming, US | |
3002919 | 3002919 | 2022-05-24 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-25 04:20:56 | Niobrara, Wyoming, US | |
625492 | 625492 | 2022-05-22 | US | Wyoming | Niobrara | 56027 | 704 | 10 | 0 | 43.05607708 | -104.4758896 | 2022-05-26 04:20:50 | Niobrara, Wyoming, US | |
3897895 | 3897895 | 2022-05-19 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-20 04:20:57 | Mercer, Missouri, US | |
1186679 | 1186679 | 2022-05-18 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-19 04:20:54 | Mercer, Missouri, US | |
3584576 | 3584576 | 2022-05-17 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-18 04:20:50 | Mercer, Missouri, US | |
3583561 | 3583561 | 2022-05-17 | US | Idaho | Adams | 16003 | 704 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-18 04:20:50 | Adams, Idaho, US | |
1505533 | 1505533 | 2022-05-16 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-17 04:20:59 | Mercer, Missouri, US | |
1504518 | 1504518 | 2022-05-16 | US | Idaho | Adams | 16003 | 704 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-17 04:20:59 | Adams, Idaho, US | |
2085892 | 2085892 | 2022-05-15 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-16 04:20:47 | Mercer, Missouri, US | |
2084877 | 2084877 | 2022-05-15 | US | Idaho | Adams | 16003 | 704 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-16 04:20:47 | Adams, Idaho, US | |
3356602 | 3356602 | 2022-05-14 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-15 04:20:53 | Mercer, Missouri, US | |
3355587 | 3355587 | 2022-05-14 | US | Idaho | Adams | 16003 | 704 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-15 04:20:53 | Adams, Idaho, US | |
660247 | 660247 | 2022-05-13 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-14 04:20:48 | Mercer, Missouri, US | |
659232 | 659232 | 2022-05-13 | US | Idaho | Adams | 16003 | 704 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-14 04:20:48 | Adams, Idaho, US | |
2535330 | 2535330 | 2022-05-12 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-13 04:20:51 | Mercer, Missouri, US | |
3446776 | 3446776 | 2022-05-11 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-12 04:20:54 | Mercer, Missouri, US | |
3538361 | 3538361 | 2022-05-10 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-11 04:20:48 | Potter, South Dakota, US | |
3537393 | 3537393 | 2022-05-10 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-11 04:20:48 | Mercer, Missouri, US | |
224896 | 224896 | 2022-05-09 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-10 04:20:50 | Potter, South Dakota, US | |
223928 | 223928 | 2022-05-09 | US | Missouri | Mercer | 29129 | 704 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-05-10 04:20:50 | Mercer, Missouri, US | |
2334281 | 2334281 | 2022-05-08 | US | South Dakota | Potter | 46107 | 704 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-09 04:20:54 | Potter, 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]);