johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94 rows where active = 2110 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408147 | 408147 | 2021-07-28 | Colombia | Narino | 86162 | 2856 | 81196 | 2110 | 1.2892 | -77.3579 | 2021-07-29 04:21:33 | Narino, Colombia | ||
625870 | 625870 | 2021-07-10 | Italy | Puglia | 253763 | 6650 | 245003 | 2110 | 41.12559576 | 16.86736689 | 2021-07-11 04:21:43 | Puglia, Italy | ||
1310014 | 1310014 | 2021-05-26 | Colombia | Cordoba | 61757 | 2461 | 57186 | 2110 | 8.0493 | -75.574 | 2021-05-27 04:20:59 | Cordoba, Colombia | ||
82940 | 82940 | 2021-05-25 | Colombia | Cordoba | 61367 | 2444 | 56813 | 2110 | 8.0493 | -75.574 | 2021-05-26 04:20:35 | Cordoba, Colombia | ||
888380 | 888380 | 2021-04-26 | Russia | Voronezh Oblast | 79932 | 2603 | 75219 | 2110 | 50.9800393 | 40.15065070000001 | 2021-04-27 04:20:52 | Voronezh Oblast, Russia | ||
2020700 | 2020700 | 2021-04-20 | Israel | 837357 | 6345 | 828902 | 2110 | 31.046051 | 34.851612 | 2021-04-21 04:21:14 | Israel | |||
1289955 | 1289955 | 2021-03-29 | India | Jammu and Kashmir | 130228 | 1989 | 126129 | 2110 | 33.75943 | 76.612638 | 2021-03-30 04:26:23 | Jammu and Kashmir, India | ||
3369233 | 3369233 | 2021-03-21 | Gabon | 17711 | 106 | 15495 | 2110 | -0.8037 | 11.6094 | 2021-03-22 05:25:43 | Gabon | |||
1744443 | 1744443 | 2021-03-20 | Gabon | 17711 | 106 | 15495 | 2110 | -0.8037 | 11.6094 | 2021-03-21 05:25:44 | Gabon | |||
3420823 | 3420823 | 2021-03-19 | Gabon | 17711 | 106 | 15495 | 2110 | -0.8037 | 11.6094 | 2021-03-20 05:25:46 | Gabon | |||
3456530 | 3456530 | 2021-03-18 | Malaysia | Johor | 39609 | 102 | 37397 | 2110 | 1.4854 | 103.7618 | 2021-03-19 05:26:09 | Johor, Malaysia | ||
1618536 | 1618536 | 2021-03-05 | US | North Carolina | Cherokee | 37039 | 2129 | 19 | 0 | 2110 | 35.1349263 | -84.05970864 | 2021-03-06 04:23:41 | Cherokee, North Carolina, US |
2208863 | 2208863 | 2021-03-04 | US | Iowa | Mahaska | 19123 | 2156 | 46 | 0 | 2110 | 41.33521503 | -92.64083907 | 2021-03-05 05:26:29 | Mahaska, Iowa, US |
1001852 | 1001852 | 2021-03-01 | US | Virginia | Waynesboro | 51820 | 2142 | 32 | 0 | 2110 | 38.06451466 | -78.90293905 | 2021-03-02 05:23:30 | Waynesboro, Virginia, US |
2370910 | 2370910 | 2021-02-28 | US | Virginia | Waynesboro | 51820 | 2141 | 31 | 0 | 2110 | 38.06451466 | -78.90293905 | 2021-03-01 05:23:01 | Waynesboro, Virginia, US |
743865 | 743865 | 2021-02-20 | US | Maine | Oxford | 23017 | 2152 | 42 | 0 | 2110 | 44.49952995 | -70.75682123 | 2021-02-21 05:24:33 | Oxford, Maine, US |
474555 | 474555 | 2021-02-19 | US | Texas | Lavaca | 48285 | 2152 | 69 | 0 | 2110 | 29.38508402 | -96.93186692 | 2021-02-20 05:22:51 | Lavaca, Texas, US |
3542237 | 3542237 | 2021-02-12 | US | Puerto Rico | Vega Baja | 72145 | 2110 | 0 | 0 | 2110 | 18.428262 | -66.397924 | 2021-02-13 05:22:12 | Vega Baja, Puerto Rico, US |
3540268 | 3540268 | 2021-02-12 | US | Georgia | Hart | 13147 | 2159 | 49 | 0 | 2110 | 34.34626973 | -82.96567682 | 2021-02-13 05:22:12 | Hart, Georgia, US |
2641133 | 2641133 | 2021-02-11 | US | Virginia | Warren | 51187 | 2150 | 40 | 0 | 2110 | 38.90847745 | -78.20280433 | 2021-02-12 05:23:29 | Warren, Virginia, US |
1531237 | 1531237 | 2021-02-09 | US | Virginia | Halifax | 51083 | 2166 | 56 | 0 | 2110 | 36.76654925 | -78.93512622 | 2021-02-10 05:22:41 | Halifax, Virginia, US |
615835 | 615835 | 2021-02-08 | US | New Hampshire | Grafton | 33009 | 2126 | 16 | 0 | 2110 | 43.93779815 | -71.82057197 | 2021-02-09 05:23:30 | Grafton, New Hampshire, US |
974710 | 974710 | 2021-02-06 | Chile | Maule | 37438 | 732 | 34596 | 2110 | -35.5183 | -71.6885 | 2021-02-07 05:23:00 | Maule, Chile | ||
342318 | 342318 | 2021-02-03 | US | Nebraska | Cass | 31025 | 2124 | 14 | 0 | 2110 | 40.90899107 | -96.13971217 | 2021-02-04 05:22:26 | Cass, Nebraska, US |
1900541 | 1900541 | 2021-01-29 | US | Virginia | Pulaski | 51155 | 2153 | 43 | 0 | 2110 | 37.06474963 | -80.71229738 | 2021-01-30 05:22:49 | Pulaski, Virginia, US |
2483123 | 2483123 | 2021-01-28 | US | Iowa | Benton | 19011 | 2160 | 50 | 0 | 2110 | 42.08011739 | -92.06463573 | 2021-01-29 05:22:23 | Benton, Iowa, US |
3155007 | 3155007 | 2021-01-27 | US | Kentucky | Harlan | 21095 | 2147 | 37 | 0 | 2110 | 36.85699301 | -83.21899516 | 2021-01-28 05:22:24 | Harlan, Kentucky, US |
15744 | 15744 | 2021-01-26 | US | Virginia | Staunton | 51790 | 2160 | 50 | 0 | 2110 | 38.15965544 | -79.05979937 | 2021-01-27 05:23:41 | Staunton, Virginia, US |
2469498 | 2469498 | 2021-01-22 | US | Pennsylvania | Tioga | 42117 | 2197 | 87 | 0 | 2110 | 41.77255149 | -77.25433032 | 2021-01-23 05:22:03 | Tioga, Pennsylvania, US |
437820 | 437820 | 2021-01-21 | US | Ohio | Henry | 39069 | 2168 | 58 | 0 | 2110 | 41.3339642 | -84.06830637 | 2021-01-22 05:22:10 | Henry, Ohio, US |
1096955 | 1096955 | 2021-01-20 | US | South Dakota | Hughes | 46065 | 2140 | 30 | 0 | 2110 | 44.39091534 | -99.99661148 | 2021-01-21 05:22:01 | Hughes, South Dakota, US |
240709 | 240709 | 2021-01-18 | US | West Virginia | Fayette | 54019 | 2167 | 57 | 0 | 2110 | 38.02974928 | -81.08286634 | 2021-01-19 05:22:15 | Fayette, West Virginia, US |
3310877 | 3310877 | 2021-01-13 | US | Pennsylvania | McKean | 42083 | 2151 | 41 | 0 | 2110 | 41.80938602 | -78.56478358 | 2021-01-14 05:22:32 | McKean, Pennsylvania, US |
2626969 | 2626969 | 2021-01-10 | US | Indiana | LaGrange | 18087 | 2177 | 67 | 0 | 2110 | 41.64232188 | -85.42674232 | 2021-01-11 05:21:50 | LaGrange, Indiana, US |
157055 | 157055 | 2021-01-08 | US | Texas | Fannin | 48147 | 2297 | 58 | 0 | 2110 | 33.59564294 | -96.10751083 | 2021-01-09 05:22:18 | Fannin, Texas, US |
156961 | 156961 | 2021-01-08 | US | Tennessee | Scott | 47151 | 2412 | 27 | 0 | 2110 | 36.42325673 | -84.50360494 | 2021-01-09 05:22:18 | Scott, Tennessee, US |
2866625 | 2866625 | 2021-01-06 | US | Missouri | Lafayette | 29107 | 2152 | 42 | 0 | 2110 | 39.06986886 | -93.78076396 | 2021-01-07 05:22:03 | Lafayette, Missouri, US |
2865108 | 2865108 | 2021-01-06 | US | Alabama | Pike | 1109 | 2133 | 23 | 0 | 2110 | 31.80396383 | -85.9408295 | 2021-01-07 05:22:03 | Pike, Alabama, US |
3034820 | 3034820 | 2021-01-05 | US | Arkansas | Sevier | 5133 | 2130 | 20 | 0 | 2110 | 33.99780401 | -94.2424869 | 2021-01-06 05:22:16 | Sevier, Arkansas, US |
3230905 | 3230905 | 2021-01-03 | US | Arkansas | Baxter | 5005 | 2182 | 72 | 0 | 2110 | 36.28784385 | -92.33782872 | 2021-01-04 05:22:02 | Baxter, Arkansas, US |
3697072 | 3697072 | 2020-12-31 | US | Maryland | Worcester | 24047 | 2158 | 48 | 0 | 2110 | 38.21274277 | -75.33200012 | 2021-01-01 05:23:07 | Worcester, Maryland, US |
3764694 | 3764694 | 2020-12-28 | US | Texas | Hopkins | 48223 | 1716 | 69 | 0 | 2110 | 33.14875072 | -95.56351139 | 2020-12-29 05:22:37 | Hopkins, Texas, US |
3781014 | 3781014 | 2020-12-27 | US | Texas | Hopkins | 48223 | 1711 | 69 | 0 | 2110 | 33.14875072 | -95.56351139 | 2020-12-28 05:22:06 | Hopkins, Texas, US |
3778837 | 3778837 | 2020-12-27 | US | Idaho | Latah | 16057 | 2114 | 4 | 0 | 2110 | 46.81587887 | -116.7113698 | 2020-12-28 05:22:06 | Latah, Idaho, US |
2224442 | 2224442 | 2020-12-26 | US | Idaho | Latah | 16057 | 2114 | 4 | 0 | 2110 | 46.81587887 | -116.7113698 | 2020-12-27 05:22:55 | Latah, Idaho, US |
204697 | 204697 | 2020-12-25 | US | Ohio | Clinton | 39027 | 2150 | 40 | 0 | 2110 | 39.41485808 | -83.80852286 | 2020-12-26 05:22:28 | Clinton, Ohio, US |
203189 | 203189 | 2020-12-25 | US | Idaho | Latah | 16057 | 2114 | 4 | 0 | 2110 | 46.81587887 | -116.7113698 | 2020-12-26 05:22:28 | Latah, Idaho, US |
3692412 | 3692412 | 2020-12-24 | US | Idaho | Latah | 16057 | 2114 | 4 | 0 | 2110 | 46.81587887 | -116.7113698 | 2020-12-25 05:22:48 | Latah, Idaho, US |
928200 | 928200 | 2020-12-21 | US | Arkansas | Poinsett | 5111 | 2163 | 53 | 0 | 2110 | 35.57433534 | -90.66268713 | 2020-12-22 05:22:33 | Poinsett, Arkansas, US |
2121254 | 2121254 | 2020-12-20 | US | Maine | Androscoggin | 23001 | 2152 | 42 | 0 | 2110 | 44.1664747 | -70.20380627 | 2020-12-21 05:27:58 | Androscoggin, Maine, US |
1902154 | 1902154 | 2020-12-18 | US | Illinois | Iroquois | 17075 | 2152 | 42 | 0 | 2110 | 40.74717633 | -87.82466784 | 2020-12-19 05:27:52 | Iroquois, Illinois, US |
2129831 | 2129831 | 2020-12-17 | US | Mississippi | Sunflower | 28133 | 2167 | 57 | 0 | 2110 | 33.60192578 | -90.58882684 | 2020-12-18 05:28:18 | Sunflower, Mississippi, US |
3152651 | 3152651 | 2020-12-16 | US | Texas | Deaf Smith | 48117 | 2402 | 46 | 0 | 2110 | 34.96522957 | -102.6054267 | 2020-12-17 05:28:12 | Deaf Smith, Texas, US |
3151219 | 3151219 | 2020-12-16 | US | Michigan | Gratiot | 26057 | 2162 | 52 | 0 | 2110 | 43.29265605 | -84.60505416 | 2020-12-17 05:28:12 | Gratiot, Michigan, US |
3150748 | 3150748 | 2020-12-16 | US | Iowa | Bremer | 19017 | 2148 | 38 | 0 | 2110 | 42.77461496 | -92.31795937 | 2020-12-17 05:28:12 | Bremer, Iowa, US |
1037914 | 1037914 | 2020-12-15 | US | Wisconsin | Jackson | 55053 | 2116 | 6 | 0 | 2110 | 44.31864893 | -90.80566792 | 2020-12-16 05:28:04 | Jackson, Wisconsin, US |
2976333 | 2976333 | 2020-12-09 | US | Indiana | Miami | 18103 | 2135 | 25 | 0 | 2110 | 40.76940965 | -86.04525048 | 2020-12-10 05:26:19 | Miami, Indiana, US |
2348921 | 2348921 | 2020-12-07 | US | Louisiana | Iberville | 22047 | 2176 | 66 | 0 | 2110 | 30.25734305 | -91.3499598 | 2020-12-08 05:27:42 | Iberville, Louisiana, US |
3570192 | 3570192 | 2020-11-29 | Ukraine | Luhansk Oblast | 6239 | 167 | 3962 | 2110 | 48.574 | 39.3078 | 2020-11-30 05:26:13 | Luhansk Oblast, Ukraine | ||
924790 | 924790 | 2020-11-26 | US | Indiana | Morgan | 18109 | 2155 | 45 | 0 | 2110 | 39.47899078 | -86.44573375 | 2020-11-27 05:26:53 | Morgan, Indiana, US |
1353243 | 1353243 | 2020-11-24 | US | Tennessee | Fayette | 47047 | 2144 | 38 | 0 | 2110 | 35.19615831 | -89.41399032 | 2020-11-25 05:27:20 | Fayette, Tennessee, US |
123016 | 123016 | 2020-11-18 | Sweden | Kalmar | 2175 | 65 | 0 | 2110 | 57.235 | 16.1849 | 2020-11-19 05:25:23 | Kalmar, Sweden | ||
3338510 | 3338510 | 2020-11-17 | Germany | Saarland | 10300 | 217 | 8372 | 2110 | 49.3964 | 7.023 | 2020-11-18 05:40:31 | Saarland, Germany | ||
3172179 | 3172179 | 2020-11-16 | US | Oklahoma | Grady | 40051 | 2129 | 19 | 0 | 2110 | 35.0167709 | -97.88339847 | 2020-11-17 05:25:54 | Grady, Oklahoma, US |
867721 | 867721 | 2020-11-12 | US | Tennessee | Lawrence | 47099 | 2140 | 24 | 0 | 2110 | 35.21675201 | -87.39787695 | 2020-11-13 05:25:30 | Lawrence, Tennessee, US |
3304440 | 3304440 | 2020-11-02 | Russia | Tambov Oblast | 10036 | 51 | 7875 | 2110 | 52.9019574 | 41.3578918 | 2020-11-03 06:00:16 | Tambov Oblast, Russia | ||
2244067 | 2244067 | 2020-10-30 | US | Florida | Flagler | 12035 | 2148 | 38 | 0 | 2110 | 29.45933576 | -81.31508595 | 2020-10-31 04:24:44 | Flagler, Florida, US |
3651408 | 3651408 | 2020-10-24 | Colombia | Caldas | 11194 | 232 | 8852 | 2110 | 5.2983 | -75.2479 | 2020-10-25 04:24:36 | Caldas, Colombia | ||
1179188 | 1179188 | 2020-10-22 | US | Minnesota | Clay | 27027 | 2153 | 43 | 0 | 2110 | 46.89289518 | -96.48761922 | 2020-10-23 04:24:46 | Clay, Minnesota, US |
79560 | 79560 | 2020-10-14 | US | Arkansas | Garland | 5051 | 2167 | 57 | 0 | 2110 | 34.57692074 | -93.14921604 | 2020-10-15 04:24:28 | Garland, Arkansas, US |
3788714 | 3788714 | 2020-10-11 | US | South Carolina | Oconee | 45073 | 2139 | 29 | 0 | 2110 | 34.75225169 | -83.06742317 | 2020-10-12 04:23:45 | Oconee, South Carolina, US |
3120967 | 3120967 | 2020-10-06 | US | West Virginia | Monongalia | 54061 | 2115 | 5 | 0 | 2110 | 39.63218457 | -80.04766838 | 2020-10-07 04:23:40 | Monongalia, West Virginia, US |
3118475 | 3118475 | 2020-10-06 | US | Illinois | Kendall | 17093 | 2136 | 26 | 0 | 2110 | 41.59081014 | -88.42869583 | 2020-10-07 04:23:40 | Kendall, Illinois, US |
3804561 | 3804561 | 2020-10-05 | US | Pennsylvania | Lebanon | 42075 | 2172 | 62 | 0 | 2110 | 40.36680311 | -76.45651841 | 2020-10-06 04:23:33 | Lebanon, Pennsylvania, US |
3391248 | 3391248 | 2020-10-02 | US | Missouri | Buchanan | 29021 | 2138 | 28 | 0 | 2110 | 39.65816401 | -94.80138942 | 2020-10-03 04:23:40 | Buchanan, Missouri, US |
3319302 | 3319302 | 2020-09-22 | US | Texas | Gregg | 48183 | 1528 | 61 | 0 | 2110 | 32.47940482 | -94.81591935 | 2020-09-23 04:23:00 | Gregg, Texas, US |
2838659 | 2838659 | 2020-09-21 | US | Mississippi | Washington | 28151 | 2181 | 71 | 0 | 2110 | 33.28392041 | -90.94196237 | 2020-09-22 04:23:00 | Washington, Mississippi, US |
1124249 | 1124249 | 2020-09-17 | US | Pennsylvania | Lackawanna | 42069 | 2325 | 215 | 0 | 2110 | 41.43564672 | -75.60379201 | 2020-09-18 05:05:00 | Lackawanna, Pennsylvania, US |
549220 | 549220 | 2020-09-12 | US | Ohio | Lorain | 39093 | 2197 | 87 | 0 | 2110 | 41.29553751 | -82.15083537 | 2020-09-13 04:30:52 | Lorain, Ohio, US |
1447049 | 1447049 | 2020-09-11 | US | Ohio | Lorain | 39093 | 2197 | 87 | 0 | 2110 | 41.29553751 | -82.15083537 | 2020-09-12 04:25:05 | Lorain, Ohio, US |
1175440 | 1175440 | 2020-09-10 | US | New York | Ulster | 36111 | 2204 | 94 | 0 | 2110 | 41.89027881 | -74.26252104 | 2020-09-11 04:46:23 | Ulster, New York, US |
1354622 | 1354622 | 2020-09-03 | Sweden | Halland | 2191 | 81 | 0 | 2110 | 56.8967 | 12.8034 | 2020-09-04 04:28:26 | Halland, Sweden | ||
610713 | 610713 | 2020-08-29 | US | Illinois | Rock Island | 17161 | 2164 | 54 | 0 | 2110 | 41.46613806 | -90.57042164 | 2020-08-30 04:28:22 | Rock Island, Illinois, US |
2992108 | 2992108 | 2020-08-24 | US | Georgia | Newton | 13217 | 2168 | 58 | 0 | 2110 | 33.55514538 | -83.84547140000002 | 2020-08-25 04:28:02 | Newton, Georgia, US |
2219024 | 2219024 | 2020-08-23 | US | Virginia | Newport News | 51700 | 2130 | 20 | 0 | 2110 | 37.08166899 | -76.51754109 | 2020-08-24 04:27:56 | Newport News, Virginia, US |
3486202 | 3486202 | 2020-08-20 | US | Missouri | Jefferson | 29099 | 2140 | 30 | 0 | 2110 | 38.25926778 | -90.53870896 | 2020-08-21 04:27:41 | Jefferson, Missouri, US |
148863 | 148863 | 2020-08-15 | US | Tennessee | Bradley | 47011 | 2186 | 16 | 0 | 2110 | 35.15739424 | -84.857186 | 2020-08-16 04:27:42 | Bradley, Tennessee, US |
1919981 | 1919981 | 2020-08-10 | US | Minnesota | Washington | 27163 | 2155 | 45 | 0 | 2110 | 45.03864533 | -92.88429635 | 2020-08-11 04:35:08 | Washington, Minnesota, US |
176971 | 176971 | 2020-07-27 | US | Pennsylvania | York | 42133 | 2191 | 81 | 0 | 2110 | 39.9210089 | -76.73040131 | 2020-07-28 04:58:43 | York, Pennsylvania, US |
1499399 | 1499399 | 2020-07-25 | US | Louisiana | Ascension | 22005 | 2175 | 65 | 0 | 2110 | 30.20406249 | -90.91328409999998 | 2020-07-26 04:35:00 | Ascension, Louisiana, US |
2560370 | 2560370 | 2020-07-24 | US | Louisiana | Ascension | 22005 | 2175 | 65 | 0 | 2110 | 30.20406249 | -90.91328409999998 | 2020-07-25 04:47:39 | Ascension, Louisiana, US |
1707695 | 1707695 | 2020-07-21 | Sweden | Sormland | 2363 | 253 | 0 | 2110 | 59.0336 | 16.7519 | 2020-07-22 04:34:42 | Sormland, Sweden | ||
417320 | 417320 | 2020-04-18 | US | Pennsylvania | Lehigh | 42077 | 2139 | 29 | 0 | 2110 | 40.6154815 | -75.59435245 | 2020-04-18 22:32:47 | Lehigh, Pennsylvania, US |
41378 | 41378 | 2020-04-13 | US | Connecticut | Hartford | 9003 | 2243 | 133 | 0 | 2110 | 41.80283011 | -72.73103891 | 2020-04-13 23:07:54 | Hartford, Connecticut, 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]);