ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 139,900
- Georgia 91,129
- Virginia 75,092
- Kentucky 67,252
- Missouri 64,913
- Illinois 57,769
- Kansas 57,103
- North Carolina 56,709
- Iowa 55,970
- Tennessee 54,463
- Indiana 52,474
- Ohio 50,322
- Nebraska 49,421
- Minnesota 49,315
- Michigan 47,478
- Mississippi 46,788
- Oklahoma 43,465
- Arkansas 42,996
- Puerto Rico 41,728
- Wisconsin 40,873
- Florida 39,014
- Pennsylvania 38,304
- Alabama 38,175
- Louisiana 37,187
- Colorado 36,023
- South Dakota 35,626
- California 33,454
- New York 33,454
- West Virginia 30,688
- North Dakota 29,105
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819641 | 1819641 | 2021-10-15 | Prince William | Virginia | 51153 | 54059 | 549 |
1819642 | 1819642 | 2021-10-15 | Pulaski | Virginia | 51155 | 3980 | 81 |
1819643 | 1819643 | 2021-10-15 | Radford city | Virginia | 51750 | 2856 | 31 |
1819644 | 1819644 | 2021-10-15 | Rappahannock | Virginia | 51157 | 559 | 4 |
1819645 | 1819645 | 2021-10-15 | Richmond | Virginia | 51159 | 1707 | 12 |
1819646 | 1819646 | 2021-10-15 | Richmond city | Virginia | 51760 | 23458 | 333 |
1819647 | 1819647 | 2021-10-15 | Roanoke | Virginia | 51161 | 11520 | 162 |
1819648 | 1819648 | 2021-10-15 | Roanoke city | Virginia | 51770 | 11795 | 231 |
1819649 | 1819649 | 2021-10-15 | Rockbridge | Virginia | 51163 | 2042 | 57 |
1819650 | 1819650 | 2021-10-15 | Rockingham | Virginia | 51165 | 9147 | 146 |
1819651 | 1819651 | 2021-10-15 | Russell | Virginia | 51167 | 3655 | 58 |
1819652 | 1819652 | 2021-10-15 | Salem city | Virginia | 51775 | 3340 | 57 |
1819653 | 1819653 | 2021-10-15 | Scott | Virginia | 51169 | 2991 | 75 |
1819654 | 1819654 | 2021-10-15 | Shenandoah | Virginia | 51171 | 6184 | 154 |
1819655 | 1819655 | 2021-10-15 | Smyth | Virginia | 51173 | 4678 | 110 |
1819656 | 1819656 | 2021-10-15 | Southampton | Virginia | 51175 | 2360 | 63 |
1819657 | 1819657 | 2021-10-15 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1819658 | 1819658 | 2021-10-15 | Stafford | Virginia | 51179 | 15574 | 103 |
1819659 | 1819659 | 2021-10-15 | Staunton city | Virginia | 51790 | 3322 | 81 |
1819660 | 1819660 | 2021-10-15 | Suffolk city | Virginia | 51800 | 10700 | 224 |
1819661 | 1819661 | 2021-10-15 | Surry | Virginia | 51181 | 595 | 10 |
1819662 | 1819662 | 2021-10-15 | Sussex | Virginia | 51183 | 1536 | 26 |
1819663 | 1819663 | 2021-10-15 | Tazewell | Virginia | 51185 | 5551 | 95 |
1819664 | 1819664 | 2021-10-15 | Virginia Beach city | Virginia | 51810 | 48959 | 526 |
1819665 | 1819665 | 2021-10-15 | Warren | Virginia | 51187 | 4807 | 79 |
1819666 | 1819666 | 2021-10-15 | Washington | Virginia | 51191 | 7355 | 140 |
1819667 | 1819667 | 2021-10-15 | Waynesboro city | Virginia | 51820 | 3551 | 44 |
1819668 | 1819668 | 2021-10-15 | Westmoreland | Virginia | 51193 | 1780 | 31 |
1819669 | 1819669 | 2021-10-15 | Williamsburg city | Virginia | 51830 | 1125 | 14 |
1819670 | 1819670 | 2021-10-15 | Winchester city | Virginia | 51840 | 3656 | 53 |
1819671 | 1819671 | 2021-10-15 | Wise | Virginia | 51195 | 5047 | 123 |
1819672 | 1819672 | 2021-10-15 | Wythe | Virginia | 51197 | 4347 | 93 |
1819673 | 1819673 | 2021-10-15 | York | Virginia | 51199 | 5325 | 73 |
1819674 | 1819674 | 2021-10-15 | Adams | Washington | 53001 | 3156 | 29 |
1819675 | 1819675 | 2021-10-15 | Asotin | Washington | 53003 | 2688 | 48 |
1819676 | 1819676 | 2021-10-15 | Benton | Washington | 53005 | 30532 | 360 |
1819677 | 1819677 | 2021-10-15 | Chelan | Washington | 53007 | 10959 | 102 |
1819678 | 1819678 | 2021-10-15 | Clallam | Washington | 53009 | 4532 | 52 |
1819679 | 1819679 | 2021-10-15 | Clark | Washington | 53011 | 39759 | 461 |
1819680 | 1819680 | 2021-10-15 | Columbia | Washington | 53013 | 352 | 8 |
1819681 | 1819681 | 2021-10-15 | Cowlitz | Washington | 53015 | 12921 | 222 |
1819682 | 1819682 | 2021-10-15 | Douglas | Washington | 53017 | 5939 | 38 |
1819683 | 1819683 | 2021-10-15 | Ferry | Washington | 53019 | 752 | 13 |
1819684 | 1819684 | 2021-10-15 | Franklin | Washington | 53021 | 19811 | 178 |
1819685 | 1819685 | 2021-10-15 | Garfield | Washington | 53023 | 239 | 7 |
1819686 | 1819686 | 2021-10-15 | Grant | Washington | 53025 | 16569 | 184 |
1819687 | 1819687 | 2021-10-15 | Grays Harbor | Washington | 53027 | 8301 | 119 |
1819688 | 1819688 | 2021-10-15 | Island | Washington | 53029 | 3740 | 44 |
1819689 | 1819689 | 2021-10-15 | Jefferson | Washington | 53031 | 1021 | 16 |
1819690 | 1819690 | 2021-10-15 | King | Washington | 53033 | 158595 | 1944 |
1819691 | 1819691 | 2021-10-15 | Kitsap | Washington | 53035 | 16097 | 215 |
1819692 | 1819692 | 2021-10-15 | Kittitas | Washington | 53037 | 4813 | 53 |
1819693 | 1819693 | 2021-10-15 | Klickitat | Washington | 53039 | 1860 | 18 |
1819694 | 1819694 | 2021-10-15 | Lewis | Washington | 53041 | 9621 | 144 |
1819695 | 1819695 | 2021-10-15 | Lincoln | Washington | 53043 | 1316 | 19 |
1819696 | 1819696 | 2021-10-15 | Mason | Washington | 53045 | 5512 | 65 |
1819697 | 1819697 | 2021-10-15 | Okanogan | Washington | 53047 | 4910 | 73 |
1819698 | 1819698 | 2021-10-15 | Pacific | Washington | 53049 | 1755 | 28 |
1819699 | 1819699 | 2021-10-15 | Pend Oreille | Washington | 53051 | 1465 | 20 |
1819700 | 1819700 | 2021-10-15 | Pierce | Washington | 53053 | 88568 | 846 |
1819701 | 1819701 | 2021-10-15 | San Juan | Washington | 53055 | 322 | 0 |
1819702 | 1819702 | 2021-10-15 | Skagit | Washington | 53057 | 10334 | 105 |
1819703 | 1819703 | 2021-10-15 | Skamania | Washington | 53059 | 715 | 6 |
1819704 | 1819704 | 2021-10-15 | Snohomish | Washington | 53061 | 62200 | 731 |
1819705 | 1819705 | 2021-10-15 | Spokane | Washington | 53063 | 69661 | 956 |
1819706 | 1819706 | 2021-10-15 | Stevens | Washington | 53065 | 4753 | 80 |
1819707 | 1819707 | 2021-10-15 | Thurston | Washington | 53067 | 19516 | 216 |
1819708 | 1819708 | 2021-10-15 | Wahkiakum | Washington | 53069 | 271 | 5 |
1819709 | 1819709 | 2021-10-15 | Walla Walla | Washington | 53071 | 8707 | 99 |
1819710 | 1819710 | 2021-10-15 | Whatcom | Washington | 53073 | 15570 | 152 |
1819711 | 1819711 | 2021-10-15 | Whitman | Washington | 53075 | 5706 | 68 |
1819712 | 1819712 | 2021-10-15 | Yakima | Washington | 53077 | 43824 | 571 |
1819713 | 1819713 | 2021-10-15 | Barbour | West Virginia | 54001 | 2573 | 43 |
1819714 | 1819714 | 2021-10-15 | Berkeley | West Virginia | 54003 | 17810 | 173 |
1819715 | 1819715 | 2021-10-15 | Boone | West Virginia | 54005 | 3392 | 51 |
1819716 | 1819716 | 2021-10-15 | Braxton | West Virginia | 54007 | 2050 | 15 |
1819717 | 1819717 | 2021-10-15 | Brooke | West Virginia | 54009 | 2979 | 69 |
1819718 | 1819718 | 2021-10-15 | Cabell | West Virginia | 54011 | 14423 | 253 |
1819719 | 1819719 | 2021-10-15 | Calhoun | West Virginia | 54013 | 872 | 4 |
1819720 | 1819720 | 2021-10-15 | Clay | West Virginia | 54015 | 1161 | 17 |
1819721 | 1819721 | 2021-10-15 | Doddridge | West Virginia | 54017 | 1171 | 10 |
1819722 | 1819722 | 2021-10-15 | Fayette | West Virginia | 54019 | 5888 | 114 |
1819723 | 1819723 | 2021-10-15 | Gilmer | West Virginia | 54021 | 1308 | 9 |
1819724 | 1819724 | 2021-10-15 | Grant | West Virginia | 54023 | 2076 | 32 |
1819725 | 1819725 | 2021-10-15 | Greenbrier | West Virginia | 54025 | 4730 | 88 |
1819726 | 1819726 | 2021-10-15 | Hampshire | West Virginia | 54027 | 3047 | 47 |
1819727 | 1819727 | 2021-10-15 | Hancock | West Virginia | 54029 | 4023 | 108 |
1819728 | 1819728 | 2021-10-15 | Hardy | West Virginia | 54031 | 2312 | 28 |
1819729 | 1819729 | 2021-10-15 | Harrison | West Virginia | 54033 | 10612 | 136 |
1819730 | 1819730 | 2021-10-15 | Jackson | West Virginia | 54035 | 3774 | 79 |
1819731 | 1819731 | 2021-10-15 | Jefferson | West Virginia | 54037 | 6613 | 80 |
1819732 | 1819732 | 2021-10-15 | Kanawha | West Virginia | 54039 | 23560 | 449 |
1819733 | 1819733 | 2021-10-15 | Lewis | West Virginia | 54041 | 2909 | 46 |
1819734 | 1819734 | 2021-10-15 | Lincoln | West Virginia | 54043 | 2660 | 42 |
1819735 | 1819735 | 2021-10-15 | Logan | West Virginia | 54045 | 5162 | 130 |
1819736 | 1819736 | 2021-10-15 | Marion | West Virginia | 54049 | 7659 | 96 |
1819737 | 1819737 | 2021-10-15 | Marshall | West Virginia | 54051 | 5167 | 106 |
1819738 | 1819738 | 2021-10-15 | Mason | West Virginia | 54053 | 3518 | 51 |
1819739 | 1819739 | 2021-10-15 | McDowell | West Virginia | 54047 | 2821 | 44 |
1819740 | 1819740 | 2021-10-15 | Mercer | West Virginia | 54055 | 8389 | 174 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);