johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,068 rows where province_or_state = "New South Wales" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • New South Wales · 1,068 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752584 2752584 2022-12-29 Australia New South Wales     3825104 5804 0   -33.8688 151.2093 2022-12-30 04:21:04 New South Wales, Australia
1073590 1073590 2022-12-28 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-29 04:21:01 New South Wales, Australia
327587 327587 2022-12-27 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-28 04:21:04 New South Wales, Australia
217660 217660 2022-12-26 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-27 04:21:07 New South Wales, Australia
3222117 3222117 2022-12-25 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-26 04:21:06 New South Wales, Australia
1018031 1018031 2022-12-24 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-25 04:21:04 New South Wales, Australia
690054 690054 2022-12-23 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-24 04:21:02 New South Wales, Australia
2179264 2179264 2022-12-22 Australia New South Wales     3797451 5772 0   -33.8688 151.2093 2022-12-23 04:21:04 New South Wales, Australia
451068 451068 2022-12-21 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-22 04:20:56 New South Wales, Australia
2951067 2951067 2022-12-20 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-21 04:21:03 New South Wales, Australia
3173469 3173469 2022-12-19 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-20 04:21:04 New South Wales, Australia
1627986 1627986 2022-12-18 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-19 04:21:03 New South Wales, Australia
503365 503365 2022-12-17 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-18 04:21:03 New South Wales, Australia
3323937 3323937 2022-12-16 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-17 04:21:04 New South Wales, Australia
542449 542449 2022-12-15 Australia New South Wales     3759120 5694 0   -33.8688 151.2093 2022-12-16 04:21:01 New South Wales, Australia
347977 347977 2022-12-14 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-15 04:20:58 New South Wales, Australia
307565 307565 2022-12-13 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-14 04:21:04 New South Wales, Australia
1148626 1148626 2022-12-12 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-13 04:21:01 New South Wales, Australia
868480 868480 2022-12-11 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-12 04:21:01 New South Wales, Australia
257010 257010 2022-12-10 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-11 04:20:50 New South Wales, Australia
3935724 3935724 2022-12-09 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-10 04:21:02 New South Wales, Australia
3377056 3377056 2022-12-08 Australia New South Wales     3718440 5620 0   -33.8688 151.2093 2022-12-09 04:21:05 New South Wales, Australia
1984327 1984327 2022-12-07 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-08 04:21:07 New South Wales, Australia
3713850 3713850 2022-12-06 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-07 04:20:58 New South Wales, Australia
2414555 2414555 2022-12-05 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-06 04:21:03 New South Wales, Australia
718163 718163 2022-12-04 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-05 04:20:58 New South Wales, Australia
2816452 2816452 2022-12-03 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-04 04:20:56 New South Wales, Australia
833308 833308 2022-12-02 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-03 04:21:02 New South Wales, Australia
2135838 2135838 2022-12-01 Australia New South Wales     3678261 5572 0   -33.8688 151.2093 2022-12-02 04:21:07 New South Wales, Australia
1964254 1964254 2022-11-30 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-12-01 04:21:03 New South Wales, Australia
2556268 2556268 2022-11-29 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-30 04:21:07 New South Wales, Australia
1239342 1239342 2022-11-28 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-29 04:21:05 New South Wales, Australia
3551330 3551330 2022-11-27 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-28 04:21:02 New South Wales, Australia
2099810 2099810 2022-11-26 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-27 04:21:05 New South Wales, Australia
487301 487301 2022-11-25 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-26 04:21:11 New South Wales, Australia
3523130 3523130 2022-11-24 Australia New South Wales     3640480 5540 0   -33.8688 151.2093 2022-11-25 04:21:06 New South Wales, Australia
3311913 3311913 2022-11-23 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-24 04:21:09 New South Wales, Australia
1619954 1619954 2022-11-22 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-23 04:21:06 New South Wales, Australia
3459842 3459842 2022-11-21 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-22 04:20:47 New South Wales, Australia
1640027 1640027 2022-11-20 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-21 04:21:05 New South Wales, Australia
2063584 2063584 2022-11-19 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-20 04:21:08 New South Wales, Australia
1754978 1754978 2022-11-18 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-19 04:21:14 New South Wales, Australia
3025971 3025971 2022-11-17 Australia New South Wales     3608974 5515 0   -33.8688 151.2093 2022-11-18 04:21:15 New South Wales, Australia
2485682 2485682 2022-11-16 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-17 04:21:11 New South Wales, Australia
291693 291693 2022-11-15 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-16 04:21:09 New South Wales, Australia
3596723 3596723 2022-11-14 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-15 04:21:16 New South Wales, Australia
311581 311581 2022-11-13 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-14 04:21:09 New South Wales, Australia
62742 62742 2022-11-12 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-13 04:21:14 New South Wales, Australia
2926904 2926904 2022-11-11 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-12 04:20:41 New South Wales, Australia
2505740 2505740 2022-11-10 Australia New South Wales     3581110 5476 0   -33.8688 151.2093 2022-11-11 04:21:22 New South Wales, Australia
2430615 2430615 2022-11-09 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-10 04:21:16 New South Wales, Australia
479271 479271 2022-11-08 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-09 04:21:22 New South Wales, Australia
2438421 2438421 2022-11-07 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-08 04:21:21 New South Wales, Australia
1049519 1049519 2022-11-06 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-07 04:21:26 New South Wales, Australia
617543 617543 2022-11-05 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-06 04:21:24 New South Wales, Australia
1022047 1022047 2022-11-04 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-05 04:21:52 New South Wales, Australia
431038 431038 2022-11-03 Australia New South Wales     3561735 5454 0   -33.8688 151.2093 2022-11-04 04:22:11 New South Wales, Australia
849280 849280 2022-11-02 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-11-03 04:22:05 New South Wales, Australia
710131 710131 2022-11-01 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-11-02 04:22:09 New South Wales, Australia
3284580 3284580 2022-10-31 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-11-01 04:22:36 New South Wales, Australia
319613 319613 2022-10-30 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-10-31 04:21:36 New South Wales, Australia
911889 911889 2022-10-29 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-10-30 04:22:14 New South Wales, Australia
1366158 1366158 2022-10-28 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-10-29 04:21:13 New South Wales, Australia
3038013 3038013 2022-10-27 Australia New South Wales     3549295 5430 0   -33.8688 151.2093 2022-10-28 04:22:31 New South Wales, Australia
538433 538433 2022-10-26 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-27 04:22:01 New South Wales, Australia
1829834 1829834 2022-10-25 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-26 04:22:19 New South Wales, Australia
794095 794095 2022-10-24 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-25 04:21:53 New South Wales, Australia
3276550 3276550 2022-10-23 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-24 04:22:29 New South Wales, Australia
2267588 2267588 2022-10-22 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-23 04:22:46 New South Wales, Australia
1591888 1591888 2022-10-21 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-22 04:22:53 New South Wales, Australia
2271604 2271604 2022-10-20 Australia New South Wales     3539264 5414 0   -33.8688 151.2093 2022-10-21 04:22:23 New South Wales, Australia
197939 197939 2022-10-19 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-20 04:22:59 New South Wales, Australia
2756600 2756600 2022-10-18 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-19 04:22:26 New South Wales, Australia
2024434 2024434 2022-10-17 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-18 04:22:42 New South Wales, Australia
2159212 2159212 2022-10-16 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-17 04:20:31 New South Wales, Australia
515409 515409 2022-10-15 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-16 04:22:39 New South Wales, Australia
2032466 2032466 2022-10-14 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-15 04:22:00 New South Wales, Australia
3753154 3753154 2022-10-13 Australia New South Wales     3530443 5392 0   -33.8688 151.2093 2022-10-14 04:22:28 New South Wales, Australia
3213979 3213979 2022-10-12 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-13 04:22:39 New South Wales, Australia
3249828 3249828 2022-10-11 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-12 04:22:51 New South Wales, Australia
2967087 2967087 2022-10-10 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-11 04:23:05 New South Wales, Australia
3097123 3097123 2022-10-09 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-10 04:22:32 New South Wales, Australia
4002348 4002348 2022-10-08 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-09 04:21:16 New South Wales, Australia
395945 395945 2022-10-07 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-08 04:22:56 New South Wales, Australia
2529062 2529062 2022-10-06 Australia New South Wales     3518633 5355 0   -33.8688 151.2093 2022-10-07 04:23:08 New South Wales, Australia
1810456 1810456 2022-10-05 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-06 04:21:22 New South Wales, Australia
130430 130430 2022-10-04 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-05 04:23:06 New South Wales, Australia
2685377 2685377 2022-10-03 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-04 04:22:55 New South Wales, Australia
2259444 2259444 2022-10-02 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-03 04:23:11 New South Wales, Australia
2994970 2994970 2022-10-01 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-02 04:21:23 New South Wales, Australia
853296 853296 2022-09-30 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-10-01 04:23:01 New South Wales, Australia
2375222 2375222 2022-09-29 Australia New South Wales     3507880 5314 0   -33.8688 151.2093 2022-09-30 04:23:09 New South Wales, Australia
1559773 1559773 2022-09-28 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-29 04:22:34 New South Wales, Australia
3994316 3994316 2022-09-27 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-28 04:23:01 New South Wales, Australia
2768644 2768644 2022-09-26 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-27 04:23:01 New South Wales, Australia
1976297 1976297 2022-09-25 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-26 04:20:52 New South Wales, Australia
2649464 2649464 2022-09-24 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-25 04:23:31 New South Wales, Australia
383904 383904 2022-09-23 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-24 04:21:40 New South Wales, Australia
1623970 1623970 2022-09-22 Australia New South Wales     3495306 5232 0   -33.8688 151.2093 2022-09-23 04:23:13 New South Wales, Australia
1370174 1370174 2022-09-21 Australia New South Wales     3481151 5163 0   -33.8688 151.2093 2022-09-22 04:22:56 New South Wales, Australia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);