johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
306 rows where deaths = 813 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752977 | 2752977 | 2022-12-29 | Malta | 116320 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-30 04:21:04 | Malta | ||||
1073983 | 1073983 | 2022-12-28 | Malta | 116303 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-29 04:21:01 | Malta | ||||
327980 | 327980 | 2022-12-27 | Malta | 116280 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-28 04:21:04 | Malta | ||||
218053 | 218053 | 2022-12-26 | Malta | 116253 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-27 04:21:07 | Malta | ||||
3222510 | 3222510 | 2022-12-25 | Malta | 116247 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-26 04:21:06 | Malta | ||||
1018424 | 1018424 | 2022-12-24 | Malta | 116231 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-25 04:21:04 | Malta | ||||
690447 | 690447 | 2022-12-23 | Malta | 116212 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-24 04:21:02 | Malta | ||||
3714167 | 3714167 | 2022-12-06 | Japan | Ibaraki | 451681 | 813 | 0 | 36.303588 | 140.319591 | 2022-12-07 04:20:58 | Ibaraki, Japan | |||
487636 | 487636 | 2022-11-25 | Japan | Okinawa | 517232 | 813 | 0 | 25.768923 | 126.668016 | 2022-11-26 04:21:11 | Okinawa, Japan | |||
3523465 | 3523465 | 2022-11-24 | Japan | Okinawa | 516677 | 813 | 0 | 25.768923 | 126.668016 | 2022-11-25 04:21:06 | Okinawa, Japan | |||
3312248 | 3312248 | 2022-11-23 | Japan | Okinawa | 516427 | 813 | 0 | 25.768923 | 126.668016 | 2022-11-24 04:21:09 | Okinawa, Japan | |||
1830915 | 1830915 | 2022-10-25 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-26 04:22:19 | Bibb, Georgia, US | |
795176 | 795176 | 2022-10-24 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-25 04:21:53 | Bibb, Georgia, US | |
3277631 | 3277631 | 2022-10-23 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-24 04:22:29 | Bibb, Georgia, US | |
2268669 | 2268669 | 2022-10-22 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-23 04:22:46 | Bibb, Georgia, US | |
1592969 | 1592969 | 2022-10-21 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-22 04:22:53 | Bibb, Georgia, US | |
2272685 | 2272685 | 2022-10-20 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-21 04:22:23 | Bibb, Georgia, US | |
199020 | 199020 | 2022-10-19 | US | Georgia | Bibb | 13021 | 43180 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-10-20 04:22:59 | Bibb, Georgia, US | |
2020049 | 2020049 | 2022-09-20 | US | Virginia | Chesterfield | 51041 | 90533 | 813 | 0 | 37.37373208 | -77.5868014 | 2022-09-21 04:23:22 | Chesterfield, Virginia, US | |
3573922 | 3573922 | 2022-09-19 | US | Virginia | Chesterfield | 51041 | 90497 | 813 | 0 | 37.37373208 | -77.5868014 | 2022-09-20 04:22:48 | Chesterfield, Virginia, US | |
374870 | 374870 | 2022-09-13 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-14 04:20:44 | Erie, Pennsylvania, US | |
2397472 | 2397472 | 2022-09-12 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-13 04:20:57 | Erie, Pennsylvania, US | |
3768550 | 3768550 | 2022-09-11 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-12 04:20:58 | Erie, Pennsylvania, US | |
3766622 | 3766622 | 2022-09-11 | US | Florida | Unassigned | 90012 | 2962 | 813 | 0 | 30.86747479 | 0.0 | 2022-09-12 04:20:58 | Unassigned, Florida, US | |
3827125 | 3827125 | 2022-09-10 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-11 04:20:50 | Erie, Pennsylvania, US | |
3825197 | 3825197 | 2022-09-10 | US | Florida | Unassigned | 90012 | 2962 | 813 | 0 | 30.86747479 | 0.0 | 2022-09-11 04:20:50 | Unassigned, Florida, US | |
965582 | 965582 | 2022-09-09 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-10 04:21:10 | Erie, Pennsylvania, US | |
963654 | 963654 | 2022-09-09 | US | Florida | Unassigned | 90012 | 2962 | 813 | 0 | 30.86747479 | 0.0 | 2022-09-10 04:21:10 | Unassigned, Florida, US | |
255984 | 255984 | 2022-09-08 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-09 04:21:11 | Erie, Pennsylvania, US | |
3747782 | 3747782 | 2022-09-07 | US | Pennsylvania | Erie | 42049 | 65352 | 813 | 0 | 41.99253829 | -80.03301954 | 2022-09-08 04:21:02 | Erie, Pennsylvania, US | |
115770 | 115770 | 2022-09-06 | US | Illinois | Madison | 17119 | 81057 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-07 04:20:59 | Madison, Illinois, US | |
115510 | 115510 | 2022-09-06 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-07 04:20:59 | Bibb, Georgia, US | |
2634742 | 2634742 | 2022-09-05 | US | Illinois | Madison | 17119 | 80893 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-06 04:21:02 | Madison, Illinois, US | |
2634482 | 2634482 | 2022-09-05 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-06 04:21:02 | Bibb, Georgia, US | |
2988306 | 2988306 | 2022-09-04 | US | Illinois | Madison | 17119 | 80893 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-05 04:21:01 | Madison, Illinois, US | |
2988046 | 2988046 | 2022-09-04 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-05 04:21:01 | Bibb, Georgia, US | |
2713991 | 2713991 | 2022-09-03 | US | Illinois | Madison | 17119 | 80893 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-04 04:21:22 | Madison, Illinois, US | |
2713731 | 2713731 | 2022-09-03 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-04 04:21:22 | Bibb, Georgia, US | |
1394696 | 1394696 | 2022-09-02 | US | Illinois | Madison | 17119 | 80893 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-03 04:21:04 | Madison, Illinois, US | |
1394436 | 1394436 | 2022-09-02 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-03 04:21:04 | Bibb, Georgia, US | |
3548525 | 3548525 | 2022-09-01 | US | Illinois | Madison | 17119 | 80827 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-02 04:21:07 | Madison, Illinois, US | |
3548265 | 3548265 | 2022-09-01 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-02 04:21:07 | Bibb, Georgia, US | |
2344445 | 2344445 | 2022-08-31 | US | Illinois | Madison | 17119 | 80730 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-09-01 04:21:03 | Madison, Illinois, US | |
2344185 | 2344185 | 2022-08-31 | US | Georgia | Bibb | 13021 | 42692 | 813 | 0 | 32.80904227 | -83.70489165 | 2022-09-01 04:21:03 | Bibb, Georgia, US | |
3774925 | 3774925 | 2022-08-30 | US | Illinois | Madison | 17119 | 80628 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-31 04:20:57 | Madison, Illinois, US | |
1681521 | 1681521 | 2022-08-29 | US | Illinois | Madison | 17119 | 80565 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-30 04:21:03 | Madison, Illinois, US | |
1878005 | 1878005 | 2022-08-28 | US | Illinois | Madison | 17119 | 80411 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-29 04:21:06 | Madison, Illinois, US | |
2097132 | 2097132 | 2022-08-27 | US | Illinois | Madison | 17119 | 80411 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-28 04:21:02 | Madison, Illinois, US | |
1532947 | 1532947 | 2022-08-26 | US | Illinois | Madison | 17119 | 80411 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-27 04:20:57 | Madison, Illinois, US | |
2829834 | 2829834 | 2022-08-25 | US | Illinois | Madison | 17119 | 80347 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-26 04:21:02 | Madison, Illinois, US | |
2324367 | 2324367 | 2022-08-24 | US | Illinois | Madison | 17119 | 80270 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-25 04:21:13 | Madison, Illinois, US | |
1251776 | 1251776 | 2022-08-23 | US | Illinois | Madison | 17119 | 80200 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-24 04:20:46 | Madison, Illinois, US | |
2853880 | 2853880 | 2022-08-22 | US | Illinois | Madison | 17119 | 80134 | 813 | 0 | 38.83042506 | -89.90422563 | 2022-08-23 04:20:56 | Madison, Illinois, US | |
993675 | 993675 | 2022-08-16 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-17 04:20:59 | Lackawanna, Pennsylvania, US | |
2496714 | 2496714 | 2022-08-15 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-16 04:20:58 | Lackawanna, Pennsylvania, US | |
3650264 | 3650264 | 2022-08-14 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-15 04:20:59 | Lackawanna, Pennsylvania, US | |
1971270 | 1971270 | 2022-08-13 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-14 04:20:55 | Lackawanna, Pennsylvania, US | |
2891079 | 2891079 | 2022-08-12 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-13 04:20:52 | Lackawanna, Pennsylvania, US | |
3910684 | 3910684 | 2022-08-11 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-12 04:20:54 | Lackawanna, Pennsylvania, US | |
1349001 | 1349001 | 2022-08-10 | US | Pennsylvania | Lackawanna | 42069 | 50427 | 813 | 0 | 41.43564672 | -75.60379201 | 2022-08-11 04:20:49 | Lackawanna, Pennsylvania, US | |
1346175 | 1346175 | 2022-08-10 | Cote d'Ivoire | 85879 | 813 | 0 | 7.54 | -5.5471 | 2022-08-11 04:20:49 | Cote d'Ivoire | ||||
2010902 | 2010902 | 2022-08-04 | US | New Mexico | San Juan | 35045 | 45830 | 813 | 0 | 36.50838318 | -108.320437 | 2022-08-05 04:20:52 | San Juan, New Mexico, US | |
2008587 | 2008587 | 2022-08-04 | Germany | Bremen | 241897 | 813 | 0 | 53.0793 | 8.8017 | 2022-08-05 04:20:52 | Bremen, Germany | |||
1100329 | 1100329 | 2022-08-03 | US | New Mexico | San Juan | 35045 | 45782 | 813 | 0 | 36.50838318 | -108.320437 | 2022-08-04 04:20:58 | San Juan, New Mexico, US | |
1098014 | 1098014 | 2022-08-03 | Germany | Bremen | 241199 | 813 | 0 | 53.0793 | 8.8017 | 2022-08-04 04:20:58 | Bremen, Germany | |||
1407254 | 1407254 | 2022-08-02 | US | New Mexico | San Juan | 35045 | 45720 | 813 | 0 | 36.50838318 | -108.320437 | 2022-08-03 04:20:59 | San Juan, New Mexico, US | |
1404939 | 1404939 | 2022-08-02 | Germany | Bremen | 240350 | 813 | 0 | 53.0793 | 8.8017 | 2022-08-03 04:20:59 | Bremen, Germany | |||
3619292 | 3619292 | 2022-08-01 | US | New Mexico | San Juan | 35045 | 45667 | 813 | 0 | 36.50838318 | -108.320437 | 2022-08-02 04:20:53 | San Juan, New Mexico, US | |
3616977 | 3616977 | 2022-08-01 | Germany | Bremen | 239684 | 813 | 0 | 53.0793 | 8.8017 | 2022-08-02 04:20:53 | Bremen, Germany | |||
2337095 | 2337095 | 2022-07-27 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-28 04:20:56 | Anoka, Minnesota, US | |
1489285 | 1489285 | 2022-07-26 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-27 04:21:04 | Anoka, Minnesota, US | |
2595731 | 2595731 | 2022-07-25 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-26 04:20:58 | Anoka, Minnesota, US | |
897846 | 897846 | 2022-07-24 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-25 04:20:51 | Anoka, Minnesota, US | |
92840 | 92840 | 2022-07-23 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-24 04:20:47 | Anoka, Minnesota, US | |
901862 | 901862 | 2022-07-22 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-23 04:20:53 | Anoka, Minnesota, US | |
671998 | 671998 | 2022-07-21 | US | Minnesota | Anoka | 27003 | 106864 | 813 | 0 | 45.27476015 | -93.24604565 | 2022-07-22 04:21:15 | Anoka, Minnesota, US | |
3211964 | 3211964 | 2022-07-18 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-19 04:20:58 | Ottawa, Michigan, US | |
3407139 | 3407139 | 2022-07-17 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-18 04:20:59 | Ottawa, Michigan, US | |
2153339 | 2153339 | 2022-07-16 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-17 04:21:15 | Ottawa, Michigan, US | |
2420572 | 2420572 | 2022-07-15 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-16 04:21:05 | Ottawa, Michigan, US | |
3430647 | 3430647 | 2022-07-14 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-15 04:20:53 | Ottawa, Michigan, US | |
3111167 | 3111167 | 2022-07-13 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-14 04:20:57 | Ottawa, Michigan, US | |
631590 | 631590 | 2022-07-12 | US | Michigan | Ottawa | 26139 | 79787 | 813 | 0 | 42.95996803 | -85.9969107 | 2022-07-13 04:20:58 | Ottawa, Michigan, US | |
165812 | 165812 | 2022-06-21 | Chile | Arica y Parinacota | 57702 | 813 | 0 | -18.594 | -69.4785 | 2022-06-22 04:20:54 | Arica y Parinacota, Chile | |||
1763095 | 1763095 | 2022-06-20 | Chile | Arica y Parinacota | 57647 | 813 | 0 | -18.594 | -69.4785 | 2022-06-21 04:20:56 | Arica y Parinacota, Chile | |||
3269281 | 3269281 | 2022-06-19 | Chile | Arica y Parinacota | 57583 | 813 | 0 | -18.594 | -69.4785 | 2022-06-20 04:21:01 | Arica y Parinacota, Chile | |||
3397193 | 3397193 | 2022-06-18 | Chile | Arica y Parinacota | 57423 | 813 | 0 | -18.594 | -69.4785 | 2022-06-19 04:20:51 | Arica y Parinacota, Chile | |||
2311070 | 2311070 | 2022-06-17 | Chile | Arica y Parinacota | 57319 | 813 | 0 | -18.594 | -69.4785 | 2022-06-18 04:21:10 | Arica y Parinacota, Chile | |||
558574 | 558574 | 2022-06-16 | Chile | Arica y Parinacota | 57198 | 813 | 0 | -18.594 | -69.4785 | 2022-06-17 04:20:56 | Arica y Parinacota, Chile | |||
3983260 | 3983260 | 2022-06-15 | US | Colorado | Pueblo | 8101 | 51039 | 813 | 0 | 38.17359144 | -104.5127437 | 2022-06-16 04:20:55 | Pueblo, Colorado, US | |
3982376 | 3982376 | 2022-06-15 | Chile | Arica y Parinacota | 57104 | 813 | 0 | -18.594 | -69.4785 | 2022-06-16 04:20:55 | Arica y Parinacota, Chile | |||
947501 | 947501 | 2022-06-14 | US | Colorado | Pueblo | 8101 | 50952 | 813 | 0 | 38.17359144 | -104.5127437 | 2022-06-15 04:20:54 | Pueblo, Colorado, US | |
946617 | 946617 | 2022-06-14 | Chile | Arica y Parinacota | 57021 | 813 | 0 | -18.594 | -69.4785 | 2022-06-15 04:20:54 | Arica y Parinacota, Chile | |||
2979025 | 2979025 | 2022-06-13 | Chile | Arica y Parinacota | 56975 | 813 | 0 | -18.594 | -69.4785 | 2022-06-14 04:20:52 | Arica y Parinacota, Chile | |||
2235151 | 2235151 | 2022-06-12 | Chile | Arica y Parinacota | 56926 | 813 | 0 | -18.594 | -69.4785 | 2022-06-13 04:21:14 | Arica y Parinacota, Chile | |||
3141349 | 3141349 | 2022-06-11 | Chile | Arica y Parinacota | 56866 | 813 | 0 | -18.594 | -69.4785 | 2022-06-12 04:20:53 | Arica y Parinacota, Chile | |||
1944265 | 1944265 | 2022-06-10 | Chile | Arica y Parinacota | 56808 | 813 | 0 | -18.594 | -69.4785 | 2022-06-11 04:21:01 | Arica y Parinacota, Chile | |||
3157404 | 3157404 | 2022-06-09 | Chile | Arica y Parinacota | 56723 | 813 | 0 | -18.594 | -69.4785 | 2022-06-10 04:20:55 | Arica y Parinacota, Chile | |||
1420871 | 1420871 | 2022-06-08 | Chile | Arica y Parinacota | 56696 | 813 | 0 | -18.594 | -69.4785 | 2022-06-09 04:20:54 | Arica y Parinacota, Chile | |||
3725985 | 3725985 | 2022-06-07 | Chile | Arica y Parinacota | 56639 | 813 | 0 | -18.594 | -69.4785 | 2022-06-08 04:20:55 | Arica y Parinacota, Chile |
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]);