johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
617 rows where confirmed = 728 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954267 | 2954267 | 2022-12-20 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-21 04:21:03 | Hanson, South Dakota, US | |
3176669 | 3176669 | 2022-12-19 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-20 04:21:04 | Hanson, South Dakota, US | |
1631186 | 1631186 | 2022-12-18 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-19 04:21:03 | Hanson, South Dakota, US | |
1630502 | 1630502 | 2022-12-18 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-19 04:21:03 | De Baca, New Mexico, US | |
506565 | 506565 | 2022-12-17 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-18 04:21:03 | Hanson, South Dakota, US | |
505881 | 505881 | 2022-12-17 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-18 04:21:03 | De Baca, New Mexico, US | |
3327137 | 3327137 | 2022-12-16 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-17 04:21:04 | Hanson, South Dakota, US | |
3326453 | 3326453 | 2022-12-16 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-17 04:21:04 | De Baca, New Mexico, US | |
545649 | 545649 | 2022-12-15 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-16 04:21:01 | Hanson, South Dakota, US | |
544965 | 544965 | 2022-12-15 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-16 04:21:01 | De Baca, New Mexico, US | |
351177 | 351177 | 2022-12-14 | US | South Dakota | Hanson | 46061 | 728 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-12-15 04:20:58 | Hanson, South Dakota, US | |
350493 | 350493 | 2022-12-14 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-15 04:20:58 | De Baca, New Mexico, US | |
310081 | 310081 | 2022-12-13 | US | New Mexico | De Baca | 35011 | 728 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-12-14 04:21:04 | De Baca, New Mexico, US | |
871236 | 871236 | 2022-12-11 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-12 04:21:01 | Towner, North Dakota, US | |
259766 | 259766 | 2022-12-10 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-11 04:20:50 | Towner, North Dakota, US | |
3938480 | 3938480 | 2022-12-09 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-10 04:21:02 | Towner, North Dakota, US | |
3379812 | 3379812 | 2022-12-08 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-09 04:21:05 | Towner, North Dakota, US | |
1987083 | 1987083 | 2022-12-07 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-08 04:21:07 | Towner, North Dakota, US | |
3716606 | 3716606 | 2022-12-06 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-07 04:20:58 | Towner, North Dakota, US | |
3715464 | 3715464 | 2022-12-06 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-07 04:20:58 | Graham, Kansas, US | |
2417311 | 2417311 | 2022-12-05 | US | North Dakota | Towner | 38095 | 728 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-06 04:21:03 | Towner, North Dakota, US | |
2416169 | 2416169 | 2022-12-05 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-06 04:21:03 | Graham, Kansas, US | |
719777 | 719777 | 2022-12-04 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-05 04:20:58 | Graham, Kansas, US | |
2818066 | 2818066 | 2022-12-03 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-04 04:20:56 | Graham, Kansas, US | |
834922 | 834922 | 2022-12-02 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-03 04:21:02 | Graham, Kansas, US | |
2137452 | 2137452 | 2022-12-01 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-02 04:21:07 | Graham, Kansas, US | |
1965868 | 1965868 | 2022-11-30 | US | Kansas | Graham | 20065 | 728 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-01 04:21:03 | Graham, Kansas, US | |
1621613 | 1621613 | 2022-11-22 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-23 04:21:06 | Rawlins, Kansas, US | |
1621584 | 1621584 | 2022-11-22 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-23 04:21:06 | Kiowa, Kansas, US | |
3461501 | 3461501 | 2022-11-21 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-22 04:20:47 | Rawlins, Kansas, US | |
3461472 | 3461472 | 2022-11-21 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-22 04:20:47 | Kiowa, Kansas, US | |
1641686 | 1641686 | 2022-11-20 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-21 04:21:05 | Rawlins, Kansas, US | |
1641657 | 1641657 | 2022-11-20 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-21 04:21:05 | Kiowa, Kansas, US | |
2065243 | 2065243 | 2022-11-19 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-20 04:21:08 | Rawlins, Kansas, US | |
2065214 | 2065214 | 2022-11-19 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-20 04:21:08 | Kiowa, Kansas, US | |
1756637 | 1756637 | 2022-11-18 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-19 04:21:14 | Rawlins, Kansas, US | |
1756608 | 1756608 | 2022-11-18 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-19 04:21:14 | Kiowa, Kansas, US | |
3027630 | 3027630 | 2022-11-17 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-18 04:21:15 | Rawlins, Kansas, US | |
3027601 | 3027601 | 2022-11-17 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-18 04:21:15 | Kiowa, Kansas, US | |
2487341 | 2487341 | 2022-11-16 | US | Kansas | Rawlins | 20153 | 728 | 10 | 0 | 39.78525843 | -101.0761617 | 2022-11-17 04:21:11 | Rawlins, Kansas, US | |
2487312 | 2487312 | 2022-11-16 | US | Kansas | Kiowa | 20097 | 728 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-11-17 04:21:11 | Kiowa, Kansas, US | |
3546711 | 3546711 | 2022-08-08 | US | Texas | Shackelford | 48417 | 728 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-08-09 04:20:34 | Shackelford, Texas, US | |
1488012 | 1488012 | 2022-07-26 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-27 04:21:04 | Haines, Alaska, US | |
2594458 | 2594458 | 2022-07-25 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-26 04:20:58 | Haines, Alaska, US | |
896573 | 896573 | 2022-07-24 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-25 04:20:51 | Haines, Alaska, US | |
91567 | 91567 | 2022-07-23 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-24 04:20:47 | Haines, Alaska, US | |
900589 | 900589 | 2022-07-22 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-23 04:20:53 | Haines, Alaska, US | |
670725 | 670725 | 2022-07-21 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-22 04:21:15 | Haines, Alaska, US | |
1608688 | 1608688 | 2022-07-20 | US | Alaska | Haines | 2100 | 728 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-21 04:21:10 | Haines, Alaska, US | |
594272 | 594272 | 2022-07-01 | US | Colorado | Custer | 8027 | 728 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-07-02 04:21:16 | Custer, Colorado, US | |
2190173 | 2190173 | 2022-06-22 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-23 04:20:55 | Harper, Oklahoma, US | |
169204 | 169204 | 2022-06-21 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-22 04:20:54 | Lipscomb, Texas, US | |
168604 | 168604 | 2022-06-21 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-22 04:20:54 | Harper, Oklahoma, US | |
1766487 | 1766487 | 2022-06-20 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-21 04:20:56 | Lipscomb, Texas, US | |
1765887 | 1765887 | 2022-06-20 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-21 04:20:56 | Harper, Oklahoma, US | |
3272673 | 3272673 | 2022-06-19 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-20 04:21:01 | Lipscomb, Texas, US | |
3272073 | 3272073 | 2022-06-19 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-20 04:21:01 | Harper, Oklahoma, US | |
3400585 | 3400585 | 2022-06-18 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-19 04:20:51 | Lipscomb, Texas, US | |
3399985 | 3399985 | 2022-06-18 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-19 04:20:51 | Harper, Oklahoma, US | |
2314462 | 2314462 | 2022-06-17 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-18 04:21:10 | Lipscomb, Texas, US | |
2313862 | 2313862 | 2022-06-17 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-18 04:21:10 | Harper, Oklahoma, US | |
561966 | 561966 | 2022-06-16 | US | Texas | Lipscomb | 48295 | 728 | 16 | 0 | 36.27783108 | -100.2733151 | 2022-06-17 04:20:56 | Lipscomb, Texas, US | |
561366 | 561366 | 2022-06-16 | US | Oklahoma | Harper | 40059 | 728 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-06-17 04:20:56 | Harper, Oklahoma, US | |
3985768 | 3985768 | 2022-06-15 | US | Texas | Lipscomb | 48295 | 728 | 15 | 0 | 36.27783108 | -100.2733151 | 2022-06-16 04:20:55 | Lipscomb, Texas, US | |
3530611 | 3530611 | 2022-06-04 | US | Texas | Kimble | 48267 | 728 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-05 04:20:55 | Kimble, Texas, US | |
3136697 | 3136697 | 2022-06-03 | US | Texas | Kimble | 48267 | 728 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-04 04:20:58 | Kimble, Texas, US | |
3581772 | 3581772 | 2022-06-02 | US | Texas | Kimble | 48267 | 728 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-03 04:20:58 | Kimble, Texas, US | |
974065 | 974065 | 2022-06-01 | US | Texas | Kimble | 48267 | 728 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-02 05:20:39 | Kimble, Texas, US | |
232372 | 232372 | 2022-05-31 | US | Texas | Kimble | 48267 | 728 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-01 04:20:55 | Kimble, Texas, US | |
3898362 | 3898362 | 2022-05-19 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-20 04:20:57 | Emmons, North Dakota, US | |
1187146 | 1187146 | 2022-05-18 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-19 04:20:54 | Emmons, North Dakota, US | |
3585043 | 3585043 | 2022-05-17 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-18 04:20:50 | Emmons, North Dakota, US | |
1506000 | 1506000 | 2022-05-16 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-17 04:20:59 | Emmons, North Dakota, US | |
2086359 | 2086359 | 2022-05-15 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-16 04:20:47 | Emmons, North Dakota, US | |
3357069 | 3357069 | 2022-05-14 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-15 04:20:53 | Emmons, North Dakota, US | |
660714 | 660714 | 2022-05-13 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-14 04:20:48 | Emmons, North Dakota, US | |
2535797 | 2535797 | 2022-05-12 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-13 04:20:51 | Emmons, North Dakota, US | |
3447243 | 3447243 | 2022-05-11 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-12 04:20:54 | Emmons, North Dakota, US | |
3537860 | 3537860 | 2022-05-10 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-11 04:20:48 | Emmons, North Dakota, US | |
224395 | 224395 | 2022-05-09 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-10 04:20:50 | Emmons, North Dakota, US | |
2333780 | 2333780 | 2022-05-08 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-09 04:20:54 | Emmons, North Dakota, US | |
362742 | 362742 | 2022-05-07 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-08 04:20:49 | Emmons, North Dakota, US | |
1400093 | 1400093 | 2022-05-06 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-07 04:21:09 | Emmons, North Dakota, US | |
2600448 | 2600448 | 2022-05-05 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-06 04:21:00 | Emmons, North Dakota, US | |
3267897 | 3267897 | 2022-05-04 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-05 04:20:55 | Emmons, North Dakota, US | |
1574536 | 1574536 | 2022-05-03 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-04 04:20:59 | Emmons, North Dakota, US | |
465796 | 465796 | 2022-05-02 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-03 04:21:00 | Emmons, North Dakota, US | |
3918435 | 3918435 | 2022-05-01 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-02 04:21:10 | Emmons, North Dakota, US | |
2843239 | 2843239 | 2022-04-30 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-05-01 04:20:57 | Emmons, North Dakota, US | |
1159942 | 1159942 | 2022-04-29 | US | Puerto Rico | Vieques | 72147 | 728 | 0 | 0 | 18.123276 | -65.440971 | 2022-04-30 04:21:05 | Vieques, Puerto Rico, US | |
1159552 | 1159552 | 2022-04-29 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-30 04:21:05 | Emmons, North Dakota, US | |
1698734 | 1698734 | 2022-04-28 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-29 04:20:59 | Emmons, North Dakota, US | |
3854217 | 3854217 | 2022-04-27 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-28 04:20:47 | Emmons, North Dakota, US | |
1328647 | 1328647 | 2022-04-26 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-27 04:20:52 | Emmons, North Dakota, US | |
3724601 | 3724601 | 2022-04-25 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-26 04:20:51 | Emmons, North Dakota, US | |
2031169 | 2031169 | 2022-04-24 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-25 04:20:56 | Emmons, North Dakota, US | |
748744 | 748744 | 2022-04-23 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-24 04:20:56 | Emmons, North Dakota, US | |
3439229 | 3439229 | 2022-04-22 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-23 04:20:50 | Emmons, North Dakota, US | |
2894814 | 2894814 | 2022-04-21 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-22 04:20:45 | Emmons, North Dakota, US | |
2309686 | 2309686 | 2022-04-20 | US | North Dakota | Emmons | 38029 | 728 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-04-21 04:20:46 | Emmons, North 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]);