johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,420 rows where country_or_region = "Australia" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 11
- New South Wales 1,052
- Victoria 1,052
- Queensland 1,050
- South Australia 1,049
- Western Australia 1,026
- Northern Territory 1,025
- Tasmania 1,025
- Australian Capital Territory 1,020
- From Diamond Princess 18
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 8,320 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1192496 | 1192496 | 2020-02-14 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1243391 | 1243391 | 2020-02-17 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
1243393 | 1243393 | 2020-02-17 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
1243394 | 1243394 | 2020-02-17 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
1243398 | 1243398 | 2020-02-17 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1305801 | 1305801 | 2020-01-28 | Australia | New South Wales | 4 | 0 | 0 | -33.8688 | 151.2093 | 1/28/20 23:00 | ||||
1305802 | 1305802 | 2020-01-28 | Australia | Victoria | 1 | 0 | 0 | -37.8136 | 144.9631 | 1/28/20 23:00 | ||||
1366082 | 1366082 | 2020-02-08 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-07T01:03:02 | ||||
1366083 | 1366083 | 2020-02-08 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
1366084 | 1366084 | 2020-02-08 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
1366090 | 1366090 | 2020-02-08 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1463517 | 1463517 | 2020-03-15 | Australia | New South Wales | 134 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-15T18:20:19 | ||||
1463548 | 1463548 | 2020-03-15 | Australia | Queensland | 61 | 0 | 8 | -28.0167 | 153.4 | 2020-03-15T18:20:19 | ||||
1463552 | 1463552 | 2020-03-15 | Australia | Victoria | 57 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-15T18:20:19 | ||||
1463596 | 1463596 | 2020-03-15 | Australia | South Australia | 20 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-15T18:20:19 | ||||
1463605 | 1463605 | 2020-03-15 | Australia | Western Australia | 17 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-14T13:33:04 | ||||
1463636 | 1463636 | 2020-03-15 | Australia | Tasmania | 6 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-15T18:20:19 | ||||
1463678 | 1463678 | 2020-03-15 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-14T01:53:03 | ||||
1463679 | 1463679 | 2020-03-15 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
1463715 | 1463715 | 2020-03-15 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
1526925 | 1526925 | 2020-03-19 | Australia | New South Wales | 307 | 5 | 4 | -33.8688 | 151.2093 | 2020-03-19T11:13:54 | ||||
1526960 | 1526960 | 2020-03-19 | Australia | Queensland | 144 | 0 | 8 | -28.0167 | 153.4 | 2020-03-19T11:13:54 | ||||
1526968 | 1526968 | 2020-03-19 | Australia | Victoria | 121 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-18T12:13:09 | ||||
1527012 | 1527012 | 2020-03-19 | Australia | Western Australia | 52 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-19T11:13:54 | ||||
1527027 | 1527027 | 2020-03-19 | Australia | South Australia | 42 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-19T11:13:54 | ||||
1527078 | 1527078 | 2020-03-19 | Australia | Tasmania | 10 | 0 | 3 | -41.4545 | 145.9707 | 2020-03-19T11:13:54 | ||||
1527099 | 1527099 | 2020-03-19 | Australia | Australian Capital Territory | 4 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-19T11:13:54 | ||||
1527128 | 1527128 | 2020-03-19 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
1527149 | 1527149 | 2020-03-19 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
1527259 | 1527259 | 2020-03-08 | Australia | New South Wales | 38 | 3 | 4 | -33.8688 | 151.2093 | 2020-03-08T05:13:07 | ||||
1527281 | 1527281 | 2020-03-08 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
1527291 | 1527291 | 2020-03-08 | Australia | Victoria | 11 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-07T02:03:30 | ||||
1527302 | 1527302 | 2020-03-08 | Australia | South Australia | 7 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-06T04:23:08 | ||||
1527331 | 1527331 | 2020-03-08 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
1527347 | 1527347 | 2020-03-08 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
1527447 | 1527447 | 2020-03-08 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
1527448 | 1527448 | 2020-03-08 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
1527539 | 1527539 | 2020-01-30 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 1/30/20 16:00 | ||||
1527540 | 1527540 | 2020-01-30 | Australia | Victoria | 2 | 0 | 0 | -37.8136 | 144.9631 | 1/30/20 16:00 | ||||
1527541 | 1527541 | 2020-01-30 | Australia | Queensland | 3 | 0 | 0 | -28.0167 | 153.4 | 1/30/20 16:00 | ||||
1559696 | 1559696 | 2020-02-13 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
1559697 | 1559697 | 2020-02-13 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
1559698 | 1559698 | 2020-02-13 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
1559703 | 1559703 | 2020-02-13 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1720085 | 1720085 | 2020-02-19 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
1720087 | 1720087 | 2020-02-19 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
1720088 | 1720088 | 2020-02-19 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
1720092 | 1720092 | 2020-02-19 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1783117 | 1783117 | 2020-02-18 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
1783119 | 1783119 | 2020-02-18 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
1783120 | 1783120 | 2020-02-18 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
1783124 | 1783124 | 2020-02-18 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1888744 | 1888744 | 2020-02-16 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
1888745 | 1888745 | 2020-02-16 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
1888746 | 1888746 | 2020-02-16 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
1888751 | 1888751 | 2020-02-16 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2091702 | 2091702 | 2020-02-05 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-01T18:12:49 | ||||
2091703 | 2091703 | 2020-02-05 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
2091704 | 2091704 | 2020-02-05 | Australia | Queensland | 3 | 0 | 0 | -28.0167 | 153.4 | 2020-02-04T16:53:03 | ||||
2091706 | 2091706 | 2020-02-05 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2111146 | 2111146 | 2020-03-14 | Australia | New South Wales | 112 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-14T13:33:04 | ||||
2111177 | 2111177 | 2020-03-14 | Australia | Victoria | 49 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-14T13:33:04 | ||||
2111179 | 2111179 | 2020-03-14 | Australia | Queensland | 46 | 0 | 8 | -28.0167 | 153.4 | 2020-03-14T13:33:04 | ||||
2111216 | 2111216 | 2020-03-14 | Australia | South Australia | 19 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-14T13:33:04 | ||||
2111224 | 2111224 | 2020-03-14 | Australia | Western Australia | 17 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-14T13:33:04 | ||||
2111261 | 2111261 | 2020-03-14 | Australia | Tasmania | 5 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-14T01:53:03 | ||||
2111299 | 2111299 | 2020-03-14 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-14T01:53:03 | ||||
2111300 | 2111300 | 2020-03-14 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2111331 | 2111331 | 2020-03-14 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2127490 | 2127490 | 2020-03-11 | Australia | New South Wales | 65 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-11T18:52:04 | ||||
2127517 | 2127517 | 2020-03-11 | Australia | Victoria | 21 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-11T18:52:04 | ||||
2127522 | 2127522 | 2020-03-11 | Australia | Queensland | 20 | 0 | 8 | -28.0167 | 153.4 | 2020-03-11T18:52:04 | ||||
2127549 | 2127549 | 2020-03-11 | Australia | South Australia | 9 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-11T18:52:04 | ||||
2127550 | 2127550 | 2020-03-11 | Australia | Western Australia | 9 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-11T18:52:04 | ||||
2127586 | 2127586 | 2020-03-11 | Australia | Tasmania | 3 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-11T18:52:04 | ||||
2127609 | 2127609 | 2020-03-11 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-10T14:13:14 | ||||
2127634 | 2127634 | 2020-03-11 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2135755 | 2135755 | 2020-02-21 | Australia | Queensland | 5 | 0 | 1 | -28.0167 | 153.4 | 2020-02-21T05:43:02 | ||||
2135757 | 2135757 | 2020-02-21 | Australia | From Diamond Princess | 4 | 0 | 0 | 35.4437 | 139.638 | 2020-02-21T23:03:13 | ||||
2135758 | 2135758 | 2020-02-21 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2135759 | 2135759 | 2020-02-21 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2135762 | 2135762 | 2020-02-21 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2255166 | 2255166 | 2020-03-16 | Australia | New South Wales | 171 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-16T14:38:46 | ||||
2255204 | 2255204 | 2020-03-16 | Australia | Victoria | 71 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-16T14:38:45 | ||||
2255205 | 2255205 | 2020-03-16 | Australia | Queensland | 68 | 0 | 8 | -28.0167 | 153.4 | 2020-03-16T14:38:46 | ||||
2255245 | 2255245 | 2020-03-16 | Australia | South Australia | 29 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-16T14:38:46 | ||||
2255248 | 2255248 | 2020-03-16 | Australia | Western Australia | 28 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-16T14:38:46 | ||||
2255296 | 2255296 | 2020-03-16 | Australia | Tasmania | 7 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-16T14:38:46 | ||||
2255333 | 2255333 | 2020-03-16 | Australia | Australian Capital Territory | 2 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-16T14:38:46 | ||||
2255344 | 2255344 | 2020-03-16 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2255380 | 2255380 | 2020-03-16 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2263493 | 2263493 | 2020-02-20 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
2263496 | 2263496 | 2020-02-20 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2263497 | 2263497 | 2020-02-20 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2263501 | 2263501 | 2020-02-20 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2282925 | 2282925 | 2020-03-12 | Australia | New South Wales | 65 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-11T18:52:04 | ||||
2282955 | 2282955 | 2020-03-12 | Australia | Victoria | 21 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-11T18:52:04 | ||||
2282957 | 2282957 | 2020-03-12 | Australia | Queensland | 20 | 0 | 8 | -28.0167 | 153.4 | 2020-03-11T18:52:04 | ||||
2282992 | 2282992 | 2020-03-12 | Australia | South Australia | 9 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-11T18:52:04 | ||||
2282993 | 2282993 | 2020-03-12 | Australia | Western Australia | 9 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-11T18:52:04 |
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]);