johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
137 rows where confirmed = 5165 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328709 | 328709 | 2022-12-27 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-28 04:21:04 | Elbert, Georgia, US | |
218782 | 218782 | 2022-12-26 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-27 04:21:07 | Elbert, Georgia, US | |
3223239 | 3223239 | 2022-12-25 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-26 04:21:06 | Elbert, Georgia, US | |
1019153 | 1019153 | 2022-12-24 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-25 04:21:04 | Elbert, Georgia, US | |
691176 | 691176 | 2022-12-23 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-24 04:21:02 | Elbert, Georgia, US | |
2180386 | 2180386 | 2022-12-22 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-23 04:21:04 | Elbert, Georgia, US | |
452190 | 452190 | 2022-12-21 | US | Georgia | Elbert | 13105 | 5165 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-12-22 04:20:56 | Elbert, Georgia, US | |
1965637 | 1965637 | 2022-11-30 | US | Illinois | White | 17193 | 5165 | 53 | 0 | 38.08706198 | -88.17657461 | 2022-12-01 04:21:03 | White, Illinois, US | |
483132 | 483132 | 2022-11-08 | US | Wisconsin | Crawford | 55023 | 5165 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-11-09 04:21:22 | Crawford, Wisconsin, US | |
2442282 | 2442282 | 2022-11-07 | US | Wisconsin | Crawford | 55023 | 5165 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-11-08 04:21:21 | Crawford, Wisconsin, US | |
539792 | 539792 | 2022-10-26 | US | Illinois | Piatt | 17147 | 5165 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-10-27 04:22:01 | Piatt, Illinois, US | |
1831193 | 1831193 | 2022-10-25 | US | Illinois | Piatt | 17147 | 5165 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-10-26 04:22:19 | Piatt, Illinois, US | |
4005589 | 4005589 | 2022-10-08 | US | Tennessee | Bledsoe | 47007 | 5165 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-09 04:21:16 | Bledsoe, Tennessee, US | |
1627816 | 1627816 | 2022-09-22 | US | West Virginia | Wetzel | 54103 | 5165 | 90 | 0 | 39.6065771 | -80.6401654 | 2022-09-23 04:23:13 | Wetzel, West Virginia, US | |
3774391 | 3774391 | 2022-08-30 | US | Arkansas | Drew | 5043 | 5165 | 73 | 0 | 33.59035001 | -91.71777921 | 2022-08-31 04:20:57 | Drew, Arkansas, US | |
2497120 | 2497120 | 2022-08-15 | US | Texas | Fayette | 48149 | 5165 | 113 | 0 | 29.87788372 | -96.92076062 | 2022-08-16 04:20:58 | Fayette, Texas, US | |
3911520 | 3911520 | 2022-08-11 | US | West Virginia | Taylor | 54091 | 5165 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-08-12 04:20:54 | Taylor, West Virginia, US | |
1069461 | 1069461 | 2022-07-28 | US | Wisconsin | Sawyer | 55113 | 5165 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-29 04:20:45 | Sawyer, Wisconsin, US | |
1066255 | 1066255 | 2022-07-28 | US | Alabama | Hale | 1065 | 5165 | 108 | 0 | 32.76039258 | -87.63284988 | 2022-07-29 04:20:45 | Hale, Alabama, US | |
2335913 | 2335913 | 2022-07-27 | US | Arkansas | Phillips | 5107 | 5165 | 100 | 0 | 34.43268455 | -90.84800154 | 2022-07-28 04:20:56 | Phillips, Arkansas, US | |
1488344 | 1488344 | 2022-07-26 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-27 04:21:04 | Berrien, Georgia, US | |
2594790 | 2594790 | 2022-07-25 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-26 04:20:58 | Berrien, Georgia, US | |
896905 | 896905 | 2022-07-24 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-25 04:20:51 | Berrien, Georgia, US | |
91899 | 91899 | 2022-07-23 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-24 04:20:47 | Berrien, Georgia, US | |
91742 | 91742 | 2022-07-23 | US | Colorado | Alamosa | 8003 | 5165 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-24 04:20:47 | Alamosa, Colorado, US | |
900921 | 900921 | 2022-07-22 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-23 04:20:53 | Berrien, Georgia, US | |
671057 | 671057 | 2022-07-21 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-22 04:21:15 | Berrien, Georgia, US | |
1609020 | 1609020 | 2022-07-20 | US | Georgia | Berrien | 13019 | 5165 | 85 | 0 | 31.27590016 | -83.2252992 | 2022-07-21 04:21:10 | Berrien, Georgia, US | |
3112957 | 3112957 | 2022-07-13 | US | West Virginia | Barbour | 54001 | 5165 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-07-14 04:20:57 | Barbour, West Virginia, US | |
558958 | 558958 | 2022-06-16 | Palau | 5165 | 6 | 0 | 7.515 | 134.5825 | 2022-06-17 04:20:56 | Palau | ||||
3982760 | 3982760 | 2022-06-15 | Palau | 5165 | 6 | 0 | 7.515 | 134.5825 | 2022-06-16 04:20:55 | Palau | ||||
947354 | 947354 | 2022-06-14 | US | Arkansas | Logan | 5083 | 5165 | 79 | 0 | 35.21413234 | -93.71951016 | 2022-06-15 04:20:54 | Logan, Arkansas, US | |
947001 | 947001 | 2022-06-14 | Palau | 5165 | 6 | 0 | 7.515 | 134.5825 | 2022-06-15 04:20:54 | Palau | ||||
2982582 | 2982582 | 2022-06-13 | US | Virginia | Colonial Heights | 51570 | 5165 | 99 | 0 | 37.26420587 | -77.39609676 | 2022-06-14 04:20:52 | Colonial Heights, Virginia, US | |
2982416 | 2982416 | 2022-06-13 | US | Texas | Limestone | 48293 | 5165 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-14 04:20:52 | Limestone, Texas, US | |
3537801 | 3537801 | 2022-05-10 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-11 04:20:48 | Madison, North Carolina, US | |
3536502 | 3536502 | 2022-05-10 | US | Illinois | Richland | 17159 | 5165 | 74 | 0 | 38.71240969 | -88.08475366 | 2022-05-11 04:20:48 | Richland, Illinois, US | |
224336 | 224336 | 2022-05-09 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-10 04:20:50 | Madison, North Carolina, US | |
2333721 | 2333721 | 2022-05-08 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-09 04:20:54 | Madison, North Carolina, US | |
362683 | 362683 | 2022-05-07 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-08 04:20:49 | Madison, North Carolina, US | |
1400034 | 1400034 | 2022-05-06 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-07 04:21:09 | Madison, North Carolina, US | |
2600389 | 2600389 | 2022-05-05 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-06 04:21:00 | Madison, North Carolina, US | |
3267838 | 3267838 | 2022-05-04 | US | North Carolina | Madison | 37115 | 5165 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-05 04:20:55 | Madison, North Carolina, US | |
465560 | 465560 | 2022-05-02 | US | New Hampshire | Unassigned | 90033 | 5165 | 2 | 0 | 44.69063265 | 0.0 | 2022-05-03 04:21:00 | Unassigned, New Hampshire, US | |
3854085 | 3854085 | 2022-04-27 | US | New York | Schoharie | 36095 | 5165 | 36 | 0 | 42.58831742 | -74.44339029999999 | 2022-04-28 04:20:47 | Schoharie, New York, US | |
1437106 | 1437106 | 2022-03-28 | US | Arkansas | Randolph | 5121 | 5165 | 83 | 0 | 36.3415714 | -91.02455531 | 2022-03-29 04:20:46 | Randolph, Arkansas, US | |
876787 | 876787 | 2022-03-27 | US | Arkansas | Randolph | 5121 | 5165 | 83 | 0 | 36.3415714 | -91.02455531 | 2022-03-28 04:20:33 | Randolph, Arkansas, US | |
2164070 | 2164070 | 2022-03-26 | US | Arkansas | Randolph | 5121 | 5165 | 83 | 0 | 36.3415714 | -91.02455531 | 2022-03-27 04:20:47 | Randolph, Arkansas, US | |
3023863 | 3023863 | 2022-03-23 | US | Maryland | Somerset | 24039 | 5165 | 73 | 0 | 38.1163542 | -75.75118623 | 2022-03-24 04:20:43 | Somerset, Maryland, US | |
3238717 | 3238717 | 2022-03-21 | US | Alabama | Marengo | 1091 | 5165 | 106 | 0 | 32.24767634 | -87.78796182 | 2022-03-22 04:20:54 | Marengo, Alabama, US | |
951365 | 951365 | 2022-03-12 | US | Arkansas | Lawrence | 5075 | 5165 | 74 | 0 | 36.04188196 | -91.10867198 | 2022-03-13 04:20:49 | Lawrence, Arkansas, US | |
2142374 | 2142374 | 2022-03-09 | US | New Mexico | Lincoln | 35027 | 5165 | 64 | 0 | 33.74526079 | -105.4586166 | 2022-03-10 04:20:48 | Lincoln, New Mexico, US | |
1647293 | 1647293 | 2022-03-03 | US | Tennessee | Crockett | 47033 | 5165 | 82 | 0 | 35.81830662 | -89.14916269 | 2022-03-04 04:21:09 | Crockett, Tennessee, US | |
2525764 | 2525764 | 2022-03-02 | US | Alabama | Pickens | 1107 | 5165 | 97 | 0 | 33.28094866 | -88.08818103 | 2022-03-03 04:21:01 | Pickens, Alabama, US | |
575304 | 575304 | 2022-02-25 | US | Arkansas | Clark | 5019 | 5165 | 74 | 0 | 34.04613432 | -93.17484713 | 2022-02-26 04:21:12 | Clark, Arkansas, US | |
1514899 | 1514899 | 2022-02-24 | US | West Virginia | Lewis | 54041 | 5165 | 78 | 0 | 38.9947249 | -80.49988181 | 2022-02-25 04:21:11 | Lewis, West Virginia, US | |
3822654 | 3822654 | 2022-02-16 | US | New Mexico | Taos | 35055 | 5165 | 84 | 0 | 36.58006022 | -105.63101979999999 | 2022-02-17 04:20:56 | Taos, New Mexico, US | |
3821230 | 3821230 | 2022-02-16 | US | Georgia | Dodge | 13091 | 5165 | 141 | 0 | 32.17265114 | -83.16948926 | 2022-02-17 04:20:56 | Dodge, Georgia, US | |
1362746 | 1362746 | 2022-02-08 | US | Alabama | Monroe | 1099 | 5165 | 71 | 0 | 31.56729412 | -87.36995001 | 2022-02-09 04:21:04 | Monroe, Alabama, US | |
2474468 | 2474468 | 2022-02-03 | US | Arkansas | Ouachita | 5103 | 5165 | 92 | 0 | 33.58839816 | -92.87795984 | 2022-02-04 04:21:10 | Ouachita, Arkansas, US | |
3426928 | 3426928 | 2022-01-21 | US | Missouri | Washington | 29221 | 5165 | 116 | 0 | 37.96130078 | -90.87948158 | 2022-01-22 04:21:13 | Washington, Missouri, US | |
1693847 | 1693847 | 2022-01-10 | US | Louisiana | Sabine | 22085 | 5165 | 99 | 0 | 31.56388699 | -93.55433981 | 2022-01-11 04:22:01 | Sabine, Louisiana, US | |
2613363 | 2613363 | 2022-01-06 | US | Virginia | Caroline | 51033 | 5165 | 58 | 0 | 38.02679129 | -77.34901405 | 2022-01-07 04:22:09 | Caroline, Virginia, US | |
3519465 | 3519465 | 2022-01-02 | Japan | Yamanashi | 5165 | 29 | 0 | 35.612364 | 138.61148899999998 | 2022-01-03 02:22:25 | Yamanashi, Japan | |||
800568 | 800568 | 2021-12-22 | US | Nevada | Douglas | 32005 | 5165 | 74 | 0 | 38.912862 | -119.61713329999999 | 2021-12-23 04:21:21 | Douglas, Nevada, US | |
1233373 | 1233373 | 2021-11-28 | US | Minnesota | Mille Lacs | 27095 | 5165 | 73 | 0 | 45.93705297 | -93.63236823 | 2021-11-29 04:22:30 | Mille Lacs, Minnesota, US | |
1360080 | 1360080 | 2021-11-27 | US | Minnesota | Mille Lacs | 27095 | 5165 | 73 | 0 | 45.93705297 | -93.63236823 | 2021-11-28 04:22:43 | Mille Lacs, Minnesota, US | |
760071 | 760071 | 2021-11-26 | US | Minnesota | Mille Lacs | 27095 | 5165 | 73 | 0 | 45.93705297 | -93.63236823 | 2021-11-27 04:22:45 | Mille Lacs, Minnesota, US | |
3072842 | 3072842 | 2021-11-23 | US | South Carolina | Clarendon | 45027 | 5165 | 136 | 0 | 33.66610974 | -80.21647898 | 2021-11-24 04:22:14 | Clarendon, South Carolina, US | |
3071043 | 3071043 | 2021-11-23 | US | Illinois | Logan | 17107 | 5165 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-24 04:22:14 | Logan, Illinois, US | |
3751940 | 3751940 | 2021-11-22 | US | South Carolina | Clarendon | 45027 | 5165 | 136 | 0 | 33.66610974 | -80.21647898 | 2021-11-23 04:22:39 | Clarendon, South Carolina, US | |
1017782 | 1017782 | 2021-11-21 | US | Washington | Kittitas | 53037 | 5165 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-11-22 04:22:20 | Kittitas, Washington, US | |
725946 | 725946 | 2021-11-20 | US | Washington | Kittitas | 53037 | 5165 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-11-21 04:22:13 | Kittitas, Washington, US | |
165476 | 165476 | 2021-11-19 | US | Washington | Kittitas | 53037 | 5165 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-11-20 04:22:17 | Kittitas, Washington, US | |
1324209 | 1324209 | 2021-11-14 | US | Missouri | Warren | 29219 | 5165 | 50 | 0 | 38.76529479 | -91.16124662 | 2021-11-15 04:21:36 | Warren, Missouri, US | |
699702 | 699702 | 2021-11-04 | US | Kansas | Harvey | 20079 | 5165 | 84 | 0 | 38.04293782 | -97.42747573 | 2021-11-05 04:21:54 | Harvey, Kansas, US | |
277480 | 277480 | 2021-11-03 | US | Kansas | Harvey | 20079 | 5165 | 84 | 0 | 38.04293782 | -97.42747573 | 2021-11-04 04:22:20 | Harvey, Kansas, US | |
3512433 | 3512433 | 2021-11-01 | US | Illinois | Morgan | 17137 | 5165 | 100 | 0 | 39.71654544 | -90.20255104 | 2021-11-02 04:22:03 | Morgan, Illinois, US | |
290608 | 290608 | 2021-10-31 | US | Oregon | Coos | 41011 | 5165 | 96 | 0 | 43.17406868 | -124.0594514 | 2021-11-01 04:22:01 | Coos, Oregon, US | |
2723614 | 2723614 | 2021-10-30 | US | Oregon | Coos | 41011 | 5165 | 96 | 0 | 43.17406868 | -124.0594514 | 2021-10-31 04:22:08 | Coos, Oregon, US | |
569716 | 569716 | 2021-10-29 | US | Oregon | Coos | 41011 | 5165 | 96 | 0 | 43.17406868 | -124.0594514 | 2021-10-30 04:22:03 | Coos, Oregon, US | |
2126245 | 2126245 | 2021-10-21 | US | Ohio | Perry | 39127 | 5165 | 74 | 0 | 39.73508655 | -82.23804971 | 2021-10-22 04:21:14 | Perry, Ohio, US | |
1492590 | 1492590 | 2021-10-12 | US | Illinois | Fulton | 17057 | 5165 | 73 | 0 | 40.47289135 | -90.20862357 | 2021-10-13 04:20:51 | Fulton, Illinois, US | |
603457 | 603457 | 2021-09-23 | US | Minnesota | Steele | 27147 | 5165 | 21 | 0 | 44.02240351 | -93.22627088 | 2021-09-24 04:21:44 | Steele, Minnesota, US | |
3012217 | 3012217 | 2021-09-22 | US | Georgia | Toombs | 13279 | 5165 | 148 | 0 | 32.12059861 | -82.32957247 | 2021-09-23 04:21:43 | Toombs, Georgia, US | |
3011380 | 3011380 | 2021-09-22 | Japan | Wakayama | 5165 | 59 | 0 | 33.911879 | 135.505446 | 2021-09-23 04:21:43 | Wakayama, Japan | |||
3758677 | 3758677 | 2021-09-21 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-22 04:21:45 | Jasper, Iowa, US | |
810780 | 810780 | 2021-09-20 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-21 04:21:26 | Jasper, Iowa, US | |
1815979 | 1815979 | 2021-09-19 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-20 04:21:22 | Jasper, Iowa, US | |
17559 | 17559 | 2021-09-18 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-19 04:21:34 | Jasper, Iowa, US | |
2619244 | 2619244 | 2021-09-17 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-18 04:21:24 | Jasper, Iowa, US | |
2809952 | 2809952 | 2021-09-16 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-17 04:21:46 | Jasper, Iowa, US | |
1375696 | 1375696 | 2021-09-15 | US | Iowa | Jasper | 19099 | 5165 | 75 | 0 | 41.68576082 | -93.05567785 | 2021-09-16 04:22:19 | Jasper, Iowa, US | |
1386160 | 1386160 | 2021-09-13 | US | Arkansas | Union | 5139 | 5165 | 125 | 0 | 33.16887091 | -92.59746952 | 2021-09-14 04:21:41 | Union, Arkansas, US | |
1778927 | 1778927 | 2021-08-30 | US | Wisconsin | Polk | 55095 | 5165 | 69 | 0 | 45.46130348 | -92.44182875 | 2021-08-31 04:21:46 | Polk, Wisconsin, US | |
3895494 | 3895494 | 2021-08-29 | US | Wisconsin | Monroe | 55081 | 5165 | 52 | 0 | 43.94641218 | -90.61881899999999 | 2021-08-30 04:21:23 | Monroe, Wisconsin, US | |
2796597 | 2796597 | 2021-08-28 | US | Wisconsin | Monroe | 55081 | 5165 | 52 | 0 | 43.94641218 | -90.61881899999999 | 2021-08-29 04:21:14 | Monroe, Wisconsin, US | |
2926756 | 2926756 | 2021-08-27 | US | Wisconsin | Monroe | 55081 | 5165 | 52 | 0 | 43.94641218 | -90.61881899999999 | 2021-08-28 04:21:28 | Monroe, Wisconsin, US | |
3166686 | 3166686 | 2021-08-23 | US | Illinois | Woodford | 17203 | 5165 | 84 | 0 | 40.78579374 | -89.20973757 | 2021-08-24 04:21:19 | Woodford, Illinois, US | |
2519008 | 2519008 | 2021-08-18 | US | Georgia | Liberty | 13179 | 5165 | 73 | 0 | 31.82588896 | -81.49251135 | 2021-08-19 04:21:15 | Liberty, Georgia, 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]);