johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
851 rows where confirmed = 409 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756135 | 2756135 | 2022-12-29 | US | Texas | Stonewall | 48433 | 409 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-12-30 04:21:04 | Stonewall, Texas, US | |
1077141 | 1077141 | 2022-12-28 | US | Texas | Stonewall | 48433 | 409 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-12-29 04:21:01 | Stonewall, Texas, US | |
719102 | 719102 | 2022-12-04 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-05 04:20:58 | Dolores, Colorado, US | |
2817391 | 2817391 | 2022-12-03 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-04 04:20:56 | Dolores, Colorado, US | |
834247 | 834247 | 2022-12-02 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-03 04:21:02 | Dolores, Colorado, US | |
2136777 | 2136777 | 2022-12-01 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-02 04:21:07 | Dolores, Colorado, US | |
1965193 | 1965193 | 2022-11-30 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-01 04:21:03 | Dolores, Colorado, US | |
2557207 | 2557207 | 2022-11-29 | US | Colorado | Dolores | 8033 | 409 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-11-30 04:21:07 | Dolores, Colorado, US | |
1372928 | 1372928 | 2022-09-21 | US | North Dakota | Steele | 38091 | 409 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-09-22 04:22:56 | Steele, North Dakota, US | |
2019158 | 2019158 | 2022-09-20 | US | North Dakota | Steele | 38091 | 409 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-09-21 04:23:22 | Steele, North Dakota, US | |
3573031 | 3573031 | 2022-09-19 | US | North Dakota | Steele | 38091 | 409 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-09-20 04:22:48 | Steele, North Dakota, US | |
2635802 | 2635802 | 2022-09-05 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-06 04:21:02 | Gosper, Nebraska, US | |
2989366 | 2989366 | 2022-09-04 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-05 04:21:01 | Gosper, Nebraska, US | |
2715051 | 2715051 | 2022-09-03 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-04 04:21:22 | Gosper, Nebraska, US | |
1395756 | 1395756 | 2022-09-02 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-03 04:21:04 | Gosper, Nebraska, US | |
3549585 | 3549585 | 2022-09-01 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-02 04:21:07 | Gosper, Nebraska, US | |
2345505 | 2345505 | 2022-08-31 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-09-01 04:21:03 | Gosper, Nebraska, US | |
3775985 | 3775985 | 2022-08-30 | US | Nebraska | Gosper | 31073 | 409 | 7 | 0 | 40.51481965 | -99.83020279 | 2022-08-31 04:20:57 | Gosper, Nebraska, US | |
3159620 | 3159620 | 2022-06-09 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-10 04:20:55 | Worth, Missouri, US | |
1423087 | 1423087 | 2022-06-08 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-09 04:20:54 | Worth, Missouri, US | |
3728201 | 3728201 | 2022-06-07 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-08 04:20:55 | Worth, Missouri, US | |
3889603 | 3889603 | 2022-06-06 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-07 04:21:08 | Worth, Missouri, US | |
3509372 | 3509372 | 2022-06-05 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-06 04:20:57 | Worth, Missouri, US | |
3529449 | 3529449 | 2022-06-04 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-05 04:20:55 | Worth, Missouri, US | |
3135535 | 3135535 | 2022-06-03 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-04 04:20:58 | Worth, Missouri, US | |
3580610 | 3580610 | 2022-06-02 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-03 04:20:58 | Worth, Missouri, US | |
972903 | 972903 | 2022-06-01 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-02 05:20:39 | Worth, Missouri, US | |
231210 | 231210 | 2022-05-31 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-06-01 04:20:55 | Worth, Missouri, US | |
3187975 | 3187975 | 2022-05-30 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-31 04:20:51 | Worth, Missouri, US | |
3200124 | 3200124 | 2022-05-29 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-30 04:20:50 | Worth, Missouri, US | |
2727002 | 2727002 | 2022-05-28 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-29 04:20:53 | Worth, Missouri, US | |
1316183 | 1316183 | 2022-05-27 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-28 04:21:07 | Worth, Missouri, US | |
1851975 | 1851975 | 2022-05-26 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-27 04:20:56 | Worth, Missouri, US | |
2049851 | 2049851 | 2022-05-25 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-26 04:20:50 | Worth, Missouri, US | |
3001289 | 3001289 | 2022-05-24 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-25 04:20:56 | Worth, Missouri, US | |
3595010 | 3595010 | 2022-05-23 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-24 04:20:57 | Worth, Missouri, US | |
623862 | 623862 | 2022-05-22 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-26 04:20:50 | Worth, Missouri, US | |
1111558 | 1111558 | 2022-05-21 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-22 04:20:52 | Worth, Missouri, US | |
1171182 | 1171182 | 2022-05-20 | US | Missouri | Worth | 29227 | 409 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-05-21 04:20:58 | Worth, Missouri, US | |
2535411 | 2535411 | 2022-05-12 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-13 04:20:51 | Meagher, Montana, US | |
3446857 | 3446857 | 2022-05-11 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-12 04:20:54 | Meagher, Montana, US | |
3537474 | 3537474 | 2022-05-10 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-11 04:20:48 | Meagher, Montana, US | |
224009 | 224009 | 2022-05-09 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-10 04:20:50 | Meagher, Montana, US | |
2333394 | 2333394 | 2022-05-08 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-09 04:20:54 | Meagher, Montana, US | |
362356 | 362356 | 2022-05-07 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-08 04:20:49 | Meagher, Montana, US | |
1399707 | 1399707 | 2022-05-06 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-07 04:21:09 | Meagher, Montana, US | |
2600062 | 2600062 | 2022-05-05 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-06 04:21:00 | Meagher, Montana, US | |
3267511 | 3267511 | 2022-05-04 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-05 04:20:55 | Meagher, Montana, US | |
1574150 | 1574150 | 2022-05-03 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-04 04:20:59 | Meagher, Montana, US | |
465445 | 465445 | 2022-05-02 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-05-03 04:21:00 | Boyd, Nebraska, US | |
465410 | 465410 | 2022-05-02 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-03 04:21:00 | Meagher, Montana, US | |
3918084 | 3918084 | 2022-05-01 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-05-02 04:21:10 | Boyd, Nebraska, US | |
3918049 | 3918049 | 2022-05-01 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-02 04:21:10 | Meagher, Montana, US | |
2842888 | 2842888 | 2022-04-30 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-05-01 04:20:57 | Boyd, Nebraska, US | |
2842853 | 2842853 | 2022-04-30 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-05-01 04:20:57 | Meagher, Montana, US | |
1159201 | 1159201 | 2022-04-29 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-04-30 04:21:05 | Boyd, Nebraska, US | |
1159166 | 1159166 | 2022-04-29 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-30 04:21:05 | Meagher, Montana, US | |
1698383 | 1698383 | 2022-04-28 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-04-29 04:20:59 | Boyd, Nebraska, US | |
1698348 | 1698348 | 2022-04-28 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-29 04:20:59 | Meagher, Montana, US | |
3853866 | 3853866 | 2022-04-27 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.8997274 | -98.76486568 | 2022-04-28 04:20:47 | Boyd, Nebraska, US | |
3853831 | 3853831 | 2022-04-27 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-28 04:20:47 | Meagher, Montana, US | |
1328296 | 1328296 | 2022-04-26 | US | Nebraska | Boyd | 31015 | 409 | 7 | 0 | 42.899727399999996 | -98.76486568 | 2022-04-27 04:20:52 | Boyd, Nebraska, US | |
1328261 | 1328261 | 2022-04-26 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-27 04:20:52 | Meagher, Montana, US | |
3724215 | 3724215 | 2022-04-25 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-26 04:20:51 | Meagher, Montana, US | |
2030783 | 2030783 | 2022-04-24 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-25 04:20:56 | Meagher, Montana, US | |
748358 | 748358 | 2022-04-23 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-24 04:20:56 | Meagher, Montana, US | |
3438843 | 3438843 | 2022-04-22 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-23 04:20:50 | Meagher, Montana, US | |
2894428 | 2894428 | 2022-04-21 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-22 04:20:45 | Meagher, Montana, US | |
2309300 | 2309300 | 2022-04-20 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-21 04:20:46 | Meagher, Montana, US | |
2253439 | 2253439 | 2022-04-19 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-20 04:20:45 | Meagher, Montana, US | |
1847989 | 1847989 | 2022-04-18 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-19 04:21:00 | Meagher, Montana, US | |
3418933 | 3418933 | 2022-04-17 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-18 04:21:12 | Meagher, Montana, US | |
305882 | 305882 | 2022-04-16 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-17 04:20:59 | Meagher, Montana, US | |
2671827 | 2671827 | 2022-04-15 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-16 04:20:48 | Meagher, Montana, US | |
1225612 | 1225612 | 2022-04-14 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-15 04:20:57 | Meagher, Montana, US | |
2444770 | 2444770 | 2022-04-13 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-13 23:21:06 | Meagher, Montana, US | |
1950527 | 1950527 | 2022-04-12 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-13 04:21:03 | Meagher, Montana, US | |
3208280 | 3208280 | 2022-04-11 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-12 04:20:49 | Meagher, Montana, US | |
1578166 | 1578166 | 2022-04-10 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-11 04:21:02 | Meagher, Montana, US | |
1654408 | 1654408 | 2022-04-09 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-10 04:20:52 | Meagher, Montana, US | |
2117730 | 2117730 | 2022-04-08 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-09 04:20:42 | Meagher, Montana, US | |
3322254 | 3322254 | 2022-04-07 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-08 04:20:48 | Meagher, Montana, US | |
2802790 | 2802790 | 2022-04-06 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-07 04:20:53 | Meagher, Montana, US | |
3869559 | 3869559 | 2022-04-05 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-06 04:20:49 | Meagher, Montana, US | |
2750901 | 2750901 | 2022-04-04 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-05 04:20:48 | Meagher, Montana, US | |
3732247 | 3732247 | 2022-04-03 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-04 04:20:51 | Meagher, Montana, US | |
501682 | 501682 | 2022-04-02 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-03 04:20:48 | Meagher, Montana, US | |
3352667 | 3352667 | 2022-04-01 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-02 04:20:47 | Meagher, Montana, US | |
1541972 | 1541972 | 2022-03-31 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-04-01 04:20:28 | Meagher, Montana, US | |
2479985 | 2479985 | 2022-03-30 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-03-31 04:20:56 | Meagher, Montana, US | |
160026 | 160026 | 2022-03-29 | US | Montana | Meagher | 30059 | 409 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-03-30 04:20:45 | Meagher, Montana, US | |
1470208 | 1470208 | 2022-03-24 | US | Nebraska | Pawnee | 31133 | 409 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-03-25 04:20:46 | Pawnee, Nebraska, US | |
1469400 | 1469400 | 2022-03-24 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-25 04:20:46 | Hodgeman, Kansas, US | |
3023574 | 3023574 | 2022-03-23 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-24 04:20:43 | Hodgeman, Kansas, US | |
1906496 | 1906496 | 2022-03-22 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-23 04:20:48 | Hodgeman, Kansas, US | |
3240435 | 3240435 | 2022-03-21 | US | Nebraska | Pawnee | 31133 | 409 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-03-22 04:20:54 | Pawnee, Nebraska, US | |
3239627 | 3239627 | 2022-03-21 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-22 04:20:54 | Hodgeman, Kansas, US | |
25700 | 25700 | 2022-03-20 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-21 04:20:50 | Hodgeman, Kansas, US | |
1657710 | 1657710 | 2022-03-19 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-20 04:20:45 | Hodgeman, Kansas, US | |
337236 | 337236 | 2022-03-18 | US | Kansas | Hodgeman | 20083 | 409 | 10 | 0 | 38.08780079 | -99.89829881 | 2022-03-19 04:20:47 | Hodgeman, Kansas, 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]);