johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,065 rows where country_or_region = "Australia" and province_or_state = "Queensland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3007017 | 3007017 | 2021-10-11 | Australia | Queensland | 2067 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-12 04:21:09 | Queensland, Australia | |||
423033 | 423033 | 2021-10-10 | Australia | Queensland | 2063 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-11 04:21:31 | Queensland, Australia | |||
2875890 | 2875890 | 2021-10-09 | Australia | Queensland | 2062 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-10 04:21:38 | Queensland, Australia | |||
2959056 | 2959056 | 2021-10-08 | Australia | Queensland | 2059 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-09 04:21:34 | Queensland, Australia | |||
467094 | 467094 | 2021-10-07 | Australia | Queensland | 2056 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-08 04:21:25 | Queensland, Australia | |||
2458474 | 2458474 | 2021-10-06 | Australia | Queensland | 2056 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-07 04:21:36 | Queensland, Australia | |||
3832168 | 3832168 | 2021-10-05 | Australia | Queensland | 2051 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-06 04:21:33 | Queensland, Australia | |||
986661 | 986661 | 2021-10-04 | Australia | Queensland | 2048 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-05 04:21:27 | Queensland, Australia | |||
1273971 | 1273971 | 2021-10-03 | Australia | Queensland | 2046 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-04 04:21:31 | Queensland, Australia | |||
3927724 | 3927724 | 2021-10-02 | Australia | Queensland | 2043 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-03 04:21:24 | Queensland, Australia | |||
2131704 | 2131704 | 2021-10-01 | Australia | Queensland | 2042 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-02 04:21:25 | Queensland, Australia | |||
2772661 | 2772661 | 2021-09-30 | Australia | Queensland | 2039 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-01 04:21:35 | Queensland, Australia | |||
706117 | 706117 | 2021-09-29 | Australia | Queensland | 2035 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-30 04:21:20 | Queensland, Australia | |||
1333959 | 1333959 | 2021-09-28 | Australia | Queensland | 2029 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-29 04:21:45 | Queensland, Australia | |||
1235328 | 1235328 | 2021-09-27 | Australia | Queensland | 2028 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-28 04:21:28 | Queensland, Australia | |||
2075629 | 2075629 | 2021-09-26 | Australia | Queensland | 2022 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-27 04:21:16 | Queensland, Australia | |||
1724181 | 1724181 | 2021-09-25 | Australia | Queensland | 2022 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-26 04:21:29 | Queensland, Australia | |||
1920901 | 1920901 | 2021-09-24 | Australia | Queensland | 2022 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-25 04:21:31 | Queensland, Australia | |||
601372 | 601372 | 2021-09-23 | Australia | Queensland | 2021 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-24 04:21:44 | Queensland, Australia | |||
3011033 | 3011033 | 2021-09-22 | Australia | Queensland | 2021 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-23 04:21:43 | Queensland, Australia | |||
3757171 | 3757171 | 2021-09-21 | Australia | Queensland | 2019 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-22 04:21:45 | Queensland, Australia | |||
809274 | 809274 | 2021-09-20 | Australia | Queensland | 2018 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-21 04:21:26 | Queensland, Australia | |||
1814473 | 1814473 | 2021-09-19 | Australia | Queensland | 2017 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-20 04:21:22 | Queensland, Australia | |||
16053 | 16053 | 2021-09-18 | Australia | Queensland | 2015 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-19 04:21:34 | Queensland, Australia | |||
2617738 | 2617738 | 2021-09-17 | Australia | Queensland | 2015 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-18 04:21:24 | Queensland, Australia | |||
2808446 | 2808446 | 2021-09-16 | Australia | Queensland | 2014 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-17 04:21:46 | Queensland, Australia | |||
1374191 | 1374191 | 2021-09-15 | Australia | Queensland | 2013 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-16 04:22:19 | Queensland, Australia | |||
2462490 | 2462490 | 2021-09-14 | Australia | Queensland | 2010 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-15 03:22:37 | Queensland, Australia | |||
1385329 | 1385329 | 2021-09-13 | Australia | Queensland | 2009 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-14 04:21:41 | Queensland, Australia | |||
1884698 | 1884698 | 2021-09-12 | Australia | Queensland | 2007 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-13 04:21:15 | Queensland, Australia | |||
3805601 | 3805601 | 2021-09-11 | Australia | Queensland | 2003 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-12 04:21:13 | Queensland, Australia | |||
3448541 | 3448541 | 2021-09-10 | Australia | Queensland | 2002 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-11 04:21:30 | Queensland, Australia | |||
1262487 | 1262487 | 2021-09-09 | Australia | Queensland | 1995 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-10 04:21:20 | Queensland, Australia | |||
2278857 | 2278857 | 2021-09-08 | Australia | Queensland | 1992 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-09 04:21:27 | Queensland, Australia | |||
641636 | 641636 | 2021-09-07 | Australia | Queensland | 1991 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-08 04:21:31 | Queensland, Australia | |||
3193699 | 3193699 | 2021-09-06 | Australia | Queensland | 1991 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-07 04:21:35 | Queensland, Australia | |||
3280567 | 3280567 | 2021-09-05 | Australia | Queensland | 1991 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-06 04:21:22 | Queensland, Australia | |||
248981 | 248981 | 2021-09-04 | Australia | Queensland | 1985 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-05 04:21:33 | Queensland, Australia | |||
3974262 | 3974262 | 2021-09-03 | Australia | Queensland | 1984 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-04 04:21:28 | Queensland, Australia | |||
177724 | 177724 | 2021-09-02 | Australia | Queensland | 1982 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-03 04:21:20 | Queensland, Australia | |||
66759 | 66759 | 2021-09-01 | Australia | Queensland | 1982 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-02 04:21:15 | Queensland, Australia | |||
2067601 | 2067601 | 2021-08-31 | Australia | Queensland | 1980 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-01 04:21:38 | Queensland, Australia | |||
1775055 | 1775055 | 2021-08-30 | Australia | Queensland | 1979 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-31 04:21:46 | Queensland, Australia | |||
3891629 | 3891629 | 2021-08-29 | Australia | Queensland | 1979 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-30 04:21:23 | Queensland, Australia | |||
2792732 | 2792732 | 2021-08-28 | Australia | Queensland | 1977 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-29 04:21:14 | Queensland, Australia | |||
2922891 | 2922891 | 2021-08-27 | Australia | Queensland | 1977 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-28 04:21:28 | Queensland, Australia | |||
1595905 | 1595905 | 2021-08-26 | Australia | Queensland | 1973 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-27 04:21:37 | Queensland, Australia | |||
32114 | 32114 | 2021-08-25 | Australia | Queensland | 1972 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-26 04:21:28 | Queensland, Australia | |||
3105153 | 3105153 | 2021-08-24 | Australia | Queensland | 1972 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-25 04:21:41 | Queensland, Australia | |||
3165324 | 3165324 | 2021-08-23 | Australia | Queensland | 1972 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-24 04:21:19 | Queensland, Australia | |||
2175251 | 2175251 | 2021-08-22 | Australia | Queensland | 1966 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-23 04:21:27 | Queensland, Australia | |||
3555347 | 3555347 | 2021-08-21 | Australia | Queensland | 1964 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-22 04:21:29 | Queensland, Australia | |||
1853689 | 1853689 | 2021-08-20 | Australia | Queensland | 1964 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-21 04:21:38 | Queensland, Australia | |||
511396 | 511396 | 2021-08-19 | Australia | Queensland | 1962 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-20 04:21:33 | Queensland, Australia | |||
2517875 | 2517875 | 2021-08-18 | Australia | Queensland | 1961 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-19 04:21:15 | Queensland, Australia | |||
244967 | 244967 | 2021-08-17 | Australia | Queensland | 1961 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-18 04:21:35 | Queensland, Australia | |||
1603930 | 1603930 | 2021-08-16 | Australia | Queensland | 1957 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-17 04:21:49 | Queensland, Australia | |||
103024 | 103024 | 2021-08-15 | Australia | Queensland | 1955 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-16 04:21:31 | Queensland, Australia | |||
507382 | 507382 | 2021-08-14 | Australia | Queensland | 1956 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-15 04:21:41 | Queensland, Australia | |||
1483254 | 1483254 | 2021-08-13 | Australia | Queensland | 1955 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-14 04:21:25 | Queensland, Australia | |||
2899384 | 2899384 | 2021-08-12 | Australia | Queensland | 1948 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-13 04:21:24 | Queensland, Australia | |||
1341988 | 1341988 | 2021-08-11 | Australia | Queensland | 1940 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-12 04:21:25 | Queensland, Australia | |||
2351135 | 2351135 | 2021-08-10 | Australia | Queensland | 1929 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-11 04:21:58 | Queensland, Australia | |||
649664 | 649664 | 2021-08-09 | Australia | Queensland | 1926 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-10 04:21:27 | Queensland, Australia | |||
589326 | 589326 | 2021-08-08 | Australia | Queensland | 1923 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-09 04:21:24 | Queensland, Australia | |||
2203338 | 2203338 | 2021-08-07 | Australia | Queensland | 1918 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-08 04:21:33 | Queensland, Australia | |||
1117288 | 1117288 | 2021-08-06 | Australia | Queensland | 1909 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-07 04:21:30 | Queensland, Australia | |||
1956225 | 1956225 | 2021-08-05 | Australia | Queensland | 1896 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-06 04:21:18 | Queensland, Australia | |||
331604 | 331604 | 2021-08-04 | Australia | Queensland | 1886 | 7 | 1727 | 152 | -27.4698 | 153.0251 | 2021-08-05 04:21:51 | Queensland, Australia | ||
3467875 | 3467875 | 2021-08-03 | Australia | Queensland | 1859 | 7 | 1727 | 125 | -27.4698 | 153.0251 | 2021-08-04 04:21:25 | Queensland, Australia | ||
3683149 | 3683149 | 2021-08-02 | Australia | Queensland | 1840 | 7 | 1727 | 106 | -27.4698 | 153.0251 | 2021-08-03 04:21:39 | Queensland, Australia | ||
3015048 | 3015048 | 2021-08-01 | Australia | Queensland | 1824 | 7 | 1727 | 90 | -27.4698 | 153.0251 | 2021-08-02 04:21:36 | Queensland, Australia | ||
3903671 | 3903671 | 2021-07-31 | Australia | Queensland | 1809 | 7 | 1725 | 77 | -27.4698 | 153.0251 | 2021-08-01 04:21:50 | Queensland, Australia | ||
3295876 | 3295876 | 2021-07-30 | Australia | Queensland | 1800 | 7 | 1720 | 73 | -27.4698 | 153.0251 | 2021-07-31 04:21:35 | Queensland, Australia | ||
3385087 | 3385087 | 2021-07-29 | Australia | Queensland | 1793 | 7 | 1720 | 66 | -27.4698 | 153.0251 | 2021-07-30 04:21:34 | Queensland, Australia | ||
407992 | 407992 | 2021-07-28 | Australia | Queensland | 1791 | 7 | 1717 | 67 | -27.4698 | 153.0251 | 2021-07-29 04:21:33 | Queensland, Australia | ||
1305853 | 1305853 | 2021-07-27 | Australia | Queensland | 1790 | 7 | 1717 | 66 | -27.4698 | 153.0251 | 2021-07-28 04:21:39 | Queensland, Australia | ||
3217996 | 3217996 | 2021-07-26 | Australia | Queensland | 1770 | 7 | 1715 | 48 | -27.4698 | 153.0251 | 2021-07-27 04:21:18 | Queensland, Australia | ||
1378205 | 1378205 | 2021-07-25 | Australia | Queensland | 1771 | 7 | 1715 | 49 | -27.4698 | 153.0251 | 2021-07-26 04:21:28 | Queensland, Australia | ||
1329945 | 1329945 | 2021-07-24 | Australia | Queensland | 1770 | 7 | 1715 | 48 | -27.4698 | 153.0251 | 2021-07-25 04:22:12 | Queensland, Australia | ||
3137249 | 3137249 | 2021-07-23 | Australia | Queensland | 1763 | 7 | 1707 | 49 | -27.4698 | 153.0251 | 2021-07-24 00:21:36 | Queensland, Australia | ||
3476009 | 3476009 | 2021-07-22 | Australia | Queensland | 1764 | 7 | 1707 | 50 | -27.4698 | 153.0251 | 2021-07-23 04:21:29 | Queensland, Australia | ||
3331228 | 3331228 | 2021-07-21 | Australia | Queensland | 1761 | 7 | 1701 | 53 | -27.4698 | 153.0251 | 2021-07-22 04:21:19 | Queensland, Australia | ||
2371209 | 2371209 | 2021-07-20 | Australia | Queensland | 1761 | 7 | 1701 | 53 | -27.4698 | 153.0251 | 2021-07-21 04:21:40 | Queensland, Australia | ||
483288 | 483288 | 2021-07-19 | Australia | Queensland | 1761 | 7 | 1698 | 56 | -27.4698 | 153.0251 | 2021-07-20 04:21:48 | Queensland, Australia | ||
2673511 | 2673511 | 2021-07-18 | Australia | Queensland | 1757 | 7 | 1686 | 64 | -27.4698 | 153.0251 | 2021-07-19 04:21:24 | Queensland, Australia | ||
3705823 | 3705823 | 2021-07-17 | Australia | Queensland | 1755 | 7 | 1685 | 63 | -27.4698 | 153.0251 | 2021-07-18 04:22:07 | Queensland, Australia | ||
2947054 | 2947054 | 2021-07-16 | Australia | Queensland | 1754 | 7 | 1685 | 62 | -27.4698 | 153.0251 | 2021-07-17 04:22:22 | Queensland, Australia | ||
295710 | 295710 | 2021-07-15 | Australia | Queensland | 1753 | 7 | 1679 | 67 | -27.4698 | 153.0251 | 2021-07-16 04:21:22 | Queensland, Australia | ||
3631655 | 3631655 | 2021-07-14 | Australia | Queensland | 1752 | 7 | 1679 | 66 | -27.4698 | 153.0251 | 2021-07-15 04:21:48 | Queensland, Australia | ||
578530 | 578530 | 2021-07-13 | Australia | Queensland | 1747 | 7 | 1675 | 65 | -27.4698 | 153.0251 | 2021-07-14 04:21:35 | Queensland, Australia | ||
3740779 | 3740779 | 2021-07-12 | Australia | Queensland | 1742 | 7 | 1670 | 65 | -27.4698 | 153.0251 | 2021-07-13 04:21:18 | Queensland, Australia | ||
3659292 | 3659292 | 2021-07-11 | Australia | Queensland | 1739 | 7 | 1670 | 62 | -27.4698 | 153.0251 | 2021-07-12 04:21:34 | Queensland, Australia | ||
625576 | 625576 | 2021-07-10 | Australia | Queensland | 1738 | 7 | 1641 | 90 | -27.4698 | 153.0251 | 2021-07-11 04:21:43 | Queensland, Australia | ||
829295 | 829295 | 2021-07-09 | Australia | Queensland | 1737 | 7 | 1641 | 89 | -27.4698 | 153.0251 | 2021-07-10 04:21:25 | Queensland, Australia | ||
778059 | 778059 | 2021-07-08 | Australia | Queensland | 1732 | 7 | 1641 | 84 | -27.4698 | 153.0251 | 2021-07-09 04:21:21 | Queensland, Australia | ||
1440281 | 1440281 | 2021-07-07 | Australia | Queensland | 1732 | 7 | 1641 | 84 | -27.4698 | 153.0251 | 2021-07-08 04:21:26 | Queensland, Australia | ||
2693386 | 2693386 | 2021-07-06 | Australia | Queensland | 1729 | 7 | 1641 | 81 | -27.4698 | 153.0251 | 2021-07-07 04:21:20 | Queensland, Australia | ||
1932135 | 1932135 | 2021-07-05 | Australia | Queensland | 1728 | 7 | 1641 | 80 | -27.4698 | 153.0251 | 2021-07-06 04:21:32 | Queensland, Australia | ||
1164866 | 1164866 | 2021-07-04 | Australia | Queensland | 1723 | 7 | 1641 | 75 | -27.4698 | 153.0251 | 2021-07-05 04:21:28 | Queensland, Australia |
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]);