johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 6977 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
578581 | 578581 | 2021-07-13 | Brazil | Rondonia | 252839 | 6287 | 239575 | 6977 | -11.5057 | -63.5806 | 2021-07-14 04:21:35 | Rondonia, Brazil | ||
3740958 | 3740958 | 2021-07-12 | Denmark | 300071 | 2539 | 290555 | 6977 | 56.2639 | 9.5018 | 2021-07-13 04:21:18 | Denmark | |||
1932360 | 1932360 | 2021-07-05 | Germany | Unknown | 6977 | 0 | 0 | 6977 | 2021-07-06 04:21:32 | Unknown, Germany | ||||
1129271 | 1129271 | 2021-06-18 | Malaysia | Negeri Sembilan | 37065 | 253 | 29835 | 6977 | 2.7258 | 101.9424 | 2021-06-19 04:22:33 | Negeri Sembilan, Malaysia | ||
982869 | 982869 | 2021-04-17 | Germany | Sachsen-Anhalt | 82455 | 2909 | 73210 | 6977 | 51.9503 | 11.6923 | 2021-04-18 04:20:41 | Sachsen-Anhalt, Germany | ||
1687551 | 1687551 | 2021-02-02 | US | Texas | Coryell | 48099 | 8553 | 57 | 0 | 6977 | 31.39078397 | -97.79936155 | 2021-02-03 05:22:52 | Coryell, Texas, US |
3881861 | 3881861 | 2021-01-14 | US | North Carolina | Caldwell | 37027 | 7008 | 31 | 0 | 6977 | 35.95204977 | -81.54799522 | 2021-01-15 05:22:24 | Caldwell, North Carolina, US |
3037393 | 3037393 | 2021-01-05 | US | Texas | Gregg | 48183 | 5264 | 174 | 0 | 6977 | 32.47940482 | -94.81591935 | 2021-01-06 05:22:16 | Gregg, Texas, US |
3772116 | 3772116 | 2020-12-22 | US | New York | Niagara | 36063 | 7137 | 160 | 0 | 6977 | 43.19898042 | -78.74777412 | 2020-12-23 05:22:03 | Niagara, New York, US |
3771237 | 3771237 | 2020-12-22 | US | Kentucky | Boone | 21015 | 7012 | 35 | 0 | 6977 | 38.97065142 | -84.72615357 | 2020-12-23 05:22:03 | Boone, Kentucky, US |
847140 | 847140 | 2020-12-12 | US | Maryland | Harford | 24025 | 7096 | 119 | 0 | 6977 | 39.55010644 | -76.30775940000002 | 2020-12-13 05:27:20 | Harford, Maryland, US |
210786 | 210786 | 2020-10-29 | US | California | Marin | 6041 | 7103 | 125 | 0 | 6977 | 38.07122463 | -122.7210631 | 2020-10-30 04:24:49 | Marin, California, US |
2291613 | 2291613 | 2020-10-12 | Peru | Tumbes | 7648 | 671 | 0 | 6977 | -3.857496 | -80.54525500000003 | 2020-10-13 04:24:02 | Tumbes, Peru | ||
1825419 | 1825419 | 2020-10-04 | US | Pennsylvania | Berks | 42011 | 7376 | 399 | 0 | 6977 | 40.41570541 | -75.92457766 | 2020-10-05 04:23:33 | Berks, Pennsylvania, US |
1824167 | 1824167 | 2020-10-04 | US | Kentucky | Fayette | 21067 | 7054 | 77 | 0 | 6977 | 38.0368225 | -84.45576892 | 2020-10-05 04:23:33 | Fayette, Kentucky, US |
1524095 | 1524095 | 2020-08-28 | US | Idaho | Canyon | 16027 | 7051 | 74 | 0 | 6977 | 43.61970148 | -116.7095499 | 2020-08-29 04:28:19 | Canyon, Idaho, US |
3534677 | 3534677 | 2020-08-12 | US | Texas | Williamson | 48491 | 6671 | 98 | 0 | 6977 | 30.64655664 | -97.6004854 | 2020-08-13 04:29:15 | Williamson, Texas, US |
121665 | 121665 | 2020-07-19 | Brazil | Acre | 17295 | 460 | 9858 | 6977 | -9.0238 | -70.812 | 2020-07-20 05:34:40 | Acre, Brazil | ||
3637681 | 3637681 | 2020-05-30 | US | California | Orange | 6059 | 7123 | 146 | 0 | 6977 | 33.70147516 | -117.76459979999998 | 2020-05-31 02:32:45 | Orange, California, US |
522449 | 522449 | 2020-04-21 | Norway | 7191 | 182 | 32 | 6977 | 60.472 | 8.4689 | 2020-04-21 23:30:30 | Norway |
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]);