daily_reports (view)
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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-13 | Australia | New South Wales | 3063 | 45 | 2595 | 423 | -33.8688 | 151.2093 | 2020-05-14 03:32:28 | New South Wales, Australia | ||
2020-05-14 | Australia | New South Wales | 3071 | 45 | 2605 | 421 | -33.8688 | 151.2093 | 2020-05-15 02:33:02 | New South Wales, Australia | ||
2020-05-15 | Australia | New South Wales | 3074 | 45 | 2611 | 418 | -33.8688 | 151.2093 | 2020-05-16 02:32:19 | New South Wales, Australia | ||
2020-05-16 | Australia | New South Wales | 3075 | 45 | 2611 | 419 | -33.8688 | 151.2093 | 2020-05-17 02:32:32 | New South Wales, Australia | ||
2020-05-17 | Australia | New South Wales | 3076 | 46 | 2612 | 418 | -33.8688 | 151.2093 | 2020-05-18 02:32:21 | New South Wales, Australia | ||
2020-05-18 | Australia | New South Wales | 3078 | 46 | 2614 | 418 | -33.8688 | 151.2093 | 2020-05-19 02:32:18 | New South Wales, Australia | ||
2020-05-19 | Australia | New South Wales | 3081 | 47 | 2631 | 403 | -33.8688 | 151.2093 | 2020-05-20 02:32:19 | New South Wales, Australia | ||
2020-05-20 | Australia | New South Wales | 3082 | 47 | 2648 | 387 | -33.8688 | 151.2093 | 2020-05-21 02:32:48 | New South Wales, Australia | ||
2020-05-21 | Australia | New South Wales | 3084 | 48 | 2648 | 388 | -33.8688 | 151.2093 | 2020-05-22 02:36:51 | New South Wales, Australia | ||
2020-05-22 | Australia | New South Wales | 3086 | 48 | 2653 | 385 | -33.8688 | 151.2093 | 2020-05-23 02:32:42 | New South Wales, Australia | ||
2020-05-23 | Australia | New South Wales | 3087 | 48 | 2653 | 386 | -33.8688 | 151.2093 | 2020-05-24 02:32:43 | New South Wales, Australia | ||
2020-05-24 | Australia | New South Wales | 3090 | 48 | 2656 | 386 | -33.8688 | 151.2093 | 2020-05-25 02:32:44 | New South Wales, Australia | ||
2020-05-25 | Australia | New South Wales | 3092 | 48 | 2661 | 383 | -33.8688 | 151.2093 | 2020-05-26 02:32:35 | New South Wales, Australia | ||
2020-05-26 | Australia | New South Wales | 3089 | 48 | 2663 | 378 | -33.8688 | 151.2093 | 2020-05-27 02:32:31 | New South Wales, Australia | ||
2020-05-27 | Australia | New South Wales | 3090 | 48 | 2670 | 372 | -33.8688 | 151.2093 | 2020-05-28 02:32:31 | New South Wales, Australia | ||
2020-05-28 | Australia | New South Wales | 3092 | 48 | 2666 | 378 | -33.8688 | 151.2093 | 2020-05-29 02:32:50 | New South Wales, Australia | ||
2020-05-29 | Australia | New South Wales | 3092 | 48 | 2683 | 361 | -33.8688 | 151.2093 | 2020-05-30 02:32:48 | New South Wales, Australia | ||
2020-05-30 | Australia | New South Wales | 3095 | 48 | 2685 | 362 | -33.8688 | 151.2093 | 2020-05-31 02:32:45 | New South Wales, Australia | ||
2020-05-31 | Australia | New South Wales | 3098 | 48 | 2685 | 365 | -33.8688 | 151.2093 | 2020-06-01 02:32:46 | New South Wales, Australia | ||
2020-06-01 | Australia | New South Wales | 3104 | 48 | 2687 | 369 | -33.8688 | 151.2093 | 2020-06-02 02:33:08 | New South Wales, Australia | ||
2020-06-02 | Australia | New South Wales | 3104 | 48 | 2691 | 365 | -33.8688 | 151.2093 | 2020-06-03 02:33:13 | New South Wales, Australia | ||
2020-06-03 | Australia | New South Wales | 3106 | 48 | 2700 | 358 | -33.8688 | 151.2093 | 2020-06-04 02:33:14 | New South Wales, Australia | ||
2020-06-04 | Australia | New South Wales | 3110 | 48 | 2714 | 348 | -33.8688 | 151.2093 | 2020-06-05 02:33:06 | New South Wales, Australia | ||
2020-06-05 | Australia | New South Wales | 3110 | 48 | 2719 | 343 | -33.8688 | 151.2093 | 2020-06-06 02:33:00 | New South Wales, Australia | ||
2020-06-06 | Australia | New South Wales | 3109 | 48 | 2723 | 338 | -33.8688 | 151.2093 | 2020-06-07 03:53:30 | New South Wales, Australia | ||
2020-06-07 | Australia | New South Wales | 3112 | 48 | 2724 | 340 | -33.8688 | 151.2093 | 2020-06-08 03:33:22 | New South Wales, Australia | ||
2020-06-08 | Australia | New South Wales | 3114 | 48 | 2729 | 337 | -33.8688 | 151.2093 | 2020-06-09 03:33:03 | New South Wales, Australia | ||
2020-06-09 | Australia | New South Wales | 3117 | 48 | 2735 | 334 | -33.8688 | 151.2093 | 2020-06-10 04:07:00 | New South Wales, Australia | ||
2020-06-10 | Australia | New South Wales | 3117 | 48 | 2738 | 331 | -33.8688 | 151.2093 | 2020-06-11 03:33:41 | New South Wales, Australia | ||
2020-06-11 | Australia | New South Wales | 3115 | 48 | 2743 | 324 | -33.8688 | 151.2093 | 2020-06-12 05:09:52 | New South Wales, Australia | ||
2020-06-12 | Australia | New South Wales | 3119 | 48 | 2763 | 308 | -33.8688 | 151.2093 | 2020-06-13 03:33:14 | New South Wales, Australia | ||
2020-06-13 | Australia | New South Wales | 3128 | 48 | 2766 | 314 | -33.8688 | 151.2093 | 2020-06-14 03:33:15 | New South Wales, Australia | ||
2020-06-14 | Australia | New South Wales | 3131 | 48 | 2766 | 317 | -33.8688 | 151.2093 | 2020-06-15 03:33:14 | New South Wales, Australia | ||
2020-06-15 | Australia | New South Wales | 3134 | 48 | 2768 | 318 | -33.8688 | 151.2093 | 2020-06-16 04:33:09 | New South Wales, Australia | ||
2020-06-16 | Australia | New South Wales | 3135 | 48 | 2770 | 317 | -33.8688 | 151.2093 | 2020-06-17 04:33:21 | New South Wales, Australia | ||
2020-06-17 | Australia | New South Wales | 3137 | 48 | 2770 | 319 | -33.8688 | 151.2093 | 2020-06-18 04:33:18 | New South Wales, Australia | ||
2020-06-18 | Australia | New South Wales | 3143 | 48 | 2770 | 325 | -33.8688 | 151.2093 | 2020-06-19 04:33:17 | New South Wales, Australia | ||
2020-06-19 | Australia | New South Wales | 3144 | 48 | 2771 | 325 | -33.8688 | 151.2093 | 2020-06-20 04:33:19 | New South Wales, Australia | ||
2020-06-20 | Australia | New South Wales | 3149 | 48 | 2771 | 330 | -33.8688 | 151.2093 | 2020-06-21 04:33:19 | New South Wales, Australia | ||
2020-06-21 | Australia | New South Wales | 3151 | 48 | 2771 | 332 | -33.8688 | 151.2093 | 2020-06-22 04:33:20 | New South Wales, Australia | ||
2020-06-22 | Australia | New South Wales | 3150 | 48 | 2771 | 331 | -33.8688 | 151.2093 | 2020-06-23 04:33:22 | New South Wales, Australia | ||
2020-06-23 | Australia | New South Wales | 3159 | 48 | 2771 | 340 | -33.8688 | 151.2093 | 2020-06-24 04:33:28 | New South Wales, Australia | ||
2020-06-24 | Australia | New South Wales | 3162 | 49 | 2776 | 337 | -33.8688 | 151.2093 | 2020-06-25 05:26:54 | New South Wales, Australia | ||
2020-06-25 | Australia | New South Wales | 3168 | 49 | 2782 | 337 | -33.8688 | 151.2093 | 2020-06-26 04:33:43 | New South Wales, Australia | ||
2020-06-26 | Australia | New South Wales | 3174 | 49 | 2784 | 341 | -33.8688 | 151.2093 | 2020-06-27 04:33:35 | New South Wales, Australia | ||
2020-06-27 | Australia | New South Wales | 3177 | 49 | 2784 | 344 | -33.8688 | 151.2093 | 2020-06-28 04:34:04 | New South Wales, Australia | ||
2020-06-28 | Australia | New South Wales | 3184 | 49 | 2784 | 351 | -33.8688 | 151.2093 | 2020-06-29 04:33:44 | New South Wales, Australia | ||
2020-06-29 | Australia | New South Wales | 3189 | 49 | 2784 | 356 | -33.8688 | 151.2093 | 2020-06-30 04:33:48 | New South Wales, Australia | ||
2020-06-30 | Australia | New South Wales | 3203 | 49 | 2787 | 367 | -33.8688 | 151.2093 | 2020-07-01 04:33:52 | New South Wales, Australia | ||
2020-07-01 | Australia | New South Wales | 3211 | 49 | 2787 | 375 | -33.8688 | 151.2093 | 2020-07-02 04:33:46 | New South Wales, Australia | ||
2020-07-02 | Australia | New South Wales | 3211 | 49 | 2789 | 373 | -33.8688 | 151.2093 | 2020-07-03 04:33:54 | New South Wales, Australia | ||
2020-07-03 | Australia | New South Wales | 3405 | 49 | 2977 | 379 | -33.8688 | 151.2093 | 2020-07-04 04:33:51 | New South Wales, Australia | ||
2020-07-04 | Australia | New South Wales | 3419 | 49 | 2988 | 382 | -33.8688 | 151.2093 | 2020-07-05 04:33:46 | New South Wales, Australia | ||
2020-07-05 | Australia | New South Wales | 3429 | 49 | 2988 | 392 | -33.8688 | 151.2093 | 2020-07-06 04:33:57 | New South Wales, Australia | ||
2020-07-06 | Australia | New South Wales | 3433 | 49 | 2987 | 397 | -33.8688 | 151.2093 | 2020-07-07 04:34:00 | New South Wales, Australia | ||
2020-07-07 | Australia | New South Wales | 3440 | 49 | 2986 | 405 | -33.8688 | 151.2093 | 2020-07-08 05:33:48 | New South Wales, Australia | ||
2020-07-08 | Australia | New South Wales | 3453 | 49 | 2986 | 418 | -33.8688 | 151.2093 | 2020-07-09 04:34:23 | New South Wales, Australia | ||
2020-07-09 | Australia | New South Wales | 3467 | 49 | 2987 | 431 | -33.8688 | 151.2093 | 2020-07-10 04:34:24 | New South Wales, Australia | ||
2020-07-10 | Australia | New South Wales | 3474 | 49 | 2997 | 428 | -33.8688 | 151.2093 | 2020-07-11 04:34:26 | New South Wales, Australia | ||
2020-07-11 | Australia | New South Wales | 3478 | 49 | 2988 | 441 | -33.8688 | 151.2093 | 2020-07-12 04:34:30 | New South Wales, Australia | ||
2020-07-12 | Australia | New South Wales | 3492 | 49 | 2988 | 455 | -33.8688 | 151.2093 | 2020-07-13 04:43:04 | New South Wales, Australia | ||
2020-07-13 | Australia | New South Wales | 3505 | 49 | 2988 | 468 | -33.8688 | 151.2093 | 2020-07-14 04:34:46 | New South Wales, Australia | ||
2020-07-14 | Australia | New South Wales | 3517 | 49 | 2988 | 480 | -33.8688 | 151.2093 | 2020-07-15 04:34:39 | New South Wales, Australia | ||
2020-07-15 | Australia | New South Wales | 3527 | 49 | 2988 | 490 | -33.8688 | 151.2093 | 2020-07-16 04:44:59 | New South Wales, Australia | ||
2020-07-16 | Australia | New South Wales | 3535 | 49 | 2988 | 498 | -33.8688 | 151.2093 | 2020-07-17 04:34:50 | New South Wales, Australia | ||
2020-07-17 | Australia | New South Wales | 3550 | 49 | 2988 | 513 | -33.8688 | 151.2093 | 2020-07-18 04:34:45 | New South Wales, Australia | ||
2020-07-18 | Australia | New South Wales | 3568 | 49 | 2988 | 531 | -33.8688 | 151.2093 | 2020-07-19 04:34:58 | New South Wales, Australia | ||
2020-07-19 | Australia | New South Wales | 3588 | 49 | 2988 | 551 | -33.8688 | 151.2093 | 2020-07-20 05:34:40 | New South Wales, Australia | ||
2020-07-20 | Australia | New South Wales | 3599 | 49 | 2988 | 562 | -33.8688 | 151.2093 | 2020-07-21 04:38:46 | New South Wales, Australia | ||
2020-07-21 | Australia | New South Wales | 3614 | 49 | 2988 | 577 | -33.8688 | 151.2093 | 2020-07-22 04:34:42 | New South Wales, Australia | ||
2020-07-22 | Australia | New South Wales | 3633 | 49 | 2988 | 596 | -33.8688 | 151.2093 | 2020-07-23 05:15:04 | New South Wales, Australia | ||
2020-07-23 | Australia | New South Wales | 3640 | 49 | 2988 | 603 | -33.8688 | 151.2093 | 2020-07-24 05:30:40 | New South Wales, Australia | ||
2020-07-24 | Australia | New South Wales | 3654 | 49 | 2988 | 617 | -33.8688 | 151.2093 | 2020-07-25 04:47:39 | New South Wales, Australia | ||
2020-07-25 | Australia | New South Wales | 3668 | 49 | 2988 | 631 | -33.8688 | 151.2093 | 2020-07-26 04:35:00 | New South Wales, Australia | ||
2020-07-26 | Australia | New South Wales | 3685 | 49 | 2989 | 647 | -33.8688 | 151.2093 | 2020-07-27 04:35:02 | New South Wales, Australia | ||
2020-07-27 | Australia | New South Wales | 3699 | 49 | 2989 | 661 | -33.8688 | 151.2093 | 2020-07-28 04:58:43 | New South Wales, Australia | ||
2020-07-28 | Australia | New South Wales | 3718 | 49 | 2989 | 680 | -33.8688 | 151.2093 | 2020-07-29 04:35:11 | New South Wales, Australia | ||
2020-07-29 | Australia | New South Wales | 3736 | 49 | 2989 | 698 | -33.8688 | 151.2093 | 2020-07-30 04:35:05 | New South Wales, Australia | ||
2020-07-30 | Australia | New South Wales | 3756 | 49 | 2989 | 718 | -33.8688 | 151.2093 | 2020-07-31 04:35:18 | New South Wales, Australia | ||
2020-07-31 | Australia | New South Wales | 3773 | 50 | 2989 | 734 | -33.8688 | 151.2093 | 2020-08-01 04:36:27 | New South Wales, Australia | ||
2020-08-01 | Australia | New South Wales | 3784 | 50 | 0 | 3734 | -33.8688 | 151.2093 | 2020-08-02 04:34:47 | New South Wales, Australia | ||
2020-08-02 | Australia | New South Wales | 3797 | 50 | 0 | 3747 | -33.8688 | 151.2093 | 2020-08-03 04:34:35 | New South Wales, Australia | ||
2020-08-03 | Australia | New South Wales | 3809 | 50 | 0 | 3759 | -33.8688 | 151.2093 | 2020-08-04 04:41:59 | New South Wales, Australia | ||
2020-08-04 | Australia | New South Wales | 3820 | 50 | 0 | 3770 | -33.8688 | 151.2093 | 2020-08-05 04:34:43 | New South Wales, Australia | ||
2020-08-05 | Australia | New South Wales | 3832 | 50 | 0 | 3782 | -33.8688 | 151.2093 | 2020-08-06 04:35:02 | New South Wales, Australia | ||
2020-08-06 | Australia | New South Wales | 3842 | 50 | 0 | 3792 | -33.8688 | 151.2093 | 2020-08-07 04:35:11 | New South Wales, Australia | ||
2020-08-07 | Australia | New South Wales | 3851 | 50 | 0 | 3801 | -33.8688 | 151.2093 | 2020-08-08 04:34:53 | New South Wales, Australia | ||
2020-08-08 | Australia | New South Wales | 3861 | 50 | 0 | 3811 | -33.8688 | 151.2093 | 2020-08-09 04:34:54 | New South Wales, Australia | ||
2020-08-09 | Australia | New South Wales | 3875 | 50 | 0 | 3825 | -33.8688 | 151.2093 | 2020-08-10 04:34:55 | New South Wales, Australia | ||
2020-08-10 | Australia | New South Wales | 3897 | 50 | 0 | 3847 | -33.8688 | 151.2093 | 2020-08-11 04:35:08 | New South Wales, Australia | ||
2020-08-11 | Australia | New South Wales | 3915 | 50 | 0 | 3865 | -33.8688 | 151.2093 | 2020-08-12 04:27:29 | New South Wales, Australia | ||
2020-08-12 | Australia | New South Wales | 3927 | 51 | 0 | 3876 | -33.8688 | 151.2093 | 2020-08-13 04:29:15 | New South Wales, Australia | ||
2020-08-13 | Australia | New South Wales | 3936 | 51 | 0 | 3885 | -33.8688 | 151.2093 | 2020-08-14 04:51:19 | New South Wales, Australia | ||
2020-08-14 | Australia | New South Wales | 3945 | 51 | 0 | 3894 | -33.8688 | 151.2093 | 2020-08-15 04:27:31 | New South Wales, Australia | ||
2020-08-15 | Australia | New South Wales | 3950 | 52 | 0 | 3898 | -33.8688 | 151.2093 | 2020-08-16 04:27:42 | New South Wales, Australia | ||
2020-08-16 | Australia | New South Wales | 3957 | 52 | 0 | 3905 | -33.8688 | 151.2093 | 2020-08-17 04:27:20 | New South Wales, Australia | ||
2020-08-17 | Australia | New South Wales | 3959 | 52 | 0 | 3907 | -33.8688 | 151.2093 | 2020-08-18 04:27:56 | New South Wales, Australia | ||
2020-08-18 | Australia | New South Wales | 3966 | 52 | 0 | 3914 | -33.8688 | 151.2093 | 2020-08-19 04:27:00 | New South Wales, Australia | ||
2020-08-19 | Australia | New South Wales | 3971 | 52 | 0 | 3919 | -33.8688 | 151.2093 | 2020-08-20 04:27:43 | New South Wales, Australia | ||
2020-08-20 | Australia | New South Wales | 3972 | 52 | 0 | 3920 | -33.8688 | 151.2093 | 2020-08-21 04:27:41 | New South Wales, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;