johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
713 rows where confirmed = 579 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1966984 | 1966984 | 2022-11-30 | US | North Dakota | Kidder | 38043 | 579 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-01 04:21:03 | Kidder, North Dakota, US | |
2558998 | 2558998 | 2022-11-29 | US | North Dakota | Kidder | 38043 | 579 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-11-30 04:21:07 | Kidder, North Dakota, US | |
1682588 | 1682588 | 2022-08-29 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-30 04:21:03 | Hitchcock, Nebraska, US | |
1879072 | 1879072 | 2022-08-28 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-29 04:21:06 | Hitchcock, Nebraska, US | |
2098199 | 2098199 | 2022-08-27 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-28 04:21:02 | Hitchcock, Nebraska, US | |
1534014 | 1534014 | 2022-08-26 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-27 04:20:57 | Hitchcock, Nebraska, US | |
2830901 | 2830901 | 2022-08-25 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-26 04:21:02 | Hitchcock, Nebraska, US | |
2325434 | 2325434 | 2022-08-24 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-25 04:21:13 | Hitchcock, Nebraska, US | |
1252843 | 1252843 | 2022-08-23 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-24 04:20:46 | Hitchcock, Nebraska, US | |
2854947 | 2854947 | 2022-08-22 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-23 04:20:56 | Hitchcock, Nebraska, US | |
2404919 | 2404919 | 2022-08-21 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-22 04:20:38 | Hitchcock, Nebraska, US | |
3799997 | 3799997 | 2022-08-20 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-21 04:20:44 | Hitchcock, Nebraska, US | |
2365583 | 2365583 | 2022-08-19 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-20 04:21:01 | Hitchcock, Nebraska, US | |
1163254 | 1163254 | 2022-08-18 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-19 04:20:54 | Hitchcock, Nebraska, US | |
3952578 | 3952578 | 2022-08-17 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-18 04:21:11 | Hitchcock, Nebraska, US | |
993080 | 993080 | 2022-08-16 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-17 04:20:59 | Hitchcock, Nebraska, US | |
2497209 | 2497209 | 2022-08-15 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-16 04:20:58 | Menard, Texas, US | |
2496119 | 2496119 | 2022-08-15 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-16 04:20:58 | Hitchcock, Nebraska, US | |
3650759 | 3650759 | 2022-08-14 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-15 04:20:59 | Menard, Texas, US | |
3650694 | 3650694 | 2022-08-14 | US | Texas | Hardeman | 48197 | 579 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-08-15 04:20:59 | Hardeman, Texas, US | |
3649669 | 3649669 | 2022-08-14 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-15 04:20:59 | Hitchcock, Nebraska, US | |
1971765 | 1971765 | 2022-08-13 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-14 04:20:55 | Menard, Texas, US | |
1971700 | 1971700 | 2022-08-13 | US | Texas | Hardeman | 48197 | 579 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-08-14 04:20:55 | Hardeman, Texas, US | |
1970675 | 1970675 | 2022-08-13 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-14 04:20:55 | Hitchcock, Nebraska, US | |
2891574 | 2891574 | 2022-08-12 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-13 04:20:52 | Menard, Texas, US | |
2891509 | 2891509 | 2022-08-12 | US | Texas | Hardeman | 48197 | 579 | 19 | 0 | 34.28944521 | -99.74632408 | 2022-08-13 04:20:52 | Hardeman, Texas, US | |
2890484 | 2890484 | 2022-08-12 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-13 04:20:52 | Hitchcock, Nebraska, US | |
3911179 | 3911179 | 2022-08-11 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-12 04:20:54 | Menard, Texas, US | |
3910089 | 3910089 | 2022-08-11 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-12 04:20:54 | Hitchcock, Nebraska, US | |
1349496 | 1349496 | 2022-08-10 | US | Texas | Menard | 48327 | 579 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-11 04:20:49 | Menard, Texas, US | |
1348406 | 1348406 | 2022-08-10 | US | Nebraska | Hitchcock | 31087 | 579 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-11 04:20:49 | Hitchcock, Nebraska, US | |
1490010 | 1490010 | 2022-07-26 | US | North Dakota | Renville | 38075 | 579 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-07-27 04:21:04 | Renville, North Dakota, US | |
3112677 | 3112677 | 2022-07-13 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-14 04:20:57 | Oldham, Texas, US | |
633100 | 633100 | 2022-07-12 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-13 04:20:58 | Oldham, Texas, US | |
1214744 | 1214744 | 2022-07-11 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-12 04:20:51 | Oldham, Texas, US | |
2792226 | 2792226 | 2022-07-10 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-11 04:20:46 | Oldham, Texas, US | |
145179 | 145179 | 2022-07-09 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-10 04:20:54 | Oldham, Texas, US | |
1420279 | 1420279 | 2022-07-08 | US | Texas | Oldham | 48359 | 579 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-09 04:20:59 | Oldham, Texas, US | |
1420105 | 1420105 | 2022-07-08 | US | Texas | Armstrong | 48011 | 579 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-07-09 04:20:59 | Armstrong, Texas, US | |
2240683 | 2240683 | 2022-06-28 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-29 04:20:59 | Elk, Kansas, US | |
2148925 | 2148925 | 2022-06-27 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-28 04:20:58 | Elk, Kansas, US | |
476726 | 476726 | 2022-06-26 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-27 04:21:00 | Elk, Kansas, US | |
940101 | 940101 | 2022-06-25 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-26 04:21:02 | Elk, Kansas, US | |
3347921 | 3347921 | 2022-06-24 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-25 04:20:57 | Elk, Kansas, US | |
1649662 | 1649662 | 2022-06-23 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-24 04:20:58 | Elk, Kansas, US | |
2188897 | 2188897 | 2022-06-22 | US | Kansas | Elk | 20049 | 579 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-06-23 04:20:55 | Elk, Kansas, US | |
2086237 | 2086237 | 2022-05-15 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-16 04:20:47 | Unassigned, New York, US | |
3356947 | 3356947 | 2022-05-14 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-15 04:20:53 | Unassigned, New York, US | |
660592 | 660592 | 2022-05-13 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-14 04:20:48 | Unassigned, New York, US | |
2535675 | 2535675 | 2022-05-12 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-13 04:20:51 | Unassigned, New York, US | |
3447121 | 3447121 | 2022-05-11 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-12 04:20:54 | Unassigned, New York, US | |
3537738 | 3537738 | 2022-05-10 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-11 04:20:48 | Unassigned, New York, US | |
224273 | 224273 | 2022-05-09 | US | New York | Unassigned | 90036 | 579 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-10 04:20:50 | Unassigned, New York, US | |
2333092 | 2333092 | 2022-05-08 | US | Minnesota | Cook | 27031 | 579 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-09 04:20:54 | Cook, Minnesota, US | |
362054 | 362054 | 2022-05-07 | US | Minnesota | Cook | 27031 | 579 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-08 04:20:49 | Cook, Minnesota, US | |
1399405 | 1399405 | 2022-05-06 | US | Minnesota | Cook | 27031 | 579 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-07 04:21:09 | Cook, Minnesota, US | |
2599760 | 2599760 | 2022-05-05 | US | Minnesota | Cook | 27031 | 579 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-06 04:21:00 | Cook, Minnesota, US | |
2733449 | 2733449 | 2022-02-27 | US | Alaska | Haines | 2100 | 579 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-02-28 04:21:05 | Haines, Alaska, US | |
3046602 | 3046602 | 2022-02-26 | US | Alaska | Haines | 2100 | 579 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-02-27 04:21:04 | Haines, Alaska, US | |
575257 | 575257 | 2022-02-25 | US | Alaska | Haines | 2100 | 579 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-02-26 04:21:12 | Haines, Alaska, US | |
74177 | 74177 | 2022-02-07 | US | Texas | Fisher | 48151 | 579 | 20 | 0 | 32.74281316 | -100.40193020000001 | 2022-02-08 04:21:15 | Fisher, Texas, US | |
2015793 | 2015793 | 2022-02-06 | US | Texas | Fisher | 48151 | 579 | 20 | 0 | 32.74281316 | -100.40193020000001 | 2022-02-07 04:21:05 | Fisher, Texas, US | |
3064788 | 3064788 | 2022-01-29 | US | Puerto Rico | Vieques | 72147 | 579 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-01-30 04:21:26 | Vieques, Puerto Rico, US | |
3812722 | 3812722 | 2022-01-28 | US | Puerto Rico | Vieques | 72147 | 579 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-01-29 04:21:10 | Vieques, Puerto Rico, US | |
1141326 | 1141326 | 2022-01-23 | US | Alaska | Aleutians East | 2013 | 579 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-24 04:21:12 | Aleutians East, Alaska, US | |
2833244 | 2833244 | 2022-01-22 | US | Alaska | Aleutians East | 2013 | 579 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-23 04:21:13 | Aleutians East, Alaska, US | |
3428107 | 3428107 | 2022-01-21 | US | Texas | Lipscomb | 48295 | 579 | 13 | 0 | 36.27783108 | -100.27331509999999 | 2022-01-22 04:21:13 | Lipscomb, Texas, US | |
3425362 | 3425362 | 2022-01-21 | US | Alaska | Aleutians East | 2013 | 579 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-22 04:21:13 | Aleutians East, Alaska, US | |
1963715 | 1963715 | 2022-01-20 | US | Texas | Lipscomb | 48295 | 579 | 13 | 0 | 36.27783108 | -100.27331509999999 | 2022-01-21 04:21:09 | Lipscomb, Texas, US | |
3228862 | 3228862 | 2022-01-19 | US | North Dakota | McIntosh | 38051 | 579 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-01-20 04:21:07 | McIntosh, North Dakota, US | |
3464611 | 3464611 | 2022-01-18 | US | Alaska | Petersburg | 2195 | 579 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-19 04:21:23 | Petersburg, Alaska, US | |
1472550 | 1472550 | 2022-01-17 | US | Alaska | Petersburg | 2195 | 579 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-18 04:21:04 | Petersburg, Alaska, US | |
555224 | 555224 | 2022-01-16 | US | Alaska | Petersburg | 2195 | 579 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-17 04:21:08 | Petersburg, Alaska, US | |
3840945 | 3840945 | 2022-01-15 | US | Alaska | Petersburg | 2195 | 579 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-16 04:21:12 | Petersburg, Alaska, US | |
102380 | 102380 | 2022-01-14 | US | Texas | Collingsworth | 48087 | 579 | 13 | 0 | 34.96489496 | -100.27001109999999 | 2022-01-15 04:21:07 | Collingsworth, Texas, US | |
99760 | 99760 | 2022-01-14 | US | Alaska | Petersburg | 2195 | 579 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-15 04:21:07 | Petersburg, Alaska, US | |
3613982 | 3613982 | 2022-01-12 | US | Idaho | Adams | 16003 | 579 | 14 | 0 | 44.89333571 | -116.4545247 | 2022-01-13 08:00:09 | Adams, Idaho, US | |
1116809 | 1116809 | 2022-01-11 | US | Texas | Shackelford | 48417 | 579 | 9 | 0 | 32.73587756 | -99.35401337 | 2022-01-12 04:21:44 | Shackelford, Texas, US | |
1694536 | 1694536 | 2022-01-10 | US | New Mexico | Union | 35059 | 579 | 12 | 0 | 36.48126404 | -103.4709624 | 2022-01-11 04:22:01 | Union, New Mexico, US | |
129582 | 129582 | 2022-01-09 | US | South Dakota | Bennett | 46007 | 579 | 9 | 0 | 43.19486375 | -101.6665572 | 2022-01-10 04:22:07 | Bennett, South Dakota, US | |
1218417 | 1218417 | 2022-01-08 | US | South Dakota | Bennett | 46007 | 579 | 9 | 0 | 43.19486375 | -101.6665572 | 2022-01-09 04:21:46 | Bennett, South Dakota, US | |
1392510 | 1392510 | 2022-01-07 | US | South Dakota | Bennett | 46007 | 579 | 9 | 0 | 43.19486375 | -101.6665572 | 2022-01-08 04:21:53 | Bennett, South Dakota, US | |
800559 | 800559 | 2021-12-22 | US | Nebraska | Valley | 31175 | 579 | 2 | 0 | 41.56730777 | -98.98197724 | 2021-12-23 04:21:21 | Valley, Nebraska, US | |
1257640 | 1257640 | 2021-12-20 | US | South Dakota | Douglas | 46043 | 579 | 14 | 0 | 43.38520741 | -98.36978007 | 2021-12-21 03:21:27 | Douglas, South Dakota, US | |
1256902 | 1256902 | 2021-12-20 | US | Nebraska | Valley | 31175 | 579 | 2 | 0 | 41.56730777 | -98.98197724 | 2021-12-21 03:21:27 | Valley, Nebraska, US | |
1256547 | 1256547 | 2021-12-20 | US | Minnesota | Unassigned | 90027 | 579 | 124 | 0 | 48.77754106 | 0.0 | 2021-12-21 03:21:27 | Unassigned, Minnesota, US | |
2906583 | 2906583 | 2021-12-19 | US | South Dakota | Douglas | 46043 | 579 | 14 | 0 | 43.38520741 | -98.36978007 | 2021-12-20 04:21:43 | Douglas, South Dakota, US | |
1261656 | 1261656 | 2021-12-18 | US | South Dakota | Douglas | 46043 | 579 | 14 | 0 | 43.38520741 | -98.36978007 | 2021-12-19 04:21:11 | Douglas, South Dakota, US | |
2401684 | 2401684 | 2021-12-17 | US | South Dakota | Douglas | 46043 | 579 | 14 | 0 | 43.38520741 | -98.36978007 | 2021-12-18 02:22:20 | Douglas, South Dakota, US | |
3498583 | 3498583 | 2021-12-15 | US | North Dakota | Cavalier | 38019 | 579 | 6 | 0 | 48.77286211 | -98.46685243 | 2021-12-16 04:22:11 | Cavalier, North Dakota, US | |
2090368 | 2090368 | 2021-12-14 | US | North Dakota | Cavalier | 38019 | 579 | 6 | 0 | 48.77286211 | -98.46685243 | 2021-12-15 03:22:16 | Cavalier, North Dakota, US | |
785413 | 785413 | 2021-12-13 | US | Texas | Baylor | 48023 | 579 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-14 04:22:38 | Baylor, Texas, US | |
1663572 | 1663572 | 2021-12-12 | US | Texas | Kinney | 48271 | 579 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2021-12-13 04:22:02 | Kinney, Texas, US | |
1663448 | 1663448 | 2021-12-12 | US | Texas | Baylor | 48023 | 579 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-13 04:22:02 | Baylor, Texas, US | |
1667464 | 1667464 | 2021-12-11 | US | Texas | Baylor | 48023 | 579 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-12 04:22:12 | Baylor, Texas, US | |
553976 | 553976 | 2021-12-08 | US | Texas | Reagan | 48383 | 579 | 10 | 0 | 31.36607041 | -101.52326590000001 | 2021-12-09 04:22:49 | Reagan, Texas, US | |
1033223 | 1033223 | 2021-12-06 | US | South Dakota | Aurora | 46003 | 579 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-07 04:22:34 | Aurora, South Dakota, US | |
1743386 | 1743386 | 2021-12-05 | US | South Dakota | Aurora | 46003 | 579 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-06 04:22:34 | Aurora, South Dakota, US | |
140818 | 140818 | 2021-12-04 | US | South Dakota | Aurora | 46003 | 579 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-05 04:22:25 | Aurora, South Dakota, US | |
2198471 | 2198471 | 2021-12-03 | US | South Dakota | Aurora | 46003 | 579 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-04 04:22:18 | Aurora, 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]);