johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
764 rows where confirmed = 657 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754911 | 2754911 | 2022-12-29 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-30 04:21:04 | Granite, Montana, US | |
1075917 | 1075917 | 2022-12-28 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-29 04:21:01 | Granite, Montana, US | |
329914 | 329914 | 2022-12-27 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-28 04:21:04 | Granite, Montana, US | |
219987 | 219987 | 2022-12-26 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-27 04:21:07 | Granite, Montana, US | |
3224444 | 3224444 | 2022-12-25 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-26 04:21:06 | Granite, Montana, US | |
1020358 | 1020358 | 2022-12-24 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-25 04:21:04 | Granite, Montana, US | |
692381 | 692381 | 2022-12-23 | US | Montana | Granite | 30039 | 657 | 10 | 0 | 46.4060522 | -113.4414186 | 2022-12-24 04:21:02 | Granite, Montana, US | |
2557874 | 2557874 | 2022-11-29 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-30 04:21:07 | Elk, Kansas, US | |
1240948 | 1240948 | 2022-11-28 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-29 04:21:05 | Elk, Kansas, US | |
3552936 | 3552936 | 2022-11-27 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-28 04:21:02 | Elk, Kansas, US | |
2101416 | 2101416 | 2022-11-26 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-27 04:21:05 | Elk, Kansas, US | |
488907 | 488907 | 2022-11-25 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-26 04:21:11 | Elk, Kansas, US | |
3524736 | 3524736 | 2022-11-24 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-25 04:21:06 | Elk, Kansas, US | |
3313519 | 3313519 | 2022-11-23 | US | Kansas | Elk | 20049 | 657 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-11-24 04:21:09 | Elk, Kansas, US | |
1052228 | 1052228 | 2022-11-06 | US | North Dakota | Adams | 38001 | 657 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-11-07 04:21:26 | Adams, North Dakota, US | |
620252 | 620252 | 2022-11-05 | US | North Dakota | Adams | 38001 | 657 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-11-06 04:21:24 | Adams, North Dakota, US | |
1024756 | 1024756 | 2022-11-04 | US | North Dakota | Adams | 38001 | 657 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-11-05 04:21:52 | Adams, North Dakota, US | |
713309 | 713309 | 2022-11-01 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-11-02 04:22:09 | Buffalo, South Dakota, US | |
3287758 | 3287758 | 2022-10-31 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-11-01 04:22:36 | Buffalo, South Dakota, US | |
322791 | 322791 | 2022-10-30 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-10-31 04:21:36 | Buffalo, South Dakota, US | |
915067 | 915067 | 2022-10-29 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-10-30 04:22:14 | Buffalo, South Dakota, US | |
1369336 | 1369336 | 2022-10-28 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-10-29 04:21:13 | Buffalo, South Dakota, US | |
3041191 | 3041191 | 2022-10-27 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-10-28 04:22:31 | Buffalo, South Dakota, US | |
541611 | 541611 | 2022-10-26 | US | South Dakota | Buffalo | 46017 | 657 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-10-27 04:22:01 | Buffalo, South Dakota, US | |
796611 | 796611 | 2022-10-24 | US | New Mexico | De Baca | 35011 | 657 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-10-25 04:21:53 | De Baca, New Mexico, US | |
2345985 | 2345985 | 2022-08-31 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-01 04:21:03 | Harmon, Oklahoma, US | |
3776465 | 3776465 | 2022-08-30 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-31 04:20:57 | Harmon, Oklahoma, US | |
3775185 | 3775185 | 2022-08-30 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-31 04:20:57 | Decatur, Kansas, US | |
1683061 | 1683061 | 2022-08-29 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-30 04:21:03 | Harmon, Oklahoma, US | |
1681781 | 1681781 | 2022-08-29 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-30 04:21:03 | Decatur, Kansas, US | |
1879545 | 1879545 | 2022-08-28 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-29 04:21:06 | Harmon, Oklahoma, US | |
1878265 | 1878265 | 2022-08-28 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-29 04:21:06 | Decatur, Kansas, US | |
2098672 | 2098672 | 2022-08-27 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-28 04:21:02 | Harmon, Oklahoma, US | |
2097392 | 2097392 | 2022-08-27 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-28 04:21:02 | Decatur, Kansas, US | |
1534487 | 1534487 | 2022-08-26 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-27 04:20:57 | Harmon, Oklahoma, US | |
1533207 | 1533207 | 2022-08-26 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-27 04:20:57 | Decatur, Kansas, US | |
2831374 | 2831374 | 2022-08-25 | US | Oklahoma | Harmon | 40057 | 657 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-08-26 04:21:02 | Harmon, Oklahoma, US | |
2830094 | 2830094 | 2022-08-25 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-26 04:21:02 | Decatur, Kansas, US | |
2324627 | 2324627 | 2022-08-24 | US | Kansas | Decatur | 20039 | 657 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-08-25 04:21:13 | Decatur, Kansas, US | |
1252069 | 1252069 | 2022-08-23 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-24 04:20:46 | Lincoln, Kansas, US | |
2854173 | 2854173 | 2022-08-22 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-23 04:20:56 | Lincoln, Kansas, US | |
2404145 | 2404145 | 2022-08-21 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-22 04:20:38 | Lincoln, Kansas, US | |
3799223 | 3799223 | 2022-08-20 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-21 04:20:44 | Lincoln, Kansas, US | |
2364809 | 2364809 | 2022-08-19 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-20 04:21:01 | Lincoln, Kansas, US | |
1162480 | 1162480 | 2022-08-18 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-19 04:20:54 | Lincoln, Kansas, US | |
3951804 | 3951804 | 2022-08-17 | US | Kansas | Lincoln | 20105 | 657 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-18 04:21:11 | Lincoln, Kansas, US | |
1488938 | 1488938 | 2022-07-26 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-27 04:21:04 | Smith, Kansas, US | |
2595384 | 2595384 | 2022-07-25 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-26 04:20:58 | Smith, Kansas, US | |
897499 | 897499 | 2022-07-24 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-25 04:20:51 | Smith, Kansas, US | |
92493 | 92493 | 2022-07-23 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-24 04:20:47 | Smith, Kansas, US | |
901515 | 901515 | 2022-07-22 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-23 04:20:53 | Smith, Kansas, US | |
671651 | 671651 | 2022-07-21 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-22 04:21:15 | Smith, Kansas, US | |
1609614 | 1609614 | 2022-07-20 | US | Kansas | Smith | 20183 | 657 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-07-21 04:21:10 | Smith, Kansas, US | |
3111198 | 3111198 | 2022-07-13 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-14 04:20:57 | Cook, Minnesota, US | |
631621 | 631621 | 2022-07-12 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-13 04:20:58 | Cook, Minnesota, US | |
1213265 | 1213265 | 2022-07-11 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-12 04:20:51 | Cook, Minnesota, US | |
2790747 | 2790747 | 2022-07-10 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-11 04:20:46 | Cook, Minnesota, US | |
143700 | 143700 | 2022-07-09 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-10 04:20:54 | Cook, Minnesota, US | |
1418800 | 1418800 | 2022-07-08 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-09 04:20:59 | Cook, Minnesota, US | |
2742725 | 2742725 | 2022-07-07 | US | Minnesota | Cook | 27031 | 657 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-07-08 04:20:56 | Cook, Minnesota, US | |
168922 | 168922 | 2022-06-21 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-22 04:20:54 | Hanson, South Dakota, US | |
1766205 | 1766205 | 2022-06-20 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-21 04:20:56 | Hanson, South Dakota, US | |
3272391 | 3272391 | 2022-06-19 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-20 04:21:01 | Hanson, South Dakota, US | |
3400303 | 3400303 | 2022-06-18 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-19 04:20:51 | Hanson, South Dakota, US | |
2314180 | 2314180 | 2022-06-17 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-18 04:21:10 | Hanson, South Dakota, US | |
561684 | 561684 | 2022-06-16 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-17 04:20:56 | Hanson, South Dakota, US | |
3985486 | 3985486 | 2022-06-15 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-16 04:20:55 | Hanson, South Dakota, US | |
949727 | 949727 | 2022-06-14 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-15 04:20:54 | Hanson, South Dakota, US | |
949283 | 949283 | 2022-06-14 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-15 04:20:54 | Towner, North Dakota, US | |
2982135 | 2982135 | 2022-06-13 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-14 04:20:52 | Hanson, South Dakota, US | |
2981691 | 2981691 | 2022-06-13 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-14 04:20:52 | Towner, North Dakota, US | |
2238261 | 2238261 | 2022-06-12 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-13 04:21:14 | Hanson, South Dakota, US | |
2237817 | 2237817 | 2022-06-12 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-13 04:21:14 | Towner, North Dakota, US | |
3144459 | 3144459 | 2022-06-11 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-12 04:20:53 | Hanson, South Dakota, US | |
3144015 | 3144015 | 2022-06-11 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-12 04:20:53 | Towner, North Dakota, US | |
1947375 | 1947375 | 2022-06-10 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-11 04:21:01 | Hanson, South Dakota, US | |
1946931 | 1946931 | 2022-06-10 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-11 04:21:01 | Towner, North Dakota, US | |
3160514 | 3160514 | 2022-06-09 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-10 04:20:55 | Hanson, South Dakota, US | |
3160070 | 3160070 | 2022-06-09 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-10 04:20:55 | Towner, North Dakota, US | |
1423981 | 1423981 | 2022-06-08 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-09 04:20:54 | Hanson, South Dakota, US | |
1423537 | 1423537 | 2022-06-08 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-09 04:20:54 | Towner, North Dakota, US | |
3729095 | 3729095 | 2022-06-07 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-08 04:20:55 | Hanson, South Dakota, US | |
3728651 | 3728651 | 2022-06-07 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-08 04:20:55 | Towner, North Dakota, US | |
3890497 | 3890497 | 2022-06-06 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-07 04:21:08 | Hanson, South Dakota, US | |
3890053 | 3890053 | 2022-06-06 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-07 04:21:08 | Towner, North Dakota, US | |
3510266 | 3510266 | 2022-06-05 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-06 04:20:57 | Hanson, South Dakota, US | |
3509822 | 3509822 | 2022-06-05 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-06 04:20:57 | Towner, North Dakota, US | |
3530343 | 3530343 | 2022-06-04 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-05 04:20:55 | Hanson, South Dakota, US | |
3529899 | 3529899 | 2022-06-04 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-05 04:20:55 | Towner, North Dakota, US | |
3136429 | 3136429 | 2022-06-03 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-04 04:20:58 | Hanson, South Dakota, US | |
3135985 | 3135985 | 2022-06-03 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-04 04:20:58 | Towner, North Dakota, US | |
3581504 | 3581504 | 2022-06-02 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-03 04:20:58 | Hanson, South Dakota, US | |
3581060 | 3581060 | 2022-06-02 | US | North Dakota | Towner | 38095 | 657 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-06-03 04:20:58 | Towner, North Dakota, US | |
973797 | 973797 | 2022-06-01 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-02 05:20:39 | Hanson, South Dakota, US | |
232104 | 232104 | 2022-05-31 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-06-01 04:20:55 | Hanson, South Dakota, US | |
3188869 | 3188869 | 2022-05-30 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-05-31 04:20:51 | Hanson, South Dakota, US | |
3201018 | 3201018 | 2022-05-29 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-05-30 04:20:50 | Hanson, South Dakota, US | |
2727896 | 2727896 | 2022-05-28 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-05-29 04:20:53 | Hanson, South Dakota, US | |
1317077 | 1317077 | 2022-05-27 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-05-28 04:21:07 | Hanson, South Dakota, US | |
1852869 | 1852869 | 2022-05-26 | US | South Dakota | Hanson | 46061 | 657 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-05-27 04:20:56 | Hanson, 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]);