johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where country_or_region = "Australia" and province_or_state = "Australian Capital Territory" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069708 | 3069708 | 2021-11-23 | Australia | Australian Capital Territory | 2087 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-24 04:22:14 | Australian Capital Territory, Australia | |||
3748806 | 3748806 | 2021-11-22 | Australia | Australian Capital Territory | 2072 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-23 04:22:39 | Australian Capital Territory, Australia | |||
1014013 | 1014013 | 2021-11-21 | Australia | Australian Capital Territory | 2053 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-22 04:22:20 | Australian Capital Territory, Australia | |||
722177 | 722177 | 2021-11-20 | Australia | Australian Capital Territory | 2042 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-21 04:22:13 | Australian Capital Territory, Australia | |||
161707 | 161707 | 2021-11-19 | Australia | Australian Capital Territory | 2027 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-20 04:22:17 | Australian Capital Territory, Australia | |||
3288594 | 3288594 | 2021-11-18 | Australia | Australian Capital Territory | 2013 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-19 04:21:40 | Australian Capital Territory, Australia | |||
447050 | 447050 | 2021-11-17 | Australia | Australian Capital Territory | 1996 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-18 04:21:33 | Australian Capital Territory, Australia | |||
3342300 | 3342300 | 2021-11-16 | Australia | Australian Capital Territory | 1971 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-17 04:21:48 | Australian Capital Territory, Australia | |||
2287136 | 2287136 | 2021-11-15 | Australia | Australian Capital Territory | 1965 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-16 04:21:10 | Australian Capital Territory, Australia | |||
1321910 | 1321910 | 2021-11-14 | Australia | Australian Capital Territory | 1953 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-15 04:21:36 | Australian Capital Territory, Australia | |||
686036 | 686036 | 2021-11-13 | Australia | Australian Capital Territory | 1943 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-14 04:21:31 | Australian Capital Territory, Australia | |||
714145 | 714145 | 2021-11-12 | Australia | Australian Capital Territory | 1928 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-13 04:21:38 | Australian Capital Territory, Australia | |||
28095 | 28095 | 2021-11-11 | Australia | Australian Capital Territory | 1917 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-12 04:22:01 | Australian Capital Territory, Australia | |||
2844534 | 2844534 | 2021-11-10 | Australia | Australian Capital Territory | 1902 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-11 04:21:45 | Australian Capital Territory, Australia | |||
86804 | 86804 | 2021-11-09 | Australia | Australian Capital Territory | 1893 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-10 04:21:38 | Australian Capital Territory, Australia | |||
3639232 | 3639232 | 2021-11-08 | Australia | Australian Capital Territory | 1884 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-09 04:21:36 | Australian Capital Territory, Australia | |||
2000340 | 2000340 | 2021-11-07 | Australia | Australian Capital Territory | 1866 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-08 04:21:43 | Australian Capital Territory, Australia | |||
495331 | 495331 | 2021-11-06 | Australia | Australian Capital Territory | 1853 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-07 04:21:53 | Australian Capital Territory, Australia | |||
3121186 | 3121186 | 2021-11-05 | Australia | Australian Capital Territory | 1840 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-06 04:21:51 | Australian Capital Territory, Australia | |||
698084 | 698084 | 2021-11-04 | Australia | Australian Capital Territory | 1822 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-05 04:21:54 | Australian Capital Territory, Australia | |||
275862 | 275862 | 2021-11-03 | Australia | Australian Capital Territory | 1816 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-04 04:22:20 | Australian Capital Territory, Australia | |||
43387 | 43387 | 2021-11-02 | Australia | Australian Capital Territory | 1803 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-03 06:22:09 | Australian Capital Territory, Australia | |||
3511083 | 3511083 | 2021-11-01 | Australia | Australian Capital Territory | 1788 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-02 04:22:03 | Australian Capital Territory, Australia | |||
287675 | 287675 | 2021-10-31 | Australia | Australian Capital Territory | 1780 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-01 04:22:01 | Australian Capital Territory, Australia | |||
2720681 | 2720681 | 2021-10-30 | Australia | Australian Capital Territory | 1775 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-31 04:22:08 | Australian Capital Territory, Australia | |||
566783 | 566783 | 2021-10-29 | Australia | Australian Capital Territory | 1768 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-30 04:22:03 | Australian Capital Territory, Australia | |||
4025 | 4025 | 2021-10-28 | Australia | Australian Capital Territory | 1759 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-29 04:22:03 | Australian Capital Territory, Australia | |||
534415 | 534415 | 2021-10-27 | Australia | Australian Capital Territory | 1749 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-28 04:22:08 | Australian Capital Territory, Australia | |||
3491852 | 3491852 | 2021-10-26 | Australia | Australian Capital Territory | 1741 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-27 04:22:32 | Australian Capital Territory, Australia | |||
3793574 | 3793574 | 2021-10-25 | Australia | Australian Capital Territory | 1731 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-26 04:22:09 | Australian Capital Territory, Australia | |||
682020 | 682020 | 2021-10-24 | Australia | Australian Capital Territory | 1719 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-25 04:22:31 | Australian Capital Territory, Australia | |||
770028 | 770028 | 2021-10-23 | Australia | Australian Capital Territory | 1710 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-24 04:21:22 | Australian Capital Territory, Australia | |||
653675 | 653675 | 2021-10-22 | Australia | Australian Capital Territory | 1701 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-23 04:21:32 | Australian Capital Territory, Australia | |||
2123422 | 2123422 | 2021-10-21 | Australia | Australian Capital Territory | 1677 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-22 04:21:14 | Australian Capital Territory, Australia | |||
443034 | 443034 | 2021-10-20 | Australia | Australian Capital Territory | 1664 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-21 04:21:18 | Australian Capital Territory, Australia | |||
597353 | 597353 | 2021-10-19 | Australia | Australian Capital Territory | 1636 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-20 04:21:00 | Australian Capital Territory, Australia | |||
2043530 | 2043530 | 2021-10-18 | Australia | Australian Capital Territory | 1612 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-19 04:20:54 | Australian Capital Territory, Australia | |||
1908891 | 1908891 | 2021-10-17 | Australia | Australian Capital Territory | 1588 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-18 04:21:10 | Australian Capital Territory, Australia | |||
934480 | 934480 | 2021-10-16 | Australia | Australian Capital Territory | 1571 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-17 04:21:29 | Australian Capital Territory, Australia | |||
2943035 | 2943035 | 2021-10-15 | Australia | Australian Capital Territory | 1538 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-16 04:21:15 | Australian Capital Territory, Australia | |||
491315 | 491315 | 2021-10-14 | Australia | Australian Capital Territory | 1518 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-15 04:21:26 | Australian Capital Territory, Australia | |||
633603 | 633603 | 2021-10-13 | Australia | Australian Capital Territory | 1483 | 10 | 0 | -35.4735 | 149.0124 | 2021-10-14 04:21:29 | Australian Capital Territory, Australia | |||
1491281 | 1491281 | 2021-10-12 | Australia | Australian Capital Territory | 1437 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-13 04:20:51 | Australian Capital Territory, Australia | |||
3007014 | 3007014 | 2021-10-11 | Australia | Australian Capital Territory | 1386 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-12 04:21:09 | Australian Capital Territory, Australia | |||
423030 | 423030 | 2021-10-10 | Australia | Australian Capital Territory | 1358 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-11 04:21:31 | Australian Capital Territory, Australia | |||
2875887 | 2875887 | 2021-10-09 | Australia | Australian Capital Territory | 1326 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-10 04:21:38 | Australian Capital Territory, Australia | |||
2959053 | 2959053 | 2021-10-08 | Australia | Australian Capital Territory | 1296 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-09 04:21:34 | Australian Capital Territory, Australia | |||
467091 | 467091 | 2021-10-07 | Australia | Australian Capital Territory | 1271 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-08 04:21:25 | Australian Capital Territory, Australia | |||
2458471 | 2458471 | 2021-10-06 | Australia | Australian Capital Territory | 1231 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-07 04:21:36 | Australian Capital Territory, Australia | |||
3832165 | 3832165 | 2021-10-05 | Australia | Australian Capital Territory | 1190 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-06 04:21:33 | Australian Capital Territory, Australia | |||
986658 | 986658 | 2021-10-04 | Australia | Australian Capital Territory | 1162 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-05 04:21:27 | Australian Capital Territory, Australia | |||
1273968 | 1273968 | 2021-10-03 | Australia | Australian Capital Territory | 1129 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-04 04:21:31 | Australian Capital Territory, Australia | |||
3927721 | 3927721 | 2021-10-02 | Australia | Australian Capital Territory | 1101 | 6 | 0 | -35.4735 | 149.0124 | 2021-10-03 04:21:24 | Australian Capital Territory, Australia | |||
2131701 | 2131701 | 2021-10-01 | Australia | Australian Capital Territory | 1063 | 6 | 0 | -35.4735 | 149.0124 | 2021-10-02 04:21:25 | Australian Capital Territory, Australia | |||
2772658 | 2772658 | 2021-09-30 | Australia | Australian Capital Territory | 1011 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-01 04:21:35 | Australian Capital Territory, Australia | |||
706114 | 706114 | 2021-09-29 | Australia | Australian Capital Territory | 959 | 6 | 0 | -35.4735 | 149.0124 | 2021-09-30 04:21:20 | Australian Capital Territory, Australia | |||
1333956 | 1333956 | 2021-09-28 | Australia | Australian Capital Territory | 928 | 5 | 0 | -35.4735 | 149.0124 | 2021-09-29 04:21:45 | Australian Capital Territory, Australia | |||
1235325 | 1235325 | 2021-09-27 | Australia | Australian Capital Territory | 906 | 4 | 0 | -35.4735 | 149.0124 | 2021-09-28 04:21:28 | Australian Capital Territory, Australia | |||
2075626 | 2075626 | 2021-09-26 | Australia | Australian Capital Territory | 893 | 4 | 0 | -35.4735 | 149.0124 | 2021-09-27 04:21:16 | Australian Capital Territory, Australia | |||
1724178 | 1724178 | 2021-09-25 | Australia | Australian Capital Territory | 874 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-26 04:21:29 | Australian Capital Territory, Australia | |||
1920898 | 1920898 | 2021-09-24 | Australia | Australian Capital Territory | 849 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-25 04:21:31 | Australian Capital Territory, Australia | |||
601369 | 601369 | 2021-09-23 | Australia | Australian Capital Territory | 817 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-24 04:21:44 | Australian Capital Territory, Australia | |||
3011030 | 3011030 | 2021-09-22 | Australia | Australian Capital Territory | 798 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-23 04:21:43 | Australian Capital Territory, Australia | |||
3757168 | 3757168 | 2021-09-21 | Australia | Australian Capital Territory | 782 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-22 04:21:45 | Australian Capital Territory, Australia | |||
809271 | 809271 | 2021-09-20 | Australia | Australian Capital Territory | 765 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-21 04:21:26 | Australian Capital Territory, Australia | |||
1814470 | 1814470 | 2021-09-19 | Australia | Australian Capital Territory | 749 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-20 04:21:22 | Australian Capital Territory, Australia | |||
16050 | 16050 | 2021-09-18 | Australia | Australian Capital Territory | 742 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-19 04:21:34 | Australian Capital Territory, Australia | |||
2617735 | 2617735 | 2021-09-17 | Australia | Australian Capital Territory | 725 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-18 04:21:24 | Australian Capital Territory, Australia | |||
2808443 | 2808443 | 2021-09-16 | Australia | Australian Capital Territory | 710 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-17 04:21:46 | Australian Capital Territory, Australia | |||
1374188 | 1374188 | 2021-09-15 | Australia | Australian Capital Territory | 680 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-16 04:22:19 | Australian Capital Territory, Australia | |||
2462487 | 2462487 | 2021-09-14 | Australia | Australian Capital Territory | 665 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-15 03:22:37 | Australian Capital Territory, Australia | |||
1385326 | 1385326 | 2021-09-13 | Australia | Australian Capital Territory | 652 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-14 04:21:41 | Australian Capital Territory, Australia | |||
1884695 | 1884695 | 2021-09-12 | Australia | Australian Capital Territory | 630 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-13 04:21:15 | Australian Capital Territory, Australia | |||
3805598 | 3805598 | 2021-09-11 | Australia | Australian Capital Territory | 617 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-12 04:21:13 | Australian Capital Territory, Australia | |||
3448538 | 3448538 | 2021-09-10 | Australia | Australian Capital Territory | 602 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-11 04:21:30 | Australian Capital Territory, Australia | |||
1262484 | 1262484 | 2021-09-09 | Australia | Australian Capital Territory | 587 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-10 04:21:20 | Australian Capital Territory, Australia | |||
2278854 | 2278854 | 2021-09-08 | Australia | Australian Capital Territory | 563 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-09 04:21:27 | Australian Capital Territory, Australia | |||
641633 | 641633 | 2021-09-07 | Australia | Australian Capital Territory | 548 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-08 04:21:31 | Australian Capital Territory, Australia | |||
3193696 | 3193696 | 2021-09-06 | Australia | Australian Capital Territory | 528 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-07 04:21:35 | Australian Capital Territory, Australia | |||
3280564 | 3280564 | 2021-09-05 | Australia | Australian Capital Territory | 509 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-06 04:21:22 | Australian Capital Territory, Australia | |||
248978 | 248978 | 2021-09-04 | Australia | Australian Capital Territory | 498 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-05 04:21:33 | Australian Capital Territory, Australia | |||
3974259 | 3974259 | 2021-09-03 | Australia | Australian Capital Territory | 483 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-04 04:21:28 | Australian Capital Territory, Australia | |||
177721 | 177721 | 2021-09-02 | Australia | Australian Capital Territory | 451 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-03 04:21:20 | Australian Capital Territory, Australia | |||
66756 | 66756 | 2021-09-01 | Australia | Australian Capital Territory | 433 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-02 04:21:15 | Australian Capital Territory, Australia | |||
2067598 | 2067598 | 2021-08-31 | Australia | Australian Capital Territory | 421 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-01 04:21:38 | Australian Capital Territory, Australia | |||
1775052 | 1775052 | 2021-08-30 | Australia | Australian Capital Territory | 398 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-31 04:21:46 | Australian Capital Territory, Australia | |||
3891626 | 3891626 | 2021-08-29 | Australia | Australian Capital Territory | 386 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-30 04:21:23 | Australian Capital Territory, Australia | |||
2792729 | 2792729 | 2021-08-28 | Australia | Australian Capital Territory | 374 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-29 04:21:14 | Australian Capital Territory, Australia | |||
2922888 | 2922888 | 2021-08-27 | Australia | Australian Capital Territory | 361 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-28 04:21:28 | Australian Capital Territory, Australia | |||
1595902 | 1595902 | 2021-08-26 | Australia | Australian Capital Territory | 335 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-27 04:21:37 | Australian Capital Territory, Australia | |||
32111 | 32111 | 2021-08-25 | Australia | Australian Capital Territory | 314 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-26 04:21:28 | Australian Capital Territory, Australia | |||
3105150 | 3105150 | 2021-08-24 | Australia | Australian Capital Territory | 300 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-25 04:21:41 | Australian Capital Territory, Australia | |||
3165321 | 3165321 | 2021-08-23 | Australia | Australian Capital Territory | 291 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-24 04:21:19 | Australian Capital Territory, Australia | |||
2175248 | 2175248 | 2021-08-22 | Australia | Australian Capital Territory | 261 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-23 04:21:27 | Australian Capital Territory, Australia | |||
3555344 | 3555344 | 2021-08-21 | Australia | Australian Capital Territory | 245 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-22 04:21:29 | Australian Capital Territory, Australia | |||
1853686 | 1853686 | 2021-08-20 | Australia | Australian Capital Territory | 226 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-21 04:21:38 | Australian Capital Territory, Australia | |||
511393 | 511393 | 2021-08-19 | Australia | Australian Capital Territory | 219 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-20 04:21:33 | Australian Capital Territory, Australia | |||
2517872 | 2517872 | 2021-08-18 | Australia | Australian Capital Territory | 207 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-19 04:21:15 | Australian Capital Territory, Australia | |||
244964 | 244964 | 2021-08-17 | Australia | Australian Capital Territory | 191 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-18 04:21:35 | Australian Capital Territory, Australia | |||
1603927 | 1603927 | 2021-08-16 | Australia | Australian Capital Territory | 169 | 3 | 0 | -35.4735 | 149.0124 | 2021-08-17 04:21:49 | Australian Capital Territory, 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]);