johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "Ireland" and recovered = 22698 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
country_or_region 1
- Ireland · 21 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1522757 | 1522757 | 2020-06-23 | Ireland | 25391 | 1720 | 22698 | 973 | 53.1424 | -7.6921 | 2020-06-24 04:33:28 | Ireland | |||
1510951 | 1510951 | 2020-06-22 | Ireland | 25383 | 1717 | 22698 | 968 | 53.1424 | -7.6921 | 2020-06-23 04:33:22 | Ireland | |||
3249690 | 3249690 | 2020-06-21 | Ireland | 25379 | 1715 | 22698 | 966 | 53.1424 | -7.6921 | 2020-06-22 04:33:20 | Ireland | |||
2438283 | 2438283 | 2020-06-20 | Ireland | 25374 | 1715 | 22698 | 961 | 53.1424 | -7.6921 | 2020-06-21 04:33:19 | Ireland | |||
1691861 | 1691861 | 2020-06-19 | Ireland | 25368 | 1714 | 22698 | 956 | 53.1424 | -7.6921 | 2020-06-20 04:33:19 | Ireland | |||
3683010 | 3683010 | 2020-06-18 | Ireland | 25355 | 1714 | 22698 | 943 | 53.1424 | -7.6921 | 2020-06-19 04:33:17 | Ireland | |||
1196213 | 1196213 | 2020-06-17 | Ireland | 25341 | 1710 | 22698 | 933 | 53.1424 | -7.6921 | 2020-06-18 04:33:18 | Ireland | |||
2386976 | 2386976 | 2020-06-16 | Ireland | 25334 | 1709 | 22698 | 927 | 53.1424 | -7.6921 | 2020-06-17 04:33:21 | Ireland | |||
287539 | 287539 | 2020-06-15 | Ireland | 25321 | 1706 | 22698 | 917 | 53.1424 | -7.6921 | 2020-06-16 04:33:09 | Ireland | |||
1837490 | 1837490 | 2020-06-14 | Ireland | 25303 | 1706 | 22698 | 899 | 53.1424 | -7.6921 | 2020-06-15 03:33:14 | Ireland | |||
3061542 | 3061542 | 2020-06-13 | Ireland | 25295 | 1705 | 22698 | 892 | 53.1424 | -7.6921 | 2020-06-14 03:33:15 | Ireland | |||
737862 | 737862 | 2020-06-12 | Ireland | 25250 | 1705 | 22698 | 847 | 53.1424 | -7.6921 | 2020-06-13 03:33:14 | Ireland | |||
1273832 | 1273832 | 2020-06-11 | Ireland | 25238 | 1703 | 22698 | 837 | 53.1424 | -7.6921 | 2020-06-12 05:09:52 | Ireland | |||
2864271 | 2864271 | 2020-06-10 | Ireland | 25231 | 1695 | 22698 | 838 | 53.1424 | -7.6921 | 2020-06-11 03:33:41 | Ireland | |||
1211089 | 1211089 | 2020-06-09 | Ireland | 25215 | 1691 | 22698 | 826 | 53.1424 | -7.6921 | 2020-06-10 04:07:00 | Ireland | |||
217516 | 217516 | 2020-06-08 | Ireland | 25207 | 1683 | 22698 | 826 | 53.1424 | -7.6921 | 2020-06-09 03:33:03 | Ireland | |||
2800313 | 2800313 | 2020-06-07 | Ireland | 25201 | 1679 | 22698 | 824 | 53.1424 | -7.6921 | 2020-06-08 03:33:22 | Ireland | |||
574369 | 574369 | 2020-06-06 | Ireland | 25183 | 1678 | 22698 | 807 | 53.1424 | -7.6921 | 2020-06-07 03:53:30 | Ireland | |||
1270066 | 1270066 | 2020-06-05 | Ireland | 25163 | 1670 | 22698 | 795 | 53.1424 | -7.6921 | 2020-06-06 02:33:00 | Ireland | |||
1281526 | 1281526 | 2020-06-04 | Ireland | 25142 | 1664 | 22698 | 780 | 53.1424 | -7.6921 | 2020-06-05 02:33:06 | Ireland | |||
3867081 | 3867081 | 2020-06-03 | Ireland | 25111 | 1659 | 22698 | 754 | 53.1424 | -7.6921 | 2020-06-04 02:33:14 | Ireland |
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]);