daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
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-12-29 | US | West Virginia | Grant | 54023 | 4666 | 61 | 0 | 39.10314817 | -79.19440518 | 2022-12-30 04:21:04 | Grant, West Virginia, US | |
2022-12-29 | US | West Virginia | Gilmer | 54021 | 2521 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-30 04:21:04 | Gilmer, West Virginia, US | |
2022-12-29 | US | West Virginia | Fayette | 54019 | 16316 | 222 | 0 | 38.02974928 | -81.08286634 | 2022-12-30 04:21:04 | Fayette, West Virginia, US | |
2022-12-29 | US | West Virginia | Doddridge | 54017 | 2474 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-30 04:21:04 | Doddridge, West Virginia, US | |
2022-12-29 | US | West Virginia | Clay | 54015 | 2672 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-12-30 04:21:04 | Clay, West Virginia, US | |
2022-12-29 | US | West Virginia | Calhoun | 54013 | 2252 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-12-30 04:21:04 | Calhoun, West Virginia, US | |
2022-12-29 | US | West Virginia | Cabell | 54011 | 33173 | 425 | 0 | 38.42424062 | -82.23855912 | 2022-12-30 04:21:04 | Cabell, West Virginia, US | |
2022-12-29 | US | West Virginia | Brooke | 54009 | 6206 | 109 | 0 | 40.27367263 | -80.57915332 | 2022-12-30 04:21:04 | Brooke, West Virginia, US | |
2022-12-29 | US | West Virginia | Braxton | 54007 | 4918 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-30 04:21:04 | Braxton, West Virginia, US | |
2022-12-29 | US | West Virginia | Boone | 54005 | 8445 | 100 | 0 | 38.01974191 | -81.69888019 | 2022-12-30 04:21:04 | Boone, West Virginia, US | |
2022-12-29 | US | West Virginia | Berkeley | 54003 | 43920 | 336 | 0 | 39.46704621 | -78.02414609 | 2022-12-30 04:21:04 | Berkeley, West Virginia, US | |
2022-12-29 | US | West Virginia | Barbour | 54001 | 5848 | 77 | 0 | 39.1307219 | -80.00350858 | 2022-12-30 04:21:04 | Barbour, West Virginia, US | |
2022-12-29 | US | Washington | Yakima | 53077 | 82272 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-30 04:21:04 | Yakima, Washington, US | |
2022-12-29 | US | Washington | Whitman | 53075 | 9941 | 98 | 0 | 46.90022523 | -117.5241763 | 2022-12-30 04:21:04 | Whitman, Washington, US | |
2022-12-29 | US | Washington | Whatcom | 53073 | 48335 | 353 | 0 | 48.82227976 | -121.7490018 | 2022-12-30 04:21:04 | Whatcom, Washington, US | |
2022-12-29 | US | Washington | Walla Walla | 53071 | 18541 | 168 | 0 | 46.23040051 | -118.4775539 | 2022-12-30 04:21:04 | Walla Walla, Washington, US | |
2022-12-29 | US | Washington | Wahkiakum | 53069 | 632 | 10 | 0 | 46.2918004 | -123.4250831 | 2022-12-30 04:21:04 | Wahkiakum, Washington, US | |
2022-12-29 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Washington, US | |
2022-12-29 | US | Washington | Thurston | 53067 | 61542 | 495 | 0 | 46.9291895 | -122.8290656 | 2022-12-30 04:21:04 | Thurston, Washington, US | |
2022-12-29 | US | Washington | Stevens | 53065 | 9846 | 162 | 0 | 48.40035475 | -117.8542701 | 2022-12-30 04:21:04 | Stevens, Washington, US | |
2022-12-29 | US | Washington | Spokane | 53063 | 150451 | 1615 | 0 | 47.62113146 | -117.4046494 | 2022-12-30 04:21:04 | Spokane, Washington, US | |
2022-12-29 | US | Washington | Snohomish | 53061 | 199657 | 1379 | 0 | 48.04615983 | -121.7170703 | 2022-12-30 04:21:04 | Snohomish, Washington, US | |
2022-12-29 | US | Washington | Skamania | 53059 | 1775 | 17 | 0 | 46.02408726 | -121.9164403 | 2022-12-30 04:21:04 | Skamania, Washington, US | |
2022-12-29 | US | Washington | Skagit | 53057 | 27952 | 253 | 0 | 48.48171488 | -121.766131 | 2022-12-30 04:21:04 | Skagit, Washington, US | |
2022-12-29 | US | Washington | San Juan | 53055 | 1923 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-30 04:21:04 | San Juan, Washington, US | |
2022-12-29 | US | Washington | Pierce | 53053 | 238907 | 1562 | 0 | 47.03892768 | -122.1405958 | 2022-12-30 04:21:04 | Pierce, Washington, US | |
2022-12-29 | US | Washington | Pend Oreille | 53051 | 2921 | 43 | 0 | 48.53234021 | -117.2741804 | 2022-12-30 04:21:04 | Pend Oreille, Washington, US | |
2022-12-29 | US | Washington | Pacific | 53049 | 4765 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-12-30 04:21:04 | Pacific, Washington, US | |
2022-12-29 | US | Washington | Okanogan | 53047 | 10343 | 137 | 0 | 48.54855019 | -119.7387224 | 2022-12-30 04:21:04 | Okanogan, Washington, US | |
2022-12-29 | US | Washington | Mason | 53045 | 15474 | 174 | 0 | 47.35007586 | -123.1863685 | 2022-12-30 04:21:04 | Mason, Washington, US | |
2022-12-29 | US | Washington | Lincoln | 53043 | 2631 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-12-30 04:21:04 | Lincoln, Washington, US | |
2022-12-29 | US | Washington | Lewis | 53041 | 20489 | 288 | 0 | 46.57756476 | -122.3925769 | 2022-12-30 04:21:04 | Lewis, Washington, US | |
2022-12-29 | US | Washington | Klickitat | 53039 | 4258 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-30 04:21:04 | Klickitat, Washington, US | |
2022-12-29 | US | Washington | Kittitas | 53037 | 10196 | 90 | 0 | 47.12521214 | -120.679439 | 2022-12-30 04:21:04 | Kittitas, Washington, US | |
2022-12-29 | US | Washington | Kitsap | 53035 | 51235 | 404 | 0 | 47.63479026 | -122.6436061 | 2022-12-30 04:21:04 | Kitsap, Washington, US | |
2022-12-29 | US | Washington | King | 53033 | 536662 | 3368 | 0 | 47.49137892 | -121.8346131 | 2022-12-30 04:21:04 | King, Washington, US | |
2022-12-29 | US | Washington | Jefferson | 53031 | 4657 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-30 04:21:04 | Jefferson, Washington, US | |
2022-12-29 | US | Washington | Island | 53029 | 13362 | 111 | 0 | 48.14713305 | -122.5216407 | 2022-12-30 04:21:04 | Island, Washington, US | |
2022-12-29 | US | Washington | Grays Harbor | 53027 | 20118 | 244 | 0 | 47.14003705 | -123.7820567 | 2022-12-30 04:21:04 | Grays Harbor, Washington, US | |
2022-12-29 | US | Washington | Grant | 53025 | 30851 | 237 | 0 | 47.20753737 | -119.4500749 | 2022-12-30 04:21:04 | Grant, Washington, US | |
2022-12-29 | US | Washington | Garfield | 53023 | 490 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-12-30 04:21:04 | Garfield, Washington, US | |
2022-12-29 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-30 04:21:04 | Franklin, Washington, US | |
2022-12-29 | US | Washington | Ferry | 53019 | 1772 | 32 | 0 | 48.4711431 | -118.5154041 | 2022-12-30 04:21:04 | Ferry, Washington, US | |
2022-12-29 | US | Washington | Douglas | 53017 | 13113 | 84 | 0 | 47.7361335 | -119.692937 | 2022-12-30 04:21:04 | Douglas, Washington, US | |
2022-12-29 | US | Washington | Cowlitz | 53015 | 26932 | 395 | 0 | 46.19074721 | -122.6782231 | 2022-12-30 04:21:04 | Cowlitz, Washington, US | |
2022-12-29 | US | Washington | Columbia | 53013 | 730 | 17 | 0 | 46.29442881 | -117.9051983 | 2022-12-30 04:21:04 | Columbia, Washington, US | |
2022-12-29 | US | Washington | Clark | 53011 | 109868 | 985 | 0 | 45.77568046 | -122.4829204 | 2022-12-30 04:21:04 | Clark, Washington, US | |
2022-12-29 | US | Washington | Clallam | 53009 | 15469 | 191 | 0 | 48.04754642 | -123.9226319 | 2022-12-30 04:21:04 | Clallam, Washington, US | |
2022-12-29 | US | Washington | Chelan | 53007 | 23809 | 192 | 0 | 47.87046092 | -120.6173956 | 2022-12-30 04:21:04 | Chelan, Washington, US | |
2022-12-29 | US | Washington | Benton | 53005 | 61017 | 523 | 0 | 46.23946995 | -119.5120834 | 2022-12-30 04:21:04 | Benton, Washington, US | |
2022-12-29 | US | Washington | Asotin | 53003 | 5443 | 81 | 0 | 46.18894415 | -117.2022851 | 2022-12-30 04:21:04 | Asotin, Washington, US | |
2022-12-29 | US | Washington | Adams | 53001 | 5570 | 45 | 0 | 46.98299757 | -118.5601734 | 2022-12-30 04:21:04 | Adams, Washington, US | |
2022-12-29 | US | Virginia | York | 51199 | 13177 | 127 | 0 | 37.24374789 | -76.54412815 | 2022-12-30 04:21:04 | York, Virginia, US | |
2022-12-29 | US | Virginia | Wythe | 51197 | 9270 | 167 | 0 | 36.91582035 | -81.07834059 | 2022-12-30 04:21:04 | Wythe, Virginia, US | |
2022-12-29 | US | Virginia | Wise | 51195 | 13390 | 223 | 0 | 36.9746148 | -82.62410519 | 2022-12-30 04:21:04 | Wise, Virginia, US | |
2022-12-29 | US | Virginia | Winchester | 51840 | 7968 | 95 | 0 | 39.17054517 | -78.17325058 | 2022-12-30 04:21:04 | Winchester, Virginia, US | |
2022-12-29 | US | Virginia | Williamsburg | 51830 | 2209 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-30 04:21:04 | Williamsburg, Virginia, US | |
2022-12-29 | US | Virginia | Westmoreland | 51193 | 4137 | 57 | 0 | 38.11021557 | -76.80213247 | 2022-12-30 04:21:04 | Westmoreland, Virginia, US | |
2022-12-29 | US | Virginia | Waynesboro | 51820 | 7274 | 84 | 0 | 38.06451466 | -78.90293905 | 2022-12-30 04:21:04 | Waynesboro, Virginia, US | |
2022-12-29 | US | Virginia | Washington | 51191 | 17438 | 240 | 0 | 36.72341572 | -81.95666289 | 2022-12-30 04:21:04 | Washington, Virginia, US | |
2022-12-29 | US | Virginia | Warren | 51187 | 11082 | 178 | 0 | 38.90847745 | -78.20280433 | 2022-12-30 04:21:04 | Warren, Virginia, US | |
2022-12-29 | US | Virginia | Virginia Beach | 51810 | 111586 | 917 | 0 | 36.73285734 | -76.04566934 | 2022-12-30 04:21:04 | Virginia Beach, Virginia, US | |
2022-12-29 | US | Virginia | Unassigned | 90051 | 0 | 0 | 0 | 39.20172582 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Virginia, US | |
2022-12-29 | US | Virginia | Tazewell | 51185 | 13254 | 206 | 0 | 37.12191123 | -81.56685568 | 2022-12-30 04:21:04 | Tazewell, Virginia, US | |
2022-12-29 | US | Virginia | Sussex | 51183 | 2798 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-12-30 04:21:04 | Sussex, Virginia, US | |
2022-12-29 | US | Virginia | Surry | 51181 | 1365 | 23 | 0 | 37.11781893 | -76.88450012 | 2022-12-30 04:21:04 | Surry, Virginia, US | |
2022-12-29 | US | Virginia | Suffolk | 51800 | 23574 | 330 | 0 | 36.70155394 | -76.63603554 | 2022-12-30 04:21:04 | Suffolk, Virginia, US | |
2022-12-29 | US | Virginia | Staunton | 51790 | 7557 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-30 04:21:04 | Staunton, Virginia, US | |
2022-12-29 | US | Virginia | Stafford | 51179 | 40420 | 193 | 0 | 38.41758738 | -77.45917053 | 2022-12-30 04:21:04 | Stafford, Virginia, US | |
2022-12-29 | US | Virginia | Spotsylvania | 51177 | 34216 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-30 04:21:04 | Spotsylvania, Virginia, US | |
2022-12-29 | US | Virginia | Southampton | 51175 | 4331 | 102 | 0 | 36.72231125 | -77.10642712 | 2022-12-30 04:21:04 | Southampton, Virginia, US | |
2022-12-29 | US | Virginia | Smyth | 51173 | 11643 | 195 | 0 | 36.84455636 | -81.53344948 | 2022-12-30 04:21:04 | Smyth, Virginia, US | |
2022-12-29 | US | Virginia | Shenandoah | 51171 | 13442 | 252 | 0 | 38.85905135 | -78.56813762 | 2022-12-30 04:21:04 | Shenandoah, Virginia, US | |
2022-12-29 | US | Virginia | Scott | 51169 | 7329 | 126 | 0 | 36.71466456 | -82.60171704 | 2022-12-30 04:21:04 | Scott, Virginia, US | |
2022-12-29 | US | Virginia | Salem | 51775 | 7048 | 111 | 0 | 37.2836193 | -80.06219455 | 2022-12-30 04:21:04 | Salem, Virginia, US | |
2022-12-29 | US | Virginia | Russell | 51167 | 9024 | 127 | 0 | 36.9302832 | -82.10095486 | 2022-12-30 04:21:04 | Russell, Virginia, US | |
2022-12-29 | US | Virginia | Rockingham | 51165 | 18409 | 260 | 0 | 38.51006137 | -78.87260325 | 2022-12-30 04:21:04 | Rockingham, Virginia, US | |
2022-12-29 | US | Virginia | Rockbridge | 51163 | 4912 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-12-30 04:21:04 | Rockbridge, Virginia, US | |
2022-12-29 | US | Virginia | Roanoke City | 51770 | 27157 | 420 | 0 | 37.27791025 | -79.96189766 | 2022-12-30 04:21:04 | Roanoke City, Virginia, US | |
2022-12-29 | US | Virginia | Roanoke | 51161 | 27180 | 311 | 0 | 37.26865804 | -80.06396753 | 2022-12-30 04:21:04 | Roanoke, Virginia, US | |
2022-12-29 | US | Virginia | Richmond City | 51760 | 60457 | 552 | 0 | 37.53255773 | -77.47966921 | 2022-12-30 04:21:04 | Richmond City, Virginia, US | |
2022-12-29 | US | Virginia | Richmond | 51159 | 2865 | 29 | 0 | 37.937575 | -76.72920628 | 2022-12-30 04:21:04 | Richmond, Virginia, US | |
2022-12-29 | US | Virginia | Rappahannock | 51157 | 1325 | 13 | 0 | 38.68295619 | -78.15826963 | 2022-12-30 04:21:04 | Rappahannock, Virginia, US | |
2022-12-29 | US | Virginia | Radford | 51750 | 4940 | 49 | 0 | 37.12222899 | -80.5602732 | 2022-12-30 04:21:04 | Radford, Virginia, US | |
2022-12-29 | US | Virginia | Pulaski | 51155 | 10366 | 157 | 0 | 37.06474963 | -80.71229738 | 2022-12-30 04:21:04 | Pulaski, Virginia, US | |
2022-12-29 | US | Virginia | Prince William | 51153 | 122787 | 804 | 0 | 38.70916224 | -77.48713689 | 2022-12-30 04:21:04 | Prince William, Virginia, US | |
2022-12-29 | US | Virginia | Prince George | 51149 | 11190 | 84 | 0 | 37.18497668 | -77.22922187 | 2022-12-30 04:21:04 | Prince George, Virginia, US | |
2022-12-29 | US | Virginia | Prince Edward | 51147 | 6373 | 84 | 0 | 37.22554789 | -78.43597949 | 2022-12-30 04:21:04 | Prince Edward, Virginia, US | |
2022-12-29 | US | Virginia | Powhatan | 51145 | 6209 | 68 | 0 | 37.55016038 | -77.91267882 | 2022-12-30 04:21:04 | Powhatan, Virginia, US | |
2022-12-29 | US | Virginia | Portsmouth | 51740 | 25670 | 354 | 0 | 36.85914825 | -76.35971629 | 2022-12-30 04:21:04 | Portsmouth, Virginia, US | |
2022-12-29 | US | Virginia | Poquoson | 51735 | 2864 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-30 04:21:04 | Poquoson, Virginia, US | |
2022-12-29 | US | Virginia | Pittsylvania | 51143 | 18193 | 231 | 0 | 36.81980341 | -79.39731264 | 2022-12-30 04:21:04 | Pittsylvania, Virginia, US | |
2022-12-29 | US | Virginia | Petersburg | 51730 | 9828 | 150 | 0 | 37.20530399 | -77.39368102 | 2022-12-30 04:21:04 | Petersburg, Virginia, US | |
2022-12-29 | US | Virginia | Patrick | 51141 | 4739 | 102 | 0 | 36.6801638 | -80.2865648 | 2022-12-30 04:21:04 | Patrick, Virginia, US | |
2022-12-29 | US | Virginia | Page | 51139 | 6798 | 127 | 0 | 38.61807452 | -78.48797204 | 2022-12-30 04:21:04 | Page, Virginia, US | |
2022-12-29 | US | Virginia | Orange | 51137 | 8891 | 104 | 0 | 38.24530219 | -78.015604 | 2022-12-30 04:21:04 | Orange, Virginia, US | |
2022-12-29 | US | Virginia | Nottoway | 51135 | 5486 | 101 | 0 | 37.1435975 | -78.05065922 | 2022-12-30 04:21:04 | Nottoway, Virginia, US | |
2022-12-29 | US | Virginia | Norton | 51720 | 1540 | 21 | 0 | 36.93357076 | -82.62750411 | 2022-12-30 04:21:04 | Norton, Virginia, US | |
2022-12-29 | US | Virginia | Northumberland | 51133 | 2630 | 45 | 0 | 37.89202088 | -76.41949732 | 2022-12-30 04:21:04 | Northumberland, Virginia, US | |
2022-12-29 | US | Virginia | Northampton | 51131 | 2793 | 74 | 0 | 37.34062933 | -75.87751591 | 2022-12-30 04:21:04 | Northampton, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;