johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
452395 | 452395 | 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 | |
2415858 | 2415858 | 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 | |
1965066 | 1965066 | 2022-11-30 | US | Arkansas | Grant | 5053 | 5039 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-01 04:21:03 | Grant, Arkansas, US | |
2557080 | 2557080 | 2022-11-29 | US | Arkansas | Grant | 5053 | 5039 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-30 04:21:07 | Grant, Arkansas, US | |
1051220 | 1051220 | 2022-11-06 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-07 04:21:26 | Breathitt, Kentucky, US | |
619244 | 619244 | 2022-11-05 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-06 04:21:24 | Breathitt, Kentucky, US | |
1023748 | 1023748 | 2022-11-04 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-05 04:21:52 | Breathitt, Kentucky, US | |
432739 | 432739 | 2022-11-03 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-04 04:22:11 | Breathitt, Kentucky, US | |
850981 | 850981 | 2022-11-02 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-03 04:22:05 | Breathitt, Kentucky, US | |
711832 | 711832 | 2022-11-01 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-02 04:22:09 | Breathitt, Kentucky, US | |
3286281 | 3286281 | 2022-10-31 | US | Kentucky | Breathitt | 21025 | 5039 | 66 | 0 | 37.52333168 | -83.31959161 | 2022-11-01 04:22:36 | Breathitt, Kentucky, US | |
2757788 | 2757788 | 2022-10-18 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-19 04:22:26 | Putnam, Georgia, US | |
2025752 | 2025752 | 2022-10-17 | US | Illinois | Hancock | 17067 | 5039 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-18 04:22:42 | Hancock, Illinois, US | |
2025622 | 2025622 | 2022-10-17 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-18 04:22:42 | Putnam, Georgia, US | |
2160400 | 2160400 | 2022-10-16 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-17 04:20:31 | Putnam, Georgia, US | |
516597 | 516597 | 2022-10-15 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-16 04:22:39 | Putnam, Georgia, US | |
2033654 | 2033654 | 2022-10-14 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-15 04:22:00 | Putnam, Georgia, US | |
3754342 | 3754342 | 2022-10-13 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-14 04:22:28 | Putnam, Georgia, US | |
3215167 | 3215167 | 2022-10-12 | US | Georgia | Putnam | 13237 | 5039 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-13 04:22:39 | Putnam, Georgia, US | |
4005442 | 4005442 | 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 | |
2396371 | 2396371 | 2022-09-12 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-13 04:20:57 | Washington, Maine, US | |
3767449 | 3767449 | 2022-09-11 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-12 04:20:58 | Washington, Maine, US | |
3826024 | 3826024 | 2022-09-10 | US | Maine | Washington | 23029 | 5039 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-11 04:20:50 | Washington, Maine, US | |
3746172 | 3746172 | 2022-09-07 | US | Illinois | White | 17193 | 5039 | 52 | 0 | 38.08706198 | -88.17657461 | 2022-09-08 04:21:02 | White, Illinois, US | |
992202 | 992202 | 2022-08-16 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-17 04:20:59 | Jackson, Iowa, US | |
2495241 | 2495241 | 2022-08-15 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-16 04:20:58 | Jackson, Iowa, US | |
3650790 | 3650790 | 2022-08-14 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-15 04:20:59 | Reeves, Texas, US | |
3648791 | 3648791 | 2022-08-14 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-15 04:20:59 | Jackson, Iowa, US | |
1971796 | 1971796 | 2022-08-13 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-14 04:20:55 | Reeves, Texas, US | |
1969797 | 1969797 | 2022-08-13 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-14 04:20:55 | Jackson, Iowa, US | |
2891605 | 2891605 | 2022-08-12 | US | Texas | Reeves | 48389 | 5039 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-08-13 04:20:52 | Reeves, Texas, US | |
2889606 | 2889606 | 2022-08-12 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-13 04:20:52 | Jackson, Iowa, US | |
3911314 | 3911314 | 2022-08-11 | US | Virginia | Bristol | 51520 | 5039 | 84 | 0 | 36.6163024 | -82.16359122 | 2022-08-12 04:20:54 | Bristol, Virginia, US | |
3909211 | 3909211 | 2022-08-11 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-12 04:20:54 | Jackson, Iowa, US | |
1347528 | 1347528 | 2022-08-10 | US | Iowa | Jackson | 19097 | 5039 | 71 | 0 | 42.17178824 | -90.57354837 | 2022-08-11 04:20:49 | Jackson, Iowa, US | |
1066369 | 1066369 | 2022-07-28 | US | Arkansas | Hempstead | 5057 | 5039 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-07-29 04:20:45 | Hempstead, Arkansas, US | |
2338382 | 2338382 | 2022-07-27 | US | Tennessee | Polk | 47139 | 5039 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-28 04:20:56 | Polk, Tennessee, US | |
1490658 | 1490658 | 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 | |
3406561 | 3406561 | 2022-07-17 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-18 04:20:59 | Jay, Indiana, US | |
2152761 | 2152761 | 2022-07-16 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-17 04:21:15 | Jay, Indiana, US | |
2419994 | 2419994 | 2022-07-15 | US | Indiana | Jay | 18075 | 5039 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-16 04:21:05 | Jay, Indiana, US | |
1770301 | 1770301 | 2022-07-03 | US | Tennessee | Humphreys | 47085 | 5039 | 77 | 0 | 36.03958805 | -87.77992872 | 2022-07-04 04:20:54 | Humphreys, Tennessee, US | |
1767944 | 1767944 | 2022-07-03 | US | Colorado | Alamosa | 8003 | 5039 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-04 04:20:54 | Alamosa, Colorado, US | |
169264 | 169264 | 2022-06-21 | US | Texas | Scurry | 48415 | 5039 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-22 04:20:54 | Scurry, Texas, US | |
3419676 | 3419676 | 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 | |
1224442 | 1224442 | 2022-04-14 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-15 04:20:57 | McDuffie, Georgia, US | |
2443600 | 2443600 | 2022-04-13 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-13 23:21:06 | McDuffie, Georgia, US | |
1949357 | 1949357 | 2022-04-12 | US | Georgia | McDuffie | 13189 | 5039 | 94 | 0 | 33.47851918 | -82.48252774 | 2022-04-13 04:21:03 | McDuffie, Georgia, US | |
1907174 | 1907174 | 2022-03-22 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-22 23:20:51 | Vernon, Missouri, US | |
26378 | 26378 | 2022-03-20 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-21 04:20:50 | Vernon, Missouri, US | |
1658388 | 1658388 | 2022-03-19 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-20 04:20:45 | Vernon, Missouri, US | |
337914 | 337914 | 2022-03-18 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-19 04:20:47 | Vernon, Missouri, US | |
696367 | 696367 | 2022-03-17 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-18 04:20:55 | Vernon, Missouri, US | |
2321310 | 2321310 | 2022-03-16 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-17 04:20:56 | Vernon, Missouri, US | |
263510 | 263510 | 2022-03-15 | US | Missouri | Vernon | 29217 | 5039 | 105 | 0 | 37.8457799 | -94.34127305 | 2022-03-16 04:20:50 | Vernon, Missouri, US | |
2265869 | 2265869 | 2022-03-14 | US | Missouri | Vernon | 29217 | 5039 | 103 | 0 | 37.8457799 | -94.34127305 | 2022-03-15 04:20:47 | Vernon, Missouri, US | |
2142885 | 2142885 | 2022-03-09 | US | Pennsylvania | Wyoming | 42131 | 5039 | 103 | 0 | 41.51955538 | -76.01074915 | 2022-03-10 04:20:48 | Wyoming, Pennsylvania, US | |
2733425 | 2733425 | 2022-02-27 | US | Alabama | Randolph | 1111 | 5039 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-02-28 04:21:05 | Randolph, Alabama, US | |
3046578 | 3046578 | 2022-02-26 | US | Alabama | Randolph | 1111 | 5039 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-02-27 04:21:04 | Randolph, Alabama, US | |
2447236 | 2447236 | 2022-02-22 | US | Arkansas | Ashley | 5003 | 5039 | 59 | 0 | 33.19153461 | -91.76984709999999 | 2022-02-23 04:21:09 | Ashley, Arkansas, US | |
3856187 | 3856187 | 2022-02-18 | US | Alabama | Cherokee | 1019 | 5039 | 77 | 0 | 34.17805983 | -85.60638968 | 2022-02-19 04:21:11 | Cherokee, Alabama, US | |
1301210 | 1301210 | 2022-02-17 | US | Texas | Limestone | 48293 | 5039 | 118 | 0 | 31.5454767 | -96.58095444 | 2022-02-18 04:21:04 | Limestone, Texas, US | |
188371 | 188371 | 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 | |
318217 | 318217 | 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 | |
235543 | 235543 | 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 | |
1466385 | 1466385 | 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 | |
1297132 | 1297132 | 2022-02-05 | US | Texas | Gillespie | 48171 | 5039 | 100 | 0 | 30.31824095 | -98.94676915 | 2022-02-06 04:21:00 | Gillespie, Texas, US | |
979342 | 979342 | 2022-02-01 | US | Alabama | Monroe | 1099 | 5039 | 70 | 0 | 31.56729412 | -87.36995001 | 2022-02-02 04:21:09 | Monroe, Alabama, US | |
2658705 | 2658705 | 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 | |
1780192 | 1780192 | 2022-01-27 | US | Georgia | Franklin | 13119 | 5039 | 90 | 0 | 34.37525597 | -83.23159927 | 2022-01-28 04:21:09 | Franklin, Georgia, US | |
1320829 | 1320829 | 2022-01-26 | US | Oregon | Crook | 41013 | 5039 | 62 | 0 | 44.14230227 | -120.356297 | 2022-01-27 04:21:19 | Crook, Oregon, US | |
1229937 | 1229937 | 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 | |
1702653 | 1702653 | 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 | |
2113512 | 2113512 | 2021-12-26 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-27 04:21:58 | Itawamba, Mississippi, US | |
3606884 | 3606884 | 2021-12-25 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-26 04:21:50 | Itawamba, Mississippi, US | |
2965202 | 2965202 | 2021-12-24 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-25 04:21:37 | Itawamba, Mississippi, US | |
3818234 | 3818234 | 2021-12-23 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-24 04:21:34 | Itawamba, Mississippi, US | |
3816281 | 3816281 | 2021-12-23 | Denmark | Faroe Islands | 5039 | 13 | 0 | 61.8926 | -6.9118 | 2021-12-24 04:21:34 | Faroe Islands, Denmark | |||
800242 | 800242 | 2021-12-22 | US | Mississippi | Itawamba | 28057 | 5039 | 108 | 0 | 34.27993475 | -88.3606733 | 2021-12-23 04:21:21 | Itawamba, Mississippi, US | |
1257965 | 1257965 | 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 | |
3498042 | 3498042 | 2021-12-15 | US | Mississippi | Tippah | 28139 | 5039 | 85 | 0 | 34.76872156 | -88.90988194 | 2021-12-16 04:22:11 | Tippah, Mississippi, US | |
3404568 | 3404568 | 2021-11-30 | US | Texas | Hutchinson | 48233 | 5039 | 94 | 0 | 35.84006574 | -101.3546643 | 2021-12-01 04:22:29 | Hutchinson, Texas, US | |
1017624 | 1017624 | 2021-11-21 | US | Vermont | Rutland | 50021 | 5039 | 30 | 0 | 43.57723578 | -73.03741676 | 2021-11-22 04:22:20 | Rutland, Vermont, US | |
1016616 | 1016616 | 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 | |
3346031 | 3346031 | 2021-11-16 | US | Virginia | Smyth | 51173 | 5039 | 121 | 0 | 36.84455636 | -81.53344948 | 2021-11-17 04:21:48 | Smyth, Virginia, US | |
1324448 | 1324448 | 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 | |
688574 | 688574 | 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 | |
716683 | 716683 | 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 | |
30633 | 30633 | 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 | |
2847072 | 2847072 | 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 | |
89464 | 89464 | 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 | |
89342 | 89342 | 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 | |
498908 | 498908 | 2021-11-06 | US | Texas | Willacy | 48489 | 5039 | 110 | 0 | 26.47411727 | -97.61535848 | 2021-11-07 04:21:53 | Willacy, Texas, US | |
700626 | 700626 | 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 | |
289680 | 289680 | 2021-10-31 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-11-01 04:22:01 | Sanilac, Michigan, US | |
2722686 | 2722686 | 2021-10-30 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-10-31 04:22:08 | Sanilac, Michigan, US | |
569765 | 569765 | 2021-10-29 | US | Pennsylvania | Clinton | 42035 | 5039 | 77 | 0 | 41.23255967 | -77.63785995 | 2021-10-30 04:22:03 | Clinton, Pennsylvania, US | |
568788 | 568788 | 2021-10-29 | US | Michigan | Sanilac | 26151 | 5039 | 136 | 0 | 43.42406072 | -82.82055898 | 2021-10-30 04:22:03 | Sanilac, Michigan, US | |
445833 | 445833 | 2021-10-20 | US | Ohio | Jackson | 39079 | 5039 | 86 | 0 | 39.01914254 | -82.61818559999998 | 2021-10-21 04:21:18 | Jackson, Ohio, US | |
495253 | 495253 | 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 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]);