daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37,839 rows where deaths = 12 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-30 04:21:04 | Anguilla, United Kingdom | |||
2022-12-29 | US | Vermont | Unassigned | 90050 | 2981 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Vermont, US | |
2022-12-29 | US | Texas | Shackelford | 48417 | 1084 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-30 04:21:04 | Shackelford, Texas, US | |
2022-12-29 | US | Texas | Menard | 48327 | 622 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-30 04:21:04 | Menard, Texas, US | |
2022-12-29 | US | Texas | Concho | 48095 | 1328 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-30 04:21:04 | Concho, Texas, US | |
2022-12-29 | US | South Dakota | Haakon | 46055 | 512 | 12 | 0 | 44.29299053 | -101.539099 | 2022-12-30 04:21:04 | Haakon, South Dakota, US | |
2022-12-29 | US | South Dakota | Deuel | 46039 | 1172 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-12-30 04:21:04 | Deuel, South Dakota, US | |
2022-12-29 | US | South Dakota | Clark | 46025 | 930 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-12-30 04:21:04 | Clark, South Dakota, US | |
2022-12-29 | US | Oklahoma | Harmon | 40057 | 819 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-30 04:21:04 | Harmon, Oklahoma, US | |
2022-12-29 | US | North Dakota | Wells | 38103 | 1179 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-12-30 04:21:04 | Wells, North Dakota, US | |
2022-12-29 | US | North Dakota | Towner | 38095 | 735 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-30 04:21:04 | Towner, North Dakota, US | |
2022-12-29 | US | North Dakota | Logan | 38047 | 544 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-12-30 04:21:04 | Logan, North Dakota, US | |
2022-12-29 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-30 04:21:04 | Valley, Nebraska, US | |
2022-12-29 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-30 04:21:04 | Meagher, Montana, US | |
2022-12-29 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-30 04:21:04 | Fallon, Montana, US | |
2022-12-29 | US | Kansas | Stanton | 20187 | 517 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-30 04:21:04 | Stanton, Kansas, US | |
2022-12-29 | US | Kansas | Lincoln | 20105 | 725 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-30 04:21:04 | Lincoln, Kansas, US | |
2022-12-29 | US | Kansas | Lane | 20101 | 366 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-30 04:21:04 | Lane, Kansas, US | |
2022-12-29 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-30 04:21:04 | Elk, Kansas, US | |
2022-12-29 | US | Kansas | Barber | 20007 | 1211 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-30 04:21:04 | Barber, Kansas, US | |
2022-12-29 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-30 04:21:04 | Oneida, Idaho, US | |
2022-12-29 | US | Idaho | Butte | 16023 | 547 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-30 04:21:04 | Butte, Idaho, US | |
2022-12-29 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-30 04:21:04 | Echols, Georgia, US | |
2022-12-29 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-30 04:21:04 | Saguache, Colorado, US | |
2022-12-29 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-30 04:21:04 | Cheyenne, Colorado, US | |
2022-12-29 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-30 04:21:04 | Yukon-Koyukuk, Alaska, US | |
2022-12-29 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-30 04:21:04 | Kodiak Island, Alaska, US | |
2022-12-29 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-30 04:21:04 | Tonga | ||||
2022-12-28 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-29 04:21:01 | Anguilla, United Kingdom | |||
2022-12-28 | US | Vermont | Unassigned | 90050 | 2981 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Vermont, US | |
2022-12-28 | US | Texas | Shackelford | 48417 | 1084 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-29 04:21:01 | Shackelford, Texas, US | |
2022-12-28 | US | Texas | Menard | 48327 | 622 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-29 04:21:01 | Menard, Texas, US | |
2022-12-28 | US | Texas | Concho | 48095 | 1328 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-29 04:21:01 | Concho, Texas, US | |
2022-12-28 | US | South Dakota | Haakon | 46055 | 512 | 12 | 0 | 44.29299053 | -101.539099 | 2022-12-29 04:21:01 | Haakon, South Dakota, US | |
2022-12-28 | US | South Dakota | Deuel | 46039 | 1172 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-12-29 04:21:01 | Deuel, South Dakota, US | |
2022-12-28 | US | South Dakota | Clark | 46025 | 930 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-12-29 04:21:01 | Clark, South Dakota, US | |
2022-12-28 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-29 04:21:01 | Harmon, Oklahoma, US | |
2022-12-28 | US | North Dakota | Wells | 38103 | 1179 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-12-29 04:21:01 | Wells, North Dakota, US | |
2022-12-28 | US | North Dakota | Towner | 38095 | 735 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-29 04:21:01 | Towner, North Dakota, US | |
2022-12-28 | US | North Dakota | Logan | 38047 | 544 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-12-29 04:21:01 | Logan, North Dakota, US | |
2022-12-28 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-29 04:21:01 | Valley, Nebraska, US | |
2022-12-28 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-29 04:21:01 | Meagher, Montana, US | |
2022-12-28 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-29 04:21:01 | Fallon, Montana, US | |
2022-12-28 | US | Kansas | Stanton | 20187 | 517 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-29 04:21:01 | Stanton, Kansas, US | |
2022-12-28 | US | Kansas | Lincoln | 20105 | 725 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-29 04:21:01 | Lincoln, Kansas, US | |
2022-12-28 | US | Kansas | Lane | 20101 | 366 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-29 04:21:01 | Lane, Kansas, US | |
2022-12-28 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-29 04:21:01 | Elk, Kansas, US | |
2022-12-28 | US | Kansas | Barber | 20007 | 1211 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-29 04:21:01 | Barber, Kansas, US | |
2022-12-28 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-29 04:21:01 | Oneida, Idaho, US | |
2022-12-28 | US | Idaho | Butte | 16023 | 547 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-29 04:21:01 | Butte, Idaho, US | |
2022-12-28 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-29 04:21:01 | Echols, Georgia, US | |
2022-12-28 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-29 04:21:01 | Saguache, Colorado, US | |
2022-12-28 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-29 04:21:01 | Cheyenne, Colorado, US | |
2022-12-28 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-29 04:21:01 | Yukon-Koyukuk, Alaska, US | |
2022-12-28 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-29 04:21:01 | Kodiak Island, Alaska, US | |
2022-12-28 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-29 04:21:01 | Tonga | ||||
2022-12-27 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-28 04:21:04 | Anguilla, United Kingdom | |||
2022-12-27 | US | Vermont | Unassigned | 90050 | 2945 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Vermont, US | |
2022-12-27 | US | Texas | Shackelford | 48417 | 1075 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-28 04:21:04 | Shackelford, Texas, US | |
2022-12-27 | US | Texas | Menard | 48327 | 618 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-28 04:21:04 | Menard, Texas, US | |
2022-12-27 | US | Texas | Concho | 48095 | 1313 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-28 04:21:04 | Concho, Texas, US | |
2022-12-27 | US | South Dakota | Haakon | 46055 | 511 | 12 | 0 | 44.29299053 | -101.539099 | 2022-12-28 04:21:04 | Haakon, South Dakota, US | |
2022-12-27 | US | South Dakota | Deuel | 46039 | 1173 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-12-28 04:21:04 | Deuel, South Dakota, US | |
2022-12-27 | US | South Dakota | Clark | 46025 | 928 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-12-28 04:21:04 | Clark, South Dakota, US | |
2022-12-27 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-28 04:21:04 | Harmon, Oklahoma, US | |
2022-12-27 | US | North Dakota | Wells | 38103 | 1179 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-12-28 04:21:04 | Wells, North Dakota, US | |
2022-12-27 | US | North Dakota | Towner | 38095 | 735 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-28 04:21:04 | Towner, North Dakota, US | |
2022-12-27 | US | North Dakota | Logan | 38047 | 544 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-12-28 04:21:04 | Logan, North Dakota, US | |
2022-12-27 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-28 04:21:04 | Valley, Nebraska, US | |
2022-12-27 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-28 04:21:04 | Meagher, Montana, US | |
2022-12-27 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-28 04:21:04 | Fallon, Montana, US | |
2022-12-27 | US | Kansas | Stanton | 20187 | 514 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-28 04:21:04 | Stanton, Kansas, US | |
2022-12-27 | US | Kansas | Lincoln | 20105 | 721 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-28 04:21:04 | Lincoln, Kansas, US | |
2022-12-27 | US | Kansas | Lane | 20101 | 365 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-28 04:21:04 | Lane, Kansas, US | |
2022-12-27 | US | Kansas | Elk | 20049 | 676 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-28 04:21:04 | Elk, Kansas, US | |
2022-12-27 | US | Kansas | Barber | 20007 | 1207 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-28 04:21:04 | Barber, Kansas, US | |
2022-12-27 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-28 04:21:04 | Oneida, Idaho, US | |
2022-12-27 | US | Idaho | Butte | 16023 | 546 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-28 04:21:04 | Butte, Idaho, US | |
2022-12-27 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-28 04:21:04 | Echols, Georgia, US | |
2022-12-27 | US | Colorado | Saguache | 8109 | 1489 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-28 04:21:04 | Saguache, Colorado, US | |
2022-12-27 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-28 04:21:04 | Cheyenne, Colorado, US | |
2022-12-27 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-28 04:21:04 | Yukon-Koyukuk, Alaska, US | |
2022-12-27 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-28 04:21:04 | Kodiak Island, Alaska, US | |
2022-12-27 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-28 04:21:04 | Tonga | ||||
2022-12-26 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-27 04:21:07 | Anguilla, United Kingdom | |||
2022-12-26 | US | Vermont | Unassigned | 90050 | 2945 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Vermont, US | |
2022-12-26 | US | Texas | Shackelford | 48417 | 1075 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-27 04:21:07 | Shackelford, Texas, US | |
2022-12-26 | US | Texas | Menard | 48327 | 618 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-27 04:21:07 | Menard, Texas, US | |
2022-12-26 | US | Texas | Concho | 48095 | 1313 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-27 04:21:07 | Concho, Texas, US | |
2022-12-26 | US | South Dakota | Haakon | 46055 | 511 | 12 | 0 | 44.29299053 | -101.539099 | 2022-12-27 04:21:07 | Haakon, South Dakota, US | |
2022-12-26 | US | South Dakota | Deuel | 46039 | 1173 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-12-27 04:21:07 | Deuel, South Dakota, US | |
2022-12-26 | US | South Dakota | Clark | 46025 | 928 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-12-27 04:21:07 | Clark, South Dakota, US | |
2022-12-26 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-27 04:21:07 | Harmon, Oklahoma, US | |
2022-12-26 | US | North Dakota | Wells | 38103 | 1179 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-12-27 04:21:07 | Wells, North Dakota, US | |
2022-12-26 | US | North Dakota | Towner | 38095 | 735 | 12 | 0 | 48.68565745 | -99.24564265 | 2022-12-27 04:21:07 | Towner, North Dakota, US | |
2022-12-26 | US | North Dakota | Logan | 38047 | 544 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-12-27 04:21:07 | Logan, North Dakota, US | |
2022-12-26 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-27 04:21:07 | Valley, Nebraska, US | |
2022-12-26 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-27 04:21:07 | Meagher, Montana, US | |
2022-12-26 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-27 04:21:07 | Fallon, Montana, US | |
2022-12-26 | US | Kansas | Stanton | 20187 | 514 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-27 04:21:07 | Stanton, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;