johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
273 rows where deaths = 801 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690366 | 690366 | 2022-12-23 | Japan | Gifu | 425324 | 801 | 0 | 35.778671 | 137.055925 | 2022-12-24 04:21:02 | Gifu, Japan | |||
311285 | 311285 | 2022-12-13 | US | Virginia | Prince William | 51153 | 120975 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-14 04:21:04 | Prince William, Virginia, US | |
1152346 | 1152346 | 2022-12-12 | US | Virginia | Prince William | 51153 | 120880 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-13 04:21:01 | Prince William, Virginia, US | |
872200 | 872200 | 2022-12-11 | US | Virginia | Prince William | 51153 | 120656 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-12 04:21:01 | Prince William, Virginia, US | |
260730 | 260730 | 2022-12-10 | US | Virginia | Prince William | 51153 | 120656 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-11 04:20:50 | Prince William, Virginia, US | |
3939444 | 3939444 | 2022-12-09 | US | Virginia | Prince William | 51153 | 120656 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-10 04:21:02 | Prince William, Virginia, US | |
3380776 | 3380776 | 2022-12-08 | US | Virginia | Prince William | 51153 | 120566 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-09 04:21:05 | Prince William, Virginia, US | |
1988047 | 1988047 | 2022-12-07 | US | Virginia | Prince William | 51153 | 120450 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-08 04:21:07 | Prince William, Virginia, US | |
3717570 | 3717570 | 2022-12-06 | US | Virginia | Prince William | 51153 | 120340 | 801 | 0 | 38.70916224 | -77.48713689 | 2022-12-07 04:20:58 | Prince William, Virginia, US | |
2559223 | 2559223 | 2022-11-29 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-30 04:21:07 | Marion, Oregon, US | |
1242297 | 1242297 | 2022-11-28 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-29 04:21:05 | Marion, Oregon, US | |
3554285 | 3554285 | 2022-11-27 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-28 04:21:02 | Marion, Oregon, US | |
2102765 | 2102765 | 2022-11-26 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-27 04:21:05 | Marion, Oregon, US | |
490256 | 490256 | 2022-11-25 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-26 04:21:11 | Marion, Oregon, US | |
3526085 | 3526085 | 2022-11-24 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-25 04:21:06 | Marion, Oregon, US | |
3314868 | 3314868 | 2022-11-23 | US | Oregon | Marion | 41047 | 84536 | 801 | 0 | 44.90287942 | -122.5815117 | 2022-11-24 04:21:09 | Marion, Oregon, US | |
292007 | 292007 | 2022-11-15 | Japan | Hiroshima | 489207 | 801 | 0 | 34.605309 | 132.788719 | 2022-11-16 04:21:09 | Hiroshima, Japan | |||
2430950 | 2430950 | 2022-11-09 | Japan | Okinawa | 511877 | 801 | 0 | 25.768923 | 126.668016 | 2022-11-10 04:21:16 | Okinawa, Japan | |||
479606 | 479606 | 2022-11-08 | Japan | Okinawa | 511498 | 801 | 0 | 25.768923 | 126.668016 | 2022-11-09 04:21:22 | Okinawa, Japan | |||
2532875 | 2532875 | 2022-10-06 | US | West Virginia | Kanawha | 54039 | 55944 | 801 | 0 | 38.33860077 | -81.52857054 | 2022-10-07 04:23:08 | Kanawha, West Virginia, US | |
1812302 | 1812302 | 2022-10-05 | US | Louisiana | Ouachita | 22073 | 59429 | 801 | 0 | 32.47645559 | -92.15704172 | 2022-10-06 04:21:22 | Ouachita, Louisiana, US | |
132276 | 132276 | 2022-10-04 | US | Louisiana | Ouachita | 22073 | 59405 | 801 | 0 | 32.47645559 | -92.15704172 | 2022-10-05 04:23:06 | Ouachita, Louisiana, US | |
2713046 | 2713046 | 2022-09-03 | Malta | 114114 | 801 | 0 | 35.9375 | 14.3754 | 2022-09-04 04:21:22 | Malta | ||||
1393751 | 1393751 | 2022-09-02 | Malta | 114097 | 801 | 0 | 35.9375 | 14.3754 | 2022-09-03 04:21:04 | Malta | ||||
3547580 | 3547580 | 2022-09-01 | Malta | 114075 | 801 | 0 | 35.9375 | 14.3754 | 2022-09-02 04:21:07 | Malta | ||||
2343500 | 2343500 | 2022-08-31 | Malta | 114050 | 801 | 0 | 35.9375 | 14.3754 | 2022-09-01 04:21:03 | Malta | ||||
3773980 | 3773980 | 2022-08-30 | Malta | 114026 | 801 | 0 | 35.9375 | 14.3754 | 2022-08-31 04:20:57 | Malta | ||||
1680576 | 1680576 | 2022-08-29 | Malta | 114000 | 801 | 0 | 35.9375 | 14.3754 | 2022-08-30 04:21:03 | Malta | ||||
1880309 | 1880309 | 2022-08-28 | US | Virginia | Chesterfield | 51041 | 88634 | 801 | 0 | 37.37373208 | -77.5868014 | 2022-08-29 04:21:06 | Chesterfield, Virginia, US | |
1877060 | 1877060 | 2022-08-28 | Malta | 113989 | 801 | 0 | 35.9375 | 14.3754 | 2022-08-29 04:21:06 | Malta | ||||
2099436 | 2099436 | 2022-08-27 | US | Virginia | Chesterfield | 51041 | 88634 | 801 | 0 | 37.37373208 | -77.5868014 | 2022-08-28 04:21:02 | Chesterfield, Virginia, US | |
2096187 | 2096187 | 2022-08-27 | Malta | 113972 | 801 | 0 | 35.9375 | 14.3754 | 2022-08-28 04:21:02 | Malta | ||||
1535251 | 1535251 | 2022-08-26 | US | Virginia | Chesterfield | 51041 | 88634 | 801 | 0 | 37.37373208 | -77.5868014 | 2022-08-27 04:20:57 | Chesterfield, Virginia, US | |
993665 | 993665 | 2022-08-16 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-17 04:20:59 | Erie, Pennsylvania, US | |
2496704 | 2496704 | 2022-08-15 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-16 04:20:58 | Erie, Pennsylvania, US | |
3650254 | 3650254 | 2022-08-14 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-15 04:20:59 | Erie, Pennsylvania, US | |
1971260 | 1971260 | 2022-08-13 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-14 04:20:55 | Erie, Pennsylvania, US | |
2891069 | 2891069 | 2022-08-12 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-13 04:20:52 | Erie, Pennsylvania, US | |
3910674 | 3910674 | 2022-08-11 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-12 04:20:54 | Erie, Pennsylvania, US | |
1348991 | 1348991 | 2022-08-10 | US | Pennsylvania | Erie | 42049 | 63679 | 801 | 0 | 41.99253829 | -80.03301954 | 2022-08-11 04:20:49 | Erie, Pennsylvania, US | |
1488345 | 1488345 | 2022-07-26 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-27 04:21:04 | Bibb, Georgia, US | |
2594791 | 2594791 | 2022-07-25 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-26 04:20:58 | Bibb, Georgia, US | |
897957 | 897957 | 2022-07-24 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-25 04:20:51 | Hinds, Mississippi, US | |
896906 | 896906 | 2022-07-24 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-25 04:20:51 | Bibb, Georgia, US | |
92951 | 92951 | 2022-07-23 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-24 04:20:47 | Hinds, Mississippi, US | |
91900 | 91900 | 2022-07-23 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-24 04:20:47 | Bibb, Georgia, US | |
901973 | 901973 | 2022-07-22 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-23 04:20:53 | Hinds, Mississippi, US | |
900922 | 900922 | 2022-07-22 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-23 04:20:53 | Bibb, Georgia, US | |
672109 | 672109 | 2022-07-21 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-22 04:21:15 | Hinds, Mississippi, US | |
671058 | 671058 | 2022-07-21 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-22 04:21:15 | Bibb, Georgia, US | |
1610473 | 1610473 | 2022-07-20 | US | New Mexico | San Juan | 35045 | 44858 | 801 | 0 | 36.50838318 | -108.320437 | 2022-07-21 04:21:10 | San Juan, New Mexico, US | |
1610072 | 1610072 | 2022-07-20 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-21 04:21:10 | Hinds, Mississippi, US | |
1609021 | 1609021 | 2022-07-20 | US | Georgia | Bibb | 13021 | 40529 | 801 | 0 | 32.80904227 | -83.70489165 | 2022-07-21 04:21:10 | Bibb, Georgia, US | |
960705 | 960705 | 2022-07-19 | US | Mississippi | Hinds | 28049 | 58329 | 801 | 0 | 32.2656285 | -90.44435448 | 2022-07-20 04:20:59 | Hinds, Mississippi, US | |
3408928 | 3408928 | 2022-07-17 | US | Washington | Yakima | 53077 | 75873 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-18 04:20:59 | Yakima, Washington, US | |
2155128 | 2155128 | 2022-07-16 | US | Washington | Yakima | 53077 | 75631 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-17 04:21:15 | Yakima, Washington, US | |
2422361 | 2422361 | 2022-07-15 | US | Washington | Yakima | 53077 | 75631 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-16 04:21:05 | Yakima, Washington, US | |
3432436 | 3432436 | 2022-07-14 | US | Washington | Yakima | 53077 | 75631 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-15 04:20:53 | Yakima, Washington, US | |
3112956 | 3112956 | 2022-07-13 | US | Washington | Yakima | 53077 | 75631 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-14 04:20:57 | Yakima, Washington, US | |
3109381 | 3109381 | 2022-07-13 | Germany | Bremen | 226840 | 801 | 0 | 53.0793 | 8.8017 | 2022-07-14 04:20:57 | Bremen, Germany | |||
633379 | 633379 | 2022-07-12 | US | Washington | Yakima | 53077 | 75485 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-13 04:20:58 | Yakima, Washington, US | |
632589 | 632589 | 2022-07-12 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-13 04:20:58 | Lackawanna, Pennsylvania, US | |
1215023 | 1215023 | 2022-07-11 | US | Washington | Yakima | 53077 | 75485 | 801 | 0 | 46.45738486 | -120.7380126 | 2022-07-12 04:20:51 | Yakima, Washington, US | |
1214233 | 1214233 | 2022-07-11 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-12 04:20:51 | Lackawanna, Pennsylvania, US | |
2791715 | 2791715 | 2022-07-10 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-11 04:20:46 | Lackawanna, Pennsylvania, US | |
144668 | 144668 | 2022-07-09 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-10 04:20:54 | Lackawanna, Pennsylvania, US | |
1419768 | 1419768 | 2022-07-08 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-09 04:20:59 | Lackawanna, Pennsylvania, US | |
2743693 | 2743693 | 2022-07-07 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-08 04:20:56 | Lackawanna, Pennsylvania, US | |
1202488 | 1202488 | 2022-07-06 | US | Pennsylvania | Lackawanna | 42069 | 48421 | 801 | 0 | 41.43564672 | -75.60379201 | 2022-07-07 04:20:55 | Lackawanna, Pennsylvania, US | |
3079743 | 3079743 | 2022-07-04 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-07-05 04:20:45 | Ottawa, Michigan, US | |
1769025 | 1769025 | 2022-07-03 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-07-04 04:20:54 | Ottawa, Michigan, US | |
3367011 | 3367011 | 2022-07-02 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-07-03 04:20:59 | Ottawa, Michigan, US | |
595340 | 595340 | 2022-07-01 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-07-02 04:21:16 | Ottawa, Michigan, US | |
3941741 | 3941741 | 2022-06-30 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-07-01 04:21:10 | Ottawa, Michigan, US | |
2491699 | 2491699 | 2022-06-29 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-06-30 04:21:01 | Ottawa, Michigan, US | |
2491036 | 2491036 | 2022-06-29 | US | Illinois | Madison | 17119 | 75694 | 801 | 0 | 38.83042506 | -89.90422563 | 2022-06-30 04:21:01 | Madison, Illinois, US | |
2241081 | 2241081 | 2022-06-28 | US | Michigan | Ottawa | 26139 | 79170 | 801 | 0 | 42.95996803 | -85.9969107 | 2022-06-29 04:20:59 | Ottawa, Michigan, US | |
3397280 | 3397280 | 2022-06-18 | Cote d'Ivoire | 82659 | 801 | 0 | 7.54 | -5.5471 | 2022-06-19 04:20:51 | Cote d'Ivoire | ||||
2311157 | 2311157 | 2022-06-17 | Cote d'Ivoire | 82659 | 801 | 0 | 7.54 | -5.5471 | 2022-06-18 04:21:10 | Cote d'Ivoire | ||||
3580325 | 3580325 | 2022-06-02 | US | Minnesota | Anoka | 27003 | 102716 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-06-03 04:20:58 | Anoka, Minnesota, US | |
972618 | 972618 | 2022-06-01 | US | Minnesota | Anoka | 27003 | 102434 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-06-02 05:20:39 | Anoka, Minnesota, US | |
230925 | 230925 | 2022-05-31 | US | Minnesota | Anoka | 27003 | 102339 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-06-01 04:20:55 | Anoka, Minnesota, US | |
3187690 | 3187690 | 2022-05-30 | US | Minnesota | Anoka | 27003 | 102164 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-05-31 04:20:51 | Anoka, Minnesota, US | |
3199839 | 3199839 | 2022-05-29 | US | Minnesota | Anoka | 27003 | 102164 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-05-30 04:20:50 | Anoka, Minnesota, US | |
2726717 | 2726717 | 2022-05-28 | US | Minnesota | Anoka | 27003 | 102164 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-05-29 04:20:53 | Anoka, Minnesota, US | |
1315898 | 1315898 | 2022-05-27 | US | Minnesota | Anoka | 27003 | 102164 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-05-28 04:21:07 | Anoka, Minnesota, US | |
1851690 | 1851690 | 2022-05-26 | US | Minnesota | Anoka | 27003 | 102061 | 801 | 0 | 45.27476015 | -93.24604565 | 2022-05-27 04:20:56 | Anoka, Minnesota, US | |
1184435 | 1184435 | 2022-05-18 | Bahamas | 34011 | 801 | 0 | 25.025885 | -78.035889 | 2022-05-19 04:20:54 | Bahamas | ||||
3582332 | 3582332 | 2022-05-17 | Bahamas | 33989 | 801 | 0 | 25.025885 | -78.035889 | 2022-05-18 04:20:50 | Bahamas | ||||
1503289 | 1503289 | 2022-05-16 | Bahamas | 33957 | 801 | 0 | 25.025885 | -78.035889 | 2022-05-17 04:20:59 | Bahamas | ||||
2083648 | 2083648 | 2022-05-15 | Bahamas | 33934 | 801 | 0 | 25.025885 | -78.035889 | 2022-05-16 04:20:47 | Bahamas | ||||
3354359 | 3354359 | 2022-05-14 | Bahamas | 33871 | 801 | 0 | 25.025885 | -78.035889 | 2022-05-15 04:20:53 | Bahamas | ||||
2536833 | 2536833 | 2022-05-12 | US | Washington | Clark | 53011 | 91106 | 801 | 0 | 45.77568046 | -122.4829204 | 2022-05-13 04:20:51 | Clark, Washington, US | |
3448279 | 3448279 | 2022-05-11 | US | Washington | Clark | 53011 | 91106 | 801 | 0 | 45.77568046 | -122.4829204 | 2022-05-12 04:20:54 | Clark, Washington, US | |
3447096 | 3447096 | 2022-05-11 | US | New York | Oneida | 36065 | 58246 | 801 | 0 | 43.24375382 | -75.43710392 | 2022-05-12 04:20:54 | Oneida, New York, US | |
3537713 | 3537713 | 2022-05-10 | US | New York | Oneida | 36065 | 58083 | 801 | 0 | 43.24375382 | -75.43710392 | 2022-05-11 04:20:48 | Oneida, New York, US | |
3722495 | 3722495 | 2022-04-25 | Spain | Cantabria | 133682 | 801 | 0 | 43.1828 | -3.9878 | 2022-04-26 04:20:51 | Cantabria, Spain | |||
2029063 | 2029063 | 2022-04-24 | Spain | Cantabria | 133682 | 801 | 0 | 43.1828 | -3.9878 | 2022-04-25 04:20:56 | Cantabria, Spain | |||
746638 | 746638 | 2022-04-23 | Spain | Cantabria | 133682 | 801 | 0 | 43.1828 | -3.9878 | 2022-04-24 04:20:56 | Cantabria, Spain | |||
3437123 | 3437123 | 2022-04-22 | Spain | Cantabria | 133682 | 801 | 0 | 43.1828 | -3.9878 | 2022-04-23 04:20:50 | Cantabria, Spain |
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]);