johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where active = 4682 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1736520 | 1736520 | 2021-06-12 | Japan | Hokkaido | 40390 | 1284 | 34424 | 4682 | 43.385711 | 142.552318 | 2021-06-13 04:22:44 | Hokkaido, Japan | ||
20205 | 20205 | 2021-05-28 | Colombia | Atlantico | 270192 | 8386 | 257124 | 4682 | 10.6966 | -74.8741 | 2021-05-29 04:20:41 | Atlantico, Colombia | ||
3420839 | 3420839 | 2021-03-19 | Germany | Sachsen-Anhalt | 66712 | 2619 | 60078 | 4682 | 51.9503 | 11.6923 | 2021-03-20 05:25:46 | Sachsen-Anhalt, Germany | ||
1617922 | 1617922 | 2021-03-05 | US | Michigan | St. Joseph | 26149 | 4767 | 85 | 0 | 4682 | 41.91441767 | -85.52797979 | 2021-03-06 04:23:41 | St. Joseph, Michigan, US |
2369760 | 2369760 | 2021-02-28 | US | New York | Sullivan | 36105 | 4741 | 59 | 0 | 4682 | 41.71579493 | -74.76394559 | 2021-03-01 05:23:01 | Sullivan, New York, US |
743840 | 743840 | 2021-02-20 | US | Louisiana | St. Martin | 22099 | 4792 | 110 | 0 | 4682 | 30.13112107 | -91.61403569 | 2021-02-21 05:24:33 | St. Martin, Louisiana, US |
472938 | 472938 | 2021-02-19 | US | Louisiana | St. Martin | 22099 | 4792 | 110 | 0 | 4682 | 30.13112107 | -91.61403569 | 2021-02-20 05:22:51 | St. Martin, Louisiana, US |
2680463 | 2680463 | 2021-02-13 | US | Pennsylvania | Armstrong | 42005 | 4797 | 115 | 0 | 4682 | 40.81665618 | -79.46290811 | 2021-02-14 05:23:43 | Armstrong, Pennsylvania, US |
2484528 | 2484528 | 2021-01-28 | US | Oklahoma | Le Flore | 40079 | 4721 | 39 | 0 | 4682 | 34.89851864 | -94.70392124 | 2021-01-29 05:22:23 | Le Flore, Oklahoma, US |
237925 | 237925 | 2021-01-18 | US | Florida | Flagler | 12035 | 4735 | 53 | 0 | 4682 | 29.45933576 | -81.31508595 | 2021-01-19 05:22:15 | Flagler, Florida, US |
3103844 | 3103844 | 2021-01-16 | US | North Dakota | Morton | 38059 | 4732 | 92 | 0 | 4682 | 46.71681782 | -101.2822377 | 2021-01-17 05:22:17 | Morton, North Dakota, US |
2544923 | 2544923 | 2021-01-07 | US | Wisconsin | Barron | 55005 | 4740 | 58 | 0 | 4682 | 45.42372701 | -91.84833627 | 2021-01-08 05:22:42 | Barron, Wisconsin, US |
3035001 | 3035001 | 2021-01-05 | US | Florida | Jackson | 12063 | 4802 | 120 | 0 | 4682 | 30.7954597 | -85.21500423 | 2021-01-06 05:22:16 | Jackson, Florida, US |
2231089 | 2231089 | 2021-01-02 | US | Wisconsin | Sauk | 55111 | 4713 | 31 | 0 | 4682 | 43.42574087 | -89.94966132 | 2021-01-03 05:22:52 | Sauk, Wisconsin, US |
1140453 | 1140453 | 2021-01-01 | US | Wisconsin | Sauk | 55111 | 4713 | 31 | 0 | 4682 | 43.42574087 | -89.94966132 | 2021-01-02 05:22:33 | Sauk, Wisconsin, US |
3850301 | 3850301 | 2020-12-13 | US | Ohio | Wayne | 39169 | 4809 | 127 | 0 | 4682 | 40.82925852 | -81.88844833 | 2020-12-14 05:26:27 | Wayne, Ohio, US |
1599998 | 1599998 | 2020-12-10 | Canada | Saskatchewan | 11222 | 75 | 6466 | 4682 | 52.9399 | -106.4509 | 2020-12-11 05:26:59 | Saskatchewan, Canada | ||
2977511 | 2977511 | 2020-12-09 | US | North Carolina | Burke | 37023 | 4750 | 68 | 0 | 4682 | 35.74989637 | -81.70755735 | 2020-12-10 05:26:19 | Burke, North Carolina, US |
2350110 | 2350110 | 2020-12-07 | US | Pennsylvania | Schuylkill | 42107 | 4878 | 196 | 0 | 4682 | 40.70497338 | -76.2150785 | 2020-12-08 05:27:42 | Schuylkill, Pennsylvania, US |
2537150 | 2537150 | 2020-12-01 | Brazil | Sergipe | 90386 | 2312 | 83392 | 4682 | -10.5741 | -37.3857 | 2020-12-02 05:27:41 | Sergipe, Brazil | ||
2935441 | 2935441 | 2020-11-28 | Russia | Khanty-Mansi Autonomous Okrug | 33900 | 398 | 28820 | 4682 | 61.0259025 | 69.0982628 | 2020-11-29 05:25:55 | Khanty-Mansi Autonomous Okrug, Russia | ||
923653 | 923653 | 2020-11-26 | India | Uttarakhand | 72997 | 1196 | 67119 | 4682 | 30.156447 | 79.197608 | 2020-11-27 05:26:53 | Uttarakhand, India | ||
2703810 | 2703810 | 2020-11-20 | US | North Carolina | Davidson | 37057 | 4730 | 48 | 0 | 4682 | 35.79115496 | -80.21256572 | 2020-11-21 05:25:51 | Davidson, North Carolina, US |
3170635 | 3170635 | 2020-11-16 | US | Illinois | LaSalle | 17099 | 4775 | 93 | 0 | 4682 | 41.34426129999999 | -88.88633881 | 2020-11-17 05:25:54 | LaSalle, Illinois, US |
1453377 | 1453377 | 2020-10-27 | US | Georgia | Forsyth | 13117 | 4735 | 53 | 0 | 4682 | 34.22604035 | -84.12315129999998 | 2020-10-28 04:24:39 | Forsyth, Georgia, US |
3483880 | 3483880 | 2020-10-26 | US | Wisconsin | Sheboygan | 55117 | 4706 | 24 | 0 | 4682 | 43.72099677 | -87.94579284 | 2020-10-27 04:24:45 | Sheboygan, Wisconsin, US |
3480375 | 3480375 | 2020-10-26 | Luxembourg | 14399 | 147 | 9570 | 4682 | 49.8153 | 6.1296 | 2020-10-27 04:24:45 | Luxembourg | |||
2194759 | 2194759 | 2020-10-21 | US | Texas | Midland | 48329 | 3741 | 89 | 0 | 4682 | 31.86904128 | -102.0315682 | 2020-10-22 04:24:27 | Midland, Texas, US |
2291437 | 2291437 | 2020-10-12 | Italy | Sicilia | 9592 | 339 | 4571 | 4682 | 38.11569725 | 13.362356699999998 | 2020-10-13 04:24:02 | Sicilia, Italy | ||
2602621 | 2602621 | 2020-10-10 | US | Colorado | Boulder | 8013 | 5007 | 77 | 0 | 4682 | 40.09313619 | -105.3546767 | 2020-10-11 04:23:46 | Boulder, Colorado, US |
2581964 | 2581964 | 2020-09-27 | Italy | Emilia-Romagna | 35028 | 4482 | 25864 | 4682 | 44.49436681 | 11.3417208 | 2020-09-28 04:23:00 | Emilia-Romagna, Italy | ||
2609206 | 2609206 | 2020-09-24 | US | Texas | Potter | 48375 | 4506 | 63 | 0 | 4682 | 35.40133773 | -101.893964 | 2020-09-25 04:23:00 | Potter, Texas, US |
667036 | 667036 | 2020-09-16 | US | Georgia | Clarke | 13059 | 4719 | 37 | 0 | 4682 | 33.95436462 | -83.37124007 | 2020-09-17 04:22:00 | Clarke, Georgia, US |
609743 | 609743 | 2020-08-29 | Kyrgyzstan | 43712 | 1057 | 37973 | 4682 | 41.20438 | 74.766098 | 2020-08-30 04:28:22 | Kyrgyzstan | |||
1483062 | 1483062 | 2020-08-21 | US | Wisconsin | Brown | 55009 | 4739 | 57 | 0 | 4682 | 44.4526553 | -88.00411844 | 2020-08-22 04:27:49 | Brown, Wisconsin, US |
1918976 | 1918976 | 2020-08-10 | US | Georgia | Muscogee | 13215 | 4780 | 98 | 0 | 4682 | 32.50931999 | -84.87142262 | 2020-08-11 04:35:08 | Muscogee, Georgia, US |
1429627 | 1429627 | 2020-05-20 | US | New York | Erie | 36029 | 5131 | 449 | 0 | 4682 | 42.76249024 | -78.73063652 | 2020-05-21 02:32:48 | Erie, New York, 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]);