johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
677 rows where confirmed = 703 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330997 | 330997 | 2022-12-27 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-28 04:21:04 | Fisher, Texas, US | |
221070 | 221070 | 2022-12-26 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-27 04:21:07 | Fisher, Texas, US | |
3225527 | 3225527 | 2022-12-25 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-26 04:21:06 | Fisher, Texas, US | |
1021441 | 1021441 | 2022-12-24 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-25 04:21:04 | Fisher, Texas, US | |
693464 | 693464 | 2022-12-23 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-24 04:21:02 | Fisher, Texas, US | |
2182674 | 2182674 | 2022-12-22 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-23 04:21:04 | Fisher, Texas, US | |
454478 | 454478 | 2022-12-21 | US | Texas | Fisher | 48151 | 703 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-12-22 04:20:56 | Fisher, Texas, US | |
3253033 | 3253033 | 2022-10-11 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-12 04:22:51 | Jackson, South Dakota, US | |
2970292 | 2970292 | 2022-10-10 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-11 04:23:05 | Jackson, South Dakota, US | |
3100328 | 3100328 | 2022-10-09 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-10 04:22:32 | Jackson, South Dakota, US | |
4005553 | 4005553 | 2022-10-08 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-09 04:21:16 | Jackson, South Dakota, US | |
399150 | 399150 | 2022-10-07 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-08 04:22:56 | Jackson, South Dakota, US | |
2532267 | 2532267 | 2022-10-06 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-07 04:23:08 | Jackson, South Dakota, US | |
1813661 | 1813661 | 2022-10-05 | US | South Dakota | Jackson | 46071 | 703 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-10-06 04:21:22 | Jackson, South Dakota, US | |
3998076 | 3998076 | 2022-09-27 | US | Washington | Columbia | 53013 | 703 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-28 04:23:01 | Columbia, Washington, US | |
2772404 | 2772404 | 2022-09-26 | US | Washington | Columbia | 53013 | 703 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-27 04:23:01 | Columbia, Washington, US | |
1980057 | 1980057 | 2022-09-25 | US | Washington | Columbia | 53013 | 703 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-26 04:20:52 | Columbia, Washington, US | |
2653224 | 2653224 | 2022-09-24 | US | Washington | Columbia | 53013 | 703 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-25 04:23:31 | Columbia, Washington, US | |
387664 | 387664 | 2022-09-23 | US | Washington | Columbia | 53013 | 703 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-09-24 04:21:40 | Columbia, Washington, US | |
2345139 | 2345139 | 2022-08-31 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-09-01 04:21:03 | Cook, Minnesota, US | |
3775619 | 3775619 | 2022-08-30 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-31 04:20:57 | Cook, Minnesota, US | |
1682215 | 1682215 | 2022-08-29 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-30 04:21:03 | Cook, Minnesota, US | |
1878699 | 1878699 | 2022-08-28 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-29 04:21:06 | Cook, Minnesota, US | |
2097826 | 2097826 | 2022-08-27 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-28 04:21:02 | Cook, Minnesota, US | |
1533641 | 1533641 | 2022-08-26 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-27 04:20:57 | Cook, Minnesota, US | |
2830528 | 2830528 | 2022-08-25 | US | Minnesota | Cook | 27031 | 703 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-08-26 04:21:02 | Cook, Minnesota, US | |
1252065 | 1252065 | 2022-08-23 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-24 04:20:46 | Kiowa, Kansas, US | |
2854169 | 2854169 | 2022-08-22 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-23 04:20:56 | Kiowa, Kansas, US | |
2404141 | 2404141 | 2022-08-21 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-22 04:20:38 | Kiowa, Kansas, US | |
3799219 | 3799219 | 2022-08-20 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-21 04:20:44 | Kiowa, Kansas, US | |
2364805 | 2364805 | 2022-08-19 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-20 04:21:01 | Kiowa, Kansas, US | |
1162476 | 1162476 | 2022-08-18 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-19 04:20:54 | Kiowa, Kansas, US | |
3951800 | 3951800 | 2022-08-17 | US | Kansas | Kiowa | 20097 | 703 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-08-18 04:21:11 | Kiowa, Kansas, US | |
1490455 | 1490455 | 2022-07-26 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-27 04:21:04 | Douglas, South Dakota, US | |
2596901 | 2596901 | 2022-07-25 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-26 04:20:58 | Douglas, South Dakota, US | |
899016 | 899016 | 2022-07-24 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-25 04:20:51 | Douglas, South Dakota, US | |
94010 | 94010 | 2022-07-23 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-24 04:20:47 | Douglas, South Dakota, US | |
903032 | 903032 | 2022-07-22 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-23 04:20:53 | Douglas, South Dakota, US | |
673168 | 673168 | 2022-07-21 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-22 04:21:15 | Douglas, South Dakota, US | |
1611131 | 1611131 | 2022-07-20 | US | South Dakota | Douglas | 46043 | 703 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-07-21 04:21:10 | Douglas, South Dakota, US | |
3968962 | 3968962 | 2022-07-05 | US | North Dakota | McIntosh | 38051 | 703 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-06 04:20:58 | McIntosh, North Dakota, US | |
3966976 | 3966976 | 2022-07-05 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-06 04:20:58 | Haines, Alaska, US | |
3078487 | 3078487 | 2022-07-04 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-05 04:20:45 | Haines, Alaska, US | |
1767769 | 1767769 | 2022-07-03 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-04 04:20:54 | Haines, Alaska, US | |
3365755 | 3365755 | 2022-07-02 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-03 04:20:59 | Haines, Alaska, US | |
594084 | 594084 | 2022-07-01 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-02 04:21:16 | Haines, Alaska, US | |
3940485 | 3940485 | 2022-06-30 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-07-01 04:21:10 | Haines, Alaska, US | |
2490443 | 2490443 | 2022-06-29 | US | Alaska | Haines | 2100 | 703 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-06-30 04:21:01 | Haines, Alaska, US | |
3144802 | 3144802 | 2022-06-11 | US | Texas | Shackelford | 48417 | 703 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-12 04:20:53 | Shackelford, Texas, US | |
1947718 | 1947718 | 2022-06-10 | US | Texas | Shackelford | 48417 | 703 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-06-11 04:21:01 | Shackelford, Texas, US | |
232128 | 232128 | 2022-05-31 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-06-01 04:20:55 | Potter, South Dakota, US | |
3188893 | 3188893 | 2022-05-30 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-31 04:20:51 | Potter, South Dakota, US | |
3201042 | 3201042 | 2022-05-29 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-30 04:20:50 | Potter, South Dakota, US | |
2727920 | 2727920 | 2022-05-28 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-29 04:20:53 | Potter, South Dakota, US | |
1317101 | 1317101 | 2022-05-27 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-28 04:21:07 | Potter, South Dakota, US | |
1852893 | 1852893 | 2022-05-26 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-27 04:20:56 | Potter, South Dakota, US | |
2050923 | 2050923 | 2022-05-25 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-26 04:20:50 | Collingsworth, Texas, US | |
2050769 | 2050769 | 2022-05-25 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-26 04:20:50 | Potter, South Dakota, US | |
3002361 | 3002361 | 2022-05-24 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-25 04:20:56 | Collingsworth, Texas, US | |
3002207 | 3002207 | 2022-05-24 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-25 04:20:56 | Potter, South Dakota, US | |
3596082 | 3596082 | 2022-05-23 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-24 04:20:57 | Collingsworth, Texas, US | |
3595928 | 3595928 | 2022-05-23 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-24 04:20:57 | Potter, South Dakota, US | |
624934 | 624934 | 2022-05-22 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-26 04:20:50 | Collingsworth, Texas, US | |
624780 | 624780 | 2022-05-22 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-26 04:20:50 | Potter, South Dakota, US | |
1112630 | 1112630 | 2022-05-21 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-22 04:20:52 | Collingsworth, Texas, US | |
1112476 | 1112476 | 2022-05-21 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-22 04:20:52 | Potter, South Dakota, US | |
1172254 | 1172254 | 2022-05-20 | US | Texas | Collingsworth | 48087 | 703 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-05-21 04:20:58 | Collingsworth, Texas, US | |
1172100 | 1172100 | 2022-05-20 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-21 04:20:58 | Potter, South Dakota, US | |
3898863 | 3898863 | 2022-05-19 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-20 04:20:57 | Potter, South Dakota, US | |
1187647 | 1187647 | 2022-05-18 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-19 04:20:54 | Potter, South Dakota, US | |
3585544 | 3585544 | 2022-05-17 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-18 04:20:50 | Potter, South Dakota, US | |
1506501 | 1506501 | 2022-05-16 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-17 04:20:59 | Potter, South Dakota, US | |
2086860 | 2086860 | 2022-05-15 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-16 04:20:47 | Potter, South Dakota, US | |
2086720 | 2086720 | 2022-05-15 | US | Puerto Rico | Maricao | 72093 | 703 | 0 | 0 | 18.171795 | -66.942126 | 2022-05-16 04:20:47 | Maricao, Puerto Rico, US | |
3357570 | 3357570 | 2022-05-14 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-15 04:20:53 | Potter, South Dakota, US | |
661215 | 661215 | 2022-05-13 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-14 04:20:48 | Potter, South Dakota, US | |
2536298 | 2536298 | 2022-05-12 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-13 04:20:51 | Potter, South Dakota, US | |
2534315 | 2534315 | 2022-05-12 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-13 04:20:51 | Adams, Idaho, US | |
3447744 | 3447744 | 2022-05-11 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-12 04:20:54 | Potter, South Dakota, US | |
3445761 | 3445761 | 2022-05-11 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-12 04:20:54 | Adams, Idaho, US | |
3444628 | 3444628 | 2022-05-11 | China | Chongqing | 703 | 6 | 0 | 30.0572 | 107.874 | 2022-05-12 04:20:54 | Chongqing, China | |||
3536378 | 3536378 | 2022-05-10 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-11 04:20:48 | Adams, Idaho, US | |
3535245 | 3535245 | 2022-05-10 | China | Chongqing | 703 | 6 | 0 | 30.0572 | 107.874 | 2022-05-11 04:20:48 | Chongqing, China | |||
222913 | 222913 | 2022-05-09 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-10 04:20:50 | Adams, Idaho, US | |
221780 | 221780 | 2022-05-09 | China | Chongqing | 703 | 6 | 0 | 30.0572 | 107.874 | 2022-05-10 04:20:50 | Chongqing, China | |||
2332298 | 2332298 | 2022-05-08 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-09 04:20:54 | Adams, Idaho, US | |
2331165 | 2331165 | 2022-05-08 | China | Chongqing | 703 | 6 | 0 | 30.0572 | 107.874 | 2022-05-09 04:20:54 | Chongqing, China | |||
361260 | 361260 | 2022-05-07 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-08 04:20:49 | Adams, Idaho, US | |
360127 | 360127 | 2022-05-07 | China | Chongqing | 703 | 6 | 0 | 30.0572 | 107.874 | 2022-05-08 04:20:49 | Chongqing, China | |||
1398611 | 1398611 | 2022-05-06 | US | Idaho | Adams | 16003 | 703 | 15 | 0 | 44.89333571 | -116.4545247 | 2022-05-07 04:21:09 | Adams, Idaho, US | |
1575037 | 1575037 | 2022-05-03 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-04 04:20:59 | Potter, South Dakota, US | |
466297 | 466297 | 2022-05-02 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-03 04:21:00 | Potter, South Dakota, US | |
3918936 | 3918936 | 2022-05-01 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-02 04:21:10 | Potter, South Dakota, US | |
2843740 | 2843740 | 2022-04-30 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-05-01 04:20:57 | Potter, South Dakota, US | |
1160053 | 1160053 | 2022-04-29 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-30 04:21:05 | Potter, South Dakota, US | |
1699235 | 1699235 | 2022-04-28 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-29 04:20:59 | Potter, South Dakota, US | |
3854718 | 3854718 | 2022-04-27 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-28 04:20:47 | Potter, South Dakota, US | |
1329148 | 1329148 | 2022-04-26 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-27 04:20:52 | Potter, South Dakota, US | |
3725102 | 3725102 | 2022-04-25 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-26 04:20:51 | Potter, South Dakota, US | |
2031670 | 2031670 | 2022-04-24 | US | South Dakota | Potter | 46107 | 703 | 7 | 0 | 45.06583079 | -99.95498503 | 2022-04-25 04:20:56 | 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]);