johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
371 rows where deaths = 819 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328668 | 328668 | 2022-12-27 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-28 04:21:04 | Bibb, Georgia, US | |
218741 | 218741 | 2022-12-26 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-27 04:21:07 | Bibb, Georgia, US | |
3223198 | 3223198 | 2022-12-25 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-26 04:21:06 | Bibb, Georgia, US | |
3222429 | 3222429 | 2022-12-25 | Japan | Gifu | 431655 | 819 | 0 | 35.778671 | 137.055925 | 2022-12-26 04:21:06 | Gifu, Japan | |||
1019112 | 1019112 | 2022-12-24 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-25 04:21:04 | Bibb, Georgia, US | |
691135 | 691135 | 2022-12-23 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-24 04:21:02 | Bibb, Georgia, US | |
2180345 | 2180345 | 2022-12-22 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-23 04:21:04 | Bibb, Georgia, US | |
452149 | 452149 | 2022-12-21 | US | Georgia | Bibb | 13021 | 43802 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-22 04:20:56 | Bibb, Georgia, US | |
2952148 | 2952148 | 2022-12-20 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-21 04:21:03 | Bibb, Georgia, US | |
3174550 | 3174550 | 2022-12-19 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-20 04:21:04 | Bibb, Georgia, US | |
1629067 | 1629067 | 2022-12-18 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-19 04:21:03 | Bibb, Georgia, US | |
504446 | 504446 | 2022-12-17 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-18 04:21:03 | Bibb, Georgia, US | |
3325018 | 3325018 | 2022-12-16 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-17 04:21:04 | Bibb, Georgia, US | |
543530 | 543530 | 2022-12-15 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-16 04:21:01 | Bibb, Georgia, US | |
349058 | 349058 | 2022-12-14 | US | Georgia | Bibb | 13021 | 43615 | 819 | 0 | 32.80904227 | -83.70489165 | 2022-12-15 04:20:58 | Bibb, Georgia, US | |
1053332 | 1053332 | 2022-11-06 | US | West Virginia | Kanawha | 54039 | 56553 | 819 | 0 | 38.33860077 | -81.52857054 | 2022-11-07 04:21:26 | Kanawha, West Virginia, US | |
621356 | 621356 | 2022-11-05 | US | West Virginia | Kanawha | 54039 | 56553 | 819 | 0 | 38.33860077 | -81.52857054 | 2022-11-06 04:21:24 | Kanawha, West Virginia, US | |
1025860 | 1025860 | 2022-11-04 | US | West Virginia | Kanawha | 54039 | 56553 | 819 | 0 | 38.33860077 | -81.52857054 | 2022-11-05 04:21:52 | Kanawha, West Virginia, US | |
434851 | 434851 | 2022-11-03 | US | West Virginia | Kanawha | 54039 | 56507 | 819 | 0 | 38.33860077 | -81.52857054 | 2022-11-04 04:22:11 | Kanawha, West Virginia, US | |
853093 | 853093 | 2022-11-02 | US | West Virginia | Kanawha | 54039 | 56488 | 819 | 0 | 38.33860077 | -81.52857054 | 2022-11-03 04:22:05 | Kanawha, West Virginia, US | |
2531355 | 2531355 | 2022-10-06 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-07 04:23:08 | St. Louis City, Missouri, US | |
1812749 | 1812749 | 2022-10-05 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-06 04:21:22 | St. Louis City, Missouri, US | |
134075 | 134075 | 2022-10-04 | US | Virginia | Chesterfield | 51041 | 91198 | 819 | 0 | 37.37373208 | -77.5868014 | 2022-10-05 04:23:06 | Chesterfield, Virginia, US | |
132723 | 132723 | 2022-10-04 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-05 04:23:06 | St. Louis City, Missouri, US | |
2687670 | 2687670 | 2022-10-03 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-04 04:22:55 | St. Louis City, Missouri, US | |
2261737 | 2261737 | 2022-10-02 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-03 04:23:11 | St. Louis City, Missouri, US | |
2997263 | 2997263 | 2022-10-01 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-02 04:21:23 | St. Louis City, Missouri, US | |
855589 | 855589 | 2022-09-30 | US | Missouri | St. Louis City | 29510 | 70513 | 819 | 0 | 38.63555736 | -90.24349225 | 2022-10-01 04:23:01 | St. Louis City, Missouri, US | |
1372212 | 1372212 | 2022-09-21 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-22 04:22:56 | Dakota, Minnesota, US | |
2018442 | 2018442 | 2022-09-20 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-21 04:23:22 | Dakota, Minnesota, US | |
3572315 | 3572315 | 2022-09-19 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-20 04:22:48 | Dakota, Minnesota, US | |
421054 | 421054 | 2022-09-18 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-19 04:21:49 | Dakota, Minnesota, US | |
3375078 | 3375078 | 2022-09-17 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-18 04:22:50 | Dakota, Minnesota, US | |
2357186 | 2357186 | 2022-09-16 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-17 04:20:19 | Dakota, Minnesota, US | |
3988343 | 3988343 | 2022-09-15 | US | Minnesota | Dakota | 27037 | 127616 | 819 | 0 | 44.67172617 | -93.06299363 | 2022-09-16 04:21:19 | Dakota, Minnesota, US | |
2633578 | 2633578 | 2022-09-05 | Cote d'Ivoire | 86824 | 819 | 0 | 7.54 | -5.5471 | 2022-09-06 04:21:02 | Cote d'Ivoire | ||||
2987142 | 2987142 | 2022-09-04 | Cote d'Ivoire | 86821 | 819 | 0 | 7.54 | -5.5471 | 2022-09-05 04:21:01 | Cote d'Ivoire | ||||
2712827 | 2712827 | 2022-09-03 | Cote d'Ivoire | 86808 | 819 | 0 | 7.54 | -5.5471 | 2022-09-04 04:21:22 | Cote d'Ivoire | ||||
1393532 | 1393532 | 2022-09-02 | Cote d'Ivoire | 86779 | 819 | 0 | 7.54 | -5.5471 | 2022-09-03 04:21:04 | Cote d'Ivoire | ||||
3548087 | 3548087 | 2022-09-01 | US | California | San Mateo | 6081 | 176019 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-09-02 04:21:07 | San Mateo, California, US | |
3547361 | 3547361 | 2022-09-01 | Cote d'Ivoire | 86760 | 819 | 0 | 7.54 | -5.5471 | 2022-09-02 04:21:07 | Cote d'Ivoire | ||||
2344007 | 2344007 | 2022-08-31 | US | California | San Mateo | 6081 | 175653 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-09-01 04:21:03 | San Mateo, California, US | |
2343281 | 2343281 | 2022-08-31 | Cote d'Ivoire | 86738 | 819 | 0 | 7.54 | -5.5471 | 2022-09-01 04:21:03 | Cote d'Ivoire | ||||
3774487 | 3774487 | 2022-08-30 | US | California | San Mateo | 6081 | 175643 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-08-31 04:20:57 | San Mateo, California, US | |
3773761 | 3773761 | 2022-08-30 | Cote d'Ivoire | 86695 | 819 | 0 | 7.54 | -5.5471 | 2022-08-31 04:20:57 | Cote d'Ivoire | ||||
1682713 | 1682713 | 2022-08-29 | US | New Mexico | San Juan | 35045 | 46794 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-30 04:21:03 | San Juan, New Mexico, US | |
1681083 | 1681083 | 2022-08-29 | US | California | San Mateo | 6081 | 175635 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-08-30 04:21:03 | San Mateo, California, US | |
1879197 | 1879197 | 2022-08-28 | US | New Mexico | San Juan | 35045 | 46746 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-29 04:21:06 | San Juan, New Mexico, US | |
1877567 | 1877567 | 2022-08-28 | US | California | San Mateo | 6081 | 175136 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-08-29 04:21:06 | San Mateo, California, US | |
2098324 | 2098324 | 2022-08-27 | US | New Mexico | San Juan | 35045 | 46746 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-28 04:21:02 | San Juan, New Mexico, US | |
2096694 | 2096694 | 2022-08-27 | US | California | San Mateo | 6081 | 175133 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-08-28 04:21:02 | San Mateo, California, US | |
1534139 | 1534139 | 2022-08-26 | US | New Mexico | San Juan | 35045 | 46746 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-27 04:20:57 | San Juan, New Mexico, US | |
1532509 | 1532509 | 2022-08-26 | US | California | San Mateo | 6081 | 175126 | 819 | 0 | 37.4228808 | -122.3275546 | 2022-08-27 04:20:57 | San Mateo, California, US | |
2831026 | 2831026 | 2022-08-25 | US | New Mexico | San Juan | 35045 | 46715 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-26 04:21:02 | San Juan, New Mexico, US | |
2325559 | 2325559 | 2022-08-24 | US | New Mexico | San Juan | 35045 | 46674 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-25 04:21:13 | San Juan, New Mexico, US | |
1252968 | 1252968 | 2022-08-23 | US | New Mexico | San Juan | 35045 | 46610 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-24 04:20:46 | San Juan, New Mexico, US | |
2855072 | 2855072 | 2022-08-22 | US | New Mexico | San Juan | 35045 | 46548 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-23 04:20:56 | San Juan, New Mexico, US | |
2405044 | 2405044 | 2022-08-21 | US | New Mexico | San Juan | 35045 | 46459 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-22 04:20:38 | San Juan, New Mexico, US | |
3800122 | 3800122 | 2022-08-20 | US | New Mexico | San Juan | 35045 | 46459 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-21 04:20:44 | San Juan, New Mexico, US | |
2365708 | 2365708 | 2022-08-19 | US | New Mexico | San Juan | 35045 | 46459 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-20 04:21:01 | San Juan, New Mexico, US | |
1163379 | 1163379 | 2022-08-18 | US | New Mexico | San Juan | 35045 | 46415 | 819 | 0 | 36.50838318 | -108.320437 | 2022-08-19 04:20:54 | San Juan, New Mexico, US | |
1161174 | 1161174 | 2022-08-18 | Japan | Kyoto | 372716 | 819 | 0 | 35.253815 | 135.443341 | 2022-08-19 04:20:54 | Kyoto, Japan | |||
3950388 | 3950388 | 2022-08-17 | Germany | Bremen | 246193 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-18 04:21:11 | Bremen, Germany | |||
990890 | 990890 | 2022-08-16 | Germany | Bremen | 245737 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-17 04:20:59 | Bremen, Germany | |||
2495715 | 2495715 | 2022-08-15 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-16 04:20:58 | Ottawa, Michigan, US | |
2493929 | 2493929 | 2022-08-15 | Germany | Bremen | 245157 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-16 04:20:58 | Bremen, Germany | |||
3649265 | 3649265 | 2022-08-14 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-15 04:20:59 | Ottawa, Michigan, US | |
3647479 | 3647479 | 2022-08-14 | Germany | Bremen | 244745 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-15 04:20:59 | Bremen, Germany | |||
1970271 | 1970271 | 2022-08-13 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-14 04:20:55 | Ottawa, Michigan, US | |
1968485 | 1968485 | 2022-08-13 | Germany | Bremen | 244745 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-14 04:20:55 | Bremen, Germany | |||
2890080 | 2890080 | 2022-08-12 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-13 04:20:52 | Ottawa, Michigan, US | |
2888294 | 2888294 | 2022-08-12 | Germany | Bremen | 244745 | 819 | 0 | 53.0793 | 8.8017 | 2022-08-13 04:20:52 | Bremen, Germany | |||
3909685 | 3909685 | 2022-08-11 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-12 04:20:54 | Ottawa, Michigan, US | |
1348002 | 1348002 | 2022-08-10 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-11 04:20:49 | Ottawa, Michigan, US | |
1087757 | 1087757 | 2022-08-09 | US | Michigan | Ottawa | 26139 | 81492 | 819 | 0 | 42.95996803 | -85.9969107 | 2022-08-10 04:20:57 | Ottawa, Michigan, US | |
3212536 | 3212536 | 2022-07-18 | US | New York | Oneida | 36065 | 60955 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-19 04:20:58 | Oneida, New York, US | |
3407711 | 3407711 | 2022-07-17 | US | New York | Oneida | 36065 | 60930 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-18 04:20:59 | Oneida, New York, US | |
3405340 | 3405340 | 2022-07-17 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-18 04:20:59 | Reunion, France | |||
2153911 | 2153911 | 2022-07-16 | US | New York | Oneida | 36065 | 60901 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-17 04:21:15 | Oneida, New York, US | |
2151540 | 2151540 | 2022-07-16 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-17 04:21:15 | Reunion, France | |||
2421144 | 2421144 | 2022-07-15 | US | New York | Oneida | 36065 | 60849 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-16 04:21:05 | Oneida, New York, US | |
2418773 | 2418773 | 2022-07-15 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-16 04:21:05 | Reunion, France | |||
3431219 | 3431219 | 2022-07-14 | US | New York | Oneida | 36065 | 60849 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-15 04:20:53 | Oneida, New York, US | |
3428848 | 3428848 | 2022-07-14 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-15 04:20:53 | Reunion, France | |||
3111739 | 3111739 | 2022-07-13 | US | New York | Oneida | 36065 | 60825 | 819 | 0 | 43.24375382 | -75.43710392 | 2022-07-14 04:20:57 | Oneida, New York, US | |
3109368 | 3109368 | 2022-07-13 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-14 04:20:57 | Reunion, France | |||
629791 | 629791 | 2022-07-12 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-13 04:20:58 | Reunion, France | |||
1211435 | 1211435 | 2022-07-11 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-12 04:20:51 | Reunion, France | |||
2788917 | 2788917 | 2022-07-10 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-11 04:20:46 | Reunion, France | |||
141870 | 141870 | 2022-07-09 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-10 04:20:54 | Reunion, France | |||
1416970 | 1416970 | 2022-07-08 | France | Reunion | 425638 | 819 | 0 | -21.1151 | 55.5364 | 2022-07-09 04:20:59 | Reunion, France | |||
3078713 | 3078713 | 2022-07-04 | US | Colorado | Pueblo | 8101 | 52317 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-07-05 04:20:45 | Pueblo, Colorado, US | |
1767995 | 1767995 | 2022-07-03 | US | Colorado | Pueblo | 8101 | 52279 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-07-04 04:20:54 | Pueblo, Colorado, US | |
3365981 | 3365981 | 2022-07-02 | US | Colorado | Pueblo | 8101 | 52237 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-07-03 04:20:59 | Pueblo, Colorado, US | |
594310 | 594310 | 2022-07-01 | US | Colorado | Pueblo | 8101 | 52191 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-07-02 04:21:16 | Pueblo, Colorado, US | |
3940711 | 3940711 | 2022-06-30 | US | Colorado | Pueblo | 8101 | 52118 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-07-01 04:21:10 | Pueblo, Colorado, US | |
2490669 | 2490669 | 2022-06-29 | US | Colorado | Pueblo | 8101 | 52025 | 819 | 0 | 38.17359144 | -104.5127437 | 2022-06-30 04:21:01 | Pueblo, Colorado, US | |
3510825 | 3510825 | 2022-06-05 | US | Washington | Clark | 53011 | 94403 | 819 | 0 | 45.77568046 | -122.4829204 | 2022-06-06 04:20:57 | Clark, Washington, US | |
3530902 | 3530902 | 2022-06-04 | US | Washington | Clark | 53011 | 94403 | 819 | 0 | 45.77568046 | -122.4829204 | 2022-06-05 04:20:55 | Clark, Washington, US | |
3136988 | 3136988 | 2022-06-03 | US | Washington | Clark | 53011 | 94403 | 819 | 0 | 45.77568046 | -122.4829204 | 2022-06-04 04:20:58 | Clark, Washington, US |
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]);