daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where confirmed = 5039 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-21 | US | Illinois | Jo Daviess | 17085 | 5039 | 45 | 0 | 42.36542373 | -90.21094405 | 2022-12-22 04:20:56 | Jo Daviess, Illinois, US | |
2022-12-05 | US | Illinois | De Witt | 17039 | 5039 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-06 04:21:03 | De Witt, Illinois, US | |
2022-11-30 | US | Arkansas | Grant | 5053 | 5039 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-01 04:21:03 | Grant, Arkansas, US | |
2022-11-29 | US | Arkansas | Grant | 5053 | 5039 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-30 04:21:07 | Grant, Arkansas, US | |
2022-11-06 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-07 04:21:26 | Breathitt, Kentucky, US | |
2022-11-05 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-06 04:21:24 | Breathitt, Kentucky, US | |
2022-11-04 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-05 04:21:52 | Breathitt, Kentucky, US | |
2022-11-03 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-04 04:22:11 | Breathitt, Kentucky, US | |
2022-11-02 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-03 04:22:05 | Breathitt, Kentucky, US | |
2022-11-01 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-02 04:22:09 | Breathitt, Kentucky, US | |
2022-10-31 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-01 04:22:36 | Breathitt, Kentucky, US | |
2022-10-18 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-19 04:22:26 | Putnam, Georgia, US | |
2022-10-17 | US | Illinois | Hancock | 17067 | 5039 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-18 04:22:42 | Hancock, Illinois, US | |
2022-10-17 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-18 04:22:42 | Putnam, Georgia, US | |
2022-10-16 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-17 04:20:31 | Putnam, Georgia, US | |
2022-10-15 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-16 04:22:39 | Putnam, Georgia, US | |
2022-10-14 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-15 04:22:00 | Putnam, Georgia, US | |
2022-10-13 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-14 04:22:28 | Putnam, Georgia, US | |
2022-10-12 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-13 04:22:39 | Putnam, Georgia, US | |
2022-10-08 | US | Puerto Rico | Penuelas | 72111 | 5039 | 0 | 0 | 18.059645 | -66.721572 | 2022-10-09 04:21:16 | Penuelas, Puerto Rico, US | |
2022-09-12 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-13 04:20:57 | Washington, Maine, US | |
2022-09-11 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-12 04:20:58 | Washington, Maine, US | |
2022-09-10 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-11 04:20:50 | Washington, Maine, US | |
2022-09-07 | US | Illinois | White | 17193 | 5039 | 52 | 0 | 38.08706198 | -88.17657461 | 2022-09-08 04:21:02 | White, Illinois, US | |
2022-08-16 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-17 04:20:59 | Jackson, Iowa, US | |
2022-08-15 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-16 04:20:58 | Jackson, Iowa, US | |
2022-08-14 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-15 04:20:59 | Reeves, Texas, US | |
2022-08-14 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-15 04:20:59 | Jackson, Iowa, US | |
2022-08-13 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-14 04:20:55 | Reeves, Texas, US | |
2022-08-13 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-14 04:20:55 | Jackson, Iowa, US | |
2022-08-12 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-13 04:20:52 | Reeves, Texas, US | |
2022-08-12 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-13 04:20:52 | Jackson, Iowa, US | |
2022-08-11 | US | Virginia | Bristol | 51520 | 5039 | 84 | 0 | 36.6163024 | -82.16359122 | 2022-08-12 04:20:54 | Bristol, Virginia, US | |
2022-08-11 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-12 04:20:54 | Jackson, Iowa, US | |
2022-08-10 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-11 04:20:49 | Jackson, Iowa, US | |
2022-07-28 | US | Arkansas | Hempstead | 5057 | 5039 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-07-29 04:20:45 | Hempstead, Arkansas, US | |
2022-07-27 | US | Tennessee | Polk | 47139 | 5039 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-28 04:20:56 | Polk, Tennessee, US | |
2022-07-26 | US | Texas | Deaf Smith | 48117 | 5039 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-07-27 04:21:04 | Deaf Smith, Texas, US | |
2022-07-17 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-18 04:20:59 | Jay, Indiana, US | |
2022-07-16 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-17 04:21:15 | Jay, Indiana, US | |
2022-07-15 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-16 04:21:05 | Jay, Indiana, US | |
2022-07-03 | US | Tennessee | Humphreys | 47085 | 5039 | 77 | 0 | 36.03958805 | -87.77992872 | 2022-07-04 04:20:54 | Humphreys, Tennessee, US | |
2022-07-03 | US | Colorado | Alamosa | 8003 | 5039 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-04 04:20:54 | Alamosa, Colorado, US | |
2022-06-21 | US | Texas | Scurry | 48415 | 5039 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-22 04:20:54 | Scurry, Texas, US | |
2022-04-17 | US | Puerto Rico | Las Piedras | 72085 | 5039 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-04-18 04:21:12 | Las Piedras, Puerto Rico, US | |
2022-04-14 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-15 04:20:57 | McDuffie, Georgia, US | |
2022-04-13 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-13 23:21:06 | McDuffie, Georgia, US | |
2022-04-12 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-13 04:21:03 | McDuffie, Georgia, US | |
2022-03-22 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-22 23:20:51 | Vernon, Missouri, US | |
2022-03-20 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-21 04:20:50 | Vernon, Missouri, US | |
2022-03-19 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-20 04:20:45 | Vernon, Missouri, US | |
2022-03-18 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-19 04:20:47 | Vernon, Missouri, US | |
2022-03-17 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-18 04:20:55 | Vernon, Missouri, US | |
2022-03-16 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-17 04:20:56 | Vernon, Missouri, US | |
2022-03-15 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-16 04:20:50 | Vernon, Missouri, US | |
2022-03-14 | US | Missouri | Vernon | 29217 | 5039 | 103 | 0 | 37.8457799 | -94.34127305 | 2022-03-15 04:20:47 | Vernon, Missouri, US | |
2022-03-09 | US | Pennsylvania | Wyoming | 42131 | 5039 | 103 | 0 | 41.51955538 | -76.01074915 | 2022-03-10 04:20:48 | Wyoming, Pennsylvania, US | |
2022-02-27 | US | Alabama | Randolph | 1111 | 5039 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-02-28 04:21:05 | Randolph, Alabama, US | |
2022-02-26 | US | Alabama | Randolph | 1111 | 5039 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-02-27 04:21:04 | Randolph, Alabama, US | |
2022-02-22 | US | Arkansas | Ashley | 5003 | 5039 | 59 | 0 | 33.19153461 | -91.76984709999999 | 2022-02-23 04:21:09 | Ashley, Arkansas, US | |
2022-02-18 | US | Alabama | Cherokee | 1019 | 5039 | 77 | 0 | 34.17805983 | -85.60638968 | 2022-02-19 04:21:11 | Cherokee, Alabama, US | |
2022-02-17 | US | Texas | Limestone | 48293 | 5039 | 118 | 0 | 31.5454767 | -96.58095444 | 2022-02-18 04:21:04 | Limestone, Texas, US | |
2022-02-13 | US | North Carolina | Caswell | 37033 | 5039 | 40 | 0 | 36.39312665 | -79.33353281 | 2022-02-14 04:20:51 | Caswell, North Carolina, US | |
2022-02-12 | US | North Carolina | Caswell | 37033 | 5039 | 40 | 0 | 36.39312665 | -79.33353281 | 2022-02-13 04:21:00 | Caswell, North Carolina, US | |
2022-02-11 | US | North Carolina | Caswell | 37033 | 5039 | 40 | 0 | 36.39312665 | -79.33353281 | 2022-02-12 04:21:06 | Caswell, North Carolina, US | |
2022-02-10 | US | North Carolina | Caswell | 37033 | 5039 | 40 | 0 | 36.39312665 | -79.33353281 | 2022-02-11 04:21:09 | Caswell, North Carolina, US | |
2022-02-05 | US | Texas | Gillespie | 48171 | 5039 | 100 | 0 | 30.31824095 | -98.94676915 | 2022-02-06 04:21:00 | Gillespie, Texas, US | |
2022-02-01 | US | Alabama | Monroe | 1099 | 5039 | 70 | 0 | 31.56729412 | -87.36995001 | 2022-02-02 04:21:09 | Monroe, Alabama, US | |
2022-01-31 | US | Hawaii | Out of HI | 80015 | 5039 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-01 04:21:11 | Out of HI, Hawaii, US | |
2022-01-27 | US | Georgia | Franklin | 13119 | 5039 | 90 | 0 | 34.37525597 | -83.23159927 | 2022-01-28 04:21:09 | Franklin, Georgia, US | |
2022-01-26 | US | Oregon | Crook | 41013 | 5039 | 62 | 0 | 44.14230227 | -120.356297 | 2022-01-27 04:21:19 | Crook, Oregon, US | |
2022-01-24 | US | North Carolina | Greene | 37079 | 5039 | 56 | 0 | 35.48544173 | -77.67578087 | 2022-01-25 04:21:05 | Greene, North Carolina, US | |
2022-01-03 | US | North Carolina | Cherokee | 37039 | 5039 | 89 | 0 | 35.1349263 | -84.05970864 | 2022-01-04 04:22:17 | Cherokee, North Carolina, US | |
2021-12-26 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-27 04:21:58 | Itawamba, Mississippi, US | |
2021-12-25 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-26 04:21:50 | Itawamba, Mississippi, US | |
2021-12-24 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-25 04:21:37 | Itawamba, Mississippi, US | |
2021-12-23 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-24 04:21:34 | Itawamba, Mississippi, US | |
2021-12-23 | Denmark | Faroe Islands | 5039 | 13 | 0 | 61.8926 | -6.9118 | 2021-12-24 04:21:34 | Faroe Islands, Denmark | |||
2021-12-22 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-23 04:21:21 | Itawamba, Mississippi, US | |
2021-12-20 | US | Texas | Palo Pinto | 48363 | 5039 | 126 | 0 | 32.75310985 | -98.31319001 | 2021-12-21 03:21:27 | Palo Pinto, Texas, US | |
2021-12-15 | US | Mississippi | Tippah | 28139 | 5039 | 85 | 0 | 34.76872156 | -88.90988194 | 2021-12-16 04:22:11 | Tippah, Mississippi, US | |
2021-11-30 | US | Texas | Hutchinson | 48233 | 5039 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-12-01 04:22:29 | Hutchinson, Texas, US | |
2021-11-21 | US | Vermont | Rutland | 50021 | 5039 | 30 | 0 | 43.57723578 | -73.03741676 | 2021-11-22 04:22:20 | Rutland, Vermont, US | |
2021-11-21 | US | New York | Wyoming | 36121 | 5039 | 63 | 0 | 42.70145109 | -78.22199579 | 2021-11-22 04:22:20 | Wyoming, New York, US | |
2021-11-16 | US | Virginia | Smyth | 51173 | 5039 | 121 | 0 | 36.84455636 | -81.53344948 | 2021-11-17 04:21:48 | Smyth, Virginia, US | |
2021-11-14 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-15 04:21:36 | Unassigned, New Mexico, US | |
2021-11-13 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-14 04:21:31 | Unassigned, New Mexico, US | |
2021-11-12 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-13 04:21:38 | Unassigned, New Mexico, US | |
2021-11-11 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-12 04:22:01 | Unassigned, New Mexico, US | |
2021-11-10 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-11 04:21:45 | Unassigned, New Mexico, US | |
2021-11-09 | US | North Carolina | Macon | 37113 | 5039 | 73 | 0 | 35.14867843 | -83.41696617 | 2021-11-10 04:21:38 | Macon, North Carolina, US | |
2021-11-09 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-10 04:21:38 | Unassigned, New Mexico, US | |
2021-11-06 | US | Texas | Willacy | 48489 | 5039 | 110 | 0 | 26.47411727 | -97.61535848 | 2021-11-07 04:21:53 | Willacy, Texas, US | |
2021-11-04 | US | New York | Allegany | 36003 | 5039 | 105 | 0 | 42.25748406 | -78.02750466 | 2021-11-05 04:21:54 | Allegany, New York, US | |
2021-10-31 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-11-01 04:22:01 | Sanilac, Michigan, US | |
2021-10-30 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-10-31 04:22:08 | Sanilac, Michigan, US | |
2021-10-29 | US | Pennsylvania | Clinton | 42035 | 5039 | 77 | 0 | 41.23255967 | -77.63785995 | 2021-10-30 04:22:03 | Clinton, Pennsylvania, US | |
2021-10-29 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-10-30 04:22:03 | Sanilac, Michigan, US | |
2021-10-20 | US | Ohio | Jackson | 39079 | 5039 | 86 | 0 | 39.01914254 | -82.61818559999998 | 2021-10-21 04:21:18 | Jackson, Ohio, US | |
2021-10-14 | US | Wyoming | Teton | 56039 | 5039 | 13 | 0 | 43.93522482 | -110.5890801 | 2021-10-15 04:21:26 | Teton, Wyoming, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;