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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 2021-12-02 | Australia | Queensland | 2139 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-03 04:23:05 | Queensland, Australia | |||
4028 | 4028 | 2021-10-28 | Australia | Queensland | 2089 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-29 04:22:03 | Queensland, Australia | |||
8044 | 8044 | 2020-10-25 | Australia | Queensland | 1167 | 6 | 1157 | 4 | -27.4698 | 153.0251 | 2020-10-26 04:25:02 | Queensland, Australia | ||
12039 | 12039 | 2021-01-26 | Australia | Queensland | 1306 | 6 | 1282 | 18 | -27.4698 | 153.0251 | 2021-01-27 05:23:41 | Queensland, Australia | ||
16053 | 16053 | 2021-09-18 | Australia | Queensland | 2015 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-19 04:21:34 | Queensland, Australia | |||
20068 | 20068 | 2021-05-28 | Australia | Queensland | 1616 | 7 | 1589 | 20 | -27.4698 | 153.0251 | 2021-05-29 04:20:41 | Queensland, Australia | ||
24083 | 24083 | 2022-03-20 | Australia | Queensland | 672275 | 685 | 0 | -27.4698 | 153.0251 | 2022-03-21 04:20:50 | Queensland, Australia | |||
28098 | 28098 | 2021-11-11 | Australia | Queensland | 2109 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-12 04:22:01 | Queensland, Australia | |||
32114 | 32114 | 2021-08-25 | Australia | Queensland | 1972 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-26 04:21:28 | Queensland, Australia | |||
36128 | 36128 | 2021-04-12 | Australia | Queensland | 1506 | 7 | 1381 | 118 | -27.4698 | 153.0251 | 2021-04-13 04:20:37 | Queensland, Australia | ||
40199 | 40199 | 2020-03-05 | Australia | Queensland | 13 | 0 | 8 | -28.0167 | 153.4 | 2020-03-05T17:33:06 | ||||
43135 | 43135 | 2020-04-13 | Australia | Queensland | 987 | 5 | 372 | 610 | -27.4698 | 153.0251 | 2020-04-13 23:15:42 | Queensland, Australia | ||
43390 | 43390 | 2021-11-02 | Australia | Queensland | 2089 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-03 06:22:09 | Queensland, Australia | |||
50234 | 50234 | 2020-04-17 | Australia | Queensland | 1007 | 5 | 442 | 560 | -27.4698 | 153.0251 | 2020-04-17 23:38:48 | Queensland, Australia | ||
50489 | 50489 | 2021-05-29 | Australia | Queensland | 1618 | 7 | 1591 | 20 | -27.4698 | 153.0251 | 2021-05-30 04:20:55 | Queensland, Australia | ||
54503 | 54503 | 2021-03-07 | Australia | Queensland | 1356 | 6 | 1316 | 34 | -27.4698 | 153.0251 | 2021-03-08 05:24:48 | Queensland, Australia | ||
62089 | 62089 | 2020-07-23 | Australia | Queensland | 1076 | 6 | 1063 | 7 | -27.4698 | 153.0251 | 2020-07-24 05:30:40 | Queensland, Australia | ||
62550 | 62550 | 2020-03-07 | Australia | Queensland | 13 | 0 | 8 | -28.0167 | 153.4 | 2020-03-05T17:33:06 | ||||
62744 | 62744 | 2022-11-12 | Australia | Queensland | 1673798 | 2303 | 0 | -27.4698 | 153.0251 | 2022-11-13 04:21:14 | Queensland, Australia | |||
66759 | 66759 | 2021-09-01 | Australia | Queensland | 1982 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-02 04:21:15 | Queensland, Australia | |||
70773 | 70773 | 2022-02-07 | Australia | Queensland | 462761 | 308 | 0 | -27.4698 | 153.0251 | 2022-02-08 04:21:15 | Queensland, Australia | |||
74789 | 74789 | 2020-12-03 | Australia | Queensland | 1208 | 6 | 1190 | 12 | -27.4698 | 153.0251 | 2020-12-04 05:27:27 | Queensland, Australia | ||
78800 | 78800 | 2020-10-14 | Australia | Queensland | 1162 | 6 | 1154 | 2 | -27.4698 | 153.0251 | 2020-10-15 04:24:28 | Queensland, Australia | ||
82793 | 82793 | 2021-05-25 | Australia | Queensland | 1611 | 7 | 1580 | 24 | -27.4698 | 153.0251 | 2021-05-26 04:20:35 | Queensland, Australia | ||
86807 | 86807 | 2021-11-09 | Australia | Queensland | 2102 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-10 04:21:38 | Queensland, Australia | |||
90824 | 90824 | 2022-07-23 | Australia | Queensland | 1448511 | 1470 | 0 | -27.4698 | 153.0251 | 2022-07-24 04:20:47 | Queensland, Australia | |||
98441 | 98441 | 2020-08-04 | Australia | Queensland | 1088 | 6 | 1069 | 13 | -27.4698 | 153.0251 | 2020-08-05 04:34:43 | Queensland, Australia | ||
98867 | 98867 | 2020-03-04 | Australia | Queensland | 11 | 0 | 1 | -28.0167 | 153.4 | 2020-03-03T15:23:03 | ||||
99008 | 99008 | 2022-01-14 | Australia | Queensland | 177454 | 20 | 0 | -27.4698 | 153.0251 | 2022-01-15 04:21:07 | Queensland, Australia | |||
103024 | 103024 | 2021-08-15 | Australia | Queensland | 1955 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-16 04:21:31 | Queensland, Australia | |||
107070 | 107070 | 2020-02-15 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
107149 | 107149 | 2021-06-19 | Australia | Queensland | 1665 | 7 | 1620 | 38 | -27.4698 | 153.0251 | 2021-06-20 04:21:48 | Queensland, Australia | ||
114174 | 114174 | 2020-05-08 | Australia | Queensland | 1045 | 6 | 1019 | 20 | -27.4698 | 153.0251 | 2020-05-09 02:32:35 | Queensland, Australia | ||
114434 | 114434 | 2022-09-06 | Australia | Queensland | 1617036 | 2027 | 0 | -27.4698 | 153.0251 | 2022-09-07 04:20:59 | Queensland, Australia | |||
122033 | 122033 | 2020-07-19 | Australia | Queensland | 1072 | 6 | 1061 | 5 | -27.4698 | 153.0251 | 2020-07-20 05:34:40 | Queensland, Australia | ||
122405 | 122405 | 2020-11-18 | Australia | Queensland | 1190 | 6 | 1171 | 13 | -27.4698 | 153.0251 | 2020-11-19 05:25:23 | Queensland, Australia | ||
126415 | 126415 | 2022-01-09 | Australia | Queensland | 96341 | 10 | 0 | -27.4698 | 153.0251 | 2022-01-10 04:22:07 | Queensland, Australia | |||
130432 | 130432 | 2022-10-04 | Australia | Queensland | 1641389 | 2239 | 0 | -27.4698 | 153.0251 | 2022-10-05 04:23:06 | Queensland, Australia | |||
137398 | 137398 | 2020-04-29 | Australia | Queensland | 1033 | 6 | 943 | 84 | -27.4698 | 153.0251 | 2020-04-30 02:32:27 | Queensland, Australia | ||
137653 | 137653 | 2021-12-04 | Australia | Queensland | 2152 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-05 04:22:25 | Queensland, Australia | |||
141670 | 141670 | 2022-07-09 | Australia | Queensland | 1343864 | 1323 | 0 | -27.4698 | 153.0251 | 2022-07-10 04:20:54 | Queensland, Australia | |||
145685 | 145685 | 2020-08-15 | Australia | Queensland | 1091 | 6 | 1079 | 6 | -27.4698 | 153.0251 | 2020-08-16 04:27:42 | Queensland, Australia | ||
149666 | 149666 | 2021-11-29 | Australia | Queensland | 2127 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-30 04:22:53 | Queensland, Australia | |||
153682 | 153682 | 2021-01-08 | Australia | Queensland | 1274 | 6 | 1240 | 28 | -27.4698 | 153.0251 | 2021-01-09 05:22:18 | Queensland, Australia | ||
157695 | 157695 | 2022-03-29 | Australia | Queensland | 758060 | 732 | 0 | -27.4698 | 153.0251 | 2022-03-30 04:20:45 | Queensland, Australia | |||
161710 | 161710 | 2021-11-19 | Australia | Queensland | 2112 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-20 04:22:17 | Queensland, Australia | |||
165727 | 165727 | 2022-06-21 | Australia | Queensland | 1260631 | 1181 | 0 | -27.4698 | 153.0251 | 2022-06-22 04:20:54 | Queensland, Australia | |||
169742 | 169742 | 2021-04-16 | Australia | Queensland | 1516 | 7 | 1429 | 80 | -27.4698 | 153.0251 | 2021-04-17 04:20:40 | Queensland, Australia | ||
177351 | 177351 | 2020-07-27 | Australia | Queensland | 1076 | 6 | 1063 | 7 | -27.4698 | 153.0251 | 2020-07-28 04:58:43 | Queensland, Australia | ||
177724 | 177724 | 2021-09-02 | Australia | Queensland | 1982 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-03 04:21:20 | Queensland, Australia | |||
181738 | 181738 | 2021-02-21 | Australia | Queensland | 1323 | 6 | 1309 | 8 | -27.4698 | 153.0251 | 2021-02-22 05:24:21 | Queensland, Australia | ||
185753 | 185753 | 2022-02-13 | Australia | Queensland | 498907 | 377 | 0 | -27.4698 | 153.0251 | 2022-02-14 04:20:51 | Queensland, Australia | |||
189768 | 189768 | 2021-01-11 | Australia | Queensland | 1281 | 6 | 1243 | 32 | -27.4698 | 153.0251 | 2021-01-12 05:22:15 | Queensland, Australia | ||
193780 | 193780 | 2020-08-31 | Australia | Queensland | 1124 | 6 | 1084 | 34 | -27.4698 | 153.0251 | 2020-09-01 04:28:31 | Queensland, Australia | ||
197941 | 197941 | 2022-10-19 | Australia | Queensland | 1655265 | 2236 | 0 | -27.4698 | 153.0251 | 2022-10-20 04:22:59 | Queensland, Australia | |||
201956 | 201956 | 2020-12-25 | Australia | Queensland | 1241 | 6 | 1217 | 18 | -27.4698 | 153.0251 | 2020-12-26 05:22:28 | Queensland, Australia | ||
205967 | 205967 | 2020-08-19 | Australia | Queensland | 1093 | 6 | 1081 | 6 | -27.4698 | 153.0251 | 2020-08-20 04:27:43 | Queensland, Australia | ||
209952 | 209952 | 2020-10-29 | Australia | Queensland | 1172 | 6 | 1159 | 7 | -27.4698 | 153.0251 | 2020-10-30 04:24:49 | Queensland, Australia | ||
217303 | 217303 | 2020-06-08 | Australia | Queensland | 1062 | 6 | 1051 | 5 | -27.4698 | 153.0251 | 2020-06-09 03:33:03 | Queensland, Australia | ||
217662 | 217662 | 2022-12-26 | Australia | Queensland | 1743616 | 2405 | 0 | -27.4698 | 153.0251 | 2022-12-27 04:21:07 | Queensland, Australia | |||
221678 | 221678 | 2022-05-09 | Australia | Queensland | 1052748 | 908 | 0 | -27.4698 | 153.0251 | 2022-05-10 04:20:50 | Queensland, Australia | |||
228651 | 228651 | 2020-04-30 | Australia | Queensland | 1033 | 6 | 948 | 79 | -27.4698 | 153.0251 | 2020-05-01 02:32:28 | Queensland, Australia | ||
228909 | 228909 | 2022-05-31 | Australia | Queensland | 1183268 | 1057 | 0 | -27.4698 | 153.0251 | 2022-06-01 04:20:55 | Queensland, Australia | |||
232925 | 232925 | 2022-02-11 | Australia | Queensland | 487846 | 367 | 0 | -27.4698 | 153.0251 | 2022-02-12 04:21:06 | Queensland, Australia | |||
236940 | 236940 | 2021-01-18 | Australia | Queensland | 1297 | 6 | 1255 | 36 | -27.4698 | 153.0251 | 2021-01-19 05:22:15 | Queensland, Australia | ||
240953 | 240953 | 2021-04-02 | Australia | Queensland | 1488 | 6 | 1353 | 129 | -27.4698 | 153.0251 | 2021-04-03 04:20:44 | Queensland, Australia | ||
244967 | 244967 | 2021-08-17 | Australia | Queensland | 1961 | 7 | 0 | -27.4698 | 153.0251 | 2021-08-18 04:21:35 | Queensland, Australia | |||
248981 | 248981 | 2021-09-04 | Australia | Queensland | 1985 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-05 04:21:33 | Queensland, Australia | |||
252996 | 252996 | 2022-09-08 | Australia | Queensland | 1620034 | 2048 | 0 | -27.4698 | 153.0251 | 2022-09-09 04:21:11 | Queensland, Australia | |||
257012 | 257012 | 2022-12-10 | Australia | Queensland | 1714583 | 2361 | 0 | -27.4698 | 153.0251 | 2022-12-11 04:20:50 | Queensland, Australia | |||
261077 | 261077 | 2020-03-03 | Australia | Queensland | 11 | 0 | 1 | -28.0167 | 153.4 | 2020-03-03T15:23:03 | ||||
261215 | 261215 | 2022-03-15 | Australia | Queensland | 640104 | 652 | 0 | -27.4698 | 153.0251 | 2022-03-16 04:20:50 | Queensland, Australia | |||
268375 | 268375 | 2020-05-21 | Australia | Queensland | 1058 | 6 | 1040 | 12 | -27.4698 | 153.0251 | 2020-05-22 02:36:51 | Queensland, Australia | ||
271612 | 271612 | 2020-04-28 | Australia | Queensland | 1034 | 6 | 934 | 94 | -27.4698 | 153.0251 | 2020-04-29 02:32:29 | Queensland, Australia | ||
271867 | 271867 | 2020-11-10 | Australia | Queensland | 1179 | 6 | 1163 | 10 | -27.4698 | 153.0251 | 2020-11-11 05:25:30 | Queensland, Australia | ||
275865 | 275865 | 2021-11-03 | Australia | Queensland | 2092 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-04 04:22:20 | Queensland, Australia | |||
279881 | 279881 | 2021-02-24 | Australia | Queensland | 1324 | 6 | 1309 | 9 | -27.4698 | 153.0251 | 2021-02-25 05:24:57 | Queensland, Australia | ||
287314 | 287314 | 2020-06-15 | Australia | Queensland | 1065 | 6 | 1051 | 8 | -27.4698 | 153.0251 | 2020-06-16 04:33:09 | Queensland, Australia | ||
287678 | 287678 | 2021-10-31 | Australia | Queensland | 2090 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-01 04:22:01 | Queensland, Australia | |||
291695 | 291695 | 2022-11-15 | Australia | Queensland | 1673798 | 2303 | 0 | -27.4698 | 153.0251 | 2022-11-16 04:21:09 | 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 | ||
303186 | 303186 | 2020-07-01 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-07-02 04:33:46 | Queensland, Australia | ||
303551 | 303551 | 2022-04-16 | Australia | Queensland | 907686 | 798 | 0 | -27.4698 | 153.0251 | 2022-04-17 04:20:59 | Queensland, Australia | |||
307567 | 307567 | 2022-12-13 | Australia | Queensland | 1714583 | 2361 | 0 | -27.4698 | 153.0251 | 2022-12-14 04:21:04 | Queensland, Australia | |||
311583 | 311583 | 2022-11-13 | Australia | Queensland | 1673798 | 2303 | 0 | -27.4698 | 153.0251 | 2022-11-14 04:21:09 | Queensland, Australia | |||
315599 | 315599 | 2022-02-12 | Australia | Queensland | 495157 | 371 | 0 | -27.4698 | 153.0251 | 2022-02-13 04:21:00 | Queensland, Australia | |||
319615 | 319615 | 2022-10-30 | Australia | Queensland | 1664371 | 2274 | 0 | -27.4698 | 153.0251 | 2022-10-31 04:21:36 | Queensland, Australia | |||
327128 | 327128 | 2020-07-20 | Australia | Queensland | 1072 | 6 | 1061 | 5 | -27.4698 | 153.0251 | 2020-07-21 04:38:46 | Queensland, Australia | ||
327589 | 327589 | 2022-12-27 | Australia | Queensland | 1743616 | 2405 | 0 | -27.4698 | 153.0251 | 2022-12-28 04:21:04 | 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 | ||
335619 | 335619 | 2022-03-18 | Australia | Queensland | 660484 | 683 | 0 | -27.4698 | 153.0251 | 2022-03-19 04:20:47 | Queensland, Australia | |||
339708 | 339708 | 2020-03-21 | Australia | Queensland | 221 | 0 | 8 | -28.0167 | 153.4 | 2020-03-21T13:13:35 | ||||
339974 | 339974 | 2021-02-03 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-04 05:22:26 | Queensland, Australia | ||
343988 | 343988 | 2020-09-14 | Australia | Queensland | 1150 | 6 | 1111 | 33 | -27.4698 | 153.0251 | 2020-09-15 03:22:50 | Queensland, Australia | ||
347979 | 347979 | 2022-12-14 | Australia | Queensland | 1714583 | 2361 | 0 | -27.4698 | 153.0251 | 2022-12-15 04:20:58 | Queensland, Australia | |||
351994 | 351994 | 2021-03-11 | Australia | Queensland | 1375 | 6 | 1324 | 45 | -27.4698 | 153.0251 | 2021-03-12 05:26:50 | Queensland, Australia | ||
356009 | 356009 | 2022-03-11 | Australia | Queensland | 620951 | 629 | 0 | -27.4698 | 153.0251 | 2022-03-12 04:20:50 | Queensland, Australia | |||
360025 | 360025 | 2022-05-07 | Australia | Queensland | 1041450 | 905 | 0 | -27.4698 | 153.0251 | 2022-05-08 04:20:49 | Queensland, Australia | |||
367534 | 367534 | 2020-07-16 | Australia | Queensland | 1071 | 6 | 1058 | 7 | -27.4698 | 153.0251 | 2020-07-17 04:34:50 | Queensland, Australia | ||
371506 | 371506 | 2020-08-08 | Australia | Queensland | 1088 | 6 | 1071 | 11 | -27.4698 | 153.0251 | 2020-08-09 04:34:54 | 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]);