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 · 13,258 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2179396 | 2179396 | 2022-12-22 | China | Unknown | 1521800 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, China | |||||
2179430 | 2179430 | 2022-12-22 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-23 04:21:04 | Unknown, Colombia | |||||
2179491 | 2179491 | 2022-12-22 | Germany | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Germany | |||||
2179537 | 2179537 | 2022-12-22 | India | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, India | |||||
2179612 | 2179612 | 2022-12-22 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2179651 | 2179651 | 2022-12-22 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Malaysia | |||||
2179690 | 2179690 | 2022-12-22 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Mexico | |||||
2179717 | 2179717 | 2022-12-22 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Netherlands | |||||
2179766 | 2179766 | 2022-12-22 | Peru | Unknown | 57725 | 294 | 0 | 2022-12-23 04:21:04 | Unknown, Peru | |||||
2179893 | 2179893 | 2022-12-22 | Spain | Unknown | 0 | 0 | 0 | 2022-12-23 04:21:04 | Unknown, Spain | |||||
2183234 | 2183234 | 2022-12-22 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-23 04:21:04 | Unknown, Ukraine | |||||
2183258 | 2183258 | 2022-12-22 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-23 04:21:04 | Unknown, United Kingdom | |||
451091 | 451091 | 2022-12-21 | Belgium | Unknown | 62623 | 33211 | 0 | 2022-12-22 04:20:56 | Unknown, Belgium | |||||
451168 | 451168 | 2022-12-21 | Chile | Unknown | 42 | 2 | 0 | 2022-12-22 04:20:56 | Unknown, Chile | |||||
451200 | 451200 | 2022-12-21 | China | Unknown | 1521800 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, China | |||||
451234 | 451234 | 2022-12-21 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-22 04:20:56 | Unknown, Colombia | |||||
451295 | 451295 | 2022-12-21 | Germany | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Germany | |||||
451341 | 451341 | 2022-12-21 | India | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, India | |||||
451416 | 451416 | 2022-12-21 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
451455 | 451455 | 2022-12-21 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Malaysia | |||||
451494 | 451494 | 2022-12-21 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Mexico | |||||
451521 | 451521 | 2022-12-21 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Netherlands | |||||
451570 | 451570 | 2022-12-21 | Peru | Unknown | 53255 | 256 | 0 | 2022-12-22 04:20:56 | Unknown, Peru | |||||
451697 | 451697 | 2022-12-21 | Spain | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Spain | |||||
455038 | 455038 | 2022-12-21 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-22 04:20:56 | Unknown, Ukraine | |||||
455062 | 455062 | 2022-12-21 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-22 04:20:56 | Unknown, United Kingdom | |||
2951090 | 2951090 | 2022-12-20 | Belgium | Unknown | 62623 | 33211 | 0 | 2022-12-21 04:21:03 | Unknown, Belgium | |||||
2951167 | 2951167 | 2022-12-20 | Chile | Unknown | 42 | 2 | 0 | 2022-12-21 04:21:03 | Unknown, Chile | |||||
2951199 | 2951199 | 2022-12-20 | China | Unknown | 1521800 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, China | |||||
2951233 | 2951233 | 2022-12-20 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-21 04:21:03 | Unknown, Colombia | |||||
2951294 | 2951294 | 2022-12-20 | Germany | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, Germany | |||||
2951340 | 2951340 | 2022-12-20 | India | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, India | |||||
2951415 | 2951415 | 2022-12-20 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2951454 | 2951454 | 2022-12-20 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, Malaysia | |||||
2951493 | 2951493 | 2022-12-20 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, Mexico | |||||
2951520 | 2951520 | 2022-12-20 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, Netherlands | |||||
2951569 | 2951569 | 2022-12-20 | Peru | Unknown | 48001 | 237 | 0 | 2022-12-21 04:21:03 | Unknown, Peru | |||||
2951696 | 2951696 | 2022-12-20 | Spain | Unknown | 0 | 0 | 0 | 2022-12-21 04:21:03 | Unknown, Spain | |||||
2955037 | 2955037 | 2022-12-20 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-21 04:21:03 | Unknown, Ukraine | |||||
2955061 | 2955061 | 2022-12-20 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-21 04:21:03 | Unknown, United Kingdom | |||
3173492 | 3173492 | 2022-12-19 | Belgium | Unknown | 62547 | 33155 | 0 | 2022-12-20 04:21:04 | Unknown, Belgium | |||||
3173569 | 3173569 | 2022-12-19 | Chile | Unknown | 42 | 2 | 0 | 2022-12-20 04:21:04 | Unknown, Chile | |||||
3173601 | 3173601 | 2022-12-19 | China | Unknown | 1521800 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, China | |||||
3173635 | 3173635 | 2022-12-19 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-20 04:21:04 | Unknown, Colombia | |||||
3173696 | 3173696 | 2022-12-19 | Germany | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, Germany | |||||
3173742 | 3173742 | 2022-12-19 | India | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, India | |||||
3173817 | 3173817 | 2022-12-19 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3173856 | 3173856 | 2022-12-19 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, Malaysia | |||||
3173895 | 3173895 | 2022-12-19 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, Mexico | |||||
3173922 | 3173922 | 2022-12-19 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, Netherlands | |||||
3173971 | 3173971 | 2022-12-19 | Peru | Unknown | 39918 | 222 | 0 | 2022-12-20 04:21:04 | Unknown, Peru | |||||
3174098 | 3174098 | 2022-12-19 | Spain | Unknown | 0 | 0 | 0 | 2022-12-20 04:21:04 | Unknown, Spain | |||||
3177439 | 3177439 | 2022-12-19 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-20 04:21:04 | Unknown, Ukraine | |||||
3177463 | 3177463 | 2022-12-19 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-20 04:21:04 | Unknown, United Kingdom | |||
1628009 | 1628009 | 2022-12-18 | Belgium | Unknown | 62547 | 33155 | 0 | 2022-12-19 04:21:03 | Unknown, Belgium | |||||
1628086 | 1628086 | 2022-12-18 | Chile | Unknown | 42 | 2 | 0 | 2022-12-19 04:21:03 | Unknown, Chile | |||||
1628118 | 1628118 | 2022-12-18 | China | Unknown | 1521800 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, China | |||||
1628152 | 1628152 | 2022-12-18 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-19 04:21:03 | Unknown, Colombia | |||||
1628213 | 1628213 | 2022-12-18 | Germany | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, Germany | |||||
1628259 | 1628259 | 2022-12-18 | India | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, India | |||||
1628334 | 1628334 | 2022-12-18 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1628373 | 1628373 | 2022-12-18 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, Malaysia | |||||
1628412 | 1628412 | 2022-12-18 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, Mexico | |||||
1628439 | 1628439 | 2022-12-18 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, Netherlands | |||||
1628488 | 1628488 | 2022-12-18 | Peru | Unknown | 39066 | 190 | 0 | 2022-12-19 04:21:03 | Unknown, Peru | |||||
1628615 | 1628615 | 2022-12-18 | Spain | Unknown | 0 | 0 | 0 | 2022-12-19 04:21:03 | Unknown, Spain | |||||
1631956 | 1631956 | 2022-12-18 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-19 04:21:03 | Unknown, Ukraine | |||||
1631980 | 1631980 | 2022-12-18 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-19 04:21:03 | Unknown, United Kingdom | |||
503388 | 503388 | 2022-12-17 | Belgium | Unknown | 62547 | 33155 | 0 | 2022-12-18 04:21:03 | Unknown, Belgium | |||||
503465 | 503465 | 2022-12-17 | Chile | Unknown | 42 | 2 | 0 | 2022-12-18 04:21:03 | Unknown, Chile | |||||
503497 | 503497 | 2022-12-17 | China | Unknown | 1521800 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, China | |||||
503531 | 503531 | 2022-12-17 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-18 04:21:03 | Unknown, Colombia | |||||
503592 | 503592 | 2022-12-17 | Germany | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Germany | |||||
503638 | 503638 | 2022-12-17 | India | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, India | |||||
503713 | 503713 | 2022-12-17 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
503752 | 503752 | 2022-12-17 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Malaysia | |||||
503791 | 503791 | 2022-12-17 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Mexico | |||||
503818 | 503818 | 2022-12-17 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Netherlands | |||||
503867 | 503867 | 2022-12-17 | Peru | Unknown | 35236 | 151 | 0 | 2022-12-18 04:21:03 | Unknown, Peru | |||||
503994 | 503994 | 2022-12-17 | Spain | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Spain | |||||
507335 | 507335 | 2022-12-17 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-18 04:21:03 | Unknown, Ukraine | |||||
507359 | 507359 | 2022-12-17 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-18 04:21:03 | Unknown, United Kingdom | |||
3323960 | 3323960 | 2022-12-16 | Belgium | Unknown | 62547 | 33155 | 0 | 2022-12-17 04:21:04 | Unknown, Belgium | |||||
3324037 | 3324037 | 2022-12-16 | Chile | Unknown | 42 | 2 | 0 | 2022-12-17 04:21:04 | Unknown, Chile | |||||
3324069 | 3324069 | 2022-12-16 | China | Unknown | 1521800 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, China | |||||
3324103 | 3324103 | 2022-12-16 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-17 04:21:04 | Unknown, Colombia | |||||
3324164 | 3324164 | 2022-12-16 | Germany | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, Germany | |||||
3324210 | 3324210 | 2022-12-16 | India | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, India | |||||
3324285 | 3324285 | 2022-12-16 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3324324 | 3324324 | 2022-12-16 | Malaysia | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, Malaysia | |||||
3324363 | 3324363 | 2022-12-16 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, Mexico | |||||
3324390 | 3324390 | 2022-12-16 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, Netherlands | |||||
3324439 | 3324439 | 2022-12-16 | Peru | Unknown | 28938 | 117 | 0 | 2022-12-17 04:21:04 | Unknown, Peru | |||||
3324566 | 3324566 | 2022-12-16 | Spain | Unknown | 0 | 0 | 0 | 2022-12-17 04:21:04 | Unknown, Spain | |||||
3327907 | 3327907 | 2022-12-16 | Ukraine | Unknown | 540756 | 5191 | 0 | 2022-12-17 04:21:04 | Unknown, Ukraine | |||||
3327931 | 3327931 | 2022-12-16 | United Kingdom | Unknown | 0 | 326 | 0 | 55.3781 | -3.436 | 2022-12-17 04:21:04 | Unknown, United Kingdom | |||
542472 | 542472 | 2022-12-15 | Belgium | Unknown | 62547 | 33155 | 0 | 2022-12-16 04:21:01 | Unknown, Belgium | |||||
542549 | 542549 | 2022-12-15 | Chile | Unknown | 42 | 2 | 0 | 2022-12-16 04:21:01 | Unknown, Chile | |||||
542581 | 542581 | 2022-12-15 | China | Unknown | 1521800 | 0 | 0 | 2022-12-16 04:21:01 | Unknown, China | |||||
542615 | 542615 | 2022-12-15 | Colombia | Unknown | 0 | 185 | 0 | 2022-12-16 04:21:01 | Unknown, Colombia |
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]);