johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
782344 | 782344 | 2021-12-13 | India | Unknown | 0 | 0 | 0 | 2021-12-14 04:22:38 | Unknown, India | |||||
782408 | 782408 | 2021-12-13 | Japan | Port Quarantine | 4761 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
782419 | 782419 | 2021-12-13 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
782441 | 782441 | 2021-12-13 | MS Zaandam | 9 | 2 | 0 | 2021-12-14 04:22:38 | MS Zaandam | ||||||
782457 | 782457 | 2021-12-13 | Malaysia | Unknown | 0 | 0 | 0 | 2021-12-14 04:22:38 | Unknown, Malaysia | |||||
782496 | 782496 | 2021-12-13 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-14 04:22:38 | Unknown, Mexico | |||||
782522 | 782522 | 2021-12-13 | Netherlands | Unknown | 4521 | 30 | 0 | 2021-12-14 04:22:38 | Unknown, Netherlands | |||||
782570 | 782570 | 2021-12-13 | Peru | Unknown | 1527 | 37 | 0 | 2021-12-14 04:22:38 | Unknown, Peru | |||||
782697 | 782697 | 2021-12-13 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
786073 | 786073 | 2021-12-13 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-12-14 04:22:38 | Unknown, Ukraine | ||||
786175 | 786175 | 2020-10-15 | Chile | Unknown | 51 | 1 | 51 | 0 | 2020-10-16 04:24:01 | Unknown, Chile | ||||
786240 | 786240 | 2020-10-15 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Colombia | ||||
786256 | 786256 | 2020-10-15 | Diamond Princess | 712 | 13 | 659 | 40 | 2020-10-16 04:24:01 | Diamond Princess | |||||
786300 | 786300 | 2020-10-15 | Germany | Unknown | 3385 | 0 | 0 | 3385 | 2020-10-16 04:24:01 | Unknown, Germany | ||||
786346 | 786346 | 2020-10-15 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, India | ||||
786410 | 786410 | 2020-10-15 | Japan | Port Quarantine | 1069 | 1 | 514 | 554 | 2020-10-16 04:24:01 | Port Quarantine, Japan | ||||
786421 | 786421 | 2020-10-15 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-10-16 04:24:01 | Unknown, Japan | ||||
786442 | 786442 | 2020-10-15 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-10-16 04:24:01 | MS Zaandam | |||||
786503 | 786503 | 2020-10-15 | Netherlands | Unknown | 873 | 13 | 0 | 1604 | 2020-10-16 04:24:01 | Unknown, Netherlands | ||||
786549 | 786549 | 2020-10-15 | Peru | Unknown | 0 | 0 | 759597 | 0 | 2020-10-16 04:24:01 | Unknown, Peru | ||||
786676 | 786676 | 2020-10-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Spain | ||||
790038 | 790038 | 2020-10-15 | China | Unknown | 5298 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, China | ||||
790059 | 790059 | 2020-10-15 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Malaysia | ||||
790066 | 790066 | 2020-10-15 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Ukraine | ||||
790103 | 790103 | 2021-02-04 | Belgium | Unknown | 12817 | 21260 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Belgium | ||||
790160 | 790160 | 2021-02-04 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-02-05 05:22:38 | Repatriated Travellers, Canada | ||||
790180 | 790180 | 2021-02-04 | Chile | Unknown | 51 | 1 | 51 | 0 | 2021-02-05 05:22:38 | Unknown, Chile | ||||
790245 | 790245 | 2021-02-04 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Colombia | ||||
790261 | 790261 | 2021-02-04 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-02-05 05:22:38 | Diamond Princess | |||||
790306 | 790306 | 2021-02-04 | Germany | Unknown | 490 | 0 | 0 | 490 | 2021-02-05 05:22:38 | Unknown, Germany | ||||
790352 | 790352 | 2021-02-04 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, India | ||||
790416 | 790416 | 2021-02-04 | Japan | Port Quarantine | 2171 | 2 | 2082 | 87 | 2021-02-05 05:22:38 | Port Quarantine, Japan | ||||
790427 | 790427 | 2021-02-04 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-02-05 05:22:38 | Unknown, Japan | ||||
790448 | 790448 | 2021-02-04 | MS Zaandam | 9 | 2 | 7 | 0 | 2021-02-05 05:22:38 | MS Zaandam | |||||
790486 | 790486 | 2021-02-04 | Mexico | Unknown | 0 | 0 | 1450237 | 0 | 2021-02-05 05:22:38 | Unknown, Mexico | ||||
790512 | 790512 | 2021-02-04 | Netherlands | Unknown | 2039 | 29 | 0 | 1544 | 2021-02-05 05:22:38 | Unknown, Netherlands | ||||
790558 | 790558 | 2021-02-04 | Peru | Unknown | 0 | 0 | 1069129 | 0 | 2021-02-05 05:22:38 | Unknown, Peru | ||||
790685 | 790685 | 2021-02-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Spain | ||||
794052 | 794052 | 2021-02-04 | China | Unknown | 7792 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, China | ||||
794073 | 794073 | 2021-02-04 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Malaysia | ||||
794080 | 794080 | 2021-02-04 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Ukraine | ||||
794118 | 794118 | 2022-10-24 | Belgium | Unknown | 61881 | 32883 | 0 | 2022-10-25 04:21:53 | Unknown, Belgium | |||||
794175 | 794175 | 2022-10-24 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-10-25 04:21:53 | Repatriated Travellers, Canada | |||||
794195 | 794195 | 2022-10-24 | Chile | Unknown | 42 | 2 | 0 | 2022-10-25 04:21:53 | Unknown, Chile | |||||
794227 | 794227 | 2022-10-24 | China | Unknown | 763286 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, China | |||||
794261 | 794261 | 2022-10-24 | Colombia | Unknown | 0 | 300 | 0 | 2022-10-25 04:21:53 | Unknown, Colombia | |||||
794277 | 794277 | 2022-10-24 | Diamond Princess | 712 | 13 | 0 | 2022-10-25 04:21:53 | Diamond Princess | ||||||
794322 | 794322 | 2022-10-24 | Germany | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Germany | |||||
794368 | 794368 | 2022-10-24 | India | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, India | |||||
794432 | 794432 | 2022-10-24 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-10-25 04:21:53 | Port Quarantine, Japan | |||||
794443 | 794443 | 2022-10-24 | Japan | Unknown | 173 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Japan | |||||
794466 | 794466 | 2022-10-24 | MS Zaandam | 9 | 2 | 0 | 2022-10-25 04:21:53 | MS Zaandam | ||||||
794482 | 794482 | 2022-10-24 | Malaysia | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Malaysia | |||||
794521 | 794521 | 2022-10-24 | Mexico | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Mexico | |||||
794548 | 794548 | 2022-10-24 | Netherlands | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Netherlands | |||||
794597 | 794597 | 2022-10-24 | Peru | Unknown | 296 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Peru | |||||
794724 | 794724 | 2022-10-24 | Spain | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Spain | |||||
798065 | 798065 | 2022-10-24 | Ukraine | Unknown | 469722 | 4314 | 0 | 2022-10-25 04:21:53 | Unknown, Ukraine | |||||
798133 | 798133 | 2021-12-22 | Belgium | Unknown | 32673 | 28067 | 0 | 2021-12-23 04:21:21 | Unknown, Belgium | |||||
798190 | 798190 | 2021-12-22 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-12-23 04:21:21 | Repatriated Travellers, Canada | |||||
798210 | 798210 | 2021-12-22 | Chile | Unknown | 46 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Chile | |||||
798242 | 798242 | 2021-12-22 | China | Unknown | 12689 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, China | |||||
798276 | 798276 | 2021-12-22 | Colombia | Unknown | 0 | 296 | 0 | 2021-12-23 04:21:21 | Unknown, Colombia | |||||
798292 | 798292 | 2021-12-22 | Diamond Princess | 712 | 13 | 0 | 2021-12-23 04:21:21 | Diamond Princess | ||||||
798337 | 798337 | 2021-12-22 | Germany | Unknown | 20045 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Germany | |||||
798383 | 798383 | 2021-12-22 | India | Unknown | 0 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, India | |||||
798447 | 798447 | 2021-12-22 | Japan | Port Quarantine | 4951 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
798458 | 798458 | 2021-12-22 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
798480 | 798480 | 2021-12-22 | MS Zaandam | 9 | 2 | 0 | 2021-12-23 04:21:21 | MS Zaandam | ||||||
798496 | 798496 | 2021-12-22 | Malaysia | Unknown | 0 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Malaysia | |||||
798535 | 798535 | 2021-12-22 | Mexico | Unknown | 0 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Mexico | |||||
798561 | 798561 | 2021-12-22 | Netherlands | Unknown | 4452 | 34 | 0 | 2021-12-23 04:21:21 | Unknown, Netherlands | |||||
798609 | 798609 | 2021-12-22 | Peru | Unknown | 5758 | 221 | 0 | 2021-12-23 04:21:21 | Unknown, Peru | |||||
798736 | 798736 | 2021-12-22 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
802112 | 802112 | 2021-12-22 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-12-23 04:21:21 | Unknown, Ukraine | ||||
805444 | 805444 | 2020-06-01 | Japan | Port Quarantine | 199 | 0 | 154 | 45 | 2020-06-02 02:33:08 | Port Quarantine, Japan | ||||
805545 | 805545 | 2020-06-01 | Brazil | Unknown | 0 | 0 | 211080 | 0 | 2020-06-02 02:33:08 | Unknown, Brazil | ||||
805546 | 805546 | 2020-06-01 | Chile | Unknown | 0 | 0 | 44946 | 0 | 2020-06-02 02:33:08 | Unknown, Chile | ||||
805547 | 805547 | 2020-06-01 | Colombia | Unknown | 1087 | 0 | 0 | 1087 | 2020-06-02 02:33:08 | Unknown, Colombia | ||||
805548 | 805548 | 2020-06-01 | Germany | Unknown | 1455 | 0 | 0 | 1455 | 2020-06-02 02:33:08 | Unknown, Germany | ||||
805549 | 805549 | 2020-06-01 | Japan | Unknown | 8 | 0 | 0 | 8 | 2020-06-02 02:33:08 | Unknown, Japan | ||||
805550 | 805550 | 2020-06-01 | Peru | Unknown | 0 | 0 | 68507 | 0 | 2020-06-02 02:33:08 | Unknown, Peru | ||||
805551 | 805551 | 2020-06-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-02 02:33:08 | Unknown, Spain | ||||
805626 | 805626 | 2020-06-01 | Diamond Princess | 712 | 13 | 651 | 48 | 2020-06-02 02:33:08 | Diamond Princess | |||||
805679 | 805679 | 2020-06-01 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-06-02 02:33:08 | MS Zaandam | |||||
805758 | 805758 | 2020-06-01 | China | Unknown | 3366 | 0 | 0 | 0 | 2020-06-02 02:33:08 | Unknown, China | ||||
805779 | 805779 | 2020-06-01 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-06-02 02:33:08 | Unknown, Malaysia | ||||
805786 | 805786 | 2020-06-01 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-06-02 02:33:08 | Unknown, Ukraine | ||||
809226 | 809226 | 2020-03-27 | China | Unknown | 0 | 0 | 0 | 0 | 2020-03-27 22:14:55 | Unknown, China | ||||
809247 | 809247 | 2020-03-27 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-03-27 22:14:55 | Unknown, Malaysia | ||||
809254 | 809254 | 2020-03-27 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-03-27 22:14:55 | Unknown, Ukraine | ||||
809295 | 809295 | 2021-09-20 | Belgium | Unknown | 24106 | 25517 | 0 | 2021-09-21 04:21:26 | Unknown, Belgium | |||||
809352 | 809352 | 2021-09-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-21 04:21:26 | Repatriated Travellers, Canada | |||||
809372 | 809372 | 2021-09-20 | Chile | Unknown | 49 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, Chile | |||||
809404 | 809404 | 2021-09-20 | China | Unknown | 11150 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, China | |||||
809438 | 809438 | 2021-09-20 | Colombia | Unknown | 0 | 296 | 0 | 2021-09-21 04:21:26 | Unknown, Colombia | |||||
809454 | 809454 | 2021-09-20 | Diamond Princess | 712 | 13 | 0 | 2021-09-21 04:21:26 | Diamond Princess | ||||||
809499 | 809499 | 2021-09-20 | Germany | Unknown | 4304 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, Germany | |||||
809545 | 809545 | 2021-09-20 | India | Unknown | 0 | 0 | 0 | 2021-09-21 04:21:26 | Unknown, India | |||||
809609 | 809609 | 2021-09-20 | Japan | Port Quarantine | 4120 | 6 | 0 | 2021-09-21 04:21:26 | Port Quarantine, 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]);