johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
192 rows where confirmed = 3677 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712018 | 712018 | 2022-11-01 | US | Maine | Piscataquis | 23021 | 3677 | 40 | 0 | 45.83839062 | -69.2860223 | 2022-11-02 04:22:09 | Piscataquis, Maine, US | |
2027173 | 2027173 | 2022-10-17 | US | North Dakota | Mountrail | 38061 | 3677 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-10-18 04:22:42 | Mountrail, North Dakota, US | |
854122 | 854122 | 2022-09-30 | US | Arkansas | Little River | 5081 | 3677 | 107 | 0 | 33.70375665 | -94.23468591 | 2022-10-01 04:23:01 | Little River, Arkansas, US | |
2376048 | 2376048 | 2022-09-29 | US | Arkansas | Little River | 5081 | 3677 | 107 | 0 | 33.70375665 | -94.23468591 | 2022-09-30 04:23:09 | Little River, Arkansas, US | |
116271 | 116271 | 2022-09-06 | US | Louisiana | Madison | 22065 | 3677 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-09-07 04:20:59 | Madison, Louisiana, US | |
1251981 | 1251981 | 2022-08-23 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-24 04:20:46 | Mills, Iowa, US | |
2854085 | 2854085 | 2022-08-22 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-23 04:20:56 | Mills, Iowa, US | |
2404057 | 2404057 | 2022-08-21 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-22 04:20:38 | Mills, Iowa, US | |
3799135 | 3799135 | 2022-08-20 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-21 04:20:44 | Mills, Iowa, US | |
2364721 | 2364721 | 2022-08-19 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-20 04:21:01 | Mills, Iowa, US | |
1162392 | 1162392 | 2022-08-18 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-19 04:20:54 | Mills, Iowa, US | |
3951716 | 3951716 | 2022-08-17 | US | Iowa | Mills | 19129 | 3677 | 45 | 0 | 41.03299766 | -95.61920963 | 2022-08-18 04:21:11 | Mills, Iowa, US | |
1065663 | 1065663 | 2022-07-28 | China | Fujian | 3677 | 1 | 0 | 26.0789 | 117.9874 | 2022-07-29 04:20:45 | Fujian, China | |||
903420 | 903420 | 2022-07-22 | US | Texas | Wilbarger | 48487 | 3677 | 88 | 0 | 34.07945812 | -99.24178437 | 2022-07-23 04:20:53 | Wilbarger, Texas, US | |
2152283 | 2152283 | 2022-07-16 | US | Colorado | Gunnison | 8051 | 3677 | 14 | 0 | 38.66611652 | -107.0320729 | 2022-07-17 04:21:15 | Gunnison, Colorado, US | |
1764878 | 1764878 | 2022-06-20 | US | Louisiana | West Carroll | 22123 | 3677 | 66 | 0 | 32.78550125 | -91.461201 | 2022-06-21 04:20:56 | West Carroll, Louisiana, US | |
3159366 | 3159366 | 2022-06-09 | US | Minnesota | Kanabec | 27065 | 3677 | 57 | 0 | 45.9459309 | -93.29275192 | 2022-06-10 04:20:55 | Kanabec, Minnesota, US | |
3510921 | 3510921 | 2022-06-05 | US | Wisconsin | Buffalo | 55011 | 3677 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-06-06 04:20:57 | Buffalo, Wisconsin, US | |
3530998 | 3530998 | 2022-06-04 | US | Wisconsin | Buffalo | 55011 | 3677 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-06-05 04:20:55 | Buffalo, Wisconsin, US | |
3137084 | 3137084 | 2022-06-03 | US | Wisconsin | Buffalo | 55011 | 3677 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-06-04 04:20:58 | Buffalo, Wisconsin, US | |
230094 | 230094 | 2022-05-31 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-06-01 04:20:55 | Rabun, Georgia, US | |
3186859 | 3186859 | 2022-05-30 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-31 04:20:51 | Rabun, Georgia, US | |
3199008 | 3199008 | 2022-05-29 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-30 04:20:50 | Rabun, Georgia, US | |
2725886 | 2725886 | 2022-05-28 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-29 04:20:53 | Rabun, Georgia, US | |
1315067 | 1315067 | 2022-05-27 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-28 04:21:07 | Rabun, Georgia, US | |
1850859 | 1850859 | 2022-05-26 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-27 04:20:56 | Rabun, Georgia, US | |
2048735 | 2048735 | 2022-05-25 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-26 04:20:50 | Rabun, Georgia, US | |
622746 | 622746 | 2022-05-22 | US | Georgia | Rabun | 13241 | 3677 | 99 | 0 | 34.88389445 | -83.40304637 | 2022-05-26 04:20:50 | Rabun, Georgia, US | |
3357427 | 3357427 | 2022-05-14 | US | Puerto Rico | Loiza | 72087 | 3677 | 0 | 0 | 18.425688 | -65.89943 | 2022-05-15 04:20:53 | Loiza, Puerto Rico, US | |
3447465 | 3447465 | 2022-05-11 | US | Oregon | Hood River | 41027 | 3677 | 43 | 0 | 45.51872811 | -121.6552036 | 2022-05-12 04:20:54 | Hood River, Oregon, US | |
466785 | 466785 | 2022-05-02 | US | Virginia | Patrick | 51141 | 3677 | 98 | 0 | 36.6801638 | -80.2865648 | 2022-05-03 04:21:00 | Patrick, Virginia, US | |
2252631 | 2252631 | 2022-04-19 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-20 04:20:45 | Iowa, Iowa, US | |
1847181 | 1847181 | 2022-04-18 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-19 04:21:00 | Iowa, Iowa, US | |
3418125 | 3418125 | 2022-04-17 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-18 04:21:12 | Iowa, Iowa, US | |
305074 | 305074 | 2022-04-16 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-17 04:20:59 | Iowa, Iowa, US | |
2671019 | 2671019 | 2022-04-15 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-16 04:20:48 | Iowa, Iowa, US | |
1224804 | 1224804 | 2022-04-14 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-15 04:20:57 | Iowa, Iowa, US | |
2443962 | 2443962 | 2022-04-13 | US | Iowa | Iowa | 19095 | 3677 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-04-13 23:21:06 | Iowa, Iowa, US | |
879626 | 879626 | 2022-03-27 | US | Virginia | King William | 51101 | 3677 | 37 | 0 | 37.70965316 | -77.09384941 | 2022-03-28 04:20:33 | King William, Virginia, US | |
2166909 | 2166909 | 2022-03-26 | US | Virginia | King William | 51101 | 3677 | 37 | 0 | 37.70965316 | -77.09384941 | 2022-03-27 04:20:47 | King William, Virginia, US | |
1723845 | 1723845 | 2022-03-25 | US | Virginia | King William | 51101 | 3677 | 37 | 0 | 37.70965316 | -77.09384941 | 2022-03-26 04:20:23 | King William, Virginia, US | |
1906857 | 1906857 | 2022-03-22 | US | Michigan | Manistee | 26101 | 3677 | 86 | 0 | 44.33352407 | -86.05626916 | 2022-03-23 04:20:48 | Manistee, Michigan, US | |
3239988 | 3239988 | 2022-03-21 | US | Michigan | Manistee | 26101 | 3677 | 86 | 0 | 44.33352407 | -86.05626916 | 2022-03-22 04:20:54 | Manistee, Michigan, US | |
1647735 | 1647735 | 2022-03-03 | US | Virginia | Manassas Park | 51685 | 3677 | 25 | 0 | 38.77058531 | -77.44399307 | 2022-03-04 04:21:09 | Manassas Park, Virginia, US | |
1514343 | 1514343 | 2022-02-24 | US | Tennessee | Decatur | 47039 | 3677 | 63 | 0 | 35.60048904 | -88.11043779 | 2022-02-25 04:21:11 | Decatur, Tennessee, US | |
3878294 | 3878294 | 2022-02-19 | US | Puerto Rico | Aguas Buenas | 72007 | 3677 | 0 | 0 | 18.251619 | -66.126806 | 2022-02-20 04:21:00 | Aguas Buenas, Puerto Rico, US | |
1466814 | 1466814 | 2022-02-10 | US | Puerto Rico | Catano | 72033 | 3677 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-02-11 04:21:09 | Catano, Puerto Rico, US | |
982334 | 982334 | 2022-02-01 | US | Virginia | Nottoway | 51135 | 3677 | 74 | 0 | 37.1435975 | -78.05065922 | 2022-02-02 04:21:09 | Nottoway, Virginia, US | |
979454 | 979454 | 2022-02-01 | US | Arkansas | Madison | 5087 | 3677 | 47 | 0 | 36.01038185 | -93.72524943 | 2022-02-02 04:21:09 | Madison, Arkansas, US | |
3303152 | 3303152 | 2022-01-30 | US | Tennessee | Grundy | 47061 | 3677 | 67 | 0 | 35.38433717 | -85.72142731 | 2022-01-31 04:21:09 | Grundy, Tennessee, US | |
1782308 | 1782308 | 2022-01-27 | US | Tennessee | Cannon | 47015 | 3677 | 52 | 0 | 35.80990797 | -86.05738983 | 2022-01-28 04:21:09 | Cannon, Tennessee, US | |
1229046 | 1229046 | 2022-01-24 | US | Kentucky | Lewis | 21135 | 3677 | 72 | 0 | 38.53184419 | -83.37735618 | 2022-01-25 04:21:05 | Lewis, Kentucky, US | |
3467176 | 3467176 | 2022-01-18 | US | Tennessee | Trousdale | 47169 | 3677 | 38 | 0 | 36.39026213 | -86.16087954 | 2022-01-19 04:21:23 | Trousdale, Tennessee, US | |
1474838 | 1474838 | 2022-01-17 | US | Puerto Rico | Barranquitas | 72019 | 3677 | 0 | 0 | 18.201592 | -66.30963 | 2022-01-18 04:21:04 | Barranquitas, Puerto Rico, US | |
3690172 | 3690172 | 2022-01-13 | US | Pennsylvania | Montour | 42093 | 3677 | 83 | 0 | 41.03023987 | -76.66345939 | 2022-01-14 04:21:54 | Montour, Pennsylvania, US | |
130315 | 130315 | 2022-01-09 | US | Wisconsin | Sawyer | 55113 | 3677 | 50 | 0 | 45.87931905 | -91.14504927 | 2022-01-10 04:22:07 | Sawyer, Wisconsin, US | |
1219150 | 1219150 | 2022-01-08 | US | Wisconsin | Sawyer | 55113 | 3677 | 50 | 0 | 45.87931905 | -91.14504927 | 2022-01-09 04:21:46 | Sawyer, Wisconsin, US | |
1393243 | 1393243 | 2022-01-07 | US | Wisconsin | Sawyer | 55113 | 3677 | 50 | 0 | 45.87931905 | -91.14504927 | 2022-01-08 04:21:53 | Sawyer, Wisconsin, US | |
2610524 | 2610524 | 2022-01-06 | US | Arkansas | Conway | 5029 | 3677 | 49 | 0 | 35.26205537 | -92.70506566 | 2022-01-07 04:22:09 | Conway, Arkansas, US | |
3522350 | 3522350 | 2022-01-02 | US | Tennessee | Bledsoe | 47007 | 3677 | 39 | 0 | 35.59942968 | -85.20611967 | 2022-01-03 02:22:25 | Bledsoe, Tennessee, US | |
731319 | 731319 | 2021-12-27 | US | Georgia | Dodge | 13091 | 3677 | 135 | 0 | 32.17265114 | -83.16948926 | 2021-12-28 04:21:47 | Dodge, Georgia, US | |
3829611 | 3829611 | 2021-12-21 | US | Indiana | Sullivan | 18153 | 3677 | 56 | 0 | 39.08952258 | -87.41414469 | 2021-12-22 04:21:54 | Sullivan, Indiana, US | |
1256891 | 1256891 | 2021-12-20 | US | Nebraska | Saunders | 31155 | 3677 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2021-12-21 03:21:27 | Saunders, Nebraska, US | |
1261940 | 1261940 | 2021-12-18 | US | Texas | Lamb | 48279 | 3677 | 97 | 0 | 34.06859623 | -102.35162890000001 | 2021-12-19 04:21:11 | Lamb, Texas, US | |
1717247 | 1717247 | 2021-12-16 | US | Georgia | Union | 13291 | 3677 | 130 | 0 | 34.82995757 | -83.98967069 | 2021-12-17 04:22:14 | Union, Georgia, US | |
2088951 | 2088951 | 2021-12-14 | US | Illinois | Crawford | 17033 | 3677 | 31 | 0 | 39.0032229 | -87.75954624 | 2021-12-15 03:22:16 | Crawford, Illinois, US | |
1079371 | 1079371 | 2021-12-09 | US | Kentucky | Meade | 21163 | 3677 | 47 | 0 | 37.96163597 | -86.21028219 | 2021-12-10 04:22:28 | Meade, Kentucky, US | |
1031187 | 1031187 | 2021-12-06 | US | Georgia | Grady | 13131 | 3677 | 92 | 0 | 30.87454847 | -84.23418364 | 2021-12-07 04:22:34 | Grady, Georgia, US | |
1146373 | 1146373 | 2021-12-01 | US | Kentucky | McCreary | 21147 | 3677 | 60 | 0 | 36.73874143 | -84.48102924 | 2021-12-02 04:22:37 | McCreary, Kentucky, US | |
3404735 | 3404735 | 2021-11-30 | US | Vermont | Windsor | 50027 | 3677 | 33 | 0 | 43.58010937 | -72.58595157 | 2021-12-01 04:22:29 | Windsor, Vermont, US | |
3402612 | 3402612 | 2021-11-30 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-12-01 04:22:29 | Carroll, Iowa, US | |
151155 | 151155 | 2021-11-29 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-30 04:22:53 | Carroll, Iowa, US | |
1232801 | 1232801 | 2021-11-28 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-29 04:22:30 | Carroll, Iowa, US | |
1359508 | 1359508 | 2021-11-27 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-28 04:22:43 | Carroll, Iowa, US | |
1358838 | 1358838 | 2021-11-27 | US | Arkansas | Lincoln | 5079 | 3677 | 57 | 0 | 33.95317155 | -91.74002806 | 2021-11-28 04:22:43 | Lincoln, Arkansas, US | |
759499 | 759499 | 2021-11-26 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-27 04:22:45 | Carroll, Iowa, US | |
1803916 | 1803916 | 2021-11-25 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-26 04:22:33 | Carroll, Iowa, US | |
905350 | 905350 | 2021-11-24 | US | Iowa | Carroll | 19027 | 3677 | 55 | 0 | 42.03617207 | -94.86032705 | 2021-11-25 04:22:33 | Carroll, Iowa, US | |
3071443 | 3071443 | 2021-11-23 | US | Kentucky | Hart | 21099 | 3677 | 72 | 0 | 37.29943898 | -85.88461055 | 2021-11-24 04:22:14 | Hart, Kentucky, US | |
1323720 | 1323720 | 2021-11-14 | US | Louisiana | Assumption | 22007 | 3677 | 57 | 0 | 29.89946234 | -91.06461642 | 2021-11-15 04:21:36 | Assumption, Louisiana, US | |
687846 | 687846 | 2021-11-13 | US | Louisiana | Assumption | 22007 | 3677 | 57 | 0 | 29.89946234 | -91.06461642 | 2021-11-14 04:21:31 | Assumption, Louisiana, US | |
715955 | 715955 | 2021-11-12 | US | Louisiana | Assumption | 22007 | 3677 | 57 | 0 | 29.89946234 | -91.06461642 | 2021-11-13 04:21:38 | Assumption, Louisiana, US | |
2847940 | 2847940 | 2021-11-10 | US | Texas | Fayette | 48149 | 3677 | 93 | 0 | 29.87788372 | -96.92076062 | 2021-11-11 04:21:45 | Fayette, Texas, US | |
90210 | 90210 | 2021-11-09 | US | Texas | Fayette | 48149 | 3677 | 93 | 0 | 29.87788372 | -96.92076062 | 2021-11-10 04:21:38 | Fayette, Texas, US | |
570041 | 570041 | 2021-10-29 | US | Tennessee | Fentress | 47049 | 3677 | 67 | 0 | 36.38128818 | -84.92870012 | 2021-10-30 04:22:03 | Fentress, Tennessee, US | |
537212 | 537212 | 2021-10-27 | US | Ohio | Holmes | 39075 | 3677 | 136 | 0 | 40.56163713 | -81.92635677 | 2021-10-28 04:22:08 | Holmes, Ohio, US | |
2125164 | 2125164 | 2021-10-21 | US | Kentucky | Johnson | 21115 | 3677 | 46 | 0 | 37.85106355 | -82.8264322 | 2021-10-22 04:21:14 | Johnson, Kentucky, US | |
446390 | 446390 | 2021-10-20 | US | Texas | Burleson | 48051 | 3677 | 59 | 0 | 30.49273808 | -96.62158484 | 2021-10-21 04:21:18 | Burleson, Texas, US | |
600296 | 600296 | 2021-10-19 | US | Oregon | Jefferson | 41031 | 3677 | 52 | 0 | 44.62806839 | -121.17832 | 2021-10-20 04:21:00 | Jefferson, Oregon, US | |
2044125 | 2044125 | 2021-10-18 | Sao Tome and Principe | 3677 | 56 | 0 | 0.1864 | 6.6131 | 2021-10-19 04:20:54 | Sao Tome and Principe | ||||
1912751 | 1912751 | 2021-10-17 | US | Wisconsin | Door | 55029 | 3677 | 38 | 0 | 44.95856458 | -87.30002707 | 2021-10-18 04:21:10 | Door, Wisconsin, US | |
1909486 | 1909486 | 2021-10-17 | Sao Tome and Principe | 3677 | 56 | 0 | 0.1864 | 6.6131 | 2021-10-18 04:21:10 | Sao Tome and Principe | ||||
938340 | 938340 | 2021-10-16 | US | Wisconsin | Door | 55029 | 3677 | 38 | 0 | 44.95856458 | -87.30002707 | 2021-10-17 04:21:29 | Door, Wisconsin, US | |
493946 | 493946 | 2021-10-14 | US | North Carolina | Dare | 37055 | 3677 | 12 | 0 | 35.66520691 | -75.71767334 | 2021-10-15 04:21:26 | Dare, North Carolina, US | |
3010684 | 3010684 | 2021-10-11 | US | Virginia | Halifax | 51083 | 3677 | 99 | 0 | 36.76654925 | -78.93512622 | 2021-10-12 04:21:09 | Halifax, Virginia, US | |
426700 | 426700 | 2021-10-10 | US | Virginia | Halifax | 51083 | 3677 | 99 | 0 | 36.76654925 | -78.93512622 | 2021-10-11 04:21:31 | Halifax, Virginia, US | |
2879557 | 2879557 | 2021-10-09 | US | Virginia | Halifax | 51083 | 3677 | 99 | 0 | 36.76654925 | -78.93512622 | 2021-10-10 04:21:38 | Halifax, Virginia, US | |
2962723 | 2962723 | 2021-10-08 | US | Virginia | Halifax | 51083 | 3677 | 99 | 0 | 36.76654925 | -78.93512622 | 2021-10-09 04:21:34 | Halifax, Virginia, US | |
3833247 | 3833247 | 2021-10-05 | US | Georgia | Burke | 13033 | 3677 | 74 | 0 | 33.05917989 | -81.99928721 | 2021-10-06 04:21:33 | Burke, Georgia, US | |
2134688 | 2134688 | 2021-10-01 | US | Pennsylvania | Elk | 42047 | 3677 | 49 | 0 | 41.42822061 | -78.64524744 | 2021-10-02 04:21:25 | Elk, 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]);