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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016404 | 2016404 | 2022-09-20 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-21 04:23:22 | New South Wales, Australia | |||
3570277 | 3570277 | 2022-09-19 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-20 04:22:48 | New South Wales, Australia | |||
419016 | 419016 | 2022-09-18 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-19 04:21:49 | New South Wales, Australia | |||
3373040 | 3373040 | 2022-09-17 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-18 04:22:50 | New South Wales, Australia | |||
2355148 | 2355148 | 2022-09-16 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-17 04:20:19 | New South Wales, Australia | |||
3986305 | 3986305 | 2022-09-15 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-16 04:21:19 | New South Wales, Australia | |||
1888822 | 1888822 | 2022-09-14 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-15 04:21:02 | New South Wales, Australia | |||
371877 | 371877 | 2022-09-13 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-14 04:20:44 | New South Wales, Australia | |||
2394482 | 2394482 | 2022-09-12 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-13 04:20:57 | New South Wales, Australia | |||
3765560 | 3765560 | 2022-09-11 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-12 04:20:58 | New South Wales, Australia | |||
3824135 | 3824135 | 2022-09-10 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-11 04:20:50 | New South Wales, Australia | |||
962592 | 962592 | 2022-09-09 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-10 04:21:10 | New South Wales, Australia | |||
252994 | 252994 | 2022-09-08 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-09 04:21:11 | New South Wales, Australia | |||
3744792 | 3744792 | 2022-09-07 | Australia | New South Wales | 3461037 | 5026 | 0 | -33.8688 | 151.2093 | 2022-09-08 04:21:02 | New South Wales, Australia | |||
114432 | 114432 | 2022-09-06 | Australia | New South Wales | 3457721 | 5001 | 0 | -33.8688 | 151.2093 | 2022-09-07 04:20:59 | New South Wales, Australia | |||
2633404 | 2633404 | 2022-09-05 | Australia | New South Wales | 3454061 | 4980 | 0 | -33.8688 | 151.2093 | 2022-09-06 04:21:02 | New South Wales, Australia | |||
2986968 | 2986968 | 2022-09-04 | Australia | New South Wales | 3451076 | 4954 | 0 | -33.8688 | 151.2093 | 2022-09-05 04:21:01 | New South Wales, Australia | |||
2712653 | 2712653 | 2022-09-03 | Australia | New South Wales | 3448746 | 4952 | 0 | -33.8688 | 151.2093 | 2022-09-04 04:21:22 | New South Wales, Australia | |||
1393358 | 1393358 | 2022-09-02 | Australia | New South Wales | 3445866 | 4946 | 0 | -33.8688 | 151.2093 | 2022-09-03 04:21:04 | New South Wales, Australia | |||
3547187 | 3547187 | 2022-09-01 | Australia | New South Wales | 3442274 | 4928 | 0 | -33.8688 | 151.2093 | 2022-09-02 04:21:07 | New South Wales, Australia | |||
2343107 | 2343107 | 2022-08-31 | Australia | New South Wales | 3438117 | 4907 | 0 | -33.8688 | 151.2093 | 2022-09-01 04:21:03 | New South Wales, Australia | |||
3773587 | 3773587 | 2022-08-30 | Australia | New South Wales | 3433433 | 4884 | 0 | -33.8688 | 151.2093 | 2022-08-31 04:20:57 | New South Wales, Australia | |||
1680183 | 1680183 | 2022-08-29 | Australia | New South Wales | 3428015 | 4862 | 0 | -33.8688 | 151.2093 | 2022-08-30 04:21:03 | New South Wales, Australia | |||
1876667 | 1876667 | 2022-08-28 | Australia | New South Wales | 3423756 | 4825 | 0 | -33.8688 | 151.2093 | 2022-08-29 04:21:06 | New South Wales, Australia | |||
2095794 | 2095794 | 2022-08-27 | Australia | New South Wales | 3420381 | 4821 | 0 | -33.8688 | 151.2093 | 2022-08-28 04:21:02 | New South Wales, Australia | |||
1531609 | 1531609 | 2022-08-26 | Australia | New South Wales | 3416226 | 4816 | 0 | -33.8688 | 151.2093 | 2022-08-27 04:20:57 | New South Wales, Australia | |||
2828496 | 2828496 | 2022-08-25 | Australia | New South Wales | 3411500 | 4796 | 0 | -33.8688 | 151.2093 | 2022-08-26 04:21:02 | New South Wales, Australia | |||
2323029 | 2323029 | 2022-08-24 | Australia | New South Wales | 3405870 | 4774 | 0 | -33.8688 | 151.2093 | 2022-08-25 04:21:13 | New South Wales, Australia | |||
1250438 | 1250438 | 2022-08-23 | Australia | New South Wales | 3400100 | 4745 | 0 | -33.8688 | 151.2093 | 2022-08-24 04:20:46 | New South Wales, Australia | |||
2852542 | 2852542 | 2022-08-22 | Australia | New South Wales | 3393432 | 4731 | 0 | -33.8688 | 151.2093 | 2022-08-23 04:20:56 | New South Wales, Australia | |||
2402514 | 2402514 | 2022-08-21 | Australia | New South Wales | 3387881 | 4700 | 0 | -33.8688 | 151.2093 | 2022-08-22 04:20:38 | New South Wales, Australia | |||
3797592 | 3797592 | 2022-08-20 | Australia | New South Wales | 3382897 | 4696 | 0 | -33.8688 | 151.2093 | 2022-08-21 04:20:44 | New South Wales, Australia | |||
2363178 | 2363178 | 2022-08-19 | Australia | New South Wales | 3378587 | 4680 | 0 | -33.8688 | 151.2093 | 2022-08-20 04:21:01 | New South Wales, Australia | |||
1160849 | 1160849 | 2022-08-18 | Australia | New South Wales | 3372497 | 4646 | 0 | -33.8688 | 151.2093 | 2022-08-19 04:20:54 | New South Wales, Australia | |||
3950173 | 3950173 | 2022-08-17 | Australia | New South Wales | 3365632 | 4624 | 0 | -33.8688 | 151.2093 | 2022-08-18 04:21:11 | New South Wales, Australia | |||
990675 | 990675 | 2022-08-16 | Australia | New South Wales | 3357506 | 4581 | 0 | -33.8688 | 151.2093 | 2022-08-17 04:20:59 | New South Wales, Australia | |||
2493714 | 2493714 | 2022-08-15 | Australia | New South Wales | 3349487 | 4555 | 0 | -33.8688 | 151.2093 | 2022-08-16 04:20:58 | New South Wales, Australia | |||
3647264 | 3647264 | 2022-08-14 | Australia | New South Wales | 3342373 | 4531 | 0 | -33.8688 | 151.2093 | 2022-08-15 04:20:59 | New South Wales, Australia | |||
1968270 | 1968270 | 2022-08-13 | Australia | New South Wales | 3336902 | 4525 | 0 | -33.8688 | 151.2093 | 2022-08-14 04:20:55 | New South Wales, Australia | |||
2888079 | 2888079 | 2022-08-12 | Australia | New South Wales | 3329963 | 4516 | 0 | -33.8688 | 151.2093 | 2022-08-13 04:20:52 | New South Wales, Australia | |||
3907684 | 3907684 | 2022-08-11 | Australia | New South Wales | 3321760 | 4481 | 0 | -33.8688 | 151.2093 | 2022-08-12 04:20:54 | New South Wales, Australia | |||
1346001 | 1346001 | 2022-08-10 | Australia | New South Wales | 3312255 | 4446 | 0 | -33.8688 | 151.2093 | 2022-08-11 04:20:49 | New South Wales, Australia | |||
1085756 | 1085756 | 2022-08-09 | Australia | New South Wales | 3301777 | 4417 | 0 | -33.8688 | 151.2093 | 2022-08-10 04:20:57 | New South Wales, Australia | |||
3543171 | 3543171 | 2022-08-08 | Australia | New South Wales | 3290453 | 4387 | 0 | -33.8688 | 151.2093 | 2022-08-09 04:20:34 | New South Wales, Australia | |||
1069574 | 1069574 | 2022-08-07 | Australia | New South Wales | 3280561 | 4362 | 0 | -33.8688 | 151.2093 | 2022-08-08 04:21:08 | New South Wales, Australia | |||
1940162 | 1940162 | 2022-08-06 | Australia | New South Wales | 3272928 | 4358 | 0 | -33.8688 | 151.2093 | 2022-08-07 04:20:54 | New South Wales, Australia | |||
879961 | 879961 | 2022-08-05 | Australia | New South Wales | 3262915 | 4343 | 0 | -33.8688 | 151.2093 | 2022-08-06 04:20:56 | New South Wales, Australia | |||
2008372 | 2008372 | 2022-08-04 | Australia | New South Wales | 3250979 | 4313 | 0 | -33.8688 | 151.2093 | 2022-08-05 04:20:52 | New South Wales, Australia | |||
1097799 | 1097799 | 2022-08-03 | Australia | New South Wales | 3238095 | 4284 | 0 | -33.8688 | 151.2093 | 2022-08-04 04:20:58 | New South Wales, Australia | |||
1404724 | 1404724 | 2022-08-02 | Australia | New South Wales | 3223819 | 4251 | 0 | -33.8688 | 151.2093 | 2022-08-03 04:20:59 | New South Wales, Australia | |||
3616762 | 3616762 | 2022-08-01 | Australia | New South Wales | 3207182 | 4212 | 0 | -33.8688 | 151.2093 | 2022-08-02 04:20:53 | New South Wales, Australia | |||
3871242 | 3871242 | 2022-07-31 | Australia | New South Wales | 3196501 | 4165 | 0 | -33.8688 | 151.2093 | 2022-08-01 04:21:03 | New South Wales, Australia | |||
673996 | 673996 | 2022-07-30 | Australia | New South Wales | 3187107 | 4158 | 0 | -33.8688 | 151.2093 | 2022-07-31 04:21:02 | New South Wales, Australia | |||
1783195 | 1783195 | 2022-07-29 | Australia | New South Wales | 3176133 | 4153 | 0 | -33.8688 | 151.2093 | 2022-07-30 04:20:42 | New South Wales, Australia | |||
1065558 | 1065558 | 2022-07-28 | Australia | New South Wales | 3162719 | 4107 | 0 | -33.8688 | 151.2093 | 2022-07-29 04:20:45 | New South Wales, Australia | |||
2335077 | 2335077 | 2022-07-27 | Australia | New South Wales | 3147857 | 4085 | 0 | -33.8688 | 151.2093 | 2022-07-28 04:20:56 | New South Wales, Australia | |||
1487267 | 1487267 | 2022-07-26 | Australia | New South Wales | 3132294 | 4051 | 0 | -33.8688 | 151.2093 | 2022-07-27 04:21:04 | New South Wales, Australia | |||
2593713 | 2593713 | 2022-07-25 | Australia | New South Wales | 3116121 | 4031 | 0 | -33.8688 | 151.2093 | 2022-07-26 04:20:58 | New South Wales, Australia | |||
895828 | 895828 | 2022-07-24 | Australia | New South Wales | 3102071 | 4001 | 0 | -33.8688 | 151.2093 | 2022-07-25 04:20:51 | New South Wales, Australia | |||
90822 | 90822 | 2022-07-23 | Australia | New South Wales | 3091346 | 3994 | 0 | -33.8688 | 151.2093 | 2022-07-24 04:20:47 | New South Wales, Australia | |||
899844 | 899844 | 2022-07-22 | Australia | New South Wales | 3078551 | 3980 | 0 | -33.8688 | 151.2093 | 2022-07-23 04:20:53 | New South Wales, Australia | |||
669980 | 669980 | 2022-07-21 | Australia | New South Wales | 3063719 | 3939 | 0 | -33.8688 | 151.2093 | 2022-07-22 04:21:15 | New South Wales, Australia | |||
1607943 | 1607943 | 2022-07-20 | Australia | New South Wales | 3045062 | 3924 | 0 | -33.8688 | 151.2093 | 2022-07-21 04:21:10 | New South Wales, Australia | |||
958576 | 958576 | 2022-07-19 | Australia | New South Wales | 3031246 | 3899 | 0 | -33.8688 | 151.2093 | 2022-07-20 04:20:59 | New South Wales, Australia | |||
3209963 | 3209963 | 2022-07-18 | Australia | New South Wales | 3016037 | 3879 | 0 | -33.8688 | 151.2093 | 2022-07-19 04:20:58 | New South Wales, Australia | |||
3405138 | 3405138 | 2022-07-17 | Australia | New South Wales | 3002504 | 3853 | 0 | -33.8688 | 151.2093 | 2022-07-18 04:20:59 | New South Wales, Australia | |||
2151338 | 2151338 | 2022-07-16 | Australia | New South Wales | 2992755 | 3848 | 0 | -33.8688 | 151.2093 | 2022-07-17 04:21:15 | New South Wales, Australia | |||
2418571 | 2418571 | 2022-07-15 | Australia | New South Wales | 2982583 | 3836 | 0 | -33.8688 | 151.2093 | 2022-07-16 04:21:05 | New South Wales, Australia | |||
3428646 | 3428646 | 2022-07-14 | Australia | New South Wales | 2971525 | 3799 | 0 | -33.8688 | 151.2093 | 2022-07-15 04:20:53 | New South Wales, Australia | |||
3109166 | 3109166 | 2022-07-13 | Australia | New South Wales | 2959333 | 3785 | 0 | -33.8688 | 151.2093 | 2022-07-14 04:20:57 | New South Wales, Australia | |||
629589 | 629589 | 2022-07-12 | Australia | New South Wales | 2945218 | 3750 | 0 | -33.8688 | 151.2093 | 2022-07-13 04:20:58 | New South Wales, Australia | |||
1211233 | 1211233 | 2022-07-11 | Australia | New South Wales | 2934596 | 3735 | 0 | -33.8688 | 151.2093 | 2022-07-12 04:20:51 | New South Wales, Australia | |||
2788715 | 2788715 | 2022-07-10 | Australia | New South Wales | 2923798 | 3715 | 0 | -33.8688 | 151.2093 | 2022-07-11 04:20:46 | New South Wales, Australia | |||
141668 | 141668 | 2022-07-09 | Australia | New South Wales | 2916337 | 3707 | 0 | -33.8688 | 151.2093 | 2022-07-10 04:20:54 | New South Wales, Australia | |||
1416768 | 1416768 | 2022-07-08 | Australia | New South Wales | 2907681 | 3699 | 0 | -33.8688 | 151.2093 | 2022-07-09 04:20:59 | New South Wales, Australia | |||
2740693 | 2740693 | 2022-07-07 | Australia | New South Wales | 2896270 | 3666 | 0 | -33.8688 | 151.2093 | 2022-07-08 04:20:56 | New South Wales, Australia | |||
1199488 | 1199488 | 2022-07-06 | Australia | New South Wales | 2883560 | 3659 | 0 | -33.8688 | 151.2093 | 2022-07-07 04:20:55 | New South Wales, Australia | |||
3966231 | 3966231 | 2022-07-05 | Australia | New South Wales | 2870282 | 3637 | 0 | -33.8688 | 151.2093 | 2022-07-06 04:20:58 | New South Wales, Australia | |||
3077742 | 3077742 | 2022-07-04 | Australia | New South Wales | 2856570 | 3627 | 0 | -33.8688 | 151.2093 | 2022-07-05 04:20:45 | New South Wales, Australia | |||
1767024 | 1767024 | 2022-07-03 | Australia | New South Wales | 2846098 | 3613 | 0 | -33.8688 | 151.2093 | 2022-07-04 04:20:54 | New South Wales, Australia | |||
3365010 | 3365010 | 2022-07-02 | Australia | New South Wales | 2837155 | 3612 | 0 | -33.8688 | 151.2093 | 2022-07-03 04:20:59 | New South Wales, Australia | |||
593339 | 593339 | 2022-07-01 | Australia | New South Wales | 2828309 | 3610 | 0 | -33.8688 | 151.2093 | 2022-07-02 04:21:16 | New South Wales, Australia | |||
3939740 | 3939740 | 2022-06-30 | Australia | New South Wales | 2817248 | 3590 | 0 | -33.8688 | 151.2093 | 2022-07-01 04:21:10 | New South Wales, Australia | |||
2489698 | 2489698 | 2022-06-29 | Australia | New South Wales | 2806385 | 3581 | 0 | -33.8688 | 151.2093 | 2022-06-30 04:21:01 | New South Wales, Australia | |||
2239080 | 2239080 | 2022-06-28 | Australia | New South Wales | 2794932 | 3558 | 0 | -33.8688 | 151.2093 | 2022-06-29 04:20:59 | New South Wales, Australia | |||
2147322 | 2147322 | 2022-06-27 | Australia | New South Wales | 2783915 | 3547 | 0 | -33.8688 | 151.2093 | 2022-06-28 04:20:58 | New South Wales, Australia | |||
475123 | 475123 | 2022-06-26 | Australia | New South Wales | 2775310 | 3508 | 0 | -33.8688 | 151.2093 | 2022-06-27 04:21:00 | New South Wales, Australia | |||
938498 | 938498 | 2022-06-25 | Australia | New South Wales | 2768461 | 3497 | 0 | -33.8688 | 151.2093 | 2022-06-26 04:21:02 | New South Wales, Australia | |||
3346318 | 3346318 | 2022-06-24 | Australia | New South Wales | 2761005 | 3490 | 0 | -33.8688 | 151.2093 | 2022-06-25 04:20:57 | New South Wales, Australia | |||
1648059 | 1648059 | 2022-06-23 | Australia | New South Wales | 2752776 | 3470 | 0 | -33.8688 | 151.2093 | 2022-06-24 04:20:58 | New South Wales, Australia | |||
2187294 | 2187294 | 2022-06-22 | Australia | New South Wales | 2743680 | 3456 | 0 | -33.8688 | 151.2093 | 2022-06-23 04:20:55 | New South Wales, Australia | |||
165725 | 165725 | 2022-06-21 | Australia | New South Wales | 2734519 | 3430 | 0 | -33.8688 | 151.2093 | 2022-06-22 04:20:54 | New South Wales, Australia | |||
1763008 | 1763008 | 2022-06-20 | Australia | New South Wales | 2725064 | 3404 | 0 | -33.8688 | 151.2093 | 2022-06-21 04:20:56 | New South Wales, Australia | |||
3269194 | 3269194 | 2022-06-19 | Australia | New South Wales | 2717292 | 3397 | 0 | -33.8688 | 151.2093 | 2022-06-20 04:21:01 | New South Wales, Australia | |||
3397106 | 3397106 | 2022-06-18 | Australia | New South Wales | 2711234 | 3392 | 0 | -33.8688 | 151.2093 | 2022-06-19 04:20:51 | New South Wales, Australia | |||
2310983 | 2310983 | 2022-06-17 | Australia | New South Wales | 2704914 | 3385 | 0 | -33.8688 | 151.2093 | 2022-06-18 04:21:10 | New South Wales, Australia | |||
558487 | 558487 | 2022-06-16 | Australia | New South Wales | 2696819 | 3361 | 0 | -33.8688 | 151.2093 | 2022-06-17 04:20:56 | New South Wales, Australia | |||
3982289 | 3982289 | 2022-06-15 | Australia | New South Wales | 2688494 | 3353 | 0 | -33.8688 | 151.2093 | 2022-06-16 04:20:55 | New South Wales, Australia | |||
946530 | 946530 | 2022-06-14 | Australia | New South Wales | 2679407 | 3336 | 0 | -33.8688 | 151.2093 | 2022-06-15 04:20:54 | New South Wales, Australia | |||
2978938 | 2978938 | 2022-06-13 | Australia | New South Wales | 2672176 | 3322 | 0 | -33.8688 | 151.2093 | 2022-06-14 04:20:52 | 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]);