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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
742012 | 742012 | 2021-02-20 | Australia | Queensland | 1321 | 6 | 1309 | 6 | -27.4698 | 153.0251 | 2021-02-21 05:24:33 | Queensland, Australia | ||
471110 | 471110 | 2021-02-19 | Australia | Queensland | 1321 | 6 | 1309 | 6 | -27.4698 | 153.0251 | 2021-02-20 05:22:51 | Queensland, Australia | ||
1152820 | 1152820 | 2021-02-18 | Australia | Queensland | 1321 | 6 | 1307 | 8 | -27.4698 | 153.0251 | 2021-02-19 05:24:16 | Queensland, Australia | ||
3600740 | 3600740 | 2021-02-17 | Australia | Queensland | 1320 | 6 | 1306 | 8 | -27.4698 | 153.0251 | 2021-02-18 05:22:58 | Queensland, Australia | ||
3049875 | 3049875 | 2021-02-16 | Australia | Queensland | 1320 | 6 | 1306 | 8 | -27.4698 | 153.0251 | 2021-02-17 05:23:10 | Queensland, Australia | ||
1337974 | 1337974 | 2021-02-15 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-16 05:24:38 | Queensland, Australia | ||
2283125 | 2283125 | 2021-02-14 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-15 05:24:49 | Queensland, Australia | ||
2677525 | 2677525 | 2021-02-13 | Australia | Queensland | 1320 | 6 | 1301 | 13 | -27.4698 | 153.0251 | 2021-02-14 05:23:43 | Queensland, Australia | ||
3539158 | 3539158 | 2021-02-12 | Australia | Queensland | 1320 | 6 | 1300 | 14 | -27.4698 | 153.0251 | 2021-02-13 05:22:12 | Queensland, Australia | ||
2637421 | 2637421 | 2021-02-11 | Australia | Queensland | 1318 | 6 | 1299 | 13 | -27.4698 | 153.0251 | 2021-02-12 05:23:29 | Queensland, Australia | ||
3978276 | 3978276 | 2021-02-10 | Australia | Queensland | 1317 | 6 | 1299 | 12 | -27.4698 | 153.0251 | 2021-02-11 05:23:55 | Queensland, Australia | ||
1527596 | 1527596 | 2021-02-09 | Australia | Queensland | 1316 | 6 | 1299 | 11 | -27.4698 | 153.0251 | 2021-02-10 05:22:41 | Queensland, Australia | ||
613387 | 613387 | 2021-02-08 | Australia | Queensland | 1315 | 6 | 1297 | 12 | -27.4698 | 153.0251 | 2021-02-09 05:23:30 | Queensland, Australia | ||
1672156 | 1672156 | 2021-02-07 | Australia | Queensland | 1314 | 6 | 1297 | 11 | -27.4698 | 153.0251 | 2021-02-08 05:22:39 | Queensland, Australia | ||
974617 | 974617 | 2021-02-06 | Australia | Queensland | 1312 | 6 | 1295 | 11 | -27.4698 | 153.0251 | 2021-02-07 05:23:00 | Queensland, Australia | ||
1587875 | 1587875 | 2021-02-05 | Australia | Queensland | 1311 | 6 | 1294 | 11 | -27.4698 | 153.0251 | 2021-02-06 05:23:55 | Queensland, Australia | ||
790082 | 790082 | 2021-02-04 | Australia | Queensland | 1309 | 6 | 1293 | 10 | -27.4698 | 153.0251 | 2021-02-05 05:22:38 | Queensland, Australia | ||
339974 | 339974 | 2021-02-03 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-04 05:22:26 | Queensland, Australia | ||
1684200 | 1684200 | 2021-02-02 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-03 05:22:52 | Queensland, Australia | ||
1676170 | 1676170 | 2021-02-01 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-02 05:22:49 | Queensland, Australia | ||
1459458 | 1459458 | 2021-01-31 | Australia | Queensland | 1310 | 6 | 1295 | 9 | -27.4698 | 153.0251 | 2021-02-01 05:22:53 | Queensland, Australia | ||
2211366 | 2211366 | 2021-01-30 | Australia | Queensland | 1309 | 6 | 1295 | 8 | -27.4698 | 153.0251 | 2021-01-31 05:22:42 | Queensland, Australia | ||
1896853 | 1896853 | 2021-01-29 | Australia | Queensland | 1309 | 6 | 1287 | 16 | -27.4698 | 153.0251 | 2021-01-30 05:22:49 | Queensland, Australia | ||
2481669 | 2481669 | 2021-01-28 | Australia | Queensland | 1308 | 6 | 1286 | 16 | -27.4698 | 153.0251 | 2021-01-29 05:22:23 | Queensland, Australia | ||
3153304 | 3153304 | 2021-01-27 | Australia | Queensland | 1307 | 6 | 1286 | 15 | -27.4698 | 153.0251 | 2021-01-28 05:22:24 | 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 | ||
2567363 | 2567363 | 2021-01-25 | Australia | Queensland | 1305 | 6 | 1278 | 21 | -27.4698 | 153.0251 | 2021-01-26 05:22:02 | Queensland, Australia | ||
1758995 | 1758995 | 2021-01-24 | Australia | Queensland | 1305 | 6 | 1278 | 21 | -27.4698 | 153.0251 | 2021-01-25 05:22:16 | Queensland, Australia | ||
2426602 | 2426602 | 2021-01-23 | Australia | Queensland | 1303 | 6 | 1272 | 25 | -27.4698 | 153.0251 | 2021-01-24 05:22:35 | Queensland, Australia | ||
2466504 | 2466504 | 2021-01-22 | Australia | Queensland | 1303 | 6 | 1266 | 31 | -27.4698 | 153.0251 | 2021-01-23 05:22:03 | Queensland, Australia | ||
435055 | 435055 | 2021-01-21 | Australia | Queensland | 1303 | 6 | 1261 | 36 | -27.4698 | 153.0251 | 2021-01-22 05:22:10 | Queensland, Australia | ||
1093787 | 1093787 | 2021-01-20 | Australia | Queensland | 1300 | 6 | 1261 | 33 | -27.4698 | 153.0251 | 2021-01-21 05:22:01 | Queensland, Australia | ||
907877 | 907877 | 2021-01-19 | Australia | Queensland | 1299 | 6 | 1258 | 35 | -27.4698 | 153.0251 | 2021-01-20 05:21:54 | 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 | ||
3503057 | 3503057 | 2021-01-17 | Australia | Queensland | 1294 | 6 | 1254 | 34 | -27.4698 | 153.0251 | 2021-01-18 05:22:34 | Queensland, Australia | ||
3101140 | 3101140 | 2021-01-16 | Australia | Queensland | 1293 | 6 | 1253 | 34 | -27.4698 | 153.0251 | 2021-01-17 05:22:17 | Queensland, Australia | ||
3515102 | 3515102 | 2021-01-15 | Australia | Queensland | 1291 | 6 | 1248 | 37 | -27.4698 | 153.0251 | 2021-01-16 05:22:40 | Queensland, Australia | ||
3879275 | 3879275 | 2021-01-14 | Australia | Queensland | 1290 | 6 | 1247 | 37 | -27.4698 | 153.0251 | 2021-01-15 05:22:24 | Queensland, Australia | ||
3307902 | 3307902 | 2021-01-13 | Australia | Queensland | 1287 | 6 | 1245 | 36 | -27.4698 | 153.0251 | 2021-01-14 05:22:32 | Queensland, Australia | ||
774047 | 774047 | 2021-01-12 | Australia | Queensland | 1283 | 6 | 1245 | 32 | -27.4698 | 153.0251 | 2021-01-13 05:22:15 | 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 | ||
2625571 | 2625571 | 2021-01-10 | Australia | Queensland | 1278 | 6 | 1243 | 29 | -27.4698 | 153.0251 | 2021-01-11 05:21:50 | Queensland, Australia | ||
3899659 | 3899659 | 2021-01-09 | Australia | Queensland | 1274 | 6 | 1241 | 27 | -27.4698 | 153.0251 | 2021-01-10 05:22:12 | 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 | ||
2541106 | 2541106 | 2021-01-07 | Australia | Queensland | 1274 | 6 | 1239 | 29 | -27.4698 | 153.0251 | 2021-01-08 05:22:42 | Queensland, Australia | ||
2864415 | 2864415 | 2021-01-06 | Australia | Queensland | 1265 | 6 | 1234 | 25 | -27.4698 | 153.0251 | 2021-01-07 05:22:03 | Queensland, Australia | ||
3034002 | 3034002 | 2021-01-05 | Australia | Queensland | 1263 | 6 | 1233 | 24 | -27.4698 | 153.0251 | 2021-01-06 05:22:16 | Queensland, Australia | ||
1061547 | 1061547 | 2021-01-04 | Australia | Queensland | 1262 | 6 | 1233 | 23 | -27.4698 | 153.0251 | 2021-01-05 05:21:49 | Queensland, Australia | ||
3230150 | 3230150 | 2021-01-03 | Australia | Queensland | 1260 | 6 | 1232 | 22 | -27.4698 | 153.0251 | 2021-01-04 05:22:02 | Queensland, Australia | ||
2227220 | 2227220 | 2021-01-02 | Australia | Queensland | 1255 | 6 | 1232 | 17 | -27.4698 | 153.0251 | 2021-01-03 05:22:52 | Queensland, Australia | ||
1136584 | 1136584 | 2021-01-01 | Australia | Queensland | 1255 | 6 | 1224 | 25 | -27.4698 | 153.0251 | 2021-01-02 05:22:33 | Queensland, Australia | ||
3695190 | 3695190 | 2020-12-31 | Australia | Queensland | 1253 | 6 | 1218 | 29 | -27.4698 | 153.0251 | 2021-01-01 05:23:07 | Queensland, Australia | ||
1010005 | 1010005 | 2020-12-30 | Australia | Queensland | 1253 | 6 | 1218 | 29 | -27.4698 | 153.0251 | 2020-12-31 05:22:49 | Queensland, Australia | ||
766020 | 766020 | 2020-12-29 | Australia | Queensland | 1250 | 6 | 1218 | 26 | -27.4698 | 153.0251 | 2020-12-30 05:22:34 | Queensland, Australia | ||
3761284 | 3761284 | 2020-12-28 | Australia | Queensland | 1248 | 6 | 1218 | 24 | -27.4698 | 153.0251 | 2020-12-29 05:22:37 | Queensland, Australia | ||
3777604 | 3777604 | 2020-12-27 | Australia | Queensland | 1246 | 6 | 1217 | 23 | -27.4698 | 153.0251 | 2020-12-28 05:22:06 | Queensland, Australia | ||
2223209 | 2223209 | 2020-12-26 | Australia | Queensland | 1241 | 6 | 1217 | 18 | -27.4698 | 153.0251 | 2020-12-27 05:22:55 | 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 | ||
3691179 | 3691179 | 2020-12-24 | Australia | Queensland | 1240 | 6 | 1216 | 18 | -27.4698 | 153.0251 | 2020-12-25 05:22:48 | Queensland, Australia | ||
2406531 | 2406531 | 2020-12-23 | Australia | Queensland | 1238 | 6 | 1216 | 16 | -27.4698 | 153.0251 | 2020-12-24 05:23:04 | Queensland, Australia | ||
3769577 | 3769577 | 2020-12-22 | Australia | Queensland | 1236 | 6 | 1215 | 15 | -27.4698 | 153.0251 | 2020-12-23 05:22:03 | Queensland, Australia | ||
927393 | 927393 | 2020-12-21 | Australia | Queensland | 1235 | 6 | 1215 | 14 | -27.4698 | 153.0251 | 2020-12-22 05:22:33 | Queensland, Australia | ||
2119414 | 2119414 | 2020-12-20 | Australia | Queensland | 1235 | 6 | 1214 | 15 | -27.4698 | 153.0251 | 2020-12-21 05:27:58 | Queensland, Australia | ||
2930921 | 2930921 | 2020-12-19 | Australia | Queensland | 1234 | 6 | 1214 | 14 | -27.4698 | 153.0251 | 2020-12-20 05:27:32 | Queensland, Australia | ||
1900867 | 1900867 | 2020-12-18 | Australia | Queensland | 1232 | 6 | 1214 | 12 | -27.4698 | 153.0251 | 2020-12-19 05:27:52 | Queensland, Australia | ||
2127693 | 2127693 | 2020-12-17 | Australia | Queensland | 1233 | 6 | 1213 | 14 | -27.4698 | 153.0251 | 2020-12-18 05:28:18 | Queensland, Australia | ||
3149293 | 3149293 | 2020-12-16 | Australia | Queensland | 1230 | 6 | 1209 | 15 | -27.4698 | 153.0251 | 2020-12-17 05:28:12 | Queensland, Australia | ||
1034074 | 1034074 | 2020-12-15 | Australia | Queensland | 1229 | 6 | 1204 | 19 | -27.4698 | 153.0251 | 2020-12-16 05:28:04 | Queensland, Australia | ||
1750968 | 1750968 | 2020-12-14 | Australia | Queensland | 1228 | 6 | 1204 | 18 | -27.4698 | 153.0251 | 2020-12-15 05:26:38 | Queensland, Australia | ||
3847488 | 3847488 | 2020-12-13 | Australia | Queensland | 1227 | 6 | 1203 | 18 | -27.4698 | 153.0251 | 2020-12-14 05:26:27 | Queensland, Australia | ||
845270 | 845270 | 2020-12-12 | Australia | Queensland | 1226 | 6 | 1202 | 18 | -27.4698 | 153.0251 | 2020-12-13 05:27:20 | Queensland, Australia | ||
860377 | 860377 | 2020-12-11 | Australia | Queensland | 1226 | 6 | 1199 | 21 | -27.4698 | 153.0251 | 2020-12-12 05:26:19 | Queensland, Australia | ||
1599919 | 1599919 | 2020-12-10 | Australia | Queensland | 1224 | 6 | 1197 | 21 | -27.4698 | 153.0251 | 2020-12-11 05:26:59 | Queensland, Australia | ||
2974928 | 2974928 | 2020-12-09 | Australia | Queensland | 1225 | 6 | 1196 | 23 | -27.4698 | 153.0251 | 2020-12-10 05:26:19 | Queensland, Australia | ||
1818488 | 1818488 | 2020-12-08 | Australia | Queensland | 1221 | 6 | 1191 | 24 | -27.4698 | 153.0251 | 2020-12-09 05:28:01 | Queensland, Australia | ||
2347124 | 2347124 | 2020-12-07 | Australia | Queensland | 1221 | 6 | 1191 | 24 | -27.4698 | 153.0251 | 2020-12-08 05:27:42 | Queensland, Australia | ||
1005994 | 1005994 | 2020-12-06 | Australia | Queensland | 1215 | 6 | 1191 | 18 | -27.4698 | 153.0251 | 2020-12-07 05:26:14 | Queensland, Australia | ||
1632003 | 1632003 | 2020-12-05 | Australia | Queensland | 1212 | 6 | 1191 | 15 | -27.4698 | 153.0251 | 2020-12-06 05:26:18 | Queensland, Australia | ||
3859531 | 3859531 | 2020-12-04 | Australia | Queensland | 1210 | 6 | 1191 | 13 | -27.4698 | 153.0251 | 2020-12-05 05:27:36 | 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 | ||
738001 | 738001 | 2020-12-02 | Australia | Queensland | 1206 | 6 | 1187 | 13 | -27.4698 | 153.0251 | 2020-12-03 05:28:22 | Queensland, Australia | ||
2537095 | 2537095 | 2020-12-01 | Australia | Queensland | 1205 | 6 | 1186 | 13 | -27.4698 | 153.0251 | 2020-12-02 05:27:41 | Queensland, Australia | ||
1583864 | 1583864 | 2020-11-30 | Australia | Queensland | 1202 | 6 | 1184 | 12 | -27.4698 | 153.0251 | 2020-12-01 05:26:18 | Queensland, Australia | ||
3566267 | 3566267 | 2020-11-29 | Australia | Queensland | 1201 | 6 | 1181 | 14 | -27.4698 | 153.0251 | 2020-11-30 05:26:13 | Queensland, Australia | ||
2934932 | 2934932 | 2020-11-28 | Australia | Queensland | 1201 | 6 | 1181 | 14 | -27.4698 | 153.0251 | 2020-11-29 05:25:55 | Queensland, Australia | ||
391935 | 391935 | 2020-11-27 | Australia | Queensland | 1199 | 6 | 1180 | 13 | -27.4698 | 153.0251 | 2020-11-28 05:25:50 | Queensland, Australia | ||
923382 | 923382 | 2020-11-26 | Australia | Queensland | 1198 | 6 | 1178 | 14 | -27.4698 | 153.0251 | 2020-11-27 05:26:53 | Queensland, Australia | ||
1972287 | 1972287 | 2020-11-25 | Australia | Queensland | 1197 | 6 | 1177 | 14 | -27.4698 | 153.0251 | 2020-11-26 05:27:44 | Queensland, Australia | ||
1350018 | 1350018 | 2020-11-24 | Australia | Queensland | 1197 | 6 | 1177 | 14 | -27.4698 | 153.0251 | 2020-11-25 05:27:20 | Queensland, Australia | ||
678013 | 678013 | 2020-11-23 | Australia | Queensland | 1197 | 6 | 1176 | 15 | -27.4698 | 153.0251 | 2020-11-24 05:27:31 | Queensland, Australia | ||
3189689 | 3189689 | 2020-11-22 | Australia | Queensland | 1196 | 6 | 1172 | 18 | -27.4698 | 153.0251 | 2020-11-23 05:25:26 | Queensland, Australia | ||
3836183 | 3836183 | 2020-11-21 | Australia | Queensland | 1193 | 6 | 1171 | 16 | -27.4698 | 153.0251 | 2020-11-22 05:25:45 | Queensland, Australia | ||
2701211 | 2701211 | 2020-11-20 | Australia | Queensland | 1192 | 6 | 1171 | 15 | -27.4698 | 153.0251 | 2020-11-21 05:25:51 | Queensland, Australia | ||
821271 | 821271 | 2020-11-19 | Australia | Queensland | 1190 | 6 | 1171 | 13 | -27.4698 | 153.0251 | 2020-11-20 05:26:28 | 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 | ||
3338293 | 3338293 | 2020-11-17 | Australia | Queensland | 1187 | 6 | 1171 | 10 | -27.4698 | 153.0251 | 2020-11-18 05:40:31 | Queensland, Australia | ||
3169338 | 3169338 | 2020-11-16 | Australia | Queensland | 1186 | 6 | 1171 | 9 | -27.4698 | 153.0251 | 2020-11-17 05:25:54 | Queensland, Australia | ||
2879906 | 2879906 | 2020-11-15 | Australia | Queensland | 1185 | 6 | 1171 | 8 | -27.4698 | 153.0251 | 2020-11-16 05:25:57 | Queensland, Australia | ||
2914884 | 2914884 | 2020-11-14 | Australia | Queensland | 1185 | 6 | 1171 | 8 | -27.4698 | 153.0251 | 2020-11-15 05:26:53 | Queensland, Australia | ||
2784706 | 2784706 | 2020-11-13 | Australia | Queensland | 1185 | 6 | 1171 | 8 | -27.4698 | 153.0251 | 2020-11-14 05:25:37 | 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]);