johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
418 rows where deaths = 587 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
217981 | 217981 | 2022-12-26 | Japan | Kagoshima | 353457 | 587 | 0 | 31.009484 | 130.430665 | 2022-12-27 04:21:07 | Kagoshima, Japan | |||
3176013 | 3176013 | 2022-12-19 | US | New York | Albany | 36001 | 76361 | 587 | 0 | 42.60060306 | -73.97723916 | 2022-12-20 04:21:04 | Albany, New York, US | |
3714176 | 3714176 | 2022-12-06 | Japan | Mie | 308628 | 587 | 0 | 34.508018 | 136.376013 | 2022-12-07 04:20:58 | Mie, Japan | |||
1964585 | 1964585 | 2022-11-30 | Japan | Nara | 256898 | 587 | 0 | 34.317451 | 135.871644 | 2022-12-01 04:21:03 | Nara, Japan | |||
3551643 | 3551643 | 2022-11-27 | Japan | Gunma | 293809 | 587 | 0 | 36.504479 | 138.985605 | 2022-11-28 04:21:02 | Gunma, Japan | |||
3525494 | 3525494 | 2022-11-24 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-25 04:21:06 | Yellowstone, Montana, US | |
3314277 | 3314277 | 2022-11-23 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-24 04:21:09 | Yellowstone, Montana, US | |
1622318 | 1622318 | 2022-11-22 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-23 04:21:06 | Yellowstone, Montana, US | |
3462206 | 3462206 | 2022-11-21 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-22 04:20:47 | Yellowstone, Montana, US | |
1642391 | 1642391 | 2022-11-20 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-21 04:21:05 | Yellowstone, Montana, US | |
2065948 | 2065948 | 2022-11-19 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-20 04:21:08 | Yellowstone, Montana, US | |
1757342 | 1757342 | 2022-11-18 | US | Montana | Yellowstone | 30111 | 49229 | 587 | 0 | 45.93955949 | -108.2691486 | 2022-11-19 04:21:14 | Yellowstone, Montana, US | |
1831254 | 1831254 | 2022-10-25 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-26 04:22:19 | Hendricks, Indiana, US | |
795515 | 795515 | 2022-10-24 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-25 04:21:53 | Hendricks, Indiana, US | |
3277970 | 3277970 | 2022-10-23 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-24 04:22:29 | Hendricks, Indiana, US | |
2269008 | 2269008 | 2022-10-22 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-23 04:22:46 | Hendricks, Indiana, US | |
1593308 | 1593308 | 2022-10-21 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-22 04:22:53 | Hendricks, Indiana, US | |
2273024 | 2273024 | 2022-10-20 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-21 04:22:23 | Hendricks, Indiana, US | |
199359 | 199359 | 2022-10-19 | US | Indiana | Hendricks | 18063 | 45393 | 587 | 0 | 39.76719009 | -86.51037283 | 2022-10-20 04:22:59 | Hendricks, Indiana, US | |
133376 | 133376 | 2022-10-04 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-10-05 04:23:06 | Jackson, Oregon, US | |
2688323 | 2688323 | 2022-10-03 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-10-04 04:22:55 | Jackson, Oregon, US | |
2262390 | 2262390 | 2022-10-02 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-10-03 04:23:11 | Jackson, Oregon, US | |
2997916 | 2997916 | 2022-10-01 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-10-02 04:21:23 | Jackson, Oregon, US | |
856242 | 856242 | 2022-09-30 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-10-01 04:23:01 | Jackson, Oregon, US | |
2378168 | 2378168 | 2022-09-29 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-09-30 04:23:09 | Jackson, Oregon, US | |
2375534 | 2375534 | 2022-09-29 | Japan | Gifu | 289959 | 587 | 0 | 35.778671 | 137.055925 | 2022-09-30 04:23:09 | Gifu, Japan | |||
1562719 | 1562719 | 2022-09-28 | US | Oregon | Jackson | 41029 | 50866 | 587 | 0 | 42.43201126 | -122.7289309 | 2022-09-29 04:22:34 | Jackson, Oregon, US | |
3997092 | 3997092 | 2022-09-27 | US | Ohio | Clermont | 39025 | 60465 | 587 | 0 | 39.04847534 | -84.15375786 | 2022-09-28 04:23:01 | Clermont, Ohio, US | |
2772498 | 2772498 | 2022-09-26 | US | Wisconsin | Brown | 55009 | 96806 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-27 04:23:01 | Brown, Wisconsin, US | |
1980151 | 1980151 | 2022-09-25 | US | Wisconsin | Brown | 55009 | 96669 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-26 04:20:52 | Brown, Wisconsin, US | |
2653318 | 2653318 | 2022-09-24 | US | Wisconsin | Brown | 55009 | 96669 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-25 04:23:31 | Brown, Wisconsin, US | |
387758 | 387758 | 2022-09-23 | US | Wisconsin | Brown | 55009 | 96669 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-24 04:21:40 | Brown, Wisconsin, US | |
1627824 | 1627824 | 2022-09-22 | US | Wisconsin | Brown | 55009 | 96604 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-23 04:23:13 | Brown, Wisconsin, US | |
1374028 | 1374028 | 2022-09-21 | US | Wisconsin | Brown | 55009 | 96509 | 587 | 0 | 44.4526553 | -88.00411844 | 2022-09-22 04:22:56 | Brown, Wisconsin, US | |
3988789 | 3988789 | 2022-09-15 | US | New Hampshire | Rockingham | 33015 | 77817 | 587 | 0 | 42.98499744 | -71.12883377 | 2022-09-16 04:21:19 | Rockingham, New Hampshire, US | |
1876673 | 1876673 | 2022-08-28 | Australia | Western Australia | 1126947 | 587 | 0 | -31.9505 | 115.8605 | 2022-08-29 04:21:06 | Western Australia, Australia | |||
1347848 | 1347848 | 2022-08-10 | US | Louisiana | Rapides | 22079 | 36581 | 587 | 0 | 31.19778499 | -92.52997303 | 2022-08-11 04:20:49 | Rapides, Louisiana, US | |
1087603 | 1087603 | 2022-08-09 | US | Louisiana | Rapides | 22079 | 36520 | 587 | 0 | 31.19778499 | -92.52997303 | 2022-08-10 04:20:57 | Rapides, Louisiana, US | |
3545018 | 3545018 | 2022-08-08 | US | Louisiana | Rapides | 22079 | 36469 | 587 | 0 | 31.19778499 | -92.52997303 | 2022-08-09 04:20:34 | Rapides, Louisiana, US | |
2338479 | 2338479 | 2022-07-27 | US | Texas | Ellis | 48139 | 52284 | 587 | 0 | 32.34894117 | -96.79371841 | 2022-07-28 04:20:56 | Ellis, Texas, US | |
1490669 | 1490669 | 2022-07-26 | US | Texas | Ellis | 48139 | 52239 | 587 | 0 | 32.34894117 | -96.79371841 | 2022-07-27 04:21:04 | Ellis, Texas, US | |
2597115 | 2597115 | 2022-07-25 | US | Texas | Ellis | 48139 | 52171 | 587 | 0 | 32.34894117 | -96.79371841 | 2022-07-26 04:20:58 | Ellis, Texas, US | |
899230 | 899230 | 2022-07-24 | US | Texas | Ellis | 48139 | 52117 | 587 | 0 | 32.34894117 | -96.79371841 | 2022-07-25 04:20:51 | Ellis, Texas, US | |
94224 | 94224 | 2022-07-23 | US | Texas | Ellis | 48139 | 52047 | 587 | 0 | 32.34894117 | -96.79371841 | 2022-07-24 04:20:47 | Ellis, Texas, US | |
2490656 | 2490656 | 2022-06-29 | US | Colorado | Mesa | 8077 | 45544 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-30 04:21:01 | Mesa, Colorado, US | |
2240038 | 2240038 | 2022-06-28 | US | Colorado | Mesa | 8077 | 45500 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-29 04:20:59 | Mesa, Colorado, US | |
2150619 | 2150619 | 2022-06-27 | US | Tennessee | Montgomery | 47125 | 52471 | 587 | 0 | 36.49609412 | -87.38550661 | 2022-06-28 04:20:58 | Montgomery, Tennessee, US | |
2148280 | 2148280 | 2022-06-27 | US | Colorado | Mesa | 8077 | 45450 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-28 04:20:58 | Mesa, Colorado, US | |
476081 | 476081 | 2022-06-26 | US | Colorado | Mesa | 8077 | 45399 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-27 04:21:00 | Mesa, Colorado, US | |
939456 | 939456 | 2022-06-25 | US | Colorado | Mesa | 8077 | 45380 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-26 04:21:02 | Mesa, Colorado, US | |
3347377 | 3347377 | 2022-06-24 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-25 04:20:57 | Sumter, Florida, US | |
3347276 | 3347276 | 2022-06-24 | US | Colorado | Mesa | 8077 | 45361 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-25 04:20:57 | Mesa, Colorado, US | |
1649118 | 1649118 | 2022-06-23 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-24 04:20:58 | Sumter, Florida, US | |
1649017 | 1649017 | 2022-06-23 | US | Colorado | Mesa | 8077 | 45319 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-24 04:20:58 | Mesa, Colorado, US | |
2188353 | 2188353 | 2022-06-22 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-23 04:20:55 | Sumter, Florida, US | |
2188252 | 2188252 | 2022-06-22 | US | Colorado | Mesa | 8077 | 45264 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-23 04:20:55 | Mesa, Colorado, US | |
166784 | 166784 | 2022-06-21 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-22 04:20:54 | Sumter, Florida, US | |
166683 | 166683 | 2022-06-21 | US | Colorado | Mesa | 8077 | 45222 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-22 04:20:54 | Mesa, Colorado, US | |
1764067 | 1764067 | 2022-06-20 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-21 04:20:56 | Sumter, Florida, US | |
1763966 | 1763966 | 2022-06-20 | US | Colorado | Mesa | 8077 | 45173 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-21 04:20:56 | Mesa, Colorado, US | |
3270253 | 3270253 | 2022-06-19 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-20 04:21:01 | Sumter, Florida, US | |
3270152 | 3270152 | 2022-06-19 | US | Colorado | Mesa | 8077 | 45108 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-20 04:21:01 | Mesa, Colorado, US | |
3398165 | 3398165 | 2022-06-18 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-19 04:20:51 | Sumter, Florida, US | |
3398064 | 3398064 | 2022-06-18 | US | Colorado | Mesa | 8077 | 45088 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-19 04:20:51 | Mesa, Colorado, US | |
2312042 | 2312042 | 2022-06-17 | US | Florida | Sumter | 12119 | 24031 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-18 04:21:10 | Sumter, Florida, US | |
2311941 | 2311941 | 2022-06-17 | US | Colorado | Mesa | 8077 | 45061 | 587 | 0 | 39.01787888 | -108.469799 | 2022-06-18 04:21:10 | Mesa, Colorado, US | |
559546 | 559546 | 2022-06-16 | US | Florida | Sumter | 12119 | 23459 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-17 04:20:56 | Sumter, Florida, US | |
3983348 | 3983348 | 2022-06-15 | US | Florida | Sumter | 12119 | 23459 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-16 04:20:55 | Sumter, Florida, US | |
947589 | 947589 | 2022-06-14 | US | Florida | Sumter | 12119 | 23459 | 587 | 0 | 28.70181754 | -82.0794267 | 2022-06-15 04:20:54 | Sumter, Florida, US | |
2980841 | 2980841 | 2022-06-13 | US | Maryland | Harford | 24025 | 41144 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-14 04:20:52 | Harford, Maryland, US | |
2236967 | 2236967 | 2022-06-12 | US | Maryland | Harford | 24025 | 41090 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-13 04:21:14 | Harford, Maryland, US | |
3143165 | 3143165 | 2022-06-11 | US | Maryland | Harford | 24025 | 41090 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-12 04:20:53 | Harford, Maryland, US | |
1946081 | 1946081 | 2022-06-10 | US | Maryland | Harford | 24025 | 41090 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-11 04:21:01 | Harford, Maryland, US | |
3159220 | 3159220 | 2022-06-09 | US | Maryland | Harford | 24025 | 41049 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-10 04:20:55 | Harford, Maryland, US | |
1422687 | 1422687 | 2022-06-08 | US | Maryland | Harford | 24025 | 41003 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-09 04:20:54 | Harford, Maryland, US | |
3727801 | 3727801 | 2022-06-07 | US | Maryland | Harford | 24025 | 40963 | 587 | 0 | 39.55010644 | -76.3077594 | 2022-06-08 04:20:55 | Harford, Maryland, US | |
3727433 | 3727433 | 2022-06-07 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-08 04:20:55 | Linn, Iowa, US | |
3889213 | 3889213 | 2022-06-06 | US | Maryland | Washington | 24043 | 35975 | 587 | 0 | 39.60835778 | -77.82002295 | 2022-06-07 04:21:08 | Washington, Maryland, US | |
3888835 | 3888835 | 2022-06-06 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-07 04:21:08 | Linn, Iowa, US | |
3508982 | 3508982 | 2022-06-05 | US | Maryland | Washington | 24043 | 35932 | 587 | 0 | 39.60835778 | -77.82002295 | 2022-06-06 04:20:57 | Washington, Maryland, US | |
3508604 | 3508604 | 2022-06-05 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-06 04:20:57 | Linn, Iowa, US | |
3529059 | 3529059 | 2022-06-04 | US | Maryland | Washington | 24043 | 35932 | 587 | 0 | 39.60835778 | -77.82002295 | 2022-06-05 04:20:55 | Washington, Maryland, US | |
3528681 | 3528681 | 2022-06-04 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-05 04:20:55 | Linn, Iowa, US | |
3135145 | 3135145 | 2022-06-03 | US | Maryland | Washington | 24043 | 35932 | 587 | 0 | 39.60835778 | -77.82002295 | 2022-06-04 04:20:58 | Washington, Maryland, US | |
3134767 | 3134767 | 2022-06-03 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-04 04:20:58 | Linn, Iowa, US | |
3579842 | 3579842 | 2022-06-02 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-03 04:20:58 | Linn, Iowa, US | |
973372 | 973372 | 2022-06-01 | US | Ohio | Clark | 39023 | 35537 | 587 | 0 | 39.91592258 | -83.78498252 | 2022-06-02 05:20:39 | Clark, Ohio, US | |
972135 | 972135 | 2022-06-01 | US | Iowa | Linn | 19113 | 54244 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-02 05:20:39 | Linn, Iowa, US | |
231679 | 231679 | 2022-05-31 | US | Ohio | Clark | 39023 | 35537 | 587 | 0 | 39.91592258 | -83.78498252 | 2022-06-01 04:20:55 | Clark, Ohio, US | |
230442 | 230442 | 2022-05-31 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-06-01 04:20:55 | Linn, Iowa, US | |
3187207 | 3187207 | 2022-05-30 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-31 04:20:51 | Linn, Iowa, US | |
3199356 | 3199356 | 2022-05-29 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-30 04:20:50 | Linn, Iowa, US | |
2726234 | 2726234 | 2022-05-28 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-29 04:20:53 | Linn, Iowa, US | |
1315415 | 1315415 | 2022-05-27 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-28 04:21:07 | Linn, Iowa, US | |
1851207 | 1851207 | 2022-05-26 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-27 04:20:56 | Linn, Iowa, US | |
2049083 | 2049083 | 2022-05-25 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-26 04:20:50 | Linn, Iowa, US | |
2999631 | 2999631 | 2022-05-24 | Sweden | Sormland | 63883 | 587 | 0 | 59.0336 | 16.7519 | 2022-05-25 04:20:56 | Sormland, Sweden | |||
3593352 | 3593352 | 2022-05-23 | Sweden | Sormland | 63883 | 587 | 0 | 59.0336 | 16.7519 | 2022-05-24 04:20:57 | Sormland, Sweden | |||
623094 | 623094 | 2022-05-22 | US | Iowa | Linn | 19113 | 53891 | 587 | 0 | 42.07923082 | -91.59809485 | 2022-05-26 04:20:50 | Linn, Iowa, US | |
1111171 | 1111171 | 2022-05-21 | US | Massachusetts | Barnstable | 25001 | 38323 | 587 | 0 | 41.72980578 | -70.28854339 | 2022-05-22 04:20:52 | Barnstable, 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]);