daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,675 rows where deaths = 144 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 4,291
- Russia 58
- Japan 54
- Antigua and Barbuda 39
- France 20
- Spain 20
- United Kingdom 16
- India 15
- Italy 14
- Comoros 11
- Sweden 11
- Colombia 10
- Congo (Brazzaville) 8
- Nicaragua 7
- Peru 7
- Burkina Faso 6
- Chile 6
- Malaysia 6
- Ukraine 6
- Andorra 5
- Liberia 5
- Netherlands 5
- Solomon Islands 5
- Mexico 4
- Pakistan 4
- Cabo Verde 3
- Canada 3
- Gambia 3
- Guinea 3
- Bahamas 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Oklahoma | Seminole | 40133 | 7461 | 144 | 0 | 35.16478725 | -96.61686741 | 2022-12-30 04:21:04 | Seminole, Oklahoma, US | |
2022-12-29 | US | Oklahoma | Bryan | 40013 | 16663 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-30 04:21:04 | Bryan, Oklahoma, US | |
2022-12-29 | US | Ohio | Madison | 39097 | 11360 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-30 04:21:04 | Madison, Ohio, US | |
2022-12-29 | US | Louisiana | Morehouse | 22067 | 8346 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-30 04:21:04 | Morehouse, Louisiana, US | |
2022-12-29 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-30 04:21:04 | Ripley, Indiana, US | |
2022-12-29 | US | Georgia | Crisp | 13081 | 5466 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-30 04:21:04 | Crisp, Georgia, US | |
2022-12-29 | Japan | Fukui | 169375 | 144 | 0 | 35.846614 | 136.224654 | 2022-12-30 04:21:04 | Fukui, Japan | |||
2022-12-28 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-29 04:21:01 | Bryan, Oklahoma, US | |
2022-12-28 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-29 04:21:01 | Madison, Ohio, US | |
2022-12-28 | US | Louisiana | Morehouse | 22067 | 8346 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-29 04:21:01 | Morehouse, Louisiana, US | |
2022-12-28 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-29 04:21:01 | Ripley, Indiana, US | |
2022-12-28 | US | Georgia | Crisp | 13081 | 5466 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-29 04:21:01 | Crisp, Georgia, US | |
2022-12-27 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-28 04:21:04 | Bryan, Oklahoma, US | |
2022-12-27 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-28 04:21:04 | Madison, Ohio, US | |
2022-12-27 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-28 04:21:04 | Morehouse, Louisiana, US | |
2022-12-27 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-28 04:21:04 | Ripley, Indiana, US | |
2022-12-27 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-28 04:21:04 | Crisp, Georgia, US | |
2022-12-26 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-27 04:21:07 | Bryan, Oklahoma, US | |
2022-12-26 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-27 04:21:07 | Madison, Ohio, US | |
2022-12-26 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-27 04:21:07 | Morehouse, Louisiana, US | |
2022-12-26 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-27 04:21:07 | Ripley, Indiana, US | |
2022-12-26 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-27 04:21:07 | Crisp, Georgia, US | |
2022-12-25 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-26 04:21:06 | Bryan, Oklahoma, US | |
2022-12-25 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-26 04:21:06 | Madison, Ohio, US | |
2022-12-25 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-26 04:21:06 | Morehouse, Louisiana, US | |
2022-12-25 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-26 04:21:06 | Ripley, Indiana, US | |
2022-12-25 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-26 04:21:06 | Crisp, Georgia, US | |
2022-12-24 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-25 04:21:04 | Bryan, Oklahoma, US | |
2022-12-24 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-25 04:21:04 | Madison, Ohio, US | |
2022-12-24 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-25 04:21:04 | Morehouse, Louisiana, US | |
2022-12-24 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-25 04:21:04 | Ripley, Indiana, US | |
2022-12-24 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-25 04:21:04 | Crisp, Georgia, US | |
2022-12-23 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-24 04:21:02 | Bryan, Oklahoma, US | |
2022-12-23 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-24 04:21:02 | Madison, Ohio, US | |
2022-12-23 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-24 04:21:02 | Morehouse, Louisiana, US | |
2022-12-23 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-24 04:21:02 | Ripley, Indiana, US | |
2022-12-23 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-24 04:21:02 | Crisp, Georgia, US | |
2022-12-22 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-23 04:21:04 | Jersey, United Kingdom | |||
2022-12-22 | US | Oklahoma | Bryan | 40013 | 16541 | 144 | 0 | 33.96472458 | -96.25903472 | 2022-12-23 04:21:04 | Bryan, Oklahoma, US | |
2022-12-22 | US | Ohio | Madison | 39097 | 11321 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-23 04:21:04 | Madison, Ohio, US | |
2022-12-22 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-23 04:21:04 | Morehouse, Louisiana, US | |
2022-12-22 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-23 04:21:04 | Ripley, Indiana, US | |
2022-12-22 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-23 04:21:04 | Crisp, Georgia, US | |
2022-12-21 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-22 04:20:56 | Jersey, United Kingdom | |||
2022-12-21 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-22 04:20:56 | Madison, Ohio, US | |
2022-12-21 | US | New York | Sullivan | 36105 | 23660 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-22 04:20:56 | Sullivan, New York, US | |
2022-12-21 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-22 04:20:56 | Morehouse, Louisiana, US | |
2022-12-21 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-22 04:20:56 | Ripley, Indiana, US | |
2022-12-21 | US | Georgia | Crisp | 13081 | 5447 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-22 04:20:56 | Crisp, Georgia, US | |
2022-12-20 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-21 04:21:03 | Jersey, United Kingdom | |||
2022-12-20 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-21 04:21:03 | Madison, Ohio, US | |
2022-12-20 | US | New York | Sullivan | 36105 | 23628 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-21 04:21:03 | Sullivan, New York, US | |
2022-12-20 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-21 04:21:03 | Morehouse, Louisiana, US | |
2022-12-20 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-21 04:21:03 | Ripley, Indiana, US | |
2022-12-20 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-21 04:21:03 | Crisp, Georgia, US | |
2022-12-19 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-20 04:21:04 | Jersey, United Kingdom | |||
2022-12-19 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-20 04:21:04 | Madison, Ohio, US | |
2022-12-19 | US | New York | Sullivan | 36105 | 23616 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-20 04:21:04 | Sullivan, New York, US | |
2022-12-19 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-20 04:21:04 | Morehouse, Louisiana, US | |
2022-12-19 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-20 04:21:04 | Ripley, Indiana, US | |
2022-12-19 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-20 04:21:04 | Crisp, Georgia, US | |
2022-12-18 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-19 04:21:03 | Jersey, United Kingdom | |||
2022-12-18 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-19 04:21:03 | Madison, Ohio, US | |
2022-12-18 | US | New York | Sullivan | 36105 | 23610 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-19 04:21:03 | Sullivan, New York, US | |
2022-12-18 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-19 04:21:03 | Morehouse, Louisiana, US | |
2022-12-18 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-19 04:21:03 | Ripley, Indiana, US | |
2022-12-18 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-19 04:21:03 | Crisp, Georgia, US | |
2022-12-17 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-18 04:21:03 | Jersey, United Kingdom | |||
2022-12-17 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-18 04:21:03 | Madison, Ohio, US | |
2022-12-17 | US | New York | Sullivan | 36105 | 23598 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-18 04:21:03 | Sullivan, New York, US | |
2022-12-17 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-18 04:21:03 | Morehouse, Louisiana, US | |
2022-12-17 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-18 04:21:03 | Ripley, Indiana, US | |
2022-12-17 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-18 04:21:03 | Crisp, Georgia, US | |
2022-12-17 | Japan | Shimane | 120371 | 144 | 0 | 35.07076 | 132.554064 | 2022-12-18 04:21:03 | Shimane, Japan | |||
2022-12-16 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-17 04:21:04 | Jersey, United Kingdom | |||
2022-12-16 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-17 04:21:04 | Madison, Ohio, US | |
2022-12-16 | US | New York | Sullivan | 36105 | 23585 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-17 04:21:04 | Sullivan, New York, US | |
2022-12-16 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-17 04:21:04 | Morehouse, Louisiana, US | |
2022-12-16 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-17 04:21:04 | Ripley, Indiana, US | |
2022-12-16 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-17 04:21:04 | Crisp, Georgia, US | |
2022-12-15 | US | Ohio | Madison | 39097 | 11266 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-16 04:21:01 | Madison, Ohio, US | |
2022-12-15 | US | New York | Sullivan | 36105 | 23566 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-16 04:21:01 | Sullivan, New York, US | |
2022-12-15 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-16 04:21:01 | Morehouse, Louisiana, US | |
2022-12-15 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-16 04:21:01 | Ripley, Indiana, US | |
2022-12-15 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-16 04:21:01 | Crisp, Georgia, US | |
2022-12-14 | US | Ohio | Madison | 39097 | 11212 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-15 04:20:58 | Madison, Ohio, US | |
2022-12-14 | US | New York | Sullivan | 36105 | 23547 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-15 04:20:58 | Sullivan, New York, US | |
2022-12-14 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-15 04:20:58 | Morehouse, Louisiana, US | |
2022-12-14 | US | Indiana | Ripley | 18137 | 9746 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-15 04:20:58 | Ripley, Indiana, US | |
2022-12-14 | US | Georgia | Crisp | 13081 | 5440 | 144 | 0 | 31.92289565 | -83.76811843 | 2022-12-15 04:20:58 | Crisp, Georgia, US | |
2022-12-13 | US | Ohio | Madison | 39097 | 11212 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-14 04:21:04 | Madison, Ohio, US | |
2022-12-13 | US | New York | Sullivan | 36105 | 23533 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-14 04:21:04 | Sullivan, New York, US | |
2022-12-13 | US | Indiana | Ripley | 18137 | 9701 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-14 04:21:04 | Ripley, Indiana, US | |
2022-12-12 | US | Ohio | Madison | 39097 | 11212 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-13 04:21:01 | Madison, Ohio, US | |
2022-12-12 | US | New York | Sullivan | 36105 | 23516 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-13 04:21:01 | Sullivan, New York, US | |
2022-12-12 | US | Indiana | Ripley | 18137 | 9701 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-13 04:21:01 | Ripley, Indiana, US | |
2022-12-11 | US | Ohio | Madison | 39097 | 11212 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-12 04:21:01 | Madison, Ohio, US | |
2022-12-11 | US | New York | Sullivan | 36105 | 23508 | 144 | 0 | 41.71579493 | -74.76394559 | 2022-12-12 04:21:01 | Sullivan, New York, US | |
2022-12-11 | US | Indiana | Ripley | 18137 | 9701 | 144 | 0 | 39.10235626 | -85.26212744 | 2022-12-12 04:21:01 | Ripley, Indiana, US | |
2022-12-10 | US | Ohio | Madison | 39097 | 11212 | 144 | 0 | 39.89381073 | -83.40178317 | 2022-12-11 04:20:50 | Madison, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;