johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11,139 rows where confirmed = 5 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309134 | 309134 | 2022-12-13 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Iowa, US | |
1150195 | 1150195 | 2022-12-12 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-13 04:21:01 | Unassigned, Iowa, US | |
870049 | 870049 | 2022-12-11 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-12 04:21:01 | Unassigned, Iowa, US | |
258579 | 258579 | 2022-12-10 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Iowa, US | |
3937293 | 3937293 | 2022-12-09 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-10 04:21:02 | Unassigned, Iowa, US | |
3378625 | 3378625 | 2022-12-08 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-12-09 04:21:05 | Unassigned, Iowa, US | |
3378412 | 3378412 | 2022-12-08 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-09 04:21:05 | Out of IL, Illinois, US | |
1986217 | 1986217 | 2022-12-07 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-08 04:21:07 | Unassigned, Maine, US | |
1985683 | 1985683 | 2022-12-07 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-08 04:21:07 | Out of IL, Illinois, US | |
1621310 | 1621310 | 2022-11-22 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-23 04:21:06 | Out of IL, Illinois, US | |
3461732 | 3461732 | 2022-11-21 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-22 04:20:47 | Unassigned, Maine, US | |
1641917 | 1641917 | 2022-11-20 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Maine, US | |
2065474 | 2065474 | 2022-11-19 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-20 04:21:08 | Unassigned, Maine, US | |
293049 | 293049 | 2022-11-15 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-16 04:21:09 | Out of IL, Illinois, US | |
2432505 | 2432505 | 2022-11-09 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-10 04:21:16 | Unassigned, Maine, US | |
320969 | 320969 | 2022-10-30 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-31 04:21:36 | Out of IL, Illinois, US | |
913245 | 913245 | 2022-10-29 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-30 04:22:14 | Out of IL, Illinois, US | |
1367514 | 1367514 | 2022-10-28 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-29 04:21:13 | Out of IL, Illinois, US | |
3039369 | 3039369 | 2022-10-27 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-28 04:22:31 | Out of IL, Illinois, US | |
539789 | 539789 | 2022-10-26 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-27 04:22:01 | Out of IL, Illinois, US | |
1831724 | 1831724 | 2022-10-25 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-26 04:22:19 | Unassigned, Maine, US | |
1831190 | 1831190 | 2022-10-25 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-26 04:22:19 | Out of IL, Illinois, US | |
795985 | 795985 | 2022-10-24 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-25 04:21:53 | Unassigned, Maine, US | |
3278440 | 3278440 | 2022-10-23 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-24 04:22:29 | Unassigned, Maine, US | |
2269478 | 2269478 | 2022-10-22 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-23 04:22:46 | Unassigned, Maine, US | |
1593778 | 1593778 | 2022-10-21 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-22 04:22:53 | Unassigned, Maine, US | |
2530952 | 2530952 | 2022-10-06 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-07 04:23:08 | Unassigned, Maine, US | |
2357038 | 2357038 | 2022-09-16 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-09-17 04:20:19 | Unassigned, Maine, US | |
3746358 | 3746358 | 2022-09-07 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-08 04:21:02 | Unassigned, Iowa, US | |
1533496 | 1533496 | 2022-08-26 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-27 04:20:57 | Unassigned, Maine, US | |
2830383 | 2830383 | 2022-08-25 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-26 04:21:02 | Unassigned, Maine, US | |
1252325 | 1252325 | 2022-08-23 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-24 04:20:46 | Unassigned, Maine, US | |
3952060 | 3952060 | 2022-08-17 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-18 04:21:11 | Unassigned, Maine, US | |
2495601 | 2495601 | 2022-08-15 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-16 04:20:58 | Unassigned, Maine, US | |
3649151 | 3649151 | 2022-08-14 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-15 04:20:59 | Unassigned, Maine, US | |
1970157 | 1970157 | 2022-08-13 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-14 04:20:55 | Unassigned, Maine, US | |
2889966 | 2889966 | 2022-08-12 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-13 04:20:52 | Unassigned, Maine, US | |
3909571 | 3909571 | 2022-08-11 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-12 04:20:54 | Unassigned, Maine, US | |
1347888 | 1347888 | 2022-08-10 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-11 04:20:49 | Unassigned, Maine, US | |
1087643 | 1087643 | 2022-08-09 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-10 04:20:57 | Unassigned, Maine, US | |
3545058 | 3545058 | 2022-08-08 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-09 04:20:34 | Unassigned, Maine, US | |
1071461 | 1071461 | 2022-08-07 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-08 04:21:08 | Unassigned, Maine, US | |
1942049 | 1942049 | 2022-08-06 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-07 04:20:54 | Unassigned, Maine, US | |
881848 | 881848 | 2022-08-05 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-06 04:20:56 | Unassigned, Maine, US | |
3618649 | 3618649 | 2022-08-01 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-02 04:20:53 | Unassigned, Maine, US | |
3873129 | 3873129 | 2022-07-31 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-01 04:21:03 | Unassigned, Maine, US | |
675883 | 675883 | 2022-07-30 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-07-31 04:21:02 | Unassigned, Maine, US | |
1785082 | 1785082 | 2022-07-29 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-07-30 04:20:42 | Unassigned, Maine, US | |
1067445 | 1067445 | 2022-07-28 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-07-29 04:20:45 | Unassigned, Maine, US | |
1609509 | 1609509 | 2022-07-20 | US | Iowa | Unassigned | 90019 | 5 | 0 | 0 | 43.38107862 | 0.0 | 2022-07-21 04:21:10 | Unassigned, Iowa, US | |
3728592 | 3728592 | 2022-06-07 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-08 04:20:55 | Unassigned, North Carolina, US | |
3889994 | 3889994 | 2022-06-06 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-07 04:21:08 | Unassigned, North Carolina, US | |
3509763 | 3509763 | 2022-06-05 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-06 04:20:57 | Unassigned, North Carolina, US | |
3529840 | 3529840 | 2022-06-04 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-05 04:20:55 | Unassigned, North Carolina, US | |
3135926 | 3135926 | 2022-06-03 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-04 04:20:58 | Unassigned, North Carolina, US | |
3581001 | 3581001 | 2022-06-02 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-03 04:20:58 | Unassigned, North Carolina, US | |
973294 | 973294 | 2022-06-01 | US | North Carolina | Unassigned | 90037 | 5 | 7 | 0 | 36.49360862 | 0.0 | 2022-06-02 05:20:39 | Unassigned, North Carolina, US | |
3594060 | 3594060 | 2022-05-23 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-05-24 04:20:57 | Out of IL, Illinois, US | |
3916145 | 3916145 | 2022-05-01 | Micronesia | 5 | 0 | 0 | 7.4256 | 150.5508 | 2022-05-02 04:21:10 | Micronesia | ||||
2840949 | 2840949 | 2022-04-30 | Micronesia | 5 | 0 | 0 | 7.4256 | 150.5508 | 2022-05-01 04:20:57 | Micronesia | ||||
1157262 | 1157262 | 2022-04-29 | Micronesia | 5 | 0 | 0 | 7.4256 | 150.5508 | 2022-04-30 04:21:05 | Micronesia | ||||
1696444 | 1696444 | 2022-04-28 | Micronesia | 5 | 0 | 0 | 7.4256 | 150.5508 | 2022-04-29 04:20:59 | Micronesia | ||||
3851927 | 3851927 | 2022-04-27 | Micronesia | 5 | 0 | 0 | 7.4256 | 150.5508 | 2022-04-28 04:20:47 | Micronesia | ||||
2308319 | 2308319 | 2022-04-20 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-21 04:20:46 | Out of IL, Illinois, US | |
1847008 | 1847008 | 2022-04-18 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-19 04:21:00 | Out of IL, Illinois, US | |
1949546 | 1949546 | 2022-04-12 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-13 04:21:03 | Out of IL, Illinois, US | |
2117283 | 2117283 | 2022-04-08 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-09 04:20:42 | Unassigned, Maine, US | |
2801809 | 2801809 | 2022-04-06 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-07 04:20:53 | Out of IL, Illinois, US | |
3869112 | 3869112 | 2022-04-05 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-06 04:20:49 | Unassigned, Maine, US | |
3868578 | 3868578 | 2022-04-05 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-06 04:20:49 | Out of IL, Illinois, US | |
2749920 | 2749920 | 2022-04-04 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-05 04:20:48 | Out of IL, Illinois, US | |
3352220 | 3352220 | 2022-04-01 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-02 04:20:47 | Unassigned, Maine, US | |
1541525 | 1541525 | 2022-03-31 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-01 04:20:28 | Unassigned, Maine, US | |
2479538 | 2479538 | 2022-03-30 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-31 04:20:56 | Unassigned, Maine, US | |
161696 | 161696 | 2022-03-29 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-30 04:20:45 | Niue, New Zealand | ||
1440267 | 1440267 | 2022-03-28 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-29 04:20:46 | Niue, New Zealand | ||
1438150 | 1438150 | 2022-03-28 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-29 04:20:46 | Unassigned, Maine, US | |
879948 | 879948 | 2022-03-27 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-28 04:20:33 | Niue, New Zealand | ||
877831 | 877831 | 2022-03-27 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-28 04:20:33 | Unassigned, Maine, US | |
2167231 | 2167231 | 2022-03-26 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-27 04:20:47 | Niue, New Zealand | ||
2165114 | 2165114 | 2022-03-26 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-27 04:20:47 | Unassigned, Maine, US | |
1724167 | 1724167 | 2022-03-25 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-26 04:20:23 | Niue, New Zealand | ||
1471784 | 1471784 | 2022-03-24 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-25 04:20:46 | Niue, New Zealand | ||
2141206 | 2141206 | 2022-03-09 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-10 04:20:48 | Out of IL, Illinois, US | |
2526398 | 2526398 | 2022-03-02 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-03 04:21:01 | Out of IL, Illinois, US | |
1993692 | 1993692 | 2022-03-01 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-02 04:21:07 | Out of IL, Illinois, US | |
943866 | 943866 | 2022-02-28 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-01 04:21:09 | Out of IL, Illinois, US | |
459720 | 459720 | 2022-02-02 | Tonga | 5 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-03 04:21:21 | Tonga | ||||
2053449 | 2053449 | 2022-01-25 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-01-26 04:21:07 | Unassigned, Maine, US | |
1229180 | 1229180 | 2022-01-24 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-01-25 04:21:05 | Unassigned, Maine, US | |
1142479 | 1142479 | 2022-01-23 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-01-24 04:21:12 | Unassigned, Maine, US | |
1141945 | 1141945 | 2022-01-23 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-01-24 04:21:12 | Out of IL, Illinois, US | |
2834397 | 2834397 | 2022-01-22 | US | Maine | Unassigned | 90023 | 5 | 0 | 0 | 46.65926321 | 0.0 | 2022-01-23 04:21:13 | Unassigned, Maine, US | |
2833863 | 2833863 | 2022-01-22 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-01-23 04:21:13 | Out of IL, Illinois, US | |
3425981 | 3425981 | 2022-01-21 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-01-22 04:21:13 | Out of IL, Illinois, US | |
3227484 | 3227484 | 2022-01-19 | US | Illinois | Out of IL | 80017 | 5 | 0 | 0 | 42.36542373 | 0.0 | 2022-01-20 04:21:07 | Out of IL, Illinois, US | |
3227410 | 3227410 | 2022-01-19 | US | Idaho | Unassigned | 90016 | 5 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2022-01-20 04:21:07 | Unassigned, Idaho, US | |
1117178 | 1117178 | 2022-01-11 | US | Wisconsin | Unassigned | 90055 | 5 | 0 | 0 | 46.52868768 | 0.0 | 2022-01-12 04:21:44 | Unassigned, Wisconsin, US | |
1695906 | 1695906 | 2022-01-10 | US | Wisconsin | Unassigned | 90055 | 5 | 0 | 0 | 46.52868768 | 0.0 | 2022-01-11 04:22:01 | Unassigned, Wisconsin, US | |
1285578 | 1285578 | 2022-01-05 | US | Wisconsin | Unassigned | 90055 | 5 | 0 | 0 | 46.52868768 | 0.0 | 2022-01-06 04:22:09 | Unassigned, Wisconsin, 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]);