johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
108 rows where confirmed = 6244 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
504160 | 504160 | 2022-12-17 | US | Arkansas | Clark | 5019 | 6244 | 90 | 0 | 34.04613432 | -93.17484713 | 2022-12-18 04:21:03 | Clark, Arkansas, US | |
386993 | 386993 | 2022-09-23 | US | Puerto Rico | Naguabo | 72103 | 6244 | 0 | 0 | 18.230637 | -65.753897 | 2022-09-24 04:21:40 | Naguabo, Puerto Rico, US | |
3373839 | 3373839 | 2022-09-17 | US | Arkansas | Columbia | 5027 | 6244 | 99 | 0 | 33.21230701 | -93.22642793 | 2022-09-18 04:22:50 | Columbia, Arkansas, US | |
3768522 | 3768522 | 2022-09-11 | US | Oregon | Wasco | 41065 | 6244 | 70 | 0 | 45.16292781 | -121.1670954 | 2022-09-12 04:20:58 | Wasco, Oregon, US | |
3827097 | 3827097 | 2022-09-10 | US | Oregon | Wasco | 41065 | 6244 | 70 | 0 | 45.16292781 | -121.1670954 | 2022-09-11 04:20:50 | Wasco, Oregon, US | |
965554 | 965554 | 2022-09-09 | US | Oregon | Wasco | 41065 | 6244 | 70 | 0 | 45.16292781 | -121.1670954 | 2022-09-10 04:21:10 | Wasco, Oregon, US | |
2343941 | 2343941 | 2022-08-31 | US | Arkansas | Ouachita | 5103 | 6244 | 113 | 0 | 33.58839816 | -92.87795984 | 2022-09-01 04:21:03 | Ouachita, Arkansas, US | |
3777190 | 3777190 | 2022-08-30 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-31 04:20:57 | Caledonia, Vermont, US | |
1683786 | 1683786 | 2022-08-29 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-30 04:21:03 | Caledonia, Vermont, US | |
1880270 | 1880270 | 2022-08-28 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-29 04:21:06 | Caledonia, Vermont, US | |
2099397 | 2099397 | 2022-08-27 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-28 04:21:02 | Caledonia, Vermont, US | |
1535212 | 1535212 | 2022-08-26 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-27 04:20:57 | Caledonia, Vermont, US | |
2832099 | 2832099 | 2022-08-25 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-26 04:21:02 | Caledonia, Vermont, US | |
2326632 | 2326632 | 2022-08-24 | US | Vermont | Caledonia | 50005 | 6244 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-08-25 04:21:13 | Caledonia, Vermont, US | |
1971529 | 1971529 | 2022-08-13 | US | Tennessee | Fentress | 47049 | 6244 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-08-14 04:20:55 | Fentress, Tennessee, US | |
1099701 | 1099701 | 2022-08-03 | US | Maryland | Garrett | 24023 | 6244 | 115 | 0 | 39.52786077 | -79.27355126 | 2022-08-04 04:20:58 | Garrett, Maryland, US | |
1068918 | 1068918 | 2022-07-28 | US | Texas | Calhoun | 48057 | 6244 | 51 | 0 | 28.47048236 | -96.61633945 | 2022-07-29 04:20:45 | Calhoun, Texas, US | |
2594380 | 2594380 | 2022-07-25 | US | Alabama | Barbour | 1005 | 6244 | 100 | 0 | 31.868263 | -85.3871286 | 2022-07-26 04:20:58 | Barbour, Alabama, US | |
94068 | 94068 | 2022-07-23 | US | Tennessee | Chester | 47023 | 6244 | 99 | 0 | 35.42527478 | -88.6095842 | 2022-07-24 04:20:47 | Chester, Tennessee, US | |
3213698 | 3213698 | 2022-07-18 | US | Virginia | Staunton | 51790 | 6244 | 117 | 0 | 38.15965544 | -79.05979937 | 2022-07-19 04:20:58 | Staunton, Virginia, US | |
2242824 | 2242824 | 2022-06-28 | US | Virginia | Waynesboro | 51820 | 6244 | 68 | 0 | 38.06451466 | -78.90293905 | 2022-06-29 04:20:59 | Waynesboro, Virginia, US | |
2314404 | 2314404 | 2022-06-17 | US | Texas | Gray | 48179 | 6244 | 127 | 0 | 35.40081878 | -100.8129222 | 2022-06-18 04:21:10 | Gray, Texas, US | |
2311773 | 2311773 | 2022-06-17 | US | Arkansas | Carroll | 5015 | 6244 | 105 | 0 | 36.3403856 | -93.54270261 | 2022-06-18 04:21:10 | Carroll, Arkansas, US | |
559730 | 559730 | 2022-06-16 | US | Idaho | Blaine | 16013 | 6244 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-06-17 04:20:56 | Blaine, Idaho, US | |
559277 | 559277 | 2022-06-16 | US | Arkansas | Carroll | 5015 | 6244 | 105 | 0 | 36.3403856 | -93.54270261 | 2022-06-17 04:20:56 | Carroll, Arkansas, US | |
3983532 | 3983532 | 2022-06-15 | US | Idaho | Blaine | 16013 | 6244 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-06-16 04:20:55 | Blaine, Idaho, US | |
3159193 | 3159193 | 2022-06-09 | US | Maine | Franklin | 23007 | 6244 | 62 | 0 | 44.97330019 | -70.44381045 | 2022-06-10 04:20:55 | Franklin, Maine, US | |
232206 | 232206 | 2022-05-31 | US | Tennessee | Morgan | 47129 | 6244 | 87 | 0 | 36.13248031 | -84.64880098 | 2022-06-01 04:20:55 | Morgan, Tennessee, US | |
1851568 | 1851568 | 2022-05-26 | US | Maryland | Caroline | 24011 | 6244 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-05-27 04:20:56 | Caroline, Maryland, US | |
3583502 | 3583502 | 2022-05-17 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-18 04:20:50 | Peach, Georgia, US | |
1504459 | 1504459 | 2022-05-16 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-17 04:20:59 | Peach, Georgia, US | |
2084818 | 2084818 | 2022-05-15 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-16 04:20:47 | Peach, Georgia, US | |
3355528 | 3355528 | 2022-05-14 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-15 04:20:53 | Peach, Georgia, US | |
659173 | 659173 | 2022-05-13 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-14 04:20:48 | Peach, Georgia, US | |
2534256 | 2534256 | 2022-05-12 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-13 04:20:51 | Peach, Georgia, US | |
3445702 | 3445702 | 2022-05-11 | US | Georgia | Peach | 13225 | 6244 | 133 | 0 | 32.56934316 | -83.82937 | 2022-05-12 04:20:54 | Peach, Georgia, US | |
1573184 | 1573184 | 2022-05-03 | US | Illinois | Shelby | 17173 | 6244 | 77 | 0 | 39.39133527 | -88.80611122 | 2022-05-04 04:20:59 | Shelby, Illinois, US | |
464037 | 464037 | 2022-05-02 | US | Colorado | Montezuma | 8083 | 6244 | 82 | 0 | 37.33859579 | -108.5958857 | 2022-05-03 04:21:00 | Montezuma, Colorado, US | |
879014 | 879014 | 2022-03-27 | US | Puerto Rico | Isabela | 72071 | 6244 | 0 | 0 | 18.44981 | -67.005093 | 2022-03-28 04:20:33 | Isabela, Puerto Rico, US | |
3628832 | 3628832 | 2022-03-13 | US | Georgia | Stephens | 13257 | 6244 | 139 | 0 | 34.55151201 | -83.29405315 | 2022-03-14 04:20:46 | Stephens, Georgia, US | |
951740 | 951740 | 2022-03-12 | US | Georgia | Stephens | 13257 | 6244 | 139 | 0 | 34.55151201 | -83.29405315 | 2022-03-13 04:20:49 | Stephens, Georgia, US | |
357201 | 357201 | 2022-03-11 | US | Georgia | Stephens | 13257 | 6244 | 139 | 0 | 34.55151201 | -83.29405315 | 2022-03-12 04:20:50 | Stephens, Georgia, US | |
1467681 | 1467681 | 2022-02-10 | US | Wisconsin | Waushara | 55137 | 6244 | 78 | 0 | 44.11324419 | -89.24317107 | 2022-02-11 04:21:09 | Waushara, Wisconsin, US | |
1362700 | 1362700 | 2022-02-08 | US | Alabama | Bibb | 1007 | 6244 | 96 | 0 | 32.99642064 | -87.12511459999996 | 2022-02-09 04:21:04 | Bibb, Alabama, US | |
1142069 | 1142069 | 2022-01-23 | US | Indiana | White | 18181 | 6244 | 84 | 0 | 40.74911165 | -86.86492015 | 2022-01-24 04:21:12 | White, Indiana, US | |
2833987 | 2833987 | 2022-01-22 | US | Indiana | White | 18181 | 6244 | 84 | 0 | 40.74911165 | -86.86492015 | 2022-01-23 04:21:13 | White, Indiana, US | |
3426105 | 3426105 | 2022-01-21 | US | Indiana | White | 18181 | 6244 | 84 | 0 | 40.74911165 | -86.86492015 | 2022-01-22 04:21:13 | White, Indiana, US | |
3229226 | 3229226 | 2022-01-19 | US | Puerto Rico | Rio Grande | 72119 | 6244 | 0 | 0 | 18.346329 | -65.813742 | 2022-01-20 04:21:07 | Rio Grande, Puerto Rico, US | |
1435046 | 1435046 | 2021-12-28 | US | Ohio | Jackson | 39079 | 6244 | 116 | 0 | 39.01914254 | -82.61818559999998 | 2021-12-29 03:21:43 | Jackson, Ohio, US | |
732247 | 732247 | 2021-12-27 | US | Minnesota | Freeborn | 27047 | 6244 | 51 | 0 | 43.67385583 | -93.34884422 | 2021-12-28 04:21:47 | Freeborn, Minnesota, US | |
1718110 | 1718110 | 2021-12-16 | US | Minnesota | Polk | 27119 | 6244 | 90 | 0 | 47.77372465 | -96.40134647 | 2021-12-17 04:22:14 | Polk, Minnesota, US | |
783494 | 783494 | 2021-12-13 | US | Indiana | Jefferson | 18077 | 6244 | 107 | 0 | 38.78576239 | -85.43633383 | 2021-12-14 04:22:38 | Jefferson, Indiana, US | |
407376 | 407376 | 2021-12-07 | US | Texas | Erath | 48143 | 6244 | 108 | 0 | 32.23602653 | -98.21773417 | 2021-12-08 04:22:46 | Erath, Texas, US | |
406903 | 406903 | 2021-12-07 | US | Oregon | Benton | 41003 | 6244 | 40 | 0 | 44.49167306 | -123.4316987 | 2021-12-08 04:22:46 | Benton, Oregon, US | |
2198301 | 2198301 | 2021-12-03 | US | Pennsylvania | Jefferson | 42065 | 6244 | 153 | 0 | 41.12913106 | -78.9986361 | 2021-12-04 04:22:18 | Jefferson, Pennsylvania, US | |
2198132 | 2198132 | 2021-12-03 | US | Ohio | Putnam | 39137 | 6244 | 129 | 0 | 41.02094889 | -84.1336111 | 2021-12-04 04:22:18 | Putnam, Ohio, US | |
444472 | 444472 | 2021-10-20 | US | Indiana | Montgomery | 18107 | 6244 | 109 | 0 | 40.04034823 | -86.89335024 | 2021-10-21 04:21:18 | Montgomery, Indiana, US | |
2046087 | 2046087 | 2021-10-18 | US | New York | Fulton | 36035 | 6244 | 102 | 0 | 43.11363907 | -74.41798804 | 2021-10-19 04:20:54 | Fulton, New York, US | |
3834922 | 3834922 | 2021-10-05 | US | North Dakota | Williams | 38105 | 6244 | 44 | 0 | 48.34522353 | -103.4793387 | 2021-10-06 04:21:33 | Williams, North Dakota, US | |
987484 | 987484 | 2021-10-04 | US | Arkansas | Miller | 5091 | 6244 | 47 | 0 | 33.31403423 | -93.89285258 | 2021-10-05 04:21:27 | Miller, Arkansas, US | |
708812 | 708812 | 2021-09-29 | US | North Carolina | Watauga | 37189 | 6244 | 34 | 0 | 36.23103603 | -81.70033724 | 2021-09-30 04:21:20 | Watauga, North Carolina, US | |
602281 | 602281 | 2021-09-23 | US | California | Tuolumne | 6109 | 6244 | 89 | 0 | 38.02644018 | -119.95250929999999 | 2021-09-24 04:21:44 | Tuolumne, California, US | |
3012879 | 3012879 | 2021-09-22 | US | Louisiana | Webster | 22119 | 6244 | 141 | 0 | 32.70847669 | -93.33121835 | 2021-09-23 04:21:43 | Webster, Louisiana, US | |
2280855 | 2280855 | 2021-09-08 | US | Minnesota | Benton | 27009 | 6244 | 98 | 0 | 45.69804958 | -93.99514135 | 2021-09-09 04:21:27 | Benton, Minnesota, US | |
3894407 | 3894407 | 2021-08-29 | US | Ohio | Jefferson | 39081 | 6244 | 171 | 0 | 40.38614126 | -80.76259514 | 2021-08-30 04:21:23 | Jefferson, Ohio, US | |
1598866 | 1598866 | 2021-08-26 | US | Pennsylvania | Columbia | 42037 | 6244 | 136 | 0 | 41.04821986 | -76.40565017 | 2021-08-27 04:21:37 | Columbia, Pennsylvania, US | |
1597954 | 1597954 | 2021-08-26 | US | Minnesota | Otter Tail | 27111 | 6244 | 88 | 0 | 46.40846929 | -95.70835255 | 2021-08-27 04:21:37 | Otter Tail, Minnesota, US | |
35948 | 35948 | 2021-08-25 | US | Wisconsin | Columbia | 55021 | 6244 | 75 | 0 | 43.46492199 | -89.33589004 | 2021-08-26 04:21:28 | Columbia, Wisconsin, US | |
3470353 | 3470353 | 2021-08-03 | US | New Jersey | Salem | 34033 | 6244 | 189 | 0 | 39.58719656 | -75.34696629999998 | 2021-08-04 04:21:25 | Salem, New Jersey, US | |
3469635 | 3469635 | 2021-08-03 | US | Kentucky | Pike | 21195 | 6244 | 113 | 0 | 37.47088263 | -82.39487445 | 2021-08-04 04:21:25 | Pike, Kentucky, US | |
3742108 | 3742108 | 2021-07-12 | US | Illinois | Ogle | 17141 | 6244 | 84 | 0 | 42.04165196 | -89.32184679 | 2021-07-13 04:21:18 | Ogle, Illinois, US | |
3660621 | 3660621 | 2021-07-11 | US | Illinois | Ogle | 17141 | 6244 | 84 | 0 | 42.04165196 | -89.32184679 | 2021-07-12 04:21:34 | Ogle, Illinois, US | |
626905 | 626905 | 2021-07-10 | US | Illinois | Ogle | 17141 | 6244 | 84 | 0 | 42.04165196 | -89.32184679 | 2021-07-11 04:21:43 | Ogle, Illinois, US | |
832559 | 832559 | 2021-07-09 | US | Tennessee | Loudon | 47105 | 6244 | 71 | 0 | 35.73939663 | -84.31145275 | 2021-07-10 04:21:25 | Loudon, Tennessee, US | |
830624 | 830624 | 2021-07-09 | US | Illinois | Ogle | 17141 | 6244 | 84 | 0 | 42.04165196 | -89.32184679 | 2021-07-10 04:21:25 | Ogle, Illinois, US | |
779388 | 779388 | 2021-07-08 | US | Illinois | Ogle | 17141 | 6244 | 84 | 0 | 42.04165196 | -89.32184679 | 2021-07-09 04:21:21 | Ogle, Illinois, US | |
3972232 | 3972232 | 2021-06-11 | US | Michigan | St. Joseph | 26149 | 6244 | 99 | 0 | 41.91441767 | -85.52797979 | 2021-06-12 04:22:22 | St. Joseph, Michigan, US | |
3574626 | 3574626 | 2021-05-17 | Japan | Okayama | 6244 | 73 | 4071 | 2100 | 34.89246 | 133.826252 | 2021-05-18 04:20:33 | Okayama, Japan | ||
1082626 | 1082626 | 2021-05-14 | US | Florida | Jackson | 12063 | 6244 | 157 | 0 | 30.7954597 | -85.21500423 | 2021-05-15 04:20:58 | Jackson, Florida, US | |
3394156 | 3394156 | 2021-04-28 | US | Georgia | Catoosa | 13047 | 6244 | 69 | 0 | 34.89872298 | -85.13757014 | 2021-04-29 04:20:55 | Catoosa, Georgia, US | |
1570405 | 1570405 | 2021-04-22 | US | North Carolina | Columbus | 37047 | 6244 | 150 | 0 | 34.26744084 | -78.65801424 | 2021-04-23 04:20:52 | Columbus, North Carolina, US | |
1568460 | 1568460 | 2021-04-22 | US | Alabama | Colbert | 1033 | 6244 | 133 | 0 | 34.69847452 | -87.80168544 | 2021-04-23 04:20:52 | Colbert, Alabama, US | |
243690 | 243690 | 2021-04-02 | US | Ohio | Ashtabula | 39007 | 6244 | 170 | 0 | 41.70860332 | -80.74830218 | 2021-04-03 04:20:44 | Ashtabula, Ohio, US | |
1882095 | 1882095 | 2021-03-26 | US | Indiana | Morgan | 18109 | 6244 | 135 | 0 | 39.47899078 | -86.44573375 | 2021-03-27 05:25:04 | Morgan, Indiana, US | |
1983222 | 1983222 | 2021-03-25 | US | Oregon | Deschutes | 41017 | 6244 | 70 | 0 | 43.91570171 | -121.2289121 | 2021-03-26 05:26:55 | Deschutes, Oregon, US | |
1801010 | 1801010 | 2021-03-23 | US | North Carolina | Wilkes | 37193 | 6244 | 104 | 0 | 36.2084135 | -81.16232895 | 2021-03-24 05:25:40 | Wilkes, North Carolina, US | |
1204519 | 1204519 | 2021-03-22 | US | Florida | Monroe | 12087 | 6244 | 48 | 0 | 25.20904673 | -81.07812416 | 2021-03-23 05:26:18 | Monroe, Florida, US | |
2467597 | 2467597 | 2021-01-22 | US | Georgia | Fayette | 13113 | 6244 | 103 | 0 | 6141 | 33.41357794 | -84.49089434 | 2021-01-23 05:22:03 | Fayette, Georgia, US |
3883064 | 3883064 | 2021-01-14 | US | West Virginia | Monongalia | 54061 | 6244 | 51 | 0 | 6193 | 39.63218457 | -80.04766838 | 2021-01-15 05:22:24 | Monongalia, West Virginia, US |
2229855 | 2229855 | 2021-01-02 | US | North Carolina | Nash | 37127 | 6244 | 120 | 0 | 6124 | 35.96575634 | -77.98422508 | 2021-01-03 05:22:52 | Nash, North Carolina, US |
204126 | 204126 | 2020-12-25 | US | Missouri | Cape Girardeau | 29031 | 6244 | 94 | 0 | 6150 | 37.38489388 | -89.6843587 | 2020-12-26 05:22:28 | Cape Girardeau, Missouri, US |
2936713 | 2936713 | 2020-11-28 | US | Louisiana | Bossier | 22015 | 6244 | 152 | 0 | 6092 | 32.67932307 | -93.60460152 | 2020-11-29 05:25:55 | Bossier, Louisiana, US |
393716 | 393716 | 2020-11-27 | US | Louisiana | Bossier | 22015 | 6244 | 152 | 0 | 6092 | 32.67932307 | -93.60460152 | 2020-11-28 05:25:50 | Bossier, Louisiana, US |
3193357 | 3193357 | 2020-11-22 | US | Virginia | Norfolk | 51710 | 6244 | 88 | 0 | 6156 | 36.89934014 | -76.26420872 | 2020-11-23 05:25:26 | Norfolk, Virginia, US |
3191647 | 3191647 | 2020-11-22 | US | Michigan | Muskegon | 26121 | 6244 | 145 | 0 | 6099 | 43.29123859 | -86.15176712 | 2020-11-23 05:25:26 | Muskegon, Michigan, US |
3838141 | 3838141 | 2020-11-21 | US | Michigan | Muskegon | 26121 | 6244 | 145 | 0 | 6099 | 43.29123859 | -86.15176712 | 2020-11-22 05:25:45 | Muskegon, Michigan, US |
126371 | 126371 | 2020-11-18 | China | Unknown | 6244 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, China | ||||
1453297 | 1453297 | 2020-10-27 | US | Florida | Okaloosa | 12091 | 6244 | 130 | 0 | 6114 | 30.69143028 | -86.59267105 | 2020-10-28 04:24:39 | Okaloosa, Florida, US |
2857684 | 2857684 | 2020-10-16 | US | Georgia | Muscogee | 13215 | 6244 | 173 | 0 | 6071 | 32.50931999 | -84.87142262 | 2020-10-17 04:24:12 | Muscogee, Georgia, US |
2379590 | 2379590 | 2020-10-01 | India | Nagaland | 6244 | 17 | 5144 | 1083 | 26.06702 | 94.470302 | 2020-10-02 04:23:51 | Nagaland, India |
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]);