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 192,244
- Georgia 124,089
- Virginia 102,521
- Kentucky 91,972
- Missouri 89,015
- Illinois 78,987
- Kansas 78,764
- North Carolina 77,309
- Iowa 76,570
- Tennessee 74,239
- Indiana 71,456
- Nebraska 68,785
- Ohio 68,656
- Minnesota 67,443
- Michigan 64,782
- Mississippi 63,733
- Oklahoma 59,533
- Arkansas 58,652
- Puerto Rico 58,002
- Wisconsin 55,705
- Florida 53,022
- Pennsylvania 52,106
- Alabama 51,977
- Louisiana 50,577
- South Dakota 49,222
- Colorado 49,207
- California 45,403
- New York 45,402
- West Virginia 42,018
- Montana 40,376
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489553 | 2489553 | 2022-05-09 | Manassas Park city | Virginia | 51685 | 3809 | 27 |
2489554 | 2489554 | 2022-05-09 | Manassas city | Virginia | 51683 | 9237 | 71 |
2489555 | 2489555 | 2022-05-09 | Martinsville city | Virginia | 51690 | 3464 | 124 |
2489556 | 2489556 | 2022-05-09 | Mathews | Virginia | 51115 | 1521 | 27 |
2489557 | 2489557 | 2022-05-09 | Mecklenburg | Virginia | 51117 | 6192 | 122 |
2489558 | 2489558 | 2022-05-09 | Middlesex | Virginia | 51119 | 1861 | 48 |
2489559 | 2489559 | 2022-05-09 | Montgomery | Virginia | 51121 | 19220 | 153 |
2489560 | 2489560 | 2022-05-09 | Nelson | Virginia | 51125 | 2572 | 35 |
2489561 | 2489561 | 2022-05-09 | New Kent | Virginia | 51127 | 4707 | 31 |
2489562 | 2489562 | 2022-05-09 | Newport News city | Virginia | 51700 | 36939 | 403 |
2489563 | 2489563 | 2022-05-09 | Norfolk city | Virginia | 51710 | 42945 | 475 |
2489564 | 2489564 | 2022-05-09 | Northampton | Virginia | 51131 | 2181 | 64 |
2489565 | 2489565 | 2022-05-09 | Northumberland | Virginia | 51133 | 2206 | 46 |
2489566 | 2489566 | 2022-05-09 | Norton city | Virginia | 51720 | 1305 | 22 |
2489567 | 2489567 | 2022-05-09 | Nottoway | Virginia | 51135 | 4289 | 92 |
2489568 | 2489568 | 2022-05-09 | Orange | Virginia | 51137 | 6888 | 86 |
2489569 | 2489569 | 2022-05-09 | Page | Virginia | 51139 | 5643 | 121 |
2489570 | 2489570 | 2022-05-09 | Patrick | Virginia | 51141 | 3696 | 98 |
2489571 | 2489571 | 2022-05-09 | Petersburg city | Virginia | 51730 | 8291 | 140 |
2489572 | 2489572 | 2022-05-09 | Pittsylvania | Virginia | 51143 | 14231 | 199 |
2489573 | 2489573 | 2022-05-09 | Poquoson city | Virginia | 51735 | 2382 | 30 |
2489574 | 2489574 | 2022-05-09 | Portsmouth city | Virginia | 51740 | 21087 | 337 |
2489575 | 2489575 | 2022-05-09 | Powhatan | Virginia | 51145 | 5234 | 59 |
2489576 | 2489576 | 2022-05-09 | Prince Edward | Virginia | 51147 | 5094 | 70 |
2489577 | 2489577 | 2022-05-09 | Prince George | Virginia | 51149 | 8871 | 77 |
2489578 | 2489578 | 2022-05-09 | Prince William | Virginia | 51153 | 97324 | 747 |
2489579 | 2489579 | 2022-05-09 | Pulaski | Virginia | 51155 | 7304 | 138 |
2489580 | 2489580 | 2022-05-09 | Radford city | Virginia | 51750 | 4982 | 53 |
2489581 | 2489581 | 2022-05-09 | Rappahannock | Virginia | 51157 | 1047 | 10 |
2489582 | 2489582 | 2022-05-09 | Richmond | Virginia | 51159 | 2587 | 25 |
2489583 | 2489583 | 2022-05-09 | Richmond city | Virginia | 51760 | 45908 | 512 |
2489584 | 2489584 | 2022-05-09 | Roanoke | Virginia | 51161 | 21476 | 281 |
2489585 | 2489585 | 2022-05-09 | Roanoke city | Virginia | 51770 | 21560 | 375 |
2489586 | 2489586 | 2022-05-09 | Rockbridge | Virginia | 51163 | 3298 | 79 |
2489587 | 2489587 | 2022-05-09 | Rockingham | Virginia | 51165 | 14612 | 229 |
2489588 | 2489588 | 2022-05-09 | Russell | Virginia | 51167 | 6860 | 114 |
2489589 | 2489589 | 2022-05-09 | Salem city | Virginia | 51775 | 5737 | 97 |
2489590 | 2489590 | 2022-05-09 | Scott | Virginia | 51169 | 5839 | 111 |
2489591 | 2489591 | 2022-05-09 | Shenandoah | Virginia | 51171 | 10907 | 222 |
2489592 | 2489592 | 2022-05-09 | Smyth | Virginia | 51173 | 8876 | 171 |
2489593 | 2489593 | 2022-05-09 | Southampton | Virginia | 51175 | 3437 | 93 |
2489594 | 2489594 | 2022-05-09 | Spotsylvania | Virginia | 51177 | 27514 | 301 |
2489595 | 2489595 | 2022-05-09 | Stafford | Virginia | 51179 | 31048 | 177 |
2489596 | 2489596 | 2022-05-09 | Staunton city | Virginia | 51790 | 5670 | 115 |
2489597 | 2489597 | 2022-05-09 | Suffolk city | Virginia | 51800 | 19022 | 302 |
2489598 | 2489598 | 2022-05-09 | Surry | Virginia | 51181 | 1104 | 20 |
2489599 | 2489599 | 2022-05-09 | Sussex | Virginia | 51183 | 2411 | 42 |
2489600 | 2489600 | 2022-05-09 | Tazewell | Virginia | 51185 | 10302 | 175 |
2489601 | 2489601 | 2022-05-09 | Virginia Beach city | Virginia | 51810 | 91047 | 824 |
2489602 | 2489602 | 2022-05-09 | Warren | Virginia | 51187 | 8649 | 156 |
2489603 | 2489603 | 2022-05-09 | Washington | Virginia | 51191 | 13895 | 215 |
2489604 | 2489604 | 2022-05-09 | Waynesboro city | Virginia | 51820 | 6014 | 69 |
2489605 | 2489605 | 2022-05-09 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2489606 | 2489606 | 2022-05-09 | Williamsburg city | Virginia | 51830 | 1816 | 22 |
2489607 | 2489607 | 2022-05-09 | Winchester city | Virginia | 51840 | 6414 | 81 |
2489608 | 2489608 | 2022-05-09 | Wise | Virginia | 51195 | 10294 | 199 |
2489609 | 2489609 | 2022-05-09 | Wythe | Virginia | 51197 | 7536 | 149 |
2489610 | 2489610 | 2022-05-09 | York | Virginia | 51199 | 10091 | 109 |
2489611 | 2489611 | 2022-05-09 | Adams | Washington | 53001 | 4921 | 38 |
2489612 | 2489612 | 2022-05-09 | Asotin | Washington | 53003 | 4542 | 66 |
2489613 | 2489613 | 2022-05-09 | Benton | Washington | 53005 | 52896 | 470 |
2489614 | 2489614 | 2022-05-09 | Chelan | Washington | 53007 | 20367 | 162 |
2489615 | 2489615 | 2022-05-09 | Clallam | Washington | 53009 | 11747 | 140 |
2489616 | 2489616 | 2022-05-09 | Clark | Washington | 53011 | 90793 | 800 |
2489617 | 2489617 | 2022-05-09 | Columbia | Washington | 53013 | 612 | 16 |
2489618 | 2489618 | 2022-05-09 | Cowlitz | Washington | 53015 | 23209 | 347 |
2489619 | 2489619 | 2022-05-09 | Douglas | Washington | 53017 | 11209 | 70 |
2489620 | 2489620 | 2022-05-09 | Ferry | Washington | 53019 | 1419 | 29 |
2489621 | 2489621 | 2022-05-09 | Franklin | Washington | 53021 | 32645 | 214 |
2489622 | 2489622 | 2022-05-09 | Garfield | Washington | 53023 | 389 | 7 |
2489623 | 2489623 | 2022-05-09 | Grant | Washington | 53025 | 27146 | 259 |
2489624 | 2489624 | 2022-05-09 | Grays Harbor | Washington | 53027 | 16546 | 198 |
2489625 | 2489625 | 2022-05-09 | Island | Washington | 53029 | 10525 | 76 |
2489626 | 2489626 | 2022-05-09 | Jefferson | Washington | 53031 | 3159 | 28 |
2489627 | 2489627 | 2022-05-09 | King | Washington | 53033 | 405165 | 2757 |
2489628 | 2489628 | 2022-05-09 | Kitsap | Washington | 53035 | 41135 | 340 |
2489629 | 2489629 | 2022-05-09 | Kittitas | Washington | 53037 | 8580 | 66 |
2489630 | 2489630 | 2022-05-09 | Klickitat | Washington | 53039 | 3569 | 45 |
2489631 | 2489631 | 2022-05-09 | Lewis | Washington | 53041 | 17732 | 252 |
2489632 | 2489632 | 2022-05-09 | Lincoln | Washington | 53043 | 2217 | 28 |
2489633 | 2489633 | 2022-05-09 | Mason | Washington | 53045 | 12575 | 139 |
2489634 | 2489634 | 2022-05-09 | Okanogan | Washington | 53047 | 8655 | 123 |
2489635 | 2489635 | 2022-05-09 | Pacific | Washington | 53049 | 3785 | 57 |
2489636 | 2489636 | 2022-05-09 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2489637 | 2489637 | 2022-05-09 | Pierce | Washington | 53053 | 197193 | 1400 |
2489638 | 2489638 | 2022-05-09 | San Juan | Washington | 53055 | 1372 | 2 |
2489639 | 2489639 | 2022-05-09 | Skagit | Washington | 53057 | 22627 | 204 |
2489640 | 2489640 | 2022-05-09 | Skamania | Washington | 53059 | 1523 | 13 |
2489641 | 2489641 | 2022-05-09 | Snohomish | Washington | 53061 | 157745 | 1144 |
2489642 | 2489642 | 2022-05-09 | Spokane | Washington | 53063 | 125788 | 1374 |
2489643 | 2489643 | 2022-05-09 | Stevens | Washington | 53065 | 8248 | 146 |
2489644 | 2489644 | 2022-05-09 | Thurston | Washington | 53067 | 48689 | 416 |
2489645 | 2489645 | 2022-05-09 | Unknown | Washington | 3265 | 0 | |
2489646 | 2489646 | 2022-05-09 | Wahkiakum | Washington | 53069 | 537 | 7 |
2489647 | 2489647 | 2022-05-09 | Walla Walla | Washington | 53071 | 16242 | 141 |
2489648 | 2489648 | 2022-05-09 | Whatcom | Washington | 53073 | 39030 | 300 |
2489649 | 2489649 | 2022-05-09 | Whitman | Washington | 53075 | 8779 | 90 |
2489650 | 2489650 | 2022-05-09 | Yakima | Washington | 53077 | 73738 | 789 |
2489651 | 2489651 | 2022-05-09 | Barbour | West Virginia | 54001 | 4829 | 73 |
2489652 | 2489652 | 2022-05-09 | Berkeley | West Virginia | 54003 | 36107 | 294 |
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);