johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756561 | 2756561 | 2022-12-29 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-30 04:21:04 | Anguilla, United Kingdom | |||
2756199 | 2756199 | 2022-12-29 | US | Vermont | Unassigned | 90050 | 2981 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Vermont, US | |
2756127 | 2756127 | 2022-12-29 | US | Texas | Shackelford | 48417 | 1084 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-30 04:21:04 | Shackelford, Texas, US | |
2756082 | 2756082 | 2022-12-29 | US | Texas | Menard | 48327 | 622 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-30 04:21:04 | Menard, Texas, US | |
2755966 | 2755966 | 2022-12-29 | US | Texas | Concho | 48095 | 1328 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-30 04:21:04 | Concho, Texas, US | |
2755781 | 2755781 | 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 | |
2755773 | 2755773 | 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 | |
2755766 | 2755766 | 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 | |
2755465 | 2755465 | 2022-12-29 | US | Oklahoma | Harmon | 40057 | 819 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-30 04:21:04 | Harmon, Oklahoma, US | |
2755345 | 2755345 | 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 | |
2755340 | 2755340 | 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 | |
2755316 | 2755316 | 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 | |
2755037 | 2755037 | 2022-12-29 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-30 04:21:04 | Valley, Nebraska, US | |
2754921 | 2754921 | 2022-12-29 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-30 04:21:04 | Meagher, Montana, US | |
2754904 | 2754904 | 2022-12-29 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-30 04:21:04 | Fallon, Montana, US | |
2754260 | 2754260 | 2022-12-29 | US | Kansas | Stanton | 20187 | 517 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-30 04:21:04 | Stanton, Kansas, US | |
2754218 | 2754218 | 2022-12-29 | US | Kansas | Lincoln | 20105 | 725 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-30 04:21:04 | Lincoln, Kansas, US | |
2754216 | 2754216 | 2022-12-29 | US | Kansas | Lane | 20101 | 366 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-30 04:21:04 | Lane, Kansas, US | |
2754190 | 2754190 | 2022-12-29 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-30 04:21:04 | Elk, Kansas, US | |
2754169 | 2754169 | 2022-12-29 | US | Kansas | Barber | 20007 | 1211 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-30 04:21:04 | Barber, Kansas, US | |
2753859 | 2753859 | 2022-12-29 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-30 04:21:04 | Oneida, Idaho, US | |
2753835 | 2753835 | 2022-12-29 | US | Idaho | Butte | 16023 | 547 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-30 04:21:04 | Butte, Idaho, US | |
2753704 | 2753704 | 2022-12-29 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-30 04:21:04 | Echols, Georgia, US | |
2753562 | 2753562 | 2022-12-29 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-30 04:21:04 | Saguache, Colorado, US | |
2753515 | 2753515 | 2022-12-29 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-30 04:21:04 | Cheyenne, Colorado, US | |
2753351 | 2753351 | 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 | |
2753336 | 2753336 | 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 | |
2753247 | 2753247 | 2022-12-29 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-30 04:21:04 | Tonga | ||||
1077567 | 1077567 | 2022-12-28 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-29 04:21:01 | Anguilla, United Kingdom | |||
1077205 | 1077205 | 2022-12-28 | US | Vermont | Unassigned | 90050 | 2981 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Vermont, US | |
1077133 | 1077133 | 2022-12-28 | US | Texas | Shackelford | 48417 | 1084 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-29 04:21:01 | Shackelford, Texas, US | |
1077088 | 1077088 | 2022-12-28 | US | Texas | Menard | 48327 | 622 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-29 04:21:01 | Menard, Texas, US | |
1076972 | 1076972 | 2022-12-28 | US | Texas | Concho | 48095 | 1328 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-29 04:21:01 | Concho, Texas, US | |
1076787 | 1076787 | 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 | |
1076779 | 1076779 | 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 | |
1076772 | 1076772 | 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 | |
1076471 | 1076471 | 2022-12-28 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-29 04:21:01 | Harmon, Oklahoma, US | |
1076351 | 1076351 | 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 | |
1076346 | 1076346 | 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 | |
1076322 | 1076322 | 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 | |
1076043 | 1076043 | 2022-12-28 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-29 04:21:01 | Valley, Nebraska, US | |
1075927 | 1075927 | 2022-12-28 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-29 04:21:01 | Meagher, Montana, US | |
1075910 | 1075910 | 2022-12-28 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-29 04:21:01 | Fallon, Montana, US | |
1075266 | 1075266 | 2022-12-28 | US | Kansas | Stanton | 20187 | 517 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-29 04:21:01 | Stanton, Kansas, US | |
1075224 | 1075224 | 2022-12-28 | US | Kansas | Lincoln | 20105 | 725 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-29 04:21:01 | Lincoln, Kansas, US | |
1075222 | 1075222 | 2022-12-28 | US | Kansas | Lane | 20101 | 366 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-29 04:21:01 | Lane, Kansas, US | |
1075196 | 1075196 | 2022-12-28 | US | Kansas | Elk | 20049 | 678 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-29 04:21:01 | Elk, Kansas, US | |
1075175 | 1075175 | 2022-12-28 | US | Kansas | Barber | 20007 | 1211 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-29 04:21:01 | Barber, Kansas, US | |
1074865 | 1074865 | 2022-12-28 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-29 04:21:01 | Oneida, Idaho, US | |
1074841 | 1074841 | 2022-12-28 | US | Idaho | Butte | 16023 | 547 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-29 04:21:01 | Butte, Idaho, US | |
1074710 | 1074710 | 2022-12-28 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-29 04:21:01 | Echols, Georgia, US | |
1074568 | 1074568 | 2022-12-28 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-29 04:21:01 | Saguache, Colorado, US | |
1074521 | 1074521 | 2022-12-28 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-29 04:21:01 | Cheyenne, Colorado, US | |
1074357 | 1074357 | 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 | |
1074342 | 1074342 | 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 | |
1074253 | 1074253 | 2022-12-28 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-29 04:21:01 | Tonga | ||||
331564 | 331564 | 2022-12-27 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-28 04:21:04 | Anguilla, United Kingdom | |||
331202 | 331202 | 2022-12-27 | US | Vermont | Unassigned | 90050 | 2945 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Vermont, US | |
331130 | 331130 | 2022-12-27 | US | Texas | Shackelford | 48417 | 1075 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-28 04:21:04 | Shackelford, Texas, US | |
331085 | 331085 | 2022-12-27 | US | Texas | Menard | 48327 | 618 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-28 04:21:04 | Menard, Texas, US | |
330969 | 330969 | 2022-12-27 | US | Texas | Concho | 48095 | 1313 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-28 04:21:04 | Concho, Texas, US | |
330784 | 330784 | 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 | |
330776 | 330776 | 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 | |
330769 | 330769 | 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 | |
330468 | 330468 | 2022-12-27 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-28 04:21:04 | Harmon, Oklahoma, US | |
330348 | 330348 | 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 | |
330343 | 330343 | 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 | |
330319 | 330319 | 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 | |
330040 | 330040 | 2022-12-27 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-28 04:21:04 | Valley, Nebraska, US | |
329924 | 329924 | 2022-12-27 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-28 04:21:04 | Meagher, Montana, US | |
329907 | 329907 | 2022-12-27 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-28 04:21:04 | Fallon, Montana, US | |
329263 | 329263 | 2022-12-27 | US | Kansas | Stanton | 20187 | 514 | 12 | 0 | 37.56304714 | -101.7843534 | 2022-12-28 04:21:04 | Stanton, Kansas, US | |
329221 | 329221 | 2022-12-27 | US | Kansas | Lincoln | 20105 | 721 | 12 | 0 | 39.04549684 | -98.20756994 | 2022-12-28 04:21:04 | Lincoln, Kansas, US | |
329219 | 329219 | 2022-12-27 | US | Kansas | Lane | 20101 | 365 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-12-28 04:21:04 | Lane, Kansas, US | |
329193 | 329193 | 2022-12-27 | US | Kansas | Elk | 20049 | 676 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-12-28 04:21:04 | Elk, Kansas, US | |
329172 | 329172 | 2022-12-27 | US | Kansas | Barber | 20007 | 1207 | 12 | 0 | 37.2288586 | -98.68460053 | 2022-12-28 04:21:04 | Barber, Kansas, US | |
328862 | 328862 | 2022-12-27 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-28 04:21:04 | Oneida, Idaho, US | |
328838 | 328838 | 2022-12-27 | US | Idaho | Butte | 16023 | 546 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-12-28 04:21:04 | Butte, Idaho, US | |
328707 | 328707 | 2022-12-27 | US | Georgia | Echols | 13101 | 1041 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-12-28 04:21:04 | Echols, Georgia, US | |
328565 | 328565 | 2022-12-27 | US | Colorado | Saguache | 8109 | 1489 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-28 04:21:04 | Saguache, Colorado, US | |
328518 | 328518 | 2022-12-27 | US | Colorado | Cheyenne | 8017 | 383 | 12 | 0 | 38.82777431 | -102.6032558 | 2022-12-28 04:21:04 | Cheyenne, Colorado, US | |
328354 | 328354 | 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 | |
328339 | 328339 | 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 | |
328250 | 328250 | 2022-12-27 | Tonga | 16211 | 12 | 0 | -21.179 | -175.1982 | 2022-12-28 04:21:04 | Tonga | ||||
221637 | 221637 | 2022-12-26 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-27 04:21:07 | Anguilla, United Kingdom | |||
221275 | 221275 | 2022-12-26 | US | Vermont | Unassigned | 90050 | 2945 | 12 | 0 | 44.85627605 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Vermont, US | |
221203 | 221203 | 2022-12-26 | US | Texas | Shackelford | 48417 | 1075 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-12-27 04:21:07 | Shackelford, Texas, US | |
221158 | 221158 | 2022-12-26 | US | Texas | Menard | 48327 | 618 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-12-27 04:21:07 | Menard, Texas, US | |
221042 | 221042 | 2022-12-26 | US | Texas | Concho | 48095 | 1313 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-12-27 04:21:07 | Concho, Texas, US | |
220857 | 220857 | 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 | |
220849 | 220849 | 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 | |
220842 | 220842 | 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 | |
220541 | 220541 | 2022-12-26 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-27 04:21:07 | Harmon, Oklahoma, US | |
220421 | 220421 | 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 | |
220416 | 220416 | 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 | |
220392 | 220392 | 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 | |
220113 | 220113 | 2022-12-26 | US | Nebraska | Valley | 31175 | 845 | 12 | 0 | 41.56730777 | -98.98197724 | 2022-12-27 04:21:07 | Valley, Nebraska, US | |
219997 | 219997 | 2022-12-26 | US | Montana | Meagher | 30059 | 582 | 12 | 0 | 46.59907074 | -110.8898557 | 2022-12-27 04:21:07 | Meagher, Montana, US | |
219980 | 219980 | 2022-12-26 | US | Montana | Fallon | 30025 | 780 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-27 04:21:07 | Fallon, Montana, US | |
219336 | 219336 | 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 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]);