johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
449 rows where deaths = 572 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953191 | 2953191 | 2022-12-20 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-21 04:21:03 | DeSoto, Mississippi, US | |
3175593 | 3175593 | 2022-12-19 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-20 04:21:04 | DeSoto, Mississippi, US | |
1630110 | 1630110 | 2022-12-18 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-19 04:21:03 | DeSoto, Mississippi, US | |
505489 | 505489 | 2022-12-17 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-18 04:21:03 | DeSoto, Mississippi, US | |
3326061 | 3326061 | 2022-12-16 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-17 04:21:04 | DeSoto, Mississippi, US | |
544573 | 544573 | 2022-12-15 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-16 04:21:01 | DeSoto, Mississippi, US | |
350101 | 350101 | 2022-12-14 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-15 04:20:58 | DeSoto, Mississippi, US | |
310578 | 310578 | 2022-12-13 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-14 04:21:04 | Monroe, Pennsylvania, US | |
309689 | 309689 | 2022-12-13 | US | Mississippi | DeSoto | 28033 | 59204 | 572 | 0 | 34.87625235 | -89.99091418 | 2022-12-14 04:21:04 | DeSoto, Mississippi, US | |
1151639 | 1151639 | 2022-12-12 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-13 04:21:01 | Monroe, Pennsylvania, US | |
871493 | 871493 | 2022-12-11 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-12 04:21:01 | Monroe, Pennsylvania, US | |
260023 | 260023 | 2022-12-10 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-11 04:20:50 | Monroe, Pennsylvania, US | |
3938737 | 3938737 | 2022-12-09 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-10 04:21:02 | Monroe, Pennsylvania, US | |
3936051 | 3936051 | 2022-12-09 | Japan | Miyagi | 392309 | 572 | 0 | 38.446859 | 140.927086 | 2022-12-10 04:21:02 | Miyagi, Japan | |||
3380069 | 3380069 | 2022-12-08 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-09 04:21:05 | Monroe, Pennsylvania, US | |
1987340 | 1987340 | 2022-12-07 | US | Pennsylvania | Monroe | 42089 | 45775 | 572 | 0 | 41.05934058 | -75.34031025 | 2022-12-08 04:21:07 | Monroe, Pennsylvania, US | |
2415512 | 2415512 | 2022-12-05 | US | Colorado | Larimer | 8069 | 104686 | 572 | 0 | 40.66671597 | -105.4625784 | 2022-12-06 04:21:03 | Larimer, Colorado, US | |
719120 | 719120 | 2022-12-04 | US | Colorado | Larimer | 8069 | 104482 | 572 | 0 | 40.66671597 | -105.4625784 | 2022-12-05 04:20:58 | Larimer, Colorado, US | |
2817409 | 2817409 | 2022-12-03 | US | Colorado | Larimer | 8069 | 104482 | 572 | 0 | 40.66671597 | -105.4625784 | 2022-12-04 04:20:56 | Larimer, Colorado, US | |
834265 | 834265 | 2022-12-02 | US | Colorado | Larimer | 8069 | 104482 | 572 | 0 | 40.66671597 | -105.4625784 | 2022-12-03 04:21:02 | Larimer, Colorado, US | |
2136795 | 2136795 | 2022-12-01 | US | Colorado | Larimer | 8069 | 104388 | 572 | 0 | 40.66671597 | -105.4625784 | 2022-12-02 04:21:07 | Larimer, Colorado, US | |
3554710 | 3554710 | 2022-11-27 | US | Texas | Comal | 48091 | 41196 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-28 04:21:02 | Comal, Texas, US | |
2103190 | 2103190 | 2022-11-26 | US | Texas | Comal | 48091 | 41196 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-27 04:21:05 | Comal, Texas, US | |
490681 | 490681 | 2022-11-25 | US | Texas | Comal | 48091 | 41196 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-26 04:21:11 | Comal, Texas, US | |
487644 | 487644 | 2022-11-25 | Japan | Tochigi | 273325 | 572 | 0 | 36.689912 | 139.819213 | 2022-11-26 04:21:11 | Tochigi, Japan | |||
487627 | 487627 | 2022-11-25 | Japan | Mie | 293046 | 572 | 0 | 34.508018 | 136.376013 | 2022-11-26 04:21:11 | Mie, Japan | |||
3526510 | 3526510 | 2022-11-24 | US | Texas | Comal | 48091 | 41196 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-25 04:21:06 | Comal, Texas, US | |
3523473 | 3523473 | 2022-11-24 | Japan | Tochigi | 271136 | 572 | 0 | 36.689912 | 139.819213 | 2022-11-25 04:21:06 | Tochigi, Japan | |||
3315293 | 3315293 | 2022-11-23 | US | Texas | Comal | 48091 | 41196 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-24 04:21:09 | Comal, Texas, US | |
3312226 | 3312226 | 2022-11-23 | Japan | Gunma | 286175 | 572 | 0 | 36.504479 | 138.985605 | 2022-11-24 04:21:09 | Gunma, Japan | |||
1623334 | 1623334 | 2022-11-22 | US | Texas | Comal | 48091 | 41167 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-23 04:21:06 | Comal, Texas, US | |
1622963 | 1622963 | 2022-11-22 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-23 04:21:06 | Lycoming, Pennsylvania, US | |
1620285 | 1620285 | 2022-11-22 | Japan | Nara | 249607 | 572 | 0 | 34.317451 | 135.871644 | 2022-11-23 04:21:06 | Nara, Japan | |||
3463222 | 3463222 | 2022-11-21 | US | Texas | Comal | 48091 | 41167 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-22 04:20:47 | Comal, Texas, US | |
3462851 | 3462851 | 2022-11-21 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-22 04:20:47 | Lycoming, Pennsylvania, US | |
3460173 | 3460173 | 2022-11-21 | Japan | Nara | 248684 | 572 | 0 | 34.317451 | 135.871644 | 2022-11-22 04:20:47 | Nara, Japan | |||
1643407 | 1643407 | 2022-11-20 | US | Texas | Comal | 48091 | 41144 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-21 04:21:05 | Comal, Texas, US | |
1643036 | 1643036 | 2022-11-20 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-21 04:21:05 | Lycoming, Pennsylvania, US | |
2066964 | 2066964 | 2022-11-19 | US | Texas | Comal | 48091 | 41144 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-20 04:21:08 | Comal, Texas, US | |
2066593 | 2066593 | 2022-11-19 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-20 04:21:08 | Lycoming, Pennsylvania, US | |
1758358 | 1758358 | 2022-11-18 | US | Texas | Comal | 48091 | 41144 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-19 04:21:14 | Comal, Texas, US | |
1757987 | 1757987 | 2022-11-18 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-19 04:21:14 | Lycoming, Pennsylvania, US | |
3029351 | 3029351 | 2022-11-17 | US | Texas | Comal | 48091 | 41106 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-18 04:21:15 | Comal, Texas, US | |
3028980 | 3028980 | 2022-11-17 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-18 04:21:15 | Lycoming, Pennsylvania, US | |
2489062 | 2489062 | 2022-11-16 | US | Texas | Comal | 48091 | 41106 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-17 04:21:11 | Comal, Texas, US | |
2488691 | 2488691 | 2022-11-16 | US | Pennsylvania | Lycoming | 42081 | 33333 | 572 | 0 | 41.34310539 | -77.06629984 | 2022-11-17 04:21:11 | Lycoming, Pennsylvania, US | |
295073 | 295073 | 2022-11-15 | US | Texas | Comal | 48091 | 41085 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-16 04:21:09 | Comal, Texas, US | |
294240 | 294240 | 2022-11-15 | US | New York | Broome | 36007 | 56072 | 572 | 0 | 42.15903158 | -75.81326086 | 2022-11-16 04:21:09 | Broome, New York, US | |
3600103 | 3600103 | 2022-11-14 | US | Texas | Comal | 48091 | 41085 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-15 04:21:16 | Comal, Texas, US | |
314961 | 314961 | 2022-11-13 | US | Texas | Comal | 48091 | 41040 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-14 04:21:09 | Comal, Texas, US | |
66122 | 66122 | 2022-11-12 | US | Texas | Comal | 48091 | 41040 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-13 04:21:14 | Comal, Texas, US | |
2930284 | 2930284 | 2022-11-11 | US | Texas | Comal | 48091 | 41040 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-12 04:20:41 | Comal, Texas, US | |
2509120 | 2509120 | 2022-11-10 | US | Texas | Comal | 48091 | 41040 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-11 04:21:22 | Comal, Texas, US | |
2433995 | 2433995 | 2022-11-09 | US | Texas | Comal | 48091 | 41040 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-10 04:21:16 | Comal, Texas, US | |
482651 | 482651 | 2022-11-08 | US | Texas | Comal | 48091 | 41024 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-09 04:21:22 | Comal, Texas, US | |
2441801 | 2441801 | 2022-11-07 | US | Texas | Comal | 48091 | 41024 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-08 04:21:21 | Comal, Texas, US | |
2440965 | 2440965 | 2022-11-07 | US | New York | Albany | 36001 | 74993 | 572 | 0 | 42.60060306 | -73.97723916 | 2022-11-08 04:21:21 | Albany, New York, US | |
1052899 | 1052899 | 2022-11-06 | US | Texas | Comal | 48091 | 41009 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-07 04:21:26 | Comal, Texas, US | |
1052063 | 1052063 | 2022-11-06 | US | New York | Albany | 36001 | 74962 | 572 | 0 | 42.60060306 | -73.97723916 | 2022-11-07 04:21:26 | Albany, New York, US | |
620923 | 620923 | 2022-11-05 | US | Texas | Comal | 48091 | 41009 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-06 04:21:24 | Comal, Texas, US | |
620087 | 620087 | 2022-11-05 | US | New York | Albany | 36001 | 74923 | 572 | 0 | 42.60060306 | -73.97723916 | 2022-11-06 04:21:24 | Albany, New York, US | |
1025427 | 1025427 | 2022-11-04 | US | Texas | Comal | 48091 | 41009 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-05 04:21:52 | Comal, Texas, US | |
1024591 | 1024591 | 2022-11-04 | US | New York | Albany | 36001 | 74871 | 572 | 0 | 42.60060306 | -73.97723916 | 2022-11-05 04:21:52 | Albany, New York, US | |
434418 | 434418 | 2022-11-03 | US | Texas | Comal | 48091 | 40967 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-04 04:22:11 | Comal, Texas, US | |
852660 | 852660 | 2022-11-02 | US | Texas | Comal | 48091 | 40967 | 572 | 0 | 29.80811278 | -98.27647225 | 2022-11-03 04:22:05 | Comal, Texas, US | |
3252513 | 3252513 | 2022-10-11 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-12 04:22:51 | Robeson, North Carolina, US | |
2969772 | 2969772 | 2022-10-10 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-11 04:23:05 | Robeson, North Carolina, US | |
3099808 | 3099808 | 2022-10-09 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-10 04:22:32 | Robeson, North Carolina, US | |
4005033 | 4005033 | 2022-10-08 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-09 04:21:16 | Robeson, North Carolina, US | |
398630 | 398630 | 2022-10-07 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-08 04:22:56 | Robeson, North Carolina, US | |
2531747 | 2531747 | 2022-10-06 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-07 04:23:08 | Robeson, North Carolina, US | |
1813141 | 1813141 | 2022-10-05 | US | North Carolina | Robeson | 37155 | 48409 | 572 | 0 | 34.64244496 | -79.1025053 | 2022-10-06 04:21:22 | Robeson, North Carolina, US | |
131169 | 131169 | 2022-10-04 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-10-05 04:23:06 | Anchorage, Alaska, US | |
2686116 | 2686116 | 2022-10-03 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-10-04 04:22:55 | Anchorage, Alaska, US | |
2260183 | 2260183 | 2022-10-02 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-10-03 04:23:11 | Anchorage, Alaska, US | |
2995709 | 2995709 | 2022-10-01 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-10-02 04:21:23 | Anchorage, Alaska, US | |
854035 | 854035 | 2022-09-30 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-10-01 04:23:01 | Anchorage, Alaska, US | |
2375961 | 2375961 | 2022-09-29 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-30 04:23:09 | Anchorage, Alaska, US | |
1560512 | 1560512 | 2022-09-28 | US | Alaska | Anchorage | 2020 | 120636 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-29 04:22:34 | Anchorage, Alaska, US | |
3995055 | 3995055 | 2022-09-27 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-28 04:23:01 | Anchorage, Alaska, US | |
2769383 | 2769383 | 2022-09-26 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-27 04:23:01 | Anchorage, Alaska, US | |
1977036 | 1977036 | 2022-09-25 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-26 04:20:52 | Anchorage, Alaska, US | |
2650203 | 2650203 | 2022-09-24 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-25 04:23:31 | Anchorage, Alaska, US | |
384643 | 384643 | 2022-09-23 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-24 04:21:40 | Anchorage, Alaska, US | |
1624709 | 1624709 | 2022-09-22 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-23 04:23:13 | Anchorage, Alaska, US | |
1370913 | 1370913 | 2022-09-21 | US | Alaska | Anchorage | 2020 | 120454 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-22 04:22:56 | Anchorage, Alaska, US | |
2017143 | 2017143 | 2022-09-20 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-21 04:23:22 | Anchorage, Alaska, US | |
3571016 | 3571016 | 2022-09-19 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-20 04:22:48 | Anchorage, Alaska, US | |
419755 | 419755 | 2022-09-18 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-19 04:21:49 | Anchorage, Alaska, US | |
3373779 | 3373779 | 2022-09-17 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-18 04:22:50 | Anchorage, Alaska, US | |
2355887 | 2355887 | 2022-09-16 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-17 04:20:19 | Anchorage, Alaska, US | |
3987044 | 3987044 | 2022-09-15 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-16 04:21:19 | Anchorage, Alaska, US | |
1889561 | 1889561 | 2022-09-14 | US | Alaska | Anchorage | 2020 | 120219 | 572 | 0 | 61.14998174 | -149.1426986 | 2022-09-15 04:21:02 | Anchorage, Alaska, US | |
2633728 | 2633728 | 2022-09-05 | Japan | Kumamoto | 303311 | 572 | 0 | 32.608154 | 130.745231 | 2022-09-06 04:21:02 | Kumamoto, Japan | |||
3775004 | 3775004 | 2022-08-30 | US | Indiana | Hendricks | 18063 | 44696 | 572 | 0 | 39.76719009 | -86.51037283 | 2022-08-31 04:20:57 | Hendricks, Indiana, US | |
1681600 | 1681600 | 2022-08-29 | US | Indiana | Hendricks | 18063 | 44696 | 572 | 0 | 39.76719009 | -86.51037283 | 2022-08-30 04:21:03 | Hendricks, Indiana, US | |
2325972 | 2325972 | 2022-08-24 | US | Oregon | Jackson | 41029 | 49889 | 572 | 0 | 42.43201126 | -122.7289309 | 2022-08-25 04:21:13 | Jackson, Oregon, US | |
1253381 | 1253381 | 2022-08-23 | US | Oregon | Jackson | 41029 | 49827 | 572 | 0 | 42.43201126 | -122.7289309 | 2022-08-24 04:20:46 | Jackson, Oregon, US | |
2855485 | 2855485 | 2022-08-22 | US | Oregon | Jackson | 41029 | 49777 | 572 | 0 | 42.43201126 | -122.7289309 | 2022-08-23 04:20:56 | Jackson, Oregon, US | |
2405457 | 2405457 | 2022-08-21 | US | Oregon | Jackson | 41029 | 49684 | 572 | 0 | 42.43201126 | -122.7289309 | 2022-08-22 04:20:38 | Jackson, Oregon, 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]);