johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 5171 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3895608 | 3895608 | 2021-08-29 | Malaysia | Negeri Sembilan | 90993 | 1003 | 84819 | 5171 | 2.7258 | 101.9424 | 2021-08-30 04:21:23 | Negeri Sembilan, Malaysia | ||
1618716 | 1618716 | 2021-03-05 | US | Ohio | Lawrence | 39087 | 5271 | 100 | 0 | 5171 | 38.59743452 | -82.53466552 | 2021-03-06 04:23:41 | Lawrence, Ohio, US |
1338603 | 1338603 | 2021-02-15 | Syria | 14906 | 981 | 8754 | 5171 | 34.802075 | 38.99681500000001 | 2021-02-16 05:24:38 | Syria | |||
2680259 | 2680259 | 2021-02-13 | US | Ohio | Ashtabula | 39007 | 5327 | 156 | 0 | 5171 | 41.70860332 | -80.74830218 | 2021-02-14 05:23:43 | Ashtabula, Ohio, US |
3542453 | 3542453 | 2021-02-12 | US | Tennessee | Warren | 47177 | 5232 | 73 | 0 | 5171 | 35.6728299 | -85.77969117 | 2021-02-13 05:22:12 | Warren, Tennessee, US |
976022 | 976022 | 2021-02-06 | US | Indiana | Marshall | 18099 | 5268 | 97 | 0 | 5171 | 41.32467367 | -86.26185087 | 2021-02-07 05:23:00 | Marshall, Indiana, US |
2226440 | 2226440 | 2020-12-26 | US | Tennessee | Greene | 47059 | 5277 | 88 | 0 | 5171 | 36.17470125 | -82.84691273 | 2020-12-27 05:22:55 | Greene, Tennessee, US |
3772554 | 3772554 | 2020-12-22 | US | Pennsylvania | Monroe | 42089 | 5359 | 188 | 0 | 5171 | 41.05934058 | -75.34031025 | 2020-12-23 05:22:03 | Monroe, Pennsylvania, US |
2917988 | 2917988 | 2020-11-14 | US | South Carolina | Dorchester | 45035 | 5278 | 107 | 0 | 5171 | 33.0794369 | -80.40502652 | 2020-11-15 05:26:53 | Dorchester, South Carolina, US |
379179 | 379179 | 2020-11-06 | US | Tennessee | Wilson | 47189 | 5328 | 66 | 0 | 5171 | 36.15496772 | -86.29775884 | 2020-11-07 05:24:52 | Wilson, Tennessee, US |
2191748 | 2191748 | 2020-10-21 | Peru | Apurimac | 5429 | 258 | 0 | 5171 | -14.027713 | -72.975378 | 2020-10-22 04:24:27 | Apurimac, Peru | ||
2514139 | 2514139 | 2020-10-03 | India | Tripura | 26874 | 293 | 21410 | 5171 | 23.746783 | 91.743565 | 2020-10-04 04:23:44 | Tripura, India | ||
2653470 | 2653470 | 2020-09-23 | Afghanistan | 39231 | 1450 | 32610 | 5171 | 33.93911 | 67.709953 | 2020-09-24 04:23:00 | Afghanistan | |||
2837863 | 2837863 | 2020-09-21 | US | Illinois | Winnebago | 17201 | 5320 | 149 | 0 | 5171 | 42.33641854 | -89.16085327 | 2020-09-22 04:23:00 | Winnebago, Illinois, US |
2730785 | 2730785 | 2020-09-15 | US | Mississippi | DeSoto | 28033 | 5224 | 53 | 0 | 5171 | 34.87625235 | -89.99091418 | 2020-09-16 04:22:53 | DeSoto, Mississippi, US |
2728743 | 2728743 | 2020-09-15 | Brazil | Goias | 171120 | 3927 | 161008 | 5171 | -15.827 | -49.8362 | 2020-09-16 04:22:53 | Goias, Brazil | ||
2512657 | 2512657 | 2020-08-27 | US | Ohio | Montgomery | 39113 | 5301 | 130 | 0 | 5171 | 39.75394919 | -84.29050975 | 2020-08-28 04:28:11 | Montgomery, Ohio, US |
371244 | 371244 | 2020-08-08 | Colombia | Cundinamarca | 11626 | 312 | 6143 | 5171 | 5.026 | -74.03 | 2020-08-09 04:34:54 | Cundinamarca, Colombia | ||
2745312 | 2745312 | 2020-07-15 | US | California | Contra Costa | 6013 | 5263 | 90 | 0 | 5171 | 37.91923498 | -121.9289527 | 2020-07-16 04:44:59 | Contra Costa, California, US |
521229 | 521229 | 2020-04-21 | US | Connecticut | New Haven | 9009 | 5493 | 322 | 0 | 5171 | 41.4080325 | -72.93620426 | 2020-04-21 23:30:50 | New Haven, Connecticut, 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]);