johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168055 | 168055 | 2022-06-21 | US | Montana | Liberty | 30051 | 422 | 4 | 0 | 48.56084317 | -111.024307 | 2022-06-22 04:20:54 | Liberty, Montana, US | |
175354 | 175354 | 2020-07-27 | US | Wyoming | Laramie | 56021 | 422 | 0 | 0 | 422 | 41.30702520000001 | -104.6887497 | 2020-07-28 04:58:43 | Laramie, Wyoming, US |
180662 | 180662 | 2021-09-02 | US | Oregon | Wallowa | 41063 | 422 | 6 | 0 | 45.57894064 | -117.18353799999998 | 2021-09-03 04:21:20 | Wallowa, Oregon, US | |
184063 | 184063 | 2021-02-21 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-22 05:24:21 | Teton, Montana, US |
195263 | 195263 | 2020-08-31 | US | Iowa | Lee | 19111 | 422 | 5 | 0 | 417 | 40.64181461 | -91.48183025 | 2020-09-01 04:28:31 | Lee, Iowa, US |
203945 | 203945 | 2020-12-25 | US | Minnesota | Big Stone | 27011 | 422 | 3 | 0 | 419 | 45.42712824 | -96.41403739 | 2020-12-26 05:22:28 | Big Stone, Minnesota, US |
204852 | 204852 | 2020-12-25 | US | Oregon | Baker | 41001 | 422 | 5 | 0 | 417 | 44.70915557 | -117.6749883 | 2020-12-26 05:22:28 | Baker, Oregon, US |
205693 | 205693 | 2020-12-25 | US | Washington | Klickitat | 53039 | 422 | 3 | 0 | 419 | 45.87325839 | -120.7913598 | 2020-12-26 05:22:28 | Klickitat, Washington, US |
206017 | 206017 | 2020-08-19 | Burundi | 422 | 1 | 336 | 85 | -3.3731 | 29.9189 | 2020-08-20 04:27:43 | Burundi | |||
211932 | 211932 | 2020-10-29 | US | Minnesota | Cass | 27021 | 422 | 5 | 0 | 417 | 46.95043611 | -94.32603968 | 2020-10-30 04:24:49 | Cass, Minnesota, US |
212851 | 212851 | 2020-10-29 | US | Oregon | Klamath | 41035 | 422 | 3 | 0 | 419 | 42.68762984 | -121.64964609999998 | 2020-10-30 04:24:49 | Klamath, Oregon, US |
224103 | 224103 | 2022-05-09 | US | Nebraska | Pawnee | 31133 | 422 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-05-10 04:20:50 | Pawnee, Nebraska, US | |
228761 | 228761 | 2020-04-30 | Jamaica | 422 | 8 | 29 | 385 | 18.1096 | -77.2975 | 2020-05-01 02:32:28 | Jamaica | |||
231415 | 231415 | 2022-05-31 | US | New Mexico | Catron | 35003 | 422 | 15 | 0 | 33.91514144 | -108.4046587 | 2022-06-01 04:20:55 | Catron, New Mexico, US | |
242789 | 242789 | 2021-04-02 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 32.83121059 | 0.0 | 2021-04-03 04:20:44 | Unassigned, Louisiana, US | |
248411 | 248411 | 2021-08-17 | US | Texas | Kinney | 48271 | 422 | 7 | 0 | 29.34967888 | -100.41866379999999 | 2021-08-18 04:21:35 | Kinney, Texas, US | |
248741 | 248741 | 2021-08-17 | US | West Virginia | Calhoun | 54013 | 422 | 1 | 0 | 38.84315422 | -81.11934872 | 2021-08-18 04:21:35 | Calhoun, West Virginia, US | |
252446 | 252446 | 2021-09-04 | US | Texas | Mason | 48319 | 422 | 6 | 0 | 30.71780434 | -99.22629416 | 2021-09-05 04:21:33 | Mason, Texas, US | |
255327 | 255327 | 2022-09-08 | US | Montana | McCone | 30055 | 422 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-09-09 04:21:11 | McCone, Montana, US | |
255353 | 255353 | 2022-09-08 | US | Montana | Wheatland | 30107 | 422 | 14 | 0 | 46.46652491 | -109.8464636 | 2022-09-09 04:21:11 | Wheatland, Montana, US | |
266113 | 266113 | 2020-05-21 | US | Alabama | Franklin | 1059 | 422 | 5 | 0 | 417 | 34.44235334 | -87.84289505 | 2020-05-22 02:36:51 | Franklin, Alabama, US |
267701 | 267701 | 2020-05-21 | US | Michigan | St. Clair | 26147 | 422 | 33 | 0 | 389 | 42.92655373 | -82.67937954 | 2020-05-22 02:36:51 | St. Clair, Michigan, US |
271188 | 271188 | 2020-04-28 | US | Connecticut | Tolland | 9013 | 422 | 35 | 0 | 387 | 41.85853803 | -72.3308481 | 2020-04-29 02:32:29 | Tolland, Connecticut, US |
273443 | 273443 | 2020-11-10 | US | Kansas | Jackson | 20085 | 422 | 4 | 0 | 418 | 39.41673394 | -95.79356799 | 2020-11-11 05:25:30 | Jackson, Kansas, US |
276795 | 276795 | 2021-11-03 | US | Colorado | Custer | 8027 | 422 | 11 | 0 | 38.10883162 | -105.3683478 | 2021-11-04 04:22:20 | Custer, Colorado, US | |
279082 | 279082 | 2021-11-03 | US | South Dakota | Perkins | 46105 | 422 | 15 | 0 | 45.49049506 | -102.47555859999999 | 2021-11-04 04:22:20 | Perkins, South Dakota, US | |
282057 | 282057 | 2021-02-24 | US | Missouri | Carter | 29035 | 422 | 8 | 0 | 414 | 36.94160441 | -90.96051322 | 2021-02-25 05:24:57 | Carter, Missouri, US |
282206 | 282206 | 2021-02-24 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-25 05:24:57 | Teton, Montana, US |
286679 | 286679 | 2020-06-15 | US | Louisiana | Union | 22111 | 422 | 20 | 0 | 402 | 32.83121059 | -92.3749373 | 2020-06-16 04:33:09 | Union, Louisiana, US |
297376 | 297376 | 2021-07-15 | US | Kentucky | Ballard | 21007 | 422 | 10 | 0 | 37.05842757 | -88.99427697 | 2021-07-16 04:21:22 | Ballard, Kentucky, US | |
298566 | 298566 | 2021-07-15 | US | Oklahoma | Harper | 40059 | 422 | 8 | 0 | 36.78836519 | -99.6679804 | 2021-07-16 04:21:22 | Harper, Oklahoma, US | |
299424 | 299424 | 2021-07-15 | US | Virginia | Surry | 51181 | 422 | 9 | 0 | 37.11781893 | -76.88450012 | 2021-07-16 04:21:22 | Surry, Virginia, US | |
299932 | 299932 | 2020-07-01 | US | Minnesota | Blue Earth | 27013 | 422 | 2 | 0 | 420 | 44.03554215 | -94.06699781 | 2020-07-02 04:33:46 | Blue Earth, Minnesota, US |
299942 | 299942 | 2020-07-01 | US | Indiana | Boone | 18011 | 422 | 42 | 0 | 380 | 40.0509304 | -86.46841646 | 2020-07-02 04:33:46 | Boone, Indiana, US |
324195 | 324195 | 2020-07-20 | US | Mississippi | Coahoma | 28027 | 422 | 7 | 0 | 415 | 34.22772299 | -90.60415045 | 2020-07-21 04:38:46 | Coahoma, Mississippi, US |
341606 | 341606 | 2021-02-03 | US | Kansas | Rush | 20165 | 422 | 11 | 0 | 411 | 38.52275276 | -99.30863983 | 2021-02-04 05:22:26 | Rush, Kansas, US |
341613 | 341613 | 2021-02-03 | US | Kansas | Sheridan | 20179 | 422 | 9 | 0 | 413 | 39.35018161 | -100.4418259 | 2021-02-04 05:22:26 | Sheridan, Kansas, US |
345199 | 345199 | 2020-09-14 | US | Idaho | Jefferson | 16051 | 422 | 1 | 0 | 421 | 43.82078483 | -112.3131749 | 2020-09-15 03:22:50 | Jefferson, Idaho, US |
353828 | 353828 | 2021-03-11 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 32.83121059 | 0.0 | 2021-03-12 05:26:50 | Unassigned, Louisiana, US | |
362450 | 362450 | 2022-05-07 | US | Nebraska | Pawnee | 31133 | 422 | 2 | 0 | 40.13141096 | -96.23705437 | 2022-05-08 04:20:49 | Pawnee, Nebraska, US | |
365541 | 365541 | 2020-07-16 | US | Arizona | La Paz | 4012 | 422 | 7 | 0 | 415 | 33.72854224 | -113.9810029 | 2020-07-17 04:34:50 | La Paz, Arizona, US |
365601 | 365601 | 2020-07-16 | US | Georgia | Laurens | 13175 | 422 | 1 | 0 | 421 | 32.46325233 | -82.92221316 | 2020-07-17 04:34:50 | Laurens, Georgia, US |
368479 | 368479 | 2020-08-08 | US | Michigan | Clinton | 26037 | 422 | 13 | 0 | 409 | 42.94400871 | -84.60145248 | 2020-08-09 04:34:54 | Clinton, Michigan, US |
369553 | 369553 | 2020-08-08 | US | Michigan | Lenawee | 26091 | 422 | 12 | 0 | 410 | 41.89475156 | -84.06603727 | 2020-08-09 04:34:54 | Lenawee, Michigan, US |
370300 | 370300 | 2020-08-08 | US | Maryland | Queen Anne's | 24035 | 422 | 25 | 0 | 397 | 39.06198912 | -76.03530977 | 2020-08-09 04:34:54 | Queen Anne's, Maryland, US |
376689 | 376689 | 2020-11-06 | US | Arkansas | Polk | 5113 | 422 | 5 | 0 | 417 | 34.48254879 | -94.22728802 | 2020-11-07 05:24:52 | Polk, Arkansas, US |
377523 | 377523 | 2020-11-06 | US | Kansas | Sumner | 20191 | 422 | 4 | 0 | 418 | 37.23682549 | -97.47721621 | 2020-11-07 05:24:52 | Sumner, Kansas, US |
383520 | 383520 | 2021-04-30 | US | Virginia | Falls Church | 51610 | 422 | 9 | 0 | 38.88485255 | -77.17560759 | 2021-05-01 04:20:47 | Falls Church, Virginia, US | |
389757 | 389757 | 2021-04-04 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 32.83121059 | 0.0 | 2021-04-05 04:20:35 | Unassigned, Louisiana, US | |
391069 | 391069 | 2021-04-04 | US | South Dakota | Buffalo | 46017 | 422 | 13 | 0 | 44.07657829 | -99.20814467 | 2021-04-05 04:20:35 | Buffalo, South Dakota, US | |
394123 | 394123 | 2020-11-27 | US | Missouri | Douglas | 29067 | 422 | 15 | 0 | 407 | 36.9325593 | -92.49905109 | 2020-11-28 05:25:50 | Douglas, Missouri, US |
394333 | 394333 | 2020-11-27 | US | Nebraska | Pierce | 31139 | 422 | 14 | 0 | 408 | 42.26434853 | -97.60122773 | 2020-11-28 05:25:50 | Pierce, Nebraska, US |
414924 | 414924 | 2020-07-05 | US | Utah | Wasatch | 49051 | 422 | 3 | 0 | 419 | 40.33110236 | -111.1691419 | 2020-07-06 04:33:57 | Wasatch, Utah, US |
427749 | 427749 | 2020-09-07 | US | Alaska | Kenai Peninsula | 2122 | 422 | 2 | 0 | 420 | 60.24429722 | -151.53888840000005 | 2020-09-08 04:28:25 | Kenai Peninsula, Alaska, US |
437419 | 437419 | 2021-01-21 | US | Nebraska | Furnas | 31065 | 422 | 4 | 0 | 418 | 40.17642064 | -99.91247454 | 2021-01-22 05:22:10 | Furnas, Nebraska, US |
455663 | 455663 | 2020-08-07 | US | Michigan | Clinton | 26037 | 422 | 13 | 0 | 409 | 42.94400871 | -84.60145248 | 2020-08-08 04:34:53 | Clinton, Michigan, US |
457928 | 457928 | 2020-08-07 | US | Minnesota | Todd | 27153 | 422 | 2 | 0 | 420 | 46.06996226 | -94.89785296 | 2020-08-08 04:34:53 | Todd, Minnesota, US |
458261 | 458261 | 2020-08-07 | US | Texas | Wise | 48497 | 422 | 6 | 0 | 384 | 33.21570665 | -97.65460265 | 2020-08-08 04:34:53 | Wise, Texas, US |
461771 | 461771 | 2022-02-02 | US | North Dakota | Burke | 38013 | 422 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2022-02-03 04:21:21 | Burke, North Dakota, US | |
473435 | 473435 | 2021-02-19 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-20 05:22:51 | Teton, Montana, US |
474269 | 474269 | 2021-02-19 | US | South Dakota | Douglas | 46043 | 422 | 9 | 0 | 413 | 43.38520741 | -98.36978007 | 2021-02-20 05:22:51 | Douglas, South Dakota, US |
478885 | 478885 | 2022-06-26 | US | Washington | Garfield | 53023 | 422 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-06-27 04:21:00 | Garfield, Washington, US | |
484954 | 484954 | 2021-07-19 | US | Kentucky | Ballard | 21007 | 422 | 10 | 0 | 37.05842757 | -88.99427697 | 2021-07-20 04:21:48 | Ballard, Kentucky, US | |
486144 | 486144 | 2021-07-19 | US | Oklahoma | Harper | 40059 | 422 | 8 | 0 | 36.78836519 | -99.6679804 | 2021-07-20 04:21:48 | Harper, Oklahoma, US | |
487002 | 487002 | 2021-07-19 | US | Virginia | Surry | 51181 | 422 | 9 | 0 | 37.11781893 | -76.88450012 | 2021-07-20 04:21:48 | Surry, Virginia, US | |
491433 | 491433 | 2021-10-14 | China | Inner Mongolia | 422 | 1 | 0 | 44.0935 | 113.9448 | 2021-10-15 04:21:26 | Inner Mongolia, China | |||
492904 | 492904 | 2021-10-14 | US | Kansas | Cheyenne | 20023 | 422 | 13 | 0 | 39.78580976 | -101.7318201 | 2021-10-15 04:21:26 | Cheyenne, Kansas, US | |
494779 | 494779 | 2021-10-14 | US | Texas | Kimble | 48267 | 422 | 11 | 0 | 30.48678918 | -99.74856473 | 2021-10-15 04:21:26 | Kimble, Texas, US | |
500534 | 500534 | 2022-04-02 | US | Georgia | Quitman | 13239 | 422 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-04-03 04:20:48 | Quitman, Georgia, US | |
526266 | 526266 | 2021-06-09 | US | Virginia | Surry | 51181 | 422 | 9 | 0 | 37.11781893 | -76.88450012 | 2021-06-10 04:23:17 | Surry, Virginia, US | |
529520 | 529520 | 2020-07-04 | US | Wisconsin | Washington | 55131 | 422 | 16 | 0 | 406 | 43.36863664 | -88.22974712 | 2020-07-05 04:33:46 | Washington, Wisconsin, US |
532729 | 532729 | 2021-02-22 | US | Montana | Teton | 30099 | 422 | 5 | 0 | 417 | 47.83741052 | -112.2410688 | 2021-02-23 05:23:41 | Teton, Montana, US |
537635 | 537635 | 2021-10-27 | US | South Dakota | Potter | 46107 | 422 | 4 | 0 | 45.06583079 | -99.95498503 | 2021-10-28 04:22:08 | Potter, South Dakota, US | |
547902 | 547902 | 2020-09-12 | US | Iowa | Bremer | 19017 | 422 | 7 | 0 | 415 | 42.77461496 | -92.31795937 | 2020-09-13 04:30:52 | Bremer, Iowa, US |
557684 | 557684 | 2022-01-16 | US | South Dakota | Miner | 46097 | 422 | 12 | 0 | 44.02197882 | -97.60992207 | 2022-01-17 04:21:08 | Miner, South Dakota, US | |
566012 | 566012 | 2021-06-22 | US | Texas | Cochran | 48079 | 422 | 15 | 0 | 33.60425307 | -102.8284499 | 2021-06-23 04:21:46 | Cochran, Texas, US | |
580196 | 580196 | 2021-07-13 | US | Kentucky | Ballard | 21007 | 422 | 10 | 0 | 37.05842757 | -88.99427697 | 2021-07-14 04:21:35 | Ballard, Kentucky, US | |
581386 | 581386 | 2021-07-13 | US | Oklahoma | Harper | 40059 | 422 | 8 | 0 | 36.78836519 | -99.6679804 | 2021-07-14 04:21:35 | Harper, Oklahoma, US | |
591166 | 591166 | 2021-08-08 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 32.83121059 | 0.0 | 2021-08-09 04:21:24 | Unassigned, Louisiana, US | |
602955 | 602955 | 2021-09-23 | US | Kansas | Chautauqua | 20019 | 422 | 8 | 0 | 37.14994405 | -96.2454192 | 2021-09-24 04:21:44 | Chautauqua, Kansas, US | |
610724 | 610724 | 2020-08-29 | US | Illinois | Union | 17181 | 422 | 24 | 0 | 398 | 37.47119609 | -89.25548938 | 2020-08-30 04:28:22 | Union, Illinois, US |
615026 | 615026 | 2021-02-08 | US | Kansas | Sheridan | 20179 | 422 | 11 | 0 | 411 | 39.35018161 | -100.4418259 | 2021-02-09 05:23:30 | Sheridan, Kansas, US |
624067 | 624067 | 2022-05-22 | US | New Mexico | Catron | 35003 | 422 | 15 | 0 | 33.91514144 | -108.4046587 | 2022-05-26 04:20:50 | Catron, New Mexico, US | |
627242 | 627242 | 2021-07-10 | US | Kentucky | Ballard | 21007 | 422 | 10 | 0 | 37.05842757 | -88.99427697 | 2021-07-11 04:21:43 | Ballard, Kentucky, US | |
628432 | 628432 | 2021-07-10 | US | Oklahoma | Harper | 40059 | 422 | 8 | 0 | 36.78836519 | -99.6679804 | 2021-07-11 04:21:43 | Harper, Oklahoma, US | |
631209 | 631209 | 2022-07-12 | US | Kansas | Hodgeman | 20083 | 422 | 11 | 0 | 38.08780079 | -99.89829881 | 2022-07-13 04:20:58 | Hodgeman, Kansas, US | |
633721 | 633721 | 2021-10-13 | China | Inner Mongolia | 422 | 1 | 0 | 44.0935 | 113.9448 | 2021-10-14 04:21:29 | Inner Mongolia, China | |||
634525 | 634525 | 2021-10-13 | US | Colorado | Baca | 8009 | 422 | 5 | 0 | 37.31940883 | -102.5603223 | 2021-10-14 04:21:29 | Baca, Colorado, US | |
635192 | 635192 | 2021-10-13 | US | Kansas | Cheyenne | 20023 | 422 | 13 | 0 | 39.78580976 | -101.7318201 | 2021-10-14 04:21:29 | Cheyenne, Kansas, US | |
637067 | 637067 | 2021-10-13 | US | Texas | Kimble | 48267 | 422 | 11 | 0 | 30.48678918 | -99.74856473 | 2021-10-14 04:21:29 | Kimble, Texas, US | |
667758 | 667758 | 2020-09-16 | US | Louisiana | Catahoula | 22025 | 422 | 9 | 0 | 413 | 31.66778967 | -91.84526385 | 2020-09-17 04:22:00 | Catahoula, Louisiana, US |
669350 | 669350 | 2020-09-16 | US | Texas | Freestone | 48161 | 422 | 1 | 0 | 396 | 31.70422788 | -96.15072516 | 2020-09-17 04:22:00 | Freestone, Texas, US |
681734 | 681734 | 2020-11-23 | US | Washington | Clallam | 53009 | 422 | 3 | 0 | 419 | 48.04754642 | -123.9226319 | 2020-11-24 05:27:31 | Clallam, Washington, US |
687638 | 687638 | 2021-11-13 | US | Kansas | Edwards | 20047 | 422 | 13 | 0 | 37.88735543 | -99.31263309 | 2021-11-14 04:21:31 | Edwards, Kansas, US | |
704071 | 704071 | 2021-03-16 | US | Michigan | Ontonagon | 26131 | 422 | 21 | 0 | 46.665226200000006 | -89.31390481 | 2021-03-17 05:25:07 | Ontonagon, Michigan, US | |
704305 | 704305 | 2021-03-16 | US | Missouri | Holt | 29087 | 422 | 10 | 0 | 40.09799248 | -95.2163888 | 2021-03-17 05:25:07 | Holt, Missouri, US | |
704382 | 704382 | 2021-03-16 | US | Montana | Broadwater | 30007 | 422 | 5 | 0 | 46.33277565 | -111.4955813 | 2021-03-17 05:25:07 | Broadwater, Montana, US | |
704820 | 704820 | 2021-03-16 | US | North Dakota | Sargent | 38081 | 422 | 6 | 0 | 46.10830372 | -97.63217159 | 2021-03-17 05:25:07 | Sargent, North Dakota, US | |
709309 | 709309 | 2021-09-29 | US | South Dakota | Hanson | 46061 | 422 | 4 | 0 | 43.6746384 | -97.78715148 | 2021-09-30 04:21:20 | Hanson, South Dakota, US | |
709519 | 709519 | 2021-09-29 | US | Texas | Fisher | 48151 | 422 | 16 | 0 | 32.74281316 | -100.40193020000001 | 2021-09-30 04:21:20 | Fisher, Texas, 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]);