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
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 14
province_or_state 1
- Unknown · 11,795 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2000287 | 2000287 | 2020-08-26 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-08-27 04:28:15 | Unknown, United Kingdom | ||
2000299 | 2000299 | 2020-08-26 | China | Unknown | 4334 | 0 | 0 | 0 | 2020-08-27 04:28:15 | Unknown, China | ||||
2000320 | 2000320 | 2020-08-26 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-08-27 04:28:15 | Unknown, Malaysia | ||||
2000327 | 2000327 | 2020-08-26 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-08-27 04:28:15 | Unknown, Ukraine | ||||
2509983 | 2509983 | 2020-08-27 | Chile | Unknown | 68 | 1 | 64 | 3 | 2020-08-28 04:28:11 | Unknown, Chile | ||||
2510107 | 2510107 | 2020-08-27 | Germany | Unknown | 1940 | 0 | 0 | 1940 | 2020-08-28 04:28:11 | Unknown, Germany | ||||
2510153 | 2510153 | 2020-08-27 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-28 04:28:11 | Unknown, India | ||||
2510228 | 2510228 | 2020-08-27 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-08-28 04:28:11 | Unknown, Japan | ||||
2510310 | 2510310 | 2020-08-27 | Netherlands | Unknown | 158 | 14 | 0 | 591 | 2020-08-28 04:28:11 | Unknown, Netherlands | ||||
2510356 | 2510356 | 2020-08-27 | Peru | Unknown | 0 | 0 | 421877 | 0 | 2020-08-28 04:28:11 | Unknown, Peru | ||||
2510482 | 2510482 | 2020-08-27 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-28 04:28:11 | Unknown, Spain | ||||
2513827 | 2513827 | 2020-08-27 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-08-28 04:28:11 | Unknown, United Kingdom | ||
2513839 | 2513839 | 2020-08-27 | China | Unknown | 4352 | 0 | 0 | 0 | 2020-08-28 04:28:11 | Unknown, China | ||||
2513860 | 2513860 | 2020-08-27 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-08-28 04:28:11 | Unknown, Malaysia | ||||
2513867 | 2513867 | 2020-08-27 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-08-28 04:28:11 | Unknown, Ukraine | ||||
1522982 | 1522982 | 2020-08-28 | Chile | Unknown | 55 | 1 | 54 | 0 | 2020-08-29 04:28:19 | Unknown, Chile | ||||
1523106 | 1523106 | 2020-08-28 | Germany | Unknown | 1817 | 0 | 0 | 1817 | 2020-08-29 04:28:19 | Unknown, Germany | ||||
1523152 | 1523152 | 2020-08-28 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-29 04:28:19 | Unknown, India | ||||
1523227 | 1523227 | 2020-08-28 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-08-29 04:28:19 | Unknown, Japan | ||||
1523309 | 1523309 | 2020-08-28 | Netherlands | Unknown | 164 | 13 | 0 | 590 | 2020-08-29 04:28:19 | Unknown, Netherlands | ||||
1523355 | 1523355 | 2020-08-28 | Peru | Unknown | 0 | 0 | 429662 | 0 | 2020-08-29 04:28:19 | Unknown, Peru | ||||
1523481 | 1523481 | 2020-08-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-29 04:28:19 | Unknown, Spain | ||||
1526826 | 1526826 | 2020-08-28 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-08-29 04:28:19 | Unknown, United Kingdom | ||
1526838 | 1526838 | 2020-08-28 | China | Unknown | 4366 | 0 | 0 | 0 | 2020-08-29 04:28:19 | Unknown, China | ||||
1526859 | 1526859 | 2020-08-28 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-08-29 04:28:19 | Unknown, Malaysia | ||||
1526866 | 1526866 | 2020-08-28 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-08-29 04:28:19 | Unknown, Ukraine | ||||
609487 | 609487 | 2020-08-29 | Chile | Unknown | 55 | 1 | 55 | 0 | 2020-08-30 04:28:22 | Unknown, Chile | ||||
609611 | 609611 | 2020-08-29 | Germany | Unknown | 1320 | 0 | 0 | 1320 | 2020-08-30 04:28:22 | Unknown, Germany | ||||
609657 | 609657 | 2020-08-29 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, India | ||||
609732 | 609732 | 2020-08-29 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-08-30 04:28:22 | Unknown, Japan | ||||
609814 | 609814 | 2020-08-29 | Netherlands | Unknown | 163 | 13 | 0 | 592 | 2020-08-30 04:28:22 | Unknown, Netherlands | ||||
609860 | 609860 | 2020-08-29 | Peru | Unknown | 0 | 0 | 438017 | 0 | 2020-08-30 04:28:22 | Unknown, Peru | ||||
609986 | 609986 | 2020-08-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, Spain | ||||
613331 | 613331 | 2020-08-29 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-08-30 04:28:22 | Unknown, United Kingdom | ||
613343 | 613343 | 2020-08-29 | China | Unknown | 4373 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, China | ||||
613364 | 613364 | 2020-08-29 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, Malaysia | ||||
613371 | 613371 | 2020-08-29 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, Ukraine | ||||
3931825 | 3931825 | 2020-08-30 | Chile | Unknown | 55 | 1 | 54 | 0 | 2020-08-31 04:28:27 | Unknown, Chile | ||||
3931949 | 3931949 | 2020-08-30 | Germany | Unknown | 1400 | 0 | 0 | 1400 | 2020-08-31 04:28:27 | Unknown, Germany | ||||
3931995 | 3931995 | 2020-08-30 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-31 04:28:27 | Unknown, India | ||||
3932070 | 3932070 | 2020-08-30 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-08-31 04:28:27 | Unknown, Japan | ||||
3932152 | 3932152 | 2020-08-30 | Netherlands | Unknown | 165 | 13 | 0 | 595 | 2020-08-31 04:28:27 | Unknown, Netherlands | ||||
3932198 | 3932198 | 2020-08-30 | Peru | Unknown | 0 | 0 | 446675 | 0 | 2020-08-31 04:28:27 | Unknown, Peru | ||||
3932324 | 3932324 | 2020-08-30 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-31 04:28:27 | Unknown, Spain | ||||
3935669 | 3935669 | 2020-08-30 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-08-31 04:28:27 | Unknown, United Kingdom | ||
3935681 | 3935681 | 2020-08-30 | China | Unknown | 4377 | 0 | 0 | 0 | 2020-08-31 04:28:27 | Unknown, China | ||||
3935702 | 3935702 | 2020-08-30 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-08-31 04:28:27 | Unknown, Malaysia | ||||
3935709 | 3935709 | 2020-08-30 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-08-31 04:28:27 | Unknown, Ukraine | ||||
193866 | 193866 | 2020-08-31 | Chile | Unknown | 56 | 1 | 54 | 1 | 2020-09-01 04:28:31 | Unknown, Chile | ||||
193990 | 193990 | 2020-08-31 | Germany | Unknown | 1937 | 0 | 0 | 1937 | 2020-09-01 04:28:31 | Unknown, Germany | ||||
194036 | 194036 | 2020-08-31 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, India | ||||
194111 | 194111 | 2020-08-31 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-01 04:28:31 | Unknown, Japan | ||||
194193 | 194193 | 2020-08-31 | Netherlands | Unknown | 168 | 13 | 0 | 597 | 2020-09-01 04:28:31 | Unknown, Netherlands | ||||
194239 | 194239 | 2020-08-31 | Peru | Unknown | 0 | 0 | 455457 | 0 | 2020-09-01 04:28:31 | Unknown, Peru | ||||
194365 | 194365 | 2020-08-31 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, Spain | ||||
197714 | 197714 | 2020-08-31 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-01 04:28:31 | Unknown, United Kingdom | ||
197726 | 197726 | 2020-08-31 | China | Unknown | 4396 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, China | ||||
197747 | 197747 | 2020-08-31 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, Malaysia | ||||
197754 | 197754 | 2020-08-31 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, Ukraine | ||||
2059681 | 2059681 | 2020-09-01 | Chile | Unknown | 56 | 1 | 54 | 1 | 2020-09-02 04:28:25 | Unknown, Chile | ||||
2059805 | 2059805 | 2020-09-01 | Germany | Unknown | 1730 | 0 | 0 | 1730 | 2020-09-02 04:28:25 | Unknown, Germany | ||||
2059851 | 2059851 | 2020-09-01 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-02 04:28:25 | Unknown, India | ||||
2059926 | 2059926 | 2020-09-01 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-02 04:28:25 | Unknown, Japan | ||||
2060008 | 2060008 | 2020-09-01 | Netherlands | Unknown | 164 | 13 | 0 | 598 | 2020-09-02 04:28:25 | Unknown, Netherlands | ||||
2060054 | 2060054 | 2020-09-01 | Peru | Unknown | 0 | 0 | 471599 | 0 | 2020-09-02 04:28:25 | Unknown, Peru | ||||
2060180 | 2060180 | 2020-09-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-02 04:28:25 | Unknown, Spain | ||||
2063529 | 2063529 | 2020-09-01 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-02 04:28:25 | Unknown, United Kingdom | ||
2063541 | 2063541 | 2020-09-01 | China | Unknown | 4430 | 0 | 0 | 0 | 2020-09-02 04:28:25 | Unknown, China | ||||
2063562 | 2063562 | 2020-09-01 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-09-02 04:28:25 | Unknown, Malaysia | ||||
2063569 | 2063569 | 2020-09-01 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-09-02 04:28:25 | Unknown, Ukraine | ||||
1105352 | 1105352 | 2020-09-02 | Chile | Unknown | 56 | 1 | 55 | 0 | 2020-09-03 04:28:22 | Unknown, Chile | ||||
1105476 | 1105476 | 2020-09-02 | Germany | Unknown | 1867 | 0 | 0 | 1867 | 2020-09-03 04:28:22 | Unknown, Germany | ||||
1105522 | 1105522 | 2020-09-02 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-03 04:28:22 | Unknown, India | ||||
1105597 | 1105597 | 2020-09-02 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-03 04:28:22 | Unknown, Japan | ||||
1105679 | 1105679 | 2020-09-02 | Netherlands | Unknown | 178 | 13 | 0 | 603 | 2020-09-03 04:28:22 | Unknown, Netherlands | ||||
1105725 | 1105725 | 2020-09-02 | Peru | Unknown | 0 | 0 | 480177 | 0 | 2020-09-03 04:28:22 | Unknown, Peru | ||||
1105851 | 1105851 | 2020-09-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-03 04:28:22 | Unknown, Spain | ||||
1109200 | 1109200 | 2020-09-02 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-03 04:28:22 | Unknown, United Kingdom | ||
1109212 | 1109212 | 2020-09-02 | China | Unknown | 4449 | 0 | 0 | 0 | 2020-09-03 04:28:22 | Unknown, China | ||||
1109233 | 1109233 | 2020-09-02 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-09-03 04:28:22 | Unknown, Malaysia | ||||
1109240 | 1109240 | 2020-09-02 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-09-03 04:28:22 | Unknown, Ukraine | ||||
1354115 | 1354115 | 2020-09-03 | Chile | Unknown | 56 | 1 | 55 | 0 | 2020-09-04 04:28:26 | Unknown, Chile | ||||
1354239 | 1354239 | 2020-09-03 | Germany | Unknown | 1922 | 0 | 0 | 1922 | 2020-09-04 04:28:26 | Unknown, Germany | ||||
1354285 | 1354285 | 2020-09-03 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-04 04:28:26 | Unknown, India | ||||
1354360 | 1354360 | 2020-09-03 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-04 04:28:26 | Unknown, Japan | ||||
1354442 | 1354442 | 2020-09-03 | Netherlands | Unknown | 180 | 10 | 0 | 609 | 2020-09-04 04:28:26 | Unknown, Netherlands | ||||
1354488 | 1354488 | 2020-09-03 | Peru | Unknown | 0 | 0 | 480177 | 0 | 2020-09-04 04:28:26 | Unknown, Peru | ||||
1354614 | 1354614 | 2020-09-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-04 04:28:26 | Unknown, Spain | ||||
1357963 | 1357963 | 2020-09-03 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-04 04:28:26 | Unknown, United Kingdom | ||
1357975 | 1357975 | 2020-09-03 | China | Unknown | 4459 | 0 | 0 | 0 | 2020-09-04 04:28:26 | Unknown, China | ||||
1357996 | 1357996 | 2020-09-03 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-09-04 04:28:26 | Unknown, Malaysia | ||||
1358003 | 1358003 | 2020-09-03 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-09-04 04:28:26 | Unknown, Ukraine | ||||
2661575 | 2661575 | 2020-09-04 | Chile | Unknown | 55 | 1 | 54 | 0 | 2020-09-05 04:28:19 | Unknown, Chile | ||||
2661699 | 2661699 | 2020-09-04 | Germany | Unknown | 1966 | 0 | 0 | 1966 | 2020-09-05 04:28:19 | Unknown, Germany | ||||
2661745 | 2661745 | 2020-09-04 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-05 04:28:19 | Unknown, India | ||||
2661820 | 2661820 | 2020-09-04 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-09-05 04:28:19 | Unknown, Japan | ||||
2661902 | 2661902 | 2020-09-04 | Netherlands | Unknown | 181 | 11 | 0 | 617 | 2020-09-05 04:28:19 | Unknown, Netherlands | ||||
2661948 | 2661948 | 2020-09-04 | Peru | Unknown | 0 | 0 | 498523 | 0 | 2020-09-05 04:28:19 | Unknown, Peru | ||||
2662074 | 2662074 | 2020-09-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-05 04:28:19 | Unknown, Spain | ||||
2665423 | 2665423 | 2020-09-04 | United Kingdom | Unknown | 0 | 73 | 0 | 0 | 55.3781 | -3.436 | 2020-09-05 04:28:19 | Unknown, United Kingdom |
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]);