johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
649 rows where deaths = 595 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752711 | 2752711 | 2022-12-29 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-30 04:21:04 | Shanghai, China | |||
1073717 | 1073717 | 2022-12-28 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-29 04:21:01 | Shanghai, China | |||
327714 | 327714 | 2022-12-27 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-28 04:21:04 | Shanghai, China | |||
217787 | 217787 | 2022-12-26 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-27 04:21:07 | Shanghai, China | |||
3222244 | 3222244 | 2022-12-25 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-26 04:21:06 | Shanghai, China | |||
1018158 | 1018158 | 2022-12-24 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-25 04:21:04 | Shanghai, China | |||
690181 | 690181 | 2022-12-23 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-24 04:21:02 | Shanghai, China | |||
2179391 | 2179391 | 2022-12-22 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-23 04:21:04 | Shanghai, China | |||
451195 | 451195 | 2022-12-21 | China | Shanghai | 65423 | 595 | 0 | 31.202 | 121.4491 | 2022-12-22 04:20:56 | Shanghai, China | |||
2951194 | 2951194 | 2022-12-20 | China | Shanghai | 65262 | 595 | 0 | 31.202 | 121.4491 | 2022-12-21 04:21:03 | Shanghai, China | |||
3174208 | 3174208 | 2022-12-19 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-20 04:21:04 | Anchorage, Alaska, US | |
3173596 | 3173596 | 2022-12-19 | China | Shanghai | 65262 | 595 | 0 | 31.202 | 121.4491 | 2022-12-20 04:21:04 | Shanghai, China | |||
1628725 | 1628725 | 2022-12-18 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-19 04:21:03 | Anchorage, Alaska, US | |
1628113 | 1628113 | 2022-12-18 | China | Shanghai | 65126 | 595 | 0 | 31.202 | 121.4491 | 2022-12-19 04:21:03 | Shanghai, China | |||
504104 | 504104 | 2022-12-17 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-18 04:21:03 | Anchorage, Alaska, US | |
503492 | 503492 | 2022-12-17 | China | Shanghai | 65102 | 595 | 0 | 31.202 | 121.4491 | 2022-12-18 04:21:03 | Shanghai, China | |||
3324676 | 3324676 | 2022-12-16 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-17 04:21:04 | Anchorage, Alaska, US | |
3324064 | 3324064 | 2022-12-16 | China | Shanghai | 64978 | 595 | 0 | 31.202 | 121.4491 | 2022-12-17 04:21:04 | Shanghai, China | |||
543188 | 543188 | 2022-12-15 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-16 04:21:01 | Anchorage, Alaska, US | |
542576 | 542576 | 2022-12-15 | China | Shanghai | 64978 | 595 | 0 | 31.202 | 121.4491 | 2022-12-16 04:21:01 | Shanghai, China | |||
348716 | 348716 | 2022-12-14 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-15 04:20:58 | Anchorage, Alaska, US | |
348304 | 348304 | 2022-12-14 | Japan | Miyagi | 410113 | 595 | 0 | 38.446859 | 140.927086 | 2022-12-15 04:20:58 | Miyagi, Japan | |||
348104 | 348104 | 2022-12-14 | China | Shanghai | 64978 | 595 | 0 | 31.202 | 121.4491 | 2022-12-15 04:20:58 | Shanghai, China | |||
308304 | 308304 | 2022-12-13 | US | Alaska | Anchorage | 2020 | 121951 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-14 04:21:04 | Anchorage, Alaska, US | |
307692 | 307692 | 2022-12-13 | China | Shanghai | 64978 | 595 | 0 | 31.202 | 121.4491 | 2022-12-14 04:21:04 | Shanghai, China | |||
1149365 | 1149365 | 2022-12-12 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-13 04:21:01 | Anchorage, Alaska, US | |
1148753 | 1148753 | 2022-12-12 | China | Shanghai | 64958 | 595 | 0 | 31.202 | 121.4491 | 2022-12-13 04:21:01 | Shanghai, China | |||
869219 | 869219 | 2022-12-11 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-12 04:21:01 | Anchorage, Alaska, US | |
868607 | 868607 | 2022-12-11 | China | Shanghai | 64936 | 595 | 0 | 31.202 | 121.4491 | 2022-12-12 04:21:01 | Shanghai, China | |||
257749 | 257749 | 2022-12-10 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-11 04:20:50 | Anchorage, Alaska, US | |
257137 | 257137 | 2022-12-10 | China | Shanghai | 64918 | 595 | 0 | 31.202 | 121.4491 | 2022-12-11 04:20:50 | Shanghai, China | |||
3936463 | 3936463 | 2022-12-09 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-10 04:21:02 | Anchorage, Alaska, US | |
3935851 | 3935851 | 2022-12-09 | China | Shanghai | 64910 | 595 | 0 | 31.202 | 121.4491 | 2022-12-10 04:21:02 | Shanghai, China | |||
3377795 | 3377795 | 2022-12-08 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-09 04:21:05 | Anchorage, Alaska, US | |
3377183 | 3377183 | 2022-12-08 | China | Shanghai | 64894 | 595 | 0 | 31.202 | 121.4491 | 2022-12-09 04:21:05 | Shanghai, China | |||
1985066 | 1985066 | 2022-12-07 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-08 04:21:07 | Anchorage, Alaska, US | |
1984454 | 1984454 | 2022-12-07 | China | Shanghai | 64861 | 595 | 0 | 31.202 | 121.4491 | 2022-12-08 04:21:07 | Shanghai, China | |||
3714589 | 3714589 | 2022-12-06 | US | Alaska | Anchorage | 2020 | 121807 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-07 04:20:58 | Anchorage, Alaska, US | |
3713977 | 3713977 | 2022-12-06 | China | Shanghai | 64813 | 595 | 0 | 31.202 | 121.4491 | 2022-12-07 04:20:58 | Shanghai, China | |||
2415294 | 2415294 | 2022-12-05 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-06 04:21:03 | Anchorage, Alaska, US | |
2414682 | 2414682 | 2022-12-05 | China | Shanghai | 64780 | 595 | 0 | 31.202 | 121.4491 | 2022-12-06 04:21:03 | Shanghai, China | |||
718902 | 718902 | 2022-12-04 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-05 04:20:58 | Anchorage, Alaska, US | |
718290 | 718290 | 2022-12-04 | China | Shanghai | 64731 | 595 | 0 | 31.202 | 121.4491 | 2022-12-05 04:20:58 | Shanghai, China | |||
2817191 | 2817191 | 2022-12-03 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-04 04:20:56 | Anchorage, Alaska, US | |
2816579 | 2816579 | 2022-12-03 | China | Shanghai | 64685 | 595 | 0 | 31.202 | 121.4491 | 2022-12-04 04:20:56 | Shanghai, China | |||
834047 | 834047 | 2022-12-02 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-03 04:21:02 | Anchorage, Alaska, US | |
833435 | 833435 | 2022-12-02 | China | Shanghai | 64643 | 595 | 0 | 31.202 | 121.4491 | 2022-12-03 04:21:02 | Shanghai, China | |||
2136577 | 2136577 | 2022-12-01 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-02 04:21:07 | Anchorage, Alaska, US | |
2135965 | 2135965 | 2022-12-01 | China | Shanghai | 64611 | 595 | 0 | 31.202 | 121.4491 | 2022-12-02 04:21:07 | Shanghai, China | |||
1964993 | 1964993 | 2022-11-30 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-12-01 04:21:03 | Anchorage, Alaska, US | |
1964381 | 1964381 | 2022-11-30 | China | Shanghai | 64581 | 595 | 0 | 31.202 | 121.4491 | 2022-12-01 04:21:03 | Shanghai, China | |||
2557007 | 2557007 | 2022-11-29 | US | Alaska | Anchorage | 2020 | 121626 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-30 04:21:07 | Anchorage, Alaska, US | |
2556395 | 2556395 | 2022-11-29 | China | Shanghai | 64552 | 595 | 0 | 31.202 | 121.4491 | 2022-11-30 04:21:07 | Shanghai, China | |||
1240081 | 1240081 | 2022-11-28 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-29 04:21:05 | Anchorage, Alaska, US | |
1239469 | 1239469 | 2022-11-28 | China | Shanghai | 64532 | 595 | 0 | 31.202 | 121.4491 | 2022-11-29 04:21:05 | Shanghai, China | |||
3552069 | 3552069 | 2022-11-27 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-28 04:21:02 | Anchorage, Alaska, US | |
3551457 | 3551457 | 2022-11-27 | China | Shanghai | 64506 | 595 | 0 | 31.202 | 121.4491 | 2022-11-28 04:21:02 | Shanghai, China | |||
2100549 | 2100549 | 2022-11-26 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-27 04:21:05 | Anchorage, Alaska, US | |
2099937 | 2099937 | 2022-11-26 | China | Shanghai | 64486 | 595 | 0 | 31.202 | 121.4491 | 2022-11-27 04:21:05 | Shanghai, China | |||
488040 | 488040 | 2022-11-25 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-26 04:21:11 | Anchorage, Alaska, US | |
487428 | 487428 | 2022-11-25 | China | Shanghai | 64467 | 595 | 0 | 31.202 | 121.4491 | 2022-11-26 04:21:11 | Shanghai, China | |||
3523869 | 3523869 | 2022-11-24 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-25 04:21:06 | Anchorage, Alaska, US | |
3523257 | 3523257 | 2022-11-24 | China | Shanghai | 64453 | 595 | 0 | 31.202 | 121.4491 | 2022-11-25 04:21:06 | Shanghai, China | |||
3312652 | 3312652 | 2022-11-23 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-24 04:21:09 | Anchorage, Alaska, US | |
3312040 | 3312040 | 2022-11-23 | China | Shanghai | 64435 | 595 | 0 | 31.202 | 121.4491 | 2022-11-24 04:21:09 | Shanghai, China | |||
1621406 | 1621406 | 2022-11-22 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-23 04:21:06 | Porter, Indiana, US | |
1620693 | 1620693 | 2022-11-22 | US | Alaska | Anchorage | 2020 | 121471 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-23 04:21:06 | Anchorage, Alaska, US | |
1620081 | 1620081 | 2022-11-22 | China | Shanghai | 64422 | 595 | 0 | 31.202 | 121.4491 | 2022-11-23 04:21:06 | Shanghai, China | |||
3461294 | 3461294 | 2022-11-21 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-22 04:20:47 | Porter, Indiana, US | |
3460581 | 3460581 | 2022-11-21 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-22 04:20:47 | Anchorage, Alaska, US | |
3459969 | 3459969 | 2022-11-21 | China | Shanghai | 64402 | 595 | 0 | 31.202 | 121.4491 | 2022-11-22 04:20:47 | Shanghai, China | |||
1641479 | 1641479 | 2022-11-20 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-21 04:21:05 | Porter, Indiana, US | |
1640766 | 1640766 | 2022-11-20 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-21 04:21:05 | Anchorage, Alaska, US | |
1640154 | 1640154 | 2022-11-20 | China | Shanghai | 64393 | 595 | 0 | 31.202 | 121.4491 | 2022-11-21 04:21:05 | Shanghai, China | |||
2065036 | 2065036 | 2022-11-19 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-20 04:21:08 | Porter, Indiana, US | |
2064323 | 2064323 | 2022-11-19 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-20 04:21:08 | Anchorage, Alaska, US | |
2063711 | 2063711 | 2022-11-19 | China | Shanghai | 64382 | 595 | 0 | 31.202 | 121.4491 | 2022-11-20 04:21:08 | Shanghai, China | |||
1756430 | 1756430 | 2022-11-18 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-19 04:21:14 | Porter, Indiana, US | |
1755717 | 1755717 | 2022-11-18 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-19 04:21:14 | Anchorage, Alaska, US | |
1755105 | 1755105 | 2022-11-18 | China | Shanghai | 64373 | 595 | 0 | 31.202 | 121.4491 | 2022-11-19 04:21:14 | Shanghai, China | |||
3027423 | 3027423 | 2022-11-17 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-18 04:21:15 | Porter, Indiana, US | |
3026710 | 3026710 | 2022-11-17 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-18 04:21:15 | Anchorage, Alaska, US | |
3026098 | 3026098 | 2022-11-17 | China | Shanghai | 64360 | 595 | 0 | 31.202 | 121.4491 | 2022-11-18 04:21:15 | Shanghai, China | |||
2487134 | 2487134 | 2022-11-16 | US | Indiana | Porter | 18127 | 45233 | 595 | 0 | 41.45986947 | -87.06848888 | 2022-11-17 04:21:11 | Porter, Indiana, US | |
2486421 | 2486421 | 2022-11-16 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-17 04:21:11 | Anchorage, Alaska, US | |
2485809 | 2485809 | 2022-11-16 | China | Shanghai | 64353 | 595 | 0 | 31.202 | 121.4491 | 2022-11-17 04:21:11 | Shanghai, China | |||
292432 | 292432 | 2022-11-15 | US | Alaska | Anchorage | 2020 | 121344 | 595 | 0 | 61.14998174 | -149.1426986 | 2022-11-16 04:21:09 | Anchorage, Alaska, US | |
291820 | 291820 | 2022-11-15 | China | Shanghai | 64345 | 595 | 0 | 31.202 | 121.4491 | 2022-11-16 04:21:09 | Shanghai, China | |||
3596850 | 3596850 | 2022-11-14 | China | Shanghai | 64341 | 595 | 0 | 31.202 | 121.4491 | 2022-11-15 04:21:16 | Shanghai, China | |||
311708 | 311708 | 2022-11-13 | China | Shanghai | 64339 | 595 | 0 | 31.202 | 121.4491 | 2022-11-14 04:21:09 | Shanghai, China | |||
62869 | 62869 | 2022-11-12 | China | Shanghai | 64334 | 595 | 0 | 31.202 | 121.4491 | 2022-11-13 04:21:14 | Shanghai, China | |||
2927031 | 2927031 | 2022-11-11 | China | Shanghai | 64331 | 595 | 0 | 31.202 | 121.4491 | 2022-11-12 04:20:41 | Shanghai, China | |||
2505867 | 2505867 | 2022-11-10 | China | Shanghai | 64328 | 595 | 0 | 31.202 | 121.4491 | 2022-11-11 04:21:22 | Shanghai, China | |||
2430742 | 2430742 | 2022-11-09 | China | Shanghai | 64326 | 595 | 0 | 31.202 | 121.4491 | 2022-11-10 04:21:16 | Shanghai, China | |||
479398 | 479398 | 2022-11-08 | China | Shanghai | 64323 | 595 | 0 | 31.202 | 121.4491 | 2022-11-09 04:21:22 | Shanghai, China | |||
2438548 | 2438548 | 2022-11-07 | China | Shanghai | 64320 | 595 | 0 | 31.202 | 121.4491 | 2022-11-08 04:21:21 | Shanghai, China | |||
1049646 | 1049646 | 2022-11-06 | China | Shanghai | 64317 | 595 | 0 | 31.202 | 121.4491 | 2022-11-07 04:21:26 | Shanghai, China | |||
617670 | 617670 | 2022-11-05 | China | Shanghai | 64315 | 595 | 0 | 31.202 | 121.4491 | 2022-11-06 04:21:24 | Shanghai, China | |||
1022174 | 1022174 | 2022-11-04 | China | Shanghai | 64312 | 595 | 0 | 31.202 | 121.4491 | 2022-11-05 04:21:52 | Shanghai, China | |||
431165 | 431165 | 2022-11-03 | China | Shanghai | 64306 | 595 | 0 | 31.202 | 121.4491 | 2022-11-04 04:22:11 | Shanghai, China |
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]);