daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
427 rows where deaths = 643 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 305
- Russia 15
- Colombia 10
- Ukraine 10
- Sweden 9
- France 8
- India 8
- Papua New Guinea 8
- Bahamas 7
- Chile 4
- Japan 4
- Namibia 4
- Australia 3
- Brazil 3
- Italy 3
- Laos 3
- Malaysia 3
- Mexico 2
- Peru 2
- Afghanistan 1
- Denmark 1
- Germany 1
- Haiti 1
- Lebanon 1
- Luxembourg 1
- Madagascar 1
- Malawi 1
- Netherlands 1
- South Africa 1
- Spain 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-20 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-21 04:21:03 | Linn, Iowa, US | |
2022-12-19 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-20 04:21:04 | Linn, Iowa, US | |
2022-12-18 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-19 04:21:03 | Linn, Iowa, US | |
2022-12-17 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-18 04:21:03 | Linn, Iowa, US | |
2022-12-16 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-17 04:21:04 | Linn, Iowa, US | |
2022-12-15 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-16 04:21:01 | Linn, Iowa, US | |
2022-12-14 | US | Iowa | Linn | 19113 | 62848 | 643 | 0 | 42.07923082 | -91.59809485 | 2022-12-15 04:20:58 | Linn, Iowa, US | |
2022-11-28 | US | Maryland | Harford | 24025 | 47161 | 643 | 0 | 39.55010644 | -76.3077594 | 2022-11-29 04:21:05 | Harford, Maryland, US | |
2022-11-08 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-09 04:21:22 | Berrien, Michigan, US | |
2022-11-08 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-09 04:21:22 | Bay, Michigan, US | |
2022-11-07 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-08 04:21:21 | Berrien, Michigan, US | |
2022-11-07 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-08 04:21:21 | Bay, Michigan, US | |
2022-11-06 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-07 04:21:26 | Berrien, Michigan, US | |
2022-11-06 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-07 04:21:26 | Bay, Michigan, US | |
2022-11-05 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-06 04:21:24 | Berrien, Michigan, US | |
2022-11-05 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-06 04:21:24 | Bay, Michigan, US | |
2022-11-04 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-05 04:21:52 | Berrien, Michigan, US | |
2022-11-04 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-05 04:21:52 | Bay, Michigan, US | |
2022-11-03 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-04 04:22:11 | Berrien, Michigan, US | |
2022-11-03 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-04 04:22:11 | Bay, Michigan, US | |
2022-11-02 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-03 04:22:05 | Berrien, Michigan, US | |
2022-11-02 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-03 04:22:05 | Bay, Michigan, US | |
2022-11-01 | US | Michigan | Berrien | 26021 | 39929 | 643 | 0 | 41.95447397 | -86.4131308 | 2022-11-02 04:22:09 | Berrien, Michigan, US | |
2022-11-01 | US | Michigan | Bay | 26017 | 30739 | 643 | 0 | 43.70639106 | -83.98731479 | 2022-11-02 04:22:09 | Bay, Michigan, US | |
2022-10-25 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-26 04:22:19 | Catawba, North Carolina, US | |
2022-10-24 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-25 04:21:53 | Catawba, North Carolina, US | |
2022-10-23 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-24 04:22:29 | Catawba, North Carolina, US | |
2022-10-22 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-23 04:22:46 | Catawba, North Carolina, US | |
2022-10-21 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-22 04:22:53 | Catawba, North Carolina, US | |
2022-10-20 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-21 04:22:23 | Catawba, North Carolina, US | |
2022-10-19 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-20 04:22:59 | Catawba, North Carolina, US | |
2022-10-19 | US | New Jersey | Cumberland | 34011 | 48019 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-20 04:22:59 | Cumberland, New Jersey, US | |
2022-10-18 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-19 04:22:26 | Catawba, North Carolina, US | |
2022-10-18 | US | New Jersey | Cumberland | 34011 | 47985 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-19 04:22:26 | Cumberland, New Jersey, US | |
2022-10-17 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-18 04:22:42 | Catawba, North Carolina, US | |
2022-10-17 | US | New Jersey | Cumberland | 34011 | 47957 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-18 04:22:42 | Cumberland, New Jersey, US | |
2022-10-16 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-17 04:20:31 | Catawba, North Carolina, US | |
2022-10-16 | US | New Jersey | Cumberland | 34011 | 47946 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-17 04:20:31 | Cumberland, New Jersey, US | |
2022-10-15 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-16 04:22:39 | Catawba, North Carolina, US | |
2022-10-15 | US | New Jersey | Cumberland | 34011 | 47925 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-16 04:22:39 | Cumberland, New Jersey, US | |
2022-10-14 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-15 04:22:00 | Catawba, North Carolina, US | |
2022-10-14 | US | New Jersey | Cumberland | 34011 | 47895 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-15 04:22:00 | Cumberland, New Jersey, US | |
2022-10-13 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-14 04:22:28 | Catawba, North Carolina, US | |
2022-10-13 | US | New Jersey | Cumberland | 34011 | 47877 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-14 04:22:28 | Cumberland, New Jersey, US | |
2022-10-12 | US | North Carolina | Catawba | 37035 | 56396 | 643 | 0 | 35.66211129 | -81.2132617 | 2022-10-13 04:22:39 | Catawba, North Carolina, US | |
2022-10-12 | US | New Jersey | Cumberland | 34011 | 47840 | 643 | 0 | 39.37199394 | -75.10712559 | 2022-10-13 04:22:39 | Cumberland, New Jersey, US | |
2022-10-12 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-13 04:22:39 | Johnson, Indiana, US | |
2022-10-11 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-12 04:22:51 | Johnson, Indiana, US | |
2022-10-10 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-11 04:23:05 | Johnson, Indiana, US | |
2022-10-09 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-10 04:22:32 | Johnson, Indiana, US | |
2022-10-08 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-09 04:21:16 | Johnson, Indiana, US | |
2022-10-07 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-08 04:22:56 | Johnson, Indiana, US | |
2022-10-06 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-07 04:23:08 | Johnson, Indiana, US | |
2022-10-05 | US | Indiana | Johnson | 18081 | 47981 | 643 | 0 | 39.48994426 | -86.10149107 | 2022-10-06 04:21:22 | Johnson, Indiana, US | |
2022-10-01 | Japan | Kumamoto | 330979 | 643 | 0 | 32.608154 | 130.745231 | 2022-10-02 04:21:23 | Kumamoto, Japan | |||
2022-09-30 | Japan | Kumamoto | 330532 | 643 | 0 | 32.608154 | 130.745231 | 2022-10-01 04:23:01 | Kumamoto, Japan | |||
2022-09-12 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-13 04:20:57 | Pickens, South Carolina, US | |
2022-09-11 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-12 04:20:58 | Pickens, South Carolina, US | |
2022-09-10 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-11 04:20:50 | Pickens, South Carolina, US | |
2022-09-09 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-10 04:21:10 | Pickens, South Carolina, US | |
2022-09-08 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-09 04:21:11 | Pickens, South Carolina, US | |
2022-09-07 | US | South Carolina | Pickens | 45077 | 50449 | 643 | 0 | 34.88807695 | -82.72791551 | 2022-09-08 04:21:02 | Pickens, South Carolina, US | |
2022-09-06 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-07 04:20:59 | Blair, Pennsylvania, US | |
2022-09-05 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-06 04:21:02 | Blair, Pennsylvania, US | |
2022-09-04 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-05 04:21:01 | Blair, Pennsylvania, US | |
2022-09-03 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-04 04:21:22 | Blair, Pennsylvania, US | |
2022-09-02 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-03 04:21:04 | Blair, Pennsylvania, US | |
2022-09-01 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-02 04:21:07 | Blair, Pennsylvania, US | |
2022-08-31 | US | Pennsylvania | Blair | 42013 | 32473 | 643 | 0 | 40.47961444 | -78.34917412 | 2022-09-01 04:21:03 | Blair, Pennsylvania, US | |
2022-08-04 | US | Indiana | Vanderburgh | 18163 | 62915 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-08-05 04:20:52 | Vanderburgh, Indiana, US | |
2022-08-03 | US | Indiana | Vanderburgh | 18163 | 62915 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-08-04 04:20:58 | Vanderburgh, Indiana, US | |
2022-08-03 | Chile | Atacama | 90816 | 643 | 0 | -27.5661 | -70.0503 | 2022-08-04 04:20:58 | Atacama, Chile | |||
2022-08-02 | US | Indiana | Vanderburgh | 18163 | 62782 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-08-03 04:20:59 | Vanderburgh, Indiana, US | |
2022-08-02 | Chile | Atacama | 90432 | 643 | 0 | -27.5661 | -70.0503 | 2022-08-03 04:20:59 | Atacama, Chile | |||
2022-08-01 | US | Indiana | Vanderburgh | 18163 | 62782 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-08-02 04:20:53 | Vanderburgh, Indiana, US | |
2022-08-01 | Chile | Atacama | 90215 | 643 | 0 | -27.5661 | -70.0503 | 2022-08-02 04:20:53 | Atacama, Chile | |||
2022-07-31 | US | Indiana | Vanderburgh | 18163 | 62597 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-08-01 04:21:03 | Vanderburgh, Indiana, US | |
2022-07-30 | US | Indiana | Vanderburgh | 18163 | 62597 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-31 04:21:02 | Vanderburgh, Indiana, US | |
2022-07-29 | US | Indiana | Vanderburgh | 18163 | 62597 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-30 04:20:42 | Vanderburgh, Indiana, US | |
2022-07-28 | US | Indiana | Vanderburgh | 18163 | 62359 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-29 04:20:45 | Vanderburgh, Indiana, US | |
2022-07-27 | US | Indiana | Vanderburgh | 18163 | 62359 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-28 04:20:56 | Vanderburgh, Indiana, US | |
2022-07-26 | US | Arkansas | Washington | 5143 | 73058 | 643 | 0 | 35.976844 | -94.21800746 | 2022-07-27 04:21:04 | Washington, Arkansas, US | |
2022-07-25 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-26 04:20:58 | Florence, South Carolina, US | |
2022-07-25 | US | Arkansas | Washington | 5143 | 72920 | 643 | 0 | 35.976844 | -94.21800746 | 2022-07-26 04:20:58 | Washington, Arkansas, US | |
2022-07-24 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-25 04:20:51 | Florence, South Carolina, US | |
2022-07-24 | US | Arkansas | Washington | 5143 | 72864 | 643 | 0 | 35.976844 | -94.21800746 | 2022-07-25 04:20:51 | Washington, Arkansas, US | |
2022-07-23 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-24 04:20:47 | Florence, South Carolina, US | |
2022-07-23 | US | Arkansas | Washington | 5143 | 72864 | 643 | 0 | 35.976844 | -94.21800746 | 2022-07-24 04:20:47 | Washington, Arkansas, US | |
2022-07-22 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-23 04:20:53 | Florence, South Carolina, US | |
2022-07-21 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-22 04:21:15 | Florence, South Carolina, US | |
2022-07-20 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-21 04:21:10 | Florence, South Carolina, US | |
2022-07-20 | Italy | Molise | 78980 | 643 | 0 | 41.55774754 | 14.65916051 | 2022-07-21 04:21:10 | Molise, Italy | |||
2022-07-19 | US | South Carolina | Florence | 45041 | 44659 | 643 | 0 | 34.02361754 | -79.70189312 | 2022-07-20 04:20:59 | Florence, South Carolina, US | |
2022-07-19 | US | Indiana | Vanderburgh | 18163 | 61503 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-20 04:20:59 | Vanderburgh, Indiana, US | |
2022-07-19 | Italy | Molise | 78555 | 643 | 0 | 41.55774754 | 14.65916051 | 2022-07-20 04:20:59 | Molise, Italy | |||
2022-07-18 | US | Indiana | Vanderburgh | 18163 | 61387 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-19 04:20:58 | Vanderburgh, Indiana, US | |
2022-07-17 | US | Indiana | Vanderburgh | 18163 | 61151 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-18 04:20:59 | Vanderburgh, Indiana, US | |
2022-07-16 | US | Indiana | Vanderburgh | 18163 | 61151 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-17 04:21:15 | Vanderburgh, Indiana, US | |
2022-07-15 | US | Indiana | Vanderburgh | 18163 | 61151 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-16 04:21:05 | Vanderburgh, Indiana, US | |
2022-07-14 | US | Indiana | Vanderburgh | 18163 | 60926 | 643 | 0 | 38.02658833 | -87.58763124 | 2022-07-15 04:20:53 | Vanderburgh, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;