johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
800 rows where deaths = 411 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753917 | 2753917 | 2022-12-29 | US | Illinois | LaSalle | 17099 | 36068 | 411 | 0 | 41.3442613 | -88.88633881 | 2022-12-30 04:21:04 | LaSalle, Illinois, US | |
2753817 | 2753817 | 2022-12-29 | US | Guam | 66 | 59951 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-30 04:21:04 | Guam, US | ||
2752780 | 2752780 | 2022-12-29 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-30 04:21:04 | French Guiana, France | |||
1074923 | 1074923 | 2022-12-28 | US | Illinois | LaSalle | 17099 | 36037 | 411 | 0 | 41.3442613 | -88.88633881 | 2022-12-29 04:21:01 | LaSalle, Illinois, US | |
1074823 | 1074823 | 2022-12-28 | US | Guam | 66 | 59926 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-29 04:21:01 | Guam, US | ||
1074231 | 1074231 | 2022-12-28 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-29 04:21:01 | Kalmar, Sweden | |||
1073898 | 1073898 | 2022-12-28 | Japan | Ehime | 246076 | 411 | 0 | 33.624835 | 132.856842 | 2022-12-29 04:21:01 | Ehime, Japan | |||
1073786 | 1073786 | 2022-12-28 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-29 04:21:01 | French Guiana, France | |||
328820 | 328820 | 2022-12-27 | US | Guam | 66 | 59876 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-28 04:21:04 | Guam, US | ||
328228 | 328228 | 2022-12-27 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-28 04:21:04 | Kalmar, Sweden | |||
327783 | 327783 | 2022-12-27 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-28 04:21:04 | French Guiana, France | |||
218893 | 218893 | 2022-12-26 | US | Guam | 66 | 59827 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-27 04:21:07 | Guam, US | ||
218301 | 218301 | 2022-12-26 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-27 04:21:07 | Kalmar, Sweden | |||
217856 | 217856 | 2022-12-26 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-27 04:21:07 | French Guiana, France | |||
3223350 | 3223350 | 2022-12-25 | US | Guam | 66 | 59827 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-26 04:21:06 | Guam, US | ||
3222758 | 3222758 | 2022-12-25 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-26 04:21:06 | Kalmar, Sweden | |||
3222313 | 3222313 | 2022-12-25 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-26 04:21:06 | French Guiana, France | |||
1019264 | 1019264 | 2022-12-24 | US | Guam | 66 | 59827 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-25 04:21:04 | Guam, US | ||
1018672 | 1018672 | 2022-12-24 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-25 04:21:04 | Kalmar, Sweden | |||
1018227 | 1018227 | 2022-12-24 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-25 04:21:04 | French Guiana, France | |||
691287 | 691287 | 2022-12-23 | US | Guam | 66 | 59827 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-24 04:21:02 | Guam, US | ||
690695 | 690695 | 2022-12-23 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-24 04:21:02 | Kalmar, Sweden | |||
690250 | 690250 | 2022-12-23 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-24 04:21:02 | French Guiana, France | |||
2180497 | 2180497 | 2022-12-22 | US | Guam | 66 | 59758 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-23 04:21:04 | Guam, US | ||
2179905 | 2179905 | 2022-12-22 | Sweden | Kalmar | 64518 | 411 | 0 | 57.235 | 16.1849 | 2022-12-23 04:21:04 | Kalmar, Sweden | |||
2179460 | 2179460 | 2022-12-22 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-23 04:21:04 | French Guiana, France | |||
452301 | 452301 | 2022-12-21 | US | Guam | 66 | 59758 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-22 04:20:56 | Guam, US | ||
451264 | 451264 | 2022-12-21 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-22 04:20:56 | French Guiana, France | |||
2954547 | 2954547 | 2022-12-20 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-21 04:21:03 | Liberty, Texas, US | |
2952300 | 2952300 | 2022-12-20 | US | Guam | 66 | 59735 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-21 04:21:03 | Guam, US | ||
2951263 | 2951263 | 2022-12-20 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-21 04:21:03 | French Guiana, France | |||
3176949 | 3176949 | 2022-12-19 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-20 04:21:04 | Liberty, Texas, US | |
3174702 | 3174702 | 2022-12-19 | US | Guam | 66 | 59709 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-20 04:21:04 | Guam, US | ||
3173665 | 3173665 | 2022-12-19 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-20 04:21:04 | French Guiana, France | |||
1631466 | 1631466 | 2022-12-18 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-19 04:21:03 | Liberty, Texas, US | |
1629219 | 1629219 | 2022-12-18 | US | Guam | 66 | 59677 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-19 04:21:03 | Guam, US | ||
1628182 | 1628182 | 2022-12-18 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-19 04:21:03 | French Guiana, France | |||
506845 | 506845 | 2022-12-17 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-18 04:21:03 | Liberty, Texas, US | |
504598 | 504598 | 2022-12-17 | US | Guam | 66 | 59677 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-18 04:21:03 | Guam, US | ||
503561 | 503561 | 2022-12-17 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-18 04:21:03 | French Guiana, France | |||
3327417 | 3327417 | 2022-12-16 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-17 04:21:04 | Liberty, Texas, US | |
3325170 | 3325170 | 2022-12-16 | US | Guam | 66 | 59677 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-17 04:21:04 | Guam, US | ||
3324133 | 3324133 | 2022-12-16 | France | French Guiana | 97526 | 411 | 0 | 4.0 | -53.0 | 2022-12-17 04:21:04 | French Guiana, France | |||
545929 | 545929 | 2022-12-15 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-16 04:21:01 | Liberty, Texas, US | |
542645 | 542645 | 2022-12-15 | France | French Guiana | 97097 | 411 | 0 | 4.0 | -53.0 | 2022-12-16 04:21:01 | French Guiana, France | |||
351457 | 351457 | 2022-12-14 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-15 04:20:58 | Liberty, Texas, US | |
348173 | 348173 | 2022-12-14 | France | French Guiana | 97097 | 411 | 0 | 4.0 | -53.0 | 2022-12-15 04:20:58 | French Guiana, France | |||
311045 | 311045 | 2022-12-13 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-14 04:21:04 | Liberty, Texas, US | |
307761 | 307761 | 2022-12-13 | France | French Guiana | 97097 | 411 | 0 | 4.0 | -53.0 | 2022-12-14 04:21:04 | French Guiana, France | |||
1152106 | 1152106 | 2022-12-12 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-13 04:21:01 | Liberty, Texas, US | |
1148822 | 1148822 | 2022-12-12 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-13 04:21:01 | French Guiana, France | |||
871960 | 871960 | 2022-12-11 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-12 04:21:01 | Liberty, Texas, US | |
868676 | 868676 | 2022-12-11 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-12 04:21:01 | French Guiana, France | |||
260490 | 260490 | 2022-12-10 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-11 04:20:50 | Liberty, Texas, US | |
257206 | 257206 | 2022-12-10 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-11 04:20:50 | French Guiana, France | |||
3939204 | 3939204 | 2022-12-09 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-10 04:21:02 | Liberty, Texas, US | |
3936052 | 3936052 | 2022-12-09 | Japan | Miyazaki | 222601 | 411 | 0 | 32.193204 | 131.299374 | 2022-12-10 04:21:02 | Miyazaki, Japan | |||
3935920 | 3935920 | 2022-12-09 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-10 04:21:02 | French Guiana, France | |||
3380536 | 3380536 | 2022-12-08 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-09 04:21:05 | Liberty, Texas, US | |
3377252 | 3377252 | 2022-12-08 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-09 04:21:05 | French Guiana, France | |||
1987807 | 1987807 | 2022-12-07 | US | Texas | Liberty | 48291 | 21455 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-08 04:21:07 | Liberty, Texas, US | |
1984523 | 1984523 | 2022-12-07 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-08 04:21:07 | French Guiana, France | |||
3717330 | 3717330 | 2022-12-06 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-07 04:20:58 | Liberty, Texas, US | |
3714556 | 3714556 | 2022-12-06 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-07 04:20:58 | Lauderdale, Alabama, US | |
3714046 | 3714046 | 2022-12-06 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-07 04:20:58 | French Guiana, France | |||
2418035 | 2418035 | 2022-12-05 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-06 04:21:03 | Liberty, Texas, US | |
2415261 | 2415261 | 2022-12-05 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-06 04:21:03 | Lauderdale, Alabama, US | |
2414751 | 2414751 | 2022-12-05 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-06 04:21:03 | French Guiana, France | |||
721643 | 721643 | 2022-12-04 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-05 04:20:58 | Liberty, Texas, US | |
718869 | 718869 | 2022-12-04 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-05 04:20:58 | Lauderdale, Alabama, US | |
718359 | 718359 | 2022-12-04 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-05 04:20:58 | French Guiana, France | |||
2819932 | 2819932 | 2022-12-03 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-04 04:20:56 | Liberty, Texas, US | |
2817158 | 2817158 | 2022-12-03 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-04 04:20:56 | Lauderdale, Alabama, US | |
2816648 | 2816648 | 2022-12-03 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-04 04:20:56 | French Guiana, France | |||
836788 | 836788 | 2022-12-02 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-03 04:21:02 | Liberty, Texas, US | |
834014 | 834014 | 2022-12-02 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-03 04:21:02 | Lauderdale, Alabama, US | |
833504 | 833504 | 2022-12-02 | France | French Guiana | 96389 | 411 | 0 | 4.0 | -53.0 | 2022-12-03 04:21:02 | French Guiana, France | |||
2139318 | 2139318 | 2022-12-01 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-02 04:21:07 | Liberty, Texas, US | |
2136544 | 2136544 | 2022-12-01 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-02 04:21:07 | Lauderdale, Alabama, US | |
2136034 | 2136034 | 2022-12-01 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-12-02 04:21:07 | French Guiana, France | |||
1967734 | 1967734 | 2022-11-30 | US | Texas | Liberty | 48291 | 21402 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-01 04:21:03 | Liberty, Texas, US | |
1964960 | 1964960 | 2022-11-30 | US | Alabama | Lauderdale | 1077 | 28777 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-12-01 04:21:03 | Lauderdale, Alabama, US | |
1964450 | 1964450 | 2022-11-30 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-12-01 04:21:03 | French Guiana, France | |||
2559748 | 2559748 | 2022-11-29 | US | Texas | Liberty | 48291 | 21380 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-30 04:21:07 | Liberty, Texas, US | |
2556974 | 2556974 | 2022-11-29 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-30 04:21:07 | Lauderdale, Alabama, US | |
2556464 | 2556464 | 2022-11-29 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-11-30 04:21:07 | French Guiana, France | |||
1242822 | 1242822 | 2022-11-28 | US | Texas | Liberty | 48291 | 21380 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-29 04:21:05 | Liberty, Texas, US | |
1240048 | 1240048 | 2022-11-28 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-29 04:21:05 | Lauderdale, Alabama, US | |
1239538 | 1239538 | 2022-11-28 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-11-29 04:21:05 | French Guiana, France | |||
3554810 | 3554810 | 2022-11-27 | US | Texas | Liberty | 48291 | 21361 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-28 04:21:02 | Liberty, Texas, US | |
3552036 | 3552036 | 2022-11-27 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-28 04:21:02 | Lauderdale, Alabama, US | |
3551526 | 3551526 | 2022-11-27 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-11-28 04:21:02 | French Guiana, France | |||
2103290 | 2103290 | 2022-11-26 | US | Texas | Liberty | 48291 | 21361 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-27 04:21:05 | Liberty, Texas, US | |
2100516 | 2100516 | 2022-11-26 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-27 04:21:05 | Lauderdale, Alabama, US | |
2100006 | 2100006 | 2022-11-26 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-11-27 04:21:05 | French Guiana, France | |||
490781 | 490781 | 2022-11-25 | US | Texas | Liberty | 48291 | 21361 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-26 04:21:11 | Liberty, Texas, US | |
488007 | 488007 | 2022-11-25 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-26 04:21:11 | Lauderdale, Alabama, US | |
487497 | 487497 | 2022-11-25 | France | French Guiana | 95451 | 411 | 0 | 4.0 | -53.0 | 2022-11-26 04:21:11 | French Guiana, France | |||
3526610 | 3526610 | 2022-11-24 | US | Texas | Liberty | 48291 | 21361 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-11-25 04:21:06 | Liberty, Texas, US | |
3523836 | 3523836 | 2022-11-24 | US | Alabama | Lauderdale | 1077 | 28685 | 411 | 0 | 34.90171875 | -87.65624729 | 2022-11-25 04:21:06 | Lauderdale, Alabama, 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]);