johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where active = 5598 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296417 | 3296417 | 2021-07-30 | Russia | Primorsky Krai | 54308 | 916 | 47794 | 5598 | 45.0819456 | 134.726645 | 2021-07-31 04:21:35 | Primorsky Krai, Russia | ||
3670570 | 3670570 | 2021-03-06 | US | Tennessee | Jefferson | 47089 | 5711 | 119 | 0 | 5598 | 36.04818632 | -83.45148924 | 2021-03-07 05:21:54 | Jefferson, Tennessee, US |
3668168 | 3668168 | 2021-03-06 | US | California | Lassen | 6035 | 5230 | 18 | 0 | 5598 | 40.67311306 | -120.59350990000002 | 2021-03-07 05:21:54 | Lassen, California, US |
2210198 | 2210198 | 2021-03-04 | US | Oklahoma | Grady | 40051 | 5674 | 76 | 0 | 5598 | 35.0167709 | -97.88339847 | 2021-03-05 05:26:29 | Grady, Oklahoma, US |
2680497 | 2680497 | 2021-02-13 | US | Pennsylvania | Lawrence | 42073 | 5775 | 177 | 0 | 5598 | 40.99206278 | -80.33393706 | 2021-02-14 05:23:43 | Lawrence, Pennsylvania, US |
1589895 | 1589895 | 2021-02-05 | US | Minnesota | Kandiyohi | 27067 | 5671 | 73 | 0 | 5598 | 45.1526059 | -95.00586446 | 2021-02-06 05:23:55 | Kandiyohi, Minnesota, US |
2468989 | 2468989 | 2021-01-22 | US | New Mexico | Eddy | 35015 | 5692 | 94 | 0 | 5598 | 32.47167456 | -104.3053527 | 2021-01-23 05:22:03 | Eddy, New Mexico, US |
3882025 | 3882025 | 2021-01-14 | US | Ohio | Erie | 39043 | 5729 | 131 | 0 | 5598 | 41.36796058 | -82.62904521 | 2021-01-15 05:22:24 | Erie, Ohio, US |
774750 | 774750 | 2021-01-12 | US | Alabama | Walker | 1127 | 5775 | 177 | 0 | 5598 | 33.80270512 | -87.30027177 | 2021-01-13 05:22:15 | Walker, Alabama, US |
193460 | 193460 | 2021-01-11 | US | Virginia | Roanoke City | 51770 | 5701 | 103 | 0 | 5598 | 37.27791025 | -79.96189766 | 2021-01-12 05:22:15 | Roanoke City, Virginia, US |
2542134 | 2542134 | 2021-01-07 | US | Florida | Sumter | 12119 | 5720 | 122 | 0 | 5598 | 28.70181754 | -82.0794267 | 2021-01-08 05:22:42 | Sumter, Florida, US |
3232327 | 3232327 | 2021-01-03 | US | Missouri | Christian | 29043 | 5647 | 49 | 0 | 5598 | 36.9711783 | -93.18537118 | 2021-01-04 05:22:02 | Christian, Missouri, US |
3763183 | 3763183 | 2020-12-28 | US | Michigan | Allegan | 26005 | 5660 | 62 | 0 | 5598 | 42.59147037 | -85.89102866 | 2020-12-29 05:22:37 | Allegan, Michigan, US |
1602858 | 1602858 | 2020-12-10 | US | Pennsylvania | Blair | 42013 | 5695 | 97 | 0 | 5598 | 40.47961444 | -78.34917412 | 2020-12-11 05:26:59 | Blair, Pennsylvania, US |
2976197 | 2976197 | 2020-12-09 | US | Illinois | DeKalb | 17037 | 5651 | 53 | 0 | 5598 | 41.89373302 | -88.76958483 | 2020-12-10 05:26:19 | DeKalb, Illinois, US |
3862706 | 3862706 | 2020-12-04 | US | South Dakota | Lincoln | 46083 | 5653 | 55 | 0 | 5598 | 43.27841182 | -96.7203905 | 2020-12-05 05:27:36 | Lincoln, South Dakota, US |
3862071 | 3862071 | 2020-12-04 | US | New York | Oneida | 36065 | 5760 | 162 | 0 | 5598 | 43.24375382 | -75.43710392 | 2020-12-05 05:27:36 | Oneida, New York, US |
77742 | 77742 | 2020-12-03 | US | Pennsylvania | Cumberland | 42041 | 5753 | 155 | 0 | 5598 | 40.1625372 | -77.26130755 | 2020-12-04 05:27:27 | Cumberland, Pennsylvania, US |
3441728 | 3441728 | 2020-11-11 | US | Idaho | Bonneville | 16019 | 5639 | 41 | 0 | 5598 | 43.38713372 | -111.6161537 | 2020-11-12 05:25:55 | Bonneville, Idaho, US |
275152 | 275152 | 2020-11-10 | US | Tennessee | Wilson | 47189 | 5677 | 66 | 0 | 5598 | 36.15496772 | -86.29775884 | 2020-11-11 05:25:30 | Wilson, Tennessee, US |
764174 | 764174 | 2020-10-18 | US | Missouri | Boone | 29019 | 5612 | 14 | 0 | 5598 | 38.99186229 | -92.30723575 | 2020-10-19 04:24:16 | Boone, Missouri, US |
1105305 | 1105305 | 2020-09-02 | Brazil | Rio de Janeiro | 228332 | 16315 | 206419 | 5598 | -22.9068 | -43.1729 | 2020-09-03 04:28:22 | Rio de Janeiro, Brazil | ||
3562868 | 3562868 | 2020-08-25 | Sudan | 12974 | 819 | 6557 | 5598 | 12.8628 | 30.2176 | 2020-08-26 04:28:11 | Sudan | |||
61746 | 61746 | 2020-07-23 | Brazil | Alagoas | 52529 | 1457 | 45474 | 5598 | -9.5713 | -36.782 | 2020-07-24 05:30:40 | Alagoas, Brazil | ||
2705507 | 2705507 | 2020-07-17 | US | Pennsylvania | Bucks | 42017 | 6171 | 573 | 0 | 5598 | 40.33682119 | -75.10836643 | 2020-07-18 04:34:45 | Bucks, Pennsylvania, US |
2553681 | 2553681 | 2020-06-02 | US | Massachusetts | Hampden | 25013 | 6201 | 603 | 0 | 5598 | 42.13440424 | -72.63235561 | 2020-06-03 02:33:13 | 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]);