johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
103 rows where confirmed = 6546 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2415392 | 2415392 | 2022-12-05 | US | Arkansas | Ouachita | 5103 | 6546 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-12-06 04:21:03 | Ouachita, Arkansas, US | |
719000 | 719000 | 2022-12-04 | US | Arkansas | Ouachita | 5103 | 6546 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-12-05 04:20:58 | Ouachita, Arkansas, US | |
2817289 | 2817289 | 2022-12-03 | US | Arkansas | Ouachita | 5103 | 6546 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-12-04 04:20:56 | Ouachita, Arkansas, US | |
3756207 | 3756207 | 2022-10-13 | US | Puerto Rico | Catano | 72033 | 6546 | 0 | 0 | 18.437269 | -66.143306 | 2022-10-14 04:22:28 | Catano, Puerto Rico, US | |
3753746 | 3753746 | 2022-10-13 | Saint Kitts and Nevis | 6546 | 46 | 0 | 17.357822 | -62.782998 | 2022-10-14 04:22:28 | Saint Kitts and Nevis | ||||
3214571 | 3214571 | 2022-10-12 | Saint Kitts and Nevis | 6546 | 46 | 0 | 17.357822 | -62.782998 | 2022-10-13 04:22:39 | Saint Kitts and Nevis | ||||
3250420 | 3250420 | 2022-10-11 | Saint Kitts and Nevis | 6546 | 46 | 0 | 17.357822 | -62.782998 | 2022-10-12 04:22:51 | Saint Kitts and Nevis | ||||
134306 | 134306 | 2022-10-04 | US | Wisconsin | Jackson | 55053 | 6546 | 45 | 0 | 44.31864893 | -90.80566792 | 2022-10-05 04:23:06 | Jackson, Wisconsin, US | |
3376289 | 3376289 | 2022-09-17 | US | Tennessee | Chester | 47023 | 6546 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-09-18 04:22:50 | Chester, Tennessee, US | |
2358397 | 2358397 | 2022-09-16 | US | Tennessee | Chester | 47023 | 6546 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-09-17 04:20:19 | Chester, Tennessee, US | |
374991 | 374991 | 2022-09-13 | US | Puerto Rico | Villalba | 72149 | 6546 | 0 | 0 | 18.127951 | -66.473115 | 2022-09-14 04:20:44 | Villalba, Puerto Rico, US | |
2346446 | 2346446 | 2022-08-31 | US | Texas | Austin | 48015 | 6546 | 80 | 0 | 29.88548725 | -96.27736949 | 2022-09-01 04:21:03 | Austin, Texas, US | |
1683834 | 1683834 | 2022-08-29 | US | Virginia | Dinwiddie | 51053 | 6546 | 96 | 0 | 37.07544585 | -77.63451754 | 2022-08-30 04:21:03 | Dinwiddie, Virginia, US | |
1880395 | 1880395 | 2022-08-28 | US | Virginia | Salem | 51775 | 6546 | 100 | 0 | 37.2836193 | -80.06219455 | 2022-08-29 04:21:06 | Salem, Virginia, US | |
2099522 | 2099522 | 2022-08-27 | US | Virginia | Salem | 51775 | 6546 | 100 | 0 | 37.2836193 | -80.06219455 | 2022-08-28 04:21:02 | Salem, Virginia, US | |
1535337 | 1535337 | 2022-08-26 | US | Virginia | Salem | 51775 | 6546 | 100 | 0 | 37.2836193 | -80.06219455 | 2022-08-27 04:20:57 | Salem, Virginia, US | |
1254167 | 1254167 | 2022-08-23 | US | Virginia | Scott | 51169 | 6546 | 116 | 0 | 36.71466456 | -82.60171704 | 2022-08-24 04:20:46 | Scott, Virginia, US | |
3909976 | 3909976 | 2022-08-11 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-12 04:20:54 | Stoddard, Missouri, US | |
1348293 | 1348293 | 2022-08-10 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-11 04:20:49 | Stoddard, Missouri, US | |
1088794 | 1088794 | 2022-08-09 | US | Puerto Rico | Aibonito | 72009 | 6546 | 0 | 0 | 18.131361 | -66.264131 | 2022-08-10 04:20:57 | Aibonito, Puerto Rico, US | |
1088048 | 1088048 | 2022-08-09 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-10 04:20:57 | Stoddard, Missouri, US | |
3545463 | 3545463 | 2022-08-08 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-09 04:20:34 | Stoddard, Missouri, US | |
1071866 | 1071866 | 2022-08-07 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-08 04:21:08 | Stoddard, Missouri, US | |
1942454 | 1942454 | 2022-08-06 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-07 04:20:54 | Stoddard, Missouri, US | |
882253 | 882253 | 2022-08-05 | US | Missouri | Stoddard | 29207 | 6546 | 139 | 0 | 36.85571651 | -89.9444155 | 2022-08-06 04:20:56 | Stoddard, Missouri, US | |
559281 | 559281 | 2022-06-16 | US | Arkansas | Cleburne | 5023 | 6546 | 129 | 0 | 35.53864922 | -92.02640019 | 2022-06-17 04:20:56 | Cleburne, Arkansas, US | |
3143852 | 3143852 | 2022-06-11 | US | New York | Seneca | 36099 | 6546 | 92 | 0 | 42.78081007 | -76.82497064 | 2022-06-12 04:20:53 | Seneca, New York, US | |
3187426 | 3187426 | 2022-05-30 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-31 04:20:51 | Lincoln, Kentucky, US | |
3199575 | 3199575 | 2022-05-29 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-30 04:20:50 | Lincoln, Kentucky, US | |
2726453 | 2726453 | 2022-05-28 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-29 04:20:53 | Lincoln, Kentucky, US | |
1315634 | 1315634 | 2022-05-27 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-28 04:21:07 | Lincoln, Kentucky, US | |
1851426 | 1851426 | 2022-05-26 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-27 04:20:56 | Lincoln, Kentucky, US | |
2050615 | 2050615 | 2022-05-25 | US | Puerto Rico | Hatillo | 72065 | 6546 | 0 | 0 | 18.410928 | -66.796326 | 2022-05-26 04:20:50 | Hatillo, Puerto Rico, US | |
2049302 | 2049302 | 2022-05-25 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-26 04:20:50 | Lincoln, Kentucky, US | |
3000740 | 3000740 | 2022-05-24 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-25 04:20:56 | Lincoln, Kentucky, US | |
3594461 | 3594461 | 2022-05-23 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-24 04:20:57 | Lincoln, Kentucky, US | |
624626 | 624626 | 2022-05-22 | US | Puerto Rico | Hatillo | 72065 | 6546 | 0 | 0 | 18.410928 | -66.796326 | 2022-05-26 04:20:50 | Hatillo, Puerto Rico, US | |
623313 | 623313 | 2022-05-22 | US | Kentucky | Lincoln | 21137 | 6546 | 137 | 0 | 37.45475628 | -84.6565327 | 2022-05-26 04:20:50 | Lincoln, Kentucky, US | |
1327951 | 1327951 | 2022-04-26 | US | Minnesota | Brown | 27015 | 6546 | 81 | 0 | 44.24205652 | -94.72562874 | 2022-04-27 04:20:52 | Brown, Minnesota, US | |
3350994 | 3350994 | 2022-04-01 | Tonga | 6546 | 6 | 0 | -21.179000000000002 | -175.1982 | 2022-04-02 04:20:47 | Tonga | ||||
876052 | 876052 | 2022-03-27 | China | Guangdong | 6546 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-28 04:20:33 | Guangdong, China | |||
2264665 | 2264665 | 2022-03-14 | US | Georgia | Chattooga | 13055 | 6546 | 129 | 0 | 34.47197698 | -85.34535662 | 2022-03-15 04:20:47 | Chattooga, Georgia, US | |
1646839 | 1646839 | 2022-03-03 | US | Ohio | Hocking | 39073 | 6546 | 119 | 0 | 39.49537927 | -82.47991446 | 2022-03-04 04:21:09 | Hocking, Ohio, US | |
2528682 | 2528682 | 2022-03-02 | US | Virginia | Carroll | 51035 | 6546 | 135 | 0 | 36.73066666 | -80.73455942 | 2022-03-03 04:21:01 | Carroll, Virginia, US | |
2735087 | 2735087 | 2022-02-27 | US | Nebraska | Dakota | 31043 | 6546 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-28 04:21:05 | Dakota, Nebraska, US | |
3048240 | 3048240 | 2022-02-26 | US | Nebraska | Dakota | 31043 | 6546 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-27 04:21:04 | Dakota, Nebraska, US | |
576895 | 576895 | 2022-02-25 | US | Nebraska | Dakota | 31043 | 6546 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-26 04:21:12 | Dakota, Nebraska, US | |
1363160 | 1363160 | 2022-02-08 | US | Georgia | Gilmer | 13123 | 6546 | 153 | 0 | 34.69316688 | -84.45802506 | 2022-02-09 04:21:04 | Gilmer, Georgia, US | |
2660231 | 2660231 | 2022-01-31 | US | Ohio | Adams | 39001 | 6546 | 137 | 0 | 38.84541072 | -83.4718964 | 2022-02-01 04:21:11 | Adams, Ohio, US | |
1285093 | 1285093 | 2022-01-05 | US | Texas | Grimes | 48185 | 6546 | 110 | 0 | 30.54579585 | -95.98902499 | 2022-01-06 04:22:09 | Grimes, Texas, US | |
1717900 | 1717900 | 2021-12-16 | US | Louisiana | Vernon | 22115 | 6546 | 167 | 0 | 31.10884837 | -93.18153838 | 2021-12-17 04:22:14 | Vernon, Louisiana, US | |
3658601 | 3658601 | 2021-12-10 | US | Tennessee | Weakley | 47183 | 6546 | 99 | 0 | 36.29896232 | -88.71990865 | 2021-12-11 04:22:45 | Weakley, Tennessee, US | |
405542 | 405542 | 2021-12-07 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-08 04:22:46 | Wapello, Iowa, US | |
1033828 | 1033828 | 2021-12-06 | US | Washington | Mason | 53045 | 6546 | 84 | 0 | 47.35007586 | -123.1863685 | 2021-12-07 04:22:34 | Mason, Washington, US | |
1031624 | 1031624 | 2021-12-06 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-07 04:22:34 | Wapello, Iowa, US | |
1741787 | 1741787 | 2021-12-05 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-06 04:22:34 | Wapello, Iowa, US | |
139219 | 139219 | 2021-12-04 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-05 04:22:25 | Wapello, Iowa, US | |
2196872 | 2196872 | 2021-12-03 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-04 04:22:18 | Wapello, Iowa, US | |
1578 | 1578 | 2021-12-02 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-03 04:23:05 | Wapello, Iowa, US | |
1146177 | 1146177 | 2021-12-01 | US | Iowa | Wapello | 19179 | 6546 | 145 | 0 | 41.03064984 | -92.40954728 | 2021-12-02 04:22:37 | Wapello, Iowa, US | |
3403391 | 3403391 | 2021-11-30 | US | Missouri | Platte | 29165 | 6546 | 65 | 0 | 39.38154439 | -94.77068479 | 2021-12-01 04:22:29 | Platte, Missouri, US | |
498111 | 498111 | 2021-11-06 | US | Ohio | Defiance | 39039 | 6546 | 115 | 0 | 41.32398837 | -84.49076944 | 2021-11-07 04:21:53 | Defiance, Ohio, US | |
3495291 | 3495291 | 2021-10-26 | US | Texas | Hill | 48217 | 6546 | 158 | 0 | 31.99045053 | -97.13423143 | 2021-10-27 04:22:32 | Hill, Texas, US | |
2946004 | 2946004 | 2021-10-15 | US | Pennsylvania | Bedford | 42009 | 6546 | 160 | 0 | 40.00522157 | -78.48998442 | 2021-10-16 04:21:15 | Bedford, Pennsylvania, US | |
494778 | 494778 | 2021-10-14 | US | Texas | Kerr | 48265 | 6546 | 126 | 0 | 30.06040006 | -99.34930144 | 2021-10-15 04:21:26 | Kerr, Texas, US | |
2459542 | 2459542 | 2021-10-06 | US | Georgia | Baldwin | 13009 | 6546 | 172 | 0 | 33.06882326 | -83.24701748 | 2021-10-07 04:21:36 | Baldwin, Georgia, US | |
1389070 | 1389070 | 2021-09-13 | US | Washington | Grays Harbor | 53027 | 6546 | 94 | 0 | 47.14003705 | -123.7820567 | 2021-09-14 04:21:41 | Grays Harbor, Washington, US | |
3451119 | 3451119 | 2021-09-10 | US | New York | Wayne | 36117 | 6546 | 76 | 0 | 43.15494365 | -77.02976528 | 2021-09-11 04:21:30 | Wayne, New York, US | |
2282664 | 2282664 | 2021-09-08 | US | West Virginia | Putnam | 54079 | 6546 | 105 | 0 | 38.50782345 | -81.9082131 | 2021-09-09 04:21:27 | Putnam, West Virginia, US | |
180666 | 180666 | 2021-09-02 | US | Oregon | Yamhill | 41071 | 6546 | 90 | 0 | 45.23330449 | -123.3086963 | 2021-09-03 04:21:20 | Yamhill, Oregon, US | |
68511 | 68511 | 2021-09-01 | US | Kentucky | Nelson | 21179 | 6546 | 68 | 0 | 37.80335779 | -85.4657193 | 2021-09-02 04:21:15 | Nelson, Kentucky, US | |
511712 | 511712 | 2021-08-19 | Japan | Ishikawa | 6546 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-20 04:21:33 | Ishikawa, Japan | |||
3468794 | 3468794 | 2021-08-03 | US | Colorado | Garfield | 8045 | 6546 | 56 | 0 | 39.59921777 | -107.902708 | 2021-08-04 04:21:25 | Garfield, Colorado, US | |
3137383 | 3137383 | 2021-07-23 | Colombia | Amazonas | 6546 | 248 | 6236 | 62 | -1.4429 | -71.5724 | 2021-07-24 00:21:36 | Amazonas, Colombia | ||
3476143 | 3476143 | 2021-07-22 | Colombia | Amazonas | 6546 | 248 | 6236 | 62 | -1.4429 | -71.5724 | 2021-07-23 04:21:29 | Amazonas, Colombia | ||
485406 | 485406 | 2021-07-19 | US | Mississippi | Lamar | 28073 | 6546 | 88 | 0 | 31.20572971 | -89.5077704 | 2021-07-20 04:21:48 | Lamar, Mississippi, US | |
3631815 | 3631815 | 2021-07-14 | Colombia | San Andres y Providencia | 6546 | 130 | 6347 | 69 | 12.5567 | -81.7185 | 2021-07-15 04:21:48 | San Andres y Providencia, Colombia | ||
582181 | 582181 | 2021-07-13 | US | Virginia | Harrisonburg | 51660 | 6546 | 95 | 0 | 38.43542574 | -78.87536254 | 2021-07-14 04:21:35 | Harrisonburg, Virginia, US | |
1443700 | 1443700 | 2021-07-07 | US | Texas | Hood | 48221 | 6546 | 134 | 0 | 32.42990927 | -97.83242024 | 2021-07-08 04:21:26 | Hood, Texas, US | |
3360260 | 3360260 | 2021-06-21 | US | Massachusetts | Berkshire | 25003 | 6546 | 246 | 0 | 42.37428441 | -73.20524838 | 2021-06-22 04:21:34 | Berkshire, Massachusetts, US | |
2718522 | 2718522 | 2021-06-10 | US | Maine | Kennebec | 23011 | 6546 | 74 | 0 | 44.40759555 | -69.76738544 | 2021-06-11 04:23:20 | Kennebec, Maine, US | |
1638689 | 1638689 | 2021-04-29 | US | North Carolina | Wilkes | 37193 | 6546 | 111 | 0 | 36.2084135 | -81.16232895 | 2021-04-30 04:21:03 | Wilkes, North Carolina, US | |
242817 | 242817 | 2021-04-02 | US | Maryland | Allegany | 24001 | 6546 | 204 | 0 | 39.62357628 | -78.69280486 | 2021-04-03 04:20:44 | Allegany, Maryland, US | |
1305728 | 1305728 | 2021-04-01 | Malaysia | Melaka | 6546 | 22 | 6204 | 320 | 2.1896 | 102.2501 | 2021-04-02 04:20:36 | Melaka, Malaysia | ||
638363 | 638363 | 2021-03-31 | US | Arizona | Gila | 4007 | 6546 | 219 | 0 | 33.80190085 | -110.8132779 | 2021-04-01 04:27:05 | Gila, Arizona, US | |
2781409 | 2781409 | 2021-03-24 | US | Alaska | Fairbanks North Star | 2090 | 6546 | 32 | 0 | 64.80726247 | -146.5692662 | 2021-03-25 05:27:00 | Fairbanks North Star, Alaska, US | |
705324 | 705324 | 2021-03-16 | US | Tennessee | Coffee | 47031 | 6546 | 117 | 0 | 35.49090731 | -86.07311784 | 2021-03-17 05:25:07 | Coffee, Tennessee, US | |
1858889 | 1858889 | 2021-02-25 | US | Georgia | Walker | 13295 | 6546 | 76 | 0 | 6470 | 34.73376362 | -85.30165174 | 2021-02-26 05:22:40 | Walker, Georgia, US |
978285 | 978285 | 2021-02-06 | US | Virginia | Montgomery | 51121 | 6546 | 69 | 0 | 6477 | 37.17746986 | -80.37868691 | 2021-02-07 05:23:00 | Montgomery, Virginia, US |
437055 | 437055 | 2021-01-21 | US | Minnesota | Clay | 27027 | 6546 | 81 | 0 | 6465 | 46.89289518 | -96.48761922 | 2021-01-22 05:22:10 | Clay, Minnesota, US |
2410066 | 2410066 | 2020-12-23 | US | Texas | Walker | 48471 | 6546 | 79 | 0 | 5658 | 30.73872995 | -95.57440968 | 2020-12-24 05:23:04 | Walker, Texas, US |
3851329 | 3851329 | 2020-12-13 | US | Wisconsin | Jefferson | 55055 | 6546 | 48 | 0 | 6498 | 43.02054068 | -88.77529134 | 2020-12-14 05:26:27 | Jefferson, Wisconsin, US |
823325 | 823325 | 2020-11-19 | US | Minnesota | St. Louis | 27137 | 6546 | 87 | 0 | 6459 | 47.6048407 | -92.46879855 | 2020-11-20 05:26:28 | St. Louis, Minnesota, US |
789681 | 789681 | 2020-10-15 | US | Virginia | Chesterfield | 51041 | 6546 | 98 | 0 | 6448 | 37.37373208 | -77.58680140000001 | 2020-10-16 04:24:01 | Chesterfield, Virginia, US |
1045893 | 1045893 | 2020-09-30 | Mexico | Chiapas | 6546 | 1020 | 5458 | 68 | 16.7569 | -93.1292 | 2020-10-01 04:23:42 | Chiapas, Mexico | ||
2653971 | 2653971 | 2020-09-23 | Russia | Karachay-Cherkess Republic | 6546 | 28 | 4735 | 1783 | 43.7368326 | 41.7267991 | 2020-09-24 04:23:00 | Karachay-Cherkess Republic, Russia | ||
2455045 | 2455045 | 2020-09-19 | Slovakia | 6546 | 39 | 3519 | 2988 | 48.669 | 19.699 | 2020-09-20 04:22:00 | Slovakia | |||
1444979 | 1444979 | 2020-09-11 | US | Alabama | Tuscaloosa | 1125 | 6546 | 96 | 0 | 6450 | 33.28726072 | -87.52556818 | 2020-09-12 04:25:05 | Tuscaloosa, Alabama, US |
3923354 | 3923354 | 2020-08-09 | Russia | Ryazan Oblast | 6546 | 34 | 5933 | 579 | 54.42267320000001 | 40.57052460000001 | 2020-08-10 04:34:55 | Ryazan Oblast, Russia | ||
3793025 | 3793025 | 2020-08-05 | Russia | Ivanovo Oblast | 6546 | 107 | 5224 | 1215 | 56.9167446 | 41.43521370000001 | 2020-08-06 04:35:02 | Ivanovo Oblast, Russia |
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]);