johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 5656 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185336 | 185336 | 2021-02-21 | US | Virginia | Bedford | 51019 | 5703 | 47 | 0 | 5656 | 37.3080028 | -79.5281964 | 2021-02-22 05:24:21 | Bedford, Virginia, US |
743036 | 743036 | 2021-02-20 | US | Florida | Putnam | 12107 | 5775 | 119 | 0 | 5656 | 29.60779729 | -81.74230285 | 2021-02-21 05:24:33 | Putnam, Florida, US |
472097 | 472097 | 2021-02-19 | US | Florida | Flagler | 12035 | 5742 | 86 | 0 | 5656 | 29.45933576 | -81.31508595 | 2021-02-20 05:22:51 | Flagler, Florida, US |
3541151 | 3541151 | 2021-02-12 | US | Minnesota | Blue Earth | 27013 | 5690 | 34 | 0 | 5656 | 44.03554215 | -94.06699781 | 2021-02-13 05:22:12 | Blue Earth, Minnesota, US |
1527886 | 1527886 | 2021-02-09 | Italy | P.A. Bolzano | 45457 | 913 | 38888 | 5656 | 46.49933453 | 11.35662422 | 2021-02-10 05:22:41 | P.A. Bolzano, Italy | ||
1678116 | 1678116 | 2021-02-01 | US | Michigan | Lenawee | 26091 | 5748 | 92 | 0 | 5656 | 41.89475156 | -84.06603727 | 2021-02-02 05:22:49 | Lenawee, Michigan, US |
3503685 | 3503685 | 2021-01-17 | Syria | 13036 | 832 | 6548 | 5656 | 34.802075 | 38.99681500000001 | 2021-01-18 05:22:34 | Syria | |||
2224188 | 2224188 | 2020-12-26 | US | Florida | Columbia | 12023 | 5772 | 116 | 0 | 5656 | 30.22509788 | -82.62160164 | 2020-12-27 05:22:55 | Columbia, Florida, US |
201995 | 201995 | 2020-12-25 | Brazil | Maranhao | 199986 | 4458 | 189872 | 5656 | -4.9609 | -45.2744 | 2020-12-26 05:22:28 | Maranhao, Brazil | ||
2976588 | 2976588 | 2020-12-09 | US | Kentucky | Boone | 21015 | 5689 | 33 | 0 | 5656 | 38.97065142 | -84.72615357 | 2020-12-10 05:26:19 | Boone, Kentucky, US |
2975224 | 2975224 | 2020-12-09 | Italy | Umbria | 25433 | 486 | 19291 | 5656 | 43.10675841 | 12.38824698 | 2020-12-10 05:26:19 | Umbria, Italy | ||
822209 | 822209 | 2020-11-19 | US | Colorado | Pueblo | 8101 | 8104 | 181 | 0 | 5656 | 38.17359144 | -104.5127437 | 2020-11-20 05:26:28 | Pueblo, Colorado, US |
3441024 | 3441024 | 2020-11-11 | Russia | Kirov Oblast | 13888 | 179 | 8053 | 5656 | 57.9665589 | 49.4074599 | 2020-11-12 05:25:55 | Kirov Oblast, Russia | ||
1057081 | 1057081 | 2020-10-23 | US | Utah | Southwest Utah | 5705 | 49 | 0 | 5656 | 37.85447192 | -111.4418764 | 2020-10-24 04:24:46 | Southwest Utah, Utah, US | |
2195254 | 2195254 | 2020-10-21 | Venezuela | 88035 | 753 | 81626 | 5656 | 6.4238 | -66.5897 | 2020-10-22 04:24:27 | Venezuela | |||
2689421 | 2689421 | 2020-10-08 | Brazil | Goias | 226656 | 5118 | 215243 | 5656 | -15.827 | -49.8362 | 2020-10-09 04:23:59 | Goias, Brazil | ||
3531529 | 3531529 | 2020-08-12 | Mexico | Ciudad de Mexico | 82510 | 9598 | 67256 | 5656 | 19.4326 | -99.1332 | 2020-08-13 04:29:15 | Ciudad de Mexico, Mexico | ||
1920819 | 1920819 | 2020-08-10 | Singapore | 55292 | 27 | 49609 | 5656 | 1.2833 | 103.8333 | 2020-08-11 04:35:08 | Singapore | |||
177252 | 177252 | 2020-07-27 | Brazil | Mato Grosso do Sul | 22443 | 328 | 15827 | 5656 | -20.7722 | -54.7852 | 2020-07-28 04:58:43 | Mato Grosso do Sul, Brazil | ||
3416260 | 3416260 | 2020-05-17 | Italy | Emilia-Romagna | 27232 | 3973 | 17603 | 5656 | 44.49436681 | 11.341720800000001 | 2020-05-18 02:32:21 | Emilia-Romagna, Italy |
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]);