daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
478 rows where deaths = 677 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-30 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-12-01 04:21:03 | Sormland, Sweden | |||
2022-11-29 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-30 04:21:07 | Sormland, Sweden | |||
2022-11-28 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-29 04:21:05 | Sormland, Sweden | |||
2022-11-27 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-28 04:21:02 | Sormland, Sweden | |||
2022-11-26 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-27 04:21:05 | Sormland, Sweden | |||
2022-11-25 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-26 04:21:11 | Sormland, Sweden | |||
2022-11-24 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-25 04:21:06 | Sormland, Sweden | |||
2022-11-16 | US | Wisconsin | Kenosha | 55059 | 53334 | 677 | 0 | 42.57639354 | -88.04051686 | 2022-11-17 04:21:11 | Kenosha, Wisconsin, US | |
2022-11-06 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-07 04:21:26 | Fayette, Kentucky, US | |
2022-11-05 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-06 04:21:24 | Fayette, Kentucky, US | |
2022-11-04 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-05 04:21:52 | Fayette, Kentucky, US | |
2022-11-03 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-04 04:22:11 | Fayette, Kentucky, US | |
2022-11-02 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-03 04:22:05 | Fayette, Kentucky, US | |
2022-11-01 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-02 04:22:09 | Fayette, Kentucky, US | |
2022-10-31 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-01 04:22:36 | Fayette, Kentucky, US | |
2022-10-27 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-28 04:22:31 | Western Australia, Australia | |||
2022-10-26 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-27 04:22:01 | Western Australia, Australia | |||
2022-10-25 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-26 04:22:19 | Western Australia, Australia | |||
2022-10-24 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-25 04:21:53 | Western Australia, Australia | |||
2022-10-23 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-24 04:22:29 | Western Australia, Australia | |||
2022-10-22 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-23 04:22:46 | Western Australia, Australia | |||
2022-10-21 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-22 04:22:53 | Western Australia, Australia | |||
2022-10-20 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-21 04:22:23 | Western Australia, Australia | |||
2022-10-16 | US | Arkansas | Washington | 5143 | 76989 | 677 | 0 | 35.976844 | -94.21800746 | 2022-10-17 04:20:31 | Washington, Arkansas, US | |
2022-10-15 | US | Arkansas | Washington | 5143 | 76975 | 677 | 0 | 35.976844 | -94.21800746 | 2022-10-16 04:22:39 | Washington, Arkansas, US | |
2022-09-20 | Italy | Molise | 89223 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-21 04:23:22 | Molise, Italy | |||
2022-09-19 | Italy | Molise | 89120 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-20 04:22:48 | Molise, Italy | |||
2022-09-18 | Italy | Molise | 89079 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-19 04:21:49 | Molise, Italy | |||
2022-09-14 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-15 04:21:02 | Southwest Utah, Utah, US | ||
2022-09-13 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-14 04:20:44 | Southwest Utah, Utah, US | ||
2022-09-12 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-13 04:20:57 | Southwest Utah, Utah, US | ||
2022-09-11 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-12 04:20:58 | Southwest Utah, Utah, US | ||
2022-09-10 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-11 04:20:50 | Southwest Utah, Utah, US | ||
2022-09-09 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-10 04:21:10 | Southwest Utah, Utah, US | ||
2022-09-08 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-09 04:21:11 | Southwest Utah, Utah, US | ||
2022-08-07 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-08 04:21:08 | Harrison, Mississippi, US | |
2022-08-06 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-07 04:20:54 | Harrison, Mississippi, US | |
2022-08-05 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-06 04:20:56 | Harrison, Mississippi, US | |
2022-08-04 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-05 04:20:52 | Harrison, Mississippi, US | |
2022-08-01 | US | New York | Dutchess | 36027 | 73637 | 677 | 0 | 41.7648606 | -73.74356679 | 2022-08-02 04:20:53 | Dutchess, New York, US | |
2022-07-20 | US | Oregon | Clackamas | 41005 | 73353 | 677 | 0 | 45.18787398 | -122.2179634 | 2022-07-21 04:21:10 | Clackamas, Oregon, US | |
2022-06-15 | Qatar | 373691 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-16 04:20:55 | Qatar | ||||
2022-06-14 | Qatar | 373178 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-15 04:20:54 | Qatar | ||||
2022-06-13 | Qatar | 372704 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-14 04:20:52 | Qatar | ||||
2022-06-12 | Qatar | 372261 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-13 04:21:14 | Qatar | ||||
2022-06-11 | Qatar | 371846 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-12 04:20:53 | Qatar | ||||
2022-06-10 | Qatar | 371585 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-11 04:21:01 | Qatar | ||||
2022-06-09 | Qatar | 371247 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-10 04:20:55 | Qatar | ||||
2022-06-08 | Qatar | 370924 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-09 04:20:54 | Qatar | ||||
2022-06-07 | Qatar | 370551 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-08 04:20:55 | Qatar | ||||
2022-06-06 | Qatar | 370235 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-07 04:21:08 | Qatar | ||||
2022-06-05 | Qatar | 369929 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-06 04:20:57 | Qatar | ||||
2022-06-04 | Qatar | 369526 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-05 04:20:55 | Qatar | ||||
2022-06-03 | Qatar | 369526 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-04 04:20:58 | Qatar | ||||
2022-06-02 | Qatar | 369305 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-03 04:20:58 | Qatar | ||||
2022-06-01 | Qatar | 369049 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-02 05:20:39 | Qatar | ||||
2022-05-31 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-06-01 04:20:55 | Schuylkill, Pennsylvania, US | |
2022-05-31 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-06-01 04:20:55 | Fayette, Pennsylvania, US | |
2022-05-31 | Qatar | 368788 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-01 04:20:55 | Qatar | ||||
2022-05-31 | Belize | 59365 | 677 | 0 | 17.1899 | -88.4976 | 2022-06-01 04:20:55 | Belize | ||||
2022-05-30 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-31 04:20:51 | Schuylkill, Pennsylvania, US | |
2022-05-30 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-31 04:20:51 | Fayette, Pennsylvania, US | |
2022-05-30 | Qatar | 368519 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-31 04:20:51 | Qatar | ||||
2022-05-30 | Belize | 59243 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-31 04:20:51 | Belize | ||||
2022-05-29 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-30 04:20:50 | Schuylkill, Pennsylvania, US | |
2022-05-29 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-30 04:20:50 | Fayette, Pennsylvania, US | |
2022-05-29 | Qatar | 368285 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-30 04:20:50 | Qatar | ||||
2022-05-29 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-30 04:20:50 | Belize | ||||
2022-05-28 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-29 04:20:53 | Schuylkill, Pennsylvania, US | |
2022-05-28 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-29 04:20:53 | Fayette, Pennsylvania, US | |
2022-05-28 | Qatar | 368087 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-29 04:20:53 | Qatar | ||||
2022-05-28 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-29 04:20:53 | Belize | ||||
2022-05-27 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-28 04:21:07 | Schuylkill, Pennsylvania, US | |
2022-05-27 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-28 04:21:07 | Fayette, Pennsylvania, US | |
2022-05-27 | Qatar | 367939 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-28 04:21:07 | Qatar | ||||
2022-05-27 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-28 04:21:07 | Belize | ||||
2022-05-26 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-27 04:20:56 | Schuylkill, Pennsylvania, US | |
2022-05-26 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-27 04:20:56 | Fayette, Pennsylvania, US | |
2022-05-26 | Qatar | 367807 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-27 04:20:56 | Qatar | ||||
2022-05-26 | Belize | 58949 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-27 04:20:56 | Belize | ||||
2022-05-25 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-26 04:20:50 | Schuylkill, Pennsylvania, US | |
2022-05-25 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-26 04:20:50 | Fayette, Pennsylvania, US | |
2022-05-25 | Qatar | 367617 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-26 04:20:50 | Qatar | ||||
2022-05-25 | Belize | 58873 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-26 04:20:50 | Belize | ||||
2022-05-24 | Qatar | 367436 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-25 04:20:56 | Qatar | ||||
2022-05-24 | Belize | 58749 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-25 04:20:56 | Belize | ||||
2022-05-23 | Qatar | 367272 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-24 04:20:57 | Qatar | ||||
2022-05-23 | Belize | 58617 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-24 04:20:57 | Belize | ||||
2022-05-22 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-26 04:20:50 | Schuylkill, Pennsylvania, US | |
2022-05-22 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-26 04:20:50 | Fayette, Pennsylvania, US | |
2022-05-22 | Qatar | 367617 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-26 04:20:50 | Qatar | ||||
2022-05-22 | Belize | 58873 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-26 04:20:50 | Belize | ||||
2022-05-21 | Qatar | 366952 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-22 04:20:52 | Qatar | ||||
2022-05-21 | Belize | 58419 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-22 04:20:52 | Belize | ||||
2022-05-20 | Qatar | 366851 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-21 04:20:58 | Qatar | ||||
2022-05-20 | Belize | 58419 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-21 04:20:58 | Belize | ||||
2022-05-19 | Qatar | 366724 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-20 04:20:57 | Qatar | ||||
2022-05-19 | Belize | 58332 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-20 04:20:57 | Belize | ||||
2022-05-18 | Qatar | 366603 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-19 04:20:54 | Qatar | ||||
2022-05-18 | Belize | 58215 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-19 04:20:54 | Belize |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;