johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,063 rows where country_or_region = "Australia" and province_or_state = "South Australia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069712 | 3069712 | 2021-11-23 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-24 04:22:14 | South Australia, Australia | |||
3748810 | 3748810 | 2021-11-22 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-23 04:22:39 | South Australia, Australia | |||
1014017 | 1014017 | 2021-11-21 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-22 04:22:20 | South Australia, Australia | |||
722181 | 722181 | 2021-11-20 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-21 04:22:13 | South Australia, Australia | |||
161711 | 161711 | 2021-11-19 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-20 04:22:17 | South Australia, Australia | |||
3288598 | 3288598 | 2021-11-18 | Australia | South Australia | 921 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-19 04:21:40 | South Australia, Australia | |||
447054 | 447054 | 2021-11-17 | Australia | South Australia | 921 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-18 04:21:33 | South Australia, Australia | |||
3342304 | 3342304 | 2021-11-16 | Australia | South Australia | 921 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-17 04:21:48 | South Australia, Australia | |||
2287140 | 2287140 | 2021-11-15 | Australia | South Australia | 920 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-16 04:21:10 | South Australia, Australia | |||
1321914 | 1321914 | 2021-11-14 | Australia | South Australia | 920 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-15 04:21:36 | South Australia, Australia | |||
686040 | 686040 | 2021-11-13 | Australia | South Australia | 920 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-14 04:21:31 | South Australia, Australia | |||
714149 | 714149 | 2021-11-12 | Australia | South Australia | 919 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-13 04:21:38 | South Australia, Australia | |||
28099 | 28099 | 2021-11-11 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-12 04:22:01 | South Australia, Australia | |||
2844538 | 2844538 | 2021-11-10 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-11 04:21:45 | South Australia, Australia | |||
86808 | 86808 | 2021-11-09 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-10 04:21:38 | South Australia, Australia | |||
3639236 | 3639236 | 2021-11-08 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-09 04:21:36 | South Australia, Australia | |||
2000344 | 2000344 | 2021-11-07 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-08 04:21:43 | South Australia, Australia | |||
495335 | 495335 | 2021-11-06 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-07 04:21:53 | South Australia, Australia | |||
3121190 | 3121190 | 2021-11-05 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-06 04:21:51 | South Australia, Australia | |||
698088 | 698088 | 2021-11-04 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-05 04:21:54 | South Australia, Australia | |||
275866 | 275866 | 2021-11-03 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-04 04:22:20 | South Australia, Australia | |||
43391 | 43391 | 2021-11-02 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-03 06:22:09 | South Australia, Australia | |||
3511087 | 3511087 | 2021-11-01 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-02 04:22:03 | South Australia, Australia | |||
287679 | 287679 | 2021-10-31 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-01 04:22:01 | South Australia, Australia | |||
2720685 | 2720685 | 2021-10-30 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-31 04:22:08 | South Australia, Australia | |||
566787 | 566787 | 2021-10-29 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-30 04:22:03 | South Australia, Australia | |||
4029 | 4029 | 2021-10-28 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-29 04:22:03 | South Australia, Australia | |||
534419 | 534419 | 2021-10-27 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-28 04:22:08 | South Australia, Australia | |||
3491856 | 3491856 | 2021-10-26 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-27 04:22:32 | South Australia, Australia | |||
3793578 | 3793578 | 2021-10-25 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-26 04:22:09 | South Australia, Australia | |||
682024 | 682024 | 2021-10-24 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-25 04:22:31 | South Australia, Australia | |||
770032 | 770032 | 2021-10-23 | Australia | South Australia | 917 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-24 04:21:22 | South Australia, Australia | |||
653679 | 653679 | 2021-10-22 | Australia | South Australia | 917 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-23 04:21:32 | South Australia, Australia | |||
2123426 | 2123426 | 2021-10-21 | Australia | South Australia | 917 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-22 04:21:14 | South Australia, Australia | |||
443038 | 443038 | 2021-10-20 | Australia | South Australia | 916 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-21 04:21:18 | South Australia, Australia | |||
597357 | 597357 | 2021-10-19 | Australia | South Australia | 916 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-20 04:21:00 | South Australia, Australia | |||
2043534 | 2043534 | 2021-10-18 | Australia | South Australia | 915 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-19 04:20:54 | South Australia, Australia | |||
1908895 | 1908895 | 2021-10-17 | Australia | South Australia | 915 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-18 04:21:10 | South Australia, Australia | |||
934484 | 934484 | 2021-10-16 | Australia | South Australia | 915 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-17 04:21:29 | South Australia, Australia | |||
2943039 | 2943039 | 2021-10-15 | Australia | South Australia | 914 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-16 04:21:15 | South Australia, Australia | |||
491319 | 491319 | 2021-10-14 | Australia | South Australia | 914 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-15 04:21:26 | South Australia, Australia | |||
633607 | 633607 | 2021-10-13 | Australia | South Australia | 914 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-14 04:21:29 | South Australia, Australia | |||
1491285 | 1491285 | 2021-10-12 | Australia | South Australia | 914 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-13 04:20:51 | South Australia, Australia | |||
3007018 | 3007018 | 2021-10-11 | Australia | South Australia | 913 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-12 04:21:09 | South Australia, Australia | |||
423034 | 423034 | 2021-10-10 | Australia | South Australia | 910 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-11 04:21:31 | South Australia, Australia | |||
2875891 | 2875891 | 2021-10-09 | Australia | South Australia | 909 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-10 04:21:38 | South Australia, Australia | |||
2959057 | 2959057 | 2021-10-08 | Australia | South Australia | 908 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-09 04:21:34 | South Australia, Australia | |||
467095 | 467095 | 2021-10-07 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-08 04:21:25 | South Australia, Australia | |||
2458475 | 2458475 | 2021-10-06 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-07 04:21:36 | South Australia, Australia | |||
3832169 | 3832169 | 2021-10-05 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-06 04:21:33 | South Australia, Australia | |||
986662 | 986662 | 2021-10-04 | Australia | South Australia | 906 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-05 04:21:27 | South Australia, Australia | |||
1273972 | 1273972 | 2021-10-03 | Australia | South Australia | 905 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-04 04:21:31 | South Australia, Australia | |||
3927725 | 3927725 | 2021-10-02 | Australia | South Australia | 904 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-03 04:21:24 | South Australia, Australia | |||
2131705 | 2131705 | 2021-10-01 | Australia | South Australia | 902 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-02 04:21:25 | South Australia, Australia | |||
2772662 | 2772662 | 2021-09-30 | Australia | South Australia | 901 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-01 04:21:35 | South Australia, Australia | |||
706118 | 706118 | 2021-09-29 | Australia | South Australia | 901 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-30 04:21:20 | South Australia, Australia | |||
1333960 | 1333960 | 2021-09-28 | Australia | South Australia | 901 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-29 04:21:45 | South Australia, Australia | |||
1235329 | 1235329 | 2021-09-27 | Australia | South Australia | 901 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-28 04:21:28 | South Australia, Australia | |||
2075630 | 2075630 | 2021-09-26 | Australia | South Australia | 901 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-27 04:21:16 | South Australia, Australia | |||
1724182 | 1724182 | 2021-09-25 | Australia | South Australia | 900 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-26 04:21:29 | South Australia, Australia | |||
1920902 | 1920902 | 2021-09-24 | Australia | South Australia | 900 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-25 04:21:31 | South Australia, Australia | |||
601373 | 601373 | 2021-09-23 | Australia | South Australia | 900 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-24 04:21:44 | South Australia, Australia | |||
3011034 | 3011034 | 2021-09-22 | Australia | South Australia | 899 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-23 04:21:43 | South Australia, Australia | |||
3757172 | 3757172 | 2021-09-21 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-22 04:21:45 | South Australia, Australia | |||
809275 | 809275 | 2021-09-20 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-21 04:21:26 | South Australia, Australia | |||
1814474 | 1814474 | 2021-09-19 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-20 04:21:22 | South Australia, Australia | |||
16054 | 16054 | 2021-09-18 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-19 04:21:34 | South Australia, Australia | |||
2617739 | 2617739 | 2021-09-17 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-18 04:21:24 | South Australia, Australia | |||
2808447 | 2808447 | 2021-09-16 | Australia | South Australia | 898 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-17 04:21:46 | South Australia, Australia | |||
1374192 | 1374192 | 2021-09-15 | Australia | South Australia | 896 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-16 04:22:19 | South Australia, Australia | |||
2462491 | 2462491 | 2021-09-14 | Australia | South Australia | 896 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-15 03:22:37 | South Australia, Australia | |||
1385330 | 1385330 | 2021-09-13 | Australia | South Australia | 895 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-14 04:21:41 | South Australia, Australia | |||
1884699 | 1884699 | 2021-09-12 | Australia | South Australia | 894 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-13 04:21:15 | South Australia, Australia | |||
3805602 | 3805602 | 2021-09-11 | Australia | South Australia | 892 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-12 04:21:13 | South Australia, Australia | |||
3448542 | 3448542 | 2021-09-10 | Australia | South Australia | 891 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-11 04:21:30 | South Australia, Australia | |||
1262488 | 1262488 | 2021-09-09 | Australia | South Australia | 891 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-10 04:21:20 | South Australia, Australia | |||
2278858 | 2278858 | 2021-09-08 | Australia | South Australia | 889 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-09 04:21:27 | South Australia, Australia | |||
641637 | 641637 | 2021-09-07 | Australia | South Australia | 888 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-08 04:21:31 | South Australia, Australia | |||
3193700 | 3193700 | 2021-09-06 | Australia | South Australia | 881 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-07 04:21:35 | South Australia, Australia | |||
3280568 | 3280568 | 2021-09-05 | Australia | South Australia | 880 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-06 04:21:22 | South Australia, Australia | |||
248982 | 248982 | 2021-09-04 | Australia | South Australia | 879 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-05 04:21:33 | South Australia, Australia | |||
3974263 | 3974263 | 2021-09-03 | Australia | South Australia | 877 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-04 04:21:28 | South Australia, Australia | |||
177725 | 177725 | 2021-09-02 | Australia | South Australia | 875 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-03 04:21:20 | South Australia, Australia | |||
66760 | 66760 | 2021-09-01 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-02 04:21:15 | South Australia, Australia | |||
2067602 | 2067602 | 2021-08-31 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-01 04:21:38 | South Australia, Australia | |||
1775056 | 1775056 | 2021-08-30 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-31 04:21:46 | South Australia, Australia | |||
3891630 | 3891630 | 2021-08-29 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-30 04:21:23 | South Australia, Australia | |||
2792733 | 2792733 | 2021-08-28 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-29 04:21:14 | South Australia, Australia | |||
2922892 | 2922892 | 2021-08-27 | Australia | South Australia | 870 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-28 04:21:28 | South Australia, Australia | |||
1595906 | 1595906 | 2021-08-26 | Australia | South Australia | 870 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-27 04:21:37 | South Australia, Australia | |||
32115 | 32115 | 2021-08-25 | Australia | South Australia | 870 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-26 04:21:28 | South Australia, Australia | |||
3105154 | 3105154 | 2021-08-24 | Australia | South Australia | 870 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-25 04:21:41 | South Australia, Australia | |||
3165325 | 3165325 | 2021-08-23 | Australia | South Australia | 870 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-24 04:21:19 | South Australia, Australia | |||
2175252 | 2175252 | 2021-08-22 | Australia | South Australia | 869 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-23 04:21:27 | South Australia, Australia | |||
3555348 | 3555348 | 2021-08-21 | Australia | South Australia | 869 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-22 04:21:29 | South Australia, Australia | |||
1853690 | 1853690 | 2021-08-20 | Australia | South Australia | 869 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-21 04:21:38 | South Australia, Australia | |||
511397 | 511397 | 2021-08-19 | Australia | South Australia | 869 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-20 04:21:33 | South Australia, Australia | |||
2517876 | 2517876 | 2021-08-18 | Australia | South Australia | 868 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-19 04:21:15 | South Australia, Australia | |||
244968 | 244968 | 2021-08-17 | Australia | South Australia | 868 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-18 04:21:35 | South Australia, Australia | |||
1603931 | 1603931 | 2021-08-16 | Australia | South Australia | 868 | 4 | 0 | -34.9285 | 138.6007 | 2021-08-17 04:21:49 | South Australia, 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]);