johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 6290 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 10
- Brazil 1
- Congo (Kinshasa) 1
- Cuba 1
- Korea, South 1
- Kyrgyzstan 1
- Mexico 1
- Mozambique 1
- Nepal 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1736377 | 1736377 | 2021-06-12 | Congo (Kinshasa) | 34949 | 834 | 27825 | 6290 | -4.0383 | 21.7587 | 2021-06-13 04:22:44 | Congo (Kinshasa) | |||
3054063 | 3054063 | 2021-05-13 | Cuba | 120561 | 778 | 113493 | 6290 | 21.521757 | -77.78116700000002 | 2021-05-14 04:20:41 | Cuba | |||
3242440 | 3242440 | 2021-04-21 | Mozambique | 69437 | 805 | 62342 | 6290 | -18.665695 | 35.529562 | 2021-04-22 04:20:53 | Mozambique | |||
3129636 | 3129636 | 2021-04-18 | Nepal | 284673 | 3083 | 275300 | 6290 | 28.1667 | 84.25 | 2021-04-19 04:20:57 | Nepal | |||
1290058 | 1290058 | 2021-03-29 | Korea, South | 102582 | 1729 | 94563 | 6290 | 35.90775700000001 | 127.766922 | 2021-03-30 04:26:23 | Korea, South | |||
3670340 | 3670340 | 2021-03-06 | US | Puerto Rico | Carolina | 72031 | 6290 | 0 | 0 | 6290 | 18.374986 | -65.95683100000001 | 2021-03-07 05:21:54 | Carolina, Puerto Rico, US |
2185800 | 2185800 | 2021-02-26 | US | New York | Chemung | 36015 | 6420 | 130 | 0 | 6290 | 42.13891056 | -76.7638805 | 2021-02-27 05:22:28 | Chemung, New York, US |
182924 | 182924 | 2021-02-21 | US | Georgia | Walker | 13295 | 6364 | 74 | 0 | 6290 | 34.73376362 | -85.30165174 | 2021-02-22 05:24:21 | Walker, Georgia, US |
3978950 | 3978950 | 2021-02-10 | US | Alabama | Jackson | 1071 | 6374 | 84 | 0 | 6290 | 34.78144169 | -85.99750489 | 2021-02-11 05:23:55 | Jackson, Alabama, US |
3695567 | 3695567 | 2020-12-31 | Mexico | Campeche | 7259 | 969 | 0 | 6290 | 19.8301 | -90.5349 | 2021-01-01 05:23:07 | Campeche, Mexico | ||
2120810 | 2120810 | 2020-12-20 | US | Indiana | Kosciusko | 18085 | 6364 | 74 | 0 | 6290 | 41.24521668 | -85.86312322 | 2020-12-21 05:27:58 | Kosciusko, Indiana, US |
3150106 | 3150106 | 2020-12-16 | US | Arkansas | Saline | 5125 | 6373 | 83 | 0 | 6290 | 34.64916145 | -92.67583224 | 2020-12-17 05:28:12 | Saline, Arkansas, US |
1352607 | 1352607 | 2020-11-24 | US | North Carolina | Catawba | 37035 | 6374 | 84 | 0 | 6290 | 35.66211129 | -81.2132617 | 2020-11-25 05:27:20 | Catawba, North Carolina, US |
3411786 | 3411786 | 2020-11-01 | US | North Carolina | Pitt | 37147 | 6331 | 41 | 0 | 6290 | 35.59535426 | -77.37353178 | 2020-11-02 05:25:04 | Pitt, North Carolina, US |
1057481 | 1057481 | 2020-10-23 | West Bank and Gaza | 49579 | 439 | 42850 | 6290 | 31.9522 | 35.2332 | 2020-10-24 04:24:46 | West Bank and Gaza | |||
1612302 | 1612302 | 2020-08-14 | Kyrgyzstan | 41373 | 1491 | 33592 | 6290 | 41.20438 | 74.766098 | 2020-08-15 04:27:31 | Kyrgyzstan | |||
585965 | 585965 | 2020-08-13 | US | Texas | Lubbock | 48303 | 2488 | 75 | 0 | 6290 | 33.61008596 | -101.8204789 | 2020-08-14 04:51:19 | Lubbock, Texas, US |
2219796 | 2219796 | 2020-07-08 | US | South Carolina | Charleston | 45019 | 6337 | 47 | 0 | 6290 | 32.82487866 | -79.96512315 | 2020-07-09 04:34:23 | Charleston, South Carolina, US |
875662 | 875662 | 2020-05-24 | Brazil | Rio Grande do Sul | 6470 | 180 | 0 | 6290 | -30.0346 | -51.2177 | 2020-05-25 02:32:44 | Rio Grande do Sul, Brazil |
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]);