johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
129 rows where confirmed = 4957 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755581 | 2755581 | 2022-12-29 | US | Pennsylvania | Fulton | 42057 | 4957 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-30 04:21:04 | Fulton, Pennsylvania, US | |
1076587 | 1076587 | 2022-12-28 | US | Pennsylvania | Fulton | 42057 | 4957 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-29 04:21:01 | Fulton, Pennsylvania, US | |
310880 | 310880 | 2022-12-13 | US | Tennessee | Sequatchie | 47153 | 4957 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-14 04:21:04 | Sequatchie, Tennessee, US | |
1151682 | 1151682 | 2022-12-12 | US | Puerto Rico | Ciales | 72039 | 4957 | 0 | 0 | 18.28885 | -66.516475 | 2022-12-13 04:21:01 | Ciales, Puerto Rico, US | |
3715177 | 3715177 | 2022-12-06 | US | Illinois | Jo Daviess | 17085 | 4957 | 45 | 0 | 42.36542373 | -90.21094405 | 2022-12-07 04:20:58 | Jo Daviess, Illinois, US | |
322706 | 322706 | 2022-10-30 | US | Puerto Rico | Patillas | 72109 | 4957 | 0 | 0 | 18.03174 | -66.012242 | 2022-10-31 04:21:36 | Patillas, Puerto Rico, US | |
131397 | 131397 | 2022-10-04 | US | Colorado | Otero | 8089 | 4957 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-10-05 04:23:06 | Otero, Colorado, US | |
3777045 | 3777045 | 2022-08-30 | US | Texas | Jones | 48253 | 4957 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-08-31 04:20:57 | Jones, Texas, US | |
1880196 | 1880196 | 2022-08-28 | US | Texas | Robertson | 48395 | 4957 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-29 04:21:06 | Robertson, Texas, US | |
2099323 | 2099323 | 2022-08-27 | US | Texas | Robertson | 48395 | 4957 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-28 04:21:02 | Robertson, Texas, US | |
1535138 | 1535138 | 2022-08-26 | US | Texas | Robertson | 48395 | 4957 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-27 04:20:57 | Robertson, Texas, US | |
3952045 | 3952045 | 2022-08-17 | US | Louisiana | Winn | 22127 | 4957 | 65 | 0 | 31.94449367 | -92.63789413 | 2022-08-18 04:21:11 | Winn, Louisiana, US | |
883198 | 883198 | 2022-08-05 | US | Tennessee | Benton | 47005 | 4957 | 96 | 0 | 36.07110411 | -88.06849355 | 2022-08-06 04:20:56 | Benton, Tennessee, US | |
959274 | 959274 | 2022-07-19 | US | Alabama | Henry | 1067 | 4957 | 78 | 0 | 31.51148016 | -85.24267944 | 2022-07-20 04:20:59 | Henry, Alabama, US | |
2490395 | 2490395 | 2022-06-29 | US | Alabama | Hale | 1065 | 4957 | 106 | 0 | 32.76039258 | -87.63284988 | 2022-06-30 04:21:01 | Hale, Alabama, US | |
2239834 | 2239834 | 2022-06-28 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-29 04:20:59 | Northwest Arctic, Alaska, US | |
2148076 | 2148076 | 2022-06-27 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-28 04:20:58 | Northwest Arctic, Alaska, US | |
475877 | 475877 | 2022-06-26 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-27 04:21:00 | Northwest Arctic, Alaska, US | |
939252 | 939252 | 2022-06-25 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-26 04:21:02 | Northwest Arctic, Alaska, US | |
3347072 | 3347072 | 2022-06-24 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-25 04:20:57 | Northwest Arctic, Alaska, US | |
1648813 | 1648813 | 2022-06-23 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-24 04:20:58 | Northwest Arctic, Alaska, US | |
2188048 | 2188048 | 2022-06-22 | US | Alaska | Northwest Arctic | 2188 | 4957 | 15 | 0 | 67.04919196 | -159.7503946 | 2022-06-23 04:20:55 | Northwest Arctic, Alaska, US | |
3510701 | 3510701 | 2022-06-05 | US | Virginia | Buchanan | 51027 | 4957 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-06 04:20:57 | Buchanan, Virginia, US | |
3530778 | 3530778 | 2022-06-04 | US | Virginia | Buchanan | 51027 | 4957 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-05 04:20:55 | Buchanan, Virginia, US | |
3136864 | 3136864 | 2022-06-03 | US | Virginia | Buchanan | 51027 | 4957 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-04 04:20:58 | Buchanan, Virginia, US | |
229834 | 229834 | 2022-05-31 | US | Colorado | Chaffee | 8015 | 4957 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-06-01 04:20:55 | Chaffee, Colorado, US | |
3000063 | 3000063 | 2022-05-24 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-25 04:20:56 | Berrien, Georgia, US | |
3593784 | 3593784 | 2022-05-23 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-24 04:20:57 | Berrien, Georgia, US | |
1110332 | 1110332 | 2022-05-21 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-22 04:20:52 | Berrien, Georgia, US | |
1169956 | 1169956 | 2022-05-20 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-21 04:20:58 | Berrien, Georgia, US | |
3896719 | 3896719 | 2022-05-19 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-20 04:20:57 | Berrien, Georgia, US | |
1185503 | 1185503 | 2022-05-18 | US | Georgia | Berrien | 13019 | 4957 | 83 | 0 | 31.27590016 | -83.2252992 | 2022-05-19 04:20:54 | Berrien, Georgia, US | |
3437489 | 3437489 | 2022-04-22 | US | Colorado | Teller | 8119 | 4957 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-04-23 04:20:50 | Teller, Colorado, US | |
2893074 | 2893074 | 2022-04-21 | US | Colorado | Teller | 8119 | 4957 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-04-22 04:20:45 | Teller, Colorado, US | |
1950499 | 1950499 | 2022-04-12 | US | Montana | Big Horn | 30003 | 4957 | 94 | 0 | 45.42335905 | -107.492347 | 2022-04-13 04:21:03 | Big Horn, Montana, US | |
3022894 | 3022894 | 2022-03-23 | US | Colorado | Elbert | 8039 | 4957 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-24 04:20:43 | Elbert, Colorado, US | |
1905816 | 1905816 | 2022-03-22 | US | Colorado | Elbert | 8039 | 4957 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-23 04:20:48 | Elbert, Colorado, US | |
3238947 | 3238947 | 2022-03-21 | US | Colorado | Elbert | 8039 | 4957 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-22 04:20:54 | Elbert, Colorado, US | |
3631432 | 3631432 | 2022-03-13 | US | West Virginia | Brooke | 54009 | 4957 | 103 | 0 | 40.27367263 | -80.57915332 | 2022-03-14 04:20:46 | Brooke, West Virginia, US | |
954340 | 954340 | 2022-03-12 | US | West Virginia | Brooke | 54009 | 4957 | 103 | 0 | 40.27367263 | -80.57915332 | 2022-03-13 04:20:49 | Brooke, West Virginia, US | |
359801 | 359801 | 2022-03-11 | US | West Virginia | Brooke | 54009 | 4957 | 103 | 0 | 40.27367263 | -80.57915332 | 2022-03-12 04:20:50 | Brooke, West Virginia, US | |
1995878 | 1995878 | 2022-03-01 | US | Texas | Scurry | 48415 | 4957 | 101 | 0 | 32.74613808 | -100.91626640000001 | 2022-03-02 04:21:07 | Scurry, Texas, US | |
1512787 | 1512787 | 2022-02-24 | US | Kentucky | Breckinridge | 21027 | 4957 | 68 | 0 | 37.77377239 | -86.42885017 | 2022-02-25 04:21:11 | Breckinridge, Kentucky, US | |
1060886 | 1060886 | 2022-02-23 | US | Texas | Burleson | 48051 | 4957 | 65 | 0 | 30.49273808 | -96.62158484 | 2022-02-24 04:21:14 | Burleson, Texas, US | |
1059228 | 1059228 | 2022-02-23 | US | Kentucky | Breckinridge | 21027 | 4957 | 68 | 0 | 37.77377239 | -86.42885017 | 2022-02-24 04:21:14 | Breckinridge, Kentucky, US | |
3821475 | 3821475 | 2022-02-16 | US | Illinois | Pike | 17149 | 4957 | 64 | 0 | 39.62265059 | -90.8877017 | 2022-02-17 04:20:56 | Pike, Illinois, US | |
1363295 | 1363295 | 2022-02-08 | US | Idaho | Jerome | 16053 | 4957 | 60 | 0 | 42.68891267 | -114.2655033 | 2022-02-09 04:21:04 | Jerome, Idaho, US | |
982539 | 982539 | 2022-02-01 | US | Wisconsin | Vilas | 55125 | 4957 | 83 | 0 | 46.05467334 | -89.51719204 | 2022-02-02 04:21:09 | Vilas, Wisconsin, US | |
2835809 | 2835809 | 2022-01-22 | US | Tennessee | Morgan | 47129 | 4957 | 64 | 0 | 36.13248031 | -84.64880098 | 2022-01-23 04:21:13 | Morgan, Tennessee, US | |
1695449 | 1695449 | 2022-01-10 | US | Texas | Jasper | 48241 | 4957 | 166 | 0 | 30.74685667 | -94.02667579 | 2022-01-11 04:22:01 | Jasper, Texas, US | |
1692813 | 1692813 | 2022-01-10 | US | Arkansas | Jackson | 5067 | 4957 | 49 | 0 | 35.59802983 | -91.21494602 | 2022-01-11 04:22:01 | Jackson, Arkansas, US | |
1701140 | 1701140 | 2022-01-03 | US | Georgia | Decatur | 13087 | 4957 | 110 | 0 | 30.87967778 | -84.57619536 | 2022-01-04 04:22:17 | Decatur, Georgia, US | |
3520223 | 3520223 | 2022-01-02 | US | Georgia | Decatur | 13087 | 4957 | 110 | 0 | 30.87967778 | -84.57619536 | 2022-01-03 02:22:25 | Decatur, Georgia, US | |
2168353 | 2168353 | 2022-01-01 | US | Georgia | Decatur | 13087 | 4957 | 110 | 0 | 30.87967778 | -84.57619536 | 2022-01-02 04:20:52 | Decatur, Georgia, US | |
2777784 | 2777784 | 2021-12-31 | US | Georgia | Decatur | 13087 | 4957 | 110 | 0 | 30.87967778 | -84.57619536 | 2022-01-01 04:22:14 | Decatur, Georgia, US | |
2399346 | 2399346 | 2021-12-17 | US | Arkansas | St. Francis | 5123 | 4957 | 72 | 0 | 35.02201976 | -90.74828138 | 2021-12-18 02:22:20 | St. Francis, Arkansas, US | |
3497091 | 3497091 | 2021-12-15 | US | Georgia | White | 13311 | 4957 | 133 | 0 | 34.64624278 | -83.74905525 | 2021-12-16 04:22:11 | White, Georgia, US | |
407854 | 407854 | 2021-12-07 | US | Wisconsin | Lincoln | 55069 | 4957 | 120 | 0 | 45.33737523 | -89.73411273 | 2021-12-08 04:22:46 | Lincoln, Wisconsin, US | |
1033936 | 1033936 | 2021-12-06 | US | Wisconsin | Lincoln | 55069 | 4957 | 120 | 0 | 45.33737523 | -89.73411273 | 2021-12-07 04:22:34 | Lincoln, Wisconsin, US | |
1744099 | 1744099 | 2021-12-05 | US | Wisconsin | Lincoln | 55069 | 4957 | 120 | 0 | 45.33737523 | -89.73411273 | 2021-12-06 04:22:34 | Lincoln, Wisconsin, US | |
141531 | 141531 | 2021-12-04 | US | Wisconsin | Lincoln | 55069 | 4957 | 120 | 0 | 45.33737523 | -89.73411273 | 2021-12-05 04:22:25 | Lincoln, Wisconsin, US | |
2199184 | 2199184 | 2021-12-03 | US | Wisconsin | Lincoln | 55069 | 4957 | 120 | 0 | 45.33737523 | -89.73411273 | 2021-12-04 04:22:18 | Lincoln, Wisconsin, US | |
1016832 | 1016832 | 2021-11-21 | US | Ohio | Morrow | 39117 | 4957 | 64 | 0 | 40.52363560000001 | -82.7892599 | 2021-11-22 04:22:20 | Morrow, Ohio, US | |
3642324 | 3642324 | 2021-11-08 | US | Puerto Rico | Ponce | 72113 | 4957 | 0 | 0 | 18.059498 | -66.613748 | 2021-11-09 04:21:36 | Ponce, Puerto Rico, US | |
2004071 | 2004071 | 2021-11-07 | US | Virginia | Smyth | 51173 | 4957 | 119 | 0 | 36.84455636 | -81.53344948 | 2021-11-08 04:21:43 | Smyth, Virginia, US | |
499062 | 499062 | 2021-11-06 | US | Virginia | Smyth | 51173 | 4957 | 119 | 0 | 36.84455636 | -81.53344948 | 2021-11-07 04:21:53 | Smyth, Virginia, US | |
3124917 | 3124917 | 2021-11-05 | US | Virginia | Smyth | 51173 | 4957 | 119 | 0 | 36.84455636 | -81.53344948 | 2021-11-06 04:21:51 | Smyth, Virginia, US | |
569558 | 569558 | 2021-10-29 | US | Ohio | Coshocton | 39031 | 4957 | 100 | 0 | 40.30096166 | -81.91729018 | 2021-10-30 04:22:03 | Coshocton, Ohio, US | |
3493200 | 3493200 | 2021-10-26 | US | Illinois | Montgomery | 17135 | 4957 | 83 | 0 | 39.23198845 | -89.47809254 | 2021-10-27 04:22:32 | Montgomery, Illinois, US | |
937030 | 937030 | 2021-10-16 | US | New York | Columbia | 36021 | 4957 | 111 | 0 | 42.24819348 | -73.63089095 | 2021-10-17 04:21:29 | Columbia, New York, US | |
1495028 | 1495028 | 2021-10-12 | US | Virginia | Wise | 51195 | 4957 | 122 | 0 | 36.9746148 | -82.62410519 | 2021-10-13 04:20:51 | Wise, Virginia, US | |
709502 | 709502 | 2021-09-29 | US | Texas | DeWitt | 48123 | 4957 | 76 | 0 | 29.08101855 | -97.35681170000001 | 2021-09-30 04:21:20 | DeWitt, Texas, US | |
1337344 | 1337344 | 2021-09-28 | US | Texas | DeWitt | 48123 | 4957 | 75 | 0 | 29.08101855 | -97.35681170000001 | 2021-09-29 04:21:45 | DeWitt, Texas, US | |
1335425 | 1335425 | 2021-09-28 | US | Indiana | Wabash | 18169 | 4957 | 93 | 0 | 40.84704239 | -85.79328272 | 2021-09-29 04:21:45 | Wabash, Indiana, US | |
16110 | 16110 | 2021-09-18 | Brunei | 4957 | 26 | 0 | 4.5353 | 114.7277 | 2021-09-19 04:21:34 | Brunei | ||||
2808796 | 2808796 | 2021-09-16 | Japan | Yamanashi | 4957 | 29 | 0 | 35.612364 | 138.61148899999998 | 2021-09-17 04:21:46 | Yamanashi, Japan | |||
3977607 | 3977607 | 2021-09-03 | US | Texas | Cherokee | 48073 | 4957 | 156 | 0 | 31.837258000000002 | -95.16559897 | 2021-09-04 04:21:28 | Cherokee, Texas, US | |
3168645 | 3168645 | 2021-08-23 | US | Texas | Bee | 48025 | 4957 | 81 | 0 | 28.41761668 | -97.74215593 | 2021-08-24 04:21:19 | Bee, Texas, US | |
3166383 | 3166383 | 2021-08-23 | US | Georgia | Bryan | 13029 | 4957 | 42 | 0 | 32.00979311 | -81.44002948 | 2021-08-24 04:21:19 | Bryan, Georgia, US | |
2178572 | 2178572 | 2021-08-22 | US | Texas | Bee | 48025 | 4957 | 81 | 0 | 28.41761668 | -97.74215593 | 2021-08-23 04:21:27 | Bee, Texas, US | |
1344613 | 1344613 | 2021-08-11 | US | North Carolina | Haywood | 37087 | 4957 | 100 | 0 | 35.55269063 | -82.98196486 | 2021-08-12 04:21:25 | Haywood, North Carolina, US | |
1344164 | 1344164 | 2021-08-11 | US | Missouri | Butler | 29023 | 4957 | 55 | 0 | 36.71462476 | -90.40421163 | 2021-08-12 04:21:25 | Butler, Missouri, US | |
652455 | 652455 | 2021-08-09 | US | Ohio | Mercer | 39107 | 4957 | 86 | 0 | 40.54043046 | -84.62912742 | 2021-08-10 04:21:27 | Mercer, Ohio, US | |
332966 | 332966 | 2021-08-04 | US | Illinois | Woodford | 17203 | 4957 | 83 | 0 | 40.78579374 | -89.20973757 | 2021-08-05 04:21:51 | Woodford, Illinois, US | |
3471451 | 3471451 | 2021-08-03 | US | Utah | Wasatch | 49051 | 4957 | 22 | 0 | 40.33110236 | -111.1691419 | 2021-08-04 04:21:25 | Wasatch, Utah, US | |
581158 | 581158 | 2021-07-13 | US | North Carolina | Hoke | 37093 | 4957 | 56 | 0 | 35.01888303 | -79.23651674 | 2021-07-14 04:21:35 | Hoke, North Carolina, US | |
1894021 | 1894021 | 2021-06-30 | US | Georgia | Tift | 13277 | 4957 | 132 | 0 | 31.45743864 | -83.5236119 | 2021-07-01 04:21:19 | Tift, Georgia, US | |
401144 | 401144 | 2021-06-29 | US | Georgia | Tift | 13277 | 4957 | 132 | 0 | 31.45743864 | -83.5236119 | 2021-06-30 04:21:41 | Tift, Georgia, US | |
2423769 | 2423769 | 2021-06-23 | US | Georgia | Tift | 13277 | 4957 | 131 | 0 | 31.45743864 | -83.5236119 | 2021-06-24 04:21:55 | Tift, Georgia, US | |
563846 | 563846 | 2021-06-22 | US | Georgia | Tift | 13277 | 4957 | 131 | 0 | 31.45743864 | -83.5236119 | 2021-06-23 04:21:46 | Tift, Georgia, US | |
2340285 | 2340285 | 2021-06-15 | US | Georgia | Ware | 13299 | 4957 | 179 | 0 | 31.05449097 | -82.42224148 | 2021-06-16 04:22:32 | Ware, Georgia, US | |
1737398 | 1737398 | 2021-06-12 | US | Georgia | Ware | 13299 | 4957 | 179 | 0 | 31.05449097 | -82.42224148 | 2021-06-13 04:22:44 | Ware, Georgia, US | |
1710742 | 1710742 | 2021-06-02 | US | North Dakota | Williams | 38105 | 4957 | 40 | 0 | 48.34522353 | -103.4793387 | 2021-06-03 04:23:32 | Williams, North Dakota, US | |
1915649 | 1915649 | 2021-05-20 | US | Ohio | Auglaize | 39011 | 4957 | 87 | 0 | 40.55998859 | -84.22421429999999 | 2021-05-21 04:20:43 | Auglaize, Ohio, US | |
1876521 | 1876521 | 2021-05-15 | US | Wisconsin | Pierce | 55093 | 4957 | 43 | 0 | 44.71850291 | -92.4224416 | 2021-05-16 04:20:49 | Pierce, Wisconsin, US | |
1084546 | 1084546 | 2021-05-14 | US | Oregon | Linn | 41043 | 4957 | 68 | 0 | 44.48899494 | -122.5373154 | 2021-05-15 04:20:58 | Linn, Oregon, US | |
3925104 | 3925104 | 2021-04-24 | US | Indiana | Jackson | 18071 | 4957 | 72 | 0 | 38.90915820000001 | -86.03851889 | 2021-04-25 04:20:32 | Jackson, Indiana, US | |
1843854 | 1843854 | 2021-04-14 | US | Missouri | Johnson | 29101 | 4957 | 49 | 0 | 38.74719601 | -93.80691168 | 2021-04-15 04:20:54 | Johnson, Missouri, US | |
3005577 | 3005577 | 2021-04-06 | US | New York | Wayne | 36117 | 4957 | 66 | 0 | 43.15494365 | -77.02976528 | 2021-04-07 04:20:53 | Wayne, New York, US | |
390867 | 390867 | 2021-04-04 | US | Pennsylvania | Bradford | 42015 | 4957 | 84 | 0 | 41.78869215 | -76.51570822 | 2021-04-05 04:20:35 | Bradford, Pennsylvania, 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]);