johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where active = 4265 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2207325 | 2207325 | 2021-08-07 | Malaysia | Terengganu | 20100 | 146 | 15689 | 4265 | 5.3117 | 103.1324 | 2021-08-08 04:21:33 | Terengganu, Malaysia | ||
3296037 | 3296037 | 2021-07-30 | Colombia | Santander | 218499 | 6988 | 207246 | 4265 | 6.6437 | -73.6536 | 2021-07-31 04:21:35 | Santander, Colombia | ||
3476014 | 3476014 | 2021-07-22 | Austria | 650471 | 13119 | 640202 | 4265 | 47.5162 | 14.5501 | 2021-07-23 04:21:29 | Austria | |||
399973 | 399973 | 2021-06-29 | Belarus | 416275 | 3132 | 408878 | 4265 | 53.7098 | 27.9534 | 2021-06-30 04:21:41 | Belarus | |||
3675573 | 3675573 | 2021-05-04 | Germany | Schleswig-Holstein | 59276 | 1515 | 53790 | 4265 | 54.2194 | 9.6961 | 2021-05-05 04:20:43 | Schleswig-Holstein, Germany | ||
241176 | 241176 | 2021-04-02 | Germany | Schleswig-Holstein | 50354 | 1438 | 44990 | 4265 | 54.2194 | 9.6961 | 2021-04-03 04:20:44 | Schleswig-Holstein, Germany | ||
2208347 | 2208347 | 2021-03-04 | US | Florida | Hendry | 12051 | 4338 | 73 | 0 | 4265 | 26.55386945 | -81.16469006 | 2021-03-05 05:26:29 | Hendry, Florida, US |
2184589 | 2184589 | 2021-02-26 | US | Illinois | Macoupin | 17117 | 4344 | 79 | 0 | 4265 | 39.26119767 | -89.92424028 | 2021-02-27 05:22:28 | Macoupin, Illinois, US |
2184354 | 2184354 | 2021-02-26 | US | Georgia | Colquitt | 13071 | 4365 | 100 | 0 | 4265 | 31.18810588 | -83.7677946 | 2021-02-27 05:22:28 | Colquitt, Georgia, US |
1860974 | 1860974 | 2021-02-25 | US | Tennessee | Obion | 47131 | 4359 | 94 | 0 | 4265 | 36.35732446 | -89.14921589 | 2021-02-26 05:22:40 | Obion, Tennessee, US |
474860 | 474860 | 2021-02-19 | US | Washington | Skagit | 53057 | 4323 | 58 | 0 | 4265 | 48.48171488 | -121.766131 | 2021-02-20 05:22:51 | Skagit, Washington, US |
3603460 | 3603460 | 2021-02-17 | US | North Dakota | Stark | 38089 | 4317 | 48 | 0 | 4265 | 46.80851182 | -102.6576326 | 2021-02-18 05:22:58 | Stark, North Dakota, US |
3543012 | 3543012 | 2021-02-12 | US | Wisconsin | Marinette | 55075 | 4328 | 63 | 0 | 4265 | 45.38553432 | -88.03324599999998 | 2021-02-13 05:22:12 | Marinette, Wisconsin, US |
2640302 | 2640302 | 2021-02-11 | US | Oklahoma | Pittsburg | 40121 | 4297 | 32 | 0 | 4265 | 34.92065823 | -95.7513432 | 2021-02-12 05:23:29 | Pittsburg, Oklahoma, US |
2640226 | 2640226 | 2021-02-11 | US | Ohio | Shelby | 39149 | 4348 | 83 | 0 | 4265 | 40.33163494 | -84.20258189 | 2021-02-12 05:23:29 | Shelby, Ohio, US |
3980809 | 3980809 | 2021-02-10 | US | New York | Jefferson | 36045 | 4320 | 55 | 0 | 4265 | 44.04200959 | -75.94653457 | 2021-02-11 05:23:55 | Jefferson, New York, US |
3980267 | 3980267 | 2021-02-10 | US | Minnesota | Benton | 27009 | 4354 | 89 | 0 | 4265 | 45.69804958 | -93.99514135 | 2021-02-11 05:23:55 | Benton, Minnesota, US |
978418 | 978418 | 2021-02-06 | US | West Virginia | Raleigh | 54081 | 4315 | 50 | 0 | 4265 | 37.76936795 | -81.2456041 | 2021-02-07 05:23:00 | Raleigh, West Virginia, US |
790743 | 790743 | 2021-02-04 | US | Alabama | Dale | 1045 | 4367 | 102 | 0 | 4265 | 31.43037123 | -85.61095742 | 2021-02-05 05:22:38 | Dale, Alabama, US |
3154212 | 3154212 | 2021-01-27 | US | Colorado | Eagle | 8037 | 4445 | 20 | 0 | 4265 | 39.62754308 | -106.6933637 | 2021-01-28 05:22:24 | Eagle, Colorado, US |
15872 | 15872 | 2021-01-26 | US | Wisconsin | Dunn | 55033 | 4291 | 26 | 0 | 4265 | 44.94562799 | -91.8962481 | 2021-01-27 05:23:41 | Dunn, Wisconsin, US |
14304 | 14304 | 2021-01-26 | US | Missouri | Taney | 29213 | 4333 | 68 | 0 | 4265 | 36.65465345 | -93.04075153 | 2021-01-27 05:23:41 | Taney, Missouri, US |
2429404 | 2429404 | 2021-01-23 | US | Ohio | Sandusky | 39143 | 4366 | 101 | 0 | 4265 | 41.35624126 | -83.137872 | 2021-01-24 05:22:35 | Sandusky, Ohio, US |
239552 | 239552 | 2021-01-18 | US | North Carolina | Granville | 37077 | 4335 | 70 | 0 | 4265 | 36.30337451 | -78.65184241 | 2021-01-19 05:22:15 | Granville, North Carolina, US |
237019 | 237019 | 2021-01-18 | Canada | Saskatchewan | 20562 | 219 | 16078 | 4265 | 52.9399 | -106.4509 | 2021-01-19 05:22:15 | Saskatchewan, Canada | ||
3505669 | 3505669 | 2021-01-17 | US | North Carolina | Granville | 37077 | 4335 | 70 | 0 | 4265 | 36.30337451 | -78.65184241 | 2021-01-18 05:22:34 | Granville, North Carolina, US |
2626482 | 2626482 | 2021-01-10 | US | Colorado | Garfield | 8045 | 4523 | 38 | 0 | 4265 | 39.59921777 | -107.902708 | 2021-01-11 05:21:50 | Garfield, Colorado, US |
2868109 | 2868109 | 2021-01-06 | US | Virginia | Rockingham | 51165 | 4313 | 48 | 0 | 4265 | 38.51006137 | -78.87260325 | 2021-01-07 05:22:03 | Rockingham, Virginia, US |
766788 | 766788 | 2020-12-29 | US | Arkansas | Crawford | 5033 | 4323 | 58 | 0 | 4265 | 35.58928601 | -94.2446814 | 2020-12-30 05:22:34 | Crawford, Arkansas, US |
3780254 | 3780254 | 2020-12-27 | US | North Carolina | Rockingham | 37157 | 4290 | 25 | 0 | 4265 | 36.39593137 | -79.77504841 | 2020-12-28 05:22:06 | Rockingham, North Carolina, US |
2408072 | 2408072 | 2020-12-23 | US | Iowa | Webster | 19187 | 4323 | 58 | 0 | 4265 | 42.42853483 | -94.17987389 | 2020-12-24 05:23:04 | Webster, Iowa, US |
2121710 | 2121710 | 2020-12-20 | US | Montana | Lewis and Clark | 30049 | 4296 | 31 | 0 | 4265 | 47.12610041 | -112.394698 | 2020-12-21 05:27:58 | Lewis and Clark, Montana, US |
2129694 | 2129694 | 2020-12-17 | US | Minnesota | Crow Wing | 27035 | 4314 | 49 | 0 | 4265 | 46.48096553 | -94.06755609 | 2020-12-18 05:28:18 | Crow Wing, Minnesota, US |
2540916 | 2540916 | 2020-12-01 | US | Wisconsin | Calumet | 55015 | 4292 | 27 | 0 | 4265 | 44.0816316 | -88.21780273 | 2020-12-02 05:27:41 | Calumet, Wisconsin, US |
823073 | 823073 | 2020-11-19 | US | Louisiana | Lafourche | 22057 | 4399 | 134 | 0 | 4265 | 29.52470226 | -90.40976986 | 2020-11-20 05:26:28 | Lafourche, Louisiana, US |
1992289 | 1992289 | 2020-11-09 | Venezuela | 95149 | 830 | 90054 | 4265 | 6.4238 | -66.5897 | 2020-11-10 05:40:07 | Venezuela | |||
895734 | 895734 | 2020-11-05 | Ukraine | Crimea Republic* | 10364 | 152 | 5947 | 4265 | 45.2835 | 34.2008 | 2020-11-06 05:24:55 | Crimea Republic*, Ukraine | ||
2500542 | 2500542 | 2020-11-03 | US | Oklahoma | Canadian | 40017 | 4289 | 24 | 0 | 4265 | 35.5426055 | -97.98465569 | 2020-11-04 05:25:09 | Canadian, Oklahoma, US |
765308 | 765308 | 2020-10-18 | US | Tennessee | Wilson | 47189 | 4353 | 53 | 0 | 4265 | 36.15496772 | -86.29775884 | 2020-10-19 04:24:16 | Wilson, Tennessee, US |
3789513 | 3789513 | 2020-10-11 | Ukraine | Kiev Oblast | 11096 | 233 | 6598 | 4265 | 50.053 | 30.7667 | 2020-10-12 04:23:45 | Kiev Oblast, Ukraine | ||
2690469 | 2690469 | 2020-10-08 | US | Georgia | Forsyth | 13117 | 4312 | 47 | 0 | 4265 | 34.22604035 | -84.12315129999998 | 2020-10-09 04:23:59 | Forsyth, Georgia, US |
3922184 | 3922184 | 2020-08-09 | US | Georgia | Richmond | 13245 | 4355 | 90 | 0 | 4265 | 33.35777107 | -82.07026432 | 2020-08-10 04:34:55 | Richmond, Georgia, US |
371175 | 371175 | 2020-08-08 | Peru | Ayacucho | 4603 | 338 | 0 | 4265 | -14.091648 | -74.08344 | 2020-08-09 04:34:54 | Ayacucho, Peru | ||
2805716 | 2805716 | 2020-08-02 | US | Texas | Hays | 48209 | 3441 | 32 | 0 | 4265 | 30.05669873 | -98.02944344 | 2020-08-03 04:34:35 | Hays, Texas, US |
751284 | 751284 | 2020-08-01 | US | Texas | Hays | 48209 | 3341 | 32 | 0 | 4265 | 30.05669873 | -98.02944344 | 2020-08-02 04:34:47 | Hays, Texas, US |
2563727 | 2563727 | 2020-07-24 | Russia | Khanty-Mansi Autonomous Okrug | 15057 | 117 | 10675 | 4265 | 61.0259025 | 69.0982628 | 2020-07-25 04:47:39 | Khanty-Mansi Autonomous Okrug, Russia | ||
3491671 | 3491671 | 2020-07-13 | Congo (Kinshasa) | 8075 | 190 | 3620 | 4265 | -4.0383 | 21.7587 | 2020-07-14 04:34:46 | Congo (Kinshasa) | |||
2700879 | 2700879 | 2020-06-24 | Brazil | Santa Catarina | 20921 | 279 | 16377 | 4265 | -27.2423 | -50.2189 | 2020-06-25 05:26:54 | Santa Catarina, Brazil | ||
216439 | 216439 | 2020-06-08 | US | New Jersey | Somerset | 34035 | 4692 | 427 | 0 | 4265 | 40.56465737 | -74.61683016 | 2020-06-09 03:33:03 | Somerset, New Jersey, US |
1266564 | 1266564 | 2020-06-05 | US | Colorado | Arapahoe | 8005 | 5133 | 353 | 0 | 4265 | 39.64977461 | -104.3353617 | 2020-06-06 02:33:00 | Arapahoe, Colorado, US |
3457637 | 3457637 | 2020-05-10 | US | Massachusetts | Hampden | 25013 | 4714 | 449 | 0 | 4265 | 42.13440424 | -72.63235561 | 2020-05-11 02:32:30 | Hampden, Massachusetts, 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]);