johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
707 rows where country_or_region = "Japan" and "last_update" is on date 2021-11-10 sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
province_or_state >30
country_or_region 1
- Japan · 707 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | 2021-12-02 | Japan | Port Quarantine | 4629 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
358 | 358 | 2021-12-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
24418 | 24418 | 2022-03-20 | Japan | Port Quarantine | 12635 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
24429 | 24429 | 2022-03-20 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
28433 | 28433 | 2021-11-11 | Japan | Port Quarantine | 4502 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
28444 | 28444 | 2021-11-11 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
71108 | 71108 | 2022-02-07 | Japan | Port Quarantine | 10269 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
71119 | 71119 | 2022-02-07 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
87142 | 87142 | 2021-11-09 | Japan | Port Quarantine | 4463 | 7 | 0 | 2021-11-10 04:21:38 | Port Quarantine, Japan | |||||
87153 | 87153 | 2021-11-09 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, Japan | |||||
91159 | 91159 | 2022-07-23 | Japan | Port Quarantine | 20385 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
91170 | 91170 | 2022-07-23 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
99343 | 99343 | 2022-01-14 | Japan | Port Quarantine | 7557 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
99354 | 99354 | 2022-01-14 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
114769 | 114769 | 2022-09-06 | Japan | Port Quarantine | 21696 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
114780 | 114780 | 2022-09-06 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
126750 | 126750 | 2022-01-09 | Japan | Port Quarantine | 6722 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
126761 | 126761 | 2022-01-09 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
130767 | 130767 | 2022-10-04 | Japan | Port Quarantine | 22118 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
130778 | 130778 | 2022-10-04 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
137988 | 137988 | 2021-12-04 | Japan | Port Quarantine | 4646 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
137999 | 137999 | 2021-12-04 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
142005 | 142005 | 2022-07-09 | Japan | Port Quarantine | 19988 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
142016 | 142016 | 2022-07-09 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
150001 | 150001 | 2021-11-29 | Japan | Port Quarantine | 4617 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
150012 | 150012 | 2021-11-29 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
158030 | 158030 | 2022-03-29 | Japan | Port Quarantine | 13801 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
158041 | 158041 | 2022-03-29 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
162045 | 162045 | 2021-11-19 | Japan | Port Quarantine | 4544 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
162056 | 162056 | 2021-11-19 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
166062 | 166062 | 2022-06-21 | Japan | Port Quarantine | 19650 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
166073 | 166073 | 2022-06-21 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
186088 | 186088 | 2022-02-13 | Japan | Port Quarantine | 10639 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
186099 | 186099 | 2022-02-13 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
222013 | 222013 | 2022-05-09 | Japan | Port Quarantine | 16757 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
222024 | 222024 | 2022-05-09 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
229244 | 229244 | 2022-05-31 | Japan | Port Quarantine | 19171 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
229255 | 229255 | 2022-05-31 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
233260 | 233260 | 2022-02-11 | Japan | Port Quarantine | 10538 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
233271 | 233271 | 2022-02-11 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
253331 | 253331 | 2022-09-08 | Japan | Port Quarantine | 21741 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
253342 | 253342 | 2022-09-08 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
261550 | 261550 | 2022-03-15 | Japan | Port Quarantine | 12472 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
261561 | 261561 | 2022-03-15 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
303886 | 303886 | 2022-04-16 | Japan | Port Quarantine | 15265 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
303897 | 303897 | 2022-04-16 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
315934 | 315934 | 2022-02-12 | Japan | Port Quarantine | 10584 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
315945 | 315945 | 2022-02-12 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
335954 | 335954 | 2022-03-18 | Japan | Port Quarantine | 12635 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
335965 | 335965 | 2022-03-18 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
356344 | 356344 | 2022-03-11 | Japan | Port Quarantine | 12144 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
356355 | 356355 | 2022-03-11 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
360360 | 360360 | 2022-05-07 | Japan | Port Quarantine | 16757 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
360371 | 360371 | 2022-05-07 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
372214 | 372214 | 2022-09-13 | Japan | Port Quarantine | 21833 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
372225 | 372225 | 2022-09-13 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
384241 | 384241 | 2022-09-23 | Japan | Port Quarantine | 22014 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
384252 | 384252 | 2022-09-23 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
404311 | 404311 | 2021-12-07 | Japan | Port Quarantine | 4685 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
404322 | 404322 | 2021-12-07 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
419353 | 419353 | 2022-09-18 | Japan | Port Quarantine | 21973 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
419364 | 419364 | 2022-09-18 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
447388 | 447388 | 2021-11-17 | Japan | Port Quarantine | 4544 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
447399 | 447399 | 2021-11-17 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
459397 | 459397 | 2022-02-02 | Japan | Port Quarantine | 9939 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
459408 | 459408 | 2022-02-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
463414 | 463414 | 2022-05-02 | Japan | Port Quarantine | 16509 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
463425 | 463425 | 2022-05-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
475460 | 475460 | 2022-06-26 | Japan | Port Quarantine | 19737 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
475471 | 475471 | 2022-06-26 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
499686 | 499686 | 2022-04-02 | Japan | Port Quarantine | 14129 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
499697 | 499697 | 2022-04-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
550791 | 550791 | 2021-12-08 | Japan | Port Quarantine | 4698 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
550802 | 550802 | 2021-12-08 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
554807 | 554807 | 2022-01-16 | Japan | Port Quarantine | 7669 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
554818 | 554818 | 2022-01-16 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
558824 | 558824 | 2022-06-16 | Japan | Port Quarantine | 19578 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
558835 | 558835 | 2022-06-16 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
574850 | 574850 | 2022-02-25 | Japan | Port Quarantine | 11284 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
574861 | 574861 | 2022-02-25 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
593676 | 593676 | 2022-07-01 | Japan | Port Quarantine | 19811 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
593687 | 593687 | 2022-07-01 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
621896 | 621896 | 2022-05-22 | Japan | Port Quarantine | 18240 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
621907 | 621907 | 2022-05-22 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
629926 | 629926 | 2022-07-12 | Japan | Port Quarantine | 20070 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
629937 | 629937 | 2022-07-12 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
658332 | 658332 | 2022-05-13 | Japan | Port Quarantine | 17306 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
658343 | 658343 | 2022-05-13 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
670317 | 670317 | 2022-07-21 | Japan | Port Quarantine | 20323 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
670328 | 670328 | 2022-07-21 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
674333 | 674333 | 2022-07-30 | Japan | Port Quarantine | 20568 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
674344 | 674344 | 2022-07-30 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
686374 | 686374 | 2021-11-13 | Japan | Port Quarantine | 4509 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
686385 | 686385 | 2021-11-13 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
694407 | 694407 | 2022-03-17 | Japan | Port Quarantine | 12562 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
694418 | 694418 | 2022-03-17 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
714483 | 714483 | 2021-11-12 | Japan | Port Quarantine | 4509 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
714494 | 714494 | 2021-11-12 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
722515 | 722515 | 2021-11-20 | Japan | Port Quarantine | 4544 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
722526 | 722526 | 2021-11-20 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan |
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]);