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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-21 04:23:22 | Queensland, Australia | |||
2022-09-19 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-20 04:22:48 | Queensland, Australia | |||
2022-09-18 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-19 04:21:49 | Queensland, Australia | |||
2022-09-17 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-18 04:22:50 | Queensland, Australia | |||
2022-09-16 | Australia | Queensland | 1622985 | 2125 | 0 | -27.4698 | 153.0251 | 2022-09-17 04:20:19 | Queensland, Australia | |||
2022-09-15 | Australia | Queensland | 1622985 | 2054 | 0 | -27.4698 | 153.0251 | 2022-09-16 04:21:19 | Queensland, Australia | |||
2022-09-14 | Australia | Queensland | 1622985 | 2054 | 0 | -27.4698 | 153.0251 | 2022-09-15 04:21:02 | Queensland, Australia | |||
2022-09-13 | Australia | Queensland | 1622985 | 2054 | 0 | -27.4698 | 153.0251 | 2022-09-14 04:20:44 | Queensland, Australia | |||
2022-09-12 | Australia | Queensland | 1622985 | 2054 | 0 | -27.4698 | 153.0251 | 2022-09-13 04:20:57 | Queensland, Australia | |||
2022-09-11 | Australia | Queensland | 1622985 | 2054 | 0 | -27.4698 | 153.0251 | 2022-09-12 04:20:58 | Queensland, Australia | |||
2022-09-10 | Australia | Queensland | 1620034 | 2048 | 0 | -27.4698 | 153.0251 | 2022-09-11 04:20:50 | Queensland, Australia | |||
2022-09-09 | Australia | Queensland | 1620034 | 2048 | 0 | -27.4698 | 153.0251 | 2022-09-10 04:21:10 | Queensland, Australia | |||
2022-09-08 | Australia | Queensland | 1620034 | 2048 | 0 | -27.4698 | 153.0251 | 2022-09-09 04:21:11 | Queensland, Australia | |||
2022-09-07 | Australia | Queensland | 1618600 | 2027 | 0 | -27.4698 | 153.0251 | 2022-09-08 04:21:02 | Queensland, Australia | |||
2022-09-06 | Australia | Queensland | 1617036 | 2027 | 0 | -27.4698 | 153.0251 | 2022-09-07 04:20:59 | Queensland, Australia | |||
2022-09-05 | Australia | Queensland | 1615258 | 2003 | 0 | -27.4698 | 153.0251 | 2022-09-06 04:21:02 | Queensland, Australia | |||
2022-09-04 | Australia | Queensland | 1611208 | 1988 | 0 | -27.4698 | 153.0251 | 2022-09-05 04:21:01 | Queensland, Australia | |||
2022-09-03 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-04 04:21:22 | Queensland, Australia | |||
2022-09-02 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-03 04:21:04 | Queensland, Australia | |||
2022-09-01 | Australia | Queensland | 1610200 | 1986 | 0 | -27.4698 | 153.0251 | 2022-09-02 04:21:07 | Queensland, Australia | |||
2022-08-31 | Australia | Queensland | 1608401 | 1985 | 0 | -27.4698 | 153.0251 | 2022-09-01 04:21:03 | Queensland, Australia | |||
2022-08-30 | Australia | Queensland | 1606370 | 1969 | 0 | -27.4698 | 153.0251 | 2022-08-31 04:20:57 | Queensland, Australia | |||
2022-08-29 | Australia | Queensland | 1604082 | 1955 | 0 | -27.4698 | 153.0251 | 2022-08-30 04:21:03 | Queensland, Australia | |||
2022-08-28 | Australia | Queensland | 1601676 | 1937 | 0 | -27.4698 | 153.0251 | 2022-08-29 04:21:06 | Queensland, Australia | |||
2022-08-27 | Australia | Queensland | 1600452 | 1937 | 0 | -27.4698 | 153.0251 | 2022-08-28 04:21:02 | Queensland, Australia | |||
2022-08-26 | Australia | Queensland | 1599323 | 1937 | 0 | -27.4698 | 153.0251 | 2022-08-27 04:20:57 | Queensland, Australia | |||
2022-08-25 | Australia | Queensland | 1597470 | 1919 | 0 | -27.4698 | 153.0251 | 2022-08-26 04:21:02 | Queensland, Australia | |||
2022-08-24 | Australia | Queensland | 1595372 | 1900 | 0 | -27.4698 | 153.0251 | 2022-08-25 04:21:13 | Queensland, Australia | |||
2022-08-23 | Australia | Queensland | 1593156 | 1900 | 0 | -27.4698 | 153.0251 | 2022-08-24 04:20:46 | Queensland, Australia | |||
2022-08-22 | Australia | Queensland | 1590535 | 1871 | 0 | -27.4698 | 153.0251 | 2022-08-23 04:20:56 | Queensland, Australia | |||
2022-08-21 | Australia | Queensland | 1593614 | 1845 | 0 | -27.4698 | 153.0251 | 2022-08-22 04:20:38 | Queensland, Australia | |||
2022-08-20 | Australia | Queensland | 1592023 | 1845 | 0 | -27.4698 | 153.0251 | 2022-08-21 04:20:44 | Queensland, Australia | |||
2022-08-19 | Australia | Queensland | 1590875 | 1845 | 0 | -27.4698 | 153.0251 | 2022-08-20 04:21:01 | Queensland, Australia | |||
2022-08-18 | Australia | Queensland | 1588222 | 1825 | 0 | -27.4698 | 153.0251 | 2022-08-19 04:20:54 | Queensland, Australia | |||
2022-08-17 | Australia | Queensland | 1585477 | 1811 | 0 | -27.4698 | 153.0251 | 2022-08-18 04:21:11 | Queensland, Australia | |||
2022-08-16 | Australia | Queensland | 1582419 | 1791 | 0 | -27.4698 | 153.0251 | 2022-08-17 04:20:59 | Queensland, Australia | |||
2022-08-15 | Australia | Queensland | 1579334 | 1774 | 0 | -27.4698 | 153.0251 | 2022-08-16 04:20:58 | Queensland, Australia | |||
2022-08-14 | Australia | Queensland | 1576102 | 1757 | 0 | -27.4698 | 153.0251 | 2022-08-15 04:20:59 | Queensland, Australia | |||
2022-08-13 | Australia | Queensland | 1574198 | 1757 | 0 | -27.4698 | 153.0251 | 2022-08-14 04:20:55 | Queensland, Australia | |||
2022-08-12 | Australia | Queensland | 1572252 | 1757 | 0 | -27.4698 | 153.0251 | 2022-08-13 04:20:52 | Queensland, Australia | |||
2022-08-11 | Australia | Queensland | 1569096 | 1741 | 0 | -27.4698 | 153.0251 | 2022-08-12 04:20:54 | Queensland, Australia | |||
2022-08-10 | Australia | Queensland | 1565788 | 1723 | 0 | -27.4698 | 153.0251 | 2022-08-11 04:20:49 | Queensland, Australia | |||
2022-08-09 | Australia | Queensland | 1562443 | 1712 | 0 | -27.4698 | 153.0251 | 2022-08-10 04:20:57 | Queensland, Australia | |||
2022-08-08 | Australia | Queensland | 1558656 | 1677 | 0 | -27.4698 | 153.0251 | 2022-08-09 04:20:34 | Queensland, Australia | |||
2022-08-07 | Australia | Queensland | 1554522 | 1653 | 0 | -27.4698 | 153.0251 | 2022-08-08 04:21:08 | Queensland, Australia | |||
2022-08-06 | Australia | Queensland | 1552018 | 1653 | 0 | -27.4698 | 153.0251 | 2022-08-07 04:20:54 | Queensland, Australia | |||
2022-08-05 | Australia | Queensland | 1549389 | 1653 | 0 | -27.4698 | 153.0251 | 2022-08-06 04:20:56 | Queensland, Australia | |||
2022-08-04 | Australia | Queensland | 1545223 | 1635 | 0 | -27.4698 | 153.0251 | 2022-08-05 04:20:52 | Queensland, Australia | |||
2022-08-03 | Australia | Queensland | 1540309 | 1627 | 0 | -27.4698 | 153.0251 | 2022-08-04 04:20:58 | Queensland, Australia | |||
2022-08-02 | Australia | Queensland | 1534738 | 1596 | 0 | -27.4698 | 153.0251 | 2022-08-03 04:20:59 | Queensland, Australia | |||
2022-08-01 | Australia | Queensland | 1528342 | 1590 | 0 | -27.4698 | 153.0251 | 2022-08-02 04:20:53 | Queensland, Australia | |||
2022-07-31 | Australia | Queensland | 1517194 | 1567 | 0 | -27.4698 | 153.0251 | 2022-08-01 04:21:03 | Queensland, Australia | |||
2022-07-30 | Australia | Queensland | 1512891 | 1567 | 0 | -27.4698 | 153.0251 | 2022-07-31 04:21:02 | Queensland, Australia | |||
2022-07-29 | Australia | Queensland | 1506868 | 1567 | 0 | -27.4698 | 153.0251 | 2022-07-30 04:20:42 | Queensland, Australia | |||
2022-07-28 | Australia | Queensland | 1488197 | 1554 | 0 | -27.4698 | 153.0251 | 2022-07-29 04:20:45 | Queensland, Australia | |||
2022-07-27 | Australia | Queensland | 1478809 | 1537 | 0 | -27.4698 | 153.0251 | 2022-07-28 04:20:56 | Queensland, Australia | |||
2022-07-26 | Australia | Queensland | 1471445 | 1510 | 0 | -27.4698 | 153.0251 | 2022-07-27 04:21:04 | Queensland, Australia | |||
2022-07-25 | Australia | Queensland | 1463230 | 1491 | 0 | -27.4698 | 153.0251 | 2022-07-26 04:20:58 | Queensland, Australia | |||
2022-07-24 | Australia | Queensland | 1454617 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-25 04:20:51 | Queensland, Australia | |||
2022-07-23 | Australia | Queensland | 1448511 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-24 04:20:47 | Queensland, Australia | |||
2022-07-22 | Australia | Queensland | 1442714 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-23 04:20:53 | Queensland, Australia | |||
2022-07-21 | Australia | Queensland | 1435080 | 1462 | 0 | -27.4698 | 153.0251 | 2022-07-22 04:21:15 | Queensland, Australia | |||
2022-07-20 | Australia | Queensland | 1426054 | 1452 | 0 | -27.4698 | 153.0251 | 2022-07-21 04:21:10 | Queensland, Australia | |||
2022-07-19 | Australia | Queensland | 1414382 | 1442 | 0 | -27.4698 | 153.0251 | 2022-07-20 04:20:59 | Queensland, Australia | |||
2022-07-18 | Australia | Queensland | 1404722 | 1427 | 0 | -27.4698 | 153.0251 | 2022-07-19 04:20:58 | Queensland, Australia | |||
2022-07-17 | Australia | Queensland | 1394701 | 1409 | 0 | -27.4698 | 153.0251 | 2022-07-18 04:20:59 | Queensland, Australia | |||
2022-07-16 | Australia | Queensland | 1388004 | 1410 | 0 | -27.4698 | 153.0251 | 2022-07-17 04:21:15 | Queensland, Australia | |||
2022-07-15 | Australia | Queensland | 1382013 | 1410 | 0 | -27.4698 | 153.0251 | 2022-07-16 04:21:05 | Queensland, Australia | |||
2022-07-14 | Australia | Queensland | 1376218 | 1388 | 0 | -27.4698 | 153.0251 | 2022-07-15 04:20:53 | Queensland, Australia | |||
2022-07-13 | Australia | Queensland | 1369893 | 1368 | 0 | -27.4698 | 153.0251 | 2022-07-14 04:20:57 | Queensland, Australia | |||
2022-07-12 | Australia | Queensland | 1362988 | 1350 | 0 | -27.4698 | 153.0251 | 2022-07-13 04:20:58 | Queensland, Australia | |||
2022-07-11 | Australia | Queensland | 1355442 | 1338 | 0 | -27.4698 | 153.0251 | 2022-07-12 04:20:51 | Queensland, Australia | |||
2022-07-10 | Australia | Queensland | 1348674 | 1323 | 0 | -27.4698 | 153.0251 | 2022-07-11 04:20:46 | Queensland, Australia | |||
2022-07-09 | Australia | Queensland | 1343864 | 1323 | 0 | -27.4698 | 153.0251 | 2022-07-10 04:20:54 | Queensland, Australia | |||
2022-07-08 | Australia | Queensland | 1339680 | 1323 | 0 | -27.4698 | 153.0251 | 2022-07-09 04:20:59 | Queensland, Australia | |||
2022-07-07 | Australia | Queensland | 1334363 | 1315 | 0 | -27.4698 | 153.0251 | 2022-07-08 04:20:56 | Queensland, Australia | |||
2022-07-06 | Australia | Queensland | 1328620 | 1302 | 0 | -27.4698 | 153.0251 | 2022-07-07 04:20:55 | Queensland, Australia | |||
2022-07-05 | Australia | Queensland | 1322636 | 1285 | 0 | -27.4698 | 153.0251 | 2022-07-06 04:20:58 | Queensland, Australia | |||
2022-07-04 | Australia | Queensland | 1316745 | 1281 | 0 | -27.4698 | 153.0251 | 2022-07-05 04:20:45 | Queensland, Australia | |||
2022-07-03 | Australia | Queensland | 1311042 | 1270 | 0 | -27.4698 | 153.0251 | 2022-07-04 04:20:54 | Queensland, Australia | |||
2022-07-02 | Australia | Queensland | 1306983 | 1270 | 0 | -27.4698 | 153.0251 | 2022-07-03 04:20:59 | Queensland, Australia | |||
2022-07-01 | Australia | Queensland | 1303007 | 1270 | 0 | -27.4698 | 153.0251 | 2022-07-02 04:21:16 | Queensland, Australia | |||
2022-06-30 | Australia | Queensland | 1298031 | 1254 | 0 | -27.4698 | 153.0251 | 2022-07-01 04:21:10 | Queensland, Australia | |||
2022-06-29 | Australia | Queensland | 1292709 | 1248 | 0 | -27.4698 | 153.0251 | 2022-06-30 04:21:01 | Queensland, Australia | |||
2022-06-28 | Australia | Queensland | 1287412 | 1238 | 0 | -27.4698 | 153.0251 | 2022-06-29 04:20:59 | Queensland, Australia | |||
2022-06-27 | Australia | Queensland | 1285999 | 1199 | 0 | -27.4698 | 153.0251 | 2022-06-28 04:20:58 | Queensland, Australia | |||
2022-06-26 | Australia | Queensland | 1280731 | 1199 | 0 | -27.4698 | 153.0251 | 2022-06-27 04:21:00 | Queensland, Australia | |||
2022-06-25 | Australia | Queensland | 1277471 | 1199 | 0 | -27.4698 | 153.0251 | 2022-06-26 04:21:02 | Queensland, Australia | |||
2022-06-24 | Australia | Queensland | 1274426 | 1197 | 0 | -27.4698 | 153.0251 | 2022-06-25 04:20:57 | Queensland, Australia | |||
2022-06-23 | Australia | Queensland | 1270096 | 1192 | 0 | -27.4698 | 153.0251 | 2022-06-24 04:20:58 | Queensland, Australia | |||
2022-06-22 | Australia | Queensland | 1265588 | 1186 | 0 | -27.4698 | 153.0251 | 2022-06-23 04:20:55 | Queensland, Australia | |||
2022-06-21 | Australia | Queensland | 1260631 | 1181 | 0 | -27.4698 | 153.0251 | 2022-06-22 04:20:54 | Queensland, Australia | |||
2022-06-20 | Australia | Queensland | 1255837 | 1175 | 0 | -27.4698 | 153.0251 | 2022-06-21 04:20:56 | Queensland, Australia | |||
2022-06-19 | Australia | Queensland | 1251031 | 1171 | 0 | -27.4698 | 153.0251 | 2022-06-20 04:21:01 | Queensland, Australia | |||
2022-06-18 | Australia | Queensland | 1248002 | 1171 | 0 | -27.4698 | 153.0251 | 2022-06-19 04:20:51 | Queensland, Australia | |||
2022-06-17 | Australia | Queensland | 1245043 | 1171 | 0 | -27.4698 | 153.0251 | 2022-06-18 04:21:10 | Queensland, Australia | |||
2022-06-16 | Australia | Queensland | 1241020 | 1163 | 0 | -27.4698 | 153.0251 | 2022-06-17 04:20:56 | Queensland, Australia | |||
2022-06-15 | Australia | Queensland | 1236839 | 1152 | 0 | -27.4698 | 153.0251 | 2022-06-16 04:20:55 | Queensland, Australia | |||
2022-06-14 | Australia | Queensland | 1232417 | 1139 | 0 | -27.4698 | 153.0251 | 2022-06-15 04:20:54 | Queensland, Australia | |||
2022-06-13 | Australia | Queensland | 1228242 | 1126 | 0 | -27.4698 | 153.0251 | 2022-06-14 04:20:52 | Queensland, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;