johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
650 rows where confirmed = 692 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717260 | 3717260 | 2022-12-06 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-07 04:20:58 | Fisher, Texas, US | |
2417965 | 2417965 | 2022-12-05 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-06 04:21:03 | Fisher, Texas, US | |
721573 | 721573 | 2022-12-04 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-05 04:20:58 | Fisher, Texas, US | |
2819862 | 2819862 | 2022-12-03 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-04 04:20:56 | Fisher, Texas, US | |
836718 | 836718 | 2022-12-02 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-03 04:21:02 | Fisher, Texas, US | |
2139248 | 2139248 | 2022-12-01 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-02 04:21:07 | Fisher, Texas, US | |
1967664 | 1967664 | 2022-11-30 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-01 04:21:03 | Fisher, Texas, US | |
2559678 | 2559678 | 2022-11-29 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-11-30 04:21:07 | Fisher, Texas, US | |
1242752 | 1242752 | 2022-11-28 | US | Texas | Fisher | 48151 | 692 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-11-29 04:21:05 | Fisher, Texas, US | |
3997553 | 3997553 | 2022-09-27 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-28 04:23:01 | Ziebach, South Dakota, US | |
2771881 | 2771881 | 2022-09-26 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-27 04:23:01 | Ziebach, South Dakota, US | |
1979534 | 1979534 | 2022-09-25 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-26 04:20:52 | Ziebach, South Dakota, US | |
2652701 | 2652701 | 2022-09-24 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-25 04:23:31 | Ziebach, South Dakota, US | |
387141 | 387141 | 2022-09-23 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-24 04:21:40 | Ziebach, South Dakota, US | |
1627207 | 1627207 | 2022-09-22 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-23 04:23:13 | Ziebach, South Dakota, US | |
1373411 | 1373411 | 2022-09-21 | US | South Dakota | Ziebach | 46137 | 692 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-09-22 04:22:56 | Ziebach, South Dakota, US | |
1373055 | 1373055 | 2022-09-21 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-22 04:22:56 | Harmon, Oklahoma, US | |
2019632 | 2019632 | 2022-09-20 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-21 04:23:22 | Stanley, South Dakota, US | |
2019285 | 2019285 | 2022-09-20 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-21 04:23:22 | Harmon, Oklahoma, US | |
3573505 | 3573505 | 2022-09-19 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-20 04:22:48 | Stanley, South Dakota, US | |
3573158 | 3573158 | 2022-09-19 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-20 04:22:48 | Harmon, Oklahoma, US | |
422244 | 422244 | 2022-09-18 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-19 04:21:49 | Stanley, South Dakota, US | |
421897 | 421897 | 2022-09-18 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-19 04:21:49 | Harmon, Oklahoma, US | |
3376268 | 3376268 | 2022-09-17 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-18 04:22:50 | Stanley, South Dakota, US | |
3375921 | 3375921 | 2022-09-17 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-18 04:22:50 | Harmon, Oklahoma, US | |
2358376 | 2358376 | 2022-09-16 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-17 04:20:19 | Stanley, South Dakota, US | |
2358029 | 2358029 | 2022-09-16 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-17 04:20:19 | Harmon, Oklahoma, US | |
3989533 | 3989533 | 2022-09-15 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-16 04:21:19 | Stanley, South Dakota, US | |
3989186 | 3989186 | 2022-09-15 | US | Oklahoma | Harmon | 40057 | 692 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-09-16 04:21:19 | Harmon, Oklahoma, US | |
1892050 | 1892050 | 2022-09-14 | US | South Dakota | Stanley | 46117 | 692 | 8 | 0 | 44.41381872 | -100.7349153 | 2022-09-15 04:21:02 | Stanley, South Dakota, US | |
3769317 | 3769317 | 2022-09-11 | US | Washington | Columbia | 53013 | 692 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-12 04:20:58 | Columbia, Washington, US | |
3827892 | 3827892 | 2022-09-10 | US | Washington | Columbia | 53013 | 692 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-11 04:20:50 | Columbia, Washington, US | |
966349 | 966349 | 2022-09-09 | US | Washington | Columbia | 53013 | 692 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-10 04:21:10 | Columbia, Washington, US | |
2325061 | 2325061 | 2022-08-24 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-25 04:21:13 | Cook, Minnesota, US | |
1252470 | 1252470 | 2022-08-23 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-24 04:20:46 | Cook, Minnesota, US | |
2854574 | 2854574 | 2022-08-22 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-23 04:20:56 | Cook, Minnesota, US | |
2404546 | 2404546 | 2022-08-21 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-22 04:20:38 | Cook, Minnesota, US | |
3799624 | 3799624 | 2022-08-20 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-21 04:20:44 | Cook, Minnesota, US | |
2365210 | 2365210 | 2022-08-19 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-20 04:21:01 | Cook, Minnesota, US | |
1162881 | 1162881 | 2022-08-18 | US | Minnesota | Cook | 27031 | 692 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-19 04:20:54 | Cook, Minnesota, US | |
3650017 | 3650017 | 2022-08-14 | US | North Dakota | Towner | 38095 | 692 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-08-15 04:20:59 | Towner, North Dakota, US | |
2242268 | 2242268 | 2022-06-28 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-29 04:20:59 | Douglas, South Dakota, US | |
2150510 | 2150510 | 2022-06-27 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-28 04:20:58 | Douglas, South Dakota, US | |
478311 | 478311 | 2022-06-26 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-27 04:21:00 | Douglas, South Dakota, US | |
941686 | 941686 | 2022-06-25 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-26 04:21:02 | Douglas, South Dakota, US | |
3349506 | 3349506 | 2022-06-24 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-25 04:20:57 | Douglas, South Dakota, US | |
1651247 | 1651247 | 2022-06-23 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-24 04:20:58 | Douglas, South Dakota, US | |
2190482 | 2190482 | 2022-06-22 | US | South Dakota | Douglas | 46043 | 692 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-06-23 04:20:55 | Douglas, South Dakota, US | |
167381 | 167381 | 2022-06-21 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-22 04:20:54 | Rawlins, Kansas, US | |
1764664 | 1764664 | 2022-06-20 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-21 04:20:56 | Rawlins, Kansas, US | |
3270850 | 3270850 | 2022-06-19 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-20 04:21:01 | Rawlins, Kansas, US | |
3398762 | 3398762 | 2022-06-18 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-19 04:20:51 | Rawlins, Kansas, US | |
2312639 | 2312639 | 2022-06-17 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-18 04:21:10 | Rawlins, Kansas, US | |
560143 | 560143 | 2022-06-16 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-17 04:20:56 | Rawlins, Kansas, US | |
3983945 | 3983945 | 2022-06-15 | US | Kansas | Rawlins | 20153 | 692 | 9 | 0 | 39.78525843 | -101.0761617 | 2022-06-16 04:20:55 | Rawlins, Kansas, US | |
3200552 | 3200552 | 2022-05-29 | US | North Dakota | McIntosh | 38051 | 692 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-05-30 04:20:50 | McIntosh, North Dakota, US | |
2727430 | 2727430 | 2022-05-28 | US | North Dakota | McIntosh | 38051 | 692 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-05-29 04:20:53 | McIntosh, North Dakota, US | |
1172419 | 1172419 | 2022-05-20 | US | Texas | Shackelford | 48417 | 692 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-21 04:20:58 | Shackelford, Texas, US | |
3899182 | 3899182 | 2022-05-19 | US | Texas | Shackelford | 48417 | 692 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-20 04:20:57 | Shackelford, Texas, US | |
1187966 | 1187966 | 2022-05-18 | US | Texas | Shackelford | 48417 | 692 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-19 04:20:54 | Shackelford, Texas, US | |
3585863 | 3585863 | 2022-05-17 | US | Texas | Shackelford | 48417 | 692 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-05-18 04:20:50 | Shackelford, Texas, US | |
3320025 | 3320025 | 2022-04-07 | China | Chongqing | 692 | 6 | 0 | 30.0572 | 107.874 | 2022-04-08 04:20:48 | Chongqing, China | |||
2800561 | 2800561 | 2022-04-06 | China | Chongqing | 692 | 6 | 0 | 30.0572 | 107.874 | 2022-04-07 04:20:53 | Chongqing, China | |||
3867330 | 3867330 | 2022-04-05 | China | Chongqing | 692 | 6 | 0 | 30.0572 | 107.874 | 2022-04-06 04:20:49 | Chongqing, China | |||
3732263 | 3732263 | 2022-04-03 | US | Montana | Sheridan | 30091 | 692 | 11 | 0 | 48.72085833 | -104.50382900000001 | 2022-04-04 04:20:51 | Sheridan, Montana, US | |
501698 | 501698 | 2022-04-02 | US | Montana | Sheridan | 30091 | 692 | 11 | 0 | 48.72085833 | -104.50382900000001 | 2022-04-03 04:20:48 | Sheridan, Montana, US | |
3352683 | 3352683 | 2022-04-01 | US | Montana | Sheridan | 30091 | 692 | 11 | 0 | 48.72085833 | -104.50382900000001 | 2022-04-02 04:20:47 | Sheridan, Montana, US | |
2322387 | 2322387 | 2022-03-16 | US | Texas | Collingsworth | 48087 | 692 | 16 | 0 | 34.96489496 | -100.27001109999999 | 2022-03-17 04:20:56 | Collingsworth, Texas, US | |
264587 | 264587 | 2022-03-15 | US | Texas | Collingsworth | 48087 | 692 | 16 | 0 | 34.96489496 | -100.27001109999999 | 2022-03-16 04:20:50 | Collingsworth, Texas, US | |
920602 | 920602 | 2022-03-08 | US | Idaho | Adams | 16003 | 692 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-03-09 04:20:59 | Adams, Idaho, US | |
1548889 | 1548889 | 2022-03-07 | US | Idaho | Adams | 16003 | 692 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-03-08 04:20:54 | Adams, Idaho, US | |
945734 | 945734 | 2022-02-28 | US | South Dakota | Potter | 46107 | 692 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-03-01 04:21:09 | Potter, South Dakota, US | |
2735925 | 2735925 | 2022-02-27 | US | South Dakota | Potter | 46107 | 692 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-02-28 04:21:05 | Potter, South Dakota, US | |
3049078 | 3049078 | 2022-02-26 | US | South Dakota | Potter | 46107 | 692 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-02-27 04:21:04 | Potter, South Dakota, US | |
577733 | 577733 | 2022-02-25 | US | South Dakota | Potter | 46107 | 692 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-02-26 04:21:12 | Potter, South Dakota, US | |
1514309 | 1514309 | 2022-02-24 | US | South Dakota | Potter | 46107 | 692 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-02-25 04:21:11 | Potter, South Dakota, US | |
188195 | 188195 | 2022-02-13 | US | Nebraska | Stanton | 31167 | 692 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-02-14 04:20:51 | Stanton, Nebraska, US | |
186681 | 186681 | 2022-02-13 | US | Colorado | Costilla | 8023 | 692 | 15 | 0 | 37.27732493 | -105.4276548 | 2022-02-14 04:20:51 | Costilla, Colorado, US | |
318041 | 318041 | 2022-02-12 | US | Nebraska | Stanton | 31167 | 692 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-02-13 04:21:00 | Stanton, Nebraska, US | |
235367 | 235367 | 2022-02-11 | US | Nebraska | Stanton | 31167 | 692 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-02-12 04:21:06 | Stanton, Nebraska, US | |
2054281 | 2054281 | 2022-01-25 | US | North Dakota | Eddy | 38027 | 692 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-01-26 04:21:07 | Eddy, North Dakota, US | |
1142269 | 1142269 | 2022-01-23 | US | Kansas | Trego | 20195 | 692 | 9 | 0 | 38.91467218 | -99.87284448 | 2022-01-24 04:21:12 | Trego, Kansas, US | |
2834187 | 2834187 | 2022-01-22 | US | Kansas | Trego | 20195 | 692 | 9 | 0 | 38.91467218 | -99.87284448 | 2022-01-23 04:21:13 | Trego, Kansas, US | |
3426305 | 3426305 | 2022-01-21 | US | Kansas | Trego | 20195 | 692 | 9 | 0 | 38.91467218 | -99.87284448 | 2022-01-22 04:21:13 | Trego, Kansas, US | |
1961974 | 1961974 | 2022-01-20 | US | Kentucky | Hickman | 21105 | 692 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2022-01-21 04:21:09 | Hickman, Kentucky, US | |
3229310 | 3229310 | 2022-01-19 | US | South Dakota | Clark | 46025 | 692 | 6 | 0 | 44.85834507 | -97.72925109 | 2022-01-20 04:21:07 | Clark, South Dakota, US | |
3465489 | 3465489 | 2022-01-18 | US | Kansas | Logan | 20109 | 692 | 9 | 0 | 38.91735806 | -101.148475 | 2022-01-19 04:21:23 | Logan, Kansas, US | |
1475138 | 1475138 | 2022-01-17 | US | Texas | Baylor | 48023 | 692 | 26 | 0 | 33.61640794 | -99.21352901 | 2022-01-18 04:21:04 | Baylor, Texas, US | |
1473428 | 1473428 | 2022-01-17 | US | Kansas | Logan | 20109 | 692 | 9 | 0 | 38.91735806 | -101.148475 | 2022-01-18 04:21:04 | Logan, Kansas, US | |
556102 | 556102 | 2022-01-16 | US | Kansas | Logan | 20109 | 692 | 9 | 0 | 38.91735806 | -101.148475 | 2022-01-17 04:21:08 | Logan, Kansas, US | |
3841823 | 3841823 | 2022-01-15 | US | Kansas | Logan | 20109 | 692 | 9 | 0 | 38.91735806 | -101.148475 | 2022-01-16 04:21:12 | Logan, Kansas, US | |
102568 | 102568 | 2022-01-14 | US | Texas | Upton | 48461 | 692 | 15 | 0 | 31.36868194 | -102.0423217 | 2022-01-15 04:21:07 | Upton, Texas, US | |
100638 | 100638 | 2022-01-14 | US | Kansas | Logan | 20109 | 692 | 9 | 0 | 38.91735806 | -101.148475 | 2022-01-15 04:21:07 | Logan, Kansas, US | |
3615455 | 3615455 | 2022-01-12 | US | North Dakota | Bowman | 38011 | 692 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-01-13 08:00:09 | Bowman, North Dakota, US | |
1391901 | 1391901 | 2022-01-07 | US | New York | Hamilton | 36041 | 692 | 4 | 0 | 43.66146647 | -74.49721957 | 2022-01-08 04:21:53 | Hamilton, New York, US | |
1703464 | 1703464 | 2022-01-03 | US | Texas | Haskell | 48207 | 692 | 37 | 0 | 33.17823584 | -99.73037358 | 2022-01-04 04:22:17 | Haskell, Texas, US | |
551769 | 551769 | 2021-12-08 | US | Illinois | Hardin | 17069 | 692 | 16 | 0 | 37.51810645 | -88.26873022 | 2021-12-09 04:22:49 | Hardin, Illinois, US | |
1741923 | 1741923 | 2021-12-05 | US | Kentucky | Carlisle | 21039 | 692 | 12 | 0 | 36.85372876 | -88.96692220000001 | 2021-12-06 04:22:34 | Carlisle, Kentucky, US | |
139355 | 139355 | 2021-12-04 | US | Kentucky | Carlisle | 21039 | 692 | 12 | 0 | 36.85372876 | -88.96692220000001 | 2021-12-05 04:22:25 | Carlisle, Kentucky, US | |
1360776 | 1360776 | 2021-11-27 | US | Northern Mariana Islands | 69 | 692 | 3 | 0 | 15.0979 | 145.6739 | 2021-11-28 04:22:43 | Northern Mariana Islands, 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]);