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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
742010 | 742010 | 2021-02-20 | Australia | New South Wales | 5149 | 54 | 0 | 5095 | -33.8688 | 151.2093 | 2021-02-21 05:24:33 | New South Wales, Australia | ||
471108 | 471108 | 2021-02-19 | Australia | New South Wales | 5146 | 54 | 0 | 5092 | -33.8688 | 151.2093 | 2021-02-20 05:22:51 | New South Wales, Australia | ||
1152818 | 1152818 | 2021-02-18 | Australia | New South Wales | 5145 | 54 | 0 | 5091 | -33.8688 | 151.2093 | 2021-02-19 05:24:16 | New South Wales, Australia | ||
3600738 | 3600738 | 2021-02-17 | Australia | New South Wales | 5143 | 54 | 0 | 5089 | -33.8688 | 151.2093 | 2021-02-18 05:22:58 | New South Wales, Australia | ||
3049873 | 3049873 | 2021-02-16 | Australia | New South Wales | 5143 | 54 | 0 | 5089 | -33.8688 | 151.2093 | 2021-02-17 05:23:10 | New South Wales, Australia | ||
1337972 | 1337972 | 2021-02-15 | Australia | New South Wales | 5139 | 54 | 0 | 5085 | -33.8688 | 151.2093 | 2021-02-16 05:24:38 | New South Wales, Australia | ||
2283123 | 2283123 | 2021-02-14 | Australia | New South Wales | 5138 | 54 | 0 | 5084 | -33.8688 | 151.2093 | 2021-02-15 05:24:49 | New South Wales, Australia | ||
2677523 | 2677523 | 2021-02-13 | Australia | New South Wales | 5138 | 54 | 0 | 5084 | -33.8688 | 151.2093 | 2021-02-14 05:23:43 | New South Wales, Australia | ||
3539156 | 3539156 | 2021-02-12 | Australia | New South Wales | 5136 | 54 | 0 | 5082 | -33.8688 | 151.2093 | 2021-02-13 05:22:12 | New South Wales, Australia | ||
2637419 | 2637419 | 2021-02-11 | Australia | New South Wales | 5134 | 54 | 0 | 5080 | -33.8688 | 151.2093 | 2021-02-12 05:23:29 | New South Wales, Australia | ||
3978274 | 3978274 | 2021-02-10 | Australia | New South Wales | 5132 | 54 | 0 | 5078 | -33.8688 | 151.2093 | 2021-02-11 05:23:55 | New South Wales, Australia | ||
1527594 | 1527594 | 2021-02-09 | Australia | New South Wales | 5129 | 54 | 0 | 5075 | -33.8688 | 151.2093 | 2021-02-10 05:22:41 | New South Wales, Australia | ||
613385 | 613385 | 2021-02-08 | Australia | New South Wales | 5125 | 54 | 0 | 5071 | -33.8688 | 151.2093 | 2021-02-09 05:23:30 | New South Wales, Australia | ||
1672154 | 1672154 | 2021-02-07 | Australia | New South Wales | 5123 | 54 | 0 | 5069 | -33.8688 | 151.2093 | 2021-02-08 05:22:39 | New South Wales, Australia | ||
974615 | 974615 | 2021-02-06 | Australia | New South Wales | 5120 | 54 | 0 | 5066 | -33.8688 | 151.2093 | 2021-02-07 05:23:00 | New South Wales, Australia | ||
1587873 | 1587873 | 2021-02-05 | Australia | New South Wales | 5119 | 54 | 0 | 5065 | -33.8688 | 151.2093 | 2021-02-06 05:23:55 | New South Wales, Australia | ||
790080 | 790080 | 2021-02-04 | Australia | New South Wales | 5117 | 54 | 0 | 5063 | -33.8688 | 151.2093 | 2021-02-05 05:22:38 | New South Wales, Australia | ||
339972 | 339972 | 2021-02-03 | Australia | New South Wales | 5117 | 54 | 0 | 5063 | -33.8688 | 151.2093 | 2021-02-04 05:22:26 | New South Wales, Australia | ||
1684198 | 1684198 | 2021-02-02 | Australia | New South Wales | 5114 | 54 | 0 | 5060 | -33.8688 | 151.2093 | 2021-02-03 05:22:52 | New South Wales, Australia | ||
1676168 | 1676168 | 2021-02-01 | Australia | New South Wales | 5112 | 54 | 0 | 5058 | -33.8688 | 151.2093 | 2021-02-02 05:22:49 | New South Wales, Australia | ||
1459456 | 1459456 | 2021-01-31 | Australia | New South Wales | 5110 | 54 | 0 | 5056 | -33.8688 | 151.2093 | 2021-02-01 05:22:53 | New South Wales, Australia | ||
2211364 | 2211364 | 2021-01-30 | Australia | New South Wales | 5104 | 54 | 0 | 5050 | -33.8688 | 151.2093 | 2021-01-31 05:22:42 | New South Wales, Australia | ||
1896851 | 1896851 | 2021-01-29 | Australia | New South Wales | 5101 | 54 | 0 | 5047 | -33.8688 | 151.2093 | 2021-01-30 05:22:49 | New South Wales, Australia | ||
2481667 | 2481667 | 2021-01-28 | Australia | New South Wales | 5099 | 54 | 0 | 5045 | -33.8688 | 151.2093 | 2021-01-29 05:22:23 | New South Wales, Australia | ||
3153302 | 3153302 | 2021-01-27 | Australia | New South Wales | 5096 | 54 | 0 | 5042 | -33.8688 | 151.2093 | 2021-01-28 05:22:24 | New South Wales, Australia | ||
12037 | 12037 | 2021-01-26 | Australia | New South Wales | 5093 | 54 | 0 | 5039 | -33.8688 | 151.2093 | 2021-01-27 05:23:41 | New South Wales, Australia | ||
2567361 | 2567361 | 2021-01-25 | Australia | New South Wales | 5091 | 54 | 0 | 5037 | -33.8688 | 151.2093 | 2021-01-26 05:22:02 | New South Wales, Australia | ||
1758993 | 1758993 | 2021-01-24 | Australia | New South Wales | 5090 | 54 | 0 | 5036 | -33.8688 | 151.2093 | 2021-01-25 05:22:16 | New South Wales, Australia | ||
2426600 | 2426600 | 2021-01-23 | Australia | New South Wales | 5087 | 54 | 0 | 5033 | -33.8688 | 151.2093 | 2021-01-24 05:22:35 | New South Wales, Australia | ||
2466502 | 2466502 | 2021-01-22 | Australia | New South Wales | 5084 | 54 | 0 | 5030 | -33.8688 | 151.2093 | 2021-01-23 05:22:03 | New South Wales, Australia | ||
435053 | 435053 | 2021-01-21 | Australia | New South Wales | 5083 | 54 | 0 | 5029 | -33.8688 | 151.2093 | 2021-01-22 05:22:10 | New South Wales, Australia | ||
1093785 | 1093785 | 2021-01-20 | Australia | New South Wales | 5084 | 54 | 0 | 5030 | -33.8688 | 151.2093 | 2021-01-21 05:22:01 | New South Wales, Australia | ||
907875 | 907875 | 2021-01-19 | Australia | New South Wales | 5079 | 54 | 0 | 5025 | -33.8688 | 151.2093 | 2021-01-20 05:21:54 | New South Wales, Australia | ||
236938 | 236938 | 2021-01-18 | Australia | New South Wales | 5076 | 54 | 0 | 5022 | -33.8688 | 151.2093 | 2021-01-19 05:22:15 | New South Wales, Australia | ||
3503055 | 3503055 | 2021-01-17 | Australia | New South Wales | 5074 | 54 | 0 | 5020 | -33.8688 | 151.2093 | 2021-01-18 05:22:34 | New South Wales, Australia | ||
3101138 | 3101138 | 2021-01-16 | Australia | New South Wales | 5066 | 54 | 0 | 5012 | -33.8688 | 151.2093 | 2021-01-17 05:22:17 | New South Wales, Australia | ||
3515100 | 3515100 | 2021-01-15 | Australia | New South Wales | 5057 | 54 | 0 | 5003 | -33.8688 | 151.2093 | 2021-01-16 05:22:40 | New South Wales, Australia | ||
3879273 | 3879273 | 2021-01-14 | Australia | New South Wales | 5045 | 54 | 0 | 4991 | -33.8688 | 151.2093 | 2021-01-15 05:22:24 | New South Wales, Australia | ||
3307900 | 3307900 | 2021-01-13 | Australia | New South Wales | 5043 | 54 | 0 | 4989 | -33.8688 | 151.2093 | 2021-01-14 05:22:32 | New South Wales, Australia | ||
774045 | 774045 | 2021-01-12 | Australia | New South Wales | 5041 | 54 | 0 | 4987 | -33.8688 | 151.2093 | 2021-01-13 05:22:15 | New South Wales, Australia | ||
189766 | 189766 | 2021-01-11 | Australia | New South Wales | 5034 | 54 | 0 | 4980 | -33.8688 | 151.2093 | 2021-01-12 05:22:15 | New South Wales, Australia | ||
2625569 | 2625569 | 2021-01-10 | Australia | New South Wales | 5018 | 54 | 0 | 4964 | -33.8688 | 151.2093 | 2021-01-11 05:21:50 | New South Wales, Australia | ||
3899657 | 3899657 | 2021-01-09 | Australia | New South Wales | 5007 | 54 | 0 | 4953 | -33.8688 | 151.2093 | 2021-01-10 05:22:12 | New South Wales, Australia | ||
153680 | 153680 | 2021-01-08 | Australia | New South Wales | 5001 | 54 | 0 | 4947 | -33.8688 | 151.2093 | 2021-01-09 05:22:18 | New South Wales, Australia | ||
2541104 | 2541104 | 2021-01-07 | Australia | New South Wales | 4995 | 54 | 0 | 4941 | -33.8688 | 151.2093 | 2021-01-08 05:22:42 | New South Wales, Australia | ||
2864413 | 2864413 | 2021-01-06 | Australia | New South Wales | 4984 | 54 | 0 | 4930 | -33.8688 | 151.2093 | 2021-01-07 05:22:03 | New South Wales, Australia | ||
3034000 | 3034000 | 2021-01-05 | Australia | New South Wales | 4978 | 54 | 0 | 4924 | -33.8688 | 151.2093 | 2021-01-06 05:22:16 | New South Wales, Australia | ||
1061545 | 1061545 | 2021-01-04 | Australia | New South Wales | 4973 | 54 | 0 | 4919 | -33.8688 | 151.2093 | 2021-01-05 05:21:49 | New South Wales, Australia | ||
3230148 | 3230148 | 2021-01-03 | Australia | New South Wales | 4965 | 54 | 0 | 4911 | -33.8688 | 151.2093 | 2021-01-04 05:22:02 | New South Wales, Australia | ||
2227218 | 2227218 | 2021-01-02 | Australia | New South Wales | 4958 | 54 | 0 | 4904 | -33.8688 | 151.2093 | 2021-01-03 05:22:52 | New South Wales, Australia | ||
1136582 | 1136582 | 2021-01-01 | Australia | New South Wales | 4947 | 54 | 0 | 4893 | -33.8688 | 151.2093 | 2021-01-02 05:22:33 | New South Wales, Australia | ||
3695188 | 3695188 | 2020-12-31 | Australia | New South Wales | 4928 | 54 | 0 | 4874 | -33.8688 | 151.2093 | 2021-01-01 05:23:07 | New South Wales, Australia | ||
1010003 | 1010003 | 2020-12-30 | Australia | New South Wales | 4923 | 54 | 0 | 4869 | -33.8688 | 151.2093 | 2020-12-31 05:22:49 | New South Wales, Australia | ||
766018 | 766018 | 2020-12-29 | Australia | New South Wales | 4906 | 54 | 0 | 4852 | -33.8688 | 151.2093 | 2020-12-30 05:22:34 | New South Wales, Australia | ||
3761282 | 3761282 | 2020-12-28 | Australia | New South Wales | 4881 | 54 | 0 | 4827 | -33.8688 | 151.2093 | 2020-12-29 05:22:37 | New South Wales, Australia | ||
3777602 | 3777602 | 2020-12-27 | Australia | New South Wales | 4872 | 54 | 0 | 4818 | -33.8688 | 151.2093 | 2020-12-28 05:22:06 | New South Wales, Australia | ||
2223207 | 2223207 | 2020-12-26 | Australia | New South Wales | 4858 | 53 | 0 | 4805 | -33.8688 | 151.2093 | 2020-12-27 05:22:55 | New South Wales, Australia | ||
201954 | 201954 | 2020-12-25 | Australia | New South Wales | 4847 | 53 | 0 | 4794 | -33.8688 | 151.2093 | 2020-12-26 05:22:28 | New South Wales, Australia | ||
3691177 | 3691177 | 2020-12-24 | Australia | New South Wales | 4832 | 53 | 0 | 4779 | -33.8688 | 151.2093 | 2020-12-25 05:22:48 | New South Wales, Australia | ||
2406529 | 2406529 | 2020-12-23 | Australia | New South Wales | 4823 | 53 | 0 | 4770 | -33.8688 | 151.2093 | 2020-12-24 05:23:04 | New South Wales, Australia | ||
3769575 | 3769575 | 2020-12-22 | Australia | New South Wales | 4805 | 53 | 0 | 4752 | -33.8688 | 151.2093 | 2020-12-23 05:22:03 | New South Wales, Australia | ||
927391 | 927391 | 2020-12-21 | Australia | New South Wales | 4789 | 53 | 0 | 4736 | -33.8688 | 151.2093 | 2020-12-22 05:22:33 | New South Wales, Australia | ||
2119412 | 2119412 | 2020-12-20 | Australia | New South Wales | 4771 | 53 | 0 | 4718 | -33.8688 | 151.2093 | 2020-12-21 05:27:58 | New South Wales, Australia | ||
2930919 | 2930919 | 2020-12-19 | Australia | New South Wales | 4748 | 53 | 0 | 4695 | -33.8688 | 151.2093 | 2020-12-20 05:27:32 | New South Wales, Australia | ||
1900865 | 1900865 | 2020-12-18 | Australia | New South Wales | 4712 | 53 | 0 | 4659 | -33.8688 | 151.2093 | 2020-12-19 05:27:52 | New South Wales, Australia | ||
2127691 | 2127691 | 2020-12-17 | Australia | New South Wales | 4682 | 53 | 0 | 4629 | -33.8688 | 151.2093 | 2020-12-18 05:28:18 | New South Wales, Australia | ||
3149291 | 3149291 | 2020-12-16 | Australia | New South Wales | 4666 | 53 | 0 | 4613 | -33.8688 | 151.2093 | 2020-12-17 05:28:12 | New South Wales, Australia | ||
1034072 | 1034072 | 2020-12-15 | Australia | New South Wales | 4657 | 53 | 0 | 4604 | -33.8688 | 151.2093 | 2020-12-16 05:28:04 | New South Wales, Australia | ||
1750966 | 1750966 | 2020-12-14 | Australia | New South Wales | 4650 | 53 | 0 | 4597 | -33.8688 | 151.2093 | 2020-12-15 05:26:38 | New South Wales, Australia | ||
3847486 | 3847486 | 2020-12-13 | Australia | New South Wales | 4645 | 53 | 0 | 4592 | -33.8688 | 151.2093 | 2020-12-14 05:26:27 | New South Wales, Australia | ||
845268 | 845268 | 2020-12-12 | Australia | New South Wales | 4642 | 53 | 0 | 4589 | -33.8688 | 151.2093 | 2020-12-13 05:27:20 | New South Wales, Australia | ||
860375 | 860375 | 2020-12-11 | Australia | New South Wales | 4639 | 53 | 0 | 4586 | -33.8688 | 151.2093 | 2020-12-12 05:26:19 | New South Wales, Australia | ||
1599917 | 1599917 | 2020-12-10 | Australia | New South Wales | 4633 | 53 | 0 | 4580 | -33.8688 | 151.2093 | 2020-12-11 05:26:59 | New South Wales, Australia | ||
2974926 | 2974926 | 2020-12-09 | Australia | New South Wales | 4624 | 53 | 0 | 4571 | -33.8688 | 151.2093 | 2020-12-10 05:26:19 | New South Wales, Australia | ||
1818486 | 1818486 | 2020-12-08 | Australia | New South Wales | 4622 | 53 | 0 | 4569 | -33.8688 | 151.2093 | 2020-12-09 05:28:01 | New South Wales, Australia | ||
2347122 | 2347122 | 2020-12-07 | Australia | New South Wales | 4620 | 53 | 0 | 4567 | -33.8688 | 151.2093 | 2020-12-08 05:27:42 | New South Wales, Australia | ||
1005992 | 1005992 | 2020-12-06 | Australia | New South Wales | 4614 | 53 | 0 | 4561 | -33.8688 | 151.2093 | 2020-12-07 05:26:14 | New South Wales, Australia | ||
1632001 | 1632001 | 2020-12-05 | Australia | New South Wales | 4610 | 53 | 0 | 4557 | -33.8688 | 151.2093 | 2020-12-06 05:26:18 | New South Wales, Australia | ||
3859529 | 3859529 | 2020-12-04 | Australia | New South Wales | 4605 | 53 | 0 | 4552 | -33.8688 | 151.2093 | 2020-12-05 05:27:36 | New South Wales, Australia | ||
74787 | 74787 | 2020-12-03 | Australia | New South Wales | 4603 | 53 | 0 | 4550 | -33.8688 | 151.2093 | 2020-12-04 05:27:27 | New South Wales, Australia | ||
737999 | 737999 | 2020-12-02 | Australia | New South Wales | 4597 | 53 | 0 | 4544 | -33.8688 | 151.2093 | 2020-12-03 05:28:22 | New South Wales, Australia | ||
2537093 | 2537093 | 2020-12-01 | Australia | New South Wales | 4588 | 53 | 0 | 4535 | -33.8688 | 151.2093 | 2020-12-02 05:27:41 | New South Wales, Australia | ||
1583862 | 1583862 | 2020-11-30 | Australia | New South Wales | 4582 | 53 | 0 | 4529 | -33.8688 | 151.2093 | 2020-12-01 05:26:18 | New South Wales, Australia | ||
3566265 | 3566265 | 2020-11-29 | Australia | New South Wales | 4577 | 53 | 0 | 4524 | -33.8688 | 151.2093 | 2020-11-30 05:26:13 | New South Wales, Australia | ||
2934930 | 2934930 | 2020-11-28 | Australia | New South Wales | 4568 | 53 | 0 | 4515 | -33.8688 | 151.2093 | 2020-11-29 05:25:55 | New South Wales, Australia | ||
391933 | 391933 | 2020-11-27 | Australia | New South Wales | 4564 | 53 | 0 | 4511 | -33.8688 | 151.2093 | 2020-11-28 05:25:50 | New South Wales, Australia | ||
923380 | 923380 | 2020-11-26 | Australia | New South Wales | 4556 | 53 | 0 | 4503 | -33.8688 | 151.2093 | 2020-11-27 05:26:53 | New South Wales, Australia | ||
1972285 | 1972285 | 2020-11-25 | Australia | New South Wales | 4552 | 53 | 0 | 4499 | -33.8688 | 151.2093 | 2020-11-26 05:27:44 | New South Wales, Australia | ||
1350016 | 1350016 | 2020-11-24 | Australia | New South Wales | 4552 | 53 | 0 | 4499 | -33.8688 | 151.2093 | 2020-11-25 05:27:20 | New South Wales, Australia | ||
678011 | 678011 | 2020-11-23 | Australia | New South Wales | 4548 | 53 | 0 | 4495 | -33.8688 | 151.2093 | 2020-11-24 05:27:31 | New South Wales, Australia | ||
3189687 | 3189687 | 2020-11-22 | Australia | New South Wales | 4542 | 53 | 0 | 4489 | -33.8688 | 151.2093 | 2020-11-23 05:25:26 | New South Wales, Australia | ||
3836181 | 3836181 | 2020-11-21 | Australia | New South Wales | 4538 | 53 | 0 | 4485 | -33.8688 | 151.2093 | 2020-11-22 05:25:45 | New South Wales, Australia | ||
2701209 | 2701209 | 2020-11-20 | Australia | New South Wales | 4527 | 53 | 0 | 4474 | -33.8688 | 151.2093 | 2020-11-21 05:25:51 | New South Wales, Australia | ||
821269 | 821269 | 2020-11-19 | Australia | New South Wales | 4517 | 53 | 0 | 4464 | -33.8688 | 151.2093 | 2020-11-20 05:26:28 | New South Wales, Australia | ||
122403 | 122403 | 2020-11-18 | Australia | New South Wales | 4514 | 53 | 0 | 4461 | -33.8688 | 151.2093 | 2020-11-19 05:25:23 | New South Wales, Australia | ||
3338291 | 3338291 | 2020-11-17 | Australia | New South Wales | 4509 | 53 | 0 | 4456 | -33.8688 | 151.2093 | 2020-11-18 05:40:31 | New South Wales, Australia | ||
3169336 | 3169336 | 2020-11-16 | Australia | New South Wales | 4502 | 53 | 0 | 4449 | -33.8688 | 151.2093 | 2020-11-17 05:25:54 | New South Wales, Australia | ||
2879904 | 2879904 | 2020-11-15 | Australia | New South Wales | 4498 | 53 | 0 | 4445 | -33.8688 | 151.2093 | 2020-11-16 05:25:57 | New South Wales, Australia | ||
2914882 | 2914882 | 2020-11-14 | Australia | New South Wales | 4486 | 53 | 0 | 4433 | -33.8688 | 151.2093 | 2020-11-15 05:26:53 | New South Wales, Australia | ||
2784704 | 2784704 | 2020-11-13 | Australia | New South Wales | 4469 | 53 | 0 | 4416 | -33.8688 | 151.2093 | 2020-11-14 05:25:37 | 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]);