johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,068 rows where country_or_region = "Australia" and province_or_state = "New South Wales" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069709 | 3069709 | 2021-11-23 | Australia | New South Wales | 80408 | 625 | 0 | -33.8688 | 151.2093 | 2021-11-24 04:22:14 | New South Wales, Australia | |||
3748807 | 3748807 | 2021-11-22 | Australia | New South Wales | 80163 | 623 | 0 | -33.8688 | 151.2093 | 2021-11-23 04:22:39 | New South Wales, Australia | |||
1014014 | 1014014 | 2021-11-21 | Australia | New South Wales | 79997 | 621 | 0 | -33.8688 | 151.2093 | 2021-11-22 04:22:20 | New South Wales, Australia | |||
722178 | 722178 | 2021-11-20 | Australia | New South Wales | 79821 | 620 | 0 | -33.8688 | 151.2093 | 2021-11-21 04:22:13 | New South Wales, Australia | |||
161708 | 161708 | 2021-11-19 | Australia | New South Wales | 79646 | 618 | 0 | -33.8688 | 151.2093 | 2021-11-20 04:22:17 | New South Wales, Australia | |||
3288595 | 3288595 | 2021-11-18 | Australia | New South Wales | 79468 | 618 | 0 | -33.8688 | 151.2093 | 2021-11-19 04:21:40 | New South Wales, Australia | |||
447051 | 447051 | 2021-11-17 | Australia | New South Wales | 79254 | 615 | 0 | -33.8688 | 151.2093 | 2021-11-18 04:21:33 | New South Wales, Australia | |||
3342301 | 3342301 | 2021-11-16 | Australia | New South Wales | 78994 | 612 | 0 | -33.8688 | 151.2093 | 2021-11-17 04:21:48 | New South Wales, Australia | |||
2287137 | 2287137 | 2021-11-15 | Australia | New South Wales | 78766 | 612 | 0 | -33.8688 | 151.2093 | 2021-11-16 04:21:10 | New South Wales, Australia | |||
1321911 | 1321911 | 2021-11-14 | Australia | New South Wales | 78556 | 610 | 0 | -33.8688 | 151.2093 | 2021-11-15 04:21:36 | New South Wales, Australia | |||
686037 | 686037 | 2021-11-13 | Australia | New South Wales | 78393 | 609 | 0 | -33.8688 | 151.2093 | 2021-11-14 04:21:31 | New South Wales, Australia | |||
714146 | 714146 | 2021-11-12 | Australia | New South Wales | 78200 | 608 | 0 | -33.8688 | 151.2093 | 2021-11-13 04:21:38 | New South Wales, Australia | |||
28096 | 28096 | 2021-11-11 | Australia | New South Wales | 77951 | 608 | 0 | -33.8688 | 151.2093 | 2021-11-12 04:22:01 | New South Wales, Australia | |||
2844535 | 2844535 | 2021-11-10 | Australia | New South Wales | 77671 | 606 | 0 | -33.8688 | 151.2093 | 2021-11-11 04:21:45 | New South Wales, Australia | |||
86805 | 86805 | 2021-11-09 | Australia | New South Wales | 77417 | 605 | 0 | -33.8688 | 151.2093 | 2021-11-10 04:21:38 | New South Wales, Australia | |||
3639233 | 3639233 | 2021-11-08 | Australia | New South Wales | 77207 | 602 | 0 | -33.8688 | 151.2093 | 2021-11-09 04:21:36 | New South Wales, Australia | |||
2000341 | 2000341 | 2021-11-07 | Australia | New South Wales | 76988 | 598 | 0 | -33.8688 | 151.2093 | 2021-11-08 04:21:43 | New South Wales, Australia | |||
495332 | 495332 | 2021-11-06 | Australia | New South Wales | 76824 | 591 | 0 | -33.8688 | 151.2093 | 2021-11-07 04:21:53 | New South Wales, Australia | |||
3121187 | 3121187 | 2021-11-05 | Australia | New South Wales | 76580 | 590 | 0 | -33.8688 | 151.2093 | 2021-11-06 04:21:51 | New South Wales, Australia | |||
698085 | 698085 | 2021-11-04 | Australia | New South Wales | 76314 | 587 | 0 | -33.8688 | 151.2093 | 2021-11-05 04:21:54 | New South Wales, Australia | |||
275863 | 275863 | 2021-11-03 | Australia | New South Wales | 76073 | 584 | 0 | -33.8688 | 151.2093 | 2021-11-04 04:22:20 | New South Wales, Australia | |||
43388 | 43388 | 2021-11-02 | Australia | New South Wales | 75766 | 580 | 0 | -33.8688 | 151.2093 | 2021-11-03 06:22:09 | New South Wales, Australia | |||
3511084 | 3511084 | 2021-11-01 | Australia | New South Wales | 75578 | 576 | 0 | -33.8688 | 151.2093 | 2021-11-02 04:22:03 | New South Wales, Australia | |||
287676 | 287676 | 2021-10-31 | Australia | New South Wales | 75407 | 572 | 0 | -33.8688 | 151.2093 | 2021-11-01 04:22:01 | New South Wales, Australia | |||
2720682 | 2720682 | 2021-10-30 | Australia | New South Wales | 75278 | 568 | 0 | -33.8688 | 151.2093 | 2021-10-31 04:22:08 | New South Wales, Australia | |||
566784 | 566784 | 2021-10-29 | Australia | New South Wales | 75112 | 567 | 0 | -33.8688 | 151.2093 | 2021-10-30 04:22:03 | New South Wales, Australia | |||
4026 | 4026 | 2021-10-28 | Australia | New South Wales | 74887 | 564 | 0 | -33.8688 | 151.2093 | 2021-10-29 04:22:03 | New South Wales, Australia | |||
534416 | 534416 | 2021-10-27 | Australia | New South Wales | 74634 | 562 | 0 | -33.8688 | 151.2093 | 2021-10-28 04:22:08 | New South Wales, Australia | |||
3491853 | 3491853 | 2021-10-26 | Australia | New South Wales | 74362 | 560 | 0 | -33.8688 | 151.2093 | 2021-10-27 04:22:32 | New South Wales, Australia | |||
3793575 | 3793575 | 2021-10-25 | Australia | New South Wales | 74057 | 557 | 0 | -33.8688 | 151.2093 | 2021-10-26 04:22:09 | New South Wales, Australia | |||
682021 | 682021 | 2021-10-24 | Australia | New South Wales | 73785 | 556 | 0 | -33.8688 | 151.2093 | 2021-10-25 04:22:31 | New South Wales, Australia | |||
770029 | 770029 | 2021-10-23 | Australia | New South Wales | 73500 | 552 | 0 | -33.8688 | 151.2093 | 2021-10-24 04:21:22 | New South Wales, Australia | |||
653676 | 653676 | 2021-10-22 | Australia | New South Wales | 73212 | 548 | 0 | -33.8688 | 151.2093 | 2021-10-23 04:21:32 | New South Wales, Australia | |||
2123423 | 2123423 | 2021-10-21 | Australia | New South Wales | 72899 | 546 | 0 | -33.8688 | 151.2093 | 2021-10-22 04:21:14 | New South Wales, Australia | |||
443035 | 443035 | 2021-10-20 | Australia | New South Wales | 72560 | 541 | 0 | -33.8688 | 151.2093 | 2021-10-21 04:21:18 | New South Wales, Australia | |||
597354 | 597354 | 2021-10-19 | Australia | New South Wales | 72202 | 540 | 0 | -33.8688 | 151.2093 | 2021-10-20 04:21:00 | New South Wales, Australia | |||
2043531 | 2043531 | 2021-10-18 | Australia | New South Wales | 71923 | 533 | 0 | -33.8688 | 151.2093 | 2021-10-19 04:20:54 | New South Wales, Australia | |||
1908892 | 1908892 | 2021-10-17 | Australia | New South Wales | 71658 | 529 | 0 | -33.8688 | 151.2093 | 2021-10-18 04:21:10 | New South Wales, Australia | |||
934481 | 934481 | 2021-10-16 | Australia | New South Wales | 71399 | 524 | 0 | -33.8688 | 151.2093 | 2021-10-17 04:21:29 | New South Wales, Australia | |||
2943036 | 2943036 | 2021-10-15 | Australia | New South Wales | 71099 | 514 | 0 | -33.8688 | 151.2093 | 2021-10-16 04:21:15 | New South Wales, Australia | |||
491316 | 491316 | 2021-10-14 | Australia | New South Wales | 70781 | 512 | 0 | -33.8688 | 151.2093 | 2021-10-15 04:21:26 | New South Wales, Australia | |||
633604 | 633604 | 2021-10-13 | Australia | New South Wales | 70391 | 508 | 0 | -33.8688 | 151.2093 | 2021-10-14 04:21:29 | New South Wales, Australia | |||
1491282 | 1491282 | 2021-10-12 | Australia | New South Wales | 69993 | 502 | 0 | -33.8688 | 151.2093 | 2021-10-13 04:20:51 | New South Wales, Australia | |||
3007015 | 3007015 | 2021-10-11 | Australia | New South Wales | 69552 | 498 | 0 | -33.8688 | 151.2093 | 2021-10-12 04:21:09 | New South Wales, Australia | |||
423031 | 423031 | 2021-10-10 | Australia | New South Wales | 69205 | 493 | 0 | -33.8688 | 151.2093 | 2021-10-11 04:21:31 | New South Wales, Australia | |||
2875888 | 2875888 | 2021-10-09 | Australia | New South Wales | 68712 | 485 | 0 | -33.8688 | 151.2093 | 2021-10-10 04:21:38 | New South Wales, Australia | |||
2959054 | 2959054 | 2021-10-08 | Australia | New South Wales | 68246 | 479 | 0 | -33.8688 | 151.2093 | 2021-10-09 04:21:34 | New South Wales, Australia | |||
467092 | 467092 | 2021-10-07 | Australia | New South Wales | 67669 | 468 | 0 | -33.8688 | 151.2093 | 2021-10-08 04:21:25 | New South Wales, Australia | |||
2458472 | 2458472 | 2021-10-06 | Australia | New South Wales | 67024 | 457 | 0 | -33.8688 | 151.2093 | 2021-10-07 04:21:36 | New South Wales, Australia | |||
3832166 | 3832166 | 2021-10-05 | Australia | New South Wales | 66456 | 449 | 0 | -33.8688 | 151.2093 | 2021-10-06 04:21:33 | New South Wales, Australia | |||
986659 | 986659 | 2021-10-04 | Australia | New South Wales | 65876 | 439 | 0 | -33.8688 | 151.2093 | 2021-10-05 04:21:27 | New South Wales, Australia | |||
1273969 | 1273969 | 2021-10-03 | Australia | New South Wales | 65279 | 432 | 0 | -33.8688 | 151.2093 | 2021-10-04 04:21:31 | New South Wales, Australia | |||
3927722 | 3927722 | 2021-10-02 | Australia | New South Wales | 64668 | 426 | 0 | -33.8688 | 151.2093 | 2021-10-03 04:21:24 | New South Wales, Australia | |||
2131702 | 2131702 | 2021-10-01 | Australia | New South Wales | 64014 | 416 | 0 | -33.8688 | 151.2093 | 2021-10-02 04:21:25 | New South Wales, Australia | |||
2772659 | 2772659 | 2021-09-30 | Australia | New South Wales | 63212 | 406 | 0 | -33.8688 | 151.2093 | 2021-10-01 04:21:35 | New South Wales, Australia | |||
706115 | 706115 | 2021-09-29 | Australia | New South Wales | 62353 | 391 | 0 | -33.8688 | 151.2093 | 2021-09-30 04:21:20 | New South Wales, Australia | |||
1333957 | 1333957 | 2021-09-28 | Australia | New South Wales | 61420 | 385 | 0 | -33.8688 | 151.2093 | 2021-09-29 04:21:45 | New South Wales, Australia | |||
1235326 | 1235326 | 2021-09-27 | Australia | New South Wales | 60561 | 370 | 0 | -33.8688 | 151.2093 | 2021-09-28 04:21:28 | New South Wales, Australia | |||
2075627 | 2075627 | 2021-09-26 | Australia | New South Wales | 59709 | 363 | 0 | -33.8688 | 151.2093 | 2021-09-27 04:21:16 | New South Wales, Australia | |||
1724179 | 1724179 | 2021-09-25 | Australia | New South Wales | 58931 | 351 | 0 | -33.8688 | 151.2093 | 2021-09-26 04:21:29 | New South Wales, Australia | |||
1920899 | 1920899 | 2021-09-24 | Australia | New South Wales | 57983 | 342 | 0 | -33.8688 | 151.2093 | 2021-09-25 04:21:31 | New South Wales, Australia | |||
601370 | 601370 | 2021-09-23 | Australia | New South Wales | 56988 | 331 | 0 | -33.8688 | 151.2093 | 2021-09-24 04:21:44 | New South Wales, Australia | |||
3011031 | 3011031 | 2021-09-22 | Australia | New South Wales | 55962 | 320 | 0 | -33.8688 | 151.2093 | 2021-09-23 04:21:43 | New South Wales, Australia | |||
3757169 | 3757169 | 2021-09-21 | Australia | New South Wales | 54919 | 314 | 0 | -33.8688 | 151.2093 | 2021-09-22 04:21:45 | New South Wales, Australia | |||
809272 | 809272 | 2021-09-20 | Australia | New South Wales | 53898 | 309 | 0 | -33.8688 | 151.2093 | 2021-09-21 04:21:26 | New South Wales, Australia | |||
1814471 | 1814471 | 2021-09-19 | Australia | New South Wales | 52922 | 299 | 0 | -33.8688 | 151.2093 | 2021-09-20 04:21:22 | New South Wales, Australia | |||
16051 | 16051 | 2021-09-18 | Australia | New South Wales | 51986 | 295 | 0 | -33.8688 | 151.2093 | 2021-09-19 04:21:34 | New South Wales, Australia | |||
2617736 | 2617736 | 2021-09-17 | Australia | New South Wales | 50919 | 282 | 0 | -33.8688 | 151.2093 | 2021-09-18 04:21:24 | New South Wales, Australia | |||
2808444 | 2808444 | 2021-09-16 | Australia | New South Wales | 49611 | 276 | 0 | -33.8688 | 151.2093 | 2021-09-17 04:21:46 | New South Wales, Australia | |||
1374189 | 1374189 | 2021-09-15 | Australia | New South Wales | 48341 | 264 | 0 | -33.8688 | 151.2093 | 2021-09-16 04:22:19 | New South Wales, Australia | |||
2462488 | 2462488 | 2021-09-14 | Australia | New South Wales | 47007 | 252 | 0 | -33.8688 | 151.2093 | 2021-09-15 03:22:37 | New South Wales, Australia | |||
1385327 | 1385327 | 2021-09-13 | Australia | New South Wales | 45782 | 240 | 0 | -33.8688 | 151.2093 | 2021-09-14 04:21:41 | New South Wales, Australia | |||
1884696 | 1884696 | 2021-09-12 | Australia | New South Wales | 44674 | 238 | 0 | -33.8688 | 151.2093 | 2021-09-13 04:21:15 | New South Wales, Australia | |||
3805599 | 3805599 | 2021-09-11 | Australia | New South Wales | 43436 | 231 | 0 | -33.8688 | 151.2093 | 2021-09-12 04:21:13 | New South Wales, Australia | |||
3448539 | 3448539 | 2021-09-10 | Australia | New South Wales | 42219 | 224 | 0 | -33.8688 | 151.2093 | 2021-09-11 04:21:30 | New South Wales, Australia | |||
1262485 | 1262485 | 2021-09-09 | Australia | New South Wales | 40616 | 216 | 0 | -33.8688 | 151.2093 | 2021-09-10 04:21:20 | New South Wales, Australia | |||
2278855 | 2278855 | 2021-09-08 | Australia | New South Wales | 39108 | 207 | 0 | -33.8688 | 151.2093 | 2021-09-09 04:21:27 | New South Wales, Australia | |||
641634 | 641634 | 2021-09-07 | Australia | New South Wales | 37724 | 201 | 0 | -33.8688 | 151.2093 | 2021-09-08 04:21:31 | New South Wales, Australia | |||
3193697 | 3193697 | 2021-09-06 | Australia | New South Wales | 36267 | 193 | 0 | -33.8688 | 151.2093 | 2021-09-07 04:21:35 | New South Wales, Australia | |||
3280565 | 3280565 | 2021-09-05 | Australia | New South Wales | 35064 | 185 | 0 | -33.8688 | 151.2093 | 2021-09-06 04:21:22 | New South Wales, Australia | |||
248979 | 248979 | 2021-09-04 | Australia | New South Wales | 33792 | 180 | 0 | -33.8688 | 151.2093 | 2021-09-05 04:21:33 | New South Wales, Australia | |||
3974260 | 3974260 | 2021-09-03 | Australia | New South Wales | 32323 | 177 | 0 | -33.8688 | 151.2093 | 2021-09-04 04:21:28 | New South Wales, Australia | |||
177722 | 177722 | 2021-09-02 | Australia | New South Wales | 30807 | 173 | 0 | -33.8688 | 151.2093 | 2021-09-03 04:21:20 | New South Wales, Australia | |||
66757 | 66757 | 2021-09-01 | Australia | New South Wales | 29390 | 161 | 0 | -33.8688 | 151.2093 | 2021-09-02 04:21:15 | New South Wales, Australia | |||
2067599 | 2067599 | 2021-08-31 | Australia | New South Wales | 28111 | 154 | 0 | -33.8688 | 151.2093 | 2021-09-01 04:21:38 | New South Wales, Australia | |||
1775053 | 1775053 | 2021-08-30 | Australia | New South Wales | 27026 | 150 | 0 | -33.8688 | 151.2093 | 2021-08-31 04:21:46 | New South Wales, Australia | |||
3891627 | 3891627 | 2021-08-29 | Australia | New South Wales | 25857 | 147 | 0 | -33.8688 | 151.2093 | 2021-08-30 04:21:23 | New South Wales, Australia | |||
2792730 | 2792730 | 2021-08-28 | Australia | New South Wales | 24585 | 143 | 0 | -33.8688 | 151.2093 | 2021-08-29 04:21:14 | New South Wales, Australia | |||
2922889 | 2922889 | 2021-08-27 | Australia | New South Wales | 23372 | 137 | 0 | -33.8688 | 151.2093 | 2021-08-28 04:21:28 | New South Wales, Australia | |||
1595903 | 1595903 | 2021-08-26 | Australia | New South Wales | 22346 | 135 | 0 | -33.8688 | 151.2093 | 2021-08-27 04:21:37 | New South Wales, Australia | |||
32112 | 32112 | 2021-08-25 | Australia | New South Wales | 21471 | 133 | 0 | -33.8688 | 151.2093 | 2021-08-26 04:21:28 | New South Wales, Australia | |||
3105151 | 3105151 | 2021-08-24 | Australia | New South Wales | 20466 | 130 | 0 | -33.8688 | 151.2093 | 2021-08-25 04:21:41 | New South Wales, Australia | |||
3165322 | 3165322 | 2021-08-23 | Australia | New South Wales | 19545 | 128 | 0 | -33.8688 | 151.2093 | 2021-08-24 04:21:19 | New South Wales, Australia | |||
2175249 | 2175249 | 2021-08-22 | Australia | New South Wales | 18800 | 128 | 0 | -33.8688 | 151.2093 | 2021-08-23 04:21:27 | New South Wales, Australia | |||
3555345 | 3555345 | 2021-08-21 | Australia | New South Wales | 17995 | 125 | 0 | -33.8688 | 151.2093 | 2021-08-22 04:21:29 | New South Wales, Australia | |||
1853687 | 1853687 | 2021-08-20 | Australia | New South Wales | 17173 | 122 | 0 | -33.8688 | 151.2093 | 2021-08-21 04:21:38 | New South Wales, Australia | |||
511394 | 511394 | 2021-08-19 | Australia | New South Wales | 16353 | 119 | 0 | -33.8688 | 151.2093 | 2021-08-20 04:21:33 | New South Wales, Australia | |||
2517873 | 2517873 | 2021-08-18 | Australia | New South Wales | 15717 | 115 | 0 | -33.8688 | 151.2093 | 2021-08-19 04:21:15 | New South Wales, Australia | |||
244965 | 244965 | 2021-08-17 | Australia | New South Wales | 15043 | 114 | 0 | -33.8688 | 151.2093 | 2021-08-18 04:21:35 | New South Wales, Australia | |||
1603928 | 1603928 | 2021-08-16 | Australia | New South Wales | 14416 | 111 | 0 | -33.8688 | 151.2093 | 2021-08-17 04:21:49 | New South Wales, 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]);