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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-21 04:23:22 | New South Wales, Australia | |||
2022-09-19 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-20 04:22:48 | New South Wales, Australia | |||
2022-09-18 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-19 04:21:49 | New South Wales, Australia | |||
2022-09-17 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-18 04:22:50 | New South Wales, Australia | |||
2022-09-16 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-17 04:20:19 | New South Wales, Australia | |||
2022-09-15 | Australia | New South Wales | 3481151 | 5163 | 0 | -33.8688 | 151.2093 | 2022-09-16 04:21:19 | New South Wales, Australia | |||
2022-09-14 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-15 04:21:02 | New South Wales, Australia | |||
2022-09-13 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-14 04:20:44 | New South Wales, Australia | |||
2022-09-12 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-13 04:20:57 | New South Wales, Australia | |||
2022-09-11 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-12 04:20:58 | New South Wales, Australia | |||
2022-09-10 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-11 04:20:50 | New South Wales, Australia | |||
2022-09-09 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-10 04:21:10 | New South Wales, Australia | |||
2022-09-08 | Australia | New South Wales | 3463759 | 5046 | 0 | -33.8688 | 151.2093 | 2022-09-09 04:21:11 | New South Wales, Australia | |||
2022-09-07 | Australia | New South Wales | 3461037 | 5026 | 0 | -33.8688 | 151.2093 | 2022-09-08 04:21:02 | New South Wales, Australia | |||
2022-09-06 | Australia | New South Wales | 3457721 | 5001 | 0 | -33.8688 | 151.2093 | 2022-09-07 04:20:59 | New South Wales, Australia | |||
2022-09-05 | Australia | New South Wales | 3454061 | 4980 | 0 | -33.8688 | 151.2093 | 2022-09-06 04:21:02 | New South Wales, Australia | |||
2022-09-04 | Australia | New South Wales | 3451076 | 4954 | 0 | -33.8688 | 151.2093 | 2022-09-05 04:21:01 | New South Wales, Australia | |||
2022-09-03 | Australia | New South Wales | 3448746 | 4952 | 0 | -33.8688 | 151.2093 | 2022-09-04 04:21:22 | New South Wales, Australia | |||
2022-09-02 | Australia | New South Wales | 3445866 | 4946 | 0 | -33.8688 | 151.2093 | 2022-09-03 04:21:04 | New South Wales, Australia | |||
2022-09-01 | Australia | New South Wales | 3442274 | 4928 | 0 | -33.8688 | 151.2093 | 2022-09-02 04:21:07 | New South Wales, Australia | |||
2022-08-31 | Australia | New South Wales | 3438117 | 4907 | 0 | -33.8688 | 151.2093 | 2022-09-01 04:21:03 | New South Wales, Australia | |||
2022-08-30 | Australia | New South Wales | 3433433 | 4884 | 0 | -33.8688 | 151.2093 | 2022-08-31 04:20:57 | New South Wales, Australia | |||
2022-08-29 | Australia | New South Wales | 3428015 | 4862 | 0 | -33.8688 | 151.2093 | 2022-08-30 04:21:03 | New South Wales, Australia | |||
2022-08-28 | Australia | New South Wales | 3423756 | 4825 | 0 | -33.8688 | 151.2093 | 2022-08-29 04:21:06 | New South Wales, Australia | |||
2022-08-27 | Australia | New South Wales | 3420381 | 4821 | 0 | -33.8688 | 151.2093 | 2022-08-28 04:21:02 | New South Wales, Australia | |||
2022-08-26 | Australia | New South Wales | 3416226 | 4816 | 0 | -33.8688 | 151.2093 | 2022-08-27 04:20:57 | New South Wales, Australia | |||
2022-08-25 | Australia | New South Wales | 3411500 | 4796 | 0 | -33.8688 | 151.2093 | 2022-08-26 04:21:02 | New South Wales, Australia | |||
2022-08-24 | Australia | New South Wales | 3405870 | 4774 | 0 | -33.8688 | 151.2093 | 2022-08-25 04:21:13 | New South Wales, Australia | |||
2022-08-23 | Australia | New South Wales | 3400100 | 4745 | 0 | -33.8688 | 151.2093 | 2022-08-24 04:20:46 | New South Wales, Australia | |||
2022-08-22 | Australia | New South Wales | 3393432 | 4731 | 0 | -33.8688 | 151.2093 | 2022-08-23 04:20:56 | New South Wales, Australia | |||
2022-08-21 | Australia | New South Wales | 3387881 | 4700 | 0 | -33.8688 | 151.2093 | 2022-08-22 04:20:38 | New South Wales, Australia | |||
2022-08-20 | Australia | New South Wales | 3382897 | 4696 | 0 | -33.8688 | 151.2093 | 2022-08-21 04:20:44 | New South Wales, Australia | |||
2022-08-19 | Australia | New South Wales | 3378587 | 4680 | 0 | -33.8688 | 151.2093 | 2022-08-20 04:21:01 | New South Wales, Australia | |||
2022-08-18 | Australia | New South Wales | 3372497 | 4646 | 0 | -33.8688 | 151.2093 | 2022-08-19 04:20:54 | New South Wales, Australia | |||
2022-08-17 | Australia | New South Wales | 3365632 | 4624 | 0 | -33.8688 | 151.2093 | 2022-08-18 04:21:11 | New South Wales, Australia | |||
2022-08-16 | Australia | New South Wales | 3357506 | 4581 | 0 | -33.8688 | 151.2093 | 2022-08-17 04:20:59 | New South Wales, Australia | |||
2022-08-15 | Australia | New South Wales | 3349487 | 4555 | 0 | -33.8688 | 151.2093 | 2022-08-16 04:20:58 | New South Wales, Australia | |||
2022-08-14 | Australia | New South Wales | 3342373 | 4531 | 0 | -33.8688 | 151.2093 | 2022-08-15 04:20:59 | New South Wales, Australia | |||
2022-08-13 | Australia | New South Wales | 3336902 | 4525 | 0 | -33.8688 | 151.2093 | 2022-08-14 04:20:55 | New South Wales, Australia | |||
2022-08-12 | Australia | New South Wales | 3329963 | 4516 | 0 | -33.8688 | 151.2093 | 2022-08-13 04:20:52 | New South Wales, Australia | |||
2022-08-11 | Australia | New South Wales | 3321760 | 4481 | 0 | -33.8688 | 151.2093 | 2022-08-12 04:20:54 | New South Wales, Australia | |||
2022-08-10 | Australia | New South Wales | 3312255 | 4446 | 0 | -33.8688 | 151.2093 | 2022-08-11 04:20:49 | New South Wales, Australia | |||
2022-08-09 | Australia | New South Wales | 3301777 | 4417 | 0 | -33.8688 | 151.2093 | 2022-08-10 04:20:57 | New South Wales, Australia | |||
2022-08-08 | Australia | New South Wales | 3290453 | 4387 | 0 | -33.8688 | 151.2093 | 2022-08-09 04:20:34 | New South Wales, Australia | |||
2022-08-07 | Australia | New South Wales | 3280561 | 4362 | 0 | -33.8688 | 151.2093 | 2022-08-08 04:21:08 | New South Wales, Australia | |||
2022-08-06 | Australia | New South Wales | 3272928 | 4358 | 0 | -33.8688 | 151.2093 | 2022-08-07 04:20:54 | New South Wales, Australia | |||
2022-08-05 | Australia | New South Wales | 3262915 | 4343 | 0 | -33.8688 | 151.2093 | 2022-08-06 04:20:56 | New South Wales, Australia | |||
2022-08-04 | Australia | New South Wales | 3250979 | 4313 | 0 | -33.8688 | 151.2093 | 2022-08-05 04:20:52 | New South Wales, Australia | |||
2022-08-03 | Australia | New South Wales | 3238095 | 4284 | 0 | -33.8688 | 151.2093 | 2022-08-04 04:20:58 | New South Wales, Australia | |||
2022-08-02 | Australia | New South Wales | 3223819 | 4251 | 0 | -33.8688 | 151.2093 | 2022-08-03 04:20:59 | New South Wales, Australia | |||
2022-08-01 | Australia | New South Wales | 3207182 | 4212 | 0 | -33.8688 | 151.2093 | 2022-08-02 04:20:53 | New South Wales, Australia | |||
2022-07-31 | Australia | New South Wales | 3196501 | 4165 | 0 | -33.8688 | 151.2093 | 2022-08-01 04:21:03 | New South Wales, Australia | |||
2022-07-30 | Australia | New South Wales | 3187107 | 4158 | 0 | -33.8688 | 151.2093 | 2022-07-31 04:21:02 | New South Wales, Australia | |||
2022-07-29 | Australia | New South Wales | 3176133 | 4153 | 0 | -33.8688 | 151.2093 | 2022-07-30 04:20:42 | New South Wales, Australia | |||
2022-07-28 | Australia | New South Wales | 3162719 | 4107 | 0 | -33.8688 | 151.2093 | 2022-07-29 04:20:45 | New South Wales, Australia | |||
2022-07-27 | Australia | New South Wales | 3147857 | 4085 | 0 | -33.8688 | 151.2093 | 2022-07-28 04:20:56 | New South Wales, Australia | |||
2022-07-26 | Australia | New South Wales | 3132294 | 4051 | 0 | -33.8688 | 151.2093 | 2022-07-27 04:21:04 | New South Wales, Australia | |||
2022-07-25 | Australia | New South Wales | 3116121 | 4031 | 0 | -33.8688 | 151.2093 | 2022-07-26 04:20:58 | New South Wales, Australia | |||
2022-07-24 | Australia | New South Wales | 3102071 | 4001 | 0 | -33.8688 | 151.2093 | 2022-07-25 04:20:51 | New South Wales, Australia | |||
2022-07-23 | Australia | New South Wales | 3091346 | 3994 | 0 | -33.8688 | 151.2093 | 2022-07-24 04:20:47 | New South Wales, Australia | |||
2022-07-22 | Australia | New South Wales | 3078551 | 3980 | 0 | -33.8688 | 151.2093 | 2022-07-23 04:20:53 | New South Wales, Australia | |||
2022-07-21 | Australia | New South Wales | 3063719 | 3939 | 0 | -33.8688 | 151.2093 | 2022-07-22 04:21:15 | New South Wales, Australia | |||
2022-07-20 | Australia | New South Wales | 3045062 | 3924 | 0 | -33.8688 | 151.2093 | 2022-07-21 04:21:10 | New South Wales, Australia | |||
2022-07-19 | Australia | New South Wales | 3031246 | 3899 | 0 | -33.8688 | 151.2093 | 2022-07-20 04:20:59 | New South Wales, Australia | |||
2022-07-18 | Australia | New South Wales | 3016037 | 3879 | 0 | -33.8688 | 151.2093 | 2022-07-19 04:20:58 | New South Wales, Australia | |||
2022-07-17 | Australia | New South Wales | 3002504 | 3853 | 0 | -33.8688 | 151.2093 | 2022-07-18 04:20:59 | New South Wales, Australia | |||
2022-07-16 | Australia | New South Wales | 2992755 | 3848 | 0 | -33.8688 | 151.2093 | 2022-07-17 04:21:15 | New South Wales, Australia | |||
2022-07-15 | Australia | New South Wales | 2982583 | 3836 | 0 | -33.8688 | 151.2093 | 2022-07-16 04:21:05 | New South Wales, Australia | |||
2022-07-14 | Australia | New South Wales | 2971525 | 3799 | 0 | -33.8688 | 151.2093 | 2022-07-15 04:20:53 | New South Wales, Australia | |||
2022-07-13 | Australia | New South Wales | 2959333 | 3785 | 0 | -33.8688 | 151.2093 | 2022-07-14 04:20:57 | New South Wales, Australia | |||
2022-07-12 | Australia | New South Wales | 2945218 | 3750 | 0 | -33.8688 | 151.2093 | 2022-07-13 04:20:58 | New South Wales, Australia | |||
2022-07-11 | Australia | New South Wales | 2934596 | 3735 | 0 | -33.8688 | 151.2093 | 2022-07-12 04:20:51 | New South Wales, Australia | |||
2022-07-10 | Australia | New South Wales | 2923798 | 3715 | 0 | -33.8688 | 151.2093 | 2022-07-11 04:20:46 | New South Wales, Australia | |||
2022-07-09 | Australia | New South Wales | 2916337 | 3707 | 0 | -33.8688 | 151.2093 | 2022-07-10 04:20:54 | New South Wales, Australia | |||
2022-07-08 | Australia | New South Wales | 2907681 | 3699 | 0 | -33.8688 | 151.2093 | 2022-07-09 04:20:59 | New South Wales, Australia | |||
2022-07-07 | Australia | New South Wales | 2896270 | 3666 | 0 | -33.8688 | 151.2093 | 2022-07-08 04:20:56 | New South Wales, Australia | |||
2022-07-06 | Australia | New South Wales | 2883560 | 3659 | 0 | -33.8688 | 151.2093 | 2022-07-07 04:20:55 | New South Wales, Australia | |||
2022-07-05 | Australia | New South Wales | 2870282 | 3637 | 0 | -33.8688 | 151.2093 | 2022-07-06 04:20:58 | New South Wales, Australia | |||
2022-07-04 | Australia | New South Wales | 2856570 | 3627 | 0 | -33.8688 | 151.2093 | 2022-07-05 04:20:45 | New South Wales, Australia | |||
2022-07-03 | Australia | New South Wales | 2846098 | 3613 | 0 | -33.8688 | 151.2093 | 2022-07-04 04:20:54 | New South Wales, Australia | |||
2022-07-02 | Australia | New South Wales | 2837155 | 3612 | 0 | -33.8688 | 151.2093 | 2022-07-03 04:20:59 | New South Wales, Australia | |||
2022-07-01 | Australia | New South Wales | 2828309 | 3610 | 0 | -33.8688 | 151.2093 | 2022-07-02 04:21:16 | New South Wales, Australia | |||
2022-06-30 | Australia | New South Wales | 2817248 | 3590 | 0 | -33.8688 | 151.2093 | 2022-07-01 04:21:10 | New South Wales, Australia | |||
2022-06-29 | Australia | New South Wales | 2806385 | 3581 | 0 | -33.8688 | 151.2093 | 2022-06-30 04:21:01 | New South Wales, Australia | |||
2022-06-28 | Australia | New South Wales | 2794932 | 3558 | 0 | -33.8688 | 151.2093 | 2022-06-29 04:20:59 | New South Wales, Australia | |||
2022-06-27 | Australia | New South Wales | 2783915 | 3547 | 0 | -33.8688 | 151.2093 | 2022-06-28 04:20:58 | New South Wales, Australia | |||
2022-06-26 | Australia | New South Wales | 2775310 | 3508 | 0 | -33.8688 | 151.2093 | 2022-06-27 04:21:00 | New South Wales, Australia | |||
2022-06-25 | Australia | New South Wales | 2768461 | 3497 | 0 | -33.8688 | 151.2093 | 2022-06-26 04:21:02 | New South Wales, Australia | |||
2022-06-24 | Australia | New South Wales | 2761005 | 3490 | 0 | -33.8688 | 151.2093 | 2022-06-25 04:20:57 | New South Wales, Australia | |||
2022-06-23 | Australia | New South Wales | 2752776 | 3470 | 0 | -33.8688 | 151.2093 | 2022-06-24 04:20:58 | New South Wales, Australia | |||
2022-06-22 | Australia | New South Wales | 2743680 | 3456 | 0 | -33.8688 | 151.2093 | 2022-06-23 04:20:55 | New South Wales, Australia | |||
2022-06-21 | Australia | New South Wales | 2734519 | 3430 | 0 | -33.8688 | 151.2093 | 2022-06-22 04:20:54 | New South Wales, Australia | |||
2022-06-20 | Australia | New South Wales | 2725064 | 3404 | 0 | -33.8688 | 151.2093 | 2022-06-21 04:20:56 | New South Wales, Australia | |||
2022-06-19 | Australia | New South Wales | 2717292 | 3397 | 0 | -33.8688 | 151.2093 | 2022-06-20 04:21:01 | New South Wales, Australia | |||
2022-06-18 | Australia | New South Wales | 2711234 | 3392 | 0 | -33.8688 | 151.2093 | 2022-06-19 04:20:51 | New South Wales, Australia | |||
2022-06-17 | Australia | New South Wales | 2704914 | 3385 | 0 | -33.8688 | 151.2093 | 2022-06-18 04:21:10 | New South Wales, Australia | |||
2022-06-16 | Australia | New South Wales | 2696819 | 3361 | 0 | -33.8688 | 151.2093 | 2022-06-17 04:20:56 | New South Wales, Australia | |||
2022-06-15 | Australia | New South Wales | 2688494 | 3353 | 0 | -33.8688 | 151.2093 | 2022-06-16 04:20:55 | New South Wales, Australia | |||
2022-06-14 | Australia | New South Wales | 2679407 | 3336 | 0 | -33.8688 | 151.2093 | 2022-06-15 04:20:54 | New South Wales, Australia | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;