daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
317 rows where deaths = 771 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 174
- Russia 20
- Bahamas 18
- Spain 13
- Sweden 13
- Peru 11
- India 9
- Ukraine 6
- Japan 5
- Chile 4
- Colombia 4
- Ghana 4
- Malaysia 3
- Mexico 3
- Netherlands 3
- Australia 2
- Brazil 2
- Germany 2
- Pakistan 2
- Somalia 2
- Albania 1
- Austria 1
- Belarus 1
- Cote d'Ivoire 1
- Finland 1
- Honduras 1
- Italy 1
- Madagascar 1
- Moldova 1
- Mongolia 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Michigan | Kalamazoo | 26077 | 74189 | 771 | 0 | 42.24542231 | -85.53038622 | 2022-12-30 04:21:04 | Kalamazoo, Michigan, US | |
2022-12-28 | US | Michigan | Kalamazoo | 26077 | 74189 | 771 | 0 | 42.24542231 | -85.53038622 | 2022-12-29 04:21:01 | Kalamazoo, Michigan, US | |
2022-12-27 | US | Michigan | Kalamazoo | 26077 | 74189 | 771 | 0 | 42.24542231 | -85.53038622 | 2022-12-28 04:21:04 | Kalamazoo, Michigan, US | |
2022-12-14 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-15 04:20:58 | Jonkoping, Sweden | |||
2022-12-13 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-14 04:21:04 | Jonkoping, Sweden | |||
2022-12-12 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-13 04:21:01 | Jonkoping, Sweden | |||
2022-12-11 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-12 04:21:01 | Jonkoping, Sweden | |||
2022-12-10 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-11 04:20:50 | Jonkoping, Sweden | |||
2022-12-09 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-10 04:21:02 | Jonkoping, Sweden | |||
2022-12-08 | Sweden | Jonkoping | 90616 | 771 | 0 | 57.3708 | 14.3439 | 2022-12-09 04:21:05 | Jonkoping, Sweden | |||
2022-11-27 | US | Illinois | St. Clair | 17163 | 77210 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-28 04:21:02 | St. Clair, Illinois, US | |
2022-11-26 | US | Illinois | St. Clair | 17163 | 77210 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-27 04:21:05 | St. Clair, Illinois, US | |
2022-11-25 | US | Illinois | St. Clair | 17163 | 77210 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-26 04:21:11 | St. Clair, Illinois, US | |
2022-11-24 | US | Illinois | St. Clair | 17163 | 77210 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-25 04:21:06 | St. Clair, Illinois, US | |
2022-11-23 | US | Illinois | St. Clair | 17163 | 77210 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-24 04:21:09 | St. Clair, Illinois, US | |
2022-11-22 | US | Illinois | St. Clair | 17163 | 77177 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-23 04:21:06 | St. Clair, Illinois, US | |
2022-11-21 | US | Illinois | St. Clair | 17163 | 77153 | 771 | 0 | 38.46996033 | -89.93063427 | 2022-11-22 04:20:47 | St. Clair, Illinois, US | |
2022-11-03 | Japan | Shizuoka | 525277 | 771 | 0 | 34.916975 | 138.407784 | 2022-11-04 04:22:11 | Shizuoka, Japan | |||
2022-11-02 | Japan | Shizuoka | 523486 | 771 | 0 | 34.916975 | 138.407784 | 2022-11-03 04:22:05 | Shizuoka, Japan | |||
2022-10-08 | US | Ohio | Lake | 39085 | 57092 | 771 | 0 | 41.69710807 | -81.23676539 | 2022-10-09 04:21:16 | Lake, Ohio, US | |
2022-10-07 | US | Ohio | Lake | 39085 | 57092 | 771 | 0 | 41.69710807 | -81.23676539 | 2022-10-08 04:22:56 | Lake, Ohio, US | |
2022-10-06 | US | Ohio | Lake | 39085 | 57092 | 771 | 0 | 41.69710807 | -81.23676539 | 2022-10-07 04:23:08 | Lake, Ohio, US | |
2022-10-05 | US | Tennessee | Sullivan | 47163 | 54656 | 771 | 0 | 36.51240691 | -82.30412917 | 2022-10-06 04:21:22 | Sullivan, Tennessee, US | |
2022-10-04 | US | Tennessee | Sullivan | 47163 | 54629 | 771 | 0 | 36.51240691 | -82.30412917 | 2022-10-05 04:23:06 | Sullivan, Tennessee, US | |
2022-08-30 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-31 04:20:57 | Beaver, Pennsylvania, US | |
2022-08-29 | US | Virginia | Prince William | 51153 | 114326 | 771 | 0 | 38.70916224 | -77.48713689 | 2022-08-30 04:21:03 | Prince William, Virginia, US | |
2022-08-29 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-30 04:21:03 | Beaver, Pennsylvania, US | |
2022-08-28 | US | Virginia | Prince William | 51153 | 114029 | 771 | 0 | 38.70916224 | -77.48713689 | 2022-08-29 04:21:06 | Prince William, Virginia, US | |
2022-08-28 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-29 04:21:06 | Beaver, Pennsylvania, US | |
2022-08-27 | US | Virginia | Prince William | 51153 | 114029 | 771 | 0 | 38.70916224 | -77.48713689 | 2022-08-28 04:21:02 | Prince William, Virginia, US | |
2022-08-27 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-28 04:21:02 | Beaver, Pennsylvania, US | |
2022-08-26 | US | Virginia | Prince William | 51153 | 114029 | 771 | 0 | 38.70916224 | -77.48713689 | 2022-08-27 04:20:57 | Prince William, Virginia, US | |
2022-08-26 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-27 04:20:57 | Beaver, Pennsylvania, US | |
2022-08-25 | US | Virginia | Prince William | 51153 | 113904 | 771 | 0 | 38.70916224 | -77.48713689 | 2022-08-26 04:21:02 | Prince William, Virginia, US | |
2022-08-25 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-26 04:21:02 | Beaver, Pennsylvania, US | |
2022-08-24 | US | Pennsylvania | Beaver | 42007 | 44854 | 771 | 0 | 40.6825484 | -80.34921611 | 2022-08-25 04:21:13 | Beaver, Pennsylvania, US | |
2022-08-21 | US | West Virginia | Kanawha | 54039 | 53925 | 771 | 0 | 38.33860077 | -81.52857054 | 2022-08-22 04:20:38 | Kanawha, West Virginia, US | |
2022-08-20 | US | West Virginia | Kanawha | 54039 | 53925 | 771 | 0 | 38.33860077 | -81.52857054 | 2022-08-21 04:20:44 | Kanawha, West Virginia, US | |
2022-08-19 | US | West Virginia | Kanawha | 54039 | 53925 | 771 | 0 | 38.33860077 | -81.52857054 | 2022-08-20 04:21:01 | Kanawha, West Virginia, US | |
2022-08-18 | US | West Virginia | Kanawha | 54039 | 53859 | 771 | 0 | 38.33860077 | -81.52857054 | 2022-08-19 04:20:54 | Kanawha, West Virginia, US | |
2022-08-17 | Australia | South Australia | 743393 | 771 | 0 | -34.9285 | 138.6007 | 2022-08-18 04:21:11 | South Australia, Australia | |||
2022-08-04 | India | Nagaland | 35822 | 771 | 0 | 26.06702 | 94.470302 | 2022-08-05 04:20:52 | Nagaland, India | |||
2022-08-03 | India | Nagaland | 35816 | 771 | 0 | 26.06702 | 94.470302 | 2022-08-04 04:20:58 | Nagaland, India | |||
2022-08-02 | Japan | Kyoto | 297034 | 771 | 0 | 35.253815 | 135.443341 | 2022-08-03 04:20:59 | Kyoto, Japan | |||
2022-08-02 | India | Nagaland | 35803 | 771 | 0 | 26.06702 | 94.470302 | 2022-08-03 04:20:59 | Nagaland, India | |||
2022-08-01 | India | Nagaland | 35793 | 771 | 0 | 26.06702 | 94.470302 | 2022-08-02 04:20:53 | Nagaland, India | |||
2022-05-31 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-06-01 04:20:55 | Erie, Pennsylvania, US | |
2022-05-30 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-31 04:20:51 | Erie, Pennsylvania, US | |
2022-05-29 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-30 04:20:50 | Erie, Pennsylvania, US | |
2022-05-28 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-29 04:20:53 | Erie, Pennsylvania, US | |
2022-05-27 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-28 04:21:07 | Erie, Pennsylvania, US | |
2022-05-26 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-27 04:20:56 | Erie, Pennsylvania, US | |
2022-05-25 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-26 04:20:50 | Erie, Pennsylvania, US | |
2022-05-24 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-25 04:20:56 | Ingham, Michigan, US | |
2022-05-23 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-24 04:20:57 | Ingham, Michigan, US | |
2022-05-22 | US | Pennsylvania | Erie | 42049 | 59694 | 771 | 0 | 41.99253829 | -80.03301954 | 2022-05-26 04:20:50 | Erie, Pennsylvania, US | |
2022-05-21 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-22 04:20:52 | Ingham, Michigan, US | |
2022-05-20 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-21 04:20:58 | Ingham, Michigan, US | |
2022-05-19 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-20 04:20:57 | Ingham, Michigan, US | |
2022-05-18 | US | Michigan | Ingham | 26065 | 67283 | 771 | 0 | 42.59716886 | -84.37472069 | 2022-05-19 04:20:54 | Ingham, Michigan, US | |
2022-05-18 | Germany | Bremen | 196639 | 771 | 0 | 53.0793 | 8.8017 | 2022-05-19 04:20:54 | Bremen, Germany | |||
2022-05-10 | US | New Mexico | Dona Ana | 35013 | 63525 | 771 | 0 | 32.35275771 | -106.8329387 | 2022-05-11 04:20:48 | Dona Ana, New Mexico, US | |
2022-05-02 | US | Pennsylvania | Lackawanna | 42069 | 44383 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-05-03 04:21:00 | Lackawanna, Pennsylvania, US | |
2022-05-01 | US | Pennsylvania | Lackawanna | 42069 | 44353 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-05-02 04:21:10 | Lackawanna, Pennsylvania, US | |
2022-04-30 | US | Pennsylvania | Lackawanna | 42069 | 44326 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-05-01 04:20:57 | Lackawanna, Pennsylvania, US | |
2022-04-29 | US | Pennsylvania | Lackawanna | 42069 | 44259 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-04-30 04:21:05 | Lackawanna, Pennsylvania, US | |
2022-04-28 | US | Pennsylvania | Lackawanna | 42069 | 44201 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-04-29 04:20:59 | Lackawanna, Pennsylvania, US | |
2022-04-27 | US | Pennsylvania | Lackawanna | 42069 | 44136 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-04-28 04:20:47 | Lackawanna, Pennsylvania, US | |
2022-04-26 | US | Pennsylvania | Lackawanna | 42069 | 44053 | 771 | 0 | 41.43564672 | -75.60379201 | 2022-04-27 04:20:52 | Lackawanna, Pennsylvania, US | |
2022-04-24 | US | Minnesota | Dakota | 27037 | 110798 | 771 | 0 | 44.67172617 | -93.06299363 | 2022-04-25 04:20:56 | Dakota, Minnesota, US | |
2022-04-23 | US | Minnesota | Dakota | 27037 | 110798 | 771 | 0 | 44.67172617 | -93.06299363 | 2022-04-24 04:20:56 | Dakota, Minnesota, US | |
2022-04-22 | US | Minnesota | Dakota | 27037 | 110798 | 771 | 0 | 44.67172617 | -93.06299363 | 2022-04-23 04:20:50 | Dakota, Minnesota, US | |
2022-04-21 | US | Minnesota | Dakota | 27037 | 110688 | 771 | 0 | 44.67172617 | -93.06299363 | 2022-04-22 04:20:45 | Dakota, Minnesota, US | |
2022-04-13 | US | Alabama | Tuscaloosa | 1125 | 55973 | 771 | 0 | 33.28726072 | -87.52556818 | 2022-04-13 23:21:06 | Tuscaloosa, Alabama, US | |
2022-04-05 | US | Georgia | Bibb | 13021 | 37034 | 771 | 0 | 32.80904227 | -83.70489165 | 2022-04-06 04:20:49 | Bibb, Georgia, US | |
2022-04-04 | US | Georgia | Bibb | 13021 | 37021 | 771 | 0 | 32.80904227 | -83.70489165 | 2022-04-05 04:20:48 | Bibb, Georgia, US | |
2022-03-21 | Colombia | Putumayo | 20468 | 771 | 0 | 0.436 | -75.5277 | 2022-03-22 04:20:54 | Putumayo, Colombia | |||
2022-03-17 | Russia | Tomsk Oblast | 119797 | 771 | 0 | 58.6124279 | 82.04753149999998 | 2022-03-18 04:20:55 | Tomsk Oblast, Russia | |||
2022-03-16 | Sweden | Ostergotland | 93685 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-17 04:20:56 | Ostergotland, Sweden | |||
2022-03-16 | Russia | Tomsk Oblast | 119055 | 771 | 0 | 58.6124279 | 82.04753149999998 | 2022-03-17 04:20:56 | Tomsk Oblast, Russia | |||
2022-03-15 | Sweden | Ostergotland | 93610 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-16 04:20:50 | Ostergotland, Sweden | |||
2022-03-14 | Sweden | Ostergotland | 93433 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-15 04:20:47 | Ostergotland, Sweden | |||
2022-03-13 | US | Washington | Clark | 53011 | 86324 | 771 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-14 04:20:46 | Clark, Washington, US | |
2022-03-13 | Sweden | Ostergotland | 93433 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-14 04:20:46 | Ostergotland, Sweden | |||
2022-03-13 | Bahamas | 33194 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-14 04:20:46 | Bahamas | ||||
2022-03-12 | US | Washington | Clark | 53011 | 86324 | 771 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-13 04:20:49 | Clark, Washington, US | |
2022-03-12 | Sweden | Ostergotland | 93433 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-13 04:20:49 | Ostergotland, Sweden | |||
2022-03-12 | Bahamas | 33194 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-13 04:20:49 | Bahamas | ||||
2022-03-11 | US | Washington | Clark | 53011 | 86324 | 771 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-12 04:20:50 | Clark, Washington, US | |
2022-03-11 | Sweden | Ostergotland | 93433 | 771 | 0 | 58.3454 | 15.5198 | 2022-03-12 04:20:50 | Ostergotland, Sweden | |||
2022-03-11 | Bahamas | 33191 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-12 04:20:50 | Bahamas | ||||
2022-03-10 | Bahamas | 33188 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-11 04:20:50 | Bahamas | ||||
2022-03-09 | Bahamas | 33180 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-10 04:20:48 | Bahamas | ||||
2022-03-08 | US | Michigan | Ottawa | 26139 | 74177 | 771 | 0 | 42.95996803 | -85.9969107 | 2022-03-09 04:20:59 | Ottawa, Michigan, US | |
2022-03-08 | Bahamas | 33180 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-09 04:20:59 | Bahamas | ||||
2022-03-07 | US | North Carolina | Forsyth | 37067 | 91516 | 771 | 0 | 36.12859861 | -80.25459052 | 2022-03-08 04:20:54 | Forsyth, North Carolina, US | |
2022-03-07 | US | Michigan | Ottawa | 26139 | 74177 | 771 | 0 | 42.95996803 | -85.9969107 | 2022-03-08 04:20:54 | Ottawa, Michigan, US | |
2022-03-07 | Russia | Sakhalin Oblast | 61896 | 771 | 0 | 49.7219665 | 143.448533 | 2022-03-08 04:20:54 | Sakhalin Oblast, Russia | |||
2022-03-07 | Bahamas | 33176 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-08 04:20:54 | Bahamas | ||||
2022-03-06 | Bahamas | 33171 | 771 | 0 | 25.025885 | -78.035889 | 2022-03-07 04:20:47 | Bahamas |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;