daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by confirmed descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: day
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-09-20 | France | 33998116 | 151288 | 0 | 46.2276 | 2.2137 | 2022-09-21 04:23:22 | France | ||||
2022-09-19 | France | 33946300 | 151240 | 0 | 46.2276 | 2.2137 | 2022-09-20 04:22:48 | France | ||||
2022-09-18 | France | 33884825 | 151169 | 0 | 46.2276 | 2.2137 | 2022-09-19 04:21:49 | France | ||||
2022-09-16 | France | 33884825 | 151169 | 0 | 46.2276 | 2.2137 | 2022-09-17 04:20:19 | France | ||||
2022-09-17 | France | 33884825 | 151169 | 0 | 46.2276 | 2.2137 | 2022-09-18 04:22:50 | France | ||||
2022-09-15 | France | 33856227 | 151142 | 0 | 46.2276 | 2.2137 | 2022-09-16 04:21:19 | France | ||||
2022-09-14 | France | 33825536 | 151114 | 0 | 46.2276 | 2.2137 | 2022-09-15 04:21:02 | France | ||||
2022-09-13 | France | 33796010 | 151096 | 0 | 46.2276 | 2.2137 | 2022-09-14 04:20:44 | France | ||||
2022-09-12 | France | 33754160 | 151047 | 0 | 46.2276 | 2.2137 | 2022-09-13 04:20:57 | France | ||||
2022-09-09 | France | 33718369 | 150991 | 0 | 46.2276 | 2.2137 | 2022-09-10 04:21:10 | France | ||||
2022-09-11 | France | 33718369 | 150991 | 0 | 46.2276 | 2.2137 | 2022-09-12 04:20:58 | France | ||||
2022-09-10 | France | 33718369 | 150991 | 0 | 46.2276 | 2.2137 | 2022-09-11 04:20:50 | France | ||||
2022-09-08 | France | 33699282 | 150960 | 0 | 46.2276 | 2.2137 | 2022-09-09 04:21:11 | France | ||||
2022-09-07 | France | 33679416 | 150902 | 0 | 46.2276 | 2.2137 | 2022-09-08 04:21:02 | France | ||||
2022-09-06 | France | 33659274 | 150856 | 0 | 46.2276 | 2.2137 | 2022-09-07 04:20:59 | France | ||||
2022-09-05 | France | 33632356 | 150796 | 0 | 46.2276 | 2.2137 | 2022-09-06 04:21:02 | France | ||||
2022-09-02 | France | 33600422 | 150712 | 0 | 46.2276 | 2.2137 | 2022-09-03 04:21:04 | France | ||||
2022-09-03 | France | 33600422 | 150712 | 0 | 46.2276 | 2.2137 | 2022-09-04 04:21:22 | France | ||||
2022-09-04 | France | 33600422 | 150712 | 0 | 46.2276 | 2.2137 | 2022-09-05 04:21:01 | France | ||||
2022-09-01 | France | 33591277 | 150670 | 0 | 46.2276 | 2.2137 | 2022-09-02 04:21:07 | France | ||||
2022-08-31 | France | 33572631 | 150629 | 0 | 46.2276 | 2.2137 | 2022-09-01 04:21:03 | France | ||||
2022-08-30 | France | 33553391 | 150575 | 0 | 46.2276 | 2.2137 | 2022-08-31 04:20:57 | France | ||||
2022-08-29 | France | 33529669 | 150524 | 0 | 46.2276 | 2.2137 | 2022-08-30 04:21:03 | France | ||||
2022-08-26 | France | 33493920 | 150414 | 0 | 46.2276 | 2.2137 | 2022-08-27 04:20:57 | France | ||||
2022-08-28 | France | 33493920 | 150414 | 0 | 46.2276 | 2.2137 | 2022-08-29 04:21:06 | France | ||||
2022-08-27 | France | 33493920 | 150414 | 0 | 46.2276 | 2.2137 | 2022-08-28 04:21:02 | France | ||||
2022-08-25 | France | 33481790 | 150369 | 0 | 46.2276 | 2.2137 | 2022-08-26 04:21:02 | France | ||||
2022-08-24 | France | 33461953 | 150325 | 0 | 46.2276 | 2.2137 | 2022-08-25 04:21:13 | France | ||||
2022-08-23 | France | 33440664 | 150268 | 0 | 46.2276 | 2.2137 | 2022-08-24 04:20:46 | France | ||||
2022-08-22 | France | 33411676 | 150180 | 0 | 46.2276 | 2.2137 | 2022-08-23 04:20:56 | France | ||||
2022-08-19 | France | 33372974 | 150064 | 0 | 46.2276 | 2.2137 | 2022-08-20 04:21:01 | France | ||||
2022-08-21 | France | 33372974 | 150064 | 0 | 46.2276 | 2.2137 | 2022-08-22 04:20:38 | France | ||||
2022-08-20 | France | 33372974 | 150064 | 0 | 46.2276 | 2.2137 | 2022-08-21 04:20:44 | France | ||||
2022-08-18 | France | 33357883 | 149992 | 0 | 46.2276 | 2.2137 | 2022-08-19 04:20:54 | France | ||||
2022-08-17 | France | 33334278 | 149900 | 0 | 46.2276 | 2.2137 | 2022-08-18 04:21:11 | France | ||||
2022-08-16 | France | 33298533 | 149807 | 0 | 46.2276 | 2.2137 | 2022-08-17 04:20:59 | France | ||||
2022-08-13 | France | 33256395 | 149648 | 0 | 46.2276 | 2.2137 | 2022-08-14 04:20:55 | France | ||||
2022-08-15 | France | 33256395 | 149648 | 0 | 46.2276 | 2.2137 | 2022-08-16 04:20:58 | France | ||||
2022-08-12 | France | 33256395 | 149648 | 0 | 46.2276 | 2.2137 | 2022-08-13 04:20:52 | France | ||||
2022-08-14 | France | 33256395 | 149648 | 0 | 46.2276 | 2.2137 | 2022-08-15 04:20:59 | France | ||||
2022-08-11 | France | 33242582 | 149588 | 0 | 46.2276 | 2.2137 | 2022-08-12 04:20:54 | France | ||||
2022-08-10 | France | 33218593 | 149508 | 0 | 46.2276 | 2.2137 | 2022-08-11 04:20:49 | France | ||||
2022-08-09 | France | 33191512 | 149420 | 0 | 46.2276 | 2.2137 | 2022-08-10 04:20:57 | France | ||||
2022-08-08 | France | 33153696 | 149309 | 0 | 46.2276 | 2.2137 | 2022-08-09 04:20:34 | France | ||||
2022-08-05 | France | 33098879 | 149135 | 0 | 46.2276 | 2.2137 | 2022-08-06 04:20:56 | France | ||||
2022-08-07 | France | 33098879 | 149135 | 0 | 46.2276 | 2.2137 | 2022-08-08 04:21:08 | France | ||||
2022-08-06 | France | 33098879 | 149135 | 0 | 46.2276 | 2.2137 | 2022-08-07 04:20:54 | France | ||||
2022-08-04 | France | 33068287 | 149055 | 0 | 46.2276 | 2.2137 | 2022-08-05 04:20:52 | France | ||||
2022-08-03 | France | 33040311 | 148975 | 0 | 46.2276 | 2.2137 | 2022-08-04 04:20:58 | France | ||||
2022-08-02 | France | 33001908 | 148885 | 0 | 46.2276 | 2.2137 | 2022-08-03 04:20:59 | France | ||||
2022-08-01 | France | 32952778 | 148799 | 0 | 46.2276 | 2.2137 | 2022-08-02 04:20:53 | France | ||||
2022-07-30 | France | 32872716 | 148603 | 0 | 46.2276 | 2.2137 | 2022-07-31 04:21:02 | France | ||||
2022-07-29 | France | 32872716 | 148603 | 0 | 46.2276 | 2.2137 | 2022-07-30 04:20:42 | France | ||||
2022-07-31 | France | 32872716 | 148603 | 0 | 46.2276 | 2.2137 | 2022-08-01 04:21:03 | France | ||||
2022-07-28 | France | 32827964 | 148514 | 0 | 46.2276 | 2.2137 | 2022-07-29 04:20:45 | France | ||||
2022-07-27 | France | 32782050 | 148409 | 0 | 46.2276 | 2.2137 | 2022-07-28 04:20:56 | France | ||||
2022-07-26 | France | 32723412 | 148306 | 0 | 46.2276 | 2.2137 | 2022-07-27 04:21:04 | France | ||||
2022-07-25 | France | 32643471 | 148200 | 0 | 46.2276 | 2.2137 | 2022-07-26 04:20:58 | France | ||||
2022-07-23 | France | 32513712 | 147990 | 0 | 46.2276 | 2.2137 | 2022-07-24 04:20:47 | France | ||||
2022-07-24 | France | 32513712 | 147990 | 0 | 46.2276 | 2.2137 | 2022-07-25 04:20:51 | France | ||||
2022-07-22 | France | 32513712 | 147990 | 0 | 46.2276 | 2.2137 | 2022-07-23 04:20:53 | France | ||||
2022-07-21 | France | 32439609 | 147877 | 0 | 46.2276 | 2.2137 | 2022-07-22 04:21:15 | France | ||||
2022-07-20 | France | 32358740 | 147744 | 0 | 46.2276 | 2.2137 | 2022-07-21 04:21:10 | France | ||||
2022-07-19 | France | 32269027 | 147619 | 0 | 46.2276 | 2.2137 | 2022-07-20 04:20:59 | France | ||||
2022-07-18 | France | 32141518 | 147482 | 0 | 46.2276 | 2.2137 | 2022-07-19 04:20:58 | France | ||||
2022-07-16 | France | 31787395 | 147067 | 0 | 46.2276 | 2.2137 | 2022-07-17 04:21:15 | France | ||||
2022-07-15 | France | 31787395 | 147067 | 0 | 46.2276 | 2.2137 | 2022-07-16 04:21:05 | France | ||||
2022-07-13 | France | 31787395 | 147067 | 0 | 46.2276 | 2.2137 | 2022-07-14 04:20:57 | France | ||||
2022-07-17 | France | 31787395 | 147067 | 0 | 46.2276 | 2.2137 | 2022-07-18 04:20:59 | France | ||||
2022-07-14 | France | 31787395 | 147067 | 0 | 46.2276 | 2.2137 | 2022-07-15 04:20:53 | France | ||||
2022-07-12 | France | 31659753 | 146958 | 0 | 46.2276 | 2.2137 | 2022-07-13 04:20:58 | France | ||||
2022-07-11 | France | 31487131 | 146844 | 0 | 46.2276 | 2.2137 | 2022-07-12 04:20:51 | France | ||||
2022-07-09 | France | 31235794 | 146682 | 0 | 46.2276 | 2.2137 | 2022-07-10 04:20:54 | France | ||||
2022-07-08 | France | 31235794 | 146682 | 0 | 46.2276 | 2.2137 | 2022-07-09 04:20:59 | France | ||||
2022-07-10 | France | 31235794 | 146682 | 0 | 46.2276 | 2.2137 | 2022-07-11 04:20:46 | France | ||||
2022-07-07 | France | 31097847 | 146615 | 0 | 46.2276 | 2.2137 | 2022-07-08 04:20:56 | France | ||||
2022-07-06 | France | 30936582 | 146526 | 0 | 46.2276 | 2.2137 | 2022-07-07 04:20:55 | France | ||||
2022-07-05 | France | 30781967 | 146473 | 0 | 46.2276 | 2.2137 | 2022-07-06 04:20:58 | France | ||||
2022-07-04 | France | 30584880 | 146406 | 0 | 46.2276 | 2.2137 | 2022-07-05 04:20:45 | France | ||||
2022-07-01 | France | 30341632 | 146265 | 0 | 46.2276 | 2.2137 | 2022-07-02 04:21:16 | France | ||||
2022-07-03 | France | 30341632 | 146265 | 0 | 46.2276 | 2.2137 | 2022-07-04 04:20:54 | France | ||||
2022-07-02 | France | 30341632 | 146265 | 0 | 46.2276 | 2.2137 | 2022-07-03 04:20:59 | France | ||||
2022-06-30 | France | 30216647 | 146213 | 0 | 46.2276 | 2.2137 | 2022-07-01 04:21:10 | France | ||||
2022-06-29 | France | 30083301 | 146171 | 0 | 46.2276 | 2.2137 | 2022-06-30 04:21:01 | France | ||||
2022-06-28 | France | 29958577 | 146123 | 0 | 46.2276 | 2.2137 | 2022-06-29 04:20:59 | France | ||||
2022-06-27 | France | 29823387 | 146105 | 0 | 46.2276 | 2.2137 | 2022-06-28 04:20:58 | France | ||||
2022-06-26 | France | 29658559 | 146016 | 0 | 46.2276 | 2.2137 | 2022-06-27 04:21:00 | France | ||||
2022-06-25 | France | 29658559 | 146016 | 0 | 46.2276 | 2.2137 | 2022-06-26 04:21:02 | France | ||||
2022-06-24 | France | 29658559 | 146016 | 0 | 46.2276 | 2.2137 | 2022-06-25 04:20:57 | France | ||||
2022-06-23 | France | 29579354 | 145967 | 0 | 46.2276 | 2.2137 | 2022-06-24 04:20:58 | France | ||||
2022-06-22 | France | 29499502 | 145927 | 0 | 46.2276 | 2.2137 | 2022-06-23 04:20:55 | France | ||||
2022-06-21 | France | 29422836 | 145869 | 0 | 46.2276 | 2.2137 | 2022-06-22 04:20:54 | France | ||||
2022-06-20 | France | 29338883 | 145821 | 0 | 46.2276 | 2.2137 | 2022-06-21 04:20:56 | France | ||||
2022-06-17 | France | 29236926 | 145754 | 0 | 46.2276 | 2.2137 | 2022-06-18 04:21:10 | France | ||||
2022-06-19 | France | 29236926 | 145754 | 0 | 46.2276 | 2.2137 | 2022-06-20 04:21:01 | France | ||||
2022-06-18 | France | 29236926 | 145754 | 0 | 46.2276 | 2.2137 | 2022-06-19 04:20:51 | France | ||||
2022-06-16 | France | 29186390 | 145711 | 0 | 46.2276 | 2.2137 | 2022-06-17 04:20:56 | France | ||||
2022-06-15 | France | 29133309 | 145662 | 0 | 46.2276 | 2.2137 | 2022-06-16 04:20:55 | France | ||||
2022-06-14 | France | 29081355 | 145613 | 0 | 46.2276 | 2.2137 | 2022-06-15 04:20:54 | France | ||||
2022-12-29 | Korea, South | 28996347 | 32095 | 0 | 35.907757 | 127.766922 | 2022-12-30 04:21:04 | Korea, South |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;