johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where active = 3061 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015185 | 3015185 | 2021-08-01 | Colombia | Atlantico | 308217 | 9215 | 295941 | 3061 | 10.6966 | -74.8741 | 2021-08-02 04:21:36 | Atlantico, Colombia | ||
2674057 | 2674057 | 2021-07-18 | Russia | Sakha (Yakutiya) Republic | 43069 | 836 | 39172 | 3061 | 66.941626 | 129.642371 | 2021-07-19 04:21:24 | Sakha (Yakutiya) Republic, Russia | ||
2911183 | 2911183 | 2021-06-17 | Japan | Hokkaido | 40794 | 1331 | 36402 | 3061 | 43.385711 | 142.552318 | 2021-06-18 04:22:16 | Hokkaido, Japan | ||
3381166 | 3381166 | 2021-06-13 | Chile | Maule | 90541 | 1429 | 86051 | 3061 | -35.5183 | -71.6885 | 2021-06-14 04:22:46 | Maule, Chile | ||
2586132 | 2586132 | 2021-06-05 | Pakistan | Islamabad | 81700 | 765 | 77874 | 3061 | 33.665087 | 73.121219 | 2021-06-06 04:24:03 | Islamabad, Pakistan | ||
3129754 | 3129754 | 2021-04-18 | Russia | Orenburg Oblast | 41491 | 801 | 37629 | 3061 | 52.02692620000001 | 54.7276647 | 2021-04-19 04:20:57 | Orenburg Oblast, Russia | ||
1091694 | 1091694 | 2021-03-03 | US | Michigan | Delta | 26041 | 3145 | 84 | 0 | 3061 | 45.90484910000001 | -86.9080745 | 2021-03-04 05:24:24 | Delta, Michigan, US |
2186180 | 2186180 | 2021-02-26 | US | Oklahoma | Woodward | 40153 | 3078 | 17 | 0 | 3061 | 36.42316318 | -99.26283045 | 2021-02-27 05:22:28 | Woodward, Oklahoma, US |
283414 | 283414 | 2021-02-24 | US | Texas | Upshur | 48459 | 3410 | 57 | 0 | 3061 | 32.73706798 | -94.93999853 | 2021-02-25 05:24:57 | Upshur, Texas, US |
282702 | 282702 | 2021-02-24 | US | Oklahoma | Adair | 40001 | 3084 | 23 | 0 | 3061 | 35.88494195 | -94.65859267 | 2021-02-25 05:24:57 | Adair, Oklahoma, US |
1938970 | 1938970 | 2021-02-23 | US | Oklahoma | Adair | 40001 | 3084 | 23 | 0 | 3061 | 35.88494195 | -94.65859267 | 2021-02-24 05:29:16 | Adair, Oklahoma, US |
472287 | 472287 | 2021-02-19 | US | Georgia | Toombs | 13279 | 3161 | 100 | 0 | 3061 | 32.12059861 | -82.32957247 | 2021-02-20 05:22:51 | Toombs, Georgia, US |
3052371 | 3052371 | 2021-02-16 | US | New Mexico | Otero | 35035 | 3111 | 50 | 0 | 3061 | 32.61348406 | -105.7417604 | 2021-02-17 05:23:10 | Otero, New Mexico, US |
3050910 | 3050910 | 2021-02-16 | US | Florida | Wakulla | 12129 | 3112 | 51 | 0 | 3061 | 30.16548905 | -84.39895211 | 2021-02-17 05:23:10 | Wakulla, Florida, US |
2285917 | 2285917 | 2021-02-14 | US | Ohio | Ottawa | 39123 | 3135 | 74 | 0 | 3061 | 41.53781826 | -83.0940185 | 2021-02-15 05:24:49 | Ottawa, Ohio, US |
2677829 | 2677829 | 2021-02-13 | Japan | Chiba | 24536 | 344 | 21131 | 3061 | 35.510141 | 140.198917 | 2021-02-14 05:23:43 | Chiba, Japan | ||
3541186 | 3541186 | 2021-02-12 | US | Minnesota | Lyon | 27083 | 3104 | 43 | 0 | 3061 | 44.41327865 | -95.83806103 | 2021-02-13 05:22:12 | Lyon, Minnesota, US |
1530220 | 1530220 | 2021-02-09 | US | North Carolina | Jackson | 37099 | 3107 | 46 | 0 | 3061 | 35.28814273 | -83.14093385 | 2021-02-10 05:22:41 | Jackson, North Carolina, US |
343214 | 343214 | 2021-02-03 | US | Tennessee | Hardin | 47071 | 3204 | 57 | 0 | 3061 | 35.19732531 | -88.18593755 | 2021-02-04 05:22:26 | Hardin, Tennessee, US |
1900387 | 1900387 | 2021-01-29 | US | Texas | Uvalde | 48463 | 3217 | 50 | 0 | 3061 | 29.35739637 | -99.76229172 | 2021-01-30 05:22:49 | Uvalde, Texas, US |
1898783 | 1898783 | 2021-01-29 | US | Michigan | Hillsdale | 26059 | 3129 | 68 | 0 | 3061 | 41.88753639 | -84.59312019 | 2021-01-30 05:22:49 | Hillsdale, Michigan, US |
1759847 | 1759847 | 2021-01-24 | US | California | Mendocino | 6045 | 3097 | 33 | 0 | 3061 | 39.4381191 | -123.3911313 | 2021-01-25 05:22:16 | Mendocino, California, US |
2466642 | 2466642 | 2021-01-22 | Colombia | Boyaca | 38242 | 797 | 34384 | 3061 | 5.4545 | -73.362 | 2021-01-23 05:22:03 | Boyaca, Colombia | ||
436374 | 436374 | 2021-01-21 | US | Illinois | Montgomery | 17135 | 3105 | 44 | 0 | 3061 | 39.23198845 | -89.47809254 | 2021-01-22 05:22:10 | Montgomery, Illinois, US |
3883133 | 3883133 | 2021-01-14 | US | Wisconsin | Oneida | 55085 | 3114 | 53 | 0 | 3061 | 45.70677897 | -89.51944105 | 2021-01-15 05:22:24 | Oneida, Wisconsin, US |
2867632 | 2867632 | 2021-01-06 | US | Tennessee | Cocke | 47029 | 3144 | 51 | 0 | 3061 | 35.9278914 | -83.11828725 | 2021-01-07 05:22:03 | Cocke, Tennessee, US |
3035828 | 3035828 | 2021-01-05 | US | Louisiana | St. Mary | 22101 | 3164 | 103 | 0 | 3061 | 29.69262097 | -91.44702164 | 2021-01-06 05:22:16 | St. Mary, Louisiana, US |
3778343 | 3778343 | 2020-12-27 | US | Arizona | Graham | 4009 | 3109 | 48 | 0 | 3061 | 32.93166885 | -109.8882178 | 2020-12-28 05:22:06 | Graham, Arizona, US |
3777762 | 3777762 | 2020-12-27 | Colombia | Risaralda | 32719 | 722 | 28936 | 3061 | 5.3158 | -75.9928 | 2020-12-28 05:22:06 | Risaralda, Colombia | ||
204722 | 204722 | 2020-12-25 | US | Ohio | Huron | 39077 | 3136 | 75 | 0 | 3061 | 41.14651175 | -82.59867951 | 2020-12-26 05:22:28 | Huron, Ohio, US |
2407870 | 2407870 | 2020-12-23 | US | Illinois | Stephenson | 17177 | 3104 | 43 | 0 | 3061 | 42.35129217 | -89.662598 | 2020-12-24 05:23:04 | Stephenson, Illinois, US |
2122531 | 2122531 | 2020-12-20 | US | South Carolina | Laurens | 45059 | 3134 | 73 | 0 | 3061 | 34.48244419 | -82.00490796 | 2020-12-21 05:27:58 | Laurens, South Carolina, US |
3851343 | 3851343 | 2020-12-13 | US | Wisconsin | Monroe | 55081 | 3081 | 20 | 0 | 3061 | 43.94641218 | -90.618819 | 2020-12-14 05:26:27 | Monroe, Wisconsin, US |
845802 | 845802 | 2020-12-12 | Russia | Orenburg Oblast | 25346 | 259 | 22026 | 3061 | 52.02692620000001 | 54.7276647 | 2020-12-13 05:27:20 | Orenburg Oblast, Russia | ||
1600713 | 1600713 | 2020-12-10 | US | Arkansas | Lonoke | 5085 | 3124 | 63 | 0 | 3061 | 34.75392199 | -91.88742357 | 2020-12-11 05:26:59 | Lonoke, Arkansas, US |
2349067 | 2349067 | 2020-12-07 | US | Michigan | Lenawee | 26091 | 3096 | 35 | 0 | 3061 | 41.89475156 | -84.06603727 | 2020-12-08 05:27:42 | Lenawee, Michigan, US |
1008975 | 1008975 | 2020-12-06 | US | Pennsylvania | Northumberland | 42097 | 3203 | 142 | 0 | 3061 | 40.84785433 | -76.70798222 | 2020-12-07 05:26:14 | Northumberland, Pennsylvania, US |
1008063 | 1008063 | 2020-12-06 | US | Minnesota | Winona | 27169 | 3094 | 33 | 0 | 3061 | 43.98772283 | -91.78081305 | 2020-12-07 05:26:14 | Winona, Minnesota, US |
1632558 | 1632558 | 2020-12-05 | Russia | Ulyanovsk Oblast | 28907 | 375 | 25471 | 3061 | 54.1463177 | 47.2324921 | 2020-12-06 05:26:18 | Ulyanovsk Oblast, Russia | ||
392246 | 392246 | 2020-11-27 | Japan | Hokkaido | 8273 | 180 | 5032 | 3061 | 43.385711 | 142.552318 | 2020-11-28 05:25:50 | Hokkaido, Japan | ||
1973165 | 1973165 | 2020-11-25 | US | California | Sutter | 6101 | 3075 | 14 | 0 | 3061 | 39.03417539 | -121.6945899 | 2020-11-26 05:27:44 | Sutter, California, US |
2703952 | 2703952 | 2020-11-20 | US | Ohio | Columbiana | 39029 | 3165 | 104 | 0 | 3061 | 40.76932373 | -80.78094576 | 2020-11-21 05:25:51 | Columbiana, Ohio, US |
2703836 | 2703836 | 2020-11-20 | US | North Carolina | Lincoln | 37109 | 3081 | 20 | 0 | 3061 | 35.48508185 | -81.21740317 | 2020-11-21 05:25:51 | Lincoln, North Carolina, US |
122457 | 122457 | 2020-11-18 | Brazil | Roraima | 61245 | 711 | 57231 | 3061 | -2.7376 | -62.0751 | 2020-11-19 05:25:23 | Roraima, Brazil | ||
3342127 | 3342127 | 2020-11-17 | US | Wisconsin | Grant | 55043 | 3116 | 55 | 0 | 3061 | 42.8671731 | -90.7063218 | 2020-11-18 05:40:31 | Grant, Wisconsin, US |
274302 | 274302 | 2020-11-10 | US | New Hampshire | Rockingham | 33015 | 3166 | 105 | 0 | 3061 | 42.98499744 | -71.12883377 | 2020-11-11 05:25:30 | Rockingham, New Hampshire, US |
1990436 | 1990436 | 2020-11-09 | US | Mississippi | Jones | 28067 | 3145 | 84 | 0 | 3061 | 31.62257767 | -89.16896899999998 | 2020-11-10 05:40:07 | Jones, Mississippi, US |
2080167 | 2080167 | 2020-10-31 | Russia | Pskov Oblast | 7799 | 70 | 4668 | 3061 | 57.5358729 | 28.8586826 | 2020-11-01 04:36:19 | Pskov Oblast, Russia | ||
3990809 | 3990809 | 2020-10-20 | Russia | Kalmykia Republic | 8041 | 86 | 4894 | 3061 | 46.2313018 | 45.3275745 | 2020-10-21 04:24:14 | Kalmykia Republic, Russia | ||
2857625 | 2857625 | 2020-10-16 | US | Georgia | Dougherty | 13095 | 3251 | 190 | 0 | 3061 | 31.53328528 | -84.21722377 | 2020-10-17 04:24:12 | Dougherty, Georgia, US |
3782830 | 3782830 | 2020-10-13 | US | Idaho | Kootenai | 16055 | 3105 | 44 | 0 | 3061 | 47.67282258 | -116.7020872 | 2020-10-14 04:24:05 | Kootenai, Idaho, US |
2602309 | 2602309 | 2020-10-10 | Slovenia | 8252 | 167 | 5024 | 3061 | 46.1512 | 14.9955 | 2020-10-11 04:23:46 | Slovenia | |||
820386 | 820386 | 2020-10-09 | US | South Carolina | Orangeburg | 45075 | 3188 | 127 | 0 | 3061 | 33.4391073 | -80.79886287 | 2020-10-10 04:23:57 | Orangeburg, South Carolina, US |
2693257 | 2693257 | 2020-10-08 | US | Wisconsin | Washington | 55131 | 3098 | 37 | 0 | 3061 | 43.36863664 | -88.22974712 | 2020-10-09 04:23:59 | Washington, Wisconsin, US |
2692153 | 2692153 | 2020-10-08 | US | Ohio | Mahoning | 39099 | 3316 | 255 | 0 | 3061 | 41.01631101 | -80.77287029 | 2020-10-09 04:23:59 | Mahoning, Ohio, US |
1123415 | 1123415 | 2020-09-17 | US | Mississippi | Rankin | 28121 | 3134 | 73 | 0 | 3061 | 32.26469147 | -89.94537876 | 2020-09-18 05:05:00 | Rankin, Mississippi, US |
2730813 | 2730813 | 2020-09-15 | US | Mississippi | Madison | 28089 | 3146 | 85 | 0 | 3061 | 32.63389156 | -90.03513564 | 2020-09-16 04:22:53 | Madison, Mississippi, US |
2059864 | 2059864 | 2020-09-01 | Italy | Emilia-Romagna | 32021 | 4463 | 24497 | 3061 | 44.49436681 | 11.3417208 | 2020-09-02 04:28:25 | Emilia-Romagna, Italy | ||
1523960 | 1523960 | 2020-08-28 | US | Georgia | Douglas | 13097 | 3123 | 62 | 0 | 3061 | 33.70291126 | -84.77026156 | 2020-08-29 04:28:19 | Douglas, Georgia, US |
149247 | 149247 | 2020-08-15 | US | Virginia | Arlington | 51013 | 3196 | 135 | 0 | 3061 | 38.8767675 | -77.10139853 | 2020-08-16 04:27:42 | Arlington, Virginia, US |
3919942 | 3919942 | 2020-08-09 | US | Iowa | Black Hawk | 19013 | 3127 | 66 | 0 | 3061 | 42.4704581 | -92.30524729 | 2020-08-10 04:34:55 | Black Hawk, Iowa, US |
458966 | 458966 | 2020-08-07 | Qatar | 112383 | 180 | 109142 | 3061 | 25.3548 | 51.1839 | 2020-08-08 04:34:53 | Qatar | |||
3793352 | 3793352 | 2020-08-05 | Ukraine | Zakarpattia Oblast | 5462 | 210 | 2191 | 3061 | 48.6208 | 22.2879 | 2020-08-06 04:35:02 | Zakarpattia Oblast, Ukraine | ||
98508 | 98508 | 2020-08-04 | Peru | Tacna | 3288 | 227 | 0 | 3061 | -17.644160999999997 | -70.27756 | 2020-08-05 04:34:43 | Tacna, Peru | ||
366320 | 366320 | 2020-07-16 | US | Texas | Potter | 48375 | 3269 | 39 | 0 | 3061 | 35.40133773 | -101.893964 | 2020-07-17 04:34:50 | Potter, Texas, US |
2232459 | 2232459 | 2020-07-03 | US | New Hampshire | Hillsborough | 33011 | 3312 | 251 | 0 | 3061 | 42.91537785 | -71.7200253 | 2020-07-04 04:33:51 | Hillsborough, New Hampshire, 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]);