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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 15
province_or_state 1
- Unknown · 4,902 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3675371 | 3675371 | 2021-05-04 | Belgium | Unknown | 19016 | 24367 | 0 | 0 | 2021-05-05 04:20:43 | Unknown, Belgium | ||||
3675448 | 3675448 | 2021-05-04 | Chile | Unknown | 55 | 0 | 55 | 0 | 2021-05-05 04:20:43 | Unknown, Chile | ||||
3675480 | 3675480 | 2021-05-04 | China | Unknown | 8851 | 0 | 7 | 0 | 2021-05-05 04:20:43 | Unknown, China | ||||
3675514 | 3675514 | 2021-05-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-05 04:20:43 | Unknown, Colombia | ||||
3675575 | 3675575 | 2021-05-04 | Germany | Unknown | 10569 | 0 | 0 | 10569 | 2021-05-05 04:20:43 | Unknown, Germany | ||||
3675621 | 3675621 | 2021-05-04 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-05 04:20:43 | Unknown, India | ||||
3675696 | 3675696 | 2021-05-04 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-05-05 04:20:43 | Unknown, Japan | ||||
3675755 | 3675755 | 2021-05-04 | Mexico | Unknown | 0 | 0 | 1875211 | 0 | 2021-05-05 04:20:43 | Unknown, Mexico | ||||
3675781 | 3675781 | 2021-05-04 | Netherlands | Unknown | 2809 | 26 | 0 | 3676 | 2021-05-05 04:20:43 | Unknown, Netherlands | ||||
3675827 | 3675827 | 2021-05-04 | Peru | Unknown | 0 | 0 | 1761205 | 0 | 2021-05-05 04:20:43 | Unknown, Peru | ||||
3675954 | 3675954 | 2021-05-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
3679310 | 3679310 | 2021-05-04 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-05 04:20:43 | Unknown, United Kingdom | ||
3679341 | 3679341 | 2021-05-04 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-05 04:20:43 | Unknown, Malaysia | ||||
3679348 | 3679348 | 2021-05-04 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-05 04:20:43 | Unknown, Ukraine | ||||
2760638 | 2760638 | 2021-05-03 | Belgium | Unknown | 18972 | 24322 | 0 | 0 | 2021-05-04 04:20:34 | Unknown, Belgium | ||||
2760715 | 2760715 | 2021-05-03 | Chile | Unknown | 72 | 0 | 55 | 17 | 2021-05-04 04:20:34 | Unknown, Chile | ||||
2760747 | 2760747 | 2021-05-03 | China | Unknown | 8836 | 0 | 8 | 0 | 2021-05-04 04:20:34 | Unknown, China | ||||
2760781 | 2760781 | 2021-05-03 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-04 04:20:34 | Unknown, Colombia | ||||
2760842 | 2760842 | 2021-05-03 | Germany | Unknown | 4459 | 0 | 0 | 4459 | 2021-05-04 04:20:34 | Unknown, Germany | ||||
2760888 | 2760888 | 2021-05-03 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-04 04:20:34 | Unknown, India | ||||
2760963 | 2760963 | 2021-05-03 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-05-04 04:20:34 | Unknown, Japan | ||||
2761022 | 2761022 | 2021-05-03 | Mexico | Unknown | 0 | 0 | 1872375 | 0 | 2021-05-04 04:20:34 | Unknown, Mexico | ||||
2761048 | 2761048 | 2021-05-03 | Netherlands | Unknown | 2834 | 23 | 0 | 3659 | 2021-05-04 04:20:34 | Unknown, Netherlands | ||||
2761094 | 2761094 | 2021-05-03 | Peru | Unknown | 3129 | 249 | 1761205 | 0 | 2021-05-04 04:20:34 | Unknown, Peru | ||||
2761221 | 2761221 | 2021-05-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
2764577 | 2764577 | 2021-05-03 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-04 04:20:34 | Unknown, United Kingdom | ||
2764608 | 2764608 | 2021-05-03 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-04 04:20:34 | Unknown, Malaysia | ||||
2764615 | 2764615 | 2021-05-03 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-04 04:20:34 | Unknown, Ukraine | ||||
2450491 | 2450491 | 2021-05-02 | Belgium | Unknown | 18934 | 24291 | 0 | 0 | 2021-05-03 04:20:39 | Unknown, Belgium | ||||
2450568 | 2450568 | 2021-05-02 | Chile | Unknown | 68 | 0 | 55 | 13 | 2021-05-03 04:20:39 | Unknown, Chile | ||||
2450600 | 2450600 | 2021-05-02 | China | Unknown | 8824 | 0 | 9 | 0 | 2021-05-03 04:20:39 | Unknown, China | ||||
2450634 | 2450634 | 2021-05-02 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-03 04:20:39 | Unknown, Colombia | ||||
2450695 | 2450695 | 2021-05-02 | Germany | Unknown | 6568 | 0 | 0 | 6568 | 2021-05-03 04:20:39 | Unknown, Germany | ||||
2450741 | 2450741 | 2021-05-02 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-03 04:20:39 | Unknown, India | ||||
2450816 | 2450816 | 2021-05-02 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-05-03 04:20:39 | Unknown, Japan | ||||
2450875 | 2450875 | 2021-05-02 | Mexico | Unknown | 0 | 0 | 1869529 | 0 | 2021-05-03 04:20:39 | Unknown, Mexico | ||||
2450901 | 2450901 | 2021-05-02 | Netherlands | Unknown | 2819 | 27 | 0 | 3649 | 2021-05-03 04:20:39 | Unknown, Netherlands | ||||
2450947 | 2450947 | 2021-05-02 | Peru | Unknown | 0 | 0 | 1748170 | 0 | 2021-05-03 04:20:39 | Unknown, Peru | ||||
2451074 | 2451074 | 2021-05-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
2454430 | 2454430 | 2021-05-02 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-03 04:20:39 | Unknown, United Kingdom | ||
2454461 | 2454461 | 2021-05-02 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-03 04:20:39 | Unknown, Malaysia | ||||
2454468 | 2454468 | 2021-05-02 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-03 04:20:39 | Unknown, Ukraine | ||||
2824504 | 2824504 | 2021-05-01 | Belgium | Unknown | 18861 | 24258 | 0 | 0 | 2021-05-02 04:20:48 | Unknown, Belgium | ||||
2824581 | 2824581 | 2021-05-01 | Chile | Unknown | 55 | 0 | 48 | 7 | 2021-05-02 04:20:48 | Unknown, Chile | ||||
2824613 | 2824613 | 2021-05-01 | China | Unknown | 8808 | 0 | 7 | 0 | 2021-05-02 04:20:48 | Unknown, China | ||||
2824647 | 2824647 | 2021-05-01 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-02 04:20:48 | Unknown, Colombia | ||||
2824708 | 2824708 | 2021-05-01 | Germany | Unknown | 6833 | 0 | 0 | 6833 | 2021-05-02 04:20:48 | Unknown, Germany | ||||
2824754 | 2824754 | 2021-05-01 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-02 04:20:48 | Unknown, India | ||||
2824829 | 2824829 | 2021-05-01 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-05-02 04:20:48 | Unknown, Japan | ||||
2824888 | 2824888 | 2021-05-01 | Mexico | Unknown | 0 | 0 | 1867191 | 0 | 2021-05-02 04:20:48 | Unknown, Mexico | ||||
2824914 | 2824914 | 2021-05-01 | Netherlands | Unknown | 2763 | 27 | 0 | 3574 | 2021-05-02 04:20:48 | Unknown, Netherlands | ||||
2824960 | 2824960 | 2021-05-01 | Peru | Unknown | 0 | 0 | 1741861 | 0 | 2021-05-02 04:20:48 | Unknown, Peru | ||||
2825087 | 2825087 | 2021-05-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
2828443 | 2828443 | 2021-05-01 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-02 04:20:48 | Unknown, United Kingdom | ||
2828474 | 2828474 | 2021-05-01 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-02 04:20:48 | Unknown, Malaysia | ||||
2828481 | 2828481 | 2021-05-01 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-02 04:20:48 | Unknown, Ukraine | ||||
379912 | 379912 | 2021-04-30 | Belgium | Unknown | 18782 | 24230 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, Belgium | ||||
379989 | 379989 | 2021-04-30 | Chile | Unknown | 55 | 0 | 48 | 7 | 2021-05-01 04:20:47 | Unknown, Chile | ||||
380021 | 380021 | 2021-04-30 | China | Unknown | 8796 | 0 | 4 | 0 | 2021-05-01 04:20:47 | Unknown, China | ||||
380055 | 380055 | 2021-04-30 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, Colombia | ||||
380116 | 380116 | 2021-04-30 | Germany | Unknown | 4658 | 0 | 0 | 4658 | 2021-05-01 04:20:47 | Unknown, Germany | ||||
380162 | 380162 | 2021-04-30 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, India | ||||
380237 | 380237 | 2021-04-30 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-05-01 04:20:47 | Unknown, Japan | ||||
380296 | 380296 | 2021-04-30 | Mexico | Unknown | 0 | 0 | 1864914 | 0 | 2021-05-01 04:20:47 | Unknown, Mexico | ||||
380322 | 380322 | 2021-04-30 | Netherlands | Unknown | 2786 | 24 | 0 | 3537 | 2021-05-01 04:20:47 | Unknown, Netherlands | ||||
380368 | 380368 | 2021-04-30 | Peru | Unknown | 0 | 0 | 1736183 | 0 | 2021-05-01 04:20:47 | Unknown, Peru | ||||
380495 | 380495 | 2021-04-30 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
383851 | 383851 | 2021-04-30 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-01 04:20:47 | Unknown, United Kingdom | ||
383882 | 383882 | 2021-04-30 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, Malaysia | ||||
383889 | 383889 | 2021-04-30 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, Ukraine | ||||
1636035 | 1636035 | 2021-04-29 | Belgium | Unknown | 18713 | 24185 | 0 | 0 | 2021-04-30 04:21:03 | Unknown, Belgium | ||||
1636112 | 1636112 | 2021-04-29 | Chile | Unknown | 55 | 0 | 48 | 7 | 2021-04-30 04:21:03 | Unknown, Chile | ||||
1636144 | 1636144 | 2021-04-29 | China | Unknown | 8778 | 0 | 3 | 0 | 2021-04-30 04:21:03 | Unknown, China | ||||
1636178 | 1636178 | 2021-04-29 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-30 04:21:03 | Unknown, Colombia | ||||
1636239 | 1636239 | 2021-04-29 | Germany | Unknown | 9272 | 0 | 0 | 9272 | 2021-04-30 04:21:03 | Unknown, Germany | ||||
1636285 | 1636285 | 2021-04-29 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-30 04:21:03 | Unknown, India | ||||
1636360 | 1636360 | 2021-04-29 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-04-30 04:21:03 | Unknown, Japan | ||||
1636419 | 1636419 | 2021-04-29 | Mexico | Unknown | 0 | 0 | 1861861 | 0 | 2021-04-30 04:21:03 | Unknown, Mexico | ||||
1636445 | 1636445 | 2021-04-29 | Netherlands | Unknown | 2788 | 26 | 0 | 3513 | 2021-04-30 04:21:03 | Unknown, Netherlands | ||||
1636491 | 1636491 | 2021-04-29 | Peru | Unknown | 8277 | 326 | 1728662 | 0 | 2021-04-30 04:21:03 | Unknown, Peru | ||||
1636618 | 1636618 | 2021-04-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
1639974 | 1639974 | 2021-04-29 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-04-30 04:21:03 | Unknown, United Kingdom | ||
1640005 | 1640005 | 2021-04-29 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-04-30 04:21:03 | Unknown, Malaysia | ||||
1640012 | 1640012 | 2021-04-29 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-04-30 04:21:03 | Unknown, Ukraine | ||||
3393114 | 3393114 | 2021-04-28 | Belgium | Unknown | 18660 | 24140 | 0 | 0 | 2021-04-29 04:20:55 | Unknown, Belgium | ||||
3393191 | 3393191 | 2021-04-28 | Chile | Unknown | 55 | 0 | 48 | 7 | 2021-04-29 04:20:55 | Unknown, Chile | ||||
3393223 | 3393223 | 2021-04-28 | China | Unknown | 8765 | 0 | 3 | 0 | 2021-04-29 04:20:55 | Unknown, China | ||||
3393257 | 3393257 | 2021-04-28 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-29 04:20:55 | Unknown, Colombia | ||||
3393318 | 3393318 | 2021-04-28 | Germany | Unknown | 7822 | 0 | 0 | 7822 | 2021-04-29 04:20:55 | Unknown, Germany | ||||
3393364 | 3393364 | 2021-04-28 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-29 04:20:55 | Unknown, India | ||||
3393439 | 3393439 | 2021-04-28 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-04-29 04:20:55 | Unknown, Japan | ||||
3393498 | 3393498 | 2021-04-28 | Mexico | Unknown | 0 | 0 | 1858844 | 0 | 2021-04-29 04:20:55 | Unknown, Mexico | ||||
3393524 | 3393524 | 2021-04-28 | Netherlands | Unknown | 2785 | 22 | 0 | 3460 | 2021-04-29 04:20:55 | Unknown, Netherlands | ||||
3393570 | 3393570 | 2021-04-28 | Peru | Unknown | 8277 | 326 | 1728662 | 0 | 2021-04-29 04:20:55 | Unknown, Peru | ||||
3393697 | 3393697 | 2021-04-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
3397053 | 3397053 | 2021-04-28 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-04-29 04:20:55 | Unknown, United Kingdom | ||
3397084 | 3397084 | 2021-04-28 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-04-29 04:20:55 | Unknown, Malaysia | ||||
3397091 | 3397091 | 2021-04-28 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-04-29 04:20:55 | Unknown, Ukraine | ||||
3701830 | 3701830 | 2021-04-27 | Belgium | Unknown | 18565 | 24104 | 0 | 0 | 2021-04-28 04:20:32 | Unknown, Belgium | ||||
3701907 | 3701907 | 2021-04-27 | Chile | Unknown | 55 | 0 | 48 | 7 | 2021-04-28 04:20:32 | Unknown, Chile |
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]);