johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13,358 rows where province_or_state = "Unknown" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 15
province_or_state 1
- Unknown · 13,258 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1085671 | 1085671 | 2020-02-22 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1243389 | 1243389 | 2020-02-17 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1720083 | 1720083 | 2020-02-19 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1783115 | 1783115 | 2020-02-18 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1888742 | 1888742 | 2020-02-16 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2135752 | 2135752 | 2020-02-21 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
2263491 | 2263491 | 2020-02-20 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
3173382 | 3173382 | 2020-02-23 | United Kingdom | Unknown | 9 | 0 | 8 | 55.3781 | -3.436 | 2020-02-16T16:23:06 | ||||
1888775 | 1888775 | 2020-02-16 | China | Unknown | 0 | 0 | 0 | 2020-02-16T23:53:01 | ||||||
1888796 | 1888796 | 2020-02-16 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-16T23:53:01 | ||||||
1888803 | 1888803 | 2020-02-16 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-16T23:53:01 | ||||||
1243422 | 1243422 | 2020-02-17 | China | Unknown | 0 | 0 | 0 | 2020-02-17T23:13:06 | ||||||
1243443 | 1243443 | 2020-02-17 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-17T23:13:06 | ||||||
1243450 | 1243450 | 2020-02-17 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-17T23:13:06 | ||||||
1783148 | 1783148 | 2020-02-18 | China | Unknown | 0 | 0 | 0 | 2020-02-18T23:13:11 | ||||||
1783169 | 1783169 | 2020-02-18 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-18T23:13:11 | ||||||
1783176 | 1783176 | 2020-02-18 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-18T23:13:11 | ||||||
1720117 | 1720117 | 2020-02-19 | China | Unknown | 0 | 0 | 0 | 2020-02-19T23:23:02 | ||||||
1720138 | 1720138 | 2020-02-19 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-19T23:23:02 | ||||||
1720145 | 1720145 | 2020-02-19 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-19T23:23:02 | ||||||
2263525 | 2263525 | 2020-02-20 | China | Unknown | 0 | 0 | 0 | 2020-02-20T23:43:02 | ||||||
2263546 | 2263546 | 2020-02-20 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-20T23:43:02 | ||||||
2263553 | 2263553 | 2020-02-20 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-20T23:43:02 | ||||||
2135791 | 2135791 | 2020-02-21 | China | Unknown | 0 | 0 | 0 | 2020-02-21T13:03:09 | ||||||
2135812 | 2135812 | 2020-02-21 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-21T13:03:09 | ||||||
2135819 | 2135819 | 2020-02-21 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-21T13:03:09 | ||||||
1085709 | 1085709 | 2020-02-22 | China | Unknown | 0 | 0 | 0 | 2020-02-22T23:33:06 | ||||||
1085730 | 1085730 | 2020-02-22 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-22T23:33:06 | ||||||
1085737 | 1085737 | 2020-02-22 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-22T23:33:06 | ||||||
3173422 | 3173422 | 2020-02-23 | China | Unknown | 0 | 0 | 0 | 2020-02-23T11:33:03 | ||||||
3173443 | 3173443 | 2020-02-23 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-23T11:33:03 | ||||||
3173450 | 3173450 | 2020-02-23 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-23T11:33:03 | ||||||
479173 | 479173 | 2020-02-25 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
2509792 | 2509792 | 2020-02-26 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
3551235 | 3551235 | 2020-02-24 | United Kingdom | Unknown | 13 | 0 | 8 | 55.3781 | -3.436 | 2020-02-24T08:33:02 | ||||
3551283 | 3551283 | 2020-02-24 | China | Unknown | 0 | 0 | 0 | 2020-02-24T11:13:09 | ||||||
3551304 | 3551304 | 2020-02-24 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-24T11:13:09 | ||||||
3551311 | 3551311 | 2020-02-24 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-24T11:13:09 | ||||||
479224 | 479224 | 2020-02-25 | China | Unknown | 0 | 0 | 0 | 2020-02-25T15:23:04 | ||||||
479245 | 479245 | 2020-02-25 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-25T15:23:04 | ||||||
479252 | 479252 | 2020-02-25 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-25T15:23:04 | ||||||
2509849 | 2509849 | 2020-02-26 | China | Unknown | 0 | 0 | 0 | 2020-02-26T14:13:10 | ||||||
2509870 | 2509870 | 2020-02-26 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-26T14:13:10 | ||||||
2509877 | 2509877 | 2020-02-26 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-26T14:13:10 | ||||||
617496 | 617496 | 2020-02-27 | China | Unknown | 0 | 0 | 0 | 2020-02-27T12:13:14 | ||||||
617517 | 617517 | 2020-02-27 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-27T12:13:14 | ||||||
617524 | 617524 | 2020-02-27 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-27T12:13:14 | ||||||
617436 | 617436 | 2020-02-27 | United Kingdom | Unknown | 15 | 0 | 8 | 55.3781 | -3.436 | 2020-02-27T13:23:02 | ||||
2884018 | 2884018 | 2020-02-28 | China | Unknown | 0 | 0 | 0 | 2020-02-28T00:43:01 | ||||||
2884039 | 2884039 | 2020-02-28 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-28T00:43:01 | ||||||
2884046 | 2884046 | 2020-02-28 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-28T00:43:01 | ||||||
2883949 | 2883949 | 2020-02-28 | United Kingdom | Unknown | 20 | 0 | 8 | 55.3781 | -3.436 | 2020-02-28T20:13:09 | ||||
3205900 | 3205900 | 2020-02-29 | China | Unknown | 0 | 0 | 0 | 2020-02-29T12:13:10 | ||||||
3205921 | 3205921 | 2020-02-29 | Malaysia | Unknown | 0 | 0 | 0 | 2020-02-29T12:13:10 | ||||||
3205928 | 3205928 | 2020-02-29 | Ukraine | Unknown | 0 | 0 | 0 | 2020-02-29T12:13:10 | ||||||
3205826 | 3205826 | 2020-02-29 | United Kingdom | Unknown | 23 | 0 | 8 | 55.3781 | -3.436 | 2020-02-29T18:03:05 | ||||
562617 | 562617 | 2020-03-01 | China | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562638 | 562638 | 2020-03-01 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562645 | 562645 | 2020-03-01 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562537 | 562537 | 2020-03-01 | United Kingdom | Unknown | 36 | 0 | 8 | 55.0 | -3.0 | 2020-03-01T23:23:02 | ||||
1152772 | 1152772 | 2020-03-02 | China | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
1152793 | 1152793 | 2020-03-02 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
1152800 | 1152800 | 2020-03-02 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
1152677 | 1152677 | 2020-03-02 | United Kingdom | Unknown | 40 | 0 | 8 | 55.0 | -3.0 | 2020-03-02T20:33:02 | ||||
261166 | 261166 | 2020-03-03 | China | Unknown | 0 | 0 | 0 | 2020-03-03T11:43:02 | ||||||
261187 | 261187 | 2020-03-03 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-03T11:43:02 | ||||||
261194 | 261194 | 2020-03-03 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-03T11:43:02 | ||||||
261057 | 261057 | 2020-03-03 | United Kingdom | Unknown | 51 | 0 | 8 | 55.0 | -3.0 | 2020-03-03T15:13:26 | ||||
98960 | 98960 | 2020-03-04 | China | Unknown | 0 | 0 | 0 | 2020-03-04T12:53:03 | ||||||
98981 | 98981 | 2020-03-04 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-04T12:53:03 | ||||||
98988 | 98988 | 2020-03-04 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-04T12:53:03 | ||||||
98838 | 98838 | 2020-03-04 | United Kingdom | Unknown | 85 | 0 | 8 | 55.0 | -3.0 | 2020-03-04T19:33:03 | ||||
40303 | 40303 | 2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
40324 | 40324 | 2020-03-05 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
40331 | 40331 | 2020-03-05 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
40164 | 40164 | 2020-03-05 | United Kingdom | Unknown | 115 | 0 | 8 | 55.0 | -3.0 | 2020-03-05T18:03:03 | ||||
3177673 | 3177673 | 2020-03-06 | China | Unknown | 0 | 0 | 0 | 2020-03-06T14:23:04 | ||||||
3177694 | 3177694 | 2020-03-06 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-06T14:23:04 | ||||||
3177701 | 3177701 | 2020-03-06 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-06T14:23:04 | ||||||
3177504 | 3177504 | 2020-03-06 | United Kingdom | Unknown | 163 | 0 | 8 | 55.0 | -3.0 | 2020-03-06T15:33:03 | ||||
62695 | 62695 | 2020-03-07 | China | Unknown | 0 | 0 | 0 | 2020-03-07T11:13:04 | ||||||
62716 | 62716 | 2020-03-07 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-07T11:13:04 | ||||||
62723 | 62723 | 2020-03-07 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-07T11:13:04 | ||||||
62498 | 62498 | 2020-03-07 | United Kingdom | Unknown | 206 | 0 | 18 | 55.0 | -3.0 | 2020-03-07T17:43:05 | ||||
1527453 | 1527453 | 2020-03-08 | China | Unknown | 0 | 0 | 0 | 2020-03-08T14:43:03 | ||||||
1527474 | 1527474 | 2020-03-08 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-08T14:43:03 | ||||||
1527481 | 1527481 | 2020-03-08 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-08T14:43:03 | ||||||
1527224 | 1527224 | 2020-03-08 | United Kingdom | Unknown | 273 | 0 | 18 | 55.0 | -3.0 | 2020-03-08T22:03:10 | ||||
657948 | 657948 | 2020-03-09 | China | Unknown | 0 | 0 | 0 | 2020-03-09T14:33:03 | ||||||
657969 | 657969 | 2020-03-09 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-09T14:33:03 | ||||||
657976 | 657976 | 2020-03-09 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-09T14:33:03 | ||||||
657707 | 657707 | 2020-03-09 | United Kingdom | Unknown | 321 | 0 | 18 | 55.0 | -3.0 | 2020-03-09T18:33:03 | ||||
3753019 | 3753019 | 2020-03-10 | China | Unknown | 0 | 0 | 0 | 2020-03-10T15:13:05 | ||||||
3753040 | 3753040 | 2020-03-10 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-10T15:13:05 | ||||||
3753047 | 3753047 | 2020-03-10 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-10T15:13:05 | ||||||
3752838 | 3752838 | 2020-03-10 | United Kingdom | Unknown | 382 | 0 | 18 | 55.0 | -3.0 | 2020-03-10T23:53:02 | ||||
2127645 | 2127645 | 2020-03-11 | China | Unknown | 0 | 0 | 0 | 2020-03-11T10:53:02 | ||||||
2127666 | 2127666 | 2020-03-11 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-11T10:53:02 | ||||||
2127673 | 2127673 | 2020-03-11 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-11T10:53:02 | ||||||
3765370 | 3765370 | 2020-03-13 | United Kingdom | Unknown | 798 | 0 | 18 | 55.3781 | -3.436 | 2020-03-11T20:00:00 |
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]);