johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 3747 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
562935 | 562935 | 2021-06-22 | India | Tripura | 63140 | 658 | 58735 | 3747 | 23.746783 | 91.743565 | 2021-06-23 04:21:46 | Tripura, India | ||
58478 | 58478 | 2021-03-07 | Malaysia | Johor | 38004 | 96 | 34161 | 3747 | 1.4854 | 103.7618 | 2021-03-08 05:24:48 | Johor, Malaysia | ||
185389 | 185389 | 2021-02-21 | US | Virginia | James City | 51095 | 3792 | 45 | 0 | 3747 | 37.31156958 | -76.76950618 | 2021-02-22 05:24:21 | James City, Virginia, US |
2639629 | 2639629 | 2021-02-11 | US | Missouri | Johnson | 29101 | 3787 | 40 | 0 | 3747 | 38.74719601 | -93.80691168 | 2021-02-12 05:23:29 | Johnson, Missouri, US |
2639460 | 2639460 | 2021-02-11 | US | Minnesota | Nobles | 27105 | 3794 | 47 | 0 | 3747 | 43.67434621 | -95.75329576 | 2021-02-12 05:23:29 | Nobles, Minnesota, US |
341748 | 341748 | 2021-02-03 | US | Kentucky | Whitley | 21235 | 3763 | 16 | 0 | 3747 | 36.75700531 | -84.14541217 | 2021-02-04 05:22:26 | Whitley, Kentucky, US |
1899652 | 1899652 | 2021-01-29 | US | Ohio | Putnam | 39137 | 3837 | 90 | 0 | 3747 | 41.02094889 | -84.1336111 | 2021-01-30 05:22:49 | Putnam, Ohio, US |
1898234 | 1898234 | 2021-01-29 | US | Indiana | Gibson | 18051 | 3825 | 78 | 0 | 3747 | 38.30393723 | -87.58054938 | 2021-01-30 05:22:49 | Gibson, Indiana, US |
2485559 | 2485559 | 2021-01-28 | US | Wyoming | Albany | 56001 | 3758 | 11 | 0 | 3747 | 41.65498705 | -105.7235415 | 2021-01-29 05:22:23 | Albany, Wyoming, US |
2484665 | 2484665 | 2021-01-28 | US | Pennsylvania | Union | 42119 | 3818 | 71 | 0 | 3747 | 40.96188846 | -77.05996014 | 2021-01-29 05:22:23 | Union, Pennsylvania, US |
15827 | 15827 | 2021-01-26 | US | West Virginia | Mercer | 54055 | 3831 | 84 | 0 | 3747 | 37.40481169 | -81.11023142 | 2021-01-27 05:23:41 | Mercer, West Virginia, US |
3880792 | 3880792 | 2021-01-14 | US | Iowa | Muscatine | 19139 | 3822 | 75 | 0 | 3747 | 41.48370744 | -91.1121697 | 2021-01-15 05:22:24 | Muscatine, Iowa, US |
3036811 | 3036811 | 2021-01-05 | US | Ohio | Union | 39159 | 3777 | 30 | 0 | 3747 | 40.30016061 | -83.37239023 | 2021-01-06 05:22:16 | Union, Ohio, US |
769755 | 769755 | 2020-12-29 | US | Washington | Kitsap | 53035 | 3787 | 40 | 0 | 3747 | 47.63479026 | -122.6436061 | 2020-12-30 05:22:34 | Kitsap, Washington, US |
3780427 | 3780427 | 2020-12-27 | US | Oklahoma | Bryan | 40013 | 3779 | 32 | 0 | 3747 | 33.96472458 | -96.25903472 | 2020-12-28 05:22:06 | Bryan, Oklahoma, US |
3780154 | 3780154 | 2020-12-27 | US | New York | Rensselaer | 36083 | 3824 | 77 | 0 | 3747 | 42.71348136 | -73.51089874 | 2020-12-28 05:22:06 | Rensselaer, New York, US |
1036800 | 1036800 | 2020-12-15 | US | North Dakota | Williams | 38105 | 3765 | 26 | 0 | 3747 | 48.34522353 | -103.4793387 | 2020-12-16 05:28:04 | Williams, North Dakota, US |
1754824 | 1754824 | 2020-12-14 | US | Wisconsin | Oconto | 55083 | 3785 | 38 | 0 | 3747 | 45.02715345 | -88.26807503 | 2020-12-15 05:26:38 | Oconto, Wisconsin, US |
1009227 | 1009227 | 2020-12-06 | US | Tennessee | Hamblen | 47063 | 3773 | 63 | 0 | 3747 | 36.21990035 | -83.26586179 | 2020-12-07 05:26:14 | Hamblen, Tennessee, US |
1006018 | 1006018 | 2020-12-06 | Belize | 7769 | 173 | 3849 | 3747 | 17.1899 | -88.4976 | 2020-12-07 05:26:14 | Belize | |||
8534 | 8534 | 2020-10-25 | Russia | Karachay-Cherkess Republic | 9084 | 30 | 5307 | 3747 | 43.7368326 | 41.7267991 | 2020-10-26 04:25:02 | Karachay-Cherkess Republic, Russia | ||
3095171 | 3095171 | 2020-09-20 | US | Minnesota | Stearns | 27145 | 3770 | 23 | 0 | 3747 | 45.55192576 | -94.61078221 | 2020-09-21 04:23:00 | Stearns, Minnesota, US |
344123 | 344123 | 2020-09-14 | Colombia | Cundinamarca | 28791 | 840 | 24204 | 3747 | 5.026 | -74.03 | 2020-09-15 03:22:50 | Cundinamarca, Colombia | ||
3485190 | 3485190 | 2020-08-20 | US | Georgia | Whitfield | 13313 | 3790 | 43 | 0 | 3747 | 34.80987459 | -84.96093476 | 2020-08-21 04:27:41 | Whitfield, Georgia, US |
2740265 | 2740265 | 2020-08-03 | Russia | Nizhny Novgorod Oblast | 24236 | 393 | 20096 | 3747 | 55.47180329999999 | 44.091159399999995 | 2020-08-04 04:41:59 | Nizhny Novgorod Oblast, Russia | ||
2808012 | 2808012 | 2020-08-02 | Australia | New South Wales | 3797 | 50 | 0 | 3747 | -33.8688 | 151.2093 | 2020-08-03 04:34:35 | New South Wales, Australia | ||
440719 | 440719 | 2020-07-26 | US | Florida | Leon | 12073 | 3760 | 13 | 0 | 3747 | 30.45955727 | -84.27491114 | 2020-07-27 04:35:02 | Leon, Florida, US |
2748375 | 2748375 | 2020-07-15 | Bulgaria | 7877 | 289 | 3841 | 3747 | 42.7339 | 25.4858 | 2020-07-16 04:44:59 | Bulgaria | |||
3737599 | 3737599 | 2020-07-12 | India | Kerala | 7873 | 31 | 4095 | 3747 | 10.450898 | 76.405749 | 2020-07-13 04:43:04 | Kerala, India | ||
1520605 | 1520605 | 2020-06-23 | US | Pennsylvania | Lancaster | 42071 | 4097 | 350 | 0 | 3747 | 40.03904563 | -76.24770128 | 2020-06-24 04:33:28 | Lancaster, Pennsylvania, US |
1520170 | 1520170 | 2020-06-23 | US | South Carolina | Greenville | 45045 | 3822 | 75 | 0 | 3747 | 34.89502264 | -82.37295012 | 2020-06-24 04:33:28 | Greenville, South Carolina, US |
3866962 | 3866962 | 2020-06-03 | Peru | Ucayali | 4580 | 833 | 0 | 3747 | -9.621718 | -73.444929 | 2020-06-04 02:33:14 | Ucayali, Peru | ||
3701625 | 3701625 | 2020-04-02 | Czechia | 3858 | 44 | 67 | 3747 | 49.8175 | 15.473 | 4/2/20 23:25 | Czechia |
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]);