johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
186 rows where confirmed = 4414 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753393 | 2753393 | 2022-12-29 | US | Arkansas | Franklin | 5047 | 4414 | 80 | 0 | 35.51202821 | -93.89299569 | 2022-12-30 04:21:04 | Franklin, Arkansas, US | |
1074399 | 1074399 | 2022-12-28 | US | Arkansas | Franklin | 5047 | 4414 | 80 | 0 | 35.51202821 | -93.89299569 | 2022-12-29 04:21:01 | Franklin, Arkansas, US | |
349326 | 349326 | 2022-12-14 | US | Illinois | Menard | 17129 | 4414 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-12-15 04:20:58 | Menard, Illinois, US | |
1151790 | 1151790 | 2022-12-12 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-13 04:21:01 | Saluda, South Carolina, US | |
871644 | 871644 | 2022-12-11 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-12 04:21:01 | Saluda, South Carolina, US | |
260174 | 260174 | 2022-12-10 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-11 04:20:50 | Saluda, South Carolina, US | |
3938888 | 3938888 | 2022-12-09 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-10 04:21:02 | Saluda, South Carolina, US | |
3380220 | 3380220 | 2022-12-08 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-09 04:21:05 | Saluda, South Carolina, US | |
1987491 | 1987491 | 2022-12-07 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-08 04:21:07 | Saluda, South Carolina, US | |
3717014 | 3717014 | 2022-12-06 | US | South Carolina | Saluda | 45081 | 4414 | 83 | 0 | 34.00795823 | -81.72713237 | 2022-12-07 04:20:58 | Saluda, South Carolina, US | |
1642552 | 1642552 | 2022-11-20 | US | New Mexico | Los Alamos | 35028 | 4414 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-11-21 04:21:05 | Los Alamos, New Mexico, US | |
2066109 | 2066109 | 2022-11-19 | US | New Mexico | Los Alamos | 35028 | 4414 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-11-20 04:21:08 | Los Alamos, New Mexico, US | |
1757503 | 1757503 | 2022-11-18 | US | New Mexico | Los Alamos | 35028 | 4414 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-11-19 04:21:14 | Los Alamos, New Mexico, US | |
292381 | 292381 | 2022-11-15 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-16 04:21:09 | Crenshaw, Alabama, US | |
3597411 | 3597411 | 2022-11-14 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-15 04:21:16 | Crenshaw, Alabama, US | |
312269 | 312269 | 2022-11-13 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-14 04:21:09 | Crenshaw, Alabama, US | |
63430 | 63430 | 2022-11-12 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-13 04:21:14 | Crenshaw, Alabama, US | |
2927592 | 2927592 | 2022-11-11 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-12 04:20:41 | Crenshaw, Alabama, US | |
2506428 | 2506428 | 2022-11-10 | US | Alabama | Crenshaw | 1041 | 4414 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-11-11 04:21:22 | Crenshaw, Alabama, US | |
711476 | 711476 | 2022-11-01 | US | Illinois | Massac | 17127 | 4414 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-11-02 04:22:09 | Massac, Illinois, US | |
1592704 | 1592704 | 2022-10-21 | US | Arkansas | Howard | 5061 | 4414 | 57 | 0 | 34.09007427 | -93.9934871 | 2022-10-22 04:22:53 | Howard, Arkansas, US | |
3217867 | 3217867 | 2022-10-12 | US | Wisconsin | Marquette | 55077 | 4414 | 65 | 0 | 43.81911946 | -89.40073763 | 2022-10-13 04:22:39 | Marquette, Wisconsin, US | |
2689307 | 2689307 | 2022-10-03 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-10-04 04:22:55 | Goshen, Wyoming, US | |
2263374 | 2263374 | 2022-10-02 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-10-03 04:23:11 | Goshen, Wyoming, US | |
2998900 | 2998900 | 2022-10-01 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-10-02 04:21:23 | Goshen, Wyoming, US | |
857226 | 857226 | 2022-09-30 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-10-01 04:23:01 | Goshen, Wyoming, US | |
2379152 | 2379152 | 2022-09-29 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-09-30 04:23:09 | Goshen, Wyoming, US | |
1563703 | 1563703 | 2022-09-28 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-09-29 04:22:34 | Goshen, Wyoming, US | |
3998246 | 3998246 | 2022-09-27 | US | Wyoming | Goshen | 56015 | 4414 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-09-28 04:23:01 | Goshen, Wyoming, US | |
1878008 | 1878008 | 2022-08-28 | US | Illinois | Mason | 17125 | 4414 | 64 | 0 | 40.23917274 | -89.91824452 | 2022-08-29 04:21:06 | Mason, Illinois, US | |
2097135 | 2097135 | 2022-08-27 | US | Illinois | Mason | 17125 | 4414 | 64 | 0 | 40.23917274 | -89.91824452 | 2022-08-28 04:21:02 | Mason, Illinois, US | |
1534699 | 1534699 | 2022-08-26 | US | Puerto Rico | Patillas | 72109 | 4414 | 0 | 0 | 18.03174 | -66.012242 | 2022-08-27 04:20:57 | Patillas, Puerto Rico, US | |
1532950 | 1532950 | 2022-08-26 | US | Illinois | Mason | 17125 | 4414 | 64 | 0 | 40.23917274 | -89.91824452 | 2022-08-27 04:20:57 | Mason, Illinois, US | |
2403340 | 2403340 | 2022-08-21 | US | Arkansas | Madison | 5087 | 4414 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-08-22 04:20:38 | Madison, Arkansas, US | |
3798418 | 3798418 | 2022-08-20 | US | Arkansas | Madison | 5087 | 4414 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-08-21 04:20:44 | Madison, Arkansas, US | |
1072894 | 1072894 | 2022-08-07 | US | Tennessee | Trousdale | 47169 | 4414 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-08-08 04:21:08 | Trousdale, Tennessee, US | |
3620243 | 3620243 | 2022-08-01 | US | Texas | Llano | 48299 | 4414 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-08-02 04:20:53 | Llano, Texas, US | |
896621 | 896621 | 2022-07-24 | US | Arkansas | Clay | 5021 | 4414 | 95 | 0 | 36.36826212 | -90.4148172 | 2022-07-25 04:20:51 | Clay, Arkansas, US | |
91615 | 91615 | 2022-07-23 | US | Arkansas | Clay | 5021 | 4414 | 95 | 0 | 36.36826212 | -90.4148172 | 2022-07-24 04:20:47 | Clay, Arkansas, US | |
3408172 | 3408172 | 2022-07-17 | US | Puerto Rico | Adjuntas | 72001 | 4414 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-18 04:20:59 | Adjuntas, Puerto Rico, US | |
2154434 | 2154434 | 2022-07-16 | US | Puerto Rico | Sabana Grande | 72121 | 4414 | 0 | 0 | 18.08282 | -66.943758 | 2022-07-17 04:21:15 | Sabana Grande, Puerto Rico, US | |
2421667 | 2421667 | 2022-07-15 | US | Puerto Rico | Sabana Grande | 72121 | 4414 | 0 | 0 | 18.08282 | -66.943758 | 2022-07-16 04:21:05 | Sabana Grande, Puerto Rico, US | |
559776 | 559776 | 2022-06-16 | US | Illinois | Carroll | 17015 | 4414 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-06-17 04:20:56 | Carroll, Illinois, US | |
3579716 | 3579716 | 2022-06-02 | US | Indiana | Franklin | 18047 | 4414 | 65 | 0 | 39.4142482 | -85.06062647 | 2022-06-03 04:20:58 | Franklin, Indiana, US | |
972009 | 972009 | 2022-06-01 | US | Indiana | Franklin | 18047 | 4414 | 65 | 0 | 39.4142482 | -85.06062647 | 2022-06-02 05:20:39 | Franklin, Indiana, US | |
3001684 | 3001684 | 2022-05-24 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-24 23:20:57 | Warren, North Carolina, US | |
3595405 | 3595405 | 2022-05-23 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-24 04:20:57 | Warren, North Carolina, US | |
1111953 | 1111953 | 2022-05-21 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-22 04:20:52 | Warren, North Carolina, US | |
1110635 | 1110635 | 2022-05-21 | US | Illinois | White | 17193 | 4414 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-05-22 04:20:52 | White, Illinois, US | |
1171577 | 1171577 | 2022-05-20 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-21 04:20:58 | Warren, North Carolina, US | |
1170259 | 1170259 | 2022-05-20 | US | Illinois | White | 17193 | 4414 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-05-21 04:20:58 | White, Illinois, US | |
3898340 | 3898340 | 2022-05-19 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-20 04:20:57 | Warren, North Carolina, US | |
3897022 | 3897022 | 2022-05-19 | US | Illinois | White | 17193 | 4414 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-05-20 04:20:57 | White, Illinois, US | |
1187124 | 1187124 | 2022-05-18 | US | North Carolina | Warren | 37185 | 4414 | 46 | 0 | 36.39728256 | -78.10652228 | 2022-05-19 04:20:54 | Warren, North Carolina, US | |
1185806 | 1185806 | 2022-05-18 | US | Illinois | White | 17193 | 4414 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-05-19 04:20:54 | White, Illinois, US | |
3583703 | 3583703 | 2022-05-17 | US | Illinois | White | 17193 | 4414 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-05-18 04:20:50 | White, Illinois, US | |
2803541 | 2803541 | 2022-04-06 | US | Puerto Rico | Morovis | 72101 | 4414 | 0 | 0 | 18.316963 | -66.420383 | 2022-04-07 04:20:53 | Morovis, Puerto Rico, US | |
878991 | 878991 | 2022-03-27 | US | Puerto Rico | Camuy | 72027 | 4414 | 0 | 0 | 18.418578 | -66.860206 | 2022-03-28 04:20:33 | Camuy, Puerto Rico, US | |
1867768 | 1867768 | 2022-03-10 | US | North Carolina | Avery | 37011 | 4414 | 42 | 0 | 36.07569796 | -81.92308483 | 2022-03-11 04:20:50 | Avery, North Carolina, US | |
1867030 | 1867030 | 2022-03-10 | US | Louisiana | Winn | 22127 | 4414 | 61 | 0 | 31.94449367 | -92.63789413 | 2022-03-11 04:20:50 | Winn, Louisiana, US | |
3821303 | 3821303 | 2022-02-16 | US | Georgia | Putnam | 13237 | 4414 | 97 | 0 | 33.32056115 | -83.37552891 | 2022-02-17 04:20:56 | Putnam, Georgia, US | |
186561 | 186561 | 2022-02-13 | US | Arkansas | Hempstead | 5057 | 4414 | 53 | 0 | 33.73325583 | -93.66935133 | 2022-02-14 04:20:51 | Hempstead, Arkansas, US | |
74693 | 74693 | 2022-02-07 | US | Wyoming | Carbon | 56007 | 4414 | 50 | 0 | 41.69357844 | -106.9326084 | 2022-02-08 04:21:15 | Carbon, Wyoming, US | |
1296011 | 1296011 | 2022-02-05 | US | Missouri | Texas | 29215 | 4414 | 80 | 0 | 37.31728859 | -91.96564727 | 2022-02-06 04:21:00 | Texas, Missouri, US | |
460846 | 460846 | 2022-02-02 | US | Kentucky | Rockcastle | 21203 | 4414 | 51 | 0 | 37.36642393 | -84.31176452 | 2022-02-03 04:21:21 | Rockcastle, Kentucky, US | |
2661189 | 2661189 | 2022-01-31 | US | Virginia | Radford | 51750 | 4414 | 39 | 0 | 37.12222899 | -80.56027320000003 | 2022-02-01 04:21:11 | Radford, Virginia, US | |
1318962 | 1318962 | 2022-01-26 | US | Georgia | Appling | 13001 | 4414 | 112 | 0 | 31.74847232 | -82.28909114 | 2022-01-27 04:21:19 | Appling, Georgia, US | |
1961060 | 1961060 | 2022-01-20 | US | Arkansas | Logan | 5083 | 4414 | 57 | 0 | 35.21413234 | -93.71951016 | 2022-01-21 04:21:09 | Logan, Arkansas, US | |
1116608 | 1116608 | 2022-01-11 | US | Texas | Austin | 48015 | 4414 | 58 | 0 | 29.88548725 | -96.27736949 | 2022-01-12 04:21:44 | Austin, Texas, US | |
1434756 | 1434756 | 2021-12-28 | US | New Mexico | Cibola | 35006 | 4414 | 158 | 0 | 34.91131525 | -107.998876 | 2021-12-29 03:21:43 | Cibola, New Mexico, US | |
732398 | 732398 | 2021-12-27 | US | Missouri | Audrain | 29007 | 4414 | 82 | 0 | 39.215877 | -91.84242683 | 2021-12-28 04:21:47 | Audrain, Missouri, US | |
3605419 | 3605419 | 2021-12-25 | US | Alabama | Bibb | 1007 | 4414 | 95 | 0 | 32.99642064 | -87.12511459999996 | 2021-12-26 04:21:50 | Bibb, Alabama, US | |
3829901 | 3829901 | 2021-12-21 | US | Kentucky | Letcher | 21133 | 4414 | 83 | 0 | 37.12306748 | -82.85346474 | 2021-12-22 04:21:54 | Letcher, Kentucky, US | |
3498122 | 3498122 | 2021-12-15 | US | Missouri | Miller | 29131 | 4414 | 101 | 0 | 38.21450288 | -92.42610898 | 2021-12-16 04:22:11 | Miller, Missouri, US | |
1080169 | 1080169 | 2021-12-09 | US | New York | Lewis | 36049 | 4414 | 40 | 0 | 43.784415700000004 | -75.44903992 | 2021-12-10 04:22:28 | Lewis, New York, US | |
150526 | 150526 | 2021-11-29 | US | California | Calaveras | 6009 | 4414 | 88 | 0 | 38.20537103 | -120.55291299999999 | 2021-11-30 04:22:53 | Calaveras, California, US | |
1015964 | 1015964 | 2021-11-21 | US | Michigan | Dickinson | 26043 | 4414 | 85 | 0 | 46.00999672 | -87.86961634 | 2021-11-22 04:22:20 | Dickinson, Michigan, US | |
724128 | 724128 | 2021-11-20 | US | Michigan | Dickinson | 26043 | 4414 | 85 | 0 | 46.00999672 | -87.86961634 | 2021-11-21 04:22:13 | Dickinson, Michigan, US | |
163658 | 163658 | 2021-11-19 | US | Michigan | Dickinson | 26043 | 4414 | 85 | 0 | 46.00999672 | -87.86961634 | 2021-11-20 04:22:17 | Dickinson, Michigan, US | |
3344169 | 3344169 | 2021-11-16 | US | Louisiana | West Baton Rouge | 22121 | 4414 | 77 | 0 | 30.46058217 | -91.30989571 | 2021-11-17 04:21:48 | West Baton Rouge, Louisiana, US | |
687790 | 687790 | 2021-11-13 | US | Kentucky | Lincoln | 21137 | 4414 | 99 | 0 | 37.45475628 | -84.6565327 | 2021-11-14 04:21:31 | Lincoln, Kentucky, US | |
88828 | 88828 | 2021-11-09 | US | Minnesota | Brown | 27015 | 4414 | 52 | 0 | 44.24205652 | -94.72562874 | 2021-11-10 04:21:38 | Brown, Minnesota, US | |
2002522 | 2002522 | 2021-11-07 | US | Mississippi | Wayne | 28153 | 4414 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-11-08 04:21:43 | Wayne, Mississippi, US | |
497513 | 497513 | 2021-11-06 | US | Mississippi | Wayne | 28153 | 4414 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-11-07 04:21:53 | Wayne, Mississippi, US | |
3123408 | 3123408 | 2021-11-05 | US | Missouri | Dunklin | 29069 | 4414 | 61 | 0 | 36.27167174 | -90.09122243 | 2021-11-06 04:21:51 | Dunklin, Missouri, US | |
3123368 | 3123368 | 2021-11-05 | US | Mississippi | Wayne | 28153 | 4414 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-11-06 04:21:51 | Wayne, Mississippi, US | |
2721019 | 2721019 | 2021-10-30 | Japan | Port Quarantine | 4414 | 7 | 0 | 2021-10-31 04:22:08 | Port Quarantine, Japan | |||||
5144 | 5144 | 2021-10-28 | US | Georgia | Emanuel | 13107 | 4414 | 128 | 0 | 32.59221302 | -82.30239915 | 2021-10-29 04:22:03 | Emanuel, Georgia, US | |
535534 | 535534 | 2021-10-27 | US | Georgia | Emanuel | 13107 | 4414 | 128 | 0 | 32.59221302 | -82.30239915 | 2021-10-28 04:22:08 | Emanuel, Georgia, US | |
1493946 | 1493946 | 2021-10-12 | US | North Carolina | Montgomery | 37123 | 4414 | 108 | 0 | 35.33155144 | -79.90416657 | 2021-10-13 04:20:51 | Montgomery, North Carolina, US | |
987750 | 987750 | 2021-10-04 | US | Georgia | Chattooga | 13055 | 4414 | 92 | 0 | 34.47197698 | -85.34535662 | 2021-10-05 04:21:27 | Chattooga, Georgia, US | |
2134682 | 2134682 | 2021-10-01 | US | Pennsylvania | Clinton | 42035 | 4414 | 71 | 0 | 41.23255967 | -77.63785995 | 2021-10-02 04:21:25 | Clinton, Pennsylvania, US | |
1237947 | 1237947 | 2021-09-27 | US | North Carolina | Cherokee | 37039 | 4414 | 61 | 0 | 35.1349263 | -84.05970864 | 2021-09-28 04:21:28 | Cherokee, North Carolina, US | |
2809145 | 2809145 | 2021-09-16 | US | Alabama | Pike | 1109 | 4414 | 88 | 0 | 31.80396383 | -85.9408295 | 2021-09-17 04:21:46 | Pike, Alabama, US | |
1387128 | 1387128 | 2021-09-13 | US | Louisiana | De Soto | 22031 | 4414 | 100 | 0 | 32.05457447 | -93.74130302 | 2021-09-14 04:21:41 | De Soto, Louisiana, US | |
1886497 | 1886497 | 2021-09-12 | US | Louisiana | De Soto | 22031 | 4414 | 100 | 0 | 32.05457447 | -93.74130302 | 2021-09-13 04:21:15 | De Soto, Louisiana, US | |
3807400 | 3807400 | 2021-09-11 | US | Louisiana | De Soto | 22031 | 4414 | 100 | 0 | 32.05457447 | -93.74130302 | 2021-09-12 04:21:13 | De Soto, Louisiana, US | |
3450340 | 3450340 | 2021-09-10 | US | Louisiana | De Soto | 22031 | 4414 | 100 | 0 | 32.05457447 | -93.74130302 | 2021-09-11 04:21:30 | De Soto, Louisiana, US | |
3450279 | 3450279 | 2021-09-10 | US | Kentucky | Marshall | 21157 | 4414 | 71 | 0 | 36.88007070000001 | -88.32803576 | 2021-09-11 04:21:30 | Marshall, Kentucky, US | |
3975201 | 3975201 | 2021-09-03 | US | Colorado | Montrose | 8085 | 4414 | 77 | 0 | 38.40214114 | -108.26390220000002 | 2021-09-04 04:21:28 | Montrose, Colorado, 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]);