daily_reports (view)
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)
province_or_state >30
- Texas 254,491
- Georgia 162,920
- Virginia 135,590
- Kentucky 121,675
- Missouri 117,101
- Kansas 105,758
- Illinois 104,685
- North Carolina 102,044
- Iowa 100,603
- Tennessee 98,183
- Indiana 94,151
- Nebraska 92,863
- Ohio 90,027
- Minnesota 88,465
- Michigan 87,758
- Mississippi 83,968
- Oklahoma 79,376
- Arkansas 76,709
- Wisconsin 73,611
- Puerto Rico 71,726
- Alabama 69,765
- Pennsylvania 68,850
- Florida 68,836
- Louisiana 66,723
- South Dakota 66,362
- Colorado 66,146
- New York 64,046
- California 59,941
- West Virginia 56,193
- Montana 54,982
- …
country_or_region >30
- US 3,284,537
- Russia 78,307
- Japan 46,430
- China 34,865
- India 34,605
- Colombia 32,189
- Mexico 31,389
- Ukraine 26,597
- Brazil 25,862
- Peru 24,679
- Italy 20,264
- Sweden 19,824
- United Kingdom 19,730
- Spain 19,298
- Malaysia 18,241
- Germany 16,427
- Chile 16,296
- Canada 16,227
- Netherlands 15,842
- France 11,972
- Belgium 9,618
- Australia 8,420
- Pakistan 6,636
- New Zealand 3,188
- Denmark 3,077
- Mainland China 1,517
- Antarctica 1,073
- Kiribati 1,073
- Korea, North 1,073
- Nauru 1,073
- …
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-20 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-21 04:20:50 | Repatriated Travellers, Canada | |||||
2022-03-20 | Chile | Unknown | 43 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Chile | |||||
2022-03-20 | China | Unknown | 31966 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, China | |||||
2022-03-20 | Colombia | Unknown | 0 | 300 | 0 | 2022-03-21 04:20:50 | Unknown, Colombia | |||||
2022-03-20 | Diamond Princess | 712 | 13 | 0 | 2022-03-21 04:20:50 | Diamond Princess | ||||||
2022-03-20 | Germany | Unknown | 37652 | 0 | 0 | 2022-03-19 23:20:51 | Unknown, Germany | |||||
2022-03-20 | India | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, India | |||||
2022-03-20 | Japan | Port Quarantine | 12635 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-03-20 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
2022-03-20 | MS Zaandam | 9 | 2 | 0 | 2022-03-21 04:20:50 | MS Zaandam | ||||||
2022-03-20 | Malaysia | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Malaysia | |||||
2022-03-20 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Mexico | |||||
2022-03-20 | Netherlands | Unknown | 19 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-03-20 | Peru | Unknown | 4901 | 319 | 0 | 2022-03-21 04:20:50 | Unknown, Peru | |||||
2022-03-20 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
2022-03-20 | Ukraine | Unknown | 125410 | 2066 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, Ukraine | ||||
2021-11-11 | Belgium | Unknown | 27124 | 26261 | 0 | 2021-11-12 04:22:01 | Unknown, Belgium | |||||
2021-11-11 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-12 04:22:01 | Repatriated Travellers, Canada | |||||
2021-11-11 | Chile | Unknown | 46 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Chile | |||||
2021-11-11 | China | Unknown | 12010 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, China | |||||
2021-11-11 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-12 04:22:01 | Unknown, Colombia | |||||
2021-11-11 | Diamond Princess | 712 | 13 | 0 | 2021-11-12 04:22:01 | Diamond Princess | ||||||
2021-11-11 | Germany | Unknown | 14420 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Germany | |||||
2021-11-11 | India | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, India | |||||
2021-11-11 | Japan | Port Quarantine | 4502 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-11-11 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
2021-11-11 | MS Zaandam | 9 | 2 | 0 | 2021-11-12 04:22:01 | MS Zaandam | ||||||
2021-11-11 | Malaysia | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Malaysia | |||||
2021-11-11 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Mexico | |||||
2021-11-11 | Netherlands | Unknown | 2991 | 25 | 0 | 2021-11-12 04:22:01 | Unknown, Netherlands | |||||
2021-11-11 | Peru | Unknown | 3856 | 116 | 0 | 2021-11-12 04:22:01 | Unknown, Peru | |||||
2021-11-11 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
2021-11-11 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, Ukraine | ||||
2021-08-25 | Belgium | Unknown | 22981 | 25348 | 0 | 2021-08-26 04:21:28 | Unknown, Belgium | |||||
2021-08-25 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-08-26 04:21:28 | Repatriated Travellers, Canada | |||||
2021-08-25 | Chile | Unknown | 53 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Chile | |||||
2021-08-25 | China | Unknown | 10791 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, China | |||||
2021-08-25 | Colombia | Unknown | 2448 | 296 | 0 | 2021-08-26 04:21:28 | Unknown, Colombia | |||||
2021-08-25 | Diamond Princess | 712 | 13 | 0 | 2021-08-26 04:21:28 | Diamond Princess | ||||||
2021-08-25 | Germany | Unknown | 9184 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Germany | |||||
2021-08-25 | India | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, India | |||||
2021-08-25 | Japan | Port Quarantine | 3829 | 6 | 0 | 2021-08-26 04:21:28 | Port Quarantine, Japan | |||||
2021-08-25 | Japan | Unknown | 8 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Japan | |||||
2021-08-25 | MS Zaandam | 9 | 2 | 0 | 2021-08-26 04:21:28 | MS Zaandam | ||||||
2021-08-25 | Mexico | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Mexico | |||||
2021-08-25 | Netherlands | Unknown | 2669 | 22 | 0 | 2021-08-26 04:21:28 | Unknown, Netherlands | |||||
2021-08-25 | Peru | Unknown | 2898 | 152 | 0 | 2021-08-26 04:21:28 | Unknown, Peru | |||||
2021-08-25 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
2021-08-25 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Malaysia | ||||
2021-08-25 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, Ukraine | ||||
2021-04-12 | Belgium | Unknown | 17415 | 23503 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Belgium | ||||
2021-04-12 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-04-13 04:20:37 | Repatriated Travellers, Canada | ||||
2021-04-12 | Chile | Unknown | 46 | 1 | 46 | 0 | 2021-04-13 04:20:37 | Unknown, Chile | ||||
2021-04-12 | China | Unknown | 8541 | 0 | 2 | 0 | 2021-04-13 04:20:37 | Unknown, China | ||||
2021-04-12 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Colombia | ||||
2021-04-12 | Diamond Princess | 712 | 13 | 699 | 0 | 2021-04-13 04:20:37 | Diamond Princess | |||||
2021-04-12 | Germany | Unknown | 1954 | 0 | 0 | 1954 | 2021-04-13 04:20:37 | Unknown, Germany | ||||
2021-04-12 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, India | ||||
2021-04-12 | Japan | Port Quarantine | 2525 | 3 | 2354 | 168 | 2021-04-13 04:20:37 | Port Quarantine, Japan | ||||
2021-04-12 | Japan | Unknown | 8 | 0 | 8 | 0 | 2021-04-13 04:20:37 | Unknown, Japan | ||||
2021-04-12 | MS Zaandam | 9 | 2 | 7 | 0 | 2021-04-13 04:20:37 | MS Zaandam | |||||
2021-04-12 | Mexico | Unknown | 0 | 0 | 1812694 | 0 | 2021-04-13 04:20:37 | Unknown, Mexico | ||||
2021-04-12 | Netherlands | Unknown | 2650 | 29 | 0 | 2972 | 2021-04-13 04:20:37 | Unknown, Netherlands | ||||
2021-04-12 | Peru | Unknown | 5626 | 327 | 1575242 | 0 | 2021-04-13 04:20:37 | Unknown, Peru | ||||
2021-04-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Spain | ||||
2021-04-12 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Malaysia | ||||
2021-04-12 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Ukraine | ||||
2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-03-05 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-03-05 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-04-13 | Diamond Princess | 712 | 11 | 619 | 82 | 2020-04-13 23:07:34 | Diamond Princess | |||||
2020-04-13 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-04-13 23:07:34 | MS Zaandam | |||||
2020-04-13 | China | Unknown | 2276 | 0 | 0 | 0 | 2020-04-13 23:07:54 | Unknown, China | ||||
2020-04-13 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-04-13 23:07:54 | Unknown, Malaysia | ||||
2020-04-13 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-04-13 23:07:54 | Unknown, Ukraine | ||||
2021-11-02 | Belgium | Unknown | 26162 | 25994 | 0 | 2021-11-03 06:22:09 | Unknown, Belgium | |||||
2021-11-02 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-11-03 06:22:09 | Repatriated Travellers, Canada | |||||
2021-11-02 | Chile | Unknown | 46 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Chile | |||||
2021-11-02 | China | Unknown | 11743 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, China | |||||
2021-11-02 | Colombia | Unknown | 0 | 296 | 0 | 2021-11-03 06:22:09 | Unknown, Colombia | |||||
2021-11-02 | Diamond Princess | 712 | 13 | 0 | 2021-11-03 06:22:09 | Diamond Princess | ||||||
2021-11-02 | Germany | Unknown | 11485 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Germany | |||||
2021-11-02 | India | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, India | |||||
2021-11-02 | Japan | Port Quarantine | 4439 | 7 | 0 | 2021-11-03 06:22:09 | Port Quarantine, Japan | |||||
2021-11-02 | Japan | Unknown | 8 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Japan | |||||
2021-11-02 | MS Zaandam | 9 | 2 | 0 | 2021-11-03 06:22:09 | MS Zaandam | ||||||
2021-11-02 | Malaysia | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Malaysia | |||||
2021-11-02 | Mexico | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Mexico | |||||
2021-11-02 | Netherlands | Unknown | 2815 | 24 | 0 | 2021-11-03 06:22:09 | Unknown, Netherlands | |||||
2021-11-02 | Peru | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Peru | |||||
2021-11-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
2021-11-02 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, Ukraine | ||||
2020-04-17 | Diamond Princess | 712 | 13 | 644 | 55 | 2020-04-17 23:30:32 | Diamond Princess | |||||
2020-04-17 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-04-17 23:30:32 | MS Zaandam | |||||
2020-04-17 | China | Unknown | 2427 | 0 | 0 | 0 | 2020-04-17 23:30:52 | Unknown, China | ||||
2020-04-17 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-04-17 23:30:52 | Unknown, Malaysia | ||||
2020-04-17 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-04-17 23:30:52 | Unknown, Ukraine | ||||
2021-05-29 | Belgium | Unknown | 20219 | 24921 | 0 | 0 | 2021-05-30 04:20:55 | Unknown, Belgium | ||||
2021-05-29 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-05-30 04:20:55 | Repatriated Travellers, Canada | ||||
2021-05-29 | Chile | Unknown | 54 | 0 | 54 | 0 | 2021-05-30 04:20:55 | Unknown, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;