johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,557 rows where deaths = 202 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756027 | 2756027 | 2022-12-29 | US | Texas | Hill | 48217 | 9931 | 202 | 0 | 31.99045053 | -97.13423143 | 2022-12-30 04:21:04 | Hill, Texas, US | |
2755233 | 2755233 | 2022-12-29 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-30 04:21:04 | Halifax, North Carolina, US | |
2754551 | 2754551 | 2022-12-29 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-30 04:21:04 | Ionia, Michigan, US | |
2754053 | 2754053 | 2022-12-29 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Indiana, US | |
2753218 | 2753218 | 2022-12-29 | Sweden | Blekinge | 31930 | 202 | 0 | 56.2784 | 15.018 | 2022-12-30 04:21:04 | Blekinge, Sweden | |||
1077033 | 1077033 | 2022-12-28 | US | Texas | Hill | 48217 | 9931 | 202 | 0 | 31.99045053 | -97.13423143 | 2022-12-29 04:21:01 | Hill, Texas, US | |
1076239 | 1076239 | 2022-12-28 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-29 04:21:01 | Halifax, North Carolina, US | |
1075557 | 1075557 | 2022-12-28 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-29 04:21:01 | Ionia, Michigan, US | |
1075059 | 1075059 | 2022-12-28 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Indiana, US | |
330236 | 330236 | 2022-12-27 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-28 04:21:04 | Halifax, North Carolina, US | |
329554 | 329554 | 2022-12-27 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-28 04:21:04 | Ionia, Michigan, US | |
329056 | 329056 | 2022-12-27 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Indiana, US | |
328762 | 328762 | 2022-12-27 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-28 04:21:04 | Murray, Georgia, US | |
220309 | 220309 | 2022-12-26 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-27 04:21:07 | Halifax, North Carolina, US | |
219627 | 219627 | 2022-12-26 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-27 04:21:07 | Ionia, Michigan, US | |
219358 | 219358 | 2022-12-26 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-27 04:21:07 | Boyd, Kentucky, US | |
219129 | 219129 | 2022-12-26 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Indiana, US | |
218835 | 218835 | 2022-12-26 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-27 04:21:07 | Murray, Georgia, US | |
3224766 | 3224766 | 2022-12-25 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-26 04:21:06 | Halifax, North Carolina, US | |
3224084 | 3224084 | 2022-12-25 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-26 04:21:06 | Ionia, Michigan, US | |
3223815 | 3223815 | 2022-12-25 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-26 04:21:06 | Boyd, Kentucky, US | |
3223586 | 3223586 | 2022-12-25 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Indiana, US | |
3223292 | 3223292 | 2022-12-25 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-26 04:21:06 | Murray, Georgia, US | |
1020680 | 1020680 | 2022-12-24 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-25 04:21:04 | Halifax, North Carolina, US | |
1019998 | 1019998 | 2022-12-24 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-25 04:21:04 | Ionia, Michigan, US | |
1019729 | 1019729 | 2022-12-24 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-25 04:21:04 | Boyd, Kentucky, US | |
1019500 | 1019500 | 2022-12-24 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Indiana, US | |
1019206 | 1019206 | 2022-12-24 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-25 04:21:04 | Murray, Georgia, US | |
692703 | 692703 | 2022-12-23 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-24 04:21:02 | Halifax, North Carolina, US | |
692021 | 692021 | 2022-12-23 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-24 04:21:02 | Ionia, Michigan, US | |
691752 | 691752 | 2022-12-23 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-24 04:21:02 | Boyd, Kentucky, US | |
691523 | 691523 | 2022-12-23 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Indiana, US | |
691229 | 691229 | 2022-12-23 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-24 04:21:02 | Murray, Georgia, US | |
2181913 | 2181913 | 2022-12-22 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-23 04:21:04 | Halifax, North Carolina, US | |
2181231 | 2181231 | 2022-12-22 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-23 04:21:04 | Ionia, Michigan, US | |
2180962 | 2180962 | 2022-12-22 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-23 04:21:04 | Boyd, Kentucky, US | |
2180733 | 2180733 | 2022-12-22 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-23 04:21:04 | Unassigned, Indiana, US | |
2180439 | 2180439 | 2022-12-22 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-23 04:21:04 | Murray, Georgia, US | |
453717 | 453717 | 2022-12-21 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-22 04:20:56 | Halifax, North Carolina, US | |
453153 | 453153 | 2022-12-21 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-22 04:20:56 | Rice, Minnesota, US | |
453035 | 453035 | 2022-12-21 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-22 04:20:56 | Ionia, Michigan, US | |
452766 | 452766 | 2022-12-21 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-22 04:20:56 | Boyd, Kentucky, US | |
452537 | 452537 | 2022-12-21 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Indiana, US | |
452243 | 452243 | 2022-12-21 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-22 04:20:56 | Murray, Georgia, US | |
2953716 | 2953716 | 2022-12-20 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-21 04:21:03 | Halifax, North Carolina, US | |
2953152 | 2953152 | 2022-12-20 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-21 04:21:03 | Rice, Minnesota, US | |
2953034 | 2953034 | 2022-12-20 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-21 04:21:03 | Ionia, Michigan, US | |
2952765 | 2952765 | 2022-12-20 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-21 04:21:03 | Boyd, Kentucky, US | |
2952536 | 2952536 | 2022-12-20 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-21 04:21:03 | Unassigned, Indiana, US | |
2952242 | 2952242 | 2022-12-20 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-21 04:21:03 | Murray, Georgia, US | |
3176118 | 3176118 | 2022-12-19 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-20 04:21:04 | Halifax, North Carolina, US | |
3175554 | 3175554 | 2022-12-19 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-20 04:21:04 | Rice, Minnesota, US | |
3175167 | 3175167 | 2022-12-19 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-20 04:21:04 | Boyd, Kentucky, US | |
3174938 | 3174938 | 2022-12-19 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-20 04:21:04 | Unassigned, Indiana, US | |
3174644 | 3174644 | 2022-12-19 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-20 04:21:04 | Murray, Georgia, US | |
1630635 | 1630635 | 2022-12-18 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-19 04:21:03 | Halifax, North Carolina, US | |
1630071 | 1630071 | 2022-12-18 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-19 04:21:03 | Rice, Minnesota, US | |
1629455 | 1629455 | 2022-12-18 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-19 04:21:03 | Unassigned, Indiana, US | |
1629161 | 1629161 | 2022-12-18 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-19 04:21:03 | Murray, Georgia, US | |
506014 | 506014 | 2022-12-17 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-18 04:21:03 | Halifax, North Carolina, US | |
505450 | 505450 | 2022-12-17 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-18 04:21:03 | Rice, Minnesota, US | |
504834 | 504834 | 2022-12-17 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-18 04:21:03 | Unassigned, Indiana, US | |
504540 | 504540 | 2022-12-17 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-18 04:21:03 | Murray, Georgia, US | |
3326586 | 3326586 | 2022-12-16 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-17 04:21:04 | Halifax, North Carolina, US | |
3326022 | 3326022 | 2022-12-16 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-17 04:21:04 | Rice, Minnesota, US | |
3325406 | 3325406 | 2022-12-16 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-17 04:21:04 | Unassigned, Indiana, US | |
3325112 | 3325112 | 2022-12-16 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-17 04:21:04 | Murray, Georgia, US | |
545098 | 545098 | 2022-12-15 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-16 04:21:01 | Halifax, North Carolina, US | |
544926 | 544926 | 2022-12-15 | US | New Hampshire | Belknap | 33001 | 16755 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-16 04:21:01 | Belknap, New Hampshire, US | |
544534 | 544534 | 2022-12-15 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-16 04:21:01 | Rice, Minnesota, US | |
543918 | 543918 | 2022-12-15 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Indiana, US | |
543624 | 543624 | 2022-12-15 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-16 04:21:01 | Murray, Georgia, US | |
350626 | 350626 | 2022-12-14 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-15 04:20:58 | Halifax, North Carolina, US | |
350454 | 350454 | 2022-12-14 | US | New Hampshire | Belknap | 33001 | 16741 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-15 04:20:58 | Belknap, New Hampshire, US | |
349446 | 349446 | 2022-12-14 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Indiana, US | |
349152 | 349152 | 2022-12-14 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-15 04:20:58 | Murray, Georgia, US | |
310227 | 310227 | 2022-12-13 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-14 04:21:04 | Lincoln, North Carolina, US | |
310214 | 310214 | 2022-12-13 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-14 04:21:04 | Halifax, North Carolina, US | |
310042 | 310042 | 2022-12-13 | US | New Hampshire | Belknap | 33001 | 16725 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-14 04:21:04 | Belknap, New Hampshire, US | |
1151889 | 1151889 | 2022-12-12 | US | Tennessee | Franklin | 47051 | 15404 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-13 04:21:01 | Franklin, Tennessee, US | |
1151288 | 1151288 | 2022-12-12 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-13 04:21:01 | Lincoln, North Carolina, US | |
1151275 | 1151275 | 2022-12-12 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-13 04:21:01 | Halifax, North Carolina, US | |
1151103 | 1151103 | 2022-12-12 | US | New Hampshire | Belknap | 33001 | 16716 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-13 04:21:01 | Belknap, New Hampshire, US | |
871743 | 871743 | 2022-12-11 | US | Tennessee | Franklin | 47051 | 15402 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-12 04:21:01 | Franklin, Tennessee, US | |
871142 | 871142 | 2022-12-11 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-12 04:21:01 | Lincoln, North Carolina, US | |
871129 | 871129 | 2022-12-11 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-12 04:21:01 | Halifax, North Carolina, US | |
870957 | 870957 | 2022-12-11 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-12 04:21:01 | Belknap, New Hampshire, US | |
260273 | 260273 | 2022-12-10 | US | Tennessee | Franklin | 47051 | 15402 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-11 04:20:50 | Franklin, Tennessee, US | |
259672 | 259672 | 2022-12-10 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-11 04:20:50 | Lincoln, North Carolina, US | |
259659 | 259659 | 2022-12-10 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-11 04:20:50 | Halifax, North Carolina, US | |
259487 | 259487 | 2022-12-10 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-11 04:20:50 | Belknap, New Hampshire, US | |
3938987 | 3938987 | 2022-12-09 | US | Tennessee | Franklin | 47051 | 15399 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-10 04:21:02 | Franklin, Tennessee, US | |
3938386 | 3938386 | 2022-12-09 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-10 04:21:02 | Lincoln, North Carolina, US | |
3938373 | 3938373 | 2022-12-09 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-10 04:21:02 | Halifax, North Carolina, US | |
3938201 | 3938201 | 2022-12-09 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-10 04:21:02 | Belknap, New Hampshire, US | |
3380319 | 3380319 | 2022-12-08 | US | Tennessee | Franklin | 47051 | 15380 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-09 04:21:05 | Franklin, Tennessee, US | |
3379718 | 3379718 | 2022-12-08 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-09 04:21:05 | Lincoln, North Carolina, US | |
3379705 | 3379705 | 2022-12-08 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-09 04:21:05 | Halifax, North Carolina, US | |
1987590 | 1987590 | 2022-12-07 | US | Tennessee | Franklin | 47051 | 15371 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-08 04:21:07 | Franklin, Tennessee, US | |
1986989 | 1986989 | 2022-12-07 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-08 04:21:07 | Lincoln, North Carolina, 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]);