johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1964901 | 1964901 | 2022-11-30 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-12-01 04:21:03 | Sormland, Sweden | |||
2556915 | 2556915 | 2022-11-29 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-30 04:21:07 | Sormland, Sweden | |||
1239989 | 1239989 | 2022-11-28 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-29 04:21:05 | Sormland, Sweden | |||
3551977 | 3551977 | 2022-11-27 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-28 04:21:02 | Sormland, Sweden | |||
2100457 | 2100457 | 2022-11-26 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-27 04:21:05 | Sormland, Sweden | |||
487948 | 487948 | 2022-11-25 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-26 04:21:11 | Sormland, Sweden | |||
3523777 | 3523777 | 2022-11-24 | Sweden | Sormland | 68541 | 677 | 0 | 59.0336 | 16.7519 | 2022-11-25 04:21:06 | Sormland, Sweden | |||
2489561 | 2489561 | 2022-11-16 | US | Wisconsin | Kenosha | 55059 | 53334 | 677 | 0 | 42.57639354 | -88.04051686 | 2022-11-17 04:21:11 | Kenosha, Wisconsin, US | |
1051241 | 1051241 | 2022-11-06 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-07 04:21:26 | Fayette, Kentucky, US | |
619265 | 619265 | 2022-11-05 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-06 04:21:24 | Fayette, Kentucky, US | |
1023769 | 1023769 | 2022-11-04 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-05 04:21:52 | Fayette, Kentucky, US | |
432760 | 432760 | 2022-11-03 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-04 04:22:11 | Fayette, Kentucky, US | |
851002 | 851002 | 2022-11-02 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-03 04:22:05 | Fayette, Kentucky, US | |
711853 | 711853 | 2022-11-01 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-02 04:22:09 | Fayette, Kentucky, US | |
3286302 | 3286302 | 2022-10-31 | US | Kentucky | Fayette | 21067 | 115322 | 677 | 0 | 38.0368225 | -84.45576892 | 2022-11-01 04:22:36 | Fayette, Kentucky, US | |
3038019 | 3038019 | 2022-10-27 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-28 04:22:31 | Western Australia, Australia | |||
538439 | 538439 | 2022-10-26 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-27 04:22:01 | Western Australia, Australia | |||
1829840 | 1829840 | 2022-10-25 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-26 04:22:19 | Western Australia, Australia | |||
794101 | 794101 | 2022-10-24 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-25 04:21:53 | Western Australia, Australia | |||
3276556 | 3276556 | 2022-10-23 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-24 04:22:29 | Western Australia, Australia | |||
2267594 | 2267594 | 2022-10-22 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-23 04:22:46 | Western Australia, Australia | |||
1591894 | 1591894 | 2022-10-21 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-22 04:22:53 | Western Australia, Australia | |||
2271610 | 2271610 | 2022-10-20 | Australia | Western Australia | 1168975 | 677 | 0 | -31.9505 | 115.8605 | 2022-10-21 04:22:23 | Western Australia, Australia | |||
2160070 | 2160070 | 2022-10-16 | US | Arkansas | Washington | 5143 | 76989 | 677 | 0 | 35.976844 | -94.21800746 | 2022-10-17 04:20:31 | Washington, Arkansas, US | |
516267 | 516267 | 2022-10-15 | US | Arkansas | Washington | 5143 | 76975 | 677 | 0 | 35.976844 | -94.21800746 | 2022-10-16 04:22:39 | Washington, Arkansas, US | |
2016696 | 2016696 | 2022-09-20 | Italy | Molise | 89223 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-21 04:23:22 | Molise, Italy | |||
3570569 | 3570569 | 2022-09-19 | Italy | Molise | 89120 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-20 04:22:48 | Molise, Italy | |||
419308 | 419308 | 2022-09-18 | Italy | Molise | 89079 | 677 | 0 | 41.55774754 | 14.65916051 | 2022-09-19 04:21:49 | Molise, Italy | |||
1892418 | 1892418 | 2022-09-14 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-15 04:21:02 | Southwest Utah, Utah, US | ||
375473 | 375473 | 2022-09-13 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-14 04:20:44 | Southwest Utah, Utah, US | ||
2398075 | 2398075 | 2022-09-12 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-13 04:20:57 | Southwest Utah, Utah, US | ||
3769153 | 3769153 | 2022-09-11 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-12 04:20:58 | Southwest Utah, Utah, US | ||
3827728 | 3827728 | 2022-09-10 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-11 04:20:50 | Southwest Utah, Utah, US | ||
966185 | 966185 | 2022-09-09 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-10 04:21:10 | Southwest Utah, Utah, US | ||
256587 | 256587 | 2022-09-08 | US | Utah | Southwest Utah | 68887 | 677 | 0 | 37.85447192 | -111.4418764 | 2022-09-09 04:21:11 | Southwest Utah, Utah, US | ||
1071702 | 1071702 | 2022-08-07 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-08 04:21:08 | Harrison, Mississippi, US | |
1942290 | 1942290 | 2022-08-06 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-07 04:20:54 | Harrison, Mississippi, US | |
882089 | 882089 | 2022-08-05 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-06 04:20:56 | Harrison, Mississippi, US | |
2010500 | 2010500 | 2022-08-04 | US | Mississippi | Harrison | 28047 | 59503 | 677 | 0 | 30.51359752 | -89.12467576 | 2022-08-05 04:20:52 | Harrison, Mississippi, US | |
3619316 | 3619316 | 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 | |
1610874 | 1610874 | 2022-07-20 | US | Oregon | Clackamas | 41005 | 73353 | 677 | 0 | 45.18787398 | -122.2179634 | 2022-07-21 04:21:10 | Clackamas, Oregon, US | |
3982793 | 3982793 | 2022-06-15 | Qatar | 373691 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-16 04:20:55 | Qatar | ||||
947034 | 947034 | 2022-06-14 | Qatar | 373178 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-15 04:20:54 | Qatar | ||||
2979442 | 2979442 | 2022-06-13 | Qatar | 372704 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-14 04:20:52 | Qatar | ||||
2235568 | 2235568 | 2022-06-12 | Qatar | 372261 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-13 04:21:14 | Qatar | ||||
3141766 | 3141766 | 2022-06-11 | Qatar | 371846 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-12 04:20:53 | Qatar | ||||
1944682 | 1944682 | 2022-06-10 | Qatar | 371585 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-11 04:21:01 | Qatar | ||||
3157821 | 3157821 | 2022-06-09 | Qatar | 371247 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-10 04:20:55 | Qatar | ||||
1421288 | 1421288 | 2022-06-08 | Qatar | 370924 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-09 04:20:54 | Qatar | ||||
3726402 | 3726402 | 2022-06-07 | Qatar | 370551 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-08 04:20:55 | Qatar | ||||
3887804 | 3887804 | 2022-06-06 | Qatar | 370235 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-07 04:21:08 | Qatar | ||||
3507573 | 3507573 | 2022-06-05 | Qatar | 369929 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-06 04:20:57 | Qatar | ||||
3527650 | 3527650 | 2022-06-04 | Qatar | 369526 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-05 04:20:55 | Qatar | ||||
3133736 | 3133736 | 2022-06-03 | Qatar | 369526 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-04 04:20:58 | Qatar | ||||
3578811 | 3578811 | 2022-06-02 | Qatar | 369305 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-03 04:20:58 | Qatar | ||||
971104 | 971104 | 2022-06-01 | Qatar | 369049 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-02 05:20:39 | Qatar | ||||
231926 | 231926 | 2022-05-31 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-06-01 04:20:55 | Schuylkill, Pennsylvania, US | |
231898 | 231898 | 2022-05-31 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-06-01 04:20:55 | Fayette, Pennsylvania, US | |
229411 | 229411 | 2022-05-31 | Qatar | 368788 | 677 | 0 | 25.3548 | 51.1839 | 2022-06-01 04:20:55 | Qatar | ||||
228933 | 228933 | 2022-05-31 | Belize | 59365 | 677 | 0 | 17.1899 | -88.4976 | 2022-06-01 04:20:55 | Belize | ||||
3188691 | 3188691 | 2022-05-30 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-31 04:20:51 | Schuylkill, Pennsylvania, US | |
3188663 | 3188663 | 2022-05-30 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-31 04:20:51 | Fayette, Pennsylvania, US | |
3186176 | 3186176 | 2022-05-30 | Qatar | 368519 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-31 04:20:51 | Qatar | ||||
3185698 | 3185698 | 2022-05-30 | Belize | 59243 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-31 04:20:51 | Belize | ||||
3200840 | 3200840 | 2022-05-29 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-30 04:20:50 | Schuylkill, Pennsylvania, US | |
3200812 | 3200812 | 2022-05-29 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-30 04:20:50 | Fayette, Pennsylvania, US | |
3198325 | 3198325 | 2022-05-29 | Qatar | 368285 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-30 04:20:50 | Qatar | ||||
3197847 | 3197847 | 2022-05-29 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-30 04:20:50 | Belize | ||||
2727718 | 2727718 | 2022-05-28 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-29 04:20:53 | Schuylkill, Pennsylvania, US | |
2727690 | 2727690 | 2022-05-28 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-29 04:20:53 | Fayette, Pennsylvania, US | |
2725203 | 2725203 | 2022-05-28 | Qatar | 368087 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-29 04:20:53 | Qatar | ||||
2724725 | 2724725 | 2022-05-28 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-29 04:20:53 | Belize | ||||
1316899 | 1316899 | 2022-05-27 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-28 04:21:07 | Schuylkill, Pennsylvania, US | |
1316871 | 1316871 | 2022-05-27 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-28 04:21:07 | Fayette, Pennsylvania, US | |
1314384 | 1314384 | 2022-05-27 | Qatar | 367939 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-28 04:21:07 | Qatar | ||||
1313906 | 1313906 | 2022-05-27 | Belize | 59049 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-28 04:21:07 | Belize | ||||
1852691 | 1852691 | 2022-05-26 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-27 04:20:56 | Schuylkill, Pennsylvania, US | |
1852663 | 1852663 | 2022-05-26 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-27 04:20:56 | Fayette, Pennsylvania, US | |
1850176 | 1850176 | 2022-05-26 | Qatar | 367807 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-27 04:20:56 | Qatar | ||||
1849698 | 1849698 | 2022-05-26 | Belize | 58949 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-27 04:20:56 | Belize | ||||
2050567 | 2050567 | 2022-05-25 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-26 04:20:50 | Schuylkill, Pennsylvania, US | |
2050539 | 2050539 | 2022-05-25 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-26 04:20:50 | Fayette, Pennsylvania, US | |
2048052 | 2048052 | 2022-05-25 | Qatar | 367617 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-26 04:20:50 | Qatar | ||||
2047574 | 2047574 | 2022-05-25 | Belize | 58873 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-26 04:20:50 | Belize | ||||
2999490 | 2999490 | 2022-05-24 | Qatar | 367436 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-25 04:20:56 | Qatar | ||||
2999012 | 2999012 | 2022-05-24 | Belize | 58749 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-25 04:20:56 | Belize | ||||
3593211 | 3593211 | 2022-05-23 | Qatar | 367272 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-24 04:20:57 | Qatar | ||||
3592733 | 3592733 | 2022-05-23 | Belize | 58617 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-24 04:20:57 | Belize | ||||
624578 | 624578 | 2022-05-22 | US | Pennsylvania | Schuylkill | 42107 | 35370 | 677 | 0 | 40.70497338 | -76.2150785 | 2022-05-26 04:20:50 | Schuylkill, Pennsylvania, US | |
624550 | 624550 | 2022-05-22 | US | Pennsylvania | Fayette | 42051 | 31728 | 677 | 0 | 39.92041012 | -79.64291195 | 2022-05-26 04:20:50 | Fayette, Pennsylvania, US | |
622063 | 622063 | 2022-05-22 | Qatar | 367617 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-26 04:20:50 | Qatar | ||||
621585 | 621585 | 2022-05-22 | Belize | 58873 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-26 04:20:50 | Belize | ||||
1109759 | 1109759 | 2022-05-21 | Qatar | 366952 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-22 04:20:52 | Qatar | ||||
1109281 | 1109281 | 2022-05-21 | Belize | 58419 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-22 04:20:52 | Belize | ||||
1169383 | 1169383 | 2022-05-20 | Qatar | 366851 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-21 04:20:58 | Qatar | ||||
1168905 | 1168905 | 2022-05-20 | Belize | 58419 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-21 04:20:58 | Belize | ||||
3896146 | 3896146 | 2022-05-19 | Qatar | 366724 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-20 04:20:57 | Qatar | ||||
3895668 | 3895668 | 2022-05-19 | Belize | 58332 | 677 | 0 | 17.1899 | -88.4976 | 2022-05-20 04:20:57 | Belize | ||||
1184930 | 1184930 | 2022-05-18 | Qatar | 366603 | 677 | 0 | 25.3548 | 51.1839 | 2022-05-19 04:20:54 | Qatar | ||||
1184452 | 1184452 | 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 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]);