daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
335 rows where deaths = 800 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 206
- Tanzania 34
- Russia 18
- Japan 10
- Colombia 6
- France 6
- Mexico 6
- Spain 5
- Peru 4
- Ukraine 4
- Brazil 3
- India 3
- Italy 3
- Luxembourg 3
- Bahamas 2
- Chile 2
- Cote d'Ivoire 2
- Germany 2
- Malaysia 2
- Angola 1
- Australia 1
- Canada 1
- Finland 1
- Indonesia 1
- Madagascar 1
- Moldova 1
- Montenegro 1
- Mozambique 1
- North Macedonia 1
- Poland 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Pennsylvania | Cambria | 42021 | 42109 | 800 | 0 | 40.49527404 | -78.71377428 | 2022-12-30 04:21:04 | Cambria, Pennsylvania, US | |
2022-12-28 | US | Pennsylvania | Cambria | 42021 | 42109 | 800 | 0 | 40.49527404 | -78.71377428 | 2022-12-29 04:21:01 | Cambria, Pennsylvania, US | |
2022-12-04 | US | Virginia | Prince William | 51153 | 120046 | 800 | 0 | 38.70916224 | -77.48713689 | 2022-12-05 04:20:58 | Prince William, Virginia, US | |
2022-12-03 | US | Virginia | Prince William | 51153 | 120046 | 800 | 0 | 38.70916224 | -77.48713689 | 2022-12-04 04:20:56 | Prince William, Virginia, US | |
2022-12-03 | Japan | Ibaraki | 445936 | 800 | 0 | 36.303588 | 140.319591 | 2022-12-04 04:20:56 | Ibaraki, Japan | |||
2022-12-02 | US | Virginia | Prince William | 51153 | 120046 | 800 | 0 | 38.70916224 | -77.48713689 | 2022-12-03 04:21:02 | Prince William, Virginia, US | |
2022-11-26 | Japan | Shizuoka | 566348 | 800 | 0 | 34.916975 | 138.407784 | 2022-11-27 04:21:05 | Shizuoka, Japan | |||
2022-11-12 | Japan | Hiroshima | 486424 | 800 | 0 | 34.605309 | 132.788719 | 2022-11-13 04:21:14 | Hiroshima, Japan | |||
2022-10-05 | US | West Virginia | Kanawha | 54039 | 55931 | 800 | 0 | 38.33860077 | -81.52857054 | 2022-10-06 04:21:22 | Kanawha, West Virginia, US | |
2022-10-04 | US | West Virginia | Kanawha | 54039 | 55912 | 800 | 0 | 38.33860077 | -81.52857054 | 2022-10-05 04:23:06 | Kanawha, West Virginia, US | |
2022-10-03 | US | Louisiana | Ouachita | 22073 | 59397 | 800 | 0 | 32.47645559 | -92.15704172 | 2022-10-04 04:22:55 | Ouachita, Louisiana, US | |
2022-10-02 | US | Louisiana | Ouachita | 22073 | 59351 | 800 | 0 | 32.47645559 | -92.15704172 | 2022-10-03 04:23:11 | Ouachita, Louisiana, US | |
2022-10-01 | US | Louisiana | Ouachita | 22073 | 59351 | 800 | 0 | 32.47645559 | -92.15704172 | 2022-10-02 04:21:23 | Ouachita, Louisiana, US | |
2022-09-30 | US | Louisiana | Ouachita | 22073 | 59351 | 800 | 0 | 32.47645559 | -92.15704172 | 2022-10-01 04:23:01 | Ouachita, Louisiana, US | |
2022-09-29 | US | Louisiana | Ouachita | 22073 | 59327 | 800 | 0 | 32.47645559 | -92.15704172 | 2022-09-30 04:23:09 | Ouachita, Louisiana, US | |
2022-08-18 | US | California | San Mateo | 6081 | 174099 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-19 04:20:54 | San Mateo, California, US | |
2022-08-17 | US | California | San Mateo | 6081 | 173605 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-18 04:21:11 | San Mateo, California, US | |
2022-08-16 | US | California | San Mateo | 6081 | 173591 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-17 04:20:59 | San Mateo, California, US | |
2022-08-15 | US | California | San Mateo | 6081 | 173585 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-16 04:20:58 | San Mateo, California, US | |
2022-08-14 | US | California | San Mateo | 6081 | 172884 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-15 04:20:59 | San Mateo, California, US | |
2022-08-13 | US | California | San Mateo | 6081 | 172872 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-14 04:20:55 | San Mateo, California, US | |
2022-08-12 | US | California | San Mateo | 6081 | 172867 | 800 | 0 | 37.4228808 | -122.3275546 | 2022-08-13 04:20:52 | San Mateo, California, US | |
2022-08-10 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-11 04:20:49 | Tuscaloosa, Alabama, US | |
2022-08-09 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-10 04:20:57 | Tuscaloosa, Alabama, US | |
2022-08-08 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-09 04:20:34 | Tuscaloosa, Alabama, US | |
2022-08-07 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-08 04:21:08 | Tuscaloosa, Alabama, US | |
2022-08-06 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-07 04:20:54 | Tuscaloosa, Alabama, US | |
2022-08-05 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-06 04:20:56 | Tuscaloosa, Alabama, US | |
2022-08-04 | US | Alabama | Tuscaloosa | 1125 | 62124 | 800 | 0 | 33.28726072 | -87.52556818 | 2022-08-05 04:20:52 | Tuscaloosa, Alabama, US | |
2022-07-28 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-29 04:20:45 | St. Louis City, Missouri, US | |
2022-07-27 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-28 04:20:56 | St. Louis City, Missouri, US | |
2022-07-26 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-27 04:21:04 | St. Louis City, Missouri, US | |
2022-07-25 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-26 04:20:58 | St. Louis City, Missouri, US | |
2022-07-24 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-25 04:20:51 | St. Louis City, Missouri, US | |
2022-07-23 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-24 04:20:47 | St. Louis City, Missouri, US | |
2022-07-22 | US | Missouri | St. Louis City | 29510 | 65676 | 800 | 0 | 38.63555736 | -90.24349225 | 2022-07-23 04:20:53 | St. Louis City, Missouri, US | |
2022-06-22 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-23 04:20:55 | Utah, Utah, US | |
2022-06-21 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-22 04:20:54 | Utah, Utah, US | |
2022-06-20 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-21 04:20:56 | Utah, Utah, US | |
2022-06-19 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-20 04:21:01 | Utah, Utah, US | |
2022-06-18 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-19 04:20:51 | Utah, Utah, US | |
2022-06-17 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-18 04:21:10 | Utah, Utah, US | |
2022-06-16 | US | Utah | Utah | 49049 | 207659 | 800 | 0 | 40.1166722 | -111.6657662 | 2022-06-17 04:20:56 | Utah, Utah, US | |
2022-06-16 | Cote d'Ivoire | 82614 | 800 | 0 | 7.54 | -5.5471 | 2022-06-17 04:20:56 | Cote d'Ivoire | ||||
2022-06-15 | Cote d'Ivoire | 82580 | 800 | 0 | 7.54 | -5.5471 | 2022-06-16 04:20:55 | Cote d'Ivoire | ||||
2022-06-05 | US | New Mexico | Dona Ana | 35013 | 64588 | 800 | 0 | 32.35275771 | -106.8329387 | 2022-06-06 04:20:57 | Dona Ana, New Mexico, US | |
2022-06-04 | US | New Mexico | Dona Ana | 35013 | 64588 | 800 | 0 | 32.35275771 | -106.8329387 | 2022-06-05 04:20:55 | Dona Ana, New Mexico, US | |
2022-06-03 | US | New Mexico | Dona Ana | 35013 | 64588 | 800 | 0 | 32.35275771 | -106.8329387 | 2022-06-04 04:20:58 | Dona Ana, New Mexico, US | |
2022-06-02 | US | New Mexico | Dona Ana | 35013 | 64588 | 800 | 0 | 32.35275771 | -106.8329387 | 2022-06-03 04:20:58 | Dona Ana, New Mexico, US | |
2022-05-13 | Bahamas | 33830 | 800 | 0 | 25.025885 | -78.035889 | 2022-05-14 04:20:48 | Bahamas | ||||
2022-05-12 | Bahamas | 33830 | 800 | 0 | 25.025885 | -78.035889 | 2022-05-13 04:20:51 | Bahamas | ||||
2022-05-10 | US | Washington | Clark | 53011 | 90793 | 800 | 0 | 45.77568046 | -122.4829204 | 2022-05-11 04:20:48 | Clark, Washington, US | |
2022-05-09 | US | Washington | Clark | 53011 | 90793 | 800 | 0 | 45.77568046 | -122.4829204 | 2022-05-10 04:20:50 | Clark, Washington, US | |
2022-05-09 | US | New York | Oneida | 36065 | 57872 | 800 | 0 | 43.24375382 | -75.43710392 | 2022-05-10 04:20:50 | Oneida, New York, US | |
2022-05-08 | US | New York | Oneida | 36065 | 57752 | 800 | 0 | 43.24375382 | -75.43710392 | 2022-05-09 04:20:54 | Oneida, New York, US | |
2022-04-26 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-27 04:20:52 | Gaston, North Carolina, US | |
2022-04-25 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-26 04:20:51 | Gaston, North Carolina, US | |
2022-04-24 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-25 04:20:56 | Gaston, North Carolina, US | |
2022-04-23 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-24 04:20:56 | Gaston, North Carolina, US | |
2022-04-22 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-23 04:20:50 | Gaston, North Carolina, US | |
2022-04-21 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-22 04:20:45 | Gaston, North Carolina, US | |
2022-04-20 | US | North Carolina | Gaston | 37071 | 65318 | 800 | 0 | 35.29373559 | -81.17477045 | 2022-04-21 04:20:46 | Gaston, North Carolina, US | |
2022-04-17 | US | Colorado | Pueblo | 8101 | 48669 | 800 | 0 | 38.17359144 | -104.5127437 | 2022-04-18 04:21:12 | Pueblo, Colorado, US | |
2022-04-16 | US | Colorado | Pueblo | 8101 | 48659 | 800 | 0 | 38.17359144 | -104.5127437 | 2022-04-17 04:20:59 | Pueblo, Colorado, US | |
2022-04-15 | US | Colorado | Pueblo | 8101 | 48651 | 800 | 0 | 38.17359144 | -104.5127437 | 2022-04-16 04:20:48 | Pueblo, Colorado, US | |
2022-04-14 | US | Colorado | Pueblo | 8101 | 48640 | 800 | 0 | 38.17359144 | -104.5127437 | 2022-04-15 04:20:57 | Pueblo, Colorado, US | |
2022-04-11 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-12 04:20:49 | Tanzania | ||||
2022-04-11 | Russia | Tomsk Oblast | 127965 | 800 | 0 | 58.6124279 | 82.04753149999998 | 2022-04-12 04:20:49 | Tomsk Oblast, Russia | |||
2022-04-10 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-11 04:21:02 | Tanzania | ||||
2022-04-10 | Russia | Tomsk Oblast | 127825 | 800 | 0 | 58.6124279 | 82.04753149999998 | 2022-04-11 04:21:02 | Tomsk Oblast, Russia | |||
2022-04-09 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-10 04:20:52 | Tanzania | ||||
2022-04-09 | Russia | Tomsk Oblast | 127684 | 800 | 0 | 58.6124279 | 82.04753149999998 | 2022-04-10 04:20:52 | Tomsk Oblast, Russia | |||
2022-04-08 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-09 04:20:42 | Tanzania | ||||
2022-04-08 | Russia | Tomsk Oblast | 127533 | 800 | 0 | 58.6124279 | 82.04753149999998 | 2022-04-09 04:20:42 | Tomsk Oblast, Russia | |||
2022-04-07 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-08 04:20:48 | Tanzania | ||||
2022-04-06 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-07 04:20:53 | Tanzania | ||||
2022-04-05 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-06 04:20:49 | Tanzania | ||||
2022-04-04 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-05 04:20:48 | Tanzania | ||||
2022-04-03 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-04 04:20:51 | Tanzania | ||||
2022-04-02 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-03 04:20:48 | Tanzania | ||||
2022-04-01 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-02 04:20:47 | Tanzania | ||||
2022-03-31 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-04-01 04:20:28 | Tanzania | ||||
2022-03-30 | Tanzania | 33815 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-31 04:20:56 | Tanzania | ||||
2022-03-29 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-30 04:20:45 | Tanzania | ||||
2022-03-28 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-29 04:20:46 | Tanzania | ||||
2022-03-27 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-28 04:20:33 | Tanzania | ||||
2022-03-26 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-27 04:20:47 | Tanzania | ||||
2022-03-25 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-26 04:20:23 | Tanzania | ||||
2022-03-24 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-25 04:20:46 | Tanzania | ||||
2022-03-23 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-24 04:20:43 | Tanzania | ||||
2022-03-22 | US | Virginia | Virginia Beach | 51810 | 88867 | 800 | 0 | 36.73285734 | -76.04566934 | 2022-03-23 04:20:48 | Virginia Beach, Virginia, US | |
2022-03-22 | Tanzania | 33797 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-23 04:20:48 | Tanzania | ||||
2022-03-21 | US | Virginia | Virginia Beach | 51810 | 88867 | 800 | 0 | 36.73285734 | -76.04566934 | 2022-03-22 04:20:54 | Virginia Beach, Virginia, US | |
2022-03-21 | Tanzania | 33773 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-22 04:20:54 | Tanzania | ||||
2022-03-20 | US | Virginia | Virginia Beach | 51810 | 88835 | 800 | 0 | 36.73285734 | -76.04566934 | 2022-03-21 04:20:50 | Virginia Beach, Virginia, US | |
2022-03-20 | US | California | Merced | 6047 | 70699 | 800 | 0 | 37.18922369 | -120.72090349999999 | 2022-03-21 04:20:50 | Merced, California, US | |
2022-03-20 | Tanzania | 33773 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-21 04:20:50 | Tanzania | ||||
2022-03-19 | US | Virginia | Virginia Beach | 51810 | 88835 | 800 | 0 | 36.73285734 | -76.04566934 | 2022-03-20 04:20:45 | Virginia Beach, Virginia, US | |
2022-03-19 | US | California | Merced | 6047 | 70641 | 800 | 0 | 37.18922369 | -120.72090349999999 | 2022-03-20 04:20:45 | Merced, California, US | |
2022-03-19 | Tanzania | 33773 | 800 | 0 | -6.369028 | 34.888822 | 2022-03-20 04:20:45 | Tanzania |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;