johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
135 rows where deaths = 1509 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755618 | 2755618 | 2022-12-29 | US | Pennsylvania | Westmoreland | 42129 | 96702 | 1509 | 0 | 40.3137798 | -79.46615476 | 2022-12-30 04:21:04 | Westmoreland, Pennsylvania, US | |
1076624 | 1076624 | 2022-12-28 | US | Pennsylvania | Westmoreland | 42129 | 96702 | 1509 | 0 | 40.3137798 | -79.46615476 | 2022-12-29 04:21:01 | Westmoreland, Pennsylvania, US | |
1239885 | 1239885 | 2022-11-28 | Russia | Kurgan Oblast | 122439 | 1509 | 0 | 55.7655302 | 64.5632681 | 2022-11-29 04:21:05 | Kurgan Oblast, Russia | |||
3551873 | 3551873 | 2022-11-27 | Russia | Kurgan Oblast | 122395 | 1509 | 0 | 55.7655302 | 64.5632681 | 2022-11-28 04:21:02 | Kurgan Oblast, Russia | |||
2100353 | 2100353 | 2022-11-26 | Russia | Kurgan Oblast | 122347 | 1509 | 0 | 55.7655302 | 64.5632681 | 2022-11-27 04:21:05 | Kurgan Oblast, Russia | |||
487844 | 487844 | 2022-11-25 | Russia | Kurgan Oblast | 122297 | 1509 | 0 | 55.7655302 | 64.5632681 | 2022-11-26 04:21:11 | Kurgan Oblast, Russia | |||
1813740 | 1813740 | 2022-10-05 | US | Tennessee | Knox | 47093 | 149217 | 1509 | 0 | 35.99508821 | -83.94635435 | 2022-10-06 04:21:22 | Knox, Tennessee, US | |
133714 | 133714 | 2022-10-04 | US | Tennessee | Knox | 47093 | 149137 | 1509 | 0 | 35.99508821 | -83.94635435 | 2022-10-05 04:23:06 | Knox, Tennessee, US | |
2688661 | 2688661 | 2022-10-03 | US | Tennessee | Knox | 47093 | 149090 | 1509 | 0 | 35.99508821 | -83.94635435 | 2022-10-04 04:22:55 | Knox, Tennessee, US | |
2685755 | 2685755 | 2022-10-03 | Malaysia | Negeri Sembilan | 222443 | 1509 | 0 | 2.7258 | 101.9424 | 2022-10-04 04:22:55 | Negeri Sembilan, Malaysia | |||
2259822 | 2259822 | 2022-10-02 | Malaysia | Negeri Sembilan | 222443 | 1509 | 0 | 2.7258 | 101.9424 | 2022-10-03 04:23:11 | Negeri Sembilan, Malaysia | |||
2995348 | 2995348 | 2022-10-01 | Malaysia | Negeri Sembilan | 222443 | 1509 | 0 | 2.7258 | 101.9424 | 2022-10-02 04:21:23 | Negeri Sembilan, Malaysia | |||
853674 | 853674 | 2022-09-30 | Malaysia | Negeri Sembilan | 222176 | 1509 | 0 | 2.7258 | 101.9424 | 2022-10-01 04:23:01 | Negeri Sembilan, Malaysia | |||
2375600 | 2375600 | 2022-09-29 | Malaysia | Negeri Sembilan | 222054 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-30 04:23:09 | Negeri Sembilan, Malaysia | |||
1560151 | 1560151 | 2022-09-28 | Malaysia | Negeri Sembilan | 221975 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-29 04:22:34 | Negeri Sembilan, Malaysia | |||
3994694 | 3994694 | 2022-09-27 | Malaysia | Negeri Sembilan | 221856 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-28 04:23:01 | Negeri Sembilan, Malaysia | |||
2769022 | 2769022 | 2022-09-26 | Malaysia | Negeri Sembilan | 221788 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-27 04:23:01 | Negeri Sembilan, Malaysia | |||
1976675 | 1976675 | 2022-09-25 | Malaysia | Negeri Sembilan | 221698 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-26 04:20:52 | Negeri Sembilan, Malaysia | |||
2649842 | 2649842 | 2022-09-24 | Malaysia | Negeri Sembilan | 221619 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-25 04:23:31 | Negeri Sembilan, Malaysia | |||
384282 | 384282 | 2022-09-23 | Malaysia | Negeri Sembilan | 221539 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-24 04:21:40 | Negeri Sembilan, Malaysia | |||
1624348 | 1624348 | 2022-09-22 | Malaysia | Negeri Sembilan | 221422 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-23 04:23:13 | Negeri Sembilan, Malaysia | |||
1370552 | 1370552 | 2022-09-21 | Malaysia | Negeri Sembilan | 221285 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-22 04:22:56 | Negeri Sembilan, Malaysia | |||
2020184 | 2020184 | 2022-09-20 | US | Washington | Pierce | 53053 | 228107 | 1509 | 0 | 47.03892768 | -122.1405958 | 2022-09-21 04:23:22 | Pierce, Washington, US | |
2016782 | 2016782 | 2022-09-20 | Malaysia | Negeri Sembilan | 221193 | 1509 | 0 | 2.7258 | 101.9424 | 2022-09-21 04:23:22 | Negeri Sembilan, Malaysia | |||
3574057 | 3574057 | 2022-09-19 | US | Washington | Pierce | 53053 | 228107 | 1509 | 0 | 47.03892768 | -122.1405958 | 2022-09-20 04:22:48 | Pierce, Washington, US | |
1405017 | 1405017 | 2022-08-02 | Italy | P.A. Bolzano | 247842 | 1509 | 0 | 46.49933453 | 11.35662422 | 2022-08-03 04:20:59 | P.A. Bolzano, Italy | |||
3617055 | 3617055 | 2022-08-01 | Italy | P.A. Bolzano | 247126 | 1509 | 0 | 46.49933453 | 11.35662422 | 2022-08-02 04:20:53 | P.A. Bolzano, Italy | |||
3616772 | 3616772 | 2022-08-01 | Bahrain | 660152 | 1509 | 0 | 26.0275 | 50.55 | 2022-08-02 04:20:53 | Bahrain | ||||
3871252 | 3871252 | 2022-07-31 | Bahrain | 659647 | 1509 | 0 | 26.0275 | 50.55 | 2022-08-01 04:21:03 | Bahrain | ||||
674006 | 674006 | 2022-07-30 | Bahrain | 659224 | 1509 | 0 | 26.0275 | 50.55 | 2022-07-31 04:21:02 | Bahrain | ||||
1783205 | 1783205 | 2022-07-29 | Bahrain | 658727 | 1509 | 0 | 26.0275 | 50.55 | 2022-07-30 04:20:42 | Bahrain | ||||
1065568 | 1065568 | 2022-07-28 | Bahrain | 658238 | 1509 | 0 | 26.0275 | 50.55 | 2022-07-29 04:20:45 | Bahrain | ||||
2335087 | 2335087 | 2022-07-27 | Bahrain | 657669 | 1509 | 0 | 26.0275 | 50.55 | 2022-07-28 04:20:56 | Bahrain | ||||
1214742 | 1214742 | 2022-07-11 | US | Texas | Nueces | 48355 | 106376 | 1509 | 0 | 27.736286 | -97.5433285 | 2022-07-12 04:20:51 | Nueces, Texas, US | |
2792224 | 2792224 | 2022-07-10 | US | Texas | Nueces | 48355 | 105832 | 1509 | 0 | 27.736286 | -97.5433285 | 2022-07-11 04:20:46 | Nueces, Texas, US | |
145177 | 145177 | 2022-07-09 | US | Texas | Nueces | 48355 | 105832 | 1509 | 0 | 27.736286 | -97.5433285 | 2022-07-10 04:20:54 | Nueces, Texas, US | |
1420277 | 1420277 | 2022-07-08 | US | Texas | Nueces | 48355 | 105832 | 1509 | 0 | 27.736286 | -97.5433285 | 2022-07-09 04:20:59 | Nueces, Texas, US | |
1424158 | 1424158 | 2022-06-08 | US | Texas | Collin | 48085 | 221107 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-06-09 04:20:54 | Collin, Texas, US | |
3189046 | 3189046 | 2022-05-30 | US | Texas | Collin | 48085 | 218173 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-31 04:20:51 | Collin, Texas, US | |
3201195 | 3201195 | 2022-05-29 | US | Texas | Collin | 48085 | 218173 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-30 04:20:50 | Collin, Texas, US | |
2728073 | 2728073 | 2022-05-28 | US | Texas | Collin | 48085 | 218173 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-29 04:20:53 | Collin, Texas, US | |
2725230 | 2725230 | 2022-05-28 | Russia | Karelia Republic | 135528 | 1509 | 0 | 62.6194031 | 33.4920267 | 2022-05-29 04:20:53 | Karelia Republic, Russia | |||
1317254 | 1317254 | 2022-05-27 | US | Texas | Collin | 48085 | 218173 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-28 04:21:07 | Collin, Texas, US | |
1314411 | 1314411 | 2022-05-27 | Russia | Karelia Republic | 135469 | 1509 | 0 | 62.6194031 | 33.4920267 | 2022-05-28 04:21:07 | Karelia Republic, Russia | |||
1853046 | 1853046 | 2022-05-26 | US | Texas | Collin | 48085 | 217968 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-27 04:20:56 | Collin, Texas, US | |
2050922 | 2050922 | 2022-05-25 | US | Texas | Collin | 48085 | 217717 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-26 04:20:50 | Collin, Texas, US | |
3002360 | 3002360 | 2022-05-24 | US | Texas | Collin | 48085 | 217571 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-25 04:20:56 | Collin, Texas, US | |
3596081 | 3596081 | 2022-05-23 | US | Texas | Collin | 48085 | 217428 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-24 04:20:57 | Collin, Texas, US | |
624933 | 624933 | 2022-05-22 | US | Texas | Collin | 48085 | 217717 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-26 04:20:50 | Collin, Texas, US | |
1112629 | 1112629 | 2022-05-21 | US | Texas | Collin | 48085 | 217037 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-22 04:20:52 | Collin, Texas, US | |
1172253 | 1172253 | 2022-05-20 | US | Texas | Collin | 48085 | 216841 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-21 04:20:58 | Collin, Texas, US | |
3899016 | 3899016 | 2022-05-19 | US | Texas | Collin | 48085 | 216649 | 1509 | 0 | 33.18820114 | -96.57264368 | 2022-05-20 04:20:57 | Collin, Texas, US | |
2533417 | 2533417 | 2022-05-12 | Japan | Saitama | 528438 | 1509 | 0 | 35.997101 | 139.347635 | 2022-05-13 04:20:51 | Saitama, Japan | |||
3023336 | 3023336 | 2022-03-23 | US | Illinois | Will | 17197 | 161121 | 1509 | 0 | 41.44619267 | -87.97862712 | 2022-03-24 04:20:43 | Will, Illinois, US | |
1906258 | 1906258 | 2022-03-22 | US | Illinois | Will | 17197 | 161065 | 1509 | 0 | 41.44619267 | -87.97862712 | 2022-03-23 04:20:48 | Will, Illinois, US | |
1646965 | 1646965 | 2022-03-03 | US | Oklahoma | Unassigned | 90040 | 1905 | 1509 | 0 | 36.83532655 | 0.0 | 2022-03-04 04:21:09 | Unassigned, Oklahoma, US | |
2735202 | 2735202 | 2022-02-27 | US | New Jersey | Morris | 34027 | 116222 | 1509 | 0 | 40.86095313 | -74.54553709999998 | 2022-02-28 04:21:05 | Morris, New Jersey, US | |
3046012 | 3046012 | 2022-02-26 | Colombia | La Guajira | 56039 | 1509 | 0 | 11.3548 | -72.5205 | 2022-02-27 04:21:04 | La Guajira, Colombia | |||
2330014 | 2330014 | 2022-02-04 | US | Pennsylvania | Berks | 42011 | 99736 | 1509 | 0 | 40.41570541 | -75.92457766 | 2022-02-05 04:21:05 | Berks, Pennsylvania, US | |
1779329 | 1779329 | 2022-01-27 | India | Meghalaya | 89841 | 1509 | 0 | 25.536934 | 91.278882 | 2022-01-28 04:21:09 | Meghalaya, India | |||
3616302 | 3616302 | 2022-01-12 | US | Texas | Travis | 48453 | 170358 | 1509 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-13 08:00:09 | Travis, Texas, US | |
1116827 | 1116827 | 2022-01-11 | US | Texas | Travis | 48453 | 168001 | 1509 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-12 04:21:44 | Travis, Texas, US | |
1695555 | 1695555 | 2022-01-10 | US | Texas | Travis | 48453 | 165834 | 1509 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-11 04:22:01 | Travis, Texas, US | |
129970 | 129970 | 2022-01-09 | US | Texas | Travis | 48453 | 163769 | 1509 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-10 04:22:07 | Travis, Texas, US | |
1218805 | 1218805 | 2022-01-08 | US | Texas | Travis | 48453 | 161797 | 1509 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-09 04:21:46 | Travis, Texas, US | |
2776766 | 2776766 | 2021-12-31 | Chile | Los Lagos | 99380 | 1509 | 0 | -41.9198 | -72.1416 | 2022-01-01 04:22:14 | Los Lagos, Chile | |||
800597 | 800597 | 2021-12-22 | US | New Jersey | Camden | 34007 | 78399 | 1509 | 0 | 39.80343818 | -74.96388753 | 2021-12-23 04:21:21 | Camden, New Jersey, US | |
2090627 | 2090627 | 2021-12-14 | US | Pennsylvania | Bucks | 42017 | 83414 | 1509 | 0 | 40.33682119 | -75.10836643 | 2021-12-15 03:22:16 | Bucks, Pennsylvania, US | |
1030340 | 1030340 | 2021-12-06 | Italy | Calabria | 94799 | 1509 | 0 | 38.90597598 | 16.59440194 | 2021-12-07 04:22:34 | Calabria, Italy | |||
1231822 | 1231822 | 2021-11-28 | Russia | Belgorod Oblast | 72159 | 1509 | 0 | 50.7080119 | 37.5837615 | 2021-11-29 04:22:30 | Belgorod Oblast, Russia | |||
3751949 | 3751949 | 2021-11-22 | US | South Carolina | Greenville | 45045 | 107169 | 1509 | 0 | 34.89502264 | -82.37295012 | 2021-11-23 04:22:39 | Greenville, South Carolina, US | |
3124174 | 3124174 | 2021-11-05 | US | Pennsylvania | Delaware | 42045 | 63317 | 1509 | 0 | 39.91680171 | -75.40243663 | 2021-11-06 04:21:51 | Delaware, Pennsylvania, US | |
701072 | 701072 | 2021-11-04 | US | Pennsylvania | Delaware | 42045 | 63219 | 1509 | 0 | 39.91680171 | -75.40243663 | 2021-11-05 04:21:54 | Delaware, Pennsylvania, US | |
1493198 | 1493198 | 2021-10-12 | US | Massachusetts | Bristol | 25005 | 79090 | 1509 | 0 | 41.79228404 | -71.10872211 | 2021-10-13 04:20:51 | Bristol, Massachusetts, US | |
1724265 | 1724265 | 2021-09-25 | Chile | Araucania | 98218 | 1509 | 0 | -38.9489 | -72.3311 | 2021-09-26 04:21:29 | Araucania, Chile | |||
1920985 | 1920985 | 2021-09-24 | Chile | Araucania | 98199 | 1509 | 0 | -38.9489 | -72.3311 | 2021-09-25 04:21:31 | Araucania, Chile | |||
601456 | 601456 | 2021-09-23 | Chile | Araucania | 98177 | 1509 | 0 | -38.9489 | -72.3311 | 2021-09-24 04:21:44 | Araucania, Chile | |||
1385473 | 1385473 | 2021-09-13 | Colombia | Cauca | 55445 | 1509 | 0 | 2.705 | -76.82600000000002 | 2021-09-14 04:21:41 | Cauca, Colombia | |||
1884842 | 1884842 | 2021-09-12 | Colombia | Cauca | 55428 | 1509 | 0 | 2.705 | -76.82600000000002 | 2021-09-13 04:21:15 | Cauca, Colombia | |||
3805745 | 3805745 | 2021-09-11 | Colombia | Cauca | 55387 | 1509 | 0 | 2.705 | -76.82600000000002 | 2021-09-12 04:21:13 | Cauca, Colombia | |||
1266471 | 1266471 | 2021-09-09 | Malaysia | Sabah | 167738 | 1509 | 141157 | 25072 | 5.9788 | 116.0753 | 2021-09-10 04:21:20 | Sabah, Malaysia | ||
32671 | 32671 | 2021-08-25 | Russia | Tver Oblast | 59465 | 1509 | 0 | 57.1134475 | 35.174442799999994 | 2021-08-26 04:21:28 | Tver Oblast, Russia | |||
1604494 | 1604494 | 2021-08-16 | Russia | Vologda Oblast | 58389 | 1509 | 0 | 60.0391461 | 43.1215213 | 2021-08-17 04:21:49 | Vologda Oblast, Russia | |||
507478 | 507478 | 2021-08-14 | Chile | OHiggins | 67786 | 1509 | 0 | -34.5755 | -71.0022 | 2021-08-15 04:21:41 | OHiggins, Chile | |||
3220758 | 3220758 | 2021-07-26 | US | Ohio | Franklin | 39049 | 130291 | 1509 | 0 | 39.96995815 | -83.01115755 | 2021-07-27 04:21:18 | Franklin, Ohio, US | |
1380967 | 1380967 | 2021-07-25 | US | Ohio | Franklin | 39049 | 130214 | 1509 | 0 | 39.96995815 | -83.01115755 | 2021-07-26 04:21:28 | Franklin, Ohio, US | |
1332707 | 1332707 | 2021-07-24 | US | Ohio | Franklin | 39049 | 130169 | 1509 | 0 | 39.96995815 | -83.01115755 | 2021-07-25 04:22:12 | Franklin, Ohio, US | |
3140011 | 3140011 | 2021-07-23 | US | Ohio | Franklin | 39049 | 130071 | 1509 | 0 | 39.96995815 | -83.01115755 | 2021-07-24 00:21:36 | Franklin, Ohio, US | |
3478771 | 3478771 | 2021-07-22 | US | Ohio | Franklin | 39049 | 129993 | 1509 | 0 | 39.96995815 | -83.01115755 | 2021-07-23 04:21:29 | Franklin, Ohio, US | |
483450 | 483450 | 2021-07-19 | Colombia | Sucre | 55191 | 1509 | 52494 | 1188 | 8.814 | -74.7233 | 2021-07-20 04:21:48 | Sucre, Colombia | ||
3473896 | 3473896 | 2021-06-08 | US | Massachusetts | Suffolk | 25025 | 92925 | 1509 | 0 | 42.3279514 | -71.07850442 | 2021-06-09 04:23:31 | Suffolk, Massachusetts, US | |
3147180 | 3147180 | 2021-06-07 | US | Massachusetts | Suffolk | 25025 | 92917 | 1509 | 0 | 42.3279514 | -71.07850442 | 2021-06-08 04:22:35 | Suffolk, Massachusetts, US | |
827182 | 827182 | 2021-06-06 | US | Massachusetts | Suffolk | 25025 | 92894 | 1509 | 0 | 42.3279514 | -71.07850442 | 2021-06-07 04:22:51 | Suffolk, Massachusetts, US | |
2587587 | 2587587 | 2021-06-05 | US | Massachusetts | Suffolk | 25025 | 92866 | 1509 | 0 | 42.3279514 | -71.07850442 | 2021-06-06 04:24:03 | Suffolk, Massachusetts, US | |
3054383 | 3054383 | 2021-05-13 | Russia | Chelyabinsk Oblast | 60206 | 1509 | 55868 | 2829 | 54.4223954 | 61.1865846 | 2021-05-14 04:20:41 | Chelyabinsk Oblast, Russia | ||
645864 | 645864 | 2021-05-05 | Germany | Hamburg | 72828 | 1509 | 65070 | 6475 | 53.5511 | 9.9937 | 2021-05-06 04:20:38 | Hamburg, Germany | ||
3397035 | 3397035 | 2021-04-28 | Ukraine | Zakarpattia Oblast | 59795 | 1509 | 52820 | 5466 | 48.6208 | 22.2879 | 2021-04-29 04:20:55 | Zakarpattia Oblast, Ukraine | ||
40048 | 40048 | 2021-04-12 | Ukraine | Chernivtsi Oblast | 73864 | 1509 | 53504 | 18851 | 48.2917 | 25.9352 | 2021-04-13 04:20:37 | Chernivtsi Oblast, Ukraine | ||
3003360 | 3003360 | 2021-04-06 | Kyrgyzstan | 89277 | 1509 | 85388 | 2380 | 41.20438 | 74.766098 | 2021-04-07 04:20:53 | Kyrgyzstan | |||
3087468 | 3087468 | 2021-04-05 | US | New Jersey | Monmouth | 34025 | 69492 | 1509 | 0 | 40.26549699 | -74.22240686 | 2021-04-06 04:20:32 | Monmouth, New Jersey, 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]);