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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728714 | 2728714 | 2020-09-15 | Australia | New South Wales | 4185 | 52 | 0 | 4133 | -33.8688 | 151.2093 | 2020-09-16 04:22:53 | New South Wales, Australia | ||
343986 | 343986 | 2020-09-14 | Australia | New South Wales | 4177 | 52 | 0 | 4125 | -33.8688 | 151.2093 | 2020-09-15 03:22:50 | New South Wales, Australia | ||
2868425 | 2868425 | 2020-09-13 | Australia | New South Wales | 4170 | 52 | 0 | 4118 | -33.8688 | 151.2093 | 2020-09-14 04:26:00 | New South Wales, Australia | ||
546464 | 546464 | 2020-09-12 | Australia | New South Wales | 4166 | 52 | 0 | 4114 | -33.8688 | 151.2093 | 2020-09-13 04:30:52 | New South Wales, Australia | ||
1444293 | 1444293 | 2020-09-11 | Australia | New South Wales | 4157 | 52 | 0 | 4105 | -33.8688 | 151.2093 | 2020-09-12 04:25:05 | New South Wales, Australia | ||
1172894 | 1172894 | 2020-09-10 | Australia | New South Wales | 4152 | 52 | 0 | 4100 | -33.8688 | 151.2093 | 2020-09-11 04:46:23 | New South Wales, Australia | ||
2171259 | 2171259 | 2020-09-09 | Australia | New South Wales | 4142 | 52 | 0 | 4090 | -33.8688 | 151.2093 | 2020-09-10 04:29:01 | New South Wales, Australia | ||
1243468 | 1243468 | 2020-09-08 | Australia | New South Wales | 4135 | 52 | 0 | 4083 | -33.8688 | 151.2093 | 2020-09-09 04:28:48 | New South Wales, Australia | ||
427047 | 427047 | 2020-09-07 | Australia | New South Wales | 4126 | 52 | 0 | 4074 | -33.8688 | 151.2093 | 2020-09-08 04:28:25 | New South Wales, Australia | ||
3161332 | 3161332 | 2020-09-06 | Australia | New South Wales | 4118 | 52 | 0 | 4066 | -33.8688 | 151.2093 | 2020-09-07 04:28:30 | New South Wales, Australia | ||
813287 | 813287 | 2020-09-05 | Australia | New South Wales | 4114 | 52 | 0 | 4062 | -33.8688 | 151.2093 | 2020-09-06 04:28:33 | New South Wales, Australia | ||
2661487 | 2661487 | 2020-09-04 | Australia | New South Wales | 4104 | 52 | 0 | 4052 | -33.8688 | 151.2093 | 2020-09-05 04:28:19 | New South Wales, Australia | ||
1354027 | 1354027 | 2020-09-03 | Australia | New South Wales | 4099 | 52 | 0 | 4047 | -33.8688 | 151.2093 | 2020-09-04 04:28:26 | New South Wales, Australia | ||
1105264 | 1105264 | 2020-09-02 | Australia | New South Wales | 4091 | 52 | 0 | 4039 | -33.8688 | 151.2093 | 2020-09-03 04:28:22 | New South Wales, Australia | ||
2059593 | 2059593 | 2020-09-01 | Australia | New South Wales | 4079 | 52 | 0 | 4027 | -33.8688 | 151.2093 | 2020-09-02 04:28:25 | New South Wales, Australia | ||
193778 | 193778 | 2020-08-31 | Australia | New South Wales | 4063 | 52 | 0 | 4011 | -33.8688 | 151.2093 | 2020-09-01 04:28:31 | New South Wales, Australia | ||
3931737 | 3931737 | 2020-08-30 | Australia | New South Wales | 4050 | 52 | 0 | 3998 | -33.8688 | 151.2093 | 2020-08-31 04:28:27 | New South Wales, Australia | ||
609399 | 609399 | 2020-08-29 | Australia | New South Wales | 4040 | 52 | 0 | 3988 | -33.8688 | 151.2093 | 2020-08-30 04:28:22 | New South Wales, Australia | ||
1522894 | 1522894 | 2020-08-28 | Australia | New South Wales | 4033 | 52 | 0 | 3981 | -33.8688 | 151.2093 | 2020-08-29 04:28:19 | New South Wales, Australia | ||
2509895 | 2509895 | 2020-08-27 | Australia | New South Wales | 4019 | 52 | 0 | 3967 | -33.8688 | 151.2093 | 2020-08-28 04:28:11 | New South Wales, Australia | ||
1996355 | 1996355 | 2020-08-26 | Australia | New South Wales | 4006 | 52 | 0 | 3954 | -33.8688 | 151.2093 | 2020-08-27 04:28:15 | New South Wales, Australia | ||
3562279 | 3562279 | 2020-08-25 | Australia | New South Wales | 3997 | 52 | 0 | 3945 | -33.8688 | 151.2093 | 2020-08-26 04:28:11 | New South Wales, Australia | ||
2990983 | 2990983 | 2020-08-24 | Australia | New South Wales | 3991 | 52 | 0 | 3939 | -33.8688 | 151.2093 | 2020-08-25 04:28:02 | New South Wales, Australia | ||
2215378 | 2215378 | 2020-08-23 | Australia | New South Wales | 3988 | 52 | 0 | 3936 | -33.8688 | 151.2093 | 2020-08-24 04:27:56 | New South Wales, Australia | ||
2299160 | 2299160 | 2020-08-22 | Australia | New South Wales | 3985 | 52 | 0 | 3933 | -33.8688 | 151.2093 | 2020-08-23 04:27:48 | New South Wales, Australia | ||
1479267 | 1479267 | 2020-08-21 | Australia | New South Wales | 3981 | 52 | 0 | 3929 | -33.8688 | 151.2093 | 2020-08-22 04:27:49 | New South Wales, Australia | ||
3484016 | 3484016 | 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 | ||
205965 | 205965 | 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 | ||
3177719 | 3177719 | 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 | ||
837323 | 837323 | 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 | ||
1555681 | 1555681 | 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 | ||
145683 | 145683 | 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 | ||
1611958 | 1611958 | 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 | ||
582542 | 582542 | 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 | ||
3531161 | 3531161 | 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 | ||
662010 | 662010 | 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 | ||
1920465 | 1920465 | 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 | ||
3923274 | 3923274 | 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 | ||
371442 | 371442 | 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 | ||
458626 | 458626 | 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 | ||
3612311 | 3612311 | 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 | ||
3793141 | 3793141 | 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 | ||
98377 | 98377 | 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 | ||
2740260 | 2740260 | 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 | ||
2808012 | 2808012 | 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 | ||
753580 | 753580 | 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 | ||
3264745 | 3264745 | 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 | ||
1928452 | 1928452 | 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 | ||
2958620 | 2958620 | 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 | ||
3185236 | 3185236 | 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 | ||
177287 | 177287 | 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 | ||
442600 | 442600 | 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 | ||
1502844 | 1502844 | 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 | ||
2563814 | 2563814 | 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 | ||
62028 | 62028 | 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 | ||
844834 | 844834 | 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 | ||
1707573 | 1707573 | 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 | ||
327064 | 327064 | 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 | ||
121969 | 121969 | 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 | ||
3205358 | 3205358 | 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 | ||
2708659 | 2708659 | 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 | ||
367472 | 367472 | 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 | ||
2748140 | 2748140 | 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 | ||
2158784 | 2158784 | 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 | ||
3491425 | 3491425 | 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 | ||
3737688 | 3737688 | 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 | ||
3436083 | 3436083 | 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 | ||
3237581 | 3237581 | 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 | ||
1005566 | 1005566 | 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 | ||
2222782 | 2222782 | 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 | ||
887391 | 887391 | 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 | ||
2684951 | 2684951 | 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 | ||
415416 | 415416 | 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 | ||
529978 | 529978 | 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 | ||
2234639 | 2234639 | 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 | ||
3045433 | 3045433 | 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 | ||
303124 | 303124 | 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 | ||
2974502 | 2974502 | 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 | ||
2632979 | 2632979 | 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 | ||
2306542 | 2306542 | 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 | ||
2039877 | 2039877 | 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 | ||
1136158 | 1136158 | 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 | ||
2625145 | 2625145 | 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 | ||
2700785 | 2700785 | 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 | ||
1522470 | 1522470 | 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 | ||
1510664 | 1510664 | 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 | ||
3249403 | 3249403 | 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 | ||
2437996 | 2437996 | 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 | ||
1691574 | 1691574 | 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 | ||
3682723 | 3682723 | 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 | ||
1195926 | 1195926 | 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 | ||
2386689 | 2386689 | 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 | ||
287252 | 287252 | 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 | ||
1837203 | 1837203 | 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 | ||
3061255 | 3061255 | 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 | ||
737575 | 737575 | 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 | ||
1273545 | 1273545 | 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 | ||
2863988 | 2863988 | 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 | ||
1210819 | 1210819 | 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 | ||
217246 | 217246 | 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 |
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]);