johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
96 rows where confirmed = 6251 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1985150 | 1985150 | 2022-12-07 | US | Arkansas | Lawrence | 5075 | 6251 | 87 | 0 | 36.04188196 | -91.10867198 | 2022-12-08 04:21:07 | Lawrence, Arkansas, US | |
1243256 | 1243256 | 2022-11-28 | US | Wisconsin | Vilas | 55125 | 6251 | 100 | 0 | 46.05467334 | -89.51719204 | 2022-11-29 04:21:05 | Vilas, Wisconsin, US | |
480760 | 480760 | 2022-11-08 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-09 04:21:22 | Boone, Iowa, US | |
2439910 | 2439910 | 2022-11-07 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-08 04:21:21 | Boone, Iowa, US | |
1051008 | 1051008 | 2022-11-06 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-07 04:21:26 | Boone, Iowa, US | |
619032 | 619032 | 2022-11-05 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-06 04:21:24 | Boone, Iowa, US | |
1023536 | 1023536 | 2022-11-04 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-05 04:21:52 | Boone, Iowa, US | |
432527 | 432527 | 2022-11-03 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-04 04:22:11 | Boone, Iowa, US | |
851871 | 851871 | 2022-11-02 | US | New York | Schoharie | 36095 | 6251 | 40 | 0 | 42.58831742 | -74.4433903 | 2022-11-03 04:22:05 | Schoharie, New York, US | |
850769 | 850769 | 2022-11-02 | US | Iowa | Boone | 19015 | 6251 | 65 | 0 | 42.03657094 | -93.9313999 | 2022-11-03 04:22:05 | Boone, Iowa, US | |
2017203 | 2017203 | 2022-09-20 | US | Arkansas | Columbia | 5027 | 6251 | 99 | 0 | 33.21230701 | -93.22642793 | 2022-09-21 04:23:22 | Columbia, Arkansas, US | |
2397444 | 2397444 | 2022-09-12 | US | Oregon | Wasco | 41065 | 6251 | 70 | 0 | 45.16292781 | -121.1670954 | 2022-09-13 04:20:57 | Wasco, Oregon, US | |
3746672 | 3746672 | 2022-09-07 | US | Maine | Lincoln | 23015 | 6251 | 40 | 0 | 44.05996956 | -69.54227124 | 2022-09-08 04:21:02 | Lincoln, Maine, US | |
3777458 | 3777458 | 2022-08-30 | US | Wisconsin | Iowa | 55049 | 6251 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-08-31 04:20:57 | Iowa, Wisconsin, US | |
1253535 | 1253535 | 2022-08-23 | US | Puerto Rico | Salinas | 72123 | 6251 | 0 | 0 | 18.010387 | -66.256592 | 2022-08-24 04:20:46 | Salinas, Puerto Rico, US | |
1069287 | 1069287 | 2022-07-28 | US | Virginia | Scott | 51169 | 6251 | 114 | 0 | 36.71466456 | -82.60171704 | 2022-07-29 04:20:45 | Scott, Virginia, US | |
2597441 | 2597441 | 2022-07-25 | US | Virginia | Salem | 51775 | 6251 | 99 | 0 | 37.2836193 | -80.06219455 | 2022-07-26 04:20:58 | Salem, Virginia, US | |
2596959 | 2596959 | 2022-07-25 | US | Tennessee | Chester | 47023 | 6251 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-07-26 04:20:58 | Chester, Tennessee, US | |
899241 | 899241 | 2022-07-24 | US | Texas | Frio | 48163 | 6251 | 94 | 0 | 28.86751206 | -99.10804207 | 2022-07-25 04:20:51 | Frio, Texas, US | |
3213110 | 3213110 | 2022-07-18 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-19 04:20:58 | Jasper, South Carolina, US | |
3408285 | 3408285 | 2022-07-17 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-18 04:20:59 | Jasper, South Carolina, US | |
2154485 | 2154485 | 2022-07-16 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-17 04:21:15 | Jasper, South Carolina, US | |
2421718 | 2421718 | 2022-07-15 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-16 04:21:05 | Jasper, South Carolina, US | |
3431793 | 3431793 | 2022-07-14 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-15 04:20:53 | Jasper, South Carolina, US | |
3112313 | 3112313 | 2022-07-13 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-14 04:20:57 | Jasper, South Carolina, US | |
632736 | 632736 | 2022-07-12 | US | South Carolina | Jasper | 45053 | 6251 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-07-13 04:20:58 | Jasper, South Carolina, US | |
2742969 | 2742969 | 2022-07-07 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-08 04:20:56 | Randolph, Missouri, US | |
1201764 | 1201764 | 2022-07-06 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-07 04:20:55 | Randolph, Missouri, US | |
3968507 | 3968507 | 2022-07-05 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-06 04:20:58 | Randolph, Missouri, US | |
3080018 | 3080018 | 2022-07-04 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-05 04:20:45 | Randolph, Missouri, US | |
1769300 | 1769300 | 2022-07-03 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-04 04:20:54 | Randolph, Missouri, US | |
3367286 | 3367286 | 2022-07-02 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-03 04:20:59 | Randolph, Missouri, US | |
595615 | 595615 | 2022-07-01 | US | Missouri | Randolph | 29175 | 6251 | 105 | 0 | 39.44007257 | -92.4971374 | 2022-07-02 04:21:16 | Randolph, Missouri, US | |
3581579 | 3581579 | 2022-06-02 | US | Tennessee | Haywood | 47075 | 6251 | 103 | 0 | 35.58332824 | -89.28536625 | 2022-06-03 04:20:58 | Haywood, Tennessee, US | |
3899338 | 3899338 | 2022-05-19 | US | Virginia | Mecklenburg | 51117 | 6251 | 123 | 0 | 36.67882005 | -78.36131056 | 2022-05-20 04:20:57 | Mecklenburg, Virginia, US | |
2029772 | 2029772 | 2022-04-24 | US | Illinois | Jersey | 17083 | 6251 | 72 | 0 | 39.08869046 | -90.35393073 | 2022-04-25 04:20:56 | Jersey, Illinois, US | |
747347 | 747347 | 2022-04-23 | US | Illinois | Jersey | 17083 | 6251 | 72 | 0 | 39.08869046 | -90.35393073 | 2022-04-24 04:20:56 | Jersey, Illinois, US | |
3437832 | 3437832 | 2022-04-22 | US | Illinois | Jersey | 17083 | 6251 | 72 | 0 | 39.08869046 | -90.35393073 | 2022-04-23 04:20:50 | Jersey, Illinois, US | |
3731108 | 3731108 | 2022-04-03 | US | Georgia | Stephens | 13257 | 6251 | 148 | 0 | 34.55151201 | -83.29405315 | 2022-04-04 04:20:51 | Stephens, Georgia, US | |
500543 | 500543 | 2022-04-02 | US | Georgia | Stephens | 13257 | 6251 | 148 | 0 | 34.55151201 | -83.29405315 | 2022-04-03 04:20:48 | Stephens, Georgia, US | |
3351528 | 3351528 | 2022-04-01 | US | Georgia | Stephens | 13257 | 6251 | 148 | 0 | 34.55151201 | -83.29405315 | 2022-04-02 04:20:47 | Stephens, Georgia, US | |
2660860 | 2660860 | 2022-01-31 | US | Texas | DeWitt | 48123 | 6251 | 86 | 0 | 29.08101855 | -97.35681170000001 | 2022-02-01 04:21:11 | DeWitt, Texas, US | |
1321601 | 1321601 | 2022-01-26 | US | Virginia | Orange | 51137 | 6251 | 71 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-27 04:21:19 | Orange, Virginia, US | |
3466649 | 3466649 | 2022-01-18 | US | Ohio | Hardin | 39065 | 6251 | 138 | 0 | 40.66015414 | -83.65929931 | 2022-01-19 04:21:23 | Hardin, Ohio, US | |
1116985 | 1116985 | 2022-01-11 | US | Virginia | Prince George | 51149 | 6251 | 53 | 0 | 37.18497668 | -77.22922187 | 2022-01-12 04:21:44 | Prince George, Virginia, US | |
3522694 | 3522694 | 2022-01-02 | US | Texas | Wood | 48499 | 6251 | 241 | 0 | 32.78722382 | -95.38236368 | 2022-01-03 02:22:25 | Wood, Texas, US | |
2091494 | 2091494 | 2021-12-14 | US | West Virginia | Wayne | 54099 | 6251 | 92 | 0 | 38.14901357 | -82.42287994 | 2021-12-15 03:22:16 | Wayne, West Virginia, US | |
162952 | 162952 | 2021-11-19 | US | Idaho | Bonner | 16017 | 6251 | 119 | 0 | 48.29996017 | -116.6017932 | 2021-11-20 04:22:17 | Bonner, Idaho, US | |
279435 | 279435 | 2021-11-03 | US | Texas | Wharton | 48481 | 6251 | 183 | 0 | 29.27765923 | -96.22319248 | 2021-11-04 04:22:20 | Wharton, Texas, US | |
3511870 | 3511870 | 2021-11-01 | US | Arkansas | Boone | 5009 | 6251 | 127 | 0 | 36.3084504 | -93.09374925 | 2021-11-02 04:22:03 | Boone, Arkansas, US | |
3495424 | 3495424 | 2021-10-26 | US | Texas | Wharton | 48481 | 6251 | 181 | 0 | 29.27765923 | -96.22319248 | 2021-10-27 04:22:32 | Wharton, Texas, US | |
3494774 | 3494774 | 2021-10-26 | US | Oklahoma | Unassigned | 90040 | 6251 | 7 | 0 | 36.83532655 | 0.0 | 2021-10-27 04:22:32 | Unassigned, Oklahoma, US | |
772594 | 772594 | 2021-10-23 | US | New York | Madison | 36053 | 6251 | 102 | 0 | 42.91653905 | -75.67266639 | 2021-10-24 04:21:22 | Madison, New York, US | |
1909704 | 1909704 | 2021-10-17 | US | Arkansas | Independence | 5063 | 6251 | 156 | 0 | 35.74242707 | -91.57001641 | 2021-10-18 04:21:10 | Independence, Arkansas, US | |
636236 | 636236 | 2021-10-13 | US | North Carolina | Davie | 37059 | 6251 | 68 | 0 | 35.93099927 | -80.54496571 | 2021-10-14 04:21:29 | Davie, North Carolina, US | |
1494412 | 1494412 | 2021-10-12 | US | South Carolina | Chester | 45023 | 6251 | 105 | 0 | 34.69249168 | -81.1583216 | 2021-10-13 04:20:51 | Chester, South Carolina, US | |
1335365 | 1335365 | 2021-09-28 | US | Indiana | Gibson | 18051 | 6251 | 107 | 0 | 38.30393723 | -87.58054938 | 2021-09-29 04:21:45 | Gibson, Indiana, US | |
68475 | 68475 | 2021-09-01 | US | Kentucky | Hopkins | 21107 | 6251 | 161 | 0 | 37.30939025 | -87.54670406 | 2021-09-02 04:21:15 | Hopkins, Kentucky, US | |
2068349 | 2068349 | 2021-08-31 | US | Arizona | Graham | 4009 | 6251 | 89 | 0 | 32.93166885 | -109.8882178 | 2021-09-01 04:21:38 | Graham, Arizona, US | |
3107767 | 3107767 | 2021-08-24 | US | North Carolina | Edgecombe | 37065 | 6251 | 115 | 0 | 35.91230639 | -77.59436892 | 2021-08-25 04:21:41 | Edgecombe, North Carolina, US | |
2902387 | 2902387 | 2021-08-12 | US | Pennsylvania | Union | 42119 | 6251 | 90 | 0 | 40.96188846 | -77.05996014 | 2021-08-13 04:21:24 | Union, Pennsylvania, US | |
3332609 | 3332609 | 2021-07-21 | US | Indiana | Dubois | 18037 | 6251 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-22 04:21:19 | Dubois, Indiana, US | |
2372590 | 2372590 | 2021-07-20 | US | Indiana | Dubois | 18037 | 6251 | 118 | 0 | 38.36597551 | -86.87924170000002 | 2021-07-21 04:21:40 | Dubois, Indiana, US | |
2767967 | 2767967 | 2021-07-01 | US | Texas | Caldwell | 48055 | 6251 | 100 | 0 | 29.83668859 | -97.61814775 | 2021-07-02 04:21:47 | Caldwell, Texas, US | |
2766043 | 2766043 | 2021-07-01 | US | Indiana | Marshall | 18099 | 6251 | 116 | 0 | 41.32467367 | -86.26185087 | 2021-07-02 04:21:47 | Marshall, Indiana, US | |
3958364 | 3958364 | 2021-06-26 | Colombia | San Andres y Providencia | 6251 | 123 | 6031 | 97 | 12.5567 | -81.7185 | 2021-06-27 04:21:39 | San Andres y Providencia, Colombia | ||
2426466 | 2426466 | 2021-06-23 | US | Wisconsin | Sauk | 55111 | 6251 | 56 | 0 | 43.42574087 | -89.94966132 | 2021-06-24 04:21:55 | Sauk, Wisconsin, US | |
564886 | 564886 | 2021-06-22 | US | Missouri | Lincoln | 29113 | 6251 | 51 | 0 | 39.05345619 | -90.95588181 | 2021-06-23 04:21:46 | Lincoln, Missouri, US | |
3473852 | 3473852 | 2021-06-08 | US | Maine | Penobscot | 23019 | 6251 | 94 | 0 | 45.40194593 | -68.65020455 | 2021-06-09 04:23:31 | Penobscot, Maine, US | |
2392583 | 2392583 | 2021-05-18 | US | Mississippi | Lamar | 28073 | 6251 | 86 | 0 | 31.20572971 | -89.5077704 | 2021-05-19 04:20:42 | Lamar, Mississippi, US | |
1085603 | 1085603 | 2021-05-14 | Malaysia | Pahang | 6251 | 27 | 5154 | 1070 | 3.8126 | 103.3256 | 2021-05-15 04:20:58 | Pahang, Malaysia | ||
3055870 | 3055870 | 2021-05-13 | US | Michigan | Shiawassee | 26155 | 6251 | 101 | 0 | 42.95392800000001 | -84.14585902 | 2021-05-14 04:20:41 | Shiawassee, Michigan, US | |
3676261 | 3676261 | 2021-05-04 | US | Colorado | Eagle | 8037 | 6251 | 23 | 0 | 39.62754308 | -106.6933637 | 2021-05-05 04:20:43 | Eagle, Colorado, US | |
1637077 | 1637077 | 2021-04-29 | US | Georgia | Catoosa | 13047 | 6251 | 70 | 0 | 34.89872298 | -85.13757014 | 2021-04-30 04:21:03 | Catoosa, Georgia, US | |
2247330 | 2247330 | 2021-04-07 | Iceland | 6251 | 29 | 6090 | 132 | 64.9631 | -19.0208 | 2021-04-08 04:21:13 | Iceland | |||
3006269 | 3006269 | 2021-04-06 | US | Tennessee | McMinn | 47107 | 6251 | 95 | 0 | 35.42812616 | -84.61520715 | 2021-04-07 04:20:53 | McMinn, Tennessee, US | |
3710104 | 3710104 | 2021-04-03 | India | Sikkim | 6251 | 135 | 6068 | 48 | 27.571671 | 88.472712 | 2021-04-04 04:20:49 | Sikkim, India | ||
1983727 | 1983727 | 2021-03-25 | US | Texas | Hood | 48221 | 6251 | 122 | 0 | 32.42990927 | -97.83242024 | 2021-03-26 05:26:55 | Hood, Texas, US | |
1801096 | 1801096 | 2021-03-23 | US | Ohio | Geauga | 39055 | 6251 | 146 | 0 | 41.49952319 | -81.17935342 | 2021-03-24 05:25:40 | Geauga, Ohio, US | |
1341092 | 1341092 | 2021-02-15 | US | South Carolina | Kershaw | 45055 | 6251 | 109 | 0 | 6142 | 34.33988254 | -80.58763164 | 2021-02-16 05:24:38 | Kershaw, South Carolina, US |
975321 | 975321 | 2021-02-06 | US | Alabama | Walker | 1127 | 6251 | 209 | 0 | 6042 | 33.80270512 | -87.30027177 | 2021-02-07 05:23:00 | Walker, Alabama, US |
340119 | 340119 | 2021-02-03 | Colombia | Choco | 6251 | 187 | 5857 | 207 | 5.2528 | -76.82600000000002 | 2021-02-04 05:22:26 | Choco, Colombia | ||
1684970 | 1684970 | 2021-02-02 | US | Arkansas | Crawford | 5033 | 6251 | 92 | 0 | 6159 | 35.58928601 | -94.2446814 | 2021-02-03 05:22:52 | Crawford, Arkansas, US |
1676844 | 1676844 | 2021-02-01 | US | Alabama | Jackson | 1071 | 6251 | 70 | 0 | 6181 | 34.78144169 | -85.99750489 | 2021-02-02 05:22:49 | Jackson, Alabama, US |
2569111 | 2569111 | 2021-01-25 | US | Kentucky | Oldham | 21185 | 6251 | 63 | 0 | 6188 | 38.39791089 | -85.448222 | 2021-01-26 05:22:02 | Oldham, Kentucky, US |
192556 | 192556 | 2021-01-11 | US | Ohio | Muskingum | 39119 | 6251 | 98 | 0 | 6153 | 39.96575964 | -81.94363275 | 2021-01-12 05:22:15 | Muskingum, Ohio, US |
2544837 | 2544837 | 2021-01-07 | US | Washington | Grant | 53025 | 6251 | 48 | 0 | 6203 | 47.20753737 | -119.4500749 | 2021-01-08 05:22:42 | Grant, Washington, US |
2131203 | 2131203 | 2020-12-17 | US | Texas | Smith | 48423 | 6251 | 226 | 0 | 11369 | 32.37474036 | -95.2717568 | 2020-12-18 05:28:18 | Smith, Texas, US |
738468 | 738468 | 2020-12-02 | Peru | Pasco | 6251 | 304 | 0 | 5947 | -10.39655 | -75.307635 | 2020-12-03 05:28:22 | Pasco, Peru | ||
2537562 | 2537562 | 2020-12-01 | Peru | Pasco | 6251 | 303 | 0 | 5948 | -10.39655 | -75.307635 | 2020-12-02 05:27:41 | Pasco, Peru | ||
3191515 | 3191515 | 2020-11-22 | US | Louisiana | Tangipahoa | 22105 | 6251 | 139 | 0 | 6112 | 30.62888673 | -90.40664996 | 2020-11-23 05:25:26 | Tangipahoa, Louisiana, US |
1797461 | 1797461 | 2020-10-19 | US | South Carolina | York | 45091 | 6251 | 96 | 0 | 6155 | 34.97281497 | -81.18085944 | 2020-10-20 04:24:22 | York, South Carolina, US |
3162967 | 3162967 | 2020-09-06 | US | Kansas | Wyandotte | 20209 | 6251 | 117 | 0 | 6134 | 39.11727348 | -94.76378225 | 2020-09-07 04:28:30 | Wyandotte, Kansas, US |
2000296 | 2000296 | 2020-08-26 | Zimbabwe | 6251 | 179 | 5001 | 1071 | -19.015438 | 29.154857 | 2020-08-27 04:28:15 | Zimbabwe | |||
96847 | 96847 | 2020-08-04 | US | Texas | Montgomery | 48339 | 6251 | 73 | 0 | 6324 | 30.30079133 | -95.50572772 | 2020-08-05 04:34:43 | Montgomery, Texas, US |
997743 | 997743 | 2020-05-23 | Brazil | Distrito Federal | 6251 | 95 | 0 | 6156 | -15.7998 | -47.8645 | 2020-05-24 02:32:43 | Distrito Federal, Brazil |
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]);