johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
433 rows where deaths = 679 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330538 | 330538 | 2022-12-27 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-28 04:21:04 | Lane, Oregon, US | |
220611 | 220611 | 2022-12-26 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-27 04:21:07 | Lane, Oregon, US | |
3225068 | 3225068 | 2022-12-25 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-26 04:21:06 | Lane, Oregon, US | |
1020982 | 1020982 | 2022-12-24 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-25 04:21:04 | Lane, Oregon, US | |
693005 | 693005 | 2022-12-23 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-24 04:21:02 | Lane, Oregon, US | |
2182215 | 2182215 | 2022-12-22 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-23 04:21:04 | Lane, Oregon, US | |
454019 | 454019 | 2022-12-21 | US | Oregon | Lane | 41039 | 76860 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-22 04:20:56 | Lane, Oregon, US | |
2954018 | 2954018 | 2022-12-20 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-21 04:21:03 | Lane, Oregon, US | |
2952165 | 2952165 | 2022-12-20 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-21 04:21:03 | Cherokee, Georgia, US | |
3176420 | 3176420 | 2022-12-19 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-20 04:21:04 | Lane, Oregon, US | |
3174567 | 3174567 | 2022-12-19 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-20 04:21:04 | Cherokee, Georgia, US | |
1630937 | 1630937 | 2022-12-18 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-19 04:21:03 | Lane, Oregon, US | |
1629084 | 1629084 | 2022-12-18 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-19 04:21:03 | Cherokee, Georgia, US | |
506316 | 506316 | 2022-12-17 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-18 04:21:03 | Lane, Oregon, US | |
504463 | 504463 | 2022-12-17 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-18 04:21:03 | Cherokee, Georgia, US | |
3326888 | 3326888 | 2022-12-16 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-17 04:21:04 | Lane, Oregon, US | |
3325035 | 3325035 | 2022-12-16 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-17 04:21:04 | Cherokee, Georgia, US | |
545400 | 545400 | 2022-12-15 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-16 04:21:01 | Lane, Oregon, US | |
543547 | 543547 | 2022-12-15 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-16 04:21:01 | Cherokee, Georgia, US | |
350928 | 350928 | 2022-12-14 | US | Oregon | Lane | 41039 | 76466 | 679 | 0 | 43.93727035 | -122.847753 | 2022-12-15 04:20:58 | Lane, Oregon, US | |
349075 | 349075 | 2022-12-14 | US | Georgia | Cherokee | 13057 | 73326 | 679 | 0 | 34.24393976 | -84.47431861 | 2022-12-15 04:20:58 | Cherokee, Georgia, US | |
2100122 | 2100122 | 2022-11-26 | Japan | Gifu | 353904 | 679 | 0 | 35.778671 | 137.055925 | 2022-11-27 04:21:05 | Gifu, Japan | |||
3460166 | 3460166 | 2022-11-21 | Japan | Kumamoto | 358958 | 679 | 0 | 32.608154 | 130.745231 | 2022-11-22 04:20:47 | Kumamoto, Japan | |||
1643906 | 1643906 | 2022-11-20 | US | Wisconsin | Kenosha | 55059 | 53409 | 679 | 0 | 42.57639354 | -88.04051686 | 2022-11-21 04:21:05 | Kenosha, Wisconsin, US | |
1640351 | 1640351 | 2022-11-20 | Japan | Kumamoto | 358519 | 679 | 0 | 32.608154 | 130.745231 | 2022-11-21 04:21:05 | Kumamoto, Japan | |||
2067463 | 2067463 | 2022-11-19 | US | Wisconsin | Kenosha | 55059 | 53409 | 679 | 0 | 42.57639354 | -88.04051686 | 2022-11-20 04:21:08 | Kenosha, Wisconsin, US | |
1758857 | 1758857 | 2022-11-18 | US | Wisconsin | Kenosha | 55059 | 53409 | 679 | 0 | 42.57639354 | -88.04051686 | 2022-11-19 04:21:14 | Kenosha, Wisconsin, US | |
3286575 | 3286575 | 2022-10-31 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-11-01 04:22:36 | Muskegon, Michigan, US | |
321608 | 321608 | 2022-10-30 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-31 04:21:36 | Muskegon, Michigan, US | |
913884 | 913884 | 2022-10-29 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-30 04:22:14 | Muskegon, Michigan, US | |
1368153 | 1368153 | 2022-10-28 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-29 04:21:13 | Muskegon, Michigan, US | |
3040008 | 3040008 | 2022-10-27 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-28 04:22:31 | Muskegon, Michigan, US | |
540428 | 540428 | 2022-10-26 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-27 04:22:01 | Muskegon, Michigan, US | |
1831829 | 1831829 | 2022-10-25 | US | Michigan | Muskegon | 26121 | 46226 | 679 | 0 | 43.29123859 | -86.15176712 | 2022-10-26 04:22:19 | Muskegon, Michigan, US | |
201535 | 201535 | 2022-10-19 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-20 04:22:59 | Southwest Utah, Utah, US | ||
198634 | 198634 | 2022-10-19 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-20 04:22:59 | Etowah, Alabama, US | |
2760196 | 2760196 | 2022-10-18 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-19 04:22:26 | Southwest Utah, Utah, US | ||
2757458 | 2757458 | 2022-10-18 | US | Arkansas | Washington | 5143 | 77036 | 679 | 0 | 35.976844 | -94.21800746 | 2022-10-19 04:22:26 | Washington, Arkansas, US | |
2757295 | 2757295 | 2022-10-18 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-19 04:22:26 | Etowah, Alabama, US | |
2028030 | 2028030 | 2022-10-17 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-18 04:22:42 | Southwest Utah, Utah, US | ||
2025129 | 2025129 | 2022-10-17 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-18 04:22:42 | Etowah, Alabama, US | |
2162808 | 2162808 | 2022-10-16 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-17 04:20:31 | Southwest Utah, Utah, US | ||
2159907 | 2159907 | 2022-10-16 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-17 04:20:31 | Etowah, Alabama, US | |
519005 | 519005 | 2022-10-15 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-16 04:22:39 | Southwest Utah, Utah, US | ||
516104 | 516104 | 2022-10-15 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-16 04:22:39 | Etowah, Alabama, US | |
2036062 | 2036062 | 2022-10-14 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-15 04:22:00 | Southwest Utah, Utah, US | ||
2033161 | 2033161 | 2022-10-14 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-15 04:22:00 | Etowah, Alabama, US | |
3756750 | 3756750 | 2022-10-13 | US | Utah | Southwest Utah | 69380 | 679 | 0 | 37.85447192 | -111.4418764 | 2022-10-14 04:22:28 | Southwest Utah, Utah, US | ||
3753849 | 3753849 | 2022-10-13 | US | Alabama | Etowah | 1055 | 32292 | 679 | 0 | 34.04567266 | -86.04051873 | 2022-10-14 04:22:28 | Etowah, Alabama, US | |
1810544 | 1810544 | 2022-10-05 | Chile | Atacama | 101664 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-06 04:21:22 | Atacama, Chile | |||
130722 | 130722 | 2022-10-04 | Italy | Molise | 90764 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-10-05 04:23:06 | Molise, Italy | |||
130518 | 130518 | 2022-10-04 | Chile | Atacama | 101603 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-05 04:23:06 | Atacama, Chile | |||
2685669 | 2685669 | 2022-10-03 | Italy | Molise | 90631 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-10-04 04:22:55 | Molise, Italy | |||
2685465 | 2685465 | 2022-10-03 | Chile | Atacama | 101572 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-04 04:22:55 | Atacama, Chile | |||
2259736 | 2259736 | 2022-10-02 | Italy | Molise | 90529 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-10-03 04:23:11 | Molise, Italy | |||
2259532 | 2259532 | 2022-10-02 | Chile | Atacama | 101543 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-03 04:23:11 | Atacama, Chile | |||
2995262 | 2995262 | 2022-10-01 | Italy | Molise | 90392 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-10-02 04:21:23 | Molise, Italy | |||
2995058 | 2995058 | 2022-10-01 | Chile | Atacama | 101482 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-02 04:21:23 | Atacama, Chile | |||
853588 | 853588 | 2022-09-30 | Italy | Molise | 90269 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-10-01 04:23:01 | Molise, Italy | |||
853384 | 853384 | 2022-09-30 | Chile | Atacama | 101429 | 679 | 0 | -27.5661 | -70.0503 | 2022-10-01 04:23:01 | Atacama, Chile | |||
2375514 | 2375514 | 2022-09-29 | Italy | Molise | 90134 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-09-30 04:23:09 | Molise, Italy | |||
2375310 | 2375310 | 2022-09-29 | Chile | Atacama | 101369 | 679 | 0 | -27.5661 | -70.0503 | 2022-09-30 04:23:09 | Atacama, Chile | |||
1560065 | 1560065 | 2022-09-28 | Italy | Molise | 89991 | 679 | 0 | 41.55774754 | 14.65916051 | 2022-09-29 04:22:34 | Molise, Italy | |||
1559861 | 1559861 | 2022-09-28 | Chile | Atacama | 101319 | 679 | 0 | -27.5661 | -70.0503 | 2022-09-29 04:22:34 | Atacama, Chile | |||
3994404 | 3994404 | 2022-09-27 | Chile | Atacama | 101234 | 679 | 0 | -27.5661 | -70.0503 | 2022-09-28 04:23:01 | Atacama, Chile | |||
2768732 | 2768732 | 2022-09-26 | Chile | Atacama | 101201 | 679 | 0 | -27.5661 | -70.0503 | 2022-09-27 04:23:01 | Atacama, Chile | |||
2712995 | 2712995 | 2022-09-03 | Japan | Shizuoka | 437775 | 679 | 0 | 34.916975 | 138.407784 | 2022-09-04 04:21:22 | Shizuoka, Japan | |||
3776616 | 3776616 | 2022-08-30 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-31 04:20:57 | Washington, Pennsylvania, US | |
1683212 | 1683212 | 2022-08-29 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-30 04:21:03 | Washington, Pennsylvania, US | |
1879696 | 1879696 | 2022-08-28 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-29 04:21:06 | Washington, Pennsylvania, US | |
2098823 | 2098823 | 2022-08-27 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-28 04:21:02 | Washington, Pennsylvania, US | |
1534638 | 1534638 | 2022-08-26 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-27 04:20:57 | Washington, Pennsylvania, US | |
2831525 | 2831525 | 2022-08-25 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-26 04:21:02 | Washington, Pennsylvania, US | |
2326058 | 2326058 | 2022-08-24 | US | Pennsylvania | Washington | 42125 | 58073 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-25 04:21:13 | Washington, Pennsylvania, US | |
1253467 | 1253467 | 2022-08-23 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-24 04:20:46 | Washington, Pennsylvania, US | |
2855571 | 2855571 | 2022-08-22 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-23 04:20:56 | Washington, Pennsylvania, US | |
2405543 | 2405543 | 2022-08-21 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-22 04:20:38 | Washington, Pennsylvania, US | |
3800621 | 3800621 | 2022-08-20 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-21 04:20:44 | Washington, Pennsylvania, US | |
2366207 | 2366207 | 2022-08-19 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-20 04:21:01 | Washington, Pennsylvania, US | |
1163878 | 1163878 | 2022-08-18 | US | Pennsylvania | Washington | 42125 | 57603 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-19 04:20:54 | Washington, Pennsylvania, US | |
3953202 | 3953202 | 2022-08-17 | US | Pennsylvania | Washington | 42125 | 57554 | 679 | 0 | 40.19208869 | -80.24582867 | 2022-08-18 04:21:11 | Washington, Pennsylvania, US | |
993638 | 993638 | 2022-08-16 | US | Oregon | Washington | 41067 | 110124 | 679 | 0 | 45.55972701 | -123.0955257 | 2022-08-17 04:20:59 | Washington, Oregon, US | |
3649392 | 3649392 | 2022-08-14 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-15 04:20:59 | Harrison, Mississippi, US | |
1970398 | 1970398 | 2022-08-13 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-14 04:20:55 | Harrison, Mississippi, US | |
2890207 | 2890207 | 2022-08-12 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-13 04:20:52 | Harrison, Mississippi, US | |
3909812 | 3909812 | 2022-08-11 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-12 04:20:54 | Harrison, Mississippi, US | |
1348129 | 1348129 | 2022-08-10 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-11 04:20:49 | Harrison, Mississippi, US | |
1087884 | 1087884 | 2022-08-09 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-10 04:20:57 | Harrison, Mississippi, US | |
3545725 | 3545725 | 2022-08-08 | US | New York | Dutchess | 36027 | 74133 | 679 | 0 | 41.7648606 | -73.74356679 | 2022-08-09 04:20:34 | Dutchess, New York, US | |
3545299 | 3545299 | 2022-08-08 | US | Mississippi | Harrison | 28047 | 60073 | 679 | 0 | 30.51359752 | -89.12467576 | 2022-08-09 04:20:34 | Harrison, Mississippi, US | |
1072128 | 1072128 | 2022-08-07 | US | New York | Dutchess | 36027 | 74079 | 679 | 0 | 41.7648606 | -73.74356679 | 2022-08-08 04:21:08 | Dutchess, New York, US | |
1942716 | 1942716 | 2022-08-06 | US | New York | Dutchess | 36027 | 73998 | 679 | 0 | 41.7648606 | -73.74356679 | 2022-08-07 04:20:54 | Dutchess, New York, US | |
882515 | 882515 | 2022-08-05 | US | New York | Dutchess | 36027 | 73916 | 679 | 0 | 41.7648606 | -73.74356679 | 2022-08-06 04:20:56 | Dutchess, New York, US | |
2010926 | 2010926 | 2022-08-04 | US | New York | Dutchess | 36027 | 73835 | 679 | 0 | 41.7648606 | -73.74356679 | 2022-08-05 04:20:52 | Dutchess, New York, US | |
1405759 | 1405759 | 2022-08-02 | US | Florida | Leon | 12073 | 101148 | 679 | 0 | 30.45955727 | -84.27491114 | 2022-08-03 04:20:59 | Leon, Florida, US | |
3617797 | 3617797 | 2022-08-01 | US | Florida | Leon | 12073 | 101148 | 679 | 0 | 30.45955727 | -84.27491114 | 2022-08-02 04:20:53 | Leon, Florida, US | |
3616765 | 3616765 | 2022-08-01 | Australia | South Australia | 711189 | 679 | 0 | -34.9285 | 138.6007 | 2022-08-02 04:20:53 | South Australia, Australia | |||
3872277 | 3872277 | 2022-07-31 | US | Florida | Leon | 12073 | 101148 | 679 | 0 | 30.45955727 | -84.27491114 | 2022-08-01 04:21:03 | Leon, Florida, US | |
3871245 | 3871245 | 2022-07-31 | Australia | South Australia | 711189 | 679 | 0 | -34.9285 | 138.6007 | 2022-08-01 04:21:03 | South Australia, Australia | |||
675031 | 675031 | 2022-07-30 | US | Florida | Leon | 12073 | 101148 | 679 | 0 | 30.45955727 | -84.27491114 | 2022-07-31 04:21:02 | Leon, Florida, 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]);