johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where active = 5101 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487266 | 487266 | 2021-07-19 | Malaysia | Melaka | 25521 | 255 | 20165 | 5101 | 2.1896 | 102.2501 | 2021-07-20 04:21:48 | Melaka, Malaysia | ||
1893121 | 1893121 | 2021-06-30 | Italy | Calabria | 68962 | 1226 | 62635 | 5101 | 38.90597598 | 16.59440194 | 2021-07-01 04:21:19 | Calabria, Italy | ||
1081788 | 1081788 | 2021-05-14 | Colombia | Valle del Cauca | 250311 | 7843 | 237367 | 5101 | 3.8009 | -76.6413 | 2021-05-15 04:20:58 | Valle del Cauca, Colombia | ||
3369516 | 3369516 | 2021-03-21 | Russia | Bashkortostan Republic | 31265 | 333 | 25831 | 5101 | 54.8573563 | 57.1439682 | 2021-03-22 05:25:43 | Bashkortostan Republic, Russia | ||
1744726 | 1744726 | 2021-03-20 | Russia | Bashkortostan Republic | 31149 | 331 | 25717 | 5101 | 54.8573563 | 57.1439682 | 2021-03-21 05:25:44 | Bashkortostan Republic, Russia | ||
3255599 | 3255599 | 2021-03-02 | US | Kentucky | Pike | 21195 | 5161 | 60 | 0 | 5101 | 37.47088263 | -82.39487445 | 2021-03-03 05:23:28 | Pike, Kentucky, US |
1861299 | 1861299 | 2021-02-25 | US | Virginia | Augusta | 51015 | 5156 | 55 | 0 | 5101 | 38.16404586 | -79.12461614 | 2021-02-26 05:22:40 | Augusta, Virginia, US |
1936147 | 1936147 | 2021-02-23 | Australia | New South Wales | 5155 | 54 | 0 | 5101 | -33.8688 | 151.2093 | 2021-02-24 05:29:16 | New South Wales, Australia | ||
1899698 | 1899698 | 2021-01-29 | US | Oklahoma | Grady | 40051 | 5158 | 57 | 0 | 5101 | 35.0167709 | -97.88339847 | 2021-01-30 05:22:49 | Grady, Oklahoma, US |
1761543 | 1761543 | 2021-01-24 | US | New York | Oswego | 36075 | 5176 | 75 | 0 | 5101 | 43.42778894 | -76.14635194 | 2021-01-25 05:22:16 | Oswego, New York, US |
2626058 | 2626058 | 2021-01-10 | Russia | Bashkortostan Republic | 20736 | 155 | 15480 | 5101 | 54.8573563 | 57.1439682 | 2021-01-11 05:21:50 | Bashkortostan Republic, Russia | ||
2231032 | 2231032 | 2021-01-02 | US | West Virginia | Wood | 54107 | 5146 | 45 | 0 | 5101 | 39.20967886 | -81.5162836 | 2021-01-03 05:22:52 | Wood, West Virginia, US |
1036657 | 1036657 | 2020-12-15 | US | North Carolina | Burke | 37023 | 5172 | 71 | 0 | 5101 | 35.74989637 | -81.70755735 | 2020-12-16 05:28:04 | Burke, North Carolina, US |
3569046 | 3569046 | 2020-11-29 | US | Ohio | Medina | 39103 | 5180 | 79 | 0 | 5101 | 41.11770589 | -81.89986209999998 | 2020-11-30 05:26:13 | Medina, Ohio, US |
2922179 | 2922179 | 2020-11-04 | US | Tennessee | Wilson | 47189 | 5195 | 65 | 0 | 5101 | 36.15496772 | -86.29775884 | 2020-11-05 06:05:03 | Wilson, Tennessee, US |
79253 | 79253 | 2020-10-14 | Peru | Pasco | 5376 | 275 | 0 | 5101 | -10.39655 | -75.307635 | 2020-10-15 04:24:28 | Pasco, Peru | ||
3782068 | 3782068 | 2020-10-13 | Peru | Pasco | 5376 | 275 | 0 | 5101 | -10.39655 | -75.307635 | 2020-10-14 04:24:05 | Pasco, Peru | ||
3390147 | 3390147 | 2020-10-02 | US | Georgia | Clarke | 13059 | 5145 | 44 | 0 | 5101 | 33.95436462 | -83.37124007 | 2020-10-03 04:23:40 | Clarke, Georgia, US |
2849840 | 2849840 | 2020-09-18 | US | Illinois | Madison | 17119 | 5231 | 130 | 0 | 5101 | 38.83042506 | -89.90422563 | 2020-09-19 04:22:00 | Madison, Illinois, US |
2870496 | 2870496 | 2020-09-13 | US | Mississippi | DeSoto | 28033 | 5154 | 53 | 0 | 5101 | 34.87625235 | -89.99091418 | 2020-09-14 04:26:00 | DeSoto, Mississippi, US |
3178175 | 3178175 | 2020-08-18 | Peru | Puno | 5841 | 740 | 0 | 5101 | -14.995827 | -69.922726 | 2020-08-19 04:27:00 | Puno, Peru | ||
300676 | 300676 | 2020-07-01 | US | California | Fresno | 6019 | 5191 | 76 | 0 | 5101 | 36.75733899 | -119.6466953 | 2020-07-02 04:33:46 | Fresno, California, 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]);