daily_reports (view)
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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-09 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
2022-05-13 | Australia | Queensland | 1080068 | 938 | 0 | -27.4698 | 153.0251 | 2022-05-14 04:20:48 | Queensland, Australia | |||
2022-07-21 | Australia | Queensland | 1435080 | 1462 | 0 | -27.4698 | 153.0251 | 2022-07-22 04:21:15 | Queensland, Australia | |||
2022-07-30 | Australia | Queensland | 1512891 | 1567 | 0 | -27.4698 | 153.0251 | 2022-07-31 04:21:02 | Queensland, Australia | |||
2021-10-24 | Australia | Queensland | 2082 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-25 04:22:31 | Queensland, Australia | |||
2021-11-13 | Australia | Queensland | 2106 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-14 04:21:31 | Queensland, Australia | |||
2022-12-23 | Australia | Queensland | 1743616 | 2405 | 0 | -27.4698 | 153.0251 | 2022-12-24 04:21:02 | Queensland, Australia | |||
2022-03-17 | Australia | Queensland | 653383 | 673 | 0 | -27.4698 | 153.0251 | 2022-03-18 04:20:55 | Queensland, Australia | |||
2021-11-04 | Australia | Queensland | 2094 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-05 04:21:54 | Queensland, Australia | |||
2021-09-29 | Australia | Queensland | 2035 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-30 04:21:20 | Queensland, Australia | |||
2022-11-01 | Australia | Queensland | 1664371 | 2274 | 0 | -27.4698 | 153.0251 | 2022-11-02 04:22:09 | Queensland, Australia | |||
2021-11-12 | Australia | Queensland | 2106 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-13 04:21:38 | Queensland, Australia | |||
2022-12-04 | Australia | Queensland | 1702314 | 2346 | 0 | -27.4698 | 153.0251 | 2022-12-05 04:20:58 | Queensland, Australia | |||
2021-11-20 | Australia | Queensland | 2112 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-21 04:22:13 | Queensland, Australia | |||
2021-12-27 | Australia | Queensland | 6961 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-28 04:21:47 | Queensland, Australia | |||
2022-04-23 | Australia | Queensland | 957675 | 838 | 0 | -27.4698 | 153.0251 | 2022-04-24 04:20:56 | Queensland, Australia | |||
2021-11-26 | Australia | Queensland | 2117 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-27 04:22:45 | Queensland, Australia | |||
2021-10-23 | Australia | Queensland | 2082 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-24 04:21:22 | Queensland, Australia | |||
2021-12-13 | Australia | Queensland | 2180 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-14 04:22:38 | Queensland, Australia | |||
2022-10-24 | Australia | Queensland | 1660208 | 2256 | 0 | -27.4698 | 153.0251 | 2022-10-25 04:21:53 | Queensland, Australia | |||
2021-12-22 | Australia | Queensland | 2977 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-23 04:21:21 | Queensland, Australia | |||
2021-09-20 | Australia | Queensland | 2018 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-21 04:21:26 | Queensland, Australia | |||
2022-12-02 | Australia | Queensland | 1702314 | 2346 | 0 | -27.4698 | 153.0251 | 2022-12-03 04:21:02 | Queensland, Australia | |||
2022-11-02 | Australia | Queensland | 1664371 | 2274 | 0 | -27.4698 | 153.0251 | 2022-11-03 04:22:05 | Queensland, Australia | |||
2022-09-30 | Australia | Queensland | 1641389 | 2239 | 0 | -27.4698 | 153.0251 | 2022-10-01 04:23:01 | Queensland, Australia | |||
2022-12-11 | Australia | Queensland | 1714583 | 2361 | 0 | -27.4698 | 153.0251 | 2022-12-12 04:21:01 | Queensland, Australia | |||
2022-03-27 | Australia | Queensland | 737136 | 718 | 0 | -27.4698 | 153.0251 | 2022-03-28 04:20:33 | Queensland, Australia | |||
2022-08-05 | Australia | Queensland | 1549389 | 1653 | 0 | -27.4698 | 153.0251 | 2022-08-06 04:20:56 | Queensland, Australia | |||
2022-07-24 | Australia | Queensland | 1454617 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-25 04:20:51 | Queensland, Australia | |||
2022-07-22 | Australia | Queensland | 1442714 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-23 04:20:53 | Queensland, Australia | |||
2021-11-24 | Australia | Queensland | 2117 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-25 04:22:33 | Queensland, Australia | |||
2022-10-29 | Australia | Queensland | 1664371 | 2274 | 0 | -27.4698 | 153.0251 | 2022-10-30 04:22:14 | Queensland, Australia | |||
2022-03-08 | Australia | Queensland | 608063 | 610 | 0 | -27.4698 | 153.0251 | 2022-03-09 04:20:59 | Queensland, Australia | |||
2021-10-16 | Australia | Queensland | 2071 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-17 04:21:29 | Queensland, Australia | |||
2022-06-25 | Australia | Queensland | 1277471 | 1199 | 0 | -27.4698 | 153.0251 | 2022-06-26 04:21:02 | Queensland, Australia | |||
2022-02-28 | Australia | Queensland | 571258 | 540 | 0 | -27.4698 | 153.0251 | 2022-03-01 04:21:09 | Queensland, Australia | |||
2022-06-14 | Australia | Queensland | 1232417 | 1139 | 0 | -27.4698 | 153.0251 | 2022-06-15 04:20:54 | Queensland, Australia | |||
2022-03-12 | Australia | Queensland | 624608 | 632 | 0 | -27.4698 | 153.0251 | 2022-03-13 04:20:49 | Queensland, Australia | |||
2022-07-19 | Australia | Queensland | 1414382 | 1442 | 0 | -27.4698 | 153.0251 | 2022-07-20 04:20:59 | Queensland, Australia | |||
2022-09-09 | Australia | Queensland | 1620034 | 2048 | 0 | -27.4698 | 153.0251 | 2022-09-10 04:21:10 | Queensland, Australia | |||
2022-06-01 | Australia | Queensland | 1187437 | 1057 | 0 | -27.4698 | 153.0251 | 2022-06-02 05:20:39 | Queensland, Australia | |||
2022-02-01 | Australia | Queensland | 427319 | 225 | 0 | -27.4698 | 153.0251 | 2022-02-02 04:21:09 | Queensland, Australia | |||
2021-10-04 | Australia | Queensland | 2048 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-05 04:21:27 | Queensland, Australia | |||
2022-08-16 | Australia | Queensland | 1582419 | 1791 | 0 | -27.4698 | 153.0251 | 2022-08-17 04:20:59 | Queensland, Australia | |||
2021-11-21 | Australia | Queensland | 2112 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-22 04:22:20 | Queensland, Australia | |||
2022-12-24 | Australia | Queensland | 1743616 | 2405 | 0 | -27.4698 | 153.0251 | 2022-12-25 04:21:04 | Queensland, Australia | |||
2022-11-04 | Australia | Queensland | 1668438 | 2288 | 0 | -27.4698 | 153.0251 | 2022-11-05 04:21:52 | Queensland, Australia | |||
2021-12-06 | Australia | Queensland | 2155 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-07 04:22:34 | Queensland, Australia | |||
2022-11-06 | Australia | Queensland | 1668438 | 2288 | 0 | -27.4698 | 153.0251 | 2022-11-07 04:21:26 | Queensland, Australia | |||
2022-02-23 | Australia | Queensland | 549935 | 513 | 0 | -27.4698 | 153.0251 | 2022-02-24 04:21:14 | Queensland, Australia | |||
2022-07-28 | Australia | Queensland | 1488197 | 1554 | 0 | -27.4698 | 153.0251 | 2022-07-29 04:20:45 | Queensland, Australia | |||
2022-08-07 | Australia | Queensland | 1554522 | 1653 | 0 | -27.4698 | 153.0251 | 2022-08-08 04:21:08 | Queensland, Australia | |||
2022-12-28 | Australia | Queensland | 1743616 | 2405 | 0 | -27.4698 | 153.0251 | 2022-12-29 04:21:01 | Queensland, Australia | |||
2021-12-09 | Australia | Queensland | 2165 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-10 04:22:28 | Queensland, Australia | |||
2020-02-22 | Australia | Queensland | 5 | 0 | 1 | -28.0167 | 153.4 | 2020-02-21T05:43:02 | ||||
2022-08-09 | Australia | Queensland | 1562443 | 1712 | 0 | -27.4698 | 153.0251 | 2022-08-10 04:20:57 | Queensland, Australia | |||
2022-08-03 | Australia | Queensland | 1540309 | 1627 | 0 | -27.4698 | 153.0251 | 2022-08-04 04:20:58 | Queensland, Australia | |||
2022-05-21 | Australia | Queensland | 1140646 | 979 | 0 | -27.4698 | 153.0251 | 2022-05-22 04:20:52 | Queensland, Australia | |||
2022-01-11 | Australia | Queensland | 116879 | 11 | 0 | -27.4698 | 153.0251 | 2022-01-12 04:21:44 | Queensland, Australia | |||
2021-08-06 | Australia | Queensland | 1909 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-07 04:21:30 | Queensland, Australia | |||
2022-01-23 | Australia | Queensland | 325150 | 105 | 0 | -27.4698 | 153.0251 | 2022-01-24 04:21:12 | Queensland, Australia | |||
2021-12-01 | Australia | Queensland | 2133 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-02 04:22:37 | Queensland, Australia | |||
2022-12-12 | Australia | Queensland | 1714583 | 2361 | 0 | -27.4698 | 153.0251 | 2022-12-13 04:21:01 | Queensland, Australia | |||
2020-03-02 | Australia | Queensland | 9 | 0 | 1 | -28.0167 | 153.4 | 2020-02-29T02:03:10 | ||||
2022-04-29 | Australia | Queensland | 992324 | 863 | 0 | -27.4698 | 153.0251 | 2022-04-30 04:21:05 | Queensland, Australia | |||
2022-08-18 | Australia | Queensland | 1588222 | 1825 | 0 | -27.4698 | 153.0251 | 2022-08-19 04:20:54 | Queensland, Australia | |||
2022-05-20 | Australia | Queensland | 1136142 | 979 | 0 | -27.4698 | 153.0251 | 2022-05-21 04:20:58 | Queensland, Australia | |||
2020-03-18 | Australia | Queensland | 94 | 0 | 8 | -28.0167 | 153.4 | 2020-03-18T11:53:04 | ||||
2022-05-18 | Australia | Queensland | 1123991 | 961 | 0 | -27.4698 | 153.0251 | 2022-05-19 04:20:54 | Queensland, Australia | |||
2020-02-14 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
2022-07-06 | Australia | Queensland | 1328620 | 1302 | 0 | -27.4698 | 153.0251 | 2022-07-07 04:20:55 | Queensland, Australia | |||
2022-07-11 | Australia | Queensland | 1355442 | 1338 | 0 | -27.4698 | 153.0251 | 2022-07-12 04:20:51 | Queensland, Australia | |||
2022-01-08 | Australia | Queensland | 86783 | 10 | 0 | -27.4698 | 153.0251 | 2022-01-09 04:21:46 | Queensland, Australia | |||
2022-04-14 | Australia | Queensland | 896979 | 797 | 0 | -27.4698 | 153.0251 | 2022-04-15 04:20:57 | Queensland, Australia | |||
2022-01-24 | Australia | Queensland | 344844 | 129 | 0 | -27.4698 | 153.0251 | 2022-01-25 04:21:05 | Queensland, Australia | |||
2021-11-28 | Australia | Queensland | 2125 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-29 04:22:30 | Queensland, Australia | |||
2021-09-27 | Australia | Queensland | 2028 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-28 04:21:28 | Queensland, Australia | |||
2022-11-28 | Australia | Queensland | 1693178 | 2331 | 0 | -27.4698 | 153.0251 | 2022-11-29 04:21:05 | Queensland, Australia | |||
2020-02-17 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
2022-08-23 | Australia | Queensland | 1593156 | 1900 | 0 | -27.4698 | 153.0251 | 2022-08-24 04:20:46 | Queensland, Australia | |||
2021-12-20 | Australia | Queensland | 2442 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-21 03:21:27 | Queensland, Australia | |||
2021-12-18 | Australia | Queensland | 2297 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-19 04:21:11 | Queensland, Australia | |||
2021-09-09 | Australia | Queensland | 1995 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-10 04:21:20 | Queensland, Australia | |||
2021-10-03 | Australia | Queensland | 2046 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-04 04:21:31 | Queensland, Australia | |||
2022-01-05 | Australia | Queensland | 46731 | 8 | 0 | -27.4698 | 153.0251 | 2022-01-06 04:22:09 | Queensland, Australia | |||
2022-01-04 | Australia | Queensland | 36407 | 7 | 0 | -27.4698 | 153.0251 | 2022-01-05 04:21:59 | Queensland, Australia | |||
2022-02-05 | Australia | Queensland | 452882 | 277 | 0 | -27.4698 | 153.0251 | 2022-02-06 04:21:00 | Queensland, Australia | |||
2022-02-17 | Australia | Queensland | 519061 | 446 | 0 | -27.4698 | 153.0251 | 2022-02-18 04:21:04 | Queensland, Australia | |||
2022-05-27 | Australia | Queensland | 1168925 | 1037 | 0 | -27.4698 | 153.0251 | 2022-05-28 04:21:07 | Queensland, Australia | |||
2022-01-26 | Australia | Queensland | 369936 | 153 | 0 | -27.4698 | 153.0251 | 2022-01-27 04:21:19 | Queensland, Australia | |||
2021-11-14 | Australia | Queensland | 2109 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-15 04:21:36 | Queensland, Australia | |||
2022-04-26 | Australia | Queensland | 974270 | 850 | 0 | -27.4698 | 153.0251 | 2022-04-27 04:20:52 | Queensland, Australia | |||
2021-09-28 | Australia | Queensland | 2029 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-29 04:21:45 | Queensland, Australia | |||
2021-08-11 | Australia | Queensland | 1940 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-12 04:21:25 | Queensland, Australia | |||
2022-08-10 | Australia | Queensland | 1565788 | 1723 | 0 | -27.4698 | 153.0251 | 2022-08-11 04:20:49 | Queensland, Australia | |||
2021-11-27 | Australia | Queensland | 2120 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-28 04:22:43 | Queensland, Australia | |||
2022-02-08 | Australia | Queensland | 469663 | 332 | 0 | -27.4698 | 153.0251 | 2022-02-09 04:21:04 | Queensland, Australia | |||
2020-02-08 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-07T01:03:02 | ||||
2022-10-28 | Australia | Queensland | 1664371 | 2274 | 0 | -27.4698 | 153.0251 | 2022-10-29 04:21:13 | Queensland, Australia | |||
2022-09-21 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-22 04:22:56 | Queensland, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;