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 country_or_region = "Australia" and province_or_state = "Victoria" 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

  • Victoria · 1,068 ✖

country_or_region 1

  • Australia · 1,068 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752589 2752589 2022-12-29 Australia Victoria     2833882 6382 0   -37.8136 144.9631 2022-12-30 04:21:04 Victoria, Australia
1073595 1073595 2022-12-28 Australia Victoria     2830731 6362 0   -37.8136 144.9631 2022-12-29 04:21:01 Victoria, Australia
327592 327592 2022-12-27 Australia Victoria     2827994 6338 0   -37.8136 144.9631 2022-12-28 04:21:04 Victoria, Australia
217665 217665 2022-12-26 Australia Victoria     2825877 6338 0   -37.8136 144.9631 2022-12-27 04:21:07 Victoria, Australia
3222122 3222122 2022-12-25 Australia Victoria     2823987 6338 0   -37.8136 144.9631 2022-12-26 04:21:06 Victoria, Australia
1018036 1018036 2022-12-24 Australia Victoria     2822382 6338 0   -37.8136 144.9631 2022-12-25 04:21:04 Victoria, Australia
690059 690059 2022-12-23 Australia Victoria     2820140 6338 0   -37.8136 144.9631 2022-12-24 04:21:02 Victoria, Australia
2179269 2179269 2022-12-22 Australia Victoria     2817370 6316 0   -37.8136 144.9631 2022-12-23 04:21:04 Victoria, Australia
451073 451073 2022-12-21 Australia Victoria     2813883 6299 0   -37.8136 144.9631 2022-12-22 04:20:56 Victoria, Australia
2951072 2951072 2022-12-20 Australia Victoria     2810305 6277 0   -37.8136 144.9631 2022-12-21 04:21:03 Victoria, Australia
3173474 3173474 2022-12-19 Australia Victoria     2806129 6255 0   -37.8136 144.9631 2022-12-20 04:21:04 Victoria, Australia
1627991 1627991 2022-12-18 Australia Victoria     2802299 6235 0   -37.8136 144.9631 2022-12-19 04:21:03 Victoria, Australia
503370 503370 2022-12-17 Australia Victoria     2796503 6235 0   -37.8136 144.9631 2022-12-18 04:21:03 Victoria, Australia
3323942 3323942 2022-12-16 Australia Victoria     2796503 6235 0   -37.8136 144.9631 2022-12-17 04:21:04 Victoria, Australia
542454 542454 2022-12-15 Australia Victoria     2793223 6216 0   -37.8136 144.9631 2022-12-16 04:21:01 Victoria, Australia
347982 347982 2022-12-14 Australia Victoria     2789650 6203 0   -37.8136 144.9631 2022-12-15 04:20:58 Victoria, Australia
307570 307570 2022-12-13 Australia Victoria     2785441 6183 0   -37.8136 144.9631 2022-12-14 04:21:04 Victoria, Australia
1148631 1148631 2022-12-12 Australia Victoria     2781559 6173 0   -37.8136 144.9631 2022-12-13 04:21:01 Victoria, Australia
868485 868485 2022-12-11 Australia Victoria     2777183 6153 0   -37.8136 144.9631 2022-12-12 04:21:01 Victoria, Australia
257015 257015 2022-12-10 Australia Victoria     2774310 6153 0   -37.8136 144.9631 2022-12-11 04:20:50 Victoria, Australia
3935729 3935729 2022-12-09 Australia Victoria     2771624 6153 0   -37.8136 144.9631 2022-12-10 04:21:02 Victoria, Australia
3377061 3377061 2022-12-08 Australia Victoria     2768656 6132 0   -37.8136 144.9631 2022-12-09 04:21:05 Victoria, Australia
1984332 1984332 2022-12-07 Australia Victoria     2764865 6127 0   -37.8136 144.9631 2022-12-08 04:21:07 Victoria, Australia
3713855 3713855 2022-12-06 Australia Victoria     2760581 6107 0   -37.8136 144.9631 2022-12-07 04:20:58 Victoria, Australia
2414560 2414560 2022-12-05 Australia Victoria     2756204 6087 0   -37.8136 144.9631 2022-12-06 04:21:03 Victoria, Australia
718168 718168 2022-12-04 Australia Victoria     2751361 6067 0   -37.8136 144.9631 2022-12-05 04:20:58 Victoria, Australia
2816457 2816457 2022-12-03 Australia Victoria     2748250 6067 0   -37.8136 144.9631 2022-12-04 04:20:56 Victoria, Australia
833313 833313 2022-12-02 Australia Victoria     2745077 6067 0   -37.8136 144.9631 2022-12-03 04:21:02 Victoria, Australia
2135843 2135843 2022-12-01 Australia Victoria     2740933 6047 0   -37.8136 144.9631 2022-12-02 04:21:07 Victoria, Australia
1964259 1964259 2022-11-30 Australia Victoria     2737064 6040 0   -37.8136 144.9631 2022-12-01 04:21:03 Victoria, Australia
2556273 2556273 2022-11-29 Australia Victoria     2732762 6027 0   -37.8136 144.9631 2022-11-30 04:21:07 Victoria, Australia
1239347 1239347 2022-11-28 Australia Victoria     2728384 6022 0   -37.8136 144.9631 2022-11-29 04:21:05 Victoria, Australia
3551335 3551335 2022-11-27 Australia Victoria     2724235 6003 0   -37.8136 144.9631 2022-11-28 04:21:02 Victoria, Australia
2099815 2099815 2022-11-26 Australia Victoria     2721084 6003 0   -37.8136 144.9631 2022-11-27 04:21:05 Victoria, Australia
487306 487306 2022-11-25 Australia Victoria     2717657 6003 0   -37.8136 144.9631 2022-11-26 04:21:11 Victoria, Australia
3523135 3523135 2022-11-24 Australia Victoria     2714014 5999 0   -37.8136 144.9631 2022-11-25 04:21:06 Victoria, Australia
3311918 3311918 2022-11-23 Australia Victoria     2710843 5990 0   -37.8136 144.9631 2022-11-24 04:21:09 Victoria, Australia
1619959 1619959 2022-11-22 Australia Victoria     2707003 5978 0   -37.8136 144.9631 2022-11-23 04:21:06 Victoria, Australia
3459847 3459847 2022-11-21 Australia Victoria     2703142 5971 0   -37.8136 144.9631 2022-11-22 04:20:47 Victoria, Australia
1640032 1640032 2022-11-20 Australia Victoria     2699335 5944 0   -37.8136 144.9631 2022-11-21 04:21:05 Victoria, Australia
2063589 2063589 2022-11-19 Australia Victoria     2696774 5944 0   -37.8136 144.9631 2022-11-20 04:21:08 Victoria, Australia
1754983 1754983 2022-11-18 Australia Victoria     2694367 5944 0   -37.8136 144.9631 2022-11-19 04:21:14 Victoria, Australia
3025976 3025976 2022-11-17 Australia Victoria     2694518 5942 0   -37.8136 144.9631 2022-11-18 04:21:15 Victoria, Australia
2485687 2485687 2022-11-16 Australia Victoria     2691818 5936 0   -37.8136 144.9631 2022-11-17 04:21:11 Victoria, Australia
291698 291698 2022-11-15 Australia Victoria     2688568 5928 0   -37.8136 144.9631 2022-11-16 04:21:09 Victoria, Australia
3596728 3596728 2022-11-14 Australia Victoria     2685116 5918 0   -37.8136 144.9631 2022-11-15 04:21:16 Victoria, Australia
311586 311586 2022-11-13 Australia Victoria     2681924 5907 0   -37.8136 144.9631 2022-11-14 04:21:09 Victoria, Australia
62747 62747 2022-11-12 Australia Victoria     2677113 5907 0   -37.8136 144.9631 2022-11-13 04:21:14 Victoria, Australia
2926909 2926909 2022-11-11 Australia Victoria     2677113 5907 0   -37.8136 144.9631 2022-11-12 04:20:41 Victoria, Australia
2505745 2505745 2022-11-10 Australia Victoria     2674120 5896 0   -37.8136 144.9631 2022-11-11 04:21:22 Victoria, Australia
2430620 2430620 2022-11-09 Australia Victoria     2671457 5897 0   -37.8136 144.9631 2022-11-10 04:21:16 Victoria, Australia
479276 479276 2022-11-08 Australia Victoria     2668400 5888 0   -37.8136 144.9631 2022-11-09 04:21:22 Victoria, Australia
2438426 2438426 2022-11-07 Australia Victoria     2665027 5872 0   -37.8136 144.9631 2022-11-08 04:21:21 Victoria, Australia
1049524 1049524 2022-11-06 Australia Victoria     2662318 5866 0   -37.8136 144.9631 2022-11-07 04:21:26 Victoria, Australia
617548 617548 2022-11-05 Australia Victoria     2660447 5866 0   -37.8136 144.9631 2022-11-06 04:21:24 Victoria, Australia
1022052 1022052 2022-11-04 Australia Victoria     2658734 5866 0   -37.8136 144.9631 2022-11-05 04:21:52 Victoria, Australia
431043 431043 2022-11-03 Australia Victoria     2656842 5856 0   -37.8136 144.9631 2022-11-04 04:22:11 Victoria, Australia
849285 849285 2022-11-02 Australia Victoria     2654825 5854 0   -37.8136 144.9631 2022-11-03 04:22:05 Victoria, Australia
710136 710136 2022-11-01 Australia Victoria     2652945 5841 0   -37.8136 144.9631 2022-11-02 04:22:09 Victoria, Australia
3284585 3284585 2022-10-31 Australia Victoria     2651262 5841 0   -37.8136 144.9631 2022-11-01 04:22:36 Victoria, Australia
319618 319618 2022-10-30 Australia Victoria     2649608 5836 0   -37.8136 144.9631 2022-10-31 04:21:36 Victoria, Australia
911894 911894 2022-10-29 Australia Victoria     2648473 5836 0   -37.8136 144.9631 2022-10-30 04:22:14 Victoria, Australia
1366163 1366163 2022-10-28 Australia Victoria     2647295 5836 0   -37.8136 144.9631 2022-10-29 04:21:13 Victoria, Australia
3038018 3038018 2022-10-27 Australia Victoria     2645945 5833 0   -37.8136 144.9631 2022-10-28 04:22:31 Victoria, Australia
538438 538438 2022-10-26 Australia Victoria     2644620 5820 0   -37.8136 144.9631 2022-10-27 04:22:01 Victoria, Australia
1829839 1829839 2022-10-25 Australia Victoria     2643137 5817 0   -37.8136 144.9631 2022-10-26 04:22:19 Victoria, Australia
794100 794100 2022-10-24 Australia Victoria     2641588 5811 0   -37.8136 144.9631 2022-10-25 04:21:53 Victoria, Australia
3276555 3276555 2022-10-23 Australia Victoria     2640079 5800 0   -37.8136 144.9631 2022-10-24 04:22:29 Victoria, Australia
2267593 2267593 2022-10-22 Australia Victoria     2639159 5800 0   -37.8136 144.9631 2022-10-23 04:22:46 Victoria, Australia
1591893 1591893 2022-10-21 Australia Victoria     2638210 5800 0   -37.8136 144.9631 2022-10-22 04:22:53 Victoria, Australia
2271609 2271609 2022-10-20 Australia Victoria     2637220 5784 0   -37.8136 144.9631 2022-10-21 04:22:23 Victoria, Australia
197944 197944 2022-10-19 Australia Victoria     2636103 5779 0   -37.8136 144.9631 2022-10-20 04:22:59 Victoria, Australia
2756605 2756605 2022-10-18 Australia Victoria     2635010 5773 0   -37.8136 144.9631 2022-10-19 04:22:26 Victoria, Australia
2024439 2024439 2022-10-17 Australia Victoria     2633804 5770 0   -37.8136 144.9631 2022-10-18 04:22:42 Victoria, Australia
2159217 2159217 2022-10-16 Australia Victoria     2632717 5758 0   -37.8136 144.9631 2022-10-17 04:20:31 Victoria, Australia
515414 515414 2022-10-15 Australia Victoria     2631917 5758 0   -37.8136 144.9631 2022-10-16 04:22:39 Victoria, Australia
2032471 2032471 2022-10-14 Australia Victoria     2631296 5758 0   -37.8136 144.9631 2022-10-15 04:22:00 Victoria, Australia
3753159 3753159 2022-10-13 Australia Victoria     2630360 5751 0   -37.8136 144.9631 2022-10-14 04:22:28 Victoria, Australia
3213984 3213984 2022-10-12 Australia Victoria     2628125 5747 0   -37.8136 144.9631 2022-10-13 04:22:39 Victoria, Australia
3249833 3249833 2022-10-11 Australia Victoria     2626888 5737 0   -37.8136 144.9631 2022-10-12 04:22:51 Victoria, Australia
2967092 2967092 2022-10-10 Australia Victoria     2625569 5731 0   -37.8136 144.9631 2022-10-11 04:23:05 Victoria, Australia
3097128 3097128 2022-10-09 Australia Victoria     2624277 5717 0   -37.8136 144.9631 2022-10-10 04:22:32 Victoria, Australia
4002353 4002353 2022-10-08 Australia Victoria     2623238 5717 0   -37.8136 144.9631 2022-10-09 04:21:16 Victoria, Australia
395950 395950 2022-10-07 Australia Victoria     2622419 5717 0   -37.8136 144.9631 2022-10-08 04:22:56 Victoria, Australia
2529067 2529067 2022-10-06 Australia Victoria     2622436 5664 0   -37.8136 144.9631 2022-10-07 04:23:08 Victoria, Australia
1810461 1810461 2022-10-05 Australia Victoria     2620352 5706 0   -37.8136 144.9631 2022-10-06 04:21:22 Victoria, Australia
130435 130435 2022-10-04 Australia Victoria     2618909 5691 0   -37.8136 144.9631 2022-10-05 04:23:06 Victoria, Australia
2685382 2685382 2022-10-03 Australia Victoria     2617377 5685 0   -37.8136 144.9631 2022-10-04 04:22:55 Victoria, Australia
2259449 2259449 2022-10-02 Australia Victoria     2615921 5678 0   -37.8136 144.9631 2022-10-03 04:23:11 Victoria, Australia
2994975 2994975 2022-10-01 Australia Victoria     2614813 5678 0   -37.8136 144.9631 2022-10-02 04:21:23 Victoria, Australia
853301 853301 2022-09-30 Australia Victoria     2613835 5678 0   -37.8136 144.9631 2022-10-01 04:23:01 Victoria, Australia
2375227 2375227 2022-09-29 Australia Victoria     2613497 5631 0   -37.8136 144.9631 2022-09-30 04:23:09 Victoria, Australia
1559778 1559778 2022-09-28 Australia Victoria     2612611 5631 0   -37.8136 144.9631 2022-09-29 04:22:34 Victoria, Australia
3994321 3994321 2022-09-27 Australia Victoria     2610959 5610 0   -37.8136 144.9631 2022-09-28 04:23:01 Victoria, Australia
2768649 2768649 2022-09-26 Australia Victoria     2609329 5597 0   -37.8136 144.9631 2022-09-27 04:23:01 Victoria, Australia
1976302 1976302 2022-09-25 Australia Victoria     2607567 5575 0   -37.8136 144.9631 2022-09-26 04:20:52 Victoria, Australia
2649469 2649469 2022-09-24 Australia Victoria     2605163 5572 0   -37.8136 144.9631 2022-09-25 04:23:31 Victoria, Australia
383909 383909 2022-09-23 Australia Victoria     2605163 5572 0   -37.8136 144.9631 2022-09-24 04:21:40 Victoria, Australia
1623975 1623975 2022-09-22 Australia Victoria     2604039 5572 0   -37.8136 144.9631 2022-09-23 04:23:13 Victoria, Australia
1370179 1370179 2022-09-21 Australia Victoria     2603226 5606 0   -37.8136 144.9631 2022-09-22 04:22:56 Victoria, 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]);