johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26,872 rows where deaths = 18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756150 | 2756150 | 2022-12-29 | US | Texas | Upton | 48461 | 926 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-30 04:21:04 | Upton, Texas, US | |
2756033 | 2756033 | 2022-12-29 | US | Texas | Hudspeth | 48229 | 1156 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-30 04:21:04 | Hudspeth, Texas, US | |
2755769 | 2755769 | 2022-12-29 | US | South Dakota | Corson | 46031 | 1188 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-30 04:21:04 | Corson, South Dakota, US | |
2755762 | 2755762 | 2022-12-29 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-30 04:21:04 | Buffalo, South Dakota, US | |
2755755 | 2755755 | 2022-12-29 | US | South Dakota | Aurora | 46003 | 887 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-30 04:21:04 | Aurora, South Dakota, US | |
2755324 | 2755324 | 2022-12-29 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-30 04:21:04 | Nelson, North Dakota, US | |
2755307 | 2755307 | 2022-12-29 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-30 04:21:04 | Emmons, North Dakota, US | |
2755104 | 2755104 | 2022-12-29 | US | New Mexico | Guadalupe | 35019 | 1335 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-30 04:21:04 | Guadalupe, New Mexico, US | |
2755024 | 2755024 | 2022-12-29 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-30 04:21:04 | Saline, Nebraska, US | |
2754974 | 2754974 | 2022-12-29 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-30 04:21:04 | Dixon, Nebraska, US | |
2754960 | 2754960 | 2022-12-29 | US | Nebraska | Butler | 31023 | 2212 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-12-30 04:21:04 | Butler, Nebraska, US | |
2754950 | 2754950 | 2022-12-29 | US | Nebraska | Antelope | 31003 | 1242 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-12-30 04:21:04 | Antelope, Nebraska, US | |
2754869 | 2754869 | 2022-12-29 | US | Missouri | Scotland | 29199 | 818 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-12-30 04:21:04 | Scotland, Missouri, US | |
2754646 | 2754646 | 2022-12-29 | US | Minnesota | Mahnomen | 27087 | 2109 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-12-30 04:21:04 | Mahnomen, Minnesota, US | |
2754594 | 2754594 | 2022-12-29 | US | Michigan | Schoolcraft | 26153 | 2165 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-12-30 04:21:04 | Schoolcraft, Michigan, US | |
2754518 | 2754518 | 2022-12-29 | US | Michigan | Alger | 26003 | 2081 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-30 04:21:04 | Alger, Michigan, US | |
2754198 | 2754198 | 2022-12-29 | US | Kansas | Graham | 20065 | 746 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-30 04:21:04 | Graham, Kansas, US | |
2754182 | 2754182 | 2022-12-29 | US | Kansas | Comanche | 20033 | 543 | 18 | 0 | 37.1911452 | -99.27113247 | 2022-12-30 04:21:04 | Comanche, Kansas, US | |
1077156 | 1077156 | 2022-12-28 | US | Texas | Upton | 48461 | 926 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-29 04:21:01 | Upton, Texas, US | |
1077039 | 1077039 | 2022-12-28 | US | Texas | Hudspeth | 48229 | 1156 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-29 04:21:01 | Hudspeth, Texas, US | |
1076775 | 1076775 | 2022-12-28 | US | South Dakota | Corson | 46031 | 1188 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-29 04:21:01 | Corson, South Dakota, US | |
1076768 | 1076768 | 2022-12-28 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-29 04:21:01 | Buffalo, South Dakota, US | |
1076761 | 1076761 | 2022-12-28 | US | South Dakota | Aurora | 46003 | 887 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-29 04:21:01 | Aurora, South Dakota, US | |
1076330 | 1076330 | 2022-12-28 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-29 04:21:01 | Nelson, North Dakota, US | |
1076313 | 1076313 | 2022-12-28 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-29 04:21:01 | Emmons, North Dakota, US | |
1076110 | 1076110 | 2022-12-28 | US | New Mexico | Guadalupe | 35019 | 1335 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-29 04:21:01 | Guadalupe, New Mexico, US | |
1076030 | 1076030 | 2022-12-28 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-29 04:21:01 | Saline, Nebraska, US | |
1075980 | 1075980 | 2022-12-28 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-29 04:21:01 | Dixon, Nebraska, US | |
1075966 | 1075966 | 2022-12-28 | US | Nebraska | Butler | 31023 | 2212 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-12-29 04:21:01 | Butler, Nebraska, US | |
1075956 | 1075956 | 2022-12-28 | US | Nebraska | Antelope | 31003 | 1242 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-12-29 04:21:01 | Antelope, Nebraska, US | |
1075875 | 1075875 | 2022-12-28 | US | Missouri | Scotland | 29199 | 818 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-12-29 04:21:01 | Scotland, Missouri, US | |
1075652 | 1075652 | 2022-12-28 | US | Minnesota | Mahnomen | 27087 | 2103 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-12-29 04:21:01 | Mahnomen, Minnesota, US | |
1075600 | 1075600 | 2022-12-28 | US | Michigan | Schoolcraft | 26153 | 2165 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-12-29 04:21:01 | Schoolcraft, Michigan, US | |
1075524 | 1075524 | 2022-12-28 | US | Michigan | Alger | 26003 | 2081 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-29 04:21:01 | Alger, Michigan, US | |
1075204 | 1075204 | 2022-12-28 | US | Kansas | Graham | 20065 | 746 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-29 04:21:01 | Graham, Kansas, US | |
1075188 | 1075188 | 2022-12-28 | US | Kansas | Comanche | 20033 | 543 | 18 | 0 | 37.1911452 | -99.27113247 | 2022-12-29 04:21:01 | Comanche, Kansas, US | |
331153 | 331153 | 2022-12-27 | US | Texas | Upton | 48461 | 924 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-28 04:21:04 | Upton, Texas, US | |
331036 | 331036 | 2022-12-27 | US | Texas | Hudspeth | 48229 | 1155 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-28 04:21:04 | Hudspeth, Texas, US | |
330772 | 330772 | 2022-12-27 | US | South Dakota | Corson | 46031 | 1187 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-28 04:21:04 | Corson, South Dakota, US | |
330765 | 330765 | 2022-12-27 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-28 04:21:04 | Buffalo, South Dakota, US | |
330758 | 330758 | 2022-12-27 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-28 04:21:04 | Aurora, South Dakota, US | |
330327 | 330327 | 2022-12-27 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-28 04:21:04 | Nelson, North Dakota, US | |
330310 | 330310 | 2022-12-27 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-28 04:21:04 | Emmons, North Dakota, US | |
330107 | 330107 | 2022-12-27 | US | New Mexico | Guadalupe | 35019 | 1334 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-28 04:21:04 | Guadalupe, New Mexico, US | |
330027 | 330027 | 2022-12-27 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-28 04:21:04 | Saline, Nebraska, US | |
329977 | 329977 | 2022-12-27 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-28 04:21:04 | Dixon, Nebraska, US | |
329963 | 329963 | 2022-12-27 | US | Nebraska | Butler | 31023 | 2212 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-12-28 04:21:04 | Butler, Nebraska, US | |
329953 | 329953 | 2022-12-27 | US | Nebraska | Antelope | 31003 | 1242 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-12-28 04:21:04 | Antelope, Nebraska, US | |
329872 | 329872 | 2022-12-27 | US | Missouri | Scotland | 29199 | 818 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-12-28 04:21:04 | Scotland, Missouri, US | |
329649 | 329649 | 2022-12-27 | US | Minnesota | Mahnomen | 27087 | 2103 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-12-28 04:21:04 | Mahnomen, Minnesota, US | |
329597 | 329597 | 2022-12-27 | US | Michigan | Schoolcraft | 26153 | 2165 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-12-28 04:21:04 | Schoolcraft, Michigan, US | |
329521 | 329521 | 2022-12-27 | US | Michigan | Alger | 26003 | 2081 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-28 04:21:04 | Alger, Michigan, US | |
329201 | 329201 | 2022-12-27 | US | Kansas | Graham | 20065 | 744 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-28 04:21:04 | Graham, Kansas, US | |
329185 | 329185 | 2022-12-27 | US | Kansas | Comanche | 20033 | 543 | 18 | 0 | 37.1911452 | -99.27113247 | 2022-12-28 04:21:04 | Comanche, Kansas, US | |
221226 | 221226 | 2022-12-26 | US | Texas | Upton | 48461 | 924 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-27 04:21:07 | Upton, Texas, US | |
221109 | 221109 | 2022-12-26 | US | Texas | Hudspeth | 48229 | 1155 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-27 04:21:07 | Hudspeth, Texas, US | |
220845 | 220845 | 2022-12-26 | US | South Dakota | Corson | 46031 | 1187 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-27 04:21:07 | Corson, South Dakota, US | |
220838 | 220838 | 2022-12-26 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-27 04:21:07 | Buffalo, South Dakota, US | |
220831 | 220831 | 2022-12-26 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-27 04:21:07 | Aurora, South Dakota, US | |
220400 | 220400 | 2022-12-26 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-27 04:21:07 | Nelson, North Dakota, US | |
220383 | 220383 | 2022-12-26 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-27 04:21:07 | Emmons, North Dakota, US | |
220180 | 220180 | 2022-12-26 | US | New Mexico | Guadalupe | 35019 | 1334 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-27 04:21:07 | Guadalupe, New Mexico, US | |
220100 | 220100 | 2022-12-26 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-27 04:21:07 | Saline, Nebraska, US | |
220050 | 220050 | 2022-12-26 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-27 04:21:07 | Dixon, Nebraska, US | |
220036 | 220036 | 2022-12-26 | US | Nebraska | Butler | 31023 | 2212 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-12-27 04:21:07 | Butler, Nebraska, US | |
220026 | 220026 | 2022-12-26 | US | Nebraska | Antelope | 31003 | 1242 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-12-27 04:21:07 | Antelope, Nebraska, US | |
219945 | 219945 | 2022-12-26 | US | Missouri | Scotland | 29199 | 817 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-12-27 04:21:07 | Scotland, Missouri, US | |
219722 | 219722 | 2022-12-26 | US | Minnesota | Mahnomen | 27087 | 2103 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-12-27 04:21:07 | Mahnomen, Minnesota, US | |
219670 | 219670 | 2022-12-26 | US | Michigan | Schoolcraft | 26153 | 2160 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-12-27 04:21:07 | Schoolcraft, Michigan, US | |
219594 | 219594 | 2022-12-26 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-27 04:21:07 | Alger, Michigan, US | |
219274 | 219274 | 2022-12-26 | US | Kansas | Graham | 20065 | 744 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-27 04:21:07 | Graham, Kansas, US | |
219258 | 219258 | 2022-12-26 | US | Kansas | Comanche | 20033 | 543 | 18 | 0 | 37.1911452 | -99.27113247 | 2022-12-27 04:21:07 | Comanche, Kansas, US | |
3225683 | 3225683 | 2022-12-25 | US | Texas | Upton | 48461 | 924 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-26 04:21:06 | Upton, Texas, US | |
3225566 | 3225566 | 2022-12-25 | US | Texas | Hudspeth | 48229 | 1155 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-26 04:21:06 | Hudspeth, Texas, US | |
3225302 | 3225302 | 2022-12-25 | US | South Dakota | Corson | 46031 | 1187 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-26 04:21:06 | Corson, South Dakota, US | |
3225295 | 3225295 | 2022-12-25 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-26 04:21:06 | Buffalo, South Dakota, US | |
3225288 | 3225288 | 2022-12-25 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-26 04:21:06 | Aurora, South Dakota, US | |
3224857 | 3224857 | 2022-12-25 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-26 04:21:06 | Nelson, North Dakota, US | |
3224840 | 3224840 | 2022-12-25 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-26 04:21:06 | Emmons, North Dakota, US | |
3224637 | 3224637 | 2022-12-25 | US | New Mexico | Guadalupe | 35019 | 1334 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-26 04:21:06 | Guadalupe, New Mexico, US | |
3224557 | 3224557 | 2022-12-25 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-26 04:21:06 | Saline, Nebraska, US | |
3224507 | 3224507 | 2022-12-25 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-26 04:21:06 | Dixon, Nebraska, US | |
3224493 | 3224493 | 2022-12-25 | US | Nebraska | Butler | 31023 | 2212 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-12-26 04:21:06 | Butler, Nebraska, US | |
3224483 | 3224483 | 2022-12-25 | US | Nebraska | Antelope | 31003 | 1242 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-12-26 04:21:06 | Antelope, Nebraska, US | |
3224402 | 3224402 | 2022-12-25 | US | Missouri | Scotland | 29199 | 817 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-12-26 04:21:06 | Scotland, Missouri, US | |
3224179 | 3224179 | 2022-12-25 | US | Minnesota | Mahnomen | 27087 | 2103 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-12-26 04:21:06 | Mahnomen, Minnesota, US | |
3224127 | 3224127 | 2022-12-25 | US | Michigan | Schoolcraft | 26153 | 2160 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-12-26 04:21:06 | Schoolcraft, Michigan, US | |
3224051 | 3224051 | 2022-12-25 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-26 04:21:06 | Alger, Michigan, US | |
3223731 | 3223731 | 2022-12-25 | US | Kansas | Graham | 20065 | 744 | 18 | 0 | 39.34987223 | -99.88332493 | 2022-12-26 04:21:06 | Graham, Kansas, US | |
3223715 | 3223715 | 2022-12-25 | US | Kansas | Comanche | 20033 | 543 | 18 | 0 | 37.1911452 | -99.27113247 | 2022-12-26 04:21:06 | Comanche, Kansas, US | |
1021597 | 1021597 | 2022-12-24 | US | Texas | Upton | 48461 | 924 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-25 04:21:04 | Upton, Texas, US | |
1021480 | 1021480 | 2022-12-24 | US | Texas | Hudspeth | 48229 | 1155 | 18 | 0 | 31.45628381 | -105.388178 | 2022-12-25 04:21:04 | Hudspeth, Texas, US | |
1021216 | 1021216 | 2022-12-24 | US | South Dakota | Corson | 46031 | 1187 | 18 | 0 | 45.70889983 | -101.1970473 | 2022-12-25 04:21:04 | Corson, South Dakota, US | |
1021209 | 1021209 | 2022-12-24 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | 44.07657829 | -99.20814467 | 2022-12-25 04:21:04 | Buffalo, South Dakota, US | |
1021202 | 1021202 | 2022-12-24 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-25 04:21:04 | Aurora, South Dakota, US | |
1020771 | 1020771 | 2022-12-24 | US | North Dakota | Nelson | 38063 | 890 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-25 04:21:04 | Nelson, North Dakota, US | |
1020754 | 1020754 | 2022-12-24 | US | North Dakota | Emmons | 38029 | 835 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-12-25 04:21:04 | Emmons, North Dakota, US | |
1020551 | 1020551 | 2022-12-24 | US | New Mexico | Guadalupe | 35019 | 1334 | 18 | 0 | 34.86319296 | -104.790669 | 2022-12-25 04:21:04 | Guadalupe, New Mexico, US | |
1020471 | 1020471 | 2022-12-24 | US | Nebraska | Saline | 31151 | 4237 | 18 | 0 | 40.52418865 | -97.14085859 | 2022-12-25 04:21:04 | Saline, Nebraska, US | |
1020421 | 1020421 | 2022-12-24 | US | Nebraska | Dixon | 31051 | 1360 | 18 | 0 | 42.49188363 | -96.86782408 | 2022-12-25 04:21:04 | Dixon, Nebraska, 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]);