johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where active = 5687 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3129190 | 3129190 | 2021-06-28 | Malaysia | Sarawak | 64233 | 406 | 58140 | 5687 | 1.5533 | 110.3592 | 2021-06-29 04:21:28 | Sarawak, Malaysia | ||
2501901 | 2501901 | 2021-05-07 | Cuba | 113876 | 713 | 107476 | 5687 | 21.521757 | -77.78116700000002 | 2021-05-08 04:21:04 | Cuba | |||
1618771 | 1618771 | 2021-03-05 | US | Oklahoma | Carter | 40019 | 5747 | 60 | 0 | 5687 | 34.25103751 | -97.28552485 | 2021-03-06 04:23:41 | Carter, Oklahoma, US |
471892 | 471892 | 2021-02-19 | US | Arkansas | Greene | 5055 | 5761 | 74 | 0 | 5687 | 36.11735460000001 | -90.55832668 | 2021-02-20 05:22:51 | Greene, Arkansas, US |
342426 | 342426 | 2021-02-03 | US | New Hampshire | Strafford | 33017 | 5752 | 65 | 0 | 5687 | 43.291833 | -71.02336013 | 2021-02-04 05:22:26 | Strafford, New Hampshire, US |
1759624 | 1759624 | 2021-01-24 | Syria | 13628 | 885 | 7056 | 5687 | 34.802075 | 38.99681500000001 | 2021-01-25 05:22:16 | Syria | |||
2429822 | 2429822 | 2021-01-23 | US | Tennessee | Coffee | 47031 | 5795 | 82 | 0 | 5687 | 35.49090731 | -86.07311784 | 2021-01-24 05:22:35 | Coffee, Tennessee, US |
2626270 | 2626270 | 2021-01-10 | US | Alabama | Talladega | 1121 | 5796 | 109 | 0 | 5687 | 33.37823223 | -86.16886178 | 2021-01-11 05:21:50 | Talladega, Alabama, US |
2544870 | 2544870 | 2021-01-07 | US | West Virginia | Cabell | 54011 | 5801 | 114 | 0 | 5687 | 38.42424062 | -82.23855912 | 2021-01-08 05:22:42 | Cabell, West Virginia, US |
2350091 | 2350091 | 2020-12-07 | US | Pennsylvania | Lackawanna | 42069 | 5922 | 235 | 0 | 5687 | 41.43564672 | -75.60379201 | 2020-12-08 05:27:42 | Lackawanna, Pennsylvania, US |
3861466 | 3861466 | 2020-12-04 | US | Michigan | Jackson | 26075 | 5790 | 103 | 0 | 5687 | 42.24807035 | -84.42258681 | 2020-12-05 05:27:36 | Jackson, Michigan, US |
738751 | 738751 | 2020-12-02 | US | Arizona | Yavapai | 4025 | 5814 | 127 | 0 | 5687 | 34.59933926 | -112.5538588 | 2020-12-03 05:28:22 | Yavapai, Arizona, US |
1587705 | 1587705 | 2020-11-30 | US | Wisconsin | Jefferson | 55055 | 5727 | 40 | 0 | 5687 | 43.02054068 | -88.77529134 | 2020-12-01 05:26:18 | Jefferson, Wisconsin, US |
1586532 | 1586532 | 2020-11-30 | US | North Carolina | Wayne | 37191 | 5799 | 112 | 0 | 5687 | 35.36438125 | -78.00027268 | 2020-12-01 05:26:18 | Wayne, North Carolina, US |
1178689 | 1178689 | 2020-10-22 | US | Iowa | Johnson | 19103 | 5717 | 30 | 0 | 5687 | 41.67169354 | -91.58754744 | 2020-10-23 04:24:46 | Johnson, Iowa, US |
3990488 | 3990488 | 2020-10-20 | Denmark | 36373 | 688 | 29998 | 5687 | 56.2639 | 9.5018 | 2020-10-21 04:24:14 | Denmark | |||
3782343 | 3782343 | 2020-10-13 | US | Arizona | Navajo | 4017 | 5923 | 236 | 0 | 5687 | 35.3997715 | -110.3218983 | 2020-10-14 04:24:05 | Navajo, Arizona, US |
3804685 | 3804685 | 2020-10-05 | US | South Carolina | Beaufort | 45013 | 5771 | 84 | 0 | 5687 | 32.39226291 | -80.72619758 | 2020-10-06 04:23:33 | Beaufort, South Carolina, US |
2455606 | 2455606 | 2020-09-19 | US | Georgia | Muscogee | 13215 | 5849 | 162 | 0 | 5687 | 32.50931999 | -84.87142262 | 2020-09-20 04:22:00 | Muscogee, Georgia, US |
3265099 | 3265099 | 2020-07-31 | Singapore | 52205 | 27 | 46491 | 5687 | 1.2833 | 103.8333 | 2020-08-01 04:36:27 | Singapore | |||
1502545 | 1502545 | 2020-07-25 | Brazil | Alagoas | 54730 | 1486 | 47557 | 5687 | -9.5713 | -36.782 | 2020-07-26 04:35:00 | Alagoas, Brazil | ||
3204003 | 3204003 | 2020-07-18 | US | Florida | Osceola | 12097 | 5725 | 38 | 0 | 5687 | 28.06312234 | -81.14882926 | 2020-07-19 04:34:58 | Osceola, Florida, US |
1196084 | 1196084 | 2020-06-17 | Peru | Ucayali | 6645 | 958 | 0 | 5687 | -9.621718 | -73.444929 | 2020-06-18 04:33:18 | Ucayali, Peru | ||
1267598 | 1267598 | 2020-06-05 | US | Massachusetts | Hampden | 25013 | 6297 | 610 | 0 | 5687 | 42.13440424 | -72.63235561 | 2020-06-06 02:33:00 | Hampden, Massachusetts, US |
267076 | 267076 | 2020-05-21 | US | Pennsylvania | Montgomery | 42091 | 6294 | 607 | 0 | 5687 | 40.21053671 | -75.36652296 | 2020-05-22 02:36:51 | Montgomery, Pennsylvania, US |
3294424 | 3294424 | 2020-05-07 | US | Maryland | Montgomery | 24031 | 6032 | 345 | 0 | 5687 | 39.13676329 | -77.20358245 | 2020-05-08 02:32:32 | Montgomery, Maryland, 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]);