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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
742013 | 742013 | 2021-02-20 | Australia | South Australia | 610 | 4 | 602 | 4 | -34.9285 | 138.6007 | 2021-02-21 05:24:33 | South Australia, Australia | ||
471111 | 471111 | 2021-02-19 | Australia | South Australia | 608 | 4 | 602 | 2 | -34.9285 | 138.6007 | 2021-02-20 05:22:51 | South Australia, Australia | ||
1152821 | 1152821 | 2021-02-18 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-19 05:24:16 | South Australia, Australia | ||
3600741 | 3600741 | 2021-02-17 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-18 05:22:58 | South Australia, Australia | ||
3049876 | 3049876 | 2021-02-16 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-17 05:23:10 | South Australia, Australia | ||
1337975 | 1337975 | 2021-02-15 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-16 05:24:38 | South Australia, Australia | ||
2283126 | 2283126 | 2021-02-14 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-15 05:24:49 | South Australia, Australia | ||
2677526 | 2677526 | 2021-02-13 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-14 05:23:43 | South Australia, Australia | ||
3539159 | 3539159 | 2021-02-12 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-13 05:22:12 | South Australia, Australia | ||
2637422 | 2637422 | 2021-02-11 | Australia | South Australia | 606 | 4 | 597 | 5 | -34.9285 | 138.6007 | 2021-02-12 05:23:29 | South Australia, Australia | ||
3978277 | 3978277 | 2021-02-10 | Australia | South Australia | 606 | 4 | 597 | 5 | -34.9285 | 138.6007 | 2021-02-11 05:23:55 | South Australia, Australia | ||
1527597 | 1527597 | 2021-02-09 | Australia | South Australia | 605 | 4 | 597 | 4 | -34.9285 | 138.6007 | 2021-02-10 05:22:41 | South Australia, Australia | ||
613388 | 613388 | 2021-02-08 | Australia | South Australia | 603 | 4 | 596 | 3 | -34.9285 | 138.6007 | 2021-02-09 05:23:30 | South Australia, Australia | ||
1672157 | 1672157 | 2021-02-07 | Australia | South Australia | 603 | 4 | 596 | 3 | -34.9285 | 138.6007 | 2021-02-08 05:22:39 | South Australia, Australia | ||
974618 | 974618 | 2021-02-06 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-07 05:23:00 | South Australia, Australia | ||
1587876 | 1587876 | 2021-02-05 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-06 05:23:55 | South Australia, Australia | ||
790083 | 790083 | 2021-02-04 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-05 05:22:38 | South Australia, Australia | ||
339975 | 339975 | 2021-02-03 | Australia | South Australia | 601 | 4 | 595 | 2 | -34.9285 | 138.6007 | 2021-02-04 05:22:26 | South Australia, Australia | ||
1684201 | 1684201 | 2021-02-02 | Australia | South Australia | 601 | 4 | 592 | 5 | -34.9285 | 138.6007 | 2021-02-03 05:22:52 | South Australia, Australia | ||
1676171 | 1676171 | 2021-02-01 | Australia | South Australia | 597 | 4 | 592 | 1 | -34.9285 | 138.6007 | 2021-02-02 05:22:49 | South Australia, Australia | ||
1459459 | 1459459 | 2021-01-31 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-02-01 05:22:53 | South Australia, Australia | ||
2211367 | 2211367 | 2021-01-30 | Australia | South Australia | 597 | 4 | 592 | 1 | -34.9285 | 138.6007 | 2021-01-31 05:22:42 | South Australia, Australia | ||
1896854 | 1896854 | 2021-01-29 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-30 05:22:49 | South Australia, Australia | ||
2481670 | 2481670 | 2021-01-28 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-29 05:22:23 | South Australia, Australia | ||
3153305 | 3153305 | 2021-01-27 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-28 05:22:24 | South Australia, Australia | ||
12040 | 12040 | 2021-01-26 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-27 05:23:41 | South Australia, Australia | ||
2567364 | 2567364 | 2021-01-25 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-26 05:22:02 | South Australia, Australia | ||
1758996 | 1758996 | 2021-01-24 | Australia | South Australia | 596 | 4 | 591 | 1 | -34.9285 | 138.6007 | 2021-01-25 05:22:16 | South Australia, Australia | ||
2426603 | 2426603 | 2021-01-23 | Australia | South Australia | 596 | 4 | 591 | 1 | -34.9285 | 138.6007 | 2021-01-24 05:22:35 | South Australia, Australia | ||
2466505 | 2466505 | 2021-01-22 | Australia | South Australia | 596 | 4 | 590 | 2 | -34.9285 | 138.6007 | 2021-01-23 05:22:03 | South Australia, Australia | ||
435056 | 435056 | 2021-01-21 | Australia | South Australia | 596 | 4 | 587 | 5 | -34.9285 | 138.6007 | 2021-01-22 05:22:10 | South Australia, Australia | ||
1093788 | 1093788 | 2021-01-20 | Australia | South Australia | 596 | 4 | 587 | 5 | -34.9285 | 138.6007 | 2021-01-21 05:22:01 | South Australia, Australia | ||
907878 | 907878 | 2021-01-19 | Australia | South Australia | 594 | 4 | 584 | 6 | -34.9285 | 138.6007 | 2021-01-20 05:21:54 | South Australia, Australia | ||
236941 | 236941 | 2021-01-18 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-19 05:22:15 | South Australia, Australia | ||
3503058 | 3503058 | 2021-01-17 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-18 05:22:34 | South Australia, Australia | ||
3101141 | 3101141 | 2021-01-16 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-17 05:22:17 | South Australia, Australia | ||
3515103 | 3515103 | 2021-01-15 | Australia | South Australia | 593 | 4 | 577 | 12 | -34.9285 | 138.6007 | 2021-01-16 05:22:40 | South Australia, Australia | ||
3879276 | 3879276 | 2021-01-14 | Australia | South Australia | 591 | 4 | 577 | 10 | -34.9285 | 138.6007 | 2021-01-15 05:22:24 | South Australia, Australia | ||
3307903 | 3307903 | 2021-01-13 | Australia | South Australia | 590 | 4 | 575 | 11 | -34.9285 | 138.6007 | 2021-01-14 05:22:32 | South Australia, Australia | ||
774048 | 774048 | 2021-01-12 | Australia | South Australia | 590 | 4 | 574 | 12 | -34.9285 | 138.6007 | 2021-01-13 05:22:15 | South Australia, Australia | ||
189769 | 189769 | 2021-01-11 | Australia | South Australia | 588 | 4 | 569 | 15 | -34.9285 | 138.6007 | 2021-01-12 05:22:15 | South Australia, Australia | ||
2625572 | 2625572 | 2021-01-10 | Australia | South Australia | 588 | 4 | 569 | 15 | -34.9285 | 138.6007 | 2021-01-11 05:21:50 | South Australia, Australia | ||
3899660 | 3899660 | 2021-01-09 | Australia | South Australia | 587 | 4 | 568 | 15 | -34.9285 | 138.6007 | 2021-01-10 05:22:12 | South Australia, Australia | ||
153683 | 153683 | 2021-01-08 | Australia | South Australia | 587 | 4 | 568 | 15 | -34.9285 | 138.6007 | 2021-01-09 05:22:18 | South Australia, Australia | ||
2541107 | 2541107 | 2021-01-07 | Australia | South Australia | 585 | 4 | 569 | 12 | -34.9285 | 138.6007 | 2021-01-08 05:22:42 | South Australia, Australia | ||
2864416 | 2864416 | 2021-01-06 | Australia | South Australia | 582 | 4 | 568 | 10 | -34.9285 | 138.6007 | 2021-01-07 05:22:03 | South Australia, Australia | ||
3034003 | 3034003 | 2021-01-05 | Australia | South Australia | 582 | 4 | 567 | 11 | -34.9285 | 138.6007 | 2021-01-06 05:22:16 | South Australia, Australia | ||
1061548 | 1061548 | 2021-01-04 | Australia | South Australia | 581 | 4 | 566 | 11 | -34.9285 | 138.6007 | 2021-01-05 05:21:49 | South Australia, Australia | ||
3230151 | 3230151 | 2021-01-03 | Australia | South Australia | 583 | 4 | 566 | 13 | -34.9285 | 138.6007 | 2021-01-04 05:22:02 | South Australia, Australia | ||
2227221 | 2227221 | 2021-01-02 | Australia | South Australia | 580 | 4 | 566 | 10 | -34.9285 | 138.6007 | 2021-01-03 05:22:52 | South Australia, Australia | ||
1136585 | 1136585 | 2021-01-01 | Australia | South Australia | 580 | 4 | 566 | 10 | -34.9285 | 138.6007 | 2021-01-02 05:22:33 | South Australia, Australia | ||
3695191 | 3695191 | 2020-12-31 | Australia | South Australia | 580 | 4 | 565 | 11 | -34.9285 | 138.6007 | 2021-01-01 05:23:07 | South Australia, Australia | ||
1010006 | 1010006 | 2020-12-30 | Australia | South Australia | 576 | 4 | 565 | 7 | -34.9285 | 138.6007 | 2020-12-31 05:22:49 | South Australia, Australia | ||
766021 | 766021 | 2020-12-29 | Australia | South Australia | 575 | 4 | 563 | 8 | -34.9285 | 138.6007 | 2020-12-30 05:22:34 | South Australia, Australia | ||
3761285 | 3761285 | 2020-12-28 | Australia | South Australia | 572 | 4 | 563 | 5 | -34.9285 | 138.6007 | 2020-12-29 05:22:37 | South Australia, Australia | ||
3777605 | 3777605 | 2020-12-27 | Australia | South Australia | 572 | 4 | 563 | 5 | -34.9285 | 138.6007 | 2020-12-28 05:22:06 | South Australia, Australia | ||
2223210 | 2223210 | 2020-12-26 | Australia | South Australia | 569 | 4 | 562 | 3 | -34.9285 | 138.6007 | 2020-12-27 05:22:55 | South Australia, Australia | ||
201957 | 201957 | 2020-12-25 | Australia | South Australia | 569 | 4 | 562 | 3 | -34.9285 | 138.6007 | 2020-12-26 05:22:28 | South Australia, Australia | ||
3691180 | 3691180 | 2020-12-24 | Australia | South Australia | 568 | 4 | 560 | 4 | -34.9285 | 138.6007 | 2020-12-25 05:22:48 | South Australia, Australia | ||
2406532 | 2406532 | 2020-12-23 | Australia | South Australia | 568 | 4 | 560 | 4 | -34.9285 | 138.6007 | 2020-12-24 05:23:04 | South Australia, Australia | ||
3769578 | 3769578 | 2020-12-22 | Australia | South Australia | 566 | 4 | 559 | 3 | -34.9285 | 138.6007 | 2020-12-23 05:22:03 | South Australia, Australia | ||
927394 | 927394 | 2020-12-21 | Australia | South Australia | 566 | 4 | 559 | 3 | -34.9285 | 138.6007 | 2020-12-22 05:22:33 | South Australia, Australia | ||
2119415 | 2119415 | 2020-12-20 | Australia | South Australia | 566 | 4 | 559 | 3 | -34.9285 | 138.6007 | 2020-12-21 05:27:58 | South Australia, Australia | ||
2930922 | 2930922 | 2020-12-19 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-20 05:27:32 | South Australia, Australia | ||
1900868 | 1900868 | 2020-12-18 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-19 05:27:52 | South Australia, Australia | ||
2127694 | 2127694 | 2020-12-17 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-18 05:28:18 | South Australia, Australia | ||
3149294 | 3149294 | 2020-12-16 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-17 05:28:12 | South Australia, Australia | ||
1034075 | 1034075 | 2020-12-15 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-16 05:28:04 | South Australia, Australia | ||
1750969 | 1750969 | 2020-12-14 | Australia | South Australia | 563 | 4 | 559 | 0 | -34.9285 | 138.6007 | 2020-12-15 05:26:38 | South Australia, Australia | ||
3847489 | 3847489 | 2020-12-13 | Australia | South Australia | 563 | 4 | 558 | 1 | -34.9285 | 138.6007 | 2020-12-14 05:26:27 | South Australia, Australia | ||
845271 | 845271 | 2020-12-12 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-13 05:27:20 | South Australia, Australia | ||
860378 | 860378 | 2020-12-11 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-12 05:26:19 | South Australia, Australia | ||
1599920 | 1599920 | 2020-12-10 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-11 05:26:59 | South Australia, Australia | ||
2974929 | 2974929 | 2020-12-09 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-10 05:26:19 | South Australia, Australia | ||
1818489 | 1818489 | 2020-12-08 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-09 05:28:01 | South Australia, Australia | ||
2347125 | 2347125 | 2020-12-07 | Australia | South Australia | 562 | 4 | 558 | 0 | -34.9285 | 138.6007 | 2020-12-08 05:27:42 | South Australia, Australia | ||
1005995 | 1005995 | 2020-12-06 | Australia | South Australia | 562 | 4 | 556 | 2 | -34.9285 | 138.6007 | 2020-12-07 05:26:14 | South Australia, Australia | ||
1632004 | 1632004 | 2020-12-05 | Australia | South Australia | 562 | 4 | 553 | 5 | -34.9285 | 138.6007 | 2020-12-06 05:26:18 | South Australia, Australia | ||
3859532 | 3859532 | 2020-12-04 | Australia | South Australia | 562 | 4 | 551 | 7 | -34.9285 | 138.6007 | 2020-12-05 05:27:36 | South Australia, Australia | ||
74790 | 74790 | 2020-12-03 | Australia | South Australia | 562 | 4 | 551 | 7 | -34.9285 | 138.6007 | 2020-12-04 05:27:27 | South Australia, Australia | ||
738002 | 738002 | 2020-12-02 | Australia | South Australia | 562 | 4 | 549 | 9 | -34.9285 | 138.6007 | 2020-12-03 05:28:22 | South Australia, Australia | ||
2537096 | 2537096 | 2020-12-01 | Australia | South Australia | 562 | 4 | 548 | 10 | -34.9285 | 138.6007 | 2020-12-02 05:27:41 | South Australia, Australia | ||
1583865 | 1583865 | 2020-11-30 | Australia | South Australia | 562 | 4 | 547 | 11 | -34.9285 | 138.6007 | 2020-12-01 05:26:18 | South Australia, Australia | ||
3566268 | 3566268 | 2020-11-29 | Australia | South Australia | 562 | 4 | 541 | 17 | -34.9285 | 138.6007 | 2020-11-30 05:26:13 | South Australia, Australia | ||
2934933 | 2934933 | 2020-11-28 | Australia | South Australia | 561 | 4 | 540 | 17 | -34.9285 | 138.6007 | 2020-11-29 05:25:55 | South Australia, Australia | ||
391936 | 391936 | 2020-11-27 | Australia | South Australia | 562 | 4 | 539 | 19 | -34.9285 | 138.6007 | 2020-11-28 05:25:50 | South Australia, Australia | ||
923383 | 923383 | 2020-11-26 | Australia | South Australia | 559 | 4 | 533 | 22 | -34.9285 | 138.6007 | 2020-11-27 05:26:53 | South Australia, Australia | ||
1972288 | 1972288 | 2020-11-25 | Australia | South Australia | 560 | 4 | 520 | 36 | -34.9285 | 138.6007 | 2020-11-26 05:27:44 | South Australia, Australia | ||
1350019 | 1350019 | 2020-11-24 | Australia | South Australia | 558 | 4 | 516 | 38 | -34.9285 | 138.6007 | 2020-11-25 05:27:20 | South Australia, Australia | ||
678014 | 678014 | 2020-11-23 | Australia | South Australia | 557 | 4 | 514 | 39 | -34.9285 | 138.6007 | 2020-11-24 05:27:31 | South Australia, Australia | ||
3189690 | 3189690 | 2020-11-22 | Australia | South Australia | 556 | 4 | 514 | 38 | -34.9285 | 138.6007 | 2020-11-23 05:25:26 | South Australia, Australia | ||
3836184 | 3836184 | 2020-11-21 | Australia | South Australia | 555 | 4 | 514 | 37 | -34.9285 | 138.6007 | 2020-11-22 05:25:45 | South Australia, Australia | ||
2701212 | 2701212 | 2020-11-20 | Australia | South Australia | 554 | 4 | 513 | 37 | -34.9285 | 138.6007 | 2020-11-21 05:25:51 | South Australia, Australia | ||
821272 | 821272 | 2020-11-19 | Australia | South Australia | 553 | 4 | 512 | 37 | -34.9285 | 138.6007 | 2020-11-20 05:26:28 | South Australia, Australia | ||
122406 | 122406 | 2020-11-18 | Australia | South Australia | 551 | 4 | 512 | 35 | -34.9285 | 138.6007 | 2020-11-19 05:25:23 | South Australia, Australia | ||
3338294 | 3338294 | 2020-11-17 | Australia | South Australia | 551 | 4 | 511 | 36 | -34.9285 | 138.6007 | 2020-11-18 05:40:31 | South Australia, Australia | ||
3169339 | 3169339 | 2020-11-16 | Australia | South Australia | 547 | 4 | 506 | 37 | -34.9285 | 138.6007 | 2020-11-17 05:25:54 | South Australia, Australia | ||
2879907 | 2879907 | 2020-11-15 | Australia | South Australia | 544 | 4 | 495 | 45 | -34.9285 | 138.6007 | 2020-11-16 05:25:57 | South Australia, Australia | ||
2914885 | 2914885 | 2020-11-14 | Australia | South Australia | 522 | 4 | 495 | 23 | -34.9285 | 138.6007 | 2020-11-15 05:26:53 | South Australia, Australia | ||
2784707 | 2784707 | 2020-11-13 | Australia | South Australia | 517 | 4 | 495 | 18 | -34.9285 | 138.6007 | 2020-11-14 05:25:37 | 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]);