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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2800042 | 2800042 | 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 | ||
574098 | 574098 | 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 | ||
1269795 | 1269795 | 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 | ||
1281267 | 1281267 | 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 | ||
3866822 | 3866822 | 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 | ||
2555864 | 2555864 | 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 | ||
805401 | 805401 | 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 | ||
1793984 | 1793984 | 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 | ||
3638877 | 3638877 | 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 | ||
1790418 | 1790418 | 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 | ||
2712297 | 2712297 | 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 | ||
2548252 | 2548252 | 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 | ||
1041215 | 1041215 | 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 | ||
1104945 | 1104945 | 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 | ||
875625 | 875625 | 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 | ||
997816 | 997816 | 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 | ||
1864839 | 1864839 | 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 | ||
268345 | 268345 | 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 | ||
1431928 | 1431928 | 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 | ||
2390180 | 2390180 | 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 | ||
3260918 | 3260918 | 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 | ||
3416312 | 3416312 | 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 | ||
1829546 | 1829546 | 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 | ||
3276262 | 3276262 | 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 | ||
1404436 | 1404436 | 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 | ||
3847215 | 3847215 | 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 | ||
2581422 | 2581422 | 2020-05-12 | Australia | New South Wales | 3059 | 45 | 2571 | 443 | -33.8688 | 151.2093 | 2020-05-13 03:32:26 | New South Wales, Australia | ||
3330956 | 3330956 | 2020-05-11 | Australia | New South Wales | 3053 | 44 | 2543 | 466 | -33.8688 | 151.2093 | 2020-05-12 03:32:27 | New South Wales, Australia | ||
3459571 | 3459571 | 2020-05-10 | Australia | New South Wales | 3053 | 44 | 2517 | 492 | -33.8688 | 151.2093 | 2020-05-11 02:32:30 | New South Wales, Australia | ||
2899112 | 2899112 | 2020-05-09 | Australia | New South Wales | 3053 | 44 | 2504 | 505 | -33.8688 | 151.2093 | 2020-05-10 02:32:30 | New South Wales, Australia | ||
114161 | 114161 | 2020-05-08 | Australia | New South Wales | 3051 | 44 | 2504 | 503 | -33.8688 | 151.2093 | 2020-05-09 02:32:35 | New South Wales, Australia | ||
3295604 | 3295604 | 2020-05-07 | Australia | New South Wales | 3047 | 44 | 2486 | 517 | -33.8688 | 151.2093 | 2020-05-08 02:32:32 | New South Wales, Australia | ||
2110825 | 2110825 | 2020-05-06 | Australia | New South Wales | 3044 | 44 | 2463 | 537 | -33.8688 | 151.2093 | 2020-05-07 02:32:28 | New South Wales, Australia | ||
1931865 | 1931865 | 2020-05-05 | Australia | New South Wales | 3042 | 44 | 2418 | 580 | -33.8688 | 151.2093 | 2020-05-06 02:32:31 | New South Wales, Australia | ||
3084728 | 3084728 | 2020-05-04 | Australia | New South Wales | 3035 | 43 | 2349 | 643 | -33.8688 | 151.2093 | 2020-05-05 02:32:34 | New South Wales, Australia | ||
2278587 | 2278587 | 2020-05-03 | Australia | New South Wales | 3033 | 42 | 2328 | 663 | -33.8688 | 151.2093 | 2020-05-04 02:32:28 | New South Wales, Australia | ||
2043263 | 2043263 | 2020-05-02 | Australia | New South Wales | 3035 | 42 | 2306 | 687 | -33.8688 | 151.2093 | 2020-05-03 02:32:28 | New South Wales, Australia | ||
1184157 | 1184157 | 2020-05-01 | Australia | New South Wales | 3030 | 41 | 2293 | 696 | -33.8688 | 151.2093 | 2020-05-02 02:32:27 | New South Wales, Australia | ||
228638 | 228638 | 2020-04-30 | Australia | New South Wales | 3025 | 41 | 2293 | 691 | -33.8688 | 151.2093 | 2020-05-01 02:32:28 | New South Wales, Australia | ||
137385 | 137385 | 2020-04-29 | Australia | New South Wales | 3016 | 40 | 2284 | 692 | -33.8688 | 151.2093 | 2020-04-30 02:32:27 | New South Wales, Australia | ||
271599 | 271599 | 2020-04-28 | Australia | New South Wales | 3016 | 39 | 2266 | 711 | -33.8688 | 151.2093 | 2020-04-29 02:32:29 | New South Wales, Australia | ||
3589475 | 3589475 | 2020-04-27 | Australia | New South Wales | 3004 | 34 | 2227 | 743 | -33.8688 | 151.2093 | 2020-04-28 02:31:20 | New South Wales, Australia | ||
3592653 | 3592653 | 2020-04-26 | Australia | New South Wales | 3002 | 34 | 2208 | 760 | -33.8688 | 151.2093 | 2020-04-27 02:31:20 | New South Wales, Australia | ||
3503002 | 3503002 | 2020-04-25 | Australia | New South Wales | 2994 | 33 | 2193 | 768 | -33.8688 | 151.2093 | 2020-04-26 02:31:18 | New South Wales, Australia | ||
1459403 | 1459403 | 2020-04-24 | Australia | New South Wales | 2982 | 33 | 1379 | 1570 | -33.8688 | 151.2093 | 2020-04-25 06:31:19 | New South Wales, Australia | ||
2524992 | 2524992 | 2020-04-23 | Australia | New South Wales | 2976 | 31 | 1379 | 1566 | -33.8688 | 151.2093 | 2020-04-24 03:31:35 | New South Wales, Australia | ||
1199221 | 1199221 | 2020-04-22 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-22 23:38:57 | New South Wales, Australia | ||
522287 | 522287 | 2020-04-21 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-21 23:39:09 | New South Wales, Australia | ||
2473369 | 2473369 | 2020-04-20 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-20 23:44:50 | New South Wales, Australia | ||
1385061 | 1385061 | 2020-04-19 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-19 23:49:05 | New South Wales, Australia | ||
418749 | 418749 | 2020-04-18 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-18 22:40:18 | New South Wales, Australia | ||
50221 | 50221 | 2020-04-17 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-17 23:38:48 | New South Wales, Australia | ||
934215 | 934215 | 2020-04-16 | Australia | New South Wales | 2897 | 25 | 4 | 2868 | -33.8688 | 151.2093 | 2020-04-16 23:38:19 | New South Wales, Australia | ||
860109 | 860109 | 2020-04-15 | Australia | New South Wales | 2886 | 25 | 4 | 2857 | -33.8688 | 151.2093 | 2020-04-15 23:04:26 | New South Wales, Australia | ||
3338025 | 3338025 | 2020-04-14 | Australia | New South Wales | 2870 | 25 | 4 | 2841 | -33.8688 | 151.2093 | 2020-04-14 23:41:11 | New South Wales, Australia | ||
43122 | 43122 | 2020-04-13 | Australia | New South Wales | 2863 | 25 | 4 | 2834 | -33.8688 | 151.2093 | 2020-04-13 23:15:42 | New South Wales, Australia | ||
2578148 | 2578148 | 2020-04-12 | Australia | New South Wales | 2857 | 24 | 4 | 2829 | -33.8688 | 151.2093 | 2020-04-12 23:25:00 | New South Wales, Australia | ||
2566985 | 2566985 | 2020-04-11 | Australia | New South Wales | 2857 | 23 | 4 | 2830 | -33.8688 | 151.2093 | 2020-04-11 22:52:46 | New South Wales, Australia | ||
1250170 | 1250170 | 2020-04-10 | Australia | New South Wales | 2822 | 22 | 4 | 2796 | -33.8688 | 151.2093 | 2020-04-10 23:01:43 | New South Wales, Australia | ||
3949907 | 3949907 | 2020-04-09 | Australia | New South Wales | 2773 | 21 | 4 | 2748 | -33.8688 | 151.2093 | 2020-04-09 23:09:19 | New South Wales, Australia | ||
3562014 | 3562014 | 2020-04-08 | Australia | New South Wales | 2734 | 21 | 4 | 2709 | -33.8688 | 151.2093 | 2020-04-08 22:59:00 | New South Wales, Australia | ||
3021689 | 3021689 | 2020-04-07 | Australia | New South Wales | 2686 | 21 | 4 | 2661 | -33.8688 | 151.2093 | 2020-04-07 23:11:31 | New South Wales, Australia | ||
3627371 | 3627371 | 2020-04-06 | Australia | New South Wales | 2637 | 18 | 4 | 2615 | -33.8688 | 151.2093 | 4/6/20 23:28 | New South Wales, Australia | ||
589059 | 589059 | 2020-04-05 | Australia | New South Wales | 2580 | 16 | 4 | 2560 | -33.8688 | 151.2093 | 2020-04-05 23:13:44 | New South Wales, Australia | ||
1750703 | 1750703 | 2020-04-04 | Australia | New South Wales | 2493 | 12 | 4 | 2477 | -33.8688 | 151.2093 | 4/4/20 23:41 | New South Wales, Australia | ||
3740514 | 3740514 | 2020-04-03 | Australia | New South Wales | 2389 | 12 | 4 | 2373 | -33.8688 | 151.2093 | 2020-04-03 22:52:45 | New South Wales, Australia | ||
3701544 | 3701544 | 2020-04-02 | Australia | New South Wales | 2298 | 10 | 4 | 2284 | -33.8688 | 151.2093 | 4/2/20 23:32 | New South Wales, Australia | ||
3364748 | 3364748 | 2020-04-01 | Australia | New South Wales | 2182 | 9 | 4 | 2169 | -33.8688 | 151.2093 | 2020-04-01 22:04:58 | New South Wales, Australia | ||
3815841 | 3815841 | 2020-03-31 | Australia | New South Wales | 2032 | 8 | 4 | 2020 | -33.8688 | 151.2093 | 2020-03-31 23:49:27 | New South Wales, Australia | ||
1872393 | 1872393 | 2020-03-30 | Australia | New South Wales | 2032 | 8 | 4 | 2020 | -33.8688 | 151.2093 | 3/30/20 22:58 | New South Wales, Australia | ||
2875630 | 2875630 | 2020-03-29 | Australia | New South Wales | 1791 | 8 | 4 | 1779 | -33.8688 | 151.2093 | 3/29/20 23:14 | New South Wales, Australia | ||
3946966 | 3946966 | 2020-03-28 | Australia | New South Wales | 1617 | 8 | 4 | 1605 | -33.8688 | 151.2093 | 3/28/20 23:11 | New South Wales, Australia | ||
809016 | 809016 | 2020-03-27 | Australia | New South Wales | 1405 | 7 | 4 | 1394 | -33.8688 | 151.2093 | 2020-03-27 23:27:48 | New South Wales, Australia | ||
919109 | 919109 | 2020-03-26 | Australia | New South Wales | 1219 | 7 | 4 | 1208 | -33.8688 | 151.2093 | 2020-03-26 23:53:24 | New South Wales, Australia | ||
1132512 | 1132512 | 2020-03-25 | Australia | New South Wales | 1029 | 7 | 4 | 1018 | -33.8688 | 151.2093 | 2020-03-25 23:37:49 | New South Wales, Australia | ||
1479020 | 1479020 | 2020-03-24 | Australia | New South Wales | 818 | 7 | 4 | 807 | -33.8688 | 151.2093 | 2020-03-24 23:41:50 | 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]);